{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["tablas","Informe de sensibilidad 1","ejercicio","datos","sistemas montaje"],"not_rendered":{"charts":0,"images":39,"macros":1,"external_links":0,"defined_names":47,"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,"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,"Metodos de Instalación","Sección mm2","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":"Informe de sensibilidad 1","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 12.0 Informe de sensibilidad"]
["Hoja de cálculo: [CALCULO DE CABLES (UNE20460-5-523) FIN.xlsm]ejercicio"]
["Informe creado: 17/12/2014 20:33:26"]
[]
[]
["Celdas cambiantes"]
[null,null,null,"Valor","Gradiente"]
[null,"Celda","Nombre","Igual","reducido"]
[null,"$F$25","ICC Máx. soportada por el cable",0,0]
[]
["Restricciones"]
[null,null,null,"Valor","Multiplicador"]
[null,"Celda","Nombre","Igual","de Lagrange"]
[null,"$C$23","Comprobar sección ( mm2 ) XLPE3",0.84613814107080099,0]
[null,"$D$20","Sección ( mm2 ) e Intensidad Max. ( A )",16.5,0]
[null,"$C$24","Caida de tensión real ( % ) XLPE3",1.1281841880944012,0]

{"sheet":"ejercicio","index":2,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,3,25,3],[2,1,2,2],[16,1,16,2]]}
[null,"CÁLCULO EXACTO DE UN CABLE ( POR IMAX , ICCTO Y CAIDA DE TENSIÓN ).-"]
[]
[null,"Datos de enterada"]
[null,"Potencia ( Kw )",8]
[null,"Cos ϕ",0.9]
[null,"Tensión ( V )",400]
[null,"Caida de tensión estimada ( % )",2]
[null,"Longitud del cable ( Mt )",12]
[null,"Tipo de cable","Cu"]
[null,"Conductividad K ( m/Ω mm2)",{"$f":"VLOOKUP(C9,datos!D7:E8,2,0)","v":56}]
[null,"Sistema de montaje","B1"]
[null,"Aislamiento y nº de cables","XLPE3"]
[null,"Duración del cortocircuito ( Seg. )",0.2]
[]
[]
[]
[null,"Datos de salida"]
[null,"Intensidad ( A )",{"$f":"IF(AND(C6=230,OR(C12=\"PVC2\",C12=\"XLPE2\")),((C4*1000)/(230*C5)),((C4*1000)/(SQRT(3)*C6*C5)))","v":12.830005981991683}]
[1,"Sección ( mm2 )",{"$f":"IF(AND(C6=230,OR(C12=\"PVC2\",C12=\"XLPE2\")),((200*1000*C4*C8)/(C10*C7*C6^2)),((100*1000*C4*C8)/(C10*C7*C6^2)))","v":0.5357142857142857}]
[2,"Sección ( mm2 ) e Intensidad Max. ( A )",{"$f":"IF(AND(C6=230,OR(C12=\"PVC2\",C12=\"XLPE2\")),IF(C11=\"D\",IFERROR(INDEX((tablas!Q13:Q28,tablas!Q30:Q44),MATCH(1,INDEX(--(200*1000*C4*C8/(C10*C7*C6^2)<=CHOOSE(MATCH(C9,{\"Cu\";\"Al\"},),tablas!Q13:Q28,tablas!Q30:Q44)),),),1,MATCH(C9,{\"Cu\";\"Al\"},)),\"Excede de 300\"),IFERROR(INDEX((tablas!B13:B27,tablas!B30:B43),MATCH(1,INDEX(--(200*1000*C4*C8/(C10*C7*C6^2)<=CHOOSE(MATCH(C9,{\"Cu\";\"Al\"},),tablas!B13:B27,tablas!B30:B43)),),),1,MATCH(C9,{\"Cu\";\"Al\"},)),\"Excede de 240\")),IF(C11=\"D\",IFERROR(INDEX((tablas!Q13:Q28,tablas!Q30:Q44),MATCH(1,INDEX(--(100*1000*C4*C8/(C10*C7*C6^2)<=CHOOSE(MATCH(C9,{\"Cu\";\"Al\"},),tablas!Q13:Q28,tablas!Q30:Q44)),),),1,MATCH(C9,{\"Cu\";\"Al\"},)),\"Excede de 300\"),IFERROR(INDEX((tablas!B13:B27,tablas!B30:B43),MATCH(1,INDEX(--(100*1000*C4*C8/(C10*C7*C6^2)<=CHOOSE(MATCH(C9,{\"Cu\";\"Al\"},),tablas!B13:B27,tablas!B30:B43)),),),1,MATCH(C9,{\"Cu\";\"Al\"},)),\"Excede de 240\")))","v":1.5},{"$f":"IF(C11=\"D\",(IFERROR(INDEX((tablas!R13:U28,tablas!R30:U44),MATCH(C20,CHOOSE(MATCH(C9,{\"Cu\";\"Al\"},),tablas!Q13:Q28,tablas!Q30:Q44),),MATCH(C12,INDEX(tablas!R11:U11,MATCH(C11,tablas!P12:P44,),),),MATCH(C9,{\"Cu\";\"Al\"},)),\"\")),(IFERROR(INDEX((tablas!C13:N27,tablas!C30:N43),MATCH(C20,CHOOSE(MATCH(C9,{\"Cu\";\"Al\"},),tablas!B13:B27,tablas!B30:B43),),MATCH(C12,INDEX(tablas!C4:N10,MATCH(C11,tablas!B4:B10,),),),MATCH(C9,{\"Cu\";\"Al\"},)),\"\")))","v":16.5}]
[3,"Temperatura real del cable ( ºC )",{"$f":"IF(OR(C20=\"Excede de 240\",C20=\"Excede de 300\"),\"\",IF(C11=\"D\",25,40)+(IF(OR(C12=\"XLPE2\",C12=\"XLPE3\"),90,IF(OR(C12=\"PVC2\",C12=\"PVC3\"),70))-IF(C11=\"D\",25,40))*((C18/D20)^2))","v":70.231231129098688}]
[4,"Conductividad K a Tª real ( m/Ω mm2)",{"$f":"IF(OR(C20=\"Excede de 240\",C20=\"Excede de 300\"),\"\",(VLOOKUP(C9,datos!D7:E8,2,0))/(1+((VLOOKUP(C9,datos!I7:J8,2,0))*(ejercicio!C21-20))))","v":46.78728326819126}]
[5,"Comprobar sección ( mm2 )",{"$f":"IF(OR(C20=\"Excede de 240\",C20=\"Excede de 300\"),\"\",IF(AND(C6=230,OR(C12=\"PVC2\",C12=\"XLPE2\")),((200*1000*C4*C8)/(C22*C7*C6^2)),((100*1000*C4*C8)/(C22*C7*C6^2))))","v":0.641199871085393},{"$f":"IF(OR(C20=\"Excede de 240\",C20=\"Excede de 300\"),\"\",IF(OR(C23>C20,D20<C18),C20&\"  \"\"NO CUMPLE\"\"\",C20&\"  \"\"CUMPLE\"\"\"))","v":"1,5  \"CUMPLE\""}]
[6,"Caida de tensión real ( % )",{"$f":"IF(C6=400,IF(OR(C20=\"Excede de 240\",C20=\"Excede de 300\"),\"\",IF(AND(C23<=C20,D20>C18),(100*10^3*C4*C8)/(C22*C20*C6^2),IF(AND(#REF!<=#REF!,#REF!>C18),(100*10^3*C4*C8)/(#REF!*#REF!*C6^2),IF(AND(#REF!<=#REF!,#REF!>C18),(100*10^3*C4*C8)/(#REF!*#REF!*C6^2),IF(AND(#REF!<=#REF!,#REF!>C18),(100*10^3*C4*C8)/(#REF!*#REF!*C6^2),))))),IF(C6=230,IF(OR(C20=\"Excede de 240\",C20=\"Excede de 300\",#REF!=\"Excede de 240\",#REF!=\"Excede de 300\",#REF!=\"Excede de 240\",#REF!=\"Excede de 300\",#REF!=\"Excede de 240\",#REF!=\"Excede de 300\"),\"\",IF(AND(C23<=C20,D20>C18),(200*10^3*C4*C8)/(C22*C20*C6^2),IF(AND(#REF!<=#REF!,#REF!>C18),(200*10^3*C4*C8)/(#REF!*#REF!*C6^2),IF(AND(#REF!<=#REF!,#REF!>C18),(200*10^3*C4*C8)/(#REF!*#REF!*C6^2),IF(AND(#REF!<=#REF!,#REF!>C18),(200*10^3*C4*C8)/(#REF!*#REF!*C6^2),\"\")))))))","v":0.85493316144719056}]
[null,"ICC Máx. soportada por el cable",{"$f":"(IF(AND(C9=\"Al\",OR(C12=\"XLPE2\",C12=\"XLPE3\")),93,IF(AND(C9=\"Al\",OR(C12=\"PVC2\",C12=\"PVC3\")),75,IF(AND(C9=\"Cu\",OR(C12=\"XLPE2\",C12=\"XLPE3\")),142,IF(AND(C9=\"Cu\",OR(C12=\"PVC2\",C12=\"PVC3\")),115))))*IF(OR(C20=\"Excede de 240\",C20=\"Excede de 300\",#REF!=\"Excede de 240\",#REF!=\"Excede de 300\",#REF!=\"Excede de 240\",#REF!=\"Excede de 300\",#REF!=\"Excede de 240\",#REF!=\"Excede de 300\"),\"\",IF(AND(C23<=C20,D20>C18),C20,IF(AND(#REF!<=#REF!,#REF!>C18),#REF!,IF(AND(#REF!<=#REF!,#REF!>C18),#REF!,IF(AND(#REF!<=#REF!,#REF!>C18),#REF!,\"\"))))))/(SQRT(C13))","v":{"$error":"#REF!"}},{"$f":"IF(C26>=C25,\"\"\"CUMPLE\"\"\",\"\"\"NO CUMPLE\"\"\")","v":{"$error":"#REF!"}}]
[null,"ICC Máx. admisible del cable",{"$f":"(IF(OR(C20=\"Excede de 240\",C20=\"Excede de 300\",#REF!=\"Excede de 240\",#REF!=\"Excede de 300\",#REF!=\"Excede de 240\",#REF!=\"Excede de 300\",#REF!=\"Excede de 240\",#REF!=\"Excede de 300\"),\"\",IF(AND(C23<=C20,D20>C18),C20,IF(AND(#REF!<=#REF!,#REF!>C18),#REF!,IF(AND(#REF!<=#REF!,#REF!>C18),#REF!,IF(AND(#REF!<=#REF!,#REF!>C18),#REF!,\"\"))))))*(IF(AND(C9=\"Al\",OR(C12=\"XLPE2\",C12=\"XLPE3\")),HLOOKUP(C13,datos!F21:N25,2,),IF(AND(C9=\"Al\",OR(C12=\"PVC2\",C12=\"PVC3\")),HLOOKUP(C13,datos!F21:N25,3),IF(AND(C9=\"Cu\",OR(C12=\"XLPE2\",C12=\"XLPE3\")),HLOOKUP(C13,datos!F21:N25,4,),IF(AND(C9=\"Cu\",OR(C12=\"PVC2\",C12=\"PVC3\")),HLOOKUP(C13,datos!F21:N25,5,))))))","v":{"$error":"#REF!"}}]

{"sheet":"datos","index":3,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[18,5,18,13],[29,3,30,3],[27,3,28,3],[23,3,24,3],[21,3,22,3],[19,5,19,13]]}
[]
[]
[]
[]
[]
["Tensiones",400,null,null,"20ºC",null,null,null,"a 20ºC","Coef. Térmico ºC-1"]
[null,230,null,"Cu",56,"A1","PVC3",null,"Cu",3.9199999999999999E-3]
[null,null,null,"Al",35,"A2","PVC2","XLPE3","Al",4.0299999999999997E-3]
[null,null,null,null,null,"B1","XLPE3","PVC3"]
[null,null,null,null,null,"B2","XLPE2","XLPE2"]
[null,null,null,null,null,"C",null,"PVC2"]
[null,null,null,null,null,"D"]
[null,null,null,null,null,"E"]
[null,null,null,null,null,"F"]
[]
[]
[]
[]
[null,null,null,null,null,"Densidad de corriente de cortocircuito, en A/mm2 para conductores de Aluminio y Cobre"]
[null,null,null,null,null,"duración del cortocircuito en segundos"]
[null,null,null,null,null,0.1,0.2,0.3,0.5,1,1.5,2,2.5,3]
[null,null,null,"Al","XLPE",294,208,170,132,93,76,66,59,54]
[null,null,null,null,"PVC",237,168,137,106,75,61,53,47,43]
[null,null,null,"Cu","XLPE",449,318,259,201,142,116,100,90,82]
[null,null,null,null,"PVC",364,257,210,163,115,94,81,73,66]
[]
[null,null,null,null,null,"K"]
[null,null,null,"Al","XLPE",93]
[null,null,null,null,"PVC",75]
[null,null,null,"Cu","XLPE",142]
[null,null,null,null,"PVC",115]

{"sheet":"sistemas montaje","index":4,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,1,2,9]]}
[]
[]
[null,"METODOS DE INSTALACIÓN DE REFERENCIA"]
[]
[null,"A1","A2","B1","B2","C","D","E","F","G"]
[null,"Conductores aislados en un conducto en una pared térmicamente aislante","Cable multiconductor en un conductor en una pared térmicamente aislante","Conductores aislados en un conducto sobre una pared de madera","Cable multiconductor en un conducto sobre una pared de madera","Cables unipolares o multipolares sobre una pared de madera","Cable multiconductor en conductos enterrados","Cable multiconductor al aire libre.  Distancia al muro no inferior a 0,3 veces el diámetro del cable","Cables unipolares en contacto al aire libre.  Distancia al muro no inferior al diámetro del cable","Cables unipolares espaciados al aire libre. Distancia entre ellos como mínimo el diámetro del cable"]
[]
[null,"Conductores aislados o cables unipolares en conductos empotrados en paredes térmicamente aislantes","Cable multiconductos empotrados en una pared térmicamente aislante","Conductores aislados o cable unipolar en conductos sobre pared de madera o de man¡mpostería, no espaciados una distancia inferior a 0,3 veces el diámetro del conductor de ella","Cable multiconductor en conducto sobre pared de madera o de mampostería, no espaciado una distancia inferior a 0,3 veces el diámetro del conducto de ella","Cables unipolares o multipolares: - Fijados sobre una pared de madera o espaciados menos de 0,3 veces el diámetro del cable de la pared.",null,"Sobre bandejas de cables perforadas","Sobre bandejas de cables perforadas","Separados de la pared mas de 0,3 veces el diámetro del cable"]
[]
[null,"Cable multiconductor empotrado directamente en una pared térmicamente aislante",null,"Conductores aislados o cables unipolares en abrazaderas fijadas sobre una pared de madera:  - En recorrido horizontal. -En recorrido vertical","( En estudio )                                           Cable multiconductor en abrazaderas fijadas sobre una pared de madera:  - En recorrido horizontal. -En recorrido vertical","Cables unipolares o multipolares: - Fijados directamente bajo un techo de madera",null,"Sobre bandejas de cables perforadas","Sobre bandejas de cables perforadas","Conductores desnudos oaislados sobre aisladores"]
[]
[null,"Conductores aislados o cables unipolares en molduras",null,"Conductores aislados en abrazaderas suspendiddas. Cable multiconductor en abrazaderas suspendidas","Conductores aislados en abrazaderas suspendiddas. Cable multiconductor en abrazaderas suspendidas","( En estudio )                                           Cables unipolares o multipolares: - Separados del techo",null,"Sobre abrazaderas o rejillas","Sobre abrazaderas o rejillas"]
[]
[null,"Conductores aislados en conductos o cables unipolares o multipolares en arquitrave",null,"Conductores aislados o cables unipolares en rodapies ranurados. Cable multiconductor en rodapies ranurados.-","Conductores aislados o cables unipolares en rodapies ranurados. Cable multiconductor en rodapies ranurados.-","Sobre bandejas de cables no perforadas",null,"Sobre abrazaderas o rejillas","Sobre abrazaderas o rejillas"]
[]
[null,"Conductores aislados en conductos o cables unipolares o multipolares en los cercos de las ventanas",null,"5De ≤ V ≤ 50De                                       Cables unipolares o multipolares en vacios de construcción","1,5De ≤ V ≤ 5De                                       Cables unipolares o multipolares en vacios de construcción","Sobre bandejas de cables no perforadas",null,"Separados de la pared mas de 0,3 veces el diámetro del cable","Separados de la pared mas de 0,3 veces el diámetro del cable"]
[]
[null,null,null,"V > 20De                                       Conductores aislados en conductos vacios de construcción","1,5De ≤ V ≤ 20De                                       Conductores aislados en conductos vacios de construcción",null,null,"Sobre escaleras de cables","Sobre escaleras de cables"]
[]
[null,null,null,"V > 20De                                       Conductores aislados en conductos vacios de construcción","1,5De ≤ V ≤ 20De                                       Conductores aislados en conductos vacios de construcción",null,null,"Cable unipolar o multipolar suspendido de un cable portador o autoportante","Cable unipolar o multipolar suspendido de un cable portador o autoportante"]
[]
[null,null,null,"5De ≤ V ≤ 50De                                       Conductores aislados en conductos empotrados en la mampostería de resistividadd térmica no superior a 2 K*m/W","1,5De ≤ V ≤ 5De                                       Conductores aislados en conductos empotrados en la mampostería de resistividadd térmica no superior a 2 K*m/W"]
[]
[null,null,null,"5De ≤ V ≤ 50De                                       Cables unipolares o multipolares     - en los vacios de techo                                          - en los suelos suspendidos","1,5De ≤ V ≤ 5De                                       Cables unipolares o multipolares     - en los vacios de techo                                          - en los suelos suspendidos"]