电缆电压降自动计算表格参数化.xlsx

电压降计算表一（需知功率和距离）电缆截面积S(mm2)电缆电阻r（Ω/km)电缆电抗x（Ω/km)额定电压U（kV）额定功率Pjs（kW）无功功率Qjs（Kvar)视在功率Sjs(kVA)距离L（km）功率因数cosφ电压损失ΔU﹪备 注250.7270.12370.385037.562.50.30.88.52 电缆电阻r（Ω/km)是20℃时候测定值350.5240.0330.385037.562.50.30.85.70 500.3870.03050.385037.562.50.30.84.26 700.2680.02920.385037.562.50.30.83.01 950.1930.02730.385037.562.50.30.82.22 1200.1530.02670.385037.562.50.30.81.80 1500.1240.02670.385037.562.50.30.81.50 1850.09910.0270.385037.562.50.30.81.24 2400.07540.02570.385037.562.50.30.80.98 3000.06010.02510.385037.562.50.30.80.82 4000.0470.0240.385037.562.50.30.80.68 5000.03660.0240.385037.562.50.30.80.57 6300.02830.0230.385037.562.50.30.80.47 电压降计算表二（需知电流和距离）电缆截面积mm2电缆电阻r（Ω/km)电缆电抗x（Ω/km)额定电压U（kV）电缆电流（A）距离L（km）功率因数cosφsinφ电压损失ΔU﹪备 注2.57.410.13910.38100.30.80.68.22 电缆电阻r（Ω/km)是20℃时候测定值44.610.13310.38200.30.80.610.30 63.080.12840.38320.30.80.611.12 101.830.12690.38500.30.80.610.53 161.150.12310.38630.30.80.68.56 250.7270.12370.38800.30.80.67.17 350.5240.0330.381000.30.80.66.00 500.3870.03050.381250.30.80.65.60 700.2680.02920.381600.30.80.65.07 950.1930.02730.382000.30.80.64.67 1200.1530.02670.382500.30.80.64.73 1500.1240.02670.38970.30.80.61.53 电缆电阻r（Ω/km)是20℃时候测定值1850.09910.0270.383600.30.80.64.70 2400.07540.02570.384000.30.80.64.14 3000.06010.02510.385000.30.80.64.32 4000.0470.0240.386300.30.80.64.48 5000.03660.0240.387000.30.80.64.18 6300.02830.0230.387000.30.80.63.49