The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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
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