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.
SKU, item, category, unit cost, on hand, reorder point, reorder quantity, value, status. Totals for stock value, items to reorder and units on hand. In Pro, on hand = opening + in − out.
Date, SKU from a dropdown, In or Out, quantity, note. The Item column looks the SKU up and shows 'unknown SKU' in red for typos.
Only the items at or below their reorder point: on hand, order quantity, unit cost, order value, and the total to restock. Works without FILTER, so Excel 2016 and Numbers are fine.
Items, units, value and reorder count per category with data bars; out of stock, below reorder point, cost to restock everything, most valuable item.
Categories as a named range for the Stock dropdown and the Dashboard.
Eleven 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.
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.
Each item has a reorder point and a reorder quantity. Status is a nested IF you can read: nothing left → Out of stock, at or below the point → Reorder, otherwise OK — and conditional formatting colours the word. The totals at the bottom and the top give stock value and how many items need ordering.
Type every receipt and sale on Movements — the SKU is a dropdown, and the sheet names the item beside it or says “unknown SKU” in red. Stock’s on-hand column becomes opening + in − out. The Reorder sheet shows only the rows that need ordering, with the cost to restock; the Dashboard breaks value and health down by category. Physical count? Type it into Opening and clear the old movements.
The Reorder sheet mirrors Stock row by row with an IF, rather than using the FILTER function, so it works in Excel 2016 and Numbers, not just Microsoft 365. The Formulas sheet explains the trade-off.
The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample stock and movements and compares thirteen values — on-hand after movements, stock value, reorder count, restock cost, value by category — against numbers computed outside Excel.
First release
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.
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.
A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.