Crew and vehicle scheduling

Work planner

A 31-day schedule of people and vehicles with warnings about gaps in staffing — one screen instead of a spreadsheet doing the rounds.

In a company that sends several crews into the field every day, the schedule usually lives in a spreadsheet that one person emails around and another prints and corrects with a pen. This application replaces that spreadsheet with a single board showing every job, the people assigned, the vehicles and whatever is missing.

A 31-day board

Jobs in rows, days in columns. Every job shows the crew, the number of days, the volume and a list of gaps — no vehicle, no driver, no team leader. People and vehicles are dragged from the pool on the left straight onto a job.

Calendar view

The same month shown as a calendar: for each day the number of crews, the number of drivers and shortened job names with the estimated mileage. Good for a quick check on whether a given week is overloaded.

Job profitability

A separate tab works out what a job cost and what was left of it: cost per person-day, cost per job, a split across vehicles, people, office and materials, and next to it the margin and a comparison with the previous period. Below, the application states plainly which simplifications it accepts — flat rates for mileage, accommodation, the euro rate — so nobody takes these figures for more precise than they are.

People and fleet

A staff record with role, phone number and an “available for crews” switch, and beside it the vehicle list: make, category, mileage, roadworthiness and the dates for inspection and insurance. A vehicle past its date is highlighted in red, so it does not have to be tracked in a calendar.

Reports and permissions

A separate section for work reports, overtime awaiting approval and accounts with permissions. Every change to the schedule lands in a log, so it can be undone and you can check who moved what.

Gallery

The 31-day board — jobs, assigned crews and the list of gaps
The 31-day board — jobs, assigned crews and the list of gaps
The same month as a calendar, with crew counts and mileage
The same month as a calendar, with crew counts and mileage
Job accounting — amounts masked, only the margin and the change against the previous period visible
Job accounting — amounts masked, only the margin and the change against the previous period visible
The job list ordered by revenue — each row with its margin and how complete the figures are (amounts masked)
The job list ordered by revenue — each row with its margin and how complete the figures are (amounts masked)
The staff record with an availability switch (personal data masked)
The staff record with an availability switch (personal data masked)
The fleet with mileage and inspection and insurance dates — an overdue row turns red
The fleet with mileage and inspection and insurance dates — an overdue row turns red
Work reports and accounts with permissions
Work reports and accounts with permissions