Report · Chapter 4

Clean RFI table

What remained after cleaning the raw register into records that can be analysed.

Source: data/processed/rfi_clean.csv 107 RFIs 4 October 2026
An engineer reviewing a building model and charts on a tablet at the site.

Section 1Cleaning result

04_clean_rfi.py read data/processed/raw_rfi.csv and wrote data/processed/rfi_clean.csv. The workbook and the raw table were not changed.

CheckResult
Raw rows read112
Rows kept107
Rows excluded5
RFI identifiersRFI-001 to RFI-107
Questions present107
Leading or double spaces left0

Each kept identifier is zero-padded, so source number 1 is RFI-001. Excel serial dates are calendar dates. Because the source Status column was empty, a response sets status to Answered and response_available to Yes. A blank response sets them to Open and No.

Section 2Rows left out

Five raw rows were not RFI records. They are listed in data/processed/rfi_excluded.csv.

Raw identifierReason
RFIs received after the due dateSection label, not an RFI record
108Identifier only, no party, date, or question
109Identifier only, no party, date, or question
110Identifier only, no party, date, or question
111Identifier only, no party, date, or question

Section 3Status

99 of 107 kept RFIs have a response. Eight do not.

StatusResponse availableRFIs
AnsweredYes99
OpenNo8

The open records are RFI-086, RFI-092, RFI-093, RFI-095, RFI-096, RFI-100, RFI-106, and RFI-107.

Section 4Dates

Received dates run from 1 September 2026 to 21 September 2026. Nine dates appear. 4 September accounts for 67 of the 107 RFIs.

Date receivedRFIs
2026-09-011
2026-09-026
2026-09-0467
2026-09-1011
2026-09-142
2026-09-151
2026-09-168
2026-09-173
2026-09-218

Section 5Parties

After the five empty rows were removed, every kept RFI has a submitting party and a tasked party. DAVID BOLAND, INC submitted 71 RFIs. AE was tasked with 66.

FromRFIs
DAVID BOLAND, INC71
Carbon Recall Chattanooga11
Willdan8
Dobco, Inc.8
Richard Group LCC8
Schweitzer Engineering Laboratories, Inc.1
TaskedRFIs
AE66
CT15
PM9
JBMDL8
AE/JBMDL4
AE/JBMDL/PM1
AE/PM1
CT/PM1
JBMDL/AE1
USACE DB1

Section 6Notes

72 kept RFIs have a note. 35 notes are blank. The filled notes are still the same six phrases found in the raw table.

NoteRows
No spec/drawing update required.51
Updated spec/dwg included15
Correct attachment sent to USACE for inclusion in the set.2
Drawing update provided as part of RFI-472
Updated spec/dwg included/ Redundant with RFI-081
Updated spec included1

Section 7First 10 clean rows

Question text is shortened here. The full text is in rfi_clean.csv.

RFI From Tasked Date received Status Question Notes
RFI-001 Schweitzer Engineering Laboratories, Inc. JBMDL 2026-09-01 Answered The specifications identify approved electric meter models for AMRS integration. Would the Government accept the…
RFI-002 Willdan AE 2026-09-02 Answered Battery Energy Storage System Capacity Discrepancy The solicitation appears to contain conflicting BESS sizing… Updated spec/dwg included
RFI-003 Willdan CT 2026-09-02 Answered Applicable Davis-Bacon Wage Determination The solicitation references a wage determination associated with Burlington…
RFI-004 Willdan CT/PM 2026-09-02 Answered Site Walk Date Clarification The solicitation references a site visit as occurring on "Friday, 03 September 2026."…
RFI-005 Willdan AE/JBMDL 2026-09-02 Answered Existing SCADA Integration Requirements The specifications reference integration between the new microgrid control… No spec/drawing update required.
RFI-006 Willdan AE/JBMDL 2026-09-02 Answered Cybersecurity / RMF Requirements The specifications include multiple references to cybersecurity support and RMF… No spec/drawing update required.
RFI-007 Willdan CT 2026-09-02 Answered CPARS and Past Performance Questionnaires (PPQs) The Supplementary Instructions to Bidders references Contractor…
RFI-008 DAVID BOLAND, INC AE 2026-09-04 Answered Spec: 09 06 00 – Schedules for Finishes, 09 90 00 – Paints and Coatings Question: Paragraph 1.6.3 of Section 09 90 00… Updated spec/dwg included
RFI-009 DAVID BOLAND, INC AE 2026-09-04 Answered Spec: 01 45 35 Special Inspections Question: Subpart 1.2 of Section 01 45 35 of the specifications states that the… Correct attachment sent to USACE for inclusion in the set.
RFI-010 DAVID BOLAND, INC AE 2026-09-04 Answered 1. Discipline: Structural Sheet: S-501 Detail: K15 Spec: Question: On Sheet S-501 Detail K15 calls out a typical… No spec/drawing update required.