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 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 20-screen Aquarium and Fish Store Management System Web App for livestock, tanks, water quality, treatments, dry goods, sales, service jobs, suppliers and reports.
A complete eye clinic and optical store management system built on Google Sheets and Apps Script – 21 modules, 5 roles, 20 reports and a 26-tab database you own.
The Chiropractic Clinic Management System Web App packs 20 modules – patients, appointments, SOAP visit notes, treatment plans, visit-credit packages, billing, insurance tracking and reports – into one Google Apps Script web app backed by your own Google Sheet.
The Therapy Center Management System Web App runs a complete therapy or rehabilitation centre from 24 modules and a 37-sheet Google Sheets database — scheduling, treatment plans, SOAP session notes, prepaid packages, billing and 20 reports, with a one-click installer.
A 15-screen catering web app for customer records, event bookings, menu packages, quotations, billing, payments, staff tasks, kitchen production, inventory, reports, user access, settings and audit logs.
Manage site visits, room-wise quotations with wastage, roll cutting, dye lots, crew scheduling, invoicing and 19 reports with this Google Apps Script web app.
A complete self-drive and chauffeur-driven car rental desk web app. 26 screens, 12 live KPI cards, 16 reports, 4 server-enforced roles and automatic late-fee, extra-km, damage, challan and deposit billing, all running on Google Sheets and Apps Script.
A Google Apps Script and Google Sheets web app for beauty product distributors managing inventory, retailers, suppliers, billing, payments, reports, users and audit logs.