The Renewable Resource KPI Dashboard in Google Sheets tracks 12 KPIs across 5 groups on 6 linked sheets – MTD and YTD actual versus target versus prior year, traffic lights, a KPI trend page and a group roll-up, all driven by one month dropdown.
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!
Waste Reduction KPI Dashboard in Google Sheets
A formula-driven Google Sheets KPI scorecard that tracks 14 waste and circular-economy KPIs across four groups, month to date and year to date, with traffic-light status, a per-KPI trend page and a group analysis page.
Daily Steps Tracker in Google Sheets
A one-page Google Sheets step log with a Total Steps Logged card, four live charts and automatic Goal Status. Log one row a day and the whole sheet redraws itself. A logging template, not medical advice.
Sleep Tracker in Google Sheets Template
A full walkthrough of the Sleep Tracker in Google Sheets – the one-page nightly log, its four charts, the six formula columns and how to set it up in a couple of minutes. A logging and charting tool, not medical advice.
Railways Dashboard in Google Sheets
A pivot-and-slicer Railways Dashboard in Google Sheets with 6 tabs, 16 KPI cards, 19 charts and gauges and 15 slicers – covering punctuality, route revenue, operating margin and passenger demand from your own service log.
Shipping Dashboard in Google Sheets
A five-page Shipping Dashboard in Google Sheets built on native pivot tables and slicers – freight spend, carrier mix, trade lanes, customer delivery quality and a shipment-ID lookup, with 500 sample shipments loaded and room for 1,000 rows.
Fleet Maintenance Calendar in Google Sheets
A Fleet Maintenance Calendar in Google Sheets that drives Annual, Monthly and Daily views from one Events sheet. Schedule vehicle service in the browser — one-time $4.99, no subscription.
Investor Relations Calendar in Google Sheets
Plan earnings calls, shareholder meetings, dividends and investor events with a 5-sheet Investor Relations Calendar in Google Sheets. Annual, Monthly and Daily views, one-time $4.99.
Wind Energy KPI Scorecard in Google Sheets
Wind Energy KPI Scorecard in Google Sheets – track 10 wind-farm KPIs with RAG status lights, MTD/YTD toggle, and prior-year comparison. One-time $8.99.
Hydropower KPI Scorecard In Google Sheets
The Hydropower KPI Scorecard in Google Sheets tracks 10 plant KPIs across 6 groups with MTD/YTD values, prior-year comparison, RAG status, and trend charts. A one-time purchase with no subscription.