{"text_format":"1","workbook":"xlsx","n_sheets":35,"sheets":["Instructions","Info","Ex. 2-PM","Ex. 2-Team Lead","Ex. 2-Team Partner 1","Ex. 2-Team Partner 2","Ex. 2-S1","Ex. 2-S2","Ex. 2-S3","Ex. 2-S4","Ex. 2-S5","Ex. 2-S6","Ex. 2-S7","Ex. 2-S8","Ex. 2-S9","Ex. 2-S10","Ex. 2-S11","Ex. 2-S12","Ex. 2-S13","Ex. 2-S14","Ex. 2-S15","Ex. 2-S16","Ex. 2-S17","Ex. 2-S18","Ex. 2-S19","Ex. 2-S20","Ex. 2-S21","Ex. 2-S22","Ex. 2-S23","Ex. 2-S24","Ex. 3","Ex. 4","Ex. 5-Project Team Summary","Ex. 5-Project Summary","Ex. 4&5 Alt."],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":98,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Info","index":1,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[32,1,32,2],[33,1,33,2],[31,3,31,4],[32,3,32,4],[23,1,23,2],[24,1,24,2],[33,3,33,4],[28,1,28,2],[29,3,29,4],[25,1,25,2],[26,1,26,2],[27,1,27,2],[29,1,29,2],[30,1,30,2],[27,3,27,4],[28,3,28,4],[21,1,21,2],[31,1,31,2],[21,3,21,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[3,2,3,5],[4,2,4,5],[18,1,18,2],[19,1,19,2],[20,1,20,2],[18,3,18,4],[19,3,19,4],[20,3,20,4],[8,2,8,3],[9,2,9,3],[7,2,7,3],[45,1,45,2],[45,3,45,4],[46,1,46,2],[46,3,46,4],[30,3,30,4],[34,3,34,4],[35,3,35,4],[38,1,38,2],[39,1,39,2],[40,1,40,2],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[44,1,44,2],[37,1,37,2],[36,1,36,2],[35,1,35,2],[34,1,34,2],[44,3,44,4],[42,1,42,2],[43,1,43,2],[42,3,42,4],[43,3,43,4],[41,3,41,4],[41,1,41,2]]}
[null,"a",null,null,null,null,"Information Page",null,null,null,null,null,"E"]
[null,"a",null,null,null,null,null,null,null,null,null,null,"E"]
[null,"a",null,null,null,null,null,"Select one",null,null,null,2.5,"E"]
[null,"Contract Number / Description:",null,null,null,null,null,"CM","SINGLE PRIME",null,null,2.8,"E"]
[null,"Prime/Team Name:",null,null,null,null,null,"DSE","TEAM",null,null,null,"E"]
[null,"a",null,null,null,null,null,"CM Upon Request",null,null,null,null,"E"]
[null,"a",null,null,null,null,null,null,null,null,null,null,"E"]
[null,"Agreement Type:",null,null,null,null,null,"DSE Upon Request",null,null,null,null,"E"]
[null,"Vendor Type:",null,null,null,null,null,"Construction Corridor Manager",null,null,null,null,"E"]
[null,"Contract Type:",null,null,null,null,null,"Design Corridor Manager",null,null,null,null,"E"]
[null,"Multiplier:",null,null,null,null,null,"Geotechnical Svcs Upon Req","PRIME CONSULTANT",null,null,null,"E"]
[null,"a",null,null,null,null,null,"Program Management","TEAM LEAD",null,null,null,"E"]
[null,"Proposal Date:",null,{"$f":"TODAY()","v":"2025-11-17"},null,null,null,"Surveying & Land Acquisition Svcs","TEAM PARTNER",null,null,null,"E"]
[null,"Est. NTP Date:",null,"2024-09-01",null,null,null,"Utilities Upon Request","SUBCONSULTANT",null,null,null,"E"]
[null,"Duration (months):",null,36,null,null,null,"Other - Upon Request","2nd TIER SUBCONSULTANT",null,null,null,"E"]
[null,"Substantial Completion Date:",null,{"$f":"IFERROR(EOMONTH(EDATE(D14,D15-1),0),\"\")","v":"2027-08-31"},null,null,null,null,null,null,null,null,"E"]
[null,"Contract Expiration Date:",null,{"$f":"IFERROR(IF(C10=\"Select One\",\"\",IF(C10=\"DSE\",EDATE(D16,60),IF(C10=\"Design Corridor Manager\",EDATE(D16,60),IF(C10=\"DSE Upon Request\",EDATE(D16,60),IF(C10=\"CM\",EDATE(D16,24),IF(C10=\"CM Upon Request\",EDATE(D16,24),IF(C10=\"Construction Corridor Manager\",EDATE(D16,24),IF(C10=\"Geotechnical Svcs Upon Req\",EDATE(D16,60),IF(C10=\"Program Management\",EDATE(D16,60),IF(C10=\"Surveying & Land Acquisition Svcs\",EDATE(D16,60),IF(C10=\"Utilities Upon Request\",EDATE(D16,60),IF(C10=\"Other - Upon Request\",EDATE(D16,60))))))))))))),\"\")","v":false},null,null,null,null,null,null,null,null,"E"]
[null,2,3,4,5,6,null,null,null,null,null,null,"E"]
[null,"Consultant Name",null,"Consultant Type",null,"Exhibit 2 tab (in Excel)",null,null,null,null,null,null,"E"]
[{"$f":"F20","v":""},null,null,{"$f":"IF($C$9=\"SINGLE PRIME\",\"PRIME CONSULTANT\",IF($C$9=\"TEAM\",\"TEAM LEAD\",IF($C$9=\"\",\"\")))","v":""},null,{"$f":"_xlfn.IFS($C$9=\"Single Prime\",\"Ex. 2-PM\",$C$9=\"Team\",\"Ex. 2-Team Lead\",$C$9=\"\",\"\")","v":""},null,null,null,null,null,null,"E"]
[{"$f":"F21","v":""},null,null,{"$f":"IF($C$9=\"SINGLE PRIME\",\"\",IF($C$9=\"TEAM\",\"TEAM PARTNER 1\",IF($C$9=\"\",\"\")))","v":""},null,{"$f":"_xlfn.IFS($C$9=\"Single Prime\",\"\",$C$9=\"Team\",\"Ex. 2-Team Partner 1\",$C$9=\"\",\"\")","v":""},null,null,null,null,null,null,"E"]
[{"$f":"F22","v":""},null,null,null,null,{"$f":"_xlfn.IFS($C$9=\"Single Prime\",\"\",B22<>\"\",\"Ex. 2-Team Partner 2\",$C$9=\"\",\"\",B22=\"\",\"\")","v":""},null,null,null,null,null,null,"E"]
[{"$f":"F23","v":0},"dfgdf","wine",null,null,null,null,null,null,null,null,null,"E"]
["",null,null,null,null,{"$f":"IF(B24=\"\",\"\",\"Ex. 2-S1\")","v":""},null,null,null,null,null,null,{"$f":"F24","v":""}]
["",null,null,null,null,{"$f":"IF(B25=\"\",\"\",\"Ex. 2-S2\")","v":""},null,null,null,null,null,null,{"$f":"F25","v":""}]
["",null,null,null,null,{"$f":"IF(B26=\"\",\"\",\"Ex. 2-S3\")","v":""},null,null,null,null,null,null,{"$f":"F26","v":""}]
["",null,null,null,null,{"$f":"IF(B27=\"\",\"\",\"Ex. 2-S4\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B28=\"\",\"\",\"Ex. 2-S5\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B29=\"\",\"\",\"Ex. 2-S6\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B30=\"\",\"\",\"Ex. 2-S7\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B31=\"\",\"\",\"Ex. 2-S8\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B32=\"\",\"\",\"Ex. 2-S9\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B33=\"\",\"\",\"Ex. 2-S10\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B34=\"\",\"\",\"Ex. 2-S11\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B35=\"\",\"\",\"Ex. 2-S12\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B36=\"\",\"\",\"Ex. 2-S13\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B37=\"\",\"\",\"Ex. 2-S14\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B38=\"\",\"\",\"Ex. 2-S15\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B39=\"\",\"\",\"Ex. 2-S16\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B40=\"\",\"\",\"Ex. 2-S17\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B41=\"\",\"\",\"Ex. 2-S18\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B42=\"\",\"\",\"Ex. 2-S19\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B43=\"\",\"\",\"Ex. 2-S20\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B44=\"\",\"\",\"Ex. 2-S21\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B45=\"\",\"\",\"Ex. 2-S22\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B46=\"\",\"\",\"Ex. 2-S23\")","v":""},null,null,null,null,null,null,""]
["",null,null,null,null,{"$f":"IF(B47=\"\",\"\",\"Ex. 2-S24\")","v":""},null,null,null,null,null,null,""]
[null,"sdfsd"]

{"sheet":"Ex. 2-PM","index":2,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[14,1,14,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[8,1,8,2],[7,7,7,8],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,5,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-PM"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[null,null,null,null,null,null,null,"Services by Others",{"$f":"IF(Info!C9=\"Single Prime\",SUM('Ex. 2-S1'!I16,'Ex. 2-S2'!I16,'Ex. 2-S3'!I16,'Ex. 2-S4'!I16,'Ex. 2-S5'!I16,'Ex. 2-S6'!I16,'Ex. 2-S7'!I16,'Ex. 2-S8'!I16,'Ex. 2-S9'!I16,'Ex. 2-S10'!I16,'Ex. 2-S11'!I16,'Ex. 2-S12'!I16,'Ex. 2-S13'!I16,'Ex. 2-S14'!I16,'Ex. 2-S15'!I16,'Ex. 2-S16'!I16,'Ex. 2-S17'!I16,'Ex. 2-S18'!I16,'Ex. 2-S19'!I16,'Ex. 2-S20'!I16,'Ex. 2-S21'!I16,'Ex. 2-S22'!I16,'Ex. 2-S23'!I16,'Ex. 2-S24'!I16),0)","v":0}]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0},"Contingency"]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-Team Lead","index":3,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-Team Lead"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0},"Contingency"]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-Team Partner 1","index":4,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-Team Partner 1"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-Team Partner 2","index":5,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-Team Partner 2"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S1","index":6,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S1"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S2","index":7,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S2"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S3","index":8,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S3"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S4","index":9,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S4"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S5","index":10,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S5"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S6","index":11,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S6"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S7","index":12,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S7"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S8","index":13,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S8"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S9","index":14,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S9"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S10","index":15,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S10"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S11","index":16,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S11"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S12","index":17,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S12"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S13","index":18,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S13"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S14","index":19,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S14"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S15","index":20,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S15"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S16","index":21,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S16"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S17","index":22,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S17"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S18","index":23,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S18"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S19","index":24,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S19"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S20","index":25,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S20"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S21","index":26,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S21"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S22","index":27,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S22"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S23","index":28,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S23"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 2-S24","index":29,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[20,7,22,9],[21,1,21,2],[22,1,22,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[9,1,9,2],[3,2,3,8],[4,2,4,8],[7,1,7,4],[7,7,7,8],[8,1,8,2]]}
[{"$f":"VLOOKUP(A2,Info!A18:D47,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"Exhibit 2",null,null,null,null,"Select one",null,"Select 'Consultant Type'"]
[{"$f":"MID(CELL(\"filename\",V1),FIND(\"]\",CELL(\"filename\",V1))+1,255)","v":"Ex. 2-S24"},null,null,null,null,null,null,null,null,"TASKS, HOURS & FEES",null,null,null,"D/M/WBE",2.5,null,"PRIME CONSULTANT",null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VOSB",null,null,"TEAM LEAD",null,null,"Project Management"]
[null,"Contract Number / Description:",{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,null,null,"No Designation",null,null,"TEAM PARTNER",null,null,"Electrical"]
[null,"Prime/Team Name:",{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd TIER SUBCONSULTANT",null,null,"Freeways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Tasks and hours listed below are estimates at the time of proposal submission.\nTasks to be coordinated with Tollway PM.",null,null,null,null,null,{"$f":"VLOOKUP(A2,Info!A18:F47,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Breakdown of Scope by Task",null,"Total Hours","Avg. Hrs/Month",null,null,"DBE/Vet Designation",null,null,null,null,null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,null,null,null,null,null,null,"Role of Consultant"]
[null,null,null,null,null,null,null,"Direct Labor"]
[null,null,null,null,null,null,null,"Multiplier",{"$f":"Info!C11","v":0}]
[null,null,null,null,null,null,null,"Total Labor",{"$f":"IFERROR(I11*I12,0)","v":0}]
[null,null,null,null,null,null,null,"Direct Costs*"]
[]
[null,null,null,null,null,null,null,"Consultant (ULC)",{"$f":"SUM(I13:I15)","v":0}]
[null,null,null,null,null,null,{"$f":"I9","v":0}]
[null,null,null,null,null,null,null,"Total Hours",{"$f":"D31","v":0}]
[null,null,null,null,null,null,null,"Avg. Hrly Rate",{"$f":"IFERROR(I11/I18,0)","v":0}]
[]
[null,null,null,null,null,null,null,"* Direct Costs (Itemized)\nList expenses not included in the Allowable Direct Costs list or Vehicle Reimbursement links (below).  Written permission must be received from the Chief Engineering Officer prior to its inclusion and attached after Exhibit 2 as a PDF."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://agency.illinoistollway.com/documents/20184/1286703/ALLOWABLE%20DIRECT%20COSTS_11022025R.pdf/b3dab352-6ca0-47db-8d7c-db8e8821037b?version=4.0&t=1762275855182&download=true\",\"* Allowable Direct Costs (link here)\")","v":"* Allowable Direct Costs (link here)"}]
[null,"Total",null,{"$f":"SUM(D10:D30)","v":0},null,null,null,{"$f":"HYPERLINK(\"https://cms.illinois.gov/employees/travel/travelreimbursement.html\",\"* Vehicle Reimbursement (link here)\")","v":"* Vehicle Reimbursement (link here)"}]

{"sheet":"Ex. 3","index":30,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":true,"merged":[[14,1,15,5],[2,1,2,5],[3,1,3,2],[3,3,3,5],[4,3,4,5]]}
[null,null,null,null,null,"Exhibit 3",null,null,null,null,null,null,"Select one"]
[null,null,null,null,null,"PROJECT SCHEDULE NARRATIVE",null,null,null,null,null,null,"CM"]
[null,"This Exhibit is for Single Prime Consultants and Team Leads only",null,null,null,null,null,null,null,null,null,null,"DSE"]
[null,"Contract Number / Description:",null,{"$f":"Info!C4","v":0},null,null,null,null,null,null,null,null,"CM Upon Request"]
[null,"Prime/Team Name:",null,{"$f":"Info!C5","v":0},null,null,null,null,null,null,null,null,"DSE Upon Request"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Construction Corridor Manager"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Design Corridor Manager"]

{"sheet":"Ex. 4","index":31,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":true,"merged":[[22,1,22,2],[21,1,21,2],[13,1,13,2],[12,1,12,2],[11,1,11,2],[19,1,19,2],[18,1,18,2],[17,1,17,2],[16,1,16,2],[15,1,15,2],[14,1,14,2],[3,2,3,4],[26,1,26,2],[2,1,2,4],[30,1,30,2],[29,1,29,2],[28,1,28,2],[27,1,27,2],[20,1,20,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[25,1,25,2],[24,1,24,2],[23,1,23,2],[4,2,4,4]]}
[null,"\n",null,null,"Exhibit 4"]
[null,null,null,null,"KEY PROJECT PERSONNEL",null,null,null,null,null,null,null,null,"Project Manager"]
[null,"This Exhibit is for Single Prime Consultants and Team Leads only",null,null,null,null,null,null,null,null,null,null,null,"Project Engineer"]
[null,"Contract Number / Description:",{"$f":"IF(Info!C4=\"\",\"\",Info!C4)","v":""},null,null,null,null,null,null,null,null,null,null,"Resident Engineer"]
[null,"Prime/Team Name:",{"$f":"IF(Info!C5=\"\",\"\",Info!C5)","v":""},null,null,null,null,null,null,null,null,null,null,"Architect"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Structural Design"]
[null,"Title*",null,"Name","Firm",null,null,null,null,null,null,null,null,"Electrical Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mechanical Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Materials Coordinator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Materials QA Technician"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Document Technician"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule Reviewer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"QC/QA Review Multiple Disciplines"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"QC/QA Review Structural Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"QC/QA Review Roadway Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"QC/QA Review Electrical Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"QC/QA Review Architectural Only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Engineer"]

{"sheet":"Ex. 5-Project Team Summary","index":32,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":true,"merged":[[39,5,39,8],[40,5,40,8],[41,5,41,8],[42,5,42,8],[28,2,28,4],[34,2,34,4],[35,2,35,4],[17,2,17,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[2,1,2,12],[7,1,7,4],[8,2,8,4],[9,2,9,4],[11,2,11,4],[3,1,3,3],[3,4,3,12],[4,4,4,12],[10,2,10,4],[12,2,12,4],[29,2,29,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4]]}
[null,"\n",null,null,null,null,null,null,null,null,null,null,"Exhibit 5",null,null,null,null,null,null,null,null,null,null,null,"Select one"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PROJECT SUMMARY",null,null,null,null,null,null,null,"CM Services",null,null,null,"Prime"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DSE Services",null,null,null,"Team Lead"]
[null,"Contract Number / Description:",null,null,{"$f":"IF(Info!C4=\"\",\"\",Info!C4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Management"]
[null,"Prime/Team Name:",null,null,{"$f":"IF(Info!C5=\"\",\"\",Info!C5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Freeways"]
[]
[null,"Consultants",null,null,null,"DBE/Vet Designation","Role of Consultant","Total Hrs","Avg. Hrly Rate","Direct Labor","Direct Costs","ULC","% Commitment",null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Lead",{"$f":"IF(Info!B20=\"\",\"\",Info!B20)","v":""},null,null,{"$f":"IF('Ex. 2-Team Lead'!$I$9=\"\",\"\",'Ex. 2-Team Lead'!$I$9)","v":""},{"$f":"IF('Ex. 2-Team Lead'!$I$10=\"\",\"\",'Ex. 2-Team Lead'!$I$10)","v":""},{"$f":"'Ex. 2-Team Lead'!$D$31","v":0},{"$f":"'Ex. 2-Team Lead'!$I$19","v":0},{"$f":"'Ex. 2-Team Lead'!I13","v":0},{"$f":"'Ex. 2-Team Lead'!I14","v":0},{"$f":"'Ex. 2-Team Lead'!$I$16","v":0},{"$f":"IFERROR($L9/($L$39-$L$38),\"\")","v":""},null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,"Partner 1",{"$f":"IF(Info!B21=\"\",\"\",Info!B21)","v":""},null,null,{"$f":"IF('Ex. 2-Team Partner 1'!$I$9=\"\",\"\",'Ex. 2-Team Partner 1'!$I$9)","v":""},{"$f":"IF('Ex. 2-Team Partner 1'!$I$10=\"\",\"\",'Ex. 2-Team Partner 1'!$I$10)","v":""},{"$f":"'Ex. 2-Team Partner 1'!$D$31","v":0},{"$f":"'Ex. 2-Team Partner 1'!$I$19","v":0},{"$f":"'Ex. 2-Team Partner 1'!I13","v":0},{"$f":"'Ex. 2-Team Partner 1'!I14","v":0},{"$f":"'Ex. 2-Team Partner 1'!$I$16","v":0},"",null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,{"$f":"IF(Info!B22=\"\",\"\",\"Partner 2\")","v":""},{"$f":"IF(Info!B22=\"\",\"\",Info!B22)","v":""},null,null,{"$f":"IF('Ex. 2-Team Partner 2'!$I$9=\"\",\"\",'Ex. 2-Team Partner 2'!$I$9)","v":""},{"$f":"IF('Ex. 2-Team Partner 2'!$I$10=\"\",\"\",'Ex. 2-Team Partner 2'!$I$10)","v":""},{"$f":"IF('Ex. 2-Team Partner 2'!$D$31=0,\"\",'Ex. 2-Team Partner 2'!$D$31)","v":""},{"$f":"IF('Ex. 2-Team Partner 2'!$I$19=0,\"\",'Ex. 2-Team Partner 2'!$I$19)","v":""},{"$f":"IF('Ex. 2-Team Partner 2'!I14=\"\",\"\",'Ex. 2-Team Partner 2'!I14)","v":""},{"$f":"IF('Ex. 2-Team Partner 2'!I15=\"\",\"\",'Ex. 2-Team Partner 2'!I15)","v":""},{"$f":"IF('Ex. 2-Team Partner 2'!$I$16=0,\"\",'Ex. 2-Team Partner 2'!$I$16)","v":""},"",null,null,null,null,null,null,null,"Structures, Roadway, and Electrical-QC/QA"]
[null,"Team Total",{"$f":"E5","v":""},null,null,"-","-",{"$f":"SUM(H9:H11)","v":0},"-",{"$f":"SUM(J9:J11)","v":0},{"$f":"SUM(K9:K11)","v":0},{"$f":"SUM(L9:L11)","v":0},"",null,null,null,null,null,null,null,"Structural Design"]
[null,1,{"$f":"IF(Info!B24=\"\",\"\",Info!B24)","v":""},null,null,{"$f":"IF('Ex. 2-S1'!$I$9=\"\",\"\",'Ex. 2-S1'!$I$9)","v":""},{"$f":"IF('Ex. 2-S1'!$I$10=\"\",\"\",'Ex. 2-S1'!$I$10)","v":""},{"$f":"'Ex. 2-S1'!$D$31","v":0},{"$f":"'Ex. 2-S1'!$I$19","v":0},{"$f":"'Ex. 2-S1'!$I$13","v":0},{"$f":"'Ex. 2-S1'!$I$14","v":0},{"$f":"'Ex. 2-S1'!$I$16","v":0},""]
[null,2,{"$f":"IF(Info!B25=\"\",\"\",Info!B25)","v":""},null,null,{"$f":"IF('Ex. 2-S2'!$I$9=\"\",\"\",'Ex. 2-S2'!$I$9)","v":""},{"$f":"IF('Ex. 2-S2'!$I$10=\"\",\"\",'Ex. 2-S2'!$I$10)","v":""},{"$f":"'Ex. 2-S2'!$D$31","v":0},{"$f":"'Ex. 2-S2'!$I$19","v":0},{"$f":"'Ex. 2-S2'!$I$13","v":0},{"$f":"'Ex. 2-S2'!$I$14","v":0},{"$f":"'Ex. 2-S2'!$I$16","v":0},""]
[null,3,{"$f":"IF(Info!B26=\"\",\"\",Info!B26)","v":""},null,null,{"$f":"IF('Ex. 2-S3'!$I$9=\"\",\"\",'Ex. 2-S3'!$I$9)","v":""},{"$f":"IF('Ex. 2-S3'!$I$10=\"\",\"\",'Ex. 2-S3'!$I$10)","v":""},{"$f":"'Ex. 2-S3'!$D$31","v":0},{"$f":"'Ex. 2-S3'!$I$19","v":0},{"$f":"'Ex. 2-S3'!$I$13","v":0},{"$f":"'Ex. 2-S3'!$I$14","v":0},{"$f":"'Ex. 2-S3'!$I$16","v":0},""]
[null,4,{"$f":"IF(Info!B27=\"\",\"\",Info!B27)","v":""},null,null,{"$f":"IF('Ex. 2-S4'!$I$9=\"\",\"\",'Ex. 2-S4'!$I$9)","v":""},{"$f":"IF('Ex. 2-S4'!$I$10=\"\",\"\",'Ex. 2-S4'!$I$10)","v":""},{"$f":"'Ex. 2-S4'!$D$31","v":0},{"$f":"'Ex. 2-S4'!$I$19","v":0},{"$f":"'Ex. 2-S4'!$I$13","v":0},{"$f":"'Ex. 2-S4'!$I$14","v":0},{"$f":"'Ex. 2-S4'!$I$16","v":0},""]
[null,5,{"$f":"IF(Info!B28=\"\",\"\",Info!B28)","v":""},null,null,{"$f":"IF('Ex. 2-S5'!$I$9=\"\",\"\",'Ex. 2-S5'!$I$9)","v":""},{"$f":"IF('Ex. 2-S5'!$I$10=\"\",\"\",'Ex. 2-S5'!$I$10)","v":""},{"$f":"'Ex. 2-S5'!$D$31","v":0},{"$f":"'Ex. 2-S5'!$I$19","v":0},{"$f":"'Ex. 2-S5'!$I$13","v":0},{"$f":"'Ex. 2-S5'!$I$14","v":0},{"$f":"'Ex. 2-S5'!$I$16","v":0},""]
[null,6,{"$f":"IF(Info!B29=\"\",\"\",Info!B29)","v":""},null,null,{"$f":"IF('Ex. 2-S6'!$I$9=\"\",\"\",'Ex. 2-S6'!$I$9)","v":""},{"$f":"IF('Ex. 2-S6'!$I$10=\"\",\"\",'Ex. 2-S6'!$I$10)","v":""},{"$f":"'Ex. 2-S6'!$D$31","v":0},{"$f":"'Ex. 2-S6'!$I$19","v":0},{"$f":"'Ex. 2-S6'!$I$13","v":0},{"$f":"'Ex. 2-S6'!$I$14","v":0},{"$f":"'Ex. 2-S6'!$I$16","v":0},""]
[null,7,{"$f":"IF(Info!B30=\"\",\"\",Info!B30)","v":""},null,null,{"$f":"IF('Ex. 2-S7'!$I$9=\"\",\"\",'Ex. 2-S7'!$I$9)","v":""},{"$f":"IF('Ex. 2-S7'!$I$10=\"\",\"\",'Ex. 2-S7'!$I$10)","v":""},{"$f":"'Ex. 2-S7'!$D$31","v":0},{"$f":"'Ex. 2-S7'!$I$19","v":0},{"$f":"'Ex. 2-S7'!$I$13","v":0},{"$f":"'Ex. 2-S7'!$I$14","v":0},{"$f":"'Ex. 2-S7'!$I$16","v":0},""]
[null,8,{"$f":"IF(Info!B31=\"\",\"\",Info!B31)","v":""},null,null,{"$f":"IF('Ex. 2-S8'!$I$9=\"\",\"\",'Ex. 2-S8'!$I$9)","v":""},{"$f":"IF('Ex. 2-S8'!$I$10=\"\",\"\",'Ex. 2-S8'!$I$10)","v":""},{"$f":"'Ex. 2-S8'!$D$31","v":0},{"$f":"'Ex. 2-S8'!$I$19","v":0},{"$f":"'Ex. 2-S8'!$I$13","v":0},{"$f":"'Ex. 2-S8'!$I$14","v":0},{"$f":"'Ex. 2-S8'!$I$16","v":0},""]
[null,9,{"$f":"IF(Info!B32=\"\",\"\",Info!B32)","v":""},null,null,{"$f":"IF('Ex. 2-S9'!$I$9=\"\",\"\",'Ex. 2-S9'!$I$9)","v":""},{"$f":"IF('Ex. 2-S9'!$I$10=\"\",\"\",'Ex. 2-S9'!$I$10)","v":""},{"$f":"'Ex. 2-S9'!$D$31","v":0},{"$f":"'Ex. 2-S9'!$I$19","v":0},{"$f":"'Ex. 2-S9'!$I$13","v":0},{"$f":"'Ex. 2-S9'!$I$14","v":0},{"$f":"'Ex. 2-S9'!$I$16","v":0},""]
[null,10,{"$f":"IF(Info!B33=\"\",\"\",Info!B33)","v":""},null,null,{"$f":"IF('Ex. 2-S10'!$I$9=\"\",\"\",'Ex. 2-S10'!$I$9)","v":""},{"$f":"IF('Ex. 2-S10'!$I$10=\"\",\"\",'Ex. 2-S10'!$I$10)","v":""},{"$f":"'Ex. 2-S10'!$D$31","v":0},{"$f":"'Ex. 2-S10'!$I$19","v":0},{"$f":"'Ex. 2-S10'!$I$13","v":0},{"$f":"'Ex. 2-S10'!$I$14","v":0},{"$f":"'Ex. 2-S10'!$I$16","v":0},""]
[null,11,{"$f":"IF(Info!B34=\"\",\"\",Info!B34)","v":""},null,null,{"$f":"IF('Ex. 2-S11'!$I$9=\"\",\"\",'Ex. 2-S11'!$I$9)","v":""},{"$f":"IF('Ex. 2-S11'!$I$10=\"\",\"\",'Ex. 2-S11'!$I$10)","v":""},{"$f":"'Ex. 2-S11'!$D$31","v":0},{"$f":"'Ex. 2-S11'!$I$19","v":0},{"$f":"'Ex. 2-S11'!$I$13","v":0},{"$f":"'Ex. 2-S11'!$I$14","v":0},{"$f":"'Ex. 2-S11'!$I$16","v":0},""]
[null,12,{"$f":"IF(Info!B35=\"\",\"\",Info!B35)","v":""},null,null,{"$f":"IF('Ex. 2-S12'!$I$9=\"\",\"\",'Ex. 2-S12'!$I$9)","v":""},{"$f":"IF('Ex. 2-S12'!$I$10=\"\",\"\",'Ex. 2-S12'!$I$10)","v":""},{"$f":"'Ex. 2-S12'!$D$31","v":0},{"$f":"'Ex. 2-S12'!$I$19","v":0},{"$f":"'Ex. 2-S12'!$I$13","v":0},{"$f":"'Ex. 2-S12'!$I$14","v":0},{"$f":"'Ex. 2-S12'!$I$16","v":0},""]
[null,13,{"$f":"IF(Info!B36=\"\",\"\",Info!B36)","v":""},null,null,{"$f":"IF('Ex. 2-S13'!$I$9=\"\",\"\",'Ex. 2-S13'!$I$9)","v":""},{"$f":"IF('Ex. 2-S13'!$I$10=\"\",\"\",'Ex. 2-S13'!$I$10)","v":""},{"$f":"'Ex. 2-S13'!$D$31","v":0},{"$f":"'Ex. 2-S13'!$I$19","v":0},{"$f":"'Ex. 2-S13'!$I$13","v":0},{"$f":"'Ex. 2-S13'!$I$14","v":0},{"$f":"'Ex. 2-S13'!$I$16","v":0},""]
[null,14,{"$f":"IF(Info!B37=\"\",\"\",Info!B37)","v":""},null,null,{"$f":"IF('Ex. 2-S14'!$I$9=\"\",\"\",'Ex. 2-S14'!$I$9)","v":""},{"$f":"IF('Ex. 2-S14'!$I$10=\"\",\"\",'Ex. 2-S14'!$I$10)","v":""},{"$f":"'Ex. 2-S14'!$D$31","v":0},{"$f":"'Ex. 2-S14'!$I$19","v":0},{"$f":"'Ex. 2-S14'!$I$13","v":0},{"$f":"'Ex. 2-S14'!$I$14","v":0},{"$f":"'Ex. 2-S14'!$I$16","v":0},""]
[null,15,{"$f":"IF(Info!B38=\"\",\"\",Info!B38)","v":""},null,null,{"$f":"IF('Ex. 2-S15'!$I$9=\"\",\"\",'Ex. 2-S15'!$I$9)","v":""},{"$f":"IF('Ex. 2-S15'!$I$10=\"\",\"\",'Ex. 2-S15'!$I$10)","v":""},{"$f":"'Ex. 2-S15'!$D$31","v":0},{"$f":"'Ex. 2-S15'!$I$19","v":0},{"$f":"'Ex. 2-S15'!$I$13","v":0},{"$f":"'Ex. 2-S15'!$I$14","v":0},{"$f":"'Ex. 2-S15'!$I$16","v":0},""]
[null,16,{"$f":"IF(Info!B39=\"\",\"\",Info!B39)","v":""},null,null,{"$f":"IF('Ex. 2-S16'!$I$9=\"\",\"\",'Ex. 2-S16'!$I$9)","v":""},{"$f":"IF('Ex. 2-S16'!$I$10=\"\",\"\",'Ex. 2-S16'!$I$10)","v":""},{"$f":"'Ex. 2-S16'!$D$31","v":0},{"$f":"'Ex. 2-S16'!$I$19","v":0},{"$f":"'Ex. 2-S16'!$I$13","v":0},{"$f":"'Ex. 2-S16'!$I$14","v":0},{"$f":"'Ex. 2-S16'!$I$16","v":0},""]
[null,17,{"$f":"IF(Info!B40=\"\",\"\",Info!B40)","v":""},null,null,{"$f":"IF('Ex. 2-S17'!$I$9=\"\",\"\",'Ex. 2-S17'!$I$9)","v":""},{"$f":"IF('Ex. 2-S17'!$I$10=\"\",\"\",'Ex. 2-S17'!$I$10)","v":""},{"$f":"'Ex. 2-S17'!$D$31","v":0},{"$f":"'Ex. 2-S17'!$I$19","v":0},{"$f":"'Ex. 2-S17'!$I$13","v":0},{"$f":"'Ex. 2-S17'!$I$14","v":0},{"$f":"'Ex. 2-S17'!$I$16","v":0},""]
[null,18,{"$f":"IF(Info!B41=\"\",\"\",Info!B41)","v":""},null,null,{"$f":"IF('Ex. 2-S18'!$I$9=\"\",\"\",'Ex. 2-S18'!$I$9)","v":""},{"$f":"IF('Ex. 2-S18'!$I$10=\"\",\"\",'Ex. 2-S18'!$I$10)","v":""},{"$f":"'Ex. 2-S18'!$D$31","v":0},{"$f":"'Ex. 2-S18'!$I$19","v":0},{"$f":"'Ex. 2-S18'!$I$13","v":0},{"$f":"'Ex. 2-S18'!$I$14","v":0},{"$f":"'Ex. 2-S18'!$I$16","v":0},""]
[null,19,{"$f":"IF(Info!B42=\"\",\"\",Info!B42)","v":""},null,null,{"$f":"IF('Ex. 2-S19'!$I$9=\"\",\"\",'Ex. 2-S19'!$I$9)","v":""},{"$f":"IF('Ex. 2-S19'!$I$10=\"\",\"\",'Ex. 2-S19'!$I$10)","v":""},{"$f":"'Ex. 2-S19'!$D$31","v":0},{"$f":"'Ex. 2-S19'!$I$19","v":0},{"$f":"'Ex. 2-S19'!$I$13","v":0},{"$f":"'Ex. 2-S19'!$I$14","v":0},{"$f":"'Ex. 2-S19'!$I$16","v":0},""]
[null,20,{"$f":"IF(Info!B43=\"\",\"\",Info!B43)","v":""},null,null,{"$f":"IF('Ex. 2-S20'!$I$9=\"\",\"\",'Ex. 2-S20'!$I$9)","v":""},{"$f":"IF('Ex. 2-S20'!$I$10=\"\",\"\",'Ex. 2-S20'!$I$10)","v":""},{"$f":"'Ex. 2-S20'!$D$31","v":0},{"$f":"'Ex. 2-S20'!$I$19","v":0},{"$f":"'Ex. 2-S20'!$I$13","v":0},{"$f":"'Ex. 2-S20'!$I$14","v":0},{"$f":"'Ex. 2-S20'!$I$16","v":0},""]
[null,21,{"$f":"IF(Info!B44=\"\",\"\",Info!B44)","v":""},null,null,{"$f":"IF('Ex. 2-S21'!$I$9=\"\",\"\",'Ex. 2-S21'!$I$9)","v":""},{"$f":"IF('Ex. 2-S21'!$I$10=\"\",\"\",'Ex. 2-S21'!$I$10)","v":""},{"$f":"'Ex. 2-S21'!$D$31","v":0},{"$f":"'Ex. 2-S21'!$I$19","v":0},{"$f":"'Ex. 2-S21'!$I$13","v":0},{"$f":"'Ex. 2-S21'!$I$14","v":0},{"$f":"'Ex. 2-S21'!$I$16","v":0},""]
[null,22,{"$f":"IF(Info!B45=\"\",\"\",Info!B45)","v":""},null,null,{"$f":"IF('Ex. 2-S22'!$I$9=\"\",\"\",'Ex. 2-S22'!$I$9)","v":""},{"$f":"IF('Ex. 2-S22'!$I$10=\"\",\"\",'Ex. 2-S22'!$I$10)","v":""},{"$f":"'Ex. 2-S22'!$D$31","v":0},{"$f":"'Ex. 2-S22'!$I$19","v":0},{"$f":"'Ex. 2-S22'!$I$13","v":0},{"$f":"'Ex. 2-S22'!$I$14","v":0},{"$f":"'Ex. 2-S22'!$I$16","v":0},""]
[null,23,{"$f":"IF(Info!B46=\"\",\"\",Info!B46)","v":""},null,null,{"$f":"IF('Ex. 2-S23'!$I$9=\"\",\"\",'Ex. 2-S23'!$I$9)","v":""},{"$f":"IF('Ex. 2-S23'!$I$10=\"\",\"\",'Ex. 2-S23'!$I$10)","v":""},{"$f":"'Ex. 2-S23'!$D$31","v":0},{"$f":"'Ex. 2-S23'!$I$19","v":0},{"$f":"'Ex. 2-S23'!$I$13","v":0},{"$f":"'Ex. 2-S23'!$I$14","v":0},{"$f":"'Ex. 2-S23'!$I$16","v":0},""]
[null,24,{"$f":"IF(Info!B47=\"\",\"\",Info!B47)","v":""},null,null,{"$f":"IF('Ex. 2-S24'!$I$9=\"\",\"\",'Ex. 2-S24'!$I$9)","v":""},{"$f":"IF('Ex. 2-S24'!$I$10=\"\",\"\",'Ex. 2-S24'!$I$10)","v":""},{"$f":"'Ex. 2-S24'!$D$31","v":0},{"$f":"'Ex. 2-S24'!$I$19","v":0},{"$f":"'Ex. 2-S24'!$I$13","v":0},{"$f":"'Ex. 2-S24'!$I$14","v":0},{"$f":"'Ex. 2-S24'!$I$16","v":0},""]
[null,"Subconsultant Totals",null,null,null,"-","-",{"$f":"SUM(H13:H36)","v":0},"-",{"$f":"SUM(J13:J36)","v":0},{"$f":"SUM(K13:K36)","v":0},{"$f":"SUM(L13:L36)","v":0},{"$f":"SUM(M13:M36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"CONTINGENCY",{"$f":"'Ex. 2-Team Lead'!I17","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(Info!C8=\"Supplement\",\"SUPPLEMENT INCREASE TO CONTRACT UPPER LIMIT OF COMPENSATION\",Info!C8=\"Original\",\"CONTRACT UPPER LIMIT OF COMPENSATION\",Info!C8=\"\",\"CONTRACT UPPER LIMIT OF COMPENSATION\")","v":"CONTRACT UPPER LIMIT OF COMPENSATION"},{"$f":"SUM(L9:L11,L13:L36,L38)","v":0}]
[null,"Proposal Date",null,null,null,null,null,null,null,null,"D/M/WBE",{"$f":"SUMIF($F$9:$F$33,\"D/M/WBE\",$L$9:$L$33)","v":0},{"$f":"IFERROR($L40/SUM(L40:L42),\"\")","v":""}]
[null,"Board Date",null,null,null,null,null,null,null,null,"VOSB",{"$f":"SUMIF($F$9:$F$33,\"VOSB\",$L$9:$L$33)","v":0},{"$f":"IFERROR($L41/SUM(L40:L42),\"\")","v":""}]
[null,{"$f":"_xlfn.IFS(Info!C8=\"Original\",\"Est. NTP Date\",Info!C8=\"Supplement\",\"Suppl. Est. NTP Date\",Info!C8=\"\",\"Est. NTP Date\")","v":"Est. NTP Date"},null,null,{"$f":"IF(E41=\"\",\"\",EOMONTH(E41,2)+1)","v":""},null,null,null,null,null,"Non-D/M/WBE/VOSB",{"$f":"SUMIF($F$9:$F$33,\"No Designation\",$L$9:$L$33)","v":0},{"$f":"IFERROR($L42/SUM(L40:L42),\"\")","v":""}]
[null,"Duration (months)"]
[null,"Substantial Completion Date",null,null,{"$f":"IFERROR(EOMONTH(EDATE(E42,E43-1),0),\"\")","v":""}]
[null,"Contract Expiration Date",null,null,{"$f":"IF(AND(E43>=60,OR(Info!C10=\"DSE\",Info!C10=\"Design Corridor Manager\")),DATE(YEAR(E41)+10,MONTH(E41),DAY(E41)-1),IFERROR(IF(Info!C10=\"\",\"Select 'Contract Type' on Info tab\",IF(Info!C10=\"DSE\",EDATE(E44,60),IF(Info!C10=\"Design Corridor Manager\",EDATE(E44,60),IF(Info!C20=\"DSE Upon Request\",EDATE(E44,24),IF(Info!C10=\"CM\",EDATE(E44,24),IF(Info!C10=\"CM Upon Request\",EDATE(E44,24),IF(Info!C10=\"Construction Corridor Manager\",EDATE(E44,24),IF(Info!C10=\"Geotechnical Svcs Upon Req\",EDATE(E44,24),IF(Info!C10=\"Program Management\",EDATE(E44,24),IF(Info!C10=\"Surveying & Land Acquisition Svcs\",EDATE(E44,60),IF(Info!C10=\"Utilities Upon Request\",EDATE(E44,24),IF(Info!C10=\"Other - Upon Request\",EDATE(E44,24))))))))))))),\"\"))","v":"Select 'Contract Type' on Info tab"}]

{"sheet":"Ex. 5-Project Summary","index":33,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":true,"merged":[[12,2,12,4],[39,5,39,8],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[36,5,36,8],[37,5,37,8],[38,5,38,8],[2,1,2,12],[3,1,3,3],[3,4,3,12],[4,4,4,12],[7,1,7,4],[8,2,8,4],[24,2,24,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[9,2,9,4],[10,2,10,4],[11,2,11,4]]}
[null,"\n",null,null,null,null,null,null,null,null,null,null,"Exhibit 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PROJECT SUMMARY",null,null,null,null,null,null,null,"CM Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DSE Services"]
[null,"Contract Number / Description:",null,null,{"$f":"IF(Info!C4=\"\",\"\",Info!C4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Management"]
[null,"Prime/Team Name:",null,null,{"$f":"IF(Info!C5=\"\",\"\",Info!C5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Freeways"]
[]
[null,"Consultants",null,null,null,"DBE/Vet Designation","Role of Consultant","Total Hrs","Avg. Hrly Rate","Direct Labor","Direct Costs","ULC","% Commitment",null,null,null,null,null,null,null,"Survey and Civil Support"]
[null,"Prime",{"$f":"IF(Info!B20=\"\",\"\",Info!B20)","v":""},null,null,{"$f":"IF('Ex. 2-PM'!$I$9=\"\",\"\",'Ex. 2-PM'!$I$9)","v":""},{"$f":"IF('Ex. 2-PM'!$I$10=\"\",\"\",'Ex. 2-PM'!$I$10)","v":""},{"$f":"'Ex. 2-PM'!$D$31","v":0},{"$f":"'Ex. 2-PM'!$I$19","v":0},{"$f":"'Ex. 2-PM'!I13","v":0},{"$f":"'Ex. 2-PM'!I14","v":0},{"$f":"J9+K9","v":0},{"$f":"IFERROR($L9/($L$36-$L$35),\"\")","v":""},null,null,null,null,null,null,null,"ITS, Electrical Lighting"]
[null,1,{"$f":"IF(Info!B24=\"\",\"\",Info!B24)","v":""},null,null,{"$f":"IF('Ex. 2-S1'!$I$9=\"\",\"\",'Ex. 2-S1'!$I$9)","v":""},{"$f":"IF('Ex. 2-S1'!$I$10=\"\",\"\",'Ex. 2-S1'!$I$10)","v":""},{"$f":"'Ex. 2-S1'!$D$31","v":0},{"$f":"'Ex. 2-S1'!$I$19","v":0},{"$f":"'Ex. 2-S1'!$I$13","v":0},{"$f":"'Ex. 2-S1'!$I$14","v":0},{"$f":"'Ex. 2-S1'!$I$16","v":0},""]
[null,2,{"$f":"IF(Info!B25=\"\",\"\",Info!B25)","v":""},null,null,{"$f":"IF('Ex. 2-S2'!$I$9=\"\",\"\",'Ex. 2-S2'!$I$9)","v":""},{"$f":"IF('Ex. 2-S2'!$I$10=\"\",\"\",'Ex. 2-S2'!$I$10)","v":""},{"$f":"'Ex. 2-S2'!$D$31","v":0},{"$f":"'Ex. 2-S2'!$I$19","v":0},{"$f":"'Ex. 2-S2'!$I$13","v":0},{"$f":"'Ex. 2-S2'!$I$14","v":0},{"$f":"'Ex. 2-S2'!$I$16","v":0},""]
[null,3,{"$f":"IF(Info!B26=\"\",\"\",Info!B26)","v":""},null,null,{"$f":"IF('Ex. 2-S3'!$I$9=\"\",\"\",'Ex. 2-S3'!$I$9)","v":""},{"$f":"IF('Ex. 2-S3'!$I$10=\"\",\"\",'Ex. 2-S3'!$I$10)","v":""},{"$f":"'Ex. 2-S3'!$D$31","v":0},{"$f":"'Ex. 2-S3'!$I$19","v":0},{"$f":"'Ex. 2-S3'!$I$13","v":0},{"$f":"'Ex. 2-S3'!$I$14","v":0},{"$f":"'Ex. 2-S3'!$I$16","v":0},""]
[null,4,{"$f":"IF(Info!B27=\"\",\"\",Info!B27)","v":""},null,null,{"$f":"IF('Ex. 2-S4'!$I$9=\"\",\"\",'Ex. 2-S4'!$I$9)","v":""},{"$f":"IF('Ex. 2-S4'!$I$10=\"\",\"\",'Ex. 2-S4'!$I$10)","v":""},{"$f":"'Ex. 2-S4'!$D$31","v":0},{"$f":"'Ex. 2-S4'!$I$19","v":0},{"$f":"'Ex. 2-S4'!$I$13","v":0},{"$f":"'Ex. 2-S4'!$I$14","v":0},{"$f":"'Ex. 2-S4'!$I$16","v":0},""]
[null,5,{"$f":"IF(Info!B28=\"\",\"\",Info!B28)","v":""},null,null,{"$f":"IF('Ex. 2-S5'!$I$9=\"\",\"\",'Ex. 2-S5'!$I$9)","v":""},{"$f":"IF('Ex. 2-S5'!$I$10=\"\",\"\",'Ex. 2-S5'!$I$10)","v":""},{"$f":"'Ex. 2-S5'!$D$31","v":0},{"$f":"'Ex. 2-S5'!$I$19","v":0},{"$f":"'Ex. 2-S5'!$I$13","v":0},{"$f":"'Ex. 2-S5'!$I$14","v":0},{"$f":"'Ex. 2-S5'!$I$16","v":0},""]
[null,6,{"$f":"IF(Info!B29=\"\",\"\",Info!B29)","v":""},null,null,{"$f":"IF('Ex. 2-S6'!$I$9=\"\",\"\",'Ex. 2-S6'!$I$9)","v":""},{"$f":"IF('Ex. 2-S6'!$I$10=\"\",\"\",'Ex. 2-S6'!$I$10)","v":""},{"$f":"'Ex. 2-S6'!$D$31","v":0},{"$f":"'Ex. 2-S6'!$I$19","v":0},{"$f":"'Ex. 2-S6'!$I$13","v":0},{"$f":"'Ex. 2-S6'!$I$14","v":0},{"$f":"'Ex. 2-S6'!$I$16","v":0},""]
[null,7,{"$f":"IF(Info!B30=\"\",\"\",Info!B30)","v":""},null,null,{"$f":"IF('Ex. 2-S7'!$I$9=\"\",\"\",'Ex. 2-S7'!$I$9)","v":""},{"$f":"IF('Ex. 2-S7'!$I$10=\"\",\"\",'Ex. 2-S7'!$I$10)","v":""},{"$f":"'Ex. 2-S7'!$D$31","v":0},{"$f":"'Ex. 2-S7'!$I$19","v":0},{"$f":"'Ex. 2-S7'!$I$13","v":0},{"$f":"'Ex. 2-S7'!$I$14","v":0},{"$f":"'Ex. 2-S7'!$I$16","v":0},""]
[null,8,{"$f":"IF(Info!B31=\"\",\"\",Info!B31)","v":""},null,null,{"$f":"IF('Ex. 2-S8'!$I$9=\"\",\"\",'Ex. 2-S8'!$I$9)","v":""},{"$f":"IF('Ex. 2-S8'!$I$10=\"\",\"\",'Ex. 2-S8'!$I$10)","v":""},{"$f":"'Ex. 2-S8'!$D$31","v":0},{"$f":"'Ex. 2-S8'!$I$19","v":0},{"$f":"'Ex. 2-S8'!$I$13","v":0},{"$f":"'Ex. 2-S8'!$I$14","v":0},{"$f":"'Ex. 2-S8'!$I$16","v":0},""]
[null,9,{"$f":"IF(Info!B32=\"\",\"\",Info!B32)","v":""},null,null,{"$f":"IF('Ex. 2-S9'!$I$9=\"\",\"\",'Ex. 2-S9'!$I$9)","v":""},{"$f":"IF('Ex. 2-S9'!$I$10=\"\",\"\",'Ex. 2-S9'!$I$10)","v":""},{"$f":"'Ex. 2-S9'!$D$31","v":0},{"$f":"'Ex. 2-S9'!$I$19","v":0},{"$f":"'Ex. 2-S9'!$I$13","v":0},{"$f":"'Ex. 2-S9'!$I$14","v":0},{"$f":"'Ex. 2-S9'!$I$16","v":0},""]
[null,10,{"$f":"IF(Info!B33=\"\",\"\",Info!B33)","v":""},null,null,{"$f":"IF('Ex. 2-S10'!$I$9=\"\",\"\",'Ex. 2-S10'!$I$9)","v":""},{"$f":"IF('Ex. 2-S10'!$I$10=\"\",\"\",'Ex. 2-S10'!$I$10)","v":""},{"$f":"'Ex. 2-S10'!$D$31","v":0},{"$f":"'Ex. 2-S10'!$I$19","v":0},{"$f":"'Ex. 2-S10'!$I$13","v":0},{"$f":"'Ex. 2-S10'!$I$14","v":0},{"$f":"'Ex. 2-S10'!$I$16","v":0},""]
[null,11,{"$f":"IF(Info!B34=\"\",\"\",Info!B34)","v":""},null,null,{"$f":"IF('Ex. 2-S11'!$I$9=\"\",\"\",'Ex. 2-S11'!$I$9)","v":""},{"$f":"IF('Ex. 2-S11'!$I$10=\"\",\"\",'Ex. 2-S11'!$I$10)","v":""},{"$f":"'Ex. 2-S11'!$D$31","v":0},{"$f":"'Ex. 2-S11'!$I$19","v":0},{"$f":"'Ex. 2-S11'!$I$13","v":0},{"$f":"'Ex. 2-S11'!$I$14","v":0},{"$f":"'Ex. 2-S11'!$I$16","v":0},""]
[null,12,{"$f":"IF(Info!B35=\"\",\"\",Info!B35)","v":""},null,null,{"$f":"IF('Ex. 2-S12'!$I$9=\"\",\"\",'Ex. 2-S12'!$I$9)","v":""},{"$f":"IF('Ex. 2-S12'!$I$10=\"\",\"\",'Ex. 2-S12'!$I$10)","v":""},{"$f":"'Ex. 2-S12'!$D$31","v":0},{"$f":"'Ex. 2-S12'!$I$19","v":0},{"$f":"'Ex. 2-S12'!$I$13","v":0},{"$f":"'Ex. 2-S12'!$I$14","v":0},{"$f":"'Ex. 2-S12'!$I$16","v":0},""]
[null,13,{"$f":"IF(Info!B36=\"\",\"\",Info!B36)","v":""},null,null,{"$f":"IF('Ex. 2-S13'!$I$9=\"\",\"\",'Ex. 2-S13'!$I$9)","v":""},{"$f":"IF('Ex. 2-S13'!$I$10=\"\",\"\",'Ex. 2-S13'!$I$10)","v":""},{"$f":"'Ex. 2-S13'!$D$31","v":0},{"$f":"'Ex. 2-S13'!$I$19","v":0},{"$f":"'Ex. 2-S13'!$I$13","v":0},{"$f":"'Ex. 2-S13'!$I$14","v":0},{"$f":"'Ex. 2-S13'!$I$16","v":0},""]
[null,14,{"$f":"IF(Info!B37=\"\",\"\",Info!B37)","v":""},null,null,{"$f":"IF('Ex. 2-S14'!$I$9=\"\",\"\",'Ex. 2-S14'!$I$9)","v":""},{"$f":"IF('Ex. 2-S14'!$I$10=\"\",\"\",'Ex. 2-S14'!$I$10)","v":""},{"$f":"'Ex. 2-S14'!$D$31","v":0},{"$f":"'Ex. 2-S14'!$I$19","v":0},{"$f":"'Ex. 2-S14'!$I$13","v":0},{"$f":"'Ex. 2-S14'!$I$14","v":0},{"$f":"'Ex. 2-S14'!$I$16","v":0},""]
[null,15,{"$f":"IF(Info!B38=\"\",\"\",Info!B38)","v":""},null,null,{"$f":"IF('Ex. 2-S15'!$I$9=\"\",\"\",'Ex. 2-S15'!$I$9)","v":""},{"$f":"IF('Ex. 2-S15'!$I$10=\"\",\"\",'Ex. 2-S15'!$I$10)","v":""},{"$f":"'Ex. 2-S15'!$D$31","v":0},{"$f":"'Ex. 2-S15'!$I$19","v":0},{"$f":"'Ex. 2-S15'!$I$13","v":0},{"$f":"'Ex. 2-S15'!$I$14","v":0},{"$f":"'Ex. 2-S15'!$I$16","v":0},""]
[null,16,{"$f":"IF(Info!B39=\"\",\"\",Info!B39)","v":""},null,null,{"$f":"IF('Ex. 2-S16'!$I$9=\"\",\"\",'Ex. 2-S16'!$I$9)","v":""},{"$f":"IF('Ex. 2-S16'!$I$10=\"\",\"\",'Ex. 2-S16'!$I$10)","v":""},{"$f":"'Ex. 2-S16'!$D$31","v":0},{"$f":"'Ex. 2-S16'!$I$19","v":0},{"$f":"'Ex. 2-S16'!$I$13","v":0},{"$f":"'Ex. 2-S16'!$I$14","v":0},{"$f":"'Ex. 2-S16'!$I$16","v":0},""]
[null,17,{"$f":"IF(Info!B40=\"\",\"\",Info!B40)","v":""},null,null,{"$f":"IF('Ex. 2-S17'!$I$9=\"\",\"\",'Ex. 2-S17'!$I$9)","v":""},{"$f":"IF('Ex. 2-S17'!$I$10=\"\",\"\",'Ex. 2-S17'!$I$10)","v":""},{"$f":"'Ex. 2-S17'!$D$31","v":0},{"$f":"'Ex. 2-S17'!$I$19","v":0},{"$f":"'Ex. 2-S17'!$I$13","v":0},{"$f":"'Ex. 2-S17'!$I$14","v":0},{"$f":"'Ex. 2-S17'!$I$16","v":0},""]
[null,18,{"$f":"IF(Info!B41=\"\",\"\",Info!B41)","v":""},null,null,{"$f":"IF('Ex. 2-S18'!$I$9=\"\",\"\",'Ex. 2-S18'!$I$9)","v":""},{"$f":"IF('Ex. 2-S18'!$I$10=\"\",\"\",'Ex. 2-S18'!$I$10)","v":""},{"$f":"'Ex. 2-S18'!$D$31","v":0},{"$f":"'Ex. 2-S18'!$I$19","v":0},{"$f":"'Ex. 2-S18'!$I$13","v":0},{"$f":"'Ex. 2-S18'!$I$14","v":0},{"$f":"'Ex. 2-S18'!$I$16","v":0},""]
[null,19,{"$f":"IF(Info!B42=\"\",\"\",Info!B42)","v":""},null,null,{"$f":"IF('Ex. 2-S19'!$I$9=\"\",\"\",'Ex. 2-S19'!$I$9)","v":""},{"$f":"IF('Ex. 2-S19'!$I$10=\"\",\"\",'Ex. 2-S19'!$I$10)","v":""},{"$f":"'Ex. 2-S19'!$D$31","v":0},{"$f":"'Ex. 2-S19'!$I$19","v":0},{"$f":"'Ex. 2-S19'!$I$13","v":0},{"$f":"'Ex. 2-S19'!$I$14","v":0},{"$f":"'Ex. 2-S19'!$I$16","v":0},""]
[null,20,{"$f":"IF(Info!B43=\"\",\"\",Info!B43)","v":""},null,null,{"$f":"IF('Ex. 2-S20'!$I$9=\"\",\"\",'Ex. 2-S20'!$I$9)","v":""},{"$f":"IF('Ex. 2-S20'!$I$10=\"\",\"\",'Ex. 2-S20'!$I$10)","v":""},{"$f":"'Ex. 2-S20'!$D$31","v":0},{"$f":"'Ex. 2-S20'!$I$19","v":0},{"$f":"'Ex. 2-S20'!$I$13","v":0},{"$f":"'Ex. 2-S20'!$I$14","v":0},{"$f":"'Ex. 2-S20'!$I$16","v":0},""]
[null,21,{"$f":"IF(Info!B44=\"\",\"\",Info!B44)","v":""},null,null,{"$f":"IF('Ex. 2-S21'!$I$9=\"\",\"\",'Ex. 2-S21'!$I$9)","v":""},{"$f":"IF('Ex. 2-S21'!$I$10=\"\",\"\",'Ex. 2-S21'!$I$10)","v":""},{"$f":"'Ex. 2-S21'!$D$31","v":0},{"$f":"'Ex. 2-S21'!$I$19","v":0},{"$f":"'Ex. 2-S21'!$I$13","v":0},{"$f":"'Ex. 2-S21'!$I$14","v":0},{"$f":"'Ex. 2-S21'!$I$16","v":0},""]
[null,22,{"$f":"IF(Info!B45=\"\",\"\",Info!B45)","v":""},null,null,{"$f":"IF('Ex. 2-S22'!$I$9=\"\",\"\",'Ex. 2-S22'!$I$9)","v":""},{"$f":"IF('Ex. 2-S22'!$I$10=\"\",\"\",'Ex. 2-S22'!$I$10)","v":""},{"$f":"'Ex. 2-S22'!$D$31","v":0},{"$f":"'Ex. 2-S22'!$I$19","v":0},{"$f":"'Ex. 2-S22'!$I$13","v":0},{"$f":"'Ex. 2-S22'!$I$14","v":0},{"$f":"'Ex. 2-S22'!$I$16","v":0},""]
[null,23,{"$f":"IF(Info!B46=\"\",\"\",Info!B46)","v":""},null,null,{"$f":"IF('Ex. 2-S23'!$I$9=\"\",\"\",'Ex. 2-S23'!$I$9)","v":""},{"$f":"IF('Ex. 2-S23'!$I$10=\"\",\"\",'Ex. 2-S23'!$I$10)","v":""},{"$f":"'Ex. 2-S23'!$D$31","v":0},{"$f":"'Ex. 2-S23'!$I$19","v":0},{"$f":"'Ex. 2-S23'!$I$13","v":0},{"$f":"'Ex. 2-S23'!$I$14","v":0},{"$f":"'Ex. 2-S23'!$I$16","v":0},""]
[null,24,{"$f":"IF(Info!B47=\"\",\"\",Info!B47)","v":""},null,null,{"$f":"IF('Ex. 2-S24'!$I$9=\"\",\"\",'Ex. 2-S24'!$I$9)","v":""},{"$f":"IF('Ex. 2-S24'!$I$10=\"\",\"\",'Ex. 2-S24'!$I$10)","v":""},{"$f":"'Ex. 2-S24'!$D$31","v":0},{"$f":"'Ex. 2-S24'!$I$19","v":0},{"$f":"'Ex. 2-S24'!$I$13","v":0},{"$f":"'Ex. 2-S24'!$I$14","v":0},{"$f":"'Ex. 2-S24'!$I$16","v":0},{"$f":"IFERROR($L33/($L$36-$L$35),\"\")","v":""}]
[null,"Subconsultant Totals",null,null,null,"-","-",{"$f":"SUM(H10:H33)","v":0},"-",{"$f":"SUM(J10:J33)","v":0},{"$f":"SUM(K10:K33)","v":0},{"$f":"SUM(L10:L33)","v":0},{"$f":"SUM(M10:M33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"CONTINGENCY",{"$f":"'Ex. 2-PM'!I17","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(Info!C8=\"Supplement\",\"SUPPLEMENT INCREASE TO CONTRACT UPPER LIMIT OF COMPENSATION\",Info!C8=\"Original\",\"CONTRACT UPPER LIMIT OF COMPENSATION\",Info!C8=\"\",\"CONTRACT UPPER LIMIT OF COMPENSATION\")","v":"CONTRACT UPPER LIMIT OF COMPENSATION"},{"$f":"SUM(L9:L33,L35)","v":0}]
[null,"Proposal Date",null,null,null,null,null,null,null,null,"D/M/WBE",{"$f":"SUMIF($F$9:$F$33,\"D/M/WBE\",$L$9:$L$33)","v":0},{"$f":"IFERROR($L37/SUM(L37:L39),\"\")","v":""}]
[null,"Board Date",null,null,null,null,null,null,null,null,"VOSB",{"$f":"SUMIF($F$9:$F$33,\"VOSB\",$L$9:$L$33)","v":0},{"$f":"IFERROR($L38/SUM(L37:L39),\"\")","v":""}]
[null,{"$f":"_xlfn.IFS(Info!C8=\"Original\",\"Est. NTP Date\",Info!C8=\"Supplement\",\"Suppl. Est. NTP Date\",Info!C8=\"\",\"Est. NTP Date\")","v":"Est. NTP Date"},null,null,{"$f":"IF(E38=\"\",\"\",EOMONTH(E38,2)+1)","v":""},null,null,null,null,null,"Non-D/M/WBE/VOSB",{"$f":"SUMIF($F$9:$F$33,\"No Designation\",$L$9:$L$33)","v":0},{"$f":"IFERROR($L39/SUM(L37:L39),\"\")","v":""}]
[null,"Duration (months)"]
[null,"Substantial Completion Date",null,null,{"$f":"IFERROR(EOMONTH(EDATE(E39,E40-1),0),\"\")","v":""}]
[null,"Contract Expiration Date",null,null,{"$f":"IF(AND(E40>=60,OR(Info!C10=\"DSE\",Info!C10=\"Design Corridor Manager\")),DATE(YEAR(E38)+10,MONTH(E38),DAY(E38)-1),IFERROR(IF(Info!C10=\"\",\"Select 'Contract Type' on Info tab\",IF(Info!C10=\"DSE\",EDATE(E41,60),IF(Info!C10=\"Design Corridor Manager\",EDATE(E41,60),IF(Info!C10=\"DSE Upon Request\",EDATE(E41,24),IF(Info!C10=\"CM\",EDATE(E41,24),IF(Info!C10=\"CM Upon Request\",EDATE(E41,24),IF(Info!C10=\"Construction Corridor Manager\",EDATE(E41,24),IF(Info!C10=\"Geotechnical Svcs Upon Req\",EDATE(E41,24),IF(Info!C10=\"Program Management\",EDATE(E41,24),IF(Info!C10=\"Surveying & Land Acquisition Svcs\",EDATE(E41,60),IF(Info!C10=\"Utilities Upon Request\",EDATE(E41,24),IF(Info!C10=\"Other - Upon Request\",EDATE(E41,24))))))))))))),\"\"))","v":"Select 'Contract Type' on Info tab"}]

{"sheet":"Ex. 4&5 Alt.","index":34,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,"Exhibit 4"]
[null,null,null,null,null,null,"PROJECT SUMMARY"]
[null,null,"This Exhibit is for Single Prime Consultants and Team Leads only","This Exhibit is for Single Prime Consultants and Team Leads only"]
[null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"Contract No.: Info Sheet tab incomplete\",\"Contract No.: \"&#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"Consultant: Info Sheet tab incomplete\",\"Consultant: \"&#REF!)","v":{"$error":"#REF!"}}]
[]
[null,"Consultant Name","Lead","Partner 2","Partner 3","Subconsultant 1","Subconsultant 2","Subconsultant 3","Subconsultant 4","Subconsultant 5","Subconsultant 6","Subconsultant 7","Subconsultant 8","Subconsultant 9","Subconsultant 10","Subconsultant 11","Subconsultant 12","Subconsultant 13","Subconsultant 14","Subconsultant 15","Subconsultant 16","Subconsultant 17","Subconsultant 18","Subconsultant 19","Subconsultant 20","Subconsultant 21","Subconsultant 22","Subconsultant 23","Subconsultant 24"]
[null,"Consultant Type","Lead Partner","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one"]
[null,"Designation","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one"]
[null,"Role of Consultant","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one","Select one"]
[null,"Total Hours",1000,1]
[null,"Direct Labor",1000000,200000,50000,500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Multiplier",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$C$13","v":{"$error":"#REF!"}},{"$f":"$C$13","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Total Labor",{"$f":"C12*C13","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Direct Costs"]
[null,"Services by Others"]
[null,"Additional Services \n(Prime only)"]
[null,"Consultant (ULC)",{"$f":"SUM(C14:C17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Avg. Hrly Rate",{"$f":"IF(C11<>\"\",C12/C11,\"\")","v":1000},{"$f":"IF(D11<>\"\",D12/D11,\"\")","v":200000},"","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,null,null,null,"CONTRACT ULC","%"]
[null,null,null,"D/M/WBE",{"$f":"SUMIFS($C$18:$AC$18,$C$9:$AC$9,\"D/M/WBE\")","v":0},{"$f":"E22/E25","v":{"$error":"#REF!"}}]
[null,null,null,"VOSB",{"$f":"SUMIFS($C$18:$AC$18,$C$9:$AC$9,\"VOSB\")","v":0},{"$f":"E23/E25","v":{"$error":"#REF!"}}]
[null,null,null,"Non-D/M/WBE/VOSB",{"$f":"SUMIFS($C$18:$AC$18,$C$9:$AC$9,\"Non-D/M/WBE/VOSB\")","v":0},{"$f":"E24/E25","v":{"$error":"#REF!"}}]
[null,null,null,"TOTAL",{"$f":"SUM(C18:AC18)","v":{"$error":"#REF!"}},{"$f":"SUM(F22:F24)","v":{"$error":"#REF!"}}]
[]
["Select one","Select one","Select one","Select one","Select one"]
[2.5,"Project Management","Single Prime","Subconsultant","D/M/WBE"]
[2.8,"Electrical","Lead Partner","Team Partner","VOSB"]
[null,"Freeways",null,null,"Non-D/M/WBE/VOSB"]
[null,"Roadway Design"]
[null,"Survey and Civil Support"]
[null,"ITS, Electrical Lighting"]
[null,"Structures, Roadway, and Electrical-QC/QA"]
[null,"Structural Design"]