{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inputs-Hazards","Lists","Sheet1"],"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-Hazards","index":0,"n_rows":54,"n_cols":25,"rows_kept":54,"cut":false,"hidden":false,"merged":[[27,2,29,2],[27,3,29,3],[27,4,29,4],[27,5,29,5],[27,6,29,6],[1,2,1,5],[2,3,2,5],[3,3,3,5],[10,10,17,18],[18,2,18,7],[27,16,28,17],[27,18,28,18],[28,14,28,15],[41,2,43,2],[41,3,43,3],[41,4,43,4],[41,5,43,5],[41,6,43,6],[41,7,43,7],[41,8,42,8],[27,7,29,7],[27,8,28,8],[27,9,28,9],[27,10,28,11],[27,12,28,13],[27,14,27,15],[41,9,42,9],[41,10,42,11],[41,12,42,13],[41,14,41,15],[41,16,42,17],[41,19,42,20],[41,21,41,22],[41,23,42,24],[42,14,42,15],[42,21,42,22],[41,18,42,18]]}
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,"Program Setup",null,null,null,null,"Dangers to Analyze (Y=1, N=0, 2 Graphs Result Histogram)",null,null,null,null,null,null,null,"Danger Limits"]
[null,1,1,"Units (SI or Imperial)",null,null,{"$f":"B10+1","v":9},null,"Total Settlement (Thaw Depth & Settlement Graphs if 2)",null,null,null,null,null,null,"Settlement"]
[null,2,null,"Total Iterations",null,null,{"$f":"G3+1","v":10},null,"Diff. Settlement (Requires TS and IW Analysis)",null,null,null,null,null,{"$f":"G10+1","v":17},null,{"$f":"IF($C$3=1,\"m\",\"ft\")","v":"m"},"Total "]
[null,3,null,"Thermal Conductivity Calc.",null,null,11,null,"Active Layer Detachment Slides",null,null,null,null,null,{"$f":"O4+1","v":18},null,{"$f":"IF($C$3=1,\"m\",\"ft\")","v":"m"},"Differential"]
[null,4,null,"# Histogram Bins",null,null,12,null,"Particle Bridge Formation (No Histogram Available)",null,null,null,null,null,null,"Culvert"]
[null,5,null,"Climate Fragility - # of Steps",null,null,13,null,"Structrual Culvert Failure",null,null,null,null,null,{"$f":"O5+1","v":19},null,"%","Minimum Slope within Culvert"]
[null,6,null,"# Soil Layers - Embankment",null,null,14,null,"Culvert Gradient Failure",null,null,null,null,null,{"$f":"O7+1","v":20},null,"%","Ring Strain at Failure"]
[null,7,null,"# Soil Layers - Natural Ground",null,null,15,null,"Ice Wedge Analysis for All Selected Dangers (Y=1, N=0)"]
[null,8,null,null,null,null,16]
[null,null,"Climate Conditions - Current and Model",null,null,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. 3) Normal ditributions are assumed for all variables execpt moisture content (see cell 34). If LogNormal distribution is selected, use the average and standard deviation of the data, not its ln(); a transformation to the ln() mean and standard deviations is included within the program. 4) Cells highlighted red require values before running the program."]
[null,null,"Mean","Stn-dv","Units"]
[null,{"$f":"O8+1","v":21},null,null,{"$f":"IF($C$3=1,\"°C-days\",\"°F-days\")","v":"°C-days"},"Air Thawing Index (Current)"]
[null,{"$f":"B13+1","v":22},null,null,"days","Thawing Season Duration (Current)"]
[null,{"$f":"B14+1","v":23},null,null,{"$f":"IF($C$3=1,\"°C\",\"°F\")","v":"°C"},"Mean Annual Air Temperature (Current)"]
[null,{"$f":"B15+1","v":24},null,null,{"$f":"IF($C$3=1,\"°C\",\"°F\")","v":"°C"},"Mean Annual Air Temperature (EOD Life)"]
[null,{"$f":"B16+1","v":25},null,null,{"$f":"IF($C$3=1,\"°C\",\"°F\")","v":"°C"},"Sinusoidal Climate Model - Amplitude "]
[null,{"$f":"B17+1","v":26}]
[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,{"$f":"B26+1","v":32},null,{"$f":"IF($C$3=1,\"m\",\"ft\")","v":"m"},"Culvert Length"]
[null,null,"Mean","Stn-dv","Units","Mean","Stn-dv","Units",null,null,null,null,null,null,{"$f":"O20+1","v":33},null,"%","Culvert Gradient (Current)"]
[null,{"$f":"B18+1","v":27},null,null,"n/a",null,null,"n/a","n-factor (Natural Ground Surface)",null,null,null,null,null,34,null,{"$f":"IF($C$3=1,\"mm\",\"in\")","v":"mm"},"Culvert Wall Thickness"]
[null,{"$f":"B22+1","v":28},null,null,"deg",null,null,"deg","slope angle (Natual Ground Condition)",null,null,null,null,null,35,null,{"$f":"IF($C$3=1,\"cm\",\"in\")","v":"cm"},"Culvert Diameter"]
[null,{"$f":"B23+1","v":29},null,null,{"$f":"IF($C$3=1,\"°C\",\"°F\")","v":"°C"},null,null,"°C","Permafrost Temperature",null,null,null,null,null,36,null,"n/a","Gravimetric Moisture Content Prob. Density Function"]
[null,{"$f":"B24+1","v":30},null,null,{"$f":"IF($C$3=1,\"m\",\"ft\")","v":"m"},null,null,"m","Active Layer Thickness (Current)",null,null,null,null,null,null,null,null,"(1= Normal, 0= LogNormal)"]
[null,{"$f":"B25+1","v":31},null,null,{"$f":"IF($C$3=1,\"m\",\"ft\")","v":"m"},null,null,"m","Depth to Ice Wedges",null,null,null,null,null,37,null,{"$f":"IF($C$3=1,\"mm\",\"in\")","v":"mm"},"Average Emb Particle Diameter"]
[null,null,"Embankment Soil Profile",null,null,null,null,null,null,null,null,null,null,null,38,null,{"$f":"IF($C$3=1,\"m\",\"ft\")","v":"m"},"Average Width of Ice Wedges"]
[null,null,"Layer Number","Layer Type","Layer Ref Num","USCS","USCS Ref Num","Thermal State","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($C$3=1,\"kg/m^3\",\"pcf\")","v":"kg/m^3"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C3=1,\"m\",\"ft\")","v":"m"},{"$f":"IF(C3=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(D31,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"I31","v":0}]
[null,null,2,null,{"$f":"VLOOKUP(D32,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F32,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I32+J31","v":0}]
[null,null,3,null,{"$f":"VLOOKUP(D33,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F33,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0,null,null,null,null,null,null,null,null,null,null,"Current Climate Text File Output"]
[null,null,4,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,0,null,null,null,null,null,null,null,null,null,null,"of Simulation Values (1=Y, 0=N)"]
[null,null,5,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,0,null,null,null,null,null,null,null,null,null,39,null,"Climate"]
[null,null,6,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,null,null,null,null,null,null,null,40,null,"Soil Properties"]
[null,null,7,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,null,null,null,null,null,null,null,41,null,"Thermal Properties"]
[null,null,8,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,{"$f":"I38+J37","v":0},null,null,null,null,null,null,null,null,null,42,null,"ThawDepth/Hazards"]
[null,null,9,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,{"$f":"I39+J38","v":0}]
[null,null,10,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,{"$f":"I40+J39","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($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(C3=1,\"kg/m^3\",\"pcf\")","v":"kg/m^3"},null,null,null,null,null,null,{"$f":"IF(C3=1,\"kg/m^2\",\"psf\")","v":"kg/m^2"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C3=1,\"m\",\"ft\")","v":"m"},{"$f":"IF(C3=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(D45,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F45,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I45","v":0}]
[null,null,2,null,{"$f":"VLOOKUP(D46,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F46,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I46+J45","v":0}]
[null,null,3,null,{"$f":"VLOOKUP(D47,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F47,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,4,null,{"$f":"VLOOKUP(D48,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F48,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,5,null,{"$f":"VLOOKUP(D49,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F49,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,6,null,{"$f":"VLOOKUP(D50,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F50,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,7,null,{"$f":"VLOOKUP(D51,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F51,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,0]
[null,null,8,null,{"$f":"VLOOKUP(D52,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F52,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I52+J51","v":0}]
[null,null,9,null,{"$f":"VLOOKUP(D53,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F53,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I53+J52","v":0}]
[null,null,10,null,{"$f":"VLOOKUP(D54,Lists!$A$2:$B$9,2)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F54,Lists!$A$13:$B$26,2)","v":{"$error":"#N/A"}},null,null,{"$f":"I54+J53","v":0}]

{"sheet":"Lists","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Material Type"]
["1 - Asphalt",1]
["2 - Ice",2]
["3 - Insulation",3]
["4 - Crushed Gravel",4]
["5 - Gravel & Large Sand",5]
["6 - Average & Fine Sand",6]
["7 - Silts & Clays",7]
["8 - Peat",8]
[]
["Thaw Consolidation Soil Types"]
["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]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}