{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Contract Data","Work Order","Asphalt","Class C Partial","GIS Data"],"not_rendered":{"charts":0,"images":1,"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":34,"n_cols":1,"rows_kept":34,"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 column G 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 (for asphalt repairs, also choose the correct type from the adjacent dropdown menu)"]
[]
["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"]
[]
[]
["Select the Work 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 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":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Do not change these items","Fixed \nPrice","Item\nNumber",null,"Unit",null,"Enter Contract Bid Factor Here",null,null,null,null,null,"Enter Project Job Number Here","Enter Contractor and Contract ID Here",null,null,null,""]
["TRAFFIC CONTROL ITEMS",null,null,null,null,null,"Adjustment Factor",null,"Each"]
["MISC. ADDITIONAL CONSTRUCTION SIGNS",3,6161005,null,"SF"]
["MISC. ADDITIONAL CHANNELIZER (TRIMLINE)",9,6161025,null,"EA"]
["MISC. ADDITIONAL TYPE III MOVEABLE BARRICADE ",75,6161030,null,"EA"]
["MISC. ADDITIONAL DIRECTIONAL INDICATOR BARRICADE",18.75,6161033,null,"EA"]
["MISC. ADDITIONAL FLASHING ARROW PANEL",390,6161040,null,"EA"]
["MISC. SEQUENTIAL FLASHING WARNING LIGHT",50,6161055,null,"EA"]
["MISC. ADDITIONAL CMS (CONTRACTOR FURNISHED/RETAINED) ",1200,6161098,null,"EA"]
["SINGLE LANE CLOSURE ",3000,6169902,null,"EA"]
["DOUBLE LANE CLOSURE ",3900,6169902,null,"EA"]
["INTERIOR LANE CLOSURE",3900,6169902,null,"EA",null,"Fill in Maintenance Superintendents for your District - populates cell I14 of Work Order spreadsheet"]
["TRIPLE LANE CLOSURE",4500,6169902,null,"EA"]
["RAMP CLOSURE ",1800,6169902,null,"EA"]
["TEMPORARY TRAFFIC CONTROL SINGLE LANE SHIFT",1000,6169902,null,"EA",null,null,null,"Direction (N, S, E, W)"]
["MISC. 1-LANE 2-WAY OPERATION W/ FLAGGERS",3000,6169902,null,"EA",null,null,null,null,null,"SELECT"]
["MISC. ADDITIONAL TRUCK MOUNTED ATTENUATOR (TMA)",750,6169902,null,"EA",null,"Used in picklist - Do Not Delete",null,null,null,"N"]
[null,null,null,null,null,null,"Yes",null,null,null,"S"]
["ASPHALT PAVEMENT ITEMS",null,null,null,null,null,"No",null,null,null,"E"]
["Shoulder Mix (15-100 tons) (Over 9 feet wide)",85,4019910,2.4569999999999999,"TONS",null,"Enter Counties Here",null,null,null,"W"]
["Shoulder Mix (15-100 tons) (4.1-9 feet wide)",102,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (15-100 tons) (2-4 feet wide)",122,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (100.1-500 tons) (Over 9 feet wide)",66.5,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (100.1-500 tons) (4.1-9 feet wide)",79,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (100.1-500 tons) (2-4 feet wide)",94,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (500.1-1000 tons) (Over 9 feet wide)",60,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (500.1-1000 tons) (4.1-9 feet wide)",72,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (500.1-1000 tons) (2-4 feet wide)",85,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (Over 1000 tons) (Over 9 feet wide)",56,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (Over 1000 tons) (4.1-9 feet wide)",67,4019910,2.4569999999999999,"TONS"]
["Shoulder Mix (Over 1000 tons) (2-4 feet wide)",80,4019910,2.4569999999999999,"TONS"]
["SP125C (70-22) (15-100 tons) (Over 9 feet wide)",102,4039910,2.4620000000000002,"TONS"]
["SP125C (70-22) (15-100 tons) (4-9 feet wide)",122,4039910,2.4620000000000002,"TONS"]
["SP125C (70-22) (15-100 tons) (2-4 feet wide)",146,4039910,2.4649999999999999,"TONS"]
["SP125C (70-22) (100.1-500 tons) (Over 9 feet wide)",84,4039910,2.4620000000000002,"TONS"]
["SP125C (70-22) (100.1-500 tons) (4-9 feet wide)",100,4039910,2.4620000000000002,"TONS"]
["SP125C (70-22) (100.1-500 tons) (2-4 feet wide)",120,4039910,2.4649999999999999,"TONS"]
["SP125C (70-22) (500.1-1000 tons) (Over 9 feet wide)",74,4039910,2.4620000000000002,"TONS"]
["SP125C (70-22) (500.1-1000 tons) (4-9 feet wide)",88,4039910,2.4620000000000002,"TONS"]
["SP125C (70-22) (500.1-1000 tons) (2-4 feet wide)",105,4039910,2.4649999999999999,"TONS"]
["SP125C (70-22) (Over 1000 tons) (Over 9 feet wide)",71,4039910,2.4620000000000002,"TONS"]
["SP125C (70-22) (Over 1000 tons) (4-9 feet wide)",85,4039910,2.4620000000000002,"TONS"]
["SP125C (70-22) (Over 1000 tons) (2-4 feet wide)",102,4039910,2.4649999999999999,"TONS"]
["Tack Coat",3.7,4071005,null,"GAL"]
["Furnishing and Placing Bituminous Material for Class C Partial Depth Pavement Repair",150,6133020,null,"TONS"]
["Removal for Class C Partial Depth Pavement Repair",50,6133021,null,"SY"]
["Milling per SY (<2\")",2.6,6229905,null,"SY"]
["Milling per SY (2\"-4\")",2.9,6229905,null,"SY"]
["Milling per SY (4\"-6\")",3.2,6229905,null,"SY"]
["Milling per SY (>6\")",8,6229905,null,"SY"]
["Modified Milling/Depth Transition",9,6229905,null,"SY"]
["Mobilization Coldmill & Resurfacing (15-1000 tons)",5000,6189902,null,"EA"]
["Mobilization Coldmill & Resurfacing (Over 1000 tons)",3500,6189902,null,"EA"]
["Mobilization Resurfacing Only (15-1000 tons)",4450,6189902,null,"EA"]
["Mobilization Resurfacing Only (Over 1000 tons)",2750,6189902,null,"EA"]
["Mobilization Material Transfer Vehicle",2700,6189902,null,"EA"]

{"sheet":"Work Order","index":2,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":false,"merged":[[42,1,42,2],[43,1,43,2],[51,1,51,2],[44,1,44,2],[45,1,45,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[6,1,6,2],[15,1,15,2],[13,6,13,7],[14,6,14,7],[41,1,41,2],[34,1,34,2],[17,1,17,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[37,1,37,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[32,1,32,2],[33,1,33,2],[16,1,16,2],[18,1,18,3],[19,1,21,9],[23,1,23,2],[26,1,26,2],[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],[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],[67,5,67,7],[54,1,54,9],[69,2,69,3],[69,4,69,6],[69,7,69,9],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[60,1,60,2],[57,5,57,6],[58,5,58,6],[70,1,71,1],[70,2,70,3],[70,4,70,6],[70,7,70,9],[71,2,71,3],[71,4,71,6],[71,7,71,9],[74,2,74,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]]}
[null,"Missouri Department of Transportation"]
[null,"2023 Asphalt Pavement Repair Job Order",null,false]
[null,{"$f":"'Contract Data'!M2","v":0}]
[null,{"$f":"IF(B3>0,VLOOKUP(B3,'Contract Data'!M2:N6,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,null," WZ Law Enforcement?"]
[null,"Working Hour Restrictions"]
[null,null,null,null,null,null,null,null,"Daytime","Nighttime"]
[null,null,null,null,null,null,null,null,false,false]
[null,"Location and Description of Repair(s):  "]
[null,"Asphalt 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(ISNA(VLOOKUP(D27,'Contract Data'!$A$52:$C$56,3,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$52:$C$56,3,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D27,'Contract Data'!$A$20:$E$72,5,FALSE)),\"\",VLOOKUP(D27,'Contract Data'!$A$20:$E$72,5,FALSE))","v":""},null,null,{"$f":"IF(D27>0,VLOOKUP(D27,'Contract Data'!$A$52:$C$56,2,FALSE),0)","v":0},{"$f":"IF(F27=\"\",0,F27*H27)","v":0},{"$f":"G27*H27","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$52:$C$56,3,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$52:$C$56,3,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D28,'Contract Data'!$A$20:$E$72,5,FALSE)),\"\",VLOOKUP(D28,'Contract Data'!$A$20:$E$72,5,FALSE))","v":""},null,null,{"$f":"IF(D28>0,VLOOKUP(D28,'Contract Data'!$A$52:$C$56,2,FALSE),0)","v":0},{"$f":"IF(F28=\"\",0,F28*H28)","v":0},{"$f":"G28*H28","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$52:$C$56,3,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$52:$C$56,3,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D29,'Contract Data'!$A$20:$E$72,5,FALSE)),\"\",VLOOKUP(D29,'Contract Data'!$A$20:$E$72,5,FALSE))","v":""},null,null,{"$f":"IF(D29>0,VLOOKUP(D29,'Contract Data'!$A$52:$C$56,2,FALSE),0)","v":0},0,{"$f":"G29*H29","v":0}]
[null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$52:$C$56,3,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$52:$C$56,3,FALSE))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(D30,'Contract Data'!$A$20:$E$72,5,FALSE)),\"\",VLOOKUP(D30,'Contract Data'!$A$20:$E$72,5,FALSE))","v":""},null,null,{"$f":"IF(D30>0,VLOOKUP(D30,'Contract Data'!$A$52:$C$56,2,FALSE),0)","v":0},0,{"$f":"G30*H30","v":0}]
[null,null,null,null,null,null,null,"Mobilization Subtotal",{"$f":"SUM(I27:I30)","v":0},{"$f":"SUM(J27:J30)","v":0}]
[null,null,null,"MILLING"]
[null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$47:C$56,3,FALSE),\"\")","v":""},{"$f":"IF(D33=\"\",\"\",IF($H$18=TRUE,\"0010\",IF($I$18=TRUE,\"0020\",IF($J$18=TRUE,\"0030\",\"\"))))","v":""},null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D33>0,VLOOKUP(D33,'Contract Data'!$A$47:$C$56,2,FALSE),0)","v":0},{"$f":"F33*H33","v":0},{"$f":"G33*H33","v":0}]
[null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$47:C$56,3,FALSE),\"\")","v":""},{"$f":"IF(D34=\"\",\"\",IF($H$18=TRUE,\"0010\",IF($I$18=TRUE,\"0020\",IF($J$18=TRUE,\"0030\",\"\"))))","v":""},null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D34>0,VLOOKUP(D34,'Contract Data'!$A$47:$C$56,2,FALSE),0)","v":0},{"$f":"F34*H34","v":0},{"$f":"G34*H34","v":0}]
[null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$47:C$56,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D35>0,VLOOKUP(D35,'Contract Data'!$A$47:$C$56,2,FALSE),0)","v":0},{"$f":"F35*H35","v":0},{"$f":"G35*H35","v":0}]
[null,null,null,null,{"$f":"IF(D36>0,VLOOKUP(D36,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,"Milling Subtotal",{"$f":"SUM(I33:I35)","v":0},{"$f":"SUM(J33:J35)","v":0}]
[null,null,null,"PAVING/PAVEMENT REPAIR"]
[null,{"$f":"IF(D38>0,VLOOKUP('Work Order'!D38,'Contract Data'!$A$20:$C$46,3,FALSE),\"\")","v":""},{"$f":"IF(D38=\"\",\"\",IF($H$18=TRUE,\"0010\",IF($I$18=TRUE,\"0020\",IF($J$18=TRUE,\"0030\",\"\"))))","v":""},null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D38>0,VLOOKUP(D38,'Contract Data'!$A$20:$B$46,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$20:$C$46,3,FALSE),\"\")","v":""},{"$f":"IF(D39=\"\",\"\",IF($H$18=TRUE,\"0010\",IF($I$18=TRUE,\"0020\",IF($J$18=TRUE,\"0030\",\"\"))))","v":""},null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D39>0,VLOOKUP(D39,'Contract Data'!$A$20:$B$46,2,FALSE),0)","v":0},{"$f":"F39*H39","v":0},0]
[null,{"$f":"IF(D40>0,VLOOKUP('Work Order'!D40,'Contract Data'!$A$20:$C$46,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D40>0,VLOOKUP(D40,'Contract Data'!$A$20:$B$46,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D41>0,VLOOKUP('Work Order'!D41,'Contract Data'!$A$20:$C$46,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D41>0,VLOOKUP(D41,'Contract Data'!$A$20:$B$46,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D42>0,VLOOKUP('Work Order'!D42,'Contract Data'!$A$20:$C$46,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D42>0,VLOOKUP(D42,'Contract Data'!$A$20:$B$46,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D43>0,VLOOKUP('Work Order'!D43,'Contract Data'!$A$20:$C$46,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D43>0,VLOOKUP(D43,'Contract Data'!$A$20:$B$46,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D44>0,VLOOKUP('Work Order'!D44,'Contract Data'!$A$20:$C$46,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D44>0,VLOOKUP(D44,'Contract Data'!$A$20:$B$46,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D45>0,VLOOKUP('Work Order'!D45,'Contract Data'!$A$20:$C$46,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D45>0,VLOOKUP(D45,'Contract Data'!$A$20:$B$46,2,FALSE),0)","v":0},0,0]
[null,{"$f":"IF(D46>0,VLOOKUP('Work Order'!D46,'Contract Data'!$A$20:$C$46,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D46>0,VLOOKUP(D46,'Contract Data'!$A$20:$B$46,2,FALSE),0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(D47>0,VLOOKUP(D47,'Contract Data'!$A$20:$E$72,5,FALSE),\" \")","v":" "},null,null,"Paving Subtotal",{"$f":"SUM(I38:I46)","v":0},{"$f":"SUM(J38:J46)","v":0}]
[null,null,null,"TRAFFIC CONTROL"]
[null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$3:$C$17,3,FALSE),\"\")","v":""},{"$f":"IF(D49=\"\",\"\",IF($H$18=TRUE,\"0010\",IF($I$18=TRUE,\"0020\",IF($J$18=TRUE,\"0030\",\"\"))))","v":""},null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$3:$E$17,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D49>0,VLOOKUP(D49,'Contract Data'!$A$3:$B$17,2,FALSE),0)","v":0},{"$f":"F49*H49","v":0},{"$f":"G49*H49","v":0}]
[null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$3:$C$17,3,FALSE),\"\")","v":""},{"$f":"IF(D50=\"\",\"\",IF($H$18=TRUE,\"0010\",IF($I$18=TRUE,\"0020\",IF($J$18=TRUE,\"0030\",\"\"))))","v":""},null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$3:$E$17,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D50>0,VLOOKUP(D50,'Contract Data'!$A$3:$B$17,2,FALSE),0)","v":0},{"$f":"F50*H50","v":0},{"$f":"G50*H50","v":0}]
[null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$3:$C$17,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$3:$E$17,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D51>0,VLOOKUP(D51,'Contract Data'!$A$3:$B$17,2,FALSE),0)","v":0},0,{"$f":"G51*H51","v":0}]
[null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$3:$C$17,3,FALSE),\"\")","v":""},"",null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$3:$E$17,5,FALSE),\" \")","v":" "},null,null,{"$f":"IF(D52>0,VLOOKUP(D52,'Contract Data'!$A$3:$B$17,2,FALSE),0)","v":0},0,{"$f":"G52*H52","v":0}]
[null,null,null,null,null,null,null,"Traffic Control Subtotal",{"$f":"SUM(I49:I52)","v":0},{"$f":"SUM(J49:J52)","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Job Order Subtotal",{"$f":"SUM(I31+I36+I47+I53)","v":0},{"$f":"SUM(J31+J36+J47+J53)","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. Subtotal"]
[null,null,null,"Adjustment Factor",{"$f":"'Contract Data'!H2","v":0},{"$f":"I56","v":0},null,{"$f":"J56","v":0},{"$f":"E59*F59","v":0},{"$f":"E59*H59","v":0}]
[null,null,null,null,null,null,null,"Adjusted Subtotal",{"$f":"SUM(I59:I59)","v":0},{"$f":"SUM(J59:J59)","v":0}]
[null,"Contingent Items"]
[null,"Item","Pay Item Description",null,"Unit","Estimated\nQuantity","Final\nQuantity","Unit Price","Estimated \nPrice","Final Price"]
[null,null,null,null,null,null,null,null,{"$f":"F63*H63","v":0},{"$f":"G63*H63","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F64*H64","v":0},{"$f":"G64*H64","v":0}]
[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,"Contingent Items Subtotal",{"$f":"SUM(I63:I65)","v":0},{"$f":"SUM(J63:J65)","v":0}]
[]
[null,null,null,null,null,"  Total Job Price",null,null,{"$f":"SUM(I60+ I66)","v":0},{"$f":"SUM(J60+ J66)","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":"Asphalt","index":3,"n_rows":58,"n_cols":25,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,5,1,7]]}
[null,null,null,null,null,null,null,"JMF Gmm",2.44]
[null,null,null,null,null,"Anticipated Density:",null,null,92]
[]
["Log Mile","Lane (Driving/Passing)","Mill \n(in)","Replace \n(in)","Tack \nCoat","Length","Width","Milling \nper SY","Area SF","Area SY","Tack Coat \nTotal","Mix Type","Tons","Price",null,"Quantity","Traffic Control","Price","TC Total",null,"Quantity","Mobilization","Price","Mob Total"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(0<C5,C5<2),'Contract Data'!$B$47*J5,IF(OR(AND(2<C5,C5<4),C5=2,C5=4),'Contract Data'!$B$48*J5,IF(OR(AND(4<C5,C5<6),C5=6),'Contract Data'!$B$49*J5,IF(C5>6,'Contract Data'!$B$50*J5,0))))","v":0},{"$f":"F5*G5","v":0},{"$f":"I5/9","v":0},{"$f":"IF(E5=TRUE,0.1*J5,0)","v":0},null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I5*Asphalt!D5/12)","v":0},{"$f":"IF(L5>0,VLOOKUP(L5,'Contract Data'!$A$20:$B$43,2,FALSE)*M5,0)","v":0},null,null,null,{"$f":"IF(Q5>0,VLOOKUP(Q5,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},{"$f":"R5*P5","v":0},null,null,null,{"$f":"IF(V5>0,VLOOKUP(V5,'Contract Data'!$A$52:$B$56,2,FALSE),0)","v":0},{"$f":"W5*U5","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(0<C6,C6<2),'Contract Data'!$B$47*J6,IF(OR(AND(2<C6,C6<4),C6=2,C6=4),'Contract Data'!$B$48*J6,IF(OR(AND(4<C6,C6<6),C6=6),'Contract Data'!$B$49*J6,IF(C6>6,'Contract Data'!$B$50*J6,0))))","v":0},0,{"$f":"I6/9","v":0},{"$f":"IF(E6=TRUE,0.1*J6,0)","v":0},null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I6*Asphalt!D6/12)","v":0},{"$f":"IF(L6>0,VLOOKUP(L6,'Contract Data'!$A$20:$B$43,2,FALSE)*M6,0)","v":0},null,null,null,{"$f":"IF(Q6>0,VLOOKUP(Q6,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},{"$f":"R6*P6","v":0},null,null,null,{"$f":"IF(V6>0,VLOOKUP(V6,'Contract Data'!$A$52:$B$56,2,FALSE),0)","v":0},{"$f":"W6*U6","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C7,C7<2),'Contract Data'!$B$47*J7,IF(OR(AND(2<C7,C7<4),C7=2,C7=4),'Contract Data'!$B$48*J7,IF(OR(AND(4<C7,C7<6),C7=6),'Contract Data'!$B$49*J7,IF(C7>6,'Contract Data'!$B$50*J7,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I7*Asphalt!D7/12)","v":0},{"$f":"IF(L7>0,VLOOKUP(L7,'Contract Data'!$A$20:$B$43,2,FALSE)*M7,0)","v":0},null,null,null,{"$f":"IF(Q7>0,VLOOKUP(Q7,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0,null,null,null,{"$f":"IF(V7>0,VLOOKUP(V7,'Contract Data'!$A$52:$B$56,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C8,C8<2),'Contract Data'!$B$47*J8,IF(OR(AND(2<C8,C8<4),C8=2,C8=4),'Contract Data'!$B$48*J8,IF(OR(AND(4<C8,C8<6),C8=6),'Contract Data'!$B$49*J8,IF(C8>6,'Contract Data'!$B$50*J8,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I8*Asphalt!D8/12)","v":0},{"$f":"IF(L8>0,VLOOKUP(L8,'Contract Data'!$A$20:$B$43,2,FALSE)*M8,0)","v":0},null,null,null,{"$f":"IF(Q8>0,VLOOKUP(Q8,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C9,C9<2),'Contract Data'!$B$47*J9,IF(OR(AND(2<C9,C9<4),C9=2,C9=4),'Contract Data'!$B$48*J9,IF(OR(AND(4<C9,C9<6),C9=6),'Contract Data'!$B$49*J9,IF(C9>6,'Contract Data'!$B$50*J9,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I9*Asphalt!D9/12)","v":0},{"$f":"IF(L9>0,VLOOKUP(L9,'Contract Data'!$A$20:$B$43,2,FALSE)*M9,0)","v":0},null,null,null,{"$f":"IF(Q9>0,VLOOKUP(Q9,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C10,C10<2),'Contract Data'!$B$47*J10,IF(OR(AND(2<C10,C10<4),C10=2,C10=4),'Contract Data'!$B$48*J10,IF(OR(AND(4<C10,C10<6),C10=6),'Contract Data'!$B$49*J10,IF(C10>6,'Contract Data'!$B$50*J10,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I10*Asphalt!D10/12)","v":0},{"$f":"IF(L10>0,VLOOKUP(L10,'Contract Data'!$A$20:$B$43,2,FALSE)*M10,0)","v":0},null,null,null,{"$f":"IF(Q10>0,VLOOKUP(Q10,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C11,C11<2),'Contract Data'!$B$47*J11,IF(OR(AND(2<C11,C11<4),C11=2,C11=4),'Contract Data'!$B$48*J11,IF(OR(AND(4<C11,C11<6),C11=6),'Contract Data'!$B$49*J11,IF(C11>6,'Contract Data'!$B$50*J11,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I11*Asphalt!D11/12)","v":0},{"$f":"IF(L11>0,VLOOKUP(L11,'Contract Data'!$A$20:$B$43,2,FALSE)*M11,0)","v":0},null,null,null,{"$f":"IF(Q11>0,VLOOKUP(Q11,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C12,C12<2),'Contract Data'!$B$47*J12,IF(OR(AND(2<C12,C12<4),C12=2,C12=4),'Contract Data'!$B$48*J12,IF(OR(AND(4<C12,C12<6),C12=6),'Contract Data'!$B$49*J12,IF(C12>6,'Contract Data'!$B$50*J12,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I12*Asphalt!D12/12)","v":0},{"$f":"IF(L12>0,VLOOKUP(L12,'Contract Data'!$A$20:$B$43,2,FALSE)*M12,0)","v":0},null,null,null,{"$f":"IF(Q12>0,VLOOKUP(Q12,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C13,C13<2),'Contract Data'!$B$47*J13,IF(OR(AND(2<C13,C13<4),C13=2,C13=4),'Contract Data'!$B$48*J13,IF(OR(AND(4<C13,C13<6),C13=6),'Contract Data'!$B$49*J13,IF(C13>6,'Contract Data'!$B$50*J13,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I13*Asphalt!D13/12)","v":0},{"$f":"IF(L13>0,VLOOKUP(L13,'Contract Data'!$A$20:$B$43,2,FALSE)*M13,0)","v":0},null,null,null,{"$f":"IF(Q13>0,VLOOKUP(Q13,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C14,C14<2),'Contract Data'!$B$47*J14,IF(OR(AND(2<C14,C14<4),C14=2,C14=4),'Contract Data'!$B$48*J14,IF(OR(AND(4<C14,C14<6),C14=6),'Contract Data'!$B$49*J14,IF(C14>6,'Contract Data'!$B$50*J14,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I14*Asphalt!D14/12)","v":0},{"$f":"IF(L14>0,VLOOKUP(L14,'Contract Data'!$A$20:$B$43,2,FALSE)*M14,0)","v":0},null,null,null,{"$f":"IF(Q14>0,VLOOKUP(Q14,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C15,C15<2),'Contract Data'!$B$47*J15,IF(OR(AND(2<C15,C15<4),C15=2,C15=4),'Contract Data'!$B$48*J15,IF(OR(AND(4<C15,C15<6),C15=6),'Contract Data'!$B$49*J15,IF(C15>6,'Contract Data'!$B$50*J15,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I15*Asphalt!D15/12)","v":0},{"$f":"IF(L15>0,VLOOKUP(L15,'Contract Data'!$A$20:$B$43,2,FALSE)*M15,0)","v":0},null,null,null,{"$f":"IF(Q15>0,VLOOKUP(Q15,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C16,C16<2),'Contract Data'!$B$47*J16,IF(OR(AND(2<C16,C16<4),C16=2,C16=4),'Contract Data'!$B$48*J16,IF(OR(AND(4<C16,C16<6),C16=6),'Contract Data'!$B$49*J16,IF(C16>6,'Contract Data'!$B$50*J16,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I16*Asphalt!D16/12)","v":0},{"$f":"IF(L16>0,VLOOKUP(L16,'Contract Data'!$A$20:$B$43,2,FALSE)*M16,0)","v":0},null,null,null,{"$f":"IF(Q16>0,VLOOKUP(Q16,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C17,C17<2),'Contract Data'!$B$47*J17,IF(OR(AND(2<C17,C17<4),C17=2,C17=4),'Contract Data'!$B$48*J17,IF(OR(AND(4<C17,C17<6),C17=6),'Contract Data'!$B$49*J17,IF(C17>6,'Contract Data'!$B$50*J17,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I17*Asphalt!D17/12)","v":0},{"$f":"IF(L17>0,VLOOKUP(L17,'Contract Data'!$A$20:$B$43,2,FALSE)*M17,0)","v":0},null,null,null,{"$f":"IF(Q17>0,VLOOKUP(Q17,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C18,C18<2),'Contract Data'!$B$47*J18,IF(OR(AND(2<C18,C18<4),C18=2,C18=4),'Contract Data'!$B$48*J18,IF(OR(AND(4<C18,C18<6),C18=6),'Contract Data'!$B$49*J18,IF(C18>6,'Contract Data'!$B$50*J18,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I18*Asphalt!D18/12)","v":0},{"$f":"IF(L18>0,VLOOKUP(L18,'Contract Data'!$A$20:$B$43,2,FALSE)*M18,0)","v":0},null,null,null,{"$f":"IF(Q18>0,VLOOKUP(Q18,'Contract Data'!$A$57:$B$72,2,FALSE),)","v":0},0]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C19,C19<2),'Contract Data'!$B$47*J19,IF(OR(AND(2<C19,C19<4),C19=2,C19=4),'Contract Data'!$B$48*J19,IF(OR(AND(4<C19,C19<6),C19=6),'Contract Data'!$B$49*J19,IF(C19>6,'Contract Data'!$B$50*J19,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I19*Asphalt!D19/12)","v":0},{"$f":"IF(L19>0,VLOOKUP(L19,'Contract Data'!$A$20:$B$43,2,FALSE)*M19,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C20,C20<2),'Contract Data'!$B$47*J20,IF(OR(AND(2<C20,C20<4),C20=2,C20=4),'Contract Data'!$B$48*J20,IF(OR(AND(4<C20,C20<6),C20=6),'Contract Data'!$B$49*J20,IF(C20>6,'Contract Data'!$B$50*J20,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I20*Asphalt!D20/12)","v":0},{"$f":"IF(L20>0,VLOOKUP(L20,'Contract Data'!$A$20:$B$43,2,FALSE)*M20,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C21,C21<2),'Contract Data'!$B$47*J21,IF(OR(AND(2<C21,C21<4),C21=2,C21=4),'Contract Data'!$B$48*J21,IF(OR(AND(4<C21,C21<6),C21=6),'Contract Data'!$B$49*J21,IF(C21>6,'Contract Data'!$B$50*J21,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I21*Asphalt!D21/12)","v":0},{"$f":"IF(L21>0,VLOOKUP(L21,'Contract Data'!$A$20:$B$43,2,FALSE)*M21,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C22,C22<2),'Contract Data'!$B$47*J22,IF(OR(AND(2<C22,C22<4),C22=2,C22=4),'Contract Data'!$B$48*J22,IF(OR(AND(4<C22,C22<6),C22=6),'Contract Data'!$B$49*J22,IF(C22>6,'Contract Data'!$B$50*J22,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I22*Asphalt!D22/12)","v":0},{"$f":"IF(L22>0,VLOOKUP(L22,'Contract Data'!$A$20:$B$43,2,FALSE)*M22,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C23,C23<2),'Contract Data'!$B$47*J23,IF(OR(AND(2<C23,C23<4),C23=2,C23=4),'Contract Data'!$B$48*J23,IF(OR(AND(4<C23,C23<6),C23=6),'Contract Data'!$B$49*J23,IF(C23>6,'Contract Data'!$B$50*J23,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I23*Asphalt!D23/12)","v":0},{"$f":"IF(L23>0,VLOOKUP(L23,'Contract Data'!$A$20:$B$43,2,FALSE)*M23,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C24,C24<2),'Contract Data'!$B$47*J24,IF(OR(AND(2<C24,C24<4),C24=2,C24=4),'Contract Data'!$B$48*J24,IF(OR(AND(4<C24,C24<6),C24=6),'Contract Data'!$B$49*J24,IF(C24>6,'Contract Data'!$B$50*J24,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I24*Asphalt!D24/12)","v":0},{"$f":"IF(L24>0,VLOOKUP(L24,'Contract Data'!$A$20:$B$43,2,FALSE)*M24,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C25,C25<2),'Contract Data'!$B$47*J25,IF(OR(AND(2<C25,C25<4),C25=2,C25=4),'Contract Data'!$B$48*J25,IF(OR(AND(4<C25,C25<6),C25=6),'Contract Data'!$B$49*J25,IF(C25>6,'Contract Data'!$B$50*J25,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I25*Asphalt!D25/12)","v":0},{"$f":"IF(L25>0,VLOOKUP(L25,'Contract Data'!$A$20:$B$43,2,FALSE)*M25,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C26,C26<2),'Contract Data'!$B$47*J26,IF(OR(AND(2<C26,C26<4),C26=2,C26=4),'Contract Data'!$B$48*J26,IF(OR(AND(4<C26,C26<6),C26=6),'Contract Data'!$B$49*J26,IF(C26>6,'Contract Data'!$B$50*J26,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I26*Asphalt!D26/12)","v":0},{"$f":"IF(L26>0,VLOOKUP(L26,'Contract Data'!$A$20:$B$43,2,FALSE)*M26,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C27,C27<2),'Contract Data'!$B$47*J27,IF(OR(AND(2<C27,C27<4),C27=2,C27=4),'Contract Data'!$B$48*J27,IF(OR(AND(4<C27,C27<6),C27=6),'Contract Data'!$B$49*J27,IF(C27>6,'Contract Data'!$B$50*J27,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I27*Asphalt!D27/12)","v":0},{"$f":"IF(L27>0,VLOOKUP(L27,'Contract Data'!$A$20:$B$43,2,FALSE)*M27,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C28,C28<2),'Contract Data'!$B$47*J28,IF(OR(AND(2<C28,C28<4),C28=2,C28=4),'Contract Data'!$B$48*J28,IF(OR(AND(4<C28,C28<6),C28=6),'Contract Data'!$B$49*J28,IF(C28>6,'Contract Data'!$B$50*J28,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I28*Asphalt!D28/12)","v":0},{"$f":"IF(L28>0,VLOOKUP(L28,'Contract Data'!$A$20:$B$43,2,FALSE)*M28,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C29,C29<2),'Contract Data'!$B$47*J29,IF(OR(AND(2<C29,C29<4),C29=2,C29=4),'Contract Data'!$B$48*J29,IF(OR(AND(4<C29,C29<6),C29=6),'Contract Data'!$B$49*J29,IF(C29>6,'Contract Data'!$B$50*J29,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I29*Asphalt!D29/12)","v":0},{"$f":"IF(L29>0,VLOOKUP(L29,'Contract Data'!$A$20:$B$43,2,FALSE)*M29,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C30,C30<2),'Contract Data'!$B$47*J30,IF(OR(AND(2<C30,C30<4),C30=2,C30=4),'Contract Data'!$B$48*J30,IF(OR(AND(4<C30,C30<6),C30=6),'Contract Data'!$B$49*J30,IF(C30>6,'Contract Data'!$B$50*J30,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I30*Asphalt!D30/12)","v":0},{"$f":"IF(L30>0,VLOOKUP(L30,'Contract Data'!$A$20:$B$43,2,FALSE)*M30,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C31,C31<2),'Contract Data'!$B$47*J31,IF(OR(AND(2<C31,C31<4),C31=2,C31=4),'Contract Data'!$B$48*J31,IF(OR(AND(4<C31,C31<6),C31=6),'Contract Data'!$B$49*J31,IF(C31>6,'Contract Data'!$B$50*J31,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I31*Asphalt!D31/12)","v":0},{"$f":"IF(L31>0,VLOOKUP(L31,'Contract Data'!$A$20:$B$43,2,FALSE)*M31,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C32,C32<2),'Contract Data'!$B$47*J32,IF(OR(AND(2<C32,C32<4),C32=2,C32=4),'Contract Data'!$B$48*J32,IF(OR(AND(4<C32,C32<6),C32=6),'Contract Data'!$B$49*J32,IF(C32>6,'Contract Data'!$B$50*J32,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I32*Asphalt!D32/12)","v":0},{"$f":"IF(L32>0,VLOOKUP(L32,'Contract Data'!$A$20:$B$43,2,FALSE)*M32,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C33,C33<2),'Contract Data'!$B$47*J33,IF(OR(AND(2<C33,C33<4),C33=2,C33=4),'Contract Data'!$B$48*J33,IF(OR(AND(4<C33,C33<6),C33=6),'Contract Data'!$B$49*J33,IF(C33>6,'Contract Data'!$B$50*J33,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I33*Asphalt!D33/12)","v":0},{"$f":"IF(L33>0,VLOOKUP(L33,'Contract Data'!$A$20:$B$43,2,FALSE)*M33,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C34,C34<2),'Contract Data'!$B$47*J34,IF(OR(AND(2<C34,C34<4),C34=2,C34=4),'Contract Data'!$B$48*J34,IF(OR(AND(4<C34,C34<6),C34=6),'Contract Data'!$B$49*J34,IF(C34>6,'Contract Data'!$B$50*J34,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I34*Asphalt!D34/12)","v":0},{"$f":"IF(L34>0,VLOOKUP(L34,'Contract Data'!$A$20:$B$43,2,FALSE)*M34,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C35,C35<2),'Contract Data'!$B$47*J35,IF(OR(AND(2<C35,C35<4),C35=2,C35=4),'Contract Data'!$B$48*J35,IF(OR(AND(4<C35,C35<6),C35=6),'Contract Data'!$B$49*J35,IF(C35>6,'Contract Data'!$B$50*J35,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I35*Asphalt!D35/12)","v":0},{"$f":"IF(L35>0,VLOOKUP(L35,'Contract Data'!$A$20:$B$43,2,FALSE)*M35,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C36,C36<2),'Contract Data'!$B$47*J36,IF(OR(AND(2<C36,C36<4),C36=2,C36=4),'Contract Data'!$B$48*J36,IF(OR(AND(4<C36,C36<6),C36=6),'Contract Data'!$B$49*J36,IF(C36>6,'Contract Data'!$B$50*J36,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I36*Asphalt!D36/12)","v":0},{"$f":"IF(L36>0,VLOOKUP(L36,'Contract Data'!$A$20:$B$43,2,FALSE)*M36,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C37,C37<2),'Contract Data'!$B$47*J37,IF(OR(AND(2<C37,C37<4),C37=2,C37=4),'Contract Data'!$B$48*J37,IF(OR(AND(4<C37,C37<6),C37=6),'Contract Data'!$B$49*J37,IF(C37>6,'Contract Data'!$B$50*J37,0))))","v":0},{"$f":"F37*G37","v":0},0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I37*Asphalt!D37/12)","v":0},{"$f":"IF(L37>0,VLOOKUP(L37,'Contract Data'!$A$20:$B$43,2,FALSE)*M37,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C38,C38<2),'Contract Data'!$B$47*J38,IF(OR(AND(2<C38,C38<4),C38=2,C38=4),'Contract Data'!$B$48*J38,IF(OR(AND(4<C38,C38<6),C38=6),'Contract Data'!$B$49*J38,IF(C38>6,'Contract Data'!$B$50*J38,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I38*Asphalt!D38/12)","v":0},{"$f":"IF(L38>0,VLOOKUP(L38,'Contract Data'!$A$20:$B$43,2,FALSE)*M38,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C39,C39<2),'Contract Data'!$B$47*J39,IF(OR(AND(2<C39,C39<4),C39=2,C39=4),'Contract Data'!$B$48*J39,IF(OR(AND(4<C39,C39<6),C39=6),'Contract Data'!$B$49*J39,IF(C39>6,'Contract Data'!$B$50*J39,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I39*Asphalt!D39/12)","v":0},{"$f":"IF(L39>0,VLOOKUP(L39,'Contract Data'!$A$20:$B$43,2,FALSE)*M39,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C40,C40<2),'Contract Data'!$B$47*J40,IF(OR(AND(2<C40,C40<4),C40=2,C40=4),'Contract Data'!$B$48*J40,IF(OR(AND(4<C40,C40<6),C40=6),'Contract Data'!$B$49*J40,IF(C40>6,'Contract Data'!$B$50*J40,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I40*Asphalt!D40/12)","v":0},{"$f":"IF(L40>0,VLOOKUP(L40,'Contract Data'!$A$20:$B$43,2,FALSE)*M40,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C41,C41<2),'Contract Data'!$B$47*J41,IF(OR(AND(2<C41,C41<4),C41=2,C41=4),'Contract Data'!$B$48*J41,IF(OR(AND(4<C41,C41<6),C41=6),'Contract Data'!$B$49*J41,IF(C41>6,'Contract Data'!$B$50*J41,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I41*Asphalt!D41/12)","v":0},{"$f":"IF(L41>0,VLOOKUP(L41,'Contract Data'!$A$20:$B$43,2,FALSE)*M41,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C42,C42<2),'Contract Data'!$B$47*J42,IF(OR(AND(2<C42,C42<4),C42=2,C42=4),'Contract Data'!$B$48*J42,IF(OR(AND(4<C42,C42<6),C42=6),'Contract Data'!$B$49*J42,IF(C42>6,'Contract Data'!$B$50*J42,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I42*Asphalt!D42/12)","v":0},{"$f":"IF(L42>0,VLOOKUP(L42,'Contract Data'!$A$20:$B$43,2,FALSE)*M42,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C43,C43<2),'Contract Data'!$B$47*J43,IF(OR(AND(2<C43,C43<4),C43=2,C43=4),'Contract Data'!$B$48*J43,IF(OR(AND(4<C43,C43<6),C43=6),'Contract Data'!$B$49*J43,IF(C43>6,'Contract Data'!$B$50*J43,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I43*Asphalt!D43/12)","v":0},{"$f":"IF(L43>0,VLOOKUP(L43,'Contract Data'!$A$20:$B$43,2,FALSE)*M43,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C44,C44<2),'Contract Data'!$B$47*J44,IF(OR(AND(2<C44,C44<4),C44=2,C44=4),'Contract Data'!$B$48*J44,IF(OR(AND(4<C44,C44<6),C44=6),'Contract Data'!$B$49*J44,IF(C44>6,'Contract Data'!$B$50*J44,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I44*Asphalt!D44/12)","v":0},{"$f":"IF(L44>0,VLOOKUP(L44,'Contract Data'!$A$20:$B$43,2,FALSE)*M44,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C45,C45<2),'Contract Data'!$B$47*J45,IF(OR(AND(2<C45,C45<4),C45=2,C45=4),'Contract Data'!$B$48*J45,IF(OR(AND(4<C45,C45<6),C45=6),'Contract Data'!$B$49*J45,IF(C45>6,'Contract Data'!$B$50*J45,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I45*Asphalt!D45/12)","v":0},{"$f":"IF(L45>0,VLOOKUP(L45,'Contract Data'!$A$20:$B$43,2,FALSE)*M45,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C46,C46<2),'Contract Data'!$B$47*J46,IF(OR(AND(2<C46,C46<4),C46=2,C46=4),'Contract Data'!$B$48*J46,IF(OR(AND(4<C46,C46<6),C46=6),'Contract Data'!$B$49*J46,IF(C46>6,'Contract Data'!$B$50*J46,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I46*Asphalt!D46/12)","v":0},{"$f":"IF(L46>0,VLOOKUP(L46,'Contract Data'!$A$20:$B$43,2,FALSE)*M46,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C47,C47<2),'Contract Data'!$B$47*J47,IF(OR(AND(2<C47,C47<4),C47=2,C47=4),'Contract Data'!$B$48*J47,IF(OR(AND(4<C47,C47<6),C47=6),'Contract Data'!$B$49*J47,IF(C47>6,'Contract Data'!$B$50*J47,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I47*Asphalt!D47/12)","v":0},{"$f":"IF(L47>0,VLOOKUP(L47,'Contract Data'!$A$20:$B$43,2,FALSE)*M47,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C48,C48<2),'Contract Data'!$B$47*J48,IF(OR(AND(2<C48,C48<4),C48=2,C48=4),'Contract Data'!$B$48*J48,IF(OR(AND(4<C48,C48<6),C48=6),'Contract Data'!$B$49*J48,IF(C48>6,'Contract Data'!$B$50*J48,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I48*Asphalt!D48/12)","v":0},{"$f":"IF(L48>0,VLOOKUP(L48,'Contract Data'!$A$20:$B$43,2,FALSE)*M48,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C49,C49<2),'Contract Data'!$B$47*J49,IF(OR(AND(2<C49,C49<4),C49=2,C49=4),'Contract Data'!$B$48*J49,IF(OR(AND(4<C49,C49<6),C49=6),'Contract Data'!$B$49*J49,IF(C49>6,'Contract Data'!$B$50*J49,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I49*Asphalt!D49/12)","v":0},{"$f":"IF(L49>0,VLOOKUP(L49,'Contract Data'!$A$20:$B$43,2,FALSE)*M49,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C50,C50<2),'Contract Data'!$B$47*J50,IF(OR(AND(2<C50,C50<4),C50=2,C50=4),'Contract Data'!$B$48*J50,IF(OR(AND(4<C50,C50<6),C50=6),'Contract Data'!$B$49*J50,IF(C50>6,'Contract Data'!$B$50*J50,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I50*Asphalt!D50/12)","v":0},{"$f":"IF(L50>0,VLOOKUP(L50,'Contract Data'!$A$20:$B$43,2,FALSE)*M50,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C51,C51<2),'Contract Data'!$B$47*J51,IF(OR(AND(2<C51,C51<4),C51=2,C51=4),'Contract Data'!$B$48*J51,IF(OR(AND(4<C51,C51<6),C51=6),'Contract Data'!$B$49*J51,IF(C51>6,'Contract Data'!$B$50*J51,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I51*Asphalt!D51/12)","v":0},{"$f":"IF(L51>0,VLOOKUP(L51,'Contract Data'!$A$20:$B$43,2,FALSE)*M51,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C52,C52<2),'Contract Data'!$B$47*J52,IF(OR(AND(2<C52,C52<4),C52=2,C52=4),'Contract Data'!$B$48*J52,IF(OR(AND(4<C52,C52<6),C52=6),'Contract Data'!$B$49*J52,IF(C52>6,'Contract Data'!$B$50*J52,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I52*Asphalt!D52/12)","v":0},{"$f":"IF(L52>0,VLOOKUP(L52,'Contract Data'!$A$20:$B$43,2,FALSE)*M52,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C53,C53<2),'Contract Data'!$B$47*J53,IF(OR(AND(2<C53,C53<4),C53=2,C53=4),'Contract Data'!$B$48*J53,IF(OR(AND(4<C53,C53<6),C53=6),'Contract Data'!$B$49*J53,IF(C53>6,'Contract Data'!$B$50*J53,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I53*Asphalt!D53/12)","v":0},{"$f":"IF(L53>0,VLOOKUP(L53,'Contract Data'!$A$20:$B$43,2,FALSE)*M53,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C54,C54<2),'Contract Data'!$B$47*J54,IF(OR(AND(2<C54,C54<4),C54=2,C54=4),'Contract Data'!$B$48*J54,IF(OR(AND(4<C54,C54<6),C54=6),'Contract Data'!$B$49*J54,IF(C54>6,'Contract Data'!$B$50*J54,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I54*Asphalt!D54/12)","v":0},{"$f":"IF(L54>0,VLOOKUP(L54,'Contract Data'!$A$20:$B$43,2,FALSE)*M54,0)","v":0}]
[null,null,null,null,false,null,null,{"$f":"IF(AND(0<C55,C55<2),'Contract Data'!$B$47*J55,IF(OR(AND(2<C55,C55<4),C55=2,C55=4),'Contract Data'!$B$48*J55,IF(OR(AND(4<C55,C55<6),C55=6),'Contract Data'!$B$49*J55,IF(C55>6,'Contract Data'!$B$50*J55,0))))","v":0},0,0,0,null,{"$f":"Asphalt!$I$2/100*(Asphalt!$I$1*62.4/2000)*(Asphalt!I55*Asphalt!D55/12)","v":0},{"$f":"IF(L55>0,VLOOKUP(L55,'Contract Data'!$A$20:$B$43,2,FALSE)*M55,0)","v":0}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I5:I55)","v":0},{"$f":"ROUND(SUM(J5:J55),1)","v":0},{"$f":"ROUND(SUM(K5:K55),0)","v":0},null,{"$f":"ROUND(SUM(M5:M55),1)","v":0}]
[null,null,"Total $",null,null,null,null,{"$f":"SUM(H5:H55)","v":0},null,null,{"$f":"K56*'Contract Data'!B44","v":0},null,null,{"$f":"SUM(N5:N55)","v":0},null,null,null,null,{"$f":"SUM(S5:S18)","v":0},null,null,null,null,{"$f":"SUM(X5:X7)","v":0},{"$f":"SUM(X57,S57,N57,K57,H57)","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:",{"$f":"'Contract Data'!H2","v":0},{"$f":"W58*Y57","v":0}]

{"sheet":"Class C Partial","index":4,"n_rows":60,"n_cols":21,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,false,null,"Anticipated Density",92]
[]
["Log Mile","Lane (Driving/Passing)","Mill \n(in)","Replace\n(in)","Tack Coat","Length","Width","Sq Ft","Sq Yds of \nRemoval","Tons of \nMaterial","Tack Coat \nTotal","Quantity","Traffic Control","Price","TC Total",null,"Quantity","Mobilization","Price","Mob Total"]
[null,null,null,null,false,null,null,{"$f":"F5*G5","v":0},{"$f":"H5/9","v":0},{"$f":"$K$2/100*H5*D5/12*62.4/2000","v":0},{"$f":"IF(E5=TRUE,0.1*I5,0)","v":0},null,null,{"$f":"IF(M5>0,VLOOKUP(M5,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},{"$f":"L5*N5","v":0},null,null,null,{"$f":"IF(R5>0,VLOOKUP(R5,'Contract Data'!$A$52:$B$56,2,FALSE),0)","v":0},{"$f":"S5*Q5","v":0}]
[null,null,null,null,false,null,null,{"$f":"F6*G6","v":0},{"$f":"H6/9","v":0},{"$f":"$K$2/100*H6*D6/12*62.4/2000","v":0},{"$f":"IF(E6=TRUE,0.1*I6,0)","v":0},null,null,{"$f":"IF(M6>0,VLOOKUP(M6,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},{"$f":"L6*N6","v":0},null,null,null,{"$f":"IF(R6>0,VLOOKUP(R6,'Contract Data'!$A$52:$B$56,2,FALSE),0)","v":0},{"$f":"S6*Q6","v":0}]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M7>0,VLOOKUP(M7,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0,null,null,null,{"$f":"IF(R7>0,VLOOKUP(R7,'Contract Data'!$A$52:$B$56,2,FALSE),0)","v":0},{"$f":"S7*Q7","v":0}]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M8>0,VLOOKUP(M8,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M9>0,VLOOKUP(M9,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M10>0,VLOOKUP(M10,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M11>0,VLOOKUP(M11,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M12>0,VLOOKUP(M12,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M13>0,VLOOKUP(M13,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M14>0,VLOOKUP(M14,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M15>0,VLOOKUP(M15,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M16>0,VLOOKUP(M16,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0,null,null,{"$f":"IF(M17>0,VLOOKUP(M17,'Contract Data'!$A$57:$B$72,2,FALSE),0)","v":0},0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,false,null,null,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H5:H57)","v":0},{"$f":"ROUND(SUM(I5:I57),1)","v":0},{"$f":"ROUND(SUM(J5:J57),1)","v":0},{"$f":"ROUND(SUM(K5:K57),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I58*'Contract Data'!B46","v":0},{"$f":"J58*'Contract Data'!B45","v":0},{"$f":"K58*'Contract Data'!B44","v":0},null,null,null,{"$f":"SUM(O5:O17)","v":0},null,null,null,null,{"$f":"SUM(T5:T7)","v":0},{"$f":"SUM(T59+O59+K59+J59+I59)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment Factor:",null,{"$f":"IF(R60>0,VLOOKUP(R60,'Contract Data'!$G$2:$H$3,2,FALSE),0)","v":0},{"$f":"S60*U59","v":0}]

{"sheet":"GIS Data","index":5,"n_rows":28,"n_cols":5,"rows_kept":28,"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,"Base Rock Supplier:"]
[]
[null,"Lane #:",null,null,"Mix ID Used:"]
[]
[null,"MM:",null,null,"Final Cost of Repair:"]
[]
[null,"Direction:"]
[]
[null,"WO #:"]
[]
[]
[]
[null,null,"Milling Thickness"]
[]
[null,null,"Asphalt Temperature:"]
[]
[null,null,"Ambient Temperature:"]
[]
[null,null,"Thickness of Mix:"]
[]
[null,null,"Tack:"]