Equipment fleet · Excel
How do you manage a construction equipment fleet well in Excel?
A well-built Excel file relies on clear columns per machine (identifier, category, make and model, serial number, site, hour meter, last and next VGP, status) and on simple rules for keeping it up to date. This works for a small fleet tracked by a single person, but becomes fragile as soon as several people work on the same file.
You track your construction equipment in Excel and want to organise it well. Here are the useful columns, the rules to follow, and how far this method can take you.
Recommended columns for an equipment tracking spreadsheet
A construction equipment fleet tracking file benefits from being structured with one row per machine, with fixed columns. Here is a solid base.
| Column | What it is for |
|---|---|
| Identifier | A unique internal number to find the machine across every other column |
| Category | Type of machine: mini excavator, MEWP, telehandler, etc. |
| Make / model | To find the manufacturer's manual and the right parts |
| Serial no. | Official identification of the machine, useful in case of an inspection or an incident |
| Location / site | Know where the machine is at any given time |
| Hour meter | Basis for calculating servicing and usage-based inspections |
| Last VGP | Date of the last regulatory inspection carried out |
| Next VGP | Date or deadline not to be missed |
| Status | In service, stopped, under repair, out of service |
| Comments | Free-text notes: fault observed, part to order, etc. |
Discipline rules to keep the file reliable
A spreadsheet is only useful if it is kept regularly up to date. A few simple rules stop it becoming outdated.
- Designate a single person responsible for updates, to avoid conflicting versions
- Update the hour meter and the machine's status on a fixed schedule (for example every week)
- Record any fault observed in the field immediately, rather than relying on memory
- Check VGP and servicing deadlines at the start of the week, not only when an inspection is already overdue
- Back up the file regularly, somewhere other than the computer of the person who maintains it
The limits of this method
This setup works well as long as a single person maintains the file and the fleet stays small. As soon as several people are involved (site manager, mechanic, operator), the risk of competing versions of the same file grows, and one update can overwrite another without anyone noticing.
The file does not send an automatic alert before a deadline: someone has to remember to open and check it. Nor is it designed to be filled in from the field, without a network, with a photo attached to a fault observed on a machine.
- Reliable with a single responsible person, more fragile with several
- No automatic alert before a deadline
- No practical use from the field or offline
- No photo easily attached to a fault
- History that depends entirely on update discipline
When to move to the next step
As long as the file stays easy to keep up to date and no one complains about not knowing a machine's status, there is no urgency to change tools. However, if several people need to edit it, if an inspection deadline has already been missed, or if the fleet exceeds what one person can easily track, it becomes worth considering a CMMS (computerised maintenance management system), which keeps the same logic of a record per machine, but with alerts, mobile access and a shared history (see the page /gmao-c-est-quoi).
What changes in practice when several sites are involved
A single Excel file becomes particularly hard to manage as soon as equipment moves between several sites. You then have to either duplicate information across several sheets, or centralise a single file accessed remotely, which multiplies the risk of data being overwritten between two simultaneous updates.
In this situation, the advantage of a shared online tool, viewable by every site manager from their phone, becomes clearer than a simple local file: everyone sees the same up-to-date information, without depending on an email being sent.
An example of day-to-day practice
In practice, a row in the table reads as follows: machine "MP-014", a mini excavator assigned to a given site, with its current hour meter, the date of its last VGP, the planned date for the next one, its status "in service", and in the comments a useful observation, for example a minor leak observed but judged not critical.
This type of row, repeated for each machine and regularly updated, gives the fleet manager a reliable overview, provided everyone follows the same entry discipline.
When your Excel file becomes hard to keep up to date with several people, Trackary picks up the same information in a per-machine record with alerts and history: a 30-minute video demo. Request a demo →