{"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,"1개",{"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,"12개 묶음",{"v":3.5,"d":"₩3.50"},{"$f":"IFERROR(목록[수량]*목록[단가],\"\")","v":{"v":7,"d":"₩7.00"}}]
[{"$nulls":3},"코티지 치즈","배달","유제품",1,"16온스",{"v":3.89,"d":"₩3.89"},{"$f":"IFERROR(목록[수량]*목록[단가],\"\")","v":{"v":3.89,"d":"₩3.89"}},null,null,{"$f":"계산!M4","v":"식료품 합계"}]
[{"$nulls":3},"사워크림","배달","유제품",1,"8온스",{"v":2.99,"d":"₩2.99"},{"$f":"IFERROR(목록[수량]*목록[단가],\"\")","v":{"v":2.99,"d":"₩2.99"}},null,null,{"$f":"식료품합계","v":271}]
[{"$nulls":3},"요구르트","식료품","유제품",1,"16온스",{"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]