{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Contract Data","Work Order","Concrete","GIS Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"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":35,"n_cols":1,"rows_kept":35,"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."]
[]
[]
["(If repair quantities and dimensions are already known, proceed to Select the Work Order Tab instructions)"]
[]
[]
["Select the tab most appropriate for the repair to be performed"]
[]
["Enter the number of mobilizations"]
[]
["Input the repair dimensions (length, width, depth,)"]
[]
["When appropriate, check the boxes associated with the characteristics of the repair"]
[]
["Choose the desired traffic control devices using the dropdown menus and enter the correct quantity"]
[]
["Choose the work adjustment factor from the dropdown menu in the bottom right"]
[]
["Select the Work Order Tab"]
[]
[]
["Check the Normal 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 Desctiption\" 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"]
[]
["Sign and submit to Work Order tab to contractor as you would a typical work order"]
[]
[]
[]
["For final quantities, enter the amounts used in the field in the \"Final Quantity\" column"]

{"sheet":"Contract Data","index":1,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Do not change these items","Fixed \nPrice","Item\nNumber","Unit",null,"Enter Contract Bid Factors Here",null,null,null,"Enter Project Job Number Here","Enter Contractor and Contract ID Here",null,null,null,""]
["18 in. Rock Base (Removal, Furnish & Place)",50,3039905,"Sq. Yd.",null,"Normal Work Adjustment Factor",null,"Each"]
["Underdrainage - 6 in. Perf Plastic Pipe w/ Geotextile",7.25,6059903,"LF",null,"Nighttime Work Adjustment Factor",null,"Each"]
["Subgrade Compaction",5.25,6131012,"Sq. Yd."]
["Type 1 or 5 Aggregate",6.5,6131013,"Sq. Yd."]
["Full Depth Saw Cuts",7.25,6131014,"LF"]
["Class A Partial Depth Repair Saw Cuts",5,6132014,"LF"]
["Dowel Bar (Drill, Furn and Install)",8,6131015,"Each",null,"Fill in Maintenance Superintendents for your District - populates cell I14 of Work Order spreadsheet"]
["Dowel Bar (Furn. & Install with Basket)",7,6131017,"Each"]
["Tie Bar (Drill, Furn and Install)",7,6131018,"Each"]
["Full Depth Repair (10 -100 sy) >12\"",195,6139905,"Sq. Yd."]
["Full Depth Repair (10 -100 sy) <12\"",185,6139905,"Sq. Yd."]
["Full Depth Repair (100.1 - 500 sy) >12\"",125,6139905,"Sq. Yd.",null,"Used in picklist - Do Not Delete",null,null,"Direction (N, S, E, W)",null,"SELECT"]
["Full Depth Repair (100.1 - 500 sy) <12\"",120,6139905,"Sq. Yd.",null,"Yes",null,null,null,null,"N"]
["Full Depth Repair (>500 sy) <12\"",105,6139905,"Sq. Yd.",null,"No",null,null,null,null,"S"]
["Full Depth Repair (>500 sy) >12\"",110,6139905,"Sq. Yd.",null,"Enter Counties Here",null,null,null,null,"E"]
["Removal of Concrete Material for Partial Depth Repair (0-200 sy)",110,6139905,"Sq. Yd.",null,null,null,null,null,null,"W"]
["Removal of Concrete Material for Partial Depth Repair (> 200 sy)",90,6139905,"Sq. Yd.",null,null,null,null,null,null,"Both"]
["Furnish/Placing Material for Partial Depth Repair (0-50 cy)",525,6139907,"Cu. Yd."]
["Furnish/Placing Material for Partial Depth Repair (> 50 cy)",425,6139907,"Cu. Yd."]
["Slab Jacking Material High Density Polyurethane",5.25,6252003,"LB"]
["Bridge Deck Approach Slab Repair (Full Depth)",40,7049904,"Sq. Ft."]
["Bridge Deck Approach Slab Repair (Partial Depth) (Over 200 SF)",35,7049904,"Sq. Ft."]
["Bridge Deck Approach Slab Repair (Partial Depth) (0-200 SF)",70,7049904,"Sq. Ft."]
["Construction Signs (SF)",3,6161005,"Sq. Ft."]
["Channelizer (Trim Line)",9,6161025,"Each"]
["Type III Moveable Barricade",75,6161030,"Each"]
["Directional Indicator Barricade",18.75,6161033,"Each"]
["Flashing Arrow Panel",390,6161040,"Each"]
["Sequential Flashing Warning Light",50,6161055,"Each"]
["CMS, contractor Furnished/Retained",1200,6161098,"Each"]
["Single Lane Closure",3000,6169902,"Each"]
["Double Lane Closure",3900,6169902,"Each"]
["Interior Lane Closure",3900,6169902,"Each"]
["Triple Lane Closure",4500,6169902,"Each"]
["Ramp Closure",1800,6169902,"Each"]
["One-Lane Two-Way Operation with Flagger",3000,6169902,"Each"]
["Truck or Trailer Mounted Attenuator (TMA)",750,"6123000A","Each"]
["Mobilization - Full Depth Repair",4800,6189902,"Each"]
[]
[" "]

{"sheet":"Work Order","index":2,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,2,76,9],[74,1,75,1],[74,2,74,3],[74,4,74,6],[74,7,74,9],[75,2,75,3],[75,4,75,6],[75,7,75,9],[69,5,69,7],[71,2,71,3],[71,4,71,6],[71,7,71,9],[72,1,73,1],[72,2,72,3],[72,4,72,6],[72,7,72,9],[73,2,73,3],[73,4,73,6],[73,7,73,9],[5,1,5,9],[11,6,11,7],[9,1,9,2],[0,1,0,9],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[6,6,6,7],[7,6,7,7],[8,6,8,7],[8,1,8,2],[7,1,7,2],[6,8,6,9],[7,8,7,9],[8,8,8,9],[14,6,14,7],[10,8,10,9],[14,8,14,9],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[10,1,10,2],[11,8,11,9],[13,8,13,9],[10,6,10,7],[13,6,13,7],[6,1,6,2],[43,1,43,2],[44,1,44,2],[47,1,47,2],[42,1,42,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[20,1,22,9],[15,1,15,2],[23,1,23,2],[41,1,41,2],[40,1,40,2],[35,1,35,2],[64,2,64,3],[66,2,66,3],[65,2,65,3],[51,1,51,2],[50,1,50,2],[55,1,55,9],[58,5,58,6],[59,5,59,6],[16,1,16,2],[17,1,17,2],[60,5,60,6],[63,2,63,3],[36,1,36,2],[48,1,48,2],[24,1,24,2],[27,1,27,2],[19,1,19,3],[49,1,49,2],[52,1,52,2],[62,1,62,2],[37,1,37,2],[38,1,38,2],[39,1,39,2]]}
[null,"Missouri Department of Transportation"]
[null,"2022 Concrete Pavement Repair Job Order",null,false]
[null,{"$f":"'[1]Contract Data'!M2","v":0}]
[null,{"$f":"IF(B3>0,VLOOKUP(B3,'Contract Data'!J2:K6,2,FALSE),\"\")","v":""}]
[]
[null,"  Actual amount paid to contractor will be determined by field measured quantities."]
[null,"Work Order Number",null,null,null,null,"Confirm Receipt"]
[null,"Work Order Issued",null,null,null,null,"Start of Repair Work"]
[null,"Notice to Proceed",null,null,null,null,"Repairs Completed"]
[null,"To be completed by"]
[null,"Acceptance for Maintenance",null,null,null,null,"Mix ID"]
[null,"Route",null,null,"`",null,"Plant Location"]
[null,"County","County"]
[null,"Direction","Direction",null,null,null,"Maintenance Supervisor"]
[null,"Milemarker","Mile Marker",null," ",null," WZ Law Enforcement?"]
[null,"Working Hour Restrictions"]
[null,null,null,null,null,null,null,null,"Normal","Nighttime"]
[null,null,null,null,null,null,null,null,false,false]
[]
[null,"Location and Description of Repair(s):  "]
[null,"Concrete Pavement Repair:"]
[]
[]
[null,null,null,null,"Unit of","Estimated","Final","Fixed *","Estimated","Final "]
[null,"Item Code",null,"Pay Item Description","Measure","Quantity","Quantity","Unit Price"," Price","Price"]
[]
[null,null,null,"MOBILIZATION"]
[null,{"$f":"IF(D28>0,VLOOKUP('Work Order'!D28,'Contract Data'!$A$39:$C$39,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$2:$D$39,4,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$2:$D$39,4,FALSE))","v":""},null,null,{"$f":"IF(D28>0,VLOOKUP(D28,'Contract Data'!$A$39:$C$40,2,FALSE),0)","v":0},{"$f":"IF(F28=\"\",0,F28*H28)","v":0},{"$f":"G28*H28","v":0}]
[null,null,null,null,null,null,null,"Mobilization Subtotal",{"$f":"SUM(I28:I28)","v":0},{"$f":"SUM(J28:J28)","v":0}]
[null,null,null,"PAVING/PAVEMENT REPAIR"]
[null,{"$f":"IF(D31>0,VLOOKUP('Work Order'!D31,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,null,null,null,{"$f":"IF(D31>0,VLOOKUP(D31,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},{"$f":"F31*H31","v":0},{"$f":"G31*H31","v":0}]
[null,{"$f":"IF(D32>0,VLOOKUP('Work Order'!D32,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D32>0,VLOOKUP(D32,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},{"$f":"F32*H32","v":0},0]
[null,{"$f":"IF(D33>0,VLOOKUP('Work Order'!D33,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D34>0,VLOOKUP('Work Order'!D34,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D35>0,VLOOKUP('Work Order'!D35,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D36>0,VLOOKUP('Work Order'!D36,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D37>0,VLOOKUP('Work Order'!D37,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D37>0,VLOOKUP(D37,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D38>0,VLOOKUP('Work Order'!D38,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},{"$f":"F38*H38","v":0},{"$f":"G38*H38","v":0}]
[null,{"$f":"IF(D39>0,VLOOKUP('Work Order'!D39,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D40>0,VLOOKUP('Work Order'!D40,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D41>0,VLOOKUP('Work Order'!D41,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D42>0,VLOOKUP('Work Order'!D42,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},{"$f":"F42*H42","v":0},{"$f":"G42*H42","v":0}]
[null,{"$f":"IF(D43>0,VLOOKUP('Work Order'!D43,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D44>0,VLOOKUP('Work Order'!D44,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D45>0,VLOOKUP('Work Order'!D45,'Contract Data'!$A$2:$C$24,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$2:$B$24,2,FALSE),0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$2:$D$38,5,FALSE),\" \")","v":" "},null,null,"Paving Subtotal",{"$f":"SUM(I31:I45)","v":0},{"$f":"SUM(J31:J45)","v":0}]
[null,null,null,"TRAFFIC CONTROL"]
[null,{"$f":"IF(D48>0,VLOOKUP(D48,'Contract Data'!$A$25:$C$38,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D48>0,VLOOKUP(D48,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},{"$f":"F48*H48","v":0},{"$f":"G48*H48","v":0}]
[null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$25:$C$38,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},{"$f":"F49*H49","v":0},0]
[null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$25:$C$38,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D50,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D50,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$25:$C$38,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D51,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D51,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$25:$C$38,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D52,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D52,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},{"$f":"F52*H52","v":0},0]
[null,{"$f":"IF(D53>0,VLOOKUP(D53,'Contract Data'!$A$25:$C$38,3,FALSE),\"\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D53,'Contract Data'!$A$2:$D$38,4,FALSE)),\"\",VLOOKUP(D53,'Contract Data'!$A$2:$D$38,4,FALSE))","v":""},null,null,{"$f":"IF(D53>0,VLOOKUP(D53,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0,0]
[null,null,null,null,null,null,null,"Traffic Control Subtotal",{"$f":"SUM(I48:I53)","v":0},{"$f":"SUM(J48:J53)","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"SUM(I29+I46+I54)","v":0},{"$f":"SUM(J29+J46+J54)","v":0},"Enter into AWP in the Quantity Field for the Correct Line"]
[]
[null,null,null,"Adjustment Factors","Factor","Estimated Subtotal",null,"Final Subtotal","Est. Adj.\nSubtotal","Final Adj.\nSubtotal"]
[null,null,null,{"$f":"'Contract Data'!F2","v":"Normal Work Adjustment Factor"},{"$f":"IF(I18=TRUE(),'Contract Data'!G2,)","v":0},{"$f":"$I$57","v":0},null,{"$f":"$J$57","v":0},{"$f":"IF(E60=\"\",0,E60*F60)","v":0},{"$f":"IF(E60=\"\",0,E60*H60)","v":0}]
[null,null,null,{"$f":"'Contract Data'!F3","v":"Nighttime Work Adjustment Factor"},{"$f":"IF(J18=TRUE(),'Contract Data'!G3,)","v":0},{"$f":"$I$57","v":0},null,{"$f":"$J$57","v":0},{"$f":"IF(E61=\"\",0,E61*F61)","v":0},{"$f":"IF(E61=\"\",0,E61*H61)","v":0}]
[null,null,null,null,null,null,null,"Adjusted Subtotal",{"$f":"SUM(I60:I61)","v":0},{"$f":"SUM(J60:J61)","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":"F65*H65","v":0},{"$f":"G65*H65","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F66*H66","v":0},{"$f":"G66*H66","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F67*H67","v":0},{"$f":"G67*H67","v":0}]
[null,null,null,null,null,null,null,"Contingent Items Subtotal",{"$f":"SUM(I65:I67)","v":0},{"$f":"SUM(J65:J67)","v":0}]
[]
[null,null,null,null,null,"  Total Job Price",null,null,{"$f":"SUM(I62+I68)","v":0},{"$f":"SUM(J62+J68)","v":0}]
[]
[null,null,"Signature",null,"Title",null,null,"Date"]
[null,"Work Order Issued & Notice to Proceed:","                                          MoDOT",null,"Resident Engineer"]
[null,null,"Contractor"]
[null,"Final Inspection /   Acceptance:","                                        MoDOT",null,"Resident Engineer"]
[null,null,"Contractor"]
[null,"Final Inspection Comments:"]

{"sheet":"Concrete","index":3,"n_rows":58,"n_cols":25,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"# of Mobilizations:"]
[]
["Log Mile","Lane (Driving/Passing)","Depth (in.)","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","Dowel Bars in Baskets","Tie Bars","Saw Cuts",null,"Quantity","Traffic Control","Price","TC Total"]
[null,null,null,false,false,null,null,null,null,{"$f":"G5*H5","v":0},{"$f":"IF(AND(C5<12,C5>0),J5/9,0)","v":0},{"$f":"IF(OR(C5>12,C5=12),J5/9,0)","v":0},{"$f":"IF(D5=TRUE,J5/9,0)","v":0},{"$f":"IF(E5=TRUE,J5/9,0)","v":0},{"$f":"IF(F5=TRUE,J5/9,0)","v":0},{"$f":"IF(H5<8,2*H5,IF(H5<12,20,IF(OR(H5<24,H5=12),(H5-12)*2+20,IF(OR(H5<36,H5=24),(H5-24)*2+40,IF(OR(H5<48,H5=36),(H5-36)*2+60,H5*2)))))","v":0},{"$f":"IF(OR(G5>30,G5=30),(INT(G5/15)-1)*H5,0)","v":0},{"$f":"IF(OR(G5>30,G5=30),INT(G5/2.5)*2,0)","v":0},null,null,null,null,{"$f":"IF(V5>0,VLOOKUP(V5,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},{"$f":"W5*U5","v":0}]
[null,null,null,null,false,false,null,null,null,{"$f":"G6*H6","v":0},{"$f":"IF(AND(C6<12,C6>0),J6/9,0)","v":0},{"$f":"IF(OR(C6>12,C6=12),J6/9,0)","v":0},{"$f":"IF(D6=TRUE,J6/9,0)","v":0},{"$f":"IF(E6=TRUE,J6/9,0)","v":0},{"$f":"IF(F6=TRUE,J6/9,0)","v":0},{"$f":"IF(H6<8,2*H6,IF(H6<12,20,IF(OR(H6<24,H6=12),(H6-12)*2+20,IF(OR(H6<36,H6=24),(H6-24)*2+40,IF(OR(H6<48,H6=36),(H6-36)*2+60,H6*2)))))","v":0},{"$f":"IF(OR(G6>30,G6=30),(INT(G6/15)-1)*H6,0)","v":0},{"$f":"IF(OR(G6>30,G6=30),INT(G6/2.5)*2,0)","v":0},null,null,null,null,{"$f":"IF(V6>0,VLOOKUP(V6,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},{"$f":"W6*U6","v":0}]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V7>0,VLOOKUP(V7,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V8>0,VLOOKUP(V8,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V9>0,VLOOKUP(V9,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V10>0,VLOOKUP(V10,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V11>0,VLOOKUP(V11,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V12>0,VLOOKUP(V12,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V13>0,VLOOKUP(V13,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V14>0,VLOOKUP(V14,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V15>0,VLOOKUP(V15,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V16>0,VLOOKUP(V16,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V17>0,VLOOKUP(V17,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V18>0,VLOOKUP(V18,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V19>0,VLOOKUP(V19,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},{"$f":"W19*U19","v":0}]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V20>0,VLOOKUP(V20,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V21>0,VLOOKUP(V21,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V22>0,VLOOKUP(V22,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V23>0,VLOOKUP(V23,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V24>0,VLOOKUP(V24,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V25>0,VLOOKUP(V25,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V26>0,VLOOKUP(V26,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V27>0,VLOOKUP(V27,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V28>0,VLOOKUP(V28,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V29>0,VLOOKUP(V29,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V30>0,VLOOKUP(V30,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V31>0,VLOOKUP(V31,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V32>0,VLOOKUP(V32,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V33>0,VLOOKUP(V33,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V34>0,VLOOKUP(V34,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V35>0,VLOOKUP(V35,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V36>0,VLOOKUP(V36,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V37>0,VLOOKUP(V37,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V38>0,VLOOKUP(V38,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V39>0,VLOOKUP(V39,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V40>0,VLOOKUP(V40,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V41>0,VLOOKUP(V41,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V42>0,VLOOKUP(V42,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V43>0,VLOOKUP(V43,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V44>0,VLOOKUP(V44,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V45>0,VLOOKUP(V45,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V46>0,VLOOKUP(V46,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V47>0,VLOOKUP(V47,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V48>0,VLOOKUP(V48,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V49>0,VLOOKUP(V49,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V50>0,VLOOKUP(V50,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V51>0,VLOOKUP(V51,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V52>0,VLOOKUP(V52,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V53>0,VLOOKUP(V53,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V54>0,VLOOKUP(V54,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,null,null,null,false,false,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(V55>0,VLOOKUP(V55,'Contract Data'!$A$25:$B$38,2,FALSE),0)","v":0},0]
[null,"Total",null,null,null,null,{"$f":"SUM(G5:G55)","v":0},{"$f":"SUM(H5:H55)","v":0},{"$f":"SUM(I5:I55)","v":0},{"$f":"SUM(J5:J55)","v":0},{"$f":"ROUND(SUM(K5:K55),1)","v":0},{"$f":"ROUND(SUM(L5:L55),1)","v":0},{"$f":"ROUND(SUM(M5:M55),0)","v":0},{"$f":"ROUND(SUM(N5:N55),0)","v":0},{"$f":"ROUND(SUM(O5:O55),0)","v":0},{"$f":"SUM(P5:P55)","v":0},0,0,0]
[null,"Total $",null,null,null,null,null,null,{"$f":"I56*'Contract Data'!B3","v":0},null,{"$f":"IF(OR(K56<500,K56=500),IF(AND(100.1<K56,K56<500,OR(100.1,500)),K56*'Contract Data'!B14,IF(AND(K56<100,K56>10,OR(10,100)),K56*'Contract Data'!B12,0)),K56*'Contract Data'!B15)","v":0},{"$f":"IF(OR(L56<500,L56=500),IF(AND(100.1<L56,L56<500,OR(100.1,500)),L56*'Contract Data'!B13,IF(AND(L56<100,L56>10,OR(10,100)),L56*'Contract Data'!B11,0)),L56*'Contract Data'!B16)","v":0},{"$f":"M56*'Contract Data'!B4","v":0},{"$f":"N56*'Contract Data'!B5","v":0},{"$f":"O56*'Contract Data'!B2","v":0},{"$f":"P56*'Contract Data'!B8","v":0},{"$f":"Q56*'Contract Data'!B9","v":0},{"$f":"R56*'Contract Data'!B10","v":0},{"$f":"S56*'Contract Data'!B6","v":0},null,null,null,null,{"$f":"SUM(X5:X18)","v":0},{"$f":"SUM(X57,S57,R57,Q57,P57,O57,N57,M57,L57,K57,I57)+(G2*'Contract Data'!B39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment Factor:","Normal Work Adjustment Factor",{"$f":"IF(W58>0,VLOOKUP(W58,'Contract Data'!$F$2:$G$4,2,FALSE),0)","v":0},{"$f":"X58*Y57+IF(J2=TRUE,'Contract Data'!#REF!,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:"]