{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Ex 6-4","Ex 6-5","Ex 6-6","Ex 6-7"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":28,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Ex 6-4","index":0,"n_rows":44,"n_cols":48,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,1,5,1],[37,32,38,32],[37,34,38,34],[7,9,9,10],[6,19,6,20],[6,21,6,22],[7,1,9,1],[20,25,21,25],[20,30,21,30]]}
[null,"Complément au cours \"Caractéristiques électriques des postes de distribution HT/MT\", module 2"]
[null,"Calcul de l'écart de tension max entre phases MT (3E Ing.,  J.P. Laflamme, ing. 2015-03-09)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impédance source MT"]
[null,null,null,"R1",null,"X1",null,null,null,null,null,null,null,null,null,null,null,null,"Z","R1","X1","R0","X0",null,null,null,null,null,null,null,null,null,null,null,null,null,"Validation d'erreur"]
[null,null,"Impédance source HT :",3.2000000000000002E-3,null,1.12E-2,"p.u. (100 MVA)",null,null,null,null,"Tension source HT :",315,"kV",null,null,null,null,"HT",{"$f":"D4*S5","v":2.3381726195378594E-2},{"$f":"F4*S5","v":8.1836041683825078E-2},null,null,"Ω",null,"Validation d'erreur",{"$f":"IF(ISERR(AB4),TRUE,OR(AB4,AC4,Erreur2))","v":false},{"$f":"OR(AK4:AV19)","v":false},{"$f":"OR(ISERR(T13),ISERR(V13),ISERR(AB4))","v":false},false,null,null,null,null,null,null,{"$f":"D4<0","v":false},null,{"$f":"F4<0","v":false},null,null,null,null,null,null,{"$f":"M4<=0","v":false}]
[null,"Tension nominale  des transfos",null,"HT",null,"MT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M4^2/100*(F6/U6)^2","v":7.3067894360558103}]
[null,null,null,310,null,26.4,"kV",null,null,null,null,"Prise de régulation :",9.4049999999999994,null,null,null,null,null,null,{"$f":"-(M6-9)/8*0.15","v":-7.5937499999999877E-3},{"$f":"(1+T6)*D6","v":307.6459375},{"$f":"(1-0.7717*T6+1.4798*T6^2)*D8","v":24.042095767435331},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(D6<0.8*M4,D6>1.2*M4)","v":false},null,{"$f":"OR(F6<0.8*D13,F6>1.3*D13)","v":false},null,null,null,null,null,null,{"$f":"OR(M6<1,M6>17)","v":false}]
[null,null,null,"Z",null,"X/R",null,"Puissance",null,null,null,null,"Z",null,"X/R",null,null,null,"Transfos","Puissance",null,"MALT",null,null,null,null,"G1","B1",null,"G0","B0"]
[null,"Impédance transfos de puissance YNd",1,23.9,"%",55,null,66,"MVA","Impédance transfos de MALT",null,1,4.3,"Ω",15,null,null,null,{"$f":"IF(ISBLANK(D8),\"\",$V$6/100*$F$6^2/H8)","v":2.538845313041171},{"$f":"IF(ISBLANK(D8),\"\",S8*1/SQRT(1+F8^2))","v":4.6153195876419133E-2},{"$f":"IF(ISBLANK(D8),\"\",S8*F8/SQRT(1+F8^2))","v":2.5384257732030524},{"$f":"IF(ISBLANK(M8),\"\",M8*1/SQRT(1+O8^2))","v":0.28603174525222791},{"$f":"IF(ISBLANK(M8),\"\",M8*O8/SQRT(1+O8^2))","v":4.2904761787834182},"Ω",null,{"$f":"T8^2+U8^2","v":6.4457355235511216},{"$f":"IF(ISBLANK($D8),0,T8/Z8)","v":7.1602683212469362E-3},{"$f":"IF(ISBLANK($D8),0,-U8/Z8)","v":-0.39381475766858154},{"$f":"V8^2+W8^2","v":18.489999999999998},{"$f":"IF(ISBLANK($M8),0,V8/AC8)","v":1.5469537331110218E-2},{"$f":"IF(ISBLANK($M8),0,-W8/AC8)","v":-0.23204305996665325},"S",null,null,null,null,{"$f":"D8<0","v":false},null,{"$f":"F8<0","v":false},null,{"$f":"H8<0","v":false},null,null,null,null,{"$f":"M8<0","v":false},null,{"$f":"O8<0","v":false}]
[null,null,2,null,"%",null,null,null,"MVA",null,null,2,null,"Ω",null,null,null,null,{"$f":"IF(ISBLANK(D9),\"\",$V$6/100*$F$6^2/H9)","v":""},{"$f":"IF(ISBLANK(D9),\"\",S9*1/SQRT(1+F9^2))","v":""},{"$f":"IF(ISBLANK(D9),\"\",S9*F9/SQRT(1+F9^2))","v":""},{"$f":"IF(ISBLANK(M9),\"\",M9*1/SQRT(1+O9^2))","v":""},{"$f":"IF(ISBLANK(M9),\"\",M9*O9/SQRT(1+O9^2))","v":""},"Ω",null,{"$f":"T9^2+U9^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D9),0,T9/Z9)","v":0},{"$f":"IF(ISBLANK($D9),0,-U9/Z9)","v":0},{"$f":"V9^2+W9^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M9),0,V9/AC9)","v":0},{"$f":"IF(ISBLANK($M9),0,-W9/AC9)","v":0},"S",null,null,null,null,{"$f":"D9<0","v":false},null,{"$f":"F9<0","v":false},null,{"$f":"H9<0","v":false},null,null,null,null,{"$f":"M9<0","v":false},null,{"$f":"O9<0","v":false}]
[null,null,3,null,"%",null,null,null,"MVA",null,null,3,null,"Ω",null,null,null,null,"",{"$f":"IF(ISBLANK(D10),\"\",S10*1/SQRT(1+F10^2))","v":""},{"$f":"IF(ISBLANK(D10),\"\",S10*F10/SQRT(1+F10^2))","v":""},{"$f":"IF(ISBLANK(M10),\"\",M10*1/SQRT(1+O10^2))","v":""},{"$f":"IF(ISBLANK(M10),\"\",M10*O10/SQRT(1+O10^2))","v":""},"Ω",null,{"$f":"T10^2+U10^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D10),0,T10/Z10)","v":0},{"$f":"IF(ISBLANK($D10),0,-U10/Z10)","v":0},{"$f":"V10^2+W10^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M10),0,V10/AC10)","v":0},{"$f":"IF(ISBLANK($M10),0,-W10/AC10)","v":0},"S",null,null,null,null,{"$f":"D10<0","v":false},null,{"$f":"F10<0","v":false},null,{"$f":"H10<0","v":false},null,null,null,null,{"$f":"M10<0","v":false},null,{"$f":"O10<0","v":false}]
[null,null,4,null,"%",null,null,null,"MVA",null,null,4,null,"Ω",null,null,null,null,"",{"$f":"IF(ISBLANK(D11),\"\",S11*1/SQRT(1+F11^2))","v":""},{"$f":"IF(ISBLANK(D11),\"\",S11*F11/SQRT(1+F11^2))","v":""},{"$f":"IF(ISBLANK(M11),\"\",M11*1/SQRT(1+O11^2))","v":""},{"$f":"IF(ISBLANK(M11),\"\",M11*O11/SQRT(1+O11^2))","v":""},"Ω",null,{"$f":"T11^2+U11^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D11),0,T11/Z11)","v":0},{"$f":"IF(ISBLANK($D11),0,-U11/Z11)","v":0},{"$f":"V11^2+W11^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M11),0,V11/AC11)","v":0},{"$f":"IF(ISBLANK($M11),0,-W11/AC11)","v":0},"S",null,null,null,null,{"$f":"D11<0","v":false},null,{"$f":"F11<0","v":false},null,{"$f":"H11<0","v":false},null,null,null,null,{"$f":"M11<0","v":false},null,{"$f":"O11<0","v":false}]
[]
[null,null,"Tension nom. MT ph-ph :",24.94,"kV",null,null,null,null,null,null,null,null,null,null,null,null,null,"Z Total :",{"$f":"AA13/Z13+T4","v":6.9534922071797733E-2},{"$f":"-AB13/Z13+U4","v":2.6202618148868773},{"$f":"AD13/AC13","v":0.28603174525222791},{"$f":"-AE13/AC13","v":4.2904761787834182},"Ω",null,{"$f":"AA13^2+AB13^2","v":0.15514133279999584},{"$f":"SUM(AA8:AA11)","v":7.1602683212469362E-3},{"$f":"SUM(AB8:AB11)","v":-0.39381475766858154},{"$f":"AD13^2+AE13^2","v":5.408328826392645E-2},{"$f":"SUM(AD8:AD11)","v":1.5469537331110218E-2},{"$f":"SUM(AE8:AE11)","v":-0.23204305996665325},"S",null,null,null,null,{"$f":"D13<=0","v":false}]
[null,null,null,null,null,"FP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal","Source","Charge"]
[null,null,"Charge totale :",{"$f":"66*1.42*0.72","v":67.478399999999993},"MVA",98,"%",null,null,null,null,"Tension de la charge :",123,"V en base 120 V",null,null,null,null,null,null,null,null,null,null,null,"V ph-n",{"$f":"D13/SQRT(3)*1000","v":14399.115713589268},{"$f":"AA15*M4*F6/U6/D13","v":15606.397658285112},{"$f":"AA15*M15/120","v":14759.093606429},"V",null,null,null,null,null,null,{"$f":"D15<0","v":false},null,{"$f":"IF(D15=0,TRUE,OR(F15<75,F15>100))","v":false},null,null,null,null,{"$f":"OR(M15<90,M15>150)","v":false}]
[null,null,null,null,null,"Vnom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P:",{"$f":"D15*1000000","v":67478400},"W","FP",{"$f":"F15/100","v":0.98},"FR",{"$f":"SQRT(1-AD16^2)","v":0.1989974874213242}]
[null,null,"Condensateurs :",12,"Mvar",28.4,"kV",null,null,null,null,"Inductance-série des condensateurs:",1.2,"Ω",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idéséq x","Idéséq y",null,null,null,null,null,null,{"$f":"D17<0","v":false},null,{"$f":"IF(D17=0,TRUE,OR(F17<0.75*D13,F17>1.2*D13))","v":false},null,null,null,null,null,null,{"$f":"M17<0","v":false}]
[null,null,null,null,null,"Angle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y condens + is",{"$f":"IF(OR(ISBLANK(D17),D17=0),0,-1/(M17-F17^2/D17))","v":1.5148454857604528E-2},"Ω",{"$f":"D19*COS(F19/180*PI())*3","v":138.35080549885555},{"$f":"D19*SIN(F19/180*PI())*3","v":31.940800206285388},"A"]
[null,null,"Déséquilibre (I0) :",47.33,"A",13,"°",null,"A","B","C",null,"Moy","ΔV",null,null,null,null,null,null,null,null,null,null,null,"Fact correction final",{"$f":"I20/AA44*AA20","v":1.0310010956764031},{"$f":"J20/AB44*AB20","v":1.0072165034985481},{"$f":"K20/AC44*AC20","v":1.0183716186109071},null,"Écart final initial",{"$f":"SQRT((AA44-I20)^2+(AB44-J20)^2+(AC44-K20)^2)/M20","v":2.8698064340834377E-6},null,null,null,null,{"$f":"D19<0","v":false},null,{"$f":"ISERR(Angle)","v":false}]
[null,null,null,null,null,null,null,"Courant :",{"$f":"IF(Erreur,\"\",AC18*2/3+M20)","v":1616.2298960913765},{"$f":"IF(Erreur,\"\",-AC18/3-SQRT(3)/3*AD18+M20)","v":1459.43806099529},{"$f":"IF(Erreur,\"\",-AC18/3+SQRT(3)/3*AD18+M20)","v":1496.3201201897518},null,{"$f":"AA16/3/AC15","v":1523.9960257588061},null,"A",null,null,null,null,null,null,null,null,null,null,"Fact correction initial",1.030999907169253,1.0072183139205719,1.0183696025059463]
[null,null,null,null,null,null,null,"Tension :",{"$f":"IF(Erreur,\"\",AA44*AF25/$AA$15*120)","v":121.47079324484449},{"$f":"IF(Erreur,\"\",AB44*AG25/$AA$15*120)","v":124.46848777207126},{"$f":"IF(Erreur,\"\",AC44*AH25/$AA$15*120)","v":123.07101340095954},null,{"$f":"(I21+J21+K21)/3","v":123.0034314726251},{"$f":"IF(Erreur,\"\",MAX(I21:K21)-MIN(I21:K21))","v":2.9976945272267699},"V (base 120 V)",null,null,null,null,null,null,null,null,null,null,"Admittance de charge","A","B","C",null,"Impédance de charge","A","B","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I20/$AC$15*AA20","v":0.11290211426726998},{"$f":"J20/$AC$15*AB20","v":9.9597765436413438E-2},{"$f":"K20/$AC$15*AC20","v":0.10324529179458035},"S",null,{"$f":"AA23^2+AA24^2","v":1.2295675237722181E-2},{"$f":"AB23^2+AB24^2","v":9.54871474927174E-3},1.0266599178180257E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gp",{"$f":"AA22*$AD$16","v":0.11064407198192458},9.7605810127685169E-2,0.10118038595868874,"S","Rs",{"$f":"AA23/AF22","v":8.9986169805849396},{"$f":"AB23/AG22","v":10.221879351368136},9.8552971829005251,"Ω"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bp",{"$f":"-AA22*$AF$16+$AA$18","v":-7.3187822061374364E-3},{"$f":"-AB22*$AF$16+$AA$18","v":-4.6712502170201536E-3},{"$f":"-AC22*$AF$16+$AA$18","v":-5.3970987975984208E-3},"S","Xs",{"$f":"-AA24/AF22","v":0.59523223122256663},{"$f":"-AB24/AG22","v":0.48920198578310448},0.52569489700824679,"Ω"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zs",{"$f":"SQRT(AF23^2+AF24^2)","v":9.0182819301881345},{"$f":"SQRT(AG23^2+AG24^2)","v":10.233578848908158},9.8693078626632946,"Ω"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice Z"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r",{"$f":"Z29+AF23","v":9.1403175103835466},{"$f":"Z30","v":7.2165607726810063E-2},{"$f":"Z30","v":7.2165607726810063E-2},{"$f":"-AA31","v":-3.772232167408291},-0.55673812129884703,-0.55673812129884703]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(V13+2*T13)/3","v":0.14170052979860778},{"$f":"Z30","v":7.2165607726810063E-2},{"$f":"Z29+AG23","v":10.363579881166743},{"$f":"Z30","v":7.2165607726810063E-2},-0.55673812129884703,-3.6662019219688289,-0.55673812129884703]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(V13-T13)/3","v":7.2165607726810063E-2},{"$f":"Z30","v":7.2165607726810063E-2},{"$f":"Z30","v":7.2165607726810063E-2},{"$f":"Z29+AH23","v":9.9969977126991321},-0.55673812129884703,-0.55673812129884703,-3.7026948331939713]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i",{"$f":"Z32+AF24","v":3.772232167408291},{"$f":"Z33","v":0.55673812129884703},{"$f":"Z33","v":0.55673812129884703},{"$f":"AA28","v":9.1403175103835466},7.2165607726810063E-2,7.2165607726810063E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W13+2*U13)/3","v":3.1769999361857244},{"$f":"Z33","v":0.55673812129884703},{"$f":"Z32+AG24","v":3.6662019219688289},{"$f":"Z33","v":0.55673812129884703},7.2165607726810063E-2,10.363579881166743,7.2165607726810063E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W13-U13)/3","v":0.55673812129884703},{"$f":"Z33","v":0.55673812129884703},{"$f":"Z33","v":0.55673812129884703},{"$f":"Z32+AH24","v":3.7026948331939713},7.2165607726810063E-2,7.2165607726810063E-2,9.9969977126991321]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice Y",null,null,null,null,null,null,"Matrice Vs",null,"Matrice Is"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MINVERSE(AA28:AF33)","v":9.3400659462319763E-2},-3.9364044936146545E-3,-4.1079401622022699E-3,3.8007111289682649E-2,3.1176363152878106E-3,3.1639419080108323E-3,null,{"$f":"$AB$15","v":15606.397658285112},null,{"$f":"MMULT(AA36:AF41,AH36:AH41)","v":1521.0452988585735}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.9364044936146545E-3,8.5653109113726963E-2,-3.53823156270618E-3,3.1176363152878111E-3,2.9856336450619973E-2,3.0023239938438929E-3,null,{"$f":"-$AB$15/2","v":-7803.198829142556},null,-1065.1382047230213]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.1079401622022699E-3,-3.53823156270618E-3,8.7862839870068432E-2,3.1639419080108323E-3,3.002323993843892E-3,3.2072366606815776E-2,"⨯",{"$f":"AH37","v":-7803.198829142556},"=",-329.21460084866754]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.8007111289682649E-2,-3.1176363152878106E-3,-3.1639419080108323E-3,9.3400659462319777E-2,-3.9364044936146527E-3,-4.1079401622022699E-3,null,0,null,-546.45608543935202]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.1176363152878102E-3,-2.9856336450619983E-2,-3.0023239938438916E-3,-3.9364044936146536E-3,8.5653109113726963E-2,-3.5382315627061796E-3,null,{"$f":"-SQRT(3)/2*AB15","v":-13515.536833636881},null,-997.72126153664647]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.1639419080108323E-3,-3.0023239938438934E-3,-3.2072366606815776E-2,-4.1079401622022699E-3,-3.5382315627061787E-3,8.7862839870068432E-2,null,{"$f":"-AH40","v":13515.536833636881},null,1459.6515966270156]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I charge calculé",{"$f":"SQRT(AJ36^2+AJ39^2)","v":1616.2280329500127},{"$f":"SQRT(AJ37^2+AJ40^2)","v":1459.4406842632757},{"$f":"SQRT(AJ38^2+AJ41^2)","v":1496.3171578738722},{"$f":"SQRT(AA44^2+AB44^2+AC44^2-AA44*AB44-AA44*AC44-AB44*AC44)/3","v":47.329087236600266},"A"]

{"sheet":"Ex 6-5","index":1,"n_rows":44,"n_cols":48,"rows_kept":44,"cut":false,"hidden":false,"merged":[[20,30,21,30],[37,32,38,32],[37,34,38,34],[4,1,5,1],[6,19,6,20],[6,21,6,22],[7,1,9,1],[7,9,9,10],[20,25,21,25]]}
[null,"Complément au cours \"Caractéristiques électriques des postes de distribution HT/MT\", module 2"]
[null,"Calcul de l'écart de tension max entre phases MT (3E Ing.,  J.P. Laflamme, ing. 2015-03-09)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impédance source MT"]
[null,null,null,"R1",null,"X1",null,null,null,null,null,null,null,null,null,null,null,null,"Z","R1","X1","R0","X0",null,null,null,null,null,null,null,null,null,null,null,null,null,"Validation d'erreur"]
[null,null,"Impédance source HT :",3.2000000000000002E-3,null,1.12E-2,"p.u. (100 MVA)",null,null,null,null,"Tension source HT :",315,"kV",null,null,null,null,"HT",{"$f":"D4*S5","v":2.3377309201317885E-2},{"$f":"F4*S5","v":8.1820582204612594E-2},null,null,"Ω",null,"Validation d'erreur",{"$f":"IF(ISERR(AB4),TRUE,OR(AB4,AC4,Erreur2))","v":false},{"$f":"OR(AK4:AV19)","v":false},{"$f":"OR(ISERR(T13),ISERR(V13),ISERR(AB4))","v":false},false,null,null,null,null,null,null,{"$f":"D4<0","v":false},null,{"$f":"F4<0","v":false},null,null,null,null,null,null,{"$f":"M4<=0","v":false}]
[null,"Tension nominale  des transfos",null,"HT",null,"MT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M4^2/100*(F6/U6)^2","v":7.3054091254118383}]
[null,null,null,310,null,26.4,"kV",null,null,null,null,"Prise de régulation :",9.4,null,null,null,null,null,null,{"$f":"-(M6-9)/8*0.15","v":-7.5000000000000067E-3},{"$f":"(1+T6)*D6","v":307.67499999999995},{"$f":"(1-0.7717*T6+1.4798*T6^2)*D8","v":24.040316631125002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(D6<0.8*M4,D6>1.2*M4)","v":false},null,{"$f":"OR(F6<0.8*D13,F6>1.3*D13)","v":false},null,null,null,null,null,null,{"$f":"OR(M6<1,M6>17)","v":false}]
[null,null,null,"Z",null,"X/R",null,"Puissance",null,null,null,null,"Z",null,"X/R",null,null,null,"Transfos","Puissance",null,"MALT",null,null,null,null,"G1","B1",null,"G0","B0"]
[null,"Impédance transfos de puissance YNd",1,23.9,"%",55,null,66,"MVA","Impédance transfos de MALT",null,1,6.42,"Ω",15,null,null,null,{"$f":"IF(ISBLANK(D8),\"\",$V$6/100*$F$6^2/H8)","v":2.5386574362468002},{"$f":"IF(ISBLANK(D8),\"\",S8*1/SQRT(1+F8^2))","v":4.6149780499181815E-2},{"$f":"IF(ISBLANK(D8),\"\",S8*F8/SQRT(1+F8^2))","v":2.538237927455},{"$f":"IF(ISBLANK(M8),\"\",M8*1/SQRT(1+O8^2))","v":0.42705204756262866},{"$f":"IF(ISBLANK(M8),\"\",M8*O8/SQRT(1+O8^2))","v":6.4057807134394293},"Ω",null,{"$f":"T8^2+U8^2","v":6.4447815786111757},{"$f":"IF(ISBLANK($D8),0,T8/Z8)","v":7.1607982266370159E-3},{"$f":"IF(ISBLANK($D8),0,-U8/Z8)","v":-0.39384390246503592},{"$f":"V8^2+W8^2","v":41.2164},{"$f":"IF(ISBLANK($M8),0,V8/AC8)","v":1.0361216592488152E-2},{"$f":"IF(ISBLANK($M8),0,-W8/AC8)","v":-0.15541824888732225},"S",null,null,null,null,{"$f":"D8<0","v":false},null,{"$f":"F8<0","v":false},null,{"$f":"H8<0","v":false},null,null,null,null,{"$f":"M8<0","v":false},null,{"$f":"O8<0","v":false}]
[null,null,2,null,"%",null,null,null,"MVA",null,null,2,null,"Ω",null,null,null,null,{"$f":"IF(ISBLANK(D9),\"\",$V$6/100*$F$6^2/H9)","v":""},{"$f":"IF(ISBLANK(D9),\"\",S9*1/SQRT(1+F9^2))","v":""},{"$f":"IF(ISBLANK(D9),\"\",S9*F9/SQRT(1+F9^2))","v":""},{"$f":"IF(ISBLANK(M9),\"\",M9*1/SQRT(1+O9^2))","v":""},{"$f":"IF(ISBLANK(M9),\"\",M9*O9/SQRT(1+O9^2))","v":""},"Ω",null,{"$f":"T9^2+U9^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D9),0,T9/Z9)","v":0},{"$f":"IF(ISBLANK($D9),0,-U9/Z9)","v":0},{"$f":"V9^2+W9^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M9),0,V9/AC9)","v":0},{"$f":"IF(ISBLANK($M9),0,-W9/AC9)","v":0},"S",null,null,null,null,{"$f":"D9<0","v":false},null,{"$f":"F9<0","v":false},null,{"$f":"H9<0","v":false},null,null,null,null,{"$f":"M9<0","v":false},null,{"$f":"O9<0","v":false}]
[null,null,3,null,"%",null,null,null,"MVA",null,null,3,null,"Ω",null,null,null,null,"",{"$f":"IF(ISBLANK(D10),\"\",S10*1/SQRT(1+F10^2))","v":""},{"$f":"IF(ISBLANK(D10),\"\",S10*F10/SQRT(1+F10^2))","v":""},{"$f":"IF(ISBLANK(M10),\"\",M10*1/SQRT(1+O10^2))","v":""},{"$f":"IF(ISBLANK(M10),\"\",M10*O10/SQRT(1+O10^2))","v":""},"Ω",null,{"$f":"T10^2+U10^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D10),0,T10/Z10)","v":0},{"$f":"IF(ISBLANK($D10),0,-U10/Z10)","v":0},{"$f":"V10^2+W10^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M10),0,V10/AC10)","v":0},{"$f":"IF(ISBLANK($M10),0,-W10/AC10)","v":0},"S",null,null,null,null,{"$f":"D10<0","v":false},null,{"$f":"F10<0","v":false},null,{"$f":"H10<0","v":false},null,null,null,null,{"$f":"M10<0","v":false},null,{"$f":"O10<0","v":false}]
[null,null,4,null,"%",null,null,null,"MVA",null,null,4,null,"Ω",null,null,null,null,"",{"$f":"IF(ISBLANK(D11),\"\",S11*1/SQRT(1+F11^2))","v":""},{"$f":"IF(ISBLANK(D11),\"\",S11*F11/SQRT(1+F11^2))","v":""},{"$f":"IF(ISBLANK(M11),\"\",M11*1/SQRT(1+O11^2))","v":""},{"$f":"IF(ISBLANK(M11),\"\",M11*O11/SQRT(1+O11^2))","v":""},"Ω",null,{"$f":"T11^2+U11^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D11),0,T11/Z11)","v":0},{"$f":"IF(ISBLANK($D11),0,-U11/Z11)","v":0},{"$f":"V11^2+W11^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M11),0,V11/AC11)","v":0},{"$f":"IF(ISBLANK($M11),0,-W11/AC11)","v":0},"S",null,null,null,null,{"$f":"D11<0","v":false},null,{"$f":"F11<0","v":false},null,{"$f":"H11<0","v":false},null,null,null,null,{"$f":"M11<0","v":false},null,{"$f":"O11<0","v":false}]
[]
[null,null,"Tension nom. MT ph-ph :",24.94,"kV",null,null,null,null,null,null,null,null,null,null,null,null,null,"Z Total :",{"$f":"AA13/Z13+T4","v":6.95270897004997E-2},{"$f":"-AB13/Z13+U4","v":2.6200585096596121},{"$f":"AD13/AC13","v":0.42705204756262877},{"$f":"-AE13/AC13","v":6.4057807134394302},"Ω",null,{"$f":"AA13^2+AB13^2","v":0.15516429654013134},{"$f":"SUM(AA8:AA11)","v":7.1607982266370159E-3},{"$f":"SUM(AB8:AB11)","v":-0.39384390246503592},{"$f":"AD13^2+AE13^2","v":2.4262186896478095E-2},{"$f":"SUM(AD8:AD11)","v":1.0361216592488152E-2},{"$f":"SUM(AE8:AE11)","v":-0.15541824888732225},"S",null,null,null,null,{"$f":"D13<=0","v":false}]
[null,null,null,null,null,"FP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal","Source","Charge"]
[null,null,"Charge totale :",{"$f":"66*1.42*0.72","v":67.478399999999993},"MVA",98,"%",null,null,null,null,"Tension de la charge :",123,"V en base 120 V",null,null,null,null,null,null,null,null,null,null,null,"V ph-n",{"$f":"D13/SQRT(3)*1000","v":14399.115713589268},{"$f":"AA15*M4*F6/U6/D13","v":15604.923502335025},{"$f":"AA15*M15/120","v":14759.093606429},"V",null,null,null,null,null,null,{"$f":"D15<0","v":false},null,{"$f":"IF(D15=0,TRUE,OR(F15<75,F15>100))","v":false},null,null,null,null,{"$f":"OR(M15<90,M15>150)","v":false}]
[null,null,null,null,null,"Vnom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P:",{"$f":"D15*1000000","v":67478400},"W","FP",{"$f":"F15/100","v":0.98},"FR",{"$f":"SQRT(1-AD16^2)","v":0.1989974874213242}]
[null,null,"Condensateurs :",12,"Mvar",28.4,"kV",null,null,null,null,"Inductance-série des condensateurs:",1.2,"Ω",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idéséq x","Idéséq y",null,null,null,null,null,null,{"$f":"D17<0","v":false},null,{"$f":"IF(D17=0,TRUE,OR(F17<0.75*D13,F17>1.2*D13))","v":false},null,null,null,null,null,null,{"$f":"M17<0","v":false}]
[null,null,null,null,null,"Angle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y condens + is",{"$f":"IF(OR(ISBLANK(D17),D17=0),0,-1/(M17-F17^2/D17))","v":1.5148454857604528E-2},"Ω",{"$f":"D19*COS(F19/180*PI())*3","v":91.173510720337163},{"$f":"D19*SIN(F19/180*PI())*3","v":14.440465467863712},"A"]
[null,null,"Déséquilibre (I0) :",30.77,"A",9,"°",null,"A","B","C",null,"Moy","ΔV",null,null,null,null,null,null,null,null,null,null,null,"Fact correction final",{"$f":"I20/AA44*AA20","v":1.0311552182728976},{"$f":"J20/AB44*AB20","v":1.0070365302935487},{"$f":"K20/AC44*AC20","v":1.0185654234057808},null,"Écart final initial",{"$f":"SQRT((AA44-I20)^2+(AB44-J20)^2+(AC44-K20)^2)/M20","v":3.3041675370739696E-6},null,null,null,null,{"$f":"D19<0","v":false},null,{"$f":"ISERR(Angle)","v":false}]
[null,null,null,null,null,null,null,"Courant :",{"$f":"IF(Erreur,\"\",AC18*2/3+M20)","v":1584.7783662390309},{"$f":"IF(Erreur,\"\",-AC18/3-SQRT(3)/3*AD18+M20)","v":1485.267648893599},{"$f":"IF(Erreur,\"\",-AC18/3+SQRT(3)/3*AD18+M20)","v":1501.9420621437885},null,{"$f":"AA16/3/AC15","v":1523.9960257588061},null,"A",null,null,null,null,null,null,null,null,null,null,"Fact correction initial",1.03115601088187,1.0070383191280252,1.0185626345092984]
[null,null,null,null,null,null,null,"Tension :",{"$f":"IF(Erreur,\"\",AA44*AF25/$AA$15*120)","v":121.47376823336641},{"$f":"IF(Erreur,\"\",AB44*AG25/$AA$15*120)","v":124.47441040227955},{"$f":"IF(Erreur,\"\",AC44*AH25/$AA$15*120)","v":123.04372248773133},null,{"$f":"(I21+J21+K21)/3","v":122.99730037445909},{"$f":"IF(Erreur,\"\",MAX(I21:K21)-MIN(I21:K21))","v":3.0006421689131315},"V (base 120 V)",null,null,null,null,null,null,null,null,null,null,"Admittance de charge","A","B","C",null,"Impédance de charge","A","B","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I20/$AC$15*AA20","v":0.11072182220940016},{"$f":"J20/$AC$15*AB20","v":0.10134236400164261},{"$f":"K20/$AC$15*AC20","v":0.10365284647501127},"S",null,{"$f":"AA23^2+AA24^2","v":1.1821254745315719E-2},{"$f":"AB23^2+AB24^2","v":9.8887564104922707E-3},1.0348464332004858E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gp",{"$f":"AA22*$AD$16","v":0.10850738576521216},9.9315516721609751E-2,0.10157978954551104,"S","Rs",{"$f":"AA23/AF22","v":9.1790074829585429},{"$f":"AB23/AG22","v":10.04327668706987},9.8159288457277309,"Ω"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bp",{"$f":"-AA22*$AF$16+$AA$18","v":-6.8849095647766749E-3},{"$f":"-AB22*$AF$16+$AA$18","v":-5.0184209480596056E-3},{"$f":"-AC22*$AF$16+$AA$18","v":-5.4782011549909769E-3},"S","Xs",{"$f":"-AA24/AF22","v":0.58241783237983968},{"$f":"-AB24/AG22","v":0.50748756868304579},0.52937334267544012,"Ω"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zs",{"$f":"SQRT(AF23^2+AF24^2)","v":9.1974664393887817},{"$f":"SQRT(AG23^2+AG24^2)","v":10.056090206706033},9.8301930418646979,"Ω"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice Z"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r",{"$f":"Z29+AF23","v":9.3677095586130861},{"$f":"Z30","v":0.11917498595404302},{"$f":"Z30","v":0.11917498595404302},{"$f":"-AA31","v":-4.4643837432993916},-1.2619074012599394,-1.2619074012599394]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(V13+2*T13)/3","v":0.18870207565454269},{"$f":"Z30","v":0.11917498595404302},{"$f":"Z29+AG23","v":10.231978762724413},{"$f":"Z30","v":0.11917498595404302},-1.2619074012599394,-4.3894534796025972,-1.2619074012599394]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(V13-T13)/3","v":0.11917498595404302},{"$f":"Z30","v":0.11917498595404302},{"$f":"Z30","v":0.11917498595404302},{"$f":"Z29+AH23","v":10.004630921382274},-1.2619074012599394,-1.2619074012599394,-4.411339253594992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i",{"$f":"Z32+AF24","v":4.4643837432993916},{"$f":"Z33","v":1.2619074012599394},{"$f":"Z33","v":1.2619074012599394},{"$f":"AA28","v":9.3677095586130861},0.11917498595404302,0.11917498595404302]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W13+2*U13)/3","v":3.8819659109195519},{"$f":"Z33","v":1.2619074012599394},{"$f":"Z32+AG24","v":4.3894534796025972},{"$f":"Z33","v":1.2619074012599394},0.11917498595404302,10.231978762724413,0.11917498595404302]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W13-U13)/3","v":1.2619074012599394},{"$f":"Z33","v":1.2619074012599394},{"$f":"Z33","v":1.2619074012599394},{"$f":"Z32+AH24","v":4.411339253594992},0.11917498595404302,0.11917498595404302,10.004630921382274]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice Y",null,null,null,null,null,null,"Matrice Vs",null,"Matrice Is"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MINVERSE(AA28:AF33)","v":8.6963082413593629E-2},-8.6880982432813898E-3,-8.9105554173682568E-3,3.8936067670813E-2,5.3824762676151026E-3,5.4161555332217174E-3,null,{"$f":"$AB$15","v":15604.923502335025},null,{"$f":"MMULT(AA36:AF41,AH36:AH41)","v":1494.8202210086304}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-8.6880982432813881E-3,8.238998820534614E-2,-8.066863716151668E-3,5.3824762676151017E-3,3.3154201232052594E-2,5.2802227569307475E-3,null,{"$f":"-$AB$15/2","v":-7802.4617511675124},null,-1092.1766418060351]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-8.9105554173682551E-3,-8.066863716151668E-3,8.3561274499551308E-2,5.4161555332217148E-3,5.2802227569307475E-3,3.4575834071961402E-2,"⨯",{"$f":"AH37","v":-7802.4617511675124},"=",-332.18227485620923]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.8936067670812993E-2,-5.3824762676151008E-3,-5.4161555332217165E-3,8.6963082413593615E-2,-8.6880982432813881E-3,-8.9105554173682568E-3,null,0,null,-526.34479002268642]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.3824762676151E-3,-3.3154201232052601E-2,-5.2802227569307475E-3,-8.6880982432813881E-3,8.2389988205346126E-2,-8.0668637161516663E-3,null,{"$f":"-SQRT(3)/2*AB15","v":-13514.260177134965},null,-1006.5674389787617]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.4161555332217174E-3,-5.2802227569307475E-3,-3.4575834071961402E-2,-8.9105554173682586E-3,-8.066863716151668E-3,8.3561274499551294E-2,null,{"$f":"-AH40","v":13514.260177134965},null,1464.7431655806092]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I charge calculé",{"$f":"SQRT(AJ36^2+AJ39^2)","v":1584.7795843966178},{"$f":"SQRT(AJ37^2+AJ40^2)","v":1485.2702872268642},{"$f":"SQRT(AJ38^2+AJ41^2)","v":1501.9379497315294},{"$f":"SQRT(AA44^2+AB44^2+AC44^2-AA44*AB44-AA44*AC44-AB44*AC44)/3","v":30.770338920037361},"A"]

{"sheet":"Ex 6-6","index":2,"n_rows":44,"n_cols":48,"rows_kept":44,"cut":false,"hidden":false,"merged":[[20,30,21,30],[37,32,38,32],[37,34,38,34],[4,1,5,1],[6,19,6,20],[6,21,6,22],[7,1,9,1],[7,9,9,10],[20,25,21,25]]}
[null,"Complément au cours \"Caractéristiques électriques des postes de distribution HT/MT\", module 2"]
[null,"Calcul de l'écart de tension max entre phases MT (3E Ing.,  J.P. Laflamme, ing. 2015-03-09)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impédance source MT"]
[null,null,null,"R1",null,"X1",null,null,null,null,null,null,null,null,null,null,null,null,"Z","R1","X1","R0","X0",null,null,null,null,null,null,null,null,null,null,null,null,null,"Validation d'erreur"]
[null,null,"Impédance source HT :",3.2000000000000002E-3,null,1.12E-2,"p.u. (100 MVA)",null,null,null,null,"Tension source HT :",315,"kV",null,null,null,null,"HT",{"$f":"D4*S5","v":2.4735707332156624E-2},{"$f":"F4*S5","v":8.6574975662548181E-2},null,null,"Ω",null,"Validation d'erreur",{"$f":"IF(ISERR(AB4),TRUE,OR(AB4,AC4,Erreur2))","v":false},{"$f":"OR(AK4:AV19)","v":false},{"$f":"OR(ISERR(T13),ISERR(V13),ISERR(AB4))","v":false},false,null,null,null,null,null,null,{"$f":"D4<0","v":false},null,{"$f":"F4<0","v":false},null,null,null,null,null,null,{"$f":"M4<=0","v":false}]
[null,"Tension nominale  des transfos",null,"HT",null,"MT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M4^2/100*(F6/U6)^2","v":7.7299085412989443}]
[null,null,null,285,null,26.4,"kV",null,null,null,null,"Prise de régulation :",6.36,null,null,null,null,null,null,{"$f":"-(M6-9)/8*0.15","v":4.9499999999999995E-2},{"$f":"(1+T6)*D6","v":299.10750000000002},{"$f":"(1-0.7717*T6+1.4798*T6^2)*D8","v":31.376368723375002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(D6<0.8*M4,D6>1.2*M4)","v":false},null,{"$f":"OR(F6<0.8*D13,F6>1.3*D13)","v":false},null,null,null,null,null,null,{"$f":"OR(M6<1,M6>17)","v":false}]
[null,null,null,"Z",null,"X/R",null,"Puissance",null,null,null,null,"Z",null,"X/R",null,null,null,"Transfos","Puissance",null,"MALT",null,null,null,null,"G1","B1",null,"G0","B0"]
[null,"Impédance transfos de puissance YNd",1,32.5,"%",70,null,140,"MVA","Impédance transfos de MALT",null,1,3.82,"Ω",15,null,null,null,{"$f":"IF(ISBLANK(D8),\"\",$V$6/100*$F$6^2/H8)","v":1.5620052818173884},{"$f":"IF(ISBLANK(D8),\"\",U8/F8)","v":2.2312084541647778E-2},{"$f":"IF(ISBLANK(D8),\"\",S8*F8/SQRT(1+F8^2))","v":1.5618459179153446},{"$f":"IF(ISBLANK(M8),\"\",W8/O8)","v":0.25410262020081642},{"$f":"IF(ISBLANK(M8),\"\",M8*O8/SQRT(1+O8^2))","v":3.8115393030122462},"Ω",null,{"$f":"T8^2+U8^2","v":2.4398605004254188},{"$f":"IF(ISBLANK($D8),0,T8/Z8)","v":9.1448197705390945E-3},{"$f":"IF(ISBLANK($D8),0,-U8/Z8)","v":-0.64013738393773667},{"$f":"V8^2+W8^2","v":14.5924},{"$f":"IF(ISBLANK($M8),0,V8/AC8)","v":1.7413353540254955E-2},{"$f":"IF(ISBLANK($M8),0,-W8/AC8)","v":-0.26120030310382436},"S",null,null,null,null,{"$f":"D8<0","v":false},null,{"$f":"F8<0","v":false},null,{"$f":"H8<0","v":false},null,null,null,null,{"$f":"M8<0","v":false},null,{"$f":"O8<0","v":false}]
[null,null,2,null,"%",null,null,null,"MVA",null,null,2,null,"Ω",null,null,null,null,{"$f":"IF(ISBLANK(D9),\"\",$V$6/100*$F$6^2/H9)","v":""},"",{"$f":"IF(ISBLANK(D9),\"\",S9*F9/SQRT(1+F9^2))","v":""},"",{"$f":"IF(ISBLANK(M9),\"\",M9*O9/SQRT(1+O9^2))","v":""},"Ω",null,{"$f":"T9^2+U9^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D9),0,T9/Z9)","v":0},{"$f":"IF(ISBLANK($D9),0,-U9/Z9)","v":0},{"$f":"V9^2+W9^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M9),0,V9/AC9)","v":0},{"$f":"IF(ISBLANK($M9),0,-W9/AC9)","v":0},"S",null,null,null,null,{"$f":"D9<0","v":false},null,{"$f":"F9<0","v":false},null,{"$f":"H9<0","v":false},null,null,null,null,{"$f":"M9<0","v":false},null,{"$f":"O9<0","v":false}]
[null,null,3,null,"%",null,null,null,"MVA",null,null,3,null,"Ω",null,null,null,null,"","",{"$f":"IF(ISBLANK(D10),\"\",S10*F10/SQRT(1+F10^2))","v":""},"",{"$f":"IF(ISBLANK(M10),\"\",M10*O10/SQRT(1+O10^2))","v":""},"Ω",null,{"$f":"T10^2+U10^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D10),0,T10/Z10)","v":0},{"$f":"IF(ISBLANK($D10),0,-U10/Z10)","v":0},{"$f":"V10^2+W10^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M10),0,V10/AC10)","v":0},{"$f":"IF(ISBLANK($M10),0,-W10/AC10)","v":0},"S",null,null,null,null,{"$f":"D10<0","v":false},null,{"$f":"F10<0","v":false},null,{"$f":"H10<0","v":false},null,null,null,null,{"$f":"M10<0","v":false},null,{"$f":"O10<0","v":false}]
[null,null,4,null,"%",null,null,null,"MVA",null,null,4,null,"Ω",null,null,null,null,"","",{"$f":"IF(ISBLANK(D11),\"\",S11*F11/SQRT(1+F11^2))","v":""},"",{"$f":"IF(ISBLANK(M11),\"\",M11*O11/SQRT(1+O11^2))","v":""},"Ω",null,{"$f":"T11^2+U11^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D11),0,T11/Z11)","v":0},{"$f":"IF(ISBLANK($D11),0,-U11/Z11)","v":0},{"$f":"V11^2+W11^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M11),0,V11/AC11)","v":0},{"$f":"IF(ISBLANK($M11),0,-W11/AC11)","v":0},"S",null,null,null,null,{"$f":"D11<0","v":false},null,{"$f":"F11<0","v":false},null,{"$f":"H11<0","v":false},null,null,null,null,{"$f":"M11<0","v":false},null,{"$f":"O11<0","v":false}]
[]
[null,null,"Tension nom. MT ph-ph :",24.94,"kV",null,null,null,null,null,null,null,null,null,null,null,null,null,"Z Total :",{"$f":"AA13/Z13+T4","v":4.7047791873804402E-2},{"$f":"-AB13/Z13+U4","v":1.6484208935778928},{"$f":"AD13/AC13","v":0.25410262020081636},{"$f":"-AE13/AC13","v":3.8115393030122462},"Ω",null,{"$f":"AA13^2+AB13^2","v":0.40985949804328492},{"$f":"SUM(AA8:AA11)","v":9.1448197705390945E-3},{"$f":"SUM(AB8:AB11)","v":-0.64013738393773667},{"$f":"AD13^2+AE13^2","v":6.8528823223047625E-2},{"$f":"SUM(AD8:AD11)","v":1.7413353540254955E-2},{"$f":"SUM(AE8:AE11)","v":-0.26120030310382436},"S",null,null,null,null,{"$f":"D13<=0","v":false}]
[null,null,null,null,null,"FP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal","Source","Charge"]
[null,null,"Charge totale :",{"$f":"140*1.42*0.72","v":143.136},"MVA",98,"%",null,null,null,null,"Tension de la charge :",123,"V en base 120 V",null,null,null,null,null,null,null,null,null,null,null,"V ph-n",{"$f":"D13/SQRT(3)*1000","v":14399.115713589268},{"$f":"AA15*M4*F6/U6/D13","v":16051.903875967428},{"$f":"AA15*M15/120","v":14759.093606429},"V",null,null,null,null,null,null,{"$f":"D15<0","v":false},null,{"$f":"IF(D15=0,TRUE,OR(F15<75,F15>100))","v":false},null,null,null,null,{"$f":"OR(M15<90,M15>150)","v":false}]
[null,null,null,null,null,"Vnom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P:",{"$f":"D15*1000000","v":143136000},"W","FP",{"$f":"F15/100","v":0.98},"FR",{"$f":"SQRT(1-AD16^2)","v":0.1989974874213242}]
[null,null,"Condensateurs :",24,"Mvar",26.8,"kV",null,null,null,null,"Inductance-série des condensateurs:",1.2,"Ω",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idéséq x","Idéséq y",null,null,null,null,null,null,{"$f":"D17<0","v":false},null,{"$f":"IF(D17=0,TRUE,OR(F17<0.75*D13,F17>1.2*D13))","v":false},null,null,null,null,null,null,{"$f":"M17<0","v":false}]
[null,null,null,null,null,"Angle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y condens + is",{"$f":"IF(OR(ISBLANK(D17),D17=0),0,-1/(M17-F17^2/D17))","v":3.4810860988628449E-2},"S",{"$f":"D19*COS(F19/180*PI())*3","v":25.650453248468935},{"$f":"D19*SIN(F19/180*PI())*3","v":131.96014227086948},"A"]
[null,null,"Déséquilibre (I0) :",44.81,"A",79,"°",null,"A","B","C",null,"Moy","ΔV",null,null,null,null,null,null,null,null,null,null,null,"Fact correction final",{"$f":"I20/AA44*AA20","v":1.0190768128591554},{"$f":"J20/AB44*AB20","v":1.0075083100594155},{"$f":"K20/AC44*AC20","v":1.0319186272721355},null,"Écart final initial",{"$f":"SQRT((AA44-I20)^2+(AB44-J20)^2+(AC44-K20)^2)/M20","v":6.3512313806113394E-6},null,null,null,null,{"$f":"D19<0","v":false},null,{"$f":"ISERR(Angle)","v":false}]
[null,null,null,null,null,null,null,"Courant :",{"$f":"IF(Erreur,\"\",AC18*2/3+M20)","v":3249.8191446843257},{"$f":"IF(Erreur,\"\",-AC18/3-SQRT(3)/3*AD18+M20)","v":3147.9814677734689},{"$f":"IF(Erreur,\"\",-AC18/3+SQRT(3)/3*AD18+M20)","v":3300.3559150982446},null,{"$f":"AA16/3/AC15","v":3232.7188425186796},null,"A",null,null,null,null,null,null,null,null,null,null,"Fact correction initial",1.0190807893409897,1.0075087720453622,1.0319135986191463]
[null,null,null,null,null,null,null,"Tension :",{"$f":"IF(Erreur,\"\",AA44*AF25/$AA$15*120)","v":123.03750876347331},{"$f":"IF(Erreur,\"\",AB44*AG25/$AA$15*120)","v":124.48613826839292},{"$f":"IF(Erreur,\"\",AC44*AH25/$AA$15*120)","v":121.48153238089708},null,{"$f":"(I21+J21+K21)/3","v":123.0017264709211},{"$f":"IF(Erreur,\"\",MAX(I21:K21)-MIN(I21:K21))","v":3.0046058874958419},"V (base 120 V)",null,null,null,null,null,null,null,null,null,null,"Admittance de charge","A","B","C",null,"Impédance de charge","A","B","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I20/$AC$15*AA20","v":0.22439238800801048},{"$f":"J20/$AC$15*AB20","v":0.21489252847047874},{"$f":"K20/$AC$15*AC20","v":0.23075144313669196},"S",null,{"$f":"AA23^2+AA24^2","v":4.845488478579011E-2},{"$f":"AB23^2+AB24^2","v":4.4413356039806624E-2},5.1261067666635206E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gp",{"$f":"AA22*$AD$16","v":0.21990454024785028},0.21059467790106917,0.22613641427395811,"S","Rs",{"$f":"AA23/AF22","v":4.5383358400294771},{"$f":"AB23/AG22","v":4.7416970181744027},4.4114651638663727,"Ω"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bp",{"$f":"-AA22*$AF$16+$AA$18","v":-9.8426604214365138E-3},{"$f":"-AB22*$AF$16+$AA$18","v":-7.9522122426121944E-3},{"$f":"-AC22*$AF$16+$AA$18","v":-1.1108096414417817E-2},"S","Xs",{"$f":"-AA24/AF22","v":0.20313040604572802},{"$f":"-AB24/AG22","v":0.17905001899619605},0.21669654808317332,"Ω"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zs",{"$f":"SQRT(AF23^2+AF24^2)","v":4.5428795007964231},{"$f":"SQRT(AG23^2+AG24^2)","v":4.7450763451673312},4.4167841565960329,"Ω"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice Z"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r",{"$f":"Z29+AF23","v":4.6544019080122858},{"$f":"Z30","v":6.901827610900399E-2},{"$f":"Z30","v":6.901827610900399E-2},{"$f":"-AA31","v":-2.572590769435072},-0.72103946981145117,-0.72103946981145117]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ph+ n",{"$f":"(V13+2*T13)/3","v":0.11606606798280839},{"$f":"Z30","v":6.901827610900399E-2},{"$f":"Z29+AG23","v":4.8577630861572114},{"$f":"Z30","v":6.901827610900399E-2},-0.72103946981145117,-2.54851038238554,-0.72103946981145117]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n",{"$f":"(V13-T13)/3","v":6.901827610900399E-2},{"$f":"Z30","v":6.901827610900399E-2},{"$f":"Z30","v":6.901827610900399E-2},{"$f":"Z29+AH23","v":4.5275312318491814},-0.72103946981145117,-0.72103946981145117,-2.5861569114725174]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i",{"$f":"Z32+AF24","v":2.572590769435072},{"$f":"Z33","v":0.72103946981145117},{"$f":"Z33","v":0.72103946981145117},{"$f":"AA28","v":4.6544019080122858},6.901827610900399E-2,6.901827610900399E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ph+ n",{"$f":"(W13+2*U13)/3","v":2.3694603633893441},{"$f":"Z33","v":0.72103946981145117},{"$f":"Z32+AG24","v":2.54851038238554},{"$f":"Z33","v":0.72103946981145117},6.901827610900399E-2,4.8577630861572114,6.901827610900399E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n",{"$f":"(W13-U13)/3","v":0.72103946981145117},{"$f":"Z33","v":0.72103946981145117},{"$f":"Z33","v":0.72103946981145117},{"$f":"Z32+AH24","v":2.5861569114725174},6.901827610900399E-2,6.901827610900399E-2,4.5275312318491814]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice Y",null,null,null,null,null,null,"Matrice Vs",null,"Matrice Is"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MINVERSE(AA28:AF33)","v":0.16585153074786449},-2.0725297130352951E-2,-2.2275031896001749E-2,8.4740506838443502E-2,9.1068202180515142E-3,8.9580462385337074E-3,null,{"$f":"$AB$15","v":16051.903875967428},null,{"$f":"MMULT(AA36:AF41,AH36:AH41)","v":3005.2832431972747}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2.0725297130352954E-2,0.16245453754284564,-2.13206097536606E-2,9.1068202180515177E-3,7.8729013997043698E-2,9.0538649288789911E-3,null,{"$f":"-$AB$15/2","v":-8025.9519379837138},null,-2433.9936874663154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2.2275031896001749E-2,-2.1320609753660597E-2,0.16798120295151972,8.9580462385337092E-3,9.0538649288789876E-3,8.8734544067869001E-2,"⨯",{"$f":"AH37","v":-8025.9519379837138},"=",-426.97801331361666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-8.474050683844353E-2,-9.1068202180515125E-3,-8.9580462385337126E-3,0.16585153074786449,-2.0725297130352954E-2,-2.2275031896001749E-2,null,0,null,-1236.8021357378523]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-9.106820218051509E-3,-7.8729013997043712E-2,-9.0538649288789876E-3,-2.0725297130352951E-2,0.16245453754284564,-2.1320609753660593E-2,null,{"$f":"-SQRT(3)/2*AB15","v":-13901.356535693687},null,-1996.3644804869375]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-8.9580462385337074E-3,-9.0538649288789859E-3,-8.8734544067869001E-2,-2.2275031896001753E-2,-2.1320609753660597E-2,0.16798120295151969,null,{"$f":"-AH40","v":13901.356535693687},null,3272.6033648301991]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","N (I0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I charge calculé",{"$f":"SQRT(AJ36^2+AJ39^2)","v":3249.8318256192956},{"$f":"SQRT(AJ37^2+AJ40^2)","v":3147.9829112585335},{"$f":"SQRT(AJ38^2+AJ41^2)","v":3300.3398321008071},{"$f":"SQRT(AA44^2+AB44^2+AC44^2-AA44*AB44-AA44*AC44-AB44*AC44)/3","v":44.806306230104276},"A"]

{"sheet":"Ex 6-7","index":3,"n_rows":44,"n_cols":48,"rows_kept":44,"cut":false,"hidden":false,"merged":[[20,30,21,30],[37,32,38,32],[37,34,38,34],[4,1,5,1],[6,19,6,20],[6,21,6,22],[7,1,9,1],[7,9,9,10],[20,25,21,25]]}
[null,"Complément au cours \"Caractéristiques électriques des postes de distribution HT/MT\", module 2"]
[null,"Calcul de l'écart de tension max entre phases MT (3E Ing.,  J.P. Laflamme, ing. 2015-03-09)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impédance source MT"]
[null,null,null,"R1",null,"X1",null,null,null,null,null,null,null,null,null,null,null,null,"Z","R1","X1","R0","X0",null,null,null,null,null,null,null,null,null,null,null,null,null,"Validation d'erreur"]
[null,null,"Impédance source HT :",3.2000000000000002E-3,null,1.12E-2,"p.u. (100 MVA)",null,null,null,null,"Tension source HT :",315,"kV",null,null,null,null,"HT",{"$f":"D4*S5","v":2.3377309201317885E-2},{"$f":"F4*S5","v":8.1820582204612594E-2},null,null,"Ω",null,"Validation d'erreur",{"$f":"IF(ISERR(AB4),TRUE,OR(AB4,AC4,Erreur2))","v":false},{"$f":"OR(AK4:AV19)","v":false},{"$f":"OR(ISERR(T13),ISERR(V13),ISERR(AB4))","v":false},false,null,null,null,null,null,null,{"$f":"D4<0","v":false},null,{"$f":"F4<0","v":false},null,null,null,null,null,null,{"$f":"M4<=0","v":false}]
[null,"Tension nominale  des transfos",null,"HT",null,"MT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M4^2/100*(F6/U6)^2","v":7.3054091254118383}]
[null,null,null,310,null,26.4,"kV",null,null,null,null,"Prise de régulation :",9.4,null,null,null,null,null,null,{"$f":"-(M6-9)/8*0.15","v":-7.5000000000000067E-3},{"$f":"(1+T6)*D6","v":307.67499999999995},{"$f":"(1-0.7717*T6+1.4798*T6^2)*D8","v":24.040316631125002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(D6<0.8*M4,D6>1.2*M4)","v":false},null,{"$f":"OR(F6<0.8*D13,F6>1.3*D13)","v":false},null,null,null,null,null,null,{"$f":"OR(M6<1,M6>17)","v":false}]
[null,null,null,"Z",null,"X/R",null,"Puissance",null,null,null,null,"Z",null,"X/R",null,null,null,"Transfos","Puissance",null,"MALT",null,null,null,null,"G1","B1",null,"G0","B0"]
[null,"Impédance transfos de puissance YNd",1,23.9,"%",55,null,66,"MVA","Impédance transfos de MALT",null,1,7.3,"Ω",15,null,null,null,{"$f":"IF(ISBLANK(D8),\"\",$V$6/100*$F$6^2/H8)","v":2.5386574362468002},{"$f":"IF(ISBLANK(D8),\"\",S8*1/SQRT(1+F8^2))","v":4.6149780499181815E-2},{"$f":"IF(ISBLANK(D8),\"\",S8*F8/SQRT(1+F8^2))","v":2.538237927455},{"$f":"IF(ISBLANK(M8),\"\",M8*1/SQRT(1+O8^2))","v":0.48558877682354967},{"$f":"IF(ISBLANK(M8),\"\",M8*O8/SQRT(1+O8^2))","v":7.2838316523532454},"Ω",null,{"$f":"T8^2+U8^2","v":6.4447815786111757},{"$f":"IF(ISBLANK($D8),0,T8/Z8)","v":7.1607982266370159E-3},{"$f":"IF(ISBLANK($D8),0,-U8/Z8)","v":-0.39384390246503592},{"$f":"V8^2+W8^2","v":53.29},{"$f":"IF(ISBLANK($M8),0,V8/AC8)","v":9.1121932224347852E-3},{"$f":"IF(ISBLANK($M8),0,-W8/AC8)","v":-0.13668289833652178},"S",null,null,null,null,{"$f":"D8<0","v":false},null,{"$f":"F8<0","v":false},null,{"$f":"H8<0","v":false},null,null,null,null,{"$f":"M8<0","v":false},null,{"$f":"O8<0","v":false}]
[null,null,2,null,"%",null,null,null,"MVA",null,null,2,null,"Ω",null,null,null,null,{"$f":"IF(ISBLANK(D9),\"\",$V$6/100*$F$6^2/H9)","v":""},{"$f":"IF(ISBLANK(D9),\"\",S9*1/SQRT(1+F9^2))","v":""},{"$f":"IF(ISBLANK(D9),\"\",S9*F9/SQRT(1+F9^2))","v":""},{"$f":"IF(ISBLANK(M9),\"\",M9*1/SQRT(1+O9^2))","v":""},{"$f":"IF(ISBLANK(M9),\"\",M9*O9/SQRT(1+O9^2))","v":""},"Ω",null,{"$f":"T9^2+U9^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D9),0,T9/Z9)","v":0},{"$f":"IF(ISBLANK($D9),0,-U9/Z9)","v":0},{"$f":"V9^2+W9^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M9),0,V9/AC9)","v":0},{"$f":"IF(ISBLANK($M9),0,-W9/AC9)","v":0},"S",null,null,null,null,{"$f":"D9<0","v":false},null,{"$f":"F9<0","v":false},null,{"$f":"H9<0","v":false},null,null,null,null,{"$f":"M9<0","v":false},null,{"$f":"O9<0","v":false}]
[null,null,3,null,"%",null,null,null,"MVA",null,null,3,null,"Ω",null,null,null,null,"",{"$f":"IF(ISBLANK(D10),\"\",S10*1/SQRT(1+F10^2))","v":""},{"$f":"IF(ISBLANK(D10),\"\",S10*F10/SQRT(1+F10^2))","v":""},{"$f":"IF(ISBLANK(M10),\"\",M10*1/SQRT(1+O10^2))","v":""},{"$f":"IF(ISBLANK(M10),\"\",M10*O10/SQRT(1+O10^2))","v":""},"Ω",null,{"$f":"T10^2+U10^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D10),0,T10/Z10)","v":0},{"$f":"IF(ISBLANK($D10),0,-U10/Z10)","v":0},{"$f":"V10^2+W10^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M10),0,V10/AC10)","v":0},{"$f":"IF(ISBLANK($M10),0,-W10/AC10)","v":0},"S",null,null,null,null,{"$f":"D10<0","v":false},null,{"$f":"F10<0","v":false},null,{"$f":"H10<0","v":false},null,null,null,null,{"$f":"M10<0","v":false},null,{"$f":"O10<0","v":false}]
[null,null,4,null,"%",null,null,null,"MVA",null,null,4,null,"Ω",null,null,null,null,"",{"$f":"IF(ISBLANK(D11),\"\",S11*1/SQRT(1+F11^2))","v":""},{"$f":"IF(ISBLANK(D11),\"\",S11*F11/SQRT(1+F11^2))","v":""},{"$f":"IF(ISBLANK(M11),\"\",M11*1/SQRT(1+O11^2))","v":""},{"$f":"IF(ISBLANK(M11),\"\",M11*O11/SQRT(1+O11^2))","v":""},"Ω",null,{"$f":"T11^2+U11^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($D11),0,T11/Z11)","v":0},{"$f":"IF(ISBLANK($D11),0,-U11/Z11)","v":0},{"$f":"V11^2+W11^2","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($M11),0,V11/AC11)","v":0},{"$f":"IF(ISBLANK($M11),0,-W11/AC11)","v":0},"S",null,null,null,null,{"$f":"D11<0","v":false},null,{"$f":"F11<0","v":false},null,{"$f":"H11<0","v":false},null,null,null,null,{"$f":"M11<0","v":false},null,{"$f":"O11<0","v":false}]
[]
[null,null,"Tension nom. MT ph-ph :",24.94,"kV",null,null,null,null,null,null,null,null,null,null,null,null,null,"Z Total :",{"$f":"AA13/Z13+T4","v":6.95270897004997E-2},{"$f":"-AB13/Z13+U4","v":2.6200585096596121},{"$f":"AD13/AC13","v":0.48558877682354967},{"$f":"-AE13/AC13","v":7.2838316523532454},"Ω",null,{"$f":"AA13^2+AB13^2","v":0.15516429654013134},{"$f":"SUM(AA8:AA11)","v":7.1607982266370159E-3},{"$f":"SUM(AB8:AB11)","v":-0.39384390246503592},{"$f":"AD13^2+AE13^2","v":1.8765246762994934E-2},{"$f":"SUM(AD8:AD11)","v":9.1121932224347852E-3},{"$f":"SUM(AE8:AE11)","v":-0.13668289833652178},"S",null,null,null,null,{"$f":"D13<=0","v":false}]
[null,null,null,null,null,"FP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal","Source","Charge"]
[null,null,"Charge totale :",{"$f":"66*1.42*0.72","v":67.478399999999993},"MVA",98,"%",null,null,null,null,"Tension de la charge :",123,"V en base 120 V",null,null,null,null,null,null,null,null,null,null,null,"V ph-n",{"$f":"D13/SQRT(3)*1000","v":14399.115713589268},{"$f":"AA15*M4*F6/U6/D13","v":15604.923502335025},{"$f":"AA15*M15/120","v":14759.093606429},"V",null,null,null,null,null,null,{"$f":"D15<0","v":false},null,{"$f":"IF(D15=0,TRUE,OR(F15<75,F15>100))","v":false},null,null,null,null,{"$f":"OR(M15<90,M15>150)","v":false}]
[null,null,null,null,null,"Vnom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P:",{"$f":"D15*1000000","v":67478400},"W","FP",{"$f":"F15/100","v":0.98},"FR",{"$f":"SQRT(1-AD16^2)","v":0.1989974874213242}]
[null,null,"Condensateurs :",12,"Mvar",28.4,"kV",null,null,null,null,"Inductance-série des condensateurs:",1.2,"Ω",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idéséq x","Idéséq y",null,null,null,null,null,null,{"$f":"D17<0","v":false},null,{"$f":"IF(D17=0,TRUE,OR(F17<0.75*D13,F17>1.2*D13))","v":false},null,null,null,null,null,null,{"$f":"M17<0","v":false}]
[null,null,null,null,null,"Angle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y condens + is",{"$f":"IF(OR(ISBLANK(D17),D17=0),0,-1/(M17-F17^2/D17))","v":1.5148454857604528E-2},"Ω",{"$f":"D19*COS(F19/180*PI())*3","v":79.765710386463326},{"$f":"D19*SIN(F19/180*PI())*3","v":12.633647396649046},"A"]
[null,null,"Déséquilibre (I0) :",26.92,"A",9,"°",null,"A","B","C",null,"Moy","ΔV",null,null,null,null,null,null,null,null,null,null,null,"Fact correction final",{"$f":"I20/AA44*AA20","v":1.0312123870777385},{"$f":"J20/AB44*AB20","v":1.0069919880392859},{"$f":"K20/AC44*AC20","v":1.0185270150826318},null,"Écart final initial",{"$f":"SQRT((AA44-I20)^2+(AB44-J20)^2+(AC44-K20)^2)/M20","v":5.8532991429311408E-6},null,null,null,null,{"$f":"D19<0","v":false},null,{"$f":"ISERR(Angle)","v":false}]
[null,null,null,null,null,null,null,"Courant :",{"$f":"IF(Erreur,\"\",AC18*2/3+M20)","v":1577.1731660164482},{"$f":"IF(Erreur,\"\",-AC18/3-SQRT(3)/3*AD18+M20)","v":1490.1134159046828},{"$f":"IF(Erreur,\"\",-AC18/3+SQRT(3)/3*AD18+M20)","v":1504.7014953552871},null,{"$f":"AA16/3/AC15","v":1523.9960257588061},null,"A",null,null,null,null,null,null,null,null,null,null,"Fact correction initial",1.0312135709749319,1.0069953830527565,1.0185221784151586]
[null,null,null,null,null,null,null,"Tension :",{"$f":"IF(Erreur,\"\",AA44*AF25/$AA$15*120)","v":121.4721149951926},{"$f":"IF(Erreur,\"\",AB44*AG25/$AA$15*120)","v":124.47683020750084},{"$f":"IF(Erreur,\"\",AC44*AH25/$AA$15*120)","v":123.04658762348797},null,{"$f":"(I21+J21+K21)/3","v":122.99851094206046},{"$f":"IF(Erreur,\"\",MAX(I21:K21)-MIN(I21:K21))","v":3.0047152123082412},"V (base 120 V)",null,null,null,null,null,null,null,null,null,null,"Admittance de charge","A","B","C",null,"Impédance de charge","A","B","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I20/$AC$15*AA20","v":0.11019662968091799},{"$f":"J20/$AC$15*AB20","v":0.10166866408295966},{"$f":"K20/$AC$15*AC20","v":0.10383915745654135},"S",null,{"$f":"AA23^2+AA24^2","v":1.1708396415412737E-2},{"$f":"AB23^2+AB24^2","v":9.9530316593669527E-3},1.0385999100349321E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gp",{"$f":"AA22*$AD$16","v":0.10799269708729962},9.9635290801300458E-2,0.10176237430741052,"S","Rs",{"$f":"AA23/AF22","v":9.2235258574897454},{"$f":"AB23/AG22","v":10.010546958075045},9.7980341923954004,"Ω"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bp",{"$f":"-AA22*$AF$16+$AA$18","v":-6.7803975711962713E-3},{"$f":"-AB22*$AF$16+$AA$18","v":-5.0833538443870729E-3},{"$f":"-AC22*$AF$16+$AA$18","v":-5.5152765721944615E-3},"S","Xs",{"$f":"-AA24/AF22","v":0.57910556925375967},{"$f":"-AB24/AG22","v":0.51073421831257315},0.53102994896359679,"Ω"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zs",{"$f":"SQRT(AF23^2+AF24^2)","v":9.2416877519272784},{"$f":"SQRT(AG23^2+AG24^2)","v":10.023567221382859},9.81241391514064,"Ω"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice Z"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r",{"$f":"Z29+AF23","v":9.431740176231262},{"$f":"Z30","v":0.13868722904101666},{"$f":"Z30","v":0.13868722904101666},{"$f":"-AA31","v":-4.7537551264779161},-1.5545910475645446,-1.5545910475645446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(V13+2*T13)/3","v":0.20821431874151633},{"$f":"Z30","v":0.13868722904101666},{"$f":"Z29+AG23","v":10.218761276816561},{"$f":"Z30","v":0.13868722904101666},-1.5545910475645446,-4.6853837755367298,-1.5545910475645446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(V13-T13)/3","v":0.13868722904101666},{"$f":"Z30","v":0.13868722904101666},{"$f":"Z30","v":0.13868722904101666},{"$f":"Z29+AH23","v":10.006248511136917},-1.5545910475645446,-1.5545910475645446,-4.705679506187753]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i",{"$f":"Z32+AF24","v":4.7537551264779161},{"$f":"Z33","v":1.5545910475645446},{"$f":"Z33","v":1.5545910475645446},{"$f":"AA28","v":9.431740176231262},0.13868722904101666,0.13868722904101666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W13+2*U13)/3","v":4.1746495572241562},{"$f":"Z33","v":1.5545910475645446},{"$f":"Z32+AG24","v":4.6853837755367298},{"$f":"Z33","v":1.5545910475645446},0.13868722904101666,10.218761276816561,0.13868722904101666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W13-U13)/3","v":1.5545910475645446},{"$f":"Z33","v":1.5545910475645446},{"$f":"Z33","v":1.5545910475645446},{"$f":"Z32+AH24","v":4.705679506187753},0.13868722904101666,0.13868722904101666,10.006248511136917]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matrice Y",null,null,null,null,null,null,"Matrice Vs",null,"Matrice Is"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MINVERSE(AA28:AF33)","v":8.4738081455833225E-2},-1.0505833487177107E-2,-1.0752153675180686E-2,3.9033751184127663E-2,5.8293324841237433E-3,5.8546079592764182E-3,null,{"$f":"$AB$15","v":15604.923502335025},null,{"$f":"MMULT(AA36:AF41,AH36:AH41)","v":1488.5374899413325}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.0505833487177107E-2,8.0864543443585832E-2,-9.8414755225931863E-3,5.8293324841237389E-3,3.3824384967903125E-2,5.7532777324526205E-3,null,{"$f":"-$AB$15/2","v":-7802.4617511675124},null,-1097.4577454399198]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.0752153675180684E-2,-9.8414755225931846E-3,8.1889377072490957E-2,5.8546079592764148E-3,5.7532777324526231E-3,3.5150099058973441E-2,"⨯",{"$f":"AH37","v":-7802.4617511675124},"=",-332.66123989415274]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.9033751184127656E-2,-5.8293324841237389E-3,-5.8546079592764165E-3,8.4738081455833211E-2,-1.0505833487177107E-2,-1.0752153675180684E-2,null,0,null,-521.28403793250357]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.8293324841237441E-3,-3.3824384967903125E-2,-5.7532777324526231E-3,-1.0505833487177109E-2,8.0864543443585832E-2,-9.8414755225931846E-3,null,{"$f":"-SQRT(3)/2*AB15","v":-13514.260177134965},null,-1007.9878280053748]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.8546079592764174E-3,-5.7532777324526222E-3,-3.5150099058973441E-2,-1.0752153675180686E-2,-9.8414755225931863E-3,8.1889377072490957E-2,null,{"$f":"-AH40","v":13514.260177134965},null,1467.4609318084076]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I charge calculé",{"$f":"SQRT(AJ36^2+AJ39^2)","v":1577.1749767112267},{"$f":"SQRT(AJ37^2+AJ40^2)","v":1490.1184397332531},{"$f":"SQRT(AJ38^2+AJ41^2)","v":1504.6943499966744},{"$f":"SQRT(AA44^2+AB44^2+AC44^2-AA44*AB44-AA44*AC44-AB44*AC44)/3","v":26.920396067271184},"A"]