Charlie Kodatt

Writing on how the trades are changing.

Field stories first, the numbers second, and the technology third: what AI and better data are changing in HVAC, plumbing and electrical, and what a platform should do about it.

What the Spreadsheet Doesn't Show

A 30-day series for PE firms, platform operators and their teams, running on LinkedIn through January 13. Each post covers one gap between what the report says and what's happening in the home, and ends with the SOP I'd write. Posts will be collected here as they run.

Follow the series on LinkedIn

Week 1 · The numbers every platform tracks

  • Day 1The spreadsheet vs. the kitchen tableOn LinkedIn
  • Day 2Close rateOn LinkedIn
  • Day 3Average ticketOn LinkedIn
  • Day 4Membership countCalculator →
  • Day 5No problem foundCalculator →
  • Day 6Reviews vs. cancellationsOn LinkedIn
  • Day 7Recap: results vs. reasonsOn LinkedIn

Week 2 · The handcuffs

  • Day 8The CSR scriptOn LinkedIn
  • Day 9The AI receptionistOn LinkedIn
  • Day 10The price bookOn LinkedIn
  • Day 11The mandatory presentationOn LinkedIn
  • Day 12The sales-only scorecardScorecard + template →
  • Day 13The dispatch boardOn LinkedIn
  • Day 14The GM in the middleOn LinkedIn

Week 3 · What the homeowner experiences

  • Day 15The thermostat is all they seeOn LinkedIn
  • Day 16Behind the hoodOn LinkedIn
  • Day 17Everything looks goodSample report →
  • Day 18Why homeowners get three quotesOn LinkedIn
  • Day 19When the family gets sickOn LinkedIn
  • Day 20The member who wanted to cancelOn LinkedIn
  • Day 21Younger homeowners want dataOn LinkedIn
  • Day 22Your techs' notes are your most valuable dataOn LinkedIn

Week 4 · The missing layer

  • Day 23The first 100 days after an acquisitionOn LinkedIn
  • Day 24The homeowner should know before the truck rollsOn LinkedIn
  • Day 25The Veteran Escalation DeskOn LinkedIn
  • Day 26The membership is the productOn LinkedIn
  • Day 27Who owns the alertOn LinkedIn
  • Day 28Price the membership on valueCalculator →
  • Day 29Get off the Google treadmillOn LinkedIn
  • Day 30The playbookOn LinkedIn