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

{"sheet":"Summary","index":0,"n_rows":359,"n_cols":7,"rows_kept":359,"merged":[[2,0,2,4],[4,1,4,4],[6,3,6,4],[337,1,337,2],[338,1,338,2],[339,1,339,2],[340,1,340,2],[341,1,341,2],[342,1,342,2],[354,1,354,4]]}
[]
[]
["Tswelopele Local Municipality"]
[]
[null,"SHORT TERM INSURANCE SUMMARY"]
[]
[null,"Period of Insurance",null,"01 July 2023  -  30 June 2024"]
[]
[{"$nulls":3},"RENEWAL 2023/2024"]
[null,"SECTION",null,"SUM INSURED"]
[null,"Combined"]
[null," - Standard Constructed Buildings ",null,{"v":413398293,"d":"R 413,398,293"}]
[null," - Standard Constructed Buildings (Contents)"]
[null," - Sub-stations, mini sub-stations, transformers, etc."]
[null," - Property in the open "]
[null," - Water purification works and pump stations"]
[null," - Sewerage Works and Pumps Station"]
[null," - Property More Specifically Insured"]
[null," - Reservoirs"]
[null," - Non Standard Constructed Buildings  (Thatch)",null,{"v":16931372,"d":"R 16,931,372"}]
[null," - Non Standard Constructed Buildings (Contents)"]
[null," - Property More Specifically Insured Non Standard"]
[null," - Private dwellings, residential units hostels, Flats",null,{"v":7569028,"d":"R 7,569,028"},null,null,{"$f":"SUM(D12:D23)","v":{"v":437898693,"d":"R 437,898,693"}}]
[null," -Escalation 15%",null,{"v":503583497,"d":"R 503,583,497"}]
[null," - Capital Additions 20%",null,{"v":525478431,"d":"R 525,478,431"}]
[]
[]
[]
[]
[null,"Extensions"]
[null," - Subsidence and Landslip",null,"Yes"]
[null," - Sum insured",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Motor Vehicles whilst parked at Insured",null,"Yes"]
[null," - Sum insured",null,{"v":5000000,"d":"R 5,000,000"}]
[null," - Riot and Strike (other than RSA and Namibia)",null,"No"]
[null," - Leakage of oils, chemicals or other fluids",null,"Yes"]
[null," - Wash basins and Sanitary Ware",null,"Yes"]
[null," - Thatch structures unless specifically insured ",null,"R 100 000 Max Annual Limit"]
[null," - Theft of immovable property",null,{"v":5000000,"d":"R 5,000,000"}]
[null," - Malicious damage caused by thieves",null,{"v":5000000,"d":"R 5,000,000"}]
[null," - Reasonable Precautions",null,{"v":10000,"d":"R 10,000"}]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[]
[null,"Additional Sasria Extensions",null,null,"Must be shown on Sasria summary"]
[null," - Professional Fees",null,{"v":5000000,"d":"R 5,000,000"},"Include Sasria Calculations"]
[null," - Clearance cost",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Security Cost",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Statutory Duties",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Fire Protection System update",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Goods in the open",null,{"v":5000000,"d":"R 5,000,000"}]
[null," - Fir Extinguishing",null,{"v":5000000,"d":"R 5,000,000"}]
[null," - Motor Vehicles whilst parked",null,{"v":5000000,"d":"R 5,000,000"}]
[]
[null,"TOTAL BUILDING COMBINED",null,{"$f":"SUM(D12:D42)","v":{"v":1483070621,"d":"R 1,483,070,621"}}]
[]
[null,"Business Interruption "]
[null,"Indemnity period : 12 months"]
[null," - Electricity",null,{"v":349376490,"d":"R 349,376,490"}]
[null," - Accommodation Income",null,0]
[null," - Increase in Cost of Working",null,{"v":5000000,"d":"R 5,000,000"}]
[null," - Additional Increase in Cost of Working",null,{"v":5000000,"d":"R 5,000,000"}]
[]
[null,"Extensions"]
[null," - Specified suppliers / sub-contractors",null,"No"]
[null," - Sum insured",null,"R"]
[null," - Unspecified suppliers / sub-contractors",null,"No"]
[null," - Sum insured",null,"R"]
[null," - Specified Customers",null,"No"]
[null," - Sum insured",null,"R"]
[null," - Public Utilities",null,"Yes"]
[null," - Sum insured",null,"R 1000000"]
[null," - Fines and Penalties",null,0]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL BUSINESS INTERRUPTION",null,{"$f":"SUM(D58:D73)","v":{"v":359476490,"d":"R 359,476,490"}}]
[]
[null,"Office Contents"]
[null,"General Contents ",null,{"v":2476160,"d":"R 2,476,160"}]
[null,"Theft @ 25% included",null,{"v":500000,"d":"500,000"}]
[null,"Loss of Documents ",null,{"v":500000,"d":"R 500,000"}]
[null,"Legal Liability",null,0]
[null,"Increase in Cost of Working ",null,{"v":534750,"d":"R 534,750"}]
[null,"Resonable Costs",null,{"v":10000,"d":"R 10,000"}]
[null,"Locks and Keys ",null,{"v":10000,"d":"R 10,000"}]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL OFFICE CONTENTS",null,{"$f":"SUM(D77:D84)","v":{"v":4130910,"d":"R 4,130,910"}}]
[]
[null,"ACCIDENTAL DAMAGE "]
[null,"Limit of Indemnity",null,{"v":1000000,"d":"R 1,000,000"}]
[null,"Total Value of Property ",null,{"$f":"SUM(D12,D20,D23,D77)","v":{"v":440374853,"d":"R 440,374,853"}},null,null,{"$f":"E89*F89","v":0}]
[null,"TOTAL ACCIDENTAL DAMAGE",{"$nulls":4},{"$f":"SUM(G88:G89)","v":0}]
[]
[]
[null,"Accounts Receivable"]
[null," - Outstanding Debit Balances",null,{"v":10000000,"d":"R 10,000,000"}]
[]
[null,"Extensions"]
[null," - Duplicate Records",null,"No"]
[null," - Protections",null,"No"]
[null," - Riot and Strike (other than RSA and Namibia)",null,"No"]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL ACCOUNTS RECEIVABLE",null,{"$f":"SUM(D94:D100)","v":{"v":10100000,"d":"R 10,100,000"}}]
[]
[null,"Business All Risks"]
[null," - All other specified items (excluding Cellphones & Laptops)",null,{"v":735749,"d":"R 735,749"}]
[null," - Cell-Phones",null,0]
[null," - Laptops ",null,{"v":1435081,"d":"R 1,435,081"}]
[{"$nulls":3},0]
[]
[null,"Extensions"]
[null," - Increase in Cost of Working",null,"Yes"]
[null," - Sum insured",null,{"v":100000,"d":"R 100,000"}]
[null," - Riot and Strike (other than RSA and Namibia)",null,"No"]
[null," - Locks and Keys",null,{"v":10000,"d":"R 10,000"}]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL BUSINESS ALL RISKS",null,{"$f":"SUM(D104:D114)","v":{"v":2380830,"d":"R 2,380,830"}}]
[]
[null,"Theft"]
[null," - First Loss Limit",null,{"v":50000,"d":"R 50,000"}]
[]
[null,"Extensions"]
[null," - Property in the open (within securely fenced off area and subject to forcible and violent entry or exit from such area)",null,{"v":50000,"d":"R 50,000"}]
[null," - Theft of employee property",null,{"v":2000,"d":"R 2,000"}]
[null," - Malicious Damage",null,{"v":100000,"d":"R 100,000"}]
[null," - Reasonable Precautions",null,{"v":20000,"d":"R 20,000"}]
[null," - Locks and Keys",null,{"v":10000,"d":"R 10,000"}]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL THEFT",null,{"$f":"SUM(D118:D126)","v":{"v":332000,"d":"R 332,000"}}]
[]
[null,"Glass"]
[null," - All fixed internal & external glass at the premises ",null,{"v":30000,"d":"R 30,000"}]
[]
[null,"Extensions"]
[null," - Riot and Strike (other than RSA and Namibia)",null,"No"]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL GLASS",null,{"$f":"SUM(D130:D134)","v":{"v":130000,"d":"R 130,000"}}]
[]
[null,"Money"]
[null," - Possession of Councilors/Employees away from insured"]
[null,"   premises on a business trip",null,{"v":5000,"d":"R 5,000"}]
[null," - On the premises outside business hours in locked"]
[null,"   safe",null,{"v":5000,"d":"R 5,000"}]
[null," - Loss of or damage to crossed cheques, money or postal",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Major limit",null,{"v":200000,"d":"R 200,000"}]
[null," - Seasonal",null,0]
[null," - Receptacles as a result of theft of money or attempt ",null,{"v":20000,"d":"R 20,000"}]
[]
[null,"Extensions"]
[null," - Locks and keys",null,{"v":5000,"d":"R 5,000"}]
[null," - Reasonable precautions",null,{"v":20000,"d":"R 20,000"}]
[null," - Credit cards",null,0]
[null," - Personal Accident ( Assault)"]
[null,"       Capital Sum",null,{"v":25000,"d":"R 25,000"}]
[null,"       Weekly Amount",null,{"v":2000,"d":"R 2,000"}]
[null,"       Medical Expenses",null,{"v":10000,"d":"R 10,000"}]
[null," - Riot and Strike (other than RSA and Namibia)",null,"No"]
[null," - Electronic Vending machines",null,0]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL MONEY",null,{"$f":"SUM(D139:D157)","v":{"v":1392000,"d":"R 1,392,000"}}]
[]
[null,"Fidelity Guarantee"]
[null," - Limit any one period ",null,{"v":100000,"d":"R 100,000"}]
[]
[null,"Extensions"]
[null," - Retroactive Cover",null,"01.07.2018"]
[null," - Superseded Policy",null,"No"]
[null," - Reinstatement Amount",null,"Yes (1x)"]
[null," - Cost of Recovery",null,0]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL FIDELITY GUARANTEE",null,{"$f":"SUM(D161:D168)","v":{"v":200000,"d":"R 200,000"}}]
[]
[]
[null,"Goods in Transit"]
[null," - Load Limit",null,{"v":100000,"d":"R 100,000"}]
[]
[null,"Extensions"]
[null," - Removal of Debris",null,{"v":50000,"d":"R 50,000"}]
[null," - Fire, Explosion, Collision and overturning ",null,{"v":20000,"d":"R 20,000"}]
[null," - Fire Extinguishing Expense",null,{"v":10000,"d":"R 10,000"}]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL GOODS IN TRANSIT",null,{"$f":"SUM(D173:D179)","v":{"v":280000,"d":"R 280,000"}}]
[]
[null,"Group Personal Accident - Business Hours"]
[null," - Councilors ",null,15]
[null," - Temporary staff - Volunteers",null,0]
[]
[]
[null,"Benefits"]
[null," - Death   - Councilors",null,{"v":150000,"d":"R 150,000"}]
[null," - Death    - Temporary Staff Volunteers",null,0]
[null," - Permanent Disability",null,"% of Death benefit as specified for particular disability"]
[null," - Temporary Total Disablement",null,"R 1 000 per week max 104 weeks"]
[null," - Medical expenses",null,{"v":20000,"d":"R 20,000"}]
[null," - Additional death benefit",null,{"v":10000,"d":"R 10,000"}]
[null," - Relocation",null,{"v":10000,"d":"R 10,000"}]
[null," - Repatriation",null,{"v":10000,"d":"R 10,000"}]
[null," - Mobility",null,{"v":10000,"d":"R 10,000"}]
[]
[null,"Extensions"]
[null," - War Risks",null,"No"]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null," - Maximum Limit Any One Life",null,"R 2 000 000.00"]
[null," - Maximum Limit Any One event ( Accumulation Limit)",null,"R 10 000 000.00"]
[null,"TOTAL GROUP PERSONAL ACCIDENT"]
[]
[null,"Stated Benefits "]
[null,"(A) All Employees (24 Hours)",null,{"v":41601600,"d":"R 41,601,600"}]
[]
[null,"Benefits"]
[null," - Death",null,"3 x Annual earnings"]
[null," - Permanent Disability",null,"% of Death benefit as specified for particular disability"]
[null," - Temporary Total Disablement",null,"100% of average weekly earnings max 104 weeks"]
[null," - Medical Expenses",null,{"v":20000,"d":"R 20,000"}]
[null," - Additional death benefits",null,{"v":10000,"d":"R 10,000"}]
[null," - Relocation",null,{"v":10000,"d":"R 10,000"}]
[null," - Repatriation",null,{"v":10000,"d":"R 10,000"}]
[null," - Mobility",null,{"v":10000,"d":"R 10,000"}]
[]
[null,"Extensions"]
[null," - War Risks",null,"No"]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null," - Maximum Limit Any One Life",null,"R 2 000 000.00"]
[null," - Maximum Limit Any One event ( Accumulation Limit)",null,"R 10 000 000.00"]
[null,"TOTAL STATED BENEFITS"]
[]
[null,"Electronic Equipment"]
[null," - Specified Equipment  ",null,{"v":2838944.43,"d":"R 2,838,944"}]
[null," - Laptops",null,{"v":1453081.28,"d":"R 1,453,081"}]
[null," - Software & Licenses",null,0]
[null," - HP Deskjet Printers",null,0]
[]
[null,"Extensions"]
[null," - Prevention of Access",null,"No"]
[null," - Increase in Cost of Working",null,{"v":120000,"d":"R 120,000"}]
[null," - Reconstruction of Data",null,{"v":120000,"d":"R 120,000"}]
[null," - Incompatibility",null,"Yes"]
[null," - Telkom access line",null,"Yes"]
[null," - Utilities ( Failure of supply)",null,"No"]
[null," - Riot and Strike (other than RSA and Namibia)",null,"No"]
[null," - Claims Preparation Costs",null,{"v":100000,"d":"R 100,000"}]
[null,"TOTAL ELECTRONIC EQUIPMENT",null,{"$f":"SUM(D226:D239)","v":{"v":4632025.71,"d":"R 4,632,026"}}]
[]
[]
[null,"Motor fleet Own Damage - value up to R500 000 - Comprehensive"]
[]
[null,"   - Private type motor cars ,LDV's and Minibuses seating up to 16 persons",null,7]
[null," - Commercial vehicles"]
[null,"    LDV's",null,17]
[null,"    Trucks",null,6]
[null,"    Fire Engines",null,0]
[null,"    Ambulances",null,0]
[null,"    Tractors",null,20]
[null,"    Emergency Vehicles/Buses",null,0]
[null,"    Compressors",null,"See Implements"]
[null,"    Motor Cycles",null,0]
[null,"    Trailers",null,51]
[null,"    Implements",null,0]
[null,"    Lawnmowers",null,"See Implements"]
[null,"    Satellite vehicles",null,0]
[null,"    Special type vehicles (road marking & construction vehicles, machinery, refuse removal, waste compactors etc.)",null,2]
[null,"    High value vehicles (First R 500 000.00) ",null,3]
[null," - Car Hire ",null,5]
[]
[null,"Extensions"]
[null," - Wreckage removal ",null,{"v":25000,"d":"R 25,000"}]
[null," - Fire extinguishing expenses",null,{"v":25000,"d":"R 25,000"}]
[null," - Medical expenses (per occupant)",null,{"v":5000,"d":"R 5,000"}]
[null," - Loss of keys",null,{"v":10000,"d":"R 10,000"}]
[null," - Conveyance of explosives",null,"No"]
[null," - Theft or attempted theft of radios/sound equipment",null,{"v":10000,"d":"R 10,000"}]
[null," - Theft or attempted theft of telephones ",null,{"v":10000,"d":"R 10,000"}]
[null,"   (excluding cellphones)"]
[null," - Claims preparation costs",null,"R 100 000"]
[null,"TOTAL MOTOR OWN DAMAGE",null,{"$f":"SUM(D245:D261)","v":111}]
[]
[null,"TOTAL ASSETS PREMIUM"]
[]
[]
[]
[null,"LIABILITIES"]
[]
[null,"Public Liability"]
[null," - Primary Policy Limit",null,{"v":50000000,"d":"R 50,000,000"}]
[null," - Salary & Wages",null,{"$f":"D206","v":{"v":41601600,"d":"R 41,601,600"}}]
[null,"TOTAL Public Liability",null,{"$f":"SUM(D282:D283)","v":{"v":91601600,"d":"R 91,601,600"}}]
[]
[null,"Sub-limits"]
[null," - Wrongful Arrest and defamation",null,{"v":2250000,"d":"R 2,250,000"}]
[null," - Errors & omissions",null,{"v":2250000,"d":"R 2,250,000"}]
[null," - Products liability and defective workmanship",null,{"v":2250000,"d":"R 2,250,000"}]
[null," - Pedal Cycles",null,"Market value"]
[null," - Legal Defense costs",null,{"v":2250000,"d":"R 2,250,000"}]
[null," - Professional Liability in respect of Medical Practitioners or other Medical officials",null,{"v":2250000,"d":"R 2,250,000"}]
[null," - Spread of fire",null,{"v":20000000,"d":"R 20,000,000"}]
[null," - Municipal Police liability",null,{"v":2000000,"d":"R 2,000,000"}]
[null," - Sub-limit use of firearms",null,{"v":250000,"d":"R 250,000"}]
[null," - Sub-limit wrongful arrest & defamation",null,{"v":250000,"d":"R 250,000"}]
[]
[null,"Employers Liability"]
[null," - Limit",null,{"v":25000000,"d":"R 25,000,000"}]
[null,"TOTAL Employers Liability",null,{"$f":"SUM(D299)","v":{"v":25000000,"d":"R 25,000,000"}}]
[]
[]
[null,"Motor Third party Liability"]
[null," - Limit",null,{"v":2500000,"d":"R 2,500,000"}]
[null," - Number of vehicles  ",null,103]
[null,"TOTAL Motor Third Party Liability",null,{"$f":"D304","v":{"v":2500000,"d":"R 2,500,000"}}]
[]
[null,"TOTAL LIABILITY PREMIUM"]
[]
[null,"GRAND TOTAL"]
[]
[]
[null,"MOTOR  OWN DAMAGE OVER R 500 000.00 MOTOR XOL",null,{"v":3100000,"d":"R 3,100,000"}]
[null,"TOTAL SUM INSURED IN EXCESS OF R 500 000.00"]
[]
[]
[null,"SASRIA ",null,null,"Please add Sasria calculations to the tender"]
[null,"Non Motor"]
[null,"Buildings and Contents",null,{"$f":"SUM(D12,D20,D23,D77)","v":{"v":440374853,"d":"R 440,374,853"}}]
[null,"Business All Risk",null,{"$f":"SUM(D104,D106)","v":{"v":2170830,"d":"R 2,170,830"}}]
[null,"Glass ",null,{"v":30000,"d":"R 30,000"}]
[null,"Money ",null,{"v":155000,"d":"R 155,000"}]
[null,"Goods In Transit",null,{"v":100000,"d":"R 100,000"}]
[null,"Electronic Equipment",null,{"$f":"SUM(D226:D227)","v":{"v":4292025.71,"d":"R 4,292,026"}}]
[null,"EXTENSIONS"]
[null," -Escalation 15%",null,{"$f":"D24","v":{"v":503583497,"d":"R 503,583,497"}}]
[null," - Capital Additions 20%",null,{"$f":"D25","v":{"v":525478431,"d":"R 525,478,431"}}]
[null," - Professional Fees",null,{"v":5000000,"d":"R 5,000,000"}]
[null," - Clearance cost",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Security Cost",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Statutory Duties",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Fire Protection System update",null,{"v":1000000,"d":"R 1,000,000"}]
[null," - Goods in the open",null,{"v":5000000,"d":"R 5,000,000"}]
[null," - Fir Extinguishing",null,{"v":2000000,"d":"R 2,000,000"}]
[null," - Motor Vehicles whilst parked",null,{"v":5000000,"d":"R 5,000,000"}]
[]
[null," Motor"]
[null,"Sedans and Mini Busses",null,7,{"v":2607478.41,"d":"2,607,478.41"}]
[null,"LDV'S",null,17,{"v":2259900,"d":"2,259,900.00"}]
[null,"Heavy Commercial",null,6,{"v":1900000,"d":"1,900,000.00"}]
[null,"Tractors",null,20,{"v":5065875,"d":"5,065,875.00"}]
[null,"Trailers",null,51,{"v":2778965,"d":"2,778,965.00"}]
[null,"Special Type/ Plant",null,2,{"v":2900000,"d":"2,900,000.00"}]
[]
[]
[]
[null,"SASRIA COUNCILORS"]
[null,"Buildings and Contents ",null,{"v":1500000,"d":"R 1,500,000"},"15"]
[null,"Vehicles ",null,"15      Private "]
[null,"Vehicles ",null,0]
[]
[null,"COMPULSORY INSURANCE RELATED DOCUMENTS "]
[null,"FIA CERTIFICATE "]
[null,"FSB CERTIFICATE "]
[null,"SANAS APPROVED ISO 9001 CERTIFICATION  (The provision of financial services in Short Term Insurance)"]
[null,"IRMSA CERTIFICATE "]
[null,"PROFESSIONAL INDEMNITY INSURANCE ",null,"Minimum limit R 100 000 000"]
[null,"FIDELITY INSURANCE ",null,"Minimum limit R 50 000 000"]
[null,"LETTER OF GOOD STANDING DEPT OF LABOR"]