{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Contract Data","Bridge Job Order","Unit Calculator","GIS Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":22,"n_cols":1,"rows_kept":22,"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.  "]
[]
[]
["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 Bridge 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":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,1,3],[19,0,19,3]]}
["Do not change these items",null,null,null,null,"Enter Contract Bid Factor Here",null,null,null,null,null,null,"Enter Contract Specific Information Here",""]
["ALL",null,null,null,null,"Adjustment Factor",null,null,null,null,"Each",null,"Job Number"]
["MISC. TRAFFIC CONTROL ITEMS",null,null,null,null,null,null,null,null,null,null,null,"Contract ID"]
["Misc. Additional Truck or Trailer Mounted Attenuator (TMA)",750,6169902,"EA",null,null,null,null,null,null,null,null,"Contractor"]
["Misc. Additional Construction Signs (SF)",3,6169904,"SF",null,null,null,null,null,null,null,null,"Contractor Phone Number"]
["Misc. Additional Channelizer (Trim Line)",9,6169902,"EA",null,"Direction (N, S, E, W)",null,"SELECT"]
["Misc. Additional Type III Moveable Barricade",75,6169902,"EA",null,null,null,"N"]
["Misc. Additional Directional Indicator Barricade",18.75,6169902,"EA",null,null,null,"S"]
["Misc. Additional Flashing Arrow Panel",390,6169902,"EA",null,null,null,"E"]
["Misc. Sequential Flashing Warning Light",50,6169902,"EA",null,null,null,"W"]
["Misc. CMS, contractor Furnished/Retained",1200,6169902,"EA"]
["Misc. Single Lane Closure",2000,6169902,"EA",null,"County:"]
["Misc. Double Lane Closure",2750,6169902,"EA",null,"SELECT"]
["Misc. Interior Lane Closure",2750,6169902,"EA"]
["Misc. Triple Lane Closure",3000,6169902,"EA"]
["Misc. Ramp Closure",1500,6169902,"EA"]
["Misc. Reset Traffic Control",1000,6169902,"EA"]
["Misc. 1-Lane 2-Way Operation w/ Flaggers",3000,6169902,"EA"]
[]
["BRIDGE"]
["BRIDGE REPAIR ITEMS"]
["Removal of Existing Expansion Joint Silicone Sealant",35,2169903,"LF"]
["Removal of Existing Expansion Joint Compression Seal",52,2169903,"LF"]
["Asphaltic Concrete Overlay Repair",12,4019904,"SF"]
["Seal Coat, Grade A",4,4094000,"SY"]
["Seal Coat, Grade B",4,4094010,"SY"]
["Polymer Concrete",300,6234000,"CF"]
["Substructure Repair (Formed)",178,7040101,"SF"]
["Cleaning and Epoxy Coating",8,7040113,"SF"]
["Misc. Type A / Type B Conc Barrier (Roadway) (<10 Ft) ",275,6179903,"LF"]
["Misc. Type A / Type B Conc Barrier (Roadway) (≥10 Ft) ",225,6179903,"LF"]
["Misc. Type C / Type D Conc Barrier (Roadway) (<10 Ft) ",300,6179903,"LF"]
["Misc. Type C / Type D Conc Barrier (Roadway) (≥10 Ft) ",250,6179903,"LF"]
["Misc. Protective Coating – Concrete Bents qnd Piers (Epoxy) ",6,7119904,"SF"]
["Misc. Thorocoat Sealer ",4,7119904,"SF"]
["Misc. Bridge Deck Approach Slab Repair (Partial Depth) (Over 100 SF)",60,7049904,"SF"]
["Misc. Bridge Deck Approach Slab Repair (Partial Depth) (0-100 SF)",80,7049904,"SF"]
["Misc. Bridge Deck Approach Slab Repair (Full Depth)",90,7049904,"SF"]
["Misc. Repairing Concrete Deck (Half-Soling) (Over 600 SF)",35,7049904,"SF"]
["Misc. Repairing Concrete Deck (Half-Soling) (100-600 SF)",50,7049904,"SF"]
["Misc. Repairing Concrete Deck (Half-Soling) (Under 100 SF)",80,7049904,"SF"]
["Misc. Deck Repair with Void Tube Replacement (Over 80 SF)",90,7049904,"SF"]
["Misc. Deck Repair with Void Tube Replacement (0-80 SF)",130,7049904,"SF"]
["Misc. Full Depth Repair (Over 600 SF)",60,7049904,"SF"]
["Misc. Full Depth Repair (100-600 SF)",90,7049904,"SF"]
["Misc. Full Depth Repair (Under 100 SF)",125,7049904,"SF"]
["Misc. Dense Concrete Overlay Repair (Over 600 SF)",20,7049904,"SF"]
["Misc. Dense Concrete Overlay Repair (200-600 SF)",30,7049904,"SF"]
["Misc. Dense Concrete Overlay Repair (Under 200 SF)",40,7049904,"SF"]
["Misc. Epoxy Polymer Overlay Repair, Concrete Deck (Over 600 SF)",8,7049904,"SF"]
["Misc. Epoxy Polymer Overlay Repair, Concrete Deck (200-600 SF)",12,7049904,"SF"]
["Misc. Epoxy Polymer Overlay Repair, Concrete Deck (Under 200 SF)",14,7049904,"SF"]
["Misc. Vertical Substructure Repair (Unformed)",128,7049904,"SF"]
["Misc. Vertical Superstructure Repair (Unformed)",128,7049904,"SF"]
["Misc. Overhead Substructure Repair (Unformed)",137,7049904,"SF"]
["Misc. Overhead Superstructure Repair (Unformed)",137,7049904,"SF"]
["Misc. Concrete and Masonry Protection System",4,7119905,"SY"]
["Misc. Penetrating Concrete Sealer",4.2,7033013,"SY"]
["Misc. Concrete Crack Filler - High Molecular Weight Methacrylate",15,7049905,"SY"]
["Misc. Silicone Expansion Joint Sealant (<2.5\" Width)",50,7179903,"LF"]
["Misc. Preformed Silicone or EPDM Expansion Joint Seal (2.5\" to 4.5\" Width)",100,7179903,"LF"]

{"sheet":"Bridge Job Order","index":2,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[[52,6,52,8],[54,2,54,4],[54,8,54,9],[51,3,51,4],[51,5,51,6],[51,7,51,8],[46,8,46,9],[47,1,47,11],[48,8,48,9],[50,3,50,4],[50,5,50,6],[50,7,50,8],[58,2,58,4],[58,8,58,9],[59,8,59,9],[63,6,63,9],[55,2,55,4],[55,8,55,9],[56,2,56,4],[56,8,56,9],[57,2,57,4],[57,8,57,9],[44,1,44,2],[44,3,44,4],[44,8,44,9],[45,1,45,2],[45,3,45,4],[45,8,45,9],[42,1,42,2],[42,3,42,4],[42,8,42,9],[43,1,43,2],[43,3,43,4],[43,8,43,9],[40,1,40,2],[40,3,40,4],[40,8,40,9],[41,1,41,2],[41,3,41,4],[41,8,41,9],[38,1,38,2],[38,3,38,4],[38,8,38,9],[39,1,39,2],[39,3,39,4],[39,8,39,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[37,1,37,2],[37,3,37,4],[37,8,37,9],[34,1,34,2],[34,3,34,4],[34,8,34,9],[35,1,35,2],[35,3,35,4],[35,8,35,9],[32,1,32,2],[32,3,32,4],[32,8,32,9],[33,1,33,2],[33,3,33,4],[33,8,33,9],[28,1,28,2],[28,3,28,4],[28,8,28,9],[29,8,29,9],[30,3,30,6],[31,1,31,2],[31,3,31,4],[31,8,31,9],[27,1,27,2],[27,3,27,4],[27,8,27,9],[24,1,24,2],[24,3,24,4],[24,8,24,9],[25,1,25,2],[25,3,25,4],[25,8,25,9],[17,10,17,11],[18,1,19,2],[18,3,19,4],[18,5,19,5],[18,8,18,9],[19,8,19,9],[26,1,26,2],[26,3,26,4],[26,8,26,9],[0,1,0,11],[1,1,1,11],[6,2,6,3],[11,2,11,3],[12,2,12,3],[3,2,3,3],[3,10,3,11],[4,2,4,3],[4,8,4,9],[4,10,4,11],[5,2,5,3],[5,10,5,11],[6,10,6,11],[10,2,10,3],[10,4,12,4],[10,5,12,8],[10,9,10,10],[11,9,11,10],[12,9,12,10],[67,1,67,2],[67,3,67,4],[67,5,67,9],[67,10,67,11],[13,1,14,1],[13,2,14,11],[15,2,15,11],[16,2,16,11],[65,1,65,2],[65,3,65,4],[65,5,65,9],[65,10,65,11],[66,1,66,2],[66,3,66,4],[66,5,66,9],[66,10,66,11],[21,3,21,4],[21,10,21,11],[22,1,22,2],[22,3,22,4],[22,8,22,9],[23,1,23,2],[23,3,23,4],[23,8,23,9]]}
[null,"Missouri Department of Transportation"]
[null,"2026 Bridge Repair JOC"]
[]
[null,"Job Number:",{"$f":"'Contract Data'!N2","v":0},null,null,null,null,null,null,"K Number (MoDOT Property Damage Number):"]
[null,"Contract Number:",{"$f":"'Contract Data'!N3","v":0},null,null,null,null,null,"Date of Issuance"]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,null,"Proposed Notice to Proceed:"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,null,"Competion Date:"]
[null,null,null,null,null,null,null,null,null,null,"Daytime","Nighttime"]
[null,null,null,null,null,null,null,null,null,null,false,false]
[]
[null,"County:","SELECT",null,"Location Description:",null,null,null,null,"Mile Marker:"]
[null,"Route:",null,null,null,null,null,null,null,"GPS Latitude:"]
[null,"Direction (N,S,E,W)","SELECT",null,null,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,null,null,null,null,null,null,"Contractor Info"]
[null,"Item Code",null,"Pay Item Description",null,"Unit ","Estimated ","Contract","Estimated ",null,"Final","Final"]
[null,null,null,null,null,null,"Quantity","Unit Price","Price",null,"Quantity","Price"]
[]
[null,null,null,{"$f":"'Contract Data'!A3","v":"MISC. TRAFFIC CONTROL ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D23,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D23,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D23,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D23,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D23>0,VLOOKUP(D23,'Contract Data'!$A$4:$D$18,2,FALSE),0)","v":0},{"$f":"G23*H23","v":0},null,null,{"$f":"K23*H23","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D24,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D24,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D24>0,VLOOKUP(D24,'Contract Data'!$A$4:$D$18,2,FALSE),0)","v":0},{"$f":"G24*H24","v":0},null,null,{"$f":"K24*H24","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D25,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D25,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D25>0,VLOOKUP(D25,'Contract Data'!$A$4:$D$18,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D26,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D26,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D26>0,VLOOKUP(D26,'Contract Data'!$A$4:$D$18,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D27>0,VLOOKUP(D27,'Contract Data'!$A$4:$D$18,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D28>0,VLOOKUP(D28,'Contract Data'!$A$4:$D$18,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D29>0,VLOOKUP(D29,'Contract Data'!$A$4:$D$18,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I23:J29)","v":0},null,null,{"$f":"SUM(L23:L29)","v":0}]
[null,"Bridge Items",null,{"$f":"'Contract Data'!A21","v":"BRIDGE REPAIR ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D32>0,VLOOKUP(D32,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},{"$f":"G32*H32","v":0},null,null,{"$f":"H32*K32","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D33,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D33,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},{"$f":"G33*H33","v":0},null,null,{"$f":"H33*K33","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D34,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D34,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$27:$D$61,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$27:$D$61,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$27:$D$61,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$27:$D$61,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$22:$D$61,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I32:J46)","v":0},null,null,{"$f":"SUM(L32:L46)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"I30+I47","v":0},null,null,{"$f":"SUM(L30+L47)","v":0},null,"Enter into AWP in the Quantity Field for the Correct Line"]
[]
[null,null,null,"Adjustment Factor",null,"Estimated Subtotal",null,"Factor",null,"Est. Adj.\nSubtotal","Final Subtotal","Final Adj.\nSubtotal"]
[null,null,null,"Adjustment Factor",null,{"$f":"I49","v":0},null,{"$f":"'Contract Data'!J2","v":0},null,{"$f":"H52*F52","v":0},{"$f":"L49","v":0},{"$f":"H52*K52","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J52:J52)","v":0},null,{"$f":"SUM(L52:L52)","v":0}]
[null,"Contingent Items"]
[null,"Item","Pay Item Description",null,null,"Unit","Estimated\nQuantity","Unit Price","Estimated Price",null,"Final\nQuantity","Final Price"]
[null,null,null,null,null,null,null,null,{"$f":"G56*H56","v":0},null,null,{"$f":"H56*K56","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G57*H57","v":0},null,null,{"$f":"H57*K57","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,"Contingent Items Subtotal",{"$f":"SUM(I56:J59)","v":0},null,null,{"$f":"SUM(L56:L59)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,"  Total Job Price",null,null,null,{"$f":"SUM(J53+I60)","v":0},{"$f":"SUM(L53+L60)","v":0}]
[]
[null,null,null,"Responsible Person",null,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":"Unit Calculator","index":3,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Length(ft)","Width(ft)","Depth(in)","Area(SF)","Area(SY)","Volume(CF)"]
[null,null,null,null,{"$f":"B5*C5","v":0},{"$f":"B5*C5/9","v":0},{"$f":"B5*C5*D5/12","v":0}]
[null,null,null,null,{"$f":"B6*C6","v":0},{"$f":"B6*C6/9","v":0},{"$f":"B6*C6*D6/12","v":0}]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"SUM(E5:E54)","v":0},{"$f":"SUM(F5:F54)","v":0},{"$f":"SUM(G5:G54)","v":0}]

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