Building Lighting Protection Calculation (Excel)


  • Calculate Area of Building / Structure
  • Calculate Collection area of Structure
  • Calculate Probable No of Strike on Structure
  • Calculate Overall Risk Factor
  • Calculate whether Lighting Protection Required or Not
  • Calculate Number of Down Conductor


About Jignesh.Parmar
Jignesh Parmar has completed M.Tech (Power System Control), B.E(Electrical) from Gujarat University. He has more than 13 years experience in Power Transmission-Power Distribution-Electrical energy theft detection-Electrical Maintenance-Electrical Projects(Planning-Designing-coordination-Execution). He is Presently associate with one of the leading business group as a Deputy Manager at Ahmedabad,India. He is Freelancer Programmer of Advance Excel and design useful Excel Sheets of Electrical Engineering as per IS,NEC,IEC,IEEE codes. He is technical Author for "Electrical Mirror" and "Electrical India" Magazines. He is Technical Blogger and Familiar with English, Hindi, Gujarati, French languages. He wants to Share his experience & knowledge and help technical enthusiasts to find suitable solutions and updating themselves on various Engineering Topics.

14 Responses to Building Lighting Protection Calculation (Excel)

  1. Rameshkumar says:

    Thanks for your post. i need one clarification, as per calculation sheet, down conductors are not varying while changing the height of the building. Is height of the building considered for down conductors

    • Definitely Change.
      Collection Area Ac=(L x W) + 2 (L x H) + 2(W x H) + 3.14 H2
      Where H=Height of Building.
      You need to enter Proper Value of Maximum Acceptable Overall Risk Factor …

  2. nethravathi nethra says:

    Hello Sir,

    My Self is Nethra, am working in Electrical consultancy field as an Design Engineer. I need some clarification regarding FRLS wire. In Residential , Apartments all are using FRLS wire , i just wanted know what is reason behind that. Is there any IS standards for that?? Plz do the need full. Am awaiting your reply.

    Warm Regards , Nethra

  3. Eswaran.G says:

    My self is Eswaran and working in HT maintenance. I need numeric relay settings and minimum settings of relay. which one is the best among the relays.

    with regards

  4. Sony Francis says:

    Thank you very much Mr. Jignesh

    Best Regards, Sony Francis Ele. Design Engr. Kuwait National Petroleum Co.

    Sent from my iPhone


  5. R K Veerabhadra Rao says:

    Hello sir,

    ( Fourth Revision )” . It defines all wires in 2 categories FR ( Flame retardant ) & FR-LSH ( Flame retardant Low smoke and halogen) . The FRLS category is under commercially available category Between FR and FR-LHS.

  6. vengat says:

    Dear sir
    i need some clarification for arc gap in between two rods of lightning arrester that could be used for a 11 kV transmission lines
    1)The space in between two metal rod will give a capacitance effect or it will act as a resistance
    2)what standards could i follow for getting accurate results for calculation of arc in between two metal rods
    3)what will be the change in the density of arc (electrical parameters) when it sparks out from leading electrode and when it reaches the end electrode after ionising the air molecules when a lightning strike occurs directly lightning strokes and if lightning hits the transmission line( please provide guidance such that it would be useful for my carrier)

  7. Rakesh Tailor says:

    Dear Sir,

    Please mail me OHSAS practices docs or general safety required in Transmission & Distribution (rural electrification) work.

  8. Kuldeep Singh says:

    Dear Sir

  9. Kuldeep Singh says:

    Dear Sir,

    A building structure height is 95 meter and a vertical air termination lighting protection is provided at top. will it cover 95meter in circle at an angle of 45 degree…..

  10. Kuldeep Singh says:

    Dear sir,


    A building structure height is 95 meter and a vertical air termination lighting protection is provided at top. Will it cover 95 meter in circle at an angle of 45 degree..

  11. PURVESH SONI says:

    Kindly Change the heading to “Lightning”. Presently its “Lighting”

  12. ramkumar says:

    IS 2309 has been replaced by IS IEC 62305.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: