Report · Chapter 3

Raw table investigation

What the loaded raw RFI table contains, before any cleaning.

Source: data/processed/raw_rfi.csv 112 rows 4 October 2026
Drawings, a hard hat, and a laptop showing a building model on a site desk.

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/.

CheckResult
Rows112
Columns10
SchemaMatches the expected raw table
Source file on every rowrfi_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.

ColumnFilledBlankBlank %
rfi_number11200.00
from_party10754.46
tasked_to10754.46
date_received10754.46
question10754.46
response991311.61
notes724035.71
status_raw0112100.00
source_file11200.00
ingestion_timestamp11200.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.

ColumnUnique valuesNon-blank rows
rfi_number112112
from_party6107
tasked_to10107
date_received9107
question107107
response9399
notes672
status_raw00
source_file1112
ingestion_timestamp1112

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.

ColumnBlank rowsShortestAverageLongest
question566587.582,217
response136167.54737
notes402131.5858

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.

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 9Whitespace

No field has leading or trailing whitespace. Blank values are empty, not padded spaces.