SEND Data Automatically Calculate and Present

I have created an Excel spreadsheet for SENCOs to store their SEN lists on which automatically calculates and presents data in a range of charts. All you need to do is keep a few things (list, on roll pupils and national data) up to date manually and it will pull through to present data such as: % of SEN need vs no identified need for on roll pupils; Boys vs girls on the SEN list; % EHCPs; % of SEN per cohort; Comparisons to national data, % areas of need and % of each cohort that makes up the SEN list.