{"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":{"external_links":1,"defined_names":6},"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."]

{"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 Emergency Call Handling Software 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"]
[null,"Tablets",{"$nulls":3},{"$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":24,"n_cols":10,"rows_kept":24,"merged":[[0,0,0,9],[23,0,23,4],[26,0,26,1]]}
["SECTION C:  Ongoing Support, Maintenance, and Hosting Services for Emergency Call Handling Software (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,"Emergency Calling Software"]
[1,"County Administrator Licenses",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"}]
[]
[2,"County Standard User License (Call Taking)",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"}]
[]
[3,"County Standard User License (Dispatching)",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"}]
[]
[null,"Support Services and Maintenance"]
[4,"Tech Support (24/7/365)",null,"Per Year",null,{"$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"}]
[]
[5,"Annual Maintenance",null,"Per Year",null,{"$f":"C16*E16","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,"Annual Refresher Training: System Administrators",null,"Per Annual Training",null,{"$f":"C18*E18","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,"Annual Refresher Training: Users",null,"Per Annual Training",null,{"$f":"C20*E20","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"]
[8,"Hosting Fee",null,"Per Unit",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"}]
["TOTAL:",{"$nulls":4},{"$f":"SUM(F7,F9,F11,F14,F16,F18,F20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G7,G9,G11,G14,G16,G18,G20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H7,H9,H11,H14,H16,H18,H20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I7,I9,I11,I14,I16,I18,I20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J7,J9,J11,J14,J16,J18,J20)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"D. Interfaces","index":3,"n_rows":14,"n_cols":11,"rows_kept":14,"merged":[[0,0,0,9],[2,10,2,18],[13,0,13,4],[16,0,16,1]]}
["SECTION D:  Interface Costs for Emergency Call Handling Software System"]
[]
["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","*Offeror shall specify if this is a system they have interfaced to previously or not."]
[null,"Mandatory Interfaces"]
[1,"Computer Aided Dispatch application; all environments",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,"API for connection to Public Safety Data Warehouse (PSDW)",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,"Post-Implementation Development Hours"]
[3,"Development Work (200 hours annually for continued interface support)",200,"Per Hour",null,{"$f":"C10*E10","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"]
[4,"Development",null,"Hourly Rate",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"}]
["TOTAL:",{"$nulls":4},{"$f":"SUM(F5:F13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G5:G13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H5:H13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I5:I13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J5:J13)","v":{"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 Emergency Call Handling Software 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 Emergency Call Handling Software 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":"'[1]B. Hardware'!F15","v":0}]
[]
["C.","Support & Maintenance",{"$f":"'C. Support & Maintenance'!F24","v":0},{"$f":"'C. Support & Maintenance'!G24","v":0},{"$f":"'C. Support & Maintenance'!H24","v":0},{"$f":"'C. Support & Maintenance'!I24","v":0},{"$f":"'C. Support & Maintenance'!J24","v":0}]
[]
["D.","Interfaces",{"$f":"'D. Interfaces'!F14","v":0},{"$f":"'D. Interfaces'!G14","v":0},{"$f":"'D. Interfaces'!H14","v":0},{"$f":"'D. Interfaces'!I14","v":0},{"$f":"'D. Interfaces'!J14","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," System TOTAL:",{"$f":"SUM(C4:C12)","v":0},{"$f":"SUM(D4:D12)","v":0},{"$f":"SUM(E4:E12)","v":0},{"$f":"SUM(F4:F12)","v":0},{"$f":"SUM(G4:G12)","v":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 Emergency Call Handling Software 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.2,"d":"20%"}]
[]
[6,"Reliability",null,{"v":0.1,"d":"10%"}]
[]
[]
[]
[null,"CAD System TOTAL:",{"$f":"SUM(C4:C16)","v":0},{"$f":"SUM(D4:D16)","v":{"v":1.0000000000000002,"d":"100%"}}]
[]
[null,"Total value shall be calculated by all Year 1 costs"]