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

{"sheet":"Sheet1","index":0,"n_rows":26,"n_cols":15,"rows_kept":26,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14]]}
["Client: Manufacturing, Engineering and Related Services Sector Education and Training Authority (Merseta)"]
["Period of Insurance: 01/06/2022 to 01/06/2023"]
["Insurer: AC & E Underwriting Managers"]
["Policy Number: ACE COMM100429 "]
[]
["No.","Broker Ref","Insurer Claim Number","Registration","Date of loss","Description of loss","Risk Type","Sub Cause Code","Claim Status","Date reported","Date Finalized","Claim Estimate (Quotation)","Agreed Amount","Excess ","Nett Payment"]
[1,"HL53WNGP","ACE COMM100429/1","HL53WNGP","05/06/2022","Broken Window - replacement","Motor","Windscreen ","Settled. ","17/06/2022","08/07/2022",{"v":2116.56,"d":"R2,116.56"},{"v":1651.41,"d":"R1,651.41"},{"v":0,"d":"R0.00"},{"v":1651.41,"d":"R1,651.41"}]
[2,"JX41XPGP","ACE COMM100429/2","JX41XPGP","28/06/2022","Insured found his car damaged on the bumper while parked at the parking","Motor","Accidental Damage","Settled. ","29/06/2022","08/07/2022",{"v":78301.88,"d":"R78,301.88"},{"v":45186.08,"d":"R45,186.08"},{"v":1500,"d":"R1,500.00"},{"v":43686.08,"d":"R43,686.08"}]
[3,"EJG126GP","ACE COMM100429/3","EJG126GP","06/07/2022","Stolen Spare Wheel","Motor","Theft","Settled. ","11/07/2022","20/07/2022",{"v":16128.58,"d":"R16,128.58"},{"v":16128.58,"d":"R16,128.58"},{"v":0,"d":"R0.00"},{"$f":"M9-N9","v":{"v":16128.58,"d":"R16,128.58"}}]
[4,"FRS724MP","ACE COMM100429/4","FRS724MP","11/07/2022","Insured vehicle bumped into rocks that were placed on the road by protestors. ","Motor","Accidental Damage","SASRIA Claim - awaiting appointment of an assessor.","12/07/2022","Ongoing",{"v":30000,"d":"R30,000.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[5,"KC53WRGP","ACE COMM100429/5","KC53WRGP","12/07/2022","Insured's spouse hit a dog that ran past the highway, damages to the front bumper","Motor","Collision","Vehicle authorised for repairs at RANDFONTEIN PANELBEATERS - 27 July 2022. Panel Beater advised that vehicle is in the assembly department - 12/09/2022","12/07/2022","Ongoing",{"v":29883.3,"d":"R29,883.30"},{"v":18650,"d":"R18,650.00"},{"v":1500,"d":"R1,500.00"},{"$f":"M11-N11","v":{"v":17150,"d":"R17,150.00"}}]
[6,"ND562147","ACE COMM100429/6","ND562147","14/07/2022","Insured was hijacked and vehicle was recovered with bullet damages","Motor","Theft and Accidental Damage","Vehicle authorised for repairs at SMG Durban ARC - 04 August 2022. Panel beater advised that vehicle is in the painting department - 12/09/2022","15/07/2022","Ongoing",{"v":216734.78,"d":"R216,734.78"},{"v":145099.64,"d":"R145,099.64"},{"v":0,"d":"R0.00"},{"v":145099.64,"d":"R145,099.64"}]
[7,"DR39WPGP","ACE COMM100429/7","DR39WPGP","17/07/2022","Insured driver's son bumped into a third party vehicle at a stop sign","Motor","Collision","Settled. ","21/07/2022","12/09/2022",{"v":29993.84,"d":"R29,993.84"},{"v":35785.47,"d":"R35,785.47"},{"v":5000,"d":"R5,000.00"},{"$f":"M13-N13","v":{"v":30785.47,"d":"R30,785.47"}}]
[8,"JJ47JBGP","ACE COMM100429/8","JJ47JBGP","19/07/2022","Insured vehicle was broken into and stripped by thieves","Motor","Theft and Malicious Damage","Vehicle authorised for repairs at GLOBAL AUTOBODY - 08 August 2022. Panel beater advised that they await parts which will be delivered on the 21st of September 2022 - 12/09/2022","20/07/2022","Ongoing",{"v":50899.17,"d":"R50,899.17"},{"v":36158.59,"d":"R36,158.59"},{"v":0,"d":"R0.00"},{"$f":"M14-N14","v":{"v":36158.59,"d":"R36,158.59"}}]
[9,"DV38ZDGP","ACE COMM100429/9","DV38ZDGP","18/07/2022","Keys fell and broke, remote senser not working","Motor","Keys and Locks","Settled. ","19/07/2022","29/07/2022",{"v":3453.5,"d":"R3,453.50"},{"v":3453.5,"d":"R3,453.50"},{"v":0,"d":"R0.00"},{"$f":"M15-N15","v":{"v":3453.5,"d":"R3,453.50"}}]
[10,"DN68ZMGP","ACE COMM100429/10","DN68ZMGP","27-07-2022","Stone chip on the Windscreen","Motor","Windscreen ","Settled. ","27/07/2022","10/08/2022",{"v":450,"d":"R450.00"},{"v":450,"d":"R450.00"},{"v":0,"d":"R0.00"},{"v":450,"d":"R450.00"}]
[11,"XHG218GP","ACE COMM100429/11","XHG218GP","17/07/2022","Bumped into the rear of a third party vehicle - multiple vehicle collision","Motor","Collision","Section 11 excess issued to insured. Own claim damage authorised at Wonderboom Panel Beaters - 06/09/2022","21/07/2022","Ongoing",{"v":20740.47,"d":"R20,740.47"},{"v":20740.47,"d":"R20,740.47"},{"v":8000,"d":"R8,000.00"},{"$f":"L17-M17","v":{"v":0,"d":"R0.00"}}]
[12,"CA121845","ACE COMM100429/13","CA121845","16/07/2022","Insured driver reversed into a wall at the CTICC parkade","Motor","Accidental Damage","Vehicle authurised for repairs a Dals Motor Group Pry Ltd - 08/07/2022. Driver advised he has not taken the vehicle in for repairs due to internal query regarding excess - 12/09/2022","29/07/2022","Ongoing",{"v":11128.17,"d":"R11,128.17"},{"v":8323,"d":"R8,323.00"},{"v":1500,"d":"R1,500.00"},{"v":4323,"d":"R4,323.00"}]
[13,"JX42PTGP","ACE COMM100429/14","JX42PTGP","08/08/2022","Third party vehicle bumped into insured vehicle from behind and drove off","Motor","Collision","Settled. ","08/08/2022","06/09/2022",{"v":245891.04,"d":"R245,891.04"},"R250 894,00  ",{"v":0,"d":"R0.00"},"R250 894,00  "]
[14,"KKV192MP","ACE COMM100429/15","KKV192MP","08/08/2022","Insured collided head on with third party vehicle at an intersection","Motor","Collision","Settled. ","08/08/2022","12/09/2022",{"v":20000,"d":"R20,000.00"},{"v":67112.25,"d":"R67,112.25"},{"v":0,"d":"R0.00"},{"v":67112.25,"d":"R67,112.25"}]
[15,"DL03YMGP","ACE COMM100429 – 19 ","DL03YMGP","25/08/2022","Insured vehicle was bumped by an unknown vehicle while it was parked ","Motor","Collision","Repairs authorised at Gauteng auto glass for the glass only - 09/09/2022 and SWJ Panelbeaters for bodily damages 12/09/2022","25/08/2022","Ongoing",{"v":18868.63,"d":"R18,868.63"},{"v":1872.15,"d":"R1,872.15"},{"v":0,"d":"R0.00"},{"v":1872.15,"d":"R1,872.15"}]
[16,"FB33YXGP","ACE COMM100429 – 20 ","FB33YXGP","24/08/2022","Insured bumped into a gate","Motor","Accidental Damage","Assessor appointed 29/08/2022. We have requested a copy of the assessors report/quote/authorisation - 09/09/2022","29/08/2022","Ongoing",{"v":10000,"d":"R10,000.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[15,"YRZ840GP","ACE COMM100429/25","YRZ840GP","29/08/2022","Cracked windscreen due to debris on the road","Motor","Glass","Repairs authorised at Gauteng auto glass - 09/09/2022","05/09/2022","Ongoing",{"v":3467.5,"d":"R3,467.50"},{"v":3467.5,"d":"R3,467.50"},{"v":0,"d":"R0.00"},{"v":3467.5,"d":"R3,467.50"}]
[18,"KN97VDGP","ACE COMM100429/26","KN97VDGP","21/08/2022","Unknown damage to windscreen - replacement","Motor","Glass","Repairs authorised at Gauteng auto glass - 09/09/2022","06/09/2022","Ongoing",{"v":6870.1,"d":"R6,870.10"},{"v":2390,"d":"R2,390.00"},{"v":0,"d":"R0.00"},{"v":2390,"d":"R2,390.00"}]
[19,"KN97VDGP","ACE COMM100429/27","KN97VDGP","20/08/2022","Insured vehicle collided with steel baricade","Motor","Collision","Claim reported to insurer, we now await their feedback regarding appointment of an assessor - 12/09/2022","06/09/2022","Ongoing",{"v":11126.25,"d":"R11,126.25"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":11},{"$f":"SUM(L7:L25)","v":{"v":806053.7699999999,"d":"R806,053.77"}},{"$f":"SUM(M7:M25)","v":{"v":406468.64,"d":"R406,468.64"}},{"v":17500,"d":"R17,500.00"},{"$f":"SUM(O7:O25)","v":{"v":373728.17000000004,"d":"R373,728.17"}}]