Hopefully you find it useful:

https://1drv.ms/x/s!AqttyoLasQwpin9YWI2 ... q?e=OxBrvL

Link should now work;

Outer Catchment Cut-off - Rough Prediction - Judd.xlsx

Very well done.

That's brilliant, working now - thanks for sharing your hard work Fibonacci!

Amazing analysis, but you didnt mention how much score you son scored

also can you please let me know what is the cut off prediction for Dartford boys, we live miles away (west london)..my son scored 400...

...son did well but he is just about accepting that himself. In his own super competitive world he feels he 'bombed' (scored between 410-415) and particularly maths was not 141, and to worsen things scoring slightly below what DD got last year. So I just did this s/sheet to try and convince him about his chances - that he did well and would (most probably) get into The Judd.

The s/sheet can be tweaked to work for different catchments etc the providing there is right data on previous intake numbers/cut-offs etc and most importantly time. Lets see what the weekend or coming week holds.

Incredible analysis.
Whats your best estimate of inner for Judd ? 390?

......there's been request for Judd 'Inner Catchment'......
Note that two equally consistent approaches were used for Judd OOC in the earlier link shared, but only the alternative method has been extended to include Judd IC in order to give a very quick and rough idea:

https://1drv.ms/x/s!AqttyoLasQwpjBtkQNT ... C?e=fF2wgz

Thanks so much for taking the time to do this!
This is similar to Arewenearlythereyet’s estimate on another thread.

Let’s see in March, it’s crazy high!!!!!

Another effect of all this is the boys in TWGSB’s scores are going to be higher due to people far from skinners who don’t make the Judd cut-off.

Makes 3 quite different and strong schools now!