please show me the spreadsheet for sag calculation of transmission line tower.

Electrical tools (MS Excel Spreadsheets)

This section is dedicated to tools every electrical engineer can use in daily work. These spreadsheets below will make your job much more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size and so on.

Spreadsheets are mostly developed by expirienced electrical engineers and programmers (thank you mr. Jignesh Parmar!) and by well known manufacturers of electrical equipment. They all really did an awsome job, you must admit!


June 6/13/05IEEE TP&C Tutorial

What happens when the conductor weight changes?
•Bare weight of Drake ACSR is 1.094 lb/ft•Iced weight is:
–1.094 + 1.244*1.0*(1.108+1.0) = 3.60 lb/ft
•Tension increases by a factor of 3.6 unless the length of the conductor changes.