Online Tutorial for Data Analysis and Automation
A finished Google Apps Script service desk for a computer and laptop repair shop: 23 screens, 16 reports and 6 server-enforced roles on your own Google Sheets database. One job card from intake to gate pass, no repair without an approved estimate, and no part out of stock without a ticket. Live demo with every role login.
Track 10 drywall KPIs – board sq ft per crew-day, waste percentage, punch list items, job gross margin – with MTD/YTD traffic lights and 12-month trends in Google Sheets.
A ready-made Carpentry Workshop KPI Scorecard in Google Sheets: 10 joinery KPIs in 5 groups, a month picker, direction-aware traffic lights against target, plus KPI Trend and KPI Analysis pages.
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.