{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["节日预算","清单条目","清单信息"],"not_rendered":{"charts":1,"images":3,"defined_names":13,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"节日预算","index":0,"n_rows":46,"n_cols":6,"rows_kept":46,"merged":[[0,1,1,3],[0,4,1,4],[2,1,2,2],[13,4,19,4]]}
[null,"节日购物预算",null,null,"此单元格中是灯串图案。","转至“清单条目”>"]
[{"$nulls":5},"转至“清单信息”>"]
[null,"总计",null,"簇状条形图显示此单元格中的费用分配和已花费金额。"]
[null,"费用分配",{"$f":"SUM(礼品数据[费用])","v":{"v":377,"d":"¥377.00"}}]
[null,"已花费金额",{"$f":"SUMIF(礼品数据[已购买],\"已购买\",礼品数据[费用])","v":{"v":233,"d":"¥233.00"}}]
[null,"差额",{"$f":"C4-C5","v":{"v":144,"d":"¥144.00"}}]
[null,"若要更新以下报表，请刷新它。",null,null,"通过“包装状态”筛选表格数据的切片器位于此单元格中。","通过“已购买”筛选表格数据的切片器位于此单元格中。"]
[null,"明细",null,"通过“收件人”筛选表格数据的切片器位于此单元格中。"]
[null,null,"求和项:费用"]
[null,"姓名 3",{"v":71,"d":"¥71.00"}]
[null,"拼图"]
[null,"已购买",{"v":16,"d":"¥16.00"}]
[null,"玩具火车"]
[null,"已购买",{"v":26,"d":"¥26.00"},null,"通过“送货状态”筛选表格数据的切片器位于此单元格中。","通过“礼品分类”筛选表格数据的切片器位于此单元格中。"]
[null,"自行车"]
[null,"未购买",{"v":29,"d":"¥29.00"}]
[]
[null,"姓名 2",{"v":59,"d":"¥59.00"}]
[null,"短袜"]
[null,"已购买",{"v":23,"d":"¥23.00"}]
[null,"玩具屋"]
[null,"已购买",{"v":36,"d":"¥36.00"}]
[]
[null,"姓名 4",{"v":44,"d":"¥44.00"}]
[null,"剪贴簿材料"]
[null,"已购买",{"v":14,"d":"¥14.00"}]
[null,"相册"]
[null,"已购买",{"v":30,"d":"¥30.00"}]
[]
[null,"姓名 5",{"v":118,"d":"¥118.00"}]
[null,"Xbox 游戏"]
[null,"已购买",{"v":49,"d":"¥49.00"}]
[null,"衬衫"]
[null,"未购买",{"v":37,"d":"¥37.00"}]
[null,"礼品卡"]
[null,"未购买",{"v":32,"d":"¥32.00"}]
[]
[null,"姓名 1",{"v":39,"d":"¥39.00"}]
[null,"运动衫"]
[null,"已购买",{"v":39,"d":"¥39.00"}]
[]
[null,"姓名 6",{"v":46,"d":"¥46.00"}]
[null,"短袜"]
[null,"未购买",{"v":46,"d":"¥46.00"}]
[]
[null,"Grand Total",{"v":377,"d":"¥377.00"}]

{"sheet":"清单条目","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,1,1,2],[0,3,1,6]]}
[null,"购物清单",null,"此单元格中是灯串图案。",{"$nulls":3},"转至“清单信息”>"]
[{"$nulls":7},"< 转至“节日预算”"]
[null,"收件人","礼品类别","礼品","费用","已购买","送货状态","包装状态"]
[null,"姓名 3","家庭礼品","玩具火车",{"v":26,"d":"¥26.00"},"已购买","已送达","已包装"]
[null,"姓名 2","常规礼品","短袜",{"v":23,"d":"¥23.00"},"已购买","已送达","已包装"]
[null,"姓名 3","常规礼品","拼图",{"v":16,"d":"¥16.00"},"已购买","已送达","未包装"]
[null,"姓名 4","常规礼品","剪贴簿材料",{"v":14,"d":"¥14.00"},"已购买","在途","未包装"]
[null,"姓名 5","常规礼品","Xbox 游戏",{"v":49,"d":"¥49.00"},"已购买","在途","未包装"]
[null,"姓名 5","常规礼品","衬衫",{"v":37,"d":"¥37.00"},"未购买","在途","未包装"]
[null,"姓名 1","常规礼品","运动衫",{"v":39,"d":"¥39.00"},"已购买","在途","未包装"]
[null,"姓名 2","常规礼品","玩具屋",{"v":36,"d":"¥36.00"},"已购买","已送达","未包装"]
[null,"姓名 3","常规礼品","自行车",{"v":29,"d":"¥29.00"},"未购买"]
[null,"姓名 4","常规礼品","相册",{"v":30,"d":"¥30.00"},"已购买","已送达"]
[null,"姓名 5","常规礼品","礼品卡",{"v":32,"d":"¥32.00"},"未购买"]
[null,"姓名 6","常规礼品","短袜",{"v":46,"d":"¥46.00"},"未购买"]

{"sheet":"清单信息","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,1,1,1],[0,2,1,3]]}
[null,"清单信息","此单元格中是灯串图案。",null,"< 转至“清单条目”"]
[{"$nulls":4},"< 转至“节日预算”"]
[null,"人员",null,"礼品类别"]
[null,"姓名 1",null,"圣诞节礼品"]
[null,"姓名 2",null,"常规礼品"]
[null,"姓名 3",null,"配偶礼品"]
[null,"姓名 4",null,"家庭礼品"]
[null,"姓名 5",null,"特殊礼品"]
[null,"姓名 6"]