Excel for a site: what moved today
A daily progress board is one row per task on this site. The planned quantity you type is the amount you are measuring against. The done quantity you type is the latest cumulative amount you saw. IF marks the row behind when done is less than planned. COUNTIFS counts the rows marked behind. A diary, one line per task per day, is a log. This board is the sheet you open when someone asks where the work stands. You edit the done quantity in place. You do not add a row because a new morning started. The guide below is that board. Elyx writes the gap and the flag from the numbers you typed. You still decide what the crew does next. The trial lasts 7 days, with no card.
- The daily progress board
- An exception log, if you need an owner and an age on a blockage
- A project status report, if you want the wider file
Frequently asked questions
What is one row on the progress board?
One task on this site: the zone, the planned quantity, the done quantity, and the unit. The flag compares done with planned.
Where does yesterday's increment go?
In a log, if you need the history. This board keeps the latest done quantity. The note can say what changed today.
Does the sheet know the programme?
No. You type the planned quantity. The formula does not read a contract, a drawing, or a date you did not type.