Countermeasures of Calculating and Reducing Voltage Loss with Excel

HUANG Yuqing（Architectural Design and Research Institute of Guangdong Province，Guangzhou 510010，China）

 

    Abstract：Excel is adopted to compile automatic computation sheets to calculate the voltage loss of power supply lines. The voltage loss is accurately and rapidly calculated，and the loss values under various situations are visually compared，so as to optimize the design and define the optimal power supply and distribution scheme. Based on the calculation results，such measures as adopting three-phase distribution，limiting the covering radius of floor distribution rooms，and increasing the sectional area of cables of relatively long distribution distances are proposed in order to reduce the voltage loss.

    kwords：Excel；spreadsheet；voltage loss；line drop；skin effect；three-phase power distribution；distribution distance；sectional area of the cable

 

    摘 要：采用Excel编写自动计算表格进行供电线路的电压损失计算，以准确、快速地计算线路电压损失，直观地对比各种情况下的线路电压损失数值，从而优化设计，确定最优的供配电方案。并根据计算结果，提出采用三相配电、楼层配电间的覆盖半径不宜过大、增大配电距离较长的线缆截面积等措施减少线路的电压损失。

    关键词：Excel；电子表格；电压损失；线路电压降；集肤效应；三相配电；配电距离；线缆截面积

     中图分类号：TU852                文献标识码：A

     doi：10. 3969 / j. issn. 1003 - 8493. 2019. 06. 007