Online Tutorial for Data Analysis and Automation
A complete Google Apps Script web app for cold stores – 22 modules, 6 roles and 18 reports covering lot-wise stock, chamber allocation, the temperature log with excursion control, and storage rent computed from weight, days and tariff slab. Live demo, no signup.
A formula-driven Google Sheets KPI scorecard that tracks 15 employee benefits metrics across 5 groups, with a month picker, MTD and YTD side by side, traffic-light status, a KPI Trend page and a KPI Analysis page. No add-ons, no scripts, no subscription.
A formula-driven Google Sheets KPI scorecard that tracks 14 conflict resolution and employee-relations KPIs across four groups, with MTD and YTD achievement, traffic lights, a trend page and an analysis page. You type the monthly numbers; the sheet does the rest.
A one-page Google Sheets tracker for a 30-day fitness challenge: 30 day rows, 15 columns, one Total Calories Burned KPI card and four charts that redraw as you type. Streak and % of Goal calculate themselves. A logging template only – not medical, coaching or fitness advice.
The Marathon Training Plan Tracker in Google Sheets records 15 fields per session, calculates 5 of them for you, and drives one card and four charts from a single table. A logging template – not medical or coaching advice.
The Textiles & Apparel Manufacturing Dashboard in Google Sheets tracks 16 KPI cards, 16 pivot-driven charts and 15 slicers across Overview, Production, Quality and Orders pages, plus an order lookup screen – built on native pivot tables and slicers, ready for 1,000 production rows.
A six-page steel and metals mill dashboard built on native Google Sheets pivot tables and slicers: 16 KPI cards, 14 charts, 16 slicers and an order-level lookup, with 380 rows of demo data ready to be replaced with your own order log.
A screen-by-screen review of a 27-screen Google Apps Script web app that runs a bowling centre end to end – POS, bookings, bowler check-in, memberships, leagues, lane safety, cashier shifts and 20 reports. Live demo with all five roles, one-off price, source code included.
A Google Apps Script web app that runs a civil contracting business end to end – tenders, projects and BOQ, daily progress, labour muster, stores, plant, subcontractors, RA billing, receipts and retention across twenty modules, six roles and sixteen reports. Free live demo with all six role logins.
A production-reporting dashboard for chemical plants built entirely in Google Sheets: 6 tabs, 16 KPI cards, 18 native charts and 15 slicers over a 380-batch demo dataset covering output, yield, OEE, cost and margin.