{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Menu","Option 1","Contractor","Sub1","Sub2","Sub3","Sub4","Sub5","Sub6","Sub7","Sub8","Sub9","Sub10","Option 2","SWA","SWA Raw Convert","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":80,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[10,2,10,9],[15,1,19,9],[21,2,21,9],[26,1,30,9],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,1,8,9]]}
[]
[]
[]
["MENU"]
[]
[null,"Specifications Section 4-3.2 allows for alteration in the character of the contract work to be paid for by the calculations in Specifications Section 4-3.2.1 and 4-3.2.2 or by an agreed Supplemental Agreement (typically based on statewide averages for the applicable work)."]
[]
[]
[]
[]
[null,"Option 1:","Calculations per Specifications Section 4-3.2"]
[]
[]
[]
[]
[null,"This option should be used when the calculations from Specifications Section 4-3.2.1 and 4-3.2.2  are used to determine the payment to the Contractor.\n\nUse the CONTRACTOR  and SUB1 through SUB10 tabs for this Option."]
[]
[]
[]
[]
[]
[null,"Option 2:","Calculations using Statewide Averages"]
[]
[]
[]
[]
[null,"This option should be used when statewide averages are used to determine payment to the Contractor.\n\nUse the SWA tabs for this Option."]

{"sheet":"Option 1","index":1,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":false,"merged":[[36,0,36,10],[37,0,37,10],[38,0,38,10],[26,0,26,10],[27,0,27,10],[33,0,33,10],[34,0,34,10],[35,0,35,10],[30,0,30,10],[31,0,31,10],[32,0,32,10],[28,0,28,10],[29,0,29,10],[12,0,12,10],[13,0,13,10],[14,0,14,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[18,0,18,10],[19,0,19,10],[20,0,20,10],[21,0,21,10],[25,0,25,10],[22,0,22,10],[23,0,23,10],[24,0,24,10],[0,0,0,10],[1,0,1,10],[7,0,7,10],[8,0,8,10],[9,0,9,10],[10,0,10,10],[11,0,11,10],[2,0,2,10],[3,0,3,10],[4,0,4,10],[5,0,5,10],[6,0,6,10]]}
[]
[]
[]
[]
["Option 1"]
["Calculations per Specifications Section 4-3.2"]
["Instructions"]
[]
["NOTE: Only the yellow cells require entry by project personnel. Tabs for Option 2 are optional."]
[]
["On the CONTRACTOR tab:"]
["Step 1: Enter the Contract and Contractor Information"]
["Step 2: Complete the LABOR AND BURDEN fields "]
["Step 3: Complete the MATERIALS AND SUPPLIES fields "]
["Step 4: Complete the EQUIPMENT fields "]
["Step 5: Enter the Bond amount "]
["Step 6: Enter in the Original Contract Amount "]
["Step 7: Enter the Original Contract Time (number of days) "]
["Step 8: Enter the Calendar of days entitlement minus 10"]
[]
["If there is any work by Subcontractor(s), complete the following on the SUB# tab(s), as appropriate:"]
["Step 9: Enter the Subcontractor Name"]
["Step 10: Complete the LABOR AND BURDEN fields "]
["Step 11: Complete the MATERIALS AND SUPPLIES fields "]
["Step 12: Complete the EQUIPMENT fields "]
["Step 13: Enter the Bond amount "]
[]
["If there is NO work by Subcontractor(s), skip to Step 14:"]
[]
["Step 14: Verify the information from the SUB# tabs transferred to the CONTRACTOR tab correctly."]
[]
["Optional:"]
["Use the SWA tab to validate the amount calculated on the CONTRACTOR tab is within reason."]
[]
["Step 15: Apply digital signature to the CONTRACTOR tab"]
["Step 16: Submit electronically as an Excel spreadsheet to the Department"]
[]
["Row Control:"]
["Select the appropriate (+) or (-) button to add or remove rows as needed."]

{"sheet":"Contractor","index":2,"n_rows":154,"n_cols":7,"rows_kept":154,"cut":false,"hidden":false,"merged":[[113,0,113,1],[113,4,113,5],[112,0,112,1],[112,4,112,5],[59,0,59,1],[59,2,59,5],[66,0,66,1],[66,2,66,5],[73,0,73,1],[73,2,73,5],[80,0,80,1],[80,2,80,5],[87,0,87,1],[87,2,87,5],[111,0,111,1],[111,4,111,5],[97,0,97,1],[97,2,97,6],[101,0,101,1],[102,0,102,1],[103,0,103,1],[0,0,0,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[1,0,1,6],[3,0,3,1],[17,0,17,1],[17,2,17,5],[45,2,45,5],[52,2,52,5],[24,0,24,1],[24,2,24,5],[31,0,31,1],[31,2,31,5],[45,0,45,1],[38,0,38,1],[38,2,38,5],[52,0,52,1],[15,0,15,6],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[7,2,7,6],[153,1,153,6],[152,1,152,6],[121,6,122,6],[122,0,122,1],[121,2,121,3],[121,4,121,5],[123,0,123,1],[147,2,147,4],[133,2,133,5],[142,3,142,5],[121,0,121,1],[124,0,124,1]]}
[]
["CONTRACTOR INFORMATION"]
[]
["FIN#:",null,null,"Contract #: ",null,"Fed Proj. #:"]
["Point of Contact (Name/Phone #):"]
["Email Address: "]
["Estimate Prepared By:"]
["Company:"]
[]
[]
[]
[]
[]
[]
[]
["******************************************************************************************************"]
[]
["CONTRACTOR",null,{"$f":"IF(C98=\"\",\"\",C98)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+G107","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+G117","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+G128","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"IF(G151=\"\",\"\",G151)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G19:G22)","v":0}]
[]
["SUB-CONTRACTOR 1",null,{"$f":"IF('Sub1'!C10=\"\",\"\",'Sub1'!C10)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub1'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+'Sub1'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub1'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub1'!G46","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G26:G29)","v":0}]
[]
["SUB-CONTRACTOR 2",null,{"$f":"IF('Sub2'!C10=\"\",\"\",'Sub2'!C10)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub2'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+'Sub2'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub2'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub2'!G46","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G33:G36)","v":0}]
[]
["SUB-CONTRACTOR 3",null,{"$f":"IF('Sub3'!C10=\"\",\"\",'Sub3'!C10)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub3'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+'Sub3'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub3'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub3'!G46","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G40:G43)","v":0}]
[]
["SUB-CONTRACTOR 4",null,{"$f":"IF('Sub4'!C10=\"\",\"\",'Sub4'!C10)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub4'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+'Sub4'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub4'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub4'!G46","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G47:G50)","v":0}]
[]
["SUB-CONTRACTOR 5",null,{"$f":"IF('Sub5'!C10=\"\",\"\",'Sub5'!C10)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub5'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+'Sub5'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub5'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub5'!G46","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G54:G57)","v":0}]
[]
["SUB-CONTRACTOR 6",null,{"$f":"IF('Sub6'!C10=\"\",\"\",'Sub6'!C10)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub6'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+'Sub6'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub6'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub6'!G46","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G61:G64)","v":0}]
[]
["SUB-CONTRACTOR 7",null,{"$f":"IF('Sub7'!C10=\"\",\"\",'Sub7'!C10)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub7'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+'Sub7'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub7'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub7'!G46","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G68:G71)","v":0}]
[]
["SUB-CONTRACTOR 8",null,{"$f":"IF('Sub8'!C10=\"\",\"\",'Sub8'!C10)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub8'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+'Sub8'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub8'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub8'!G46","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G75:G78)","v":0}]
[]
["SUB-CONTRACTOR 9",null,{"$f":"IF('Sub9'!C10=\"\",\"\",'Sub9'!C10)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub9'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"+'Sub9'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub9'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub9'!G46","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G82:G85)","v":0}]
[]
["SUB-CONTRACTOR 10",null,{"$f":"IF('Sub9'!C18=\"\",\"\",'Sub9'!C18)","v":""}]
["1)","LABOR AND BURDEN",null,null,null,null,{"$f":"+'Sub10'!G19","v":0}]
["2)","MATERIALS AND SUPPLIES",null,null,null,null,{"$f":"'Sub10'!G29","v":0}]
["3)","EQUIPMENT",null,null,null,null,{"$f":"+'Sub10'!G40","v":0}]
["4)","INDIRECT COST, EXPENSES, AND PROFIT",null,null,null,null,{"$f":"+'Sub10'!G54","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G89:G92)","v":0}]
[]
["TOTAL COST OF INCREASE, DECREASE OR ALTERATION IN THE WORK",null,null,null,null,null,{"$f":"SUM(G23,G30,G37,G44,G51,G58,G65,G72,G79,G86,G93)","v":0}]
[]
[]
["CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C103*E103)+ (F103*(C103*E103))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C104*E104)+ (F104*(C104*E104))","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G103:G104)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C113*E113","v":0}]
[null,null,null,null,null,null,{"$f":"+C114*E114","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G113:G114)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C124*D124)+(E124*F124)","v":0}]
[null,null,null,null,null,null,{"$f":"+(C125*D125)+(E125*F125)","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G124:G125)","v":0}]
[]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT (1) or (2), whichever is greater:"]
[]
[null,"a)     ","17.5% of the sum of (1), (2), & (3) above:",null,null,null,{"$f":"SUM(G107,G117,G128)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,"2.","SUBCONTRACTOR MARKUP: "]
[null,null,"Subcontractor Cost for Extra Work:",null,null,{"$f":"SUM('Sub1'!G48,'Sub2'!G48,'Sub3'!G48,'Sub4'!G48,'Sub5'!G48,'Sub6'!G48,'Sub7'!G48,'Sub8'!G48,'Sub9'!G48 )","v":0}]
[null,null,"First $50,000",0.1,null,{"$f":"IF(F136>50000,50000,F136)","v":0},{"$f":"+F137*D137","v":0}]
[null,null,"Over $50,000",0.05,null,{"$f":"+F136-F137","v":0},{"$f":"+F138*D138","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G133:G138)","v":0}]
[]
[null,"b)     ","Average overhead per day = Ds:"]
[]
[null,null,"As  =","Original Contract Amount minus Original Subcontract Amount(s)*"]
[null,null,"B  =","Original Contract Time"]
[null,null,"C  =",0.08]
[null,null,"Ds  =","As  x  C",null,null,{"$f":"IF(G143=\"\",0,(G143*D145)/G144)","v":0}]
[null,null,null,"B"]
[null,null,"Calendar days of entitlement that are in excess of the first 10 cumulative entitlement calendar days for the contract:"]
[null,null,null,null,null,null,{"$f":"IF(G146=\"\",0,G146*G148)","v":0}]
[]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"MAX(G139,G149)","v":0}]
[]
[null,"* Deduct Original Subcontract Amount(s) of subcontractor(s) performing the work."]
[null,"NOTE: If there is no subcontracted work, use the Original Contract Amount."]

{"sheet":"Sub1","index":3,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,0,6,1],[15,0,15,1],[24,0,24,1],[24,4,24,5],[35,0,35,1],[17,0,17,1],[23,0,23,1],[13,0,13,1],[6,2,6,6],[7,0,7,6],[9,0,9,1],[9,2,9,6],[33,6,34,6],[34,0,34,1],[25,0,25,1],[14,0,14,1],[0,0,0,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[25,4,25,5],[23,4,23,5],[44,2,44,5],[33,0,33,1],[33,2,33,3],[33,4,33,5],[36,0,36,1]]}
["SUBCONTRACTOR #1 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[" "]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,{"$f":"+C26*E26","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,{"$f":"+(C37*D37)+(E37*F37)","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Sub2","index":4,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,0,6,1],[14,0,14,1],[24,0,24,1],[24,4,24,5],[35,0,35,1],[17,0,17,1],[23,0,23,1],[13,0,13,1],[6,2,6,6],[7,0,7,6],[9,0,9,1],[9,2,9,6],[33,6,34,6],[34,0,34,1],[25,0,25,1],[15,0,15,1],[0,0,0,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[25,4,25,5],[23,4,23,5],[44,2,44,5],[33,0,33,1],[33,2,33,3],[33,4,33,5],[36,0,36,1]]}
["SUBCONTRACTOR #2 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[" "]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,{"$f":"+C26*E26","v":0}]
[null,null,null,null,null,"Row Control"]
[" "]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,{"$f":"+(C37*D37)+(E37*F37)","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Sub3","index":5,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[24,0,24,1],[24,4,24,5],[35,0,35,1],[6,2,6,6],[7,0,7,6],[9,0,9,1],[9,2,9,6],[6,0,6,1],[23,4,23,5],[17,0,17,1],[23,0,23,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[0,0,0,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[36,0,36,1],[44,2,44,5],[25,0,25,1],[25,4,25,5],[33,6,34,6],[34,0,34,1],[33,0,33,1],[33,2,33,3],[33,4,33,5]]}
["SUBCONTRACTOR #3 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[" "]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,{"$f":"+C26*E26","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,{"$f":"+(C37*D37)+(E37*F37)","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Sub4","index":6,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6],[23,0,23,1],[23,4,23,5],[24,0,24,1],[24,4,24,5],[5,0,5,1],[5,2,5,6],[6,0,6,1],[6,2,6,6],[7,0,7,6],[9,0,9,1],[9,2,9,6],[13,0,13,1],[14,0,14,1],[15,0,15,1],[25,0,25,1],[25,4,25,5],[44,2,44,5],[33,6,34,6],[34,0,34,1],[33,0,33,1],[33,2,33,3],[33,4,33,5],[35,0,35,1],[36,0,36,1]]}
["SUBCONTRACTOR #4 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Sub5","index":7,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6],[5,0,5,1],[5,2,5,6],[6,0,6,1],[6,2,6,6],[7,0,7,6],[23,0,23,1],[23,4,23,5],[25,0,25,1],[25,4,25,5],[9,0,9,1],[9,2,9,6],[13,0,13,1],[14,0,14,1],[24,0,24,1],[24,4,24,5],[15,0,15,1],[36,0,36,1],[44,2,44,5],[33,6,34,6],[34,0,34,1],[33,0,33,1],[33,2,33,3],[33,4,33,5],[35,0,35,1]]}
["SUBCONTRACTOR #5 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,{"$f":"+C26*E26","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,{"$f":"+(C37*D37)+(E37*F37)","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Sub6","index":8,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[35,0,35,1],[44,2,44,5],[33,0,33,1],[33,2,33,3],[33,4,33,5],[36,0,36,1],[33,6,34,6],[34,0,34,1],[13,0,13,1],[14,0,14,1],[23,0,23,1],[23,4,23,5],[24,0,24,1],[24,4,24,5],[15,0,15,1],[25,0,25,1],[25,4,25,5],[9,0,9,1],[9,2,9,6],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6],[5,0,5,1],[5,2,5,6],[6,0,6,1],[6,2,6,6],[7,0,7,6]]}
["SUBCONTRACTOR #6 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,{"$f":"+(C37*D37)+(E37*F37)","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Sub7","index":9,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[33,6,34,6],[34,0,34,1],[35,0,35,1],[44,2,44,5],[36,0,36,1],[24,0,24,1],[24,4,24,5],[33,0,33,1],[33,2,33,3],[33,4,33,5],[25,0,25,1],[25,4,25,5],[23,4,23,5],[5,0,5,1],[5,2,5,6],[6,0,6,1],[6,2,6,6],[7,0,7,6],[9,0,9,1],[9,2,9,6],[13,0,13,1],[14,0,14,1],[17,0,17,1],[23,0,23,1],[15,0,15,1],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6]]}
["SUBCONTRACTOR #7 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[" "]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,{"$f":"+C26*E26","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,{"$f":"+(C37*D37)+(E37*F37)","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Sub8","index":10,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[33,6,34,6],[34,0,34,1],[35,0,35,1],[44,2,44,5],[36,0,36,1],[24,0,24,1],[24,4,24,5],[33,0,33,1],[33,2,33,3],[33,4,33,5],[25,0,25,1],[25,4,25,5],[23,4,23,5],[5,0,5,1],[5,2,5,6],[6,0,6,1],[6,2,6,6],[7,0,7,6],[9,0,9,1],[9,2,9,6],[13,0,13,1],[14,0,14,1],[17,0,17,1],[23,0,23,1],[15,0,15,1],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6]]}
["SUBCONTRACTOR #8 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[" "]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,{"$f":"+C26*E26","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,{"$f":"+(C37*D37)+(E37*F37)","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Sub9","index":11,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[33,6,34,6],[34,0,34,1],[35,0,35,1],[44,2,44,5],[36,0,36,1],[24,0,24,1],[24,4,24,5],[33,0,33,1],[33,2,33,3],[33,4,33,5],[25,0,25,1],[25,4,25,5],[23,4,23,5],[5,0,5,1],[5,2,5,6],[6,0,6,1],[6,2,6,6],[7,0,7,6],[9,0,9,1],[9,2,9,6],[13,0,13,1],[14,0,14,1],[17,0,17,1],[23,0,23,1],[15,0,15,1],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6]]}
["SUBCONTRACTOR #9 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[" "]
[null,null,null,null,null,"TOTAL LABOR AND BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,{"$f":"+C26*E26","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,{"$f":"+(C37*D37)+(E37*F37)","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Sub10","index":12,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[24,0,24,1],[24,4,24,5],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6],[23,4,23,5],[5,0,5,1],[5,2,5,6],[6,0,6,1],[6,2,6,6],[7,0,7,6],[9,0,9,1],[9,2,9,6],[13,0,13,1],[14,0,14,1],[17,0,17,1],[23,0,23,1],[15,0,15,1],[25,0,25,1],[25,4,25,5],[33,0,33,1],[33,2,33,3],[33,4,33,5],[33,6,34,6],[34,0,34,1],[35,0,35,1],[44,2,44,5],[36,0,36,1]]}
["SUBCONTRACTOR #10 INFORMATION"]
[]
["FIN#:",null,{"$f":"IF(Contractor!C4=\"\",\"\",Contractor!C4)","v":""},"Contract #: ",{"$f":"IF(Contractor!E4=\"\",\"\",Contractor!E4)","v":""},"Fed Proj. #:",{"$f":"IF(Contractor!G4=\"\",\"\",Contractor!G4)","v":""}]
["Point of Contact (Name/Phone #):",null,{"$f":"IF(Contractor!C5=\"\",\"\",Contractor!C5)","v":""}]
["Email Address: ",null,{"$f":"IF(Contractor!C6=\"\",\"\",Contractor!C6)","v":""}]
["Estimate Prepared By:",null,{"$f":"IF(Contractor!C7=\"\",\"\",Contractor!C7)","v":""}]
["Company:",null,{"$f":"IF(Contractor!C8=\"\",\"\",Contractor!C8)","v":""}]
["********************************************************************************************"]
[]
["SUB-CONTRACTOR:"]
[]
["1)","LABOR AND BURDEN"]
[]
["LABOR",null,"TIME","UNIT","RATE","BURDEN (%)","LABOR plus BURDEN     \nSUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+(C15*E15)+ (F15*(C15*E15))","v":0}]
[null,null,null,null,null,null,{"$f":"+(C16*E16)+ (F16*(C16*E16))","v":0}]
[null,null,null,null,null,"Row Control"]
[" "]
[null,null,null,null,null,"TOTAL LABOR and BURDEN",{"$f":"SUM(G15:G16)","v":0}]
[]
[]
["2)","MATERIALS AND SUPPLIES"]
[]
["MATERIAL",null,"QTY.","UNIT","RATE",null,"SUB-TOTAL"]
[null,null,null,null,null,null,{"$f":"+C25*E25","v":0}]
[null,null,null,null,null,null,{"$f":"+C26*E26","v":0}]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL MATERIALS AND SUPPLIES",{"$f":"SUM(G25:G26)","v":0}]
[]
[]
["3)","EQUIPMENT"]
[]
["EQUIPMENT",null,"OPERATING",null,"STAND-BY / IDLE",null,"SUB-TOTAL"]
[null,null,"FHWA    Rate w/ Adjustments","HRS","Standby Rate","HRS"]
[null,null,null,null,null,null,{"$f":"+(C36*D36)+(E36*F36)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,"Row Control"]
[]
[null,null,null,null,null,"TOTAL EQUIPMENT",{"$f":"SUM(G36:G37)","v":0}]
[]
["4)","INDIRECT COST, EXPENSES, AND PROFIT"]
[]
[null,"a)     ","17.5% of the sum of a), b), & c) above:",null,null,null,{"$f":"SUM(G19,G29,G40)*17.5%","v":0}]
[null,"1. ","BOND:  For any additional bond for the additional or unforeseen work, the Contractor shall provide clear and convincing proof that the bond has actually been provided and paid for a separate bond premium for such additional or unforeseen work."]
[null,null,null,null,null,"TOTAL INDIRECT COST, EXPENSES, AND PROFIT",{"$f":"SUM(G44:G45)","v":0}]
[]
[null,null,null,null,null,"TOTAL SUBCONTRACTOR COST:",{"$f":"SUM(G19,G29,G40,G46)","v":0}]

{"sheet":"Option 2","index":13,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[35,0,35,10],[36,0,36,10],[29,0,29,10],[30,0,30,10],[31,0,31,10],[32,0,32,10],[33,0,33,10],[12,0,12,10],[13,0,13,10],[14,0,14,10],[9,0,9,10],[34,0,34,10],[6,0,6,10],[7,0,7,10],[8,0,8,10],[10,0,10,10],[11,0,11,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,0,4,10],[5,0,5,10],[37,0,37,10],[38,0,38,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[18,0,18,10],[19,0,19,10],[20,0,20,10],[21,0,21,10],[22,0,22,10],[23,0,23,10],[24,0,24,10],[25,0,25,10],[26,0,26,10],[27,0,27,10],[28,0,28,10]]}
[]
[]
[]
[]
["Option 2"]
["Calculations using Statewide Averages"]
["Instructions"]
[]
["NOTE: Only the yellow cells require entry by project personnel. Tabs for Option 1 are not required."]
[]
["On the SWA tab:"]
["Step 1: Enter the Pay Item, Description, Unit, Statewide Average, and Quantity for all applicable pay items."]
["Step 2: Enter any applicable Comments regarding the estimate"]
["Step 3: Apply digital signature to the CONTRACTOR tab"]
["Step 4: Submit electronically as an Excel spreadsheet to the Department"]
[]
[]
["Link to Historical Cost Website to obtain Statewide Averages:"]
["http://www.fdot.gov/programmanagement/Estimates/HistoricalCostInformation/HistoricalCost.shtm"]
[]
["Row Control:"]
["Select the appropriate (+) or (-) button to add or remove rows as needed."]

{"sheet":"SWA","index":14,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[16,2,16,6],[23,0,23,1],[16,0,16,1],[28,1,32,6],[20,0,20,1],[21,0,21,1],[22,0,22,1],[0,0,0,6],[2,0,2,1],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6],[5,0,5,1],[5,2,5,6],[6,0,6,1],[6,2,6,6],[25,3,25,5],[14,0,14,6]]}
["ENGINEER'S COST ESTIMATE USING STATEWIDE AVERAGES"]
[]
["FIN#:",null,null,"Contract #: ",null,"Fed Proj. #:"]
["Point of Contact (Name/Phone #):"]
["Email Address: "]
["Estimate Prepared By:"]
["Company:"]
[]
[]
[]
[]
[]
[]
[]
["******************************************************************************************************"]
[]
["Prime Contractor:"]
[]
["a)","Estimate based on Statewide Average"]
[]
["Pay Item",null,"Description","UNIT","Statewide Average","Quantity","Estimated Cost"]
[null,null,null,null,null,null,{"$f":"E22*F22","v":0}]
[null,null,null,null,null,null,{"$f":"E23*F23","v":0}]
[" ",null,null,null,null,"Row Control"]
[]
[null,null,null,"TOTAL CONTRACTOR COST:",null,null,{"$f":"SUM(G22:G23)","v":0}]
[]
[null,"Comments:"]

{"sheet":"SWA Raw Convert","index":15,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,4,3,8],[0,0,0,8]]}
["FOR INFORMATIONAL PURPOSES ONLY"]
[]
[]
["Prime Only No Sub-Contractor",null,null,null,"Prime with Sub-Contractor"]
["Statewide Average","Prime Mark-up 17.5%","Raw Cost to Prime",null,"Statewide Average","Prime Mark-up 10%","Sub Price to Prime","Sub Mark-up 17.5%","Raw Cost to Sub"]
[12,{"$f":"A6*14.8936170212766%","v":1.7872340425531921},{"$f":"A6-B6","v":10.212765957446807},null,47,{"$f":"E6*9.09090909090909%","v":4.2727272727272725},{"$f":"E6-F6","v":42.727272727272727},{"$f":"G6*14.8936170212766%","v":6.363636363636366},{"$f":"G6-H6","v":36.36363636363636}]
[48,{"$f":"A7*14.8936170212766%","v":7.1489361702127683},{"$f":"A7-B7","v":40.851063829787229},null,48,{"$f":"E7*9.09090909090909%","v":4.3636363636363633},{"$f":"E7-F7","v":43.63636363636364},{"$f":"G7*14.8936170212766%","v":6.4990328820116083},{"$f":"G7-H7","v":37.137330754352035}]
[49,7.2978723404255339,41.702127659574465,null,49,4.4545454545454541,44.545454545454547,6.6344294003868498,37.911025145067697]
[50,7.4468085106383004,42.553191489361701,null,50,4.545454545454545,45.454545454545453,6.7698259187620913,38.684719535783358]
[51,7.595744680851066,43.40425531914893,null,51,4.6363636363636358,46.363636363636367,6.9052224371373336,39.458413926499034]
[52,7.7446808510638325,44.255319148936167,null,52,4.7272727272727266,47.272727272727273,7.0406189555125751,40.232108317214696]
[53,7.8936170212765981,45.106382978723403,null,53,4.8181818181818175,48.18181818181818,7.1760154738878166,41.005802707930364]
[54,8.0425531914893647,45.957446808510639,null,54,4.9090909090909083,49.090909090909093,7.3114119922630589,41.779497098646033]
[55,8.1914893617021303,46.808510638297868,null,55,4.9999999999999991,50,7.4468085106383004,42.553191489361701]
[56,8.3404255319148959,47.659574468085104,null,56,5.0909090909090899,50.909090909090907,7.5822050290135419,43.326885880077363]

{"sheet":"Data","index":16,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[104,104]
[114,114]
[125,125]
[16,16]
[26,26]
[37,37]
[16,16]
[26,26]
[37,37]
[16,16]
[26,26]
[37,37]
[16,16]
[26,26]
[37,37]
[16,16]
[26,26]
[37,37]
[16,16]
[26,26]
[37,37]
[16,16]
[26,26]
[37,37]
[16,16]
[26,26]
[37,37]
[16,16]
[26,26]
[37,37]
[16,16]
[26,26]
[37,37]
[23,23]