{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月 "],"not_rendered":{"defined_names":12,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"1月","index":0,"n_rows":42,"n_cols":71,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,2009,"年",{"$f":"DATE(B2,1,1)","v":"2009-01-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,1,1)","v":"2009-01-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Thu)"},{"$f":"J2+1","v":"2009-01-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Fri)"},{"$f":"L2+1","v":"2009-01-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Sat)"},{"$f":"N2+1","v":"2009-01-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Sun)"},{"$f":"P2+1","v":"2009-01-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Mon)"},{"$f":"R2+1","v":"2009-01-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Tue)"},{"$f":"T2+1","v":"2009-01-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Wed)"},{"$f":"V2+1","v":"2009-01-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Thu)"},{"$f":"X2+1","v":"2009-01-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Fri)"},{"$f":"Z2+1","v":"2009-01-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Sat)"},{"$f":"AB2+1","v":"2009-01-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Sun)"},{"$f":"AD2+1","v":"2009-01-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Mon)"},{"$f":"AF2+1","v":"2009-01-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Tue)"},{"$f":"AH2+1","v":"2009-01-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Wed)"},{"$f":"AJ2+1","v":"2009-01-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Thu)"},{"$f":"AL2+1","v":"2009-01-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Fri)"},{"$f":"AN2+1","v":"2009-01-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Sat)"},{"$f":"AP2+1","v":"2009-01-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Sun)"},{"$f":"AR2+1","v":"2009-01-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Mon)"},{"$f":"AT2+1","v":"2009-01-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Tue)"},{"$f":"AV2+1","v":"2009-01-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Wed)"},{"$f":"AX2+1","v":"2009-01-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Thu)"},{"$f":"AZ2+1","v":"2009-01-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Fri)"},{"$f":"BB2+1","v":"2009-01-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Sat)"},{"$f":"BD2+1","v":"2009-01-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Sun)"},{"$f":"BF2+1","v":"2009-01-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Mon)"},{"$f":"BH2+1","v":"2009-01-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Tue)"},{"$f":"BJ2+1","v":"2009-01-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Wed)"},{"$f":"BL2+1","v":"2009-01-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Thu)"},{"$f":"BN2+1","v":"2009-01-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Fri)"},{"$f":"BP2+1","v":"2009-01-31"},{"$f":"TEXT(BR2,\"(aaa)\")","v":"(Sat)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BS19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BS25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BS27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BS39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BS41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS4:BS18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS19:BS39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BQ42-BS40+BS41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"2月","index":1,"n_rows":42,"n_cols":67,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,2,1)","v":"2009-02-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,2,1)","v":"2009-02-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Sun)"},{"$f":"J2+1","v":"2009-02-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Mon)"},{"$f":"L2+1","v":"2009-02-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Tue)"},{"$f":"N2+1","v":"2009-02-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Wed)"},{"$f":"P2+1","v":"2009-02-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Thu)"},{"$f":"R2+1","v":"2009-02-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Fri)"},{"$f":"T2+1","v":"2009-02-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Sat)"},{"$f":"V2+1","v":"2009-02-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Sun)"},{"$f":"X2+1","v":"2009-02-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Mon)"},{"$f":"Z2+1","v":"2009-02-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Tue)"},{"$f":"AB2+1","v":"2009-02-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Wed)"},{"$f":"AD2+1","v":"2009-02-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Thu)"},{"$f":"AF2+1","v":"2009-02-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Fri)"},{"$f":"AH2+1","v":"2009-02-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Sat)"},{"$f":"AJ2+1","v":"2009-02-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Sun)"},{"$f":"AL2+1","v":"2009-02-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Mon)"},{"$f":"AN2+1","v":"2009-02-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Tue)"},{"$f":"AP2+1","v":"2009-02-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Wed)"},{"$f":"AR2+1","v":"2009-02-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Thu)"},{"$f":"AT2+1","v":"2009-02-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Fri)"},{"$f":"AV2+1","v":"2009-02-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Sat)"},{"$f":"AX2+1","v":"2009-02-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Sun)"},{"$f":"AZ2+1","v":"2009-02-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Mon)"},{"$f":"BB2+1","v":"2009-02-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Tue)"},{"$f":"BD2+1","v":"2009-02-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Wed)"},{"$f":"BF2+1","v":"2009-02-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Thu)"},{"$f":"BH2+1","v":"2009-02-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Fri)"},{"$f":"BJ2+1","v":"2009-02-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Sat)"},{"$f":"IF((DATE(B2,3,1)-1)=DATE(B2,2,29),\"29\",\" \")","v":" "},{"$f":"TEXT(BN2,\"(aaa)\")","v":" "}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BO19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BO25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BO27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BO39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BO41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"3月","index":2,"n_rows":42,"n_cols":71,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,3,1)","v":"2009-03-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,3,1)","v":"2009-03-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Sun)"},{"$f":"J2+1","v":"2009-03-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Mon)"},{"$f":"L2+1","v":"2009-03-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Tue)"},{"$f":"N2+1","v":"2009-03-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Wed)"},{"$f":"P2+1","v":"2009-03-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Thu)"},{"$f":"R2+1","v":"2009-03-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Fri)"},{"$f":"T2+1","v":"2009-03-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Sat)"},{"$f":"V2+1","v":"2009-03-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Sun)"},{"$f":"X2+1","v":"2009-03-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Mon)"},{"$f":"Z2+1","v":"2009-03-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Tue)"},{"$f":"AB2+1","v":"2009-03-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Wed)"},{"$f":"AD2+1","v":"2009-03-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Thu)"},{"$f":"AF2+1","v":"2009-03-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Fri)"},{"$f":"AH2+1","v":"2009-03-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Sat)"},{"$f":"AJ2+1","v":"2009-03-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Sun)"},{"$f":"AL2+1","v":"2009-03-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Mon)"},{"$f":"AN2+1","v":"2009-03-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Tue)"},{"$f":"AP2+1","v":"2009-03-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Wed)"},{"$f":"AR2+1","v":"2009-03-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Thu)"},{"$f":"AT2+1","v":"2009-03-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Fri)"},{"$f":"AV2+1","v":"2009-03-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Sat)"},{"$f":"AX2+1","v":"2009-03-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Sun)"},{"$f":"AZ2+1","v":"2009-03-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Mon)"},{"$f":"BB2+1","v":"2009-03-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Tue)"},{"$f":"BD2+1","v":"2009-03-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Wed)"},{"$f":"BF2+1","v":"2009-03-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Thu)"},{"$f":"BH2+1","v":"2009-03-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Fri)"},{"$f":"BJ2+1","v":"2009-03-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Sat)"},{"$f":"BL2+1","v":"2009-03-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Sun)"},{"$f":"BN2+1","v":"2009-03-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Mon)"},{"$f":"BP2+1","v":"2009-03-31"},{"$f":"TEXT(BR2,\"(aaa)\")","v":"(Tue)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BS19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BS25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BS27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BS39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BS41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS4:BS18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS19:BS39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BQ42-BS40+BS41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"4月","index":3,"n_rows":42,"n_cols":69,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,4,1)","v":"2009-04-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,4,1)","v":"2009-04-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Wed)"},{"$f":"J2+1","v":"2009-04-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Thu)"},{"$f":"L2+1","v":"2009-04-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Fri)"},{"$f":"N2+1","v":"2009-04-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Sat)"},{"$f":"P2+1","v":"2009-04-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Sun)"},{"$f":"R2+1","v":"2009-04-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Mon)"},{"$f":"T2+1","v":"2009-04-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Tue)"},{"$f":"V2+1","v":"2009-04-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Wed)"},{"$f":"X2+1","v":"2009-04-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Thu)"},{"$f":"Z2+1","v":"2009-04-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Fri)"},{"$f":"AB2+1","v":"2009-04-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Sat)"},{"$f":"AD2+1","v":"2009-04-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Sun)"},{"$f":"AF2+1","v":"2009-04-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Mon)"},{"$f":"AH2+1","v":"2009-04-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Tue)"},{"$f":"AJ2+1","v":"2009-04-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Wed)"},{"$f":"AL2+1","v":"2009-04-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Thu)"},{"$f":"AN2+1","v":"2009-04-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Fri)"},{"$f":"AP2+1","v":"2009-04-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Sat)"},{"$f":"AR2+1","v":"2009-04-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Sun)"},{"$f":"AT2+1","v":"2009-04-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Mon)"},{"$f":"AV2+1","v":"2009-04-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Tue)"},{"$f":"AX2+1","v":"2009-04-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Wed)"},{"$f":"AZ2+1","v":"2009-04-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Thu)"},{"$f":"BB2+1","v":"2009-04-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Fri)"},{"$f":"BD2+1","v":"2009-04-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Sat)"},{"$f":"BF2+1","v":"2009-04-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Sun)"},{"$f":"BH2+1","v":"2009-04-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Mon)"},{"$f":"BJ2+1","v":"2009-04-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Tue)"},{"$f":"BL2+1","v":"2009-04-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Wed)"},{"$f":"BN2+1","v":"2009-04-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Thu)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BQ19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BQ25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BQ27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BQ39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BQ41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"5月","index":4,"n_rows":42,"n_cols":71,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,5,1)","v":"2009-05-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,5,1)","v":"2009-05-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Fri)"},{"$f":"J2+1","v":"2009-05-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Sat)"},{"$f":"L2+1","v":"2009-05-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Sun)"},{"$f":"N2+1","v":"2009-05-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Mon)"},{"$f":"P2+1","v":"2009-05-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Tue)"},{"$f":"R2+1","v":"2009-05-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Wed)"},{"$f":"T2+1","v":"2009-05-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Thu)"},{"$f":"V2+1","v":"2009-05-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Fri)"},{"$f":"X2+1","v":"2009-05-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Sat)"},{"$f":"Z2+1","v":"2009-05-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Sun)"},{"$f":"AB2+1","v":"2009-05-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Mon)"},{"$f":"AD2+1","v":"2009-05-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Tue)"},{"$f":"AF2+1","v":"2009-05-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Wed)"},{"$f":"AH2+1","v":"2009-05-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Thu)"},{"$f":"AJ2+1","v":"2009-05-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Fri)"},{"$f":"AL2+1","v":"2009-05-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Sat)"},{"$f":"AN2+1","v":"2009-05-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Sun)"},{"$f":"AP2+1","v":"2009-05-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Mon)"},{"$f":"AR2+1","v":"2009-05-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Tue)"},{"$f":"AT2+1","v":"2009-05-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Wed)"},{"$f":"AV2+1","v":"2009-05-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Thu)"},{"$f":"AX2+1","v":"2009-05-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Fri)"},{"$f":"AZ2+1","v":"2009-05-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Sat)"},{"$f":"BB2+1","v":"2009-05-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Sun)"},{"$f":"BD2+1","v":"2009-05-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Mon)"},{"$f":"BF2+1","v":"2009-05-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Tue)"},{"$f":"BH2+1","v":"2009-05-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Wed)"},{"$f":"BJ2+1","v":"2009-05-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Thu)"},{"$f":"BL2+1","v":"2009-05-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Fri)"},{"$f":"BN2+1","v":"2009-05-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Sat)"},{"$f":"BP2+1","v":"2009-05-31"},{"$f":"TEXT(BR2,\"(aaa)\")","v":"(Sun)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BS19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BS25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BS27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BS39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BS41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS4:BS18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS19:BS39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BQ42-BS40+BS41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"6月","index":5,"n_rows":42,"n_cols":69,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,6,1)","v":"2009-06-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,6,1)","v":"2009-06-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Mon)"},{"$f":"J2+1","v":"2009-06-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Tue)"},{"$f":"L2+1","v":"2009-06-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Wed)"},{"$f":"N2+1","v":"2009-06-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Thu)"},{"$f":"P2+1","v":"2009-06-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Fri)"},{"$f":"R2+1","v":"2009-06-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Sat)"},{"$f":"T2+1","v":"2009-06-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Sun)"},{"$f":"V2+1","v":"2009-06-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Mon)"},{"$f":"X2+1","v":"2009-06-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Tue)"},{"$f":"Z2+1","v":"2009-06-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Wed)"},{"$f":"AB2+1","v":"2009-06-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Thu)"},{"$f":"AD2+1","v":"2009-06-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Fri)"},{"$f":"AF2+1","v":"2009-06-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Sat)"},{"$f":"AH2+1","v":"2009-06-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Sun)"},{"$f":"AJ2+1","v":"2009-06-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Mon)"},{"$f":"AL2+1","v":"2009-06-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Tue)"},{"$f":"AN2+1","v":"2009-06-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Wed)"},{"$f":"AP2+1","v":"2009-06-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Thu)"},{"$f":"AR2+1","v":"2009-06-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Fri)"},{"$f":"AT2+1","v":"2009-06-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Sat)"},{"$f":"AV2+1","v":"2009-06-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Sun)"},{"$f":"AX2+1","v":"2009-06-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Mon)"},{"$f":"AZ2+1","v":"2009-06-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Tue)"},{"$f":"BB2+1","v":"2009-06-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Wed)"},{"$f":"BD2+1","v":"2009-06-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Thu)"},{"$f":"BF2+1","v":"2009-06-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Fri)"},{"$f":"BH2+1","v":"2009-06-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Sat)"},{"$f":"BJ2+1","v":"2009-06-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Sun)"},{"$f":"BL2+1","v":"2009-06-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Mon)"},{"$f":"BN2+1","v":"2009-06-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Tue)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BQ19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BQ25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BQ27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BQ39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BQ41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"7月","index":6,"n_rows":42,"n_cols":71,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,7,1)","v":"2009-07-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,7,1)","v":"2009-07-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Wed)"},{"$f":"J2+1","v":"2009-07-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Thu)"},{"$f":"L2+1","v":"2009-07-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Fri)"},{"$f":"N2+1","v":"2009-07-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Sat)"},{"$f":"P2+1","v":"2009-07-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Sun)"},{"$f":"R2+1","v":"2009-07-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Mon)"},{"$f":"T2+1","v":"2009-07-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Tue)"},{"$f":"V2+1","v":"2009-07-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Wed)"},{"$f":"X2+1","v":"2009-07-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Thu)"},{"$f":"Z2+1","v":"2009-07-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Fri)"},{"$f":"AB2+1","v":"2009-07-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Sat)"},{"$f":"AD2+1","v":"2009-07-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Sun)"},{"$f":"AF2+1","v":"2009-07-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Mon)"},{"$f":"AH2+1","v":"2009-07-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Tue)"},{"$f":"AJ2+1","v":"2009-07-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Wed)"},{"$f":"AL2+1","v":"2009-07-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Thu)"},{"$f":"AN2+1","v":"2009-07-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Fri)"},{"$f":"AP2+1","v":"2009-07-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Sat)"},{"$f":"AR2+1","v":"2009-07-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Sun)"},{"$f":"AT2+1","v":"2009-07-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Mon)"},{"$f":"AV2+1","v":"2009-07-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Tue)"},{"$f":"AX2+1","v":"2009-07-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Wed)"},{"$f":"AZ2+1","v":"2009-07-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Thu)"},{"$f":"BB2+1","v":"2009-07-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Fri)"},{"$f":"BD2+1","v":"2009-07-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Sat)"},{"$f":"BF2+1","v":"2009-07-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Sun)"},{"$f":"BH2+1","v":"2009-07-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Mon)"},{"$f":"BJ2+1","v":"2009-07-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Tue)"},{"$f":"BL2+1","v":"2009-07-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Wed)"},{"$f":"BN2+1","v":"2009-07-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Thu)"},{"$f":"BP2+1","v":"2009-07-31"},{"$f":"TEXT(BR2,\"(aaa)\")","v":"(Fri)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BS19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BS25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BS27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BS39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BS41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS4:BS18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS19:BS39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BQ42-BS40+BS41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"8月","index":7,"n_rows":42,"n_cols":71,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,8,1)","v":"2009-08-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,8,1)","v":"2009-08-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Sat)"},{"$f":"J2+1","v":"2009-08-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Sun)"},{"$f":"L2+1","v":"2009-08-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Mon)"},{"$f":"N2+1","v":"2009-08-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Tue)"},{"$f":"P2+1","v":"2009-08-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Wed)"},{"$f":"R2+1","v":"2009-08-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Thu)"},{"$f":"T2+1","v":"2009-08-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Fri)"},{"$f":"V2+1","v":"2009-08-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Sat)"},{"$f":"X2+1","v":"2009-08-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Sun)"},{"$f":"Z2+1","v":"2009-08-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Mon)"},{"$f":"AB2+1","v":"2009-08-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Tue)"},{"$f":"AD2+1","v":"2009-08-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Wed)"},{"$f":"AF2+1","v":"2009-08-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Thu)"},{"$f":"AH2+1","v":"2009-08-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Fri)"},{"$f":"AJ2+1","v":"2009-08-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Sat)"},{"$f":"AL2+1","v":"2009-08-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Sun)"},{"$f":"AN2+1","v":"2009-08-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Mon)"},{"$f":"AP2+1","v":"2009-08-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Tue)"},{"$f":"AR2+1","v":"2009-08-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Wed)"},{"$f":"AT2+1","v":"2009-08-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Thu)"},{"$f":"AV2+1","v":"2009-08-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Fri)"},{"$f":"AX2+1","v":"2009-08-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Sat)"},{"$f":"AZ2+1","v":"2009-08-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Sun)"},{"$f":"BB2+1","v":"2009-08-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Mon)"},{"$f":"BD2+1","v":"2009-08-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Tue)"},{"$f":"BF2+1","v":"2009-08-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Wed)"},{"$f":"BH2+1","v":"2009-08-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Thu)"},{"$f":"BJ2+1","v":"2009-08-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Fri)"},{"$f":"BL2+1","v":"2009-08-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Sat)"},{"$f":"BN2+1","v":"2009-08-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Sun)"},{"$f":"BP2+1","v":"2009-08-31"},{"$f":"TEXT(BR2,\"(aaa)\")","v":"(Mon)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BS19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BS25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BS27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BS39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BS41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS4:BS18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS19:BS39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BQ42-BS40+BS41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"9月","index":8,"n_rows":42,"n_cols":69,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,9,1)","v":"2009-09-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,9,1)","v":"2009-09-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Tue)"},{"$f":"J2+1","v":"2009-09-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Wed)"},{"$f":"L2+1","v":"2009-09-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Thu)"},{"$f":"N2+1","v":"2009-09-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Fri)"},{"$f":"P2+1","v":"2009-09-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Sat)"},{"$f":"R2+1","v":"2009-09-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Sun)"},{"$f":"T2+1","v":"2009-09-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Mon)"},{"$f":"V2+1","v":"2009-09-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Tue)"},{"$f":"X2+1","v":"2009-09-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Wed)"},{"$f":"Z2+1","v":"2009-09-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Thu)"},{"$f":"AB2+1","v":"2009-09-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Fri)"},{"$f":"AD2+1","v":"2009-09-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Sat)"},{"$f":"AF2+1","v":"2009-09-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Sun)"},{"$f":"AH2+1","v":"2009-09-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Mon)"},{"$f":"AJ2+1","v":"2009-09-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Tue)"},{"$f":"AL2+1","v":"2009-09-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Wed)"},{"$f":"AN2+1","v":"2009-09-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Thu)"},{"$f":"AP2+1","v":"2009-09-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Fri)"},{"$f":"AR2+1","v":"2009-09-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Sat)"},{"$f":"AT2+1","v":"2009-09-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Sun)"},{"$f":"AV2+1","v":"2009-09-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Mon)"},{"$f":"AX2+1","v":"2009-09-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Tue)"},{"$f":"AZ2+1","v":"2009-09-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Wed)"},{"$f":"BB2+1","v":"2009-09-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Thu)"},{"$f":"BD2+1","v":"2009-09-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Fri)"},{"$f":"BF2+1","v":"2009-09-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Sat)"},{"$f":"BH2+1","v":"2009-09-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Sun)"},{"$f":"BJ2+1","v":"2009-09-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Mon)"},{"$f":"BL2+1","v":"2009-09-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Tue)"},{"$f":"BN2+1","v":"2009-09-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Wed)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BQ19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BQ25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BQ27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BQ39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BQ41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"10月","index":9,"n_rows":42,"n_cols":71,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,10,1)","v":"2009-10-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,10,1)","v":"2009-10-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Thu)"},{"$f":"J2+1","v":"2009-10-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Fri)"},{"$f":"L2+1","v":"2009-10-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Sat)"},{"$f":"N2+1","v":"2009-10-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Sun)"},{"$f":"P2+1","v":"2009-10-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Mon)"},{"$f":"R2+1","v":"2009-10-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Tue)"},{"$f":"T2+1","v":"2009-10-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Wed)"},{"$f":"V2+1","v":"2009-10-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Thu)"},{"$f":"X2+1","v":"2009-10-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Fri)"},{"$f":"Z2+1","v":"2009-10-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Sat)"},{"$f":"AB2+1","v":"2009-10-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Sun)"},{"$f":"AD2+1","v":"2009-10-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Mon)"},{"$f":"AF2+1","v":"2009-10-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Tue)"},{"$f":"AH2+1","v":"2009-10-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Wed)"},{"$f":"AJ2+1","v":"2009-10-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Thu)"},{"$f":"AL2+1","v":"2009-10-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Fri)"},{"$f":"AN2+1","v":"2009-10-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Sat)"},{"$f":"AP2+1","v":"2009-10-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Sun)"},{"$f":"AR2+1","v":"2009-10-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Mon)"},{"$f":"AT2+1","v":"2009-10-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Tue)"},{"$f":"AV2+1","v":"2009-10-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Wed)"},{"$f":"AX2+1","v":"2009-10-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Thu)"},{"$f":"AZ2+1","v":"2009-10-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Fri)"},{"$f":"BB2+1","v":"2009-10-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Sat)"},{"$f":"BD2+1","v":"2009-10-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Sun)"},{"$f":"BF2+1","v":"2009-10-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Mon)"},{"$f":"BH2+1","v":"2009-10-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Tue)"},{"$f":"BJ2+1","v":"2009-10-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Wed)"},{"$f":"BL2+1","v":"2009-10-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Thu)"},{"$f":"BN2+1","v":"2009-10-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Fri)"},{"$f":"BP2+1","v":"2009-10-31"},{"$f":"TEXT(BR2,\"(aaa)\")","v":"(Sat)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BS19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BS25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BS27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BS39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BS41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS4:BS18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS19:BS39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BQ42-BS40+BS41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"11月","index":10,"n_rows":42,"n_cols":69,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,11,1)","v":"2009-11-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,11,1)","v":"2009-11-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Sun)"},{"$f":"J2+1","v":"2009-11-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Mon)"},{"$f":"L2+1","v":"2009-11-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Tue)"},{"$f":"N2+1","v":"2009-11-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Wed)"},{"$f":"P2+1","v":"2009-11-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Thu)"},{"$f":"R2+1","v":"2009-11-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Fri)"},{"$f":"T2+1","v":"2009-11-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Sat)"},{"$f":"V2+1","v":"2009-11-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Sun)"},{"$f":"X2+1","v":"2009-11-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Mon)"},{"$f":"Z2+1","v":"2009-11-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Tue)"},{"$f":"AB2+1","v":"2009-11-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Wed)"},{"$f":"AD2+1","v":"2009-11-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Thu)"},{"$f":"AF2+1","v":"2009-11-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Fri)"},{"$f":"AH2+1","v":"2009-11-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Sat)"},{"$f":"AJ2+1","v":"2009-11-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Sun)"},{"$f":"AL2+1","v":"2009-11-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Mon)"},{"$f":"AN2+1","v":"2009-11-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Tue)"},{"$f":"AP2+1","v":"2009-11-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Wed)"},{"$f":"AR2+1","v":"2009-11-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Thu)"},{"$f":"AT2+1","v":"2009-11-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Fri)"},{"$f":"AV2+1","v":"2009-11-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Sat)"},{"$f":"AX2+1","v":"2009-11-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Sun)"},{"$f":"AZ2+1","v":"2009-11-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Mon)"},{"$f":"BB2+1","v":"2009-11-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Tue)"},{"$f":"BD2+1","v":"2009-11-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Wed)"},{"$f":"BF2+1","v":"2009-11-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Thu)"},{"$f":"BH2+1","v":"2009-11-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Fri)"},{"$f":"BJ2+1","v":"2009-11-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Sat)"},{"$f":"BL2+1","v":"2009-11-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Sun)"},{"$f":"BN2+1","v":"2009-11-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Mon)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BQ19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BQ25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BQ27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BQ39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BQ41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}}]

{"sheet":"12月 ","index":11,"n_rows":42,"n_cols":71,"rows_kept":42,"merged":[[3,8,5,8],[6,8,13,8],[12,1,13,1],[13,5,14,5],[14,8,16,8],[15,5,16,6],[17,5,18,5],[19,5,20,6],[19,8,24,8],[21,5,22,5],[23,5,36,6],[25,8,26,8],[27,8,28,8],[34,8,38,8]]}
[]
[null,{"$f":"'1月'!B2","v":2009},"年",{"$f":"DATE(B2,12,1)","v":"2009-12-01"},"月の家計簿",{"$nulls":3},"毎日の記録",{"$f":"DATE(B2,12,1)","v":"2009-12-01"},{"$f":"TEXT(J2,\"(aaa)\")","v":"(Tue)"},{"$f":"J2+1","v":"2009-12-02"},{"$f":"TEXT(L2,\"(aaa)\")","v":"(Wed)"},{"$f":"L2+1","v":"2009-12-03"},{"$f":"TEXT(N2,\"(aaa)\")","v":"(Thu)"},{"$f":"N2+1","v":"2009-12-04"},{"$f":"TEXT(P2,\"(aaa)\")","v":"(Fri)"},{"$f":"P2+1","v":"2009-12-05"},{"$f":"TEXT(R2,\"(aaa)\")","v":"(Sat)"},{"$f":"R2+1","v":"2009-12-06"},{"$f":"TEXT(T2,\"(aaa)\")","v":"(Sun)"},{"$f":"T2+1","v":"2009-12-07"},{"$f":"TEXT(V2,\"(aaa)\")","v":"(Mon)"},{"$f":"V2+1","v":"2009-12-08"},{"$f":"TEXT(X2,\"(aaa)\")","v":"(Tue)"},{"$f":"X2+1","v":"2009-12-09"},{"$f":"TEXT(Z2,\"(aaa)\")","v":"(Wed)"},{"$f":"Z2+1","v":"2009-12-10"},{"$f":"TEXT(AB2,\"(aaa)\")","v":"(Thu)"},{"$f":"AB2+1","v":"2009-12-11"},{"$f":"TEXT(AD2,\"(aaa)\")","v":"(Fri)"},{"$f":"AD2+1","v":"2009-12-12"},{"$f":"TEXT(AF2,\"(aaa)\")","v":"(Sat)"},{"$f":"AF2+1","v":"2009-12-13"},{"$f":"TEXT(AH2,\"(aaa)\")","v":"(Sun)"},{"$f":"AH2+1","v":"2009-12-14"},{"$f":"TEXT(AJ2,\"(aaa)\")","v":"(Mon)"},{"$f":"AJ2+1","v":"2009-12-15"},{"$f":"TEXT(AL2,\"(aaa)\")","v":"(Tue)"},{"$f":"AL2+1","v":"2009-12-16"},{"$f":"TEXT(AN2,\"(aaa)\")","v":"(Wed)"},{"$f":"AN2+1","v":"2009-12-17"},{"$f":"TEXT(AP2,\"(aaa)\")","v":"(Thu)"},{"$f":"AP2+1","v":"2009-12-18"},{"$f":"TEXT(AR2,\"(aaa)\")","v":"(Fri)"},{"$f":"AR2+1","v":"2009-12-19"},{"$f":"TEXT(AT2,\"(aaa)\")","v":"(Sat)"},{"$f":"AT2+1","v":"2009-12-20"},{"$f":"TEXT(AV2,\"(aaa)\")","v":"(Sun)"},{"$f":"AV2+1","v":"2009-12-21"},{"$f":"TEXT(AX2,\"(aaa)\")","v":"(Mon)"},{"$f":"AX2+1","v":"2009-12-22"},{"$f":"TEXT(AZ2,\"(aaa)\")","v":"(Tue)"},{"$f":"AZ2+1","v":"2009-12-23"},{"$f":"TEXT(BB2,\"(aaa)\")","v":"(Wed)"},{"$f":"BB2+1","v":"2009-12-24"},{"$f":"TEXT(BD2,\"(aaa)\")","v":"(Thu)"},{"$f":"BD2+1","v":"2009-12-25"},{"$f":"TEXT(BF2,\"(aaa)\")","v":"(Fri)"},{"$f":"BF2+1","v":"2009-12-26"},{"$f":"TEXT(BH2,\"(aaa)\")","v":"(Sat)"},{"$f":"BH2+1","v":"2009-12-27"},{"$f":"TEXT(BJ2,\"(aaa)\")","v":"(Sun)"},{"$f":"BJ2+1","v":"2009-12-28"},{"$f":"TEXT(BL2,\"(aaa)\")","v":"(Mon)"},{"$f":"BL2+1","v":"2009-12-29"},{"$f":"TEXT(BN2,\"(aaa)\")","v":"(Tue)"},{"$f":"BN2+1","v":"2009-12-30"},{"$f":"TEXT(BP2,\"(aaa)\")","v":"(Wed)"},{"$f":"BP2+1","v":"2009-12-31"},{"$f":"TEXT(BR2,\"(aaa)\")","v":"(Thu)"}]
[{"$nulls":9},"品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額","品名","金額"]
[null,"今月の収入",{"$nulls":3},"今月の生活費",null,null,"主食","米５Ｋｇ",{"v":2600,"d":"2,600"}]
[null,"項目","金額","入金日",null,"項目","購入金額",null,null,"食パン",160]
[null,"給料（手取り）",{"v":300000,"d":"300,000 "},null,null,"食費合計",{"$f":"SUM(J19:BS19)","v":{"v":6951,"d":"6,951"}}]
[{"$nulls":5},"日用雑貨合計",{"$f":"SUM(J20:BS25)","v":398},null,"副食","卵６個",168,"鳥ムネ肉",552]
[{"$nulls":5},"教育・教養費",{"$f":"SUM(J26:BS27)","v":1200},null,null,"キャベツ",200,"長ネギ３本",250]
[null,"ボーナス",{"$nulls":3},"上記以外合計",{"$f":"SUM(J28:BS39)","v":3500},null,null,"ブロッコリー",250,"ツナ缶+3",346]
[null,"収入合計",{"$f":"SUM(C6:C9)","v":{"v":300000,"d":"¥300,000"}},null,null,"生活費合計",{"$f":"SUM(G6:G9)","v":{"v":12049,"d":"¥12,049"}},{"$nulls":4},"りんご２個",300]
[]
[]
[null,"今月の固定支出"]
[{"$nulls":5},"今月の残金"]
[null,"項目","金額","支払日",{"$nulls":4},"嗜好品","ビール６本",{"v":1980,"d":"1,980"},"ポテトチップ",145]
[null,"電気代",{"v":4500,"d":"4,500 "},null,null,{"$f":"C10-C37-G10+SUM(J41:BS41)","v":{"v":116231,"d":"¥116,231"}}]
[null,"ガス代",{"v":3800,"d":"3,800 "}]
[null,"水道代",{"v":1040,"d":"1,040 "},null,null,"累計残金",null,null,"外食"]
[null,"電話代",{"v":4000,"d":"4,000 "},{"$nulls":5},"食費合計",null,{"$f":"SUM(K4:K18)","v":{"v":5358,"d":"¥5,358"}},null,{"$f":"SUM(M4:M18)","v":{"v":1593,"d":"¥1,593"}},null,{"$f":"SUM(O4:O18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q4:Q18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S4:S18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U4:U18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W4:W18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y4:Y18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA4:AA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC4:AC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE4:AE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG4:AG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI4:AI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK4:AK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM4:AM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO4:AO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ4:AQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS4:AS18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU4:AU18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW4:AW18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY4:AY18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA4:BA18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC4:BC18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE4:BE18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG4:BG18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI4:BI18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK4:BK18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM4:BM18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO4:BO18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ4:BQ18)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS4:BS18)","v":{"v":0,"d":"¥0"}}]
[null,"携帯電話代",{"v":8600,"d":"8,600 "},null,null,{"$f":"F16","v":{"v":116231,"d":"¥116,231"}},null,null,"日用雑貨","T・ペーパー",398]
[null,"新聞代",{"v":2980,"d":"2,980 "}]
[null,"受信料",{"v":2500,"d":"2,500 "},null,null,"今月のひとこと"]
[null,"住居費",{"v":114000,"d":"114,000 "}]
[null,"インターネット代",{"v":1800,"d":"1,800 "}]
[null,"保険",{"v":10000,"d":"10,000 "}]
[null,"定期預金",{"v":20000,"d":"20,000 "},{"$nulls":5},"教育・教養費",null,null,"書籍",{"v":1200,"d":"1,200"}]
[null,"ローン"]
[null,"クレジット",{"$nulls":6},"衣料費"]
[null,"税金"]
[null,"こづかい",{"$nulls":6},"医療費"]
[null,"貯金",{"$nulls":6},"美容費",null,null,"カット",{"v":3500,"d":"3,500"}]
[{"$nulls":8},"交通費"]
[{"$nulls":8},"レジャー費"]
[{"$nulls":8},"慶弔・交際費"]
[{"$nulls":8},"その他"]
[]
[null,"固定支出合計",{"$f":"SUM(C16:C36)","v":{"v":173220,"d":"¥173,220"}}]
[]
[]
[{"$nulls":8},"支出合計",null,{"$f":"SUM(K19:K39)","v":{"v":5756,"d":"¥5,756"}},null,{"$f":"SUM(M19:M39)","v":{"v":6293,"d":"¥6,293"}},null,{"$f":"SUM(O19:O39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Q19:Q39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(S19:S39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(U19:U39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(W19:W39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(Y19:Y39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AA19:AA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AC19:AC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AE19:AE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AG19:AG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AI19:AI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AK19:AK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AM19:AM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AO19:AO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AQ19:AQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AS19:AS39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AU19:AU39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AW19:AW39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(AY19:AY39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BA19:BA39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BC19:BC39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BE19:BE39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BG19:BG39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BI19:BI39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BK19:BK39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BM19:BM39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BO19:BO39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BQ19:BQ39)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(BS19:BS39)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":8},"臨時収入",{"$nulls":3},{"v":1500,"d":"¥1,500"}]
[{"$nulls":8},"差引残高",null,{"$f":"C10-C37-K40+K41","v":{"v":121024,"d":"¥121,024"}},null,{"$f":"K42-M40+M41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"M42-O40+O41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"O42-Q40+Q41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Q42-S40+S41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"S42-U40+U41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"U42-W40+W41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"W42-Y40+Y41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"Y42-AA40+AA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AA42-AC40+AC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AC42-AE40+AE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AE42-AG40+AG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AG42-AI40+AI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AI42-AK40+AK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AK42-AM40+AM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AM42-AO40+AO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AO42-AQ40+AQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AQ42-AS40+AS41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AS42-AU40+AU41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AU42-AW40+AW41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AW42-AY40+AY41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"AY42-BA40+BA41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BA42-BC40+BC41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BC42-BE40+BE41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BE42-BG40+BG41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BG42-BI40+BI41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BI42-BK40+BK41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BK42-BM40+BM41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BM42-BO40+BO41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BO42-BQ40+BQ41","v":{"v":116231,"d":"¥116,231"}},null,{"$f":"BQ42-BS40+BS41","v":{"v":116231,"d":"¥116,231"}}]