Hi Ian - this is hugely helpful - thanks so much! Is there any chance you could share a way to increase the number of rows in the calculator beyond the 54 currently? Would like to be able to input more data at one time. Thanks again.
hello Ian , I am a beginner for maps and i am into the getting distance for map point lat and long and i really like how you are set up on your demistraton in excel in your video can you put out a step by step video on how you set up google maps and your excel spreadsheet i would really appreciate your help
Hi Ian! I hope you are fine. I download your update JAN 2021 (and create API Key in google) but it is not working. Could you help me sending me instructionshow i can do in order to work with your file to get distance kms and time? Thanks a lot for your support.
Hey Ian, I've been trying to find a spreadsheet like the one in your video for a good time now. I'm trying to use a spreadsheet like yours for my business. Any way I could get a copy to help me out?
Howdy, to do this you need to modify the web address something like as follows. After the ? it needs to contain key=XXXXXX for example: maps.googleapis.com/maps/api/distancematrix/xml?origins=Denver, CO&destinations=Colorado Springs, CO becomes maps.googleapis.com/maps/api/distancematrix/xml?key=XXXXXX&origins=Denver, CO&destinations=Colorado Springs, CO
Hi Victoria, normally I charge for providing custom spreadsheets by the hour and to modify something like the above to use GPS co-ordinates instead of physical addresses and send you the spreadsheet I estimate would take less than an hour. If you'd like me to do that for you, please contact me at ian@millingtoncs.com and we can discuss further.
Phantastisch, vielen Dank! Ein soo altes Video - aber es konnte mir dennoch helfen. Insbesondere dank deinem Update im 2023! 👍👍💐💐😎😎
This is amazing, thanks for posting!
Hi Ian - this is hugely helpful - thanks so much! Is there any chance you could share a way to increase the number of rows in the calculator beyond the 54 currently? Would like to be able to input more data at one time. Thanks again.
Hi Ian, great tool. Thank you. Is there a reason it is limited to 54 records?
Hej,
can I get info did you do this with VBA or through Excel build in functions?
Do you have video for that?? if yes then please send me that.
Hi
Would it be possible to get a copy of the Spreadsheet used?
Gr8 simple looking spreadsheet, very clean.
I just added a link to it in the description.
hello Ian , I am a beginner for maps and i am into the getting distance for map point lat and long and i really like how you are set up on your demistraton in excel in your video can you put out a step by step video on how you set up google maps and your excel spreadsheet i would really appreciate your help
Hi Ian! I am assuming this is driving distance and time, right?
On the spreadhseet, the miles field is displying the duration. Please can this be fixed to show miles?
Hi Peter, a copy of the spreadsheet would be really helpful for me.
Hi Ian! I hope you are fine. I download your update JAN 2021 (and create API Key in google) but it is not working. Could you help me sending me instructionshow i can do in order to work with your file to get distance kms and time? Thanks a lot for your support.
What is API?Which info we shuould enter?
How to program your "get travel info". This is what I need
Send me a private message and I can help you out.
Plz help me
Hey Ian, I've been trying to find a spreadsheet like the one in your video for a good time now. I'm trying to use a spreadsheet like yours for my business. Any way I could get a copy to help me out?
Sure, send me an email ian@millingtoncs.com and I'll send you a copy.
How do that
I WOULD LOVE A COPY OF YOUR WORK OR INSTRUCTIONS ON HOW TO MAKE MY OWN.
Email me at ian@millingtoncs.com. and I can send you a copy!
hii how to program it
Please provide a link for this awesome spreadsheet and VBA for the button. Thanks!
Steve, please email me at ian@millingtoncs.com and I will email a copy to you.
Thank you, Ian. I have sent you an email.
@@37777steve hey do already get what u want? Could u please forward to me? Thx
Can you please email it to me aswell shujahmoledina121@gmail.com
Hi Ian, how do I use the key? I have my own version on this tool that measures time, distance and direction but it now no longer works.
Howdy, to do this you need to modify the web address something like as follows. After the ? it needs to contain key=XXXXXX for example:
maps.googleapis.com/maps/api/distancematrix/xml?origins=Denver, CO&destinations=Colorado Springs, CO
becomes
maps.googleapis.com/maps/api/distancematrix/xml?key=XXXXXX&origins=Denver, CO&destinations=Colorado Springs, CO
A Perth boy ah? Aussie Aussie Aussie!!! oi oi oi....Sydney is not in WA
i want this sheet
Send me an email - ian@millingtoncs.com
Rosebiba0@gmail. Com
do you have a copy of that document
Victoria Franco Yes I do, I write custom software and create documents like this as part of my business.
how can i obtain this kind of document from you? i need to the same using coordenates as the user input
Hi Victoria, normally I charge for providing custom spreadsheets by the hour and to modify something like the above to use GPS co-ordinates instead of physical addresses and send you the spreadsheet I estimate would take less than an hour. If you'd like me to do that for you, please contact me at ian@millingtoncs.com and we can discuss further.