{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Marketing Material","Proposal Form","UWlimits and Glossary","Questionaire - Property ","Questionaire - Liability","Questionaire - WIC","Tax Invoice","Quotation Slip","Pricing ","WICA","Quotation Slip (old)","Cover Note","Welcome Email","Receipt","Renewal Notice","Certificate of Insurance","Claims Form","Template","Dropdown","Data","Policy Schedule_v2","Policy Management Data","Debit Note","Finance Data","Endorsement Schedule"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":14,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Marketing Material","index":0,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":true,"merged":[[32,0,32,5],[2,0,2,5],[3,0,3,2],[3,3,3,4],[16,2,17,2],[14,0,14,5]]}
["TO INCLUDE THE PDF COPY HERE"]
[]
["ACE Risk Appetite"]
["Preferred Industries",null,null,"Will Consider (with more information*)",null,"Non-preferred Industries"]
["Food & Beverage",null,"Restaurants, Cafes, Food stalls, Takeaway kiosks, Pubs","Manufacturing","Clothes, Shoes, Consumer electronics, Home applicances, Food (<EUR 20 mil), Medical Supplies, Jewellery, Metal prodcuts/steel strutural component, Signs and advertising displays, Bakery products, Fibreglass/fibreglass products, Electronic machinery/apparatus/appliances and supplies","Manufacturing of Chemical, Glass, Wood, Food (>EUR 20 mil)"]
["Beauty Salon/Spas",null,"Facial, Massage parlours, Mani/Pedi, Hairsalons, Slimming centres, Spas, Fitness centres","Wholesale","Food and Drinks (Frozen, Meat, Poultry, Eggs, Seafood, Beverages, Liquor), Fruits, Vegetables, Health supplements, Clothes, Shoes, Consumer electronics, Home appliances, Furniture, Sporting goods and equipment, Bags and luggages, Lightings, Vehicles parts and accessories, Security and fire-fighting equipment, Software, Liquor/Soft drinks/Beverages","Explosives/Flameable materials"]
["Retail",null,"Apparel and Accessory stores,\nHome Furnishings  &  Equipment stores,\nStores in shopping malls, Chain Stores, Motor Vehicles Showroom","Hotels","Boutique hotels","Rubber"]
["Office",null,"Consultancy firms,  Accounting & Legal, Representative offices, Architectural & Engeineering Services, Investment & Securities, Insurance Financial institutions - Banks, Investment, Advisory Services and Administrative Services, IT services","Installation and Renovation","Interior Designer, A&A Contractors, Industrial machinery and equipment","Plastics"]
["Education",null,"Preschools, Childcare centres, Primary Schools, Secondary Schools, Tuition centres","Services","Courier services, Self-operated and retail laundry services","Carpets"]
["Healthcare",null,"Health Clinics (Dental, General Practitioner, Specialist)","Religious Organizations","Churches, Temples, Associations","Paper"]
[null,null,null,null,null,"Toxic and hazardous waste treatment"]
["* Please use our comprehensive questionaire forms where necessary"]
[]
[]
["ACE Coverage"]
["Benefit","Mandatory / Optional ?","U/W guidelines","Comments"]
["Property (All Risks / Fire & Extraneous Perils)","Mandatory",45000000,"Comments"]
["Business Interruption","Optional",null,"Comments"]
["Glass","Optional","up to 10% of Property TSI","Comments"]
["Burglary","Optional","up to 10% of Property TSI","Comments"]
["Electronic Equipment ","Optional",45000000,"Comments","Comments"]
["Goods-in-Transit","Optional",10000000,"Comments","- minimum premium"]
["Money","Optional",250000,"Comments","Comments"]
["Fidelity Guarantee","Optional",350000,"Comments","Comments"]
["Public Liability","Optional",10000000,"Comments","Comments"]
["Products Liability","Optional",2000000,"Comments","Comments"]
["Work Injury Compensation","Optional","Medical Expense: $75,000\n$10,000,000 under Common Law","Comments","Comments"]
["Personal Accident","Optional","Accidental Death and Permanent Disability: $1,000,000 \nMedical Expense: $1,500\nPersons: 50","Comments","Comments"]
["Machinery Breakdown","Optional","Machinery Breakdown: up to 5% of Property TSI or $2,000,000 \nDeterioration of Stock: $250,000 ","Comments","Comments"]
["Any limits beyond the above stated, please refer to UW"]
[]
[]
["ACE General Information"]
["Commission",0.25]
["Minimum Premium","of $1000 applies as a whole policy"]
["Cancellation","If have claim, no refund.\nIf no claim, prorate refund, subject to minimum premium"]
["Follow MCP","If Property or Liability must key information into MCP to generate the pricing"]

{"sheet":"Proposal Form","index":1,"n_rows":171,"n_cols":19,"rows_kept":171,"cut":false,"hidden":false,"merged":[[128,1,128,4],[129,1,129,4],[133,1,133,4],[132,5,132,7],[130,5,130,7],[132,1,132,4],[130,1,130,4],[131,1,131,4],[133,5,133,7],[128,5,128,7],[170,2,170,6],[158,1,158,9],[159,1,159,9],[160,1,160,9],[161,1,161,9],[162,1,162,9],[163,1,163,9],[164,2,164,9],[165,2,165,9],[2,1,2,9],[118,1,118,4],[15,7,15,9],[14,7,14,9],[12,7,12,9],[11,7,11,9],[13,7,13,9],[6,7,6,9],[5,7,5,9],[7,7,7,9],[118,5,118,7],[115,6,115,9],[50,5,50,9],[121,5,121,7],[120,5,120,7],[122,5,122,7],[124,5,124,7],[119,5,119,7],[119,1,119,4],[127,1,127,4],[120,1,120,4],[121,1,121,4],[123,1,123,4],[125,1,125,4],[122,1,122,4],[124,1,124,4],[126,1,126,4],[125,5,125,7],[127,5,127,7],[129,5,129,7],[131,5,131,7],[123,5,123,7],[126,5,126,7]]}
["Proposal Form",null,null,null,null,null,null,null,null,"Allianz Commercial EDGE"]
["IMPORTANT NOTICE"]
[1,"Statement pursuant to Section 25(5) of the Insurance Act (Cap 142) or any amendments thereof. You are to disclose in this Proposal Form fully and faithfully, all the facts which you know or ought to know, otherwise the Policy issued may be void."]
[2,"Allianz Insurance Singapore Pte. Ltd. (Insurer)  reserves the right to request for more information."]
[]
["Intermediary"]
["Intermediary Code (for Allianz internal use)"]
["Distribution Channel (for Allianz internal use)"]
[]
[]
["1. Policy Details"]
["Insured Name"]
["UEN"]
["ISIC"]
["Business Address"]
["Nature of Business (ACRA)"]
["Period of Insurance (dd/mm/yyyy)",null,null,null,null,null,null,null,"to ",null,"both dates inclusive"]
[]
["2. Benefits"]
["Property",null,null,null,null,"(up to SGD50mil for Property + Business Interruption HG1-4.  Up to SGD20mil for Property + Business Interruption HG5.  Higher sum insured will be subjected to further underwriting review)"]
[null,null,null,null,null,null,null,null,null,"Location 1","Location 2","Location 3","Location 4"]
["Type of Cover"]
["Age of Building "]
["Location of Risk"]
["Postal Code"]
["Occupied as"]
[null,"If others, please enter in details"]
[]
["Total Sum Insured (Please specify below if others):",null,null,null,null,null,null,null,null,{"$f":"SUM(J30:J35)","v":0},{"$f":"SUM(K30:K35)","v":0},{"$f":"SUM(L30:L35)","v":0},{"$f":"SUM(M30:M35)","v":0},{"$f":"SUM(N30:N35)","v":0},{"$f":"SUM(O30:O35)","v":0},0,0,0,0]
["Contents"]
["Stocks"]
["Plant & Machinery"]
["Furniture, Fixtures and Fittings"]
["Building"]
[]
["Deductible (Please specify below if necessary)"]
["Each and every loss",null,null,null,null,null,null,null,null,1000,"(for internal use)"]
[]
[]
["Protection Systems"]
["Fully Sprinklered",null,null,null,null,null,null,null,null,"Yes"]
["Smoke Detectors",null,null,null,null,null,null,null,null,"Yes"]
["Hosereel",null,null,null,null,null,null,null,null,"Yes"]
["Fire Extinguishers",null,null,null,null,null,null,null,null,"Yes"]
["Fire Alarm",null,null,null,null,null,null,null,null,"Yes"]
["Burglary Alarm",null,null,null,null,null,null,null,null,"Yes"]
["Electrical Protection",null,null,null,null,null,null,null,null,"Yes"]
["24-hour Security Guard Protection",null,null,null,null,null,null,null,null,"Yes"]
[]
["SECTION 3 - OPTIONAL BENEFITS"]
["Business Interruption",null,null,null,null,"(up to SGD50mil for Property + Business Interruption HG1-4.  Up to SGD20mil for Property + Business Interruption HG5.  Higher sum insured will be subjected to further underwriting review)"]
["Indemnity Period",null,null,null,null,null,null,null,null,null,"months"]
["Time Excess",null,null,null,null,null,null,null,null,null,"hours (for internal use)"]
["Total Sum Insured (Please specify below if others):",null,null,null,null,null,null,null,null,{"$f":"SUM(J55:J63)","v":0}]
["Gross Profit",null,null,null,null,null,null,null,null,null,"Estimated upcoming 12 month"]
["Gross Revenue",null,null,null,null,null,null,null,null,null,"Estimated upcoming 12 month"]
["Gross Rental",null,null,null,null,null,null,null,null,null,"Estimated upcoming 12 month"]
["Additional Increased Cost of Working"]
["Auditors Fees"]
["Standing Charges"]
["Wages"]
["Others"]
[]
[]
["Fixed Glass",null,null,null,null,"(up to SGD250,000 - higher limit will be subjected to further underwriting review)"]
["Sum Insured"]
["Deductible",null,null,null,null,null,null,null,null,null,"(for internal use)"]
[]
["Burglary",null,null,null,null,"(up to SGD250,000 - higher limit will be subjected to further underwriting review)"]
["Sum Insured"]
["Deductible",null,null,null,null,null,null,null,null,null,"(for internal use)"]
["First Loss/Full Value"]
[]
["Electronic Equipment",null,null,null,null,"(up to SGD5mil - higher limit will be subjected to further underwriting review)"]
["Sum Insured"]
["Deductible",null,null,null,null,null,null,null,null,null,"(for internal use)"]
[]
["Goods in Transit",null,null,null,null,"(up to SGD10mil - higher limit will be subjected to further underwriting review)"]
["Conveyance Limit"]
["Annual Sending "]
["Type of Cargo"]
[]
["Deductible",null,null,null,null,null,null,null,null,null,"(for internal use)"]
[]
["Money",null,null,null,null,"(up to SGD250,000 - higher limit will be subjected to further underwriting review)"]
["Money On Premises"]
["Money In Transit"]
["Estimated Annual Carrying"]
["Deductible",null,null,null,null,null,null,null,null,null,"(for internal use)"]
[]
["Fidelity Guarantee",null,null,null,null,"(up to SGD250,000 - higher limit will be subjected to further underwriting review)"]
["Limits of Guarantee in aggregate"]
["No. of Employees to cover"]
["Category of staff"]
["Deductible",null,null,null,null,null,null,null,null,null,"(for internal use)"]
[]
["Public Liability",null,null,null,null,"(up to SGD10mil - higher limit will be subjected to further underwriting review)",null,null,null,null,null,"Risk Exposures limitation for Public Liability and WICA"]
["A. PUBLIC LIABILITY",null,null,null,null,"(up to SGD10mil - higher limit of liability will be subjected to further underwriting review)"]
["Principal/Landlord/Tenant",null,null,null,null,null,null,null,null,null,null,"ØDo not engage sub-contractors at work."]
["Limit of Liability (Occurrence)",null,null,null,null,null,null,null,null,null,null,"ØNo hazardous materials handled or used on site."]
["Annual Turnover",null,null,null,null,null,null,null,null,null,"Above SGD20mil subjected to further underwriting review","ØNo works aboard vessel/rigs/offshore platform."]
["Deductible",null,null,null,null,null,null,null,null,null,"(for internal use)","ØNo works involve explosives, dangerous or toxic chemicals."]
["Manual Work Away from Premises",null,null,null,null,null,null,null,null,null,null,"ØNo Wavier of Subrogation"]
["Proportion of the total value of work",null,null,null,null,null,null,null,null,null,null,"ØNo Project business policy"]
[]
["B. PRODUCT LIABILITY",null,null,null,null,"(up to SGD2mil - higher limit of liability will be subjected to further underwriting review)"]
["Limit of Liability (Occurrence)"]
["Annual Turnover"]
["Deductible",null,null,null,null,null,null,null,null,null,"(for internal use)"]
["Any product quality assurance process in place?"]
["Do you manufacture to third party design specifications with possibility of recourse?"]
["Do you use third party manufactured products as components? "]
["If above is yes, from which countries?"]
["Please attach product list"]
[]
["Work Injury Compensation",null,null,null,null,null,"(up to 100 headcount, no claims for the past 3 years, no seconded employees or employees based outside of Singapore)"]
["Declaration of Hazardous Activities"]
[]
[null,"Employee Category",null,null,null,"Employee Category (if Others)",null,null,"No. of Employees","Estimated Total Annual Wages"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[]
["Personal Accident",null,null,null,null,"(up to Aggregate Limit of SGD10mil; 50pax)"]
["Declaration of Hazardous Activities"]
[]
["Non-Manual Employees",null,null,null,null,null,null,null,null,"Group 1","Group 2","Group 3"]
["Accidental Death and Permanent Disability SI per pax (up to $1,000,000 SI per pax)"]
["Medical Expenses SI per pax\n (up to $1,500 SI per pax)"]
["No. of Employees to be insured "]
[]
["Manual Employees"]
["Accidental Death and Permanent Disability (up to $1,000,000 SI per pax)",null,null,null,null,null,null,null,null,null,"per pax"]
["Medical Expenses \n(up to $1,500 SI per pax)",null,null,null,null,null,null,null,null,null,"per pax"]
["No. of Employees to be insured "]
["Coverage is on a declared name basis"]
["MACHINERY BREAKDOWN",null,null,null,null,"(up to 5% of Property SI (Max. $2mil))"]
["Sum Insured"]
["Deductible",null,null,null,null,null,null,null,null,null,"(for internal use)"]
["Please attach machine list"]
[]
["SECTION 4"]
["3. Declaration"]
["Claims for the past 3 years"]
[]
["By signing this form, "]
["i","I/We declare the above statements, particulars and declarations in this Proposal Form are true, accurate and complete."]
["ii","I/We agree that this Proposal Form and the statements, particulars and declarations set out herein shall form the basis of the contract of insurance to be entered into between Insurer and myself/ourselves, and that no liability is attached until this Proposal Form is accepted by Insurer and a contract of insurance formed between Insurer and myself/ourselves."]
["iii","I/We undertake to inform Insurer of any material changes or alterations to the statements, particulars and declarations set out in this Proposal Form, if any such material changes or alterations occur before the contract of insurance is formed."]
["iv"," If I/We do not fully and faithfully give the facts as I know them or ought to know them, I/We may receive nothing from the Policy."]
["v"," I/We agree to the policy terms, exclusions and conditions as expressed in this Proposal Form, policy wordings and endorsements."]
["vi"," By submitting information (including but not limited to personal data, if any) to Insurer by way of this Proposal Form, I/We consent to:"]
[null,"a","the Insurer and its third party service providers, related entities, business partners collecting, using, transferring and/or disclosing all personal data related to me/us which I/We had provided, whether within or outside of Singapore for the purposes notified to me/us under Insurer’s privacy policy which is available for viewing here: https://www.allianz.sg/Privacy-Policy.html; and"]
[null,"b","the collection, use, disclosure and dissemination of all information (including but not limited to information provided by I/We related to the Policy to my/our insurance intermediaries and the Insurer’s authorized agents and service providers) for the purposes relating to or incidental to my/our claims under the Policy or in accordance with the legislation. "]
[]
[]
[]
[]
[null,null,"Signature & Company Stamp",null,null,null,null,null,null,"Date"]

{"sheet":"UWlimits and Glossary","index":2,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,0,0,5],[2,2,3,2],[18,0,18,5],[27,0,27,5],[36,0,36,5]]}
["ACE Coverage"]
["Benefit","Mandatory / Optional","U/W guidelines - beyond these limits will require more information and further U/W approval","Comments"]
["Property (All Risks / Fire & Extraneous Perils)","Mandatory",45000000,"Comments"]
["Business Interruption","Optional",null,"Comments"]
["Glass","Optional","up to 10% of Property TSI","Comments"]
["Burglary","Optional","up to 10% of Property TSI","Comments"]
["Electronic Equipment ","Optional",45000000,"Comments","Comments"]
["Goods-in-Transit","Optional",10000000,"Comments","- minimum premium"]
["Money","Optional",250000,"Comments","Comments"]
["Fidelity Guarantee","Optional",350000,"Comments","Comments"]
["Public Liability","Optional",10000000,"Comments","Comments"]
["Products Liability","Optional",2000000,"Comments","Comments"]
["Work Injury Compensation","Optional","Medical Expense: $75,000\n$10,000,000 under Common Law","Comments","Comments"]
["Personal Accident","Optional","Accidental Death and Permanent Disability: $1,000,000 \nMedical Expense: $1,500\nPersons: 50","Comments","Comments"]
["Machinery Breakdown","Optional","Machinery Breakdown: up to 5% of Property TSI or $2,000,000 \nDeterioration of Stock: $250,000 ","Comments","Comments"]
[null,null,"Any limits beyond the above stated, will require UW approval"]
[]
[]
["ACE General Information"]
["Commission",0.25]
["Minimum Premium","of $1000 applies as a whole policy"]
[]
[]
[]
[]
[]
[]
["Definitions"]
[1,"TSI","Total Sum Insured"]
[]
[]
[]
[]
[]
[]
[]
["FAQ"]
[1,"How do I submit"]

{"sheet":"Questionaire - Property ","index":3,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["PDF File"]
[]
[]
[null,"FIELDS REQUIRED","Options",null,null,null,null,"Comments"]
[null,"Nature of Business "]
[null,"Website (if any)"]
[null,"Location Address"]
[]
["CONSTRUCTION","Supporting Structural System","Reinforce Concrete","Pre-stressed / pre-cast concrete (columns & beams)","Concrete columns & steel beams","Brick supporting walls ","Steel columns & beams (protected)","Steel columns & \nbeams (unprotected)","Wood frame","Unknown"]
[null,"Outside walls","Brick ","Concrete panels","Steel cladding","Sandwich panels","Glass curtain facade for high rise building","Glass curtain facade for other building","Unknown"]
[null,"Roof(s) ","Concrete slab & bitumen","Concrete slab & gravel","Metal deck & bitumen","ISP / Sandwich panels","Tiles on wooden structure","Wood ","Others"]
[null,"Insulated Sandwich Panels (ISP)\n\nCan take various forms but are generally an assembly of an insulating core material \nbetween two thin facings and can be used internally or externally in a building. This core \nmaterial broadly fits into 3 categories and underwriters need to determine \nif it is:\n1. Thermoplastic cores – examples include expanded (XPS) and extruded polystyrene (EPS), (PVC).","Yes","No"]
[null,"2. Thermosetting cores – examples include Polyurethane (PUR), polyisocyanurate (PIR) and phenolic foam (PHE).","Yes","No"]
[null,"3. Spray on foam – usually a polyurethane type material that has been sprayed directly onto a surface or for example a tank; typically used in wineries.","Yes","No"]
[null,"Height of Building\n\nThe height of a building needs to be determined as a high rise\nbuilding is considered as \n<30m","Yes","No"]
[null,">30m ","Yes","No"]
[null,"Age of the Building\n\nPre-war","Yes","No"]
[null,"Post-war","Yes","No"]
[null,"Automatic Systems\n\nNone","Yes","No"]
[null,"Hazardous area only","Yes","No"]
[null,"Full coverage","Yes","No"]
[null,"Double source & Certification provided on adequacy of sprinklers","Yes","No"]
[null,"Fire Detection systems\n\nHazardous area only, connected to a permanently staffed location","Yes","No"]
[null,"Hazardous area only, not connected to a permanently staffed location","Yes","No"]
[null,"Full coverage, connected to a permanently staffed location","Yes","No"]
[null,"Full coverage, not connected to a permanently staffed location","Yes","No"]
[null,"Manual Fire Fighting\n\nAre fire hoses for manual fire response available?","Yes","No"]
[null,"Are portable fire extinguishers available?","Yes","No"]
[null,"Are there any fire hydrants within 100m of range?","Yes","No"]
[null,"Security Features\n\nAre alarm systems in place?","Yes","No"]
[null,"Are there CCTV installed?","Yes","No"]
[null,"Is watchman service in place?","Yes","No"]
[null,null,"Yes","No"]
["HUMAN ELEMENT","Maintenance\n\nAre documented inspections of electrical systems conducted on a regular basis?","Yes","No"]
[null,"Are equipment and machines regularly maintained?","Yes","No"]
[null,"Hot-Works Permit\n\nIs there a formal document that mandates use of a formal hot work permit to monitor all hot work performed outside of designated safe areas?","Yes","No"]
[null,null,"Yes","No"]
["BUSINESS INTERRUPTION","Bottleneck\n\nIs the manufacturing process dependent on some unique or very \nspecific products or components (e.g. bottleneck machines, \ncustomized equipment etc.)? ","Yes","No"]
[null,"Replacement time\n\nReplacement time for crucial technical infrastructure/buildings (e.g. Machinery)\n<6 months","Yes","No"]
[null,"6 - 12 months","Yes","No"]
[null,"12 - 18 months","Yes","No"]
[null,">18 months","Yes","No"]
[null,"Dependencies\n\nIs total turnover dependent on one supplier or client for than 30%?","Yes","No"]
[null,"If so, what would be the implications in the event of a major catastrophe at a supplier’s/client’s premise?\nPlease provide information in the space below:"]

{"sheet":"Questionaire - Liability","index":4,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["PDF File"]
[]
[]
[null,"FIELDS REQUIRED","Options",null,null,null,null,"Comments"]
[null,"Proposal Number (if any)"]
[null,"Name of Intermediary"]
[null,"Intermediary Code"]
[]
["INSURED INFORMATION","Full name of the Insured (Including all Subsidiary Companies):"]
[null,"Postal Address and Principal Location:"]
[null,"Named Insured is:","Individual","Partnership","Corporation","Joint Venture","Others:"]
[null,"Nature of Business of Insured (in details):"]
[null,"Length of time Insured has been established in this business:"]
[null,"Does Insured have a subsidiary, affiliate or representative in the USA/ Canada/ UK or Australia?","Yes ","No"]
[null,"If yes, please give name(s) and address(es):"]
[null,"Annual aggregate estimated sales of the Insured:"]
[null,"Policy Period desired (DDMMYYYY)","From:","To:"]
[null,"Does the Insured: (a) Require “Vendors Liability” Endorsement?","Yes","No"]
[null,"If yes, please list vendor(s) and address(es)"]
[null,"(b) Enter into any hold harmless or other similar “contractual agreements”.","Yes","No"]
[null,"If yes, please explain: (Attach copy of such contracts if applicable)"]
[]
["PRODUCT INFORMATION","For USA/Canada/UK/Australia Products: \n(a) List all products manufactured, sold or distributed by the Insured in or exported to USA/Canada/UK/Australia and sales by\nproduct for the past 4 years as well as estimated sales for the upcoming year (Attach products brochures or other printed\nmaterial describing products)",null,null,null,null,null,"(Please indicate products manufactured in USA/Canada/UK/Australia by placing a asterix * next to the product category)"]
[null,"(b) List all products manufactured by the Insured for sales in USA/Canada/UK/Australia but not sold under their label and sales by\nproduct for the last 4 years as well as estimated sales for the upcoming year:",null,null,null,null,null,"(Please indicate products manufactured in USA/Canada/UK/Australia by placing a asterix * next to the product category)"]
[null,"For Non USA/Canada/UK/Australia Products (Rest of the World Sales of Products):\n(a) List all products manufactured, sold or distributed by the Insured in or exported outside USA/Canada/UK/Australia and sales by\nproduct for the past 4 years as well as estimated sales for the upcoming year (Attach products brochures or other printed\nmaterial describing products)"]
[null,"(b) List all products manufactured by the Insured for sales outside USA/Canada/UK/Australia but not sold under their label and\nsales by product for the last 4 years as well as estimated sales for the upcoming year:"]
[null,"Does the Insured expect to manufacture any new products in the next 12 months?","Yes","No"]
[null,"Have any new products been introduced in the last 3 years?\n(a) In USA/Canada/UK/Australia","Yes","No"]
[null,"(b) Outside of USA/Canada/UK/Australia","Yes","No"]
[null,"If yes, list products and date of introduction and sales."]
[null,"Please provide a list of discontinued or recalled products manufactured and/or distributed by the Insured in the past 5 years."]
[null,"Are any products sold as components for other products?","Yes","No"]
[null,"If yes, please elaborate."]
[null,"Are any products used or incorporated in:","Aircraft","Atomic Reactors or Installations","Petrochemical Installations"]
[null,"If yes, please provide details and turnover."]
[null,"Are all products designed by the Insured?","Yes","No"]
[null,"If no, please explain."]
[null,"Are there or have there been any violations of the consumer product safety act or any other federal or local legislation?","Yes","No"]
[null,"If yes, please provide details."]
[null,"Are raw materials/components/parts purchased/imported?","Yes","No"]
[null,"If yes, please give % purchased/imported and source."]
[null,"Is the Insured aware of any product which, because of known defects or inherent hazards, is likely to cause bodily injury or property damage?","Yes","No"]
[null,"If yes, please provide details."]
[]
["INSURANCE HISTORY","Please state name of current insurer and basis of liability (i.e. occurrence/claims-made)."]
[null,"Has any Insurance Company cancelled/ refused to renew products liability coverage?","Yes","No"]
[null,"If yes, please provide details."]
[null,"Loss Experience:\n(a) Total incurred in the past 5 years"]
[null,"(b) Describe in details losses over S$5,000.00 (paid or reserved)"]
[]
["COVERAGE REQUIRED","Limit of Liability required:",null,null,null,null,null,"(per occurrence & in aggregate)"]
[null,"Deductible required:"]
[null,"May we make a physical inspection of the Insured’s premises? If yes, please provide,","Yes","No"]
[null,"Person to contact:"]
[null,"Designation:"]
[null,"Contact Number:"]

{"sheet":"Questionaire - WIC","index":5,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["PDF File "]
[]
[]
[null,"FIELDS REQUIRED","Options",null,null,null,null,"Comments"]
[null,"Proposal Number (if any)"]
[null,"Name of Intermediary"]
[null,"Intermediary Code"]
[]
["GENERAL INFORMATION","Full name of the Employer/Proposer (Including all subsidiary companies):"]
[null,"Business Registration/UEN No.:"]
[null,"Postal Address and Principal Location:"]
[null,"Policy Period desired (DD/MM/YYYY):","from:","to:"]
[null,"Nature of Business of Insured (in detail):"]
[null,"No. of Years in Operation:"]
[null,"Places of Employment:"]
[]
["EMPLOYEES TO BE INSURED FOR ACT BENEFITS","Categories of Employees"]
[null,"Description of Occupation"]
[null,"No.of Employees"]
[null,"*Estimated Total Annual Wages (S$)",null,null,null,null,null,"*Definition of Annual Wages\nThe annual wages, salaries and other monetary earnings must consist of the normal wages, food and housing allowances, overtime payments,\nbonuses and annual wages supplements but excluding travelling allowances and employers’ CPF contributions."]
[]
[null,"Are there any employees based outside of Singapore? \nIf yes, please provide the following details.","Yes","No"]
[null,"Country Based In"]
[null,"Categories of Employees"]
[null,"Description of Occupation"]
[null,"No. of Employees"]
[null,"*Estimated Total Annual Wages (S$)"]
[]
["CLAIMS INFORMATION","Current Insurer:"]
[null,"Insurance Period"]
[null,"No. of Claims"]
[null,"Details of Claims"]
[null,"Paid Amount"]
[null,"Outstanding Amount"]
[]
["ADDITIONAL INFORMATION","1. Are any workers involved in manual works in connection with installation, erection, repair, testing, maintenance, demolition or construction outside insured’s premises?","Yes","No"]
[null,"2. Are any workers involved in works at a height of more than 30 feet above floor or ground level or below ground more than 1.5m depth from road/street level?\nIf height is 30 feet above floor or ground level, please state:","Yes","No"]
[null,"(a) Maximum height involved:","Yes","No"]
[null,"(b) Average height involved:","Yes","No"]
[null,"(c) Method use to access/reach height limit:","Yes","No"]
[null,"3. Are any workers involved in Demolition/Sewer/Manhole/Tunneling works?","Yes","No"]
[null,"4. Are any workers involved in works of the following activities?\n(a) explosives, dangerous or toxic chemicals e.g. chemicals that are under the Poison Act or Gases","Yes","No"]
[null,"(b) tank cleaning","Yes","No"]
[null,"(c) dealing with asbestos","Yes","No"]
[null,"(d) dealing with radiation and radioactive contamination (excluding radiographers)","Yes","No"]
[null,"5. Are any workers involved in using heavy machinery that involved cutting, pressing, grinding etc.?","Yes","No"]
[null,"6. Are any workers involved in any Welding and/or Hot work process?","Yes","No"]
[null,"7. Are any workers involved in lifting or hoisting operations?","Yes","No"]
[null,"8. Are any workers required to work-on-board vessels? If yes, please state the maximum number of employees onboard any vessel any one time.","Yes","No"]
[null,"9. Will there be any diving and/or related underwater activities pertaining to your business?","Yes","No"]
[null,"10. Do you have a dedicated risk manager or safety officer?","Yes","No"]
[null,"11. Has any insurer declined, cancelled or not renewed any of the company’s insurance cover in the past 3 years?","Yes","No"]

{"sheet":"Tax Invoice","index":6,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,0,0,9],[5,0,5,4],[18,0,18,1],[19,0,19,9],[20,0,20,9],[2,0,2,4],[3,0,3,4],[4,0,4,4],[6,0,6,4],[13,0,13,1],[10,3,10,5]]}
["Tax Invoice"]
[]
["«Policy_holder_name»"]
["< Block No/Street Name >",null,null,null,null,"GST No.",":","201903913C"]
["< unit no.> ",null,null,null,null,"Tax Invoice No.",":"]
["<Building Name>",null,null,null,null,"Intermediary Code",":",{"$f":"'Proposal Form'!H7","v":0}]
["<Country> <postal code>",null,null,null,null,"Date",":"]
[]
["Policy Number",null,":"]
["Policyholder / Insured",null,":",{"$f":"'Proposal Form'!H12","v":0}]
["Type of Insurance",null,":","ALLIANZ COMMERCIAL EDGE"]
["Period of Insurance",null,":",{"$f":"'Proposal Form'!H17","v":"00:00:00"},"to",{"$f":"'Proposal Form'!J17","v":"00:00:00"},"(both dates inclusive)"]
["Premium",null,":","SGD",{"$f":"SUM('Policy Schedule_v2'!J16,J178,J206,J216,J225,J234,J247,J275,J285,J294)","v":0}]
["GST on Premium @ 8%",null,":","SGD",{"$f":"E13*8%","v":0}]
["Premium Payable",null,":","SGD",{"$f":"SUM(E13:E14)","v":0}]
[]
[]
["E. & O.E."]
["Important notice"]
["Please note that the Policy is subject to Payment Before Cover Warranty or Premium Payment Warranty, whichever is applicable."]
["The Company should be notified of any discrepancy in writing within 2 weeks from data hereof, otherwise this invoice shall be deemed to be correct. This is a computer-generated tax invoice. No signature is required. "]

{"sheet":"Quotation Slip","index":7,"n_rows":354,"n_cols":12,"rows_kept":354,"cut":false,"hidden":true,"merged":[[349,7,349,9],[353,1,353,9],[3,4,3,6],[340,1,340,9],[346,1,346,3],[346,7,346,9],[347,1,347,3],[347,7,347,9],[348,7,348,9],[324,1,324,9],[326,8,326,9],[327,0,327,10],[328,1,328,4],[331,1,331,4],[334,1,334,4],[309,6,309,7],[309,8,309,9],[310,6,310,7],[310,8,310,9],[311,6,311,7],[311,8,311,9],[306,6,306,7],[306,8,306,9],[307,6,307,7],[307,8,307,9],[308,6,308,7],[308,8,308,9],[297,6,297,7],[297,8,297,9],[305,6,305,7],[305,8,305,9],[298,6,298,7],[298,8,298,9],[299,6,299,7],[299,8,299,9],[300,6,300,7],[300,8,300,9],[303,6,303,7],[303,8,303,9],[304,6,304,7],[304,8,304,9],[301,6,301,7],[301,8,301,9],[225,0,225,10],[232,0,232,10],[234,0,234,10],[296,2,296,4],[296,6,296,7],[296,8,296,9],[247,0,247,10],[273,0,273,10],[275,0,275,10],[283,0,283,10],[285,0,285,10],[292,0,292,10],[294,0,294,10],[272,4,272,9],[302,6,302,7],[302,8,302,9],[0,0,0,10],[1,0,1,10],[13,4,13,5],[14,0,14,10],[16,0,16,10],[19,1,19,9],[204,0,204,10],[176,0,176,10],[178,0,178,10],[245,0,245,10],[206,0,206,10],[214,0,214,10],[216,0,216,10],[223,0,223,10]]}
["Quotation Slip"]
["Allianz Commercial EDGE"]
[]
[null,"Date of Quotation",null,":",{"$f":"TODAY()","v":"2025-08-04"}]
[null,"Quotation No.",null,":"]
[null,"Intermediary Code",null,":",{"$f":"'Proposal Form'!H7","v":0}]
[null,"Intermediary",null,":",{"$f":"'Proposal Form'!H6","v":0}]
[null,"Policyholder/Insured",null,":",{"$f":"'Proposal Form'!H12","v":0}]
[null,"ISIC",null,":",{"$f":"'Proposal Form'!H14","v":0}]
[null,"UEN",null,":",{"$f":"'Proposal Form'!H13","v":0}]
[null,"Correspondence Address",null,":",{"$f":"'Proposal Form'!H15","v":0}]
[null,"Nature of Business",null,":",{"$f":"'Proposal Form'!H16","v":0}]
[null,"Period of Insurance",null,":",{"$f":"'Proposal Form'!H17","v":"00:00:00"},"to",{"$f":"'Proposal Form'!J17","v":"00:00:00"},null,"(both dates inclusive)"]
[null,"Total Premium with GST",null,":",{"$f":"SUM(J16,J178,J206,J216,J225,J234,J247,J275,J285,J294)*1.08","v":0}]
[]
[null,"Section 1 - Property",null,null,null,null,null,null,"Premium",{"$f":"SUM(J32,J44,J56,J68,J80,J92,J104,J116,J128,J140,J160,J172)","v":0}]
[]
[]
[null,"Property"]
[null,"On the following properties belonging to the Insured or held by the Insured or on commission or for which the Insured hold itself responsible"]
[]
[1,{"$f":"\"Location of Risk\"&\" \"&A22","v":"Location of Risk 1"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A22,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B23,'Proposal Form'!$A$26:$S$26,9+A22,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B24,'Proposal Form'!$A$22:$S$26,9+A22,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,3.0000000000000001E-3,{"$f":"_xlfn.IFNA(VLOOKUP(C27,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},{"$f":"IFERROR(H27*I27,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C28,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},{"$f":"IFERROR(H28*I28,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C29,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C30,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C31,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I27:I31)","v":0},{"$f":"SUM(J27:J31)","v":0}]
[]
[2,{"$f":"\"Location of Risk\"&\" \"&A34","v":"Location of Risk 2"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A34,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B35,'Proposal Form'!$A$26:$S$26,9+A34,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B36,'Proposal Form'!$A$22:$S$26,9+A34,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C39,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},{"$f":"IFERROR(H39*I39,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C40,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},{"$f":"IFERROR(H40*I40,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C41,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C42,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C43,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I39:I43)","v":0},{"$f":"SUM(J39:J43)","v":0}]
[]
[3,{"$f":"\"Location of Risk\"&\" \"&A46","v":"Location of Risk 3"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A46,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B47,'Proposal Form'!$A$26:$S$26,9+A46,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B48,'Proposal Form'!$A$22:$S$26,9+A46,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C51,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},{"$f":"IFERROR(H51*I51,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C52,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},{"$f":"IFERROR(H52*I52,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C53,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C54,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C55,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I51:I55)","v":0},{"$f":"SUM(J51:J55)","v":0}]
[]
[4,{"$f":"\"Location of Risk\"&\" \"&A58","v":"Location of Risk 4"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A58,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B59,'Proposal Form'!$A$26:$S$26,9+A58,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B60,'Proposal Form'!$A$22:$S$26,9+A58,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C63,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},{"$f":"IFERROR(H63*I63,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C64,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},{"$f":"IFERROR(H64*I64,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C65,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C66,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C67,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I63:I67)","v":0},{"$f":"SUM(J63:J67)","v":0}]
[]
[5,{"$f":"\"Location of Risk\"&\" \"&A70","v":"Location of Risk 5"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A70,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B71,'Proposal Form'!$A$26:$S$26,9+A70,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B72,'Proposal Form'!$A$22:$S$26,9+A70,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C75,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},{"$f":"IFERROR(H75*I75,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C76,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},{"$f":"IFERROR(H76*I76,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C77,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C78,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C79,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I79)","v":0},{"$f":"SUM(J75:J79)","v":0}]
[]
[6,{"$f":"\"Location of Risk\"&\" \"&A82","v":"Location of Risk 6"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A82,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B83,'Proposal Form'!$A$26:$S$26,9+A82,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B84,'Proposal Form'!$A$22:$S$26,9+A82,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C87,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},{"$f":"IFERROR(H87*I87,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C88,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},{"$f":"IFERROR(H88*I88,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C89,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C90,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C91,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I91)","v":0},{"$f":"SUM(J87:J91)","v":0}]
[]
[7,{"$f":"\"Location of Risk\"&\" \"&A94","v":"Location of Risk 7"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A94,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B95,'Proposal Form'!$A$26:$S$26,9+A94,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B96,'Proposal Form'!$A$22:$S$26,9+A94,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C99,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},{"$f":"IFERROR(H99*I99,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C100,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},{"$f":"IFERROR(H100*I100,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C101,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C102,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C103,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I99:I103)","v":0},{"$f":"SUM(J99:J103)","v":0}]
[]
[8,{"$f":"\"Location of Risk\"&\" \"&A106","v":"Location of Risk 8"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A106,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B107,'Proposal Form'!$A$26:$S$26,9+A106,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B108,'Proposal Form'!$A$22:$S$26,9+A106,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C111,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},{"$f":"IFERROR(H111*I111,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C112,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},{"$f":"IFERROR(H112*I112,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C113,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C114,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C115,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I111:I115)","v":0},{"$f":"SUM(J111:J115)","v":0}]
[]
[9,{"$f":"\"Location of Risk\"&\" \"&A118","v":"Location of Risk 9"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A118,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B119,'Proposal Form'!$A$26:$S$26,9+A118,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B120,'Proposal Form'!$A$22:$S$26,9+A118,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C123,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},{"$f":"IFERROR(H123*I123,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C124,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},{"$f":"IFERROR(H124*I124,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C125,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C126,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C127,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I123:I127)","v":0},{"$f":"SUM(J123:J127)","v":0}]
[]
[10,{"$f":"\"Location of Risk\"&\" \"&A130","v":"Location of Risk 10"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A130,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B131,'Proposal Form'!$A$26:$S$26,9+A130,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B132,'Proposal Form'!$A$22:$S$26,9+A130,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C135,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},{"$f":"IFERROR(H135*I135,\"\")","v":0}]
[null,2,"Stocks",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C136,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},{"$f":"IFERROR(H136*I136,\"\")","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C137,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},0]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C138,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},0]
[null,5,"Building",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C139,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I135:I139)","v":0},{"$f":"SUM(J135:J139)","v":0}]
[]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(E143,'Proposal Form'!$A$37:$J$38,10,FALSE),\"\")","v":1000}]
[null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(E144,'Proposal Form'!$A$37:$J$38,10,FALSE),\"\")","v":""}]
[]
[null,"Subjectivity",null,":"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Business Interruption "]
[null,null,"Business Interruption",null,null,null,null,"Rate","Sum Insured","Premium"]
[null,1,"Gross Profit",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C151,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"IFERROR(H151*I151,\"\")","v":0}]
[null,2,"Gross Revenue",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C152,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"IFERROR(H152*I152,\"\")","v":0}]
[null,3,"Gross Rental",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C153,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},0]
[null,4,"Additional Increased Cost of Working",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C154,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},0]
[null,5,"Auditors Fees",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C155,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},0]
[null,6,"Standing Charges",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C156,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},0]
[null,7,"Wages",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C157,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},0]
[null,8,"Others",null,null,null,null,0,{"$f":"_xlfn.IFNA(VLOOKUP(C158,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},0]
[null,9,null,null,null,null,null,{"$f":"IF(OR(I159=0,I159=\"\"),\"\",'Pricing '!$H$14)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP(C159,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},""]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I151:I159)","v":0},{"$f":"SUM(J151:J159)","v":0}]
[]
[null,"Indemnity Period",null,":",{"$f":"'Proposal Form'!J52","v":0},"months"]
[]
[null,"Time Excess",null,":",{"$f":"'Proposal Form'!J53","v":0},"hours"]
[]
[null,"Subjectivity",null,":"]
[]
[]
[null,{"$f":"IF(J178=0,L169&\" - Not Covered\",L169)","v":"Fixed Glass - Not Covered"},null,null,null,null,null,null,null,null,null,"Fixed Glass"]
[null,"Sum Insured",null,":","Per Event",null,null,null,null,{"$f":"'Proposal Form'!J66","v":0}]
[]
[null,"Premium",null,":","at rate",0,null,null,null,{"$f":"F172*J170","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J67","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J178=0,L178&\" - Not Covered\",L178)","v":"Section 2 - Public Liability - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'[1]Pricing '!M18","v":0},null,"Section 2 - Public Liability"]
[]
[]
[null,{"$f":"IF(J182=0,L181&\" - Not Covered\",L181)","v":"Public Liability - Not Covered"},null,null,null,null,null,null,null,null,null,"Public Liability"]
[null,"Limit of Liability",null,":","Any one occurrence ",null,null,null,null,{"$f":"'Proposal Form'!J100","v":0}]
[null,null,null,null,"Any one period",null,null,null,null,"Unlimited"]
[]
[null,"Deductible/Excess",null,":","Any one occurrence",null,null,null,null,{"$f":"'Proposal Form'!J102","v":0}]
[]
[null,"Annual Turnover",null,":",null,null,null,null,null,{"$f":"'Proposal Form'!J101","v":0}]
[]
[null,"Geographical Limit",null,":","Singapore"]
[]
[null,"Subjectivity",null,":","Insured’s number of years in business operations: more than 3 years.\n"]
[null,null,null,null,"Claims Experience: Nil claim for the past 3 years"]
[]
[null,{"$f":"IF(J195=0,L194&\" - Not Covered\",L194)","v":"Product Liability - Not Covered"},null,null,null,null,null,null,null,null,null,"Product Liability"]
[null,"Limit of Liability",null,":","Any one occurrence ",null,null,null,null,{"$f":"'Proposal Form'!J107","v":0}]
[null,null,null,null,"Any one period",null,null,null,null,"Unlimited"]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J109","v":0}]
[]
[null,"Annual Turnover",null,":",null,null,null,null,null,{"$f":"'Proposal Form'!J108","v":0}]
[]
[null,"Jurisdiction",null,":","Republic of Singapore"]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J206=0,L206&\" - Not Covered\",L206)","v":"Section 3 - Money - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"(H209*J209)+(H210*J210)","v":0},null,"Section 3 - Money"]
[]
[]
[null,"Sum Insured",null,":","In Transit",null,"at rate",0,null,{"$f":"'Proposal Form'!J87","v":0}]
[null,null,null,null,"In Premise",null,"at rate",0,null,{"$f":"'Proposal Form'!J86","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J102","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J216=0,L216&\" - Not Covered\",L216)","v":"Section 4 - Goods in Transit - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"J219*H219","v":0},null,"Section 4 - Goods in Transit"]
[]
[]
[null,"Sum Insured",null,":","Per Event",null,"at rate",0,null,{"$f":"'Proposal Form'!J79","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J83","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J225=0,L225&\" - Not Covered\",L225)","v":"Section 5 - Electronic Equipment - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"J228*H228","v":0},null,"Section 5 - Electronic Equipment"]
[]
[]
[null,"Sum Insured",null,":","Anywhere in Singapore",null,"at rate",0,null,{"$f":"'Proposal Form'!J75","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J76","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J234=0,L234&\" - Not Covered\",L234)","v":"Section 6 - Fidelity Guarantee - Not Covered"},null,null,null,null,null,null,"Premium",null,null,"Section 6 - Fidelity Guarantee"]
[]
[]
[null,"Limits of Guarantee",null,":","In Aggregate",null,"at rate",0,null,{"$f":"'Proposal Form'!J92","v":0}]
[]
[null,"No. of Employees to cover",null,":",null,null,null,null,null,{"$f":"'Proposal Form'!J93","v":0}]
[]
[null,"Category of staff",null,":",null,null,null,null,null,{"$f":"IF('Proposal Form'!J94=0,\"\",'Proposal Form'!J94)","v":""}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J95","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J247=0,L247&\" - Not Covered\",L247)","v":"Section 7 - Personal Accident - Not Covered"},null,null,null,null,null,null,"Premium",null,null,"Section 7 - Personal Accident"]
[]
[]
[null,"Sum Insured",null,":","Non-Manual Employees (Group 1)"]
[null,null,null,null,"Accidental Death and Permanent Disability",null,null,null,null,{"$f":"'Proposal Form'!J$140","v":0}]
[null,null,null,null,"Medical Expense",null,null,null,null,{"$f":"'Proposal Form'!J$141","v":0}]
[null,null,null,null,"Number of Employees",null,null,null,null,{"$f":"'Proposal Form'!J$142","v":0}]
[]
[null,null,null,null,"Non-Manual Employees (Group 2)"]
[null,null,null,null,"Accidental Death and Permanent Disability",null,null,null,null,{"$f":"'Proposal Form'!K$140","v":0}]
[null,null,null,null,"Medical Expense",null,null,null,null,{"$f":"'Proposal Form'!K$141","v":0}]
[null,null,null,null,"Number of Employees",null,null,null,null,{"$f":"'Proposal Form'!K$142","v":0}]
[]
[null,null,null,null,"Non-Manual Employees (Group 3)"]
[null,null,null,null,"Accidental Death and Permanent Disability",null,null,null,null,{"$f":"'Proposal Form'!L$140","v":0}]
[null,null,null,null,"Medical Expense",null,null,null,null,{"$f":"'Proposal Form'!L$141","v":0}]
[null,null,null,null,"Number of Employees",null,null,null,null,{"$f":"'Proposal Form'!L$142","v":0}]
[]
[null,null,null,null,"Manual Employees"]
[null,null,null,null,"Accidental Death and Permanent Disability",null,null,null,null,{"$f":"'Proposal Form'!J145","v":0}]
[null,null,null,null,"Medical Expense",null,null,null,null,{"$f":"'Proposal Form'!J146","v":0}]
[null,null,null,null,"Number of Employees"]
[]
[null,"Number of Employees",null,":","Non-Manual Employees",null,null,null,null,{"$f":"'Proposal Form'!J142","v":0}]
[null,null,null,null,"Manual Employees",null,null,null,null,{"$f":"'Proposal Form'!J147","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J275=0,L275&\" - Not Covered\",L275)","v":"Section 8 - Machinery Breakdown - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Pricing '!M57","v":0},null,"Section 8 - Machinery Breakdown"]
[]
[]
[null,"Sum Insured",null,":","Machinery Breakdown",null,"at rate",{"$f":"IF(J275=0,\"\",J275/J278)","v":""},null,{"$f":"'Proposal Form'!J150","v":0}]
[]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J151","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J285=0,L285&\" - Not Covered\",L285)","v":"Section 8 - Burglary - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"J288*H288","v":0},null,"Section 8 - Burglary"]
[]
[]
[null,"Sum Insured",null,":",{"$f":"'Proposal Form'!J72","v":0},null,"at rate",0,null,{"$f":"'Proposal Form'!J70","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J71","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J294=0,L294&\" - Not Covered\",L294)","v":"Section 9 - Work Injury Compensation - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"SUMPRODUCT(G298:G312,I298:I312)","v":0},null,"Section 9 - Work Injury Compensation"]
[]
[]
[null,null,"Employee Category",null,null,"Number of Employees","Rate",null,"Estimated Total Annual Wages"]
[null,1,{"$f":"'Pricing '!C38","v":0},null,null,{"$f":"'Proposal Form'!I120","v":0},{"$f":"IFERROR(VLOOKUP(C298,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J120","v":0}]
[null,{"$f":"B298+1","v":2},{"$f":"'Pricing '!C39","v":0},null,null,{"$f":"'Proposal Form'!I121","v":0},{"$f":"IFERROR(VLOOKUP(C299,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J121","v":0}]
[null,{"$f":"B299+1","v":3},{"$f":"'Pricing '!C40","v":0},null,null,{"$f":"'Proposal Form'!I122","v":0},{"$f":"IFERROR(VLOOKUP(C300,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J122","v":0}]
[null,4,{"$f":"'Pricing '!C41","v":0},null,null,{"$f":"'Proposal Form'!I123","v":0},{"$f":"IFERROR(VLOOKUP(C301,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J123","v":0}]
[null,5,{"$f":"'Pricing '!C42","v":0},null,null,{"$f":"'Proposal Form'!I124","v":0},{"$f":"IFERROR(VLOOKUP(C302,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J124","v":0}]
[null,6,{"$f":"'Pricing '!C43","v":0},null,null,{"$f":"'Proposal Form'!I125","v":0},{"$f":"IFERROR(VLOOKUP(C303,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J125","v":0}]
[null,7,{"$f":"'Pricing '!C44","v":0},null,null,{"$f":"'Proposal Form'!I126","v":0},{"$f":"IFERROR(VLOOKUP(C304,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J126","v":0}]
[null,8,{"$f":"'Pricing '!C45","v":0},null,null,{"$f":"'Proposal Form'!I127","v":0},{"$f":"IFERROR(VLOOKUP(C305,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J127","v":0}]
[null,9,{"$f":"'Pricing '!C46","v":0},null,null,{"$f":"'Proposal Form'!I121","v":0},{"$f":"IFERROR(VLOOKUP(C306,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J128","v":0}]
[null,10,{"$f":"'Pricing '!C47","v":0},null,null,{"$f":"'Proposal Form'!I128","v":0},{"$f":"IFERROR(VLOOKUP(C307,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J129","v":0}]
[null,11,{"$f":"'Pricing '!C48","v":0},null,null,{"$f":"'Proposal Form'!I129","v":0},{"$f":"IFERROR(VLOOKUP(C308,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J130","v":0}]
[null,12,{"$f":"'Pricing '!C49","v":0},null,null,{"$f":"'Proposal Form'!I130","v":0},{"$f":"IFERROR(VLOOKUP(C309,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J131","v":0}]
[null,13,{"$f":"'Pricing '!C50","v":0},null,null,{"$f":"'Proposal Form'!I131","v":0},{"$f":"IFERROR(VLOOKUP(C310,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J132","v":0}]
[null,14,{"$f":"'Pricing '!C51","v":0},null,null,{"$f":"'Proposal Form'!I132","v":0},{"$f":"IFERROR(VLOOKUP(C311,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J133","v":0}]
[null,15,{"$f":"'Pricing '!C52","v":0},null,null,{"$f":"'Proposal Form'!I133","v":0},{"$f":"IFERROR(VLOOKUP(C312,Dropdown!$AF$3:$AG$26,2,FALSE),0)","v":0},null,{"$f":"'Proposal Form'!J134","v":0}]
[]
[null,"Limit of Liability",null,":","Common Law Limit (per occurrence)",null,null,null,null,15000000]
[null,null,null,null,"Hospitalisation Leave Wages (days)",null,null,null,null,60]
[null,null,null,null,"Medical Leave Wages (days)",null,null,null,null,14]
[null,null,null,null,"Medical Expense (per accident per employee)",null,null,null,null,250000]
[]
[null,"Geographical Limit",null,":","Singapore"]
[]
[null,"Subjectivity",null,":","Insured’s number of years in business operations: more than 3 years.\n"]
[null,null,null,null,"Claims Experience: Nil claim for the past 3 years"]
[null,null,null,null,"No seconded employees or employees based out of Singapore."]
[]
[null,"Subject to the following extensions as in the Policy Wording. Limit of Liability and Excess is as per Polcy Wording unless stated otherwise:"]
[]
[null,"Extensions",null,null,null,null,"Excess",null,"Limit of Liability"]
[]
[null,"Section 1C - Business Interruption"]
[3,{"$f":"VLOOKUP(A330,Dropdown!Q:AM,VLOOKUP('Quotation Slip'!B329,Dropdown!N:O,2,FALSE),FALSE)","v":"Alternative Basis"}]
[null,{"$f":"VLOOKUP(A331,Dropdown!Q:AM,VLOOKUP('Quotation Slip'!B330,Dropdown!N:O,2,FALSE),FALSE)","v":{"$error":"#N/A"}}]
[null,"Section 1B - Fire & Extraneous Perils"]
[2,{"$f":"VLOOKUP(A333,Dropdown!Q:AM,VLOOKUP('Quotation Slip'!B332,Dropdown!N:O,2,FALSE),FALSE)","v":"Alterations and Repairs"}]
[null,{"$f":"VLOOKUP(A334,Dropdown!Q:AM,VLOOKUP('Quotation Slip'!B333,Dropdown!N:O,2,FALSE),FALSE)","v":{"$error":"#N/A"}}]
[null,"Section 1C - Business Interruption"]
[3,{"$f":"VLOOKUP(A336,Dropdown!Q:AM,VLOOKUP('Quotation Slip'!B335,Dropdown!N:O,2,FALSE),FALSE)","v":"Alternative Basis"}]
[null,{"$f":"VLOOKUP(A337,Dropdown!Q:AM,VLOOKUP('Quotation Slip'!B336,Dropdown!N:O,2,FALSE),FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Subject otherwise to the terms, exceptions and conditions of the Allianz Commercial Edge Insurance Policy."]
[]
[]
[]
[]
[]
[]
[null,"Issue Date",null,null,null,null,null,"Hicham Raissi"]
[null,null,null,null,null,null,null,"Chief Executive Officer"]
[null,null,null,null,null,null,null,"Allianz Insurance Singapore Pte. Ltd."]
[]
[]
[null,"Note: "]
[null,"This Policy Schedule shall be read in conjunction with the Policy Wording as one contract. Please refer to the Policy Wording for the exact terms and conditions as well as the full list of exclusions."]

{"sheet":"Pricing ","index":8,"n_rows":65,"n_cols":34,"rows_kept":65,"cut":false,"hidden":true,"merged":[[1,16,17,16],[2,7,2,10],[3,7,3,10],[4,7,4,10],[5,7,5,10],[6,7,6,10],[7,7,7,10],[13,7,13,10],[14,7,14,10],[9,7,9,10],[10,7,10,10],[11,7,11,10],[12,7,12,10],[19,2,19,10],[20,6,20,10],[32,6,32,10],[0,2,0,10],[1,2,1,10],[31,2,31,10],[28,2,28,10],[24,6,24,10],[23,6,23,10],[27,6,27,10],[26,6,26,10],[25,2,25,10],[22,2,22,10],[21,6,21,10],[17,2,17,10],[8,7,8,10],[57,6,57,10],[58,6,58,10],[33,6,33,10],[29,6,29,10],[30,6,30,10],[56,2,56,10],[52,2,52,10],[34,2,34,10],[53,8,53,9],[54,8,54,9],[55,8,55,9],[53,6,53,7],[54,6,54,7],[55,6,55,7]]}
[null,null,"Product Type",null,null,null,null,null,null,null,null,null,"Quoted Premium","Technical Premium",null,null,"Remarks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Predetermined WICA rates"]
[null,null,"Property (with Business Interruption, Fixed Glass)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M4:M15)","v":0},null,{"$f":"IF(M2='Quotation Slip'!J32+'Quotation Slip'!J44+'Quotation Slip'!J56+'Quotation Slip'!J68+'Quotation Slip'!J80+'Quotation Slip'!J160+'Quotation Slip'!J172,M2/N2,\"error\")","v":{"$error":"#DIV/0!"}},null,"Taken from MCP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Role","Rate"]
[null,null,null,null,null,null,"Total Sum Insured","Rate (%)"]
[null,{"$f":"_xlfn.NUMBERVALUE(RIGHT(C4,1))","v":1},"Location of Risk 1",null,null,null,{"$f":"'Proposal Form'!J$29","v":0},null,null,null,null,null,{"$f":"IFERROR(H4*G4,\"\")","v":0}]
[null,{"$f":"_xlfn.NUMBERVALUE(RIGHT(C5,1))","v":2},"Location of Risk 2",null,null,null,{"$f":"'Proposal Form'!K29","v":0},null,null,null,null,null,{"$f":"IFERROR(H5*G5,\"\")","v":0}]
[null,3,"Location of Risk 3",null,null,null,{"$f":"'Proposal Form'!L29","v":0},null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Proposal Form'!T29","v":0}]
[null,4,"Location of Risk 4",null,null,null,{"$f":"'Proposal Form'!M29","v":0},null,null,null,null,null,{"$f":"IFERROR(H7*G7,\"\")","v":0}]
[null,5,"Location of Risk 5",null,null,null,{"$f":"'Proposal Form'!N29","v":0},null,null,null,null,null,{"$f":"IFERROR(H8*G8,\"\")","v":0}]
[null,null,"Location of Risk 6",null,null,null,{"$f":"'Proposal Form'!O29","v":0},null,null,null,null,null,0]
[null,null,"Location of Risk 7",null,null,null,{"$f":"'Proposal Form'!P29","v":0},null,null,null,null,null,0]
[null,null,"Location of Risk 8",null,null,null,{"$f":"'Proposal Form'!Q29","v":0},null,null,null,null,null,0]
[null,null,"Location of Risk 9",null,null,null,{"$f":"'Proposal Form'!R29","v":0},null,null,null,null,null,0]
[null,null,"Location of Risk 10",null,null,null,{"$f":"'Proposal Form'!S29","v":0},null,null,null,null,null,0]
[null,{"$error":"#VALUE!"},"Business Interruption",null,null,null,{"$f":"'Proposal Form'!J54","v":0},null,null,null,null,null,0]
[null,{"$error":"#VALUE!"},"Fixed Glass",null,null,null,{"$f":"'Proposal Form'!J66","v":0},null,null,null,null,null,0]
[]
[]
[null,null,"Public Liability",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M18/N18","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Burglary",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Proposal Form'!J70*VLOOKUP('Proposal Form'!J72,'Pricing '!C21:K22,5,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Manual Outdoor Job ",2E-3]
[null,null,"Full Value",null,null,null,2E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manual Outdoor Job",1.2500000000000001E-2]
[null,null,"First Lost",null,null,null,3.5000000000000001E-3]
[null,null,"Electronic Equipment ",null,null,null,null,null,null,null,null,null,{"$f":"IF('Proposal Form'!J75>1000000,G24*1000000+G25*('Proposal Form'!J75-1000000),'Proposal Form'!J75*G24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Director",5.0000000000000001E-4]
[null,null,"First 1 million",null,null,null,6.9999999999999999E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction Worker",2.5000000000000001E-2]
[null,null,"Subsequent",null,null,null,5.0000000000000001E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weilder",0.04]
[null,null,"Goods in Transit ",null,null,null,null,null,null,null,null,null,{"$f":"IF('Proposal Form'!J79>1000000,G27*1000000+G28*('Proposal Form'!J79-1000000),'Proposal Form'!J79*G27)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Agent",3.0000000000000001E-3]
[null,null,"First 1 million",null,null,null,3.8E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cleaner",6.4999999999999997E-3]
[null,null,"Subsequent",null,null,null,2.7000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Packer",8.0000000000000002E-3]
[null,null,"Money",null,null,null,null,null,null,null,null,null,{"$f":"G30*'Proposal Form'!J86+G31*'Proposal Form'!J87","v":0}]
[null,null,"Money on Premise",null,null,null,1.5E-3]
[null,null,"Money in Transit",null,null,null,2.5000000000000001E-3]
[null,null,"Fidelity Guarantee",null,null,null,null,null,null,null,null,null,{"$f":"G33*'Proposal Form'!J93+G34*'Proposal Form'!J92","v":0}]
[null,null,"Per Employee",null,null,null,3]
[null,null,"Per Aggregate",null,null,null,5.0000000000000001E-3]
[null,null,"Work Injury Compensation",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K38:K52)","v":0}]
[null,null,62,null,null,null,null,null,14]
[null,null,"Categories of Employees",{"$f":"'Proposal Form'!I119","v":"No. of Employees"},{"$f":"'Proposal Form'!H119","v":0},"Average Monthy Salary","To use","Market Rate",14,"Manual Rate","Subtotal"]
[null,null,{"$f":"IF('Proposal Form'!B120=\"Others\",_xlfn.CONCAT('Proposal Form'!B120,\" - \",'Proposal Form'!F120),'Proposal Form'!B120)","v":0},{"$f":"'Proposal Form'!I120","v":0},{"$f":"'Proposal Form'!H120","v":0},{"$f":"IFERROR('Proposal Form'!J120/'Proposal Form'!I120/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C38,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J120*_xlfn.IFS(G38=\"Market Rate\",H38,G38=\"Technical\",I38,G38=\"Manual\",J38),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B121=\"Others\",_xlfn.CONCAT('Proposal Form'!B121,\" - \",'Proposal Form'!F121),'Proposal Form'!B121)","v":0},{"$f":"'Proposal Form'!I121","v":0},{"$f":"'Proposal Form'!H121","v":0},{"$f":"IFERROR('Proposal Form'!J121/'Proposal Form'!I121/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C39,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J121*_xlfn.IFS(G39=\"Market Rate\",H39,G39=\"Technical\",I39,G39=\"Manual\",J39),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B122=\"Others\",_xlfn.CONCAT('Proposal Form'!B122,\" - \",'Proposal Form'!F122),'Proposal Form'!B122)","v":0},{"$f":"'Proposal Form'!I122","v":0},{"$f":"'Proposal Form'!H122","v":0},{"$f":"IFERROR('Proposal Form'!J122/'Proposal Form'!I122/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C40,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J122*_xlfn.IFS(G40=\"Market Rate\",H40,G40=\"Technical\",I40,G40=\"Manual\",J40),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B123=\"Others\",_xlfn.CONCAT('Proposal Form'!B123,\" - \",'Proposal Form'!F123),'Proposal Form'!B123)","v":0},{"$f":"'Proposal Form'!I123","v":0},{"$f":"'Proposal Form'!H123","v":0},{"$f":"IFERROR('Proposal Form'!J123/'Proposal Form'!I123/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C41,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J123*_xlfn.IFS(G41=\"Market Rate\",H41,G41=\"Technical\",I41,G41=\"Manual\",J41),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B124=\"Others\",_xlfn.CONCAT('Proposal Form'!B124,\" - \",'Proposal Form'!F124),'Proposal Form'!B124)","v":0},{"$f":"'Proposal Form'!I124","v":0},{"$f":"'Proposal Form'!H124","v":0},{"$f":"IFERROR('Proposal Form'!J124/'Proposal Form'!I124/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C42,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J124*_xlfn.IFS(G42=\"Market Rate\",H42,G42=\"Technical\",I42,G42=\"Manual\",J42),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B125=\"Others\",_xlfn.CONCAT('Proposal Form'!B125,\" - \",'Proposal Form'!F125),'Proposal Form'!B125)","v":0},{"$f":"'Proposal Form'!I125","v":0},{"$f":"'Proposal Form'!H125","v":0},{"$f":"IFERROR('Proposal Form'!J125/'Proposal Form'!I125/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C43,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J125*_xlfn.IFS(G43=\"Market Rate\",H43,G43=\"Technical\",I43,G43=\"Manual\",J43),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B126=\"Others\",_xlfn.CONCAT('Proposal Form'!B126,\" - \",'Proposal Form'!F126),'Proposal Form'!B126)","v":0},{"$f":"'Proposal Form'!I126","v":0},{"$f":"'Proposal Form'!H126","v":0},{"$f":"IFERROR('Proposal Form'!J126/'Proposal Form'!I126/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C44,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J126*_xlfn.IFS(G44=\"Market Rate\",H44,G44=\"Technical\",I44,G44=\"Manual\",J44),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B127=\"Others\",_xlfn.CONCAT('Proposal Form'!B127,\" - \",'Proposal Form'!F127),'Proposal Form'!B127)","v":0},{"$f":"'Proposal Form'!I127","v":0},{"$f":"'Proposal Form'!H127","v":0},{"$f":"IFERROR('Proposal Form'!J127/'Proposal Form'!I127/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C45,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J127*_xlfn.IFS(G45=\"Market Rate\",H45,G45=\"Technical\",I45,G45=\"Manual\",J45),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B128=\"Others\",_xlfn.CONCAT('Proposal Form'!B128,\" - \",'Proposal Form'!F128),'Proposal Form'!B128)","v":0},{"$f":"'Proposal Form'!I126","v":0},{"$f":"'Proposal Form'!H126","v":0},{"$f":"IFERROR('Proposal Form'!J126/'Proposal Form'!I126/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C46,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J128*_xlfn.IFS(G46=\"Market Rate\",H46,G46=\"Technical\",I46,G46=\"Manual\",J46),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B129=\"Others\",_xlfn.CONCAT('Proposal Form'!B129,\" - \",'Proposal Form'!F129),'Proposal Form'!B129)","v":0},{"$f":"'Proposal Form'!I128","v":0},{"$f":"'Proposal Form'!H128","v":0},{"$f":"IFERROR('Proposal Form'!J128/'Proposal Form'!I128/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C47,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J129*_xlfn.IFS(G47=\"Market Rate\",H47,G47=\"Technical\",I47,G47=\"Manual\",J47),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B130=\"Others\",_xlfn.CONCAT('Proposal Form'!B130,\" - \",'Proposal Form'!F130),'Proposal Form'!B130)","v":0},{"$f":"'Proposal Form'!I129","v":0},{"$f":"'Proposal Form'!H129","v":0},{"$f":"IFERROR('Proposal Form'!J129/'Proposal Form'!I129/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C48,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J130*_xlfn.IFS(G48=\"Market Rate\",H48,G48=\"Technical\",I48,G48=\"Manual\",J48),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B131=\"Others\",_xlfn.CONCAT('Proposal Form'!B131,\" - \",'Proposal Form'!F131),'Proposal Form'!B131)","v":0},{"$f":"'Proposal Form'!I130","v":0},{"$f":"'Proposal Form'!H130","v":0},{"$f":"IFERROR('Proposal Form'!J130/'Proposal Form'!I130/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C49,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J131*_xlfn.IFS(G49=\"Market Rate\",H49,G49=\"Technical\",I49,G49=\"Manual\",J49),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B132=\"Others\",_xlfn.CONCAT('Proposal Form'!B132,\" - \",'Proposal Form'!F132),'Proposal Form'!B132)","v":0},{"$f":"'Proposal Form'!I131","v":0},{"$f":"'Proposal Form'!H131","v":0},{"$f":"IFERROR('Proposal Form'!J131/'Proposal Form'!I131/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C50,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J132*_xlfn.IFS(G50=\"Market Rate\",H50,G50=\"Technical\",I50,G50=\"Manual\",J50),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B133=\"Others\",_xlfn.CONCAT('Proposal Form'!B133,\" - \",'Proposal Form'!F133),'Proposal Form'!B133)","v":0},{"$f":"'Proposal Form'!I132","v":0},{"$f":"'Proposal Form'!H132","v":0},{"$f":"IFERROR('Proposal Form'!J132/'Proposal Form'!I132/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C51,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J133*_xlfn.IFS(G51=\"Market Rate\",H51,G51=\"Technical\",I51,G51=\"Manual\",J51),0)","v":0}]
[null,null,{"$f":"IF('Proposal Form'!B134=\"Others\",_xlfn.CONCAT('Proposal Form'!B134,\" - \",'Proposal Form'!F134),'Proposal Form'!B134)","v":0},{"$f":"'Proposal Form'!I133","v":0},{"$f":"'Proposal Form'!H133","v":0},{"$f":"IFERROR('Proposal Form'!J133/'Proposal Form'!I133/12,0)","v":0},"Market Rate",{"$f":"IFERROR(VLOOKUP(C52,WICA!C:D,2,FALSE),0%)","v":0},14,null,{"$f":"IFERROR('Proposal Form'!J134*_xlfn.IFS(G52=\"Market Rate\",H52,G52=\"Technical\",I52,G52=\"Manual\",J52),0)","v":0}]
[null,null,"Personal Accident",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K55:K56)","v":0}]
[null,null,"Accidental Death and Permanent Disability Rate",null,null,null,"Medical Expenses Rate",null,"Category",null,"Subtotal"]
[null,null,{"$f":"0.0277%/0.85","v":3.258823529411765E-4},null,null,null,{"$f":"0.892%/0.85","v":1.0494117647058826E-2},null,"Non Manual",null,{"$f":"SUMPRODUCT('Proposal Form'!J140:L140,'Proposal Form'!J142:L142)*'Pricing '!C55+SUMPRODUCT('Proposal Form'!J141:L141,'Proposal Form'!J142:L142)*'Pricing '!G55","v":0}]
[null,null,{"$f":"0.0513%/0.85","v":6.0352941176470588E-4},null,null,null,{"$f":"1.652%/0.85","v":1.9435294117647058E-2},null,"Manual",null,{"$f":"(C56*'Proposal Form'!J145+G56*'Proposal Form'!J146)*'Proposal Form'!J147","v":0}]
[null,null,"Machinery Breakdown",null,null,null,null,null,null,null,null,null,{"$f":"IF('Proposal Form'!J150>100000,G58*100000+('Proposal Form'!J150-100000)*G59,G58*'Proposal Form'!J150)","v":0}]
[null,null,"First 100,000",null,null,null,5.174999999999999E-3]
[null,null,"Subsequent",null,null,null,2.5300000000000001E-3]
[]
[null,null,null,null,null,null,null,null,null,null,"Gross Premium",null,{"$f":"SUM(M4:M59)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"GST @ 8%",null,{"$f":"M61*0.08","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Proposed Premium",null,{"$f":"M61+M63","v":0}]

{"sheet":"WICA","index":9,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Others",0.09]
[null,null,"Admin",5.0000000000000001E-4]
[null,null,"Marketer",2.5000000000000001E-3]
[null,null,"Airconditioning Servicer/ Installer",8.5000000000000006E-3]
[null,null,"Groundcrew ",1.4999999999999999E-2,null,"Ground crew"]
[null,null,"Airport Service Staff",5.0000000000000001E-3]
[null,null,"Auctioneers",3.4999999999999996E-3]
[null,null,"Bartender",3.5000000000000001E-3,null,2.5000000000000001E-3]
[null,null,"Bellboy",5.0000000000000001E-3]
[null,null,"Beautician (Face, Nails, Weight loss, Skin)",2.5000000000000001E-3]
[null,null,"Bedding & Mattress Manufacturer",1.2500000000000001E-2]
[null,null,"Bookbinder ",1.2500000000000001E-2]
[null,null,"Boot & Shoes Manufacturer",1.2500000000000001E-2]
[null,null,"Brewer",1.2500000000000001E-2]
[null,null,"Brush Manufacturer",1.2500000000000001E-2]
[null,null,"Butcher",0.01]
[null,null,"Concierge",1.5E-3]
[null,null,"Cashier",2.5000000000000001E-3]
[null,null,"Car Cleaners",8.0000000000000002E-3,null,"Internal Cleaner"]
[null,null,"Chef/Cook",5.0000000000000001E-3,null,null,1.4999999999999999E-2]
[null,null,"Church staffs & religious organisation",1E-3]
[null,null,"Cleaner (Excluding external works)",6.4999999999999997E-3]
[null,null,"Construction Worker",0.02]
[null,null,"Die Cutters/Sinkers/Engravers",1.4999999999999999E-2]
[null,null,"Director/Management Executive",5.0000000000000001E-4]
[null,null,"Domestic animal breeder & trainer",5.0000000000000001E-3]
[null,null,"Driver",1.2500000000000001E-2]
[null,null,"Education Institutes Staff",1E-3]
[null,null,"Electric Battery Manufacturer",1.2500000000000001E-2]
[null,null,"Electrical Engineers",0.01,null,0.5]
[null,null,"Electronics Manufacturer",1.2500000000000001E-2]
[null,null,"Fishmonger",0.01]
[null,null,"Food Stall Keeper",3.5000000000000001E-3]
[null,null,"Florist",5.0000000000000001E-3]
[null,null,"Food & Beverage Manufacturer",1.4999999999999999E-2]
[null,null,"Furniture Dealer/Remover",0.01,null,1]
[null,null,"General Estate Management Contractors",0.01]
[null,null,"General Worker - Landscaping",1.4999999999999999E-2,null,0.2]
[null,null,"General Workers (Real Estate Management)",0.01]
[null,null,"Goldsmith/Silversmith",1.2500000000000001E-2]
[null,null,"Hairdresser",2.5000000000000001E-3]
[null,null,"Housekeeper",5.0000000000000001E-3]
[null,null,"Ink Manufacturer",1.2500000000000001E-2]
[null,null,"Jewellers",1.2500000000000001E-2]
[null,null,"Leather Dressers & Dyers",1.2500000000000001E-2,null,"hot works"]
[null,null,"Lodging Operator",2.5000000000000001E-3]
[null,null,"Manager",5.0000000000000001E-4]
[null,null,"Mechanic/Electrical Engineer (excluding hotworks)",1.4999999999999999E-2]
[null,null,"Mechanic/Electrical Engineer (including hotworks/welding)",0.03]
[null,null,"Metal Workers (Heavy)",0.02]
[null,null,"Metal Workers (Moderate)",1.4999999999999999E-2,null,0.25]
[null,null,"Musical Instruments Manufacturer",1.2500000000000001E-2]
[null,null,"Doctor (General Practitioner/Specialist)",2.5000000000000001E-3]
[null,null,"Nurse/Doctor's Assistant",2.5000000000000001E-3]
[null,null,"Office Admin/Clerical Staff",5.0000000000000001E-4]
[null,null,"Optician",2.5000000000000001E-3]
[null,null,"Packer",8.0000000000000002E-3]
[null,null,"Pest Control Staff",0.01]
[null,null,"Photographers",4.5000000000000005E-3]
[null,null,"Picture Frame Maker/Moulder/Glider/Dealer",1.2500000000000001E-2]
[null,null,"Plumber/Sanitary Installation Contractors",1.4999999999999999E-2]
[null,null,"Potter",1.2500000000000001E-2]
[null,null,"Poulterer",0.01]
[null,null,"Produce Dealer",8.0000000000000002E-3]
[null,null,"Radiographer",2.5000000000000001E-3]
[null,null,"Rattan/Basket Maker",1.2500000000000001E-2]
[null,null,"Renovation Contractors (Interior)",1.4999999999999999E-2]
[null,null,"Retail Staff",2.5000000000000001E-3]
[null,null,"Sales Agent",3.0000000000000001E-3]
[null,null,"Scientific/Surgical Instrument/Appliance Manufacturer",1.2500000000000001E-2]
[null,null,"Security Guard",1.2500000000000001E-2]
[null,null,"Service Staff",2.5000000000000001E-3]
[null,null,"Sign Writer & Maker",0.01]
[null,null,"Soap/Perfume Maker",0.01]
[null,null,"Storeman",8.0000000000000002E-3]
[null,null,"Supervisor (Indoor)",2.5000000000000001E-3]
[null,null,"Supervisor (Outdoor)",5.0000000000000001E-3,null,"admin"]
[null,null,"Surveyor",5.0000000000000001E-3]
[null,null,"Tailor/Seamtress",4.5000000000000005E-3]
[null,null,"Teacher (all levels)",3.0000000000000001E-3]
[null,null,"Umbrella  Manufacturer",1.2500000000000001E-2]
[null,null,"Vehicle Assembler",1.4999999999999999E-2]
[null,null,"Video Arcade/Saloon Operators",1.5E-3]
[null,null,"Waiters/Waitresses",2.5000000000000001E-3]
[null,null,"Watchmaker"]

{"sheet":"Quotation Slip (old)","index":10,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":true,"merged":[[32,8,32,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[0,0,0,10],[12,0,12,10],[15,1,15,9],[19,0,19,10],[21,0,21,10],[1,0,1,10],[20,8,20,9],[34,8,34,9],[33,8,33,9],[61,7,61,9],[62,7,62,9],[66,1,66,9],[40,0,40,10],[59,1,59,3],[60,1,60,3],[41,1,41,4],[59,7,59,9],[60,7,60,9],[47,1,47,4],[44,1,44,4],[53,1,53,9],[37,1,37,9],[39,8,39,9]]}
["QOUTATION SLIP"]
["ALLIANZ COMMERCIAL EDGE"]
[]
[null,"Intermediary Code",null,":",{"$f":"'Proposal Form'!H7","v":0}]
[null,"Intermediary",null,":",{"$f":"'Proposal Form'!H6","v":0}]
[null,"Policyholder/Insured",null,":",{"$f":"'Proposal Form'!H12","v":0}]
[null,"SSIC",null,":",{"$f":"'Proposal Form'!H14","v":0}]
[null,"UEN",null,":",{"$f":"'Proposal Form'!H13","v":0}]
[null,"Address",null,":",{"$f":"'Proposal Form'!H15","v":0}]
[null,"Nature of Business",null,":",{"$f":"'Proposal Form'!H16","v":0}]
[null,"Period of Insurance",null,":",{"$f":"'Proposal Form'!H17","v":"00:00:00"},"to",{"$f":"'Proposal Form'!J18","v":0},null,"(both dates inclusive)"]
[null,"Premium",null,":",{"$f":"'Pricing '!M65","v":0}]
[]
[]
[null,"The Property Insured"]
[null,"On the following property belonging to the Insured or held by the Insured or on commission or for which the Insured hold itself responsible:"]
[]
[null,"Locations of Risk",null,":",{"$f":"'Proposal Form'!#REF!","v":{"$error":"#REF!"}}]
[null,"Occupied as",null,":",{"$f":"'Proposal Form'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Coverages",null,null,null,null,"Excess",null,"Limit of Liability"]
[]
[null,"Property",null,null,null,null,{"$f":"'Proposal Form'!J36","v":0},null,{"$f":"'Proposal Form'!J29","v":0}]
[null,"Business Interruption",null,null,null,null,"N/a",null,{"$f":"'Proposal Form'!J54","v":0},"$xxx,xxx"]
[null,"Glass",null,null,null,null,{"$f":"'Proposal Form'!J67","v":0},null,{"$f":"'Proposal Form'!J66","v":0}]
[null,"Public Liability",null,null,null,null,{"$f":"'Proposal Form'!J102","v":0},null,{"$f":"'Proposal Form'!J100","v":0}]
[null,"Product Liability",null,null,null,null,{"$f":"'Proposal Form'!J109","v":0},null,{"$f":"'Proposal Form'!J107","v":0}]
[null,"Money",null,null,null,null,{"$f":"'Proposal Form'!J89","v":0},null,{"$f":"'Proposal Form'!J86","v":0}]
[null,"Goods in Transit",null,null,null,null,{"$f":"'Proposal Form'!J83","v":0},null,{"$f":"'Proposal Form'!J79","v":0}]
[null,"Electronic Equipment",null,null,null,null,{"$f":"'Proposal Form'!J76","v":0},null,{"$f":"'Proposal Form'!J75","v":0}]
[null,"Fidelity Guarantee",null,null,null,null,{"$f":"'Proposal Form'!J95","v":0},null,{"$f":"'Proposal Form'!J92","v":0}]
[null,"Personal Accident",null,null,null,null,"N/a",null,{"$f":"'Proposal Form'!J145*'Proposal Form'!J147+'Proposal Form'!J140*'Proposal Form'!J142","v":0}]
[null,"Machinery Breakdown",null,null,null,null,{"$f":"'Proposal Form'!J151","v":0},null,{"$f":"'Proposal Form'!J150","v":0}]
[null,"Burglary",null,null,null,null,{"$f":"'Proposal Form'!J71","v":0},null,{"$f":"'Proposal Form'!J70","v":0}]
[null,"Workmen Injury Compensation",null,null,null,null,"N/a",null,{"$f":"SUMPRODUCT('Proposal Form'!I120:I133,'Proposal Form'!J120:J133)","v":0}]
[]
[]
[null,"Subject to the following extensions as in the Policy Wording. Limit of Liability and Excess is as per Polcy Wording unless stated otherwise:"]
[]
[null,"Extensions",null,null,null,null,"Excess",null,"Limit of Liability"]
[]
[null,"Section 1A - All Risk"]
[8,{"$f":"VLOOKUP(A43,Dropdown!Q:AM,VLOOKUP('Quotation Slip (old)'!$B$42,Dropdown!N:O,2,FALSE),FALSE)","v":"Demonstration and Exhibition"}]
[9,{"$f":"VLOOKUP(A44,Dropdown!Q:AM,VLOOKUP('Quotation Slip (old)'!$B$42,Dropdown!N:O,2,FALSE),FALSE)","v":"Fire Extinguishing Expenses/Fire Brigade Charges"}]
[null,"Section 4 - Goods in Transit"]
[21,{"$f":"VLOOKUP(A46,Dropdown!Q:AM,VLOOKUP('Quotation Slip (old)'!B45,Dropdown!N:O,2,FALSE),FALSE)","v":0}]
[null,{"$f":"VLOOKUP(A47,Dropdown!Q:AM,VLOOKUP('Quotation Slip (old)'!B46,Dropdown!N:O,2,FALSE),FALSE)","v":{"$error":"#N/A"}}]
[null,"Section 7 - Personal Accident"]
[3,{"$f":"VLOOKUP(A49,Dropdown!Q:AM,VLOOKUP('Quotation Slip (old)'!B48,Dropdown!N:O,2,FALSE),FALSE)","v":"Ambulance/Transport Fee"}]
[null,{"$f":"VLOOKUP(A50,Dropdown!Q:AM,VLOOKUP('Quotation Slip (old)'!B49,Dropdown!N:O,2,FALSE),FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Subject otherwise to the terms, exceptions and conditions of the Allianz Commercial Edge Insurance Policy."]
[]
[]
[]
[]
[]
[]
[null,"Issue Date",null,null,null,null,null,"Hicham Raissi"]
[null,null,null,null,null,null,null,"Chief Executive Officer"]
[null,null,null,null,null,null,null,"Allianz Insurance Singapore Pte. Ltd."]
[]
[]
[null,"Note: "]
[null,"This Policy Schedule shall be read in conjunction with the Policy Wording as one contract. Please refer to the Policy Wording for the exact terms and conditions as well as the full list of exclusions."]

{"sheet":"Cover Note","index":11,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"merged":[[0,0,0,9],[12,0,12,9]]}
["COVER NOTE"]
[]
["1st July 2020",null,null,null,null,null,null,null,null,"COM/AIS/2020/000001"]
[]
[]
[{"$f":"'Proposal Form'!H12","v":0}]
[{"$f":"'Proposal Form'!H15","v":0}]
[]
[]
[]
["Dear Sirs,"]
[]
["We confirm holding covered from the date stated below for a period not exceeding 30 days or until a policy has been delivered to you by the Company or notice has been given by the Company that it cannot accept the risk, whichever may first occur. The cover hereby granted is declared and agreed to be subject to all the terms, conditions and clauses of the Company’s Policy Form used for this class of insurance."]
[]
[]
["Insured",null,null,":",{"$f":"A6","v":0}]
[]
["Business Address",null,null,":",{"$f":"A7","v":0}]
[]
["Period of Insurance (both dates inclusive)",null,null,":",{"$f":"'Proposal Form'!H17","v":"00:00:00"},"to",{"$f":"'Proposal Form'!J18","v":"00:00:00"}]
[]
[]
["COVERAGES",null,null,":","Details as agreed per Quotation Slip"]
["Section 1A - All Risk"]
["Section 1B - Fire & Extraneous Perils"]
["Section 1C - Business Interruption"]
["Section 1D - Glass"]
["Section 2A - Public Liability"]
["Section 2B - Product Liability"]
["Section 3 - Money"]
["Section 4 - Goods in Transit"]
["Section 5 - Electronic Equipment"]
["Section 6 - Fidelity Guarantee"]
["Section 7 - Personal Accident"]
["Section 8 - Machinery Breakdown"]
["Section 9 - Burglary"]
["Section 10 - Work Injury Compensation"]
[]
[]
["Yours faithfully,"]
["(Signature)"]

{"sheet":"Welcome Email","index":12,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":true,"merged":[[27,0,27,1],[30,0,30,8],[45,0,45,8],[4,0,4,8],[10,0,10,8],[17,0,17,8],[24,0,24,1],[25,0,25,1],[26,0,26,1]]}
[]
["Dear Intermediary"]
[]
[]
["Thank you for your partnership with Allianz Insurance Singapore in bringing financial security to your client. "]
[]
["We are pleased to confirm cover and attach your client’s e-Policy documents for your reference. "]
[]
[]
["Password protection"]
["In our efforts to keep your client’s personal data secured, the attached documents with personal data are password protected. "]
[]
[]
["The password shall be your client's Company UEN"]
[]
[null,"Example: 200302053W"]
[]
["Please review the attached documents and ensure that all the particulars detailed in the Policy Schedule are accurate."]
[]
[]
["Policy Summary"]
["Meanwhile for quick reference, below is a summary of your client’s policy details:"]
[]
[]
["Product",null,":","ALLIANZ COMMERCIAL EDGE"]
["Policy Number",null,":","SG0000527631"]
["Policyholder",null,":",{"$f":"'Proposal Form'!H12","v":0}]
["Period of Cover",null,":",{"$f":"'Proposal Form'!H17","v":"00:00:00"},"to",{"$f":"'Proposal Form'!J18","v":0},null,"(Both dates inclusive)"]
[]
[]
["Please do not hesitate to reach out to your Allianz Business Development Manager should you require further assistance. "]
[]
[]
["Thank you once again for allowing Allianz take care of your client’s financial needs. "]
["We care about what matters to your client. "]
[]
[]
["Sincerely"]
[]
["Allianz Insurance Singapore Pte. Ltd."]
[]
[]
[]
[]
["This is a computer-generated document and does not require any signature."]
["Please note: This email and any files transmitted with it are intended only for the named recipient(s) and may contain confidential and/or privileged information. If you are not the intended recipient, kindly notify the sender immediately. Please delete the email and any copies of it thereafter. Thank you. "]

{"sheet":"Receipt","index":13,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[[12,1,12,9],[11,1,11,8],[11,9,11,10],[0,0,0,10],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,3,6,10],[7,3,7,10],[8,3,8,10],[10,4,10,9]]}
["Official Receipt"]
[]
[null,"LIM LIANG ZHI ",null,null,null,null,"Date",":","2021-03-11"]
[null,"xx SHEPHERDS DRIVE",null,null,null,null,"Code",":","0000043"]
[null,"SHEPHERDS HILL ESTATE",null,null,null,null,"Payment Mode",":","Credit Card or Others"]
[null,"SINGAPORE xxxxx",null,null,null,null,"Voucher No",":","NA or 00000002281"]
[]
[null,"Policy Number",":","SP2000204xxx"]
[null,"Policyholder",":","Lim Liang Zhi"]
[null,"Total Amount Received",":","S$",12249.99]
[]
[]
[null,"Other Information"]
[]
[]
[]
[]
[null,"This is a computerised document. No signature is required."]

{"sheet":"Renewal Notice","index":14,"n_rows":93,"n_cols":30,"rows_kept":93,"cut":false,"hidden":true,"merged":[[61,9,61,12],[12,17,12,18],[14,18,14,19],[17,10,18,19],[21,21,21,22],[23,21,24,31],[26,21,26,22],[27,21,27,22],[31,21,32,31],[36,27,36,31],[38,27,38,28],[3,10,3,16],[4,10,4,16],[5,10,5,16],[6,10,6,16],[60,9,60,12],[90,5,90,6],[73,9,73,10],[74,11,75,19],[76,11,77,19],[78,11,81,19],[80,3,81,4],[83,4,83,7],[85,5,85,6],[86,5,86,6],[87,5,87,6],[56,0,56,8],[57,0,57,8],[60,3,60,5],[28,1,30,7],[23,1,26,7],[66,1,69,1],[66,2,69,2],[66,3,66,5],[67,3,67,5],[68,3,68,5],[69,3,69,5],[92,5,92,7],[71,3,71,5],[72,3,72,5],[73,3,73,5],[59,3,59,5],[70,3,70,5],[61,3,61,5],[62,3,62,5],[63,3,63,5],[64,3,64,5],[65,3,65,5],[91,5,91,6],[88,5,89,6],[77,1,77,3],[80,2,81,2],[78,1,79,7],[1,21,1,32],[89,9,89,10],[90,9,90,10],[91,9,91,10],[89,12,89,18],[90,12,90,18],[91,12,91,18],[19,10,19,14],[20,10,20,14],[56,9,56,20],[57,9,57,12],[58,9,58,12],[59,9,59,12],[1,17,1,19],[1,10,1,16],[2,10,2,16],[6,21,6,22],[7,21,7,22],[8,21,8,22],[9,21,9,22],[2,21,2,22],[3,21,3,22],[10,21,10,22],[11,21,11,22],[12,21,12,22],[16,27,16,28],[16,21,16,22]]}
[]
[null,"Date",":",null,null,null,null,null,null,null,"Benefits",null,null,null,null,null,null,"Limit of Liability / Sum Insured (SGD)  ",null,null,null,"Payment Advice"]
[null,null,null,null,null,null,null,null,null,null,"Money",null,null,null,null,null,null,null,null,10000,null,"Policy No",null,":",null,null,null,"Total Premium",null,":"]
[null,"Policyholder",null,null,null,null,null,null,null,null,"Sub-limits",null,null,null,null,null,null,null,null,null,null,"Intermediary Code",null,":"]
[null,"Address 1",null,null,null,null,null,null,null,null,"In transit ",null,null,null,null,null,null,null,null,10000]
[null,"Address 2",null,null,null,null,null,null,null,null,"In Premises in locked safe ",null,null,null,null,null,null,null,null,10000,null,"q","Bank Transfer"]
[null,"Singapore <postal code> ",null,null,null,null,null,null,null,null,"In locked drawers/cash registers within Premises ",null,null,null,null,null,null,null,null,1000,null,"Bank Name",null,":","ALLIANZ INSURANCE SINGAPORE PTE. LTD."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bank",null,":","HSBC BANK "]
[null,null,null,null,null,null,null,null,null,null,"Goods in Transit",null,null,null,null,null,null,null,null,5000,null,"Account",null,":","052- 823754-002"]
[null,null,null,null,null,null,null,null,null,null,"Glass Breakage and Signs",null,null,null,null,null,null,null,null,10000,null,"Currency",null,":","SGD"]
[null,"Policy No. ",": «policy_no»",null,null,null,null,null,null,null,"Electronic Equipment",null,null,null,null,null,null,null,null,20000,null,"Swift Code",null,":","HSBCSGSG"]
[null,"Intermediary",":",null,null,null,null,null,null,null,"Fidelity Guarantee",null,null,null,null,null,null,null,null,5000,null,"Address",null,":","79 ROBINSON ROAD #09-01 SINGAPORE 068897"]
[null,"Policyholder",":",null,null,null,null,null,null,null,"Personal Accident (up to 5 Employees)",null,null,null,null,null,null,"per Employee",null,50000,null,"Payment Remarks",null,":","Please indicate Policy/invoice number/ref number & nature of payment"]
[null,"Period of Insurance",": ",null,null,null,null,null,null,null,"Machinery Breakdown",null,null,null,null,null,null,null,null,20000]
[null,null,null,null,null,null,null,null,null,null,"Fire and Other Perils (Building)",null,null,null,null,null,null,null,"$<Min 75k, Max 2mil>"]
[null,"Dear Client",null,null,null,null,null,null,null,null,"Work Injury Compensation ",null,null,null,null,null,null,null,null,null,null,"q","Cheque/Bank Draft"]
[null,null,null,null,null,null,null,null,null,null,"Place / Places of Employment",null,null,null,null,null,null,null,null,null,null,"Bank Name",null,":",null,null,null,"Cheque No",null,":"]
[null,"<NAME OF PLAN> - RENEWAL INVITATION",null,null,null,null,null,null,null,null,"Anywhere in Singapore in connection with the Insured’s business and as governed by The Work Injury Compensation Act.",null,null,null,null,null,null,null,null,null,null,"To be crossed and made payable to Allianz Insurance Singapore Pte. Ltd."]
[]
[null,"Thank you for insuring with Allianz Insurance Singapore Pte. Ltd. ",null,null,null,null,null,null,null,null,"No of  Employees",null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Estimated Annual Earnings",null,null,null,null,null,null,null,null,580000,null,"q","Credit Card"]
[null,"It has been a privilege to provide the insurance cover for your business needs. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cardholder's Name",null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Relationship (where cardholder is not the insured)"]
[null,"Your Policy will expire on <date of expiry>. We are pleased to invite renewal based on the details as stated herein. To ensure continuous insurance cover, kindly complete the Renewal Notice and return the duly completed Renewal Notice to your Insurance Intermediary or Allianz Insurance Singapore Pte. Ltd. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Your security is our concern. If cardholder is not Insured nor the Insured’s spouse, parent, parent-in-law, child or sibling, Allianz reserves the right to reject"]
[]
[null,null,null,null,null,null,null,null,null,null,"Subject otherwise to the terms, exceptions and conditions of the Allianz Smart SME Insurance Policy."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Card No.",null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expiry",null,":",null,null,null,null,"CVV",":"]
[null,"Should you require further assistance, please reach out to your Insurance Intermediary or call us at 1800-222-1818, Monday – Friday, between 9am and 5pm or email us at customerservice@allianz.com.sg."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I hereby conﬁrm that the information given above is correct. I agree to Allianz collecting, using and disclosing my personal data for the purposes of processing this payment arrangement."]
[null,"We look forward to being of service to you and your business again."]
[]
[null,"Sincerely"]
[]
[null,"Allianz Insurance Singapore Pte. Ltd. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature of Cardholder"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,":"]
[]
[]
[null,"This is a system generated letter. No signature is required. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RENEWAL NOTICE",null,null,null,null,null,null,null,null,"Renewal Instructions"]
["<NAME OF PLAN>",null,null,null,null,null,null,null,null,"Policy No",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,"Intermediary",null,null,null,":"]
[null,"Date of Issue",":",null,null,null,null,null,null,"Intermediary Code",null,null,null,":"]
[null,"Reference No ",": ","<old Policy Number>",null,null,null,null,null,"Policyholder",null,null,null,":"]
[null,"Type of Cover",":","ALLIANZ SMART SME - EXTRA",null,null,null,null,null,"Period of Insurance",null,null,null,":"]
[null,"Intermediary Code",":"]
[null,"Intermediary",":",null,null,null,null,null,null,"q","Please renew the Policy above as invited, with terms and conditions as set out in the expiring Policy."]
[null,"Policyholder ",":",null,null,null,null,null,null,"q","Please furnish a new Quotation based on the following changes:"]
[null,"UEN",": "]
[null,"Correspondence Address",": ","<Block No/Street Name>"]
[null,null,null,"<unit no.> "]
[null,null,null,"<Building Name>"]
[null,null,null,"<Country> <postal code>"]
[null,"Nature of Business",":","<description of business>",null,null,null,null,null,null,"Otherwise, subject to the terms and conditions as set out in the expiring Policy."]
[null,"Policy Number ",":","<old policy number>",null,null,null,null,null,"q","Please allow Policy to expire without renewal"]
[null,"Policy Expiry Date",": ","<Expiry Date>"]
[null,"Renewal Period of Insurance",":","From < InceptionDate> To <ExpiryDate> (both dates inclusive)",null,null,null,null,null,"Important Notes",null,":"]
[null,"Renewal Premium ",": ","SGD ",null,null,null,null,null,null,"1)","To ensure that your Policy is adequate, please review the coverage and sum insured according to your current business needs. "]
[null,"GST 7%",":","SGD"]
[null,"Total Renewal Premium",": ","SGD",null,null,null,null,null,null,"2)","Renewal of this Policy is invited subject to there being no events or claims occurring prior to expiry of the existing period which may change, influence or increase the circumstances of this insurance. "]
[null,"The Property Insured"]
[null,"On the following property belonging to the Insured or held by the Insured or on commission or for which the Insured hold itself responsible:",null,null,null,null,null,null,null,null,"3)","Statement pursuant to Section 25(5) of the Insurance Act (Cap. 142) or any amendments thereof: You are to disclose to us, fully and faithfully, all the facts which you know or ought to know, otherwise the policy issued may be void and you may not receive any benefits from your Policy."]
[]
[null,"Location of Risks",":","2 Balestier Road \n#03-659 Singapore 320002"]
[]
[]
[null,"Benefits",null,null,"Limit of Liability / Sum Insured (SGD)  ",null,null,null,null,"We confirm acceptance of the above quote subject to the terms and conditions as set out in the Policy to be issued."]
[null,"All Risks (Contents and Stocks)"]
[null,"Sub-limits"]
[null,"Curios and works of art  ",null,null,null,"per item",null,2000]
[null,"Any one item of equipment or machinery   ",null,null,null,null,null,50000,null,"Signature & Company Stamp, if applicable"]
[null,"Employees’ personal effects    ",null,null,null,"per Employee in aggregate",null,250]
[null,null,null,null,null,null,null,1000,null,"Name",null,":"]
[null,"Business Interruption",null,null,null,"per day",null,200,null,"Designation",null,":"]
[null,"Public Liability",null,null,null,null,null,1000000,null,"Date",null,":"]
[null,"24-hour Emergency Workplace Assistance",null,null,null,"4 times per year, up to $200 per visit"]

{"sheet":"Certificate of Insurance","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Claims Form","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Template","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Dropdown","index":18,"n_rows":57,"n_cols":33,"rows_kept":57,"cut":false,"hidden":true,"merged":[[0,13,0,14]]}
["Yes/No","Type of Cover","Age of Building ","Waiting Period","First Lost/Full Value","Occupied as","Category of staff","Principal/Landlord/Tenant","Limit of Public Liability","Sedentary Level","WICA","BI (Indemnity Period)",null,"Sections",null,null,null,"Section 1A - All Risk","Section 1B - Fire & Extraneous Perils","Section 1C - Business Interruption","Section 1D - Glass","Section 2A - Public Liability","Section 2B - Product Liability","Section 3 - Money","Section 4 - Goods in Transit","Section 5 - Electronic Equipment","Section 6 - Fidelity Guarantee","Section 7 - Personal Accident","Section 8 - Machinery Breakdown","Section 9 - Burglary","Section 10 - Work Injury Compensation","WICA employee categories","WICA rates"]
[]
["Yes","All Risks","Pre-war",6,"First Lost","Shop/Retail","Management","Principal","N/A","All","Market Rate",3,null,"Section 1A - All Risk",2,null,1,"All Other Contents","All Other Contents","Professional Accountant’s Charges","Awnings, Blinds, Signs Or Other Outdoor Fixtures Or Fittings","Alterations and Repairs",null,"Armed Robbery and/or Hold-Up",null,"Automatic Cover","Professional Accountant's Charges","Accidental Death Due to Natural Catastrophe","Expedition Expenses","All Other Contents","Social and Recreational Activities","Admin/Director/Management/Consultant(non-manual, indoor)",5.0000000000000001E-4]
["No","Fire & Extraneous Perils","Post-war",24,"Full Value","Office","Executive","Landlord",1000000,"Very","Technical",6,null,"Section 1B - Fire & Extraneous Perils",3,null,2,"Alterations and Repairs","Alterations and Repairs","Accumulated Stocks","Cost of Temporary Protection","Car Park Liability",null,"Damage to Safe or Strongroom",null,"Automatic Reinstatement of Loss","Automatic Inclusion and Deletion","Amateur Sports","Hire of Substitute Item","Alterations and Repairs","Travel to and from Work Extension (Exclude all two wheelers)","Management/Consultant/Supervisor/Architects/Surveyor(nonmanual,outdoor)",8.0000000000000004E-4]
[null,null,null,48,null,"Factory/Workshop","Staff with access to money","Tenant",2000000,"Equal","Manual",9,null,"Section 1C - Business Interruption",4,null,3,"Tenants’ Improvements","Tenants’ Improvements","Alternative Basis","Automatic Reinstatement of Loss","Cross Liability Clause",null,"Money in Private Residences",null,"Costs Of Reinstating Data","One Automatic Reinstatement of Loss","Ambulance/Transport Fee","Debris Removal","Appraisement","Vocational Training Attachment","Cashier",2.5000000000000001E-3]
[null,null,null,72,null,"Warehouse/Storage","Staff without access to money",null,5000000,"Less",null,12,null,"Section 1D - Glass",5,null,4,"Cost of Demolition, Removal of Debris, Clearing and Erection of Hoarding","Cost of Demolition, Removal of Debris, Clearing and Erection of Hoarding","Appraisement","Cost of Demolition, Removal of Debris, Clearing and Erection of Hoarding Clause","Defective Sanitary Arrangement",null,"Automatic Reinstatement of Loss",null,"Expedition Expenses","Payment on Account","Bereavement Allowance/Grant","Repair Cost Investigation","Armed Robbery and Hold Up","Voluntary Sliding Scale","Cleaner / Housekeeper / Waiter",6.4999999999999997E-3]
[null,null,null,null,null,"Hotel",null,null,10000000,"None",null,18,null,"Section 2A - Public Liability",6,null,5,"Architects’, Surveyors’ and Consultant Engineers’ Fees","Architects’, Surveyors’ and Consultant Engineers’ Fees","Automatic Reinstatement","Errors and Omissions Clause","Demonstration, Exhibition and Promotion",null,"Credit Card Chits Clause",null,"Hire of Substitute Item","Interlocking Cover","Child Education Fund","Deterioration of Stock in Freezers and/or Refrigerators","Automatic Reinstatement of Loss","Automatic cover for new employees","Cleaner (external works, no works at height)",8.0000000000000002E-3]
[null,null,null,null,null,"Dormitory",null,null,null,null,null,24,null,"Section 2B - Product Liability",7,null,6,"Cost of Recompiling, Rewriting Records and Claims Preparation","Cost of Recompiling, Rewriting Records and Claims Preparation","Business Conducted Other Than At Location","Misdescription","Employees' or Guests' Effects",null,"Employees' or Guests' Effects",null,"Measures Taken in Avoidance of Impending Loss or Damage","Prima Facie Evidence","Coma",null,"Breach of Conditions and/or Warranties","Business Disruption Assistance Benefits","Chef / Kitchen Helper / Butcher",5.0000000000000001E-3]
[null,null,null,null,null,"Other",null,null,null,null,null,36,null,"Section 3 - Money",8,null,7,"Cost of Temporary Protection","Cost of Temporary Protection","Denial of Access  ","Non-Invalidation","Employee Training",null,"Keys , Locks and Combinations",null,"New Location","Loss caused by Unidenitfiable Employees","Daily Hospital Cash",null,"Capital Additions","Business Travek Clause","Delivery/Logistics/Drivers/Packers",1.2500000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 4 - Goods in Transit",9,null,8,"Demonstration and Exhibition","Demonstration and Exhibition","Department",null,"False Arrest",null,"Personal Accident Benefits",null,"Removal of Debris",null,"Disappearance",null,"Contract Price","Cross Liability","Engineer / Supervisor (outdoor, semi-manual)",8.5000000000000006E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 5 - Electronic Equipment",10,null,9,"Fire Extinguishing Expenses/Fire Brigade Charges","Fire Extinguishing Expenses/Fire Brigade Charges","Designation of Accounts",null,"First Aid Facilities",null,"Seasonal Money Acculumation",null,"Replacement Value (not applicable to Stock)",null,"Domestic Assistance",null,"Cost of Temporary Protection","Medical Expenses Clause","General Worker/Construction Worker/Carpenter (no works at height)",2.2499999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 6 - Fidelity Guarantee",11,null,10,"Leased Property","Leased Property","New Business (if applicable)",null,"Food and Drinks",null,"Traveller's Money",null,"Temporary Removal",null,"Drowning and Suffocation By Gas, Poisonous Fumes or Smoke",null,"Description of Insured Property","Part-Timers / Temporary / Contract Employees Clause","Machine Operator / Mechanic / Electrician (no hotworks)",1.4999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 7 - Personal Accident",12,null,11,"Locks Replacement","Locks Replacement","Non-Invalidation",null,"Indemnity to Directors and Executives",null,"Money Carried by Directors / Employees Clause",null,null,null,"Exposure",null,"Errors and Omissions Clause","Waiver of Subrogation Rights (against Principal)","Maintenance Staff / Technician ",1.4999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 8 - Machinery Breakdown",13,null,12,"Temporary Removal","Temporary Removal","Payment on Account",null,"Independent Contractor's Liability",null,"Unlocked Receptacles",null,null,null,"Hijack, Murder or Assault",null,"First Loss (if applicable)","Common Law Extension","Packer",8.0000000000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 9 - Burglary",14,null,13,"Accidental Leakage or Spillage","Accidental Leakage or Spillage","Plus Provision (20%)",null,"Liability of Students on Attachement/Trainees",null,"Counterfeits",null,null,null,"Infectious Disease Benefit",null,"Loss Notification","Contingent Liability Clause","Plumber/Sanitary Install/Aircon Servicer and install",1.2500000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 10 - Workmen Injury Compensation",15,null,14,"Appraisement","Appraisement","Property Stored Elsewhere or In Transit",null,"Loading and Unloading of Vehicles",null,"Personal Accident (Assault) Insurance Clause",null,null,null,"Insect Snake and Animal Bites",null,"Misdescription",null,"Sales (outdoor)",3.0000000000000001E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Average (85%)","Average (85%)","Public Utilities",null,"Neon or Advertising Signs",null,"Bonus & Extraordinary Payments Clause",null,null,null,"Key-Employee Recruitment Fees",null,"New Location",null,"Security Guard (unarmed)",0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Automatic Reinstatement of Loss","Automatic Reinstatement of Loss","Interdependency Clause",null,"Non-Owned and Hired Vehicles",null,null,null,null,null,"Medical and Surgical Expenses Benefit",null,"Non-Invalidation",null,"Storeman",8.0000000000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Brand and Label","Brand and Label","Leeway Clause ",null,"Plant and Machinery",null,null,null,null,null,"Miscarriage due to Accident",null,"Payment on Account",null,"Welder / Fitter / Blasting Worker",3.5000000000000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Breach of Conditions and/or Warranties","Breach of Conditions and/or Warranties","Material Damage Excess Waiver Clause",null,"Private Work for Directors or Executives",null,null,null,null,null,"Mobility Aids and Home Modification",null,"Replacement Value (not applicable to stock)",null,"WAH Director/Management/Consultant/Supervisor (non-manual)",8.8000000000000003E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Capital Additions","Capital Additions","Suppliers’ / Customers’ Premises Clause",null,"Property Owners Liability",null,null,null,null,null,"Poisonous Food or Drink",null,null,null,"WAH Engineer/Supervisor/Surveyor (semi-manual)",9.3500000000000007E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Contract Price","Contract Price",null,null,"Social Sports and Recreation (within Singapore only)",null,null,null,null,null,"Recuperation Benefit",null,null,null,"WAH General Worker/Construction Worker/Carpenter",3.8249999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"Cost of Demolition, Removal of Debris, Clearing and Erection of Hoarding","Cost of Demolition, Removal of Debris, Clearing and Erection of Hoarding",null,null,"Swimming Pool",null,null,null,null,null,"Reservist Training",null,null,null,"WAH Machine Operator / Mechanic / Electrician",1.7999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"Cost of Recompiling, Rewriting Records and Claims Preparation","Cost of Recompiling, Rewriting Records and Claims Preparation",null,null,"Tenant's Liability",null,null,null,null,null,"Simple Fractures",null,null,null,"WAH Maintenance Staff / Technician ",1.7999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"Cost of Re-Erection","Cost of Re-Erection",null,null,"Worldwide Extension for Employees on Travel",null,null,null,null,null,"Strike, Riot or Civil Commotion",null,null,null,"WAH Scaffolder / Rope Access",3.8249999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"Cost of Temporary Protection","Cost of Temporary Protection",null,null,"Breach of Conition Clause",null,null,null,null,null,"Temporary Total Disablement",null,null,null,"WAH Welder / Fitter",3.85E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"Customers’ Goods  ","Customers’ Goods  ",null,null,"Breach of Warranties Clause",null,null,null,null,null,"Terrorism Cover",null,null,null,"Others"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"Description of Insured Property","Description of Insured Property",null,null,"Contingent Liability Clause",null,null,null,null,null,"Trauma Counselling Benefit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"Divisible Control","Divisible Control",null,null,"Fire and Explosion Clause",null,null,null,null,null,"National Service Reservist Training Clause"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"Electrical Installation","Electrical Installation",null,null,"Fire Brigade Water Damage Clause",null,null,null,null,null,"Repatriation Expenses Clause"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"Errors and Omissions Clause","Errors and Omissions Clause",null,null,"Fire Extinguishers for Demostration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Extended Impact Damage","Extended Impact Damage",null,null,"Personal Injury Clause"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"Falling Trees  ","Falling Trees  ",null,null,"Sprinkler Leakage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"Hazardous Goods","Hazardous Goods",null,null,"Subsidairy / Associated Companies Clause"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"Heating and Power","Heating and Power",null,null,"Waiver of Subrogation Clause"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"Internal Removals","Internal Removals",null,null,"Waiver of subrogation rights against Principals (as applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"Landlord","Landlord"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"Subsidence and Landslip","Subsidence and Landslip"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"Leakage of Liquids","Leakage of Liquids"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Misdescription","Misdescription"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"Mortgage","Mortgage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"New Location","New Location"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"Non-Cancellation","Non-Cancellation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"Non-Invalidation","Non-Invalidation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"Payment on Account  ","Payment on Account  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"Premises","Premises"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"Property Stored Elsewhere","Property Stored Elsewhere"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"Property in Transit","Property in Transit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"Public Authorities","Public Authorities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"Reinstatement Value (not applicable to Stock)","Reinstatement Value (not applicable to Stock)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"Rent (if insured under the Schedule)","Rent (if insured under the Schedule)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"Services","Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,"Sue and Labour","Sue and Labour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Time Adjustment Clause (72 Hours)","Time Adjustment Clause (72 Hours)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,"Vehicle Load","Vehicle Load"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,"Waiver of Subrogation","Waiver of Subrogation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,null,"Theft During or After Occurrence of a Fire"]

{"sheet":"Data","index":19,"n_rows":4,"n_cols":391,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,225,1,226]]}
[]
["POLICY DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WICA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROPERTY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BURGLARY",null,null,null,null,null,"ELECTRONIC EQUIPMENT",null,null,null,null,"GOODS IN TRANSIT",null,null,null,null,null,null,null,"MONEY",null,null,null,null,null,null,"FIDELITY GUARANTEE",null,null,null,null,null,null,"LIABILITY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERSONAL ACCIDENT",null,null,null,null,null,null,null,null,null,null,null,null,null,"MACHINERY BREAKDOWN",null,null,null,null,"TOTAL"]
["Serial no.","Date of Quotation","Quotation No.","Status?","Intermediary","Intermediary Code","Distrubutioin Channel","Insured Name","UEN","SSIC","Commission","Business Address","Nature of Business","Period of Insurance (Start)","Period of Insurance (End)","WICA only?","Declaration of Hazardous Activities","Aggregated Annual Wages Declared by Employer","Aggregated Number of Workers Declared by Employer","Cat 1: Description","Cat 1: Predetermined Rate","Cat 1: Technical Rate","Cat 1: Manual Rate","Cat 1: Which Rate used?","Cat 1: Headcount","Cat 1: Average Monthly Salary","Cat 1: Considered a Workmen?","Cat 1: Death","Cat 1: PI","Cat 1: HL Wages","Cat 1: ML Wages","Cat 1: Medical Expenses","Cat 2: Description","Cat 2: Predetermined Rate","Cat 2: Technical Rate","Cat 2: Manual Rate","Cat 2: Which Rate used?","Cat 2: Headcount","Cat 2: Average Monthly Salary","Cat 2: Considered a Workmen?","Cat 2: Death","Cat 2: PI","Cat 2: HL Wages","Cat 2: ML Wages","Cat 2: Medical Expenses","Cat 3: Description","Cat 3: Predetermined Rate","Cat 3: Technical Rate","Cat 3: Manual Rate","Cat 3: Which Rate used?","Cat 3: Headcount","Cat 3: Average Monthly Salary","Cat 3: Considered a Workmen?","Cat 3: Death","Cat 3: PI","Cat 3: HL Wages","Cat 3: ML Wages","Cat 3: Medical Expenses","Cat 4: Description","Cat 4: Predetermined Rate","Cat 4: Technical Rate","Cat 4: Manual Rate","Cat 4: Which Rate used?","Cat 4: Headcount","Cat 4: Average Monthly Salary","Cat 4: Considered a Workmen?","Cat 4: Death","Cat 4: PI","Cat 4: HL Wages","Cat 4: ML Wages","Cat 4: Medical Expenses","Cat 5: Description","Cat 5: Predetermined Rate","Cat 5: Technical Rate","Cat 5: Manual Rate","Cat 5: Which Rate used?","Cat 5: Headcount","Cat 5: Average Monthly Salary","Cat 5: Considered a Workmen?","Cat 5: Death","Cat 5: PI","Cat 5: HL Wages","Cat 5: ML Wages","Cat 5: Medical Expenses","Cat 6: Description","Cat 6: Predetermined Rate","Cat 6: Technical Rate","Cat 6: Manual Rate","Cat 6: Which Rate used?","Cat 6: Headcount","Cat 6: Average Monthly Salary","Cat 6: Considered a Workmen?","Cat 6: Death","Cat 6: PI","Cat 6: HL Wages","Cat 6: ML Wages","Cat 6: Medical Expenses","Cat 7: Description","Cat 7: Predetermined Rate","Cat 7: Technical Rate","Cat 7: Manual Rate","Cat 7: Which Rate used?","Cat 7: Headcount","Cat 7: Average Monthly Salary","Cat 7: Considered a Workmen?","Cat 7: Death","Cat 7: PI","Cat 7: HL Wages","Cat 7: ML Wages","Cat 7: Medical Expenses","Cat 8: Description","Cat 8: Predetermined Rate","Cat 8: Technical Rate","Cat 8: Manual Rate","Cat 8: Which Rate used?","Cat 8: Headcount","Cat 8: Average Monthly Salary","Cat 8: Considered a Workmen?","Cat 8: Death","Cat 8: PI","Cat 8: HL Wages","Cat 8: ML Wages","Cat 8: Medical Expenses","Cat 9: Description","Cat 9: Predetermined Rate","Cat 9: Technical Rate","Cat 9: Manual Rate","Cat 9: Which Rate used?","Cat 9: Headcount","Cat 9: Average Monthly Salary","Cat 9: Considered a Workmen?","Cat 9: Death","Cat 9: PI","Cat 9: HL Wages","Cat 9: ML Wages","Cat 9: Medical Expenses","Cat 10: Description","Cat 10: Predetermined Rate","Cat 10: Technical Rate","Cat 10: Manual Rate","Cat 10: Which Rate used?","Cat 10: Headcount","Cat 10: Average Monthly Salary","Cat 10: Considered a Workmen?","Cat 10: Death","Cat 10: PI","Cat 10: HL Wages","Cat 10: ML Wages","Cat 10: Medical Expenses","Cat 11: Description","Cat 11: Predetermined Rate","Cat 11: Technical Rate","Cat 11: Manual Rate","Cat 11: Which Rate used?","Cat 11: Headcount","Cat 11: Average Monthly Salary","Cat 11: Considered a Workmen?","Cat 11: Death","Cat 11: PI","Cat 11: HL Wages","Cat 11: ML Wages","Cat 11: Medical Expenses","Cat 12: Description","Cat 12: Predetermined Rate","Cat 12: Technical Rate","Cat 12: Manual Rate","Cat 12: Which Rate used?","Cat 12: Headcount","Cat 12: Average Monthly Salary","Cat 12: Considered a Workmen?","Cat 12: Death","Cat 12: PI","Cat 12: HL Wages","Cat 12: ML Wages","Cat 12: Medical Expenses","Cat 13: Description","Cat 13: Predetermined Rate","Cat 13: Technical Rate","Cat 13: Manual Rate","Cat 13: Which Rate used?","Cat 13: Headcount","Cat 13: Average Monthly Salary","Cat 13: Considered a Workmen?","Cat 13: Death","Cat 13: PI","Cat 13: HL Wages","Cat 13: ML Wages","Cat 13: Medical Expenses","Cat 14: Description","Cat 14: Predetermined Rate","Cat 14: Technical Rate","Cat 14: Manual Rate","Cat 14: Which Rate used?","Cat 14: Headcount","Cat 14: Average Monthly Salary","Cat 14: Considered a Workmen?","Cat 14: Death","Cat 14: PI","Cat 14: HL Wages","Cat 14: ML Wages","Cat 14: Medical Expenses","Cat 15: Description","Cat 15: Predetermined Rate","Cat 15: Technical Rate","Cat 15: Manual Rate","Cat 15: Which Rate used?","Cat 15: Headcount","Cat 15: Average Monthly Salary","Cat 15: Considered a Workmen?","Cat 15: Death","Cat 15: PI","Cat 15: HL Wages","Cat 15: ML Wages","Cat 15: Medical Expenses","Current Year: Inc","Current Year: Clm Count","Current Year: Headcount","Previous 1 Year: Inc","Previous 1 Year: Clm Count","Previous 1 Year: Headcount","Previous 2 Year: Inc","Previous 2 Year: Clm Count","Previous 2 Year: Headcount","Lives","GWP","Type of Cover 1","Age of Building 1","Location of Risk 1","Postcode 1","Occupied as 1","Other details 1","Other details 1","Total Sum Insured 1","Type of Cover 2","Age of Building 2","Location of Risk 2","Postcode 2","Occupied as 2","Other details 2","Other details 2","Total Sum Insured 2","Type of Cover 3","Age of Building 3","Location of Risk 3","Postcode 3","Occupied as 3","Other details 3","Other details 3","Total Sum Insured 3","Type of Cover 4","Age of Building 4","Location of Risk 4","Postcode 4","Occupied as 4","Other details 4","Other details 4","Total Sum Insured 4","Type of Cover 5","Age of Building 5","Location of Risk 5","Postcode 5","Occupied as 5","Other details 5","Other details 5","Total Sum Insured 5","Type of Cover 6","Age of Building 6","Location of Risk 6","Postcode 6","Occupied as 6","Other details 6","Other details 6","Total Sum Insured 6","Type of Cover 7","Age of Building 7","Location of Risk 7","Postcode 7","Occupied as 7","Other details 7","Other details 7","Total Sum Insured 7","Type of Cover 8","Age of Building 8","Location of Risk 8","Postcode 8","Occupied as 8","Other details 8","Other details 8","Total Sum Insured 8","Type of Cover 9","Age of Building 9","Location of Risk 9","Postcode 9","Occupied as 9","Other details 9","Other details 9","Total Sum Insured 9","Type of Cover 10","Age of Building 10","Location of Risk 10","Postcode 10","Occupied as 10","Other details 10","Other details 10","Total Sum Insured 10","Deductible - Each and Every Loss","Protection Systems Fully Sprinklered","Protection Systems Smoke Detectors","Protection Systems Hosereel","Protection Systems Fire Extinguishers","Protection Systems Fire Alarm","Protection Systems Burglary Alarm","Protection Systems Electrical Protection","Protection Systems 24-hour Security Guard Protection","BUSINESS INTERRUPTION","Indemnity Period","Time Excess","Total Sum Insured (Please specify below if others):","FIXED GLASS","Limit of Cover","Deductible","Total Property GWP","Sum Insured","Deductible","First Lost/Full Value","Rate - Full Value","Rate - First Lost","GWP","Sum Insured","Deductible","Rate - First 1 million","Rate - Subsequent","GWP","Conveyance Limit","Annual Sending ","Type of cargo","Type of cargo","Deductible","Rate - First 1 million","Rate - Subsequent","GWP","Money On Premises","Money In Transit","Estimated Annual Carrying","Deductible","Rate - Money on Premise","Rate - Money in Transit","GWP","Limits of Guarantee in aggregate","No. of Employees to cover","Category of staff","Deductible","Rate - Per Employee","Rate - Per Aggregate","GWP","PUBLIC LIABILITY","Principal/Landlord/Tenant","Limit of Liability (Occurrence)","Annual Turnover","Deductible","Manual Work Away from Premises","Proportion of the total value of work","PRODUCT LIABILITY","Limit of Liability (Occurrence)","Annual Turnover","Deductible","Any product quality assurance process in place?","Do you manufacture to third party design specifications with possibility of recourse?","Do you use third party manufactured products as components? ","If above is yes, from which countries?","Total Liability GWP","Declaration of Hazardous Activities","Non-Manual Employees","Accidental Death and Permanent Disability (up to $1,000,000 SI per pax)","Medical Expenses \n(up to $1,500 SI per pax)","No. of Employees to be insured ","Accidental Death and Permanent Disability Rate","Medical Expenses Rate","Manual Employees","Accidental Death and Permanent Disability (up to $1,000,000 SI per pax)","Medical Expenses \n(up to $1,500 SI per pax)","No. of Employees to be insured ","Accidental Death and Permanent Disability Rate","Medical Expenses Rate","GWP","Sum Insured","Deductible","Rate: First 100,000","Rate: Subsequent","GWP","GWP w/o GST"]
[null,{"$f":"'Quotation Slip'!E4","v":"2025-08-04"},"44798-2",null,{"$f":"'Proposal Form'!H6","v":0},{"$f":"'Proposal Form'!H7","v":0},{"$f":"'Proposal Form'!H8","v":0},{"$f":"'Proposal Form'!H12","v":0},{"$f":"'Proposal Form'!H13","v":0},{"$f":"'Proposal Form'!H14","v":0},0.25,{"$f":"'Proposal Form'!H15","v":0},{"$f":"'Proposal Form'!H16","v":0},{"$f":"'Proposal Form'!H17","v":"00:00:00"},{"$f":"'Proposal Form'!J18","v":"00:00:00"},"No",{"$f":"'Proposal Form'!J117","v":0},{"$f":"SUM('Proposal Form'!J120:J134)","v":0},{"$f":"SUM('Proposal Form'!I120:I134)","v":0},{"$f":"IF('Proposal Form'!B120=\"Others\",_xlfn.CONCAT('Proposal Form'!B120,\" - \",'Proposal Form'!F120),'Proposal Form'!B120)","v":0},{"$f":"'Pricing '!H38","v":0},{"$f":"'Pricing '!I38","v":14},{"$f":"'Pricing '!J38","v":0},{"$f":"'Pricing '!G38","v":"Market Rate"},{"$f":"'Pricing '!D38","v":0},{"$f":"'Pricing '!F38","v":0},{"$f":"'Pricing '!E38","v":0},"As per WICA","As per WICA",{"$f":"'Quotation Slip'!$J$315","v":60},{"$f":"'Quotation Slip'!$J$316","v":14},{"$f":"'Quotation Slip'!$J$317","v":250000},{"$f":"IF('Proposal Form'!B121=\"Others\",_xlfn.CONCAT('Proposal Form'!B121,\" - \",'Proposal Form'!F121),'Proposal Form'!B121)","v":0},{"$f":"'Pricing '!H39","v":0},{"$f":"'Pricing '!I39","v":14},{"$f":"'Pricing '!J39","v":0},{"$f":"'Pricing '!G39","v":"Market Rate"},{"$f":"'Pricing '!D39","v":0},{"$f":"'Pricing '!F39","v":0},{"$f":"'Pricing '!E39","v":0},{"$f":"AB4","v":"As per WICA"},{"$f":"AC4","v":"As per WICA"},{"$f":"AD4","v":60},{"$f":"AE4","v":14},{"$f":"AF4","v":250000},{"$f":"IF('Proposal Form'!B122=\"Others\",_xlfn.CONCAT('Proposal Form'!B122,\" - \",'Proposal Form'!F122),'Proposal Form'!B122)","v":0},{"$f":"'Pricing '!H40","v":0},{"$f":"'Pricing '!I40","v":14},{"$f":"'Pricing '!J40","v":0},{"$f":"'Pricing '!G40","v":"Market Rate"},{"$f":"'Pricing '!D40","v":0},{"$f":"'Pricing '!F40","v":0},{"$f":"'Pricing '!E40","v":0},{"$f":"AO4","v":"As per WICA"},{"$f":"AP4","v":"As per WICA"},{"$f":"AQ4","v":60},{"$f":"AR4","v":14},{"$f":"AS4","v":250000},{"$f":"IF('Proposal Form'!B123=\"Others\",_xlfn.CONCAT('Proposal Form'!B123,\" - \",'Proposal Form'!F123),'Proposal Form'!B123)","v":0},{"$f":"'Pricing '!H41","v":0},{"$f":"'Pricing '!I41","v":14},{"$f":"'Pricing '!J41","v":0},{"$f":"'Pricing '!G41","v":"Market Rate"},{"$f":"'Pricing '!D41","v":0},{"$f":"'Pricing '!F41","v":0},{"$f":"'Pricing '!E41","v":0},{"$f":"BB4","v":"As per WICA"},{"$f":"BC4","v":"As per WICA"},{"$f":"BD4","v":60},{"$f":"BE4","v":14},{"$f":"BF4","v":250000},{"$f":"IF('Proposal Form'!B124=\"Others\",_xlfn.CONCAT('Proposal Form'!B124,\" - \",'Proposal Form'!F124),'Proposal Form'!B124)","v":0},{"$f":"'Pricing '!H42","v":0},{"$f":"'Pricing '!I42","v":14},{"$f":"'Pricing '!J42","v":0},{"$f":"'Pricing '!G42","v":"Market Rate"},{"$f":"'Pricing '!D42","v":0},{"$f":"'Pricing '!F42","v":0},{"$f":"'Pricing '!E42","v":0},{"$f":"BO4","v":"As per WICA"},{"$f":"BP4","v":"As per WICA"},{"$f":"BQ4","v":60},{"$f":"BR4","v":14},{"$f":"BS4","v":250000},{"$f":"IF('Proposal Form'!B125=\"Others\",_xlfn.CONCAT('Proposal Form'!B125,\" - \",'Proposal Form'!F125),'Proposal Form'!B125)","v":0},{"$f":"'Pricing '!H43","v":0},{"$f":"'Pricing '!I43","v":14},{"$f":"'Pricing '!J43","v":0},{"$f":"'Pricing '!G43","v":"Market Rate"},{"$f":"'Pricing '!D43","v":0},{"$f":"'Pricing '!F43","v":0},{"$f":"'Pricing '!E43","v":0},{"$f":"CB4","v":"As per WICA"},{"$f":"CC4","v":"As per WICA"},{"$f":"CD4","v":60},{"$f":"CE4","v":14},{"$f":"CF4","v":250000},{"$f":"IF('Proposal Form'!B126=\"Others\",_xlfn.CONCAT('Proposal Form'!B126,\" - \",'Proposal Form'!F126),'Proposal Form'!B126)","v":0},{"$f":"'Pricing '!H44","v":0},{"$f":"'Pricing '!I44","v":14},{"$f":"'Pricing '!J44","v":0},{"$f":"'Pricing '!G44","v":"Market Rate"},{"$f":"'Pricing '!D44","v":0},{"$f":"'Pricing '!F44","v":0},{"$f":"'Pricing '!E44","v":0},{"$f":"CO4","v":"As per WICA"},{"$f":"CP4","v":"As per WICA"},{"$f":"CQ4","v":60},{"$f":"CR4","v":14},{"$f":"CS4","v":250000},{"$f":"IF('Proposal Form'!B127=\"Others\",_xlfn.CONCAT('Proposal Form'!B127,\" - \",'Proposal Form'!F127),'Proposal Form'!B127)","v":0},{"$f":"'Pricing '!H45","v":0},{"$f":"'Pricing '!I45","v":14},{"$f":"'Pricing '!J45","v":0},{"$f":"'Pricing '!G45","v":"Market Rate"},{"$f":"'Pricing '!D45","v":0},{"$f":"'Pricing '!F45","v":0},{"$f":"'Pricing '!E45","v":0},{"$f":"DB4","v":"As per WICA"},{"$f":"DC4","v":"As per WICA"},{"$f":"DD4","v":60},{"$f":"DE4","v":14},{"$f":"DF4","v":250000},{"$f":"IF('Proposal Form'!B128=\"Others\",_xlfn.CONCAT('Proposal Form'!B128,\" - \",'Proposal Form'!F128),'Proposal Form'!B128)","v":0},{"$f":"'Pricing '!H46","v":0},{"$f":"'Pricing '!I46","v":14},{"$f":"'Pricing '!J46","v":0},{"$f":"'Pricing '!G46","v":"Market Rate"},{"$f":"'Pricing '!D46","v":0},{"$f":"'Pricing '!F46","v":0},{"$f":"'Pricing '!E46","v":0},{"$f":"DO4","v":"As per WICA"},{"$f":"DP4","v":"As per WICA"},{"$f":"DQ4","v":60},{"$f":"DR4","v":14},{"$f":"DS4","v":250000},{"$f":"IF('Proposal Form'!B129=\"Others\",_xlfn.CONCAT('Proposal Form'!B129,\" - \",'Proposal Form'!F129),'Proposal Form'!B129)","v":0},{"$f":"'Pricing '!H47","v":0},{"$f":"'Pricing '!I47","v":14},{"$f":"'Pricing '!J47","v":0},{"$f":"'Pricing '!G47","v":"Market Rate"},{"$f":"'Pricing '!D47","v":0},{"$f":"'Pricing '!F47","v":0},{"$f":"'Pricing '!E47","v":0},{"$f":"EB4","v":"As per WICA"},{"$f":"EC4","v":"As per WICA"},{"$f":"ED4","v":60},{"$f":"EE4","v":14},{"$f":"EF4","v":250000},{"$f":"IF('Proposal Form'!B130=\"Others\",_xlfn.CONCAT('Proposal Form'!B130,\" - \",'Proposal Form'!F130),'Proposal Form'!B130)","v":0},{"$f":"'Pricing '!H48","v":0},{"$f":"'Pricing '!I48","v":14},{"$f":"'Pricing '!J48","v":0},{"$f":"'Pricing '!G48","v":"Market Rate"},{"$f":"'Pricing '!D48","v":0},{"$f":"'Pricing '!F48","v":0},{"$f":"'Pricing '!E48","v":0},{"$f":"EO4","v":"As per WICA"},{"$f":"EP4","v":"As per WICA"},{"$f":"EQ4","v":60},{"$f":"ER4","v":14},{"$f":"ES4","v":250000},{"$f":"IF('Proposal Form'!B131=\"Others\",_xlfn.CONCAT('Proposal Form'!B131,\" - \",'Proposal Form'!F131),'Proposal Form'!B131)","v":0},{"$f":"'Pricing '!H49","v":0},{"$f":"'Pricing '!I49","v":14},{"$f":"'Pricing '!J49","v":0},{"$f":"'Pricing '!G49","v":"Market Rate"},{"$f":"'Pricing '!D49","v":0},{"$f":"'Pricing '!F49","v":0},{"$f":"'Pricing '!E49","v":0},{"$f":"FB4","v":"As per WICA"},{"$f":"FC4","v":"As per WICA"},{"$f":"FD4","v":60},{"$f":"FE4","v":14},{"$f":"FF4","v":250000},{"$f":"IF('Proposal Form'!B132=\"Others\",_xlfn.CONCAT('Proposal Form'!B132,\" - \",'Proposal Form'!F132),'Proposal Form'!B132)","v":0},{"$f":"'Pricing '!H50","v":0},{"$f":"'Pricing '!I50","v":14},{"$f":"'Pricing '!J50","v":0},{"$f":"'Pricing '!G50","v":"Market Rate"},{"$f":"'Pricing '!D50","v":0},{"$f":"'Pricing '!F50","v":0},{"$f":"'Pricing '!E50","v":0},{"$f":"FO4","v":"As per WICA"},{"$f":"FP4","v":"As per WICA"},{"$f":"FQ4","v":60},{"$f":"FR4","v":14},{"$f":"FS4","v":250000},{"$f":"IF('Proposal Form'!B133=\"Others\",_xlfn.CONCAT('Proposal Form'!B133,\" - \",'Proposal Form'!F133),'Proposal Form'!B133)","v":0},{"$f":"'Pricing '!H51","v":0},{"$f":"'Pricing '!I51","v":14},{"$f":"'Pricing '!J51","v":0},{"$f":"'Pricing '!G51","v":"Market Rate"},{"$f":"'Pricing '!D51","v":0},{"$f":"'Pricing '!F51","v":0},{"$f":"'Pricing '!E51","v":0},{"$f":"GB4","v":"As per WICA"},{"$f":"GC4","v":"As per WICA"},{"$f":"GD4","v":60},{"$f":"GE4","v":14},{"$f":"GF4","v":250000},{"$f":"IF('Proposal Form'!B134=\"Others\",_xlfn.CONCAT('Proposal Form'!B134,\" - \",'Proposal Form'!F134),'Proposal Form'!B134)","v":0},{"$f":"'Pricing '!H52","v":0},{"$f":"'Pricing '!I52","v":14},{"$f":"'Pricing '!J52","v":0},{"$f":"'Pricing '!G52","v":"Market Rate"},{"$f":"'Pricing '!D52","v":0},{"$f":"'Pricing '!F52","v":0},{"$f":"'Pricing '!E52","v":0},{"$f":"GO4","v":"As per WICA"},{"$f":"GP4","v":"As per WICA"},{"$f":"GQ4","v":60},{"$f":"GR4","v":14},{"$f":"GS4","v":250000},"N/a","N/a","N/a","N/a","N/a","N/a","N/a","N/a","N/a",{"$f":"SUM('Quotation Slip'!$F$298:$F$312)","v":0},{"$f":"'Pricing '!M35","v":0},{"$f":"'Proposal Form'!J22","v":0},{"$f":"'Proposal Form'!J23","v":0},{"$f":"'Proposal Form'!J24","v":0},{"$f":"'Proposal Form'!J25","v":0},{"$f":"'Proposal Form'!J26","v":0},{"$f":"'Proposal Form'!J27","v":0},{"$f":"'Proposal Form'!J28","v":0},{"$f":"'Proposal Form'!J29","v":0},{"$f":"'Proposal Form'!K22","v":0},{"$f":"'Proposal Form'!K23","v":0},{"$f":"'Proposal Form'!K24","v":0},{"$f":"'Proposal Form'!K25","v":0},{"$f":"'Proposal Form'!K26","v":0},{"$f":"'Proposal Form'!K27","v":0},{"$f":"'Proposal Form'!K28","v":0},{"$f":"'Proposal Form'!K29","v":0},{"$f":"'Proposal Form'!L22","v":0},{"$f":"'Proposal Form'!L23","v":0},{"$f":"'Proposal Form'!L24","v":0},{"$f":"'Proposal Form'!L25","v":0},{"$f":"'Proposal Form'!L26","v":0},{"$f":"'Proposal Form'!L27","v":0},{"$f":"'Proposal Form'!L28","v":0},{"$f":"'Proposal Form'!L29","v":0},{"$f":"'Proposal Form'!M22","v":0},{"$f":"'Proposal Form'!M23","v":0},{"$f":"'Proposal Form'!M24","v":0},{"$f":"'Proposal Form'!M25","v":0},{"$f":"'Proposal Form'!M26","v":0},{"$f":"'Proposal Form'!M27","v":0},{"$f":"'Proposal Form'!M28","v":0},{"$f":"'Proposal Form'!M29","v":0},{"$f":"'Proposal Form'!N22","v":0},{"$f":"'Proposal Form'!N23","v":0},{"$f":"'Proposal Form'!N24","v":0},{"$f":"'Proposal Form'!N25","v":0},{"$f":"'Proposal Form'!N26","v":0},{"$f":"'Proposal Form'!N27","v":0},{"$f":"'Proposal Form'!N28","v":0},{"$f":"'Proposal Form'!N29","v":0},{"$f":"'Proposal Form'!O22","v":0},{"$f":"'Proposal Form'!O23","v":0},{"$f":"'Proposal Form'!O24","v":0},{"$f":"'Proposal Form'!O25","v":0},{"$f":"'Proposal Form'!O26","v":0},{"$f":"'Proposal Form'!O27","v":0},{"$f":"'Proposal Form'!O28","v":0},{"$f":"'Proposal Form'!O29","v":0},{"$f":"'Proposal Form'!P22","v":0},{"$f":"'Proposal Form'!P23","v":0},{"$f":"'Proposal Form'!P24","v":0},{"$f":"'Proposal Form'!P25","v":0},{"$f":"'Proposal Form'!P26","v":0},{"$f":"'Proposal Form'!P27","v":0},{"$f":"'Proposal Form'!P28","v":0},{"$f":"'Proposal Form'!P29","v":0},{"$f":"'Proposal Form'!Q22","v":0},{"$f":"'Proposal Form'!Q23","v":0},{"$f":"'Proposal Form'!Q24","v":0},{"$f":"'Proposal Form'!Q25","v":0},{"$f":"'Proposal Form'!Q26","v":0},{"$f":"'Proposal Form'!Q27","v":0},{"$f":"'Proposal Form'!Q28","v":0},{"$f":"'Proposal Form'!Q29","v":0},{"$f":"'Proposal Form'!R22","v":0},{"$f":"'Proposal Form'!R23","v":0},{"$f":"'Proposal Form'!R24","v":0},{"$f":"'Proposal Form'!R25","v":0},{"$f":"'Proposal Form'!R26","v":0},{"$f":"'Proposal Form'!R27","v":0},{"$f":"'Proposal Form'!R28","v":0},{"$f":"'Proposal Form'!R29","v":0},{"$f":"'Proposal Form'!S22","v":0},{"$f":"'Proposal Form'!S23","v":0},{"$f":"'Proposal Form'!S24","v":0},{"$f":"'Proposal Form'!S25","v":0},{"$f":"'Proposal Form'!S26","v":0},{"$f":"'Proposal Form'!S27","v":0},{"$f":"'Proposal Form'!S28","v":0},{"$f":"'Proposal Form'!S29","v":0},{"$f":"'Proposal Form'!J37","v":1000},{"$f":"'Proposal Form'!J41","v":"Yes"},{"$f":"'Proposal Form'!J42","v":"Yes"},{"$f":"'Proposal Form'!J43","v":"Yes"},{"$f":"'Proposal Form'!J44","v":"Yes"},{"$f":"'Proposal Form'!J45","v":"Yes"},{"$f":"'Proposal Form'!J46","v":"Yes"},{"$f":"'Proposal Form'!J47","v":"Yes"},{"$f":"'Proposal Form'!J48","v":"Yes"},null,{"$f":"'Proposal Form'!J52","v":0},{"$f":"'Proposal Form'!J53","v":0},{"$f":"'Proposal Form'!J54","v":0},null,{"$f":"'Proposal Form'!J66","v":0},{"$f":"'Proposal Form'!J67","v":0},{"$f":"'Pricing '!M2","v":0},{"$f":"'Proposal Form'!J70","v":0},{"$f":"'Proposal Form'!J71","v":0},{"$f":"'Proposal Form'!J72","v":0},{"$f":"'Pricing '!G21","v":2E-3},{"$f":"'Pricing '!G22","v":3.5000000000000001E-3},{"$f":"'Pricing '!M20","v":0},{"$f":"'Proposal Form'!J75","v":0},{"$f":"'Proposal Form'!J76","v":0},{"$f":"'Pricing '!G24","v":6.9999999999999999E-4},{"$f":"'Pricing '!G25","v":5.0000000000000001E-4},{"$f":"'Pricing '!M23","v":0},{"$f":"'Proposal Form'!J79","v":0},{"$f":"'Proposal Form'!J80","v":0},{"$f":"'Proposal Form'!J81","v":0},{"$f":"'Proposal Form'!J82","v":0},{"$f":"'Proposal Form'!J83","v":0},{"$f":"'Pricing '!G27","v":3.8E-3},{"$f":"'Pricing '!G28","v":2.7000000000000001E-3},{"$f":"'Pricing '!M26","v":0},{"$f":"'Proposal Form'!J86","v":0},{"$f":"'Proposal Form'!J87","v":0},{"$f":"'Proposal Form'!J88","v":0},{"$f":"'Proposal Form'!J89","v":0},{"$f":"'Pricing '!G30","v":1.5E-3},{"$f":"'Pricing '!G31","v":2.5000000000000001E-3},{"$f":"'Pricing '!M29","v":0},{"$f":"'Proposal Form'!J92","v":0},{"$f":"'Proposal Form'!J93","v":0},{"$f":"'Proposal Form'!J94","v":0},{"$f":"'Proposal Form'!J95","v":0},{"$f":"'Pricing '!G33","v":3},{"$f":"'Pricing '!G34","v":5.0000000000000001E-3},{"$f":"'Pricing '!M32","v":0},null,{"$f":"'Proposal Form'!J99","v":0},{"$f":"'Proposal Form'!J100","v":0},{"$f":"'Proposal Form'!J101","v":0},{"$f":"'Proposal Form'!J102","v":0},{"$f":"'Proposal Form'!J103","v":0},{"$f":"'Proposal Form'!J104","v":0},null,{"$f":"'Proposal Form'!J107","v":0},{"$f":"'Proposal Form'!J108","v":0},{"$f":"'Proposal Form'!J109","v":0},{"$f":"'Proposal Form'!J110","v":0},{"$f":"'Proposal Form'!J111","v":0},{"$f":"'Proposal Form'!J112","v":0},{"$f":"'Proposal Form'!J113","v":0},{"$f":"'Pricing '!M18","v":0},{"$f":"'Proposal Form'!J137","v":0},null,{"$f":"'Proposal Form'!J140","v":0},{"$f":"'Proposal Form'!J141","v":0},{"$f":"'Proposal Form'!J142","v":0},{"$f":"'Pricing '!C55","v":3.258823529411765E-4},{"$f":"'Pricing '!G55","v":1.0494117647058826E-2},null,{"$f":"'Proposal Form'!J145","v":0},{"$f":"'Proposal Form'!J146","v":0},{"$f":"'Proposal Form'!J147","v":0},{"$f":"'Pricing '!C56","v":6.0352941176470588E-4},{"$f":"'Pricing '!G56","v":1.9435294117647058E-2},{"$f":"'Pricing '!M53","v":0},{"$f":"'Proposal Form'!J150","v":0},{"$f":"'Proposal Form'!J151","v":0},{"$f":"'Pricing '!G58","v":5.174999999999999E-3},{"$f":"'Pricing '!G59","v":2.5300000000000001E-3},{"$f":"'Pricing '!M57","v":0},{"$f":"'Pricing '!M61","v":0}]

{"sheet":"Policy Schedule_v2","index":20,"n_rows":354,"n_cols":12,"rows_kept":354,"cut":false,"hidden":true,"merged":[[214,0,214,10],[0,0,0,10],[1,0,1,10],[3,4,3,6],[13,4,13,5],[14,0,14,10],[16,0,16,10],[19,1,19,9],[176,0,176,10],[178,0,178,10],[204,0,204,10],[206,0,206,10],[292,0,292,10],[216,0,216,10],[223,0,223,10],[225,0,225,10],[232,0,232,10],[234,0,234,10],[245,0,245,10],[247,0,247,10],[273,0,273,10],[275,0,275,10],[283,0,283,10],[285,0,285,10],[294,0,294,10],[296,2,296,4],[296,6,296,7],[296,8,296,9],[297,6,297,7],[297,8,297,9],[298,6,298,7],[298,8,298,9],[299,6,299,7],[299,8,299,9],[300,6,300,7],[300,8,300,9],[301,6,301,7],[301,8,301,9],[302,6,302,7],[302,8,302,9],[303,6,303,7],[303,8,303,9],[304,6,304,7],[304,8,304,9],[305,6,305,7],[305,8,305,9],[306,6,306,7],[306,8,306,9],[307,6,307,7],[307,8,307,9],[308,6,308,7],[308,8,308,9],[309,6,309,7],[309,8,309,9],[346,1,346,3],[346,7,346,9],[310,6,310,7],[310,8,310,9],[311,6,311,7],[311,8,311,9],[324,1,324,9],[326,8,326,9],[327,0,327,10],[328,1,328,4],[331,1,331,4],[334,1,334,4],[340,1,340,9],[347,1,347,3],[347,7,347,9],[348,7,348,9],[349,7,349,9],[353,1,353,9]]}
["Policy Schedule"]
["Allianz Commercial EDGE"]
[]
[null,"Policy Number",null,":"]
[null,"Quotation No.",null,":"]
[null,"Intermediary Code",null,":",{"$f":"'Proposal Form'!H7","v":0}]
[null,"Intermediary",null,":",{"$f":"'Proposal Form'!H6","v":0}]
[null,"Policyholder/Insured",null,":",{"$f":"'Proposal Form'!H12","v":0}]
[null,"ISIC",null,":",{"$f":"'Proposal Form'!H14","v":0}]
[null,"UEN",null,":",{"$f":"'Proposal Form'!H13","v":0}]
[null,"Correspondence Address",null,":",{"$f":"'Proposal Form'!H15","v":0}]
[null,"Nature of Business",null,":",{"$f":"'Proposal Form'!H16","v":0}]
[null,"Period of Insurance",null,":",{"$f":"'Proposal Form'!H17","v":"00:00:00"},"to",{"$f":"'Proposal Form'!J17","v":"00:00:00"},null,"(both dates inclusive)"]
[null,"Total Premium with GST",null,":",{"$f":"SUM(J16,J178,J206,J216,J225,J234,J247,J275,J285,J294)*1.08","v":0}]
[]
[null,"Section 1 - Property",null,null,null,null,null,null,"Premium",{"$f":"SUM(J32,J44,J56,J68,J80,J92,J104,J116,J128,J140,J160,J172)","v":0}]
[]
[]
[null,"Property"]
[null,"On the following properties belonging to the Insured or held by the Insured or on commission or for which the Insured hold itself responsible"]
[]
[1,{"$f":"\"Location of Risk\"&\" \"&A22","v":"Location of Risk 1"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A22,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B23,'Proposal Form'!$A$26:$S$26,9+A22,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B24,'Proposal Form'!$A$22:$S$26,9+A22,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C27,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J27","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C28,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J28","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C29,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J29","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C30,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J30","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C31,'Proposal Form'!$A$30:$S$35,9+A22,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J31","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I27:I31)","v":0},{"$f":"SUM(J27:J31)","v":0}]
[]
[2,{"$f":"\"Location of Risk\"&\" \"&A34","v":"Location of Risk 2"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A34,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B35,'Proposal Form'!$A$26:$S$26,9+A34,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B36,'Proposal Form'!$A$22:$S$26,9+A34,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C39,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J39","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C40,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J40","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C41,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J41","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C42,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J42","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C43,'Proposal Form'!$A$30:$S$35,9+A34,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J43","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I39:I43)","v":0},{"$f":"SUM(J39:J43)","v":0}]
[]
[3,{"$f":"\"Location of Risk\"&\" \"&A46","v":"Location of Risk 3"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A46,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B47,'Proposal Form'!$A$26:$S$26,9+A46,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B48,'Proposal Form'!$A$22:$S$26,9+A46,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C51,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J51","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C52,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J52","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C53,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J53","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C54,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J54","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C55,'Proposal Form'!$A$30:$S$35,9+A46,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J55","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I51:I55)","v":0},{"$f":"SUM(J51:J55)","v":0}]
[]
[4,{"$f":"\"Location of Risk\"&\" \"&A58","v":"Location of Risk 4"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A58,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B59,'Proposal Form'!$A$26:$S$26,9+A58,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B60,'Proposal Form'!$A$22:$S$26,9+A58,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C63,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J63","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C64,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J64","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C65,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J65","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C66,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J66","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C67,'Proposal Form'!$A$30:$S$35,9+A58,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J67","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I63:I67)","v":0},{"$f":"SUM(J63:J67)","v":0}]
[]
[5,{"$f":"\"Location of Risk\"&\" \"&A70","v":"Location of Risk 5"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A70,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B71,'Proposal Form'!$A$26:$S$26,9+A70,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B72,'Proposal Form'!$A$22:$S$26,9+A70,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C75,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J75","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C76,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J76","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C77,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J77","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C78,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J78","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C79,'Proposal Form'!$A$30:$S$35,9+A70,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J79","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I79)","v":0},{"$f":"SUM(J75:J79)","v":0}]
[]
[6,{"$f":"\"Location of Risk\"&\" \"&A82","v":"Location of Risk 6"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A82,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B83,'Proposal Form'!$A$26:$S$26,9+A82,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B84,'Proposal Form'!$A$22:$S$26,9+A82,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C87,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J87","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C88,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J88","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C89,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J89","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C90,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J90","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C91,'Proposal Form'!$A$30:$S$35,9+A82,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J91","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I91)","v":0},{"$f":"SUM(J87:J91)","v":0}]
[]
[7,{"$f":"\"Location of Risk\"&\" \"&A94","v":"Location of Risk 7"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A94,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B95,'Proposal Form'!$A$26:$S$26,9+A94,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B96,'Proposal Form'!$A$22:$S$26,9+A94,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C99,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J99","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C100,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J100","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C101,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J101","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C102,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J102","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C103,'Proposal Form'!$A$30:$S$35,9+A94,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J103","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I99:I103)","v":0},{"$f":"SUM(J99:J103)","v":0}]
[]
[8,{"$f":"\"Location of Risk\"&\" \"&A106","v":"Location of Risk 8"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A106,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B107,'Proposal Form'!$A$26:$S$26,9+A106,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B108,'Proposal Form'!$A$22:$S$26,9+A106,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C111,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J111","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C112,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J112","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C113,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J113","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C114,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J114","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C115,'Proposal Form'!$A$30:$S$35,9+A106,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J115","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I111:I115)","v":0},{"$f":"SUM(J111:J115)","v":0}]
[]
[9,{"$f":"\"Location of Risk\"&\" \"&A118","v":"Location of Risk 9"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A118,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B119,'Proposal Form'!$A$26:$S$26,9+A118,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B120,'Proposal Form'!$A$22:$S$26,9+A118,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C123,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J123","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C124,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J124","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C125,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J125","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C126,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J126","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C127,'Proposal Form'!$A$30:$S$35,9+A118,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J127","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I123:I127)","v":0},{"$f":"SUM(J123:J127)","v":0}]
[]
[10,{"$f":"\"Location of Risk\"&\" \"&A130","v":"Location of Risk 10"},null,":",{"$f":"VLOOKUP(\"Location of Risk\",'Proposal Form'!$A$24:$S$24,9+A130,FALSE)","v":0}]
[null,"Occupied as",null,":",{"$f":"VLOOKUP(B131,'Proposal Form'!$A$26:$S$26,9+A130,FALSE)","v":0}]
[null,"Type of Cover",null,":",{"$f":"VLOOKUP(B132,'Proposal Form'!$A$22:$S$26,9+A130,FALSE)","v":0}]
[]
[null,null,"Interest Insured at Location of Risk",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Contents",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C135,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J135","v":0}]
[null,2,"Stocks",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C136,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J136","v":0}]
[null,3,"Plant & Machinery",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C137,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J137","v":0}]
[null,4,"Furniture, Fixtures and Fittings",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C138,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J138","v":0}]
[null,5,"Building",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C139,'Proposal Form'!$A$30:$S$35,9+A130,FALSE),\"\")","v":0},{"$f":"'Quotation Slip'!J139","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I135:I139)","v":0},{"$f":"SUM(J135:J139)","v":0}]
[]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(E143,'Proposal Form'!$A$37:$J$38,10,FALSE),\"\")","v":1000}]
[null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(E144,'Proposal Form'!$A$37:$J$38,10,FALSE),\"\")","v":""}]
[]
[null,"Subjectivity",null,":"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Business Interruption "]
[null,null,"Business Interruption",null,null,null,null,null,"Sum Insured","Premium"]
[null,1,"Gross Profit",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C151,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"'Quotation Slip'!J151","v":0}]
[null,2,"Gross Revenue",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C152,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"'Quotation Slip'!J152","v":0}]
[null,3,"Gross Rental",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C153,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"'Quotation Slip'!J153","v":0}]
[null,4,"Additional Increased Cost of Working",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C154,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"'Quotation Slip'!J154","v":0}]
[null,5,"Auditors Fees",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C155,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"'Quotation Slip'!J155","v":0}]
[null,6,"Standing Charges",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C156,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"'Quotation Slip'!J156","v":0}]
[null,7,"Wages",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C157,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"'Quotation Slip'!J157","v":0}]
[null,8,"Others",null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C158,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"'Quotation Slip'!J158","v":0}]
[null,9,null,null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C159,'Proposal Form'!$A$55:$J$63,10,FALSE),0)","v":0},{"$f":"'Quotation Slip'!J159","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I151:I159)","v":0},{"$f":"SUM(J151:J159)","v":0}]
[]
[null,"Indemnity Period",null,":",{"$f":"'Proposal Form'!J52","v":0},"months"]
[]
[null,"Time Excess",null,":",{"$f":"'Proposal Form'!J53","v":0},"hours"]
[]
[null,"Subjectivity",null,":"]
[]
[]
[null,null,"Fixed Glass",null,null,null,null,null,null,null,null,"Fixed Glass"]
[null,"Sum Insured",null,":","Per Event",null,null,null,null,{"$f":"'Proposal Form'!J66","v":0}]
[]
[null,"Premium",null,":",null,null,null,null,null,{"$f":"'Quotation Slip'!J172","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J67","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J178=0,L178&\" - Not Covered\",L178)","v":"Section 2 - Public Liability - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Quotation Slip'!J178","v":0},null,"Section 2 - Public Liability"]
[]
[]
[null,{"$f":"IF(J182=0,L181&\" - Not Covered\",L181)","v":"Public Liability - Not Covered"},null,null,null,null,null,null,null,null,null,"Public Liability"]
[null,"Limit of Liability",null,":","Any one occurrence ",null,null,null,null,{"$f":"'Proposal Form'!J100","v":0}]
[null,null,null,null,"Any one period",null,null,null,null,"Unlimited"]
[]
[null,"Deductible/Excess",null,":","Any one occurrence",null,null,null,null,{"$f":"'Proposal Form'!J102","v":0}]
[]
[null,"Annual Turnover",null,":",null,null,null,null,null,{"$f":"'Proposal Form'!J101","v":0}]
[]
[null,"Geographical Limit",null,":","Singapore"]
[]
[null,"Subjectivity",null,":","Insured’s number of years in business operations: more than 3 years.\n"]
[null,null,null,null,"Claims Experience: Nil claim for the past 3 years"]
[]
[null,{"$f":"IF(J195=0,L194&\" - Not Covered\",L194)","v":"Product Liability - Not Covered"},null,null,null,null,null,null,null,null,null,"Product Liability"]
[null,"Limit of Liability",null,":","Any one occurrence ",null,null,null,null,{"$f":"'Proposal Form'!J107","v":0}]
[null,null,null,null,"Any one period",null,null,null,null,"Unlimited"]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J109","v":0}]
[]
[null,"Annual Turnover",null,":",null,null,null,null,null,{"$f":"'Proposal Form'!J108","v":0}]
[]
[null,"Jurisdiction",null,":","Republic of Singapore"]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J206=0,L206&\" - Not Covered\",L206)","v":"Section 3 - Money - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Quotation Slip'!J206","v":0},null,"Section 3 - Money"]
[]
[]
[null,"Sum Insured",null,":","In Transit",null,null,null,null,{"$f":"'Proposal Form'!J87","v":0}]
[null,null,null,null,"In Premise",null,null,null,null,{"$f":"'Proposal Form'!J86","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J102","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J216=0,L216&\" - Not Covered\",L216)","v":"Section 4 - Goods in Transit - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Quotation Slip'!J216","v":0},null,"Section 4 - Goods in Transit"]
[]
[]
[null,"Sum Insured",null,":","Per Event",null,null,{"$f":"IF(J216=0,\"\",J216/J219)","v":""},null,{"$f":"'Proposal Form'!J79","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J83","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J225=0,L225&\" - Not Covered\",L225)","v":"Section 5 - Electronic Equipment - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Quotation Slip'!J225","v":0},null,"Section 5 - Electronic Equipment"]
[]
[]
[null,"Sum Insured",null,":","Anywhere in Singapore",null,null,{"$f":"IF(J225=0,\"\",J225/J228)","v":""},null,{"$f":"'Proposal Form'!J75","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J76","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J234=0,L234&\" - Not Covered\",L234)","v":"Section 6 - Fidelity Guarantee - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Quotation Slip'!J234","v":0},null,"Section 6 - Fidelity Guarantee"]
[]
[]
[null,"Limits of Guarantee",null,":","In Aggregate",null,null,{"$f":"IF(J234=0,\"\",'Pricing '!G34)","v":""},null,{"$f":"'Proposal Form'!J92","v":0}]
[]
[null,"No. of Employees to cover",null,":",null,null,null,null,null,{"$f":"'Proposal Form'!J93","v":0}]
[]
[null,"Category of staff",null,":",null,null,null,null,null,{"$f":"IF('Proposal Form'!J94=0,\"\",'Proposal Form'!J94)","v":""}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J95","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J247=0,L247&\" - Not Covered\",L247)","v":"Section 7 - Personal Accident - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Quotation Slip'!J247","v":0},null,"Section 7 - Personal Accident"]
[]
[]
[null,"Sum Insured",null,":","Non-Manual Employees (Group 1)"]
[null,null,null,null,"Accidental Death and Permanent Disability",null,null,null,null,{"$f":"'Proposal Form'!J$140","v":0}]
[null,null,null,null,"Medical Expense",null,null,null,null,{"$f":"'Proposal Form'!J$141","v":0}]
[null,null,null,null,"Number of Employees",null,null,null,null,{"$f":"'Proposal Form'!J$142","v":0}]
[]
[null,null,null,null,"Non-Manual Employees (Group 2)"]
[null,null,null,null,"Accidental Death and Permanent Disability",null,null,null,null,{"$f":"'Proposal Form'!K$140","v":0}]
[null,null,null,null,"Medical Expense",null,null,null,null,{"$f":"'Proposal Form'!K$141","v":0}]
[null,null,null,null,"Number of Employees",null,null,null,null,{"$f":"'Proposal Form'!K$142","v":0}]
[]
[null,null,null,null,"Non-Manual Employees (Group 3)"]
[null,null,null,null,"Accidental Death and Permanent Disability",null,null,null,null,{"$f":"'Proposal Form'!L$140","v":0}]
[null,null,null,null,"Medical Expense",null,null,null,null,{"$f":"'Proposal Form'!L$141","v":0}]
[null,null,null,null,"Number of Employees",null,null,null,null,{"$f":"'Proposal Form'!L$142","v":0}]
[]
[null,null,null,null,"Manual Employees"]
[null,null,null,null,"Accidental Death and Permanent Disability",null,null,null,null,{"$f":"'Proposal Form'!J145","v":0}]
[null,null,null,null,"Medical Expense",null,null,null,null,{"$f":"'Proposal Form'!J146","v":0}]
[null,null,null,null,"Number of Employees"]
[]
[null,"Number of Employees",null,":","Non-Manual Employees",null,null,null,null,{"$f":"'Proposal Form'!J142","v":0}]
[null,null,null,null,"Manual Employees",null,null,null,null,{"$f":"'Proposal Form'!J147","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J275=0,L275&\" - Not Covered\",L275)","v":"Section 8 - Machinery Breakdown - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Pricing '!M57","v":0},null,"Section 8 - Machinery Breakdown"]
[]
[]
[null,"Sum Insured",null,":","Machinery Breakdown",null,"at rate",{"$f":"IF(J275=0,\"\",J275/J278)","v":""},null,{"$f":"'Proposal Form'!J150","v":0}]
[]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J151","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J285=0,L285&\" - Not Covered\",L285)","v":"Section 8 - Burglary - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Quotation Slip'!J285","v":0},null,"Section 8 - Burglary"]
[]
[]
[null,"Sum Insured",null,":",{"$f":"'Proposal Form'!J72","v":0},null,null,{"$f":"IF(J285=0,\"\",J285/J288)","v":""},null,{"$f":"'Proposal Form'!J70","v":0}]
[]
[null,"Deductible/Excess",null,":","Each and every loss",null,null,null,null,{"$f":"'Proposal Form'!J71","v":0}]
[]
[null,"Subjectivity",null,":"]
[]
[null,{"$f":"IF(J294=0,L294&\" - Not Covered\",L294)","v":"Section 9 - Work Injury Compensation - Not Covered"},null,null,null,null,null,null,"Premium",{"$f":"'Quotation Slip'!J294","v":0},null,"Section 9 - Work Injury Compensation"]
[]
[]
[null,null,"Employee Category",null,null,"Number of Employees",null,null,"Estimated Total Annual Wages"]
[null,1,{"$f":"'Pricing '!C38","v":0},null,null,{"$f":"'Proposal Form'!I120","v":0},null,null,{"$f":"'Proposal Form'!J120","v":0}]
[null,{"$f":"B298+1","v":2},{"$f":"'Pricing '!C39","v":0},null,null,{"$f":"'Proposal Form'!I121","v":0},null,null,{"$f":"'Proposal Form'!J121","v":0}]
[null,{"$f":"B299+1","v":3},{"$f":"'Pricing '!C40","v":0},null,null,{"$f":"'Proposal Form'!I122","v":0},null,null,{"$f":"'Proposal Form'!J122","v":0}]
[null,4,{"$f":"'Pricing '!C41","v":0},null,null,{"$f":"'Proposal Form'!I123","v":0},null,null,{"$f":"'Proposal Form'!J123","v":0}]
[null,5,{"$f":"'Pricing '!C42","v":0},null,null,{"$f":"'Proposal Form'!I124","v":0},null,null,{"$f":"'Proposal Form'!J124","v":0}]
[null,6,{"$f":"'Pricing '!C43","v":0},null,null,{"$f":"'Proposal Form'!I125","v":0},null,null,{"$f":"'Proposal Form'!J125","v":0}]
[null,7,{"$f":"'Pricing '!C44","v":0},null,null,{"$f":"'Proposal Form'!I126","v":0},null,null,{"$f":"'Proposal Form'!J126","v":0}]
[null,8,{"$f":"'Pricing '!C45","v":0},null,null,{"$f":"'Proposal Form'!I127","v":0},null,null,{"$f":"'Proposal Form'!J127","v":0}]
[null,9,{"$f":"'Pricing '!C46","v":0},null,null,{"$f":"'Proposal Form'!I121","v":0},null,null,{"$f":"'Proposal Form'!J128","v":0}]
[null,10,{"$f":"'Pricing '!C47","v":0},null,null,{"$f":"'Proposal Form'!I128","v":0},null,null,{"$f":"'Proposal Form'!J129","v":0}]
[null,11,{"$f":"'Pricing '!C48","v":0},null,null,{"$f":"'Proposal Form'!I129","v":0},null,null,{"$f":"'Proposal Form'!J130","v":0}]
[null,12,{"$f":"'Pricing '!C49","v":0},null,null,{"$f":"'Proposal Form'!I130","v":0},null,null,{"$f":"'Proposal Form'!J131","v":0}]
[null,13,{"$f":"'Pricing '!C50","v":0},null,null,{"$f":"'Proposal Form'!I131","v":0},null,null,{"$f":"'Proposal Form'!J132","v":0}]
[null,14,{"$f":"'Pricing '!C51","v":0},null,null,{"$f":"'Proposal Form'!I132","v":0},null,null,{"$f":"'Proposal Form'!J133","v":0}]
[null,15,{"$f":"'Pricing '!C52","v":0},null,null,{"$f":"'Proposal Form'!I133","v":0},null,null,{"$f":"'Proposal Form'!J134","v":0}]
[]
[null,"Limit of Liability",null,":","Common Law Limit (per occurrence)",null,null,null,null,15000000]
[null,null,null,null,"Hospitalisation Leave Wages (days)",null,null,null,null,60]
[null,null,null,null,"Medical Leave Wages (days)",null,null,null,null,14]
[null,null,null,null,"Medical Expense (per accident per employee)",null,null,null,null,250000]
[]
[null,"Geographical Limit",null,":","Singapore"]
[]
[null,"Subjectivity",null,":","Insured’s number of years in business operations: more than 3 years.\n"]
[null,null,null,null,"Claims Experience: Nil claim for the past 3 years"]
[null,null,null,null,"No seconded employees or employees based out of Singapore."]
[]
[null,"Subject to the following extensions as in the Policy Wording. Limit of Liability and Excess is as per Polcy Wording unless stated otherwise:"]
[]
[null,"Extensions",null,null,null,null,"Excess",null,"Limit of Liability"]
[]
[null,"Section 1C - Business Interruption"]
[3,{"$f":"VLOOKUP(A330,Dropdown!Q:AM,VLOOKUP('Policy Schedule_v2'!B329,Dropdown!N:O,2,FALSE),FALSE)","v":"Alternative Basis"}]
[null,{"$f":"VLOOKUP(A331,Dropdown!Q:AM,VLOOKUP('Policy Schedule_v2'!B330,Dropdown!N:O,2,FALSE),FALSE)","v":{"$error":"#N/A"}}]
[null,"Section 1B - Fire & Extraneous Perils"]
[2,{"$f":"VLOOKUP(A333,Dropdown!Q:AM,VLOOKUP('Policy Schedule_v2'!B332,Dropdown!N:O,2,FALSE),FALSE)","v":"Alterations and Repairs"}]
[null,{"$f":"VLOOKUP(A334,Dropdown!Q:AM,VLOOKUP('Policy Schedule_v2'!B333,Dropdown!N:O,2,FALSE),FALSE)","v":{"$error":"#N/A"}}]
[null,"Section 1C - Business Interruption"]
[3,{"$f":"VLOOKUP(A336,Dropdown!Q:AM,VLOOKUP('Policy Schedule_v2'!B335,Dropdown!N:O,2,FALSE),FALSE)","v":"Alternative Basis"}]
[null,{"$f":"VLOOKUP(A337,Dropdown!Q:AM,VLOOKUP('Policy Schedule_v2'!B336,Dropdown!N:O,2,FALSE),FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Subject otherwise to the terms, exceptions and conditions of the Allianz Commercial Edge Insurance Policy."]
[]
[]
[]
[]
[]
[]
[null,"Issue Date",null,null,null,null,null,"Hicham Raissi"]
[null,null,null,null,null,null,null,"Chief Executive Officer"]
[null,null,null,null,null,null,null,"Allianz Insurance Singapore Pte. Ltd."]
[]
[]
[null,"Note: "]
[null,"This Policy Schedule shall be read in conjunction with the Policy Wording as one contract. Please refer to the Policy Wording for the exact terms and conditions as well as the full list of exclusions."]

{"sheet":"Policy Management Data","index":21,"n_rows":24,"n_cols":51,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,27,0,37],[0,15,0,25]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WICA details",null,null,null,null,null,null,null,null,null,null,null,"Premium before GST"]
["Qoutation No.","No","Email Received Date","Due Date (for ABS Issuance)","Due Date (for Document Issuance)","WICA Commission Rate","Other Lines Commission Rate","Distribution Channel","Insured Name","UEN/NRIC No.","Intermediary","Account Code","Insurance Class","ACE Master Policy No",null,"Error Message","Employer UEN","Employer Name","Policy No.","Effective Date","Expiry Date","Aggregated Annual Wages Declared by Employer","Aggregated Number of Workers Declared by Employer","Premium Amount Collected","Suspended Date","Termination Date",null,"WICA","Property ","Liability","Money","Goods in Transit","Electronic Equipment","Fidelity Guarantee","Personal Accident ","Machinery Breakdown ","Burglary","Total Premium (w/o GST)",null,"Effective Date","Expiry Date","Termination","Transaction Type (NB/EC/etc)","Trans. Date (Issued in Manual File)","Master Tax Invoice No.","Documents issuer","Doc Sent Date","Policy Status","Date Sent to Offshore","AGING","NEW AGING"]
[{"$f":"Data!C4","v":"44798-2"},null,null,null,null,0.125,0.25,{"$f":"'Proposal Form'!H8","v":0},{"$f":"'Quotation Slip'!E8","v":0},{"$f":"'Quotation Slip'!E10","v":0},{"$f":"'Quotation Slip'!E7","v":0},null,null,null,null,null,{"$f":"J3","v":0},{"$f":"I3","v":0},null,null,null,{"$f":"SUM('Quotation Slip'!I298:J312)","v":0},{"$f":"SUM('Quotation Slip'!F298:F312)","v":0},{"$f":"'Quotation Slip'!J294","v":0},null,null,null,{"$f":"X3","v":0},{"$f":"'Quotation Slip'!J16","v":0},{"$f":"'Quotation Slip'!J178","v":0},{"$f":"'Quotation Slip'!J206","v":0},{"$f":"'Quotation Slip'!J216","v":0},{"$f":"'Quotation Slip'!J225","v":0},{"$f":"'Quotation Slip'!J234","v":0},{"$f":"'Quotation Slip'!J247","v":0},{"$f":"'Quotation Slip'!J275","v":0},{"$f":"'Quotation Slip'!J285","v":0},{"$f":"SUM(AB3:AK3)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"LEGEND"]
[null,"Autofilled"]
[null,"PM to fill"]
[]
[]
[null,"INSTRUCTIONS TO PM IF ISSUED"]
[null,"Fill up the blanks"]
[null,"Copy paste the whole line into Master File Tracker"]
[null,"Press \"update\" button to update Technical that the quotation is secured"]
[null,"Share this file to Finance for their perusal"]
[]
[]
[]
[null,"Khairul's note: not sure this is button works anymore"]

{"sheet":"Debit Note","index":22,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":true,"merged":[[0,0,0,11],[2,0,2,2],[3,0,3,2],[45,1,45,10],[42,3,42,10],[10,0,10,2],[11,0,11,2],[30,0,30,4],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[8,0,8,2],[9,0,9,2],[31,0,31,4],[32,0,32,4],[9,15,9,16],[7,0,7,3],[7,7,7,15],[8,15,8,16],[10,4,10,9],[16,0,16,2],[17,0,17,2],[48,1,48,7],[34,6,34,7],[2,4,2,6],[47,4,47,11],[39,3,39,10],[40,3,40,10],[41,3,41,10],[35,0,35,1],[33,0,33,11],[19,0,19,10],[20,0,20,10],[21,0,21,10],[22,0,22,10],[23,0,24,10],[29,0,29,4],[30,9,31,11]]}
["Debit Note"]
[]
[{"$f":"'Proposal Form'!H6","v":0},null,null,null,null,null,null,"GST No.",":","201903913C"]
["GST No.: xxxxxxx",null,null,null,null,null,null,"Tax Invoice No.",":",{"$f":"'Tax Invoice'!H5","v":0}]
["<address line 1>",null,null,null,null,null,null,"Intermediary Code",":",{"$f":"'Proposal Form'!H7","v":0}]
["<address line 2>",null,null,null,null,null,null,"Date",":"]
["<address line 3>"]
[]
["Policy Number",null,null,":",{"$f":"'Tax Invoice'!D9","v":0}]
["Policyholder/Insured",null,null,":",{"$f":"'Tax Invoice'!D10","v":0}]
["Type of Insurance",null,null,":","ALLIANZ COMMERICAL EDGE"]
["Period of Insurance",null,null,":",{"$f":"'Tax Invoice'!D12","v":"00:00:00"},"to",{"$f":"'Tax Invoice'!F12","v":"00:00:00"},null,"(both dates inclusive)"]
["Annual Premium",null,null,":","SGD",{"$f":"'Tax Invoice'!E13","v":0}]
[{"$f":"'Tax Invoice'!A14","v":"GST on Premium @ 8%"},null,null,":","SGD",{"$f":"'Tax Invoice'!E14","v":0}]
["Total Premiums",null,null,":","SGD",{"$f":"SUM(F13:F14)","v":0}]
["Commission",null,null,":","SGD",{"$f":"-('Policy Management Data'!F3*'Policy Management Data'!AB3+'Policy Management Data'!G3*SUM('Policy Management Data'!AC3:AK3))","v":0}]
["GST on Commission @ 8%",null,null,":","SGD",{"$f":"F16*0.08","v":0}]
["Total Amount Due",null,null,":","SGD",{"$f":"SUM(F15:F17)","v":0}]
[]
["E. & O.E."]
["IMPORTANT NOTICE"]
["Premium must be received by the Insurer in accordance to the Premium Payment Warranty."]
["The tax shown is your output tax due to the Comptroller of GST. "]
["The Company should be notified of any discrepancy in writing within 2 weeks from data hereof, otherwise this invoice shall deemed to be correct. "]
[]
["This is a computer generated tax invoice. No signature is required. "]
[]
["Please detach and return this portion with your payment"]
[]
["Allianz Insurance Singapore Pte. Ltd. ",null,null,null,null,null,null,null,null,"Notice:"]
["79 ROBINSON ROAD #09-01",null,null,null,null,null,null,null,null,"Not applicable if premium has been paid"]
["Singapore 068897"]
["Attention: Finance Department"]
["PAYMENT ADVICE"]
["Intermediary Code",null,":",{"$f":"'Proposal Form'!H7","v":0},null,null,"Total Amount Due",null,":","SGD",null,{"$f":"F18","v":0}]
["Policy No",null,":",{"$f":"E9","v":0}]
[]
[]
[null,"Bank name",":","ALLIANZ INSURANCE SINGAPORE PTE. LTD."]
[null,"Bank",":","HSBC BANK "]
[null,"Account",":","052- 823754-002"]
[null,"Currency",":","SGD"]
[null,"Swift Code",":","HSBCSGSG"]
[null,"Address",":","79 ROBINSON ROAD #09-01 Singapore 068897"]
[null,"Payment Remarks",":","Please indicate Policy/invoice number/ref number & nature of payment"]
[]
[]
[null,"Bank Name",":",null,"___________ and Cheque No :___________"]
[null,"To be crossed and made payable to Allianz Insurance Singapore Pte. Ltd."]
[null,null,null,null,null,null,null,null,null,"Intermediary's Copy"]

{"sheet":"Finance Data","index":23,"n_rows":22,"n_cols":31,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,0,3,0]]}
[]
["Qoutation No.","BDM / PM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finance"]
[null,"Tax Invoice - Policy Issuance",null,null,null,null,null,null,null,null,null,"Tax Invoice Details",null,null,null,null,null,null,null,null,null,"Reciept Details",null,null,null,null,null,"Payment Details"]
[null,"Invoice Number","Issue By","ACE Policy Number","ABS Policy Number","Company / Policyholder name","UEN","Invoice Date: (DD/MM/YYYY)","Invoice Description","Channel","Intermediary Name","Premiums (b4 GST)","GST Amount","Premium + GST (J+k)","Comm (b4 GST)","Comm GST Amount","Comm + GST (M+N)","Comm %","Effective Date: (DD/MM/YYYY)","Expiry Date: (DD/MM/YYYY)","Remarks","Gross","Net","Voucher no","(G)Gross/(N)net settlement ","Settlement","O/s","Comms Payable","Payment","Amount","Remarks"]
[{"$f":"Data!C4","v":"44798-2"},null,null,{"$f":"'Policy Management Data'!N3","v":0},null,{"$f":"Data!H4","v":0},{"$f":"Data!I4","v":0},null,null,{"$f":"Data!G4","v":0},{"$f":"Data!E4","v":0},{"$f":"Data!OA4","v":0},{"$f":"L5*0.07","v":0},{"$f":"L5+M5","v":0},{"$f":"R5*L5","v":0},{"$f":"R5*M5","v":0},{"$f":"R5*N5","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"LEGEND"]
[null,"Autofilled"]
[null,"PM filled"]
[null,"Finance to fill"]

{"sheet":"Endorsement Schedule","index":24,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":true,"merged":[[38,7,38,9],[39,7,39,9],[40,7,40,9],[38,1,38,3],[0,0,0,10],[1,0,1,10],[18,0,18,10],[21,1,21,9],[25,0,25,10]]}
["Endorsement Schedule"]
["Original"]
[]
[null,"Date of Issue",null,":","2020-09-17"]
[null,"Policy No.",null,":","SP2000144375"]
[null,"Endorsement No.",null,":","<Endorsement No.>"]
[null,"Endorsement Effective Date",null,":","<Endorsement Effective Date>"]
[null,"Plan",null,":","ALLIANZ COMMERCIAL EDGE"]
[null,"Intermediary Code",null,":",{"$f":"'Tax Invoice'!H6","v":0}]
[null,"Intermediary",null,":",{"$f":"'Proposal Form'!H6","v":0}]
[null,"Policyholder/Insured",null,":",{"$f":"'Proposal Form'!H12","v":0}]
[null,"UEN",null,":","197601540N"]
[null,"Address",null,":",{"$f":"'Proposal Form'!H15","v":0}]
[null,"Nature of Business",null,":",{"$f":"'Proposal Form'!H16","v":0}]
[null,"Period of Insurance",null,":","From: <17 September 2020> To: <16 September 2021> (both dates inclusive)"]
[null,"Adjusted Premiums",null,":","SGD",768.55]
[null,"GST",null,":","SGD",53.81]
[null,"Premium Payable",null,":","SGD",822.46," (inclusive of GST)"]
[]
[]
[null,"The Property Insured"]
[null,"On the following property belonging to the Insured or held by the Insured or on commission or for which the Insured hold itself responsible:"]
[]
[null,"Locations of Risk",null,":","2 Balestier Road #03-659 Singapore 320002"]
[]
[]
[null,"Description:"]
[]
[]
[null,"<Remarks>"]
[]
[]
[null,"Subject otherwise to the terms, exceptions and conditions of the Allianz Commercial Edge Policy."]
[]
[]
[]
[]
[]
[null,"Issue Date",null,null,null,null,null,"Hicham Raissi"]
[null,null,null,null,null,null,null,"Chief Executive Officer"]
[null,null,null,null,null,null,null,"Allianz Insurance Singapore Pte. Ltd."]