{"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":5000,"d":"¥5,000.00"}]
[{"$nulls":4},"已花费",{"$f":"IFERROR(SUMIFS(礼品[成本],礼品[已购买],\"是\"),\"\")","v":{"v":2830,"d":"¥2,830.00"}}]
[{"$nulls":4},"剩余预算",{"$f":"IFERROR(总预算-F2,\"\")","v":{"v":2170,"d":"¥2,170.00"}}]
[null,"如果计划的预算百分比超出 100%，则调整预算（是/否）？",null,"是"]
[null,"收礼者","计划的预算百分比","分配的剩余资金","计划礼品数","剩余礼品数"]
[null,"米申",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(调整_预算=\"是\",已分配_资金_剩余-SUMIFS(礼品[成本],礼品[收礼者],收礼者[[#This Row],[收礼者]]),(总预算*收礼者[[#This Row],[计划的预算百分比]])-SUMIFS(礼品[成本],礼品[收礼者],收礼者[[#This Row],[收礼者]])),\"\")","v":{"v":450,"d":"¥450.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":540,"d":"¥540.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":110,"d":"¥110.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":-10,"d":"¥-10.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":1090,"d":"¥1,090.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":360,"d":"¥360.00"},"是","是"]
[null,"黄琏","自行车",{"v":890,"d":"¥890.00"},"是"]
[null,"柏隼","剪贴簿材料",{"v":510,"d":"¥510.00"},"是","是"]
[null,"米申","玩具火车",{"v":480,"d":"¥480.00"}]
[null,"米申","运动衫",{"v":570,"d":"¥570.00"},"是"]
[null,"康霓","礼品卡",{"v":500,"d":"¥500.00"},"是","是"]
[null,"陶湘","连衣裙",{"v":600,"d":"¥600.00"}]