{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Inicio","Instrucciones de uso","Radiación","Angulo_Incidencia","Demanda_ACS","Demanda_Climatización","Demanda_Piscinas","Demandas_Totales","Curvas_f","Pérdidas_Conductos","Viabilidad_Económica","Conclusiones","BBDD_Localidades","BBDD_Clima","BBDD_Demanda"],"not_rendered":{"charts":14,"images":22,"macros":1,"external_links":0,"defined_names":77,"comments":8,"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":"Inicio","index":0,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Energía Solar Térmica"]
[null,null,null,null,"Hoja de càlculo para ser utilizada con el libro del mismo nombre, de M. Rosas Casals y J. Cendra Garreta, editado por Edicions UPC"]
[null,null,null,null,"http://upcommons.upc.edu/handle/2099.3/36583"]
[]
[null,null,null,null,"Implementa y desarrolla parte de los contenidos incluidos en la obra de referencia \"Solar Engineering of Thermal Processes\" (J. A. Duffie & W.A Beckman, John Wiley & Sons, 1991, USA)"]
[]
[null,null,null,null,"DESCARGO de RESPONSABILIDAD: los autores rechazan expresamente toda responsabilidad en relación con la utilización de los resultados generados en este hoja de càlculo y, en ningún caso, podrán ser considerados responsables frente a terceras partes por cualquier pérdida o daño que se derive de la aplicación de dichos resultados."]
[]
[]
[]
[]
[null,null,null,null,"Este libro está protegido por licencia Creative Commons. "]
[]
[]
[null,null,null,null,"Permite las modificaciones en macros y códigos asociados que el usuario crea conveniente (a su cuenta y riesgo)."]
[null,null,null,null,"Se recomienda guardar una copia de seguridad antes de modificar cualquier elemento."]
[]
[null,null,null,null,"Leyenda:"]
[]
[null,null,"Valor",null,"Variables. (a) Introducidas por el usuario o (b) modificables mediante botones."]
[]
[null,null,"Valor",null,"Datos obtenidos de las bases de datos"]
[]
[null,null,"Valor",null,"Resultados finales de cálculo para cada hoja"]
[]
[null,null,"Valor",null,"Resultados obtenidos en otras hojas del libro"]
[]
[null,null,"Valor",null,"Otros datos de partida y resultados intermedios"]
[]
[null,null,null,null,"Celdas auxiliares para uso interno de la plantilla. No tocar!"]

{"sheet":"Instrucciones de uso","index":1,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[[42,2,45,2],[48,1,49,1],[54,2,57,2],[53,1,57,1],[8,1,11,1],[17,1,19,1],[25,1,29,1],[34,1,36,1],[41,1,46,1]]}
["*"]
[null,null,null,"Antes de empezar:"]
[null,null,null,"Para que TODA LA PLANTILLA funcione correctamente, debemos empezar por seleccionar una población en el menú despleglable de la pestaña \"Radiación\"."]
[]
[null,null,null,"Además de estos comentarios, prestad atención a los insertados en algunas celdas específicas. Los reconoceréis por un triángulo rojo en la parte superior derecha, como en ésta, y los podéis leer situando el ratón encima de la celda en cuestión. "]
[]
[null,"Pestaña","Comentario"]
[]
[null,"Radiación:",1,"La base de datos incluye 50 localidades de la Penínsua Ibérica. Para trabajar con datos de otras localidades, se debe seleccionar la opción \"Genérica\" en la lista desplegable. Esta opción borra el valor de la latitud así como el resto de valores utilizados de la base de datos en el resto de pestañas. "]
[null,null,2,"Para poblaciones del hemisferio sur, el signo de la latitud así como el signo de la inclinación deben ser negativos. Al verificar \"Hemisferio Sur\", cambiamos el signo de la inclinación. La latitud, con signo negativo, debe ser introducida también. No debemos olvidar entonces introducir el resto de datos necesarios, empezando por la radiación."]
[null,null,3,"La correlación utilizada para calcular la razón de la radiación difusa (columna K) se puede particularizar para cada región. Podría utilizarse CUALQUIER correlación genérica. Por defecto y sencillez, utilizamos la de Page (simplificación de la 2.20)."]
[null,null,4,"La reflectividad del entorno (C4) suele considerarse nula, para estar siempre en el caso más desfavorable. "]
[]
[null,"Angulo_Incidencia:",1,"Esta pestaña presenta el cálculo de la variación del producto ta respecto la desviación normal. Como se puede observar los valores no varían ostensiblemente a lo largo del año por lo que se suele considerar su promedio.  "]
[]
[null,"Demanda_ACS:",1,"Calculada según UNE 94002 (aceptada en CTE)."]
[]
[null,"Demanda_Climatización:",1,"El UA estimado (E14)  es el resultado del cálculo con los valores (E3:E12) y tan sólo se debe utilizar en caso de que no se conozcan los datos exactos de los cerramientos. La plantilla trabaja con el valor de la celda E16."]
[null,null,2,"Los grados-día se pueden calcular (columna G) u obtener de una base de datos (columnas H e I). Esta plantilla trabaja con estos últimos. Ambos resultados pueden no necesariamente coincidir pues el proceso de cálculo en esta plantilla es aproximado ya que asumimos una temperatura del aire constante durante todo el mes. En otros casos puede variar la temperatura base (los GD de NASA por ejemplo son en base 65 F, esto es 18,34ºC)."]
[null,null,3,"Para cálculos de estimación de demanda de calefacción, lo normal es trabajar en base 18. En base 15 nos quedamos un poco por debajo en la estimación de la demanda real."]
[]
[null,"Demanda_Piscinas:",1,"La demanda térmica en piscinas suele ser órdenes de magnitud superior al resto de demandas. Por este motivo las piscinas (descubiertas sobretodo) se utilizan más que nada como sumidero de calor para alargar la temporada de baño. "]
[]
[null,"Demandas_Totales:",1,"El método de cálculo de las curvas-f en esta plantilla trabaja con los datos de la pestaña \"Demandas totales\". En esta pestaña debéis seleccionar (= poner un tick en) la demanda con la que queréis calcular las curvas f y después clicar en el boton de \"sumatorio\". De esta forma las curvas f se calcularan para las demandas específcas que uno quiera."]
[]
[null,"Curvas_f:",1,"Esta pestaña permite escoger el cálculo de las curvas f según el fluido calorportador, esto es el fluido que pasa por el interior de los captadores, pudiendo ser aire o agua. También permite modificar los valores de diseño estándar. Atención a la opción  \"Sistema para ACS solamente\", que debemos seleccionar cuando nuestro sistema esté diseñado para proporcionar agua caliente sanitaria solamente"]
[null,null,2,"Los valores de Fr(ta) y FrUl los debe proporcionar el fabricante del captador. En los catálogos o certificados, Fr(ta) suele ser un valor elevado (alrededor de 0,8 - 0,9) que normalmente recibe el nombre de rendimiento óptico. Para detereminar FrUl debemos fijarnos en las unidades y buscar W/m2K (FrUl no deja de ser una transmistancia térmica). En muchos casos FrUl, que se conoce como \"k1\", viene acompañado de un \"k2\" que tiene unidades W/m2K2. Este valor aparece porque la \"recta\" de rendimeinto no es en realidad una recta sinó una función ligeramente cuadrática. Pero k2 es órdenes de magnitud inferior a k1 y despreciable por este motivo."]
[null,null,3,"El factor captador - intercambiador (H6) debe ser calculado siempre que se prevea la necesidad de utilizar un intercambiador externo entre circuitos primario y de acumulación."]
[null,null,4,"Para estimar la evolución de la fracción anual de energía cubierta por el sol, definimos primero un rango de áreas de prueba amplio, para posteriormente acotar el rango para áreas que proporcionen la fracción deseada."]
[null,null,5,"El valor òptimo de la fracción anual es, en general, aquel que impide sobrepasar el 90% en cualquier mes del año, para evitar sobrecalentamientos en el sistema. Para ACS, este valor suele rondar el 60%, valor que deja la fracción de los meses de verano (en latitudes 40N almenos) en menos de 95%. Pero las cosas cambian cuando se incluyen demandas térmicas que no son tan regulares a lo largo del año como ACS. Por ejemplo, en ACS+calefacción, podemos tener fracciones anuales del 25% traquilamente. También dependerá de la forma aual de la radición solar: en paises tropicales, como la radiación es mas regular, tambien lo es el aporte solar y la fraccion anual se puede aproximar mas a la maxima mensual permitida."]
[]
[null,null,null,"En este punto:"]
[null,null,null,"Las curvas-f determinan una valor que nada sabe de tipos de connexión, pérdidas en conductos o cualquier otra característica que finalmente esté presente en nuestro sistema solar. En este punto requerimos de un primer esbozo del sistema y afinar los cálculos en un proceso de aproximaciones sucesivas. Este es el momento de decidir que tipo de conexión utilizaremos (serie o paralelo) o como vamos a aislar nuestras tuberías o conductos, por ejemplo. Recordemos que, como marca la recta de funcionamiento de un captador, la alta temperatura va en contra de la eficiencia del sistema. Por lo tanto, en general, se tenderá a connectar en paralelo siempre. En general, la conexión en serie tan sólo se utiliza cuando queremos que un sistema determinado entre en regimen (temperatura de utilización adecuada) lo más rápidamente posible, como en hoteles, hospitales, etc."]
[]
[null,"Pérdidas_Conductos:",1,"El  valor U se puede calcular o se puede pedir al fabricante del aislante de la tubería o conducto. Para las diferentes prácticas del Master, podéis suponer un valor de 1 W/m2K aunque no hace falta estimar pérdidas en conductos. A pesar de esto, pensad que el CTE sí lo exige."]
[null,null,2,"La variación de FrUl (D20) es notablemente dependiente del área de conductos. Con una superficíe de captación de 2m2 (1placa) los tubos del circuito primario normalmente serían de diámetro 3/4\" o aprox. 20 mm. Suponiendo 5m de ida y 5m de vuelta, esto proporciona un área de conductos de ida de 0,3 m2 y la misma de vuelta. Con estos datos, un FrUl que tenga valor original de 4,9 pasa a un valor de 5,2, esto es un 6% de aumento."]
[null,null,3,"Para determinar el diámetro de tubería a utilizar en los diferentes tramos de nuestro primario, disponemos originalmente del caudal por m2 de captador (que proporciona el fabricante) y el diámetro del conducto de entrada o salida del mismo. Cuando las tuberías se empiezan a unir por motivos de conexión, podemos utilizar un ábaco como el de la página A57, el cual proporciona dos resultados a partir de dos datos. Por ejemplo, para encontrar el diámetro si conocemos el caudal, debemos considerar una pérdida de presión por metro lineal de entre 10 y 40 mmca/m. Con estos valores fijados, la velocidad del fluido y el diámetro de la tubería son los resultados. "]
[]
[null,null,null,"En este punto:"]
[null,null,null,"Con las pérdidas en conductos estimadas y el tipo de conexión establecida, los valores de Fr(ta) y FrUl varían. Con estos nuevos valores debemos retroceder de nuevo a la pestaña Curvas-f para determinar como varía a su vez el comportamento de la fracción anual con estas modificaciones. El proceso de aproximaciones sucesivas es rápido y suele converger en dos iteraciones."]
[]
[null,"Viabilidad_Económica:",1,"El cálculo de la viabilidad económica de un sistema de EERR en general, o de energía solar en particular, es necesario siempre y cuando no venga, como es el caso del agua caliente sanitaria (ACS) y el Código Técnico de la Edificación, fijado por ley. En este sentido, esta pestaña puede ser medianamente útil cuando debamos justificar la viabilidad económica de proyectos que incluyan otras demandas además de la de ACS. El proceso de cálculo determina el área óptima que proporciona el máximo ahorro acumulado a lo largo de la vida útil de la instalación (VAN) o el menor tiempo de recuperación de la inversión (TRI). Aunque el área óptima para cada caso puede variar ligeramente (dado que el cálculo del VAN se realiza bajo premisas ligeramente diferentes que el TRI) y estimamos constantes las variables económicas a largo plazo (hecho claramente inverosímil), el resultado nos puede ayudar a situar el órden de magnitud adecuado para nuestra instalación.  "]
[null,null,2,"Todas las estimaciones de precios y porcentajes de esta pestaña son harto discutibles. Tan sólo comentar algunas cosas:"]
[null,null,null,"(a) El coste solar fijo (E6) es el que tienen todos los sistemas por pequeños que sean (no termosifón): bomba, acumulador, termostato, etc. Hasta unos 20 m2 de captación, se puede suponer constante, entre 1500 y 3000 € (en 2009). El coste variable (E5) es esencialmente el de los captadores, cuyo coste total es función del área."]
[null,null,null,"(b) Aunque el tiempo de vida de una instalación solar se cifra en 20 años (tiempo de vida de los captadores según los fabricantes), algunos elementos (sobretodo en el anillo primario, debido el estrés térmico al que están sometidos) pueden empezar a fallar mucho antes. Es recomendable seguir un estricto plan de mantenimiento que podemos cuantificar como un % de coste sobre la inversión (E8)."]
[null,null,null,"(c) El cálculo de viabilidad busca el punto en el que la inversión sea compensada o (con suerte) superada por el ahorro de combustible fósil a lo largo de los años de vida del sistema. En este sentido, el tipo de combustible y de instalación auxiliar que vamos a utilizar así como su precio, pueden modificar notablemente los resultados obtenidos."]
[null,null,3,"ATENCIÓN. Este cálculo de viabilidad no está pensado para instalaciones de frío solar, aunque es fácilmente adaptable con alguna modificación menor."]
[]
[null,"Conclusiones:",1,"La pestaña de conclusiones se basa en los resultados de área óptima de la pestaña Viabilidad_Económica. Por tanto, y para cualquier otro resultado que no venga de esta citada pestaña, debe ser modificada consecuentemente."]
[null,null,2,"Los factores de CO2 (térmico y eléctrico) deben ser cotejados con los del mix particular de producción del país o región, para así proporcionar la cantidad de CO2 ahorrada con nuestra  instalación solar particular. En este caso se utiliza tan sólo el factor de CO2 térmico."]
[]
[null,"BBDD__Localidades:",1,"BBDD con la lista de localidades incluidas en fSol.xls. "]
[]
[null,"BBDD_Clima:",1,"Los datos de esta pestaña provienen del \"Atlas de Radiación Solar de España\" (Font, 1984) realizado por el Instituto Nacional de Meteorología de España y que hasta la fecha (y que yo sepa) no ha sido actualizado. Los datos de capitales de provincia de Catalunya provienen del \"Atlas de Radiació Solar de Catalunya\" y del documento \"Els Graus Día de calefacció i refrigeració a Catalunya\" (ICAEN, 2002)."]
[null,null,2,"Siempre es conveniente cotejar los datos climatológicos con otros que sean más actuales o fiables, preguntando siempre cuál es la fuente de información con la que trabajan las entidades locales o ayuntamientos y trabajar con ellas. Algunas páginas web útiles para encontrar datos meteorológicos son las siguientes:"]
[null,null,null,"http://eosweb.larc.nasa.gov/sse/RETScreen/"]
[null,null,null,"http://re.jrc.ec.europa.eu/pvgis/apps/radmonth.php?lang=es&map=europe  "]
[null,null,null,"http://opengis.uab.es/wms/iberia/espanol/es_cartografia.htm   "]
[]
[null,"BBDD_Demanda:",1,"BBDD con los valores necesarios para los cálculos de demanda de fSol.xls. La temperatura media mensual de agua de red se ha obtenido de UNE 94002."]

{"sheet":"Radiación","index":2,"n_rows":23,"n_cols":45,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,12,9,13]]}
[null,"(Apartado A del Material teórico base del Módulo 3)"]
[null,"Inclinación del captador (º) ",{"$f":"IF(I2=FALSE,F2,F2*(-1))","v":35},null,"b",35,null,null,false,null,"Orientación del captador (º) ",null,null,null,0,null,"g"]
[null,"Latitud del lugar (º) ",42.37,null,"f"]
[null,"Reflectividad del entorno ",0.6,null,"r"]
[null,"Población"]
[]
[null,null,null,"↓"]
[null,"Mes (día característico)","Día","H "," d  "," wsp","as Máx","He","He ","KT","Hd / H","1-Hd / H","wsp","arccos"," w'sp","Rb","Comp.","Comp.","Comp.","R","HTOT","HTOT "]
[null,null,null,"(J/dia-m2)","(º)","(º)","(º)"," (J/s-m2)","(J/dia-m2)"," (H / He)",null,null,null,null," (º)",null,null,null,null,null," (J/dia-m2)","(kWh/dia-m2)",null,null,null,null,null,"(wsr)",null,null,null,null,"(wss)"]
[null,null,"n","BBDD_Clima","2.2","2.6","2.3","2.15","2.16","2.19","2.20",null,"2.6",null,"2.22","2.21","directa","difusa","reflejada","2.18","2.17","2.17",null,null,"A","B","C","cos-1","abs(min(wsr))","A>0 and B>0 ?","A>=B?","wsr","cos-1","abs(min(wss))","wss","a","b","d","a'","(wss) >= (wsr)?","(wsr) > (wss)?","G(wss, wsr)","G(wss, -ws)","G(ws, wsr)","D"]
[null,"G (17)",17,3708000,{"$f":"(23.45*(SIN(RADIANS(360*(284+C11)/365))))","v":-20.916962574476418},{"$f":"DEGREES(ACOS(-TAN(RADIANS(lat))*TAN(RADIANS(E11))))","v":69.596353589055823},{"$f":"DEGREES(ASIN(((SIN(RADIANS(lat))*SIN(RADIANS(E11)))+(COS(RADIANS(lat))*COS(RADIANS(E11))))))","v":26.713037425523584},{"$f":"1367*(1+0.034*(COS(RADIANS(360*C11)/365)))*SIN(RADIANS(G11))","v":634.50158171161297},{"$f":"(24/PI())*1367*(1+0.034*COS(RADIANS(360*C11)/365))*(COS(RADIANS(lat))*COS(RADIANS(E11))*SIN(RADIANS(F11))+RADIANS(F11)*SIN(RADIANS(lat))*SIN(RADIANS(E11)))*3600","v":13764130.578885309},{"$f":"D11/I11","v":0.26939587493366346},{"$f":"1-1.13*J11","v":0.69558266132496027},{"$f":"1-K11","v":0.30441733867503973},{"$f":"F11","v":69.596353589055823},{"$f":"DEGREES(ACOS(-TAN(RADIANS(lat-b))*TAN(RADIANS(E11))))","v":87.166376174650011},{"$f":"MIN(M11:N11)","v":69.596353589055823},{"$f":"(COS(RADIANS(lat-b))*COS(RADIANS(E11))*SIN(RADIANS(O11))+(RADIANS(O11))*SIN(RADIANS(lat-b))*SIN(RADIANS(E11)))/(COS(RADIANS(lat))*COS(RADIANS(E11))*SIN(RADIANS(F11))+RADIANS(F11)*SIN(RADIANS(lat))*SIN(RADIANS(E11)))","v":2.2918727200779978},{"$f":"IF(gamma>5,AS11,L11*P11)","v":0.69768579402806841},{"$f":"K11*(1+COS(RADIANS(b)))/2","v":0.63268531016063945},{"$f":"_r*(1-COS(RADIANS(b)))/2","v":5.425438671330246E-2},{"$f":"Q11+R11+S11","v":1.3846254909020104},{"$f":"T11*D11","v":5134191.3202646542},{"$f":"U11/3600000","v":1.4261642556290706},null,null,{"$f":"COS(RADIANS(b))+TAN(RADIANS(lat))*COS(RADIANS(gamma))*SIN(RADIANS(b))","v":1.3423488329061071},{"$f":"COS(RADIANS(F11))*COS(RADIANS(b))+TAN(RADIANS(E11))*SIN(RADIANS(b))*COS(RADIANS(gamma))","v":6.6360232327819041E-2},{"$f":"SIN(RADIANS(b))*SIN(RADIANS(gamma))/(COS(RADIANS(lat)))","v":0},{"$f":"DEGREES(ACOS((Y11*Z11+AA11*SQRT(Y11^2-Z11^2+AA11^2))/(Y11^2+AA11^2)))","v":87.166376174650011},{"$f":"ABS(MIN(F11,AB11))","v":69.596353589055823},{"$f":"IF(AND(Y11>0,Z11>0),1,0)","v":1},{"$f":"IF(Y11>=Z11,1,0)","v":1},{"$f":"IF(OR(AD11=1,AE11=1),-AC11,AC11)","v":-69.596353589055823},{"$f":"DEGREES(ACOS((Y11*Z11-AA11*SQRT(Y11^2-Z11^2+AA11^2))/(Y11^2+AA11^2)))","v":87.166376174650011},{"$f":"ABS(MIN(F11,AG11))","v":69.596353589055823},{"$f":"IF(OR(AD11=1,AE11=1),AH11,-AH11)","v":69.596353589055823},{"$f":"0.409+0.506*SIN(RADIANS(F11-60))","v":0.49335323384446095},{"$f":"0.6609-0.4767*(SIN(RADIANS(F11-60)))","v":0.58143125183072231},{"$f":"SIN(RADIANS(F11))-(PI()*F11/180)*COS(RADIANS(F11))","v":0.51378193052221444},{"$f":"AJ11-K11","v":-0.20222942748049932},{"$f":"IF(AI11>=AF11,1,0)","v":1},{"$f":"IF(AF11>AI11,1,0)","v":0},{"$f":"(1/(AL11*2))*((AK11*Y11/2-AM11*Z11)*(AI11-AF11)*PI()/180+(AM11*Y11-AK11*Z11)*(SIN(RADIANS(AI11))-SIN(RADIANS(AF11)))-AM11*AA11*(COS(RADIANS(AI11))-COS(RADIANS(AF11)))+(AK11*Y11/2)*(SIN(RADIANS(AI11))*COS(RADIANS(AI11))-SIN(RADIANS(AF11))*COS(RADIANS(AF11)))+(AK11*AA11/2)*((SIN(RADIANS(AI11))^2)-(SIN(RADIANS(AF11))^2)))","v":0.63692963810477421},{"$f":"(1/(AL11*2))*((AK11*Y11/2-AM11*Z11)*(AI11-(-F11))*PI()/180+(AM11*Y11-AK11*Z11)*(SIN(RADIANS(AI11))-SIN(RADIANS(-F11)))-AM11*AA11*(COS(RADIANS(AI11))-COS(RADIANS(-F11)))+(AK11*Y11/2)*(SIN(RADIANS(AI11))*COS(RADIANS(AI11))-SIN(RADIANS(-F11))*COS(RADIANS(-F11)))+(AK11*AA11/2)*((SIN(RADIANS(AI11))^2)-(SIN(RADIANS(-F11))^2)))","v":0.63692963810477421},{"$f":"(1/(AL11*2))*((AK11*Y11/2-AM11*Z11)*(F11-AF11)*PI()/180+(AM11*Y11-AK11*Z11)*(SIN(RADIANS(F11))-SIN(RADIANS(AF11)))-AM11*AA11*(COS(RADIANS(F11))-COS(RADIANS(AF11)))+(AK11*Y11/2)*(SIN(RADIANS(F11))*COS(RADIANS(F11))-SIN(RADIANS(AF11))*COS(RADIANS(AF11)))+(AK11*AA11/2)*((SIN(RADIANS(F11))^2)-(SIN(RADIANS(AF11))^2)))","v":0.63692963810477421},{"$f":"IF(AN11=1,MAX(0,AP11),MAX(0,AQ11+AR11))","v":0.63692963810477421}]
[null,"F (16)",47,7996000,{"$f":"(23.45*(SIN(RADIANS(360*(284+C12)/365))))","v":-12.954608093780696},77.887666897325872,34.675391906219311,{"$f":"1367*(1+0.034*(COS(RADIANS(360*C12)/365)))*SIN(RADIANS(G12))","v":795.97229390976725},19184868.884044841,{"$f":"D12/I12","v":0.41678679423500775},{"$f":"1-1.13*J12","v":0.52903092251444128},{"$f":"1-K12","v":0.47096907748555872},{"$f":"F12","v":77.887666897325872},88.29498603043443,{"$f":"MIN(M12:N12)","v":77.887666897325872},1.8168612110899476,0.85568544850632755,{"$f":"K12*(1+COS(RADIANS(b)))/2","v":0.48119384209211857},{"$f":"_r*(1-COS(RADIANS(b)))/2","v":5.425438671330246E-2},{"$f":"Q12+R12+S12","v":1.3911336773117486},11123504.883784743,{"$f":"U12/3600000","v":3.089862467717984},null,null,1.3423488329061071,3.9939865587681339E-2,0,{"$f":"DEGREES(ACOS((Y12*Z12+AA12*SQRT(Y12^2-Z12^2+AA12^2))/(Y12^2+AA12^2)))","v":88.29498603043443},{"$f":"ABS(MIN(F12,AB12))","v":77.887666897325872},{"$f":"IF(AND(Y12>0,Z12>0),1,0)","v":1},{"$f":"IF(Y12>=Z12,1,0)","v":1},{"$f":"IF(OR(AD12=1,AE12=1),-AC12,AC12)","v":-77.887666897325872},{"$f":"DEGREES(ACOS((Y12*Z12-AA12*SQRT(Y12^2-Z12^2+AA12^2))/(Y12^2+AA12^2)))","v":88.29498603043443},{"$f":"ABS(MIN(F12,AG12))","v":77.887666897325872},{"$f":"IF(OR(AD12=1,AE12=1),AH12,-AH12)","v":77.887666897325872},{"$f":"0.409+0.506*SIN(RADIANS(F12-60))","v":0.56441879910838},{"$f":"0.6609-0.4767*(SIN(RADIANS(F12-60)))","v":0.51448074795461507},{"$f":"SIN(RADIANS(F12))-(PI()*F12/180)*COS(RADIANS(F12))","v":0.69249730112481145},3.5387876593938716E-2,{"$f":"IF(AI12>=AF12,1,0)","v":1},{"$f":"IF(AF12>AI12,1,0)","v":0},0.81543071708562553,0.81543071708562553,{"$f":"(1/(AL12*2))*((AK12*Y12/2-AM12*Z12)*(F12-AF12)*PI()/180+(AM12*Y12-AK12*Z12)*(SIN(RADIANS(F12))-SIN(RADIANS(AF12)))-AM12*AA12*(COS(RADIANS(F12))-COS(RADIANS(AF12)))+(AK12*Y12/2)*(SIN(RADIANS(F12))*COS(RADIANS(F12))-SIN(RADIANS(AF12))*COS(RADIANS(AF12)))+(AK12*AA12/2)*((SIN(RADIANS(F12))^2)-(SIN(RADIANS(AF12))^2)))","v":0.81543071708562553},{"$f":"IF(AN12=1,MAX(0,AP12),MAX(0,AQ12+AR12))","v":0.81543071708562553}]
[null,"M (16)",75,10780000,-2.4177348051423611,87.792769267490655,45.212265194857636,{"$f":"1367*(1+0.034*(COS(RADIANS(360*C13)/365)))*SIN(RADIANS(G13))","v":979.29682830202023},26337581.593182016,{"$f":"D13/I13","v":0.4093010575728262},0.53748980494270637,0.46251019505729363,87.792769267490655,89.687090962399182,87.792769267490655,1.4146536299493875,0.65429172632639965,0.48888783872300789,5.425438671330246E-2,1.1974339517627102,12908338.000002015,3.5856494444450044,null,null,1.3423488329061071,7.3309237964296441E-3,0,89.687090962399182,87.792769267490655,1,1,-87.792769267490655,89.687090962399182,87.792769267490655,87.792769267490655,0.64493515122851508,0.4386267063426223,0.94024423502532728,0.10744534628580871,1,0,0.64039259623426426,0.64039259623426426,0.64039259623426426,0.64039259623426426]
[null,"A (15)",105,14386000,9.4148933468800724,98.699470109441236,57.044893346880087,1137.9006150173054,33952861.676308721,0.42370508080142522,0.52121325869438961,0.47878674130561039,98.699470109441236,91.228943096287551,91.228943096287551,1.1111525754005396,0.5320051206693609,0.47408308253221304,5.425438671330246E-2,1.0603425899148764,15254088.498515412,4.2372468051431698,null,null,1.3423488329061071,-2.8789971191705899E-2,0,91.228943096287551,91.228943096287551,0,1,-91.228943096287551,91.228943096287551,91.228943096287551,91.228943096287551,0.72536913194534947,0.36285026640642665,1.2490460737114055,0.20415587325095985,1,0,0.54148108367735726,0.54072965253248129,0.54072965253248129,0.54148108367735726]
[null,"M (15)",135,18110000,18.791917517696167,108.0823118414052,66.421917517696173,1223.7436334989977,39452995.146148279,0.45902725339138273,0.4812992036677376,0.5187007963322624,108.0823118414052,92.52253076791105,92.52253076791105,0.93511936982382915,0.48504716179334356,0.43777821513341436,5.425438671330246E-2,0.97707976364006033,17694914.519521493,4.9152540332004149,null,null,1.3423488329061071,-5.9079786772616716E-2,0,92.52253076791105,92.52253076791105,0,1,-92.52253076791105,92.52253076791105,92.52253076791105,92.52253076791105,0.78551730192149893,0.30618498453363929,1.5361156215451097,0.30421809825376134,1,0,0.50639562112883163,0.50263354063816623,0.50263354063816623,0.50639562112883163]
[null,"J (11)",162,21434000,23.085911002836561,112.88026223869227,70.715911002836577,1249.1344733636261,41737717.669121385,0.5135402987273886,0.4196994624380509,0.5803005375619491,112.88026223869227,93.160473455826875,93.160473455826875,0.86565681499770331,0.50234111508733192,0.38174856754058561,5.425438671330246E-2,0.93834406934121994,20112466.78225971,5.5867963284054749,null,null,1.3423488329061071,-7.4007314284098735E-2,0,93.160473455826875,93.160473455826875,0,1,-93.160473455826875,93.160473455826875,93.160473455826875,93.160473455826875,0.81247229801537491,0.28079082121753124,1.6873197943605112,0.39277283557732401,1,0,0.52776088100841478,0.52048547536848355,0.52048547536848355,0.52776088100841478]
[null,"J (17)",198,22964000,21.183693564513842,110.701979143976,68.813693564513841,1232.8016847909253,40541075.973139197,0.56643785219748422,{"$f":"1-1.13*J17","v":0.35992522701684293},0.64007477298315707,110.701979143976,92.873283816304308,92.873283816304308,0.89575435928698166,0.57334976816928807,0.32737935625943465,5.425438671330246E-2,0.95498351114202529,21930241.34986547,6.0917337082959637,null,null,1.3423488329061071,-6.7288250660934162E-2,0,92.873283816304308,92.873283816304308,0,1,-92.873283816304308,92.873283816304308,92.873283816304308,92.873283816304308,0.80057421646399385,0.2919999427106999,1.618447954640946,0.44064898944715092,1,0,0.59706090262273614,0.58980742729878022,0.58980742729878022,0.59706090262273614]
[null,"A (16)",228,20080000,13.454959682356431,102.60529224734982,61.084959682356441,1167.7568182506368,36029798.761922695,0.5573164627614049,0.37023239707961253,0.62976760292038747,102.60529224734982,91.773326872630719,91.773326872630719,1.030388957364889,0.64890558375532348,0.33675451100469544,5.425438671330246E-2,1.0399144814733214,20881482.787984293,5.8004118855511928,null,null,1.3423488329061071,-4.1539590717817154E-2,0,91.773326872630719,91.773326872630719,0,1,-91.773326872630719,91.773326872630719,91.773326872630719,91.773326872630719,0.75153364273717882,0.33820081523159462,1.3667089901900418,0.38130124565756629,1,0,0.66405404719977745,0.66118658341047243,0.66118658341047243,0.66405404719977745]
[null,"S (15)",258,14452000,2.2168867832133041,92.023598618334844,49.846886783213314,1035.3169640022131,29044725.986785866,0.49757742615905742,{"$f":"1-1.13*J19","v":0.43773750844026516},0.56226249155973484,92.023598618334844,90.286887439390824,90.286887439390824,1.2810682221822354,0.72029661046218363,0.39815554167053913,5.425438671330246E-2,1.1727065388460254,16947954.89940276,4.7077652498341003,null,null,1.3423488329061071,-6.7212875632496165E-3,0,90.286887439390824,90.286887439390824,0,1,-90.286887439390824,90.286887439390824,90.286887439390824,90.286887439390824,0.67731586499158636,0.40812100228954701,1.0560900742379202,0.2395783565513212,1,0,0.71693447197817395,0.7168675394293228,0.7168675394293228,0.71693447197817395]
[null,"O (15)",288,10034000,-9.5993972342263003,81.125456535373417,38.030602765773715,849.13830045859675,21250703.890134722,0.47217259493499009,{"$f":"1-1.13*J20","v":0.46644496772346122},0.53355503227653878,81.125456535373417,88.746517161306514,81.125456535373417,1.6693218912856778,0.89067509558486258,0.42426715829122369,5.425438671330246E-2,1.3691966405893887,13738519.091673927,3.8162553032427575,null,null,1.3423488329061071,2.9364763355894608E-2,0,88.746517161306514,81.125456535373417,1,1,-81.125456535373417,88.746517161306514,81.125456535373417,81.125456535373417,0.59136810978705112,0.48909194083895802,0.76959462681425417,0.1249231420635899,1,0,0.85906066845575602,0.85906066845575602,0.85906066845575602,0.85906066845575602]
[null,"N (14)",318,5170000,-18.911954741226136,71.789030202433935,28.718045258773873,672.2565431035473,15015427.907452313,0.34431253187490418,{"$f":"1-1.13*J21","v":0.61092683898135824},0.38907316101864176,71.789030202433935,87.460116025535768,71.789030202433935,2.1502568395814792,0.83660722557792055,0.55568440402197483,5.425438671330246E-2,1.446546016313198,7478642.9043392334,2.077400806760898,null,null,1.3423488329061071,5.9485948081788254E-2,0,87.460116025535754,71.789030202433935,1,1,-71.789030202433935,87.460116025535754,71.789030202433935,71.789030202433935,0.51238016932998465,0.5635060736766726,0.55834277322087766,-9.8546669651373597E-2,1,0,0.78088816433351604,0.78088816433351604,0.78088816433351604,0.78088816433351604]
[null,"D (10)",344,2910000,-23.049627643930584,67.162169212219254,24.580372356069418,586.71388646610103,12305972.058178348,0.23647055155354926,{"$f":"1-1.13*J22","v":0.73278827674448932},0.26721172325551068,67.162169212219254,86.845079208807888,67.162169212219254,2.4654989457176097,0.65881022196984729,0.66652664583537269,5.425438671330246E-2,1.3795912545185225,4014610.5506489007,1.1151695974024725,null,null,1.3423488329061071,7.3877421712956942E-2,0,{"$f":"DEGREES(ACOS((Y22*Z22+AA22*SQRT(Y22^2-Z22^2+AA22^2))/(Y22^2+AA22^2)))","v":86.845079208807888},67.162169212219254,1,1,-67.162169212219254,86.845079208807888,67.162169212219254,67.162169212219254,0.47208713930897972,0.60146593022017658,0.46664753617700583,-0.2607011374355096,1,0,0.59297365889607057,0.59297365889607057,0.59297365889607057,0.59297365889607057]
[null,null,null,{"$f":"SUM(D11:D22)","v":152024000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U11:U22)","v":167218955.58826262},{"$f":"SUM(V11:V22)","v":46.449709885628501}]

{"sheet":"Angulo_Incidencia","index":3,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Implementa el efecto de la inclinación sobre el producto \"ta\" (J. A. Duffie & W. A. Beckman, sección 5.6, \"Angular depence of  ta)"]
[]
[null,null,"І Φ - β І =",{"$f":"lat-b","v":7.3699999999999974}]
[null,null,"w = ",37.5,"(2,5 horas antes del mediodía solar = 09.30 o 14.30 hora solar)"]
[]
[null,null,null,null,null,null,null,"Nueva",null,null,null,"Nueva",null,null,null,"Nueva"]
[null,"MES ","dia"," d  (º)","θb mensual","(ta)b / (ta)n","Comp.","Comp.","θe (difusa)","(ta)d / (ta)n","Comp.","Comp.","θe (reflejada)","(ta)r / (ta)n","Comp.","Comp.","R","R","(ta) / (ta)n"]
[null,null,"n","2.2",null,null,"directa","directa",null,null,"difusa","difusa",null,null,"reflejada","reflejada","2.18","nueva"]
[null,"G (17)",17,{"$f":"Radiación!E11","v":-20.916962574476418},{"$f":"DEGREES(ACOS(SIN(RADIANS($D$3))*SIN(RADIANS(D9))+COS(RADIANS($D$3))*COS(RADIANS(omega))*COS(RADIANS(D9))))","v":46.43701838113526},0.96,{"$f":"Radiación!Q11","v":0.69768579402806841},{"$f":"G9*F9","v":0.66977836226694565},56.5,0.88,{"$f":"Radiación!R11","v":0.63268531016063945},{"$f":"K9*J9","v":0.55676307294136274},71,0.66,{"$f":"Radiación!S11","v":5.425438671330246E-2},{"$f":"O9*N9","v":3.5807895230779624E-2},{"$f":"Radiación!T11","v":1.3846254909020104},{"$f":"H9+L9+P9","v":1.262349330439088},{"$f":"R9/Q9","v":0.9116900842383987}]
[null,"F (16)",47,{"$f":"Radiación!E12","v":-12.954608093780696},{"$f":"DEGREES(ACOS(SIN(RADIANS($D$3))*SIN(RADIANS(D10))+COS(RADIANS($D$3))*COS(RADIANS(omega))*COS(RADIANS(D10))))","v":42.437273076885113},0.97,{"$f":"Radiación!Q12","v":0.85568544850632755},{"$f":"G10*F10","v":0.83001488505113774},56.5,0.88,{"$f":"Radiación!R12","v":0.48119384209211857},{"$f":"K10*J10","v":0.42345058104106437},71,0.66,{"$f":"Radiación!S12","v":5.425438671330246E-2},{"$f":"O10*N10","v":3.5807895230779624E-2},{"$f":"Radiación!T12","v":1.3911336773117486},{"$f":"H10+L10+P10","v":1.2892733613229816},{"$f":"R10/Q10","v":0.92677891589426287}]
[null,"M (16)",75,{"$f":"Radiación!E13","v":-2.4177348051423611},38.676452511662617,0.97,{"$f":"Radiación!Q13","v":0.65429172632639965},0.63466297453660769,56.5,0.88,{"$f":"Radiación!R13","v":0.48888783872300789},0.43022129807624693,71,0.66,{"$f":"Radiación!S13","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T13","v":1.1974339517627102},1.1006921678436343,0.91920908558115888]
[null,"A (15)",105,{"$f":"Radiación!E14","v":9.4148933468800724},37.137938808857818,0.97,{"$f":"Radiación!Q14","v":0.5320051206693609},0.51604496704928005,56.5,0.88,{"$f":"Radiación!R14","v":0.47408308253221304},0.41719311262834746,71,0.66,{"$f":"Radiación!S14","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T14","v":1.0603425899148764},0.96904597490840716,0.91389894560983498]
[null,"M (15)",135,{"$f":"Radiación!E15","v":18.791917517696167},38.170016282328717,0.96,{"$f":"Radiación!Q15","v":0.48504716179334356},0.46564527532160982,56.5,0.88,{"$f":"Radiación!R15","v":0.43777821513341436},0.38524482931740461,71,0.66,{"$f":"Radiación!S15","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T15","v":0.97707976364006033},0.88669799986979414,0.90749807013344175]
[null,"J (11)",162,{"$f":"Radiación!E16","v":23.085911002836561},39.27748041970392,0.95,{"$f":"Radiación!Q16","v":0.50234111508733192},0.4772240593329653,56.5,0.88,{"$f":"Radiación!R16","v":0.38174856754058561},0.33593873943571534,71,0.66,{"$f":"Radiación!S16","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T16","v":0.93834406934121994},0.84897069399946035,0.90475415334110265]
[null,"J (17)",198,{"$f":"Radiación!E17","v":21.183693564513842},38.740684400455606,0.95,{"$f":"Radiación!Q17","v":0.57334976816928807},0.54468227976082362,56.5,0.88,{"$f":"Radiación!R17","v":0.32737935625943465},0.28809383350830248,71,0.66,{"$f":"Radiación!S17","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T17","v":0.95498351114202529},0.86858400849990569,0.90952775452761692]
[null,"A (16)",228,{"$f":"Radiación!E18","v":13.454959682356431},37.339897772166275,0.96,{"$f":"Radiación!Q18","v":0.64890558375532348},0.62294936040511051,56.5,0.88,{"$f":"Radiación!R18","v":0.33675451100469544},0.29634396968413201,71,0.66,{"$f":"Radiación!S18","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T18","v":1.0399144814733214},0.95510122532002217,0.91844208570579933]
[null,"S (15)",258,{"$f":"Radiación!E19","v":2.2168867832133041},37.704811462626495,0.97,{"$f":"Radiación!Q19","v":0.72029661046218363},0.69868771214831815,56.5,0.88,{"$f":"Radiación!R19","v":0.39815554167053913},0.35037687667007444,71,0.66,{"$f":"Radiación!S19","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T19","v":1.1727065388460254},1.0848724840491724,0.92510141976074933]
[null,"O (15)",288,{"$f":"Radiación!E20","v":-9.5993972342263003},41.027819704377535,0.97,{"$f":"Radiación!Q20","v":0.89067509558486258},0.86395484271731671,56.5,0.88,{"$f":"Radiación!R20","v":0.42426715829122369},0.37335509929627686,71,0.66,{"$f":"Radiación!S20","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T20","v":1.3691966405893887},1.2731178372443732,0.92982833838705803]
[null,"N (14)",318,{"$f":"Radiación!E21","v":-18.911954741226136},45.35197829977524,0.96,{"$f":"Radiación!Q21","v":0.83660722557792055},0.80314293655480373,56.5,0.88,{"$f":"Radiación!R21","v":0.55568440402197483},0.48900227553933784,71,0.66,{"$f":"Radiación!S21","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T21","v":1.446546016313198},1.3279531073249211,0.91801649746992919]
[null,"D (10)",344,{"$f":"Radiación!E22","v":-23.049627643930584},47.641917981614306,0.95,{"$f":"Radiación!Q22","v":0.65881022196984729},0.6258697108713549,56.5,0.88,{"$f":"Radiación!R22","v":0.66652664583537269},0.58654344833512795,71,0.66,{"$f":"Radiación!S22","v":5.425438671330246E-2},3.5807895230779624E-2,{"$f":"Radiación!T22","v":1.3795912545185225},1.2482210544372625,0.90477599821614685]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(S9:S20)","v":0.91579344573879162}]

{"sheet":"Demanda_ACS","index":4,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Temperatura de referencia (ºC) ",45]
[null,"Número de viviendas ",10,"FC = ",{"$f":"IF(C3<=3,1,IF(C3<=10,0.95,IF(C3<=20,0.9,IF(C3<=50,0.85,IF(C3<=75,0.8,IF(C3<=100,0.75,0.7))))))","v":0.95}]
[null,"Número de habitantes por vivienda ",6]
[null,"Consumo unitario diario medio para "]
[null,"Litros por persona y día (a 45ºC) ",100]
[]
[null,null,"Días","T agua fría","Demanda ACS","Demanda ACS"]
[null,"Mes","por","(ºC)","(MJ/mes)","(kWh/mes)"]
[null,null,"mes","TAF","5.10","5.10"]
[null,"G",31,5,{"$f":"$C$6*C11*$C$4*$C$3*$E$3*4.186*(45-D11)/1000","v":29586.648000000001},{"$f":"(E11*1000)/3600","v":8218.5133333333342}]
[null,"F",28,6,{"$f":"$C$6*C12*$C$4*$C$3*$E$3*4.186*(45-D12)/1000","v":26055.338399999997},{"$f":"(E12*1000)/3600","v":7237.5939999999991}]
[null,"M",31,7,28107.315599999998,{"$f":"(E13*1000)/3600","v":7807.5876666666663}]
[null,"A",30,9,25769.016,7158.06]
[null,"M",31,11,25148.650799999996,6985.7363333333324]
[null,"J",30,13,22905.792000000001,6362.72]
[null,"J",31,16,21450.319799999997,5958.4221666666663]
[null,"A",31,16,21450.319799999997,5958.4221666666663]
[null,"S",30,14,22189.986000000001,6163.8850000000002]
[null,"O",31,11,25148.650799999996,6985.7363333333324]
[null,"N",30,7,27200.628000000001,7555.73]
[null,"D",31,6,28846.981799999998,8013.0504999999994]
[null,"Total anual",{"$f":"SUM(C11:C22)","v":365},null,{"$f":"SUM(E11:E22)","v":303859.647},{"$f":"SUM(F11:F22)","v":84405.45749999999}]

{"sheet":"Demanda_Climatización","index":5,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Área bruta cerramiento vertical exterior opaco",100,"m2"]
[null,null,null,"U cerramiento vertical exterior opaco",1.5,"W/m2K"]
[null,null,null,"Área neta huecos",20,"m2"]
[null,null,null,"U huecos",4,"W/m2K"]
[null,null,null,"Área de cubierta",25,"m2"]
[null,null,null,"U cubierta",1.5,"W/m2K"]
[null,null,null,"Área cerramientos en contacto con local no habitable",10,"m2"]
[null,null,null,"U cerramiento en contacto con local no habitable",2,"W/m2K"]
[null,null,null,"Volumen encerrado por cerramientos",100,"m3"]
[null,null,null,"Renovaciones por hora (infiltraciones)",1,"1/h"]
[null,null,null,null,"ê"]
[null,null,null,"UA estimado del edificio ",{"$f":"(E3-E5)*E4+E5*E6+0.5*E9*E10+0.8*E7*E8+(E11*(E12/3600)*1.2)*1000","v":273.33333333333331},"W/K"]
[]
[null,null,null,"UA calculado del edificio ",500,"W/K"]
[null,null,null,"Tipo de edificio"]
[null,null,null,"Coeficiente de uso (u)",1,null,null,null,null,null,null," ","COPR =",0.75]
[null,null,null,"Coeficiente de intermitencia (i)",0.85]
[]
[]
[null,null,"MES","DIAS","T ","GD ","GD ","GD ","GD ","Demanda ","Demanda ","Demanda ","Demanda ","Demanda ","Demanda "]
[null,null,null,null,"ambiente","diarios","mensuales","mensuales","mensuales","Calefacción","Calefacción","Refrigeración","Refrigeración","de Calor","de Calor"]
[null,null,null,null,null,null,null,"calefacción","refrigeración","(MJ/mes)","(kWh/mes)","(MJ/mes)","(kWh/mes)","Total","Total"]
[null,null,null,"NM","ºC","(20ºC-Ta)","NM·GD diarios","BBDD_Clima","BBDD_Clima","5.1","5.1","5.1","5.1","(MJ/mes)","(kWh/mes)"]
[null,null,"G",31,2.5,{"$f":"MAX(0,20-E26)","v":17.5},{"$f":"F26*D26","v":542.5},387,null,{"$f":"us*int*ua*H26*3600*24/1000000","v":14210.64},{"$f":"J26*1000/3600","v":3947.4},{"$f":"ua*I26*3600*24/1000000","v":0},{"$f":"L26*1000/3600","v":0},{"$f":"J26+L26/copabs","v":14210.64},{"$f":"K26+M26/copabs","v":3947.4}]
[null,null,"F",28,3.8,{"$f":"MAX(0,20-E27)","v":16.2},453.59999999999997,335.3,null,12312.216,{"$f":"J27*1000/3600","v":3420.06},0,{"$f":"L27*1000/3600","v":0},12312.216,3420.06]
[null,null,"M",31,7.1,12.9,399.90000000000003,328.2,null,12051.504000000001,{"$f":"J28*1000/3600","v":3347.64},0,0,12051.504000000001,3347.64]
[null,null,"A",30,9.1999999999999993,10.8,324,241.1,null,8853.1919999999991,2459.2199999999998,0,0,8853.1919999999991,2459.2199999999998]
[null,null,"M",31,12.2,7.8000000000000007,241.8,145.19999999999999,null,5331.7439999999988,1481.0399999999997,0,0,5331.7439999999988,1481.0399999999997]
[null,null,"J",30,16.2,3.8000000000000007,114.00000000000003,50.5,null,1854.36,515.1,0,0,1854.36,515.1]
[null,null,"J",31,19.2,0.80000000000000071,24.800000000000022,6.8,null,249.696,69.36,0,0,249.696,69.36]
[null,null,"A",31,18.8,1.1999999999999993,37.199999999999974,10.9,null,400.24799999999999,111.18,0,0,400.24799999999999,111.18]
[null,null,"S",30,16.2,3.8000000000000007,114.00000000000003,52.8,null,1938.816,538.55999999999995,0,0,1938.816,538.55999999999995]
[null,null,"O",31,11.3,8.6999999999999993,269.7,148.69999999999999,null,5460.2639999999992,1516.7399999999998,0,0,5460.2639999999992,1516.7399999999998]
[null,null,"N",30,6.5,13.5,405,284.60000000000002,null,10450.512000000002,2902.9200000000005,0,0,10450.512000000002,2902.9200000000005]
[null,null,"D",31,3.4,16.600000000000001,514.6,392.4,null,14408.928,4002.48,0,0,14408.928,4002.48]
[null,null,"Totales",{"$f":"SUM(D26:D37)","v":365},null,null,{"$f":"SUM(G26:G37)","v":3441.1},{"$f":"SUM(H26:H37)","v":2383.5},null,{"$f":"SUM(J26:J37)","v":87522.12},24311.7,0,0,87522.12,24311.7]

{"sheet":"Demanda_Piscinas","index":6,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[[10,4,10,5]]}
[null,"Implementa el cálculo de las necesidades térmicas para el calentamiento de piscinas (referencia perdida, aunque similar a la de J. A. Duffie & W. A. Beckman, sección 9.7, \"Swimming pool heating loads\")"]
[null,"Área de piscina ",50,null,"m2"]
[null,"Absortancia agua ",0.8,null,"-"]
[null,"Emitancia de la piscina",1,null,"-"]
[null,"Temperatura piscina ",25,null,"ºC"]
[null,"Humedad relativa media ",50,null,"%"]
[null,"Velocidad del viento ",4.4000000000000004,null,"m/s",null,"Viento superficie",{"$f":"C7/7.5","v":0.58666666666666667},"m/s"]
[null,"Grado de humedad sat. ",0.02,null,"kgw/kga"]
[]
[]
[null,null,null,null,"Hoja Radiación"]
[null,"MES","DIAS","Tambiente","H (MJ/dia-m2)","KT = H / He","HP (MJ/mes)","Tr (ºC)","TCielo (K)","TCielo ponderada","Segundos","LP Rad (MJ/mes)","wa (kgw/kga)","LP Evap (MJ/mes)","LP Conv (MJ/mes)","LP (MJ/mes)"]
[null,null,"NM","Anexo","Atlas de Radiación","2.19",null,"Diagrama psicrométrico",null," según KT","por mes",null,"Diagrama psicrométrico"]
[null,"G",31,{"$f":"Demanda_Climatización!E26","v":2.5},{"$f":"Radiación!D11/1000000","v":3.7080000000000002},{"$f":"Radiación!J11","v":0.26939587493366346},{"$f":"absortancia*areapiscina*E14*C14","v":4597.92},-5,{"$f":"(D14+273)*(0.711+0.0056*H14+0.000073*H14^2)^0.25","v":250.62044958835412},{"$f":"(1-F14)*I14+F14*(D14+273)","v":257.32289783945566},{"$f":"C14*24*3600","v":2678400},{"$f":"(emitancia*areapiscina*0.0000000567*((tpiscina+273)^4-J14^4)/1000000*K14)","v":26589.442073672853},2.5000000000000001E-3,{"$f":"areapiscina*101.3*(35*$H$7+43*((tpiscina+273)-(D14+273))^0.33)*(graupiscina-M14)*K14/1000000","v":33396.858576884246},{"$f":"N14*0.0006*(((tpiscina+273)-(D14+273))/(graupiscina-M14))","v":25763.290902167842},{"$f":"MAX(0,(L14+N14+O14-G14))","v":81151.671552724947}]
[null,"F",28,{"$f":"Demanda_Climatización!E27","v":3.8},{"$f":"Radiación!D12/1000000","v":7.9960000000000004},{"$f":"Radiación!J12","v":0.41678679423500775},8955.52,-2,253.19484805849558,263.03316366362549,{"$f":"C15*24*3600","v":2419200},21256.92962063829,3.0000000000000001E-3,{"$f":"areapiscina*101.3*(35*$H$7+43*((tpiscina+273)-(D15+273))^0.33)*(graupiscina-M15)*K15/1000000","v":28816.345872612415},{"$f":"N15*0.0006*(((tpiscina+273)-(D15+273))/(graupiscina-M15))","v":21561.407029389979},{"$f":"MAX(0,(L15+N15+O15-G15))","v":62679.162522640676}]
[null,"M",31,{"$f":"Demanda_Climatización!E28","v":7.1},{"$f":"Radiación!D13/1000000","v":10.78},{"$f":"Radiación!J13","v":0.4093010575728262},13367.199999999999,2,258.23872539614393,267.18656821139223,2678400,21183.758681298918,4.0000000000000001E-3,28638.503127634998,19223.595224424967,55678.65703335889]
[null,"A",30,{"$f":"Demanda_Climatización!E29","v":9.1999999999999993},{"$f":"Radiación!D14/1000000","v":14.385999999999999},{"$f":"Radiación!J14","v":0.42370508080142522},17263.199999999997,8,263.52863741234023,271.43978860621735,2592000,18058.298181647657,5.0000000000000001E-3,25097.396426930456,15861.55454182006,41754.049150398176]
[null,"M",31,{"$f":"Demanda_Climatización!E30","v":12.2},{"$f":"Radiación!D15/1000000","v":18.11},{"$f":"Radiación!J15","v":0.45902725339138273},22456.399999999998,11,268.14670090939791,275.97462995221872,2678400,15835.757568229363,6.4999999999999997E-3,22026.225161081831,12530.474758304339,27936.057487615541]
[null,"J",30,{"$f":"Demanda_Climatización!E31","v":16.2},{"$f":"Radiación!D16/1000000","v":21.434000000000001},{"$f":"Radiación!J16","v":0.5135402987273886},25720.799999999999,14,273.82485189145973,281.72061004409733,2592000,11662.583018752181,8.2500000000000004E-3,16763.116959300904,7532.7027697965004,10237.602747849585]
[null,"J",31,{"$f":"Demanda_Climatización!E32","v":19.2},{"$f":"Radiación!D17/1000000","v":22.963999999999999},{"$f":"Radiación!J17","v":0.56643785219748422},28475.359999999997,9,273.47860167761706,284.08311033348127,2678400,10426.627698613047,0.01,13205.256461609149,4595.4292486399927,0]
[null,"A",31,{"$f":"Demanda_Climatización!E33","v":18.8},{"$f":"Radiación!D18/1000000","v":20.079999999999998},{"$f":"Radiación!J18","v":0.5573164627614049},24899.199999999997,10,273.72382638791913,283.79797552566509,2678400,10624.881289678458,8.5000000000000006E-3,15452.684011048697,4998.6073496609606,6176.9726503881175]
[null,"S",30,{"$f":"Demanda_Climatización!E34","v":16.2},{"$f":"Radiación!D19/1000000","v":14.452},{"$f":"Radiación!J19","v":0.49757742615905742},17342.400000000001,5,268.30403006346791,278.70139300158462,2592000,13615.170668069786,7.6E-3,17690.438323006911,7532.7027697964986,{"$f":"MAX(0,(L22+N22+O22-G22))","v":21495.911760873198}]
[null,"O",31,{"$f":"Demanda_Climatización!E35","v":11.3},{"$f":"Radiación!D20/1000000","v":10.034000000000001},{"$f":"Radiación!J20","v":0.47217259493499009},12442.16,0,261.06236009790621,272.03453683064271,2678400,18297.773785584559,5.4999999999999997E-3,24102.691460743838,13663.732676366493,43622.037922694886]
[null,"N",30,{"$f":"Demanda_Climatización!E36","v":6.5},{"$f":"Radiación!D21/1000000","v":5.17},{"$f":"Radiación!J21","v":0.34431253187490418},6204,-4,254.71678990780038,263.24995972263332,2592000,22659.172210409077,3.5000000000000001E-3,28844.765600658171,19404.660494988224,64704.598306055472]
[null,"D",31,{"$f":"Demanda_Climatización!E37","v":3.4},{"$f":"Radiación!D22/1000000","v":2.91},{"$f":"Radiación!J22","v":0.23647055155354926},3608.4,-5,251.43917338011281,257.34167381815007,2678400,26579.724140493188,2.5000000000000001E-3,33015.206334375842,24450.118519629214,80436.648994498246]
[null,"Totales",{"$f":"SUM(C14:C25)","v":365},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P14:P25)","v":495873.37012909778}]

{"sheet":"Demandas_Totales","index":7,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"MES","ACS","Calefacción","Refrigeración con COPr","Piscina","R",null,"R","Demanda total","Demanda total"]
[null,null,"(MJ/mes)","(MJ/mes)","(MJ/mes)","(MJ/mes)",null,null,null,"(MJ/mes)","(kWh/mes)"]
[null,"G",{"$f":"Demanda_ACS!E11","v":29586.648000000001},{"$f":"Demanda_Climatización!J26","v":14210.64},{"$f":"Demanda_Climatización!L26/copabs","v":0},{"$f":"Demanda_Piscinas!P14","v":81151.671552724947},null,null,null,29586.648000000001,{"$f":"J5*1000/3600","v":8218.5133333333342}]
[null,"F",{"$f":"Demanda_ACS!E12","v":26055.338399999997},{"$f":"Demanda_Climatización!J27","v":12312.216},{"$f":"Demanda_Climatización!L27/copabs","v":0},{"$f":"Demanda_Piscinas!P15","v":62679.162522640676},null,null,null,26055.338399999997,{"$f":"J6*1000/3600","v":7237.5939999999991}]
[null,"M",{"$f":"Demanda_ACS!E13","v":28107.315599999998},{"$f":"Demanda_Climatización!J28","v":12051.504000000001},{"$f":"Demanda_Climatización!L28/copabs","v":0},{"$f":"Demanda_Piscinas!P16","v":55678.65703335889},null,null,null,28107.315599999998,7807.5876666666663]
[null,"A",{"$f":"Demanda_ACS!E14","v":25769.016},{"$f":"Demanda_Climatización!J29","v":8853.1919999999991},{"$f":"Demanda_Climatización!L29/copabs","v":0},{"$f":"Demanda_Piscinas!P17","v":41754.049150398176},null,null,null,25769.016,7158.06]
[null,"M",{"$f":"Demanda_ACS!E15","v":25148.650799999996},{"$f":"Demanda_Climatización!J30","v":5331.7439999999988},{"$f":"Demanda_Climatización!L30/copabs","v":0},{"$f":"Demanda_Piscinas!P18","v":27936.057487615541},null,null,null,25148.650799999996,6985.7363333333324]
[null,"J",{"$f":"Demanda_ACS!E16","v":22905.792000000001},{"$f":"Demanda_Climatización!J31","v":1854.36},{"$f":"Demanda_Climatización!L31/copabs","v":0},{"$f":"Demanda_Piscinas!P19","v":10237.602747849585},null,null,null,22905.792000000001,6362.72]
[null,"J",{"$f":"Demanda_ACS!E17","v":21450.319799999997},{"$f":"Demanda_Climatización!J32","v":249.696},{"$f":"Demanda_Climatización!L32/copabs","v":0},{"$f":"Demanda_Piscinas!P20","v":0},null,null,null,21450.319799999997,5958.4221666666663]
[null,"A",{"$f":"Demanda_ACS!E18","v":21450.319799999997},{"$f":"Demanda_Climatización!J33","v":400.24799999999999},{"$f":"Demanda_Climatización!L33/copabs","v":0},{"$f":"Demanda_Piscinas!P21","v":6176.9726503881175},null,null,null,21450.319799999997,5958.4221666666663]
[null,"S",{"$f":"Demanda_ACS!E19","v":22189.986000000001},{"$f":"Demanda_Climatización!J34","v":1938.816},{"$f":"Demanda_Climatización!L34/copabs","v":0},{"$f":"Demanda_Piscinas!P22","v":21495.911760873198},null,null,null,22189.986000000001,6163.8850000000002]
[null,"O",{"$f":"Demanda_ACS!E20","v":25148.650799999996},{"$f":"Demanda_Climatización!J35","v":5460.2639999999992},{"$f":"Demanda_Climatización!L35/copabs","v":0},{"$f":"Demanda_Piscinas!P23","v":43622.037922694886},null,null,null,25148.650799999996,6985.7363333333324]
[null,"N",{"$f":"Demanda_ACS!E21","v":27200.628000000001},{"$f":"Demanda_Climatización!J36","v":10450.512000000002},{"$f":"Demanda_Climatización!L36/copabs","v":0},{"$f":"Demanda_Piscinas!P24","v":64704.598306055472},null,null,null,27200.628000000001,7555.73]
[null,"D",{"$f":"Demanda_ACS!E22","v":28846.981799999998},{"$f":"Demanda_Climatización!J37","v":14408.928},{"$f":"Demanda_Climatización!L37/copabs","v":0},{"$f":"Demanda_Piscinas!P25","v":80436.648994498246},null,null,null,28846.981799999998,8013.0504999999994]
[null,"Totales",{"$f":"SUM(C5:C16)","v":303859.647},87522.12,0,{"$f":"SUM(F5:F16)","v":495873.37012909778},null,null,null,303859.647,84405.45749999999]

{"sheet":"Curvas_f","index":8,"n_rows":49,"n_cols":53,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Captador",null,null,null,null,"Roca"]
[null,null,"FR(ta)",null,null,null,null,0.78400000000000003]
[null,null,"FRUL",null,null,null,null,4.9000000000000004]
[null,null,"F'R/FR (Factor Capt-Inter.)",null,null,null,null,0.96]
[]
[]
[true,null,null,null,null,null,null,"Capacidad de almacenaje",null,null,75,null,null,"l/m2"]
[]
[false,null,null,null,null,null,null,"Caudal circulante",null,null,10,null,null,"l/s·m2"]
[null,null,null,null,null,null,null,"Capacidad de almacenaje",null,null,0.26,null,null,"m3/m2"]
[]
[null,null,"Rango de áreas de prueba (m2)",null,null,null,null,1,"Mínimo",400,"Máximo"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fracción",null,null,null,"Fracción",null,null,null,"Fracción",null,null,null,"Fracción",null,null,null,"Fracción",null,null,null,"Fracción",null,null,null,"Fracción",null,null,null,"Fracción",null,null,null,"Fracción",null,null,null,"Fracción"]
[null,null,"Mes","Días","Segundos","Ta","(100-Ta)","Demanda","X/A ","XC/A ","HTOT","(ta) / (ta)n","Y/A ",null,null,null," energía",null,null,null," energía",null,null,null," energía",null,null,null," energía",null,null,null," energía",null,null,null," energía",null,null,null," energía",null,null,null," energía",null,null,null," energía",null,null,null," energía"]
[null,null,null,null,null,null,null,null,null,"(ACS)",null,null,null,"Área =",{"$f":"H14","v":1},"m2","solar","Área =",{"$f":"O21+($J$14-$H$14)/9","v":45.333333333333336},"m2","solar","Área =",{"$f":"S21+($J$14-$H$14)/9","v":89.666666666666671},"m2","solar","Área =",{"$f":"W21+($J$14-$H$14)/9","v":134},"m2","solar","Área =",{"$f":"AA21+($J$14-$H$14)/9","v":178.33333333333334},"m2","solar","Área =",{"$f":"AE21+($J$14-$H$14)/9","v":222.66666666666669},"m2","solar","Área =",{"$f":"AI21+($J$14-$H$14)/9","v":267},"m2","solar","Área =",{"$f":"AM21+($J$14-$H$14)/9","v":311.33333333333331},"m2","solar","Área =",{"$f":"AQ21+($J$14-$H$14)/9","v":355.66666666666663},"m2","solar","Área =",{"$f":"J14","v":400},"m2","solar"]
[null,null,null,null,"por mes",null,null,"(MJ/mes)","(1/m2)","(1/m2)","(J/dia-m2)",null,"(1/m2)","X","Y","f"," (MJ/mes)","X","Y","f"," (MJ/mes)","X","Y","f"," (MJ/mes)","X","Y","f"," (MJ/mes)","X","Y","f"," (MJ/mes)","X","Y","f"," (MJ/mes)","X","Y","f"," (MJ/mes)","X","Y","f"," (MJ/mes)","X","Y","f"," (MJ/mes)","X","Y","f"," (MJ/mes)"]
[null,null,"G",31,{"$f":"D23*24*3600","v":2678400},{"$f":"Demanda_Climatización!E26","v":2.5},{"$f":"100-(F23)","v":97.5},{"$f":"Demandas_Totales!J5","v":29586.648000000001},{"$f":"frul*fcb*G23*E23/(H23*1000000)","v":4.1519450800915333E-2},3.3300728744939265E-2,{"$f":"Radiación!U11","v":5134191.3202646542},{"$f":"Angulo_Incidencia!S9","v":0.9116900842383987},{"$f":"frta*fcb*D23*K23*L23/(H23*1000000)","v":3.6912418766698219E-3},{"$f":"IF($A$9=TRUE,area1*J23*(cap_alm/75)^-0.25,area1*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":3.3300728744939265E-2},{"$f":"area1*M23","v":3.6912418766698219E-3},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*O23-0.065*N23-0.245*(O23)^2+0.0018*(N23)^2+0.0215*(O23)^3)),(MIN(1,1.04*O23-0.065*N23-0.159*(O23)^2+0.00187*(N23)^2+0.0095*(O23)^3)))","v":1.6323995030443582E-3},{"$f":"IF(P23<0,0,$H23*P23)","v":48.297229491948357},{"$f":"IF($A$9=TRUE,area2*J23*(cap_alm/75)^-0.25,area2*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":1.5096330364372468},{"$f":"area2*M23","v":0.16733629840903194},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*S23-0.065*R23-0.245*(S23)^2+0.0018*(R23)^2+0.0215*(S23)^3)),(MIN(1,1.04*S23-0.065*R23-0.159*(S23)^2+0.00187*(R23)^2+0.0095*(S23)^3)))","v":7.1405478736191033E-2},{"$f":"IF(T23<0,0,$H23*T23)","v":2112.6487646391693},{"$f":"IF($A$9=TRUE,area3*J23*(cap_alm/75)^-0.25,area3*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":2.9859653441295544},{"$f":"area3*M23","v":0.33098135494139402},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*W23-0.065*V23-0.245*(W23)^2+0.0018*(V23)^2+0.0215*(W23)^3)),(MIN(1,1.04*W23-0.065*V23-0.159*(W23)^2+0.00187*(V23)^2+0.0095*(W23)^3)))","v":0.13648098519374932},{"$f":"IF(X23<0,0,$H23*X23)","v":4038.0148676206732},{"$f":"IF($A$9=TRUE,area4*J23*(cap_alm/75)^-0.25,area4*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":4.4622976518218618},{"$f":"area4*M23","v":0.49462641147375613},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AA23-0.065*Z23-0.245*(AA23)^2+0.0018*(Z23)^2+0.0215*(AA23)^3)),(MIN(1,1.04*AA23-0.065*Z23-0.159*(AA23)^2+0.00187*(Z23)^2+0.0095*(AA23)^3)))","v":0.19742424412342963},{"$f":"IF(AB23<0,0,$H23*AB23)","v":5841.1216175459813},{"$f":"IF($A$9=TRUE,area5*J23*(cap_alm/75)^-0.25,area5*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":5.9386299595141692},{"$f":"area5*M23","v":0.65827146800611824},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AE23-0.065*AD23-0.245*(AE23)^2+0.0018*(AD23)^2+0.0215*(AE23)^3)),(MIN(1,1.04*AE23-0.065*AD23-0.159*(AE23)^2+0.00187*(AD23)^2+0.0095*(AE23)^3)))","v":0.2548005807729421},{"$f":"IF(AF23<0,0,$H23*AF23)","v":7538.6950935246059},{"$f":"IF($A$9=TRUE,area6*J23*(cap_alm/75)^-0.25,area6*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":7.4149622672064766},{"$f":"area6*M23","v":0.82191652453848041},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AI23-0.065*AH23-0.245*(AI23)^2+0.0018*(AH23)^2+0.0215*(AI23)^3)),(MIN(1,1.04*AI23-0.065*AH23-0.159*(AI23)^2+0.00187*(AH23)^2+0.0095*(AI23)^3)))","v":0.30917532038999684},{"$f":"IF(AJ23<0,0,$H23*AJ23)","v":9147.4613746660598},{"$f":"IF($A$9=TRUE,area7*J23*(cap_alm/75)^-0.25,area7*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":8.8912945748987831},{"$f":"area7*M23","v":0.98556158107084246},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AM23-0.065*AL23-0.245*(AM23)^2+0.0018*(AL23)^2+0.0215*(AM23)^3)),(MIN(1,1.04*AM23-0.065*AL23-0.159*(AM23)^2+0.00187*(AL23)^2+0.0095*(AM23)^3)))","v":0.36111378822230411},{"$f":"IF(AN23<0,0,$H23*AN23)","v":10684.146540079857},{"$f":"IF($A$9=TRUE,area8*J23*(cap_alm/75)^-0.25,area8*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":10.367626882591091},{"$f":"area8*M23","v":1.1492066376032044},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AQ23-0.065*AP23-0.245*(AQ23)^2+0.0018*(AP23)^2+0.0215*(AQ23)^3)),(MIN(1,1.04*AQ23-0.065*AP23-0.159*(AQ23)^2+0.00187*(AP23)^2+0.0095*(AQ23)^3)))","v":0.41118130951757409},{"$f":"IF(AR23<0,0,$H23*AR23)","v":12165.476668875515},{"$f":"IF($A$9=TRUE,area9*J23*(cap_alm/75)^-0.25,area9*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":11.843959190283398},{"$f":"area9*M23","v":1.3128516941355666},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AU23-0.065*AT23-0.245*(AU23)^2+0.0018*(AT23)^2+0.0215*(AU23)^3)),(MIN(1,1.04*AU23-0.065*AT23-0.159*(AU23)^2+0.00187*(AT23)^2+0.0095*(AU23)^3)))","v":0.45994320952351714},{"$f":"IF(AV23<0,0,$H23*AV23)","v":13608.177840162551},{"$f":"IF($A$9=TRUE,area10*J23*(cap_alm/75)^-0.25,area10*J23*((cau_circ/10.1)^0.28)*((cap_alm_aire/0.25)^-0.3))","v":13.320291497975706},{"$f":"area10*M23","v":1.4764967506679287},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AY23-0.065*AX23-0.245*(AY23)^2+0.0018*(AX23)^2+0.0215*(AY23)^3)),(MIN(1,1.04*AY23-0.065*AX23-0.159*(AY23)^2+0.00187*(AX23)^2+0.0095*(AY23)^3)))","v":0.50796481348784328},{"$f":"IF(AZ23<0,0,$H23*AZ23)","v":15028.976133050472}]
[null,null,"F",29,2505600,{"$f":"Demanda_Climatización!E27","v":3.8},{"$f":"100-(F24)","v":96.2},{"$f":"Demandas_Totales!J6","v":26055.338399999997},4.3516845625770115E-2,3.5756190703153556E-2,{"$f":"Radiación!U12","v":11123504.883784743},{"$f":"Angulo_Incidencia!S10","v":0.92677891589426287},8.6358754568711619E-3,3.5756190703153556E-2,{"$f":"area1*M24","v":8.6358754568711619E-3},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*O24-0.065*N24-0.245*(O24)^2+0.0018*(N24)^2+0.0215*(O24)^3)),(MIN(1,1.04*O24-0.065*N24-0.159*(O24)^2+0.00187*(N24)^2+0.0095*(O24)^3)))","v":6.5462069112857263E-3},{"$f":"IF(P24<0,0,H24*P24)","v":170.56363630996836},1.6209473118762947,{"$f":"area2*M24","v":0.39149302071149267},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*S24-0.065*R24-0.245*(S24)^2+0.0018*(R24)^2+0.0215*(S24)^3)),(MIN(1,1.04*S24-0.065*R24-0.159*(S24)^2+0.00187*(R24)^2+0.0095*(S24)^3)))","v":0.26595388883810234},{"$f":"IF(T24<0,0,$H24*T24)","v":6929.518572472738},3.2061384330494356,{"$f":"area3*M24","v":0.77435016596611417},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*W24-0.065*V24-0.245*(W24)^2+0.0018*(V24)^2+0.0215*(W24)^3)),(MIN(1,1.04*W24-0.065*V24-0.159*(W24)^2+0.00187*(V24)^2+0.0095*(W24)^3)))","v":0.46998641161100702},{"$f":"IF(X24<0,0,$H24*X24)","v":12245.654997926475},4.7913295542225764,{"$f":"area4*M24","v":1.1572073112207357},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AA24-0.065*Z24-0.245*(AA24)^2+0.0018*(Z24)^2+0.0215*(AA24)^3)),(MIN(1,1.04*AA24-0.065*Z24-0.159*(AA24)^2+0.00187*(Z24)^2+0.0095*(AA24)^3)))","v":0.62588313200739887},{"$f":"IF(AB24<0,0,$H24*AB24)","v":16307.596803304647},6.3765206753957182,{"$f":"area5*M24","v":1.5400644564753574},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AE24-0.065*AD24-0.245*(AE24)^2+0.0018*(AD24)^2+0.0215*(AE24)^3)),(MIN(1,1.04*AE24-0.065*AD24-0.159*(AE24)^2+0.00187*(AD24)^2+0.0095*(AE24)^3)))","v":0.74088340680467812},{"$f":"IF(AF24<0,0,$H24*AF24)","v":19303.96787924075},7.9617117965688591,{"$f":"area6*M24","v":1.9229216017299788},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AI24-0.065*AH24-0.245*(AI24)^2+0.0018*(AH24)^2+0.0215*(AI24)^3)),(MIN(1,1.04*AI24-0.065*AH24-0.159*(AI24)^2+0.00187*(AH24)^2+0.0095*(AI24)^3)))","v":0.82222659278024346},{"$f":"IF(AJ24<0,0,$H24*AJ24)","v":21423.392116368239},9.5469029177419991,{"$f":"area7*M24","v":2.3057787469846001},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AM24-0.065*AL24-0.245*(AM24)^2+0.0018*(AL24)^2+0.0215*(AM24)^3)),(MIN(1,1.04*AM24-0.065*AL24-0.159*(AM24)^2+0.00187*(AL24)^2+0.0095*(AM24)^3)))","v":0.87715204671149505},{"$f":"IF(AN24<0,0,$H24*AN24)","v":22854.493405320609},11.13209403891514,{"$f":"area8*M24","v":2.6886358922392217},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AQ24-0.065*AP24-0.245*(AQ24)^2+0.0018*(AP24)^2+0.0215*(AQ24)^3)),(MIN(1,1.04*AQ24-0.065*AP24-0.159*(AQ24)^2+0.00187*(AP24)^2+0.0095*(AQ24)^3)))","v":0.91289912537583173},{"$f":"IF(AR24<0,0,$H24*AR24)","v":23785.895636731319},12.717285160088281,{"$f":"area9*M24","v":3.0714930374938429},{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AU24-0.065*AT24-0.245*(AU24)^2+0.0018*(AT24)^2+0.0215*(AU24)^3)),(MIN(1,1.04*AU24-0.065*AT24-0.159*(AU24)^2+0.00187*(AT24)^2+0.0095*(AU24)^3)))","v":0.93670718555065391},{"$f":"IF(AV24<0,0,$H24*AV24)","v":24406.222701233874},14.302476281261423,3.4543501827484646,{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AY24-0.065*AX24-0.245*(AY24)^2+0.0018*(AX24)^2+0.0215*(AY24)^3)),(MIN(1,1.04*AY24-0.065*AX24-0.159*(AY24)^2+0.00187*(AX24)^2+0.0095*(AY24)^3)))","v":0.95581558401336042},{"$f":"IF(AZ24<0,0,$H24*AZ24)","v":24904.098489461732}]
[null,null,"M",31,2678400,{"$f":"Demanda_Climatización!E28","v":7.1},92.9,{"$f":"Demandas_Totales!J7","v":28107.315599999998},4.1642720425425481E-2,3.3730155291414599E-2,{"$f":"Radiación!U13","v":12908338.000002015},{"$f":"Angulo_Incidencia!S11","v":0.91920908558115888},9.849501631608153E-3,3.3730155291414599E-2,9.849501631608153E-3,7.9209774236951302E-3,222.63741230827392,1.5291003732107953,0.44651074063290297,0.3173445588724681,8919.7036701712404,3.0244705911301759,0.8831719796341978,0.55237117253803014,15525.670874868465,4.5198408090495565,1.3198332186354924,0.72374129712767044,20342.425051120805,6.0152110269689372,1.7564944576367874,0.84219541134867804,23671.852223649115,7.5105812448883178,2.1931556966380823,0.91847399390834228,25815.838417174251,9.0059514628076975,2.629816935639377,0.96331752351395217,27076.269656417073,10.501321680727077,3.0664781746406713,0.98746647887279704,27755.031966098435,11.996691898646457,3.503139413641966,1,28107.315599999998,13.49206211656584,3.9398006526432612,1,28107.315599999998]
[null,null,"A",30,2592000,{"$f":"Demanda_Climatización!E29","v":9.1999999999999993},90.8,{"$f":"Demandas_Totales!J8","v":25769.016},4.2962577011089589E-2,3.6951601478612914E-2,{"$f":"Radiación!U14","v":15254088.498515412},{"$f":"Angulo_Incidencia!S12","v":0.91389894560983498},1.221504730578437E-2,3.6951601478612914E-2,1.221504730578437E-2,1.0133370716175441E-2,261.12699211905641,1.6751392670304521,0.55374881119555808,0.39449889760882578,10165.848404464194,3.3133269325822914,1.0952825750853319,0.66577730781557332,17156.426097536434,4.9515145981341302,1.6368163389751056,0.84445503344097961,21760.775268021138,6.5897022636859699,2.1783501028648793,0.9510185065896064,24506.811112603671,8.2278899292378096,2.7198838667546532,1,25769.016,9.8660775947896475,3.2614176306444267,1,25769.016,11.504265260341487,3.8029513945342002,1,25769.016,13.142452925893325,4.3444851584239741,1,25769.016,14.780640591445165,4.886018922313748,1,25769.016]
[null,null,"M",31,2678400,{"$f":"Demanda_Climatización!E30","v":12.2},87.8,{"$f":"Demandas_Totales!J9","v":25148.650799999996},4.398682087867712E-2,3.950597661969206E-2,{"$f":"Radiación!U15","v":17694914.519521493},{"$f":"Angulo_Incidencia!S13","v":0.90749807013344175},1.4898017433516477E-2,3.950597661969206E-2,1.4898017433516477E-2,1.2710673875020622E-2,319.65629871557644,1.7909376067593734,0.67537679031941367,0.47919575017660765,12051.126586035542,3.5423692368990549,1.3358555632053108,0.78097621289213826,19640.498061130838,5.293800867038736,1.996334336091208,0.95521981477657047,24022.489559056648,7.0452324971784179,2.6568131089771052,1,25148.650799999996,8.796664127318099,3.3172918818630026,1,25148.650799999996,10.54809575745778,3.9777706547488996,1,25148.650799999996,12.299527387597461,4.6382494276347961,1,25148.650799999996,14.05095901773714,5.298728200520693,1,25148.650799999996,15.802390647876823,5.9592069734065909,1,25148.650799999996]
[null,null,"J",30,2592000,{"$f":"Demanda_Climatización!E31","v":16.2},83.8,{"$f":"Demandas_Totales!J10","v":22905.792000000001},4.4606794578419283E-2,4.1144711142404491E-2,{"$f":"Radiación!U16","v":20112466.78225971},{"$f":"Angulo_Incidencia!S14","v":0.90475415334110265},1.7937386373707596E-2,4.1144711142404491E-2,1.7937386373707596E-2,1.570750692706431E-2,359.79288650989429,1.8652269051223371,0.8131615156080777,0.5713243197150607,13086.63603193468,3.6893090991022697,1.6083856448424478,0.89538787359095606,20509.568391796733,5.5133912930822015,2.4036097740768176,1,22905.792000000001,7.3374734870621348,3.1988339033111881,1,22905.792000000001,9.1615556810420671,3.9940580325455581,1,22905.792000000001,10.985637875021999,4.7892821617799282,1,22905.792000000001,12.809720069001932,5.5845062910142982,{"$f":"IF($A$9=TRUE,(MIN(1,1.029*AQ28-0.065*AP28-0.245*(AQ28)^2+0.0018*(AP28)^2+0.0215*(AQ28)^3)),(MIN(1,1.04*AQ28-0.065*AP28-0.159*(AQ28)^2+0.00187*(AP28)^2+0.0095*(AQ28)^3)))","v":1},22905.792000000001,14.633802262981863,6.3797304202486673,1,22905.792000000001,16.457884456961796,7.1749545494830382,1,22905.792000000001]
[null,null,"J",31,2678400,{"$f":"Demanda_Climatización!E32","v":19.2},80.8,{"$f":"Demandas_Totales!J11","v":21450.319799999997},4.7459191861559107E-2,4.8114692580835082E-2,{"$f":"Radiación!U17","v":21930241.34986547},{"$f":"Angulo_Incidencia!S15","v":0.90952775452761692},2.1695745893920919E-2,4.8114692580835082E-2,2.1695745893920919E-2,1.9086531293669676E-2,409.41220012192224,2.1811993969978571,0.98354048052441501,0.66230345847853478,14206.620989010591,4.3142841014148789,1.9453852151549091,0.98595877531914633,21149.131040212033,6.4473688058319008,2.9072299497854033,1,21450.319799999997,8.5804535102489226,3.8690746844158972,1,21450.319799999997,10.713538214665945,4.830919419046392,1,21450.319799999997,12.846622919082966,5.7927641536768855,1,21450.319799999997,14.979707623499987,6.7546088883073789,1,21450.319799999997,17.11279232791701,7.7164536229378724,1,21450.319799999997,19.245877032334032,8.6782983575683676,1,21450.319799999997]
[null,null,"A",31,2678400,{"$f":"Demanda_Climatización!E33","v":18.8},81.2,{"$f":"Demandas_Totales!J12","v":21450.319799999997},4.769413835592326E-2,4.8659768447759918E-2,{"$f":"Radiación!U18","v":20881482.787984293},{"$f":"Angulo_Incidencia!S16","v":0.91844208570579933},2.0860673647264308E-2,4.8659768447759918E-2,2.0860673647264308E-2,1.8200589312385686E-2,{"$f":"IF(P30<0,0,H30*P30)","v":390.40846129913501},2.2059095029651163,0.94568387200931536,0.63755900126797205,13675.844468566604,4.3631592374824733,1.8705070703713664,0.95891538401992593,20569.04164836722,6.5204089719998288,2.7953302687334172,1,21450.319799999997,8.6776587065171853,3.7201534670954683,1,21450.319799999997,10.834908441034543,4.64497666545752,1,21450.319799999997,12.992158175551898,5.5697998638195703,1,21450.319799999997,15.149407910069254,6.4946230621816206,1,21450.319799999997,17.306657644586608,7.4194462605436717,1,21450.319799999997,19.463907379103969,8.3442694589057229,1,21450.319799999997]
[null,null,"S",30,2592000,{"$f":"Demanda_Climatización!E34","v":16.2},83.8,{"$f":"Demandas_Totales!J13","v":22189.986000000001},4.6045723435787653E-2,4.4592920419508138E-2,{"$f":"Radiación!U19","v":16947954.89940276},{"$f":"Angulo_Incidencia!S17","v":0.92510141976074933},1.59535805451935E-2,4.4592920419508138E-2,1.59535805451935E-2,1.3459004605480447E-2,298.65512376954666,2.0215457256843692,0.72322898471543873,0.50014166149839179,11098.136466666054,3.99849853094923,1.4305043888856839,0.80244800780285952,17806.310058873343,5.9754513362140909,2.137779793055929,0.96601906723427333,21435.949577661584,7.9524041414789517,2.8450551972261744,1,22189.986000000001,9.9293569467438125,3.5523306013964198,1,22189.986000000001,11.906309752008672,4.2596060055666642,1,22189.986000000001,13.883262557273532,4.9668814097369092,1,22189.986000000001,15.860215362538392,5.6741568139071541,1,22189.986000000001,17.837168167803256,6.3814322180773999,1,22189.986000000001]
[null,null,"O",31,2678400,{"$f":"Demanda_Climatización!E35","v":11.3},88.7,{"$f":"Demandas_Totales!J14","v":25148.650799999996},4.4437710842125978E-2,4.0552041334893402E-2,{"$f":"Radiación!U20","v":13738519.091673927},{"$f":"Angulo_Incidencia!S18","v":0.92982833838705803},1.1851600363961812E-2,4.0552041334893402E-2,1.1851600363961812E-2,9.5279971152486664E-3,239.61627227479602,1.8383592071818342,0.53727254983293549,0.37205561854400115,9356.696828941087,3.6361663730287752,1.0626934993019093,0.63007963040406145,15845.652601224801,5.4339735388757155,1.5881144487708829,0.80231167319673635,20177.056101988437,7.2317807047226568,2.1135353982398568,0.90746338742333266,22821.479844094501,9.029587870569598,2.6389563477088305,0.96424641358515717,24249.496340405491,10.827395036416538,3.1643772971778037,0.99137239218351714,24931.678103783917,12.625202202263479,3.6897982466467774,1,25148.650799999996,14.423009368110419,4.2152191961157506,1,25148.650799999996,16.220816533957361,4.7406401455847247,1,25148.650799999996]
[null,null,"N",30,2592000,{"$f":"Demanda_Climatización!E36","v":6.5},93.5,{"$f":"Demandas_Totales!J15","v":27200.628000000001},4.1911672333447593E-2,3.4354123718025917E-2,{"$f":"Radiación!U21","v":7478642.9043392334},{"$f":"Angulo_Incidencia!S19","v":0.91801649746992919},5.6990557056516896E-3,3.4354123718025917E-2,5.6990557056516896E-3,3.6254812167800942E-3,98.615365898622699,1.5573869418838417,0.25835719198954327,0.15300261541339411,4161.7672248867993,3.0804197600496575,0.51101532827343488,0.28157824394046782,7659.1050663179194,4.6034525782154727,0.76367346455732643,0.39143297149755213,10647.222644639518,6.1264853963812884,1.016331600841218,0.48464740278419816,13182.713714299138,7.649518214547105,1.2689897371251098,0.56330214249995691,15322.172029744319,9.1725510327129189,1.5216478734090011,0.62947779534437898,17122.191345422583,10.695583850878736,1.7743060096928926,0.68525496601701597,18639.365415781493,12.21861666904455,2.026964145976784,0.7327142592174184,19930.287995268569,13.741649487210367,2.279622282260676,0.77393627964513767,21051.552838331361]
[null,null,"D",31,2678400,{"$f":"Demanda_Climatización!E37","v":3.4},96.6,{"$f":"Demandas_Totales!J16","v":28846.981799999998},4.2190968545624423E-2,3.4928531434064963E-2,{"$f":"Radiación!U22","v":4014610.5506489007},{"$f":"Angulo_Incidencia!S20","v":0.90477599821614685},2.9378735673094222E-3,3.4928531434064963E-2,2.9378735673094222E-3,7.5279928711023995E-4,{"$f":"IF(P34<0,0,H34*P34)","v":21.715987334322065},1.5834267583442785,0.13318360171802715,3.4341232294378181E-2,990.64090298549957,3.1319249852544919,0.2634293298687449,6.8541030549143386E-2,1977.2018608043832,4.6804232121647047,0.39367505801946256,0.1036372172269787,2989.6209191493008,6.2289214390749184,0.52392078617018034,0.13991481550345705,4036.1201363785831,7.7774196659851329,0.65416651432089812,0.17765884855415134,5124.9215708505599,9.3259178928953457,0.78441224247161578,0.21715433955463459,6264.2472809235633,10.874416119805558,0.91465797062233345,0.25868631168047967,7462.3193249559245,12.422914346715771,1.0449036987730511,0.30253978810725929,8727.3597613059646,13.971412573625985,1.175149426923769,0.34899979201054671,10067.590648332025]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total=",{"$f":"SUM(Q23:Q34)","v":2840.4978661530622},null,null,"Total=",{"$f":"SUM(U23:U34)","v":106755.1889107742},null,null,"Total=",{"$f":"SUM(Y23:Y34)","v":174122.27556667931},null,null,"Total=",{"$f":"SUM(AC23:AC34)","v":209330.68914248806},null,null,"Total=",{"$f":"SUM(AG23:AG34)","v":228206.7084037904},null,null,"Total=",{"$f":"SUM(AK23:AK34)","v":239997.36624920892},null,null,"Total=",{"$f":"SUM(AO23:AO34)","v":247847.11073194759},null,null,"Total=",{"$f":"SUM(AS23:AS34)","v":253870.82421244271},null,null,"Total=",{"$f":"SUM(AW23:AW34)","v":258842.09909797093},null,null,"Total=",{"$f":"SUM(BA23:BA34)","v":263222.26890917559}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H23:H34)","v":303859.647},"MJ/año",null,null,null,null,null,null,"fanual =",{"$f":"Q35/cartotal","v":9.3480588626928211E-3},null,null,"fanual =",{"$f":"U35/cartotal","v":0.35133058951646251},null,null,"fanual =",{"$f":"Y35/cartotal","v":0.57303520650334761},null,null,"fanual =",{"$f":"AC35/cartotal","v":0.68890585245262281},null,null,"fanual =",{"$f":"AG35/cartotal","v":0.75102670149482009},null,null,"fanual =",{"$f":"AK35/cartotal","v":0.78982967504470547},null,null,"fanual =",{"$f":"AO35/cartotal","v":0.81566312993165424},null,null,"fanual =",{"$f":"AS35/cartotal","v":0.83548712939972158},null,null,"fanual =",{"$f":"AW35/cartotal","v":0.85184756071927814},null,null,"fanual =",{"$f":"BA35/cartotal","v":0.86626266932106188}]
[]
[null,null,null,"Área","Fracción"]
[null,null,null,"(m2)","anual"]
[null,null,null,0,0]
[null,null,null,{"$f":"area1","v":1},{"$f":"factor1","v":9.3480588626928211E-3}]
[null,null,null,{"$f":"area2","v":45.333333333333336},{"$f":"factor2","v":0.35133058951646251}]
[null,null,null,{"$f":"area3","v":89.666666666666671},{"$f":"factor3","v":0.57303520650334761}]
[null,null,null,{"$f":"area4","v":134},{"$f":"factor4","v":0.68890585245262281}]
[null,null,null,{"$f":"area5","v":178.33333333333334},{"$f":"factor5","v":0.75102670149482009}]
[null,null,null,{"$f":"area6","v":222.66666666666669},{"$f":"factor6","v":0.78982967504470547}]
[null,null,null,{"$f":"area7","v":267},{"$f":"factor7","v":0.81566312993165424}]
[null,null,null,{"$f":"area8","v":311.33333333333331},{"$f":"factor8","v":0.83548712939972158}]
[null,null,null,{"$f":"area9","v":355.66666666666663},{"$f":"factor9","v":0.85184756071927814}]

{"sheet":"Pérdidas_Conductos","index":9,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Implementa el cálculo de las pérdidas térmicas por conductos y tuberías (referencia en cualquier obra de fluidos, aunque similar a la de J. A. Duffie & W. A. Beckman, sección 10.3, \"Duct and pipe loss factors\")"]
[]
[null,null,"U conductos (Ud)",1,"W/m2K"]
[null,null,"Area conductos ida (Ao)",0.4,"m2"]
[null,null,"Area conductos retorno (Ai)",0.4,"m2"]
[null,null,"Area de captación (Ac)",2,"m2"]
[null,null,"Caudal másico unitario",0.02,"kg/s·m2"]
[]
[null,null,"Caudal másico en primario (mc)",{"$f":"D7*D6","v":0.04},"kg/s"]
[]
[null,null,"Capacidad calorífica fluido primario (cp)c",4180,"J/kgK"]
[]
[null,null,"Valores originales de:"]
[null,null,"FR(ta) =",{"$f":"frta","v":0.78400000000000003}]
[null,null,"FRUL =",{"$f":"frul","v":4.9000000000000004}]
[]
[]
[null,null,"Nuevos valores de:"]
[null,null,"FR(ta) =",{"$f":"D14*1/(1+(D3*D4/(D9*D11)))","v":0.78212887828162292}]
[null,null,"FRUL =",{"$f":"D15*(1-((D3*D5)/(D9*D11))+(D3*(D4+D5)/(D15*D6)))/(1+(D3*D4)/(D9*D11))","v":5.2756563245823385}]

{"sheet":"Viabilidad_Económica","index":10,"n_rows":26,"n_cols":31,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Espacio temporal",null,20,"años",null,"Combustible"]
[null,null,"Inflación(ipc)",null,2,"%",null,"Tipo de instalación"]
[]
[null,null,"Coste solar variable",null,350,"€ / m2"]
[null,null,"Coste solar fijo",null,1500,"€",null,"PCI combustible fósil",17581.2,"kJ/kg"]
[null,null,null,null,null,null,null,"Rendimiento caldera",0.7,"ô"]
[null,null,"Mantenimiento",null,0.5,"%sobre la inversión",null,"Precio del combustible",0.4,"€/litro"]
[]
[]
[null,null,"Área","fanual","LTOT","Inversión","Ahorro anual comb.","Gastos","Flujo de caja","VAN","TRI"]
[null,null," (m2)",null,"(MJ / año)","(€)","(€)","(€)","(€)","(€)","(años)","Año 1","Año 2","Año 3","Año 4","Año 5","Año 6","Año 7","Año 8","Año 9","Año 10","Año 11","Año 12","Año 13","Año 14","Año 15","Año 16","Año 17","Año 18","Año 19","Año 20"]
[null,null,0,0,{"$f":"cartotal","v":303859.647},0,0,0,{"$f":"-(E13*preucomb/(pci*rendcal))","v":-9.8761224489795918},{"$f":"I13*(((1+(ipc/100))^anys-1)/((ipc/100)*(1+(ipc/100))^anys))","v":-161.488757927569},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"f1",{"$f":"area1","v":1},{"$f":"factor1","v":9.3480588626928211E-3},{"$f":"cartotal","v":303859.647},{"$f":"C14*csv+csf","v":1850},{"$f":"(D14*E14*preucomb/((pci/1000)*rendcal))","v":92.322573988223212},{"$f":"F14*$E$8/100","v":9.25},{"$f":"G14-H14","v":83.072573988223212},{"$f":"-F14+I14*(((1+(ipc/100))^anys-1)/((ipc/100)*(1+(ipc/100))^anys))","v":-491.64434366745627},{"$f":"(LN(I14/(I14-F14*(ipc/100))))/(LN(1+(ipc/100)))","v":29.76861371455643},{"$f":"-F14+($I$14/(1+(ipc/100)))","v":-1768.5563000115458},{"$f":"L14+($I$14/(1+(ipc/100))^M13)","v":-1688.709535316983},-1610.4283934595683,-1533.6821759522991,-1458.44078623929,-1384.6747178932028,-1312.3550430440976,-1241.4534010351708,-1171.941987300929,-1103.793542463437,-1036.9813416423665,-971.47918397465025,-907.26138233963434,-844.30275328569712,-782.57860715438619,-722.06473839819898,-662.73741608821149,-604.57337460783162,-547.54980452902782,-491.64434366745547]
[null,"f2",{"$f":"area2","v":45.333333333333336},{"$f":"factor2","v":0.35133058951646251},{"$f":"cartotal","v":303859.647},17366.666666666668,3469.7839221367699,{"$f":"F15*$E$8/100","v":86.833333333333343},{"$f":"G15-H15","v":3382.9505888034364},{"$f":"-F15+I15*(((1+(ipc/100))^anys-1)/((ipc/100)*(1+(ipc/100))^anys))","v":37949.42439421828},5.4706630306042676,{"$f":"-F15+($I$15/(1+(ipc/100)))","v":-14050.048442349573},{"$f":"L15+($I$15/(1+(ipc/100))^M13)","v":-10798.461947921049},{"$f":"M15+($I$15/(1+(ipc/100))^N13)","v":-7610.6320514224954},-4485.3086234827369,-1421.2660470712099,1582.6972631361696,4527.759331966934,7415.0750857225858,10245.776805090871,13020.974569177426,15741.756690830911,18409.190143432366,21024.320979316148,23588.17473998652,26101.756858290806,28566.053052706775,30982.029713898901,33350.634283695101,35672.795626632556,37949.424394218295]
[null,"f3",{"$f":"area3","v":89.666666666666671},{"$f":"factor3","v":0.57303520650334761},303859.647,32883.333333333336,5659.3658670033674,164.41666666666669,5494.9492003367004,56966.96224791943,6.4373397597306621,{"$f":"-F16+($I$16/(1+(ipc/100)))","v":-27496.128234964021},{"$f":"L16+($I$16/(1+(ipc/100))^M13)","v":-22214.55460911175},-17036.541250433056,-11960.057565453943,-6983.1127762587339,-2103.7551397928437,2679.9288175266574,7369.8150501928349,11967.742729277323,16475.514963673879,20894.899507199916,25227.629451833283,29475.403907356194,33639.888667672771,37722.716864061571,41725.489605619223,45649.776607146327,49497.116804721925,53269.018959207802,56966.962247919444]
[null,"f4",{"$f":"area4","v":134},{"$f":"factor4","v":0.68890585245262281},303859.647,48400,6803.7185546407718,242,6561.7185546407718,58893.503572214686,8.0599538406548366,{"$f":"-F17+($I$17/(1+(ipc/100)))","v":-41966.942593489439},{"$f":"L17+($I$17/(1+(ipc/100))^M13)","v":-35660.023567498691},-29476.76962044894,-23414.755946870755,-17471.605286499984,-11644.986992018836,-5932.616115076532,-332.25251023113742,5158.3000435388576,10541.194704097676,15818.542410527891,20992.412710949669,26064.834574108278,31037.79718504809,35913.250725185164,40693.107137084255,45379.240874240219,49973.489636157836,54477.655089018241,58893.503572214715]
[null,"f5",{"$f":"area5","v":178.33333333333334},{"$f":"factor5","v":0.75102670149482009},303859.647,63916.666666666672,7417.231666416088,319.58333333333337,7097.648333082755,52140.056955126798,10.028010341256138,{"$f":"-F18+($I$18/(1+(ipc/100)))","v":-56958.187908742402},{"$f":"L18+($I$18/(1+(ipc/100))^M13)","v":-50136.149910777429},-43447.877363752945,-36890.74741568973,-30462.188643078734,-24159.680042479718,-17980.750041892446,-11922.97553151277,-5983.9809134934776,-161.43717033730991,5546.9390484432479,11143.38632175752,16630.099334810729,22009.229739764854,27282.886999523802,32453.139214973751,37522.01393600311,42491.498956620133,47363.543094479959,52140.056955126842]
[null,"f6",{"$f":"area6","v":222.66666666666669},{"$f":"factor6","v":0.78982967504470547},303859.647,79433.333333333343,7800.4545845792727,397.16666666666674,7403.2879179126057,41621.035587275765,12.197803875379211,{"$f":"-F19+($I$19/(1+(ipc/100)))","v":-72175.207923615104},{"$f":"L19+($I$19/(1+(ipc/100))^M13)","v":-65059.398698401143},-58083.11514426981,-51243.621463748896,-44538.235502453877,-37964.327697262685,-31519.320045114455,-25200.685092027958,-19005.944941943155,-12932.670284997272,-6978.479444854247,-1141.0374447140275,4581.9449083646196,10192.711921186823,15693.463894541925,21086.357986066534,26373.509056188697,31556.990497484938,36638.83504777537,41621.035587275794]
[null,"f7",{"$f":"area7","v":267},{"$f":"factor7","v":0.81566312993165424},303859.647,94950,8055.5889483229694,474.75,7580.8389483229694,29007.582759628698,14.56114532547655,{"$f":"-F20+($I$20/(1+(ipc/100)))","v":-87517.804952624545},{"$f":"L20+($I$20/(1+(ipc/100))^M13)","v":-80231.339219903501},-73087.745364294635,-66084.221976442816,-59218.022576588082,-52486.454537514815,-45886.878028619452,-39416.704980682829,-33073.398070941039,-26854.469728056931,-20757.48115660192,-14780.041380665636,-8919.8063062182991,-3174.4778018581665,2458.1972024164752,7980.4275987641622,13394.378967732482,18702.174427505346,23905.89546649835,29007.582759628745]
[null,"f8",{"$f":"area8","v":311.33333333333331},{"$f":"factor8","v":0.83548712939972158},303859.647,110466.66666666666,8251.3731944981082,552.33333333333326,7699.0398611647752,15423.670440565373,17.079593750197933,{"$f":"-F21+($I$21/(1+(ipc/100)))","v":-102918.58837140707},{"$f":"L21+($I$21/(1+(ipc/100))^M13)","v":-95518.511611348658},-88263.534395605107,-81150.811635072227,-74177.554026706654,-67341.026959681578,-60638.549442990326,-54067.493054077335,-47625.280908084205,-41309.38664730663,-35117.333450465871,-29046.693061406302,-23095.084836838098,-17260.174812751622,-11539.674789137429,-5931.3414326529273,-432.97539688380857,4957.5795401447394,10242.437321545276,15423.670440565411]
[null,"f9",{"$f":"area9","v":355.66666666666663},{"$f":"factor9","v":0.85184756071927814},303859.647,125983.33333333331,8412.9508175281699,629.91666666666652,7783.0341508615038,1280.4308032015542,19.753703484395562,{"$f":"-F22+($I$22/(1+(ipc/100)))","v":-118352.90769523381},{"$f":"L22+($I$22/(1+(ipc/100))^M13)","v":-110872.09824611664},-103537.97133521746,-96347.650834335902,-89298.317009942228,-82387.205417399397,-75611.605816867217,-68968.861110463113,-62456.366300263013,-56071.567466733504,-49811.960767194774,-43675.091453921508,-37658.552911496736,-31759.985713041078,-25977.076694947293,-20307.55804975731,-14749.206436825953,-9299.8421104226618,-3957.3280649292392,1280.430803201567]
[]
[null,null,"VAN opt.",{"$f":"MAX(J14:J22)","v":58893.503572214686},"→","Área opt.",{"$f":"INDEX(C14:J22,MATCH(D24,J14:J22,0),1)","v":134},"Fracción solar opt.",{"$f":"INDEX(C14:J22,MATCH(D24,J14:J22,0),2)","v":0.68890585245262281},"TRI",{"$f":"INDEX(C14:K22,MATCH(D24,J14:J22,0),9)","v":8.0599538406548366}]
[]
[null,null,"TRI opt.",{"$f":"MIN(K14:K22)","v":5.4706630306042676},"→","Área opt.",{"$f":"INDEX(C14:K22,MATCH(D26,K14:K22,0),1)","v":45.333333333333336}]

{"sheet":"Conclusiones","index":11,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Factor de CO2",0.63,"kgCO2/kWhe"]
[null,null,0.21,"kgCO2/kWht"]
[]
[null,"Área óptima de captación",{"$f":"Viabilidad_Económica!G24","v":134},"m2"]
[null,"Área unitaria por captador",1.9,"m2"]
[null,"Nº de captadores",{"$f":"C5/C6","v":70.526315789473685},"captadores"]
[]
[null,"Fracción de aporte solar anual",{"$f":"Viabilidad_Económica!I24","v":0.68890585245262281}]
[null,"Ahorro energético",{"$f":"C9*cartotal","v":209330.68914248806},"MJ/año",{"$f":"C10/4.186","v":50007.331376609669},"Mcal/año",{"$f":"C10*1000000*0.00000027778","v":58147.878830000336},"kWh/año"]
[null,"Ahorro de combustible",{"$f":"C10*1000/(4.186*pci*rendcal)","v":4063.3770632111632},"Unidades de combustible",{"$f":"C11*preucomb*(((1+(ipc/100))^anys-1)/((ipc/100)*(1+(ipc/100))^anys))","v":26576.815681224842},"€"]
[null,"Ahorro del ciclo de vida (20 años)",{"$f":"Viabilidad_Económica!D24","v":58893.503572214686},"€"]
[null,"Tiempo de recuperación de la inversión",{"$f":"Viabilidad_Económica!K24","v":8.0599538406548366},"años"]
[null,"Ahorro en emisiones anuales de CO2",{"$f":"G10*C3","v":12211.05455430007},"kgCO2/año",{"$f":"C14/1000","v":12.21105455430007},"tCO2/año"]
[]
[null,"Caudal estandard",1.4999999999999999E-2,"l/s·m2"]
[null,"Caudal en el primario",{"$f":"C16*C5","v":2.0099999999999998},"l/s",{"$f":"C17*3600","v":7235.9999999999991},"l/h",{"$f":"C17/1000","v":2.0099999999999996E-3},"m3/s",{"$f":"G17*3600","v":7.2359999999999989},"m3/h"]
[null,"Volumen de acumulación estandard",75,"l/m2"]
[null,"Volumen de acumulación principal",{"$f":"C18*C5","v":10050},"l"]

{"sheet":"BBDD_Localidades","index":12,"n_rows":104,"n_cols":3,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Lista de Localidades"]
[null,null,"Genérica"]
[null,null,"Albacete"]
[null,null,"Alicante"]
[null,null,"Almería"]
[null,null,"Ávila"]
[null,null,"Badajoz"]
[null,null,"Barcelona"]
[null,null,"Bilbao"]
[null,null,"Burgos"]
[null,null,"Cáceres"]
[null,null,"Cádiz"]
[null,null,"Castellón"]
[null,null,"Ciudad Real"]
[null,null,"Córdoba"]
[null,null,"A Coruña"]
[null,null,"Cuenca"]
[null,null,"Girona"]
[null,null,"Granada"]
[null,null,"Guadalajara"]
[null,null,"Huelva"]
[null,null,"Huesca"]
[null,null,"Jaén"]
[null,null,"León"]
[null,null,"Lleida"]
[null,null,"Logroño"]
[null,null,"Lugo"]
[null,null,"Madrid"]
[null,null,"Málaga"]
[null,null,"Murcia"]
[null,null,"Ourense"]
[null,null,"Oviedo"]
[null,null,"Palencia"]
[null,null,"Palma de Mallorca"]
[null,null,"Las Palmas"]
[null,null,"Pamplona"]
[null,null,"Pontevedra"]
[null,null,"Salamanca"]
[null,null,"San Sebastián"]
[null,null,"Santander"]
[null,null,"Segovia "]
[null,null,"Sevilla"]
[null,null,"Soria"]
[null,null,"Tarragona"]
[null,null,"Tenerife"]
[null,null,"Teruel"]
[null,null,"Toledo"]
[null,null,"Valencia"]
[null,null,"Valladolid"]
[null,null,"Vitoria"]
[null,null,"Zaragoza"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Pontevedra"]
[]
[null,null,"Salamanca"]
[]
[null,null,"San Sebastián"]
[]
[null,null,"Santander"]
[]
[null,null,"Segovia "]
[]
[null,null,"Sevilla"]
[]
[null,null,"Soria"]
[]
[null,null,"Tarragona"]
[]
[null,null,"Tenerife"]
[]
[null,null,"Teruel"]
[]
[null,null,"Toledo"]
[]
[null,null,"Valencia"]
[]
[null,null,"Valladolid"]
[]
[null,null,"Vitoria"]
[]
[null,null,"Zaragoza"]

{"sheet":"BBDD_Clima","index":13,"n_rows":355,"n_cols":19,"rows_kept":355,"cut":false,"hidden":false,"merged":[]}
[null,null,"Otras fuentes:"]
[null,null,"http://re.jrc.ec.europa.eu/pvgis/apps/radmonth.php?lang=es&map=europe"]
[null,null,"http://opengis.uab.es/wms/iberia/espanol/es_cartografia.htm"]
[]
[null,"Localidad","Latitud","Dato","Símbolo","Unidades","Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
[null,"Albacete",38.92,"Radiación en superficie plana","H","(kJ /m2-día)",6410,9220,13990,16530,19820,23070,23240,19760,16400,11280,6310,5630]
[null,null,"Altura (m)","Indice de nubosidad","KT","(-)",0.49,0.5,0.54,0.49,0.51,0.56000000000000005,0.57999999999999996,0.56000000000000005,0.57999999999999996,0.55000000000000004,0.44,0.48]
[null,null,686,"Temperatura agua de red (UNE 94002)","Tr","ºC",7,8,9,11,14,17,19,19,17,13,9,7]
[null,null,null,"Temperatura ambiente","Ta","ºC",4.2,5.6,9,11.6,15.3,20.5,24.1,23.8,19.8,13.7,8.6999999999999993,5.0999999999999996]
[null,null,null,"Grados-día (15/15) calef.","GD15","ºC",334.7,267.5,236.4,157.1,49.6,2.1,0,0,7.6,95.8,209.6,313.3]
[null,null,null,"Grados-día (18/18) calef.","GD18","ºC"]
[null,null,null,"Grados-día (21/21) refrig.","GD21","ºC"]
[null,"Alicante",38.369999999999997,"Radiación en superficie plana",null,"(kJ /m2-día)",9360,13540,16244,20746,23720,25870,26088,22446,18522,13386,9264,7502]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.57999999999999996,0.63,0.57999999999999996,0.59,0.6,0.62,0.64,0.61,0.6,0.59,0.53,0.52]
[null,null,3,"Temperatura agua de red (UNE 94002)",null,"ºC",11,12,13,14,16,18,20,20,19,16,13,12]
[null,null,null,"Temperatura ambiente",null,"ºC",11,11.8,14,15.9,19.100000000000001,22.7,25.5,26,23.7,19.3,15.2,12.1]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",128.6,104.6,87.9,35.700000000000003,3.4,0,0,0,0,2.9,33.799999999999997,120.5]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Almería",36.83,"Radiación en superficie plana",null,"(kJ /m2-día)",8918,12144,16748,20432,23404,24034,24534,22188,17962,13778,9796,7662]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.53,0.54,0.57999999999999996,0.57999999999999996,0.59,0.57999999999999996,0.61,0.6,0.56999999999999995,0.56000000000000005,0.53,0.5]
[null,null,16,"Temperatura agua de red (UNE 94002)",null,"ºC",12,12,13,14,16,18,20,21,19,17,14,12]
[null,null,null,"Temperatura ambiente",null,"ºC",11.7,12.2,14.1,16.100000000000001,18.399999999999999,22,24.7,25.3,23.4,19.3,15.6,12.8]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",90.8,66.099999999999994,44.7,15.8,1.3,0,0,0,0,1.3,19,80]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Ávila",40.65,"Radiación en superficie plana",null,"(kJ /m2-día)",6558,10194,12044,16260,19716,21236,24406,22664,16578,11076,6454,5004]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.45,0.5,0.44,0.47,0.5,0.51,0.51,0.6,0.62,0.49,0.4,0.38]
[null,null,1128,"Temperatura agua de red (UNE 94002)",null,"ºC",6,6,7,9,11,14,17,16,14,11,8,6]
[null,null,null,"Temperatura ambiente",null,"ºC",2.4,3.3,6.3,8.6999999999999993,12.2,16.399999999999999,20,19.8,16.3,10.6,6.1,3.3]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",357.4,326.5,316.7,229.7,136.6,35.5,1.2,3.7,37.299999999999997,130.5,273.5,388.4]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Badajoz",38.880000000000003,"Radiación en superficie plana",null,"(kJ /m2-día)",6656,9504,13150,17588,21266,23320,23906,21142,16496,11638,7872,5568]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.43,0.45,0.47,0.5,0.54,0.56000000000000005,0.59,0.56999999999999995,0.54,0.49,0.46,0.39]
[null,null,186,"Temperatura agua de red (UNE 94002)",null,"ºC",9,10,11,13,15,18,20,20,18,15,12,9]
[null,null,null,"Temperatura ambiente",null,"ºC",8.6999999999999993,10,12.7,15.3,18.100000000000001,22.8,25.9,25.6,22.8,17.8,12.7,9.1]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",213.9,131.19999999999999,99.2,18,0,0,0,0,0,0,96,189.1]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Barcelona",41.4,"Radiación en superficie plana",null,"(kJ /m2-día)",6800,9650,13880,18540,22250,24030,23370,20420,16050,11400,7730,6040,"calef. 1515 573 152 114 77 50 2 0 0 0 0 5 56 117"]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.44,0.5,0.51,0.53,0.54,0.55000000000000004,0.55000000000000004,0.52,0.51,0.53,0.44,0.46,"calef. 1818 1128 246 195 154 117 40 0 0 0 0 46 125 205"]
[null,null,18,"Temperatura agua de red (UNE 94002)",null,"ºC",9,10,11,12,14,17,19,19,17,15,12,10,"refr. 2121 354 0 0 0 0 5 44 118 135 52 0 0 0"]
[null,null,null,"Temperatura ambiente",null,"ºC",9.5,10.3,12.3,14.6,17.7,21.5,24.3,24.3,21.9,17.600000000000001,13.5,10.3]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",152,114,77,50,2,0,0,0,0,5,56,117]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC",246,195,143,117,40,0,0,0,0,46,125,205]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC",0,0,0,0,5,44,118,135,52,0,0,0]
[null,"Bilbao",43.4,"Radiación en superficie plana",null,"(kJ /m2-día)",3804,6016,8824,9962,13562,13442,14110,11286,10722,8190,4400,3042]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.3,0.32,0.34,0.3,0.35,0.32,0.35,0.31,0.37,0.38,0.3,0.27]
[null,null,19,"Temperatura agua de red (UNE 94002)",null,"ºC",9,10,10,11,13,15,17,17,16,14,11,10]
[null,null,null,"Temperatura ambiente",null,"ºC",8.6,8.6999999999999993,11.6,12.1,14.6,17.600000000000001,19.5,19.7,18.399999999999999,15.9,11.8,9.4]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",179,151.1,164.4,134.69999999999999,50.7,6.7,0.1,0.5,10.199999999999999,59.1,137.80000000000001,188.4]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Burgos",42.37,"Radiación en superficie plana",null,"(kJ /m2-día)",3708,7996,10780,14386,18110,21434,22964,20080,14452,10034,5170,2910]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.27,0.42,0.41,0.42,0.46,0.52,0.56999999999999995,0.56000000000000005,0.49,0.46,0.34,0.24]
[null,null,860,"Temperatura agua de red (UNE 94002)",null,"ºC",5,6,7,9,11,13,16,16,14,11,7,6]
[null,null,null,"Temperatura ambiente",null,"ºC",2.5,3.8,7.1,9.1999999999999993,12.2,16.2,19.2,18.8,16.2,11.3,6.5,3.4]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",387,335.3,328.2,241.1,145.19999999999999,50.5,6.8,10.9,52.8,148.69999999999999,284.60000000000002,392.4]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Cáceres",39.33,"Radiación en superficie plana",null,"(kJ /m2-día)",6061,9614,14992,20273,23157,26877,31768,29218,22321,12749,7691,5852]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.39,0.46,0.54,0.57999999999999996,0.59,0.65,0.78,0.79,0.73,0.54,0.45,0.42]
[null,null,439,"Temperatura agua de red (UNE 94002)",null,"ºC",9,10,11,12,14,18,21,20,19,15,11,9]
[null,null,null,"Temperatura ambiente",null,"ºC",7.7,9,11.7,14.4,17.399999999999999,22.5,26,25.6,22.3,16.899999999999999,11.7,8.1]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",209.9,180.7,140.6,76.5,32.9,1,0,0,1.6,24.9,111.1,246.7]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Cádiz",36.47,"Radiación en superficie plana",null,"(kJ /m2-día)",8394,13264,16458,22270,25630,27322,27222,25710,20528,14594,9750,7878]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.49,0.59,0.56999999999999995,0.63,0.65,0.66,0.67,0.69,0.65,0.59,0.52,0.5]
[null,null,4,"Temperatura agua de red (UNE 94002)",null,"ºC",12,12,13,14,16,18,19,20,19,17,14,12]
[null,null,null,"Temperatura ambiente",null,"ºC",11.4,12.5,14.7,11.6,18.8,22.2,24.4,24.9,23.1,19.5,15.6,12.3]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",80.900000000000006,51.7,43.5,15.8,2.2999999999999998,0,0,0,0,1.5,16.8,80.2]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Castellón",39.979999999999997,"Radiación en superficie plana",null,"(kJ /m2-día)",7604,12424,15634,18496,21158,23044,23364,20306,17170,12126,7766,6806]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.5,0.6,0.56999999999999995,0.54,0.54,0.56000000000000005,0.57999999999999996,0.56000000000000005,0.56999999999999995,0.52,0.47,0.5]
[null,null,30,"Temperatura agua de red (UNE 94002)",null,"ºC",10,11,12,13,15,18,19,20,18,16,12,11]
[null,null,null,"Temperatura ambiente",null,"ºC",10.6,11.1,13.1,14.9,17.8,21.6,24.3,24.7,22.8,18.5,14.5,11.6]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",124.3,102.3,90.2,40.200000000000003,3.4,0,0,0,0,5,40.5,118.4]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Ciudad Real",38.979999999999997,"Radiación en superficie plana",null,"(kJ /m2-día)",5948,10424,12642,16584,20720,23024,25764,22956,17426,10974,6493,4612]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.38,0.49,0.45,0.48,0.53,0.56000000000000005,0.64,0.56000000000000005,0.56999999999999995,0.47,0.38,0.33]
[null,null,635,"Temperatura agua de red (UNE 94002)",null,"ºC",7,8,10,11,14,17,20,20,17,13,10,7]
[null,null,null,"Temperatura ambiente",null,"ºC",5.4,7.3,10.4,12.9,15.9,21.2,25.5,24.8,20.7,14.8,9.3000000000000007,6.2]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",308.10000000000002,241.5,199.3,111.9,41.7,3.1,0,0,3.6,51.4,193,322.89999999999998]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Córdoba",37.880000000000003,"Radiación en superficie plana",null,"(kJ /m2-día)",7400,11094,14156,17224,19014,24266,15722,23412,17988,11894,8228,6236]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.46,0.51,0.5,0.49,0.48,0.59,0.46,0.63,0.57999999999999996,0.49,0.46,0.42]
[null,null,123,"Temperatura agua de red (UNE 94002)",null,"ºC",10,11,12,14,16,19,21,21,19,16,12,10]
[null,null,null,"Temperatura ambiente",null,"ºC",9.1,10.7,13.5,16.399999999999999,19.399999999999999,24.4,27.9,27.6,24.3,18.600000000000001,13.5,9.6]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",220,148.6,117.3,50.6,8.3000000000000007,0,0,0,0.1,19.5,100.7,203.7]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"A Coruña",43.37,"Radiación en superficie plana",null,"(kJ /m2-día)",5172,7638,11078,14676,15016,16876,18172,14926,13356,8244,6268,3938]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.4,0.41,0.43,0.44,0.38,0.41,0.45,0.42,0.42,0.39,0.43,0.34]
[null,null,5,"Temperatura agua de red (UNE 94002)",null,"ºC",10,10,11,12,13,14,16,16,15,14,12,11]
[null,null,null,"Temperatura ambiente",null,"ºC",9.9,9.8000000000000007,11.5,12.4,14,16.5,18.2,18.899999999999999,17.8,15.3,12.4,10.199999999999999]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",161.80000000000001,152.6,150.1,111.8,62.6,11.2,0.1,0,1.9,28.7,89.8,158.69999999999999]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Cuenca",40.08,"Radiación en superficie plana",null,"(kJ /m2-día)",6040,9212,11800,15266,18680,20928,23788,21468,15982,11076,6394,4968]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.41,0.45,0.43,0.44,0.47,0.5,0.59,0.59,0.53,0.48,0.39,0.37]
[null,null,1001,"Temperatura agua de red (UNE 94002)",null,"ºC",6,7,8,10,13,16,18,18,16,12,9,7]
[null,null,null,"Temperatura ambiente",null,"ºC",3,4.3,7.3,10,13.3,18.100000000000001,21.9,21.5,18,12,7.2,4.0999999999999996]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",239.1,291.60000000000002,264.7,168,78.599999999999994,11.2,0,0,13.5,89,227.2,342.5]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Girona",41.38,"Radiación en superficie plana",null,"(kJ /m2-día)",6790,9520,13480,17770,21120,22640,21910,19070,14980,10710,7400,5950]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.53,0.53,0.51,0.47,0.46,0.41,0.55000000000000004,0.5,0.46,0.48,0.48,0.46]
[null,null,75,"Temperatura agua de red (UNE 94002)",null,"ºC",8,9,10,11,14,16,19,18,17,14,10,9]
[null,null,null,"Temperatura ambiente",null,"ºC",7.3,8.4,11.1,13.4,16.7,20.8,23.5,23.3,20.9,16.100000000000001,11.4,8]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",244,201,156,118,44,10,0,0,14,64,141,224]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC",333,279,233,186,95,44,9,7,51,121,214,310]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC",0,0,0,0,16,45,107,116,39,9,0,0]
[null,"Granada",37.18,"Radiación en superficie plana",null,"(kJ /m2-día)",6880,9670,12250,15872,18594,21006,23686,18806,15452,11206,7414,5510]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.41,0.44,0.43,0.45,0.47,0.51,0.59,0.51,0.49,0.46,0.41,0.36]
[null,null,685,"Temperatura agua de red (UNE 94002)",null,"ºC",8,9,10,12,14,17,20,19,17,14,11,8]
[null,null,null,"Temperatura ambiente",null,"ºC",6.5,8.1,11.1,13.5,16.3,21.9,25.5,25.1,21.5,15.8,11.1,7.2]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",257.3,196,155,69,0,0,0,0,0,0,132,232.5]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Guadalajara",40.630000000000003,"Radiación en superficie plana",null,"(kJ /m2-día)",4990,7658,9948,12998,16258,18372,23580,20474,14554,10034,5186,4166]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.34,0.38,0.37,0.38,0.41,0.44,0.57999999999999996,0.56000000000000005,0.49,0.44,0.32,0.32]
[null,null,679,"Temperatura agua de red (UNE 94002)",null,"ºC",7,8,9,11,14,17,19,19,16,13,9,7]
[null,null,null,"Temperatura ambiente",null,"ºC",8.1,10.4,14.7,17.899999999999999,21.5,26.7,31.5,30.5,25.9,18.600000000000001,12.1,8.5]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",288.5,241.8,210,121.3,46.2,3,0,0,5.2,54,183.9,294.7]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Huelva",37.25,"Radiación en superficie plana",null,"(kJ /m2-día)",7572,11858,15798,20796,24036,25632,26996,24840,20612,13088,8670,6684]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.46,0.54,0.55000000000000004,0.59,0.61,0.62,0.67,0.67,0.66,0.54,0.48,0.44]
[null,null,56,"Temperatura agua de red (UNE 94002)",null,"ºC",12,12,13,14,16,18,20,20,19,17,14,12]
[null,null,null,"Temperatura ambiente",null,"ºC",11.2,12.3,14.4,16.600000000000001,18.8,22.3,25.1,25.2,23.1,19.399999999999999,15.2,11.9]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",91.8,60.3,48.1,16.100000000000001,2.2999999999999998,0,0,0,0,1.3,25.8,99.8]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Huesca",42.15,"Radiación en superficie plana",null,"(kJ /m2-día)",6434,11472,14994,17614,20608,22330,23894,20734,15420,11370,6772,4966]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.47,0.59,0.56999999999999995,0.52,0.53,0.54,0.59,0.56999999999999995,0.52,0.52,0.44,0.41]
[null,null,488,"Temperatura agua de red (UNE 94002)",null,"ºC",7,8,10,11,14,16,19,18,17,13,9,7]
[null,null,null,"Temperatura ambiente",null,"ºC",4.3,6.1,9.6999999999999993,12.4,15.9,19.899999999999999,22.8,22.5,19.3,14.1,8.9,5.4]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",314,244.9,202.3,121.1,42.2,4.4000000000000004,0,0.1,6.8,57.8,182.4,324.60000000000002]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Jaén",37.770000000000003,"Radiación en superficie plana",null,"(kJ /m2-día)",6207,9906,14671,18057,20189,24411,26835,24285,19646,11620,7774,6311]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.38,0.45,0.52,0.51,0.51,0.51,0.66,0.65,0.63,0.48,0.43,0.42]
[null,null,574,"Temperatura agua de red (UNE 94002)",null,"ºC",9,10,11,13,16,19,21,21,19,15,12,9]
[null,null,null,"Temperatura ambiente",null,"ºC",8.1,9.5,12.3,14.9,18.399999999999999,27.8,27.7,27.3,23.4,17.600000000000001,12.7,8.9]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",188,146,119,54,17,0,0,0,0,16,91,179]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"León",42.58,"Radiación en superficie plana",null,"(kJ /m2-día)",5600,10726,13652,17314,19144,23574,24820,21668,15406,10630,6972,4216]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.42,0.56000000000000005,0.52,0.51,0.49,0.56999999999999995,0.61,0.6,0.53,0.49,0.44,0.35]
[null,null,838,"Temperatura agua de red (UNE 94002)",null,"ºC",6,6,8,9,12,14,16,16,15,11,8,6]
[null,null,null,"Temperatura ambiente",null,"ºC",2.8,4.2,7.6,9.9,12.5,17.2,19.7,19.5,16.600000000000001,11.8,7,3.6]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",403,333.2,29.76,20.399999999999999,80.599999999999994,0,0,0,0,16.43,29.1,36.89]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Lleida",41.62,"Radiación en superficie plana",null,"(kJ /m2-día)",4920,8280,13220,18640,22920,24940,24130,20650,15540,10140,5900,3990]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.44,0.62,0.57999999999999996,0.56000000000000005,0.53,0.57999999999999996,0.61,0.59,0.56999999999999995,0.54,0.4,0.32]
[null,null,155,"Temperatura agua de red (UNE 94002)",null,"ºC",7,9,10,12,15,17,20,19,17,14,10,7]
[null,null,null,"Temperatura ambiente",null,"ºC",4.9000000000000004,7.2,11.4,14.6,18.3,21.9,24.8,24.6,21.6,15.5,9.5,5.7]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",302,220,146,99,36,3,0,0,13,78,184,277]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC",398,302,226,169,90,38,11,13,55,145,266,370]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC",0,0,0,4,27,70,132,128,50,8,0,0]
[null,"Logroño",42.45,"Radiación en superficie plana",null,"(kJ /m2-día)",5986,9630,13606,18254,21228,23572,25224,21396,16538,11808,6740,5024]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.45,0.5,0.52,0.54,0.54,0.56999999999999995,0.62,0.59,0.56000000000000005,0.54,0.45,0.42]
[null,null,384,"Temperatura agua de red (UNE 94002)",null,"ºC",7,8,10,11,13,16,18,18,16,13,10,8]
[null,null,null,"Temperatura ambiente",null,"ºC",5.0999999999999996,6.5,9.6999999999999993,11.9,14.9,19.100000000000001,21.8,21.5,19,13.8,8.9,6.1]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",288.10000000000002,230.3,203.5,143.30000000000001,50.7,8.1999999999999993,0,0.3,14.3,93.1,190,284.60000000000002]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Lugo",43.1,"Radiación en superficie plana",null,"(kJ /m2-día)",3868,7238,8590,13566,13836,16734,17034,15242,11302,9146,5342,3156]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.3,0.39,0.33,0.4,0.35,0.4,0.42,0.42,0.39,0.43,0.36,0.27]
[null,null,454,"Temperatura agua de red (UNE 94002)",null,"ºC",7,8,9,10,11,13,15,15,14,12,9,8]
[null,null,null,"Temperatura ambiente",null,"ºC",6,6.7,9.3000000000000007,11,13,16.2,18.100000000000001,18.7,16.8,13.1,8.9,6.2]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",328,263.5,263.5,204,74.400000000000006,0,0,0,0,114.7,128,291.5]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Madrid",40.42,"Radiación en superficie plana",null,"(kJ /m2-día)",6362,9798,14150,19552,21184,23530,25874,22986,16118,10762,7326,6263]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.43,0.48,0.52,0.56999999999999995,0.54,0.56999999999999995,0.64,0.63,0.54,0.47,0.45,0.47]
[null,null,655,"Temperatura agua de red (UNE 94002)",null,"ºC",8,8,10,12,14,17,20,19,17,13,10,8]
[null,null,null,"Temperatura ambiente",null,"ºC",5,6.6,10,12.7,15.8,20.6,24.2,23.7,19.8,14,9,5.6]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",321.7,246.4,208.1,122.9,41.1,2,0,0,7.8,86,209.1,309.8]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Málaga",36.85,"Radiación en superficie plana",null,"(kJ /m2-día)",8204,11556,17708,18882,22818,24870,25916,22316,18546,13020,10134,6236]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.49,0.52,0.62,0.53,0.57999999999999996,0.6,0.64,0.6,0.59,0.53,0.55000000000000004,0.4]
[null,null,8,"Temperatura agua de red (UNE 94002)",null,"ºC",12,12,13,14,16,18,20,20,19,16,14,12]
[null,null,null,"Temperatura ambiente",null,"ºC",11.8,12.6,14.6,16.2,19.100000000000001,22.6,24.9,25.4,23,19.3,15.8,12.9]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",126,88.8,75.2,36.299999999999997,2.2000000000000002,0,0,0,0,5.8,37.5,103.5]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Murcia",37.979999999999997,"Radiación en superficie plana",null,"(kJ /m2-día)",9546,11978,17208,11352,25288,25748,26922,23954,19050,13900,9670,7746]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.59,0.55000000000000004,0.61,0.61,0.64,0.62,0.67,0.64,0.62,0.57999999999999996,0.54,0.53]
[null,null,42,"Temperatura agua de red (UNE 94002)",null,"ºC",11,11,12,13,15,17,19,20,18,16,13,11]
[null,null,null,"Temperatura ambiente",null,"ºC",9.5,10.7,13.3,15.1,18.7,22.7,25.7,26.1,23.4,18.5,14,10.7]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",175.5,130.19999999999999,99.1,46.8,7,0,0,0,0,12.9,64.599999999999994,166.5]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Ourense",42.33,"Radiación en superficie plana",null,"(kJ /m2-día)",2824,6790,14072,12094,8868,19184,16162,18176,12546,7158,5300,2440]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.21,0.35,0.53,0.36,0.23,0.46,0.4,0.5,0.43,0.33,0.35,0.2]
[null,null,139,"Temperatura agua de red (UNE 94002)",null,"ºC",8,10,11,12,14,16,18,18,17,13,11,9]
[null,null,null,"Temperatura ambiente",null,"ºC",7,8.1,11,12.6,16.399999999999999,19.2,21.7,19.899999999999999,17.7,16.2,9.6999999999999993,7.4]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",244.9,168,136.4,57,0,0,0,0,0,0,141,220.1]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Oviedo",43.35,"Radiación en superficie plana",null,"(kJ /m2-día)",5360,7536,10426,12892,15280,16622,16204,14196,12100,8040,5610,4272]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.41,0.4,0.4,0.38,0.39,0.49,0.4,0.4,0.42,0.38,0.38,0.37]
[null,null,232,"Temperatura agua de red (UNE 94002)",null,"ºC",9,9,10,10,12,14,15,16,15,13,10,9]
[null,null,null,"Temperatura ambiente",null,"ºC",7.2,8.1,9.1999999999999993,10.4,13.5,15.9,15.8,18.399999999999999,16.899999999999999,13.8,9.9,8.3000000000000007]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",244,192.9,205.4,176.2,100.2,26.4,3.1,3.5,19.7,89.9,167.8,232.7]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Palencia",42,"Radiación en superficie plana",null,"(kJ /m2-día)",4328,10120,12048,15530,20114,22470,24200,21866,15248,11222,6352,3672]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.32,0.52,0.45,0.48,0.51,0.45,0.6,0.6,0.52,0.51,0.41,0.3]
[null,null,740,"Temperatura agua de red (UNE 94002)",null,"ºC",6,7,8,10,12,15,17,17,15,12,9,6]
[null,null,null,"Temperatura ambiente",null,"ºC",3.3,4.5999999999999996,8.1999999999999993,10.5,13.5,18.100000000000001,21,20.8,17.600000000000001,12.2,7.2,3.9]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",340.6,276.8,260.89999999999998,171.9,90.6,18.2,0.5,1.5,18.3,79.2,"211, 5",338.6]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Palma de Mallorca",39.57,"Radiación en superficie plana",null,"(kJ /m2-día)",8364,12720,14462,17818,22922,24902,25634,22224,17606,12918,8960,6472]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.55000000000000004,0.61,0.52,0.51,0.57999999999999996,0.6,0.63,0.61,0.57999999999999996,0.56000000000000005,0.53,0.47]
[null,null,34,"Temperatura agua de red (UNE 94002)",null,"ºC",11,11,12,13,15,18,20,20,19,17,14,12]
[null,null,null,"Temperatura ambiente",null,"ºC",10.1,10.5,12.2,14.5,17.3,21.4,24,24.5,22.6,18.399999999999999,14.3,11.5]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",185.2,153.19999999999999,139.80000000000001,92.1,14.6,0.2,0,0,0.1,21.9,89.8,147.30000000000001]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Las Palmas",28.15,"Radiación en superficie plana",null,"(kJ /m2-día)",9766,11700,14880,17602,17844,15932,15358,14990,16624,12160,9650,7370]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.44,0.44,0.46,0.48,0.45,0.39,0.38,0.4,0.49,0.42,0.41,0.36]
[null,null,8,"Temperatura agua de red (UNE 94002)",null,"ºC",15,15,16,16,17,18,19,19,19,18,17,16]
[null,null,null,"Temperatura ambiente",null,"ºC",16.8,17,17.7,18.5,19.600000000000001,21.2,22.9,23.6,23.3,22.3,20.2,17.8]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",0.9,0.2,0.2,0,0,0,0,0,0,0,0,0.1]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Pamplona",42.85,"Radiación en superficie plana",null,"(kJ /m2-día)",4210,4346,11008,11318,17172,19970,21266,17748,13420,9948,4626,3244]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.31,0.39,0.34,0.34,0.41,0.48,0.53,0.49,0.46,0.46,0.31,0.28000000000000003]
[null,null,449,"Temperatura agua de red (UNE 94002)",null,"ºC",7,8,9,10,12,15,17,17,16,13,9,7]
[null,null,null,"Temperatura ambiente",null,"ºC",4.5999999999999996,5.4,9,11.1,14.4,17.8,20.2,20.6,18.3,13.4,8.1999999999999993,5.0999999999999996]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",290,252,235,153,71,18,1,1,16,64,194,30.8]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Pontevedra",42.43,"Radiación en superficie plana",null,"(kJ /m2-día)",5338,8862,12050,17942,16984,23022,23076,20420,14476,11226,6990,4918]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.4,0.46,0.46,0.53,0.43,0.55000000000000004,0.56999999999999995,0.56999999999999995,0.49,0.52,0.46,0.41]
[null,null,290,"Temperatura agua de red (UNE 94002)",null,"ºC",10,11,11,13,14,16,17,17,16,14,12,10]
[null,null,null,"Temperatura ambiente",null,"ºC",9.1999999999999993,10.1,12.3,14.2,15.6,18.600000000000001,20.100000000000001,20.5,18.2,14.9,11.9,9.5]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",146,121.4,101,55.6,23.5,1.5,0,0,2.4,15.8,75.900000000000006,151.6]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Salamanca",40.93,"Radiación en superficie plana",null,"(kJ /m2-día)",5822,8960,12436,17502,20848,22736,23068,20850,15534,10676,6114,4856]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.4,0.45,0.46,0.51,0.53,0.55000000000000004,0.56999999999999995,0.56999999999999995,0.52,0.47,0.38,0.38]
[null,null,800,"Temperatura agua de red (UNE 94002)",null,"ºC",6,7,8,10,12,15,17,17,15,12,8,6]
[null,null,null,"Temperatura ambiente",null,"ºC",3.7,4.9000000000000004,8.1999999999999993,10.5,13.6,18.399999999999999,21.5,21.3,18.100000000000001,12.5,7.5,4.3]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",369.7,301.89999999999998,278.60000000000002,177.3,94.8,14.2,0.2,0.8,26.3,117.7,263.8,387]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"San Sebastián",43.32,"Radiación en superficie plana",null,"(kJ /m2-día)",4762,6984,9546,10092,14434,14838,14922,12084,11542,9076,5226,3830]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.37,0.37,0.37,0.3,0.37,0.36,0.37,0.34,0.4,0.43,0.36,0.33]
[null,null,40,"Temperatura agua de red (UNE 94002)",null,"ºC",9,9,10,11,12,14,16,16,15,14,11,9]
[null,null,null,"Temperatura ambiente",null,"ºC",7.7,8,10.7,11.8,13.4,16.7,18.399999999999999,18.899999999999999,18.100000000000001,14.6,10.9,8]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",207.7,179.2,142.6,99,6.2,0,0,0,0,0,111,167.4]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Santander",43.47,"Radiación en superficie plana",null,"(kJ /m2-día)",4704,7268,9648,11338,15138,15740,15134,12028,11482,8984,5206,3574]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.37,0.39,0.37,0.34,0.39,0.38,0.37,0.41,0.4,0.42,0.36,0.31]
[null,null,15,"Temperatura agua de red (UNE 94002)",null,"ºC",10,10,11,11,13,15,16,16,16,14,12,10]
[null,null,null,"Temperatura ambiente",null,"ºC",9.3000000000000007,9.1999999999999993,11.5,12.3,14.2,16.899999999999999,18.8,19.3,18.2,15.3,12.2,9.9]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",171.4,148.1,157.69999999999999,128.1,52.8,6.9,0,0,5.9,47.7,98.8,167.3]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Segovia ",40.950000000000003,"Radiación en superficie plana",null,"(kJ /m2-día)",5154,5748,11082,14626,17138,20578,23996,21666,15488,10612,5478,4164]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.36,0.44,0.41,0.43,0.44,0.5,0.59,0.6,0.52,0.47,0.34,0.32]
[null,null,1001,"Temperatura agua de red (UNE 94002)",null,"ºC",6,7,8,10,12,15,18,18,15,12,8,6]
[null,null,null,"Temperatura ambiente",null,"ºC",2.4,4,7.6,10.1,13.2,18.2,21.7,21.3,17.5,11.8,6.6,3.1]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",334.4,292.8,275.39999999999998,185.6,97.1,18.3,0.4,1.1000000000000001,22.8,97.6,238.9,266.7]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Sevilla",37.409999999999997,"Radiación en superficie plana",null,"(kJ /m2-día)",7160,11178,15446,19720,12400,23490,23782,21648,17544,12060,8330,6784]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.43,0.51,0.54,0.56000000000000005,0.56999999999999995,0.56999999999999995,0.59,0.59,0.56000000000000005,0.49,0.46,0.45]
[null,null,12,"Temperatura agua de red (UNE 94002)",null,"ºC",11,11,13,14,16,19,21,21,20,16,13,11]
[null,null,null,"Temperatura ambiente",null,"ºC",10.3,11.6,14.1,16.399999999999999,19.100000000000001,23.4,26.3,26.4,23.7,19.2,14.6,11]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",157.30000000000001,102.3,69.900000000000006,25.2,3.9,0,0,0,0,5.5,53.9,161.80000000000001]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Soria",41.77,"Radiación en superficie plana",null,"(kJ /m2-día)",5258,7906,10570,13856,17800,20952,23374,19856,14056,9066,5182,4268]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.38,0.4,0.4,0.41,0.45,0.5,0.6,0.55000000000000004,0.48,0.41,0.33,0.34]
[null,null,1063,"Temperatura agua de red (UNE 94002)",null,"ºC",5,6,7,9,11,14,17,16,14,11,8,6]
[null,null,null,"Temperatura ambiente",null,"ºC",2.2999999999999998,3.5,6.6,8.9,11.9,16.5,19.600000000000001,19.5,16.399999999999999,11,6.2,3.1]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",368.3,323.60000000000002,311.10000000000002,220.8,124.7,33.799999999999997,2.4,3.1,35.299999999999997,122.9,266.39999999999998,379.8]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Tarragona",41.42,"Radiación en superficie plana",null,"(kJ /m2-día)",7280,10370,14860,19720,23510,25240,24410,21200,16560,11720,7970,6330]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.52,0.57999999999999996,0.49,0.48,0.47,0.5,0.53,0.5,0.47,0.5,0.46,0.47]
[null,null,51,"Temperatura agua de red (UNE 94002)",null,"ºC",10,11,12,14,16,18,20,20,19,16,12,11]
[null,null,null,"Temperatura ambiente",null,"ºC",8.9,10,11.7,13.7,16.7,20.3,23,23.2,21.7,17.7,13.3,10.3]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",152,113,84,55,8,0,0,0,0,7,56,131]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC",245,193,162,122,46,7,0,0,0,42,122,220]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC",0,0,0,0,2,35,104,130,51,3,0,0]
[null,"Tenerife",28.47,"Radiación en superficie plana",null,"(kJ /m2-día)",9572,12014,15916,19778,21786,24178,25182,22878,18694,13258,9426,7170]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.44,0.45,0.5,0.54,0.55000000000000004,0.6,0.63,0.6,0.55000000000000004,0.46,0.41,0.35]
[null,null,4,"Temperatura agua de red (UNE 94002)",null,"ºC",15,15,16,16,17,18,20,20,20,18,17,16]
[null,null,null,"Temperatura ambiente",null,"ºC",17.399999999999999,17.5,18.2,19.2,20.399999999999999,22.2,24.3,24.7,24.1,22.7,20.5,18.399999999999999]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",1.9,2.2999999999999998,2.1,0,0,0,0,0,0,0,0,0]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Teruel",40.92,"Radiación en superficie plana",null,"(kJ /m2-día)",6116,9338,11466,14408,18726,20444,22958,20276,14390,10532,6026,4192]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.43,0.47,0.42,0.42,0.48,0.49,0.59,0.56000000000000005,0.48,0.47,0.38,0.34]
[null,null,915,"Temperatura agua de red (UNE 94002)",null,"ºC",6,7,8,10,12,15,18,17,15,12,8,6]
[null,null,null,"Temperatura ambiente",null,"ºC",5,6,9,12,16,20,23,24,19,14,9,6]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",350,263,267,184,82,12,1,2,18,113,256,324]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Toledo",39.85,"Radiación en superficie plana",null,"(kJ /m2-día)",6382,10640,12342,17184,19694,22030,24822,22266,16144,11058,6396,4562]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.42,0.52,0.45,0.5,0.5,0.53,0.61,0.61,0.53,0.48,0.38,0.34]
[null,null,529,"Temperatura agua de red (UNE 94002)",null,"ºC",8,9,11,12,15,18,21,20,18,14,11,8]
[null,null,null,"Temperatura ambiente",null,"ºC",5.9,7.3,10.6,13.4,16.899999999999999,22.1,26.1,25.3,21.3,11.2,9.9,6.4]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",265.39999999999998,208,176.7,91.1,29.5,1.5,0,0,2,37.200000000000003,155.5,284]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Valencia",39.46,"Radiación en superficie plana",null,"(kJ /m2-día)",9338,10802,13856,18464,11686,11854,23068,24032,16032,11222,7536,6614]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.61,0.52,0.5,0.55000000000000004,0.55000000000000004,0.53,0.56999999999999995,0.66,0.53,0.48,0.45,0.48]
[null,null,13,"Temperatura agua de red (UNE 94002)",null,"ºC",10,11,12,13,15,17,19,20,18,16,13,11]
[null,null,null,"Temperatura ambiente",null,"ºC",10.3,10.9,13.1,14.8,17.8,21.3,23.9,24.5,22.4,18.3,14.4,11.1]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",176.2,132.19999999999999,115.8,49.9,4.5999999999999996,0,0,0,0.1,11,72.7,175.3]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Valladolid",41.65,"Radiación en superficie plana",null,"(kJ /m2-día)",4468,10354,12940,16958,19436,22800,24932,22760,16030,10924,6068,3624]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.32,0.53,0.49,0.5,0.5,0.55000000000000004,0.62,0.63,0.54,0.49,0.39,0.28999999999999998]
[null,null,691,"Temperatura agua de red (UNE 94002)",null,"ºC",6,8,9,10,12,15,18,18,16,12,9,7]
[null,null,null,"Temperatura ambiente",null,"ºC",3.5,5.0999999999999996,8.6999999999999993,10.9,14,18.5,21.3,20.8,17.899999999999999,12.8,7.7,4.3]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",368.6,278.89999999999998,250.3,170.3,73.7,10.6,0.2,0.9,22.9,131.69999999999999,251.2,361.2]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Vitoria",42.85,"Radiación en superficie plana",null,"(kJ /m2-día)",4458,8422,9198,11400,15312,16878,17628,14634,11556,9270,4916,3216]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.34,0.44,0.35,0.35,0.39,0.41,0.44,0.41,0.4,0.43,0.33,0.27]
[null,null,525,"Temperatura agua de red (UNE 94002)",null,"ºC",7,7,8,10,12,14,16,16,14,12,8,7]
[null,null,null,"Temperatura ambiente",null,"ºC",4.5,5.3,8.6999999999999993,10.4,13.1,16.7,18.899999999999999,19.3,17.2,12.7,8.3000000000000007,5.5]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",309.7,269.5,260.60000000000002,186.5,95.9,31.8,3.3,3.4,28.8,92.4,217,323.8]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Zaragoza",41.5,"Radiación en superficie plana",null,"(kJ /m2-día)",4336,10496,12982,17422,19766,23022,25138,22160,15990,10724,6264,3586]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)",0.31,0.53,0.49,0.51,0.5,0.56000000000000005,0.62,0.61,0.54,0.48,0.4,0.28999999999999998]
[null,null,200,"Temperatura agua de red (UNE 94002)",null,"ºC",8,9,10,12,15,17,20,19,17,14,10,8]
[null,null,null,"Temperatura ambiente",null,"ºC",6.1,7.7,11.3,13.7,17,21.2,23.9,23.7,20.6,15.4,10.199999999999999,6.8]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC",285.3,221.5,186.8,49.4,26.4,0.8,0,0,3.3,51.7,175.6,285.8]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]
[null,"Zamora",null,"Radiación en superficie plana",null,"(kJ /m2-día)"]
[null,null,"Altura (m)","Indice de nubosidad",null,"(-)"]
[null,null,649,"Temperatura agua de red (UNE 94002)",null,"ºC",6,8,9,10,13,16,18,18,16,12,9,7]
[null,null,null,"Temperatura ambiente",null,"ºC"]
[null,null,null,"Grados-día (15/15) calef.",null,"ºC"]
[null,null,null,"Grados-día (18/18) calef.",null,"ºC"]
[null,null,null,"Grados-día (21/21) refrig.",null,"ºC"]

{"sheet":"BBDD_Demanda","index":14,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Demanda de referencia a 45ºC (Tabla 1, UNE 94002)",null,null,null,null,"Coeficientes de uso y de intermitencia (GD calefacción)"]
[null,"Criterio de demanda","Litros ACS / día","por",null,null,"Tipo de edificio","Días de calefacción/mes ","Coeficiente de uso (u)","Horas de calefacción/mes","% de horas","Coeficiente de intermitencia (i)"]
[null,"Vivienda ",40,"persona",null,null,"Vivienda",30,1,15,63,0.85]
[null,"Hospitales y clínicas ",80,"persona",null,null,"Escuela",22,0.8,6,25,0.45]
[null,"Hotel *****",100,"persona",null,null,"Iglesia",6,0.4,6,25,0.45]
[null,"Hotel ****",80,"persona",null,null,"Comercio",24,0.85,11,46,0.8]
[null,"Hotel ***",60,"persona",null,null,"Oficina",24,0.85,9,38,0.7]
[null,"Hotel/Hostal ** ",50,"persona",null,null,"Hotel",30,1,15,63,0.85]
[null,"Camping ",30,"persona",null,null,"Industria",24,0.85,9,38,0.7]
[null,"Hostal/Pensión * ",40,"persona",null,null,"Hospital",30,1,24,100,1]
[null,"Residencia (ancianos, estudiantes, etc) ",60,"persona",null,null,"Cines y teatros",30,1,3,13,0.4]
[null,"Centro penitenciario",40,"persona",null,null,"Salas de reuniones",6,0.4,3,13,0.4]
[null,"Albergue",35,"persona"]
[null,"Vestuarios/Duchas colectivas ",30,"persona"]
[null,"Escuela sin duchas",6,"persona"]
[null,"Escuela con duchas ",30,"persona"]
[null,"Cuarteles ",40,"persona",null,null,"Rendimientos estacionales de instalaciones"]
[null,"Fábricas y talleres ",30,"persona",null,null,"Tipo de energía o combustible","Tipo de instalación","Rendimiento"]
[null,"Oficinas",3,"persona",null,null,"Combustible sólido","Individual",0.5]
[null,"Gimnasios ",30,"persona",null,null,"Combustible sólido","Central poco atendida",0.5]
[null,"Lavanderías ",5,"kilo de ropa",null,null,"Combustible sólido","Central, atendida normalmente",0.6]
[null,"Restaurantes ",12,"persona",null,null,"Combustible sólido","Central, atendida mecánicamente",0.7]
[null,"Cafeterías ",2,"persona",null,null,"Combustible líquido","Individual",0.6]
[null,null,null,null,null,null,"Combustible líquido","Central normal",0.7]
[null,"Poder calorífico de algunos combustibles",null,null,null,null,"Combustible líquido","Central automatizada",0.8]
[null,"Combustible","PCI","Unidades",null,null,"Combustible Gas","Individual",0.6]
[null,"Madera",11302.2,"kJ/kg",null,null,"Combustible Gas","Central normal",0.7]
[null,"Carbón vegetal",27209,"kJ/kg",null,null,"Combustible Gas","Central automatizada",0.8]
[null,"Carbón de turba",13813.8,"kJ/kg",null,null,"Energía eléctrica","Elementos individuales",1]
[null,"Carbón de hulla",20930,"kJ/kg",null,null,"Energía eléctrica","Radiadores (distribución)",0.8]
[null,"Carbón de antracita",29302,"kJ/kg"]
[null,"Gasoleo -C-",35790.300000000003,"kJ/litro"]
[null,"Fueloleo",37674,"kJ/litro"]
[null,"Gasoleo -A-",41860,"kJ/litro"]
[null,"Gas butano",49645.96,"kJ/kg"]
[null,"Gas propano",50232,"kJ/kg"]
[null,"Gas ciudad",17581.2,"kJ/kg"]
[null,"Gas natural",41441.4,"kJ/m3"]
[null,"Energia eléctrica",3600,"kJ/kWh"]