Pivot tables
Most graders todayChecks only that a pivot exists
GridGradeFull structure: placement, aggregation, filters, Show Values As, stale source
Power Query
Most graders todayCan't grade it
GridGradeGrades the query a student built — joins, grouping, step order — and checks it against the expected result
Multiple valid methods
Most graders todayOne rigid right answer
GridGradeCredits every valid method — a formula, a pivot, or Power Query — that reaches the right answer
Answer moved or sheet renamed
Most graders todayBreaks on fixed cells
GridGradeFinds the answer even if a student moved it or renamed the sheet
Partial credit
Most graders todayLimited carry-through
GridGradeDependency-aware: a correct step on a wrong upstream value isn't double-penalized
Feedback
Most graders today“Cell B7: Incorrect”
GridGradeEvidence + reason + a fix suggestion on every deduction
“Most graders today” reflects publicly documented capabilities of common spreadsheet auto-graders.