The control this drawing log needs
A drawing log fails in a quiet way: the list looks complete while one sheet points to a superseded revision. Before delegating the log, define the unit you track as one drawing sheet with one current revision and one receipt date. The assistant may update the row only when the incoming file matches the sheet number and title block.
Any mismatch becomes an exception rather than a silent edit, because a guessed revision number is harder to correct than a blank cell. The control needs a named owner for the log and a separate owner for the drawing set itself. Put both names on the first tab of the workbook so anyone opening the file knows who decides.
Link the log to the takeoff service page and to the correction note guide so the team sees the full workflow. Ground the process in AACE recommended practices for a documented and repeatable estimating routine.
What the assistant may and may not change
Write the edit boundary beside the log, not in a training slide that disappears after onboarding. The assistant may add a receipt row, attach the incoming file, and flag a missing title block. The assistant may not overwrite an accepted revision or change the basis date on a live estimate.
Those two actions stay with the estimator because they alter the record other people rely on. A simple two-column rule prevents most conflicts: read columns and write columns. Read columns include sheet number, title, and prior revision, while write columns include receipt date, file name, and exception code.
When a request falls outside the write columns, the assistant leaves a note and moves to the next sheet. That pause is the control working, not the assistant failing. Post the boundary at the top of the log so the rule is visible at the moment of editing.
A short note that says revisions are accepted only by the estimating lead prevents a well-meaning assistant from correcting the record. Review the note with the assistant during the first week, then spot-check it during the weekly sample. The boundary is a living instruction, not a one-time permission.
The daily revision receipt routine
The daily routine starts with a download check, not with data entry. The assistant confirms the file set matches the transmittal, opens each drawing title block, and records the receipt time in the log. A sheet that appears twice is treated as a conflict until the estimator confirms which file is current.
The routine ends only when every new file has a row and every exception has a code. Time-box the routine so the log does not become a place to hide unfinished work. A practical target is one pass in the morning and one short pass before the end of the day.
The morning pass clears new receipts, and the afternoon pass resolves exceptions that arrived during the day. If the queue grows for two days, the estimator reviews capacity before the log loses credibility. Use a single receipt timestamp for the file set rather than one timestamp per row.
The set timestamp makes it easier to compare the log to the transmittal later. If a file arrives late, add it as a new receipt instead of changing the original time. That preserves the sequence of what the team knew and when.
Exceptions that stop the handoff
Stop the handoff when a file has no title block, when two sheets share a sheet number, or when the transmittal lists a sheet that never arrived. Stop it again when a revision changes a dimension that feeds a current takeoff. In each case the assistant records the stop code, the time, and the person who owns the next action.
The estimator resolves the stop before the log accepts another revision for that sheet. The stop list should be short enough to remember and specific enough to test. Six codes cover most drawing log failures: missing file, duplicate sheet, revision conflict, unreadable scan, wrong project, and scope change.
Review the codes monthly and retire any code that has not appeared in a quarter. A code list that keeps growing usually means the team is documenting noise instead of risk.
Review evidence at week end
At the end of the week, sample five log rows and trace each one back to the source file. Confirm the receipt date, the revision, and the exception code all agree. Then check one row that the assistant marked complete and one row that was escalated.
The sample takes minutes and shows whether the boundary is being followed in ordinary work. Keep the weekly result in the same file as the log, with the reviewer initials and the date. Do not average away a missed row because the rest of the week looked clean.
A single unresolved revision can invalidate a takeoff, so the review reports the worst case first. Over time the sample history becomes the evidence that the delegation is stable. Report the sample result as a count, such as four of five rows traced cleanly, rather than a vague comment.
A count is easier to compare from week to week and harder to misinterpret. If a row fails, record the correction and the date it was fixed. The next sample can then check whether the fix held.
| Field | Check | Owner |
|---|---|---|
| Sheet identity | Sheet number and title block agree | Estimating assistant |
| Revision | Current file matches the transmittal | Estimating assistant |
| Exception | Coded and escalated with a time | Estimating lead |
| Basis date | Changed only by the estimator | Estimating lead |