Online Tutorial for Data Analysis and Automation
A finished Google Apps Script back office for concert promoters: 24 modules, 16 reports and 6 roles on your own Google Sheets database. Ticketing that cannot oversell, a gate that scans once, and settlements that reconcile with your co-promoter. Live demo with every role login.
A one-page Google Sheets log for lab results and health metrics: 16 columns, 6 auto formulas, 4 live charts and an abnormal-results counter. A personal record only – not medical advice, not diagnostic, and it never interprets a lab value.
One Google Sheet with 16 columns, 6 dropdowns, 3 self-filling formula columns, an Avg Pain Score card and 4 live charts for logging symptoms, pain scores, triggers and relief. A personal diary – not a medical device, not diagnostic, and not medical advice.
A shared on-call diary in Google Sheets: 100 sample duties across 2026, 19 duty types, 31 named locations, and Annual, Monthly and Daily views driven by one entry table. A scheduling spreadsheet – not a clinical system, not a patient record, and not a paging or e-rostering platform.
Track 10 welding shop KPIs on one page in Google Sheets – weld defect rate, first-pass yield, arc-on time, downtime and cost per kg deposited – with red-amber-green status dots, targets, prior-year comparison and 12-month trends.
The Masonry Contractor KPI Scorecard in Google Sheets tracks 10 masonry KPIs across 5 groups on 4 sheets, with traffic lights, a month picker, MTD/YTD switching and Actual vs Target vs PY trend charts.
Track 14 plumbing KPIs across 5 groups in Google Sheets. One month picker drives MTD and YTD achievement, traffic lights, a per-KPI trend page and a group analysis page. No add-ons, no scripts.
A formula-driven Google Sheets scorecard tracking 14 risk mitigation KPIs across 6 groups, with MTD and YTD achievement, prior-year comparison and traffic lights driven by a single month picker. No add-on, no script. A reporting sheet, not a risk management system.
A one-sheet blood sugar log in Google Sheets: an average glucose card, four linked charts and a 16-column entry table with your own per-row target ranges. A personal record-keeping template only – not medical advice, not a medical device.
A one-page Google Sheets log for home blood pressure readings: 15 columns, 4 live charts, an average systolic card and editable dropdowns. A personal record only – not medical advice, not a diagnostic tool.