{"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]]}
[null,"假日","禮物追蹤工具",null,"總預算",{"v":500,"d":"HK$500.00"}]
[{"$nulls":4},"已花費",{"$f":"IFERROR(SUMIFS(禮物[費用],禮物[已購買],\"是\"),\"\")","v":{"v":283,"d":"HK$283.00"}}]
[{"$nulls":4},"剩餘預算",{"$f":"IFERROR(總預算-F2,\"\")","v":{"v":217,"d":"HK$217.00"}}]
[null,"如果預定的預算百分比超過 100% 的話是否要調整預算 (是/否)?",null,"是"]
[null,"對象","預定的預算百分比","剩餘金額","預定的禮物數量","剩餘的禮物"]
[null,"柏友",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(調整_預算=\"是\",剩餘金額-SUMIFS(禮物[費用],禮物[對象],收件者[[#This Row],[對象]]),(總預算*收件者[[#This Row],[預定的預算百分比]])-SUMIFS(禮物[費用],禮物[對象],收件者[[#This Row],[對象]])),\"\")","v":{"v":45,"d":"HK$45.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":54,"d":"HK$54.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":11,"d":"HK$11.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":-1,"d":"-HK$1.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":"HK$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":"NT$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,"珮佳","娃娃屋",{"v":36,"d":"HK$36.00"},"是","是"]
[null,"棟材","腳踏車",{"v":89,"d":"HK$89.00"},"是"]
[null,"舒慧","手作拼貼材料",{"v":51,"d":"HK$51.00"},"是","是"]
[null,"柏友","玩具火車",{"v":48,"d":"HK$48.00"}]
[null,"柏友","毛衣",{"v":57,"d":"HK$57.00"},"是"]
[null,"庭宇","禮品卡",{"v":50,"d":"HK$50.00"},"是","是"]
[null,"珮佳","洋裝",{"v":60,"d":"HK$60.00"}]