Online Tutorial for Data Analysis and Automation
A full sound, light and stage hire desk in one Google Apps Script web app – 182 tagged assets, availability checks across a date window, dispatch and return with condition grading, crew rostering, invoices and 49 printable reports. Try the live demo with all nine seeded logins.
The Clinics Dashboard in Google Sheets turns one visit log into four report pages with 18 charts, 15 slicers and a Visit ID search – across 500 sample visits, 8 clinics and 12 providers, with no patient identifiers in the data model.
The Hospitals Dashboard in Google Sheets reports on an admissions log across six linked tabs – 16 KPI cards, 18 charts and 15 slicers driven by native pivot tables. A static reporting template: no EHR connection, no clinical data.
An appointment calendar for a small animal practice built in one Google Sheet: Annual, Monthly and Daily views over a single 100-row Events table, 18 appointment types and 13 clinic locations. No scripts, no add-ons, no subscription – and an honest list of what it does not do.
The Home Nursing Visit Calendar in Google Sheets is a ready-to-copy scheduling workbook with six tabs, three linked calendar views and 100 verified sample visits across 2026, covering 16 visit types in 15 locations. It is a scheduling spreadsheet only – not a patient record, not an EHR/EMR and not a care-planning or visit-verification system – and it holds no patient name, ID or contact column at all.
Track ten pool service KPIs on one screen in Google Sheets – month picker, red/amber/green traffic lights, MTD and YTD against target and prior year, a KPI trend page and written formulas for every metric.
Ten fencing KPIs on one Google Sheets page – month picker, MTD/YTD switch, direction-aware traffic lights, 12-month sparklines and a KPI trend page. A tab-by-tab walkthrough of what the scorecard does, what it does not do, and how it differs from the Excel edition.
Track ten paving contractor KPIs on one screen in Google Sheets – month picker, MTD/YTD against target or prior year, red/amber/green traffic lights, a KPI trend page and a written formula for every metric.
A complete Google Apps Script trading system for electrical wholesalers: 24 screens, 18 reports, 6 roles and 41 permissions, multi-warehouse stock, price-list slab discounts and an ageing receivables book – with a free live demo you can sign into as every role.
The Welding Shop KPI Dashboard in Google Sheets tracks 15 fabrication KPIs across 5 groups with MTD and YTD achievement, editable traffic lights, a month picker, a KPI Trend page and a KPI Analysis page – all plain worksheet formulas, no add-ons.