{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["支出の概要","出金仕訳帳"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"支出の概要","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"支出の概要",null,null,"支出の概要テーブルの見出しの下のカテゴリ名を変更し、ニーズに合わせてこのテンプレートをカスタマイズします。カテゴリを追加する必要がある場合は、テーブルの最後の列をコピーし、コピーした列の右に貼り付けます。カテゴリ名を変更すると、数式が自動的に更新されます。このテーブルの行数は出金仕訳帳の行数と同じになるようにしてください。"]
[null,"日付","自動車保険","事務用品","電気","住宅ローン","電話","空欄 1","空欄 2","空欄 3","空欄 4"]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A1),1),\"\")","v":"2018-04-05"},{"$f":"IFERROR(INDIRECT(\"台帳[@金額]\")*(INDIRECT(\"台帳[@カテゴリ]\")=CategoryName),\"\")","v":0},0,0,{"v":1200,"d":"¥1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A2),1),\"\")","v":"2018-04-10"},0,0,{"v":85,"d":"¥85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A3),1),\"\")","v":"2018-04-15"},{"v":100,"d":"¥100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A4),1),\"\")","v":"2018-04-20"},0,0,0,{"v":1200,"d":"¥1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A5),1),\"\")","v":"2018-04-25"},0,0,0,{"v":99,"d":"¥99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A6),1),\"\")","v":"2018-04-30"},0,0,0,0,{"v":68,"d":"¥68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A7),1),\"\")","v":"2018-05-05"},{"v":100,"d":"¥100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A8),1),\"\")","v":"2018-05-10"},0,{"v":345,"d":"¥345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A9),1),\"\")","v":"2018-05-15"},0,0,0,{"v":1200,"d":"¥1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A10),1),\"\")","v":"2018-05-20"},0,0,{"v":74,"d":"¥74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A11),1),\"\")","v":"2018-05-25"},0,0,0,0,{"v":123,"d":"¥123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A12),1),\"\")","v":"2018-05-30"},0,{"v":99,"d":"¥99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A13),1),\"\")","v":"2018-06-04"},{"v":100,"d":"¥100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A14),1),\"\")","v":"2018-06-09"},0,0,0,{"v":1200,"d":"¥1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(台帳[],ROW(A15),1),\"\")","v":"2018-06-14"},0,{"v":128,"d":"¥128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,支出の概要[自動車保険])","v":{"v":300,"d":"¥300.00"}},{"$f":"SUBTOTAL(109,支出の概要[事務用品])","v":{"v":572,"d":"¥572.00"}},{"$f":"SUBTOTAL(109,支出の概要[電気])","v":{"v":159,"d":"¥159.00"}},{"$f":"SUBTOTAL(109,支出の概要[住宅ローン])","v":{"v":4899,"d":"¥4,899.00"}},{"$f":"SUBTOTAL(109,支出の概要[電話])","v":{"v":191,"d":"¥191.00"}},{"$f":"SUBTOTAL(109,支出の概要[空欄 1])","v":0},{"$f":"SUBTOTAL(109,支出の概要[空欄 2])","v":0},{"$f":"SUBTOTAL(109,支出の概要[空欄 3])","v":0},{"$f":"SUBTOTAL(109,支出の概要[空欄 4])","v":0}]

{"sheet":"出金仕訳帳","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"出金仕訳帳"]
[null,"日付","番号","説明","カテゴリ","金額"]
[null,{"$f":"TODAY()-70","v":"2018-04-05"},"100","Woodgrove Bank","住宅ローン",{"v":1200,"d":"¥1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-10"},101,"City Power & Light","電気",{"v":85,"d":"¥85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-15"},102,"Humongous Insurance","自動車保険",{"v":100,"d":"¥100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-20"},103,"Woodgrove Bank","住宅ローン",{"v":1200,"d":"¥1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-25"},104,"City Power & Light","住宅ローン",{"v":99,"d":"¥99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-04-30"},105,"The Phone Company","電話",{"v":68,"d":"¥68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-05"},106,"Humongous Insurance","自動車保険",{"v":100,"d":"¥100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-10"},107,"Litware, Inc.","事務用品",{"v":345,"d":"¥345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-15"},110,"Woodgrove Bank","住宅ローン",{"v":1200,"d":"¥1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-20"},111,"City Power & Light","電気",{"v":74,"d":"¥74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-25"},108,"The Phone Company","電話",{"v":123,"d":"¥123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-30"},109,"Litware, Inc.","事務用品",{"v":99,"d":"¥99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-04"},112,"Humongous Insurance","自動車保険",{"v":100,"d":"¥100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-09"},113,"Woodgrove Bank","住宅ローン",{"v":1200,"d":"¥1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-14"},114,"Litware, Inc.","事務用品",{"v":128,"d":"¥128.00"}]
[null,"合計",{"$nulls":3},{"$f":"SUBTOTAL(109,台帳[金額])","v":{"v":6121,"d":"¥6,121.00"}}]