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

1 1、三三相相电电机机额额定定电电流流计计算算公公式式（直直接接输输入入）功率KW功率因数cos电流A（中国380V电压）电流A（德国400V电压）2.20.853.933.7430.855.365.0940.857.156.79110.8519.6618.68150.8526.8125.47220.8539.3337.36300.8553.6350.94450.8580.4476.42600.85107.25101.89900.85160.88152.831000.85178.75169.811100.85196.63186.802.20.93.713.5330.95.064.8140.96.756.42110.918.5717.64150.925.3224.06220.937.1435.28300.950.6548.11450.975.9772.17600.9101.2996.23900.9151.94144.341000.9168.82160.381100.9185.70176.422 2、电电力力系系统统负负荷荷计计算算序号负荷类型Pe（KW）KxUe（V）释义设备容量，一般是将所有设备铭牌容量相加而求得。需用系数，是用电设备在最大负荷时需要的有功功率（Pjs计算负荷）与设备容量Pe之比。这个数值可根据负荷性质，查表求得，并根据经验对其进行修正。额定电压2 2、电电力力系系统统负负荷荷计计算算序号负荷类型Pe（KW）KxUe（V）1动力210.843802动力370.853803动力6900.853804动力23.40.853805动力00.753806动力00.853807动力0.83808动力0.83809动力0.838010动力0.8380合计771.4单位（KW）3 3、变变压压器器容容量量选选型型计计算算公公式式（直直接接输输入入）电机总功率总系数视在功率（计算）有功功率（计算）无功功率（计算）SjsPjsQjs3500.85330.56297.5144.093600.85340.00306148.203700.85349.44314.5152.323800.85358.89323156.443880.85366.44329.8159.733880.85366.44329.8159.736900.85617.37586.5192.776900.7536.67483233.936900.6460.00414200.516900.85651.67586.5284.056900.85617.37586.5192.774 4、电电力力系系统统负负荷荷计计算算(将将以以上上表表2 2、表表3 3整整合合)序号回路编号总功率Pe（KW）需用系数Kx功率因数Cos1370.850.82370.850.8323.40.850.8423.40.850.8500.750.8600.850.8700.80.85800.80.85900.80.851000.80.85合合计计总总负负荷荷:Pe=120.8(KW):Pe=120.8(KW)平平均均功功率率因因数数=0.82=0.825 5、变变压压器器容容量量与与其其电电流流计计算算公公式式（直直接接输输入入）容量KVA高压电压KV高压电流A低压电压KV低压电流A80104.620.4115.47100105.770.4144.34125107.220.4180.43160109.240.4230.952001011.550.4288.682501014.430.4360.853151018.190.4454.684001023.090.4577.375001028.870.4721.716301036.370.4909.358001046.190.41154.7310001057.740.41443.4212501072.170.41804.2716001092.380.42309.47200010115.470.42886.84250010144.340.43608.55315010181.870.44546.77400010230.950.45773.67500010288.680.47217.09630010363.740.49093.53800010461.890.411547.341000010577.370.414434.186 6、铝铝排排计计算算公公式式（直直接接输输入入）截面(mm)长度(米）密度(Kg/m3)重量(公斤)440127000.432550127000.675660127000.972880127001.72810100127002.7809270007 7、铜铜排排计计算算公公式式（直直接接输输入入）截面(mm)长度(米）密度(Kg/m3)重量(公斤)440189001.424550189002.225660189003.204880189005.69610100189008.9890008 8、铜铜线线截截面面计计算算公公式式（直直接接输输入入）直径(mm)截面(mm)根数计算截面标称截面23.1415913.1415942.364.37434991614.37434991662.585.22791991915.22791991961.892.80551841719.638628872523.1415913.14159423.1415913.1415949 9、铜铜线线重重量量计计算算公公式式（直直接接输输入入）直径(mm)截面(mm2)根数计算截面(mm2)长度(m)1.82.544687912.544687915037.068577517.068577515037.068577517.068577515037.068577517.068577515023.1415913.14159120023.1415913.141591200颜色表达含义输入给定参数输出CosPjs（KW）Ijs（A)功率因数计算负荷，是指通过负荷的统计计算求出的，用来按发热条件来选择供电系统中各元件（包括设备和线路等）的负荷值，用电单位到供电部门申报的用电功率就是指此计算功率。PjsPeKx计算电流，其值为：IjsPjs/(1.732UeCos)CosPjs（KW）Ijs（A)0.817.6433.50249182 2、电电力力系系统统负负荷荷计计算算2 2、电电力力系系统统负负荷荷计计算算0.831.4559.730916490.8586.51113.9008750.819.8937.775768810.8000.8000.85000.85000.85000.8500平均功率因数655.481244.9100520.82（KW）（A)功率因数选用的变压器负荷率CosSSjs/S0.940082.64%0.940085.00%0.940087.36%0.940089.72%0.940091.61%0.940091.61%0.9563097.99%0.963085.19%0.963073.02%0.9630103.44%0.9563097.99%额定电压Ue（V）设备相数视在功率S(KVA)计算有功功率Pjs（KW）380三相39.3131.45380三相39.3131.45380三相24.8619.89380三相24.8619.894 4、电电力力系系统统负负荷荷计计算算(将将以以上上表表2 2、表表3 3整整合合)380三相0.000.00380三相0.000.00380三相0.000.00380三相0.000.00380三相0.000.00380三相0.000.00视视在在功功率率:S=:S=128.35128.35有有功功功功率率:Pj=102.68(KW):Pj=102.68(KW)颜颜色色表表达达含含义义单价(元/公斤)合计(元)2611.2322617.552625.2722644.9282670.2260颜颜色色表表达达含含义义单价(元/公斤)合计(元)86122.46486191.3586275.54486489.85686765.4860截面率%78.5397572.9058319387.1319986578.5545154778.5397578.53975体积(m3)密度(Kg/m3)重量(公斤)单价(元/公斤)0.00038170389003.397158347500.00106028727002.862773888150.00106028727005150.00106028727002.862773888150.003769908890033.5521812600.003769908890033.552181260备注用电设备的额定功率Pe是指这个设备的输出功率，它与输入容量之间有一个效率n1；用电设备不一定满载工作，存在一个负荷系数Ks；用电设备组的全部设备并不同时运行，存在同时运行系数Kt；向用电设备供电的线路有损耗，存在线路效率n2。所以用电设备的有功功率需要量为P30=Pe*Ks*Kt/(n1*n2)=Pe*Kx我们令需用系数 KxKs*Kt/(n1*n2）需用系数的值总小于1，它不仅与设备的负荷率、效率、台数、工作情况及线路损耗有关，而且与维护管理水平等因素也有关系。备注三相三相三相三相三相三相三相三相三相三相颜颜色色表表达达含含义义输入给定参数输出计算无功功率Qjs（KVar）计算有功电流Ijs（A)选用的变压器S(KVA)负荷率Sjs/S23.5959.734009.83%23.5959.734009.83%14.9237.784006.22%14.9237.784006.22%0.000.0010000.00%0.000.004000.00%0.000.004000.00%0.000.004000.00%0.000.004000.00%0.000.004000.00%无无功功功功率率:Qjs=77.01(Kvar)Qjs=77.01(Kvar)有有功功电电流流:Ijs=195.0:Ijs=195.013370608971337060897(A)(A)160016008.02%输入给定参数输出颜颜色色表表达达含含义义输入给定参数输出合计(元)169.857917342.941608317542.941608312013.1308722013.130872颜颜色色表表达达含含义义4 4、电电力力系系统统负负荷荷计计算算序号回路编号总功率Pe（KW）需用系数Kx 功率因数Cos额定电压Ue（V）设备相数视在功率S(KVA)1370.850.8380三相39.312370.850.65380三相48.38323.40.850.95380三相20.94423.40.850.8380三相24.8658900.750.8380三相834.3863500.850.8380三相371.88700.80.85380三相0.00800.80.85380三相0.00900.80.85380三相0.001000.80.85380三相0.00合合计计总总负负荷荷:Pe=1360.8(KW):Pe=1360.8(KW)平平均均功功率率因因数数=0.82=0.82视视在在功功率率:S=:S=1339.751339.75计算有功功率Pjs（KW）计算无功功率Qjs（KVar）计算有功电流Ijs（A)选用的变压器S(KVA)负荷率Sjs/S31.4523.5959.734009.83%31.4536.7773.5140012.10%19.896.5431.814005.23%19.8914.9237.784006.22%667.50500.631267.74100083.44%297.50223.13565.0240092.97%0.000.000.004000.00%0.000.000.004000.00%0.000.000.004000.00%0.000.000.004000.00%有有功功功功率率:Pj=1067.68(:Pj=1067.68