{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Major Item Cost","Percentage Items","Results"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Major Item Cost","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,4,1,6]]}
["Minor Item Cost:  ",275330.49731667992]
["Number of Iterations:  ",10000,null,null,"Unit Price"]
["Item","Description","Units","Quantity","Minimum","Most Likely","Maximum"]
["203-02-00100","Drainage Excavation ","CUYD",1463,8,10,25]
["810-01-00200","Concrete Bridge Railing (Slotted) ","LNFT",240,85,105,150]
["502-01-00200","Asphalt Concrete, Drives, Turnouts and Miscellaneous ","TON",171.6,100,155,225]
["814-01-00100","Elastomeric Bearing Pads (Non-Reinforced) ","SFIN",264,50,75,250]
["202-02-04501","Removal of Bridge (Sta. 110+60.67 22' x 73' Concrete Precast Bridge Structure No. 04070670304101)","SQFT",1,20000,40000,90000]
["203-05-00100","Excavation and Embankment ","LUMP",1,20156.5,57885,137725]
["202-02-04501","Removal of Bridge (Sta. 185+07.00 27' x 76' Concrete Precast Bridge Structure No. 04070670305581)","SQFT",1,20000,40000,90000]
["201-01-00100","Clearing and Grubbing ","ACRE",6.5,1400,8800,20000]
["712-04-00100","Flexible Revetment ","SQYD",700,60,80,105]
["302-02-08520","Class II Base Course (8-1/2\" Thick) (Crushed Stone) ","SQYD",2594.8000000000002,20,26,32]
["502-01-00100","Asphalt Concrete ","TON",642.1,115,140,190]
["806-01-00100","Deformed Reinforcing Steel ","LB",82797,0.55000000000000004,1.1000000000000001,2]
["805-01-00300","Class A1 Concrete (Bent Cap) ","CUYD",101.49,800,1350,2200]
["711-01-05000","Riprap (130 lb, 24\" Thick) ","SQYD",1810,86,108,135]
["813-01-00100","Concrete Approach Slabs (Cast-in-Place) ","SQFT",5120,26,40,75]
["805-01-00100","Class A1 Concrete (Slab Span) ","CUYD",351.89,800,1000,1300]
["804-01-00400","Precast Concrete Piles (18\") ","LNFT",4760,55,87,120]

{"sheet":"Percentage Items","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,2,0,4]]}
[null,null,"Percent of Total Construction Cost"]
["Item","Description","Minimum","Most Likely","Maximum"]
["740-01-00100","Construction Layout ",2.3E-3,1.1299999999999999E-2,4.4900000000000002E-2]
["713-01-00100","Temporary Signs and Barricades ",3.8E-3,1.6299999999999999E-2,3.85E-2]
["727-01-00100","Mobilization ",6.5000000000000002E-2,8.6800000000000002E-2,9.9500000000000005E-2]

{"sheet":"Results","index":2,"n_rows":102,"n_cols":20,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[1,"Cost Range"]
["Bin","From","To","Frequency",null,null,"Mean:  ",2537144.6154979402,null,"Minimum:  ",{"$f":"B3","v":1650996.71},null,null,null,null,null,"Cost Ranges"]
[1,1650996.71,1673082.59,0,null,null,"Median:  ",2535758.38,null,"Maximum:  ",{"$f":"C102","v":3859584.67},null,null,null,null,null,{"$f":"TEXT(B3,\"$###,###,##0.00\") & \" - \" & TEXT(C3,\"$###,###,##0.00\")","v":"$1,650,996.71 - $1,673,082.59"}]
[2,1673082.59,1695168.47,0,null,null,"Standard Deviation:  ",115754.82981731664,null,null,null,null,null,null,null,null,{"$f":"TEXT(B4,\"$###,###,##0.00\") & \" - \" & TEXT(C4,\"$###,###,##0.00\")","v":"$1,673,082.59 - $1,695,168.47"}]
[3,1695168.47,1717254.35,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,695,168.47 - $1,717,254.35"]
[4,1717254.35,1739340.23,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,717,254.35 - $1,739,340.23",null,"Percentile","Cost"]
[5,1739340.23,1761426.11,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,739,340.23 - $1,761,426.11",null,0.05,2349568.11]
[6,1761426.11,1783511.99,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,761,426.11 - $1,783,511.99",null,0.1,2388530.9700000002]
[7,1783511.99,1805597.87,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,783,511.99 - $1,805,597.87",null,0.15,2415570.21]
[8,1805597.87,1827683.75,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,805,597.87 - $1,827,683.75",null,0.2,2438644.35]
[9,1827683.75,1849769.63,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,827,683.75 - $1,849,769.63",null,0.25,2458155.71]
[10,1849769.63,1871855.51,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,849,769.63 - $1,871,855.51",null,0.3,2474961.6800000002]
[11,1871855.51,1893941.39,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,871,855.51 - $1,893,941.39",null,0.35,2490542.5299999998]
[12,1893941.39,1916027.27,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,893,941.39 - $1,916,027.27",null,0.4,2505187.98]
[13,1916027.27,1938113.15,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,916,027.27 - $1,938,113.15",null,0.45,2520696.71]
[14,1938113.15,1960199.03,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,938,113.15 - $1,960,199.03",null,0.5,2535758.38]
[15,1960199.03,1982284.91,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,960,199.03 - $1,982,284.91",null,0.55000000000000004,2549663.75]
[16,1982284.91,2004370.79,0,null,null,null,null,null,null,null,null,null,null,null,null,"$1,982,284.91 - $2,004,370.79",null,0.6,2565371.3199999998]
[17,2004370.79,2026456.67,0,null,null,null,null,null,null,null,null,null,null,null,null,"$2,004,370.79 - $2,026,456.67",null,0.65,2581164.0499999998]
[18,2026456.67,2048542.55,0,null,null,null,null,null,null,null,null,null,null,null,null,"$2,026,456.67 - $2,048,542.55",null,0.7,2597793.15]
[19,2048542.55,2070628.43,0,null,null,null,null,null,null,null,null,null,null,null,null,"$2,048,542.55 - $2,070,628.43",null,0.75,2615064.67]
[20,2070628.43,2092714.31,0,null,null,null,null,null,null,null,null,null,null,null,null,"$2,070,628.43 - $2,092,714.31",null,0.8,2634298.73]
[21,2092714.31,2114800.1800000002,0,null,null,null,null,null,null,null,null,null,null,null,null,"$2,092,714.31 - $2,114,800.18",null,0.85,2657675.67]
[22,2114800.1800000002,2136886.06,1,null,null,null,null,null,null,null,null,null,null,null,null,"$2,114,800.18 - $2,136,886.06",null,0.9,2684721.45]
[23,2136886.06,2158971.94,1,null,null,null,null,null,null,null,null,null,null,null,null,"$2,136,886.06 - $2,158,971.94",null,0.95,2730743.83]
[24,2158971.94,2181057.8199999998,0,null,null,null,null,null,null,null,null,null,null,null,null,"$2,158,971.94 - $2,181,057.82",null,1,2983666.09]
[25,2181057.8199999998,2203143.7000000002,9,null,null,null,null,null,null,null,null,null,null,null,null,"$2,181,057.82 - $2,203,143.70"]
[26,2203143.7000000002,2225229.58,13,null,null,null,null,null,null,null,null,null,null,null,null,"$2,203,143.70 - $2,225,229.58"]
[27,2225229.58,2247315.46,15,null,null,null,null,null,null,null,null,null,null,null,null,"$2,225,229.58 - $2,247,315.46"]
[28,2247315.46,2269401.34,28,null,null,null,null,null,null,null,null,null,null,null,null,"$2,247,315.46 - $2,269,401.34"]
[29,2269401.34,2291487.2200000002,58,null,null,null,null,null,null,null,null,null,null,null,null,"$2,269,401.34 - $2,291,487.22"]
[30,2291487.2200000002,2313573.1,103,null,null,null,null,null,null,null,null,null,null,null,null,"$2,291,487.22 - $2,313,573.10"]
[31,2313573.1,2335658.98,153,null,null,null,null,null,null,null,null,null,null,null,null,"$2,313,573.10 - $2,335,658.98"]
[32,2335658.98,2357744.86,205,null,null,null,null,null,null,null,null,null,null,null,null,"$2,335,658.98 - $2,357,744.86"]
[33,2357744.86,2379830.7400000002,279,null,null,null,null,null,null,null,null,null,null,null,null,"$2,357,744.86 - $2,379,830.74"]
[34,2379830.7400000002,2401916.62,346,null,null,null,null,null,null,null,null,null,null,null,null,"$2,379,830.74 - $2,401,916.62"]
[35,2401916.62,2424002.5,475,null,null,null,null,null,null,null,null,null,null,null,null,"$2,401,916.62 - $2,424,002.50"]
[36,2424002.5,2446088.38,525,null,null,null,null,null,null,null,null,null,null,null,null,"$2,424,002.50 - $2,446,088.38"]
[37,2446088.38,2468174.2599999998,593,null,null,null,null,null,null,null,null,null,null,null,null,"$2,446,088.38 - $2,468,174.26"]
[38,2468174.2599999998,2490260.14,686,null,null,null,null,null,null,null,null,null,null,null,null,"$2,468,174.26 - $2,490,260.14"]
[39,2490260.14,2512346.02,740,null,null,null,null,null,null,null,null,null,null,null,null,"$2,490,260.14 - $2,512,346.02"]
[40,2512346.02,2534431.9,734,null,null,null,null,null,null,null,null,null,null,null,null,"$2,512,346.02 - $2,534,431.90"]
[41,2534431.9,2556517.7799999998,764,null,null,null,null,null,null,null,null,null,null,null,null,"$2,534,431.90 - $2,556,517.78"]
[42,2556517.7799999998,2578603.66,678,null,null,null,null,null,null,null,null,null,null,null,null,"$2,556,517.78 - $2,578,603.66"]
[43,2578603.66,2600689.54,685,null,null,null,null,null,null,null,null,null,null,null,null,"$2,578,603.66 - $2,600,689.54"]
[44,2600689.54,2622775.42,635,null,null,null,null,null,null,null,null,null,null,null,null,"$2,600,689.54 - $2,622,775.42"]
[45,2622775.42,2644861.29,514,null,null,null,null,null,null,null,null,null,null,null,null,"$2,622,775.42 - $2,644,861.29"]
[46,2644861.29,2666947.17,445,null,null,null,null,null,null,null,null,null,null,null,null,"$2,644,861.29 - $2,666,947.17"]
[47,2666947.17,2689033.05,365,null,null,null,null,null,null,null,null,null,null,null,null,"$2,666,947.17 - $2,689,033.05"]
[48,2689033.05,2711118.93,277,null,null,null,null,null,null,null,null,null,null,null,null,"$2,689,033.05 - $2,711,118.93"]
[49,2711118.93,2733204.81,191,null,null,null,null,null,null,null,null,null,null,null,null,"$2,711,118.93 - $2,733,204.81"]
[50,2733204.81,2755290.69,140,null,null,null,null,null,null,null,null,null,null,null,null,"$2,733,204.81 - $2,755,290.69"]
[51,2755290.69,2777376.57,120,null,null,null,null,null,null,null,null,null,null,null,null,"$2,755,290.69 - $2,777,376.57"]
[52,2777376.57,2799462.45,75,null,null,null,null,null,null,null,null,null,null,null,null,"$2,777,376.57 - $2,799,462.45"]
[53,2799462.45,2821548.33,62,null,null,null,null,null,null,null,null,null,null,null,null,"$2,799,462.45 - $2,821,548.33"]
[54,2821548.33,2843634.21,35,null,null,null,null,null,null,null,null,null,null,null,null,"$2,821,548.33 - $2,843,634.21"]
[55,2843634.21,2865720.09,25,null,null,null,null,null,null,null,null,null,null,null,null,"$2,843,634.21 - $2,865,720.09"]
[56,2865720.09,2887805.97,11,null,null,null,null,null,null,null,null,null,null,null,null,"$2,865,720.09 - $2,887,805.97"]
[57,2887805.97,2909891.85,7,null,null,null,null,null,null,null,null,null,null,null,null,"$2,887,805.97 - $2,909,891.85"]
[58,2909891.85,2931977.73,4,null,null,null,null,null,null,null,null,null,null,null,null,"$2,909,891.85 - $2,931,977.73"]
[59,2931977.73,2954063.61,1,null,null,null,null,null,null,null,null,null,null,null,null,"$2,931,977.73 - $2,954,063.61"]
[60,2954063.61,2976149.49,1,null,null,null,null,null,null,null,null,null,null,null,null,"$2,954,063.61 - $2,976,149.49"]
[61,2976149.49,2998235.37,1,null,null,null,null,null,null,null,null,null,null,null,null,"$2,976,149.49 - $2,998,235.37"]
[62,2998235.37,3020321.25,0,null,null,null,null,null,null,null,null,null,null,null,null,"$2,998,235.37 - $3,020,321.25"]
[63,3020321.25,3042407.13,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,020,321.25 - $3,042,407.13"]
[64,3042407.13,3064493.01,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,042,407.13 - $3,064,493.01"]
[65,3064493.01,3086578.89,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,064,493.01 - $3,086,578.89"]
[66,3086578.89,3108664.77,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(B68,\"$###,###,##0.00\") & \" - \" & TEXT(C68,\"$###,###,##0.00\")","v":"$3,086,578.89 - $3,108,664.77"}]
[67,3108664.77,3130750.65,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,108,664.77 - $3,130,750.65"]
[68,3130750.65,3152836.53,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,130,750.65 - $3,152,836.53"]
[69,3152836.53,3174922.4,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,152,836.53 - $3,174,922.40"]
[70,3174922.4,3197008.28,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,174,922.40 - $3,197,008.28"]
[71,3197008.28,3219094.16,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,197,008.28 - $3,219,094.16"]
[72,3219094.16,3241180.04,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,219,094.16 - $3,241,180.04"]
[73,3241180.04,3263265.92,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,241,180.04 - $3,263,265.92"]
[74,3263265.92,3285351.8,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,263,265.92 - $3,285,351.80"]
[75,3285351.8,3307437.68,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,285,351.80 - $3,307,437.68"]
[76,3307437.68,3329523.56,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,307,437.68 - $3,329,523.56"]
[77,3329523.56,3351609.44,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,329,523.56 - $3,351,609.44"]
[78,3351609.44,3373695.32,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,351,609.44 - $3,373,695.32"]
[79,3373695.32,3395781.2,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,373,695.32 - $3,395,781.20"]
[80,3395781.2,3417867.08,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,395,781.20 - $3,417,867.08"]
[81,3417867.08,3439952.96,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,417,867.08 - $3,439,952.96"]
[82,3439952.96,3462038.84,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,439,952.96 - $3,462,038.84"]
[83,3462038.84,3484124.72,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,462,038.84 - $3,484,124.72"]
[84,3484124.72,3506210.6,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,484,124.72 - $3,506,210.60"]
[85,3506210.6,3528296.48,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,506,210.60 - $3,528,296.48"]
[86,3528296.48,3550382.36,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,528,296.48 - $3,550,382.36"]
[87,3550382.36,3572468.24,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,550,382.36 - $3,572,468.24"]
[88,3572468.24,3594554.12,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,572,468.24 - $3,594,554.12"]
[89,3594554.12,3616640,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,594,554.12 - $3,616,640.00"]
[90,3616640,3638725.88,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,616,640.00 - $3,638,725.88"]
[91,3638725.88,3660811.76,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,638,725.88 - $3,660,811.76"]
[92,3660811.76,3682897.64,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,660,811.76 - $3,682,897.64"]
[93,3682897.64,3704983.51,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,682,897.64 - $3,704,983.51"]
[94,3704983.51,3727069.39,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,704,983.51 - $3,727,069.39"]
[95,3727069.39,3749155.27,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,727,069.39 - $3,749,155.27"]
[96,3749155.27,3771241.15,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,749,155.27 - $3,771,241.15"]
[97,3771241.15,3793327.03,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,771,241.15 - $3,793,327.03"]
[98,3793327.03,3815412.91,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,793,327.03 - $3,815,412.91"]
[99,3815412.91,3837498.79,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,815,412.91 - $3,837,498.79"]
[100,3837498.79,3859584.67,0,null,null,null,null,null,null,null,null,null,null,null,null,"$3,837,498.79 - $3,859,584.67"]