A Google Apps Script web app that runs a consulting practice from 20 modules, a seven-phase fee schedule and 14 exportable reports — with fee earned, WIP, margin and utilisation all derived from the timesheet.
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!
Patient Follow-Up Visit Calendar in Google Sheets
A six-tab Google Sheets calendar for outpatient follow-up reviews – Annual, Monthly and Daily views over one appointments table, with 100 sample visits across 20 review types and 38 clinic rooms. Walkthrough of every tab, plus the five things it deliberately does not do.
Radiology Slot Booking Calendar in Google Sheets
A six-tab Google Sheets scheduling workbook for imaging departments – Annual, Monthly and Daily views over one bookings table, with 100 sample slots across 21 procedures and 21 rooms. Walkthrough of every tab, plus the four things it deliberately does not do.
Roofing Contractor KPI Scorecard in Google Sheets
Ten roofing KPIs on one traffic-light page in Google Sheets – month picker, MTD and YTD targets, prior-year trends and every formula documented. A full walkthrough of the four sheets, where it fits against Excel and paid roofing software, and where it deliberately stops.
HVAC Contractor KPI Scorecard in Google Sheets
Track 10 HVAC KPIs – first-time fix rate, callback rate, ticket value and more – with MTD/YTD traffic lights and 12-month trends in Google Sheets.
HVAC Contractor KPI Dashboard in Google Sheets
Track 15 HVAC contractor KPIs in Google Sheets with MTD and YTD achievement, prior-year comparison and traffic-light status. One month dropdown drives the scorecard, the KPI Trend page and the group analysis – formula-driven, nothing to install.
Leadership Development KPI Dashboard in Google Sheets
The Leadership Development KPI Dashboard in Google Sheets tracks 14 leadership KPIs across four groups and ten tabs, with a month picker that drives MTD and YTD traffic lights, a single-KPI trend page and a group roll-up analysis page. Formula-driven, no add-ons, one-time payment.
Medication & Pill Tracker in Google Sheets
One Google Sheets tab that tracks every medicine, dose and refill, with days supply left, refill alerts and four live charts calculated for you. A personal organising log, not medical advice.
Yoga & Stretching Practice Tracker in Google Sheets
A one-page Yoga & Stretching Practice Tracker in Google Sheets: total practice minutes, four live charts and a 16-column session log that grades every session against your planned minutes. A personal practice log, not medical advice.
Heavy Machinery Dashboard in Google Sheets
The Heavy Machinery Dashboard in Google Sheets tracks 16 KPI cards and 18 charts across 6 pages, driven by 15 native slicers over a 500-order book that auto-expands to 1,000 rows. Built on real pivot tables, it covers plant output, dealer orders, backlog and warranty service in one browser file.