Convert Data file with Excel or web script

Closed

Description

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

Project ID: #11813265

Awarded to:

MimiFL

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) PearsonTemp.xlsx, but More

$50 USD in 3 days
(188 Reviews)
5.9

33 freelancers are bidding on average $156 for this job

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W More

$210 USD in 3 days
(142 Reviews)
7.6
Maariyaa

Hello Dear, HERE Ready to start!!! I can perfectly do it. I have lot of experience related and different types of projects. I am waiting to your quick positive reply. Feel free ask me question if any. I Look for More

$210 USD in 3 days
(219 Reviews)
6.7
ITservice

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
(84 Reviews)
7.0
gangabass

I'm expert in data processing with hundreds of completed projects and excellent reviews that's why I'm sure you'll be impressed with my work. I can offer you third way: I can create simple GUI application where you More

$54 USD in 0 days
(268 Reviews)
6.6
Walkingdreams

Hello, We have read your full descriptions and have seen your project files too.We can work on both of the methods but would prefer the host webpages.Professional developers with similar expertise here.We are posting More

$473 USD in 3 days
(60 Reviews)
6.7
arityinfoway

Hello Sir, I have gone through your requirements regarding Convert Data file with Excel or web script. we brief and understand your idea and preference for job as you are looking for. I have more than 6+ years of More

$189 USD in 5 days
(71 Reviews)
5.9
watersev

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
(190 Reviews)
6.1
suniljoshi151

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
(48 Reviews)
5.8
romanapanovich

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
(15 Reviews)
5.2
xielessupport

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
(17 Reviews)
5.1
neekweb

Hello, I am interested in doing the project. I am Aakash from Neekweb software solution. Our Website www.neekweb.com. WE WILL DO THIS PROJECT UING PHP MYSQL. Logo Portfolio- http://neekweb.com/portfolio-graphics-de More

$411 USD in 3 days
(48 Reviews)
5.1
schoudhary1553

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
(46 Reviews)
5.0
teeares

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
(45 Reviews)
4.8
maamekal

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
(19 Reviews)
4.5
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More

$88 USD in 3 days
(30 Reviews)
4.5
shiva1888

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
(7 Reviews)
4.1
aaquibinfi

Hi, I'm Professional VBA Expert. I'm interested in this project. I need know more about this project I assure you of quality work. Looking forward to hear from you soon. Regards, Alex

$120 USD in 3 days
(15 Reviews)
3.8
$245 USD in 3 days
(3 Reviews)
3.8
nikmah344

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
(7 Reviews)
3.9
royalcalif

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
(15 Reviews)
3.6