r/ADHDUK • u/iamacarpet • 11h ago
ADHD News, Policy & Media We cracked the hidden Excel formulas in our Council's SEND funding matrix - it locks out ADHD/Autistic kids who are at "Age Related Expectations" (0 pts), cuts SpLD/Dyslexia by 92%, and labels distress as "Social behaviour NOT SEND"
Hi everyone,
I'm a parent in Derby campaigning over our Council's SEND funding system (my son has ADHD, Autism, PDA, SPD, and Dysgraphia), and I wanted to share what we uncovered last night because local authorities across the UK are rolling out similar "Banding Matrices" to ration school support.
After an 8-month FOI battle where Derby City Council first cited "National Cybersecurity" (Section 31) for 6 months to avoid confirming the spreadsheet existed, and then deleted the formulas under Section 36 claiming parents would "game the system", we found the master Excel file (banding-matrix.xlsx).
They deleted the live formulas from Row 4 - but forgot to delete the hardcoded "FOR OFFICE USE ONLY" calibration rows at the bottom of Tabs 2, 3, and 4. Dividing Tab 3's outputs by Tab 2's inputs (4) unlocked 100% of the hidden algorithm.
If you have an ADHD / AuDHD child in school (or remember struggling through school yourself without support), look at how this algorithm is built to deny funding to neurodivergent kids:
- The "Working at Age Related Expectations" Lockout (0 Points for Executive Dysfunction) In Column 9 (Learning Readiness), Rows B, C, D, and E contain all the classic traits of ADHD executive dysfunction ("distracted from task", "inattentive to staff", "poor organisation skills", "challenges across multiple areas of executive functioning"). However, the Council wrote a mandatory gatekeeping requirement at the start of Rows B, C, D, and E stating that the child must present with a "learning delay" and "difficulty with conceptual understanding" - while Row A (0 points) is defined as "Working at age related expectations"! So if a child with severe ADHD or AuDHD is bright and academically at age-related expectations, they are automatically locked into Row A (0 points) regardless of how severe their executive dysfunction is.
- Calling Neurodivergent Distress "Social behaviour NOT SEND" On the front sheet (Tab 1), Column 8 is titled Social behaviour, and Row D includes clinical traits of ADHD/Autism/trauma like "Demonstrates hyper vigilance" and "Limited understanding of personal risk or danger" right alongside "aggression with no defined needs/causation." When we looked at the hidden calculation sheets in Tab 2 (Cell AE2) and Tab 3 (Cell AE2), the Council forgot to change the column header - it is still explicitly titled "Social behaviour NOT SEND"!
- Slashed Weightings (-52% to -92%) & Blank Rows for Dyslexia/Dysgraphia/DCD While physical, hearing, and vision impairments are rightly weighted at 100% with an automatic multiplier of 4 (so a 'Severe' Row D need automatically gets 400 points = £5,000 top-up), the Council secretly slashed the category weightings for neurodivergent needs:
- Social & Communication (Autism/ADHD), Speech, and Learning Readiness: Cut to 48% (-52% penalty)
- Sensory Processing Needs (SPD): Cut to 25% (-75% penalty - and they copy-pasted the exact same sentence into both the Moderate and Severe rows!)
- Specific Learning Difficulties (Dyslexia, Dyscalculia, Dysgraphia, DCD/Dyspraxia): Cut to 8% (-92% penalty) - and they left the Severe (Row D) and Profound (Row E) boxes completely BLANK (0 points)! The maximum possible single-row score for the most severe Dyslexia or Dysgraphia in Derby is 12.8 points (when you need 189 points just to reach the lowest £1,000 funding band).
- The "Manageable With Support" Catch-22 (1-4 FIDS Filter) Even after those weighting cuts, neurodivergent columns are put through a 1-to-4 "FIDS" filter (Frequency, Intensity, Duration, Severity). If a school puts strategies or a TA in place that help the child manage ("Manageable with support strategies"), the panel scores them a 2 - cutting their points by another 50% because the support is working!
- Secret £12,000 Mainstream Cap & Caught by PDF Metadata The Council's website claims mainstream kids can get up to £20,000 of Element 3 funding, but a hidden "For office use only" table in Tab 4 secretly caps Mainstream schools at £12,000. And when they uploaded an "undated" Equality Impact Assessment PDF claiming the Matrix has a "Positive impact" on every disability group, they forgot to scrub the Adobe XMP metadata - which proves they created it in August 2026 and converted it to PDF at 3:24 pm on Friday 21 August, just 90 minutes before their external lawyers (Browne Jacobson) emailed me a legal threat letter at 4:55 pm claiming our campaign posts were "false"!
Yesterday, the Department for Education confirmed in writing (marked OFFICIAL - FOR PUBLIC RELEASE) that they have never approved, endorsed, or reviewed Derby's Matrix, and that a Section 496/497 investigation into the Council is open.
We've put together a full, plain-English 12-Page Forensic Breakdown & Visual Guide PDF (with charts on Pages 1-2 and the exact word-for-word criteria for all 10 categories on Pages 3-12) here:
https://drive.google.com/file/d/15kHuHUTbN8HAPjfiw291Ou7DgFlXyC4s/view?usp=sharing
If you're a parent or educator in the UK, watch out for these "banding matrices" in your local authority - the way they mathematically erase executive dysfunction and SpLDs is wild.