{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Cover","Prime Contractor Technicians","SUBCONTRACTOR1 Technicians","SUBCONTRACTOR2 Technicians","SUBCONTRACTOR3 Technicians","PRIME CONTRACTOR Administration","SUBCONTRACTOR1 Administration","SUBCONTRACTOR2 Administration","SUBCONTRACTOR3 Administration","Direct Costs","Mileage"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":5,"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":"Cover","index":0,"n_rows":116,"n_cols":10,"rows_kept":116,"cut":false,"hidden":false,"merged":[[7,1,11,2],[2,0,2,7],[3,0,3,7],[8,4,8,6],[6,4,6,6],[7,4,7,6]]}
[null,null,null,null,null,null,"Version:","2024.01.04.RJS"]
["CEI and ALL TECHNICIANs' SCOPE and ESTIMATE--(WITH SHIFT PREMIUM) No 85%-Rule--STAND-ALONE or ON-CALL"]
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["PROFESSIONAL SERVICES MANAGEMENT UNIT"]
[]
[null,null,null,null,"Construction Engineering and Inspection (CEI)"]
[null,null,null,null,"WBS-XXXXX.X.X"]
[null,"Choose YES or NO to Hide/Unhide Appropriate Estimate Sheets as dictated by Task Order Scope.",null,null,"PROJECT DESCRIPTION"]
[null,null,null,null,"LSC #XXXXXXXXXX"]
[]
[null,null,null,null,"ENGINEERING AND INSPECTION TECHNICIANS"]
[]
[null,null,null,null,null,null,"Regular Direct Labor"]
[]
[null,null,null,"PRIME CONTRACTOR NAME","Prime Contractor Technicians",null,{"$f":"'Prime Contractor Technicians'!G211","v":0},null,"Prime CEI Tech Salary Cost","Prime CEI Tech Fee Cost"]
[null,null,null,{"$f":"D15","v":"PRIME CONTRACTOR NAME"},"Prime Contractor Overhead Audited -- FIELD",null,{"$f":"ROUND((G15)*F16,2)","v":0},null,{"$f":"SUM(G15:G16)","v":0},{"$f":"I16*$F$29","v":0}]
[]
[null,null,null,"SUBCONTRACTOR1 NAME","Subcontractor1 Technicians",null,{"$f":"'SUBCONTRACTOR1 Technicians'!G211","v":0},null,"Sub1 CEI Tech Salary Cost","Sub1 CEI Tech Fee Cost"]
[null,null,null,{"$f":"D18","v":"SUBCONTRACTOR1 NAME"},"Subcontractor1 Overhead Audited -- FIELD",null,{"$f":"ROUND(G18*F19,2)","v":0},null,{"$f":"SUM(G18:G19)","v":0},{"$f":"I19*$F$29","v":0}]
[]
[null,null,null,"SUBCONTRACTOR2 NAME","Subcontractor2 Technicians",null,{"$f":"'SUBCONTRACTOR2 Technicians'!G211","v":0},null,"Sub2 CEI Tech Salary Cost","Sub2 CEI Tech Fee Cost"]
[null,null,null,{"$f":"D21","v":"SUBCONTRACTOR2 NAME"},"Subcontractor2 Overhead Audited -- FIELD",null,{"$f":"ROUND(G21*F22,2)","v":0},null,{"$f":"SUM(G21:G22)","v":0},{"$f":"I22*$F$29","v":0}]
[]
[null,null,null,"SUBCONTRACTOR3 NAME","Subcontractor3 Technicians",null,{"$f":"'SUBCONTRACTOR3 Technicians'!G211","v":0},null,"Sub3 CEI Tech Salary Cost","Sub3 CEI Tech Fee Cost"]
[null,null,null,{"$f":"D24","v":"SUBCONTRACTOR3 NAME"},"Subcontractor3 Overhead Audited -- FIELD",null,{"$f":"ROUND((G24)*F25,2)","v":0},null,{"$f":"SUM(G24:G25)","v":0},{"$f":"I25*$F$29","v":0}]
[]
[null,null,null,null,"Subtotal",null,{"$f":"SUM(G15:G25)","v":0},null,{"$f":"SUM(I15:I25)","v":0},{"$f":"SUM(J15:J25)","v":0}]
[]
[null,null,null,null,"Operating Margin (Fixed Fee Rate) (Usually 9%)",null,{"$f":"ROUND(G27*F29,2)","v":0}]
[]
[null,null,null,null,"Subtotal",null,{"$f":"G27+G29","v":0}]
[]
[null,null,null,{"$f":"D15","v":"PRIME CONTRACTOR NAME"},"TOTAL PREMIUM LABOR - Prime Contractor",null,{"$f":"'Prime Contractor Technicians'!M213","v":0},null,"Prime TOTAL CEI Tech Cost",{"$f":"SUM(I16+J16+G33)","v":0}]
[]
[null,null,null,{"$f":"D18","v":"SUBCONTRACTOR1 NAME"},"TOTAL PREMIUM LABOR - Subcontractor1",null,{"$f":"'SUBCONTRACTOR1 Technicians'!M213","v":0},null,"Sub1 TOTAL CEI Tech Cost",{"$f":"SUM(I19+J19+G35)","v":0}]
[]
[null,null,null,{"$f":"D21","v":"SUBCONTRACTOR2 NAME"},"TOTAL PREMIUM LABOR - Subcontractor2",null,{"$f":"'SUBCONTRACTOR2 Technicians'!M213","v":0},null,"Sub2 TOTAL CEI Tech Cost",{"$f":"SUM(I22+J22+G37)","v":0}]
[]
[null,null,null,{"$f":"D24","v":"SUBCONTRACTOR3 NAME"},"TOTAL PREMIUM LABOR - Subcontractor3",null,{"$f":"'SUBCONTRACTOR3 Technicians'!M213","v":0},null,"Sub3 TOTAL CEI Tech Cost",{"$f":"SUM(I25+J25+G39)","v":0}]
[]
[null,null,null,null,"TOTAL DIRECT SALARY COST CEI TECHNICIANS",null,{"$f":"SUM(G31:G39)","v":0},null,null,{"$f":"SUM(J33:J39)","v":0}]
[]
[]
[null,null,null,null,"PROJECT MANAGEMENT/CONTRACT ADMINISTRATION"]
[]
[null,null,null,null,"Position",null,"Direct Labor"]
[]
[null,null,null,{"$f":"D15","v":"PRIME CONTRACTOR NAME"},"Prime Contractor Project Manager",null,{"$f":"'PRIME CONTRACTOR Administration'!G132","v":0},null,"Prime PM/CA Salary Cost","Prime PM/CA Fee Cost"]
[null,null,null,{"$f":"D15","v":"PRIME CONTRACTOR NAME"},"Prime Contractor Overhead ",null,{"$f":"ROUND(G48*F49,2)","v":0},null,{"$f":"SUM(G48:G49)","v":0},{"$f":"I49*$F$62","v":0}]
[]
[null,null,null,{"$f":"D18","v":"SUBCONTRACTOR1 NAME"},"Subcontractor1 Project Manager",null,{"$f":"'SUBCONTRACTOR1 Administration'!G132","v":0},null,"Sub1 PM/CA Salary Cost","Sub1 PM/CA Fee Cost"]
[null,null,null,{"$f":"D18","v":"SUBCONTRACTOR1 NAME"},"Subcontractor1 Overhead ",null,{"$f":"ROUND(G51*F52,2)","v":0},null,{"$f":"SUM(G51:G52)","v":0},{"$f":"I52*$F$62","v":0}]
[]
[null,null,null,{"$f":"D21","v":"SUBCONTRACTOR2 NAME"},"Subcontractor2 Project Manager",null,{"$f":"'SUBCONTRACTOR2 Administration'!G132","v":0},null,"Sub2 PM/CA Salary Cost","Sub2 PM/CA Fee Cost"]
[null,null,null,{"$f":"D21","v":"SUBCONTRACTOR2 NAME"},"Subcontractor2 Overhead ",null,{"$f":"ROUND(G54*F55,2)","v":0},null,{"$f":"SUM(G54:G55)","v":0},{"$f":"I55*$F$62","v":0}]
[]
[null,null,null,{"$f":"D24","v":"SUBCONTRACTOR3 NAME"},"Subcontractor3 Project Manager",null,{"$f":"'SUBCONTRACTOR3 Administration'!G132","v":0},null,"Sub3 PM/CA Salary Cost","Sub3 PM/CA Fee Cost"]
[null,null,null,{"$f":"D24","v":"SUBCONTRACTOR3 NAME"},"Subcontractor3 Overhead ",null,{"$f":"ROUND(G57*F58,2)","v":0},null,{"$f":"SUM(G57:G58)","v":0},{"$f":"I58*$F$62","v":0}]
[]
[null,null,null,null,"Subtotal",null,{"$f":"SUM(G48:G58)","v":0}]
[]
[null,null,null,null,"Operating Margin (Fixed Fee Rate) (Usually 9%)",null,{"$f":"ROUND(G60*F62,2)","v":0},null,{"$f":"SUM(I49:I58)","v":0},{"$f":"SUM(J49:J58)","v":0}]
[]
[null,null,null,null,"TOTAL DIRECT SALARY COST PM/CA",null,{"$f":"G60+G62","v":0},null,null,{"$f":"SUM(I62:J62)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"APPENDIX D (continued)"]
[]
[null,null,null,null,"PROJECT DIRECT EXPENSES"]
[null,null,null,null,null,null,null,null,"PRIME DIRECTs COST",{"$f":"J88/$J$99*$G$77","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"TOTAL DIRECT EXPENSES",null,{"$f":"'Direct Costs'!J55","v":0},null,"SUB1 DIRECTs COST",{"$f":"J91/$J$99*$G$77","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"SUB2 DIRECTs COST",{"$f":"J94/$J$99*$G$77","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"SUB3 DIRECTs COST",{"$f":"J97/$J$99*$G$77","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"AGREEMENT COSTS AND FEES SUMMARY",null,null,null,null,{"$f":"SUM(J76:J79)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Direct Salary Cost CEI Technicians",null,{"$f":"G41","v":0}]
[null,null,null,null,"Direct Salary Cost Project Management/Contract Administration",null,{"$f":"G64","v":0}]
[null,null,null,null,"Project Direct Expenses",null,{"$f":"+G77","v":0}]
[null,null,null,null,"TOTAL AGREEMENT COSTS AND FEES",null,{"$f":"SUM(G82:G84)","v":0}]
[]
[null,null,null,{"$f":"D15","v":"PRIME CONTRACTOR NAME"},"Facilities Cost of Capital (Prime Contractor TECHNICIANS) FIELD",null,{"$f":"ROUND((F87)*(G15),2)","v":0},null,"Prime TOTAL CoC Cost","PRIME TOTAL D&ND Salary COST"]
[null,null,null,{"$f":"D15","v":"PRIME CONTRACTOR NAME"},"Facilities Cost of Capital (Prime Contractor PROJECT  MANAGER) HOME",null,{"$f":"ROUND((F88)*(G48),2)","v":0},null,{"$f":"SUM(G87:G88)","v":0},{"$f":"SUM(J33,I49,J49,I88)","v":0}]
[]
[null,null,null,{"$f":"D18","v":"SUBCONTRACTOR1 NAME"},"Facilities Cost of Capital (Subcontractor 1 TECHNICIANS) FIELD",null,{"$f":"ROUND((F90)*(G18),2)","v":0},null,"Sub1 TOTAL CoC Cost","Sub1 TOTAL D&ND Salary COST"]
[null,null,null,{"$f":"D18","v":"SUBCONTRACTOR1 NAME"},"Facilities Cost of Capital (Subcontractor 1 PROJECT  MANAGER) HOME",null,{"$f":"ROUND((F91)*(G51),2)","v":0},null,{"$f":"SUM(G90:G91)","v":0},{"$f":"SUM(J35,I52,J52,I91)","v":0}]
[]
[null,null,null,{"$f":"D21","v":"SUBCONTRACTOR2 NAME"},"Facilities Cost of Capital (Subcontractor 2 TECHNICIANS) FIELD",null,{"$f":"ROUND((F93)*(G21),2)","v":0},null,"Sub2 TOTAL CoC Cost","Sub2 TOTAL D&ND Salary COST"]
[null,null,null,{"$f":"D21","v":"SUBCONTRACTOR2 NAME"},"Facilities Cost of Capital (Subcontractor 2 PROJECT  MANAGER) HOME",null,{"$f":"ROUND((F94)*(G54),2)","v":0},null,{"$f":"SUM(G93:G94)","v":0},{"$f":"SUM(J37,I55,J55,I94)","v":0}]
[]
[null,null,null,{"$f":"D24","v":"SUBCONTRACTOR3 NAME"},"Facilities Cost of Capital (Subcontractor 3 TECHNICIANS) FIELD",null,{"$f":"ROUND((F96)*(G24),2)","v":0},null,"Sub3 TOTAL CoC Cost","Sub3 TOTAL D&ND Salary COST"]
[null,null,null,{"$f":"D24","v":"SUBCONTRACTOR3 NAME"},"Facilities Cost of Capital (Subcontractor 3 PROJECT  MANAGER) HOME",null,{"$f":"ROUND((F97)*(G57),2)","v":0},null,{"$f":"SUM(G96:G97)","v":0},{"$f":"SUM(J39,I58,J58,I97)","v":0}]
[]
[null,null,null,null,"TOTAL Non-DIRECT SALARY COST CEI TECHNICIANS & PM/CA",null,{"$f":"SUM(G87:G97)","v":0},null,{"$f":"SUM(I87:I97)","v":0},{"$f":"SUM(J87:J97)","v":0}]
[]
[null,null,null,null,"TOTAL DIRECT and NON-DIRECT SALARY COST CEI TECHs & PM/CA",null,{"$f":"SUM(G41,G64,G99)","v":0}]
[]
[null,null,null,null,"Contingency"]
[]
[null,null,null,null,"TOTAL AGREEMENT AMOUNT",null,{"$f":"SUM(G85,G99)","v":0},null,"TOTAL AGREEMENT AMOUNT",{"$f":"SUM(J80,J99)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"FOR STAND-ALONE PURCHASE ORDERS ONLY -- ADDITIVE:",{"$f":"IF(G109-G105<0,\"\",G109-G105)","v":0}]
[]
[null,null,null,null,null,"STAND-ALONE PO WILL BE WRITTEN FOR THIS AMOUNT:"]
[]
[null,null,null,null,"MANHOURS TECHNICIANS",{"$f":"'Prime Contractor Technicians'!E211+'SUBCONTRACTOR1 Technicians'!E211+'SUBCONTRACTOR2 Technicians'!E211+'SUBCONTRACTOR3 Technicians'!E211","v":0}]
[null,null,null,null,"MANHOURS PROJECT MANAGEMENT",{"$f":"'PRIME CONTRACTOR Administration'!E132+'SUBCONTRACTOR1 Administration'!E132+'SUBCONTRACTOR2 Administration'!E132+'SUBCONTRACTOR3 Administration'!E132","v":0}]
[null,null,null,null,"TOTAL MANHOURS",{"$f":"SUM(F111:F112)","v":0}]
[null,null,null,null,null,"LABOR COSTS",{"$f":"SUM(G82,G83,G87:G97)","v":0}]
[null,null,null,null,null,"DIRECT EXPENSES",{"$f":"SUM(G77,G103)","v":0}]
[null,null,null,null,null,"TOTAL COSTS",{"$f":"SUM(G114:G115)","v":0}]

{"sheet":"Prime Contractor Technicians","index":1,"n_rows":216,"n_cols":14,"rows_kept":216,"cut":false,"hidden":true,"merged":[[215,1,215,13],[32,1,32,13],[65,1,65,13],[98,1,98,13],[131,1,131,13],[164,1,164,13],[197,1,197,13]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Labor Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N211","v":0}]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"Cover!E8","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"Cover!D15","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C12+D12","v":0},null,{"$f":"F12*E12","v":0},{"$f":"D12","v":0},{"$f":"ROUND(F12/2,2)","v":0},{"$f":"(I12)*H12","v":0},null,{"$f":"ROUND(F12*0.1, 2)","v":0},{"$f":"(K12)*L12","v":0},{"$f":"G12+J12+M12","v":0}]
[null,null,null,null,{"$f":"C13+D13","v":0},null,{"$f":"F13*E13","v":0},{"$f":"D13","v":0},{"$f":"ROUND(F13/2,2)","v":0},{"$f":"(I13)*H13","v":0},null,{"$f":"ROUND(F13*0.1, 2)","v":0},{"$f":"(K13)*L13","v":0},{"$f":"G13+J13+M13","v":0}]
[null,null,null,null,{"$f":"C14+D14","v":0},null,{"$f":"F14*E14","v":0},{"$f":"D14","v":0},{"$f":"ROUND(F14/2,2)","v":0},{"$f":"(I14)*H14","v":0},null,{"$f":"ROUND(F14*0.1, 2)","v":0},{"$f":"(K14)*L14","v":0},{"$f":"G14+J14+M14","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C12:C27)","v":0},{"$f":"SUM(D12:D27)","v":0},{"$f":"SUM(E12:E27)","v":0},null,{"$f":"SUM(G12:G27)","v":0},{"$f":"SUM(H12:H27)","v":0},null,{"$f":"SUM(J12:J27)","v":0},{"$f":"SUM(K12:K27)","v":0},null,{"$f":"SUM(M12:M27)","v":0},{"$f":"SUM(N12:N27)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J28+M28","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C45+D45","v":0},null,{"$f":"F45*E45","v":0},{"$f":"D45","v":0},{"$f":"ROUND(F45/2,2)","v":0},{"$f":"(I45)*H45","v":0},null,{"$f":"ROUND(F45*0.1, 2)","v":0},{"$f":"(K45)*L45","v":0},{"$f":"G45+J45+M45","v":0}]
[null,null,null,null,0,null,0,{"$f":"D46","v":0},{"$f":"ROUND(F46/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,{"$f":"C47+D47","v":0},null,{"$f":"F47*E47","v":0},{"$f":"D47","v":0},{"$f":"ROUND(F47/2,2)","v":0},{"$f":"(I47)*H47","v":0},null,{"$f":"ROUND(F47*0.1, 2)","v":0},{"$f":"(K47)*L47","v":0},{"$f":"G47+J47+M47","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C45:C60)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K45:K60)","v":0},null,{"$f":"SUM(M45:M60)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J61+M61","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C78+D78","v":0},null,{"$f":"F78*E78","v":0},{"$f":"D78","v":0},{"$f":"ROUND(F78/2,2)","v":0},{"$f":"(I78)*H78","v":0},null,{"$f":"ROUND(F78*0.1, 2)","v":0},{"$f":"(K78)*L78","v":0},{"$f":"G78+J78+M78","v":0}]
[null,null,null,null,0,null,0,{"$f":"D79","v":0},{"$f":"ROUND(F79/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,0,null,0,{"$f":"D80","v":0},0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C78:C93)","v":0},{"$f":"SUM(D78:D93)","v":0},{"$f":"SUM(E78:E93)","v":0},null,{"$f":"SUM(G78:G93)","v":0},{"$f":"SUM(H78:H93)","v":0},null,{"$f":"SUM(J78:J93)","v":0},{"$f":"SUM(K78:K93)","v":0},null,{"$f":"SUM(M78:M93)","v":0},{"$f":"SUM(N78:N93)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J94+M94","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C111+D111","v":0},null,{"$f":"F111*E111","v":0},{"$f":"D111","v":0},{"$f":"ROUND(F111/2,2)","v":0},{"$f":"(I111)*H111","v":0},null,{"$f":"ROUND(F111*0.1, 2)","v":0},{"$f":"(K111)*L111","v":0},{"$f":"G111+J111+M111","v":0}]
[null,null,null,null,0,null,0,{"$f":"D112","v":0},{"$f":"ROUND(F112/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,0,null,0,{"$f":"D113","v":0},0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C111:C126)","v":0},{"$f":"SUM(D111:D126)","v":0},{"$f":"SUM(E111:E126)","v":0},null,{"$f":"SUM(G111:G126)","v":0},{"$f":"SUM(H111:H126)","v":0},null,{"$f":"SUM(J111:J126)","v":0},{"$f":"SUM(K111:K126)","v":0},null,{"$f":"SUM(M111:M126)","v":0},{"$f":"SUM(N111:N126)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J127+M127","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C144+D144","v":0},null,{"$f":"F144*E144","v":0},{"$f":"D144","v":0},{"$f":"ROUND(F144/2,2)","v":0},{"$f":"(I144)*H144","v":0},null,{"$f":"ROUND(F144*0.1, 2)","v":0},{"$f":"(K144)*L144","v":0},{"$f":"G144+J144+M144","v":0}]
[null,null,null,null,0,null,0,0,{"$f":"ROUND(F145/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,{"$f":"C146+D146","v":0},null,{"$f":"F146*E146","v":0},{"$f":"D146","v":0},{"$f":"ROUND(F146/2,2)","v":0},{"$f":"(I146)*H146","v":0},null,{"$f":"ROUND(F146*0.1, 2)","v":0},{"$f":"(K146)*L146","v":0},{"$f":"G146+J146+M146","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C144:C159)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K144:K159)","v":0},null,{"$f":"SUM(M144:M159)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J160+M160","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C177+D177","v":0},null,{"$f":"F177*E177","v":0},{"$f":"D177","v":0},{"$f":"ROUND(F177/2,2)","v":0},{"$f":"(I177)*H177","v":0},null,{"$f":"ROUND(F177*0.1, 2)","v":0},{"$f":"(K177)*L177","v":0},{"$f":"G177+J177+M177","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,{"$f":"G178+J178+M178","v":0}]
[null,null,null,null,{"$f":"C179+D179","v":0},null,{"$f":"F179*E179","v":0},{"$f":"D179","v":0},{"$f":"ROUND(F179/2,2)","v":0},{"$f":"(I179)*H179","v":0},null,{"$f":"ROUND(F179*0.1, 2)","v":0},{"$f":"(K179)*L179","v":0},{"$f":"G179+J179+M179","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,{"$f":"G186+J186+M186","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C177:C192)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K177:K192)","v":0},null,{"$f":"SUM(M177:M192)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J193+M193","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,null,"GRAND TOTAL FOR ALL CALENDAR YEARS",{"$f":"H10","v":0},"TO",{"$f":"H175","v":0}]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[]
[null,"TOTALS",{"$f":"C28+C61+C94+C127+C160+C193","v":0},{"$f":"D28+D61+D94+D127+D160+D193","v":0},{"$f":"E28+E61+E94+E127+E160+E193","v":0},null,{"$f":"G28+G61+G94+G127+G160+G193","v":0},{"$f":"H28+H61+H94+H127+H160+H193","v":0},null,{"$f":"J28+J61+J94+J127+J160+J193","v":0},{"$f":"K28+K61+K94+K127+K160+K193","v":0},null,{"$f":"M28+M61+M94+M127+M160+M193","v":0},{"$f":"N28+N61+N94+N127+N160+N193","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J211+M211","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]

{"sheet":"SUBCONTRACTOR1 Technicians","index":2,"n_rows":216,"n_cols":14,"rows_kept":216,"cut":false,"hidden":true,"merged":[[215,1,215,13],[32,1,32,13],[65,1,65,13],[98,1,98,13],[131,1,131,13],[164,1,164,13],[197,1,197,13]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Labor Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N211","v":0}]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"Cover!$E$8","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"Cover!D18","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C12+D12","v":0},null,{"$f":"F12*E12","v":0},{"$f":"D12","v":0},{"$f":"ROUND(F12/2,2)","v":0},{"$f":"(I12)*H12","v":0},null,{"$f":"ROUND(F12*0.1, 2)","v":0},{"$f":"(K12)*L12","v":0},{"$f":"G12+J12+M12","v":0}]
[null,null,null,null,{"$f":"C13+D13","v":0},null,{"$f":"F13*E13","v":0},{"$f":"D13","v":0},{"$f":"ROUND(F13/2,2)","v":0},{"$f":"(I13)*H13","v":0},null,{"$f":"ROUND(F13*0.1, 2)","v":0},{"$f":"(K13)*L13","v":0},{"$f":"G13+J13+M13","v":0}]
[null,null,null,null,{"$f":"C14+D14","v":0},null,{"$f":"F14*E14","v":0},{"$f":"D14","v":0},{"$f":"ROUND(F14/2,2)","v":0},{"$f":"(I14)*H14","v":0},null,{"$f":"ROUND(F14*0.1, 2)","v":0},{"$f":"(K14)*L14","v":0},{"$f":"G14+J14+M14","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C12:C27)","v":0},{"$f":"SUM(D12:D27)","v":0},{"$f":"SUM(E12:E27)","v":0},null,{"$f":"SUM(G12:G27)","v":0},{"$f":"SUM(H12:H27)","v":0},null,{"$f":"SUM(J12:J27)","v":0},{"$f":"SUM(K12:K27)","v":0},null,{"$f":"SUM(M12:M27)","v":0},{"$f":"SUM(N12:N27)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J28+M28","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C45+D45","v":0},null,{"$f":"F45*E45","v":0},{"$f":"D45","v":0},{"$f":"ROUND(F45/2,2)","v":0},{"$f":"(I45)*H45","v":0},null,{"$f":"ROUND(F45*0.1, 2)","v":0},{"$f":"(K45)*L45","v":0},{"$f":"G45+J45+M45","v":0}]
[null,null,null,null,0,null,0,{"$f":"D46","v":0},{"$f":"ROUND(F46/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,{"$f":"C47+D47","v":0},null,{"$f":"F47*E47","v":0},{"$f":"D47","v":0},{"$f":"ROUND(F47/2,2)","v":0},{"$f":"(I47)*H47","v":0},null,{"$f":"ROUND(F47*0.1, 2)","v":0},{"$f":"(K47)*L47","v":0},{"$f":"G47+J47+M47","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C45:C60)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K45:K60)","v":0},null,{"$f":"SUM(M45:M60)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J61+M61","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C78+D78","v":0},null,{"$f":"F78*E78","v":0},{"$f":"D78","v":0},{"$f":"ROUND(F78/2,2)","v":0},{"$f":"(I78)*H78","v":0},null,{"$f":"ROUND(F78*0.1, 2)","v":0},{"$f":"(K78)*L78","v":0},{"$f":"G78+J78+M78","v":0}]
[null,null,null,null,0,null,0,{"$f":"D79","v":0},{"$f":"ROUND(F79/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,0,null,0,{"$f":"D80","v":0},0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C78:C93)","v":0},{"$f":"SUM(D78:D93)","v":0},{"$f":"SUM(E78:E93)","v":0},null,{"$f":"SUM(G78:G93)","v":0},{"$f":"SUM(H78:H93)","v":0},null,{"$f":"SUM(J78:J93)","v":0},{"$f":"SUM(K78:K93)","v":0},null,{"$f":"SUM(M78:M93)","v":0},{"$f":"SUM(N78:N93)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J94+M94","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C111+D111","v":0},null,{"$f":"F111*E111","v":0},{"$f":"D111","v":0},{"$f":"ROUND(F111/2,2)","v":0},{"$f":"(I111)*H111","v":0},null,{"$f":"ROUND(F111*0.1, 2)","v":0},{"$f":"(K111)*L111","v":0},{"$f":"G111+J111+M111","v":0}]
[null,null,null,null,0,null,0,{"$f":"D112","v":0},{"$f":"ROUND(F112/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,0,null,0,{"$f":"D113","v":0},0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C111:C126)","v":0},{"$f":"SUM(D111:D126)","v":0},{"$f":"SUM(E111:E126)","v":0},null,{"$f":"SUM(G111:G126)","v":0},{"$f":"SUM(H111:H126)","v":0},null,{"$f":"SUM(J111:J126)","v":0},{"$f":"SUM(K111:K126)","v":0},null,{"$f":"SUM(M111:M126)","v":0},{"$f":"SUM(N111:N126)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J127+M127","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C144+D144","v":0},null,{"$f":"F144*E144","v":0},{"$f":"D144","v":0},{"$f":"ROUND(F144/2,2)","v":0},{"$f":"(I144)*H144","v":0},null,{"$f":"ROUND(F144*0.1, 2)","v":0},{"$f":"(K144)*L144","v":0},{"$f":"G144+J144+M144","v":0}]
[null,null,null,null,0,null,0,0,{"$f":"ROUND(F145/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,{"$f":"C146+D146","v":0},null,{"$f":"F146*E146","v":0},{"$f":"D146","v":0},{"$f":"ROUND(F146/2,2)","v":0},{"$f":"(I146)*H146","v":0},null,{"$f":"ROUND(F146*0.1, 2)","v":0},{"$f":"(K146)*L146","v":0},{"$f":"G146+J146+M146","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C144:C159)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K144:K159)","v":0},null,{"$f":"SUM(M144:M159)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J160+M160","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C177+D177","v":0},null,{"$f":"F177*E177","v":0},{"$f":"D177","v":0},{"$f":"ROUND(F177/2,2)","v":0},{"$f":"(I177)*H177","v":0},null,{"$f":"ROUND(F177*0.1, 2)","v":0},{"$f":"(K177)*L177","v":0},{"$f":"G177+J177+M177","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,{"$f":"G178+J178+M178","v":0}]
[null,null,null,null,{"$f":"C179+D179","v":0},null,{"$f":"F179*E179","v":0},{"$f":"D179","v":0},{"$f":"ROUND(F179/2,2)","v":0},{"$f":"(I179)*H179","v":0},null,{"$f":"ROUND(F179*0.1, 2)","v":0},{"$f":"(K179)*L179","v":0},{"$f":"G179+J179+M179","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,{"$f":"G186+J186+M186","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C177:C192)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K177:K192)","v":0},null,{"$f":"SUM(M177:M192)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J193+M193","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,null,"GRAND TOTAL FOR ALL CALENDAR YEARS",{"$f":"H10","v":0},"TO",{"$f":"H175","v":0}]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[]
[null,"TOTALS",{"$f":"C28+C61+C94+C127+C160+C193","v":0},{"$f":"D28+D61+D94+D127+D160+D193","v":0},{"$f":"E28+E61+E94+E127+E160+E193","v":0},null,{"$f":"G28+G61+G94+G127+G160+G193","v":0},{"$f":"H28+H61+H94+H127+H160+H193","v":0},null,{"$f":"J28+J61+J94+J127+J160+J193","v":0},{"$f":"K28+K61+K94+K127+K160+K193","v":0},null,{"$f":"M28+M61+M94+M127+M160+M193","v":0},{"$f":"N28+N61+N94+N127+N160+N193","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J211+M211","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]

{"sheet":"SUBCONTRACTOR2 Technicians","index":3,"n_rows":216,"n_cols":14,"rows_kept":216,"cut":false,"hidden":true,"merged":[[215,1,215,13],[32,1,32,13],[65,1,65,13],[98,1,98,13],[131,1,131,13],[164,1,164,13],[197,1,197,13]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Labor Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N211","v":0}]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"Cover!E8","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"Cover!D21","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C12+D12","v":0},null,{"$f":"F12*E12","v":0},{"$f":"D12","v":0},{"$f":"ROUND(F12/2,2)","v":0},{"$f":"(I12)*H12","v":0},null,{"$f":"ROUND(F12*0.1, 2)","v":0},{"$f":"(K12)*L12","v":0},{"$f":"G12+J12+M12","v":0}]
[null,null,null,null,{"$f":"C13+D13","v":0},null,{"$f":"F13*E13","v":0},{"$f":"D13","v":0},{"$f":"ROUND(F13/2,2)","v":0},{"$f":"(I13)*H13","v":0},null,{"$f":"ROUND(F13*0.1, 2)","v":0},{"$f":"(K13)*L13","v":0},{"$f":"G13+J13+M13","v":0}]
[null,null,null,null,{"$f":"C14+D14","v":0},null,{"$f":"F14*E14","v":0},{"$f":"D14","v":0},{"$f":"ROUND(F14/2,2)","v":0},{"$f":"(I14)*H14","v":0},null,{"$f":"ROUND(F14*0.1, 2)","v":0},{"$f":"(K14)*L14","v":0},{"$f":"G14+J14+M14","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C12:C27)","v":0},{"$f":"SUM(D12:D27)","v":0},{"$f":"SUM(E12:E27)","v":0},null,{"$f":"SUM(G12:G27)","v":0},{"$f":"SUM(H12:H27)","v":0},null,{"$f":"SUM(J12:J27)","v":0},{"$f":"SUM(K12:K27)","v":0},null,{"$f":"SUM(M12:M27)","v":0},{"$f":"SUM(N12:N27)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J28+M28","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C45+D45","v":0},null,{"$f":"F45*E45","v":0},{"$f":"D45","v":0},{"$f":"ROUND(F45/2,2)","v":0},{"$f":"(I45)*H45","v":0},null,{"$f":"ROUND(F45*0.1, 2)","v":0},{"$f":"(K45)*L45","v":0},{"$f":"G45+J45+M45","v":0}]
[null,null,null,null,0,null,0,{"$f":"D46","v":0},{"$f":"ROUND(F46/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,{"$f":"C47+D47","v":0},null,{"$f":"F47*E47","v":0},{"$f":"D47","v":0},{"$f":"ROUND(F47/2,2)","v":0},{"$f":"(I47)*H47","v":0},null,{"$f":"ROUND(F47*0.1, 2)","v":0},{"$f":"(K47)*L47","v":0},{"$f":"G47+J47+M47","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C45:C60)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K45:K60)","v":0},null,{"$f":"SUM(M45:M60)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J61+M61","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C78+D78","v":0},null,{"$f":"F78*E78","v":0},{"$f":"D78","v":0},{"$f":"ROUND(F78/2,2)","v":0},{"$f":"(I78)*H78","v":0},null,{"$f":"ROUND(F78*0.1, 2)","v":0},{"$f":"(K78)*L78","v":0},{"$f":"G78+J78+M78","v":0}]
[null,null,null,null,0,null,0,{"$f":"D79","v":0},{"$f":"ROUND(F79/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,0,null,0,{"$f":"D80","v":0},0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C78:C93)","v":0},{"$f":"SUM(D78:D93)","v":0},{"$f":"SUM(E78:E93)","v":0},null,{"$f":"SUM(G78:G93)","v":0},{"$f":"SUM(H78:H93)","v":0},null,{"$f":"SUM(J78:J93)","v":0},{"$f":"SUM(K78:K93)","v":0},null,{"$f":"SUM(M78:M93)","v":0},{"$f":"SUM(N78:N93)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J94+M94","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C111+D111","v":0},null,{"$f":"F111*E111","v":0},{"$f":"D111","v":0},{"$f":"ROUND(F111/2,2)","v":0},{"$f":"(I111)*H111","v":0},null,{"$f":"ROUND(F111*0.1, 2)","v":0},{"$f":"(K111)*L111","v":0},{"$f":"G111+J111+M111","v":0}]
[null,null,null,null,0,null,0,{"$f":"D112","v":0},{"$f":"ROUND(F112/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,0,null,0,{"$f":"D113","v":0},0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C111:C126)","v":0},{"$f":"SUM(D111:D126)","v":0},{"$f":"SUM(E111:E126)","v":0},null,{"$f":"SUM(G111:G126)","v":0},{"$f":"SUM(H111:H126)","v":0},null,{"$f":"SUM(J111:J126)","v":0},{"$f":"SUM(K111:K126)","v":0},null,{"$f":"SUM(M111:M126)","v":0},{"$f":"SUM(N111:N126)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J127+M127","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C144+D144","v":0},null,{"$f":"F144*E144","v":0},{"$f":"D144","v":0},{"$f":"ROUND(F144/2,2)","v":0},{"$f":"(I144)*H144","v":0},null,{"$f":"ROUND(F144*0.1, 2)","v":0},{"$f":"(K144)*L144","v":0},{"$f":"G144+J144+M144","v":0}]
[null,null,null,null,0,null,0,0,{"$f":"ROUND(F145/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,{"$f":"C146+D146","v":0},null,{"$f":"F146*E146","v":0},{"$f":"D146","v":0},{"$f":"ROUND(F146/2,2)","v":0},{"$f":"(I146)*H146","v":0},null,{"$f":"ROUND(F146*0.1, 2)","v":0},{"$f":"(K146)*L146","v":0},{"$f":"G146+J146+M146","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C144:C159)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K144:K159)","v":0},null,{"$f":"SUM(M144:M159)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J160+M160","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C177+D177","v":0},null,{"$f":"F177*E177","v":0},{"$f":"D177","v":0},{"$f":"ROUND(F177/2,2)","v":0},{"$f":"(I177)*H177","v":0},null,{"$f":"ROUND(F177*0.1, 2)","v":0},{"$f":"(K177)*L177","v":0},{"$f":"G177+J177+M177","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,{"$f":"G178+J178+M178","v":0}]
[null,null,null,null,{"$f":"C179+D179","v":0},null,{"$f":"F179*E179","v":0},{"$f":"D179","v":0},{"$f":"ROUND(F179/2,2)","v":0},{"$f":"(I179)*H179","v":0},null,{"$f":"ROUND(F179*0.1, 2)","v":0},{"$f":"(K179)*L179","v":0},{"$f":"G179+J179+M179","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,{"$f":"G186+J186+M186","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C177:C192)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K177:K192)","v":0},null,{"$f":"SUM(M177:M192)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J193+M193","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,null,"GRAND TOTAL FOR ALL CALENDAR YEARS",{"$f":"H10","v":0},"TO",{"$f":"H175","v":0}]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[]
[null,"TOTALS",{"$f":"C28+C61+C94+C127+C160+C193","v":0},{"$f":"D28+D61+D94+D127+D160+D193","v":0},{"$f":"E28+E61+E94+E127+E160+E193","v":0},null,{"$f":"G28+G61+G94+G127+G160+G193","v":0},{"$f":"H28+H61+H94+H127+H160+H193","v":0},null,{"$f":"J28+J61+J94+J127+J160+J193","v":0},{"$f":"K28+K61+K94+K127+K160+K193","v":0},null,{"$f":"M28+M61+M94+M127+M160+M193","v":0},{"$f":"N28+N61+N94+N127+N160+N193","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J211+M211","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]

{"sheet":"SUBCONTRACTOR3 Technicians","index":4,"n_rows":216,"n_cols":14,"rows_kept":216,"cut":false,"hidden":true,"merged":[[215,1,215,13],[32,1,32,13],[65,1,65,13],[98,1,98,13],[131,1,131,13],[164,1,164,13],[197,1,197,13]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Labor Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N211","v":0}]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"Cover!E8","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"Cover!D24","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C12+D12","v":0},null,{"$f":"F12*E12","v":0},{"$f":"D12","v":0},{"$f":"ROUND(F12/2,2)","v":0},{"$f":"(I12)*H12","v":0},null,{"$f":"ROUND(F12*0.1, 2)","v":0},{"$f":"(K12)*L12","v":0},{"$f":"G12+J12+M12","v":0}]
[null,null,null,null,{"$f":"C13+D13","v":0},null,{"$f":"F13*E13","v":0},{"$f":"D13","v":0},{"$f":"ROUND(F13/2,2)","v":0},{"$f":"(I13)*H13","v":0},null,{"$f":"ROUND(F13*0.1, 2)","v":0},{"$f":"(K13)*L13","v":0},{"$f":"G13+J13+M13","v":0}]
[null,null,null,null,{"$f":"C14+D14","v":0},null,{"$f":"F14*E14","v":0},{"$f":"D14","v":0},{"$f":"ROUND(F14/2,2)","v":0},{"$f":"(I14)*H14","v":0},null,{"$f":"ROUND(F14*0.1, 2)","v":0},{"$f":"(K14)*L14","v":0},{"$f":"G14+J14+M14","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C12:C27)","v":0},{"$f":"SUM(D12:D27)","v":0},{"$f":"SUM(E12:E27)","v":0},null,{"$f":"SUM(G12:G27)","v":0},{"$f":"SUM(H12:H27)","v":0},null,{"$f":"SUM(J12:J27)","v":0},{"$f":"SUM(K12:K27)","v":0},null,{"$f":"SUM(M12:M27)","v":0},{"$f":"SUM(N12:N27)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J28+M28","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C45+D45","v":0},null,{"$f":"F45*E45","v":0},{"$f":"D45","v":0},{"$f":"ROUND(F45/2,2)","v":0},{"$f":"(I45)*H45","v":0},null,{"$f":"ROUND(F45*0.1, 2)","v":0},{"$f":"(K45)*L45","v":0},{"$f":"G45+J45+M45","v":0}]
[null,null,null,null,0,null,0,{"$f":"D46","v":0},{"$f":"ROUND(F46/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,{"$f":"C47+D47","v":0},null,{"$f":"F47*E47","v":0},{"$f":"D47","v":0},{"$f":"ROUND(F47/2,2)","v":0},{"$f":"(I47)*H47","v":0},null,{"$f":"ROUND(F47*0.1, 2)","v":0},{"$f":"(K47)*L47","v":0},{"$f":"G47+J47+M47","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C45:C60)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K45:K60)","v":0},null,{"$f":"SUM(M45:M60)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J61+M61","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C78+D78","v":0},null,{"$f":"F78*E78","v":0},{"$f":"D78","v":0},{"$f":"ROUND(F78/2,2)","v":0},{"$f":"(I78)*H78","v":0},null,{"$f":"ROUND(F78*0.1, 2)","v":0},{"$f":"(K78)*L78","v":0},{"$f":"G78+J78+M78","v":0}]
[null,null,null,null,0,null,0,{"$f":"D79","v":0},{"$f":"ROUND(F79/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,0,null,0,{"$f":"D80","v":0},0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C78:C93)","v":0},{"$f":"SUM(D78:D93)","v":0},{"$f":"SUM(E78:E93)","v":0},null,{"$f":"SUM(G78:G93)","v":0},{"$f":"SUM(H78:H93)","v":0},null,{"$f":"SUM(J78:J93)","v":0},{"$f":"SUM(K78:K93)","v":0},null,{"$f":"SUM(M78:M93)","v":0},{"$f":"SUM(N78:N93)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J94+M94","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C111+D111","v":0},null,{"$f":"F111*E111","v":0},{"$f":"D111","v":0},{"$f":"ROUND(F111/2,2)","v":0},{"$f":"(I111)*H111","v":0},null,{"$f":"ROUND(F111*0.1, 2)","v":0},{"$f":"(K111)*L111","v":0},{"$f":"G111+J111+M111","v":0}]
[null,null,null,null,0,null,0,{"$f":"D112","v":0},{"$f":"ROUND(F112/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,0,null,0,{"$f":"D113","v":0},0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C111:C126)","v":0},{"$f":"SUM(D111:D126)","v":0},{"$f":"SUM(E111:E126)","v":0},null,{"$f":"SUM(G111:G126)","v":0},{"$f":"SUM(H111:H126)","v":0},null,{"$f":"SUM(J111:J126)","v":0},{"$f":"SUM(K111:K126)","v":0},null,{"$f":"SUM(M111:M126)","v":0},{"$f":"SUM(N111:N126)","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J127+M127","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C144+D144","v":0},null,{"$f":"F144*E144","v":0},{"$f":"D144","v":0},{"$f":"ROUND(F144/2,2)","v":0},{"$f":"(I144)*H144","v":0},null,{"$f":"ROUND(F144*0.1, 2)","v":0},{"$f":"(K144)*L144","v":0},{"$f":"G144+J144+M144","v":0}]
[null,null,null,null,0,null,0,0,{"$f":"ROUND(F145/2,2)","v":0},0,null,0,0,0]
[null,null,null,null,{"$f":"C146+D146","v":0},null,{"$f":"F146*E146","v":0},{"$f":"D146","v":0},{"$f":"ROUND(F146/2,2)","v":0},{"$f":"(I146)*H146","v":0},null,{"$f":"ROUND(F146*0.1, 2)","v":0},{"$f":"(K146)*L146","v":0},{"$f":"G146+J146+M146","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C144:C159)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K144:K159)","v":0},null,{"$f":"SUM(M144:M159)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J160+M160","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[null,null,null,null,{"$f":"C177+D177","v":0},null,{"$f":"F177*E177","v":0},{"$f":"D177","v":0},{"$f":"ROUND(F177/2,2)","v":0},{"$f":"(I177)*H177","v":0},null,{"$f":"ROUND(F177*0.1, 2)","v":0},{"$f":"(K177)*L177","v":0},{"$f":"G177+J177+M177","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,{"$f":"G178+J178+M178","v":0}]
[null,null,null,null,{"$f":"C179+D179","v":0},null,{"$f":"F179*E179","v":0},{"$f":"D179","v":0},{"$f":"ROUND(F179/2,2)","v":0},{"$f":"(I179)*H179","v":0},null,{"$f":"ROUND(F179*0.1, 2)","v":0},{"$f":"(K179)*L179","v":0},{"$f":"G179+J179+M179","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,{"$f":"G186+J186+M186","v":0}]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[null,null,null,null,0,null,0,0,0,0,null,0,0,0]
[]
[null,"TOTALS",{"$f":"SUM(C177:C192)","v":0},0,0,null,0,0,null,0,{"$f":"SUM(K177:K192)","v":0},null,{"$f":"SUM(M177:M192)","v":0},0]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J193+M193","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]
[]
[]
[]
[]
[null,"ENGINEERING AND INSPECTION - TECHNICIANS"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,null,"GRAND TOTAL FOR ALL CALENDAR YEARS",{"$f":"H10","v":0},"TO",{"$f":"H175","v":0}]
[null,"Personnel Classification / Employee Name","Regular Hours1","Overtime Hours2","Total Hours","Regular Rate3","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Shift Premium Hours","Shift Premium Rate","Shift Premium Labor Cost","Total Labor Cost"]
[]
[null,"TOTALS",{"$f":"C28+C61+C94+C127+C160+C193","v":0},{"$f":"D28+D61+D94+D127+D160+D193","v":0},{"$f":"E28+E61+E94+E127+E160+E193","v":0},null,{"$f":"G28+G61+G94+G127+G160+G193","v":0},{"$f":"H28+H61+H94+H127+H160+H193","v":0},null,{"$f":"J28+J61+J94+J127+J160+J193","v":0},{"$f":"K28+K61+K94+K127+K160+K193","v":0},null,{"$f":"M28+M61+M94+M127+M160+M193","v":0},{"$f":"N28+N61+N94+N127+N160+N193","v":0}]
[]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,"TOTAL PREMIUM LABOR",{"$f":"J211+M211","v":0}]
[null,"1 Estimated 165 hours / month"]
[null,"2 Estimated 10% of Regular Hours"]
[null,"3 Rates shown are Maximum Allowable Rates for purposes of establishing the Project CEI budget.\n   Actual Reimbursable Rates will be approved by the DEPARTMENT for each technician and shall not exceed the maximum allowable rates established for the classification."]

{"sheet":"PRIME CONTRACTOR Administration","index":5,"n_rows":135,"n_cols":11,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Total Labor Cost"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K132","v":0}]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"Cover!E8","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"'Prime Contractor Technicians'!B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C12+D12","v":0},null,{"$f":"F12*E12","v":0},{"$f":"D12","v":0},{"$f":"F12/2","v":0},{"$f":"I12*H12","v":0},{"$f":"J12+G12","v":0}]
[null,null,null,null,{"$f":"C13+D13","v":0},null,{"$f":"F13*E13","v":0},{"$f":"D13","v":0},{"$f":"F13/2","v":0},{"$f":"I13*H13","v":0},{"$f":"J13+G13","v":0}]
[null,null,null,null,{"$f":"C14+D14","v":0},null,{"$f":"F14*E14","v":0},{"$f":"D14","v":0},{"$f":"F14/2","v":0},{"$f":"I14*H14","v":0},{"$f":"J14+G14","v":0}]
[null,null,null,null,{"$f":"C15+D15","v":0},null,{"$f":"F15*E15","v":0},{"$f":"D15","v":0},{"$f":"F15/2","v":0},{"$f":"I15*H15","v":0},{"$f":"J15+G15","v":0}]
[null,"TOTALS",{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},0,null,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C32+D32","v":0},null,{"$f":"F32*E32","v":0},{"$f":"D32","v":0},{"$f":"F32/2","v":0},{"$f":"I32*H32","v":0},{"$f":"J32+G32","v":0}]
[null,null,null,null,{"$f":"C33+D33","v":0},null,{"$f":"F33*E33","v":0},{"$f":"D33","v":0},{"$f":"F33/2","v":0},{"$f":"I33*H33","v":0},{"$f":"J33+G33","v":0}]
[null,null,null,null,{"$f":"C34+D34","v":0},null,{"$f":"F34*E34","v":0},{"$f":"D34","v":0},{"$f":"F34/2","v":0},{"$f":"I34*H34","v":0},{"$f":"J34+G34","v":0}]
[null,null,null,null,{"$f":"C35+D35","v":0},null,{"$f":"F35*E35","v":0},{"$f":"D35","v":0},{"$f":"F35/2","v":0},{"$f":"I35*H35","v":0},{"$f":"J35+G35","v":0}]
[null,"TOTALS",{"$f":"SUM(C32:C35)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C52+D52","v":0},null,{"$f":"F52*E52","v":0},{"$f":"D52","v":0},{"$f":"F52/2","v":0},{"$f":"I52*H52","v":0},{"$f":"J52+G52","v":0}]
[null,null,null,null,{"$f":"C53+D53","v":0},null,{"$f":"F53*E53","v":0},{"$f":"D53","v":0},{"$f":"F53/2","v":0},{"$f":"I53*H53","v":0},{"$f":"J53+G53","v":0}]
[null,null,null,null,{"$f":"C54+D54","v":0},null,{"$f":"F54*E54","v":0},{"$f":"D54","v":0},{"$f":"F54/2","v":0},{"$f":"I54*H54","v":0},{"$f":"J54+G54","v":0}]
[null,null,null,null,{"$f":"C55+D55","v":0},null,{"$f":"F55*E55","v":0},{"$f":"D55","v":0},{"$f":"F55/2","v":0},{"$f":"I55*H55","v":0},{"$f":"J55+G55","v":0}]
[null,"TOTALS",{"$f":"SUM(C52:C55)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C72+D72","v":0},null,{"$f":"F72*E72","v":0},{"$f":"D72","v":0},{"$f":"F72/2","v":0},{"$f":"I72*H72","v":0},{"$f":"J72+G72","v":0}]
[null,null,null,null,{"$f":"C73+D73","v":0},null,{"$f":"F73*E73","v":0},{"$f":"D73","v":0},{"$f":"F73/2","v":0},{"$f":"I73*H73","v":0},{"$f":"J73+G73","v":0}]
[null,null,null,null,{"$f":"C74+D74","v":0},null,{"$f":"F74*E74","v":0},{"$f":"D74","v":0},{"$f":"F74/2","v":0},{"$f":"I74*H74","v":0},{"$f":"J74+G74","v":0}]
[null,null,null,null,{"$f":"C75+D75","v":0},null,{"$f":"F75*E75","v":0},{"$f":"D75","v":0},{"$f":"F75/2","v":0},{"$f":"I75*H75","v":0},{"$f":"J75+G75","v":0}]
[null,"TOTALS",{"$f":"SUM(C72:C75)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C92+D92","v":0},null,{"$f":"F92*E92","v":0},{"$f":"D92","v":0},{"$f":"F92/2","v":0},{"$f":"I92*H92","v":0},{"$f":"J92+G92","v":0}]
[null,null,null,null,{"$f":"C93+D93","v":0},null,{"$f":"F93*E93","v":0},{"$f":"D93","v":0},{"$f":"F93/2","v":0},{"$f":"I93*H93","v":0},{"$f":"J93+G93","v":0}]
[null,null,null,null,{"$f":"C94+D94","v":0},null,{"$f":"F94*E94","v":0},{"$f":"D94","v":0},{"$f":"F94/2","v":0},{"$f":"I94*H94","v":0},{"$f":"J94+G94","v":0}]
[null,null,null,null,{"$f":"C95+D95","v":0},null,{"$f":"F95*E95","v":0},{"$f":"D95","v":0},{"$f":"F95/2","v":0},{"$f":"I95*H95","v":0},{"$f":"J95+G95","v":0}]
[null,"TOTALS",{"$f":"SUM(C92:C95)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C112+D112","v":0},null,{"$f":"F112*E112","v":0},{"$f":"D112","v":0},{"$f":"F112/2","v":0},{"$f":"I112*H112","v":0},{"$f":"J112+G112","v":0}]
[null,null,null,null,{"$f":"C113+D113","v":0},null,{"$f":"F113*E113","v":0},{"$f":"D113","v":0},{"$f":"F113/2","v":0},{"$f":"I113*H113","v":0},{"$f":"J113+G113","v":0}]
[null,null,null,null,{"$f":"C114+D114","v":0},null,{"$f":"F114*E114","v":0},{"$f":"D114","v":0},{"$f":"F114/2","v":0},{"$f":"I114*H114","v":0},{"$f":"J114+G114","v":0}]
[null,null,null,null,{"$f":"C115+D115","v":0},null,{"$f":"F115*E115","v":0},{"$f":"D115","v":0},{"$f":"F115/2","v":0},{"$f":"I115*H115","v":0},{"$f":"J115+G115","v":0}]
[null,"TOTALS",{"$f":"SUM(C112:C115)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"PRIME CONTRACTOR NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR",{"$f":"G10","v":0},"TO",{"$f":"G110","v":0}]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"TOTALS",{"$f":"SUM(C16,C36,C56,C76,C96,C116)","v":0},{"$f":"SUM(D16,D36,D56,D76,D96,D116)","v":0},{"$f":"SUM(E16,E36,E56,E76,E96,E116)","v":0},null,{"$f":"SUM(G16,G36,G56,G76,G96,G116)","v":0},{"$f":"SUM(0)","v":0},null,{"$f":"SUM(0)","v":0},{"$f":"SUM(K16,K36,K56,K76,K96,K116)","v":0}]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]

{"sheet":"SUBCONTRACTOR1 Administration","index":6,"n_rows":135,"n_cols":11,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Total Labor Cost"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K132","v":0}]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"Cover!$E$8","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"'SUBCONTRACTOR1 Technicians'!$B$8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C12+D12","v":0},null,{"$f":"F12*E12","v":0},{"$f":"D12","v":0},{"$f":"F12/2","v":0},{"$f":"I12*H12","v":0},{"$f":"J12+G12","v":0}]
[null,null,null,null,{"$f":"C13+D13","v":0},null,{"$f":"F13*E13","v":0},{"$f":"D13","v":0},{"$f":"F13/2","v":0},{"$f":"I13*H13","v":0},{"$f":"J13+G13","v":0}]
[null,null,null,null,{"$f":"C14+D14","v":0},null,{"$f":"F14*E14","v":0},{"$f":"D14","v":0},{"$f":"F14/2","v":0},{"$f":"I14*H14","v":0},{"$f":"J14+G14","v":0}]
[null,null,null,null,{"$f":"C15+D15","v":0},null,{"$f":"F15*E15","v":0},{"$f":"D15","v":0},{"$f":"F15/2","v":0},{"$f":"I15*H15","v":0},{"$f":"J15+G15","v":0}]
[null,"TOTALS",{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},0,null,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C32+D32","v":0},null,{"$f":"F32*E32","v":0},{"$f":"D32","v":0},{"$f":"F32/2","v":0},{"$f":"I32*H32","v":0},{"$f":"J32+G32","v":0}]
[null,null,null,null,{"$f":"C33+D33","v":0},null,{"$f":"F33*E33","v":0},{"$f":"D33","v":0},{"$f":"F33/2","v":0},{"$f":"I33*H33","v":0},{"$f":"J33+G33","v":0}]
[null,null,null,null,{"$f":"C34+D34","v":0},null,{"$f":"F34*E34","v":0},{"$f":"D34","v":0},{"$f":"F34/2","v":0},{"$f":"I34*H34","v":0},{"$f":"J34+G34","v":0}]
[null,null,null,null,{"$f":"C35+D35","v":0},null,{"$f":"F35*E35","v":0},{"$f":"D35","v":0},{"$f":"F35/2","v":0},{"$f":"I35*H35","v":0},{"$f":"J35+G35","v":0}]
[null,"TOTALS",{"$f":"SUM(C32:C35)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B27","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B28","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C52+D52","v":0},null,{"$f":"F52*E52","v":0},{"$f":"D52","v":0},{"$f":"F52/2","v":0},{"$f":"I52*H52","v":0},{"$f":"J52+G52","v":0}]
[null,null,null,null,{"$f":"C53+D53","v":0},null,{"$f":"F53*E53","v":0},{"$f":"D53","v":0},{"$f":"F53/2","v":0},{"$f":"I53*H53","v":0},{"$f":"J53+G53","v":0}]
[null,null,null,null,{"$f":"C54+D54","v":0},null,{"$f":"F54*E54","v":0},{"$f":"D54","v":0},{"$f":"F54/2","v":0},{"$f":"I54*H54","v":0},{"$f":"J54+G54","v":0}]
[null,null,null,null,{"$f":"C55+D55","v":0},null,{"$f":"F55*E55","v":0},{"$f":"D55","v":0},{"$f":"F55/2","v":0},{"$f":"I55*H55","v":0},{"$f":"J55+G55","v":0}]
[null,"TOTALS",{"$f":"SUM(C52:C55)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B27","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B28","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C72+D72","v":0},null,{"$f":"F72*E72","v":0},{"$f":"D72","v":0},{"$f":"F72/2","v":0},{"$f":"I72*H72","v":0},{"$f":"J72+G72","v":0}]
[null,null,null,null,{"$f":"C73+D73","v":0},null,{"$f":"F73*E73","v":0},{"$f":"D73","v":0},{"$f":"F73/2","v":0},{"$f":"I73*H73","v":0},{"$f":"J73+G73","v":0}]
[null,null,null,null,{"$f":"C74+D74","v":0},null,{"$f":"F74*E74","v":0},{"$f":"D74","v":0},{"$f":"F74/2","v":0},{"$f":"I74*H74","v":0},{"$f":"J74+G74","v":0}]
[null,null,null,null,{"$f":"C75+D75","v":0},null,{"$f":"F75*E75","v":0},{"$f":"D75","v":0},{"$f":"F75/2","v":0},{"$f":"I75*H75","v":0},{"$f":"J75+G75","v":0}]
[null,"TOTALS",{"$f":"SUM(C72:C75)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C92+D92","v":0},null,{"$f":"F92*E92","v":0},{"$f":"D92","v":0},{"$f":"F92/2","v":0},{"$f":"I92*H92","v":0},{"$f":"J92+G92","v":0}]
[null,null,null,null,{"$f":"C93+D93","v":0},null,{"$f":"F93*E93","v":0},{"$f":"D93","v":0},{"$f":"F93/2","v":0},{"$f":"I93*H93","v":0},{"$f":"J93+G93","v":0}]
[null,null,null,null,{"$f":"C94+D94","v":0},null,{"$f":"F94*E94","v":0},{"$f":"D94","v":0},{"$f":"F94/2","v":0},{"$f":"I94*H94","v":0},{"$f":"J94+G94","v":0}]
[null,null,null,null,{"$f":"C95+D95","v":0},null,{"$f":"F95*E95","v":0},{"$f":"D95","v":0},{"$f":"F95/2","v":0},{"$f":"I95*H95","v":0},{"$f":"J95+G95","v":0}]
[null,"TOTALS",{"$f":"SUM(C92:C95)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C112+D112","v":0},null,{"$f":"F112*E112","v":0},{"$f":"D112","v":0},{"$f":"F112/2","v":0},{"$f":"I112*H112","v":0},{"$f":"J112+G112","v":0}]
[null,null,null,null,{"$f":"C113+D113","v":0},null,{"$f":"F113*E113","v":0},{"$f":"D113","v":0},{"$f":"F113/2","v":0},{"$f":"I113*H113","v":0},{"$f":"J113+G113","v":0}]
[null,null,null,null,{"$f":"C114+D114","v":0},null,{"$f":"F114*E114","v":0},{"$f":"D114","v":0},{"$f":"F114/2","v":0},{"$f":"I114*H114","v":0},{"$f":"J114+G114","v":0}]
[null,null,null,null,{"$f":"C115+D115","v":0},null,{"$f":"F115*E115","v":0},{"$f":"D115","v":0},{"$f":"F115/2","v":0},{"$f":"I115*H115","v":0},{"$f":"J115+G115","v":0}]
[null,"TOTALS",{"$f":"SUM(C112:C115)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR1 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR",{"$f":"G10","v":0},"TO",{"$f":"G110","v":0}]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"TOTALS",{"$f":"SUM(C16,C36,C56,C76,C96,C116)","v":0},{"$f":"SUM(D16,D36,D56,D76,D96,D116)","v":0},{"$f":"SUM(E16,E36,E56,E76,E96,E116)","v":0},null,{"$f":"SUM(G16,G36,G56,G76,G96,G116)","v":0},{"$f":"SUM(0)","v":0},null,{"$f":"SUM(0)","v":0},{"$f":"SUM(K16,K36,K56,K76,K96,K116)","v":0}]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]

{"sheet":"SUBCONTRACTOR2 Administration","index":7,"n_rows":135,"n_cols":11,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Total Labor Cost"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K132","v":0}]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"Cover!E8","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"'SUBCONTRACTOR2 Technicians'!B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C12+D12","v":0},null,{"$f":"F12*E12","v":0},{"$f":"D12","v":0},{"$f":"F12/2","v":0},{"$f":"I12*H12","v":0},{"$f":"J12+G12","v":0}]
[null,null,null,null,{"$f":"C13+D13","v":0},null,{"$f":"F13*E13","v":0},{"$f":"D13","v":0},{"$f":"F13/2","v":0},{"$f":"I13*H13","v":0},{"$f":"J13+G13","v":0}]
[null,null,null,null,{"$f":"C14+D14","v":0},null,{"$f":"F14*E14","v":0},{"$f":"D14","v":0},{"$f":"F14/2","v":0},{"$f":"I14*H14","v":0},{"$f":"J14+G14","v":0}]
[null,null,null,null,{"$f":"C15+D15","v":0},null,{"$f":"F15*E15","v":0},{"$f":"D15","v":0},{"$f":"F15/2","v":0},{"$f":"I15*H15","v":0},{"$f":"J15+G15","v":0}]
[null,"TOTALS",{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},0,null,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C32+D32","v":0},null,{"$f":"F32*E32","v":0},{"$f":"D32","v":0},{"$f":"F32/2","v":0},{"$f":"I32*H32","v":0},{"$f":"J32+G32","v":0}]
[null,null,null,null,{"$f":"C33+D33","v":0},null,{"$f":"F33*E33","v":0},{"$f":"D33","v":0},{"$f":"F33/2","v":0},{"$f":"I33*H33","v":0},{"$f":"J33+G33","v":0}]
[null,null,null,null,{"$f":"C34+D34","v":0},null,{"$f":"F34*E34","v":0},{"$f":"D34","v":0},{"$f":"F34/2","v":0},{"$f":"I34*H34","v":0},{"$f":"J34+G34","v":0}]
[null,null,null,null,{"$f":"C35+D35","v":0},null,{"$f":"F35*E35","v":0},{"$f":"D35","v":0},{"$f":"F35/2","v":0},{"$f":"I35*H35","v":0},{"$f":"J35+G35","v":0}]
[null,"TOTALS",{"$f":"SUM(C32:C35)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B27","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B28","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C52+D52","v":0},null,{"$f":"F52*E52","v":0},{"$f":"D52","v":0},{"$f":"F52/2","v":0},{"$f":"I52*H52","v":0},{"$f":"J52+G52","v":0}]
[null,null,null,null,{"$f":"C53+D53","v":0},null,{"$f":"F53*E53","v":0},{"$f":"D53","v":0},{"$f":"F53/2","v":0},{"$f":"I53*H53","v":0},{"$f":"J53+G53","v":0}]
[null,null,null,null,{"$f":"C54+D54","v":0},null,{"$f":"F54*E54","v":0},{"$f":"D54","v":0},{"$f":"F54/2","v":0},{"$f":"I54*H54","v":0},{"$f":"J54+G54","v":0}]
[null,null,null,null,{"$f":"C55+D55","v":0},null,{"$f":"F55*E55","v":0},{"$f":"D55","v":0},{"$f":"F55/2","v":0},{"$f":"I55*H55","v":0},{"$f":"J55+G55","v":0}]
[null,"TOTALS",{"$f":"SUM(C52:C55)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B27","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B28","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C72+D72","v":0},null,{"$f":"F72*E72","v":0},{"$f":"D72","v":0},{"$f":"F72/2","v":0},{"$f":"I72*H72","v":0},{"$f":"J72+G72","v":0}]
[null,null,null,null,{"$f":"C73+D73","v":0},null,{"$f":"F73*E73","v":0},{"$f":"D73","v":0},{"$f":"F73/2","v":0},{"$f":"I73*H73","v":0},{"$f":"J73+G73","v":0}]
[null,null,null,null,{"$f":"C74+D74","v":0},null,{"$f":"F74*E74","v":0},{"$f":"D74","v":0},{"$f":"F74/2","v":0},{"$f":"I74*H74","v":0},{"$f":"J74+G74","v":0}]
[null,null,null,null,{"$f":"C75+D75","v":0},null,{"$f":"F75*E75","v":0},{"$f":"D75","v":0},{"$f":"F75/2","v":0},{"$f":"I75*H75","v":0},{"$f":"J75+G75","v":0}]
[null,"TOTALS",{"$f":"SUM(C72:C75)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C92+D92","v":0},null,{"$f":"F92*E92","v":0},{"$f":"D92","v":0},{"$f":"F92/2","v":0},{"$f":"I92*H92","v":0},{"$f":"J92+G92","v":0}]
[null,null,null,null,{"$f":"C93+D93","v":0},null,{"$f":"F93*E93","v":0},{"$f":"D93","v":0},{"$f":"F93/2","v":0},{"$f":"I93*H93","v":0},{"$f":"J93+G93","v":0}]
[null,null,null,null,{"$f":"C94+D94","v":0},null,{"$f":"F94*E94","v":0},{"$f":"D94","v":0},{"$f":"F94/2","v":0},{"$f":"I94*H94","v":0},{"$f":"J94+G94","v":0}]
[null,null,null,null,{"$f":"C95+D95","v":0},null,{"$f":"F95*E95","v":0},{"$f":"D95","v":0},{"$f":"F95/2","v":0},{"$f":"I95*H95","v":0},{"$f":"J95+G95","v":0}]
[null,"TOTALS",{"$f":"SUM(C92:C95)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C112+D112","v":0},null,{"$f":"F112*E112","v":0},{"$f":"D112","v":0},{"$f":"F112/2","v":0},{"$f":"I112*H112","v":0},{"$f":"J112+G112","v":0}]
[null,null,null,null,{"$f":"C113+D113","v":0},null,{"$f":"F113*E113","v":0},{"$f":"D113","v":0},{"$f":"F113/2","v":0},{"$f":"I113*H113","v":0},{"$f":"J113+G113","v":0}]
[null,null,null,null,{"$f":"C114+D114","v":0},null,{"$f":"F114*E114","v":0},{"$f":"D114","v":0},{"$f":"F114/2","v":0},{"$f":"I114*H114","v":0},{"$f":"J114+G114","v":0}]
[null,null,null,null,{"$f":"C115+D115","v":0},null,{"$f":"F115*E115","v":0},{"$f":"D115","v":0},{"$f":"F115/2","v":0},{"$f":"I115*H115","v":0},{"$f":"J115+G115","v":0}]
[null,"TOTALS",{"$f":"SUM(C112:C115)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR2 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR",{"$f":"G10","v":0},"TO",{"$f":"G110","v":0}]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"TOTALS",{"$f":"SUM(C16,C36,C56,C76,C96,C116)","v":0},{"$f":"SUM(D16,D36,D56,D76,D96,D116)","v":0},{"$f":"SUM(E16,E36,E56,E76,E96,E116)","v":0},null,{"$f":"SUM(G16,G36,G56,G76,G96,G116)","v":0},{"$f":"SUM(0)","v":0},null,{"$f":"SUM(0)","v":0},{"$f":"SUM(K16,K36,K56,K76,K96,K116)","v":0}]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]

{"sheet":"SUBCONTRACTOR3 Administration","index":8,"n_rows":135,"n_cols":11,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Total Labor Cost"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K132","v":0}]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"Cover!E8","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"'SUBCONTRACTOR3 Technicians'!B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C12+D12","v":0},null,{"$f":"F12*E12","v":0},{"$f":"D12","v":0},{"$f":"F12/2","v":0},{"$f":"I12*H12","v":0},{"$f":"J12+G12","v":0}]
[null,null,null,null,{"$f":"C13+D13","v":0},null,{"$f":"F13*E13","v":0},{"$f":"D13","v":0},{"$f":"F13/2","v":0},{"$f":"I13*H13","v":0},{"$f":"J13+G13","v":0}]
[null,null,null,null,{"$f":"C14+D14","v":0},null,{"$f":"F14*E14","v":0},{"$f":"D14","v":0},{"$f":"F14/2","v":0},{"$f":"I14*H14","v":0},{"$f":"J14+G14","v":0}]
[null,null,null,null,{"$f":"C15+D15","v":0},null,{"$f":"F15*E15","v":0},{"$f":"D15","v":0},{"$f":"F15/2","v":0},{"$f":"I15*H15","v":0},{"$f":"J15+G15","v":0}]
[null,"TOTALS",{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},0,null,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C32+D32","v":0},null,{"$f":"F32*E32","v":0},{"$f":"D32","v":0},{"$f":"F32/2","v":0},{"$f":"I32*H32","v":0},{"$f":"J32+G32","v":0}]
[null,null,null,null,{"$f":"C33+D33","v":0},null,{"$f":"F33*E33","v":0},{"$f":"D33","v":0},{"$f":"F33/2","v":0},{"$f":"I33*H33","v":0},{"$f":"J33+G33","v":0}]
[null,null,null,null,{"$f":"C34+D34","v":0},null,{"$f":"F34*E34","v":0},{"$f":"D34","v":0},{"$f":"F34/2","v":0},{"$f":"I34*H34","v":0},{"$f":"J34+G34","v":0}]
[null,null,null,null,{"$f":"C35+D35","v":0},null,{"$f":"F35*E35","v":0},{"$f":"D35","v":0},{"$f":"F35/2","v":0},{"$f":"I35*H35","v":0},{"$f":"J35+G35","v":0}]
[null,"TOTALS",{"$f":"SUM(C32:C35)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B27","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B28","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C52+D52","v":0},null,{"$f":"F52*E52","v":0},{"$f":"D52","v":0},{"$f":"F52/2","v":0},{"$f":"I52*H52","v":0},{"$f":"J52+G52","v":0}]
[null,null,null,null,{"$f":"C53+D53","v":0},null,{"$f":"F53*E53","v":0},{"$f":"D53","v":0},{"$f":"F53/2","v":0},{"$f":"I53*H53","v":0},{"$f":"J53+G53","v":0}]
[null,null,null,null,{"$f":"C54+D54","v":0},null,{"$f":"F54*E54","v":0},{"$f":"D54","v":0},{"$f":"F54/2","v":0},{"$f":"I54*H54","v":0},{"$f":"J54+G54","v":0}]
[null,null,null,null,{"$f":"C55+D55","v":0},null,{"$f":"F55*E55","v":0},{"$f":"D55","v":0},{"$f":"F55/2","v":0},{"$f":"I55*H55","v":0},{"$f":"J55+G55","v":0}]
[null,"TOTALS",{"$f":"SUM(C52:C55)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B27","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B28","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C72+D72","v":0},null,{"$f":"F72*E72","v":0},{"$f":"D72","v":0},{"$f":"F72/2","v":0},{"$f":"I72*H72","v":0},{"$f":"J72+G72","v":0}]
[null,null,null,null,{"$f":"C73+D73","v":0},null,{"$f":"F73*E73","v":0},{"$f":"D73","v":0},{"$f":"F73/2","v":0},{"$f":"I73*H73","v":0},{"$f":"J73+G73","v":0}]
[null,null,null,null,{"$f":"C74+D74","v":0},null,{"$f":"F74*E74","v":0},{"$f":"D74","v":0},{"$f":"F74/2","v":0},{"$f":"I74*H74","v":0},{"$f":"J74+G74","v":0}]
[null,null,null,null,{"$f":"C75+D75","v":0},null,{"$f":"F75*E75","v":0},{"$f":"D75","v":0},{"$f":"F75/2","v":0},{"$f":"I75*H75","v":0},{"$f":"J75+G75","v":0}]
[null,"TOTALS",{"$f":"SUM(C72:C75)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C92+D92","v":0},null,{"$f":"F92*E92","v":0},{"$f":"D92","v":0},{"$f":"F92/2","v":0},{"$f":"I92*H92","v":0},{"$f":"J92+G92","v":0}]
[null,null,null,null,{"$f":"C93+D93","v":0},null,{"$f":"F93*E93","v":0},{"$f":"D93","v":0},{"$f":"F93/2","v":0},{"$f":"I93*H93","v":0},{"$f":"J93+G93","v":0}]
[null,null,null,null,{"$f":"C94+D94","v":0},null,{"$f":"F94*E94","v":0},{"$f":"D94","v":0},{"$f":"F94/2","v":0},{"$f":"I94*H94","v":0},{"$f":"J94+G94","v":0}]
[null,null,null,null,{"$f":"C95+D95","v":0},null,{"$f":"F95*E95","v":0},{"$f":"D95","v":0},{"$f":"F95/2","v":0},{"$f":"I95*H95","v":0},{"$f":"J95+G95","v":0}]
[null,"TOTALS",{"$f":"SUM(C92:C95)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST "]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR"]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"PROJECT MANAGER",null,null,{"$f":"C112+D112","v":0},null,{"$f":"F112*E112","v":0},{"$f":"D112","v":0},{"$f":"F112/2","v":0},{"$f":"I112*H112","v":0},{"$f":"J112+G112","v":0}]
[null,null,null,null,{"$f":"C113+D113","v":0},null,{"$f":"F113*E113","v":0},{"$f":"D113","v":0},{"$f":"F113/2","v":0},{"$f":"I113*H113","v":0},{"$f":"J113+G113","v":0}]
[null,null,null,null,{"$f":"C114+D114","v":0},null,{"$f":"F114*E114","v":0},{"$f":"D114","v":0},{"$f":"F114/2","v":0},{"$f":"I114*H114","v":0},{"$f":"J114+G114","v":0}]
[null,null,null,null,{"$f":"C115+D115","v":0},null,{"$f":"F115*E115","v":0},{"$f":"D115","v":0},{"$f":"F115/2","v":0},{"$f":"I115*H115","v":0},{"$f":"J115+G115","v":0}]
[null,"TOTALS",{"$f":"SUM(C112:C115)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]
[]
[]
[]
[]
[]
[null,"ENGINEERING MANAGEMENT/CONTRACT ADMINISTRATION"]
[null,"DIRECT LABOR COST SUMMARY"]
[null,{"$f":"B7","v":"PROJECT DESCRIPTION"}]
[null,{"$f":"B8","v":"SUBCONTRACTOR3 NAME"}]
[]
[null,null,null,null,null,"CALENDAR YEAR",{"$f":"G10","v":0},"TO",{"$f":"G110","v":0}]
[null,"Personnel Classification / Employee Name1","Regular Hours","Overtime Hours","Total Hours","Regular Rate","Regular Labor Cost","Overtime Hours","Overtime Rate","Overtime Labor Cost","Total Labor Cost"]
[null,"TOTALS",{"$f":"SUM(C16,C36,C56,C76,C96,C116)","v":0},{"$f":"SUM(D16,D36,D56,D76,D96,D116)","v":0},{"$f":"SUM(E16,E36,E56,E76,E96,E116)","v":0},null,{"$f":"SUM(G16,G36,G56,G76,G96,G116)","v":0},{"$f":"SUM(0)","v":0},null,{"$f":"SUM(0)","v":0},{"$f":"SUM(K16,K36,K56,K76,K96,K116)","v":0}]
[]
[null,"1 One Management visit for prime firm is reimbursable every quarter"]
[null,"  One Management visit from subcontractors is reimbursable two times per year"]

{"sheet":"Direct Costs","index":9,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":true,"merged":[[8,2,8,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[7,2,7,9]]}
[null,null,null,null,null,null,null,null,"Version:",{"$f":"Cover!H1","v":"2024.01.04.RJS"}]
["CONTRACT ENGINEERING AND INSPECTION"]
["DIRECT EXPENSES"]
["FIELD EQUIPMENT AND SUPPLIES FURNISHED BY "]
[{"$f":"Cover!E8","v":"PROJECT DESCRIPTION"}]
[null,null,null,null,null,null,null,null,"TOTAL DIRECT COSTS:",{"$f":"J55","v":0}]
[]
[null,null,"* Vehicle Base Rates per \"MAXIMUM ALLOWABLE NON-SALARY DIRECT COSTS\" (latest version) -- Maximum Allowable Non-Salary Direct Costs.pdf located at:  https://connect.ncdot.gov/business/consultants/_layouts/download.aspx?SourceUrl=/business/consultants/Roadway/Maximum%20Allowable%20Non-Salary%20Direct%20Costs.pdf"]
[null,"Phones, Computers, iPads, Data Plans, Wifi, …etc. are in Overhead.","** Nuclear Gauge monthly reimbursement rate per M. L. Sylvester, PE memo dated May 13, 2019 entitled \"Reimbursement for Private Engineering Firm Furnished Nuclear Gauge\"."]
[]
["Item No. ","Description","Months","Quantity","Unit","Unit Price","Unit Tax","Total Unit Cost","Salvage Value","Total Cost"]
[1,"Project Vehicles - 2 wheel drive - # Vehicles *",null,null,"veh-mo",1074,null,{"$f":"G12+F12","v":1074},null,{"$f":"C12*D12*(H12)-C12*D12*I12","v":0}]
[{"$f":"A12+1","v":2},"Gas Reimbursement: 2-WD @ $0.XX per mile         Gas reimbursement based on $/gal/16 mpg.",null,null,"miles",0.2,null,null,null,{"$f":"C13*D13*F13","v":0}]
[{"$f":"A13+1","v":3},"Project Vehicles - 4 wheel drive -  # Vehicles *",null,null,"veh-mo",1140,null,{"$f":"F14+G14","v":1140},null,{"$f":"C14*D14*(H14)-C14*D14*I14","v":0}]
[4,"Gas Reimbursement: 4-WD @ $0.XX per mile        Gas reimbursement based on $/gal/14mpg.",null,null,"miles",0.23,null,null,null,{"$f":"C15*D15*F15","v":0}]
[5,"Project Vehicles - Survey Vehicle - #  Vehicle",null,null,"veh-mo",null,null,{"$f":"F16+G16","v":0},null,{"$f":"C16*D16*(H16)-C16*D16*I16","v":0}]
[6,"Gas Reimbursement: Survey Vehicle @ $TBD per mile         Gas reimbursement based on $TBD/gal/TBD mpg",null,null,"miles",null,null,null,null,{"$f":"C17*D17*F17","v":0}]
[7,"Communication (# mobile phones). --  -- RECOVERED THROUGH FIRM's OVERHEAD.",null,null,"mo",null,null,0,null,{"$f":"C18*D18*(H18)-C18*D18*I18","v":0}]
[8,"Survey Equipment",null,null,"Actual Cost (Not-to-Exceed)",null,null,0,null,0]
[9,"Troxler 3450 Thick Nuclear Gauges (Rent/Purchase) -- MONTHLY REIMBURSEMENT RATE = $400/month.  **",null,null,"gauge-month",400,null,400,null,0]
[10,"Leak Test, Calibration, Cleaning and Lubrication -- INCLUDED IN MONTHLY REIMBURSEMENT RATE ABOVE.  **",null,null,"yr",null,null,0,null,0]
[11,"Yearly NCDENR License Fee of  -- INCLUDED IN MONTHLY REIMBURSEMENT RATE ABOVE.  **",null,null,"yr",null,null,0,null,0]
[12,"Quarterly Testing of 10 Badges  per test -- INCLUDED IN MONTHLY REIMBURSEMENT RATE ABOVE.  **",null,null,"yr",null,{"$f":"F23*(0.0775)","v":0},0,null,0]
[13,"Mounted Transportation Box -- INCLUDED IN MONTHLY REIMBURSEMENT RATE ABOVE.  **",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,null,0]
[14,"Safety Harness w/ 2 Lanyards",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,null,0]
[15,"Field Office( Rent Monthly)",null,null,"mo",null,0,0,null,0]
[16,"Field Office Set up",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,null,{"$f":"(H27)-I27","v":0}]
[17,"Utilities (Monthly)",null,null,"mo",null,0,0,null,0]
[18,"Office Furniture",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,null,{"$f":"(H29)-I29","v":0}]
[19,"Monthly Office supplies ($50 per month) -- IF PEF PROVIDES A FIELD OFFICE. --  -- RECOVERED THROUGH FIRM's OVERHEAD.",null,null,"mo",null,0,0,null,0]
[20,"Computer (LAPTOP) -- HAS A $300.00 SALVAGE VALUE (CALCULATED AUTOMATICALLY). --  -- RECOVERED THROUGH FIRM's OVERHEAD.",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,{"$f":"IF(D31=\"\",0,300)","v":0},{"$f":"D31*(H31)-D31*I31","v":0}]
[21,"Concrete Air Pot",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,null,{"$f":"D32*(H32)-D32*I32","v":0}]
[22,"Concrete Slump Cone",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,null,0]
[23,"Conventional Density Equipment Set",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,null,0]
[24,"Copier",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,null,{"$f":"(H35)-I35","v":0}]
[25,"Copier Maintenance (yearly)",null,null,"Actual Cost (Not-to-Exceed)",null,null,0,null,{"$f":"(H36)-I36","v":0}]
[26,"Fax",null,null,"Actual Cost (Not-to-Exceed)",null,0,0,null,0]
[27,"Trips by Project Management"]
[28,"   PEF Prime = 4 trips per year @  ____ miles (Total # of Trips)",null,null,"mi",0.67,null,{"$f":"F39","v":0.67},null,{"$f":"D39*(H39)","v":0}]
[29,"   PEF Subconsultant1 = 2 trips per year @  ____ miles (Total # of Trips)",null,null,"mi",0.67,null,{"$f":"F40","v":0.67},null,{"$f":"D40*(H40)","v":0}]
[30,"   PEF Subconsultant2 = 2 trips per year @  ____ miles (Total # of Trips)",null,null,"mi",0.67,null,{"$f":"F41","v":0.67},null,0]
[31,"   PEF Subconsultant3 = 2 trips per year @  ____ miles (Total # of Trips)",null,null,"mi",0.67,null,{"$f":"F42","v":0.67},null,0]
[32,"-- Miscellaneous Direct Costs, etc. --",null,null,null,null,null,null,null,0]
[33,"Miscellaneous",null,null,null,null,0,{"$f":"F44","v":0},null,0]
[34,"Miscellaneous",null,null,null,null,0,0,null,0]
[35,"Miscellaneous",null,null,null,null,0,0,null,0]
[36,"Miscellaneous",null,null,null,null,0,0,null,0]
[37,"Miscellaneous",null,null,null,null,0,0,null,0]
[38,"Miscellaneous",null,null,null,null,0,0,null,0]
[39,"Miscellaneous",null,null,null,null,0,0,null,0]
[40,"Miscellaneous",null,null,null,null,0,0,null,0]
[41,"Miscellaneous",null,null,null,null,0,0,null,0]
[42,"Miscellaneous",null,null,null,null,0,0,null,0]
[]
[null,null,null,null,null,null,null,null,"TOTAL DIRECT COSTS:",{"$f":"SUM(J12:J53)","v":0}]

{"sheet":"Mileage","index":10,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":true,"merged":[[14,3,14,6],[16,3,16,7],[1,2,1,10],[2,2,2,10],[12,3,12,6],[13,3,13,6],[5,8,5,13],[12,9,12,16],[13,9,13,16]]}
[]
[null,null,"Reimbursable Vehicle Rate for Private Engineering Construction Engineering"]
[null,null,"and Inspection 2WD  and 4WD Vehicles"]
[]
[]
[null,null,null,null,null,null,null,null,"* Vehicle Base Rates per R. A. Hancock, PE memo dated June 6, 2013 entitled \"Vehicle Base Rates for Construction Engineering & Inspection\"."]
[]
[]
[null,null,null,null,"Base Rate/Vehicle/month",null,null,720,"2WD Base Vehicle Rate *."]
[null,null,null,null,null,null,null,null,780,"4 WD base rate *."]
[]
[]
[null,null,null,"Project Vehicle Miles per Month",null,null,null,null,"**","** Reimbursed by Mileage Reimbursement and Vehicle Mileage Logs."]
[null,null,null,"Average Fuel Price ",null,null,null,null,"**","** Reimbursed by Mileage Reimbursement and Vehicle Mileage Logs."]
[null,null,null,"Monthly 2WD Vehicle Fuel Cost @ 18 mpg",null,null,null,{"$f":"H13/18*H14","v":0}]
[]
[null,null,null,"Monthly 4 WD Vehicle Fuel Cost @ 14 mpg",null,null,null,null,{"$f":"H13/14*H14","v":0}]
[]
[]
[null,null,null,"Monthly Rental Rate (2 WD)",null,null,null,{"$f":"H9+H15","v":720}]
[]
[]
[null,null,null,null,"Monthly Rental Rate (4 WD)",null,null,null,{"$f":"I10+I17","v":780}]