{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["요약","선물 목록"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"요약","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,2,1],[0,2,2,3],[3,1,3,2]]}
[null,"휴일","선물 관리표",null,"총 예산",{"v":500000,"d":"500,000.00 ₩"}]
[{"$nulls":4},"지출",{"$f":"IFERROR(SUMIFS(선물[비용],선물[구매],\"예\"),\"\")","v":{"v":283000,"d":"283,000.00 ₩"}}]
[{"$nulls":4},"남은 예산",{"$f":"IFERROR(총예산-F2,\"\")","v":{"v":217000,"d":"217,000.00 ₩"}}]
[null,"계획된 예산의 %가 100%를 초과하는 경우 예산을 조정할까요(예/아니요)?",null,"예"]
[null,"수신자","계획된 예산 퍼센트(%)","남은 할당 예산","계획된 선물 수","남은 선물"]
[null,"재석",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(예산_조정=\"예\",남은_할당_예산-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]]),(총예산*수신자[[#This Row],[계획된 예산 퍼센트(%)]])-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]])),\"\")","v":{"v":45000,"d":"45,000.00 ₩"}},3,{"$f":"IFERROR(수신자[[#This Row],[계획된 선물 수]]-COUNTIFS(선물[수신자],수신자[[#This Row],[수신자]]), \"\")","v":1}]
[null,"서현",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(예산_조정=\"예\",남은_할당_예산-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]]),(총예산*수신자[[#This Row],[계획된 예산 퍼센트(%)]])-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]])),\"\")","v":{"v":54000,"d":"54,000.00 ₩"}},3,{"$f":"IFERROR(수신자[[#This Row],[계획된 선물 수]]-COUNTIFS(선물[수신자],수신자[[#This Row],[수신자]]), \"\")","v":1}]
[null,"진식",{"v":0.2,"d":"20%"},{"$f":"IFERROR(IF(예산_조정=\"예\",남은_할당_예산-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]]),(총예산*수신자[[#This Row],[계획된 예산 퍼센트(%)]])-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]])),\"\")","v":{"v":11000,"d":"11,000.00 ₩"}},2,{"$f":"IFERROR(수신자[[#This Row],[계획된 선물 수]]-COUNTIFS(선물[수신자],수신자[[#This Row],[수신자]]), \"\")","v":1}]
[null,"유진",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(예산_조정=\"예\",남은_할당_예산-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]]),(총예산*수신자[[#This Row],[계획된 예산 퍼센트(%)]])-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]])),\"\")","v":{"v":-1000,"d":"-1,000.00 ₩"}},1,{"$f":"IFERROR(수신자[[#This Row],[계획된 선물 수]]-COUNTIFS(선물[수신자],수신자[[#This Row],[수신자]]), \"\")","v":0}]
[null,"기익",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(예산_조정=\"예\",남은_할당_예산-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]]),(총예산*수신자[[#This Row],[계획된 예산 퍼센트(%)]])-SUMIFS(선물[비용],선물[수신자],수신자[[#This Row],[수신자]])),\"\")","v":{"v":0,"d":"0.00 ₩"}},1,{"$f":"IFERROR(수신자[[#This Row],[계획된 선물 수]]-COUNTIFS(선물[수신자],수신자[[#This Row],[수신자]]), \"\")","v":0}]
[null,"합계",{"$f":"SUM(수신자[계획된 예산 퍼센트(%)])","v":{"v":1,"d":"100%"}},{"$f":"IFERROR(SUM(수신자[남은 할당 예산]),\"\")","v":{"v":109000,"d":"109,000.00 ₩"}},{"$f":"SUM(수신자[계획된 선물 수])","v":10},{"$f":"SUM(수신자[남은 선물])","v":3}]

{"sheet":"선물 목록","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[null,"휴일","선물 목록"]
[null,"수신자","선물","비용","구매","포장됨"]
[null,"서현","인형 집",{"v":36000,"d":"36,000.00 ₩"},"예","예"]
[null,"진식","자전거",{"v":89000,"d":"89,000.00 ₩"},"예"]
[null,"유진","스크랩북 재료",{"v":51000,"d":"51,000.00 ₩"},"예","예"]
[null,"재석","장난감 기차",{"v":48000,"d":"48,000.00 ₩"}]
[null,"재석","스웨터",{"v":57000,"d":"57,000.00 ₩"},"예"]
[null,"기익","선물 카드",{"v":50000,"d":"50,000.00 ₩"},"예","예"]
[null,"서현","원피스",{"v":60000,"d":"60,000.00 ₩"}]