Automated Data Manipulation (Excel Macro)

Status: Closed
Prize: $300
Entries Received: 9
Winner: mrbrave

Winner

Contest Brief

We need an Excel Macro made: Goal: Automate a process to take information from a source file and output it in the format provided in the outsource file.
Included: Four .xlxs files, as follows:
TRIADTESTSOURCE.xlxs
TRIADTESTOUTPUT.xlxs
TRIADTESTDATAMAP.xlxs
TRIADTESTPRICELIST.xlxs
Take the attached TRIADTESTSOURCE.xlxs) and manipulate it into the TRIADTESTOUTPUT.xlxs file using the TRIADTESTDATAMAP.xlxs and the TRIADTESTPRICELIST.xlxs.
The Data Map is your key to where the source information belongs in the output file.
The Price List is your key to getting the charges and the descriptions relevant to each medical CPT code in the source file.
The CPT Codes are 5 digit codes. There may be more than one CPT code on any given row. Each CPT code needs its own row so the corresponding charge/description will be on its own line. Additionally, the credit will need to be on its own line as well. So, at minimum, each row in the source file will have two rows in the output file (charge, and credit).
We receive source files like the one in this project that need to be manipulated this way every time. The amount of information in the file varies. So, this process needs to be able to work no matter how many rows of data are in the source file.
The winner of the contest will the the contestant that provides the stipulated output, exactly as requested, the quickest.
The winner of the contest will receive $300 with potential for steady contract work on future projects.

Recommended Skills

Winner

Post a Contest Like This

Public Clarification Board

Edison1983
- 11 years ago
Kindly confirm if i can submit my entry. And give me an hour time. I can give you the required details. You can message me too.
- 11 years ago
1. Contest Holder
  - 11 years ago
  I will accept your submission for review! Thank you!
  - 11 years ago
2. Contest Holder
  - 11 years ago
  Message me if you would still like to submit.
  - 11 years ago
CloverCloud
- 11 years ago
I can still submit my entry?
- 11 years ago
1. Contest Holder
  - 11 years ago
  Message me if you are still interested in submitting an entry
  - 11 years ago
rajivck13
- 11 years ago
Hi, pls confirm whether I can still submit my entry as I am working on the same.
- 11 years ago
babumuth
- 11 years ago
Hi, can you pls confirm whether I can still submit my entry as I am working on the same.
- 11 years ago
Contest Holder
- 11 years ago
The project was a contest, also a search for contractors for this type of work in the future. We were looking for speed & accuracy with minimal questions required for completion. It has proven to be successful since we have essentially received 2 winners of this contest.
- 11 years ago
View 2 more messages
1. BDtW
  - 11 years ago
  Thank you for the clarification. I am uploading my project for your kind consideration. With thanks & best regards.
  - 11 years ago
2. fabest
  - 11 years ago
  Hello Samara, Waiting for your feedback about my solution.
  - 11 years ago
Edison1983
- 11 years ago
Hi Samara, Is this contenst over. I'm skilled in Excel Programming.
- 11 years ago
zExcel
- 11 years ago
I don't think this project should be posted as a contest. I'll be happy to sunmit a competetive bid for this work
- 11 years ago
pranshua1
- 11 years ago
For Column AT in the output file, if the CPT code is given twice in the PRICELIST File then which description is to be considered. For example check CPT code 11440.
- 11 years ago
pranshua1
- 11 years ago
What will be the format of Column C when it contains the middle name as well. Please provide an example. Secondly, In column D can you please explain how D4 will get populated in the output file?
- 11 years ago
pranshua1
- 11 years ago
Hi, can you please explain column C and Column D in the source file. My doubt is-
- 11 years ago