{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Inicio","Siniestros Denunciados","Siniestros Liquidación directa","Denunciados Periodos Anteriores","20 Liq con mayor asignación","Base"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Inicio","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,1,3,2],[5,1,5,2],[7,1,7,2],[9,1,9,2]]}
[]
["Información Agregada Compañias de Seguros"]
[]
["Grupo compañía:",1]
[]
["Nombre Compañía:",null,null,"Buscar Entidad"]
[]
["Rut:",{"$f":"IFERROR(VLOOKUP(B6,Base!$K:$L,2,0),\"\")","v":""}]
[]
["Periodo","2025-06"]

{"sheet":"Siniestros Denunciados","index":1,"n_rows":71,"n_cols":19,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,1,3]],"read":"row_number_cap"}
["Siniestros Denunciados",null,null,null,"Grupo compañía:",{"$f":"Inicio!B4","v":1},{"$f":"+VLOOKUP(F1,Base!$C$2:$D$3,2,0)","v":"General"},null,{"$f":"+SUM(D8:D87)","v":0},null,{"$f":"+MAX(Base!P2:P90)","v":0}]
[null,null,null,null,"Periodo",{"$f":"Inicio!B10","v":"2025-06"}]
[]
[]
[]
[]
["Ramo","N° Siniestros Denunciados","N° Siniestros Liquidados","Liquidación Directa","Con Liquidador","Con Indemnización","Sin Indemnización","Plazo Promedio","Monto Efectivo de Pago",null,null,"MinD","MaxD","MinE","MaxE","MinF","MaxF","MinG","MaxG"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(E8)=0,0,C8-E8)","v":0},{"$f":"IF(LEN(E8)=0,C8,C8-E8)","v":0},{"$f":"IF(LEN(D8)=0,0,C8-D8)","v":0},{"$f":"IF(LEN(D8)=0,C8,C8-D8)","v":0},{"$f":"IF(LEN(G8)=0,0,C8-G8)","v":0},{"$f":"IF(LEN(G8)=0,C8,C8-G8)","v":0},{"$f":"IF(LEN(F8)=0,0,C8-F8)","v":0},{"$f":"IF(LEN(F8)=0,C8,C8-F8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(E9)=0,0,C9-E9)","v":0},{"$f":"IF(LEN(E9)=0,C9,C9-E9)","v":0},{"$f":"IF(LEN(D9)=0,0,C9-D9)","v":0},{"$f":"IF(LEN(D9)=0,C9,C9-D9)","v":0},{"$f":"IF(LEN(I9)=0,0,G9-I9)","v":0},{"$f":"IF(LEN(G9)=0,C9,C9-G9)","v":0},{"$f":"IF(LEN(F9)=0,0,C9-F9)","v":0},{"$f":"IF(LEN(F9)=0,C9,C9-F9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(E71)=0,0,C71-E71)","v":0},{"$f":"IF(LEN(E71)=0,C71,C71-E71)","v":0},{"$f":"IF(LEN(D71)=0,0,C71-D71)","v":0},{"$f":"IF(LEN(D71)=0,C71,C71-D71)","v":0},{"$f":"IF(LEN(I71)=0,0,G71-I71)","v":0},null,{"$f":"IF(LEN(H71)=0,0,G71-H71)","v":0},{"$f":"IF(LEN(H71)=0,G71,G71-H71)","v":0}]

{"sheet":"Siniestros Liquidación directa","index":2,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[6,9,6,12],[3,0,3,10],[0,0,1,6],[4,0,4,10]]}
["Siniestros Denunciados y liqudados (Liquidación Directa)",null,null,null,null,null,null,"Grupo compañía:",{"$f":"Inicio!B4","v":1},{"$f":"+VLOOKUP(I1,Base!$C$2:$D$3,2,0)","v":"General"},{"$f":"+MAX(Base!Q2:Q90)","v":0},null,{"$f":"'Siniestros Denunciados'!I1","v":0}]
[null,null,null,null,null,null,null,"Periodo",{"$f":"Inicio!B10","v":"2025-06"}]
[]
[{"$f":"+IF('Siniestros Denunciados'!$I$1=0,\"En la pestaña Siniestros Denunciados, usted indica que no tiene Siniestros liquidados directamente, en caso de existir un error favor revisar\",\"\")","v":"En la pestaña Siniestros Denunciados, usted indica que no tiene Siniestros liquidados directamente, en caso de existir un error favor revisar"}]
[{"$f":"+IF(SUM(C9:C65)-M1>0,\"Ha ingresado mayor número de Siniestros Liquidados directamente que en la pestaña anterior\",IF(SUM(C9:C65)-M1<0,\"Aún no ha ingresado todos los siniestros liquidados directamente que ha ingresado en la pestaña anterior\",IF(SUM(C9:C65)-M1=0,\"\")))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"Motivo Rechazo"]
["Ramo","N° Siniestros Asignados","N° Siniestros Liquidados","Con Pago","Plazo Promedio con Pago","Sin Pago","Plazo Promedio sin Pago","Monto Promedio","Monto Efectivo de Pago Liquidacion directa","1.- Sin Cobertura","2.- Bajo deducible","3.- Incumplimiento de contrato por parte del asegurado","4.- Otros","Detalle Otros","Validador",null,null,"MinD","MaxD","MinE","MaxE","MaxJ","MaxK","MaxL","ValorM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F9=\"\",\"\",IF(SUM(J9:M9)=F9,\"Suma motivo de Pago correcto\",\"Existe un error en la suma de Motivo de Pago\"))","v":""},{"$f":"IFERROR(VLOOKUP(A9,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A9,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},{"$f":"IF(LEN(F9)=0,0,C9-F9)","v":0},{"$f":"IF(LEN(F9)=0,C9,C9-F9)","v":0},{"$f":"IF(LEN(D9)=0,0,C9-D9)","v":0},{"$f":"IF(LEN(D9)=0,C9,C9-D9)","v":0},{"$f":"IF(AND(LEN(K9)=0,LEN(L9)=0,LEN(M9)=0),F9,F9-K9-L9-M9)","v":0},{"$f":"IF(AND(LEN(J9)=0,LEN(L9)=0,LEN(M9)=0),F9,F9-J9-L9-M9)","v":0},{"$f":"IF(AND(LEN(J9)=0,LEN(K9)=0,LEN(M9)=0),F9,F9-J9-K9-M9)","v":0},{"$f":"IF(AND(LEN(J9)=0,LEN(K9)=0,LEN(L9)=0),F9,F9-J9-K9-L9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F10=\"\",\"\",IF(SUM(J10:M10)=F10,\"Suma motivo de Pago correcto\",\"Existe un error en la suma de Motivo de Pago\"))","v":""},{"$f":"IFERROR(VLOOKUP(A10,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A10,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},{"$f":"IF(LEN(F10)=0,0,C10-F10)","v":0},{"$f":"IF(LEN(F10)=0,C10,C10-F10)","v":0},{"$f":"IF(LEN(D10)=0,0,C10-D10)","v":0},{"$f":"IF(LEN(D10)=0,C10,C10-D10)","v":0},{"$f":"IF(AND(LEN(K10)=0,LEN(L10)=0,LEN(M10)=0),F10,F10-K10-L10-M10)","v":0},{"$f":"IF(AND(LEN(J10)=0,LEN(L10)=0,LEN(M10)=0),F10,F10-J10-L10-M10)","v":0},{"$f":"IF(AND(LEN(J10)=0,LEN(K10)=0,LEN(M10)=0),F10,F10-J10-K10-M10)","v":0},{"$f":"IF(AND(LEN(J10)=0,LEN(K10)=0,LEN(L10)=0),F10,F10-J10-K10-L10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A11,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A11,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A12,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A12,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A13,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A13,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A14,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A14,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A15,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A15,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A16,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A16,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A17,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A17,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A18,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A18,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A19,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A19,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A20,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A20,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A21,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A21,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A22,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A22,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A23,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A23,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A24,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A24,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A25,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A25,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A26,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A26,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A27,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A27,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A28,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A28,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A29,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A29,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A30,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A30,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A31,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A31,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A32,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A32,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A33,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A33,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A34,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A34,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A35,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A35,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A36,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A36,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A37,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A37,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A38,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A38,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A39,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A39,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A40,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A40,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A41,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A41,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A42,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A42,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A43,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A43,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A44,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A44,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A45,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A45,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A46,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A46,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A47,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A47,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A48,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A48,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A49,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A49,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A50,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A50,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A51,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A51,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A52,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A52,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A53,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A53,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A54,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A54,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A55,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A55,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A56,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A56,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A57,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A57,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A58,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A58,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A59,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A59,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A60,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A60,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A61,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A61,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A62,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A62,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A63,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A63,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A64,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A64,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A65,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A65,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A66,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A66,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A67,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A67,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A68,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A68,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A69,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A69,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(A70,'Siniestros Denunciados'!$A$8:$D$70,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A70,'Siniestros Denunciados'!$A$8:$D$70,4,0),\"\")","v":""},0,0,0,0,0,0,0,0]

{"sheet":"Denunciados Periodos Anteriores","index":3,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,0,1,6],[3,0,3,10],[4,0,4,10],[6,9,6,12]]}
["Siniestros Denunciados Periodos Anteriores",null,null,null,null,null,null,"Grupo compañía:",{"$f":"Inicio!B4","v":1},{"$f":"+VLOOKUP(I1,Base!$C$2:$D$3,2,0)","v":"General"},{"$f":"+MAX(Base!R2:R90)","v":0}]
[null,null,null,null,null,null,null,"Periodo",{"$f":"Inicio!B10","v":"2025-06"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Motivo Rechazo"]
["Ramo","N° Siniestros Asignados","N° Siniestros Liquidados","Con Pago","Plazo Promedio con Pago","Sin Pago","Plazo Promedio sin Pago","Monto Promedio","Monto Efectivo de Pago Liquidacion directa","1.- Sin Cobertura","2.- Bajo deducible","3.- Incumplimiento de contrato por parte del asegurado","4.- Otros","Detalle Otros","Validador",null,null,"MinD","MaxD","MinE","MaxE","MaxJ","MaxK","MaxL","ValorM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F9=\"\",\"\",IF(SUM(J9:M9)=F9,\"Suma motivo de Pago correcto\",\"Existe un error en la suma de Motivo de Pago\"))","v":""},null,null,{"$f":"IF(LEN(F9)=0,0,C9-F9)","v":0},{"$f":"IF(LEN(F9)=0,C9,C9-F9)","v":0},{"$f":"IF(LEN(D9)=0,0,C9-D9)","v":0},{"$f":"IF(LEN(D9)=0,C9,C9-D9)","v":0},{"$f":"IF(AND(LEN(K9)=0,LEN(L9)=0,LEN(M9)=0),F9,F9-K9-L9-M9)","v":0},{"$f":"IF(AND(LEN(J9)=0,LEN(L9)=0,LEN(M9)=0),F9,F9-J9-L9-M9)","v":0},{"$f":"IF(AND(LEN(J9)=0,LEN(K9)=0,LEN(M9)=0),F9,F9-J9-K9-M9)","v":0},{"$f":"IF(AND(LEN(J9)=0,LEN(K9)=0,LEN(L9)=0),F9,F9-J9-K9-L9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F10=\"\",\"\",IF(SUM(J10:M10)=F10,\"Suma motivo de Pago correcto\",\"Existe un error en la suma de Motivo de Pago\"))","v":""},null,null,{"$f":"IF(LEN(F10)=0,0,C10-F10)","v":0},{"$f":"IF(LEN(F10)=0,C10,C10-F10)","v":0},{"$f":"IF(LEN(D10)=0,0,C10-D10)","v":0},{"$f":"IF(LEN(D10)=0,C10,C10-D10)","v":0},{"$f":"IF(AND(LEN(K10)=0,LEN(L10)=0,LEN(M10)=0),F10,F10-K10-L10-M10)","v":0},{"$f":"IF(AND(LEN(J10)=0,LEN(L10)=0,LEN(M10)=0),F10,F10-J10-L10-M10)","v":0},{"$f":"IF(AND(LEN(J10)=0,LEN(K10)=0,LEN(M10)=0),F10,F10-J10-K10-M10)","v":0},{"$f":"IF(AND(LEN(J10)=0,LEN(K10)=0,LEN(L10)=0),F10,F10-J10-K10-L10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,0,0,0,0,0]

{"sheet":"20 Liq con mayor asignación","index":4,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,4],[27,0,27,2]]}
["20 Liquidadores con mayor asignación",null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[]
["N°","Rut Liquidador","Nombre Liquidador","N° Casos",null,"Suma N° Casos",{"$f":"+IF(J1=TRUE,SUM(D8:D27),IF(J2=TRUE,0,IF(AND(J2=FALSE,J1=FALSE),SUM(D8:D28),SUM(D8:D28))))","v":0}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
["Otros"]

{"sheet":"Base","index":5,"n_rows":90,"n_cols":18,"rows_kept":90,"cut":false,"hidden":true,"merged":[]}
["Periodo",null,"Grupo compañía","Grupo",null,1,"General","1.-Incendio",null,null,"Grupo compañía 1","Rut Grupo 1",null,null,null,"Siniestros Denunciados","Siniestros Liquidación directa","Denunciados Periodos Anteriores"]
["2020-06",null,1,"General",null,1,"General","2.-Pérdida de beneficio por incendio",null,1,"ASEGURADORA PORVENIR S.A.","76598625-7",null,null,"1.-Incendio",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O2)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O2)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O2)","v":0}]
["2020-12",null,2,"Vida",null,1,"General","3.-Otros Riesgos adicionales a incendio",null,1,"ASSURANT CHILE COMPAÑIA DE SEGUROS GENERALES S.A.","76212519-6",null,null,"2.-Pérdida de beneficio por incendio",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O3)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O3)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O3)","v":0}]
["2021-06",null,null,null,null,1,"General","4.-Terremoto y Tsunami",null,1,"BCI SEGUROS GENERALES S.A.","99147000-K",null,null,"3.-Otros Riesgos adicionales a incendio",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O4)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O4)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O4)","v":0}]
["2021-12",null,null,null,null,1,"General","5.-Pérdida de beneficio por Terremoto",null,1,"BNP PARIBAS CARDIF SEGUROS GENERALES S.A.","96837640-3",null,null,"4.-Terremoto y Tsunami",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O5)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O5)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O5)","v":0}]
["2022-06",null,null,null,null,1,"General","6.-Otros Riesgos de la naturaleza",null,1,"CHUBB SEGUROS CHILE S.A.","99225000-3",null,null,"5.-Pérdida de beneficio por Terremoto",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O6)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O6)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O6)","v":0}]
["2022-12",null,null,null,null,1,"General","7.-Terrorismo",null,1,"COMPAÑIA DE SEGUROS GENERALES CONSORCIO NACIONAL DE SEGUROS S.A.","96654180-6",null,null,"6.-Otros Riesgos de la naturaleza",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O7)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O7)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O7)","v":0}]
["2023-06",null,null,null,null,1,"General","8.-Robo",null,1,"COMPAÑIA DE SEGUROS GENERALES CONTINENTAL S.A.","76039758-K",null,null,"7.-Terrorismo",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O8)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O8)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O8)","v":0}]
["2023-12",null,null,null,null,1,"General","9.-Cristales",null,1,"CONTEMPORA COMPAÑIA DE SEGUROS GENERALES S.A.","76981875-8",null,null,"8.-Robo",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O9)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O9)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O9)","v":0}]
["2024-06",null,null,null,null,1,"General","10.-Daños físicos Vehículos Motorizados",null,1,"EVEREST COMPAÑIA DE SEGUROS GENERALES CHILE S.A.","77591207-3",null,null,"9.-Cristales",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O10)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O10)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O10)","v":0}]
["2024-12",null,null,null,null,1,"General","11.-Casco Marítimo",null,1,"FID CHILE SEGUROS GENERALES S.A.","77096952-2",null,null,"10.-Daños físicos Vehículos Motorizados",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O11)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O11)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O11)","v":0}]
["2025-06",null,null,null,null,1,"General","12.-Casco Aéreo",null,1,"HDI SEGUROS S.A.","99061000-2",null,null,"11.-Casco Marítimo",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O12)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O12)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O12)","v":0}]
["2025-12",null,null,null,null,1,"General","13.-Responsabilidad civil Hogar y Condominios",null,1,"MAPFRE COMPAÑIA DE SEGUROS GENERALES DE CHILE S.A.","96508210-7",null,null,"12.-Casco Aéreo",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O13)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O13)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O13)","v":0}]
[null,null,null,null,null,1,"General","14.-Responsabilidad civil Profesional",null,1,"METLIFE CHILE SEGUROS GENERALES S.A.","76328793-9",null,null,"13.-Responsabilidad civil Hogar y Condominios",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O14)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O14)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O14)","v":0}]
["Tipo","Grupo",null,null,null,1,"General","15.-Responsabilidad civil Industria, Infraestructura y Comercio",null,1,"MUTUALIDAD DE CARABINEROS","99024000-0",null,null,"14.-Responsabilidad civil Profesional",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O15)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O15)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O15)","v":0}]
["CSG",1,null,null,null,1,"General","16.-Responsabilidad civil Vehículos Motorizados",null,1,"ORION SEGUROS GENERALES S.A.","76042965-1",null,null,"15.-Responsabilidad civil Industria, Infraestructura y Comercio",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O16)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O16)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O16)","v":0}]
["CSC",1,null,null,null,1,"General","17.-Transporte terrestre",null,1,"REALE CHILE SEGUROS GENERALES S.A.","76743492-8",null,null,"16.-Responsabilidad civil Vehículos Motorizados",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O17)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O17)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O17)","v":0}]
["CSV",2,null,null,null,1,"General","18.-Transporte Marítimo",null,1,"RENTA NACIONAL COMPAÑIA DE SEGUROS GENERALES S.A.","94510000-1",null,null,"17.-Transporte terrestre",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O18)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O18)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O18)","v":0}]
[null,null,null,null,null,1,"General","19.-Transporte Aéreo",null,1,"SEGUROS GENERALES SURAMERICANA S.A.","99017000-2",null,null,"18.-Transporte Marítimo",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O19)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O19)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O19)","v":0}]
[null,null,null,null,null,1,"General","20.-Equipo Contratista",null,1,"SOUTHBRIDGE COMPAÑIA DE SEGUROS GENERALES S.A.","99288000-7",null,null,"19.-Transporte Aéreo",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O20)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O20)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O20)","v":0}]
[null,null,null,null,null,1,"General","21.-Todo Riesgo Construcción y Montaje",null,1,"STARR INTERNATIONAL SEGUROS GENERALES S.A.","76620932-7",null,null,"20.-Equipo Contratista",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O21)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O21)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O21)","v":0}]
[null,null,null,null,null,1,"General","22.-Avería de Maquinaria",null,1,"UNNIO SEGUROS GENERALES S.A.","76173258-7",null,null,"21.-Todo Riesgo Construcción y Montaje",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O22)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O22)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O22)","v":0}]
[null,null,null,null,null,1,"General","23.-Equipo Eléctrico",null,1,"ZENIT SEGUROS GENERALES S.A.","76061223-5",null,null,"22.-Avería de Maquinaria",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O23)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O23)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O23)","v":0}]
[null,null,null,null,null,1,"General","24.-Garantía",null,1,"ZURICH CHILE SEGUROS GENERALES S.A.","99037000-1",null,null,"23.-Equipo Eléctrico",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O24)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O24)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O24)","v":0}]
[null,null,null,null,null,1,"General","25.-Fidelidad",null,1,"ZURICH SANTANDER SEGUROS GENERALES CHILE S.A.","76590840-K",null,null,"24.-Garantía",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O25)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O25)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O25)","v":0}]
[null,null,null,null,null,1,"General","26.-Seguro extensión y Garantía",null,1,"AVLA SEGUROS DE CREDITO Y GARANTIA S.A.","76363534-1",null,null,"25.-Fidelidad",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O26)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O26)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O26)","v":0}]
[null,null,null,null,null,1,"General","27.-Seguro de Crédito por venta a plazo",null,1,"CESCE CHILE ASEGURADORA S.A.","76015592-6",null,null,"26.-Seguro extensión y Garantía",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O27)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O27)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O27)","v":0}]
[null,null,null,null,null,1,"General","28.-Seguro de Crédito a la exportación",null,1,"COMPAÑIA DE SEGUROS DE CREDITO CONTINENTAL S.A.","96573590-9",null,null,"27.-Seguro de Crédito por venta a plazo",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O28)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O28)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O28)","v":0}]
[null,null,null,null,null,1,"General","29.-Otros seguros de crédito",null,1,"COMPAÑIA DE SEGUROS DE CREDITOS COFACE CHILE S.A.","96831690-7",null,null,"28.-Seguro de Crédito a la exportación",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O29)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O29)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O29)","v":0}]
[null,null,null,null,null,1,"General","30.-Salud",null,1,"ORSAN SEGUROS DE CREDITO Y GARANTIA S.A.","76810563-4",null,null,"29.-Otros seguros de crédito",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O30)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O30)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O30)","v":0}]
[null,null,null,null,null,1,"General","31.-Accidentes personales",null,1,"SEGUROS KONSEGUR DE GARANTIAS Y CREDITO S.A.","76844788-8",null,null,"30.-Salud",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O31)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O31)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O31)","v":0}]
[null,null,null,null,null,1,"General","32.-Seguro Obligatorio de Accidentes Personales (SOAP)",null,1,"SOLUNION CHILE SEGUROS DE CREDITO S.A.","76094234-0",null,null,"31.-Accidentes personales",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O32)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O32)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O32)","v":0}]
[null,null,null,null,null,1,"General","33.-Seguro de Cesantía",null,1,"LIBERTY MUTUAL SURETY SEGUROS CHILE S.A.","78027718-1",null,null,"32.-Seguro Obligatorio de Accidentes Personales (SOAP)",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O33)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O33)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O33)","v":0}]
[null,null,null,null,null,1,"General","34.-Seguro de Título",null,null,null,null,null,null,"33.-Seguro de Cesantía",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O34)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O34)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O34)","v":0}]
[null,null,null,null,null,1,"General","35.-Seguro Agrícola",null,2,"4 LIFE SEGUROS DE VIDA S.A.","76418751-2",null,null,"34.-Seguro de Título",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O35)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O35)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O35)","v":0}]
[null,null,null,null,null,1,"General","36.-Seguro de Asistencia",null,2,"ALEMANA SEGUROS S.A.","76511423-3",null,null,"35.-Seguro Agrícola",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O36)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O36)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O36)","v":0}]
[null,null,null,null,null,1,"General","50.-Otros Seguros",null,2,"BCI SEGUROS VIDA S.A.","96573600-K",null,null,"36.-Seguro de Asistencia",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O37)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O37)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O37)","v":0}]
[null,null,null,null,null,2,"Vida","101 - Vida entera",null,2,"BICE VIDA COMPAÑIA DE SEGUROS S.A.","96656410-5",null,null,"50.-Otros Seguros",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O38)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O38)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O38)","v":0}]
[null,null,null,null,null,2,"Vida","102 - Temporal de vida",null,2,"BNP PARIBAS CARDIF SEGUROS DE VIDA S.A.","96837630-6",null,null,"101 - Vida entera",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O39)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O39)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O39)","v":0}]
[null,null,null,null,null,2,"Vida","103 - Seguros con cuenta única de inversión (CUI)",null,2,"BUPA COMPAÑIA DE SEGUROS DE VIDA S.A.","76282191-5",null,null,"102 - Temporal de vida",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O40)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O40)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O40)","v":0}]
[null,null,null,null,null,2,"Vida","104 - Mixto o dotal",null,2,"CF SEGUROS DE VIDA S.A.","76477116-8",null,null,"103 - Seguros con cuenta única de inversión (CUI)",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O41)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O41)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O41)","v":0}]
[null,null,null,null,null,2,"Vida","105 - Rentas privadas  y otras rentas",null,2,"CHUBB SEGUROS DE VIDA CHILE S.A.","99588060-1",null,null,"104 - Mixto o dotal",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O42)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O42)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O42)","v":0}]
[null,null,null,null,null,2,"Vida","106 - Dotal puro o capital diferido",null,2,"CN LIFE, COMPAÑIA DE SEGUROS DE VIDA S.A.","96579280-5",null,null,"105 - Rentas privadas  y otras rentas",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O43)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O43)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O43)","v":0}]
[null,null,null,null,null,2,"Vida","107 - Protección familiar",null,2,"COLMENA COMPAÑIA DE SEGUROS DE VIDA S.A.","76408757-7",null,null,"106 - Dotal puro o capital diferido",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O44)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O44)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O44)","v":0}]
[null,null,null,null,null,2,"Vida","108 - Incapacidad o invalidez",null,2,"COMPAÑIA DE SEGUROS CONFUTURO S.A.","96571890-7",null,null,"107 - Protección familiar",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O45)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O45)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O45)","v":0}]
[null,null,null,null,null,2,"Vida","109 - Salud",null,2,"COMPAÑIA DE SEGUROS DE VIDA CAMARA S.A.","99003000-6",null,null,"108 - Incapacidad o invalidez",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O46)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O46)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O46)","v":0}]
[null,null,null,null,null,2,"Vida","110 - Accidentes personales",null,2,"COMPAÑIA DE SEGUROS DE VIDA CONSORCIO NACIONAL DE SEGUROS S.A.","99012000-5",null,null,"109 - Salud",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O47)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O47)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O47)","v":0}]
[null,null,null,null,null,2,"Vida","111 - Asistencia",null,2,"DIVINA PASTORA SEGUROS DE VIDA S.A.","77205281-2",null,null,"110 - Accidentes personales",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O48)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O48)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O48)","v":0}]
[null,null,null,null,null,2,"Vida","112 - Desgravamen hipotecario",null,2,"EUROAMERICA SEGUROS DE VIDA S.A.","99279000-8",null,null,"111 - Asistencia",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O49)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O49)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O49)","v":0}]
[null,null,null,null,null,2,"Vida","113 - Desgravamen consumos y otros",null,2,"HELP SEGUROS DE VIDA S.A.","76213329-6",null,null,"112 - Desgravamen hipotecario",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O50)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O50)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O50)","v":0}]
[null,null,null,null,null,2,"Vida","114 - SOAP",null,2,"MAPFRE COMPAÑIA DE SEGUROS DE VIDA DE CHILE S.A.","96933030-K",null,null,"113 - Desgravamen consumos y otros",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O51)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O51)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O51)","v":0}]
[null,null,null,null,null,2,"Vida","150 - Otros",null,2,"METLIFE CHILE SEGUROS DE VIDA S.A.","99289000-2",null,null,"114 - SOAP",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O52)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O52)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O52)","v":0}]
[null,null,null,null,null,2,"Vida","201 - Vida entera",null,2,"MUTUAL DE SEGUROS DE CHILE","70015730-K",null,null,"150 - Otros",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O53)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O53)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O53)","v":0}]
[null,null,null,null,null,2,"Vida","202 - Temporal de vida",null,2,"MUTUALIDAD DE CARABINEROS","99024000-0",null,null,"201 - Vida entera",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O54)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O54)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O54)","v":0}]
[null,null,null,null,null,2,"Vida","203 - Seguros con cuenta única de inversión (CUI)",null,2,"MUTUALIDAD DEL EJERCITO Y AVIACION","99025000-6",null,null,"202 - Temporal de vida",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O55)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O55)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O55)","v":0}]
[null,null,null,null,null,2,"Vida","204 - Mixto o dotal",null,2,"OHIO NATIONAL SEGUROS DE VIDA S.A.","96687900-9",null,null,"203 - Seguros con cuenta única de inversión (CUI)",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O56)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O56)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O56)","v":0}]
[null,null,null,null,null,2,"Vida","205 - Rentas privadas  y otras rentas",null,2,"PENTA VIDA COMPAÑIA DE SEGUROS DE VIDA S.A.","96812960-0",null,null,"204 - Mixto o dotal",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O57)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O57)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O57)","v":0}]
[null,null,null,null,null,2,"Vida","206 - Dotal puro o capital diferido",null,2,"PRINCIPAL COMPAÑIA DE SEGUROS DE VIDA CHILE S.A.","96588080-1",null,null,"205 - Rentas privadas  y otras rentas",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O58)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O58)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O58)","v":0}]
[null,null,null,null,null,2,"Vida","207 - Protección familiar",null,2,"RENTA NACIONAL COMPAÑIA DE SEGUROS DE VIDA S.A.","94716000-1",null,null,"206 - Dotal puro o capital diferido",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O59)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O59)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O59)","v":0}]
[null,null,null,null,null,2,"Vida","208 - Incapacidad o invalidez",null,2,"SAVE COMPAÑÍA DE SEGUROS DE VIDA S.A.","76034737-K",null,null,"207 - Protección familiar",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O60)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O60)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O60)","v":0}]
[null,null,null,null,null,2,"Vida","209 - Salud",null,2,"SEGUROS CLC S.A.","76573480-0",null,null,"208 - Incapacidad o invalidez",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O61)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O61)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O61)","v":0}]
[null,null,null,null,null,2,"Vida","210 - Accidentes personales",null,2,"SEGUROS DE VIDA SURA S.A.","96549050-7",null,null,"209 - Salud",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O62)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O62)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O62)","v":0}]
[null,null,null,null,null,2,"Vida","211 - Asistencia",null,2,"SEGUROS DE VIDA SURAMERICANA S.A.","76263414-7",null,null,"210 - Accidentes personales",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O63)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O63)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O63)","v":0}]
[null,null,null,null,null,2,"Vida","212 - Desgravamen hipotecario",null,2,"SEGUROS VIDA SECURITY PREVISION S.A.","99301000-6",null,null,"211 - Asistencia",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O64)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O64)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O64)","v":0}]
[null,null,null,null,null,2,"Vida","213 - Desgravamen consumos y otros",null,2,"ZURICH CHILE SEGUROS DE VIDA S.A.","99185000-7",null,null,"212 - Desgravamen hipotecario",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O65)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O65)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O65)","v":0}]
[null,null,null,null,null,2,"Vida","214 - SOAP",null,2,"ZURICH SANTANDER SEGUROS DE VIDA CHILE S.A.","96819630-8",null,null,"213 - Desgravamen consumos y otros",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O66)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O66)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O66)","v":0}]
[null,null,null,null,null,2,"Vida","250 - Otros",null,2,"SEGUROS DE VIDA Y SALUD UC CHRISTUS S.A.","76632553-K",null,null,"214 - SOAP",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O67)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O67)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O67)","v":0}]
[null,null,null,null,null,2,"Vida","301 - Vida entera",null,2,"ZURICH CHILE SEGUROS DE RENTAS VITALICIAS S.A.","76632616-1",null,null,"250 - Otros",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O68)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O68)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O68)","v":0}]
[null,null,null,null,null,2,"Vida","302 - Temporal de vida",null,2,"AUGUSTAR SEGUROS DE VIDA S.A.","76632384-7",null,null,"301 - Vida entera",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O69)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O69)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O69)","v":0}]
[null,null,null,null,null,2,"Vida","303 - Seguros con cuenta única de inversión (CUI)",null,null,null,null,null,null,"302 - Temporal de vida",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O70)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O70)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O70)","v":0}]
[null,null,null,null,null,2,"Vida","304 - Mixto o dotal",null,null,null,null,null,null,"303 - Seguros con cuenta única de inversión (CUI)",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O71)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O71)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O71)","v":0}]
[null,null,null,null,null,2,"Vida","305 - Rentas privadas  y otras rentas",null,null,null,null,null,null,"304 - Mixto o dotal",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O72)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O72)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O72)","v":0}]
[null,null,null,null,null,2,"Vida","306 - Dotal puro o capital diferido",null,null,null,null,null,null,"305 - Rentas privadas  y otras rentas",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O73)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O73)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O73)","v":0}]
[null,null,null,null,null,2,"Vida","307 - Protección familiar",null,null,null,null,null,null,"306 - Dotal puro o capital diferido",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O74)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O74)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O74)","v":0}]
[null,null,null,null,null,2,"Vida","308 - Incapacidad o invalidez",null,null,null,null,null,null,"307 - Protección familiar",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O75)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O75)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O75)","v":0}]
[null,null,null,null,null,2,"Vida","309 - Salud",null,null,null,null,null,null,"308 - Incapacidad o invalidez",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O76)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O76)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O76)","v":0}]
[null,null,null,null,null,2,"Vida","310 - Accidentes personales",null,null,null,null,null,null,"309 - Salud",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O77)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O77)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O77)","v":0}]
[null,null,null,null,null,2,"Vida","311 - Asistencia",null,null,null,null,null,null,"310 - Accidentes personales",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O78)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O78)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O78)","v":0}]
[null,null,null,null,null,2,"Vida","312 - Desgravamen hipotecario",null,null,null,null,null,null,"311 - Asistencia",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O79)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O79)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O79)","v":0}]
[null,null,null,null,null,2,"Vida","313 - Desgravamen consumos y otros",null,null,null,null,null,null,"312 - Desgravamen hipotecario",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O80)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O80)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O80)","v":0}]
[null,null,null,null,null,2,"Vida","314 - SOAP",null,null,null,null,null,null,"313 - Desgravamen consumos y otros",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O81)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O81)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O81)","v":0}]
[null,null,null,null,null,2,"Vida","350 - Otros",null,null,null,null,null,null,"314 - SOAP",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O82)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O82)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O82)","v":0}]
[null,null,null,null,null,2,"Vida","420 - Seguro invalidez y sobrevivencia (SIS)",null,null,null,null,null,null,"350 - Otros",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O83)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O83)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O83)","v":0}]
[null,null,null,null,null,2,"Vida","421 - Renta vitalicia vejez",null,null,null,null,null,null,"420 - Seguro invalidez y sobrevivencia (SIS)",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O84)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O84)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O84)","v":0}]
[null,null,null,null,null,2,"Vida","422 - Renta vitalicia invalidez",null,null,null,null,null,null,"421 - Renta vitalicia vejez",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O85)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O85)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O85)","v":0}]
[null,null,null,null,null,2,"Vida","423 - Renta vitalicia de sobrevivencia",null,null,null,null,null,null,"422 - Renta vitalicia invalidez",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O86)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O86)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O86)","v":0}]
[null,null,null,null,null,2,"Vida","424 - Invalidez y sobrevivencia (C-528)",null,null,null,null,null,null,"423 - Renta vitalicia de sobrevivencia",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O87)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O87)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O87)","v":0}]
[null,null,null,null,null,2,"Vida","425 - Seguro con ahorro previsional (APV)",null,null,null,null,null,null,"424 - Invalidez y sobrevivencia (C-528)",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O88)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O88)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O88)","v":0}]
[null,null,null,null,null,2,"Vida","426 - Seguro con Previsional Colectivo (APVC)",null,null,null,null,null,null,"425 - Seguro con ahorro previsional (APV)",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O89)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O89)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O89)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"426 - Seguro con Previsional Colectivo (APVC)",{"$f":"+COUNTIF('Siniestros Denunciados'!$A$8:$A$70,Base!O90)","v":0},{"$f":"+COUNTIF('Siniestros Liquidación directa'!$A$9:$A$72,Base!O90)","v":0},{"$f":"+COUNTIF('Denunciados Periodos Anteriores'!$A$9:$A$70,Base!O90)","v":0}]