Transmission Line Single Pole Analysis

0
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