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 templateTruck calendar
Dispatch daysNovember 2026
Tables
Dispatch days
34 sample rows · 10 columnsWho is on which truck each day, the area and kind of work, and whether the day was worked.
| Dispatch day | Technician | Truck | Area | Work | Starts | Hours |
|---|---|---|---|---|---|---|
| JW-4101 | Ambrose Thistlewood-Okeke | Oct 22, 11:30 AM | 8 | |||
| JW-4102 | Cordelia Vasquez-Lindahl | Oct 23, 11:30 AM | 9 | |||
| JW-4103 | Leopold Mwangi-Strand | Oct 26, 11:30 AM | 8 | |||
| JW-4104 | Marisela Fenn-Adebayo | Oct 27, 11:30 AM | 10 | |||
| JW-4105 | Tiberius Hollingsworth-Cho | Oct 28, 11:30 AM | 7 | |||
| JW-4106 | Ambrose Thistlewood-Okeke | Oct 29, 11:30 AM | 8 | |||
| JW-4107 | Cordelia Vasquez-Lindahl | Oct 30, 11:30 AM | 9 | |||
| JW-4108 | Leopold Mwangi-Strand | Nov 2, 12:30 PM | 8 | |||
| JW-4109 | Marisela Fenn-Adebayo | Nov 3, 12:30 PM | 10 | |||
| JW-4110 | Tiberius Hollingsworth-Cho | Nov 4, 12:30 PM | 7 | |||
| JW-4111 | Ambrose Thistlewood-Okeke | Nov 5, 12:30 PM | 8 | |||
| JW-4112 | Cordelia Vasquez-Lindahl | Nov 6, 12:30 PM | 9 |
Licenses and cards
24 sample rows · 9 columnsThe licenses, permits and safety cards each technician holds, with the day each lapses.
| File number | Technician | Kind | Number on the card | Issued | Expires | Standing |
|---|---|---|---|---|---|---|
| HC-3104 | Ambrose Thistlewood-Okeke | REF-615367 | Jun 5, 2024 | Nov 10, 2026 | ||
| HC-3118 | Tiberius Hollingsworth-Cho | GAS-640413 | Dec 2, 2024 | Nov 14, 2026 | ||
| HC-3116 | Marisela Fenn-Adebayo | DOT-636835 | Dec 7, 2025 | Dec 7, 2026 | ||
| HC-3112 | Leopold Mwangi-Strand | CPR-629679 | Dec 22, 2024 | Dec 10, 2026 | ||
| HC-3102 | Ambrose Thistlewood-Okeke | MEC-611789 | Dec 22, 2024 | Dec 17, 2026 | ||
| HC-3108 | Cordelia Vasquez-Lindahl | DOT-622523 | Dec 17, 2025 | Dec 17, 2026 | ||
| HC-3120 | Tiberius Hollingsworth-Cho | DOT-643991 | Dec 27, 2025 | Dec 27, 2026 | ||
| HC-3109 | Leopold Mwangi-Strand | MEC-624312 | Aug 10, 2023 | Jan 6, 2027 | ||
| HC-3123 | Leopold Mwangi-Strand | DOT-649358 | Jan 26, 2026 | Jan 21, 2027 | ||
| HC-3119 | Tiberius Hollingsworth-Cho | CPR-642202 | Apr 1, 2025 | Mar 27, 2027 | ||
| HC-3115 | Marisela Fenn-Adebayo | REF-635046 | Apr 1, 2025 | Apr 1, 2027 | ||
| HC-3106 | Cordelia Vasquez-Lindahl | MEC-618945 | Jul 10, 2025 | May 1, 2027 |
Training sessions
20 sample rows · 7 columnsClasses technicians are booked into, with the hours away from trucks and what each class costs.
| Session | Technician | Course | Class day | Hours | Class fee | Status |
|---|---|---|---|---|---|---|
| TR-320 | Marisela Fenn-Adebayo | Jul 20, 1:00 PM | 8 | $220 | ||
| TR-318 | Leopold Mwangi-Strand | Aug 3, 1:00 PM | 6 | $180 | ||
| TR-319 | Tiberius Hollingsworth-Cho | Aug 17, 1:00 PM | 16 | $260 | ||
| TR-301 | Ambrose Thistlewood-Okeke | Aug 31, 1:00 PM | 16 | $395 | ||
| TR-302 | Cordelia Vasquez-Lindahl | Sep 21, 1:00 PM | 8 | $220 | ||
| TR-303 | Leopold Mwangi-Strand | Oct 7, 1:00 PM | 12 | $310 | ||
| TR-304 | Marisela Fenn-Adebayo | Oct 15, 1:00 PM | 6 | $180 | ||
| TR-305 | Tiberius Hollingsworth-Cho | Oct 26, 1:00 PM | 4 | $140 | ||
| TR-306 | Ambrose Thistlewood-Okeke | Nov 3, 2:00 PM | 8 | $220 | ||
| TR-307 | Cordelia Vasquez-Lindahl | Nov 10, 2:00 PM | 16 | $260 | ||
| TR-308 | Leopold Mwangi-Strand | Nov 13, 2:00 PM | 16 | $395 | ||
| TR-316 | Nadezhda Rasmussen-Ofori | Nov 27, 2:00 PM | 4 | $140 |
New hires
7 sample rows · 8 columnsEach technician's first weeks, from the signed offer to the first day alone on a truck.
| Onboarding | Technician | Status | Offer accepted | Paperwork in | Driving record checked | Ride-along began |
|---|---|---|---|---|---|---|
| NH-801 | Ambrose Thistlewood-Okeke | Aug 1, 2017 | Aug 11, 2017 | Aug 13, 2017 | Aug 21, 2017 | |
| NH-802 | Cordelia Vasquez-Lindahl | Nov 13, 2020 | Nov 23, 2020 | Nov 26, 2020 | Dec 3, 2020 | |
| NH-803 | Leopold Mwangi-Strand | Oct 29, 2021 | Nov 6, 2021 | Nov 9, 2021 | Nov 16, 2021 | |
| NH-804 | Marisela Fenn-Adebayo | Oct 29, 2023 | Nov 8, 2023 | Nov 11, 2023 | Nov 18, 2023 | |
| NH-805 | Tiberius Hollingsworth-Cho | Oct 23, 2024 | Nov 1, 2024 | Nov 3, 2024 | Nov 10, 2024 | |
| NH-806 | Nadezhda Rasmussen-Ofori | Nov 2, 2026 | Nov 10, 2026 | Nov 13, 2026 | — | |
| NH-807 | Bartholomew Kessler-Amadi | Nov 20, 2026 | — | — | — |
Also included
- New hire checklist
- Card running outWarns the dispatcher a month before a license or safety card lapses.
- Cards lapsing soon
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.
Related templates
- Electrical contractorWillowmere Gate Electric4 tables · 8 views · 2 forms · 2 dimension sets · 1 dashboard · 1 digest · 1 checklist · 1 document · 1 notification · 1 agent
- Masonry contractorVineholt Point Masonry4 tables · 7 views · 1 form · 3 dimension sets · 1 portal · 1 digest · 1 notification · 1 stage rule set · 1 agent
- Pool constructionMarrowgate Row Pools & Spas4 tables · 6 views · 1 form · 3 dimension sets · 1 digest · 1 checklist · 1 notification · 1 agent
- Solar installerHazelmere Row Solar5 tables · 7 views · 1 form · 1 portal · 1 digest · 1 notification · 1 stage rule set · 1 agent
- Tree serviceThornhollow Park Tree Care5 tables · 9 views · 2 forms · 4 dimension sets · 1 dashboard · 1 digest · 1 document · 1 notification · 1 agent
- Cabinet makerOrchardine Station Cabinetry4 tables · 5 views · 1 form · 2 dimension sets · 1 booking page · 1 dashboard · 1 notification · 1 stage rule set · 1 row action · 1 agent