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
Walsall Arboretum2.88
Perry Hall7.55140 7 18.54 2.65
Cardiff94.25304 1 3.23 3.23
Pontypridd91.75136 7 1.48 0.21
Coventry24.81107 2 4.31 2.16
Swansea Bay110.29110 4 1.00 0.25
Lytham Hall87.71271 1 3.09 3.09
Conkers19.33123 2 6.36 3.18
Rosliston16.22258 1 15.91 15.91
Wolverhampton7.8183 2 23.46 11.73
Hazlehead311.83245 1 0.79 0.79
Cannock Chase7.59139 2 18.31 9.16
Rugby35.37101 2 2.86 1.43
Kingsbury Water12.17121 2 9.94 4.97
South Oxhey95.7294 2 0.98 0.49
Markeaton28.66167 2 5.83 2.91
Blackpool92.65219 1 2.36 2.36
Dudley11.998 2 8.24 4.12
Sandwell Valley7.43151 6 20.32 3.39
Telford20.36211 1 10.36 10.36
Bryn Bach80.41206 1 2.56 2.56
Riverfront84.03205 1 2.44 2.44
Newport86.58205 1 2.37 2.37
Ruchill243.45 5 0.02 0.00
Brueton17.55177 2 10.09 5.04
Highbury Fields108.84186 2 1.71 0.85
Clifton38.71115 2 2.97 1.49
Cannon Hill12.5194 1 15.52 15.52
Bevendean Down146.69126 2 0.86 0.43
Darndale183.37161 1 0.88 0.88
Isabel Trail14.06137 2 9.74 4.87
Sutton Park6.42101 2 15.73 7.87
Arrow Valley22.31153 1 6.86 6.86
Woodhouse Moor83.21152 1 1.83 1.83
Felixstowe147.43150 1 1.02 1.02
Carlisle158.72149 1 0.94 0.94
Bedworth23.3995 3 4.06 1.35
Stranmillis College210.99145 1 0.69 0.69
Montsouris323.42129 2 0.40 0.20
Wyre Forest24.88142 1 5.71 5.71
Hanley27.89138 1 4.95 4.95
Burnham and Highbridge106.22134 1 1.26 1.26
The Wammy29.16133 1 4.56 4.56
Alvaston29.19131 1 4.49 4.49
Ludlow38.88130 1 3.34 3.34
Chasewater2.4710 4 4.05 1.01
Shipley Country36.43124 1 3.40 3.40
Babbs Mill13.36122 1 9.13 9.13
Worcester Pitchcroft31.56120 1 3.80 3.80
Bramley82.98119 1 1.43 1.43
Severn Valley Country20.65117 1 5.67 5.67
Volksgarten368.06114 1 0.31 0.31
Warwick Racecourse28.68111 1 3.87 3.87
Bushy parkrun109.02109 1 1.00 1.00
East Park parkrun6.637 4 1.06 0.26
Oaklands12.85100 1 7.78 7.78
Queen's Glasgow240.0897 1 0.40 0.40
Beacon6.6792 2 13.79 6.90
River Valley186.5193 1 0.50 0.50
Nobles148.3119 1 0.13 0.13
Fairview184.296 1 0.03 0.03
Potternewton84.173 1 0.04 0.04

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