Online Tutorial for Data Analysis and Automation
The Knowledge Management Dashboard in Google Sheets tracks 16 KPI cards and 16 slicer-driven pivot charts across six tabs, on 500 sample knowledge base articles. Measure cost savings, readership, content mix and review health, then look up any article by ID.
A six-page Google Sheets dashboard for tracking audit engagements, findings, exposure value and control categories – built on native pivot tables and slicers, with 500 sample audits already loaded.
A Google Apps Script web app that runs the whole drawing issue-and-approval loop for an architectural practice: one current revision per sheet, transmittals that start the review clock, comments that cannot close without a resolution, and an overdue list computed from dates. Six roles, 15 pages, 12 reports – with a free live demo you can sign into right now.
A walkthrough of the Quarterly Tax Payment Tracker in Google Sheets – the Total Tax Paid card, four live charts, the 16-column register, and the four columns that calculate Balance Due, % Paid and Days to Due for you.
A one-page Utility Bills & Usage Tracker in Google Sheets: 11 utility types, 16 data columns, 4 automatic charts and a live Total Amount Due card. Track due dates, spot price hikes with Change %, and see your real cost per kWh, gallon or GB — for a one-time $6.99, with no bank login and no subscription.
A Google Apps Script Hospital Management System Web App with 20 screens, 8 role-based logins and 33 database sheets – patients, appointments, doctors, beds, pharmacy, laboratory, billing, insurance and documents in one Google Sheet. Live demo you can sign into, full source code included. Administrative records only, not a clinical or certified EHR system.
A Google Apps Script delivery system with 17 role-gated modules for projects, sprints, tasks, defects, releases, timesheets and invoices – with a live demo.
A Google Apps Script web app for airport transfer and chauffeur operators: 34 role-gated pages, flight-derived pickup times, a 160-row tariff matrix, four driver payout models and 22 reports – with a live demo you can sign into before you buy.
A six-page Google Sheets dashboard for transport operators – 500 sample trips, $215,597 of revenue, 16 slicers and 16 charts built on native pivot tables. Walk through every page, see what it does well, and learn where it stops.
A pivot-and-slicer Google Sheets dashboard for housing programmes: 16 KPI cards, 16 charts and a project lookup across 6 tabs, sized for 1,000 project rows.