Data gaps & decisions

• work_plan_person_months

These do not exist as structured fields anywhere in the source workbooks. Any estimate method that requires them is blocked rather than guessed.

thresholds

{"total_person_months_max":5000,"role_fte_months_max":400,"hourly_rate_band":[10,500],"threshold_adjustment":"role fte_months above 400 was RETAINED where the workbook's own price = fte_months x bill_rate x hours/month identity reconciles to within 2% (hours/month taken from hours_basis_per_month, or derived as the median implied factor across that workbook's rows when it sits in 80-200 h/month). 4 of 6 such rows were corroborated this way and kept; 2 were nulled."}

records_touched

20

figures_nulled

33

placeholder_rows_dropped

411

corrections

[{"slug":"federal-investigation-case-management-system-info-may-2026-rfi","field":"roles[] (rows dropped)","role":null,"nulled_value":5,"why":"all-zero / all-null placeholder row x5"},{"slug":"fl-health-facility-electronic-licensing-system-replacement-rfi-april-2026","field":"roles[] (rows dropped)","role":null,"nulled_value":2,"why":"all-zero / all-null placeholder row x2"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Project Manager","nulled_value":7.5,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"Project Manager","nulled_value":1200,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Development/Integration Lead","nulled_value":12,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"Development/Integration Lead","nulled_value":1920,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Business Analyst/Trainer","nulled_value":12,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"Business Analyst/Trainer","nulled_value":1920,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Project Manager","nulled_value":3.75,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"Project Manager","nulled_value":600,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Business Analyst","nulled_value":12,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"Business Analyst","nulled_value":1920,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Technical Architect","nulled_value":2.0000000000000004,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Development Lead","nulled_value":17,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"Development Lead","nulled_value":2720,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Developers","nulled_value":67,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"Developers","nulled_value":10720,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Designers","nulled_value":3,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Testers","nulled_value":7,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"Testers","nulled_value":1120,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"Solution Architect","nulled_value":6,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"Solution Architect","nulled_value":960,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].company","role":"DevOps","nulled_value":5.25,"why":"numeric value in a text column — parser column shift"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[].bill_rate","role":"DevOps","nulled_value":840,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"fl-pinellas-county-human-services-arpa-mar-2024","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"all-zero / all-null placeholder row x1"},{"slug":"ga-child-support-system-sep-2025","field":"roles[].location","role":"Cardinality","nulled_value":4361600,"why":"numeric value in a text column — parser column shift"},{"slug":"ga-child-support-system-sep-2025","field":"roles[].company","role":"Cardinality","nulled_value":7948800,"why":"numeric value in a text column — parser column shift"},{"slug":"ga-child-support-system-sep-2025","field":"roles[].bill_rate","role":"Cardinality","nulled_value":16228800,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"ga-child-support-system-sep-2025","field":"roles[].location","role":"Unisys","nulled_value":2083200,"why":"numeric value in a text column — parser column shift"},{"slug":"ga-child-support-system-sep-2025","field":"roles[].company","role":"Unisys","nulled_value":2534400,"why":"numeric value in a text column — parser column shift"},{"slug":"ga-child-support-system-sep-2025","field":"roles[].bill_rate","role":"Unisys","nulled_value":2065600,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"ga-child-support-system-sep-2025","field":"roles[].location","role":"Accenture","nulled_value":1449600,"why":"numeric value in a text column — parser column shift"},{"slug":"ga-child-support-system-sep-2025","field":"roles[].company","role":"Accenture","nulled_value":1689600,"why":"numeric value in a text column — parser column shift"},{"slug":"ga-child-support-system-sep-2025","field":"roles[].bill_rate","role":"Accenture","nulled_value":1200000,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"ga-child-support-system-sep-2025","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"all-zero / all-null placeholder row x1"},{"slug":"ga-dph-vital-events-registration-system-vers-info-may-2026-rfi","field":"roles[] (rows dropped)","role":null,"nulled_value":2,"why":"all-zero / all-null placeholder row x2"},{"slug":"ga-natural-resources-modernizing-permitting-and-compliance-system-mpacs-rfi-jan-2026","field":"roles[] (rows dropped)","role":null,"nulled_value":3,"why":"all-zero / all-null placeholder row x3"},{"slug":"id-electronic-visit-verification-nov-2025","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"sheet header row leaked into staffing x1"},{"slug":"il-environmental-information-management-system-dec-2025","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"sheet header row leaked into staffing x1"},{"slug":"in-fssa-medicaid-fraud-and-abuse-detection-system-feb-2026","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"sheet header row leaked into staffing x1"},{"slug":"nd-ai-assisted-investigation-and-reporting-solution-jan-2026","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"all-zero / all-null placeholder row x1"},{"slug":"nd-comprehensive-child-welfare-information-system-ccwis-nov-2025","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"all-zero / all-null placeholder row x1"},{"slug":"nd-docr-corrections-and-rehabilitation-client-management-system-cms-feb-2026","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"all-zero / all-null placeholder row x1"},{"slug":"new-hampshire-granite-families-ccwis-sep-2021","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"all-zero / all-null placeholder row x1"},{"slug":"nv-comprehensive-childcare-welfare-system-ccwis-oct-2025","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"all-zero / all-null placeholder row x1"},{"slug":"nv-dpbh-radiation-producing-machines-licensing-software-system-feb-2026","field":"roles[] (rows dropped)","role":null,"nulled_value":1,"why":"all-zero / all-null placeholder row x1"},{"slug":"nys-foster-parent-nov-2024","field":"roles[].bill_rate","role":"Executive Sponsor / Account Manager","nulled_value":0,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"nys-foster-parent-nov-2024","field":"roles[].bill_rate","role":"Delivery Lead","nulled_value":0,"why":"outside plausible hourly rate band $10-$500/hour — dollar total or hours count landed in a rate column"},{"slug":"va-provider-hub-services-dec-2025","field":"roles[] (rows dropped)","role":null,"nulled_value":97,"why":"TBD-<n> placeholder row, zero/absent effort and price x97"},{"slug":"va-vccs-student-conduct-case-management-software-mar-2026","field":"roles[] (rows dropped)","role":null,"nulled_value":97,"why":"TBD-<n> placeholder row, zero/absent effort and price x97"},{"slug":"vt-dail-direct-care-worker-registry-dec-2025","field":"roles[] (rows dropped)","role":null,"nulled_value":96,"why":"TBD-<n> placeholder row, zero/absent effort and price x96"},{"slug":"vt-vocational-rehabilitation-customer-relationship-management-system-nov-2025","field":"roles[] (rows dropped)","role":null,"nulled_value":98,"why":"TBD-<n> placeholder row, zero/absent effort and price x98"}]

effort_reconciliation_flags

[{"slug":"ca-cdss-childcare-connect-system-rfi-may-2026","stated":178.16,"role_sum":194.16,"delta_pct":9},{"slug":"ca-doj-rfi-juvenile-court-and-probation-statistical-system-may-2022","stated":1290,"role_sum":1538,"delta_pct":19.2},{"slug":"in-medicaid-fraud-and-abuse-detection-system-july2025","stated":190,"role_sum":209,"delta_pct":10}]

authoritative_index

sorted_keys.txt

index_header_count

174

folders_in_index

174

folders_with_record

156

folders_without_record

18

coverage_pct

89.7

missing_folder_indices

[26,34,55,56,57,60,62,69,73,75,82,89,94,96,101,103,104,107]

missing_folders

[{"index":26,"folder_name":"FL APS June 2022"},{"index":34,"folder_name":"GA AI LLM Oct 2024"},{"index":55,"folder_name":"Indiana DNR Sport and Commercial Licensing Sep 2022"},{"index":56,"folder_name":"Indiana EHR Firefly Mar 2023"},{"index":57,"folder_name":"Indiana IDoE Sep 2021"},{"index":60,"folder_name":"IOWA DHHS LMS Sep 2023"},{"index":62,"folder_name":"KY Jefferson County AI Pilot"},{"index":69,"folder_name":"MA Probation Case Management Feb 2022"},{"index":73,"folder_name":"MD MMIS RFR Dec 2022"},{"index":75,"folder_name":"MI WIC Vendor Module Modernization Aug 2023"},{"index":82,"folder_name":"MS CCWIS Apr 2021"},{"index":89,"folder_name":"NC Provider DM CVO RFI - Sep 2025 "},{"index":94,"folder_name":"ND UI Modernisation RFI Aug 2022"},{"index":96,"folder_name":"New Mexico CCWIS Sep 2022"},{"index":101,"folder_name":"NV DCFS CMS Aug 2024"},{"index":103,"folder_name":"NY Chapter 683 Applications Modernization June 2025"},{"index":104,"folder_name":"NY North Country CRM Job Matching - June 2025"},{"index":107,"folder_name":"NYS OCFS Community Resource Portal Apr 2025"}]

records_read

156

records_failed_to_join

0

failed_joins

[]

duplicate_folder_records

[]

empty_folder_cross_check

{"empty_folders_listed_in_recon":35,"matched_to_index":35,"unmatched_names":[],"non_empty_folders_in_index":139,"non_empty_folders_with_a_record":139,"non_empty_coverage_pct":100,"missing_folders_that_are_confirmed_empty":[26,34,55,56,57,60,62,69,73,75,82,89,94,96,101,103,104,107],"missing_folders_with_real_content":[],"empty_folders_that_do_have_a_stub_record":17,"verdict":"All 18 folders without a record are among the 35 subfolders recon.md confirmed are completely empty (children == [] in folderA_tree.json). Substantive coverage is therefore 139/139 = 100% of non-empty folders: NO opportunity data is missing. What is inconsistent is bookkeeping — 17 of the 35 empty folders got a stub record from their shard and 18 did not."}

join_method

folder_name on both sides normalized: U+202F/U+00A0/U+2007/U+2009 -> ASCII space, curly quotes -> ASCII, en/em/minus dashes -> hyphen, NFKC, whitespace runs collapsed, stripped, casefolded. Worker-claimed shard ranges and "Corpus index N" notes were NOT trusted; index membership was re-derived from the name join. Cross-checks: 0 of 156 records disagreed with their own claimed "Corpus index N" note, 0 failed to join, 0 folders had two records, and all 18 folders lacking a record are in recon.md's list of 35 confirmed-empty subfolders — so no off-by-one and no data loss survived into records_safe.