{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["決算","グラフ","メニュー","1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"],"not_rendered":{"charts":4,"images":12,"macros":1,"external_links":0,"defined_names":1,"comments":12,"pivot_tables":0},"unopened":[],"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":0,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,1,24,1],[24,2,24,3],[25,1,25,3],[0,1,0,3],[2,1,5,1],[5,2,5,3],[7,1,14,1],[14,2,14,3],[1,2,1,3]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\"),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年メニュー"}]
[null,null,null,null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
[null,"収入",null,"夫収入",{"$f":"INDIRECT(E$2&\"!E\"&ROW()+1)","v":0},{"$f":"INDIRECT(F$2&\"!E\"&ROW()+1)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"妻収入",{"$f":"INDIRECT(E$2&\"!E\"&ROW()+1)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"その他収入",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"収入合計",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"固定支出",null,"家賃",{"$f":"INDIRECT(E$2&\"!L\"&ROW()+1)","v":0},{"$f":"INDIRECT(F$2&\"!L\"&ROW()+1)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"夫現金費",{"$f":"INDIRECT(E$2&\"!L\"&ROW()+1)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"妻現金費",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"保育料",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"保険料（積立）",0,0,0,0,0,0,0,{"$f":"INDIRECT(L$2&\"!L\"&ROW()+1)","v":0},0,0,0,0]
[null,null,null,"医療費（積立）",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"水道費",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"固定支出合計",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"変動支出",null,"貯蓄",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"流動的貯金",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"生活費①（手持ち）",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"生活費②（口座）",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"ガソリン費",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"通信費",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"光熱費",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"移動費",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"予備費",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"変動支出合計",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"支出合計",null,null,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"グラフ","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"メニュー","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,13],[17,1,17,13],[3,1,3,3],[3,4,3,6],[3,7,3,9]]}
[]
[null,"家計管理メニュー"]
[]
[null,"会計年度：",null,null,2016,null,null,"年（西暦）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"決算・集計"]

{"sheet":"1月","index":3,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,8,6,13],[8,1,15,1],[8,8,15,8],[15,9,15,10],[15,2,15,3],[6,2,6,3],[16,1,25,1],[16,8,25,8],[26,1,26,3],[26,8,26,10],[25,9,25,10],[25,2,25,3]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年m]1月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"2月","index":4,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年m]2月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"3月","index":5,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年m]3月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"4月","index":6,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年m]4月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"5月","index":7,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年m]5月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"6月","index":8,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年m]6月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"7月","index":9,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年m]7月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"8月","index":10,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年m]8月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"9月","index":11,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年m]9月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"10月","index":12,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年]10月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"11月","index":13,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年]11月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]

{"sheet":"12月","index":14,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,15,1],[8,8,15,8],[15,2,15,3],[15,9,15,10],[0,1,0,3],[1,1,1,6],[3,1,6,1],[6,2,6,3],[6,8,6,13],[16,1,25,1],[16,8,25,8],[25,2,25,3],[25,9,25,10],[26,1,26,3],[26,8,26,10]]}
[null,{"$f":"メニュー!E4&\"年\"&RIGHT(CELL(\"filename\",A2),\nLEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))","v":"2016年]12月"}]
[null,"予　算"]
[]
[null,"収入",null,"夫収入",null,{"$f":"E4/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻収入",null,{"$f":"E5/$E$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"その他収入",null,{"$error":"#DIV/0!"}]
[null,null,"収入合計",null,{"$f":"SUM(E4:E6)","v":0},{"$error":"#DIV/0!"},null,null,"決　　算"]
[null,null,null,null,null,null,null,null,null,null,"項目","金額","支出割合","予算との比較"]
[null,"固定支出",null,"家賃",null,{"$f":"E9/$E$7","v":{"$error":"#DIV/0!"}},"夫SBI",null,"固定支出",null,"家賃",{"$f":"E9","v":0},{"$f":"L9/$E$7","v":{"$error":"#DIV/0!"}},{"$f":"E9/L9-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"夫現金費",null,{"$f":"E10/$E$7","v":{"$error":"#DIV/0!"}},"現金",null,null,null,"夫現金費",0,{"$error":"#DIV/0!"},{"$f":"E10/L10-1","v":{"$error":"#DIV/0!"}}]
[null,null,null,"妻現金費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"妻現金費",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保育料",null,{"$error":"#DIV/0!"},"天引き",null,null,null,"保育園料",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"保険料（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"保険料（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"医療費（積立）",null,{"$error":"#DIV/0!"},"現金",null,null,null,"医療費（積立）",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"水道費",null,{"$error":"#DIV/0!"},"現金",null,null,null,"水道費",0,{"$f":"L15/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"固定支出合計",null,{"$f":"SUM(E9:E15)","v":0},{"$f":"E16/E7","v":{"$error":"#DIV/0!"}},null,null,null,"固定支出合計",null,0,{"$f":"L16/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"変動支出",null,"貯蓄",{"$f":"ROUND($E$7*F17,-3)","v":0},0.1,"妻SBI",null,"変動支出",null,"貯蓄",null,{"$f":"L17/$E$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,"流動的貯金",{"$f":"ROUND($E$7*F18,-3)","v":0},0.11,"夫SBI",null,null,null,"流動的貯金",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費①（手持ち）",0,0.05,"現金",null,null,null,"生活費①（手持ち）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"生活費②（口座）",0,0.02,"夫SBI",null,null,null,"生活費②（口座）",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"ガソリン費",0,0.02,"現金",null,null,null,"ガソリン費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"通信費",0,0.03,"夫SBI",null,null,null,"通信費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"光熱費",0,0.1,"夫SBI",null,null,null,"光熱費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"移動費",0,7.0000000000000007E-2,"夫SBI",null,null,null,"移動費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"予備費",{"$f":"E7-(E16+SUM(E17:E24))","v":0},{"$f":"E25/E7","v":{"$error":"#DIV/0!"}},"現金　未使用分は夫SBIへ",null,null,null,"予備費",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"変動支出合計",null,{"$f":"SUM(E17:E25)","v":0},null,null,null,null,"変動支出合計",null,{"$f":"SUM(L17:L25)","v":0}]
[null,"支出合計",null,null,{"$f":"E16+E26","v":0},{"$f":"E27/E7","v":{"$error":"#DIV/0!"}},null,null,"支出合計",null,null,{"$f":"L16+L26","v":0},{"$f":"L27/E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M27>1,\"予算オーバー\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"振り分け金額"]
[null,null,null,"現金","妻SBI"]
[null,null,null,{"$f":"(SUMIF(G9:G25,\"現金\",E9:E25))+E25","v":0},{"$f":"E7-D31-E12","v":0}]
[]
[]
[]
[null,null,null,null,"夫SBI"]
[null,null,null,null,{"$f":"SUMIF(G9:G25,\"夫SBI\",E9:E25)","v":0}]