{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["FEB 2024 - JAN 2025","FEB 2025 -JAN 2026","FEB 2026-JAN 2027","Travel"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"FEB 2024 - JAN 2025","index":0,"n_rows":59,"n_cols":14,"rows_kept":59,"merged":[[2,7,2,9],[3,7,3,9],[13,6,13,7]]}
[]
[]
[{"$nulls":7},"NATIONAL YOUTH DEVELOPMENT AGENCY COMMERCIAL POLICY"]
[{"$nulls":7},"PERIOD OF INSURANCE: FEBRUARY 2024 - JANUARY 2025"]
[{"$nulls":8},"CLAIMS HISTORY  REPORT"]
["Insured Year","Date of Loss","Date Registered","User","Section of Cover ","Location","Asset ID","Asset Label"," Description","Claim Number","Excess","Gross","Net","Status"]
["2024/2025","06/02/2024","13/02/2024","Nelisiwe Gumede","BAR","PDDD/Durban","CE5252","CE5252-1","Stolen Laptop : Dell Latitude 3330 2in1 QTY100",124308194,{"v":2716.9,"d":"R2,716.90"},{"v":27169,"d":"R27,169.00"},{"v":24452.1,"d":"R24,452.10"},"Settled. File closed."]
["2024/2025","12/03/2024","28/03/2024","Welile Ntlebi","BAR","Secunda Centre","CE4011","CE4011-1","Stolen laptop : DELL Lattitude 5300",124313557,{"v":2631.9,"d":"R2,631.90"},{"v":26319,"d":"R26,319.00"},{"v":23687.1,"d":"R23,687.10"},"Settled. File closed."]
["2024/2025","07/03/2024","22/03/2024","Simphiwe","BAR","Woodmead Office","CE4394-1","CE4394-1","Stolen laptop : DELL Intel Core i3 ",124310097,{"v":2000,"d":"R2,000.00"},{"v":13364.58,"d":"R13,364.58"},{"v":11364.58,"d":"R11,364.58"},"Settled. File closed."]
["2024/2025","23/02/2024","03/04/2024","Lusanda","BAR","East London Centre ","CE5077-1",{"$f":"$G$10","v":"CE5077-1"},"Stolen laptop",124316160,{"v":2519.9,"d":"R2,519.90"},{"v":25199,"d":"R25,199.00"},{"v":22679.1,"d":"R22,679.10"},{"$f":"$N$9","v":"Settled. File closed."}]
["2024/2025","01/03/2024","18/03/2024","Motor","MOTOR","Bloemfontein","HC 42 KY GP","HC 42 KY GP","Motor Accident : Iveco",124308765,{"v":91330.04,"d":"R91,330.04"},{"v":913300.4,"d":"R913,300.40"},{"v":821970.36,"d":"R821,970.36"},"Settled. File closed."]
["2024/2025","26/03/2024","28/03/2024","Westrand Office","OFFICE CONTENTS","Westrand office",null,null,"Break-in Claim No:",124313314,{"v":11860.2,"d":"R11,860.20"},{"v":237204,"d":"R237,204.00"},{"v":225343.8,"d":"R225,343.80"},"Settled. File closed."]
["2024/2025","27/03/2024","22/04/2024","Lucricia Ndhlovu","BAR","Thulamahashe/Lillydale","CE4289","CE4289-1","Damaged Laptop ",124330698,{"v":2000,"d":"R2,000.00"},{"v":6095,"d":"R6,095.00"},{"v":4095,"d":"R4,095.00"},"Settled. File closed."]
["2024/2025","01/03/2024","22/04/2024","Pulane Moadira","BAR",{"$f":"$F$11","v":"Bloemfontein"},"CE4390-1      CE5250-1",null,"Damaged Laptops (Pulane and Thuso)",124335381,{"v":3578.96,"d":"R3,578.96"},{"v":35789.8,"d":"R35,789.80"},{"v":32210.62,"d":"R32,210.62"},"Settled. File closed."]
["2024/2025","01/03/2024","20/05/2024","Pulane Moadira | Tshepang | Thuso","GPA","Bloemfontein",null,null,"Group Personal Accident",124344641,"TBA","TBA","TBA","Pulane claim - awaiting NYDA's response if they did lodge a claim with COIDA | Tshepang claim - Awaiting insurer's feedback | Thuso claim - Awaiting NYDA to furnish all pertinent documents. 14/07/2026 NYDA advised to follow-up and revert to broker"]
["2024/2025","13/05/2024","16/05/2024","Minah Ngwetjana","BAR",{"$nulls":3},"Damaged Laptop  : Dell laptop",124342716,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"Asset not on asset register. File Closed"]
["2024/2025","23/04/2024","16/05/2024","Paballo Phadi","BAR","Welkom","CE4524-1",{"$f":"$G$17","v":"CE4524-1"},"Damaged Tablet; Samsung Galaxy Tab S6 Lite",124342727,{"v":2000,"d":"R2,000.00"},{"v":3309.85,"d":"R3,309.85"},{"v":1309.85,"d":"R1,309.85"},{"$f":"$N$7","v":"Settled. File closed."}]
["2024/2025","28/03/2024","17/05/2024","Luyanda Madlanga","BAR","Woodmead Office",null,null,"Stolen laptop: Dell laptop",124343708,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"NYDA found the laptop. File Closed."]
["2024/2025","30/05/2024","18/06/2024",null,"OFFICE CONTENTS","Rustenburg Centre","OE1802-1","OE1802-1","Broken stand",124360741,{"v":2500,"d":"R2,500.00"},{"v":2530,"d":"R2,530.00"},{"v":30,"d":"R30.00"},"Settled. File closed."]
["2024/2025","02/06/2024","21/06/2024","Sandisi","BAR",null,"CE4649-1","CE4649-1","Stolen Laptop",124363226,{"v":2000,"d":"R2,000.00"},{"v":3195.96,"d":"R3,195.96"},{"v":1195.96,"d":"R1,195.96"},{"$f":"$N$7","v":"Settled. File closed."}]
["2024/2025","15/06/2024","05/07/2024","Moscow","MOTOR","Polokwane","HM34JY GP","HM34JY GP","Motor Accident : Polokwane",124371269,{"v":5000,"d":"R5,000.00"},{"v":27595.84,"d":"R27,595.84"},{"v":22595.84,"d":"R22,595.84"},{"$f":"$N$20","v":"Settled. File closed."}]
["2024/2025","09/06/2024","05/07/2024","Asanda","BAR",null,"CE5176-1",{"$f":"$G$22","v":"CE5176-1"},"Damaged Tablet :  Samsung S6 life with sylus pen",124372472,{"v":2000,"d":"R2,000.00"},{"v":5116.8,"d":"R5,116.80"},{"v":3116.8,"d":"R3,116.80"},{"$f":"$N$20","v":"Settled. File closed."}]
["2024/2025","25/06/2024","17/07/2024","Kedibone Bereng","EE","Bloemfontein","OE897-1",{"$f":"$G$23","v":"OE897-1"},"Stolen Projector",124379304,{"v":2500,"d":"R2,500.00"},{"v":9000,"d":"R9,000.00"},{"v":6500,"d":"R6,500.00"},"Settled. File closed."]
["2024/2025","16/07/2024","17/07/2024","Shadrack","MOTOR","Woodmead Office","KS08DYGP","KS08DYGP","Motor Accident; Opel Combo ",124379326,{"v":5000,"d":"R5,000.00"},{"v":59265.27,"d":"R59,265.27"},{"$f":"L24-K24","v":{"v":54265.27,"d":"R54,265.27"}},"Settled. File Closed."]
["2024/2025","19/07/2024","25/07/2024","Vusi Ngwenya","BAR","Woodmead Office","CE4572-1",{"$f":"$G$25","v":"CE4572-1"},"Stolen laptop",124385524,{"v":2027.29,"d":"R2,027.29"},{"v":20272.85,"d":"R20,272.85"},{"v":18245.56,"d":"R18,245.56"},"Settled. File Closed."]
["2024/2025","30/07/2024","05/08/2024","Lebohang Manyama","BAR",null,"CE4831","CE4831","Damaged Samsung Tablet",124388311,{"v":2000,"d":"R2,000.00"},{"v":11960,"d":"R11,960.00"},{"v":9960,"d":"R9,960.00"},"Settled. File Closed."]
["2024/2025","30/07/2024","13/08/2024","Puleng Rantso","MOTOR","Woodmead Office","JN 59 BJ GP","JN 59 BJ GP","Cracked Windscreen ; VW Caddy",124392329,{"v":0,"d":"R0.00"},{"v":4924.47,"d":"R4,924.47"},{"v":4924.47,"d":"R4,924.47"},"Settled. File Closed."]
["2024/2025","28/07/2024","08/08/2024","Mawakhazole Nyatela","BAR ",null,"CE4820","CE4820","Damaged Tablet",124390715,{"v":2000,"d":"R2,000.00"},{"v":11960,"d":"R11,960.00"},{"v":9960,"d":"R9,960.00"},"Settled. File Closed."]
["2024/2025","07/08/2024","20/08/2024","Palesa Mafoka","BAR",null,"CE4544","CE4544","Stolen Tablet",124398687,{"v":2000,"d":"R2,000.00"},{"v":3309.85,"d":"R3,309.85"},{"v":1309.85,"d":"R1,309.85"},{"$f":"$N$7","v":"Settled. File closed."}]
["2024/2025",null,"28/08/2024","George","MOTOR","Kimberly","JF 49 ZK GP","JF 49 ZK GP","Towing Invoice","TN-184225",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"Claim dismissed - Client to borne costs"]
["2024/2025","27/08/2024","02/09/2024","Shadrack","MOTOR","Woodmead Office","LS 58 FG GP","LS 58 FG GP","damaged rear windscreen ; GWM steed 5",124403322,{"v":673.09,"d":"R673.09"},{"v":2692.25,"d":"R2,692.25"},{"$f":"L31-K31","v":{"v":2019.1599999999999,"d":"R2,019.16"}},{"$f":"$N$29","v":"Settled. File closed."}]
["2024/2025","30/08/2024","05/09/2024","Promise Sibanyoni","MOTOR",null,"LF 31 TD GP",{"$f":"$G$32","v":"LF 31 TD GP"},"Motor accident",124412746,{"v":5000,"d":"R5,000.00"},{"$f":"K32+M32","v":{"v":25906.25,"d":"R25,906.25"}},{"v":20906.25,"d":"R20,906.25"},"Settled. File closed."]
["2024/2025","04/09/2024","06/09/2024","Raoul Weldon","BAR","Portsheptone","CE4526-1","CE4526-1","Damaged tablet",124406249,{"v":2000,"d":"R2,000.00"},{"v":3309.85,"d":"R3,309.85"},{"v":1309.85,"d":"R1,309.85"},"Settled. File closed."]
["2024/2025","29/08/2024","11/09/2024","Tshepo Manyama","BAR",null,"CE4984","CE4984","Damaged Dell Laptop",124410211,{"v":2000,"d":"R2,000.00"},{"v":7820,"d":"R7,820.00"},{"$f":"L34-K34","v":{"v":5820,"d":"R5,820.00"}},{"$f":"$N$29","v":"Settled. File closed."}]
["2024/2025","05/09/2024","13/09/2024","Promise Sibanyoni","MOTOR","Kwa Thema","LS 58 FG GP","LS 58 FG GP","Chipped Windscreen GWM Bakkie",124409687,{"v":0,"d":"R0.00"},{"v":786.26,"d":"R786.26"},{"v":786.26,"d":"R786.26"},{"$f":"$N$29","v":"Settled. File closed."}]
["2024/2025","20/09/2024","07/10/2024","Carlyn Sassman","BAR","Cape Town","CE4216-1","CE4216-1","Damaged Dell latitude 7490 Laptop",124422145,{"v":2000,"d":"R2,000.00"},{"v":5085.3,"d":"R5,085.30"},{"v":3085.3,"d":"R3,085.30"},{"$f":"$N$29","v":"Settled. File closed."}]
["2024/2025","25/09/2024","10/10/2024","Jeremiah Lukas","BAR",null,"CE4051","CE4051","Stolen dell laptop",124423567,{"v":2454.9,"d":"R2,454.90"},{"v":24549,"d":"R24,549.00"},{"v":22094.1,"d":"R22,094.10"},{"$f":"$N$29","v":"Settled. File closed."}]
["2024/2025","04/09/2024","18/10/2024","Mr Dikotsi","GIT","Woodmead Office",null,null,"Damaged furniture in transit","124437834/RES2187",{"v":2562.46,"d":"R2,562.46"},{"v":51249.27,"d":"R51,249.27"},{"$f":"L38-K38","v":{"v":48686.81,"d":"R48,686.81"}},"Settled. File closed."]
["2024/2025","30/09/2024","22/10/2024","Churchill Mhlaba","BAR",{"$nulls":3},"Damaged Laptop",124437862,{"v":2000,"d":"R2,000.00"},{"v":5290,"d":"R5,290.00"},{"$f":"L39-K39","v":{"v":3290,"d":"R3,290.00"}},"Settled. File closed."]
["2024/2025","01/11/2024","12/11/2024","Solomzi Tshona","BAR","East London Centre ","CE4877","CE4877","Stolen Laptop",124442604,{"v":2286.9,"d":"R2,286.90"},{"v":22869,"d":"R22,869.00"},{"v":20582.1,"d":"R20,582.10"},"Settled. File closed."]
["2024/2025","09/12/2024","13/12/2024","Kedibone Masuku","BAR","Sunninghill",null,null,"Damaged Laptop",124462773,{"v":2479.28,"d":"R2,479.28"},{"v":24792.85,"d":"R24,792.85"},{"$f":"L41-K41","v":{"v":22313.57,"d":"R22,313.57"}},"Settled. File closed."]
["2024/2025","10/01/2025","14/01/2025","Sarah Baartman","MOTOR","Sunninghill","JN 59 CC GP","JN 59 CC GP","Cracked Windscreen ; VW Caddy",124474301,{"v":1231.11,"d":"R1,231.11"},{"v":4924.47,"d":"R4,924.47"},{"$f":"L42-K42","v":{"v":3693.3600000000006,"d":"R3,693.36"}},"Settled. File closed."]
["2024/2025","08/01/2025","22/01/2025","Nontsikelelo Makaula","BAR","Sunninghill","CE4983","CE4983","Damaged Laptop",124480412,{"v":2000,"d":"R2,000.00"},{"v":7176,"d":"R7,176.00"},{"$f":"L43-K43","v":{"v":5176,"d":"R5,176.00"}},"Settled. File closed."]
["2024/2025","29/11/2024","22/01/2025",null,"OC","East London Centre ",null,null,"Damaged Aircons",124480428,{"v":6410.54,"d":"R6,410.54"},{"v":64105.41,"d":"R64,105.41"},{"v":57694.87,"d":"R57,694.87"},"Settled. File closed."]
["2024/2025","21/01/2025","22/01/2025","Sahluko Tekana","MOTOR","Tweeling","JD 34 RG GP","JD 34 RG GP","Shattered windscreen;VW Caddy",124479769,{"v":1254.12,"d":"R1,254.12"},{"v":5016.47,"d":"R5,016.47"},{"v":1254.11,"d":"R1,254.11"},"Settled. File closed."]
["2024/2025","02/01/2025","29/01/2025","Beauty Mogotlane","BAR",{"$nulls":3},"Damaged laptop",124485041,{"v":2479.28,"d":"R2,479.28"},{"v":24792.85,"d":"R24,792.85"},{"v":22313.57,"d":"R22,313.57"},"Settled. File closed."]
["2024/2025","04/02/2025","04/02/2025","Lungile Thangeni","MOTOR","Kimberly","JN 59 BJ GP","JN 59 BJ GP","Cracked Windscreen ; VW Caddy",124487069,{"v":1231.11,"d":"R1,231.11"},{"v":4924.47,"d":"R4,924.47"},{"$f":"L47-K47","v":{"v":3693.3600000000006,"d":"R3,693.36"}},"Settled. File closed."]
["2024/2025","19/01/2025","06/02/2025","Mduduzi Madonsela","EE","Mpumalanga","OE1728","OE1728","Stolen Projector",124490085,{"v":1000,"d":"R1,000.00"},{"v":8999,"d":"R8,999.00"},{"v":7999,"d":"R7,999.00"},"Settled. File closed."]
["2024/2025","28/01/2025","19/02/2025","Zelda","BAR",null,"CE5183","CE5183","Damaged Tablet",124496907,{"v":2000,"d":"R2,000.00"},{"v":4998.99,"d":"R4,998.99"},{"v":2998.99,"d":"R2,998.99"},"Settled. File closed."]
["TOTAL ",{"$nulls":9},{"$f":"SUM(K7:K49)","v":{"v":188727.97999999995,"d":"R188,727.98"}},{"$f":"SUM(L7:L49)","v":{"v":1746169.3600000006,"d":"R1,746,169.36"}},{"$f":"SUM(M7:M49)","v":{"v":1554932.9200000013,"d":"R1,554,932.92"}}]
[]
[]
["KEY",{"$nulls":7}," "]
["DESCRIPTION ","COLOUR"]
["Settled ","Sky Blue "]
["In progress","Yellow"]
["Not yet recognised ","Orange "]
["Proof of forcibly entry required","Green"]
["Rejected","Red"]

{"sheet":"FEB 2025 -JAN 2026","index":1,"n_rows":62,"n_cols":14,"rows_kept":62,"merged":[[2,4,2,11],[3,4,3,11],[4,4,4,12]]}
[]
[]
[{"$nulls":4},"NATIONAL YOUTH DEVELOPMENT AGENCY COMMERCIAL POLICY"]
[{"$nulls":4},"PERIOD OF INSURANCE: FEBRUARY 2025 - JANUARY 2026"]
[{"$nulls":4},"CLAIMS HISTORY  REPORT"]
[]
[]
[]
["Insured Year","Date of Loss","Date Registered","User","Section of Cover ","Location","Asset ID","Asset Label"," Description","Claim Number","Excess","Gross","Net","Status"]
["2025/2026","18/02/2025","19/02/2025","Seja","BAR",null,"CE5251","CE5251","Stolen Laptop",124496932,{"v":2286.9,"d":"R2,286.90"},{"v":22869,"d":"R22,869.00"},{"v":20582.1,"d":"R20,582.10"},"Settled. File closed."]
["2025/2026","05/03/2025","24/03/2025","Sabelo Mzuku","BAR","Sandton","CE4511","CE4511","Damage laptop",124514150,{"v":2000,"d":"R2,000.00"},{"v":19768.5,"d":"R19,768.50"},{"v":17768.5,"d":"R17,768.50"},"Settled. File closed."]
["2025/2026","27/03/2025","31/03/2025","TBA","Motor","TBA","TBA","TBA","Motor accident involving 3rd party",124524574,{"v":4000,"d":"R4,000.00"},"TBA","TBA","Settled. File closed."]
["2025/2026","15/04/2025","15/04/2025","Philani Zulu","BAR","Rosettenville","CE5062","CE5062","Damaged dell latitude 3330",124528043,{"v":2000,"d":"R2,000.00"},{"v":7532.5,"d":"R7,532.50"},{"v":5532.5,"d":"R5,532.50"},"Settled. File closed."]
["2025/2026","16/04/2025","23/04/2025","Kedumete Matshego","BAR",null,"CE4000","CE4000","Damaged laptop",124531758,{"v":2000,"d":"R2,000.00"},{"v":4715,"d":"R4,715.00"},{"v":2715,"d":"R2,715.00"},"Settled. File closed."]
["2025/2026","16/04/2025","24/04/2025","Sabelo Ndlangalala","Motor",null,"JN 59 CC GP","JN 59 CC GP","2018 VW Caddy Van damaged side mirror",124538914,{"v":5000,"d":"R5,000.00"},{"v":7921.78,"d":"R7,921.78"},{"v":2927.78,"d":"R2,927.78"},"Settled. File closed."]
["2025/2026","24/04/2025","24/04/2025",null,null,"Emalahleni ",null,null,"Break-in at the Emahleni office",124532819,{"v":3873.6,"d":"R3,873.60"},{"$f":"M16+K16","v":{"v":38735.9,"d":"R38,735.90"}},{"v":34862.3,"d":"R34,862.30"},"Settled. File closed."]
["2025/2026","29/11/2024","19/05/2025","Unathi Bonagni","BAR","Sandton",null,null,"Lost laptop in bolt vehicle",124544061,{"v":2398.9,"d":"R2,398.90"},{"v":23989,"d":"R23,989.00"},{"v":21590.1,"d":"R21,590.10"},"Settled. File closed."]
["2025/2026","07/05/2025","20/05/2025","Vuyiswa Diba","BAR","East London","CE3360","CE3360","Stolen Laptop",124545559,{"v":2069,"d":"R2,069.00"},{"v":20699,"d":"R20,699.00"},{"v":18629.1,"d":"R18,629.10"},"Settled. File closed."]
["2025/2026","10/06/2024","26/05/2025",null,"FG","Sedibeng centre","NA","N/A","Fraud claim - NYDA employees defrauded agency ",124546539,{"v":55000,"d":"R55,000.00"},{"v":190000,"d":"R190,000.00"},{"v":135000,"d":"R135,000.00"},"Settled. File closed."]
["2025/2026","30/05/2025","03/06/2025","Solomzi Tshona","BAR",{"$nulls":3},"Stolen Laptop",124551113,{"v":2939.9,"d":"R2,939.90"},{"v":29399,"d":"R29,399.00"},{"v":26459.1,"d":"R26,459.10"},"Settled. File closed."]
["2025/2026","24/02/2025","13/06/2025","Beauty Matlala","BAR","Mbombela","CE4557","CE4557","Damaged tablet",124487374,{"v":2000,"d":"R2,000.00"},{"v":7176,"d":"R7,176.00"},{"$f":"L21-K21","v":{"v":5176,"d":"R5,176.00"}},"Settled. File closed."]
["2025/2026","26/06/2025","27/06/2025","EC Office","OC","Eastern Cape",null,null,"Fire broke out in EC Office",124562321,{"v":2615.59,"d":"R2,615.59"},{"v":26155.92,"d":"R26,155.92"},{"v":23540.33,"d":"R23,540.33"},"Settled. File closed."]
["2025/2026","12/05/2025","30/06/2025","Vhutshilo Gandamipfa ","BAR",null,"CE4282","CE4282","Damaged Laptop",124562489,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"NTU - NYDA advised that the device is still working and only needed a new charger"]
["2025/2026","02/07/2025","03/07/2025","Promise Sibanyoni","Motor",null,"LF31TD GP","LF31TD GP","Glass claim - hit by small rock while following a truck",124564914,{"v":340.28,"d":"R340.28"},{"v":1361.12,"d":"R1,361.12"},{"v":1020.84,"d":"R1,020.84"},"Settled. File closed."]
["2025/2026","03/01/2025","10/07/2025","Thamsanqa Mthembu","BAR","Sandton","CE3872","CE3872","Stolen Laptop from employee vehicle",124568108,{"v":2369,"d":"R2,369.00"},{"v":23699,"d":"R23,699.00"},{"$f":"L25-K25","v":{"v":21330,"d":"R21,330.00"}},"Settled. File closed."]
["2025/2026","01/08/2025","05/08/2025","Sahluko ","Motor","Free State","JD 34 RG GP","JD 34 RG GP","Head on motor collision accident",124583110,{"v":12530,"d":"R12,530.00"},{"v":250600,"d":"R250,600.00"},{"$f":"L26-K26","v":{"v":238070,"d":"R238,070.00"}},"Settled. File closed."]
["2025/2026","TBA","02/09/2025","Cape Town","Contents",{"$nulls":3},"Lost assets at the Cape Town office",124637979,"TBA","TBA","TBA","29/06/2026: Submitted the replacement quotation, reason for late notification, affidavit, and asset list to OMI. Awaiting NYDA to provide proof of forcible entry/exit\n"]
["2025/2026","18/08/2025","02/09/2025","Polokwane","Contents",null,"ADXM021038444","ADXM021038444","Stolen assets at the Polokwane offcie",124593306,"TBA","TBA","TBA","30/06/2026: Awaiting replacement quotation from NYDA.\n14/07/2026: NYDA advised that their IT department is assisting with the claim and is sourcing the replacement quotation, which will be shared with us as soon as it becomes available.\n30/07/2026: Followed up with NYDA. We are awaiting their response on whether we may proceed with sourcing a replacement quotation on their behalf."]
["2025/2026","18/09/2024",45483,"Ndlela Thulisa","Baggage",{"$nulls":3},"Lost baggage","TBA","TBA","TBA","TBA","Settled. File closed."]
["2025/2026","26/08/2025","18/09/2025","Sechaba Sono","BAR",{"$nulls":3},"Damaged laptop",124601167,{"v":3179.29,"d":"R3,179.29"},{"v":31792.9,"d":"R31,792.90"},{"$f":"L30-K30","v":{"v":28613.61,"d":"R28,613.61"}},"Sent AOL to insurer on 06/08/2026 await POP"]
["2025/2026","30/05/2024","16/10/2025","Ndumiso Ndlovu","BAR",null,"CE4347","CE4347","Damaged laptop",124696529,"TBA","TBA","TBA","Sent reason for late notice, damage report and repair quote to OMI on 25/07/2026 | Awaiting AOL"]
["2025/2026","30/09/2025","16/10/2025","Basani Hlabathi","BAR",null,"CE4287","CE4287","Damaged laptop",124612667,{"v":2000,"d":"R2,000.00"},{"v":9919.9,"d":"R9,919.90"},{"v":7919.9,"d":"R7,919.90"},"Sent AOL to NYDA on 20/07/2026 await signed"]
["2025/2026","04/09/2025","16/10/2025","Philani Zulu","BAR",null,"CE4379","CE4379","Damaged laptop",124612680,"TBA","TBA","TBA","Awaiting damage report and quote, 30/07/2026 sent NYDA a quote for assessments to obtain damage report from Netpoint awaiting their feedback on how to proceed"]
["2025/2026","05/09/2025","16/10/2025","Florence","BAR",null,"CE5022","CE5022","Stolen laptop",124612690,{"v":2286.9,"d":"R2,286.90"},{"v":22869,"d":"R22,869.00"},{"v":20582.1,"d":"R20,582.10"},"Settled. File closed."]
["2025/2026","16/10/2025","24/10/2025","Meldy","BAR",null,"S/N:COGQTV3","S/N:COGQTV3","Stolen laptop",124616631,{"v":4699,"d":"R4,699.00"},{"v":46999,"d":"R46,999.00"},{"v":42299.1,"d":"R42,299.10"},"Settled. File closed."]
["2025/2026","30/09/2025","30/10/2025","Nicholas Mutsi","BAR",null,"CE4133","CE4133","Damaged laptop",124619703,{"v":2000,"d":"R2,000.00"},{"v":12903,"d":"R12,903.00"},{"v":10903,"d":"R10,903.00"},"Sent AOL to insurer on 06/08/2026 await POP"]
["2025/2026","03/11/2025","03/11/2025","Victoria","BAR",null,"CE3870","CE3870","Damaged laptop",124621120,{"v":2000,"d":"R2,000.00"},{"v":2875,"d":"R2,875.00"},{"v":875,"d":"R875.00"},"Sent AOL to insurer on 06/08/2026 await POP"]
["2025/2026","30/10/2025","06/11/2025","Okuhle ","BAR",null,"CE5433","CE5433","Stolen laptop",124623396,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"Claim repudiated due to no proof of violent and forcible entry/exit "]
["2025/2026","11/11/2025","20/11/2025","Ncomeka Magopeni","BAR",null,"CE3539","CE3539","Damaged laptop",124630199,{"v":2000,"d":"R2,000.00"},{"v":2875,"d":"R2,875.00"},{"v":875,"d":"R875.00"},"Sent AOL to insurer on 06/08/2026 await POP"]
["2025/2026","20/11/2025","24/11/2025","N/A","Events",null,"N/A","N/A","Food poisoning at event held on 20 Nov 2025","ITOO/SC/00028404",{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"Claim registered, awaiting LOD from NYDA if any | 30/06/2026 still no LOD received |14/07/2026 NYDA advised we can close the claim due to no LOD/approach received"]
["2025/2026","31/10/2025","02/12/2025","Faith Langeni","BAR",null,"TBA","TBA","Stolen Camera",124636791,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"14/07/2026 NYDA advised that the asset wasn’t tagged therefore not included on FAR thus not insured, NYDA withdrew claim"]
["2025/2026","24/09/2025","02/12/2025","Vuyisile Sibiya","BAR",null,"CE4348","CE4348","Stolen laptop",124637443,{"v":4174.9,"d":"R4,174.90"},{"v":21749,"d":"R21,749.00"},{"v":19574.1,"d":"R19,574.10"},"Settled. File closed."]
["2025/2026","08/12/2025","10/12/2025","Dimakatso Masiteng","BAR",null,"TBA","TBA","Damaged laptop",124642479,{"v":2000,"d":"R2,000.00"},{"v":11822,"d":"R11,822.00"},{"v":9822,"d":"R9,822.00"},"Sent AOL to NYDA on 20/07/2026 await signed"]
["2025/2026","25/11/2025","09/12/2025","Victo Mposula","BAR",null,"CE4175","CE4175","Damaged laptop",124641575,{"v":2000,"d":"R2,000.00"},{"v":18000,"d":"R18,000.00"},{"v":16000,"d":"R16,000.00"},"Sent AOL to insurer on 06/08/2026 await POP"]
["2025/2026","02/12/2025","09/12/2025","Tshiamo Motlahaba","BAR",null,"CE3511","CE3511","Damaged laptop",124641788,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"Claim repudiated due wear and tear | Sent rejection letter to NYDA"]
["2025/2026","26/12/2025","26/12/2025","TBA","FIRE",null,"TBA","TBA","Flooded office due to burst pressure pipe/s",124676783,{"v":15501,"d":"R15,501.00"},{"v":155010,"d":"R155,010.00"},{"$f":"L46-K46","v":{"v":139509,"d":"R139,509.00"}},"Settled. File closed."]
["2025/2026","01/12/2025","12/01/2026","Andile Mbatha","BAR",null,"CE5763","CE5763","Damaged laptop",124653691,{"v":2000,"d":"R2,000.00"},{"v":6969,"d":"R6,969.00"},{"v":4969,"d":"R4,969.00"},"Sent AOL to NYDA on 21/07/2026 await signed for payment"]
["2025/2026","29/01/2026","04/02/2026","Lebjana Mahasha","BAR",null,"CE5061","CE5061","Damaged laptop",124667422,{"v":2000,"d":"R2,000.00"},{"v":7791.25,"d":"R7,791.25"},{"v":5791.25,"d":"R5,791.25"},"Sent AOL to NYDA on 30/07/2026 await signed for payment"]
["2025/2026","10/07/2025","19/08/2025","Alpheus Mosoma","Motor",null,"JD 34 PW GP","JD 34 PW GP","Cracked windscreen claim - GROBESDAL",124586966,{"v":661.3,"d":"R661.30"},{"v":2300,"d":"R2,300.00"},{"v":1638.7,"d":"R1,638.70"},"Settled. File closed."]
["2025/2026","30/07/2025","20/08/2025","Gladys Makwela","Motor",null,"JN 59 BT GP","JN 59 BT GP","Cracked windscreen claim- BUSHBUCKRIDGE",124588036,{"v":1292.67,"d":"R1,292.67"},{"v":4496.25,"d":"R4,496.25"},{"v":3203.58,"d":"R3,203.58"},"Settled. File closed."]
["2025/2026","27/10/2025","19/11/2025","Njabulo","Motor",null,"JN 59 BX GP","JN 59 BX GP","Lost keys",124643496,{"v":894.63,"d":"R894.63"},{"v":8964.25,"d":"R8,964.25"},{"v":8069.62,"d":"R8,069.62"},"Settled. File closed."]
["2025/2026","04/12/2025","09/12/2025","Mawakhazole Nyatela","Motor",null,"KS 08 DY GP","KS 08 DY GP","Shattered windscreen",124641069,{"v":3434.6,"d":"R3,434.60"},{"v":13738.83,"d":"R13,738.83"},{"v":10304.23,"d":"R10,304.23"},"Settled. File closed."]
["2025/2026","05/01/2026","20/01/2026","Kharavho Mandiwana","Motor",null,"JC 19 BG GP","JC 19 BG GP","Minor motor damage (scratch to vehicle)",124658941,{"v":5000,"d":"R5,000.00"},"TBA","TBA","Settled. File closed. However awaiting NYDA to settle excess and collect vehicle"]
[null,"TOTAL ",{"$nulls":8},{"$f":"SUM(K10:K53)","v":{"v":160547.45999999996,"d":"R160,547.46"}},{"$f":"SUM(L10:L53)","v":{"v":1055696.1,"d":"R1,055,696.10"}},{"$f":"SUM(M10:M53)","v":{"v":906152.8399999999,"d":"R906,152.84"}}]
[]
["KEY"]
["DESCRIPTION ","COLOUR"]
["Settled ","Sky Blue "]
["In progress","Yellow"]
["Not yet recognised ","Orange "]
["Proof of forcibly entry required","Green"]
["Rejected","Red"]

{"sheet":"FEB 2026-JAN 2027","index":2,"n_rows":55,"n_cols":13,"rows_kept":55,"merged":[[3,4,3,10],[4,4,4,10],[5,4,5,11]]}
[]
[]
[]
[{"$nulls":4},"NATIONAL YOUTH DEVELOPMENT AGENCY COMMERCIAL POLICY"]
[{"$nulls":4},"PERIOD OF INSURANCE: FEBRUARY 2026 - JANUARY 2027"]
[{"$nulls":4},"CLAIMS HISTORY  REPORT"]
[]
[]
[]
["Insured Year","Date of Loss","Date Registered","User","Section of Cover ","Asset ID","Asset Label"," Description","Claim Number","Excess","Gross","Net","Status"]
["2026/2027","TBA","09/02/2026","WRSETA","FG","N/A","N/A","Fraud claim - WRSETA",124670485,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"Claim falls within excess. File Closed"]
["2026/2027","TBA","09/02/2026","Unathi","FG","N/A","N/A","Fraud -Mr Unathi",124671062,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},"Claim falls within excess. File Closed"]
["2026/2027","03/02/2026","20/02/2026","West Rand office","Contents","TBA","TBA","Rain Damage: Ceilings were damaged and office furniture damaged again",124676783,{"v":15501,"d":"R15,501.00"},{"v":155010,"d":"R155,010.00"},{"$f":"K13-J13","v":{"v":139509,"d":"R139,509.00"}},"Settled. File closed."]
["2026/2027","27/02/2026","09/03/2026","Carol Sefadi","BAR","CE3558","CE3558","When opening the laptop screws started coming out from the right corner",124684077,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","05/09/2025","12/03/2026","Sonwabo Cangci","BAR","CE4540 & CE5385","CE4540 & CE5385","Break in at employee's house",124686574,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","23/03/2026","24/03/2026","Johannes Bosadi","BAR","CE4766","CE4766","Screen not switching on",124692086,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","11/03/2026","30/03/2026","Prudence Cele","BAR","CE3853","CE3853","Laptop was charging employee tripped on cable and the laptop fell with the screen and keyboard dislocating slightly",124694921,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","23/03/2026","02/04/2026","Vutshilo Mudau","BAR","CE4401","CE4401","Description on claim form not clear - awaiting NYDA to send clear description",124692086,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","20/02/2026","10/04/2026","Sphelele Mavuso","BAR","CE4427","CE4427","Tea spilled over onto the laptop",124699580,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","10/02/2026","10/04/2026","Lovington Buthelezi","BAR","CE3704","CE3704","The asset stopped workng and is not charging",124699582,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","20/04/2026","23/04/2026","Rito Mahlangu","BAR","CE4430","CE4430","Laptop swictches off and pressess itself",124705727,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","22/04/2026","28/04/2026","Mannini","BAR","CE4293","CE4293","Laptop stopped working, it switched off while charging",124707910,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","23/04/2026","08/05/2026","Miracle Khoza","BAR","CE4751","CE4751","Suspected wear and tear",124713114,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA. 30/07/2026 sent NYDA quote for obtaining damage report and quote from Netpoint awaiting NYDA to advise they accept the quote so we may issue invoice for payment "]
["2026/2027","05/05/2026","08/05/2026","East London office","TBA","N/A","N/A","Roof leaking",124713127,"TBA","TBA","TBA","15/06/2026 OMI has appointed loss adjuster to conduct and assessment 14/07/2026 awaiting OMI to provide update on status of claim |30/07/2026 f/u with OMI on assessment outcome"]
["2026/2027","06/05/2026","14/05/2026","Busisiwe Nxumalo","BAR","CE3128","CE3128","Cracked screen in the airplane craft",124717684,"TBA","TBA","TBA","30/06/2026 Awaiting pictures, damage report and quote from NYDA | 15/06/2026 Sent NYDA Quote for damage assessemnt reports awaiting feedback on way forward"]
["2026/2027","17/11/2025","21/05/2026","George Olyn","BAR","CE4095","CE4095","The laptop does not switch on",124721765,"TBA","TBA","TBA","30/06/2026 Awaiting pictures, damage report and quote from NYDA | 15/06/2026 Sent NYDA Quote for damage assessemnt reports awaiting feedback on way forward"]
["2026/2027","10/04/2026","29/05/2026","Jabulani Maswanganyi","BAR","CE3969","CE3969","Stolen Tablet and Dell Screen",124726304,"TBA","TBA","TBA","30/06/2026 Awaiting quote from NYDA | 24/07/2026 NYDA advised to send quote as soon as available"]
["2026/2027","28/05/2026","05/06/2026","Zama Msomi","EE","CE5294","CE5294","Damaged screen",124729869,"TBA","TBA","TBA","30/06/2026 Awaiting pictures, damage report and quote from NYDA | 15/06/2026 Sent NYDA Quote for damage assessemnt reports awaiting feedback on way forward"]
["2026/2027","02/05/2026","10/06/2026","Musa Mthombeni","BAR","CE5380","CE5380","Suspected car jamming",124732204,"TBA","TBA","TBA"," Awaiting quote from NYDA"]
["2026/2027","17/06/2026","24/06/2026","Nkileng Nyembe","BAR","CE3835","CE3835","Laptop switched itself off and flips different screens at a time tehn it shut down",124738069,"TBA","TBA","TBA","30/06/2026 Awaiting NYDA to send photos of the damaged asset, damage report and quote"]
["2026/2027","26/12/2025","01/07/2026","Westrand Office","OC","TBA","TBA","water damage caused by a burst pipe, which occurred during the festive period when the premises were unoccupied. The escape of water resulted in damage to carpets, walls, skirtings, and certain office furniture.",124737484,{"$f":"K31-L31","v":{"v":11617.930000000008,"d":"R11,617.93"}},{"v":116179.27,"d":"R116,179.27"},{"v":104561.34,"d":"R104,561.34"},"Sent AOL to Nyda ON 21/07/2026 Await signed for payment"]
["2026/2027","29/06/2026","17/07/2026","Isaac Shilangu","BAR","CE4366","CE4366","Laptop does not switch on it flickers",124749508,"TBA","TBA","TBA","Awaiting damage report and quote"]
["2026/2027","24/06/2026","24/07/2026","Shamadie Mlundi","BAR","CE4518","CE4518","Tablet slipped and fell","TBA","TBA","TBA","TBA","Awaiting damage report and quote"]
["2026/2027","06/02/2026","17/02/2026","Doreen Mogashoa","Motor","JN 59 CH GP","JN 59 CH GP","Damaged winscreen",124675432,"TBA","TBA","TBA","Settled. File closed."]
["2026/2027","03/02/2026","11/03/2026","Promise Sibanyoni","Motor","LF 31 TD GP","LF 31 TD GP","Damaged sunroof ",124686077,"TBA","TBA","TBA","Claim amount falls within excess"]
["2026/2027","21/04/2026","13/05/2026","Thuso Motankisi","Motor","LS 58 FG GP","LS 58 FG GP","Motor accident",124716425,"TBA","TBA","TBA","Authorisation issued to SP. Vehicle booked in on 09/06/2026; repairs delayed due to parts on back order. As at 30/06/2026, booking date TBC pending supplier ETA. 14/07/2026 Parts are on back order , we are awaiting an ETA from the supplier then we can book the vehicle for repair. 31/07/2026 According to the repairer, they are still awaiting the required parts. Unfortunately, there is currently no estimated arrival date available."]
["2026/2027","29/06/2026","07/07/2026","Jabulile Shongwe","Motor","JN 59 BT GP","JN 59 BT GP","Motor accident",124745000,"TBA","TBA","TBA","Awaiting NYDA to take the vehicle to Chris Craft for assessment. quotes and pictures. 30/07/2026 followed with NYDA if they have taken in the vehicle awaiting response."]
["2026/2027","TBA","TBA","TBA","Motor","JN 59 BT GP","JN 59 BT GP","Lost keys","TBA","TBA","TBA","TBA","Awaiting NYDA to provide incident report. 30/07/2026 followed up with NYDA awaiting response"]
["2026/2027","TBA","TBA","TBA","Motor","JN 59 CC GP","JN 59 CC GP","Lost keys","TBA","TBA","TBA","TBA","Awaiting NYDA to provide incident report. 30/07/2026 followed up with NYDA awaiting response"]
["2026/2027","TBA","TBA","TBA","Motor","KS 08 DY GP","KS 08 DY GP","Lost keys","TBA","TBA","TBA","TBA","Awaiting NYDA to provide incident report. 30/07/2026 followed up with NYDA awaiting response"]
["2026/2027","TBA","TBA","TBA","Motor","LF 85 MF GP","LF 85 MF GP","Lost keys","TBA","TBA","TBA","TBA","Awaiting NYDA to provide incident report. 30/07/2026 followed up with NYDA awaiting response"]
["2026/2027","TBA","TBA","TBA","Motor","JF 49 YW GP","JF 49 YW GP","Lost keys","TBA","TBA","TBA","TBA","Awaiting NYDA to provide incident report. 30/07/2026 followed up with NYDA awaiting response"]
["2026/2027","TBA","TBA","TBA","Motor","HM 34 JY GP","HM 34 JY GP","Lost keys","TBA","TBA","TBA","TBA","Awaiting NYDA to provide incident report. 30/07/2026 followed up with NYDA awaiting response"]
["2026/2027","10/06/2026","04/08/2026","Trudy","BAR","CE5056","CE5056","Laptop buttop don’t respond when pressed",124756691,"TBA","TBA","TBA","Awaiting damage report and quote from NYDA"]
["2026/2027","30/06/2026","23/07/2026","Walter Bango","BAR","TBA","TBA","There was a crack then it expnaded from the screen ",124752246,"TBA","TBA","TBA","Awaiting incident report ,damage report and quote form NYDA"]
["2026/2027","24/06/2026","04/08/2026","Noluthando Ngcwabe-Cokile","BAR","TBA","TBA","Car broken into and laptop stolen",124756703,"TBA","TBA","TBA","Awaiting quote from NYDA"]
[null,"TOTAL ",{"$nulls":7},{"$f":"SUM(J11:J43)","v":{"v":27118.930000000008,"d":"R27,118.93"}},{"$f":"SUM(K11:K43)","v":{"v":271189.27,"d":"R271,189.27"}},{"$f":"SUM(L11:L43)","v":{"v":244070.34,"d":"R244,070.34"}}]
[]
["KEY"]
["DESCRIPTION ","COLOUR"]
["Settled ","Sky Blue "]
["In progress","Yellow"]
["Not yet recognised ","Orange "]
["Proof of forcibly entry required","Green"]
["Rejected","Red"]

{"sheet":"Travel","index":3,"n_rows":26,"n_cols":11,"rows_kept":26,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10]]}
["NYDA COMMERCIAL POLICY"]
["PERIOD OF INSURANCE: FEBRUARY 2024 - JANUARY 2027"]
["CLAIMS HISTORY REPORT"]
["Insured Year","Date of Loss","Date Registered","User","Section of Cover ","Location"," Description","Gross Amount","Excess","Net Amount","Status"]
["2024/2025","18/09/2024","07/10/2024","Ndlela Thulisa","Delayed Luggage","Durban","Lost baggage",{"v":2234.53,"d":"R2,234.53"},{"v":0,"d":"R0.00"},{"v":2234.53,"d":"R2,234.53"},"Settled"]
["2026-2027","21/06/2026","23/07/2026","Mellon Ncube","Lost luggage","China","Lost perfume from luggage","TBA","TBA","TBA","Awaiting insurer to register claim and revert with required details for validation"]
{"$rows_empty":16}
["DESCRIPTION","COLOUR"]
["Settled","Green"]
["In-progress","Yellow"]
["Rejected","Red"]