Google Spreadsheet or Excel Scripts for Searching Nearest Addresses of School, Supermarkets etc. And Their Distances
$30-250 AUD
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.
Proje NO: #9547470
Proje hakkında
Bu iş için 8 freelancer ortalamada $327 teklif veriyor
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
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
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
I´m expert in Excel, I can to work to day. -----------------------------------------------------------------------------------------------------------------------------------------------------------