Conductor Sag and Tension Calculator

CATENARY SAG-TENSION CALCULATOR (by: Jared Cuchapin, 2
1. LINE CHARACTERISTICS
Variable Symbol Value
Span Length (Ruling Span) S 450
Conductor Name Al
Conductor Size 0
Stranding 0
Diameter dia 0
Cross-sectional Area A 0
Final Modulus of Elasticity E 0
Coefficient of Linear Thermal Expansion alpha 0
Unit Weight W.1 0
Ultimate Tensile Strength RTS 0
2. LOADING CONDITIONS
Initial Loading ( These are the conditions when the conductor was first strung.)
Initial Horizontal Tension H.1 25,000.00
Initial Conductor Temperature t.1 30
Final Loading ( These are the conditions where conductor will be subjected to win
1. Thermal Load
Conductor Temperature @ final loading t.2 90
2. Wind Load
Wind Pressure P 0
Additional Conductor Weight due to wind W.wind 0.000
3.Ice Load
Ice Thickness t 0
Ice Density density 915
Additional Conductor Weight due to ice W.ice 0.000
Resultant Conductor Weight W.2 0.000

Blowout Angle theta #DIV/0!
3. CALCULATION OF FINAL HORIZONTAL TENSION (Note: Please review the fundamental concepts of the sag-tension
website.) https://electricalengineerreso
Coefficients:
_A -25000
B 0
_C1 0
_C2 0
-1588110532166.92
Final Horizontal Tension H.2 21,594.345
STOP! Do not proceed to "results summary" until "goalseek" have been perfo
RESULTS SUMMARY:
Sags:
Initial Conductor Sag D.1 #DIV/0!
Final Conductor Sag D.2 #DIV/0!
Horizontal Sag HD.1 #DIV/0!
Vertical Sag VD.2 #DIV/0!
Conductor Lengths:
Initial Conductor Length L.1 450.000
Final Conductor Length L.2 450.000
Tensions:
Initial Horizontal Tension H.1 25,000.00
Initial Tension @ supports T.1 #DIV/0!
Final Horizontal Tension H.2 21,594.34

Final Tension @ supports T.2 #DIV/0!
TOR (by: Jared Cuchapin, 2018)
Unit
m Important: Creep is not considered in the
calculation.
m
m^2
N/m^2
/deg C
N/m
N
conductor was first strung.)

N
deg C
nductor will be subjected to wind, ice or max temperature.)
deg C
Pa (N/m^2) (Refer to applicable standards, NESC 2017 or ASCE.)

N/m
m (Refer to applicable standards, NESC 2017 or ASCE.)

kg/m^3
N/m
N/m
radians #DIV/0! degrees
tal concepts of the sag-tension to understand the foregoing equations. This is the link to my
.) https://electricalengineerresources.com/engineering_guides/
>>>>>>>>>>>
( Note: To solve the cubic equation, use the "goalseek"
command of excel. See Manual.)
Newtons
until "goalseek" have been performed.
MMARY:
m Difference ( Negative value represents Cold Uplift. )

m #DIV/0! meters
m
m
m
m
Newtons
Newtons
Newtons
Newtons
CONDUCTOR CHARACTERISTI
Code Word Size (AWG/MCM) Stranding Ultimate Strength Weight per m

kg kg/m
1 Sparrow *2 *6/1 1250 0.1357140909091
2 Arbutus 795 37 8338.4301732926 1.1100917431193
3 Quail *2/0 *6/1 2429.5454545455 0.2729195454545
4 Penguin *4/0 *6/1 3827.2727272727 0.4339868181818
5 Linnet *336.4 *26/7 6386.3636363636 0.6905013636364
6 Dove *556.5 *26/7 10181.818181818 1.1423845454545
7 Condor *795 *54/7 12954.545454545 1.5271563636364
8 Al
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
UCTOR CHARACTERISTICS
Final Modulus of Coefficient Linear

Cross-sectional Area Conductor Diameter
Elasticity N/m² Expansion Per °C
m^2 m
0.0000439 0.00802600833079346 79000000000 0.0000191
0.000403 0.0261 58000000000 0.000023
0.0000786 0.0113532459615971 79000000000 0.0000191
0.0001251 0.0142995021842934 79000000000 0.0000191
0.0001981 0.0183125063496901 75500000000 0.0000192
0.0003279 0.0235446510210302 75500000000 0.0000192
0.0004548 0.0277608452707508 59000000000 0.0000193
USER INPUT:
1. In the "Conductor_Reference" worksheet, you can add the specifications of the conductor if not in the list. These
menu in cell D6.
2. Provide other values in the orange color as applicable in your analysis.
HOW TO IMPLEMENT THE "GOALSEEK" COMMAND:

To calculate for the Final Tension, H.2, we need to solve the cubic equation. In this case, we will use the "GOALSEE
However, modern pocket calculator can solve this equation easily. (Refer to the picture below.)
1. Click D44, this is the equation to be solved.
2. Go to "DATA" Tab.
3. In the "What If Analysis" drop down menu, select "GOALSEEK".
4. A small pop-up window will appear.

4.1 Set the "To_Value" to "0".
4.2 Set the "By_Changing_Cell" to "D45" or by clicking/selecting Cell D45. Then click "OK" to begin the iteration.
5. Another window will appear "Goal Seek Status", if the "Target Value" is acceptably close to the "Current Value"
change. This value will then be used in the succeeding calculations.
Warning: Since this is a cubic equation, there are three possible roots. But usually, the other two roots are negativ
USER INPUT:
User Input ( Only this cell can be edited. )
Calculated Ouput
Notes
onductor_Reference" worksheet, you can add the specifications of the conductor if not in the list. These values are then reflec
ll D6.
other values in the orange color as applicable in your analysis.
HOW TO IMPLEMENT THE "GOALSEEK" COMMAND:

ate for the Final Tension, H.2, we need to solve the cubic equation. In this case, we will use the "GOALSEEK" command of excel.
, modern pocket calculator can solve this equation easily. (Refer to the picture below.)
44, this is the equation to be solved.
DATA" Tab.
"What If Analysis" drop down menu, select "GOALSEEK".
l pop-up window will appear.

the "To_Value" to "0".
the "By_Changing_Cell" to "D45" or by clicking/selecting Cell D45. Then click "OK" to begin the iteration.
er window will appear "Goal Seek Status", if the "Target Value" is acceptably close to the "Current Value" then click "OK". Note
his value will then be used in the succeeding calculations.
Since this is a cubic equation, there are three possible roots. But usually, the other two roots are negative and equal.

Conductor Sag and Tension Calculator

Uploaded by

Copyright:

Available Formats

Conductor Sag and Tension Calculator

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Conductor Sag and Tension Calculator

Uploaded by

Copyright:

Available Formats

CATENARY SAG-TENSION CALCULATOR (by: Jared Cuchapin, 2

Resultant Conductor Weight W.2 0.000

Final Horizontal Tension H.2 21,594.34

conductor was first strung.)

nductor will be subjected to wind, ice or max temperature.)

Pa (N/m^2) (Refer to applicable standards, NESC 2017 or ASCE.)

m (Refer to applicable standards, NESC 2017 or ASCE.)

until "goalseek" have been performed.

m Difference ( Negative value represents Cold Uplift. )

Code Word Size (AWG/MCM) Stranding Ultimate Strength Weight per m

Final Modulus of Coefficient Linear

HOW TO IMPLEMENT THE "GOALSEEK" COMMAND:

1. Click D44, this is the equation to be solved.

3. In the "What If Analysis" drop down menu, select "GOALSEEK".

4. A small pop-up window will appear.

HOW TO IMPLEMENT THE "GOALSEEK" COMMAND:

44, this is the equation to be solved.

"What If Analysis" drop down menu, select "GOALSEEK".

l pop-up window will appear.

You might also like