Ideally you are local to the Greater Seattle metro area, as our office is located in downtown Seattle. It's possible to do this work remotely, but the folks in our Finance dept would prefer to meet in person.
We need an automated mechanism (e.g. Excel macros or VBA) to take customer-provided spreadsheets, MS Word Docs and PDFs (we have hundreds of them, some with many hundreds of tabs), most with identical column names and column order and transfer the data into a single, consolidated spreadsheet (also with a fixed column definition but in many cases the column names of the consolidated spreadsheet are different than those of the customer spreadsheets).
Not all the rows from the customer spreadsheets move into the consolidated spreadsheet. Data in each row will trigger the move (i.e. Publisher = ABC or Publisher = ABC Publishing). Also only certain input columns move over.
Also, sometimes we have to do a lookup against a SQL Server db to determine if the data in a given row should move. (i.e. if this item ID exists in our database, then move the row into the consolidated spreadsheet).This database is accessible via web service calls.
We have no preference of programming language but the final app will should run on a desktop PC and be easy to install.
We'd like to complete this project by the end of May.
p.s. see the attached samples. They are not identical to the actual input files but very similar.
You must be local to Seattle Washington to be considered for this project as we need onsite consultation.
17 freelancers are bidding on average $3456 for this job
Hi! I worked with databases 10 years and worked with many languages (c#, delphi, assmebler, vb etc...).. I will make it in 10-20 days... if you check me, then we must talk about details..
Hello,If you don't find local guy,we are glad to do this task for you with our programming gurus. Customer satisfation on top of accuracey is @ the heart of everything we do,best regards,Tareq
Hi, I have implemented a similar kind of project having few features similar to the one you are having in your project. Please check my PM for more details.