{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Chute de tension","Formule","Dimmensionnement intallation"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Chute de tension","index":0,"n_rows":25,"n_cols":51,"rows_kept":25,"cut":false,"hidden":false,"merged":[[16,2,17,2]]}
[]
[]
[]
[]
[]
[null,null,"Calculateur","Type","Puissance","Nombre d'usager",null,"P Transfo = ",160,"kVA"]
[null,null,1,"Mono sur Phase1",70,1,null,"V = ",230.6,"Volts"]
[null,null,2,"Mono sur Phase2",6,1,null,"Cos Phi = ",0.8]
[null,null,3,"Triphasé",12,1]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,"Puissance retenue par phase","P1","P2","P3"]
[null,null,null,{"$f":"Formule!P15","v":74},{"$f":"Formule!Q15","v":10},{"$f":"Formule!R15","v":4}]
[]
[]
[]
[]
["Tronçon principal","Longueur","Section phase","Section neutre","Type","P1","P2","P3","Zph","Zn","xN","xP1","xP2","xP3","yN","yP1","yP2","yP3","V1","V2","V3","U12","U13","U23","Intensité P1","Intensité P2","Intensité P3","dU/U P1-N","dU/U P2-N","dU/U P3-N","dU/U U12","dU/U U13","dU/U U23","Pcc (kW)","I Max"]
["Tension sortie transfo",null,null,null,null,null,null,null,null,null,0,{"$f":"$I$7*COS(0)","v":230.6},{"$f":"$I$7*COS(2*PI()/3)","v":-115.29999999999994},{"$f":"$I$7*COS(4*PI()/3)","v":-115.3000000000001},0,{"$f":"$I$7*SIN(0)","v":0},{"$f":"$I$7*SIN(2*PI()/3)","v":199.70545811269156},{"$f":"$I$7*SIN(4*PI()/3)","v":-199.70545811269147},{"$f":"SQRT(($L24-$K24)^2+($P24-$O24)^2)","v":230.6},{"$f":"SQRT(($M24-$K24)^2+($Q24-$O24)^2)","v":230.59999999999997},{"$f":"SQRT(($N24-$K24)^2+($R24-$O24)^2)","v":230.59999999999997},{"$f":"SQRT(($L24-$M24)^2+($P24-$Q24)^2)","v":399.41091622538306},{"$f":"SQRT(($N24-$L24)^2+($R24-$P24)^2)","v":399.41091622538312},{"$f":"SQRT(($N24-$M24)^2+($R24-$Q24)^2)","v":399.41091622538306},null,null,null,{"$f":"AB25","v":-0.19276247559091039},{"$f":"AC25","v":3.7912950532820865E-2},{"$f":"AD25","v":5.8348327391930681E-2},-4.9604595320324789E-2,-4.5994792496031986E-2,-8.3074820449122698E-3]
["Tronçon 1",150,150,70,"AL",74,10,4,{"$f":"IF(OR(B25=\"\",C25=\"\",D25=\"\",E25=\"\"),0,(VLOOKUP($E25,Formule!$B$3:$C$5,2,FALSE)/1000/$C25*$B25)+VLOOKUP($I$6,Formule!$B$10:$C$17,2)+0)","v":5.0500000000000003E-2},{"$f":"IF(OR(B25=\"\",C25=\"\",D25=\"\",E25=\"\"),0,(VLOOKUP($E25,Formule!$B$3:$C$5,2,FALSE)/1000/$D25*$B25)+0)","v":6.6642857142857156E-2},{"$f":"$K24+$Y25*$J25+$J25*$Z25*(M24-K24)/$T24+$J25*$AA25*($N24-$K24)/$U24","v":24.203552843513819},{"$f":"$L24-($L24-$K24)*$Y25*$I25/$S24","v":210.34306157849088},{"$f":"$M24-($M24-$K24)*$Z25*$I25/$T24","v":-113.93128794449257},{"$f":"$N24-($N24-$K24)*$AA25*$I25/$U24","v":-114.75251517779715},{"$f":"$O24+$J25*$Z25*($Q24-$O24)/$T24+$J25*$AA25*($R24-$O24)/$U24","v":1.8770947723273483},{"$f":"$P24-($P24-$O24)*$Y25*$I25/$S24","v":0},{"$f":"$Q24-($Q24-$O24)*$Z25*$I25/$T24","v":197.33477929162075},{"$f":"$R24-($R24-$P24)*$AA25*$I25/$U24","v":-198.75718658426317},{"$f":"SQRT(($L25-$K25)^2+($P25-$O25)^2)","v":186.14897312873606},{"$f":"SQRT(($M25-$K25)^2+($Q25-$O25)^2)","v":239.34272639286849},{"$f":"SQRT(($N25-$K25)^2+($R25-$O25)^2)","v":244.05512429657921},{"$f":"SQRT(($L25-$M25)^2+($P25-$Q25)^2)","v":379.59829935950279},{"$f":"SQRT(($N25-$L25)^2+($R25-$P25)^2)","v":381.04009401294655},{"$f":"SQRT(($N25-$M25)^2+($R25-$Q25)^2)","v":396.09281721029873},{"$f":"IF($I25<>0,(($F25*1000)/($I$7*$I$8)),0)","v":401.12749349522977},{"$f":"IF($I25<>0,(($G25*1000)/($I$7*$I$8)),0)","v":54.206418039895915},{"$f":"IF($I25<>0,(($H25*1000)/($I$8*$I$7)),0)","v":21.682567215958368},{"$f":"(S25-$I$7)/$I$7","v":-0.19276247559091039},{"$f":"(T25-$I$7)/$I$7","v":3.7912950532820865E-2},{"$f":"(U25-$I$7)/$I$7","v":5.8348327391930681E-2},{"$f":"(V25-($I$7*SQRT(3)))/($I$7*SQRT(3))","v":-4.9604595320324789E-2},{"$f":"(W25-($I$7*SQRT(3)))/($I$7*SQRT(3))","v":-4.5994792496031986E-2},{"$f":"(X25-($I$7*SQRT(3)))/($I$7*SQRT(3))","v":-8.3074820449122698E-3},{"$f":"(MAX($V25:$X25)*(MAX($V25:$X25)/I25)*$I$8*SQRT(3))/1000","v":4304.8018938241512},{"$f":"IF(C25=\"\",\"\",IMax(C25))","v":335},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AI25<Y25,AI25<Z25,AI25<AA25),1,\"\")","v":1}]

{"sheet":"Formule","index":1,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[13,14,14,14],[139,0,139,12],[140,0,140,12],[8,1,8,3],[136,0,136,12],[138,0,138,12],[135,0,135,12],[19,1,19,3],[109,0,109,12],[23,5,23,7]]}
[]
[null,"Conducteurs",null,null,null,null,null,null,null,null,"Coefficients de pondération"]
[null,"AL",31.1,"Ohm/km/mm²",null,null,null,null,null,{"$f":"IF($R$16<=K3,1,\"\")","v":1},4,1,0.62,null,{"$f":"'Chute de tension'!C6","v":"Calculateur"},{"$f":"'Chute de tension'!D6","v":"Type"},{"$f":"'Chute de tension'!E6","v":"Puissance"},{"$f":"'Chute de tension'!F6","v":"Nombre d'usager"}]
[null,"AM",34,"Ohm/km/mm²",null,null,null,null,null,{"$f":"IF($R$16<=K4,IF($R$16>K3,1,\"\"),\"\")","v":""},9,0.78,0.64,null,{"$f":"'Chute de tension'!C7","v":1},{"$f":"'Chute de tension'!D7","v":"Mono sur Phase1"},{"$f":"'Chute de tension'!E7","v":70},{"$f":"'Chute de tension'!F7","v":1},{"$f":"R4*Q4","v":70}]
[null,"CU",18.399999999999999,"Ohm/km/mm²",null,null,null,null,null,"",14,0.63,0.68,null,{"$f":"'Chute de tension'!C8","v":2},{"$f":"'Chute de tension'!D8","v":"Mono sur Phase2"},{"$f":"'Chute de tension'!E8","v":6},{"$f":"'Chute de tension'!F8","v":1},{"$f":"R5*Q5","v":6}]
[null,null,null,null,null,null,null,null,null,"",19,0.53,0.7,null,{"$f":"'Chute de tension'!C9","v":3},{"$f":"'Chute de tension'!D9","v":"Triphasé"},{"$f":"'Chute de tension'!E9","v":12},{"$f":"'Chute de tension'!F9","v":1},12]
[null,null,null,null,null,null,null,null,null,"",24,0.49,0.72,null,{"$f":"'Chute de tension'!C10","v":4},{"$f":"'Chute de tension'!D10","v":0},{"$f":"'Chute de tension'!E10","v":0},{"$f":"'Chute de tension'!F10","v":0},0]
[null,null,null,null,null,null,null,null,null,"",29,0.46,0.74,null,{"$f":"'Chute de tension'!C11","v":5},{"$f":"'Chute de tension'!D11","v":0},{"$f":"'Chute de tension'!E11","v":0},{"$f":"'Chute de tension'!F11","v":0},0]
[null,"Poste HTA/BT",null,null,null,null,null,null,null,"",34,0.44,0.76,null,{"$f":"'Chute de tension'!C12","v":6},{"$f":"'Chute de tension'!D12","v":0},{"$f":"'Chute de tension'!E12","v":0},{"$f":"'Chute de tension'!F12","v":0},0]
[null,0,0,"Ohms",null,null,null,null,null,"",39,0.42,0.78,null,{"$f":"'Chute de tension'!C13","v":7},{"$f":"'Chute de tension'!D13","v":0},{"$f":"'Chute de tension'!E13","v":0},{"$f":"'Chute de tension'!F13","v":0},0]
[null,50,8.5699999999999998E-2,"Ohms","Valeur par défaut (hypothèse conservatrice)",null,null,null,null,"",49,0.41,0.8,null,{"$f":"'Chute de tension'!C14","v":8},{"$f":"'Chute de tension'!D14","v":0},{"$f":"'Chute de tension'!E14","v":0},{"$f":"'Chute de tension'!F14","v":0},0]
[null,100,3.4099999999999998E-2,"Ohms","source EDF HN 52-S-54",null,null,null,null,"",999999999999999,0.38,0.82,null,{"$f":"'Chute de tension'!C15","v":9},{"$f":"'Chute de tension'!D15","v":0},{"$f":"'Chute de tension'!E15","v":0},{"$f":"'Chute de tension'!F15","v":0},0]
[null,160,1.9400000000000001E-2,"Ohms",null,null,null,null,null,null,null,"C14-100","Extreme",null,{"$f":"'Chute de tension'!C16","v":10},{"$f":"'Chute de tension'!D16","v":0},{"$f":"'Chute de tension'!E16","v":0},{"$f":"'Chute de tension'!F16","v":0},0]
[null,250,1.0751999999999999E-2,"Ohms",null,null,null,null,null,null,null,null,null,null,{"$f":"'Chute de tension'!C17","v":"Puissance retenue par phase"},{"$f":"'Chute de tension'!D17","v":"P1"},{"$f":"'Chute de tension'!E17","v":"P2"},{"$f":"'Chute de tension'!F17","v":"P3"}]
[null,400,6.0000000000000001E-3,"Ohms",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((P4:P13=\"Mono sur Phase1\")*(Q4:Q13*R4:R13))+(SUMPRODUCT((P4:P13=\"Triphasé\")*(Q4:Q13*R4:R13))/3)*VLOOKUP(1,$J$3:$L$12,3,FALSE)","v":74},{"$f":"SUMPRODUCT((P4:P13=\"Mono sur Phase2\")*(Q4:Q13*R4:R13))+(SUMPRODUCT((P4:P13=\"Triphasé\")*(Q4:Q13*R4:R13))/3)*VLOOKUP(1,$J$3:$L$12,3,FALSE)","v":10},{"$f":"SUMPRODUCT((P4:P13=\"Mono sur Phase3\")*(Q4:Q13*R4:R13))+(SUMPRODUCT((P4:P13=\"Triphasé\")*(Q4:Q13*R4:R13))/3)*VLOOKUP(1,$J$3:$L$12,3,FALSE)","v":4}]
[null,630,3.386243386243386E-3,"Ohms",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R4:R13)","v":3}]
[null,1000,2.0800000000000003E-3,"Ohms"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge monoP1","nb","Charge monoP2","nb","Charge monoP3","nb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P19=0,0,(SUMIF($P$4:$P$13,\"Mono sur Phase1\",$S$4:$S$13)+(SUMIF($P$4:$P$13,\"Triphasé\",$S$4:$S$13)/3))/P19)","v":37},{"$f":"SUMIF($P$4:$P$13,\"Mono sur Phase1\",$R$4:$R$13)+SUMIF($P$4:$P$13,\"Triphasé\",$R$4:$R$13)","v":2},{"$f":"IF(R19=0,0,(SUMIF($P$4:$P$13,\"Mono sur Phase2\",$S$4:$S$13)+(SUMIF($P$4:$P$13,\"Triphasé\",$S$4:$S$13)/3))/R19)","v":5},{"$f":"SUMIF($P$4:$P$13,\"Mono sur Phase2\",$R$4:$R$13)+SUMIF($P$4:$P$13,\"Triphasé\",$R$4:$R$13)","v":2},{"$f":"IF(T19=0,0,(SUMIF($P$4:$P$13,\"Mono sur Phase3\",$S$4:$S$13)+(SUMIF($P$4:$P$13,\"Triphasé\",$S$4:$S$13)/3))/T19)","v":4},{"$f":"SUMIF($P$4:$P$13,\"Mono sur Phase3\",$R$4:$R$13)+SUMIF($P$4:$P$13,\"Triphasé\",$R$4:$R$13)","v":1}]
[null,"Dérivations"]
[null,"D1"]
[null,"D2"]
[null,"D3"]
[null,"D4"]
[null,"D5"]
[null,"D6"]
[null,"D7"]
[null,"D8"]
[null,"D9"]
[null,"D10"]
[null,"D11"]
[null,"D12"]
[null,"D13"]
[null,"D14"]
[null,"D15",null,null,null,"Câble"]
[null,"D16",null,null,null,"section nominale","intensité de courant maxi admissible (Ampère)"]
[null,"D17",null,null,null,0.75,12]
[null,"D18",null,null,null,1,15]
[null,"D19",null,null,null,1.5,18]
[null,"D20",null,null,null,2.5,26]
[null,null,null,null,null,4,34]
[null,null,null,null,null,6,44]
[null,null,null,null,null,10,61]
[null,null,null,null,null,16,82]
[null,null,null,null,null,25,108]
[null,null,null,null,null,35,135]
[null,null,null,null,null,50,168]
[null,null,null,null,null,70,207]
[null,null,null,null,null,95,250]
[null,null,null,null,null,120,292]
[null,null,null,null,null,150,335]
[null,null,null,null,null,185,382]
[null,null,null,null,null,240,453]
[null,null,null,null,null,300,523]

{"sheet":"Dimmensionnement intallation","index":2,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Outil de dimmensionnement d'installation électrique : permet de définir la puissance à souscrire en kVA"]
[]
[]
[null,"Appareil","Puissance absorbée en kW","Cos phi","Q (kVAR)"]
[null,1,18.5,0.8,{"$f":"IF(D6=\"\",\"\",C6*TANGENTE(ACOSINUS(D6)))","v":13.875}]
[null,2,null,null,{"$f":"IF(D7=\"\",\"\",C7*TANGENTE(ACOSINUS(D7)))","v":""}]
[null,3,null,null,{"$f":"IF(D8=\"\",\"\",C8*TANGENTE(ACOSINUS(D8)))","v":""}]
[null,4,null,null,{"$f":"IF(D9=\"\",\"\",C9*TANGENTE(ACOSINUS(D9)))","v":""}]
[null,5,null,null,{"$f":"IF(D10=\"\",\"\",C10*TANGENTE(ACOSINUS(D10)))","v":""}]
[null,6,null,null,{"$f":"IF(D11=\"\",\"\",C11*TANGENTE(ACOSINUS(D11)))","v":""}]
[null,7,null,null,{"$f":"IF(D12=\"\",\"\",C12*TANGENTE(ACOSINUS(D12)))","v":""}]
[null,8,null,null,{"$f":"IF(D13=\"\",\"\",C13*TANGENTE(ACOSINUS(D13)))","v":""}]
[null,9,null,null,{"$f":"IF(D14=\"\",\"\",C14*TANGENTE(ACOSINUS(D14)))","v":""}]
[null,10,null,null,{"$f":"IF(D15=\"\",\"\",C15*TANGENTE(ACOSINUS(D15)))","v":""}]
[null,11,null,null,{"$f":"IF(D16=\"\",\"\",C16*TANGENTE(ACOSINUS(D16)))","v":""}]
[null,12,null,null,{"$f":"IF(D17=\"\",\"\",C17*TANGENTE(ACOSINUS(D17)))","v":""}]
[null,13,null,null,{"$f":"IF(D18=\"\",\"\",C18*TANGENTE(ACOSINUS(D18)))","v":""}]
[null,14,null,null,{"$f":"IF(D19=\"\",\"\",C19*TANGENTE(ACOSINUS(D19)))","v":""}]
[null,15,null,null,{"$f":"IF(D20=\"\",\"\",C20*TANGENTE(ACOSINUS(D20)))","v":""}]
[null,null,null,"Puissance active retenu :  ",{"$f":"SUM(C6:C20)","v":18.5},"kW"]
[null,null,null,"Puissance reactive retenu :  ",{"$f":"SUM(E6:E20)","v":13.875},"kVAR"]
[null,null,null,"Puissance apparente retenu :  ",{"$f":"SQRT((E21*E21)+(E22*E22))","v":23.125},"kVA"]
[null,null,null,"Cos phi intallation : ",{"$f":"E21/E23","v":0.8}]
[]
[null,"Caul puissance aborbée"]
[null,"Intensité (A)","Cos phi","Type"]
[null,47,0.8,"Tri"]
[null,null,"Puissance aborbée : ",{"$f":"IF(D28=\"Tri\",B28*C28*400*SQRT(3),B28*C28*230)/1000","v":26.050044145835912},"kW"]