接地电阻计算.xls

1、人人工工接接地地体体工工频频接接地地电电阻阻的的计计算算1.单单根根垂垂直直接接地地体体的的接接地地电电阻阻R0（ld）(1)对对于于扁扁钢钢l lb bd dR R00.0000.000#DIV/0!#DIV/0!(2)对对于于等等边边角角钢钢l lb bd dR R00.0000.000#DIV/0!#DIV/0!2.不不同同形形状状水水平平接接地地体体的的接接地地电电阻阻R0LhdAR R0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!3.以以水水平平接接地地体体为为主主，且且边边缘缘闭闭合合的的复复合合接接地地体体的的接接地地电电阻阻计算公式S S

2、L Lh hd dR Rw40.000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!接接触触电电压压和和跨跨步步电电压压计算公式1.接接触触电电势势允允许许值值1.接触电势允许值btEj40.00040.0000.2000.200581.378581.378#DIV/0!#DIV/0!42106.1ln2404hdLLSRW2112142221210bbb84.0dbbbbbb71.0db2bd4lnl 2，对于等边角钢为角钢边长；，）（为扁钢宽度；对于角钢，对于扁钢dlR）（ALRhdLln220tjbE25.02502.跨步电势允许值2.跨跨步步电电势

3、势允允许许值值btEk40.00040.0000.2000.200648.460648.460#DIV/0!#DIV/0!1.入入地地短短路路电电流流计计算算1.厂厂内内发发生生接接地地短短路路ImaxIzKf1I Kf1=0.51864093209320.002.厂厂外外发发生生接接地地短短路路IzKf2I Kf2=0.0.0002.接接地地装装置置的的电电位位IREw4660.0000.2741276.8403.接接地地网网的的最最大大接接触触电电势势1.长长孔孔ndSKnKdKs4.8230.03034900.2971.0001.0742.方方孔孔ndSKnKdKs6.0000.0303

4、4900.2190.9001.0743.最最大大接接触触电电势势孔孔的的规规格格（长长取取1，方方取取0）KjEwEjm1.0000.3191276.840 407.550tkbE250）（1max1fzKIII）（21fzKIIIREw)10(137.0545.0nKnn长孔：wjjmEKE)9(096.097.0nKnn长孔：)9(047.003.1nKnn方孔：)10(105.055.0nKnn方孔：0.1dK长 孔：d102.1方孔：dKSsK4023.023.14.接接地地网网的的最最大大跨跨步步电电势势当埋深h0.8m时hLL1SdKk1Kk2ABC0.857924434900.0

5、300.0660.0640.0641.3761.3761.2961.2960.0210.021EwEkm1Ekm21276.84083.94781.710)(28.102.9125.01ln476.041.0dSLLSLLLkKwjjmEKE)9(096.097.0nKnn长孔：)9(047.003.1nKnn方孔：)10(105.055.0nKnn方孔：0.1dK长 孔：d102.1方孔：dKSsK4023.023.1人人工工接接地地体体工工频频接接地地电电阻阻的的计计算算1.单单根根垂垂直直接接地地体体的的接接地地电电阻阻R0（ld）(1)对对于于扁扁钢钢l lb bd dR R00.00

6、00.000#DIV/0!#DIV/0!(2)对对于于等等边边角角钢钢l lb bd dR R00.0000.000#DIV/0!#DIV/0!2.不不同同形形状状水水平平接接地地体体的的接接地地电电阻阻R0LhdAR R0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!3.以以水水平平接接地地体体为为主主，且且边边缘缘闭闭合合的的复复合合接接地地体体的的接接地地电电阻阻计算公式S SL Lh hd dR Rw40.0008295.1601775.5100.8000.0300.2590.259#DIV/0!#DIV/0!#DIV/0!#DIV/0!接接触触电

7、电压压和和跨跨步步电电压压计算公式1.接接触触电电势势允允许许值值1.接触电势允许值ftUt4004000.2000.200541.128541.128#DIV/0!#DIV/0!42106.1ln2404hdLLSRW2112142221210bbb84.0dbbbbbb71.0db2bd4lnl 2，对于等边角钢为角钢边长；，）（为扁钢宽度；对于角钢，对于扁钢dlR）（ALRhdLln220ttfU17.0174 2.跨步电势允许值2.跨跨步步电电势势允允许许值值ftUs2002000.2640.264404.819404.819#DIV/0!#DIV/0!1.入入地地短短路路电电流流计计

8、算算1.厂厂内内发发生生接接地地短短路路ImaxIzKf1I Kf1=0.5186409320.00.54660.002.厂厂外外发发生生接接地地短短路路IzKf2I Kf2=0.19320.0000.18388.002.接接地地装装置置的的电电位位IRUg8388.000.2592172.4923.均均压压带带等等间间距距布布置置时时接接地地网网的的最最大大接接触触电电势势及及最最大大跨跨步步电电势势（1）均均压压带带等等间间距距布布置置时时接接地地网网的的最最大大接接触触电电势势1.最最大大接接触触电电位位差差系系数数孔孔的的规规格格ndL1L2S07.4200.0308275KdKLKn

9、KsKtmax1.1841.0000.1811.0450.2233.最最大大接接触触电电势势UgKtmaxUtmax2172.4920.223485.245）（1max1fzKIII）（21fzKIIIRUgtsfU17.0174 421/1.1LLKL长 孔：dKdlg225.0841.00.1LK方 孔：nKn/776.0076.0SKslg414.0234.0gttUKUmaxmax（2）均均压压带带等等间间距距布布置置时时接接地地网网的的最最大大跨跨步步电电势势1.最最大大跨跨步步电电位位差差系系数数接接地地网网的的规规格格NLL0hd11625.51526.930.800.800.0

10、30SnKsmax8295.167.4200.2720.3310.0712.最最大大跨跨步步电电位位差差UgKsmaxUsmax2172.4920.071153.8804.均均压压带带不不等等间间距距布布置置时时接接地地网网的的最最大大跨跨步步电电势势（1）均均压压带带不不等等间间距距布布置置时时接接地地网网的的最最大大接接触触电电势势n1n2mhdL11.000L2SKtdKthKtlKtmax#DIV/0!0.257#DIV/0!#DIV/0!KtnKtsKtmaxUgUtmax#DIV/0!0.054#DIV/0!2172.492#DIV/0!（2）均均压压带带不不等等间间距距布布置置时

11、时接接地地网网的的最最大大跨跨步步电电势势n1n2hdL1L2SmKsdKshKsLKsmax1.0000.5740.000#DIV/0!1.128KsnKssKsmaxUgUtmax#DIV/0!0.070#DIV/0!2172.492#DIV/0!2/14)(200SLLLn n1.0)()(35.03014.122SnndhSThhThhsK4.20)2/()2/(2max/ln)5.1(2222gssUKUmaxmaxtstnttLthtdtKKKKKKKmaxmaxgttUKUmaxmaxsssnssLshsdsKKKKKKKmaxmaxgssUKUm axm ax6/522.040

12、1.0dKtd5095.0257.0hKth)/(002.0168.012LLKtL3021.240m a x8 3 7.2htK)/(132.0217.0021.01212nnKnntn8410.0054.0SKts)(12LL)(12nn 364.0574.0dKsd)/(011.0741.012LLKsLmKs/072.1056.0max1212/234.0849.0nnKsnSKss08.107.0)(12LL)(12nn heKsh789.2864.3836/522.0401.0dKtd5095.0257.0hKth)/(002.0168.012LLKtL3021.240m a x8 3 7.2htK)/(132.0217.0021.01212nnKnntn8410.0054.0SKts)(12LL)(12nn 364.0574.0dKsd)/(011.0741.012LLKsLmKs/072.1056.0max1212/234.0849.0nnKsnSKss08.107.0)(12LL)(12nn heKsh789.2864.383