Calculating Distance In Excel
HTML-код
- Опубликовано: 13 сен 2024
- Stuck on a problem? Schedule a 1-Hour Consulting session with me.
www.bowerylabs...
In this video, I will show you how to calculate distances between zip codes in terms of miles and kilometers in Excel
DOWNLOAD LINK
www.bowerylabs...
God bless you for your selflessness and for sharing this knowledge with all of us. Saved me so much time, I cannot thank you enough!
Thank you, thank you, thank you SO MUCH!!! You have saved me so many hours of pouring over data and repeatedly going back to a map database I've been having to use for YEARS. This is a game changer for me!
Thanks. This is exactly what I need for my church's outreach program to seniors living alone. It will allow us to pair seniors with someone who can check on them regularly in person post-pandemic. Many shut-ins suffered greatly during the last 15 months.
This is incredible, thanks for sharing!!
Wow. This is exactly what I was looking for. Super helpful, thank you!!!
Thank you so much for creating this! I was able to create a sensitive report for corporate leadership through your formulas.
The internet is God and it speaks to us through angels, and today, you are an angel. thank you!
This was SOOOO helpful, and you just saved me a TON of time. Thank you!!!!!
This was incredibly helpful and saved me SO much time. Thank you for linking the document!!
This is amazing. Thank you so much for sharing!! Saved tons of time.
Not all hero's wear capes! Thank you so much!!!
Flipping amazing!! Exactly what I need!! THANK YOU!!
Extremely helpful - thank you for sharing this!
THANK YOU for your great insight of this and sharing it with everybody.
This is just wonderful!! Thank you so much for sharing this, you've made my life easier. You are a star, Kaptain Tech!!
Dude, you're the man. Thanks!
weldon dear, from few day i was searching but your vedio help me alot. thanks
This is absolutely brilliant. I didn't even think that someone would do it via Lat/Long and Trig..... You are a hero.
Thank you soo much, you have saved a lots of time for me.
Thank you for this simple tutorial and the excel file..
Excellent!!! Super-helpful and clear!!! Thank you so much!!!!!!
This was nicely taught! Extremely helpful and to the point. Thank you.
True scholar and gentleman
what is the unit of distance measured when we multiply by 3958.8? is it nautical miles or just regular miles
This was very helpful. Thank you very much
Thank you so much for this!
Thank you for this!!
Yeah this is awesome. Great work here.
Amazing and to the point!
THANK YOU! So helpful!
How did u get the latitude and longitude?
Big help, thank you!
Appreciate your video. Really helpful!
Where can I find this worksheet?
This mileage is where the crow flies, correct? It isn't calculating driving distance like Google Maps, right?
Amazing! Thank you
Thank you so much!
Hello, I would love the template but the link says the website is expired. Can you assist?
Really cool!!
How did you get the latitude and longitude for each zip code?
Thank you so mush. ^^
=ACOS(COS(RADIANS(90-B2))*COS(RADIANS(90-E2))+SIN(RADIANS(90-B2))*SIN(RADIANS(90-E2))*COS(RADIANS(C2-F2)))*3958.8
you're welcome
Thank you!
How would you explain the secret sauce? I need to explain it on my report
Brilliant.
THANK YOU SO MUCH
Genius!
How much variance do you think we have with actual roads and distance between two points?
Hi Max, the distance is shown as the aerial distance between 2 points and not the actual road wise distance which google maps suggest.
Is there a way to do this without the lat / longitudes? From zip to zip?
ruclips.net/video/UfJKouXwbZo/видео.html
This is for US only?
it doesn´t work for Europe... is there any way to make it work? thanks
This was great thanks! However, when I put the distance in using your spreadsheet and then use google maps, I'm getting a difference of 300 miles.... any idea why this could be happening? Thank you in advance.
my issue too did you find a work around?
I think that this must calculate a straight line, not driving distance.
@@alisonj this one calculates driving distance ruclips.net/video/UfJKouXwbZo/видео.html
Would you please describe me that why you multiply the formula by 3985.8 TIA
this is redus or earth
Merci!!
Thank youuuuuuuuuuuuuuuuu
Would it be possible to get the same data but for Canadian Postal Codes?
what is unit of distance? please
it is mile , but i need kilo meter !