{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Datos (GENERALES)","Datos (SUP AISLADA)","Datos (ESP AISLAMIENTO)","Datos (PPI AISLAMIENTO)","CALIFICACIÓN","COSTE NO AISLAM","Datos (GENERALES) (IMP)","Datos (SUP AISLADA) (IMP)","Datos (ESP AISLAMIENTO) (IMP)","Datos (PPI AISLAMIENTO) (IMP)","CALIFICACIÓN (IMP)","COSTE NO AISLAM (IMP)","RECOMENDACIONES (IMP)","Hoja de programación","Hoja Cálculos Térmicos"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":67,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Datos (GENERALES)","index":0,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CÓDIGO DE INSPECCIÓN"]
["HERRAMIENTA DE PREDIAGNÓSTICO DE ESTADO DE AISLAMIENTO DE SUPERFICIES CALIENTES EN INSTALACIONES INDUSTRIALES"]
[]
["DATOS GENERALES"]
[]
["PROPIEDAD DE LA INSTALACIÓN"]
[]
["DENOMINACIÓN DE LA INSTALACIÓN"]
[]
["DIRECCIÓN POSTAL"]
[]
["MUNICIPIO"]
[]
["CÓDIGO POSTAL"]
[]
["PROVINCIA"]
[]
["COMUNIDAD AUTÓNOMA",{"$f":"IFERROR((VLOOKUP(B17,'Hoja de programación'!$L$2:$M$54,2,FALSE)),\" \")","v":" "}]
[]
["DATOS DEL INSPECTOR"]
[]
["NOMBRE Y APELLIDOS"]
[]
["NIF"]
[]
["RAZÓN SOCIAL"]
[]
["CIF"]
[]
["DIRECCIÓN POSTAL"]
[]
["MUNICIPIO"]
[]
["CÓDIGO POSTAL"]
[]
["PROVINCIA"]
[]
["COMUNIDAD AUTÓNOMA",{"$f":"IFERROR((VLOOKUP(B37,'Hoja de programación'!$L$2:$M$54,2,FALSE)),\" \")","v":" "}]
[]
["e-mail"]
[]
["DATOS DE LA INSPECCIÓN"]
[]
["FECHA"]
[]
["REPRESENTANTE DE LA PROPIEDAD"]
[]
["ALCANCE DEL ESTUDIO"]
[]
["A) Tuberías (hasta 1000 mm de diámetro) o sistemas de tuberías"]
[]
[]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
[]
[]
["DATOS DE LA INSTALACIÓN"]
[]
["Los equipos y tuberías a analizar aparecen en los listados siguientes"]
[]
["A) Tuberías (hasta 1000 mm de diámetro) o sistemas de tuberías"]
[]
["Descripción de tuberías/sistemas de tuberías objeto de la inspección."]
[]
["Item","Descripción","Rango de Temperaturas","Material de aislamiento","Espesor/es de aislamiento","Material de recubrimiento","Espesor de recubrimiento"]
["A1"]
["A2"]
["A3"]
["A4"]
["A5"]
["A6"]
["A7"]
["A8"]
["A9"]
["A10"]
[]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
["Descripción de superficies planas objeto de la inspección."]
[]
["Item","Descripción","Rango de Temperaturas","Material de aislamiento","Espesor/es de aislamiento","Material de recubrimiento","Espesor de recubrimiento"]
["B1"]
["B2"]
["B3"]
["B4"]
["B5"]
["B6"]
["B7"]
["B8"]
["B9"]
["B10"]
[null,null,null,null,null,"e"]
[]
["C) Condiciones Ambientales de la instalación (sólo para el cálculo de pérdidas)"]
[]
["Instalaciones exteriores"]
[]
["Temperatura ambiental media del lugar (Promedio anual TA(ºC) de Guia Técnica Condiciones Clímaticas IDAE):",null,"ºC"]
[]
[]
["Instalaciones interiores"]
[]
["Temperatura ambiental media del interior/temperatura medida el día de la inspección :",null,"ºC"]
[]
[]
["Ante cualquier duda relativa al uso de esta herramienta, puede contactar con: consultas@andimai.es"]
["Para imprimir el informe aditivo completo, pulse a la vez las teclas \"Control\", \"Mayúsculas\" y \"P\" (Ctrl+Mayus+P)"]
["Versión 1.2.0"]

{"sheet":"Datos (SUP AISLADA)","index":1,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["ANEXO 1: SUPERFICIE AISLADA"]
[]
["A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
["Tª superficial de la instalación\n(ºC)","Total m² tubería","Total m² aislados para Conservación de Calor\n(CC)","Total m² aislados para Protección Personal\n(PP)",null,"% de superficie aislada para Conservación de Calor\n(CC)","% de superficie aislada para protección personal (PP)","% de superficie aislada (CC+PP)","% de superficie sin aislamiento",null,"Temperatura media de cada tramo (ºC)","TI\nTemperatura Incremental media para cálculo de CISA\nT(ºC)-60ºC","CISA60 (m²xTI)/1000"]
["60<X≤100",null,null,null,null,{"$f":"IF(B6<>0,C6/B6,0)","v":0},{"$f":"IF(B6<>0,D6/B6,0)","v":0},{"$f":"F6+G6","v":0},{"$f":"IF(B6<>0,1-F6-G6,0)","v":0},null,80,{"$f":"K6-60","v":20},{"$f":"ROUND(L6*B6/1000,0)","v":0}]
["100<X≤200",null,null,null,null,{"$f":"IF(B7<>0,C7/B7,0)","v":0},{"$f":"IF(B7<>0,D7/B7,0)","v":0},{"$f":"F7+G7","v":0},{"$f":"IF(B7<>0,1-F7-G7,0)","v":0},null,150,{"$f":"K7-60","v":90},{"$f":"ROUND(L7*B7/1000,0)","v":0}]
["200<X≤300",null,null,null,null,{"$f":"IF(B8<>0,C8/B8,0)","v":0},{"$f":"IF(B8<>0,D8/B8,0)","v":0},0,0,null,250,190,0]
["300<X≤400",null,null,null,null,0,0,0,0,null,350,290,0]
["400<X≤500",null,null,null,null,0,0,0,0,null,450,390,0]
["500<X≤600",null,null,null,null,0,0,0,0,null,550,490,0]
["600<X≤650",null,null,null,null,0,0,0,0,null,625,565,0]
["TOTAL",{"$f":"SUM(B6:B12)","v":0},{"$f":"SUM(C6:C12)","v":0},{"$f":"SUM(D6:D12)","v":0},null,0,0,{"$f":"F13+G13","v":0},0,null,null,"TOTAL:",{"$f":"SUM(M6:M12)","v":0}]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
["Tª superficial de la instalación\n(ºC)","Total m² equipo","Total m² aislados para Conservación de Calor\n(CC)","Total m² aislados para Protección Personal\n(PP)",null,"% de superficie aislada para Conservación de Calor\n(CC)","% de superficie aislada para protección personal (PP)","% de superficie aislada (CC+PP)","% de superficie sin aislamiento",null,"Temperatura media de cada tramo (ºC)","TI\nTemperatura Incremental media para cálculo de CISA\nT(ºC)-60ºC","CISA60 (m²xTI)/1000"]
["60<X≤100",null,null,null,null,{"$f":"IF(B18<>0,C18/B18,0)","v":0},{"$f":"IF(B18<>0,D18/B18,0)","v":0},{"$f":"F18+G18","v":0},{"$f":"IF(B18<>0,1-F18-G18,0)","v":0},null,80,{"$f":"K18-60","v":20},{"$f":"ROUND(L18*B18/1000,0)","v":0}]
["100<X≤200",null,null,null,null,0,0,{"$f":"F19+G19","v":0},{"$f":"IF(B19<>0,1-F19-G19,0)","v":0},null,150,{"$f":"K19-60","v":90},0]
["200<X≤300",null,null,null,null,0,0,0,0,null,250,190,0]
["300<X≤400",null,null,null,null,0,0,0,0,null,350,290,0]
["400<X≤500",null,null,null,null,0,0,0,0,null,450,390,0]
["500<X≤600",null,null,null,null,0,0,0,0,null,550,490,0]
["600<X≤650",null,null,null,null,0,0,0,0,null,625,565,0]
["TOTAL",{"$f":"SUM(B18:B24)","v":0},{"$f":"SUM(C18:C24)","v":0},{"$f":"SUM(D18:D24)","v":0},null,0,0,{"$f":"F25+G25","v":0},{"$f":"IF(B25<>0,1-F25-G25,0)","v":0},null,null,"TOTAL:",{"$f":"SUM(M18:M24)","v":0}]
[]
["C) Total de superfices calientes en la instalación (A)+(B)"]
[]
["Tª superficial de la instalación\n(ºC)","Total m² ","Total m² aislados para Conservación de Calor\n(CC)","Total m² aislados para Protección Personal\n(PP)",null,"% de superficie aislada para Conservación de Calor\n(CC)","% de superficie aislada para protección personal (PP)","% de superficie aislada (CC+PP)","% de superficie sin aislamiento",null,null,"CISA60 (m²xTI)/1000","% REPARTO CISA60 "]
["TOTAL SUPERFICIES CALIENTES TUBERÍA",{"$f":"B13","v":0},{"$f":"C13","v":0},{"$f":"D13","v":0},null,{"$f":"F13","v":0},{"$f":"G13","v":0},{"$f":"H13","v":0},{"$f":"I13","v":0},null,null,{"$f":"M13","v":0},{"$f":"IFERROR((ROUND(L30/L32,2)),0)","v":0}]
["TOTAL SUPERFICIES CALIENTES EQUIPOS",{"$f":"B25","v":0},{"$f":"C25","v":0},{"$f":"D25","v":0},null,{"$f":"F25","v":0},{"$f":"G25","v":0},{"$f":"H25","v":0},{"$f":"I25","v":0},null,null,{"$f":"M25","v":0},{"$f":"IFERROR((ROUND(L31/L32,2)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"SUM(L30:L31)","v":0},{"$f":"SUM(M30:M31)","v":0}]
["Para imprimir el informe aditivo completo, pulse a la vez las teclas \"Control\", \"Mayúsculas\" y \"P\" (Ctrl+Mayus+P)"]

{"sheet":"Datos (ESP AISLAMIENTO)","index":2,"n_rows":123,"n_cols":5,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[null,"ANEXO 2: ESPESORES DE AISLAMIENTO"]
[]
[null,"A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
[null,"A.1) Superficies de tuberías (hasta 1000 mm de diámetro) aisladas para Conservación de Calor"]
[]
[null,null,null,"Valor promedio de Perdidas Instalación actual en W/m²"]
[]
[null,null,"TABLA 2.A.1"]
[null,null,"Rango de Pérdidas Cálculadas Q (W/m²)","Ponderación por rangos (%)","Ponderación de la instalación Estudiada (%)"]
[null,{"$f":"E11","v":" "},"Q≤90",1,{"$f":"IF((AND($E$7<=90,$E$7<>0)),\"X\",\" \")","v":" "}]
[null,{"$f":"E12","v":" "},"90<Q≤100",{"$f":"D11-0.05","v":0.95},{"$f":"IF((AND($E$7>90,$E$7<=100)),\"X\",\" \")","v":" "}]
[null," ","100<Q≤120",{"$f":"D12-0.05","v":0.89999999999999991},{"$f":"IF((AND($E$7>100,$E$7<=120)),\"X\",\" \")","v":" "}]
[null," ","120<Q≤140",0.84999999999999987,{"$f":"IF((AND($E$7>120,$E$7<=140)),\"X\",\" \")","v":" "}]
[null," ","140<Q≤160",0.79999999999999982,{"$f":"IF((AND($E$7>140,$E$7<=160)),\"X\",\" \")","v":" "}]
[null," ","160<Q≤180",0.74999999999999978,{"$f":"IF((AND($E$7>160,$E$7<=180)),\"X\",\" \")","v":" "}]
[null," ","180<Q≤200",0.69999999999999973,{"$f":"IF((AND($E$7>180,$E$7<=200)),\"X\",\" \")","v":" "}]
[null," ","200<Q≤220",0.64999999999999969,{"$f":"IF((AND($E$7>200,$E$7<=220)),\"X\",\" \")","v":" "}]
[null," ","220<Q≤240",0.59999999999999964,{"$f":"IF((AND($E$7>220,$E$7<=240)),\"X\",\" \")","v":" "}]
[null," ","240<Q≤260",0.5499999999999996,{"$f":"IF((AND($E$7>240,$E$7<=260)),\"X\",\" \")","v":" "}]
[null," ","260<Q≤280",0.49999999999999961,{"$f":"IF((AND($E$7>260,$E$7<=280)),\"X\",\" \")","v":" "}]
[null," ","280<Q≤300",0.44999999999999962,{"$f":"IF((AND($E$7>280,$E$7<=300)),\"X\",\" \")","v":" "}]
[null," ","300<Q≤320",0.39999999999999963,{"$f":"IF((AND($E$7>300,$E$7<=320)),\"X\",\" \")","v":" "}]
[null," ","320<Q≤340",0.34999999999999964,{"$f":"IF((AND($E$7>320,$E$7<=340)),\"X\",\" \")","v":" "}]
[null," ","340<Q≤360",0.29999999999999966,{"$f":"IF((AND($E$7>340,$E$7<=360)),\"X\",\" \")","v":" "}]
[null," ","360<Q≤380",0.24999999999999967,{"$f":"IF((AND($E$7>360,$E$7<=380)),\"X\",\" \")","v":" "}]
[null," ","380<Q≤400",0.19999999999999968,{"$f":"IF((AND($E$7>380,$E$7<=400)),\"X\",\" \")","v":" "}]
[null," ","400<Q",0.14999999999999969,{"$f":"IF($E$7>400,\"X\",\" \")","v":" "}]
[]
[null,"A.2) Superficies de tuberías (hasta 1000 mm de diámetro) aisladas para Protección Personal"]
[]
[null,null,null,"Valor promedio de Perdidas Instalación actual en W/m²"]
[]
[null,null,"TABLA 2.A.2"]
[null,null,"Rango de Pérdidas Cálculadas Q (W/m²)","Ponderación por rangos (%)","Ponderación de la instalación Estudiada (%)"]
[null,{"$f":"E36","v":" "},"Q≤90",1,{"$f":"IF((AND($E$32<=90,$E$32<>0)),\"X\",\" \")","v":" "}]
[null,{"$f":"E37","v":" "},"90<Q≤100",{"$f":"D36-0.05","v":0.95},{"$f":"IF((AND($E$32>90,$E$32<=100)),\"X\",\" \")","v":" "}]
[null," ","100<Q≤120",{"$f":"D37-0.05","v":0.89999999999999991},{"$f":"IF((AND($E$32>100,$E$32<=120)),\"X\",\" \")","v":" "}]
[null," ","120<Q≤140",0.84999999999999987,{"$f":"IF((AND($E$32>120,$E$32<=140)),\"X\",\" \")","v":" "}]
[null," ","140<Q≤160",0.79999999999999982,{"$f":"IF((AND($E$32>140,$E$32<=160)),\"X\",\" \")","v":" "}]
[null," ","160<Q≤180",0.74999999999999978,{"$f":"IF((AND($E$32>160,$E$32<=180)),\"X\",\" \")","v":" "}]
[null," ","180<Q≤200",0.69999999999999973,{"$f":"IF((AND($E$32>180,$E$32<=200)),\"X\",\" \")","v":" "}]
[null," ","200<Q≤220",0.64999999999999969,{"$f":"IF((AND($E$32>200,$E$32<=220)),\"X\",\" \")","v":" "}]
[null," ","220<Q≤240",0.59999999999999964,{"$f":"IF((AND($E$32>220,$E$32<=240)),\"X\",\" \")","v":" "}]
[null," ","240<Q≤260",0.5499999999999996,{"$f":"IF((AND($E$32>240,$E$32<=260)),\"X\",\" \")","v":" "}]
[null," ","260<Q≤280",0.49999999999999961,{"$f":"IF((AND($E$32>260,$E$32<=280)),\"X\",\" \")","v":" "}]
[null," ","280<Q≤300",0.44999999999999962,{"$f":"IF((AND($E$32>280,$E$32<=300)),\"X\",\" \")","v":" "}]
[null," ","300<Q≤320",0.39999999999999963,{"$f":"IF((AND($E$32>300,$E$32<=320)),\"X\",\" \")","v":" "}]
[null," ","320<Q≤340",0.34999999999999964,{"$f":"IF((AND($E$32>320,$E$32<=340)),\"X\",\" \")","v":" "}]
[null," ","340<Q≤360",0.29999999999999966,{"$f":"IF((AND($E$32>340,$E$32<=360)),\"X\",\" \")","v":" "}]
[null," ","360<Q≤380",0.24999999999999967,{"$f":"IF((AND($E$32>360,$E$32<=380)),\"X\",\" \")","v":" "}]
[null," ","380<Q≤400",0.19999999999999968,{"$f":"IF((AND($E$32>380,$E$32<=400)),\"X\",\" \")","v":" "}]
[null," ","400<Q",0.14999999999999969,{"$f":"IF($E$32>400,\"X\",\" \")","v":" "}]
[]
[null,"A.3) Pérdidas promedio en Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
[null,"Tipo","Peso CC ó PP sobre superfices aisladas (%)","Valoración SUPERFICIES DE TUBERIAS","Ponderación de la superficie estudiada (%)"]
[null,"TOTAL TUBERIAS CALIENTES AISLADAS PARA CONSERVACION DE CALOR",{"$f":"IFERROR(('Datos (SUP AISLADA)'!F30/'Datos (SUP AISLADA)'!H30),0)","v":0},{"$f":"IFERROR((VLOOKUP(\"X\",B11:D28,3,FALSE)),0)","v":0},{"$f":"D58*C58","v":0}]
[null,"TOTAL TUBERIAS CALIENTES AISLADAS PARA PROTECCION PERSONAL",{"$f":"IFERROR(('Datos (SUP AISLADA)'!G30/'Datos (SUP AISLADA)'!H30),0)","v":0},{"$f":"IFERROR((VLOOKUP(\"X\",B36:D53,3,FALSE)),0)","v":0},{"$f":"D59*C59","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E58:E59)","v":0}]
[]
[null,"B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
[null,"B.1) Superficies planas (desde 1000 mm de diámetro) y equipos aisladas para Conservación de Calor"]
[]
[null,null,null,"Valor promedio de Perdidas Instalación actual en W/m²"]
[]
[null,null,"TABLA 2.B.1"]
[]
[null,null,"Rango de Pérdidas Cálculadas Q (W/m²)","Ponderación por rangos (%)","Ponderación de la instalación Estudiada (%)"]
[null,{"$f":"E71","v":" "},"Q≤90",1,{"$f":"IF((AND($E$66<=90,$E$66<>0)),\"X\",\" \")","v":" "}]
[null,{"$f":"E72","v":" "},"90<Q≤100",{"$f":"D71-0.05","v":0.95},{"$f":"IF((AND($E$66>90,$E$66<=100)),\"X\",\" \")","v":" "}]
[null," ","100<Q≤120",{"$f":"D72-0.05","v":0.89999999999999991},{"$f":"IF((AND($E$66>100,$E$66<=120)),\"X\",\" \")","v":" "}]
[null," ","120<Q≤140",0.84999999999999987,{"$f":"IF((AND($E$66>120,$E$66<=140)),\"X\",\" \")","v":" "}]
[null," ","140<Q≤160",0.79999999999999982,{"$f":"IF((AND($E$66>140,$E$66<=160)),\"X\",\" \")","v":" "}]
[null," ","160<Q≤180",0.74999999999999978,{"$f":"IF((AND($E$66>160,$E$66<=180)),\"X\",\" \")","v":" "}]
[null," ","180<Q≤200",0.69999999999999973,{"$f":"IF((AND($E$66>180,$E$66<=200)),\"X\",\" \")","v":" "}]
[null," ","200<Q≤220",0.64999999999999969,{"$f":"IF((AND($E$66>200,$E$66<=220)),\"X\",\" \")","v":" "}]
[null," ","220<Q≤240",0.59999999999999964,{"$f":"IF((AND($E$66>220,$E$66<=240)),\"X\",\" \")","v":" "}]
[null," ","240<Q≤260",0.5499999999999996,{"$f":"IF((AND($E$66>240,$E$66<=260)),\"X\",\" \")","v":" "}]
[null," ","260<Q≤280",0.49999999999999961,{"$f":"IF((AND($E$66>260,$E$66<=280)),\"X\",\" \")","v":" "}]
[null," ","280<Q≤300",0.44999999999999962,{"$f":"IF((AND($E$66>280,$E$66<=300)),\"X\",\" \")","v":" "}]
[null," ","300<Q≤320",0.39999999999999963,{"$f":"IF((AND($E$66>300,$E$66<=320)),\"X\",\" \")","v":" "}]
[null," ","320<Q≤340",0.34999999999999964,{"$f":"IF((AND($E$66>320,$E$66<=340)),\"X\",\" \")","v":" "}]
[null," ","340<Q≤360",0.29999999999999966,{"$f":"IF((AND($E$66>340,$E$66<=360)),\"X\",\" \")","v":" "}]
[null," ","360<Q≤380",0.24999999999999967,{"$f":"IF((AND($E$66>360,$E$66<=380)),\"X\",\" \")","v":" "}]
[null," ","380<Q≤400",0.19999999999999968,{"$f":"IF((AND($E$66>380,$E$66<=400)),\"X\",\" \")","v":" "}]
[null," ","400<Q",0.14999999999999969,{"$f":"IF($E$66>400,\"X\",\" \")","v":" "}]
[]
[null,"B.2) Superficies planas (desde 1000 mm de diámetro) y equipos aisladas para Protección Personal"]
[]
[null,null,null,"Valor promedio de Perdidas Instalación actual en W/m²"]
[]
[null,null,"TABLA 2.B.2"]
[]
[null,null,"Rango de Pérdidas Cálculadas Q (W/m²)","Ponderación por rangos (%)","Ponderación de la instalación Estudiada (%)"]
[null,{"$f":"E97","v":" "},"Q≤90",1,{"$f":"IF((AND($E$92<=90,$E$92<>0)),\"X\",\" \")","v":" "}]
[null,{"$f":"E98","v":" "},"90<Q≤100",{"$f":"D97-0.05","v":0.95},{"$f":"IF((AND($E$92>90,$E$92<=100)),\"X\",\" \")","v":" "}]
[null," ","100<Q≤120",{"$f":"D98-0.05","v":0.89999999999999991},{"$f":"IF((AND($E$92>100,$E$92<=120)),\"X\",\" \")","v":" "}]
[null," ","120<Q≤140",0.84999999999999987,{"$f":"IF((AND($E$92>120,$E$92<=140)),\"X\",\" \")","v":" "}]
[null," ","140<Q≤160",0.79999999999999982,{"$f":"IF((AND($E$92>140,$E$92<=160)),\"X\",\" \")","v":" "}]
[null," ","160<Q≤180",0.74999999999999978,{"$f":"IF((AND($E$92>160,$E$92<=180)),\"X\",\" \")","v":" "}]
[null," ","180<Q≤200",0.69999999999999973,{"$f":"IF((AND($E$92>180,$E$92<=200)),\"X\",\" \")","v":" "}]
[null," ","200<Q≤220",0.64999999999999969,{"$f":"IF((AND($E$92>200,$E$92<=220)),\"X\",\" \")","v":" "}]
[null," ","220<Q≤240",0.59999999999999964,{"$f":"IF((AND($E$92>220,$E$92<=240)),\"X\",\" \")","v":" "}]
[null," ","240<Q≤260",0.5499999999999996,{"$f":"IF((AND($E$92>240,$E$92<=260)),\"X\",\" \")","v":" "}]
[null," ","260<Q≤280",0.49999999999999961,{"$f":"IF((AND($E$92>260,$E$92<=280)),\"X\",\" \")","v":" "}]
[null," ","280<Q≤300",0.44999999999999962,{"$f":"IF((AND($E$92>280,$E$92<=300)),\"X\",\" \")","v":" "}]
[null," ","300<Q≤320",0.39999999999999963,{"$f":"IF((AND($E$92>300,$E$92<=320)),\"X\",\" \")","v":" "}]
[null," ","320<Q≤340",0.34999999999999964,{"$f":"IF((AND($E$92>320,$E$92<=340)),\"X\",\" \")","v":" "}]
[null," ","340<Q≤360",0.29999999999999966,{"$f":"IF((AND($E$92>340,$E$92<=360)),\"X\",\" \")","v":" "}]
[null," ","360<Q≤380",0.24999999999999967,{"$f":"IF((AND($E$92>360,$E$92<=380)),\"X\",\" \")","v":" "}]
[null," ","380<Q≤400",0.19999999999999968,{"$f":"IF((AND($E$92>380,$E$92<=400)),\"X\",\" \")","v":" "}]
[null," ","400<Q",0.14999999999999969,{"$f":"IF($E$92>400,\"X\",\" \")","v":" "}]
[]
[null,"B.3) Pérdidas promedio en Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
[null,"Tipo","Peso CC ó PP sobre superfices aisladas (%)","Valoración SUPERFICIES DE TUBERIAS","Ponderación de la superficie estudiada (%)"]
[null,"TOTAL SUPERFICIES PLANAS CALIENTES AISLADAS PARA CONSERVACION DE CALOR",{"$f":"IFERROR(('Datos (SUP AISLADA)'!F31/'Datos (SUP AISLADA)'!H31),0)","v":0},{"$f":"IFERROR((VLOOKUP(\"X\",B71:D88,3,FALSE)),0)","v":0},{"$f":"D119*C119","v":0}]
[null,"TOTAL SUPERFICIES PLANAS CALIENTES AISLADAS PARA PROTECCION PERSONAL",{"$f":"IFERROR(('Datos (SUP AISLADA)'!G31/'Datos (SUP AISLADA)'!H31),0)","v":0},{"$f":"IFERROR((VLOOKUP(\"X\",B97:D114,3,FALSE)),0)","v":0},{"$f":"D120*C120","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E119:E120)","v":0}]
[]
[null,"Para imprimir el informe aditivo completo, pulse a la vez las teclas \"Control\", \"Mayúsculas\" y \"P\" (Ctrl+Mayus+P)"]

{"sheet":"Datos (PPI AISLAMIENTO)","index":3,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"ANEXO 3: Registro de Puntos de Inspección en Aislamiento "]
[]
[null,"A) Registro de Puntos de Inspección de tuberías aisladas"]
[]
[null,null,null,null,null,null,"TIPO  DE CONTROL"]
[null,"Columna1","PUNTOS DE INSPECCIÓN","CRITERIOS DE ACEPTACIÓN","PUNTO DE LA GUIA","MUESTRA INSTALACION","V","D","P","C","T","VALORACIÓN INSPECTOR","OBSERVACIONES INSPECTOR","Peso Parcial (%) de Punto de Inspección","Ponderación puntos (%)"]
[null,"Soporte del aislamiento","Colocación de los distanciadores, si procede (altura y separación)","Superficies horizontales: 950 mm ± 30 mm; Superficies Verticales: mínimo cada 3 metros. Según Guía","3.3.1 \n4.3.1",0.05,null,null,null,null,null,null,null,0.03,{"$f":"ROUND($L7*$N7,3)","v":0}]
[null,"Soporte del aislamiento","Rotura de puente térmico","Según Guía","3.3.1 \n4.3.1",0.05,null,null,null,null,null,null,null,0.03,{"$f":"ROUND($L8*$N8,3)","v":0},null,0.71890134518053506,0.80522932474640929,0.96295868900233872,0.98649170993241442]
[null,"Material aislante","Tipo y espesor de aislamiento instalado","Corresponde con las especificaciones/ guía","3.1\n4.3.2",0.2,null,null,null,null,null,null,null,{"$f":"0.5*(0.42-$N$10)","v":0.21},{"$f":"ROUND($L9*$N9,3)","v":0},null,"V","D","P","C","T"]
[null,"Material aislante","Estado del aislamiento instalado ","Realización de:\n-Inspecciones visuales\n-Inspecciones Dimensionales\n-Inpecciones  mediante informacion de planos\n-Inspecciones mediante informacion de certicados\n-Inspecciones mediante termografías","General",0.05,null,null,null,null,null,null,null,{"$f":"+V11","v":0},{"$f":"ROUND($L10*$N10,3)","v":0},null,{"$f":"+IF(G10=\"X\",0.2,0)","v":0},{"$f":"+IF(H10=\"X\",0.22,0)","v":0},{"$f":"+IF(I10=\"X\",0.24,0)","v":0},{"$f":"+IF(J10=\"X\",0.28,0)","v":0},{"$f":"+IF(K10=\"X\",0.3,0)","v":0},{"$f":"SUM(Q10:U10)","v":0}]
[null,"Material aislante","Adecuada sujección","Según especificaciones","3.1\n4.3.2",0.05,null,null,null,null,null,null,null,{"$f":"0.25*(0.42-$N$10)","v":0.105},{"$f":"ROUND($L11*$N11,3)","v":0},null,{"$f":"+IF($K$10=\"x\",0,IF($V$10>0.3,IF(G10=\"x\",Q8*Q10*0.3/$V$10,0),IF(G10=\"x\",Q10,0)))","v":0},{"$f":"+IF($K$10=\"x\",0,IF($V$10>0.3,IF(H10=\"x\",R8*R10*0.3/$V$10,0),IF(H10=\"x\",R10,0)))","v":0},{"$f":"+IF($K$10=\"x\",0,IF($V$10>0.3,IF(I10=\"x\",S8*S10*0.3/$V$10,0),IF(I10=\"x\",S10,0)))","v":0},{"$f":"+IF($K$10=\"x\",0,IF($V$10>0.3,IF(J10=\"x\",T8*T10*0.3/$V$10,0),IF(J10=\"x\",T10,0)))","v":0},{"$f":"IF(SUM(Q11:T11)>0,0,IF(K10=\"x\",U10,0))","v":0},{"$f":"SUM(Q11:U11)","v":0}]
[null,"Material aislante","Juntas a tope y contrapeadas (multicapa)","Según especificaciones","3.1\n4.3.2",0.05,null,null,null,null,null,null,null,{"$f":"0.25*(0.42-$N$10)","v":0.105},0]
[null,"Protección metálica","Tipo y espesor del recubrimiento instalado","Corresponde con las especificaciones/ guía","3.2.1\n4.3.3",0.2,null,null,null,null,null,null,null,0.06,0]
[null,"Protección metálica","Ejecución de bordones y solapes","Según Guía","3.2.1\n4.3.3",0.05,null,null,null,null,null,null,null,0.05,0]
[null,"Protección metálica","Fijación por tornillos / remaches POP","Aprox. cada 250 mm. Según Guía","4.3.3",0.05,null,null,null,null,null,null,null,0.02,0]
[null,"Protección metálica","Superficie aislada (bridas, válvulas,..)","Según especificaciones","3,1\n4.3.2",1,null,null,null,null,null,null,null,7.0000000000000007E-2,0]
[null,"Montaje","Correcta instalación a favor de agua","Según Guía","4.3.3",0.05,null,null,null,null,null,null,null,0.06,0]
[null,"Montaje","Correcto sellado (donde haya riesgo de entrada de agua de lluvía)","Según Guía","4.3.3",0.05,null,null,null,null,null,null,null,0.06,0]
[null,"Montaje","Uso de tapas en finales de aislamiento (cajas desmontables, etc)","Según Guía","4.11",0.05,null,null,null,null,null,null,null,0.04,0]
[null,"Montaje","Correcto tratamiento salidas  de traceado.","Según Guía","4.11",0.05,null,null,null,null,null,null,null,0.02,0]
[null,"Montaje","Tratamiento de puentes térmicos (tapas, instrumentos, etc)","Según Guía","4.11",0.05,null,null,null,null,null,null,null,0.04,0]
[null,"Acabado final","No presenta golpes, ni aberturas, ni daños.","Inspección general","Guía",0.05,null,null,null,null,null,null,null,0.1,0]
[null,null,"• V= Visual • D= Dimensional • P= Información de Planos\n• C= Información de Certificados • T= Termografía",null,null,null,null,null,null,null,null,null,null,"TOTAL PPI",{"$f":"SUM($O7:$O22)","v":0}]
[]
[null,"B) Registro de Puntos de Inspección en Aislamiento de equipos aislados"]
[]
[null,null,null,null,null,null,"TIPO  DE CONTROL"]
[null,"Columna1","PUNTOS DE INSPECCIÓN","CRITERIOS DE ACEPTACIÓN","PUNTO DE LA GUIA","MUESTRA INSTALACION","V","D","P","C","T","VALORACIÓN INSPECTOR","OBSERVACIONES INSPECTOR","Peso Parcial (%) de Punto de Inspección","Ponderación puntos (%)"]
[null,"Soporte del aislamiento","Colocación de los distanciadores, si procede (altura y separación)","Superficies horizontales: 950 mm ± 30 mm; Superficies Verticales: mínimo cada 3 metros. Según Guía","3.3.1 \n4.3.1\n ",0.05,null,null,null,null,null,null,null,0.03,{"$f":"ROUND($L29*$N29,3)","v":0}]
[null,"Soporte del aislamiento","Rotura de puente térmico","Según Guía","3.3.1 \n4.3.1\n",0.05,null,null,null,null,null,null,null,0.03,{"$f":"ROUND($L30*$N30,3)","v":0},null,0.71890134518053506,0.80522932474640929,0.96295868900233872,0.98649170993241442]
[null,"Material aislante","Tipo y espesor de aislamiento instalado","Corresponde con las especificaciones/ guía","3,1\n4.3.2",0.2,null,null,null,null,null,null,null,{"$f":"0.5*(0.42-$N$32)","v":0.21},0,null,"V","D","P","C","T"]
[null,"Material aislante","Estado del aislamiento instalado ","Realización de:\n-Inspecciones visuales\n-Inspecciones Dimensionales\n-Inpecciones  mediante informacion de planos\n-Inspecciones mediante informacion de certicados\n-Inspecciones mediante termografías","3,1\n4.3.2",0.05,null,null,null,null,null,null,null,{"$f":"+V33","v":0},0,null,{"$f":"+IF(G32=\"X\",0.2,0)","v":0},{"$f":"+IF(H32=\"X\",0.22,0)","v":0},{"$f":"+IF(I32=\"X\",0.24,0)","v":0},{"$f":"+IF(J32=\"X\",0.28,0)","v":0},{"$f":"+IF(K32=\"X\",0.3,0)","v":0},{"$f":"SUM(Q32:U32)","v":0}]
[null,"Material aislante","Adecuada sujección","Según especificaciones","3,1\n4.3.2",0.05,null,null,null,null,null,null,null,{"$f":"0.25*(0.42-$N$32)","v":0.105},0,null,{"$f":"+IF($K$32=\"x\",0,IF($V$32>0.3,IF(G32=\"x\",Q30*Q32*0.3/$V$32,0),IF(G32=\"x\",Q32,0)))","v":0},{"$f":"+IF($K$32=\"x\",0,IF($V$32>0.3,IF(H32=\"x\",R30*R32*0.3/$V$32,0),IF(H32=\"x\",R32,0)))","v":0},0,0,{"$f":"IF(SUM(Q33:T33)>0,0,IF(K32=\"x\",U32,0))","v":0},{"$f":"SUM(Q33:U33)","v":0}]
[null,"Material aislante","Juntas a tope y contrapeadas (multicapa)","Según especificaciones","3,1\n4.3.2",0.05,null,null,null,null,null,null,null,{"$f":"0.25*(0.42-$N$32)","v":0.105},0]
[null,"Protección metálica","Tipo y espesor del material instalado","Según especificaciones/ guía","3.2.1\n4.3.3",0.2,null,null,null,null,null,null,null,0.06,0]
[null,"Protección metálica","Ejecución de bordones y solapes","Según Guía","3.2.1\n4.3.3",0.05,null,null,null,null,null,null,null,0.05,0]
[null,"Protección metálica","Fijación por tornillos / remaches POP","Aprox. cada 250 mm. Según Guía","4.3.3",0.05,null,null,null,null,null,null,null,0.02,0]
[null,"Protección metálica","Superficie aislada (bridas, válvulas,..)","Según especificaciones","3.1\n4.3.2",1,null,null,null,null,null,null,null,7.0000000000000007E-2,0]
[null,"Montaje","Correcta instalación a favor de agua","Según Guía","4.3.3",0.05,null,null,null,null,null,null,null,0.06,0]
[null,"Montaje","Correcto sellado (donde haya riesgo de entrada de agua de lluvía)","Según Guía","4.3.3",0.05,null,null,null,null,null,null,null,0.06,0]
[null,"Montaje","Uso de tapas en finales de aislamiento ( cajas desmontables, rosetas,…)","Según Guía","4.11",0.05,null,null,null,null,null,null,null,0.04,0]
[null,"Montaje","Correcto tratamiento salidas  de traceaado.","Según Guía","4.11",0.05,null,null,null,null,null,null,null,0.02,0]
[null,"Montaje","Tratamiento de puentes térmicos (tapas, instrumentos,…)","Según Guía","4.11",0.05,null,null,null,null,null,null,null,0.04,0]
[null,"Acabado final","No presenta golpes, ni aberturas, ni daños.","Inspección general","Guía",0.05,null,null,null,null,null,null,null,0.1,0]
[null,null,"• V= Visual • D= Dimensional • P= Información de Planos\n• C= Información de Certificados • T= Termografía",null,null,null,null,null,null,null,null,null,null,"TOTAL PPI",{"$f":"SUM($O29:$O44)","v":0}]
[null,"Para imprimir el informe aditivo completo, pulse a la vez las teclas \"Control\", \"Mayúsculas\" y \"P\" (Ctrl+Mayus+P)"]

{"sheet":"CALIFICACIÓN","index":4,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["CÁLCULO DE LA CALIFICACIÓN DE LA INSTALACIÓN"]
[]
["A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
["Tuberías","Nota BASE (N)","Ponderación Superficies Aisladas (% 1) ","Ponderación Calidad de aislamiento (% 2) ","Nota Total Obtenida \n(N x %1 x %2)"]
["ANEXO 2.a): Espesores de Aislamiento",6,{"$f":"'Datos (SUP AISLADA)'!H30","v":0},{"$f":"'Datos (ESP AISLAMIENTO)'!E60","v":0},{"$f":"ROUND($D6*$C6*$B6,2)","v":0}]
["ANEXO 3.a): Registros de Inspección",4,{"$f":"'Datos (SUP AISLADA)'!H30","v":0},{"$f":"'Datos (PPI AISLAMIENTO)'!O23","v":0},{"$f":"ROUND($D7*$C7*$B7,2)","v":0}]
["TOTAL NOTA MÁXIMA",{"$f":"SUM(Tabla30[Nota BASE (N)])","v":10},null,"TOTAL",{"$f":"SUM($E6:$E7)","v":0}]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
["Tuberías","Nota BASE (N)","Ponderación Superficies Aisladas (% 1). ","Ponderación Calidad de aislamiento (% 2). ","Nota Total Obtenida \n(N x %1 x %2)"]
["ANEXO 2.b): Espesores de Aislamiento",6,{"$f":"'Datos (SUP AISLADA)'!H31","v":0},{"$f":"'Datos (ESP AISLAMIENTO)'!E121","v":0},{"$f":"ROUND($D13*$C13*$B13,2)","v":0}]
["ANEXO 3.b): Registros de Inspección",4,{"$f":"'Datos (SUP AISLADA)'!H31","v":0},{"$f":"'Datos (PPI AISLAMIENTO)'!O45","v":0},{"$f":"ROUND($D14*$C14*$B14,2)","v":0}]
["TOTAL NOTA MÁXIMA",{"$f":"SUM(B13:B14)","v":10},null,"TOTAL",{"$f":"SUM($E13:$E14)","v":0}]
[]
["C) Total de superfices calientes en la instalación (A)+(B)"]
[]
["Según tabla a continuación:"]
[]
["Sistema","PESO CISA (%)","NOTA PARCIAL","NOTA PONDERADA"]
["Tuberías",{"$f":"'Datos (SUP AISLADA)'!$M$30","v":0},{"$f":"$E$8","v":0},{"$f":"IFERROR((ROUND($C$22*$B$22,2)),0)","v":0}]
["Equipos",{"$f":"'Datos (SUP AISLADA)'!$M$31","v":0},{"$f":"$E$15","v":0},{"$f":"IFERROR((ROUND($C$23*$B$23,2)),0)","v":0}]
[null,null,"NOTA GLOBAL",{"$f":"SUM($D$22:$D$23)","v":0}]
[]
["CALIFICACIÓN OBTENIDA"]
[]
[null,null,"NOTA:",{"$f":"D24","v":0}]
[]
[null,"Rango","Nota","Recomendaciones"]
[null,"más de 9","Excelente","Mantenimiento Preventivo"]
[null,"de 7 a 9","Bueno","Mantenimiento Preventivo. Actuaciones puntuales"]
[null,"de 5 a 7","Deficiente","Mantenimiento Correctivo y Preventivo. Actuaciones de mejora"]
[null,"menos de 5","Muy deficiente","Actuaciones generalizadas de mejora"]
[]
["Para imprimir el informe aditivo completo, pulse a la vez las teclas \"Control\", \"Mayúsculas\" y \"P\" (Ctrl+Mayus+P)"]

{"sheet":"COSTE NO AISLAM","index":5,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["COSTE DE NO AISLAMIENTO"]
[]
["Precio adoptado energía kWh",null,null,null,null,"€/kWh"]
[]
["A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
["Número de horas anuales de trabajo bajo condiciones de operación",null,null,null,null,"horas/año"]
[]
["Tª superficial de la instalación X\n(ºC)","Total m²\nSIN AISLAR","Diámetro medio\n(mm)","Total pérdidas kW/m²","Total pérdidas kWh/año","Total €/año"]
["60<X≤100",{"$f":"'Datos (SUP AISLADA)'!B6-'Datos (SUP AISLADA)'!C6-'Datos (SUP AISLADA)'!D6","v":0},null,{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q8),0)","v":0},{"$f":"D10*B10*$E$7","v":0},{"$f":"E10*$E$3","v":0}]
["100<X≤200",{"$f":"'Datos (SUP AISLADA)'!B7-'Datos (SUP AISLADA)'!C7-'Datos (SUP AISLADA)'!D7","v":0},null,{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q9),0)","v":0},0,0]
["200<X≤300",{"$f":"'Datos (SUP AISLADA)'!B8-'Datos (SUP AISLADA)'!C8-'Datos (SUP AISLADA)'!D8","v":0},null,{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q10),0)","v":0},0,0]
["300<X≤400",{"$f":"'Datos (SUP AISLADA)'!B9-'Datos (SUP AISLADA)'!C9-'Datos (SUP AISLADA)'!D9","v":0},null,{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q11),0)","v":0},0,0]
["400<X≤500",{"$f":"'Datos (SUP AISLADA)'!B10-'Datos (SUP AISLADA)'!C10-'Datos (SUP AISLADA)'!D10","v":0},null,{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q12),0)","v":0},0,0]
["500<X≤600",{"$f":"'Datos (SUP AISLADA)'!B11-'Datos (SUP AISLADA)'!C11-'Datos (SUP AISLADA)'!D11","v":0},null,{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q13),0)","v":0},0,0]
["600<X≤650",{"$f":"'Datos (SUP AISLADA)'!B12-'Datos (SUP AISLADA)'!C12-'Datos (SUP AISLADA)'!D12","v":0},null,{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q14),0)","v":0},0,0]
["TOTAL",{"$f":"SUM(B10:B16)","v":0},null,null,{"$f":"SUM(E10:E16)","v":0},{"$f":"SUM(F10:F16)","v":0}]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
["Número de horas anuales de trabajo bajo condiciones de operación",null,null,null,null,"horas/año"]
[]
["Tª superficial de la instalación X\n(ºC)","Total m²\nSIN AISLAR","Total pérdidas kW/m²","Total pérdidas kW/m²2","Total pérdidas kWh/año"]
["60<X≤100",{"$f":"'Datos (SUP AISLADA)'!B18-'Datos (SUP AISLADA)'!C18-'Datos (SUP AISLADA)'!D18","v":0},{"$f":"'Hoja Cálculos Térmicos'!I23","v":1.0376688970110231},{"$f":"C24*B24*$E$21","v":0},{"$f":"D24*$E$3","v":0}]
["100<X≤200",{"$f":"'Datos (SUP AISLADA)'!B19-'Datos (SUP AISLADA)'!C19-'Datos (SUP AISLADA)'!D19","v":0},{"$f":"'Hoja Cálculos Térmicos'!I24","v":2.5104347777449632},{"$f":"C25*B25*$E$21","v":0},{"$f":"D25*$E$3","v":0}]
["200<X≤300",{"$f":"'Datos (SUP AISLADA)'!B20-'Datos (SUP AISLADA)'!C20-'Datos (SUP AISLADA)'!D20","v":0},{"$f":"'Hoja Cálculos Térmicos'!I25","v":5.7314539364789781},{"$f":"C26*B26*$E$21","v":0},{"$f":"D26*$E$3","v":0}]
["300<X≤400",{"$f":"'Datos (SUP AISLADA)'!B21-'Datos (SUP AISLADA)'!C21-'Datos (SUP AISLADA)'!D21","v":0},{"$f":"'Hoja Cálculos Térmicos'!I26","v":10.749545202154277},0,0]
["400<X≤500",{"$f":"'Datos (SUP AISLADA)'!B22-'Datos (SUP AISLADA)'!C22-'Datos (SUP AISLADA)'!D22","v":0},{"$f":"'Hoja Cálculos Térmicos'!I27","v":18.240721111831128},0,0]
["500<X≤600",{"$f":"'Datos (SUP AISLADA)'!B23-'Datos (SUP AISLADA)'!C23-'Datos (SUP AISLADA)'!D23","v":0},{"$f":"'Hoja Cálculos Térmicos'!I28","v":29.014160678102463},0,0]
["600<X≤650",{"$f":"'Datos (SUP AISLADA)'!B24-'Datos (SUP AISLADA)'!C24-'Datos (SUP AISLADA)'!D24","v":0},{"$f":"'Hoja Cálculos Térmicos'!I29","v":39.806966793306259},0,0]
["TOTAL",{"$f":"SUM(B24:B30)","v":0},null,null,{"$f":"SUM(E24:E30)","v":0}]
[]
["C) Coste de no aislamiento en todas las superficies"]
[]
["Tª superficial de la instalación X\n(ºC)","Total m²\nSIN AISLAR","Total €/año"]
["60<X≤100",{"$f":"B10+B24","v":0},{"$f":"F10+E24","v":0}]
["100<X≤200",0,{"$f":"F11+E25","v":0}]
["200<X≤300",0,0]
["300<X≤400",0,0]
["400<X≤500",0,0]
["500<X≤600",0,0]
["600<X≤650",0,0]
["TOTAL",{"$f":"SUM(B36:B42)","v":0},{"$f":"SUM(C36:C42)","v":0}]
[]
["Para imprimir el informe aditivo completo, pulse a la vez las teclas \"Control\", \"Mayúsculas\" y \"P\" (Ctrl+Mayus+P)"]

{"sheet":"Datos (GENERALES) (IMP)","index":6,"n_rows":111,"n_cols":11,"rows_kept":111,"cut":false,"hidden":true,"merged":[[1,1,2,7],[2,9,2,10],[1,9,1,10],[32,3,32,10],[6,1,6,2],[8,1,8,2],[10,1,10,2],[13,1,13,2],[15,1,15,2],[17,1,17,2],[21,1,21,2],[4,0,4,10],[19,0,19,10],[23,1,23,2],[25,1,25,2],[6,3,6,10],[8,3,8,10],[10,3,11,10],[13,3,13,5],[13,9,13,10],[53,1,58,10],[44,1,49,10],[25,3,26,10],[51,0,51,10],[34,0,34,10],[36,1,36,2],[21,3,21,5],[28,1,28,2],[30,1,30,2],[32,1,32,2],[42,0,42,10],[38,1,38,2],[69,7,69,9],[74,5,74,6],[75,5,75,6],[70,7,70,9],[71,7,71,9],[77,5,77,6],[78,5,78,6],[69,5,69,6],[70,5,70,6],[71,5,71,6],[72,5,72,6],[73,5,73,6],[15,3,15,5],[68,5,68,6],[38,3,38,10],[30,3,30,5],[28,3,28,5],[64,0,64,10],[68,7,68,9],[30,7,30,10],[23,7,23,10],[21,7,21,10],[36,3,36,6],[40,0,40,10],[17,3,17,10],[23,3,23,5],[28,9,28,10],[60,0,60,10],[102,2,103,6],[95,5,95,6],[92,5,92,6],[93,5,93,6],[72,7,72,9],[73,7,73,9],[74,7,74,9],[75,7,75,9],[86,7,86,9],[76,7,76,9],[77,7,77,9],[78,7,78,9],[85,7,85,9],[81,0,81,10],[98,0,98,10],[76,5,76,6],[88,5,88,6],[89,5,89,6],[95,7,95,9],[91,7,91,9],[91,5,91,6],[85,5,85,6],[86,5,86,6],[87,5,87,6],[110,7,110,10],[94,5,94,6],[92,7,92,9],[93,7,93,9],[94,7,94,9],[90,5,90,6],[87,7,87,9],[88,7,88,9],[89,7,89,9],[90,7,90,9],[107,2,107,6],[103,7,103,9],[107,7,107,9]]}
[]
[null,"HERRAMIENTA DE PREDIAGNÓSTICO DE ESTADO DE AISLAMIENTO DE SUPERFICIES CALIENTES EN INSTALACIONES INDUSTRIALES",null,null,null,null,null,null,null,"CÓDIGO DE INSPECCIÓN"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Datos (GENERALES)'!B3=0,\" \",'Datos (GENERALES)'!B3)","v":" "}]
[]
["DATOS GENERALES"]
[]
[null,"PROPIEDAD DE LA INSTALACIÓN",null,{"$f":"IF('Datos (GENERALES)'!B7=0,\" \",'Datos (GENERALES)'!B7)","v":" "}]
[]
[null,"DENOMINACIÓN DE LA INSTALACIÓN",null,{"$f":"IF('Datos (GENERALES)'!B9=0,\" \",'Datos (GENERALES)'!B9)","v":" "}]
[]
[null,"DIRECCIÓN POSTAL",null,{"$f":"IF('Datos (GENERALES)'!B11=0,\" \",'Datos (GENERALES)'!B11)","v":" "}]
[]
[]
[null,"MUNICIPIO",null,{"$f":"IF('Datos (GENERALES)'!B13=0,\" \",'Datos (GENERALES)'!B13)","v":" "},null,null,"CÓDIGO POSTAL",null,null,{"$f":"IF('Datos (GENERALES)'!B15=0,\" \",'Datos (GENERALES)'!B15)","v":" "}]
[]
[null,"PROVINCIA",null,{"$f":"IF('Datos (GENERALES)'!B17=0,\" \",'Datos (GENERALES)'!B17)","v":" "}]
[]
[null,"COMUNIDAD AUTÓNOMA",null,{"$f":"IFERROR((VLOOKUP(D16,'Hoja de programación'!$L$2:$M$54,2,FALSE)),\" \")","v":" "}]
[]
["DATOS DEL INSPECTOR"]
[]
[null,"NOMBRE Y APELLIDOS",null,{"$f":"IF('Datos (GENERALES)'!B23=0,\" \",'Datos (GENERALES)'!B23)","v":" "},null,null,"NIF",{"$f":"IF('Datos (GENERALES)'!B25=0,\" \",'Datos (GENERALES)'!B25)","v":" "}]
[]
[null,"RAZÓN SOCIAL",null,{"$f":"IF('Datos (GENERALES)'!B27=0,\" \",'Datos (GENERALES)'!B27)","v":" "},null,null,"CIF",{"$f":"IF('Datos (GENERALES)'!B29=0,\"\",'Datos (GENERALES)'!B29)","v":""}]
[]
[null,"DIRECCIÓN POSTAL",null,{"$f":"IF('Datos (GENERALES)'!B31=0,\" \",'Datos (GENERALES)'!B31)","v":" "}]
[]
[]
[null,"MUNICIPIO",null,{"$f":"IF('Datos (GENERALES)'!B33=0,\" \",'Datos (GENERALES)'!B33)","v":" "},null,null,"CÓDIGO POSTAL",null,null,{"$f":"IF('Datos (GENERALES)'!B35=0,\" \",'Datos (GENERALES)'!B35)","v":" "}]
[]
[null,"PROVINCIA",null,{"$f":"IF('Datos (GENERALES)'!B37=0,\" \",'Datos (GENERALES)'!B37)","v":" "},null,null,"e-mail",{"$f":"IF('Datos (GENERALES)'!B41=0,\" \",'Datos (GENERALES)'!B41)","v":" "}]
[]
[null,"COMUNIDAD AUTÓNOMA",null,{"$f":"IFERROR((VLOOKUP(D31,'Hoja de programación'!$L$2:$M$54,2,FALSE)),\" \")","v":" "}]
[]
["DATOS DE LA INSPECCIÓN"]
[]
[null,"FECHA",null,{"$f":"IF('Datos (GENERALES)'!B45=0,\" \",'Datos (GENERALES)'!B45)","v":" "}]
[]
[null,"REPRESENTANTE DE LA PROPIEDAD",null,{"$f":"IF('Datos (GENERALES)'!B47=0,\" \",'Datos (GENERALES)'!B47)","v":" "}]
[]
["ALCANCE DEL ESTUDIO"]
[]
["A) Tuberías (hasta 1000 mm de diámetro) o sistemas de tuberías - Descripción"]
[]
[null,{"$f":"IF('Datos (GENERALES)'!A53=0,\" \",'Datos (GENERALES)'!A53)","v":" "}]
[]
[]
[]
[]
[]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos - Descripción"]
[]
[null,{"$f":"IF('Datos (GENERALES)'!A57=0,\" \",'Datos (GENERALES)'!A57)","v":" "}]
[]
[]
[]
[]
[]
[]
["DATOS DE LA INSTALACIÓN"]
[]
[null,"Los equipos y tuberías a analizar aparecen en los listados siguientes"]
[]
["A) Tuberías (hasta 1000 mm de diámetro) o sistemas de tuberías"]
[]
[null,"Descripción de tuberías/sistemas de tuberías objeto de la inspección."]
[]
[null,"Item","Descripción","Rango de Temperaturas","Material de aislamiento","Espesor/es de aislamiento",null,"Material de recubrimiento",null,null,"Espesor de recubrimiento"]
[null,"A1",{"$f":"IF('Datos (GENERALES)'!B68=0,\" \",'Datos (GENERALES)'!B68)","v":" "},{"$f":"IF('Datos (GENERALES)'!C68=0,\" \",'Datos (GENERALES)'!C68)","v":" "},{"$f":"IF('Datos (GENERALES)'!D68=0,\" \",'Datos (GENERALES)'!D68)","v":" "},{"$f":"IF('Datos (GENERALES)'!E68=0,\" \",'Datos (GENERALES)'!E68)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F68=0,\" \",'Datos (GENERALES)'!F68)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G68=0,\" \",'Datos (GENERALES)'!G68)","v":" "}]
[null,"A2",{"$f":"IF('Datos (GENERALES)'!B69=0,\" \",'Datos (GENERALES)'!B69)","v":" "},{"$f":"IF('Datos (GENERALES)'!C69=0,\" \",'Datos (GENERALES)'!C69)","v":" "},{"$f":"IF('Datos (GENERALES)'!D69=0,\" \",'Datos (GENERALES)'!D69)","v":" "},{"$f":"IF('Datos (GENERALES)'!E69=0,\" \",'Datos (GENERALES)'!E69)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F69=0,\" \",'Datos (GENERALES)'!F69)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G69=0,\" \",'Datos (GENERALES)'!G69)","v":" "}]
[null,"A3",{"$f":"IF('Datos (GENERALES)'!B70=0,\" \",'Datos (GENERALES)'!B70)","v":" "},{"$f":"IF('Datos (GENERALES)'!C70=0,\" \",'Datos (GENERALES)'!C70)","v":" "},{"$f":"IF('Datos (GENERALES)'!D70=0,\" \",'Datos (GENERALES)'!D70)","v":" "},{"$f":"IF('Datos (GENERALES)'!E70=0,\" \",'Datos (GENERALES)'!E70)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F70=0,\" \",'Datos (GENERALES)'!F70)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G70=0,\" \",'Datos (GENERALES)'!G70)","v":" "}]
[null,"A4",{"$f":"IF('Datos (GENERALES)'!B71=0,\" \",'Datos (GENERALES)'!B71)","v":" "},{"$f":"IF('Datos (GENERALES)'!C71=0,\" \",'Datos (GENERALES)'!C71)","v":" "},{"$f":"IF('Datos (GENERALES)'!D71=0,\" \",'Datos (GENERALES)'!D71)","v":" "},{"$f":"IF('Datos (GENERALES)'!E71=0,\" \",'Datos (GENERALES)'!E71)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F71=0,\" \",'Datos (GENERALES)'!F71)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G71=0,\" \",'Datos (GENERALES)'!G71)","v":" "}]
[null,"A5",{"$f":"IF('Datos (GENERALES)'!B72=0,\" \",'Datos (GENERALES)'!B72)","v":" "},{"$f":"IF('Datos (GENERALES)'!C72=0,\" \",'Datos (GENERALES)'!C72)","v":" "},{"$f":"IF('Datos (GENERALES)'!D72=0,\" \",'Datos (GENERALES)'!D72)","v":" "},{"$f":"IF('Datos (GENERALES)'!E72=0,\" \",'Datos (GENERALES)'!E72)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F72=0,\" \",'Datos (GENERALES)'!F72)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G72=0,\" \",'Datos (GENERALES)'!G72)","v":" "}]
[null,"A6",{"$f":"IF('Datos (GENERALES)'!B73=0,\" \",'Datos (GENERALES)'!B73)","v":" "},{"$f":"IF('Datos (GENERALES)'!C73=0,\" \",'Datos (GENERALES)'!C73)","v":" "},{"$f":"IF('Datos (GENERALES)'!D73=0,\" \",'Datos (GENERALES)'!D73)","v":" "},{"$f":"IF('Datos (GENERALES)'!E73=0,\" \",'Datos (GENERALES)'!E73)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F73=0,\" \",'Datos (GENERALES)'!F73)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G73=0,\" \",'Datos (GENERALES)'!G73)","v":" "}]
[null,"A7",{"$f":"IF('Datos (GENERALES)'!B74=0,\" \",'Datos (GENERALES)'!B74)","v":" "},{"$f":"IF('Datos (GENERALES)'!C74=0,\" \",'Datos (GENERALES)'!C74)","v":" "},{"$f":"IF('Datos (GENERALES)'!D74=0,\" \",'Datos (GENERALES)'!D74)","v":" "},{"$f":"IF('Datos (GENERALES)'!E74=0,\" \",'Datos (GENERALES)'!E74)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F74=0,\" \",'Datos (GENERALES)'!F74)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G74=0,\" \",'Datos (GENERALES)'!G74)","v":" "}]
[null,"A8",{"$f":"IF('Datos (GENERALES)'!B75=0,\" \",'Datos (GENERALES)'!B75)","v":" "},{"$f":"IF('Datos (GENERALES)'!C75=0,\" \",'Datos (GENERALES)'!C75)","v":" "},{"$f":"IF('Datos (GENERALES)'!D75=0,\" \",'Datos (GENERALES)'!D75)","v":" "},{"$f":"IF('Datos (GENERALES)'!E75=0,\" \",'Datos (GENERALES)'!E75)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F75=0,\" \",'Datos (GENERALES)'!F75)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G75=0,\" \",'Datos (GENERALES)'!G75)","v":" "}]
[null,"A9",{"$f":"IF('Datos (GENERALES)'!B76=0,\" \",'Datos (GENERALES)'!B76)","v":" "},{"$f":"IF('Datos (GENERALES)'!C76=0,\" \",'Datos (GENERALES)'!C76)","v":" "},{"$f":"IF('Datos (GENERALES)'!D76=0,\" \",'Datos (GENERALES)'!D76)","v":" "},{"$f":"IF('Datos (GENERALES)'!E76=0,\" \",'Datos (GENERALES)'!E76)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F76=0,\" \",'Datos (GENERALES)'!F76)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G76=0,\" \",'Datos (GENERALES)'!G76)","v":" "}]
[null,"A10",{"$f":"IF('Datos (GENERALES)'!B77=0,\" \",'Datos (GENERALES)'!B77)","v":" "},{"$f":"IF('Datos (GENERALES)'!C77=0,\" \",'Datos (GENERALES)'!C77)","v":" "},{"$f":"IF('Datos (GENERALES)'!D77=0,\" \",'Datos (GENERALES)'!D77)","v":" "},{"$f":"IF('Datos (GENERALES)'!E77=0,\" \",'Datos (GENERALES)'!E77)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F77=0,\" \",'Datos (GENERALES)'!F77)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G77=0,\" \",'Datos (GENERALES)'!G77)","v":" "}]
[]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
[null,"Descripción de superficies planas objeto de la inspección."]
[]
[null,"Item","Descripción","Rango de Temperaturas","Material de aislamiento","Espesor/es de aislamiento",null,"Material de recubrimiento",null,null,"Espesor de recubrimiento"]
[null,"B1",{"$f":"IF('Datos (GENERALES)'!B85=0,\" \",'Datos (GENERALES)'!B85)","v":" "},{"$f":"IF('Datos (GENERALES)'!C85=0,\" \",'Datos (GENERALES)'!C85)","v":" "},{"$f":"IF('Datos (GENERALES)'!D85=0,\" \",'Datos (GENERALES)'!D85)","v":" "},{"$f":"IF('Datos (GENERALES)'!E85=0,\" \",'Datos (GENERALES)'!E85)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F85=0,\" \",'Datos (GENERALES)'!F85)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G85=0,\" \",'Datos (GENERALES)'!G85)","v":" "}]
[null,"B2",{"$f":"IF('Datos (GENERALES)'!B86=0,\" \",'Datos (GENERALES)'!B86)","v":" "},{"$f":"IF('Datos (GENERALES)'!C86=0,\" \",'Datos (GENERALES)'!C86)","v":" "},{"$f":"IF('Datos (GENERALES)'!D86=0,\" \",'Datos (GENERALES)'!D86)","v":" "},{"$f":"IF('Datos (GENERALES)'!E86=0,\" \",'Datos (GENERALES)'!E86)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F86=0,\" \",'Datos (GENERALES)'!F86)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G86=0,\" \",'Datos (GENERALES)'!G86)","v":" "}]
[null,"B3",{"$f":"IF('Datos (GENERALES)'!B87=0,\" \",'Datos (GENERALES)'!B87)","v":" "},{"$f":"IF('Datos (GENERALES)'!C87=0,\" \",'Datos (GENERALES)'!C87)","v":" "},{"$f":"IF('Datos (GENERALES)'!D87=0,\" \",'Datos (GENERALES)'!D87)","v":" "},{"$f":"IF('Datos (GENERALES)'!E87=0,\" \",'Datos (GENERALES)'!E87)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F87=0,\" \",'Datos (GENERALES)'!F87)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G87=0,\" \",'Datos (GENERALES)'!G87)","v":" "}]
[null,"B4",{"$f":"IF('Datos (GENERALES)'!B88=0,\" \",'Datos (GENERALES)'!B88)","v":" "},{"$f":"IF('Datos (GENERALES)'!C88=0,\" \",'Datos (GENERALES)'!C88)","v":" "},{"$f":"IF('Datos (GENERALES)'!D88=0,\" \",'Datos (GENERALES)'!D88)","v":" "},{"$f":"IF('Datos (GENERALES)'!E88=0,\" \",'Datos (GENERALES)'!E88)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F88=0,\" \",'Datos (GENERALES)'!F88)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G88=0,\" \",'Datos (GENERALES)'!G88)","v":" "}]
[null,"B5",{"$f":"IF('Datos (GENERALES)'!B89=0,\" \",'Datos (GENERALES)'!B89)","v":" "},{"$f":"IF('Datos (GENERALES)'!C89=0,\" \",'Datos (GENERALES)'!C89)","v":" "},{"$f":"IF('Datos (GENERALES)'!D89=0,\" \",'Datos (GENERALES)'!D89)","v":" "},{"$f":"IF('Datos (GENERALES)'!E89=0,\" \",'Datos (GENERALES)'!E89)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F89=0,\" \",'Datos (GENERALES)'!F89)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G89=0,\" \",'Datos (GENERALES)'!G89)","v":" "}]
[null,"B6",{"$f":"IF('Datos (GENERALES)'!B90=0,\" \",'Datos (GENERALES)'!B90)","v":" "},{"$f":"IF('Datos (GENERALES)'!C90=0,\" \",'Datos (GENERALES)'!C90)","v":" "},{"$f":"IF('Datos (GENERALES)'!D90=0,\" \",'Datos (GENERALES)'!D90)","v":" "},{"$f":"IF('Datos (GENERALES)'!E90=0,\" \",'Datos (GENERALES)'!E90)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F90=0,\" \",'Datos (GENERALES)'!F90)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G90=0,\" \",'Datos (GENERALES)'!G90)","v":" "}]
[null,"B7",{"$f":"IF('Datos (GENERALES)'!B91=0,\" \",'Datos (GENERALES)'!B91)","v":" "},{"$f":"IF('Datos (GENERALES)'!C91=0,\" \",'Datos (GENERALES)'!C91)","v":" "},{"$f":"IF('Datos (GENERALES)'!D91=0,\" \",'Datos (GENERALES)'!D91)","v":" "},{"$f":"IF('Datos (GENERALES)'!E91=0,\" \",'Datos (GENERALES)'!E91)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F91=0,\" \",'Datos (GENERALES)'!F91)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G91=0,\" \",'Datos (GENERALES)'!G91)","v":" "}]
[null,"B8",{"$f":"IF('Datos (GENERALES)'!B92=0,\" \",'Datos (GENERALES)'!B92)","v":" "},{"$f":"IF('Datos (GENERALES)'!C92=0,\" \",'Datos (GENERALES)'!C92)","v":" "},{"$f":"IF('Datos (GENERALES)'!D92=0,\" \",'Datos (GENERALES)'!D92)","v":" "},{"$f":"IF('Datos (GENERALES)'!E92=0,\" \",'Datos (GENERALES)'!E92)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F92=0,\" \",'Datos (GENERALES)'!F92)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G92=0,\" \",'Datos (GENERALES)'!G92)","v":" "}]
[null,"B9",{"$f":"IF('Datos (GENERALES)'!B93=0,\" \",'Datos (GENERALES)'!B93)","v":" "},{"$f":"IF('Datos (GENERALES)'!C93=0,\" \",'Datos (GENERALES)'!C93)","v":" "},{"$f":"IF('Datos (GENERALES)'!D93=0,\" \",'Datos (GENERALES)'!D93)","v":" "},{"$f":"IF('Datos (GENERALES)'!E93=0,\" \",'Datos (GENERALES)'!E93)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F93=0,\" \",'Datos (GENERALES)'!F93)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G93=0,\" \",'Datos (GENERALES)'!G93)","v":" "}]
[null,"B10",{"$f":"IF('Datos (GENERALES)'!B94=0,\" \",'Datos (GENERALES)'!B94)","v":" "},{"$f":"IF('Datos (GENERALES)'!C94=0,\" \",'Datos (GENERALES)'!C94)","v":" "},{"$f":"IF('Datos (GENERALES)'!D94=0,\" \",'Datos (GENERALES)'!D94)","v":" "},{"$f":"IF('Datos (GENERALES)'!E94=0,\" \",'Datos (GENERALES)'!E94)","v":" "},null,{"$f":"IF('Datos (GENERALES)'!F94=0,\" \",'Datos (GENERALES)'!F94)","v":" "},null,null,{"$f":"IF('Datos (GENERALES)'!G94=0,\" \",'Datos (GENERALES)'!G94)","v":" "}]
[]
[]
["C) Condiciones Ambientales de la instalación (sólo para el cálculo de pérdidas)"]
[]
[null,null,"Instalaciones exteriores"]
[]
[null,null,"Temperatura ambiental media del lugar (Promedio anual TA(ºC) de Guia Técnica Condiciones Clímaticas IDAE):"]
[null,null,null,null,null,null,null,{"$f":"IF('Datos (GENERALES)'!B101=0,\" \",'Datos (GENERALES)'!B101)","v":" "},null,null,"ºC"]
[]
[null,null,"Instalaciones interiores"]
[]
[null,null,"Temperatura ambiental media del interior/temperatura medida el día de la inspección :",null,null,null,null,{"$f":"IF('Datos (GENERALES)'!B106=0,\" \",'Datos (GENERALES)'!B106)","v":" "},null,null,"ºC"]
[]
[]
[null,"Ante cualquier duda relativa al uso de esta herramienta, puede contactar con:",null,null,null,null,null,"consultas@andimai.es"]

{"sheet":"Datos (SUP AISLADA) (IMP)","index":7,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,0,0,13],[2,0,2,13],[14,0,14,13],[26,0,26,13]]}
["ANEXO 1: SUPERFICIE AISLADA"]
[]
["A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
[null,"Tª superficial de la instalación\n(ºC)","Total m² tubería","Total m² aislados para Conservación de Calor\n(CC)","Total m² aislados para Protección Personal\n(PP)",null,"% de superficie aislada para Conservación de Calor\n(CC)","% de superficie aislada para protección personal (PP)","% de superficie aislada (CC+PP)","% de superficie sin aislamiento",null,"Temperatura media de cada tramo (ºC)","TI\nTemperatura Incremental media para cálculo de CISA\nT(ºC)-60ºC","CISA60 (m²xTI)/1000"]
[null,"60<X≤100",{"$f":"IF('Datos (SUP AISLADA)'!B6=0,\" \",'Datos (SUP AISLADA)'!B6)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C6=0,\" \",'Datos (SUP AISLADA)'!C6)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D6=0,\" \",'Datos (SUP AISLADA)'!D6)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F6=0,\" \",'Datos (SUP AISLADA)'!F6)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G6=0,\" \",'Datos (SUP AISLADA)'!G6)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H6=0,\" \",'Datos (SUP AISLADA)'!H6)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I6=0,\" \",'Datos (SUP AISLADA)'!I6)","v":" "},null,80,{"$f":"L6-60","v":20},{"$f":"IF('Datos (SUP AISLADA)'!M6=0,\" \",'Datos (SUP AISLADA)'!M6)","v":" "}]
[null,"100<X≤200",{"$f":"IF('Datos (SUP AISLADA)'!B7=0,\" \",'Datos (SUP AISLADA)'!B7)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C7=0,\" \",'Datos (SUP AISLADA)'!C7)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D7=0,\" \",'Datos (SUP AISLADA)'!D7)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F7=0,\" \",'Datos (SUP AISLADA)'!F7)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G7=0,\" \",'Datos (SUP AISLADA)'!G7)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H7=0,\" \",'Datos (SUP AISLADA)'!H7)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I7=0,\" \",'Datos (SUP AISLADA)'!I7)","v":" "},null,150,{"$f":"L7-60","v":90},{"$f":"IF('Datos (SUP AISLADA)'!M7=0,\" \",'Datos (SUP AISLADA)'!M7)","v":" "}]
[null,"200<X≤300",{"$f":"IF('Datos (SUP AISLADA)'!B8=0,\" \",'Datos (SUP AISLADA)'!B8)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C8=0,\" \",'Datos (SUP AISLADA)'!C8)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D8=0,\" \",'Datos (SUP AISLADA)'!D8)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F8=0,\" \",'Datos (SUP AISLADA)'!F8)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G8=0,\" \",'Datos (SUP AISLADA)'!G8)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H8=0,\" \",'Datos (SUP AISLADA)'!H8)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I8=0,\" \",'Datos (SUP AISLADA)'!I8)","v":" "},null,250,190,{"$f":"IF('Datos (SUP AISLADA)'!M8=0,\" \",'Datos (SUP AISLADA)'!M8)","v":" "}]
[null,"300<X≤400",{"$f":"IF('Datos (SUP AISLADA)'!B9=0,\" \",'Datos (SUP AISLADA)'!B9)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C9=0,\" \",'Datos (SUP AISLADA)'!C9)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D9=0,\" \",'Datos (SUP AISLADA)'!D9)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F9=0,\" \",'Datos (SUP AISLADA)'!F9)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G9=0,\" \",'Datos (SUP AISLADA)'!G9)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H9=0,\" \",'Datos (SUP AISLADA)'!H9)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I9=0,\" \",'Datos (SUP AISLADA)'!I9)","v":" "},null,350,290,{"$f":"IF('Datos (SUP AISLADA)'!M9=0,\" \",'Datos (SUP AISLADA)'!M9)","v":" "}]
[null,"400<X≤500",{"$f":"IF('Datos (SUP AISLADA)'!B10=0,\" \",'Datos (SUP AISLADA)'!B10)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C10=0,\" \",'Datos (SUP AISLADA)'!C10)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D10=0,\" \",'Datos (SUP AISLADA)'!D10)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F10=0,\" \",'Datos (SUP AISLADA)'!F10)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G10=0,\" \",'Datos (SUP AISLADA)'!G10)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H10=0,\" \",'Datos (SUP AISLADA)'!H10)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I10=0,\" \",'Datos (SUP AISLADA)'!I10)","v":" "},null,450,390,{"$f":"IF('Datos (SUP AISLADA)'!M10=0,\" \",'Datos (SUP AISLADA)'!M10)","v":" "}]
[null,"500<X≤600",{"$f":"IF('Datos (SUP AISLADA)'!B11=0,\" \",'Datos (SUP AISLADA)'!B11)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C11=0,\" \",'Datos (SUP AISLADA)'!C11)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D11=0,\" \",'Datos (SUP AISLADA)'!D11)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F11=0,\" \",'Datos (SUP AISLADA)'!F11)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G11=0,\" \",'Datos (SUP AISLADA)'!G11)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H11=0,\" \",'Datos (SUP AISLADA)'!H11)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I11=0,\" \",'Datos (SUP AISLADA)'!I11)","v":" "},null,550,490,{"$f":"IF('Datos (SUP AISLADA)'!M11=0,\" \",'Datos (SUP AISLADA)'!M11)","v":" "}]
[null,"600<X≤650",{"$f":"IF('Datos (SUP AISLADA)'!B12=0,\" \",'Datos (SUP AISLADA)'!B12)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C12=0,\" \",'Datos (SUP AISLADA)'!C12)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D12=0,\" \",'Datos (SUP AISLADA)'!D12)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F12=0,\" \",'Datos (SUP AISLADA)'!F12)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G12=0,\" \",'Datos (SUP AISLADA)'!G12)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H12=0,\" \",'Datos (SUP AISLADA)'!H12)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I12=0,\" \",'Datos (SUP AISLADA)'!I12)","v":" "},null,625,565,{"$f":"IF('Datos (SUP AISLADA)'!M12=0,\" \",'Datos (SUP AISLADA)'!M12)","v":" "}]
[null,"TOTAL",{"$f":"SUM(C6:C12)","v":0},{"$f":"SUM(D6:D12)","v":0},{"$f":"SUM(E6:E12)","v":0},null,{"$f":"IF(C13<>0,D13/C13,0)","v":0},{"$f":"IF(C13<>0,E13/C13,0)","v":0},{"$f":"G13+H13","v":0},{"$f":"IF(C13<>0,1-G13-H13,0)","v":0},null,null,"TOTAL",{"$f":"SUM(N6:N12)","v":0}]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
[null,"Tª superficial de la instalación\n(ºC)","Total m² equipo","Total m² aislados para Conservación de Calor\n(CC)","Total m² aislados para Protección Personal\n(PP)",null,"% de superficie aislada para Conservación de Calor\n(CC)","% de superficie aislada para protección personal (PP)","% de superficie aislada (CC+PP)","% de superficie sin aislamiento",null,"Temperatura media de cada tramo (ºC)","TI\nTemperatura Incremental media para cálculo de CISA\nT(ºC)-60ºC","CISA60 (m²xTI)/1000"]
[null,"60<X≤100",{"$f":"IF('Datos (SUP AISLADA)'!B18=0,\" \",'Datos (SUP AISLADA)'!B18)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C18=0,\" \",'Datos (SUP AISLADA)'!C18)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D18=0,\" \",'Datos (SUP AISLADA)'!D18)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F18=0,\" \",'Datos (SUP AISLADA)'!F18)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G18=0,\" \",'Datos (SUP AISLADA)'!G18)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H18=0,\" \",'Datos (SUP AISLADA)'!H18)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I18=0,\" \",'Datos (SUP AISLADA)'!I18)","v":" "},null,80,{"$f":"L18-60","v":20},{"$f":"IF('Datos (SUP AISLADA)'!M18=0,\" \",'Datos (SUP AISLADA)'!M18)","v":" "}]
[null,"100<X≤200",{"$f":"IF('Datos (SUP AISLADA)'!B19=0,\" \",'Datos (SUP AISLADA)'!B19)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C19=0,\" \",'Datos (SUP AISLADA)'!C19)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D19=0,\" \",'Datos (SUP AISLADA)'!D19)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F19=0,\" \",'Datos (SUP AISLADA)'!F19)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G19=0,\" \",'Datos (SUP AISLADA)'!G19)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H19=0,\" \",'Datos (SUP AISLADA)'!H19)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I19=0,\" \",'Datos (SUP AISLADA)'!I19)","v":" "},null,150,{"$f":"L19-60","v":90},{"$f":"IF('Datos (SUP AISLADA)'!M19=0,\" \",'Datos (SUP AISLADA)'!M19)","v":" "}]
[null,"200<X≤300",{"$f":"IF('Datos (SUP AISLADA)'!B20=0,\" \",'Datos (SUP AISLADA)'!B20)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C20=0,\" \",'Datos (SUP AISLADA)'!C20)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D20=0,\" \",'Datos (SUP AISLADA)'!D20)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F20=0,\" \",'Datos (SUP AISLADA)'!F20)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G20=0,\" \",'Datos (SUP AISLADA)'!G20)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H20=0,\" \",'Datos (SUP AISLADA)'!H20)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I20=0,\" \",'Datos (SUP AISLADA)'!I20)","v":" "},null,250,190,{"$f":"IF('Datos (SUP AISLADA)'!M20=0,\" \",'Datos (SUP AISLADA)'!M20)","v":" "}]
[null,"300<X≤400",{"$f":"IF('Datos (SUP AISLADA)'!B21=0,\" \",'Datos (SUP AISLADA)'!B21)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C21=0,\" \",'Datos (SUP AISLADA)'!C21)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D21=0,\" \",'Datos (SUP AISLADA)'!D21)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F21=0,\" \",'Datos (SUP AISLADA)'!F21)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G21=0,\" \",'Datos (SUP AISLADA)'!G21)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H21=0,\" \",'Datos (SUP AISLADA)'!H21)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I21=0,\" \",'Datos (SUP AISLADA)'!I21)","v":" "},null,350,290,{"$f":"IF('Datos (SUP AISLADA)'!M21=0,\" \",'Datos (SUP AISLADA)'!M21)","v":" "}]
[null,"400<X≤500",{"$f":"IF('Datos (SUP AISLADA)'!B22=0,\" \",'Datos (SUP AISLADA)'!B22)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C22=0,\" \",'Datos (SUP AISLADA)'!C22)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D22=0,\" \",'Datos (SUP AISLADA)'!D22)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F22=0,\" \",'Datos (SUP AISLADA)'!F22)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G22=0,\" \",'Datos (SUP AISLADA)'!G22)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H22=0,\" \",'Datos (SUP AISLADA)'!H22)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I22=0,\" \",'Datos (SUP AISLADA)'!I22)","v":" "},null,450,390,{"$f":"IF('Datos (SUP AISLADA)'!M22=0,\" \",'Datos (SUP AISLADA)'!M22)","v":" "}]
[null,"500<X≤600",{"$f":"IF('Datos (SUP AISLADA)'!B23=0,\" \",'Datos (SUP AISLADA)'!B23)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C23=0,\" \",'Datos (SUP AISLADA)'!C23)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D23=0,\" \",'Datos (SUP AISLADA)'!D23)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F23=0,\" \",'Datos (SUP AISLADA)'!F23)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G23=0,\" \",'Datos (SUP AISLADA)'!G23)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H23=0,\" \",'Datos (SUP AISLADA)'!H23)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I23=0,\" \",'Datos (SUP AISLADA)'!I23)","v":" "},null,550,490,{"$f":"IF('Datos (SUP AISLADA)'!M23=0,\" \",'Datos (SUP AISLADA)'!M23)","v":" "}]
[null,"600<X≤650",{"$f":"IF('Datos (SUP AISLADA)'!B24=0,\" \",'Datos (SUP AISLADA)'!B24)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!C24=0,\" \",'Datos (SUP AISLADA)'!C24)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!D24=0,\" \",'Datos (SUP AISLADA)'!D24)","v":" "},null,{"$f":"IF('Datos (SUP AISLADA)'!F24=0,\" \",'Datos (SUP AISLADA)'!F24)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!G24=0,\" \",'Datos (SUP AISLADA)'!G24)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!H24=0,\" \",'Datos (SUP AISLADA)'!H24)","v":" "},{"$f":"IF('Datos (SUP AISLADA)'!I24=0,\" \",'Datos (SUP AISLADA)'!I24)","v":" "},null,625,565,{"$f":"IF('Datos (SUP AISLADA)'!M24=0,\" \",'Datos (SUP AISLADA)'!M24)","v":" "}]
[null,"TOTAL",{"$f":"SUM(C18:C24)","v":0},{"$f":"SUM(D18:D24)","v":0},{"$f":"SUM(E18:E24)","v":0},null,{"$f":"IF(C25<>0,D25/C25,0)","v":0},{"$f":"IF(C25<>0,E25/C25,0)","v":0},{"$f":"G25+H25","v":0},{"$f":"IF(C25<>0,1-G25-H25,0)","v":0},null,null,"TOTAL",{"$f":"SUM(N18:N24)","v":0}]
[]
["C) Total de superfices calientes en la instalación (A)+(B)"]
[]
[null,"Tª superficial de la instalación\n(ºC)","Total m² ","Total m² aislados para Conservación de Calor\n(CC)","Total m² aislados para Protección Personal\n(PP)",null,"% de superficie aislada para Conservación de Calor\n(CC)","% de superficie aislada para protección personal (PP)","% de superficie aislada (CC+PP)","% de superficie sin aislamiento",null,null,"CISA60 (m²xTI)/1000","% REPARTO CISA60 "]
[null,"TOTAL SUPERFICIES CALIENTES TUBERÍA",{"$f":"C13","v":0},{"$f":"D13","v":0},{"$f":"E13","v":0},null,{"$f":"G13","v":0},{"$f":"H13","v":0},{"$f":"I13","v":0},{"$f":"J13","v":0},null,null,{"$f":"N13","v":0},{"$f":"IFERROR((ROUND(M30/M32,2)),0)","v":0}]
[null,"TOTAL SUPERFICIES CALIENTES EQUIPOS",{"$f":"C25","v":0},{"$f":"D25","v":0},{"$f":"E25","v":0},null,{"$f":"G25","v":0},{"$f":"H25","v":0},{"$f":"I25","v":0},{"$f":"J25","v":0},null,null,{"$f":"N25","v":0},{"$f":"IFERROR((ROUND(M31/M32,2)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"SUM(M30:M31)","v":0},{"$f":"SUM(N30:N31)","v":0}]

{"sheet":"Datos (ESP AISLAMIENTO) (IMP)","index":8,"n_rows":169,"n_cols":5,"rows_kept":169,"cut":false,"hidden":true,"merged":[[51,1,51,3],[0,0,0,7],[2,0,2,7],[4,0,4,7],[6,1,6,3],[49,0,49,7],[163,0,163,7],[74,0,74,7],[89,0,89,7],[91,0,91,7],[93,1,93,3],[137,0,137,7],[139,1,139,3]]}
["ANEXO 2: ESPESORES DE AISLAMIENTO"]
[]
["A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
["A.1) Superficies de tuberías (hasta 1000 mm de diámetro) aisladas para Conservación de Calor"]
[]
[null,"Valor promedio de Perdidas Instalación actual en W/m²",null,null,{"$f":"IF('Datos (ESP AISLAMIENTO)'!E7=0,0,'Datos (ESP AISLAMIENTO)'!E7)","v":0}]
[]
[null,null,"TABLA 2.A.1"]
[null,null,"Rango de Pérdidas Cálculadas Q (W/m²)","Ponderación por rangos (%)","Ponderación de la instalación Estudiada (%)"]
[null,{"$f":"E11","v":" "},"Q≤90",1,{"$f":"IF((AND($E$7<=90,$E$7<>0)),\"X\",\" \")","v":" "}]
[null,{"$f":"E12","v":" "},"90<Q≤100",{"$f":"D11-0.05","v":0.95},{"$f":"IF((AND($E$7>90,$E$7<=100)),\"X\",\" \")","v":" "}]
[null," ","100<Q≤120",{"$f":"D12-0.05","v":0.89999999999999991},{"$f":"IF((AND($E$7>100,$E$7<=120)),\"X\",\" \")","v":" "}]
[null," ","120<Q≤140",0.84999999999999987,{"$f":"IF((AND($E$7>120,$E$7<=140)),\"X\",\" \")","v":" "}]
[null," ","140<Q≤160",0.79999999999999982,{"$f":"IF((AND($E$7>140,$E$7<=160)),\"X\",\" \")","v":" "}]
[null," ","160<Q≤180",0.74999999999999978,{"$f":"IF((AND($E$7>160,$E$7<=180)),\"X\",\" \")","v":" "}]
[null," ","180<Q≤200",0.69999999999999973,{"$f":"IF((AND($E$7>180,$E$7<=200)),\"X\",\" \")","v":" "}]
[null," ","200<Q≤220",0.64999999999999969,{"$f":"IF((AND($E$7>200,$E$7<=220)),\"X\",\" \")","v":" "}]
[null," ","220<Q≤240",0.59999999999999964,{"$f":"IF((AND($E$7>220,$E$7<=240)),\"X\",\" \")","v":" "}]
[null," ","240<Q≤260",0.5499999999999996,{"$f":"IF((AND($E$7>240,$E$7<=260)),\"X\",\" \")","v":" "}]
[null," ","260<Q≤280",0.49999999999999961,{"$f":"IF((AND($E$7>260,$E$7<=280)),\"X\",\" \")","v":" "}]
[null," ","280<Q≤300",0.44999999999999962,{"$f":"IF((AND($E$7>280,$E$7<=300)),\"X\",\" \")","v":" "}]
[null," ","300<Q≤320",0.39999999999999963,{"$f":"IF((AND($E$7>300,$E$7<=320)),\"X\",\" \")","v":" "}]
[null," ","320<Q≤340",0.34999999999999964,{"$f":"IF((AND($E$7>320,$E$7<=340)),\"X\",\" \")","v":" "}]
[null," ","340<Q≤360",0.29999999999999966,{"$f":"IF((AND($E$7>340,$E$7<=360)),\"X\",\" \")","v":" "}]
[null," ","360<Q≤380",0.24999999999999967,{"$f":"IF((AND($E$7>360,$E$7<=380)),\"X\",\" \")","v":" "}]
[null," ","380<Q≤400",0.19999999999999968,{"$f":"IF((AND($E$7>380,$E$7<=400)),\"X\",\" \")","v":" "}]
[null," ","400<Q",0.14999999999999969,{"$f":"IF($E$7>400,\"X\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A.2) Superficies de tuberías (hasta 1000 mm de diámetro) aisladas para Protección Personal"]
[]
[null,"Valor promedio de Perdidas Instalación actual en W/m²",null,null,{"$f":"IF('Datos (ESP AISLAMIENTO)'!E32=0,0,'Datos (ESP AISLAMIENTO)'!E32)","v":0}]
[]
[null,null,"TABLA 2.A.2"]
[null,null,"Rango de Pérdidas Cálculadas Q (W/m²)","Ponderación por rangos (%)","Ponderación de la instalación Estudiada (%)"]
[null,{"$f":"E56","v":" "},"Q≤90",1,{"$f":"IF((AND($E$52<=90,$E$52<>0)),\"X\",\" \")","v":" "}]
[null,{"$f":"E57","v":" "},"90<Q≤100",{"$f":"D56-0.05","v":0.95},{"$f":"IF((AND($E$52>90,$E$52<=100)),\"X\",\" \")","v":" "}]
[null," ","100<Q≤120",{"$f":"D57-0.05","v":0.89999999999999991},{"$f":"IF((AND($E$52>100,$E$52<=120)),\"X\",\" \")","v":" "}]
[null," ","120<Q≤140",0.84999999999999987,{"$f":"IF((AND($E$52>120,$E$52<=140)),\"X\",\" \")","v":" "}]
[null," ","140<Q≤160",0.79999999999999982,{"$f":"IF((AND($E$52>140,$E$52<=160)),\"X\",\" \")","v":" "}]
[null," ","160<Q≤180",0.74999999999999978,{"$f":"IF((AND($E$52>160,$E$52<=180)),\"X\",\" \")","v":" "}]
[null," ","180<Q≤200",0.69999999999999973,{"$f":"IF((AND($E$52>180,$E$52<=200)),\"X\",\" \")","v":" "}]
[null," ","200<Q≤220",0.64999999999999969,{"$f":"IF((AND($E$52>200,$E$52<=220)),\"X\",\" \")","v":" "}]
[null," ","220<Q≤240",0.59999999999999964,{"$f":"IF((AND($E$52>220,$E$52<=240)),\"X\",\" \")","v":" "}]
[null," ","240<Q≤260",0.5499999999999996,{"$f":"IF((AND($E$52>240,$E$52<=260)),\"X\",\" \")","v":" "}]
[null," ","260<Q≤280",0.49999999999999961,{"$f":"IF((AND($E$52>260,$E$52<=280)),\"X\",\" \")","v":" "}]
[null," ","280<Q≤300",0.44999999999999962,{"$f":"IF((AND($E$52>280,$E$52<=300)),\"X\",\" \")","v":" "}]
[null," ","300<Q≤320",0.39999999999999963,{"$f":"IF((AND($E$52>300,$E$52<=320)),\"X\",\" \")","v":" "}]
[null," ","320<Q≤340",0.34999999999999964,{"$f":"IF((AND($E$52>320,$E$52<=340)),\"X\",\" \")","v":" "}]
[null," ","340<Q≤360",0.29999999999999966,{"$f":"IF((AND($E$52>340,$E$52<=360)),\"X\",\" \")","v":" "}]
[null," ","360<Q≤380",0.24999999999999967,{"$f":"IF((AND($E$52>360,$E$52<=380)),\"X\",\" \")","v":" "}]
[null," ","380<Q≤400",0.19999999999999968,{"$f":"IF((AND($E$52>380,$E$52<=400)),\"X\",\" \")","v":" "}]
[null," ","400<Q",0.14999999999999969,{"$f":"IF($E$52>400,\"X\",\" \")","v":" "}]
[]
["A.3) Pérdidas promedio en Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
[null,"Tipo","Peso CC ó PP sobre superfices aisladas (%)","Valoración SUPERFICIES DE TUBERIAS","Ponderación de la superficie estudiada (%)"]
[null,"TOTAL TUBERIAS CALIENTES AISLADAS PARA CONSERVACION DE CALOR",{"$f":"IFERROR(('Datos (SUP AISLADA)'!F30/'Datos (SUP AISLADA)'!H30),0)","v":0},{"$f":"IFERROR((VLOOKUP(\"X\",B11:D28,3,FALSE)),0)","v":0},{"$f":"D78*C78","v":0}]
[null,"TOTAL TUBERIAS CALIENTES AISLADAS PARA PROTECCION PERSONAL",{"$f":"IFERROR(('Datos (SUP AISLADA)'!G30/'Datos (SUP AISLADA)'!H30),0)","v":0},{"$f":"IFERROR((VLOOKUP(\"X\",B56:D73,3,FALSE)),0)","v":0},{"$f":"D79*C79","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E78:E79)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
["B.1) Superficies planas (desde 1000 mm de diámetro) y equipos aisladas para Conservación de Calor"]
[]
[null,"Valor promedio de Perdidas Instalación actual en W/m²",null,null,{"$f":"IF('Datos (ESP AISLAMIENTO)'!E66=0,0,'Datos (ESP AISLAMIENTO)'!E66)","v":0}]
[]
[null,null,"TABLA 2.B.1"]
[]
[null,null,"Rango de Pérdidas Cálculadas Q (W/m²)","Ponderación por rangos (%)","Ponderación de la instalación Estudiada (%)"]
[null,{"$f":"E99","v":" "},"Q≤90",1,{"$f":"IF((AND($E$94<=90,$E$94<>0)),\"X\",\" \")","v":" "}]
[null,{"$f":"E100","v":" "},"90<Q≤100",{"$f":"D99-0.05","v":0.95},{"$f":"IF((AND($E$94>90,$E$94<=100)),\"X\",\" \")","v":" "}]
[null," ","100<Q≤120",{"$f":"D100-0.05","v":0.89999999999999991},{"$f":"IF((AND($E$94>100,$E$94<=120)),\"X\",\" \")","v":" "}]
[null," ","120<Q≤140",0.84999999999999987,{"$f":"IF((AND($E$94>120,$E$94<=140)),\"X\",\" \")","v":" "}]
[null," ","140<Q≤160",0.79999999999999982,{"$f":"IF((AND($E$94>140,$E$94<=160)),\"X\",\" \")","v":" "}]
[null," ","160<Q≤180",0.74999999999999978,{"$f":"IF((AND($E$94>160,$E$94<=180)),\"X\",\" \")","v":" "}]
[null," ","180<Q≤200",0.69999999999999973,{"$f":"IF((AND($E$94>180,$E$94<=200)),\"X\",\" \")","v":" "}]
[null," ","200<Q≤220",0.64999999999999969,{"$f":"IF((AND($E$94>200,$E$94<=220)),\"X\",\" \")","v":" "}]
[null," ","220<Q≤240",0.59999999999999964,{"$f":"IF((AND($E$94>220,$E$94<=240)),\"X\",\" \")","v":" "}]
[null," ","240<Q≤260",0.5499999999999996,{"$f":"IF((AND($E$94>240,$E$94<=260)),\"X\",\" \")","v":" "}]
[null," ","260<Q≤280",0.49999999999999961,{"$f":"IF((AND($E$94>260,$E$94<=280)),\"X\",\" \")","v":" "}]
[null," ","280<Q≤300",0.44999999999999962,{"$f":"IF((AND($E$94>280,$E$94<=300)),\"X\",\" \")","v":" "}]
[null," ","300<Q≤320",0.39999999999999963,{"$f":"IF((AND($E$94>300,$E$94<=320)),\"X\",\" \")","v":" "}]
[null," ","320<Q≤340",0.34999999999999964,{"$f":"IF((AND($E$94>320,$E$94<=340)),\"X\",\" \")","v":" "}]
[null," ","340<Q≤360",0.29999999999999966,{"$f":"IF((AND($E$94>340,$E$94<=360)),\"X\",\" \")","v":" "}]
[null," ","360<Q≤380",0.24999999999999967,{"$f":"IF((AND($E$94>360,$E$94<=380)),\"X\",\" \")","v":" "}]
[null," ","380<Q≤400",0.19999999999999968,{"$f":"IF((AND($E$94>380,$E$94<=400)),\"X\",\" \")","v":" "}]
[null," ","400<Q",0.14999999999999969,{"$f":"IF($E$94>400,\"X\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B.2) Superficies planas (desde 1000 mm de diámetro) y equipos aisladas para Protección Personal"]
[]
[null,"Valor promedio de Perdidas Instalación actual en W/m²",null,null,{"$f":"IF('Datos (ESP AISLAMIENTO)'!E92=0,0,'Datos (ESP AISLAMIENTO)'!E92)","v":0}]
[]
[null,null,"TABLA 2.B.2"]
[]
[null,null,"Rango de Pérdidas Cálculadas Q (W/m²)","Ponderación por rangos (%)","Ponderación de la instalación Estudiada (%)"]
[null,{"$f":"E145","v":" "},"Q≤90",1,{"$f":"IF((AND($E$140<=90,$E$140<>0)),\"X\",\" \")","v":" "}]
[null,{"$f":"E146","v":" "},"90<Q≤100",{"$f":"D145-0.05","v":0.95},{"$f":"IF((AND($E$140>90,$E$140<=100)),\"X\",\" \")","v":" "}]
[null," ","100<Q≤120",{"$f":"D146-0.05","v":0.89999999999999991},{"$f":"IF((AND($E$140>100,$E$140<=120)),\"X\",\" \")","v":" "}]
[null," ","120<Q≤140",0.84999999999999987,{"$f":"IF((AND($E$140>120,$E$140<=140)),\"X\",\" \")","v":" "}]
[null," ","140<Q≤160",0.79999999999999982,{"$f":"IF((AND($E$140>140,$E$140<=160)),\"X\",\" \")","v":" "}]
[null," ","160<Q≤180",0.74999999999999978,{"$f":"IF((AND($E$140>160,$E$140<=180)),\"X\",\" \")","v":" "}]
[null," ","180<Q≤200",0.69999999999999973,{"$f":"IF((AND($E$140>180,$E$140<=200)),\"X\",\" \")","v":" "}]
[null," ","200<Q≤220",0.64999999999999969,{"$f":"IF((AND($E$140>200,$E$140<=220)),\"X\",\" \")","v":" "}]
[null," ","220<Q≤240",0.59999999999999964,{"$f":"IF((AND($E$140>220,$E$140<=240)),\"X\",\" \")","v":" "}]
[null," ","240<Q≤260",0.5499999999999996,{"$f":"IF((AND($E$140>240,$E$140<=260)),\"X\",\" \")","v":" "}]
[null," ","260<Q≤280",0.49999999999999961,{"$f":"IF((AND($E$140>260,$E$140<=280)),\"X\",\" \")","v":" "}]
[null," ","280<Q≤300",0.44999999999999962,{"$f":"IF((AND($E$140>280,$E$140<=300)),\"X\",\" \")","v":" "}]
[null," ","300<Q≤320",0.39999999999999963,{"$f":"IF((AND($E$140>300,$E$140<=320)),\"X\",\" \")","v":" "}]
[null," ","320<Q≤340",0.34999999999999964,{"$f":"IF((AND($E$140>320,$E$140<=340)),\"X\",\" \")","v":" "}]
[null," ","340<Q≤360",0.29999999999999966,{"$f":"IF((AND($E$140>340,$E$140<=360)),\"X\",\" \")","v":" "}]
[null," ","360<Q≤380",0.24999999999999967,{"$f":"IF((AND($E$140>360,$E$140<=380)),\"X\",\" \")","v":" "}]
[null," ","380<Q≤400",0.19999999999999968,{"$f":"IF((AND($E$140>380,$E$140<=400)),\"X\",\" \")","v":" "}]
[null," ","400<Q",0.14999999999999969,{"$f":"IF($E$140>400,\"X\",\" \")","v":" "}]
[]
["B.3) Pérdidas promedio en Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
[null,"Tipo","Peso CC ó PP sobre superfices aisladas (%)","Valoración SUPERFICIES DE TUBERIAS","Ponderación de la superficie estudiada (%)"]
[null,"TOTAL SUPERFICIES PLANAS CALIENTES AISLADAS PARA CONSERVACION DE CALOR",{"$f":"IFERROR(('Datos (SUP AISLADA)'!F31/'Datos (SUP AISLADA)'!H31),0)","v":0},{"$f":"IFERROR((VLOOKUP(\"X\",B99:D116,3,FALSE)),0)","v":0},{"$f":"D167*C167","v":0}]
[null,"TOTAL SUPERFICIES PLANAS CALIENTES AISLADAS PARA PROTECCION PERSONAL",{"$f":"IFERROR(('Datos (SUP AISLADA)'!G31/'Datos (SUP AISLADA)'!H31),0)","v":0},{"$f":"IFERROR((VLOOKUP(\"X\",B145:D162,3,FALSE)),0)","v":0},{"$f":"D168*C168","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E167:E168)","v":0}]

{"sheet":"Datos (PPI AISLAMIENTO) (IMP)","index":9,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":true,"merged":[[38,1,42,1],[44,2,44,11],[24,0,24,14],[26,12,27,12],[26,13,27,13],[26,14,27,14],[28,1,29,1],[30,1,33,1],[34,1,37,1],[16,1,20,1],[22,2,22,11],[26,1,27,1],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,26,10],[26,11,27,11],[12,1,15,1],[0,0,0,14],[2,0,2,14],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,4,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,14,5,14],[6,1,7,1],[8,1,11,1]]}
["ANEXO 3: Registro de Puntos de Inspección en Aislamiento "]
[]
["A) Registro de Puntos de Inspección de tuberías aisladas"]
[]
[null,null,"PUNTOS DE INSPECCIÓN","CRITERIOS DE ACEPTACIÓN","PUNTO DE LA GUIA","MUESTRA INSTALACION","TIPO  DE CONTROL",null,null,null,null,"VALORACIÓN INSPECTOR","OBSERVACIONES INSPECTOR","Peso Parcial (%) de Punto de Inspección","Ponderación puntos (%)"]
[null,null,null,null,null,null,"V","D","P","C","T"]
[null,"Soporte del aislamiento","Colocación de los distanciadores, si procede (altura y separación)","Superficies horizontales: 950 mm ± 30 mm; Superficies Verticales: mínimo cada 3 metros. Según Guía","3.3.1 \n4.3.1",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.03,{"$f":"ROUND($L7*$N7,3)","v":0}]
[null,null,"Rotura de puente térmico","Según Guía","3.3.1 \n4.3.1\n",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.03,{"$f":"ROUND($L8*$N8,3)","v":0}]
[null,"Material aislante","Tipo y espesor de aislamiento instalado","Corresponde con las especificaciones/ guía","3.1\n4.3.2",0.2,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},{"$f":"0.5*(0.42-$N$10)","v":0.21},{"$f":"ROUND($L9*$N9,3)","v":0}]
[null,null,"Estado del aislamiento instalado ","Realización de:\n-Inspecciones visuales\n-Inspecciones Dimensionales\n-Inpecciones  mediante informacion de planos\n-Inspecciones mediante informacion de certicados\n-Inspecciones mediante termografías","General",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},{"$f":"+U11","v":0},{"$f":"ROUND($L10*$N10,3)","v":0}]
[null,null,"Adecuada sujección","Según especificaciones","3.1\n4.3.2",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},{"$f":"0.25*(0.42-$N$10)","v":0.105},{"$f":"ROUND($L11*$N11,3)","v":0}]
[null,null,"Juntas a tope y contrapeadas (multicapa)","Según especificaciones","3.1\n4.3.2",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},{"$f":"0.25*(0.42-$N$10)","v":0.105},0]
[null,"Protección metálica","Tipo y espesor del recubrimiento instalado","Corresponde con las especificaciones/ guía","3.2.1\n4.3.3",0.2,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.06,0]
[null,null,"Ejecución de bordones y solapes","Según Guía","3.2.1\n4.3.3",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.05,0]
[null,null,"Fijación por tornillos / remaches POP","Aprox. cada 250 mm. Según Guía","4.3.3",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.02,0]
[null,null,"Superficie aislada (bridas, válvulas,..)","Según especificaciones","3,1\n4.3.2",1,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},7.0000000000000007E-2,0]
[null,"Montaje","Correcta instalación a favor de agua","Según Guía","4.3.3",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.06,0]
[null,null,"Correcto sellado (donde haya riesgo de entrada de agua de lluvía)","Según Guía","4.3.3",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.06,0]
[null,null,"Uso de tapas en finales de aislamiento (cajas desmontables, etc)","Según Guía","4.11",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.04,0]
[null,null,"Correcto tratamiento salidas  de traceado.","Según Guía","4.11",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.02,0]
[null,null,"Tratamiento de puentes térmicos (tapas, instrumentos, etc)","Según Guía","4.11",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.04,0]
[null,"Acabado final","No presenta golpes, ni aberturas, ni daños.","Inspección general","Guía",0.05,{"$f":"IF(Tabla28[[#This Row],[V]]<>\"X\",\" \",Tabla28[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[D]]<>\"X\",\" \",Tabla28[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[P]]<>\"X\",\" \",Tabla28[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[C]]<>\"X\",\" \",Tabla28[[#This Row],[Columna1]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[T]]<>\"X\",\" \",Tabla28[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla28[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla28[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla28[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.1,0]
[null,null,"• V= Visual • D= Dimensional • P= Información de Planos\n• C= Información de Certificados • T= Termografía",null,null,null,null,null,null,null,null,null,null,"TOTAL PPI",{"$f":"SUM($O7:$O22)","v":0}]
[]
["B) Registro de Puntos de Inspección en Aislamiento de equipos aislados"]
[]
[null,null,"PUNTOS DE INSPECCIÓN","CRITERIOS DE ACEPTACIÓN","PUNTO DE LA GUIA","MUESTRA INSTALACION","TIPO  DE CONTROL",null,null,null,null,"VALORACIÓN INSPECTOR","OBSERVACIONES INSPECTOR","Peso Parcial (%) de Punto de Inspección","Ponderación puntos (%)"]
[null,null,null,null,null,null,"V","D","P","C","T"]
[null,"Soporte del aislamiento","Colocación de los distanciadores, si procede (altura y separación)","Superficies horizontales: 950 mm ± 30 mm; Superficies Verticales: mínimo cada 3 metros. Según Guía","3.3.1 \n4.3.1\n ",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.03,{"$f":"ROUND($L29*$N29,3)","v":0}]
[null,null,"Rotura de puente térmico","Según Guía","3.3.1 \n4.3.1\n",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.03,{"$f":"ROUND($L30*$N30,3)","v":0}]
[null,"Material aislante","Tipo y espesor de aislamiento instalado","Corresponde con las especificaciones/ guía","3,1\n4.3.2",0.2,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},{"$f":"0.5*(0.42-$N$32)","v":0.21},0]
[null,null,"Estado del aislamiento instalado ","Realización de:\n-Inspecciones visuales\n-Inspecciones Dimensionales\n-Inpecciones  mediante informacion de planos\n-Inspecciones mediante informacion de certicados\n-Inspecciones mediante termografías","3,1\n4.3.2",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},{"$f":"+U33","v":0},0]
[null,null,"Adecuada sujección","Según especificaciones","3,1\n4.3.2",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},{"$f":"0.25*(0.42-$N$32)","v":0.105},0]
[null,null,"Juntas a tope y contrapeadas (multicapa)","Según especificaciones","3,1\n4.3.2",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},{"$f":"0.25*(0.42-$N$32)","v":0.105},0]
[null,"Protección metálica","Tipo y espesor del material instalado","Según especificaciones/ guía","3.2.1\n4.3.3",0.2,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.06,0]
[null,null,"Ejecución de bordones y solapes","Según Guía","3.2.1\n4.3.3",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.05,0]
[null,null,"Fijación por tornillos / remaches POP","Aprox. cada 250 mm. Según Guía","4.3.3",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.02,0]
[null,null,"Superficie aislada (bridas, válvulas,..)","Según especificaciones","3.1\n4.3.2",1,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},7.0000000000000007E-2,0]
[null,"Montaje","Correcta instalación a favor de agua","Según Guía","4.3.3",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.06,0]
[null,null,"Correcto sellado (donde haya riesgo de entrada de agua de lluvía)","Según Guía","4.3.3",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.06,0]
[null,null,"Uso de tapas en finales de aislamiento ( cajas desmontables, rosetas,…)","Según Guía","4.11",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.04,0]
[null,null,"Correcto tratamiento salidas  de traceaado.","Según Guía","4.11",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.02,0]
[null,null,"Tratamiento de puentes térmicos (tapas, instrumentos,…)","Según Guía","4.11",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.04,0]
[null,"Acabado final","No presenta golpes, ni aberturas, ni daños.","Inspección general","Guía",0.05,{"$f":"IF(Tabla29[[#This Row],[V]]<>\"X\",\" \",Tabla29[[#This Row],[V]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[D]]<>\"X\",\" \",Tabla29[[#This Row],[D]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[P]]<>\"X\",\" \",Tabla29[[#This Row],[P]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[C]]<>\"X\",\" \",Tabla29[[#This Row],[C]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[T]]<>\"X\",\" \",Tabla29[[#This Row],[T]])","v":" "},{"$f":"IF(Tabla29[[#This Row],[VALORACIÓN INSPECTOR]]=\" \",\" \",Tabla29[[#This Row],[VALORACIÓN INSPECTOR]])","v":0},{"$f":"IF(Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]]=0,\" \",Tabla29[[#This Row],[OBSERVACIONES INSPECTOR]])","v":" "},0.1,0]
[null,null,"• V= Visual • D= Dimensional • P= Información de Planos\n• C= Información de Certificados • T= Termografía",null,null,null,null,null,null,null,null,null,null,"TOTAL PPI",{"$f":"SUM($O29:$O44)","v":0}]

{"sheet":"CALIFICACIÓN (IMP)","index":10,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":true,"merged":[[30,3,30,5],[31,3,31,5],[32,3,32,5],[33,3,33,5],[29,3,29,5],[0,0,0,6],[2,0,2,6],[9,0,9,6],[16,0,16,6],[25,0,25,6]]}
["CÁLCULO DE LA CALIFICACIÓN DE LA INSTALACIÓN"]
[]
["A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
[null,"Tuberías","Nota BASE (N)","Ponderación Superficies Aisladas (% 1) ","Ponderación Calidad de aislamiento (% 2) ","Nota Total Obtenida \n(N x %1 x %2)"]
[null,"ANEXO 2.a): Espesores de Aislamiento",6,{"$f":"'Datos (SUP AISLADA)'!H30","v":0},{"$f":"'Datos (ESP AISLAMIENTO)'!E60","v":0},{"$f":"ROUND($E6*$D6*$C6,2)","v":0}]
[null,"ANEXO 3.a): Registros de Inspección",4,{"$f":"'Datos (SUP AISLADA)'!H30","v":0},{"$f":"'Datos (PPI AISLAMIENTO)'!O23","v":0},{"$f":"ROUND($E7*$D7*$C7,2)","v":0}]
[null,"TOTAL NOTA MÁXIMA",{"$f":"SUM(C6:C7)","v":10},null,"TOTAL",{"$f":"SUM($F6:$F7)","v":0}]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
[null,"Tuberías","Nota BASE (N)","Ponderación Superficies Aisladas (% 1). ","Ponderación Calidad de aislamiento (% 2). ","Nota Total Obtenida \n(N x %1 x %2)"]
[null,"ANEXO 2.b): Espesores de Aislamiento",6,{"$f":"'Datos (SUP AISLADA)'!H31","v":0},{"$f":"'Datos (ESP AISLAMIENTO)'!E121","v":0},{"$f":"ROUND($E13*$D13*$C13,2)","v":0}]
[null,"ANEXO 3.b): Registros de Inspección",4,{"$f":"'Datos (SUP AISLADA)'!H31","v":0},{"$f":"'Datos (PPI AISLAMIENTO)'!O45","v":0},{"$f":"ROUND($E14*$D14*$C14,2)","v":0}]
[null,"TOTAL NOTA MÁXIMA",{"$f":"SUM(C13:C14)","v":10},null,"TOTAL",{"$f":"SUM($F13:$F14)","v":0}]
[]
["C) Total de superfices calientes en la instalación (A)+(B)"]
[]
[null,"Según tabla a continuación:"]
[]
[null,"Sistema","PESO CISA (%)","NOTA PARCIAL","NOTA PONDERADA"]
[null,"Tuberías",{"$f":"'Datos (SUP AISLADA)'!$M$30","v":0},{"$f":"$F$8","v":0},{"$f":"IFERROR((ROUND($D$22*$C$22,2)),0)","v":0}]
[null,"Equipos",{"$f":"'Datos (SUP AISLADA)'!$M$31","v":0},{"$f":"$F$15","v":0},{"$f":"IFERROR((ROUND($D$23*$C$23,2)),0)","v":0}]
[null,null,null,"NOTA GLOBAL",{"$f":"SUM($E$22:$E$23)","v":0}]
[]
["CALIFICACIÓN OBTENIDA"]
[]
[null,null,null,"NOTA:",{"$f":"E24","v":0}]
[]
[null,"Rango","Nota","Recomendaciones"]
[null,"más de 9","Excelente","Mantenimiento Preventivo"]
[null,"de 7 a 9","Bueno","Mantenimiento Preventivo. Actuaciones puntuales"]
[null,"de 5 a 7","Deficiente","Mantenimiento Correctivo y Preventivo. Actuaciones de mejora"]
[null,"menos de 5","Muy deficiente","Actuaciones generalizadas de mejora"]

{"sheet":"COSTE NO AISLAM (IMP)","index":11,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":true,"merged":[[9,5,9,6],[0,0,0,8],[2,1,2,5],[4,0,4,8],[6,1,6,5],[8,5,8,6],[23,3,23,4],[23,5,23,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[18,0,18,8],[20,1,20,5],[22,3,22,4],[22,5,22,6],[24,3,24,4],[24,5,24,6],[25,3,25,4],[25,5,25,6],[26,3,26,4],[26,5,26,6],[37,3,37,4],[27,3,27,4],[27,5,27,6],[28,3,28,4],[28,5,28,6],[29,3,29,4],[29,5,29,6],[30,5,30,6],[32,0,32,8],[34,3,34,4],[35,3,35,4],[36,3,36,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4]]}
["COSTE DE NO AISLAMIENTO"]
[]
[null,"Precio adoptado energía kWh",null,null,null,null,{"$f":"IF('COSTE NO AISLAM'!E3=0,\" \",'COSTE NO AISLAM'!E3)","v":" "},"€/kWh"]
[]
["A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
[null,"Número de horas anuales de trabajo bajo condiciones de operación",null,null,null,null,{"$f":"IF('COSTE NO AISLAM'!E7=0,\" \",'COSTE NO AISLAM'!E7)","v":" "},"horas/año"]
[]
[null,"Tª superficial de la instalación X\n(ºC)","Total m²\nSIN AISLAR","Diámetro medio\n(mm)","Total pérdidas kW/m²","Total pérdidas kWh/año",null,"Total €/año"]
[null,"60<X≤100",{"$f":"'Datos (SUP AISLADA)'!B6-'Datos (SUP AISLADA)'!C6-'Datos (SUP AISLADA)'!D6","v":0},{"$f":"IF('COSTE NO AISLAM'!C10=0,\" \",'COSTE NO AISLAM'!C10)","v":" "},{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q8),0)","v":0},{"$f":"'COSTE NO AISLAM'!E10","v":0},null,{"$f":"'COSTE NO AISLAM'!$F10","v":0}]
[null,"100<X≤200",{"$f":"'Datos (SUP AISLADA)'!B7-'Datos (SUP AISLADA)'!C7-'Datos (SUP AISLADA)'!D7","v":0},{"$f":"IF('COSTE NO AISLAM'!C11=0,\" \",'COSTE NO AISLAM'!C11)","v":" "},{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q9),0)","v":0},{"$f":"'COSTE NO AISLAM'!E11","v":0},null,{"$f":"'COSTE NO AISLAM'!$F11","v":0}]
[null,"200<X≤300",{"$f":"'Datos (SUP AISLADA)'!B8-'Datos (SUP AISLADA)'!C8-'Datos (SUP AISLADA)'!D8","v":0},{"$f":"IF('COSTE NO AISLAM'!C12=0,\" \",'COSTE NO AISLAM'!C12)","v":" "},{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q10),0)","v":0},{"$f":"'COSTE NO AISLAM'!E12","v":0},null,{"$f":"'COSTE NO AISLAM'!$F12","v":0}]
[null,"300<X≤400",{"$f":"'Datos (SUP AISLADA)'!B9-'Datos (SUP AISLADA)'!C9-'Datos (SUP AISLADA)'!D9","v":0},{"$f":"IF('COSTE NO AISLAM'!C13=0,\" \",'COSTE NO AISLAM'!C13)","v":" "},{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q11),0)","v":0},{"$f":"'COSTE NO AISLAM'!E13","v":0},null,{"$f":"'COSTE NO AISLAM'!$F13","v":0}]
[null,"400<X≤500",{"$f":"'Datos (SUP AISLADA)'!B10-'Datos (SUP AISLADA)'!C10-'Datos (SUP AISLADA)'!D10","v":0},{"$f":"IF('COSTE NO AISLAM'!C14=0,\" \",'COSTE NO AISLAM'!C14)","v":" "},{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q12),0)","v":0},{"$f":"'COSTE NO AISLAM'!E14","v":0},null,{"$f":"'COSTE NO AISLAM'!$F14","v":0}]
[null,"500<X≤600",{"$f":"'Datos (SUP AISLADA)'!B11-'Datos (SUP AISLADA)'!C11-'Datos (SUP AISLADA)'!D11","v":0},{"$f":"IF('COSTE NO AISLAM'!C15=0,\" \",'COSTE NO AISLAM'!C15)","v":" "},{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q13),0)","v":0},{"$f":"'COSTE NO AISLAM'!E15","v":0},null,{"$f":"'COSTE NO AISLAM'!$F15","v":0}]
[null,"600<X≤650",{"$f":"'Datos (SUP AISLADA)'!B12-'Datos (SUP AISLADA)'!C12-'Datos (SUP AISLADA)'!D12","v":0},{"$f":"IF('COSTE NO AISLAM'!C16=0,\" \",'COSTE NO AISLAM'!C16)","v":" "},{"$f":"IFERROR(('Hoja Cálculos Térmicos'!Q14),0)","v":0},{"$f":"'COSTE NO AISLAM'!E16","v":0},null,{"$f":"'COSTE NO AISLAM'!$F16","v":0}]
[null,"TOTAL",{"$f":"SUM(C10:C16)","v":0},null,null,{"$f":"SUM(F10:F16)","v":0},null,{"$f":"SUM(H10:H16)","v":0}]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
[null,"Número de horas anuales de trabajo bajo condiciones de operación",null,null,null,"horas/año",{"$f":"IF('COSTE NO AISLAM'!E21=0,\" \",'COSTE NO AISLAM'!E21)","v":" "},"horas/año"]
[]
[null,"Tª superficial de la instalación X\n(ºC)","Total m²\nSIN AISLAR","Total pérdidas kW/m²",null,"Total pérdidas kWh/año",null,"Total €/año"]
[null,"60<X≤100",{"$f":"'Datos (SUP AISLADA)'!B18-'Datos (SUP AISLADA)'!C18-'Datos (SUP AISLADA)'!D18","v":0},{"$f":"'Hoja Cálculos Térmicos'!I23","v":1.0376688970110231},null,{"$f":"'COSTE NO AISLAM'!D24","v":0},null,{"$f":"'COSTE NO AISLAM'!E24","v":0}]
[null,"100<X≤200",{"$f":"'Datos (SUP AISLADA)'!B19-'Datos (SUP AISLADA)'!C19-'Datos (SUP AISLADA)'!D19","v":0},{"$f":"'Hoja Cálculos Térmicos'!I24","v":2.5104347777449632},null,{"$f":"'COSTE NO AISLAM'!D25","v":0},null,{"$f":"'COSTE NO AISLAM'!E25","v":0}]
[null,"200<X≤300",{"$f":"'Datos (SUP AISLADA)'!B20-'Datos (SUP AISLADA)'!C20-'Datos (SUP AISLADA)'!D20","v":0},{"$f":"'Hoja Cálculos Térmicos'!I25","v":5.7314539364789781},null,{"$f":"'COSTE NO AISLAM'!D26","v":0},null,{"$f":"'COSTE NO AISLAM'!E26","v":0}]
[null,"300<X≤400",{"$f":"'Datos (SUP AISLADA)'!B21-'Datos (SUP AISLADA)'!C21-'Datos (SUP AISLADA)'!D21","v":0},{"$f":"'Hoja Cálculos Térmicos'!I26","v":10.749545202154277},null,{"$f":"'COSTE NO AISLAM'!D27","v":0},null,{"$f":"'COSTE NO AISLAM'!E27","v":0}]
[null,"400<X≤500",{"$f":"'Datos (SUP AISLADA)'!B22-'Datos (SUP AISLADA)'!C22-'Datos (SUP AISLADA)'!D22","v":0},{"$f":"'Hoja Cálculos Térmicos'!I27","v":18.240721111831128},null,{"$f":"'COSTE NO AISLAM'!D28","v":0},null,{"$f":"'COSTE NO AISLAM'!E28","v":0}]
[null,"500<X≤600",{"$f":"'Datos (SUP AISLADA)'!B23-'Datos (SUP AISLADA)'!C23-'Datos (SUP AISLADA)'!D23","v":0},{"$f":"'Hoja Cálculos Térmicos'!I28","v":29.014160678102463},null,{"$f":"'COSTE NO AISLAM'!D29","v":0},null,{"$f":"'COSTE NO AISLAM'!E29","v":0}]
[null,"600<X≤650",{"$f":"'Datos (SUP AISLADA)'!B24-'Datos (SUP AISLADA)'!C24-'Datos (SUP AISLADA)'!D24","v":0},{"$f":"'Hoja Cálculos Térmicos'!I29","v":39.806966793306259},null,{"$f":"'COSTE NO AISLAM'!D30","v":0},null,{"$f":"'COSTE NO AISLAM'!E30","v":0}]
[null,"TOTAL",{"$f":"SUM(C24:C30)","v":0},null,null,{"$f":"SUM(F24:F30)","v":0},null,{"$f":"SUM(H24:H30)","v":0}]
[]
["C) Coste de no aislamiento en todas las superficies"]
[]
[null,"Tª superficial de la instalación X\n(ºC)","Total m²\nSIN AISLAR","Total €/año"]
[null,"60<X≤100",{"$f":"C10+C24","v":0},{"$f":"H10+H24","v":0}]
[null,"100<X≤200",{"$f":"C11+C25","v":0},0]
[null,"200<X≤300",0,0]
[null,"300<X≤400",0,0]
[null,"400<X≤500",0,0]
[null,"500<X≤600",0,0]
[null,"600<X≤650",0,0]
[null,"TOTAL",{"$f":"SUM(C36:C42)","v":0},{"$f":"SUM(D36:E42)","v":0}]

{"sheet":"RECOMENDACIONES (IMP)","index":12,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[[12,1,12,5],[13,1,13,5],[14,1,17,5],[0,0,0,5],[2,0,2,5],[4,1,4,5],[5,1,5,5],[6,1,8,5],[10,0,10,5]]}
["RECOMENDACIONES DEL INSPECTOR"]
[]
["A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
[null,{"$f":"IF('Datos (SUP AISLADA)'!$M$13<=0,\"\",\"La nota parcial obtenida para las tuberías de la instalación ha sido: \"&(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$6,'Hoja de programación'!$S$6,(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$5,'Hoja de programación'!$S$5,(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$4,'Hoja de programación'!$S$4,(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$3,'Hoja de programación'!$S$3,0)))))))))","v":""}]
[null,{"$f":"IF('Datos (SUP AISLADA)'!$M$13<=0,\" \",\"Las medidas a adoptar atendiendo a la calificación obtenida son:\")","v":" "}]
[null,{"$f":"IF('Datos (SUP AISLADA)'!$M$13<=0,\" \",VLOOKUP((IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$6,'Hoja de programación'!$S$6,(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$5,'Hoja de programación'!$S$5,(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$4,'Hoja de programación'!$S$4,(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$3,'Hoja de programación'!$S$3,0)))))))),'Hoja de programación'!$G$9:$H$13,2,FALSE))","v":" "}]
[]
[]
[]
["B) Superficies planas (desde 1000 mm de diámetro) y equipos"]
[]
[null,{"$f":"IF('Datos (SUP AISLADA)'!$M$25<=0,\" \",\"La nota parcial obtenida para las superficies planas y equipos de la instalación ha sido: \"&(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$6,'Hoja de programación'!$S$6,(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$5,'Hoja de programación'!$S$5,(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$4,'Hoja de programación'!$S$4,(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$3,'Hoja de programación'!$S$3,0)))))))))","v":" "}]
[null,{"$f":"IF('Datos (SUP AISLADA)'!$M$25<=0,\" \",\"Las medidas a adoptar atendiendo a la calificación obtenida son:\")","v":" "}]
[null,{"$f":"IF('Datos (SUP AISLADA)'!$M$25<=0,\" \",VLOOKUP((IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$6,'Hoja de programación'!$S$6,(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$5,'Hoja de programación'!$S$5,(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$4,'Hoja de programación'!$S$4,(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$3,'Hoja de programación'!$S$3,0)))))))),'Hoja de programación'!$G$15:$H$18,2,FALSE))","v":" "}]

{"sheet":"Hoja de programación","index":13,"n_rows":54,"n_cols":21,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Datos validación",null,"Percentiles",null,"Cumplimiento",null,null,null,null,"Checklist",null,"Provincias","Comunidad Autónoma","CC_XX"]
["Sí",null,0,null,"Sí",null,"Nota","Recomendaciones",null,null,null,null,null,null,null,null,"Inferior","Superior","Nota"]
["No",null,0.1,null,"Parcial",null,"Excelente","Mantenimiento Preventivo",null,"X",null,"Albacete","CASTILLA LA MANCHA","02",null,null,9,10,"Excelente"]
[null,null,0.2,null,"No",null,"Muy bueno","Mantenimiento Preventivo. Actuaciones puntuales",null,null,null,"Alicante/Alacant","COMUNIDAD VALENCIANA","03",null,null,7,9,"Muy bueno"]
[null,null,0.3,null,null,null,"Correcto","Manteamiento Correctivo y Preventivo. Actuaciones de mejora",null,null,null,"Almería","ANDALUCÍA","04",null,null,5,7,"Correcto"]
[null,null,0.4,null,null,null,"Deficiente","Actuaciones generalizadas de mejora",null,null,null,"Araba/Álava","EUSKADI","01",null,null,0,5,"Deficiente",null,{"$f":"(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$6,'Hoja de programación'!$S$6,(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$5,'Hoja de programación'!$S$5,(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$4,'Hoja de programación'!$S$4,(IF(CALIFICACIÓN!$E$8<='Hoja de programación'!$R$3,'Hoja de programación'!$S$3,0))))))))","v":"Deficiente"}]
[null,null,0.5,null,null,null,null,null,null,null,null,"Asturias","PRINCIPADO DE ASTURIAS","33",null,null,null,null,null,null,{"$f":"IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$6,'Hoja de programación'!$S$6,(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$5,'Hoja de programación'!$S$5,(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$4,'Hoja de programación'!$S$4,(IF(CALIFICACIÓN!$E$15<='Hoja de programación'!$R$3,'Hoja de programación'!$S$3,0)))))))","v":"Deficiente"}]
[null,null,0.6,null,null,null,"Nota","Recomendación Tuberías",null,null,null,"Ávila","CASTILLA-LEÓN","05"]
[null,null,0.7,null,null,null,"Excelente","Implantación/aplicación del plan de mantenimiento preventivo:\n· Revisión periódica del estado del aislamiento.\n· Adecuado desmontaje y montaje del aislamiento de bridas, válvulas y elementos singulares.",null,null,null,"Badajoz","EXTREMADURA","06"]
[null,null,0.8,null,null,null,"Muy bueno","Implantación/aplicación del plan de mantenimiento preventivo:\n· Revisión periódica del estado del aislamiento.\n· Adecuado desmontaje y montaje del aislamiento de bridas, válvulas y elementos singulares.\n· Actuaciones  puntuales en zonas no aisladas, como bridas, válvulas, etc., o en zonas con aislamiento defectuoso.\n· Realización de mediciones mas estrictas para detectar puntos calientes no esperados.",null,null,null,"Balears, Illes","ISLAS BALEARES","07"]
[null,null,0.9,null,null,null,"Correcto","Implantación/aplicación del plan de mantenimiento preventivo:\n· Revisión periódica del estado del aislamiento.\n· Adecuado desmontaje y montaje del aislamiento de bridas, válvulas y elementos singulares.\n· Actuaciones  puntuales en zonas no aisladas, como bridas, válvulas, etc., o en zonas con aislamiento defectuoso.\n· Realización de mediciones mas estrictas para detectar puntos calientes no esperados.\n· Realización de auditorías específicas del aislamiento, realización de estudio de viabilidad y realización de actuaciones de mejora en las zonas con aislamiento defectuoso.",null,null,null,"Barcelona","CATALUNYA","08"]
[null,null,1,null,null,null,"Deficiente","·Realización de auditoría específica del aislamiento para realización de un plan de acción global para la mejora, sustitución o implementación de un nuevo sistema de aislamiento allí donde sea necesario.",null,null,null,"Bizkaia","EUSKADI","48"]
[null,null,null,null,null,null,null,null,null,null,null,"Burgos","CASTILLA-LEÓN","09"]
[null,null,null,null,null,null,"Nota","Recomendación Equipos",null,null,null,"Cáceres","EXTREMADURA","10"]
[null,null,null,null,null,null,"Excelente","Implantación/aplicación del plan de mantenimiento preventivo:\n· Revisión periódica del estado del aislamiento.\n· Adecuado desmontaje y montaje del aislamiento de bridas, bridas ciegas, bocas de hombre y elementos singulares.",null,null,null,"Cádiz","ANDALUCÍA","11"]
[null,null,null,null,null,null,"Muy bueno","Implantación/aplicación del plan de mantenimiento preventivo:\n· Revisión periódica del estado del aislamiento.\n· Adecuado desmontaje y montaje del aislamiento de bridas, válvulas y elementos singulares.\n· Actuaciones  puntuales en zonas no aisladas, como bridas, válvulas, etc., o en zonas con aislamiento defectuoso.\n· Realización de mediciones más estrictas para detectar puntos calientes no esperados.",null,null,null,"Cantabria","CANTABRIA","39"]
[null,null,null,null,null,null,"Correcto","Implantación/aplicación del plan de mantenimiento preventivo:\n· Revisión periódica del estado del aislamiento.\n· Adecuado desmontaje y montaje del aislamiento de bridas, válvulas y elementos singulares.\n· Actuaciones  puntuales en zonas no aisladas, como bridas, válvulas, etc., o en zonas con aislamiento defectuoso.\n· Realización de mediciones más estrictas para detectar puntos calientes no esperados.\n· Realización de auditorías específicas del aislamiento, realización de estudio de viabilidad y realización de actuaciones de mejora en las zonas con aislamiento defectuoso.",null,null,null,"Castellón/Castelló","COMUNIDAD VALENCIANA","12"]
[null,null,null,null,null,null,"Deficiente","·Realización de auditoría específica del aislamiento para realización de un plan de acción global para la mejora, sustitución o implementación de un nuevo sistema de aislamiento allí donde sea necesario.",null,null,null,"Ceuta","CEUTA","51"]
[null,null,null,null,null,null,null,null,null,null,null,"Ciudad Real","CASTILLA LA MANCHA","13"]
[null,null,null,null,null,null,null,null,null,null,null,"Córdoba","ANDALUCÍA","14"]
[null,null,null,null,null,null,null,null,null,null,null,"Coruña, A","GALICIA","15"]
[null,null,null,null,null,null,null,null,null,null,null,"Cuenca","CASTILLA LA MANCHA","16"]
[null,null,null,null,null,null,null,null,null,null,null,"Guipúzcoa","EUSKADI","20"]
[null,null,null,null,null,null,null,null,null,null,null,"Girona","CATALUNYA","17"]
[null,null,null,null,null,null,null,null,null,null,null,"Granada","ANDALUCÍA","18"]
[null,null,null,null,null,null,null,null,null,null,null,"Guadalajara","CASTILLA LA MANCHA","19"]
[null,null,null,null,null,null,null,null,null,null,null,"Huelva","ANDALUCÍA","21"]
[null,null,null,null,null,null,null,null,null,null,null,"Huesca","ARAGÓN","22"]
[null,null,null,null,null,null,null,null,null,null,null,"Jaén","ANDALUCÍA","23"]
[null,null,null,null,null,null,null,null,null,null,null,"León","CASTILLA -LEÓN","24"]
[null,null,null,null,null,null,null,null,null,null,null,"Lleida","CATALUNYA","25"]
[null,null,null,null,null,null,null,null,null,null,null,"Lugo","GALICIA","27"]
[null,null,null,null,null,null,null,null,null,null,null,"Madrid","COMUNIDAD DE MADRID","28"]
[null,null,null,null,null,null,null,null,null,null,null,"Málaga","ANDALUCÍA","29"]
[null,null,null,null,null,null,null,null,null,null,null,"Melilla","MELILLA","52"]
[null,null,null,null,null,null,null,null,null,null,null,"Murcia","MURCIA","30"]
[null,null,null,null,null,null,null,null,null,null,null,"Navarra","NAVARRA","31"]
[null,null,null,null,null,null,null,null,null,null,null,"Ourense","GALICIA","32"]
[null,null,null,null,null,null,null,null,null,null,null,"Palencia","CASTILLA-LEÓN","34"]
[null,null,null,null,null,null,null,null,null,null,null,"Palmas, Las","CANARIAS","35"]
[null,null,null,null,null,null,null,null,null,null,null,"Pontevedra","GALICIA","36"]
[null,null,null,null,null,null,null,null,null,null,null,"Rioja, La","LA RIOJA","26"]
[null,null,null,null,null,null,null,null,null,null,null,"Salamanca","CASTILLA-LEÓN","37"]
[null,null,null,null,null,null,null,null,null,null,null,"Santa Cruz de Tenerife","CANARIAS","38"]
[null,null,null,null,null,null,null,null,null,null,null,"Segovia","CASTILLA-LEÓN","40"]
[null,null,null,null,null,null,null,null,null,null,null,"Sevilla","ANDALUCÍA","41"]
[null,null,null,null,null,null,null,null,null,null,null,"Soria","CASTILLA-LEÓN","42"]
[null,null,null,null,null,null,null,null,null,null,null,"Tarragona","CATALUNYA","43"]
[null,null,null,null,null,null,null,null,null,null,null,"Teruel","ARAGÓN","44"]
[null,null,null,null,null,null,null,null,null,null,null,"Toledo","CASTILLA LA MANCHA","45"]
[null,null,null,null,null,null,null,null,null,null,null,"Valencia/València","COMUNIDAD VALENCIANA","46"]
[null,null,null,null,null,null,null,null,null,null,null,"Valladolid","CASTILLA-LEÓN","47"]
[null,null,null,null,null,null,null,null,null,null,null,"Zamora","CASTILLA-LEÓN","49"]
[null,null,null,null,null,null,null,null,null,null,null,"Zaragoza","ARAGÓN","50"]

{"sheet":"Hoja Cálculos Térmicos","index":14,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Temperatura ambiental en ºC",null,null,{"$f":"IFERROR((MIN('Datos (GENERALES) (IMP)'!H104:J104,'Datos (GENERALES) (IMP)'!H108:J108)),25)","v":0},"ºC"]
[]
[null,"A) Superficies de tuberías (hasta 1000 mm de diámetro)"]
[]
[]
[null,null,"Tª superficial de la instalación\n(ºC)","Tª superficial media por tramo\n(ºC)","Tª superficial media por tramo\n(K)","Tª ambiental por tramo\n(ºC)","Tª ambiental por tramo\n(K)","Diametro promedio en mm","Diametro promedio en m","Superficie exterior tubería en m2","h convección","h radiación","h total= h convección + h radicación","R conv_cilindrica","Pérdidas W/metro lineal","Pérdidas W/ m2","Pérdidas kW/ m2"]
[null,null,"60<X≤100",80,{"$f":"D8+273","v":353},{"$f":"$E$2","v":0},{"$f":"F8+273","v":273},{"$f":"'COSTE NO AISLAM'!C10","v":0},{"$f":"H8/1000","v":0},{"$f":"PI()*I8","v":0},{"$f":"IFERROR(IF(I8^3*(D8-F8)<=10,SQRT(SQRT((D8-F8)/I8))*1.25,1.21*((D8-F8)^(1/3))),0)","v":0},{"$f":"0.9*0.0000000567*(E8+G8)*(E8*E8+G8*G8)","v":6.3614195996399996},{"$f":"K8+L8","v":6.3614195996399996},{"$f":"IFERROR((1/(PI()*I8*M8)),0)","v":0},{"$f":"IFERROR(((D8-F8)/N8),0)","v":0},{"$f":"IFERROR((O8/J8),0)","v":0},{"$f":"P8/1000","v":0}]
[null,null,"100<X≤200",150,{"$f":"D9+273","v":423},{"$f":"$E$2","v":0},{"$f":"F9+273","v":273},{"$f":"'COSTE NO AISLAM'!C11","v":0},{"$f":"H9/1000","v":0},0,{"$f":"IFERROR(IF(I9^3*(D9-F9)<=10,SQRT(SQRT((D9-F9)/I9))*1.25,1.21*((D9-F9)^(1/3))),0)","v":0},{"$f":"0.9*0.0000000567*(E9+G9)*(E9*E9+G9*G9)","v":9.0020373710400001},{"$f":"K9+L9","v":9.0020373710400001},{"$f":"IFERROR((1/(PI()*I9*M9)),0)","v":0},{"$f":"IFERROR(((D9-F9)/N9),0)","v":0},{"$f":"IFERROR((O9/J9),0)","v":0},{"$f":"P9/1000","v":0}]
[null,null,"200<X≤300",250,523,0,273,{"$f":"'COSTE NO AISLAM'!C12","v":0},0,0,0,14.13807419304,14.13807419304,0,0,0,0]
[null,null,"300<X≤400",350,623,0,273,{"$f":"'COSTE NO AISLAM'!C13","v":0},0,0,0,21.154056215040001,21.154056215040001,0,0,0,0]
[null,null,"400<X≤500",450,723,0,273,{"$f":"'COSTE NO AISLAM'!C14","v":0},0,0,0,30.356163437040003,30.356163437040003,0,0,0,0]
[null,null,"500<X≤600",550,823,0,273,{"$f":"'COSTE NO AISLAM'!C15","v":0},0,0,0,42.050575859040002,42.050575859040002,0,0,0,0]
[null,null,"600<X≤650",625,898,0,273,{"$f":"'COSTE NO AISLAM'!C16","v":0},0,{"$f":"PI()*I14","v":0},0,52.641146869290004,52.641146869290004,0,0,0,0]
[]
[null,null,"NOTA 1: Cálculo según \"Guía Técnica IDAE: Diseño y Cálculo del aislamiento térmico de conductos, aparatos y equipos"]
[null,null,"NOTA 2:  Se asume regimen laminar en el aire exterior"]
[]
[null,"B) Superficies planas y equipos (desde 1000 mm de diámetro)"]
[]
[]
[null,null,"Tª superficial de la instalación\n(ºC)","Tª superficial media por tramo\n(ºC)","Tª superficial media por tramo\n(K)","Tª ambiental por tramo\n(ºC)","Tª ambiental por tramo\n(K)","Pérdidas W/ m2","Pérdidas kW/ m2"]
[null,null,"60<X≤100",80,{"$f":"D23+273","v":353},{"$f":"$E$2","v":0},{"$f":"F23+273","v":273},{"$f":"POWER((D23-F23),1.25)*2.21+5.67*0.9*(POWER((E23/100),4)-POWER((G23/100),4))","v":1037.6688970110231},{"$f":"H23/1000","v":1.0376688970110231}]
[null,null,"100<X≤200",150,{"$f":"D24+273","v":423},{"$f":"$E$2","v":0},{"$f":"F24+273","v":273},2510.434777744963,{"$f":"H24/1000","v":2.5104347777449632}]
[null,null,"200<X≤300",250,523,0,273,5731.453936478978,5.7314539364789781]
[null,null,"300<X≤400",350,623,0,273,10749.545202154277,10.749545202154277]
[null,null,"400<X≤500",450,723,0,273,18240.721111831128,18.240721111831128]
[null,null,"500<X≤600",550,823,0,273,29014.160678102464,29.014160678102463]
[null,null,"600<X≤650",625,898,0,273,39806.966793306259,39.806966793306259]
[]
[null,null,"NOTA 1: Cálculo según fórmula de Fishendon y Saunders, asumiendo K= 2,21 y e=0,9"]