AI Matrx Logo

HVAC contractor

Juniperwell Park Heating & Air · HVAC contractor · Columbus, OH

Yoshiko Prendergast is the dispatcher at Juniperwell Park Heating & Air, a residential HVAC company in Columbus, and she keeps the truck schedule, every technician's licenses and classes, and each new hire's first weeks in this one place.

Construction and tradesTeam and HRChecklists5 tables · 7 views · 1 form · 2 dimension sets · 1 digest · 1 checklist · 1 notification · 1 agent
Use this template

Truck calendar

Dispatch days
October 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1JW-4111
2JW-4112
3
4
5JW-4113
6JW-4114
7JW-4115
8JW-4116
9JW-4117
10
11
12JW-4118
13JW-4119
14JW-4120
15JW-4121
16JW-4122
17
18
19JW-4123
20JW-4124
21JW-4125
22JW-4126
23JW-4127
24
25
26JW-4128
27JW-4129
28JW-4130
29JW-4131
30JW-4132
31

Tables

Dispatch days

34 sample rows · 10 columns

Who is on which truck each day, the area and kind of work, and whether the day was worked.

Dispatch dayTechnicianTruckAreaWorkStartsHours
JW-4101Ambrose Thistlewood-OkekeTruck 1NorthsideFurnace tune-upsSep 17, 11:30 AM8
JW-4102Cordelia Vasquez-LindahlTruck 2Grove CityHeat pump swapsSep 18, 11:30 AM9
JW-4103Leopold Mwangi-StrandTruck 3WestervilleDuct workSep 21, 11:30 AM8
JW-4104Marisela Fenn-AdebayoTruck 4DowntownAC installsSep 22, 11:30 AM10
JW-4105Tiberius Hollingsworth-ChoTruck 5Dublin lineEmergency callsSep 23, 11:30 AM7
JW-4106Ambrose Thistlewood-OkekeTruck 1WestervilleAC installsSep 24, 11:30 AM8
JW-4107Cordelia Vasquez-LindahlTruck 2DowntownEmergency callsSep 25, 11:30 AM9
JW-4108Leopold Mwangi-StrandTruck 3Dublin lineFurnace tune-upsSep 28, 11:30 AM8
JW-4109Marisela Fenn-AdebayoTruck 4NorthsideHeat pump swapsSep 29, 11:30 AM10
JW-4110Tiberius Hollingsworth-ChoTruck 5Grove CityDuct workSep 30, 11:30 AM7
JW-4111Ambrose Thistlewood-OkekeTruck 1Dublin lineHeat pump swapsOct 1, 11:30 AM8
JW-4112Cordelia Vasquez-LindahlTruck 2NorthsideDuct workOct 2, 11:30 AM9

22 more rows

Licenses and cards

24 sample rows · 9 columns

The licenses, permits and safety cards each technician holds, with the day each lapses.

File numberTechnicianKindNumber on the cardIssuedExpiresStanding
HC-3104Ambrose Thistlewood-OkekeRefrigerant handling cardREF-615367May 1, 2024Oct 6, 2026Expired
HC-3118Tiberius Hollingsworth-ChoGas fitter permitGAS-640413Oct 28, 2024Oct 10, 2026Expired
HC-3116Marisela Fenn-AdebayoDriver medical cardDOT-636835Nov 2, 2025Nov 2, 2026Renewal due
HC-3112Leopold Mwangi-StrandFirst aid and CPRCPR-629679Nov 17, 2024Nov 5, 2026Renewal due
HC-3102Ambrose Thistlewood-OkekeState mechanical licenseMEC-611789Nov 17, 2024Nov 12, 2026Renewal due
HC-3108Cordelia Vasquez-LindahlDriver medical cardDOT-622523Nov 12, 2025Nov 12, 2026Renewal due
HC-3120Tiberius Hollingsworth-ChoDriver medical cardDOT-643991Nov 22, 2025Nov 22, 2026Renewal due
HC-3109Leopold Mwangi-StrandState mechanical licenseMEC-624312Jul 6, 2023Dec 2, 2026Renewal due
HC-3123Leopold Mwangi-StrandDriver medical cardDOT-649358Dec 22, 2025Dec 17, 2026Renewal due
HC-3119Tiberius Hollingsworth-ChoFirst aid and CPRCPR-642202Feb 25, 2025Feb 20, 2027Current
HC-3115Marisela Fenn-AdebayoRefrigerant handling cardREF-635046Feb 25, 2025Feb 25, 2027Current
HC-3106Cordelia Vasquez-LindahlState mechanical licenseMEC-618945Jun 5, 2025Mar 27, 2027Current

12 more rows

Training sessions

20 sample rows · 7 columns

Classes technicians are booked into, with the hours away from trucks and what each class costs.

SessionTechnicianCourseClass dayHoursClass feeStatus
TR-320Marisela Fenn-AdebayoR-454B refrigerant handlingJun 15, 1:00 PM8$220Completed
TR-318Leopold Mwangi-StrandCustomer communicationJun 29, 1:00 PM6$180Completed
TR-319Tiberius Hollingsworth-ChoElectrical basics for HVACJul 13, 1:00 PM16$260Completed
TR-301Ambrose Thistlewood-OkekeHeat pump commissioningJul 27, 1:00 PM16$395Completed
TR-302Cordelia Vasquez-LindahlR-454B refrigerant handlingAug 17, 1:00 PM8$220Completed
TR-303Leopold Mwangi-StrandLoad calculationsSep 2, 1:00 PM12$310Completed
TR-304Marisela Fenn-AdebayoCustomer communicationSep 10, 1:00 PM6$180Completed
TR-305Tiberius Hollingsworth-ChoGas safety refresherSep 21, 1:00 PM4$140Completed
TR-306Ambrose Thistlewood-OkekeR-454B refrigerant handlingSep 29, 1:00 PM8$220Completed
TR-307Cordelia Vasquez-LindahlElectrical basics for HVACOct 6, 1:00 PM16$260Completed
TR-308Leopold Mwangi-StrandHeat pump commissioningOct 9, 1:00 PM16$395Cancelled
TR-316Nadezhda Rasmussen-OforiGas safety refresherOct 23, 1:00 PM4$140Booked

8 more rows

New hires

7 sample rows · 8 columns

Each technician's first weeks, from the signed offer to the first day alone on a truck.

OnboardingTechnicianStatusOffer acceptedPaperwork inDriving record checkedRide-along began
NH-801Ambrose Thistlewood-OkekeCleared for the roadJun 27, 2017Jul 7, 2017Jul 9, 2017Jul 17, 2017
NH-802Cordelia Vasquez-LindahlCleared for the roadOct 9, 2020Oct 19, 2020Oct 22, 2020Oct 29, 2020
NH-803Leopold Mwangi-StrandCleared for the roadSep 24, 2021Oct 2, 2021Oct 5, 2021Oct 12, 2021
NH-804Marisela Fenn-AdebayoCleared for the roadSep 24, 2023Oct 4, 2023Oct 7, 2023Oct 14, 2023
NH-805Tiberius Hollingsworth-ChoCleared for the roadSep 18, 2024Sep 27, 2024Sep 29, 2024Oct 6, 2024
NH-806Nadezhda Rasmussen-OforiOnboardingSep 28, 2026Oct 6, 2026Oct 9, 2026—
NH-807Bartholomew Kessler-AmadiOffer acceptedOct 16, 2026———

Also included

  • New hire checklistChecklist
  • Card running outNotificationWarns the dispatcher a month before a license or safety card lapses.
  • Cards lapsing soonDigest

Related templates