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-4111
3JW-4112
4JW-4113
5JW-4114
6JW-4115
7
8
9JW-4116
10JW-4117
11JW-4118
12JW-4119
13JW-4120
14
15
16JW-4121
17JW-4122
18
19JW-4123
20JW-4124
21
22
23JW-4125
24JW-4126
25JW-4127
26JW-4128
27JW-4129
28
29
30JW-4130

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 19, 11:30 AM8
JW-4102Cordelia Vasquez-LindahlTruck 2Grove CityHeat pump swapsOct 20, 11:30 AM9
JW-4103Leopold Mwangi-StrandTruck 3WestervilleDuct workOct 21, 11:30 AM8
JW-4104Marisela Fenn-AdebayoTruck 4DowntownAC installsOct 22, 11:30 AM10
JW-4105Tiberius Hollingsworth-ChoTruck 5Dublin lineEmergency callsOct 23, 11:30 AM7
JW-4106Ambrose Thistlewood-OkekeTruck 1WestervilleAC installsOct 26, 11:30 AM8
JW-4107Cordelia Vasquez-LindahlTruck 2DowntownEmergency callsOct 27, 11:30 AM9
JW-4108Leopold Mwangi-StrandTruck 3Dublin lineFurnace tune-upsOct 28, 11:30 AM8
JW-4109Marisela Fenn-AdebayoTruck 4NorthsideHeat pump swapsOct 29, 11:30 AM10
JW-4110Tiberius Hollingsworth-ChoTruck 5Grove CityDuct workOct 30, 11:30 AM7
JW-4111Ambrose Thistlewood-OkekeTruck 1Dublin lineHeat pump swapsNov 2, 12:30 PM8
JW-4112Cordelia Vasquez-LindahlTruck 2NorthsideDuct workNov 3, 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 1, 2024Nov 6, 2026Expired
HC-3118Tiberius Hollingsworth-ChoGas fitter permitGAS-640413Nov 28, 2024Nov 10, 2026Expired
HC-3116Marisela Fenn-AdebayoDriver medical cardDOT-636835Dec 3, 2025Dec 3, 2026Renewal due
HC-3112Leopold Mwangi-StrandFirst aid and CPRCPR-629679Dec 18, 2024Dec 6, 2026Renewal due
HC-3102Ambrose Thistlewood-OkekeState mechanical licenseMEC-611789Dec 18, 2024Dec 13, 2026Renewal due
HC-3108Cordelia Vasquez-LindahlDriver medical cardDOT-622523Dec 13, 2025Dec 13, 2026Renewal due
HC-3120Tiberius Hollingsworth-ChoDriver medical cardDOT-643991Dec 23, 2025Dec 23, 2026Renewal due
HC-3109Leopold Mwangi-StrandState mechanical licenseMEC-624312Aug 6, 2023Jan 2, 2027Renewal due
HC-3123Leopold Mwangi-StrandDriver medical cardDOT-649358Jan 22, 2026Jan 17, 2027Renewal due
HC-3119Tiberius Hollingsworth-ChoFirst aid and CPRCPR-642202Mar 28, 2025Mar 23, 2027Current
HC-3115Marisela Fenn-AdebayoRefrigerant handling cardREF-635046Mar 28, 2025Mar 28, 2027Current
HC-3106Cordelia Vasquez-LindahlState mechanical licenseMEC-618945Jul 6, 2025Apr 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 handlingJul 15, 1:00 PM8$220Completed
TR-318Leopold Mwangi-StrandCustomer communicationJul 29, 1:00 PM6$180Completed
TR-319Tiberius Hollingsworth-ChoElectrical basics for HVACAug 12, 1:00 PM16$260Completed
TR-301Ambrose Thistlewood-OkekeHeat pump commissioningAug 26, 1:00 PM16$395Completed
TR-302Cordelia Vasquez-LindahlR-454B refrigerant handlingSep 16, 1:00 PM8$220Completed
TR-303Leopold Mwangi-StrandLoad calculationsOct 2, 1:00 PM12$310Completed
TR-304Marisela Fenn-AdebayoCustomer communicationOct 12, 1:00 PM6$180Completed
TR-305Tiberius Hollingsworth-ChoGas safety refresherOct 21, 1:00 PM4$140Completed
TR-306Ambrose Thistlewood-OkekeR-454B refrigerant handlingOct 29, 1:00 PM8$220Completed
TR-307Cordelia Vasquez-LindahlElectrical basics for HVACNov 5, 2:00 PM16$260Completed
TR-308Leopold Mwangi-StrandHeat pump commissioningNov 10, 2:00 PM16$395Cancelled
TR-316Nadezhda Rasmussen-OforiGas safety refresherNov 25, 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 roadJul 28, 2017Aug 7, 2017Aug 9, 2017Aug 17, 2017
NH-802Cordelia Vasquez-LindahlCleared for the roadNov 9, 2020Nov 19, 2020Nov 22, 2020Nov 29, 2020
NH-803Leopold Mwangi-StrandCleared for the roadOct 25, 2021Nov 2, 2021Nov 5, 2021Nov 12, 2021
NH-804Marisela Fenn-AdebayoCleared for the roadOct 25, 2023Nov 4, 2023Nov 7, 2023Nov 14, 2023
NH-805Tiberius Hollingsworth-ChoCleared for the roadOct 19, 2024Oct 28, 2024Oct 30, 2024Nov 6, 2024
NH-806Nadezhda Rasmussen-OforiOnboardingOct 29, 2026Nov 6, 2026Nov 9, 2026—
NH-807Bartholomew Kessler-AmadiOffer acceptedNov 16, 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.