Write a stock comparison tool

I need to write a desktop application that takes two excel files as input and compares both files are returns the difference.

The first file is the original stock file, that includes item code, barcode, quantity and expiry and the second file is the stocktake file received from the stocktake machine that includes barcode, quantity and expiry. The application needs to look at the new file and finds rows with same barcode and same expiry and merge it and add the quantities. For example, if there exist two rows with barcode 1234 and expiry 01/2018 with first having a quantity of 1 and the second as 2, it needs to merge into a single line with barcode 1234, expiry 01/2018 and quantity 3.

The application needs to return the following:

Quantity differences based on barcode+expiry

Items in original file that didn't exist in the new file

Items in the new file that dont exist in the first file

Items in the old file with no barcodes

Habilidades: .NET, VB.NET

Veja mais: Sub-strings of a DNA sequence having length k are called k-mers. For example, the k-mers of length 4 (k = 4) of the sequence, i am a led bulb sale i want to look for led bulb buyer where can i look for, stock write, functional test automation tool comparison, comparison stock market vsgdp, automation testing tool comparison, automated tool comparison, jboss tool web services eclipse tutorial example, testing tool comparison, stock write sample, testing automation tool comparison, write program will generate single digit integers, write emailsletters example, test automation tool comparison, tinymce write php example, stock backtesting software comparison, automation tool comparison, write stock market, stock chart flex example, stock project page write

Acerca do Empregador:
( 10 comentários ) rockdale, Australia

ID do Projeto: #13775395

Concedido a:


I've done the project and have a sample version available but can't see how to attach it to this bid so I've put in up on one of my web sites for you to download if you care to [login to view URL] Mais

$30 USD em 2 dias
(1 Comentário)

3 freelancers estão ofertando em média $28 para esse trabalho

$30 USD em 1 dia
(6 Comentários)

Comparing 2 Excel Files will be Slow The Best Idea is to Submit data from file1 into a table1 in an Access database and file2 into table2 and then you can get all Queries you want veryyyyy faaaaast and i can Mais

$25 USD em 1 dia
(0 Comentários)