{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Data"],"not_rendered":{"charts":4,"defined_names":5,"pivot_tables":4},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":49,"n_cols":14,"rows_kept":49}
["Broker: Lateral Unison Pty Ltd"]
["Claim Feedback - Specific period (Based on Date Notified)"]
["Lejweleputswa District Municipality"]
["Notification Date From 01 Jun 2019 to 31 Jan 2023"]
["(Double click a total value in a Pivot table to display the claim detail)"]
[]
[]
["Row Labels","No",null,null,"Row Labels","No",{"$nulls":6},"Row Labels","No"]
["Finalised",16,null,null,"Settled",10,{"$nulls":6},"M",9]
["Verification ",2,null,null,"Repudiated",3,{"$nulls":6},"NM",13]
["Negotiation ",1,null,null,"Closed",2,{"$nulls":6},"Grand Total",22]
["NTU",2,null,null,"No cover",1]
["Adjudication ",1,null,null,"Not Taken Up",2]
["Grand Total",22,null,null,"Awaiting Loss Adjustor Report",1]
[{"$nulls":4},"Awaiting Repairers/Replacement Invoice",1]
[{"$nulls":4},"Awaiting document from Client",2]
[{"$nulls":4},"Grand Total",22]
{"$rows_empty":20}
["No","Section"]
["Peril","Motor","Buildings Combined","Business All Risk","Theft","Stated benefits","Grand Total"]
["Collision",4,{"$nulls":4},4]
["Burglary",null,null,4,1,null,5]
["Storm/Flood",null,1,{"$nulls":3},1]
["Theft",null,null,3,null,null,3]
["Impact",3,{"$nulls":4},3]
["Accidental Loss",null,null,1,null,null,1]
["Windscreen",2,{"$nulls":4},2]
["Accidental Breakage",null,null,1,null,null,1]
["Injuries",{"$nulls":4},2,2]
["Grand Total",9,1,9,1,2,22]

{"sheet":"Data","index":1,"n_rows":28,"n_cols":24,"rows_kept":28,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3]]}
["Broker: Lateral Unison Pty Ltd"]
["Claim Feedback - Specific period (Based on Date Notified)"]
["Lejweleputswa District Municipality"]
["Notification Date From 01 Jun 2019 to 31 Jan 2023"]
[]
["Client","LuibBrokerClaimNo","Client Claim Ref","Section","Peril","DateOfLoss","DateNotified","Stage","Status","Status Comment","Repudiated Reason","ClaimedItem","VehRegNo","ClaimDetail","QuotedAmount","AuthorisedAmount","InvoiceAmt","Excess","NettOfLoss","Settlement","Settlement Beneficiary","M_NM","ClaimRef","ClientID"]
["Lejweleputswa District Municipality","LEJ00011","BULELWA MPAKA","Business All Risk","Theft","2019-06-03","2019-07-26","Finalised","Repudiated",null,"TBA","HP - 7282",null,"Laptop and router stolen in an office.",{"v":14722,"d":"R14,722.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"NM",30200,115]
["Lejweleputswa District Municipality","LEJ00012",null,"Business All Risk","Accidental Loss","2019-05-22","2019-07-26","Finalised","Repudiated",null,"TBA","Lenovo laptop - 06668",null,"Laptop stolen in a vehicle during a car accident",{"v":10000,"d":"R10,000.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"NM",30205,115]
["Lejweleputswa District Municipality","LEJ00013",null,"Motor","Windscreen","2019-06-26","2019-07-31","Finalised","Closed",null,null,"TOYOTA COROLLA - FRC 032 FS",null,"Windscreen damaged by an object from a passing truck",{"v":500,"d":"R500.00"},{"v":6145.57,"d":"R6,145.57"},{"v":6145.57,"d":"R6,145.57"},{"v":1536.39,"d":"R1,536.39"},{"v":4609.18,"d":"R4,609.18"},{"v":0,"d":"R0.00"},null,"M",30232,115]
["Lejweleputswa District Municipality","LEJ00014",null,"Motor","Windscreen","2019-07-18","2019-08-07","Finalised","Settled",null,null,"FRZ032FS - TOYOTA",null,"Windscreen to be replaced - FRZ032FS",{"v":2411.55,"d":"R2,411.55"},{"v":2411.55,"d":"R2,411.55"},{"v":2411.55,"d":"R2,411.55"},{"v":602.88,"d":"R602.88"},{"v":1808.67,"d":"R1,808.67"},{"v":1808.67,"d":"R1,808.67"},null,"M",30253,115]
["Lejweleputswa District Municipality","LEJ00015","HCH035FS","Motor","Collision","2020-03-09","2020-03-13","Finalised","Settled",{"$nulls":4},"Mercedes Benz 350GLE D",{"v":46884.55,"d":"R46,884.55"},{"v":40623.64,"d":"R40,623.64"},{"v":40623.64,"d":"R40,623.64"},{"v":3500,"d":"R3,500.00"},{"v":37123.64,"d":"R37,123.64"},{"v":37123.64,"d":"R37,123.64"},null,"M",33464,115]
["Lejweleputswa District Municipality","LEJ00016","Edgar Monnye","Business All Risk","Burglary","2020-03-04","2020-03-16","Finalised","Settled",{"$nulls":4},"Burglary and laptop stolen",{"v":16800,"d":"R16,800.00"},{"v":10757.89,"d":"R10,757.89"},{"v":10757.89,"d":"R10,757.89"},{"v":2500,"d":"R2,500.00"},{"v":8257.89,"d":"R8,257.89"},{"v":8257.89,"d":"R8,257.89"},null,"NM",33471,115]
["Lejweleputswa District Municipality","LEJ00017","Mbali Khanyusa","Business All Risk","Theft","2020-03-04","2020-03-16","Finalised","Settled",{"$nulls":4},"Laptop robbed by two men from insured",{"v":10345.22,"d":"R10,345.22"},{"v":10345.22,"d":"R10,345.22"},{"v":10345.22,"d":"R10,345.22"},{"v":2500,"d":"R2,500.00"},{"v":7845.22,"d":"R7,845.22"},{"v":7845.22,"d":"R7,845.22"},null,"NM",33473,115]
["Lejweleputswa District Municipality","LEJ00018","FBC032FS","Motor","Collision","2020-05-15","2020-05-26","Finalised","Settled",null,null,"Toyota Corolla - FBC032FS","FBC032FS","Third party collided with insured side in circle",{"v":11019.02,"d":"R11,019.02"},{"v":15752.82,"d":"R15,752.82"},{"v":14752.82,"d":"R14,752.82"},{"v":3500,"d":"R3,500.00"},{"v":11252.82,"d":"R11,252.82"},{"v":12252.82,"d":"R12,252.82"},null,"M",33681,115]
["Lejweleputswa District Municipality","LEJ00019","DSS643FS","Motor","Collision","2021-01-18","2021-02-09","Finalised","Settled",{"$nulls":3},"DSS643FS","Insured and third party collided",{"v":15254.1,"d":"R15,254.10"},{"v":17059.42,"d":"R17,059.42"},{"v":17059.42,"d":"R17,059.42"},{"v":5000,"d":"R5,000.00"},{"v":12059.42,"d":"R12,059.42"},{"v":12059.42,"d":"R12,059.42"},null,"M",34644,115]
["Lejweleputswa District Municipality","LEJ00020","HDF759FS - SPEAKER VEHICLE","Motor","Impact","2021-02-18","2021-03-09","Finalised","Settled",{"$nulls":3},"HDF759FS","Insured went through a pothole and damaged vehicle",{"v":74159.58,"d":"R74,159.58"},{"v":97007.01,"d":"R97,007.01"},{"v":0,"d":"R0.00"},{"v":9700.7,"d":"R9,700.70"},{"v":0,"d":"R0.00"},{"v":87306.31,"d":"R87,306.31"},null,"M",34783,115]
["Lejweleputswa District Municipality","LEJ00021",null,"Theft","Burglary","2021-07-14","2021-08-06","Finalised","No cover",{"$nulls":4},"Cllr Matlabe alleges that his TV was stolen from his house.",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"NM",35407,115]
["Lejweleputswa District Municipality","LEJ00022",null,"Business All Risk","Burglary","2021-08-13","2021-09-08","Finalised","Settled",null,null,"Dell Laptop",null,"Insured alleges that laptop and tv was stolen from his house.",{"v":16476.52,"d":"R16,476.52"},{"v":20999,"d":"R20,999.00"},{"v":20999,"d":"R20,999.00"},{"v":2500,"d":"R2,500.00"},{"v":18499,"d":"R18,499.00"},{"v":13976.52,"d":"R13,976.52"},null,"NM",35551,115]
["Lejweleputswa District Municipality","LEJ00023",null,"Business All Risk","Theft","2021-09-02","2021-09-28","Finalised","Repudiated",null,"No Cover","Dell Laptop",null,"Insured advised alleges that have left the laptop on the vehicle and was stolen due to car jamming.",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"NM",35638,115]
["Lejweleputswa District Municipality","LEJ00025","FRC 032 FS","Motor","Impact","2022-09-05","2022-09-05","Finalised","Closed",null,null,"FRC 032 FS","FRC 032 FS","Insured went through a pothole and vehicle damaged",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":5000,"d":"R5,000.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"M",37415,115]
["Lejweleputswa District Municipality","LEJ00026","Laptop - Kobus","Business All Risk","Accidental Breakage","2022-09-29","2022-10-06","Finalised","Settled",null,null,"Laptop",null,"Laptop screen cracked",{"v":4548,"d":"R4,548.00"},{"v":0,"d":"R0.00"},{"v":4548,"d":"R4,548.00"},{"v":2500,"d":"R2,500.00"},{"v":2048,"d":"R2,048.00"},{"v":2048,"d":"R2,048.00"},null,"NM",37598,115]
["Lejweleputswa District Municipality","LEJ00027","HJH190FS","Motor","Collision","2022-09-28","2022-10-12","Finalised","Settled",null,null,"HJH190FS","HJH190FS","Third party turned right into insured vehicle",{"v":57903.77,"d":"R57,903.77"},{"v":57903.77,"d":"R57,903.77"},{"v":62786.76,"d":"R62,786.76"},{"v":15000,"d":"R15,000.00"},{"v":47786.76,"d":"R47,786.76"},{"v":47786.76,"d":"R47,786.76"},null,"M",37630,115]
["Lejweleputswa District Municipality","LEJ00027-2","K Pitso","Stated benefits","Injuries","2022-09-28","2022-10-12","NTU","Not Taken Up","Outstanding documentation from insured",null,"K Pitso - Injuries","HJH190FS","Third party turned right into insured vehicle and driver and passenger got injured",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"NM",37630,115]
["Lejweleputswa District Municipality","LEJ00027-3","TI Mothupi","Stated benefits","Injuries","2022-09-28","2022-10-12","NTU","Not Taken Up","Outstanding documentation from insured",null,"TI Mothupi","HJH190FS","Third party turned right into insured vehicle",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"NM",37630,115]
["Lejweleputswa District Municipality","LEJ00028","Damaged wall and electric fence","Buildings Combined","Storm/Flood","2022-11-10","2022-11-11","Adjudication ","Awaiting Loss Adjustor Report",null,null,"Wall & Electric fence",null,"Tree fell and damaged wall and electric fence due to thunderstorms",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":10000,"d":"R10,000.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"NM",37748,115]
["Lejweleputswa District Municipality","LEJ00029","HV984FS","Motor","Impact","2022-12-14","2023-01-18","Negotiation ","Awaiting Repairers/Replacement Invoice",null,null,"HV984FS","HV984FS","Executive Mayor collided with a Guineafowl",{"v":24849.46,"d":"R24,849.46"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":7500,"d":"R7,500.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"M",40929,115]
["Lejweleputswa District Municipality","LEJ00030","Burglary - Laptops","Business All Risk","Burglary","2022-12-28","2023-01-23","Verification ","Awaiting document from Client",null,null,"TV, 2X Laptops and 2x Monitors",null,"Burglary at office",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":2500,"d":"R2,500.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"NM",40944,115]
["Lejweleputswa District Municipality","LEJ00031","Laptop stolen - Siphiwe Mokotedi","Business All Risk","Burglary","2022-12-28","2023-01-27","Verification ","Awaiting document from Client",null,null,"Laptop",null,"Laptop stolen from employee house",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":2500,"d":"R2,500.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},null,"NM",40970,115]