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...
That question’s pretty old, but I actually made something similar not long ago, so here’s a quick overview.
You can set this up in Excel using a few tables and an add-in. Create one sheet for students (name and home address) and another for clinical sites (site info, type, volume, etc.). Then use the Bing Maps Excel add-in or a Google Maps API script to calculate commute time and distance between addresses.
Once that’s working, you can build a simple matrix showing each student’s commute to each site and add filters or slicers to narrow sites by type, volume, or location. The Bing Maps add-in is the easiest option if you just need quick distance and time calculations right in Excel.