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.
Author: PK
Meet PK, the founder of NeotechNavigators.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your data analysis skills to the next level!
Bowling Alley Management System Web App
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.
Civil Contractor Job Management System Web App
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.
Chemical Manufacturing Dashboard in Google Sheets
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.
Power Generation Dashboard in Google Sheets
A six-page Power Generation Dashboard in Google Sheets built on native pivot tables and slicers – 16 KPI cards, 18 charts and a record lookup covering MWh, capacity factor, availability, outage hours, revenue and margin across your generation fleet.
Internal Communications KPI Dashboard in Google Sheets
A formula-driven Google Sheets KPI scorecard for internal communications: 14 comms KPIs, a single month picker, MTD and YTD traffic lights, a KPI Trend page and a KPI Analysis page. No add-on, no Apps Script, no connector.
Cement & Concrete Supplier Management System Web App
A Google Apps Script web app that runs a ready-mix and cement supply business end to end: 22 modules, 7 roles, 17 reports and a seeded database. Free live demo.
Workplace Safety KPI Dashboard in Google Sheets
A formula-driven Google Sheets KPI scorecard that tracks 14 workplace safety KPIs – TRIR, LTIFR, DART Rate, near-misses, PPE compliance and more – with a month picker, MTD and YTD traffic lights, a 12-month trend page and a group analysis page. No add-ons, no scripts.
Chit Fund Management System Web App
A Google Apps Script web app that keeps the whole chit book in one place – 16 chit groups, 92 subscribers, 220 auctions and 4,920 receipts seeded on first run, six roles, eighteen reports and a live demo you can sign into right now. Record-keeping software only: it does not register, license or make compliant any scheme.
Running Log & Mileage Tracker in Google Sheets: Pages, Features and Setup
A walkthrough of the Running Log & Mileage Tracker in Google Sheets – the total mileage card, the four charts, the 15-column log, the four self-calculating columns, and how to set it up in five minutes. A logging template, not medical or coaching advice.