{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["家計簿表紙","収支表","第1週目","第2週目","第3週目","第4週目","第5週目","家計簿表紙使い方","収支表使い方","第1週目使い方"],"not_rendered":{"images":1,"defined_names":10,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"家計簿表紙","index":0,"n_rows":3,"n_cols":8,"rows_kept":3}
["締め日",{"$f":"IF(H1=\"\",\"\",YEAR(H1))","v":""},"年",{"$f":"IF(H1=\"\",\"\",MONTH(H1))","v":""},"月",{"$f":"IF(H1=\"\",\"\",DAY(H1))","v":""},"日",{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(OR(AND(D3=1,F3=30),AND(D3=1,F3=31)),(DATE(YEAR(H3),MONTH(H3)+2,1)-1),DATE(YEAR(H3),MONTH(H3)+1,DAY(H3)-1)))","v":""}]
[]
["開始年月日",null,"年",null,"月",null,"日",{"$f":"IF(OR(B3=\"\",D3=\"\",F3=\"\"),\"\",DATE($B$3,$D$3,$F$3))","v":""}]

{"sheet":"収支表","index":1,"n_rows":30,"n_cols":14,"rows_kept":30,"merged":[[6,1,6,3],[6,6,6,9],[6,11,6,13],[19,1,19,4],[22,6,22,8]]}
[null,"※薄い灰色のセルは計算式が入っています。何も入力しないでください。"]
[null,{"$f":"家計簿表紙!B3","v":0},"年",{"$f":"家計簿表紙!D3","v":0},"月分収支表"]
[]
[null,"今月自由に使えるお金",{"$nulls":4},{"$f":"C14-H21-M30-C30","v":0},"円",null,"今月の収支",null,null,{"$f":"C14-I21-M30-D30-H30","v":0},"円"]
[null,"（A-B（予算）-C-D(予算）)",{"$nulls":7},"（A-B（実際）-C-D(実際）-E)"]
[]
[null,"収入 A",{"$nulls":4},"支出Ⅰ    B (流動性ありの支出)",{"$nulls":4},"支出Ⅱ   C (固定金額支出)"]
[null,"項目","金額","月日",null,null,"項目","予算額","実際額","月日",null,"項目","金額","月日"]
[null,"給料（夫）"]
[null,"給料（妻）"]
[]
[]
[]
[null,"合計",{"$f":"SUM(C9:C13)","v":{"v":0,"d":"¥0"}}]
[]
[]
[]
[]
[]
[null,"特別支出 D",{"$nulls":4},"貯蓄"]
[null,"項目","予算額","実際額","月日",null,"合計",{"$f":"SUM(H9:H20)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(I9:I20)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"2008-11-26"]
[null,"パパ誕生日",{"$nulls":4},"週間集計表 E"]
[{"$nulls":4},"2008-11-25",null,"項目","金額","残高"]
[{"$nulls":4},"2008-11-25",null,"第1週目",{"$f":"第1週目!P35","v":{"v":0,"d":"¥0"}},{"$f":"G4-H25","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"2008-12-09",null,"第2週目",{"$f":"第2週目!P35","v":{"v":0,"d":"¥0"}},{"$f":"G4-(H25+H26)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":6},"第3週目",{"$f":"第3週目!P35","v":{"v":0,"d":"¥0"}},{"$f":"G4-(H25+H26+H27)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":6},"第4週目",{"$f":"第4週目!P35","v":{"v":0,"d":"¥0"}},{"$f":"G4-(H25+H26+H27+H28)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":6},"第5週目",{"$f":"第5週目!H35","v":{"v":0,"d":"¥0"}},{"$f":"G4-(H25+H26+H27+H28+H29)","v":{"v":0,"d":"¥0"}}]
[null,"合計",{"$f":"SUM(C22:C29)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(D22:D29)","v":{"v":0,"d":"¥0"}},null,null,"合計",{"$f":"SUM(H25:H29)","v":{"v":0,"d":"¥0"}},{"$nulls":3},"合計",{"$f":"SUM(M9:M29)","v":{"v":0,"d":"¥0"}}]

{"sheet":"第1週目","index":2,"n_rows":36,"n_cols":16,"rows_kept":36,"merged":[[1,15,2,15],[3,0,11,0],[13,0,19,0],[21,0,25,0],[27,0,31,0]]}
["第 1 週目"]
[null,{"$f":"IF(OR(家計簿表紙!$B$3=\"\",家計簿表紙!$D$3=\"\",家計簿表紙!$F$3=\"\"),\"\",DATE(家計簿表紙!$B$3,家計簿表紙!$D$3,家計簿表紙!$F$3))","v":""},{"$f":"TEXT(B2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(B2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),B2+1,\"\"))","v":""},{"$f":"TEXT(D2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(D2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),D2+1,\"\"))","v":""},{"$f":"TEXT(F2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(F2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),F2+1,\"\"))","v":""},{"$f":"TEXT(H2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(H2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),H2+1,\"\"))","v":""},{"$f":"TEXT(J2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(J2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),J2+1,\"\"))","v":""},{"$f":"TEXT(L2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(L2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),L2+1,\"\"))","v":""},{"$f":"TEXT(N2,\"(aaaa)\")","v":""},"集計"]
[null,"内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額"]
["食費"]
{"$rows_empty":8}
["小計",null,{"$f":"SUM(C4:C12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E4:E12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G4:G12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I4:I12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K4:K12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M4:M12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O4:O12)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C13:O13)","v":{"v":0,"d":"¥0"}}]
["日用雑貨"]
[]
[]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C14:C20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E14:E20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G14:G20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I14:I20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K14:K20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M14:M20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O14:O20)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C21:O21)","v":{"v":0,"d":"¥0"}}]
["子供費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C22:C26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E22:E26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G22:G26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I22:I26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K22:K26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M22:M26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O22:O26)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C27:O27)","v":{"v":0,"d":"¥0"}}]
["特別出費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C28:C32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E28:E32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G28:G32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I28:I32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K28:K32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M28:M32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O28:O32)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C33:O33)","v":{"v":0,"d":"¥0"}}]
["臨時収入",{"$nulls":14},{"$f":"SUM(C34:O34)","v":{"v":0,"d":"¥0"}}]
["支出合計",null,{"$f":"SUM(C13,C21,C27,C33,-C34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E13,E21,E27,E33,-E34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G13,G21,G27,G33,-G34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I13,I21,I27,I33,-I34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K13,K21,K27,K33,-K34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M13,M21,M27,M33,-M34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O13,O21,O27,O33,-O34)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C35:O35)","v":{"v":0,"d":"¥0"}}]
["メモ"]

{"sheet":"第2週目","index":3,"n_rows":36,"n_cols":16,"rows_kept":36,"merged":[[1,15,2,15],[3,0,11,0],[13,0,19,0],[21,0,25,0],[27,0,31,0]]}
["第 2 週目"]
[null,{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(第1週目!N2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),第1週目!N2+1,\"\"))","v":""},{"$f":"TEXT(B2,\"(aaaa)\")","v":""},{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(B2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),B2+1,\"\"))","v":""},{"$f":"TEXT(D2,\"(aaaa)\")","v":""},{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(D2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),D2+1,\"\"))","v":""},"",{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(F2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),F2+1,\"\"))","v":""},"",{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(H2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),H2+1,\"\"))","v":""},"",{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(J2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),J2+1,\"\"))","v":""},"",{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(L2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),L2+1,\"\"))","v":""},"","集計"]
[null,"内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額"]
["食費"]
{"$rows_empty":8}
["小計",null,{"$f":"SUM(C4:C12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E4:E12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G4:G12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I4:I12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K4:K12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M4:M12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O4:O12)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C13:O13)","v":{"v":0,"d":"¥0"}}]
["日用雑貨"]
[]
[]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C14:C20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E14:E20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G14:G20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I14:I20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K14:K20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M14:M20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O14:O20)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C21:O21)","v":{"v":0,"d":"¥0"}}]
["子供費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C22:C26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E22:E26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G22:G26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I22:I26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K22:K26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M22:M26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O22:O26)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C27:O27)","v":{"v":0,"d":"¥0"}}]
["特別出費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C28:C32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E28:E32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G28:G32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I28:I32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K28:K32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M28:M32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O28:O32)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C33:O33)","v":{"v":0,"d":"¥0"}}]
["臨時収入",{"$nulls":14},{"$f":"SUM(C34:O34)","v":{"v":0,"d":"¥0"}}]
["支出合計",null,{"$f":"SUM(C13,C21,C27,C33,-C34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E13,E21,E27,E33,-E34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G13,G21,G27,G33,-G34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I13,I21,I27,I33,-I34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K13,K21,K27,K33,-K34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M13,M21,M27,M33,-M34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O13,O21,O27,O33,-O34)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C35:O35)","v":{"v":0,"d":"¥0"}}]
["メモ"]

{"sheet":"第3週目","index":4,"n_rows":36,"n_cols":16,"rows_kept":36,"merged":[[1,15,2,15],[3,0,11,0],[13,0,19,0],[21,0,25,0],[27,0,31,0]]}
["第 3 週目"]
[null,{"$f":"IF(第2週目!$B$2=\"\",\"\",IF(第2週目!N2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),第2週目!N2+1,\"\"))","v":""},{"$f":"TEXT(B2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(B2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),B2+1,\"\"))","v":""},{"$f":"TEXT(D2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(D2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),D2+1,\"\"))","v":""},{"$f":"TEXT(F2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(F2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),F2+1,\"\"))","v":""},{"$f":"TEXT(H2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(H2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),H2+1,\"\"))","v":""},{"$f":"TEXT(J2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(J2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),J2+1,\"\"))","v":""},{"$f":"TEXT(L2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(L2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),L2+1,\"\"))","v":""},{"$f":"TEXT(N2,\"(aaaa)\")","v":""},"集計"]
[null,"内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額"]
["食費"]
{"$rows_empty":8}
["小計",null,{"$f":"SUM(C4:C12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E4:E12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G4:G12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I4:I12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K4:K12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M4:M12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O4:O12)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C13:O13)","v":{"v":0,"d":"¥0"}}]
["日用雑貨"]
[]
[]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C14:C20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E14:E20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G14:G20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I14:I20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K14:K20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M14:M20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O14:O20)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C21:O21)","v":{"v":0,"d":"¥0"}}]
["子供費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C22:C26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E22:E26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G22:G26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I22:I26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K22:K26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M22:M26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O22:O26)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C27:O27)","v":{"v":0,"d":"¥0"}}]
["特別出費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C28:C32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E28:E32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G28:G32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I28:I32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K28:K32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M28:M32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O28:O32)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C33:O33)","v":{"v":0,"d":"¥0"}}]
["臨時収入",{"$nulls":14},{"$f":"SUM(C34:O34)","v":{"v":0,"d":"¥0"}}]
["支出合計",null,{"$f":"SUM(C13,C21,C27,C33,-C34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E13,E21,E27,E33,-E34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G13,G21,G27,G33,-G34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I13,I21,I27,I33,-I34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K13,K21,K27,K33,-K34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M13,M21,M27,M33,-M34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O13,O21,O27,O33,-O34)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C35:O35)","v":{"v":0,"d":"¥0"}}]
["メモ"]

{"sheet":"第4週目","index":5,"n_rows":36,"n_cols":16,"rows_kept":36,"merged":[[1,15,2,15],[3,0,11,0],[13,0,19,0],[21,0,25,0],[27,0,31,0]]}
["第 4 週目"]
[null,{"$f":"IF(第3週目!$B$2=\"\",\"\",IF(第3週目!N2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),第3週目!N2+1,\"\"))","v":""},{"$f":"TEXT(B2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(B2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),B2+1,\"\"))","v":""},{"$f":"TEXT(D2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(D2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),D2+1,\"\"))","v":""},{"$f":"TEXT(F2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(F2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),F2+1,\"\"))","v":""},{"$f":"TEXT(H2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(H2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),H2+1,\"\"))","v":""},{"$f":"TEXT(J2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(J2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),J2+1,\"\"))","v":""},{"$f":"TEXT(L2,\"(aaaa)\")","v":""},{"$f":"IF($B$2=\"\",\"\",IF(L2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),L2+1,\"\"))","v":""},{"$f":"TEXT(N2,\"(aaaa)\")","v":""},"集計"]
[null,"内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額"]
["食費"]
{"$rows_empty":8}
["小計",null,{"$f":"SUM(C4:C12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E4:E12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G4:G12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I4:I12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K4:K12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M4:M12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O4:O12)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C13:O13)","v":{"v":0,"d":"¥0"}}]
["日用雑貨"]
[]
[]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C14:C20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E14:E20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G14:G20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I14:I20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K14:K20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M14:M20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O14:O20)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C21:O21)","v":{"v":0,"d":"¥0"}}]
["子供費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C22:C26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E22:E26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G22:G26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I22:I26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K22:K26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M22:M26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O22:O26)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C27:O27)","v":{"v":0,"d":"¥0"}}]
["特別出費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C28:C32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E28:E32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G28:G32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I28:I32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K28:K32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M28:M32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O28:O32)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C33:O33)","v":{"v":0,"d":"¥0"}}]
["臨時収入",{"$nulls":14},{"$f":"SUM(C34:O34)","v":{"v":0,"d":"¥0"}}]
["支出合計",null,{"$f":"SUM(C13,C21,C27,C33,-C34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E13,E21,E27,E33,-E34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G13,G21,G27,G33,-G34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I13,I21,I27,I33,-I34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K13,K21,K27,K33,-K34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M13,M21,M27,M33,-M34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O13,O21,O27,O33,-O34)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C35:O35)","v":{"v":0,"d":"¥0"}}]
["メモ"]

{"sheet":"第5週目","index":6,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[3,0,11,0],[13,0,19,0],[21,0,25,0],[27,0,31,0]]}
["第 5 週目"]
[null,{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(第4週目!N2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),第4週目!N2+1,\"\"))","v":""},{"$f":"TEXT(B2,\"(aaaa)\")","v":""},{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(B2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),B2+1,\"\"))","v":""},{"$f":"TEXT(D2,\"(aaaa)\")","v":""},{"$f":"IF(第1週目!$B$2=\"\",\"\",IF(D2<DATE(家計簿表紙!$B$1,家計簿表紙!$D$1,家計簿表紙!$F$1),D2+1,\"\"))","v":""},{"$f":"TEXT(F2,\"(aaaa)\")","v":""},"集計"]
[null,"内容","金額","内容","金額","内容","金額"]
["食費"]
{"$rows_empty":8}
["小計",null,{"$f":"SUM(C4:C12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E4:E12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G4:G12)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C13:G13)","v":0}]
["日用雑貨"]
[]
[]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C14:C20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E14:E20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G14:G20)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C21:G21)","v":0}]
["子供費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C22:C26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E22:E26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G22:G26)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C27:G27)","v":0}]
["特別出費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C28:C32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E28:E32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G28:G32)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C33:G33)","v":0}]
["臨時収入",{"$nulls":6},{"$f":"SUM(C34:G34)","v":{"v":0,"d":"¥0"}}]
["支出合計",null,{"$f":"SUM(C13,C21,C27,C33,-C34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E13,E21,E27,E33,-E34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G13,G21,G27,G33,-G34)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C35:G35)","v":0}]
["メモ"]

{"sheet":"家計簿表紙使い方","index":7,"n_rows":3,"n_cols":8,"rows_kept":3}
["締め日",{"$f":"IF(H1=\"\",\"\",YEAR(H1))","v":2008},"年",{"$f":"IF(H1=\"\",\"\",MONTH(H1))","v":12},"月",{"$f":"IF(H1=\"\",\"\",DAY(H1))","v":24},"日",{"$f":"IF(第1週目使い方!$B$2=\"\",\"\",IF(OR(AND(D3=1,F3=30),AND(D3=1,F3=31)),(DATE(YEAR(H3),MONTH(H3)+2,1)-1),DATE(YEAR(H3),MONTH(H3)+1,DAY(H3)-1)))","v":"2008-12-24"}]
[]
["開始年月日",2008,"年",11,"月",25,"日",{"$f":"IF(OR(B3=\"\",D3=\"\",F3=\"\"),\"\",DATE($B$3,$D$3,$F$3))","v":"2008-11-25"}]

{"sheet":"収支表使い方","index":8,"n_rows":30,"n_cols":14,"rows_kept":30,"merged":[[6,1,6,3],[6,6,6,9],[6,11,6,13],[19,1,19,4],[22,6,22,8]]}
[null,"※薄い灰色のセルは計算式が入っています。何も入力しないでください。"]
[null,{"$f":"家計簿表紙使い方!B3","v":2008},"年",{"$f":"家計簿表紙使い方!D3","v":11},"月分収支表"]
[]
[null,"今月自由に使えるお金",{"$nulls":4},{"$f":"C14-H21-M30-C30","v":78500},"円",null,"今月の収支",null,null,{"$f":"C14-I21-M30-D30-H30","v":77640},"円"]
[null,"（A-B（予算）-C-D(予算）)",{"$nulls":7},"（A-B（実際）-C-D(実際）-E)"]
[]
[null,"収入 A",{"$nulls":4},"支出Ⅰ    B (流動性ありの支出)",{"$nulls":4},"支出Ⅱ   C (固定金額支出)"]
[null,"項目","金額","月日",null,null,"項目","予算額","実際額","月日",null,"項目","金額","月日"]
[null,"給料（夫）",{"v":300000,"d":"¥300,000"},"2008-11-25",null,null,"電気",{"v":8000,"d":"¥8,000"},{"v":9800,"d":"¥9,800"},null,null,"住居費",{"v":98000,"d":"¥98,000"}]
[null,"給料（妻）",{"v":30000,"d":"¥30,000"},"2008-11-25",null,null,"ガス",{"v":8000,"d":"¥8,000"},{"v":7300,"d":"¥7,300"},null,null,"管理費",{"v":13000,"d":"¥13,000"}]
[{"$nulls":6},"水道",{"v":4000,"d":"¥4,000"},{"v":3400,"d":"¥3,400"},null,null,"駐車場",{"v":10000,"d":"¥10,000"}]
[{"$nulls":6},"電話",{"v":7000,"d":"¥7,000"},{"v":6800,"d":"¥6,800"},null,null,"新聞",{"v":4000,"d":"¥4,000"}]
[null,"繰越金",{"v":6300,"d":"¥6,300"},{"$nulls":3},"携帯電話",{"v":3000,"d":"¥3,000"},{"v":2700,"d":"¥2,700"},null,null,"受信料",{"v":2500,"d":"¥2,500"}]
[null,"合計",{"$f":"SUM(C9:C13)","v":{"v":336300,"d":"¥336,300"}},{"$nulls":3},"プロバイダー",{"v":1200,"d":"¥1,200"},{"v":1500,"d":"¥1,500"},null,null,"保育料",{"v":23600,"d":"¥23,600"}]
[{"$nulls":6},"ガソリン",{"v":5000,"d":"¥5,000"},{"v":3000,"d":"¥3,000"},null,null,"通園バス",{"v":3500,"d":"¥3,500"}]
[{"$nulls":11},"サッカー",{"v":3000,"d":"¥3,000"}]
[{"$nulls":11},"スイミング",{"v":6000,"d":"¥6,000"}]
[{"$nulls":11},"子ども保険",{"v":1000,"d":"¥1,000"}]
[{"$nulls":11},"医療保険","天引き"]
[null,"特別支出 D",{"$nulls":4},"貯蓄",{"$nulls":4},"終身保険","天引き"]
[null,"項目","予算額","実際額","月日",null,"合計",{"$f":"SUM(H9:H20)","v":{"v":36200,"d":"¥36,200"}},{"$f":"SUM(I9:I20)","v":{"v":34500,"d":"¥34,500"}}]
[null,"自動車保険",{"v":40000,"d":"¥40,000"},{"v":37800,"d":"¥37,800"},"2008-11-26",{"$nulls":6},"カード支払い"]
[null,"パパ誕生日",{"v":10000,"d":"¥10,000"},{"$nulls":3},"週間集計表 E"]
[null,"ケーキ",null,{"v":3500,"d":"¥3,500"},"2008-11-25",null,"項目","金額","残高"]
[null,"プレゼント",null,{"v":4000,"d":"¥4,000"},"2008-11-25",null,"第1週目",{"$f":"第1週目使い方!P35","v":{"v":7830,"d":"¥7,830"}},{"$f":"G4-H25","v":{"v":70670,"d":"¥70,670"}}]
[null,"3学期給食",{"v":7000,"d":"¥7,000"},{"v":6430,"d":"¥6,430"},"2008-12-09",null,"第2週目",{"v":0,"d":"¥0"},{"$f":"G4-(H25+H26)","v":{"v":70670,"d":"¥70,670"}}]
[{"$nulls":6},"第3週目",{"v":0,"d":"¥0"},{"$f":"G4-(H25+H26+H27)","v":{"v":70670,"d":"¥70,670"}}]
[{"$nulls":6},"第4週目",{"v":0,"d":"¥0"},{"$f":"G4-(H25+H26+H27+H28)","v":{"v":70670,"d":"¥70,670"}}]
[{"$nulls":6},"第5週目",{"v":0,"d":"¥0"},{"$f":"G4-(H25+H26+H27+H28+H29)","v":{"v":70670,"d":"¥70,670"}}]
[null,"合計",{"$f":"SUM(C22:C29)","v":{"v":57000,"d":"¥57,000"}},{"$f":"SUM(D22:D29)","v":{"v":51730,"d":"¥51,730"}},null,null,"合計",{"$f":"SUM(H25:H29)","v":{"v":7830,"d":"¥7,830"}},{"$nulls":3},"合計",{"$f":"SUM(M9:M29)","v":{"v":164600,"d":"¥164,600"}}]

{"sheet":"第1週目使い方","index":9,"n_rows":36,"n_cols":16,"rows_kept":36,"merged":[[1,15,2,15],[3,0,11,0],[13,0,19,0],[21,0,25,0],[27,0,31,0]]}
["第 1 週目"]
[null,{"$f":"IF(OR(家計簿表紙使い方!$B$3=\"\",家計簿表紙使い方!$D$3=\"\",家計簿表紙使い方!$F$3=\"\"),\"\",DATE(家計簿表紙使い方!$B$3,家計簿表紙使い方!$D$3,家計簿表紙使い方!$F$3))","v":"2008-11-25"},{"$f":"TEXT(B2,\"(aaaa)\")","v":"(Tuesday)"},{"$f":"IF($B$2=\"\",\"\",IF(B2<DATE(家計簿表紙使い方!$B$1,家計簿表紙使い方!$D$1,家計簿表紙使い方!$F$1),B2+1,\"\"))","v":"2008-11-26"},{"$f":"TEXT(D2,\"(aaaa)\")","v":"(Wednesday)"},{"$f":"IF($B$2=\"\",\"\",IF(D2<DATE(家計簿表紙使い方!$B$1,家計簿表紙使い方!$D$1,家計簿表紙使い方!$F$1),D2+1,\"\"))","v":"2008-11-27"},{"$f":"TEXT(F2,\"(aaaa)\")","v":"(Thursday)"},{"$f":"IF($B$2=\"\",\"\",IF(F2<DATE(家計簿表紙使い方!$B$1,家計簿表紙使い方!$D$1,家計簿表紙使い方!$F$1),F2+1,\"\"))","v":"2008-11-28"},{"$f":"TEXT(H2,\"(aaaa)\")","v":"(Friday)"},{"$f":"IF($B$2=\"\",\"\",IF(H2<DATE(家計簿表紙使い方!$B$1,家計簿表紙使い方!$D$1,家計簿表紙使い方!$F$1),H2+1,\"\"))","v":"2008-11-29"},{"$f":"TEXT(J2,\"(aaaa)\")","v":"(Saturday)"},{"$f":"IF($B$2=\"\",\"\",IF(J2<DATE(家計簿表紙使い方!$B$1,家計簿表紙使い方!$D$1,家計簿表紙使い方!$F$1),J2+1,\"\"))","v":"2008-11-30"},{"$f":"TEXT(L2,\"(aaaa)\")","v":"(Sunday)"},{"$f":"IF($B$2=\"\",\"\",IF(L2<DATE(家計簿表紙使い方!$B$1,家計簿表紙使い方!$D$1,家計簿表紙使い方!$F$1),L2+1,\"\"))","v":"2008-12-01"},{"$f":"TEXT(N2,\"(aaaa)\")","v":"(Monday)"},"集計"]
[null,"内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額","内容","金額"]
["食費","スーパー",{"v":2780,"d":"¥2,780"}]
[null,"チキン",{"v":1200,"d":"¥1,200"}]
{"$rows_empty":7}
["小計",null,{"$f":"SUM(C4:C12)","v":{"v":3980,"d":"¥3,980"}},null,{"$f":"SUM(E4:E12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G4:G12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I4:I12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K4:K12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M4:M12)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O4:O12)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C13:O13)","v":{"v":3980,"d":"¥3,980"}}]
["日用雑貨",null,null,"ドラッグA",{"v":2800,"d":"¥2,800"}]
[]
[]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C14:C20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E14:E20)","v":{"v":2800,"d":"¥2,800"}},null,{"$f":"SUM(G14:G20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I14:I20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K14:K20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M14:M20)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O14:O20)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C21:O21)","v":{"v":2800,"d":"¥2,800"}}]
["子供費",{"$nulls":4},"靴下",{"v":1050,"d":"¥1,050"}]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C22:C26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E22:E26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G22:G26)","v":{"v":1050,"d":"¥1,050"}},null,{"$f":"SUM(I22:I26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K22:K26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M22:M26)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O22:O26)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C27:O27)","v":{"v":1050,"d":"¥1,050"}}]
["特別出費"]
[]
[]
[]
[]
["小計",null,{"$f":"SUM(C28:C32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(E28:E32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(G28:G32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(I28:I32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K28:K32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M28:M32)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O28:O32)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C33:O33)","v":{"v":0,"d":"¥0"}}]
["臨時収入",{"$nulls":14},{"$f":"SUM(C34:O34)","v":{"v":0,"d":"¥0"}}]
["支出合計",null,{"$f":"SUM(C13,C21,C27,C33,-C34)","v":{"v":3980,"d":"¥3,980"}},null,{"$f":"SUM(E13,E21,E27,E33,-E34)","v":{"v":2800,"d":"¥2,800"}},null,{"$f":"SUM(G13,G21,G27,G33,-G34)","v":{"v":1050,"d":"¥1,050"}},null,{"$f":"SUM(I13,I21,I27,I33,-I34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(K13,K21,K27,K33,-K34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(M13,M21,M27,M33,-M34)","v":{"v":0,"d":"¥0"}},null,{"$f":"SUM(O13,O21,O27,O33,-O34)","v":{"v":0,"d":"¥0"}},{"$f":"SUM(C35:O35)","v":{"v":7830,"d":"¥7,830"}}]
["メモ"]