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-4121
2JW-4122
3
4
5
6JW-4123
7JW-4124
8JW-4125
9JW-4126
10
11
12JW-4127
13JW-4128
14JW-4129
15JW-4130
16JW-4131
17
18
19JW-4132
20JW-4133
21JW-4134
22
23
24
25
26
27
28
29
30
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 3, 11:30 AM8
JW-4102Cordelia Vasquez-LindahlTruck 2Grove CityHeat pump swapsSep 4, 11:30 AM9
JW-4103Leopold Mwangi-StrandTruck 3WestervilleDuct workSep 7, 11:30 AM8
JW-4104Marisela Fenn-AdebayoTruck 4DowntownAC installsSep 8, 11:30 AM10
JW-4105Tiberius Hollingsworth-ChoTruck 5Dublin lineEmergency callsSep 9, 11:30 AM7
JW-4106Ambrose Thistlewood-OkekeTruck 1WestervilleAC installsSep 10, 11:30 AM8
JW-4107Cordelia Vasquez-LindahlTruck 2DowntownEmergency callsSep 11, 11:30 AM9
JW-4108Leopold Mwangi-StrandTruck 3Dublin lineFurnace tune-upsSep 14, 11:30 AM8
JW-4109Marisela Fenn-AdebayoTruck 4NorthsideHeat pump swapsSep 15, 11:30 AM10
JW-4110Tiberius Hollingsworth-ChoTruck 5Grove CityDuct workSep 16, 11:30 AM7
JW-4111Ambrose Thistlewood-OkekeTruck 1Dublin lineHeat pump swapsSep 17, 11:30 AM8
JW-4112Cordelia Vasquez-LindahlTruck 2NorthsideDuct workSep 18, 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-615367Apr 18, 2024Sep 23, 2026Expired
HC-3118Tiberius Hollingsworth-ChoGas fitter permitGAS-640413Oct 15, 2024Sep 27, 2026Expired
HC-3116Marisela Fenn-AdebayoDriver medical cardDOT-636835Oct 20, 2025Oct 20, 2026Renewal due
HC-3112Leopold Mwangi-StrandFirst aid and CPRCPR-629679Nov 4, 2024Oct 23, 2026Renewal due
HC-3102Ambrose Thistlewood-OkekeState mechanical licenseMEC-611789Nov 4, 2024Oct 30, 2026Renewal due
HC-3108Cordelia Vasquez-LindahlDriver medical cardDOT-622523Oct 30, 2025Oct 30, 2026Renewal due
HC-3120Tiberius Hollingsworth-ChoDriver medical cardDOT-643991Nov 9, 2025Nov 9, 2026Renewal due
HC-3109Leopold Mwangi-StrandState mechanical licenseMEC-624312Jun 23, 2023Nov 19, 2026Renewal due
HC-3123Leopold Mwangi-StrandDriver medical cardDOT-649358Dec 9, 2025Dec 4, 2026Renewal due
HC-3119Tiberius Hollingsworth-ChoFirst aid and CPRCPR-642202Feb 12, 2025Feb 7, 2027Current
HC-3115Marisela Fenn-AdebayoRefrigerant handling cardREF-635046Feb 12, 2025Feb 12, 2027Current
HC-3106Cordelia Vasquez-LindahlState mechanical licenseMEC-618945May 23, 2025Mar 14, 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 1, 1:00 PM8$220Completed
TR-318Leopold Mwangi-StrandCustomer communicationJun 15, 1:00 PM6$180Completed
TR-319Tiberius Hollingsworth-ChoElectrical basics for HVACJun 29, 1:00 PM16$260Completed
TR-301Ambrose Thistlewood-OkekeHeat pump commissioningJul 13, 1:00 PM16$395Completed
TR-302Cordelia Vasquez-LindahlR-454B refrigerant handlingAug 3, 1:00 PM8$220Completed
TR-303Leopold Mwangi-StrandLoad calculationsAug 19, 1:00 PM12$310Completed
TR-304Marisela Fenn-AdebayoCustomer communicationAug 27, 1:00 PM6$180Completed
TR-305Tiberius Hollingsworth-ChoGas safety refresherSep 7, 1:00 PM4$140Completed
TR-306Ambrose Thistlewood-OkekeR-454B refrigerant handlingSep 15, 1:00 PM8$220Completed
TR-307Cordelia Vasquez-LindahlElectrical basics for HVACSep 22, 1:00 PM16$260Completed
TR-308Leopold Mwangi-StrandHeat pump commissioningSep 25, 1:00 PM16$395Cancelled
TR-316Nadezhda Rasmussen-OforiGas safety refresherOct 12, 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 14, 2017Jun 24, 2017Jun 26, 2017Jul 4, 2017
NH-802Cordelia Vasquez-LindahlCleared for the roadSep 26, 2020Oct 6, 2020Oct 9, 2020Oct 16, 2020
NH-803Leopold Mwangi-StrandCleared for the roadSep 11, 2021Sep 19, 2021Sep 22, 2021Sep 29, 2021
NH-804Marisela Fenn-AdebayoCleared for the roadSep 11, 2023Sep 21, 2023Sep 24, 2023Oct 1, 2023
NH-805Tiberius Hollingsworth-ChoCleared for the roadSep 5, 2024Sep 14, 2024Sep 16, 2024Sep 23, 2024
NH-806Nadezhda Rasmussen-OforiOnboardingSep 15, 2026Sep 23, 2026Sep 26, 2026—
NH-807Bartholomew Kessler-AmadiOffer acceptedOct 3, 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