Online Tutorial for Data Analysis and Automation
A Google Apps Script web app that runs a civil contracting business end to end – tenders, projects and BOQ, daily progress, labour muster, stores, plant, subcontractors, RA billing, receipts and retention across twenty modules, six roles and sixteen reports. Free live demo with all six role logins.
A production-reporting dashboard for chemical plants built entirely in Google Sheets: 6 tabs, 16 KPI cards, 18 native charts and 15 slicers over a 380-batch demo dataset covering output, yield, OEE, cost and margin.
A six-page Power Generation Dashboard in Google Sheets built on native pivot tables and slicers – 16 KPI cards, 18 charts and a record lookup covering MWh, capacity factor, availability, outage hours, revenue and margin across your generation fleet.
A formula-driven Google Sheets KPI scorecard for internal communications: 14 comms KPIs, a single month picker, MTD and YTD traffic lights, a KPI Trend page and a KPI Analysis page. No add-on, no Apps Script, no connector.
A Google Apps Script web app that runs a ready-mix and cement supply business end to end: 22 modules, 7 roles, 17 reports and a seeded database. Free live demo.
A formula-driven Google Sheets KPI scorecard that tracks 14 workplace safety KPIs – TRIR, LTIFR, DART Rate, near-misses, PPE compliance and more – with a month picker, MTD and YTD traffic lights, a 12-month trend page and a group analysis page. No add-ons, no scripts.
A Google Apps Script web app that keeps the whole chit book in one place – 16 chit groups, 92 subscribers, 220 auctions and 4,920 receipts seeded on first run, six roles, eighteen reports and a live demo you can sign into right now. Record-keeping software only: it does not register, license or make compliant any scheme.
A walkthrough of the Running Log & Mileage Tracker in Google Sheets – the total mileage card, the four charts, the 15-column log, the four self-calculating columns, and how to set it up in five minutes. A logging template, not medical or coaching advice.
A one-page Cycling Training Log Tracker in Google Sheets: 16 fields per ride, 4 self-calculating columns, one Total Distance KPI card and four live charts. A logging template – not medical or coaching advice.
A walkthrough of the Oil & Gas Dashboard in Google Sheets – 6 tabs, 16 KPI cards, 18 pivot-driven charts and 15 native slicers for production, uptime, operating cost and netback reporting, with 500 rows of labelled demo data to start from.