{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["開始","休日の予算計画シート"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"このテンプレートの使用方法"]
[null,"この休日の予算計画シートを使用して、支出を管理します。"]
[null,"開始するには、各カテゴリ テーブルに予算と実際の費用を入力します。"]
[null,"休日の予算、実際に費やされた合計金額、および差額が自動的に計算されます。"]

{"sheet":"休日の予算計画シート","index":1,"n_rows":36,"n_cols":14,"rows_kept":36,"merged":[[0,2,5,7],[2,10,2,11],[8,2,8,5],[8,10,8,13],[18,2,18,5],[18,10,18,13],[29,2,29,5],[29,10,29,13]]}
[null,null,"休日の予算\n計画シート"]
[]
[{"$nulls":10},"休日の予算",null,null,{"$f":"SUM(贈り物[予算],パッケージ[予算],(出張費[予算],(食事[予算],(エンターテインメント[予算],雑費[予算]))))","v":{"v":750,"d":"¥750.00"}}]
[{"$nulls":10},"実績の支出",null,null,{"$f":"SUM((贈り物[実績],(パッケージ[実際],(出張費[実際],(食事[実績],(エンターテインメント[実際],(雑費[実際])))))))","v":{"v":820,"d":"¥820.00"}}]
[]
[{"$nulls":10},"差額 (予算内/予算外)",null,null,{"$f":"SUM(N3-N4)","v":{"v":-70,"d":"(¥70.00)"}}]
[]
[]
[null,null,"ギフト",{"$nulls":7},"休日の食事"]
[null,null,"項目","予算","実績","差額",{"$nulls":4},"項目","予算","実績","差額"]
[null,null,"家族",{"v":500,"d":"¥500.00"},{"v":495,"d":"¥495.00"},{"$f":"贈り物[[#This Row],[予算]]-贈り物[[#This Row],[実績]]","v":{"v":5,"d":"¥5.00"}},{"$nulls":4},"食料品",null,null,{"$f":"食事[[#This Row],[予算]]-食事[[#This Row],[実績]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"友だち",{"v":250,"d":"¥250.00"},{"v":325,"d":"¥325.00"},{"$f":"贈り物[[#This Row],[予算]]-贈り物[[#This Row],[実績]]","v":{"v":-75,"d":"¥-75.00"}},{"$nulls":4},"酒類",null,null,{"$f":"食事[[#This Row],[予算]]-食事[[#This Row],[実績]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"同僚",null,null,{"$f":"贈り物[[#This Row],[予算]]-贈り物[[#This Row],[実績]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"装飾",null,null,{"$f":"食事[[#This Row],[予算]]-食事[[#This Row],[実績]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"教師、乳母、ベビーシッターなど",null,null,{"$f":"贈り物[[#This Row],[予算]]-贈り物[[#This Row],[実績]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"その他 (行を追加するには、この行の最後の列で Tab キーを押す)",null,null,{"$f":"食事[[#This Row],[予算]]-食事[[#This Row],[実績]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"寄付金",null,null,{"$f":"贈り物[[#This Row],[予算]]-贈り物[[#This Row],[実績]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":7},{"$f":"食事[[#This Row],[予算]]-食事[[#This Row],[実績]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"その他 (行を追加するには、この行の最後の列で Tab キーを押す)",null,null,{"$f":"贈り物[[#This Row],[予算]]-贈り物[[#This Row],[実績]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,贈り物[予算])","v":{"v":750,"d":"¥750.00"}},{"$f":"SUBTOTAL(109,贈り物[実績])","v":{"v":820,"d":"¥820.00"}},{"$f":"SUBTOTAL(109,贈り物[差額])","v":{"v":-70,"d":"¥-70.00"}},{"$nulls":4},"集計",{"$f":"SUBTOTAL(109,食事[予算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,食事[実績])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,食事[差額])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,null,"パッケージ",{"$nulls":7},"エンターテインメント"]
[null,null,"項目","予算","実際","差額",{"$nulls":4},"項目","予算","実際","差額"]
[null,null,"贈り物包装",null,null,{"$f":"パッケージ[[#This Row],[予算]]-パッケージ[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"パーティのヘルパー (バーテンダー、ケータリング業者、清掃業者等)",null,null,{"$f":"エンターテインメント[[#This Row],[予算]]-エンターテインメント[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"タグ",null,null,{"$f":"パッケージ[[#This Row],[予算]]-パッケージ[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"装飾",null,null,{"$f":"エンターテインメント[[#This Row],[予算]]-エンターテインメント[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"消耗品 (リボン、テープなど)",null,null,{"$f":"パッケージ[[#This Row],[予算]]-パッケージ[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"食べ物と飲み物",null,null,{"$f":"エンターテインメント[[#This Row],[予算]]-エンターテインメント[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"ボックス",null,null,{"$f":"パッケージ[[#This Row],[予算]]-パッケージ[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"衣料品",null,null,{"$f":"エンターテインメント[[#This Row],[予算]]-エンターテインメント[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"送料",null,null,{"$f":"パッケージ[[#This Row],[予算]]-パッケージ[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"チケット",null,null,{"$f":"エンターテインメント[[#This Row],[予算]]-エンターテインメント[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"その他 (行を追加するには、この行の最後の列で Tab キーを押す)",null,null,{"$f":"パッケージ[[#This Row],[予算]]-パッケージ[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"夕食の外食",null,null,{"$f":"エンターテインメント[[#This Row],[予算]]-エンターテインメント[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":10},"その他 (行を追加するには、この行の最後の列で Tab キーを押す)",null,null,{"$f":"エンターテインメント[[#This Row],[予算]]-エンターテインメント[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,パッケージ[予算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,パッケージ[実際])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,パッケージ[差額])","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"集計",{"$f":"SUBTOTAL(109,エンターテインメント[予算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,エンターテインメント[実際])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,エンターテインメント[差額])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,null,"出張",{"$nulls":7},"雑費"]
[null,null,"項目","予算","実際","差額",{"$nulls":4},"項目","予算","実際","差額"]
[null,null,"航空運賃",null,null,{"$f":"出張費[[#This Row],[予算]]-出張費[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"休暇の写真",null,null,{"$f":"雑費[[#This Row],[予算]]-雑費[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"宿泊費",null,null,{"$f":"出張費[[#This Row],[予算]]-出張費[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"ガソリン ",null,null,{"$f":"雑費[[#This Row],[予算]]-雑費[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"移動",null,null,{"$f":"出張費[[#This Row],[予算]]-出張費[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"その他 (行を追加するには、この行の最後の列で Tab キーを押す)",null,null,{"$f":"雑費[[#This Row],[予算]]-雑費[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"その他 (行を追加するには、この行の最後の列で Tab キーを押す)",null,null,{"$f":"出張費[[#This Row],[予算]]-出張費[[#This Row],[実際]]","v":{"v":0,"d":"¥0.00"}}]
[null,null,"集計",{"$f":"SUBTOTAL(109,出張費[予算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,出張費[実際])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,出張費[差額])","v":{"v":0,"d":"¥0.00"}},{"$nulls":4},"集計",{"$f":"SUBTOTAL(109,雑費[予算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[実際])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,雑費[差額])","v":{"v":0,"d":"¥0.00"}}]