{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":238,"n_cols":19,"rows_kept":238,"cut":false,"hidden":false,"merged":[[23,15,23,16],[24,15,24,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[31,15,31,16],[39,9,39,14],[181,12,182,12],[181,13,182,13],[181,14,182,15],[184,12,185,12],[184,13,185,13],[184,14,185,15],[175,12,176,12],[175,13,176,13],[175,14,176,15],[178,12,179,12],[178,13,179,13],[178,14,179,15],[193,12,194,12],[193,13,194,13],[193,14,194,15],[196,14,196,15],[187,12,188,12],[187,13,188,13],[187,14,188,15],[190,12,191,12],[190,13,191,13],[190,14,191,15],[169,13,170,13],[169,14,170,15],[172,12,173,12],[172,13,173,13],[172,14,173,15],[169,2,169,3],[169,4,169,5],[169,6,169,7],[169,8,169,9],[169,10,169,11],[169,12,170,12],[147,12,148,12],[147,13,148,13],[147,14,148,15],[150,14,150,15],[162,1,167,1],[162,2,164,5],[162,6,164,11],[162,12,167,12],[162,13,167,13],[162,14,167,15],[165,2,167,3],[165,4,167,5],[165,6,167,7],[165,8,167,9],[165,10,167,11],[141,12,142,12],[141,13,142,13],[141,14,142,15],[144,12,145,12],[144,13,145,13],[144,14,145,15],[135,12,136,12],[135,13,136,13],[135,14,136,15],[138,12,139,12],[138,13,139,13],[138,14,139,15],[129,12,130,12],[129,13,130,13],[129,14,130,15],[132,12,133,12],[132,13,133,13],[132,14,133,15],[123,12,124,12],[123,13,124,13],[123,14,124,15],[126,12,127,12],[126,13,127,13],[126,14,127,15],[123,2,123,3],[123,4,123,5],[123,6,123,7],[123,8,123,9],[123,10,123,11],[116,13,121,13],[116,14,121,15],[119,2,121,3],[119,4,121,5],[119,6,121,7],[119,8,121,9],[119,10,121,11],[114,1,115,7],[116,1,121,1],[116,2,118,5],[116,6,118,11],[116,12,121,12],[23,1,23,5],[7,0,7,19],[6,0,6,19],[9,0,9,19],[10,0,10,19],[13,0,16,1],[8,0,8,19],[11,0,11,10],[12,0,12,10],[25,1,25,5],[24,1,24,5],[26,1,26,5],[103,16,104,16],[103,17,104,19],[106,16,107,16],[106,17,107,19],[109,14,109,15],[65,9,65,10],[63,6,64,7],[0,0,0,2],[1,0,1,2],[62,10,62,11],[62,12,62,13],[5,0,5,10],[2,0,2,2],[3,0,3,2],[4,0,4,10],[62,2,62,3],[62,4,62,5],[62,8,62,9],[39,2,40,3],[13,2,16,10],[30,1,30,5],[31,1,31,5],[0,3,3,10],[63,9,64,9],[27,1,27,5],[28,1,28,5],[88,16,89,16],[88,17,89,19],[91,16,92,16],[94,16,95,16],[94,17,95,19],[79,16,80,16],[79,17,80,19],[82,16,83,16],[82,17,83,19],[85,16,86,16],[85,17,86,19],[73,17,74,19],[76,17,77,19],[76,16,77,16],[42,7,42,13],[63,2,64,3],[63,4,64,5],[97,16,98,16],[97,17,98,19],[100,16,101,16],[100,17,101,19],[91,17,92,19],[21,7,21,8],[21,0,21,3],[73,16,74,16],[50,12,50,13],[70,17,71,19],[62,14,62,15],[62,17,62,19],[63,11,64,11],[63,13,64,13],[63,14,63,15],[64,17,65,19],[67,16,68,16],[67,17,68,19],[64,16,65,16],[63,1,64,1],[70,16,71,16],[62,6,62,7],[45,11,45,14],[45,15,45,16]]}
[null,null,null,"NUREG 2180  Event Tree Spreadsheet for Area-wide Fire Detection. Version 2180.0 (English Units)."]
[]
[]
[]
[]
[]
["The following calculations estimate the non-suppression probability for using areawide smoke detection."]
["Parameters in YELLOW CELLS are Entered by the User."]
["Parameters in GREEN CELLS are Automatically Selected from the DROP DOWN MENU."]
["All subsequent output values are calculated by the spreadsheet and based on values specified in the input parameters.  This spreadsheet is protected "]
["and secure to avoid errors due to a wrong entry in a cell(s).  The chapter in the NUREG should be read before an analysis is made."]
[]
[]
["Project / Inspection Title:"]
[]
[]
[]
[]
[]
[]
[]
["INPUT PARAMETERS"]
[]
[null,"Detection System Unavailability/Unreliability Probability",null,null,null,null,"β",null,null,null,null,null,null,null,null,{"$f":"IF(R24=\"ENTER VALUE\",\"\",IF(R24<0,\"WARNING value must be between 0 and 1\",IF(R24>1,\"WARNING value must be between 0 and 1\",\"\")))","v":""},null,1,"β"]
[null,"Fraction of Fires that DO NOT have an Incipient Stage",null,null,null,null,"α",null,null,null,null,null,null,null,null,"",null,1,"α"]
[null,"System In-Effectiveness",null,null,null,null,"τ",null,null,null,null,null,null,null,null,null,null,1,"τ"]
[null,"Human Error Probability for MCR Operator Response",null,null,null,null,"μ",null,null,null,null,null,null,null,null,{"$f":"IF(R27=\"ENTER VALUE\",\"\",IF(R27<0,\"WARNING value must be between 0 and 1\",IF(R27>1,\"WARNING value must be between 0 and 1\",\"\")))","v":""},null,1E-4,"μ"]
[null,"Human Error Probability for Field Operator Response \n NOTE: DEFAULT VALUE",null,null,null,null,"ξ",1,null,null,null,null,null,null,null,{"$f":"IF(R28=\"ENTER VALUE\",\"\",IF(R28<0,\"WARNING value must be between 0 and 1\",IF(R28>1,\"WARNING value must be between 0 and 1\",\"\")))","v":""},null,1,"ξ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H36=\"\",1,EXP(-H32*L36))","v":1},"π2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R31<0,\"WARNING value must be between 0 and 1\",IF(R31>1,\"WARNING value must be between 0 and 1\",\"\"))","v":""}]
[null,"Electrical non-suppression rate parameter (λ[Electrical])",null,null,null,null,null,9.8000000000000004E-2,null,null,null,null,null,null,null,{"$f":"IF(R32<0,\"WARNING value must be between 0 and 1\",IF(R32>1,\"WARNING value must be between 0 and 1\",\"\"))","v":""},null,{"$f":"IF(R40<1,1,O151)","v":1},"η1"]
[null,"Enhanced non-suppression rate parameter (λ[1-π3])",null,null,null,null,null,0.19400000000000001,null,null,null,null,null,null,null,{"$f":"IF(R33<0,\"WARNING value must be between 0 and 1\",IF(R33>1,\"WARNING value must be between 0 and 1\",\"\"))","v":""},null,{"$f":"IF(O179=0,1,IF((O179)<0.001,0.001,O179))","v":1},"η2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L232=\"Yes\",IF(L228=\"Yes\",(R38+R42*(1-R38)),R42),1)","v":1},"η3"]
[]
[null,null,null,null,null,null,null,"Enter Time to Target Damage (Minutes):"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H36<0,0,H36)","v":0}]
[null,null,null,null,null,null,null,"Is there a redundant automatic fire detection system protecting the electrical enclosure?",null,null,null,null,null,null,null,null,null,"Failure Probability"]
[null,null,null,null,null,null,null,null,null,null,"Select Item",null,null,null,null,null,null,{"$f":"IF(H40=\"N/A\",1,IF(H40=\"\",1,IF(H40>L36,1,S38)))","v":1},1]
[null,null,null,null,null,null,null,"Enter time for redundant automatic fire detection response",null,null,null,null,null,null,null,null,null,"Time (Minutes):"]
[null,null,"Conventional Suppression",null,null,null,null,null,null,{"$f":"IF(H40=\"N/A\",\"\",IF(H40<0,\"WARNING time to detection must be greater than 0 minutes\",IF(H40>L36,\"WARNING time to detection > time to damage\",\"\")))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H40=\"\",L36,IF(H40<0,\"N/A\",H40))","v":0}]
[null,null,null,null,null,null,null,"Is there an automatic fire suppression system protecting target of interest?",null,null,null,null,null,null,null,null,null,"Automatic Suppression Failure Probability"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,"Is the automatic suppression system dependant on the redundant automatic detection system?"]
[]
[null,null,null,null,null,null,null,"Is there manual fixed supression?",null,null,null,null,null,null,null,null,null,"Manual Fixed Suppression Failure Probability"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R46=\"ENTER VALUE\",\"\",IF(R46<0,\"WARNING value must be between 0 and 1\",IF(R46>1,\"WARNING value must be between 0 and 1\",\"\")))","v":""},null,1]
[]
[]
[]
[null,null,"RESULTS"]
[null,null,null,null,null,null,null,"Total Non-Suppression Probability:",null,null,null,null,{"$f":"Q110","v":1},null,null,"Calculate"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Area-wide"]
[null,"Fire","Detector System Availability, Reliability",null,"Fraction of Fires that have an Incipient Stage",null,"System Effecitve Detecting Incipient Stage",null,"Successful MCR Response",null,"Successful Field Operator Response (Fire Watch Posted)",null,"Enhanced Suppression",null,"Conventional Detection / Suppression",null,null,"End State"]
[null,"λi x  SF","1-β",null,"1-α",null,"1-τ",null,null,"1-μ",null,"1-ξ",null,"1-π2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N66*L66*J66*H66*F66*D66","v":0},"Cabinet Damage"]
[null,null,null,{"$f":"1-D99","v":0},null,{"$f":"1-F93","v":0},null,{"$f":"1-H87","v":0},null,{"$f":"1-J81","v":0.99990000000000001},null,{"$f":"1-L75","v":0},null,{"$f":"1-N69","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"π2",null,"1-η3",{"$f":"N69*L66*J66*H66*F66*D66*P69","v":0},"Cabinet Damage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R29<0,1,IF(R29>1,1,R29))","v":1},null,{"$f":"1-P72","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"η3",{"$f":"P72*N69*J66*H66*F66*D66*L66","v":0},"Fire Damage Outside Cabinet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R33<0,1,IF(R33>1,1,R33))","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ξ",null,null,null,"1-η2",{"$f":"L75*J66*H66*F66*D66*P75","v":0},"Cabinet Damage"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R28<0,1,IF(R28>1,1,R28))","v":1},null,null,null,{"$f":"1-P78","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"η2",{"$f":"L75*J66*H66*F66*D66*P78","v":0},"Fire Damage Outside Cabinet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R32<0,1,IF(R32>1,1,R32))","v":1}]
[]
[null,null,null,null,null,null,null,null,null,"μ",null,null,null,null,null,"1-η1",{"$f":"P81*J81*H66*F66*D66","v":0},"Cabinet Damage"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(R27<0,1,IF(R27>1,1,R27))","v":1E-4},null,null,null,null,null,{"$f":"1-P84","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"η1",{"$f":"P84*J81*H66*F66*D66","v":0},"Fire Damage Outside Cabinet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R31<0,1,IF(R31>1,1,R31))","v":1}]
[]
[null,null,null,null,null,null,null,"τ",null,null,null,null,null,null,null,"1-η2",{"$f":"P87*H87*F66*D66","v":0},"Cabinet Damage"]
[null,null,null,null,null,null,null,{"$f":"IF(R26<0,1,IF(R26>1,1,R26))","v":1},null,null,null,null,null,null,null,{"$f":"1-P90","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"η2",{"$f":"P90*H87*F66*D66","v":0},"Fire Damage Outside Cabinet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R32<0,1,IF(R32>1,1,R32))","v":1}]
[]
[null,null,null,null,null,"α",null,null,null,null,null,null,null,null,null,"1-η2",{"$f":"P93*F93*D66","v":0},"Cabinet Damage"]
[null,null,null,null,null,{"$f":"IF(R25<0,1,IF(R25>1,1,R25))","v":1},null,null,null,null,null,null,null,null,null,{"$f":"1-P96","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"η2",{"$f":"P96*F93*D66","v":0},"Fire Damage Outside Cabinet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R32<0,1,IF(R32>1,1,R32))","v":1}]
[]
[null,null,null,"β",null,null,null,null,null,null,null,null,null,null,null,"1-η1",{"$f":"P99*D99","v":0},"Cabinet Damage"]
[null,null,null,{"$f":"IF(R24<0,1,IF(R24>1,1,R24))","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"1-P102","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"η1",{"$f":"P102*D99","v":1},"Fire Damage Outside Cabinet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R31<0,1,IF(R31>1,1,R31))","v":1}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pr(non-supp)=",null,{"$f":"IF((Q71+Q77+Q83+Q89+Q95+Q101)<0.001,0.001,(Q71+Q77+Q83+Q89+Q95+Q101))","v":1}]
[]
[]
[]
[]
[null,"Event Tree For η1"]
[]
[null,"Fire","Automatic",null,null,null,"Manual",null,null,null,null,null,"Sequence","End State","Pr (Non-Suppression)"]
[]
[]
[null,null,"Detection",null,"Suppression",null,"Detection",null,"Fixed",null,"Fire Brigade"]
[]
[]
[]
[null,"FI","AD",null,"AS",null,"MD",null,"MF",null,"FB",null,"F","OK"]
[null,1,{"$f":"1-C137","v":0},null,{"$f":"1-E128","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"G","OK"]
[null,null,null,null,{"$f":"R42","v":1},null,null,null,{"$f":"1-R46","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"H","OK"]
[null,null,null,null,null,null,null,null,{"$f":"R46","v":1},null,{"$f":"1-K134","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"I","NS",{"$f":"K134*I131*E128*C125*B125","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H40>=L36,1,IF((EXP(-H31*(L36-H40)))<0.001,0.001,(EXP(-H31*(L36-H40)))))","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"J","OK"]
[null,null,{"$f":"IF(L236=\"Yes\",R38,IF(L232=\"Yes\",0,1))","v":1},null,{"$f":"1-E140","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"K","OK"]
[null,null,null,null,{"$f":"IF(L232=\"Yes\",IF(L228=\"Yes\",1,R42),1)","v":1},null,{"$f":"IF(L36>15, 1, 0)","v":0},null,{"$f":"1-R46","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"L","OK"]
[null,null,null,null,null,null,null,null,{"$f":"R46","v":1},null,{"$f":"1-K146","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","NS",{"$f":"K146*I143*G140*E140*C137*B125","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R40=\"N/A\",1,IF((L36>(R40+15)),IF((EXP(-H31*(L36-R40-15)))<0.001,0.001,(EXP(-H31*(L36-R40-15)))),1))","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"N","NS",{"$f":"G149*E140*C137*B125","v":1}]
[null,null,null,null,null,null,{"$f":"IF(L36>15, 0, 1)","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"O148+O145+O133","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Event Tree For η2"]
[null,"Fire","Automatic",null,null,null,"Manual",null,null,null,null,null,"Sequence","End State","Pr (Non-Suppression)"]
[]
[]
[null,null,"Detection",null,"Suppression",null,"Detection",null,"Fixed",null,"Fire Brigade"]
[]
[]
[]
[null,"FI","AD",null,"AS",null,"MD",null,"MF",null,"FB",null,"F","OK"]
[null,1,1,null,{"$f":"1-E174","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"G","OK"]
[null,null,null,null,{"$f":"R42","v":1},null,null,null,{"$f":"1-R46","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"H","OK"]
[null,null,null,null,null,null,null,null,{"$f":"R46","v":1},null,{"$f":"1-K180","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"I","NS",{"$f":"K180*I177*E174*C171*B171","v":1}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(EXP(-H31*(L36))<0.001,0.001,EXP(-H31*(L36)))","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"J","OK"]
[null,null,0,null,{"$f":"1-E186","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"K","OK"]
[null,null,null,null,{"$f":"IF(L232=\"Yes\",IF(L228=\"Yes\",1,R42),1)","v":1},null,{"$f":"IF(L36>15, 1, 0)","v":0},null,{"$f":"1-R46","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"L","OK"]
[null,null,null,null,null,null,null,null,{"$f":"R46","v":1},null,{"$f":"1-K192","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","NS",{"$f":"K192*I189*G186*E186*C183*B171","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R40=\"N/A\",1,IF((L36>(R40+15)),IF((EXP(-H31*(L36-R40-15)))<0.001,0.001,(EXP(-H31*(L36-R40-15)))),1))","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"N","NS",{"$f":"G195*E186*C183*B171","v":0}]
[null,null,null,null,null,null,{"$f":"IF(L36>15, 0, 1)","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"O194+O191+O179","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Detector System Availability, Reliability",null,null,null,null,null,null,null,null,null,null,null,"Automatic Suppression"]
["Select Detector Type",1,null,null,null,"Select Detector Type",1,null,null,"Select Cabinet Type",1,null,"Select suppression system","Select Technology"]
["ASD Very Early Warning",3.5999999999999999E-3,null,null,null,"VEWFD SS",0.56999999999999995,null,null,"Low Voltage Control Cabinet",0.28000000000000003,null,"Carbon dioxide",0.04]
["Spot",0.05,null,null,null,"ASD VEWFD CC",0.32,null,null,"Power Cabinet",0.5,null,"Halon systems",0.05]
["User Defined","Enter Value",null,null,null,"ASD VEWFD LS2",0.11,null,null,"User Defined","Enter Value",null,"Wet pipe sprinkler systems",0.02]
[null,null,null,null,null,"Spot ION",0.81,null,null,null,null,null,"Deluge or preaction sprinkler systems",0.05]
["Select Application","SA","SA",null,null,null,null,null,null,"Automatic Detection",null,null,"User Defined","Enter Value"]
["Air Return Grill","AR",null,null,null,"Select Detector Type",1,null,null,"Select Detector Type",1]
["Ceiling","CE",null,null,null,"ASD VEWFD CC",0.3,null,null,"VEWFD ASD",3.5999999999999999E-3]
["User Defined","UD",null,null,null,"ASD VEWFD LS2",0.52,null,null,"Spot-Type detection System",0.05]
[null,null,null,null,null,null,null,null,null,"User Defined","Enter Value"]
["Select Cabinet Ventilation",0,0]
["Any",1,0,null,null,"Default Enhanced Non-Suppression [1.0]",1]
["Select Cabinet Ventilation",0,0,null,null,"User Defined","Enter Value",null,null,"CheckBox5 Ticker"]
["HVAC In Room",1,null,null,null,null,null,null,null,"1=True"]
[null,null,null,null,null,null,null,null,null,"0=False"]
["Default HEP Vaule [1x10-4]",1E-4]
["User Defined","Enter Value",null,null,null,"AutoDetection",null,null,null,"Checkbox3 Ticker"]
[null,null,null,null,null,"Select",1,null,null,"1=True"]
[null,null,null,null,null,"Smoke / Heat",0.05,null,null,"0=False"]
[null,null,null,null,null,"User Define","Enter Value"]
[null,null,null,null,null,null,null,null,null,"Checkbox1 Ticker"]
[null,null,null,null,null,null,null,null,null,"1=True"]
[null,null,null,null,null,null,null,null,null,"0=False"]