Skip to content

Electrical Engineer Resources

Free resources for students and Electrical Practitioners

Menu
  • Posts Directory
  • Transmission & Distribution
    • Steel Pole Design
    • Substation Design Guides
  • Pinoy Electrical Engineer
    • Philippines Codes and Standards
    • Electrical Engineering Practice
    • Technical References – Downloads
  • Philippine Electrical Code 2017
    • PEC 2017
  • Your Cart
  • Purchases
Menu

Sag-Tension Spreadsheet Free Calculator (Even and Uneven Supports Elevation)

Posted on October 19, 2018

In addition to the free “even elevation sag-tension spreadsheet”, here is another excel spreadsheet wherein uneven elevation of supports is integrated. Also, I added a “macro code” for the ease of the user. In the previous calculator, the user will have to encounter the “goal seek” command but by using the “macro” capabilities of excel the user will just click the command button and focus more on the simulation.

The user should  understand first the fundamental concepts of sag-tension so that he can appreciate the equations and the result.

HERE ARE FEATURES OF THE CALCULATOR:

  1. The user can add the conductor specifications when it is not available in the database.
  2. The variables names are shown and used in the formula. This advanced excel feature, allows the user to easily pinpoint the possible errors in the formula. Formulas are protected so that accidental edit would not lead to erroneous result.
  3. There are helpful diagrams and formulas to guide the user.

Go ahead and try it out!

Update: Try also the conductor Sag and Tension Calculator with different load cases to determine the which case will produce the maximum sag. Click this link to that post.

Comment below what are the possible improvements you want to include in the future.

Icon
Conductor Sag and Tension Calculator – Even and Uneven Elevation 1190 downloads 929.32 KB

₱500.00

Table of Contents

  • HERE ARE FEATURES OF THE CALCULATOR:
  • ₱500.00

Recent Posts

  • Example 2: Pole Loading Analysis of Angled Structure based on NESC 2017
  • Transmission Line Failure Due To Increase In Conductor Tension
  • Example 1: Pole Loading Analysis of Tangent Structure based on NESC 2017
  • Loading Analysis of Transmission and Distribution Structures based on NESC 2017
  • 10 Measurable Benefits of Hot-Dip Galvanizing Transmission Structures
©2023 Electrical Engineer Resources | Design: Newspaperly WordPress Theme