{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["HOW TO","Rockfall-PTCS","Rockfall-Bridge","Rockfall-Roadway","Flood-Roadway","Flood-Bridge","Flood-Bridge Approach","Flood-Minor Culvert","Flood-Major Culvert","Scour-Bridge","Benefit Cost Ratio"],"not_rendered":{"charts":0,"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":"HOW TO","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,2,6,12]]}
[null,"General Notes"]
[null,"CDOT Standard can be viewed here."]
[null,"For geohazard information needed to fill out steps 4 and 5, reach out to Robert Group (robert.group@state.co.us)."]
[null,"For hydraulic information needed to fill out steps 4 and 5, reach out to Al Gross (alfred.gross@state.co.us) "]
[]
[]
[null,null,"Threat Asset-Specific Notes"]
[null,"General Instructions for all assets:","Rockfall-PTCS","Rockfall-Bridge","Rockfall-Roadway","Flood-Roadway","Flood-Bridge","Flood-Bridge Approach","Flood-Minor Cuvlert","Flood-Major Culvert","Scour-Bridge","General Snow Events","Avalanches"]
[1,"Choose which asset(s) you are evaluating for your project",null,null,null,null,null,null,"Use for CMP, CMPE, RCP, RBC, RCPE","Use for CBC",null,"For general snow events, like a blizzard, please use the rockfall tab for either the roadway or bridge you are assessing. Since the snow event should not damage the asset, we will only be focusing on the user risk of this asset. ","For avalanches, use the Rockfall Roadway or Bridge tab, and modify the annual threat likelihood to the appropriate values."]
[2,"Duplicate the sheet for the asset, add \"Mitigation\" to the end of the original sheet title and \"No Action\" to the end of the duplicative sheet title. If there's more than one proposed mitigation that you want to evaluate for an asset, duplicate the mitigation sheet again and name appropriately.",null,null,null,null,null,null,"You may be upgrading from a Minor culvert to a major culvert, or vice versa. Use the correct sheet accordingly.","You may be upgrading from a Minor culvert to a major culvert, or vice versa. Use the correct sheet accordingly."]
[3,"Delete the sheets for the assets you are not assessing, but keep the Benefit Cost Ratio Sheet"]
[4,"In each \"No Action\" asset tab, enter the pre-mitigation (current) information for all cells colored yellow. ONLY the yellow cells and the detour route information (step 7 below) need to be filled out, and some are drop-down options only. Everything else will automatically populate. Helpful CDOT links for the information can be found in the light blue shaded cells off to the right.","ALL yellow cells need to be filled out, except for cells D29 and E29. There are used for a description of the mitigation, but are not tied to the formula.","ALL yellow cells need to be filled out, except for cells D25 and E25. There are used for a description of the mitigation, but are not tied to the formula.","ALL yellow cells need to be filled out, except for cells D23 and E23. There are used for a description of the mitigation, but are not tied to the formula."]
[5,"In each \"Mitigation\" asset tab, enter the proposed mitigation information for all cells colored yellow. ONLY the yellow cells need to be filled out, and some are drop-down options only. Everything else will automatically populate. Helpful CDOT links for the information can be found in the light blue shaded cells off to the right."]
[6,"Determine if there is information from the standard that should be tailored to your project. If there is, make those changes at this time.",null,null,null,null,null,null,null,null,null,"Modify the full and partial closure days."]
[7,"Enter the route name and MP location of the expected closure into the ClosureLocation tab on the HighwaySegmentList_AllSeasonDetours workbook, set the filter for the PrimaryMatch column of the DetourInfo sheet, choose a detour route, and enter the MP range, added time, and added distance into table 3.13.\n\nYou can also manually map out a detour route on google maps and enter the MP range, added time, and added distance into table 3.13."]
[null,"Perform the benefit cost analysis"]
[8,"On the Benefit Cost Ratio sheet, add up all of the owner and user risks for the No Action and Mitigation (add more rows if you are comparing more than one mitigation measure)"]
[9,"Determine the mitigation annual cost by entering the price it would cost to replace the asset in cell K2 and the price it would cost to install the new mitigation measure in cell K3. CDOT's Cost Planner Tool or an ARC calculation (from table 3.10) can be used to determine the proces. These numbers will be used to automatically generate the delta between the prices in cell K4. Next, enter the lifespan of the mitigation method in cell K5. The B/C ratios for the owner risk, user risk, and total risk will automatically populate."]

{"sheet":"Rockfall-PTCS","index":1,"n_rows":249,"n_cols":17,"rows_kept":249,"cut":false,"hidden":false,"merged":[[4,2,4,4],[97,3,97,4],[210,2,210,5],[98,3,98,4],[222,1,222,5]]}
["Problem:",null,"Rockfall"]
[]
["Step 1:","Threat Data Collection"]
[]
[null,"Event","Annual Threat Likelihood"]
[null,"Small",null,{"$f":"VLOOKUP(B6,B100:D102,3,FALSE)","v":1}]
[null,"Medium",null,{"$f":"VLOOKUP(B7,B99:D101,3,FALSE)","v":0.16666666666666666}]
[null,"Large",null,{"$f":"VLOOKUP(B8,B100:D102,3,FALSE)","v":0.05}]
[]
[]
[]
["Step 2: Asset Data Collection",null,null,null,null,"CODE","Item Description",null,null,"CDOT Link"]
["Site Overview:",null,"PTCS"]
[null,"Roadway:","Type:",2,"(lanes)"]
[null,null,"Width:",38,"(feet)"]
[null,null,"Speed Lim:",50,"(mph)"]
[null,"Total:","AADT Veh:",16000,"(vehicle)","OTIS","Avg. Annual Daily Traffic (all)",null,"CDOT OTIS Data Search Platform"]
[null,null,"AADT Trck:",2000,"(truck)","OTIS","Avg. Annual Daily Traffic (trucks)",null,"CDOT OTIS Data Search Platform"]
[null,null,"Milepost:",10,11,"OTIS","CDOT Mile Post",null,"CDOT OTIS Data Search Platform"]
[null,null,"Car User Cost Assumptions:","C2","C4","C8"]
[null,null,"Trck User:","C3","C5","C9"]
[null,"Work Zone:","Length:",6,"(miles)"]
[null,null,"Speed Red:",10,"(mph)"]
[null,"Rockfall Mitigation:",null,620,"T35 Barrier (LF)","Installed"]
[null,null,"Lithology:","Rock Slope"]
[null,null,"Slope:","Natural"]
[null,null,"Ditch:","Absent"]
[null,null,"Monitored","No"]
[]
["Step 3:","Owner Consequence"]
[]
[]
[null,{"$f":"INDEX(C213:F217,E219,F219)","v":2812500}]
[]
[]
[]
[]
[]
["Step 4:","User Consequence"]
[null,"Full Closure:",null,null,null,null,"Dt:",{"$f":"INDEX(E208:E208,MATCH(C44,D208:D208,0))","v":189},"mins"]
[null,"Avg Veh:",{"$f":"D17","v":16000},"Veh Cost:",{"$f":"VLOOKUP(D20,G224:H230,2)","v":0.59},null,"Veh:",{"$f":"VLOOKUP(E20,G224:H230,2)","v":10.62}]
[null,"Avg Trck:",{"$f":"D18","v":2000},"Trck Cost:",{"$f":"VLOOKUP(D21,G224:H230,2)","v":0.96},null,"Trck:",{"$f":"VLOOKUP(E21,G224:H230,2)","v":25.31}]
[null,"dFC:",{"$f":"SUMPRODUCT((B239:B249=C13)*(C239:C249=C1)*(D239:D249))","v":4},null,null,null,"O:",{"$f":"VLOOKUP(D22,G224:H230,2)","v":1.77}]
[null,"C7:",{"$f":"LOOKUP(2,1/(B208:B208<=D19)/(C208:C208>=D19),D208:D208)","v":146},"VOC.FC:",{"$f":"(E41*C41+E42*C42)*C43*C44","v":6634240},null,"LW.FC:",{"$f":"(H41*H43*C41+H42*C42)*C43*H40/60","v":4427367.84}]
[]
[null,null,null,"Total Full:",{"$f":"E44+H44","v":11061607.84}]
[]
[null,"Partial Closure:"]
[null,"WL:",{"$f":"D22","v":6},"Veh Cost:",{"$f":"VLOOKUP(F20,G224:H230,2)","v":26.52}]
[null,"WZS:",{"$f":"D16","v":50},"Trck Cost:",{"$f":"VLOOKUP(F21,G224:H230,2)","v":44.24}]
[null,"WZSR:",{"$f":"D23","v":10}]
[null,"dPC:",{"$f":"SUMPRODUCT((B239:B249=C13)*(C239:C249=C1)*(E239:E249))","v":14},"VOC.PC:",{"$f":"(1/((1/C49)*(C50-C51))-1/((1/C49)*C50))*(E49*C41+E50*C42)*C52","v":215376},null,"LW.PC:",{"$f":"(1/((1/C49)*(C50-C51))-1/((1/C49)*C50))*(H41*H43*C41+H42*C42)*C52","v":147578.92800000001}]
[]
[null,null,null,"Total Part:",{"$f":"E52+H52","v":362954.92800000001}]
[]
[]
[null,null,null,"Total:",{"$f":"E46+E54","v":11424562.767999999}]
[]
["Step 5:","Vulnerability Assessment"]
[null,"Event Vol:",{"$f":"B100","v":"Small"},{"$f":"INDEX(C100:C102,MATCH(C60,B100:B102,0))","v":"lt100"},"Event Index:",{"$f":"MATCH(D60,C175:C203,0)","v":1}]
[null,null,{"$f":"B101","v":"Medium"},{"$f":"INDEX(C100:C102,MATCH(C61,B100:B102,0))","v":"100to499"},null,{"$f":"MATCH(D61,C175:C203,0)","v":17}]
[null,null,{"$f":"B102","v":"Large"},{"$f":"INDEX(C100:C102,MATCH(C62,B100:B102,0))","v":"gt499"},null,{"$f":"MATCH(D62,C175:C203,0)","v":29}]
[null,"Slope:",null,{"$f":"D26","v":"Natural"},"Slope Index:",{"$f":"MATCH(D63,D175:D202,0)","v":9},{"$f":"F60+F63-1","v":9}]
[null,null,null,null,null,null,{"$f":"F61+F63-1","v":25}]
[null,"Lithology:",null,{"$f":"D25","v":"Rock Slope"},"Lith Index:",{"$f":"MATCH(D65,E175:E182,0)","v":1},{"$f":"G63+F65-1","v":9}]
[null,null,null,null,null,null,{"$f":"IF(D63=\"Cut\",G64+F65-1,G64+MATCH(D65,E199:E202,0)-1)","v":25}]
[null,"Ditch:",null,{"$f":"D27","v":"Absent"},"Ditch Index:",{"$f":"MATCH(D67,F175:F178,0)","v":1},{"$f":"G65+F67-1","v":9}]
[null,null,null,null,null,null,{"$f":"IF(D63=\"Cut\",G66+F67-1,G66)","v":25}]
[null,"Monitored:",null,{"$f":"D28","v":"No"},"Mon Index:",{"$f":"IF(D69=\"Yes\",0,1)","v":1},{"$f":"G67+F69","v":10}]
[null,null,null,null,null,null,{"$f":"G68+F69","v":26}]
[null,"Mitigation:",null,{"$f":"F24","v":"Installed"},"Mit Index:",{"$f":"MATCH(D71,I174:K174,0)","v":3}]
[]
[null,"Event:","1-yr",{"$f":"INDEX(I175:K203,G69,F71)","v":1.5E-3}]
[null,null,"6-yr",{"$f":"INDEX(I175:K203,G70,F71)","v":0.55999999999999994}]
[null,null,"20-yr",{"$f":"INDEX(I175:K203,F62,F71)","v":0.99}]
[]
["Step 6:","Risk Assessment"]
[]
[null,"Annual Owner Risk:",null,{"$f":"B33*D73*D6","v":4218.75}]
[null,null,null,{"$f":"ROUND(B33*D74*D7,0)","v":262500}]
[null,null,null,{"$f":"B33*D75*D8","v":139218.75}]
[]
[null,"Total Owner Risk:",null,{"$f":"SUM(D79:D81)","v":405937.5}]
[]
[null,"Annual User Risk:",null,{"$f":"E57*D73*D6","v":17136.844151999998}]
[null,null,null,{"$f":"ROUND(E57*D74*D7,0)","v":1066293}]
[null,null,null,{"$f":"E57*D75*D8","v":565515.85701599997}]
[]
[null,"Total User Risk:",null,{"$f":"SUM(D85:D87)","v":1648945.701168}]
[]
[null,"Total Annual Risk:",null,{"$f":"D83+D89","v":2054883.201168}]
[]
[]
[]
["Please customize the information from the standard below:"]
[]
["Exhibits:",3.6]
[null,"Event","Volume","Annual Threat"]
[null,"Magnitude","(cu yds)","Likelihood"]
[null,"Small","lt100",1]
[null,"Medium","100to499",{"$f":"1/6","v":0.16666666666666666}]
[null,"Large","gt499",{"$f":"1/20","v":0.05}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1]
[null,3.8]
[null,null,"Road"]
[null,"Asset","Type","Units","Unit Cost"]
[null,"Approach",null,"sq ft",350]
[null,"Bridge",null,"sq ft",600]
[null,"CBC",null,"cu ft",55]
[null,"PTCS",null,"sq ft",550]
[null,"Roadway","Asphalt","sq yds",150]
[null,"Roadway","Concrete","sq yds",350]
[]
[null,"Unit Cost:",{"$f":"INDEX(E162:E167,MATCH(C13,B162:B167,0))","v":550},"($ / units)"]
[]
[null,"4.1.1.12"]
[null,"Magnitude",null,"Factors",null,null,null,null,"Vulnerability"]
[null,"Return",null,"Natural or",null,null,null,null,"Mitigation"]
[null,"Period","Volume","Cut Slope","Lithology","Ditch","Width","Monitored","No","Maintained","Installed"]
[null,"1-yr","lt100","Cut","Rock Slope","Absent",null,"Yes",0,0,{"$f":"I175*0.15","v":0},1]
[null,"1-yr","lt100","Cut","Rock Slope","Absent",null,"No",0.01,0.01,{"$f":"I176*0.15","v":1.5E-3},2]
[null,"1-yr","lt100","Cut","Rock Slope","Present",null,"Yes",0,0,0,3]
[null,"1-yr","lt100","Cut","Rock Slope","Present",null,"No",0.01,0.01,1.5E-3,4]
[null,"1-yr","lt100","Cut","Non-Rock","Absent",null,"Yes",0,0,0,5]
[null,"1-yr","lt100","Cut","Non-Rock","Absent",null,"No",0.01,0,1.5E-3,6]
[null,"1-yr","lt100","Cut","Non-Rock","Present",null,"Yes",0,0,0,7]
[null,"1-yr","lt100","Cut","Non-Rock","Present",null,"No",0.01,0,1.5E-3,8]
[null,"1-yr","lt100","Natural","Rock Slope","Absent",null,"Yes",0.01,0,1.5E-3,9]
[null,"1-yr","lt100","Natural","Rock Slope","Absent",null,"No",0.01,0.01,1.5E-3,10]
[null,"1-yr","lt100","Natural","Rock Slope","Present",null,"Yes",0,0,0,11]
[null,"1-yr","lt100","Natural","Rock Slope","Present",null,"No",0.01,0.01,1.5E-3,12]
[null,"1-yr","lt100","Natural","Non-Rock","Absent",null,"Yes",0,0,0,13]
[null,"1-yr","lt100","Natural","Non-Rock","Absent",null,"No",0.01,0.01,1.5E-3,14]
[null,"1-yr","lt100","Natural","Non-Rock","Present",null,"Yes",0,0,0,15]
[null,"1-yr","lt100","Natural","Non-Rock","Present",null,"No",0.01,0.01,1.5E-3,16]
[null,"6-yr","100to499","Cut","Rock Slope","Absent","lte10","Yes",0.35,0.3,{"$f":"I191*0.7","v":0.24499999999999997},17]
[null,"6-yr","100to499","Cut","Rock Slope","Absent","lte10","No",0.65,0.5,{"$f":"I192*0.7","v":0.45499999999999996},18]
[null,"6-yr","100to499","Cut","Rock Slope","Present","gt10","Yes",0.3,0.25,0.21,19]
[null,"6-yr","100to499","Cut","Rock Slope","Present","gt10","No",0.6,0.45,0.42,20]
[null,"6-yr","100to499","Cut","Non-Rock","Absent","lte10","Yes",0.3,0.25,0.21,21]
[null,"6-yr","100to499","Cut","Non-Rock","Absent","lte10","No",0.55400000000000005,0.45,0.38780000000000003,22]
[null,"6-yr","100to499","Cut","Non-Rock","Present","gt10","Yes",0.25,0.2,0.17499999999999999,23]
[null,"6-yr","100to499","Cut","Non-Rock","Present","gt10","No",0.5,0.4,0.35,24]
[null,"6-yr","100to499","Natural","Rock Slope",null,null,"Yes",0.4,0.3,0.27999999999999997,25]
[null,"6-yr","100to499","Natural","Rock Slope",null,null,"No",0.8,0.5,0.55999999999999994,26]
[null,"6-yr","100to499","Natural","Non-Rock",null,null,"Yes",0.35,0.3,0.24499999999999997,27]
[null,"6-yr","100to499","Natural","Non-Rock",null,null,"No",0.3,0.25,0.21,28]
[null,"20-yr","gt499",null,null,null,null,null,0.99,0.99,0.99,29]
[]
[null,3.13,null,"(miles)","(minutes)"]
[null,"Start","End","Added Travel","Added Travel"]
[null,"Milepost","Milepost","Distance (C7)","Time (Dt)"]
[null,1,14,146,189]
[]
[null,3.1]
[null,null,"Threat"]
[null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C219","v":41800}]
[null,"Bridge",null,{"$f":"C219+5000","v":46800},{"$f":"C219+5000","v":46800},{"$f":"IF(D14<100,C219+200000,2500000)","v":241800}]
[null,"Culvert",{"$f":"C219+5000","v":46800},{"$f":"C219+5000","v":46800}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*D15*C169+200000","v":2812500}]
[null,"Roadway",{"$f":"C219+5000","v":46800},{"$f":"C219+5000","v":46800},null,{"$f":"100*D15*C169+200000","v":2290000}]
[]
[null,"ARC:",{"$f":"D15*D14*C169","v":41800},null,{"$f":"MATCH(C13,B213:B217,0)","v":4},{"$f":"MATCH(C1,C212:F212,0)","v":4}]
[]
[null,3.11]
[null,null,null,null,null,null,null,null,"Year"]
[null,"User Cost Terms",null,null,null,null,"Variable","Value ($)","Published"]
[null,"Average Vehicle Occupancy",null,null,null,null,0,1.77,2019]
[null,"Car Running Cost per Mile",null,null,null,null,"C2",0.59,2019]
[null,"Truck Running Cost per Mile",null,null,null,null,"C3",0.96,2015]
[null,"Average Value of Time per Adult per Hour",null,null,null,null,"C4",10.62,2015]
[null,"Average Value of Freight Driver Cost per Hour",null,null,null,null,"C5",25.31,2015]
[null,"Car Running Cost per Mile",null,null,null,null,"C8",26.52,2015]
[null,"Truck Running Cost per Mile",null,null,null,null,"C9",44.24,2015]
[]
[null,null,null,null,null,null,"A:","<= half road width"]
[null,null,null,null,null,null,"B:","> half road width"]
[null,null,null,null,null,null,"C:","2 directions"]
[]
[null,3.12]
[null,null,null,"Full Closure","Part Closure"]
[null,"Asset","Threat","Days (dFC)","Days (dPC)"]
[null,"Approach","All",2,0]
[null,"Bridge","Flood",180,0]
[null,"Bridge","Debris",2,0]
[null,"Bridge","Rockfall",4,14]
[null,"Culvert","Flood",3,0]
[null,"Culvert","Debris",1,0]
[null,"PTCS","Rockfall",4,14]
[null,"Road A","Flood",1,0]
[null,"Road B","Flood",3,0]
[null,"Road C","Flood",3,0]
[null,"Roadway","Rockfall",4,14]

{"sheet":"Rockfall-Bridge","index":2,"n_rows":194,"n_cols":12,"rows_kept":194,"cut":false,"hidden":false,"merged":[[4,2,4,4],[156,2,156,5],[99,3,99,4],[168,1,168,5],[98,3,98,4]]}
["Problem:",null,"Rockfall"]
[]
["Step 1:","Threat Data Collection"]
[]
[null,"Event","Annual Threat Likelihood"]
[null,"Small",null,{"$f":"VLOOKUP(B6,B101:D103,3,FALSE)","v":1}]
[null,"Medium",null,{"$f":"VLOOKUP(B7,B101:D103,3,FALSE)","v":0.16666666666666666}]
[null,"Large",null,{"$f":"VLOOKUP(B8,B101:D103,3,FALSE)","v":0.05}]
[]
[]
[]
["Step 2:","Asset Data Collection",null,null,null,null,"CODE","Item Description",null,null,"CDOT Link"]
["Site Overview:",null,"Bridge"]
[null,null,"Length:",100,"(feet)"]
[null,"Deck:","Width:",38,"(feet)"]
[null,null,"Length:",187,"(feet)"]
[null,null,"Speed Lim:",55,"(mph)"]
[null,"Total:","AADT Veh:",11950,"(vehicle)",null,"OTIS","Avg. Annual Daily Traffic (all)",null,"CDOT OTIS Data Search Platform"]
[null,null,"AADT Trck:",2050,"(truck)",null,"OTIS","Avg. Annual Daily Traffic (trucks)",null,"CDOT OTIS Data Search Platform"]
[null,null,"Milepost:",10,null,null,"OTIS","CDOT Mile Post",null,"CDOT OTIS Data Search Platform"]
[null,null,"Car User:","C2","C4","C8"]
[null,null,"Trck User:","C3","C5","C9"]
[null,"Work Zone:","Length:",1,"(miles)"]
[null,null,"Speed Red:",15,"(mph)"]
[null,"Rockfall Mitigation:",null,null,null,"No"]
[null,null,"Lithology:","Rock Slope"]
[null,null,"Slope:","Natural"]
[null,null,"Ditch:","Absent"]
[null,null,"Monitored","No"]
[]
["Step 3:","Owner Consequence"]
[]
[]
[null,{"$f":"INDEX(C159:F163,E165,F165)","v":2500000}]
[]
[]
[]
[]
[]
["Step 4:","User Consequence"]
[null,"Full Closure:",null,null,null,null,"Dt:",{"$f":"INDEX(E154:E154,MATCH(C45,D154:D154,0))","v":189},"mins"]
[null,"Avg Veh:",{"$f":"D18","v":11950},"Veh Cost:",{"$f":"VLOOKUP(D21,G170:H176,2)","v":0.59},null,"Veh:",{"$f":"VLOOKUP(E21,G170:H176,2)","v":10.62}]
[null,"Avg Trck:",{"$f":"D19","v":2050},"Trck Cost:",{"$f":"VLOOKUP(D22,G170:H176,2)","v":0.96},null,"Trck:",{"$f":"VLOOKUP(E22,G170:H176,2)","v":25.31}]
[null,"dFC:",{"$f":"SUMPRODUCT((B184:B194=C13)*(C184:C194=C1)*(D184:D194))","v":4},null,null,null,"O:",{"$f":"VLOOKUP(D23,G170:H176,2)","v":1.77}]
[null,"C7:",{"$f":"LOOKUP(2,1/(B154:B154<=D20)/(C154:C154>=D20),D154:D154)","v":146},"VOC.FC:",{"$f":"(E42*C42+E43*C43)*C44*C45","v":5266804},null,"LW.FC:",{"$f":"(H42*H44*C42+H43*C43)*C44*H41/60","v":3484081.8179999995}]
[]
[null,null,null,"Total Full:",{"$f":"E45+H45","v":8750885.818}]
[]
[null,"Partial Closure:"]
[null,"WL:",{"$f":"D23","v":1},"Veh Cost:",{"$f":"VLOOKUP(F21,G170:H176,2)","v":26.52}]
[null,"WZS:",{"$f":"D17","v":55},"Trck Cost:",{"$f":"VLOOKUP(F22,G170:H176,2)","v":44.24}]
[null,"WZSR:",{"$f":"D24","v":15}]
[null,"dPC:",{"$f":"SUMPRODUCT((B184:B194=C13)*(C184:C194=C1)*(E184:E194))","v":14},"VOC.PC:",{"$f":"(1/((1/C50)*(C51-C52))-1/((1/C50)*C51))*(E50*C42+E51*C43)*C53","v":38907.845454545466},null,"LW.PC:",{"$f":"(1/((1/C50)*(C51-C52))-1/((1/C50)*C51))*(H42*H44*C42+H43*C43)*C53","v":26394.559227272737}]
[]
[null,null,null,"Total Part:",{"$f":"E53+H53","v":65302.404681818203}]
[]
[]
[null,null,null,"Total:",{"$f":"E47+E55","v":8816188.2226818185}]
[]
["Step 5:","Vulnerability Assessment"]
[]
[null,"Event Vol:",{"$f":"B101","v":"Small"},{"$f":"INDEX(C101:C103,MATCH(C62,B101:B103,0))","v":"lt100"},"Event Index:",{"$f":"MATCH(D62,C121:C149,0)","v":1}]
[null,null,{"$f":"B102","v":"Medium"},{"$f":"INDEX(C101:C103,MATCH(C63,B101:B103,0))","v":"100to499"},null,{"$f":"MATCH(D63,C121:C149,0)","v":17}]
[null,null,{"$f":"B103","v":"Large"},{"$f":"INDEX(C101:C103,MATCH(C64,B101:B103,0))","v":"gt499"},null,{"$f":"MATCH(D64,C121:C149,0)","v":29}]
[null,"Slope:",null,{"$f":"D27","v":"Natural"},"Slope Index:",{"$f":"MATCH(D65,D121:D148,0)","v":9},{"$f":"F62+F65-1","v":9}]
[null,null,null,null,null,null,{"$f":"F63+F65-1","v":25}]
[null,"Lithology:",null,{"$f":"D26","v":"Rock Slope"},"Lith Index:",{"$f":"MATCH(D67,E121:E128,0)","v":1},{"$f":"G65+F67-1","v":9}]
[null,null,null,null,null,null,{"$f":"IF(D65=\"Cut\",G66+F67-1,G66+MATCH(D67,E145:E148,0)-1)","v":25}]
[null,"Ditch:",null,{"$f":"D28","v":"Absent"},"Ditch Index:",{"$f":"MATCH(D69,F121:F124,0)","v":1},{"$f":"G67+F69-1","v":9}]
[null,null,null,null,null,null,{"$f":"IF(D65=\"Cut\",G68+F69-1,G68)","v":25}]
[null,"Monitored:",null,{"$f":"D29","v":"No"},"Mon Index:",{"$f":"IF(D71=\"Yes\",0,1)","v":1},{"$f":"G69+F71","v":10}]
[null,null,null,null,null,null,{"$f":"G70+F71","v":26}]
[null,"Mitigation:",null,{"$f":"F25","v":"No"},"Mit Index:",{"$f":"MATCH(D73,I120:K120,0)","v":1}]
[]
[null,"Event:","1-yr",{"$f":"INDEX(I121:K149,G71,F73)","v":0.01}]
[null,null,"6-yr",{"$f":"INDEX(I121:K149,G72,F73)","v":0.8}]
[null,null,"20-yr",{"$f":"INDEX(I121:K149,F64,F73)","v":0.99}]
[]
["Step 6:","Risk Assessment"]
[]
[null,"Annual Owner Risk:",null,{"$f":"B34*D75*D6","v":25000}]
[null,null,null,{"$f":"B34*D76*D7","v":333333.33333333331}]
[null,null,null,{"$f":"B34*D77*D8","v":123750}]
[]
[null,"Total Owner Risk:",null,{"$f":"SUM(D81:D83)","v":482083.33333333331}]
[]
[null,"Annual User Risk:",null,{"$f":"E58*D75*D6","v":88161.882226818183}]
[null,null,null,{"$f":"E58*D76*D7","v":1175491.7630242426}]
[null,null,null,{"$f":"E58*D77*D8","v":436401.31702274998}]
[]
[null,"Total User Risk:",null,{"$f":"SUM(D87:D89)","v":1700054.9622738108}]
[]
[null,"Total Annual Risk:",null,{"$f":"D85+D91","v":2182138.295607144}]
[]
[]
["Please customize the information from the standard below:"]
[]
["Exhibits:",3.6]
[null,"Event","Volume","Annual Threat"]
[null,"Magnitude","(cu yds)","Likelihood"]
[null,"Small","lt100",1]
[null,"Medium","100to499",{"$f":"1/6","v":0.16666666666666666}]
[null,"Large","gt499",{"$f":"1/20","v":0.05}]
[]
[null,3.8]
[null,null,"Road"]
[null,"Asset","Type","Units","Unit Cost"]
[null,"Approach",null,"sq ft",350]
[null,"Bridge",null,"sq ft",600]
[null,"CBC",null,"cu ft",55]
[null,"PTCS",null,"sq ft",550]
[null,"Roadway","Asphalt","sq yds",150]
[null,"Roadway","Concrete","sq yds",350]
[]
[null,"Unit Cost:",{"$f":"INDEX(E108:E113,MATCH(C13,B108:B113,0))","v":600},"($ / units)"]
[]
[null,"4.1.1.12"]
[null,"Magnitude",null,"Factors",null,null,null,null,"Vulnerability"]
[null,"Return",null,"Natural or",null,null,null,null,"Mitigation"]
[null,"Period","Volume","Cut Slope","Lithology","Ditch","Width","Monitored","No","Maintained","Installed"]
[null,"1-yr","lt100","Cut","Rock Slope","Absent",null,"Yes",0,0,0,1]
[null,"1-yr","lt100","Cut","Rock Slope","Absent",null,"No",0.01,0.01,0,2]
[null,"1-yr","lt100","Cut","Rock Slope","Present",null,"Yes",0,0,0,3]
[null,"1-yr","lt100","Cut","Rock Slope","Present",null,"No",0.01,0.01,0,4]
[null,"1-yr","lt100","Cut","Non-Rock","Absent",null,"Yes",0,0,0,5]
[null,"1-yr","lt100","Cut","Non-Rock","Absent",null,"No",0.01,0,0,6]
[null,"1-yr","lt100","Cut","Non-Rock","Present",null,"Yes",0,0,0,7]
[null,"1-yr","lt100","Cut","Non-Rock","Present",null,"No",0.01,0,0,8]
[null,"1-yr","lt100","Natural","Rock Slope","Absent",null,"Yes",0.01,0,0,9]
[null,"1-yr","lt100","Natural","Rock Slope","Absent",null,"No",0.01,0.01,0,10]
[null,"1-yr","lt100","Natural","Rock Slope","Present",null,"Yes",0,0,0,11]
[null,"1-yr","lt100","Natural","Rock Slope","Present",null,"No",0.01,0.01,0,12]
[null,"1-yr","lt100","Natural","Non-Rock","Absent",null,"Yes",0,0,0,13]
[null,"1-yr","lt100","Natural","Non-Rock","Absent",null,"No",0.01,0.01,0,14]
[null,"1-yr","lt100","Natural","Non-Rock","Present",null,"Yes",0,0,0,15]
[null,"1-yr","lt100","Natural","Non-Rock","Present",null,"No",0.01,0.01,0,16]
[null,"6-yr","100to499","Cut","Rock Slope","Absent","lte10","Yes",0.35,0.3,0.15,17]
[null,"6-yr","100to499","Cut","Rock Slope","Absent","lte10","No",0.65,0.5,0.25,18]
[null,"6-yr","100to499","Cut","Rock Slope","Present","gt10","Yes",0.3,0.25,0.15,19]
[null,"6-yr","100to499","Cut","Rock Slope","Present","gt10","No",0.6,0.45,0.25,20]
[null,"6-yr","100to499","Cut","Non-Rock","Absent","lte10","Yes",0.3,0.25,0.15,21]
[null,"6-yr","100to499","Cut","Non-Rock","Absent","lte10","No",0.55400000000000005,0.45,0.25,22]
[null,"6-yr","100to499","Cut","Non-Rock","Present","gt10","Yes",0.25,0.2,0.1,23]
[null,"6-yr","100to499","Cut","Non-Rock","Present","gt10","No",0.5,0.4,0.2,24]
[null,"6-yr","100to499","Natural","Rock Slope",null,null,"Yes",0.4,0.3,0.15,25]
[null,"6-yr","100to499","Natural","Rock Slope",null,null,"No",0.8,0.5,0.25,26]
[null,"6-yr","100to499","Natural","Non-Rock",null,null,"Yes",0.35,0.3,0.15,27]
[null,"6-yr","100to499","Natural","Non-Rock",null,null,"No",0.3,0.25,0.15,28]
[null,"20-yr","gt499",null,null,null,null,null,0.99,0.99,0.99,29]
[]
[null,3.13,null,"(miles)","(minutes)"]
[null,"Start","End","Added Travel","Added Travel"]
[null,"Milepost","Milepost","Distance (C7)","Time (Dt)"]
[null,1,14,146,189]
[]
[null,3.1]
[null,null,"Threat"]
[null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C165","v":2280000}]
[null,"Bridge",null,{"$f":"C165+5000","v":2285000},{"$f":"C165+5000","v":2285000},{"$f":"IF(D14<100,C165+200000,2500000)","v":2500000}]
[null,"Culvert",{"$f":"C165+5000","v":2285000},{"$f":"C165+5000","v":2285000}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*D15*C115+200000","v":3050000}]
[null,"Roadway",{"$f":"C165+5000","v":2285000},{"$f":"C165+5000","v":2285000},null,{"$f":"100*D15*C115+200000","v":2480000}]
[]
[null,"ARC:",{"$f":"D14*D15*C115","v":2280000},null,{"$f":"MATCH(C13,B159:B163,0)","v":2},{"$f":"MATCH(C1,C158:F158,0)","v":4}]
[]
[null,3.11]
[null,null,null,null,null,null,null,null,"Year"]
[null,"User Cost Terms",null,null,null,null,"Variable","Value ($)","Published"]
[null,"Average Vehicle Occupancy",null,null,null,null,0,1.77,2019]
[null,"Car Running Cost per Mile",null,null,null,null,"C2",0.59,2019]
[null,"Truck Running Cost per Mile",null,null,null,null,"C3",0.96,2015]
[null,"Average Value of Time per Adult per Hour",null,null,null,null,"C4",10.62,2015]
[null,"Average Value of Freight Driver Cost per Hour",null,null,null,null,"C5",25.31,2015]
[null,"Car Running Cost per Mile",null,null,null,null,"C8",26.52,2015]
[null,"Truck Running Cost per Mile",null,null,null,null,"C9",44.24,2015]
[]
[null,null,null,null,null,null,"A:","<= half road width"]
[null,null,null,null,null,null,"B:","> half road width"]
[null,null,null,null,null,null,"C:","2 directions"]
[null,3.12]
[null,null,null,"Full Closure","Part Closure"]
[null,"Asset","Threat","Days (dFC)","Days (dPC)"]
[null,"Approach","All",2,0]
[null,"Bridge","Flood",180,0]
[null,"Bridge","Debris",2,0]
[null,"Bridge","Rockfall",4,14]
[null,"Culvert","Flood",3,0]
[null,"Culvert","Debris",1,0]
[null,"PTCS","Rockfall",4,14]
[null,"Road A","Flood",1,0]
[null,"Road B","Flood",3,0]
[null,"Road C","Flood",3,0]
[null,"Roadway","Rockfall",4,14]

{"sheet":"Rockfall-Roadway","index":3,"n_rows":192,"n_cols":12,"rows_kept":192,"cut":false,"hidden":false,"merged":[[4,2,4,4]]}
["Problem:",null,"Rockfall"]
[]
["Step 1:","Threat Data Collection"]
[]
[null,"Event","Annual Threat Likelihood"]
[null,"Small",null,{"$f":"VLOOKUP(B6,B99:D101,3,FALSE)","v":1}]
[null,"Medium",null,{"$f":"VLOOKUP(B7,B99:D101,3,FALSE)","v":0.16666666666666666}]
[null,"Large",null,{"$f":"VLOOKUP(B8,B99:D101,3,FALSE)","v":0.05}]
[]
[]
["Step 2:","Asset Data Collection",null,null,null,null,"CODE","Item Description",null,null,"CDOT Link"]
["Site Overview:",null,"Roadway","Asphalt"]
[null,"Roadway:","Length:",100,"(feet)"]
[null,null,"Width:",38,"(feet)"]
[null,null,"Speed Lim:",50,"(mph)"]
[null,"Total:","AADT Veh:",13780,"(vehicle)",null,"OTIS","Avg. Annual Daily Traffic (all)",null,"CDOT OTIS Data Search Platform"]
[null,null,"AADT Trck:",2220,"(truck)",null,"OTIS","Avg. Annual Daily Traffic (trucks)",null,"CDOT OTIS Data Search Platform"]
[null,null,"Milepost:",10,null,null,"OTIS","CDOT Mile Post",null,"CDOT OTIS Data Search Platform"]
[null,null,"Car User:","C2","C4","C8"]
[null,null,"Trck User:","C3","C5","C9"]
[null,"Work Zone:","Length:",1,"(miles)"]
[null,null,"Speed Red:",15,"(mph)"]
[null,"Rockfall Mitigation:",null,null,null,"No"]
[null,null,"Lithology:","Rock Slope"]
[null,null,"Slope:","Natural"]
[null,null,"Ditch:","Absent"]
[null,null,"Monitored","No"]
[]
["Step 3:","Owner Consequence"]
[]
[]
[null,{"$f":"ROUNDUP(INDEX(C157:F161,E163,F163)/50,0)*50","v":263350}]
[]
[]
[]
[]
[]
["Step 4:","User Consequence"]
[null,"Full Closure:",null,null,null,null,"Dt:",{"$f":"INDEX(E152:E153,MATCH(C43,D152:D153,0))","v":189},"mins"]
[null,"Avg Veh:",{"$f":"D16","v":13780},"Veh Cost:",{"$f":"VLOOKUP(D19,G168:H174,2)","v":0.59},null,"Veh:",{"$f":"VLOOKUP(E19,G168:H174,2)","v":10.62}]
[null,"Avg Trck:",{"$f":"D17","v":2220},"Trck Cost:",{"$f":"VLOOKUP(D20,G168:H174,2)","v":0.96},null,"Trck:",{"$f":"VLOOKUP(E20,G168:H174,2)","v":25.31}]
[null,"dFC:",{"$f":"SUMPRODUCT((B182:B192=C12)*(C182:C192=C1)*(D182:D192))","v":4},null,null,null,"O:",{"$f":"VLOOKUP(D21,G168:H174,2)","v":1.77}]
[null,"C7:",{"$f":"LOOKUP(2,1/(B152:B153<=D18)/(C152:C153>=D18),D152:D153)","v":146},"VOC.FC:",{"$f":"(E40*C40+E41*C41)*C42*C43","v":5992657.5999999996},null,"LW.FC:",{"$f":"(H40*H42*C40+H41*C41)*C42*H39/60","v":3971726.2871999997}]
[]
[null,null,null,"Total Full:",{"$f":"E43+H43","v":9964383.8871999998}]
[]
[null,"Partial Closure:"]
[null,"WL:",{"$f":"D21","v":1},"Veh Cost:",{"$f":"VLOOKUP(F19,G168:H174,2)","v":26.52}]
[null,"WZS:",{"$f":"D15","v":50},"Trck Cost:",{"$f":"VLOOKUP(F20,G168:H174,2)","v":44.24}]
[null,"WZSR:",{"$f":"D22","v":15}]
[null,"dPC:",{"$f":"SUMPRODUCT((B182:B192=C12)*(C182:C192=C1)*(E182:E192))","v":14},"VOC.PC:",{"$f":"(1/((1/C48)*(C49-C50))-1/((1/C48)*C49))*(E48*C40+E49*C41)*C51","v":55639.007999999987},null,"LW.PC:",{"$f":"(1/((1/C48)*(C49-C50))-1/((1/C48)*C49))*(H40*H42*C40+H41*C41)*C51","v":37825.964639999991}]
[]
[null,null,null,"Total Part:",{"$f":"E51+H51","v":93464.972639999978}]
[]
[]
[null,null,null,"Total:",{"$f":"E45+E53","v":10057848.85984}]
[]
["Step 5:","Vulnerability Assessment"]
[]
[null,"Event Vol:",{"$f":"B99","v":"Small"},{"$f":"INDEX(C99:C101,MATCH(C60,B99:B101,0))","v":"lt100"},"Event Index:",{"$f":"MATCH(D60,C119:C147,0)","v":1}]
[null,null,{"$f":"B100","v":"Medium"},{"$f":"INDEX(C99:C101,MATCH(C61,B99:B101,0))","v":"100to499"},null,{"$f":"MATCH(D61,C119:C147,0)","v":17}]
[null,null,{"$f":"B101","v":"Large"},{"$f":"INDEX(C99:C101,MATCH(C62,B99:B101,0))","v":"gt499"},null,{"$f":"MATCH(D62,C119:C147,0)","v":29}]
[null,"Slope:",null,{"$f":"D25","v":"Natural"},"Slope Index:",{"$f":"MATCH(D63,D119:D146,0)","v":9},{"$f":"F60+F63-1","v":9}]
[null,null,null,null,null,null,{"$f":"F61+F63-1","v":25}]
[null,"Lithology:",null,{"$f":"D24","v":"Rock Slope"},"Lith Index:",{"$f":"MATCH(D65,E119:E126,0)","v":1},{"$f":"G63+F65-1","v":9}]
[null,null,null,null,null,null,{"$f":"IF(D63=\"Cut\",G64+F65-1,G64+MATCH(D65,E143:E146,0)-1)","v":25}]
[null,"Ditch:",null,{"$f":"D26","v":"Absent"},"Ditch Index:",{"$f":"MATCH(D67,F119:F122,0)","v":1},{"$f":"G65+F67-1","v":9}]
[null,null,null,null,null,null,{"$f":"IF(D63=\"Cut\",G66+F67-1,G66)","v":25}]
[null,"Monitored:",null,{"$f":"D27","v":"No"},"Mon Index:",{"$f":"IF(D69=\"Yes\",0,1)","v":1},{"$f":"G67+F69","v":10}]
[null,null,null,null,null,null,{"$f":"G68+F69","v":26}]
[null,"Mitigation:",null,{"$f":"F23","v":"No"},"Mit Index:",{"$f":"MATCH(D71,I118:K118,0)","v":1}]
[]
[null,"Event:","1-yr",{"$f":"INDEX(I119:K147,G69,F71)","v":0.01}]
[null,null,"6-yr",{"$f":"INDEX(I119:K147,G70,F71)","v":0.8}]
[null,null,"20-yr",{"$f":"INDEX(I119:K147,F62,F71)","v":0.99}]
[]
["Step 6:","Risk Assessment"]
[]
[null,"Annual Owner Risk:",null,{"$f":"B32*D73*D6","v":2633.5},{"$f":"C73","v":"1-yr"}]
[null,null,null,{"$f":"B32*D74*D7","v":35113.333333333328},{"$f":"C74","v":"6-yr"}]
[null,null,null,{"$f":"B32*D75*D8","v":13035.825000000001},{"$f":"C75","v":"20-yr"}]
[]
[null,"Total Owner Risk:",null,{"$f":"SUM(D79:D81)","v":50782.658333333326}]
[]
[null,"Annual User Risk:",null,{"$f":"E56*D73*D6","v":100578.4885984},{"$f":"C73","v":"1-yr"}]
[null,null,null,{"$f":"E56*D74*D7","v":1341046.5146453334},{"$f":"C74","v":"6-yr"}]
[null,null,null,{"$f":"E56*D75*D8","v":497863.51856207999},{"$f":"C75","v":"20-yr"}]
[]
[null,"Total User Risk:",null,{"$f":"SUM(D85:D87)","v":1939488.5218058135}]
[]
[null,"Total Annual Risk:",null,{"$f":"D83+D89","v":1990271.1801391467}]
[]
[]
["Please customize the information from the standard below:"]
[]
["Exhibits:",3.6]
[null,"Event","Volume","Annual Threat"]
[null,"Magnitude","(cu yds)","Likelihood"]
[null,"Small","lt100",1]
[null,"Medium","100to499",{"$f":"1/6","v":0.16666666666666666}]
[null,"Large","gt499",{"$f":"1/20","v":0.05}]
[]
[null,3.8]
[null,null,"Road"]
[null,"Asset","Type","Units","Unit Cost"]
[null,"Approach",null,"sq ft",350]
[null,"Bridge",null,"sq ft",600]
[null,"CBC",null,"cu ft",55]
[null,"PTCS",null,"sq ft",550]
[null,"Roadway","Asphalt","sq yds",150]
[null,"Roadway","Concrete","sq yds",350]
[]
[null,"Unit Cost:",{"$f":"INDEX(E110:E111,MATCH(D12,C110:C111,0))","v":150},"($ / units)"]
[]
[null,"4.1.1.12"]
[null,"Magnitude",null,"Factors",null,null,null,null,"Vulnerability"]
[null,"Return",null,"Natural or",null,null,null,null,"Mitigation"]
[null,"Period","Volume","Cut Slope","Lithology","Ditch","Width","Monitored","No","Maintained","Installed"]
[null,"1-yr","lt100","Cut","Rock Slope","Absent",null,"Yes",0,0,0,1]
[null,"1-yr","lt100","Cut","Rock Slope","Absent",null,"No",0.01,0.01,0,2]
[null,"1-yr","lt100","Cut","Rock Slope","Present",null,"Yes",0,0,0,3]
[null,"1-yr","lt100","Cut","Rock Slope","Present",null,"No",0.01,0.01,0,4]
[null,"1-yr","lt100","Cut","Non-Rock","Absent",null,"Yes",0,0,0,5]
[null,"1-yr","lt100","Cut","Non-Rock","Absent",null,"No",0.01,0,0,6]
[null,"1-yr","lt100","Cut","Non-Rock","Present",null,"Yes",0,0,0,7]
[null,"1-yr","lt100","Cut","Non-Rock","Present",null,"No",0.01,0,0,8]
[null,"1-yr","lt100","Natural","Rock Slope","Absent",null,"Yes",0.01,0,0,9]
[null,"1-yr","lt100","Natural","Rock Slope","Absent",null,"No",0.01,0.01,0,10]
[null,"1-yr","lt100","Natural","Rock Slope","Present",null,"Yes",0,0,0,11]
[null,"1-yr","lt100","Natural","Rock Slope","Present",null,"No",0.01,0.01,0,12]
[null,"1-yr","lt100","Natural","Non-Rock","Absent",null,"Yes",0,0,0,13]
[null,"1-yr","lt100","Natural","Non-Rock","Absent",null,"No",0.01,0.01,0,14]
[null,"1-yr","lt100","Natural","Non-Rock","Present",null,"Yes",0,0,0,15]
[null,"1-yr","lt100","Natural","Non-Rock","Present",null,"No",0.01,0.01,0,16]
[null,"6-yr","100to499","Cut","Rock Slope","Absent","lte10","Yes",0.35,0.3,0.15,17]
[null,"6-yr","100to499","Cut","Rock Slope","Absent","lte10","No",0.65,0.5,0.25,18]
[null,"6-yr","100to499","Cut","Rock Slope","Present","gt10","Yes",0.3,0.25,0.15,19]
[null,"6-yr","100to499","Cut","Rock Slope","Present","gt10","No",0.6,0.45,0.25,20]
[null,"6-yr","100to499","Cut","Non-Rock","Absent","lte10","Yes",0.3,0.25,0.15,21]
[null,"6-yr","100to499","Cut","Non-Rock","Absent","lte10","No",0.55400000000000005,0.45,0.25,22]
[null,"6-yr","100to499","Cut","Non-Rock","Present","gt10","Yes",0.25,0.2,0.1,23]
[null,"6-yr","100to499","Cut","Non-Rock","Present","gt10","No",0.5,0.4,0.2,24]
[null,"6-yr","100to499","Natural","Rock Slope",null,null,"Yes",0.4,0.3,0.15,25]
[null,"6-yr","100to499","Natural","Rock Slope",null,null,"No",0.8,0.5,0.25,26]
[null,"6-yr","100to499","Natural","Non-Rock",null,null,"Yes",0.35,0.3,0.15,27]
[null,"6-yr","100to499","Natural","Non-Rock",null,null,"No",0.3,0.25,0.15,28]
[null,"20-yr","gt499",null,null,null,null,null,0.99,0.99,0.99,29]
[]
[null,3.13,null,"(miles)","(minutes)"]
[null,"Start","End","Added Travel","Added Travel"]
[null,"Milepost","Milepost","Distance (C7)","Time (Dt)"]
[null,1,14,146,189]
[]
[null,3.1]
[null,null,"Threat"]
[null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C163","v":63333.333333333336}]
[null,"Bridge",null,{"$f":"C163+5000","v":68333.333333333343},{"$f":"C163+5000","v":68333.333333333343},{"$f":"IF(D13<101,C163+200000,2500000)","v":263333.33333333331}]
[null,"Culvert",{"$f":"C163+5000","v":68333.333333333343},{"$f":"C163+5000","v":68333.333333333343}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*D14*C113+200000","v":912500}]
[null,"Roadway",{"$f":"C163+5000","v":68333.333333333343},{"$f":"C163+5000","v":68333.333333333343},null,{"$f":"(100*D14/9)*C113+200000","v":263333.33333333331}]
[]
[null,"ARC:",{"$f":"(D13*D14/9)*C113","v":63333.333333333336},null,{"$f":"MATCH(C12,B157:B161,0)","v":5},{"$f":"MATCH(C1,C156:F156,0)","v":4}]
[]
[null,3.11]
[null,null,null,null,null,null,null,null,"Year"]
[null,"User Cost Terms",null,null,null,null,"Variable","Value ($)","Published"]
[null,"Average Vehicle Occupancy",null,null,null,null,0,1.77,2019]
[null,"Car Running Cost per Mile",null,null,null,null,"C2",0.59,2019]
[null,"Truck Running Cost per Mile",null,null,null,null,"C3",0.96,2015]
[null,"Average Value of Time per Adult per Hour",null,null,null,null,"C4",10.62,2015]
[null,"Average Value of Freight Driver Cost per Hour",null,null,null,null,"C5",25.31,2015]
[null,"Car Running Cost per Mile",null,null,null,null,"C8",26.52,2015]
[null,"Truck Running Cost per Mile",null,null,null,null,"C9",44.24,2015]
[]
[null,null,null,null,null,null,"A:","<= half road width"]
[null,null,null,null,null,null,"B:","> half road width"]
[null,null,null,null,null,null,"C:","2 directions"]
[null,3.12]
[null,null,null,"Full Closure","Part Closure"]
[null,"Asset","Threat","Days (dFC)","Days (dPC)"]
[null,"Approach","All",2,0]
[null,"Bridge","Flood",180,0]
[null,"Bridge","Debris",2,0]
[null,"Bridge","Rockfall",4,14]
[null,"Culvert","Flood",3,0]
[null,"Culvert","Debris",1,0]
[null,"PTCS","Rockfall",4,14]
[null,"Road A","Flood",1,0]
[null,"Road B","Flood",3,0]
[null,"Road C","Flood",3,0]
[null,"Roadway","Rockfall",4,14]

{"sheet":"Flood-Roadway","index":4,"n_rows":188,"n_cols":21,"rows_kept":188,"cut":false,"hidden":false,"merged":[[5,3,5,4],[135,1,135,5],[179,2,179,5],[5,1,5,2],[113,8,113,11],[121,8,121,11],[163,2,163,5],[169,3,169,7],[84,3,84,4],[113,2,113,5],[85,1,85,2],[85,3,85,4],[121,2,121,5]]}
["Problem:",null,"Flood"]
[]
[]
["Step 1:","Threat Data Collection"]
[]
[null,"Recurrence Interval",null,"Annual Threat Likelihood"]
[null,100,"years",null,{"$f":"VLOOKUP(B7,B87:D94,3,FALSE)","v":0.01}]
[null,500,"years",null,{"$f":"VLOOKUP(B8,B87:D94,3,FALSE)","v":2E-3}]
[]
[]
[]
[]
["Step 2:","Asset Data Collection",null,null,null,"CODE","Item Description",null,null,"CDOT Link"]
["Site Overview:",null,"Roadway","Asphalt","Road C"]
[null,null,"Milepost:",12,13,"OTIS","CDOT Mile Post",null,"CDOT OTIS Data Search Platform"]
[null,null,"# Lanes:",4]
[null,"East","Overtop MP:",12,13]
[null,null,"Over Len:",5914,"(feet)",null,"Overtop Length"]
[null,"Area Over:","100-yr",22587,"(sq yds)",null,"Area over 100 yr Event"]
[null,null,"500-yr",22587,"(sq yds)",null,"Area over 500 yr Event"]
[null,{"$f":"IF(B17=\"East\",\"West\",IF(B17=\"North\",\"South\",IF(B17=\"West\",\"East\",IF(B17=\"South\",\"North\",\"West\"))))","v":"West"},"Overtop MP:",12,13,"OTIS","CDOT Mile Post",null,"CDOT OTIS Data Search Platform"]
[null,null,"Over Len:",6758,"(feet)",null,"Overtop Length"]
[null,null,"100-yr",25615,null,null,"Area over 100 yr Event"]
[null,null,"500-yr",25615,null,null,"Area over 500 yr Event"]
[null,"Total:","AADT Veh:",20490,"(vehicle)","OTIS","Avg. Annual Daily Traffic (all)",null,"CDOT OTIS Data Search Platform"]
[null,null,"AADT Trck:",2510,"(truck)","OTIS","Avg. Annual Daily Traffic (trucks)",null,"CDOT OTIS Data Search Platform"]
[null,null,"Car User:","C2","C4"]
[null,null,"Trck User:","C3","C5"]
[null,null,"Occup:",0]
[null,null,"Slope:","Low"]
[null,null,"Cover:","Shrubs"]
[null,"Soil:","Class:","A1toA3"]
[null,null,"Frost:","Moderate"]
[null,null,"Terrain:","Mountainous"]
[]
["Step 3:","Owner Consequence"]
[]
[]
[null,{"$f":"C19","v":"100-yr"},{"$f":"INDEX(C116:F120,MATCH(C14,B116:B120,1),MATCH(C1,C115:F115,1))","v":3393050},{"$f":"B17","v":"East"}]
[null,{"$f":"C20","v":"500-yr"},{"$f":"INDEX(C124:F128,MATCH(C14,B124:B128,1),MATCH(C1,C123:F123,1))","v":3393050}]
[null,{"$f":"C23","v":"100-yr"},{"$f":"INDEX(I116:L120,MATCH(C14,H116:H120,1),MATCH(C1,I115:L115,1))","v":3847250},{"$f":"B21","v":"West"}]
[null,{"$f":"C24","v":"500-yr"},{"$f":"INDEX(I124:L128,MATCH(C14,H124:H128,1),MATCH(C1,I123:L123,1))","v":3847250}]
[]
[]
["Step 4:","User Consequence"]
[null,"Full Closure:",null,null,null,null,"Dt:",{"$f":"INDEX(E111:E111,MATCH(C50,D111:D111,))","v":189},"mins"]
[null,"Avg Veh:",{"$f":"0.5*D25","v":10245},"Veh Cost:",{"$f":"VLOOKUP(D27,G137:H143,2)","v":0.59},null,"Veh:",{"$f":"VLOOKUP(E27,G137:H143,2)","v":10.62}]
[null,"Avg Trck:",{"$f":"0.5*D26","v":1255},"Trck Cost:",{"$f":"VLOOKUP(D28,G137:H143,2)","v":0.96},null,"Trck:",{"$f":"VLOOKUP(E28,G137:H143,2)","v":25.31}]
[null,"dFC:",{"$f":"SUMPRODUCT((B151:B161=E14)*(D151:D161))","v":3},null,null,null,"O:",{"$f":"VLOOKUP(D29,G137:H143,2)","v":1.77}]
[null,"C7:",{"$f":"LOOKUP(2,1/(B111:B111<=E15)/(C111:C111>=D15),D111:D111)","v":146},"VOC.FC:",{"$f":"(E47*C47+E48*C48)*C49*C50","v":3175215.3},"each","LW.FC:",{"$f":"(H47*H49*C47+H48*C48)*C49*H46/60","v":2120045.2528499998},"each"]
[]
[null,null,null,"Total:",{"$f":"E50+H50","v":5295260.5528499996},"each","Site:",{"$f":"2*E52","v":10590521.105699999}]
[]
[]
[]
["Step 5:","Vulnerability Assessment"]
[]
[null,"Soil Classification:",null,null,{"$f":"D32","v":"A1toA3"}]
[null,"Frost Action:",null,null,{"$f":"D33","v":"Moderate"}]
[]
[null,"Embankment Erodibility Potential:",null,null,{"$f":"INDEX(C166:F167,MATCH(E58,B166:B167,0),MATCH(E59,C165:F165,0))","v":"Moderate"}]
[]
[null,"Terrain:",null,null,{"$f":"D34","v":"Mountainous"},"100-yr Ind:",{"$f":"MATCH(E63,C172:C174,0)","v":3}]
[null,null,null,null,null,"500-yr Ind:",{"$f":"3+MATCH(E63,C175:C177,0)","v":6}]
[null,"100-year",null,null,{"$f":"INDEX(D172:H177,G63,MATCH(E61,D171:H171,0))","v":0.4}]
[null,"500-year",null,null,{"$f":"INDEX(D172:H177,G64,MATCH(E61,D171:H171,0))","v":0.99}]
[]
[]
["Step 6:","Risk Assessment"]
[]
[null,"Annual Owner Risk:",null,"100-year",{"$f":"B17","v":"East"},{"$f":"C39*E65*(1/100)","v":13572.2},null,"Annual User Risk:",null,"100-year",{"$f":"B17","v":"East"},{"$f":"E52*E65*(1/100)","v":21181.042211399999}]
[null,null,null,null,{"$f":"B21","v":"West"},{"$f":"C41*E65*(1/100)","v":15389},null,null,null,null,{"$f":"B21","v":"West"},{"$f":"E52*E65*(1/100)","v":21181.042211399999}]
[]
[null,null,null,"500-year",{"$f":"B17","v":"East"},{"$f":"C39*E66*(1/500)","v":6718.2390000000005},null,null,null,"500-year",{"$f":"B17","v":"East"},{"$f":"E52*E66*(1/500)","v":10484.615894643001}]
[null,null,null,null,{"$f":"B21","v":"West"},{"$f":"C42*E66*(1/500)","v":7617.5550000000003},null,null,null,null,{"$f":"B21","v":"West"},{"$f":"E52*E66*(1/500)","v":10484.615894643001}]
[]
[null,"Total Owner Risk:",null,null,null,{"$f":"SUM(F71:F75)","v":43296.993999999999},null,"Total User Risk:",null,null,null,{"$f":"SUM(L71:L75)","v":63331.316212086}]
[]
[null,null,null,null,null,null,null,"Total Annual Risk:",null,null,null,{"$f":"F77+L77","v":106628.310212086}]
[]
[]
["Please customize the information from the standard below:"]
[]
["Exhibits:",3.6]
[null,null,null,"Annual Threat"]
[null,"Recurrence Interval",null,"Likelihood"]
[null,1,"year",1]
[null,2,"years",{"$f":"1/2","v":0.5}]
[null,5,"years",{"$f":"1/5","v":0.2}]
[null,10,"years",{"$f":"1/10","v":0.1}]
[null,25,"years",{"$f":"1/25","v":0.04}]
[null,50,"years",{"$f":"1/50","v":0.02}]
[null,100,"years",{"$f":"1/100","v":0.01}]
[null,500,"years",{"$f":"1/500","v":2E-3}]
[]
[null,3.8]
[null,null,"Road"]
[null,"Asset","Type","Units","Unit Cost"]
[null,"Approach",null,"sq ft",350]
[null,"Bridge",null,"sq ft",600]
[null,"CBC",null,"cu ft",55]
[null,"PTCS",null,"sq ft",550]
[null,"Roadway","Asphalt","sq yds",150]
[null,"Roadway","Concrete","sq yds",350]
[]
[null,"Unit Cost:",{"$f":"INDEX(E99:E104,MATCH(C14,B99:B104,0))","v":150},"($ / units)"]
[]
[null,3.13,null,"(miles)","(minutes)"]
[null,"Start","End","Added Travel","Added Travel"]
[null,"Milepost","Milepost","Distance (C7)","Time (Dt)"]
[null,1,14,146,189]
[]
[null,3.1]
[null,null,"Threat",null,null,null,{"$f":"B17","v":"East"},null,"Threat",null,null,null,{"$f":"B21","v":"West"}]
[null,"Asset","Debris","Flood","Scour","Rockfall",null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C130","v":3388050},null,null,null,"Approach",null,{"$f":"I130","v":3842250}]
[null,"Bridge",null,{"$f":"C130+5000","v":3393050},{"$f":"C130+5000","v":3393050},{"$f":"IF((E17-D17)<100,C130+200000,2500000)","v":3588050},null,"Bridge",null,{"$f":"I130+5000","v":3847250},{"$f":"I130+5000","v":3847250},{"$f":"IF((F89-E89)<100,I130+200000,2500000)","v":4042250}]
[null,"Culvert",{"$f":"C130+5000","v":3393050},{"$f":"C130+5000","v":3393050},null,null,null,"Culvert",{"$f":"I130+5000","v":3847250},{"$f":"I130+5000","v":3847250}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*48*C106+200000","v":1100000},null,"PTCS",null,null,null,{"$f":"0.25*500*48*C106+200000","v":1100000},null,null,"Approach Directions:",null,"Soil Classification",null,"Frost Action",null,"Terrain"]
[null,"Roadway",{"$f":"C130+5000","v":3393050},{"$f":"C130+5000","v":3393050},null,{"$f":"100*48*C106+200000","v":920000},null,"Roadway",{"$f":"I130+5000","v":3847250},{"$f":"I130+5000","v":3847250},null,{"$f":"100*48*C106+200000","v":920000},null,null,"East",null,"A1toA3",null,"None",null,"Level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West",null,"A4toA8",null,"Low",null,"Rolling"]
[null,null,"Threat",null,null,null,{"$f":"B21","v":"West"},null,"Threat",null,null,null,{"$f":"B21","v":"West"},null,"North",null,null,null,"Moderate",null,"Mountainous"]
[null,"Asset","Debris","Flood","Scour","Rockfall",null,"Asset","Debris","Flood","Scour","Rockfall",null,null,"South",null,null,null,"High"]
[null,"Approach",null,{"$f":"C131","v":3388050},null,null,null,"Approach",null,{"$f":"I131","v":3842250}]
[null,"Bridge",null,{"$f":"C131+5000","v":3393050},{"$f":"C131+5000","v":3393050},{"$f":"IF((E17-D17)<100,C131+200000,2500000)","v":3588050},null,"Bridge",null,{"$f":"I131+5000","v":3847250},{"$f":"I131+5000","v":3847250},{"$f":"IF((F89-E89)<100,I131+200000,2500000)","v":4042250}]
[null,"Culvert",{"$f":"C131+5000","v":3393050},{"$f":"C131+5000","v":3393050},null,null,null,"Culvert",{"$f":"I131+5000","v":3847250},{"$f":"I131+5000","v":3847250}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*48*C106+200000","v":1100000},null,"PTCS",null,null,null,{"$f":"0.25*500*48*C106+200000","v":1100000}]
[null,"Roadway",{"$f":"C131+5000","v":3393050},{"$f":"C131+5000","v":3393050},null,{"$f":"100*48*C106+200000","v":920000},null,"Roadway",{"$f":"I131+5000","v":3847250},{"$f":"I131+5000","v":3847250},null,{"$f":"100*48*C106+200000","v":920000}]
[]
[null,"ARC:",{"$f":"D19*C106","v":3388050},"for the:",{"$f":"B17","v":"East"},{"$f":"C19","v":"100-yr"},"event","ARC:",{"$f":"D23*C106","v":3842250},"for the:",{"$f":"B21","v":"West"},{"$f":"C23","v":"100-yr"},"event"]
[null,null,{"$f":"D20*C106","v":3388050},"for the:",{"$f":"B17","v":"East"},{"$f":"C20","v":"500-yr"},"event",null,{"$f":"D24*C106","v":3842250},"for the:",{"$f":"B21","v":"West"},{"$f":"C24","v":"500-yr"},"event"]
[null,null,{"$f":"C130+C131","v":6776100},"total",null,null,null,null,{"$f":"I130+I131","v":7684500},"total"]
[]
[null,3.11]
[null,null,null,null,null,null,null,null,"Year"]
[null,"User Cost Terms",null,null,null,null,"Variable","Value ($)","Published"]
[null,"Average Vehicle Occupancy",null,null,null,null,0,1.77,2019]
[null,"Car Running Cost per Mile",null,null,null,null,"C2",0.59,2019]
[null,"Truck Running Cost per Mile",null,null,null,null,"C3",0.96,2015]
[null,"Average Value of Time per Adult per Hour",null,null,null,null,"C4",10.62,2015]
[null,"Average Value of Freight Driver Cost per Hour",null,null,null,null,"C5",25.31,2015]
[null,"Car Running Cost per Mile",null,null,null,null,"C8",26.52,2015]
[null,"Truck Running Cost per Mile",null,null,null,null,"C9",44.24,2015]
[]
[null,null,null,null,null,null,"A:","<= half road width"]
[null,null,null,null,null,null,"B:","> half road width"]
[null,null,null,null,null,null,"C:","2 directions"]
[null,3.12]
[null,null,null,"Full Closure","Part Closure"]
[null,"Asset","Threat","Days (dFC)","Days (dPC)"]
[null,"Approach","All",2,0]
[null,"Bridge","Flood",180,0]
[null,"Bridge","Debris",2,0]
[null,"Bridge","Rockfall",4,14]
[null,"Culvert","Flood",3,0]
[null,"Culvert","Debris",1,0]
[null,"PTCS","Rockfall",4,14]
[null,"Road A","Flood",1,0]
[null,"Road B","Flood",3,0]
[null,"Road C","Flood",3,0]
[null,"Roadway","Rockfall",4,14]
[]
[null,"4.2.1.15"]
[null,"Soil","Frost Action"]
[null,"Class","None","Low","Moderate","High"]
[null,"A1toA3","Very Low","Low","Moderate","High"]
[null,"A4toA8","Moderate","High","Very High","Very High"]
[]
[null,"4.2.1.16"]
[null,"Flood",null,"Embankment Erodibility Potential"]
[null,"Event","Terrain","Very Low","Low","Moderate","High","Very High"]
[null,"100-yr","Level",0.22,0.23,0.25,0.31,0.33]
[null,"100-yr","Rolling",0.26,0.28000000000000003,0.3,0.36,0.39]
[null,"100-yr","Mountainous",0.35,0.37,0.4,0.48,0.52]
[null,"500-yr","Level",0.55000000000000004,0.59,0.63,0.77,0.83]
[null,"500-yr","Rolling",0.66,0.7,0.75,0.91,0.99]
[null,"500-yr","Mountainous",0.88,0.93,0.99,0.99,0.99]
[]
[null,"4.2.2.8"]
[null,"Site","Landcover"]
[null,"Slopes","Water & Snow","Urban","Shrubs","Trees"]
[null,"Low","Very Low","Low","Moderate","Moderate"]
[null,"Moderate","Very Low","Moderate","High","High"]
[null,"High","Very Low","High","High","Very High"]
[]
[]
[]
[null,"Debris Potential Factor:",null,null,{"$f":"INDEX(C182:F184,MATCH(D30,B182:B184,0),MATCH(D31,C181:F181,0))","v":"Moderate"}]

{"sheet":"Flood-Bridge","index":5,"n_rows":195,"n_cols":28,"rows_kept":195,"cut":false,"hidden":false,"merged":[[5,3,5,4],[113,1,113,5],[72,3,72,4],[101,2,101,5],[73,1,73,2],[73,3,73,4],[5,1,5,2],[151,5,151,13],[151,19,151,27],[153,5,153,7],[153,8,153,10],[153,11,153,13],[183,17,184,17],[155,15,174,15],[155,16,158,16],[155,17,156,17],[157,17,158,17],[159,16,162,16],[159,17,160,17],[161,17,162,17],[163,16,166,16],[163,17,164,17],[165,17,166,17],[167,16,170,16],[167,17,168,17],[169,17,170,17],[171,16,174,16],[171,17,172,17],[185,17,186,17],[173,17,174,17],[175,15,194,15],[175,16,178,16],[175,17,176,17],[177,17,178,17],[179,16,182,16],[179,17,180,17],[181,17,182,17],[183,16,186,16],[187,16,190,16],[187,17,188,17],[189,17,190,17],[191,16,194,16],[191,17,192,17],[193,17,194,17]]}
["Problem:",null,"Flood"]
[]
[]
["Step 1:","Threat Data Collection"]
[]
[null,"Recurrence Interval",null,"Annual Threat Likelihood"]
[null,100,"years",null,{"$f":"VLOOKUP(B7,B75:D82,3,FALSE)","v":0.01}]
[null,500,"years",null,{"$f":"VLOOKUP(B8,B76:D83,3,FALSE)","v":2E-3}]
[]
[]
[]
[]
["Step 2:","Asset Data Collection"]
["Site Overview:",null,"Bridge",null,null,"CODE","Item Description",null,null,"CDOT Link"]
[null,null,"Length:",83,"(feet)","NBI 49","Structure Length",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Width:",42,"(feet)","NBI 52","Width Out to Out",null,"Staff Bridge Major Structure Inventory (link)"]
[null,"Span Length:",null,38,"(feet)","NBI 48","Max Span",null,"Staff Bridge Major Structure Inventory (link)"]
[null,"Superstructure:",null,6,null,"NBI 59","Super",null,"Staff Bridge Major Structure Inventory (link)"]
[null,"Substructure:",null,7,null,"NBI 60","Sub",null,"Staff Bridge Major Structure Inventory (link)"]
[null,"Scour Condition:",null,5,null,"NBI 113","Scour Critical",null,"Staff Bridge Major Structure Inventory (link)"]
[null,"Total:","AADT Veh:",8200,"(vehicle)","OTIS","Avg. Annual Daily Traffic (all)",null,"CDOT OTIS Data Search Platform"]
[null,null,"AADT Trck:",2800,"(truck)","OTIS","Avg. Annual Daily Traffic (trucks)",null,"CDOT OTIS Data Search Platform"]
[null,null,"Milepost:",7,null,"OTIS","CDOT Mile Post",null,"CDOT OTIS Data Search Platform"]
[null,null,"Car User:","C2","C4"]
[null,null,"Trck User:","C3","C5"]
[null,null,"Occup:",0]
[null,null,"Slope:","Low"]
[null,null,"Cover:","Shrubs"]
[]
["Step 3:","Owner Consequence"]
[]
[]
[null,{"$f":"INDEX(C104:F108,MATCH(C14,B104:B108,1),MATCH(C1,C103:F103,1))","v":2096600}]
[]
[]
[]
[]
[]
["Step 4:","User Consequence"]
[null,"Full Closure:",null,null,null,null,"Dt:",{"$f":"VLOOKUP(C44,D99:E99,2)","v":189},"mins"]
[null,"Avg Veh:",{"$f":"0.5*D21","v":4100},"Veh Cost:",{"$f":"VLOOKUP(D24,G115:H121,2)","v":0.59},null,"Veh:",{"$f":"VLOOKUP(E24,G115:H121,2)","v":10.62}]
[null,"Avg Trck:",{"$f":"0.5*D22","v":1400},"Trck Cost:",{"$f":"VLOOKUP(D25,G115:H121,2)","v":0.96},null,"Trck:",{"$f":"VLOOKUP(E25,G115:H121,2)","v":25.31}]
[null,"dFC:",{"$f":"SUMPRODUCT((B129:B139=C14)*(C129:C139=C1)*(D129:D139))","v":180},null,null,null,"O:",{"$f":"VLOOKUP(D26,G115:H121,2)","v":1.77}]
[null,"C7:",{"$f":"LOOKUP(2,1/(B99:B99<=D23)/(C99:C99>=D23),D99:D99)","v":146},"VOC.FC:",{"$f":"(E41*C41+E42*C42)*C43*C44","v":98891640},null,"LW.FC:",{"$f":"(H41*H43*C41+H42*C42)*C43*H40/60","v":63789393.779999994}]
[]
[null,null,null,"Total:",{"$f":"E44+H44","v":162681033.78}]
[]
["Step 5:","Vulnerability Assessment"]
[null,"HC Values:",null,"Hydraulic Capacity:",null,50,"years","(based on Exhibit 4.2.2.5?)"]
[null,50,null,"HC:",null,{"$f":"IF(F49=100,\"100-yr\",\"50-yr\")","v":"50-yr"},"HC Index:",{"$f":"MATCH(F50,B156:B195,0)","v":21}]
[null,100,null,"Debris:",null,{"$f":"E150","v":"Moderate"},"D Index:",{"$f":"MATCH(F51,C156:C195,0)","v":9},{"$f":"H50+H51-1","v":29}]
[null,null,null,"Scour:",null,{"$f":"IF(D20<4,\"0to3\",\"4to9\")","v":"4to9"},"Sc Index:",{"$f":"MATCH(F52,D156:D195,0)","v":1},{"$f":"I51+H52-1","v":29}]
[null,null,null,"Span:",null,{"$f":"IF(D17>30,\"> 30 ft\",\"else\")","v":"> 30 ft"},"Sp Index:",{"$f":"MATCH(F53,E156:E195,0)","v":1},{"$f":"I52+H53-1","v":29}]
[null,null,null,"Super:",null,{"$f":"IF(D18<5,\"0to4\",IF(D18<7,\"5to6\",\"7to9\"))","v":"5to6"},"Sup Index:",{"$f":"MATCH(F54,F153:N153,0)","v":4}]
[null,null,null,"Sub:",null,{"$f":"IF(D19<5,\"0to4\",IF(D19<7,\"5to6\",\"7to9\"))","v":"7to9"},"Sub Index:",{"$f":"MATCH(F55,F155:N155,0)","v":1},{"$f":"H54+H55-1","v":4}]
[null,null,null,"100-year magnitude:",null,{"$f":"INDEX(F156:N195,I53,I55)","v":8.9999999999999993E-3}]
[null,null,null,"500-year magnitude:",null,{"$f":"INDEX(T156:AB195,I53,I55)","v":0.13300000000000001}]
[]
[]
["Step 6:","Risk Assessment"]
[]
[null,"Annual Owner Risk:",null,{"$f":"B7","v":100},"year",{"$f":"B33*F56*E7","v":188.69399999999999},null,"Annual User Risk:",null,{"$f":"B7","v":100},"year",{"$f":"E46*F56*E7","v":14641.2930402}]
[null,null,null,{"$f":"B8","v":500},"year",{"$f":"B33*F57*E8","v":557.69560000000001},null,null,null,{"$f":"B8","v":500},"year",{"$f":"E46*F57*E8","v":43273.154985480003}]
[]
[null,"Total Owner Risk:",null,null,null,{"$f":"F62+F63","v":746.38959999999997},null,"Total User Risk:",null,null,null,{"$f":"L62+L63","v":57914.448025680002}]
[]
[null,null,null,null,null,null,null,"Total Annual Risk:",null,null,null,{"$f":"F65+L65","v":58660.837625680004}]
[]
[]
["Please customize the information from the standard below:"]
[]
["Exhibits:",3.6]
[null,null,null,"Annual Threat"]
[null,"Recurrence Interval",null,"Likelihood"]
[null,1,"year",1]
[null,2,"years",{"$f":"1/2","v":0.5}]
[null,5,"years",{"$f":"1/5","v":0.2}]
[null,10,"years",{"$f":"1/10","v":0.1}]
[null,25,"years",{"$f":"1/25","v":0.04}]
[null,50,"years",{"$f":"1/50","v":0.02}]
[null,100,"years",{"$f":"1/100","v":0.01}]
[null,500,"years",{"$f":"1/500","v":2E-3}]
[]
[null,3.8]
[null,null,"Road"]
[null,"Asset","Type","Units","Unit Cost"]
[null,"Approach",null,"sq ft",350]
[null,"Bridge",null,"sq ft",600]
[null,"CBC",null,"cu ft",55]
[null,"PTCS",null,"sq ft",550]
[null,"Roadway","Asphalt","sq yds",150]
[null,"Roadway","Concrete","sq yds",350]
[]
[null,"Unit Cost:",{"$f":"INDEX(E87:E92,MATCH(C14,B87:B92,0))","v":600},"($ / units)"]
[]
[null,3.13,null,"(miles)","(minutes)"]
[null,"Start","End","Added Travel","Added Travel"]
[null,"Milepost","Milepost","Distance (C7)","Time (Dt)"]
[null,1,14,146,189]
[]
[null,3.1]
[null,null,"Threat"]
[null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C110","v":2091600}]
[null,"Bridge",null,{"$f":"C110+5000","v":2096600},{"$f":"C110+5000","v":2096600},{"$f":"IF(D15<100,C110+200000,2500000)","v":2291600}]
[null,"Culvert",{"$f":"C110+5000","v":2096600},{"$f":"C110+5000","v":2096600}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*D16*C94+200000","v":3350000}]
[null,"Roadway",{"$f":"C110+5000","v":2096600},{"$f":"C110+5000","v":2096600},null,{"$f":"100*D16*C94+200000","v":2720000}]
[]
[null,"ARC:",{"$f":"D16*D15*C94","v":2091600}]
[]
[null,3.11]
[null,null,null,null,null,null,null,null,"Year"]
[null,"User Cost Terms",null,null,null,null,"Variable","Value ($)","Published"]
[null,"Average Vehicle Occupancy",null,null,null,null,0,1.77,2019]
[null,"Car Running Cost per Mile",null,null,null,null,"C2",0.59,2019]
[null,"Truck Running Cost per Mile",null,null,null,null,"C3",0.96,2015]
[null,"Average Value of Time per Adult per Hour",null,null,null,null,"C4",10.62,2015]
[null,"Average Value of Freight Driver Cost per Hour",null,null,null,null,"C5",25.31,2015]
[null,"Car Running Cost per Mile",null,null,null,null,"C8",26.52,2015]
[null,"Truck Running Cost per Mile",null,null,null,null,"C9",44.24,2015]
[]
[null,null,null,null,null,null,"A:","<= half road width"]
[null,null,null,null,null,null,"B:","> half road width"]
[null,null,null,null,null,null,"C:","2 directions"]
[null,3.12]
[null,null,null,"Full Closure","Part Closure"]
[null,"Asset","Threat","Days (dFC)","Days (dPC)"]
[null,"Approach","All",2,0]
[null,"Bridge","Flood",180,0]
[null,"Bridge","Debris",2,0]
[null,"Bridge","Rockfall",4,14]
[null,"Culvert","Flood",3,0]
[null,"Culvert","Debris",1,0]
[null,"PTCS","Rockfall",4,14]
[null,"Road A","Flood",1,0]
[null,"Road B","Flood",3,0]
[null,"Road C","Flood",3,0]
[null,"Roadway","Rockfall",4,14]
[]
[null,"4.2.2.8"]
[null,"Site","Landcover"]
[null,"Slopes","Water & Snow","Urban","Shrubs","Trees"]
[null,"Low","Very Low","Low","Moderate","Moderate"]
[null,"Moderate","Very Low","Moderate","High","High"]
[null,"High","Very Low","High","High","Very High"]
[]
[]
[]
[null,"Debris Potential Factor:",null,null,{"$f":"INDEX(C144:F146,MATCH(D27,B144:B146,0),MATCH(D28,C143:F143,0))","v":"Moderate"}]
[]
[null,"4.2.2.9",null,null,null,"Superstructure Condition",null,null,null,null,null,null,null,null,null,"4.2.2.10",null,null,null,"Superstructure Condition"]
[null,null,null,null,null,"7to9","7to9","7to9","5to6","5to6","5to6","0to4","0to4","0to4",null,null,null,null,null,"7to9",null,null,"5to6",null,null,"0to4"]
[null,null,null,null,null,"Substructure Condition",null,null,"Substructure Condition",null,null,"Substructure Condition",null,null,null,null,null,null,null,"Substructure Condition",null,null,"Substructure Condition",null,null,"Substructure Condition"]
[null,"Hydraulic","Debris","Scour","Span","7to9","5to6","0to4","7to9","5to6","0to4","7to9","5to6","0to4",null,"Hydraulic","Debris","Scour","Span","7to9","5to6","0to4","7to9","5to6","0to4","7to9","5to6","0to4"]
[null,"100-yr","Very Low","4to9","> 30 ft",1E-3,3.0000000000000001E-3,1.4999999999999999E-2,2E-3,5.0000000000000001E-3,2.8000000000000001E-2,6.0000000000000001E-3,1.6E-2,8.5000000000000006E-2,1,"100-yr","Very Low","4to9","> 30 ft",1.4999999999999999E-2,3.7999999999999999E-2,0.20599999999999999,2.8000000000000001E-2,7.0999999999999994E-2,0.38600000000000001,8.5000000000000006E-2,0.219,0.5]
[null,"100-yr","Very Low","4to9","else",1E-3,4.0000000000000001E-3,0.02,3.0000000000000001E-3,7.0000000000000001E-3,3.7999999999999999E-2,8.0000000000000002E-3,2.1000000000000001E-2,0.11700000000000001,2,null,null,null,"else",0.02,5.1999999999999998E-2,0.28199999999999997,3.7999999999999999E-2,9.7000000000000003E-2,0.5,0.11700000000000001,0.3,0.5]
[null,"100-yr","Very Low","0to3","> 30 ft",0.20599999999999999,0.5,0.5,0.38600000000000001,0.5,0.5,0.5,0.5,0.5,3,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"100-yr","Very Low","0to3","else",0.28199999999999997,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,4,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"100-yr","Low","4to9","> 30 ft",1E-3,3.0000000000000001E-3,1.7000000000000001E-2,2E-3,6.0000000000000001E-3,3.1E-2,7.0000000000000001E-3,1.7999999999999999E-2,9.7000000000000003E-2,5,null,"Low","4to9","> 30 ft",1.7000000000000001E-2,4.2999999999999997E-2,0.23300000000000001,3.1E-2,0.08,0.437,9.7000000000000003E-2,0.249,0.5]
[null,"100-yr","Low","4to9","else",2E-3,4.0000000000000001E-3,2.3E-2,3.0000000000000001E-3,8.0000000000000002E-3,4.2999999999999997E-2,8.9999999999999993E-3,2.4E-2,0.13300000000000001,6,null,null,null,"else",2.3E-2,5.8999999999999997E-2,0.32,4.2999999999999997E-2,0.11,0.5,0.13300000000000001,0.34,0.5]
[null,"100-yr","Low","0to3","> 30 ft",0.23300000000000001,0.5,0.5,0.437,0.5,0.5,0.5,0.5,0.5,7,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"100-yr","Low","0to3","else",0.32,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,8,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"100-yr","Moderate","4to9","> 30 ft",1E-3,3.0000000000000001E-3,1.9E-2,3.0000000000000001E-3,7.0000000000000001E-3,3.5000000000000003E-2,8.0000000000000002E-3,0.02,0.11,9,null,"Mod","4to9","> 30 ft",1.9E-2,4.9000000000000002E-2,0.26500000000000001,3.5000000000000003E-2,9.0999999999999998E-2,0.496,0.11,0.28199999999999997,0.5]
[null,"100-yr","Moderate","4to9","else",2E-3,5.0000000000000001E-3,2.5999999999999999E-2,3.0000000000000001E-3,8.9999999999999993E-3,4.9000000000000002E-2,1.0999999999999999E-2,2.8000000000000001E-2,0.15,10,null,null,null,"else",2.5999999999999999E-2,6.6000000000000003E-2,0.36199999999999999,4.9000000000000002E-2,0.125,0.5,0.15,0.38600000000000001,0.5]
[null,"100-yr","Moderate","0to3","> 30 ft",0.26500000000000001,0.5,0.5,0.496,0.5,0.5,0.5,0.5,0.5,11,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"100-yr","Moderate","0to3","else",0.36199999999999999,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,12,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"100-yr","High","4to9","> 30 ft",2E-3,4.0000000000000001E-3,2.1000000000000001E-2,3.0000000000000001E-3,7.0000000000000001E-3,0.04,8.9999999999999993E-3,2.3E-2,0.125,13,null,"High","4to9","> 30 ft",2.1000000000000001E-2,5.5E-2,0.3,0.04,0.10299999999999999,0.5,0.125,0.32,0.5]
[null,"100-yr","High","4to9","else",2E-3,5.0000000000000001E-3,2.9000000000000001E-2,4.0000000000000001E-3,0.01,5.5E-2,1.2E-2,3.1E-2,0.17100000000000001,14,null,null,null,"else",2.9000000000000001E-2,7.4999999999999997E-2,0.41099999999999998,5.5E-2,0.14099999999999999,0.5,0.17100000000000001,0.437,0.5]
[null,"100-yr","High","0to3","> 30 ft",0.3,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,15,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"100-yr","High","0to3","else",0.41099999999999998,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,16,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"100-yr","Very High","4to9","> 30 ft",2E-3,5.0000000000000001E-3,2.8000000000000001E-2,4.0000000000000001E-3,8.9999999999999993E-3,5.1999999999999998E-2,1.0999999999999999E-2,2.9000000000000001E-2,0.16,17,null,"Very High","4to9","> 30 ft",2.8000000000000001E-2,7.0999999999999994E-2,0.38600000000000001,5.1999999999999998E-2,0.13300000000000001,0.5,0.16,0.41099999999999998,0.5]
[null,"100-yr","Very High","4to9","else",3.0000000000000001E-3,7.0000000000000001E-3,3.7999999999999999E-2,5.0000000000000001E-3,1.2999999999999999E-2,7.0999999999999994E-2,1.6E-2,0.04,0.219,18,null,null,null,"else",3.7999999999999999E-2,9.7000000000000003E-2,0.5,7.0999999999999994E-2,0.182,0.5,0.219,0.5,0.5]
[null,"100-yr","Very High","0to3","> 30 ft",0.38600000000000001,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,19,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"100-yr","Very High","0to3","else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,20,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","Very Low","4to9","> 30 ft",4.0000000000000001E-3,0.01,5.5E-2,7.0000000000000001E-3,1.9E-2,0.10299999999999999,2.3E-2,5.8999999999999997E-2,0.32,21,"50-yr","Very Low","4to9","> 30 ft",5.5E-2,0.14099999999999999,0.5,0.10299999999999999,0.26500000000000001,0.5,0.32,0.5,0.5]
[null,"50-yr","Very Low","4to9","else",5.0000000000000001E-3,1.4E-2,7.4999999999999997E-2,0.01,2.5999999999999999E-2,0.14099999999999999,3.1E-2,0.08,0.437,22,null,null,null,"else",7.4999999999999997E-2,0.193,0.5,0.14099999999999999,0.36199999999999999,0.5,0.437,0.5,0.5]
[null,"50-yr","Very Low","0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,23,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","Very Low","0to3","else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,24,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","Low","4to9","> 30 ft",4.0000000000000001E-3,1.0999999999999999E-2,6.2E-2,8.0000000000000002E-3,2.1000000000000001E-2,0.11700000000000001,2.5999999999999999E-2,6.6000000000000003E-2,0.36199999999999999,25,null,"Low","4to9","> 30 ft",6.2E-2,0.16,0.5,0.11700000000000001,0.3,0.5,0.36199999999999999,0.5,0.5]
[null,"50-yr","Low","4to9","else",6.0000000000000001E-3,1.6E-2,8.5000000000000006E-2,1.0999999999999999E-2,2.9000000000000001E-2,0.16,3.5000000000000003E-2,9.0999999999999998E-2,0.496,26,null,null,null,"else",8.5000000000000006E-2,0.219,0.5,0.16,0.41099999999999998,0.5,0.496,0.5,0.5]
[null,"50-yr","Low","0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,27,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","Low","0to3","else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,28,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","Moderate","4to9","> 30 ft",5.0000000000000001E-3,1.2999999999999999E-2,7.0999999999999994E-2,8.9999999999999993E-3,2.4E-2,0.13300000000000001,2.9000000000000001E-2,7.4999999999999997E-2,0.41099999999999998,29,null,"Mod","4to9","> 30 ft",7.0999999999999994E-2,0.182,0.5,0.13300000000000001,0.34,0.5,0.41099999999999998,0.5,0.5]
[null,"50-yr","Moderate","4to9","else",7.0000000000000001E-3,1.7999999999999999E-2,9.7000000000000003E-2,1.2999999999999999E-2,3.3000000000000002E-2,0.182,0.04,0.10299999999999999,0.5,30,null,null,null,"else",9.7000000000000003E-2,0.249,0.5,0.182,0.46600000000000003,0.5,0.5,0.5,0.5]
[null,"50-yr","Moderate","0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,31,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","Moderate","0to3","else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,32,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","High","4to9","> 30 ft",6.0000000000000001E-3,1.4999999999999999E-2,0.08,1.0999999999999999E-2,2.8000000000000001E-2,0.15,3.3000000000000002E-2,8.5000000000000006E-2,0.46600000000000003,33,null,"High","4to9","> 30 ft",0.08,0.20599999999999999,0.5,0.15,0.38600000000000001,0.5,0.46600000000000003,0.5,0.5]
[null,"50-yr","High","4to9","else",8.0000000000000002E-3,0.02,0.11,1.4999999999999999E-2,3.7999999999999999E-2,0.20599999999999999,4.5999999999999999E-2,0.11700000000000001,0.5,34,null,null,null,"else",0.11,0.28199999999999997,0.5,0.20599999999999999,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","High","0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,35,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","High","0to3","else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,36,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","Very High","4to9","> 30 ft",7.0000000000000001E-3,1.9E-2,0.10299999999999999,1.4E-2,3.5000000000000003E-2,0.193,4.2999999999999997E-2,0.11,0.5,37,null,"Very High","4to9","> 30 ft",0.10299999999999999,0.26500000000000001,0.5,0.193,0.496,0.5,0.5,0.5,0.5]
[null,"50-yr","Very High","4to9","else",0.01,2.5999999999999999E-2,0.14099999999999999,1.9E-2,4.9000000000000002E-2,0.26500000000000001,0.59,0.15,0.5,38,null,null,null,"else",0.14099999999999999,0.36199999999999999,0.5,0.26500000000000001,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","Very High","0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,39,null,null,"0to3","> 30 ft",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"50-yr","Very High","0to3","else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,40,null,null,null,"else",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]

{"sheet":"Flood-Bridge Approach","index":6,"n_rows":196,"n_cols":31,"rows_kept":196,"cut":false,"hidden":false,"merged":[[170,5,170,9],[170,15,170,19],[5,1,5,2],[5,3,5,4],[132,1,132,5],[80,3,80,4],[110,2,110,5],[81,1,81,2],[81,3,81,4],[118,2,118,5]]}
["Problem:",null,"Flood"]
[]
[]
["Step 1:","Threat Data Collection"]
[]
[null,"Recurrence Interval",null,"Annual Threat Likelihood"]
[null,100,"years",null,{"$f":"VLOOKUP(B7,B83:D90,3,FALSE)","v":0.01}]
[null,500,"years",null,{"$f":"VLOOKUP(B8,B83:D90,3,FALSE)","v":2E-3}]
[]
[]
[]
[]
["Step 2:","Asset Data Collection"]
["Site Overview:",null,"Approach",null,null,"CODE","Item Description",null,null,"CDOT Link"]
[null,"East","Length:",20,"(feet)",null,"Default 20 ft"]
[null,null,"Width:",38,"(feet)","NBI 51","Width Curb to Curb",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Slope Prot:","Riprap",null,"Element 9326/1","Type of Slope Protection",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Slope Cond:","State 2",null,"Element 9325/1","Slope Protection Condition",null,"Staff Bridge Major Structure Inventory (link)"]
[null,{"$f":"IF(B15=\"East\",\"West\",IF(B15=\"North\",\"South\",IF(B15=\"West\",\"East\",IF(B15=\"South\",\"North\",\"West\"))))","v":"West"},"Length:",20,"(feet)",null,"Default 20 ft"]
[null,null,"Width:",38,"(feet)","NBI 51","Width Curb to Curb",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Slope Prot:","Riprap",null,"Element 9326/1","Type of Slope Protection",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Slope Cond:","State 1",null,"Element 9325/1","Slope Protection Condition",null,"Staff Bridge Major Structure Inventory (link)"]
[null,"Total:","AADT Veh:",8200,"(vehicle)"]
[null,null,"AADT Trck:",2800,"(truck)"]
[null,null,"Milepost:",7]
[null,null,"Car User:","C2","C4"]
[null,null,"Trck User:","C3","C5"]
[null,null,"Occup:",0]
[null,null,"Slope:","Low"]
[null,null,"Cover:","Shrubs"]
[]
["Step 3:","Owner Consequence"]
[]
[]
[null,null,{"$f":"INDEX(C113:F117,MATCH(C14,B113:B117,1),MATCH(C1,C112:F112,1))","v":266000},{"$f":"B15","v":"East"}]
[null,null,{"$f":"INDEX(C121:F125,MATCH(C14,B121:B125,1),MATCH(C1,C120:F120,1))","v":266000},{"$f":"B19","v":"West"}]
[]
[]
[]
[]
["Step 4:","User Consequence"]
[null,"Full Closure:",null,null,null,null,"Dt:",{"$f":"VLOOKUP(C46,D108:E108,2)","v":189},"mins"]
[null,"Avg Veh:",{"$f":"0.5*D23","v":4100},"Veh Cost:",{"$f":"VLOOKUP(D26,G134:H140,2)","v":0.59},null,"Veh:",{"$f":"VLOOKUP(E26,G134:H140,2)","v":10.62}]
[null,"Avg Trck:",{"$f":"0.5*D24","v":1400},"Trck Cost:",{"$f":"VLOOKUP(D27,G134:H140,2)","v":0.96},null,"Trck:",{"$f":"VLOOKUP(E27,G134:H140,2)","v":25.31}]
[null,"dFC:",{"$f":"SUMPRODUCT((B148:B158=C14)*(D148:D158))","v":2},null,null,null,"O:",{"$f":"VLOOKUP(D28,G134:H140,2)","v":1.77}]
[null,"C7:",{"$f":"LOOKUP(2,1/(B108:B108<=D25)/(C108:C108>=D25),D108:D108)","v":146},"VOC.FC:",{"$f":"(E43*C43+E44*C44)*C45*C46","v":1098796},null,"LW.FC:",{"$f":"(H43*H45*C43+H44*C44)*C45*H42/60","v":708771.0419999999}]
[]
[null,null,null,"Total:",{"$f":"E46+H46","v":1807567.0419999999},null,"Per Approach:",{"$f":"E48/2","v":903783.52099999995}]
[]
["Step 5:","Vulnerability Assessment"]
[]
[null,"HC Values:",null,"Hydraulic Capacity:",null,50,"years","(based on Exhibit 4.2.3.4?)"]
[null,50,null,"HC:",null,{"$f":"IF(F52=100,\"100-yr\",\"50-yr\")","v":"50-yr"},"HC Index:",{"$f":"MATCH(F53,C173:C196,0)","v":13}]
[null,100,null,"Slope Prot,",{"$f":"B15","v":"East"},{"$f":"D17","v":"Riprap"},"SP Index:",{"$f":"MATCH(F54,D173:D196,0)","v":7},{"$f":"H53+H54-1","v":19}]
[null,null,null,"Slope Cond,",{"$f":"B15","v":"East"},{"$f":"D18","v":"State 2"},"SC Index:",{"$f":"MATCH(F55,E173:E196,0)","v":2},{"$f":"I54+H55-1","v":20}]
[null,null,null,"Debris:",null,{"$f":"E169","v":"Moderate"},"Deb Index:",{"$f":"MATCH(F56,F172:J172,0)","v":3}]
[null,null,null,"Slope Prot,",{"$f":"B19","v":"West"},{"$f":"D21","v":"Riprap"},"SP Index:",{"$f":"MATCH(F57,D173:D196,0)","v":7},{"$f":"H53+H57-1","v":19}]
[null,null,null,"Slope Cond,",{"$f":"B19","v":"West"},{"$f":"D22","v":"State 1"},"SC Index:",{"$f":"MATCH(F58,E173:E196,0)","v":1},{"$f":"I57+H58-1","v":19}]
[null,null,null,"100-year mag,",{"$f":"B15","v":"East"},{"$f":"INDEX(F173:J196,I55,H56)","v":0.26979999999999998}]
[null,null,null,"100-year mag,",{"$f":"B19","v":"West"},{"$f":"INDEX(F173:J196,I58,H56)","v":0.14799999999999999}]
[null,null,null,"500-year mag,",{"$f":"B15","v":"East"},{"$f":"INDEX(P173:T196,I55,H56)","v":0.99}]
[null,null,null,"500-year mag,",{"$f":"B19","v":"West"},{"$f":"INDEX(O110:S133,I58,H56)","v":0}]
[]
["Step 6:","Risk Assessment"]
[]
[null,"Annual Owner Risk:",null,"100-year",{"$f":"B15","v":"East"},{"$f":"C35*F59*E7","v":717.66800000000001},null,"Annual User Risk:",null,"100-year",{"$f":"B15","v":"East"},{"$f":"H48*F59*E7","v":2438.4079396579996}]
[null,null,null,null,{"$f":"B19","v":"West"},{"$f":"C36*F60*E7","v":393.68},null,null,null,null,{"$f":"B19","v":"West"},{"$f":"H48*F60*E7","v":1337.5996110799999}]
[]
[null,null,null,"500-year",{"$f":"B15","v":"East"},{"$f":"C35*F61*E8","v":526.68000000000006},null,null,null,"500-year",{"$f":"B15","v":"East"},{"$f":"H48*F61*E8","v":1789.4913715799998}]
[null,null,null,null,{"$f":"B19","v":"West"},{"$f":"C36*F62*E8","v":0},null,null,null,null,{"$f":"B19","v":"West"},{"$f":"H48*F62*E8","v":0}]
[]
[null,"Total Owner Risk:",null,null,null,{"$f":"SUM(F66:F70)","v":1638.028},null,"Total User Risk:",null,null,null,{"$f":"SUM(L66:L70)","v":5565.498922318}]
[]
[null,null,null,null,null,null,null,"Total Annual Risk:",null,null,null,{"$f":"F72+L72","v":7203.5269223180003}]
[]
[]
[]
["Please customize the information from the standard below:"]
[]
["Exhibits:",3.6]
[null,null,null,"Annual Threat"]
[null,"Recurrence Interval",null,"Likelihood"]
[null,1,"year",1]
[null,2,"years",{"$f":"1/2","v":0.5}]
[null,5,"years",{"$f":"1/5","v":0.2}]
[null,10,"years",{"$f":"1/10","v":0.1}]
[null,25,"years",{"$f":"1/25","v":0.04}]
[null,50,"years",{"$f":"1/50","v":0.02}]
[null,100,"years",{"$f":"1/100","v":0.01}]
[null,500,"years",{"$f":"1/500","v":2E-3}]
[]
[null,3.8]
[null,null,"Road"]
[null,"Asset","Type","Units","Unit Cost"]
[null,"Approach",null,"sq ft",350]
[null,"Bridge",null,"sq ft",600]
[null,"CBC",null,"cu ft",55]
[null,"PTCS",null,"sq ft",550]
[null,"Roadway","Asphalt","sq yds",150]
[null,"Roadway","Concrete","sq yds",350]
[]
[null,"Unit Cost:",{"$f":"INDEX(E95:E100,MATCH(C14,B95:B100,0))","v":350},"($ / units)"]
[]
[]
[null,3.13,null,"(miles)","(minutes)"]
[null,"Start","End","Added Travel","Added Travel"]
[null,"Milepost","Milepost","Distance (C7)","Time (Dt)"]
[null,1,14,146,189]
[]
[null,3.1]
[null,null,"Threat"]
[null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C127","v":266000},null,null,{"$f":"B15","v":"East"}]
[null,"Bridge",null,{"$f":"C127+5000","v":271000},{"$f":"C127+5000","v":271000},{"$f":"IF(D15<100,C127+200000,2500000)","v":466000}]
[null,"Culvert",{"$f":"C127+5000","v":271000},{"$f":"C127+5000","v":271000}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*D16*C102+200000","v":1862500}]
[null,"Roadway",{"$f":"C127+5000","v":271000},{"$f":"C127+5000","v":271000},null,{"$f":"100*D16*C102+200000","v":1530000}]
[]
[null,null,"Threat"]
[null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C128","v":266000},null,null,{"$f":"B19","v":"West"}]
[null,"Bridge",null,{"$f":"C128+5000","v":271000},{"$f":"C128+5000","v":271000},{"$f":"IF(D15<100,C128+200000,2500000)","v":466000}]
[null,"Culvert",{"$f":"C128+5000","v":271000},{"$f":"C128+5000","v":271000}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*D20*C102+200000","v":1862500}]
[null,"Roadway",{"$f":"C128+5000","v":271000},{"$f":"C128+5000","v":271000},null,{"$f":"100*D20*C102+200000","v":1530000}]
[]
[null,"ARC:",{"$f":"D16*D15*C102","v":266000},"for the:",{"$f":"B15","v":"East"},"approach"]
[null,null,{"$f":"D20*D19*C102","v":266000},"for the:",{"$f":"B19","v":"West"},"approach"]
[null,null,{"$f":"C127+C128","v":532000},"total"]
[]
[null,3.11]
[null,null,null,null,null,null,null,null,"Year"]
[null,"User Cost Terms",null,null,null,null,"Variable","Value ($)","Published"]
[null,"Average Vehicle Occupancy",null,null,null,null,0,1.77,2019]
[null,"Car Running Cost per Mile",null,null,null,null,"C2",0.59,2019]
[null,"Truck Running Cost per Mile",null,null,null,null,"C3",0.96,2015]
[null,"Average Value of Time per Adult per Hour",null,null,null,null,"C4",10.62,2015]
[null,"Average Value of Freight Driver Cost per Hour",null,null,null,null,"C5",25.31,2015]
[null,"Car Running Cost per Mile",null,null,null,null,"C8",26.52,2015]
[null,"Truck Running Cost per Mile",null,null,null,null,"C9",44.24,2015]
[]
[null,null,null,null,null,null,"A:","<= half road width"]
[null,null,null,null,null,null,"B:","> half road width"]
[null,null,null,null,null,null,"C:","2 directions"]
[null,3.12]
[null,null,null,"Full Closure","Part Closure"]
[null,"Asset","Threat","Days (dFC)","Days (dPC)"]
[null,"Approach","All",2,0]
[null,"Bridge","Flood",180,0]
[null,"Bridge","Debris",2,0]
[null,"Bridge","Rockfall",4,14]
[null,"Culvert","Flood",3,0]
[null,"Culvert","Debris",1,0]
[null,"PTCS","Rockfall",4,14]
[null,"Road A","Flood",1,0]
[null,"Road B","Flood",3,0]
[null,"Road C","Flood",3,0]
[null,"Roadway","Rockfall",4,14]
[]
[null,"4.2.2.8"]
[null,"Site","Landcover"]
[null,"Slopes","Water & Snow","Urban","Shrubs","Trees"]
[null,"Low","Very Low","Low","Moderate","Moderate"]
[null,"Moderate","Very Low","Moderate","High","High"]
[null,"High","Very Low","High","High","Very High"]
[]
[]
[]
[null,"Debris Potential Factor:",null,null,{"$f":"INDEX(C163:F165,MATCH(D29,B163:B165,0),MATCH(D30,C162:F162,0))","v":"Moderate"}]
[]
[null,null,"4.2.3.15",null,null,"Debris Potential",null,null,null,null,null,null,null,null,null,"Debris Potential"]
[null,"100-yr","Hydraulic","Slope Prot","Slope Cn","Very Low","Low","Moderate","High","Very High","Index","500-yr","Hydraulic","Slope Prot","Slope Cn","Very Low","Low","Moderate","High","Very High"]
[null,null,"100-yr","Both","State 1",8.0000000000000004E-4,1.1000000000000001E-3,3.5999999999999999E-3,1.21E-2,2.2100000000000002E-2,1,null,"100-yr","Both","State 1",2.2100000000000002E-2,2.98E-2,9.9199999999999997E-2,0.3296,0.60099999999999998]
[null,null,"100-yr","Both","State 2",1.5E-3,2E-3,6.6E-3,2.2100000000000002E-2,4.0300000000000002E-2,2,null,"100-yr","Both","State 2",4.0300000000000002E-2,5.4399999999999997E-2,0.18079999999999999,0.60099999999999998,0.99]
[null,null,"100-yr","Both","State 3",4.0000000000000001E-3,5.4000000000000003E-3,1.8100000000000002E-2,6.0100000000000001E-2,0.1096,3,null,"100-yr","Both","State 3",0.1096,0.14799999999999999,0.4919,0.99,0.99]
[null,null,"100-yr","Wingwalls","State 1",8.9999999999999998E-4,1.1999999999999999E-3,4.0000000000000001E-3,1.34E-2,2.4400000000000002E-2,4,null,"100-yr","Wingwalls","State 1",2.4400000000000002E-2,3.3000000000000002E-2,0.1096,0.36430000000000001,0.6643]
[null,null,"100-yr","Wingwalls","State 2",1.6000000000000001E-3,2.2000000000000001E-3,7.3000000000000001E-3,2.4400000000000002E-2,4.4499999999999998E-2,5,null,"100-yr","Wingwalls","State 2",4.4499999999999998E-2,6.0100000000000001E-2,0.19980000000000001,0.6643,0.99]
[null,null,"100-yr","Wingwalls","State 3",4.4999999999999997E-3,6.0000000000000001E-3,0.02,6.6400000000000001E-2,0.1211,6,null,"100-yr","Wingwalls","State 3",0.1211,0.1636,0.54369999999999996,0.99,0.99]
[null,null,"100-yr","Riprap","State 1",1E-3,1.2999999999999999E-3,4.4999999999999997E-3,1.4800000000000001E-2,2.7E-2,7,null,"100-yr","Riprap","State 1",2.7E-2,3.6400000000000002E-2,0.1211,0.4027,0.73419999999999996]
[null,null,"100-yr","Riprap","State 2",1.8E-3,2.3999999999999998E-3,8.0999999999999996E-3,2.7E-2,4.9200000000000001E-2,8,null,"100-yr","Riprap","State 2",4.9200000000000001E-2,6.6400000000000001E-2,0.22090000000000001,0.73419999999999996,0.99]
[null,null,"100-yr","Riprap","State 3",4.8999999999999998E-3,6.6E-3,2.2100000000000002E-2,7.3400000000000007E-2,0.13389999999999999,9,null,"100-yr","Riprap","State 3",0.13389999999999999,0.18079999999999999,0.60099999999999998,0.99,0.99]
[null,null,"100-yr","None","State 1",4.4999999999999997E-3,6.0000000000000001E-3,0.02,6.6400000000000001E-2,0.1211,10,null,"100-yr","None","State 1",0.1211,0.1636,0.54369999999999996,0.99,0.99,null,null,null,null,"Approach Directions:",null,null,"Slope Protection Type:",null,null,"Slope Condition:"]
[null,null,"100-yr","None","State 2",8.0999999999999996E-3,1.0999999999999999E-2,3.6400000000000002E-2,0.1211,0.22090000000000001,11,null,"100-yr","None","State 2",0.22090000000000001,0.29820000000000002,0.99,0.99,0.99,null,null,null,null,"East",null,null,"None",null,null,"State 1"]
[null,null,"100-yr","None","State 3",2.2100000000000002E-2,2.98E-2,9.9199999999999997E-2,0.3296,0.60099999999999998,12,null,"100-yr","None","State 3",0.60099999999999998,0.8115,0.99,0.99,0.99,null,null,null,null,"West",null,null,"Riprap",null,null,"State 2"]
[null,null,"50-yr","Both","State 1",2.7E-2,3.6400000000000002E-2,0.1211,0.4027,0.73419999999999996,13,null,"50-yr","Both","State 1",0.73419999999999996,0.99,0.99,0.99,0.99,null,null,null,null,"North",null,null,"Wingwalls",null,null,"State 3"]
[null,null,"50-yr","Both","State 2",4.9200000000000001E-2,6.6400000000000001E-2,0.22090000000000001,0.73419999999999996,0.99,14,null,"50-yr","Both","State 2",0.99,0.99,0.99,0.99,0.99,null,null,null,null,"South",null,null,"Both"]
[null,null,"50-yr","Both","State 3",0.13389999999999999,0.18079999999999999,0.60099999999999998,0.99,0.99,15,null,"50-yr","Both","State 3",0.99,0.99,0.99,0.99,0.99]
[null,null,"50-yr","Wingwalls","State 1",2.98E-2,4.0300000000000002E-2,0.13389999999999999,0.4451,0.8115,16,null,"50-yr","Wingwalls","State 1",0.8115,0.99,0.99,0.99,0.99]
[null,null,"50-yr","Wingwalls","State 2",5.4399999999999997E-2,7.3400000000000007E-2,0.24410000000000001,0.8115,0.99,17,null,"50-yr","Wingwalls","State 2",0.99,0.99,0.99,0.99,0.99]
[null,null,"50-yr","Wingwalls","State 3",0.14799999999999999,0.19980000000000001,0.6643,0.99,0.99,18,null,"50-yr","Wingwalls","State 3",0.99,0.99,0.99,0.99,0.99]
[null,null,"50-yr","Riprap","State 1",3.3000000000000002E-2,4.4499999999999998E-2,0.14799999999999999,0.4919,0.89690000000000003,19,null,"50-yr","Riprap","State 1",0.89690000000000003,0.99,0.99,0.99,0.99]
[null,null,"50-yr","Riprap","State 2",6.0100000000000001E-2,8.1199999999999994E-2,0.26979999999999998,0.89690000000000003,0.99,20,null,"50-yr","Riprap","State 2",0.99,0.99,0.99,0.99,0.99]
[null,null,"50-yr","Riprap","State 3",0.1636,0.22090000000000001,0.73419999999999996,0.99,0.99,21,null,"50-yr","Riprap","State 3",0.99,0.99,0.99,0.99,0.99]
[null,null,"50-yr","None","State 1",0.14799999999999999,0.19980000000000001,0.6643,0.99,0.99,22,null,"50-yr","None","State 1",0.99,0.99,0.99,0.99,0.99]
[null,null,"50-yr","None","State 2",0.26979999999999998,0.36430000000000001,0.99,0.99,0.99,23,null,"50-yr","None","State 2",0.99,0.99,0.99,0.99,0.99]
[null,null,"50-yr","None","State 3",0.73419999999999996,0.99,0.99,0.99,0.99,24,null,"50-yr","None","State 3",0.99,0.99,0.99,0.99,0.99]

{"sheet":"Flood-Minor Culvert","index":7,"n_rows":190,"n_cols":13,"rows_kept":190,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,4]]}
["Problem:",null,"Flood"]
[]
[]
["Step 1:","Threat Data Collection"]
[]
[null,"Recurrence Interval",null,"Annual Threat Likelihood"]
[null,{"$f":"B131","v":"25-year"},null,null,{"$f":"IF(D135=\"yes\",D86,0)","v":0.04}]
[null,{"$f":"B132","v":"50-year"},null,null,{"$f":"IF(D136=\"yes\",D87,0)","v":0.02}]
[null,{"$f":"B133","v":"100-year"},null,null,{"$f":"IF(D137=\"yes\",D88,0)","v":0.01}]
[]
[]
[]
["Step 2:","Asset Data Collection"]
["Site Overview:",null,"Culvert"]
[null,"East","Type:","CMPE"]
[null,null,"Diameter:",60,"(inches)"]
[null,null,"Length:",78,"(feet)"]
[null,null,"Condition:","Fair"]
[null,"Peak Flow:","Design:",200,"(cfs)"]
[null,null,"25-year:",225,"(cfs)"]
[null,null,"50-year:",300,"(cfs)"]
[null,null,"100-year:",500,"(cfs)"]
[null,"Total:","AADT Veh:",20928,"(vehicle)","OTIS","Avg. Annual Daily Traffic (all)",null,"CDOT OTIS Data Search Platform"]
[null,null,"AADT Trck:",3072,"(truck)","OTIS","Avg. Annual Daily Traffic (trucks)",null,"CDOT OTIS Data Search Platform"]
[null,null,"Milepost:",11,null,"OTIS","CDOT Mile Post",null,"CDOT OTIS Data Search Platform"]
[null,null,"Car User:","C2","C4"]
[null,null,"Trck User:","C3","C5"]
[null,null,"Occup:",0]
[null,"Site:","Slope:","Low"]
[null,null,"Cover:","Shrubs"]
[]
["Step 3:","Owner Consequence"]
[]
[]
[null,null,{"$f":"INDEX(C142:F146,MATCH(C14,B142:B146,1),MATCH(C1,C141:F141,1))","v":249530},{"$f":"B15","v":"East"}]
[]
[]
[]
[]
[]
["Step 4:","User Consequence"]
[null,"Full Closure:",null,null,null,null,"Dt:",{"$f":"INDEX(E127:E127,MATCH(C46,D127:D127,0))","v":189},"mins"]
[null,"Avg Veh:",{"$f":"0.5*D23","v":10464},"Veh Cost:",{"$f":"VLOOKUP(D26,G153:H159,2)","v":0.59},null,"Veh:",{"$f":"VLOOKUP(E26,G153:H159,2)","v":10.62}]
[null,"Avg Trck:",{"$f":"0.5*D24","v":1536},"Trck Cost:",{"$f":"VLOOKUP(D27,G153:H159,2)","v":0.96},null,"Trck:",{"$f":"VLOOKUP(E27,G153:H159,2)","v":25.31}]
[null,"dFC:",{"$f":"SUMPRODUCT((B167:B177=C14)*(C167:C177=C1)*(D167:D177))","v":3},null,null,null,"O:",{"$f":"VLOOKUP(D28,G153:H159,2)","v":1.77}]
[null,"C7:",{"$f":"LOOKUP(2,1/(B127:B127<=D25)/(C127:C127>=D25),D127:D127)","v":146},"VOC.FC:",{"$f":"(E43*C43+E44*C44)*C45*C46","v":3349964.1599999997},null,"LW.FC:",{"$f":"(H43*H45*C43+H44*C44)*C45*H42/60","v":2226156.85152}]
[]
[null,null,null,"Total:",{"$f":"E46+H46","v":5576121.0115200002}]
[]
["Step 5:","Vulnerability Assessment"]
[]
[null,"Qe / Qd",{"$f":"B131","v":"25-year"},{"$f":"IF(D135=\"yes\",E131,0)","v":1.125}]
[null,null,{"$f":"B132","v":"50-year"},{"$f":"IF(D136=\"yes\",E132,0)","v":1.5}]
[null,null,{"$f":"B133","v":"100-year"},{"$f":"IF(D137=\"yes\",E133,0)","v":2.5}]
[null,"Qe / Qd val",{"$f":"B131","v":"25-year"},{"$f":"IF(D52<=2,\"1to2\",IF(D52<=3,\"2.1to3\",IF(D52<=4,\"3.1to4\",\"gt4\")))","v":"1to2"},"Qe / Qd Ind",{"$f":"MATCH(D55,B111:B122,0)","v":1}]
[null,null,{"$f":"B132","v":"50-year"},{"$f":"IF(D53<=2,\"1to2\",IF(D53<=3,\"2.1to3\",IF(D53<=4,\"3.1to4\",\"gt4\")))","v":"1to2"},null,{"$f":"MATCH(D56,B111:B122,0)","v":1}]
[null,null,{"$f":"B133","v":"100-year"},"2.1to3",null,{"$f":"MATCH(D57,B111:B122,0)","v":4}]
[null,"Culvert Condition:",null,{"$f":"D18","v":"Fair"},"Cond Ind",{"$f":"MATCH(D58,C111:C113,0)","v":2}]
[null,"Vulnerable",{"$f":"B131","v":"25-year"},{"$f":"INDEX(D111:H122,F59,F62)","v":0.12},"Vuln Index",{"$f":"F55+F58-1","v":2}]
[null,null,{"$f":"B132","v":"50-year"},{"$f":"INDEX(D111:H122,F60,F62)","v":0.12},null,{"$f":"F56+F58-1","v":2}]
[null,null,{"$f":"B133","v":"100-year"},{"$f":"INDEX(D111:H122,F61,F62)","v":0.18},null,{"$f":"F57+F58-1","v":5}]
[null,null,null,null,"Debris Ind",{"$f":"MATCH(E188,D110:H110,0)","v":3}]
[]
["Step 6:","Risk Assessment"]
[]
[null,"Annual Owner Risk:",null,{"$f":"B131","v":"25-year"},{"$f":"C35*D59*E7","v":1197.7439999999999},null,"Annual User Risk:",null,{"$f":"B131","v":"25-year"},{"$f":"E48*D59*E7","v":26765.380855296}]
[null,null,null,{"$f":"B132","v":"50-year"},{"$f":"C35*D60*E8","v":598.87199999999996},null,null,null,{"$f":"B132","v":"50-year"},{"$f":"E48*D60*E8","v":13382.690427648}]
[null,null,null,{"$f":"B133","v":"100-year"},{"$f":"C35*D61*E9","v":449.154},null,null,null,{"$f":"B133","v":"100-year"},{"$f":"E48*D61*E9","v":10037.017820736}]
[]
[null,"Total Owner Risk:",null,null,{"$f":"SUM(E66:E68)","v":2245.77},null,"Total User Risk:",null,null,{"$f":"SUM(J66:J68)","v":50185.089103680002}]
[]
[null,null,null,null,null,null,"Total Annual Risk:",null,null,{"$f":"E70+J70","v":52430.859103679999}]
[]
[]
[]
[]
["Please customize the information from the standard below:"]
[]
["Exhibits:",3.6]
[null,null,null,"Annual Threat"]
[null,"Recurrence Interval",null,"Likelihood"]
[null,1,"year",1]
[null,2,"years",{"$f":"1/2","v":0.5}]
[null,5,"years",{"$f":"1/5","v":0.2}]
[null,10,"years",{"$f":"1/10","v":0.1}]
[null,25,"years",{"$f":"1/25","v":0.04}]
[null,50,"years",{"$f":"1/50","v":0.02}]
[null,100,"years",{"$f":"1/100","v":0.01}]
[null,500,"years",{"$f":"1/500","v":2E-3}]
[]
[null,3.8]
[null,null,"Road",null,null,null,"Pipe","Unit Cost"]
[null,"Asset","Type","Units","Unit Cost",null,"Diam (in)","($ / lin ft)"]
[null,"Approach",null,"sq ft",350,null,"<48",2205]
[null,"Bridge",null,"sq ft",600,null,48,2225]
[null,"Culvert",null,"lin ft",{"$f":"IF(D16<48,H94,VLOOKUP(D16,G95:H107,2))","v":3135},null,54,2660]
[null,"CBC",null,"cu ft",55,null,60,3135]
[null,"PTCS",null,"sq ft",550,null,66,3660]
[null,"Roadway","Asphalt","sq yds",150,null,72,4235]
[null,"Roadway","Concrete","sq yds",350,null,78,4865]
[null,null,null,null,null,null,84,5550]
[null,"Unit Cost:",{"$f":"INDEX(E94:E100,MATCH(C14,B94:B100,0))","v":3135},"($ / units)",null,null,90,10325]
[null,null,null,null,null,null,96,11690]
[null,null,null,null,null,null,102,13160]
[null,null,null,null,null,null,108,14770]
[null,null,null,null,null,null,120,18325]
[null,null,null,null,null,null,138,24695]
[]
[null,"4.2.3.16",null,"Debris Potential"]
[null,"Qe / Qd","Culvert Cnd","Very Low","Low","Moderate","High","Very High","Index",null,null,null,"0-5 poor"]
[null,"1to2","Good",0.05,0.06,0.08,0.13,0.3,1,null,null,null,"6-7 fair"]
[null,"1to2","Fair",7.0000000000000007E-2,0.08,0.12,0.18,0.42,2,null,null,null,"8-9 good"]
[null,"1to2","Poor",0.25,0.3,0.42,0.64,0.99,3]
[null,"2.1to3","Good",0.08,0.09,0.13,0.2,0.47,4]
[null,"2.1to3","Fair",0.1,0.13,0.18,0.27,0.64,5]
[null,"2.1to3","Poor",0.38,0.47,0.64,0.99,0.99,6]
[null,"3.1to4","Good",0.18,0.22,0.3,0.47,0.99,7]
[null,"3.1to4","Fair",0.25,0.3,0.42,0.64,0.99,8]
[null,"3.1to4","Poor",0.89,0.99,0.99,0.99,0.99,9]
[null,"gt4","Good",0.64,0.8,0.99,0.99,0.99,10]
[null,"gt4","Fair",0.89,0.99,0.99,0.99,0.99,11]
[null,"gt4","Poor",0.99,0.99,0.99,0.99,0.99,12]
[]
[null,3.13,null,"(miles)","(minutes)"]
[null,"Start","End","Added Travel","Added Travel"]
[null,"Milepost","Milepost","Distance (C7)","Time (Dt)"]
[null,1,14,146,189]
[]
[null,"Rainfall","Qevent","Qdesign",null,null,"Approach Directions:",null,"Culvert Types:",null,null,null,"Culvert Conditions:"]
[null,"Event","(cfs)","(cfs)","Qe / Qd",null,"East",null,"Corrugated Metal Pipe",null,null,"CMP","Good"]
[null,"25-year",{"$f":"D20","v":225},{"$f":"D19","v":200},{"$f":"C131/D131","v":1.125},null,"West",null,"Corrugated Metal Pipe Ellipse",null,null,"CMPE","Fair"]
[null,"50-year",{"$f":"D21","v":300},{"$f":"D19","v":200},{"$f":"C132/D132","v":1.5},null,"North",null,"Reinforced Concrete Box",null,null,"RCB","Poor"]
[null,"100-year",{"$f":"D22","v":500},{"$f":"D19","v":200},2.5,null,"South",null,"Reinforced Concrete Pipe",null,null,"RCP"]
[null,null,null,null,null,null,null,null,"Reinforced Concrete Pipe Ellipse",null,null,"RCPE"]
[null,"Events","25-year:",{"$f":"IF(E131>1,\"yes\",\"no\")","v":"yes"}]
[null,"Used:","50-year:",{"$f":"IF(E132>1,\"yes\",\"no\")","v":"yes"}]
[null,null,"100-year:","yes"]
[]
[null,3.1]
[null,null,"Threat"]
[null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C148","v":244530}]
[null,"Bridge",null,{"$f":"C148+5000","v":249530},{"$f":"C148+5000","v":249530},{"$f":"IF(D15<100,C148+200000,2500000)","v":2500000}]
[null,"Culvert",{"$f":"C148+5000","v":249530},{"$f":"C148+5000","v":249530}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*D16*C102+200000","v":23712500}]
[null,"Roadway",{"$f":"C148+5000","v":249530},{"$f":"C148+5000","v":249530},null,{"$f":"100*D16*C102+200000","v":19010000}]
[]
[null,"ARC:",{"$f":"C102*D17","v":244530},"for the:",{"$f":"B15","v":"East"},{"$f":"C14","v":"Culvert"}]
[]
[null,3.11]
[null,null,null,null,null,null,null,null,"Year"]
[null,"User Cost Terms",null,null,null,null,"Variable","Value ($)","Published"]
[null,"Average Vehicle Occupancy",null,null,null,null,0,1.77,2019]
[null,"Car Running Cost per Mile",null,null,null,null,"C2",0.59,2019]
[null,"Truck Running Cost per Mile",null,null,null,null,"C3",0.96,2015]
[null,"Average Value of Time per Adult per Hour",null,null,null,null,"C4",10.62,2015]
[null,"Average Value of Freight Driver Cost per Hour",null,null,null,null,"C5",25.31,2015]
[null,"Car Running Cost per Mile",null,null,null,null,"C8",26.52,2015]
[null,"Truck Running Cost per Mile",null,null,null,null,"C9",44.24,2015]
[]
[null,null,null,null,null,null,"A:","<= half road width"]
[null,null,null,null,null,null,"B:","> half road width"]
[null,null,null,null,null,null,"C:","2 directions"]
[null,3.12]
[null,null,null,"Full Closure","Part Closure"]
[null,"Asset","Threat","Days (dFC)","Days (dPC)"]
[null,"Approach","All",2,0]
[null,"Bridge","Flood",180,0]
[null,"Bridge","Debris",2,0]
[null,"Bridge","Rockfall",4,14]
[null,"Culvert","Flood",3,0]
[null,"Culvert","Debris",1,0]
[null,"PTCS","Rockfall",4,14]
[null,"Road A","Flood",1,0]
[null,"Road B","Flood",3,0]
[null,"Road C","Flood",3,0]
[null,"Roadway","Rockfall",4,14]
[]
[null,"4.2.2.8"]
[null,"Site","Landcover"]
[null,"Slopes","Water & Snow","Urban","Shrubs","Trees"]
[null,"Low","Very Low","Low","Moderate","Moderate"]
[null,"Moderate","Very Low","Moderate","High","High"]
[null,"High","Very Low","High","High","Very High"]
[]
[]
[]
[null,"Debris Potential Factor:",null,null,{"$f":"INDEX(C182:F184,MATCH(D29,B182:B184,0),MATCH(D30,C181:F181,0))","v":"Moderate"}]
[]
[null,{"$f":"_xlfn.CONCAT(C14,C1)","v":"CulvertFlood"}]

{"sheet":"Flood-Major Culvert","index":8,"n_rows":203,"n_cols":15,"rows_kept":203,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,4],[5,7,5,8],[5,9,5,10],[192,2,192,5]]}
["Problem:",null,"Flood"]
[]
[]
["Step 1:","Threat Data Collection"]
[]
[null,"Recurrence Interval",null,"Annual Threat Likelihood"]
[null,100,null,null,{"$f":"VLOOKUP(B7,B85:D92,3)","v":0.01}]
[null,500,null,null,{"$f":"VLOOKUP(B8,B85:D92,3)","v":2E-3}]
[]
[]
[]
[]
["Step 2:","Asset Data Collect"]
["Site Overview:",null,"CBC",null,null,"CODE","Item Description",null,null,"CDOT Link"]
[null,"East","Type:","CBC",null,"NBI 120A","CDOT Structure Type",null,null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Width:",25,"(feet)","NBI 48","Max Spans (round to integer)",null,null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Length:",45,"(feet)","NBI 49","Structure Length",null,null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Height:",15,"(feet)"]
[null,null,"# of Cells:",4,null,"NBI 45","Maint Spans Unit",null,null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Culv Cond:",7,null,"NBI 62","Culvert",null,null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Ch&Pr Cnd:",7,null,"NBI 61","Channel & Chnl. Protection Condition",null,null,"Staff Bridge Major Structure Inventory (link)"]
[null,"Peak Flow:","Design:",225,"(cfs)"]
[null,null,"25-year:",225,"(cfs)"]
[null,null,"50-year:",300,"(cfs)"]
[null,null,"100-year:",500,"(cfs)"]
[null,"Total:","AADT Veh:",10220,"(vehicle)","OTIS","Avg. Annual Daily Traffic (all)",null,"CDOT OTIS Data Search Platform"]
[null,null,"AADT Trck:",3780,"(truck)","OTIS","Avg. Annual Daily Traffic (trucks)",null,"CDOT OTIS Data Search Platform"]
[null,null,"Milepost:",9,null,"NBI 11","CDOT Mile Post",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Car User:","C2","C4"]
[null,null,"Trck User:","C3","C5"]
[null,null,"Occup:",0]
[null,null,"Slope:",2.2499999999999999E-2]
[null,null,"Slope Val:",{"$f":"IF(D32<0.09,\"Low\",IF(D32<0.17,\"Moderate\",\"High\"))","v":"Low"}]
[null,null,"Cover:","Shrubs"]
[]
["Step 3:","Owner Consequence"]
[]
[]
[null,null,{"$f":"INDEX(C154:F158,MATCH(C14,B154:B158,1),MATCH(C1,C153:F153,1))","v":3717500},{"$f":"B15","v":"East"}]
[]
[]
[]
[]
[]
["Step 4:","User Consequence"]
[null,"Full Closure:",null,null,null,null,"Dt:",{"$f":"INDEX(E149:E149,MATCH(C50,D149:D149,0))","v":189},"mins"]
[null,"Avg Veh:",{"$f":"0.5*D26","v":5110},"Veh Cost:",{"$f":"VLOOKUP(D29,G165:H171,2)","v":0.59},null,"Veh:",{"$f":"VLOOKUP(E29,G165:H171,2)","v":10.62}]
[null,"Avg Trck:",{"$f":"0.5*D27","v":1890},"Trck Cost:",{"$f":"VLOOKUP(D30,G165:H171,2)","v":0.96},null,"Trck:",{"$f":"VLOOKUP(E30,G165:H171,2)","v":25.31}]
[null,"dFC:",{"$f":"SUMPRODUCT((B179:B190=C14)*(C179:C190=C1)*(D179:D190))","v":3},null,null,null,"O:",{"$f":"VLOOKUP(D28,G165:H171,2)","v":1.77}]
[null,"C7:",{"$f":"LOOKUP(2,1/(B149:B149<=D28)/(C149:C149>=D28),D149:D149)","v":146},"VOC.FC:",{"$f":"(E47*C47+E48*C48)*C49*C50","v":2115233.4},null,"LW.FC:",{"$f":"(H47*H49*C47+H48*C48)*C49*H46/60","v":1359766.3022999999}]
[]
[null,null,null,"Total:",{"$f":"E50+H50","v":3474999.7023}]
[]
["Step 5:","Vulnerability Assessment"]
[]
[null,"HC Values:",null,"Flood Event Magnitudes:",null,"100-yr","FEM Index:",{"$f":"MATCH(F56,B109:B144,0)","v":1}]
[null,50,null,null,null,"500-yr",null,{"$f":"MATCH(F57,B109:B144,0)","v":19}]
[null,100,null,"Culvert Hydraulic Cap:",null,50,"CHC Index:",{"$f":"MATCH(F59,C109:C126,0)","v":10},{"$f":"H56+H58-1","v":10}]
[null,null,null,"CHC Value:",null,{"$f":"IF(F58=50,\"50-yr\",\"100-yr\")","v":"50-yr"},null,null,{"$f":"H57+H58-1","v":28}]
[null,null,null,"Culvert Condition:",null,{"$f":"D20","v":7},"CC Index:",{"$f":"MATCH(F61,D109:D117,0)","v":1},{"$f":"I58+H60-1","v":10}]
[null,null,null,"CC Value:",null,{"$f":"IF(F60>6,\"7to9\",IF(F60>3,\"4to6\",\"0to3\"))","v":"7to9"},null,null,{"$f":"I59+H60-1","v":28}]
[null,null,null,"Ch & Protection Cond:",null,{"$f":"D21","v":7},"CPC Index:",{"$f":"MATCH(F63,E109:E112,0)","v":1},{"$f":"I60+H62-1","v":10}]
[null,null,null,"CPC Value:",null,{"$f":"IF(F62>6,\"7to9\",IF(F62>3,\"4to6\",\"0to3\"))","v":"7to9"},null,null,{"$f":"I61+H62-1","v":28}]
[null,null,null,"Vulnerable",{"$f":"F56","v":"100-yr"},{"$f":"INDEX(F109:J144,I62,H65)","v":0.12}]
[null,null,null,null,{"$f":"F57","v":"500-yr"},{"$f":"INDEX(F109:J144,I63,H65)","v":0.99},"Debris Ind",{"$f":"MATCH(E201,F108:J108,0)","v":3}]
[]
["Step 6:","Risk Assessment"]
[]
[null,"Annual Owner Risk:",null,{"$f":"F56","v":"100-yr"},{"$f":"C39*F64*E7","v":4461},null,"Annual User Risk:",null,{"$f":"F56","v":"100-yr"},{"$f":"E52*F64*E7","v":4169.9996427599999}]
[null,null,null,{"$f":"F57","v":"500-yr"},{"$f":"C39*F65*E8","v":7360.6500000000005},null,null,null,{"$f":"F57","v":"500-yr"},{"$f":"E52*F65*E8","v":6880.499410554}]
[]
[null,"Total Owner Risk:",null,null,{"$f":"SUM(E69:E70)","v":11821.650000000001},null,"Total User Risk:",null,null,{"$f":"SUM(J69:J70)","v":11050.499053314001}]
[]
[null,null,null,null,null,null,"Total Annual Risk:",null,null,{"$f":"E72+J72","v":22872.149053314002}]
[]
[]
[]
[]
[]
["Please customize the information from the standard below:"]
[]
["Exhibits:",3.6]
[null,null,null,"Annual Threat"]
[null,"Recurrence Interval",null,"Likelihood"]
[null,1,"year",1]
[null,2,"years",{"$f":"1/2","v":0.5}]
[null,5,"years",{"$f":"1/5","v":0.2}]
[null,10,"years",{"$f":"1/10","v":0.1}]
[null,25,"years",{"$f":"1/25","v":0.04}]
[null,50,"years",{"$f":"1/50","v":0.02}]
[null,100,"years",{"$f":"1/100","v":0.01}]
[null,500,"years",{"$f":"1/500","v":2E-3}]
[]
[null,3.8]
[null,null,"Road"]
[null,"Asset","Type","Units","Unit Cost"]
[null,"Approach",null,"sq ft",350]
[null,"Bridge",null,"sq ft",600]
[null,"Culvert",null,"lin ft",{"$f":"IF(D17<48,I85,VLOOKUP(D16,H86:I98,2))","v":0}]
[null,"CBC",null,"cu ft",55]
[null,"PTCS",null,"sq ft",550]
[null,"Roadway","Asphalt","sq yds",150]
[null,"Roadway","Concrete","sq yds",350]
[]
[null,"Unit Cost:",{"$f":"INDEX(E97:E103,MATCH(D15,B97:B103,0))","v":55},"($ / units)"]
[]
[null,"4.2.5.15",null,null,null,"Debris Potential"]
[null,"Flood Event","Hydr Cap","Culv Cond","Chan&Prot","Very Low","Low","Moderate","High","Very High","Index"]
[null,"100-yr","100-yr","7to9","7to9",1E-3,1E-3,4.0000000000000001E-3,0.01,0.02,1]
[null,"100-yr","100-yr","7to9","4to6",1E-3,1E-3,4.0000000000000001E-3,0.01,0.03,2]
[null,"100-yr","100-yr","7to9","0to3",2E-3,2E-3,7.0000000000000001E-3,0.02,0.04,3]
[null,"100-yr","100-yr","4to6","7to9",1E-3,2E-3,5.0000000000000001E-3,0.02,0.03,4]
[null,"100-yr","100-yr","4to6","4to6",1E-3,2E-3,7.0000000000000001E-3,0.02,0.04,5]
[null,"100-yr","100-yr","4to6","0to3",2E-3,3.0000000000000001E-3,0.01,0.04,7.0000000000000007E-2,6]
[null,"100-yr","100-yr","0to3","7to9",3.0000000000000001E-3,4.0000000000000001E-3,0.01,0.05,0.09,7]
[null,"100-yr","100-yr","0to3","4to6",4.0000000000000001E-3,5.0000000000000001E-3,0.02,0.06,0.11,8]
[null,"100-yr","100-yr","0to3","0to3",7.0000000000000001E-3,8.9999999999999993E-3,0.03,0.1,0.18,9]
[null,"100-yr","50-yr","7to9","7to9",0.03,0.04,0.12,0.4,0.73,10]
[null,"100-yr","50-yr","7to9","4to6",0.03,0.04,0.15,0.49,0.9,11]
[null,"100-yr","50-yr","7to9","0to3",0.05,7.0000000000000007E-2,0.24,0.81,0.99,12]
[null,"100-yr","50-yr","4to6","7to9",0.04,0.05,0.18,0.6,0.99,13]
[null,"100-yr","50-yr","4to6","4to6",0.05,7.0000000000000007E-2,0.22,0.73,0.99,14]
[null,"100-yr","50-yr","4to6","0to3",0.08,0.11,0.36,0.99,0.99,15]
[null,"100-yr","50-yr","0to3","7to9",0.11,0.15,0.49,0.99,0.99,16]
[null,"100-yr","50-yr","0to3","4to6",0.13,0.18,0.6,0.99,0.99,17]
[null,"100-yr","50-yr","0to3","0to3",0.22,0.3,0.99,0.99,0.99,18]
[null,"500-yr","100-yr","7to9","7to9",0.02,0.03,0.1,0.33,0.6,19]
[null,"500-yr","100-yr","7to9","4to6",0.03,0.04,0.12,0.4,0.73,20]
[null,"500-yr","100-yr","7to9","0to3",0.04,0.06,0.2,0.66,0.99,21]
[null,"500-yr","100-yr","4to6","7to9",0.03,0.04,0.15,0.49,0.9,22]
[null,"500-yr","100-yr","4to6","4to6",0.04,0.05,0.18,0.6,0.99,23]
[null,"500-yr","100-yr","4to6","0to3",7.0000000000000007E-2,0.09,0.3,0.99,0.99,24]
[null,"500-yr","100-yr","0to3","7to9",0.09,0.12,0.4,0.99,0.99,25]
[null,"500-yr","100-yr","0to3","4to6",0.11,0.15,0.49,0.99,0.99,26]
[null,"500-yr","100-yr","0to3","0to3",0.18,0.24,0.81,0.99,0.99,27]
[null,"500-yr","50-yr","7to9","7to9",0.73,0.99,0.99,0.99,0.99,28]
[null,"500-yr","50-yr","7to9","4to6",0.9,0.99,0.99,0.99,0.99,29]
[null,"500-yr","50-yr","7to9","0to3",0.99,0.99,0.99,0.99,0.99,30]
[null,"500-yr","50-yr","4to6","7to9",0.99,0.99,0.99,0.99,0.99,31]
[null,"500-yr","50-yr","4to6","4to6",0.99,0.99,0.99,0.99,0.99,32]
[null,"500-yr","50-yr","4to6","0to3",0.99,0.99,0.99,0.99,0.99,33]
[null,"500-yr","50-yr","0to3","7to9",0.99,0.99,0.99,0.99,0.99,34]
[null,"500-yr","50-yr","0to3","4to6",0.99,0.99,0.99,0.99,0.99,35]
[null,"500-yr","50-yr","0to3","0to3",0.99,0.99,0.99,0.99,0.99,36]
[]
[null,3.13,null,"(miles)","(minutes)"]
[null,"Start","End","Added Travel","Added Travel"]
[null,"Milepost","Milepost","Distance (C7)","Time (Dt)"]
[null,1,14,146,189]
[]
[null,3.1]
[null,null,"Threat",null,null,null,{"$f":"B15","v":"East"}]
[null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C160","v":3712500}]
[null,"Bridge",null,{"$f":"C160+5000","v":3717500},{"$f":"C160+5000","v":3717500},{"$f":"IF(D15<100,C160+200000,2500000)","v":2500000}]
[null,"Culvert",{"$f":"C160+5000","v":3717500},{"$f":"C160+5000","v":3717500}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*D16*C105+200000","v":371875}]
[null,"Roadway",{"$f":"C160+5000","v":3717500},{"$f":"C160+5000","v":3717500},null,{"$f":"100*D16*C105+200000","v":337500}]
[]
[null,"ARC:",{"$f":"D17*D16*D18*C105*D19","v":3712500},"for the:",{"$f":"B15","v":"East"},{"$f":"C14","v":"CBC"}]
[]
[null,3.11]
[null,null,null,null,null,null,null,null,"Year"]
[null,"User Cost Terms",null,null,null,null,"Variable","Value ($)","Published"]
[null,"Average Vehicle Occupancy",null,null,null,null,0,1.77,2019]
[null,"Car Running Cost per Mile",null,null,null,null,"C2",0.59,2019]
[null,"Truck Running Cost per Mile",null,null,null,null,"C3",0.96,2015]
[null,"Average Value of Time per Adult per Hour",null,null,null,null,"C4",10.62,2015]
[null,"Average Value of Freight Driver Cost per Hour",null,null,null,null,"C5",25.31,2015]
[null,"Car Running Cost per Mile",null,null,null,null,"C8",26.52,2015]
[null,"Truck Running Cost per Mile",null,null,null,null,"C9",44.24,2015]
[]
[null,null,null,null,null,null,"A:","<= half road width"]
[null,null,null,null,null,null,"B:","> half road width"]
[null,null,null,null,null,null,"C:","2 directions"]
[null,3.12]
[null,null,null,"Full Closure","Part Closure"]
[null,"Asset","Threat","Days (dFC)","Days (dPC)"]
[null,"Approach","All",2,0]
[null,"Bridge","Flood",180,0]
[null,"Bridge","Debris",2,0,null,null,null,null,"Approach Directions:",null,"Culvert Types:"]
[null,"Bridge","Rockfall",4,14,null,null,null,null,"East",null,"Corrugated Metal Pipe",null,null,"CMP"]
[null,"CBC","Flood",3,0,null,null,null,null,"West",null,"Corrugated Metal Pipe Ellipse",null,null,"CMPE"]
[null,"Culvert","Flood",3,0,null,null,null,null,"North",null,"Concrete Box Culvert",null,null,"CBC"]
[null,"Culvert","Debris",1,0,null,null,null,null,"South",null,"Reinforced Concrete Box",null,null,"RCB"]
[null,"PTCS","Rockfall",4,14,null,null,null,null,null,null,"Reinforced Concrete Pipe",null,null,"RCP"]
[null,"Road A","Flood",1,0,null,null,null,null,null,null,"Reinforced Concrete Pipe Ellipse",null,null,"RCPE"]
[null,"Road B","Flood",3,0]
[null,"Road C","Flood",3,0]
[null,"Roadway","Rockfall",4,14]
[]
[null,"4.2.2.8"]
[null,"Site","Landcover"]
[null,"Slopes","Water & Snow","Urban","Shrubs","Trees"]
[null,"Low","Very Low","Low","Moderate","Moderate"]
[null,"Moderate","Very Low","Moderate","High","High"]
[null,"High","Very Low","High","High","Very High"]
[]
[]
[]
[null,"Debris Potential Factor:",null,null,{"$f":"INDEX(C195:F197,MATCH(D33,B195:B197,0),MATCH(D34,C194:F194,0))","v":"Moderate"}]
[]
[null,"CulvertFlood"]

{"sheet":"Scour-Bridge","index":9,"n_rows":208,"n_cols":22,"rows_kept":208,"cut":false,"hidden":false,"merged":[[196,2,196,5],[159,17,159,18],[5,1,5,2],[123,1,123,5],[76,3,76,4],[111,2,111,5],[77,1,77,2],[77,3,77,4],[158,5,158,15]]}
["Problem:",null,"Scour"]
[]
[]
["Step 1:","Threat Data Collection"]
[]
[]
[null,"See Vulnerability Assessment"]
[]
[]
[]
[]
[]
[]
["Step 2:","Asset Data Collect"]
["Site Overview:",null,"Bridge"]
[null,"East","Type:",4,"(lanes)","CODE","Item Description",null,null,"CDOT Link"]
[null,null,"Width:",42,"(feet)","NBI 52","Bridge Width",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Length:",83,"(feet)","NBI 49","Bridge Length (all spans)",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Class:",1,null,"NBI 26","Functional Classification",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Water Adq:",8,null,"NBI 71","Waterway Adequacy",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Ch Prot:",8,null,"NBI 61","Channel Protection ",null,"Staff Bridge Major Structure Inventory (link)"]
[null,null,"Sub Cond:",7,null,"NBI 60","Substructure Condition",null,"Staff Bridge Major Structure Inventory (link)"]
[null,"Road:","Width:",37,"(feet)","NBI 51","Width Curb to Curb",null,"Staff Bridge Major Structure Inventory (link)"]
[null,"Total:","AADT Veh:",8200,"(vehicle)","OTIS","Avg. Annual Daily Traffic (all)",null,"CDOT OTIS Data Search Platform"]
[null,null,"AADT Trck:",2800,"(truck)","OTIS","Avg. Annual Daily Traffic (trucks)",null,"CDOT OTIS Data Search Platform"]
[null,null,"Milepost:",7,null,"OTIS","CDOT Mile Post",null,"CDOT OTIS Data Search Platform"]
[null,null,"Car User:","C2","C4"]
[null,null,"Trck User:","C3","C5"]
[]
["Step 3:","Owner Consequence"]
[]
[]
[null,{"$f":"INDEX(C114:F118,MATCH(C15,B114:B118,1),MATCH(C1,C113:F113,1))","v":2096600},{"$f":"B16","v":"East"}]
[]
[]
[]
[]
[]
["Step 4:","User Consequence"]
[null,"Full Closure:",null,null,null,null,"Dt:",{"$f":"INDEX(E156,MATCH(C44,D156,0))","v":189},"mins"]
[null,"Avg Veh:",{"$f":"0.5*D24","v":4100},"Veh Cost:",{"$f":"VLOOKUP(D27,G125:H131,2)","v":0.59},null,"Veh:",{"$f":"VLOOKUP(E27,G125:H131,2)","v":10.62}]
[null,"Avg Trck:",{"$f":"0.5*D25","v":1400},"Trck Cost:",{"$f":"VLOOKUP(D28,G125:H131,2)","v":0.96},null,"Trck:",{"$f":"VLOOKUP(E28,G125:H131,2)","v":25.31}]
[null,"dFC:",{"$f":"SUMPRODUCT((B140:B151=C15)*(C140:C151=C1)*(D140:D151))","v":180},null,null,null,"O:",{"$f":"VLOOKUP(D26,G125:H131,2)","v":1.77}]
[null,"C7:",{"$f":"LOOKUP(2,1/(B156<=D26)/(C156>=D26),D156)","v":146},"VOC.FC:",{"$f":"(E41*C41+E42*C42)*C43*C44","v":98891640},null,"LW.FC:",{"$f":"(H41*H43*C41+H42*C42)*C43*H40/60","v":63789393.779999994}]
[]
[null,null,null,"Total:",{"$f":"E44+H44","v":162681033.78}]
[]
["Step 5:","Vulnerability Assessment"]
[]
[null,"Functional Classification:",null,{"$f":"D19","v":1},null,"Overtopping Frequency:",null,{"$f":"INDEX(F161:P179,MATCH(D50,E161:E179,0),MATCH(D53,F160:P160,0))","v":"S"}]
[null,"Substructure Condition:",null,{"$f":"D22","v":7},null,"Annual Probability:",null,{"$f":"INDEX(U161:U166,MATCH(H50,S161:S166,0))","v":0.02}]
[null,"Channel Protection:",null,{"$f":"D21","v":8},null,"Return Period:",null,{"$f":"INDEX(V161:V166,MATCH(H50,S161:S166,0))","v":"11to100"}]
[null,"Water Adequacy:",null,{"$f":"D20","v":8},null,"Scour Vulnerability:",null,{"$f":"INDEX(C184:M194,MATCH(D52,B184:B194,0),MATCH(D51,C183:M183,0))","v":7}]
[null,"Culvert Condition:",null,{"$f":"D21","v":8},null,"Probability of Failure:",null,{"$f":"INDEX(C199:F208,MATCH(H53,B199:B208,0),MATCH(H50,C198:F198,0))","v":2.5000000000000001E-4}]
[]
["Step 6:","Risk Assessment"]
[]
[null,"Annual Owner Risk:",null,{"$f":"B33*H54","v":524.15},null,"Annual User Risk:",null,{"$f":"E46*H54","v":40670.258444999999}]
[]
[null,null,null,null,null,"Total Annual Risk:",null,{"$f":"D58+H58","v":41194.408445000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Exhibits:",3.6]
[null,null,null,"Annual Threat",null,null,null,"Pipe","Unit Cost"]
[null,"Recurrence Interval",null,"Likelihood",null,null,null,"Diam (in)","($ / lin ft)"]
[null,1,"year",1,null,null,null,"<48",2205]
[null,2,"years",{"$f":"1/2","v":0.5},null,null,null,48,2225]
[null,5,"years",{"$f":"1/5","v":0.2},null,null,null,54,2660]
[null,10,"years",{"$f":"1/10","v":0.1},null,null,null,60,3135]
[null,25,"years",{"$f":"1/25","v":0.04},null,null,null,66,3660]
[null,50,"years",{"$f":"1/50","v":0.02},null,null,null,72,4235]
[null,100,"years",{"$f":"1/100","v":0.01},null,null,null,78,4865]
[null,500,"years",{"$f":"1/500","v":2E-3},null,null,null,84,5550]
[null,null,null,null,null,null,null,90,10325]
[null,null,null,null,null,null,null,96,11690]
[null,"Approach Directions:",null,"Culvert Types:",null,null,null,102,13160]
[null,"East",null,"Corrugated Metal Pipe",null,null,"CMP",108,14770]
[null,"West",null,"Corrugated Metal Pipe Ellipse",null,null,"CMPE",120,18325]
[null,"North",null,"Concrete Box Culvert",null,null,"CBC",138,24695]
[null,"South",null,"Reinforced Concrete Box",null,null,"RCB"]
[null,null,null,"Reinforced Concrete Pipe",null,null,"RCP"]
[null,null,null,"Reinforced Concrete Pipe Ellipse",null,null,"RCPE"]
[]
[null,3.8]
[null,null,"Road"]
[null,"Asset","Type","Units","Unit Cost"]
[null,"Approach",null,"sq ft",350]
[null,"Bridge",null,"sq ft",600]
[null,"Culvert",null,"lin ft",{"$f":"IF(D17<48,I79,VLOOKUP(D17,H80:I92,2))","v":2205}]
[null,"CBC",null,"cu ft",55]
[null,"PTCS",null,"sq ft",550]
[null,"Roadway","Asphalt","sq yds",150]
[null,"Roadway","Concrete","sq yds",350]
[]
[null,"Unit Cost:",{"$f":"INDEX(E100:E106,MATCH(C15,B100:B106,0))","v":600},"($ / units)"]
[]
[]
[null,3.1]
[null,null,"Threat",null,null,null,{"$f":"B16","v":"East"}]
[null,"Asset","Debris","Flood","Scour","Rockfall"]
[null,"Approach",null,{"$f":"C120","v":2091600}]
[null,"Bridge",null,{"$f":"C120+5000","v":2096600},{"$f":"C120+5000","v":2096600},{"$f":"IF(D16<100,C120+200000,2500000)","v":2291600}]
[null,"Culvert",{"$f":"C120+5000","v":2096600},{"$f":"C120+5000","v":2096600}]
[null,"PTCS",null,null,null,{"$f":"0.25*500*D17*C108+200000","v":3350000}]
[null,"Roadway",{"$f":"C120+5000","v":2096600},{"$f":"C120+5000","v":2096600},null,{"$f":"100*D17*C108+200000","v":2720000}]
[]
[null,"ARC:",{"$f":"D18*D17*D19*C108","v":2091600},"for the:",{"$f":"B16","v":"East"},{"$f":"C15","v":"Bridge"}]
[]
[null,3.11]
[null,null,null,null,null,null,null,null,"Year"]
[null,"User Cost Terms",null,null,null,null,"Variable","Value ($)","Published"]
[null,"Average Vehicle Occupancy",null,null,null,null,0,1.77,2019]
[null,"Car Running Cost per Mile",null,null,null,null,"C2",0.59,2019]
[null,"Truck Running Cost per Mile",null,null,null,null,"C3",0.96,2015]
[null,"Average Value of Time per Adult per Hour",null,null,null,null,"C4",10.62,2015]
[null,"Average Value of Freight Driver Cost per Hour",null,null,null,null,"C5",25.31,2015]
[null,"Car Running Cost per Mile",null,null,null,null,"C8",26.52,2015]
[null,"Truck Running Cost per Mile",null,null,null,null,"C9",44.24,2015]
[]
[null,null,null,null,null,null,"A:","<= half road width"]
[null,null,null,null,null,null,"B:","> half road width"]
[null,null,null,null,null,null,"C:","2 directions"]
[]
[null,3.12]
[null,null,null,"Full Closure","Part Closure"]
[null,"Asset","Threat","Days (dFC)","Days (dPC)"]
[null,"Approach","All",2,0]
[null,"Bridge","Flood",180,0]
[null,"Bridge","Scour",180,0]
[null,"Bridge","Debris",2,0]
[null,"Bridge","Rockfall",4,14]
[null,"Culvert","Flood",3,0]
[null,"Culvert","Rockfall",3,0]
[null,"PTCS","Rockfall",4,14]
[null,"Road A","Flood",1,0]
[null,"Road B","Flood",3,0]
[null,"Road C","Flood",3,0]
[null,"Roadway","Rockfall",4,14]
[]
[null,3.13,null,"(miles)","(minutes)"]
[null,"Start","End","Added Travel","Added Travel"]
[null,"Milepost","Milepost","Distance (C7)","Time (Dt)"]
[null,1,14,146,189]
[]
[null,null,null,null,"4.2.6.12"]
[null,"Functional",null,null,null,"Waterway Adequacy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual","Return"]
["Asset","Classification",null,null,"Asset",0,1,2,3,4,5,6,7,8,9,"N",null,"Waterway Adequacy",null,"Description","Probability","Period"]
["01","Principal Arterial",null,null,1,"C","C","O","O","O","O","S","S","S","R","N",null,null,"C","Closed","N/A","N/A"]
["02","Other Principal Arterial",null,null,2,"C","C","F","O","O","O","S","S","S","R","N",null,null,"N","None",0,"Never"]
["03",null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,"R","Remote",0.01,"gt100"]
["04",null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,"S","Slight",0.02,"11to100"]
["05",null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,"O","Occasional",0.2,"3to10"]
["06","Minor Arterial",null,null,6,"C","C","F","O","O","O","S","S","S","R","N",null,null,"F","Frequent",0.3,"lt3"]
["07","Major Collector",null,null,7,"C","C","F","O","O","O","S","S","S","R","N"]
["08","Minor Collector",null,null,8,"C","C","F","O","O","O","O","S","S","R","N"]
["09","Local",null,null,9,"C","C","F","F","O","O","O","S","S","R","N"]
["10",null,null,null,10]
["11","Interstate",null,null,11,"C","C","O","O","O","O","S","S","S","R","N"]
["12","Freeway",null,null,12,"C","C","F","O","O","O","S","S","S","R","N"]
["13",null,null,null,13]
["14","Other Principal Arterial",null,null,14,"C","C","F","O","O","O","S","S","S","R","N"]
["15",null,null,null,15]
["16","Minor Arterial",null,null,16,"C","C","F","O","O","O","S","S","S","R","N"]
["17","Major Collector",null,null,17,"C","C","F","O","O","O","S","S","S","R","N"]
["18",null,null,null,18]
["19","Local",null,null,19,"C","C","F","F","O","O","O","S","S","R","N"]
[]
[null,"4.2.6.13"]
[null,null,"Substructure Condition",null,null,null,null,null,null,null,null,null,null,"Channel"]
[null,"Value",0,1,2,3,4,5,6,7,8,9,"N","Protection"]
[null,0,0,0,0,0,0,0,0,0,0,0,0,"Failure"]
[null,1,0,1,1,1,1,1,1,1,1,1,"N","Failure"]
[null,2,0,1,2,2,2,2,2,2,2,2,"N","Near Collapse"]
[null,3,0,1,2,2,3,4,4,4,4,4,"N","Channel Mitigation"]
[null,4,0,1,2,3,4,4,5,5,6,6,"N","Undetermined Bank"]
[null,5,0,1,2,3,4,5,5,6,7,7,"N","Eroded Bank"]
[null,6,0,1,2,3,4,5,6,6,7,7,"N","Bed Movement"]
[null,7,0,1,2,3,4,6,6,7,7,8,"N","Minor Drift"]
[null,8,0,1,2,3,4,6,7,7,8,8,"N","Stable Condition"]
[null,9,0,1,2,3,4,7,7,8,8,9,"N","No Deficiencies"]
[null,"N",0,1,"N","N","N","N","N","N","N","N","N","Not Over Water"]
[]
[null,"4.2.6.14"]
[null,"Scour","Overtopping Frequency"]
[null,"Vulnerable","R","S","O","F"]
[null,0,1,1,1,1]
[null,1,0.01,0.01,0.01,0.01]
[null,2,5.0000000000000001E-3,6.0000000000000001E-3,8.0000000000000002E-3,8.9999999999999993E-3]
[null,3,1.1000000000000001E-3,1.2999999999999999E-3,1.6000000000000001E-3,2E-3]
[null,4,4.0000000000000002E-4,5.0000000000000001E-4,5.9999999999999995E-4,6.9999999999999999E-4]
[null,5,2.9999999999999997E-4,4.0000000000000002E-4,5.0000000000000001E-4,6.9999999999999999E-4]
[null,6,1.8000000000000001E-4,2.5000000000000001E-4,4.0000000000000002E-4,5.0000000000000001E-4]
[null,7,1.8000000000000001E-4,2.5000000000000001E-4,4.0000000000000002E-4,5.0000000000000001E-4]
[null,8,3.9999999999999998E-6,5.0000000000000004E-6,2.0000000000000002E-5,4.0000000000000003E-5]
[null,9,2.5000000000000002E-6,3.0000000000000001E-6,3.9999999999999998E-6,6.9999999999999999E-6]

{"sheet":"Benefit Cost Ratio","index":10,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,9,0,10],[6,9,7,10],[2,14,3,14],[0,1,0,3],[0,5,0,7],[0,12,0,14],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,12,3,12],[2,13,3,13],[5,9,5,10]]}
[null,"Annual Risk",null,null,null,"Average Mitigation Benefit",null,null,null,"Mitigation Cost Analysis",null,null,"B/C"]
[null,"Owner Risk","User Risk","Total Risk",null,"Owner","User","Total",null,"Cost of asset replacement:",250000,null,"Owner","User","Total"]
["No Action",3246,{"$f":"'Flood-Minor Culvert'!$J$70","v":50185.089103680002},{"$f":"B3+C3","v":53431.089103680002},null,{"$f":"B3-B4","v":-8575.6500000000015},{"$f":"C3-C4","v":39134.590050366001},{"$f":"D3-D4","v":30558.940050366},null,"Cost of new mitigation:",375000,null,{"$f":"F3/J7","v":-1.9980710785298434},{"$f":"G3/J7","v":9.1181067965411451},{"$f":"H3/J7","v":7.1200357180113008}]
["Mitigation",{"$f":"'Flood-Major Culvert'!E72","v":11821.650000000001},{"$f":"'Flood-Major Culvert'!J72","v":11050.499053314001},{"$f":"B4+C4","v":22872.149053314002},null,null,null,null,null,"Cost delta:",{"$f":"K3-K2","v":125000}]
[null,null,null,null,null,null,null,null,null,"Life span of mitigation:",100]
[null,null,null,null,null,null,null,null,null,"Mitigation Annual Cost"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(K4<0,\"$1\",K4*(((0.033*(1+0.033)^K5))/(((1+0.033)^K5)-1)))","v":4291.9644311702168}]