{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["User Instructions - Must Read","DesignStep","Output"],"not_rendered":{"charts":11,"images":11,"macros":0,"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":"User Instructions - Must Read","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,37,18]]}
[]
[null,"\n\nWorksheet Instructions:\n\nThe Design Step calculator is an Excel spreadsheet designed to automate the summation of Consequence Rating Points (CRP) and selection of the Design Step, as outlined in the Dam Safety Guidelines - Technical Note #2: Selection of Design/Performance Goals for Critical Elements.  Specifically, it automates the summation of Consequence Rating Points outlined in the Tech Note #2 Appendix B Worksheet.\n\nNote: The worksheet requires a thorough understanding of the terminology and design step format outlined in Tech Note #2 and should not be used without reviewing all sections of that document.  It is not intended to substitute for the Best Professional Judgment (BPJ) and analytical skills of a Professional Engineer, but is presented merely as an aid to make the summations more convenient.  Several sections in the Results Column for the CRP summation include cell formulae, in conjunction with regressed equations derived from utility curves, the latter outlined in various sections of Tech Note #2.  These are computational aids to speed the selection of the proper consequence rating points for various inputs.  All such results should be confirmed by the user by referring to the proper tables and utility curves presented in Tech Note 2.\n \nInputs: The use of the spreadsheet is somewhat self-explanatory, calling for inputs in the Input column, which are then expressed in the Results column.  The Input boxes are open for editing, while the Results boxes are protected and automatically process the inputs.  A number of Results Boxes are designated by a deeper orange color and a \"Will Calculate\" title, indicating that the results will be automatically calculated from other inputs (i.e. previous “Results”).  All of these results can be manually over-ridden by inputs into the Yellow Input boxes.  It should be noted that all the Green Input boxes must have some value entered (default to zero, if no other values are anticipated), but entries into the Yellow Input boxes are optional, and act as overrides of calculated results. Finally, it should be noted that the Dam Breach Peach Discharge and the 100-year flood are typically calculated using separate spreadsheets. \n\nResults: The results are expressed in individual boxes in the Results Column for the specific parameters outlined in Tech Note #2.  The Input and Results columns are broken up into related categories (i.e. \"Capital Value of Project\", \"Potential for Loss of Life\", \"Population at Risk\", etc.), and the Consequence Rating Points are summed in a Summation box, typically at the bottom of each section.  The Consequence Rating Points are all summarized in the top section, (i.e. Total Consequence Rating Points & Annual Exceedance Probability).  From the Consequence Rating Points, an Annual Exceedance Probability (AEP) is calculated and a Design Step is selected. The Design Step can be used in Technical Note #3 - Design Storm Construction to determine the Design Precipitation and then the subsequent Inflow Design Flood (IDF), using appropriate hydrologic software.    \n  \n\nGuy Hoyle-Dodson P.E.   \nDam Safety Office\nWater Resources Program\nWashington State Department of Ecology\n360-407-6451\nghoy461@ecy.wa.gov\n \n"]

{"sheet":"DesignStep","index":1,"n_rows":198,"n_cols":65,"rows_kept":198,"cut":false,"hidden":false,"merged":[[65,17,65,18],[65,20,65,21],[65,23,65,24]]}
["Design Step Analysis & Calculator - Design by Guy Hoyle-Dodson, 11-28-2017"]
[]
["Project:"]
[]
["Date:"]
[]
["Project lead:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Must Input Values"]
["Total Consequence Rating Points & Annual Exceedance Probability",null,"Override Results"]
[]
["Description","Parameter Symbol","Input                      (Enter Values Here)","Equation","Result\n(Do Not Input Here)",null,null,null,null,"Annual Exceedance Probability","Design Step"]
[null,null,null,null,"Will Calculate",null,null,null,null,0.01,0]
["Annual Exceedance Probability","P(Annual Exceed) :",null,"AEP =",{"$f":"IF(C38<>\"\",C38,IF(ISNUMBER(E40)=TRUE,IF(E40<>0,(EXP(E40+4)^-(1/0.8686)),\"Enter Values to Calculate Design Step\"),\"Enter Values to Calculate Design Step\"))","v":"Enter Values to Calculate Design Step"},null,null,null,null,1E-3,2]
[null,null,null,null,"Will Calculate",null,null,null,null,1E-4,4]
["Design Step","DS :",null,{"$f":"IF(ISNUMBER(E40)=TRUE,\"Design Step =\",\"Input All Values Below\" & CHAR(10) & \"to\" & CHAR(10) & \"Calculate Design Step\")","v":"Input All Values Below\nto\nCalculate Design Step"},{"$f":"IF(C40<>\"\",C40,IF(ISNUMBER(E42)=TRUE,IF(E42<=275,IF(E109>0,3,1),IF(E42<=325,IF(E109>0,3,2),IF(E42<=375,3,IF(E42<=425,4,IF(E42<=475,5,F40))))),\"Input Values to Calculate                   Cumulative Rating Points\"))","v":"Input Values to Calculate                   Cumulative Rating Points"},{"$f":"IF(E42<=525,6,IF(E42<=575,7,IF(E42<=800,8,\"Value for Cumulative rating points Outside of Range\")))","v":"Value for Cumulative rating points Outside of Range"},null,null,null,1.0000000000000001E-5,6]
[null,null,null,null,"Will Calculate",null,null,null,null,9.9999999999999995E-7,8]
["Cumulative Consequence\nRating Points","Cp(cumulative) :",null,"Cumulative Rating =",{"$f":"IF(C42<>\"\",C42,IF(ISNUMBER(E44)=TRUE,IF(ISNUMBER(E53)=TRUE,IF(ISNUMBER(E59)=TRUE,IF(ISNUMBER(E61)=TRUE,IF(ISNUMBER(E76)=TRUE,IF(ISNUMBER(E115)=TRUE,F42),\"Check the Consequence Rating Points of All Values.\" & CHAR(10) & \"IF Not  Applicable Input Zero\")),\"Check the Consequence Rating Points of All Values\" & CHAR(10) &  \"IF Not  Applicable Input Zero\"),\"Check the Consequence Rating Points of All Values\" & CHAR(10) & \"IF Not  Applicable Input Zero\"),\"Check the Consequence Rating Points of All Values\" & CHAR(10) & \"IF Not  Applicable Input Zero\"))","v":"Check the Consequence Rating Points of All Values\nIF Not  Applicable Input Zero"},{"$f":"IF(ISNUMBER(E145)=TRUE,IF(ISNUMBER(E196)=TRUE,E44+E53+E59+E61+E76+E115+E145+E196,\"Check the Consequence Rating Points of All Values. IF Not  Applicable Input Zero\"),\"Check the Consequence Rating Points of All Values. IF Not  Applicable Input Zero\")","v":"Check the Consequence Rating Points of All Values. IF Not  Applicable Input Zero"}]
[null,null,null,null,"Will Calculate"]
["Base Consequence Rating Points","CP(Base) :",null,"Base Points =",{"$f":"IF(C44<>\"\",C44,150)","v":150}]
[]
[]
["Capital Value of Project",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consequence Rating Points","Height of Dam (log10 scale)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35.25,1]
["Description","Parameter Symbol","Input                      (Enter Values Here)","Equation","Result\n(Do Not Input Here)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.5,3]
["Dam Height (ft)","HDAM :",null,"Input =",{"$f":"IF(C51<>\"\",C51,\"Enter Value for \nDam Height\")","v":"Enter Value for \nDam Height"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38.25,4]
[null,null,null,null,"Will Calculate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,5]
["Cosequence Rating Points","CP(Dam Height) :",null,{"$f":"IF(ISNUMBER(E53)=TRUE,\"Calculate Value =\",\"\")","v":""},{"$f":"IF(C53<>\"\",C53,IF(ISNUMBER(E51)=TRUE,((0.000004*((E51)^3))-(0.0026*((E51)^2))+(0.7868*E51)+(36.046)),\"Enter Value for\" & CHAR(10) & \"Dam Height\"))","v":"Enter Value for\nDam Height"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40.5,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41.5,7]
["Loss of Project Benefits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42.35,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,9]
["Description","Parameter Symbol","Input                      (Enter Values Here)","Equation","Result\n(Do Not Input Here)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,20]
["Limited Resource\n(Losses Would Effect General Public)","CP(Loss-public) :",null,"Mandatory Rating Points (25 - 75) =",{"$f":"IF(C59<>\"\",C59,\"Enter Value for Public Losses\")","v":"Enter Value for Public Losses"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64.75,40]
["Private Enterprise\n(Losses Would Not Effect General Public)","CP(Loss-private) :",null,"Total Discretionary Rating Points =\nIrrigation/Industrial Water Supply (10 - 75)\n HydroPower generation (10 - 75) \nMining/Manufacturing (10 - 75)\nAesthetics/Recreation/Habitat (10 - 25)\n Other (10 - 25)",{"$f":"IF(C61<>\"\",C61,\"Input Total Value for Private Losses\")","v":"Input Total Value for Private Losses"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74.75,60]
["Potential for Loss of Life",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78.75,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Q, flood magnitude, in cubic feet per second; A, total drainage area, in square miles; P, mean annual precipitation, in inches; F,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"forest cover, in percent of contributing drainage area; a, regression constant; b, c, and d, regression coefficients; --, regression coef-ficient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"not determined; <, less than]"]
["Description","Parameter Symbol","Input                      (Enter Values Here)","Equation","Result\n(Do Not Input Here)",null,null,null,null,null,null,null,null,null,null,null,null,"Large Dams",null,null,"Intermediate Dams",null,null,"Small Dams"]
[null,null,null,null,"Will Calculate"]
["Dam Size Classification\n(Large, Intermediate, or Small)","Size :",null,{"$f":"IF(ISNUMBER(E51)=TRUE,\"Dam Size Classification =\",\"Must Enter Value for Dam Size\")","v":"Must Enter Value for Dam Size"},{"$f":"IF(C68<>\"\",C68,IF(ISNUMBER(E51)=TRUE,IF(E51>50,\"Large\",IF(E51<15,\"Small\",\"Intermediate\")),\"Enter Value for Dam Height\"))","v":"Enter Value for Dam Height"},{"$f":"-0.000000003454*E74^6 + 0.000001171503*E74^5 - 0.000155841504*E74^4 + 0.010324309069*E74^3 - 0.361964266435*E74^2 + 6.97917016023*E74 - 4.743978465648","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equation for 100 year flood"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loss of Life Consequence Rating Points","Ratio of Dam Breach Peak Q to 100 Year Flood Peak Q",null,"Loss of Life Consequence Rating Points","Ratio of Dam Breach Peak Q to 100 Year Flood Peak Q",null,"Loss of Life Consequence Rating Points","Ratio of Dam Breach Peak Q to 100 Year Flood Peak Q"]
["Dam Breach\nPeak Discharge (cfs)\n(from Tech Note1 Breach Calculation)","Q(Dam) :",null,"Peak Discharge from\nDam Breach =",{"$f":"IF(C70<>\"\",C70,\"Enter Value for 100 Year Flood Peak Discharge\")","v":"Enter Value for 100 Year Flood Peak Discharge"},{"$f":"-0.000000001019*E74^6 + 0.000000352653*E74^5 - 0.000047971565*E74^4 + 0.003252023634*E74^3 - 0.116524653766*E74^2 + 2.289675395824*E74  - 1.529483761259","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,0,1,null,0,1,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q = a* A^b*P^c "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0590000000000002,2,null,4.7058999999999997,2,null,2.3530000000000002,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a ="]
["100 Year Flood\nPeak Discharge (cfs)\n(From USGS Flood Calculation)","Q(flood) :",null,"Peak Discharge from\n100 Year Flood =",{"$f":"IF(C72<>\"\",C72,\"Enter Value for 100 Year Flood Peak Discharge\")","v":"Enter Value for 100 Year Flood Peak Discharge"},null,null,null,null,null,null,null,null,null,null,null,null,10.587999999999999,2.5,null,7.0590000000000002,2.5,null,3.5289999999999999,2.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A = "]
[null,null,null,null,"Will Calculate",null,null,null,null,null,null,null,null,null,null,null,null,14.117599999999999,3,null,9.4116999999999997,3,null,4.7058999999999997,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b ="]
["Ratio of Q(dam) to Q(flood) =","Ratio :",null,"Ratio Q(dam)/Q(flood) =",{"$f":"IF(C74<>\"\",C74,IF(ISNUMBER(E70)=TRUE,IF(ISNUMBER(E72)=TRUE,E70/E72,\"Enter Value for\" & CHAR(10) & \"100 Year Flood\"),IF(ISNUMBER(E72)=TRUE,\"Enter Value for\" & CHAR(10) & \"Dam Breach\" & CHAR(10) & \"Peak Discharge\",\"Enter Values for\" & CHAR(10) & \"100 year Flood\" & CHAR(10) & \"and\" & CHAR(10) & \"Dam Breach\" & CHAR(10) & \"Peak Discharges\")))","v":"Enter Values for\n100 year Flood\nand\nDam Breach\nPeak Discharges"},null,null,null,null,null,null,null,null,null,null,null,null,17.059000000000001,3.5,null,11.176500000000001,3.5,null,5.5880000000000001,3.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P ="]
[null,null,null,null,"Will Calculate",null,null,null,null,null,null,null,null,null,null,null,null,19.411999999999999,4,null,12.9411,4,null,6.4710000000000001,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c ="]
["Loss of Life Consequence\nRating Points","CP(Loss of Life) :",null,"Consequence Rating Points for\nLoss of Life =",{"$f":"IF(C76<>\"\",C76,IF(ISNUMBER(E70)=TRUE,IF(ISNUMBER(E72)=TRUE,IF(E68=\"Large\",IF(E74<100,17.967787209876*LN(E74)-4.544597405357,48.4077830955042*E74^0.095141052950899),IF(E68=\"Intermediate\",IF(E74<100,12.034295331474*LN(E74)-3.135689950556,37.9327934764107*E74^0.060635300845052),IF(E68=\"Small\",IF(E74<100,6.00061651530522*LN(E74)-1.56302813808367,21.1746741486962*Y105^0.034341245342119)))),\"Enter Value for\" &  CHAR(10) & \"100 Year Flood\"),IF(ISNUMBER(E70)=TRUE,\"Enter Value for\" & CHAR(10) & \"100 Year Flood\",\"Enter All Values for\" & CHAR(10)& \"Peak Discharges\")))","v":"Enter All Values for\nPeak Discharges"},null,null,null,null,null,null,null,null,null,null,null,null,21.175999999999998,4.5,null,14.117599999999999,4.5,null,7.0587999999999997,4.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.704999999999998,5.5,null,16.471,5.5,null,8.2349999999999994,5.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.059000000000001,6,null,17.646999999999998,6,null,8.8230000000000004,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.294,6.5,null,18.824000000000002,6.5,null,9.4116999999999997,6.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,7,null,20,7,null,10,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31.175999999999998,7.5,null,20.588000000000001,7.5,null,10.294,7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32.353000000000002,8,null,21.175999999999998,8,null,10.882,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33.529000000000003,8.5,null,22.353000000000002,8.5,null,11.176,8.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34.704999999999998,9,null,23.529,9,null,11.471,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35.881999999999998,9.5,null,24.117599999999999,9.5,null,11.765000000000001,9.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.47,10,null,24.7059,10,null,12.353,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44.7059,15,null,30,15,null,14.7059,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50.588000000000001,20,null,33.529000000000003,20,null,16.765000000000001,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54.7059,25,null,37.058999999999997,25,null,18.234999999999999,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58.325000000000003,30,null,38.823999999999998,30,null,19.4117,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61.176000000000002,35,null,40.588000000000001,35,null,20.294,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63.529000000000003,40,null,42.353000000000002,40,null,21.175999999999998,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65.293999999999997,45,null,43.529000000000003,45,null,21.765000000000001,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67.058999999999997,50,null,45.293999999999997,50,null,22.353000000000002,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69.411699999999996,55,null,45.881999999999998,55,null,22.940999999999999,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70.587999999999994,60,null,47.058999999999997,60,null,23.529,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71.765000000000001,65,null,47.646999999999998,65,null,24.117999999999999,65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72.352000000000004,70,null,48.234999999999999,70,null,24.411999999999999,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72.941000000000003,75,null,48.823,75,null,24.529,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`",73.528999999999996,80,null,49.411700000000003,80,null,24.646999999999998,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74.117000000000004,85,null,49.7059,85,null,24.675999999999998,85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74.441699999999997,90,null,49.9,90,null,24.7059,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74.7059,95,null,50,95,null,24.76,95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74.709999999999994,100,null,50.1,100,null,24.794,100]
["Population at Risk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"48.4077830955042*S105^0.095141052950899","v":80.137835966017406},200,null,{"$f":"37.9327934764107*V105^0.060635300845052","v":52.304429872919627},200,null,{"$f":"21.1746741486962*Y105^0.034341245342119","v":25.40019036073226},200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"48.4077830955042*S106^0.095141052950899","v":83.289665595251094},300,null,{"$f":"37.9327934764107*V106^0.060635300845052","v":53.606298339066434},300,null,{"$f":"21.1746741486962*Y106^0.034341245342119","v":25.756340898181563},300]
["Description","Parameter Symbol","Input                      (Enter Values Here)","Equation","Result\n(Do Not Input Here)",null,null,null,null,null,null,null,null,null,null,null,null,"Population At Risk","Consequence Rating Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.73,1]
["Population At Risk","Pop(At Risk) :",null,"Population At Risk =",{"$f":"IF(C109<>\"\",C109,\"Enter Value for Number of People at Risk\")","v":"Enter Value for Number of People at Risk"},{"$f":"23.4760266498394*E109^0.411373677682179","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,27.27,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.36,3]
["Increase Above Current\ndue to Anticipated Population Increase\n(Typically 10%)","Pop(Increse) :",null,"Increased Population At Risk =",{"$f":"IF(C111<>\"\",C111,\"Enter Value for\" & CHAR(10) & \"Incresing Population\" &CHAR(10) & \"at Risk\")","v":"Enter Value for\nIncresing Population\nat Risk"}]
[null,null,null,null,"Will Calculate"]
["Total Population At Risk","Pop(Total) :",null,"Total Population At Risk =",{"$f":"IF(C113<>\"\",C113,IF(ISNUMBER(E109)=TRUE,IF(ISNUMBER(E111)=TRUE,E109+E111,\"Enter Population Increase\"),IF(ISNUMBER(E109)=TRUE, \"Enter Direct Population At Risk\",\"Enter Direct Population and Increased Polulation at Risk\")))","v":"Enter Direct Population and Increased Polulation at Risk"}]
[null,null,null,null,"Will Calculate"]
["Consequence Rating Points for\nPopulation at Risk","CP(Pop Loss) :",null,"Consequence Rating Points for\nPopulation at Risk =",{"$f":"IF(C115<>\"\",C115, IF(ISNUMBER(E113)=TRUE,F115,\"Enter Value for Population At Risk\"))","v":"Enter Value for Population At Risk"},{"$f":"0.0000000000001*E113^6 + 0.000000000619*E113^5 - 0.000000448667*E113^4 + 0.000157738324*E113^3 - 0.028452818155*E113^2 + 2.943223183598*E113 + 31.220576679421","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,40.9,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52.27,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54.45,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59.09,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63.63,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84.09,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111.36,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122.72,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131.82,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140.9,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147.72999999999999,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,154.44999999999999,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,159.09,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,207.95,200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,238.64,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,263.64,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,281.82,500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,600]
["Advance Warning Time"]
[]
["Description","Parameter Symbol","Input                      (Enter Values Here)","Equation","Result\n(Do Not Input Here)"]
[]
["Advanced Warning Time:\nA:  Adequate = 0\nM: Marginal = 25\nI: Inadequate = 50","Warn(Advanced) :",null,{"$f":"IF(C139<>\"\",IF(ISNUMBER(C139)=TRUE,\"Input Value =\",IF(C139=\"A\",\"Adequate Warning Index Points =\",IF(C139=\"M\",\"Marginal Warning Index Points =\",IF(C139=\"I\",\"Inadequate Warning Index Points =\",\"Enter Either A,  M,  or  I\")))),\"Input\" & CHAR(10) &  \" A  for Adequate Warning\" & CHAR(10) & \"M  for Marginal Warning , or\" & CHAR(10) & \" I  for Inadequate Warning\")","v":"Input\n A  for Adequate Warning\nM  for Marginal Warning , or\n I  for Inadequate Warning"},{"$f":"IF(C139<>\"\",IF(ISNUMBER(C139)=TRUE,C139,IF(C139=\"A\",0,IF(C139=\"M\",25,IF(C139=\"I\",50,\"Input either a Direct Value, A for Adequate, M for Marginal, or I for Inadequate to Generate Notification Index Points\")))),\"Input Value for Notification Index\")","v":"Input Value for Notification Index"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30]
["Likelihhood of \nObservation and Notification\nAdequate = 0\nM: Marginal = 15\nI: Inadequate = 30","Warn(Notification) :",null,{"$f":"IF(C141<>\"\",IF(ISNUMBER(C141)=TRUE,\"Input Value =\",IF(C141=\"A\",\"Adequate Notification Index Points =\",IF(C141=\"M\",\"Marginal Notification Index Points =\",IF(C141=\"I\",\"Inadequate Notification Index Points =\",\"Enter Either A,  M,  or  I\")))),\"Input\" & CHAR(10) &   \"A  for Adequate Notification,\" & CHAR(10)& \"M for Marginal Notification , or\" & CHAR(10) & \" I  for Inadequate Notification\")","v":"Input\nA  for Adequate Notification,\nM for Marginal Notification , or\n I  for Inadequate Notification"},{"$f":"IF(C141<>\"\",IF(ISNUMBER(C141)=TRUE,C141,IF(C141=\"A\",0,IF(C141=\"M\",15,IF(C141=\"I\",30,\"Input either a Direct Value, A for Adequate, M for Marginal, or I for Inadequate to Generate Notification Index Points\")))),\"Input Value for Notification Index\")","v":"Input Value for Notification Index"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,60]
["Downstream High Ground and\nEase of Evacuation\nAdequate = 0\nM: Marginal = 10\nI: Inadequate = 20","Warn(Evacuation) :",null,{"$f":"IF(C143<>\"\",IF(ISNUMBER(C143)=TRUE,\"Input Value =\",IF(C143=\"A\",\"Adequate Evacuation Index Points =\",IF(C143=\"M\",\"Marginal Evacuation Index Points =\",IF(C143=\"I\",\"Inadequate Evacuation Index Points =\",\"Enter Either A,  M,  or  I\")))),\"Input\" & CHAR(10) &  \"A  for Adequate Evacuation,\" & CHAR(10) & \"M  for Marginal Evacuation , or\" & CHAR(10) & \"I  for Inadequate Evacuation\")","v":"Input\nA  for Adequate Evacuation,\nM  for Marginal Evacuation , or\nI  for Inadequate Evacuation"},{"$f":"IF(C143<>\"\",IF(ISNUMBER(C143)=TRUE,C143,IF(C143=\"A\",0,IF(C143=\"M\",10,IF(C143=\"I\",20,\"Input either a Direct Value, A for Adequate, M for Marginal, or I for Inadequate to Generate Notification Index Points\")))),\"Input Value for Notification Index\")","v":"Input Value for Notification Index"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,70]
[null,null,null,null,"Will Calculate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,80]
["Consequence Index Points for Advanced Warning Factors","CP(Warning) :",null,{"$f":"IF(ISNUMBER(E145)=TRUE,\"Consequence Index Points for Advanced Warning Factors =\",\"Inpute Values to Calculate Consequence Index Points\")","v":"Inpute Values to Calculate Consequence Index Points"},{"$f":"IF(C145<>\"\",C145,IF(ISNUMBER(E139)=TRUE,IF(ISNUMBER(E141)=TRUE,IF(ISNUMBER(E143)=TRUE,E139+E141+E143,\"Enter Value for Adequacy of Evacuation\"),IF(ISNUMBER(E143)=TRUE,\"Enter Value for Adequacy of Notification\",\"Enter Value for Adequacy of Evacuation & Notification\")),IF(ISNUMBER(E141)=TRUE,IF(ISNUMBER(E143)=TRUE,\"Enter Value for Adequacy of Warning Time\",\"Enter Value for Adequacy of Warning Time & Evacuation\"),IF(ISNUMBER(E143)=TRUE,\"Enter Value for Adequacy of Warning Time & Notification\", \"Enter Values for Adequacy of                Warning Time, Notification, & Evacuation\"))))","v":"Enter Values for Adequacy of                Warning Time, Notification, & Evacuation"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[]
["Downstream Property at Risk"]
[]
["Description","Parameter Symbol","Input                      (Enter Values Here)","Equation or Parameter","Result\n(Do Not Input Here)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Homes at Risk",null,"Consequence Rating Points "]
[]
[null,null,null,null,"Will Calculate"]
["Number of Homes Downstream\nat Risk from Dam Breach","Homes(Downstream) :",null,{"$f":"IF(ISNUMBER(E154)=TRUE,\"Number of Homes At Risk =\",\"Enter Value\")","v":"Enter Value"},{"$f":"IF(C154<>\"\",C154,IF(ISNUMBER(E109)=TRUE,INT(E113/3),\"Input Value for\" & CHAR(10) & \"the Number of Homes\" & CHAR(10) & \"at Risk from\" & CHAR(10) & \"Dam Breach\"))","v":"Input Value for\nthe Number of Homes\nat Risk from\nDam Breach"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,5]
[null,null,null,null,"Will Calculate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,11.818]
["Consequence Rating Points\nfor Homes at Risk","CP(Home damage) :",null,{"$f":"IF(ISNUMBER(E157)=TRUE,\"Homes At Risk Rating Points =\",\"Enter Value\")","v":"Enter Value"},{"$f":"IF(C157<>\"\",C157,IF(ISNUMBER(E154)=TRUE,IF(E154<=3,(3.409*E154) + 1.666666666667,-8.7052783174547E-11*E154^6 + 5.23569382501754E-08*E154^5 - 0.0000110469581067196*E154^4 + 0.00113609679343085*E154^3 - 0.064815547459375*E154^2 + 2.49830600596943*E154 + 5),\"Input Value for\" & CHAR(10) & \"Homes At Risk\"))","v":"Input Value for\nHomes At Risk"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,13.635999999999999]
[]
[null,null,null,null,"Will Calculate"]
["Consequence Rating Points for\nProperty Damage, \nEconomic Disruption, &  \nEnvironmental Damage\n(See Table 5)","CP(total) :",null,"Total Damage Rating Points =   ",{"$f":"IF(C160<>\"\",C160,F160)","v":0},{"$f":"IF(ISNUMBER(E162)=TRUE,IF(ISNUMBER(E164)=TRUE,IF(ISNUMBER(E166)=TRUE,IF(ISNUMBER(E168)=TRUE,IF(ISNUMBER(E170)=TRUE,IF(ISNUMBER(E172)=TRUE,IF(ISNUMBER(E174)=TRUE,G160,\"Enter a Correct Value for Wastewater Treatment Systems\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Water Delivery Systems\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Water Treatment Systems\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Water Supply Systems\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Public Transportation Links\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for State Transportation Links\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Major Transportation Links\" & CHAR(10) & \"or Enter Zero\")","v":0},{"$f":"IF(ISNUMBER(E176)=TRUE,IF(ISNUMBER(E178)=TRUE,IF(ISNUMBER(E180)=TRUE,IF(ISNUMBER(E182)=TRUE,IF(ISNUMBER(E184)=TRUE,IF(ISNUMBER(E186)=TRUE,IF(ISNUMBER(E188)=TRUE,H160,\"Enter a Correct Value for Long Term Release of Deleterious Materials from Reservoir\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Other Important Facilities\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Important Natural Resource Facilities\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Important Public Facilities\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Important Economic Facilities\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Emergency Response Facilities\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Electrical Power Facilities\" & CHAR(10) & \"or Enter Zero\")","v":0},{"$f":"IF(ISNUMBER(E190)=TRUE,IF(ISNUMBER(E192)=TRUE,IF(ISNUMBER(E194)=TRUE,E162+E164+E166+E168+E170+E172+E174+E176+E178+E180+E182+E184+E186+E188+E190+E192+E194,\"Enter a Correct Value for Short Term Damage by Deleterious Materials Released Downstream of Breach\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Long Term Damage by Deleterious Materials Released Downstream of Breach\" & CHAR(10) & \"or Enter Zero\"),\"Enter a Correct Value for Short Term Release of Deleterious Materials from Reservoir\" & CHAR(10) & \"or Enter Zero\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,17.727]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,20]
["Major Transportation Links\n (Enter Number of Items):","CP(Interstate Highways/Railway Mainlines: 25 pts.) :",0,"Interstate Highways/Railway Mainlines =                                                                                           (Summation of Items X 25)",{"$f":"IF(C162<>\"\",IF(C162=0,C162,IF(ISNUMBER(C162)=TRUE,25*C162,\"Enter Number of Items\")),\"Enter Value for Property Damage\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,8.6359999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,23.181000000000001]
["State Transportation Links:\n(Enter Number of Items):","CP(State Highway: 10 pts.) :",0,"State or County Highways  =                                                                                           (Summation of Items X 10)",{"$f":"IF(C164<>\"\",IF(C164=0,C164,IF(ISNUMBER(C164)=TRUE,10*C164,\"Enter Number of Items\")),\"Enter Value for Property Damage\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,36.363999999999997]
["Public Transportation Links:                                               (Enter ∑[(Point Value) X (# Items)]:","CP(Other Public Roads/Railway Lines: 2 - 5pts.) :",0,"Public Roads/Railway Lines  =",{"$f":"IF(C166<>\"\",IF(C166=0,C166,IF(C166>=2,IF(C166>5,\"Value Out of Range\",C166),\"Value Out of Range\")),\"Enter Value for\" & CHAR(10) & \"Property Damage\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,44.091000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,50.908999999999999]
["Water Supply Systems:                                               (Enter ∑[(Point Value) X (# Items)]:","CP(Storage Reservoirs: 10 - 75pts.) :",0,"Water Storage Reservoirs =",{"$f":"IF(C168<>\"\",IF(C168=0,C168,IF(C168>=10,IF(C168>75,\"Value Out of Range\",C168),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,55.908999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,60.454999999999998]
["Water Treatment Systems:                                               (Enter ∑[(Point Value) X (# Items)]:","CP(Treatment Facilities: 10-25pts.) :",0,"Treatment Facilities =",{"$f":"IF(C170<>\"\",IF(C170=0,C170,IF(C170>=10,IF(C170>25,\"Value Out of Range\",C170),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,64.545000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,67.727000000000004]
["Water Delivery Systems:                                                (Enter ∑[(Point Value) X (# Items)]:","CP(Water Delivery Systems: 5 - 25pts.) :",0,"Water Delivery Systems =",{"$f":"IF(C172<>\"\",IF(C172=0,C172,IF(C172>=5,IF(C172>25,\"Value Out of Range\",C172),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,71.364000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,74.545000000000002]
["Wastewater Treatment Systems:\n(Enter ∑[(Point Value) X (# Items)]:","CP(Wastewater Treatment Facilities: 5 - 25pts.) :",0,"Waste Water Treatment Systems =",{"$f":"IF(C174<>\"\",IF(C174=0,C174,IF(C174>=5,IF(C174>25,\"Value Out of Range\",C174),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Electrical Power Facilities:                                               (Enter ∑[(Point Value) X (# Items)]:","CP(Electrical Power Plants or Works: 5 - 75pts.) :",0,"Electrical Power Plants or Works =",{"$f":"IF(C176<>\"\",IF(C176=0,C176,IF(C176>=5,IF(C176>75,\"Value Out of Range\",C176),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Emergency Response Facilities:                                               (Enter ∑[(Point Value) X (# Items)]:","CP(Hospitals, Police, Fire, Emergency: 10 - 75pts.) :",0,"Hospitals, Police, Fire, Emergency =",{"$f":"IF(C178<>\"\",IF(C178=0,C178,IF(C178>=10,IF(C178>75,\"Value Out of Range\",C178),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Important Economic Facilities:\n(Enter ∑[(Point Value) X (# Items)]:","CP(Industrial/Comercial/Agricultural: 5 - 75 pts.) :",0,"Industrial/Comercial Developments =",{"$f":"IF(C180<>\"\",IF(C180=0,C180,IF(C180>=5,IF(C180>75,\"Value Out of Range\",C180),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Important Public Facilities:                                               (Enter ∑[(Point Value) X (# Items)]:","CP(Public Buildings, Schools, Libraries, etc.: 10 - 75 pts.) :",0,"Public Buildings, Schools, Libraries, ect. =",{"$f":"IF(C182<>\"\",IF(C182=0,C182,IF(C182>=10,IF(C182>75,\"Value Out of Range\",C182),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Important Natural Resource Facilities:                                               (Enter ∑[(Point Value) X (# Items)]:","CP(Fish Hatcheries: 5 - 25pts.) :",0,"Fish Hatcheries = ",{"$f":"IF(C184<>\"\",IF(C184=0,C184,IF(C184>=5,IF(C184>25,\"Value Out of Range\",C184),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Other Important Facilities:                                               (Enter ∑[(Point Value) X (# Items)]:","CP(Other Considerations ? pts.) :",0,"Other Considerations = ",{"$f":"IF(C186<>\"\",IF(C186=0,C186,IF(C186>=1,IF(C186>200,\"Value Out of Range\",C186),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Environmental Degradation\nCaused by Release of Deleterious\nMaterials from Reservoir","CP(Breach Causes Long Term Degradation: 10 - 75pts.) :",0,"Long Term Environmental Damage = ",{"$f":"IF(C188<>\"\",IF(C188=0,C188,IF(C188>=10,IF(C188>75,\"Value Out of Range\",C188),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Environmental Degradation\nCaused by Release of Deleterious \nMaterials from Reservoir","CP(Breach Causes Temporary Minor Degradation: 5 - 20pts.) :",0,"Short Term Environmental Damage = ",{"$f":"IF(C190<>\"\",IF(C190=0,C190,IF(C190>=5,IF(C190>20,\"Value Out of Range\",C190),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Environmental Degradation\nCaused by Deleterious Materials\nReleased from Storage\nDownstream of Breach","CP(Breach Causes Long Term Degradation: 10 - 75pts.) :",0,"Long Term Environmental Damage = ",{"$f":"IF(C192<>\"\",IF(C192=0,C192,IF(C192>=10,IF(C192>75,\"Value Out of Range\",C192),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[]
["Environmental Degradation\nCaused by Deleterious Materials\nReleased from Storage\nDownstream of Breach","CP(Breach Causes Temporary Minor Degradation: 5 - 20pts.) :",0,"Short Term Environmental Damage = ",{"$f":"IF(C194<>\"\",IF(C194=0,C194,IF(C194>=5,IF(C194>20,\"Value Out of Range\",C194),\"Value Out of Range\")),\"Enter Value for Property Damage\")","v":0}]
[null,null,null,null,"Will Calculate"]
["Consequence Rating Points for Total Property Damage","CP(Total Damage) :",null,{"$f":"IF(ISNUMBER(E196)=TRUE,\"Total Points for Property Damage =\",\"Enter Value\")","v":"Enter Value"},{"$f":"IF(C196<>\"\",C196,IF(ISNUMBER(E157)=TRUE,IF(ISNUMBER(E160)=TRUE,E157+E160,\"Enter Value for Other Damage Consequence Points\"),IF(ISNUMBER(E160)=TRUE,\"Enter Value to Calculate Downstream Home Damage       Consequent Points\",\"Enter Values to Determine Both Home and Other Property Damage         Consequence Points\")))","v":"Enter Value to Calculate Downstream Home Damage       Consequent Points"}]
[]
["END"]

{"sheet":"Output","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[18,6,18,7]]}
[null,null,null,"Cut & Past Bottom Table from Previous Worksheed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total Consequence Rating Points & Design Step"]
[null,null,null,"Description","Parameter Symbol","Input                      (Enter Values)","Result"]
[null,null,null,null,null,"(As Needed)"]
[null,null,null,"Annual Exceedance Probability","AEP(Annual Exceedance) :",null,"AEP =",{"$f":"DesignStep!E38","v":"Enter Values to Calculate Design Step"}]
[]
[null,null,null,"Design Step","DS :",null,"Design Step =",{"$f":"DesignStep!E40","v":"Input Values to Calculate                   Cumulative Rating Points"}]
[]
[null,null,null,"Cumulative Consequence Rating Points","Cp(cumulative) :",null,"Cumulative Rating =",{"$f":"DesignStep!E42","v":"Check the Consequence Rating Points of All Values\nIF Not  Applicable Input Zero"}]
[]
[null,null,null,"Base Consequence Rating Points","CP(Base) :",null,"Base Points =",{"$f":"DesignStep!E44","v":150}]