| Source file | NYS IES EECM GCOM Pricing March 2022 |
| Tab used | Summary |
| Tabs in workbook | Summary, Software Pricing, Implementation Plan, Pricing Reference |
| File modified | 2022-03-23T12:36:26.918Z |
| Documents snapshot | propshop-archive/drive snapshot 2026-09-03 |
Extractor confidence
| Field | Confidence |
|---|
| 0 | m |
| 1 | e |
| 2 | d |
| 3 | i |
| 4 | u |
| 5 | m |
Fields the extractor could not find
agencydomainddi_valuemo_valuewarranty_valuesaas_valuelicense_valuethird_party_valuevalue_by_yearduration_months_ddiduration_months_mocontract_term_monthsuser_countuser_count_notecounties_or_officesprimesubcontractorshours_basis_per_monthmodulesdeliverablesphasesassumptionsrfp_summarysoftware_and_toolscompetitor_data
Extraction notes
Gen-1/2 workbook (March 2022 vintage) whose 'Summary' tab uses the same 'Period / Year:' / 'Total to the state' / 'Totals' column layout as the later Gen-3 template, just without the DDI/Warranty/M&O phase split -- a label-based lookup (not the generic ddi/mo/warranty phase parser, since this tab has no per-phase period columns) was used to pull total_contract_value only; ddi_value/mo_value/warranty_value are left null rather than guessed. 'Implementation Plan' carries a full per-role monthly-headcount grid with its own 'Total'/'Price' columns spanning 48 months, which produced a large total_person_months (2702) across 25 role rows for what looks like a multi-year enterprise integration program -- plausible given the program's scale, but hand-check recommended since it could not be cross-validated against a matching total_contract_value breakdown by phase. || SYNTHESIS SANITY: total_person_months=2702.0 is extreme but was retained — role rows reconcile and price = fte_months x bill_rate x hours_basis holds to <2%, so the figure is internally consistent bid effort, not a dollar-sum artefact. SANITY: role 'Developers' fte_months=596.0 exceeds the 400 threshold but was RETAINED — price(2803584) = fte_months x bill_rate(28.00) x implied hours/month(168) reconciles to 1.000, so it is a genuine multi-FTE pooled row on a long programme.