{"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":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,4,1,6]]}
["Minor Item Cost:  ",1177405.8600000001]
["Number of Iterations:  ",10000,null,null,"Unit Price",null,null,"Probability"]
["Item","Description","Units","Quantity","Minimum","Most Likely","Maximum","of Occuring"]
["736-03-00300","Jacked or Bored Conduit (3\" HPDE, Sch 80) ","LNFT",1795,10,15,21.7,1]
["NS-500-00240","Sawing and Sealing Transverse Joints in Asphaltic Concrete Overlay ","LNFT",19767,1,1.5,2.5,1]
["806-01-00100","Deformed Reinforcing Steel ","LB",47710,0.6,1,1.5,1]
["702-03-00800","Catch Basins (CB-09) ","EACH",10,2500,4300,5200,1]
["NS-P17-00033","Signal Support (Mast Arm Standard w/35 ft Arm and 1 luminaire) ","EACH",3,16000,17338,18852,1]
["804-01-00300","Precast Concrete Piles (16\") ","LNFT",900,43,75,105,1]
["202-02-06100","Removal of Concrete Walks and Drives ","SQYD",3881,0.01,10,20,1]
["202-02-04040","Removal of Bridge Superstructure (Concrete Slab Span) ","SQFT",2440,18.5,25,30,1]
["NS-500-00220","Sawing and Sealing Longitudinal Joints in Asphaltic Concrete Overlay ","LNFT",30823,1.1000000000000001,1.5,2,1]
["736-04-02000","Signal Support (Pedestal Pole) ","EACH",13,1200,1750,2150,1]
["702-03-00600","Catch Basins (CB-07) ","EACH",13,3500,5000,6300,1]
["NS-600-00220","Saw Cutting Portland Cement Concrete Pavement ","INLF",75740,0.15,1,1.5,1]
["707-01-00200","Concrete Curb (Barrier) ","LNFT",6333.9,3.4,7,10,1]
["702-03-00700","Catch Basins (CB-08) ","EACH",11,4500,6850,10000,1]
["NS-736-00006","Video Detection Camera ","EACH",16,1890,2200,2875,1]
["736-08-00071","Sig Cntrlr (TS-2, Type 2, w/Eth cap)(Type 6E Cabinet) (F&I) ","EACH",4,22500,26500,32000,1]
["NS-P17-00048","Signal Support (Mast Arm Standard w/60 ft Arm and 1 luminaire) ","EACH",6,14300,19800,23100,1]
["736-03-00200","Jacked or Bored Conduit (2\" HPDE, Sch 80) ","LNFT",8580,5,7,11,1]
["706-04-00100","Handicapped Curb Ramps ","EACH",101,750,1300,2200,1]
["706-02-00200","Concrete Drive (6\" Thick) ","SQYD",2270.1,37,56,70,1]
["703-01-00100","Shoulder Underdrain Systems ","LNFT",9145.16,9,10,17,1]
["805-04-00100","Class AA(M) Concrete ","CUYD",204,550,700,850,1]
["706-01-00100","Concrete Walk (4\" Thick) ","SQYD",3065.2,25,45,60,1]
["NS-602-00001","Milling Concrete Pavement ","SQYD",8630.5,5,8,11,1]
["NS-MSC-00120","Drainage Structure CB-Adjust, Adjustment/Conversion","EACH",41,1300,3000,3500,1]
["302-02-03121","Class II Base Course (8\" Thick) (Stone or Recycled Portland Cement Concrete, or Blended Calcium Sulfate) ","SQYD",7927.6,15.6,23,28,1]
["602-05-01200","Full Depth Patching of Jointed Concrete Pavement (16.0 square yards and under) (10\" Thick) ","SQYD",2020,125,150,175,1]
["601-01-00500","Portland Cement Concrete Pavement (10\" Thick) ","SQYD",6982.1,56,63,75,1]
["502-01-00100","Superpave Asphaltic Concrete ","TON",7022.5,80,85,112,1]
["Risk 3","Possible Hazard Clean-up Cost","LUMP",1,5000,7000,13000,0.3]

{"sheet":"Percentage Items","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,2,0,4]]}
[null,null,"Percent of Total Construction Cost",null,null,"Probability"]
["Item","Description","Minimum","Most Likely","Maximum","of Occuring"]
["202-02-40100","Removal of Traffic Signal Equipment ",2.0000000000000001E-4,1.8E-3,2.1999999999999999E-2,1]
["740-01-00100","Construction Layout ",2.8E-3,1.2E-2,2.75E-2,1]
["713-01-00100","Temporary Signs and Barricades ",2.5999999999999999E-3,1.6E-2,5.8799999999999998E-2,1]
["727-01-00100","Mobilization ",2.1299999999999999E-2,8.0500000000000002E-2,9.8299999999999998E-2,1]
["Risk 1","Construction Utility Risk",0.05,0.1,0.15,1]
["Risk 2","Unknown Soil Conditions",0.05,7.0000000000000007E-2,0.1,0.3]

{"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:  ",5978625.9400146101,null,"Minimum:  ",{"$f":"B3","v":4224338.5999999996},null,null,null,null,null,"Cost Ranges"]
[1,4224338.5999999996,4267192.5599999996,0,null,null,"Median:  ",5917035.6200000001,null,"Maximum:  ",{"$f":"C102","v":8509734.8699999992},null,null,null,null,null,{"$f":"TEXT(B3,\"$###,###,##0.00\") & \" - \" & TEXT(C3,\"$###,###,##0.00\")","v":"$4,224,338.60 - $4,267,192.56"}]
[2,4267192.5599999996,4310046.5199999996,0,null,null,"Standard Deviation:  ",348916.24502684962,null,null,null,null,null,null,null,null,{"$f":"TEXT(B4,\"$###,###,##0.00\") & \" - \" & TEXT(C4,\"$###,###,##0.00\")","v":"$4,267,192.56 - $4,310,046.52"}]
[3,4310046.5199999996,4352900.49,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,310,046.52 - $4,352,900.49"]
[4,4352900.49,4395754.45,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,352,900.49 - $4,395,754.45",null,"Percentile","Cost"]
[5,4395754.45,4438608.41,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,395,754.45 - $4,438,608.41",null,0.05,5495353]
[6,4438608.41,4481462.37,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,438,608.41 - $4,481,462.37",null,0.1,5577435.54]
[7,4481462.37,4524316.34,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,481,462.37 - $4,524,316.34",null,0.15,5631338.7800000003]
[8,4524316.34,4567170.3,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,524,316.34 - $4,567,170.30",null,0.2,5681039.9199999999]
[9,4567170.3,4610024.26,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,567,170.30 - $4,610,024.26",null,0.25,5723397.7400000002]
[10,4610024.26,4652878.22,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,610,024.26 - $4,652,878.22",null,0.3,5763239.3600000003]
[11,4652878.22,4695732.1900000004,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,652,878.22 - $4,695,732.19",null,0.35,5801456.4900000002]
[12,4695732.1900000004,4738586.1500000004,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,695,732.19 - $4,738,586.15",null,0.4,5839079.71]
[13,4738586.1500000004,4781440.1100000003,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,738,586.15 - $4,781,440.11",null,0.45,5876304.8600000003]
[14,4781440.1100000003,4824294.08,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,781,440.11 - $4,824,294.08",null,0.5,5917035.6200000001]
[15,4824294.08,4867148.04,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,824,294.08 - $4,867,148.04",null,0.55000000000000004,5958625.2000000002]
[16,4867148.04,4910002,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,867,148.04 - $4,910,002.00",null,0.6,6009893.46]
[17,4910002,4952855.96,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,910,002.00 - $4,952,855.96",null,0.65,6064031.3799999999]
[18,4952855.96,4995709.93,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,952,855.96 - $4,995,709.93",null,0.7,6125296.9100000001]
[19,4995709.93,5038563.8899999997,0,null,null,null,null,null,null,null,null,null,null,null,null,"$4,995,709.93 - $5,038,563.89",null,0.75,6199155.0899999999]
[20,5038563.8899999997,5081417.8499999996,1,null,null,null,null,null,null,null,null,null,null,null,null,"$5,038,563.89 - $5,081,417.85",null,0.8,6286008.5800000001]
[21,5081417.8499999996,5124271.8099999996,0,null,null,null,null,null,null,null,null,null,null,null,null,"$5,081,417.85 - $5,124,271.81",null,0.85,6379200.5099999998]
[22,5124271.8099999996,5167125.78,3,null,null,null,null,null,null,null,null,null,null,null,null,"$5,124,271.81 - $5,167,125.78",null,0.9,6484192.1500000004]
[23,5167125.78,5209979.74,6,null,null,null,null,null,null,null,null,null,null,null,null,"$5,167,125.78 - $5,209,979.74",null,0.95,6634297.4400000004]
[24,5209979.74,5252833.7,13,null,null,null,null,null,null,null,null,null,null,null,null,"$5,209,979.74 - $5,252,833.70",null,1,7283128.1100000003]
[25,5252833.7,5295687.67,19,null,null,null,null,null,null,null,null,null,null,null,null,"$5,252,833.70 - $5,295,687.67"]
[26,5295687.67,5338541.63,37,null,null,null,null,null,null,null,null,null,null,null,null,"$5,295,687.67 - $5,338,541.63"]
[27,5338541.63,5381395.5899999999,61,null,null,null,null,null,null,null,null,null,null,null,null,"$5,338,541.63 - $5,381,395.59"]
[28,5381395.5899999999,5424249.5499999998,82,null,null,null,null,null,null,null,null,null,null,null,null,"$5,381,395.59 - $5,424,249.55"]
[29,5424249.5499999998,5467103.5199999996,135,null,null,null,null,null,null,null,null,null,null,null,null,"$5,424,249.55 - $5,467,103.52"]
[30,5467103.5199999996,5509957.4800000004,219,null,null,null,null,null,null,null,null,null,null,null,null,"$5,467,103.52 - $5,509,957.48"]
[31,5509957.4800000004,5552811.4400000004,256,null,null,null,null,null,null,null,null,null,null,null,null,"$5,509,957.48 - $5,552,811.44"]
[32,5552811.4400000004,5595665.4000000004,327,null,null,null,null,null,null,null,null,null,null,null,null,"$5,552,811.44 - $5,595,665.40"]
[33,5595665.4000000004,5638519.3700000001,409,null,null,null,null,null,null,null,null,null,null,null,null,"$5,595,665.40 - $5,638,519.37"]
[34,5638519.3700000001,5681373.3300000001,433,null,null,null,null,null,null,null,null,null,null,null,null,"$5,638,519.37 - $5,681,373.33"]
[35,5681373.3300000001,5724227.29,508,null,null,null,null,null,null,null,null,null,null,null,null,"$5,681,373.33 - $5,724,227.29"]
[36,5724227.29,5767081.25,535,null,null,null,null,null,null,null,null,null,null,null,null,"$5,724,227.29 - $5,767,081.25"]
[37,5767081.25,5809935.2199999997,563,null,null,null,null,null,null,null,null,null,null,null,null,"$5,767,081.25 - $5,809,935.22"]
[38,5809935.2199999997,5852789.1799999997,577,null,null,null,null,null,null,null,null,null,null,null,null,"$5,809,935.22 - $5,852,789.18"]
[39,5852789.1799999997,5895643.1399999997,567,null,null,null,null,null,null,null,null,null,null,null,null,"$5,852,789.18 - $5,895,643.14"]
[40,5895643.1399999997,5938497.1100000003,517,null,null,null,null,null,null,null,null,null,null,null,null,"$5,895,643.14 - $5,938,497.11"]
[41,5938497.1100000003,5981351.0700000003,475,null,null,null,null,null,null,null,null,null,null,null,null,"$5,938,497.11 - $5,981,351.07"]
[42,5981351.0700000003,6024205.0300000003,396,null,null,null,null,null,null,null,null,null,null,null,null,"$5,981,351.07 - $6,024,205.03"]
[43,6024205.0300000003,6067058.9900000002,378,null,null,null,null,null,null,null,null,null,null,null,null,"$6,024,205.03 - $6,067,058.99"]
[44,6067058.9900000002,6109912.96,367,null,null,null,null,null,null,null,null,null,null,null,null,"$6,067,058.99 - $6,109,912.96"]
[45,6109912.96,6152766.9199999999,297,null,null,null,null,null,null,null,null,null,null,null,null,"$6,109,912.96 - $6,152,766.92"]
[46,6152766.9199999999,6195620.8799999999,295,null,null,null,null,null,null,null,null,null,null,null,null,"$6,152,766.92 - $6,195,620.88"]
[47,6195620.8799999999,6238474.8399999999,249,null,null,null,null,null,null,null,null,null,null,null,null,"$6,195,620.88 - $6,238,474.84"]
[48,6238474.8399999999,6281328.8099999996,253,null,null,null,null,null,null,null,null,null,null,null,null,"$6,238,474.84 - $6,281,328.81"]
[49,6281328.8099999996,6324182.7699999996,239,null,null,null,null,null,null,null,null,null,null,null,null,"$6,281,328.81 - $6,324,182.77"]
[50,6324182.7699999996,6367036.7300000004,225,null,null,null,null,null,null,null,null,null,null,null,null,"$6,324,182.77 - $6,367,036.73"]
[51,6367036.7300000004,6409890.6900000004,220,null,null,null,null,null,null,null,null,null,null,null,null,"$6,367,036.73 - $6,409,890.69"]
[52,6409890.6900000004,6452744.6600000001,189,null,null,null,null,null,null,null,null,null,null,null,null,"$6,409,890.69 - $6,452,744.66"]
[53,6452744.6600000001,6495598.6200000001,195,null,null,null,null,null,null,null,null,null,null,null,null,"$6,452,744.66 - $6,495,598.62"]
[54,6495598.6200000001,6538452.5800000001,164,null,null,null,null,null,null,null,null,null,null,null,null,"$6,495,598.62 - $6,538,452.58"]
[55,6538452.5800000001,6581306.5499999998,140,null,null,null,null,null,null,null,null,null,null,null,null,"$6,538,452.58 - $6,581,306.55"]
[56,6581306.5499999998,6624160.5099999998,126,null,null,null,null,null,null,null,null,null,null,null,null,"$6,581,306.55 - $6,624,160.51"]
[57,6624160.5099999998,6667014.4699999997,117,null,null,null,null,null,null,null,null,null,null,null,null,"$6,624,160.51 - $6,667,014.47"]
[58,6667014.4699999997,6709868.4299999997,88,null,null,null,null,null,null,null,null,null,null,null,null,"$6,667,014.47 - $6,709,868.43"]
[59,6709868.4299999997,6752722.4000000004,70,null,null,null,null,null,null,null,null,null,null,null,null,"$6,709,868.43 - $6,752,722.40"]
[60,6752722.4000000004,6795576.3600000003,54,null,null,null,null,null,null,null,null,null,null,null,null,"$6,752,722.40 - $6,795,576.36"]
[61,6795576.3600000003,6838430.3200000003,50,null,null,null,null,null,null,null,null,null,null,null,null,"$6,795,576.36 - $6,838,430.32"]
[62,6838430.3200000003,6881284.2800000003,40,null,null,null,null,null,null,null,null,null,null,null,null,"$6,838,430.32 - $6,881,284.28"]
[63,6881284.2800000003,6924138.25,33,null,null,null,null,null,null,null,null,null,null,null,null,"$6,881,284.28 - $6,924,138.25"]
[64,6924138.25,6966992.21,26,null,null,null,null,null,null,null,null,null,null,null,null,"$6,924,138.25 - $6,966,992.21"]
[65,6966992.21,7009846.1699999999,10,null,null,null,null,null,null,null,null,null,null,null,null,"$6,966,992.21 - $7,009,846.17"]
[66,7009846.1699999999,7052700.1299999999,6,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(B68,\"$###,###,##0.00\") & \" - \" & TEXT(C68,\"$###,###,##0.00\")","v":"$7,009,846.17 - $7,052,700.13"}]
[67,7052700.1299999999,7095554.0999999996,11,null,null,null,null,null,null,null,null,null,null,null,null,"$7,052,700.13 - $7,095,554.10"]
[68,7095554.0999999996,7138408.0599999996,9,null,null,null,null,null,null,null,null,null,null,null,null,"$7,095,554.10 - $7,138,408.06"]
[69,7138408.0599999996,7181262.0199999996,4,null,null,null,null,null,null,null,null,null,null,null,null,"$7,138,408.06 - $7,181,262.02"]
[70,7181262.0199999996,7224115.9900000002,2,null,null,null,null,null,null,null,null,null,null,null,null,"$7,181,262.02 - $7,224,115.99"]
[71,7224115.9900000002,7266969.9500000002,2,null,null,null,null,null,null,null,null,null,null,null,null,"$7,224,115.99 - $7,266,969.95"]
[72,7266969.9500000002,7309823.9100000001,2,null,null,null,null,null,null,null,null,null,null,null,null,"$7,266,969.95 - $7,309,823.91"]
[73,7309823.9100000001,7352677.8700000001,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,309,823.91 - $7,352,677.87"]
[74,7352677.8700000001,7395531.8399999999,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,352,677.87 - $7,395,531.84"]
[75,7395531.8399999999,7438385.7999999998,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,395,531.84 - $7,438,385.80"]
[76,7438385.7999999998,7481239.7599999998,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,438,385.80 - $7,481,239.76"]
[77,7481239.7599999998,7524093.7199999997,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,481,239.76 - $7,524,093.72"]
[78,7524093.7199999997,7566947.6900000004,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,524,093.72 - $7,566,947.69"]
[79,7566947.6900000004,7609801.6500000004,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,566,947.69 - $7,609,801.65"]
[80,7609801.6500000004,7652655.6100000003,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,609,801.65 - $7,652,655.61"]
[81,7652655.6100000003,7695509.5800000001,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,652,655.61 - $7,695,509.58"]
[82,7695509.5800000001,7738363.54,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,695,509.58 - $7,738,363.54"]
[83,7738363.54,7781217.5,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,738,363.54 - $7,781,217.50"]
[84,7781217.5,7824071.46,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,781,217.50 - $7,824,071.46"]
[85,7824071.46,7866925.4299999997,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,824,071.46 - $7,866,925.43"]
[86,7866925.4299999997,7909779.3899999997,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,866,925.43 - $7,909,779.39"]
[87,7909779.3899999997,7952633.3499999996,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,909,779.39 - $7,952,633.35"]
[88,7952633.3499999996,7995487.3099999996,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,952,633.35 - $7,995,487.31"]
[89,7995487.3099999996,8038341.2800000003,0,null,null,null,null,null,null,null,null,null,null,null,null,"$7,995,487.31 - $8,038,341.28"]
[90,8038341.2800000003,8081195.2400000002,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,038,341.28 - $8,081,195.24"]
[91,8081195.2400000002,8124049.2000000002,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,081,195.24 - $8,124,049.20"]
[92,8124049.2000000002,8166903.1600000001,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,124,049.20 - $8,166,903.16"]
[93,8166903.1600000001,8209757.1299999999,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,166,903.16 - $8,209,757.13"]
[94,8209757.1299999999,8252611.0899999999,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,209,757.13 - $8,252,611.09"]
[95,8252611.0899999999,8295465.0499999998,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,252,611.09 - $8,295,465.05"]
[96,8295465.0499999998,8338319.0199999996,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,295,465.05 - $8,338,319.02"]
[97,8338319.0199999996,8381172.9800000004,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,338,319.02 - $8,381,172.98"]
[98,8381172.9800000004,8424026.9399999995,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,381,172.98 - $8,424,026.94"]
[99,8424026.9399999995,8466880.9000000004,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,424,026.94 - $8,466,880.90"]
[100,8466880.9000000004,8509734.8699999992,0,null,null,null,null,null,null,null,null,null,null,null,null,"$8,466,880.90 - $8,509,734.87"]