TITLE
COMPUTATION OF SAG AND TENSION IN MEDIUM-VOLTAGE AERIAL BUNDLED CONDUCTOR (MV ABC) USING MICROSOFT EXCEL
AUTHOR(S)
Zorica Bogićević1, Damjana Zubac1, Danijela Zubac1, Dragan Stanojević2
ABSTRACT
This study presents an applied methodology for calculating the sag and tension of medium-voltage self-supporting cable bundles (SN-SKS) using Microsoft Excel. Based on input parameters – voltage, cross-sectional area, additional load coefficient, suspension height on the pole, horizontal span between poles, temperature, and maximum allowable conductor stress – Excel automatically calculates the sag length and tension force. The results are visually presented on a separate chart sheet, allowing dynamic analysis of different scenarios. The study demonstrates that this approach enables quick verification of design solutions, optimization of the cable system design, and assessment of cable bundle safety under various operating conditions. Keywords: medium-voltage cable bundle, sag, tension, Microsoft Excel and applied analysis.
DOI
How to cite this article:
Zorica Bogićević1, Damjana Zubac1, Danijela Zubac1, Dragan Stanojević2, COMPUTATION OF SAG AND TENSION IN MEDIUM-VOLTAGE AERIAL BUNDLED CONDUCTOR (MV ABC) USING MICROSOFT EXCEL, UNITECH – SELECTED PAPERS - 2025