Forum Discussion
Help Creating an Excel File to Calculate Student Commutes to Clinical Sites and Filter Site Details
Hello, I’m hoping someone can help me create an Excel document for a fairly complex need. I oversee a large number of students across my state and am trying to ensure fairness in the clinical rotat...
Hi,
Sounds like a fun spreadsheet!
I did something similar a few years ago using the Google Maps API and the Excel function WEBSERVICE.
Chandoo has an old post with steps and an example file: https://chandoo.org/wp/distance-between-places-excel-maps-api/
Just read that the Google API changed on March 1st, so it may not work. Check this out: https://www.youtube.com/watch?v=uIRz2k21lEo
Copilot or ChatGPT can probably help you out as well!
Good luck
Matt