{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Home Contents Inventory List","Room lookup"],"not_rendered":{"images":2,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Home Contents Inventory List","index":0,"n_rows":16,"n_cols":12,"rows_kept":16,"merged":[[0,1,0,2],[1,1,1,3],[1,6,1,7],[2,1,3,1],[2,2,3,2],[2,3,3,5],[2,8,2,10],[3,8,3,10],[4,1,5,1],[4,2,5,2],[4,3,5,5],[4,8,4,10],[5,8,5,10],[6,1,7,1],[6,2,7,2],[6,3,7,5],[6,8,6,10],[7,8,7,10]]}
[null,"Home Inventory",null,"Contents list",{"$nulls":7},"House icon is in this cell"]
[null," TOTAL ESTIMATED VALUE OF ALL ITEMS:",null,null,{"$f":"SUM(Inventory[[#Totals],[Estimated\ncurrent value]])","v":{"v":4040,"d":"£4,040.00"}},null,"INVENTORY DATE:",null,{"$f":"TODAY()-35","v":"2019-05-17"}]
[null,"Person icon is in this cell","NAME:","Enter your name here",{"$nulls":3},"Insurance company:","Enter Insurance company name here"]
[{"$nulls":7},"Insurance company phone:","Enter Insurance company phone number here"]
[null,"Envelope is in this cell","ADDRESS:","Enter your address here",{"$nulls":3},"Insurance company policy number:","Enter Insurance policy number here"]
[{"$nulls":7},"Insurance agent:","Enter Insurance agent name here"]
[null,"Phone icon is in this cell","PHONE NUMBER:","Enter your phone number here",{"$nulls":3},"Insurance agent phone:","Enter Insurance agent phone number here"]
[{"$nulls":7},"Insurance agent address:","Enter Insurance agent address here"]
[null,"A slicer is in cells B9 to J9. To filter inventory list, select a room from the slicer in this cell. Press and hold CTRL to select multiple rooms."]
[null,"Item no.","Room/Area","Item/description","Make/model","Serial number/\nID number","Date\npurchased","Where purchased","Purchase\nprice","Estimated\ncurrent value","Notes","Photo?"]
[null,{"$f":"ROW($A1)","v":1},"Living room","Item 1","Manufacturer 1","33XCBH3",{"$f":"TODAY()-120","v":"2019-02-21"},"Online",{"v":2000,"d":"£2,000.00"},{"v":2000,"d":"£2,000.00"},null,"Yes"]
[null,{"$f":"ROW($A2)","v":2},"Home office","Item 2","Manufacturer 2","55-678B",{"$f":"TODAY()-90","v":"2019-03-23"},"Computer shop",{"v":1500,"d":"£1,500.00"},{"v":1000,"d":"£1,000.00"},null,"No"]
[null,3,"Living room","Item 3","Manufacturer 3","7865SS-J3",{"$f":"TODAY()-60","v":"2019-04-22"},"Furniture shop",{"v":560,"d":"£560.00"},{"v":550,"d":"£550.00"},null,"No"]
[null,4,"Dining room","Item 4","Manufacturer 4","768087",{"$f":"TODAY()-30","v":"2019-05-22"},"Online",{"v":240,"d":"£240.00"},{"v":200,"d":"£200.00"},null,"Yes"]
[null,5,"Family room","Item 5","Manufacturer 5","80-JBNR",{"$f":"TODAY()","v":"2019-06-21"},"Computer shop",{"v":300,"d":"£300.00"},{"v":290,"d":"£290.00"},null,"No"]
[null,"TOTALS",{"$f":"\"INVENTORY ITEMS: \"&SUBTOTAL(103,Inventory[Room/Area])","v":"INVENTORY ITEMS: 5"},{"$nulls":5},{"$f":"SUBTOTAL(109,Inventory[Purchase\nprice])","v":{"v":4600,"d":"£4,600.00"}},{"$f":"SUBTOTAL(109,Inventory[Estimated\ncurrent value])","v":{"v":4040,"d":"£4,040.00"}}]

{"sheet":"Room lookup","index":1,"n_rows":15,"n_cols":2,"rows_kept":15}
[null,"Room lookup"]
[null,"Modify or add entries to this list. Simply type over an existing entry or add a new entry directly below the last row of the table."]
[null,"Room/Area"]
[null,"Basement"]
[null,"Bedroom 1"]
[null,"Bedroom 2"]
[null,"Bedroom 3"]
[null,"Bedroom 4"]
[null,"Dining room"]
[null,"Family room"]
[null,"Garage"]
[null,"Home office"]
[null,"Kitchen"]
[null,"Living room"]
[null,"Master bedroom"]