Section 1Raw table
02_load_rfi_excel.py wrote data/processed/raw_rfi.csv. The original workbook was left unchanged. Cell values were copied as stored, including Excel date serials. Each row also records the source file and the time the table was loaded.
03_raw_rfi_investigation.py then checked that table. It did not clean or transform the rows. The saved checks are in data/processed/profiling/.
| Check | Result |
|---|---|
| Rows | 112 |
| Columns | 10 |
| Schema | Matches the expected raw table |
| Source file on every row | rfi_log.xlsx |
The columns are rfi_number, from_party, tasked_to, date_received, question, response, notes, status_raw, source_file, and ingestion_timestamp.
Section 2First 10 rows
These are the first 10 records in raw_rfi.csv. Question and response text is shortened here. status_raw is blank on each of these rows. Every row uses source file rfi_log.xlsx.
| RFI | From | Tasked | Date received | Question | Response | Notes |
|---|---|---|---|---|---|---|
| 1 | Schweitzer Engineering Laboratories, Inc. | JBMDL | 46266 | The specifications identify approved electric meter models for AMRS integration. Would the Government accept the SEL-735 Power Quality and… | Only the meters that are explicitly listed in the Meter Data Management Plan will be authorized on the… | |
| 2 | Willdan | AE | 46267 | Battery Energy Storage System Capacity Discrepancy The solicitation appears to contain conflicting BESS sizing information. The drawings… | Each individual BESS: 500KW/KWH Total System Power Capacity: 1.5MW Total System Energy Capacity: 1.5MWH Spec… | Updated spec/dwg included |
| 3 | Willdan | CT | 46267 | Applicable Davis-Bacon Wage Determination The solicitation references a wage determination associated with Burlington County, New Jersey.… | The Government acknowledges the inquiry regarding the geographic location of the project site at Joint Base… | |
| 4 | Willdan | CT/PM | 46267 | Site Walk Date Clarification The solicitation references a site visit as occurring on "Friday, 03 September 2026." However, 03 September… | Walk thru was held 9/3/26. | |
| 5 | Willdan | AE/JBMDL | 46267 | Existing SCADA Integration Requirements The specifications reference integration between the new microgrid control system and existing… | Concerning existing cybersecurity boundary requirements; Any connections to the existing base EMCS must be… | No spec/drawing update required. |
| 6 | Willdan | AE/JBMDL | 46267 | Cybersecurity / RMF Requirements The specifications include multiple references to cybersecurity support and RMF activities. Question:… | The contractor/vendor will not be responsible for the ATO. The contractor’s/vendor’s responsibility is to… | No spec/drawing update required. |
| 7 | Willdan | CT | 46267 | CPARS and Past Performance Questionnaires (PPQs) The Supplementary Instructions to Bidders references Contractor Representatives are… | This solicitation is an Invitation for Bid (IFB), and the award will be made to the responsible bidder with… | |
| 8 | DAVID BOLAND, INC | AE | 46269 | Spec: 09 06 00 – Schedules for Finishes, 09 90 00 – Paints and Coatings Question: Paragraph 1.6.3 of Section 09 90 00 of the specifications… | Concur, will strike the requirement for SSPC QP 1. | Updated spec/dwg included |
| 9 | DAVID BOLAND, INC | AE | 46269 | Spec: 01 45 35 Special Inspections Question: Subpart 1.2 of Section 01 45 35 of the specifications states that the “Schedule of Special… | Concur, this attachment has been sent to USACE for inclusion in the documents. | Correct attachment sent to USACE for inclusion in the set. |
| 10 | DAVID BOLAND, INC | AE | 46269 | 1. Discipline: Structural Sheet: S-501 Detail: K15 Spec: Question: On Sheet S-501 Detail K15 calls out a typical exterior pad detail. Note… | Detail K15 on sheet S-501 is to be used for Electrical Equipment Pad and Switchgear Pad | No spec/drawing update required. |
Section 3Completeness
Five rows have an RFI identifier and no party, date, or question. Status is blank on every row. Response and notes are the other fields with substantial gaps.
| Column | Filled | Blank | Blank % |
|---|---|---|---|
| rfi_number | 112 | 0 | 0.00 |
| from_party | 107 | 5 | 4.46 |
| tasked_to | 107 | 5 | 4.46 |
| date_received | 107 | 5 | 4.46 |
| question | 107 | 5 | 4.46 |
| response | 99 | 13 | 11.61 |
| notes | 72 | 40 | 35.71 |
| status_raw | 0 | 112 | 100.00 |
| source_file | 112 | 0 | 0.00 |
| ingestion_timestamp | 112 | 0 | 0.00 |
Section 4Uniqueness
Every RFI number is unique, and every non-blank question is unique. Some response texts repeat. Notes collapse into a few repeated phrases.
| Column | Unique values | Non-blank rows |
|---|---|---|
| rfi_number | 112 | 112 |
| from_party | 6 | 107 |
| tasked_to | 10 | 107 |
| date_received | 9 | 107 |
| question | 107 | 107 |
| response | 93 | 99 |
| notes | 6 | 72 |
| status_raw | 0 | 0 |
| source_file | 1 | 112 |
| ingestion_timestamp | 1 | 112 |
Section 5Duplicates
The table has no exact duplicate rows and no repeated RFI number.
Section 6Dates
All 107 populated date_received values are numeric Excel serials. None are already calendar dates. The serials run from 46266 to 46286, across 9 distinct values. Converting those serials is part of cleaning.
Section 7Text length
Questions are long. Responses are shorter. Notes are short repeated lines.
| Column | Blank rows | Shortest | Average | Longest |
|---|---|---|---|---|
| question | 5 | 66 | 587.58 | 2,217 |
| response | 13 | 6 | 167.54 | 737 |
| notes | 40 | 21 | 31.58 | 58 |
Section 8Notes
The 72 filled notes use only six phrases. Most say either that no drawing or specification update was required, or that an updated specification or drawing was included.
| 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 9Whitespace
No field has leading or trailing whitespace. Blank values are empty, not padded spaces.