Most Overdue For a Revisit

Elliott Line, of parkrun Stats fame, has been promoting the idea of a Most Overdue For a Revisit or MOFAR ranking to decided which parkruns are in the most urgent need of a revisit. I have attempted to steal this idea and calculate my own.

EventMilesWeeksTimesW/M(W/M)/T
Alvaston29.1989 1 3.0490 3.0490
Arrow Valley22.31111 1 4.9753 4.9753
Babbs Mill13.3680 1 5.9880 5.9880
Beacon6.6750 2 7.4963 3.7481
Bedworth23.3953 3 2.2659 0.7553
Bevendean Down146.6984 2 0.5726 0.2863
Blackpool92.65177 1 1.9104 1.9104
Bramley82.9877 1 0.9279 0.9279
Brueton17.55135 2 7.6923 3.8462
Bryn Bach80.41164 1 2.0395 2.0395
Burnham and Highbridge106.2292 1 0.8661 0.8661
Bushy parkrun109.0267 1 0.6146 0.6146
Cannock Chase7.5997 2 12.7800 6.3900
Cannon Hill12.5152 1 12.1600 12.1600
Cardiff94.25262 1 2.7798 2.7798
Carlisle158.72107 1 0.6741 0.6741
Chasewater2.4759 2 23.8866 11.9433
Churchfields Farm27.59106 1 3.8420 3.8420
Clifton38.7173 2 1.8858 0.9429
Conkers19.3381 2 4.1904 2.0952
Coventry24.8165 2 2.6199 1.3100
Darndale183.37119 1 0.6490 0.6490
Dudley11.956 2 4.7059 2.3529
East Park parkrun6.6349 3 7.3906 2.4635
Felixstowe147.43108 1 0.7326 0.7326
Hanley27.8996 1 3.4421 3.4421
Hazlehead311.83203 1 0.6510 0.6510
Highbury Fields108.84144 2 1.3230 0.6615
Isabel Trail14.0695 2 6.7568 3.3784
Kingsbury Water12.1779 2 6.4914 3.2457
Ludlow38.8888 1 2.2634 2.2634
Lytham Hall87.71229 1 2.6109 2.6109
Markeaton28.66125 2 4.3615 2.1807
Newcastle163.3147 1 0.9002 0.9002
Newport86.58163 1 1.8827 1.8827
Oaklands12.8558 1 4.5136 4.5136
Perry Hall7.5598 7 12.9801 1.8543
Pontypridd91.7594 7 1.0245 0.1464
Queen's Glasgow240.0855 1 0.2291 0.2291
Riverfront84.03163 1 1.9398 1.9398
Rosliston16.22215 1 13.2552 13.2552
Ruchill243.486 4 0.3533 0.0883
Rugby35.3759 2 1.6681 0.8340
Sandwell Valley7.43109 6 14.6703 2.4450
Severn Valley Country20.6575 1 3.6320 3.6320
Shipley Country36.4382 1 2.2509 2.2509
South Oxhey95.7252 2 0.5433 0.2716
Stranmillis College210.99103 1 0.4882 0.4882
Sutton Park6.4259 2 9.1900 4.5950
Swansea Bay110.2968 4 0.6166 0.1541
Telford20.36169 1 8.3006 8.3006
The Wammy29.1691 1 3.1207 3.1207
Volksgarten368.0672 1 0.1956 0.1956
Walsall Arboretum2.8862 113 21.5278 0.1905
Warwick Racecourse28.6869 1 2.4059 2.4059
Wolverhampton7.8141 2 18.0769 9.0385
Woodhouse Moor83.21110 1 1.3220 1.3220
Worcester Pitchcroft31.5678 1 2.4715 2.4715
Wyre Forest24.88100 1 4.0193 4.0193
Montsouris323.4287 2 0.2690 0.1345

Elliott’s formula takes into account travelling time and time since his last visit to each parkrun. I was not happy with using travelling time as it seems too inconstant, so instead I decided to use the distance (in miles) between my home and each parkrun. To this end I added the coordinates for each event I have visited to this here website, and only later realised that I had no way of converting these into distances with the basic tools at my disposal, so I had to resort to using a spreadsheet instead and paste the resulting answer back into the website. Storing the location of each event was not entirely wasted, as it allowed me to display my Graticule Bingo.

Counting the weeks proved to be much easier, but then came the problem of the calculation. Elliot’s formula did not seem to produce sane results for me, as it was optimised to use minutes not miles and then only less than around 60 of them. I tried a few diffrent options in the spreadsheet, and ultimately (for now) settled on the simplest one “Weeks divided by Miles”.

As with most tables on this site there is some javascript that allows it to be sorted by any column, so by clicking on the W/M header I can get this otherwise alphabetical list of parkruns to sort by my MOFAR.

I’ll just leave this here for next time I need it…

=ACOS(COS(RADIANS(90-52.6289)) *COS(RADIANS(90-B3)) +SIN(RADIANS(90-52.6289)) *SIN(RADIANS(90-B3)) *COS(RADIANS(-1.96705-C3))) *3958