Students down the side, assessments across, with max points and a weight for each; the weighted percentage and letter grade follow, with class average, median, highest, lowest and missing per assessment and a grade distribution. Pro adds a per-student Report with rank and an Assessments sheet showing which was hardest. No macros.
40 students × 6 assessments; max points and weight rows; weighted % with bars, letter from bands you set, assessments done; class average, median, highest, lowest and missing per assessment; letter distribution. Blank scores red, scores over max pink.
Per student: weighted %, letter, rank, done, missing, best and weakest assessment as a share of its max.
Average % of max, median, high, low, done and missing per assessment; hardest, easiest, class average.
Assessment names, grade bands with letters.
Seven formulas explained, including MATCH type 1 for bands and SUMPRODUCT(MAX()) for a row's best.
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
Six assessments with a max and a weight each. A student’s grade is Σ (score ÷ max × weight)
÷ Σ weights — one SUMPRODUCT — and the letter comes from bands you can edit, found with
MATCH type 1 on ascending thresholds rather than a chain of IFs. A blank score is a zero
and turns red; a score above the max turns pink. Under the class: average, median, highest,
lowest and missing per assessment, and how many of each letter.
Report gives one line per student with rank (how many are above, plus one), done and missing, and their best and weakest assessment as a share of its max. Assessments turns the table sideways: average % of max, median, high, low and missing per assessment, and which one was hardest.
One of those formulas is worth knowing: a row’s best score-over-max is
SUMPRODUCT(MAX(scores/maxes)). A bare MAX(scores/maxes) silently returns only the first
cell in Excel 2016 and LibreOffice — the build caught it.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares twenty-eight values — weighted percentages and letters, class median, missing counts, the distribution, ranks, best and weakest, per-assessment averages — against numbers computed outside Excel.
First release
One row per medicine with its strength, dose and the times of day it's taken; the week grid records doses actually taken and works out adherence against what was due. Pro adds a refill planner — units used a day, days left, the date it runs out and the date to order — and a dated dose log. A tracker, not medical advice. No macros.
One row per goal or KPI: start, target, current, dates, owner. Progress, expected progress from the calendar, days left and a status — Done, On track, Behind, Overdue — are calculated. Pro adds monthly check-ins that feed the current value, and a view by area and by owner. No macros.
One row per service or repair with the odometer and the next-due the garage gave you; days and km to each, overdue and due-soon flags, cost this year. Pro adds a Vehicles sheet with cost per km and tax, insurance and inspection reminders, and a service schedule that reads last-done from the log. No macros.