Transmission Line Single Pole Analysis
 

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Description:
Calculation Preview




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
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
ASCE 7-10
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Structural Design
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
08 Mar 2016
Submitted By:
yosso
File Date:
02 Oct 2012
File Author:
Mike Jones
File Version:
1.0
File Size:
147.75 Kb
File Type:
xlsm
Downloads:
485
Rating:
stars/3.gifTotal Votes:1
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Comments  

 
#3 yosso 2017-11-04 19:35
Quoting rpick2007:
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

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
 
 
#2 rpick2007 2017-11-02 16:20
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
 
 
#1 JohnDoyle 2012-10-03 08:47
I have extended your XLC Pro subscription by 3 months by way of thanks. [Admin.]
 

Please sign in or register to add a comment.

We have 5 guests and 36 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.