A tracker is a grid that counts itself: mark a day, log a movement, type a quantity, and the totals, streaks and flags appear. Three of them here, all without macros.
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.
Stock levels, reorder points and stock value for Excel and Google Sheets, every number a visible formula. Status turns yellow at the reorder point and red at zero. Pro adds a Movements log that updates quantities, a Reorder list with the cost to restock, a Dashboard by category, and a formulas walkthrough.
Habits down the side, days across the top, a mark when you did it. Done counts, a monthly target scaled from your weekly one, completion bars, weekends shaded. Pro adds current and best streaks with the running count on its own sheet, a by-week view, and a formulas walkthrough. No macros.
The trackers share one idea: the input is a mark in a cell — a 1, a letter, a quantity — and everything else is a formula reading the grid. COUNTA and COUNTIF do the counting, conditional formatting does the colouring, and the totals sit where you’d look for them.
Streak works out current and best streaks with a running count you can see on its own sheet. Roll turns letters into attendance percentages that count Late as present and leave holidays out. Shelf turns opening stock plus movements into on-hand quantities and a reorder list — without the FILTER function, so it works in Excel 2016 and Numbers.
The main grid — habits, attendance or stock — with counts and colours, and a credit line kept. Pro adds the summary sheets, logs, Setup and the formulas walkthrough.
Streak for personal habits by day; Roll for attendance of a class, team or shift; Shelf for stock levels with reorder points and a movements log.
Yes — the day header is a formula on the month's length, and days past the end are greyed out and excluded from counts.
The main grid with its counts and colours, with a credit line kept. Pro adds streaks, summaries, movement logs and the formulas walkthrough.