Tabellab
Business & Operations Intermediate

Field Service by the Numbers: Work Orders, Travel vs On-Site Time, Jobs per Technician-Day, First-Time Fix, Repeat Visits, Van Stock, Appointment Windows, Response Targets & a Dashboard

Run the numbers of a fictional heating service company in 20 hands-on labs – work-order logs, travel and on-site time, jobs per technician-day, first-time fix, repeat visits, van stock, appointment windows, response targets, zone travel, seasonal capacity, cost per visit, contracts and a service dashboard – with every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

In 20 hands-on labs you run the numbers of a fictional heating service company with 18 vans in three regions. You turn work-order logs into on-site minutes and first-time-fix rates, split a paid technician-day into travel, on-site, admin and waiting time and calculate jobs per day and weekly capacity. You flag repeat visits within 30 days, decide which parts go on the van, check appointment windows and response targets on a working-hours clock, plan a day, compare zone allocations, size seasonal capacity, price visits and contracts, cost wasted trips and finish with a region-level service dashboard.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. A Week of Work Orders: First-Time Fix & TravelLabFree
  2. The Work-Order Log: Jobs per Region & WeekdayLab Locked
  3. Anatomy of a Technician-Day: Where the Hours GoLab Locked
  4. Jobs per Technician-Day & Weekly CapacityLab Locked
  5. First-Time Fix by Job Type, Region & Revisit ReasonLab Locked
  6. Repeat Visits Within 30 DaysLab Locked
  7. Van Stock: What to Carry and What It BuysLab Locked
  8. Appointment Windows: AM/PM vs 2-Hour SlotsLab Locked
  9. Response Targets on a Working-Hours ClockLab Locked
  10. Planning One Day: Start, End and OvertimeLab Locked
  11. Travel Zones: Home-Zone vs Any-Zone AllocationLab Locked
  12. Seasonal Demand: Technicians Needed per MonthLab Locked
  13. Capacity vs Demand: Gaps and Subcontractor DaysLab Locked
  14. Cost per Visit: Labour, Van, Parts vs PriceLab Locked
  15. Service Contracts: Fee vs Expected Visit CostLab Locked
  16. Wasted Trips: Cancellations, No Access & a Reminder RuleLab Locked
  17. Second Visits for Parts: How Long Customers WaitLab Locked
  18. Region Comparison: KPIs vs Targets in One IndexLab Locked
  19. One More Van vs Overtime vs SubcontractorLab Locked
  20. Final Project: The Service DashboardLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy