{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["DISCLAIMER","Instrucciones","DATOS","Flujo de caja","Calculo(rehabilitado)","Calculo(inicial)","LOCALIDADES","LIMITES"],"not_rendered":{"charts":0,"images":16,"macros":0,"external_links":1,"defined_names":5,"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":"DISCLAIMER","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["DISCLAIMER / DESCARGO DE RESPONABILIDAD"]
["El objeto de esta herramienta es efectuar un estudio preliminar sobre el impacto de la rehabilitación en un edificio de viviendas."]
["No es pues una herramienta para ser utilizada en fase de proyecto definitivo de rehabilitación y tampoco una herramienta para efectuar las verificaciones reglamentarias que puedan ser legalmente exigibles"]
["La información proporcionada por la herramienta se ofrece a título estimativo como ayuda al usuario o propietario del edificio o vivienda, pero ni es ni puede sustituir al conjunto de cálculos y comprobaciones que la dirección técnica del proyecto de rehabilitación energética deberá llevar a cabo para justificar el cumplimiento de la reglamentación técnica vigente y de aplicación al proyecto, como puede ser la reglamentaria certificación energética del edificio o vivienda. "]
["Los diferentes niveles de rehabilitación (\"mínima\", \"estándar\" y \"elevada\") sirven para realizar cálculos orientativos, pero no implican el cumplimiento con el Código Técnico de Edificación que deberá ser siempre evaluado por la dirección técnica del proyecto. "]
["El estudio proporcionado sobre el cumplimiento con las subvenciones es orientativo y se deberá verificar en cada Comunidad Autónoma por un técnico designado a tal fin."]

{"sheet":"Instrucciones","index":1,"n_rows":392,"n_cols":3,"rows_kept":392,"cut":false,"hidden":false,"merged":[[298,1,298,2],[386,1,386,2],[0,1,0,3]]}
[null,"INSTRUCCIONES HERRAMIENTA ESTUDIO PRELIMINAR REHABILITACION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"EN 13790 EN 52016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"HIPÓTESIS"]
[null,"Temperaturas de consigna","Se ha considerado 19ºC para invierno y 26ºC para verano durante todas las horas del día"]
[null,"Ganancias internas","Se ha considerado un valor de 2,1 W/m2 que corresponden al uso vivienda"]
[null,"Ventilación nocturna","Durante los meses de verano se ha considerado un aumento de la ventilación nocturna con el fin de eliminar el sobre-calentamiento"]
[null,"Factor solar de protección estacional","Se ha incluido un factor de protección adicional durante los meses de verano (efecto persianas) para evitar el exceso de ganancias solares"]
[null,null,"© Josep Sole"]

{"sheet":"DATOS","index":2,"n_rows":126,"n_cols":12,"rows_kept":126,"cut":false,"hidden":false,"merged":[[100,1,100,2],[99,1,99,2],[101,3,101,4],[1,1,1,10],[84,1,84,10],[50,8,50,9],[2,2,2,9],[88,1,88,10],[39,2,39,8],[61,2,61,8],[29,2,29,9],[97,1,97,10],[86,2,86,4],[85,2,85,4],[3,2,3,9],[15,2,15,9],[123,1,123,10],[124,1,124,10],[125,1,125,10],[120,1,120,10],[13,3,13,6],[23,1,23,2],[23,4,23,7],[24,2,24,9],[85,8,85,9],[37,2,37,9],[30,2,30,9],[14,6,14,9],[31,1,31,10],[25,1,25,10],[36,2,36,9],[118,2,118,8],[102,3,102,4],[103,3,103,4],[101,1,101,2],[121,1,121,10],[122,1,122,10],[115,2,116,8],[104,1,104,10],[109,1,109,10]]}
[]
[null,"ESTUDIO PRELIMINAR REHABILITACIÓN ENERGÉTICA VIVIENDAS"]
[null,"Nombre del proyecto","Edificio plurifamiliar entre medianeras"]
[null,null,"Información del edificio"]
[null,"Ciudad referencia",null,null,null,"Zona Climática",{"$f":"INDEX(LOCALIDADES!BV3:BV59,'Calculo(rehabilitado)'!C2)","v":"C2"}]
[null,"Superficie Útil",{"$f":"159*4","v":636},"m2","Número Viviendas",8]
[null,"Altura entre plantas",3,"m"]
[null,"Situación Inicial",1]
[null,null,"Fachada\nSur","Fachada\nSur Este","Fachada\nEste","Fachada\nNorte","Fachada\nOeste","Fachada\nSur Oeste","Azoteas\nTejados","Cerramientos exteriores\nNo soleados"]
[null,"Superficie (bruta)",145.5,null,null,145.5,null,null,15.16,297.60000000000002,"m2"]
[null,"% huecos",20,null,null,20,null,null,"(--)",20,"(0-30)",{"$f":"IF(MAX(C11:J11)>30,\"mayor de 30%\",\" \")","v":" "}]
[null,"Dispone Refrigeración ?",2]
[null,null,"Lectura Facturas"]
[null,"Calefacción € /año","--","Si no se disponen estos datos se usará una estimación efectuada por la herramienta"]
[null,"Refrigeración € /año","--"]
[null,null,"Escenario de Rehabilitación"]
[null,"Rehabilitación opaco",2,1,1,2,1,1,2,2]
[null,"Rehabilitación hueco",2,1,1,2,1,1,"(--)",2]
[null,"Protección solar huecos",1,1,1,1,1,1,"(--)","(--)"]
[null,"Tipo Intervención",2,1,1,2,1,1,2,2]
[null,"Puentes Térmicos",1]
[null,"Hermeticidad",1]
[]
[null,"Presupuesto total de rehabilitación €",null,"--","Si no se dispone de este dato se usará una estimación efectuada por la herramienta"]
[null,null,"Listado coeficientes antes y después de rehabilitar"]
[null,"Coeficientes Edificio Sin Rehabilitar"]
[null,"Uopaco",{"$f":"INDEX(LIMITES!$B$4:$B$6,$C$8)","v":1.8},{"$f":"INDEX(LIMITES!$B$4:$B$6,$C$8)","v":1.8},{"$f":"INDEX(LIMITES!$B$4:$B$6,$C$8)","v":1.8},{"$f":"INDEX(LIMITES!$B$4:$B$6,$C$8)","v":1.8},{"$f":"INDEX(LIMITES!$B$4:$B$6,$C$8)","v":1.8},{"$f":"INDEX(LIMITES!$B$4:$B$6,$C$8)","v":1.8},{"$f":"INDEX(LIMITES!C4:C6,C8)","v":2.5},{"$f":"INDEX(LIMITES!$B$4:$B$6,$C$8)","v":1.8},"W/m2·K"]
[null,"Uhuecos",{"$f":"INDEX(LIMITES!$D$4:$D$6,$C$8)","v":5.7},{"$f":"INDEX(LIMITES!$D$4:$D$6,$C$8)","v":5.7},{"$f":"INDEX(LIMITES!$D$4:$D$6,$C$8)","v":5.7},{"$f":"INDEX(LIMITES!$D$4:$D$6,$C$8)","v":5.7},{"$f":"INDEX(LIMITES!$D$4:$D$6,$C$8)","v":5.7},{"$f":"INDEX(LIMITES!$D$4:$D$6,$C$8)","v":5.7},"(--)",{"$f":"INDEX(LIMITES!$D$4:$D$6,$C$8)","v":5.7},"W/m2·K"]
[null,"F.solar",{"$f":"INDEX(LIMITES!$F$4:$F$5,$C$8,0)","v":0.75},{"$f":"INDEX(LIMITES!$F$4:$F$5,$C$8,0)","v":0.75},{"$f":"INDEX(LIMITES!$F$4:$F$5,$C$8,0)","v":0.75},{"$f":"INDEX(LIMITES!$F$4:$F$5,$C$8,0)","v":0.75},{"$f":"INDEX(LIMITES!$F$4:$F$5,$C$8,0)","v":0.75},{"$f":"INDEX(LIMITES!$F$4:$F$5,$C$8,0)","v":0.75},null,{"$f":"INDEX(LIMITES!$F$4:$F$5,$C$8,0)","v":0.75}]
[null,"Factor PT",{"$f":"LIMITES!J8","v":1.3},null,null,null,null,null,null,null,"(-)"]
[null,"Hermeticidad",{"$f":"INDEX(LIMITES!E4:E6,C8)","v":2},null,null,null,null,null,null,null,"ren/h"]
[null,"Coeficientes Edificio Rehabilitado"]
[null,"Uopaco",{"$f":"IF(C17=1,C27,VLOOKUP(LEFT($G$5,1),LIMITES!$A$10:$D$14,C17,0))","v":0.49},{"$f":"IF(D17=1,D27,VLOOKUP(LEFT($G$5,1),LIMITES!$A$10:$D$14,D17,0))","v":1.8},{"$f":"IF(E17=1,E27,VLOOKUP(LEFT($G$5,1),LIMITES!$A$10:$D$14,E17,0))","v":1.8},{"$f":"IF(F17=1,F27,VLOOKUP(LEFT($G$5,1),LIMITES!$A$10:$D$14,F17,0))","v":0.49},{"$f":"IF(G17=1,G27,VLOOKUP(LEFT($G$5,1),LIMITES!$A$10:$D$14,G17,0))","v":1.8},{"$f":"IF(H17=1,H27,VLOOKUP(LEFT($G$5,1),LIMITES!$A$10:$D$14,H17,0))","v":1.8},{"$f":"IF(I17=1,I27,VLOOKUP(LEFT($G$5,1),LIMITES!$E$10:$H$14,I17,0))","v":0.4},{"$f":"IF(J17=1,J27,VLOOKUP(LEFT($G$5,1),LIMITES!$A$10:$D$14,J17,0))","v":0.49},"W/m2·K"]
[null,"Uhuecos",{"$f":"IF(C18=1,C28,IF(C18=2,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,2)),IF(C18=3,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,3)),VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,4))))","v":2.1},{"$f":"IF(D18=1,D28,IF(D18=2,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,2)),IF(D18=3,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,3)),VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,4))))","v":5.7},{"$f":"IF(E18=1,E28,IF(E18=2,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,2)),IF(E18=3,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,3)),VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,4))))","v":5.7},{"$f":"IF(F18=1,F28,IF(F18=2,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,2)),IF(F18=3,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,3)),VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,4))))","v":2.1},{"$f":"IF(G18=1,G28,IF(G18=2,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,2)),IF(G18=3,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,3)),VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,4))))","v":5.7},{"$f":"IF(H18=1,H28,IF(H18=2,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,2)),IF(H18=3,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,3)),VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,4))))","v":5.7},"(--)",{"$f":"IF(J18=1,J28,IF(J18=2,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,2)),IF(J18=3,(VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,3)),VLOOKUP(LEFT($G$5,1),LIMITES!$A$17:$D$21,4))))","v":2.1},"W/m2·K"]
[null,"F.Solar",{"$f":"IF(C19=1,C29,INDEX(LIMITES!$B$24:$B$25,C19,0))","v":0.75},{"$f":"IF(D19=1,D29,INDEX(LIMITES!$B$24:$B$25,D19,0))","v":0.75},{"$f":"IF(E19=1,E29,INDEX(LIMITES!$B$24:$B$25,E19,0))","v":0.75},{"$f":"IF(F19=1,F29,INDEX(LIMITES!$B$24:$B$25,F19,0))","v":0.75},{"$f":"IF(G19=1,G29,INDEX(LIMITES!$B$24:$B$25,G19,0))","v":0.75},{"$f":"IF(H19=1,H29,INDEX(LIMITES!$B$24:$B$25,H19,0))","v":0.75},"(--)","(--)"]
[null,"R.térmica aislante",{"$f":"1/C33-1/C27","v":1.4852607709750567},0,0,1.4852607709750567,0,0,2.1,1.4852607709750567,"m2·K/W"]
[null,"Factor PT",{"$f":"INDEX(LIMITES!J8:J10,C21)","v":1.3},null,null,null,null,null,null,null,"(-)"]
[null,"Hermeticidad",{"$f":"IF(C22=1,C31,INDEX(LIMITES!J4:J6,DATOS!C22))","v":2},null,null,null,null,null,null,null,"ren/h"]
[]
[null,null,"DEMANDA ENERGÉTICA PROBABLE"]
[null,null,null,"Estado inicial","Edificio rehabilitado",null,"Estado inicial","Edificio rehabilitado"]
[null,null,"Calefacción",{"$f":"'Calculo(inicial)'!B108","v":99097.306186532238},{"$f":"'Calculo(rehabilitado)'!B108","v":52189.071747754591},"kWh/año",{"$f":"D42/$C$6","v":155.81337450712616},82.058288911563821,"kWh/m2/año"]
[null,null,"Refrigeración",{"$f":"'Calculo(inicial)'!B109","v":3557.3862560516923},{"$f":"'Calculo(rehabilitado)'!B109","v":2426.5464783744692},"kWh/año",5.5933746164334783,3.8153246515321841,"kWh/m2/año"]
[null,null,"TOTAL",{"$f":"SUM(D42:D43)","v":102654.69244258392},{"$f":"SUM(E42:E43)","v":54615.61822612906},"kWh/año",161.40674912355962,85.873613563096001,"kWh/m2/año"]
[null,null,"%ahorro",null,{"$f":"100*(D44-E44)/D44","v":46.796764057642797},"%",null,{"$f":"100*(G44-H44)/G44","v":46.79676405764279},"%"]
[]
[null,"Rendimiento estacional",null,"Coef paso a EPnr"]
[null,"Calefacción",{"$f":"LIMITES!B29","v":0.85},{"$f":"LIMITES!D29","v":1.1950000000000001}]
[null,"Refrigeración",{"$f":"LIMITES!B30","v":3},{"$f":"LIMITES!D30","v":1.954}]
[]
[null,null,"CONSUMO PROBABLE E. Final",null,null,null,null,null,"Energía Primaria nr"]
[null,null,null,"Estado inicial","Edificio rehabilitado",null,"Estado inicial","Edificio rehabilitado","Inicial","Rehabilitado"]
[null,null,"Calefacción",{"$f":"D42/C48","v":116585.06610180263},{"$f":"E42/C48","v":61398.907938534816},"kWh/año",{"$f":"D53/$C$6","v":183.30985236132489},96.53916342536921,{"$f":"G53*$D$48","v":219.05527357178326},{"$f":"H53*$D$48","v":115.36430029331622}]
[null,null,"Refrigeración",{"$f":"IF(C12=1,D43/C49,0)","v":0},{"$f":"IF(C12=1,E43/C49,0)","v":0},"kWh/año",0,0,{"$f":"G54*$D$49","v":0},{"$f":"H54*$D$49","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D53:D54)","v":116585.06610180263},{"$f":"SUM(E53:E54)","v":61398.907938534816},"kWh/año",183.30985236132489,96.53916342536921,{"$f":"I53+I54","v":219.05527357178326},{"$f":"J53+J54","v":115.36430029331622}]
[null,null,"%ahorro",null,{"$f":"100*(D55-E55)/D55","v":47.335529333644672},"%",null,{"$f":"100*(G55-H55)/G55","v":47.335529333644672},null,{"$f":"100*(I55-J55)/I55","v":47.335529333644672}]
[]
[null,"Coste Energético"]
[null,"Calefacción",{"$f":"LIMITES!C29","v":6.0499999999999998E-2},"€/kwH"]
[null,"Refrigeración",{"$f":"LIMITES!C30","v":0.20570000000000002},"€/kwH"]
[]
[null,null,"COSTE ENERGETICO PROBABLE"]
[null,null,null,"Estado inicial","Edificio rehabilitado",null,"Estado inicial","Edificio rehabilitado"]
[null,null,"Calefacción",{"$f":"D53*C59","v":7053.3964991590592},{"$f":"E53*C59","v":3714.6339302813562},"€/año",{"$f":"D64/$C$6","v":11.090246067860155},5.8406193872348364,"€/m2/año"]
[null,null,"Refrigeración",{"$f":"D54*C60","v":0},{"$f":"E54*C60","v":0},"€/año",0,0,"€/m2/año"]
[null,null,"TOTAL",{"$f":"SUM(D64:D65)","v":7053.3964991590592},{"$f":"SUM(E64:E65)","v":3714.6339302813562},"€/año",11.090246067860155,5.8406193872348364,"€/m2/año"]
[null,null,"%ahorro",null,{"$f":"100*(D66-E66)/D66","v":47.335529333644679},"%",null,{"$f":"100*(G66-H66)/G66","v":47.335529333644672},"%"]
[]
[null,"Costes unitarios","Opacos"]
[null,"Coste Intervención €/m2",{"$f":"INDEX(LIMITES!$C$36:$C$40,C20)","v":90.750000000000014},{"$f":"INDEX(LIMITES!$C$36:$C$40,D20)","v":0},{"$f":"INDEX(LIMITES!$C$36:$C$40,E20)","v":0},{"$f":"INDEX(LIMITES!$C$36:$C$40,F20)","v":90.750000000000014},{"$f":"INDEX(LIMITES!$C$36:$C$40,G20)","v":0},{"$f":"INDEX(LIMITES!$C$36:$C$40,H20)","v":0},{"$f":"INDEX(LIMITES!C42:C44,I20)","v":102.85000000000002},{"$f":"INDEX(LIMITES!$C$36:$C$40,J20)","v":90.750000000000014}]
[null,"Coste Aislamiento €/m2",{"$f":"IF(C20=1,0,IF(C20=2,9.7643*C36+6.65,IF(C20=3,4.9286*C36+6,IF(C20=4,5.7143*C36+5,IF(C20=5,5.5714*C36+7.5,\"nd\")))))","v":21.152531746031748},0,0,21.152531746031748,0,0,{"$f":"IF(I20=1,0,IF(I20=2,10.357*I36,IF(I20=3,4.9286*I36+6,\"nd\")))","v":21.749700000000001},{"$f":"IF(J20=1,0,IF(J20=2,9.7643*J36+6.65,IF(J20=3,4.9286*J36+6,IF(J20=4,5.7143*J36+5,IF(J20=5,5.5714*J36+7.5,\"nd\")))))","v":21.152531746031748}]
[null,"Coste TOTAL €/m2",{"$f":"C70+C71","v":111.90253174603177},{"$f":"D70+D71","v":0},0,111.90253174603177,0,0,124.59970000000003,111.90253174603177]
[null,"Costes Unitarios","Huecos"]
[null,"Coste TOTAL €/m2",{"$f":"INDEX(LIMITES!$B$48:$E$48,C18)","v":491.26000000000005},{"$f":"INDEX(LIMITES!$B$48:$E$48,D18)","v":0},{"$f":"INDEX(LIMITES!$B$48:$E$48,E18)","v":0},{"$f":"INDEX(LIMITES!$B$48:$E$48,F18)","v":491.26000000000005},{"$f":"INDEX(LIMITES!$B$48:$E$48,G18)","v":0},{"$f":"INDEX(LIMITES!$B$48:$E$48,H18)","v":0},"(--)",{"$f":"INDEX(LIMITES!$B$48:$E$48,J18)","v":491.26000000000005}]
[null,"Coste Prot. solar €/m2",{"$f":"IF(C19=1,0,LIMITES!$C$52)","v":0},{"$f":"IF(D19=1,0,LIMITES!$C$52)","v":0},{"$f":"IF(E19=1,0,LIMITES!$C$52)","v":0},{"$f":"IF(F19=1,0,LIMITES!$C$52)","v":0},{"$f":"IF(G19=1,0,LIMITES!$C$52)","v":0},{"$f":"IF(H19=1,0,LIMITES!$C$52)","v":0},"(--)",0]
[]
[null,"Estimación coste rehabilitación",null,null,null,null,null,null,null,null,"Total"]
[null,"Elementos opacos (m2)",{"$f":"IF(C17=1,0,C10*(100-C11)/100)","v":116.4},0,0,116.4,0,0,{"$f":"IF(I17=1,0,I10*(100)/100)","v":15.16},{"$f":"IF(J17=1,0,J10*(100-J11)/100)","v":238.08}]
[null,"Coste (€)",{"$f":"C78*C72","v":13025.454695238099},0,0,13025.454695238099,0,0,1888.9314520000005,26641.754758095245,{"$f":"SUM(C79:J79)","v":54581.59560057144}]
[null,"Coste Aislamiento(€)",{"$f":"C78*C71","v":2462.1546952380954},0,0,2462.1546952380954,0,0,329.72545200000002,5035.9947580952385,{"$f":"SUM(C80:J80)","v":10290.02960057143}]
[null,"Elementos huecos (m2)",{"$f":"IF(C18=1,0,C10*(C11)/100)","v":29.1},0,0,29.1,0,0,"(--)",{"$f":"IF(J18=1,0,J10*(J11)/100)","v":59.52}]
[null,"Coste (€)",{"$f":"C81*(C74+C75)","v":14295.666000000003},0,0,14295.666000000003,0,0,"(--)",{"$f":"J81*(J74+J75)","v":29239.795200000004},{"$f":"SUM(C82:J82)","v":57831.12720000001}]
[null,"Sobre Coste (€)",{"$f":"C82","v":14295.666000000003},{"$f":"D82","v":0},0,14295.666000000003,0,0,"(--)",29239.795200000004,{"$f":"SUM(C83:J83)","v":57831.12720000001}]
[]
[null,"RESULTADOS ENERGETICOS"]
[null,null,"Reducción anual Demanda",null,null,{"$f":"H45","v":46.79676405764279},"% kWh/año"]
[null,null,"Reducción Anual Energía Primaria no renovable",null,null,{"$f":"J56","v":47.335529333644672},"% kWh/año"]
[]
[null,"RESULTADOS ECONOMICOS"]
[null,null,null,"Ahorro porcentual probable","Calefacción",{"$f":"IF(D64=0,0,100*(D64-E64)/D64)","v":47.335529333644679},"% de €/año"]
[null,null,null,null,"Refrigeración",{"$f":"IF(C12=2,0,IF(D65=0,0,100*(D65-E65)/D65))","v":0},"% de €/año"]
[null,null,null,null,"TOTAL",{"$f":"100*(D66-E66)/D66","v":47.335529333644679},"% de €/año"]
[null,null,null,null,null,"COSTES REALES",null,"Estimación coste debido solo al aislamiento de la envolvente","Estimación coste total rehabilitación"]
[null,"Coste Operacional","Sin Rehabilitar","Rehabilitado","Rehabilitación",{"$f":"IF(ISNUMBER(D24),D24,I94)","v":112412.72280057144},"€",{"$f":"K80","v":10290.02960057143},{"$f":"K79+K82","v":112412.72280057144}]
[null,"Calefacción €/año",{"$f":"D64","v":7053.3964991590592},{"$f":"E64","v":3714.6339302813562},"Coste calefacción",{"$f":"IF(ISNUMBER(C14),C14,C95)","v":7053.3964991590592},"€/año"]
[null,"Refrigeración €/año",{"$f":"D65","v":0},{"$f":"E65","v":0},"Coste Refrigeración",{"$f":"IF(ISNUMBER(C15),C15,C96)","v":0},"€/año"]
[null,"TOTAL",{"$f":"C95+C96","v":7053.3964991590592},{"$f":"D95+D96","v":3714.6339302813562},"Ahorro anual",{"$f":"F95+F96-F95*(1-F90/100)-F96*(1-F91/100)","v":3338.7625688777034},"€/año"]
[null,"POSIBILIDAD SUBVENCIONES"]
[null,"Zona",{"$f":"LEFT(G5,1)","v":"C"},null,"Numero viviendas",{"$f":"F6","v":8}]
[null,"¿Cumple el requisito de reducción de la demanda",null,{"$f":"IF(C99=\"a\",0,IF(C99=\"B\",0,IF(C99=\"C\",25,IF(C99=\"D\",35,IF(C99=\"E\",35,\"ND\")))))","v":25},"% ?",{"$f":"IF(F86>=D100,\"SI\",\"NO\")","v":"SI"},{"$f":"IF(F100=\"no\",0,1)","v":1}]
[null,"¿Cumple el requisito de reducción CEP,nr",null,30,"% ?",{"$f":"IF(F87>D101,\"SI\",\"NO\")","v":"SI"},{"$f":"IF(F101=\"no\",0,1)","v":1}]
[null,"Aplicación RD de subvenciones",null,"La cantidad máxima subvencionable es de:",null,{"$f":"$G$100*$G$101*IF($F$87<30,0,IF($F$87<45,MIN(8100*$F$99,0.4*F94),IF($F$87<60,MIN(14500*$F$99,0.65*F94),MIN(21400*$F$99,0.8*F94))))","v":73068.269820371439}]
[null,null,null,"El porcentaje máximo subvencionable es:",null,{"$f":"F102/F94","v":0.65}]
[null,null,null,"En relación al coste de actuación de :",null,{"$f":"F94","v":112412.72280057144}]
[null,"ANALISIS VIABILIDAD SIN SUBVENCIONES"]
[null,null,null,null,"Recuperación",{"$f":"IF(F94=0,\"--\",IF(AND(F90=0,F91=0),\"--\",IF(AND(F90=0,F91<>0),F94/F97,IF(AND(F91=0,F90<>0),F94/F97,F94/F97))))","v":33.66897779687222},"años"]
[null,null,null,"Tasa Interna de Retorno de la inversión (horizonte 50 años)",{"$f":"CONCATENATE(\"TIR_\",'Flujo de caja'!A54 )","v":"TIR_50"},{"$f":"'Flujo de caja'!I5","v":1.6769667065211324E-2}]
[null,null,null,"Valor Actual Neto de la inversión (horizonte 50 años, tasa interés 1%)",{"$f":"CONCATENATE(\"VAN_\",'Flujo de caja'!A54,\"_\",'Flujo de caja'!I2)","v":"VAN_50_1"},{"$f":"'Flujo de caja'!I6","v":18453.807257613153}]
[]
[null,"ANALISIS VIABILIDAD CON SUBVENCIONES"]
[null,null,null,null,"Recuperación",{"$f":"IF(F94-F102=0,\"--\",IF(AND(F90=0,F91=0),\"--\",IF(AND(F90=0,F91<>0),(F94-F102)/(F97),IF(AND(F91=0,F90<>0),(F94-F102)/(F97),(F94-F102)/(F97)))))","v":11.784142228905276},"años"]
[null,null,null,"Tasa Interna de Retorno de la inversión (horizonte 50 años)",{"$f":"CONCATENATE(\"TIR_\",'Flujo de caja'!A54 )","v":"TIR_50"},{"$f":"'Flujo de caja'!I8","v":8.3306969541680376E-2}]
[null,null,null,"Valor Actual Neto de la inversión (horizonte 50 años, tasa interés 1%)",{"$f":"CONCATENATE(\"VAN_\",'Flujo de caja'!A54,\"_\",'Flujo de caja'!I2)","v":"VAN_50_1"},{"$f":"'Flujo de caja'!I9","v":91522.077077984592}]
[]
[]
[null,null,"Esta herramienta ha sido desarrollada por J.Sole de URSA y ha sido cedida a ANDIMAT para su difusión"]
[]
[]
[null,"© Josep Sole","Actualización marzo 2022 con apoyo del Grupo de Trabajo de Eficiencia Energética de ANDIMAT"]
[]
[null,"DISCLAIMER / DESCARGO DE RESPONABILIDAD"]
[null,"El objeto de esta herramienta es efectuar un estudio preliminar sobre el impacto de la rehabilitación en un edificio de viviendas."]
[null,"No es pues una herramienta para ser utilizada en fase de proyecto definitivo de rehabilitación y tampoco una herramienta para efectuar las verificaciones reglamentarias que puedan ser legalmente exigibles"]
[null,"La información proporcionada por la herramienta se ofrece a título estimativo como ayuda al usuario o propietario del edificio o vivienda, pero ni es ni puede sustituir al conjunto de cálculos y comprobaciones que la dirección técnica del proyecto de rehabilitación energética deberá llevar a cabo para justificar el cumplimiento de la reglamentación técnica vigente y de aplicación al proyecto, como puede ser la reglamentaria certificación energética del edificio o vivienda. "]
[null,"Los diferentes niveles de rehabilitación (\"mínima\", \"estándar\" y \"elevada\") sirven para realizar cálculos orientativos, pero no implican el cumplimiento con el Código Técnico de Edificación que deberá ser siempre evaluado por la dirección técnica del proyecto. "]
[null,"El estudio proporcionado sobre el cumplimiento con las subvenciones es orientativo y se deberá verificar en cada Comunidad Autónoma por un técnico designado a tal fin."]

{"sheet":"Flujo de caja","index":3,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":true,"merged":[[1,1,1,3],[1,4,1,6],[6,7,6,10],[3,7,3,10]]}
[null,null,null,null,null,null,null,"Periodo",50,"años"]
[null,"Sin subvenciones",null,null,"Con Subvenciones",null,null,"Interes referencia",1,"%"]
["años","reales","aislamiento","estimado","reales","aislamiento","estimado",null,{"$f":"I2/100","v":0.01},"(0-1)"]
[0,{"$f":"-DATOS!F94","v":-112412.72280057144},{"$f":"-DATOS!H94","v":-10290.02960057143},{"$f":"-DATOS!I94","v":-112412.72280057144},{"$f":"B4+DATOS!F102","v":-39344.452980200003},{"$f":"C4+DATOS!H102","v":-10290.02960057143},{"$f":"D4+DATOS!I102","v":-112412.72280057144},"Sin subvencion"]
[1,{"$f":"DATOS!F97","v":3338.7625688777034},{"$f":"DATOS!F97","v":3338.7625688777034},{"$f":"DATOS!F97","v":3338.7625688777034},{"$f":"DATOS!F97","v":3338.7625688777034},{"$f":"DATOS!F97","v":3338.7625688777034},{"$f":"DATOS!F97","v":3338.7625688777034},"TIR",{"$f":"IRR(B4:B54,0.01)","v":1.6769667065211324E-2},{"$f":"IRR(C4:C54,0.01)","v":0.32446553205292838},{"$f":"IRR(D4:D54,0.01)","v":1.6769667065211324E-2}]
[2,{"$f":"B5","v":3338.7625688777034},3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,"VAN",{"$f":"NPV(I3,B5:B54)+B4","v":18453.807257613153},{"$f":"NPV(I3,C5:C54)+C4","v":120576.50045761316},{"$f":"NPV(I3,D5:D54)+D4","v":18453.807257613153}]
[3,{"$f":"B6","v":3338.7625688777034},{"$f":"C6","v":3338.7625688777034},{"$f":"D6","v":3338.7625688777034},3338.7625688777034,3338.7625688777034,3338.7625688777034,"Con Subvencion"]
[4,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,"TIR",{"$f":"IRR(E4:E54,0.01)","v":8.3306969541680376E-2},{"$f":"IRR(F4:F54,0.01)","v":0.32446553205292838},{"$f":"IRR(G4:G54,0.01)","v":1.6769667065211324E-2}]
[5,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,"VAN",{"$f":"NPV($I$3,E5:E54)+E4","v":91522.077077984592},{"$f":"NPV($I$3,F5:F54)-F4","v":141156.55965875601},{"$f":"NPV($I$3,G5:G54)+G4","v":18453.807257613153}]
[6,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[7,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[8,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[9,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[10,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[11,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[12,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[13,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[14,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[15,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[16,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[17,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[18,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[19,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[20,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[21,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[22,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[23,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[24,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[25,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[26,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[27,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[28,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[29,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[30,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[31,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[32,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[33,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[34,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[35,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[36,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[37,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[38,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[39,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[40,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[41,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[42,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[43,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[44,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[45,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[46,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[47,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[48,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[49,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]
[50,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034,3338.7625688777034]

{"sheet":"Calculo(rehabilitado)","index":4,"n_rows":109,"n_cols":17,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Emplazamiento",6]
[null,"Sup util","m2",{"$f":"DATOS!C6","v":636}]
[null,"Inercia termica","kJ/m2·K",200,{"$f":"IF(D4<=100,\"muy baja\",IF(D4<=150,\"baja\",IF(D4<400,\"alta\",IF(D4<=400,\"alta\",\"muy alta\"))))","v":"alta"}]
[null,"Renovación de aire","n (invierno)",{"$f":"DATOS!C38","v":2}]
[null,null,"n (verano)",5]
[null,"Altura plantas","m",{"$f":"DATOS!C7","v":3}]
["T.Consigna","Calefacción","ºC",19]
[null,"Refrigeración","ºC",26]
[null,"Ganacias Internas","W/m2",2.1]
[null,null,null,"EXTERIOR",null,null,null,null,null,null,null,"INTERIORES"]
[null,null,null,"Fachadas",null,null,null,null,null,"Cubiertas","Exterior"]
[null,null,null,"F.Sur","F.SurEste","F.Este","F.Norte","F.Oeste","F.SurOeste","Cubiertas","No soleados","A.Vivendas","Z.Comunes","A.Locales","Techos","Suelos","Total"]
["Geometria","Sup","m2",{"$f":"DATOS!C10","v":145.5},{"$f":"DATOS!D10","v":0},{"$f":"DATOS!E10","v":0},{"$f":"DATOS!F10","v":145.5},{"$f":"DATOS!G10","v":0},{"$f":"DATOS!H10","v":0},{"$f":"DATOS!I10","v":15.16},{"$f":"DATOS!J10","v":297.60000000000002}]
[null,"% ventanas","(--) (0 a 1)",{"$f":"DATOS!C11/100","v":0.2},{"$f":"DATOS!D11/100","v":0},{"$f":"DATOS!E11/100","v":0},{"$f":"DATOS!F11/100","v":0.2},{"$f":"DATOS!G11/100","v":0},{"$f":"DATOS!H11/100","v":0},0,{"$f":"DATOS!J11/100","v":0.2}]
["Carac Constructivas","U opac","W/m2·K",{"$f":"DATOS!C33","v":0.49},{"$f":"DATOS!D33","v":1.8},{"$f":"DATOS!E33","v":1.8},{"$f":"DATOS!F33","v":0.49},{"$f":"DATOS!G33","v":1.8},{"$f":"DATOS!H33","v":1.8},{"$f":"DATOS!I33","v":0.4},{"$f":"DATOS!J33","v":0.49}]
[null,"U ventanas","W/m2·K",{"$f":"DATOS!C34","v":2.1},{"$f":"DATOS!D34","v":5.7},{"$f":"DATOS!E34","v":5.7},{"$f":"DATOS!F34","v":2.1},{"$f":"DATOS!G34","v":5.7},{"$f":"DATOS!H34","v":5.7},null,{"$f":"DATOS!J34","v":2.1}]
[null,"Transp. Ventana","(--) (0 a 1)",{"$f":"DATOS!C35","v":0.75},{"$f":"DATOS!D35","v":0.75},{"$f":"DATOS!E35","v":0.75},{"$f":"DATOS!F35","v":0.75},{"$f":"DATOS!G35","v":0.75},{"$f":"DATOS!H35","v":0.75},null,{"$f":"DATOS!J35","v":"(--)"}]
[null,"Coef.Exposición t","(--) (0 a 1)",1,1,1,1,1,1,1,1]
["Sombras","F.Sombra Horizonte (Fsh)","(--) (0 a 1)",1,1,1,1,1,1,1,1]
[null,"F.Carpinteria (Fc)","(--) (0 a 1)",0.7,0.7,0.7,0.7,0.7,0.7,null,0.7]
[null,"F.Persianas (Calefacc.) (Fp.Cal)","(--) (0 a 1)",1,1,1,1,1,1,null,1]
[null,"F.Persianas (Refrig) (Fp.Refrig)","(--) (0 a 1)",0.7,0.7,0.7,0.7,0.7,0.7,null,0.7]
[null,"F.Cornisas (Fsc)","(--) (0 a 1)",1,1,1,1,1,1,null,1]
[null,"F.Pantallas (Fsp)","(--) (0 a 1)",1,1,1,1,1,1,null,1]
["Frentes forjado","Y F.forjado Cubierta","W/m·K"]
[null,"L F.forjado Cubierta","m"]
[null,"Y Fforjaado Intermedio","W/m·K"]
[null,"L F.forjado Intermedio","m"]
[null,"Y Fforjado Inferior","W/m·K"]
[null,"L F.forjado Inferior","m"]
[null,"Factor PT","(--)",{"$f":"DATOS!C37","v":1.3}]
["U medio","(Sf*Uf+Sv*Uv)/S","W/m2·K",{"$f":"IF(D14=0,0,(D14*(1-D15)*D16+D14*D15*D17)/D14)","v":0.81200000000000006},{"$f":"IF(E14=0,0,(E14*(1-E15)*E16+E14*E15*E17)/E14)","v":0},{"$f":"IF(F14=0,0,(F14*(1-F15)*F16+F14*F15*F17)/F14)","v":0},0.81200000000000006,0,{"$f":"IF(I14=0,0,(I14*(1-I15)*I16+I14*I15*I17)/I14)","v":0},0.4,0.81200000000000006,0,0,0,{"$f":"IF(O14=0,0,(O14*(1-O15)*O16+O14*O15*O17)/O14)","v":0},{"$f":"IF(P14=0,0,(P14*(1-P15)*P16+P14*P15*P17)/P14)","v":0}]
["Transmission Termica","S*U*t +Y*l","W/K",{"$f":"D14*D33*D19*$D$32","v":153.58980000000003},0,0,153.58980000000003,0,0,{"$f":"J14*J33*J19","v":6.0640000000000001},314.14656000000008,{"$f":"L14*L33*L19+L26*L27*L19+L28*L29*L19+L30*L31*L19","v":0},{"$f":"M14*M33*M19+M26*M27*M19+M28*M29*M19+M30*M31*M19","v":0},{"$f":"N14*N33*N19+N26*N27*N19+N28*N29*N19+N30*N31*N19","v":0},{"$f":"O14*O33*O19+O26*O27*O19+O28*O29*O19+O30*O31*O19","v":0},{"$f":"P14*P33*P19+P26*P27*P19+P28*P29*P19+P30*P31*P19","v":0},{"$f":"SUM(D34:P34)","v":627.39016000000015}]
["Transmissión Ventilacion","n(invierno)*V*0,34","W/K",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.34*D3*D7*D5","v":1297.44}]
[null,"n(verano)*V*0,34","W/K",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.34*D3*D7*D6","v":3243.6000000000004}]
["F. Sombras (Calefac.)","Fsh*Fc*Fp.Cal*Fsc*Fsp","(--) (0 a 1)",{"$f":"D20*D21*D22*D24*D25","v":0.7},{"$f":"E20*E21*E22*E24*E25","v":0.7},0.7,0.7,0.7,{"$f":"I20*I21*I22*I24*I25","v":0.7},0]
["F. Sombras (Refrig.)","Fsh*Fc*Fp.Refr*Fsc*Fsp","(--) (0 a 1)",{"$f":"D20*D21*D23*D24*D25","v":0.48999999999999994},{"$f":"E20*E21*E23*E24*E25","v":0.48999999999999994},0.48999999999999994,0.48999999999999994,0.48999999999999994,{"$f":"I20*I21*I23*I24*I25","v":0.48999999999999994},0]
["Area solar (Calefac)","Fs.Cal*tr*S","m2",{"$f":"D37*D14*D15*D18","v":15.2775},0,0,15.2775,0,0,0,0]
["Area solar (Refrig.)","Fs.Refr*tr*S","m2",{"$f":"D38*D14*D15*D18+0.045*(1-D15)*D14*D16*D20","v":13.260869999999999},0,0,13.260869999999999,0,0,0.27288000000000001,0]
[null,null,null,"F.Sur","F.Sureste","F.Este","F.Norte","F.Oeste","F.Suroeste","Cubierta","Suelo"]
["TOTAL KWh/año",null,null,"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
[{"$f":"SUM(D43:O43)","v":52189.071747754591},"Ql-(Qi+Qs)*h","CALEFACCION",{"$f":"IF(D76-D103*D95<0,0,D76-D103*D95)","v":12542.482008798104},9230.5477787866566,8051.1889628533163,4726.3595502257704,893.94159126798399,0,0,0,0,611.05908060814158,6309.8145610139745,9823.6782142006414]
[{"$f":"SUM(D44:O44)","v":2426.5464783744692},"Ql*h-(Q+Qs)","REFRIGERACION",{"$f":"IF(D43>0,0,IF(D96-D104*D77<0,0,D96-D104*D77))","v":0},{"$f":"IF(E43>0,0,IF(E96-E104*E77<0,0,E96-E104*E77))","v":0},0,0,0,382.03917468587724,747.99502359901908,859.31814719065869,437.19413289891418,0,0,0]
[null,null,null,"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
["Clima","Dias",null,31,28,31,30,31,30,31,31,30,31,30,31]
[null,"qe","ºC",{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,1)","v":8.4},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,2)","v":10.1},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,3)","v":11.7},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,4)","v":14.1},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,5)","v":17.5},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,6)","v":19.899999999999999},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,7)","v":23.1},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,8)","v":23.6},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,9)","v":20.8},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,10)","v":17.8},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,11)","v":12.9},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,12)","v":10.6}]
[null,"qi (Calef)","ºC",{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},19,19,19,19,19,19]
[null,"qi (Refig)","ºC",{"$f":"$D$9","v":26},{"$f":"$D$9","v":26},26,26,26,26,26,26,26,26,26,26]
[null,"Is(Horitz)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,1)","v":2173.0555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,2)","v":2823.8888888888887},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,3)","v":3744.1666666666665},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,4)","v":4805.5555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,5)","v":5470},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,6)","v":6162.5},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,7)","v":6446.1111111111113},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,8)","v":5550.5555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,9)","v":4139.166666666667},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,10)","v":3067.2222222222222},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,11)","v":2152.7777777777778},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,12)","v":1643.3333333333333}]
[null,"Is(Sur)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,1)","v":4040.3691061707218},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,2)","v":3728.4741269437122},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,3)","v":3362.4272918504757},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,4)","v":2909.6358170175786},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,5)","v":2554.1850075006382},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,6)","v":2535.3312417810457},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,7)","v":2717.717283393562},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,8)","v":2959.7067820182979},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,9)","v":3162.5730387867443},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,10)","v":3560.559429373825},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,11)","v":3527.1545224922147},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,12)","v":3090.3766179782397}]
[null,"Is(Sureste)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,1)","v":3090.3766179782397},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,2)","v":3145.4842403825851},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,3)","v":3142.0314520210009},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,4)","v":3235.636022202782},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,5)","v":3311.4023848290753},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,6)","v":3196.9073323799357},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,7)","v":3326.2811359241805},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,8)","v":3586.4704491103903},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,9)","v":3575.5821246783912},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,10)","v":3263.0001332126603},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,11)","v":3119.0108208805896},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,12)","v":2810.1284790601994}]
[null,"Is(Este)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,1)","v":1773.5662653947948},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,2)","v":2137.5158324169529},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,3)","v":2648.4005484233844},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,4)","v":3209.2665258021671},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,5)","v":3503.8089965265822},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,6)","v":3886.9636073610145},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,7)","v":4113.6491687193538},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,8)","v":3662.6558364110774},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,9)","v":2860.3442204251701},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,10)","v":2264.7646433878776},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,11)","v":1697.211285803276},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,12)","v":1327.2171566373263}]
[null,"Is(Norte)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,1)","v":598.16220462491663},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,2)","v":821.31034384203872},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,3)","v":1123.3656464040096},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,4)","v":1458.9131565349956},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,5)","v":1701.9122357800402},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,6)","v":1833.5023583393292},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,7)","v":1795.9646191471902},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,8)","v":1579.3241452375446},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,9)","v":1243.6090909215425},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,10)","v":906.6962094776261},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,11)","v":637.99135198597662},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,12)","v":511.56482151723338}]
[null,"Is(Oeste)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,1)","v":2173.0555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,2)","v":2823.8888888888887},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,3)","v":3744.1666666666665},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,4)","v":4805.5555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,5)","v":5470},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,6)","v":6162.5},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,7)","v":6446.1111111111113},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,8)","v":5550.5555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,9)","v":4139.166666666667},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,10)","v":3067.2222222222222},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,11)","v":2152.7777777777778},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,12)","v":1643.3333333333333}]
[null,"Is(Suroeste)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,1)","v":3090.3766179782397},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,2)","v":3145.4842403825851},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,3)","v":3142.0314520210009},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,4)","v":3235.636022202782},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,5)","v":3311.4023848290753},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,6)","v":3196.9073323799357},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,7)","v":3326.2811359241805},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,8)","v":3586.4704491103903},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,9)","v":3575.5821246783912},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,10)","v":3263.0001332126603},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,11)","v":3119.0108208805896},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,12)","v":2810.1284790601994}]
["EDIFICIO","HT","W/K",{"$f":"$Q$34","v":627.39016000000015},{"$f":"$Q$34","v":627.39016000000015},627.39016000000015,627.39016000000015,627.39016000000015,627.39016000000015,627.39016000000015,627.39016000000015,627.39016000000015,627.39016000000015,627.39016000000015,627.39016000000015]
[null,"HV (Invierno)","W/K",{"$f":"$Q$35","v":1297.44},{"$f":"$Q$35","v":1297.44},1297.44,1297.44,1297.44,1297.44,1297.44,1297.44,1297.44,1297.44,1297.44,1297.44]
[null,"HV (verano)","W/K",{"$f":"$Q$36","v":3243.6000000000004},{"$f":"$Q$36","v":3243.6000000000004},3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004]
[null,"As(Horitz) (Calefac)","m2",{"$f":"$K$39","v":0},{"$f":"$K$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Sur) (Calefac)","m2",{"$f":"$D$39","v":15.2775},{"$f":"$D$39","v":15.2775},15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775]
[null,"As (Sureste) (Calefac)","m2",{"$f":"$E$39","v":0},{"$f":"$E$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Este) (Calefac)","m2",{"$f":"$F$39","v":0},{"$f":"$F$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Norte) (Calefac)","m2",{"$f":"$G$39","v":15.2775},{"$f":"$G$39","v":15.2775},15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775]
[null,"As (Oeste) (Calefac)","m2",{"$f":"$H$39","v":0},{"$f":"$H$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Suroeste) (Calefac)","m2",{"$f":"$I$39","v":0},{"$f":"$I$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As(Horitz) (Refrig)","m2",{"$f":"$J$40","v":0.27288000000000001},{"$f":"$J$40","v":0.27288000000000001},0.27288000000000001,0.27288000000000001,0.27288000000000001,0.27288000000000001,0.27288000000000001,0.27288000000000001,0.27288000000000001,0.27288000000000001,0.27288000000000001,0.27288000000000001]
[null,"As (Sur) (Refrig)","m2",{"$f":"$D$40","v":13.260869999999999},{"$f":"$D$40","v":13.260869999999999},13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999]
[null,"As (Sureste) (Refrig)","m2",{"$f":"$E$40","v":0},{"$f":"$E$40","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Este) (Refrig)","m2",{"$f":"$F$40","v":0},{"$f":"$F$40","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Norte) (refrig)","m2",{"$f":"$G$40","v":13.260869999999999},{"$f":"$G$40","v":13.260869999999999},13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999,13.260869999999999]
[null,"As (Oeste) (refrig)","m2",{"$f":"$H$40","v":0},{"$f":"$H$40","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Suroeste) (refrig)","m2",{"$f":"$I$40","v":0},{"$f":"$I$40","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"gi","W",{"$f":"$D$10*$D$3","v":1335.6000000000001},{"$f":"$D$10*$D$3","v":1335.6000000000001},1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001]
[null,"C","J/K",{"$f":"$D$3*$D$4","v":127200},{"$f":"$D$3*$D$4","v":127200},127200,127200,127200,127200,127200,127200,127200,127200,127200,127200]
["CALCULO","Ql (Calef)","(HT+HV)(qi-qe)dias 24/1000",{"$f":"IF(D48-D47=0,0.01,(D57+D58)*(D48-D47)*24*D46/1000)","v":15179.980573824001},{"$f":"IF(E48-E47=0,0.01,(E57+E58)*(E48-E47)*24*E46/1000)","v":11512.024220928002},10454.137564992003,6790.8008044800008,2148.1104585600001,-1247.289943679998,-5871.5019200640027,-6587.5387395840035,-2494.5798873600015,1718.4883668479993,8453.85406272,12029.418567936002]
[null,"Ql (Refrig)","(HT+HV)(qi-qe)dias 24/1000",{"$f":"IF(D49-D47=0,0.01,(D57+D59)*(D49-D47)*D46*24/1000)","v":50688.293551104005},{"$f":"IF(E49-E47=0,0.01,(E57+E59)*(E49-E47)*E46*24/1000)","v":41360.755661568001},41184.238510272007,33166.643690880002,24480.141771840001,17001.388782720001,8352.0483692159978,6912.040029695997,14492.98715904,23616.136768127999,36511.179189119997,{"$f":"IF(O49-O47=0,0.01,(O57+O59)*(O49-O47)*O46*24/1000)","v":44352.256857216002}]
[null,"Qi","gi*24*dias/1000",{"$f":"D74*24*D46/1000","v":993.68640000000005},897.52320000000009,993.68640000000005,961.63199999999995,993.68640000000005,961.63199999999995,993.68640000000005,993.68640000000005,961.63199999999995,993.68640000000005,961.63199999999995,993.68640000000005]
[null,"Qs(horitz) (Calefac)","As*Is*dias/1000",{"$f":"D50*D60*D46/1000","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Sur) (Calefac)","As*Is*dias/1000",{"$f":"D46*D51*D61/1000","v":1913.5289096052193},1594.9293772827118,1592.453971488615,1333.5588358345817,1209.668405014821,1162.0056913892979,1287.1176997083994,1401.7245312308207,1449.4862880019346,1686.2898471500168,1616.5830965212442,1463.6100922160392]
[null,"Qs(Sureste) (Calefac)","As*Is*dias/1000",{"$f":"D46*D52*D62/1000","v":0},{"$f":"E46*E52*E62/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Este) (Calefac)","As*Is*dias/1000",{"$f":"D46*D53*D63/1000","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Norte) (Calefac)","As*Is*dias/1000",{"$f":"D46*D54*D64/1000","v":283.29111551587209},351.33192578530895,532.02877855105487,668.65637246890185,806.0298896460165,840.33996838587302,850.57333353965714,747.97186349486424,569.97713659661599,429.41359154912743,292.40738639897273,242.2783783826155]
[null,"Qs(Oeste) (Calefac)","As*Is*dias/1000",{"$f":"D46*D55*D65/1000","v":0},{"$f":"E46*E55*E65/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Suroeste) (Calefac)","As*Is*dias/1000",{"$f":"D46*D56*D66/1000","v":0},{"$f":"E46*E56*E66/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs (Calefac)","S Qs(i)",{"$f":"SUM(D79:D85)","v":2196.8200251210915},{"$f":"SUM(E79:E85)","v":1946.2613030680209},2124.48275003967,2002.2152083034835,2015.6982946608375,2002.345659775171,2137.6910332480566,2149.696394725685,2019.4634245985505,2115.7034386991445,1908.9904829202169,1705.8884705986547]
[null,"Qs(horitz) (Refrig)","As*Is*dias/1000",{"$f":"D67*D50*D46/1000","v":18.3824854},21.576318400000002,31.6729542,39.340200000000003,46.272261600000007,50.448689999999999,54.529458800000008,46.953703599999997,33.884874000000003,25.946491600000002,17.6235,13.9014168]
[null,"Qs(Sur) (Refrig)","As*Is*dias/1000",{"$f":"D51*D46*D68/1000","v":1660.9430935373302},1384.3986994813936,1382.2500472521176,1157.5290695044168,1049.9921755528646,1008.6209401259105,1117.2181633468906,1216.6968931083522,1258.1540979856791,1463.6995873262147,1403.1941277804399,1270.413560043522]
[null,"Qs(Sureste) (Refrig)","As*Is*dias/1000",{"$f":"D46*D52*D69/1000","v":0},{"$f":"E46*E52*E69/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Este) (Refrig)","As*Is*dias/1000",{"$f":"D70*D53*D46/1000","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Norte) (Refrig)","As*Is*dias/1000",{"$f":"D71*D54*D46/1000","v":245.89668826777694},304.95611158164814,461.80097978231566,580.3937313030068,699.63394421274222,729.41509255893777,738.29765351242224,649.23957751354203,494.74015456586267,372.73099746464254,253.80961139430829,210.29763243611026]
[null,"Qs(Oeste) (Refrig)","As*Is*dias/1000",{"$f":"D72*D55*D46/1000","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Suroeste) (Refrig)","As*Is*dias/1000",{"$f":"D46*D56*D73/1000","v":0},{"$f":"E46*E56*E73/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs (Refrig)","S Qs(i)",{"$f":"SUM(D87:D93)","v":1925.2222672051071},{"$f":"SUM(E87:E93)","v":1710.9311294630418},1875.7239812344333,1777.2630008074239,1795.8983813656068,1788.4847226848483,1910.0452756593127,1912.8901742218941,1786.7791265515418,1862.3770763908572,1674.6272391747482,1494.6126092796324]
[null,"Qi+Qs (Calefac)","Qi+Qs",{"$f":"D78+D86","v":3190.5064251210915},{"$f":"E78+E86","v":2843.784503068021},3118.1691500396701,2963.8472083034835,3009.3846946608373,{"$f":"I78+I86","v":2963.9776597751711},{"$f":"J78+J86","v":3131.3774332480566},{"$f":"K78+K86","v":3143.382794725685},{"$f":"L78+L86","v":2981.0954245985504},3109.3898386991445,2870.622482920217,2699.5748705986548]
[null,"Qi+Qs (Refrig)","Qi+Qs",{"$f":"D94+D78","v":2918.9086672051071},{"$f":"E94+E78","v":2608.4543294630421},2869.4103812344333,2738.8950008074239,2789.5847813656069,2750.1167226848484,2903.7316756593127,2906.5765742218941,2748.4111265515417,2856.0634763908574,2636.259239174748,2488.2990092796326]
[null,"g (calefac)","(Qs+Qi)/Ql",{"$f":"IF(D76=0,1,ABS(D95/D76))","v":0.21017855784497677},{"$f":"IF(E76=0,1,ABS(E95/E76))","v":0.24702732104213546},0.29827129504030547,0.43645032355362062,1.4009450411028668,2.376334127276186,0.53331796120981645,0.47717105264783405,1.195029046655798,1.8093749708659919,0.33956376128837545,0.22441441000268109]
[null,"l (Refrig)","(Qs+Qi)/Ql",{"$f":"D96/D77","v":5.7585459338106527E-2},{"$f":"E96/E77","v":6.3065925361871264E-2},6.9672536995403142E-2,8.2579805974173734E-2,0.11395296675015675,0.16175835738078248,0.34766700901324932,0.42050922184108508,0.18963731192138816,0.12093694681872608,7.2204165894492106E-2,5.6103097916533479E-2]
[null,"t (calefaccion)","C/(HT+HV)/60/60",{"$f":"D75/(D57+D58)/60/60","v":1.8356597931390127E-2},{"$f":"E75/(E57+E58)/60/60","v":1.8356597931390127E-2},1.8356597931390127E-2,1.8356597931390127E-2,1.8356597931390127E-2,{"$f":"I75/(I57+I58)/60/60","v":1.8356597931390127E-2},{"$f":"J75/(J57+J58)/60/60","v":1.8356597931390127E-2},{"$f":"K75/(K57+K58)/60/60","v":1.8356597931390127E-2},{"$f":"L75/(L57+L58)/60/60","v":1.8356597931390127E-2},1.8356597931390127E-2,1.8356597931390127E-2,1.8356597931390127E-2]
[null,"t (refrigeracion)","C/(HT+HV)/60/60",{"$f":"D75/(D57+D59)/60/60","v":9.1277249160802119E-3},{"$f":"E75/(E57+E59)/60/60","v":9.1277249160802119E-3},9.1277249160802119E-3,9.1277249160802119E-3,9.1277249160802119E-3,9.1277249160802119E-3,9.1277249160802119E-3,9.1277249160802119E-3,9.1277249160802119E-3,9.1277249160802119E-3,9.1277249160802119E-3,9.1277249160802119E-3]
[null,"a (Calef)","1+t/15",{"$f":"1+D99/15","v":1.0012237731954261},{"$f":"1+E99/15","v":1.0012237731954261},1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261]
[null,"a (Refig)","1+t/15",{"$f":"1+D100/15","v":1.0006085149944053},{"$f":"1+E99/15","v":1.0012237731954261},1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261,1.0012237731954261]
[null,"h (Calef)","(1-ga)/(1-g(a+1))",{"$f":"IF(D76=1,D101/(D101+1),(1-D97^D101)/(1-D97^(D101+1)))","v":0.82667082073837039},{"$f":"IF(E76=1,E101/(E101+1),(1-E97^E101)/(1-E97^(E101+1)))","v":0.80226769633211348},0.77062804694482834,0.69654105261246702,0.41675259049370655,0.29633952787120671,0.65255413329036904,0.67734811499017655,0.45585195629915626,0.35615646274291735,0.74689009595052847,0.81706952370845609]
[null,"h (Refrig)","(1-la)/(1-l(a+1))",{"$f":"IF(D98<0,1,IF(D98=1,D102/(D102+1),(1-D98^(-D102))/(1-D98^(-(D102+1)))))","v":5.445539457287122E-2},{"$f":"IF(E98<0,1,IF(E98=1,E102/(E102+1),(1-E98^(-E102))/(1-E98^(-(E102+1)))))","v":5.9337248798724131E-2},6.5149296506074608E-2,7.6299899055621415E-2,0.10232737954552941,0.13928730048252619,0.25810873653532868,0.29618729322105464,0.15947140284403041,0.10792334741277745,6.7357502587700221E-2,5.3133267934004587E-2]
[]
[]
[null,"Demanda"]
["Calefaccion",{"$f":"A43","v":52189.071747754591}]
["Refrigeracion",{"$f":"A44","v":2426.5464783744692}]

{"sheet":"Calculo(inicial)","index":5,"n_rows":109,"n_cols":17,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Emplazamiento",{"$f":"'Calculo(rehabilitado)'!C2","v":6}]
[null,"Sup util","m2",{"$f":"DATOS!C6","v":636}]
[null,"Inercia termica","kJ/m2·K",200,{"$f":"IF(D4<=100,\"muy baja\",IF(D4<=150,\"baja\",IF(D4<400,\"alta\",IF(D4<=400,\"alta\",\"muy alta\"))))","v":"alta"}]
[null,"Renovación de aire","n (invierno)",{"$f":"DATOS!C31","v":2}]
[null,null,"n (verano)",5]
[null,"Altura plantas","m",{"$f":"DATOS!C7","v":3}]
["T.Consigna","Calefacción","ºC",19]
[null,"Refrigeración","ºC",26]
[null,"Ganacias Internas","W/m2",2.1]
[null,null,null,"EXTERIOR",null,null,null,null,null,null,null,"INTERIORES"]
[null,null,null,"Fachadas",null,null,null,null,null,"Cubiertas","Exterior"]
[null,null,null,"F.Sur","F.SurEste","F.Este","F.Norte","F.Oeste","F.SurOeste","Cubiertas","No soleados","A.Vivendas","Z.Comunes","A.Locales","Techos","Suelos","Total"]
["Geometria","Sup","m2",{"$f":"DATOS!C10","v":145.5},{"$f":"DATOS!D10","v":0},{"$f":"DATOS!E10","v":0},{"$f":"DATOS!F10","v":145.5},{"$f":"DATOS!G10","v":0},{"$f":"DATOS!H10","v":0},{"$f":"DATOS!I10","v":15.16},{"$f":"DATOS!J10","v":297.60000000000002}]
[null,"% ventanas","(--) (0 a 1)",{"$f":"DATOS!C11/100","v":0.2},{"$f":"DATOS!D11/100","v":0},{"$f":"DATOS!E11/100","v":0},{"$f":"DATOS!F11/100","v":0.2},{"$f":"DATOS!G11/100","v":0},{"$f":"DATOS!H11/100","v":0},0,{"$f":"DATOS!J11/100","v":0.2}]
["Carac Constructivas","U opac","W/m2·K",{"$f":"DATOS!C27","v":1.8},{"$f":"DATOS!D27","v":1.8},{"$f":"DATOS!E27","v":1.8},{"$f":"DATOS!F27","v":1.8},{"$f":"DATOS!G27","v":1.8},{"$f":"DATOS!H27","v":1.8},{"$f":"DATOS!I27","v":2.5},{"$f":"DATOS!J27","v":1.8}]
[null,"U ventanas","W/m2·K",{"$f":"DATOS!C28","v":5.7},{"$f":"DATOS!D28","v":5.7},{"$f":"DATOS!E28","v":5.7},{"$f":"DATOS!F28","v":5.7},{"$f":"DATOS!G28","v":5.7},{"$f":"DATOS!H28","v":5.7},null,{"$f":"DATOS!J28","v":5.7}]
[null,"Transp. Ventana","(--) (0 a 1)",{"$f":"DATOS!C29","v":0.75},{"$f":"DATOS!D29","v":0.75},{"$f":"DATOS!E29","v":0.75},{"$f":"DATOS!F29","v":0.75},{"$f":"DATOS!G29","v":0.75},{"$f":"DATOS!H29","v":0.75},null,{"$f":"DATOS!J29","v":0.75}]
[null,"Coef.Exposición t","(--) (0 a 1)",1,1,1,1,1,1,1,1]
["Sombras","F.Sombra Horizonte (Fsh)","(--) (0 a 1)",1,1,1,1,1,1,1,1]
[null,"F.Carpinteria (Fc)","(--) (0 a 1)",0.7,0.7,0.7,0.7,0.7,0.7,null,0.7]
[null,"F.Persianas (Calefacc.) (Fp.Cal)","(--) (0 a 1)",1,1,1,1,1,1,null,1]
[null,"F.Persianas (Refrig) (Fp.Refrig)","(--) (0 a 1)",0.7,0.7,0.7,0.7,0.7,0.7,null,0.7]
[null,"F.Cornisas (Fsc)","(--) (0 a 1)",1,1,1,1,1,1,null,1]
[null,"F.Pantallas (Fsp)","(--) (0 a 1)",1,1,1,1,1,1,null,1]
["Frentes forjado","Y F.forjado Cubierta","W/m·K"]
[null,"L F.forjado Cubierta","m"]
[null,"Y Fforjaado Intermedio","W/m·K"]
[null,"L F.forjado Intermedio","m"]
[null,"Y Fforjado Inferior","W/m·K"]
[null,"L F.forjado Inferior","m"]
[null,"Factor PT","(--)",{"$f":"DATOS!C30","v":1.3}]
["U medio","(Sf*Uf+Sv*Uv)/S","W/m2·K",{"$f":"IF(D14=0,0,(D14*(1-D15)*D16+D14*D15*D17)/D14)","v":2.58},{"$f":"IF(E14=0,0,(E14*(1-E15)*E16+E14*E15*E17)/E14)","v":0},{"$f":"IF(F14=0,0,(F14*(1-F15)*F16+F14*F15*F17)/F14)","v":0},2.58,0,{"$f":"IF(I14=0,0,(I14*(1-I15)*I16+I14*I15*I17)/I14)","v":0},2.5,2.5800000000000005,0,0,0,{"$f":"IF(O14=0,0,(O14*(1-O15)*O16+O14*O15*O17)/O14)","v":0},{"$f":"IF(P14=0,0,(P14*(1-P15)*P16+P14*P15*P17)/P14)","v":0}]
["Transmission Termica","S*U*t +Y*l","W/K",{"$f":"D14*D33*D19*$D$32","v":488.00700000000001},0,0,488.00700000000001,0,0,{"$f":"J14*J33*J19","v":37.9},998.15040000000033,{"$f":"L14*L33*L19+L26*L27*L19+L28*L29*L19+L30*L31*L19","v":0},{"$f":"M14*M33*M19+M26*M27*M19+M28*M29*M19+M30*M31*M19","v":0},{"$f":"N14*N33*N19+N26*N27*N19+N28*N29*N19+N30*N31*N19","v":0},{"$f":"O14*O33*O19+O26*O27*O19+O28*O29*O19+O30*O31*O19","v":0},{"$f":"P14*P33*P19+P26*P27*P19+P28*P29*P19+P30*P31*P19","v":0},{"$f":"SUM(D34:P34)","v":2012.0644000000002}]
["Transmissión Ventilacion","n(invierno)*V*0,34","W/K",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.34*D3*D7*D5","v":1297.44}]
[null,"n(verano)*V*0,34","W/K",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.34*D3*D7*D6","v":3243.6000000000004}]
["F. Sombras (Calefac.)","Fsh*Fc*Fp.Cal*Fsc*Fsp","(--) (0 a 1)",{"$f":"D20*D21*D22*D24*D25","v":0.7},{"$f":"E20*E21*E22*E24*E25","v":0.7},0.7,0.7,0.7,{"$f":"I20*I21*I22*I24*I25","v":0.7},0]
["F. Sombras (Refrig.)","Fsh*Fc*Fp.Refr*Fsc*Fsp","(--) (0 a 1)",{"$f":"D20*D21*D23*D24*D25","v":0.48999999999999994},{"$f":"E20*E21*E23*E24*E25","v":0.48999999999999994},0.48999999999999994,0.48999999999999994,0.48999999999999994,{"$f":"I20*I21*I23*I24*I25","v":0.48999999999999994},0]
["Area solar (Calefac)","Fs.Cal*tr*S","m2",{"$f":"D37*D14*D15*D18","v":15.2775},0,0,15.2775,0,0,0,0]
["Area solar (Refrig.)","Fs.Refr*tr*S","m2",{"$f":"D38*D14*D15*D18+0.045*(1-D15)*D14*D16*D20","v":20.12265},0,0,20.12265,0,0,1.7055,0]
[null,null,null,"F.Sur","F.Sureste","F.Este","F.Norte","F.Oeste","F.Suroeste","Cubierta","Suelo"]
["TOTAL KWh/año",null,null,"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
[{"$f":"SUM(D43:O43)","v":99097.306186532238},"Ql-(Qi+Qs)*h","CALEFACCION",{"$f":"IF(D76-D103*D95<0,0,D76-D103*D95)","v":23256.570870684438},17306.443653851227,15316.782067465048,9311.4945185557663,2034.5743700687701,0,0,0,0,1439.1441151197441,12137.580544972865,18294.716045814366]
[{"$f":"SUM(D44:O44)","v":3557.3862560516923},"Ql*h-(Q+Qs)","REFRIGERACION",{"$f":"IF(D43>0,0,IF(D96-D104*D77<0,0,D96-D104*D77))","v":0},{"$f":"IF(E43>0,0,IF(E96-E104*E77<0,0,E96-E104*E77))","v":0},0,0,0,566.79694325926584,1111.0203691192105,1255.3093938564757,624.25954981674022,0,0,0]
[null,null,null,"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
["Clima","Dias",null,31,28,31,30,31,30,31,31,30,31,30,31]
[null,"qe","ºC",{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,1)","v":8.4},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,2)","v":10.1},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,3)","v":11.7},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,4)","v":14.1},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,5)","v":17.5},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,6)","v":19.899999999999999},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,7)","v":23.1},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,8)","v":23.6},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,9)","v":20.8},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,10)","v":17.8},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,11)","v":12.9},{"$f":"INDEX(LOCALIDADES!$B$3:$M$59,$C$2,12)","v":10.6}]
[null,"qi (Calef)","ºC",{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},{"$f":"$D$8","v":19},19,19,19,19,19,19]
[null,"qi (Refig)","ºC",{"$f":"$D$9","v":26},{"$f":"$D$9","v":26},26,26,26,26,26,26,26,26,26,26]
[null,"Is(Horitz)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,1)","v":2173.0555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,2)","v":2823.8888888888887},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,3)","v":3744.1666666666665},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,4)","v":4805.5555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,5)","v":5470},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,6)","v":6162.5},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,7)","v":6446.1111111111113},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,8)","v":5550.5555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,9)","v":4139.166666666667},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,10)","v":3067.2222222222222},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,11)","v":2152.7777777777778},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,12)","v":1643.3333333333333}]
[null,"Is(Sur)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,1)","v":4040.3691061707218},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,2)","v":3728.4741269437122},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,3)","v":3362.4272918504757},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,4)","v":2909.6358170175786},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,5)","v":2554.1850075006382},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,6)","v":2535.3312417810457},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,7)","v":2717.717283393562},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,8)","v":2959.7067820182979},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,9)","v":3162.5730387867443},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,10)","v":3560.559429373825},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,11)","v":3527.1545224922147},{"$f":"INDEX(LOCALIDADES!$Z$3:$AK$59,$C$2,12)","v":3090.3766179782397}]
[null,"Is(Sureste)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,1)","v":3090.3766179782397},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,2)","v":3145.4842403825851},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,3)","v":3142.0314520210009},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,4)","v":3235.636022202782},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,5)","v":3311.4023848290753},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,6)","v":3196.9073323799357},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,7)","v":3326.2811359241805},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,8)","v":3586.4704491103903},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,9)","v":3575.5821246783912},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,10)","v":3263.0001332126603},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,11)","v":3119.0108208805896},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,12)","v":2810.1284790601994}]
[null,"Is(Este)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,1)","v":1773.5662653947948},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,2)","v":2137.5158324169529},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,3)","v":2648.4005484233844},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,4)","v":3209.2665258021671},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,5)","v":3503.8089965265822},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,6)","v":3886.9636073610145},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,7)","v":4113.6491687193538},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,8)","v":3662.6558364110774},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,9)","v":2860.3442204251701},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,10)","v":2264.7646433878776},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,11)","v":1697.211285803276},{"$f":"INDEX(LOCALIDADES!$AX$3:$BI$59,$C$2,12)","v":1327.2171566373263}]
[null,"Is(Norte)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,1)","v":598.16220462491663},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,2)","v":821.31034384203872},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,3)","v":1123.3656464040096},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,4)","v":1458.9131565349956},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,5)","v":1701.9122357800402},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,6)","v":1833.5023583393292},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,7)","v":1795.9646191471902},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,8)","v":1579.3241452375446},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,9)","v":1243.6090909215425},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,10)","v":906.6962094776261},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,11)","v":637.99135198597662},{"$f":"INDEX(LOCALIDADES!$BJ$3:$BU$59,$C$2,12)","v":511.56482151723338}]
[null,"Is(Oeste)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,1)","v":2173.0555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,2)","v":2823.8888888888887},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,3)","v":3744.1666666666665},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,4)","v":4805.5555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,5)","v":5470},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,6)","v":6162.5},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,7)","v":6446.1111111111113},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,8)","v":5550.5555555555557},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,9)","v":4139.166666666667},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,10)","v":3067.2222222222222},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,11)","v":2152.7777777777778},{"$f":"INDEX(LOCALIDADES!$N$3:$Y$59,$C$2,12)","v":1643.3333333333333}]
[null,"Is(Suroeste)","W/m2 dia",{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,1)","v":3090.3766179782397},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,2)","v":3145.4842403825851},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,3)","v":3142.0314520210009},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,4)","v":3235.636022202782},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,5)","v":3311.4023848290753},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,6)","v":3196.9073323799357},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,7)","v":3326.2811359241805},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,8)","v":3586.4704491103903},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,9)","v":3575.5821246783912},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,10)","v":3263.0001332126603},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,11)","v":3119.0108208805896},{"$f":"INDEX(LOCALIDADES!$AK$3:$AW$59,$C$2,12)","v":2810.1284790601994}]
["EDIFICIO","HT","W/K",{"$f":"$Q$34","v":2012.0644000000002},{"$f":"$Q$34","v":2012.0644000000002},2012.0644000000002,2012.0644000000002,2012.0644000000002,2012.0644000000002,2012.0644000000002,2012.0644000000002,2012.0644000000002,2012.0644000000002,2012.0644000000002,2012.0644000000002]
[null,"HV (Invierno)","W/K",{"$f":"$Q$35","v":1297.44},{"$f":"$Q$35","v":1297.44},1297.44,1297.44,1297.44,1297.44,1297.44,1297.44,1297.44,1297.44,1297.44,1297.44]
[null,"HV (verano)","W/K",{"$f":"$Q$36","v":3243.6000000000004},{"$f":"$Q$36","v":3243.6000000000004},3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004,3243.6000000000004]
[null,"As(Horitz) (Calefac)","m2",{"$f":"$K$39","v":0},{"$f":"$K$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Sur) (Calefac)","m2",{"$f":"$D$39","v":15.2775},{"$f":"$D$39","v":15.2775},15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775]
[null,"As (Sureste) (Calefac)","m2",{"$f":"$E$39","v":0},{"$f":"$E$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Este) (Calefac)","m2",{"$f":"$F$39","v":0},{"$f":"$F$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Norte) (Calefac)","m2",{"$f":"$G$39","v":15.2775},{"$f":"$G$39","v":15.2775},15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775,15.2775]
[null,"As (Oeste) (Calefac)","m2",{"$f":"$H$39","v":0},{"$f":"$H$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Suroeste) (Calefac)","m2",{"$f":"$I$39","v":0},{"$f":"$I$39","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As(Horitz) (Refrig)","m2",{"$f":"$J$40","v":1.7055},{"$f":"$J$40","v":1.7055},1.7055,1.7055,1.7055,1.7055,1.7055,1.7055,1.7055,1.7055,1.7055,1.7055]
[null,"As (Sur) (Refrig)","m2",{"$f":"$D$40","v":20.12265},{"$f":"$D$40","v":20.12265},20.12265,20.12265,20.12265,20.12265,20.12265,20.12265,20.12265,20.12265,20.12265,20.12265]
[null,"As (Sureste) (Refrig)","m2",{"$f":"$E$40","v":0},{"$f":"$E$40","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Este) (Refrig)","m2",{"$f":"$F$40","v":0},{"$f":"$F$40","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Norte) (refrig)","m2",{"$f":"$G$40","v":20.12265},{"$f":"$G$40","v":20.12265},20.12265,20.12265,20.12265,20.12265,20.12265,20.12265,20.12265,20.12265,20.12265,20.12265]
[null,"As (Oeste) (refrig)","m2",{"$f":"$H$40","v":0},{"$f":"$H$40","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"As (Suroeste) (refrig)","m2",{"$f":"$I$40","v":0},{"$f":"$I$40","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"gi","W",{"$f":"$D$10*$D$3","v":1335.6000000000001},{"$f":"$D$10*$D$3","v":1335.6000000000001},1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001,1335.6000000000001]
[null,"C","J/K",{"$f":"$D$3*$D$4","v":127200},{"$f":"$D$3*$D$4","v":127200},127200,127200,127200,127200,127200,127200,127200,127200,127200,127200]
["CALCULO","Ql (Calef)","(HT+HV)(qi-qe)dias 24/1000",{"$f":"IF(D48-D47=0,0.01,(D57+D58)*(D48-D47)*24*D46/1000)","v":26100.075500160005},{"$f":"IF(E48-E47=0,0.01,(E57+E58)*(E48-E47)*24*E46/1000)","v":19793.483915520002},17974.580297280001,11675.931523200001,3693.4069104000005,-2144.5588511999968,-10095.312221760003,-11326.447858560003,-4289.1177024000026,2954.7255283199984,14535.3433248,20683.078698240006]
[null,"Ql (Refrig)","(HT+HV)(qi-qe)dias 24/1000",{"$f":"IF(D49-D47=0,0.01,(D57+D59)*(D49-D47)*D46*24/1000)","v":68819.771919360006},{"$f":"IF(E49-E47=0,0.01,(E57+E59)*(E49-E47)*E46*24/1000)","v":56155.722981120009},55916.064684480007,45030.532579200008,33236.8216656,23082.878044800007,11339.621509439996,9384.5143526399952,19677.207513599998,32063.757371520001,49571.426620800004,{"$f":"IF(O49-O47=0,0.01,(O57+O59)*(O49-O47)*O46*24/1000)","v":60217.300429440009}]
[null,"Qi","gi*24*dias/1000",{"$f":"D74*24*D46/1000","v":993.68640000000005},897.52320000000009,993.68640000000005,961.63199999999995,993.68640000000005,961.63199999999995,993.68640000000005,993.68640000000005,961.63199999999995,993.68640000000005,961.63199999999995,993.68640000000005]
[null,"Qs(horitz) (Calefac)","As*Is*dias/1000",{"$f":"D50*D60*D46/1000","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Sur) (Calefac)","As*Is*dias/1000",{"$f":"D46*D51*D61/1000","v":1913.5289096052193},1594.9293772827118,1592.453971488615,1333.5588358345817,1209.668405014821,1162.0056913892979,1287.1176997083994,1401.7245312308207,1449.4862880019346,1686.2898471500168,1616.5830965212442,1463.6100922160392]
[null,"Qs(Sureste) (Calefac)","As*Is*dias/1000",{"$f":"D46*D52*D62/1000","v":0},{"$f":"E46*E52*E62/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Este) (Calefac)","As*Is*dias/1000",{"$f":"D46*D53*D63/1000","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Norte) (Calefac)","As*Is*dias/1000",{"$f":"D46*D54*D64/1000","v":283.29111551587209},351.33192578530895,532.02877855105487,668.65637246890185,806.0298896460165,840.33996838587302,850.57333353965714,747.97186349486424,569.97713659661599,429.41359154912743,292.40738639897273,242.2783783826155]
[null,"Qs(Oeste) (Calefac)","As*Is*dias/1000",{"$f":"D46*D55*D65/1000","v":0},{"$f":"E46*E55*E65/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Suroeste) (Calefac)","As*Is*dias/1000",{"$f":"D46*D56*D66/1000","v":0},{"$f":"E46*E56*E66/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs (Calefac)","S Qs(i)",{"$f":"SUM(D79:D85)","v":2196.8200251210915},{"$f":"SUM(E79:E85)","v":1946.2613030680209},2124.48275003967,2002.2152083034835,2015.6982946608375,2002.345659775171,2137.6910332480566,2149.696394725685,2019.4634245985505,2115.7034386991445,1908.9904829202169,1705.8884705986547]
[null,"Qs(horitz) (Refrig)","As*Is*dias/1000",{"$f":"D67*D50*D46/1000","v":114.89053375},134.85199,197.95596375,245.87625,289.20163500000001,315.30431249999998,340.80911750000001,293.46064749999999,211.78046250000003,162.1655725,110.14687499999999,86.883854999999997]
[null,"Qs(Sur) (Refrig)","As*Is*dias/1000",{"$f":"D51*D46*D68/1000","v":2520.3909352228743},2100.7498369352293,2097.4893738750043,1756.4874951992633,1593.3060991766645,1530.5274963727607,1695.3178844730633,1846.2714539925955,1909.1805107682624,2221.0846272461654,2129.2708785608388,1927.7835786045546]
[null,"Qs(Sureste) (Refrig)","As*Is*dias/1000",{"$f":"D46*D52*D69/1000","v":0},{"$f":"E46*E52*E69/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Este) (Refrig)","As*Is*dias/1000",{"$f":"D70*D53*D46/1000","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Norte) (Refrig)","As*Is*dias/1000",{"$f":"D71*D54*D46/1000","v":373.13486929376296},462.75433653436403,700.75790546296093,880.71596488046782,1061.656511790896,1106.8477869311071,1120.3265907479486,985.18579734609261,750.74131420297124,565.59904486899347,385.14230037121837,319.11523552681643]
[null,"Qs(Oeste) (Refrig)","As*Is*dias/1000",{"$f":"D72*D55*D46/1000","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Qs(Suroeste) (Refrig)","As*Is*dias/1000",{"$f":"D46*D56*D73/1000","v":0},{"$f":"E46*E56*E73/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Qs (Refrig)","S Qs(i)",{"$f":"SUM(D87:D93)","v":3008.4163382666375},{"$f":"SUM(E87:E93)","v":2698.3561634695934},2996.2032430879653,2883.0797100797313,2944.1642459675604,2952.6795958038674,3156.4535927210118,3124.9178988386884,2871.7022874712338,2948.849244615159,2624.5600539320571,2333.7826691313712]
[null,"Qi+Qs (Calefac)","Qi+Qs",{"$f":"D78+D86","v":3190.5064251210915},{"$f":"E78+E86","v":2843.784503068021},3118.1691500396701,2963.8472083034835,3009.3846946608373,{"$f":"I78+I86","v":2963.9776597751711},{"$f":"J78+J86","v":3131.3774332480566},{"$f":"K78+K86","v":3143.382794725685},{"$f":"L78+L86","v":2981.0954245985504},3109.3898386991445,2870.622482920217,2699.5748705986548]
[null,"Qi+Qs (Refrig)","Qi+Qs",{"$f":"D94+D78","v":4002.1027382666375},{"$f":"E94+E78","v":3595.8793634695935},3989.8896430879654,3844.7117100797313,3937.8506459675605,3914.3115958038675,4150.1399927210114,4118.6042988386889,3833.3342874712339,3942.5356446151591,3586.1920539320572,3327.4690691313713]
[null,"g (calefac)","(Qs+Qi)/Ql",{"$f":"IF(D76=0,1,ABS(D95/D76))","v":0.12224127187300789},{"$f":"IF(E76=0,1,ABS(E95/E76))","v":0.14367276196578105},0.17347660409692717,0.25384246236921981,0.81479911844723263,1.3820920130574477,0.31018133609562959,0.27752591403579918,0.69503698229835464,1.0523447301269588,0.19749258196209241,0.13052093984578664]
[null,"l (Refrig)","(Qs+Qi)/Ql",{"$f":"D96/D77","v":5.8153385671724199E-2},{"$f":"E96/E77","v":6.403406763507534E-2},7.1354979389230772E-2,8.5380107448598933E-2,0.11847855627071655,0.16957641019490044,0.36598575968925484,0.43887239595728977,0.19481088893440832,0.1229592526831256,7.2343934770424848E-2,5.5257692480425183E-2]
[null,"t (calefaccion)","C/(HT+HV)/60/60",{"$f":"D75/(D57+D58)/60/60","v":1.0676321606743696E-2},{"$f":"E75/(E57+E58)/60/60","v":1.0676321606743696E-2},1.0676321606743696E-2,1.0676321606743696E-2,1.0676321606743696E-2,{"$f":"I75/(I57+I58)/60/60","v":1.0676321606743696E-2},{"$f":"J75/(J57+J58)/60/60","v":1.0676321606743696E-2},{"$f":"K75/(K57+K58)/60/60","v":1.0676321606743696E-2},{"$f":"L75/(L57+L58)/60/60","v":1.0676321606743696E-2},1.0676321606743696E-2,1.0676321606743696E-2,1.0676321606743696E-2]
[null,"t (refrigeracion)","C/(HT+HV)/60/60",{"$f":"D75/(D57+D59)/60/60","v":6.722905163680795E-3},{"$f":"E75/(E57+E59)/60/60","v":6.722905163680795E-3},6.722905163680795E-3,6.722905163680795E-3,6.722905163680795E-3,6.722905163680795E-3,6.722905163680795E-3,6.722905163680795E-3,6.722905163680795E-3,6.722905163680795E-3,6.722905163680795E-3,6.722905163680795E-3]
[null,"a (Calef)","1+t/15",{"$f":"1+D99/15","v":1.0007117547737829},{"$f":"1+E99/15","v":1.0007117547737829},1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829]
[null,"a (Refig)","1+t/15",{"$f":"1+D100/15","v":1.0004481936775786},{"$f":"1+E99/15","v":1.0007117547737829},1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829,1.0007117547737829]
[null,"h (Calef)","(1-ga)/(1-g(a+1))",{"$f":"IF(D76=1,D101/(D101+1),(1-D97^D101)/(1-D97^(D101+1)))","v":0.89123927383021828},{"$f":"IF(E76=1,E101/(E101+1),(1-E97^E101)/(1-E97^(E101+1)))","v":0.87455299759374461},0.85235858028456835,0.79775941149059626,0.55121983682388054,0.41994583215868808,0.76347126640823537,0.78297760913939007,0.59016294536842129,0.48742084197275126,0.83527624899946673,0.88471806373571682]
[null,"h (Refrig)","(1-la)/(1-l(a+1))",{"$f":"IF(D98<0,1,IF(D98=1,D102/(D102+1),(1-D98^(-D102))/(1-D98^(-(D102+1)))))","v":5.49615112585288E-2},{"$f":"IF(E98<0,1,IF(E98=1,E102/(E102+1),(1-E98^(-E102))/(1-E98^(-(E102+1)))))","v":6.0188029282952908E-2},6.6611522864896966E-2,7.8675623676832951E-2,0.10594763147548353,0.14502154566894282,0.26800891203218713,0.30510847950024483,0.16308588174600111,0.1095161155984794,6.7472531766173377E-2,5.2370145114220987E-2]
[]
[]
[null,"Demanda"]
["Calefaccion",{"$f":"A43","v":99097.306186532238}]
["Refrigeracion",{"$f":"A44","v":3557.3862560516923}]

{"sheet":"LOCALIDADES","index":6,"n_rows":59,"n_cols":74,"rows_kept":59,"cut":false,"hidden":true,"merged":[[0,49,0,60],[0,61,0,72],[0,1,0,12],[0,13,0,24],[0,25,0,36],[0,37,0,48]]}
[null,"TEMPERATURAS MEDIAS MENSUALES",null,null,null,null,null,null,null,null,null,null,null,"RADIACION SOLAR HORIZONTAL W/m2 dia",null,null,null,null,null,null,null,null,null,null,null,"RADIACION SOLAR SUR W/m2 dia",null,null,null,null,null,null,null,null,null,null,null,"RADIACION SOLAR SUR-OESTE/ SUR -ESTE W/m2 dia",null,null,null,null,null,null,null,null,null,null,null,"RADIACION SOLAR OESTE/ESTE W/m2 dia",null,null,null,null,null,null,null,null,null,null,null,"RADIACION SOLAR Norte W/m2 dia"]
[null,"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre","Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre","Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre","Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre","Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre","Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre","Zona"]
["Albacete",4.2,5.6,9,11,15.3,21.6,24.1,23.8,17.8,13.7,8.6999999999999993,5.2,2010,2955,3433.333333333333,4876.666666666667,5454.4444444444443,6148.8888888888887,6636.6666666666661,5822.2222222222217,4536.1111111111113,3200,1882.7777777777778,1612.7777777777778,3201.3252387318466,3642.9968514266552,2852.7116614701717,2822.7380414398922,2445.3936838696973,2420.116611635443,2635.4660301858353,2944.6419548323033,3332.7710731940551,3494.7013194159499,2612.294147907844,2640.9846576759251,2545.6619424646888,3106.9432204656441,2784.3688571946077,3263.7000997698128,3114.6826634767303,3244.9758372084693,3592.618529357339,3649.8478148329391,3491.9272652990408,3097.9502974732677,2135.2255229253669,2082.5128913239678,1542.0152112951127,2173.9876262605776,2352.6414858313583,3209.6195858056726,3454.3794344126864,3838.7482701205131,4191.434748190356,3797.5576139133045,3098.2702042952646,2304.6060806777905,1393.478169363276,1234.0931216349288,627.27919731683244,871.16236886198908,1123.5072509994775,1481.8739721604002,1702.9208042038488,1826.674180240831,1798.4347851682719,1602.6461502947845,1296.346314430338,954.11165837700469,642.97606839467676,541.97181193222002,"D3"]
["Alicante",11,11.8,14,15.9,19,22.8,25.5,26.1,23.7,19.3,15.2,12,2594.4444444444443,3761.1111111111109,4512.2222222222217,5762.7777777777774,6588.8888888888887,7186.1111111111113,7246.6666666666661,6235,5145,3718.333333333333,2573.3333333333335,2083.8888888888887,4477.6198315034826,4948.1734123666047,3912.7029794223845,3268.1680113480411,2750.9350119675714,2591.3790202859113,2727.5581625418286,3073.7821372608028,3781.8394329395915,4173.1308421785998,3960.4025458937158,3706.9430760177097,3516.3528219339623,4178.2313467673212,3821.0025528281603,3871.8082142902872,3701.76446304007,3695.5025201768153,3860.873070590937,3881.5481957067118,3995.1707958048737,3687.073349029004,3182.1161578733577,2885.4225542457916,2045.3713430481625,2830.9361779235855,3156.6963392799926,3819.2620289618858,4192.6471376011104,4494.3701436217962,4576.3824302656949,4066.0627477578241,3533.2205615529465,2703.9821123022298,1971.1971237052283,1638.9995195436463,679.36317308056118,911.74218740277649,1207.9961802855248,1526.565487203552,1754.371406652032,1849.2789750916843,1796.1885471009905,1613.1218570881233,1323.4410729543638,993.96017744780727,722.88788037601978,602.67190697739454,"B4"]
["Almeria",11.7,11.8,14.1,16.100000000000001,18.399999999999999,22,24.7,25.3,23.4,19.399999999999999,15.6,12.8,2477.2222222222222,3373.333333333333,4650,5675.5555555555557,6501.1111111111113,6676.1111111111113,6815,6163.333333333333,4989.4444444444443,3827.2222222222222,2665.2900255903473,2128.3333333333335,3888.6153420724941,4030.2261940807689,3894.7178664000971,3112.2418789936273,2632.8511649665347,2409.8846922607531,2540.5125117998091,2939.4927984662299,3518.3114550262339,4124.1428350420647,3888.8888888868328,3527.9609792478877,3095.3290487908125,3459.43613394452,3840.4128736595576,3726.6767106145844,3590.2024363647961,3407.8439144938202,3588.0381859813433,3759.085996629954,3752.6257899956831,3674.569417474379,3149.8166608537135,2771.7967742469923,1881.9590760342783,2447.1740746627215,3213.1098869784682,3718.4353748255894,4102.5955335366989,4138.7054364748947,4262.8546407956956,3979.1156794574458,3371.9087309855072,2738.805301595241,1997.7501000943414,1627.5941176955905,706.55148432502779,937.60733373321273,1237.1031854184637,1538.782766198678,1754.5888846606358,1839.7302730418446,1797.3906268765879,1622.0214580498894,1342.898809846906,1027.2561806448646,758.68406988802337,634.81212373935614,"A4"]
["Avila",2.4,3.3,6.3,8.6999999999999993,12.2,16.399999999999999,20,19.8,16.3,10.6,6,3.2,1821.6666666666665,2831.6666666666665,3345.5555555555557,4516.666666666667,5476.666666666667,5898.8888888888887,6779.4444444444443,6295.5555555555557,4605,3076.6666666666665,1792.7777777777778,1390,3028.7093385914677,3663.407467634433,2881.9758629661801,2705.3567810288946,2531.1625818900793,2440.4781488744948,2775.5357597390448,3273.6257766087251,3533.3367871008459,3508.8454378927986,2633.8989884816879,2332.0734873445185,2394.9747706127482,3097.7695939069167,2787.764461857666,3070.8449692579757,3182.4885859740884,3179.4674493588063,3736.3029060329318,4051.911071970675,3664.7882820610916,3083.7573271390652,2133.7166964566559,1834.5128345996616,1423.8430585167389,2125.3800039878993,2323.9278703652776,2990.3648619438318,3498.3564859260027,3705.1470279329556,4323.6755071192911,4175.4106233744178,3199.8854351438031,2255.2380814242042,1357.1043354445362,1075.9329297908096,579.22348421074128,831.76611108976977,1093.3110018824673,1439.2567646952543,1703.0756761815528,1816.0870996342774,1801.3581698052076,1596.0132789498603,1276.5058203935585,916.56903700545922,606.94910809761643,486.05266390262386,"E1"]
["Badajoz",8.6,9.9,12.7,15.2,18,22.8,25.8,22.6,22.6,17.8,12.6,9.1,1821.1111111111111,2640,3652.7777777777778,4885.5555555555557,5907.2222222222217,6477.7777777777774,6640.5555555555557,5872.7777777777774,4582.2222222222217,3232.7777777777778,2186.6666666666665,1546.6666666666665,2755.4312280453487,3106.3819384977032,3066.1722115096322,2820.0673013717565,2582.2746833432752,2485.5998268688113,2628.2625901369188,2957.8060471518129,3360.4305234514063,3526.7870782778941,3217.2126916953557,2464.7831269801391,2208.8837540121522,2670.1509522231404,2992.4821619575882,3264.2326630059297,3356.9689779273194,3393.828908964917,3588.9982644105398,3676.0487898501133,3524.9197027006285,3127.4248276812368,2604.0486745378676,1951.6778131846056,1372.3216550518107,1910.1236018769862,2515.1057878078996,3212.987364385564,3751.5263275471184,4048.2729706043619,4191.1550998955181,3829.257056800875,3128.8903405439346,2327.0792300636949,1650.5742916631675,1172.3841380939034,607.00918220442702,844.58146045823412,1147.9665019996703,1483.5503555611056,1732.4837712120559,1840.8905194021208,1798.3549632118797,1604.8070683705585,1300.3874613078963,958.81772063967151,682.24232399477637,534.2282021203365,"C4"]
["Barcelona",8.4,10.1,11.7,14.1,17.5,19.899999999999999,23.1,23.6,20.8,17.8,12.9,10.6,2173.0555555555557,2823.8888888888887,3744.1666666666665,4805.5555555555557,5470,6162.5,6446.1111111111113,5550.5555555555557,4139.166666666667,3067.2222222222222,2152.7777777777778,1643.3333333333333,4040.3691061707218,3728.4741269437122,3362.4272918504757,2909.6358170175786,2554.1850075006382,2535.3312417810457,2717.717283393562,2959.7067820182979,3162.5730387867443,3560.559429373825,3527.1545224922147,3090.3766179782397,3145.4842403825851,3142.0314520210009,3235.636022202782,3311.4023848290753,3196.9073323799357,3326.2811359241805,3586.4704491103903,3575.5821246783912,3263.0001332126603,3119.0108208805896,2810.1284790601994,2392.5096036623149,1773.5662653947948,2137.5158324169529,2648.4005484233844,3209.2665258021671,3503.8089965265822,3886.9636073610145,4113.6491687193538,3662.6558364110774,2860.3442204251701,2264.7646433878776,1697.211285803276,1327.2171566373263,598.16220462491663,821.31034384203872,1123.3656464040096,1458.9131565349956,1701.9122357800402,1833.5023583393292,1795.9646191471902,1579.3241452375446,1243.6090909215425,906.6962094776261,637.99135198597662,511.56482151723338,"C2"]
["Bilbao",7.5,11.4,10.8,11.5,13.7,16.2,18.399999999999999,19.3,18.3,15.8,11.9,12.2,1056.6666666666667,1671.1111111111111,2451.1111111111109,2767.2222222222222,3767.2222222222222,3733.8888888888887,3919.4444444444443,3135,2978.3333333333335,2275,1222.2222222222222,845,1563.0585029709646,1940.8978933222566,2084.4340530490908,1714.2489657106337,1949.7060180963895,1836.142954554128,1947.1157683182287,1798.2444056023166,2252.2941081467243,2549.9774406230777,1714.4432879374654,1294.2776080586677,1260.5495938085123,1669.2981881008632,2002.8891397751474,1847.7891932141779,2253.8355042244411,2125.6320306936923,2274.621181699255,2000.2521113723687,2288.9416863024603,2241.6783790111663,1400.6582332222358,1034.6975036365329,795.79665253817086,1209.9309082145664,1688.4715313978038,1794.4801065324339,2390.053901170324,2328.482490198357,2467.7557107497805,2014.369878715597,2028.4403544039239,1660.2908025319325,914.04919797258685,636.32141721497817,420.12971527135704,641.44601507522907,932.79994680879543,1149.0723715850136,1478.4708958133854,1528.9663884223908,1536.6030873679251,1273.948107933682,1087.3541214120121,790.00513807701952,476.51054695051135,349.22777170618798,"C1"]
["Burgos",2.5,4.8,7.1,9.1999999999999993,12.2,16.2,19,18.8,16.2,11.3,6.5,3.4,1030,2221.1111111111109,2994.4444444444443,3996.1111111111109,5030.5555555555557,5953.8888888888887,6378.8888888888887,5577.7777777777774,4014.4444444444443,2787.2222222222222,1436.1111111111111,808.33333333333326,1428.1032197554193,2791.6620314701709,2620.0451057831924,2465.644918311215,2440.5515643837516,2535.4027155053482,2764.6043078539824,3044.6084950855125,3135.8129756257426,3256.3325338534096,2072.537843253197,1142.0056091914348,1163.8253720947541,2370.0324070297816,2517.2256913204278,2743.4955906554569,2979.1032456325224,3260.5344946738746,3597.345714797777,3649.7567111221156,3213.2999192106986,2846.5457028181295,1684.7781503631297,924.82310789101484,758.23001739043661,1653.0259603515294,2090.5478314591614,2651.4026125007658,3227.5413886765791,3771.0780081465036,4094.7264292681612,3711.9994874325357,2796.361088473745,2065.2952163698501,1083.2670560406125,592.35130050676833,421.6978123604286,742.95766776370567,1029.8780179570927,1370.1964637349301,1661.3360557962469,1823.890490211204,1794.4041885539311,1572.7666089495387,1220.0011621436536,864.38690563426701,528.47953716653353,346.11682872359944,"E1"]
["Caceres",7.7,9.1,11.7,14.4,17.399999999999999,22.5,26,25.6,22.3,16.899999999999999,11.7,8.1,1821.1111111111111,2640,3652.7777777777778,4885.5555555555557,5907.2222222222217,6477.7777777777774,6640.5555555555557,5872.7777777777774,4582.2222222222217,3232.7777777777778,2186.6666666666665,1546.6666666666665,2755.4312280453487,3106.3819384977032,3066.1722115096322,2820.0673013717565,2582.2746833432752,2485.5998268688113,2628.2625901369188,2957.8060471518129,3360.4305234514063,3526.7870782778941,3217.2126916953557,2464.7831269801391,2208.8837540121522,2670.1509522231404,2992.4821619575882,3264.2326630059297,3356.9689779273194,3393.828908964917,3588.9982644105398,3676.0487898501133,3524.9197027006285,3127.4248276812368,2604.0486745378676,1951.6778131846056,1372.3216550518107,1910.1236018769862,2515.1057878078996,3212.987364385564,3751.5263275471184,4048.2729706043619,4191.1550998955181,3829.257056800875,3128.8903405439346,2327.0792300636949,1650.5742916631675,1172.3841380939034,607.00918220442702,844.58146045823412,1147.9665019996703,1483.5503555611056,1732.4837712120559,1840.8905194021208,1798.3549632118797,1604.8070683705585,1300.3874613078963,958.81772063967151,682.24232399477637,534.2282021203365,"C4"]
["Cadiz",11.4,12.5,14.6,16.600000000000001,18.899999999999999,22.2,24.5,24.9,23.4,19.5,15.6,12.5,2331.6666666666665,3684.4444444444443,4571.666666666667,6186.1111111111113,7119.4444444444443,7589.4444444444443,7561.6666666666661,7141.6666666666661,5702.2222222222217,4053.8888888888887,2708.3333333333335,2188.3333333333335,3515.4651334861205,4493.6501182854181,3785.1909858935437,3346.3453264571335,2762.1152812125588,2529.8564158627278,2654.2659834403162,3276.546953022239,4049.9285070109922,4405.3361087793155,3925.948299103301,3616.8807687905587,2816.0795522861258,3844.9205120445222,3740.4126855612194,4066.7443258042017,3892.4144604835319,3789.3471919605167,3920.0656759744907,4344.7773938469518,4353.2226016093346,3921.9415924868536,3182.9364758571401,2842.2291307403361,1746.3886028821696,2691.0989225522726,3144.7016734514523,4066.9695357870241,4501.5332598912655,4714.0751522614346,4738.7457827312555,4639.6590237333494,3887.3556594397396,2909.4243381124479,2024.2282478732207,1670.6329423916832,701.33601764226398,954.23916628059851,1239.9410393429337,1545.3835076732603,1753.4509774631788,1834.5154754233256,1783.4989665847279,1600.2099547490225,1346.0778156767183,1038.2466688587631,767.31644146842814,645.38630696798998,"A3"]
["Castellon",10.4,11.1,13.1,14.9,17.8,21.6,24.3,24.7,22.6,18.600000000000001,14.3,11.1,2112.2222222222222,3451.1111111111109,4342.7777777777774,5137.7777777777774,5877.2222222222217,6401.1111111111113,6490,7862.7777777777774,4769.4444444444443,3368.333333333333,2157.2222222222222,1890.5555555555554,3626.019968177317,4693.9123404921311,3911.1701918294948,3033.2603526416056,2633.3162255824877,2530.5945214585172,2658.7713851616777,3896.8983266846999,3618.3553337166941,3872.4381747892849,3330.495538781347,3535.0788688397515,2852.6778287118777,3939.8271009612295,3781.0016281461926,3502.5345189165146,3383.2463206625853,3399.1907141784177,3560.1084532463328,5066.9153344965771,3771.7766399367001,3401.7148772612859,2676.2686910051134,2736.1716301517567,1668.1864857200303,2637.3259087679621,3081.5947430862871,3418.2350784132223,3753.8090352019008,4019.9054916995292,4116.2807902275035,5277.0264243648844,3303.9860368594127,2475.2398282809295,1659.9761108086352,1519.9626856803397,618.51429757538779,870.95116398799451,1174.201526008834,1489.9982232605992,1729.645728213789,1841.3806565978655,1796.3527683869393,1496.3425963150835,1291.6848768933194,947.18087029346452,659.95786766950619,555.85005297798534,"B3"]
["Ciudad Real",5.4,7.3,10.4,12.9,16.3,21.2,25.5,24.8,21,14.8,8.9,6.2,1652.2222222222222,2895.5555555555557,3511.6666666666665,4606.666666666667,5755.5555555555557,6395.5555555555557,7156.6666666666661,6376.6666666666661,4840.5555555555557,3048.3333333333335,1805,1281.1111111111111,2403.745496194575,3538.454650993066,2929.7869325507595,2669.009010359146,2540.1804046244943,2473.3421898233705,2752.8263805247152,3179.7826647035035,3585.6302490436119,3272.553266004445,2455.0982494331729,1876.1541633992588,1939.5925731501643,3022.1963983038145,2859.2492504919405,3067.6695406982844,3278.0791039248948,3359.2278477980635,3847.4208425585011,4007.7217948241555,3764.5369180426915,2908.9624755108989,2013.5734319971662,1506.4925652596576,1229.1097959276028,2123.4560121762934,2410.8844411247192,3019.504149243111,3652.9235407574606,3997.0899321677703,4532.5368481410642,4181.9388211641917,3325.0083976441601,2181.5226836668162,1327.0672682848067,944.94693828835864,580.96077598030115,867.17137576617597,1132.5038922693809,1459.9465801301362,1723.8902621098518,1838.1245646759733,1798.5306366529617,1608.2168928895228,1308.7815016102052,941.89118439911817,631.81077459148901,486.41439967012229,"D3"]
["Cordoba",9.1,10.7,13.5,16.3,19.399999999999999,24.4,27.9,27.6,24.3,18.600000000000001,13.6,9.6,2055.5555555555557,3081.6666666666665,3932.2222222222222,4784.4444444444443,5281.666666666667,6740.5555555555557,7145,6503.333333333333,4996.666666666667,3303.8888888888887,2285.5555555555557,1732.2222222222222,3125.3873493602582,3699.8629010177197,3268.8315742488112,2708.8793309801972,2339.3446752860154,2481.3804529324261,2674.3647260909179,3147.598482761447,3615.7440538216406,3513.3531602234239,3273.8453159812202,2758.3975020449152,2502.0646061698676,3171.2318837156699,3206.6597949255106,3149.710348941474,2985.5916137616864,3476.1468521646693,3790.0878441825712,4026.6863807075279,3828.5857755352054,3132.111597672621,2660.6609868708201,2182.7173398565133,1548.3952727547105,2242.5123600345746,2700.9883915780297,3121.844310787807,3323.1021540360621,4198.5447986826757,4498.9567972517516,4238.7812723933121,3407.7054701089096,2354.4691543411559,1706.1101403905288,1310.0432258233036,651.0860812746082,900.80213189157337,1185.3129768163387,1483.1232039787476,1688.9640878760783,1844.805416514055,1797.4733279366239,1614.459348125454,1328.4523734345505,980.85320920361744,709.08127124281714,574.76398018224938,"B4"]
["Coruña",9.9,9.8000000000000007,11.5,12.4,14,16.5,18.2,18.899999999999999,17.8,15.3,12.4,10.199999999999999,1436.6666666666667,2121.6666666666665,3075,4076.6666666666665,4171.1111111111113,4687.7777777777774,5047.7777777777774,4146.1111111111113,3710,2290,1741.1111111111111,1093.8888888888889,2518.256737182674,2750.2638282344847,2796.9606286580042,2572.496459109399,2132.0460824044508,2187.1429284676528,2381.2804424259266,2356.7086676409513,2939.9498301908779,2599.242513468907,2934.7008834813314,1953.4009580783102,1979.2781935876396,2322.4128586121733,2668.3042857937912,2850.1000599338904,2500.8856226512539,2638.6494023603113,2911.0029215394411,2700.6312707047882,2990.6481285099981,2279.9444486184257,2330.449964958917,1526.0697934428531,1150.9380417514783,1599.9380138963545,2182.2977567130315,2733.1845464584526,2664.5398160800601,2954.610908051267,3222.1686098711743,2721.0473910826845,2593.674395177427,1679.7488494121048,1393.4572639224641,869.7087517486998,486.79842609601394,712.75359319227857,1026.0280271379122,1371.6022894768826,1548.516749785078,1696.5673363983294,1702.4079357476849,1446.1590167491017,1178.8550652493166,788.54289617227892,557.56306455530625,400.71500104478014,"C1"]
["Cuenca",3.1,4.2,7.3,10,13.3,18.100000000000001,21.9,21.4,18,12,7.2,4.0999999999999996,1677.7777777777778,2558.8888888888887,3277.7777777777778,4240.5555555555557,5188.8888888888887,5813.333333333333,6607.7777777777774,5963.333333333333,4439.4444444444443,3076.6666666666665,1776.1111111111111,1380,2602.3471466836631,3113.1675880353978,2768.844244335337,2513.1355680116449,2404.1080574008624,2391.1282756219011,2694.3761328735841,3079.5922733393127,3338.248160116384,3438.9569218446477,2526.2856861154214,2229.5329043062711,2079.2677133091647,2659.5007983602495,2688.0257579871773,2844.9872459141448,3001.6561354901391,3119.6336199767716,3623.4229988893076,3796.8702240899006,3472.1470377612609,3033.6655784181908,2057.0399663030912,1763.2511912202403,1278.0463132911802,1876.3744987214209,2258.8294101812712,2783.7299092706553,3296.2432888698168,3639.9319883550625,4196.0313664581108,3923.8361597578319,3056.4240190091059,2236.9731070085536,1328.1497800754935,1053.2832290518541,569.68033858888134,816.90593858063642,1092.4199365929062,1414.6763608284953,1679.1698164830725,1808.4565489292638,1798.9019153852475,1598.7754066356272,1276.9796618284483,926.3705384440442,612.5916004601828,491.82629104460153,"D2"]
["San Sebastian",7.8,7.7,10.7,11.8,10.5,16.8,15.1,19,18.100000000000001,14.7,10.7,8,1322.7777777777778,1940,2651.6666666666665,2803.3333333333335,4009.4444444444443,4121.666666666667,4145,3356.6666666666665,3206.1111111111109,2521.1111111111109,1451.6666666666667,1063.8888888888889,2199.0029776872989,2403.6226379738523,2306.3993106764128,1739.2584880001684,2056.8987219590344,1981.7374875959101,2037.4579383468051,1921.4059266380032,2461.2859753392818,2944.2868080948983,2220.4343969231431,1847.3575730178675,1741.4922530235242,2044.7231709549962,2210.8639977814951,1875.9543269823471,2399.9943247692108,2334.3873785040892,2402.5200486401741,2152.1810982673587,2502.3838845910354,2571.6364044002639,1788.8983380674003,1448.8120306814819,1038.5338221212221,1437.9922143147787,1844.75258201211,1820.5096071967685,2553.2428836499494,2581.3978434267151,2617.554425957796,2167.5987978637709,2202.0056620312203,1869.5653342342957,1119.6984321468715,837.02022066509755,471.67705931619992,688.8519653334514,967.47519726933672,1156.988931434503,1522.0118004449312,1604.9163028468979,1576.8659135468768,1318.9275682502173,1121.2000776036934,821.12881368510909,519.37357928631934,397.22955016999799,"C1"]
["Girona",7.2,8.1999999999999993,10.7,13.1,16.7,20.399999999999999,23.3,23.1,20.5,15.9,10.9,7.7,2010.5555555555554,2834.4444444444443,3784.7222222222222,4432.7777777777774,4987.7777777777774,4740.5555555555557,6124.4444444444443,5016.1111111111113,3792.2222222222222,2953.8888888888887,2055.2777777777778,1555.2777777777778,3776.0281396015653,3873.8771407879967,3485.2598875685112,2724.1100193599386,2410.3453890122773,2155.660355579123,2668.6180090873472,2742.0429065860662,2909.888472915412,3481.9065412740238,3439.0373662519678,2995.3150565652704,2937.1349879489699,3246.2675763262928,3337.4226842083431,3063.2363935160433,2944.184524936486,2633.2981745426596,3448.1986651624015,3246.7761191107134,2984.662056700321,3040.6075385514227,2732.3159687863472,2313.002689702721,1650.0994105301118,2176.7738128604306,2705.3388152847151,2958.7824855172507,3193.0164774954778,2970.2297613137412,3916.0016447260591,3304.537696133159,2617.3922025840761,2195.7622314656005,1635.8570309622369,1269.3938451023485,572.06988551987104,806.63219217896983,1114.0962766893051,1421.1554483962793,1657.2821390817617,1700.4454019192558,1784.6718889853755,1543.3854830435891,1204.694089807326,884.31044737525713,615.18177067689862,488.83987041170258,"C2"]
["Granada",7,8.4,11,13.3,16.3,21.8,25.7,25.3,21.8,16,11.6,7.7,1911.1111111111111,2686.1111111111109,3402.7777777777778,4408.8888888888887,5165,5835,6579.4444444444443,5223.8888888888887,4292.2222222222217,3112.7777777777778,2059.4444444444443,1530.5555555555554,2721.9406294868168,2996.0866119335883,2700.6439355202988,2473.4112682936934,2273.4318857750136,2262.8665928398946,2512.3391029625641,2585.2064823916603,3000.98239434275,3177.809700146895,2738.3541980883651,2219.8546365589518,2202.1482581261366,2601.6896414973785,2663.9420761008751,2861.8329640899037,2902.896628655144,3041.4558739058848,3490.1744486577863,3192.426432902475,3175.6550304395369,2854.220219042289,2253.5474505874245,1783.0785731475123,1407.0432144761287,1904.4350861160065,2292.3829314922591,2850.55216963468,3237.1973034897751,3610.0848732935833,4117.3043918261765,3350.2262142895429,2873.4494670565432,2185.2265971263055,1498.1756191097008,1121.7895156272293,644.02906495558921,875.31309695496304,1140.9249591913044,1451.8731896216791,1678.2063139602817,1801.1222984881019,1794.9351266779902,1582.8879907636745,1302.9005102061517,975.44382678341674,693.4188880523792,553.4194251222018,"C3"]
["Guadalajara",3.5,5.9,9.5,11.9,15.6,20.2,24.3,23.5,19.8,13.7,8.4,5.5,1386.1111111111111,2125.5555555555557,2763.3333333333335,3610.5555555555557,4516.1111111111113,5103.333333333333,6550,5687.2222222222217,4042.7777777777778,2787.2222222222222,1440.5555555555554,1157.2222222222222,2021.8883180569726,2457.4211523216763,2273.3902249431876,2161.5236619756133,2179.462068333612,2219.1945963330645,2711.5206854601697,2987.839851944851,3035.1707441935846,3066.6782003860776,1912.9051399571429,1768.5648654774568,1632.1775797379662,2117.0879145969411,2207.458194287964,2403.9250798158159,2635.9982280011086,2785.3692862926891,3616.2101984723308,3639.5351782662615,3140.5544460716774,2710.3698836031044,1576.2961809786866,1411.7250501335604,1035.0099209028156,1531.8172937659863,1880.864662448804,2351.3039794567985,2857.7172756557852,3188.2524522291933,4169.684935977798,3743.9867747757144,2772.0803910121317,2015.4108479553231,1053.6393882534408,867.74982472245188,514.90588489600111,752.08963703655957,1012.6070812482375,1325.076107438553,1601.3348790874177,1743.0371761407835,1798.1381758845987,1588.2545305764675,1243.2725764862357,890.82061754000949,548.08715204410692,444.1358498270265,"D3"]
["Huelva",11.1,12.3,14.4,18.399999999999999,18.899999999999999,22.4,25,25.2,23.3,19.399999999999999,15.2,11.9,2103.3333333333335,3293.8888888888887,4388.333333333333,5776.666666666667,6676.6666666666661,7120,7498.8888888888887,6900,5725.5555555555557,3638.333333333333,2408.3333333333335,1856.6666666666665,3136.3657638789718,3961.0229095083232,3672.7226767498278,3194.4110271580312,2704.2468935821526,2509.9033376307475,2697.1490100348674,3250.8109596993831,4147.5032901665709,3910.9287759086455,3431.1098690664767,2955.564504310275,2518.0002683116368,3395.4396842620149,3613.1712756202228,3820.3948992941596,3699.2380785881201,3619.5381514980813,3927.1109654613533,4239.9408934373741,4433.6832844551318,3483.7195014483682,2790.4144616317681,2337.7122142985418,1572.0923371883246,2396.3122018273716,3027.9427208699067,3799.7288644021241,4226.630286990634,4429.3852109298405,4715.062865560787,4494.8378687438926,3930.6849987437276,2601.9609815481735,1792.2647013893752,1402.1349698264678,666.49283613581702,925.41934314015623,1221.63014917142,1537.1109666378989,1756.2855411639482,1845.7377007190059,1787.2311332718143,1607.2804119578764,1332.7413445598793,1011.9178037102721,731.36729054492366,599.9185295482331,"B4"]
["Huesca",4.5999999999999996,6.1,10.199999999999999,12.5,15.9,19.899999999999999,22.8,22.5,19.3,14,8.9,5.4,1787.2222222222222,3186.6666666666665,4165,4892.7777777777774,5724.4444444444443,6202.7777777777774,6637.2222222222217,5759.4444444444443,4283.333333333333,3158.333333333333,1881.1111111111111,1379.4444444444443,3196.712500606468,4589.0570795350459,3946.6350627962124,3019.915365919755,2692.1774684188208,2593.4330457540154,2828.067027273024,3121.3515527870268,3366.6006916317206,3830.5335916003282,3041.6313230230708,2522.469356194134,2503.3661768442607,3815.7571404016539,3768.7949027086611,3423.0965284311305,3376.7698675873035,3378.1752880141726,3725.9640357135299,3764.9630706388616,3457.264529855911,3330.5160178179849,2428.8525200808276,1961.8867507066971,1439.5046874325783,2498.9554020908918,3016.4948896060118,3295.6340130803501,3694.7210405396409,3931.3679318971017,4263.8869555621841,3836.0239019877308,2997.7340416844936,2374.6661653351416,1478.1932957618048,1104.2086839755743,551.34902614802672,817.47269994273961,1131.0030540836801,1456.7909141122364,1717.8199458377026,1837.8368194332427,1800.2126657085096,1580.0347223626441,1240.8563989877621,895.99612379295445,596.09706224534023,464.9200627179377,"D2"]
["Jaen",8.1999999999999993,9.6,12.3,14.1,18.3,23.8,27.7,27.3,23.4,17.600000000000001,12.7,8.9,2055.5555555555557,3081.6666666666665,3932.2222222222222,4784.4444444444443,5281.666666666667,6740.5555555555557,7145,6503.333333333333,4996.666666666667,3303.8888888888887,2285.5555555555557,1732.2222222222222,3125.3873493602582,3699.8629010177197,3268.8315742488112,2708.8793309801972,2339.3446752860154,2481.3804529324261,2674.3647260909179,3147.598482761447,3615.7440538216406,3513.3531602234239,3273.8453159812202,2758.3975020449152,2502.0646061698676,3171.2318837156699,3206.6597949255106,3149.710348941474,2985.5916137616864,3476.1468521646693,3790.0878441825712,4026.6863807075279,3828.5857755352054,3132.111597672621,2660.6609868708201,2182.7173398565133,1548.3952727547105,2242.5123600345746,2700.9883915780297,3121.844310787807,3323.1021540360621,4198.5447986826757,4498.9567972517516,4238.7812723933121,3407.7054701089096,2354.4691543411559,1706.1101403905288,1310.0432258233036,651.0860812746082,900.80213189157337,1185.3129768163387,1483.1232039787476,1688.9640878760783,1844.805416514055,1797.4733279366239,1614.459348125454,1328.4523734345505,980.85320920361744,709.08127124281714,574.76398018224938,"C4"]
["Leon",2.8,4.2,7.6,9.9,12.5,17.2,19.7,19.5,16.600000000000001,11.8,7,3.6,1555.5555555555554,2979.4444444444443,3792.2222222222222,4809.4444444444443,5317.7777777777774,6548.333333333333,6894.4444444444443,6018.8888888888887,4279.4444444444443,2952.7777777777778,1936.6666666666665,1171.1111111111111,2676.1211509072987,4260.0115093346803,3552.844532033313,2996.1674782767759,2562.3984438854318,2711.8831277449249,2932.9555265881522,3284.2723692101799,3402.6195294765375,3555.4479698900777,3254.2409076502831,2032.5581901508008,2107.8730572973786,3545.1923451133443,3390.4157579411858,3381.5476790281641,3155.6049795641225,3568.4307700796589,3884.3202234275145,3972.3380541764054,3484.8933897183811,3093.2372803233307,2584.4720676511834,1593.2518860108285,1235.5307865453597,2331.4422658319309,2730.5294375507124,3246.8810477660286,3427.1014859460588,4170.6735264632325,4450.5736314327705,4037.0345748733307,3009.37028662584,2214.7301094305144,1545.5960578627198,920.29636797462535,516.85388388531567,801.52802561125156,1105.3832525453067,1447.0893054752512,1687.7678838473566,1853.0688079717422,1801.9817489790773,1580.680819291638,1234.1627066223218,874.13872214690753,594.03549298692462,425.57264522872293,"E1"]
["Lleida",5.4,7.3,10.9,13.8,17.899999999999999,21.8,24.9,24.4,21.2,15.5,9.1999999999999993,5.2,1688.0555555555554,3380,4330.833333333333,5340.2777777777774,6097.7777777777774,6739.7222222222217,6843.8888888888887,5927.7777777777774,4650,3327.7777777777778,1750.8333333333333,1112.7777777777778,2836.4104118503142,4854.8197404412058,4071.2733722167218,3257.469436527078,2791.2611478145427,2696.9486285848106,2846.849792744451,3161.4272379281947,3650.3791798931024,4020.3039061330919,2653.1412693113512,1757.7198458396308,2240.4591529405498,4039.3087288787947,3899.3088754978553,3737.1456175855214,3567.7704564393789,3619.9976498344672,3807.2397378773776,3848.2674749019657,3767.4657165429171,3499.7427754862811,2139.3193684210632,1396.5380402801848,1326.5827668292598,2645.174426159233,3127.5406448031736,3605.7186564504118,3935.2616126331527,4273.0891661282612,4387.5858430238131,3938.5318198607361,3262.0620932670363,2496.6760451453674,1341.9376774853074,844.79472855239521,550.21101752659297,833.88293574884506,1146.7865039484334,1484.6023123874538,1737.2336040710584,1855.433239478145,1801.9405973444375,1588.0723506616871,1265.7150923422835,916.31343151398949,589.31274514424649,426.02865874153918,"D3"]
["Logroño",5.0999999999999996,6.5,9.6999999999999993,11.9,14.9,19.100000000000001,21.8,21.5,19,13.8,8.9,6.1,1662.7777777777778,2675,3779.4444444444443,5070.5555555555557,5896.666666666667,6547.7777777777774,7012.2222222222217,5943.333333333333,4593.8888888888887,3280,1872.2222222222222,1395.5555555555554,2939.2116779720732,3648.0901951740088,3529.1968703656012,3158.0108105102527,2776.0410976232051,2706.9447644551656,2961.1455182418372,3240.1237240100963,3693.0814517153922,4092.2785765673016,3083.2927746114769,2631.6409176981247,2306.0473689693772,3057.4739874304482,3369.7443494820168,3582.3588729501002,3492.3634159613075,3564.9064383386863,3943.2383208348028,3914.3688476637863,3787.8552858290909,3542.1297339608504,2455.7971352586865,2038.7845119596388,1334.1376605991363,2054.1139843503079,2717.4184932456701,3436.6369987912603,3821.075859070897,4168.4159374679739,4528.4608387496319,3979.7591830309775,3253.1643161005513,2495.4233419652169,1482.4605091715307,1130.8146829094351,531.53172549976898,786.46896461364383,1105.9009082346088,1463.2611544557521,1726.4887462335762,1852.8661611043108,1801.4394976035508,1580.6197888264928,1248.6660439806567,894.28096745352025,588.86830053623021,461.66734127940373,"D2"]
["Lugo",6,6.9,9.4,11,13.1,16.3,18.100000000000001,16.8,16.600000000000001,13.2,8.8000000000000007,6.2,1074.4444444444443,2010.5555555555554,2386.1111111111109,3768.333333333333,3843.333333333333,4648.333333333333,4731.666666666667,4233.8888888888887,3139.4444444444443,2540.5555555555557,1483.8888888888889,876.66666666666663,1594.8515082681704,2510.6409101034828,2011.1693120403943,2355.4095839233646,1980.7621685317915,2162.1209263370192,2253.1633778679766,2389.5831640746869,2392.3300405673758,2957.3692021806451,2272.7927823397054,1361.3441645502573,1285.4107926606694,2133.1252567740953,1934.5758842036666,2598.2816322588124,2297.7049664523165,2610.0951148993977,2725.9680672572413,2750.1868137603897,2433.5891476403435,2584.7153542170599,1830.5951991244515,1085.8517867277619,810.05628818043135,1494.3114189343255,1637.4097341625188,2502.8733971201559,2440.0521628166507,2924.1256434211436,3005.1094149542391,2776.4937457435094,2148.2179600675859,1881.2934233319086,1144.8324222890672,663.15553656061013,424.90206710411155,701.94463257861958,921.04701959934164,1334.11151737824,1492.6874218621342,1690.0964892756895,1664.3997613442275,1459.1353347013267,1113.1256706048694,825.8157475670547,526.79375745315758,357.77242723597652,"D1"]
["Madrid",4.9000000000000004,6.5,10,13,15.7,20.6,24.2,23.6,19.8,14,8.9,5.6,1767.2222222222222,2713.3333333333335,3930.5555555555557,5431.1111111111113,5884.4444444444443,7091.6666666666661,7187.2222222222217,6385,4477.2222222222217,2989.4444444444443,2035,1732.2222222222222,2858.0975489613252,3419.2494977059869,3495.9567779595882,3234.1063649670809,2658.0813413998694,2709.3787542646664,2861.6517182028401,3295.0895390679643,3398.7150111039537,3346.6063727215483,3125.1673927764446,3185.0562494404949,2269.203951090391,2903.785646865872,3376.7375145174324,3745.0022665825682,3403.2167005382703,3743.2032525759641,3932.581918557345,4097.4952891985149,3528.4893262131,2950.4060724606752,2513.7210352498064,2471.8756389887258,1366.9576518227088,2016.1013290448518,2771.1740652463959,3640.4021153549547,3767.1556311047302,4479.8586466486177,4589.5876942788109,4231.1856876620886,3094.7856280433111,2175.4085059173285,1564.1862178865774,1385.1762908740134,576.71249427661917,826.67369123645494,1148.0393842005367,1498.4344755251354,1729.4602668738823,1856.0250840057508,1798.9503121089433,1597.0747707951632,1274.4341187511036,913.57367822276638,640.61251769792443,534.01485004536073,"D3"]
["Malaga",12.5,12.9,15,16.3,19.3,22.8,25.2,25.6,23.5,19.7,15.8,13.3,2278.8888888888887,3210,4918.8888888888887,5245,6338.333333333333,6908.333333333333,7198.8888888888887,6198.8888888888887,5151.666666666667,3616.6666666666665,2815,1732.2222222222222,3428.7057096605772,3750.6312718848749,4153.0542366615855,2883.5904284646772,2582.8714380890915,2441.2619995249693,2604.4001881860277,2943.8714578909562,3633.3856545089375,3812.1697039621827,4177.0807918958808,2597.7607077142966,2747.786639253884,3231.7877698987768,4097.243133084562,3420.6283638060504,3500.7323440852006,3504.4180652290902,3761.3232407024589,3774.3306898387686,3884.0515379039934,3408.9492717064436,3373.829082978536,2074.025784581157,1706.3127162354672,2310.4731018744369,3412.8752688858926,3416.7223592860478,3993.4951072915828,4283.8980622564886,4507.9344496145313,4000.0910278518913,3486.8257112098768,2567.3352237341214,2121.4820417126316,1281.7032695674184,693.61349141255323,930.8162573057399,1242.8065706340112,1522.9448333934567,1751.0780958229709,1842.9896944235475,1794.7664552914055,1623.0992053662592,1347.9785799802776,1020.9206938685531,769.438394103718,591.62690602519035,"A3"]
["Murcia",10.7,11.6,14.2,16,19.5,23.4,26,26.3,23.5,18.899999999999999,14.4,11.6,2651.6666666666665,3327.2222222222222,4777.7777777777774,5931.1111111111113,7024.4444444444443,7152.2222222222217,7478.333333333333,6570.5555555555557,5291.666666666667,3861.1111111111109,2686.1111111111109,2151.6666666666665,4543.1293043969017,4127.9926858098434,4157.4380965649198,3332.9594853090166,2844.7115982899963,2563.695212934143,2749.1527954909475,3184.6945050864001,3870.683176692502,4338.336105155121,4145.5159803392207,3813.8469306210268,3570.8677132601915,3518.8820599792775,4066.2846719657291,3974.0570721342719,3916.3509518452179,3665.8830237652119,3955.1734818852974,4076.9891445781573,4102.5966311099783,3834.1757527016243,3329.0074152112684,2969.3341441983594,2083.2584365290372,2450.0055606719225,3350.4609276604765,3929.2221105554636,4474.2023255185904,4465.4421679263105,4720.0334550114158,4289.0289123466182,3632.025727242562,2808.3320262288448,2058.1392949023889,1688.8237404549241,688.80382438062099,912.03837880266553,1218.172608571027,1531.41523473505,1753.552909378204,1848.3266310023637,1789.0343810744532,1612.2902530428726,1328.8741765553739,1004.280594671751,735.69329192452278,614.00295524615638,"B3"]
["Ourense",6.6,7.2,10.7,12.6,16.12,19.100000000000001,21.8,21.2,18.7,13.9,9.5,7.3,784.44444444444446,1886.1111111111111,3908.8888888888887,3359.4444444444443,2463.3333333333335,5328.8888888888887,4489.4444444444443,5048.8888888888887,3485,1988.3333333333333,1472.2222222222222,677.77777777777771,952.83627772177101,2220.0254647160082,3665.1483247610954,2064.7612079969663,1341.7890444206596,2351.8927624622397,2137.7869147645533,2776.3885449699656,2655.8319263930184,2056.9921484261831,2149.4654173585905,875.70552420409047,795.53935072585705,1905.5047182160774,3500.3363766083257,2265.4276121343241,1468.7515812710678,2943.1144071863127,2573.3674584329992,3283.1422163988568,2716.0221509408825,1833.4739771880395,1744.0094138191337,720.65809255059969,554.13091084509506,1370.6433380324122,2816.4031944868088,2198.9171854483438,1527.3204020351941,3359.3758156776148,2833.5314904034099,3335.2645801097083,2392.1528552411919,1407.3410056411929,1115.0469691387457,483.30517726754027,353.82853153122721,691.76466784753666,1116.2276077699887,1273.6178919019658,1158.0904669804156,1771.7755476822711,1630.3060906959229,1543.861934469119,1167.669690151107,752.30573092980001,534.94043836524497,307.51743098993347,"C2"]
["Oviedo",9.3000000000000007,9.4,11.3,12.3,14.1,17,19.600000000000001,19.5,18.100000000000001,15.1,12,10.1,1488.8888888888889,2093.3333333333335,2896.1111111111109,3581.1111111111109,4244.4444444444443,4617.2222222222217,4501.1111111111113,3943.333333333333,3361.1111111111109,2233.3333333333335,1558.3333333333333,1186.6666666666667,2628.768215387528,2679.7362236713357,2580.6722996205599,2241.9050175649882,2158.3096313440333,2157.6875977780905,2174.298423808089,2240.9743472551368,2604.6012263408138,2496.5143690750315,2469.6539275418859,2184.7969588635956,2063.8315798917024,2267.5074937809068,2467.8680918180644,2461.3093361643037,2541.0810465915824,2597.872422384165,2602.2845347826155,2555.2336064031483,2649.0056343185997,2195.4156040561825,1978.9086774800653,1699.3457044042043,1195.779026249653,1570.7543268051995,2036.6265185769025,2371.7525428500121,2711.8625741689552,2906.1476215987973,2854.2673243322588,2575.8404885705754,2320.7823516050407,1628.3627030285916,1217.8969127887033,954.07664226092152,496.46121493710166,711.24716636106018,1004.5198015480314,1304.9201852588189,1560.102281824991,1686.0173802430347,1632.9038345406389,1418.6239625243049,1141.6706979004609,782.36107092581972,535.8418964637541,418.87210469244934,"C1"]
["Palencia",3.3,4.5999999999999996,8.1999999999999993,10.5,13.5,18.100000000000001,21,20.8,17.600000000000001,12.2,7.2,3.9,1202.2222222222222,2811.1111111111109,3346.6666666666665,4313.8888888888887,5587.2222222222217,6241.6666666666661,6722.2222222222217,6073.8888888888887,4235.5555555555557,3117.2222222222222,1764.4444444444443,1020,1768.1700397736495,3834.6697504258823,2988.6716029324493,2651.3588236609166,2637.4846292649031,2599.5583900153265,2847.319873186686,3271.0623932962112,3315.5725616561699,3751.1369056893882,2758.2257646222988,1593.1194525945598,1426.447625148325,3214.2978530443993,2868.976392283394,2973.8778946286102,3293.8884756559914,3394.6411757700776,3767.3654465737286,3979.1492698123975,3405.9093646407468,3265.5286225249802,2213.7431225967066,1268.5225457091371,902.15731727224556,2157.3582235530102,2358.7832816201903,2873.7921919330292,3599.535417246675,3955.3934252245517,4319.1999384174806,4059.3691082635851,2958.2199396827355,2336.2479727166683,1369.0061537170093,772.0034630443422,463.42286520339854,804.56080029008513,1076.0264819610522,1409.0063102936183,1709.16433330368,1839.5783629185312,1801.2547985770461,1585.4448753124516,1239.1819993375893,895.14554574754868,583.38068648561989,401.00256963833135,"D1"]
["Palma Mallorca",10.5,10.5,12.2,14.5,17.399999999999999,21.4,24.1,24.5,22.6,18.399999999999999,14.3,11.6,2323.3333333333335,3533.333333333333,4017.2222222222222,4949.4444444444443,6367.2222222222217,6917.2222222222217,7120.5555555555557,6173.333333333333,4890.5555555555557,3588.333333333333,2488.8888888888887,1797.7777777777778,4073.3224946301143,4768.9471589661525,3510.7087219715982,2898.317514323167,2764.7691344701529,2619.7745152458556,2787.4674003131886,3137.9293675172853,3685.1267888472885,4154.9401655788888,4008.6458890212034,3203.2961066068574,3194.043256674001,4008.3260478907982,3406.9258035564521,3343.159015421912,3637.1219169243363,3625.9522679110132,3858.8975669874653,3909.0418524824599,3854.2388344876922,3647.802390955268,3199.975694077295,2495.4135680885033,1847.6542106491122,2690.4735970275792,2813.4692616916973,3274.0548791665401,4073.0978302233025,4347.1318426941698,4523.849382907556,4057.2800395243885,3382.4472337560792,2643.2310485419453,1943.3302490410442,1418.7296274177988,640.4694835453048,881.46757606791084,1166.1810626997483,1482.3137101752168,1748.8394868498019,1852.8833416893042,1799.5714161210374,1604.3745318132649,1300.8663928388858,964.59050868625184,692.38314990316655,554.94242961231964,"B3"]
["Palma G.Canaria",18.3,19.600000000000001,19.100000000000001,19.600000000000001,20.3,21.4,23.8,23.6,25.9,23.3,22.1,19.899999999999999,2712.7777777777778,3250,4133.333333333333,4889.4444444444443,4956.666666666667,4425.5555555555557,4266.1111111111113,4163.8888888888887,4617.7777777777774,3377.7777777777778,2680.5555555555557,2047.2222222222222,3107.9465337993493,2937.8109812929097,2762.1637541706891,2273.3876886434114,1875.8228515955066,1678.226095974841,1675.380820268761,1844.737267067688,2661.9919668476628,2762.353134743626,2835.5581224366765,2303.3260965602208,2609.6635161809145,2675.9646836248553,2890.6424277343226,2875.4859281340941,2572.7815341632449,2223.4576578174356,2198.1502997395341,2338.7005123066656,3023.3984530631951,2618.8489465403618,2436.1158884032275,1932.1157704225636,1842.9886801531118,2144.9002135951114,2652.6992379366588,3044.4085174996017,3012.501923030009,2661.5560104346296,2575.7291072609401,2556.5650623110982,2934.0042477266725,2203.7744031802149,1798.4638755012659,1375.5083720911691,881.78564453695901,1067.8346968337862,1318.0886279092942,1544.9414532909477,1646.714126133231,1608.1399930244299,1566.9183539864266,1489.0532121932279,1416.3225009554462,1124.2626510634168,904.49785008287779,753.24714027263872,"Alfa"]
["Pamplona",4.5999999999999996,5.4,9,11.1,14.4,17.8,20.2,19.7,18.3,13.4,8.1999999999999993,5.5,1169.4444444444443,2040.5555555555554,3057.7777777777778,3143.8888888888887,4492.2222222222217,5547.2222222222217,5907.2222222222217,4930,3727.7777777777778,2763.3333333333335,1285,892.77777777777771,1775.6634412228768,2528.9848524231079,2725.3678581864997,1943.688156539863,2244.5254778831554,2439.0024445475888,2644.1975890939016,2741.5105954773107,2907.9718549086706,3277.5751475493034,1806.0853584304552,1369.6607372169617,1425.6611398767454,2151.5988347409275,2610.1611551549581,2117.6082389931098,2675.8616054857498,3068.933059632117,3361.9278968106214,3221.4447791309672,2968.9632406868518,2857.2591523775768,1474.8482518164958,1094.3579727954209,888.20706741949823,1511.7588257631503,2151.52776851819,2053.6421826348051,2871.6987732185171,3511.2558913188755,3787.6372046387269,3262.2758895411744,2589.1447119723475,2060.7685004816431,961.11226603832768,672.34584193978299,448.56973859629932,710.80446844645485,1032.4046949479962,1230.9459311531966,1596.5389485051403,1793.7387976481577,1773.735108419967,1531.9681525024478,1188.7969235778946,854.11427127305024,493.80683436598616,364.40262828343731,"D1"]
["Pontevedra",9.1999999999999993,10.1,12.3,14.2,15.6,18.100000000000001,20.2,20.5,18.2,14.9,11.9,9.9,1482.7777777777778,2461.6666666666665,3347.2222222222222,4983.8888888888887,4717.7777777777774,6395,6410,5672.2222222222217,4021.1111111111109,3117.2222222222222,1941.6666666666665,1366.1111111111111,2468.2405878642212,3235.4200305705544,3020.4689345859601,3097.0444526347701,2320.9137986844667,2661.4445243021405,2778.9003791051755,3097.6820505686578,3148.3065707355972,3804.9778365100533,3237.1116935175182,2534.9014342149403,1953.3564290965066,2727.1781276485367,2893.3046216557677,3509.732191997065,2798.0813843248325,3485.2436791597638,3617.4491309892956,3719.8629187295537,3224.7015099992091,3304.2080273261495,2573.6325417245766,1968.0389622632131,1163.0780153622306,1863.3218218827096,2369.3773173932159,3370.4892932000748,3017.6259962749014,4064.9875498792849,4117.7160935165675,3782.0349263352296,2803.8532535465797,2350.4787266184208,1544.4469409209667,1100.0717895843156,508.9156999035913,769.39885116714049,1071.0214582272845,1459.4598069961894,1626.150181528772,1847.2580416298781,1795.3296147204551,1575.3885032817973,1219.4580643407746,888.01083311739751,597.39577356646748,458.82355733682056,"C1"]
["Salamanca",3.7,4.9000000000000004,8.1,10.5,13.7,18.399999999999999,21.5,21.2,18.100000000000001,11.9,7.4,4.2,1617.2222222222222,2488.8888888888887,3454.4444444444443,4861.666666666667,5791.1111111111113,6315.5555555555557,6407.7777777777774,5791.666666666667,4315,2965.5555555555557,1698.3333333333333,1348.8888888888889,2448.9192536077921,2981.3291354374956,2943.632839991596,2869.2686818371953,2602.3645565236893,2507.8852033646958,2634.2863915394887,2992.8498645337149,3220.5074838651913,3258.8272689702735,2353.1390382674062,2138.7891030269466,1964.0821087561176,2553.6419798164757,2857.3401487308406,3295.4228981861356,3333.4655119179674,3356.623090336494,3516.2862096382141,3676.2987926226451,3350.1856704521374,2882.8305234056234,1924.4437893717009,1696.3155983516024,1221.5050723957061,1814.6453638757528,2390.3637023481529,3220.1296675457584,3695.2217340071429,3963.3610219643028,4060.9038535648974,3800.0815390338171,2959.038693242745,2142.2352970945226,1258.4710088125537,1022.7928900148233,562.52355999410031,811.00742868679845,1114.1674536400883,1473.2760826840793,1724.9608500103002,1837.6453312262202,1794.0846538053725,1595.8157272908988,1271.381146625364,918.84730559675472,602.25079830360835,488.10961207114588,"D2"]
["Santa Cruz",17.399999999999999,17.5,18.2,19.2,20.399999999999999,22.4,24.2,24.7,24.1,22.7,20.5,18.399999999999999,2658.8888888888887,3337.2222222222222,4421.1111111111113,5493.8888888888887,6051.666666666667,6716.1111111111113,6995,6355,5192.7777777777774,3682.7777777777778,2562.2229999325727,1991.6666666666665,3058.7370148863529,3064.5680466999816,2992.5298163337879,2503.4900724951499,2075.9957097132965,1961.0806824421118,2052.117792535063,2439.2671185533641,3005.369075391724,3092.5543373199025,2697.2222223500726,2243.2085525570324,2566.4479543840994,2781.6516332178785,3130.4637349870218,3237.2009746347594,3067.5242846156816,3119.8299538669626,3325.2503053684386,3486.0081785654179,3441.9874991737438,2917.4233237348922,2319.7190726827012,1881.6291199784691,1809.4431450423237,2212.4040258273576,2852.7131104887417,3437.1689449742307,3689.6954066444659,4046.4705624241647,4240.4764860463529,3942.3714915110186,3322.2542260663013,2421.9075586225422,1717.9898403651673,1339.399691301654,870.26933136533103,1073.2708214174811,1340.4337032439603,1587.3918475711284,1732.5282600407977,1797.6055631859456,1769.1933204033023,1657.7368136396365,1448.7357991588226,1153.5008373727053,883.58996246353206,739.31520658398085,"Alfa"]
["Santander",9.3000000000000007,9.1999999999999993,11.5,12.3,14.2,16.899999999999999,18.8,19.3,18.2,15.3,12.2,9.9,1306.6666666666667,2018.8888888888889,2680,3149.4444444444443,4205,4372.2222222222217,4203.8888888888887,3341.1111111111109,3189.4444444444443,2495.5555555555557,1446.1111111111111,992.77777777777771,2174.4436028406603,2555.0397205862464,2344.5095191719524,1965.0545021185585,2144.0522762214296,2074.6341897152247,2063.433826853447,1915.8681556600288,2452.4103229220241,2915.8813618209474,2222.041254892446,1676.1903366985534,1721.889071391513,2165.9262741191596,2245.4609262612003,2136.2899083935881,2519.3507015698992,2469.7766146950275,2437.7377569964588,2143.9451079417631,2491.8748751532362,2546.3842496934481,1788.9939115891616,1320.1193455120781,1026.44471516454,1508.5543940299622,1869.0746764076264,2065.2872874487648,2686.3347061067689,2746.400090670601,2657.8611827189266,2158.1941280694164,2191.7200371406752,1851.1753852509808,1117.4688786978784,773.3438637654682,467.52105373035192,699.47449805472195,970.93913286750478,1229.0554842877516,1553.9213051760526,1648.2701173179046,1586.8492228179939,1315.539657983086,1117.7226100601742,816.43656154240625,517.00904724061843,381.66929197815858,"C1"]
["Segovia",22.4,4,7.6,10.1,13.2,18.2,21.7,21.3,17.5,11.8,6.6,3.1,1431.6666666666667,2430,3078.333333333333,4062.7777777777778,4760.5555555555557,5716.1111111111113,6665.5555555555557,6018.333333333333,4302.2222222222217,2947.7777777777778,1521.6666666666667,1156.6666666666667,2158.491378386384,2996.0663024461187,2618.4046817395051,2446.1414230152559,2283.3212876247826,2404.8628137054193,2763.1479216753232,3165.6915327287679,3287.939583120216,3344.9678432676242,2104.7093488324699,1802.2249526082405,1733.3105431896822,2552.8945626233135,2532.8529724408522,2745.0156025106498,2783.7920807944029,3098.3903820402584,3690.0241336091776,3880.1295686014741,3399.7651424089886,2941.119619127488,1722.3348164906754,1434.445404050683,1081.617568619391,1792.5130039750181,2125.4593499391558,2673.8558416547189,3024.5247263444444,3590.8070266426839,4254.4413143609463,3986.9782849096978,2977.372777161529,2157.1251824795036,1128.7487215004371,873.36225511892337,519.32548004436967,789.09225930181356,1056.878794546257,1387.7190987975284,1632.5863704142432,1803.3591063934941,1800.3067468258998,1593.3571979916821,1257.6651020793711,901.28245951024769,559.87323795882901,440.62793625987626,"D2"]
["Sevilla",10.5,12.3,14.6,17.2,19.899999999999999,24.8,27.9,27.8,24.8,19.8,15,11.4,1988.8888888888889,3105,4290.5555555555557,5477.7777777777774,6222.2222222222217,6525,6606.1111111111113,6013.333333333333,4873.333333333333,3350,2313.8888888888887,1884.4444444444443,2916.770894283713,3677.806649743311,3589.9540639746115,3050.4632911591029,2593.7216220963896,2415.096288010041,2532.9270250049622,2920.2611776387648,3476.7811926268851,3526.952827086975,3265.704781069574,3046.5584023580955,2348.4143861114076,3160.3119075797376,3528.6340821829863,3618.0563274666133,3469.1445719884859,3362.3000668115465,3512.9245143740773,3694.6358932665644,3689.814469746962,3151.1579426942449,2660.231460109866,2404.0934531153193,1478.96583243187,2247.5219122172339,2958.9149085084487,3594.7661170123379,3931.3315299717924,4052.6581593480764,4139.3416789846378,3890.7980130471278,3303.3436518973554,2378.0479910818481,1717.1592806492765,1430.96385056434,650.46917287161114,910.59736869992003,1214.5139920175855,1527.666238629203,1747.1204967541494,1837.6816719205049,1795.8450656778346,1616.5301786426151,1331.5403152478268,991.74576803072068,719.52180327730173,600.48938238153517,"B4"]
["Soria",2.2999999999999998,3.5,6.6,8.9,11.9,16.5,19.600000000000001,19.5,16.399999999999999,10.9,6.2,3.1,1460.5555555555554,2196.1111111111109,2936.1111111111109,3848.8888888888887,4944.4444444444443,5820,6492.7777777777774,5515.5555555555557,3904.4444444444443,2516.6666666666665,1439.4444444444443,1185.5555555555554,2323.1478147864491,2684.8161765887567,2518.7464647753627,2348.9570180875435,2383.674536777552,2470.0386921113482,2763.7505850707266,2976.785088787105,2993.3041056802335,2776.871319435973,2018.8414980993575,1963.3531253590397,1850.5757508245736,2290.1961197573901,2428.4354870178918,2612.8904082784334,2911.7257036459478,3174.5660365314284,3633.7553209718726,3578.0893810111406,3075.7727264725581,2450.407246367201,1648.6132523975393,1548.7988386690031,1125.7291729190106,1616.6697397467524,2033.0648012887207,2536.1302432326602,3159.7514631651934,3672.2854277615397,4157.6478360945202,3652.0431264061135,2696.4412471220021,1823.4010998648594,1074.1447578440152,915.13145229110057,514.28094155225551,747.74209384210428,1028.1416731518991,1354.3637360936243,1652.9224940562883,1813.2541643255013,1797.3472758831858,1574.2505238244837,1218.0069942983148,842.86767788409918,535.66425226566685,437.69395719905918,"E1"]
["Tarragona",9.4,10.1,11.7,13.7,16.600000000000001,20.6,23.1,22.8,21.4,17.5,13,10.3,2058.6111111111109,3206.9444444444443,3657.7777777777778,4600.5555555555557,5124.4444444444443,5708.6111111111113,5897.7777777777774,5047.7777777777774,3861.3888888888887,3101.6666666666665,2040.8333333333333,1655.8333333333333,3690.190766756843,4415.3732177277761,3248.129603949465,2773.6871666098527,2420.0951416667567,2405.0634398455018,2548.1703179511865,2705.2726193466824,2903.9251244721836,3589.1669353895727,3231.2436775365372,3086.8613159110423,2887.0177880559145,3697.4849295974032,3130.7167158284142,3147.6287694008124,2993.0482765657976,3096.185101492285,3291.9440811593145,3227.694492447079,2995.5953231210046,3146.242763870091,2587.4017310741706,2392.2503060291169,1655.9090182737511,2466.168679280242,2574.7644107599322,3057.3995989962632,3268.2447321698078,3586.7336383010115,3744.5456632555515,3304.9767179058713,2645.2223766633338,2286.9848683831642,1587.9535110573838,1332.4301120599907,595.18195397153625,843.59998303048269,1119.4348002881441,1444.2645674012861,1672.1741430046482,1802.8936983276628,1772.2492752011292,1551.3150066635526,1222.7162458249904,912.66663260482801,631.43879829786613,516.23226423255346,"B3"]
["Teruel",1.6,3.5,6.7,9.1,12.9,17.2,19.2,18.899999999999999,16.7,11.1,6.6,3.3,1698.8888888888889,2677.2222222222222,3185,4002.2222222222222,5201.666666666667,5678.8888888888887,6377.2222222222217,5632.2222222222217,3997.2222222222222,2925.5555555555557,1673.8888888888889,1164.4444444444443,2685.7163352076122,3345.6261760710645,2689.3710919305527,2383.6530137836785,2419.3544990071578,2367.4123499118218,2648.2315961338782,2944.2745957444281,2976.1622303566287,3241.6693995100704,2346.4993274526578,1756.1327799661726,2139.7597112205654,2845.2176689050521,2608.5745704834367,2679.8707664874478,3016.4803156319285,3061.7484939860992,3515.8858720689914,3589.104603584969,3083.722159854749,2862.7189106676465,1915.4649174046135,1404.5748146896037,1303.3484533562246,1982.9519371569868,2193.7181009641677,2620.7301487741952,3308.8136086664636,3556.7830138180834,4048.8012712771724,3698.229404548505,2730.8825953513201,2120.5607736483075,1246.056741441482,868.99262551996208,569.04762629365212,824.80869913977585,1077.9248932831238,1383.8274435702472,1680.1539277995801,1798.7579711491355,1793.4532872955492,1588.0995865406649,1242.7204587827448,909.08631957384478,593.44213709286487,448.48522627552103,"D2"]
["Toledo",5.9,7.4,10.6,13.4,16.899999999999999,22.1,26.1,25.3,21.2,15.2,9.9,6.4,1772.7777777777778,2955.5555555555557,3428.333333333333,4773.333333333333,5470.5555555555557,6119.4444444444443,6895,6185,4484.4444444444443,3071.6666666666665,1776.6666666666665,1267.2222222222222,2788.6846859810953,3766.676837240826,2910.1158478254365,2813.0811102687753,2491.233029303763,2456.8377032907265,2752.8921839469417,3163.7241652917746,3359.3888802649135,3406.3123637332646,2501.6210776430648,1939.9020522710186,2222.9368938817061,3193.8664827446273,2826.496654256734,3226.578429830216,3152.1307800974937,3260.0703537488653,3759.206769753624,3932.3247952023567,3499.6410377581929,3009.2992612671837,2040.2609359399667,1547.2191557965248,1356.4847939435188,2203.5072510639616,2368.4867949522841,3155.5487914634409,3479.8978837477825,3834.6176282312081,4381.3042132799937,4073.4889852696106,3084.1130796386574,2226.3150450801927,1323.4950496150232,949.59344632818704,585.77177767352168,855.23187964707108,1112.3915901158468,1467.3443507322183,1703.4538850622093,1827.5899632967398,1801.3077897362482,1602.3738142716898,1282.2307782062724,929.53402089117901,615.58623084354815,474.02354315340574,"C4"]
["Valencia",10.3,11,13.1,14.8,17.8,21.9,23.9,24.5,22.4,18.3,14.4,11.1,2593.8888888888887,3000.5555555555557,3848.8888888888887,5128.8888888888887,6023.8888888888887,6070.5555555555557,6407.7777777777774,6675.5555555555557,4453.333333333333,3117.2222222222222,2093.3333333333335,1837.2222222222222,4748.673088642915,3784.5356623418788,3318.6820452227726,2992.8478221568607,2650.4220413280395,2424.3618982641187,2605.4404411473606,3345.037144107137,3299.1814080960085,3425.6828682090108,3106.1361738945479,3281.9514343775954,3700.7252172161179,3215.0016630277482,3225.2941547030709,3468.561149827849,3443.0741024223116,3222.9145029069264,3496.5042405302356,4232.1573007436955,3445.2428754613961,3032.1513934427926,2511.2038341916596,2555.4641236487678,2096.1924370459742,2227.2298363097389,2679.7378841964246,3398.2801356655195,3840.6369498381923,3795.8346480795781,4050.5352356470539,4406.2337032351797,3048.9696456082456,2250.9749977260412,1586.5908092065351,1450.7888315294269,652.15862886900402,866.01959515913325,1156.7083811867469,1494.3093272476744,1737.4281413306674,1823.6075135267845,1793.6360081600833,1598.3790416773497,1286.0641167272825,940.11908083125695,662.74361711791562,561.15062900158591,"B3"]
["Valladolid",3.3,5.0999999999999996,8.6,11,14.1,18.5,21.3,20.399999999999999,17.8,12.9,7.7,4.4000000000000004,1241.1111111111111,2876.1111111111109,3594.4444444444443,4710.5555555555557,5398.8888888888887,6333.333333333333,6925.5555555555557,6322.2222222222217,4452.7777777777774,3034.4444444444443,1685.5555555555554,1006.6666666666666,1833.3931100289039,3926.2588230715442,3251.1889036943066,2888.4270518699459,2558.1974333371113,2613.2252957708592,2891.4347533261839,3377.0193380459891,3498.8357999031359,3589.8560660121352,2553.4088053223409,1542.6471941053144,1477.846024971084,3290.9596080857291,3119.723018041042,3268.6072226472056,3177.6034780146492,3433.0099567134512,3865.5011448431387,4140.2179226736253,3601.1843079199684,3133.6857573265061,2059.2390608552205,1231.926492382632,932.45253521579662,2207.223662336638,2548.7733845362786,3155.87636282125,3467.8005029134192,4011.8649562273495,4451.3732980144032,4231.9180525236652,3120.1144258138042,2258.5082764287654,1292.4872438519228,756.8746594568313,473.46635033129837,812.34275012877447,1102.2284828874456,1446.4881470809503,1695.5130666889756,1843.3279165108331,1801.9782842511406,1586.1444153170237,1253.4147104973667,893.25691549331657,575.42682110010833,399.82052620401333,"D2"]
["Vitoria",4.5999999999999996,5.4,8.6,10.4,13,16.600000000000001,18.8,19.399999999999999,16.8,12.7,8.3000000000000007,5.4,1238.3333333333333,2339.4444444444443,2555,3166.6666666666665,4253.333333333333,4688.333333333333,4896.666666666667,4065,3210,2575,1365.5555555555554,893.33333333333326,1934.1750144282942,3064.8772244070456,2173.9840496758184,1958.1632595083229,2145.7698438521888,2165.1338908485027,2300.8389739313857,2287.0700866138718,2438.194681012365,2976.1294775862143,1975.3616336191953,1370.9543892484871,1545.9857700721468,2584.3522506925151,2091.0767180566127,2134.5348063791257,2534.453715150788,2624.030238401931,2808.8843240154788,2623.882685430458,2484.7300928195741,2604.7193509851381,1605.4216414902569,1095.3346221027382,949.89286022300257,1769.6450567591121,1761.0258679153333,2069.6671260744552,2710.9257137324962,2946.2567297644864,3110.2226289529222,2652.5375153597083,2194.9348796066824,1900.9043706954199,1031.6589719695867,672.83655716862745,462.28897359067639,749.79123742584591,955.66033499328717,1235.3746830632895,1561.8588364717923,1695.0676269133533,1684.6821654834941,1438.2263337143747,1126.4928336552969,834.65039706069592,509.75196257116897,364.53875630777026,"D1"]
["Zamora",3.8,5.3,8.6,11.2,14.2,18.600000000000001,21.6,21.2,18,12.8,7.5,4.3,1204.4444444444443,2915.5555555555557,3606.1111111111109,4839.4444444444443,5490.5555555555557,6395,6982.7777777777774,6155.5555555555557,4441.666666666667,2978.8888888888887,1735,996.11111111111109,1721.9748599024113,3946.5400070520868,3234.6705738852256,2948.4564490426715,2575.9731835369107,2611.0482355551553,2884.5092881624773,3271.0231085852615,3459.3678700436808,3459.1863388333618,2618.2740192469869,1487.9745182691322,1395.3975066259572,3312.6664665990293,3109.6176286302666,3351.5235282362009,3219.0557223709179,3451.2193149953869,3879.7267584482793,4004.9065062215413,3567.4711167317982,3029.1183039874336,2112.5850978936796,1192.9769865069629,894.59928372419859,2229.0454807354022,2548.3861410612972,3241.0867722665412,3523.4012634986375,4045.6716047285508,4481.1185010222944,4101.3532497257156,3100.8438329522201,2200.4222832126266,1327.8246848059632,742.33713527228008,469.15269349513733,821.18006440060083,1107.9775458802328,1458.7340034786564,1703.0580731798505,1845.0901157208166,1801.7075664301249,1589.9057712518568,1257.6635793462258,894.78610798778527,587.11260235149973,400.30729025115727,"D2"]
["Zaragoza",6.1,7.6,11.3,13.7,17,21.2,23.1,23.7,20.6,15.4,10.199999999999999,6.7,1800,3143.333333333333,4064.4444444444443,4962.2222222222217,6056.666666666667,6518.333333333333,6815.5555555555557,6196.6666666666661,4400,3240,1820,1359.4444444444443,3337.8599602803129,4611.2382845796383,3889.1884217949359,3099.6204836700194,2844.3132907281192,2708.6305435231443,2915.4494020881621,3380.2496300098719,3523.9997257431301,4049.721513628172,2985.1815574956017,2558.1400272723786,2601.7967070095629,3823.1764435171435,3703.687808342981,3505.9289023638794,3593.2032855377979,3556.6139313903341,3845.948137550818,4103.0212282214316,3608.8099625684436,3503.8042162096622,2379.205797665687,1982.6788078275849,1471.7301129741595,2485.7302927984183,2955.2271949056794,3361.480129719781,3935.0424672895501,4152.5692861749794,4399.139282546811,4168.8345006114996,3106.4660529823072,2467.2410586464921,1439.3073174618557,1100.954669818479,542.93400194526259,803.78307366463798,1117.6305719410241,1455.8550304839418,1733.2123830634694,1852.2961508207018,1801.8640357865634,1580.1018051444307,1238.9553538734694,889.2843431335707,580.39287934129879,454.35765004867562,"D3"]
["Zona 1 a definir"]
["Zona 2 a definir"]
["Zona 3 a definir"]
["Zona 4 a definir"]
["Zona 5 a definir"]
["Zona 6 a definir"]
["Zona 7 a definir"]

{"sheet":"LIMITES","index":7,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
["INICIAL"]
["Epoca","Valor Uo Muros","Valor Uo Cubiertas","Valor Uo huecos","Tasa ventilacion","F.solar",null,null,"Hermeticidad",null,null,"Refrigeracion"]
["Antes de 1979",1.8,2.5,5.7,2,0.75,"Sin rehabilitacion",null,"Sin Modificación",null,null,"Si"]
["Entre 1979 y 2006",1.4,1.8,4.5,1.5,0.75,"Rehab.\"mínima\"",null,"Hermeticidad mejorada",0.75,null,"No"]
[null,null,null,null,null,null,"Rehab. \"estándard\"",null,"Hermeticidad muy buena",0.5]
["Rehabilitacion Opacos",null,null,null,null,null,"Rehab. \"elevada\"",null,"PT"]
[null,"Muros",null,null,null,"Cubiertas",null,null,"Sin Modificación",1.3]
["Zona ","Rehab.\"basica\"","Rehab. \"media\"","Rehab. \"elevada\"","Zona ","Rehab.\"basica\"","Rehab. \"media\"","Rehab. \"elevada\"","Puentes térmicos reducidos",1.1499999999999999]
["A",0.7,0.5,0.15,"A",0.5,0.44,0.15,"Puentes termicos eliminados",1.05]
["B",0.56000000000000005,0.38,0.15,"B",0.44,0.33,0.15]
["C",0.49,0.28999999999999998,0.15,"C",0.4,0.23,0.15]
["D",0.41,0.27,0.15,"D",0.35,0.22,0.15]
["E",0.37,0.23,0.15,"E",0.33,0.19,0.15]
["Huecos"]
["Zona ","Rehab. \"basica\"","Rehab.\"media\"","Rehab.\"elevada\""]
["A",2.7,2.7,1]
["B",2.2999999999999998,2,1]
["C",2.1,2,1]
["D",1.8,1.6,1]
["E",1.8,1.5,1]
[]
["Factor solar"]
["Sin tratamiento",0.75]
["Prot. Solar \"mejorada\"",0.45]
[]
[]
["Combustible","Eficiencia","Coste €/kWh","Coef. a EPnr"]
["Calefaccion Gas Natural",0.85,{"$f":"0.05*1.21","v":6.0499999999999998E-2},1.1950000000000001,"Coste 0.05+21% Iva"]
["Refrigeracion Electrricidad",3,{"$f":"0.17*1.21","v":0.20570000000000002},1.954,"Coste 0.17+21%Iva"]
["--"]
[]
[null,"BI",1.1000000000000001,"%"]
[null,"IVA",1.1000000000000001,"%"]
[null,"Ejec.Mat","Coste intervencion","Coste aislamiento "]
["Sin intervención",0,{"$f":"B36*$C$33*$C$34","v":0},0]
["SATE/ETICS",75,{"$f":"B37*$C$33*$C$34","v":90.750000000000014},"9.7643*Rt+6.65"]
["Trasdosado Interior",27,32.670000000000009,"4.9286*Rt+6"]
["Relleno de camaras",15,18.150000000000002,"5.7143*Rt+5"]
["Fachada Ventilada",150,181.50000000000003,"5.5714*Rt+7.5"]
[]
["Sin intervención",0,0,0]
["Invertida",85,102.85000000000002,"10.357*Rt"]
["Trasdosado; falso techo",33,39.930000000000007,"4.9286*Rt+6"]
[]
["HUECOS","Sin rehabilitacion","Rehab.\"basica\"","Rehab. \"media\"","Rehab. \"elevada\""]
["Ejec.Mat",0,{"$f":"45+355+6","v":406},{"$f":"74+355+6","v":435},{"$f":"80+355+6","v":441}]
["Coste Intervencion",{"$f":"B47*$C$33*$C$34","v":0},{"$f":"C47*$C$33*$C$34","v":491.26000000000005},{"$f":"D47*$C$33*$C$34","v":526.35000000000014},{"$f":"E47*$C$33*$C$34","v":533.61}]
[null,null,"2Vidrio+carpintALrp","2VidrioBE+carpintALrp","3VidrioBE+carpintALrp"]
["Proteccion solar","Sin tratamiento","Con tratamiento"]
["Ejec.Mat",0,110.48]
["Coste Intervencion",0,{"$f":"C51*C33*C34","v":133.68080000000003}]