Closed

Seattle preferred: C# or VB work (or similar) needed

This project received 18 bids from talented freelancers with an average bid price of $3458 USD.

Get free quotes for a project like this
Employer working
Project Budget
$3000 - $5000 USD
Total Bids
18
Project Description

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.

Thanks
Dwight

p.s. see the attached samples. They are not identical to the actual input files but very similar.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online