{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Datos","Analisis","Tarifas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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","index":0,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[21,6,23,7],[19,6,20,7],[24,6,26,7],[0,0,1,5],[3,1,3,2],[8,0,8,5],[9,0,9,4],[4,1,4,5],[3,3,3,4],[7,1,7,5],[16,0,16,4],[2,0,2,1],[17,0,17,4],[11,0,11,4],[13,0,13,4],[10,0,10,4],[2,2,2,5],[29,1,29,2],[21,0,21,4],[12,0,12,4],[22,0,22,4],[23,0,23,4],[19,0,19,4],[18,0,18,4],[20,0,20,4],[14,0,14,4],[15,0,15,4],[25,0,25,4],[29,3,29,4],[5,3,5,5],[26,0,26,4],[24,0,24,4],[27,0,27,5],[35,1,35,2],[35,3,35,4],[28,3,28,4],[33,1,33,2],[33,3,33,4],[34,1,34,2],[34,3,34,4],[28,1,28,2],[32,1,32,2],[32,3,32,4],[31,1,31,2],[31,3,31,4],[30,1,30,2],[30,3,30,4]]}
["INTRODUCCIÓN DE DATOS"]
[]
["PRESUPUESTO Nº:"]
["SUMINISTRO",null,null,"CONTADOR"]
["CALLE"]
["NÚMERO:",null,"POBLACIÓN"]
["COD.POSTAL"]
["INSTALADOR"]
["PARTIDAS DEL PRESUPUESTO"]
["Importe de Fontanería Exterior",null,null,null,null,0]
["Importe de Albañilería y Varios",null,null,null,null,0]
["Importe de nuevos Grupos de Presión",null,null,null,null,0]
["Importe de adaptación o ampliación de Grupos existentes",null,null,null,null,0]
["Importe de Proyecto Técnico y Dirección",null,null,null,null,0]
["Importe de Aislamiento Térmico de Montantes",null,null,null,null,0]
["Importe de Estudio, Medidas y Elementos de Seguridad",null,null,null,null,0]
["Porcentaje de IVA vigente (10%)",null,null,null,null,{"$f":"SUM(F10:F16)*0.1","v":0}]
["TOTAL PRESUPUESTO (IVA INCLUIDO)",null,null,null,null,{"$f":"SUM(F10:F17)","v":0}]
["Importe de ingreso en efectivo de la comunidad"]
["Número de edificios diferentes con toma de comunidad",null,null,null,null,0,{"$f":"IF(F21<F20,\"F20 DEBE SER >= F19\",\"\")","v":""}]
["Número total de tomas de comunidad a contratar",null,null,null,null,0]
["Número total de viviendas y locales a individualizar",null,null,null,null,0,{"$f":"IF(F23+F24<>F22,\"¡ATENCIÓN! EL NUMERO TOTAL DE MONTANTES NO COINCIDE CON LA DISTRIBUCION POR PUNTOS DE ENTRADA\",\"\")","v":""}]
["Con una sóla entrada de agua:",null,null,null,null,0]
["Con más de una entrada de agua:",null,null,null,null,0]
["Número de contadores de 13 mm. para viviendas o locales",null,null,null,null,0,{"$f":"IF((F25+F26+F27)<>(F23+F24),\"¡ATENCIÓN EL NÚMERO DE CONTADORES DEBE COINCIDIR CON EL NÚMERO DE MONTANTES\",\"\")","v":""}]
["Número de contadores de 15 mm. para viviendas o locales",null,null,null,null,0]
["Número de contadores de 20 mm. para viviendas o locales"]
["NUEVA/S ACOMETIDA/S NECESARIA/S"]
[null,"Nº DE ACOMETIDAS",null,"Ø (MM)"]
[null,null,null,{"$f":"+Tarifas!A28","v":20}]
[null,null,null,{"$f":"+Tarifas!A29","v":25}]
[null,0,null,{"$f":"+Tarifas!A30","v":30}]
[null,0,null,{"$f":"+Tarifas!A31","v":40}]
[null,null,null,50]
[null,null,null,{"$f":"+Tarifas!A33","v":65}]
[null,null,null,{"$f":"+Tarifas!A34","v":80}]
[]
[]
[]
[]
[" "]
[" "," "]
[" "," "]
[" "]

{"sheet":"Analisis","index":1,"n_rows":105,"n_cols":18,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,1,2,9],[1,10,2,10],[85,16,85,17],[86,16,86,17],[89,16,89,17],[79,0,79,6],[76,10,76,12],[77,10,77,12],[78,10,78,12],[60,7,60,9],[1,15,1,17],[35,15,35,17],[80,7,80,9],[81,7,81,9],[77,7,77,9],[78,7,78,9],[76,0,76,6],[57,0,57,6],[61,7,61,9],[62,7,62,9],[77,0,77,6],[78,0,78,6],[80,0,80,6],[81,0,81,6],[90,13,90,15],[91,13,91,15],[79,13,79,15],[90,16,90,17],[84,16,84,17],[87,16,87,17],[88,16,88,17],[78,13,78,15],[60,13,60,15],[61,13,61,15],[74,13,74,15],[86,13,86,15],[76,13,76,15],[77,13,77,15],[94,13,94,15],[98,10,98,12],[96,13,96,15],[97,13,97,15],[103,10,103,12],[89,10,89,12],[104,13,104,15],[46,0,46,15],[84,7,84,9],[82,13,82,15],[83,13,83,15],[62,13,62,15],[56,13,56,15],[57,13,57,15],[75,13,75,15],[103,13,103,15],[84,13,84,15],[87,13,87,15],[88,13,88,15],[89,13,89,15],[80,13,80,15],[81,13,81,15],[55,13,55,15],[90,10,90,12],[84,10,84,12],[87,10,87,12],[88,10,88,12],[59,10,59,12],[81,10,81,12],[82,10,82,12],[83,10,83,12],[79,10,79,12],[80,10,80,12],[60,10,60,12],[75,10,75,12],[61,10,61,12],[96,10,96,12],[97,10,97,12],[94,10,94,12],[104,0,104,6],[104,7,104,9],[87,7,87,9],[88,7,88,9],[89,7,89,9],[90,7,90,9],[96,7,96,9],[97,7,97,9],[92,7,92,9],[95,7,95,9],[103,7,103,9],[94,7,94,9],[98,7,98,9],[101,7,101,9],[104,10,104,12],[91,10,91,12],[101,10,101,12],[103,0,103,6],[88,0,88,6],[95,0,95,6],[100,0,100,6],[96,0,96,6],[97,0,97,6],[98,0,98,6],[99,0,99,6],[101,0,101,6],[94,0,94,6],[89,0,89,6],[75,7,75,9],[76,7,76,9],[62,0,62,6],[75,0,75,6],[51,7,51,9],[83,0,83,6],[84,0,84,6],[90,0,90,6],[91,0,91,6],[87,0,87,6],[85,0,85,6],[62,10,62,12],[74,10,74,12],[51,10,51,12],[58,0,58,6],[59,0,59,6],[60,0,60,6],[58,13,58,15],[59,13,59,15],[52,7,52,9],[54,7,54,9],[52,0,52,6],[24,14,24,17],[28,14,28,17],[35,12,35,14],[50,7,50,9],[48,10,48,12],[48,0,48,6],[49,0,49,6],[50,0,50,6],[50,10,50,12],[36,12,36,14],[36,15,36,17],[49,10,49,12],[48,13,48,15],[49,13,49,15],[50,13,50,15],[48,7,48,9],[49,7,49,9],[0,15,0,17],[19,14,19,17],[4,3,4,16],[7,0,7,17],[18,14,18,17],[9,14,9,16],[1,12,1,14],[2,15,2,17],[35,9,35,11],[9,1,9,10],[11,2,11,10],[11,15,11,16],[31,6,31,17],[16,3,16,10],[21,14,21,17],[16,16,16,17],[32,15,32,16],[25,14,25,17],[20,14,20,17],[33,9,33,11],[33,12,33,14],[14,0,14,17],[26,14,26,17],[32,7,32,8],[101,13,101,15],[55,0,55,6],[36,9,36,11],[93,0,93,6],[93,7,93,9],[93,10,93,12],[56,10,56,12],[57,10,57,12],[58,10,58,12],[57,7,57,9],[100,7,100,9],[100,10,100,12],[100,13,100,15],[95,10,95,12],[95,13,95,15],[99,7,99,9],[99,10,99,12],[98,13,98,15],[82,7,82,9],[83,7,83,9],[79,7,79,9],[36,6,36,8],[56,7,56,9],[82,0,82,6],[32,13,32,14],[39,3,39,8],[56,0,56,6],[55,7,55,9],[55,10,55,12],[51,0,51,6],[52,10,52,12],[54,10,54,12],[51,13,51,15],[52,13,52,15],[54,13,54,15],[36,0,36,5],[2,12,2,14],[99,13,99,15],[85,13,85,15],[93,13,93,15],[85,7,85,9],[33,6,33,8],[34,6,34,8],[34,12,34,14],[35,6,35,8],[23,14,23,17],[58,7,58,9],[59,7,59,9],[85,10,85,12],[91,7,91,9],[86,0,86,6],[86,7,86,9],[86,10,86,12],[61,0,61,6],[74,7,74,9],[32,10,32,11],[34,9,34,11],[33,15,33,17],[34,15,34,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Suministro nº",null,null,{"$f":"Datos!B4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Presupuesto nº",null,null,{"$f":"Datos!C3","v":0}]
[]
[null,null,null,"Análisis de Subvención"]
[]
[]
["DIRECCIÓN DE LA FINCA PRESUPUESTADA"]
[]
["Calle:",{"$f":"IF(Datos!B5<>\"\",Datos!B5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Número:",null,{"$f":"IF(Datos!B6<>\"\",Datos!B6,\"\")","v":""}]
[]
["Población:",null,{"$f":"IF(Datos!D6<>\"\",Datos!D6,\"\")","v":""},null,null,null,null,null,null,null,null,null,"Código Postal:",null,null,{"$f":"IF(Datos!B7<>\"\",Datos!B7,\"\")","v":""}]
[]
[]
["DATOS DEL PRESUPUESTO"]
[]
["INSTALADOR:",null,null,{"$f":"IF(Datos!B8<>\"\",Datos!B8,\"\")","v":""},null,null,null,null,null,null,null,"Nº de viviendas y/o locales",null,null,null,null,{"$f":"+Datos!F22","v":0}]
[]
["IMPORTE DEL PRESUPUESTO (10% IVA incluido)....................................",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Datos!F18","v":0}]
[{"$f":"IF(SUM(Datos!B30:C36)<=1,\"IMPORTE DE LA NUEVA ACOMETIDA DE AGUA...................................................................\",\"IMPORTE DE LAS NUEVAS ACOMETIDAS DE AGUA.......................................\")","v":"IMPORTE DE LA NUEVA ACOMETIDA DE AGUA..................................................................."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(+N102>0,N102,\"\")","v":""}]
["IMPORTE CUOTAS DE CONTRATACIÓN Y FIANZAS..............................................",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N82","v":0}]
[null,null,"TOTAL..............................................................................................................",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O20=\"\",O19+O21,O20+O19+O21)","v":0}]
[]
["SUBVENCIÓN EMASESA............................................................................................",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-Analisis!N60","v":0}]
[{"$f":"IF(SUM(Datos!B30:C36)<=1,\"BONIFICACIÓN ACOMETIDA.........................................................................................\",\"BONIFICACIÓN ACOMETIDAS.................................................................................\")","v":"BONIFICACIÓN ACOMETIDA........................................................................................."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O20<>\"\",-O20,\"\")","v":""}]
["BONIFICACIÓN EN CUOTAS DE CONTRATACIÓN Y FIANZAS............................",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-Analisis!N92","v":0}]
[null,null,"TOTAL AYUDAS EXTRAORDINARIAS PLAN CINCO...........................................................................",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O25=\"\",O24+O26,O26+O24+O25)","v":0}]
[]
[" ",null,"IMPORTE NETO............................................................................................",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+O22+O27","v":0}]
[]
["Análisis supuesto pago en efectivo:"]
[null,null,null,null,null,null,"Distribución en función de los tipos de viviendas"]
[null,null,null,null,null,null,{"$f":"IF(Datos!$F$25>0,Datos!F$25,\"\")","v":""},{"$f":"IF(G33<>\"\",\"de 13 mm.\",\"\")","v":""},null,{"$f":"IF(Datos!$F$26>0,Datos!F$26,\"\")","v":""},{"$f":"IF(J33<>\"\",\"de 15 mm.\",\"\")","v":""},null,{"$f":"IF(Datos!$F$27>0,Datos!F$27,\"\")","v":""},{"$f":"IF(M33<>\"\",\"de 20 mm.\",\"\")","v":""},null,{"$f":"IF(Datos!F21>=1,\"Comunidad\",\"\")","v":""},null,{"$f":"IF(Datos!F21>0,Datos!F21,\"\")","v":""}]
["Importe neto por comunero.................",null,null,null,null,null,{"$f":"IF(Datos!F25>=1,($O$19-Datos!F19+$O$24)/Datos!$F$22,\"\")","v":""},null,null,{"$f":"IF(Datos!F26>=1,($O$19-Datos!F19+$O$24)/Datos!$F$22,\"\")","v":""},null,null,{"$f":"IF(Datos!F27>=1,($O$19-Datos!F19+$O$24)/Datos!$F$22,\"\")","v":""},null,null,{"$f":"IF(Datos!F19>0,Datos!F19,\"\")","v":""}]
["Cuota de Contratación (*)...........................",null,null,null,null,null,{"$f":"IF(Datos!F25>=1,Tarifas!K4,\"\")","v":""},null,null,{"$f":"IF(Datos!F26>=1,Tarifas!K6,\"\")","v":""},null,null,{"$f":"IF(Datos!F27>=1,Tarifas!K7,\"\")","v":""},null,null,{"$f":"IF(AND(Datos!F20=Datos!F21,Datos!F20=1),\"Bonificada\",IF(AND(Datos!F20<Datos!F21,Datos!F20>1),CONCATENATE(TEXT(Datos!F20,0),\" Bonificadas\"),IF(AND(Datos!F20<Datos!F21,Datos!F20=1),CONCATENATE(TEXT(Datos!F20,0),\" Bonificada\"),IF(AND(Datos!F20=Datos!F21,Datos!F20>1),\"Bonificadas\",IF(Q85>0,Q85,\"\")))))","v":""}]
["Fianza según tipo (*)....................................",null,null,null,null,null,{"$f":"IF(Datos!F25>=1,Tarifas!K16,\"\")","v":""},null,null,{"$f":"IF(Datos!F26>=1,Tarifas!K18,\"\")","v":""},null,null,{"$f":"IF(Datos!F27>=1,Tarifas!K19,\"\")","v":""},null,null,{"$f":"IF(Datos!F21<1,\"\",Q88)","v":""}]
["TOTAL EFECTIVO POR COMUNERO",null,null,null,null,null,{"$f":"IF(Datos!F25>0,+G36+G35+G34,\"\")","v":""},null,null,{"$f":"IF(Datos!F26>0,+J36+J35+J34,\"\")","v":""},null,null,{"$f":"IF(Datos!F27>0,+M36+M35+M34,\"\")","v":""},null,null,{"$f":"IF(Datos!F21>=1,+Q85+Q88+Datos!F19,\"\")","v":""}]
[]
[]
[null,null,null,{"$f":"+Analisis!A105","v":"2017-06-14T07:19:16.890"}]
[]
["(*) Los precios de Cuotas de Contratación, Fianzas e importes de subvención son los previstos para el año 2017"]
["(*) Esta información es orientativa hasta su aprobación definitiva por EMASESA."]
[]
[]
[]
["DETALLE DE LA SUBVENCIÓN DE EMASESA"]
[]
["Concepto",null,null,null,null,null,null,"Año 2017"]
["Subvención base",null,null,null,null,null,null,122]
["Con grupo de presión",null,null,null,null,null,null,40]
["Con más de un punto de entrada",null,null,null,null,null,null,60]
["Con proyecto",null,null,null,null,null,null,3]
[]
[null,null,null,null,null,null,null,"Unidades",null,null,"Importe",null,null,"Subvención"]
["Subvención base",null,null,null,null,null,null,{"$f":"+Datos!F22","v":0},null,null,{"$f":"+H50","v":122},null,null,{"$f":"+H56*K56","v":0}]
["Con grupo de presión",null,null,null,null,null,null,{"$f":"IF(Datos!F12>0,Datos!F22,0)","v":0},null,null,{"$f":"+H51","v":40},null,null,{"$f":"+H57*K57","v":0}]
["Con más de un punto de entrada",null,null,null,null,null,null,{"$f":"IF(Datos!F24>0,Datos!F24,0)","v":0},null,null,{"$f":"+H52","v":60},null,null,{"$f":"+H58*K58","v":0}]
["Con proyecto",null,null,null,null,null,null,{"$f":"IF(Datos!F14>0,Datos!F22,0)","v":0},null,null,{"$f":"+H53","v":3},null,null,{"$f":"+H59*K59","v":0}]
["SUMA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N56:N59)","v":0}]
["Importe acometida",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N102","v":0}]
["Importe Bonificación Contratación",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N92","v":0}]
["TOTAL SUBVENCIÓN",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N60:N62)","v":0}]
[]
[]
["Con la entrada en vigor de la nueva forma de facturación por habitantes, el  Consejo de Administración"]
["de EMASESA, a propuesta de la Comisión para Sostenibilidad y Equilibrio, aprobó paralelamente"]
["adoptar una nueva medida,  la cual ha sido debidamente recogida en la Ordenanza de"]
["Abastecimiento para 2017. Dicha medida es:"]
[]
[null,"1.","Eximir de la cuota de contratación a todos aquellos contratos que se generen como "]
[null,null,"consecuencia del paso de contador general a individual (art. 12.2)"]
[]
[]
[]
["DERECHOS COMPLETOS"]
["CONTRATACIÓN 13 MM.",null,null,null,null,null,null,{"$f":"+Datos!F25","v":0},null,null,{"$f":"Tarifas!F4","v":127.89099999999999},null,null,{"$f":"+H77*K77","v":0}]
["CONTRATACIÓN 15 MM.",null,null,null,null,null,null,{"$f":"+Datos!F26","v":0},null,null,{"$f":"Tarifas!F6","v":127.89099999999999},null,null,{"$f":"+H78*K78","v":0}]
["CONTRATACIÓN 20 MM.",null,null,null,null,null,null,{"$f":"+Datos!F27","v":0},null,null,{"$f":"Tarifas!F7","v":180.04599999999999},null,null,{"$f":"+H79*K79","v":0}]
["C.C. COMUNIDAD",null,null,null,null,null,null,{"$f":"IF(Datos!F21>=1,Datos!F21,0)","v":0},null,null,{"$f":"Tarifas!D5","v":57.6},null,null,{"$f":"+K80*H80","v":0},null,null," "]
["FIANZA COMUNIDAD",null,null,null,null,null,null,{"$f":"IF(Datos!F21>=1,Datos!F21,0)","v":0},null,null,{"$f":"Tarifas!D17","v":70.290999999999997},null,null,{"$f":"+K81*H81","v":0}]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N77:N81)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,","]
["SUBVENCION CONTRATACIÓN Y FIANZA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contratación Comunidad, más de una toma)"]
["C.C. COMUNIDAD",null,null,null,null,null,null,{"$f":"IF(Datos!F20>=1,Datos!F20,0)","v":0},null,null,{"$f":"Tarifas!D4-Tarifas!K5","v":57.6},null,null,{"$f":"+K85*H85","v":0},null,null,0]
["C.C. DE 13 MM",null,null,null,null,null,null,{"$f":"Datos!F25","v":0},null,null,{"$f":"Tarifas!D4-Tarifas!K4","v":57.6},null,null,{"$f":"+K86*H86","v":0},null,null,0]
["C.C. DE 15 MM",null,null,null,null,null,null,{"$f":"Datos!F26","v":0},null,null,{"$f":"Tarifas!D6-Tarifas!K6","v":57.6},null,null,{"$f":"+K87*H87","v":0},null,null,0]
["FIANZA COMUNIDAD",null,null,null,null,null,null,{"$f":"IF(Datos!F20>=1,Datos!F20,0)","v":0},null,null,{"$f":"Tarifas!D17-Tarifas!K17","v":67.280999999999992},null,null,0,null,null,3.01]
["FIANZAS DE 13 MM.",null,null,null,null,null,null,{"$f":"IF(Datos!F25>=1,Datos!F25,0)","v":0},null,null,{"$f":"Tarifas!D16-Tarifas!K16","v":67.280999999999992},null,null,0,null,null,3.01]
["FIANZAS DE 15 MM.",null,null,null,null,null,null,{"$f":"IF(Datos!F26>=1,Datos!F26,0)","v":0},null,null,{"$f":"Tarifas!D18-Tarifas!K18","v":67.280999999999992},null,null,0,null,null,3.01]
["FIANZAS DE 20 MM.",null,null,null,null,null,null,{"$f":"IF(Datos!F27>=1,Datos!F27,0)","v":0},null,null,{"$f":"Tarifas!D19-Tarifas!K19","v":88.935999999999993},null,null,0,null,null,3.01]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N85:P91)","v":0}]
[]
["SUBVENCION ACOMETIDAS"]
["ACOMETIDAS DE 20 MM",null,null,null,null,null,null,{"$f":"+Datos!B30","v":0},null,null,{"$f":"+Tarifas!D28","v":535.47},null,null,{"$f":"+K95*H95","v":0}]
["ACOMETIDAS DE 25 MM",null,null,null,null,null,null,{"$f":"+Datos!B31","v":0},null,null,{"$f":"+Tarifas!D29","v":669.33999999999992},null,null,0]
["ACOMETIDAS DE 30 MM",null,null,null,null,null,null,{"$f":"+Datos!B32","v":0},null,null,{"$f":"+Tarifas!D30","v":803.19999999999993},null,null,0]
["ACOMETIDAS DE 40 MM",null,null,null,null,null,null,{"$f":"+Datos!B33","v":0},null,null,{"$f":"+Tarifas!D31","v":1070.93},null,null,0]
["ACOMETIDAS DE 50 MM",null,null,null,null,null,null,{"$f":"+Datos!B34","v":0},null,null,{"$f":"+Tarifas!D32","v":1338.6699999999998},null,null,0]
["ACOMETIDAS DE 65 MM",null,null,null,null,null,null,{"$f":"+Datos!B35","v":0},null,null,{"$f":"+Tarifas!D33","v":1740.27},null,null,0]
["ACOMETIDAS DE 80 MM",null,null,null,null,null,null,{"$f":"+Datos!B36","v":0},null,null,{"$f":"+Tarifas!D34","v":2141.87},null,null,0]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N95:N101)","v":0}]
[]
["FECHA"]
[{"$f":"+NOW()","v":"2017-06-14T07:19:16.890"}]

{"sheet":"Tarifas","index":2,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,0,24,11],[25,0,25,3],[25,7,25,10],[0,0,0,10],[1,0,1,3],[1,7,1,10],[12,0,12,10],[13,0,13,3],[13,7,13,10]]}
["CUOTAS DE CONTRATACIÓN"]
["EMASESA",null,null,null,null,"Derechos ",null,"PLAN CINCO",null,null,null,"Derechos "]
["Calibre","Importe","IVA ","Total",null,"Completos",null,"Calibre","Importe","IVA ","Total","Completos"]
[13,47.6,{"$f":"ROUND(+B4*21%,2)","v":10},{"$f":"+C4+B4","v":57.6},null,{"$f":"+D4+D16","v":127.89099999999999},null,13,0,0,0,{"$f":"+K4+K16","v":3.01}]
["Comunidad",47.6,{"$f":"ROUND(+B5*21%,2)","v":10},{"$f":"+C5+B5","v":57.6},null,{"$f":"+D5+D17","v":127.89099999999999},null,"Comunidad",0,0,0,{"$f":"+K5+K17","v":3.01}]
[15,47.6,10,57.6,null,{"$f":"+D6+D18","v":127.89099999999999},null,15,0,0,0,3.01]
[20,72.81,15.29,88.1,null,180.04599999999999,null,20,0,0,0,3.01]
[25,94.98,19.95,114.93,null,268.05100000000004,null,25,0,0,0,0]
[30,117.14,24.6,141.74,null,331.15,null,30,0,0,0,0]
[40,161.47,33.909999999999997,195.38,null,495.26600000000002,null,40,0,0,0,0]
[50,205.81,43.22,249.03,null,{"$f":"+D11+D23","v":1043.729},null,50,0,0,0,0]
[]
["FIANZAS"]
["EMASESA",null,null,null,null," ",null,"PLAN CINCO",null,null,null,null,null,null," "]
["Calibre",null,null,"Total",null," ",null,"Calibre",null,null,"Total","Diferencia"]
[13,null,null,70.290999999999997,null,null,null,13,null,null,3.01,{"$f":"+D16-K16","v":67.280999999999992}]
["Comunidad",null,null,70.290999999999997,null,null,null,"Comunidad",null,null,3.01,{"$f":"+D17-K17","v":67.280999999999992}]
[15,null,null,70.290999999999997,null,null,null,15,null,null,3.01,{"$f":"+D18-K18","v":67.280999999999992}]
[20,null,null,91.945999999999998,null,null,null,20,null,null,3.01,{"$f":"+D19-K19","v":88.935999999999993}]
[25,null,null,153.12100000000001,null,null,null,25]
[30,null,null,189.41,null,null,null,30]
[40,null,null,299.88600000000002,null,null,null,40]
[50,null,null,794.69899999999996,null,null,null,50]
[]
["PARÁMETROS A DE ACOMETIDAS"]
["EMASESA",null,null,null,null,null,null,"PLAN CINCO"]
["Calibre","Importe","IVA ","Total",null,null,null,"Calibre","Importe","IVA ","Total"]
[20,442.54,{"$f":"ROUND(+B28*21%,2)","v":92.93},{"$f":"SUM(B28:C28)","v":535.47},1,null,null,20,0,0,0]
[25,553.16999999999996,{"$f":"ROUND(+B29*21%,2)","v":116.17},{"$f":"SUM(B29:C29)","v":669.33999999999992},2,null,null,25,0,0,0," "]
[30,663.8,139.4,803.19999999999993,3,null,null,30,0,0,0," "]
[40,885.07,{"$f":"ROUND(+B31*21%,2)","v":185.86},1070.93,4,null,null,40,0,0,0," "]
[50,1106.3399999999999,232.33,1338.6699999999998,5,null,null,50,0,0,0]
[65,1438.24,302.02999999999997,1740.27,6,null,null,65,0,0,0]
[80,1770.14,371.73,2141.87,7,null,null,80,0,0,0]