{"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],[2,3,5,5],[6,4,12,4],[6,5,12,5],[7,3,22,3],[13,4,19,4],[13,5,20,5]]}
[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":26,"d":"¥26.00"}]
[null,"パズル",{"v":16,"d":"¥16.00"}]
[null,"未購入",null,null,"このセルには、配達の状態でテーブル データをフィルター処理するスライサーが表示されます。","このセルには、ギフトのカテゴリでテーブル データをフィルター処理するスライサーが表示されます。"]
[null,"自転車",{"v":29,"d":"¥29.00"}]
[]
[null,"名前 2",{"v":59,"d":"¥59.00"}]
[null,"購入済み"]
[null,"靴下",{"v":23,"d":"¥23.00"}]
[null,"ドール ハウス",{"v":36,"d":"¥36.00"}]
[]
[null,"名前 4",{"v":44,"d":"¥44.00"}]
[null,"購入済み"]
[null,"スクラップブックの道具",{"v":14,"d":"¥14.00"}]
[null,"フォト アルバム",{"v":30,"d":"¥30.00"}]
[]
[null,"名前 5",{"v":118,"d":"¥118.00"}]
[null,"購入済み"]
[null,"Xbox ゲーム",{"v":49,"d":"¥49.00"}]
[null,"未購入"]
[null,"シャツ",{"v":37,"d":"¥37.00"}]
[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,"総計",{"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"]