Running a small business on spreadsheets
Practical guides for small teams that run on spreadsheets: tracking stock, orders and quotes in Google Sheets, and asking a sheet questions from an AI assistant.
How to set a reorder level for each product in a spreadsheet
Work out a reorder level for every product from your own sales and supplier lead times, with three Google Sheets formulas and a worked example.
Spreadsheet or app: when should a small business switch?
A plain way to decide whether to keep running stock, orders or quotes on a spreadsheet or move to dedicated software, with the real costs of each.
How to ask a Google Sheet questions from ChatGPT or Claude
Three ways to ask an AI assistant about a live Google Sheet, what each one is good for, and where each goes wrong.
How to track inventory in Google Sheets
Set up a two-tab stock tracker in Google Sheets that works out stock left, stock value and what to reorder, using three formulas.