Convert Data file with Excel or web script

I need a developer who can pay attention to detail. If you submit a general proposal and did not read this project description fully, you will not be considered.

Project is to come up with a solution to convert a data file. There are two ways you can do this:

1. Through an excel vba script. This is the preffered way

2. A hosted web page with database to execute the script and then download new output file.

Attached are two files:

1. [url removed, login to view] (final output file)

2. [url removed, login to view] (initial data file)

If it is to be done in excel, I need to be able to run the script/macro on new files that are setup just like initial data file.

If it is to be done in a hoste web page with database, should be done with php and mysql.

I am available to answer any questions.

Asking directly to select you through chat will be ignored.

Skills: .NET, Excel, PHP, Visual Basic

See more: complete pdf forms based on excel data file, macro script read excel data, pdf excel data entry convert, data entry web excel data, script export excel data text file, php script read tabbed data file, excel data file file, simply accounting data file convert excel, export excel data file tradestation, excel split file keep header download experts exchange, web excel data collection, script search excel data, web script handle excel data, excel dat file convert vba, script update excel data source, script web page data grabber

About the Employer:
( 50 reviews ) miami, Saudi Arabia

Project ID: #11813265

Awarded to:


Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel macros and i've never had a single problem. I reviewed the first file (initial file) [url removed, login to view], but More

$50 USD in 3 days
(347 Reviews)

32 freelancers are bidding on average $157 for this job


Hi I am very much sure that I can complete work as per your requirements.I assure you that I will provide you quality work and within the decided time frame and budget. Please drop me a message for further discuss More

$155 USD in 3 days
(1 Review)

I unable to see few fields in PearsonTemp.xlsx. Where i have to fetch the rest of fields like ID, etc., PM me. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accura More

$120 USD in 4 days
(40 Reviews)

Hi there, looks clear. I guess "SectionNumber" is Sec ID from raw data file. Do we need to create City sheets or they are constant? Do we clear them or append data every time? I would suggest the following appr More

$35 USD in 1 day
(232 Reviews)

Hi, I need few clarification. In the output file (Student_Registration_demo_v1), a) is the "Campus code" data is to replace with institution" data in the main sheet.? b) Idnumber is the "STUDENT_NUMBER" from " More

$277 USD in 3 days
(101 Reviews)

I can make your project a great success. I'm 31 year old talented PHP and open-source developer. I have 9 years of experience in Server Administration and Web Application Development. I'm expert in web application cust More

$222 USD in 8 days
(20 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can make a excel vba script to convert the data file Here is the reason. Why you should pick me More

$100 USD in 1 day
(227 Reviews)

Hi I have some questions 1- what field to put in "institution" ? 2- is IDNUMBER = STUDENT_NUMBER ? 3- as I understand Course1=institution+COURSE_SYMBOL+03+Sec_ID - You wrote "<institution>+<coursecode>+"03"+<sectio More

$140 USD in 3 days
(26 Reviews)

I can create the final data file from the person file by using a macro. For each institution you require a new sheet to be created. The subject names and email ids have to be derived from the data in person.

$30 USD in 1 day
(50 Reviews)

I would like to utilize this opportunity to introduce myself and send this application. I am keenly interested in working with you. I don't have much knowledge because I'm new and fresh in this field, but I'm willing More

$111 USD in 3 days
(0 Reviews)

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have done similar kind of project where I need to generate excel output with differen More

$200 USD in 5 days
(12 Reviews)

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills More

$250 USD in 3 days
(53 Reviews)
$245 USD in 3 days
(3 Reviews)

Hi, I am interested to your job. I am expert in web research, extracting email, data mining, Google, Bing, Yahoo, MS Office (Full), Google Docs, Google Document, Google Spreadsheet, Adwords, Analytics, Webmaster, SEO, More

$30 USD in 3 days
(1 Review)

Hi I have been in this industry for 5 years and such jobs are my daily practice.I can assure you that if you work with me once, you will always work with me for these kind of projects.

$200 USD in 7 days
(16 Reviews)

Hello, We have read your full descriptions and have seen your project files [url removed, login to view] can work on both of the methods but would prefer the host [url removed, login to view] developers with similar expertise [url removed, login to view] are posting More

$473 USD in 3 days
(75 Reviews)

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
$150 USD in 3 days
(2 Reviews)

Hi I am very interested in your project and would like to know more. For background I am a UK-based developer with over 20 years experience of developing bespoke solutions. I am proficient in Visual Basic in all More

$155 USD in 3 days
(6 Reviews)

Dear Hiring Manager, I am a Full time PHP Developer with Native English Skills. I have 5+ years of experience in web applications and can do all-round development. Technical Details About Me: Strong PHP/Mysql More

$138 USD in 3 days
(101 Reviews)

Greeting sir,i read your proposal well. Please make sure i will exceed your expectation,,thanks ... Kindly,please check my latest works : [url removed, login to view] with all respect sir ..

$188 USD in 5 days
(4 Reviews)