{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Impedance 3ph-N","Impedance 3ph","Short-circuit calculation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Impedance 3ph-N","index":0,"n_rows":24,"n_cols":22,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,4],[2,0,3,0]]}
["Cable type","Earth return path","R, X","Conductors",null,"Z1","Z0","Zn","Zearth","Zneutral","Z0_SE","Z0_N","Z0/Z1","Z0_SE/Z1","Z0_N/Z1","r","d","RS'","r_sm","ω","μ0","δ"]
[null,null,null,"Phase","Neutral","Ohm/km","Ohm/km","Ohm/km","Ohm/km","Ohm/km","Ohm/km","Ohm/km","Ohm/km","Ohm/km","Ohm/km","mm","mm","Ohm/km","mm","1/s","Vs/Am","m"]
["NYCWY 4x70/35","Earth/Sheath/N","R",3,1,0.26800000000000002,{"$f":"K3","v":1.2410872448644601},{"$f":"J3+I3","v":0.59236241495482012},{"$f":"(K3-$F3)/3","v":0.32436241495482004},0.26800000000000002,{"$f":"IMREAL(IMSUB(COMPLEX(F3+3*T3*U3/8*1000,T4*U4*1000/(2*PI())*(1/4+3*LN(V4*1000/((P4*Q4^2)^(1/3))))),IMPRODUCT(3,IMDIV(IMPRODUCT(COMPLEX(T3*U3/8*1000,T4*U4*1000/(2*PI())*(LN(V4*1000/S4))),COMPLEX(T3*U3/8*1000,T4*U4*1000/(2*PI())*(LN(V4*1000/S4)))),COMPLEX(R3+T3*U3/8*1000,T4*U4*1000/(2*PI())*(LN(V4*1000/S4)))))))","v":1.2410872448644601},{"$f":"4*F3","v":1.0720000000000001},{"$f":"G3/F3","v":4.6309225554644033},{"$f":"K3/$F3","v":4.6309225554644033},{"$f":"L3/$F3","v":4},5.4,15.6,0.51,16.899999999999999,{"$f":"2*PI()*50","v":314.15926535897933},{"$f":"1.257*10^-6","v":1.2569999999999998E-6},932]
[null,"Earth/Sheath/N","X",3,1,{"$f":"0.262*2*PI()*50/1000","v":8.2309727524052578E-2},{"$f":"K4","v":0.78065760091664005},0.31509235198824836,0.23278262446419581,8.2309727524052578E-2,{"$f":"IMAGINARY(IMSUB(COMPLEX(F3+3*T3*U3/8*1000,T4*U4*1000/(2*PI())*(1/4+3*LN(V4*1000/((P4*Q4^2)^(1/3))))),IMPRODUCT(3,IMDIV(IMPRODUCT(COMPLEX(T3*U3/8*1000,T4*U4*1000/(2*PI())*(LN(V4*1000/S4))),COMPLEX(T3*U3/8*1000,T4*U4*1000/(2*PI())*(LN(V4*1000/S4)))),COMPLEX(R3+T3*U3/8*1000,T4*U4*1000/(2*PI())*(LN(V4*1000/S4)))))))","v":0.78065760091664005},{"$f":"4*F4","v":0.32923891009621031},9.4843905380262132,9.4843905380262132,4,5.4,15.6,0.51,16.899999999999999,314.15926535897933,1.2569999999999998E-6,932]
[]
[]
["Variable description"]
["Z1","positive sequence impedance","Ohm/km"]
["Z0","zero sequence impedance","Ohm/km"]
["Zn","neutral earth loop impedance (Z_n = Z_NE)","Ohm/km"]
["Zearth","earth impedance","Ohm/km"]
["Zneutral","neutral impedance","Ohm/km"]
["Z0_SE","phase earth loop impedance (plus return via sheath)","Ohm/km"]
["Z0_N","phase neutral loop impedance","Ohm/km"]
["Z0/Z1","ration zero sequence to positive sequence impedance","Ohm/km"]
["Z0_SE/Z1","ration zero sequence (return via earth and sheath) to positive sequence impedance","Ohm/km"]
["Z0_N/Z1","ration zero sequence (return via neutral) to positive sequence impedance","Ohm/km"]
["r","conductor radius","mm"]
["d","mean distance of the conductors to each other","mm"]
["RS'","resistance of the sheath/shield ","Ohm/km"]
["r_sm","mean radius of the sheath/shield ","mm"]
["ω","angular frequency ","1/s"]
["μ0","magnetic constant ","Vs/Am"]
["δ","earth current depth ","m"]

{"sheet":"Impedance 3ph","index":1,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["3ph-N cable","R1'",{"$f":"'Impedance 3ph-N'!F3","v":0.26800000000000002},"Ohm/km",null,"X1'",{"$f":"'Impedance 3ph-N'!F4","v":8.2309727524052578E-2},"Ohm/km",null,"Z1'",{"$f":"SQRT(C1^2+G1^2)","v":0.28035493797164301},"Ohm/km"]
[null,"R0'",{"$f":"'Impedance 3ph-N'!G3","v":1.2410872448644601},"Ohm/km",null,"X0'",{"$f":"'Impedance 3ph-N'!G4","v":0.78065760091664005},"Ohm/km",null,"Z0'",{"$f":"SQRT(C2^2+G2^2)","v":1.4661936567978258},"Ohm/km"]
["return path","Rn'",{"$f":"'Impedance 3ph-N'!H3","v":0.59236241495482012},"Ohm/km",null,"Xn'",{"$f":"'Impedance 3ph-N'!H4","v":0.31509235198824836},"Ohm/km",null,"Zn'",{"$f":"SQRT(C3^2+G3^2)","v":0.67095187676359669},"Ohm/km"]
["Earth/Sheath/N","Rpn'",{"$f":"'Impedance 3ph-N'!I3","v":0.32436241495482004},"Ohm/km",null,"Xpn'",{"$f":"'Impedance 3ph-N'!I4","v":0.23278262446419581},"Ohm/km",null,"Zpn'",0.39924770066684379,"Ohm/km"]
[null,"Rneutral'",{"$f":"C3-C4","v":0.26800000000000007},"Ohm/km",null,"Xneutral'",{"$f":"G3-G4","v":8.2309727524052551E-2},"Ohm/km",null,"Zneutral'",0.28035493797164307,"Ohm/km"]
[]
["3ph-Leitungen"]
["return path","R1'",{"$f":"$C$1","v":0.26800000000000002},"Ohm/km",null,"X1'",{"$f":"$G$1","v":8.2309727524052578E-2},"Ohm/km",null,"Z1'",{"$f":"SQRT(C8^2+G8^2)","v":0.28035493797164301},"Ohm/km"]
["Earth/Sheath","R0'",{"$f":"C1+3*C4","v":1.2410872448644601},"Ohm/km",null,"X0'",{"$f":"G1+3*G4","v":0.78065760091663994},"Ohm/km",null,"Z0'",{"$f":"SQRT(C9^2+G9^2)","v":1.4661936567978258},"Ohm/km"]
[]
["return path","R1'",{"$f":"$C$1","v":0.26800000000000002},"Ohm/km",null,"X1'",{"$f":"$G$1","v":8.2309727524052578E-2},"Ohm/km",null,"Z1'",{"$f":"SQRT(C11^2+G11^2)","v":0.28035493797164301},"Ohm/km"]
["N","R0'",{"$f":"C1+3*C5","v":1.0720000000000003},"Ohm/km",null,"X0'",{"$f":"G1+3*G5","v":0.3292389100962102},"Ohm/km",null,"Z0'",{"$f":"SQRT(C12^2+G12^2)","v":1.1214197518865723},"Ohm/km"]
[]
["return path","R1'",{"$f":"$C$1","v":0.26800000000000002},"Ohm/km",null,"X1'",{"$f":"$G$1","v":8.2309727524052578E-2},"Ohm/km",null,"Z1'",{"$f":"SQRT(C14^2+G14^2)","v":0.28035493797164301},"Ohm/km"]
["Earth/Sheath/N","R0'",{"$f":"IMREAL(IMSUM(COMPLEX($C$1,$G$1),IMPRODUCT(3,IMDIV(IMPRODUCT(COMPLEX($C$4,$G$4),COMPLEX($C$5,$G$5)),IMSUM(COMPLEX($C$4,$G$4),COMPLEX($C$5,$G$5))))))","v":0.72257768357415098},"Ohm/km",null,"X0'",{"$f":"IMAGINARY(IMSUM(COMPLEX($C$1,$G$1),IMPRODUCT(3,IMDIV(IMPRODUCT(COMPLEX($C$4,$G$4),COMPLEX($C$5,$G$5)),IMSUM(COMPLEX($C$4,$G$4),COMPLEX($C$5,$G$5))))))","v":0.29167112764233699},"Ohm/km",null,"Z0'",{"$f":"SQRT(C15^2+G15^2)","v":0.7792243293811727},"Ohm/km"]

{"sheet":"Short-circuit calculation","index":2,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["3ph-N cable","R1'",{"$f":"'Impedance 3ph-N'!F3","v":0.26800000000000002},"Ohm/km",null,"X1'",{"$f":"'Impedance 3ph-N'!F4","v":8.2309727524052578E-2},"Ohm/km",null,"Z1'",{"$f":"COMPLEX(C1,G1)","v":"0,268+0,0823097275240526i"},"Ohm/km"]
[null,"R0'",{"$f":"'Impedance 3ph-N'!G3","v":1.2410872448644601},"Ohm/km",null,"X0'",{"$f":"'Impedance 3ph-N'!G4","v":0.78065760091664005},"Ohm/km",null,"Z0'",{"$f":"COMPLEX(C2,G2)","v":"1,24108724486446+0,78065760091664i"},"Ohm/km"]
["return path","Rn'",{"$f":"'Impedance 3ph-N'!H3","v":0.59236241495482012},"Ohm/km",null,"Xn'",{"$f":"'Impedance 3ph-N'!H4","v":0.31509235198824836},"Ohm/km",null,"Zn'",{"$f":"COMPLEX(C3,G3)","v":"0,59236241495482+0,315092351988248i"},"Ohm/km"]
["Earth/Sheath/N","Rpn'",{"$f":"'Impedance 3ph-N'!I3","v":0.32436241495482004},"Ohm/km",null,"Xpn'",{"$f":"'Impedance 3ph-N'!I4","v":0.23278262446419581},"Ohm/km",null,"Zpn'",{"$f":"COMPLEX(C4,G4)","v":"0,32436241495482+0,232782624464196i"},"Ohm/km"]
[null,"Rneutral'",{"$f":"C3-C4","v":0.26800000000000007},"Ohm/km",null,"Xneutral'",{"$f":"G3-G4","v":8.2309727524052551E-2},"Ohm/km",null,"Zneutral'",{"$f":"COMPLEX(C5,G5)","v":"0,268+0,0823097275240526i"},"Ohm/km"]
[]
["Data"]
["c",1.05]
["Un",0.4,"kV"]
[]
["Short-circuit","Z1","Z2","Z0","Zk","Ikss","abs(Ikss)","arg(Ikss)"]
["calculation","Ohm","Ohm","Ohm","Ohm","kA","kA","deg"]
["1PH-E",{"$f":"K1","v":"0,268+0,0823097275240526i"},{"$f":"K1","v":"0,268+0,0823097275240526i"},{"$f":"IMSUM(B13,IMPRODUCT(COMPLEX(3,0),K4))","v":"1,24108724486446+0,780657600916641i"},{"$f":"IMSUM(B13,C13,D13)","v":"1,77708724486446+0,945277055964746i"},{"$f":"IMDIV(IMPRODUCT(COMPLEX($B$9,0),COMPLEX(SQRT(3),0),COMPLEX($B$8,0)),E13)","v":"0,319075467324267-0,169724204174265i"},{"$f":"IMABS(F13)","v":0.36140760829122975},{"$f":"IMARGUMENT(F13)*180/PI()","v":-28.009626127927611}]
["1PH-N",{"$f":"K1","v":"0,268+0,0823097275240526i"},{"$f":"K1","v":"0,268+0,0823097275240526i"},{"$f":"IMSUM(B14,IMPRODUCT(COMPLEX(3,0),K5))","v":"1,072+0,329238910096211i"},{"$f":"IMSUM(B14,C14,D14)","v":"1,608+0,493858365144316i"},{"$f":"IMDIV(IMPRODUCT(COMPLEX($B$9,0),COMPLEX(SQRT(3),0),COMPLEX($B$8,0)),E14)","v":"0,413406253386871-0,126967746541093i"},{"$f":"IMABS(F14)","v":0.43246449449763275},{"$f":"IMARGUMENT(F14)*180/PI()","v":-17.073075535162211}]
["1PH-N-E",{"$f":"K1","v":"0,268+0,0823097275240526i"},{"$f":"K1","v":"0,268+0,0823097275240526i"},{"$f":"IMSUM(B15,IMPRODUCT(COMPLEX(3,0),IMDIV(IMPRODUCT(K4,K5),IMSUM(K4,K5))))","v":"0,722577683574151+0,291671127642337i"},{"$f":"IMSUM(B15,C15,D15)","v":"1,25857768357415+0,456290582690442i"},{"$f":"IMDIV(IMPRODUCT(COMPLEX($B$9,0),COMPLEX(SQRT(3),0),COMPLEX($B$8,0)),E15)","v":"0,510856467719208-0,185208269913714i"},{"$f":"IMABS(F15)","v":0.54339344296281067},-19.927840826389602]