Seattle preferred: C# or VB work (or similar) needed
- Status Closed
- Budget $3000 - $5000 USD
- Total Bids 18
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.Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online