{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Plantilla_Relación Valorada","Plantilla_Desglose complementar","Plantilla_Resumen Tipos"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Plantilla_Relación Valorada","index":0,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":false,"merged":[[70,1,70,9],[6,1,6,2],[5,1,5,2],[7,1,7,2],[62,9,62,10],[48,2,48,7],[54,2,54,7],[18,2,18,7],[24,2,24,7],[30,2,30,7],[36,2,36,7],[42,2,42,7]]}
[]
[]
[]
[]
[]
["Nº Expte.","C2I5PL/22/XXXXX"]
["Beneficiario"]
["Nombre de actuacion"]
[]
["RELACIÓN VALORADA",null,null,"Nº de  Certificacion a la que corresponde : ",{"$nulls":4},"Mes",null,"Año"]
[]
["Código","Ud.","Descripción",{"$nulls":5},"Medición","Precio","Importe","Tipo"]
[null,null,"Comentario","Cantidad","Longitud","Anchura","Altura","Parcial","Subtotal",null,null,"Actuación"]
[]
[1,"CAPÍTULO:  "]
["1.1","SUBCAPÍTULO: "]
[]
["XX0111","Ud","Enunciado",{"$nulls":5},{"$f":"I22","v":0},0,{"$f":"ROUND(PRODUCT(I18:J18),0)","v":0},"A"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,0,0,{"$f":"ROUND(PRODUCT(D21:G21),3)","v":0}]
[{"$nulls":8},{"$f":"SUM(H21)","v":0}]
[]
["XX0112","Ud","Enunciado",{"$nulls":5},{"$f":"I28","v":0},0,{"$f":"ROUND(PRODUCT(I24:J24),0)","v":0},"B"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,0,0,{"$f":"ROUND(PRODUCT(D27:G27),3)","v":0}]
[{"$nulls":8},{"$f":"SUM(H27)","v":0}]
[]
["XX0113","Ud","Enunciado",{"$nulls":5},{"$f":"I34","v":0},0,{"$f":"ROUND(PRODUCT(I30:J30),0)","v":0},"C"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,0,0,{"$f":"ROUND(PRODUCT(D33:G33),3)","v":0}]
[{"$nulls":8},{"$f":"SUM(H33)","v":0}]
[]
["XX0114","Ud","Enunciado",{"$nulls":5},{"$f":"I40","v":0},0,{"$f":"ROUND(PRODUCT(I36:J36),0)","v":0},"D"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,0,0,{"$f":"ROUND(PRODUCT(D39:G39),3)","v":0}]
[{"$nulls":8},{"$f":"SUM(H39)","v":0}]
[]
["XX0115","Ud","Enunciado",{"$nulls":5},{"$f":"I46","v":0},0,{"$f":"ROUND(PRODUCT(I42:J42),0)","v":0},"E"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,0,0,{"$f":"ROUND(PRODUCT(D45:G45),3)","v":0}]
[{"$nulls":8},{"$f":"SUM(H45)","v":0}]
[]
["XX0114","Ud","Enunciado",{"$nulls":5},{"$f":"I52","v":0},0,{"$f":"ROUND(PRODUCT(I48:J48),0)","v":0},"NO ELEGIBLES ( Fondos Propios)"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,0,0,{"$f":"ROUND(PRODUCT(D51:G51),3)","v":0}]
[{"$nulls":8},{"$f":"SUM(H51)","v":0}]
[]
["XX0114","Ud","Enunciado",{"$nulls":5},{"$f":"I58","v":0},0,{"$f":"ROUND(PRODUCT(I54:J54),0)","v":0},"NO ELEGIBLES ( Otras Ayudas)"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,0,0,{"$f":"ROUND(PRODUCT(D57:G57),3)","v":0}]
[{"$nulls":8},{"$f":"SUM(H57)","v":0}]
[]
[]
[]
[]
[null,null,"Firma El promotor",null,null,"Firma Direccion Facultativa",null,null,null,"Firma Constructora"]
{"$rows_empty":7}
[null,"**Observacion: En el caso de existir más de una fuente de financiación por otros fondos, se deberá indicar por separado"]

{"sheet":"Plantilla_Desglose complementar","index":1,"n_rows":70,"n_cols":6,"rows_kept":70,"cut":false,"hidden":false,"merged":[[5,2,5,3],[6,2,6,3],[69,1,69,5],[66,4,66,5],[70,1,70,5],[10,1,10,5]]}
[]
[]
[]
[]
[]
[null,"Nº Expte.","C2I5PL/22/XXXXX"]
[null,"Beneficiario"]
[null,"Nombre de actuacion"]
[]
[]
[null,"DESGLOSE DE LA RELACIÓN VALORADA "]
[]
[null,"Nº DE CERTIFICACION A LA QUE CORRESPONDE :  …, MES - AÑO"]
[]
[null,"Código","Ud.","Descripción",null,"Importe"]
[null,null,null,"Comentario"]
[]
[null,"ACTUACIONES TIPO A"]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E20:E20),0)","v":0}]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E22:E22),0)","v":0}]
[]
[]
[null,"ACTUACIONES TIPO B"]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E27:E27),0)","v":0}]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E29:E29),0)","v":0}]
[]
[]
[null,"ACTUACIONES TIPO C"]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E34:E34),0)","v":0}]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E36:E36),0)","v":0}]
[]
[]
[null,"ACTUACIONES TIPO D"]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E41:E41),0)","v":0}]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E43:E43),0)","v":0}]
[]
[]
[null,"ACTUACIONES TIPO E"]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E48:E48),0)","v":0}]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E50:E50),0)","v":0}]
[]
[]
[null,"NO ELEGIBLES ( Fondos Propios)"]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E55:E55),0)","v":0}]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E57:E57),0)","v":0}]
[]
[]
[null,"NO ELEGIBLES ( Otras Ayudas)"]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E62:E62),0)","v":0}]
[]
[null,"Cod. Partida","Ud","Nombre Partida",null,{"$f":"ROUND(PRODUCT(E64:E64),0)","v":0}]
[]
[]
[null,null,"Firma Direccion Facultativa",null,"Firma Constructora"]
[]
[]
[null,"**Observacion: En el caso de existir más de una fuente de financiación por otros fondos, se deberá indicar por separado"]

{"sheet":"Plantilla_Resumen Tipos","index":2,"n_rows":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":false,"merged":[[9,0,10,6],[11,1,11,5],[92,2,92,6],[98,2,98,6],[104,2,104,6],[110,2,110,6],[12,1,16,6],[80,2,80,6],[86,2,86,6],[43,4,43,5],[43,2,43,3],[40,1,40,6],[59,1,59,5]]}
[]
[]
[]
[]
[]
[null,"Nº Expte.","C2I5PL/22/XXXXX"]
[null,"Beneficiario"]
[null,"Nombre de actuacion"]
[]
["RESUMEN DE RELACION VALORADA POR TIPOS DE ACTUACION DE LA CERTIFICACION"]
[]
[null,"Nº de CERTIFICACION A LA QUE CORRESPONDE : …, MES   -   AÑO"]
[null,"El importe de la certificación original  número X, de MES de 202.. es de (IMPORTE)€ + IVA (Total con IVA =IMPORTE €).\n\nEste importe se desglosa según los siguientes tipos del Plan de Recuperación, Transformación y Resiliencia (PIREP):"]
{"$rows_empty":7}
[null,"TIPO","MEJORA ","COSTE ANTES DE IMPUESTOS","IVA (21%)","COSTE TOTAL"]
[null,"A","Mejora de eficiencia energetica",null,{"$f":"D22*1.21","v":0},{"$f":"SUM(C22,D22)","v":0}]
[null,"B","Mejora de sostenibilidad ambiental",null,{"$f":"D23*1.21","v":0},{"$f":"SUM(C23,D23)","v":0}]
[null,"C","Mejora de accesibilidad",null,0,0]
[null,"D","Mejora de habitabilidad",null,0,0]
[null,"E","Conservacion de los edificios",null,0,0]
[null,"NO ELEGIBLES ( Fondos Propios)",null,null,0,0]
[null,"NO ELEGIBLES ( Otras Ayudas)",null,null,0,0]
[]
[]
[null,"TIPO","MEJORA ","COSTE ANTES DE IMPUESTOS","IVA (21%)","COSTE TOTAL"]
[null,"A BIS","Mejora de eficiencia energetica",null,{"$f":"D32*1.21","v":0},{"$f":"SUM(C32,D32)","v":0}]
[null,"B BIS","Mejora de sostenibilidad ambiental",null,{"$f":"D33*1.21","v":0},{"$f":"SUM(C33,D33)","v":0}]
[null,"C BIS","Mejora de accesibilidad",null,0,0]
[null,"D BIS","Mejora de habitabilidad",null,0,0]
[null,"E BIS","Conservacion de los edificios",null,0,0]
[null,"NO ELEGIBLES ( Fondos Propios)",null,null,0,0]
[null,"NO ELEGIBLES ( Otras Ayudas)",null,null,0,0]
[]
[]
[null,"Se adjunta el desglosado del periodo de la certificación X con la caracterización por tipos."]
[]
[]
[null,"Firma El promotor","Firma Direccion Facultativa",null,"Firma Constructora"]
{"$rows_empty":15}
[null,"**Observacion: En el caso de existir más de una fuente de financiación por otros fondos, se deberá indicar por separado"]
{"$rows_empty":16}
[2,"CAPÍTULO:  "]
["2.1","SUBCAPÍTULO: "]
[]
["XX0211","Ud","Enunciado"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,null,0]
[]
[]
["XX0212","Ud","Enunciado"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,null,0]
[]
[]
["XX0213","Ud","Enunciado"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,null,0]
[]
[]
["XX0214","Ud","Enunciado"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,null,0]
[]
[]
["XX0215","Ud","Enunciado"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,null,0]
[]
[]
["XX0216","Ud","Enunciado"]
[null,null,"Descripción completa"]
[]
[null,null,null,1,0,null,0]