{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Contract Data","Work Order","Unit Calculator","GIS Data"],"not_rendered":{"charts":0,"images":1,"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":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["(If using spreadsheet 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."]
["Create a list of the counties included in the contract and a list of the applicable Maintenance Superintendents."]
[]
["Select the Job Order Tab for the items you're working on"]
[]
[]
["Fill in the shaded cells manually, note that some utilize dropdown menus."]
["Be sure and check the box for the type of work completed (Daytime or Nighttime). "]
[]
["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."]
[]
["Sign and submit to Job 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":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,0,1,3],[19,0,19,3]]}
["Do not change these items",null,null,null,null,null,"Enter Contract Bid Factor Here",null,null,null,null,null,"Enter Contract Specific Information Here",""]
["ALL",null,null,null,null,null,"Adjustment Factor",null,null,null,null,"Each","Job Number"]
["TRAFFIC CONTROL ITEMS",null,null,null,null,null,null,null,null,null,null,null,"Contract ID"]
["Truck or Trailer Mounted Attenuator (TMA)",750,"612-30.00A","EA",null,null,null,null,null,null,null,null,"Contractor"]
["Construction Signs (SF)",3,"616-10.05","SF",null,null,null,null,null,null,null,null,"Contractor Phone Number"]
["Channelizer (Trim Line)",9,"616-10.25","EA"]
["Type III Moveable Barricade",75,"616-10.30","EA",null,null,"Direction (N, S, E, W)",null,"SELECT"]
["Directional Indicator Barricade",18.75,"616-10.33","EA",null,null,null,null,"N"]
["Flashing Arrow Panel",390,"616-10.40","EA",null,null,null,null,"S"]
["Sequential Flashing Warning Light",50,"616-10.55","EA",null,null,null,null,"E"]
["CMS, contractor Furnished/Retained",1200,"616-10.98","EA",null,null,null,null,"W"]
["Single Lane Closure",3000,"616-99.02","EA"]
["Double Lane Closure",3900,"616-99.02","EA",null,null,"County:"]
["Interior Lane Closure",3900,"616-99.02","EA",null,null,"SELECT",null,null,null,null,null,"Maintenance Sup't"]
["Triple Lane Closure",4500,"616-99.02","EA",null,null,null,null,null,null,null,null,"SELECT"]
["Ramp Closure",1800,"616-99.02","EA"]
["Temporary Traffic Control Single Lane Shift",1000,"616-99.02","EA"]
["One-Lane Two-Way Operation with Flagger",3000,"616-99.02","EA"]
[]
["BRIDGE"]
["BRIDGE REPAIR ITEMS"]
["Removal of Existing Expansion Joint Silicone Sealant",35,"216-99.03","LF"]
["Removal of Existing Expansion Joint Compression Seal",52,"216-99.03","LF"]
["Asphaltic Concrete Overlay Repair",12,"401-99.04","SF"]
["Seal Coat, Grade A",4,"409-40.00","SY"]
["Seal Coat, Grade B",4,"409-40.10","SY"]
["Polymer Concrete",300,"623-40.00","CF"]
["Substructure Repair (Formed)",178,"704-01.01","SF"]
["Cleaning and Epoxy Coating",8,"704-01.13","SF"]
["Bridge Deck Approach Slab Repair (Partial Depth) (Over 200 SF)",40,"704-99.04","SF"]
["Bridge Deck Approach Slab Repair (Partial Depth) (0-200 SF)",80,"704-99.04","SF"]
["Bridge Deck Approach Slab Repair (Full Depth)",90,"704-99.04","SF"]
["Repairing Concrete Deck (Half-Soling) (Over 600 SF)",35,"704-99.04","SF"]
["Repairing Concrete Deck (Half-Soling) (200-600 SF)",50,"704-99.04","SF"]
["Repairing Concrete Deck (Half-Soling) (Under 200 SF)",60,"704-99.04","SF"]
["Deck Repair with Void Tube Replacement (Over 80 SF)",90,"704-99.04","SF"]
["Deck Repair with Void Tube Replacement (0-80 SF)",130,"704-99.04","SF"]
["Full Depth Repair (Over 600 SF)",60,"704-99.04","SF"]
["Full Depth Repair (200-600 SF)",80,"704-99.04","SF"]
["Full Depth Repair (Under 200 SF)",100,"704-99.04","SF"]
["Dense Concrete Overlay Repair (Over 600 SF)",20,"704-99.04","SF"]
["Dense Concrete Overlay Repair (200-600 SF)",30,"704-99.04","SF"]
["Dense Concrete Overlay Repair (Under 200 SF)",40,"704-99.04","SF"]
["Epoxy Polymer Overlay Repair, Concrete Deck (Over 600 SF)",8,"704-99.04","SF"]
["Epoxy Polymer Overlay Repair, Concrete Deck (200-600 SF)",12,"704-99.04","SF"]
["Epoxy Polymer Overlay Repair, Concrete Deck (Under 200 SF)",14,"704-99.04","SF"]
["Vertical Substructure Repair (Unformed)",128,"704-99.04","SF"]
["Vertical Superstructure Repair (Unformed)",128,"704-99.04","SF"]
["Overhead Substructure Repair (Unformed)",137,"704-99.04","SF"]
["Overhead Superstructure Repair (Unformed)",137,"704-99.04","SF"]
["Concrete and Masonry Protection System",4,"711-99.05","SY"]
["Penetrating Concrete Sealer",4.2,"711-99.05","SY"]
["Silicone Expansion Joint Sealant (<2.5\" Width)",50,"717-99.03","LF"]
["Preformed Silicone or EPDM Expansion Joint Seal (2.5\" to 4.5\" Width)",100,"717-99.03","LF"]

{"sheet":"Work Order","index":2,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,1,1,11],[4,7,4,9],[5,1,5,11],[6,2,6,3],[14,2,14,11],[15,2,15,4],[15,5,15,6],[15,7,15,10],[7,2,7,3],[9,2,10,11],[11,2,11,3],[11,9,11,11],[12,2,12,3],[12,9,12,11],[18,1,18,2],[18,3,18,4],[18,5,18,9],[19,1,19,2],[19,3,19,4],[19,5,19,9],[16,1,16,2],[16,3,16,4],[16,5,16,9],[17,1,17,2],[17,3,17,4],[17,5,17,9],[24,3,24,4],[24,10,24,11],[25,1,25,2],[25,3,25,4],[25,8,25,9],[26,1,26,2],[26,3,26,4],[26,8,26,9],[20,10,20,11],[21,1,22,2],[21,3,22,4],[21,5,22,5],[21,8,21,9],[22,8,22,9],[29,1,29,2],[29,3,29,4],[29,8,29,9],[30,1,30,2],[30,3,30,4],[30,8,30,9],[27,1,27,2],[27,3,27,4],[27,8,27,9],[28,1,28,2],[28,3,28,4],[28,8,28,9],[35,1,35,2],[35,3,35,4],[35,8,35,9],[36,1,36,2],[36,3,36,4],[36,8,36,9],[31,1,31,2],[31,3,31,4],[31,8,31,9],[32,8,32,9],[33,3,33,6],[34,1,34,2],[34,3,34,4],[34,8,34,9],[39,1,39,2],[39,3,39,4],[39,8,39,9],[40,1,40,2],[40,3,40,4],[40,8,40,9],[37,1,37,2],[37,3,37,4],[37,8,37,9],[38,1,38,2],[38,3,38,4],[38,8,38,9],[43,1,43,2],[43,3,43,4],[43,8,43,9],[44,1,44,2],[44,3,44,4],[44,8,44,9],[41,1,41,2],[41,3,41,4],[41,8,41,9],[42,1,42,2],[42,3,42,4],[42,8,42,9],[47,1,47,2],[47,3,47,4],[47,8,47,9],[48,1,48,2],[48,3,48,4],[48,8,48,9],[45,1,45,2],[45,3,45,4],[45,8,45,9],[46,1,46,2],[46,3,46,4],[46,8,46,9],[61,2,61,4],[61,8,61,9],[62,8,62,9],[66,6,66,9],[11,7,11,8],[12,7,12,8],[58,2,58,4],[58,8,58,9],[59,2,59,4],[59,8,59,9],[60,2,60,4],[60,8,60,9],[55,6,55,8],[57,2,57,4],[57,8,57,9],[54,3,54,4],[54,5,54,6],[54,7,54,8],[49,8,49,9],[50,1,50,11],[51,8,51,9],[53,3,53,4],[53,5,53,6],[53,7,53,8]]}
[null,"Missouri Department of Transportation"]
[null,"2023 Bridge Repair JOC"]
[]
[null,null,null,"Job Number:",{"$f":"'Contract Data'!N2","v":0}]
[null,null,null,"Contract  Number:",{"$f":"'Contract Data'!N3","v":0},null,"Date Issued:"]
[null,"Job Order"]
[null,"Contractor:",{"$f":"'Contract Data'!N4","v":0},null,null,null,null,null,"Daytime","Nighttime"]
[null,"Phone:",{"$f":"'Contract Data'!N5","v":0},null,null,null,null,null,false,false]
[]
[null,"Description of Work:"]
[]
[null,"Route:",null,null,null,null,null,"Direction (N, S, E, W):",null,"SELECT"]
[null,"Maintenance Sup't:","SELECT",null,null,null,null,"County:",null,"SELECT"]
[]
[null,"Remarks/Comments:"]
[null,null,"TOTAL ESTIMATED PRICE FOR THIS WORK ORDER:",null,null,{"$f":"K67","v":0},null,"TOTAL COMPLETED PRICE THIS WORK ORDER:",null,null,null,{"$f":"L67","v":0}]
[null,"Issued:",null,"Responsible Person",null,null,null,null,null,null,"Time","Date"]
[null,"Notice to Proceed:",null,null,null,"MoDOT"]
[null,"Engr. Notified of Completion:",null,null,null,"Contractor"]
[null,"Inspection/Acceptance:\n(Signature)",null,null,null,"MoDOT"]
[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":"TRAFFIC CONTROL ITEMS"}]
[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},{"$f":"G26*H26","v":0},null,null,{"$f":"K26*H26","v":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},{"$f":"G27*H27","v":0},null,null,{"$f":"K27*H27","v":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,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D30>0,VLOOKUP(D30,'Contract Data'!$A$4:$D$18,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D31,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D31,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D31>0,VLOOKUP(D31,'Contract Data'!$A$4:$D$18,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$18,3,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$18,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D32,'Contract Data'!$A$4:$D$18,4,FALSE)),\"\",VLOOKUP(D32,'Contract Data'!$A$4:$D$18,4,FALSE))","v":""},null,{"$f":"IF(D32>0,VLOOKUP(D32,'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(I26:J32)","v":0},null,null,{"$f":"SUM(L26:L32)","v":0}]
[null,"Bridge Items",null,{"$f":"'Contract Data'!A21","v":"BRIDGE REPAIR ITEMS"}]
[null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D35,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D35,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},{"$f":"G35*H35","v":0},null,null,{"$f":"H35*K35","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D36,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D36,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},{"$f":"G36*H36","v":0},null,null,{"$f":"H36*K36","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D37,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D37>0,VLOOKUP(D37,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D38,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D38,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D39,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D39,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D40,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D40,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D41,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D41,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D42,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D42,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D43,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D43,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D44,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D44,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D45,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D45,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D46,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D46,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D47,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D47,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D48,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D48,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D48>0,VLOOKUP(D48,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$27:$D$54,3,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$27:$D$54,3,FALSE))","v":""},null,null,null,{"$f":"IF(ISNA(VLOOKUP(D49,'Contract Data'!$A$27:$D$54,4,FALSE)),\"\",VLOOKUP(D49,'Contract Data'!$A$27:$D$54,4,FALSE))","v":""},null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$22:$D$54,2,FALSE),0)","v":0},0,null,null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I35:J49)","v":0},null,null,{"$f":"SUM(L35:L49)","v":0}]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"I33+I50","v":0},null,null,{"$f":"SUM(L33+L50)","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":"I52","v":0},null,{"$f":"'Contract Data'!K2","v":0},null,{"$f":"H55*F55","v":0},{"$f":"L52","v":0},{"$f":"H55*K55","v":0}]
[null,null,null,null,null,null,"Adjusted Subtotal",null,null,{"$f":"SUM(J55:J55)","v":0},null,{"$f":"SUM(L55:L55)","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":"G59*H59","v":0},null,null,{"$f":"H59*K59","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G60*H60","v":0},null,null,{"$f":"H60*K60","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(I59:J62)","v":0},null,null,{"$f":"SUM(L59:L62)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,"  Total Job Price",null,null,null,{"$f":"SUM(J56+I63)","v":0},{"$f":"SUM(L56+L63)","v":0}]

{"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:"]