电气工程量计算表格（成套自动计算）.xls

变压器容量计算表 名称 组别额定功率输入容量需要系数功率因数功率因数正切有功功率无功功率视在功率低压额定电流10kV额定电流有功功率同期系数(0.80.9)无功功率同期系数(0.930.97)无功功率补偿率用电设备Pe(kW)S(kV.A)KxcostgPjs(kW)Qjs(kvar)Sjs(kV.A)Ijs(A)Igs(A)KpKqqc1#照明及电热344.000.750.800.75258.00193.50322.502#照明及电热302.000.750.800.75226.50169.88283.13办公及商住楼240.000.700.800.75168.00126.00210.00自动扶梯30.000.600.501.7318.0031.1836.00厨房电力120.000.700.701.0284.0085.70120.00电梯112.000.400.501.7344.8077.6089.60防排烟风机42.000.900.800.7537.8028.3547.25卷帘门48.000.600.701.0228.8029.3841.140.000.701.020.000.000.000.000.701.020.000.000.000.000.701.020.000.000.000.000.701.020.000.000.000.000.701.020.000.000.000.000.701.020.000.000.000.000.701.020.000.000.000.000.701.020.000.000.00合计1238.00865.90741.581140.05同时系数0.740.90779.31704.501050.541596.140.900.95电容补偿448.350.58电容补偿后0.950.33779.31256.15820.331246.36功率损耗8.2041.02总计0.840.94787.51297.16841.711278.853016000kV.A容量变压器10001443.3857.74变压器负荷率0.75 0.850.84变压器应选容量为:10001000kV.A无功补偿容量为:448448 kvarkvar用电设备组名称Kxcostg单独传动的金属加工机床：小批生产的金属冷加工机床0.120.160.51.73大批生产的金属冷加工机床0.170.20.51.73小批生产的金属热加工机床0.20.250.550.61.511.33大批生产的金属热加工机床0.250.30.651.17锻锤、压床、剪床及其它锻工机械0.250.61.33木工机械(木加工车间内)0.20.30.50.61.731.33液压机0.30.61.33生产用通风机0.750.850.80.850.750.62卫生用通风机0.650.70.80.75泵、活塞型压缩机、电动发电机组0.750.850.80.75球磨机、破碎机、筛选机、搅拌机等0.750.860.80.850.750.62电阻炉（带调压器或变压器）：非自动装料0.60.70.950.980.330.2自动装料0.40.60.950.980.330.2干燥箱、加热器等0.70.910工频感应电炉（不带无功补偿装置）0.80.352.67高频感应电炉（不带无功补偿装置）0.80.61.33焊接和加热用高频加热设备0.50.650.71.02熔炼用高频加热设备0.80.850.80.850.750.62表面淬火电炉(带无功补偿装置)：电动发电机0.650.71.02真空管振荡器0.80.850.62中频电炉(中频机组)0.650.750.80.75氢气炉(带调压器或变压器)0.40.50.850.90.620.48真空炉(带调压器或变压器)0.550.650.850.90.620.48电弧炼钢炉变压器0.90.850.62电弧炼钢炉的辅助设备0.150.51.73点焊机(非电子行业)、缝焊机0.350.61.33电子行业点焊机0.20.61.33对焊机0.350.71.02自动弧焊变压器0.50.51.73单头手动弧焊变压器0.350.352.68多头手动弧焊变压器0.40.352.68单头直流弧焊机0.350.61.33多头直流弧焊机0.70.71.02金属、机修、装配车间、锅炉房起重机(=25%)0.1 0.150.51.73铸造车间用起重机(=25%)0.150.30.51.73联锁的连续运输机械0.650.750.88非联锁的连续运输机械0.50.60.750.88一般工业用硅整流装置0.50.71.02电镀用硅整流装置0.70.80.75电解用硅整流装置0.70.80.75红外线干燥设备0.850.910电火花加工装置0.50.61.33超声波装置0.70.71.02X光设备0.30.551.52电子计算机主机(中频机组)0.60.70.80.75电子计算机外部设备0.40.50.51.73试验设备(仪表为主)0.150.20.71.02试验设备(电热为主)0.20.40.80.75磁粉探伤机0.20.42.29铁屑加工机械0.40.750.88木工机械一般木材加工0.20.651.17筛砂机0.60.71.02称量车0.150.51.73阀门0.180.51.73静电除尘器0.80.80.75硒整流器0.70.71.02稳压器0.60.71.02插头设备0.150.250.71.02排气台0.50.70.90.48老炼台0.60.70.71.02陶瓷隧道窑0.80.90.950.33拉单晶炉0.70.750.90.48赋能腐蚀设备0.60.930.4真空浸渍设备0.70.950.33科研机构的实验室及实习工厂总的电力负荷0.10.20.70.81.020.75大专院校的实验室及实习工厂总的电力负荷0.10.20.70.81.020.75一般医疗插座0.20.80.75给水泵和排水泵0.80.850.62循环水泵、油泵0.80.80.75剪板机0.20.40.51.73振动机0.60.70.650.751.171.02卷扬机0.550.60.80.75冷冻机0.650.750.80.75窗式空调器0.70.80.80.75洗衣房电力0.650.750.51.73厨房电力0.50.70.80.75实验室电力0.20.40.70.81.020.75医院电力0.40.50.80.75洗衣机0.40.51.73绞肉机、磨碎机0.70.80.75照明用电设备Kx表建筑类别Kx建筑类别Kx 生产厂房(有天然采光)0.80.9 宿舍区0.60.8 生产厂房(无天然采光)0.91 医院0.5 办公楼0.70.8 食堂0.90.95 设计室0.90.95 商店0.9 科研楼0.80.9 学校0.60.7 仓库0.50.7 展览馆0.70.8 锅炉房0.9 旅馆0.60.7照明用电设备cos、tg表光源类别costg光源类别costg 白炽灯、卤钨灯10 高压钠灯0.451.98 荧光灯（无补偿）0.551.52 金属卤化物灯 0.40.612.291.29 荧光灯（有补偿）0.90.48 镝灯0.521.6 高压水银灯0.450.65 1.981.16 氙灯0.90.48S9-M-10/0.4kV变压器损耗计算Seb变压器容量Pk空载有功损耗Pd短路有功损耗Sjs低压侧计算负荷Qk空载有功损耗Qd短路有功损耗Ik空载电流比Ud%阻抗电压比Pb有功损耗Qb无功损耗300.130.60.00.841.22.840.10.8500.170.870.01.2522.540.21.3630.21.040.01.5122.522.442.41.5800.251.250.01.763.22.240.31.81000.291.50.02.142.140.32.11250.341.80.02.55240.32.51600.42.20.03.046.41.940.43.02000.482.60.03.681.840.53.62500.563.050.04.25101.740.64.33150.673.650.05.0412.61.640.75.04000.84.30.06161.540.86.05000.965.10.07201.441.07.06301.26.20.08.1928.351.34.51.28.28001.47.50.09.6361.24.51.49.610001.710.30.011451.14.51.711.012501.9512.80.012.556.2514.52.012.516002.414.50.014.4720.94.52.414.4已知设计数据中间计算结果计算结果SZ-M-10/0.4kV变压器损耗计算Seb变压器容量Pk空载有功损耗Pd短路有功损耗Sjs低压侧计算负荷Qk空载有功损耗Qd短路有功损耗Ik空载电流比Ud%阻抗电压比Pb有功损耗Qb无功损耗2000.332.60.01.880.940.31.82500.43.050.02.25100.940.42.33150.483.650.02.5212.60.840.52.54000.574.30.02.8160.740.62.85000.685.10.03.5200.740.73.56300.816.20.04.09528.350.654.50.84.18000.987.50.04.8360.64.51.04.810001.1510.30.05.5450.554.51.25.512501.35120.06.2556.250.54.51.46.316001.6814.50.08720.54.51.78.020001.9517.150.010900.54.52.010.025002.2820.30.012.5112.50.54.52.312.5已知设计数据中间计算结果计算结果SG10-10/0.4kV变压器损耗计算Seb变压器容量Pk空载有功损耗Pd短路有功损耗Sjs低压侧计算负荷Qk空载有功损耗Qd短路有功损耗Ik空载电流比Ud%阻抗电压比Pb有功损耗Qb无功损耗1000.41.880.00.840.840.40.81600.542.550.01.286.40.840.51.32000.623.10.01.680.840.61.62500.723.60.01.75100.740.71.83150.884.60.02.20512.60.740.92.24000.975.40.02.4160.641.02.45001.166.60.03200.641.23.06301.297.90.03.7837.80.661.33.88001.529.50.04480.561.54.010001.7611.40.05600.561.85.012502.0812.50.06.25750.562.16.316002.4413.90.08960.562.48.020003.3217.50.081200.463.38.02500420.30.0101500.464.010.0已知设计数据中间计算结果计算结果变压器低压侧母线出三相短路电流估算变压器额定容量Se（kVA）变压器低压的额定电压Ue（kV）变压器的阻抗电压百分数 Uk（）变压器低压的额定电流Ie（A）变压器低压侧母线出三相短路电流估算值Id（kA）6300.44.5909.326720.2摘自现代建筑 电气技术设计文集Id=Ie/Uk%Ie=Se/（1.732xUe）Id=100 xSe/(1.732xUexUk)其中：Se-变压器额定容量 kVAIe-变压器低压的额定电流 AUe-变压器低压的额定电压 VUk-变压器的阻抗电压百分数Id-变压器低压侧母线出三相短路电流 AUk含义可以理解为：1.当变压器的低压侧为额定电流时发生短路，高压侧电压为额定电压的百分数2.10/0.4lkV变压器低压侧三相短路电流为其 额定电流的1/Uk%倍，即：Id=Ie/Uk%3.110/10kV变压器10kV侧短路容量为其 额定容量的1/Uk%倍，即：Sd=Se/Uk%假定条件：1.10kV侧线缆阻抗忽略不计，短路容量无穷大，这样短路电流大小仅取决于前级变压器容量的大小。2.0.4kV侧的变压器保护主断路器和低压母线上的阻抗也 不加考虑，使低压母线三相短路电流也仅取决于10/0.4kV 变压器容量的大小。3.不考虑低压侧电动机和补偿电容器等的反馈电流对短路 电流的正面影响。电动机启动时母线电压计算 Uqm1.经验公式估算法Uqm100（KiqSed+Sjh）/Sdm Sdm=100Seb/uk启动电动机的全电压启动时的起动电流倍数Kiq启动电动机的额定容量Sed（kVA）变压器低压侧其他负荷容量Sjh（kVA）变压器额定容量Seb（kVA）变压器阻抗电压uk（）变压器低压母线上的三相短路容量Sdm（kVA）电动机启动电压计算 Uqm3132150315478756.9设计数据常规参数计算结果电动机启动时端电压计算 Uqd1.经验公式估算法Uqm100（KiqSed+Sjh）/SdmKiqPedLUxSdm=100Seb/uk启动电动机的全电压启动时的起动电流倍数Kiq启动电动机的额定容量Sed（kVA）变压器低压侧其他负荷容量Sjh（kVA）变压器额定容量Seb（kVA）变压器阻抗电压uk（）变压器低压母线上的三相短路容量Sdm（kVA）电动机启动电压计算 Uqm31321503154787518.9电动机额定功率Ped（kW）电动机供电线路长度 L（km）每千瓦公里单位电压损失Ux（）1000.20.2设计数据常规参数计算结果无功功率补偿率qc表补偿前cos1补偿后cos20.700.750.800.820.840.860.880.900.920.940.302.160 2.298 2.430 2.482 2.534 2.586 2.640 2.695 2.7542.8170.351.656 1.795 1.926 1.978 2.030 2.083 2.137 2.192 2.2502.3130.401.271 1.409 1.541 1.593 1.645 1.698 1.752 1.807 1.8651.9280.450.964 1.103 1.235 1.287 1.339 1.391 1.445 1.500 1.5591.6220.500.712 0.850 0.982 1.034 1.086 1.139 1.192 1.248 1.3061.3690.520.622 0.761 0.893 0.945 0.997 1.049 1.103 1.158 1.2171.2800.540.538 0.677 0.809 0.861 0.913 0.965 1.019 1.074 1.1331.1960.560.459 0.598 0.729 0.781 0.834 0.886 0.940 0.995 1.0531.1160.580.384 0.523 0.655 0.707 0.759 0.811 0.865 0.920 0.9791.0420.600.313 0.451 0.583 0.635 0.687 0.740 0.794 0.849 0.9070.9700.620.245 0.384 0.515 0.567 0.620 0.672 0.726 0.781 0.8390.9030.640.180 0.319 0.451 0.503 0.555 0.607 0.661 0.716 0.7750.8380.660.118 0.256 0.388 0.440 0.492 0.545 0.599 0.654 0.7120.7750.680.058 0.196 0.328 0.380 0.432 0.485 0.539 0.594 0.6520.7150.700.138 0.270 0.322 0.374 0.427 0.480 0.536 0.5940.6570.720.082 0.214 0.266 0.318 0.370 0.424 0.480 0.5380.6010.740.027 0.159 0.211 0.263 0.316 0.369 0.425 0.4830.5460.760.105 0.157 0.209 0.262 0.315 0.371 0.4290.4920.780.052 0.104 0.156 0.209 0.263 0.318 0.3760.4390.800.052 0.104 0.157 0.210 0.266 0.3240.3870.820.052 0.105 0.158 0.214 0.272 18.8170.840.053 0.106 0.162 0.2200.2830.860.054 0.109 0.1670.2300.880.055 0.1140.1770.900.0580.1210.920.0630.940.960.981.002.888 2.977 3.1802.385 2.473 2.6762.000 2.088 2.2911.693 1.781 1.9851.440 1.529 1.7321.351 1.440 1.6431.267 1.356 1.5591.188 1.276 1.4791.113 1.201 1.4051.042 1.130 1.3330.974 1.062 1.2650.909 0.998 1.2010.847 0.935 1.1380.787 0.875 1.0780.729 0.817 1.0200.672 0.761 0.9640.617 0.706 0.9090.563 0.652 0.8550.511 0.599 0.8020.458 0.547 0.7500.406 0.495 0.6980.354 0.443 0.6460.302 0.390 0.5930.248 0.337 0.5400.193 0.281 0.4840.134 0.223 0.4260.071 0.160 0.363利利用用系系数数法法平平均均照照度度计计算算表表序序号号房房间间名名称称照照度度标标准准灯灯具具光光源源类类型型光光通通量量（kW）房房间间尺尺寸寸维维护护系系数数长长度度（米米）宽宽度度（米米）1 1单单管管日日光光灯灯1x36x36W220022006 63 30.70.72 2节节能能日日光光灯灯1x13x13W590590363615150.70.73 3节节能能日日光光灯灯1x8x8W280280363615150.70.73 3单单管管日日光光灯灯1x30 x30W46004600363615150.70.74 4双双管管日日光光灯灯2x202x20W17601760363615150.70.75 5金金属属卤卤素素灯灯1xZJD10 xZJD100W60006000454515150.70.76 6金金属属卤卤素素灯灯1xZJD15xZJD150W1150011500101020200.70.77 7金金属属卤卤素素灯灯1xZJD175xZJD175W140001400015156 60.660.668 8金金属属卤卤素素灯灯1xZJD25xZJD250W2050020500636344440.70.79 9金金属属卤卤素素灯灯1xZJD40 xZJD400W3600036000101020200.70.71010金金属属卤卤素素灯灯1xZJD100 xZJD1000W110000110000101020200.70.71111白白炽炽灯灯1x60 x60W540540101020200.70.71212白白炽炽灯灯1x40 x40W297297101020200.70.71313白白炽炽灯灯1x100 x100W11001100101020200.70.71414高高压压汞汞灯灯1xGGY8xGGY80W34003400101020200.70.71515高高压压汞汞灯灯1xGGY125xGGY125W60006000101020200.70.71616高高压压汞汞灯灯1xGGY175xGGY175W85008500101020200.70.71717高高压压汞汞灯灯1xGGY25xGGY250W1300013000101020200.70.71818高高压压汞汞灯灯1xGGY40 xGGY400W2300023000101020200.70.71919高高压压汞汞灯灯1xGGY100 xGGY1000W5850058500101020200.70.72020高高压压钠钠灯灯1xNG7xNG70W51605160101020200.70.72121高高压压钠钠灯灯1xNG10 xNG100W81808180101020200.70.72222高高压压钠钠灯灯1xNG15xNG150W1335013350101020200.70.72323高高压压钠钠灯灯1xNG25xNG250W2314023140101020200.70.72424高高压压钠钠灯灯1xNG40 xNG400W4180041800101020200.70.72525高高压压钠钠灯灯1xNG100 xNG1000W106800106800101020200.70.72626高高压压钠钠灯灯1xNGG25xNGG250W1869018690101020200.70.72727高高压压钠钠灯灯1xNGG40 xNGG400W3115031150101020200.70.72828混混光光灯灯3600036000101020200.70.7灯灯数数n利利用用系系数数水水平平照照度度2 20.70119.78119.7854540.6024.7824.7854540.6011.7611.7654540.60193.2193.254540.6073.9273.9248480.60179.2179.210100.60241.5241.53 30.55169.4169.442420.70152.20152.2010100.6075675610100.602310231010100.6011.3411.3410100.606.2376.23710100.6023.123.110100.6071.471.410100.6012612610100.60178.5178.510100.6027327310100.6048348310100.601228.51228.510100.60108.36108.3610100.60171.78171.7810100.60280.35280.3510100.60485.94485.9410100.60877.8877.810100.602242.82242.810100.60392.49392.4910100.60654.15654.1510100.60756756