{"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":500,"d":"500.00 ¥"}]
[{"$nulls":4},"支払済",{"$f":"IFERROR(SUMIFS(ギフト[コスト],ギフト[購入済み],\"はい\"),\"\")","v":{"v":283,"d":"283.00 ¥"}}]
[{"$nulls":4},"予算残額",{"$f":"IFERROR(TotalBudget-F2,\"\")","v":{"v":217,"d":"217.00 ¥"}}]
[null,"予定予算に対する割合が 100% を超えたら予算を調整しますか (はい/いいえ)?",null,"はい"]
[null,"贈り先","予定予算に対する割合","残り予算額","予定ギフト個数","残りギフト数"]
[null,"Adam",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Adjust_Budget=\"はい\",Allocated_Money_Remaining-SUMIFS(ギフト[コスト],ギフト[贈り先],贈り先[[#This Row],[贈り先]]),(TotalBudget*贈り先[[#This Row],[予定予算に対する割合]])-SUMIFS(ギフト[コスト],ギフト[贈り先],贈り先[[#This Row],[贈り先]])),\"\")","v":{"v":45,"d":"45.00 ¥"}},3,{"$f":"IFERROR(贈り先[[#This Row],[予定ギフト個数]]-COUNTIFS(ギフト[贈り先],贈り先[[#This Row],[贈り先]]), \"\")","v":1}]
[null,"Jenny",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Adjust_Budget=\"はい\",Allocated_Money_Remaining-SUMIFS(ギフト[コスト],ギフト[贈り先],贈り先[[#This Row],[贈り先]]),(TotalBudget*贈り先[[#This Row],[予定予算に対する割合]])-SUMIFS(ギフト[コスト],ギフト[贈り先],贈り先[[#This Row],[贈り先]])),\"\")","v":{"v":54,"d":"54.00 ¥"}},3,{"$f":"IFERROR(贈り先[[#This Row],[予定ギフト個数]]-COUNTIFS(ギフト[贈り先],贈り先[[#This Row],[贈り先]]), \"\")","v":1}]
[null,"Brian",{"v":0.2,"d":"20%"},{"$f":"IFERROR(IF(Adjust_Budget=\"はい\",Allocated_Money_Remaining-SUMIFS(ギフト[コスト],ギフト[贈り先],贈り先[[#This Row],[贈り先]]),(TotalBudget*贈り先[[#This Row],[予定予算に対する割合]])-SUMIFS(ギフト[コスト],ギフト[贈り先],贈り先[[#This Row],[贈り先]])),\"\")","v":{"v":11,"d":"11.00 ¥"}},2,{"$f":"IFERROR(贈り先[[#This Row],[予定ギフト個数]]-COUNTIFS(ギフト[贈り先],贈り先[[#This Row],[贈り先]]), \"\")","v":1}]
[null,"Suzanne",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Adjust_Budget=\"はい\",Allocated_Money_Remaining-SUMIFS(ギフト[コスト],ギフト[贈り先],贈り先[[#This Row],[贈り先]]),(TotalBudget*贈り先[[#This Row],[予定予算に対する割合]])-SUMIFS(ギフト[コスト],ギフト[贈り先],贈り先[[#This Row],[贈り先]])),\"\")","v":{"v":-1,"d":"-1.00 ¥"}},1,{"$f":"IFERROR(贈り先[[#This Row],[予定ギフト個数]]-COUNTIFS(ギフト[贈り先],贈り先[[#This Row],[贈り先]]), \"\")","v":0}]
[null,"Marty",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Adjust_Budget=\"はい\",Allocated_Money_Remaining-SUMIFS(ギフト[コスト],ギフト[贈り先],贈り先[[#This Row],[贈り先]]),(TotalBudget*贈り先[[#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":109,"d":"109.00 ¥"}},{"$f":"SUM(贈り先[予定ギフト個数])","v":10},{"$f":"SUM(贈り先[残りギフト数])","v":3}]

{"sheet":"ギフト リスト","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[null,"休日","ギフト リスト"]
[null,"贈り先","ギフト","コスト","購入済み","ラッピング済み"]
[null,"Jenny","ドール ハウス",{"v":36,"d":"36.00 ¥"},"はい","はい"]
[null,"Brian","自転車",{"v":89,"d":"89.00 ¥"},"はい"]
[null,"Suzanne","スクラップブック資料",{"v":51,"d":"51.00 ¥"},"はい","はい"]
[null,"Adam","おもちゃの電車",{"v":48,"d":"48.00 ¥"}]
[null,"Adam","セーター",{"v":57,"d":"57.00 ¥"},"はい"]
[null,"Marty","ギフト カード",{"v":50,"d":"50.00 ¥"},"はい","はい"]
[null,"Jenny","ドレス",{"v":60,"d":"60.00 ¥"}]