{"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":[]}
["試験名"]
["学習開始日",null,{"$f":"IF(B2=\"\",\"\",B2)","v":""}]
["試験日",null,{"$f":"IF(B3=\"\",\"\",B3)","v":""}]
[8,{"$f":"IF(B3=\"\",\"\",B3-A4)","v":""},""]
["に終わらせるので、学習できる日は",{"$f":"IF(B4=\"\",\"\",B4-B2+1)","v":""},"日"]
["1日の学習時間（単位:分）",120,"分"]
["1日の学習コマ数（=科目数）",2]
["1コマの学習時間（単位:分）",{"$f":"IF(B6=\"\",\"\",B6/B7)","v":60},"分"]
["学習トータルコマ数",{"$f":"IF(B5=\"\",\"\",B5*B7)","v":""}]
["トータル学習時間（単位:時）",{"$f":"IF(B5=\"\",\"\",B6*B5/60)","v":""},"時間"]
[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":0},{"$f":"COUNTA(B15:B19)","v":0},0,0,0,{"$f":"SUM(H13:L13)","v":0},"教材数",{"$f":"COUNTA(A15:A19)","v":0},{"$f":"COUNTA(B15:B19)","v":0},0,0,0,{"$f":"SUM(O13:S13)","v":0}]
[{"$f":"H14","v":0},{"$f":"I14","v":0},0,0,0,{"$f":"SUM(A14:E14)","v":0},null,{"$f":"SUM(H15:H19)","v":0},{"$f":"SUM(I15:I19)","v":0},0,0,0,null,null,{"$f":"SUM(O15:O19)","v":0},{"$f":"SUM(P15:P19)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS($E$33:$E$67,$A$33:$A$67,O$12,$B$33:$B$67,A15)","v":0},{"$f":"SUMIFS($E$33:$E$67,$A$33:$A$67,P$12,$B$33:$B$67,B15)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS($E$33:$E$67,$A$33:$A$67,O$12,$B$33:$B$67,A16)","v":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]
[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","科目","調整後コマ数","設定コマ数","過不足"]
["国語",null,{"$f":"IFERROR(L23,\"\")","v":""},{"$f":"IFERROR($B$8*C23/60,\"\")","v":""},{"$f":"IFERROR(D23/$D$28,\"\")","v":""},null,null,{"$f":"QUOTIENT(A14,B23)","v":{"$error":"#DIV/0!"}},{"$f":"MOD(A14,B23)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I23=0,0,IF(AND(B23*$L$21>I23,H23*$O$21>I23),0,1))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I23=0,0,IF(J23=0,I23,0))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H23,J23)","v":{"$error":"#DIV/0!"}},{"$f":"RANK(L23,L$23:L$27)+COUNTIF(L23:L$27,L23)-1","v":{"$error":"#DIV/0!"}},"国語",{"$f":"L23","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(DB_dayplan!C:C,N23)","v":0},{"$f":"P23-O23","v":{"$error":"#DIV/0!"}}]
["数学",null,{"$f":"IFERROR(L24,\"\")","v":""},"","",null,null,{"$f":"QUOTIENT(B14,B24)","v":{"$error":"#DIV/0!"}},{"$f":"MOD(B14,B24)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I24=0,0,IF(J24=0,I24,0))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H24,J24)","v":{"$error":"#DIV/0!"}},{"$f":"RANK(L24,L$23:L$27)+COUNTIF(L24:L$27,L24)-1","v":{"$error":"#DIV/0!"}},"数学",{"$f":"L24","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF(DB_dayplan!C:C,N24)","v":0},{"$f":"P24-O24","v":{"$error":"#DIV/0!"}}]
["英語",null,{"$f":"IFERROR(L25,\"\")","v":""},"","",null,null,{"$f":"QUOTIENT(C14,B25)","v":{"$error":"#DIV/0!"}},{"$f":"MOD(C14,B25)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"RANK(L25,L$23:L$27)+COUNTIF(L25:L$27,L25)-1","v":{"$error":"#DIV/0!"}},"英語",{"$error":"#DIV/0!"},{"$f":"COUNTIF(DB_dayplan!C:C,N25)","v":0},{"$error":"#DIV/0!"}]
["理科",null,{"$f":"IFERROR(L26,\"\")","v":""},"","",null,null,{"$f":"QUOTIENT(D14,B26)","v":{"$error":"#DIV/0!"}},{"$f":"MOD(D14,B26)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"RANK(L26,L$23:L$27)+COUNTIF(L26:L$27,L26)-1","v":{"$error":"#DIV/0!"}},"理科",{"$error":"#DIV/0!"},{"$f":"COUNTIF(DB_dayplan!C:C,N26)","v":0},{"$error":"#DIV/0!"}]
["社会",null,{"$f":"IFERROR(L27,\"\")","v":""},"","",null,null,{"$f":"QUOTIENT(E14,B27)","v":{"$error":"#DIV/0!"}},{"$f":"MOD(E14,B27)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"RANK(L27,L$23:L$27)+COUNTIF(L27:L$27,L27)-1","v":{"$error":"#DIV/0!"}},"社会",{"$error":"#DIV/0!"},{"$f":"COUNTIF(DB_dayplan!C:C,N27)","v":0},{"$error":"#DIV/0!"}]
["5教科計",null,{"$f":"IFERROR(SUM(C23:C27),\"\")","v":0},0,""]
["このペースで学習すると・・・",{"$f":"IF(OR(A14=0,B14=0,C14=0,D14=0,E14=0),\"\",IFERROR(IF(I29>=0,\"Good!\",\"残念!\"),\"\"))","v":""},{"$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":{"$error":"#DIV/0!"}},{"$f":"B5-H29","v":{"$error":"#VALUE!"}}]
[]
["科目別学習ページ",null,null,null,null,null,null,"日曜始まりは1、月曜始まりは2"]
["科目","学習教材","開始ページ","終了ページ","学習ページ数",null,null,1,null,"科目","学習教材",null,"科目","学習教材",null,"教材重複判定",null,"判定1",null,"判定2"]
[null,null,null,null,{"$f":"IF(OR(A33=\"\",B33=\"\",C33=\"\",D33=\"\"),\"\",D33-C33+1)","v":""}]
[null,null,null,null,{"$f":"IF(OR(A34=\"\",B34=\"\",C34=\"\",D34=\"\"),\"\",D34-C34+1)","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,""]

{"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":" 学習カレンダー"},null,null,null,null,null,null,null,"試験日（初日）:",{"$f":"plan_sheet!B3","v":"00:00:00"},null,null,null,null,null,null,null,{"$f":"TEXT(NOW(),\"yyyy年mm月dd日 h:mm\")&\" 作成\"&\" powered by Percredere\"","v":"2021年09月12日 11:37 作成 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"}]
["科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ","科目","教材","学習ページ"]