电气计算EXCEL表格-强弱电电线电缆桥架计算表.xls

芯数x标称截面mm2导体种类绝缘标称厚度mm护套标称厚度mm平均外径mm70最小绝缘电阻Mkm穿管最小管内径mm(0.33)下限上限2x0.7510.61.26.48.00.01213.932x0.7520.61.26.68.40.01414.622x1.010.61.26.88.40.01114.622x1.020.61.26.88.80.01315.322x1.510.71.27.69.40.01116.362x1.520.71.27.810.00.0117.412x2.510.81.28.610.50.0118.282x2.520.81.29.011.50.00920.022x410.81.29.611.50.008520.022x420.81.210.012.50.007721.762x610.81.210.512.50.00721.762x620.81.211.014.00.006524.372x1021.01.514.017.50.006530.463x0.7510.61.26.88.40.01214.623x0.7520.61.27.08.80.01415.323x1.010.61.27.08.80.01115.323x1.020.61.27.29.20.01316.023x1.510.71.28.09.80.01117.063x1.520.71.28.210.50.0118.283x2.510.81.29.211.00.0119.153x2.520.81.29.412.00.00920.893x410.81.210.012.50.008521.763x420.81.210.513.50.007723.503x610.81.511.514.00.00724.373x620.81.512.015.00.006526.113x1021.01.514.518.50.006532.204x0.7510.61.27.29.00.01215.674x0.7520.61.27.49.60.01416.714x1.010.61.27.69.40.01116.364x1.020.61.27.810.00.01317.414x1.510.71.28.610.50.01118.284x1.520.71.29.011.50.0120.024x2.510.81.210.012.00.0120.894x2.520.81.210.013.00.00922.634x410.81.511.514.00.008524.374x420.81.512.015.00.007726.114x610.81.512.515.00.00726.114x620.81.513.016.50.006528.724x1021.01.516.020.00.006534.825x0.7510.61.27.89.60.01216.715x0.7520.61.28.010.50.01418.285x1.010.61.28.210.00.01117.415x1.020.61.28.411.00.01319.155x1.510.71.29.411.50.01120.025x1.520.71.29.812.50.0121.765x2.510.81.211.514.00.0124.375x2.520.81.211.514.50.00925.245x410.81.512.515.00.008526.115x420.81.513.016.50.007728.725x610.81.514.016.50.00728.725x620.81.514.518.00.006531.335x1021.01.718.022.50.006539.177x0.7510.61.28.410.50.01218.287x0.7520.61.28.811.00.01419.157x1.010.61.29.011.00.01119.157x1.020.61.29.211.50.01320.027x1.510.71.210.012.50.01121.767x1.520.71.210.513.50.0123.507x2.510.81.212.515.00.0126.117x2.520.81.212.516.00.00927.857x410.81.513.516.50.008528.727x420.81.514.017.50.007730.467x610.81.515.018.00.00731.337x620.81.515.519.50.006533.957x1021.01.720.024.00.006541.788x0.7510.61.29.411.50.01220.028x0.7520.61.29.612.00.01420.898x1.010.61.210.012.00.01120.898x1.020.61.210.013.00.01322.638x1.510.71.512.014.50.01125.248x1.520.71.512.515.50.0126.988x2.510.81.514.016.50.0128.728x2.520.81.514.017.50.00930.468x420.81.516.019.50.007733.958x610.81.717.520.00.00734.828x621.01.718.022.00.006538.308x1020.61.722.527.00.006547.0010 x0.7510.61.210.512.50.01221.7610 x0.7520.61.210.513.50.01423.5010 x1.010.61.511.514.00.01124.3710 x1.020.71.512.015.00.01326.1110 x1.510.71.513.516.00.01127.8510 x1.520.81.514.017.00.0129.5910 x2.510.81.515.518.50.0132.2010 x2.520.81.516.019.50.00933.9510 x410.81.718.020.50.008535.6910 x420.81.718.522.50.007739.1710 x610.81.719.523.50.00740.9110 x620.81.720.525.00.006543.5210 x1021.01.725.530.50.006553.0912x0.7510.61.511.513.50.01223.5012x0.7520.61.511.514.50.01425.2412x1.010.61.512.014.50.01125.2412x1.020.61.512.515.50.01326.9812x1.510.71.514.016.50.01128.7212x1.520.71.514.017.50.0130.4612x2.510.81.516.019.00.0133.0712x2.520.81.516.520.50.00935.6912x410.81.718.521.50.008537.4312x420.81.719.023.00.007740.0412x610.81.720.523.50.007740.9112x620.81.721.026.00.006545.2614x0.7510.61.512.014.50.01225.2414x0.7520.61.512.015.00.01426.1114x1.010.61.512.515.00.01126.1114x1.020.61.513.016.00.01327.8514x1.510.71.514.517.00.01129.5914x1.520.71.515.018.50.0132.2014x2.510.81.517.019.50.0133.9514x2.520.81.517.521.50.00937.4314x410.81.719.522.50.008539.1714x420.81.720.024.50.007742.6514x610.81.721.524.50.00742.6514x620.81.722.527.00.006547.0016x0.7510.61.512.515.00.01226.1116x0.7520.61.513.016.00.01427.8516x1.010.61.513.015.50.01126.9816x1.020.61.513.517.00.01329.5916x1.510.71.515.018.00.01131.3316x1.520.71.515.519.50.0133.9516x2.510.81.718.021.00.0136.5616x2.520.81.719.023.00.00940.0419x0.7510.61.513.015.50.01226.9819x0.7520.61.513.516.50.01428.7219x1.010.61.514.016.50.01128.7219x1.020.61.514.517.50.01330.4619x1.510.71.516.019.00.01133.0719x1.520.71.516.520.50.0135.6919x2.510.81.719.022.00.0138.3019x2.520.81.720.024.00.00941.7824x0.7510.61.515.018.00.01231.3324x0.7520.61.515.519.00.01433.0724x1.010.61.516.019.00.01133.0724x1.020.61.516.520.50.01335.6924x1.510.71.719.022.00.01138.3024x1.520.71.720.024.00.0141.7824x2.510.81.722.525.50.0144.3924x2.520.81.723.028.00.00948.7427x0.7510.61.515.518.00.01231.3327x0.7520.61.516.019.50.01433.9527x1.010.61.716.519.00.01133.0727x1.020.61.717.020.50.01335.6927x1.510.71.719.522.50.01139.1727x1.520.71.720.024.50.0142.6527x2.510.81.723.026.00.0145.2627x2.520.81.723.528.50.00949.6130 x0.7510.61.516.019.00.01233.0730 x0.7520.61.516.520.00.01434.8230 x1.010.61.717.520.50.01135.6930 x1.020.61.718.022.00.01338.3030 x1.510.71.720.023.00.01140.0430 x1.520.71.721.025.00.0143.5230 x2.510.81.724.027.00.0147.0030 x2.520.81.724.529.50.00951.3537x0.7510.61.717.520.50.01235.6937x0.7520.61.718.022.00.01438.3037x1.010.61.718.521.50.01137.4337x1.020.61.719.523.50.01340.9137x1.510.71.721.525.00.01143.5237x1.520.71.722.527.00.0147.0037x2.510.81.725.529.00.0150.4837x2.520.81.726.531.50.00954.8344x0.7510.61.719.523.00.01240.0444x0.7520.61.720.524.50.01442.6544x1.010.61.721.024.00.01141.7844x1.020.61.721.526.00.01345.2644x1.510.71.724.528.00.01148.7448x0.7510.61.720.023.00.01240.0448x0.7520.61.720.525.00.01443.5248x1.010.61.721.524.50.01142.6548x1.020.61.722.026.50.01346.1348x1.510.71.725.028.50.01149.6148x1.520.71.725.531.00.0153.9648x2.510.82.030.034.00.0159.1948x2.520.82.031.037.00.00964.4152x0.7510.61.720.523.50.01240.9152x0.7520.61.721.025.00.01443.5252x1.010.61.722.025.00.01143.5252x1.020.61.722.527.00.01347.0052x1.510.71.725.529.00.01150.4852x1.520.71.726.531.50.0154.8352x2.510.82.031.035.00.0160.9352x2.520.82.032.038.00.00966.1561x0.7510.61.722.025.00.01343.5261x0.7520.61.722.527.00.01447.0061x1.010.61.723.026.50.01146.1361x1.020.61.724.028.50.01349.6161x1.510.72.027.531.50.01154.8361x1.520.72.028.534.00.0159.1961x2.510.82.233.037.50.0165.2861x2.520.82.234.040.50.00970.50芯数x标称截面mm2导体种类绝缘标称厚度mm屏蔽单丝直径mm护套标称厚度mm平均外径mm70最小绝缘电阻Mkm下限上限2x0.7520.60.151.27.89.80.0142x1.020.60.151.28.210.50.0132x1.520.70.151.29.211.50.012x2.520.80.151.210.012.50.0092x420.80.201.511.514.50.00772x620.80.201.513.016.00.00652x1021.00.201.515.519.00.00653x0.7520.60.151.28.210.50.0143x1.020.60.151.28.610.50.0133x1.520.70.151.29.612.00.013x2.520.80.151.210.513.50.0093x420.80.201.512.515.50.00773x620.80.201.513.517.00.00653x1021.00.201.516.520.00.00654x0.7520.60.151.28.811.00.0144x1.020.60.151.29.211.50.0134x1.520.70.151.210.012.50.014x2.520.80.201.512.515.00.0094x420.80.201.513.516.50.00774x620.80.201.515.018.00.00654x1021.00.201.718.022.00.00655x0.7520.60.151.29.411.50.0145x1.020.60.151.29.812.00.0135x1.520.70.151.211.013.50.015x2.520.80.201.513.516.50.0095x420.80.201.514.518.00.00775x620.80.201.516.019.50.00655x1021.00.201.719.524.00.00657x0.7520.60.151.210.012.50.0147x1.020.60.151.210.513.00.0137x1.520.70.151.512.515.00.017x2.520.80.201.514.517.50.0097x420.80.201.515.519.00.00777x620.80.201.517.521.00.00657x1021.00.201.721.526.00.00658x0.7520.60.151.511.013.50.0148x1.020.60.151.212.015.00.0138x1.520.70.201.514.017.00.018x2.520.80.201.516.019.00.0098x420.80.201.718.021.50.00778x620.80.201.719.524.00.00658x1021.00.251.724.029.00.006510 x0.7520.60.201.513.016.00.01410 x1.020.60.201.513.516.50.01310 x1.520.70.201.515.518.50.0110 x2.520.80.201.517.521.50.00910 x420.80.201.720.024.00.007710 x620.80.251.722.527.00.006510 x1021.00.251.727.032.50.006512x0.7520.60.201.513.016.00.01412x1.020.60.201.514.017.00.01312x1.520.70.201.516.019.00.0112x2.520.80.201.718.522.50.00912x420.80.201.720.525.00.007712x620.80.251.723.027.50.006514x0.7520.60.201.514.017.00.01414x1.020.60.201.514.517.50.01314x1.520.70.201.516.520.00.0114x2.520.80.201.719.523.50.00914x420.80.201.721.526.00.007714x620.80.251.724.029.00.006516x0.7520.60.201.514.517.50.01416x1.020.60.201.515.018.50.01316x1.520.70.201.517.521.00.0116x2.520.80.201.720.524.00.00919x0.7520.60.201.515.018.00.01419x1.020.60.201.516.019.00.01319x1.520.70.201.718.522.50.0119x2.520.80.201.721.525.50.00924x0.7520.60.201.517.020.50.01424x1.020.60.201.518.522.00.01324x1.520.70.201.721.525.50.0124x2.520.80.251.725.029.50.00927x0.7520.60.201.517.521.00.01427x1.020.60.201.519.022.50.01327x1.520.70.201.721.526.00.0127x2.520.80.251.725.530.50.00930 x0.7520.60.201.718.522.00.01430 x1.020.60.201.719.523.50.01330 x1.520.80.251.722.527.00.0130 x2.520.80.251.726.531.50.00937x0.7520.60.251.719.523.50.01437x1.020.60.251.721.025.00.01337x1.520.70.251.724.529.00.0137x2.520.80.302.029.034.00.00944x0.7520.60.251.722.026.50.01444x1.020.60.251.723.528.00.01344x1.520.70.251.727.032.00.0144x2.520.80.302.032.538.50.00948x0.7520.60.251.722.526.50.01448x1.020.60.251.723.528.00.01348x1.520.70.251.727.532.50.0148x2.520.80.302.033.039.00.00952x0.7520.60.251.723.027.50.01452x1.020.60.251.724.529.00.01352x1.520.70.252.029.534.00.0152x2.520.80.302.234.540.50.00961x0.7520.60.251.724.529.00.01461x1.020.60.251.726.530.50.01361x1.520.70.252.030.536.00.0161x2.520.80.302.236.542.50.009穿管最小管内径mm(0.33)17.0618.2820.0221.7625.2427.8533.0718.2818.2820.8923.5026.9829.5934.8219.1520.0221.7626.1128.7231.3338.3020.0220.8923.5028.7231.3333.9541.7821.7622.6326.1130.4633.0736.5645.2623.5026.1129.5933.0737.4341.7850.4827.8528.7232.2037.4341.7847.0056.5827.8529.5933.0739.1743.5247.8729.5930.4634.8240.9145.2650.4830.4632.2036.5641.7831.3333.0739.1744.3935.6938.3044.3951.3536.5639.1745.2653.0938.3040.9147.0054.8340.9143.5250.4859.1946.1348.7455.7067.0246.1348.7456.5867.8947.8750.4859.1970.5050.4853.0962.6773.98导体标称截面mm2导体种类绝缘厚度规定值平均外径上限70最小绝缘电阻Mkm穿管最小管内径mm(0.33)导线数21.510.73.30.0115.746.601.520.73.40.015.926.802.510.83.90.016.797.802.520.84.20.0097.318.40410.84.40.00857.668.80420.84.80.00778.369.60610.84.90.0078.539.80620.85.40.00659.4010.801011.06.40.00711.1412.801021.06.80.006511.8413.601621.08.00.00513.9316.002521.29.80.00517.0619.603521.211.00.00419.1522.005021.413.00.004522.6326.007021.415.00.003526.1130.009521.617.00.003529.5934.0012021.619.00.003233.0738.0015021.821.00.003236.5642.0018522.023.50.003240.9147.0024022.226.50.003246.1353.0030022.429.50.00351.3559.0040022.633.50.002858.3267.00穿管最小管内径mm(0.33)导线数3穿管最小管内径mm(0.33)导线数4穿管最小管内径mm(0.33)导线数5穿管最小管内径mm(0.33)11.497.1112.387.9713.878.9115.5111.847.3312.768.2114.299.1815.9813.588.4014.629.4216.4010.5418.3514.629.0515.7510.1417.6511.3519.7615.329.4816.5010.6218.4911.8920.7016.7110.3418.0011.5920.1812.9722.5817.0610.5618.3811.8320.5913.2423.0518.8011.6420.2613.0422.7014.5925.4022.2813.7924.0115.4526.8917.2930.1023.6714.6525.5016.4228.5818.3731.9827.8517.2430.0119.3133.6121.6137.6234.1221.1236.7723.6641.1926.4746.0838.3023.7041.2626.5646.2429.7151.7245.2628.0148.7631.3854.6335.1261.1452.2232.3256.2636.2163.0340.5270.5459.1936.6363.7641.0471.4445.9279.9466.1540.9471.2745.8779.8551.3289.3473.1145.2578.7750.7088.2656.7398.7581.8250.6488.1556.7398.7563.48110.5092.2657.1099.4063.98111.3771.58124.60102.7163.56110.6471.22123.9879.69138.72116.6372.18125.6580.88140.7990.49157.52BVV、BLVV型300/500V铜芯聚氯乙烯绝缘聚氯乙烯护套圆型电缆导体标称截面mm2实心导体或绞合导体中单线最少根数绝缘厚度规定值mm护套厚度规定值mm平均外径mm20最小绝缘电阻km下限上限0.7510.60.83.64.424.5110.60.83.74.518.11.510.70.84.25.012.11.570.70.84.35.212.12.510.80.84.85.77.412.570.80.84.85.97.41410.80.95.46.54.61470.80.95.56.84.61610.80.95.97.13.08670.80.96.07.33.081071.00.97.38.81.8370最小绝缘电阻Mkm穿管最小管内径mm(0.33)0.0127.660.0117.830.0118.700.019.050.019.920.00910.270.008511.320.007711.840.00712.360.006512.710.006515.32导体标称截面mm2导体种类绝缘厚度规定值mm内护套厚度规定值mm护套厚度规定值mm平均外径mm70最小绝缘电阻Mkm下限上限2x1.510.70.41.27.610.00.0112x1.520.70.41.27.810.50.012x2.510.80.41.28.611.50.012x2.520.80.41.29.012.00.0092x410.80.41.29.612.50.00852x420.80.41.210.013.00.00772x610.80.41.210.513.50.0072x620.80.41.211.014.00.00652x1011.00.61.413.016.50.0072x1021.00.61.413.517.50.00652x1621.00.61.415.520.00.00522x2521.20.81.418.524.00.0052x3521.21.01.621.027.50.00443x1.510.70.41.28.010.50.0113x1.520.70.41.28.211.00.013x2.510.80.41.29.212.00.013x2.520.80.41.29.412.50.0093x410.80.41.210.013.00.00853x420.80.41.210.513.50.00773x610.80.41.411.514.50.0073x620.80.41.412.015.50.00653x1011.00.61.414.017.50.0073x1021.00.61.414.519.00.00653x1621.00.81.416.521.50.00523x2521.20.81.420.026.00.0053x3521.21.01.622.029.00.00444x1.510.70.41.28.611.50.0114x1.520.70.41.29.012.00.014x2.510.80.41.210.013.00.014x2.520.80.41.210.013.50.0094x410.80.41.411.514.50.00854x420.80.41.412.015.00.00774x610.80.61.412.516.00.0074x620.80.61.413.017.00.00654x1011.00.61.415.519.00.0074x1021.00.61.416.020.50.00654x1621.00.81.418.023.50.00524x2521.21.01.622.528.50.0054x3521.21.01.624.532.50.00445x1.510.70.41.29.412.00.0115x1.520.70.41.29.812.50.015x2.510.80.41.211.014.00.015x2.520.80.41.211.014.50.0095x410.80.61.412.516.00.00855x420.80.61.413.017.00.00775x610.80.61.413.517.50.0075x620.80.61.414.518.50.00655x1011.00.61.417.021.00.0075x1021.00.61.417.522.00.00655x1621.00.81.620.526.00.00525x2521.21.01.624.531.50.0055x3521.21.21.627.035.00.0044穿管最小管内径mm(0.33)17.4118.2820.0220.8921.7622.6323.5024.3728.7230.4634.8241.7847.8718.2819.1520.8921.7622.6323.5025.2426.9830.4633.0737.4345.2650.4820.0220.8922.6323.5025.2426.1127.8529.5933.0735.6940.9149.6156.5820.8921.7624.3725.2427.8529.5930.4632.2036.5638.3045.2654.8360.93导体标称截面mm2绝缘厚度规定值平均外径上限70最小绝缘电阻Mkm穿管最小管内径mm(0.33)导线数2穿管最小管内径mm(0.33)1.50.73.50.016.097.0012.192.50.84.20.0097.318.4014.6240.84.80.0078.369.6016.7160.86.30.00610.9712.6021.93101.07.60.005613.2315.2026.46161.08.80.004615.3217.6030.64251.211.00.004419.1522.0038.30351.212.50.003821.7625.0043.52501.414.50.003725.2429.0050.48701.417.00.003229.5934.0059.19951.619.00.003233.0738.0066.151201.621.00.002936.5642.0073.111501.823.50.002940.9147.0081.821852.026.00.002945.2652.0090.522402.229.50.002851.3559.00102.71导线数3穿管最小管内径mm(0.33)导线数4穿管最小管内径mm(0.33)导线数5穿管最小管内径mm(0.33)7.5413.138.4514.719.4516.459.0515.7510.1417.6511.3519.7610.3418.0011.5920.1812.9722.5813.5723.6215.2126.4817.0229.6316.3828.5118.3531.9420.5335.7418.9633.0121.2536.9923.7741.3823.7041.2626.5646.2429.7151.7226.9346.8830.1852.5433.7758.7931.2454.3835.0160.9439.1768.1936.6363.7641.0471.4445.9279.9440.9471.2745.8779.8551.3289.3445.2578.7750.7088.2656.7398.7550.6488.1556.7398.7563.48110.5056.0297.5262.77109.2770.23122.2563.56110.6471.22123.9879.69138.72导体标称截面mm2绝缘厚度规定值mm护套厚度规定值mm平均外径mm70最小绝缘电阻Mkm穿管最小管内径mm(0.33)下限上限2x0.750.60.86.07.60.01113.232x10.60.86.48.00.0113.932x1.50.70.87.49.00.0115.672x2.50.81.08.911.00.00919.153x0.750.60.86.48.00.01113.933x10.60.86.88.40.0114.623x1.50.70.98.09.80.0117.063x2.50.81.09.612.00.00920.894x0.750.60.86.88.60.01114.974x10.60.97.69.40.0116.364x1.50.71.09.011.00.0119.154x2.50.81.110.513.00.00922.635x0.750.60.97.49.60.01116.715x10.60.98.310.00.0117.415x1.50.71.110.012.00.0120.895x2.50.81.211.514.00.00924.37导体标称截面mm2导体中单线最大直径绝缘厚度规定值mm屏蔽层单线直径mm护套厚度规定值mm平均外径mm70最小绝缘电阻km下限上限1x0.080.130.40.100.42.42.92471x0.120.160.40.100.42.43.01581x0.20.160.40.100.42.63.292.31x0.30.160.50.100.42.93.569.21x0.40.160.50.100.43.03.748.21x0.50.210.50.100.43.13.8391x0.750.210.50.100.43.44.1261x1.00.210.60.100.64.14.919.51x1.50.260.60.100.64.35.213.31x2.50.260.70.150.64.96.07.982x0.080.130.40.100.43.24.22472x0.120.160.40.100.63.74.91562x0.20.160.40.100.64.15.392.32x0.30.160.50.150.64.86.269.22x0.40.160.5