Online Tutorial for Data Analysis and Automation
A 30-screen Google Apps Script web app that runs a CrossFit box end to end – members, plans, memberships, timetable, WOD programming, PRs and leaderboards, the retail counter, invoices, payroll and 21 reports. Live demo with every seeded login inside.
A module-by-module walkthrough of the Courier & Parcel Delivery Management System Web App – 28 modules, 17 reports, 6 roles and a live demo you can sign into as any of eight seeded accounts. Runs on Google Apps Script in your own Google account.
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.