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 rotations they are assigned to. I would like to set up an Excel spreadsheet that can:

• House student names along with their home addresses.
• List multiple clinical site addresses that students may rotate to.
• Calculate and display the commute time and distance (in miles) from each student’s home address to each potential clinical site.

Additionally (if possible), I would love to be able to filter the clinical sites based on certain characteristics, such as:

• Types of MRI scans performed at the site
• Patient volume (high volume vs slower paced)
• Type of location (small town hospital, large city hospital, or mobile MRI unit)

If the filtering features are too complicated, I would at least like help setting up the commute calculations between home addresses and multiple site addresses.

I appreciate any guidance or ideas. Thank you so much in advance for your help!