Online Tutorial for Data Analysis and Automation
A shared on-call diary in Google Sheets: 100 sample duties across 2026, 19 duty types, 31 named locations, and Annual, Monthly and Daily views driven by one entry table. A scheduling spreadsheet – not a clinical system, not a patient record, and not a paging or e-rostering platform.
Track 10 welding shop KPIs on one page in Google Sheets – weld defect rate, first-pass yield, arc-on time, downtime and cost per kg deposited – with red-amber-green status dots, targets, prior-year comparison and 12-month trends.
The Masonry Contractor KPI Scorecard in Google Sheets tracks 10 masonry KPIs across 5 groups on 4 sheets, with traffic lights, a month picker, MTD/YTD switching and Actual vs Target vs PY trend charts.
Track 14 plumbing KPIs across 5 groups in Google Sheets. One month picker drives MTD and YTD achievement, traffic lights, a per-KPI trend page and a group analysis page. No add-ons, no scripts.
A formula-driven Google Sheets scorecard tracking 14 risk mitigation KPIs across 6 groups, with MTD and YTD achievement, prior-year comparison and traffic lights driven by a single month picker. No add-on, no script. A reporting sheet, not a risk management system.
A one-sheet blood sugar log in Google Sheets: an average glucose card, four linked charts and a 16-column entry table with your own per-row target ranges. A personal record-keeping template only – not medical advice, not a medical device.
A one-page Google Sheets log for home blood pressure readings: 15 columns, 4 live charts, an average systolic card and editable dropdowns. A personal record only – not medical advice, not a diagnostic tool.
A six-page Facility Services Dashboard in Google Sheets built on native pivot tables and slicers – service cost, tickets, labor hours, technicians and a ticket ID lookup across eight sites.
A six-tab Google Sheets reporting pack for BPO and KPO delivery teams: 16 KPI cards, 18 charts and 15 native slicers across Overview, Clients, Delivery and Workforce, plus an engagement lookup and a built-in user guide.
A 10-KPI flooring installation scorecard in Google Sheets: month picker, traffic lights against target, MTD and YTD trend charts and a KPI definition sheet. All four pages explained.