Online Tutorial for Data Analysis and Automation
Google-Sheets-Templates
One Google Sheet with 16 columns per session, five dropdowns from a single List tab, three self-filling formula columns, an Average Progress Score card and four live charts for logging therapy attendance, progress and mood. An organisational log – not clinical software, not an EHR, and not HIPAA-compliant storage.
A four-tab daily journal tracker in Google Sheets: a 16-column log, six columns that calculate themselves, a Wellbeing Score out of ten and four charts that read the journal rows directly.
A fire safety audit management system web app with 22 screens, 6 roles, weighted compliance scoring, derived site risk, a 1,677-asset register and 15 reports.
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.
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.
Manage clients, brands, projects, briefs, design jobs, revisions, approvals, assets, time, invoices, payments and profitability in one agency web app.