How Roadsafe Asphalt Replaced Daily Excel Spreadsheets with a Scheduling System Built for the Field
Roadsafe Asphalt is a civil construction company specializing in asphalt, concrete, and road maintenance across Australia.
“It’s easy to see everything in one place. For us, the Excel spreadsheets we were sending out, this is a much friendlier format for guys out on the field to use.”
Key Results
- Field crews get shift details in real time, not at 6am via an Excel file no one could open
- Subcontractors onboarded and scheduled faster, without daily emails for every job
- Operations manager handles scheduling, time tracking, and subcontractor coordination in one platform
The Challenge: A Field Team Running on Morning Emails and Excel Files
With roughly 50 staff and a rotating mix of subcontractors working across different sites, coordinating the day’s work was a manual, last-minute process. Crews had no visibility until the morning email arrived.
- Field workers received their schedule via Excel spreadsheet at 6am, often unable to open it on their phones
- Subcontractors required individual emails for each new job, creating repetitive daily admin
- No scheduling system could show more than a single day at a time, making forward planning difficult
How Roadsafe Asphalt Uses Connecteam to Manage a Dispersed Field Operation
Roadsafe Asphalt uses Connecteam primarily for its profiling and trucking crews, who drive directly to site and never pass through the yard. The platform handles job scheduling and time clock for these workers, while subcontractors get access only to the job information they need.
- Custom shift templates are built for each job type, with fields for equipment, crew assignments, and location pin drops
- Subcontractors are added quickly and see only the relevant job details, eliminating daily email chains
- The scheduler displays work across weekly and monthly views, giving the operations manager full visibility ahead of time
Results That Affect Roadsafe Asphalt’s Bottom Line
Field-Ready Scheduling That Works on Any Phone
- Crews see their shifts in a clean, mobile-friendly format instead of scrolling through spreadsheet rows
- Shift details include location pins, equipment lists, and crew assignments in one view
- Roadsafe Asphalt manages a workforce ranging from 17 to 70 years old. The simpler format has made adoption practical across the board
Faster Subcontractor Coordination
- New subcontractors are added to Connecteam quickly, with no complex setup required
- Each subcontractor sees only their job information, keeping internal documents and other data private
- The scheduling process that once relied on individual daily emails now runs through a single shared platform
Before vs. After Connecteam
| Aspect | Before Connecteam | After Connecteam |
|---|---|---|
| Scheduling | Excel spreadsheet emailed at 6am. No advance visibility | Digital shifts viewable weekly and monthly. Updated in real time |
| Field Access | Staff tried to open Excel on phones. Files failed to load in Google Sheets | Mobile-friendly format. Works across all devices and age groups |
| Subcontractors | Individual email sent for each job, every day | Added once. Sees only relevant job info. No daily admin required |
| Shift Detail | Basic information in a spreadsheet | Location pin, equipment list, crew roles in one structured template |
| Time Clock | Not applicable for off-site crews | Crews clock in and out via Connecteam directly from the job site |
Why Connecteam Was the Right Move
Roadsafe Asphalt needed a platform that could handle a workforce spread across multiple sites, including workers who never come into the yard and subcontractors who change job to job. The old Excel-based process created a daily bottleneck and put the burden on staff to figure out how to open a file on their phones. Connecteam replaced that friction with a format the whole team could actually use.