{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["plan_sheet","DB_pages","DB_dayplan","calendar_format"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"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":"plan_sheet","index":0,"n_rows":67,"n_cols":20,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["試験名","1年生 第4回定期考査"]
["学習開始日","2021-01-24",{"$f":"IF(B2=\"\",\"\",B2)","v":44220}]
["試験日","2021-02-24",{"$f":"IF(B3=\"\",\"\",B3)","v":44251}]
[8,{"$f":"IF(B3=\"\",\"\",B3-A4)","v":"2021-02-16"},44243]
["に終わらせるので、学習できる日は",{"$f":"IF(B4=\"\",\"\",B4-B2+1)","v":24},"日"]
["1日の学習時間（単位:分）",120,"分"]
["1日の学習コマ数（=科目数）",2]
["1コマの学習時間（単位:分）",{"$f":"IF(B6=\"\",\"\",B6/B7)","v":60},"分"]
["学習トータルコマ数",{"$f":"IF(B5=\"\",\"\",B5*B7)","v":48}]
["トータル学習時間（単位:時）",{"$f":"IF(B5=\"\",\"\",B6*B5/60)","v":48},"時間"]
[null,null,null,null,null,null,null,"重複等のチェック後",null,null,null,null,null,null,"重複等のチェック前"]
["科目別学習教材とトータルページ数",null,null,null,null,null,null,"国語","数学","英語","理科","社会","5教科計",null,"国語","数学","英語","理科","社会","5教科計"]
["国語","数学","英語","理科","社会","5教科計","教材数",{"$f":"COUNTA(A15:A19)","v":2},{"$f":"COUNTA(B15:B19)","v":2},1,2,2,{"$f":"SUM(H13:L13)","v":9},"教材数",{"$f":"COUNTA(A15:A19)","v":2},{"$f":"COUNTA(B15:B19)","v":2},1,2,2,{"$f":"SUM(O13:S13)","v":9}]
[{"$f":"H14","v":38},{"$f":"I14","v":33},32,34,24,{"$f":"SUM(A14:E14)","v":161},null,{"$f":"SUM(H15:H19)","v":38},{"$f":"SUM(I15:I19)","v":33},32,34,24,null,null,{"$f":"SUM(O15:O19)","v":38},{"$f":"SUM(P15:P19)","v":33},32,34,24]
["A:ワーク","数量:リピート","AとB:完全学習","A:自主学習","地理:ワーク",null,null,21,12,32,22,18,null,null,{"$f":"SUMIFS($E$33:$E$67,$A$33:$A$67,O$12,$B$33:$B$67,A15)","v":21},{"$f":"SUMIFS($E$33:$E$67,$A$33:$A$67,P$12,$B$33:$B$67,B15)","v":12},32,22,18]
["B:ワーク","図形:リピート",null,"B:自主学習","歴史:ワーク",null,null,17,21,null,12,6,null,null,{"$f":"SUMIFS($E$33:$E$67,$A$33:$A$67,O$12,$B$33:$B$67,A16)","v":17},21,0,12,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[]
[{"$f":"\"各科目の1コマ（＝\"&B8&\"分）の学習目標ページ数→終了迄の必要コマ数\"","v":"各科目の1コマ（＝60分）の学習目標ページ数→終了迄の必要コマ数"},null,null,null,null,null,null,"コマ数・ページ調整基準→",null,null,"余りが目標ページの",0.5,"未満","コマ数の",0.4,"未満"]
["科目","1日の学習目標ページ数","終了迄のコマ数","学習時間（単位:時）","学習時間割合",null,null,"整数商","余り","コマ数増","1ページ増コマ","調整後コマ数","Rank","科目","調整後コマ数","設定コマ数","過不足"]
["国語",4,{"$f":"IFERROR(L23,\"\")","v":10},{"$f":"IFERROR($B$8*C23/60,\"\")","v":10},{"$f":"IFERROR(D23/$D$28,\"\")","v":0.21276595744680851},null,null,{"$f":"QUOTIENT(A14,B23)","v":9},{"$f":"MOD(A14,B23)","v":2},{"$f":"IF(I23=0,0,IF(AND(B23*$L$21>I23,H23*$O$21>I23),0,1))","v":1},{"$f":"IF(I23=0,0,IF(J23=0,I23,0))","v":0},{"$f":"SUM(H23,J23)","v":10},{"$f":"RANK(L23,L$23:L$27)+COUNTIF(L23:L$27,L23)-1","v":3},"国語",{"$f":"L23","v":10},{"$f":"COUNTIF(DB_dayplan!C:C,N23)","v":0},{"$f":"P23-O23","v":-10}]
["数学",3,{"$f":"IFERROR(L24,\"\")","v":11},11,0.23404255319148937,null,null,{"$f":"QUOTIENT(B14,B24)","v":11},{"$f":"MOD(B14,B24)","v":0},0,{"$f":"IF(I24=0,0,IF(J24=0,I24,0))","v":0},{"$f":"SUM(H24,J24)","v":11},{"$f":"RANK(L24,L$23:L$27)+COUNTIF(L24:L$27,L24)-1","v":2},"数学",{"$f":"L24","v":11},{"$f":"COUNTIF(DB_dayplan!C:C,N24)","v":0},{"$f":"P24-O24","v":-11}]
["英語",3,{"$f":"IFERROR(L25,\"\")","v":11},11,0.23404255319148937,null,null,{"$f":"QUOTIENT(C14,B25)","v":10},{"$f":"MOD(C14,B25)","v":2},1,0,11,{"$f":"RANK(L25,L$23:L$27)+COUNTIF(L25:L$27,L25)-1","v":1},"英語",11,{"$f":"COUNTIF(DB_dayplan!C:C,N25)","v":0},-11]
["理科",4,{"$f":"IFERROR(L26,\"\")","v":9},9,0.19148936170212766,null,null,{"$f":"QUOTIENT(D14,B26)","v":8},{"$f":"MOD(D14,B26)","v":2},1,0,9,{"$f":"RANK(L26,L$23:L$27)+COUNTIF(L26:L$27,L26)-1","v":4},"理科",9,{"$f":"COUNTIF(DB_dayplan!C:C,N26)","v":0},-9]
["社会",4,{"$f":"IFERROR(L27,\"\")","v":6},6,0.1276595744680851,null,null,{"$f":"QUOTIENT(E14,B27)","v":6},{"$f":"MOD(E14,B27)","v":0},0,0,6,{"$f":"RANK(L27,L$23:L$27)+COUNTIF(L27:L$27,L27)-1","v":5},"社会",6,{"$f":"COUNTIF(DB_dayplan!C:C,N27)","v":0},-6]
["5教科計",null,{"$f":"IFERROR(SUM(C23:C27),\"\")","v":47},47,1]
["このペースで学習すると・・・",{"$f":"IF(OR(A14=0,B14=0,C14=0,D14=0,E14=0),\"\",IFERROR(IF(I29>=0,\"Good!\",\"残念!\"),\"\"))","v":"Good!"},{"$f":"IF(OR(A14=0,B14=0,C14=0,D14=0,E14=0),\"\",IFERROR(IF(I29>0,\"計画の\"&I29&\"日前\",IF(I29=0,\"ぴったり計画日\",\"計画を\"&-I29&\"日オーバー!\")),\"\"))","v":"ぴったり計画日"},{"$f":"IF(OR(A14=0,B14=0,C14=0,D14=0,E14=0),\"\",IFERROR(IF(B5-C28/2>=0,\"に終了できます。\",\"計画の日までに終わりません\"),\"\"))","v":"に終了できます。"},null,null,"学習必要日数",{"$f":"IF(ROUNDUP(C28/B7,0)<MAX(L23:L27),MAX(L23:L27),ROUNDUP(C28/B7,0))","v":24},{"$f":"B5-H29","v":0}]
[]
["科目別学習ページ",null,null,null,null,null,null,"日曜始まりは1、月曜始まりは2"]
["科目","学習教材","開始ページ","終了ページ","学習ページ数",null,null,1,null,"科目","学習教材",null,"科目","学習教材",null,"教材重複判定",null,"判定1",null,"判定2"]
["国語","A:ワーク",105,119,{"$f":"IF(OR(A33=\"\",B33=\"\",C33=\"\",D33=\"\"),\"\",D33-C33+1)","v":15}]
["国語","B:ワーク",120,123,{"$f":"IF(OR(A34=\"\",B34=\"\",C34=\"\",D34=\"\"),\"\",D34-C34+1)","v":4}]
["国語","A:ワーク",128,128,1]
["国語","A:ワーク",130,131,2]
["国語","A:ワーク",135,137,3]
["国語","B:ワーク",76,77,2]
["国語","B:ワーク",81,81,1]
["国語","B:ワーク",94,96,3]
["国語","B:ワーク",108,113,6]
["国語","B:ワーク",129,129,1]
["英語","AとB:完全学習",110,141,32]
["理科","A:自主学習",44,65,22]
["理科","B:自主学習",78,81,4]
["社会","地理:ワーク",52,55,4]
["社会","歴史:ワーク",36,41,6]
["数学","数量:リピート",152,154,3]
["数学","数量:リピート",158,158,1]
["数学","数量:リピート",209,216,8]
["数学","図形:リピート",180,200,21]
["理科","B:自主学習",86,87,2]
["理科","B:自主学習",90,95,6]
["社会","地理:ワーク",57,70,14]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]

{"sheet":"DB_pages","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"DB_dayplan","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"calendar_format","index":3,"n_rows":4,"n_cols":21,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,9,0,11],[0,17,0,20]]}
[{"$f":"plan_sheet!B1&\" 学習カレンダー\"","v":"1年生 第4回定期考査 学習カレンダー"},null,null,null,null,null,null,null,"試験日（初日）:",{"$f":"plan_sheet!B3","v":"2021-02-24"},null,null,null,null,null,null,null,{"$f":"TEXT(NOW(),\"yyyy年mm月dd日 h:mm\")&\" 作成\"&\" powered by Percredere\"","v":"2021年09月12日 11:41 作成 powered by Percredere"}]
[null,null,null,{"$f":"A2+1","v":"1900-01-01"},null,null,{"$f":"D2+1","v":"1900-01-02"},null,null,{"$f":"G2+1","v":"1900-01-03"},null,null,{"$f":"J2+1","v":"1900-01-04"},null,null,{"$f":"M2+1","v":"1900-01-05"},null,null,{"$f":"P2+1","v":"1900-01-06"}]
[{"$f":"A2","v":"00:00:00"},null,null,{"$f":"D2","v":"1900-01-01"},null,null,{"$f":"G2","v":"1900-01-02"},null,null,{"$f":"J2","v":"1900-01-03"},null,null,{"$f":"M2","v":"1900-01-04"},null,null,{"$f":"P2","v":"1900-01-05"},null,null,{"$f":"S2","v":"1900-01-06"}]
["科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ"]