{"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":42,"n_cols":6,"rows_kept":42,"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":"NT$377.00"}}]
[null,"目前支出",{"$f":"SUMIF(禮物資料[已購買],\"已購買\",禮物資料[費用])","v":{"v":233,"d":"NT$233.00"}}]
[null,"差額",{"$f":"C4-C5","v":{"v":144,"d":"NT$144.00"}}]
[null,"若要更新下方報表，請重新整理。",null,null,"此儲存格為依據 [包裝狀態] 來篩選表格資料的交叉分析篩選器。","此儲存格為依據 [已購買] 來篩選表格資料的交叉分析篩選器。"]
[null,"明細",null,"此儲存格為依據 [對象] 來篩選表格資料的交叉分析篩選器。"]
[null,null,"加總 - 費用"]
[null,"姓名 1",{"v":39,"d":"NT$39.00"}]
[null,"已購買"]
[null,"毛衣",{"v":39,"d":"NT$39.00"}]
[]
[null,"姓名 2",{"v":59,"d":"NT$59.00"},null,"此儲存格為依據 [配送狀態] 來篩選表格資料的交叉分析篩選器。","此儲存格為依據 [禮物類別] 來篩選表格資料的交叉分析篩選器。"]
[null,"已購買"]
[null,"娃娃屋",{"v":36,"d":"NT$36.00"}]
[null,"襪子",{"v":23,"d":"NT$23.00"}]
[]
[null,"姓名 3",{"v":71,"d":"NT$71.00"}]
[null,"已購買"]
[null,"玩具火車",{"v":26,"d":"NT$26.00"}]
[null,"拼圖",{"v":16,"d":"NT$16.00"}]
[null,"未購買"]
[null,"腳踏車",{"v":29,"d":"NT$29.00"}]
[]
[null,"姓名 4",{"v":44,"d":"NT$44.00"}]
[null,"已購買"]
[null,"手作拼貼材料",{"v":14,"d":"NT$14.00"}]
[null,"相簿",{"v":30,"d":"NT$30.00"}]
[]
[null,"姓名 5",{"v":118,"d":"NT$118.00"}]
[null,"已購買"]
[null,"Xbox 遊戲",{"v":49,"d":"NT$49.00"}]
[null,"未購買"]
[null,"T 恤",{"v":37,"d":"NT$37.00"}]
[null,"禮品卡",{"v":32,"d":"NT$32.00"}]
[]
[null,"姓名 6",{"v":46,"d":"NT$46.00"}]
[null,"未購買"]
[null,"襪子",{"v":46,"d":"NT$46.00"}]
[]
[null,"總計",{"v":377,"d":"NT$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":"NT$26.00"},"已購買","已送達","已包裝"]
[null,"姓名 2","一般禮物","襪子",{"v":23,"d":"NT$23.00"},"已購買","已送達","已包裝"]
[null,"姓名 3","一般禮物","拼圖",{"v":16,"d":"NT$16.00"},"已購買","已送達","未包裝"]
[null,"姓名 4","一般禮物","手作拼貼材料",{"v":14,"d":"NT$14.00"},"已購買","運送中","未包裝"]
[null,"姓名 5","一般禮物","Xbox 遊戲",{"v":49,"d":"NT$49.00"},"已購買","運送中","未包裝"]
[null,"姓名 5","一般禮物","T 恤",{"v":37,"d":"NT$37.00"},"未購買","運送中","未包裝"]
[null,"姓名 1","一般禮物","毛衣",{"v":39,"d":"NT$39.00"},"已購買","運送中","未包裝"]
[null,"姓名 2","一般禮物","娃娃屋",{"v":36,"d":"NT$36.00"},"已購買","已送達","未包裝"]
[null,"姓名 3","一般禮物","腳踏車",{"v":29,"d":"NT$29.00"},"未購買"]
[null,"姓名 4","一般禮物","相簿",{"v":30,"d":"NT$30.00"},"已購買","已送達"]
[null,"姓名 5","一般禮物","禮品卡",{"v":32,"d":"NT$32.00"},"未購買"]
[null,"姓名 6","一般禮物","襪子",{"v":46,"d":"NT$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"]