Online Tutorial for Data Analysis and Automation
A complete bakery production planning and record-keeping system built on Google Apps Script and Google Sheets. Generate the daily bake schedule from real orders, release work orders, record actual yield and wastage, plan ingredients against stock and cost every batch. 21 modules, 6 roles, 18 reports, and a live demo you can sign into right now. A planning tool only – it makes no food-safety, HACCP, allergen or labelling claims.
Track 14 corporate governance KPIs across board composition, board effectiveness, audit and risk, compliance, ethics, disclosure and shareholder rights in one formula-driven Google Sheets scorecard. Pick a month and MTD plus YTD achievement, traffic lights and prior-year comparisons update instantly. No add-ons, no scripts. A reporting template only, not legal or governance advice.
A formula-driven carbon footprint KPI dashboard in Google Sheets: 14 emissions KPIs, 12 months, MTD and YTD with traffic lights and prior-year comparison, all driven by one month dropdown. No add-ons, no scripts.
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 full walkthrough of the Water Intake Tracker in Google Sheets – the one-page drink log, its four charts, the seven formula columns, and how to set it up in about five minutes. A logging and charting tool, not medical advice.
A one-page Calorie & Macro Tracker in Google Sheets: log food, servings, calories, protein, carbs, fat and fiber in a 16-column table while a Total Calories Logged card and four live charts redraw underneath. Logging tool only – not medical or nutritional advice.
A six-page Investor Relations Dashboard in Google Sheets built on native pivot tables and 15 slicers. Track your shareholder register, share price, capital flows and IR meetings in one file – a reporting tool only, with demo data you replace with your own.
A six-tab Google Sheets workbook that charts workforce representation, pay and inclusion-survey scores from 500 sample employee records using native pivot tables and 16 slicers. A reporting tool only – it charts what you enter and gives no HR or legal advice.
Review the Solar Energy KPI Scorecard in Google Sheets, a practical template for tracking solar production, availability, performance ratio, downtime, maintenance cost, revenue, and ROI.
A complete alarm monitoring and central station management system built on Google Apps Script and Google Sheets – live alarm monitor with SLA countdowns, keyholder calls, authority dispatch, a false alarm register with fines, contracts and recurring revenue, a one-pass monthly billing run, and the whole service side. Seeded with 60 customers, 85 sites, 85 panels and six months of history, with nine logins across seven roles and a live demo you can sign into now.