Create Program: Take Excel Address to Google Maps Directions to Letter (THIS IS NOT DATA ENTRY)

IN PROGRESS
Bids
5
Avg Bid (USD)
$252
Project Budget (USD)
$30 - $250

Project Description:
Overview

This project will require the selected programmer to create a mechanism/program to (1) take list of my client's addresses (always in the same format and sample included below) from Excel and (2) create turn-by-turn directions (distance as well) using Google Maps for each address to a particular location (static location/ my office) and then (3) merge those turn by turn direction into a unique letter (word format) for each client.

Concept

I receive (daily) a list of name for advertising purposes. I would like to create a clean, elegant design (word output) in which to easy provide each client turn-by-turn directions to my business. This idea is basically like a mail merge but for turn-by-turn directions.

Issues

The Ending Location is where we want the client to go. In other words, the ending location is my office. I do not want to be forced into running the list twice, once for Durham, NC office and again for Raleigh, NC office. I would like the run the list and have this program decide which office the client should be sent to, based upon the distance or length of journey by car. Essentially, the program should find the closer office for the client and only provide the client with one set of driving directions.

Details

Excel Spreadsheet - Excel spreadsheet is created by a third party and the format is consistent (see attachment). Spreadsheet contains between 100 to 500 names + addresses on a daily basis. Averaging approximately 250 names a day.

Directions – I would like the output document to contain turn-by-turn directions from the clients address to my end location. Note: There are two end locations – see Issues section.

Ending Locations – The ending locations are our two offices.

Durham Office
2304 S. Miami Blvd, Suite 123
Durham, NC 27703

Raleigh Office
4801 Glenwood Ave, Suite 200
Raleigh, North Carolina 27612

Output Document – We should be able to change the content and wording of the language. See attachment for template language. Since each client is being mailed their own set of direction we will need to be able to print it out quickly.

Limitations

This application should be fast and efficient. No crashing or bugs.

When a list of 200 names has been run, the output file should be a single word document with each set of directions of a single page. The order of the turn-by-turn directions should be the same order as the spreadsheet.

Data
- Client address are always in the exact same format in the excel spreadsheet.
- Directions will need to placed into a letter that should be in word format / template (easy to edit)
- Letter should contact turn by turn directions (hereinafter referred to as "Produced Directions")
- Letter should contact distance from client's address to ending address. (hereinafter referred to as "Produced Distance")

Things to Avoid

I do not want to have to cut and paste my data from the spreadsheet to the program if I can avoid it. I would like to activate the program, browse for the excel file with the client addresses and then produce directions (very important)

Design

I would like the output document to have a clean, concise and elegant design. The turn-by-turn directions should be spaced evenly and appropriately. The turn-by-turn directions should work well on the page with the other advertisement language.

This document will be printed on letterhead and therefore the first 2.25 inches of the page (top) will need to be blank with the design below that.

See attachment for other language for file...
See attachment for spreadsheet format

Skills required:
Advertisement Design, Data Processing, Excel, Google App Engine, Word
Additional Files: Other advertising language – see below.docx AAAList011314-1-1.xls
Hire jpierce127
Project posted by:
jpierce127 United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 250
in 5 days
Hire vikas0903
$ 315
in 10 days
$ 300
in 12 days
Hire zainbasharat
$ 175
in 7 days
Hire avijitchatterjee
$ 222
in 3 days