Names down the side, days across, one letter per cell — P, A, L, E, H — from a dropdown, coloured. Counts per person, attendance % that counts Late as present and leaves holidays out, present per day, weekends shaded. Pro adds a Summary with bars and flags, holidays from Setup, and a formulas walkthrough. No macros.
Ten people × 31 days, code dropdown with colours (green P, yellow L, red A), present/late/absent/excused counts, days logged, attendance %, present per day, group attendance. Weekends shaded.
Everyone with attendance % as a bar, counts by reason, below 90% in red, three or more absences highlighted; group %, how many below 90%, most absences, best attendance.
Month, names, the code list as a named range, up to twenty holiday dates that grey their columns and drop out of the day count.
Eight formulas explained.
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.
P present, A absent, L late, E excused, H holiday — from a dropdown, so nobody types “p” in
one cell and “Present” in another. Five codes instead of two, but the mechanism is the one in
the Yes/No drop-down guide: a validated list, a colour per answer, and COUNTIF doing
the counting. Attendance % is Present plus Late over days logged: someone
who came late still came, a holiday isn’t held against anyone, and a day you haven’t logged
yet doesn’t pull the number down. Below 90% turns red.
The Summary sheet ranks everyone with a bar, flags three or more absences, and names the best and the worst. Holiday dates on Setup grey out their columns on the Month grid and drop out of the day count — a COUNTIF against a named range, shown on the Formulas sheet.
The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample month and compares twelve values — counts per code, attendance for a person with absences, present per day, the group figure, the below-90% count — against numbers computed outside Excel.
First release
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.
One row per application: company, role, stage, dates, next step. Days waiting and which applications need a nudge are calculated; active, interviews, offers and response rate are kept at the top. Pro adds a Pipeline sheet with conversion between stages and results by source, and a Follow-ups sheet that lists what needs doing. No macros.
One row per request — who, what kind, from, to — and the working days are counted for you, weekends out. Balances per person against an annual allowance. Pro excludes public holidays, adds an approval status, a Balances sheet per person and type, and a month calendar showing who's off on which day. No macros.