176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Excel Automation (parser)
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Feb 15, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Jan 29, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Goal:
Automate a multi-step process of combining several workbooks into one spreadsheet based on locations.

Raw data comes in the form of 3 spreadsheets, each in a csv
• BMR
• CASS
• NCOA
Data in each spreadsheet could contain between 1 to 1,000 line items. The location name is contained in each of these reports.

The data from each of the above spreadsheets needs to be merged then separated by location as well as drilled down to either clinic (singular) or billing company (multiple). The master lists for all locations are housed in another spreadsheet. The process will result in the data for a particular 'location' to be extrapolated and then placed into one spreadsheet with the tabs representing BMR/CASS/NCOA. The final product will be saved as xls or similar for easy reading.

Current challenges that need to be accounted for: names on the 3 individual files sometimes will not match the name on the 'location' list exactly, for instance: space could be before the name when it wasn...

Sign in or Register to see more

Desired Skills
PHP, VBA, XML
Job ID: 37329742
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Russia  |  
Expert in VBA-automating MS Excel, Word, Access. More 10 years experience in programming. Complex and non-typical works are welcomed!
4
  |  
 5.0   |  Private   |  7 Jobs
Bid ID: 37695526  |  Submitted: Feb 9, 2013 09:55 ET 
Proposal SEALED

 Netherlands  |  
Winner
Expert on Excel, Word and Acces VBA. Created various applications in all programs. I have experience in other programming languages as well, such...
1
  |  
 0.0   |  $0 Earnings   |  1 Jobs
Bid ID: 37642845  |  Submitted: Feb 7, 2013 16:22 ET 
Delivery
Within 1 month
$109.59

 Croatia (Hrvatska)  |  
Experienced developer and system architect with lots of integration & workflow automation projects behind - from simple Office automation (VBA) to...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37577895  |  Submitted: Feb 6, 2013 05:06 ET 
Proposal SEALED

 Slovak Republic  |  
Data processing, VBA automation, SQL, WSH... MS Office Excel macros. OpenOffice BASIC. Turn your data into information, automate your daily routines.
5
  |  
 5.0   |  Private   |  15 Jobs
Bid ID: 37562650  |  Submitted: Feb 5, 2013 19:02 ET 
Proposal SEALED

Sowmya Narayan V.      
Sowmya Narayan V.'s identity has been verified.  Learn More
 India
Excel with Formulas/VBA developer since 6 yrs. MS ACCESS ,SQL Developer Internet Explorer Automation using VBA .Good experience in SQL using...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37553354  |  Submitted: Feb 5, 2013 13:33 ET 
Proposal SEALED

 United Kingdom  |  
I have been a Management Accountant for 20 years with very strong Excel skills, but I also have a passion for graphic design.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37552791  |  Submitted: Feb 5, 2013 13:20 ET 
Proposal SEALED

Fabrice Tayou      
Fabrice Tayou's identity has been verified.  Learn More
 Cameroon  |  
.NET: VB, C#, Batch: AutoIt3, DOS, VBS, Solution package: NSIS, Visual Studio, MS Office, IT Graphics resources, Custom Software.
10
  |  
 4.9   |  Private   |  6 Jobs
Bid ID: 37415655  |  Submitted: Feb 1, 2013 05:21 ET 
Proposal SEALED

Mark T.      
Mark T.'s identity has been verified.  Learn More
 Thailand  |  
Over 20 years experience in Relational Database Design (IBM DB2, MySQL, postgreSQL, MS SQLServer, MS Access and many more ....). using PHP5, Java,...
5
  |  
 5.0   |  Private   |  3 Jobs
Bid ID: 37414244  |  Submitted: Feb 1, 2013 04:30 ET 
Proposal SEALED

 Poland  |  
I am an experienced Excel VBA developer, as well as a business consultant. I create advanced Excel-based tools for SMEs and large corporations. I...
11
  |  
 5.0   |  Private   |  65 Jobs
Bid ID: 37380231  |  Submitted: Jan 31, 2013 05:45 ET 
Proposal SEALED

 United States
For the past fifteen years my primary focus has been spreadsheet development, initially with the Lotus 123 macro language, and for the past decade...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37356831  |  Submitted: Jan 30, 2013 13:35 ET 
Proposal SEALED

 Egypt  |  
Feel free to contact me regarding any help about MS Excel. I have a very good overall knowledge of Excel, and can assist on most matters. I worked...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37354438  |  Submitted: Jan 30, 2013 12:26 ET 
Proposal SEALED

 United States  |  
Fueled by 19 years of extensive financial and analytical experience across numerous industries, projects including spreadsheets, data mining,...
3
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37348821  |  Submitted: Jan 30, 2013 09:28 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »