{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Contract Data","Concrete Pavement Rep Job Order","Concrete","GIS Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["(If using spreadshseet tab for the first time, Click on the \"Contract Data\" Tab to fill out specific contract data)"]
["Remove and/or fill out any of the highlighted areas in order to set this up for YOUR contract.  You may need to scroll over to see this information."]
[]
["Utilize the Concrete tab to determine quanities for the pavement repairs."]
[]
["Select Contract Data Tab."]
[]
["Enter the work adjustment factor from the Contract."]
[]
["Enter the contract specific information from the Contract."]
[]
["Create a list of the counties included in the contract."]
[]
[]
["Select the Concrete Pavement Rep Job Order Tab"]
[]
["Check the Daytime or Nighttime box at the top of the page"]
[]
["Fill in the shaded cells manually, note some utilize dropdown menus"]
[]
["Select the correct pay item utilizing the dropdown menus in the \"Pay Item Description\" column note this will auto populate other cells"]
[]
["Using the calculated quantities from previous tabs or manual calculations, enter the quantities in the \"Estimated Quantities\" column"]
[]
["For final quantities, enter the amounts used in the field in the \"Final Quantity\" column.  MoDOT Signature is only REQUIRED on the final PDF version of the job order."]

{"sheet":"Contract Data","index":1,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Do not change these items","Fixed \nPrice","Item\nNumber","Unit",null,"Enter Contract Bid Factor Here",null,null,null,null,null,null,"Enter Contract Specific Information Here",""]
["MISC. 18 IN. ROCK BASE (REMOVAL, FURNISH & PLACE)",50,3039905,"SY",null,"Adjustment Factor",null,null,null,null,"Each",null,"Job Number"]
["MISC. UNDERDRAINAGE 6 IN. PERF. PLASTIC PIPE W/GEOTEXTILE",7.25,6059903,"LF",null,null,null,null,null,null,null,null,"Contract ID"]
["SUBGRADE COMPACTION",5.25,6131012,"SY",null,null,null,null,null,null,null,null,"Contractor"]
["TYPE 1 OR 5 AGGREGATE",6.5,6131013,"SY",null,null,null,null,null,null,null,null,"Contractor Phone Number"]
["FULL DEPTH SAW CUTS",9.5,6131014,"LF",null,"Direction (N, S, E, W)",null,"SELECT"]
["DOWEL BAR (DRILL, FURN. & INSTALL)",10.5,6131015,"EA ",null,null,null,"N"]
["DOWEL BAR (FURN. & INSTALL W/ BASKET)",9,6131017,"EA ",null,null,null,"S"]
["TIE BAR (DRILL, FURN. & INSTALL)",9,6131018,"EA ",null,null,null,"E"]
["CLASS A PARTIAL DEPTH REPAIR SAW CUTS",5,6132014,"LF",null,null,null,"W"]
["MISC. FULL DEPTH REPAIR (10 -100 SY) > 12\"",235,6139905,"SY"]
["MISC. FULL DEPTH REPAIR (10 -100 SY) ≤ 12\"",220,6139905,"SY",null,"County:"]
["MISC. FULL DEPTH REPAIR (100.1 - 500 SY) > 12\"",150,6139905,"SY",null,"SELECT"]
["MISC. FULL DEPTH REPAIR (100.1 - 500 SY) ≤ 12\"",145,6139905,"SY"]
["MISC. FULL DEPTH REPAIR (> 500 SY) ≤ 12\"",125,6139905,"SY"]
["MISC. FULL DEPTH REPAIR (> 500 SY) > 12\"",130,6139905,"SY"]
["MISC. REMOVAL OF CONCRETE MATERIAL FOR PARTIAL DEPTH  REPAIR (0-200 SY)",110,6139905,"SY"]
["MISC. REMOVAL OF CONCRETE MATERIAL FOR PARTIAL DEPTH REPAIR (> 200 SY)",90,6139905,"SY"]
["MISC. FURN./PLACING MATERIAL FOR PARTIAL DEPTH REPAIR (0-50 CY)",525,6139907,"CY"]
["MISC. FURN./PLACING MATERIAL FOR PARTIAL DEPTH REPAIR (> 50 CY)",425,6139907,"CY"]
["MISC. MOBILIZATION – FULL DEPTH REPAIR",4800,6189902,"EA "]
["SLAB JACKING MATERIAL HIGH DENSITY POLYURETHANE ",5.25,6252003,"LB"]
["MISC. BRIDGE DECK APPROACH SLAB REPAIR (FULL DEPTH)",40,7049904,"SF"]
["MISC. BRIDGE DECK APPROACH SLAB REPAIR (PARTIAL DEPTH) (OVER 200 SF)",35,7049904,"SF"]
["MISC. BRIDGE DECK APPROACH SLAB REPAIR (PARTIAL DEPTH) (0-200 SF)",70,7049904,"SF"]
[]
["MISC. Traffic Control Items"]
["MISC. ADDITIONAL TRUCK MOUNTED ATTENUATOR (TMA)",750,"6123000A","EA "]
["MISC. ADDITIONAL CONSTRUCTION SIGNS",3,6169904,"SF"]
["MISC. ADDITIONAL CHANNELIZER (TRIMLINE)",9,6169902,"EA "]
["MISC. ADDITIONAL TYPE III MOVEABLE BARRICADE ",75,6169902,"EA "]
["MISC. ADDITIONAL DIRECTIONAL INDICATOR BARRICADE",18.75,6169902,"EA "]
["MISC. ADDITIONAL FLASHING ARROW PANEL",390,6169902,"EA "]
["MISC. SEQUENTIAL FLASHING WARNING LIGHT",50,6169902,"EA "]
["MISC. ADDITIONAL CMS (CONTRACTOR FURNISHED/RETAINED) ",1200,6169902,"EA "]
["MISC. SINGLE LANE CLOSURE ",3000,6169902,"EA "]
["MISC. DOUBLE LANE CLOSURE ",3900,6169902,"EA "]
["MISC. INTERIOR LANE CLOSURE",3900,6169902,"EA "]
["MISC. TEMPORARY TRAFFIC CONTROL SINGLE LANE SHIFT",1000,6169902,"EA "]
["MISC. TRIPLE LANE CLOSURE",4500,6169902,"EA "]
["MISC. RAMP CLOSURE ",1800,6169902,"EA "]
["MISC. 1-LANE 2-WAY OPERATION W/ FLAGGERS",3000,6169902,"EA "]
[]
[]
[]
[" "]

{"sheet":"Concrete Pavement Rep Job Order","index":2,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[66,1,66,2],[66,3,66,4],[66,5,66,8],[67,1,67,2],[67,3,67,4],[67,5,67,8],[15,2,15,9],[16,2,16,9],[65,1,65,2],[65,3,65,4],[65,5,65,8],[57,2,57,3],[56,1,56,2],[38,2,38,3],[39,2,39,3],[42,2,42,3],[58,2,58,3],[60,2,60,3],[59,2,59,3],[50,1,50,9],[53,5,53,6],[54,5,54,6],[5,2,5,3],[5,8,5,9],[6,2,6,3],[10,2,10,3],[10,4,12,4],[10,5,12,6],[10,7,10,8],[11,2,11,3],[11,7,11,8],[12,2,12,3],[12,7,12,8],[3,2,3,3],[3,8,3,9],[4,2,4,3],[4,4,4,7],[4,8,4,9],[47,2,47,3],[0,1,0,9],[1,1,1,9],[6,8,6,9],[63,5,63,7],[7,2,7,3],[8,2,8,3],[20,2,20,3],[19,2,19,3],[21,2,21,3],[22,2,22,3],[24,2,24,3],[25,2,25,3],[13,1,14,1],[13,2,14,9],[26,2,26,3],[18,2,18,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3]]}
[null,"Missouri Department of Transportation"]
[null,"2026 Concrete Pavement Repair Job Order",null,false]
[]
[null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,null,null,null,"K Number (MoDOT Property Damage Number):"]
[null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,"Date of Issuance"]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,"Proposed Notice to Proceed:"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,"Completion Date:"]
[null,"Mix ID:",null,null,null,null,null,null,"Daytime","Nighttime"]
[null,"Plant Location:",null,null,null,null,null,null,false,false]
[]
[null,"County:","SELECT",null,"Location Description:",null,null,"Mile Marker:"]
[null,"Route:",null,null,null,null,null,"GPS Latitude:"]
[null,"Direction (N,S,E,W)","SELECT",null,null,null,null,"GPS Longitude:"]
[null,"Description of Work:"]
[]
[null,"Restrictions:"]
[null,"Remarks/Comments (to include any speed limit reductions and or working hour restrictions):"]
[]
[null,null,null,null,"Unit of","Estimated","Final",null,"Estimated","Final "]
[null,"Item Code","Pay Item Description",null,"Measure","Quantity","Quantity","Unit Price"," Price","Price"]
[]
[null,null,"MOBILIZATION"]
[null,{"$f":"IF(C23>0,VLOOKUP('Concrete Pavement Rep Job Order'!C23,'Contract Data'!$A$21:$C$21,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C23,'Contract Data'!$A$2:$D$43,4,FALSE)),\"\",VLOOKUP(C23,'Contract Data'!$A$2:$D$43,4,FALSE))","v":""},null,null,{"$f":"IF(C23>0,VLOOKUP(C23,'Contract Data'!$A$21:$C$45,2,FALSE),0)","v":0},{"$f":"IF(F23=\"\",0,F23*H23)","v":0},{"$f":"G23*H23","v":0}]
[null,null,null,null,null,null,null,"Mobilization Subtotal",{"$f":"SUM(I23:I23)","v":0},{"$f":"SUM(J23:J23)","v":0}]
[null,null,"PAVING/PAVEMENT REPAIR"]
[null,{"$f":"IF(C26>0,VLOOKUP('Concrete Pavement Rep Job Order'!C26,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C26>0,VLOOKUP(C26,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},{"$f":"F26*H26","v":0},{"$f":"G26*H26","v":0}]
[null,{"$f":"IF(C27>0,VLOOKUP('Concrete Pavement Rep Job Order'!C27,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C27,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C27,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C27>0,VLOOKUP(C27,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},{"$f":"F27*H27","v":0},0]
[null,{"$f":"IF(C28>0,VLOOKUP('Concrete Pavement Rep Job Order'!C28,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C28,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C28,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C28>0,VLOOKUP(C28,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C29>0,VLOOKUP('Concrete Pavement Rep Job Order'!C29,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C29,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C29,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C29>0,VLOOKUP(C29,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C30>0,VLOOKUP('Concrete Pavement Rep Job Order'!C30,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C30,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C30,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C30>0,VLOOKUP(C30,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C31>0,VLOOKUP('Concrete Pavement Rep Job Order'!C31,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C31,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C31,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C31>0,VLOOKUP(C31,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C32>0,VLOOKUP('Concrete Pavement Rep Job Order'!C32,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C32,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C32,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C32>0,VLOOKUP(C32,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C33>0,VLOOKUP('Concrete Pavement Rep Job Order'!C33,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C33,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C33,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C33>0,VLOOKUP(C33,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},{"$f":"F33*H33","v":0},{"$f":"G33*H33","v":0}]
[null,{"$f":"IF(C34>0,VLOOKUP('Concrete Pavement Rep Job Order'!C34,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C34,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C34,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C34>0,VLOOKUP(C34,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C35>0,VLOOKUP('Concrete Pavement Rep Job Order'!C35,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C35,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C35,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C35>0,VLOOKUP(C35,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C36>0,VLOOKUP('Concrete Pavement Rep Job Order'!C36,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C36,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C36,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C36>0,VLOOKUP(C36,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C37>0,VLOOKUP('Concrete Pavement Rep Job Order'!C37,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C37,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C37,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C37>0,VLOOKUP(C37,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},{"$f":"F37*H37","v":0},{"$f":"G37*H37","v":0}]
[null,{"$f":"IF(C38>0,VLOOKUP('Concrete Pavement Rep Job Order'!C38,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C38,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C38,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C38>0,VLOOKUP(C38,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C39>0,VLOOKUP('Concrete Pavement Rep Job Order'!C39,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C39,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C39,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C39>0,VLOOKUP(C39,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C40>0,VLOOKUP('Concrete Pavement Rep Job Order'!C40,'Contract Data'!$A$2:$C$25,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C40,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C40,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C40>0,VLOOKUP(C40,'Contract Data'!$A$2:$B$25,2,FALSE),0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(C41>0,VLOOKUP(C41,'Contract Data'!$A$2:$D$42,5,FALSE),\" \")","v":" "},null,null,"Paving Subtotal",{"$f":"SUM(I26:I40)","v":0},{"$f":"SUM(J26:J40)","v":0}]
[null,null,"TRAFFIC CONTROL"]
[null,{"$f":"IF(C43>0,VLOOKUP(C43,'Contract Data'!$A$29:$C$43,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C43,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C43,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C43>0,VLOOKUP(C43,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},{"$f":"F43*H43","v":0},{"$f":"G43*H43","v":0}]
[null,{"$f":"IF(C44>0,VLOOKUP(C44,'Contract Data'!$A$29:$C$43,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C44,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C44,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C44>0,VLOOKUP(C44,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},{"$f":"F44*H44","v":0},0]
[null,{"$f":"IF(C45>0,VLOOKUP(C45,'Contract Data'!$A$29:$C$43,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C45,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C45,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C45>0,VLOOKUP(C45,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C46>0,VLOOKUP(C46,'Contract Data'!$A$29:$C$43,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C46,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C46,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C46>0,VLOOKUP(C46,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(C47>0,VLOOKUP(C47,'Contract Data'!$A$29:$C$43,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C47,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C47,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C47>0,VLOOKUP(C47,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},{"$f":"F47*H47","v":0},0]
[null,{"$f":"IF(C48>0,VLOOKUP(C48,'Contract Data'!$A$29:$C$43,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(C48,'Contract Data'!$A$2:$D$42,4,FALSE)),\"\",VLOOKUP(C48,'Contract Data'!$A$2:$D$42,4,FALSE))","v":""},null,null,{"$f":"IF(C48>0,VLOOKUP(C48,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0,0]
[null,null,null,null,null,null,null,"Traffic Control Subtotal",{"$f":"SUM(I43:I48)","v":0},{"$f":"SUM(J43:J48)","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"SUM(I24+I41+I49)","v":0},{"$f":"SUM(J24+J41+J49)","v":0},"Enter into AWP in the Quantity Field for the Correct Line"]
[]
[null,null,null,"Adjustment Factor","Factor","Estimated Subtotal",null,"Final Subtotal","Est. Adj.\nSubtotal","Final Adj.\nSubtotal"]
[null,null,null,{"$f":"'Contract Data'!F2","v":"Adjustment Factor"},{"$f":"'Contract Data'!J2","v":0},{"$f":"$I$52","v":0},null,{"$f":"$J$52","v":0},{"$f":"E55*F55","v":0},{"$f":"E55*H55","v":0}]
[null,null,null,null,null,null,null,"Adjusted Subtotal",{"$f":"SUM(I55:I55)","v":0},{"$f":"SUM(J55:J55)","v":0}]
[null,"Contingent Items"]
[null,"Item","Pay Item Description",null,"Unit","Estimated Quantity","Final \nQuantity","Unit Price","Estimated \nPrice","Final Price"]
[null,null,null,null,null,null,null,null,{"$f":"F59*H59","v":0},{"$f":"G59*H59","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F60*H60","v":0},{"$f":"G60*H60","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F61*H61","v":0},{"$f":"G61*H61","v":0}]
[null,null,null,null,null,null,null,"Contingent Items Subtotal",{"$f":"SUM(I59:I61)","v":0},{"$f":"SUM(J59:J61)","v":0}]
[]
[null,null,null,null,null,"  Total Job Price",null,null,{"$f":"SUM(I56+I62)","v":0},{"$f":"SUM(J56+J62)","v":0}]
[]
[null,null,null,"Responsible Person",null,null,null,null,null,"Date"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor (type in)"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT (PDF Signature when complete)"]
[null,"NOTE:  Italicized entries are \"ONLY IF APPLICABLE\" and may remain blank if not needed."]

{"sheet":"Concrete","index":3,"n_rows":58,"n_cols":27,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"# of Mobilizations:"]
[]
["Log Mile","Lane (Passing/Driving)","Depth (in.)","Center lane (Tie Bars both sides)","Subgrade Compaction","4\" Type 1/5","18\" Base Rock","Length","Width","Underdrain LF","Area SF","Area SY <12\"","Area SY >12\"","Subgrade Compaction Total","4\" Type 1/5 Total","18\" Base Rock Total","Dowel Bars 10 per end ","Dowel Bars in Baskets","Tie Bars","Saw Cuts",null,"Quantity","Traffic Control","Price","TC Total"]
[null,null,null,false,false,false,false,null,null,null,{"$f":"H5*I5","v":0},{"$f":"IF(AND(C5<12,C5>0),K5/9,0)","v":0},{"$f":"IF(OR(C5>12,C5=12),K5/9,0)","v":0},{"$f":"IF(E5=TRUE,K5/9,0)","v":0},{"$f":"IF(F5=TRUE,K5/9,0)","v":0},{"$f":"IF(G5=TRUE,K5/9,0)","v":0},0,{"$f":"IF(OR(H5>30,H5=30),INT(H5/15)*10,0)","v":0},{"$f":"IF(OR(H5>30,H5=30),IF(D5=TRUE,INT((H5-2.5)/2.5)*2,INT((H5-2.5)/2.5)),0)","v":0},null,null,null,null,{"$f":"IF(W5>0,VLOOKUP(W5,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},{"$f":"X5*V5","v":0}]
[null,null,null,false,null,false,false,null,null,null,{"$f":"H6*I6","v":0},{"$f":"IF(AND(C6<12,C6>0),K6/9,0)","v":0},{"$f":"IF(OR(C6>12,C6=12),K6/9,0)","v":0},{"$f":"IF(E6=TRUE,K6/9,0)","v":0},{"$f":"IF(F6=TRUE,K6/9,0)","v":0},{"$f":"IF(G6=TRUE,K6/9,0)","v":0},0,{"$f":"IF(OR(H6>30,H6=30),INT(H6/15)*10,0)","v":0},{"$f":"IF(OR(H6>30,H6=30),IF(D6=TRUE,INT((H6-2.5)/2.5)*2,INT((H6-2.5)/2.5)),0)","v":0},null,null,null,null,{"$f":"IF(W6>0,VLOOKUP(W6,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},{"$f":"X6*V6","v":0}]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W7>0,VLOOKUP(W7,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W8>0,VLOOKUP(W8,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W9>0,VLOOKUP(W9,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W10>0,VLOOKUP(W10,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W11>0,VLOOKUP(W11,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W12>0,VLOOKUP(W12,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W13>0,VLOOKUP(W13,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W14>0,VLOOKUP(W14,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W15>0,VLOOKUP(W15,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W16>0,VLOOKUP(W16,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W17>0,VLOOKUP(W17,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W18>0,VLOOKUP(W18,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W19>0,VLOOKUP(W19,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},{"$f":"X19*V19","v":0}]
[null,null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W20>0,VLOOKUP(W20,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W21>0,VLOOKUP(W21,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W22>0,VLOOKUP(W22,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W23>0,VLOOKUP(W23,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W24>0,VLOOKUP(W24,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W25>0,VLOOKUP(W25,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W26>0,VLOOKUP(W26,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W27>0,VLOOKUP(W27,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W28>0,VLOOKUP(W28,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W29>0,VLOOKUP(W29,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W30>0,VLOOKUP(W30,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W31>0,VLOOKUP(W31,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W32>0,VLOOKUP(W32,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W33>0,VLOOKUP(W33,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W34>0,VLOOKUP(W34,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W35>0,VLOOKUP(W35,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W36>0,VLOOKUP(W36,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W37>0,VLOOKUP(W37,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W38>0,VLOOKUP(W38,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W39>0,VLOOKUP(W39,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W40>0,VLOOKUP(W40,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W41>0,VLOOKUP(W41,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W42>0,VLOOKUP(W42,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W43>0,VLOOKUP(W43,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W44>0,VLOOKUP(W44,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W45>0,VLOOKUP(W45,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W46>0,VLOOKUP(W46,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W47>0,VLOOKUP(W47,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W48>0,VLOOKUP(W48,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W49>0,VLOOKUP(W49,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W50>0,VLOOKUP(W50,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W51>0,VLOOKUP(W51,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W52>0,VLOOKUP(W52,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W53>0,VLOOKUP(W53,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W54>0,VLOOKUP(W54,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,null,null,false,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(W55>0,VLOOKUP(W55,'Contract Data'!$A$29:$B$43,2,FALSE),0)","v":0},0]
[null,"Total",null,null,null,null,null,{"$f":"SUM(H5:H55)","v":0},{"$f":"SUM(I5:I55)","v":0},{"$f":"SUM(J5:J55)","v":0},{"$f":"SUM(K5:K55)","v":0},{"$f":"ROUND(SUM(L5:L55),1)","v":0},{"$f":"ROUND(SUM(M5:M55),1)","v":0},{"$f":"ROUND(SUM(N5:N55),0)","v":0},{"$f":"ROUND(SUM(O5:O55),0)","v":0},{"$f":"ROUND(SUM(P5:P55),0)","v":0},{"$f":"SUM(Q5:Q55)","v":0},0,0,0]
[null,"Total $",null,null,null,null,null,null,null,{"$f":"J56*'Contract Data'!B3","v":0},null,{"$f":"IF(OR(L56<500,L56=500),IF(AND(100.1<L56,L56<500,OR(100.1,500)),L56*'Contract Data'!B14,IF(AND(L56<100,L56>10,OR(10,100)),L56*'Contract Data'!B12,0)),L56*'Contract Data'!B15)","v":0},{"$f":"IF(OR(M56<500,M56=500),IF(AND(100.1<M56,M56<500,OR(100.1,500)),M56*'Contract Data'!B13,IF(AND(M56<100,M56>10,OR(10,100)),M56*'Contract Data'!B11,0)),M56*'Contract Data'!B16)","v":0},{"$f":"N56*'Contract Data'!B4","v":0},{"$f":"O56*'Contract Data'!B5","v":0},{"$f":"P56*'Contract Data'!B2","v":0},{"$f":"Q56*'Contract Data'!B7","v":0},{"$f":"R56*'Contract Data'!B8","v":0},{"$f":"S56*'Contract Data'!B9","v":0},{"$f":"T56*'Contract Data'!B6","v":0},null,null,null,null,{"$f":"SUM(Y5:Y18)","v":0},{"$f":"SUM(Y57,T57,S57,R57,Q57,P57,O57,N57,M57,L57,J57)+(H2*'Contract Data'!B21)","v":0},"(total of all dollar values on row 57 plus the mobiltion amount from the Contract Data, Cell B21)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment Factor:",{"$f":"'Contract Data'!J2","v":0},{"$f":"Y58*Z57+IF(K2=TRUE,'Contract Data'!J2,0)","v":0}]

{"sheet":"GIS Data","index":4,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"County:",null,null,"Contractor:"]
[]
[null,false,false,false,"Inspector:"]
[]
[null,"Route:",null,null,"Concrete Supplier:"]
[]
[null,"Date:",null,null,"Base Rock Supplier:"]
[]
[null,"Lane #:",null,null,"Mix ID Used:"]
[]
[null,"MM:",null,null,"Final Cost of Repair:"]
[]
[null,"Direction:"]
[]
[null,"WO #:"]
[]
[]
[]
[null,"Pavement Thickness:"]
[]
[null,"Concrete Temperature:"]
[]
[null,"Slump:"]
[]
[null,"Air Content:"]
[]
[null,"Ambient Temp:"]
[]
[null,"Base Rock Thickness:"]
[]
[null,"Underdrain:"]
[]
[null,"Subgrade Compaction:"]
[]
[null,"# Dowel Bars:"]
[]
[null,"# Tie Bars"]
[]
[null,"LF Saw Cuts:"]