Site Diary
The diary that puts you in the best position when a claim comes.
One five-minute form a day on site, and six flat data tables that build themselves underneath, ready to pivot. Most diaries record the day and bury it; this one keeps every observation as a row that can be counted, filtered and cross-referenced the moment a claim needs it.
What you get
Why it's built this way
The problem with most site diaries
A diary is usually written for the day it records: a page of prose, a PDF, a photo of a notebook. The facts a claim needs are in there, but not in a form anyone can count. So before analysis can start, someone reads months of pages and retypes every gang, delay and delivery into a table, slow work billed by the hour. I know, because I am usually that someone.
What this one does differently
The day sheet stays a one-page form: five minutes at the end of the shift, signed the same day, exported to PDF for the daily record. The difference is underneath. Every line lands as a row in six flat tables, one each for days, labour, plant, deliveries, progress and events, collected as day tabs are added. Nothing to maintain, no second write-up: keep the diary and the dataset builds itself.
One vocabulary, so the data adds up
The form's dropdowns read from a project vocabulary you type once: your areas as the drawings name them, your gangs, trades, plant and suppliers, plus a fixed list of event categories covering access, late information, weather, preceding trades, instructions, stoppages and out-of-sequence working. The whole job is described in the same words, which lets the data aggregate instead of fragmenting into fifty spellings of it.
When the claim comes
Click into any table and insert a pivot. Hours lost by cause by location, standing plant by week with the reason, man-hours by trade against measured progress, every access delay with the day sheet, photo and instruction it cross-references. Patterns and outliers surface in minutes, whether you are building your own claim or defending someone else's, and analysis starts the day the question is asked, not after weeks of retyping.
An Excel template with no macros. Only the yellow cells can be edited, the Guide tab explains every step, and it prints on A4. Your contract's terms come first.
Related paid help
For the diary fitted to your contract and your people, and checked monthly once it is running, see the Records & Monthly Check service.