| Source file | CA - DoJ - RFI - Juvenile Court and Probation Statistical System Pricing May 2022 |
| Tab used | Summary |
| Tabs in workbook | To be shared with DMI - 0806, Summary, Round 4 - DMI - 0308, Software Pricing, Implementation Plan with Data M, Pricing Template |
| File modified | 2022-05-16T11:05:31.830Z |
| 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
non_opportunity_reasonwarranty_valuesaas_valuelicense_valuethird_party_valueuser_countuser_count_notecounties_or_officeshours_basis_per_month
Extraction notes
Staffing header at row 61 of 'Implementation Plan with Data M' tab; no explicit Total-FTE or Hours/Month columns here (fte_months computed by summing the M1..M25 monthly decimals). 'Company' column literally reads 'Prime' vs 'Cardinality' — the real prime-contractor entity name is not stated in this workbook (tab name 'To be shared with DMI - 0806' hints it may be DMI, as in the AR CCWIS folder, but this is not confirmed in-sheet, hence recorded with low confidence). Two other tabs ('To be shared with DMI - 0806', 'Round 4 - DMI - 0308') are earlier negotiation-round variants of the same Summary grid, not opened in full given time constraints. 'Pricing Template' tab is the agency's own RFI cost-response form for 'JCPSS Replacement', totaling $10,041,000 (One-Time $7,251,900 + Maintenance $2,789,100 over 3 years) — a materially different total from our internal Summary tab ($9,595,404); both recorded as variants. || SYNTHESIS SANITY: role 'Developers' fte_months=630.0 exceeds the 400 threshold but was RETAINED — price(1587600) = fte_months x bill_rate(30.00) x implied hours/month(84) reconciles to 1.000, so it is a genuine multi-FTE pooled row on a long programme. SANITY: stated total_person_months=1290.0 disagrees with the sum of role fte_months (1538.0, +19.2%). Both are as-extracted; neither was overwritten. Treat effort for this opportunity as a range, not a point.