{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["概要​​","収入と支出"],"not_rendered":{"images":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"概要​​","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,1,0,4],[0,5,3,5],[1,1,1,4],[2,1,2,3],[3,2,3,3]]}
[null,"毎月の予算概要",{"$nulls":3},"予算の計画にお困りですか?この月間予算計算ツールを使用すると、月々の収入や支出を確認するのに役立ちます。管理する新しいカテゴリを [予算の概要] テーブルに追加するか、または追加済みのカテゴリを必要に応じて変更します。次に、[毎月の収入と支出] テーブルに 1 か月の収入と支出のすべてを入力し、各品目にカテゴリを割り当てます。金額を入力すると、[予算の概要] テーブル内の関連付けられたカテゴリが、自動的に集計されます。"]
[null,"[月を入力]"]
[null,{"$f":"CONCATENATE(\"下/上: \"&TEXT(下上,\"¥#,##0.00_);[赤](¥#,##0.00)\"))","v":"下/上: ¥928.00 "}]
[null,null,"予算の概要"]
[null,null,"カテゴリ","合計"]
[null,null,"収入",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":4500,"d":"4,500.00"}}]
[null,null,"住居費",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":1410,"d":"1,410.00"}}]
[null,null,"水道光熱費",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":73,"d":"73.00"}}]
[null,null,"食料品",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":220,"d":"220.00"}}]
[null,null,"保険料",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":180,"d":"180.00"}}]
[null,null,"電話",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":104,"d":"104.00"}}]
[null,null,"クレジット カード支払い",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":315,"d":"315.00"}}]
[null,null,"学校",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":1063,"d":"1,063.00"}}]
[null,null,"貯蓄",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":100,"d":"100.00"}}]
[null,null,"娯楽",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":107,"d":"107.00"}}]
[null,null,"その他",{"$f":"SUMIF(台帳[カテゴリ],\"=\" &カテゴリ[[#This Row],[カテゴリ]],台帳[金額])","v":{"v":0,"d":"0.00"}}]

{"sheet":"収入と支出","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,{"$f":"Budget_Title","v":"毎月の予算概要"}]
[null,"収入と支出"]
[null,"カテゴリ","説明","金額","メモ"]
[null,"収入","Pat の給与",{"v":1250,"d":"¥1,250.00"}]
[null,"学校","入学手続き",{"v":225,"d":"¥225.00"}]
[null,"水道光熱費","電気代とガス代",{"v":73,"d":"¥73.00"}]
[null,"学校","学校用品",{"v":38,"d":"¥38.00"}]
[null,"食料品","食料品店",{"v":40,"d":"¥40.00"}]
[null,"娯楽","Southridge ビデオ",{"v":7,"d":"¥7.00"}]
[null,"電話","電話会社",{"v":24,"d":"¥24.00"},"Jesse の携帯電話"]
[null,"収入","John の給与",{"v":2000,"d":"¥2,000.00"}]
[null,"住居費","Woodgrove 銀行",{"v":1000,"d":"¥1,000.00"},"住宅ローン"]
[null,"住居費","住宅保険",{"v":210,"d":"¥210.00"},"住宅保険"]
[null,"学校","ファイン アート スクール",{"v":800,"d":"¥800.00"},"授業料"]
[null,"クレジット カード支払い","Woodgrove 銀行",{"v":75,"d":"¥75.00"},"Pat のカード"]
[null,"貯蓄","Woodgrove 銀行",{"v":100,"d":"¥100.00"}]
[null,"電話","Consolidated Messenger",{"v":80,"d":"¥80.00"},"Pat の携帯電話"]
[null,"収入","Pat の給与",{"v":1250,"d":"¥1,250.00"}]
[null,"住居費","Woodgrove 銀行",{"v":200,"d":"¥200.00"},"固定資産税"]
[null,"保険料","自動車保険",{"v":180,"d":"¥180.00"},"自動車保険"]
[null,"食料品","食料品店",{"v":180,"d":"¥180.00"}]
[null,"クレジット カード支払い","Woodgrove 銀行",{"v":240,"d":"¥240.00"},"Jesse のカード"]
[null,"娯楽","夕食と映画",{"v":100,"d":"¥100.00"}]