电缆、阻抗值、短路电流、电压降计算表.xls

变变压压器器型型号号、参参数数、电电压压降降、启启动动电电压压降降综综合合计计算算表表序号变压器编号变压器型号额定容量kVA一次额定电压kV二次额定电压V二次额定电流A使用地点或范围最大电机额定容量kw负荷容量之和kw需用系数功率因数cos变压器计算容量kVA联结组别空载损耗W负载损耗W空载电流%短路阻抗%启动时功率因数电机额定启动电流A电机实践启动电流A变压器正常电压损失V最大电机启动时变压器电压损失VkxUzUrUx1B1KBSGZY-630/1.263010 1200388运输线 2505000.700.70.71 1.02500.00Yy0Yy111800 3680 1.040.3973.9800.70.7167046429.7269.672B2KBSGZY-1600/1.21600 10 1200693工作面 2506320.640.70.71 1.02575.43Yy03350 8000 1.040.7123.9360.70.7167046414.2845.273B3KBSGZY-4000/3.454000 10 3450 669.4 工作面 400 3180 0.480.70.71 1.022160.00Dyn116100 14000 1.040.6973.9880.70.7137325862.15142.44qcoscosxejKPS）sincos%(1002xRBejBeBuuSSUUqeIqqeK IIsinqsin310%(sin)3dxdexqqeKPUItgU310cos)3dxdeqqeKPI U%RU2 2100BeqBBeU U I tg（14505.36515.56552.99564.16579.97591.6714电电缆缆型型号号、实实际际电电流流、载载流流量量、电电压压降降、启启动动电电压压降降综综合合计计算算表表序号电缆编号电缆型号电缆截面积mm3电缆长度m最大电机功率kw负荷容量之和kw需用系数电网额定电压V功率因数cos电缆载流量A电缆最大长时工作电流公式（单位A）电缆电导率m/mm2电动机效率干线电缆电压降公式（单位V）支线电缆电压降公式（单位V）启动时功率因数电机额定启动电流A电机实践启动电流A干线电缆启动时电压损失公式（单位V）支线电缆启动时电压损失公式（单位V）sLPmaxPekxUe电缆实际工作电流D干线电缆电压降 支线电缆电压降额定14MCPTJ-3120120202505000.7011400.7293253.242.50.951.200.76704623.4025MYP-370703045900.8011400.716860.342.50.950.640.71811252.1636MCPTJ-3120120302507220.6111400.7293317.542.50.952.260.76704625.5647MCPTJ-31201202040015800.5533000.7293217.942.50.950.520.73702561.1358MCPTJ-31201202040016000.5533000.7293219.942.50.950.520.73702561.131.2169MYP3353515045450.8011400.714330.242.50.953.350.731121426.19710MYP3353515045450.8011400.714330.242.50.953.350.731121426.19811MCPTJ-37070202502500.8011400.7168167.542.50.951.240.76704623.77912MCPTJ-37070202502500.8011400.7168167.542.50.951.240.76704623.7710 13MYP316162015150.8011400.77610.142.50.950.330.740280.9911 14MYP316162015150.8011400.77610.142.50.950.330.740280.9912 15MYP335351045450.8011400.714330.242.50.950.220.73112141.7513 16MYP335351045450.8011400.714330.242.50.950.220.73112141.7514 17MCPTJ-35050302502500.8011400.7168167.542.50.952.610.76704627.9115 18MCPTJ-35050301321320.8011400.716888.442.50.951.380.75313666.2716 19MCPTJ-35050302502500.8011400.7168167.542.50.952.610.76704627.9117 20MCPTJ-35050301321320.8011400.716888.442.50.951.380.75313666.2718 21MCPTJ-35050302502500.8011400.7168167.542.50.952.610.76704627.9119 22MCPTJ-370702004004000.8033000.720592.642.50.956.860.737025620.8320 23MCPTJ-370702002002000.8033000.720546.342.50.953.430.718512810.4121 24MCPTJ-350502302502500.8033000.716857.942.50.956.900.723116020.9622 25MCPTJ-370704604009300.6633000.7168153.042.50.9528.680.737025676.5823 26MCPTJ-370704602002000.8033000.720546.342.50.957.890.718512823.9524 27MCPTJ-370704604004000.8033000.720592.642.50.9515.780.737025647.9025 28MCPTJ-370702502002000.8033000.720546.342.50.954.290.718512813.0226 29MCPTJ-370702504004000.8033000.720592.642.50.958.580.737025626.0327 30MCPTJ-370704502002000.8033000.720546.342.50.957.720.718512823.4328 31MCPTJ-370704504004000.8033000.720592.642.50.9515.440.737025646.8629 32MCPTJ-370702402002000.8033000.720546.342.50.954.120.718512812.5030 33MCPTJ-370702402002000.8033000.720546.342.50.954.120.718512812.50gegexgDSULPKU3103103cosxeg eKPIAU hzeZefzDSULPKU310qcoshqeIqqeK II310(3cos)g XdeqgqqgeL KpUIDSV3cosz qzqqZL UIDS15线线路路电电压压降降计计算算表表序号各线路编号各线路组成（变压器编号、电缆编号）电网额定电压V变压器二次额定电压V正常运行时线路电压损失V正常运行时线路允许电压损失V是否满足下列条件启动时线路电压损失V启动电动机时实际最小启动电压V满足电动机最小启动转矩的最小电压V电动机启动时启动器最低吸持电压V启动电动机所需要的最小启动电压V 是否同时满足三个条件UeU2BeUUq1B1、4、151140 1200 31.14117是74.821125.18789.82798723.18是2B2、6、191140 1200 18.97117是58.551141.45789.82798739.45是B3、7、273300 3450 78.45315是191.473258.532286.3123102118.53是295%yBeDeUUUqmmU0.7eUmin0.7qezqUUUyUUminqeK UUminqU0.7eUminqU2 BeqUU16短短路路点点短短路路电电流流计计算算表表序号短路点编号短路点前端变压器感抗相对值短路点前端各电缆编号前端电缆长度（m）前端电缆相对70mm2电缆相对电阻的等效长度（m）电缆等效截面积mm2基准容量MVA基准电压Kv电缆电导率m/mm2单位电缆电抗值/km短路点前端各电缆电阻相对值之和短路点前端变压器及电缆电抗相对值之和短路点前端线路阻抗值短路点最小两相短路电流LLSSjUjDX0R*X*Z*Id(2)1d16.3492420201201001.242.50.060.2726.4336.43864722d26.34924、114054.285711201001.242.50.060.7396.5166.55863543d36.34924、124054.285711201001.242.50.060.7396.5166.55863544d46.34924、13401701201001.242.50.062.3156.5166.91560265d56.34924、14401701201001.242.50.062.3156.5166.91560266d62.553030701001.242.50.060.7002.6252.717153377d72.55、10、15190175351001.242.50.068.1703.2928.80847308d82.55、9、16190175351001.242.50.068.1703.2928.80847309d92.5630301201001.242.50.060.4082.6252.6571568410d102.56、17601021201001.242.50.061.3892.7503.0811352411d112.56、18601021201001.242.50.061.3892.7503.0811352412d122.56、19601021201001.242.50.061.3892.7503.0811352413d132.56、20601021201001.242.50.061.3892.7503.0811352414d142.56、21601021201001.242.50.061.3892.7503.0811352415d151720201201003.4542.50.060.0331.0101.0111434016d1617、22220362.85711201003.4542.50.060.5981.1111.2621148817d1717、23220362.85711201003.4542.50.060.5981.1111.2621148818d1817、242505721201003.4542.50.060.9421.1261.468987119d1917、25480808.57141201003.4542.50.061.3321.2421.821795820d201820201201003.4542.50.060.0331.0101.0111434021d2118、26480808.57141201003.4542.50.061.3321.2421.821795822d2218、27480808.57141201003.4542.50.061.3321.2421.821795823d2318、28270448.57141201003.4542.50.060.7391.1361.3551069324d2418、29270448.57141201003.4542.50.060.7391.1361.3551069325d2518、30470791.42861201003.4542.50.061.3041.2371.797806426d2618、31470791.42861201003.4542.50.061.3041.2371.797806427d2718、32260431.42861201003.4542.50.060.7111.1311.3361084928d2818、33260431.42861201003.4542.50.060.7111.1311.33610849*2*2()()ZRX(2)*10002j d jS I ZU*2 j jL SR SDU 2*1000jjoULSXX17开开关关整整定定值值计计算算表表序号开关编号开关名称开关型号开关额定电压V开关额定电流A电机额定功率KW电机额定电流A最大电机额定功率KW最大电机额定电流A最大电机启动电流A其它电机额定功率之和KW其它电机额定电流之和A馈电继电保护整定计数值A整定值取值A最小两相短路电流A灵敏度合格或不合格启动器控制电机（组）整定值A最小两相短路电流A灵敏度合格或不合格PeIe或IePmaxImaxIqePeIe1 GK1高防开关KBGZ41-100/10Y100001002502080.72250201011607234.52合格2 GK2高防开关KBG-210/10Y100002102502080.724723811933616234.83合格3 GK3高防开关KBG-400/10Y1000040040032129.2278022435364026264.10合格4K1馈电开关BXB-630/1140Y114063025016867025016883885060267.09合格5K2馈电开关BXB-1200/1140Y11401200250168670472316986100047304.73合格6K3馈电开关BXB-800/3300Y330080040097389.827806771067110079587.23合格75馈电开关KBZ-40011404004530180.94530211220473021.50合格81组合开关QJZ9215-1140-6K1140400250148.0014863545.4合格92400250148.0014863545.4合格1034007.55.0356026150.7合格1144007.55.0356026150.7合格126电磁启动器QBZ-120N11401204530.1530473019.7合格137电磁启动器QBZ-120N11401204530.1530473019.7合格148组合开关QJZ9215-1140-6K1140400250148.001481352411.4合格15940013280.00801352421.1合格16 10400250148.001481352411.4合格17 1140013280.00901352418.8合格18 12400250148.001481352411.4合格19 13组合开关QJZ9215-3300-6K330040020058.00581148824.8合格20 1440040087.00871148816.5合格21 1540025054.0054987122.8合格22 16400930153.0016079586.2合格23 17组合开关QJZ9215-3300-9K330040020058.0058795817.2合格24 1840040087.0087795811.4合格25 1940020058.00581069323.0合格26 2040040087.00871069315.4合格27 2140020058.0058806417.4合格28 2240040087.0087806411.6合格29 2340020058.00581084923.4合格30 2440040087.00871084915.6合格zjqeeIIIzjIzI(2)dI(2)1.5d ZI K I KzeIIzI(2)dI21.28zI K I（）K18短短路路保保护护分分级级表表开关编号一级保护二级保护三级保护线路末端两相短路电流值（A）灵敏度灵敏度是否合格电磁元件脱扣器熔体JDB电磁元件脱扣器熔体JDB电磁元件脱扣器熔体JDBGK11607234.52是GK233616234.83是GK364026264.10是K185060267.09是K2100047304.73是K3110079587.23是5220473021.50是114863545.37是214863545.37是356026150.65是456026150.65是630473019.71是730473019.71是81481352411.42是9801352421.13是101481352411.42是11901352418.78是121481352411.42是13581148824.76是14871148816.51是1554987122.85是1616079586.22是1758795817.15是1887795811.43是19581069323.05是20871069315.36是2158806417.38是2287806411.59是23581084923.38是1924871084915.59是19开开关关选选择择继继保保整整定定一一览览表表开关编号开 关型 号负荷容量(KW)工作电流(A)整 定 电 流 值 (A)线路末端两相短路电流值(A)灵敏度是否合格电磁元件脱扣器热元件熔体JDBGK1KBGZ41-100/10Y5001607234.5合格GK2KBG-210/10Y72233616234.8合格GK3KBG-400/10Y318064026264.1合格K1BXB-630/1140Y50085060267.1合格K2BXB-1200/1140Y722100047304.7合格K3BXB-800/3300Y3180110079587.2合格5KBZ-40090220473021.5合格1QJZ9215-1140-6K25014863545.4合格225014863545.4合格37.556026150.7合格47.556026150.7合格6QBZ-120N4530473019.7合格7QBZ-120N4530473019.7合格8QJZ9215-1140-6K2501481352411.4合格9132801352421.1合格102501481352411.4合格11132901352418.8合格122501481352411.4合格13QJZ9215-3300-6K200581148824.8合格14400871148816.5合格1525054987122.8合格1693016079586.2合格17QJZ9215-3300-9K20058795817.2合格1840087795811.4合格19200581069323.0合格20400871069315.4合格2120058806417.4合格2240087806411.6合格23200581084923.4合格24400871084915.6合格20