Find Jobs
Hire Freelancers

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

$30-250 USD

Завершено
Опублікований about 10 years ago

$30-250 USD

Оплачується при отриманні
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
ID проекту: 5317468

Про проект

4 пропозицій(-ї)
Дистанційний проект
Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
Hi Sir, i have experience with google maps API and also file generation. i have read you requirements and i can make a program which will perform all the operations. it will choose the shortest distance and you will be able to choose input files from the software. Here is an example of how the turn by turn directions will be From : 2 Brynhurst Ct Durham,NC 27713 Destination : Durham Office 2304 S. Miami Blvd, Suite 123 Durham, NC 27703 Total Distance 6.9 mi - about 12 mins 1. Head northeast on Brynhurst Ct toward Fortune's Ridge Dr (75 ft) 2. Continue onto Tall Oaks Dr (0.4 mi) 3. Turn right onto Cook Rd (0.2 mi) 4. Turn left onto Fayetteville Rd (1.1 mi) 5. Turn right onto Martin Luther King Jr Pkwy (1.2 mi) 6. Turn left onto NC-55 W (0.1 mi) 7. Sharp right onto E Cornwallis Rd (1.2 mi) 8. Turn left onto T W Alexander Drive (1.7 mi) 9. Turn left onto S Miami Blvd Destination will be on the left (0.9 mi) If you need any further information then let me know. Best Regards, Zain Basharat.
$175 USD за 7 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
4 фрілансерів(-и) готові виконати цю роботу у середньому за $260 USD
Аватарка користувача
Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.
$250 USD за 5 дні(-в)
5,0 (19 відгуки(-ів))
4,5
4,5
Аватарка користувача
Hi, My Background: I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, regression and price models. In my projects, I work extensively on excel. Regarding your project: I have successfully completed similar projects for 'atlgcb''. You may have a look at review provided. That project was about going into a website, entering card details and getting data. In your project, I expect the same though a lot of pre and post analysis as well. Please revert back for any questions/clarifications. Regards! Vikas
$315 USD за 10 дні(-в)
5,0 (3 відгуки(-ів))
2,9
2,9
Аватарка користувача
I am interested in making this "directions" program for you. I have experience with almost all of the pieces of the program. To write the program, I will use Java. If you want, I can even make the program so that you don't have to have Java installed (I can bundle the Java JRE with the program using Launch4j, a Java bundling tool I have used many times). Here are the pieces to the program and how I'll make them: 1) To read the Excel file, I will use the Apache POI API. It's an API for Java that lets me read/write Microsoft Office documents (such as Excel and Word documents). I have used it many times for past projects, so it's not new for me. 2) To get turn-by-turn directions from Google, I will use the Google Maps API that Google provides. I will not be able to get a map of the directions, but I will be able to get simple turn-by-turn text directions. I have never used this API before, but it's based around calling GET requests on URLs and then parsing the Google server's response as JSON, both of which I have done before. I just haven't used specifically Google's API. 3) To save the directions to the Word document, I'll use the Apache POI API again. I have never used the Word side of the API (I've only used the Excel side), but I can learn how to use the Word side the same way I learned to use the Excel side my first time using it. Let me know if you are interested in me making this program for you. Hope to hear from you soon. Regards, Christopher (andrewscm)
$300 USD за 12 дні(-в)
5,0 (4 відгуки(-ів))
2,8
2,8
Аватарка користувача
A proposal has not yet been provided
$222 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
United States
1,7
12
Спосіб оплати верифіковано
На сайті з жовт. 12, 2010

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.