Online Tutorial for Data Analysis and Automation
Google-Sheets-Templates
A complete Amusement Park Ticketing Management System Web App built on Google Sheets and Google Apps Script – 22 screens covering counter sales, gate scanning, season passes, rides, safety, cash reconciliation and 20 reports, with 5 server-enforced roles and a live demo you can sign into right now.
A bed-level hostel management system built as a single Google Apps Script web app: a fourteen-night bed board, self-posting folios, a cafe till, 17 exportable reports, 7 roles and 10 rules the server refuses to break. Free live demo with every role login.
A walkthrough of the Gym Personal Records (PR) Tracker in Google Sheets – the Total PRs Logged card, four live charts, the 16-column register, and the five columns that calculate Est. 1RM, Gain, Strength Ratio and % to Goal for you.
A one-page Google Sheets workout log with a live Total Volume Lifted KPI card, four auto-updating charts and a 15-column session table. Here is how every part of it works, what it does well, and where it stops.
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.