{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Input screen","Coding","Production Rate Estimates","Historical Production Rates","Regression Coefficients","Background"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Welcome to the MDT Production Rate Estimation Tool (PRET)"]
[]
[null,"This user-friendly tool is designed to help MDT to quantitatively estimate production rates of major controlling activities of highway projects using the historical project data."]
[]
[null,"PRET consists of three major sections. A user needs to provide specific project parameters in the first section such as district, location type, season of work, budget type, and project type. Also, the user needs to provide the engineer's estimate of the project under consideration and quantities of work items.                        "]
[]
[null,"Once the input values are provided, PRET will estimate production rates for up to 31 major controlling activities using regression models."]
[]
[null,"Historical production rates are also provided for comparison through common statistical measures with various districts, locations, and budget categories. "]

{"sheet":"Input screen","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Select District","District 2 - Butte"]
[null,"The maintenance district where the project is geographically located."]
[]
[null,"Select Location Type","Urban"]
[null,"Rural or Urban area is selected according to the location of the project."]
[]
[null,"Select Season of Work","Winter"]
[null,"The season in which construction works is undertaken."]
[]
[null,"Select Project Type","110 - Reconstruction/New Construction"]
[null,"The project work type is selected from MDT's project work types."]
[]
[null,"Enter Engineer's Estimate:",3000000]

{"sheet":"Coding","index":2,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,"CODING"]
["Select District"]
[null,"Option",null,"Selection",{"$f":"'Input screen'!C6","v":"District 2 - Butte"}]
[1,"District 1 - Missoula",null,null,"Index","Value"]
[2,"District 2 - Butte",null,null,null,{"$f":"MATCH(E3,District)","v":2}]
[3,"District 3 - Great Falls"]
[4,"District 4 - Glendive"]
[5,"District 5 - Billings"]
["Select Location"]
[null,"Option",null,"Selection",{"$f":"'Input screen'!C9","v":"Urban"}]
[0,"Rural",null,null,"Index","Value"]
[1,"Urban",null,null,null,{"$f":"IF(E10=\"Rural\",0,1)","v":1}]
["Select Season of Work"]
[null,"Option",null,"Selection",{"$f":"'Input screen'!C12","v":"Winter"}]
[1,"Winter",null,null,"Index","Value"]
[0,"Construction",null,null,null,{"$f":"IF(E14=\"Construction\",0,1)","v":1}]
["Select Allocated Budget"]
[null,"Option",null,"Selection"]
[0,"Less than $2 Million",null,null,"Index","Value"]
[1,"Greater than $2 Million",null,null,null,{"$f":"IF(B42<2000000,0,1)","v":1}]
["Select Project Type"]
[null,"Option",null,"Selection",{"$f":"'Input screen'!C15","v":"110 - Reconstruction/New Construction"}]
["Type code","Project work type",null,null,"Index","Value"]
[110,"Reconstruction/New Construction",{"$f":"CONCATENATE(A24,\" - \",B24)","v":"110 - Reconstruction/New Construction"},{"$f":"A24","v":110},null,{"$f":"VLOOKUP(E22,C24:D40,2,FALSE)","v":110}]
[111,"Facilities (Buildings)",{"$f":"CONCATENATE(A25,\" - \",B25)","v":"111 - Facilities (Buildings)"},{"$f":"A25","v":111}]
[141,"Drainage","141 - Drainage",141]
[150,"Major Rehabilitation","150 - Major Rehabilitation",150]
[160,"Overlay","160 - Overlay",160]
[170,"Portland Cement Concrete Pavement","170 - Portland Cement Concrete Pavement",170]
[183,"Seal & Cover","183 - Seal & Cover",183]
[185,"Crack Seal","185 - Crack Seal",185]
[210,"Bridge Construction","210 - Bridge Construction",210]
[230,"Major Bridge Rehabilitation","230 - Major Bridge Rehabilitation",230]
[232,"Minor Bridge Rehabiiitation","232 - Minor Bridge Rehabiiitation",232]
[310,"Safety","310 - Safety",310]
[410,"Traffic Signals & Lighting","410 - Traffic Signals & Lighting",410]
[411,"Signing, Pavment Markings","411 - Signing, Pavment Markings",411]
[510,"Environmental","510 - Environmental",510]
[520,"Landscaping","520 - Landscaping",520]
[620,"Bicycle & Pedestrian Facilities","620 - Bicycle & Pedestrian Facilities",620]
["Type in Dollar Amount of the Project:"]
[null,{"$f":"'Input screen'!C18","v":3000000}]

{"sheet":"Production Rate Estimates","index":3,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,1],[2,3,3,3],[2,2,3,2],[2,4,3,4],[2,5,2,8]]}
["PRODUCTION RATE ESTIMATES"]
[]
["SN","Activity Description","Unit","Quantity","Production Rates\n(Per day)","Statistical measures from historical data",null,null,null,null,"Note:"]
[null,null,null,null,null,"Mean","Q1","Median","Q3",null,"a. Provide quantities for controlling activities in column D."]
["AA","TOPSOIL-SALVAGING AND PLACING","CUYD",null,{"$f":"Background!AD3","v":""},2313.4211178270148,306.19050000000004,1267.2308333333335,3071.3959176648113,null,"b. Predicted production rates are shown in column E."]
["AB","EXCAVATION-UNCLASSIFIED","CUYD",null,{"$f":"Background!AD4","v":""},8874.3465926090685,940.69666666666672,4950,12541.838941715952,null,"c. Mean: average production rate of historical projects."]
["AC","SPECIAL BORROW","CUYD",null,{"$f":"Background!AD5","v":""},3640.2539261089901,644.79889537940312,1807.8022083206727,3709.7912499999998,null,"d. Q1: 25% of historical projects have production rates lower than Q1."]
["AD","EXCAVATION-STREET","CUYD",null,{"$f":"Background!AD6","v":""},1518.1244878192754,518.40249999999992,977.84719999999993,2426.3667857142855,null,"e. Median: 50% of historical projects have production rates lower than Median."]
["AE","CRUSHED AGGREGATE COURSE","CUYD",null,{"$f":"Background!AD7","v":""},2087.9926693411835,132.09375,636.17631791654685,2653.5211683168145,null,"f. Q3: 75% of historical projects have production rates lower than Q3."]
["AF","BASE-CEMENT TREATED","CUYD",null,{"$f":"Background!AD8","v":""},3453.3634909105554,1549.766594998425,3565.8003759058615,5045.1139999999996]
["AG","DRAINAGE PIPE (<= 24 IN)","LNFT",null,{"$f":"Background!AD9","v":""},95.233632207673409,59.042307692307688,86.77421419883494,112.22858506323075]
["AH","DRAINAGE PIPE (> 24 IN)","LNFT",null,{"$f":"Background!AD10","v":""},91.077115947174264,54.826279527559066,72.800000000000011,118.5]
["AI","RCB","LNFT",null,{"$f":"Background!AD11","v":""},95.3230227471566,48.75,66.013451443569551,139.5]
["AJ","SSPP","LNFT",null,{"$f":"Background!AD12","v":""},65.5,21,54,98.5]
["AK","RIPRAP","CUYD",null,{"$f":"Background!AD13","v":""},136.25338008434616,23.6,94.21,202.71201330683056]
["AL","COLD MILLING","SQYD",null,{"$f":"Background!AD14","v":""},15077.227912343067,1911.1,8220.1,20472.349999999999]
["AM","PLANT MIX SURFACING","TON",null,{"$f":"Background!AD15","v":""},1508.9349215872192,378.27471590909084,1027.7912608695653,2177.091273109244]
["AN","COVER","SQYD",null,{"$f":"Background!AD16","v":""},83884.18651805562,15891.575000000001,56360.180911223855,120457.647]
["AO","MICROSURFACING","TON",null,{"$f":"Background!AD17","v":""},464.59539722222218,407.92374999999998,442.77525000000003,525.46566666666661]
["AP","CRACK SEALING","LB",null,{"$f":"Background!AD18","v":""},6345.9750287639717,3003.75,5129.7888888888883,8003.3374999999996]
["AQ","PCCP","SQYD",null,{"$f":"Background!AD19","v":""},568.3882638888889,236.67250000000004,447.5,1104.5]
["AR","CURB AND GUTTER","LNFT",null,{"$f":"Background!AD20","v":""},408.38925931320733,136.55745341614906,261,562.01102866949327]
["AS","SIDEWALK","SQYD",null,{"$f":"Background!AD21","v":""},246.48669338338465,60.775000000000006,130.81015645230428,282.52237499999995]
["AT","FARM FENCE","LNFT",null,{"$f":"Background!AD22","v":""},2205.8714011100733,540.31069553805776,1423.1,2422.3738248628015]
["AU","GUARDRAIL STEEL","LNFT",null,{"$f":"Background!AD23","v":""},679.50604070554175,150,424.43733595800541,901.68750000000011]
["AV","CONCRETE BARRIER RAIL","EACH",null,{"$f":"Background!AD24","v":""},57.534668803418803,12.25,25,84.074999999999989]
["AW","SEEDING","ACRE",null,{"$f":"Background!AD25","v":""},12.236424835301277,2.5125000000000002,7.2,18.065462596762014]
["AX","REINFORCING STEEL","LB",null,{"$f":"Background!AD26","v":""},13995.350781214542,5194.7416440896768,10516.5,18271.316666666666]
["AY","DRILLED SHAFT","LNFT",null,{"$f":"Background!AD27","v":""},102.56161616161616,59.009090909090901,87.818181818181813,138.74242424242425]
["AZ","CONCRETE-CLASS DECK","CUYD",null,{"$f":"Background!AD28","v":""},72.621441618195078,43.044654881636646,60.550000000000004,84.83278854362635]
["BA","CLASS A BRIDGE DECK REPAIR","SQYD",null,{"$f":"Background!AD29","v":""},14.474505135387489,4.875,7.8000000000000007,17.166666666666668]
["BB","CONCRETE BARRIER RAIL-BRIDGE","LNFT",null,{"$f":"Background!AD30","v":""},222.16751906011748,88.049540682414715,141.05000000000001,252.27500000000001]
["BC","CONCRETE-CLASS OVERLAY","CUYD",null,{"$f":"Background!AD31","v":""},31.442678571428573,22.683035714285715,34.810357142857143,43.57]
["BD","BRIDGE DECK MILLING","SQYD",null,{"$f":"Background!AD32","v":""},472.5310966810967,311.73750000000001,394.125,583.84772727272718]
["BE","REVISE BRIDGE CONCRETE BARRIER","LNFT",null,{"$f":"Background!AD33","v":""},199.68825518762898,69.125,157.39999999999998,245.25]

{"sheet":"Historical Production Rates","index":4,"n_rows":41,"n_cols":49,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,1,3],[2,29,2,33],[2,34,2,38],[2,39,2,43],[2,44,2,48],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,2,8],[2,9,2,13],[2,14,2,18],[2,19,2,23],[2,24,2,28]]}
["HISTORICAL PRODUCTION RATES"]
[]
["SN","Activity Description","Unit","Mean","Rural",null,null,null,null,"Urban ",null,null,null,null,"Budget less than $2 Million",null,null,null,null,"Budget greater than $2 Million",null,null,null,null,"District 1",null,null,null,null,"District 2",null,null,null,null,"District 3",null,null,null,null,"District 4",null,null,null,null,"District 5"]
[null,null,null,"Mean","Mean","Q1","Median","Q3","N","Mean","Q1","Median","Q3","N","Mean","Q1","Median","Q3","N","Mean","Q1","Median","Q3","N","Mean","Q1","Median","Q3","N","Mean","Q1","Median","Q3","N","Mean","Q1","Median","Q3","N","Mean","Q1","Median","Q3","N","Mean","Q1","Median","Q3","N"]
["AA","TOPSOIL-SALVAGING AND PLACING","CUYD",2313.4211178270148,2504.8341,392.46499999999997,1388.5150000000001,3323.8625000000002,180,1174.0869,153.13,531.95000000000005,2058.81,13,1015.4754,122.9375,352.20499999999998,1248.28,80,3383.0679,1140.1600000000001,2619.54,4629.5600000000004,115,1902.1488999999999,272.5625,1566.5,2784.53,36,2114.1415000000002,261.60000000000002,847.23,2708.92,39,3384.0484000000001,394.99250000000001,1144.9649999999999,3015.94,38,2818.7037999999998,150.63499999999999,1487.23,4650.3999999999996,37,2886.2752,800.35249999999996,1783.605,3200.8,44]
["AB","EXCAVATION-UNCLASSIFIED","CUYD",8874.3465926090685,9274.0571,1219,5506,13169.75,140,9468.4,107,318,14370,15,3186.1176,321.75,1127,4884.25,68,13972.124,4507.5,10455,21758.5,89,7298,518.75,3236,9060.75,46,7974.4827999999998,902.5,4185,12556,29,9818.7083000000002,820.25,6003,13560.5,24,13725.825999999999,2206,11171,21875,23,9632.1764999999996,2112.75,6123,13609.75,34]
["AC","SPECIAL BORROW","CUYD",3640.2539261089901,3919.7386000000001,744.9425,1938.915,3644.6774999999998,110,1645.7063000000001,269.01249999999999,694.36500000000001,1842.2574999999999,16,1159.9042999999999,236.26,583.41,1629.19,37,4656.3185000000003,1063.4825000000001,2428.23,4479.0249999999996,92,3494.1914000000002,356.685,1096,4489.3999999999996,29,5107.6896999999999,686.875,2069.19,5003.3950000000004,29,2767.1613000000002,423.59,1665.77,2275.6,15,3108.7611000000002,1197.51,1971.77,3612.12,19,3340.9513999999999,653.23500000000001,1796.355,3961.3225000000002,36]
["AD","EXCAVATION-STREET","CUYD",1518.1244878192754,2003.51,714.42499999999995,1522.71,2620.5475000000001,12,1173.9169999999999,191.00749999999999,908.65,2426.37,10,993.81399999999996,191.00749999999999,508.95,2157.8249999999998,10,2153.5958000000001,898.37249999999995,1755.67,2620.5475000000001,12,1812.925,1054.3375000000001,1856.1949999999999,2528.2424999999998,4,1423.7325000000001,358.26499999999999,1362.4949999999999,2550.4375,4,1496.5571,204.45,971.19,2647.9,7,1478.825,661.2,1478.825,2296.4499999999998,2,1880.222,194.88,874.1,4068.625,5]
["AE","CRUSHED AGGREGATE COURSE","CUYD",2087.9926693411835,2467.4924999999998,161.13499999999999,794.30499999999995,3158.82,242,686.37888999999996,75.362499999999997,452.01,867.21,36,604.59810000000004,60.895000000000003,184.19,557.495,137,3732.8838000000001,771.81500000000005,2475.0100000000002,5502.17,146,1393.0162,95.03,527.99,2017.34,71,2577.7671,292.74,876.24,3846.58,51,1974.2677000000001,139.82,566.87,2575.9699999999998,53,2486.4193,313.19499999999999,1003.55,3139.4,45,2909.3465000000001,94.224999999999994,846.68,3277.9050000000002,62]
["AF","BASE-CEMENT TREATED","CUYD",3453.3634909105554,3453.3638000000001,1358.2650000000001,3565.8,5281.39,13,null,null,null,null,null,null,null,null,null,null,3453.3638000000001,1358.2650000000001,3565.8,5281.39,13,null,null,null,null,null,8009.76,8009.76,8009.76,8009.76,1,6114.81,6114.81,6114.81,6114.81,1,2737.5088999999998,1084.9100000000001,2069.5500000000002,4585,9,3065.79,2565.7800000000002,3065.79,3565.8,2]
["AG","DRAINAGE PIPE (<= 24 IN)","LNFT",95.233632207673409,97.205376000000001,61.625,88.17,112.23,173,98.096249999999998,44.567500000000003,78.290000000000006,122.9825,24,73.287026999999995,41.522500000000001,63.9,102.125,74,111.5136,79.400000000000006,100.84,127.825,125,116.456,75.52,103.105,136.215,40,99.343783999999999,47.134999999999998,96.46,134.07499999999999,37,81.049786999999995,55,70,101.92,47,94.907499999999999,76.392499999999998,90.6,103.57,28,92.433042999999998,56.344999999999999,87.9,128.96250000000001,46]
["AH","DRAINAGE PIPE (> 24 IN)","LNFT",91.077115947174264,88.785799999999995,58.33,72.8,116.35250000000001,100,115.43,29.45,87.93,189.68,11,86.213042999999999,39.04,63.33,107,23,92.754555999999994,60.295000000000002,78.94,122.1875,90,103.35142999999999,63.784999999999997,91.86,136.21,21,99.432272999999995,45.695,72.644999999999996,131.83250000000001,22,66.116667000000007,37.53,61.034999999999997,91.842500000000001,18,90.305000000000007,60.692500000000003,74.91,126.75,24,87.618148000000005,59.11,78,108,27]
["AI","RCB","LNFT",95.3230227471566,98.91,48,69.015000000000001,143.125,26,74.010000000000005,18,60,144.03,3,97.087500000000006,42.375,55.5,184.6,8,96.047143000000005,51,72,139,21,54.8,48,54.8,61.6,2,112.43583,52.75,91.415000000000006,159.92500000000001,12,39.5,22.5,40,56,4,96,54,102,132,3,106.40429,36,66.03,200,7]
["AJ","SSPP","LNFT",65.5,65.5,19,54,123.5,4,null,null,null,null,null,54,22,54,86,2,77,18,77,136,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,18,86,136,3,22,22,22,22,1]
["AK","RIPRAP","CUYD",136.25338008434616,145.31178,26.79,105.31,211.315,129,66.703333000000001,23.537500000000001,40.72,95.8,12,142.6388,25.9,112.45,205.8075,50,133.96355,24.79,92.67,207.60499999999999,93,147.53614999999999,27.5075,93.28,177.42500000000001,26,117.61609,25,101.53,191.56,23,129.47148000000001,21.54,81.12,209.37,27,179.10035999999999,61.407499999999999,138.19999999999999,287.1925,28,116.21789,18.377500000000001,72.16,203.1825,38]
["AL","COLD MILLING","SQYD",15077.227912343067,16636.246999999999,1977.7750000000001,9448.61,22841.428,206,7854.8977999999997,1038.4000000000001,5235.37,8759.9249999999993,37,12997.163,1706.7075,6244.17,15639.133,134,17750.486000000001,2542.38,10945.33,23589.53,113,12389.1,2122.1824999999999,5205.8,17020.294999999998,48,20746.392,4004.27,13649.565000000001,28342.363000000001,68,11075.428,746.54750000000001,3212.7849999999999,8626.6849999999995,52,12372.07,1252.615,8498.5,15155.45,33,16473.758000000002,4672.8900000000003,15014.584999999999,23143.332999999999,46]
["AM","PLANT MIX SURFACING","TON",1508.9349215872192,1700.7113999999999,477.75,1257.5,2476.75,350,669.61111000000005,160.5,421.5,749.75,54,1013.1697,141,532,1322.5,218,2173.5156000000002,994,1847,2781,192,1679.9213,193.5,948,2575,89,1793.5851,534.5,1297.5,2466,94,1227.3377,219.5,628,2087.5,77,1565.2742000000001,461,1608,2346.25,62,1468.8621000000001,522,1151,1928,87]
["AN","COVER","SQYD",83884.18651805562,87218.525999999998,19662.599999999999,62965.94,126711.6,326,45297.154000000002,7055.5749999999998,14070.95,34332.688000000002,38,73085.004000000001,8801.9500000000007,39143.199999999997,117432.65,191,92000.464999999997,30671.075000000001,67959.12,123105.76,178,101889.89,23538.755000000001,80329.87,141482.25,81,94331.091,24195.279999999999,57466.7,133790,87,72923.562000000005,8632.2000000000007,30227.599999999999,117820.97,81,71763.448999999993,35281.055,62566.125,91185.862999999998,48,63577.159,13753.59,39429,91045.3,71]
["AO","MICROSURFACING","TON",464.59539722222218,483.50545,420.87,450.67,565.67999999999995,11,null,null,null,null,null,483.50545,420.87,450.67,565.67999999999995,11,null,null,null,null,null,456.17124999999999,382.02749999999997,436.78,507.03250000000003,8,null,null,null,null,null,565.67999999999995,565.67999999999995,565.67999999999995,565.67999999999995,1,null,null,null,null,null,551.755,434.88,551.755,668.63,2]
["AP","CRACK SEALING","LB",6345.9750287639717,6324.3779999999997,3166.67,5232.78,8395,35,4157.88,1051,3625,6875,7,6030.73,2958.335,5232.78,7375,37,5464.2759999999998,2085,4830,9160.69,5,2858.7925,1343.75,2770.835,4461.7924999999996,4,5108.59,2785,5505,6753,13,7163.4168,3482.9175,6038.96,8937.5,22,8671.3799999999992,8671.3799999999992,8671.3799999999992,8671.3799999999992,1,3172.5,1515,3172.5,4830,2]
["AQ","PCCP","SQYD",568.3882638888889,924.4,481.58499999999998,1130.02,1161.595,4,431.72143,149.34,394.9,518.23,7,805.81667000000004,149.34,1096.33,1171.78,3,537.77499999999998,272.1225,447.5,976.3075,8,1132.3699999999999,1096.33,1129,1171.78,3,1131.04,1131.04,1131.04,1131.04,1,370.74400000000003,220.245,394.9,509.16500000000002,5,265.77999999999997,265.77999999999997,265.77999999999997,265.77999999999997,1,72,72,72,72,1]
["AR","CURB AND GUTTER","LNFT",408.38925931320733,479.84825000000001,162.84,288.5,672.26,57,336.53073000000001,111.575,256.12,524.46500000000003,41,257.12824999999998,104.48,168.18,310.5,63,667.995,424.46,542.36500000000001,923.8,40,303.20679000000001,106.0625,243.625,430.2,28,504.47500000000002,99.51,373.08,880.00250000000005,18,424.67,146.25,223.15,678.17750000000001,26,416.68299999999999,112.0425,243,660.11249999999995,10,481.36750000000001,146.11500000000001,466.18,757.05,20]
["AS","SIDEWALK","SQYD",246.48669338338465,251.06112999999999,68.262500000000003,128.87,315.13249999999999,62,239.16974999999999,56.887500000000003,197.38499999999999,297.80250000000001,40,196.26754,52.31,92.3,225.2,69,319.15973000000002,122.1,245.66,454.12,37,218.39896999999999,41.97,112.1,284.36500000000001,29,366.00578999999999,76.7,145.25,493.35,19,217.52073999999999,59.58,210.64,291.3,27,200.64667,62.655000000000001,146.75,332.995,9,197.47713999999999,59.484999999999999,107.77,184.42,21]
["AT","FARM FENCE","LNFT",2205.8714011100733,2332.6703000000002,552.93499999999995,1490,2511.5324999999998,146,699.28332999999998,379.875,630.70000000000005,1031.96,6,1139.0453,329.875,481.33,1652.5,57,2934.9811,1156.4649999999999,1955.99,4430.8625000000002,96,1315.7845,739.35500000000002,1161.76,1978.35,20,1856.5030999999999,423.72500000000002,1418.4749999999999,2413.5524999999998,26,1745.3587,531.41750000000002,1415.665,2207.1925000000001,30,4190.2803000000004,654,2508.83,6928.51,35,1739.9626000000001,377.82249999999999,1346.2449999999999,2319.7525000000001,42]
["AU","GUARDRAIL STEEL","LNFT",679.50604070554175,680.69386999999995,146,450,912.5,199,374.09615000000002,155.16499999999999,252.6,533.625,13,647.68934999999999,120.5,475,968.75,92,674.50702000000001,162.57499999999999,406.25,890.8125,124,856.29648999999995,216.155,607.29999999999995,1275.25,57,734.63250000000005,128.57249999999999,433.76499999999999,968.75,52,484.73604999999998,84.375,310.66500000000002,663.95,38,483.18142999999998,81,174,756,21,587.36,181.25,378,817.79,47]
["AV","CONCRETE BARRIER RAIL","EACH",57.534668803418803,57.732759000000001,16,25,97.885000000000005,29,67.5,6,7,189.5,4,47.650908999999999,16.329999999999998,25,44,11,64.549544999999995,8,23.75,118.94499999999999,22,63.586111000000002,12.25,22.5,117.7225,18,50.787500000000001,18.497499999999999,35.5,61.752499999999998,8,85.866667000000007,22.5,81.599999999999994,153.5,3,null,null,null,null,null,33.950000000000003,6,7,88.85,4]
["AW","SEEDING","ACRE",12.236424835301277,13.140131,2.9750000000000001,8.43,19.43,153,7.9474999999999998,0.83499999999999996,2.35,17.857500000000002,8,4.2791071000000001,1.2275,2.91,6.5125000000000002,56,17.297664000000001,5.75,12.84,25.66,107,11.127692,3.59,6.3449999999999998,18.574999999999999,26,12.377647,2.6974999999999998,9.4550000000000001,18.662500000000001,34,8.5821622000000009,2.2650000000000001,4.22,13.125,37,18.111332999999998,2.0325000000000002,12.595000000000001,33.82,30,14.428889,4.1349999999999998,11.09,19.895,36]
["AX","REINFORCING STEEL","LB",13995.350781214542,14190.582,5326.2,10832.83,18586.330000000002,67,17632.89,4125.18,17322.27,31295.91,5,7340.5689000000002,1731.615,4847.125,8918.0475000000006,18,16792.651999999998,7693.67,12859.555,19913.402999999998,54,19069.347000000002,7825.86,16278.93,21312.67,15,16068.92,6149.9575000000004,12117.684999999999,19360.887999999999,16,11878.209000000001,870.3175,7893.1750000000002,20181.782500000001,14,11991.526,6099.28,10832.83,15054.7,13,10592.803,4720.12,8292.9599999999991,15762.725,13]
["AY","DRILLED SHAFT","LNFT",102.56161616161616]
["AZ","CONCRETE-CLASS DECK","CUYD",72.621441618195078,74.679444000000004,43.22,61.56,87.252499999999998,54,55.912500000000001,13.4175,53.52,100.8,4,48.993749999999999,38.272500000000001,50.234999999999999,59.3125,8,77.287800000000004,43.22,69.665000000000006,97.517499999999998,50,75.302000000000007,39.72,67.319999999999993,117.14,15,77.758461999999994,55.534999999999997,60.55,92.54,13,54.334443999999998,27.895,54.54,84.924999999999997,9,82.89,39.15,72.290000000000006,89.465000000000003,9,69.906363999999996,39.65,45.87,78.459999999999994,11]
["BA","CLASS A BRIDGE DECK REPAIR","SQYD",14.474505135387489,13.685714000000001,4.57,7.4850000000000003,16.407499999999999,42,19.823333000000002,9.4,12.97,37.1,3,14.193077000000001,4.9074999999999998,9.9700000000000006,18.91,26,13.960526,4.6500000000000004,7.67,15.6,19,25.123999999999999,6.8650000000000002,12.97,49.46,5,13.0748,6,9.93,15.164999999999999,25,15.6,3.45,11.2,32.15,4,10.728332999999999,0.78749999999999998,2.4900000000000002,27.07,6,11.002000000000001,3.4449999999999998,6.85,20.635000000000002,5]
["BB","CONCRETE BARRIER RAIL-BRIDGE","LNFT",222.16751906011748,227.87125,83.002499999999998,133.16499999999999,253.49250000000001,24,187.9425,121.845,182.89,259.09249999999997,4,141,86.8,141.05000000000001,195.15,4,235.69499999999999,87.97,139.05500000000001,268.49250000000001,24,234.43364,88.09,128.83000000000001,251.67,11,261.36286000000001,90.55,144.6,346.44,7,89.052499999999995,70.042500000000004,74.989999999999995,122.125,4,118.185,69.900000000000006,118.185,166.47,2,315.5,212,216.5,518,3]
["BC","CONCRETE-CLASS OVERLAY","CUYD",31.442678571428573]
["BD","BRIDGE DECK MILLING","SQYD",472.5310966810967,489.07166999999998,230.66,462.49,715.21749999999997,6,null,null,null,null,null,572.53,261.78750000000002,583.85,871.95249999999999,4,322.15499999999997,250.18,322.15499999999997,394.13,2,null,null,null,null,null,636.85,636.85,636.85,636.85,1,272.13666999999998,172.1,250.18,394.13,3,null,null,null,null,null,740.58500000000004,530.85,740.58500000000004,950.32,2]
["BE","REVISE BRIDGE CONCRETE BARRIER","LNFT",199.68825518762898,203.18486999999999,62.5,156.65,250.3,39,9.4,3,9.4,15.8,2,139.36832999999999,50.292499999999997,135,181.785,18,236.27739,27.5,161.58000000000001,262.63,23,172.86,110,161.58000000000001,247,3,168.59,36.734999999999999,146,236.23,25,220,220,220,220,1,732.375,392,732.375,1072.75,2,152.49299999999999,10.3725,150.5,278.85000000000002,10]
[]
[null,null,null,null,null,null,null,null,"NOTE:","Mean: average production rate of historical projects."]
[null,null,null,null,null,null,null,null,null,"Q1: 25% of historical projects have production rates lower than Q1."]
[null,null,null,null,null,null,null,null,null,"Median: 50% of historical projects have production rates lower than Median."]
[null,null,null,null,null,null,null,null,null,"Q3: 75% of historical projects have production rates lower than Q3."]
[null,null,null,null,null,null,null,null,null,"N: number of historical projects used to calculate statistical measures"]

{"sheet":"Regression Coefficients","index":5,"n_rows":33,"n_cols":46,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,5,0,28],[0,29,0,33],[0,34,0,35],[0,36,0,37],[0,38,0,39]]}
[null,null,"INTERCEPT","QUANTITY","PRJCT_TTL_AMT","NEW_WORK_TYPE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DISTRICT",null,null,null,null,"BUDGET",null,"AREA",null,"WINTER",null,"NBR_PECS","NBR_USED","USED_HRS","NBR_SUPRVSR","OTH_WRKR","WRKD_HRS"]
["No","Production Rate Items",null,null,null,110,111,120,141,150,160,170,183,185,210,230,232,310,311,312,313,410,411,412,510,520,620,650,710,1,2,3,4,5,0,1,0,1,0,1]
[1,"TOPSOIL-SALVAGING AND PLACING",-283.12139999999999,0.14178160000000001,null,1166.1206999999999,735.67628000000002,2995.4866000000002,1199.9124999999999,1620.0767000000001,1541.4827,1890,4569.0321999999996,1890,1068.3311000000001,1654.4627,714.13550999999995,1550.4478999999999,null,null,1138.6668999999999,1890,1890,null,4064.5464000000002,1890,2462.1941999999999,3759.7467000000001,0,-1462.1369999999999,-425.83179999999999,-749.56759999999997,-1353.816,0,null,null,null,null,null,null,null,null,null,null,null,5.4399312999999996]
[2,"EXCAVATION-UNCLASSIFIED",4570.2855,2.7372199999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3452.4659999999999,0,null,null,null,null,144.73847000000001]
[3,"SPECIAL BORROW",1176.9074000000001,7.2899400000000003E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146.71709999999999,-150.38159999999999,null,-619.30560000000003]
[4,"EXCAVATION-STREET",365.42327999999998,0.1101502]
[5,"CRUSHED AGGREGATE COURSE",70.920270000000002,0.11614910000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35.898125]
[6,"BASE-CEMENT TREATED"]
[7,"DRAINAGE PIPE (<= 24 IN)",58.598998999999999,1.19933E-2,3.5277999999999999E-6,19.958264,67.070327000000006,29.877801000000002,49.863309000000001,25.765767,-3.0734720000000002,-54.716569999999997,29.573675999999999,29,31.675951999999999,-19.588249999999999,200.03344999999999,2.6000595999999998,null,null,86.461200000000005,-1.4657979999999999,29,null,29,29,4.1061991999999998,null,0,null,null,null,null,null,null,null,null,null,null,null,null,-0.90187899999999999]
[8,"DRAINAGE PIPE (> 24 IN)",74.673580000000001,2.2025599999999999E-2,-1.7719999999999999E-6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.6378779999999997]
[9,"RCB",83.038774000000004,0.20188519999999999,-6.0179999999999998E-6]
[10,"SSPP"]
[11,"RIPRAP",61.070338999999997,0.1005572,-5.215E-6,12.952370999999999,-37,-13.26084,16.228726999999999,28.796123000000001,18.553635,-37,-37,-37,58.017698000000003,-34.757680000000001,-542.93880000000001,95.373512000000005,null,null,null,-46.48612,-37,null,-37,-37,-37,0]
[12,"COLD MILLING",9287.3363000000008,9.0242500000000003E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4120.6689999999999,null,72.025936000000002]
[13,"PLANT MIX SURFACING",-324.73899999999998,2.9217300000000002E-2,null,253.64999,-696.76459999999997,390.38213999999999,-454.096,514.77260999999999,921.72798999999998,49.771987000000003,-1.2956780000000001,-273,-116.7811,-1004.901,-482.25259999999997,-548.40309999999999,-369.38749999999999,null,-118.9509,-859.423,-974.18010000000004,null,-273,-273,-474.9538,-1222.4110000000001,0,969.72213999999997,379.55282,379.04338000000001,181.83038999999999,0,null,null,734.72577999999999,0,null,null,53.024048000000001,-36.746400000000001,null,null,-33.240259999999999]
[14,"COVER",-8221.1839999999993,0.3141467,null,17704.258999999998,3640.0902000000001,3382.8577,12058,42731.303999999996,55085.025999999998,45502.550999999999,33520.798000000003,13140.837,6183.6624000000002,-8811.0859999999993,4453.4327000000003,-1183.8630000000001,-3060.3310000000001,null,-1501.63,-20986.51,15185.393,null,12058,12058,12058,null,0,36992.345999999998,14092.174000000001,10264.444,-4385.95,0,null,null,null,null,null,null,null,null,-257.72559999999999,null,null,153.37341000000001]
[15,"MICROSURFACING",252.35387,9.5721500000000001E-2]
[16,"CRACK SEALING",12712.243,6.5141400000000002E-2,null,-7717,-7717,null,-7717,-10443.34,-10482.09,-7717,-9942.7219999999998,0,-7717,-7717,-7717,-7717,null,null,null,-7717,-7717,null,-7717,-7717,-7717,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26.995593]
[17,"PCCP",366.74126999999999,7.2150400000000003E-2]
[18,"CURB AND GUTTER",452.60174000000001,2.59045E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-49.42456,181.70706000000001,90.798491999999996,38.965224999999997,0,-286.64760000000001,0]
[19,"SIDEWALK",-66.341350000000006,0.1138446,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160.77271999999999,0,null,null,null,null,-7.0870870000000004,null,3.0386093999999999]
[20,"FARM FENCE",1682.3873000000001,5.2054799999999998E-2,null,-915.26940000000002,-1012,-1653.297,-2564.2420000000002,-733.98720000000003,696.97542999999996,-1012,-1012,-1012,-1934.963,-2190.0189999999998,-1329.854,-2122.625,null,null,null,-1012,-1012,null,-1012,-1012,1613.6474000000001,0,null,-193.1352,649.82343000000003,1039.5424,2173.877,0]
[21,"GUARDRAIL STEEL",410.47635000000002,6.2158600000000001E-2,null,-66.558390000000003,113,1136.962,-81.762929999999997,-98.554569999999998,95.763932999999994,781.61221,-84.035510000000002,113,-205.5497,-192.09460000000001,487.38936999999999,348.80592999999999,null,null,-351.39229999999998,113,-194.52959999999999,null,113,113,113,null,0]
[22,"CONCRETE BARRIER RAIL",-78.006150000000005,null,null,-1.8819570000000001,81,null,81,103.94783,117.49888,181.46689000000001,81,81,84.220940999999996,81,81,0,null,null,null,81,81,null,81,81,81,null,null,158.5926,147.56348,-124.7064,45,0,null,null,-125.84269999999999,0,null,null,14.263036,null,1.5750040000000001,-40.67492,-10.70621]
[23,"SEEDING",4.2263685999999998,0.23096510000000001]
[24,"REINFORCING STEEL",-3937.0549999999998,null,1.1207000000000001E-3,9890.7630000000008,21321,27384.874,21321,15351.395,8007.6229000000003,21321,21321,21321,26779.091,31950.655999999999,51200.675000000003,0,null,null,null,21321,21321,null,21321,21321,21321,null,null,1867.0617,3290.2446,-4939.6909999999998,-6895.4539999999997,0,-13856.14,0,null,null,null,null,853.83565999999996,-922.4828,null,null,-1030.0219999999999]
[25,"DRILLED SHAFT"]
[26,"CONCRETE-CLASS DECK",76.784394000000006,null,null,-9.9188729999999996,-4,42.80883,-4,-4,-116.33159999999999,-4,-4,-4,38.916434000000002,43.814041000000003,-24.62059,0,null,null,null,-4,-4,null,-4,-4,-4,null,null,null,null,null,null,null,-69.938850000000002,0,null,null,null,null,-2.6980270000000002,null,0.58668779999999998,null,5.9952107999999997,-0.77901900000000002]
[27,"CLASS A BRIDGE DECK REPAIR",-79.668329999999997,4.8403700000000001E-2,null,43,43,null,43,43.170115000000003,44.418410000000002,43,37.730725,43,43,98.867531,36.329844000000001,0,null,null,null,43,43,null,43,43,43,null,null,46.669452999999997,13.225498999999999,10.717689999999999,5.8726092000000003,0,null,null,31.058478999999998,0,null,null,null,0.77614539999999999]
[28,"CONCRETE BARRIER RAIL-BRIDGE",-2473.268,0.37981880000000001,null,2486.9636,1244,null,1244,1244,76.476720999999998,1244,1244,1244,2861.0585000000001,793.50770999999997,0,1244,null,null,null,1244,1244,null,1244,1244,1244,null,null,-453.95139999999998,-358.27069999999998,-1.0579719999999999,2382.8094999999998,0,-557.06420000000003,0,null,null,472.23457000000002,0,null,-106.6217,12.687307000000001,-277.05869999999999,89.818391000000005]
[29,"CONCRETE-CLASS OVERLAY"]
[30,"BRIDGE DECK MILLING",282.05313999999998,6.8964800000000007E-2]
[31,"REVISE BRIDGE CONCRETE BARRIER",-71.587760000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.143798,26.332201999999999,198.92426,851.21037999999999,0,83.872009000000006,0,null,null,null,null,null,null,-1.7918959999999999,null,23.165873999999999,2.5817966999999999]

{"sheet":"Background","index":6,"n_rows":33,"n_cols":33,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,3,1,3],[0,4,1,4],[0,30,0,31]]}
["SN","PRODUCTION RATE ITEMS","QUANTITY","PRJCT_TTL_AMT","NEW_WORK_TYPE","DISTRICT","BUDGET","AREA","WINTER","NBR_PECS","NBR_USED","USED_HRS","NBR_SUPRVSR","OTH_WRKR","WRKD_HRS","SUM_1","SUM_2","SUM_3","SUM_4","SUM_5","SUM","Mean","Q1","Median","Q3","Min ","Max","RAW 1","RAW 2","FINAL","Historical quantities",null,"Examples"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRODUCTIVITY","PRODUCTIVITY","PRODUCTIVITY","Min","Max","Quantity"]
["AA",{"$f":"'Regression Coefficients'!B3","v":"TOPSOIL-SALVAGING AND PLACING"},{"$f":"'Production Rate Estimates'!D5","v":0},{"$f":"Coding!B42","v":3000000},{"$f":"Coding!F24","v":110},{"$f":"Coding!F5","v":2},{"$f":"Coding!F20","v":1},{"$f":"Coding!F12","v":1},{"$f":"Coding!F16","v":1},18.311557788944725,12.190954773869347,35.085427135678394,1.1132075471698113,6.9245283018867925,31.778301886792452,{"$f":"'Regression Coefficients'!C3+'Regression Coefficients'!D3*Background!C3+'Regression Coefficients'!E3*Background!D3","v":-283.12139999999999},{"$f":"HLOOKUP(E3,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B3,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":1166.1206999999999},{"$f":"IF(F3=1,'Regression Coefficients'!AD3,IF(F3=2,'Regression Coefficients'!AE3,IF(F3=3,'Regression Coefficients'!AF3,IF(F3=4,'Regression Coefficients'!AG3,'Regression Coefficients'!AH3))))","v":-425.83179999999999},{"$f":"IF(G3=0,'Regression Coefficients'!AI3,'Regression Coefficients'!AJ3)+IF(H3=0,'Regression Coefficients'!AK3,'Regression Coefficients'!AL3)+IF(I3=0,'Regression Coefficients'!AM3,'Regression Coefficients'!AN3)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO3:AT3,Background!J3:O3)","v":172.8717790948113},{"$f":"P3+Q3+R3+S3+T3","v":630.03927909481126},2313.4211178270148,306.19050000000004,1267.2308333333335,3071.3959176648113,26.5,19255.073519273985,{"$f":"IF(U3<Z3,Z3,U3)","v":630.03927909481126},{"$f":"IF(AB3>AA3,AA3,AB3)","v":630.03927909481126},{"$f":"IF(C3<=0,\"\",AC3)","v":""},8,115530,65290.279014935826]
["AB",{"$f":"'Regression Coefficients'!B4","v":"EXCAVATION-UNCLASSIFIED"},{"$f":"'Production Rate Estimates'!D6","v":0},{"$f":"$D$3","v":3000000},{"$f":"$E$3","v":110},{"$f":"$F$3","v":2},{"$f":"$G$3","v":1},{"$f":"$H$3","v":1},{"$f":"$I$3","v":1},19.451807228915662,13.674698795180722,36.69879518072289,1.0795454545454546,7.8409090909090908,37.113636363636367,{"$f":"'Regression Coefficients'!C4+'Regression Coefficients'!D4*Background!C4+'Regression Coefficients'!E4*Background!D4","v":4570.2855},{"$f":"HLOOKUP(E4,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B4,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F4=1,'Regression Coefficients'!AD4,IF(F4=2,'Regression Coefficients'!AE4,IF(F4=3,'Regression Coefficients'!AF4,IF(F4=4,'Regression Coefficients'!AG4,'Regression Coefficients'!AH4))))","v":0},{"$f":"IF(G4=0,'Regression Coefficients'!AI4,'Regression Coefficients'!AJ4)+IF(H4=0,'Regression Coefficients'!AK4,'Regression Coefficients'!AL4)+IF(I4=0,'Regression Coefficients'!AM4,'Regression Coefficients'!AN4)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO4:AT4,Background!J4:O4)","v":2815.4248170481928},{"$f":"P4+Q4+R4+S4+T4","v":7385.7103170481932},8874.3465926090685,940.69666666666672,4950,12541.838941715952,17.14,43698,{"$f":"IF(U4<Z4,Z4,U4)","v":7385.7103170481932},{"$f":"IF(AB4>AA4,AA4,AB4)","v":7385.7103170481932},{"$f":"IF(C4<=0,\"\",AC4)","v":""},17,1193215,101898.46966040775]
["AC",{"$f":"'Regression Coefficients'!B5","v":"SPECIAL BORROW"},{"$f":"'Production Rate Estimates'!D7","v":0},{"$f":"$D$3","v":3000000},{"$f":"$E$3","v":110},{"$f":"$F$3","v":2},{"$f":"$G$3","v":1},{"$f":"$H$3","v":1},{"$f":"$I$3","v":1},24.35483870967742,16.846774193548388,43.822580645161288,1.2971014492753623,10.659420289855072,46.369565217391305,{"$f":"'Regression Coefficients'!C5+'Regression Coefficients'!D5*Background!C5+'Regression Coefficients'!E5*Background!D5","v":1176.9074000000001},{"$f":"HLOOKUP(E5,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B5,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F5=1,'Regression Coefficients'!AD5,IF(F5=2,'Regression Coefficients'!AE5,IF(F5=3,'Regression Coefficients'!AF5,IF(F5=4,'Regression Coefficients'!AG5,'Regression Coefficients'!AH5))))","v":0},{"$f":"IF(G5=0,'Regression Coefficients'!AI5,'Regression Coefficients'!AJ5)+IF(H5=0,'Regression Coefficients'!AK5,'Regression Coefficients'!AL5)+IF(I5=0,'Regression Coefficients'!AM5,'Regression Coefficients'!AN5)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO5:AT5,Background!J5:O5)","v":236.52425708274882},1413.4316570827489,3640.2539261089901,644.79889537940312,1807.8022083206727,3709.7912499999998,9.24,36198.129233696825,{"$f":"IF(U5<Z5,Z5,U5)","v":1413.4316570827489},1413.4316570827489,"",28,325783,34495.013306882844]
["AD",{"$f":"'Regression Coefficients'!B6","v":"EXCAVATION-STREET"},{"$f":"'Production Rate Estimates'!D8","v":0},3000000,110,2,1,1,1,16.920000000000002,11.8,35.92,1.52,8.32,33.4,{"$f":"'Regression Coefficients'!C6+'Regression Coefficients'!D6*Background!C6+'Regression Coefficients'!E6*Background!D6","v":365.42327999999998},{"$f":"HLOOKUP(E6,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B6,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F6=1,'Regression Coefficients'!AD6,IF(F6=2,'Regression Coefficients'!AE6,IF(F6=3,'Regression Coefficients'!AF6,IF(F6=4,'Regression Coefficients'!AG6,'Regression Coefficients'!AH6))))","v":0},{"$f":"IF(G6=0,'Regression Coefficients'!AI6,'Regression Coefficients'!AJ6)+IF(H6=0,'Regression Coefficients'!AK6,'Regression Coefficients'!AL6)+IF(I6=0,'Regression Coefficients'!AM6,'Regression Coefficients'!AN6)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO6:AT6,Background!J6:O6)","v":0},365.42327999999998,1518.1244878192754,518.40249999999992,977.84719999999993,2426.3667857142855,52.25,5734.5917748282154,{"$f":"IF(U6<Z6,Z6,U6)","v":365.42327999999998},365.42327999999998,"",75,27191,22846.431250281246]
["AE",{"$f":"'Regression Coefficients'!B7","v":"CRUSHED AGGREGATE COURSE"},{"$f":"'Production Rate Estimates'!D9","v":0},3000000,110,2,1,1,1,17.036630036630036,12.208791208791208,34.575091575091577,0.95253164556962022,6.9050632911392409,33.357594936708864,{"$f":"'Regression Coefficients'!C7+'Regression Coefficients'!D7*Background!C7+'Regression Coefficients'!E7*Background!D7","v":70.920270000000002},{"$f":"HLOOKUP(E7,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B7,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F7=1,'Regression Coefficients'!AD7,IF(F7=2,'Regression Coefficients'!AE7,IF(F7=3,'Regression Coefficients'!AF7,IF(F7=4,'Regression Coefficients'!AG7,'Regression Coefficients'!AH7))))","v":0},{"$f":"IF(G7=0,'Regression Coefficients'!AI7,'Regression Coefficients'!AJ7)+IF(H7=0,'Regression Coefficients'!AK7,'Regression Coefficients'!AL7)+IF(I7=0,'Regression Coefficients'!AM7,'Regression Coefficients'!AN7)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO7:AT7,Background!J7:O7)","v":611.58307463369965},682.50334463369961,2087.9926693411835,132.09375,636.17631791654685,2653.5211683168145,1.85,20606.504777009781,{"$f":"IF(U7<Z7,Z7,U7)","v":682.50334463369961},682.50334463369961,"",1,151590,28186.335846225153]
["AF",{"$f":"'Regression Coefficients'!B8","v":"BASE-CEMENT TREATED"},{"$f":"'Production Rate Estimates'!D10","v":0},3000000,110,2,1,1,1,27.384615384615383,17.46153846153846,20.615384615384617,1.6,12.733333333333333,27.666666666666668,null,null,null,null,null,null,3453.3634909105554,1549.766594998425,3565.8003759058615,5045.1139999999996,577.48,8009.7633333333333,null,{"$f":"V8","v":3453.3634909105554},"",2887,58891,2887]
["AG",{"$f":"'Regression Coefficients'!B9","v":"DRAINAGE PIPE (<= 24 IN)"},{"$f":"'Production Rate Estimates'!D11","v":0},3000000,110,2,1,1,1,18.834170854271356,13.361809045226131,40.959798994974875,1.300469483568075,8.8920187793427239,43.483568075117368,{"$f":"'Regression Coefficients'!C9+'Regression Coefficients'!D9*Background!C9+'Regression Coefficients'!E9*Background!D9","v":69.182399000000004},{"$f":"HLOOKUP(E9,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B9,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":19.958264},{"$f":"IF(F9=1,'Regression Coefficients'!AD9,IF(F9=2,'Regression Coefficients'!AE9,IF(F9=3,'Regression Coefficients'!AF9,IF(F9=4,'Regression Coefficients'!AG9,'Regression Coefficients'!AH9))))","v":0},{"$f":"IF(G9=0,'Regression Coefficients'!AI9,'Regression Coefficients'!AJ9)+IF(H9=0,'Regression Coefficients'!AK9,'Regression Coefficients'!AL9)+IF(I9=0,'Regression Coefficients'!AM9,'Regression Coefficients'!AN9)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO9:AT9,Background!J9:O9)","v":-12.050734979899499},77.089928020100501,95.233632207673409,59.042307692307688,86.77421419883494,112.22858506323075,1.5,527.31299212598435,{"$f":"IF(U9<Z9,Z9,U9)","v":77.089928020100501},{"$f":"IF(AB9>AA9,AA9,AB9)","v":77.089928020100501},{"$f":"IF(C9<=0,\"\",AC9)","v":""},3,9692,2458]
["AH",{"$f":"'Regression Coefficients'!B10","v":"DRAINAGE PIPE (> 24 IN)"},{"$f":"'Production Rate Estimates'!D12","v":0},3000000,110,2,1,1,1,22.155172413793103,15.629310344827585,50.318965517241381,1.4628099173553719,11,52.231404958677686,{"$f":"'Regression Coefficients'!C10+'Regression Coefficients'!D10*Background!C10+'Regression Coefficients'!E10*Background!D10","v":69.357579999999999},{"$f":"HLOOKUP(E10,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B10,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F10=1,'Regression Coefficients'!AD10,IF(F10=2,'Regression Coefficients'!AE10,IF(F10=3,'Regression Coefficients'!AF10,IF(F10=4,'Regression Coefficients'!AG10,'Regression Coefficients'!AH10))))","v":0},{"$f":"IF(G10=0,'Regression Coefficients'!AI10,'Regression Coefficients'!AJ10)+IF(H10=0,'Regression Coefficients'!AK10,'Regression Coefficients'!AL10)+IF(I10=0,'Regression Coefficients'!AM10,'Regression Coefficients'!AN10)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO10:AT10,Background!J10:O10)","v":9.7099537685950406},79.067533768595041,91.077115947174264,54.826279527559066,72.800000000000011,118.5,4.666666666666667,336.90500000000003,{"$f":"IF(U10<Z10,Z10,U10)","v":79.067533768595041},79.067533768595041,{"$f":"IF(C10<=0,\"\",AC10)","v":""},14,4942,1433]
["AI",{"$f":"'Regression Coefficients'!B11","v":"RCB"},{"$f":"'Production Rate Estimates'!D13","v":0},3000000,110,2,1,1,1,24.379310344827587,15.103448275862069,36.103448275862071,1.6,10.766666666666667,36.4,{"$f":"'Regression Coefficients'!C11+'Regression Coefficients'!D11*Background!C11+'Regression Coefficients'!E11*Background!D11","v":64.984774000000002},{"$f":"HLOOKUP(E11,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B11,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F11=1,'Regression Coefficients'!AD11,IF(F11=2,'Regression Coefficients'!AE11,IF(F11=3,'Regression Coefficients'!AF11,IF(F11=4,'Regression Coefficients'!AG11,'Regression Coefficients'!AH11))))","v":0},{"$f":"IF(G11=0,'Regression Coefficients'!AI11,'Regression Coefficients'!AJ11)+IF(H11=0,'Regression Coefficients'!AK11,'Regression Coefficients'!AL11)+IF(I11=0,'Regression Coefficients'!AM11,'Regression Coefficients'!AN11)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO11:AT11,Background!J11:O11)","v":0},64.984774000000002,95.3230227471566,48.75,66.013451443569551,139.5,18,250,{"$f":"IF(U11<Z11,Z11,U11)","v":64.984774000000002},64.984774000000002,"",36,610,264]
["AJ",{"$f":"'Regression Coefficients'!B12","v":"SSPP"},{"$f":"'Production Rate Estimates'!D14","v":0},3000000,110,2,1,1,1,19.666666666666668,13.666666666666666,20,1.5,8.5,15.25,null,null,null,null,null,null,65.5,21,54,98.5,18,136,null,{"$f":"V12","v":65.5},"",18,272,18]
["AK",{"$f":"'Regression Coefficients'!B13","v":"RIPRAP"},{"$f":"'Production Rate Estimates'!D15","v":0},3000000,110,2,1,1,1,18.056737588652481,12.446808510638299,32.652482269503544,1.0382165605095541,7.3821656050955413,36.375796178343947,{"$f":"'Regression Coefficients'!C13+'Regression Coefficients'!D13*Background!C13+'Regression Coefficients'!E13*Background!D13","v":45.425338999999994},{"$f":"HLOOKUP(E13,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B13,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":12.952370999999999},{"$f":"IF(F13=1,'Regression Coefficients'!AD13,IF(F13=2,'Regression Coefficients'!AE13,IF(F13=3,'Regression Coefficients'!AF13,IF(F13=4,'Regression Coefficients'!AG13,'Regression Coefficients'!AH13))))","v":0},{"$f":"IF(G13=0,'Regression Coefficients'!AI13,'Regression Coefficients'!AJ13)+IF(H13=0,'Regression Coefficients'!AK13,'Regression Coefficients'!AL13)+IF(I13=0,'Regression Coefficients'!AM13,'Regression Coefficients'!AN13)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO13:AT13,Background!J13:O13)","v":0},58.377709999999993,136.25338008434616,23.6,94.21,202.71201330683056,3.8333333333333335,914.25748290076012,{"$f":"IF(U13<Z13,Z13,U13)","v":58.377709999999993},58.377709999999993,{"$f":"IF(C13<=0,\"\",AC13)","v":""},1,7410,2430]
["AL",{"$f":"'Regression Coefficients'!B14","v":"COLD MILLING"},{"$f":"'Production Rate Estimates'!D16","v":0},3000000,110,2,1,1,1,10.995918367346938,9.0530612244897952,28.975510204081633,0.83216783216783219,6.6888111888111892,37.545454545454547,{"$f":"'Regression Coefficients'!C14+'Regression Coefficients'!D14*Background!C14+'Regression Coefficients'!E14*Background!D14","v":9287.3363000000008},{"$f":"HLOOKUP(E14,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B14,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F14=1,'Regression Coefficients'!AD14,IF(F14=2,'Regression Coefficients'!AE14,IF(F14=3,'Regression Coefficients'!AF14,IF(F14=4,'Regression Coefficients'!AG14,'Regression Coefficients'!AH14))))","v":0},{"$f":"IF(G14=0,'Regression Coefficients'!AI14,'Regression Coefficients'!AJ14)+IF(H14=0,'Regression Coefficients'!AK14,'Regression Coefficients'!AL14)+IF(I14=0,'Regression Coefficients'!AM14,'Regression Coefficients'!AN14)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO14:AT14,Background!J14:O14)","v":-724.84168262937055},8562.4946173706303,15077.227912343067,1911.1,8220.1,20472.349999999999,17.999650196831258,116274.5,8562.4946173706303,8562.4946173706303,"",36,656548,51132.162449510084]
["AM",{"$f":"'Regression Coefficients'!B15","v":"PLANT MIX SURFACING"},{"$f":"'Production Rate Estimates'!D17","v":0},3000000,110,2,1,1,1,22.920745920745922,18.498834498834498,50.314685314685313,1.2706131078224101,14.054968287526426,75.042283298097246,{"$f":"'Regression Coefficients'!C15+'Regression Coefficients'!D15*Background!C15+'Regression Coefficients'!E15*Background!D15","v":-324.73899999999998},{"$f":"HLOOKUP(E15,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B15,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":253.64999},{"$f":"IF(F15=1,'Regression Coefficients'!AD15,IF(F15=2,'Regression Coefficients'!AE15,IF(F15=3,'Regression Coefficients'!AF15,IF(F15=4,'Regression Coefficients'!AG15,'Regression Coefficients'!AH15))))","v":379.55282},{"$f":"IF(G15=0,'Regression Coefficients'!AI15,'Regression Coefficients'!AJ15)+IF(H15=0,'Regression Coefficients'!AK15,'Regression Coefficients'!AL15)+IF(I15=0,'Regression Coefficients'!AM15,'Regression Coefficients'!AN15)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO15:AT15,Background!J15:O15)","v":68.394359700330767},376.85816970033079,1508.9349215872192,378.27471590909084,1027.7912608695653,2177.091273109244,2.3633333333333333,14223.029999999999,376.85816970033079,376.85816970033079,"",6,156515,7066]
["AN",{"$f":"'Regression Coefficients'!B16","v":"COVER"},{"$f":"'Production Rate Estimates'!D18","v":0},3000000,110,2,1,1,1,18.244736842105262,14.855263157894736,32.055263157894736,1.0627705627705628,10.666666666666666,51.51731601731602,{"$f":"'Regression Coefficients'!C16+'Regression Coefficients'!D16*Background!C16+'Regression Coefficients'!E16*Background!D16","v":-8221.1839999999993},{"$f":"HLOOKUP(E16,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B16,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":17704.258999999998},{"$f":"IF(F16=1,'Regression Coefficients'!AD16,IF(F16=2,'Regression Coefficients'!AE16,IF(F16=3,'Regression Coefficients'!AF16,IF(F16=4,'Regression Coefficients'!AG16,'Regression Coefficients'!AH16))))","v":14092.174000000001},{"$f":"IF(G16=0,'Regression Coefficients'!AI16,'Regression Coefficients'!AJ16)+IF(H16=0,'Regression Coefficients'!AK16,'Regression Coefficients'!AL16)+IF(I16=0,'Regression Coefficients'!AM16,'Regression Coefficients'!AN16)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO16:AT16,Background!J16:O16)","v":-360.0754989029374},23215.173501097062,83884.18651805562,15891.575000000001,56360.180911223855,120457.647,155.54999999999998,484405.20000000007,23215.173501097062,23215.173501097062,"",311,961168,83941.039795659832]
["AO",{"$f":"'Regression Coefficients'!B17","v":"MICROSURFACING"},{"$f":"'Production Rate Estimates'!D19","v":0},3000000,110,2,1,1,1,17.76923076923077,12.384615384615385,29.615384615384617,0.5714285714285714,16.214285714285715,61.428571428571431,{"$f":"'Regression Coefficients'!C17+'Regression Coefficients'!D17*Background!C17+'Regression Coefficients'!E17*Background!D17","v":252.35387},{"$f":"HLOOKUP(E17,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B17,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F17=1,'Regression Coefficients'!AD17,IF(F17=2,'Regression Coefficients'!AE17,IF(F17=3,'Regression Coefficients'!AF17,IF(F17=4,'Regression Coefficients'!AG17,'Regression Coefficients'!AH17))))","v":0},{"$f":"IF(G17=0,'Regression Coefficients'!AI17,'Regression Coefficients'!AJ17)+IF(H17=0,'Regression Coefficients'!AK17,'Regression Coefficients'!AL17)+IF(I17=0,'Regression Coefficients'!AM17,'Regression Coefficients'!AN17)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO17:AT17,Background!J17:O17)","v":0},252.35387,464.59539722222218,407.92374999999998,442.77525000000003,525.46566666666661,256.59000000000003,668.62659999999994,256.59000000000003,256.59000000000003,"",1065,3479,1683]
["AP",{"$f":"'Regression Coefficients'!B18","v":"CRACK SEALING"},{"$f":"'Production Rate Estimates'!D20","v":0},3000000,110,2,1,1,1,9.6666666666666661,7.7647058823529411,30.470588235294116,0.72413793103448276,6.068965517241379,41.155172413793103,{"$f":"'Regression Coefficients'!C18+'Regression Coefficients'!D18*Background!C18+'Regression Coefficients'!E18*Background!D18","v":12712.243},{"$f":"HLOOKUP(E18,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B18,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":-7717},{"$f":"IF(F18=1,'Regression Coefficients'!AD18,IF(F18=2,'Regression Coefficients'!AE18,IF(F18=3,'Regression Coefficients'!AF18,IF(F18=4,'Regression Coefficients'!AG18,'Regression Coefficients'!AH18))))","v":0},{"$f":"IF(G18=0,'Regression Coefficients'!AI18,'Regression Coefficients'!AJ18)+IF(H18=0,'Regression Coefficients'!AK18,'Regression Coefficients'!AL18)+IF(I18=0,'Regression Coefficients'!AM18,'Regression Coefficients'!AN18)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO18:AT18,Background!J18:O18)","v":1111.0082843275861},6106.2512843275863,6345.9750287639717,3003.75,5129.7888888888883,8003.3374999999996,595.83333333333337,30125,6106.2512843275863,6106.2512843275863,"",1051,81135,13700]
["AQ",{"$f":"'Regression Coefficients'!B19","v":"PCCP"},{"$f":"'Production Rate Estimates'!D21","v":0},3000000,110,2,1,1,1,15.555555555555555,11,17.555555555555557,1.2727272727272727,7.0909090909090908,34,{"$f":"'Regression Coefficients'!C19+'Regression Coefficients'!D19*Background!C19+'Regression Coefficients'!E19*Background!D19","v":366.74126999999999},{"$f":"HLOOKUP(E19,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B19,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F19=1,'Regression Coefficients'!AD19,IF(F19=2,'Regression Coefficients'!AE19,IF(F19=3,'Regression Coefficients'!AF19,IF(F19=4,'Regression Coefficients'!AG19,'Regression Coefficients'!AH19))))","v":0},{"$f":"IF(G19=0,'Regression Coefficients'!AI19,'Regression Coefficients'!AJ19)+IF(H19=0,'Regression Coefficients'!AK19,'Regression Coefficients'!AL19)+IF(I19=0,'Regression Coefficients'!AM19,'Regression Coefficients'!AN19)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO19:AT19,Background!J19:O19)","v":0},366.74126999999999,568.3882638888889,236.67250000000004,447.5,1104.5,72,1171.78,366.74126999999999,366.74126999999999,"",101,13572,1555]
["AR",{"$f":"'Regression Coefficients'!B20","v":"CURB AND GUTTER"},{"$f":"'Production Rate Estimates'!D22","v":0},3000000,110,2,1,1,1,11.540816326530612,8.091836734693878,20.540816326530614,0.85470085470085466,6.5213675213675213,25.760683760683762,{"$f":"'Regression Coefficients'!C20+'Regression Coefficients'!D20*Background!C20+'Regression Coefficients'!E20*Background!D20","v":452.60174000000001},{"$f":"HLOOKUP(E20,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B20,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F20=1,'Regression Coefficients'!AD20,IF(F20=2,'Regression Coefficients'!AE20,IF(F20=3,'Regression Coefficients'!AF20,IF(F20=4,'Regression Coefficients'!AG20,'Regression Coefficients'!AH20))))","v":181.70706000000001},{"$f":"IF(G20=0,'Regression Coefficients'!AI20,'Regression Coefficients'!AJ20)+IF(H20=0,'Regression Coefficients'!AK20,'Regression Coefficients'!AL20)+IF(I20=0,'Regression Coefficients'!AM20,'Regression Coefficients'!AN20)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO20:AT20,Background!J20:O20)","v":0},634.30880000000002,408.38925931320733,136.55745341614906,261,562.01102866949327,13.200000000000001,1614.1857142857136,634.30880000000002,634.30880000000002,"",13,1614,433]
["AS",{"$f":"'Regression Coefficients'!B21","v":"SIDEWALK"},{"$f":"'Production Rate Estimates'!D23","v":0},{"$f":"$D$3","v":3000000},110,2,1,1,1,10.489795918367347,7.4591836734693882,18.897959183673468,0.85833333333333328,6.2666666666666666,23.95,{"$f":"'Regression Coefficients'!C21+'Regression Coefficients'!D21*Background!C21+'Regression Coefficients'!E21*Background!D21","v":-66.341350000000006},{"$f":"HLOOKUP(E21,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B21,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F21=1,'Regression Coefficients'!AD21,IF(F21=2,'Regression Coefficients'!AE21,IF(F21=3,'Regression Coefficients'!AF21,IF(F21=4,'Regression Coefficients'!AG21,'Regression Coefficients'!AH21))))","v":0},{"$f":"IF(G21=0,'Regression Coefficients'!AI21,'Regression Coefficients'!AJ21)+IF(H21=0,'Regression Coefficients'!AK21,'Regression Coefficients'!AL21)+IF(I21=0,'Regression Coefficients'!AM21,'Regression Coefficients'!AN21)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO21:AT21,Background!J21:O21)","v":-16.91857986938777},-83.259929869387776,246.48669338338465,60.775000000000006,130.81015645230428,282.52237499999995,4.1500000000000004,2168.1,4.1500000000000004,4.1500000000000004,"",7,8489,4440.1250067932242]
["AT",{"$f":"'Regression Coefficients'!B22","v":"FARM FENCE"},{"$f":"'Production Rate Estimates'!D24","v":0},3000000,110,2,1,1,1,7.115702479338843,5.0991735537190079,13.71900826446281,0.50617283950617287,2.3580246913580245,10.518518518518519,{"$f":"'Regression Coefficients'!C22+'Regression Coefficients'!D22*Background!C22+'Regression Coefficients'!E22*Background!D22","v":1682.3873000000001},{"$f":"HLOOKUP(E22,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B22,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":-915.26940000000002},{"$f":"IF(F22=1,'Regression Coefficients'!AD22,IF(F22=2,'Regression Coefficients'!AE22,IF(F22=3,'Regression Coefficients'!AF22,IF(F22=4,'Regression Coefficients'!AG22,'Regression Coefficients'!AH22))))","v":649.82343000000003},{"$f":"IF(G22=0,'Regression Coefficients'!AI22,'Regression Coefficients'!AJ22)+IF(H22=0,'Regression Coefficients'!AK22,'Regression Coefficients'!AL22)+IF(I22=0,'Regression Coefficients'!AM22,'Regression Coefficients'!AN22)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO22:AT22,Background!J22:O22)","v":0},1416.9413300000001,2205.8714011100733,540.31069553805776,1423.1,2422.3738248628015,10,17924.333333333332,1416.9413300000001,1416.9413300000001,"",20,105577,5052]
["AU",{"$f":"'Regression Coefficients'!B23","v":"GUARDRAIL STEEL"},{"$f":"'Production Rate Estimates'!D25","v":0},3000000,110,2,1,1,1,8.0980392156862742,6.5294117647058822,20.818627450980394,0.7385892116182573,5.3775933609958511,24.933609958506224,{"$f":"'Regression Coefficients'!C23+'Regression Coefficients'!D23*Background!C23+'Regression Coefficients'!E23*Background!D23","v":410.47635000000002},{"$f":"HLOOKUP(E23,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B23,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":-66.558390000000003},{"$f":"IF(F23=1,'Regression Coefficients'!AD23,IF(F23=2,'Regression Coefficients'!AE23,IF(F23=3,'Regression Coefficients'!AF23,IF(F23=4,'Regression Coefficients'!AG23,'Regression Coefficients'!AH23))))","v":0},{"$f":"IF(G23=0,'Regression Coefficients'!AI23,'Regression Coefficients'!AJ23)+IF(H23=0,'Regression Coefficients'!AK23,'Regression Coefficients'!AL23)+IF(I23=0,'Regression Coefficients'!AM23,'Regression Coefficients'!AN23)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO23:AT23,Background!J23:O23)","v":0},343.91795999999999,679.50604070554175,150,424.43733595800541,901.68750000000011,4.166666666666667,5150,343.91795999999999,343.91795999999999,"",13,39000,1518.7007874015749]
["AV",{"$f":"'Regression Coefficients'!B24","v":"CONCRETE BARRIER RAIL"},{"$f":"'Production Rate Estimates'!D26","v":0},3000000,110,2,1,1,1,10.260869565217391,7.3478260869565215,30.608695652173914,0.63888888888888884,5.1944444444444446,26.555555555555557,{"$f":"'Regression Coefficients'!C24+'Regression Coefficients'!D24*Background!C24+'Regression Coefficients'!E24*Background!D24","v":-78.006150000000005},{"$f":"HLOOKUP(E24,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B24,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":-1.8819570000000001},{"$f":"IF(F24=1,'Regression Coefficients'!AD24,IF(F24=2,'Regression Coefficients'!AE24,IF(F24=3,'Regression Coefficients'!AF24,IF(F24=4,'Regression Coefficients'!AG24,'Regression Coefficients'!AH24))))","v":147.56348},{"$f":"IF(G24=0,'Regression Coefficients'!AI24,'Regression Coefficients'!AJ24)+IF(H24=0,'Regression Coefficients'!AK24,'Regression Coefficients'!AL24)+IF(I24=0,'Regression Coefficients'!AM24,'Regression Coefficients'!AN24)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO24:AT24,Background!J24:O24)","v":112.96040258695652},180.63577558695653,57.534668803418803,12.25,25,84.074999999999989,3,250,180.63577558695653,180.63577558695653,"",3,2352,2352]
["AW",{"$f":"'Regression Coefficients'!B25","v":"SEEDING"},{"$f":"'Production Rate Estimates'!D27","v":0},3000000,110,2,1,1,1,6.5255474452554747,4.6350364963503647,14.81021897810219,0.34222222222222221,1.3422222222222222,6.68,{"$f":"'Regression Coefficients'!C25+'Regression Coefficients'!D25*Background!C25+'Regression Coefficients'!E25*Background!D25","v":4.2263685999999998},{"$f":"HLOOKUP(E25,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B25,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F25=1,'Regression Coefficients'!AD25,IF(F25=2,'Regression Coefficients'!AE25,IF(F25=3,'Regression Coefficients'!AF25,IF(F25=4,'Regression Coefficients'!AG25,'Regression Coefficients'!AH25))))","v":0},{"$f":"IF(G25=0,'Regression Coefficients'!AI25,'Regression Coefficients'!AJ25)+IF(H25=0,'Regression Coefficients'!AK25,'Regression Coefficients'!AL25)+IF(I25=0,'Regression Coefficients'!AM25,'Regression Coefficients'!AN25)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO25:AT25,Background!J25:O25)","v":0},4.2263685999999998,12.236424835301277,2.5125000000000002,7.2,18.065462596762014,0.55000000000000004,55.4375,4.2263685999999998,4.2263685999999998,"",1,236,18.342632466307684]
["AX",{"$f":"'Regression Coefficients'!B26","v":"REINFORCING STEEL"},{"$f":"'Production Rate Estimates'!D28","v":0},3000000,110,2,1,1,1,8.3943661971830981,4.816901408450704,16.591549295774648,0.96,4.24,18.413333333333334,{"$f":"'Regression Coefficients'!C26+'Regression Coefficients'!D26*Background!C26+'Regression Coefficients'!E26*Background!D26","v":-574.95499999999947},{"$f":"HLOOKUP(E26,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B26,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":9890.7630000000008},{"$f":"IF(F26=1,'Regression Coefficients'!AD26,IF(F26=2,'Regression Coefficients'!AE26,IF(F26=3,'Regression Coefficients'!AF26,IF(F26=4,'Regression Coefficients'!AG26,'Regression Coefficients'!AH26))))","v":3290.2446},{"$f":"IF(G26=0,'Regression Coefficients'!AI26,'Regression Coefficients'!AJ26)+IF(H26=0,'Regression Coefficients'!AK26,'Regression Coefficients'!AL26)+IF(I26=0,'Regression Coefficients'!AM26,'Regression Coefficients'!AN26)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO26:AT26,Background!J26:O26)","v":-1643.3927763380289},10962.659823661972,13995.350781214542,5194.7416440896768,10516.5,18271.316666666666,248.85714285714286,61785.625,10962.659823661972,10962.659823661972,"",849,2731615,54904]
["AY",{"$f":"'Regression Coefficients'!B27","v":"DRILLED SHAFT"},{"$f":"'Production Rate Estimates'!D29","v":0},3000000,110,2,1,1,1,12,5,5,1.3333333333333333,5.666666666666667,10.333333333333334,null,null,null,null,null,null,102.56161616161616,59.009090909090901,87.818181818181813,138.74242424242425,30.2,189.66666666666666,null,{"$f":"V27","v":102.56161616161616},"",60,966,569]
["AZ",{"$f":"'Regression Coefficients'!B28","v":"CONCRETE-CLASS DECK"},{"$f":"'Production Rate Estimates'!D30","v":0},3000000,110,2,1,1,1,8.0545454545454547,4.9454545454545453,22.109090909090909,1.0833333333333333,5.1833333333333336,22.683333333333334,{"$f":"'Regression Coefficients'!C28+'Regression Coefficients'!D28*Background!C28+'Regression Coefficients'!E28*Background!D28","v":76.784394000000006},{"$f":"HLOOKUP(E28,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B28,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":-9.9188729999999996},{"$f":"IF(F28=1,'Regression Coefficients'!AD28,IF(F28=2,'Regression Coefficients'!AE28,IF(F28=3,'Regression Coefficients'!AF28,IF(F28=4,'Regression Coefficients'!AG28,'Regression Coefficients'!AH28))))","v":0},{"$f":"IF(G28=0,'Regression Coefficients'!AI28,'Regression Coefficients'!AJ28)+IF(H28=0,'Regression Coefficients'!AK28,'Regression Coefficients'!AL28)+IF(I28=0,'Regression Coefficients'!AM28,'Regression Coefficients'!AN28)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO28:AT28,Background!J28:O28)","v":4.6441811263636374},71.509702126363635,72.621441618195078,43.044654881636646,60.550000000000004,84.83278854362635,4.6500000000000004,244.5,{"$f":"IF(U28<Z28,Z28,U28)","v":71.509702126363635},71.509702126363635,{"$f":"IF(C28<=0,\"\",AC28)","v":""},9,2607,489]
["BA",{"$f":"'Regression Coefficients'!B29","v":"CLASS A BRIDGE DECK REPAIR"},{"$f":"'Production Rate Estimates'!D31","v":0},3000000,110,2,1,1,1,10.113636363636363,7.6818181818181817,21.022727272727273,0.8,5.2727272727272725,21.145454545454545,{"$f":"'Regression Coefficients'!C29+'Regression Coefficients'!D29*Background!C29+'Regression Coefficients'!E29*Background!D29","v":-79.668329999999997},{"$f":"HLOOKUP(E29,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B29,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":43},{"$f":"IF(F29=1,'Regression Coefficients'!AD29,IF(F29=2,'Regression Coefficients'!AE29,IF(F29=3,'Regression Coefficients'!AF29,IF(F29=4,'Regression Coefficients'!AG29,'Regression Coefficients'!AH29))))","v":13.225498999999999},{"$f":"IF(G29=0,'Regression Coefficients'!AI29,'Regression Coefficients'!AJ29)+IF(H29=0,'Regression Coefficients'!AK29,'Regression Coefficients'!AL29)+IF(I29=0,'Regression Coefficients'!AM29,'Regression Coefficients'!AN29)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO29:AT29,Background!J29:O29)","v":5.9622078454545449},-17.480623154545455,14.474505135387489,4.875,7.8000000000000007,17.166666666666668,0.6,60.319999999999993,{"$f":"IF(U29<Z29,Z29,U29)","v":0.6},0.6,{"$f":"IF(C29<=0,\"\",AC29)","v":""},1,951,857]
["BB",{"$f":"'Regression Coefficients'!B30","v":"CONCRETE BARRIER RAIL-BRIDGE"},{"$f":"'Production Rate Estimates'!D32","v":0},3000000,110,2,1,1,1,6.68,5,17.96,0.75,5.5,23.214285714285715,{"$f":"'Regression Coefficients'!C30+'Regression Coefficients'!D30*Background!C30+'Regression Coefficients'!E30*Background!D30","v":-2473.268},{"$f":"HLOOKUP(E30,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B30,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":2486.9636},{"$f":"IF(F30=1,'Regression Coefficients'!AD30,IF(F30=2,'Regression Coefficients'!AE30,IF(F30=3,'Regression Coefficients'!AF30,IF(F30=4,'Regression Coefficients'!AG30,'Regression Coefficients'!AH30))))","v":-358.27069999999998},{"$f":"IF(G30=0,'Regression Coefficients'!AI30,'Regression Coefficients'!AJ30)+IF(H30=0,'Regression Coefficients'!AK30,'Regression Coefficients'!AL30)+IF(I30=0,'Regression Coefficients'!AM30,'Regression Coefficients'!AN30)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO30:AT30,Background!J30:O30)","v":-19.037340779999965},-363.61244077999993,222.16751906011748,88.049540682414715,141.05000000000001,252.27500000000001,49.978127734033258,961.2,{"$f":"IF(U30<Z30,Z30,U30)","v":49.978127734033258},49.978127734033258,"",91,5837,91]
["BC",{"$f":"'Regression Coefficients'!B31","v":"CONCRETE-CLASS OVERLAY"},{"$f":"'Production Rate Estimates'!D33","v":0},3000000,110,2,1,1,1,16,12.666666666666666,31,2,11.666666666666666,26.333333333333332,null,null,null,null,null,null,31.442678571428573,22.683035714285715,34.810357142857143,43.57,10.15,46,null,{"$f":"V31","v":31.442678571428573},"",20,376,43]
["BD",{"$f":"'Regression Coefficients'!B32","v":"BRIDGE DECK MILLING"},{"$f":"'Production Rate Estimates'!D34","v":0},3000000,110,2,1,1,1,7.8571428571428568,5.5714285714285712,19.571428571428573,1,5.8571428571428568,11,{"$f":"'Regression Coefficients'!C32+'Regression Coefficients'!D32*Background!C32+'Regression Coefficients'!E32*Background!D32","v":282.05313999999998},{"$f":"HLOOKUP(E32,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B32,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F32=1,'Regression Coefficients'!AD32,IF(F32=2,'Regression Coefficients'!AE32,IF(F32=3,'Regression Coefficients'!AF32,IF(F32=4,'Regression Coefficients'!AG32,'Regression Coefficients'!AH32))))","v":0},{"$f":"IF(G32=0,'Regression Coefficients'!AI32,'Regression Coefficients'!AJ32)+IF(H32=0,'Regression Coefficients'!AK32,'Regression Coefficients'!AL32)+IF(I32=0,'Regression Coefficients'!AM32,'Regression Coefficients'!AN32)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO32:AT32,Background!J32:O32)","v":0},282.05313999999998,472.5310966810967,311.73750000000001,394.125,583.84772727272718,172.1,950.32222222222254,{"$f":"IF(U32<Z32,Z32,U32)","v":282.05313999999998},282.05313999999998,{"$f":"IF(C32<=0,\"\",AC32)","v":""},344,8553,1577]
["BE",{"$f":"'Regression Coefficients'!B33","v":"REVISE BRIDGE CONCRETE BARRIER"},{"$f":"'Production Rate Estimates'!D35","v":0},3000000,110,2,1,1,1,12.071428571428571,5.9761904761904763,15.571428571428571,0.95652173913043481,6.5,16.369565217391305,{"$f":"'Regression Coefficients'!C33+'Regression Coefficients'!D33*Background!C33+'Regression Coefficients'!E33*Background!D33","v":-71.587760000000003},{"$f":"HLOOKUP(E33,'Regression Coefficients'!$F$2:$AC$33,1+MATCH(B33,'Regression Coefficients'!$B$3:$B$33,0),FALSE)","v":0},{"$f":"IF(F33=1,'Regression Coefficients'!AD33,IF(F33=2,'Regression Coefficients'!AE33,IF(F33=3,'Regression Coefficients'!AF33,IF(F33=4,'Regression Coefficients'!AG33,'Regression Coefficients'!AH33))))","v":26.332201999999999},{"$f":"IF(G33=0,'Regression Coefficients'!AI33,'Regression Coefficients'!AJ33)+IF(H33=0,'Regression Coefficients'!AK33,'Regression Coefficients'!AL33)+IF(I33=0,'Regression Coefficients'!AM33,'Regression Coefficients'!AN33)","v":0},{"$f":"SUMPRODUCT('Regression Coefficients'!AO33:AT33,Background!J33:O33)","v":164.93868988726709},119.68313188726708,199.68825518762898,69.125,157.39999999999998,245.25,3,1072.75,{"$f":"IF(U33<Z33,Z33,U33)","v":119.68313188726708},119.68313188726708,{"$f":"IF(C33<=0,\"\",AC33)","v":""},3,8582,800]