GCSE Dance Spreadsheet with weightings / formulas to help forecast pupils levels (1-9)

This resource is for teachers of GCSE dance who want to forecast what levels their dancers will get in their GCSEs based on the 2018 grade boundaries.
Either use it to keep an up to date track of pupils scores from their assessments or use it to enter predicted scores, guide conversations with pupils or to answer questions such as ‘how many more marks would I need to get a level…”
Cells coloured in a peach colour are cells that contain formulas. I have coloured them to remind me to not touch them.
I recommend keeping a copy of the original file just in case something vital to making the spreadsheet run smoothly is accidently deleted.