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.
- Click the Microsoft Office Button Office button image, and then click Excel Options.
- Click Add-Ins, and then in the Manage box, select Excel Add-ins.
- Click Go.
- In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
- Tip If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
- If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.
- 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
(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
×
![avatar johndoyle[admin]](/media/com_osmembership/avatars/62_56e81868b9b33.png){kind=small}
12 years ago
I have extended your XLC Pro subscription by 3 months by way of thanks. [Admin.]
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