{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["RESUMEN","SIS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"RESUMEN","index":0,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,3,6]]}
[]
[null,"RESUMEN REPORTE SINIESTRALIDAD"]
[]
[]
[null,"Etiquetas de fila","Suma de Reserva_COP 100%","Suma de Indem_COP 100%","Suma de Gasto_COP 100%","Suma de Recobro_COP 100%","Suma de Total_COP 100%"]
[null,"PROPERTY",6016666.666666667,50951050.816666663,1199999.08,0,58167716.563333333]
[null,"SPECIALT",28343347.5,0,0,0,28343347.5]
[null,"Total general",34360014.166666664,50951050.816666663,1199999.08,0,86511064.063333333]

{"sheet":"SIS","index":1,"n_rows":16,"n_cols":31,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Ramo_Siniestro","Policy Holder ID","Sponsor ID","Sponsor","Asegurado","Agente/Bróker ID","Ramo","Póliza","Endoso","Siniestro","Fecha de Ocurrencia","Fecha de Aviso","Descripción 1","Descripción 2","Clmeventcode","Dtlfline","Flinedesc","Majorline","Majorshortdesc","Código sucursal","Descripción sucursal","Reserva_COP","Reserva_COP 100%","Indem_COP","Indem_COP 100%","Gasto_COP","Gasto_COP 100%","Recobro_COP","Recobro_COP 100%","Total_COP","Total_COP 100%"]
["12_550281",30,8002253408,"UNIVERSIDAD MILITAR NUEVA","VER ASEGURADOS CONDICIONE",11111,12,58287,10,550281,"2023-06-15","2023-09-05","IUS-2022-548292","IUS-2022-548292",653,"6S","PI, NON-US, PRIMARY",5,"SPECIALT",3,"Bogotá",22674678,{"$f":"V2/80%","v":28343347.5},0,{"$f":"X2/80%","v":0},0,{"$f":"Z2/80%","v":0},0,{"$f":"AB2/80%","v":0},22674678,{"$f":"AD2/80%","v":28343347.5}]
["1_548746",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,0,548746,"2022-12-12","2023-07-28","HURTO TECLADO AU E211","HURTO TECLADO",618,82,"BURGLARY",1,"PROPERTY",3,"Bogotá",60000,{"$f":"V3/60%","v":100000},0,{"$f":"X3/60%","v":0},0,{"$f":"Z3/60%","v":0},0,{"$f":"AB3/60%","v":0},60000,{"$f":"AD3/60%","v":100000}]
["1_540932",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,2,540932,"2023-01-17","2023-02-08","ROTURA DE VIDRIO OF SEPULVEDA","ROTURA DE VIDRIO OF",606,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",0,{"$f":"V4/60%","v":0},840840,{"$f":"X4/60%","v":1401400},0,{"$f":"Z4/60%","v":0},0,{"$f":"AB4/60%","v":0},840840,{"$f":"AD4/60%","v":1401400}]
["1_544391",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,2,544391,"2023-03-10","2023-03-29","ROTURA DE VIDRIOS SEDE UMNG","ROTURA DE VIDRIOS",606,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",0,0,1404000.24,2340000.4,0,0,0,0,1404000.24,2340000.4]
["1_544829",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,2,544829,"2023-03-02","2023-04-05","ROTURA DE VIDRIO 2PS","ROTURA DE VIDRIO 2PS",664,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",0,0,498000,830000,0,0,0,0,498000,830000]
["1_544844",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,2,544844,"2023-01-17","2023-04-11","ROTURA DE VIDRIO OF GEOTECNIA","OF GEOTECNIA",606,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",0,0,401940,669900,0,0,0,0,401940,669900]
["1_547360",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,2,547360,"2023-05-28","2023-06-16","ROTURA DE VIDRIOS CAMPUS","ROTURA DE VIDRIOS",606,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",0,0,5004002.72,8340004.5333333332,0,0,0,0,5004002.72,8340004.5333333332]
["1_552992",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,2,552992,"2023-07-12","2023-12-07","ROT VIDRIO ED AULAS 2","ROT VIDRIO",606,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",800000,1333333.3333333335,0,0,0,0,0,0,800000,1333333.3333333335]
["1_545352",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,4,545352,"2023-03-09","2023-04-20","HTO/CEL SAMSUNG GALAXY J2","HTO/CEL SAMSUNG",618,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",750000,1250000,0,0,0,0,0,0,750000,1250000]
["1_546542",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,4,546542,"2023-01-23","2023-05-26","DÑ 3 PROYECTORES EPSON 1450","DÑ PROYECTORES",617,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",0,0,0,0,0,0,0,0,0,0]
["1_547376",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,4,547376,"2023-05-11","2023-06-16","ROTURA VIDRIO AULA B207 DLM233","ROTURA VIDRIO B207",606,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",0,0,1170000.6399999999,1950001.0666666667,0,0,0,0,1170000.6399999999,1950001.0666666667]
["1_552993",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,4,552993,"2023-07-12","2023-12-07","ROTURA VIDRIO PRTA OCCIDENTAL","ROTURA DE VIDRIO",664,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",1900000,3166666.666666667,0,0,0,0,0,0,1900000,3166666.666666667]
["1_548744",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,7,548744,"2023-07-21","2023-07-28","ROTURA VIDRIO AULA B106","ROT VIDRIO AULA B106",606,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",0,0,900000.49,1500000.8166666667,0,0,0,0,900000.49,1500000.8166666667]
["1_549347",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,1,57370,7,549347,"2023-06-01","2023-08-09","HTO TECLADO Y MOUSE AULA E503","HTO EQUIPOS",618,10,"FIRE-Property",1,"PROPERTY",3,"Bogotá",100000,166666.66666666669,0,0,0,0,0,0,100000,166666.66666666669]
["14_545051",8002253408,8002253408,"UNIVERSIDAD MILITAR NUEVA","UNIVERSIDAD MILITAR NUEVA",11111,14,7012,2,545051,"2023-03-08","2023-04-13","FAL EQUIPOS/FUN JOHN CHAVEZ","FAL EQUIPOS",814,"E5","PACKAGE - FIRE",1,"PROPERTY",3,"Bogotá",0,{"$f":"V16/50%","v":0},16959872,{"$f":"X16/50%","v":33919744},599999.54,{"$f":"Z16/50%","v":1199999.08},0,{"$f":"AB16/50%","v":0},17559871.539999999,{"$f":"AD16/50%","v":35119743.079999998}]