Transmission Line Single Pole Analysis

Rating:
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

Submitted On:
08 Mar 2016
File Size:
147.75 Kb
Downloads:
534
File Version:
1.0
File Author:
Mike Jones
Rating:
2

 
This download is for Registered Users Only.
Perhaps you need to login or register.
Comments: 3
yosso 4 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
rpick2007 4 years ago
Please help!
I did not find any instructions for data entry with the TX pole analysis calculator. After downloading the solver was enabled and macros were enabled.
If you go to the calculation tab and put in a structure number from the pole data tab and then click on create pole table button (EFG,124 gray ) the Pole Length always resets to 105. This also happens even when the original download file data is unchanged. I presume the structure number is the left hand column of the pole data tab and is a required data entry. Is there a procedure for entering data that I need to use, or is this invalid data which crashed to calculator?
thanks
Rick
JohnDoyle[Admin] 9 years ago
I have extended your XLC Pro subscription by 3 months by way of thanks. [Admin.]