{"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 - MARCH 2026"]
[]
["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,433.61,426.65,498.65,498.65,520.33000000000004]
["Semi-Detached House",112,417.8,411.1,480.47,480.47,501.36]
["Detached Bungalow",113,476.85,469.2,548.38,548.38,572.22]
["Semi-Detached Bungalow",114,453.79,446.51,521.85,521.85,544.54]
["Terraced House",115,401.8,395.35,462.07,462.07,482.16]
["Terraced Bungalow",116,430.72,423.82,495.33,495.33,516.87]
["Detached 1½ Storey House / Cottage",117,442.35,435.26,508.71,508.71,530.82000000000005]
["Terraced 1½ Storey House / Cottage",118,410.74,404.16,472.35,472.35,492.89]
[]
["Rendered \"Georgian or Victorian\" Period Property",null,"Guernsey","Jersey","Alderney","Sark","Herm"]
["Detached House",121,458.76,451.4,527.57000000000005,527.57000000000005,550.51]
["Semi-Detached House",122,443.94,436.82,510.54,510.54,532.73]
["Detached Bungalow",123,500.51,492.58,575.48,575.48,600.61]
["Semi-Detached Bungalow",124,475.75,468.12,547.12,547.12,570.91]
["Terraced House",125,425.36,418.53,489.16,489.16,510.43]
["Terraced Bungalow",126,451,443.77,518.65,518.65,541.20000000000005]
["Detached 1½ Storey House / Cottage",127,466.51,459.03,536.49,536.49,559.80999999999995]
["Terraced 1½ Storey House / Cottage",128,436.89,429.88,502.42,502.42,524.26]
[]
["Stone / Granite Farmhouse or Cottage",null,"Guernsey","Jersey","Alderney","Sark","Herm"]
["Detached House",131,508.86,500.7,585.17999999999995,585.17999999999995,610.63]
["Semi-Detached House",132,496.13,488.18,570.54999999999995,570.54999999999995,595.36]
["Detached Bungalow",133,547.42999999999995,538.65,629.54,629.54,656.91]
["Semi-Detached Bungalow",134,519.39,511.06,597.29999999999995,597.29999999999995,623.27]
["Terraced House",135,472.37,464.8,543.23,543.23,566.85]
["Terraced Bungalow",136,491.36,483.48,565.07000000000005,565.07000000000005,589.63]
["Detached 1½ Storey House / Cottage",137,514.82000000000005,506.56,592.04,592.04,617.78]
["Terraced 1½ Storey House / Cottage",138,489.37,481.52,562.78,562.78,587.25]