Online Tutorial for Data Analysis and Automation
A Google Apps Script web app that keeps a whole credit union book in one place – 420 members, 480 savings accounts, 150 certificates, 190 loans and 4,172 ledger rows seeded on first run, six roles, fourteen reports and a live demo you can sign into right now. Record-keeping software only: it does not license, certify or make compliant any society.
Track 15 roofing contractor KPIs in Google Sheets with MTD and YTD achievement, prior-year comparison and traffic-light status. One month dropdown drives the scorecard, the KPI Trend page and the group analysis – formula-driven, nothing to install.
Fourteen electrical contracting KPIs on one traffic-light page in Google Sheets – month picker, MTD and YTD achievement, prior-year comparison, trend and analysis pages.
A six-tab Google Sheets dashboard for recruitment agencies: 16 KPI cards, 18 charts and 15 slicers over one placement log, reporting fee revenue, time-to-fill, candidate sources and recruiter billings.
A six-tab Google Sheets workbook that turns 500 sample executive search mandates into fee revenue, pipeline, time-to-fill and consultant-level reporting using native pivot tables and 15 slicers. A reporting tool only – it charts what you enter and is not an applicant tracking system.
Track medical bills, insurance claims and out-of-pocket costs on one Google Sheets page – KPI card, four charts, an automatic follow-up flag and 17 columns per claim.
One Google Sheet with 16 columns, 6 editable dropdowns, 4 self-filling formula columns, an Upcoming Visits counter and 4 live charts for logging every doctor visit for the whole household. A personal record – not medical software, not an EHR, and it sends no reminders.
A 30-screen Google Apps Script web app that runs a CrossFit box end to end – members, plans, memberships, timetable, WOD programming, PRs and leaderboards, the retail counter, invoices, payroll and 21 reports. Live demo with every seeded login inside.
A module-by-module walkthrough of the Courier & Parcel Delivery Management System Web App – 28 modules, 17 reports, 6 roles and a live demo you can sign into as any of eight seeded accounts. Runs on Google Apps Script in your own Google account.
A finished Google Apps Script back office for concert promoters: 24 modules, 16 reports and 6 roles on your own Google Sheets database. Ticketing that cannot oversell, a gate that scans once, and settlements that reconcile with your co-promoter. Live demo with every role login.