Tag
#Spreadsheets
4 articles
CSV export problems: what the file leaves behind
A sample customer export, taken row by row: the leading zeros, dates, accents and commas that go wrong when a CSV is opened or imported, and how to check each one. It also covers how fast a copy goes stale and how often to regenerate it.
Why double bookings happen, and how to stop them
The five usual causes of double bookings, seven steps that close the gap, a worked example with two rooms and three therapists, and the tests to run before a booking app takes real customers.
Turn an Excel report into a dashboard you can trust
A worked guide to rebuilding a weekly Excel report as a dashboard: the jobs the report does, a metric-definition table, workbook traps to clear, ten rows to check by hand and a plan for new figures.
How to turn an Excel spreadsheet into an app
A step-by-step guide to turning an Excel workbook into a web app. It works through a sample job sheet with an audit checklist, a column-mapping plan, formulas rewritten as rules and a test script.