Online Tutorial for Data Analysis and Automation
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.
A formula-driven Google Sheets scorecard for masonry firms: 15 KPIs in 5 groups, MTD and YTD side by side, a month dropdown, traffic lights, and dedicated KPI Trend and KPI Analysis pages.
A one-page Google Sheets fasting log: type Fast Start and Fast End and it returns fasting hours across midnight, the eating window, % of your own target and a Yes/Close/Short verdict, plus four live charts. A personal record – not medical advice, and it sends no reminders.
A Google Apps Script web app for collection agencies – 38 screens, 8 server-enforced roles, 36 tables and 28 reports, from creditor placement through activity, promises, plans and settlements to a client remittance statement that must reconcile. Live demo with every login published.