Online Tutorial for Data Analysis and Automation
A finished Google Apps Script web app for escape room venues: day-grid schedule, slot-factor pricing, booking lifecycle, game results and leaderboard, payments, invoices, vouchers, promo codes, props and 20 reports across 8 server-enforced roles. Live demo inside.
A full walkthrough of the Gaming Zone & Arcade Management System Web App – time-billed stations, prepaid game cards and ticket balances, bookings, tournaments, party packages, a costed snack bar, a prize counter and 13 reports, with a live demo and eight seeded logins.
A six-tab Google Sheets calendar for diagnostic centres and preventive-health clinics: 100 sample bookings, 16 checkup package types, 28 clinic rooms, and four linked views. No patient data fields, by design.
Plan and review administrative bed-turnover events with annual, monthly, daily, and central event-register views in Google Sheets.
Ten elevator maintenance KPIs on one Google Sheets board – uptime, callbacks, MTTR, entrapment response, PM completion, overdue work orders and more – with a month picker, MTD/YTD basis, Target or prior-year comparison and direction-aware traffic lights.
Track 10 solar installation KPIs with actual-versus-target cards, MTD and YTD trends, prior-year comparisons, and editable definitions in Google Sheets.
Track 13 locksmith KPIs in Google Sheets with a month picker, MTD and YTD traffic lights, per-KPI trends, group analysis, targets and prior-year comparison.
Track 14 pest control business KPIs with monthly and YTD comparisons, traffic-light status, trend charts, and group analysis in Google Sheets.
A 14-column Google Sheets register for freelance invoices and costs, with 5 auto columns, a net profit card and 4 live charts. A record, not tax software.
A manual screen time log in Google Sheets: 15 columns, 5 formulas, 4 charts and a 33.3 h headline card across 4 tabs. It does not measure or block anything – you type the numbers in.