{"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":"¥2.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":5.98,"d":"¥5.98"}},null,null,{"$f":"計算!M8","v":"農産物の合計"}]
[{"$nulls":3},"リンゴ","果樹園","農産物",3,"グラム",{"v":1.99,"d":"¥1.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":5.97,"d":"¥5.97"}},"クーポンあり",null,{"$f":"計算!L8","v":45}]
[{"$nulls":3},"バナナ","食料品店","農産物",1,"房",{"v":3.99,"d":"¥3.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":3.99,"d":"¥3.99"}}]
[{"$nulls":3},"レタス","市場","農産物",2,"玉",{"v":2.29,"d":"¥2.29"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":4.58,"d":"¥4.58"}},null,null,{"$f":"計算!M7","v":"肉類の合計"}]
[{"$nulls":3},"トマト","市場","農産物",4,"グラム",{"v":3.49,"d":"¥3.49"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":13.96,"d":"¥13.96"}},null,null,{"$f":"計算!L7","v":80}]
[{"$nulls":3},"カボチャ","市場","農産物",2,"個",{"v":1.5,"d":"¥1.50"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":3,"d":"¥3.00"}}]
[{"$nulls":3},"セロリ","食料品店","農産物",2,"房",{"v":1.99,"d":"¥1.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":3.98,"d":"¥3.98"}},null,null,{"$f":"計算!M6","v":"魚介類の合計"}]
[{"$nulls":3},"きゅうり","市場","農産物",1,"グラム",{"v":2.29,"d":"¥2.29"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":2.29,"d":"¥2.29"}},null,null,{"$f":"計算!L6","v":109}]
[{"$nulls":3},"マッシュルーム","食料品店","農産物",0.5,"グラム",{"v":2.25,"d":"¥2.25"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":1.125,"d":"¥1.13"}},"大きなポットベラ"]
[{"$nulls":3},"牛乳 ","宅配","乳製品",2,"リットル",{"v":3.99,"d":"¥3.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":7.98,"d":"¥7.98"}},null,null,{"$f":"計算!M3","v":"その他の合計"}]
[{"$nulls":3},"チーズ","宅配","乳製品",1,"グラム",{"v":9.99,"d":"¥9.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":9.99,"d":"¥9.99"}},"チーズ詰め合わせ",null,{"$f":"計算!L3","v":0}]
[{"$nulls":3},"卵","宅配","乳製品",2,"ケース",{"v":3.5,"d":"¥3.50"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":7,"d":"¥7.00"}}]
[{"$nulls":3},"カッテージ チーズ","宅配","乳製品",1,"500 g",{"v":3.89,"d":"¥3.89"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":3.89,"d":"¥3.89"}},null,null,{"$f":"計算!M4","v":"食料品の合計"}]
[{"$nulls":3},"サワー クリーム","宅配","乳製品",1,"250 g",{"v":2.99,"d":"¥2.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":2.99,"d":"¥2.99"}},null,null,{"$f":"食料品合計","v":271}]
[{"$nulls":3},"ヨーグルト","食料品店","乳製品",1,"500 g",{"v":4.99,"d":"¥4.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":4.99,"d":"¥4.99"}},"蜂蜜入りギリシャ ヨーグルト"]
[{"$nulls":3},"牛肉","市場","肉類",10,"グラム",{"v":7.99,"d":"¥7.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":79.9,"d":"¥79.90"}},"ベーコン巻きのヒレ肉"]
[{"$nulls":3},"サーモン (天然)","魚市場","魚介類",6,"グラム",{"v":8.99,"d":"¥8.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":53.94,"d":"¥53.94"}}]
[{"$nulls":3},"アラスカ キング クラブの足","魚市場","魚介類",5,"グラム",{"v":10.99,"d":"¥10.99"},{"$f":"IFERROR(リスト[数量]*リスト[単価],\"\")","v":{"v":54.95,"d":"¥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":"¥0.00"}},{"$f":"ROUND(K3,0)","v":{"v":0,"d":"¥0"}},"その他の合計"]
[{"$nulls":11},{"$f":"ROUNDUP(SUM(リスト[合計]),0)","v":{"v":271,"d":"¥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":"¥108.89"}},{"$f":"ROUND(K6,0)","v":{"v":109,"d":"¥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":"¥79.90"}},{"$f":"ROUND(K7,0)","v":{"v":80,"d":"¥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":"¥44.88"}},{"$f":"ROUND(K8,0)","v":{"v":45,"d":"¥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":"¥36.84"}},{"$f":"ROUND(K9,0)","v":{"v":37,"d":"¥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]