Templates

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
November 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2JW-4108
3JW-4109
4JW-4110
5JW-4111
6JW-4112
7
8
9JW-4113
10JW-4114
11JW-4115
12JW-4116
13JW-4117
14
15
16JW-4118
17JW-4119
18JW-4120
19JW-4121
20JW-4122
21
22
23JW-4123
24JW-4124
25JW-4125
26JW-4126
27JW-4127
28
29
30JW-4128

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-upsOct 22, 11:30 AM8
JW-4102Cordelia Vasquez-LindahlTruck 2Grove CityHeat pump swapsOct 23, 11:30 AM9
JW-4103Leopold Mwangi-StrandTruck 3WestervilleDuct workOct 26, 11:30 AM8
JW-4104Marisela Fenn-AdebayoTruck 4DowntownAC installsOct 27, 11:30 AM10
JW-4105Tiberius Hollingsworth-ChoTruck 5Dublin lineEmergency callsOct 28, 11:30 AM7
JW-4106Ambrose Thistlewood-OkekeTruck 1WestervilleAC installsOct 29, 11:30 AM8
JW-4107Cordelia Vasquez-LindahlTruck 2DowntownEmergency callsOct 30, 11:30 AM9
JW-4108Leopold Mwangi-StrandTruck 3Dublin lineFurnace tune-upsNov 2, 12:30 PM8
JW-4109Marisela Fenn-AdebayoTruck 4NorthsideHeat pump swapsNov 3, 12:30 PM10
JW-4110Tiberius Hollingsworth-ChoTruck 5Grove CityDuct workNov 4, 12:30 PM7
JW-4111Ambrose Thistlewood-OkekeTruck 1Dublin lineHeat pump swapsNov 5, 12:30 PM8
JW-4112Cordelia Vasquez-LindahlTruck 2NorthsideDuct workNov 6, 12:30 PM9

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-615367Jun 5, 2024Nov 10, 2026Expired
HC-3118Tiberius Hollingsworth-ChoGas fitter permitGAS-640413Dec 2, 2024Nov 14, 2026Expired
HC-3116Marisela Fenn-AdebayoDriver medical cardDOT-636835Dec 7, 2025Dec 7, 2026Renewal due
HC-3112Leopold Mwangi-StrandFirst aid and CPRCPR-629679Dec 22, 2024Dec 10, 2026Renewal due
HC-3102Ambrose Thistlewood-OkekeState mechanical licenseMEC-611789Dec 22, 2024Dec 17, 2026Renewal due
HC-3108Cordelia Vasquez-LindahlDriver medical cardDOT-622523Dec 17, 2025Dec 17, 2026Renewal due
HC-3120Tiberius Hollingsworth-ChoDriver medical cardDOT-643991Dec 27, 2025Dec 27, 2026Renewal due
HC-3109Leopold Mwangi-StrandState mechanical licenseMEC-624312Aug 10, 2023Jan 6, 2027Renewal due
HC-3123Leopold Mwangi-StrandDriver medical cardDOT-649358Jan 26, 2026Jan 21, 2027Renewal due
HC-3119Tiberius Hollingsworth-ChoFirst aid and CPRCPR-642202Apr 1, 2025Mar 27, 2027Current
HC-3115Marisela Fenn-AdebayoRefrigerant handling cardREF-635046Apr 1, 2025Apr 1, 2027Current
HC-3106Cordelia Vasquez-LindahlState mechanical licenseMEC-618945Jul 10, 2025May 1, 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 handlingJul 20, 1:00 PM8$220Completed
TR-318Leopold Mwangi-StrandCustomer communicationAug 3, 1:00 PM6$180Completed
TR-319Tiberius Hollingsworth-ChoElectrical basics for HVACAug 17, 1:00 PM16$260Completed
TR-301Ambrose Thistlewood-OkekeHeat pump commissioningAug 31, 1:00 PM16$395Completed
TR-302Cordelia Vasquez-LindahlR-454B refrigerant handlingSep 21, 1:00 PM8$220Completed
TR-303Leopold Mwangi-StrandLoad calculationsOct 7, 1:00 PM12$310Completed
TR-304Marisela Fenn-AdebayoCustomer communicationOct 15, 1:00 PM6$180Completed
TR-305Tiberius Hollingsworth-ChoGas safety refresherOct 26, 1:00 PM4$140Completed
TR-306Ambrose Thistlewood-OkekeR-454B refrigerant handlingNov 3, 2:00 PM8$220Completed
TR-307Cordelia Vasquez-LindahlElectrical basics for HVACNov 10, 2:00 PM16$260Completed
TR-308Leopold Mwangi-StrandHeat pump commissioningNov 13, 2:00 PM16$395Cancelled
TR-316Nadezhda Rasmussen-OforiGas safety refresherNov 27, 2: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 roadAug 1, 2017Aug 11, 2017Aug 13, 2017Aug 21, 2017
NH-802Cordelia Vasquez-LindahlCleared for the roadNov 13, 2020Nov 23, 2020Nov 26, 2020Dec 3, 2020
NH-803Leopold Mwangi-StrandCleared for the roadOct 29, 2021Nov 6, 2021Nov 9, 2021Nov 16, 2021
NH-804Marisela Fenn-AdebayoCleared for the roadOct 29, 2023Nov 8, 2023Nov 11, 2023Nov 18, 2023
NH-805Tiberius Hollingsworth-ChoCleared for the roadOct 23, 2024Nov 1, 2024Nov 3, 2024Nov 10, 2024
NH-806Nadezhda Rasmussen-OforiOnboardingNov 2, 2026Nov 10, 2026Nov 13, 2026—
NH-807Bartholomew Kessler-AmadiOffer acceptedNov 20, 2026———

Also included

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

Questions

What is included in the HVAC contractor: Juniperwell Park Heating & Air template?
4 tables (Dispatch days, Licenses and cards, Training sessions and New hires), filled with 85 sample rows so every view opens with realistic data.
Is the HVAC contractor: Juniperwell Park Heating & Air template free?
Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
Can I change the template after I use it?
Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.