{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["LookUp Tables","Instructions","Basic Price Adjustment","Data","Order Details","Vendor Totals","Order Summary","PJ-101","FIELD"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":95,"comments":4,"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":"LookUp Tables","index":0,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":true,"merged":[[6,0,6,1],[14,0,14,1],[21,0,21,1],[27,0,27,1]]}
[]
["Override",null,null,"Activity",null,null,null,"County","Number","District",null,"Supplemental Code",null,null,"District",null,"Other Override",null,"Project Description",null,null,"Vendor","Oasis ID"]
[0,"NO",null,"A1","Section 401 Base I",1,null,"Barbour",1,7,null,"00","Not Applicable",null,1,null,"Yes",null,"Preservation",null,null,"AAA PAVING AND SEALING INC","DOT20*41"]
[1,"YES",null,"A2","Section 401 25mm Superpave",2,null,"Berkeley",2,"05",null,"01","Alternate",null,2,null,"No",null,"Minor Rehabilitation",null,null,"BELT PAVING INC","DOT20*40"]
[null,null,null,"A3","Section 401 Base II",3,null,"Boone",3,"01",null,"02","Wye",null,3,null,null,null,"Major Rehabilitation",null,null,"CAMDEN MATERIALS LLC","DOT20*42"]
[null,null,null,"A4","Section 401 Patch & Level",4,null,"Braxton",4,"07",null,"03","Spur",null,4,null,"Other Override",null,"Reconstruction",null,null,"CAST & BAKER CORP","DOT20*43"]
["Sign System",null,null,"A5","Section 401 Wearing IV",5,null,"Brooke",5,"06",null,"04","North",null,5,null,1,null,null,null,null,"C WILLIAM HETZER INC","DOT20*44"]
["I",1,null,"A6","Section 402 Wearing IV",6,null,"Cabell",6,"02",null,"05","South",null,6,null,0,null,null,null,null,"GREENBRIER EXCAVATING & PAVING","DOT20*45"]
["US",2,null,"A7","Section 401 19mm Superpave",7,null,"Calhoun",7,"03",null,"06","East",null,7,null,null,null,null,null,null,"GREER INDUSTRIES INC","DOT20*46"]
["WV",3,null,"A8","Section 401 Scratch Course",8,null,"Clay",8,"01",null,"07","West",null,8,null,null,null,null,null,null,"JEFFERSON ASPHALT PRODUCTS CO","DOT20*47"]
["CO",4,null,"A9","Section 402 9.5mm Superpave",9,null,"Doddridge",9,"04",null,"08","Business",null,9,null,null,null,null,null,null,"J F ALLEN CO","DOT20*48"]
["PF",6,null,"A10","Section 401 Wearing I",10,null,"Fayette",10,"09",null,"09","North Bound(Business)",null,10,null,null,null,null,null,null,"KELLY PAVING INC","DOT20*49"]
["HA",8,null,"A11","Section 402 Wearing I",11,null,"Gilmer",11,"07",null,"10","South Bound(Business)",null,null,null,null,null,null,null,null,"KLUG BROS CO","DOT20*50"]
[null,null,null,"A12","Section 401 4.75mm Superpave",12,null,"Grant",12,"05",null,"11","East Bound(Business)",null,null,null,"Override List",null,null,null,null,"MEADOWS STONE & PAVING INC","DOT20*51"]
["AF Table",null,null,"A13","Section 402 4.75mm Superpave",13,null,"Greenbrier",13,"09",null,"12","West Bound(Business)",null,null,null,"Vendor A",null,null,null,null,"NEW ENTERPRISE STONE & LIME CO INC","DOT20*52"]
[0,0,null,"A14","Section 401 Wearing III",14,null,"Hampshire",14,"05",null,"13","Truck Route",null,null,null,"Vendor B",null,null,null,null,"NLS PAVING INC","DOT20*53"]
[250,1,null,"A15","Section 402 Wearing III",15,null,"Hancock",15,"06",null,"14","Bypass",null,null,null,"Vendor C",null,null,null,null,"P & W EXCAVATING INC","DOT20*54"]
[1000,2,null,"P","Asphalt Section 401 - 12.5mm Superpave",16,null,"Hardy",16,"05",null,"15","Loop",null,null,null,"Vendor D",null,null,null,null,"STONE ASPHALT LLC","DOT20*55"]
[2500,3,null,"Q","Asphalt Section 402 - 12.5mm Superpave",17,null,"Harrison",17,"04",null,"16","Toll",null,null,null,"Vendor E",null,null,null,null,"W L CONSTRUCTION & PAVING INC.","DOT20*56"]
[5000,4,null,"R","Plant Run",18,null,"Jackson",18,"03",null,"17","Ramp",null,null,null,"Vendor F",null,null,null,null,"WV PAVING INC","DOT20*57"]
[null,null,null,"S1","Surcharge for PG64H-22 Binder",19,null,"Jefferson",19,"05",null,"18","Other",null,null,null,"Vendor G"]
["S Table",null,null,"S2","Surcharge for PG64E-22 Binder",20,null,"Kanawha",20,"01",null,"19","City Streets - Non-State",null,null,null,"Vendor H"]
[0,0,null,"S3","ESAL Surcharge - 3 million to 20 million ESALs",21,null,"Lewis",21,"07",null,"20","Roads Under Construction",null,null,null,"Vendor I"]
[1000,1,null,"S4","ESAL Surcharge - Greater than 20 million ESALs",22,null,"Lincoln",22,"02",null,"21","Footbridges",null,null,null,"Vendor J"]
[2000,2,null,"T1","Off Season first day",23,null,"Logan",23,"02",null,"22","Historical Bridges",null,null,null,"Vendor K"]
[3000,3,null,"T2","Off Season additional day",24,null,"McDowell",24,"10",null,null,null,null,null,null,"Vendor L"]
[null,null,null,"T3","Base 1 Shoulder Paving         201 to 500",31,null,"Marion",25,"04",null,null,null,null,null,null,"Vendor M"]
["TUW Table",null,null,"T4","Base 1 Shoulder Paving         500+",32,null,"Marshall",26,"06",null,null,null,null,null,null,"Vendor N"]
[0,0,null,"U1","Base 2 Shoulder Paving         0 to 100",33,null,"Mason",27,"01",null,null,null,null,null,null,"Vendor O"]
[100,1,null,"U2","Base 2 Shoulder Paving         101 to 200",34,null,"Mercer",28,"10",null,null,null,null,null,null,"Vendor P"]
[200,2,null,"U3","Base 2 Shoulder Paving         201 to 500",35,null,"Mineral",29,"05",null,null,null,null,null,null,"Vendor Q"]
[500,3,null,"U4","Base 2 Shoulder Paving         500+",36,null,"Mingo",30,"02",null,null,null,null,null,null,"Vendor R"]
[null,null,null,"V1","Haul first ton mile",37,null,"Monongalia",31,"04",null,null,null,null,null,null,"Vendor S"]
[null,null,null,"V2","Haul each additional mile",38,null,"Monroe",32,"09",null,null,null,null,null,null,"Vendor T"]
[null,null,null,"W1","Lay Down 0 to 100 tons",39,null,"Morgan",33,"05",null,null,null,null,null,null,"Vendor U"]
[null,null,null,"W2","Lay Down 101 to 200 tons",40,null,"Nicholas",34,"09",null,null,null,null,null,null,"Vendor V"]
[null,null,null,"W3","Lay Down 201 to 500 tons",41,null,"Ohio",35,"06",null,null,null,null,null,null,"Vendor W"]
[null,null,null,"W4","Lay Down 500 and up",42,null,"Pendleton",36,"08",null,null,null,null,null,null,"Vendor X"]
[null,null,null,"X","Cleaning & Sweeping",43,null,"Pleasants",37,"03",null,null,null,null,null,null,"Vendor Y"]
[null,null,null,"Y","Bituminous Material",44,null,"Pocahontas",38,"08",null,null,null,null,null,null,"Vendor Z"]
[null,null,null,"Z","Daytime Paving mobilization",45,null,"Preston",39,"04",null,null,null,null,null,null,"Vendor AA"]
[null,null,null,"AA","Nighttime Paving Mobilization",46,null,"Putnam",40,"01",null,null,null,null,null,null,"Vendor AB"]
[null,null,null,"AB1","Off Season first day",47,null,"Raleigh",41,"10",null,null,null,null,null,null,"Vendor AC"]
[null,null,null,"AB2","Off Season additional day",48,null,"Randolph",42,"08",null,null,null,null,null,null,"Vendor AD"]
[null,null,null,"AC","Additional Heel-In Joints",49,null,"Ritchie",43,"03",null,null,null,null,null,null,"Vendor AE"]
[null,null,null,"AD","Skip Paving Surcharge",50,null,"Roane",44,"03"]
[null,null,null,"AE","Mobilization for Profiling",51,null,"Summers",45,"09"]
[null,null,null,"AF1","Milling Less than 250",52,null,"Taylor",46,"04"]
[null,null,null,"AF2","Milling 250 less than 500",53,null,"Tucker",47,"08"]
[null,null,null,"AF3","Milling 500 less than 1000",54,null,"Tyler",48,"06"]
[null,null,null,"AF4","Milling 1000 less than 2500",55,null,"Upshur",49,"07"]
[null,null,null,"AF5","Milling 2500 less than 5000",56,null,"Wayne",50,"02"]
[null,null,null,"AF6","Milling 5000 and greater",57,null,"Webster",51,"07"]
[null,null,null,"AG","Pilot w/Driver",58,null,"Wetzel",52,"06"]
[null,null,null,"AH","Traffic Control",59,null,"Wirt",53,"03"]
[null,null,null,"AI","Flagger",60,null,"Wood",54,"03"]
[null,null,null,"AJ","Arrow Board",61,null,"Wyoming",55,"10"]
[null,null,null,"AK","Rumble Strips",62]
[null,null,null,"AL","Mobilization for rumble strips",63]
[null,null,null,"AM","Pavement Repair",64]
[null,null,null,"AN","Surcharge for Parking Lot",65]

{"sheet":"Instructions","index":1,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Instructions"]
["1. Go to 'Order Details' sheet\n(Note: all dark green boxes indicate a user input area, all cells containing a note have red indicators in top right corner, scroll over to display note)\n(Note: some cells contain drop down lists for selections, choose a selection from the list, do not type in entry)"]
["2. Select a county from the drop down menu"]
["3. Select the \"Get Bidders\" button"]
["4. Select the \"Clear Data\" button to clear any existing, old data in the sheet"]
["5. Enter the route information into the Route box"]
["6. Enter the beginning mile post (BMP), end mile post (EMP), longitude, latitude, and a beginning and end item description "]
["7. Enter the length, average width, average thickness, and total number of lanes"]
["8. Enter the average shoulder width, excavation depth, and average shoulder thickness along with selecting a Project Title and providing a Project Description"]
["9. Under \"Item Quantities,\" enter each quantity into the green blank\n(Note: if no quantity is needed of a certain item, can either enter 0 or leave blank)\n(Note: the sheet will automatically generate estimated asphalt quantities, however)"]
["10. View the 'Vendor Totals' sheet for a complete cost breakdown of each company, bid prices for each item,  and lowest bidder"]
["11. The 'Vendor Totals' sheet will display the lowest, complete bid; meaning the vendor has a bid for each of the input quantities needed. "]
["12. View the 'Order Summary' sheet for a complete list of unit bid prices for the lowest bidder from the 'Vendor Totals' sheet. "]
["13. If you'd like to perform a maual override selection of a vendor from the available group of vendors that is not the lowest bidder, you can do so on the 'Order Summary' sheet"]
["14. To perform a manual override pick a vendor using the drop down box at the top of the 'Order Summary' sheet, the data below will then be automatically filled in and a total will be displayed at the bottom. \n(Note: vendor identifications are found at the top of the 'Vendor Totals' sheet)"]
["15. To go back and display the lowest bidder on the 'Order Summary' sheet simply select the blank box from the drop down box on the sheet "]
["16. The 'Order Summary' sheet is fit to a single page for printing ease"]
["17. The PJ-101 form is automatically filled in with data from the 'Order Details' sheet and can either be completed in excel or printed and completed by hand by filling in all green spaces"]
["18. The Field Personnel sheet is also filled in automatically with quantities and project data and can either completed in excel or printed out for completion"]

{"sheet":"Basic Price Adjustment","index":2,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["2024 Hot Mix Asphalt Contract (Material and Pickup by WVDOH Forces Only)"]
["Unit Bid Price Adjustment"]
[" ",null,"Asphalt","Fuel"]
["Asphalt Price Index at Month of Bid Opening October 2023, Ib","Fuel Price Index at Month of Bid Opening October 2023, Ib",605,3.3066]
[{"$f":"'[3]Basic Price Adjustment'!$A5","v":"(Enter Month of Record) 2024 Price Index, Ip"},{"$f":"A5","v":"(Enter Month of Record) 2024 Price Index, Ip"},{"$f":"'[3]Basic Price Adjustment'!$C5","v":0},{"$f":"'[3]Basic Price Adjustment'!$D5","v":0},null,"Monthly Fuel/Asphalt Price Link"]
[null,null,null," "]
[" ",null," "]
["Asphalt Cement Content, AC",null," "]
[" ",null," "]
[1,"Section 401 - Base I",{"$f":"3.9/100","v":3.9E-2}]
[2,"Section 401 - 25mm Superpave",{"$f":"4.4/100","v":4.4000000000000004E-2}]
[3,"Section 401 - Base II",{"$f":"5/100","v":0.05}]
[4,"Section 401 - Patch & Level",{"$f":"5/100","v":0.05}]
[5,"Section 401 - Wearing IV",{"$f":"5.2/100","v":5.2000000000000005E-2}]
[6,"Section 402 - Wearing IV",{"$f":"5.1/100","v":5.0999999999999997E-2}]
[7,"Section 401 - 19mm Superpave",{"$f":"4.7/100","v":4.7E-2}]
[8,"Section 401 - Scratch Course",{"$f":"6.2/100","v":6.2E-2}]
[9,"Section 402 - 9.5mm Superpave",{"$f":"6.1/100","v":6.0999999999999999E-2}]
[10,"Section 401 - Wearing I",{"$f":"6.1/100","v":6.0999999999999999E-2}]
[11,"Section 402 - Wearing I",{"$f":"6/100","v":0.06}]
[12,"Section 401 - 4.75mm Superpave",{"$f":"7.6/100","v":7.5999999999999998E-2}]
[13,"Section 402 - 4.75mm Superpave",{"$f":"7.2/100","v":7.2000000000000008E-2}]
[14,"Section 401 - Wearing III",{"$f":"7.3/100","v":7.2999999999999995E-2}]
[15,"Section 402 - Wearing III",{"$f":"7.5/100","v":7.4999999999999997E-2}]
[16,"Section 401 - 12.5mm Superpave",{"$f":"5.6/100","v":5.5999999999999994E-2}]
[17,"Section 402 - 12.5mm Superpave",{"$f":"5.6/100","v":5.5999999999999994E-2}]
[18,"Plant Run",{"$f":"5.7/100","v":5.7000000000000002E-2}]
[" ",null," "]
["The asphalt prices will be adjusted as follows:","The fuel prices will be adjusted as follows:"," "]
["(Ip - Ib) x AC / 100","(Ip/Ib - 1) x Ib x C","Where C=",0.43]
[" ",null," "]
["Adjustment to Price* at Bid Opening",null,"Asphalt","Fuel","Total"]
[1,"Section 401 - Base I",{"$f":"ROUND(($C$5-$C$4)*C10,2)","v":-23.6},{"$f":"ROUND((($D$5/$D$4)-1)*$D$4*0.43,2)","v":-1.42},{"$f":"C33+D33","v":-25.020000000000003}]
[2,"Section 401 - 25mm Superpave",-26.62,{"$f":"ROUND((($D$5/$D$4)-1)*$D$4*0.43,2)","v":-1.42},-28.04]
[3,"Section 401 - Base II",-30.25,-1.42,-31.67]
[4,"Section 401 - Patch & Level",-30.25,-1.42,-31.67]
[5,"Section 401 - Wearing IV",-31.46,-1.42,-32.880000000000003]
[6,"Section 402 - Wearing IV",-30.86,-1.42,-32.28]
[7,"Section 401 - 19mm Superpave",-28.44,-1.42,-29.86]
[8,"Section 401 - Scratch Course",-37.51,-1.42,-38.93]
[9,"Section 402 - 9.5mm Superpave",-36.909999999999997,-1.42,-38.33]
[10,"Section 401 - Wearing I",-36.909999999999997,-1.42,-38.33]
[11,"Section 402 - Wearing I",-36.299999999999997,-1.42,-37.72]
[12,"Section 401 - 4.75mm Superpave",-45.98,-1.42,-47.4]
[13,"Section 402 - 4.75mm Superpave",-43.56,-1.42,-44.980000000000004]
[14,"Section 401 - Wearing III",-44.17,-1.42,-45.59]
[15,"Section 402 - Wearing III",-45.38,-1.42,-46.800000000000004]
[16,"Section 401 - 12.5mm Superpave",-33.880000000000003,-1.42,-35.300000000000004]
[17,"Section 402 - 12.5mm Superpave",-33.880000000000003,-1.42,-35.300000000000004]
[18,"Plant Run",-34.49,-1.42,-35.910000000000004]
[]
[]
["*per ton of asphalt",null," "]
["If you prepare Receiving Reports, please click on the  District Tab below to get the correct adjusted Asphalt Price Index."]
[null,null,null,"   "]

{"sheet":"Data","index":3,"n_rows":201,"n_cols":31,"rows_kept":201,"cut":false,"hidden":true,"merged":[[1,0,1,3],[147,14,147,15],[247,7,247,8]]}
[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
["MASTER BID TABLE (Material)"]
["District","PID","Vendor","Location","Plant Location","City","State",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[1,101,"AMERICAN ASPHALT","2334 Rt 52, Kenova, WV 25530","KENOVA","Kenova","WV",73.989999999999995,74.989999999999995,76.95,76.95,77.680000000000007,84.41,77.25,84.56,89.03,84.56,88.83,110,110,105,110,89.11,89.11,84.56,5,12.5,0,0,3500,1000]
[1,102,"AMERICAN ASPHALT","484 Industrial Rd, St Albans, WV 25177","ST ALBANS","St Albans","WV",74.510000000000005,75.510000000000005,77.540000000000006,77.540000000000006,78.59,85.91,79.19,85.39,89.89,85.39,89.25,110,110,105,110,89.11,89.11,85.39,5,12.5,0,0,3500,1000]
[1,103,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[1,104,"JF ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[1,105,"JF ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[1,106,"JF ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[1,107,"MEADOWS STONE","OLD B&O RAILROAD YARD, GASSAWAY WV 26624","GASSAWAY","Gassaway","WV",72,79,77,77,77,92,79,80.5,82.5,80.5,100,112,124,110,121,80,102,80.5,8,12,5,10,3500,900]
[1,108,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[1,109,"WV PAVING","2902 Charles Ave Dunbar, WV 25064","DUNBAR","Dunbar","WV",85.5,85.5,87,87,89,0,90.5,94.5,106.5,94.5,103.5,0,0,112.5,0,102.5,102.5,94.5,4,12,2,5,4000,1500]
[1,110,"WV PAVING","Rt. 7 N, Gallipolis OH 45631","GALLIPOLIS","Gallipolis","OH",84,0,88,88,90,0,0,98,0,98,0,0,0,0,0,0,0,98,4,12,2,5,4000,1500]
[1,111,"WV PAVING","40222 Ohio River Road, Huntington, WV 25702","HUNTINGTON","Huntington","WV",84.75,84.75,88.5,88.5,90.5,100,89.5,98,108.5,98,107,0,0,0,0,104.5,104.5,98,4,12,2,5,4000,1500]
[1,112,"WV PAVING","Wright Road Poca, WV 25159","POCA","Poca","WV",85.5,85.5,87,87,89,0,90.5,94.5,106.5,94.5,103.5,0,0,112.5,0,102.5,102.5,94.5,4,12,2,5,4000,1500]
[1,113,"WV PAVING","2187 Ripley Rd, Ripley, WV 25271","RIPLEY","Ripley","WV",0,0,90,90,92,0,0,95.5,0,95.5,0,0,0,106,0,0,0,95.5,4,12,2,5,4000,1500]
[1,114,"WV PAVING","2816 Frontage Rd, Summersville, WV 26651","SUMMERSVILLE","Summersville","WV",94,94,98,98,100,0,98.5,108,110,108,110,0,0,117,0,105,105,108,4,12,2,5,4000,1500]
[2,201,"AMERICAN ASPHALT","2334 Rt 52, Kenova, WV 25530","KENOVA","Kenova","WV",73.989999999999995,74.989999999999995,76.95,76.95,77.680000000000007,84.41,77.25,84.56,89.03,84.56,88.83,110,110,105,110,89.11,89.11,84.56,5,12.5,0,0,3500,1000]
[2,202,"AMERICAN ASPHALT","484 Industrial Rd, St Albans, WV 25177","ST ALBANS","St Albans","WV",74.510000000000005,75.510000000000005,77.540000000000006,77.540000000000006,78.59,85.91,79.19,85.39,89.89,85.39,89.25,110,110,105,110,89.11,89.11,85.39,5,12.5,0,0,3500,1000]
[2,203,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[2,204,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[2,205,"JF ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[2,206,"JF ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[2,207,"JF ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[2,208,"WV PAVING","2902 Charles Ave Dunbar, WV 25064","DUNBAR","Dunbar","WV",85.5,85.5,87,87,89,0,90.5,94.5,106.5,94.5,103.5,0,0,112.5,0,102.5,102.5,94.5,4,12,2,5,4000,1500]
[2,209,"WV PAVING","Rt. 7 N, Gallipolis OH 45631","GALLIPOLIS","Gallipolis","OH",84,0,88,88,90,0,0,98,0,98,0,0,0,0,0,0,0,98,4,12,2,5,4000,1500]
[2,210,"WV PAVING","40222 Ohio River Road, Huntington, WV 25702","HUNTINGTON","Huntington","WV",84.75,84.75,88.5,88.5,90.5,100,89.5,98,108.5,98,107,0,0,0,0,104.5,104.5,98,4,12,2,5,4000,1500]
[2,211,"WV PAVING","Wright Road Poca, WV 25159","POCA","Poca","WV",85.5,85.5,87,87,89,0,90.5,94.5,106.5,94.5,103.5,0,0,112.5,0,102.5,102.5,94.5,4,12,2,5,4000,1500]
[2,212,"WV PAVING","US 119 Whitman Creek Rd., Whitman, WV 25652","WHITMAN","Whitman","WV",105.5,105.5,112,112,114,117.5,113.5,119.5,121.5,119.5,120.5,0,0,0,0,118.5,118.5,119.5,4,12,2,5,4000,1500]
[3,301,"GREER IND."," 2399 Benedum Dr, Bridgeport, WV 26330","CLARKSBURG","Bridgeport","WV",64,68.900000000000006,67,67,67,74.3,72,74.900000000000006,80.400000000000006,74.900000000000006,78.2,93.5,96,97,107,82.3,82.3,68,4.55,9.25,10,10,3500,850]
[3,302,"MEADOWS STONE ","OLD B&O RAILROAD YARD, GASSAWAY WV 26624","GASSAWAY","Gassaway","WV",71,78,76,76,76,91,78,79.5,81.5,79.5,99,111,123,109,120,79,101,79.5,8,12,5,10,3500,900]
[3,303,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[3,304,"CAMDEN MATERIALS","202 HICKORY ST PARKERSBURG WV 26101","PARKERSBURG","Parkersburg","WV",82.25,85.5,84.75,84.75,86,99.5,86,89,99.5,88.25,98.5,100.75,100.75,100.75,100.75,91,101.5,88.25,5,15,0.25,0.5,2500,500]
[3,305,"WV PAVING","Rt. 7 North, Gallipolis, Ohio  45631","GALLIPOLIS","Gallipolis","OH",84,0,88,88,90,0,0,98,0,98,0,0,0,0,0,0,0,98,4,12,2,5,4000,1500]
[3,306,"WV PAVING","2902 Charles Ave Dunbar, WV 25064","DUNBAR","Dunbar","WV",85.5,85.5,87,87,89,0,90.5,94.5,106.5,94.5,103.5,0,0,112.5,0,102.5,102.5,94.5,4,12,2,5,4000,1500]
[3,307,"WV PAVING","Wright Road Poca, WV 25159","POCA","Poca","WV",85.5,85.5,87,87,89,0,90.5,94.5,106.5,94.5,103.5,0,0,112.5,0,102.5,102.5,94.5,4,12,2,5,4000,1500]
[3,308,"WV PAVING","2187 Ripley Rd, Ripley, WV 25271","RIPLEY","Ripley","WV",0,0,90,90,92,0,0,95.5,0,95.5,0,0,0,106,0,0,0,95.5,4,12,2,5,4000,1500]
[3,309,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[3,310,"AMERICAN ASPHALT","484 Industrial Rd, St Albans, WV 25177","ST ALBANS","St Albans","WV",74.510000000000005,75.510000000000005,77.540000000000006,77.540000000000006,78.59,85.91,79.19,85.39,89.89,85.39,89.25,110,110,105,110,89.11,89.11,85.39,5,12.5,0,0,3500,1000]
[3,311,"JF ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[3,312,"J F ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[3,313,"J F ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[4,401,"GREER IND."," 2399 Benedum Dr, Bridgeport, WV 26330","CLARKSBURG","Bridgeport","WV",64,68.900000000000006,67,67,67,74.3,72,74.900000000000006,80.400000000000006,74.900000000000006,78.2,93.5,96,97,107,82.3,82.3,68,4.55,9.25,10,10,3500,850]
[4,402,"GREER IND.","442 Blaney Hollow Rd, Morgantown WV 26508","BUCKEYE","Morgantown","WV",55.2,61.7,60.35,60.35,60.35,68,62.5,69.099999999999994,75,69.099999999999994,73.5,90,95,81.5,89,72.8,72.8,60,4.55,9.25,1,3,3000,1500]
[4,403,"GREER IND."," 5630 Earl L. Core Rd Rt 7, Morgantown WV 26508","GREER","Morgantown","WV",55.2,61.7,60.35,60.35,60.35,68,62.5,69.099999999999994,75,69.099999999999994,73.5,90,95,81.5,89,72.8,72.8,60,4.55,9.25,1,3,3000,1500]
[4,404,"WV PAVING","Route 33,  Kelly Mountain Rd, Elkins, WV 26241","ELKINS","Elkins","WV",67.5,67.5,73.75,73.75,76,80,75,80.5,83,80.5,83,0,0,101,0,78.5,78.5,80.5,4,12,2,5,4000,1500]
[4,405,"CAMDEN MATERIALS","202 HICKORY ST PARKERSBURG WV 26101","PARKERSBURG","Parkersburg","WV",82.25,85.5,84.75,84.75,86,99.5,86,89,99.5,88.25,98.5,100.75,100.75,100.75,100.75,91,101.5,88.25,5,15,0.25,0.5,2500,500]
[4,406,"STONE ASPHALT","164 VIP Drive Masontown, WV 26542","MASONTOWN","Masontown","WV",60.85,60.85,63.15,63.15,62.7,64.099999999999994,66.849999999999994,69.8,72.95,69.8,70.8,102.5,106,79.75,82.35,69.25,70.900000000000006,62.7,6.9,11.4,0,0,3000,2000]
[4,407,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[4,408,"JF ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[4,409,"J F ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[4,410,"J F ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[4,411,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[5,501,"BELT PAVING","11269 Waxler Rd, Keyser WV 26726","KEYSER","Keyser","WV",65.5,68,70.25,70.25,73,85,71.5,76.25,86,76,82,86.5,101,86.25,99,79.5,83,76,4.75,14.5,1.25,1.75,6850,4350]
[5,502,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[5,503,"WL CONTRUCTION","390 Pedal Car Drive, Inwood, WV 25428","INWWOD","Inwood","WV",63.5,69.849999999999994,70.599999999999994,70.599999999999994,71.3,75.400000000000006,74.7,78,95.5,78,82,0,0,0,0,83.3,84,78,5,12,4,10,4500,1500]
[5,504,"WL CONTRUCTION","57 Blair Rd, Harpers Ferry WV 25425","MILLEVILLE","Harpers Ferry","WV",66.2,71,73.2,73.2,73.8,75.400000000000006,77.7,79.8,93.5,79.8,82.7,0,0,0,0,84.5,85,79.8,5,12,4,10,4500,1500]
[5,505,"WL CONTRUCTION","866 Oranda Rd., Strasburg VA 22657","CLEARBROOK","Strasburg","VA",63.5,78.5,70.599999999999994,70.599999999999994,71.3,76.5,79.25,78,95,78,84.7,0,0,0,0,88,95.5,78,5,12,4,10,4500,1500]
[5,506,"WL CONTRUCTION","660 Quarry Lane Clearbrook VA 22624","CLEARBROOK","Clearbrook","VA",63.5,78.5,70.599999999999994,70.599999999999994,71.3,76.5,79.25,78,95,78,84.7,0,0,0,0,88,95.5,78,5,12,4,10,4500,1500]
[5,507,"JF ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[5,508,"JF ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[5,509,"JF ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[5,510,"P&W Excavating","Warfordsburg, PA 17267","WARFORDSBURG","Warfordsburg","PA",69.5,67.2,70.599999999999994,70.599999999999994,70.599999999999994,80.5,70.5,77.3,0,77.3,85.3,0,0,0,0,0,81.95,77.3,5,15,5,15,9000,3000]
[5,511,"STUART M PERRY","117 Limestone Lane, Winchester, VA 22602","Winchester - Berryville - Front Royal","W-117 Limesone Lane \nB-426 Quarry Road \nFR - 711 Riverton Road","VA, WV",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,78,0,0,0,0,0,0]
[5,512,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[5,513,"C WILLIAM HETZER INC","10104 Mapleville Road\nHagerstown, MD 21740","C WILLIAM HETZER INC","Hagerstown","MD",56.5,61.4,63.5,63.5,63.5,66.8,63.5,72.7,72.7,72.7,76,82.9,86.9,82.9,86.9,70.599999999999994,73.900000000000006,73,2,11,2,4,5000,1500]
[5,514,"NEW ENTERPRISE","3587 Stone Quarry Rd Chamersburg PA 17201","CHAMERSBURG","Chamersburg","PA",70,70,75,75,90,100,80,90,90,90,100,105,115,115,125,90,100,90,8,8,0,0,8000,4000]
[5,515,"NEW ENTERPRISE","526 Ashcom Rd Everett  PA 15537","ASHCOM PLANT","Everett","PA",70,70,75,75,90,100,80,90,90,90,100,105,115,115,125,90,100,90,8,8,0,0,8000,4000]
[5,516,"WV PAVING","Greenland Gap Rd, Scherr, WV 26726","SCHERR","Scherr","WV",71.5,71.5,79.5,79.5,81.5,93,79,84,97,84,97,0,0,104,0,99,99,84,4,12,2,5,4000,1500]
[6,601,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[6,602,"GREER IND.","442 Blaney Hollow Rd, Morgantown WV 26508","BUCKEYE","Morgantown","WV",55.2,61.7,60.35,60.35,60.35,68,62.5,69.099999999999994,75,69.099999999999994,73.5,90,95,81.5,89,72.8,72.8,60,4.55,9.25,1,3,3000,1500]
[6,603,"GREER IND."," 5630 Earl L. Core Rd Rt 7, Morgantown WV 26508","GREER","Morgantown","WV",55.2,61.7,60.35,60.35,60.35,68,62.5,69.099999999999994,75,69.099999999999994,73.5,90,95,81.5,89,72.8,72.8,60,4.55,9.25,1,3,3000,1500]
[6,604,"GREER IND."," 2399 Benedum Dr, Bridgeport, WV 26330","CLARKSBURG","Bridgeport","WV",64,68.900000000000006,67,67,67,74.3,72,74.900000000000006,80.400000000000006,74.900000000000006,78.2,93.5,96,97,107,82.3,82.3,68,4.55,9.25,10,10,3500,850]
[6,605,"J F ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[6,606,"J F ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[6,607,"J F ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[6,608,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[6,609,"KELLY PAVING ","#1 IND PARK DR BENWOOD WV 26031","BENWOOD","Benwood","WV",72,74,70,72,73,74,73,77,83,75,82,0,0,95,0,78,87,78,10,12,0.25,0.5,6000,1200]
[6,610,"KELLY PAVING ","4260 FREEDOM WAY WEIRTON WV 26062","WEIRTON","Weirton","WV",77,78,77,78,77,86,80,84,89,84,89,0,0,102,0,81,88,84,10,12,0.25,0.5,6000,1200]
[6,611,"KLUG BROS","State Rt 2 S. Lafayette Ave. Moundsville, WV","MOUNDSVILLE","Moundsville","WV",78.900000000000006,0,78.900000000000006,78.900000000000006,79.099999999999994,0,0,86.95,0,86.95,93.45,0,0,103.95,0,0,0,86.25,0,0,0,0,1200,800]
[6,612,"KLUG BROS","Foot of Wetzel St. New Martinsville, WV","NEW MARTINSVILLE","New Martinsville","WV",78.900000000000006,0,78.900000000000006,78.900000000000006,79.099999999999994,0,0,86.95,0,86.95,93.45,0,0,103.95,0,0,0,86.25,0,0,0,0,1200,800]
[6,613,"NLS PAVING ","1422 Co HWY 7F Toronto Ohio 43964","EMPIRE","Toronto","OH",73,75,75,75,78,81,80,84,85,81,91,98,0,100,101,81,90,84,10.5,12,0,2,5500,1500]
[6,614,"STONE ASPHALT","164 VIP Drive Masontown, WV 26542","MASONTOWN","Masontown","WV",60.85,60.85,63.15,63.15,62.7,64.099999999999994,66.849999999999994,69.8,72.95,69.8,70.8,102.5,106,79.75,82.35,69.25,70.900000000000006,62.7,6.9,11.4,0,0,3000,2000]
[6,615,"WILSON BLACKTOP","102 CENTER ST MARTINS FERRY OH","MARTINS FERRY","Martins Ferry","OH",73,75,74,74,75,85,75,80,82,80,90,100,110,100,110,90,95,80,0,0,25,25,6500,1500]
[7,701,"AMERICAN ASPHALT","484 Industrial Rd, St Albans, WV 25177","ST ALBANS PLANT","St Albans","WV",74.510000000000005,75.510000000000005,77.540000000000006,77.540000000000006,78.59,85.91,79.19,85.39,89.89,85.39,89.25,110,110,105,110,89.11,89.11,85.39,5,12.5,0,0,3500,1000]
[7,702,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg ","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[7,703,"GREER IND."," 5630 Earl L. Core Rd Rt 7, Morgantown WV 26508","GREER","Morgantown","WV",55.2,61.7,60.35,60.35,60.35,68,62.5,69.099999999999994,75,69.099999999999994,73.5,90,95,81.5,89,72.8,72.8,60,4.55,9.25,1,3,3000,1500]
[7,704,"GREER IND.","442 Blaney Hollow Rd, Morgantown WV 26508","BUCKEYE","Morgantown","WV",55.2,61.7,60.35,60.35,60.35,68,62.5,69.099999999999994,75,69.099999999999994,73.5,90,95,81.5,89,72.8,72.8,60,4.55,9.25,1,3,3000,1500]
[7,705,"GREER IND."," 2399 Benedum Dr, Bridgeport, WV 26330","CLARKSBURG","Bridgeport","WV",64,68.900000000000006,67,67,67,74.3,72,74.900000000000006,80.400000000000006,74.900000000000006,78.2,93.5,96,97,107,82.3,82.3,68,4.55,9.25,10,10,3500,850]
[7,706,"J F ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[7,707,"J F ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[7,708,"J F ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[7,709,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[7,710,"MEADOWS STONE ","OLD B&O RAILROAD YARD, GASSAWAY WV 26624","GASSAWAY","Gassaway","WV",71,78,76,76,76,91,78,79.5,81.5,79.5,99,111,123,109,120,79,101,79.5,8,12,5,10,3500,900]
[7,711,"MEADOWS STONE ","3401 POINT MOUNTAIN RD GASSAWAY WV 26624","MONTERVILLE ","Valley Head","WV",61,67,65,65,65,86,68,72.5,74.5,72.5,92,94,115,93,119,72,96,72.5,8,12,5,10,3500,900]
[7,712,"STONE ASPHALT","164 VIP Drive Masontown, WV 26542","MASONTOWN","Masontown","WV",60.85,60.85,63.15,63.15,62.7,64.099999999999994,66.849999999999994,69.8,72.95,69.8,70.8,102.5,106,79.75,82.35,69.25,70.900000000000006,62.7,6.9,11.4,0,0,3000,2000]
[7,713,"WV PAVING","Route 33,  Kelly Mountain Rd, Elkins, WV 26241","ELKINS","Elkins","WV",67.5,67.5,73.75,73.75,76,80,75,80.5,83,80.5,83,0,0,101,0,78.5,78.5,80.5,4,12,2,5,4000,1500]
[7,714,"WV PAVING","2816 Frontage Rd, Summersville, WV 26651","SUMMERSVILLE","Summersville","WV",94,94,98,98,100,0,98.5,108,110,108,110,0,0,117,0,105,105,108,4,12,2,5,4000,1500]
[8,801,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[8,802,"GREER IND."," 5630 Earl L. Core Rd Rt 7, Morgantown WV 26508","GREER","Morgantown","WV",55.2,61.7,60.35,60.35,60.35,68,62.5,69.099999999999994,75,69.099999999999994,73.5,90,95,81.5,89,72.8,72.8,60,4.55,9.25,1,3,3000,1500]
[8,803,"GREER IND.","442 Blaney Hollow Rd, Morgantown WV 26508","BUCKEYE","Morgantown","WV",55.2,61.7,60.35,60.35,60.35,68,62.5,69.099999999999994,75,69.099999999999994,73.5,90,95,81.5,89,72.8,72.8,60,4.55,9.25,1,3,3000,1500]
[8,804,"GREER IND."," 2399 Benedum Dr, Bridgeport, WV 26330","CLARKSBURG","Bridgeport","WV",64,68.900000000000006,67,67,67,74.3,72,74.900000000000006,80.400000000000006,74.900000000000006,78.2,93.5,96,97,107,82.3,82.3,68,4.55,9.25,10,10,3500,850]
[8,805,"J F ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[8,806,"J F ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[8,807,"J F ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[8,808,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[8,809,"MEADOWS STONE ","OLD B&O RAILROAD YARD, GASSAWAY WV 26624","GASSAWAY","Gassaway","WV",71,78,76,76,76,91,78,79.5,81.5,79.5,99,111,123,109,120,79,101,79.5,8,12,5,10,3500,900]
[8,810,"MEADOWS STONE ","3401 POINT MOUNTAIN RD GASSAWAY WV 26624","MONTERVILLE ","Valley Head","WV",61,67,65,65,65,86,68,72.5,74.5,72.5,92,94,115,93,119,72,96,72.5,8,12,5,10,3500,900]
[8,811,"STONE ASPHALT","164 VIP Drive Masontown, WV 26542","MASONTOWN","Masontown","WV",60.85,60.85,63.15,63.15,62.7,64.099999999999994,66.849999999999994,69.8,72.95,69.8,70.8,102.5,106,79.75,82.35,69.25,70.900000000000006,62.7,6.9,11.4,0,0,3000,2000]
[8,812,"WV PAVING","Route 33,  Kelly Mountain Rd, Elkins, WV 26241","ELKINS","Elkins","WV",67.5,67.5,73.75,73.75,76,80,75,80.5,83,80.5,83,0,0,101,0,78.5,78.5,80.5,4,12,2,5,4000,1500]
[8,813,"WV PAVING","Greenland Gap Rd, Scherr, WV 26726","SCHERR","Scherr","WV",71.5,71.5,79.5,79.5,81.5,93,79,84,97,84,97,0,0,104,0,99,99,84,4,12,2,5,4000,1500]
[8,814,"WV PAVING","Rt. 60, West Lewisburg Asbury, WV  24916","ALTA","Lewisburg","WV",85.75,85.75,92,92,94,0,92.5,97.5,108.25,97.5,108.25,0,0,0,0,105,105,97.5,4,12,2,5,4000,1500]
[9,901,"AAA PAVING ","560 TURNPIKE IND PARK RD, PRINCETON WV","PRINCETON ","Princeton","WV",65,0,75,75,75,0,75,77,90,78,86,0,0,0,0,0,0,78,5,12,0.01,0.01,3500,1000]
[9,902,"AMERICAN ASPHALT","484 Industrial Rd, St Albans, WV 25177","ST ALBANS ","St Albans","WV",74.510000000000005,75.510000000000005,77.540000000000006,77.540000000000006,78.59,85.91,79.19,85.39,89.89,85.39,89.25,110,110,105,110,89.11,89.11,85.39,5,12.5,0,0,3500,1000]
[9,903,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[9,904,"J F ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[9,905,"J F ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[9,906,"J F ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[9,907,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[9,908,"MEADOWS STONE ","OLD B&O RAILROAD YARD, GASSAWAY WV 26624","GASSAWAY","Gassaway","WV",72,79,77,77,77,92,79,80.5,82.5,80.5,100,112,124,110,121,80,102,80.5,8,12,5,10,3500,900]
[9,909,"MEADOWS STONE ","3401 POINT MOUNTAIN RD GASSAWAY WV 26624","MONTERVILLE","Valley Head","WV",62,68,66,66,66,87,69,73.5,73.5,73.5,93,95,116,94,120,73,97,72.5,8,12,5,10,3500,900]
[9,910,"WV PAVING","195 Southern Industrial Dr. Beaver, WV  25813","BEAVER","Beaver","WV",95.5,95.5,98.5,98.5,100.5,0,99.25,104.5,110,104.5,107,0,0,117,0,104,104,104.5,4,12,2,5,4000,1500]
[9,911,"WV PAVING","Rt. 60, West Lewisburg Asbury, WV  24916","ALTA","Lewisburg","WV",85.75,85.75,92,92,94,0,92.5,97.5,108.25,97.5,108.25,0,0,0,0,105,105,97.5,4,12,2,5,4000,1500]
[9,912,"WV PAVING","2816 Frontage Rd, Summersville, WV 26651","SUMMERSVILLE","Summersville","WV",94,94,98,98,100,0,98.5,108,110,108,110,0,0,117,0,105,105,108,4,12,2,5,4000,1500]
[9,913,"WV PAVING","6941 Ingleside Dr Princeton, WV 24740","PRINCETON","Princeton","WV",76,76,85.5,85.5,87.5,0,86,88.5,102.5,88.5,101.5,0,0,0,0,100.5,100.5,88.5,4,12,2,5,4000,1500]
[9,914,"WV PAVING","2902 Charles Ave Dunbar, WV 25064","DUNBAR","Dunbar","WV",85.5,85.5,87,87,89,0,90.5,94.5,106.5,94.5,103.5,0,0,112.5,0,102.5,102.5,94.5,4,12,2,5,4000,1500]
[10,1001,"AAA PAVING","560 TURNPIKE IND PARK RD, PRINCETON WV","PRINCETON ","Princeton","WV",65,0,75,75,75,0,75,77,90,78,86,0,0,0,0,0,0,78,5,12,0.01,0.01,3500,1000]
[10,1002,"AMERICAN ASPHALT","484 Industrial Rd, St Albans, WV 25177","ST ALBANS","St Albans","WV",74.510000000000005,75.510000000000005,77.540000000000006,77.540000000000006,78.59,85.91,79.19,85.39,89.89,85.39,89.25,110,110,105,110,89.11,89.11,85.39,5,12.5,0,0,3500,1000]
[10,1003,"AMERICAN ASPHALT","2334 Rt 52, Kenova, WV 25530","KENOVA ","Kenova","WV",73.989999999999995,74.989999999999995,76.95,76.95,77.680000000000007,84.41,77.25,84.56,89.03,84.56,88.83,110,110,105,110,89.11,89.11,84.56,5,12.5,0,0,3500,1000]
[10,1004,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901","LEWISBURG","Lewisburg ","WV",62.32,0,72.87,72.87,73.61,0,0,76.180000000000007,0,75.92,84.55,0,0,0,0,0,0,75.92,0,0,0,0,3000,750]
[10,1005,"J F ALLEN","3105 Harrison Ave., Elkins WV 26257","ELKINS","Elkins","WV",63.28,62.87,68.45,68.45,69.510000000000005,72.37,68.45,77.23,77.97,75.37,77.97,86,87.6,87.63,91.28,77.510000000000005,80.84,77.08,4.75,12.5,10,10,3500,1500]
[10,1006,"J F ALLEN","320 Alcon Rd, Buckhannon, WV 26201","BUCKHANNON","Buckhannon","WV",68.95,72.88,73.2,73.2,73.41,77.09,73.2,78.08,82.92,78.08,83.06,97.95,100.45,94.46,97.68,83.71,86.38,77.739999999999995,4.75,12.5,10,10,3500,1500]
[10,1007,"J F ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330","SALTWELL","Bridgeport","WV",69.64,73.33,73.33,73.33,73.41,77.09,73.33,78.08,82.92,78.08,83.06,104.95,107.59,103.17,104.2,87.08,89.67,79.64,4.75,12.5,10,10,3500,1500]
[10,1008,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170","PLANT 14","St Marys","WV",80,86,84,84,85,96,86,90,100,90,95,0,0,98,0,92,100,90,6,15,0.3,0.45,5000,500]
[10,1009,"WV PAVING","195 Southern Industrial Dr. Beaver, WV  25813","BEAVER","Beaver","WV",95.5,95.5,98.5,98.5,100.5,0,99.25,104.5,110,104.5,107,0,0,117,0,104,104,104.5,4,12,2,5,4000,1500]
[10,1010,"WV PAVING","US 119 Whitman Creek Rd., Whitman, WV 25652","WHITMAN","Whitman","WV",105.5,105.5,112,112,114,117.5,113.5,119.5,121.5,119.5,120.5,0,0,0,0,118.5,118.5,119.5,4,12,2,5,4000,1500]
[10,1011,"WV PAVING","6941 Ingleside Dr Princeton, WV 24740","PRINCETON","Princeton","WV",76,76,85.5,85.5,87.5,0,86,88.5,102.5,88.5,101.5,0,0,0,0,100.5,100.5,88.5,4,12,2,5,4000,1500]
[]
[]
[]
[]
[]
[null,"00",null,"Not Applicable"]
[null,"01",null,"Alternate"]
[null,"02",null,"Wye"]
[null,"03",null,"Spur"]
[null,"04",null,"North",null,null,null,null,null,"Barbour","01","07"]
[null,"05",null,"South",null,null,null,null,null,"Berkeley","02","05",null,null,"Sign System"]
[null,"06",null,"East",null,null,null,null,null,"Boone","03","01",null,null,"I",1]
[null,"07",null,"West",null,null,null,null,null,"Braxton","04","07",null,null,"US",2]
[null,"08",null,"Business",null,null,null,null,null,"Brooke","05","06",null,null,"WV",3]
[null,"09",null,"North Bound(Business)",null,null,null,null,null,"Cabell","06","02",null,null,"CO",4]
[null,"10",null,"South Bound(Business)",null,null,null,null,null,"Calhoun","07","03",null,null,"PF",6]
[null,"11",null,"East Bound(Business)",null,null,null,null,null,"Clay","08","01",null,null,"HA",8]
[null,"12",null,"West Bound(Business)",null,null,null,null,null,"Doddridge","09","04"]
[null,"13",null,"Truck Route",null,null,null,null,null,"Fayette","10","09"]
[null,"14",null,"Bypass",null,null,null,null,null,"Gilmer","11","07"]
[null,"15",null,"Loop",null,null,null,null,null,"Grant","12","05"]
[null,"16",null,"Toll",null,null,null,null,null,"Greenbrier","13","09"]
[null,"17",null,"Ramp",null,null,null,null,null,"Hampshire","14","05"]
[null,"18",null,"Other",null,null,null,null,null,"Hancock","15","06"]
[null,"19",null,"City Streets - Non-State",null,null,null,null,null,"Hardy","16","05"]
[null,"20",null,"Roads Under Construction",null,null,null,null,null,"Harrison","17","04"]
[null,"21",null,"Footbridges",null,null,null,null,null,"Jackson","18","03"]
[null,"22",null,"Historical Bridges",null,null,null,null,null,"Jefferson","19","05"]
[null,null,null,null,null,null,null,null,null,"Kanawha","20","01"]
[null,null,null,null,null,null,null,null,null,"Lewis","21","07"]
[null,"Yes",null,null,null,null,null,null,null,"Lincoln","22","02"]
[null,"No",null,null,null,null,null,null,null,"Logan","23","02"]
[null,null,null,null,null,null,null,null,null,"McDowell","24","10"]
[null,"Vendor A",null,null,null,null,null,null,null,"Marion","25","04"]
[null,"Vendor B",null,null,null,null,null,null,null,"Marshall","26","06"]
[null,"Vendor C",null,null,null,null,null,null,null,"Mason","27","01"]
[null,"Vendor D",null,null,null,null,null,null,null,"Mercer","28","10"]
[null,"Vendor E",null,null,null,null,null,null,null,"Mineral","29","05"]
[null,"Vendor F",null,null,null,null,null,null,null,"Mingo","30","02"]
[null,"Vendor G",null,null,null,null,null,null,null,"Monongalia","31","04"]
[null,"Vendor H",null,null,null,null,null,null,null,"Monroe","32","09"]
[null,"Vendor I",null,null,null,null,null,null,null,"Morgan","33","05"]
[null,"Vendor J",null,null,null,null,null,null,null,"Nicholas","34","09"]
[null,"Vendor K",null,null,null,null,null,null,null,"Ohio","35","06"]
[null,"Vendor L",null,null,null,null,null,null,null,"Pendleton","36","08"]
[null,"Vendor M",null,null,null,null,null,null,null,"Pleasants","37","03"]
[null,"Vendor N",null,null,null,null,null,null,null,"Pocahontas","38","08"]
[null,"Vendor O",null,null,null,null,null,null,null,"Preston","39","04"]
[null,"Vendor P",null,null,null,null,null,null,null,"Putnam","40","01"]
[null,"Vendor Q",null,null,null,null,null,null,null,"Raleigh","41","10"]
[null,"Vendor R",null,null,null,null,null,null,null,"Randolph","42","08"]
[null,null,null,null,null,null,null,null,null,"Ritchie","43","03"]
[null,null,null,null,null,null,null,null,null,"Roane","44","03"]
[null,null,null,null,null,null,null,null,null,"Summers","45","09"]
[null,null,null,null,null,null,null,null,null,"Taylor","46","04"]
[null,null,null,null,null,null,null,null,null,"Tucker","47","08"]
[null,null,null,null,null,null,null,null,null,"Tyler","48","06"]
[null,null,null,null,null,null,null,null,null,"Upshur","49","07"]
[null,null,null,null,null,null,null,null,null,"Wayne","50","02"]
[null,null,null,null,null,null,null,null,null,"Webster","51","07"]
[null,null,null,null,null,null,null,null,null,"Wetzel","52","06"]
[null,null,null,null,null,null,null,null,null,"Wirt","53","03"]
[null,null,null,null,null,null,null,null,null,"Wood","54","03"]
[null,null,null,null,null,null,null,null,null,"Wyoming","55","10"]

{"sheet":"Order Details","index":4,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["HOT-LAID BITUMINOUS CONCRETE PROJECT COST"]
[null,"County",null,"District",null,null,null,null,"Estimated Asphalt Quantities",null,"Unit(s)"]
[null,"Berkeley",null,{"$f":"VLOOKUP(B3,County,3,FALSE)","v":"05"},null,null,null,null,"HMA Required for Pavement",{"$f":"E24*B26*110/2000","v":0},"TONS"]
[null,null,null,null,null,null,null,null,"HMA Required for Shoulders",{"$f":"E28*B30*110/2000","v":0},"TONS"]
[]
["Sign",null,null,"BMP",null,null,null,"Item","Description","Quantity","Unit(s)"]
["Route",null,null,"EMP",null,null,null,1,"Asphalt Section 401 - Base I",1,"Ton",null,"Potential Vendors"]
["Subroute",null,null,null,null,null,null,2,"Asphalt Section 401 - 25mm Superpave",null,"Ton",null,"PID","Vendor","Plant Location"]
["Supplemental Designation",null,null,null,null,null,null,3,"Asphalt Section 401 - Base II",null,"Ton",null,501,"BELT PAVING","11269 Waxler Rd, Keyser WV 26726"]
["Designation",{"$f":"VLOOKUP($B$9,'LookUp Tables'!SAList,2)","v":{"$error":"#N/A"}},null,null,null,null,null,4,"Asphalt Section 401 - Patch and Level",null,"Ton",null,502,"GREENBRIER EXCAVATING","232 Rambler Rd, Lewisburg, WV 24901"]
[null,null,null,null,null,null,null,5,"Asphalt Section 401 - Wearing IV",null,"Ton",null,503,"WL CONTRUCTION","390 Pedal Car Drive, Inwood, WV 25428"]
["Route ID Builder Link: ",null,null,null,null,null,null,6,"Asphalt Section 402 - Wearing IV",null,"Ton",null,504,"WL CONTRUCTION","57 Blair Rd, Harpers Ferry WV 25425"]
["GIS Route ID",null,null,null,null,null,null,7,"Asphalt Section 401 - 19mm Superpave",null,"Ton",null,505,"WL CONTRUCTION","866 Oranda Rd., Strasburg VA 22657"]
["Begin",null,null,null,null,null,null,8,"Asphalt Section 401 - Scratch Course",null,"Ton",null,506,"WL CONTRUCTION","660 Quarry Lane Clearbrook VA 22624"]
["End",null,null,null,null,null,null,9,"Asphalt Section 402 - 9.5mm Superpave",null,"Ton",null,507,"JF ALLEN","3105 Harrison Ave., Elkins WV 26257"]
["Project Location",null,null,null,null,null,null,10,"Asphalt Section 401 - Wearing 1",null,"Ton",null,508,"JF ALLEN","320 Alcon Rd, Buckhannon, WV 26201"]
["Project Type",null,null,null,null,null,null,11,"Asphalt Section 402 - Wearing 1",null,"Ton",null,509,"JF ALLEN","5856 Saltwell Rd, Bridgeport, WV 26330"]
["Project Description",null,null,null,null,null,null,12,"Asphalt Section 401 - 4.75mm Superpave",null,"Ton",null,510,"P&W Excavating","Warfordsburg, PA 17267"]
["Agency Release No.:",null,null,null,null,null,null,13,"Asphalt Section 402 - 4.75mm Superpave",null,"Ton",null,511,"STUART M PERRY","117 Limestone Lane, Winchester, VA 22602"]
["Project #",null,null,null,null,null,null,14,"Asphalt Section 401 - Wearing III",null,"Ton",null,512,"KELLY PAVING ","123 Dodd Drive, St. Marys WV 26170"]
["Authorization #",null,null,null,null,null,null,15,"Asphalt Section 402 - Wearing III",null,"Ton",null,513,"C WILLIAM HETZER INC","10104 Mapleville Road\nHagerstown, MD 21740"]
[null,null,null,null,null,null,null,16,"Asphalt Section 401 - 12.5mm Superpave",null,"Ton",null,514,"NEW ENTERPRISE","3587 Stone Quarry Rd Chamersburg PA 17201"]
["Paving",null,null,null,"Area",null,null,17,"Asphalt Section 402 - 12.5mm Superpave",null,"Ton",null,515,"NEW ENTERPRISE","526 Ashcom Rd Everett  PA 15537"]
["Length",null,"Miles",">>>>>>>>",{"$f":"B24*1760*B25/3","v":0},"Square Yards",null,18,"Asphalt Plant Run ",null,"Ton",null,516,"WV PAVING","Greenland Gap Rd, Scherr, WV 26726"]
["Average Width",null,"Feet",null,{"$f":"B27*B24","v":0},"Lane Miles",null,19,"Surcharge for PG Binder - 64H minus 22",null,"Ton"]
["Average Thickness",null,"Inches",null,null,null,null,20,"Surcharge for PG Binder - 64E minus 22 - ordered in 400 ton increments",null,"Ton"]
["Lanes",null,null,null,"Area",null,null,21,"ESAL Surcharge - 3 million to 20 million ESALs",null,"Ton"]
["Shoulder Excavation Depth",null,"Inches",">>>>>>>",{"$f":"B24*1760*B29/3","v":0},"Square Yards",null,22,"ESAL Surcharge - Greater than 20 million ESALs",null,"Ton"]
["Avg Shoulder Width",null,"Feet",null,null,null,null,23,"Off-Season Plant Opening - First Day",null,"Day"]
["Avg Shoulder Thickness",null,"Inches",null,null,null,null,24,"Off-Season Plant Opening - Each Additional Day",null,"Days"]

{"sheet":"Vendor Totals","index":5,"n_rows":32,"n_cols":81,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,73,1,74],[1,37,1,38],[1,41,1,42],[1,45,1,46],[1,49,1,50],[1,53,1,54],[1,57,1,58],[1,61,1,62],[1,65,1,66],[1,69,1,70],[1,21,1,22],[1,25,1,26],[1,29,1,30],[1,33,1,34],[0,1,1,1],[1,5,1,6],[1,9,1,10],[1,13,1,14],[1,17,1,18]]}
[null,"Lowest\nBid",{"$f":"SMALL(CB8:CB25,COUNTIF(CB8:CB25,0)+1)","v":31.479999999999997}]
[null,null,{"$f":"VLOOKUP(B3,'Order Details'!_xlnm.Extract,2,0)","v":"C WILLIAM HETZER INC"},null,null,"Vendor A",null,null,null,"Vendor B",null,null,null,"Vendor C",null,null,null,"Vendor D",null,null,null,"Vendor E",null,null,null,"Vendor F",null,null,null,"Vendor G",null,null,null,"Vendor H",null,null,null,"Vendor I",null,null,null,"Vendor J",null,null,null,"Vendor K",null,null,null,"Vendor L",null,null,null,"Vendor M",null,null,null,"Vendor N",null,null,null,"Vendor O",null,null,null,"Vendor P",null,null,null,"Vendor Q",null,null,null,"Vendor R"]
[null,{"$f":"VLOOKUP(C1,CB8:CC25,2,0)","v":513},{"$f":"VLOOKUP(B3,'Order Details'!_xlnm.Extract,3,0)","v":"10104 Mapleville Road\nHagerstown, MD 21740"},null,null,{"$f":"H3","v":501},null,{"$f":"'Order Details'!$M9","v":501},null,{"$f":"L3","v":502},null,{"$f":"'Order Details'!$M10","v":502},null,{"$f":"P3","v":503},null,{"$f":"'Order Details'!$M11","v":503},null,{"$f":"T3","v":504},null,{"$f":"'Order Details'!$M12","v":504},null,{"$f":"X3","v":505},null,{"$f":"'Order Details'!$M13","v":505},null,{"$f":"AB3","v":506},null,{"$f":"'Order Details'!$M14","v":506},null,{"$f":"AF3","v":507},null,{"$f":"'Order Details'!$M15","v":507},null,{"$f":"AJ3","v":508},null,{"$f":"'Order Details'!$M16","v":508},null,{"$f":"AN3","v":509},null,{"$f":"'Order Details'!$M17","v":509},null,{"$f":"AR3","v":510},null,{"$f":"'Order Details'!$M18","v":510},null,{"$f":"AV3","v":511},null,{"$f":"'Order Details'!$M19","v":511},null,{"$f":"AZ3","v":512},null,{"$f":"'Order Details'!$M20","v":512},null,{"$f":"BD3","v":513},null,{"$f":"'Order Details'!$M21","v":513},null,{"$f":"BH3","v":514},null,{"$f":"'Order Details'!$M22","v":514},null,{"$f":"BL3","v":515},null,{"$f":"'Order Details'!$M23","v":515},null,{"$f":"BP3","v":516},null,{"$f":"'Order Details'!$M24","v":516},null,{"$f":"BT3","v":0},null,{"$f":"'Order Details'!$M25","v":0},null,{"$f":"BX3","v":0},null,{"$f":"'Order Details'!$M26","v":0}]
[null,null,null,null,null,{"$f":"'Order Details'!$N9","v":"BELT PAVING"},null,null,null,{"$f":"'Order Details'!$N10","v":"GREENBRIER EXCAVATING"},null,null,null,{"$f":"'Order Details'!$N11","v":"WL CONTRUCTION"},null,null,null,{"$f":"'Order Details'!$N12","v":"WL CONTRUCTION"},null,null,null,{"$f":"'Order Details'!$N13","v":"WL CONTRUCTION"},null,null,null,{"$f":"'Order Details'!$N14","v":"WL CONTRUCTION"},null,null,null,{"$f":"'Order Details'!$N15","v":"JF ALLEN"},null,null,null,{"$f":"'Order Details'!$N16","v":"JF ALLEN"},null,null,null,{"$f":"'Order Details'!$N17","v":"JF ALLEN"},null,null,null,{"$f":"'Order Details'!$N18","v":"P&W Excavating"},null,null,null,{"$f":"'Order Details'!$N19","v":"STUART M PERRY"},null,null,null,{"$f":"'Order Details'!$N20","v":"KELLY PAVING "},null,null,null,{"$f":"'Order Details'!$N21","v":"C WILLIAM HETZER INC"},null,null,null,{"$f":"'Order Details'!$N22","v":"NEW ENTERPRISE"},null,null,null,{"$f":"'Order Details'!$N23","v":"NEW ENTERPRISE"},null,null,null,{"$f":"'Order Details'!$N24","v":"WV PAVING"},null,null,null,{"$f":"'Order Details'!$N25","v":0},null,null,null,{"$f":"'Order Details'!$N26","v":0}]
[null,null,null,null,null,{"$f":"'Order Details'!$O9","v":"11269 Waxler Rd, Keyser WV 26726"},null,null,null,{"$f":"'Order Details'!$O10","v":"232 Rambler Rd, Lewisburg, WV 24901"},null,null,null,{"$f":"'Order Details'!$O11","v":"390 Pedal Car Drive, Inwood, WV 25428"},null,null,null,{"$f":"'Order Details'!$O12","v":"57 Blair Rd, Harpers Ferry WV 25425"},null,null,null,{"$f":"'Order Details'!$O13","v":"866 Oranda Rd., Strasburg VA 22657"},null,null,null,{"$f":"'Order Details'!$O14","v":"660 Quarry Lane Clearbrook VA 22624"},null,null,null,{"$f":"'Order Details'!$O15","v":"3105 Harrison Ave., Elkins WV 26257"},null,null,null,{"$f":"'Order Details'!$O16","v":"320 Alcon Rd, Buckhannon, WV 26201"},null,null,null,{"$f":"'Order Details'!$O17","v":"5856 Saltwell Rd, Bridgeport, WV 26330"},null,null,null,{"$f":"'Order Details'!$O18","v":"Warfordsburg, PA 17267"},null,null,null,{"$f":"'Order Details'!$O19","v":"117 Limestone Lane, Winchester, VA 22602"},null,null,null,{"$f":"'Order Details'!$O20","v":"123 Dodd Drive, St. Marys WV 26170"},null,null,null,{"$f":"'Order Details'!$O21","v":"10104 Mapleville Road\nHagerstown, MD 21740"},null,null,null,{"$f":"'Order Details'!$O22","v":"3587 Stone Quarry Rd Chamersburg PA 17201"},null,null,null,{"$f":"'Order Details'!$O23","v":"526 Ashcom Rd Everett  PA 15537"},null,null,null,{"$f":"'Order Details'!$O24","v":"Greenland Gap Rd, Scherr, WV 26726"},null,null,null,{"$f":"'Order Details'!$O25","v":0},null,null,null,{"$f":"'Order Details'!$O26","v":0}]
[null,null,null,null,null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(I32=\"Incomplete\",\"Incomplete\",SUM(H8:H31)),\"\")","v":40.479999999999997},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(M32=\"Incomplete\",\"Incomplete\",SUM(L8:L31)),\"\")","v":37.299999999999997},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(Q32=\"Incomplete\",\"Incomplete\",SUM(P8:P31)),\"\")","v":38.479999999999997},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(U32=\"Incomplete\",\"Incomplete\",SUM(T8:T31)),\"\")","v":41.18},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(Y32=\"Incomplete\",\"Incomplete\",SUM(X8:X31)),\"\")","v":38.479999999999997},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(AC32=\"Incomplete\",\"Incomplete\",SUM(AB8:AB31)),\"\")","v":38.479999999999997},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(AG32=\"Incomplete\",\"Incomplete\",SUM(AF8:AF31)),\"\")","v":38.26},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(AK32=\"Incomplete\",\"Incomplete\",SUM(AJ8:AJ31)),\"\")","v":43.93},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(AO32=\"Incomplete\",\"Incomplete\",SUM(AN8:AN31)),\"\")","v":44.62},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(AS32=\"Incomplete\",\"Incomplete\",SUM(AR8:AR31)),\"\")","v":44.48},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(AW32=\"Incomplete\",\"Incomplete\",SUM(AV8:AV31)),\"\")","v":"Incomplete"},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(BA32=\"Incomplete\",\"Incomplete\",SUM(AZ8:AZ31)),\"\")","v":54.98},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(BE32=\"Incomplete\",\"Incomplete\",SUM(BD8:BD31)),\"\")","v":31.479999999999997},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(BI32=\"Incomplete\",\"Incomplete\",SUM(BH8:BH31)),\"\")","v":44.98},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(BM32=\"Incomplete\",\"Incomplete\",SUM(BL8:BL31)),\"\")","v":44.98},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(BQ32=\"Incomplete\",\"Incomplete\",SUM(BP8:BP31)),\"\")","v":46.48},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(BU32=\"Incomplete\",\"Incomplete\",SUM(BT8:BT31)),\"\")","v":0},null,"PROJECT TOTAL",null,{"$f":"IFERROR(IF(BY32=\"Incomplete\",\"Incomplete\",SUM(BX8:BX31)),\"\")","v":0}]
[null,"Item","Description    ",null,"Quantity","Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted",null,"Unit $","Unit $ with Qty","Adjusted"]
[null,1,"Asphalt Section 401 - Base I",null,{"$f":"'Order Details'!J7","v":1},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,7,0),\"\")","v":65.5},{"$f":"IFERROR(F8*$E8,\"\")","v":65.5},{"$f":"IF(G8=0,0,IFERROR($E8*F8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":40.479999999999997},{"$f":"IF(AND($E8>0,F8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,7,0),\"\")","v":62.32},{"$f":"IFERROR(J8*$E8,\"\")","v":62.32},{"$f":"IF(K8=0,0,IFERROR($E8*J8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":37.299999999999997},{"$f":"IF(AND($E8>0,J8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,7,0),\"\")","v":63.5},{"$f":"IFERROR(N8*$E8,\"\")","v":63.5},{"$f":"IF(O8=0,0,IFERROR($E8*N8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":38.479999999999997},{"$f":"IF(AND($E8>0,N8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,7,0),\"\")","v":66.2},{"$f":"IFERROR(R8*$E8,\"\")","v":66.2},{"$f":"IF(S8=0,0,IFERROR($E8*R8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":41.18},{"$f":"IF(AND($E8>0,R8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,7,0),\"\")","v":63.5},{"$f":"IFERROR(V8*$E8,\"\")","v":63.5},{"$f":"IF(W8=0,0,IFERROR($E8*V8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":38.479999999999997},{"$f":"IF(AND($E8>0,V8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,7,0),\"\")","v":63.5},{"$f":"IFERROR(Z8*$E8,\"\")","v":63.5},{"$f":"IF(AA8=0,0,IFERROR($E8*Z8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":38.479999999999997},{"$f":"IF(AND($E8>0,Z8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,7,0),\"\")","v":63.28},{"$f":"IFERROR(AD8*$E8,\"\")","v":63.28},{"$f":"IF(AE8=0,0,IFERROR($E8*AD8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":38.26},{"$f":"IF(AND($E8>0,AD8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,7,0),\"\")","v":68.95},{"$f":"IFERROR(AH8*$E8,\"\")","v":68.95},{"$f":"IF(AI8=0,0,IFERROR($E8*AH8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":43.93},{"$f":"IF(AND($E8>0,AH8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,7,0),\"\")","v":69.64},{"$f":"IFERROR(AL8*$E8,\"\")","v":69.64},{"$f":"IF(AM8=0,0,IFERROR($E8*AL8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":44.62},{"$f":"IF(AND($E8>0,AL8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,7,0),\"\")","v":69.5},{"$f":"IFERROR(AP8*$E8,\"\")","v":69.5},{"$f":"IF(AQ8=0,0,IFERROR($E8*AP8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":44.48},{"$f":"IF(AND($E8>0,AP8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,7,0),\"\")","v":0},{"$f":"IFERROR(AT8*$E8,\"\")","v":0},{"$f":"IF(AU8=0,0,IFERROR($E8*AT8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":0},{"$f":"IF(AND($E8>0,AT8=0),\"Incomplete\",\"\")","v":"Incomplete"},{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,7,0),\"\")","v":80},{"$f":"IFERROR(AX8*$E8,\"\")","v":80},{"$f":"IF(AY8=0,0,IFERROR($E8*AX8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":54.98},{"$f":"IF(AND($E8>0,AX8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,7,0),\"\")","v":56.5},{"$f":"IFERROR(BB8*$E8,\"\")","v":56.5},{"$f":"IF(BC8=0,0,IFERROR($E8*BB8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":31.479999999999997},{"$f":"IF(AND($E8>0,BB8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,7,0),\"\")","v":70},{"$f":"IFERROR(BF8*$E8,\"\")","v":70},{"$f":"IF(BG8=0,0,IFERROR($E8*BF8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":44.98},{"$f":"IF(AND($E8>0,BF8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,7,0),\"\")","v":70},{"$f":"IFERROR(BJ8*$E8,\"\")","v":70},{"$f":"IF(BK8=0,0,IFERROR($E8*BJ8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":44.98},{"$f":"IF(AND($E8>0,BJ8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,7,0),\"\")","v":71.5},{"$f":"IFERROR(BN8*$E8,\"\")","v":71.5},{"$f":"IF(BO8=0,0,IFERROR($E8*BN8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":46.48},{"$f":"IF(AND($E8>0,BN8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,7,0),\"\")","v":""},{"$f":"IFERROR(BR8*$E8,\"\")","v":""},{"$f":"IF(BS8=0,0,IFERROR($E8*BR8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":""},{"$f":"IF(AND($E8>0,BR8=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,7,0),\"\")","v":""},{"$f":"IFERROR(BV8*$E8,\"\")","v":""},{"$f":"IF(BW8=0,0,IFERROR($E8*BV8+($E8*'Basic Price Adjustment'!$E33),\"\"))","v":""},{"$f":"IF(AND($E8>0,BV8=0),\"Incomplete\",\"\")","v":""},null,null,{"$f":"H$6","v":40.479999999999997},{"$f":"H$3","v":501}]
[null,2,"Asphalt Section 401 - 25mm Superpave",null,{"$f":"'Order Details'!J8","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,8,0),\"\")","v":68},{"$f":"IFERROR(F9*$E9,\"\")","v":0},{"$f":"IF(G9=0,0,IFERROR($E9*F9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,F9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,8,0),\"\")","v":0},{"$f":"IFERROR(J9*$E9,\"\")","v":0},{"$f":"IF(K9=0,0,IFERROR($E9*J9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,J9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,8,0),\"\")","v":69.849999999999994},{"$f":"IFERROR(N9*$E9,\"\")","v":0},{"$f":"IF(O9=0,0,IFERROR($E9*N9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,N9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,8,0),\"\")","v":71},{"$f":"IFERROR(R9*$E9,\"\")","v":0},{"$f":"IF(S9=0,0,IFERROR($E9*R9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,R9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,8,0),\"\")","v":78.5},{"$f":"IFERROR(V9*$E9,\"\")","v":0},{"$f":"IF(W9=0,0,IFERROR($E9*V9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,V9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,8,0),\"\")","v":78.5},{"$f":"IFERROR(Z9*$E9,\"\")","v":0},{"$f":"IF(AA9=0,0,IFERROR($E9*Z9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,Z9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,8,0),\"\")","v":62.87},{"$f":"IFERROR(AD9*$E9,\"\")","v":0},{"$f":"IF(AE9=0,0,IFERROR($E9*AD9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,AD9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,8,0),\"\")","v":72.88},{"$f":"IFERROR(AH9*$E9,\"\")","v":0},{"$f":"IF(AI9=0,0,IFERROR($E9*AH9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,AH9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,8,0),\"\")","v":73.33},{"$f":"IFERROR(AL9*$E9,\"\")","v":0},{"$f":"IF(AM9=0,0,IFERROR($E9*AL9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,AL9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,8,0),\"\")","v":67.2},{"$f":"IFERROR(AP9*$E9,\"\")","v":0},{"$f":"IF(AQ9=0,0,IFERROR($E9*AP9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,AP9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,8,0),\"\")","v":0},{"$f":"IFERROR(AT9*$E9,\"\")","v":0},{"$f":"IF(AU9=0,0,IFERROR($E9*AT9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,AT9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,8,0),\"\")","v":86},{"$f":"IFERROR(AX9*$E9,\"\")","v":0},{"$f":"IF(AY9=0,0,IFERROR($E9*AX9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,AX9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,8,0),\"\")","v":61.4},{"$f":"IFERROR(BB9*$E9,\"\")","v":0},{"$f":"IF(BC9=0,0,IFERROR($E9*BB9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,BB9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,8,0),\"\")","v":70},{"$f":"IFERROR(BF9*$E9,\"\")","v":0},{"$f":"IF(BG9=0,0,IFERROR($E9*BF9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,BF9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,8,0),\"\")","v":70},{"$f":"IFERROR(BJ9*$E9,\"\")","v":0},{"$f":"IF(BK9=0,0,IFERROR($E9*BJ9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,BJ9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,8,0),\"\")","v":71.5},{"$f":"IFERROR(BN9*$E9,\"\")","v":0},{"$f":"IF(BO9=0,0,IFERROR($E9*BN9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":0},{"$f":"IF(AND($E9>0,BN9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,8,0),\"\")","v":""},{"$f":"IFERROR(BR9*$E9,\"\")","v":""},{"$f":"IF(BS9=0,0,IFERROR($E9*BR9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":""},{"$f":"IF(AND($E9>0,BR9=0),\"Incomplete\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,8,0),\"\")","v":""},{"$f":"IFERROR(BV9*$E9,\"\")","v":""},{"$f":"IF(BW9=0,0,IFERROR($E9*BV9+($E9*'Basic Price Adjustment'!$E34),\"\"))","v":""},{"$f":"IF(AND($E9>0,BV9=0),\"Incomplete\",\"\")","v":""},null,null,{"$f":"L$6","v":37.299999999999997},{"$f":"L$3","v":502}]
[null,3,"Asphalt Section 401 - Base II",null,{"$f":"'Order Details'!J9","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,9,0),\"\")","v":70.25},0,{"$f":"IF(G10=0,0,IFERROR($E10*F10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,9,0),\"\")","v":72.87},0,{"$f":"IF(K10=0,0,IFERROR($E10*J10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,9,0),\"\")","v":70.599999999999994},0,{"$f":"IF(O10=0,0,IFERROR($E10*N10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,9,0),\"\")","v":73.2},0,{"$f":"IF(S10=0,0,IFERROR($E10*R10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,9,0),\"\")","v":70.599999999999994},0,{"$f":"IF(W10=0,0,IFERROR($E10*V10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,9,0),\"\")","v":70.599999999999994},0,{"$f":"IF(AA10=0,0,IFERROR($E10*Z10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,9,0),\"\")","v":68.45},0,{"$f":"IF(AE10=0,0,IFERROR($E10*AD10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,9,0),\"\")","v":73.2},0,{"$f":"IF(AI10=0,0,IFERROR($E10*AH10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,9,0),\"\")","v":73.33},0,{"$f":"IF(AM10=0,0,IFERROR($E10*AL10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,9,0),\"\")","v":70.599999999999994},0,{"$f":"IF(AQ10=0,0,IFERROR($E10*AP10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,9,0),\"\")","v":0},0,{"$f":"IF(AU10=0,0,IFERROR($E10*AT10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,9,0),\"\")","v":84},0,{"$f":"IF(AY10=0,0,IFERROR($E10*AX10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,9,0),\"\")","v":63.5},0,{"$f":"IF(BC10=0,0,IFERROR($E10*BB10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,9,0),\"\")","v":75},0,{"$f":"IF(BG10=0,0,IFERROR($E10*BF10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,9,0),\"\")","v":75},0,{"$f":"IF(BK10=0,0,IFERROR($E10*BJ10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,9,0),\"\")","v":79.5},0,{"$f":"IF(BO10=0,0,IFERROR($E10*BN10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,9,0),\"\")","v":""},"",{"$f":"IF(BS10=0,0,IFERROR($E10*BR10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,9,0),\"\")","v":""},"",{"$f":"IF(BW10=0,0,IFERROR($E10*BV10+($E10*'Basic Price Adjustment'!$E35),\"\"))","v":""},"",null,null,{"$f":"P$6","v":38.479999999999997},{"$f":"P$3","v":503}]
[null,4,"Asphalt Section 401 - Patch and Level",null,{"$f":"'Order Details'!J10","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,10,0),\"\")","v":70.25},0,{"$f":"IF(G11=0,0,IFERROR($E11*F11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,10,0),\"\")","v":72.87},0,{"$f":"IF(K11=0,0,IFERROR($E11*J11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,10,0),\"\")","v":70.599999999999994},0,{"$f":"IF(O11=0,0,IFERROR($E11*N11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,10,0),\"\")","v":73.2},0,{"$f":"IF(S11=0,0,IFERROR($E11*R11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,10,0),\"\")","v":70.599999999999994},0,{"$f":"IF(W11=0,0,IFERROR($E11*V11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,10,0),\"\")","v":70.599999999999994},0,{"$f":"IF(AA11=0,0,IFERROR($E11*Z11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,10,0),\"\")","v":68.45},0,{"$f":"IF(AE11=0,0,IFERROR($E11*AD11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,10,0),\"\")","v":73.2},0,{"$f":"IF(AI11=0,0,IFERROR($E11*AH11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,10,0),\"\")","v":73.33},0,{"$f":"IF(AM11=0,0,IFERROR($E11*AL11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,10,0),\"\")","v":70.599999999999994},0,{"$f":"IF(AQ11=0,0,IFERROR($E11*AP11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,10,0),\"\")","v":0},0,{"$f":"IF(AU11=0,0,IFERROR($E11*AT11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,10,0),\"\")","v":84},0,{"$f":"IF(AY11=0,0,IFERROR($E11*AX11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,10,0),\"\")","v":63.5},0,{"$f":"IF(BC11=0,0,IFERROR($E11*BB11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,10,0),\"\")","v":75},0,{"$f":"IF(BG11=0,0,IFERROR($E11*BF11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,10,0),\"\")","v":75},0,{"$f":"IF(BK11=0,0,IFERROR($E11*BJ11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,10,0),\"\")","v":79.5},0,{"$f":"IF(BO11=0,0,IFERROR($E11*BN11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,10,0),\"\")","v":""},"",{"$f":"IF(BS11=0,0,IFERROR($E11*BR11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,10,0),\"\")","v":""},"",{"$f":"IF(BW11=0,0,IFERROR($E11*BV11+($E11*'Basic Price Adjustment'!$E36),\"\"))","v":""},"",null,null,{"$f":"T$6","v":41.18},{"$f":"T$3","v":504}]
[null,5,"Asphalt Section 401 - Wearing IV",null,{"$f":"'Order Details'!J11","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,11,0),\"\")","v":73},0,{"$f":"IF(G12=0,0,IFERROR($E12*F12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,11,0),\"\")","v":73.61},0,{"$f":"IF(K12=0,0,IFERROR($E12*J12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,11,0),\"\")","v":71.3},0,{"$f":"IF(O12=0,0,IFERROR($E12*N12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,11,0),\"\")","v":73.8},0,{"$f":"IF(S12=0,0,IFERROR($E12*R12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,11,0),\"\")","v":71.3},0,{"$f":"IF(W12=0,0,IFERROR($E12*V12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,11,0),\"\")","v":71.3},0,{"$f":"IF(AA12=0,0,IFERROR($E12*Z12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,11,0),\"\")","v":69.510000000000005},0,{"$f":"IF(AE12=0,0,IFERROR($E12*AD12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,11,0),\"\")","v":73.41},0,{"$f":"IF(AI12=0,0,IFERROR($E12*AH12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,11,0),\"\")","v":73.41},0,{"$f":"IF(AM12=0,0,IFERROR($E12*AL12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,11,0),\"\")","v":70.599999999999994},0,{"$f":"IF(AQ12=0,0,IFERROR($E12*AP12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,11,0),\"\")","v":0},0,{"$f":"IF(AU12=0,0,IFERROR($E12*AT12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,11,0),\"\")","v":85},0,{"$f":"IF(AY12=0,0,IFERROR($E12*AX12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,11,0),\"\")","v":63.5},0,{"$f":"IF(BC12=0,0,IFERROR($E12*BB12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,11,0),\"\")","v":90},0,{"$f":"IF(BG12=0,0,IFERROR($E12*BF12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,11,0),\"\")","v":90},0,{"$f":"IF(BK12=0,0,IFERROR($E12*BJ12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,11,0),\"\")","v":81.5},0,{"$f":"IF(BO12=0,0,IFERROR($E12*BN12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,11,0),\"\")","v":""},"",{"$f":"IF(BS12=0,0,IFERROR($E12*BR12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,11,0),\"\")","v":""},"",{"$f":"IF(BW12=0,0,IFERROR($E12*BV12+($E12*'Basic Price Adjustment'!$E37),\"\"))","v":""},"",null,null,{"$f":"X$6","v":38.479999999999997},{"$f":"X$3","v":505}]
[null,6,"Asphalt Section 402 - Wearing IV",null,{"$f":"'Order Details'!J12","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,12,0),\"\")","v":85},0,{"$f":"IF(G13=0,0,IFERROR($E13*F13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,12,0),\"\")","v":0},0,{"$f":"IF(K13=0,0,IFERROR($E13*J13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,12,0),\"\")","v":75.400000000000006},0,{"$f":"IF(O13=0,0,IFERROR($E13*N13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,12,0),\"\")","v":75.400000000000006},0,{"$f":"IF(S13=0,0,IFERROR($E13*R13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,12,0),\"\")","v":76.5},0,{"$f":"IF(W13=0,0,IFERROR($E13*V13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,12,0),\"\")","v":76.5},0,{"$f":"IF(AA13=0,0,IFERROR($E13*Z13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,12,0),\"\")","v":72.37},0,{"$f":"IF(AE13=0,0,IFERROR($E13*AD13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,12,0),\"\")","v":77.09},0,{"$f":"IF(AI13=0,0,IFERROR($E13*AH13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,12,0),\"\")","v":77.09},0,{"$f":"IF(AM13=0,0,IFERROR($E13*AL13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,12,0),\"\")","v":80.5},0,{"$f":"IF(AQ13=0,0,IFERROR($E13*AP13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,12,0),\"\")","v":0},0,{"$f":"IF(AU13=0,0,IFERROR($E13*AT13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,12,0),\"\")","v":96},0,{"$f":"IF(AY13=0,0,IFERROR($E13*AX13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,12,0),\"\")","v":66.8},0,{"$f":"IF(BC13=0,0,IFERROR($E13*BB13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,12,0),\"\")","v":100},0,{"$f":"IF(BG13=0,0,IFERROR($E13*BF13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,12,0),\"\")","v":100},0,{"$f":"IF(BK13=0,0,IFERROR($E13*BJ13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,12,0),\"\")","v":93},0,{"$f":"IF(BO13=0,0,IFERROR($E13*BN13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,12,0),\"\")","v":""},"",{"$f":"IF(BS13=0,0,IFERROR($E13*BR13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,12,0),\"\")","v":""},"",{"$f":"IF(BW13=0,0,IFERROR($E13*BV13+($E13*'Basic Price Adjustment'!$E38),\"\"))","v":""},"",null,null,{"$f":"AB$6","v":38.479999999999997},{"$f":"AB$3","v":506}]
[null,7,"Asphalt Section 401 - 19mm Superpave",null,{"$f":"'Order Details'!J13","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,13,0),\"\")","v":71.5},0,{"$f":"IF(G14=0,0,IFERROR($E14*F14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,13,0),\"\")","v":0},0,{"$f":"IF(K14=0,0,IFERROR($E14*J14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,13,0),\"\")","v":74.7},0,{"$f":"IF(O14=0,0,IFERROR($E14*N14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,13,0),\"\")","v":77.7},0,{"$f":"IF(S14=0,0,IFERROR($E14*R14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,13,0),\"\")","v":79.25},0,{"$f":"IF(W14=0,0,IFERROR($E14*V14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,13,0),\"\")","v":79.25},0,{"$f":"IF(AA14=0,0,IFERROR($E14*Z14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,13,0),\"\")","v":68.45},0,{"$f":"IF(AE14=0,0,IFERROR($E14*AD14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,13,0),\"\")","v":73.2},0,{"$f":"IF(AI14=0,0,IFERROR($E14*AH14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,13,0),\"\")","v":73.33},0,{"$f":"IF(AM14=0,0,IFERROR($E14*AL14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,13,0),\"\")","v":70.5},0,{"$f":"IF(AQ14=0,0,IFERROR($E14*AP14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,13,0),\"\")","v":0},0,{"$f":"IF(AU14=0,0,IFERROR($E14*AT14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,13,0),\"\")","v":86},0,{"$f":"IF(AY14=0,0,IFERROR($E14*AX14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,13,0),\"\")","v":63.5},0,{"$f":"IF(BC14=0,0,IFERROR($E14*BB14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,13,0),\"\")","v":80},0,{"$f":"IF(BG14=0,0,IFERROR($E14*BF14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,13,0),\"\")","v":80},0,{"$f":"IF(BK14=0,0,IFERROR($E14*BJ14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,13,0),\"\")","v":79},0,{"$f":"IF(BO14=0,0,IFERROR($E14*BN14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,13,0),\"\")","v":""},"",{"$f":"IF(BS14=0,0,IFERROR($E14*BR14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,13,0),\"\")","v":""},"",{"$f":"IF(BW14=0,0,IFERROR($E14*BV14+($E14*'Basic Price Adjustment'!$E39),\"\"))","v":""},"",null,null,{"$f":"AF$6","v":38.26},{"$f":"AF$3","v":507}]
[null,8,"Asphalt Section 401 - Scratch Course",null,{"$f":"'Order Details'!J14","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,14,0),\"\")","v":76.25},0,{"$f":"IF(G15=0,0,IFERROR($E15*F15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,14,0),\"\")","v":76.180000000000007},0,{"$f":"IF(K15=0,0,IFERROR($E15*J15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,14,0),\"\")","v":78},0,{"$f":"IF(O15=0,0,IFERROR($E15*N15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,14,0),\"\")","v":79.8},0,{"$f":"IF(S15=0,0,IFERROR($E15*R15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,14,0),\"\")","v":78},0,{"$f":"IF(W15=0,0,IFERROR($E15*V15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,14,0),\"\")","v":78},0,{"$f":"IF(AA15=0,0,IFERROR($E15*Z15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,14,0),\"\")","v":77.23},0,{"$f":"IF(AE15=0,0,IFERROR($E15*AD15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,14,0),\"\")","v":78.08},0,{"$f":"IF(AI15=0,0,IFERROR($E15*AH15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,14,0),\"\")","v":78.08},0,{"$f":"IF(AM15=0,0,IFERROR($E15*AL15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,14,0),\"\")","v":77.3},0,{"$f":"IF(AQ15=0,0,IFERROR($E15*AP15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,14,0),\"\")","v":0},0,{"$f":"IF(AU15=0,0,IFERROR($E15*AT15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,14,0),\"\")","v":90},0,{"$f":"IF(AY15=0,0,IFERROR($E15*AX15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,14,0),\"\")","v":72.7},0,{"$f":"IF(BC15=0,0,IFERROR($E15*BB15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,14,0),\"\")","v":90},0,{"$f":"IF(BG15=0,0,IFERROR($E15*BF15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,14,0),\"\")","v":90},0,{"$f":"IF(BK15=0,0,IFERROR($E15*BJ15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,14,0),\"\")","v":84},0,{"$f":"IF(BO15=0,0,IFERROR($E15*BN15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,14,0),\"\")","v":""},"",{"$f":"IF(BS15=0,0,IFERROR($E15*BR15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,14,0),\"\")","v":""},"",{"$f":"IF(BW15=0,0,IFERROR($E15*BV15+($E15*'Basic Price Adjustment'!$E40),\"\"))","v":""},"",null,null,{"$f":"AJ$6","v":43.93},{"$f":"AJ$3","v":508}]
[null,9,"Asphalt Section 402 - 9.5mm Superpave",null,{"$f":"'Order Details'!J15","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,15,0),\"\")","v":86},0,{"$f":"IF(G16=0,0,IFERROR($E16*F16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,15,0),\"\")","v":0},0,{"$f":"IF(K16=0,0,IFERROR($E16*J16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,15,0),\"\")","v":95.5},0,{"$f":"IF(O16=0,0,IFERROR($E16*N16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,15,0),\"\")","v":93.5},0,{"$f":"IF(S16=0,0,IFERROR($E16*R16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,15,0),\"\")","v":95},0,{"$f":"IF(W16=0,0,IFERROR($E16*V16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,15,0),\"\")","v":95},0,{"$f":"IF(AA16=0,0,IFERROR($E16*Z16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,15,0),\"\")","v":77.97},0,{"$f":"IF(AE16=0,0,IFERROR($E16*AD16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,15,0),\"\")","v":82.92},0,{"$f":"IF(AI16=0,0,IFERROR($E16*AH16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,15,0),\"\")","v":82.92},0,{"$f":"IF(AM16=0,0,IFERROR($E16*AL16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,15,0),\"\")","v":0},0,{"$f":"IF(AQ16=0,0,IFERROR($E16*AP16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,15,0),\"\")","v":0},0,{"$f":"IF(AU16=0,0,IFERROR($E16*AT16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,15,0),\"\")","v":100},0,{"$f":"IF(AY16=0,0,IFERROR($E16*AX16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,15,0),\"\")","v":72.7},0,{"$f":"IF(BC16=0,0,IFERROR($E16*BB16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,15,0),\"\")","v":90},0,{"$f":"IF(BG16=0,0,IFERROR($E16*BF16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,15,0),\"\")","v":90},0,{"$f":"IF(BK16=0,0,IFERROR($E16*BJ16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,15,0),\"\")","v":97},0,{"$f":"IF(BO16=0,0,IFERROR($E16*BN16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,15,0),\"\")","v":""},"",{"$f":"IF(BS16=0,0,IFERROR($E16*BR16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,15,0),\"\")","v":""},"",{"$f":"IF(BW16=0,0,IFERROR($E16*BV16+($E16*'Basic Price Adjustment'!$E41),\"\"))","v":""},"",null,null,{"$f":"AN$6","v":44.62},{"$f":"AN$3","v":509}]
[null,10,"Asphalt Section 401 - Wearing 1",null,{"$f":"'Order Details'!J16","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,16,0),\"\")","v":76},0,{"$f":"IF(G17=0,0,IFERROR($E17*F17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,16,0),\"\")","v":75.92},0,{"$f":"IF(K17=0,0,IFERROR($E17*J17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,16,0),\"\")","v":78},0,{"$f":"IF(O17=0,0,IFERROR($E17*N17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,16,0),\"\")","v":79.8},0,{"$f":"IF(S17=0,0,IFERROR($E17*R17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,16,0),\"\")","v":78},0,{"$f":"IF(W17=0,0,IFERROR($E17*V17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,16,0),\"\")","v":78},0,{"$f":"IF(AA17=0,0,IFERROR($E17*Z17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,16,0),\"\")","v":75.37},0,{"$f":"IF(AE17=0,0,IFERROR($E17*AD17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,16,0),\"\")","v":78.08},0,{"$f":"IF(AI17=0,0,IFERROR($E17*AH17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,16,0),\"\")","v":78.08},0,{"$f":"IF(AM17=0,0,IFERROR($E17*AL17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,16,0),\"\")","v":77.3},0,{"$f":"IF(AQ17=0,0,IFERROR($E17*AP17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,16,0),\"\")","v":0},0,{"$f":"IF(AU17=0,0,IFERROR($E17*AT17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,16,0),\"\")","v":90},0,{"$f":"IF(AY17=0,0,IFERROR($E17*AX17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,16,0),\"\")","v":72.7},0,{"$f":"IF(BC17=0,0,IFERROR($E17*BB17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,16,0),\"\")","v":90},0,{"$f":"IF(BG17=0,0,IFERROR($E17*BF17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,16,0),\"\")","v":90},0,{"$f":"IF(BK17=0,0,IFERROR($E17*BJ17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,16,0),\"\")","v":84},0,{"$f":"IF(BO17=0,0,IFERROR($E17*BN17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,16,0),\"\")","v":""},"",{"$f":"IF(BS17=0,0,IFERROR($E17*BR17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,16,0),\"\")","v":""},"",{"$f":"IF(BW17=0,0,IFERROR($E17*BV17+($E17*'Basic Price Adjustment'!$E42),\"\"))","v":""},"",null,null,{"$f":"AR$6","v":44.48},{"$f":"AR$3","v":510}]
[null,11,"Asphalt Section 402 - Wearing 1",null,{"$f":"'Order Details'!J17","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,17,0),\"\")","v":82},0,{"$f":"IF(G18=0,0,IFERROR($E18*F18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,17,0),\"\")","v":84.55},0,{"$f":"IF(K18=0,0,IFERROR($E18*J18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,17,0),\"\")","v":82},0,{"$f":"IF(O18=0,0,IFERROR($E18*N18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,17,0),\"\")","v":82.7},0,{"$f":"IF(S18=0,0,IFERROR($E18*R18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,17,0),\"\")","v":84.7},0,{"$f":"IF(W18=0,0,IFERROR($E18*V18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,17,0),\"\")","v":84.7},0,{"$f":"IF(AA18=0,0,IFERROR($E18*Z18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,17,0),\"\")","v":77.97},0,{"$f":"IF(AE18=0,0,IFERROR($E18*AD18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,17,0),\"\")","v":83.06},0,{"$f":"IF(AI18=0,0,IFERROR($E18*AH18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,17,0),\"\")","v":83.06},0,{"$f":"IF(AM18=0,0,IFERROR($E18*AL18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,17,0),\"\")","v":85.3},0,{"$f":"IF(AQ18=0,0,IFERROR($E18*AP18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,17,0),\"\")","v":0},0,{"$f":"IF(AU18=0,0,IFERROR($E18*AT18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,17,0),\"\")","v":95},0,{"$f":"IF(AY18=0,0,IFERROR($E18*AX18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,17,0),\"\")","v":76},0,{"$f":"IF(BC18=0,0,IFERROR($E18*BB18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,17,0),\"\")","v":100},0,{"$f":"IF(BG18=0,0,IFERROR($E18*BF18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,17,0),\"\")","v":100},0,{"$f":"IF(BK18=0,0,IFERROR($E18*BJ18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,17,0),\"\")","v":97},0,{"$f":"IF(BO18=0,0,IFERROR($E18*BN18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,17,0),\"\")","v":""},"",{"$f":"IF(BS18=0,0,IFERROR($E18*BR18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,17,0),\"\")","v":""},"",{"$f":"IF(BW18=0,0,IFERROR($E18*BV18+($E18*'Basic Price Adjustment'!$E43),\"\"))","v":""},"",null,null,{"$f":"AV$6","v":"Incomplete"},{"$f":"AV$3","v":511}]
[null,12,"Asphalt Section 401 - 4.75mm Superpave",null,{"$f":"'Order Details'!J18","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,18,0),\"\")","v":86.5},0,{"$f":"IF(G19=0,0,IFERROR($E19*F19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,18,0),\"\")","v":0},0,{"$f":"IF(K19=0,0,IFERROR($E19*J19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,18,0),\"\")","v":0},0,{"$f":"IF(O19=0,0,IFERROR($E19*N19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,18,0),\"\")","v":0},0,{"$f":"IF(S19=0,0,IFERROR($E19*R19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,18,0),\"\")","v":0},0,{"$f":"IF(W19=0,0,IFERROR($E19*V19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,18,0),\"\")","v":0},0,{"$f":"IF(AA19=0,0,IFERROR($E19*Z19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,18,0),\"\")","v":86},0,{"$f":"IF(AE19=0,0,IFERROR($E19*AD19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,18,0),\"\")","v":97.95},0,{"$f":"IF(AI19=0,0,IFERROR($E19*AH19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,18,0),\"\")","v":104.95},0,{"$f":"IF(AM19=0,0,IFERROR($E19*AL19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,18,0),\"\")","v":0},0,{"$f":"IF(AQ19=0,0,IFERROR($E19*AP19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,18,0),\"\")","v":0},0,{"$f":"IF(AU19=0,0,IFERROR($E19*AT19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,18,0),\"\")","v":0},0,{"$f":"IF(AY19=0,0,IFERROR($E19*AX19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,18,0),\"\")","v":82.9},0,{"$f":"IF(BC19=0,0,IFERROR($E19*BB19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,18,0),\"\")","v":105},0,{"$f":"IF(BG19=0,0,IFERROR($E19*BF19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,18,0),\"\")","v":105},0,{"$f":"IF(BK19=0,0,IFERROR($E19*BJ19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,18,0),\"\")","v":0},0,{"$f":"IF(BO19=0,0,IFERROR($E19*BN19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,18,0),\"\")","v":""},"",{"$f":"IF(BS19=0,0,IFERROR($E19*BR19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,18,0),\"\")","v":""},"",{"$f":"IF(BW19=0,0,IFERROR($E19*BV19+($E19*'Basic Price Adjustment'!$E44),\"\"))","v":""},"",null,null,{"$f":"AZ$6","v":54.98},{"$f":"AZ$3","v":512}]
[null,13,"Asphalt Section 402 - 4.75mm Superpave",null,{"$f":"'Order Details'!J19","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,19,0),\"\")","v":101},0,{"$f":"IF(G20=0,0,IFERROR($E20*F20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,19,0),\"\")","v":0},0,{"$f":"IF(K20=0,0,IFERROR($E20*J20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,19,0),\"\")","v":0},0,{"$f":"IF(O20=0,0,IFERROR($E20*N20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,19,0),\"\")","v":0},0,{"$f":"IF(S20=0,0,IFERROR($E20*R20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,19,0),\"\")","v":0},0,{"$f":"IF(W20=0,0,IFERROR($E20*V20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,19,0),\"\")","v":0},0,{"$f":"IF(AA20=0,0,IFERROR($E20*Z20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,19,0),\"\")","v":87.6},0,{"$f":"IF(AE20=0,0,IFERROR($E20*AD20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,19,0),\"\")","v":100.45},0,{"$f":"IF(AI20=0,0,IFERROR($E20*AH20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,19,0),\"\")","v":107.59},0,{"$f":"IF(AM20=0,0,IFERROR($E20*AL20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,19,0),\"\")","v":0},0,{"$f":"IF(AQ20=0,0,IFERROR($E20*AP20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,19,0),\"\")","v":0},0,{"$f":"IF(AU20=0,0,IFERROR($E20*AT20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,19,0),\"\")","v":0},0,{"$f":"IF(AY20=0,0,IFERROR($E20*AX20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,19,0),\"\")","v":86.9},0,{"$f":"IF(BC20=0,0,IFERROR($E20*BB20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,19,0),\"\")","v":115},0,{"$f":"IF(BG20=0,0,IFERROR($E20*BF20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,19,0),\"\")","v":115},0,{"$f":"IF(BK20=0,0,IFERROR($E20*BJ20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,19,0),\"\")","v":0},0,{"$f":"IF(BO20=0,0,IFERROR($E20*BN20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,19,0),\"\")","v":""},"",{"$f":"IF(BS20=0,0,IFERROR($E20*BR20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,19,0),\"\")","v":""},"",{"$f":"IF(BW20=0,0,IFERROR($E20*BV20+($E20*'Basic Price Adjustment'!$E45),\"\"))","v":""},"",null,null,{"$f":"BD$6","v":31.479999999999997},{"$f":"BD$3","v":513}]
[null,14,"Asphalt Section 401 - Wearing III",null,{"$f":"'Order Details'!J20","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,20,0),\"\")","v":86.25},0,{"$f":"IF(G21=0,0,IFERROR($E21*F21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,20,0),\"\")","v":0},0,{"$f":"IF(K21=0,0,IFERROR($E21*J21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,20,0),\"\")","v":0},0,{"$f":"IF(O21=0,0,IFERROR($E21*N21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,20,0),\"\")","v":0},0,{"$f":"IF(S21=0,0,IFERROR($E21*R21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,20,0),\"\")","v":0},0,{"$f":"IF(W21=0,0,IFERROR($E21*V21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,20,0),\"\")","v":0},0,{"$f":"IF(AA21=0,0,IFERROR($E21*Z21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,20,0),\"\")","v":87.63},0,{"$f":"IF(AE21=0,0,IFERROR($E21*AD21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,20,0),\"\")","v":94.46},0,{"$f":"IF(AI21=0,0,IFERROR($E21*AH21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,20,0),\"\")","v":103.17},0,{"$f":"IF(AM21=0,0,IFERROR($E21*AL21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,20,0),\"\")","v":0},0,{"$f":"IF(AQ21=0,0,IFERROR($E21*AP21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,20,0),\"\")","v":0},0,{"$f":"IF(AU21=0,0,IFERROR($E21*AT21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,20,0),\"\")","v":98},0,{"$f":"IF(AY21=0,0,IFERROR($E21*AX21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,20,0),\"\")","v":82.9},0,{"$f":"IF(BC21=0,0,IFERROR($E21*BB21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,20,0),\"\")","v":115},0,{"$f":"IF(BG21=0,0,IFERROR($E21*BF21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,20,0),\"\")","v":115},0,{"$f":"IF(BK21=0,0,IFERROR($E21*BJ21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,20,0),\"\")","v":104},0,{"$f":"IF(BO21=0,0,IFERROR($E21*BN21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,20,0),\"\")","v":""},"",{"$f":"IF(BS21=0,0,IFERROR($E21*BR21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,20,0),\"\")","v":""},"",{"$f":"IF(BW21=0,0,IFERROR($E21*BV21+($E21*'Basic Price Adjustment'!$E46),\"\"))","v":""},"",null,null,{"$f":"BH$6","v":44.98},{"$f":"BH$3","v":514}]
[null,15,"Asphalt Section 402 - Wearing III",null,{"$f":"'Order Details'!J21","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,21,0),\"\")","v":99},0,{"$f":"IF(G22=0,0,IFERROR($E22*F22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,21,0),\"\")","v":0},0,{"$f":"IF(K22=0,0,IFERROR($E22*J22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,21,0),\"\")","v":0},0,{"$f":"IF(O22=0,0,IFERROR($E22*N22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,21,0),\"\")","v":0},0,{"$f":"IF(S22=0,0,IFERROR($E22*R22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,21,0),\"\")","v":0},0,{"$f":"IF(W22=0,0,IFERROR($E22*V22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,21,0),\"\")","v":0},0,{"$f":"IF(AA22=0,0,IFERROR($E22*Z22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,21,0),\"\")","v":91.28},0,{"$f":"IF(AE22=0,0,IFERROR($E22*AD22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,21,0),\"\")","v":97.68},0,{"$f":"IF(AI22=0,0,IFERROR($E22*AH22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,21,0),\"\")","v":104.2},0,{"$f":"IF(AM22=0,0,IFERROR($E22*AL22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,21,0),\"\")","v":0},0,{"$f":"IF(AQ22=0,0,IFERROR($E22*AP22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,21,0),\"\")","v":0},0,{"$f":"IF(AU22=0,0,IFERROR($E22*AT22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,21,0),\"\")","v":0},0,{"$f":"IF(AY22=0,0,IFERROR($E22*AX22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,21,0),\"\")","v":86.9},0,{"$f":"IF(BC22=0,0,IFERROR($E22*BB22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,21,0),\"\")","v":125},0,{"$f":"IF(BG22=0,0,IFERROR($E22*BF22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,21,0),\"\")","v":125},0,{"$f":"IF(BK22=0,0,IFERROR($E22*BJ22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,21,0),\"\")","v":0},0,{"$f":"IF(BO22=0,0,IFERROR($E22*BN22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,21,0),\"\")","v":""},"",{"$f":"IF(BS22=0,0,IFERROR($E22*BR22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,21,0),\"\")","v":""},"",{"$f":"IF(BW22=0,0,IFERROR($E22*BV22+($E22*'Basic Price Adjustment'!$E47),\"\"))","v":""},"",null,null,{"$f":"BL$6","v":44.98},{"$f":"BL$3","v":515}]
[null,16,"Asphalt Section 401 - 12.5mm Superpave",null,{"$f":"'Order Details'!J22","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,22,0),\"\")","v":79.5},0,{"$f":"IF(G23=0,0,IFERROR($E23*F23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,22,0),\"\")","v":0},0,{"$f":"IF(K23=0,0,IFERROR($E23*J23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,22,0),\"\")","v":83.3},0,{"$f":"IF(O23=0,0,IFERROR($E23*N23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,22,0),\"\")","v":84.5},0,{"$f":"IF(S23=0,0,IFERROR($E23*R23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,22,0),\"\")","v":88},0,{"$f":"IF(W23=0,0,IFERROR($E23*V23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,22,0),\"\")","v":88},0,{"$f":"IF(AA23=0,0,IFERROR($E23*Z23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,22,0),\"\")","v":77.510000000000005},0,{"$f":"IF(AE23=0,0,IFERROR($E23*AD23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,22,0),\"\")","v":83.71},0,{"$f":"IF(AI23=0,0,IFERROR($E23*AH23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,22,0),\"\")","v":87.08},0,{"$f":"IF(AM23=0,0,IFERROR($E23*AL23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,22,0),\"\")","v":0},0,{"$f":"IF(AQ23=0,0,IFERROR($E23*AP23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,22,0),\"\")","v":0},0,{"$f":"IF(AU23=0,0,IFERROR($E23*AT23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,22,0),\"\")","v":92},0,{"$f":"IF(AY23=0,0,IFERROR($E23*AX23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,22,0),\"\")","v":70.599999999999994},0,{"$f":"IF(BC23=0,0,IFERROR($E23*BB23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,22,0),\"\")","v":90},0,{"$f":"IF(BG23=0,0,IFERROR($E23*BF23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,22,0),\"\")","v":90},0,{"$f":"IF(BK23=0,0,IFERROR($E23*BJ23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,22,0),\"\")","v":99},0,{"$f":"IF(BO23=0,0,IFERROR($E23*BN23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,22,0),\"\")","v":""},"",{"$f":"IF(BS23=0,0,IFERROR($E23*BR23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,22,0),\"\")","v":""},"",{"$f":"IF(BW23=0,0,IFERROR($E23*BV23+($E23*'Basic Price Adjustment'!$E48),\"\"))","v":""},"",null,null,{"$f":"BP$6","v":46.48},{"$f":"BP$3","v":516}]
[null,17,"Asphalt Section 402 - 12.5mm Superpave",null,{"$f":"'Order Details'!J23","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,23,0),\"\")","v":83},0,{"$f":"IF(G24=0,0,IFERROR($E24*F24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,23,0),\"\")","v":0},0,{"$f":"IF(K24=0,0,IFERROR($E24*J24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,23,0),\"\")","v":84},0,{"$f":"IF(O24=0,0,IFERROR($E24*N24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,23,0),\"\")","v":85},0,{"$f":"IF(S24=0,0,IFERROR($E24*R24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,23,0),\"\")","v":95.5},0,{"$f":"IF(W24=0,0,IFERROR($E24*V24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,23,0),\"\")","v":95.5},0,{"$f":"IF(AA24=0,0,IFERROR($E24*Z24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,23,0),\"\")","v":80.84},0,{"$f":"IF(AE24=0,0,IFERROR($E24*AD24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,23,0),\"\")","v":86.38},0,{"$f":"IF(AI24=0,0,IFERROR($E24*AH24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,23,0),\"\")","v":89.67},0,{"$f":"IF(AM24=0,0,IFERROR($E24*AL24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,23,0),\"\")","v":81.95},0,{"$f":"IF(AQ24=0,0,IFERROR($E24*AP24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,23,0),\"\")","v":0},0,{"$f":"IF(AU24=0,0,IFERROR($E24*AT24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,23,0),\"\")","v":100},0,{"$f":"IF(AY24=0,0,IFERROR($E24*AX24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,23,0),\"\")","v":73.900000000000006},0,{"$f":"IF(BC24=0,0,IFERROR($E24*BB24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,23,0),\"\")","v":100},0,{"$f":"IF(BG24=0,0,IFERROR($E24*BF24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,23,0),\"\")","v":100},0,{"$f":"IF(BK24=0,0,IFERROR($E24*BJ24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,23,0),\"\")","v":99},0,{"$f":"IF(BO24=0,0,IFERROR($E24*BN24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,23,0),\"\")","v":""},"",{"$f":"IF(BS24=0,0,IFERROR($E24*BR24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,23,0),\"\")","v":""},"",{"$f":"IF(BW24=0,0,IFERROR($E24*BV24+($E24*'Basic Price Adjustment'!$E49),\"\"))","v":""},"",null,null,{"$f":"BT$6","v":0},{"$f":"BT$3","v":0}]
[null,18,"Asphalt Plant Run ",null,{"$f":"'Order Details'!J24","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,24,0),\"\")","v":76},0,{"$f":"IF(G25=0,0,IFERROR($E25*F25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,24,0),\"\")","v":75.92},0,{"$f":"IF(K25=0,0,IFERROR($E25*J25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,24,0),\"\")","v":78},0,{"$f":"IF(O25=0,0,IFERROR($E25*N25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,24,0),\"\")","v":79.8},0,{"$f":"IF(S25=0,0,IFERROR($E25*R25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,24,0),\"\")","v":78},0,{"$f":"IF(W25=0,0,IFERROR($E25*V25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,24,0),\"\")","v":78},0,{"$f":"IF(AA25=0,0,IFERROR($E25*Z25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,24,0),\"\")","v":77.08},0,{"$f":"IF(AE25=0,0,IFERROR($E25*AD25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,24,0),\"\")","v":77.739999999999995},0,{"$f":"IF(AI25=0,0,IFERROR($E25*AH25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,24,0),\"\")","v":79.64},0,{"$f":"IF(AM25=0,0,IFERROR($E25*AL25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,24,0),\"\")","v":77.3},0,{"$f":"IF(AQ25=0,0,IFERROR($E25*AP25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,24,0),\"\")","v":78},0,{"$f":"IF(AU25=0,0,IFERROR($E25*AT25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,24,0),\"\")","v":90},0,{"$f":"IF(AY25=0,0,IFERROR($E25*AX25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,24,0),\"\")","v":73},0,{"$f":"IF(BC25=0,0,IFERROR($E25*BB25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,24,0),\"\")","v":90},0,{"$f":"IF(BG25=0,0,IFERROR($E25*BF25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,24,0),\"\")","v":90},0,{"$f":"IF(BK25=0,0,IFERROR($E25*BJ25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,24,0),\"\")","v":84},0,{"$f":"IF(BO25=0,0,IFERROR($E25*BN25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,24,0),\"\")","v":""},"",{"$f":"IF(BS25=0,0,IFERROR($E25*BR25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,24,0),\"\")","v":""},"",{"$f":"IF(BW25=0,0,IFERROR($E25*BV25+($E25*'Basic Price Adjustment'!$E50),\"\"))","v":""},"",null,null,{"$f":"BX$6","v":0},{"$f":"BX$3","v":0}]
[null,19,"Surcharge for PG Binder - 64H minus 22",null,{"$f":"'Order Details'!J25","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,25,0),\"\")","v":4.75},0,{"$f":"IFERROR(G26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,25,0),\"\")","v":0},0,{"$f":"IFERROR(K26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,25,0),\"\")","v":5},0,{"$f":"IFERROR(O26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,25,0),\"\")","v":5},0,{"$f":"IFERROR(S26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,25,0),\"\")","v":5},0,{"$f":"IFERROR(W26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,25,0),\"\")","v":5},0,{"$f":"IFERROR(AA26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,25,0),\"\")","v":4.75},0,{"$f":"IFERROR(AE26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,25,0),\"\")","v":4.75},0,{"$f":"IFERROR(AI26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,25,0),\"\")","v":4.75},0,{"$f":"IFERROR(AM26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,25,0),\"\")","v":5},0,{"$f":"IFERROR(AQ26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,25,0),\"\")","v":0},0,{"$f":"IFERROR(AU26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,25,0),\"\")","v":6},0,{"$f":"IFERROR(AY26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,25,0),\"\")","v":2},0,{"$f":"IFERROR(BC26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,25,0),\"\")","v":8},0,{"$f":"IFERROR(BG26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,25,0),\"\")","v":8},0,{"$f":"IFERROR(BK26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,25,0),\"\")","v":4},0,{"$f":"IFERROR(BO26,\"\")","v":0},"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,25,0),\"\")","v":""},"",{"$f":"IFERROR(BS26,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,25,0),\"\")","v":""},"",{"$f":"IFERROR(BW26,\"\")","v":""},""]
[null,20,"Surcharge for PG Binder - 64E minus 22 - ordered in 400 ton increments",null,{"$f":"'Order Details'!J26","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,26,0),\"\")","v":14.5},0,0,"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,26,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,26,0),\"\")","v":12},0,0,"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,26,0),\"\")","v":12},0,0,"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,26,0),\"\")","v":12},0,0,"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,26,0),\"\")","v":12},0,0,"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,26,0),\"\")","v":12.5},0,0,"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,26,0),\"\")","v":12.5},0,0,"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,26,0),\"\")","v":12.5},0,0,"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,26,0),\"\")","v":15},0,0,"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,26,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,26,0),\"\")","v":15},0,0,"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,26,0),\"\")","v":11},0,0,"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,26,0),\"\")","v":8},0,0,"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,26,0),\"\")","v":8},0,0,"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,26,0),\"\")","v":12},0,0,"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,26,0),\"\")","v":""},"","","",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,26,0),\"\")","v":""},"","",""]
[null,21,"ESAL Surcharge - 3 million to 20 million ESALs",null,{"$f":"'Order Details'!J27","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,27,0),\"\")","v":1.25},0,0,"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,27,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,27,0),\"\")","v":4},0,0,"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,27,0),\"\")","v":4},0,0,"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,27,0),\"\")","v":4},0,0,"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,27,0),\"\")","v":4},0,0,"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,27,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,27,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,27,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,27,0),\"\")","v":5},0,0,"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,27,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,27,0),\"\")","v":0.3},0,0,"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,27,0),\"\")","v":2},0,0,"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,27,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,27,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,27,0),\"\")","v":2},0,0,"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,27,0),\"\")","v":""},"","","",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,27,0),\"\")","v":""},"","",""]
[null,22,"ESAL Surcharge - Greater than 20 million ESALs",null,{"$f":"'Order Details'!J28","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,28,0),\"\")","v":1.75},0,0,"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,28,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,28,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,28,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,28,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,28,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,28,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,28,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,28,0),\"\")","v":10},0,0,"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,28,0),\"\")","v":15},0,0,"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,28,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,28,0),\"\")","v":0.45},0,0,"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,28,0),\"\")","v":4},0,0,"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,28,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,28,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,28,0),\"\")","v":5},0,0,"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,28,0),\"\")","v":""},"","","",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,28,0),\"\")","v":""},"","",""]
[null,23,"Off-Season Plant Opening - First Day",null,{"$f":"'Order Details'!J29","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,29,0),\"\")","v":6850},0,0,"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,29,0),\"\")","v":3000},0,0,"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,29,0),\"\")","v":4500},0,0,"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,29,0),\"\")","v":4500},0,0,"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,29,0),\"\")","v":4500},0,0,"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,29,0),\"\")","v":4500},0,0,"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,29,0),\"\")","v":3500},0,0,"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,29,0),\"\")","v":3500},0,0,"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,29,0),\"\")","v":3500},0,0,"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,29,0),\"\")","v":9000},0,0,"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,29,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,29,0),\"\")","v":5000},0,0,"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,29,0),\"\")","v":5000},0,0,"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,29,0),\"\")","v":8000},0,0,"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,29,0),\"\")","v":8000},0,0,"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,29,0),\"\")","v":4000},0,0,"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,29,0),\"\")","v":""},"","","",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,29,0),\"\")","v":""},"","",""]
[null,24,"Off-Season Plant Opening - Each Additional Day",null,{"$f":"'Order Details'!J30","v":0},{"$f":"IFERROR(VLOOKUP(H$3,Data!$B$4:$AE$137,30,0),\"\")","v":4350},0,0,"",{"$f":"IFERROR(VLOOKUP(L$3,Data!$B$4:$AE$137,30,0),\"\")","v":750},0,0,"",{"$f":"IFERROR(VLOOKUP(P$3,Data!$B$4:$AE$137,30,0),\"\")","v":1500},0,0,"",{"$f":"IFERROR(VLOOKUP(T$3,Data!$B$4:$AE$137,30,0),\"\")","v":1500},0,0,"",{"$f":"IFERROR(VLOOKUP(X$3,Data!$B$4:$AE$137,30,0),\"\")","v":1500},0,0,"",{"$f":"IFERROR(VLOOKUP(AB$3,Data!$B$4:$AE$137,30,0),\"\")","v":1500},0,0,"",{"$f":"IFERROR(VLOOKUP(AF$3,Data!$B$4:$AE$137,30,0),\"\")","v":1500},0,0,"",{"$f":"IFERROR(VLOOKUP(AJ$3,Data!$B$4:$AE$137,30,0),\"\")","v":1500},0,0,"",{"$f":"IFERROR(VLOOKUP(AN$3,Data!$B$4:$AE$137,30,0),\"\")","v":1500},0,0,"",{"$f":"IFERROR(VLOOKUP(AR$3,Data!$B$4:$AE$137,30,0),\"\")","v":3000},0,0,"",{"$f":"IFERROR(VLOOKUP(AV$3,Data!$B$4:$AE$137,30,0),\"\")","v":0},0,0,"",{"$f":"IFERROR(VLOOKUP(AZ$3,Data!$B$4:$AE$137,30,0),\"\")","v":500},0,0,"",{"$f":"IFERROR(VLOOKUP(BD$3,Data!$B$4:$AE$137,30,0),\"\")","v":1500},0,0,"",{"$f":"IFERROR(VLOOKUP(BH$3,Data!$B$4:$AE$137,30,0),\"\")","v":4000},0,0,"",{"$f":"IFERROR(VLOOKUP(BL$3,Data!$B$4:$AE$137,30,0),\"\")","v":4000},0,0,"",{"$f":"IFERROR(VLOOKUP(BP$3,Data!$B$4:$AE$137,30,0),\"\")","v":1500},0,0,"",{"$f":"IFERROR(VLOOKUP(BT$3,Data!$B$4:$AE$137,30,0),\"\")","v":""},"","","",{"$f":"IFERROR(VLOOKUP(BX$3,Data!$B$4:$AE$137,30,0),\"\")","v":""},"","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",I8:I31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",M8:M31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",Q8:Q31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",U8:U31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",Y8:Y31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",AC8:AC31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",AG8:AG31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",AK8:AK31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",AO8:AO31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",AS8:AS31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",AW8:AW31,0))=TRUE,\"\",\"Incomplete\")","v":"Incomplete"},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",BA8:BA31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",BE8:BE31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",BI8:BI31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",BM8:BM31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",BQ8:BQ31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",BU8:BU31,0))=TRUE,\"\",\"Incomplete\")","v":""},null,null,null,{"$f":"IF(ISNA(MATCH(\"Incomplete\",BY8:BY31,0))=TRUE,\"\",\"Incomplete\")","v":""}]

{"sheet":"Order Summary","index":6,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,1,7,2],[4,7,4,10],[7,7,7,8],[3,7,3,10],[6,1,6,2],[3,1,3,2]]}
["Manual Override Selection:"]
["Override",{"$f":"IF(D1=\"\",\"No\",\"Yes\")","v":"No"}]
[]
["Agency Release No.",{"$f":"'Order Details'!B19","v":0},null,null,null,null,"Vendor:",{"$f":"IF(D1=\"\",'Vendor Totals'!C2,HLOOKUP(D1,'Vendor Totals'!F2:BX5,3,FALSE))","v":"C WILLIAM HETZER INC"}]
["Project Type:",{"$f":"'Order Details'!B17","v":0},null,null,null,null,null,{"$f":"IF(D1=\"\",'Vendor Totals'!C3,HLOOKUP('Order Summary'!$D$1,'Vendor Totals'!$F$2:$BX$5,4,0))","v":"10104 Mapleville Road\nHagerstown, MD 21740"}]
["Description:",{"$f":"'Order Details'!B18","v":0},null,null,null,null,"PID",{"$f":"IF(D1=\"\",'Vendor Totals'!B3,HLOOKUP('Order Summary'!D1,'Vendor Totals'!F2:BX5,2,FALSE))","v":513}]
["Project #",{"$f":"'Order Details'!B20","v":0}]
["Authorization #",{"$f":"'Order Details'!B21","v":0},null,null,null,null,"TOTAL",{"$f":"SUM(K11:K34)","v":31.479999999999997}]
[]
[null,"Item","Description",null,null,null,null,"Quantity","Unit $","Adjustment","Total"]
[null,1,"Asphalt Section 401 - Base I",null,null,null,null,{"$f":"'Order Details'!J7","v":1},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,7,0)","v":56.5},{"$f":"IF(I11=0,0,IFERROR(H11*I11+(H11*'Basic Price Adjustment'!E33),\"\"))","v":31.479999999999997},{"$f":"J11","v":31.479999999999997}]
[null,2,"Asphalt Section 401 - 25mm Superpave",null,null,null,null,{"$f":"'Order Details'!J8","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,8,0)","v":61.4},{"$f":"IF(I12=0,0,IFERROR(H12*I12+(H12*'Basic Price Adjustment'!E34),\"\"))","v":0},{"$f":"J12","v":0}]
[null,3,"Asphalt Section 401 - Base II",null,null,null,null,{"$f":"'Order Details'!J9","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,9,0)","v":63.5},{"$f":"IF(I13=0,0,IFERROR(H13*I13+(H13*'Basic Price Adjustment'!E35),\"\"))","v":0},0]
[null,4,"Asphalt Section 401 - Patch and Level",null,null,null,null,{"$f":"'Order Details'!J10","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,10,0)","v":63.5},{"$f":"IF(I14=0,0,IFERROR(H14*I14+(H14*'Basic Price Adjustment'!E36),\"\"))","v":0},0]
[null,5,"Asphalt Section 401 - Wearing IV",null,null,null,null,{"$f":"'Order Details'!J11","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,11,0)","v":63.5},{"$f":"IF(I15=0,0,IFERROR(H15*I15+(H15*'Basic Price Adjustment'!E37),\"\"))","v":0},0]
[null,6,"Asphalt Section 402 - Wearing IV",null,null,null,null,{"$f":"'Order Details'!J12","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,12,0)","v":66.8},{"$f":"IF(I16=0,0,IFERROR(H16*I16+(H16*'Basic Price Adjustment'!E38),\"\"))","v":0},0]
[null,7,"Asphalt Section 401 - 19mm Superpave",null,null,null,null,{"$f":"'Order Details'!J13","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,13,0)","v":63.5},{"$f":"IF(I17=0,0,IFERROR(H17*I17+(H17*'Basic Price Adjustment'!E39),\"\"))","v":0},0]
[null,8,"Asphalt Section 401 - Scratch Course",null,null,null,null,{"$f":"'Order Details'!J14","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,14,0)","v":72.7},{"$f":"IF(I18=0,0,IFERROR(H18*I18+(H18*'Basic Price Adjustment'!E40),\"\"))","v":0},0]
[null,9,"Asphalt Section 402 - 9.5mm Superpave",null,null,null,null,{"$f":"'Order Details'!J15","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,15,0)","v":72.7},{"$f":"IF(I19=0,0,IFERROR(H19*I19+(H19*'Basic Price Adjustment'!E41),\"\"))","v":0},0]
[null,10,"Asphalt Section 401 - Wearing 1",null,null,null,null,{"$f":"'Order Details'!J16","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,16,0)","v":72.7},{"$f":"IF(I20=0,0,IFERROR(H20*I20+(H20*'Basic Price Adjustment'!E42),\"\"))","v":0},0]
[null,11,"Asphalt Section 402 - Wearing 1",null,null,null,null,{"$f":"'Order Details'!J17","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,17,0)","v":76},{"$f":"IF(I21=0,0,IFERROR(H21*I21+(H21*'Basic Price Adjustment'!E43),\"\"))","v":0},0]
[null,12,"Asphalt Section 401 - 4.75mm Superpave",null,null,null,null,{"$f":"'Order Details'!J18","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,18,0)","v":82.9},{"$f":"IF(I22=0,0,IFERROR(H22*I22+(H22*'Basic Price Adjustment'!E44),\"\"))","v":0},0]
[null,13,"Asphalt Section 402 - 4.75mm Superpave",null,null,null,null,{"$f":"'Order Details'!J19","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,19,0)","v":86.9},{"$f":"IF(I23=0,0,IFERROR(H23*I23+(H23*'Basic Price Adjustment'!E45),\"\"))","v":0},0]
[null,14,"Asphalt Section 401 - Wearing III",null,null,null,null,{"$f":"'Order Details'!J20","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,20,0)","v":82.9},{"$f":"IF(I24=0,0,IFERROR(H24*I24+(H24*'Basic Price Adjustment'!E46),\"\"))","v":0},0]
[null,15,"Asphalt Section 402 - Wearing III",null,null,null,null,{"$f":"'Order Details'!J21","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,21,0)","v":86.9},{"$f":"IF(I25=0,0,IFERROR(H25*I25+(H25*'Basic Price Adjustment'!E47),\"\"))","v":0},0]
[null,16,"Asphalt Section 401 - 12.5mm Superpave",null,null,null,null,{"$f":"'Order Details'!J22","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,22,0)","v":70.599999999999994},{"$f":"IF(I26=0,0,IFERROR(H26*I26+(H26*'Basic Price Adjustment'!E48),\"\"))","v":0},0]
[null,17,"Asphalt Section 402 - 12.5mm Superpave",null,null,null,null,{"$f":"'Order Details'!J23","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,23,0)","v":73.900000000000006},{"$f":"IF(I27=0,0,IFERROR(H27*I27+(H27*'Basic Price Adjustment'!E49),\"\"))","v":0},0]
[null,18,"Asphalt Plant Run ",null,null,null,null,{"$f":"'Order Details'!J24","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,24,0)","v":73},{"$f":"IF(I28=0,0,IFERROR(H28*I28+(H28*'Basic Price Adjustment'!E50),\"\"))","v":0},0]
[null,19,"Surcharge for PG Binder - 64H minus 22",null,null,null,null,{"$f":"'Order Details'!J25","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,25,0)","v":2},null,{"$f":"I29*H29","v":0}]
[null,20,"Surcharge for PG Binder - 64E minus 22 - ordered in 400 ton increments",null,null,null,null,{"$f":"'Order Details'!J26","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,26,0)","v":11},null,0]
[null,21,"ESAL Surcharge - 3 million to 20 million ESALs",null,null,null,null,{"$f":"'Order Details'!J27","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,27,0)","v":2},null,0]
[null,22,"ESAL Surcharge - Greater than 20 million ESALs",null,null,null,null,{"$f":"'Order Details'!J28","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,28,0)","v":4},null,0]
[null,23,"Off-Season Plant Opening - First Day",null,null,null,null,{"$f":"'Order Details'!J29","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,29,0)","v":5000},null,0]
[null,24,"Off-Season Plant Opening - Each Additional Day",null,null,null,null,{"$f":"'Order Details'!J30","v":0},{"$f":"VLOOKUP($H$6,Data!$B$4:$AE$137,30,0)","v":1500},null,0]

{"sheet":"PJ-101","index":7,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,1,52,8],[53,1,53,8],[13,2,13,3],[32,4,32,6],[27,3,27,5],[44,3,44,4],[39,1,39,8],[40,1,40,8],[22,0,22,2],[22,7,22,8],[57,3,57,4],[60,1,60,2],[60,3,60,6],[61,3,61,6],[54,1,54,10]]}
["STATE  USE  ONLY"]
["PJ-101"]
["Rev. 4/14/82"]
[]
["WEST  VIRGINIA  DEPARTMENT  OF HIGHWAYS"]
[]
["REPORT  OF  ROAD  OR  BRIDGE  PROJECTS  EFFECTING  PLANNING  INVENTORY  DATA"]
["(Send  to  RP  to  update  Straight-Line  Diagrams)"]
[]
["A.  IDENTIFICATION  INFORMATION",null,null,null,null,null,"                        P. O.  Request Date:",null,null,{"$f":"NOW()","v":"2024-02-05T10:45:10.610"}]
[null,null,null,null,null,null,"                        Prepared By:"]
["    l.  District ",null,{"$f":"'Order Details'!D3","v":"05"},null,null,null,"                        Data Column:"]
[null,null,null,null,null,null,"                        Authorization No:"]
["    2.  County ",null,{"$f":"'Order Details'!B3","v":"Berkeley"},null,null,null,"                        Approx. Cost",null,null,{"$f":"'Order Summary'!$H$8","v":31.479999999999997}]
[]
["    3.  I, US, WV, Co. & Route Number ",null,null,null,{"$f":"'Order Details'!B6","v":0},{"$f":"'Order Details'!B7","v":0},"/",{"$f":"IF('Order Details'!$B$8=\"\",\"\",'Order Details'!$B$8)","v":""}]
[]
["    4.  Beginning Milepoint ",null,null,{"$f":"'Order Details'!E6","v":0}]
[]
["    5.  Ending Milepoint (before project) ",null,null,null,{"$f":"'Order Details'!E7","v":0}]
[]
[null,null,null,"District Equipment Shop"]
["    6. Project beginning is ",null,null,null,"miles",null,null,"from jct. with Route Number"]
[null,null,null,"to "]
[]
["    7.  Length of new work ",null,null,{"$f":"'Order Details'!B24","v":0}]
[]
["    8.  Project Number "]
[]
[]
["B.  Nature of Work"]
[]
["    1. Road",null,"     Bridge",null,"      Bridge & Approaches",null,null,null,"       Other"]
[]
["    2.  Narrative Description of Work:"]
[]
[null,"  Examples:  Widen to 16' and stab Reconst to 2 12' ln, 4' shl  "]
[null,null,"  Reinf base and pave Traf sig, Sign, Light, Pvmt. Mark  "]
[null,null,"  Const 2 l0' ln, 4' shl Repl New Loc, 28' wide conc slab "]
[]
[]
[]
["    3.  New Pavement Width (if paved) "]
[]
["    4.  New Grade Width "]
[]
["    5.  New Pavement:"]
[]
[null,"       Example:  110 #/ST HLBC patch & level & 110 #/SY HLBC Wearing Course"]
[]
[]
[]
[]
[]
[]
[]
[]
["    6.  Date Work Completed ",null,null,null,null,"     Date Work Started "]
[]
[]
[null,"Prepared by:  ",null,null,null,null,null,"Date:"]
[null,null,null,"  (Please print or type) "]

{"sheet":"FIELD","index":8,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,8,37,12],[38,8,38,12],[35,8,35,12],[36,8,36,12],[11,7,12,12],[13,8,13,12],[23,8,23,12],[24,8,24,12],[19,8,19,12],[20,8,20,12],[21,8,21,12],[22,8,22,12],[14,8,14,12],[15,8,15,12],[16,8,16,12],[17,8,17,12],[0,0,0,12],[1,7,1,12],[2,8,2,9],[3,8,3,9],[4,8,4,9],[2,10,2,12],[1,0,1,2],[3,0,3,2],[4,0,4,2],[1,3,1,4],[3,3,3,4],[1,5,1,6],[2,5,2,6],[2,0,2,2],[2,3,2,4],[7,0,10,2],[3,10,3,12],[4,10,4,12],[5,8,5,9],[6,8,6,9],[5,10,5,12],[5,0,5,2],[6,0,6,2],[7,3,10,12],[3,5,3,6],[4,5,4,6],[5,3,5,7],[6,3,6,7],[4,3,4,4],[11,0,11,2],[12,0,12,2],[13,0,13,2],[11,3,11,5],[12,3,12,5],[33,8,33,12],[34,8,34,12],[14,5,14,6],[14,0,14,2],[32,8,32,12],[31,8,31,12],[30,8,30,12],[25,8,25,12],[26,8,26,12],[27,8,27,12],[28,8,28,12],[29,8,29,12],[18,8,18,12]]}
["HOT-MIXED ASPHALT PROJECT DATA (FOR FIELD PERSONNEL, BOTH STATE & CONTRACTOR)"]
["Project Title:",null,null,{"$f":"'Order Details'!B17","v":0},null,"Project Description:",null,{"$f":"'Order Details'!B18","v":0}]
["Project Number:",null,null,{"$f":"'Order Details'!B20","v":0},null,"Longitude:",null,null,"Agency Release No.",null,{"$f":"IF('Order Details'!$B19=\"\",\"\",'Order Details'!$B19)","v":""}]
["County:",null,null,{"$f":"'Order Details'!$B$3","v":"Berkeley"},null,"Latitude:",null,null,"Prepared By:"]
["Auth. No.:",null,null,{"$f":"'Order Details'!B21","v":0},null,"Date:",null,{"$f":"TODAY()","v":"2024-02-05"},"Length (miles):",null,{"$f":"'Order Details'!B24","v":0}]
["Begin:",null,null,{"$f":"'Order Details'!$B$16","v":0},null,null,null,null,"Route Sign:",null,{"$f":"'Order Details'!$B$6","v":0}]
["End:",null,null,{"$f":"'Order Details'!$B$17","v":0},null,null,null,null,"Route No.:",null,{"$f":"'Order Details'!B7","v":0},{"$f":"\"/\"","v":"/"},{"$f":"IF('Order Details'!$B$8=\"\",\"\",'Order Details'!$B$8)","v":""}]
["Further Description:\nand \nComments:"]
[]
[]
[]
["Vendor PID:",null,null,{"$f":"'Order Summary'!$H$6","v":513},null,null,null,"FIELD INSPECTOR'S COPY"]
["Vendor Name:",null,null,{"$f":"'Order Summary'!$H$4","v":"C WILLIAM HETZER INC"}]
["Vendor Location:",null,null,{"$f":"'Order Summary'!$H$5","v":"10104 Mapleville Road\nHagerstown, MD 21740"},null,null,null,"Actual","Comment"]
[null,null,null,null,"Qty."]
[1,"Asphalt Section 401 - Base I",null,null,{"$f":"'Order Details'!J7","v":1}]
[2,"Asphalt Section 401 - 25mm Superpave",null,null,{"$f":"'Order Details'!J8","v":0}]
[3,"Asphalt Section 401 - Base II",null,null,{"$f":"'Order Details'!J9","v":0}]
[4,"Asphalt Section 401 - Patch and Level",null,null,{"$f":"'Order Details'!J10","v":0}]
[5,"Asphalt Section 401 - Wearing IV",null,null,{"$f":"'Order Details'!J11","v":0}]
[6,"Asphalt Section 402 - Wearing IV",null,null,{"$f":"'Order Details'!J12","v":0}]
[7,"Asphalt Section 401 - 19mm Superpave",null,null,{"$f":"'Order Details'!J13","v":0}]
[8,"Asphalt Section 401 - Scratch Course",null,null,{"$f":"'Order Details'!J14","v":0}]
[9,"Asphalt Section 402 - 9.5mm Superpave",null,null,{"$f":"'Order Details'!J15","v":0}]
[10,"Asphalt Section 401 - Wearing 1",null,null,{"$f":"'Order Details'!J16","v":0}]
[11,"Asphalt Section 402 - Wearing 1",null,null,{"$f":"'Order Details'!J17","v":0}]
[12,"Asphalt Section 401 - 4.75mm Superpave",null,null,{"$f":"'Order Details'!J18","v":0}]
[13,"Asphalt Section 402 - 4.75mm Superpave",null,null,{"$f":"'Order Details'!J19","v":0}]
[14,"Asphalt Section 401 - Wearing III",null,null,{"$f":"'Order Details'!J20","v":0}]
[15,"Asphalt Section 402 - Wearing III",null,null,{"$f":"'Order Details'!J21","v":0}]
[16,"Asphalt Section 401 - 12.5mm Superpave",null,null,{"$f":"'Order Details'!J22","v":0}]
[17,"Asphalt Section 402 - 12.5mm Superpave",null,null,{"$f":"'Order Details'!J23","v":0}]
[18,"Asphalt Plant Run ",null,null,{"$f":"'Order Details'!J24","v":0}]
[19,"Surcharge for PG Binder - 64H minus 22",null,null,{"$f":"'Order Details'!J25","v":0}]
[20,"Surcharge for PG Binder - 64E minus 22 - ordered in 400 ton increments",null,null,{"$f":"'Order Details'!J26","v":0}]
[21,"ESAL Surcharge - 3 million to 20 million ESALs",null,null,{"$f":"'Order Details'!J27","v":0}]
[22,"ESAL Surcharge - Greater than 20 million ESALs",null,null,{"$f":"'Order Details'!J28","v":0}]
[23,"Off-Season Plant Opening - First Day",null,null,{"$f":"'Order Details'!J29","v":0}]
[24,"Off-Season Plant Opening - Each Additional Day",null,null,{"$f":"'Order Details'!J30","v":0}]