Google Spreadsheet or Excel Scripts for Searching Nearest Addresses of School, Supermarkets etc. And Their Distances

Devam Ediyor İlan edilme: Feb 3, 2016 Teslim sırasında ödenir
Devam Ediyor Teslim sırasında ödenir

The idea is to do what [login to view URL] does, but much much simpler. There will be project addresses inside a Google Spreadsheet. Script written will be able to calculate automatically distances between addresses and primary school, secondary school, the nearest university, shopping centre, supermarket (Woolworths/Coles/Aldi), park and hospital and store all these information inside the same Google Spreadsheet or Excel file.

For school information, if it is located in Victoria, the address has to be inputted into [login to view URL] to look for schools it belongs. If it is located in New South Wales (NSW), it will be on another website [login to view URL] As for other info, Google Map has a 'nearby' function and user can type in keywords (such as university, shopping centre, Woolworths, Coles, Aldi, park, hospital) to find the nearest places and their distances (walking) and estimated travelling time (driving and walking) from the building project. Script has to be able to get such information and the results are stored inside the same Google Spreadsheet or Excel file.

You can use Google Map Direction API (though I believe there is some limitation). Or Mapquest API.

I revised the whole project requirement thinking about the complexity of the system....

The idea is similar to what www.walkscore.com does, but much much simpler. The ultimate goal is to generate a marketing script for that particular project based on a word template.
Project addresses will be stored inside a database (has import and export function to csv file). System need to search which primary and secondary schools the address belong and the distance (driving and walking) and traveling time (driving and walking) between those addresses. Such searching will be done via certain websites.
Beside school information, nearest university, shopping centre, supermarket (can only either Woolworths, Coles or Aldi), park and hospital and their distances (driving and walking) and their traveling time (driving and walking). All of these information will be stored inside the database. You can use Google Map Direction API (though I believe there is some limitation) or Mapquest API. Afterwards, user can have the function to generate a marketing script based on templates and merge the information inside the database into that templates.

MySQL PHP Yazılım Mimarisi

Proje NO: #9547470

Proje hakkında

8 teklif Uzak proje Aktif Feb 11, 2016

Bu iş için 8 freelancer ortalamada $327 teklif veriyor

arhamsoftltd

Greetings, I have gone through your complete project description along with the provided links and got the Idea for developing the script to find the nearby location in the Excel and Google Spreadsheets. We hav Daha Fazla

$600 AUD in 20 gün içinde
(170 Değerlendirme)
9.1
gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo Daha Fazla

$201 AUD in 7 gün içinde
(512 Değerlendirme)
8.3
patzzVJSOFT

Hello , May i see the sample spread sheet or excel format ? the way you entered the data? If the spread sheet has lat long information then it will be easy to calculate the distance from a point (location) . Otherwise Daha Fazla

$315 AUD in 7 gün içinde
(218 Değerlendirme)
8.2
jaimecollazos

I´m expert in Excel, I can to work to day. -----------------------------------------------------------------------------------------------------------------------------------------------------------

$200 AUD in 3 gün içinde
(0 Değerlendirme)
0.0