Transmission Line Single Pole Analysis

(3/2)

Description


Spreadsheet 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. 

 

Calculation Reference
Snow Loads

ASCE 7-10

Structural Design

Calculation Preview

Mike Jones (yosso)
08 Mar 2016
File Size: 147.75 Kb
Downloads: 545
File Version: 1.0
File Author: Mike Jones
File Rating (3/2)

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 2
yosso 7 years ago
Rick,
It's been five years since I uploaded this workbook...and I'm no longer doing much transmission line design.
That said, the button updates the table on the TSS-1 Table worksheet with the updated cable values from the data input worksheet.
If you review the VBA code, you'll see that the code is feeding the pole heights into the calculation worksheet and then pushing the calculated values back into table.
Since the table ends at 105, you'll always get 105 in the pole length cell.
Hope that helps.
Mike
JohnDoyle[Admin] 11 years ago
I have extended your XLC Pro subscription by 3 months by way of thanks. [Admin.]
Web Analytics