{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["tablas","ejercicio","datos"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"comments":0,"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":"tablas","index":0,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[28,15,43,15],[9,17,9,20],[8,15,8,20],[2,2,2,13],[1,2,1,13],[11,15,27,15]]}
[]
[null,null,"Tabla A.52-1 bis.   Intensidades admisibles en Amperios. Temperatura ambiente 40ºC en el aire"]
[null,"Metodos de Instalación","Número de conductores cargados y tipo de aislamiento"]
[null,"A1",null,"PVC3","PVC2",null,"XLPE3","XLPE2"]
[null,"A2","PVC3","PVC2",null,"XLPE3","XLPE2",null,null,null,null,null,null,null,null,"Metodos de Instalación","Sección mm2"]
[null,"B1",null,null,null,"PVC3","PVC2",null,"XLPE3",null,"XLPE2"]
[null,"B2",null,null,"PVC3","PVC2",null,"XLPE3","XLPE2"]
[null,"C",null,null,null,null,"PVC3",null,"PVC2","XLPE3",null,"XLPE2"]
[null,"E",null,null,null,null,null,"PVC3",null,"PVC2","XLPE3",null,"XLPE2",null,null,"Tabla A.52-2 bis.   Intensidades admisibles en Amperios. Temperatura ambiente 25ºC en el terreno"]
[null,"F",null,null,null,null,null,null,"PVC3",null,"PVC2","XLPE3",null,"XLPE2",null,null,null,"Número de conductores cargados y tipo de aislamiento"]
[null,"Sección mm2",null,null,null,null,null,null,null,null,null,null,null,null,null,"D","D","PVC2","PVC3","XLPE2","XLPE3"]
[null,"Cu",null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Cu"]
[null,1.5,11,11.5,13,13.5,15,16,16.5,19,20,21,24,"-",null,null,1.5,20.5,17,24.5,21]
[null,2.5,15,16,17.5,18.5,21,22,23,26,26.5,29,33,"-",null,null,2.5,27.5,22.5,32.5,27.5]
[null,4,20,21,23,24,27,30,31,34,36,38,45,"-",null,null,4,36,29,42,35]
[null,6,25,27,30,32,36,37,40,44,46,49,57,"-",null,null,6,44,37,53,44]
[null,10,34,37,40,44,50,52,54,60,65,68,76,"-",null,null,10,59,49,70,58]
[null,16,45,49,54,59,66,70,73,81,87,91,105,"-",null,null,16,76,63,91,75]
[null,25,59,64,70,77,84,88,95,103,110,116,123,140,null,null,25,98,81,116,96]
[null,35,"-",77,86,96,104,110,119,127,137,144,154,174,null,null,35,118,97,140,117]
[null,50,"-",94,103,117,125,133,145,155,167,175,188,210,null,null,50,140,115,166,138]
[null,70,"-","-","-",149,160,171,185,199,214,224,244,269,null,null,70,173,143,204,170]
[null,95,"-","-","-",180,194,207,224,241,259,271,296,327,null,null,95,205,170,241,202]
[null,120,"-","-","-",208,225,240,260,280,301,314,348,380,null,null,120,233,192,275,230]
[null,150,"-","-","-",236,260,278,299,322,343,363,404,438,null,null,150,264,218,311,260]
[null,185,"-","-","-",268,297,317,341,368,391,415,464,500,null,null,185,296,245,348,291]
[null,240,"-","-","-",315,350,374,401,435,468,490,552,590,null,null,240,342,282,402,336]
[null,"Sección mm2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,387,319,455,380]
[null,"Al",null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Al"]
[null,2.5,11.5,12,13.5,14,16,17,18,20,20,22,25,"-",null,null,2.5,20.5,17,24.5,21]
[null,4,15,16,18.5,19,22,24,24,26.5,27.5,29,35,"-",null,null,4,27.5,225,32.5,27.5]
[null,6,20,21,24,25,28,30,31,33,36,38,45,"-",null,null,6,34,28,40,34]
[null,10,27,28,32,34,38,42,42,46,50,53,61,"-",null,null,10,45,38,53,45]
[null,16,36,38,42,46,51,56,57,63,66,70,83,"-",null,null,16,58,49,70,58]
[null,25,46,50,54,61,64,71,72,78,84,88,94,105,null,null,25,76,62,89,74]
[null,35,"-",61,67,75,78,88,89,97,104,109,117,130,null,null,35,91,76,107,90]
[null,50,"-",73,80,90,96,106,108,118,127,133,145,160,null,null,50,107,89,126,107]
[null,70,"-","-","-",116,122,136,139,151,162,170,187,206,null,null,70,133,111,156,132]
[null,95,"-","-","-",140,148,167,169,183,197,207,230,251,null,null,95,157,131,185,157]
[null,120,"-","-","-",162,171,193,196.5,213,228,239,269,293,null,null,120,179,149,211,178]
[null,150,"-","-","-",187,197,223,227,246,264,277,312,338,null,null,150,202,169,239,201]
[null,185,"-","-","-",212,225,236,259,281,301,316,359,388,null,null,185,228,190,267,226]
[null,240,"-","-","-",248,265,300,306,332,355,372,429,461,null,null,240,263,218,309,261]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,297,247,349,295]

{"sheet":"ejercicio","index":1,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Corrientes de cortocircuito aguas abajo del transformador.-"]
[]
[null,"Datos de enterada"]
[null,"Potencia ( Kw )",250]
[null,"Cos ϕ",0.9]
[null,"Tensión ( V )",400]
[null,"Caida de tensión estimada ( % )",0.5]
[null,"Longitud del cable ( Mt )",30]
[null,"Tipo de cable","Cu"]
[null,"Conductividad K ( m/Ω mm2)",{"$f":"VLOOKUP(C10,datos!D7:E8,2,0)","v":56}]
[null,"Sistema de montaje","D"]
[null,"Aislamiento y nº de cables","PVC3"]
[]
[]
[]
[null,"Requerimientos estrictos"]
[null,"Sección ( mm2 )",{"$f":"10^5*C5*C9/(C11*C8*C7^2)","v":167.41071428571428}]
[null,"Intensidad ( A )",{"$f":"((C5*1000)/(SQRT(3)*C7*C6))","v":400.93768693724013}]
[]
[null,"Cable Propuesto (de la tabla)"]
[null,"Sección ( mm2 )",240]
[null,"Intensidad ( A )",{"$f":"IF(C12=\"D\",(IFERROR(INDEX((tablas!R13:U28,tablas!R30:U44),MATCH(C22,CHOOSE(MATCH(C10,{\"Cu\";\"Al\"},),tablas!Q13:Q28,tablas!Q30:Q44),),MATCH(C13,INDEX(tablas!R11:U11,MATCH(C12,tablas!Q11:Q11,),),),MATCH(C10,{\"Cu\";\"Al\"},)),\"\")),(IFERROR(INDEX((tablas!C13:N27,tablas!C30:N43),MATCH(C22,CHOOSE(MATCH(C10,{\"Cu\";\"Al\"},),tablas!B13:B27,tablas!B30:B43),),MATCH(C13,INDEX(tablas!C4:N10,MATCH(C12,tablas!B4:B10,),),),MATCH(C10,{\"Cu\";\"Al\"},)),\"\")))","v":282}]
[]
[null,"Comprobación del cable propuesto"]
[null,"Temperatura real del cable ( ºC )",{"$f":"40+(IF(OR(C13=\"XLPE2\",C13=\"XLPE3\"),90,IF(OR(C13=\"PVC2\",C13=\"PVC3\"),70))-40)*((C19/C23)^2)","v":100.64245843012841}]
[null,"Conductividad K a Tª real ( m/Ω mm2)",{"$f":"(VLOOKUP(C10,datos!D7:E8,2,0))/(1+((VLOOKUP(C10,datos!I7:J8,2,0))*(ejercicio!C26-20)))","v":42.549362142275292}]
[null,"Comprobar sección ( mm2 )",{"$f":"10^5*C5*C9/(C27*C8*C7^2)","v":220.33232763048608}]
[null,"Caida de tensión real ( % )",{"$f":"((100*10^3*C5*C9)/(C27*C22*C7^2))","v":0.45902568256351262}]
[]
[null,"Cumple",{"$f":"C28<=C22","v":true}]

{"sheet":"datos","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,"20ºC",null,null,null,"a 20ºC","Coef. Térmico ºC-1"]
[null,null,null,"Cu",56,"A1","PVC3",null,"Cu",3.9199999999999999E-3]
[null,null,null,"Al",35,"A2","PVC2",null,"Al",4.0299999999999997E-3]
[null,null,null,null,null,"B1","XLPE3"]
[null,null,null,null,null,"B2","XLPE2"]
[null,null,null,null,null,"C"]
[null,null,null,null,null,"D"]
[null,null,null,null,null,"E"]
[null,null,null,null,null,"F"]