{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Nc","Nd","Result"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":23,"n_cols":1,"rows_kept":23}
["Instructions for Using this Calculator"]
["(exclude sheet if printing workbook as a calculation)"]
[]
["General"]
["This calculator supports risk-based decision-making on installation of a lighting protection system per NFPA 780 Annex L;"]
["where Annex L assessment is that an LPS is recommended, LANL requires it (per ESM Ch. 7 Section D5090)"]
[]
["User Action"]
["By entering the correct data in the cyan (bluish) cells in the next two sheets (tabs),"]
["the result will appear in the last (Result) tab."]
[]
["Specifically, for each box that contains cyan cells, enter a 1 in the most appropriate selection (except for building"]
["dimensions where actual dimenstions are required)"]
[]
["Warning"]
["Yellow cells are outputs; do not alter them -- nor any other non-cyan cell."]
[]
["Tabs Requiring Input"]
["Nc tab calculates the \"acceptability\" of lightning strikes to the structure"]
["Nd tab calculates the yearly likelihood of a lightning strike to the structure"]
[]
["Results"]
["After the Nc and Nd sheets have all correct input data, the result will appear on the Result tab"]

{"sheet":"Nc","index":1,"n_rows":41,"n_cols":20,"rows_kept":41,"merged":[[13,15,13,16],[15,4,15,8],[22,3,22,10],[23,15,23,16],[25,15,25,16],[26,15,26,16],[30,3,30,10],[31,15,31,16],[33,15,33,16],[36,3,36,11],[38,15,38,16],[39,15,39,16],[40,15,40,16]]}
["Calculation for:"]
[]
[]
[null,"Nc Calculation Sheet (acceptability factor of lightning strikes to the structure)"]
[]
["Key to cell shading:",null,"Inputs","For each box that contains cyan cells, enter a 1 in the most appropriate selection.  "]
[null,null,"Outputs","Yellow cells are outputs; do not alter them -- nor any other non-cyan cell."]
[]
[null,"RESULT:  ","Nc = ",{"$f":"0.0015/B13","v":6.0000000000000006E-4}]
[]
[null,null,"Where Nc =","1.5 * 10e-3 / C"]
[]
["C = ",{"$f":"B18*B26*B32*B38","v":2.5},"where C = C2 * C3 * C4 * C5"]
[{"$nulls":15},"Guidance (does not print)"]
[{"$nulls":6},"Structure and Roof Materials"]
[{"$nulls":4},"Roof (Columns below)",{"$nulls":11},"Roof (Box's Columns) Guidance"]
[{"$nulls":3},"Structure (Rows)","Metal",null,"Nonmetallic",null,"Combustible",{"$nulls":6},"Structure Material (Box's Rows) Guidance/Examples","Metal: Sloped standing seam, Pro-Panel, other types"]
["C2 = ",{"$f":"E18*F18+E19*F19+E20*F20+G18*H18+G19*H19+G20*H20+I18*J18+I19*J19+I20*J20","v":0.5},null,"Metal",0.5,1,1,null,2,{"$nulls":6},"Pre-engineered buildings, ARMAGs, containers, sheds, garages, transportables","Nonmetallic: Most roofs at LANL (low-slope membrane, single or multi-ply)"]
[{"$nulls":3},"Nonmetallic",1,null,1,null,2.5,{"$nulls":6},"Concrete, masonry, stucco-on-stud","Combustible: Not allowed in new construction"]
[{"$nulls":3},"Combustible",2,null,2.5,null,3,{"$nulls":6},"Wood (not common at LANL)"]
[]
[]
[{"$nulls":3},"Structure Contents",{"$nulls":11},"Structure Contents Guidance/Examples"]
[{"$nulls":3},"Low Value and noncombustible",{"$nulls":6},0.5,{"$nulls":4},"Many sheds, bus stops, general storage."]
[{"$nulls":3},"Standard value and noncombustible",{"$nulls":6},1,{"$nulls":4},"Office buildings, many shops, some laboratories"]
["C3 = ",{"$f":"K24*L24+K25*L25+K26*L26+K27*L27+K28*L28","v":2},null,"High value, moderate combustibility",{"$nulls":6},2,1,{"$nulls":3},"Some laboratories, structures with very expensive or hard to replace items."]
[{"$nulls":3},"Exceptional value, flammable liquids, computer or electronics",{"$nulls":6},3,{"$nulls":4},"Buildings on Historic Register, irreplaceable eqiupment, programmatic processes like PF-4, DARHT & LANSCE beamlines, mag lab generator; other mission-critical contents, supercomputers like SCC, records centers."]
[{"$nulls":3},"Exceptional value, irreplaceable cultural items",{"$nulls":6},4,{"$nulls":4},"Not expected, but if so designated by project's customer."]
[]
[]
[{"$nulls":3},"Occupancy",{"$nulls":11},"Structure Occupancy Guidance"]
["C4 = ",{"$f":"K32*L32+K33*L33+K34*L34","v":0.5},null,"Unoccupied",{"$nulls":6},0.5,1,{"$nulls":3},"Many sheds, carports, bus stops, storage, small garages.   Includes \"Incidental Occupancy\" per ESM Ch 16 IBC-GEN’s Prefab subsection:  \"Occupied for a total of less than 2 hours/day, yearly average. Not the same as incidental use (IBC sec. 509 term relating to certain adjunct uses).\""]
[{"$nulls":3},"Normally occupied",{"$nulls":6},1,{"$nulls":4},"Office buildings, some lab spaces"]
[{"$nulls":3},"Difficult to evacuate or risk of panic",{"$nulls":6},3,{"$nulls":4},"Buildings with > 300 person auditoriums or high-rises (occupied floor located more than 75 feet above the lowest level of fire dept vehicle access), underground or limited-access structures."]
[]
[]
[{"$nulls":3},"Lightning Consequence",{"$nulls":11},"Lightning Consequence Guidance/Examples"]
["C5 = ",{"$f":"M38*N38+M39*N39+M40*N40","v":5},null,"Continuity of facility services not required, no environmental impact",{"$nulls":8},1,null,null,"Most of LANL (except types below).",null,"COOP:",null,"https://int.lanl.gov/org/ddops/alddpp/emergency/coop.shtml"]
[{"$nulls":3},"Continuity of facility services required, no environmental impact",{"$nulls":8},5,1,null,"Emergency Operations center.  LDCC.  Facilities on Continuity of Operations list and/or having an MDI score and cost causing it to be ML-3 (AP-341-502, FM01 Instructions, Field 2.3 Criterion 4 & 5).",null,"APs:",null,"https://coe.lanl.gov/APs/AllAPs/Forms/APbyNumber.aspx"]
[{"$nulls":3},"Consequences to the environment",{"$nulls":8},10,null,null,"Where lightning damage could affect the environment.  Ex.:  WETF, PF-4, other HC-2 and -3 nuclear facilities (LPS required by DOE-STD-1020 anyway); explosives (LPS required by DOE-STD-1212 anyway) large hazardous chemical supplies (rare at LANL)",null,"MDI:",null,"https://int.lanl.gov/org/ddops/aldfo/mss/data/index.shtml"]
[{"$nulls":15},"MDI is a 1–100 score calculated for each facility to measure its impact to the mission by combining the consequences if the facility was lost, the difficulty to replace it, and the interdependency of it to other facilities. MDI also links assets to the core capabilities they support which provides greater insight for understanding risks. LANL’s MSS Data Group postsMDI  scores for existing facilities and probable score of proposed ones.  "]

{"sheet":"Nd","index":2,"n_rows":23,"n_cols":13,"rows_kept":23,"merged":[[18,3,18,12]]}
[]
["Nd Calculation Sheet",null,"(Nd = yearly likelihood of a lightning strike to the structure or object)"]
[]
["Key to cell shading:",null,"Inputs","For each box that contains cyan cells, enter a 1 in the most appropriate selection.  "]
[null,null,"Outputs","Yellow cells are outputs; do not alter them -- nor any other non-cyan cell."]
[]
["RESULT of inputs below:",null,null,"Nd =",{"$f":"B9*G13*L18/1000000","v":6.6057929838550967E-4},null,"where Nd = ","Ng * Ad * Cd *10e-6"]
[]
["Ng =",3,"Lightning ground flash density in flashes / km^2 / year (per ESM Ch. 7 Section D5090 r6 and later editions)"]
[]
["Ad calculation (equivalent collection area of the structure in m^2)"]
["Enter dimensions in cyan cells"]
[null,"Ft.","meters",null,{"$f":"C14*C15+6*C16*(C14+C15)+PI()*9*C16*C16","v":{"v":440.3861989236731,"d":"440"}},"RESULT:",{"$f":"E13","v":{"v":440.3861989236731,"d":"440"}}]
["L",30,{"$f":"B14 * 12 / 39.37","v":{"v":9.144018288036577,"d":"9"}}]
["W",5.5,{"$f":"B15 * 12 / 39.37","v":{"v":1.6764033528067057,"d":"2"}}]
["H",9.5,{"$f":"B16 * 12 / 39.37","v":{"v":2.8956057912115827,"d":"3"}}]
[]
["Cd calculation (environmental coefficient)",{"$nulls":9},"RESULT:",{"$f":"L20*M20+L21*M21+L22*M22+L23*M23","v":0.5}]
[{"$nulls":3},"Location factor, environmental coefficient"]
[null,null,"Structure surrounded by taller structures or trees within a distance of 3H",{"$nulls":8},0.25]
[null,null,"Structure surrounded by structures of equal or lesser height within a distance of 3H",{"$nulls":8},0.5,1]
[null,null,"Isolated structure, with no other structures located within a distance of 3H",{"$nulls":8},1]
[null,null,"Isolated structure on hilltop",{"$nulls":8},2]

{"sheet":"Result","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[6,0,10,3]]}
[null,null,"Result of Calculation"]
[]
[null,"Nd",{"$f":"Nd!E7","v":{"v":6.6057929838550967E-4,"d":"0.00066"}},"(populates from that tab)"]
[null,"Nc",{"$f":"Nc!D9","v":{"v":6.0000000000000006E-4,"d":"0.00060"}},"(populates from that tab)"]
[null,"The greater is:",{"$f":"IF(C3>C4,\"Nd\",\"Nc\")","v":"Nd"}]
[]
["If Nd is greater (than Nc), a lightning protection system is recommended by NFPA 780, thus required by LANL."]
[]
[]
[]
[]
["LANL ESM Chapter 7, Section D5090"]
["Lightning Protection NFPA 780 Annex L Calculator v1.01, 2023-5-4"]