{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Summary","Short Term","Long Term","Employee","Commercial","Head-end System","Software","Services","Warranty","Alternates"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,0,6,1],[22,0,22,1],[25,0,25,1],[35,0,35,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[5,0,5,1],[3,0,3,1],[14,0,14,1],[18,0,18,1]]}
["Eastern Iowa Airport"]
["Parking Access and Revenue Control System"]
[]
["Price Proposal Form"]
[]
["SUMMARY"]
["PARCS HARDWARE"]
["Lane Equipment Short Term",{"$f":"'Short Term'!E16","v":0}]
["Lane Equipment Long Term",{"$f":"'Long Term'!E17","v":0}]
["Lane Equipment Employee",{"$f":"Employee!E16","v":0}]
["Lane Equipment Commercial",{"$f":"Commercial!E16","v":0}]
["Head-End Systems",{"$f":"'Head-end System'!E14","v":0}]
["Spare Parts",{"$f":"'Head-end System'!E46","v":0}]
["PARCS HARDWARE SUBTOTAL",{"$f":"SUM(B8:B13)","v":0}]
["SOFTWARE, INTERFACES AND INTEGRATIONS"]
["Software",{"$f":"Software!E15","v":0}]
["Integrations and Interfaces",{"$f":"Software!E35","v":0}]
["PARCS SOFTWARE, INTERFACES AND INTEGRATIONS  SUBTOTAL",{"$f":"SUM(B16:B17)","v":0}]
["CONSUMABLES AND SERVICES"]
["Consumables (Tickets, Receipts, etc.)",{"$f":"Services!E13","v":0}]
["Services (Design, Installation, Project Management, etc.)",{"$f":"Services!E31","v":0}]
["CONSUMABLES AND SERVCES SUBTOTAL",{"$f":"SUM(B20:B21)","v":0}]
[]
["PROJECT TOTAL",{"$f":"B14+B18+B22","v":0}]
[]
["RECURRING FEES"]
["Post-Warranty Maintenance - Year 1",{"$f":"Warranty!C24","v":0}]
["Post-Warranty Maintenance - Year 2",{"$f":"Warranty!C25","v":0}]
["Post-Warranty Maintenance - Year 3",{"$f":"Warranty!C26","v":0}]
["Post-Warranty Maintenance - Year 4",{"$f":"Warranty!C27","v":0}]
["Post-Warranty Maintenance - Year 5",{"$f":"Warranty!C28","v":0}]
["Post-Warranty Maintenance - Year 6",{"$f":"Warranty!C29","v":0}]
["Post-Warranty Maintenance - Year 7",{"$f":"Warranty!C30","v":0}]
["Post-Warranty Maintenance - Year 8",{"$f":"Warranty!C31","v":0}]
["Recurring Fees",{"$f":"Services!E36","v":0}]

{"sheet":"Short Term","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,15,3],[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,2,5,4]]}
[{"$f":"Summary!A1","v":"Eastern Iowa Airport"}]
["Parking Access and Revenue Control System"]
["Price Proposal Form"]
[]
["Short Term"]
["Item",null,"Cost",null,null,"Comments"]
["Parking Access and Revenue Control System",null,"Quantity","Unit Cost","Extension","Quantities as required for complete system."]
[null,"Entry Station",4,0,{"$f":"C8*D8","v":0}]
[null,"Exit Station",0,0,{"$f":"C9*D9","v":0}]
[null,"Barrier Gate",6,0,{"$f":"C10*D10","v":0}]
[null,"LPR Cameras",4,0,{"$f":"C11*D11","v":0}]
[null,"Coin & Credit PIL Station",0,0,0]
[null,"Radio Remote Control",2,0,0]
[null,"Intercom (Standalone)",0,0,{"$f":"C14*D14","v":0}]
[null,"Prox Card Reader/Intercom",0,0,0]
[null,"Lane Equipment","Subtotal:",null,{"$f":"SUM(E8:E15)","v":0}]

{"sheet":"Long Term","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,2,16,3],[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,2,5,4]]}
[{"$f":"Summary!A1","v":"Eastern Iowa Airport"}]
["Parking Access and Revenue Control System"]
["Price Proposal Form"]
[]
["Long Term"]
["Item",null,"Cost",null,null,"Comments"]
["Parking Access and Revenue Control System",null,"Quantity","Unit Cost","Extension","Quantities as required for complete system."]
[null,"Entry Station",4,0,{"$f":"C8*D8","v":0}]
[null,"Exit Station",4,0,{"$f":"C9*D9","v":0}]
[null,"Barrier Gate",9,0,{"$f":"C10*D10","v":0}]
[null,"LPR Cameras",9,0,{"$f":"C11*D11","v":0}]
[null,"Cash & Credit PIL Station",1,0,0]
[null,"Cashier Fee Computer",1,0,{"$f":"C13*D13","v":0}]
[null,"Radio Remote Control",0,0,0]
[null,"Intercom (Standalone)",0,0,{"$f":"C15*D15","v":0}]
[null,"Prox Card Reader/Intercom",0,0,0]
[null,"Lane Equipment","Subtotal:",null,{"$f":"SUM(E8:E16)","v":0}]

{"sheet":"Employee","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,15,3],[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,2,5,4]]}
[{"$f":"Summary!A1","v":"Eastern Iowa Airport"}]
["Parking Access and Revenue Control System"]
["Price Proposal Form"]
[]
["Employee"]
["Item",null,"Cost",null,null,"Comments"]
["Parking Access and Revenue Control System",null,"Quantity","Unit Cost","Extension","Quantities as required for complete system."]
[null,"Entry Station",0,0,{"$f":"C8*D8","v":0}]
[null,"Exit Station",0,0,{"$f":"C9*D9","v":0}]
[null,"Barrier Gate",2,0,{"$f":"C10*D10","v":0}]
[null,"LPR Cameras",0,0,{"$f":"C11*D11","v":0}]
[null,"Coin & Credit PIL Station",0,0,0]
[null,"Radio Remote Control",0,0,0]
[null,"Intercom (Standalone)",0,0,0]
[null,"Prox Card Reader/Intercom",2,0,0]
[null,"Lane Equipment","Subtotal:",null,{"$f":"SUM(E8:E15)","v":0}]

{"sheet":"Commercial","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,15,3],[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,2,5,4]]}
[{"$f":"Summary!A1","v":"Eastern Iowa Airport"}]
["Parking Access and Revenue Control System"]
["Price Proposal Form"]
[]
["Commercial"]
["Item",null,"Cost",null,null,"Comments"]
["Parking Access and Revenue Control System",null,"Quantity","Unit Cost","Extension","Quantities as required for complete system."]
[null,"Entry Station",0,0,{"$f":"C8*D8","v":0}]
[null,"Exit Station",0,0,{"$f":"C9*D9","v":0}]
[null,"Barrier Gate",1,0,{"$f":"C10*D10","v":0}]
[null,"LPR Cameras",0,0,{"$f":"C11*D11","v":0}]
[null,"Coin & Credit PIL Station",0,0,0]
[null,"Radio Remote Control",0,0,0]
[null,"Intercom (Standalone)",1,0,0]
[null,"Prox Card Reader/Intercom",0,0,0]
[null,"Lane Equipment","Subtotal:",null,{"$f":"SUM(E8:E15)","v":0}]

{"sheet":"Head-end System","index":5,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,2,45,3],[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,2,5,4],[13,2,13,3]]}
[{"$f":"Summary!A1","v":"Eastern Iowa Airport"}]
["Parking Access and Revenue Control System"]
["Price Proposal Form"]
[]
["HEAD END SYSTEMS AND SPARE PARTS HARDWARE"]
["Item",null,"Cost",null,null,"Comments"]
["Head-End Systems",null,"Quantity","Unit Cost","Extension","Quantities as required for complete system"]
[null,"Intercom Master Station",1,0,{"$f":"C8*D8","v":0}]
[null,null,0,0,{"$f":"C9*D9","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,"[additional items]",0,0,0]
[null,null,0,0,0]
[null,{"$f":"A7","v":"Head-End Systems"},"Subtotal:",null,{"$f":"SUM(E7:E13)","v":0}]
["Spare Parts",null,"Quantity","Unit Cost","Extension"]
[1,null,0,0,{"$f":"C16*D16","v":0}]
[2,null,0,0,0]
[3,null,0,0,0]
[4,null,0,0,0]
[5,null,0,0,0]
[6,null,0,0,0]
[7,null,0,0,0]
[8,null,0,0,0]
[9,null,0,0,0]
[10,null,0,0,0]
[11,null,0,0,0]
[12,null,0,0,0]
[13,null,0,0,0]
[14,null,0,0,0]
[15,null,0,0,0]
[16,null,0,0,0]
[17,null,0,0,0]
[18,null,0,0,0]
[19,null,0,0,0]
[20,null,0,0,0]
[21,null,0,0,0]
[22,null,0,0,0]
[23,null,0,0,0]
[24,null,0,0,0]
[25,null,0,0,0]
[26,null,0,0,0]
[27,null,0,0,0]
[28,null,0,0,0]
[29,null,0,0,0]
[30,null,0,0,0]
[null,{"$f":"A15","v":"Spare Parts"},"Subtotal:",null,{"$f":"SUM(E15:E45)","v":0}]

{"sheet":"Software","index":6,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,2,34,3],[14,2,14,3],[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,2,5,4]]}
[{"$f":"Summary!A1","v":"Eastern Iowa Airport"}]
["Parking Access and Revenue Control System"]
["Price Proposal Form"]
[]
["SOFTWARE, INTEGRATIONS, AND INTERFACES"]
["Item",null,"Cost",null,null,"Comments"]
["Software",null,"Quantity","Unit Cost","Extension","Quantities as required for complete system"]
[null,null,0,0,{"$f":"D8*C8","v":0}]
[null,"[additional items]",0,0,{"$f":"D9*C9","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,{"$f":"D12*C12","v":0}]
[null,null,0,0,0]
[null,null,0,0,{"$f":"D14*C14","v":0}]
[null,{"$f":"A7","v":"Software"},"Subtotal:",null,{"$f":"SUM(E7:E14)","v":0}]
["Integrations and Interfaces",null,"Quantity","Unit Cost","Extension"]
[null,"Entry Portal Sign",0,0,{"$f":"D17*C17","v":0}]
[null,"[additional items]",0,0,0]
[null,null,0,0,{"$f":"D19*C19","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,{"$f":"D23*C23","v":0}]
[null,null,0,0,{"$f":"D24*C24","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,{"$f":"D29*C29","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,{"$f":"A16","v":"Integrations and Interfaces"},"Subtotal:",null,{"$f":"SUM(E16:E34)","v":0}]

{"sheet":"Services","index":7,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,2,5,4],[34,2,34,4],[30,2,30,3],[12,2,12,3],[35,2,35,3],[31,2,31,4],[32,2,32,4],[33,2,33,4]]}
[{"$f":"Summary!A1","v":"Eastern Iowa Airport"}]
["Parking Access and Revenue Control System"]
["Price Proposal Form"]
[]
["CONSUMABLES, SERVICES AND RECURRING FEES"]
["Item",null,"Cost",null,null,"Comments"]
["Consumables",null,"Quantity","Unit Cost","Extension"]
[null,"Tickets",null,0,{"$f":"C8*D8","v":0}]
[null,"Receipts",null,0,0,"if different than tickets"]
[null,null,null,0,0]
[null,"[additional items]",null,0,0]
[null,null,null,0,{"$f":"C12*D12","v":0}]
[null,{"$f":"A7","v":"Consumables"},"Subtotal:",null,{"$f":"SUM(E8:E12)","v":0}]
["Services ",null,"Quantity","Unit Cost","Extension"]
[null,"Design Coordination",null,0,{"$f":"C15*D15","v":0}]
[null,"Installation",null,0,0]
[null,"Project Management",null,0,0]
[null,"Mobilization",null,0,0]
[null,"Bonding",null,0,0]
[null,"Training",null,0,{"$f":"C20*D20","v":0}]
[null,"Lane Acceptance Testing",null,0,0]
[null,"Final System Operational Testing -30 day",null,0,0]
[null,"Local Storage facility",null,0,0]
[null,"Freight",null,0,0]
[null,"Warranty",null,0,{"$f":"C25*D25","v":0}]
[null,"Sub-Contractor-1 [Describe]",null,0,{"$f":"C26*D26","v":0}]
[null,"Sub-Contractor-2 [Describe]",null,0,{"$f":"C27*D27","v":0}]
[null,"Sub-Contractor-3 [Describe]",null,0,{"$f":"C28*D28","v":0}]
[null,"[additional items]",null,0,0]
[null,null,null,0,{"$f":"C30*D30","v":0}]
[null,{"$f":"A14","v":"Services "},"Subtotal:",null,{"$f":"SUM(E15:E30)","v":0}]
["Annual Recurring Fees",null,"Fee"]
[null,null,0]
[null,"[additional items]",0]
[]
[null,{"$f":"A32","v":"Annual Recurring Fees"},"Subtotal:",null,{"$f":"SUM(C33:C35)","v":0}]

{"sheet":"Warranty","index":8,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,2,28,4],[29,2,29,4],[30,2,30,4],[16,2,16,4],[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,2,5,4],[6,2,6,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[31,0,31,5],[7,2,7,4],[15,2,15,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,0,21,5],[13,0,13,5],[14,2,14,4],[26,2,26,4],[27,2,27,4]]}
[{"$f":"Summary!A1","v":"Eastern Iowa Airport"}]
["Parking Access and Revenue Control System"]
["Price Proposal Form"]
[]
["WARRANTY/POST-WARRANTY MAINTENANCE"]
["Service Position",null,"Cost",null,null,"Comments"]
["WARRANTY HOURLY SERVICE RATES",null,"Hourly Service Rate",null,null,"For non-warranty service"]
[null,"Hardware Technician",0]
[null,"Network Engineer",0]
[null,"Server Engineer",0]
[null,"Software Engineer",0]
[null,"Database Engineer",0]
[null,"[additional items]",0]
[]
["POST-WARRANTY MAINTENANCE HOURLY SERVICE RATES",null,"Hourly Service Rate"]
[null,"Hardware Technician",0]
[null,"Network Engineer",0]
[null,"Server Engineer",0]
[null,"Software Engineer",0]
[null,"Database Engineer",0]
[null,"[additional items]",0]
[]
["POST-WARRANTY MAINTENANCE (YEARS 3-10)",null,"Annual Cost"]
[null,"Year 1",0]
[null,"Year 2",0]
[null,"Year 3",0]
[null,"Year 4",0]
[null,"Year 5",0]
[null,"Year 6",0]
[null,"Year 7",0]
[null,"Year 8",0]

{"sheet":"Alternates","index":9,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,0,24,5],[0,0,0,5],[1,0,1,5],[2,0,3,5],[4,0,4,5],[5,2,5,4],[10,0,10,5],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,0,29,5]]}
[{"$f":"Summary!A1","v":"Eastern Iowa Airport"}]
["Parking Access and Revenue Control System"]
["Price Proposal Form"]
[]
["ALTERNATE BID ITEMS"]
["Item",null,"Cost",null,null,"Comments"]
["Hardware",null,"Quantity","Unit Cost","Extension"]
[null,"UPS's",13,0,{"$f":"C8*D8","v":0}]
[null,"[additional items]",0,0,{"$f":"C9*D9","v":0}]
[null,null,0,0,0]
[]
["Software/Third Party Applications",null,"Quantity","Unit Cost","Extension"]
[null,null,0,0,{"$f":"C13*D13","v":0}]
[null,"[additional items]",0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,{"$f":"C22*D22","v":0}]
[null,null,0,0,0]
[null,null,null,0,{"$f":"C24*D24","v":0}]
[]
["Annual Recurring Fees",null,"Fee"]
[null,null,0]
[null,"[additional items]",0]
[null,null,0]