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.
| Check | Result |
|---|---|
| Raw rows read | 112 |
| Rows kept | 107 |
| Rows excluded | 5 |
| RFI identifiers | RFI-001 to RFI-107 |
| Questions present | 107 |
| Leading or double spaces left | 0 |
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 identifier | Reason |
|---|---|
| RFIs received after the due date | Section label, not an RFI record |
| 108 | Identifier only, no party, date, or question |
| 109 | Identifier only, no party, date, or question |
| 110 | Identifier only, no party, date, or question |
| 111 | Identifier only, no party, date, or question |
Section 3Status
99 of 107 kept RFIs have a response. Eight do not.
| Status | Response available | RFIs |
|---|---|---|
| Answered | Yes | 99 |
| Open | No | 8 |
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 received | RFIs |
|---|---|
| 2026-09-01 | 1 |
| 2026-09-02 | 6 |
| 2026-09-04 | 67 |
| 2026-09-10 | 11 |
| 2026-09-14 | 2 |
| 2026-09-15 | 1 |
| 2026-09-16 | 8 |
| 2026-09-17 | 3 |
| 2026-09-21 | 8 |
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.
| From | RFIs |
|---|---|
| DAVID BOLAND, INC | 71 |
| Carbon Recall Chattanooga | 11 |
| Willdan | 8 |
| Dobco, Inc. | 8 |
| Richard Group LCC | 8 |
| Schweitzer Engineering Laboratories, Inc. | 1 |
| Tasked | RFIs |
|---|---|
| AE | 66 |
| CT | 15 |
| PM | 9 |
| JBMDL | 8 |
| AE/JBMDL | 4 |
| AE/JBMDL/PM | 1 |
| AE/PM | 1 |
| CT/PM | 1 |
| JBMDL/AE | 1 |
| USACE DB | 1 |
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.
| Note | Rows |
|---|---|
| No spec/drawing update required. | 51 |
| Updated spec/dwg included | 15 |
| Correct attachment sent to USACE for inclusion in the set. | 2 |
| Drawing update provided as part of RFI-47 | 2 |
| Updated spec/dwg included/ Redundant with RFI-08 | 1 |
| Updated spec included | 1 |
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. |