{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["ダッシュボード","予算","設定","グラフ データ"],"not_rendered":{"charts":2,"images":3,"defined_names":42},"read":"whole","date_system":"1900"}

{"sheet":"ダッシュボード","index":0,"n_rows":13,"n_cols":14,"rows_kept":13,"merged":[[2,0,4,2],[6,0,8,2],[10,0,12,2]]}
[{"$nulls":13},{"$f":"BudgetName&\" の収支\"","v":"青木家 2012 年 の収支"}]
[]
[{"$f":"'グラフ データ'!C38","v":{"v":400000,"d":"¥400,000"}}]
[]
[{"$nulls":3},"収入"]
[]
[{"$f":"'グラフ データ'!C39","v":{"v":593300,"d":"¥593,300"}}]
[]
[{"$nulls":3},"支出"]
[]
[{"$f":"-'グラフ データ'!C40","v":{"v":-193300,"d":"-¥193,300"}}]
[]
[{"$nulls":3},"キャッシュ フロー"]

{"sheet":"予算","index":1,"n_rows":131,"n_cols":16,"rows_kept":131}
[null,null,"1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年","平均"]
[]
[]
[]
[null,"開始残高",{"v":100000,"d":"100,000"}]
[null,"総収入",{"$f":"SUM(tblIncome[jan])","v":{"v":422200,"d":"422,200"}},{"$f":"SUM(tblIncome[feb])","v":{"v":903300,"d":"903,300"}},{"$f":"SUM(tblIncome[mar])","v":{"v":400000,"d":"400,000"}},{"$f":"SUM(tblIncome[apr])","v":{"v":404500,"d":"404,500"}},{"$f":"SUM(tblIncome[may])","v":{"v":900000,"d":"900,000"}},{"$f":"SUM(tblIncome[jun])","v":{"v":152500,"d":"152,500"}},{"$f":"SUM(tblIncome[jul])","v":{"v":150000,"d":"150,000"}},{"$f":"SUM(tblIncome[aug])","v":{"v":650000,"d":"650,000"}},{"$f":"SUM(tblIncome[sep])","v":{"v":400000,"d":"400,000"}},{"$f":"SUM(tblIncome[oct])","v":{"v":400000,"d":"400,000"}},{"$f":"SUM(tblIncome[nov])","v":{"v":900000,"d":"900,000"}},{"$f":"SUM(tblIncome[dec])","v":{"v":400000,"d":"400,000"}},{"$f":"SUM(tblIncome[year])","v":{"v":6082500,"d":"6,082,500"}},{"$f":"O6/12","v":{"v":506875,"d":"506,875"}}]
[null,"総支出",{"$f":"SUM(tblExpenseCategory_01[jan],tblExpenseCategory_02[jan],tblExpenseCategory_03[jan],tblExpenseCategory_04[jan],tblExpenseCategory_05[jan],tblExpenseCategory_06[jan],tblExpenseCategory_07[jan],tblExpenseCategory_08[jan],tblExpenseCategory_09[jan],tblExpenseCategory_10[jan],tblExpenseCategory_11[jan],tblExpenseCategory_12[jan],tblExpenseCategory_13[jan],tblExpenseCategory_14[jan],tblExpenseCategory_15[jan])","v":{"v":793600,"d":"793,600"}},{"$f":"SUM(tblExpenseCategory_01[feb],tblExpenseCategory_02[feb],tblExpenseCategory_03[feb],tblExpenseCategory_04[feb],tblExpenseCategory_05[feb],tblExpenseCategory_06[feb],tblExpenseCategory_07[feb],tblExpenseCategory_08[feb],tblExpenseCategory_09[feb],tblExpenseCategory_10[feb],tblExpenseCategory_11[feb],tblExpenseCategory_12[feb],tblExpenseCategory_13[feb],tblExpenseCategory_14[feb],tblExpenseCategory_15[feb])","v":{"v":524300,"d":"524,300"}},{"$f":"SUM(tblExpenseCategory_01[mar],tblExpenseCategory_02[mar],tblExpenseCategory_03[mar],tblExpenseCategory_04[mar],tblExpenseCategory_05[mar],tblExpenseCategory_06[mar],tblExpenseCategory_07[mar],tblExpenseCategory_08[mar],tblExpenseCategory_09[mar],tblExpenseCategory_10[mar],tblExpenseCategory_11[mar],tblExpenseCategory_12[mar],tblExpenseCategory_13[mar],tblExpenseCategory_14[mar],tblExpenseCategory_15[mar])","v":{"v":593300,"d":"593,300"}},{"$f":"SUM(tblExpenseCategory_01[apr],tblExpenseCategory_02[apr],tblExpenseCategory_03[apr],tblExpenseCategory_04[apr],tblExpenseCategory_05[apr],tblExpenseCategory_06[apr],tblExpenseCategory_07[apr],tblExpenseCategory_08[apr],tblExpenseCategory_09[apr],tblExpenseCategory_10[apr],tblExpenseCategory_11[apr],tblExpenseCategory_12[apr],tblExpenseCategory_13[apr],tblExpenseCategory_14[apr],tblExpenseCategory_15[apr])","v":{"v":585800,"d":"585,800"}},{"$f":"SUM(tblExpenseCategory_01[may],tblExpenseCategory_02[may],tblExpenseCategory_03[may],tblExpenseCategory_04[may],tblExpenseCategory_05[may],tblExpenseCategory_06[may],tblExpenseCategory_07[may],tblExpenseCategory_08[may],tblExpenseCategory_09[may],tblExpenseCategory_10[may],tblExpenseCategory_11[may],tblExpenseCategory_12[may],tblExpenseCategory_13[may],tblExpenseCategory_14[may],tblExpenseCategory_15[may])","v":{"v":546800,"d":"546,800"}},{"$f":"SUM(tblExpenseCategory_01[jun],tblExpenseCategory_02[jun],tblExpenseCategory_03[jun],tblExpenseCategory_04[jun],tblExpenseCategory_05[jun],tblExpenseCategory_06[jun],tblExpenseCategory_07[jun],tblExpenseCategory_08[jun],tblExpenseCategory_09[jun],tblExpenseCategory_10[jun],tblExpenseCategory_11[jun],tblExpenseCategory_12[jun],tblExpenseCategory_13[jun],tblExpenseCategory_14[jun],tblExpenseCategory_15[jun])","v":{"v":511800,"d":"511,800"}},{"$f":"SUM(tblExpenseCategory_01[jul],tblExpenseCategory_02[jul],tblExpenseCategory_03[jul],tblExpenseCategory_04[jul],tblExpenseCategory_05[jul],tblExpenseCategory_06[jul],tblExpenseCategory_07[jul],tblExpenseCategory_08[jul],tblExpenseCategory_09[jul],tblExpenseCategory_10[jul],tblExpenseCategory_11[jul],tblExpenseCategory_12[jul],tblExpenseCategory_13[jul],tblExpenseCategory_14[jul],tblExpenseCategory_15[jul])","v":{"v":574300,"d":"574,300"}},{"$f":"SUM(tblExpenseCategory_01[aug],tblExpenseCategory_02[aug],tblExpenseCategory_03[aug],tblExpenseCategory_04[aug],tblExpenseCategory_05[aug],tblExpenseCategory_06[aug],tblExpenseCategory_07[aug],tblExpenseCategory_08[aug],tblExpenseCategory_09[aug],tblExpenseCategory_10[aug],tblExpenseCategory_11[aug],tblExpenseCategory_12[aug],tblExpenseCategory_13[aug],tblExpenseCategory_14[aug],tblExpenseCategory_15[aug])","v":{"v":535300,"d":"535,300"}},{"$f":"SUM(tblExpenseCategory_01[sep],tblExpenseCategory_02[sep],tblExpenseCategory_03[sep],tblExpenseCategory_04[sep],tblExpenseCategory_05[sep],tblExpenseCategory_06[sep],tblExpenseCategory_07[sep],tblExpenseCategory_08[sep],tblExpenseCategory_09[sep],tblExpenseCategory_10[sep],tblExpenseCategory_11[sep],tblExpenseCategory_12[sep],tblExpenseCategory_13[sep],tblExpenseCategory_14[sep],tblExpenseCategory_15[sep])","v":{"v":598300,"d":"598,300"}},{"$f":"SUM(tblExpenseCategory_01[oct],tblExpenseCategory_02[oct],tblExpenseCategory_03[oct],tblExpenseCategory_04[oct],tblExpenseCategory_05[oct],tblExpenseCategory_06[oct],tblExpenseCategory_07[oct],tblExpenseCategory_08[oct],tblExpenseCategory_09[oct],tblExpenseCategory_10[oct],tblExpenseCategory_11[oct],tblExpenseCategory_12[oct],tblExpenseCategory_13[oct],tblExpenseCategory_14[oct],tblExpenseCategory_15[oct])","v":{"v":594300,"d":"594,300"}},{"$f":"SUM(tblExpenseCategory_01[nov],tblExpenseCategory_02[nov],tblExpenseCategory_03[nov],tblExpenseCategory_04[nov],tblExpenseCategory_05[nov],tblExpenseCategory_06[nov],tblExpenseCategory_07[nov],tblExpenseCategory_08[nov],tblExpenseCategory_09[nov],tblExpenseCategory_10[nov],tblExpenseCategory_11[nov],tblExpenseCategory_12[nov],tblExpenseCategory_13[nov],tblExpenseCategory_14[nov],tblExpenseCategory_15[nov])","v":{"v":505800,"d":"505,800"}},{"$f":"SUM(tblExpenseCategory_01[dec],tblExpenseCategory_02[dec],tblExpenseCategory_03[dec],tblExpenseCategory_04[dec],tblExpenseCategory_05[dec],tblExpenseCategory_06[dec],tblExpenseCategory_07[dec],tblExpenseCategory_08[dec],tblExpenseCategory_09[dec],tblExpenseCategory_10[dec],tblExpenseCategory_11[dec],tblExpenseCategory_12[dec],tblExpenseCategory_13[dec],tblExpenseCategory_14[dec],tblExpenseCategory_15[dec])","v":{"v":495800,"d":"495,800"}},{"$f":"SUM(tblExpenseCategory_01[year],tblExpenseCategory_02[year],tblExpenseCategory_03[year],tblExpenseCategory_04[year],tblExpenseCategory_05[year],tblExpenseCategory_06[year],tblExpenseCategory_07[year],tblExpenseCategory_08[year],tblExpenseCategory_09[year],tblExpenseCategory_10[year],tblExpenseCategory_11[year],tblExpenseCategory_12[year],tblExpenseCategory_13[year],tblExpenseCategory_14[year],tblExpenseCategory_15[year])","v":{"v":6859400,"d":"6,859,400"}},{"$f":"O7/12","v":{"v":571616.6666666666,"d":"571,617"}}]
[null,"純収入",{"$f":"C6-C7","v":{"v":-371400,"d":"-371,400"}},{"$f":"D6-D7","v":{"v":379000,"d":"379,000"}},{"v":-193300,"d":"-193,300"},{"v":-181300,"d":"-181,300"},{"v":353200,"d":"353,200"},{"v":-359300,"d":"-359,300"},{"v":-424300,"d":"-424,300"},{"v":114700,"d":"114,700"},{"v":-198300,"d":"-198,300"},{"v":-194300,"d":"-194,300"},{"v":394200,"d":"394,200"},{"v":-95800,"d":"-95,800"},{"v":-776900,"d":"-776,900"},{"$f":"O8/12","v":{"v":-64741.666666666664,"d":"-64,742"}}]
[null,"総キャッシュ フロー",{"$f":"C5+C6-C7","v":{"v":-271400,"d":"-271,400"}},{"$f":"C9+D6-D7","v":{"v":107600,"d":"107,600"}},{"$f":"D9+E6-E7","v":{"v":-85700,"d":"-85,700"}},{"v":-267000,"d":"-267,000"},{"v":86200,"d":"86,200"},{"v":-273100,"d":"-273,100"},{"v":-697400,"d":"-697,400"},{"v":-582700,"d":"-582,700"},{"v":-781000,"d":"-781,000"},{"v":-975300,"d":"-975,300"},{"v":-581100,"d":"-581,100"},{"v":-676900,"d":"-676,900"}]
[]
[]
[null,"収入"]
[null,"給与/チップ",{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"v":100000,"d":"100,000"},{"v":100000,"d":"100,000"},{"v":100000,"d":"100,000"},{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"$f":"SUM(tblIncome[[#This Row],[jan]:[dec]])","v":{"v":3900000,"d":"3,900,000"}},{"$f":"tblIncome[[#This Row],[year]]/12","v":{"v":325000,"d":"325,000"}}]
[null,"金利収入",{"v":22200,"d":"22,200"},{"v":3300,"d":"3,300"},null,{"v":4500,"d":"4,500"},null,{"v":2500,"d":"2,500"},{"$nulls":6},{"$f":"SUM(tblIncome[[#This Row],[jan]:[dec]])","v":{"v":32500,"d":"32,500"}},{"$f":"tblIncome[[#This Row],[year]]/12","v":{"v":2708.3333333333335,"d":"2,708"}}]
[null,"配当",null,{"v":500000,"d":"500,000"},null,null,{"v":500000,"d":"500,000"},null,null,{"v":500000,"d":"500,000"},null,null,{"v":500000,"d":"500,000"},null,{"$f":"SUM(tblIncome[[#This Row],[jan]:[dec]])","v":{"v":2000000,"d":"2,000,000"}},{"$f":"tblIncome[[#This Row],[year]]/12","v":{"v":166666.66666666666,"d":"166,667"}}]
[null,"還付/償還",{"$nulls":5},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"$nulls":4},{"$f":"SUM(tblIncome[[#This Row],[jan]:[dec]])","v":{"v":150000,"d":"150,000"}},{"$f":"tblIncome[[#This Row],[year]]/12","v":{"v":12500,"d":"12,500"}}]
[null,"その他",{"$nulls":12},{"$f":"SUM(tblIncome[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblIncome[[#This Row],[year]]/12","v":0}]
[null,"総収入",{"$f":"SUM(tblIncome[jan])","v":{"v":422200,"d":"422,200"}},{"$f":"SUM(tblIncome[feb])","v":{"v":903300,"d":"903,300"}},{"$f":"SUM(tblIncome[mar])","v":{"v":400000,"d":"400,000"}},{"$f":"SUM(tblIncome[apr])","v":{"v":404500,"d":"404,500"}},{"$f":"SUM(tblIncome[may])","v":{"v":900000,"d":"900,000"}},{"$f":"SUM(tblIncome[jun])","v":{"v":152500,"d":"152,500"}},{"$f":"SUM(tblIncome[jul])","v":{"v":150000,"d":"150,000"}},{"$f":"SUM(tblIncome[aug])","v":{"v":650000,"d":"650,000"}},{"$f":"SUM(tblIncome[sep])","v":{"v":400000,"d":"400,000"}},{"$f":"SUM(tblIncome[oct])","v":{"v":400000,"d":"400,000"}},{"$f":"SUM(tblIncome[nov])","v":{"v":900000,"d":"900,000"}},{"$f":"SUM(tblIncome[dec])","v":{"v":400000,"d":"400,000"}},{"$f":"SUM(tblIncome[year])","v":{"v":6082500,"d":"6,082,500"}},{"$f":"tblIncome[[#Totals],[year]]/12","v":{"v":506875,"d":"506,875"}}]
[]
[]
[null,"住居"]
[null,"住宅ローン/家賃",{"v":85000,"d":"85,000"},{"v":85000,"d":"85,000"},{"v":85000,"d":"85,000"},{"v":85000,"d":"85,000"},{"v":85000,"d":"85,000"},{"v":85000,"d":"85,000"},{"v":85000,"d":"85,000"},{"v":85000,"d":"85,000"},{"v":85000,"d":"85,000"},{"v":85000,"d":"85,000"},{"v":90000,"d":"90,000"},{"v":90000,"d":"90,000"},{"$f":"SUM(tblExpenseCategory_01[[#This Row],[jan]:[dec]])","v":{"v":1030000,"d":"1,030,000"}},{"$f":"tblExpenseCategory_01[[#This Row],[year]]/12","v":{"v":85833.33333333333,"d":"85,833"}}]
[null,"電気",{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":17500,"d":"17,500"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":17500,"d":"17,500"},{"v":22500,"d":"22,500"},{"v":27500,"d":"27,500"},{"v":20000,"d":"20,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"$f":"SUM(tblExpenseCategory_01[[#This Row],[jan]:[dec]])","v":{"v":220000,"d":"220,000"}},{"$f":"tblExpenseCategory_01[[#This Row],[year]]/12","v":{"v":18333.333333333332,"d":"18,333"}}]
[null,"電話番号",{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"$f":"SUM(tblExpenseCategory_01[[#This Row],[jan]:[dec]])","v":{"v":80000,"d":"80,000"}},{"$f":"tblExpenseCategory_01[[#This Row],[year]]/12","v":{"v":6666.666666666667,"d":"6,667"}}]
[null,"ケーブル テレビ/衛星放送",{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"v":6900,"d":"6,900"},{"$f":"SUM(tblExpenseCategory_01[[#This Row],[jan]:[dec]])","v":{"v":82800,"d":"82,800"}},{"$f":"tblExpenseCategory_01[[#This Row],[year]]/12","v":{"v":6900,"d":"6,900"}}]
[null,"インターネット",{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"v":3900,"d":"3,900"},{"$f":"SUM(tblExpenseCategory_01[[#This Row],[jan]:[dec]])","v":{"v":46800,"d":"46,800"}},{"$f":"tblExpenseCategory_01[[#This Row],[year]]/12","v":{"v":3900,"d":"3,900"}}]
[null,{"$f":"UPPER(\"合計 \" & B21)","v":"合計 住居"},{"$f":"SUM(tblExpenseCategory_01[jan])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[feb])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[mar])","v":{"v":123300,"d":"123,300"}},{"$f":"SUM(tblExpenseCategory_01[apr])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[may])","v":{"v":115800,"d":"115,800"}},{"$f":"SUM(tblExpenseCategory_01[jun])","v":{"v":118300,"d":"118,300"}},{"$f":"SUM(tblExpenseCategory_01[jul])","v":{"v":128300,"d":"128,300"}},{"$f":"SUM(tblExpenseCategory_01[aug])","v":{"v":133300,"d":"133,300"}},{"$f":"SUM(tblExpenseCategory_01[sep])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[oct])","v":{"v":115800,"d":"115,800"}},{"$f":"SUM(tblExpenseCategory_01[nov])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[dec])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[year])","v":{"v":1459600,"d":"1,459,600"}},{"$f":"tblExpenseCategory_01[[#Totals],[year]]/12","v":{"v":121633.33333333333,"d":"121,633"}}]
[]
[]
[null,"生活"]
[null,"食料品",{"v":34500,"d":"34,500"},{"v":25000,"d":"25,000"},{"v":20000,"d":"20,000"},{"v":40000,"d":"40,000"},{"v":35000,"d":"35,000"},{"v":25000,"d":"25,000"},{"v":40000,"d":"40,000"},{"v":35000,"d":"35,000"},{"v":25000,"d":"25,000"},{"v":40000,"d":"40,000"},{"v":35000,"d":"35,000"},{"v":25000,"d":"25,000"},{"$f":"SUM(tblExpenseCategory_02[[#This Row],[jan]:[dec]])","v":{"v":379500,"d":"379,500"}},{"$f":"tblExpenseCategory_02[[#This Row],[year]]/12","v":{"v":31625,"d":"31,625"}}]
[null,"服飾費",{"v":30000,"d":"30,000"},null,null,{"v":30000,"d":"30,000"},null,null,{"v":30000,"d":"30,000"},null,null,{"v":30000,"d":"30,000"},null,null,{"$f":"SUM(tblExpenseCategory_02[[#This Row],[jan]:[dec]])","v":{"v":120000,"d":"120,000"}},{"$f":"tblExpenseCategory_02[[#This Row],[year]]/12","v":{"v":10000,"d":"10,000"}}]
[null,"外食",{"v":12500,"d":"12,500"},{"v":12500,"d":"12,500"},{"v":30000,"d":"30,000"},{"v":12500,"d":"12,500"},{"v":12500,"d":"12,500"},{"v":20000,"d":"20,000"},{"v":12500,"d":"12,500"},{"v":12500,"d":"12,500"},{"v":12500,"d":"12,500"},{"v":12500,"d":"12,500"},{"v":12500,"d":"12,500"},{"v":12500,"d":"12,500"},{"$f":"SUM(tblExpenseCategory_02[[#This Row],[jan]:[dec]])","v":{"v":175000,"d":"175,000"}},{"$f":"tblExpenseCategory_02[[#This Row],[year]]/12","v":{"v":14583.333333333334,"d":"14,583"}}]
[null,"美容院/理容院",{"v":2500,"d":"2,500"},null,{"v":5000,"d":"5,000"},null,{"v":2500,"d":"2,500"},null,{"v":5000,"d":"5,000"},null,{"v":2500,"d":"2,500"},null,{"v":10000,"d":"10,000"},null,{"$f":"SUM(tblExpenseCategory_02[[#This Row],[jan]:[dec]])","v":{"v":27500,"d":"27,500"}},{"$f":"tblExpenseCategory_02[[#This Row],[year]]/12","v":{"v":2291.6666666666665,"d":"2,292"}}]
[null,"その他",{"$nulls":12},{"$f":"SUM(tblExpenseCategory_02[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_02[[#This Row],[year]]/12","v":0}]
[null,{"$f":"UPPER(\"合計 \" & B30)","v":"合計 生活"},{"$f":"SUM(tblExpenseCategory_02[jan])","v":{"v":79500,"d":"79,500"}},{"$f":"SUM(tblExpenseCategory_02[feb])","v":{"v":37500,"d":"37,500"}},{"$f":"SUM(tblExpenseCategory_02[mar])","v":{"v":55000,"d":"55,000"}},{"$f":"SUM(tblExpenseCategory_02[apr])","v":{"v":82500,"d":"82,500"}},{"$f":"SUM(tblExpenseCategory_02[may])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_02[jun])","v":{"v":45000,"d":"45,000"}},{"$f":"SUM(tblExpenseCategory_02[jul])","v":{"v":87500,"d":"87,500"}},{"$f":"SUM(tblExpenseCategory_02[aug])","v":{"v":47500,"d":"47,500"}},{"$f":"SUM(tblExpenseCategory_02[sep])","v":{"v":40000,"d":"40,000"}},{"$f":"SUM(tblExpenseCategory_02[oct])","v":{"v":82500,"d":"82,500"}},{"$f":"SUM(tblExpenseCategory_02[nov])","v":{"v":57500,"d":"57,500"}},{"$f":"SUM(tblExpenseCategory_02[dec])","v":{"v":37500,"d":"37,500"}},{"$f":"SUM(tblExpenseCategory_02[year])","v":{"v":702000,"d":"702,000"}},{"$f":"tblExpenseCategory_02[[#Totals],[year]]/12","v":{"v":58500,"d":"58,500"}}]
[]
[]
[null,"子供"]
[null,"学費",{"v":12300,"d":"12,300"},null,{"v":10000,"d":"10,000"},{"$nulls":4},{"v":34500,"d":"34,500"},{"$nulls":4},{"$f":"SUM(tblExpenseCategory_03[[#This Row],[jan]:[dec]])","v":{"v":56800,"d":"56,800"}},{"$f":"tblExpenseCategory_03[[#This Row],[year]]/12","v":{"v":4733.333333333333,"d":"4,733"}}]
[null,"服飾費",null,{"v":10000,"d":"10,000"},null,null,{"v":10000,"d":"10,000"},{"$nulls":3},{"v":10000,"d":"10,000"},null,null,{"v":10000,"d":"10,000"},{"$f":"SUM(tblExpenseCategory_03[[#This Row],[jan]:[dec]])","v":{"v":40000,"d":"40,000"}},{"$f":"tblExpenseCategory_03[[#This Row],[year]]/12","v":{"v":3333.3333333333335,"d":"3,333"}}]
[null,"給食費",{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},null,null,{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"$f":"SUM(tblExpenseCategory_03[[#This Row],[jan]:[dec]])","v":{"v":50000,"d":"50,000"}},{"$f":"tblExpenseCategory_03[[#This Row],[year]]/12","v":{"v":4166.666666666667,"d":"4,167"}}]
[null,"医療",{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"$f":"SUM(tblExpenseCategory_03[[#This Row],[jan]:[dec]])","v":{"v":240000,"d":"240,000"}},{"$f":"tblExpenseCategory_03[[#This Row],[year]]/12","v":{"v":20000,"d":"20,000"}}]
[null,"その他",{"v":200000,"d":"200,000"},{"v":15000,"d":"15,000"},{"$nulls":3},{"v":20000,"d":"20,000"},{"$nulls":3},{"v":10000,"d":"10,000"},null,null,{"$f":"SUM(tblExpenseCategory_03[[#This Row],[jan]:[dec]])","v":{"v":245000,"d":"245,000"}},{"$f":"tblExpenseCategory_03[[#This Row],[year]]/12","v":{"v":20416.666666666668,"d":"20,417"}}]
[null,{"$f":"UPPER(\"合計 \" & B39)","v":"合計 子供"},{"$f":"SUM(tblExpenseCategory_03[jan])","v":{"v":237300,"d":"237,300"}},{"$f":"SUM(tblExpenseCategory_03[feb])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_03[mar])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[apr])","v":{"v":25000,"d":"25,000"}},{"$f":"SUM(tblExpenseCategory_03[may])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[jun])","v":{"v":45000,"d":"45,000"}},{"$f":"SUM(tblExpenseCategory_03[jul])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_03[aug])","v":{"v":54500,"d":"54,500"}},{"$f":"SUM(tblExpenseCategory_03[sep])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[oct])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[nov])","v":{"v":25000,"d":"25,000"}},{"$f":"SUM(tblExpenseCategory_03[dec])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[year])","v":{"v":631800,"d":"631,800"}},{"$f":"tblExpenseCategory_03[[#Totals],[year]]/12","v":{"v":52650,"d":"52,650"}}]
[]
[]
[null,"交通費"]
[null,"自動車の支払",{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"$f":"SUM(tblExpenseCategory_04[[#This Row],[jan]:[dec]])","v":{"v":720000,"d":"720,000"}},{"$f":"tblExpenseCategory_04[[#This Row],[year]]/12","v":{"v":60000,"d":"60,000"}}]
[null,"燃料費",{"v":32500,"d":"32,500"},{"v":32500,"d":"32,500"},{"v":32500,"d":"32,500"},{"v":32500,"d":"32,500"},{"v":32500,"d":"32,500"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":32500,"d":"32,500"},{"v":32500,"d":"32,500"},{"v":32500,"d":"32,500"},{"v":32500,"d":"32,500"},{"$f":"SUM(tblExpenseCategory_04[[#This Row],[jan]:[dec]])","v":{"v":442500,"d":"442,500"}},{"$f":"tblExpenseCategory_04[[#This Row],[year]]/12","v":{"v":36875,"d":"36,875"}}]
[null,"修理",null,{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"},null,null,{"$f":"SUM(tblExpenseCategory_04[[#This Row],[jan]:[dec]])","v":{"v":50000,"d":"50,000"}},{"$f":"tblExpenseCategory_04[[#This Row],[year]]/12","v":{"v":4166.666666666667,"d":"4,167"}}]
[null,"登録/免許",{"v":18500,"d":"18,500"},{"$nulls":7},{"v":22500,"d":"22,500"},{"$nulls":3},{"$f":"SUM(tblExpenseCategory_04[[#This Row],[jan]:[dec]])","v":{"v":41000,"d":"41,000"}},{"$f":"tblExpenseCategory_04[[#This Row],[year]]/12","v":{"v":3416.6666666666665,"d":"3,417"}}]
[null,"その他",{"$nulls":4},{"v":40000,"d":"40,000"},{"$nulls":7},{"$f":"SUM(tblExpenseCategory_04[[#This Row],[jan]:[dec]])","v":{"v":40000,"d":"40,000"}},{"$f":"tblExpenseCategory_04[[#This Row],[year]]/12","v":{"v":3333.3333333333335,"d":"3,333"}}]
[null,{"$f":"UPPER(\"合計 \" & B48)","v":"合計 交通費"},{"$f":"SUM(tblExpenseCategory_04[jan])","v":{"v":111000,"d":"111,000"}},{"$f":"SUM(tblExpenseCategory_04[feb])","v":{"v":102500,"d":"102,500"}},{"$f":"SUM(tblExpenseCategory_04[mar])","v":{"v":92500,"d":"92,500"}},{"$f":"SUM(tblExpenseCategory_04[apr])","v":{"v":102500,"d":"102,500"}},{"$f":"SUM(tblExpenseCategory_04[may])","v":{"v":132500,"d":"132,500"}},{"$f":"SUM(tblExpenseCategory_04[jun])","v":{"v":120000,"d":"120,000"}},{"$f":"SUM(tblExpenseCategory_04[jul])","v":{"v":110000,"d":"110,000"}},{"$f":"SUM(tblExpenseCategory_04[aug])","v":{"v":120000,"d":"120,000"}},{"$f":"SUM(tblExpenseCategory_04[sep])","v":{"v":115000,"d":"115,000"}},{"$f":"SUM(tblExpenseCategory_04[oct])","v":{"v":102500,"d":"102,500"}},{"$f":"SUM(tblExpenseCategory_04[nov])","v":{"v":92500,"d":"92,500"}},{"$f":"SUM(tblExpenseCategory_04[dec])","v":{"v":92500,"d":"92,500"}},{"$f":"SUM(tblExpenseCategory_04[year])","v":{"v":1293500,"d":"1,293,500"}},{"$f":"tblExpenseCategory_04[[#Totals],[year]]/12","v":{"v":107791.66666666667,"d":"107,792"}}]
[]
[]
[null,"健康"]
[null,"病院/歯科医院",null,{"v":3500,"d":"3,500"},null,null,{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},null,null,{"v":3500,"d":"3,500"},null,null,{"$f":"SUM(tblExpenseCategory_05[[#This Row],[jan]:[dec]])","v":{"v":17500,"d":"17,500"}},{"$f":"tblExpenseCategory_05[[#This Row],[year]]/12","v":{"v":1458.3333333333333,"d":"1,458"}}]
[null,"薬",{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"$f":"SUM(tblExpenseCategory_05[[#This Row],[jan]:[dec]])","v":{"v":30000,"d":"30,000"}},{"$f":"tblExpenseCategory_05[[#This Row],[year]]/12","v":{"v":2500,"d":"2,500"}}]
[null,"その他",null,null,{"v":15000,"d":"15,000"},{"$nulls":5},{"v":15000,"d":"15,000"},{"$nulls":3},{"$f":"SUM(tblExpenseCategory_05[[#This Row],[jan]:[dec]])","v":{"v":30000,"d":"30,000"}},{"$f":"tblExpenseCategory_05[[#This Row],[year]]/12","v":{"v":2500,"d":"2,500"}}]
[null,{"$f":"UPPER(\"合計 \" & B57)","v":"合計 健康"},{"$f":"SUM(tblExpenseCategory_05[jan])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[feb])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[mar])","v":{"v":17500,"d":"17,500"}},{"$f":"SUM(tblExpenseCategory_05[apr])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[may])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[jun])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[jul])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[aug])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[sep])","v":{"v":17500,"d":"17,500"}},{"$f":"SUM(tblExpenseCategory_05[oct])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[nov])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[dec])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[year])","v":{"v":77500,"d":"77,500"}},{"$f":"tblExpenseCategory_05[[#Totals],[year]]/12","v":{"v":6458.333333333333,"d":"6,458"}}]
[]
[]
[null,"保険"]
[null,"自動車",{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"$f":"SUM(tblExpenseCategory_06[[#This Row],[jan]:[dec]])","v":{"v":180000,"d":"180,000"}},{"$f":"tblExpenseCategory_06[[#This Row],[year]]/12","v":{"v":15000,"d":"15,000"}}]
[null,"健康",{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"v":67500,"d":"67,500"},{"$f":"SUM(tblExpenseCategory_06[[#This Row],[jan]:[dec]])","v":{"v":810000,"d":"810,000"}},{"$f":"tblExpenseCategory_06[[#This Row],[year]]/12","v":{"v":67500,"d":"67,500"}}]
[null,"生命",{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"$f":"SUM(tblExpenseCategory_06[[#This Row],[jan]:[dec]])","v":{"v":180000,"d":"180,000"}},{"$f":"tblExpenseCategory_06[[#This Row],[year]]/12","v":{"v":15000,"d":"15,000"}}]
[null,{"$f":"UPPER(\"合計 \" & B64)","v":"合計 保険"},{"$f":"SUM(tblExpenseCategory_06[jan])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[feb])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[mar])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[apr])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[may])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[jun])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[jul])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[aug])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[sep])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[oct])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[nov])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[dec])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[year])","v":{"v":1170000,"d":"1,170,000"}},{"$f":"tblExpenseCategory_06[[#Totals],[year]]/12","v":{"v":97500,"d":"97,500"}}]
[]
[]
[null,"教育"]
[null,"授業料",null,null,{"v":40000,"d":"40,000"},{"$nulls":5},{"v":40000,"d":"40,000"},{"$nulls":3},{"$f":"SUM(tblExpenseCategory_07[[#This Row],[jan]:[dec]])","v":{"v":80000,"d":"80,000"}},{"$f":"tblExpenseCategory_07[[#This Row],[year]]/12","v":{"v":6666.666666666667,"d":"6,667"}}]
[null,"書籍代",null,null,{"v":22500,"d":"22,500"},{"$nulls":5},{"v":22500,"d":"22,500"},{"$nulls":3},{"$f":"SUM(tblExpenseCategory_07[[#This Row],[jan]:[dec]])","v":{"v":45000,"d":"45,000"}},{"$f":"tblExpenseCategory_07[[#This Row],[year]]/12","v":{"v":3750,"d":"3,750"}}]
[null,"その他",{"$nulls":12},{"$f":"SUM(tblExpenseCategory_07[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_07[[#This Row],[year]]/12","v":0}]
[null,{"$f":"UPPER(\"合計 \" & B71)","v":"合計 教育"},{"$f":"SUM(tblExpenseCategory_07[jan])","v":0},{"$f":"SUM(tblExpenseCategory_07[feb])","v":0},{"$f":"SUM(tblExpenseCategory_07[mar])","v":{"v":62500,"d":"62,500"}},{"$f":"SUM(tblExpenseCategory_07[apr])","v":0},{"$f":"SUM(tblExpenseCategory_07[may])","v":0},{"$f":"SUM(tblExpenseCategory_07[jun])","v":0},{"$f":"SUM(tblExpenseCategory_07[jul])","v":0},{"$f":"SUM(tblExpenseCategory_07[aug])","v":0},{"$f":"SUM(tblExpenseCategory_07[sep])","v":{"v":62500,"d":"62,500"}},{"$f":"SUM(tblExpenseCategory_07[oct])","v":0},{"$f":"SUM(tblExpenseCategory_07[nov])","v":0},{"$f":"SUM(tblExpenseCategory_07[dec])","v":0},{"$f":"SUM(tblExpenseCategory_07[year])","v":{"v":125000,"d":"125,000"}},{"$f":"tblExpenseCategory_07[[#Totals],[year]]/12","v":{"v":10416.666666666666,"d":"10,417"}}]
[]
[]
[null,"寄付"]
[null,"ギフト",null,{"v":10000,"d":"10,000"},{"$nulls":3},{"v":10000,"d":"10,000"},{"$nulls":3},{"v":10000,"d":"10,000"},null,null,{"$f":"SUM(tblExpenseCategory_08[[#This Row],[jan]:[dec]])","v":{"v":30000,"d":"30,000"}},{"$f":"tblExpenseCategory_08[[#This Row],[year]]/12","v":{"v":2500,"d":"2,500"}}]
[null,"慈善寄付",null,null,{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"},null,{"$f":"SUM(tblExpenseCategory_08[[#This Row],[jan]:[dec]])","v":{"v":50000,"d":"50,000"}},{"$f":"tblExpenseCategory_08[[#This Row],[year]]/12","v":{"v":4166.666666666667,"d":"4,167"}}]
[null,"その他",{"$nulls":3},{"v":10000,"d":"10,000"},{"$nulls":3},{"v":10000,"d":"10,000"},{"$nulls":3},{"v":10000,"d":"10,000"},{"$f":"SUM(tblExpenseCategory_08[[#This Row],[jan]:[dec]])","v":{"v":30000,"d":"30,000"}},{"$f":"tblExpenseCategory_08[[#This Row],[year]]/12","v":{"v":2500,"d":"2,500"}}]
[null,{"$f":"UPPER(\"合計 \" & B78)","v":"合計 寄付"},{"$f":"SUM(tblExpenseCategory_08[jan])","v":0},{"$f":"SUM(tblExpenseCategory_08[feb])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[mar])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[apr])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[may])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[jun])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[jul])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[aug])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[sep])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[oct])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[nov])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[dec])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[year])","v":{"v":110000,"d":"110,000"}},{"$f":"tblExpenseCategory_08[[#Totals],[year]]/12","v":{"v":9166.666666666666,"d":"9,167"}}]
[]
[]
[null,"貯蓄"]
[null,"緊急用",{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"$nulls":3},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"$f":"SUM(tblExpenseCategory_09[[#This Row],[jan]:[dec]])","v":{"v":90000,"d":"90,000"}},{"$f":"tblExpenseCategory_09[[#This Row],[year]]/12","v":{"v":7500,"d":"7,500"}}]
[null,"退職金 (401 k、IRA)",{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"v":50000,"d":"50,000"},{"$f":"SUM(tblExpenseCategory_09[[#This Row],[jan]:[dec]])","v":{"v":600000,"d":"600,000"}},{"$f":"tblExpenseCategory_09[[#This Row],[year]]/12","v":{"v":50000,"d":"50,000"}}]
[null,"貯蓄口座への振込",{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"$nulls":3},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"v":20000,"d":"20,000"},{"$f":"SUM(tblExpenseCategory_09[[#This Row],[jan]:[dec]])","v":{"v":180000,"d":"180,000"}},{"$f":"tblExpenseCategory_09[[#This Row],[year]]/12","v":{"v":15000,"d":"15,000"}}]
[null,{"$f":"UPPER(\"合計 \" & B85)","v":"合計 貯蓄"},{"$f":"SUM(tblExpenseCategory_09[jan])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[feb])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[mar])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[apr])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[may])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[jun])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_09[jul])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_09[aug])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_09[sep])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[oct])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[nov])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[dec])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[year])","v":{"v":870000,"d":"870,000"}},{"$f":"tblExpenseCategory_09[[#Totals],[year]]/12","v":{"v":72500,"d":"72,500"}}]
[]
[]
[null,"負債"]
[null,"クレジット カード # 1",{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"v":14500,"d":"14,500"},{"$f":"SUM(tblExpenseCategory_10[[#This Row],[jan]:[dec]])","v":{"v":174000,"d":"174,000"}},{"$f":"tblExpenseCategory_10[[#This Row],[year]]/12","v":{"v":14500,"d":"14,500"}}]
[null,"国税",{"v":45000,"d":"45,000"},null,null,{"v":45000,"d":"45,000"},null,null,{"v":45000,"d":"45,000"},null,null,{"v":45000,"d":"45,000"},null,null,{"$f":"SUM(tblExpenseCategory_10[[#This Row],[jan]:[dec]])","v":{"v":180000,"d":"180,000"}},{"$f":"tblExpenseCategory_10[[#This Row],[year]]/12","v":{"v":15000,"d":"15,000"}}]
[null,"学生ローン",{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"v":5500,"d":"5,500"},{"$f":"SUM(tblExpenseCategory_10[[#This Row],[jan]:[dec]])","v":{"v":66000,"d":"66,000"}},{"$f":"tblExpenseCategory_10[[#This Row],[year]]/12","v":{"v":5500,"d":"5,500"}}]
[null,{"$f":"UPPER(\"合計 \" & B92)","v":"合計 負債"},{"$f":"SUM(tblExpenseCategory_10[jan])","v":{"v":65000,"d":"65,000"}},{"$f":"SUM(tblExpenseCategory_10[feb])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[mar])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[apr])","v":{"v":65000,"d":"65,000"}},{"$f":"SUM(tblExpenseCategory_10[may])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[jun])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[jul])","v":{"v":65000,"d":"65,000"}},{"$f":"SUM(tblExpenseCategory_10[aug])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[sep])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[oct])","v":{"v":65000,"d":"65,000"}},{"$f":"SUM(tblExpenseCategory_10[nov])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[dec])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[year])","v":{"v":420000,"d":"420,000"}},{"$f":"tblExpenseCategory_10[[#Totals],[year]]/12","v":{"v":35000,"d":"35,000"}}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_11[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_11[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_11[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_11[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_11[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_11[[#This Row],[year]]/12","v":0}]
[null,{"$f":"UPPER(\"合計 \" & B99)","v":"合計  "},{"$f":"SUM(tblExpenseCategory_11[jan])","v":0},{"$f":"SUM(tblExpenseCategory_11[feb])","v":0},{"$f":"SUM(tblExpenseCategory_11[mar])","v":0},{"$f":"SUM(tblExpenseCategory_11[apr])","v":0},{"$f":"SUM(tblExpenseCategory_11[may])","v":0},{"$f":"SUM(tblExpenseCategory_11[jun])","v":0},{"$f":"SUM(tblExpenseCategory_11[jul])","v":0},{"$f":"SUM(tblExpenseCategory_11[aug])","v":0},{"$f":"SUM(tblExpenseCategory_11[sep])","v":0},{"$f":"SUM(tblExpenseCategory_11[oct])","v":0},{"$f":"SUM(tblExpenseCategory_11[nov])","v":0},{"$f":"SUM(tblExpenseCategory_11[dec])","v":0},{"$f":"SUM(tblExpenseCategory_11[year])","v":0},{"$f":"tblExpenseCategory_11[[#Totals],[year]]/12","v":0}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_12[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_12[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_12[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_12[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_12[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_12[[#This Row],[year]]/12","v":0}]
[null,{"$f":"UPPER(\"合計 \" & B106)","v":"合計  "},{"$f":"SUM(tblExpenseCategory_12[jan])","v":0},{"$f":"SUM(tblExpenseCategory_12[feb])","v":0},{"$f":"SUM(tblExpenseCategory_12[mar])","v":0},{"$f":"SUM(tblExpenseCategory_12[apr])","v":0},{"$f":"SUM(tblExpenseCategory_12[may])","v":0},{"$f":"SUM(tblExpenseCategory_12[jun])","v":0},{"$f":"SUM(tblExpenseCategory_12[jul])","v":0},{"$f":"SUM(tblExpenseCategory_12[aug])","v":0},{"$f":"SUM(tblExpenseCategory_12[sep])","v":0},{"$f":"SUM(tblExpenseCategory_12[oct])","v":0},{"$f":"SUM(tblExpenseCategory_12[nov])","v":0},{"$f":"SUM(tblExpenseCategory_12[dec])","v":0},{"$f":"SUM(tblExpenseCategory_12[year])","v":0},{"$f":"tblExpenseCategory_12[[#Totals],[year]]/12","v":0}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_13[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_13[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_13[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_13[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_13[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_13[[#This Row],[year]]/12","v":0}]
[null,{"$f":"UPPER(\"合計 \" & B113)","v":"合計  "},{"$f":"SUM(tblExpenseCategory_13[jan])","v":0},{"$f":"SUM(tblExpenseCategory_13[feb])","v":0},{"$f":"SUM(tblExpenseCategory_13[mar])","v":0},{"$f":"SUM(tblExpenseCategory_13[apr])","v":0},{"$f":"SUM(tblExpenseCategory_13[may])","v":0},{"$f":"SUM(tblExpenseCategory_13[jun])","v":0},{"$f":"SUM(tblExpenseCategory_13[jul])","v":0},{"$f":"SUM(tblExpenseCategory_13[aug])","v":0},{"$f":"SUM(tblExpenseCategory_13[sep])","v":0},{"$f":"SUM(tblExpenseCategory_13[oct])","v":0},{"$f":"SUM(tblExpenseCategory_13[nov])","v":0},{"$f":"SUM(tblExpenseCategory_13[dec])","v":0},{"$f":"SUM(tblExpenseCategory_13[year])","v":0},{"$f":"tblExpenseCategory_13[[#Totals],[year]]/12","v":0}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_14[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_14[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_14[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_14[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_14[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_14[[#This Row],[year]]/12","v":0}]
[null,{"$f":"UPPER(\"合計 \" & B120)","v":"合計  "},{"$f":"SUM(tblExpenseCategory_14[jan])","v":0},{"$f":"SUM(tblExpenseCategory_14[feb])","v":0},{"$f":"SUM(tblExpenseCategory_14[mar])","v":0},{"$f":"SUM(tblExpenseCategory_14[apr])","v":0},{"$f":"SUM(tblExpenseCategory_14[may])","v":0},{"$f":"SUM(tblExpenseCategory_14[jun])","v":0},{"$f":"SUM(tblExpenseCategory_14[jul])","v":0},{"$f":"SUM(tblExpenseCategory_14[aug])","v":0},{"$f":"SUM(tblExpenseCategory_14[sep])","v":0},{"$f":"SUM(tblExpenseCategory_14[oct])","v":0},{"$f":"SUM(tblExpenseCategory_14[nov])","v":0},{"$f":"SUM(tblExpenseCategory_14[dec])","v":0},{"$f":"SUM(tblExpenseCategory_14[year])","v":0},{"$f":"tblExpenseCategory_14[[#Totals],[year]]/12","v":0}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_15[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_15[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_15[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_15[[#This Row],[year]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_15[[#This Row],[jan]:[dec]])","v":0},{"$f":"tblExpenseCategory_15[[#This Row],[year]]/12","v":0}]
[null,{"$f":"UPPER(\"合計 \" & B127)","v":"合計  "},{"$f":"SUM(tblExpenseCategory_15[jan])","v":0},{"$f":"SUM(tblExpenseCategory_15[feb])","v":0},{"$f":"SUM(tblExpenseCategory_15[mar])","v":0},{"$f":"SUM(tblExpenseCategory_15[apr])","v":0},{"$f":"SUM(tblExpenseCategory_15[may])","v":0},{"$f":"SUM(tblExpenseCategory_15[jun])","v":0},{"$f":"SUM(tblExpenseCategory_15[jul])","v":0},{"$f":"SUM(tblExpenseCategory_15[aug])","v":0},{"$f":"SUM(tblExpenseCategory_15[sep])","v":0},{"$f":"SUM(tblExpenseCategory_15[oct])","v":0},{"$f":"SUM(tblExpenseCategory_15[nov])","v":0},{"$f":"SUM(tblExpenseCategory_15[dec])","v":0},{"$f":"SUM(tblExpenseCategory_15[year])","v":0},{"$f":"tblExpenseCategory_15[[#Totals],[year]]/12","v":0}]

{"sheet":"設定","index":2,"n_rows":59,"n_cols":10,"rows_kept":59}
[null,"青木家 2012 年"]
[null,"収入",null,"支出"]
[null,"給与/チップ",null," ",null,"このシートの表を使用して、収支シートの表の名前とドロップダウン リストの項目を構成します"]
[null,"金利収入",null,"住居",null,"住居",null,"生活",null,"子供"]
[null,"配当",null,"生活",null,"住宅ローン/家賃",null,"食料品",null,"医療"]
[null,"ギフト受け取り",null,"子供",null,"電気",null,"個人用品",null,"服飾費"]
[null,"還付/償還",null,"交通費",null,"ガス/石油",null,"服飾費",null,"学費"]
[null,"貯蓄口座からの振替",null,"健康",null,"上下水道/ごみ",null,"清掃サービス",null,"給食費"]
[null,"その他",null,"保険",null,"電話番号",null,"外食",null,"学用品"]
[{"$nulls":3},"教育",null,"ケーブル テレビ/衛星放送",null,"ドライ クリーニング",null,"ベビーシッター"]
[{"$nulls":3},"寄付",null,"インターネット",null,"美容院/理容院",null,"玩具/ゲーム"]
[{"$nulls":3},"貯蓄",null,"家具/電化製品",null,"その他",null,"その他"]
[{"$nulls":3},"負債",null,"芝生/庭"]
[{"$nulls":3},"娯楽費",null,"家庭用品"]
[{"$nulls":3},"ペット",null,"修理"]
[{"$nulls":3},"購読",null,"改築"]
[{"$nulls":3},"休暇",null,"その他"]
[{"$nulls":3},"その他"]
[]
[{"$nulls":5},"交通費",null,"健康",null,"保険"]
[{"$nulls":5},"自動車の支払",null,"病院/歯科医院",null,"自動車"]
[{"$nulls":5},"燃料費",null,"薬",null,"健康"]
[{"$nulls":5},"バス/タクシー/電車料金",null,"スポーツ クラブ会費",null,"住宅/賃貸"]
[{"$nulls":5},"修理",null,"緊急",null,"生命"]
[{"$nulls":5},"登録/免許",null,"その他",null,"その他"]
[{"$nulls":5},"その他"]
[]
[]
[{"$nulls":5},"教育",null,"寄付",null,"貯蓄"]
[{"$nulls":5},"授業料",null,"ギフト",null,"緊急用"]
[{"$nulls":5},"書籍代",null,"慈善寄付",null,"貯蓄口座への振込"]
[{"$nulls":5},"音楽レッスン",null,"宗教上の寄付",null,"退職金 (401 k、IRA)"]
[{"$nulls":5},"その他",null,"その他",null,"投資"]
[{"$nulls":9},"大学"]
[{"$nulls":9},"その他"]
[]
[]
[{"$nulls":5},"負債",null,"娯楽費",null,"ペット"]
[{"$nulls":5},"学生ローン",null,"ビデオ/DVD",null,"食費"]
[{"$nulls":5},"その他のローン",null,"音楽",null,"医療"]
[{"$nulls":5},"クレジット カード # 1",null,"ゲーム",null,"玩具/ペット用品"]
[{"$nulls":5},"クレジット カード # 2",null,"レンタル",null,"その他"]
[{"$nulls":5},"クレジット カード # 3",null,"映画"]
[{"$nulls":5},"慰謝料/養育費",null,"コンサート/演劇"]
[{"$nulls":5},"国税",null,"書籍代"]
[{"$nulls":5},"財産税",null,"趣味"]
[{"$nulls":5},"地方税",null,"ビデオ/写真"]
[{"$nulls":5},"自治会費",null,"スポーツ"]
[{"$nulls":5},"弁護士費用",null,"アウトドア"]
[{"$nulls":5},"その他",null,"玩具/ガジェット"]
[{"$nulls":7},"その他"]
[]
[{"$nulls":5},"購読",null,"休暇",null,"その他"]
[{"$nulls":5},"新聞",null,"旅行",null,"銀行手数料"]
[{"$nulls":5},"雑誌",null,"宿泊費",null,"郵送料"]
[{"$nulls":5},"手数料",null,"食費",null,"その他"]
[{"$nulls":5},"会費",null,"レンタカー"]
[{"$nulls":5},"その他",null,"娯楽費"]
[{"$nulls":7},"その他"]

{"sheet":"グラフ データ","index":3,"n_rows":40,"n_cols":16,"rows_kept":40,"hidden":true}
[null,"***このシートは、非表示***ままにしてください"]
[]
[]
[null,"の期間",3]
[]
[null,null,"1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年","平均"]
[null,{"$f":"LOWER(予算!B127)","v":" "},{"$f":"SUM(tblExpenseCategory_15[jan])","v":0},{"$f":"SUM(tblExpenseCategory_15[feb])","v":0},{"$f":"SUM(tblExpenseCategory_15[mar])","v":0},{"$f":"SUM(tblExpenseCategory_15[apr])","v":0},{"$f":"SUM(tblExpenseCategory_15[may])","v":0},{"$f":"SUM(tblExpenseCategory_15[jun])","v":0},{"$f":"SUM(tblExpenseCategory_15[jul])","v":0},{"$f":"SUM(tblExpenseCategory_15[aug])","v":0},{"$f":"SUM(tblExpenseCategory_15[sep])","v":0},{"$f":"SUM(tblExpenseCategory_15[oct])","v":0},{"$f":"SUM(tblExpenseCategory_15[nov])","v":0},{"$f":"SUM(tblExpenseCategory_15[dec])","v":0},{"$f":"SUM(tblExpenseCategory_15[year])","v":0},{"$f":"SUM(tblExpenseCategory_15[avg])","v":0}]
[null,{"$f":"LOWER(予算!B120)","v":" "},{"$f":"SUM(tblExpenseCategory_14[jan])","v":0},{"$f":"SUM(tblExpenseCategory_14[feb])","v":0},{"$f":"SUM(tblExpenseCategory_14[mar])","v":0},{"$f":"SUM(tblExpenseCategory_14[apr])","v":0},{"$f":"SUM(tblExpenseCategory_14[may])","v":0},{"$f":"SUM(tblExpenseCategory_14[jun])","v":0},{"$f":"SUM(tblExpenseCategory_14[jul])","v":0},{"$f":"SUM(tblExpenseCategory_14[aug])","v":0},{"$f":"SUM(tblExpenseCategory_14[sep])","v":0},{"$f":"SUM(tblExpenseCategory_14[oct])","v":0},{"$f":"SUM(tblExpenseCategory_14[nov])","v":0},{"$f":"SUM(tblExpenseCategory_14[dec])","v":0},{"$f":"SUM(tblExpenseCategory_14[year])","v":0},{"$f":"SUM(tblExpenseCategory_14[avg])","v":0}]
[null,{"$f":"LOWER(予算!B113)","v":" "},{"$f":"SUM(tblExpenseCategory_13[jan])","v":0},{"$f":"SUM(tblExpenseCategory_13[feb])","v":0},{"$f":"SUM(tblExpenseCategory_13[mar])","v":0},{"$f":"SUM(tblExpenseCategory_13[apr])","v":0},{"$f":"SUM(tblExpenseCategory_13[may])","v":0},{"$f":"SUM(tblExpenseCategory_13[jun])","v":0},{"$f":"SUM(tblExpenseCategory_13[jul])","v":0},{"$f":"SUM(tblExpenseCategory_13[aug])","v":0},{"$f":"SUM(tblExpenseCategory_13[sep])","v":0},{"$f":"SUM(tblExpenseCategory_13[oct])","v":0},{"$f":"SUM(tblExpenseCategory_13[nov])","v":0},{"$f":"SUM(tblExpenseCategory_13[dec])","v":0},{"$f":"SUM(tblExpenseCategory_13[year])","v":0},{"$f":"SUM(tblExpenseCategory_13[avg])","v":0}]
[null,{"$f":"LOWER(予算!B106)","v":" "},{"$f":"SUM(tblExpenseCategory_12[jan])","v":0},{"$f":"SUM(tblExpenseCategory_12[feb])","v":0},{"$f":"SUM(tblExpenseCategory_12[mar])","v":0},{"$f":"SUM(tblExpenseCategory_12[apr])","v":0},{"$f":"SUM(tblExpenseCategory_12[may])","v":0},{"$f":"SUM(tblExpenseCategory_12[jun])","v":0},{"$f":"SUM(tblExpenseCategory_12[jul])","v":0},{"$f":"SUM(tblExpenseCategory_12[aug])","v":0},{"$f":"SUM(tblExpenseCategory_12[sep])","v":0},{"$f":"SUM(tblExpenseCategory_12[oct])","v":0},{"$f":"SUM(tblExpenseCategory_12[nov])","v":0},{"$f":"SUM(tblExpenseCategory_12[dec])","v":0},{"$f":"SUM(tblExpenseCategory_12[year])","v":0},{"$f":"SUM(tblExpenseCategory_12[avg])","v":0}]
[null,{"$f":"LOWER(予算!B99)","v":" "},{"$f":"SUM(tblExpenseCategory_11[jan])","v":0},{"$f":"SUM(tblExpenseCategory_11[feb])","v":0},{"$f":"SUM(tblExpenseCategory_11[mar])","v":0},{"$f":"SUM(tblExpenseCategory_11[apr])","v":0},{"$f":"SUM(tblExpenseCategory_11[may])","v":0},{"$f":"SUM(tblExpenseCategory_11[jun])","v":0},{"$f":"SUM(tblExpenseCategory_11[jul])","v":0},{"$f":"SUM(tblExpenseCategory_11[aug])","v":0},{"$f":"SUM(tblExpenseCategory_11[sep])","v":0},{"$f":"SUM(tblExpenseCategory_11[oct])","v":0},{"$f":"SUM(tblExpenseCategory_11[nov])","v":0},{"$f":"SUM(tblExpenseCategory_11[dec])","v":0},{"$f":"SUM(tblExpenseCategory_11[year])","v":0},{"$f":"SUM(tblExpenseCategory_11[avg])","v":0}]
[null,{"$f":"LOWER(予算!B92)","v":"負債"},{"$f":"SUM(tblExpenseCategory_10[jan])","v":{"v":65000,"d":"65,000"}},{"$f":"SUM(tblExpenseCategory_10[feb])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[mar])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[apr])","v":{"v":65000,"d":"65,000"}},{"$f":"SUM(tblExpenseCategory_10[may])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[jun])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[jul])","v":{"v":65000,"d":"65,000"}},{"$f":"SUM(tblExpenseCategory_10[aug])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[sep])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[oct])","v":{"v":65000,"d":"65,000"}},{"$f":"SUM(tblExpenseCategory_10[nov])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[dec])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_10[year])","v":{"v":420000,"d":"420,000"}},{"$f":"SUM(tblExpenseCategory_10[avg])","v":{"v":35000,"d":"35,000"}}]
[null,{"$f":"LOWER(予算!B85)","v":"貯蓄"},{"$f":"SUM(tblExpenseCategory_09[jan])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[feb])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[mar])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[apr])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[may])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[jun])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_09[jul])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_09[aug])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_09[sep])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[oct])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[nov])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[dec])","v":{"v":80000,"d":"80,000"}},{"$f":"SUM(tblExpenseCategory_09[year])","v":{"v":870000,"d":"870,000"}},{"$f":"SUM(tblExpenseCategory_09[avg])","v":{"v":72500,"d":"72,500"}}]
[null,{"$f":"LOWER(予算!B78)","v":"寄付"},{"$f":"SUM(tblExpenseCategory_08[jan])","v":0},{"$f":"SUM(tblExpenseCategory_08[feb])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[mar])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[apr])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[may])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[jun])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[jul])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[aug])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[sep])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[oct])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[nov])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[dec])","v":{"v":10000,"d":"10,000"}},{"$f":"SUM(tblExpenseCategory_08[year])","v":{"v":110000,"d":"110,000"}},{"$f":"SUM(tblExpenseCategory_08[avg])","v":{"v":9166.666666666668,"d":"9,167"}}]
[null,{"$f":"LOWER(予算!B71)","v":"教育"},{"$f":"SUM(tblExpenseCategory_07[jan])","v":0},{"$f":"SUM(tblExpenseCategory_07[feb])","v":0},{"$f":"SUM(tblExpenseCategory_07[mar])","v":{"v":62500,"d":"62,500"}},{"$f":"SUM(tblExpenseCategory_07[apr])","v":0},{"$f":"SUM(tblExpenseCategory_07[may])","v":0},{"$f":"SUM(tblExpenseCategory_07[jun])","v":0},{"$f":"SUM(tblExpenseCategory_07[jul])","v":0},{"$f":"SUM(tblExpenseCategory_07[aug])","v":0},{"$f":"SUM(tblExpenseCategory_07[sep])","v":{"v":62500,"d":"62,500"}},{"$f":"SUM(tblExpenseCategory_07[oct])","v":0},{"$f":"SUM(tblExpenseCategory_07[nov])","v":0},{"$f":"SUM(tblExpenseCategory_07[dec])","v":0},{"$f":"SUM(tblExpenseCategory_07[year])","v":{"v":125000,"d":"125,000"}},{"$f":"SUM(tblExpenseCategory_07[avg])","v":{"v":10416.666666666668,"d":"10,417"}}]
[null,{"$f":"LOWER(予算!B64)","v":"保険"},{"$f":"SUM(tblExpenseCategory_06[jan])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[feb])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[mar])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[apr])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[may])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[jun])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[jul])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[aug])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[sep])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[oct])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[nov])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[dec])","v":{"v":97500,"d":"97,500"}},{"$f":"SUM(tblExpenseCategory_06[year])","v":{"v":1170000,"d":"1,170,000"}},{"$f":"SUM(tblExpenseCategory_06[avg])","v":{"v":97500,"d":"97,500"}}]
[null,{"$f":"LOWER(予算!B57)","v":"健康"},{"$f":"SUM(tblExpenseCategory_05[jan])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[feb])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[mar])","v":{"v":17500,"d":"17,500"}},{"$f":"SUM(tblExpenseCategory_05[apr])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[may])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[jun])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[jul])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[aug])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[sep])","v":{"v":17500,"d":"17,500"}},{"$f":"SUM(tblExpenseCategory_05[oct])","v":{"v":6000,"d":"6,000"}},{"$f":"SUM(tblExpenseCategory_05[nov])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[dec])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_05[year])","v":{"v":77500,"d":"77,500"}},{"$f":"SUM(tblExpenseCategory_05[avg])","v":{"v":6458.333333333333,"d":"6,458"}}]
[null,{"$f":"LOWER(予算!B48)","v":"交通費"},{"$f":"SUM(tblExpenseCategory_04[jan])","v":{"v":111000,"d":"111,000"}},{"$f":"SUM(tblExpenseCategory_04[feb])","v":{"v":102500,"d":"102,500"}},{"$f":"SUM(tblExpenseCategory_04[mar])","v":{"v":92500,"d":"92,500"}},{"$f":"SUM(tblExpenseCategory_04[apr])","v":{"v":102500,"d":"102,500"}},{"$f":"SUM(tblExpenseCategory_04[may])","v":{"v":132500,"d":"132,500"}},{"$f":"SUM(tblExpenseCategory_04[jun])","v":{"v":120000,"d":"120,000"}},{"$f":"SUM(tblExpenseCategory_04[jul])","v":{"v":110000,"d":"110,000"}},{"$f":"SUM(tblExpenseCategory_04[aug])","v":{"v":120000,"d":"120,000"}},{"$f":"SUM(tblExpenseCategory_04[sep])","v":{"v":115000,"d":"115,000"}},{"$f":"SUM(tblExpenseCategory_04[oct])","v":{"v":102500,"d":"102,500"}},{"$f":"SUM(tblExpenseCategory_04[nov])","v":{"v":92500,"d":"92,500"}},{"$f":"SUM(tblExpenseCategory_04[dec])","v":{"v":92500,"d":"92,500"}},{"$f":"SUM(tblExpenseCategory_04[year])","v":{"v":1293500,"d":"1,293,500"}},{"$f":"SUM(tblExpenseCategory_04[avg])","v":{"v":107791.66666666667,"d":"107,792"}}]
[null,{"$f":"LOWER(予算!B39)","v":"子供"},{"$f":"SUM(tblExpenseCategory_03[jan])","v":{"v":237300,"d":"237,300"}},{"$f":"SUM(tblExpenseCategory_03[feb])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_03[mar])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[apr])","v":{"v":25000,"d":"25,000"}},{"$f":"SUM(tblExpenseCategory_03[may])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[jun])","v":{"v":45000,"d":"45,000"}},{"$f":"SUM(tblExpenseCategory_03[jul])","v":{"v":20000,"d":"20,000"}},{"$f":"SUM(tblExpenseCategory_03[aug])","v":{"v":54500,"d":"54,500"}},{"$f":"SUM(tblExpenseCategory_03[sep])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[oct])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[nov])","v":{"v":25000,"d":"25,000"}},{"$f":"SUM(tblExpenseCategory_03[dec])","v":{"v":35000,"d":"35,000"}},{"$f":"SUM(tblExpenseCategory_03[year])","v":{"v":631800,"d":"631,800"}},{"$f":"SUM(tblExpenseCategory_03[avg])","v":{"v":52650,"d":"52,650"}}]
[null,{"$f":"LOWER(予算!B30)","v":"生活"},{"$f":"SUM(tblExpenseCategory_02[jan])","v":{"v":79500,"d":"79,500"}},{"$f":"SUM(tblExpenseCategory_02[feb])","v":{"v":37500,"d":"37,500"}},{"$f":"SUM(tblExpenseCategory_02[mar])","v":{"v":55000,"d":"55,000"}},{"$f":"SUM(tblExpenseCategory_02[apr])","v":{"v":82500,"d":"82,500"}},{"$f":"SUM(tblExpenseCategory_02[may])","v":{"v":50000,"d":"50,000"}},{"$f":"SUM(tblExpenseCategory_02[jun])","v":{"v":45000,"d":"45,000"}},{"$f":"SUM(tblExpenseCategory_02[jul])","v":{"v":87500,"d":"87,500"}},{"$f":"SUM(tblExpenseCategory_02[aug])","v":{"v":47500,"d":"47,500"}},{"$f":"SUM(tblExpenseCategory_02[sep])","v":{"v":40000,"d":"40,000"}},{"$f":"SUM(tblExpenseCategory_02[oct])","v":{"v":82500,"d":"82,500"}},{"$f":"SUM(tblExpenseCategory_02[nov])","v":{"v":57500,"d":"57,500"}},{"$f":"SUM(tblExpenseCategory_02[dec])","v":{"v":37500,"d":"37,500"}},{"$f":"SUM(tblExpenseCategory_02[year])","v":{"v":702000,"d":"702,000"}},{"$f":"SUM(tblExpenseCategory_02[avg])","v":{"v":58500,"d":"58,500"}}]
[null,{"$f":"LOWER(予算!B21)","v":"住居"},{"$f":"SUM(tblExpenseCategory_01[jan])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[feb])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[mar])","v":{"v":123300,"d":"123,300"}},{"$f":"SUM(tblExpenseCategory_01[apr])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[may])","v":{"v":115800,"d":"115,800"}},{"$f":"SUM(tblExpenseCategory_01[jun])","v":{"v":118300,"d":"118,300"}},{"$f":"SUM(tblExpenseCategory_01[jul])","v":{"v":128300,"d":"128,300"}},{"$f":"SUM(tblExpenseCategory_01[aug])","v":{"v":133300,"d":"133,300"}},{"$f":"SUM(tblExpenseCategory_01[sep])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[oct])","v":{"v":115800,"d":"115,800"}},{"$f":"SUM(tblExpenseCategory_01[nov])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[dec])","v":{"v":120800,"d":"120,800"}},{"$f":"SUM(tblExpenseCategory_01[year])","v":{"v":1459600,"d":"1,459,600"}},{"$f":"SUM(tblExpenseCategory_01[avg])","v":{"v":121633.33333333333,"d":"121,633"}}]
[]
[]
[]
[]
[null,"累積キャッシュフロー",{"$f":"SUM(予算!$C$8:C$8)","v":{"v":-371400,"d":"-371,400"}},{"$f":"SUM(予算!$C$8:D$8)","v":{"v":7600,"d":"7,600"}},{"$f":"SUM(予算!$C$8:E$8)","v":{"v":-185700,"d":"-185,700"}},{"$f":"SUM(予算!$C$8:F$8)","v":{"v":-367000,"d":"-367,000"}},{"$f":"SUM(予算!$C$8:G$8)","v":{"v":-13800,"d":"-13,800"}},{"$f":"SUM(予算!$C$8:H$8)","v":{"v":-373100,"d":"-373,100"}},{"$f":"SUM(予算!$C$8:I$8)","v":{"v":-797400,"d":"-797,400"}},{"$f":"SUM(予算!$C$8:J$8)","v":{"v":-682700,"d":"-682,700"}},{"$f":"SUM(予算!$C$8:K$8)","v":{"v":-881000,"d":"-881,000"}},{"$f":"SUM(予算!$C$8:L$8)","v":{"v":-1075300,"d":"-1,075,300"}},{"$f":"SUM(予算!$C$8:M$8)","v":{"v":-681100,"d":"-681,100"}},{"$f":"SUM(予算!$C$8:N$8)","v":{"v":-776900,"d":"-776,900"}},{"$f":"SUM(予算!$C$8:O$8)","v":{"v":-1553800,"d":"-1,553,800"}}]
[]
[null,"正年間のキャッシュフロー",{"$f":"IF(予算!C$8<0,NA(),IF(period+2<>COLUMN(予算!C$8),NA(),予算!C$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!D$8<0,NA(),IF(period+2<>COLUMN(予算!D$8),NA(),予算!D$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!E$8<0,NA(),IF(period+2<>COLUMN(予算!E$8),NA(),予算!E$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!F$8<0,NA(),IF(period+2<>COLUMN(予算!F$8),NA(),予算!F$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!G$8<0,NA(),IF(period+2<>COLUMN(予算!G$8),NA(),予算!G$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!H$8<0,NA(),IF(period+2<>COLUMN(予算!H$8),NA(),予算!H$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!I$8<0,NA(),IF(period+2<>COLUMN(予算!I$8),NA(),予算!I$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!J$8<0,NA(),IF(period+2<>COLUMN(予算!J$8),NA(),予算!J$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!K$8<0,NA(),IF(period+2<>COLUMN(予算!K$8),NA(),予算!K$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!L$8<0,NA(),IF(period+2<>COLUMN(予算!L$8),NA(),予算!L$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!M$8<0,NA(),IF(period+2<>COLUMN(予算!M$8),NA(),予算!M$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!N$8<0,NA(),IF(period+2<>COLUMN(予算!N$8),NA(),予算!N$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!O$8<0,NA(),IF(period+2<>COLUMN(予算!O$8),NA(),予算!O$8))","v":{"$error":"#N/A"}}]
[null,"負の年間のキャッシュフロー",{"$f":"IF(予算!C$8>=0,NA(),IF(period+2<>COLUMN(予算!C$8),NA(),予算!C$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!D$8>=0,NA(),IF(period+2<>COLUMN(予算!D$8),NA(),予算!D$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!E$8>=0,NA(),IF(period+2<>COLUMN(予算!E$8),NA(),予算!E$8))","v":{"v":-193300,"d":"-193,300"}},{"$f":"IF(予算!F$8>=0,NA(),IF(period+2<>COLUMN(予算!F$8),NA(),予算!F$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!G$8>=0,NA(),IF(period+2<>COLUMN(予算!G$8),NA(),予算!G$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!H$8>=0,NA(),IF(period+2<>COLUMN(予算!H$8),NA(),予算!H$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!I$8>=0,NA(),IF(period+2<>COLUMN(予算!I$8),NA(),予算!I$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!J$8>=0,NA(),IF(period+2<>COLUMN(予算!J$8),NA(),予算!J$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!K$8>=0,NA(),IF(period+2<>COLUMN(予算!K$8),NA(),予算!K$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!L$8>=0,NA(),IF(period+2<>COLUMN(予算!L$8),NA(),予算!L$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!M$8>=0,NA(),IF(period+2<>COLUMN(予算!M$8),NA(),予算!M$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!N$8>=0,NA(),IF(period+2<>COLUMN(予算!N$8),NA(),予算!N$8))","v":{"$error":"#N/A"}},{"$f":"IF(予算!O$8>=0,NA(),IF(period+2<>COLUMN(予算!O$8),NA(),予算!O$8))","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[null,"正期のキャッシュフロー",{"$f":"CHOOSE({1,2,3},0,SelectedPeriodCashFlowPositive,(MAX(ABS(SelectedPeriodCashFlowNegative),SelectedPeriodCashFlowPositive)))","v":0},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,"負の期間のキャッシュフロー",{"$f":"CHOOSE({1,2,3},0,SelectedPeriodCashFlowNegative,-(MAX(ABS(SelectedPeriodCashFlowNegative),SelectedPeriodCashFlowPositive)))","v":0},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
[null,{"$f":"LOWER(display_long_period)","v":"3 月"}]
[null,{"$f":"display_long_period & \"  収入\"","v":"3 月  収入"},{"$f":"INDEX(予算!$C$6:$P$6,,period)","v":{"v":400000,"d":"¥400,000"}}]
[null,{"$f":"display_long_period & \" 支出: \" & TEXT(INDEX(予算!$C$7:$P$7,,period),\"$#,##0\")","v":"3 月 支出: $593,300"},{"$f":"INDEX(予算!$C$7:$P$7,,period)","v":{"v":593300,"d":"¥593,300"}}]
[null,{"$f":"display_long_period & \" キャッシュ フロー\"","v":"3 月 キャッシュ フロー"},{"$f":"ABS(INDEX(予算!$C$8:$P$8,,period))","v":{"v":193300,"d":"¥193,300"}},{"$f":"REPT(\"-\",INDEX(予算!$C$8:$P$8,,period)<0)","v":"-"}]