A 16-column Google Sheets tracker for every dose given or scheduled: 6 formula columns, 4 charts, a live Doses Administered card and an Overdue flag that reads today’s date. Record-keeping only, not medical advice.
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!
Medical Equipment Manufacturing Dashboard in Google Sheets
A six-tab Google Sheets reporting workbook for medical device plants – 950 sample manufacturing orders, 18 charts, 15 slicers and an order lookup page. Static reporting only: no ERP link and no regulatory or QMS capability.
Nutrition & Dietetics Dashboard in Google Sheets
The Nutrition & Dietetics Dashboard in Google Sheets turns one consultation log into 4 slicer-driven pages with 18 charts, 16 KPI cards and 950 sample consultations – a business reporting template for a dietetics practice, not a clinical or meal-planning tool.
Expense & Petty Cash Management System Web App
A complete Google Apps Script expense and petty cash web app: 25 screens, 6 roles, tiered approvals, branch imprest floats, reconciled cash counts, budgets and 16 finance reports – with a live demo you can open before you buy.
Diet Plan Calendar in Google Sheets
A five-tab Google Sheets calendar that turns one Events table into a year view, a month grid and a printable day list. No macros, no Apps Script, 100 sample rows with every weekday verified. A scheduling calendar only – not medical or nutritional advice.
Franchise Royalty Management System Web App
A Google Apps Script web app that bills franchise royalty from each outlet’s own agreement – flat or banded rates with a minimum monthly floor, a one-click period close, receivables ageing, automatic audit back charges and a franchisee self-service portal. Free live demo with all five role logins.
Garage Door Service KPI Scorecard in Google Sheets
Track ten garage door service KPIs on one page in Google Sheets – first-time fix rate, response time, callback rate, margin and utilization – with a month picker, MTD/YTD and Target/PY switches and red-amber-green traffic lights.
Fencing Contractor KPI Dashboard in Google Sheets
Track 14 fencing contractor KPIs in Google Sheets with MTD and YTD achievement, prior-year comparison, traffic-light status and one month dropdown that drives the whole workbook.
Paving Contractor KPI Dashboard in Google Sheets
A formula-driven Google Sheets KPI dashboard for paving contractors: 14 asphalt-paving KPIs, a month picker, MTD and YTD traffic lights side by side, a twelve-month trend page and a KPI group roll-up.
Baby Feeding & Sleep Log Tracker in Google Sheets
Log every feed, nap, night sleep, diaper change and pumping session in one Google Sheet. 16 columns, 4 formula columns, 4 charts and a live Total Sleep Hours Logged card.