{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["雜貨清單","計算"],"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"雜貨清單","index":0,"n_rows":22,"n_cols":11,"rows_kept":22}
[]
[null," 雜貨清單"]
[]
[null,null," ","項目","商店","類別","數量","單位","單價","合計","註解"]
[null,null,{"$f":"\"c\"","v":"c"},"柳橙","雜貨","農產品",0.9,"公斤",{"v":89.7,"d":"NT$89.70"},{"v":80.73,"d":"NT$80.73"}]
[null,null,{"$f":"\"c\"","v":"c"},"蘋果","果園","農產品",1.35,"公斤",{"v":59.7,"d":"NT$59.70"},{"v":80.6,"d":"NT$80.60"},"有優待券"]
[null,null,{"$f":"\"c\"","v":"c"},"香蕉","雜貨","農產品",1,"串",{"v":119.7,"d":"NT$119.70"},{"v":119.7,"d":"NT$119.70"}]
[null,null,"c","萵苣","市場","農產品",2,"顆",{"v":68.7,"d":"NT$68.70"},{"v":137.4,"d":"NT$137.40"}]
[null,null,"c","蕃茄","市場","農產品",1.8,"公斤",{"v":104.7,"d":"NT$104.70"},{"v":188.46,"d":"NT$188.46"}]
[null,null,"c","南瓜","市場","農產品",2,"個",{"v":45,"d":"NT$45.00"},{"v":90,"d":"NT$90.00"}]
[null,null,"c","芹菜","雜貨","農產品",2,"串",{"v":59.7,"d":"NT$59.70"},{"v":119.4,"d":"NT$119.40"}]
[null,null,"c","黃瓜","市場","農產品",0.45,"公斤",{"v":68.7,"d":"NT$68.70"},{"v":30.92,"d":"NT$30.92"}]
[null,null,"c","香菇","雜貨","農產品",0.23,"公斤",{"v":67.5,"d":"NT$67.50"},{"v":15.53,"d":"NT$15.53"},"大波特貝勒菇"]
[null,null,"c","牛乳 ","宅配","乳品",7.4,"公升",{"v":119.7,"d":"NT$119.70"},{"v":885.78,"d":"NT$885.78"}]
[null,null,"c","起司","宅配","乳品",0.45,"公斤",{"v":299.7,"d":"NT$299.70"},{"v":134.87,"d":"NT$134.87"},"多種塊狀起司"]
[null,null,"c","雞蛋","宅配","乳品",2,"打",{"v":105,"d":"NT$105.00"},{"v":210,"d":"NT$210.00"}]
[null,null,"c","乾酪","宅配","乳品",1,"452.8 克",{"v":116.7,"d":"NT$116.70"},{"v":116.7,"d":"NT$116.70"}]
[null,null,"c","酸奶油","宅配","乳品",1,"226.4 克",{"v":89.7,"d":"NT$89.70"},{"v":89.7,"d":"NT$89.70"}]
[null,null,"c","優格","雜貨","乳品",1,"452.8 克",{"v":149.7,"d":"NT$149.70"},{"v":149.7,"d":"NT$149.70"},"希臘優格佐蜂蜜"]
[null,null,"c","牛肉","市場","肉類",4.5,"公斤",{"v":239.7,"d":"NT$239.70"},{"v":1078.65,"d":"NT$1,078.65"},"培根捲菲力牛排"]
[null,null,"c","野生鮭魚","魚市","海鮮",2.7,"公斤",{"v":269.7,"d":"NT$269.70"},{"v":728.19,"d":"NT$728.19"}]
[null,null,"c","阿拉斯加帝王蟹腳","魚市","海鮮",2.3,"公斤",{"v":329.7,"d":"NT$329.70"},{"v":741.83,"d":"NT$741.83"}]

{"sheet":"計算","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"hidden":true}
["***  要保持隱藏的工作表 ***"]
[]
[{"$nulls":10},{"$f":"SUM(List[合計])-SUM(K6:K9)","v":{"v":0,"d":"NT$0.00"}},{"$f":"ROUND(K3,0)","v":{"v":0,"d":"NT$0.00"}},"其他總計"]
[{"$nulls":11},{"$f":"ROUNDUP(SUM(List[合計]),0)","v":{"v":4999,"d":"NT$4,999.00"}},"雜貨總計"]
[]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E5,List[類別]),)),\"\")","v":"農產品"},{"$f":"SUMIFS(List[合計],List[類別],E6)","v":862.7399999999999},{"$f":"F6+ROW()/1000000","v":862.7400059999999},{"$f":"LARGE($G$6:$G$21,1)","v":1586.7500070000003},{"$f":"MATCH(H6,$G$6:$G$21,0)","v":2},{"$f":"INDEX($E$6:$E$21,$I6)","v":"乳品"},{"$f":"INDEX($F$6:$F$21,$I6)","v":{"v":1586.7500000000002,"d":"NT$1,586.75"}},{"$f":"ROUND(K6,0)","v":{"v":1587,"d":"NT$1,587.00"}},{"$f":"UPPER(J6) & \"總計\"","v":"乳品總計"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E6,List[類別]),)),\"\")","v":"乳品"},{"$f":"SUMIFS(List[合計],List[類別],E7)","v":1586.7500000000002},{"$f":"F7+ROW()/1000000","v":1586.7500070000003},{"$f":"LARGE($G$6:$G$21,2)","v":1470.020009},{"$f":"MATCH(H7,$G$6:$G$21,0)","v":4},{"$f":"INDEX($E$6:$E$21,$I7)","v":"海鮮"},{"$f":"INDEX($F$6:$F$21,$I7)","v":{"v":1470.02,"d":"NT$1,470.02"}},{"$f":"ROUND(K7,0)","v":{"v":1470,"d":"NT$1,470.00"}},{"$f":"UPPER(J7) & \"總計\"","v":"海鮮總計"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E7,List[類別]),)),\"\")","v":"肉類"},{"$f":"SUMIFS(List[合計],List[類別],E8)","v":1078.65},1078.650008,{"$f":"LARGE($G$6:$G$21,3)","v":1078.650008},{"$f":"MATCH(H8,$G$6:$G$21,0)","v":3},{"$f":"INDEX($E$6:$E$21,$I8)","v":"肉類"},{"$f":"INDEX($F$6:$F$21,$I8)","v":{"v":1078.65,"d":"NT$1,078.65"}},{"$f":"ROUND(K8,0)","v":{"v":1079,"d":"NT$1,079.00"}},{"$f":"UPPER(J8) & \"總計\"","v":"肉類總計"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E8,List[類別]),)),\"\")","v":"海鮮"},{"$f":"SUMIFS(List[合計],List[類別],E9)","v":1470.02},1470.020009,{"$f":"LARGE($G$6:$G$21,4)","v":862.7400059999999},{"$f":"MATCH(H9,$G$6:$G$21,0)","v":1},{"$f":"INDEX($E$6:$E$21,$I9)","v":"農產品"},{"$f":"INDEX($F$6:$F$21,$I9)","v":{"v":862.7399999999999,"d":"NT$862.74"}},{"$f":"ROUND(K9,0)","v":{"v":863,"d":"NT$863.00"}},{"$f":"UPPER(J9) & \"總計\"","v":"農產品總計"}]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E9,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E10)","v":0},1e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E10,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E11)","v":0},1.1E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E11,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E12)","v":0},1.2E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E12,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E13)","v":0},1.3e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E13,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E14)","v":0},1.4E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E14,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E15)","v":0},1.5E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E15,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E16)","v":0},1.6e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E16,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E17)","v":0},1.7E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E17,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E18)","v":0},1.8E-5]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E18,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E19)","v":0},1.9e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E19,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E20)","v":0},2e-05]
[{"$nulls":4},{"$f":"IFERROR(INDEX(List[類別],MATCH(,COUNTIF($E$5:E20,List[類別]),)),\"\")","v":""},{"$f":"SUMIFS(List[合計],List[類別],E21)","v":0},2.1e-05]