{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Buildngs","Content","Validation & Calcs","Rate table "],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"comments":0,"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":"Buildngs","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,0,4,8],[12,1,12,4],[8,1,8,2],[10,1,10,2],[6,1,6,7]]}
[]
[]
[]
[]
["INTACT INSURANCE CHANNEL ISLANDS LIMITED - WHAT SUM INSURED CALCULATOR - JUNE 2024"]
[]
["BUILDINGS INSURANCE","Please read the what sum insured guide before completing this form"]
[]
["Type of home:"]
[]
["Location:"]
[]
["Construction:"]
[]
["Unit of Measurement:","m"]
[]
["Measurement:","Basement Floor:","Length:",null,"Width:",null,"Area:",{"$f":"D17*F17","v":0},{"$f":"CONCATENATE(\"sq\",\" \",$B$15)","v":"sq m"}]
[null,"Ground Floor:","Length:",null,"Width:",null,"Area:",{"$f":"D18*F18","v":0},{"$f":"CONCATENATE(\"sq\",\" \",$B$15)","v":"sq m"}]
[null,"First Floor:","Length:",null,"Width:",null,"Area:",{"$f":"D19*F19","v":0},"sq m"]
[null,"Second Floor:","Length:",null,"Width:",null,"Area:",{"$f":"D20*F20","v":0},"sq m"]
[null,"Third Floor:","Length:",null,"Width:",null,"Area:",{"$f":"D21*F21","v":0},"sq m"]
[]
["REBUILDING COST:",{"$f":"IF(ISERROR(E23*'Validation & Calcs'!B40),0,E23*'Validation & Calcs'!B40)","v":0},null,"Total Area:",{"$f":"IF(I17=F23,SUM(H17:H21),H23*10.764)","v":0},"sq ft","=",{"$f":"IF(I17=I23,SUM(H17:H21),E23/10.764)","v":0},"sq m"]
[]
["Luxury Factor:"]
[]
["Garages:"]
[]
[]
["Other Buildings:",{"$f":"SUM(B31:B38)","v":0}]
["Garden Walls:",0]
["Conservatory:",0]
["Tennis Court:",0]
["Swimming Pool / Jacuzzi:",0]
["Driveway / Paving, etc:",0]
["Timber Decking:",0]
["Solar Panels:",0]
["Other:",0]
[]
["Professional Fees:",{"$f":"(B23+B25+B28+B30)*18%","v":0}]
[]
["TOTAL SUM INSURED:",{"$f":"B23+B25+B28+B30+B40","v":0}]

{"sheet":"Content","index":1,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[4,1,4,6],[6,1,6,3]]}
[]
[]
[]
[]
["CONTENTS INSURANCE","Please read the guidelines before completing this form"]
[]
["LOCATION:"]
[]
["Lounge",null,null,"Kitchen",null,null,"Dining Room",null,null,"Bathroom / WC (add for more than one)"]
[]
["Sofa / Chairs                                       ",0,null,"Cooker/Microwave/Ovens",0,null,"Carpets/Curtains/Blinds                       ",0,null,"Carpets/Curtains",0]
["T.V. / Video / Hi-Fi / DVD Players / ",0,null,"Fridge/Freezer",0,null,"Table/Chairs",0,null,"Chair",0]
["Tapes / CD/DVDs                                            ",0,null,"Washing Machine/Dryer",0,null,"Linen",0,null,"Bathroom Cabinet/Mirror",0]
["Computers / Laptops / ipods / phones /",0,null,"Kettles/Irons/Toasters/Mixer",0,null,"China & Glass",0,null,"Towels",0]
["Electronic devices                                 ",0,null,"Table & Chairs",0,null,"Cutlery",0,null,"Toiletries",0]
["Carpets / Curtains / Blinds                       ",0,null,"Floor Covering/Curtains/Blinds",0,null,"Sideboard",0,null,"Linen basket/Clothes",0]
["Tables / Bookcases / Books                    ",0,null,"Crockery/Utensils/Cutlery",0,null,"Pictures/Clocks/Ornaments                 ",0,null,"Other items",0]
["Pictures / Clocks / Ornaments                 ",0,null,"Food & Drink",0,null,"Other items                                        ",0]
["Lamps / Lights                                      ",0,null,"Dishwasher",0]
["Value of Electronic Downloads            ",0,null,"Other items                                        ",0]
["Other items                                        ",0,null,"Electronic Equipment (e.g. tv)",0]
[]
["Main Bedroom",null,null,"Bedroom 2",null,null,"Bedroom 3",null,null,"Bedroom 4"]
[]
["Carpets / Curtains / Blinds",0,null,"Carpets/Curtains",0,null,"Carpets/Curtains",0,null,"Carpets/Curtains",0]
["Bed & Bedding",0,null,"Bed & Bedding",0,null,"Beds & Bedding",0,null,"Bed & Bedding",0]
["Wardrobe/Chest of Drawers",0,null,"Wardrobe/Chest of Drawers",0,null,"Wardrobe/Chest of Drawers",0,null,"Wardrobe/Chest of Drawers",0]
["Dressing Table/Chairs",0,null,"Dressing Table/Chairs",0,null,"Dressing Table/Chairs",0,null,"Dressing Table/Chairs",0]
["Pictures/Mirrors",0,null,"Pictures",0,null,"Pictures",0,null,"Pictures",0]
["Ornaments",0,null,"Ornaments",0,null,"Ornaments",0,null,"Ornaments",0]
["Clothes/Shoes/Bags",0,null,"Clothes",0,null,"Clothes",0,null,"Clothes",0]
["Valuables",0,null,"TV/Hi-Fi/Other",0,null,"TV/Hi-Fi/Other",0,null,"TV/Hi-Fi/Other",0]
["TV/Hi-Fi/Other",0,null,"Other items",0,null,"Other items",0,null,"Other items",0]
["Other items                                        ",0]
[]
["Hall / Stairs / Landing / Loft / Cellar",null,null,"Garage / Shed / Conservatory",null,null,"Study",null,null,"TOTALS"]
[]
["Carpets/Curtains",0,null,"Garden Equipment",0,null,"Desk/Chair",0,null,"Lounge",{"$f":"SUM(B11:B21)","v":0}]
["Furniture",0,null,"Lawn Mower",0,null,"Telephones/Fax/Photocopier/Printer",0,null,"Kitchen",{"$f":"SUM(E11:E21)","v":0}]
["Chairs",0,null,"Garden Furniture",0,null,"Computers Software",0,null,"Dining Room",{"$f":"SUM(H11:H18)","v":0}]
["Pictures",0,null,"Work Bench & Tools",0,null,"Value of Electronic Downloads",0,null,"Main Bedroom",{"$f":"SUM(B25:B34)","v":0}]
["Sports Equipment",0,null,"Motor Accessories",0,null,"Other equipment",0,null,"Bedroom 2",{"$f":"SUM(E25:E33)","v":0}]
["Vacuum Cleaner",0,null,"Conservatory Furniture",0,null,"Carpets/Blinds/Curtains",0,null,"Bedroom 3",{"$f":"SUM(H25:H33)","v":0}]
["Items in Storage",0,null,"Bikes/Toys",0,null,"Other items",0,null,"Bedroom 4",{"$f":"SUM(K25:K33)","v":0}]
["Other items",0,null,"Other items",0,null,null,null,null,"Bathroom/WC",{"$f":"SUM(K11:K17)","v":0}]
[null,null,null,null,null,null,null,null,null,"Hall / Stairs / Landing / Loft / Cellar",{"$f":"SUM(B38:B45)","v":0}]
["OTHER",null,null,null,null,null,null,null,null,"Garage / Shed / Conservatory",{"$f":"SUM(E38:E45)","v":0}]
[null,null,null,null,null,null,null,null,null,"Study",{"$f":"SUM(H38:H44)","v":0}]
["Collections*",0,null,null,null,null,null,null,null,"Other",{"$f":"SUM(B49:B51)","v":0}]
["Stairlift*",0,null,"*specify separately to Insurance Corporation"]
["Disability Scooter*",0,null,null,null,null,null,null,null,"TOTAL SUM INSURED:",{"$f":"SUM(K38:K50)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B7=\"Jersey\",\"GST:\",IF(B7=\"Isle of Man\",\"VAT:\",\"\"))","v":""},{"$f":"IF(J52=\"GST:\",K51*0.05,IF(J52=\"VAT:\",K51*0.05,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J52=\"\",\"\",\"TOTAL:\")","v":""},{"$f":"IF(J53=\"\",\"\",SUM(K51:K52))","v":""}]

{"sheet":"Validation & Calcs","index":2,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["House Type"]
[]
["Detached House",1]
["Semi-Detached House",2]
["Detached Bungalow",3]
["Semi-Detached Bungalow",4]
["Terraced House",5]
["Terraced Bungalow",6]
["Detached 1½ Storey House / Cottage",7]
["Terraced 1½ Storey House / Cottage",8]
[]
["Location"]
[]
["Guernsey",2]
["Jersey",3]
["Alderney",4]
["Sark",5]
["Herm",6]
[]
["Construction"]
[]
["Block / Brick Rendered or timber framed",1]
["Rendered \"Georgian or Victorian\" Period Property",2]
["Stone / Granite Farmhouse or Cottage",3]
[]
["Garages"]
[]
["Single - Prefabricated"]
["Single - Brick / Block"]
["Double"]
[]
["CODE"]
[]
["Area",1]
["Construction",{"$f":"VLOOKUP(Buildngs!B13,$A$22:$B$24,2,FALSE)","v":{"$error":"#N/A"}}]
["Type",{"$f":"VLOOKUP(Buildngs!B9,$A$3:$B$10,2,FALSE)","v":{"$error":"#N/A"}}]
[]
["CODE",{"$f":"VALUE(B34&B35&B36)","v":{"$error":"#N/A"}}]
["LOCATION",{"$f":"VALUE(VLOOKUP(Buildngs!B11,$A$14:$B$18,2,FALSE))","v":{"$error":"#N/A"}}]
["Cost per sq ft",{"$f":"VLOOKUP(B38,'Rate table '!$B$4:$G$31,B39,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Rate table ","index":3,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Type of Home"]
[]
["Block / Brick Rendered or timber framed",null,"Guernsey","Jersey","Alderney","Sark","Herm"]
["Detached House",111,412.76400000000001,396.89100000000002,474.68299999999999,474.68299999999999,495.31900000000002]
["Semi-Detached House",112,397.67200000000003,382.38200000000001,457.32499999999999,457.32499999999999,477.202]
["Detached Bungalow",113,453.94799999999998,436.49099999999999,522.03800000000001,522.03800000000001,544.74200000000008]
["Semi-Detached Bungalow",114,431.97,415.36,496.77100000000002,496.77100000000002,518.36400000000003]
["Terraced House",115,382.50299999999999,367.79599999999999,439.87900000000002,439.87900000000002,459.00799999999998]
["Terraced Bungalow",116,409.99200000000002,394.21800000000002,471.49299999999999,471.49299999999999,491.98599999999999]
["Detached 1½ Storey House / Cottage",117,421.04699999999997,404.85500000000002,484.209,484.209,505.25200000000001]
["Terraced 1½ Storey House / Cottage",118,393.59100000000001,378.45500000000004,452.62800000000004,452.62800000000004,472.30700000000002]
[]
["Rendered \"Georgian or Victorian\" Period Property",null,"Guernsey","Jersey","Alderney","Sark","Herm"]
["Detached House",121,436.678,419.88099999999997,502.18299999999999,502.18299999999999,524.01800000000003]
["Semi-Detached House",122,422.59800000000001,406.34,485.99099999999999,485.99099999999999,507.12199999999996]
["Detached Bungalow",123,476.38799999999998,458.06200000000001,547.84400000000005,547.84400000000005,571.67000000000007]
["Semi-Detached Bungalow",124,452.82600000000002,435.41300000000001,520.75099999999998,520.75099999999998,543.38900000000001]
["Terraced House",125,404.93200000000002,389.35599999999999,465.67399999999998,465.67399999999998,485.91399999999999]
["Terraced Bungalow",126,429.26400000000001,412.75300000000004,493.65799999999996,493.65799999999996,515.11900000000003]
["Detached 1½ Storey House / Cottage",127,444.09200000000004,427.00900000000001,510.70799999999997,510.70799999999997,532.90599999999995]
["Terraced 1½ Storey House / Cottage",128,413.47899999999998,397.57299999999998,475.49699999999996,475.49699999999996,496.17700000000002]
[]
["Stone / Granite Farmhouse or Cottage",null,"Guernsey","Jersey","Alderney","Sark","Herm"]
["Detached House",131,484.35199999999998,465.71800000000002,557.00700000000006,557.00700000000006,581.21799999999996]
["Semi-Detached House",132,472.274,454.113,543.11400000000003,543.11400000000003,566.73099999999999]
["Detached Bungalow",133,521.11400000000003,501.072,599.28,599.28,625.33900000000006]
["Semi-Detached Bungalow",134,494.40599999999995,475.387,568.56799999999998,568.56799999999998,593.28500000000008]
["Terraced House",135,449.64699999999999,432.35500000000002,517.09899999999993,517.09899999999993,539.572]
["Terraced Bungalow",136,467.69799999999998,449.71299999999997,537.85599999999999,537.85599999999999,561.24200000000008]
["Detached 1½ Storey House / Cottage",137,490.02800000000002,471.185,563.53,563.53,588.03800000000001]
["Terraced 1½ Storey House / Cottage",138,453.11200000000002,435.68799999999999,521.08100000000002,521.08100000000002,543.73]