{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["休日の予算プランナー"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

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