{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":109,"n_cols":11,"rows_kept":109,"cut":false,"hidden":false,"merged":[[108,3,108,6],[66,4,66,10],[94,7,94,10],[50,1,50,7],[46,1,46,7],[47,1,47,7],[49,1,49,7],[64,4,64,5],[51,1,51,7],[75,7,75,10],[3,4,3,5],[4,4,4,10],[48,1,48,7],[34,1,34,6],[42,1,42,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[6,2,6,10],[35,1,35,6],[40,1,40,10],[30,1,30,6],[31,1,31,6],[32,1,32,6],[33,1,33,6],[27,1,27,6],[26,1,26,6],[70,7,70,10],[71,7,71,8],[72,7,72,8],[105,3,105,10],[28,1,28,6],[29,1,29,6],[64,9,64,10]]}
[null,null,null,null,null,null,"INDIANA DEPARTMENT OF TRANSPORTATION\n"]
[null,null,null,null,null,null,"Change Order Cost Analysis Worksheet"]
[]
[null,null,null,"Contract Number: ",null,null,null,null,"Change Order Number:"]
[null,null,null,"Change Order Description:"]
[]
[null,"LABOR","Classification Codes: L=Laborer, O=Operator, F=Foreman, C=Carpenter/Pile Driver, T=Teamster, I=Iron Worker (Add Sub Categorization as necessary)\nHourly Rate Codes: ST=Straight Time, OT = Overtime (1.5*ST), DT=Double Time (2*ST)"]
[null,"Class","Quantity for Class (EA)","ST\nHours","OT\nHours","DT\nHours","ST Hourly Rate ($)","Fringes \nper Hour ($)","Total Wages for Insurance Calc.","Fringe\nCost","Hourly Payroll\n Cost"]
[null,null,null,null,null,null,null,null,{"$f":"G9*C9*(D9+E9+F9)","v":0},{"$f":"C9*H9*(D9+E9+F9)","v":0},{"$f":"C9*G9*(D9+(E9*1.5)+(F9*2))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G10*C10*(D10+E10+F10)","v":0},{"$f":"C10*H10*(D10+E10+F10)","v":0},{"$f":"C10*G10*(D10+(E10*1.5)+(F10*2))","v":0}]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,"Totals:",{"$f":"ROUND(SUM(I9:I17),2)","v":0},{"$f":"ROUND(SUM(J9:J17),2)","v":0},{"$f":"ROUND(SUM(K9:K17),2)","v":0}]
[null,null,null,null,null,null,null,null,"Estimated Insurance (Worker's Compensation and Liability Cost) = ",0.1,{"$f":"ROUND(I18*J19,2)","v":0}]
[null,null,null,null,null,null,null,null,"Estimated Tax (Federal Unemployment, State Unemployment, Federal SS) = ",0.14000000000000001,{"$f":"ROUND(K18*J20,2)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Fringe Cost =",{"$f":"J18","v":0}]
[null,null,null,null,null,null,null,null,null,"Labor Subtotal =",{"$f":"SUM(K18:K21)","v":0}]
[null,null,null,null,null,null,null,null,"Labor Markup = ",0.2,{"$f":"ROUND(K22*J23,2)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Estimated Labor Cost =",{"$f":"SUM(K22:K23)","v":0}]
[]
[null,"MATERIAL (Consider Some Overrun in Material Quantities)"]
[null,"Material\nDescription",null,null,null,null,null,"Unit\n of Measure","Material \nQuantity","Material\nUnit Cost ($)","Material\nCost"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I28*J28","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I29*J29","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Materials Subtotal = ",{"$f":"ROUND(SUM(K28:K36),2)","v":0}]
[null,null,null,null,null,null,null,null,"Materials Markups = ",0.12,{"$f":"ROUND(K37*J38,2)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Estimated Material Cost = ",{"$f":"SUM(K37:K38)","v":0}]
[]
[null,"EQUIPMENT (Utilize the current Rental Rate Blue Book as published by Equipment Watch®) (FHWA Hourly Rate = FHWA Monthly Rate / 176)                        "]
[null,null,"  https:/app.equipmentwatch.com/search     (must be connected to the network)"]
[null,"Equipment Description\n(include Make, Model, Year, Attachments)",null,null,null,null,null,null,"Equipment\nHours","Equipment Hourly Rate ($)","Equipment\nCost"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J44*I44","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J45*I45","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Equipment Subtotal = ",{"$f":"ROUND(SUM(K44:K52),2)","v":0}]
[null,null,null,null,null,null,null,null,"Equipment Markups = ",0.12,{"$f":"ROUND(K53*J54,2)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Estimated Equipment Cost = ",{"$f":"SUM(K53:K54)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total Estimated Labor, Material and Equipment Cost =",{"$f":"K24+K39+K55","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Contract Number: ",{"$f":"IF(E4=\"\",\"\",E4)","v":""},null,null,null,"Change Order Number:",{"$f":"IF(J4=\"\",\"\",J4)","v":""}]
[]
[null,null,null,"Change Order Description:",{"$f":"IF(E5=\"\",\"\",E5)","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,"SUBCONTRACTING"]
[null,null,null,null,null,null,null,"Total Dollars of Sub-contracted Work",null,"7% of                   Sub-contracted Amount","Total                            Sub-contracting          Cost"]
[null,null,null,null,null,null,null,null,null,{"$f":"0.07*(H73)","v":0},{"$f":"ROUND((H73+J73),2)","v":0}]
[]
[]
[null,null,null,null,null,null,null,"TOTAL ESTIMATED CHANGE ORDER COST"]
[null,null,null,null,null,null,null,null,null,"Total Estimated Labor, Material and Equipment Cost (from page 1) =",{"$f":"ROUND(K58,2)","v":0}]
[null,null,null,null,null,null,null,null,"Bond Cost = ",0.01,{"$f":"(K73+K77)*J78","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Estimated Change Order Cost = ",{"$f":"SUM(K73+K77+K78)","v":0}]
[]
[]
[]
[null,null,null,null,"Explanation of Circumstances/Situations Affecting Cost Calculations:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(K92<>0,IF(OR(J4=\"\",E4=\"\"),\"Contract and Change Order numbers MUST be filed\",\"\"))","v":false}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Prepared by:"]
[]
[]
[null,null,"Date:"]