{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Graph1","取説","1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月","年計","費目毎月別集計表","費目名参考"],"not_rendered":{"charts":2,"images":17,"macros":1,"external_links":0,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Graph1","index":0,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"取説","index":1,"n_rows":188,"n_cols":16,"rows_kept":188,"cut":false,"hidden":false,"merged":[[49,11,49,14],[183,7,183,9],[33,12,33,13],[34,12,34,15],[187,0,187,3]]}
[null,null,null,"ファイル名：",{"$f":"MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1)","v":"suitou01m.xlsm"}]
[null,null,null,"　　父ちゃん母ちゃん簡単　出 納 帳　（プチ・マクロ版）",null,null,null,null,null,null,null,"お読みください m(__)m",null,null,null,"Ver 1.8"]
[]
[null,null,null,null,"このそふとはマクロを含まないソフトとして 2006年 7月 15日に公開した出納帳を元に、次のマクロを付加したものです。"]
[null,null,null,null,"　　○ 便宜上、銀行等の口座引落額を繰り入れて経費総額を把握できるように改修"]
[null,null,null,null,"　　○ 開始月が変更できるように改修"]
[null,null,null,null,"　　○ ページの追加削除ができるように改修"]
[null,null,null,null,"　　○ 継続使用を可能にするために年次更新を追加"]
[null,null,null,null,"windows8.1のExcel2013で制作しています。Excel2010でも動作確認済です。"]
[]
[]
[null,null,null,null,"改変暦"]
[null,null,null,null,null,"2006-07-15","Ver 1.0","初版を公開"]
[null,null,null,null,null,"2011-09-06",null,"ご利用者様のご指摘によりバグ修正"]
[null,null,null,null,null,null,null,"　　各月シートの費目集計表の \"合 計\" の文字列表示数式に誤りが有りこれを修正"]
[null,null,null,null,null,null,null,"　　（\"合 計\"の文字列を表示するタイミング判断の条件式の範囲が一部に留まっていた）"]
[null,null,null,null,null,null,null,"　　ご指摘を頂きました \"谷田貝 奉文\" 様、ありがとうございました。"]
[null,null,null,null,null,"2014-12-17","Ver 1.4","ページの追加ができるように改修（マクロを設定）。同時に年次更新・開始月変更・自振合算の機能他を追加。"]
[null,null,null,null,null,"2016-04-03","Ver 1.6","残高算出式を変更"]
[null,null,null,null,null,"2018-02-28","Ver 1.8","エラー（マイナス残高or貸借同行入力）の警告表示を復活"]
[null,null,null,null,"-----------------------------------------------------------------------------"]
[null,"このソフトについて"]
[]
[null,null,null,"この出納帳は父ちゃん母ちゃんの小規模事業（申告は税理士任せ）用です。もちろん個人やご家庭でもご利用になれます。　"]
[null,null,null,null,"できるだけマクロの使用を控えていますので、痒い所に手が届くようには出来ていません m(__)m"]
[null,null,null,null,"金額の桁数は８桁（１億円未満）までが正常表示が可能です。これを超えると桁腺を無視して縮小表示されます。（出金項目毎月別集計表は７桁）"]
[null,null,null,null,"　　　文字が縮小されて桁腺と重なり判読しにくくなる場合は、Ｅｘｃｅｌメニューの表示で一時的に拡大して判読してください。"]
[null,null,null,null,"金額欄のフォントはMS明朝体に設定されています。同じフォントが無い場合は8桁以内であっても桁腺ズレが発生する場合があります。"]
[]
[null,null,null,"このソフトは当初 WindowsXP機のEXCEL2003で作成してたものを、Windows8.1機のExcel2013で改修したものです。"]
[null,null,null,null,"Excel2010と2013以外での動作確認は未済です。"]
[]
[null,null,null,"シート見出し(最下部)をご覧ください。１２ヶ月分が用意されています。該当月を選んでから入力してください。"]
[null,null,null,"月次シートの他に、“取説”(このシート)　や　“年計”　・　“費目毎月別集計表”　も用意されています。",null,null,null,null,null,null,null,null,"年計シート の項へ"]
[null,null,null,"（月次入力の前に次項の 　“最初に設定が必要です”　 を先に済ませてください）",null,null,null,null,null,null,null,null,"費目毎月別集計表 の項へ"]
[]
[null,"最初に設定が必要です　（いずれも開始月のみで設定できます。）"]
[]
[null,null,null,"開始月の出納帳で次の四か所の　　　　　　　色枠内を設定してください。（ この設定は初年度の開始月のみです。）"]
[]
[null,null,null,"　　① 開始月の 年度を入力する。　数値のみを入力してください。\"年\"などの文字は入力禁止です。"]
[]
[null,null,null,"　　② 企業や団体名もしくはこの出納帳の呼称を入力してください。　未入力でも機能に影響は有りません。"]
[]
[null,null,null,"　　③ 前年度より繰越　行の残高欄に金額を入力してください。　　繰越額が無い場合は入力不要です。"]
[]
[null,null,null,"　　④ 費目別集計表　の 費目名　欄に費目名（科目名）を入力してください。　"]
[null,null,null,null,"“出金項目毎月別集計表”　を必要としない場合は入力不要です。"]
[null,null,null,null,"出金項目(費目)名は２９項目まで設定できます。"]
[null,null,null,null,"入金項目の振り分けは用意されていません。 　　入金項目も必要な場合は",null,null,null,null,null,null,"世話人さんの簡単エクセル出納帳",null,null,null,"をご検討ください。"]
[null,null,null,null,"№３０ は既定で “その他” としています。"]
[null,null,null,null,null,"費用として扱いたく無いものにご利用ください。（預金・立替金・貸金等々。）"]
[]
[null,"帳票および入力表"]
[]
[null,null,"各月シート"]
[null,null,null,"１２か月分のシートが有ります。"]
[null,null,null,null,"開始月（会計期間）を変更すればシート名が変わります。"]
[]
[null,null,"年計シート",null,"（年間出納額集計表）"]
[null,null,null,"月別入出金額集計表　→　月毎に出納額の合計金額を表示します。"]
[null,null,null,null,null,"　　純 現金出納額 と 便宜上繰り入れた銀行等支出分 を区分します。"]
[null,null,null,"費目別集計表　　　　　 →　費目毎の年間支出合計額を表示します。（月毎の集計額は事項の 費目毎月別集計表 シートで表示します。）"]
[]
[null,null,"費目毎月別集計表シート",null,null,"費目№が未入力の場合は機能しません。"]
[null,null,null,"出金項目毎月別集計表　→　項目(費目)毎に月別の合計額の一覧を表示します。"]
[]
[null,null,"コピペ（コピー＆貼り付け）時の注意"]
[null,null,null,"摘要欄は摘要欄へ、金額欄は金額欄へ等のコピペは問題有りません。罫線や書式が異なっている欄へのコピペは値貼り付け等の配慮が必要です。"]
[]
[null,"入力の仕方"]
[]
[null,null,"日々の入力"]
[]
[null,null,null,"日 ・ 摘要 ・ 入金額 または 出金額　を入力します。"]
[null,null,null,null,"入金 と 出金 を同じ行に入力しないでください。"]
[null,null,null,"費目毎の分類集計が必要な場合は、　費目№を入力します。"]
[]
[null,null,null,"※ セルを選択しただけで入力できない場合",null,null,null,"数式バー内で作業を行うか"]
[null,null,null,"　　既入力セルの追加修正をする場合",null,null,null,"ダブルクリック　もしくは　F２キー でセル内にカーソル入れて作業を行ってください。"]
[]
[null,null,null,"残高欄（自動）"]
[null,null,null,null,"入出金額を入力すると、残高が自動で表示されます。"]
[]
[null,"ボタンの機能"]
[]
[null,null,null,null,null," 入力確定後 Enter キーを押すとカーソルが 右 に移動するように設定されます。"]
[null,null,null,null,null,null,"これで数日分をまとめて入力する時などは効率的に作業ができます。"]
[null,null,null,null,null," 入力確定後 Enter キーを押すとカーソルが 下　に移動するように設定されます。"]
[]
[null,null,null,null,"※ （この設定は他のExcelファイルでも同じ動きになります。）出納帳を閉じる前に元の設定に戻しておく方が良いでしょう。　"]
[]
[null,null,null,null,null," 入力行が不足した時に１ページ分の行を追加します。"]
[]
[null,null,null,null,null," 間違って余分にページを追加した場合などに余った行をページ単位で削除します。"]
[null,null,null,null,null,null," ボタンを押しても変化が無い場合は余ったページはありません。"]
[null,null,null,null,null,null," （該当のページが１行しか使われていなくても以下は余白として残ります。）"]
[]
[null,null,null,null,null," 経費の全体を把握するために便宜上銀行口座からの自動引き落とし等も含めて記帳するためのツールを用意しました。"]
[null,null,null,null,null,null,"このボタンは、上の処理をするにあたり貸借不一致が発生する事象を解消するため相殺処理です。"]
[null,null,null,null,null,"　　① 銀行口座等からの支出（自動引き落とし等）を記帳します。 "]
[null,null,null,"【必須】",null,"--------------->　","摘要名の先頭にアスタリスク （ 小文字  “*”  もしくは 大文字  “＊” ）を付加して入力します。（小文字入力はテンキーが便利）"]
[null,null,null,null,null,null,null,"続けて 支出金額・費目の№ を入力します。"]
[null,null,null,null,null,null,"複数行を続けて入力できます。"]
[null,null,null,null,null,"　　② 前項の入力が終わったら、"]
[null,null,null,null,null,"↓","“*”　を付けて入力した欄を選択します。（行が連続していれば複数行(欄)を選択)"]
[null,null,null,null,null,"↓","　　　　　　　　　　　　　 ボタンをクリックします。"]
[null,null,null,null,null,"↓","自動的に選択範囲の上に、行が挿入されて"]
[null,null,null,null,null,null,"　　摘要名欄に “*口座引落額を記帳分等の引当（ 　 件分）” と表示されて選択した範囲の合計額が収入欄に記帳されます。"]
[null,null,null,null,null,"①の入力が行われると　　　　　　　　　　　　　　の処理が行われるまで “月計” 欄の左側に　　　　　　　　　　　　　　　　　　が表示されます。"]
[null,null,null,null,null,"　　　"]
[null,null,null," 開始月のみに配置されているボタン"]
[]
[null,null,null,null,null,null,"会計期間（通常１年間の区切り）の開始月を設定します。"]
[]
[null,null,null,null,null,null,{"$f":"\"現時点の \"&E1&\" ファイルを複製して残します。（バックアップファイルの作成）\"","v":"現時点の suitou01m.xlsm ファイルを複製して残します。（バックアップファイルの作成）"}]
[null,null,null,null,null,null,null,"ファイル名の後ろに 日付時刻 を付加したファイルを保存します。"]
[null,null,null,null,null,null,null,"保存場所は、このファイルの在るフォルダ内の “バックアップ” フォルダです。"]
[null,null,null,null,null,null,null,"際限なく増えますので、用済みのファイルは削除するようにしてください。"]
[]
[null,null,null,null,null,null,"会計期間（通常１年間）が終わったら次の年度用に帳票を書き換えます。"]
[null,null,null,null,null,null,"１．","現状の帳票をファイル名の後ろに 年度数 を付加したファイルを保存します。-----",null,null,null,null,null,null,"（保存先= “年次決算” フォルダ)"]
[null,null,null,null,null,null,"２．","念のために現時点のファイルも複製して残します。----------------------------",null,null,null,null,null,null,"（保存先= “バックアップ” フォルダ)"]
[null,null,null,null,null,null,null,"　　　① と ② は保管先とファイル名が違うだけで内容は同じです。バックアップフォルダ分は後々削除してください。"]
[null,null,null,null,null,null,"３．","年度数に１を加算して期末残高を繰越高として引き継ぎます。"]
[null,null,null,null,null,null,"４．","前項繰越高以外の月次データを総て消去します。"]
[]
[null,"（各月の）費目別集計表",null,null,null,"費目№が未入力の場合は機能しません。"]
[null,null,null,"費目№を入力すると 費目別集計表 に反映されます。"]
[null,null,null,"費目名は 開始月の出納帳 にある費目別集計表の　　費目名　　欄で自由に設定できます。　"]
[null,null,null,null,"費目名参考シートにも一般的費目名を掲載しています。よろしければご参照ください。"]
[null,null,null,null,"　　"]
[null,"印刷　と　印刷プレビュー"]
[null,null,"ボタンは用意されていません。 Ｅｘｃｅｌのメニュから　ファイル → 印刷　をご利用ください。"]
[null,null,"用紙設定 -------",null,"A４版縦向きに設定されています。　（ただし 費目毎月別集計表 は横向きに設定。）"]
[null,null,"印刷設定 -------",null,"プリンターの機種によって異なります。不具合は印刷プレビューで確認して余白を調整してください。"]
[null,null,null,null,"　　Excelの　“メニュー　→　校閲　→　シート保護の解除”　を実行してから 余白・行高さ・列幅 を調整する方法もあります。作業後はシートの保護をお忘れなく。"]
[null,null,null,null,"　　　月次出納帳シートの調整は慎重を要します。（１パージ当りの行数が変わるとページ設定に不都合が生じます）"]
[null,null,"月々の出納帳下部の３行(グレー文字部)は印刷されません。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"助け合い塾　　PCサロン"]
[]
[]
[]
[null,null,null,null,null,null,"( URL ) ","http://pasobou.world.coocan.jp/"]
[null,null,null,null,null,null,"( e-mail ) ",null,null,"　　　← ( メアドは画像化されています )"]
[]
[]
["ページ先頭に戻る"]

{"sheet":"1月","index":2,"n_rows":77,"n_cols":30,"rows_kept":77,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,2012,{"$f":"IF(L7=1,\"エラー(マイナス残高)です\",IF(L7=2,\"入金と出金は別行に記入してください\",\"\"))","v":""},null,null,null,"わがやの家計簿",null,null,"",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"1 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F70)","v":41740},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"年計!AB9","v":1},1,{"$f":"SUM($C$8:C70)","v":41740},null,null,"前年度より繰越　　　",null,null,455346,"-","* * * * *",{"$f":"MAX(L8:L70)","v":0},1,"食材飲料費",{"$f":"SUMIF(J$8:J70,M7,H$8:H70)","v":81941}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},"お年玉　お婆ちゃん",null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,3000,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":452346},7,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":"お小遣い"},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},2,"外食費",{"$f":"SUMIF(J$8:J70,M8,H$8:H70)","v":8340}]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},"お年玉　太郎",null,"",null,3000,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":449346},7,"お小遣い",{"$f":"IF(I9<0,1,IF(AND(G9<>\"\",H9<>\"\"),2,\"\"))","v":""},3,"住居費",{"$f":"SUMIF(J$8:J70,M9,H$8:H70)","v":75000}]
[null,null,"","お年玉　花子",null,"",null,2000,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":447346},7,"お小遣い","",4,"水道光熱費",{"$f":"SUMIF(J$8:J70,M10,H$8:H70)","v":25350}]
[null,null,"","お婆ちゃんから　お年賀",null,"",10000,null,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":457346},null,"","",5,"被服費",{"$f":"SUMIF(J$8:J70,M11,H$8:H70)","v":17490}]
[null,2,"","初詣　お賽銭　藤崎八旛宮",null,"",null,1000,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":456346},19,"冠婚葬祭費","",6,"教育費",{"$f":"SUMIF(J$8:J70,M12,H$8:H70)","v":23000}]
[null,null,"","初詣　お札代　藤崎八旛宮",null,"",null,1500,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":454846},19,"冠婚葬祭費","",7,"お小遣い",{"$f":"SUMIF(J$8:J70,M13,H$8:H70)","v":31000}]
[null,null,"","初詣　電車賃　4人往復",null,"",null,1200,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":453646},19,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":"冠婚葬祭費"},"",8,"通信ＩＴ費",{"$f":"SUMIF(J$8:J70,M14,H$8:H70)","v":6220}]
[null,4,"","食材　ダイエー",null,"",null,1724,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":451922},1,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":"食材飲料費"},"",9,"交際費",{"$f":"SUMIF(J$8:J70,M15,H$8:H70)","v":0}]
[null,null,"","灯油代　キグナス肥後",null,"",null,1830,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":450092},4,"水道光熱費","",10,"趣味娯楽費",{"$f":"SUMIF(J$8:J70,M16,H$8:H70)","v":0}]
[null,6,"","たかさき屋　家族会食",null,"",null,8340,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":441752},2,"外食費","",11,"社会保険料",{"$f":"SUMIF(J$8:J70,M17,H$8:H70)","v":0}]
[null,null,"","食材　ダイエー",null,"",null,3265,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":438487},1,"食材飲料費","",12,"其他保険料",{"$f":"SUMIF(J$8:J70,M18,H$8:H70)","v":18500}]
[null,7,"","パパ　1月分",null,"",null,20000,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":418487},7,"お小遣い","",13,"保健医療費",{"$f":"SUMIF(J$8:J70,M19,H$8:H70)","v":0}]
[null,null,"","ガソリン代　キグナス肥後",null,"",null,4359,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":414128},20,"車両費","",14,"税金",{"$f":"SUMIF(J$8:J70,M20,H$8:H70)","v":0}]
[null,9,"","食材　ダイエー",null,"",null,6378,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":407750},1,"食材飲料費","",15,"交通費",{"$f":"SUMIF(J$8:J70,M21,H$8:H70)","v":0}]
[null,11,"","食材　ダイエー",null,"",null,12355,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":395395},1,"食材飲料費","",16,"支払手数料",{"$f":"SUMIF(J$8:J70,M22,H$8:H70)","v":0}]
[null,13,"","お米　ダイエー",null,"",null,3470,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":391925},1,"食材飲料費","",17,"雑貨日用品",{"$f":"SUMIF(J$8:J70,M23,H$8:H70)","v":10400}]
[null,null,"","焼酎　ダイエー",null,"",null,1790,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":390135},1,"食材飲料費","",18,"消耗品費",{"$f":"SUMIF(J$8:J70,M24,H$8:H70)","v":165}]
[null,15,"","食材　ダイエー",null,"",null,1894,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":388241},1,"食材飲料費","",19,"冠婚葬祭費",{"$f":"SUMIF(J$8:J70,M25,H$8:H70)","v":3700}]
[null,16,"","高速通行料　熊本～福岡",null,"",null,4500,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":383741},20,"車両費","",20,"車両費",{"$f":"SUMIF(J$8:J70,M26,H$8:H70)","v":9859}]
[null,null,"","駐車場 料金",null,"",null,1000,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":382741},20,"車両費","",21,"雑費",{"$f":"SUMIF(J$8:J70,M27,H$8:H70)","v":0}]
[null,null,"","太郎＆花子用ウエアー類　お婆ちゃんのお年玉で",null,"",null,13240,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":369501},5,"被服費","",22,null,{"$f":"SUMIF(J$8:J70,M28,H$8:H70)","v":0}]
[null,18,"","魚・野菜他　ダイエー",null,"",null,2367,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":367134},1,"食材飲料費","",23,null,{"$f":"SUMIF(J$8:J70,M29,H$8:H70)","v":0}]
[null,null,"","クリーニング代　白洋舎",null,"",null,840,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":366294},5,"被服費","",24,null,{"$f":"SUMIF(J$8:J70,M30,H$8:H70)","v":0}]
[null,20,"","食材　ダイエー",null,"",null,11642,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":354652},1,"食材飲料費","",25,null,{"$f":"SUMIF(J$8:J70,M31,H$8:H70)","v":0}]
[null,null,"","塾費　太郎学習塾",null,"",null,15000,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":339652},6,"教育費","",26,null,{"$f":"SUMIF(J$8:J70,M32,H$8:H70)","v":0}]
[null,null,"","塾費　花子バレー教室",null,"",null,8000,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":331652},6,"教育費","",27,null,{"$f":"SUMIF(J$8:J70,M33,H$8:H70)","v":0}]
[null,null,"","ママパートお給料　12月分",null,"",36000,null,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":367652},null,"","",28,null,{"$f":"SUMIF(J$8:J70,M34,H$8:H70)","v":0}]
[null,null,"","お小遣い　太郎",null,"",null,2000,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":365652},7,"お小遣い","",29,"使途不明金",{"$f":"SUMIF(J$8:J70,M35,H$8:H70)","v":3600}]
[null,null,"","お小遣い　花子",null,"",null,1000,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":364652},7,"お小遣い","",30,"その他",{"$f":"SUMIF(J$8:J70,M36,H$8:H70)","v":50000}]
[null,null,12000,"*口座引落額を記帳分等の引当（ 1 件分）",null,0,12000,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":376652},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":"合 計"},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":364565}]
[null,null,0,"*生命保険料　1月分　明治生命",null,12000,null,12000,{"$f":"$I$7+SUM($G$8:G38)-SUM($H$8:H38)","v":364652},12,"其他保険料",""]
[null,23,"","食材　ダイエー",null,"",null,6483,{"$f":"$I$7+SUM($G$8:G39)-SUM($H$8:H39)","v":358169},1,"食材飲料費",""]
[null,null,"","パパ靴下　ダイエー",null,"",null,3410,{"$f":"$I$7+SUM($G$8:G40)-SUM($H$8:H40)","v":354759},5,"被服費",""]
[null,25,"","２月分家賃　山田様　",null,"",null,75000,{"$f":"$I$7+SUM($G$8:G41)-SUM($H$8:H41)","v":279759},3,"住居費",""]
[null,null,"","ホットモット お弁当",null,"",null,2480,{"$f":"$I$7+SUM($G$8:G42)-SUM($H$8:H42)","v":277279},1,"食材飲料費",""]
[null,null,29740,"*口座引落額を記帳分等の引当（ 5 件分）",null,0,29740,null,{"$f":"$I$7+SUM($G$8:G43)-SUM($H$8:H43)","v":307019},null,"",""]
[null,null,0,"*自動引き落とし 電気料",null,12440,null,12440,{"$f":"$I$7+SUM($G$8:G44)-SUM($H$8:H44)","v":294579},4,"水道光熱費",""]
[null,null,0,"*自動引き落とし 上下水道料",null,8400,null,8400,{"$f":"$I$7+SUM($G$8:G45)-SUM($H$8:H45)","v":286179},4,"水道光熱費",""]
[null,null,0,"*自動引き落とし ガス代",null,2680,null,2680,{"$f":"$I$7+SUM($G$8:G46)-SUM($H$8:H46)","v":283499},4,"水道光熱費",""]
[null,null,0,"*VISAカード決済　NTT回線料・通話料",null,5120,null,5120,{"$f":"$I$7+SUM($G$8:G47)-SUM($H$8:H47)","v":278379},8,"通信ＩＴ費",""]
[null,null,0,"*VISAカード決済　niftyプロバイダ料",null,1100,null,1100,{"$f":"$I$7+SUM($G$8:G48)-SUM($H$8:H48)","v":277279},8,"通信ＩＴ費",""]
[null,26,"","単三電池　セブンイレブン",null,"",null,520,{"$f":"$I$7+SUM($G$8:G49)-SUM($H$8:H49)","v":276759},17,"雑貨日用品",""]
[null,null,"","食材　ダイエー",null,"",null,6450,{"$f":"$I$7+SUM($G$8:G50)-SUM($H$8:H50)","v":270309},1,"食材飲料費",""]
[null,null,"","便箋　ダイエー",null,"",null,165,{"$f":"$I$7+SUM($G$8:G51)-SUM($H$8:H51)","v":270144},18,"消耗品費",""]
[null,28,"","食材　ゆめマート",null,"",null,6432,{"$f":"$I$7+SUM($G$8:G52)-SUM($H$8:H52)","v":263712},1,"食材飲料費",""]
[null,30,"","食材　ダイエー",null,"",null,15211,{"$f":"$I$7+SUM($G$8:G53)-SUM($H$8:H53)","v":248501},1,"食材飲料費",""]
[null,null,"","LED電球 6個 ダイエー",null,"",null,9880,{"$f":"$I$7+SUM($G$8:G54)-SUM($H$8:H54)","v":238621},17,"雑貨日用品",""]
[null,null,"","1月度積立金",null,"",null,50000,{"$f":"$I$7+SUM($G$8:G55)-SUM($H$8:H55)","v":188621},30,"その他",""]
[null,null,"","家財保険　県民共済",null,"",null,6500,{"$f":"$I$7+SUM($G$8:G56)-SUM($H$8:H56)","v":182121},12,"其他保険料",""]
[null,null,"","残高相違",null,"",null,3600,{"$f":"$I$7+SUM($G$8:G57)-SUM($H$8:H57)","v":178521},29,"使途不明金",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G58)-SUM($H$8:H58)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G59)-SUM($H$8:H59)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G60)-SUM($H$8:H60)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G61)-SUM($H$8:H61)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G62)-SUM($H$8:H62)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G63)-SUM($H$8:H63)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G64)-SUM($H$8:H64)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G65)-SUM($H$8:H65)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G66)-SUM($H$8:H66)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G67)-SUM($H$8:H67)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G68)-SUM($H$8:H68)","v":178521},null,"",""]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G69)-SUM($H$8:H69)","v":178521},null,"",""]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G69)","v":87740},{"$f":"SUM(H$8:H69)","v":364565}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":455346}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I69","v":178521}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G70:G72)","v":543086},{"$f":"SUM(H70:H72)","v":543086}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G70-G77","v":46000},{"$f":"H70-H77","v":322825}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":41740},{"$f":"$F$6","v":41740}]

{"sheet":"2月","index":3,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},{"$f":"IF(L7=1,\"エラー(マイナス残高)です\",IF(L7=2,\"入金と出金は別行に記入してください\",\"\"))","v":""},null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"2 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":41140},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('1月'!A7+1<=12,'1月'!A7+1,'1月'!A7+1-12)","v":2},1,{"$f":"SUM($C$8:C37)","v":41140},null,null,"前月より繰越　　　",null,null,{"$f":"'1月'!H72","v":178521},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J37,M7,H$8:H37)","v":45710}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},"食材　ダイエー",null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,15759,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":162762},1,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":"食材飲料費"},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},{"$f":"SUMIF(J$8:J37,M8,H$8:H37)","v":24360}]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},"木下家葬儀御霊前",null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,10000,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":152762},9,"交際費","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},{"$f":"SUMIF(J$8:J37,M9,H$8:H37)","v":75000}]
[null,7,"","ローボード＆カラーボックス",null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),H10,\"\")","v":""},null,23900,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":128862},17,"雑貨日用品","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},{"$f":"SUMIF(J$8:J37,M10,H$8:H37)","v":22070}]
[null,8,"","ウェスト",null,{"$f":"IF(OR(LEFT(D11,1)=\"*\",LEFT(D11,1)=\"＊\"),H11,\"\")","v":""},null,10130,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":118732},2,"外食費","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},{"$f":"SUMIF(J$8:J37,M11,H$8:H37)","v":0}]
[null,10,"","パパ　２月分",null,"",null,20000,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":98732},7,"お小遣い","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},{"$f":"SUMIF(J$8:J37,M12,H$8:H37)","v":35600}]
[null,15,"","食材　ダイエー",null,"",null,8184,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":90548},1,"食材飲料費","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},{"$f":"SUMIF(J$8:J37,M13,H$8:H37)","v":23000}]
[null,null,"","ガソリン代　キグナス肥後",null,"",null,8540,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":82008},20,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":"車両費"},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},{"$f":"SUMIF(J$8:J37,M14,H$8:H37)","v":7070}]
[null,20,"","食材　ダイエー",null,"",null,7124,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":74884},1,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":"食材飲料費"},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},{"$f":"SUMIF(J$8:J37,M15,H$8:H37)","v":10000}]
[null,null,"","塾費　太郎学習塾",null,"",null,15000,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":59884},6,"教育費","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},{"$f":"SUMIF(J$8:J37,M16,H$8:H37)","v":0}]
[null,null,"","塾費　花子バレー教室",null,"",null,8000,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":51884},6,"教育費","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},{"$f":"SUMIF(J$8:J37,M17,H$8:H37)","v":0}]
[null,null,"","ママパートお給料　１月分",null,"",34400,null,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":86284},null,"","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},{"$f":"SUMIF(J$8:J37,M18,H$8:H37)","v":12000}]
[null,null,"","お小遣い　太郎",null,"",null,2000,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":84284},7,"お小遣い","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},{"$f":"SUMIF(J$8:J37,M19,H$8:H37)","v":0}]
[null,null,12000,"*口座引落額を記帳分等の引当（ 1 件分）",null,0,12000,null,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":96284},null,"","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},{"$f":"SUMIF(J$8:J37,M20,H$8:H37)","v":0}]
[null,null,0,"*生命保険料　２月分　明治生命",null,12000,null,12000,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":84284},12,"其他保険料","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},{"$f":"SUMIF(J$8:J37,M21,H$8:H37)","v":0}]
[null,22,"","食材　ダイエー",null,"",null,8527,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":75757},1,"食材飲料費","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},{"$f":"SUMIF(J$8:J37,M22,H$8:H37)","v":0}]
[null,25,"","お小遣い　花子",null,"",null,1000,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":74757},7,"お小遣い","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},{"$f":"SUMIF(J$8:J37,M23,H$8:H37)","v":23900}]
[null,null,29140,"*口座引落額を記帳分等の引当（ 5 件分）",null,0,29140,null,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":103897},null,"","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},{"$f":"SUMIF(J$8:J37,M24,H$8:H37)","v":670}]
[null,null,0,"*自動引き落とし 電気料",null,11350,null,11350,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":92547},4,"水道光熱費","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},{"$f":"SUMIF(J$8:J37,M25,H$8:H37)","v":0}]
[null,null,0,"*自動引き落とし 上下水道料",null,8040,null,8040,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":84507},4,"水道光熱費","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},{"$f":"SUMIF(J$8:J37,M26,H$8:H37)","v":8540}]
[null,null,0,"*自動引き落とし ガス代",null,2680,null,2680,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":81827},4,"水道光熱費","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},{"$f":"SUMIF(J$8:J37,M27,H$8:H37)","v":0}]
[null,null,0,"*VISAカード決済　NTT回線料・通話料",null,5970,null,5970,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":75857},8,"通信ＩＴ費","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},{"$f":"SUMIF(J$8:J37,M28,H$8:H37)","v":0}]
[null,null,0,"*VISAカード決済　niftyプロバイダ料",null,1100,null,1100,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":74757},8,"通信ＩＴ費","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},{"$f":"SUMIF(J$8:J37,M29,H$8:H37)","v":0}]
[null,28,"","衣装代　花子バレー教室　",null,"",null,12600,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":62157},6,"教育費","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},{"$f":"SUMIF(J$8:J37,M30,H$8:H37)","v":0}]
[null,null,"","ウエストにて焼肉",null,"",null,5586,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":56571},1,"食材飲料費","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},{"$f":"SUMIF(J$8:J37,M31,H$8:H37)","v":0}]
[null,null,"","ポプコーン他　セブンイレブン",null,"",null,530,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":56041},1,"食材飲料費","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},{"$f":"SUMIF(J$8:J37,M32,H$8:H37)","v":0}]
[null,null,"","手元現金準備　肥後銀行口座より",null,"",350000,null,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":406041},null,"","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},{"$f":"SUMIF(J$8:J37,M33,H$8:H37)","v":0}]
[null,null,"","食材　ダイエー",null,"",null,14230,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":391811},2,"外食費","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},{"$f":"SUMIF(J$8:J37,M34,H$8:H37)","v":0}]
[null,null,"","３月分家賃　山田様",null,"",null,75000,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":316811},3,"住居費","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},{"$f":"SUMIF(J$8:J37,M35,H$8:H37)","v":0}]
[null,null,"","洗剤他　ドラッグスター",null,"",null,670,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":316141},18,"消耗品費","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},{"$f":"SUMIF(J$8:J37,M36,H$8:H37)","v":0}]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":316141},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":"合 計"},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":287920}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":425540},{"$f":"SUM(H$8:H37)","v":287920}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":178521}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":316141}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":604061},{"$f":"SUM(H38:H40)","v":604061}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":384400},{"$f":"H38-H45","v":246780}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":41140},{"$f":"$F$6","v":41140}]
[null,null,null,null,null,{"$f":"IF(OR(LEFT(D46,1)=\"*\",LEFT(D46,1)=\"＊\"),H46,\"\")","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]

{"sheet":"3月","index":4,"n_rows":70,"n_cols":15,"rows_kept":70,"cut":false,"hidden":false,"merged":[[2,8,2,10],[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},null,null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"3 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":43000},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('2月'!A7+1<=12,'2月'!A7+1,'2月'!A7+1-12)","v":3},1,{"$f":"SUM($C$8:C37)","v":43000},null,null,"前月より繰越　　　",null,null,{"$f":"'2月'!H40","v":316141},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":59436}]
[null,2,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},"食材　ダイエー",null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,6803,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":309338},1,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":"食材飲料費"},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},13540]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},"鉢・苗・肥料代",null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,3670,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":305668},10,"趣味娯楽費","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},75000]
[null,5,"","食材　ダイエー",null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),H10,\"\")","v":""},null,6532,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":299136},1,"食材飲料費","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},23930]
[null,6,"","山崎さんへ手土産　とら家",null,{"$f":"IF(OR(LEFT(D11,1)=\"*\",LEFT(D11,1)=\"＊\"),H11,\"\")","v":""},null,3000,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":296136},9,"交際費","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},7530]
[null,7,"","太郎誕生祝いで回転寿司へ",null,"",null,13540,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":282596},2,"外食費","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},23000]
[null,null,"","パパ　３月分",null,"",null,20000,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":262596},7,"お小遣い","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},24000]
[null,10,"","食材　ダイエー",null,"",null,5684,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":256912},1,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":"食材飲料費"},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},7070]
[null,null,"","ガソリン代　キグナス肥後",null,"",null,7634,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":249278},20,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":"車両費"},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},3000]
[null,15,"","食材　ダイエー",null,"",null,10256,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":239022},1,"食材飲料費","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},3670]
[null,null,"","塾費　太郎学習塾",null,"",null,15000,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":224022},6,"教育費","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,"","塾費　花子バレー教室",null,"",null,8000,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":216022},6,"教育費","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},12000]
[null,20,"","ママパートお給料　２月分",null,"",36580,null,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":252602},null,"","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,null,"","お小遣い　太郎",null,"",null,3000,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":249602},7,"お小遣い","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,null,"","お小遣い　花子",null,"",null,1000,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":248602},7,"お小遣い","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,"","食材　ダイエー",null,"",null,11865,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":236737},1,"食材飲料費","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,null,12000,"*口座引落額を記帳分等の引当（ 1 件分）",null,0,12000,null,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":248737},null,"","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,null,0,"*生命保険料　３月分　明治生命",null,12000,null,12000,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":236737},12,"其他保険料","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},0]
[null,25,"","４月分家賃　山田様　",null,"",null,75000,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":161737},3,"住居費","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,"","食材　ダイエー",null,"",null,9867,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":151870},1,"食材飲料費","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},7634]
[null,null,"","3月度積立金",null,"",null,50000,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":101870},30,"その他","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,31000,"*口座引落額を記帳分等の引当（ 5 件分）",null,0,31000,null,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":132870},null,"","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,null,0,"*自動引き落とし 電気料",null,13050,null,13050,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":119820},4,"水道光熱費","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,0,"*自動引き落とし 上下水道料",null,8200,null,8200,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":111620},4,"水道光熱費","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,0,"*自動引き落とし ガス代",null,2680,null,2680,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":108940},4,"水道光熱費","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,0,"*VISAカード決済　NTT回線料・通話料",null,5970,null,5970,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":102970},8,"通信ＩＴ費","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,0,"*VISAカード決済　niftyプロバイダ料",null,1100,null,1100,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":101870},8,"通信ＩＴ費","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,28,"","食材　ダイエー",null,"",null,8429,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":93441},1,"食材飲料費","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,30,"","パパ　カッターシャツ他",null,"",null,7530,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":85911},5,"被服費","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},3]
[null,null,"","手元現金準備",null,"",250000,null,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":335911},null,"","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},50000]
[null,null,"","違算金",null,"",null,3,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":335908},29,"使途不明金","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":"合 計"},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":309813}]
[null,null,{"$f":"IF(OR(LEFT(D38,1)=\"*\",LEFT(D38,1)=\"＊\"),G38,\"\")","v":""},null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":329580},{"$f":"SUM(H$8:H37)","v":309813}]
[null,null,"",null,null,"前月残高　",{"$f":"I7","v":316141}]
[null,null,"",null,null,"当月残高　",null,{"$f":"I37","v":335908}]
[null,null,"",null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":645721},{"$f":"SUM(H38:H40)","v":645721}]
[null,null,""]
[null,null,"",null,null,"（月計の内訳）"]
[null,null,"",null,null,"現 　　　　金 ",{"$f":"G38-G45","v":286580},{"$f":"H38-H45","v":266813}]
[null,null,"",null,null,"預貯金振替 ",{"$f":"$C$7","v":43000},{"$f":"$F$6","v":43000}]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"4月","index":5,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},null,null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"4 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":40130},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('3月'!A7+1<=12,'3月'!A7+1,'3月'!A7+1-12)","v":4},1,{"$f":"SUM($C$8:C37)","v":40130},null,null,"前月より繰越　　　",null,null,{"$f":"'3月'!H40","v":335908},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":76512}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},"食材　ダイエー",null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,12465,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":323443},1,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":"食材飲料費"},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},0]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},"洗剤他　ダイエー",null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,868,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":322575},18,"消耗品費","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},75000]
[null,4,"","食材　ダイエー",null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),H10,\"\")","v":""},null,6548,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":316027},1,"食材飲料費","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},21060]
[null,null,"","ガソリン代　キグナス肥後",null,{"$f":"IF(OR(LEFT(D11,1)=\"*\",LEFT(D11,1)=\"＊\"),H11,\"\")","v":""},null,8530,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":307497},20,"車両費","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},0]
[null,5,"","パパ　４月分",null,"",null,20000,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":287497},7,"お小遣い","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},0]
[null,8,"","景子ちゃん　結婚祝い",null,"",null,50000,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":237497},9,"交際費","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},23000]
[null,null,"","食材　ダイエー",null,"",null,8467,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":229030},1,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":"食材飲料費"},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},30070]
[null,9,"","フルーツ　よしだ",null,"",null,2430,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":226600},1,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":"食材飲料費"},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},50000]
[null,13,"","食材　ダイエー",null,"",null,12035,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":214565},1,"食材飲料費","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},0]
[null,20,"","ママパートお給料　３月分",null,"",36690,null,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":251255},null,"","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,"","お小遣い　太郎",null,"",null,2000,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":249255},7,"お小遣い","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},12000]
[null,null,"","お小遣い　花子",null,"",null,1000,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":248255},7,"お小遣い","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,null,"","食材　ダイエー",null,"",null,6451,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":241804},1,"食材飲料費","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,null,12000,"*口座引落額を記帳分等の引当（ 1 件分）",null,0,12000,null,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":253804},null,"","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,0,"*生命保険料　４月分　明治生命",null,12000,null,12000,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":241804},12,"其他保険料","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,22,"","食材　ダイエー",null,"",null,7544,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":234260},1,"食材飲料費","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,25,"","５月分家賃　山田様　",null,"",null,75000,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":159260},3,"住居費","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},868]
[null,null,"","雅ちゃんに用立て分　返金受入",null,"",100000,null,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":259260},null,"","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,"","４月度積立金",null,"",null,50000,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":209260},30,"その他","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},8530]
[null,null,"","食材　ダイエー",null,"",null,7536,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":201724},1,"食材飲料費","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,28130,"*口座引落額を記帳分等の引当（ 5 件分）",null,0,28130,null,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":229854},null,"","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,null,0,"*自動引き落とし 電気料",null,10050,null,10050,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":219804},4,"水道光熱費","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,0,"*自動引き落とし 上下水道料",null,8330,null,8330,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":211474},4,"水道光熱費","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,0,"*自動引き落とし ガス代",null,2680,null,2680,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":208794},4,"水道光熱費","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,0,"*VISAカード決済　NTT回線料・通話料",null,5970,null,5970,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":202824},8,"通信ＩＴ費","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,0,"*VISAカード決済　niftyプロバイダ料",null,1100,null,1100,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":201724},8,"通信ＩＴ費","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,28,"","食材　ダイエー",null,"",null,6604,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":195120},1,"食材飲料費","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,null,"","塾費　太郎学習塾",null,"",null,15000,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":180120},8,"通信ＩＴ費","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},0]
[null,null,"","塾費　花子バレー教室",null,"",null,8000,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":172120},8,"通信ＩＴ費","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},50000]
[null,30,"","食材　ダイエー",null,"",null,6432,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":165688},1,"食材飲料費","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":"合 計"},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":347040}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":176820},{"$f":"SUM(H$8:H37)","v":347040}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":335908}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":165688}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":512728},{"$f":"SUM(H38:H40)","v":512728}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":136690},{"$f":"H38-H45","v":306910}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":40130},{"$f":"$F$6","v":40130}]

{"sheet":"5月","index":6,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},{"$f":"IF(L7=1,\"エラー(マイナス残高)です\",IF(L7=2,\"入金と出金は別行に記入してください\",\"\"))","v":""},null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"5 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":43010},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('4月'!A7+1<=12,'4月'!A7+1,'4月'!A7+1-12)","v":5},1,{"$f":"SUM($C$8:C37)","v":43010},null,null,"前月より繰越　　　",null,null,{"$f":"'4月'!H40","v":165688},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":41074}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},"食材　ダイエー",null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,12387,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":153301},1,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":"食材飲料費"},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},20776]
[null,4,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},"鬼太郎",null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,7356,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":145945},2,"外食費","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},75000]
[null,10,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),G10,\"\")","v":""},"パパ　５月分",null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),H10,\"\")","v":""},null,20000,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":125945},7,"お小遣い","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},23940]
[null,15,"","食材　ダイエー",null,"",null,8254,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":117691},1,"食材飲料費","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},0]
[null,null,"","ガソリン代　キグナス肥後",null,"",null,4640,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":113051},20,"車両費","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},23000]
[null,20,"","食材　ダイエー",null,"",null,4217,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":108834},1,"食材飲料費","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},23000]
[null,null,"","塾費　太郎学習塾",null,"",null,15000,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":93834},6,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":"教育費"},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},7070]
[null,null,"","塾費　花子バレー教室",null,"",null,8000,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":85834},6,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":"教育費"},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},0]
[null,null,"","ママパートお給料　４月分",null,"",36800,null,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":122634},null,"","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},0]
[null,null,"","お小遣い　太郎",null,"",null,2000,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":120634},7,"お小遣い","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,12000,"*口座引落額を記帳分等の引当（ 1 件分）",null,0,12000,null,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":132634},null,"","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},12000]
[null,null,{"$f":"IF(OR(LEFT(D19,1)=\"*\",LEFT(D19,1)=\"＊\"),G19,\"\")","v":0},"*生命保険料　５月分　明治生命",null,{"$f":"IF(OR(LEFT(D19,1)=\"*\",LEFT(D19,1)=\"＊\"),H19,\"\")","v":12000},null,12000,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":120634},12,"其他保険料","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,22,"","食材　ダイエー",null,"",null,9634,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":111000},1,"食材飲料費","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,25,"","お小遣い　花子",null,"",null,1000,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":110000},7,"お小遣い","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,"","手元現金準備",null,"",100000,null,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":210000},null,"","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,null,31010,"*口座引落額を記帳分等の引当（ 5 件分）",null,0,31010,null,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":241010},null,"","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,null,{"$f":"IF(OR(LEFT(D24,1)=\"*\",LEFT(D24,1)=\"＊\"),G24,\"\")","v":0},"*自動引き落とし 電気料",null,{"$f":"IF(OR(LEFT(D24,1)=\"*\",LEFT(D24,1)=\"＊\"),H24,\"\")","v":13510},null,13510,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":227500},4,"水道光熱費","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},0]
[null,null,0,"*自動引き落とし 上下水道料",null,7750,null,7750,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":219750},4,"水道光熱費","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,0,"*自動引き落とし ガス代",null,2680,null,2680,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":217070},4,"水道光熱費","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},4640]
[null,null,0,"*VISAカード決済　NTT回線料・通話料",null,5970,null,5970,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":211100},8,"通信ＩＴ費","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,0,"*VISAカード決済　niftyプロバイダ料",null,1100,null,1100,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":210000},8,"通信ＩＴ費","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,28,"","一休",null,"",null,6348,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":203652},1,"食材飲料費","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,"","菓子他　セブンイレブン",null,"",null,234,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":203418},1,"食材飲料費","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,"","食材　ダイエー",null,"",null,13420,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":189998},2,"外食費","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,"","３月分家賃　山田様",null,"",null,75000,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":114998},3,"住居費","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":114998},null,"","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":114998},null,"","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":114998},null,"","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":114998},null,"","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":114998},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":"合 計"},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":230500}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":179810},{"$f":"SUM(H$8:H37)","v":230500}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":165688}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":114998}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":345498},{"$f":"SUM(H38:H40)","v":345498}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":136800},{"$f":"H38-H45","v":187490}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":43010},{"$f":"$F$6","v":43010}]

{"sheet":"6月","index":7,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C7","v":0}]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳",null,null,null,null,null,null,{"$f":"F6","v":0}]
[null,null,null,{"$f":"'1月'!D3","v":2012},{"$f":"IF(L7=1,\"エラー(マイナス残高)です\",IF(L7=2,\"入金と出金は別行に記入してください\",\"\"))","v":""},null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"6 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":0},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('5月'!A7+1<=12,'5月'!A7+1,'5月'!A7+1-12)","v":6},1,{"$f":"SUM($C$8:C37)","v":0},null,null,"前月より繰越　　　",null,null,{"$f":"'5月'!H40","v":114998},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":0}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":114998},null,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":""},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},0]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},null,null,null,null,null,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":114998},null,"","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},0]
[null,null,"",null,null,null,null,null,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":114998},null,"","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},0]
[null,null,"",null,null,{"$f":"IF(OR(LEFT(D11,1)=\"*\",LEFT(D11,1)=\"＊\"),H11,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":114998},null,"","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":114998},null,"","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":114998},null,"","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":114998},null,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":114998},null,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":114998},null,"","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":114998},null,"","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":114998},null,"","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":114998},null,"","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":114998},null,"","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":114998},null,"","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":114998},null,"","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":114998},null,"","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":114998},null,"","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":114998},null,"","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":114998},null,"","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":114998},null,"","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":114998},null,"","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":114998},null,"","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":114998},null,"","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":114998},null,"","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":114998},null,"","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":114998},null,"","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":114998},null,"","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":114998},null,"","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":114998},null,"","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":114998},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":""},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":""}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":0},{"$f":"SUM(H$8:H37)","v":0}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":114998}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":114998}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":114998},{"$f":"SUM(H38:H40)","v":114998}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":0},{"$f":"H38-H45","v":0}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":0},{"$f":"$F$6","v":0}]

{"sheet":"7月","index":8,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},null,null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"7 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":0},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('6月'!A7+1<=12,'6月'!A7+1,'6月'!A7+1-12)","v":7},1,{"$f":"SUM($C$8:C37)","v":0},null,null,"前月より繰越　　　",null,null,{"$f":"'6月'!H40","v":114998},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":0}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":114998},null,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":""},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},0]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":114998},null,"","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},0]
[null,null,"",null,null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),H10,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":114998},null,"","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},0]
[null,null,"",null,null,{"$f":"IF(OR(LEFT(D11,1)=\"*\",LEFT(D11,1)=\"＊\"),H11,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":114998},null,"","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":114998},null,"","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":114998},null,"","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":114998},null,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":114998},null,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":114998},null,"","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":114998},null,"","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":114998},null,"","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":114998},null,"","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":114998},null,"","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":114998},null,"","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":114998},null,"","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":114998},null,"","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":114998},null,"","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":114998},null,"","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":114998},null,"","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":114998},null,"","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":114998},null,"","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":114998},null,"","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":114998},null,"","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":114998},null,"","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":114998},null,"","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":114998},null,"","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":114998},null,"","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":114998},null,"","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":114998},null,"","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":114998},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":""},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":""}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":0},{"$f":"SUM(H$8:H37)","v":0}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":114998}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":114998}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":114998},{"$f":"SUM(H38:H40)","v":114998}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":0},{"$f":"H38-H45","v":0}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":0},{"$f":"$F$6","v":0}]

{"sheet":"8月","index":9,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},null,null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"8 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":0},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('7月'!A7+1<=12,'7月'!A7+1,'7月'!A7+1-12)","v":8},1,{"$f":"SUM($C$8:C37)","v":0},null,null,"前月より繰越　　　",null,null,{"$f":"'7月'!H40","v":114998},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":0}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":114998},null,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":""},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},0]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":114998},null,"","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},0]
[null,null,"",null,null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),H10,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":114998},null,"","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},0]
[null,null,"",null,null,{"$f":"IF(OR(LEFT(D11,1)=\"*\",LEFT(D11,1)=\"＊\"),H11,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":114998},null,"","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":114998},null,"","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":114998},null,"","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":114998},null,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},0]
[null,null,{"$f":"IF(OR(LEFT(D15,1)=\"*\",LEFT(D15,1)=\"＊\"),G15,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D15,1)=\"*\",LEFT(D15,1)=\"＊\"),H15,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":114998},null,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":114998},null,"","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":114998},null,"","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":114998},null,"","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":114998},null,"","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":114998},null,"","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":114998},null,"","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":114998},null,"","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,null,{"$f":"IF(OR(LEFT(D23,1)=\"*\",LEFT(D23,1)=\"＊\"),G23,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D23,1)=\"*\",LEFT(D23,1)=\"＊\"),H23,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":114998},null,"","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":114998},null,"","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":114998},null,"","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":114998},null,"","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":114998},null,"","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":114998},null,"","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":114998},null,"","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":114998},null,"","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":114998},null,"","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":114998},null,"","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":114998},null,"","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":114998},null,"","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":114998},null,"","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":114998},null,"","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":114998},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":""},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":""}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":0},{"$f":"SUM(H$8:H37)","v":0}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":114998}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":114998}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":114998},{"$f":"SUM(H38:H40)","v":114998}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":0},{"$f":"H38-H45","v":0}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":0},{"$f":"$F$6","v":0}]

{"sheet":"9月","index":10,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},null,null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"9 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":0},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('8月'!A7+1<=12,'8月'!A7+1,'8月'!A7+1-12)","v":9},1,{"$f":"SUM($C$8:C37)","v":0},null,null,"前月より繰越　　　",null,null,{"$f":"'8月'!H40","v":114998},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":0}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":114998},null,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":""},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},0]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":114998},null,"","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},0]
[null,null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),G10,\"\")","v":""},null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":114998},null,"","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":114998},null,"","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":114998},null,"","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":114998},null,"","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},0]
[null,null,{"$f":"IF(OR(LEFT(D14,1)=\"*\",LEFT(D14,1)=\"＊\"),G14,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D14,1)=\"*\",LEFT(D14,1)=\"＊\"),H14,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":114998},null,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},0]
[null,null,{"$f":"IF(OR(LEFT(D15,1)=\"*\",LEFT(D15,1)=\"＊\"),G15,\"\")","v":""},null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":114998},null,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":114998},null,"","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":114998},null,"","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":114998},null,"","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":114998},null,"","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":114998},null,"","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":114998},null,{"$f":"IF(J21<>0,VLOOKUP(J21,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":114998},null,"","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":114998},null,"","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":114998},null,"","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":114998},null,"","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":114998},null,"","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":114998},null,"","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":114998},null,"","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":114998},null,"","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":114998},null,"","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":114998},null,"","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":114998},null,"","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":114998},null,"","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":114998},null,"","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":114998},null,"","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":114998},null,"","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":114998},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":""},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":""}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":0},{"$f":"SUM(H$8:H37)","v":0}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":114998}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":114998}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":114998},{"$f":"SUM(H38:H40)","v":114998}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":0},{"$f":"H38-H45","v":0}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":0},{"$f":"$F$6","v":0}]

{"sheet":"10月","index":11,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},{"$f":"IF(L7=1,\"エラー(マイナス残高)です\",IF(L7=2,\"入金と出金は別行に記入してください\",\"\"))","v":""},null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"10 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":0},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('9月'!A7+1<=12,'9月'!A7+1,'9月'!A7+1-12)","v":10},1,{"$f":"SUM($C$8:C37)","v":0},null,null,"前月より繰越　　　",null,null,{"$f":"'9月'!H40","v":114998},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":0}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":114998},null,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":""},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},0]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":114998},null,"","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},0]
[null,null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),G10,\"\")","v":""},null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":114998},null,"","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":114998},null,"","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":114998},null,"","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":114998},null,"","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},0]
[null,null,{"$f":"IF(OR(LEFT(D14,1)=\"*\",LEFT(D14,1)=\"＊\"),G14,\"\")","v":""},null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":114998},null,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":114998},null,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":114998},null,"","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":114998},null,"","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":114998},null,"","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":114998},null,"","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":114998},null,"","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":114998},null,"","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":114998},null,"","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":114998},null,"","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":114998},null,"","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":114998},null,"","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":114998},null,"","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":114998},null,"","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":114998},null,"","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":114998},null,"","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":114998},null,"","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":114998},null,"","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":114998},null,"","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":114998},null,"","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":114998},null,"","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":114998},null,"","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":114998},null,"","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":114998},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":""},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":""}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":0},{"$f":"SUM(H$8:H37)","v":0}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":114998}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":114998}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":114998},{"$f":"SUM(H38:H40)","v":114998}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":0},{"$f":"H38-H45","v":0}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":0},{"$f":"$F$6","v":0}]

{"sheet":"11月","index":12,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7],[2,8,2,10]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},{"$f":"IF(L7=1,\"エラー(マイナス残高)です\",IF(L7=2,\"入金と出金は別行に記入してください\",\"\"))","v":""},null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"11 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":0},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('10月'!A7+1<=12,'10月'!A7+1,'10月'!A7+1-12)","v":11},1,{"$f":"SUM($C$8:C37)","v":0},null,null,"前月より繰越　　　",null,null,{"$f":"'10月'!H40","v":114998},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":0}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":114998},null,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":""},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},0]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":114998},null,"","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},0]
[null,null,"",null,null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),H10,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":114998},null,"","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},0]
[null,null,"",null,null,{"$f":"IF(OR(LEFT(D11,1)=\"*\",LEFT(D11,1)=\"＊\"),H11,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":114998},null,"","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":114998},null,"","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":114998},null,"","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":114998},null,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":114998},null,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":114998},null,"","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":114998},null,"","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":114998},null,"","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":114998},null,"","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":114998},null,"","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":114998},null,"","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":114998},null,"","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":114998},null,"","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":114998},null,"","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":114998},null,"","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":114998},null,"","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":114998},null,"","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":114998},null,"","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":114998},null,"","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":114998},null,"","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":114998},null,"","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":114998},null,"","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":114998},null,"","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":114998},null,"","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":114998},null,"","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":114998},null,"","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":114998},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":""},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":""}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":0},{"$f":"SUM(H$8:H37)","v":0}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":114998}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":114998}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":114998},{"$f":"SUM(H38:H40)","v":114998}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":0},{"$f":"H38-H45","v":0}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":0},{"$f":"$F$6","v":0}]

{"sheet":"12月","index":13,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,8,2,10],[2,13,2,14],[3,12,4,14],[3,0,3,10],[2,11,5,11],[2,4,2,7]]}
[]
[null,null,null,null,null,null," 月 度　 現  金　 出　 納　 帳"]
[null,null,null,{"$f":"'1月'!D3","v":2012},{"$f":"IF(L7=1,\"エラー(マイナス残高)です\",IF(L7=2,\"入金と出金は別行に記入してください\",\"\"))","v":""},null,null,null,{"$f":"'1月'!$I$3:$K$3","v":"わがやの家計簿"},null,null,"↓",null,"↓ 費 目 振 分 未 済"]
[{"$f":"A7&G2","v":"12 月 度　 現  金　 出　 納　 帳"},null,null,null,null,null,null,null,null,null,null,null,"費 目 別 集 計 表"]
[]
["月","日",null,"摘　　　　　　　　　要",null,{"$f":"SUM($F$8:F37)","v":0},"入　　金","出　　金","残　　高","№","費 目 名",null,"№","費 目 名","出金計"]
[{"$f":"IF('11月'!A7+1<=12,'11月'!A7+1,'11月'!A7+1-12)","v":12},1,{"$f":"SUM($C$8:C37)","v":0},null,null,"前月より繰越　　　",null,null,{"$f":"'11月'!H40","v":114998},"-","* * * * *",{"$f":"MAX(L8:L37)","v":0},{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUMIF(J$8:J$37,M7,H$8:H$37)","v":0}]
[null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),G8,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D8,1)=\"*\",LEFT(D8,1)=\"＊\"),H8,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G8)-SUM($H$8:H8)","v":114998},null,{"$f":"IF(J8<>0,VLOOKUP(J8,M$7:N$36,2,FALSE),\"\")","v":""},{"$f":"IF(I8<0,1,IF(AND(G8<>\"\",H8<>\"\"),2,\"\"))","v":""},{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},0]
[null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),G9,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D9,1)=\"*\",LEFT(D9,1)=\"＊\"),H9,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G9)-SUM($H$8:H9)","v":114998},null,"","",{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},0]
[null,null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),G10,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D10,1)=\"*\",LEFT(D10,1)=\"＊\"),H10,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G10)-SUM($H$8:H10)","v":114998},null,"","",{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},0]
[null,null,"",null,null,{"$f":"IF(OR(LEFT(D11,1)=\"*\",LEFT(D11,1)=\"＊\"),H11,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G11)-SUM($H$8:H11)","v":114998},null,"","",{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},0]
[null,null,"",null,null,{"$f":"IF(OR(LEFT(D12,1)=\"*\",LEFT(D12,1)=\"＊\"),H12,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G12)-SUM($H$8:H12)","v":114998},null,"","",{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G13)-SUM($H$8:H13)","v":114998},null,"","",{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G14)-SUM($H$8:H14)","v":114998},null,{"$f":"IF(J14<>0,VLOOKUP(J14,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G15)-SUM($H$8:H15)","v":114998},null,{"$f":"IF(J15<>0,VLOOKUP(J15,M$7:N$36,2,FALSE),\"\")","v":""},"",{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G16)-SUM($H$8:H16)","v":114998},null,"","",{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G17)-SUM($H$8:H17)","v":114998},null,"","",{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G18)-SUM($H$8:H18)","v":114998},null,"","",{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G19)-SUM($H$8:H19)","v":114998},null,"","",{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G20)-SUM($H$8:H20)","v":114998},null,"","",{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G21)-SUM($H$8:H21)","v":114998},null,"","",{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G22)-SUM($H$8:H22)","v":114998},null,"","",{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G23)-SUM($H$8:H23)","v":114998},null,"","",{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G24)-SUM($H$8:H24)","v":114998},null,"","",{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G25)-SUM($H$8:H25)","v":114998},null,"","",{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G26)-SUM($H$8:H26)","v":114998},null,"","",{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G27)-SUM($H$8:H27)","v":114998},null,"","",{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G28)-SUM($H$8:H28)","v":114998},null,"","",{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G29)-SUM($H$8:H29)","v":114998},null,"","",{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G30)-SUM($H$8:H30)","v":114998},null,"","",{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G31)-SUM($H$8:H31)","v":114998},null,"","",{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G32)-SUM($H$8:H32)","v":114998},null,"","",{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0]
[null,null,{"$f":"IF(OR(LEFT(D33,1)=\"*\",LEFT(D33,1)=\"＊\"),G33,\"\")","v":""},null,null,{"$f":"IF(OR(LEFT(D33,1)=\"*\",LEFT(D33,1)=\"＊\"),H33,\"\")","v":""},null,null,{"$f":"$I$7+SUM($G$8:G33)-SUM($H$8:H33)","v":114998},null,"","",{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G34)-SUM($H$8:H34)","v":114998},null,"","",{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G35)-SUM($H$8:H35)","v":114998},null,"","",{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G36)-SUM($H$8:H36)","v":114998},null,"","",{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},0]
[null,null,"",null,null,"",null,null,{"$f":"$I$7+SUM($G$8:G37)-SUM($H$8:H37)","v":114998},null,"","",null,{"$f":"IF(SUM(O7:O36)=0,\"\",\"合 計\")","v":""},{"$f":"IF(SUM(O7:O36)=0,\"\",SUM(O7:O36))","v":""}]
[null,null,"　自動振替処理が未済です",null,"月 　　計",null,{"$f":"SUM(G$8:G37)","v":0},{"$f":"SUM(H$8:H37)","v":0}]
[null,null,null,null,null,"前月残高　",{"$f":"I7","v":114998}]
[null,null,null,null,null,"当月残高　",null,{"$f":"I37","v":114998}]
[null,null,null,null,null,"合　　計　",{"$f":"SUM(G38:G40)","v":114998},{"$f":"SUM(H38:H40)","v":114998}]
[]
[null,null,null,null,null,"（月計の内訳）"]
[null,null,null,null,null,"現 　　　　金 ",{"$f":"G38-G45","v":0},{"$f":"H38-H45","v":0}]
[null,null,null,null,null,"預貯金振替 ",{"$f":"$C$7","v":0},{"$f":"$F$6","v":0}]

{"sheet":"年計","index":14,"n_rows":33,"n_cols":34,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,5,2,8],[1,10,32,10],[27,1,32,8],[7,8,8,8],[5,31,5,33],[3,1,3,8],[7,1,8,1],[7,2,7,3],[7,4,7,5],[7,6,7,7],[23,4,23,5],[5,1,6,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年","月","日","時","分","秒"]
[null,null,null,null,null,{"$f":"IF('1月'!I3=\"\",\"\",'1月'!I3)","v":"わがやの家計簿"},null,null,null,null,"　　　　費 目 別 集 計 表",null,"№","費　目　名","出　金　計",null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(AH4)","v":2018},{"$f":"MONTH(AH4)","v":3},{"$f":"DAY(AH4)","v":19},{"$f":"HOUR(AH4)","v":23},{"$f":"MINUTE(AH4)","v":22},{"$f":"SECOND(AH4)","v":32}]
[null,{"$f":"'1月'!D3","v":2012},null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUM('1月:12月'!O7)","v":304673},null,null,null,null,null,null,null,null,null,null,null,null,"会計年度　",null,{"$f":"'1月'!D3","v":2012},"年",null,"バックアップファイル名",{"$f":"AB5&\"-\"&AA2&\"-\"&AB2&\"-\"&AC2&\"-\"&AD2&\"-\"&AE2&\"-\"&AF2","v":"suitou01m-2018-3-19-23-22-32"}]
[null,"年　間　出　納　額　集　計　表",null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},{"$f":"SUM('1月:12月'!O8)","v":67016},null,null,null,null,null,null,null,null,null,null,null,null,"開始月　",null,1,"月",null,"バックアップ日付",{"$f":"NOW()","v":"2018-03-19T23:22:31.530"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},{"$f":"SUM('1月:12月'!O9)","v":375000},null,null,null,null,null,null,null,null,null,null,null,"このブック名","suitou01m",null,"BUブック名",{"$f":"AB5&AD3","v":"suitou01m2012"},null,"期末更新日付","2014-12-11T23:01:55"]
[null,"\n月 別 入 出 金 額 集 計 表",null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},{"$f":"SUM('1月:12月'!O10)","v":116350},null,null,null,null,null,null,null,null,null,null,null,"　　　　現在のシート名",null,null,"新 シート名","仮","入力規則用 末日"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},{"$f":"SUM('1月:12月'!O11)","v":25020}]
[null,"　　　入出金別\n　　\n　月　 別","現　金　出　納",null,"預貯金口座引落",null,"合　　　　　計",null,"残　　　高",null,null,null,{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},{"$f":"SUM('1月:12月'!O12)","v":104600},null,null,null,null,null,null,null,null,null,null,null,"sheet1",null,null,null,null,"末日","月末","年度"]
[null,null,"入　金　額","出　金　額","相殺記帳","引 落 等","入　金　額","出　金　額",null,null,null,null,{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},{"$f":"SUM('1月:12月'!O13)","v":124000},null,null,null,null,null,null,null,null,null,null,null,"sheet2",1,"月",{"$f":"AD4","v":1},{"$f":"AB10+20","v":22},{"$f":"DATEVALUE(AH9&\"/\"&AD10&\"/\"&1)-1","v":"2012-01-31"},{"$f":"DAY(AF9)","v":31},{"$f":"AD3","v":2012}]
[null,"前年度繰越","①","②","③","④","① ＋ ③","② ＋ ④",{"$f":"'1月'!I7","v":455346},null,null,null,{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},{"$f":"SUM('1月:12月'!O14)","v":57500},null,null,null,null,null,null,null,null,null,null,null,"sheet3",2,"月",{"$f":"IF(AD9+1>12,1,AD9+1)","v":2},23,{"$f":"DATEVALUE(AH10&\"/\"&AD11&\"/\"&1)-1","v":"2012-02-29"},29,{"$f":"IF(AD10<AD9,AH9+1,AH9)","v":2012}]
[null,{"$f":"AD9","v":1},{"$f":"G11-E11","v":46000},{"$f":"H11-F11","v":322825},{"$f":"'1月'!C7","v":41740},{"$f":"'1月'!F6","v":41740},{"$f":"'1月'!G70","v":87740},{"$f":"'1月'!H70","v":364565},{"$f":"I10+G11-H11","v":178521},null,null,null,{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},{"$f":"SUM('1月:12月'!O15)","v":63000},null,null,null,null,null,null,null,null,null,null,null,"sheet4",3,"月",{"$f":"IF(AD10+1>12,1,AD10+1)","v":3},24,"2012-03-31",31,{"$f":"IF(AD11<AD10,AH10+1,AH10)","v":2012}]
[null,{"$f":"AD10","v":2},{"$f":"G12-E12","v":384400},{"$f":"H12-F12","v":246780},{"$f":"'2月'!C7","v":41140},{"$f":"'2月'!F6","v":41140},{"$f":"'2月'!G38","v":425540},{"$f":"'2月'!H38","v":287920},316141,null,null,null,{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},{"$f":"SUM('1月:12月'!O16)","v":3670},null,null,null,null,null,null,null,null,null,null,null,"sheet5",4,"月",4,25,"2012-04-30",30,2012]
[null,3,286580,266813,{"$f":"'3月'!C7","v":43000},{"$f":"'3月'!F6","v":43000},{"$f":"'3月'!G38","v":329580},{"$f":"'3月'!H38","v":309813},335908,null,null,null,{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},{"$f":"SUM('1月:12月'!O17)","v":0},null,null,null,null,null,null,null,null,null,null,null,"sheet6",5,"月",5,26,"2012-05-31",31,2012]
[null,4,136690,306910,{"$f":"'4月'!C7","v":40130},{"$f":"'4月'!F6","v":40130},{"$f":"'4月'!G38","v":176820},{"$f":"'4月'!H38","v":347040},165688,null,null,null,{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},{"$f":"SUM('1月:12月'!O18)","v":66500},null,null,null,null,null,null,null,null,null,null,null,"sheet7",6,"月",6,27,"2012-06-30",30,2012]
[null,5,136800,187490,{"$f":"'5月'!C7","v":43010},{"$f":"'5月'!F6","v":43010},{"$f":"'5月'!G38","v":179810},{"$f":"'5月'!H38","v":230500},114998,null,null,null,{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},{"$f":"SUM('1月:12月'!O19)","v":0},null,null,null,null,null,null,null,null,null,null,null,"sheet8",7,"月",7,28,"2012-07-31",31,2012]
[null,6,0,0,{"$f":"'6月'!C7","v":0},{"$f":"'6月'!F6","v":0},{"$f":"'6月'!G38","v":0},{"$f":"'6月'!H38","v":0},114998,null,null,null,{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},{"$f":"SUM('1月:12月'!O20)","v":0},null,null,null,null,null,null,null,null,null,null,null,"sheet9",8,"月",8,29,"2012-08-31",31,2012]
[null,7,0,0,{"$f":"'7月'!C7","v":0},{"$f":"'7月'!F6","v":0},{"$f":"'7月'!G38","v":0},{"$f":"'7月'!H38","v":0},114998,null,null,null,{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},{"$f":"SUM('1月:12月'!O21)","v":0},null,null,null,null,null,null,null,null,null,null,null,"sheet10",9,"月",9,30,"2012-09-30",30,2012]
[null,8,0,0,{"$f":"'8月'!C7","v":0},{"$f":"'8月'!F6","v":0},{"$f":"'8月'!G38","v":0},{"$f":"'8月'!H38","v":0},114998,null,null,null,{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},{"$f":"SUM('1月:12月'!O22)","v":0},null,null,null,null,null,null,null,null,null,null,null,"sheet11",10,"月",10,31,{"$f":"DATEVALUE(AH18&\"/\"&AD19&\"/\"&1)-1","v":"2012-10-31"},31,2012]
[null,9,0,0,{"$f":"'9月'!C7","v":0},{"$f":"'9月'!F6","v":0},{"$f":"'9月'!G38","v":0},{"$f":"'9月'!H38","v":0},114998,null,null,null,{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},{"$f":"SUM('1月:12月'!O23)","v":34300},null,null,null,null,null,null,null,null,null,null,null,"sheet12",11,"月",11,32,"2012-11-30",30,2012]
[null,10,0,0,{"$f":"'10月'!C7","v":0},{"$f":"'10月'!F6","v":0},{"$f":"'10月'!G38","v":0},{"$f":"'10月'!H38","v":0},114998,null,null,null,{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},{"$f":"SUM('1月:12月'!O24)","v":1703},null,null,null,null,null,null,null,null,null,null,null,"sheet13",12,"月",12,20,{"$f":"DATEVALUE(AH20&\"/\"&AD21&\"/\"&1)-1","v":"2011-12-31"},31,2012]
[null,11,0,0,{"$f":"'11月'!C7","v":0},{"$f":"'11月'!F6","v":0},{"$f":"'11月'!G38","v":0},{"$f":"'11月'!H38","v":0},114998,null,null,null,{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},{"$f":"SUM('1月:12月'!O25)","v":3700},null,null,null,null,null,null,null,null,null,null,null,"sheet14",null,null,1]
[null,12,0,0,{"$f":"'12月'!C7","v":0},{"$f":"'12月'!F6","v":0},{"$f":"'12月'!G38","v":0},{"$f":"'12月'!H38","v":0},114998,null,null,null,{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},{"$f":"SUM('1月:12月'!O26)","v":39203}]
[null,"計　",{"$f":"SUM(C11:C22)","v":990470},1330818,209020,209020,1199490,1539838,null,null,null,null,{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},{"$f":"SUM('1月:12月'!O27)","v":0}]
[null,"前年度繰越",null,null,"金　額　違　算",null,{"$f":"I10","v":455346},null,null,null,null,null,{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},{"$f":"SUM('1月:12月'!O28)","v":0}]
[null,"次年度繰越",null,null,null,null,null,{"$f":"I22","v":114998},null,null,null,null,{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},{"$f":"SUM('1月:12月'!O29)","v":0}]
[null,"合　　　計",null,null,null,null,{"$f":"SUM(G23:G25)","v":1654836},{"$f":"SUM(H23:H25)","v":1654836},null,null,null,null,{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},{"$f":"SUM('1月:12月'!O30)","v":0}]
[null,"（備　考）",null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},{"$f":"SUM('1月:12月'!O31)","v":0}]
[null,"（ここに記事を入力してください。）\nこの文字は Delete キーで消去できます。",null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},{"$f":"SUM('1月:12月'!O32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},{"$f":"SUM('1月:12月'!O33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},{"$f":"SUM('1月:12月'!O34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},{"$f":"SUM('1月:12月'!O35)","v":3603}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},{"$f":"SUM('1月:12月'!O36)","v":150000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(O3:O32)=0,\"\",\"合　　 計\")","v":"合　　 計"},{"$f":"SUM('1月:12月'!O37)","v":1539838}]

{"sheet":"費目毎月別集計表","index":15,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'1月'!D3","v":2012},null,null,null,null,null,null,null,null,null,null,{"$f":"'1月'!I3","v":"わがやの家計簿"}]
[null,null,null,null,null,null,null,"出 金 項 目 毎 月 別 集 計 表"]
[]
["№","費　目　名","年　　計",{"$f":"年計!AD9","v":1},{"$f":"年計!AD10","v":2},{"$f":"年計!AD11","v":3},{"$f":"年計!AD12","v":4},{"$f":"年計!AD13","v":5},{"$f":"年計!AD14","v":6},{"$f":"年計!AD15","v":7},{"$f":"年計!AD16","v":8},{"$f":"年計!AD17","v":9},{"$f":"年計!AD18","v":10},{"$f":"年計!AD19","v":11},{"$f":"年計!AD20","v":12}]
[{"$f":"'1月'!M7","v":1},{"$f":"'1月'!N7","v":"食材飲料費"},{"$f":"SUM(D5:O5)","v":304673},{"$f":"'1月'!O7","v":81941},{"$f":"'2月'!O7","v":45710},{"$f":"'3月'!O7","v":59436},{"$f":"'4月'!O7","v":76512},{"$f":"'5月'!O7","v":41074},{"$f":"'6月'!O7","v":0},{"$f":"'7月'!O7","v":0},{"$f":"'8月'!O7","v":0},{"$f":"'9月'!O7","v":0},{"$f":"'10月'!O7","v":0},{"$f":"'11月'!O7","v":0},{"$f":"'12月'!O7","v":0}]
[{"$f":"'1月'!M8","v":2},{"$f":"'1月'!N8","v":"外食費"},{"$f":"SUM(D6:O6)","v":67016},{"$f":"'1月'!O8","v":8340},{"$f":"'2月'!O8","v":24360},{"$f":"'3月'!O8","v":13540},{"$f":"'4月'!O8","v":0},{"$f":"'5月'!O8","v":20776},{"$f":"'6月'!O8","v":0},{"$f":"'7月'!O8","v":0},{"$f":"'8月'!O8","v":0},{"$f":"'9月'!O8","v":0},{"$f":"'10月'!O8","v":0},{"$f":"'11月'!O8","v":0},{"$f":"'12月'!O8","v":0}]
[{"$f":"'1月'!M9","v":3},{"$f":"'1月'!N9","v":"住居費"},375000,{"$f":"'1月'!O9","v":75000},{"$f":"'2月'!O9","v":75000},{"$f":"'3月'!O9","v":75000},{"$f":"'4月'!O9","v":75000},{"$f":"'5月'!O9","v":75000},{"$f":"'6月'!O9","v":0},{"$f":"'7月'!O9","v":0},{"$f":"'8月'!O9","v":0},{"$f":"'9月'!O9","v":0},{"$f":"'10月'!O9","v":0},{"$f":"'11月'!O9","v":0},{"$f":"'12月'!O9","v":0}]
[{"$f":"'1月'!M10","v":4},{"$f":"'1月'!N10","v":"水道光熱費"},116350,{"$f":"'1月'!O10","v":25350},{"$f":"'2月'!O10","v":22070},{"$f":"'3月'!O10","v":23930},{"$f":"'4月'!O10","v":21060},{"$f":"'5月'!O10","v":23940},{"$f":"'6月'!O10","v":0},{"$f":"'7月'!O10","v":0},{"$f":"'8月'!O10","v":0},{"$f":"'9月'!O10","v":0},{"$f":"'10月'!O10","v":0},{"$f":"'11月'!O10","v":0},{"$f":"'12月'!O10","v":0}]
[{"$f":"'1月'!M11","v":5},{"$f":"'1月'!N11","v":"被服費"},25020,{"$f":"'1月'!O11","v":17490},{"$f":"'2月'!O11","v":0},{"$f":"'3月'!O11","v":7530},{"$f":"'4月'!O11","v":0},{"$f":"'5月'!O11","v":0},{"$f":"'6月'!O11","v":0},{"$f":"'7月'!O11","v":0},{"$f":"'8月'!O11","v":0},{"$f":"'9月'!O11","v":0},{"$f":"'10月'!O11","v":0},{"$f":"'11月'!O11","v":0},{"$f":"'12月'!O11","v":0}]
[{"$f":"'1月'!M12","v":6},{"$f":"'1月'!N12","v":"教育費"},104600,{"$f":"'1月'!O12","v":23000},{"$f":"'2月'!O12","v":35600},{"$f":"'3月'!O12","v":23000},{"$f":"'4月'!O12","v":0},{"$f":"'5月'!O12","v":23000},{"$f":"'6月'!O12","v":0},{"$f":"'7月'!O12","v":0},{"$f":"'8月'!O12","v":0},{"$f":"'9月'!O12","v":0},{"$f":"'10月'!O12","v":0},{"$f":"'11月'!O12","v":0},{"$f":"'12月'!O12","v":0}]
[{"$f":"'1月'!M13","v":7},{"$f":"'1月'!N13","v":"お小遣い"},124000,{"$f":"'1月'!O13","v":31000},{"$f":"'2月'!O13","v":23000},{"$f":"'3月'!O13","v":24000},{"$f":"'4月'!O13","v":23000},{"$f":"'5月'!O13","v":23000},{"$f":"'6月'!O13","v":0},{"$f":"'7月'!O13","v":0},{"$f":"'8月'!O13","v":0},{"$f":"'9月'!O13","v":0},{"$f":"'10月'!O13","v":0},{"$f":"'11月'!O13","v":0},{"$f":"'12月'!O13","v":0}]
[{"$f":"'1月'!M14","v":8},{"$f":"'1月'!N14","v":"通信ＩＴ費"},57500,{"$f":"'1月'!O14","v":6220},{"$f":"'2月'!O14","v":7070},{"$f":"'3月'!O14","v":7070},{"$f":"'4月'!O14","v":30070},{"$f":"'5月'!O14","v":7070},{"$f":"'6月'!O14","v":0},{"$f":"'7月'!O14","v":0},{"$f":"'8月'!O14","v":0},{"$f":"'9月'!O14","v":0},{"$f":"'10月'!O14","v":0},{"$f":"'11月'!O14","v":0},{"$f":"'12月'!O14","v":0}]
[{"$f":"'1月'!M15","v":9},{"$f":"'1月'!N15","v":"交際費"},63000,{"$f":"'1月'!O15","v":0},{"$f":"'2月'!O15","v":10000},{"$f":"'3月'!O15","v":3000},{"$f":"'4月'!O15","v":50000},{"$f":"'5月'!O15","v":0},{"$f":"'6月'!O15","v":0},{"$f":"'7月'!O15","v":0},{"$f":"'8月'!O15","v":0},{"$f":"'9月'!O15","v":0},{"$f":"'10月'!O15","v":0},{"$f":"'11月'!O15","v":0},{"$f":"'12月'!O15","v":0}]
[{"$f":"'1月'!M16","v":10},{"$f":"'1月'!N16","v":"趣味娯楽費"},3670,{"$f":"'1月'!O16","v":0},{"$f":"'2月'!O16","v":0},{"$f":"'3月'!O16","v":3670},{"$f":"'4月'!O16","v":0},{"$f":"'5月'!O16","v":0},{"$f":"'6月'!O16","v":0},{"$f":"'7月'!O16","v":0},{"$f":"'8月'!O16","v":0},{"$f":"'9月'!O16","v":0},{"$f":"'10月'!O16","v":0},{"$f":"'11月'!O16","v":0},{"$f":"'12月'!O16","v":0}]
[{"$f":"'1月'!M17","v":11},{"$f":"'1月'!N17","v":"社会保険料"},0,{"$f":"'1月'!O17","v":0},{"$f":"'2月'!O17","v":0},{"$f":"'3月'!O17","v":0},{"$f":"'4月'!O17","v":0},{"$f":"'5月'!O17","v":0},{"$f":"'6月'!O17","v":0},{"$f":"'7月'!O17","v":0},{"$f":"'8月'!O17","v":0},{"$f":"'9月'!O17","v":0},{"$f":"'10月'!O17","v":0},{"$f":"'11月'!O17","v":0},{"$f":"'12月'!O17","v":0}]
[{"$f":"'1月'!M18","v":12},{"$f":"'1月'!N18","v":"其他保険料"},66500,{"$f":"'1月'!O18","v":18500},{"$f":"'2月'!O18","v":12000},{"$f":"'3月'!O18","v":12000},{"$f":"'4月'!O18","v":12000},{"$f":"'5月'!O18","v":12000},{"$f":"'6月'!O18","v":0},{"$f":"'7月'!O18","v":0},{"$f":"'8月'!O18","v":0},{"$f":"'9月'!O18","v":0},{"$f":"'10月'!O18","v":0},{"$f":"'11月'!O18","v":0},{"$f":"'12月'!O18","v":0}]
[{"$f":"'1月'!M19","v":13},{"$f":"'1月'!N19","v":"保健医療費"},0,{"$f":"'1月'!O19","v":0},{"$f":"'2月'!O19","v":0},{"$f":"'3月'!O19","v":0},{"$f":"'4月'!O19","v":0},{"$f":"'5月'!O19","v":0},{"$f":"'6月'!O19","v":0},{"$f":"'7月'!O19","v":0},{"$f":"'8月'!O19","v":0},{"$f":"'9月'!O19","v":0},{"$f":"'10月'!O19","v":0},{"$f":"'11月'!O19","v":0},{"$f":"'12月'!O19","v":0}]
[{"$f":"'1月'!M20","v":14},{"$f":"'1月'!N20","v":"税金"},0,{"$f":"'1月'!O20","v":0},{"$f":"'2月'!O20","v":0},{"$f":"'3月'!O20","v":0},{"$f":"'4月'!O20","v":0},{"$f":"'5月'!O20","v":0},{"$f":"'6月'!O20","v":0},{"$f":"'7月'!O20","v":0},{"$f":"'8月'!O20","v":0},{"$f":"'9月'!O20","v":0},{"$f":"'10月'!O20","v":0},{"$f":"'11月'!O20","v":0},{"$f":"'12月'!O20","v":0}]
[{"$f":"'1月'!M21","v":15},{"$f":"'1月'!N21","v":"交通費"},0,{"$f":"'1月'!O21","v":0},{"$f":"'2月'!O21","v":0},{"$f":"'3月'!O21","v":0},{"$f":"'4月'!O21","v":0},{"$f":"'5月'!O21","v":0},{"$f":"'6月'!O21","v":0},{"$f":"'7月'!O21","v":0},{"$f":"'8月'!O21","v":0},{"$f":"'9月'!O21","v":0},{"$f":"'10月'!O21","v":0},{"$f":"'11月'!O21","v":0},{"$f":"'12月'!O21","v":0}]
[{"$f":"'1月'!M22","v":16},{"$f":"'1月'!N22","v":"支払手数料"},0,{"$f":"'1月'!O22","v":0},{"$f":"'2月'!O22","v":0},{"$f":"'3月'!O22","v":0},{"$f":"'4月'!O22","v":0},{"$f":"'5月'!O22","v":0},{"$f":"'6月'!O22","v":0},{"$f":"'7月'!O22","v":0},{"$f":"'8月'!O22","v":0},{"$f":"'9月'!O22","v":0},{"$f":"'10月'!O22","v":0},{"$f":"'11月'!O22","v":0},{"$f":"'12月'!O22","v":0}]
[{"$f":"'1月'!M23","v":17},{"$f":"'1月'!N23","v":"雑貨日用品"},34300,{"$f":"'1月'!O23","v":10400},{"$f":"'2月'!O23","v":23900},{"$f":"'3月'!O23","v":0},{"$f":"'4月'!O23","v":0},{"$f":"'5月'!O23","v":0},{"$f":"'6月'!O23","v":0},{"$f":"'7月'!O23","v":0},{"$f":"'8月'!O23","v":0},{"$f":"'9月'!O23","v":0},{"$f":"'10月'!O23","v":0},{"$f":"'11月'!O23","v":0},{"$f":"'12月'!O23","v":0}]
[{"$f":"'1月'!M24","v":18},{"$f":"'1月'!N24","v":"消耗品費"},1703,{"$f":"'1月'!O24","v":165},{"$f":"'2月'!O24","v":670},{"$f":"'3月'!O24","v":0},{"$f":"'4月'!O24","v":868},{"$f":"'5月'!O24","v":0},{"$f":"'6月'!O24","v":0},{"$f":"'7月'!O24","v":0},{"$f":"'8月'!O24","v":0},{"$f":"'9月'!O24","v":0},{"$f":"'10月'!O24","v":0},{"$f":"'11月'!O24","v":0},{"$f":"'12月'!O24","v":0}]
[{"$f":"'1月'!M25","v":19},{"$f":"'1月'!N25","v":"冠婚葬祭費"},3700,{"$f":"'1月'!O25","v":3700},{"$f":"'2月'!O25","v":0},{"$f":"'3月'!O25","v":0},{"$f":"'4月'!O25","v":0},{"$f":"'5月'!O25","v":0},{"$f":"'6月'!O25","v":0},{"$f":"'7月'!O25","v":0},{"$f":"'8月'!O25","v":0},{"$f":"'9月'!O25","v":0},{"$f":"'10月'!O25","v":0},{"$f":"'11月'!O25","v":0},{"$f":"'12月'!O25","v":0}]
[{"$f":"'1月'!M26","v":20},{"$f":"'1月'!N26","v":"車両費"},39203,{"$f":"'1月'!O26","v":9859},{"$f":"'2月'!O26","v":8540},{"$f":"'3月'!O26","v":7634},{"$f":"'4月'!O26","v":8530},{"$f":"'5月'!O26","v":4640},{"$f":"'6月'!O26","v":0},{"$f":"'7月'!O26","v":0},{"$f":"'8月'!O26","v":0},{"$f":"'9月'!O26","v":0},{"$f":"'10月'!O26","v":0},{"$f":"'11月'!O26","v":0},{"$f":"'12月'!O26","v":0}]
[{"$f":"'1月'!M27","v":21},{"$f":"'1月'!N27","v":"雑費"},0,{"$f":"'1月'!O27","v":0},{"$f":"'2月'!O27","v":0},{"$f":"'3月'!O27","v":0},{"$f":"'4月'!O27","v":0},{"$f":"'5月'!O27","v":0},{"$f":"'6月'!O27","v":0},{"$f":"'7月'!O27","v":0},{"$f":"'8月'!O27","v":0},{"$f":"'9月'!O27","v":0},{"$f":"'10月'!O27","v":0},{"$f":"'11月'!O27","v":0},{"$f":"'12月'!O27","v":0}]
[{"$f":"'1月'!M28","v":22},{"$f":"'1月'!N28","v":0},0,{"$f":"'1月'!O28","v":0},{"$f":"'2月'!O28","v":0},{"$f":"'3月'!O28","v":0},{"$f":"'4月'!O28","v":0},{"$f":"'5月'!O28","v":0},{"$f":"'6月'!O28","v":0},{"$f":"'7月'!O28","v":0},{"$f":"'8月'!O28","v":0},{"$f":"'9月'!O28","v":0},{"$f":"'10月'!O28","v":0},{"$f":"'11月'!O28","v":0},{"$f":"'12月'!O28","v":0}]
[{"$f":"'1月'!M29","v":23},{"$f":"'1月'!N29","v":0},0,{"$f":"'1月'!O29","v":0},{"$f":"'2月'!O29","v":0},{"$f":"'3月'!O29","v":0},{"$f":"'4月'!O29","v":0},{"$f":"'5月'!O29","v":0},{"$f":"'6月'!O29","v":0},{"$f":"'7月'!O29","v":0},{"$f":"'8月'!O29","v":0},{"$f":"'9月'!O29","v":0},{"$f":"'10月'!O29","v":0},{"$f":"'11月'!O29","v":0},{"$f":"'12月'!O29","v":0}]
[{"$f":"'1月'!M30","v":24},{"$f":"'1月'!N30","v":0},0,{"$f":"'1月'!O30","v":0},{"$f":"'2月'!O30","v":0},{"$f":"'3月'!O30","v":0},{"$f":"'4月'!O30","v":0},{"$f":"'5月'!O30","v":0},{"$f":"'6月'!O30","v":0},{"$f":"'7月'!O30","v":0},{"$f":"'8月'!O30","v":0},{"$f":"'9月'!O30","v":0},{"$f":"'10月'!O30","v":0},{"$f":"'11月'!O30","v":0},{"$f":"'12月'!O30","v":0}]
[{"$f":"'1月'!M31","v":25},{"$f":"'1月'!N31","v":0},0,{"$f":"'1月'!O31","v":0},{"$f":"'2月'!O31","v":0},{"$f":"'3月'!O31","v":0},{"$f":"'4月'!O31","v":0},{"$f":"'5月'!O31","v":0},{"$f":"'6月'!O31","v":0},{"$f":"'7月'!O31","v":0},{"$f":"'8月'!O31","v":0},{"$f":"'9月'!O31","v":0},{"$f":"'10月'!O31","v":0},{"$f":"'11月'!O31","v":0},{"$f":"'12月'!O31","v":0}]
[{"$f":"'1月'!M32","v":26},{"$f":"'1月'!N32","v":0},0,{"$f":"'1月'!O32","v":0},{"$f":"'2月'!O32","v":0},{"$f":"'3月'!O32","v":0},{"$f":"'4月'!O32","v":0},{"$f":"'5月'!O32","v":0},{"$f":"'6月'!O32","v":0},{"$f":"'7月'!O32","v":0},{"$f":"'8月'!O32","v":0},{"$f":"'9月'!O32","v":0},{"$f":"'10月'!O32","v":0},{"$f":"'11月'!O32","v":0},{"$f":"'12月'!O32","v":0}]
[{"$f":"'1月'!M33","v":27},{"$f":"'1月'!N33","v":0},0,{"$f":"'1月'!O33","v":0},{"$f":"'2月'!O33","v":0},{"$f":"'3月'!O33","v":0},{"$f":"'4月'!O33","v":0},{"$f":"'5月'!O33","v":0},{"$f":"'6月'!O33","v":0},{"$f":"'7月'!O33","v":0},{"$f":"'8月'!O33","v":0},{"$f":"'9月'!O33","v":0},{"$f":"'10月'!O33","v":0},{"$f":"'11月'!O33","v":0},{"$f":"'12月'!O33","v":0}]
[{"$f":"'1月'!M34","v":28},{"$f":"'1月'!N34","v":0},0,{"$f":"'1月'!O34","v":0},{"$f":"'2月'!O34","v":0},{"$f":"'3月'!O34","v":0},{"$f":"'4月'!O34","v":0},{"$f":"'5月'!O34","v":0},{"$f":"'6月'!O34","v":0},{"$f":"'7月'!O34","v":0},{"$f":"'8月'!O34","v":0},{"$f":"'9月'!O34","v":0},{"$f":"'10月'!O34","v":0},{"$f":"'11月'!O34","v":0},{"$f":"'12月'!O34","v":0}]
[{"$f":"'1月'!M35","v":29},{"$f":"'1月'!N35","v":"使途不明金"},3603,{"$f":"'1月'!O35","v":3600},{"$f":"'2月'!O35","v":0},{"$f":"'3月'!O35","v":3},{"$f":"'4月'!O35","v":0},{"$f":"'5月'!O35","v":0},{"$f":"'6月'!O35","v":0},{"$f":"'7月'!O35","v":0},{"$f":"'8月'!O35","v":0},{"$f":"'9月'!O35","v":0},{"$f":"'10月'!O35","v":0},{"$f":"'11月'!O35","v":0},{"$f":"'12月'!O35","v":0}]
[null,"費　用　計",{"$f":"SUM(C5:C33)","v":1389838},{"$f":"SUM(D5:D33)","v":314565},{"$f":"SUM(E5:E33)","v":287920},{"$f":"SUM(F5:F33)","v":259813},297040,230500,0,0,0,0,0,0,{"$f":"SUM(O5:O33)","v":0}]
[{"$f":"'1月'!M36","v":30},{"$f":"'1月'!N36","v":"その他"},150000,{"$f":"'1月'!O36","v":50000},{"$f":"'2月'!O36","v":0},{"$f":"'3月'!O36","v":50000},{"$f":"'4月'!O36","v":50000},{"$f":"'5月'!O36","v":0},{"$f":"'6月'!O36","v":0},{"$f":"'7月'!O36","v":0},{"$f":"'8月'!O36","v":0},{"$f":"'9月'!O36","v":0},{"$f":"'10月'!O36","v":0},{"$f":"'11月'!O36","v":0},{"$f":"'12月'!O36","v":0}]
[null,"出金総計",{"$f":"C34+C35","v":1539838},{"$f":"D34+D35","v":364565},287920,309813,347040,230500,0,0,0,0,0,0,0]

{"sheet":"費目名参考","index":16,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"　費　目　名　参　考　資　料"]
[null,"要は、自分が分かるような、納得のいくような費目にすることがベストだと思います。"]
[]
[null,"旅費交通費",null,"給料手当",null,"食　材　費",null,"主　食　費"]
[null,"通　信　費",null,"雑　　　給",null,"外　食　費",null,"副　食　費"]
[null,"車　両　費",null,"賞　　　与",null,"嗜 好 品 費"]
[null,"交　際　費",null,"退　職　金",null,"住　居　費"]
[null,"諸　会　費",null,"法定福利費",null,"水道光熱費"]
[null,"広告宣伝費",null,"福利厚生費",null,"被　服　費"]
[null,"保　険　料",null,"会　議　費",null,"車　両　費"]
[null,"修　繕　費",null,"賃　借　料",null,"交　通　費"]
[null,"水道光熱費",null,"リース料",null,"医療衛生費"]
[null,"事務費",null,"試験研究費",null,"教　育　費"]
[null,"消耗品費",null,"減価償却費",null,"教養娯楽費"]
[null,"新聞図書費",null,null,null,"交際慶弔費"]
[null,"租税公課",null,null,null,"通　信　費"]
[null,"支払手数料",null,"期首商品たな卸高",null,"保　険　料"]
[null,"支払利息",null,"期末商品たな卸高",null,"納　税　費"]
[null,"雑　　　費",null,"仕　　　入",null,"家　財　費"]
[null,"現金過不足",null,null,null,"貯　蓄　費"]
[null,"振り分け未済",null,null,null,"雑　　　費"]