Transmission Line Single Pole Analysis

0
(Last Updated On: March 11, 2016)
Transmission Line Single Pole AnalysisSpreadsheet to analyze single wood pole structures for horizontal and vertical loading.

CONDUCTOR DATA
SIZE  (kcmils or inch)
STRANDING
MATERIAL
DIAMETER (inch)
WEIGHT (lb/ft)
RATED STRENGTH (lbs)
DESIGN LOADING
NESC DISTRICT
ICE
WIND w/ICE
CONSTANT K
HEAVY ICE
HEAVY ICE w/WIND (4 psf)
HIGH WIND (NO ICE)
HIGH WIND ON STR.
Wind for Overturning Chk
SAG & TENSION DATA
NESC HEAVY
CONDUCTOR TENSION
OPGW TENSION
 

Note: This calculation uses the Solver add-in which ships with Excel To use the Solver Add-in, however, you first need to load it in Excel.

  1. Click the Microsoft Office Button Office button image, and then click Excel Options.
  2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.
  3. Click Go.
  4. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
  5. Tip    If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
  6. If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.
  7. After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab. 
Download
Code

Transmission Line Single Pole Analysis
Become a 
VIP Member to see this content