{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["A.Implementation & Project Mgmt","B. Hardware","C. Support & Maintenance","D. Interfaces","E. Other Services","Total Cost","Payment Milestones"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"A.Implementation & Project Mgmt","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"merged":[[0,0,1,5],[3,0,3,5],[4,0,4,5],[13,0,13,4],[16,0,16,5]]}
["23-OEM-RFP-567: Computer Aided Dispatch (CAD) System"]
[]
[]
["ATTACHMENT A - COST PROPOSAL*"]
["SECTION A:  Project Management and Implementation Services for CAD System"]
[]
["Item No.","Item Description","QTY","Unit of Measure","Unit Price","Total Year 1 Price"]
[null,"Project Management Services"]
[1,"Project Management (provide details)",null,"Each",null,{"$f":"C9*E9","v":{"v":0,"d":"$0.00"}}]
[null,"Implementation Services"]
[2,"System Configuration and System Setup",null,"Each",null,{"$f":"C11*E11","v":{"v":0,"d":"$0.00"}}]
[]
[3,"Training & Support (For Initial Rollout)",null,"Each",null,{"$f":"C13*E13","v":{"v":0,"d":"$0.00"}}]
["TOTAL:",{"$nulls":4},{"$f":"SUM(F9,F11,F13)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["* Please modify this template as necessary to provide your firm's preliminary cost proposal. Final rates and fees will be negotiated with the awarded Offeror."]

{"sheet":"B. Hardware","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[0,0,0,9],[14,0,14,4]]}
["SECTION B:  Hardware Costs for CAD System RFP"]
[null,"Please provide a list of all hardware necessary for all systems.   The County may choose to purchase through their existing contracts."]
["Item No.","Item Description","Estimated Yearly Quantity","Unit of Measure","Unit Price","Total Year 1 Price","Year 2 Price","Year 3 Price","Year 4 Price","Year 5 Price"]
[null,"Hardware"]
[{"$nulls":5},{"$f":"C5*E5","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[{"$nulls":5},{"$f":"C7*E7","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[{"$nulls":5},{"$f":"C9*E9","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[null,"Hardware Warranties"]
[{"$nulls":5},{"$f":"C12*E12","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[{"$nulls":5},{"$f":"C14*E14","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["TOTAL:",{"$nulls":4},{"$f":"SUM(F5:F14)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G5:G14)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]

{"sheet":"C. Support & Maintenance","index":2,"n_rows":28,"n_cols":10,"rows_kept":28,"merged":[[0,0,0,9],[27,0,27,4],[30,0,30,1]]}
["SECTION C:  Ongoing Support, Maintenance, and Hosting Services for CAD System (recurring costs)"]
[]
["Item No.","Item Description","QTY","Unit of Measure","Unit Price","Total Year 1 Price","Year 2 Price","Year 3 Price","Year 4 Price","Year 5 Price"]
[null,"Mobile CAD Software"]
[1,"County Administrator Licenses",null,"Each",null,{"$f":"C5*E5","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[2,"County Standard User License",null,"Each",null,{"$f":"C7*E7","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"CAD Software"]
[3,"County Administrator Licenses",null,"Each",null,{"$f":"C9*E9","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[4,"County Standard User License (Call Taking)",null,"Each",null,{"$f":"C11*E11","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[5,"County Standard User License (Dispatching)",null,"Each",null,{"$f":"C13*E13","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[6,"Portal/Non-County User Licenses",null,"Each",null,{"$f":"C15*E15","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"Support Services and Maintenance"]
[7,"Tech Support (24/7/365)",null,"Per Unit",null,{"$f":"C17*E17","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[8,"Annual Maintenance",null,"Per Unit",null,{"$f":"C19*E19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[9,"Annual Refresher Training: System Administrators",null,"Per Annual Training",null,{"$f":"C21*E21","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[10,"Annual Refresher Training: Users",null,"Per Annual Training",null,{"$f":"C23*E23","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"Dedicated On-Site Full Time Equivalent: System Administrator"]
[11,"1.0 FTE System Administrator",null,"Annual Salary",null,{"$f":"C25*E25","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"Hosting Services"]
[12,"Hosting Fee",null,"Per Unit",null,{"$f":"C27*E27","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["TOTAL:",{"$nulls":4},{"$f":"SUM(F9,F11,F15,F17,F19,F27,F7,F5,F21,F23,F25)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G9,G11,G15,G17,G19,G27,G7,G5,G21,G23,G25)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]

{"sheet":"D. Interfaces","index":3,"n_rows":61,"n_cols":12,"rows_kept":61,"merged":[[0,0,0,10],[2,11,2,19],[60,0,60,5],[63,0,63,1]]}
["SECTION D:  Interface Costs for CAD System"]
[]
["Item No.","Item Description","QTY","Unit of Measure","New or Existing?","Unit Price","Total Year 1 Price","Year 2 Price","Year 3 Price","Year 4 Price","Year 5 Price","*Offeror shall specify if this is a system they have interfaced to previously or not."]
[null,"Mandatory Interfaces"]
[1,"Motorola VESTA NG9-1-1",null,"Each",null,null,{"$f":"C5*F5","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[2,"VCIN/NLETS/NCIC",null,"Each",null,null,{"$f":"C7*F7","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[3,"NCR/DEH",null,"Each",null,null,{"$f":"C9*F9","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[4,"ImageTrend (Fire RMS and ePCR)",null,"Each",null,null,{"$f":"C11*F11","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[5,"Criminal Justice Records Management System (CJRMS)",null,"Each",null,null,{"$f":"C13*F13","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[6,"Structured Emergency Dispatch Protocols",null,"Each",null,null,{"$f":"C15*F15","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[7,"ASAP-to-PSAP",null,"Each",null,null,{"$f":"C17*F17","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[8,"WestNet First-In Fire Station Alerting (WestNet First-In FSA)",null,"Each",null,null,{"$f":"C19*F19","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[9,"FirstDue (Pre-planning)",null,"Each",null,null,{"$f":"C21*F21","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[10,"Active 911",null,"Each",null,null,{"$f":"C23*F23","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[11,"IAR",null,"Each",null,null,{"$f":"C25*F25","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[12,"Everbridge",null,"Each",null,null,{"$f":"C27*F27","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[13,"RapidDeploy",null,"Each",null,null,{"$f":"C29*F29","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[14,"Astro P25 PTT",null,"Each",null,null,{"$f":"C31*F31","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[15,"Time Server",null,"Each",null,null,{"$f":"C33*F33","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[16,"GIS",null,"Each",null,null,{"$f":"C35*F35","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[17,"Public Safety Data Warehouse (PSDW)",null,"Each",null,null,{"$f":"C37*F37","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[18,"Microsoft Active Directory (AD)",null,"Each",null,null,{"$f":"C39*F39","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[19,"NICE Logging Recorder",null,"Each",null,null,{"$f":"C41*F41","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[null,"Optional Interfaces"]
[20,"Telestaff",null,"Each",null,null,{"$f":"C44*F44","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[21,"AlertUS",null,"Each",null,null,{"$f":"C46*F46","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[22,"MarcusAlert",null,"Each",null,null,{"$f":"C48*F48","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[23,"Axon",null,"Each",null,null,{"$f":"C50*F50","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[24,"Watch Desk",null,"Each",null,null,{"$f":"C52*F52","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[25,"Amazon Connect",null,"Each",null,null,{"$f":"C54*F54","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[null,"Post-Implementation Development Hours"]
[25,"Development Work (200 hours annually for continued interface support)",200,"Per Hour",null,null,{"$f":"C57*F57","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[null,"Post-Implementation Development Hourly Rate"]
[26,"Development",null,"Hourly Rate",null,null,{"$f":"C60*F60","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["TOTAL:",{"$nulls":5},{"$f":"SUM(G5:G60)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H5:H60)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]

{"sheet":"E. Other Services","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[0,0,0,9],[9,0,9,4]]}
["SECTION E:  Other Charges or Services for CAD System"]
[]
["Item No.","Item Description","Estimated Yearly Quantity","Unit of Measure","Unit Price","Total Year 1 Price","Year 2 Price","Year 3 Price","Year 4 Price","Year 5 Price"]
[1,{"$nulls":4},{"$f":"SUM(C4 * E4)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[2,{"$nulls":4},{"$f":"SUM(C5*E5)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[3,{"$nulls":4},{"$f":"SUM(C6*E6)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[4,{"$nulls":4},{"$f":"SUM(C7 * E7)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[5,{"$nulls":4},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[6,{"$nulls":4},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["TOTAL:",{"$nulls":4},{"$f":"SUM(F4:F9)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G4:G9)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]

{"sheet":"Total Cost","index":5,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[0,1,0,6],[16,1,16,6]]}
[null,"Total Costs for CAD System"]
[]
["Category #","Cost Category","Year 1 Price","Year 2 Price","Year 3 Price","Year 4 Price","Year 5 Price"]
["A","Implementation & Project Management",{"$f":"'A.Implementation & Project Mgmt'!F14","v":0}]
[]
["B","Hardware",{"$f":"'B. Hardware'!F15","v":0},{"$f":"'B. Hardware'!G15","v":0},{"$f":"'B. Hardware'!H15","v":0},{"$f":"'B. Hardware'!I15","v":0},{"$f":"'B. Hardware'!J15","v":0}]
[]
["C","Support & Maintenance",{"$f":"'C. Support & Maintenance'!F28","v":0},{"$f":"'C. Support & Maintenance'!G28","v":0},{"$f":"'C. Support & Maintenance'!H28","v":0},{"$f":"'C. Support & Maintenance'!I28","v":0},{"$f":"'C. Support & Maintenance'!J28","v":0}]
[]
["D","Interfaces",{"$f":"'D. Interfaces'!G61","v":0},{"$f":"'D. Interfaces'!H61","v":0},{"$f":"'D. Interfaces'!I61","v":0},{"$f":"'D. Interfaces'!J61","v":0},{"$f":"'D. Interfaces'!K61","v":0}]
[]
["E","Other Services",{"$f":"'E. Other Services'!F10","v":0},{"$f":"'E. Other Services'!G10","v":0},{"$f":"'E. Other Services'!H10","v":0},{"$f":"'E. Other Services'!I10","v":0},{"$f":"'E. Other Services'!J10","v":0}]
[]
[null,"CAD System TOTAL:",{"$f":"SUM(C4:C12)","v":0},{"$f":"SUM(D4:D12)","v":0},0,0,0]

{"sheet":"Payment Milestones","index":6,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[0,1,0,2],[20,1,20,2]]}
[null,"Payment Milestones for CAD System"]
[]
["Category #","Milestone Description","Milestone Cost","Milestone %"]
[1,"Contract Signing",null,{"v":0.1,"d":"10%"}]
[]
[2,"Installation/Configuration of Hardware",null,{"v":0.15,"d":"15%"}]
[]
[3,"Installation of Software",null,{"v":0.3,"d":"30%"}]
[]
[4,"Completion of System Testing, Training & Acceptance",null,{"v":0.15,"d":"15%"}]
[]
[5,"Go-Live",null,{"v":0.1,"d":"10%"}]
[]
[6,"Reliability: Interfaces",null,{"v":0.1,"d":"10%"}]
[]
[7,"Reliability: System",null,{"v":0.1,"d":"10%"}]
[]
[null,"CAD System TOTAL:",{"$f":"SUM(C4:C16)","v":0},{"$f":"SUM(D4:D16)","v":{"v":1,"d":"100%"}}]
[]
[null,"Total value shall be calculated by all Year 1 costs"]