{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["初期設定","１学期会計簿","２学期会計簿","３学期会計簿"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"初期設定","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,1,4,4],[10,1,10,2],[12,1,12,2],[0,0,0,4]]}
["学級会計簿作成システム"]
[]
["平成",25,"年度"]
[]
["学校名","○○市立△△小学校"]
[]
["学年",2,"年"]
[]
["学級",3,"組"]
[]
["担任名","担任の名前"]
[]
["校長名","校長の名前"]

{"sheet":"１学期会計簿","index":1,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,0,49,2],[49,3,49,5],[1,4,1,8],[2,5,2,8],[47,0,47,2],[47,3,47,5],[48,0,48,2],[48,3,48,5]]}
["平成",{"$f":"初期設定!B3","v":25},"年度"]
[null,null,null,{"$f":"初期設定!B7&\" 年 \"&初期設定!B9&\" 組 \"","v":"2 年 3 組 "},"１学期学級会計簿"]
[null,null,null,null,null,{"$f":"初期設定!B5","v":"○○市立△△小学校"}]
["月","日","№","摘要","単価","個数","収入金額","支出金額","差引残高"]
[null,null,null,null,null,null,{"$f":"IF(AND(C5=\"\",E5<>\"\"),E5*F5,\"\")","v":""},{"$f":"IF(C5<>\"\",E5*F5,\"\")","v":""},{"$f":"G5","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(C6=\"\",E6<>\"\"),E6*F6,\"\")","v":""},{"$f":"IF(C6<>\"\",E6*F6,\"\")","v":""},{"$f":"IF(D6=\"\",\"\",IF(G6=\"\",I5-H6,I5+G6))","v":""}]
[null,null,null,null,null,null,"","",{"$f":"IF(D7=\"\",\"\",IF(G7=\"\",I6-H7,I6+G7))","v":""}]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
["計",null,null,null,null,null,{"$f":"SUM(G5:G47)","v":0},{"$f":"SUM(H5:H47)","v":0},{"$f":"G48-H48","v":0}]
[null,null,null,"二学期へ繰り越し",null,null,null,{"$f":"I48","v":0}]
["合計",null,null,null,null,null,{"$f":"G48","v":0},{"$f":"H48+H49","v":0},{"$f":"G50-H50","v":0}]
[]
[null,null,null,"上記の通り相違ありません。"]
[null,null,null,null,{"$f":"\"第 \"&初期設定!B7&\" 学年 \"&初期設定!B9&\" 組　担任 　\"&初期設定!B11","v":"第 2 学年 3 組　担任 　担任の名前"}]

{"sheet":"２学期会計簿","index":2,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,0,49,2],[49,3,49,5],[1,4,1,8],[2,5,2,8],[47,0,47,2],[47,3,47,5],[48,0,48,2],[48,3,48,5]]}
["平成",{"$f":"初期設定!B3","v":25},"年度"]
[null,null,null,{"$f":"初期設定!B7&\" 年 \"&初期設定!B9&\" 組 \"","v":"2 年 3 組 "},"２学期学級会計簿"]
[null,null,null,null,null,{"$f":"初期設定!B5","v":"○○市立△△小学校"}]
["月","日","№","摘要","単価","個数","収入金額","支出金額","差引残高"]
[null,null,null,null,null,null,null,{"$f":"IF(C5<>\"\",E5*F5,\"\")","v":""},{"$f":"G5","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(C6=\"\",E6<>\"\"),E6*F6,\"\")","v":""},{"$f":"IF(C6<>\"\",E6*F6,\"\")","v":""},{"$f":"IF(D6=\"\",\"\",IF(G6=\"\",I5-H6,I5+G6))","v":""}]
[null,null,null,null,null,null,"","",{"$f":"IF(D7=\"\",\"\",IF(G7=\"\",I6-H7,I6+G7))","v":""}]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
["計",null,null,null,null,null,{"$f":"SUM(G5:G47)","v":0},{"$f":"SUM(H5:H47)","v":0},{"$f":"G48-H48","v":0}]
[null,null,null,"二学期へ繰り越し",null,null,null,{"$f":"G48-H48","v":0}]
["合計",null,null,null,null,null,{"$f":"G48","v":0},{"$f":"SUM(H48:H49)","v":0},{"$f":"I48-H49","v":0}]
[]
[null,null,null,"上記の通り相違ありません。"]
[null,null,null,null,{"$f":"\"第 \"&初期設定!B7&\" 学年 \"&初期設定!B9&\" 組　担任 　\"&初期設定!B11","v":"第 2 学年 3 組　担任 　担任の名前"}]

{"sheet":"３学期会計簿","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,0,49,2],[49,3,49,5],[1,4,1,8],[2,5,2,8],[47,0,47,2],[47,3,47,5],[48,0,48,2],[48,3,48,5]]}
["平成",{"$f":"初期設定!B3","v":25},"年度"]
[null,null,null,{"$f":"初期設定!B7&\" 年 \"&初期設定!B9&\" 組 \"","v":"2 年 3 組 "},"３学期学級会計簿"]
[null,null,null,null,null,{"$f":"初期設定!B5","v":"○○市立△△小学校"}]
["月","日","№","摘要","単価","個数","収入金額","支出金額","差引残高"]
[null,null,null,null,null,null,null,{"$f":"IF(C5<>\"\",E5*F5,\"\")","v":""},{"$f":"G5","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(C6=\"\",E6<>\"\"),E6*F6,\"\")","v":""},{"$f":"IF(C6<>\"\",E6*F6,\"\")","v":""},{"$f":"IF(D6=\"\",\"\",IF(G6=\"\",I5-H6,I5+G6))","v":""}]
[null,null,null,null,null,null,"","",{"$f":"IF(D7=\"\",\"\",IF(G7=\"\",I6-H7,I6+G7))","v":""}]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,"","",""]
["計",null,null,null,null,null,{"$f":"SUM(G5:G47)","v":0},{"$f":"SUM(H5:H47)","v":0},{"$f":"G48-H48","v":0}]
[null,null,null,"二学期へ繰り越し",null,null,null,{"$f":"G48-H48","v":0}]
["合計",null,null,null,null,null,{"$f":"G48","v":0},{"$f":"SUM(H48:H49)","v":0},{"$f":"I48-H49","v":0}]
[]
[null,null,null,"上記の通り相違ありません。"]
[null,null,null,null,{"$f":"\"第 \"&初期設定!B7&\" 学年 \"&初期設定!B9&\" 組　担任 　\"&初期設定!B11","v":"第 2 学年 3 組　担任 　担任の名前"}]