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 19, 11:30 AM | 8 | |||
| JW-4102 | Cordelia Vasquez-Lindahl | Oct 20, 11:30 AM | 9 | |||
| JW-4103 | Leopold Mwangi-Strand | Oct 21, 11:30 AM | 8 | |||
| JW-4104 | Marisela Fenn-Adebayo | Oct 22, 11:30 AM | 10 | |||
| JW-4105 | Tiberius Hollingsworth-Cho | Oct 23, 11:30 AM | 7 | |||
| JW-4106 | Ambrose Thistlewood-Okeke | Oct 26, 11:30 AM | 8 | |||
| JW-4107 | Cordelia Vasquez-Lindahl | Oct 27, 11:30 AM | 9 | |||
| JW-4108 | Leopold Mwangi-Strand | Oct 28, 11:30 AM | 8 | |||
| JW-4109 | Marisela Fenn-Adebayo | Oct 29, 11:30 AM | 10 | |||
| JW-4110 | Tiberius Hollingsworth-Cho | Oct 30, 11:30 AM | 7 | |||
| JW-4111 | Ambrose Thistlewood-Okeke | Nov 2, 12:30 PM | 8 | |||
| JW-4112 | Cordelia Vasquez-Lindahl | Nov 3, 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 1, 2024 | Nov 6, 2026 | ||
| HC-3118 | Tiberius Hollingsworth-Cho | GAS-640413 | Nov 28, 2024 | Nov 10, 2026 | ||
| HC-3116 | Marisela Fenn-Adebayo | DOT-636835 | Dec 3, 2025 | Dec 3, 2026 | ||
| HC-3112 | Leopold Mwangi-Strand | CPR-629679 | Dec 18, 2024 | Dec 6, 2026 | ||
| HC-3102 | Ambrose Thistlewood-Okeke | MEC-611789 | Dec 18, 2024 | Dec 13, 2026 | ||
| HC-3108 | Cordelia Vasquez-Lindahl | DOT-622523 | Dec 13, 2025 | Dec 13, 2026 | ||
| HC-3120 | Tiberius Hollingsworth-Cho | DOT-643991 | Dec 23, 2025 | Dec 23, 2026 | ||
| HC-3109 | Leopold Mwangi-Strand | MEC-624312 | Aug 6, 2023 | Jan 2, 2027 | ||
| HC-3123 | Leopold Mwangi-Strand | DOT-649358 | Jan 22, 2026 | Jan 17, 2027 | ||
| HC-3119 | Tiberius Hollingsworth-Cho | CPR-642202 | Mar 28, 2025 | Mar 23, 2027 | ||
| HC-3115 | Marisela Fenn-Adebayo | REF-635046 | Mar 28, 2025 | Mar 28, 2027 | ||
| HC-3106 | Cordelia Vasquez-Lindahl | MEC-618945 | Jul 6, 2025 | Apr 27, 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 15, 1:00 PM | 8 | $220 | ||
| TR-318 | Leopold Mwangi-Strand | Jul 29, 1:00 PM | 6 | $180 | ||
| TR-319 | Tiberius Hollingsworth-Cho | Aug 12, 1:00 PM | 16 | $260 | ||
| TR-301 | Ambrose Thistlewood-Okeke | Aug 26, 1:00 PM | 16 | $395 | ||
| TR-302 | Cordelia Vasquez-Lindahl | Sep 16, 1:00 PM | 8 | $220 | ||
| TR-303 | Leopold Mwangi-Strand | Oct 2, 1:00 PM | 12 | $310 | ||
| TR-304 | Marisela Fenn-Adebayo | Oct 12, 1:00 PM | 6 | $180 | ||
| TR-305 | Tiberius Hollingsworth-Cho | Oct 21, 1:00 PM | 4 | $140 | ||
| TR-306 | Ambrose Thistlewood-Okeke | Oct 29, 1:00 PM | 8 | $220 | ||
| TR-307 | Cordelia Vasquez-Lindahl | Nov 5, 2:00 PM | 16 | $260 | ||
| TR-308 | Leopold Mwangi-Strand | Nov 10, 2:00 PM | 16 | $395 | ||
| TR-316 | Nadezhda Rasmussen-Ofori | Nov 25, 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 | Jul 28, 2017 | Aug 7, 2017 | Aug 9, 2017 | Aug 17, 2017 | |
| NH-802 | Cordelia Vasquez-Lindahl | Nov 9, 2020 | Nov 19, 2020 | Nov 22, 2020 | Nov 29, 2020 | |
| NH-803 | Leopold Mwangi-Strand | Oct 25, 2021 | Nov 2, 2021 | Nov 5, 2021 | Nov 12, 2021 | |
| NH-804 | Marisela Fenn-Adebayo | Oct 25, 2023 | Nov 4, 2023 | Nov 7, 2023 | Nov 14, 2023 | |
| NH-805 | Tiberius Hollingsworth-Cho | Oct 19, 2024 | Oct 28, 2024 | Oct 30, 2024 | Nov 6, 2024 | |
| NH-806 | Nadezhda Rasmussen-Ofori | Oct 29, 2026 | Nov 6, 2026 | Nov 9, 2026 | — | |
| NH-807 | Bartholomew Kessler-Amadi | Nov 16, 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