电工表格计算器(可计算电机电流、变压器选型、铜铝重量)

1、1、三相电机额定电流计算公式（直接输入）,功率KW,功率因数cos,电流A（中国380V电压）,电流A（德国400V电压）,2.2,0.85,3.93 ,3.74 ,颜色表达含义,3,0.85,5.36 ,5.09 ,输入,4,0.85,7.15 ,6.79 ,11,0.85,19.66 ,18.68 ,给定参数,15,0.85,26.81 ,25.47 ,22,0.85,39.33 ,37.36 ,30,0.85,53.63 ,50.94 ,45,0.85,80.44 ,76.42 ,60,0.85,107.25 ,101.89 ,输出,90,0.85,160.88 ,152.83 ,100

2、,0.85,178.75 ,169.81 ,110,0.85,196.63 ,186.80 ,2.2,0.9,3.71 ,3.53 ,3,0.9,5.06 ,4.81 ,4,0.9,6.75 ,6.42 ,11,0.9,18.57 ,17.64 ,15,0.9,25.32 ,24.06 ,22,0.9,37.14 ,35.28 ,30,0.9,50.65 ,48.11 ,45,0.9,75.97 ,72.17 ,60,0.9,101.29 ,96.23 ,90,0.9,151.94 ,144.34 ,100,0.9,168.82 ,160.38 ,110,0.9,185.70 ,176.42

3、,2、电力系统负荷计算,序号,负荷类型,Pe（KW）,Kx,Ue（V）,Cos,Pjs（KW）,Ijs（A),备注,释义,设备容量，一般是将所有设备铭牌容量相加而求得。,需用系数，是用电设备在最大负荷时需要的有功功率（Pjs计算负荷）与设备容量Pe之比。这个数值可根据负荷性质，查表求得，并根据经验对其进行修正。,额定电压,功率因数,计算负荷，是指通过负荷的统计计算求出的，用来按发热条件来选择供电系统中各元件（包括设备和线路等）的负荷值，用电单位到供电部门申报的用电功率就是指此计算功率。PjsPeKx,计算电流，其值为：IjsPjs/(1.732UeCos),用电设备的额定功率Pe是指这个设备的

4、输出功率，它与输入容量之间有一个效率n1；用电设备不一定满载工作，存在一个负荷系数Ks；用电设备组的全部设备并不同时运行，存在同时运行系数Kt；向用电设备供电的线路有损耗，存在线路效率n2。所以用电设备的有功功率需要量为 P30=Pe*Ks*Kt/(n1*n2)=Pe*Kx我们令需用系数 KxKs*Kt/(n1*n2） 需用系数的值总小于1，它不仅与设备的负荷率、效率、台数、工作情况及线路损耗有关，而且与维护管理水平等因素也有关系。,2、电力系统负荷计算,序号,负荷类型,Pe（KW）,Kx,Ue（V）,Cos,Pjs（KW）,Ijs（A),备注,1,动力,21,0.84,380,0.8,17.

5、64,33.5024918,三相,2,动力,37,0.85,380,0.8,31.45,59.73091649,三相,3,动力,690,0.85,380,0.8,586.5,1113.900875,三相,4,动力,23.4,0.85,380,0.8,19.89,37.77576881,三相,5,动力,0,0.75,380,0.8,0,0,三相,6,动力,0,0.85,380,0.8,0,0,三相,7,动力,0.8,380,0.85,0,0,三相,8,动力,0.8,380,0.85,0,0,三相,9,动力,0.8,380,0.85,0,0,三相,10,动力,0.8,380,0.85,0,0,三相

6、,合计,771.4,平均功率因数,655.48,0,1244.910052,单位,（KW）,0.82,（KW）,（A),3、变压器容量选型计算公式（直接输入）,电机总功率,总系数,视在功率（计算）,有功功率（计算）,无功功率（计算）,功率因数,选用的变压器,负荷率,颜色表达含义,Sjs,Pjs,Qjs,Cos,S,Sjs/S,输入,350,0.85,330.56 ,297.5,144.09 ,0.9,400,82.64%,360,0.85,340.00 ,306,148.20 ,0.9,400,85.00%,给定参数,370,0.85,349.44 ,314.5,152.32 ,0.9,400

7、,87.36%,380,0.85,358.89 ,323,156.44 ,0.9,400,89.72%,388,0.85,366.44 ,329.8,159.73 ,0.9,400,91.61%,输出,388,0.85,366.44 ,329.8,159.73 ,0.9,400,91.61%,690,0.85,617.37 ,586.5,192.77 ,0.95,630,97.99%,690,0.7,536.67 ,483,233.93 ,0.9,630,85.19%,690,0.6,460.00 ,414,200.51 ,0.9,630,73.02%,690,0.85,651.67 ,586

8、.5,284.05 ,0.9,630,103.44%,690,0.85,617.37 ,586.5,192.77 ,0.95,630,97.99%,4、电力系统负荷计算(将以上表2、表3整合),序号,回路编号,总功率Pe（KW）,需用系数Kx,功率因数Cos,额定电压Ue（V）,设备相数,视在功率S (KVA),计算有功功率Pjs（KW）,计算无功功率Qjs（KVar）,计算有功电流Ijs（A),选用的变压器S (KVA),负荷率Sjs/S1,37,0.85,0.8,380,三相,39.31 ,31.45 ,23.59 ,59.73 ,400 ,9.83%2,37,0.85,0.8,380,三

9、相,39.31 ,31.45 ,23.59 ,59.73 ,400 ,9.83%3,23.4,0.85,0.8,380,三相,24.86 ,19.89 ,14.92 ,37.78 ,400 ,6.22%4,23.4,0.85,0.8,380,三相,24.86 ,19.89 ,14.92 ,37.78 ,400 ,6.22%5,0,0.75,0.8,380,三相,0.00 ,0.00 ,0.00 ,0.00 ,1000 ,0.00%6,0,0.85,0.8,380,三相,0.00 ,0.00 ,0.00 ,0.00 ,400 ,0.00%7,0,0.8,0.85,380,三相,0.00 ,0.0

10、0 ,0.00 ,0.00 ,400 ,0.00%8,0,0.8,0.85,380,三相,0.00 ,0.00 ,0.00 ,0.00 ,400 ,0.00%9,0,0.8,0.85,380,三相,0.00 ,0.00 ,0.00 ,0.00 ,400 ,0.00%10,0,0.8,0.85,380,三相,0.00 ,0.00 ,0.00 ,0.00 ,400 ,0.00%合计,总负荷:Pe=120.8(KW),平均功率因数=0.82,视在功率:S=,128.35 ,有功功率:Pj=102.68(KW),无功功率:Qjs=77.01(Kvar),有功电流:Ijs=195.01337060897

11、 (A),1600 ,8.02%,5、变压器容量与其电流计算公式（直接输入）,颜色表达含义,容量KVA,高压电压KV,高压电流A,低压电压KV,低压电流A,输入,80,10,4.62 ,0.4,115.47 ,100,10,5.77 ,0.4,144.34 ,给定参数,125,10,7.22 ,0.4,180.43 ,160,10,9.24 ,0.4,230.95 ,200,10,11.55 ,0.4,288.68 ,输出,250,10,14.43 ,0.4,360.85 ,315,10,18.19 ,0.4,454.68 ,400,10,23.09 ,0.4,577.37 ,500,10,2

12、8.87 ,0.4,721.71 ,630,10,36.37 ,0.4,909.35 ,800,10,46.19 ,0.4,1154.73 ,1000,10,57.74 ,0.4,1443.42 ,1250,10,72.17 ,0.4,1804.27 ,1600,10,92.38 ,0.4,2309.47 ,2000,10,115.47 ,0.4,2886.84 ,2500,10,144.34 ,0.4,3608.55 ,3150,10,181.87 ,0.4,4546.77 ,4000,10,230.95 ,0.4,5773.67 ,5000,10,288.68 ,0.4,7217.09 ,

13、6300,10,363.74 ,0.4,9093.53 ,8000,10,461.89 ,0.4,11547.34 ,10000,10,577.37 ,0.4,14434.18 ,6、铝排计算公式（直接输入）,截面(mm),长度(米）,密度(Kg/m3),重量(公斤),单价(元/公斤),合计(元),4,40,1,2700,0.432,26,11.232,5,50,1,2700,0.675,26,17.55,6,60,1,2700,0.972,26,25.272,8,80,1,2700,1.728,26,44.928,10,100,1,2700,2.7,26,70.2,80,9,2700,0,2

14、6,0,颜色表达含义,7、铜排计算公式（直接输入）,输入,截面(mm),长度(米）,密度(Kg/m3),重量(公斤),单价(元/公斤),合计(元),4,40,1,8900,1.424,86,122.464,给定参数,5,50,1,8900,2.225,86,191.35,6,60,1,8900,3.204,86,275.544,8,80,1,8900,5.696,86,489.856,输出,10,100,1,8900,8.9,86,765.4,8900,0,86,0,8、铜线截面计算公式（直接输入）,直径(mm),截面(mm),根数,计算截面,标称截面,截面率%,2,3.14159,1,3.1

15、4159,4,78.53975,2.36,4.374349916,1,4.374349916,6,72.90583193,2.58,5.227919919,1,5.227919919,6,87.13199865,1.89,2.80551841,7,19.63862887,25,78.55451547,2,3.14159,1,3.14159,4,78.53975,2,3.14159,1,3.14159,4,78.53975,9、铜线重量计算公式（直接输入）,直径(mm),截面(mm2),根数,计算截面(mm2),长度(m),体积(m3),密度(Kg/m3),重量(公斤),单价(元/公斤),合计(元),1.8,2.5446879,1,2.5446879,150,0.000381703,8900,3.397158347,50,169.8579173,3,7.0685775,1,7.0685775,150,0.001060287,2700,2.862773888,15,42.94160831,3,7.0685775,1,7.