{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Grocery list","calculations"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Grocery list","index":0,"n_rows":22,"n_cols":13,"rows_kept":22}
[{"$nulls":11},{"$f":"calculations!M9","v":"DAIRY TOTAL"}," "]
[]
[null,"GROCERY LIST"]
[null,"DONE","ITEM","STORE","CATEGORY","QTY","UNIT","UNIT PRICE","TOTAL","COMMENT",null,{"$f":"calculations!M6","v":"SEAFOOD TOTAL"}]
[null,1,"Oranges","Grocery","Produce",2,"lbs",{"v":2.99,"d":"$2.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":5.98,"d":"$5.98"}},null,null,{"$f":"calculations!L6","v":{"v":109,"d":"$109"}}]
[null,1,"Apples","Orchard","Produce",3,"lbs",{"v":1.99,"d":"$1.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":5.97,"d":"$5.97"}},"Have coupon"]
[null,null,"Bananas","Grocery","Produce",1,"bunch",{"v":3.99,"d":"$3.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":3.99,"d":"$3.99"}},null,null,{"$f":"calculations!M7","v":"MEAT TOTAL"}]
[null,null,"Lettuce","Market","Produce",2,"head",{"v":2.29,"d":"$2.29"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":4.58,"d":"$4.58"}},null,null,{"$f":"calculations!L7","v":{"v":80,"d":"$80"}}]
[null,null,"Tomatoes","Market","Produce",4,"lbs",{"v":3.49,"d":"$3.49"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":13.96,"d":"$13.96"}}]
[null,null,"Squash","Market","Produce",2,"each",{"v":1.5,"d":"$1.50"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":3,"d":"$3.00"}},null,null,{"$f":"calculations!M8","v":"PRODUCE TOTAL"}]
[null,null,"Celery","Grocery","Produce",2,"bunch",{"v":1.99,"d":"$1.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":3.98,"d":"$3.98"}},null,null,{"$f":"calculations!L8","v":{"v":45,"d":"$45"}}]
[null,null,"Cucumber","Market","Produce",1,"lbs",{"v":2.29,"d":"$2.29"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":2.29,"d":"$2.29"}}]
[null,null,"Mushrooms","Grocery","Produce",0.5,"lbs",{"v":2.25,"d":"$2.25"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":1.125,"d":"$1.13"}},"Large portabella",null,{"$f":"calculations!M9","v":"DAIRY TOTAL"}]
[null,null,"Milk ","Home delivery","Dairy",2,"gal",{"v":3.99,"d":"$3.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":7.98,"d":"$7.98"}},null,null,{"$f":"calculations!L9","v":{"v":37,"d":"$37"}}]
[null,null,"Cheese","Home delivery","Dairy",1,"lbs",{"v":9.99,"d":"$9.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":9.99,"d":"$9.99"}},"Variety of block cheeses"]
[null,null,"Eggs","Home delivery","Dairy",2,"doz",{"v":3.5,"d":"$3.50"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":7,"d":"$7.00"}},null,null,{"$f":"calculations!M3","v":"OTHER TOTAL"}]
[null,null,"Cottage cheese","Home delivery","Dairy",1,"16 oz",{"v":3.89,"d":"$3.89"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":3.89,"d":"$3.89"}},null,null,{"$f":"calculations!L3","v":{"v":0,"d":"$0"}}]
[null,null,"Sour cream","Home delivery","Dairy",1,"8 oz",{"v":2.99,"d":"$2.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":2.99,"d":"$2.99"}}]
[null,null,"Yogurt","Grocery","Dairy",1,"16 oz",{"v":4.99,"d":"$4.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":4.99,"d":"$4.99"}},"Greek with honey",null,{"$f":"calculations!M4","v":"GROCERY TOTAL"}]
[null,null,"Beef","Market","Meat",10,"lbs",{"v":7.99,"d":"$7.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":79.9,"d":"$79.90"}},"Bacon wrapped filets",null,{"$f":"GroceryTotal","v":{"v":271,"d":"$271"}}]
[null,null,"Wild salmon","Fish market","Seafood",6,"lbs",{"v":8.99,"d":"$8.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":53.94,"d":"$53.94"}}]
[null,null,"Alaskan king crab legs","Fish market","Seafood",5,"lbs",{"v":10.99,"d":"$10.99"},{"$f":"IFERROR(List[[#This Row],[QTY]]*List[[#This Row],[UNIT PRICE]],\"\")","v":{"v":54.95,"d":"$54.95"}}]

{"sheet":"calculations","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"hidden":true}
["***  Sheet to remain hidden ***"]
[]
[{"$nulls":10},{"$f":"SUM(List[TOTAL])-SUM(K6:K9)","v":{"v":0,"d":"$0.00"}},{"$f":"ROUND(K3,0)","v":{"v":0,"d":"$0"}},"OTHER TOTAL"]
[{"$nulls":11},{"$f":"ROUNDUP(SUM(List[TOTAL]),0)","v":{"v":271,"d":"$271"}},"GROCERY TOTAL"]
[]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E5,List[CATEGORY]),)),\"\")","v":"Produce"},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E6)","v":44.875},{"$f":"F6+ROW()/1000000","v":44.875006},{"$f":"LARGE($G$6:$G$21,1)","v":108.890009},{"$f":"MATCH(H6,$G$6:$G$21,0)","v":4},{"$f":"INDEX($E$6:$E$21,$I6)","v":"Seafood"},{"$f":"INDEX($F$6:$F$21,$I6)","v":{"v":108.89,"d":"$108.89"}},{"$f":"IF(M6=\"\",\"\", ROUND(K6,0))","v":{"v":109,"d":"$109"}},{"$f":"IF(J6=\"\",\"\", UPPER(J6) & \" TOTAL\")","v":"SEAFOOD TOTAL"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E6,List[CATEGORY]),)),\"\")","v":"Dairy"},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E7)","v":36.84},{"$f":"F7+ROW()/1000000","v":36.840007},{"$f":"LARGE($G$6:$G$21,2)","v":79.900008},{"$f":"MATCH(H7,$G$6:$G$21,0)","v":3},{"$f":"INDEX($E$6:$E$21,$I7)","v":"Meat"},{"$f":"INDEX($F$6:$F$21,$I7)","v":{"v":79.9,"d":"$79.90"}},{"$f":"IF(M7=\"\",\"\", ROUND(K7,0))","v":{"v":80,"d":"$80"}},{"$f":"IF(J7=\"\",\"\", UPPER(J7) & \" TOTAL\")","v":"MEAT TOTAL"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E7,List[CATEGORY]),)),\"\")","v":"Meat"},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E8)","v":79.9},79.900008,{"$f":"LARGE($G$6:$G$21,3)","v":44.875006},{"$f":"MATCH(H8,$G$6:$G$21,0)","v":1},{"$f":"INDEX($E$6:$E$21,$I8)","v":"Produce"},{"$f":"INDEX($F$6:$F$21,$I8)","v":{"v":44.875,"d":"$44.88"}},{"v":45,"d":"$45"},{"$f":"IF(J8=\"\",\"\", UPPER(J8) & \" TOTAL\")","v":"PRODUCE TOTAL"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E8,List[CATEGORY]),)),\"\")","v":"Seafood"},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E9)","v":108.89},108.890009,{"$f":"LARGE($G$6:$G$21,4)","v":36.840007},{"$f":"MATCH(H9,$G$6:$G$21,0)","v":2},{"$f":"INDEX($E$6:$E$21,$I9)","v":"Dairy"},{"$f":"INDEX($F$6:$F$21,$I9)","v":{"v":36.84,"d":"$36.84"}},{"v":37,"d":"$37"},{"$f":"IF(J9=\"\",\"\", UPPER(J9) & \" TOTAL\")","v":"DAIRY TOTAL"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E9,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E10)","v":0},1e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E10,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E11)","v":0},1.1E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E11,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E12)","v":0},1.2E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E12,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E13)","v":0},1.3e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E13,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E14)","v":0},1.4E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E14,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E15)","v":0},1.5E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E15,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E16)","v":0},1.6e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E16,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E17)","v":0},1.7E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E17,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E18)","v":0},1.8E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E18,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E19)","v":0},1.9e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E19,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E20)","v":0},2e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[CATEGORY],MATCH(,COUNTIF($E$5:E20,List[CATEGORY]),)),\"\")","v":""},{"$f":"SUMIFS(List[TOTAL],List[CATEGORY],E21)","v":0},2.1e-05]