Development of a Template for the Risk Assessment for Lightning Protection System Design based on

MS IEC 62305: Protection Against Lightning standard serves as the main reference for lightning risk assessment and lightning protection design and installation in Malaysia. Lightning risk assessment is complex and complicated to be used manually. A computer tool or software could simplify the work in lightning risk assessment. A template was developed in Microsoft Excel for lightning risk assessment. The development focused on features such as user-friendly interface, multiple zone and service calculation capability, comprehensive, informative, and able to suggest protection measures. All calculations and parameters for risk calculation were identified from MS IEC 62305-2: Risk Management. The calculations and interactive user interface were made using Excel's built in functions and coding in VBA. The template was validated through comparison of results between the template, MS IEC 62305-2, and other software such as SIRAC and RISK in three different case studies. In all three case studies, the template achieves results similar to the results in IEC 62305-2.