{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inputs","SSCopy","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Inputs","index":0,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[14,11,21,16]]}
[]
[null,null,"Program Setup ",null,null,null,null,null,"Dangers to Analyze (Yes=1, No=0)"]
[null,1,1,"Units (SI=1, Imperial=0)",null,null,null,8,1,"Total Thaw Settlement"]
[null,2,10000,"Monte Carlo Simulations",null,null,null,9,1,"Differential Thaw Settlement"]
[null,3,1,"Thermal Conductivity Calc",null,null,null,10,1,"Culvert Failure - Structural"]
[null,null,null,"(Côté & Konrad=1, Kersten=0)",null,null,null,11,1,"Culvert Failure - Gradient"]
[null,4,0,"Moisture Content PDF",null,null,null,12,1,"Active Layer Detachment Landslides"]
[null,null,null,"(Normal=1, LogNormal=0)",null,null,null,13,0,"Particle Bridge Formation "]
[null,5,10,"Climate Fragility - # of Steps",null,null,null,14,1,"Ice Wedge Analysis for All Selected Dangers"]
[null,null,null,"(if 0, no climate fragility analysis)",null,null,null,null,"Infrastructure Analysis Data"]
[null,6,0,"Hazard & Risk Reporting",null,null,null,15,0,{"$f":"IF($C$3=1,\"km\",\"mi\")","v":"km"},"Beginning Length"]
[null,null,null,"(Both=0, Hazard=1, Risk=2)",null,null,null,16,10,{"$f":"IF($C$3=1,\"km\",\"mi\")","v":"km"},"Ending Length"]
[null,7,0,"Graph Hazardc & Riskc Profile",null,null,null,17,0.5,"km","Graph Unit Length"]
[null,null,null,"(Both=0, Hazard=1, Risk=2, No=3)"]
[null,null,"Indirect Consequence Factors",null,null,null,null,null,null,null,null,"Notes: 1) Fill out this sheet (Inputs), then hit \"1) Setup  Excel File\" button. 2) Complete analyses for all sections. 3) Hit \"3) Graph Charts\" if you want the graphical presentation of the current data analyses. DO NOT CHANGE THE NAMES OF SHEETS!!"]
[null,null,"Ih",null,"Is",null,"Casualty (Ih) and Social (Is) Factors"]
[null,18,"2 - Minor Impacts",{"$f":"VLOOKUP(C17,Lists!$D$2:$E$5,2,FALSE)","v":2},"2 - Minor Impacts",{"$f":"VLOOKUP(E17,Lists!$D$8:$E$11,2,FALSE)","v":2},"Total Thaw Settlement"]
[null,19,"1 - No Impact",{"$f":"VLOOKUP(C18,Lists!$D$2:$E$5,2,FALSE)","v":1},"2 - Minor Impacts",{"$f":"VLOOKUP(E18,Lists!$D$8:$E$11,2,FALSE)","v":2},"Differential Thaw Settlement"]
[null,20,"2 - Minor Impacts",{"$f":"VLOOKUP(C19,Lists!$D$2:$E$5,2,FALSE)","v":2},"5 - Major Impacts",{"$f":"VLOOKUP(E19,Lists!$D$8:$E$11,2,FALSE)","v":5},"Culvert Failure"]
[null,21,"2 - Minor Impacts",{"$f":"VLOOKUP(C20,Lists!$D$2:$E$5,2,FALSE)","v":2},"2 - Minor Impacts",{"$f":"VLOOKUP(E20,Lists!$D$8:$E$11,2,FALSE)","v":2},"Active Layer Detachment Landslides"]
[null,22,"5 - Major Impacts",{"$f":"VLOOKUP(C21,Lists!$D$2:$E$5,2,FALSE)","v":5},"5 - Major Impacts",{"$f":"VLOOKUP(E21,Lists!$D$8:$E$11,2,FALSE)","v":5},"Particle Bridge Formation "]
[]
[null,null,"Hazard Analysis Limits"]
[null,null,"Settlement"]
[null,23,0.05,"m","Total"]
[null,24,0.03,"m","Differential"]
[null,null,"Culvert",null,null,null,null,30,2,{"$f":"IF($C$3=1,\"km\",\"mi\")","v":"km"},"Kilometer Post Ending 1st Section"]
[null,25,2,"%","Minimum Culvert Slope",null,null,null,"Qualitative Shading of Reporting Sheets"]
[null,26,15,"%","Culvert Collapse Ring Strain",null,null,null,"Hazard"]
[null,null,null,null,null,null,null,31,0.25,"Max Percentage in Green (values in decimals)"]
[null,null,"Climate Data",null,null,null,null,32,0.75,"Max Percentage in Yellow (values in decimals)"]
[null,27,-5,{"$f":"IF(C3=0,\"°F\",\"°C\")","v":"°C"},"Current MAAT",null,null,null,"Risk"]
[null,28,0,{"$f":"IF(C4=1,\"°F\",\"°C\")","v":"°C"},"End of Design Life MAAT",null,null,33,50000,"Max $ in Green"]
[null,29,10,{"$f":"IF(C5=1,\"°F\",\"°C\")","v":"°F"},"Climate Curve Amplitude",null,null,34,500000,"Max $ in Yellow"]

{"sheet":"SSCopy","index":1,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[30,18,31,18],[30,19,31,20],[30,21,30,22],[30,23,31,24],[31,14,31,15],[31,21,31,22],[30,16,31,17],[30,2,32,2],[30,3,32,3],[30,4,32,4],[30,5,32,5],[30,6,32,6],[30,7,32,7],[16,10,17,11],[16,12,17,13],[16,14,16,15],[16,16,17,17],[30,8,31,8],[30,9,31,9],[30,10,31,11],[30,12,31,13],[30,14,30,15],[16,18,17,18],[17,14,17,15],[1,16,6,22],[7,2,7,7],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[16,6,18,6],[16,7,18,7],[16,8,17,8],[16,9,17,9]]}
[]
[null,null,"Climate Conditions - Current and Model",null,null,null,null,null,null,null,"Section Direct Consequence ",null,null,null,null,null,"Notes: 1) Tables must only include values and no formulas. 2) Determine your average and standard deviation values elsewhere and place the results on the INPUTS sheets. "]
[null,null,"Mean","Stn-dv","Units",null,null,null,null,null,null,"Total Thaw Settlement"]
[null,null,null,null,{"$f":"IF($C$4=1,\"°C-days\",\"°F-days\")","v":"°F-days"},"Air Thawing Index (Current)",null,null,null,null,null,"Differential Thaw Settlement"]
[null,null,null,null,"days","Thawing Season Duration (Current)",null,null,null,null,null,"Culvert Failure"]
[null,null,null,null,null,null,null,null,null,null,null,"Active Layer Detachment Landslides"]
[null,null,null,null,null,null,null,null,null,null,null,"Particle Bridge Formation "]
[null,null,"Subsurface Soil Profiles",null,null,null,null,null,null,null,null,null,null,null,null,"Other Analysis Inputs "]
[null,null,"Embankment Soil Profile",null,null,"Natural Ground Profile",null,null,null,null,null,null,null,null,null,null,null,"# Soil Layers in Embankment Profile"]
[null,null,"Mean","Stn-dv","Units","Mean","Stn-dv","Units",null,null,null,null,null,null,null,null,null,"# Soil Layers in Natural Ground profile"]
[null,null,null,null,"n/a",null,null,"n/a","n-factor (Natural Ground Surface)",null,null,null,null,null,null,null,{"$f":"IF($C$4=1,\"m\",\"ft\")","v":"ft"},"Culvert Length"]
[null,null,null,null,"deg",null,null,"deg","slope angle (Natual Ground Condition)",null,null,null,null,null,null,null,"%","Culvert Gradient (Current)"]
[null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"°C\",\"°F\")","v":"°C"},null,null,"°C","Permafrost Temperature",null,null,null,null,null,null,null,{"$f":"IF($C$4=1,\"mm\",\"in\")","v":"in"},"Culvert Wall Thickness"]
[null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"m\",\"ft\")","v":"m"},null,null,"m","Active Layer Thickness (Current)",null,null,null,null,null,null,null,{"$f":"IF($C$4=1,\"cm\",\"in\")","v":"in"},"Culvert Diameter"]
[null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"m\",\"ft\")","v":"m"},null,null,"m","Depth to Ice Wedges",null,null,null,null,null,null,null,{"$f":"IF($C$4=1,\"mm\",\"in\")","v":"in"},"Average Emb Particle Diameter"]
[null,null,"Embankment Soil Profile",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$4=1,\"m\",\"ft\")","v":"ft"},"Average Width of Ice Wedges"]
[null,null,"Layer Number","Layer Type","Layer Ref Num","USCS","USCS Ref Num","Thermal State        (F or T)","Layer Thickness","Layer Depth","Moisture Content (%)",null,"Unfrozen W (%)",null,"Dry Unit Weight",null,"Specific Gravity ",null,"ks, Mineral Conductivity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"kg/m^3\",\"pcf\")","v":"kg/m^3"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"m\",\"ft\")","v":"m"},{"$f":"IF(Inputs!$C$3=1,\"m\",\"ft\")","v":"m"},"Mean","Stn-dv","Mean","Stn-dv","Mean","Stn-dv","Mean","Stn-dv","W/m-K"]
[null,null,1,null,{"$f":"VLOOKUP(D20,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"I20","v":0}]
[null,null,2,null,{"$f":"VLOOKUP(D21,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F21,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I21+J20","v":0}]
[null,null,3,null,{"$f":"VLOOKUP(D22,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F22,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0,null,null,null,null,null,null,null,null,null,"Other Analysis Inputs 2"]
[null,null,4,null,{"$f":"VLOOKUP(D23,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F23,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"km\",\"mi\")","v":"km"},"Section Starting Post"]
[null,null,5,null,{"$f":"VLOOKUP(D24,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F24,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"km\",\"mi\")","v":"km"},"Section Ending Post"]
[null,null,6,null,{"$f":"VLOOKUP(D25,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F25,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"km\",\"mi\")","v":"km"},"End Point of Next Section"]
[null,null,7,null,{"$f":"VLOOKUP(D26,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F26,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,8,null,{"$f":"VLOOKUP(D27,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F27,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I27+J26","v":0}]
[null,null,9,null,{"$f":"VLOOKUP(D28,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F28,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I28+J27","v":0}]
[null,null,10,null,{"$f":"VLOOKUP(D29,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F29,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I29+J28","v":0}]
[null,null,"Natural Ground Soil Profile (Active Layer Detachment Slide Analysis)"]
[null,null,"Layer Number","Layer Type","Layer Ref Num","USCS","USCS Ref Num","Thermal State        (F or T)","Layer Thickness","Layer Depth","Moisture Content (%)",null,"Unfrozen W (%)",null,"Dry Unit Weight",null,"Specific Gravity ",null,"ks, Mineral Conductivity",{"$f":"IF(Inputs!$C$3=1,\"Coeff. Of Consol. (m^2/s)\",\"Coeff. Of Consol. (ft^2/hr)\")","v":"Coeff. Of Consol. (m^2/s)"},null,"Eff. Cohesion",null,"Eff. Friction Angle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"kg/m^3\",\"pcf\")","v":"kg/m^3"},null,null,null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"kg/m^2\",\"psf\")","v":"kg/m^2"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Inputs!$C$3=1,\"m\",\"ft\")","v":"m"},{"$f":"IF(Inputs!$C$3=1,\"m\",\"ft\")","v":"m"},"Mean","Stn-dv","Mean","Stn-dv","Mean","Stn-dv","Mean","Stn-dv","W/m-K","Mean","Stn-dv","Mean","Stn-dv","Mean","Stn-dv"]
[null,null,1,null,{"$f":"VLOOKUP(D34,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F34,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I34","v":0}]
[null,null,2,null,{"$f":"VLOOKUP(D35,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F35,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I35+J34","v":0}]
[null,null,3,null,{"$f":"VLOOKUP(D36,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F36,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,4,null,{"$f":"VLOOKUP(D37,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F37,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,5,null,{"$f":"VLOOKUP(D38,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F38,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,6,null,{"$f":"VLOOKUP(D39,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F39,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,7,null,{"$f":"VLOOKUP(D40,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F40,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,8,null,{"$f":"VLOOKUP(D41,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F41,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I41+J40","v":0}]
[null,null,9,null,{"$f":"VLOOKUP(D42,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F42,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I42+J41","v":0}]
[null,null,10,null,{"$f":"VLOOKUP(D43,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F43,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I43+J42","v":0}]

{"sheet":"Lists","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Material Type",null,null,"Ih Values"]
["1 - Asphalt",1,null,"1 - No Impact",1]
["2 - Ice",2,null,"2 - Minor Impacts",2]
["3 - Insulation",3,null,"5 - Major Impacts",5]
["4 - Crushed Gravel",4,null,"10 - Unacceptable Impacts",10]
["5 - Gravel & Large Sand",5]
["6 - Average & Fine Sand",6,null,"Is Values"]
["7 - Silts & Clays",7,null,"1 - No Impact",1]
["8 - Peat",8,null,"2 - Minor Impacts",2]
[null,null,null,"5 - Major Impacts",5]
["Thaw Consolidation Soil Types",null,null,"10 - Unacceptable Impacts",10]
["USCS","Thaw Con"]
["CL",4]
["GC",3]
["GM",3]
["GP",1]
["GP-GC",3]
["GP-GM",3]
["GW",1]
["ML",4]
["OL",4]
["SM",2]
["SP",1]
["SP-SC",2]
["SP-SM",2]
["SW",1]