Lightning Protection Calculator Excel Sheet (Risk Assessment)

Download NFPA 780 lightning protection calculator, it is also called lightning risk assessment. We will provide you with lightning protection system design calculation (excel sheet). Risk management in accordance with IEC 62305-2 (EN 62305-2) includes a risk analysis to determine whether lightning protection is required, this excel sheet will help you in this mission.

Download also: Capacitor Size Calculator for Power Factor improvement (XLS)

Lightning Protection Risk Assessment

Download Lightning Protection Calculator Excel Sheet (Risk Assessment)

Lightning risk assessment:

Risk assessment for lightning protection is important as not all buildings need lightning protection system. The above spreadsheet will help you determine Lighting Protection System (LPS) should be installed or not.

lightning protection rod

Risk Assessment formula:

There are various parameters must be taken in the design of Lightning Protection:

Nd =(Ng) x (Ae) x (C1) x 10 ^-6

Nc =(1.5 x 10^ -3) /((C2)(C3)(C4)(C5))

where:

Nd Yearly expected lightning strike frequency to the structure

Nc Tolerable lightning strike frequency to the structure

Ng Yearly average flash density in the region (fl/km2/year)

Ae Equivalent collective area of the structure (km2)

C1 Environmental coefficient

C2 Structure Coefficient

C3 Structure Contents Coefficient 

C4 Structure Occupancy Coefficient 

C5 Lightning Consequence Coefficient 

Risk Calculation:

if Nd ≤ Nc Hence, LPS May Be Optional

Nd > Nc Hence, LPS Should Be Installed

We introduced to you the free lightning protection risk assessment calculator excel sheet which depends on the NFPA 780 code (National Fire Protection Agency).