Track 10 tire shop KPIs – sales, service, quality, customer and inventory – with monthly cards, MTD/YTD views, direction-aware traffic lights and trend charts in Google Sheets.
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!
Auto Repair Shop KPI Scorecard in Google Sheets
The Auto Repair Shop KPI Scorecard in Google Sheets tracks 10 shop KPIs on one page of traffic-light cards with a month picker, MTD/YTD and Target/PY views and a KPI Trend page.
Streaming Income Tracker (Twitch/YouTube Live) in Google Sheets
A one-page streaming income tracker in Google Sheets: one Total Streaming Income card, four live charts and a 16-column log that works out Total Income and $ / Hour for every Twitch, YouTube Live, Kick or TikTok Live session you run.
Self-Publishing (KDP) Royalty Tracker in Google Sheets
A one-page KDP Royalty Tracker in Google Sheets: 16 columns with six automatic formulas, a Total Net Royalty card and four live charts over every book edition you publish.
Book Writing & Word Count Tracker in Google Sheets
A one-page Google Sheets tracker for a whole manuscript: a live Total Words Written card, 4 charts, 16 columns and a Pace flag that warns you before a chapter deadline slips.
Freelance Writing Pitch & Submission Tracker in Google Sheets
A one-page Google Sheets tracker for freelance writers: 15 columns, a Total Pipeline Value card, four live charts, eight pitch statuses and automatic follow-up flags at 14 and 21 days.
Online Marketplaces Dashboard in Google Sheets
A six-tab Google Sheets dashboard that puts 8 marketplaces, 8 categories, 5 regions and 3 buyer segments on the same axes – 16 KPI cards, 18 charts and 15 native slicers over your own pasted order export.
Placement Drive Calendar in Google Sheets
A Google Sheets placement drive calendar with Annual, Monthly and Daily views plus an Events sheet of 100 sample talks, tests and interview rounds for 2026.
Board Exam Revision Calendar in Google Sheets
A Google Sheets board exam revision planner with Annual, Monthly and Daily views plus an Events sheet of 100 sample revision sessions, mock tests and clinics for 2026.
Home Inspection Services KPI Scorecard in Google Sheets
A 10-KPI Google Sheets scorecard for home inspection businesses with month, MTD/YTD and Target/PY selectors, traffic lights, mini charts and a KPI Trend page.