Report · Chapter 14

What the dashboards mean

A reading of the report pages for the people who will act on the register, and what to do next.

107 RFIs Four dashboard pages 13 October 2026
A site plan laid over a construction photograph.

Section 1The register in one view

The project has 107 questions. Ninety-nine have a written reply. Eight are still open, and all eight sit with CT. Nineteen record a change to a drawing, a specification, or both. Thirty-seven still do not say whether a document changed.

That is the whole register. The four dashboard pages are four ways of looking at the same 107 rows. The executive page is the project picture. The document page is what has to change on paper. The coordination page is who asked and who still owes an answer. The register is the row behind each count. A detail view opens one question when a row is selected.

Most of the work is already answered, and most of it is electrical specification questions from one contractor. The unfinished work is smaller, and it is not sitting with the busiest designer.

What a manager needsWhat the dashboards show
Is the register under control?99 of 107 have a reply. The response rate is 92.52%.
What is still open?Eight RFIs, all tasked to CT, all labelled Other, all with an unknown document impact.
What must change in the documents?19 RFIs. Sixteen of those change both the drawing and the specification. Electrical holds 11 of the 19.
Who is carrying the questions?DAVID BOLAND, INC asked 71, and all 71 are answered. AE was tasked with 66, and all 66 are answered.

Section 2What to do next

Six actions follow from the pages. They are for the project team, not for a later model.

Do thisWhy the dashboards say so
Answer the eight open RFIs, with CT. They are the whole backlog. They arrived on 14, 16, and 21 September, from Dobco, Inc., Richard Group LCC, and Willdan. They ask about liquidated damages, the award and notice to proceed, prevailing wage, a tax certificate, the share of work the contractor performs, hand delivery of the bid, a funding date, and adjusting the bid for material prices. They are bid and contract questions. They are not drawing conflicts.
Write Yes or No on the 37 unknown document notes. Unknown means the note is blank or only says an attachment was sent. It is about a third of the register. Treating it as “no change” would hide that third. Other, General, Quality / Inspection, and Compliance Requirement hold most of it.
Review the 19 confirmed document updates, starting with Electrical. Sixteen of the 19 change both the drawing and the specification. Electrical has 11. Specification Clarification is the source of 15 of the 19. Architectural is 2 of 3, so that high rate is not the workload.
Ask the tasked party, not the contractor who wrote the question. DAVID BOLAND, INC submitted the most and has nothing open. AE holds the most assignments and has nothing open. CT holds every open RFI, at a response rate of 46.67%. On the register, the party filter is the submitter. Selecting AE or CT there shows an empty list.
Read 4 September as one intake day. Sixty-seven of the 107 RFIs arrived that day. The later days are smaller. Every question received through 10 September is answered. The line between those dates is the drop after that one day.
Give “Other” a real home. Other is 24 RFIs. Twenty-three of them have an unknown document impact, and all eight open RFIs are in it. It is a leftover label, not a discipline.

If the team wants to know how long a question has been waiting, the register needs the date the reply was written. Every row has a received date. None has an answered date, so the dashboards cannot show days open.

Section 3How to use the pages

Open the published report rif_vis. It has four pages. The project file in data/processed/powerbi uses the same 107 rows. Its page names are Executive overview, Engineering analysis, Document control, and RFI register. Selecting a row opens a hidden RFI detail page.

Published pageUse it to
Executive overviewSee the five cards, the day the questions arrived, and the mix of discipline, issue type, and submitter.
Drawing and specification changesSee which questions change a drawing, a specification, or both, and which notes are still unknown.
Coordination and responsibilitySee who asked and who was tasked. This is the page that shows CT holding the eight open RFIs.
RFI registerFind the row. Search an RFI number, or filter by status, discipline, and document impact, then read the question.

Start with the cards. Open the document page before saying a drawing is unchanged. Open the coordination page before asking a contractor why their question is still open. Use the register to read the words.

Section 4What the labels can do

Discipline and issue type on the dashboards are labels already stored on each row. They are there so a chart can sort the register. Specification Clarification is 62 of 107, so it will lead every issue-type chart. Electrical is 40 of 107.

A first automatic check of the issue-type labels was run on 105 of the 107 questions. It agreed with the stored label about 7 times in 10. It did that mostly by calling questions specification clarifications. It did not pick out the drawing conflicts, the interface questions, or the material questions. Constructability (RFI-023) and Scope Gap (RFI-096) were left out of that check because each label appears once.

Use the charts to see the mix. Have a person confirm a rare label, and have a person confirm any document change. The label sorts the work. It does not answer the RFI.

Section 5What the dashboards do not say

Answered means the reply box has text. It does not mean the contractor has accepted the reply, and it does not mean the design is settled. A response rate of 92.52% is not a clean bill of health while 37 document notes are still unknown.

The dashboards do not show cost, days of delay, or a schedule impact. They do not close an RFI, and they do not revise a drawing. Those decisions stay with the people named on the coordination page.