{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["禮物清單"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"禮物清單","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"merged":[[1,0,3,3],[12,1,12,5]]}
[]
["節慶 禮物清單",{"$nulls":3},"總預算",{"v":15000,"d":"NT$15,000.00"}]
[{"$nulls":4},"已花費",{"$f":"F2-F4","v":{"v":11730,"d":"NT$11,730.00"}}]
[{"$nulls":4},"剩餘",{"$f":"SUM(接收者[剩餘金額])","v":{"v":3270,"d":"NT$3,270.00"}}]
[]
[null,"對象","預定的預算百分比","剩餘金額","預定的禮物數量","剩餘的禮物"]
[null,"安主",{"v":0.3,"d":"30%"},{"$f":"TotalBudget*接收者[[#This Row],[預定的預算百分比]]-SUMIFS(禮物[成本],禮物[對象],接收者[[#This Row],[對象]])","v":{"v":1350,"d":"NT$1,350.00"}},3,{"$f":"接收者[[#This Row],[預定的禮物數量]]-COUNTIFS(禮物[對象],接收者[[#This Row],[對象]])","v":1}]
[null,"珍菲",{"v":0.3,"d":"30%"},{"$f":"TotalBudget*接收者[[#This Row],[預定的預算百分比]]-SUMIFS(禮物[成本],禮物[對象],接收者[[#This Row],[對象]])","v":{"v":1620,"d":"NT$1,620.00"}},3,{"$f":"接收者[[#This Row],[預定的禮物數量]]-COUNTIFS(禮物[對象],接收者[[#This Row],[對象]])","v":1}]
[null,"建宏",{"v":0.2,"d":"20%"},{"$f":"TotalBudget*接收者[[#This Row],[預定的預算百分比]]-SUMIFS(禮物[成本],禮物[對象],接收者[[#This Row],[對象]])","v":{"v":330,"d":"NT$330.00"}},2,{"$f":"接收者[[#This Row],[預定的禮物數量]]-COUNTIFS(禮物[對象],接收者[[#This Row],[對象]])","v":1}]
[null,"甦瓊",{"v":0.1,"d":"10%"},{"$f":"TotalBudget*接收者[[#This Row],[預定的預算百分比]]-SUMIFS(禮物[成本],禮物[對象],接收者[[#This Row],[對象]])","v":{"v":-30,"d":"-NT$30.00"}},1,{"$f":"接收者[[#This Row],[預定的禮物數量]]-COUNTIFS(禮物[對象],接收者[[#This Row],[對象]])","v":0}]
[null,"馬汀",{"v":0.1,"d":"10%"},{"$f":"TotalBudget*接收者[[#This Row],[預定的預算百分比]]-SUMIFS(禮物[成本],禮物[對象],接收者[[#This Row],[對象]])","v":{"v":0,"d":"NT$0.00"}},1,{"$f":"接收者[[#This Row],[預定的禮物數量]]-COUNTIFS(禮物[對象],接收者[[#This Row],[對象]])","v":0}]
[null,"合計",{"$f":"SUM(接收者[預定的預算百分比])","v":{"v":1,"d":"100%"}},{"$f":"SUM(接收者[剩餘金額])","v":{"v":3270,"d":"NT$3,270.00"}},{"$f":"SUM(接收者[預定的禮物數量])","v":10},{"$f":"SUM(接收者[剩餘的禮物])","v":3}]
[]
[null,"對象","禮物","成本","已購買","已包裝"]
[null,"珍菲","娃娃屋",{"v":1080,"d":"NT$1,080.00"},"是","是"]
[null,"建宏","腳踏車",{"v":2670,"d":"NT$2,670.00"},"是"]
[null,"甦瓊","剪貼簿材料",{"v":1530,"d":"NT$1,530.00"},"是","是"]
[null,"安主","玩具火車",{"v":1440,"d":"NT$1,440.00"}]
[null,"安主","毛衣",{"v":1710,"d":"NT$1,710.00"},"是"]
[null,"馬汀","禮物卡",{"v":1500,"d":"NT$1,500.00"},"是","是"]
[null,"珍菲","洋裝",{"v":1800,"d":"NT$1,800.00"}]