High Mast Light Pole Design Spreadsheet

The CivilWeb High Mast Light Pole Design spreadsheet uses the design procedure contained in ILE Technical Report 7 to analyze high mast light poles between 10m and 60m high. The design suite also includes a 75 page Ultimate User Guide explaining in detail the calculations used in the spreadsheet and the design parameters required. The design suite also includes a High Mast Light Pole Foundation Design spreadsheet and some typical foundation details in AutoCAD format.

The spreadsheet includes unique design tools including graphs showing at a glance the sensitivity of the key design parameters including mast height and diameter, wind area and material properties. This allows the user to quickly optimize the high mast light pole design to suit any site conditions and head assembly arrangements. This spreadsheet suite is the quickest and easiest to use design tool on the market today for high mast light pole design.

High Mast Light Pole Design Procedure

The design of high mast light poles in the UK is generally undertaken in accordance with ILE Technical Report 7. This is suitable for lighting high masts between 10m and 60m high of either circular cross section or regular polygonal cross section with more than 16 sides.

The CivilWeb High Mast Light Pole Design Spreadsheet first calculates the bending moment capacity of the high mast light pole. It does this using the geometrical and material properties information input by the user. The section plastic modulus can be calculated by the spreadsheet automatically or can be input by the user for non-standard sections. The spreadsheet then calculates the bending moment capacity at the base of the high mast light pole.

High Mast Light Pole Design - Wind Loading

Next the CivilWeb High Mast Light Pole Design Spreadsheet calculates the wind pressure acting on the mast. The spreadsheet uses the BS 6399-2 methodology as this is the method used in ILE Technical Report 7 and is considered generally equivalent to more modern methods such as the BS EN 1991-1-4 method. The user is able to use default wind velocity data for over 35 urban centres or can input site specific wind velocity data using the wind velocity map included with the spreadsheet.

The wind velocity is then used to estimate the wind pressure acting on the high mast light pole and the head assembly and lanterns. The CivilWeb High Mast Light Pole Design Spreadsheet uses the procedure contained within ILE Technical Report 7 which is the industry standard guidance for high mast light pole design.

The CivilWeb High Mast Light Pole Design Spreadsheet uses this information to perform a check on whether the high mast light pole specified will be adequate to withstand the forces imposed on the high mast light pole, the head assembly and the lanterns from the wind.

High Mast Light Pole Foundation Design Spreadsheet

The CivilWeb High Mast Light Pole Design Spreadsheet suite includes a design tool for designing the concrete foundations required. The user simply inputs the overturning moment and the ground bearing capacity into the spreadsheet which then returns a standard foundation size and reinforcement details. The overturning moment can be taken either from the CivilWeb High Mast Light Pole Design Spreadsheet or in some cases can be taken from the high mast light pole manufacturer's information. The design suite also includes standard foundation details in AutoCAD.

Get the full license version now for only £20. This includes;

  • Full license version of the CivilWeb High Mast Light Pole Design Spreadsheet
  • Free comprehensive 75 page Ultimate User Guide.  This includes detailed information and typical values for all the required inputs and an explanation of the design standards and principles used in the spreadsheet.
  • Additional high mast light pole foundation design spreadsheet including three standard foundation types
  • AutoCAD drawing of standard foundation details.

All purchases are covered by our full money back guarantee.

License Type

Or why not bundle the CivilWeb High Mast Light Pole Design Spreadsheet with our Street Light Foundation Design Spreadsheet for only £5 extra?

License Type

Download Free Trial Version

To try out a fully functional free trail version of this software, please Click Here or enter your email address below to sign up to our newsletter.