Online Tutorial for Data Analysis and Automation
A working Google Apps Script web app that runs the commercial side of an architecture practice: 20 modules, 6 roles, a seven-stage fee schedule, timesheets, invoicing and a margin that is computed rather than typed. Includes a live demo you can sign into as any role.
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 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 25-page Google Apps Script booking system for adventure operators: sessions and seat capacity, waivers that block boarding, gear inspections, guide certifications, payments, refunds, agent commission and 24 operating reports.