Grade Boundary Calculator

I have been looking for a spreadsheet to enter all the mock data in and then have it do the grade work for me to help with my analysis. I couldn’t find one so i created this, feel free to improve the design.
Simply enter the grade boundaries for each subject on the right hand columns and then enter in the % or raw score as desired, ensure they are the same for the raw score and grade boundary.
For GCSE where there are the Foundation and Higher paper options the formula will look at which paper was undertaken and calculate the grade according to the boundaries your set. Simply amend with a F or H…
Happy calculating