{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hoja de vida poliza RCCH","RATING TOOL RCCH","Historico"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":18,"comments":2,"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":"Hoja de vida poliza RCCH","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[8,2,8,5],[3,1,3,5],[4,1,4,5],[5,2,5,3],[6,2,6,3],[7,2,7,5],[19,2,19,3],[19,4,19,5],[9,2,9,5],[10,2,10,4],[11,2,11,4],[12,2,12,3],[12,4,13,4],[13,2,13,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[17,4,18,5],[18,2,18,3],[20,2,20,3],[20,4,20,5],[21,2,21,3],[21,4,21,5],[22,2,22,3],[22,4,22,5],[43,1,43,5],[23,2,23,3],[23,4,23,5],[24,2,24,3],[27,2,27,3],[28,1,28,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[55,1,55,5],[44,1,44,5],[45,1,45,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[62,1,62,5],[63,1,63,5],[64,1,64,5],[65,1,65,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[61,1,61,5]]}
[]
[]
[]
[null,"HOJA DE VIDA POLIZA CASUALTY & LF",null,null,null,null,null,null,"SI"]
[null,{"$f":"+IF(C23>0,\"CUENTA FACULTATIVA \",\"CUENTA EN CONTRATOS\")","v":"CUENTA EN CONTRATOS"},null,null,null,null,null,null,"NO"]
[null,"FECHA:","2017-12-06",null,"SUSCRIPTOR","LILIANA PEREA"]
[null,"RAMO / PRODUCTO","RCCH",null,"NO. DE POLIZA",22027503]
[null,"TOMADOR","MEDILASER",null,null,null,null,null,"NO"]
[null,"ASEGURADO","MEDILASER",null,null,null,null,null,"Industria Química"]
[null,"ACTIVIDAD","PRESTACIÓN DE SERVICIOS MÉDICOS",null,null,null,null,null,"Industria Farmacéutica"]
[null,"VIGENCIA","2017-2018",null,null,"COASEGURADORES",null,null,"Proveedores de Partes para Automóviles"]
[null,"MQES ?","NO",null,null,null,null,null,"Cobertura Anual para Construcción"]
[null,"PRIMA ANTES DE IVA (Opcional)",null,null,null,null,null,null,"Telecomunicacion"]
[null,"COMISION BROKER (Opcional)",0.15]
[]
[null,"DATOS DEL SEGURO"]
[null,"Participación AZ Colombia",1]
[null,"Limite Asegurado Dólares",null,null,{"$f":"+IF(AND(ISBLANK(C18)=FALSE,ISBLANK(C19)=FALSE),\"UNA DE LAS 2 CELDAS DEBE ESTAR VACIA\",\"\")","v":""}]
[null,"Limite Asegurado Pesos",6000000000]
[null,"DATOS DEL REASEGURO",null,null,"REASEGURADORES"]
[null,"TRM USD",2996.53]
[null,"TRM EU",3565.45]
[null,"Limite reasegurado"]
[null,"% Retención AZ Colombia"]
[null,"% Reaseguro FAC  con cias no AZ:",null,null,"CIFRAS EN EUROS","RESULTADO VALIDACION"]
[null,"Limite Asegurado en pesos",null,{"$f":"+C18*C21","v":0},{"$f":"+D26/$C$22","v":0},null,null,null,"Servicios Públicos (agua, gas, etc)"]
[null,"Limite Asegurado a comparar convertido a pesos",null,{"$f":"+IF(ISBLANK(C19)=TRUE,D26,C19)","v":6000000000},{"$f":"+D27/$C$22","v":1682817.0357177916}]
[null,"Limite Total de Participación AZ Colombia",{"$f":"+D27*C17","v":6000000000},null,{"$f":"+C28/$C$22","v":1682817.0357177916},{"$f":"+IF(C28>10000000000,\"LIMITE FUERA DE CONTRATOS\",\"\")","v":""}]
[null,"VALIDACION"]
[null,"Exposición Bruta? GUE > EU 250M ?",{"$f":"+IF(D27*C17>C22*250000000,\"SI\",\"NO\")","v":"NO"},{"$f":"+C28*C17","v":6000000000},{"$f":"+D30/$C$22","v":1682817.0357177916},{"$f":"+IF(C30=\"SI\",\"REPORTAR A LA BD DE ALLIANZ ANTES DE COTIZAR\",\"\")","v":""}]
[null,"Exposición Bruta? GUL (Local) > $36,000,000,000 ?",{"$f":"+IF(C28>36000000000,\"SI\",\"NO\")","v":"NO"},{"$f":"+C28","v":6000000000},{"$f":"+D31/$C$22","v":1682817.0357177916},{"$f":"+IF(C31=\"SI\",\"REPORTAR A CUO Y COMITE LOCAL ANTES DE COTIZAR \",\"\")","v":""}]
[null,"Reaseguro Facultativo a Cias no AZ > EU 50M?",{"$f":"+IF(C23*C25>C22*50000000,\"SI\",\"NO\")","v":"NO"},{"$f":"+C23*C25*C21","v":0},{"$f":"+D32/$C$22","v":0},{"$f":"+IF(C32=\"SI\",\"REPORTAR A LA BD DE ALLIANZ ANTES DE COTIZAR\",\"\")","v":""}]
[null,"Reaseguro Facultativo a Cias no AZ > 90%?",{"$f":"+IF(C25>90%,\"SI\",\"NO\")","v":"NO"},{"$f":"+C23*C25*C21","v":0},{"$f":"+D33/$C$22","v":0},{"$f":"+IF(C33=\"SI\",\"REPORTAR A LA BD DE ALLIANZ ANTES DE COTIZAR\",\"\")","v":""}]
[null,"Reaseguro Facultativo dentro de security list?",null,null,null,{"$f":"+IF(C34=\"NO\",\"REPORTAR A CUO Y COMITE LOCAL ANTES DE COTIZAR \",\"\")","v":""}]
[]
[null,"* Diligencie los campos en este color"]
[]
[null,"NOTAS DEL SUSCRIPTOR"]

{"sheet":"RATING TOOL RCCH","index":1,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[[39,1,45,3],[3,1,3,3],[5,2,5,3],[30,1,30,3],[32,1,32,2],[35,1,35,2],[15,1,15,3],[10,1,10,3],[24,1,24,2],[25,1,25,2],[27,1,27,2],[28,1,28,2]]}
[]
[]
[]
[null,"RATING TOOL RCCH V1/2013                   RCCH (MEDMAL)"]
[null,null,null,null,null,"PROCESO DE TARIFACIÓN.","CALCULO"]
[null,"NOMBRE RIESGO:","MEDILASER"]
[null,"VIGENCIA","2017-2018"]
[null,"LIMITE (millones $)",1500,null,null,"Se carga el límite de cotización requerido en millones"]
[null,"CAMAS",{"$f":"10+142+133","v":285},null,null,"Se carga el numero de camas"]
[null,"PRIMA PLO",null,{"$f":"IF(C9<=60,60*C68,C9*C68)","v":12682500},null,"Se calcula la prima PLO usando el valor registrado en la celda PLO Básica de la tabla PLO","SI(C6<=60;60*C37;C6*C37)"]
[null,"GRUPO A (MEDICOS VINCULADOS LABORALMENTE)"]
[null,"CATEGORIA I: ANESTESIOLOGOS, GINECOLOGOS,  GINECOBSTETRAS",{"$f":"0+0+0","v":0},{"$f":"F68*C12","v":0},null,"Se carga la cantidad de medicos del grupo A de la categoria I y se usa esta cifra para calcular la prima usando el valor registrado en la celda PLO Básica de la tabla medicos cat 1","F37*C9"]
[null,"CATEGORIA II: ESPECIALISTAS EN CIRUGIA, UROLOGIA, OFTALMOLOGIA, RADIOLOGIA",{"$f":"18+0+0","v":18},{"$f":"I68*C13","v":15130800},null,"Se carga la cantidad de medicos del grupo A de la categoria II y se usa esta cifra para calcular la prima usando el valor registrado en la celda PLO Básica de la tabla medicos cat 2","L37*C10"]
[null,"CATEGORIA III: DEMAS MEDICOS",{"$f":"67+0+0","v":67},{"$f":"L68*C14","v":35664100},null,"Se carga la cantidad de medicos del grupo A de la categoria III y se usa esta cifra para calcular la prima usando el valor registrado en la celda PLO Básica de la tabla medicos cat 3","L38*C11"]
[null,"CATEGORIA IV:ODONTOLOGOS, ORTODONCISTAS",{"$f":"0+0+0","v":0},{"$f":"O68*C15","v":0},null,"Se carga la cantidad de medicos del grupo A de la categoria IV y se usa esta cifra para calcular la prima usando el valor registrado en la celda PLO Básica de la tabla medicos cat 4","L39*C12"]
[null,"GRUPO B (MEDICOS VINCULADOS MEDIANTE CONTRATO DE PRESTACION DE SERVICIOS O AUTORIZADO PARA TRABAJAR EN INSTALACIONES)"]
[null,"CATEGORIA I: ANESTESIOLOGOS, GINECOLOGOS,  GINECOBSTETRAS",{"$f":"0+43+1","v":44},{"$f":"0.6*F68*C17","v":29066400},null,"Se carga la cantidad de medicos del grupo A de la categoria I y se usa esta cifra para calcular la prima usando el 60% del valor registrado en la celda PLO Básica de la tabla medicos cat 1","0,6*F37*C14"]
[null,"CATEGORIA II: ESPECIALISTAS EN CIRUGIA, UROLOGIA, OFTALMOLOGIA, RADIOLOGIA",{"$f":"0+52+1","v":53},{"$f":"0.6*I68*C18","v":26731080},null,"Se carga la cantidad de medicos del grupo A de la categoria II y se usa esta cifra para calcular la prima usando el 60% del valor registrado en la celda PLO Básica de la tabla medicos cat 2","0,6*L37*C15"]
[null,"CATEGORIA III: DEMAS MEDICOS",{"$f":"0+184+3","v":187},{"$f":"0.6*L68*C19","v":59724060},null,"Se carga la cantidad de medicos del grupo A de la categoria III y se usa esta cifra para calcular la prima usando el 60% del valor registrado en la celda PLO Básica de la tabla medicos cat 3","0,6*O37*C16"]
[null,"CATEGORIA IV:ODONTOLOGOS, ORTODONCISTAS",{"$f":"0+0+0","v":0},{"$f":"0.6*O68*C20","v":0},null,"Se carga la cantidad de medicos del grupo A de la categoria IV y se usa esta cifra para calcular la prima usando el 60% del valor registrado en la celda PLO Básica de la tabla medicos cat 4","0,6*R37*C17"]
[null,"PRIMA MEDICOS",null,{"$f":"SUM(D12:D20)","v":166316440},null,"Se suma la prima de medicos GRUPO A + GRUPO B","D9+D10+D11+D12+D14+D15+D16+D17"]
[null,"PRIMA BASE (PLO)",null,{"$f":"D21+D10","v":178998940},null,"se suma la prima de medicos + la prima PLO","D18+D7"]
[null,"PRIMA TOTAL","ColP$:",{"$f":"IF(C8<=100,IF(SUM(D10:D20)>250000*C8,250000*C8,SUM(D10:D20)),IF(C8<=200,IF(SUM(D10:D20)>175000*C8,175000*C8,SUM(D10:D20)),IF(SUM(D10:D20)>150000*C8,150000*C8,SUM(D10:D20))))","v":178998940}]
[]
[null,"Siniestralidad:",null,1.2,null,{"$f":"+E25","v":0}]
[null,"Opinión del Suscriptor:",null,1.5,null,{"$f":"+E26","v":0}]
[]
[null,"Prima Ajustada RCCH (Ocurrencia 2 años Sunset):",null,{"$f":"+(D23*D26)*(D25)","v":322198092}]
[null,"Payback PLO en años:",null,{"$f":"+(C8*1000000)/D28","v":4.6555210513164678}]
[]
[null,"TARIFACION ADICIONAL CLAIMS MADE"]
[]
[null,"Años de retroactividad"]
[null,"Recargo adicional por cada año de retroactividad",null,0.125]
[]
[null,"Prima total modalidad CLAIMS MADE",null,{"$f":"+D28*(1+($D$34*$D$33))","v":322198092},null,{"$f":"+#REF!*(1+(#REF!*#REF!))","v":{"$error":"#REF!"}},{"$f":"+#REF!*(1+(#REF!*#REF!))","v":{"$error":"#REF!"}}]
[]
[]
[null,"OPINION DEL SUSCRIPTOR"]
[null,"En la vigencia se presentaron tres eventos por los cuales se aperturaron reservas por $5,380,222, sin generar pagos así mismo la planta de médicos aumento en un 17% (53 médicos frente al año anerior), por lo tanto se ajusta la prima en $3Mill, es decir $383MIll para el límie de $3,000Mill. Adicionalmente se cotiza límite de $4,000Mill - Prima$555Mill y límite de $6,000Mill - Prima$650Mill"]
[]
[]
[]
[]
[]
[]
[]
[null,"Nota: Tarificador solo para Sumas aseguradas entre ColP$20 y ColP$1.500 mio."]
[null,"Diligenica los campos en este color"]
[]
[]
[]
[null,"SI(Y($C$5<=B36;$C$5>=B35);((C36-C35)/(B36-B35))*($C$5-B35)+C35"]
[]
[]
[null,"Tabla PLO",null,null,"Tabla Medicos cat 1",null,null,"Tabla Medicos cat 2",null,null,"Tabla Medicos cat 3",null,null,"Tabla Medicos cat 4"]
[null,"limite","prima",null,"limite","prima",null,"limite","prima",null,"limite","prima",null,"limite","prima"]
[null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[null,10,5000,null,10,{"$f":"0.5*247000","v":123500},null,10,{"$f":"0.5*177000","v":88500},null,10,{"$f":"0.5*116000","v":58000},null,10,{"$f":"0.5*82000","v":41000}]
[null,20,6400,null,20,{"$f":"0.5*321000","v":160500},null,20,{"$f":"0.5*231000","v":115500},null,20,{"$f":"0.5*152000","v":76000},null,20,{"$f":"0.5*108000","v":54000}]
[null,30,7400,null,30,{"$f":"0.5*370000","v":185000},null,30,{"$f":"0.5*264000","v":132000},null,30,{"$f":"0.5*176000","v":88000},null,30,{"$f":"0.5*124000","v":62000}]
[null,50,8800,null,50,{"$f":"0.5*445000","v":222500},null,50,{"$f":"0.5*321000","v":160500},null,50,{"$f":"0.5*211000","v":105500},null,50,{"$f":"0.5*150000","v":75000}]
[null,100,11900,null,100,300000,null,100,220000,null,100,143000,null,100,101500]
[null,200,16000,null,200,407000,null,200,302500,null,200,192500,null,200,137500]
[null,500,27000,null,500,660000,null,500,511500,null,500,327500,null,500,236500]
[null,1000,36500,null,1000,890000,null,1000,690000,null,1000,442500,null,1000,320000]
[null,1500,{"$f":"+C66+8000","v":44500},null,1500,1101000,null,1500,840600,null,1500,532300,null,1500,14300]
[null,"PLO Básica",{"$f":"IF(AND($C$8<=B61,$C$8>=B60),((C61-C60)/(B61-B60))*($C$8-B60)+C60,IF(AND($C$8<=B62,$C$8>=B61),((C62-C61)/(B62-B61))*($C$8-B61)+C61,IF(AND($C$8<=B63,$C$8>=B62),((C63-C62)/(B63-B62))*($C$8-B62)+C62,IF(AND($C$8<=B64,$C$8>=B63),((C64-C63)/(B64-B63))*($C$8-B63)+C63,IF(AND($C$8<=B65,$C$8>=B64),((C65-C64)/(B65-B64))*($C$8-B64)+C64,IF(AND($C$8<=B66,$C$8>=B65),((C66-C65)/(B66-B65))*($C$8-B65)+C65,IF(AND($C$8<=B67,$C$8>=B66),((C67-C66)/(B67-B66))*($C$8-B66)+C66,0)))))))","v":44500},null,"PLO Básica",{"$f":"IF(AND($C$8<=E61,$C$8>=E60),((F61-F60)/(E61-E60))*($C$8-E60)+F60,IF(AND($C$8<=E62,$C$8>=E61),((F62-F61)/(E62-E61))*($C$8-E61)+F61,IF(AND($C$8<=E63,$C$8>=E62),((F63-F62)/(E63-E62))*($C$8-E62)+F62,IF(AND($C$8<=E64,$C$8>=E63),((F64-F63)/(E64-E63))*($C$8-E63)+F63,IF(AND($C$8<=E65,$C$8>=E64),((F65-F64)/(E65-E64))*($C$8-E64)+F64,IF(AND($C$8<=E66,$C$8>=E65),((F66-F65)/(E66-E65))*($C$8-E65)+F65,IF(AND($C$8<=E67,$C$8>=E66),((F67-F66)/(E67-E66))*($C$8-E66)+F66,0)))))))","v":1101000},null,"PLO Básica",{"$f":"IF(AND($C$8<=H61,$C$8>=H60),((I61-I60)/(H61-H60))*($C$8-H60)+I60,IF(AND($C$8<=H62,$C$8>=H61),((I62-I61)/(H62-H61))*($C$8-H61)+I61,IF(AND($C$8<=H63,$C$8>=H62),((I63-I62)/(H63-H62))*($C$8-H62)+I62,IF(AND($C$8<=H64,$C$8>=H63),((I64-I63)/(H64-H63))*($C$8-H63)+I63,IF(AND($C$8<=H65,$C$8>=H64),((I65-I64)/(H65-H64))*($C$8-H64)+I64,IF(AND($C$8<=H66,$C$8>=H65),((I66-I65)/(H66-H65))*($C$8-H65)+I65,IF(AND($C$8<=H67,$C$8>=H66),((I67-I66)/(H67-H66))*($C$8-H66)+I66,0)))))))","v":840600},null,"PLO Básica",{"$f":"IF(AND($C$8<=K61,$C$8>=K60),((L61-L60)/(K61-K60))*($C$8-K60)+L60,IF(AND($C$8<=K62,$C$8>=K61),((L62-L61)/(K62-K61))*($C$8-K61)+L61,IF(AND($C$8<=K63,$C$8>=K62),((L63-L62)/(K63-K62))*($C$8-K62)+L62,IF(AND($C$8<=K64,$C$8>=K63),((L64-L63)/(K64-K63))*($C$8-K63)+L63,IF(AND($C$8<=K65,$C$8>=K64),((L65-L64)/(K65-K64))*($C$8-K64)+L64,IF(AND($C$8<=K66,$C$8>=K65),((L66-L65)/(K66-K65))*($C$8-K65)+L65,IF(AND($C$8<=K67,$C$8>=K66),((L67-L66)/(K67-K66))*($C$8-K66)+L66,0)))))))","v":532300},null,"PLO Básica",{"$f":"IF(AND($C$8<=N61,$C$8>=N60),((O61-O60)/(N61-N60))*($C$8-N60)+O60,IF(AND($C$8<=N62,$C$8>=N61),((O62-O61)/(N62-N61))*($C$8-N61)+O61,IF(AND($C$8<=N63,$C$8>=N62),((O63-O62)/(N63-N62))*($C$8-N62)+O62,IF(AND($C$8<=N64,$C$8>=N63),((O64-O63)/(N64-N63))*($C$8-N63)+O63,IF(AND($C$8<=N65,$C$8>=N64),((O65-O64)/(N65-N64))*($C$8-N64)+O64,IF(AND($C$8<=N66,$C$8>=N65),((O66-O65)/(N66-N65))*($C$8-N65)+O65,IF(AND($C$8<=N67,$C$8>=N66),((O67-O66)/(N67-N66))*($C$8-N66)+O66,0)))))))","v":14300}]

{"sheet":"Historico","index":2,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,16,5,16],[1,0,1,16],[4,6,4,8],[4,9,5,9],[4,10,5,10],[4,11,4,13],[4,14,5,14],[4,15,5,15],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5]]}
[]
[{"$f":"+'Hoja de vida poliza RCCH'!C9:F9","v":{"$error":"#VALUE!"}}]
[]
[]
["Año","Vigenica","No. de póliza","Prima","% VAR","Limite","Medicos",null,null,"% VAR","Modalidad","Siniestros","ptes","Stros totales","Siniest. del año","Siniest. acumulada","Siniest. Pagada acumulada"]
[null,null,null,null,null,null,"A","B","TOTAL",null,null,"pagados","pendientes","totales"]
[1,"2015-2016",21880057,380000000,0,3000000000,291,187,{"$f":"SUM(G7:H7)","v":478},0,"SUNSET 2 AÑOS",0,3040111,{"$f":"SUM(L7:M7)","v":3040111},{"$f":"+N7/D7","v":8.0002921052631584E-3},{"$f":"+N7/$D$7","v":8.0002921052631584E-3},{"$f":"+L7/$D$7","v":0}]
[2,"2016-2017",22027503,280000000,{"$f":"+D8/D7-1","v":-0.26315789473684215},3000000000,{"$f":"9+13+67+5+5","v":99},{"$f":"1+1+3+20+27+59+106","v":217},316,{"$f":"+I8/I7-1","v":-0.33891213389121344},"SUNSET 2 AÑOS",0,5380222,5380222,{"$f":"+N8/D8","v":1.9215078571428571E-2},{"$f":"+SUM(N7:N8)/SUM($D$7:$D$8)","v":1.2758080303030304E-2},{"$f":"+SUM(L7:L8)/SUM($D$7:$D$8)","v":0}]
[3,"2017-2018",null,null,{"$f":"+D9/D8-1","v":-1},null,{"$f":"85+0+0","v":85},284,369,{"$f":"+I9/I8-1","v":0.16772151898734178},"SUNSET 2 AÑOS",null,null,0,{"$error":"#DIV/0!"},{"$f":"+SUM(N7:N9)/SUM($D$7:$D$9)","v":1.2758080303030304E-2},{"$f":"+SUM(L7:L9)/SUM($D$7:$D$9)","v":0}]
[4,null,null,null,{"$error":"#DIV/0!"},null,null,null,0,-1,null,null,null,0,{"$error":"#DIV/0!"},{"$f":"+SUM(N7:N10)/SUM($D$7:$D$10)","v":1.2758080303030304E-2},{"$f":"+SUM(L7:L10)/SUM($D$7:$D$10)","v":0}]
[5,null,null,null,{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},{"$f":"+SUM(N7:N11)/SUM($D$7:$D$11)","v":1.2758080303030304E-2},{"$f":"+SUM(L7:L11)/SUM($D$7:$D$11)","v":0}]
[6,null,null,null,{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},{"$f":"+SUM(N7:N12)/SUM($D$7:$D$12)","v":1.2758080303030304E-2},{"$f":"+SUM(L7:L12)/SUM($D$7:$D$12)","v":0}]
[7,null,null,null,{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},{"$f":"+SUM(N7:N13)/SUM($D$7:$D$13)","v":1.2758080303030304E-2},{"$f":"+SUM(L7:L13)/SUM($D$7:$D$13)","v":0}]
[8,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},{"$f":"+SUM(N7:N14)/SUM($D$7:$D$14)","v":1.2758080303030304E-2},{"$f":"+SUM(L7:L14)/SUM($D$7:$D$14)","v":0}]
[9,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},{"$f":"+SUM(N7:N15)/SUM($D$7:$D$15)","v":1.2758080303030304E-2},{"$f":"+SUM(L7:L15)/SUM($D$7:$D$15)","v":0}]
[10,null,null,null,{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},null,0,null,0,{"$error":"#DIV/0!"},{"$f":"+SUM(N7:N16)/SUM($D$7:$D$16)","v":1.2758080303030304E-2},{"$f":"+SUM(L7:L16)/SUM($D$7:$D$16)","v":0}]
[null,"TOTALES",null,{"$f":"SUM(D7:D16)","v":660000000},null,null,null,null,null,null,null,{"$f":"SUM(L7:L16)","v":0},8420333,8420333,{"$f":"+N17/D17","v":1.2758080303030304E-2},{"$f":"+N17/D17","v":1.2758080303030304E-2},{"$f":"+L17/D17","v":0}]