{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["購物清單","計算"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"購物清單","index":0,"n_rows":21,"n_cols":13,"rows_kept":21,"merged":[[0,1,0,11],[0,12,1,12],[1,1,1,11],[4,12,5,12],[7,12,8,12],[10,12,11,12],[13,12,14,12]]}
[{"$nulls":12},{"$f":"計算!M9","v":"乳製品 總計"}]
[null," 購物清單"]
[null,null,"完成","項目","商店","類別","數量","單位","單價","總計","備註",null,{"$f":"計算!L9","v":37}]
[null,null,1,"橘子","雜貨店","農產品",2,"磅",{"v":2.99,"d":"NT$2.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":5.98,"d":"NT$5.98"}},null,null,{"$f":"計算!M8","v":"農產品 總計"}]
[{"$nulls":3},"蘋果","果園","農產品",3,"磅",{"v":1.99,"d":"NT$1.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":5.97,"d":"NT$5.97"}},"有折價券",null,{"$f":"計算!L8","v":45}]
[{"$nulls":3},"香蕉","雜貨店","農產品",1,"串/束",{"v":3.99,"d":"NT$3.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":3.99,"d":"NT$3.99"}}]
[{"$nulls":3},"萵苣","市場","農產品",2,"把",{"v":2.29,"d":"NT$2.29"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":4.58,"d":"NT$4.58"}},null,null,{"$f":"計算!M7","v":"肉品 總計"}]
[{"$nulls":3},"番茄","市場","農產品",4,"磅",{"v":3.49,"d":"NT$3.49"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":13.96,"d":"NT$13.96"}},null,null,{"$f":"計算!L7","v":80}]
[{"$nulls":3},"果汁飲料","市場","農產品",2,"每個",{"v":1.5,"d":"NT$1.50"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":3,"d":"NT$3.00"}}]
[{"$nulls":3},"芹菜","雜貨店","農產品",2,"串/束",{"v":1.99,"d":"NT$1.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":3.98,"d":"NT$3.98"}},null,null,{"$f":"計算!M6","v":"海鮮 總計"}]
[{"$nulls":3},"小黃瓜","市場","農產品",1,"磅",{"v":2.29,"d":"NT$2.29"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":2.29,"d":"NT$2.29"}},null,null,{"$f":"計算!L6","v":109}]
[{"$nulls":3},"香菇","雜貨店","農產品",0.5,"磅",{"v":2.25,"d":"NT$2.25"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":1.125,"d":"NT$1.13"}},"大褐菇"]
[{"$nulls":3},"牛奶 ","宅配","乳製品",2,"加侖",{"v":3.99,"d":"NT$3.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":7.98,"d":"NT$7.98"}},null,null,{"$f":"計算!M3","v":"其他總計"}]
[{"$nulls":3},"起司","宅配","乳製品",1,"磅",{"v":9.99,"d":"NT$9.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":9.99,"d":"NT$9.99"}},"各種起司塊",null,{"$f":"計算!L3","v":0}]
[{"$nulls":3},"雞蛋","宅配","乳製品",2,"一打",{"v":3.5,"d":"NT$3.50"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":7,"d":"NT$7.00"}}]
[{"$nulls":3},"鄉村乳酪","宅配","乳製品",1,"16 盎司",{"v":3.89,"d":"NT$3.89"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":3.89,"d":"NT$3.89"}},null,null,{"$f":"計算!M4","v":"購物總計"}]
[{"$nulls":3},"酸奶油","宅配","乳製品",1,"8 盎司",{"v":2.99,"d":"NT$2.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":2.99,"d":"NT$2.99"}},null,null,{"$f":"購物總計","v":271}]
[{"$nulls":3},"優格","雜貨店","乳製品",1,"16 盎司",{"v":4.99,"d":"NT$4.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":4.99,"d":"NT$4.99"}},"希臘式 (含蜂蜜)"]
[{"$nulls":3},"牛肉","市場","肉品",10,"磅",{"v":7.99,"d":"NT$7.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":79.9,"d":"NT$79.90"}},"培根包里肌肉"]
[{"$nulls":3},"野生鮭魚","魚市場","海鮮",6,"磅",{"v":8.99,"d":"NT$8.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":53.94,"d":"NT$53.94"}}]
[{"$nulls":3},"阿拉斯加帝王蟹腳","魚市場","海鮮",5,"磅",{"v":10.99,"d":"NT$10.99"},{"$f":"IFERROR(清單[數量]*清單[單價],\"\")","v":{"v":54.95,"d":"NT$54.95"}}]

{"sheet":"計算","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"hidden":true}
["*** 工作表要保持隱藏 ***"]
[]
[{"$nulls":10},{"$f":"SUM(清單[總計])-SUM(K6:K9)","v":{"v":0,"d":"NT$0.00"}},{"$f":"ROUND(K3,0)","v":{"v":0,"d":"NT$0"}},"其他總計"]
[{"$nulls":11},{"$f":"ROUNDUP(SUM(清單[總計]),0)","v":{"v":271,"d":"NT$271"}},"購物總計"]
[]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E5,清單[類別]),)),\"\")","v":"農產品"},{"$f":"SUMIFS(清單[總計],清單[類別],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":"海鮮"},{"$f":"INDEX($F$6:$F$21,$I6)","v":{"v":108.89,"d":"NT$108.89"}},{"$f":"ROUND(K6,0)","v":{"v":109,"d":"NT$109"}},{"$f":"UPPER(J6) & \" 總計\"","v":"海鮮 總計"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E6,清單[類別]),)),\"\")","v":"乳製品"},{"$f":"SUMIFS(清單[總計],清單[類別],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":"肉品"},{"$f":"INDEX($F$6:$F$21,$I7)","v":{"v":79.9,"d":"NT$79.90"}},{"$f":"ROUND(K7,0)","v":{"v":80,"d":"NT$80"}},{"$f":"UPPER(J7) & \" 總計\"","v":"肉品 總計"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E7,清單[類別]),)),\"\")","v":"肉品"},{"$f":"SUMIFS(清單[總計],清單[類別],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":"農產品"},{"$f":"INDEX($F$6:$F$21,$I8)","v":{"v":44.875,"d":"NT$44.88"}},{"$f":"ROUND(K8,0)","v":{"v":45,"d":"NT$45"}},{"$f":"UPPER(J8) & \" 總計\"","v":"農產品 總計"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E8,清單[類別]),)),\"\")","v":"海鮮"},{"$f":"SUMIFS(清單[總計],清單[類別],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":"乳製品"},{"$f":"INDEX($F$6:$F$21,$I9)","v":{"v":36.84,"d":"NT$36.84"}},{"$f":"ROUND(K9,0)","v":{"v":37,"d":"NT$37"}},{"$f":"UPPER(J9) & \" 總計\"","v":"乳製品 總計"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E9,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E10)","v":0},1e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E10,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E11)","v":0},1.1E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E11,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E12)","v":0},1.2E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E12,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E13)","v":0},1.3e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E13,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E14)","v":0},1.4E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E14,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E15)","v":0},1.5E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E15,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E16)","v":0},1.6e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E16,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E17)","v":0},1.7E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E17,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E18)","v":0},1.8E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E18,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E19)","v":0},1.9e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E19,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E20)","v":0},2e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(清單[類別],MATCH(,COUNTIF($E$5:E20,清單[類別]),)),\"\")","v":""},{"$f":"SUMIFS(清單[總計],清單[類別],E21)","v":0},2.1e-05]