{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Summary","Inventory","Lists"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":31,"n_cols":6,"rows_kept":31}
[]
[]
[null,"Inventory Summary"]
[]
[null,"Top Ten","Axis","Vals"]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A1),tblLists[Rank],0),1)","v":"Art"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A1),tblLists[Rank],0),2)","v":3}]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A2),tblLists[Rank],0),1)","v":"Books"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A2),tblLists[Rank],0),2)","v":3}]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A3),tblLists[Rank],0),1)","v":"Music"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A3),tblLists[Rank],0),2)","v":3}]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A4),tblLists[Rank],0),1)","v":"Movies"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A4),tblLists[Rank],0),2)","v":2}]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A5),tblLists[Rank],0),1)","v":"Toys"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A5),tblLists[Rank],0),2)","v":2}]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A6),tblLists[Rank],0),1)","v":"Games"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A6),tblLists[Rank],0),2)","v":1}]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A7),tblLists[Rank],0),1)","v":"Jewelry"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A7),tblLists[Rank],0),2)","v":1}]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A8),tblLists[Rank],0),1)","v":"Keepsakes"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A8),tblLists[Rank],0),2)","v":1}]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A9),tblLists[Rank],0),1)","v":"Memorabilia"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A9),tblLists[Rank],0),2)","v":0}]
[null,{"$f":"INDEX(tblLists[],MATCH(ROW($A10),tblLists[Rank],0),1)","v":"Sports"},-1,{"$f":"INDEX(tblLists[],MATCH(ROW($A10),tblLists[Rank],0),2)","v":0}]
[]
[]
[null,"Item Counts",null,null,"Most Recently Acquired Item"]
[]
[null,"Type","Count ",null,"Name",{"$f":"INDEX(tblData[],MATCH(MAX(tblData[Acquired]),tblData[Acquired],0),1)","v":"Beethoven"}]
[null,"Art",3,null,"Type",{"$f":"INDEX(tblData[],MATCH(MAX(tblData[Acquired]),tblData[Acquired],0),2)","v":"Music"}]
[null,"Books",3,null,"Description",{"$f":"INDEX(tblData[],MATCH(MAX(tblData[Acquired]),tblData[Acquired],0),3)","v":"Beethoven 25 Favorites"}]
[null,"Games",1,null,"Acquired",{"$f":"INDEX(tblData[],MATCH(MAX(tblData[Acquired]),tblData[Acquired],0),4)","v":"2010-04-04"}]
[null,"Jewelry",1]
[null,"Keepsakes",1]
[null,"Memorabilia",0]
[null,"Movies",2]
[null,"Music",3]
[null,"Sports",0]
[null,"Toys",2]
[null,"Grand Total",16]

{"sheet":"Inventory","index":1,"n_rows":21,"n_cols":6,"rows_kept":21}
[]
[]
[null,"Personal Collections Inventory"]
[]
[null,null,"Name","Type","Description","Acquired"]
[null,null,"Soccer Legends","Toys","Original memorabilia","1985-05-01"]
[null,null,"The Classics","Music","The Collection (3 CDs)","2010-02-01"]
[null,null,"Beethoven","Music","Beethoven 25 Favorites","2010-04-04"]
[null,null,"Baseball Greats","Books","20th century legends","2006-06-12"]
[null,null,"Classical Piano","Books","Sheet music","2006-09-06"]
[null,null,"Stringed Instruments","Books","Early history","2007-08-07"]
[null,null,"Xbox 360","Games","Console","2009-12-25"]
[null,null,"Sci-Fi","Movies","Sci-Fi history","2003-03-25"]
[null,null,"Night","Art","Vincent van Gogh, replica","1985-08-13"]
[null,null,"Beaded bracelet","Jewelry","Made by son","2008-07-17"]
[null,null,"Jewelry Box","Keepsakes","Gift from mom","2005-11-30"]
[null,null,"Sculpture stand","Art","Picked up at yard sale","2004-03-28"]
[null,null,"Sculpture","Art","Picked up at yard sale","2004-03-28"]
[null,null,"Fantasy collection","Movies","DVD collection (10 DVDs)","2003-03-25"]
[null,null,"Relaxation CD","Music","Mix, various artists","2009-06-18"]
[null,null,"Bicycle","Toys","Girl's bicycle","2002-09-14"]

{"sheet":"Lists","index":2,"n_rows":15,"n_cols":4,"rows_kept":15}
[]
[]
[null,"Collections List"]
[]
[null,"Type","Count","Rank"]
[null,"Art",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":3},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":1}]
[null,"Books",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":3},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":2}]
[null,"Games",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":1},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":6}]
[null,"Jewelry",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":1},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":7}]
[null,"Keepsakes",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":1},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":8}]
[null,"Memorabilia",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":0},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":9}]
[null,"Movies",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":2},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":4}]
[null,"Music",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":3},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":3}]
[null,"Sports",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":0},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":10}]
[null,"Toys",{"$f":"COUNTIF(tblData[Type],tblLists[[#This Row],[Type]])","v":2},{"$f":"RANK(tblLists[[#This Row],[Count]],tblLists[Count],0)+COUNTIF(INDEX(tblLists[Count],1,1):tblLists[[#This Row],[Count]],tblLists[[#This Row],[Count]])-1","v":5}]