Em Andamento

Spreadsheet Combination

Needed, a program to compare two spreadsheets and output the result to a third

I have a spreadsheet from my supplier that shows all their product current prices and stock levels. I have a spreadsheet that shows all my active items on eBay. I need to know which items on my active items spreadsheet that have changed prices or are out of stock. I need to do this for several different suppliers with slightly different spreadsheets.

I also need to have a list of new supplier products for consideration as new items that I might carry but not any that I have already decided to not carry. The key for all this would be the supplier part number that appears in all spreadsheets. This would also pick up any items that were out of stock but now are again available.

Here’s how I want it to work

1. I download “xxx Supplier’s Spreadsheet??

2. The program compares this spreadsheet to my “Rejected Item Spreadsheet?? (This is a spreadsheet that I make up has all the items I have already decided to not sell from this supplier)

3. The result is the “Current Supplier Item Spreadsheet??

4. The “Zero Stock Items Spreadsheet ?? is compared by the program to the “Current Supplier Item Spreadsheet

5. Items still out of stock are ignored but those now in stock are sent to the “FileExchange Upload Spreadsheet?? and removed from the “Zero Stock Item Spreadsheet?? and the “Current Supplier Item Spreadsheet??

6. I download the “Actives Spreadsheet?? from eBay

7. The program compares the “Current Supplier Spreadsheet?? to the Actives Spreadsheet?? and outputs zero stock items and price change items with the new price to the “FileExchange Upload Spreadsheet?? and a “New Item Spreadsheet??

The zero stock items are also sent to the “Zero Stock Spreadsheet"

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Internet Explorer, Windows XP, Microsoft Office Excel .csv and .xls, & Visual Basic.

Habilidades: PHP

Ver mais: visual basic price, spreadsheet web form, sell excel spreadsheets, part of microsoft excel 2007, microsoft office package, microsoft spreadsheets, microsoft excel price, do i need microsoft office, csv spreadsheet, zero bid price, spreadsheet 2, i need to upload product to ebay, compare spreadsheet, spreadsheet price list, compare exist, spreadsheet csv, combination program visual basic, sell source code windows, xls visual basic, list combination excel, excel spreadsheet source code, excel stock download, microsoft office windows ebay, upload spreadsheet ebay, microsoft price list

Acerca do Empregador:
( 2 comentários ) United States

ID do Projeto: #3019044

Premiar a:

stsolhouse

See private message.

$85.85 USD em 348 dias
(23 Avaliações)
5.3

40 freelancers estão ofertando em média $252 para este trabalho

inetprograms

See private message.

$425 USD in 348 dias
(154 Comentários)
8.0
illuminesoft

See private message.

$335.75 USD in 348 dias
(364 Comentários)
7.7
pShankar2

See private message.

$297.5 USD in 348 dias
(409 Comentários)
7.1
brsofts

See private message.

$297.5 USD in 348 dias
(274 Comentários)
6.6
suthernsoftware

See private message.

$133.45 USD in 348 dias
(62 Comentários)
6.6
deepbluetech

See private message.

$255 USD in 348 dias
(190 Comentários)
6.1
unimaxsystems

See private message.

$335.75 USD in 348 dias
(179 Comentários)
6.0
imarzouka

See private message.

$255 USD in 348 dias
(85 Comentários)
5.9
vnb400sl

See private message.

$212.5 USD in 348 dias
(130 Comentários)
5.9
jawadh

See private message.

$169.15 USD in 348 dias
(83 Comentários)
6.0
techzonevw

See private message.

$425 USD in 348 dias
(156 Comentários)
5.8
pixvista

See private message.

$382.5 USD in 348 dias
(30 Comentários)
5.6
pikessoft

See private message.

$127.5 USD in 348 dias
(79 Comentários)
5.5
somireddy

See private message.

$85 USD in 348 dias
(75 Comentários)
5.4
jlsproject

See private message.

$425 USD in 348 dias
(38 Comentários)
5.0
projexpertvw

See private message.

$425 USD in 348 dias
(20 Comentários)
4.8
vw2244935vw

See private message.

$119 USD in 348 dias
(39 Comentários)
4.5
edgabriel

See private message.

$212.5 USD in 348 dias
(14 Comentários)
4.4
salamandravw

See private message.

$221 USD in 348 dias
(29 Comentários)
3.9
ekandeel

See private message.

$85 USD in 348 dias
(17 Comentários)
4.0