{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":16,"n_cols":9,"rows_kept":16,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
[]
["Client Name","MERSETA"]
["Policy No","TUM-22111123"]
["Broker Name","Westwood Insurance Brokers "]
[]
["TUM Claim Number","Business Class","Date Of Loss","Description of Loss","Peril","Claim Status","Comments","Original Estimate","Excess"]
["TUMC-2211BR019","Business All Risks","2022-11-29","Stolen Laptop","Theft","Finalised","Settled. File Closed","R15,000.00 ","R2,500.00 "]
["TUMC-212E026","Electronic Equipment","2022-12-01","Burglary","Burglary","Finalised","Settled. File Closed","R18,000.00 ","R2,000.00 "]
["TUMC-302BR040","Business All Risks","2023-01-25","Cell phone stolen from insured's vehicle","Theft","Finalised","Closed. No cover ","R9,499.00 ","R0.00 "]
["TUMC-308M295","Motor","2023-07-20","Stone damage to windscreen ","Windscreen Damage","Finalised","Settled. File Closed","R15,000.00 ","R2,500.00 "]
["TUMC-308M306","Motor","2023-07-07","Stone damage to windscreen ","Windscreen Damage","Finalised","NTU. Requested for vehicle details ","R4,500.00 ","R500.00 "]
["TUMC-311BAR460","Business All Risks","2023-10-24","Theft of camera and equipment","Theft","Finalised","Settled. File Closed","R60,000.00 ","R5,728.00 "]
["TUMC-406E806","Electronic Equipment","2024-05-31","Burglary","Theft","Finalised","Settled. File Closed","R50,000.00 ","R5,000.00 "]
["TUMC-407E882","Electronic Equipment","2024-04-10","Burglary - theft of monitors","Burglary","Finalised","Settled. File Closed","R20,000.00 ","R20,000.00 "]
["TUMC-410E1059","Electronic Equipment","2024-09-16","Laptop stolen from the vehicle ","Theft","Finalised","Settled. File Closed","R17,000.00 ","R1,500.00 "]
[{"$nulls":7},{"v":208999,"d":"208,999.00"},{"v":39728,"d":"39,728.00"}]

{"sheet":"Sheet2","index":1,"n_rows":46,"n_cols":2,"rows_kept":46}
[]
["Claim No","Sum of Amount Paid Incl Vat"]
["TUMC-306P199",{"v":18000,"d":"18,000.00"}]
["TUMC-308M263",{"v":9641.18,"d":"9,641.18"}]
["TUMC-308M301",{"v":4542.5,"d":"4,542.50"}]
["TUMC-308M309",{"v":3141.98,"d":"3,141.98"}]
["TUMC-308M312",{"v":3141.98,"d":"3,141.98"}]
["TUMC-309M323",{"v":6879.48,"d":"6,879.48"}]
["TUMC-309M330",{"v":20304.06,"d":"20,304.06"}]
["TUMC-309M347",{"v":176164,"d":"176,164.00"}]
["TUMC-309M353",{"v":977.5,"d":"977.50"}]
["TUMC-310M380",{"v":3737.5,"d":"3,737.50"}]
["TUMC-310M383",{"v":2817.5,"d":"2,817.50"}]
["TUMC-310M384",{"v":3105,"d":"3,105.00"}]
["TUMC-311E437",{"v":16104.060000000001,"d":"16,104.06"}]
["TUMC-311E445",{"v":649,"d":"649.00"}]
["TUMC-311M436",{"v":4600,"d":"4,600.00"}]
["TUMC-312M497",{"v":3737.5,"d":"3,737.50"}]
["TUMC-401E561",{"v":24703.809999999998,"d":"24,703.81"}]
["TUMC-401M532",{"v":33519.71,"d":"33,519.71"}]
["TUMC-401M533",{"v":3116.5,"d":"3,116.50"}]
["TUMC-402M603",{"v":2990,"d":"2,990.00"}]
["TUMC-403M655",{"v":5060,"d":"5,060.00"}]
["TUMC-403M656",{"v":2999,"d":"2,999.00"}]
["TUMC-404M690",{"v":4839.49,"d":"4,839.49"}]
["TUMC-404M706",{"v":190321.36,"d":"190,321.36"}]
["TUMC-404M713",{"v":2990,"d":"2,990.00"}]
["TUMC-405M766",{"v":71147.81,"d":"71,147.81"}]
["TUMC-405M767",{"v":9378.59,"d":"9,378.59"}]
["TUMC-409M1023",{"v":3852.5,"d":"3,852.50"}]
["TUMC-409M1053",{"v":3852.5,"d":"3,852.50"}]
["TUMC-410M1087",{"v":3852.5,"d":"3,852.50"}]
["TUMC-411E1169",{"v":13805.87,"d":"13,805.87"}]
["TUMC-411M1151",{"v":4542.5,"d":"4,542.50"}]
["TUMC-412M1253",{"v":75976.93,"d":"75,976.93"}]
["TUMC-501M1268",{"v":4370.94,"d":"4,370.94"}]
["TUMC-502BAR1395",{"v":9895,"d":"9,895.00"}]
["TUMC-502M1415",{"v":17135.68,"d":"17,135.68"}]
["TUMC-504M1583",{"v":5117.5,"d":"5,117.50"}]
["TUMC-506M1719",{"v":4130,"d":"4,130.00"}]
["TUMC-507M1784",{"v":977.5,"d":"977.50"}]
["TUMC-507M1815",{"v":7762.5,"d":"7,762.50"}]
["TUMC-507M1838",{"v":4370,"d":"4,370.00"}]
["TUMC-507M1866",{"v":5117.5,"d":"5,117.50"}]
["TUMC-508M1969",{"v":4542.5,"d":"4,542.50"}]
["Grand Total",{"v":797911.4299999998,"d":"797,911.43"}]