Help Creating an Excel File to Calculate Student Commutes to Clinical Sites and Filter Site Details

You can handle this by using a structured spreadsheet. Keep one sheet for students with names and home addresses, and another sheet for clinical sites with site addresses and details like scan type, patient volume, and location type. Store each attribute in its own column so filtering stays simple. For commute distance, converting addresses to latitude and longitude allows consistent distance calculations. Once distances are calculated, standard filters or tables can be used to narrow sites by the required characteristics.