基于EXCEL软件煤矿供电计算公式程序设计

Program Design of Calculation Formula of Coal Mine Power Supply based on EXCEL Software

通过EXCEL办公软件和标幺值短路电流计算原理相结合,设计出一套公式程序,将井上、下复杂的短路电流、继电保护整定形成较为固定的模式程序公式,只需用输入已知参数,程序将自动完成系统短路电流、继电保护定值计算。此程序操作简单,计算结果准确,提高了煤矿机电人员的技术水平与工作效率,避免煤矿供电保护装置出现拒动、误动及越级跳闸等现象。

Through the combination of EXCEL office software and standard unit short-circuit current calculation principle,a set of formula program is designed,which forms a relatively fixed mode program formula for complex short-circuit current and relay protection setting above and below the well.With the input of known parameters,the program will automatically complete the calculation of system short-circuit current and relay protection setting value.This program is easy to operate and the calculation result is accurate,which improves the technical level and work efficiency of coal mine mechanical and electrical personnel,and avoids the phenomenon of refusing to operate,maloperation and override trip of coal mine power supply protection device.