Hunter Ford asks: Who has had the most miles traveled?
Those formulas were rather difficult to figure out utilizing Google Sheets (Google’s version of Microsoft Excel), but after well over a year of testing, I finally did it. This sheet takes all of our active teams and finds the distance between them using a complex formula which mimics the functionality of a web-crawler. It will then generate a report which will show the total unique distance traveled to and from an Event for each team. Meaning, Kent will not get credit for traveling to BGSU four times last year for each game they played at Nationals, it will only give them one credit for travel to and from BGSU for Nationals.
This is set up as a 27×27 matrix which is running this formula 729 times and comparing it to a much larger matrix which includes any school that has ever expressed interest in joining the league (this matrix is 61×61 for a total of 3,721 simultaneously running formulas). Needless to say, I nerded out HARD on this and actually had a good time creating it. My laptop almost dies every time I open the sheet to start the report.
Anyway, here’s the information that is most useful and what you guys probably care about.
I was able to find an average distance between each of the schools from one another. Here is a list ranking the most centrally located schools:
#1: OSU – 352.5 miles
#2: BGSU – 362.5 miles
#3: BW – 365.0 miles
#4: Akron – 365.5 miles
#5: Kent – 365.7 miles
#6: Ohio – 376.3 miles
#7: Miami (OH) – 379.4 miles
#8: Pitt – 387.7 miles
#9: UK – 410.6 miles
#10: MSU – 417.1 miles
#11: DePaul – 450.1 miles
#12: SVSU – 459.3 miles
#13: GVSU – 459.3 miles
#14: PSU – 459.6 miles
#15: CMU – 469.0 miles
#16: JMU – 483.4 miles
#17: WKU – 487.5 miles
#18: NIU – 490.7 miles
#19: UMD – 498.4 miles
#20: SU – 503.1 miles
#21: TU – 508.5 miles
#22: UVA – 509.9 miles
#23: UWW – 531.0 miles
#24: VCU – 546.8 miles
#25: UWP – 591.3 miles
#26: UNG – 624.3 miles
#27: GSU – 742.2 miles
#28: UNL – 841.2 miles
#29: UNT – 1069.0 miles
Below you will find rankings for how many miles that were traveled by each school going to and from NCDA Events starting with the 2010/2011 season, when accurate records started being kept, through Nationals 2016.
2010/2011 Season:
During the 2010/2011 season, teams traveled a total of 59,156.4 miles to and from events. If we multiply that by 4.5 cars per trip (that’s a guesstimate) it totals out to 266,203.8 miles put on vehicles for the sake of NCDA dodgeball trips during the 2010/2011 season. There were 95 unique trips made to other schools for events, at an average of 622.7 miles round-trip per event.
#1: DePaul – 2,518.8 miles (11334.6 total miles at 4.5 cars per trip)
#2: WIU – 2,231.0 miles (10039.5 total miles at 4.5 cars per trip)
#3: GVSU – 2,225.2 miles (10013.4 total miles at 4.5 cars per trip)
#4: SVSU – 2,133.8 miles (9602.1 total miles at 4.5 cars per trip)
#5: CMU – 2,054.8 miles (9246.6 total miles at 4.5 cars per trip)
#6: WKU – 1,910.0 miles (8595 total miles at 4.5 cars per trip)
#7: Kent – 1,844.6 miles (8300.7 total miles at 4.5 cars per trip)
#8: MSU – 1,730.8 miles (7788.6 total miles at 4.5 cars per trip)
#9: UK – 1,695.4 miles (7629.3 total miles at 4.5 cars per trip)
#10: K-State – 1,567.4 miles (7053.3 total miles at 4.5 cars per trip)
#11: UWP – 1,504.8 miles (6771.6 total miles at 4.5 cars per trip)
#12: BGSU – 1,485.0 miles (6682.5 total miles at 4.5 cars per trip)
#13: EMU – 1,391.6 miles (6262.2 total miles at 4.5 cars per trip)
#14: NSULA – 1,390.4 miles (6256.8 total miles at 4.5 cars per trip)
#15: OSU – 1,293.0 miles (5818.5 total miles at 4.5 cars per trip)
#16: Miami – 987.2 miles (4442.4 total miles at 4.5 cars per trip)
#17: MAD – 834.0 miles (3753 total miles at 4.5 cars per trip)
#18: UofL – 768.8 miles (3459.6 total miles at 4.5 cars per trip)
#19: LCC – 11.6 miles (52.2 total miles at 4.5 cars per trip)
2011/2012 Season:
During the 2011/2012 season, teams traveled a total of 60,722.4 miles to and from events. If we multiply that by 4.5 cars per trip (that’s a guesstimate) it totals out to 273,250.8 miles put on vehicles for the sake of NCDA dodgeball trips during the 2011/2012 season. There were 103 unique trips made to other schools for events, at an average of 589.5 miles round-trip per event.
#1: Kent – 3,381.0 miles (15214.5 total miles at 4.5 cars per trip)
#2: NSULA – 2,427.8 miles (10925.1 total miles at 4.5 cars per trip)
#3: JMU – 2,374.4 miles (10684.8 total miles at 4.5 cars per trip)
#4: UK – 2,080.6 miles (9362.7 total miles at 4.5 cars per trip)
#5: Miami – 2,074.2 miles (9333.9 total miles at 4.5 cars per trip)
#6: OSU – 2,025.6 miles (9115.2 total miles at 4.5 cars per trip)
#7: WKU – 1,863.4 miles (8385.3 total miles at 4.5 cars per trip)
#8: WIU – 1,554.2 miles (6993.9 total miles at 4.5 cars per trip)
#9: GVSU – 1,535.6 miles (6910.2 total miles at 4.5 cars per trip)
#10: BGSU – 1,483.4 miles (6675.3 total miles at 4.5 cars per trip)
#11: SVSU – 1,408.4 miles (6337.8 total miles at 4.5 cars per trip)
#12: UWP – 1,344.2 miles (6048.9 total miles at 4.5 cars per trip)
#13: MSU – 1,141.8 miles (5138.1 total miles at 4.5 cars per trip)
#14: DePaul – 1,091.2 miles (4910.4 total miles at 4.5 cars per trip)
#15: UNL – 1,051.2 miles (4730.4 total miles at 4.5 cars per trip)
#16: MAD – 1,010.8 miles (4548.6 total miles at 4.5 cars per trip)
#17: RIT – 556.2 miles (2502.9 total miles at 4.5 cars per trip)
#18: UofL – 542.8 miles (2442.6 total miles at 4.5 cars per trip)
#19: CMU – 537.2 miles (2417.4 total miles at 4.5 cars per trip)
#20: Towson – 438.6 miles (1973.7 total miles at 4.5 cars per trip)
#21: UMD – 293.8 miles (1322.1 total miles at 4.5 cars per trip)
#22: EMU – 144.8 miles (651.6 total miles at 4.5 cars per trip)
2012/2013 Season:
During the 2012/2013 season, teams traveled a total of 74,551.6 miles to and from events. If we multiply that by 4.5 cars per trip (that’s a guesstimate) it totals out to 335,482.2 miles put on vehicles for the sake of NCDA dodgeball trips during the 2012/2013 season. There were 111 unique trips made to other schools for events, at an average of 671.6 miles round-trip per event.
#1: Kent – 4,266.0 miles (19197 total miles at 4.5 cars per trip)
#2: JMU – 3,849.0 miles (17320.5 total miles at 4.5 cars per trip)
#3: SVSU – 3,191.8 miles (14363.1 total miles at 4.5 cars per trip)
#4: UK – 3,044.8 miles (13701.6 total miles at 4.5 cars per trip)
#5: MSU – 2,179.2 miles (9806.4 total miles at 4.5 cars per trip)
#6: GVSU – 2,129.0 miles (9580.5 total miles at 4.5 cars per trip)
#7: WKU – 2,041.4 miles (9186.3 total miles at 4.5 cars per trip)
#8: Miami – 1,996.0 miles (8982 total miles at 4.5 cars per trip)
#9: CMU – 1,703.0 miles (7663.5 total miles at 4.5 cars per trip)
#10: NSULA – 1,686.0 miles (7587 total miles at 4.5 cars per trip)
#11: Towson – 1,619.0 miles (7285.5 total miles at 4.5 cars per trip)
#12: UWP – 1,541.8 miles (6938.1 total miles at 4.5 cars per trip)
#13: BGSU – 1,373.0 miles (6178.5 total miles at 4.5 cars per trip)
#14: DePaul – 1,210.2 miles (5445.9 total miles at 4.5 cars per trip)
#15: UNL – 1,051.2 miles (4730.4 total miles at 4.5 cars per trip)
#16: PSU – 1,015.2 miles (4568.4 total miles at 4.5 cars per trip)
#17: VCU – 1,000.4 miles (4501.8 total miles at 4.5 cars per trip)
#18: OSU – 892.8 miles (4017.6 total miles at 4.5 cars per trip)
#19: RIT – 793.6 miles (3571.2 total miles at 4.5 cars per trip)
#20: NSU – 583.2 miles (2624.4 total miles at 4.5 cars per trip)
#21: UMD – 93.6 miles (421.2 total miles at 4.5 cars per trip)
#22: MAD – 15.6 miles (70.2 total miles at 4.5 cars per trip)
2013/2014 Season:
During the 2013/2014 season, teams traveled a total of 76,808.4 miles to and from events. If we multiply that by 4.5 cars per trip (that’s a guesstimate) it totals out to 345,637.8 miles put on vehicles for the sake of NCDA dodgeball trips during the 2013/2014 season. There were 117 unique trips made to other schools for events, at an average of 656.5 miles round-trip per event.
#1: DePaul – 4,034.8 miles (18156.6 total miles at 4.5 cars per trip)
#2: GVSU – 4,025.4 miles (18114.3 total miles at 4.5 cars per trip)
#3: JMU – 3,661.2 miles (16475.4 total miles at 4.5 cars per trip)
#4: Kent – 3,202.8 miles (14412.6 total miles at 4.5 cars per trip)
#5: SVSU – 2,986.8 miles (13440.6 total miles at 4.5 cars per trip)
#6: WKU – 2,647.2 miles (11912.4 total miles at 4.5 cars per trip)
#7: UWP – 2,452.0 miles (11034 total miles at 4.5 cars per trip)
#8: CMU – 2,248.4 miles (10117.8 total miles at 4.5 cars per trip)
#9: MSU – 1,804.2 miles (8118.9 total miles at 4.5 cars per trip)
#10: UNT – 1,784.6 miles (8030.7 total miles at 4.5 cars per trip)
#11: Towson – 1,592.6 miles (7166.7 total miles at 4.5 cars per trip)
#12: Miami – 1,508.8 miles (6789.6 total miles at 4.5 cars per trip)
#13: UMD – 1,476.2 miles (6642.9 total miles at 4.5 cars per trip)
#14: BGSU – 1,244.4 miles (5599.8 total miles at 4.5 cars per trip)
#15: UK – 1,031.0 miles (4639.5 total miles at 4.5 cars per trip)
#16: OSU – 1,019.0 miles (4585.5 total miles at 4.5 cars per trip)
#17: SHU – 621.2 miles (2795.4 total miles at 4.5 cars per trip)
#18: VCU – 569.2 miles (2561.4 total miles at 4.5 cars per trip)
#19: PSU – 460.4 miles (2071.8 total miles at 4.5 cars per trip)
#20: DU – 34.0 miles (153 total miles at 4.5 cars per trip)
2014/2015 Season:
During the 2014/2015 season, teams traveled a total of 83,000.8 miles to and from events. If we multiply that by 4.5 cars per trip (that’s a guesstimate) it totals out to 373,503.6 miles put on vehicles for the sake of NCDA dodgeball trips during the 2014/2015 season. There were 114 unique trips made to other schools for events, at an average of 728.1 miles round-trip per event.
#1: Kent – 4,196.6 miles (18884.7 total miles at 4.5 cars per trip)
#2: JMU – 3,919.8 miles (17639.1 total miles at 4.5 cars per trip)
#3: CMU – 3,343.2 miles (15044.4 total miles at 4.5 cars per trip)
#4: WKU – 3,290.6 miles (14807.7 total miles at 4.5 cars per trip)
#5: GVSU – 2,808.0 miles (12636 total miles at 4.5 cars per trip)
#6: Towson – 2,267.4 miles (10203.3 total miles at 4.5 cars per trip)
#7: MSU – 2,264.2 miles (10188.9 total miles at 4.5 cars per trip)
#8: UK – 2,212.2 miles (9954.9 total miles at 4.5 cars per trip)
#9: PSU – 2,134.4 miles (9604.8 total miles at 4.5 cars per trip)
#10: UMD – 2,056.4 miles (9253.8 total miles at 4.5 cars per trip)
#11: BGSU – 2,014.0 miles (9063 total miles at 4.5 cars per trip)
#12: UWP – 1,976.4 miles (8893.8 total miles at 4.5 cars per trip)
#13: OSU – 1,904.2 miles (8568.9 total miles at 4.5 cars per trip)
#14: VCU – 1,769.0 miles (7960.5 total miles at 4.5 cars per trip)
#15: SVSU – 1,657.4 miles (7458.3 total miles at 4.5 cars per trip)
#16: DePaul – 1,274.0 miles (5733 total miles at 4.5 cars per trip)
#17: UNT – 1,201.2 miles (5405.4 total miles at 4.5 cars per trip)
#18: Akron – 984.0 miles (4428 total miles at 4.5 cars per trip)
#19: SU – 81.8 miles (368.1 total miles at 4.5 cars per trip)
#20: BW – 77.6 miles (349.2 total miles at 4.5 cars per trip)
#21: DU – 68.0 miles (306 total miles at 4.5 cars per trip)
2015/2016 Season:
During the 2015/2016 season, teams traveled a total of 80,718.8 miles to and from events. If we multiply that by 4.5 cars per trip (that’s a guesstimate) it totals out to 363,234.6 miles put on vehicles for the sake of NCDA dodgeball trips during the 2015/2016 season. There were 234 unique trips made to other schools for events, at an average of 345.0 miles round-trip per event.
#1: Ohio – 3,728.8 miles (16779.6 total miles at 4.5 cars per trip)
#2: Kent – 3,668.4 miles (16507.8 total miles at 4.5 cars per trip)
#3: GVSU – 2,872.4 miles (12925.8 total miles at 4.5 cars per trip)
#4: UK – 2,734.4 miles (12304.8 total miles at 4.5 cars per trip)
#5: MSU – 2,609.0 miles (11740.5 total miles at 4.5 cars per trip)
#6: VCU – 2,468.2 miles (11106.9 total miles at 4.5 cars per trip)
#7: UWP – 2,461.8 miles (11078.1 total miles at 4.5 cars per trip)
#8: DePaul – 2,453.8 miles (11042.1 total miles at 4.5 cars per trip)
#9: SVSU – 2,159.2 miles (9716.4 total miles at 4.5 cars per trip)
#10: Akron – 2,033.8 miles (9152.1 total miles at 4.5 cars per trip)
#11: Towson – 1,733.4 miles (7800.3 total miles at 4.5 cars per trip)
#12: WKU – 1,720.2 miles (7740.9 total miles at 4.5 cars per trip)
#13: CMU – 1,704.0 miles (7668 total miles at 4.5 cars per trip)
#14: JMU – 1,594.2 miles (7173.9 total miles at 4.5 cars per trip)
#15: BGSU – 1,567.8 miles (7055.1 total miles at 4.5 cars per trip)
#16: OSU – 1,152.2 miles (5184.9 total miles at 4.5 cars per trip)
#17: PSU – 1,134.0 miles (5103 total miles at 4.5 cars per trip)
#18: BW – 851.6 miles (3832.2 total miles at 4.5 cars per trip)
#19: UNL – 828.8 miles (3729.6 total miles at 4.5 cars per trip)
#20: UMD – 681.2 miles (3065.4 total miles at 4.5 cars per trip)
#21: UVA – 120.4 miles (541.8 total miles at 4.5 cars per trip)
#22: SU – 81.8 miles (368.1 total miles at 4.5 cars per trip)
My guess for the reason there were 2,300 more miles driven in the 2015 season compared to the 2016 season is because BGSU (host of 2016 Nationals [18 Teams]) is the 2nd most centrally located team to all the other active clubs (362.5mi), while WKU (host of 2015 Nationals [16 Teams]) is the 17th most centrally located team to all other active clubs (487.5mi). The 2015 season had 195 recorded games, while the 2016 season had 231 recorded games.
August 2010-April 2016:
From August 2010-April 2016, teams traveled a total of 434,958.4 miles to and from events. If we multiply that by 4.5 cars per trip (that’s a guesstimate) it totals out to 1,957,312.8 miles put on vehicles for the sake of NCDA dodgeball trips from August 2010-April 2016. There were 774 unique trips made to other schools for events, at an average of 562.0 miles round-trip per event.
#1: Kent – 20,559 miles (92517.3 total miles at 4.5 cars per trip)
#2: GVSU – 15,596 miles (70180.2 total miles at 4.5 cars per trip)
#3: JMU – 15,399 miles (69293.7 total miles at 4.5 cars per trip)
#4: SVSU – 13,537 miles (60918.3 total miles at 4.5 cars per trip)
#5: WKU – 13,473 miles (60627.6 total miles at 4.5 cars per trip)
#6: UK – 12,798 miles (57592.8 total miles at 4.5 cars per trip)
#7: DePaul – 12,583 miles (56622.6 total miles at 4.5 cars per trip)
#8: MSU – 11,729 miles (52781.4 total miles at 4.5 cars per trip)
#9: CMU – 11,591 miles (52157.7 total miles at 4.5 cars per trip)
#10: UWP – 11,281 miles (50764.5 total miles at 4.5 cars per trip)
#11: BGSU – 9,168 miles (41254.2 total miles at 4.5 cars per trip)
#12: OSU – 8,287 miles (37290.6 total miles at 4.5 cars per trip)
#13: Towson – 7,651 miles (34429.5 total miles at 4.5 cars per trip)
#14: Miami – 6,566 miles (29547.9 total miles at 4.5 cars per trip)
#15: VCU – 5,807 miles (26130.6 total miles at 4.5 cars per trip)
#16: PSU – 4,744 miles (21348 total miles at 4.5 cars per trip)
#17: UMD – 4,601 miles (20705.4 total miles at 4.5 cars per trip)
#18: WIU – 3,785 miles (17033.4 total miles at 4.5 cars per trip)
#19: Ohio – 3,729 miles (16779.6 total miles at 4.5 cars per trip)
#20: NSULA – 3,076 miles (13843.8 total miles at 4.5 cars per trip)
#21: Akron – 3,018 miles (13580.1 total miles at 4.5 cars per trip)
#22: NSU – 3,011 miles (13549.5 total miles at 4.5 cars per trip)
#23: UNT – 2,986 miles (13436.1 total miles at 4.5 cars per trip)
#24: UNL – 2,931 miles (13190.4 total miles at 4.5 cars per trip)
#25: MAD – 1,860 miles (8371.8 total miles at 4.5 cars per trip)
#26: K-State – 1,567 miles (7053.3 total miles at 4.5 cars per trip)
#27: EMU – 1,536 miles (6913.8 total miles at 4.5 cars per trip)
#28: RIT – 1,350 miles (6074.1 total miles at 4.5 cars per trip)
#29: UofL – 1,312 miles (5902.2 total miles at 4.5 cars per trip)
#30: BW – 929 miles (4181.4 total miles at 4.5 cars per trip)
#31: SHU – 621 miles (2795.4 total miles at 4.5 cars per trip)
#32: SU – 164 miles (736.2 total miles at 4.5 cars per trip)
#33: UVA – 120 miles (541.8 total miles at 4.5 cars per trip)
#34: DU – 102 miles (459 total miles at 4.5 cars per trip)
#35: LCC – 12 miles (52.2 total miles at 4.5 cars per trip)
Damn I ask a lot of questions