Creating Antenna Patterns using the 3D-360 degree plot accepting phased verticals spreadsheet

Instructions for use are included at the top of the spreadsheet, but are repeated here for reference purposes.

The sheet provides a chart display and also allows 0 dB values to be inserted if required in the Azimuth and Elevation data columns.

Actual Azimuth and Elevation gain data can be entered at 10° intervals by ignoring the 5° columns and leaving them at Blank. The 10° values will be interpolated.

Enter datasheet Azimuth gain data in the Green area with the plot being displayed on the Green chart. Make sure that you enter your actual antenna Azimuth gain at 0°.

Enter datasheet Elevation gain data in the Blue area with the plot being displayed on the Blue chart.

To save Full Azimuth and Elevation data use 'Ctrl+Q to copy the 'yellow + tan' data area to the clipboard

Paste into Notepad, and save as ''your_name.ant', using 'All Files' option.

To generate an Omni Azimuth pattern, enter the same gain into all Green area cells - but if the Elevation plot has its maximum gain below 0°, make sure you enter the Elevation pattern 0° gain value as the Azimuth gain!

6) Check that your elevation data at 0° and 180° are the same value - if not a full 360° Azimuth pattern will have to be entered to allow for this.