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.
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.
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
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.
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.