首页|基于Excel架空导线载流量计算软件的设计与实现

基于Excel架空导线载流量计算软件的设计与实现

扫码查看
针对线路选型过程中手动计算核验导线载流量效率低下的问题,基于 Excel 及 VB6.0 平台设计了一款架空导线载流量计算软件.该软件通过选择导线类型、确定执行标准、输入对应的导线参数及环境参数,即可快速自动输出计算所得允许最高工作温度和短时最高工作温度范围内的导线载流量.经过实例验证,该软件操作便利、计算准确、输出结果可视化且图形清晰直观,可为导线载流量核验、线路导线选型、线路增容改造提供技术支持.
Design and Implementation of a Software for Calculating the Current-Carrying Capacity of Overhead Conductor Based on Excel
In view of the low efficiency of manual calculation and verification of conductor current-carrying capacity in the course of line selection,a software for calculating the current-carrying capacity of overhead conductor based on Excel and VB 6.0 platform is designed.Through selecting the conductor types,determining the execution standards,and inputting the corresponding conductor parameters and environmental parameters,the software can quickly and automatically output the calculated conductor current-carrying capacity within the range of maximum allowable working temperature and short-term maximum working temperature.After practical verification,the software has the advantages of convenient operation,accurate calculation,visualized output results,and clear and intuitive graphics.It can provide technical support for conductor carrying-capacity verification,line conductor selection,and line capacity expansion and transformation.

overhead conductorcurrent-carrying capacity calculationdesign verificationExcel VBA programmingdata processing

孟祥辉、杨立军、黎汉林、施鑫、孙乐雨、侯岩、崔佳宇、丁启凡

展开 >

江苏亨通电力特种导线有限公司,江苏 苏州 215234

架空导线 载流量计算 设计校核 Excel VBA编程 数据处理

2024

光纤与电缆及其应用技术
中国电子科技集团公司第二十三研究所

光纤与电缆及其应用技术

影响因子:0.209
ISSN:1006-1908
年,卷(期):2024.(2)