{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["このテンプレートの使い方","学生リスト","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","1 月","2 月","3 月","学生の出席記録"],"not_rendered":{"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"このテンプレートの使い方","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[3,2,3,12],[4,4,4,12],[5,4,5,12],[6,4,6,12],[7,4,7,12],[8,4,8,7],[11,2,11,12],[12,4,12,12],[13,4,13,12],[14,4,14,12],[17,2,17,12],[18,4,18,12],[19,4,19,12],[20,4,20,12],[21,4,21,12],[24,2,24,12]]}
["このテンプレートの使い方"]
[]
[null,"最初の手順"]
[null,null,"学生の出席管理を始める前に、いくつかの手順が必要です。"]
[{"$nulls":3},"1.","学生の追加:  [学生リスト] シートで、保護者名や連絡先データなど、各学生の情報を入力します。学生 ID は、各学生の一意の識別子となり、ブック全体でデータを入力しやすくするための [学生 ID] ドロップダウン リストで使われるため、重要な入力項目です。[学生リスト] に入力する情報は、[学生の出席記録] や月間出席記録など、他のシートでも使われます。"]
[{"$nulls":3},"2.","学校年度の変更: 出席状況を表す [4 月] シートで、ヘッダーの右上端の上下ボタンをクリックして学校年度を更新します。この変更により、このブック全体のすべての月間出席記録のヘッダーが更新されます(上下ボタンは印刷されません)。"]
[{"$nulls":3},"3.","(オプション) ブック全体の色の変更: まず、最後のシートである [学生の出席記録] に移動し、[校閲] タブの [変更] グループで、[シート保護の解除] をクリックします。次に、[ページ レイアウト] タブの [テーマ] グループで、[配色] をクリックし、配色ギャラリーから設定された別の配色パターンを選びます。色の変更やテーマの他の変更を加えたら、[学生の出席記録] シートに戻り、[校閲] タブの [変更] グループで [シートの保護] をクリックし、[OK] をクリックします。"]
[{"$nulls":4},"ヒント: 学校のカラーに合わせてテーマのカスタム色を作ってみください。これを行うには、[ページ レイアウト] タブの [テーマ] グループで、[配色] をクリックし、配色ギャラリーの一番下付近にある [新しい配色パターンの作成] をクリックします。カスタム色セットを作成する方法の詳細については、次のヘルプ トピックをご覧ください。"]
[{"$nulls":4},"ドキュメントのテーマをカスタマイズする"]
[]
[null,"学生を追加したら、次に何をすればよいですか。"]
[null,null,"[学生リスト] シートに学生を入力したら、以下の手順に従って学校年度の出席状況の管理を始めることができます。"]
[{"$nulls":3},"1.","学生を出席記録に追加するには、[学生 ID] 列の下のセルをクリックし、リストから ID を選びます。ID を選ぶと、学生の名前が自動的に表示されます。"]
[{"$nulls":4},"ヒント: 入力するたびにデータを保存してください。その月に学生を追加したら、入力した学生 ID を選んでコピーし、他の月の [学生 ID] 列に貼り付けます。"]
[{"$nulls":3},"2.","次に、色分けに用意された出席タイプを使って各日付の出席記録を入力します。学生の出席状況は、各学生の出席タイプにより、[合計] 列で自動的に計算されます。表の一番下の [合計] 行で、各日付の欠席合計が自動的に計算されます。"]
[]
[null,"どうすれば月間出席記録に他の学生を追加できますか。"]
[null,null,"月間出席記録シートと学生リストは、Excel テーブルです。Excel テーブルに新しい行を追加するには、次のいずれかを行います。"]
[{"$nulls":3},"● ","テーブルに [合計] 行がない場合、テーブルの下で入力し始めると、Enter キーまたは Tab キーを押したときに自動的に拡張されます。"]
[{"$nulls":3},"● ","[合計] 行の上の最後のセル (最後の学生の [欠席日数] セルなど) にセル ポインターを置き、Tab キーを押します。"]
[{"$nulls":3},"● ","テーブルを右クリックし、ポップアップ メニューで [挿入] をポイントし、[上に行を挿入] または [下に行を挿入] をクリックします。"]
[{"$nulls":3},"● ","テーブルの右下隅で、テーブル サイズ変更ハンドルにマウスを置き、下にドラッグして使用可能なテーブル行の数を増やします。"]
[]
[null,"学校年度全体の学生の出席状況を表示できますか。"]
[null,null,"このブックの最後のシートである [学生の出席記録] では、年度の始めからその日までの出席状況を管理できます。特定の学生の記録を表示するには、[学生 ID] の下のセル内をクリックし、ドロップダウン リストから ID を選びます。[学生リスト] シートに入力しておいた、選んだ学生の情報が自動的に表示されます。初めて [学生の出席記録] を使うときは、[学校名]、[学年]、[先生]、[教室] を入力してください。これらの情報は、別の学生を選んでも変わりません。"]

{"sheet":"学生リスト","index":1,"n_rows":8,"n_cols":19,"rows_kept":8}
["学生リスト"]
[]
[null,"学生 ID","学生の姓","学生の名","性別","誕生日","保護者 1","保護者 1 の続柄","保護者 1 の勤務先電話番号","保護者 1 の自宅電話番号","保護者 2","保護者 2 の続柄","保護者 2 の勤務先電話番号","保護者 2 の自宅電話番号","緊急連絡先","緊急連絡先との続柄","緊急連絡先の勤務先電話番号","緊急連絡先の自宅電話番号","学生氏名"]
[null,"S001","川田","弘穀","男","1997-03-28","川田 一之","兄","(03)1111-1111","(03)1111-2222","川田 浩之","父","(03)1111-1111","(03)1111-2222","川井 伸好","祖父","(03)1111-3333","(03)1111-4444",{"$f":"StudentList[[#This Row],[学生の姓]]&\" \" &StudentList[[#This Row],[学生の名]]","v":"川田 弘穀"}]
[null,"S002",2,"学生",{"$nulls":14},{"$f":"StudentList[[#This Row],[学生の姓]]&\" \" &StudentList[[#This Row],[学生の名]]","v":"2 学生"}]
[null,"S003",3,"学生",{"$nulls":14},{"$f":"StudentList[[#This Row],[学生の姓]]&\" \" &StudentList[[#This Row],[学生の名]]","v":"3 学生"}]
[null,"S004",4,"学生",{"$nulls":14},{"$f":"StudentList[[#This Row],[学生の姓]]&\" \" &StudentList[[#This Row],[学生の名]]","v":"4 学生"}]
[null,"S005",5,"学生",{"$nulls":14},{"$f":"StudentList[[#This Row],[学生の姓]]&\" \" &StudentList[[#This Row],[学生の名]]","v":"5 学生"}]

{"sheet":"4 月","index":2,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",2012]
[]
[null,null,"色分け","T","遅刻",null,null,"E","届出欠席",null,null,"U","無断欠席",null,null,"P","出席",null,null,"N","休校日"]
[]
[null,{"$f":"DATE(CalendarYear,4,1)","v":"2012-04-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,1),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,2),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,3),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,4),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,5),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,6),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,7),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,8),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,9),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,10),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,11),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,12),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,13),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,14),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,15),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,16),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,17),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,18),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,19),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,20),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,21),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,22),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,23),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,24),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,25),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,26),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,27),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,28),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,29),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,30),1),\"aaa\")","v":"月"},null,"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","T","E","U","P","欠席日数"]
[null,"S001",{"$f":"IFERROR(VLOOKUP(AugustAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":"川田 弘穀"},"P","P","T","T","P","N","N","P","P","E","P","P","N","N","P","P","P","P","P","N","N","P","P","P","P","P","N","N","P","P",null,{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code1)","v":2},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code2)","v":1},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code4)","v":19},{"$f":"SUM(AugustAttendance[[#This Row],[E]:[U]])","v":1}]
[null,"S002",{"$f":"IFERROR(VLOOKUP(AugustAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":"2 学生"},"P","U","P","P","P","N","N","P","E","E","E","E","N","N","P","P","P","P","P","N","N","P","P","P","T","T","N","N","P","P",null,{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code1)","v":2},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code2)","v":4},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code3)","v":1},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code4)","v":15},{"$f":"SUM(AugustAttendance[[#This Row],[E]:[U]])","v":5}]
[null,"S003",{"$f":"IFERROR(VLOOKUP(AugustAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":"3 学生"},"P","E","P","P","P","N","N","P","P","U","P","P","N","N","P","P","P","P","P","N","N","P","P","E","E","P","N","N","P","P",null,{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code2)","v":3},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code3)","v":1},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code4)","v":18},{"$f":"SUM(AugustAttendance[[#This Row],[E]:[U]])","v":4}]
[null,"S004",{"$f":"IFERROR(VLOOKUP(AugustAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":"4 学生"},"P","P","P","P","P","N","N","P","P","P","P","P","N","N","P","P","P","P","P","N","N","P","U","P","P","E","N","N","P","E",null,{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code2)","v":2},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code3)","v":1},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code4)","v":19},{"$f":"SUM(AugustAttendance[[#This Row],[E]:[U]])","v":3}]
[null,"S005",{"$f":"IFERROR(VLOOKUP(AugustAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":"5 学生"},"P","P","P","P","P","N","N","P","P","P","P","P","N","N","P","P","P","P","P","N","N","P","P","P","P","P","N","N","P","P",null,{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AugustAttendance[[#This Row],[1]:[ ]],Code4)","v":22},{"$f":"SUM(AugustAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(AugustAttendance[1],\"U\")+COUNTIF(AugustAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[2],\"U\")+COUNTIF(AugustAttendance[2],\"E\")","v":2},{"$f":"COUNTIF(AugustAttendance[3],\"U\")+COUNTIF(AugustAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[4],\"U\")+COUNTIF(AugustAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[5],\"U\")+COUNTIF(AugustAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[6],\"U\")+COUNTIF(AugustAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[7],\"U\")+COUNTIF(AugustAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[8],\"U\")+COUNTIF(AugustAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[9],\"U\")+COUNTIF(AugustAttendance[9],\"E\")","v":1},{"$f":"COUNTIF(AugustAttendance[10],\"U\")+COUNTIF(AugustAttendance[10],\"E\")","v":3},{"$f":"COUNTIF(AugustAttendance[11],\"U\")+COUNTIF(AugustAttendance[11],\"E\")","v":1},{"$f":"COUNTIF(AugustAttendance[12],\"U\")+COUNTIF(AugustAttendance[12],\"E\")","v":1},{"$f":"COUNTIF(AugustAttendance[13],\"U\")+COUNTIF(AugustAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[14],\"U\")+COUNTIF(AugustAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[15],\"U\")+COUNTIF(AugustAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[16],\"U\")+COUNTIF(AugustAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[17],\"U\")+COUNTIF(AugustAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[18],\"U\")+COUNTIF(AugustAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[19],\"U\")+COUNTIF(AugustAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[20],\"U\")+COUNTIF(AugustAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[21],\"U\")+COUNTIF(AugustAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[22],\"U\")+COUNTIF(AugustAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[23],\"U\")+COUNTIF(AugustAttendance[23],\"E\")","v":1},{"$f":"COUNTIF(AugustAttendance[24],\"U\")+COUNTIF(AugustAttendance[24],\"E\")","v":1},{"$f":"COUNTIF(AugustAttendance[25],\"U\")+COUNTIF(AugustAttendance[25],\"E\")","v":1},{"$f":"COUNTIF(AugustAttendance[26],\"U\")+COUNTIF(AugustAttendance[26],\"E\")","v":1},{"$f":"COUNTIF(AugustAttendance[27],\"U\")+COUNTIF(AugustAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[28],\"U\")+COUNTIF(AugustAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[29],\"U\")+COUNTIF(AugustAttendance[29],\"E\")","v":0},{"$f":"COUNTIF(AugustAttendance[30],\"U\")+COUNTIF(AugustAttendance[30],\"E\")","v":1},{"$f":"COUNTIF(AugustAttendance[[ ]],\"U\")+COUNTIF(AugustAttendance[[ ]],\"E\")","v":0},{"$f":"SUBTOTAL(109,AugustAttendance[T])","v":4},{"$f":"SUBTOTAL(109,AugustAttendance[E])","v":10},{"$f":"SUBTOTAL(109,AugustAttendance[U])","v":3},{"$f":"SUBTOTAL(109,AugustAttendance[P])","v":93},{"$f":"SUBTOTAL(109,AugustAttendance[欠席日数])","v":13}]

{"sheet":"5 月","index":3,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,5,1)","v":"2012-05-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,1),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,2),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,3),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,4),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,5),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,6),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,7),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,8),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,9),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,10),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,11),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,12),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,13),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,14),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,15),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,16),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,17),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,18),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,19),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,20),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,21),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,22),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,23),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,24),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,25),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,26),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,27),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,28),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,29),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,30),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,31),1),\"aaa\")","v":"木"},"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(SeptemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(SeptemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(SeptemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(SeptemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(SeptemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(SeptemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(SeptemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(SeptemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(SeptemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(SeptemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(SeptemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(SeptemberAttendance[1],\"U\")+COUNTIF(SeptemberAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[2],\"U\")+COUNTIF(SeptemberAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[3],\"U\")+COUNTIF(SeptemberAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[4],\"U\")+COUNTIF(SeptemberAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[5],\"U\")+COUNTIF(SeptemberAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[6],\"U\")+COUNTIF(SeptemberAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[7],\"U\")+COUNTIF(SeptemberAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[8],\"U\")+COUNTIF(SeptemberAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[9],\"U\")+COUNTIF(SeptemberAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[10],\"U\")+COUNTIF(SeptemberAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[11],\"U\")+COUNTIF(SeptemberAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[12],\"U\")+COUNTIF(SeptemberAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[13],\"U\")+COUNTIF(SeptemberAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[14],\"U\")+COUNTIF(SeptemberAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[15],\"U\")+COUNTIF(SeptemberAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[16],\"U\")+COUNTIF(SeptemberAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[17],\"U\")+COUNTIF(SeptemberAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[18],\"U\")+COUNTIF(SeptemberAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[19],\"U\")+COUNTIF(SeptemberAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[20],\"U\")+COUNTIF(SeptemberAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[21],\"U\")+COUNTIF(SeptemberAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[22],\"U\")+COUNTIF(SeptemberAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[23],\"U\")+COUNTIF(SeptemberAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[24],\"U\")+COUNTIF(SeptemberAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[25],\"U\")+COUNTIF(SeptemberAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[26],\"U\")+COUNTIF(SeptemberAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[27],\"U\")+COUNTIF(SeptemberAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[28],\"U\")+COUNTIF(SeptemberAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[29],\"U\")+COUNTIF(SeptemberAttendance[29],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[30],\"U\")+COUNTIF(SeptemberAttendance[30],\"E\")","v":0},{"$f":"COUNTIF(SeptemberAttendance[31],\"U\")+COUNTIF(SeptemberAttendance[31],\"E\")","v":0},{"$f":"SUBTOTAL(109,SeptemberAttendance[T])","v":0},{"$f":"SUBTOTAL(109,SeptemberAttendance[E])","v":0},{"$f":"SUBTOTAL(109,SeptemberAttendance[U])","v":0},{"$f":"SUBTOTAL(109,SeptemberAttendance[P])","v":0},{"$f":"SUBTOTAL(109,SeptemberAttendance[欠席日数])","v":0}]

{"sheet":"6 月","index":4,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,6,1)","v":"2012-06-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,1),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,2),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,3),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,4),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,5),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,6),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,7),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,8),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,9),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,10),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,11),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,12),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,13),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,14),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,15),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,16),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,17),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,18),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,19),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,20),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,21),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,22),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,23),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,24),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,25),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,26),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,27),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,28),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,29),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,30),1),\"aaa\")","v":"土"},null,"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(OctoberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(OctoberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(OctoberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(OctoberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(OctoberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(OctoberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(OctoberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(OctoberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(OctoberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(OctoberAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(OctoberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(OctoberAttendance[1],\"U\")+COUNTIF(OctoberAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[2],\"U\")+COUNTIF(OctoberAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[3],\"U\")+COUNTIF(OctoberAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[4],\"U\")+COUNTIF(OctoberAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[5],\"U\")+COUNTIF(OctoberAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[6],\"U\")+COUNTIF(OctoberAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[7],\"U\")+COUNTIF(OctoberAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[8],\"U\")+COUNTIF(OctoberAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[9],\"U\")+COUNTIF(OctoberAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[10],\"U\")+COUNTIF(OctoberAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[11],\"U\")+COUNTIF(OctoberAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[12],\"U\")+COUNTIF(OctoberAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[13],\"U\")+COUNTIF(OctoberAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[14],\"U\")+COUNTIF(OctoberAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[15],\"U\")+COUNTIF(OctoberAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[16],\"U\")+COUNTIF(OctoberAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[17],\"U\")+COUNTIF(OctoberAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[18],\"U\")+COUNTIF(OctoberAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[19],\"U\")+COUNTIF(OctoberAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[20],\"U\")+COUNTIF(OctoberAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[21],\"U\")+COUNTIF(OctoberAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[22],\"U\")+COUNTIF(OctoberAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[23],\"U\")+COUNTIF(OctoberAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[24],\"U\")+COUNTIF(OctoberAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[25],\"U\")+COUNTIF(OctoberAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[26],\"U\")+COUNTIF(OctoberAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[27],\"U\")+COUNTIF(OctoberAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[28],\"U\")+COUNTIF(OctoberAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[29],\"U\")+COUNTIF(OctoberAttendance[29],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[30],\"U\")+COUNTIF(OctoberAttendance[30],\"E\")","v":0},{"$f":"COUNTIF(OctoberAttendance[[ ]],\"U\")+COUNTIF(OctoberAttendance[[ ]],\"E\")","v":0},{"$f":"SUBTOTAL(109,OctoberAttendance[T])","v":0},{"$f":"SUBTOTAL(109,OctoberAttendance[E])","v":0},{"$f":"SUBTOTAL(109,OctoberAttendance[U])","v":0},{"$f":"SUBTOTAL(109,OctoberAttendance[P])","v":0},{"$f":"SUBTOTAL(109,OctoberAttendance[欠席日数])","v":0}]

{"sheet":"7 月","index":5,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,7,1)","v":"2012-07-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,1),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,2),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,3),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,4),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,5),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,6),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,7),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,8),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,9),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,10),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,11),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,12),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,13),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,14),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,15),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,16),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,17),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,18),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,19),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,20),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,21),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,22),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,23),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,24),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,25),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,26),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,27),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,28),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,29),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,30),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,31),1),\"aaa\")","v":"火"},"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(NovemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(NovemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(NovemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(NovemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(NovemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(NovemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(NovemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(NovemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(NovemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(NovemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(NovemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(NovemberAttendance[1],\"U\")+COUNTIF(NovemberAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[2],\"U\")+COUNTIF(NovemberAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[3],\"U\")+COUNTIF(NovemberAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[4],\"U\")+COUNTIF(NovemberAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[5],\"U\")+COUNTIF(NovemberAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[6],\"U\")+COUNTIF(NovemberAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[7],\"U\")+COUNTIF(NovemberAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[8],\"U\")+COUNTIF(NovemberAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[9],\"U\")+COUNTIF(NovemberAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[10],\"U\")+COUNTIF(NovemberAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[11],\"U\")+COUNTIF(NovemberAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[12],\"U\")+COUNTIF(NovemberAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[13],\"U\")+COUNTIF(NovemberAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[14],\"U\")+COUNTIF(NovemberAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[15],\"U\")+COUNTIF(NovemberAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[16],\"U\")+COUNTIF(NovemberAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[17],\"U\")+COUNTIF(NovemberAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[18],\"U\")+COUNTIF(NovemberAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[19],\"U\")+COUNTIF(NovemberAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[20],\"U\")+COUNTIF(NovemberAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[21],\"U\")+COUNTIF(NovemberAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[22],\"U\")+COUNTIF(NovemberAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[23],\"U\")+COUNTIF(NovemberAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[24],\"U\")+COUNTIF(NovemberAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[25],\"U\")+COUNTIF(NovemberAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[26],\"U\")+COUNTIF(NovemberAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[27],\"U\")+COUNTIF(NovemberAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[28],\"U\")+COUNTIF(NovemberAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[29],\"U\")+COUNTIF(NovemberAttendance[29],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[30],\"U\")+COUNTIF(NovemberAttendance[30],\"E\")","v":0},{"$f":"COUNTIF(NovemberAttendance[31],\"U\")+COUNTIF(NovemberAttendance[31],\"E\")","v":0},{"$f":"SUBTOTAL(109,NovemberAttendance[T])","v":0},{"$f":"SUBTOTAL(109,NovemberAttendance[E])","v":0},{"$f":"SUBTOTAL(109,NovemberAttendance[U])","v":0},{"$f":"SUBTOTAL(109,NovemberAttendance[P])","v":0},{"$f":"SUBTOTAL(109,NovemberAttendance[欠席日数])","v":0}]

{"sheet":"8 月","index":6,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,8,1)","v":"2012-08-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,1),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,2),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,3),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,4),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,5),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,6),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,7),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,8),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,9),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,10),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,11),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,12),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,13),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,14),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,15),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,16),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,17),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,18),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,19),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,20),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,21),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,22),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,23),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,24),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,25),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,26),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,27),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,28),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,29),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,30),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,31),1),\"aaa\")","v":"金"},"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(DecemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(DecemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(DecemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(DecemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(DecemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(DecemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(DecemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(DecemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(DecemberAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(DecemberAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(DecemberAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(DecemberAttendance[1],\"U\")+COUNTIF(DecemberAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[2],\"U\")+COUNTIF(DecemberAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[3],\"U\")+COUNTIF(DecemberAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[4],\"U\")+COUNTIF(DecemberAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[5],\"U\")+COUNTIF(DecemberAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[6],\"U\")+COUNTIF(DecemberAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[7],\"U\")+COUNTIF(DecemberAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[8],\"U\")+COUNTIF(DecemberAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[9],\"U\")+COUNTIF(DecemberAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[10],\"U\")+COUNTIF(DecemberAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[11],\"U\")+COUNTIF(DecemberAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[12],\"U\")+COUNTIF(DecemberAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[13],\"U\")+COUNTIF(DecemberAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[14],\"U\")+COUNTIF(DecemberAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[15],\"U\")+COUNTIF(DecemberAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[16],\"U\")+COUNTIF(DecemberAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[17],\"U\")+COUNTIF(DecemberAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[18],\"U\")+COUNTIF(DecemberAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[19],\"U\")+COUNTIF(DecemberAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[20],\"U\")+COUNTIF(DecemberAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[21],\"U\")+COUNTIF(DecemberAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[22],\"U\")+COUNTIF(DecemberAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[23],\"U\")+COUNTIF(DecemberAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[24],\"U\")+COUNTIF(DecemberAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[25],\"U\")+COUNTIF(DecemberAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[26],\"U\")+COUNTIF(DecemberAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[27],\"U\")+COUNTIF(DecemberAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[28],\"U\")+COUNTIF(DecemberAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[29],\"U\")+COUNTIF(DecemberAttendance[29],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[30],\"U\")+COUNTIF(DecemberAttendance[30],\"E\")","v":0},{"$f":"COUNTIF(DecemberAttendance[31],\"U\")+COUNTIF(DecemberAttendance[31],\"E\")","v":0},{"$f":"SUBTOTAL(109,DecemberAttendance[T])","v":0},{"$f":"SUBTOTAL(109,DecemberAttendance[E])","v":0},{"$f":"SUBTOTAL(109,DecemberAttendance[U])","v":0},{"$f":"SUBTOTAL(109,DecemberAttendance[P])","v":0},{"$f":"SUBTOTAL(109,DecemberAttendance[欠席日数])","v":0}]

{"sheet":"9 月","index":7,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,9,1)","v":"2012-09-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,1),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,2),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,3),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,4),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,5),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,6),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,7),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,8),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,9),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,10),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,11),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,12),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,13),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,14),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,15),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,16),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,17),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,18),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,19),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,20),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,21),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,22),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,23),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,24),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,25),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,26),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,27),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,28),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,29),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,30),1),\"aaa\")","v":"日"},null,"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(JanuaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(JanuaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JanuaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(JanuaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JanuaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(JanuaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JanuaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(JanuaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JanuaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(JanuaryAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(JanuaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(JanuaryAttendance[1],\"U\")+COUNTIF(JanuaryAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[2],\"U\")+COUNTIF(JanuaryAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[3],\"U\")+COUNTIF(JanuaryAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[4],\"U\")+COUNTIF(JanuaryAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[5],\"U\")+COUNTIF(JanuaryAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[6],\"U\")+COUNTIF(JanuaryAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[7],\"U\")+COUNTIF(JanuaryAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[8],\"U\")+COUNTIF(JanuaryAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[9],\"U\")+COUNTIF(JanuaryAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[10],\"U\")+COUNTIF(JanuaryAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[11],\"U\")+COUNTIF(JanuaryAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[12],\"U\")+COUNTIF(JanuaryAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[13],\"U\")+COUNTIF(JanuaryAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[14],\"U\")+COUNTIF(JanuaryAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[15],\"U\")+COUNTIF(JanuaryAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[16],\"U\")+COUNTIF(JanuaryAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[17],\"U\")+COUNTIF(JanuaryAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[18],\"U\")+COUNTIF(JanuaryAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[19],\"U\")+COUNTIF(JanuaryAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[20],\"U\")+COUNTIF(JanuaryAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[21],\"U\")+COUNTIF(JanuaryAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[22],\"U\")+COUNTIF(JanuaryAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[23],\"U\")+COUNTIF(JanuaryAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[24],\"U\")+COUNTIF(JanuaryAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[25],\"U\")+COUNTIF(JanuaryAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[26],\"U\")+COUNTIF(JanuaryAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[27],\"U\")+COUNTIF(JanuaryAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[28],\"U\")+COUNTIF(JanuaryAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(JanuaryAttendance[29],\"U\")+COUNTIF(JanuaryAttendance[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,JanuaryAttendance[T])","v":0},{"$f":"SUBTOTAL(109,JanuaryAttendance[E])","v":0},{"$f":"SUBTOTAL(109,JanuaryAttendance[U])","v":0},{"$f":"SUBTOTAL(109,JanuaryAttendance[P])","v":0},{"$f":"SUBTOTAL(109,JanuaryAttendance[欠席日数])","v":0}]

{"sheet":"10 月","index":8,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,10,1)","v":"2012-10-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,1),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,2),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,3),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,4),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,5),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,6),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,7),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,8),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,9),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,10),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,11),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,12),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,13),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,14),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,15),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,16),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,17),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,18),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,19),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,20),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,21),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,22),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,23),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,24),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,25),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,26),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,27),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,28),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,29),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,30),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,31),1),\"aaa\")","v":"水"},"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(FebruaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(FebruaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(FebruaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(FebruaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(FebruaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(FebruaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(FebruaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(FebruaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(FebruaryAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(FebruaryAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(FebruaryAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(FebruaryAttendance[1],\"U\")+COUNTIF(FebruaryAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[2],\"U\")+COUNTIF(FebruaryAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[3],\"U\")+COUNTIF(FebruaryAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[4],\"U\")+COUNTIF(FebruaryAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[5],\"U\")+COUNTIF(FebruaryAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[6],\"U\")+COUNTIF(FebruaryAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[7],\"U\")+COUNTIF(FebruaryAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[8],\"U\")+COUNTIF(FebruaryAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[9],\"U\")+COUNTIF(FebruaryAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[10],\"U\")+COUNTIF(FebruaryAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[11],\"U\")+COUNTIF(FebruaryAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[12],\"U\")+COUNTIF(FebruaryAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[13],\"U\")+COUNTIF(FebruaryAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[14],\"U\")+COUNTIF(FebruaryAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[15],\"U\")+COUNTIF(FebruaryAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[16],\"U\")+COUNTIF(FebruaryAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[17],\"U\")+COUNTIF(FebruaryAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[18],\"U\")+COUNTIF(FebruaryAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[19],\"U\")+COUNTIF(FebruaryAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[20],\"U\")+COUNTIF(FebruaryAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[21],\"U\")+COUNTIF(FebruaryAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[22],\"U\")+COUNTIF(FebruaryAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[23],\"U\")+COUNTIF(FebruaryAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[24],\"U\")+COUNTIF(FebruaryAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[25],\"U\")+COUNTIF(FebruaryAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[26],\"U\")+COUNTIF(FebruaryAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[27],\"U\")+COUNTIF(FebruaryAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[28],\"U\")+COUNTIF(FebruaryAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(FebruaryAttendance[29],\"U\")+COUNTIF(FebruaryAttendance[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,FebruaryAttendance[T])","v":0},{"$f":"SUBTOTAL(109,FebruaryAttendance[E])","v":0},{"$f":"SUBTOTAL(109,FebruaryAttendance[U])","v":0},{"$f":"SUBTOTAL(109,FebruaryAttendance[P])","v":0},{"$f":"SUBTOTAL(109,FebruaryAttendance[欠席日数])","v":0}]

{"sheet":"11 月","index":9,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,11,1)","v":"2012-11-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,1),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,2),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,3),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,4),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,5),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,6),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,7),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,8),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,9),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,10),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,11),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,12),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,13),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,14),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,15),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,16),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,17),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,18),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,19),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,20),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,21),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,22),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,23),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,24),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,25),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,26),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,27),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,28),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,29),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,30),1),\"aaa\")","v":"金"},null,"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(MarchAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(MarchAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(MarchAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(MarchAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(MarchAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(MarchAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(MarchAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(MarchAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(MarchAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(MarchAttendance[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(MarchAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(MarchAttendance[1],\"U\")+COUNTIF(MarchAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[2],\"U\")+COUNTIF(MarchAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[3],\"U\")+COUNTIF(MarchAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[4],\"U\")+COUNTIF(MarchAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[5],\"U\")+COUNTIF(MarchAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[6],\"U\")+COUNTIF(MarchAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[7],\"U\")+COUNTIF(MarchAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[8],\"U\")+COUNTIF(MarchAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[9],\"U\")+COUNTIF(MarchAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[10],\"U\")+COUNTIF(MarchAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[11],\"U\")+COUNTIF(MarchAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[12],\"U\")+COUNTIF(MarchAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[13],\"U\")+COUNTIF(MarchAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[14],\"U\")+COUNTIF(MarchAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[15],\"U\")+COUNTIF(MarchAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[16],\"U\")+COUNTIF(MarchAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[17],\"U\")+COUNTIF(MarchAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[18],\"U\")+COUNTIF(MarchAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[19],\"U\")+COUNTIF(MarchAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[20],\"U\")+COUNTIF(MarchAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[21],\"U\")+COUNTIF(MarchAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[22],\"U\")+COUNTIF(MarchAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[23],\"U\")+COUNTIF(MarchAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[24],\"U\")+COUNTIF(MarchAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[25],\"U\")+COUNTIF(MarchAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[26],\"U\")+COUNTIF(MarchAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[27],\"U\")+COUNTIF(MarchAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[28],\"U\")+COUNTIF(MarchAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(MarchAttendance[29],\"U\")+COUNTIF(MarchAttendance[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,MarchAttendance[T])","v":0},{"$f":"SUBTOTAL(109,MarchAttendance[E])","v":0},{"$f":"SUBTOTAL(109,MarchAttendance[U])","v":0},{"$f":"SUBTOTAL(109,MarchAttendance[P])","v":0},{"$f":"SUBTOTAL(109,MarchAttendance[欠席日数])","v":0}]

{"sheet":"12 月","index":10,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,12,1)","v":"2012-12-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,1),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,2),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,3),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,4),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,5),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,6),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,7),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,8),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,9),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,10),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,11),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,12),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,13),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,14),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,15),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,16),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,17),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,18),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,19),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,20),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,21),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,22),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,23),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,24),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,25),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,26),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,27),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,28),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,29),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,30),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,31),1),\"aaa\")","v":"月"},"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(AprilAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AprilAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AprilAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AprilAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AprilAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AprilAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AprilAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AprilAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AprilAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AprilAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AprilAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(AprilAttendance[1],\"U\")+COUNTIF(AprilAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[2],\"U\")+COUNTIF(AprilAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[3],\"U\")+COUNTIF(AprilAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[4],\"U\")+COUNTIF(AprilAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[5],\"U\")+COUNTIF(AprilAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[6],\"U\")+COUNTIF(AprilAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[7],\"U\")+COUNTIF(AprilAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[8],\"U\")+COUNTIF(AprilAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[9],\"U\")+COUNTIF(AprilAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[10],\"U\")+COUNTIF(AprilAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[11],\"U\")+COUNTIF(AprilAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[12],\"U\")+COUNTIF(AprilAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[13],\"U\")+COUNTIF(AprilAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[14],\"U\")+COUNTIF(AprilAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[15],\"U\")+COUNTIF(AprilAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[16],\"U\")+COUNTIF(AprilAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[17],\"U\")+COUNTIF(AprilAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[18],\"U\")+COUNTIF(AprilAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[19],\"U\")+COUNTIF(AprilAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[20],\"U\")+COUNTIF(AprilAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[21],\"U\")+COUNTIF(AprilAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[22],\"U\")+COUNTIF(AprilAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[23],\"U\")+COUNTIF(AprilAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[24],\"U\")+COUNTIF(AprilAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[25],\"U\")+COUNTIF(AprilAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[26],\"U\")+COUNTIF(AprilAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[27],\"U\")+COUNTIF(AprilAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[28],\"U\")+COUNTIF(AprilAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(AprilAttendance[29],\"U\")+COUNTIF(AprilAttendance[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,AprilAttendance[T])","v":0},{"$f":"SUBTOTAL(109,AprilAttendance[E])","v":0},{"$f":"SUBTOTAL(109,AprilAttendance[U])","v":0},{"$f":"SUBTOTAL(109,AprilAttendance[P])","v":0},{"$f":"SUBTOTAL(109,AprilAttendance[欠席日数])","v":0}]

{"sheet":"1 月","index":11,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,1,1)","v":"2012-01-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,1),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,2),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,3),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,4),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,5),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,6),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,7),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,8),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,9),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,10),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,11),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,12),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,13),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,14),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,15),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,16),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,17),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,18),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,19),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,20),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,21),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,22),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,23),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,24),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,25),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,26),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,27),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,28),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,29),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,30),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,1,31),1),\"aaa\")","v":"木"},"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(MayAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(MayAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(MayAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(MayAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(MayAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(MayAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(MayAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(MayAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(MayAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(MayAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(MayAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(MayAttendance[1],\"U\")+COUNTIF(MayAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[2],\"U\")+COUNTIF(MayAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[3],\"U\")+COUNTIF(MayAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[4],\"U\")+COUNTIF(MayAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[5],\"U\")+COUNTIF(MayAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[6],\"U\")+COUNTIF(MayAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[7],\"U\")+COUNTIF(MayAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[8],\"U\")+COUNTIF(MayAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[9],\"U\")+COUNTIF(MayAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[10],\"U\")+COUNTIF(MayAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[11],\"U\")+COUNTIF(MayAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[12],\"U\")+COUNTIF(MayAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[13],\"U\")+COUNTIF(MayAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[14],\"U\")+COUNTIF(MayAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[15],\"U\")+COUNTIF(MayAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[16],\"U\")+COUNTIF(MayAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[17],\"U\")+COUNTIF(MayAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[18],\"U\")+COUNTIF(MayAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[19],\"U\")+COUNTIF(MayAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[20],\"U\")+COUNTIF(MayAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[21],\"U\")+COUNTIF(MayAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[22],\"U\")+COUNTIF(MayAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[23],\"U\")+COUNTIF(MayAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[24],\"U\")+COUNTIF(MayAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[25],\"U\")+COUNTIF(MayAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[26],\"U\")+COUNTIF(MayAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[27],\"U\")+COUNTIF(MayAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[28],\"U\")+COUNTIF(MayAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(MayAttendance[29],\"U\")+COUNTIF(MayAttendance[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,MayAttendance[T])","v":0},{"$f":"SUBTOTAL(109,MayAttendance[E])","v":0},{"$f":"SUBTOTAL(109,MayAttendance[U])","v":0},{"$f":"SUBTOTAL(109,MayAttendance[P])","v":0},{"$f":"SUBTOTAL(109,MayAttendance[欠席日数])","v":0}]

{"sheet":"2 月","index":12,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,2,1)","v":"2012-02-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,1),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,2),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,3),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,4),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,5),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,6),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,7),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,8),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,9),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,10),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,11),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,12),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,13),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,14),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,15),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,16),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,17),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,18),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,19),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,20),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,21),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,22),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,23),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,24),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,25),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,26),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,27),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,2,28),1),\"aaa\")","v":"木"},{"$nulls":3},"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(JuneAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JuneAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JuneAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JuneAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JuneAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JuneAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JuneAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JuneAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JuneAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JuneAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JuneAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(JuneAttendance[1],\"U\")+COUNTIF(JuneAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[2],\"U\")+COUNTIF(JuneAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[3],\"U\")+COUNTIF(JuneAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[4],\"U\")+COUNTIF(JuneAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[5],\"U\")+COUNTIF(JuneAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[6],\"U\")+COUNTIF(JuneAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[7],\"U\")+COUNTIF(JuneAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[8],\"U\")+COUNTIF(JuneAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[9],\"U\")+COUNTIF(JuneAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[10],\"U\")+COUNTIF(JuneAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[11],\"U\")+COUNTIF(JuneAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[12],\"U\")+COUNTIF(JuneAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[13],\"U\")+COUNTIF(JuneAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[14],\"U\")+COUNTIF(JuneAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[15],\"U\")+COUNTIF(JuneAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[16],\"U\")+COUNTIF(JuneAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[17],\"U\")+COUNTIF(JuneAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[18],\"U\")+COUNTIF(JuneAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[19],\"U\")+COUNTIF(JuneAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[20],\"U\")+COUNTIF(JuneAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[21],\"U\")+COUNTIF(JuneAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[22],\"U\")+COUNTIF(JuneAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[23],\"U\")+COUNTIF(JuneAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[24],\"U\")+COUNTIF(JuneAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[25],\"U\")+COUNTIF(JuneAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[26],\"U\")+COUNTIF(JuneAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[27],\"U\")+COUNTIF(JuneAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[28],\"U\")+COUNTIF(JuneAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(JuneAttendance[29],\"U\")+COUNTIF(JuneAttendance[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,JuneAttendance[T])","v":0},{"$f":"SUBTOTAL(109,JuneAttendance[E])","v":0},{"$f":"SUBTOTAL(109,JuneAttendance[U])","v":0},{"$f":"SUBTOTAL(109,JuneAttendance[P])","v":0},{"$f":"SUBTOTAL(109,JuneAttendance[欠席日数])","v":0}]

{"sheet":"3 月","index":13,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["学生の出席記録",{"$nulls":36},"学校年度の開始:",{"$f":"CalendarYear","v":2012}]
[]
[null,null,{"$f":"ColorKeyText","v":"色分け"},{"$f":"Code1","v":"T"},{"$f":"Code1Text","v":"遅刻"},null,null,{"$f":"Code2","v":"E"},{"$f":"Code2Text","v":"届出欠席"},null,null,{"$f":"Code3","v":"U"},{"$f":"Code3Text","v":"無断欠席"},null,null,{"$f":"Code4","v":"P"},{"$f":"Code4Text","v":"出席"},null,null,{"$f":"Code5","v":"N"},{"$f":"Code5Text","v":"休校日"}]
[]
[null,{"$f":"DATE(CalendarYear,3,1)","v":"2012-03-01"},null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,1),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,2),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,3),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,4),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,5),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,6),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,7),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,8),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,9),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,10),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,11),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,12),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,13),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,14),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,15),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,16),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,17),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,18),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,19),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,20),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,21),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,22),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,23),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,24),1),\"aaa\")","v":"日"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,25),1),\"aaa\")","v":"月"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,26),1),\"aaa\")","v":"火"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,27),1),\"aaa\")","v":"水"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,28),1),\"aaa\")","v":"木"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,29),1),\"aaa\")","v":"金"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,30),1),\"aaa\")","v":"土"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear+1,3,31),1),\"aaa\")","v":"日"},"合計"]
[null,"学生 ID","学生名","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","E","U","P","欠席日数"]
[null,null,{"$f":"IFERROR(VLOOKUP(JulyAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JulyAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JulyAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JulyAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JulyAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JulyAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JulyAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JulyAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(JulyAttendance[[#This Row],[学生 ID]],StudentList[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(JulyAttendance[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(JulyAttendance[[#This Row],[E]:[U]])","v":0}]
[null,null,"合計欠席日数",{"$f":"COUNTIF(JulyAttendance[1],\"U\")+COUNTIF(JulyAttendance[1],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[2],\"U\")+COUNTIF(JulyAttendance[2],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[3],\"U\")+COUNTIF(JulyAttendance[3],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[4],\"U\")+COUNTIF(JulyAttendance[4],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[5],\"U\")+COUNTIF(JulyAttendance[5],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[6],\"U\")+COUNTIF(JulyAttendance[6],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[7],\"U\")+COUNTIF(JulyAttendance[7],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[8],\"U\")+COUNTIF(JulyAttendance[8],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[9],\"U\")+COUNTIF(JulyAttendance[9],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[10],\"U\")+COUNTIF(JulyAttendance[10],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[11],\"U\")+COUNTIF(JulyAttendance[11],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[12],\"U\")+COUNTIF(JulyAttendance[12],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[13],\"U\")+COUNTIF(JulyAttendance[13],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[14],\"U\")+COUNTIF(JulyAttendance[14],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[15],\"U\")+COUNTIF(JulyAttendance[15],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[16],\"U\")+COUNTIF(JulyAttendance[16],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[17],\"U\")+COUNTIF(JulyAttendance[17],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[18],\"U\")+COUNTIF(JulyAttendance[18],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[19],\"U\")+COUNTIF(JulyAttendance[19],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[20],\"U\")+COUNTIF(JulyAttendance[20],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[21],\"U\")+COUNTIF(JulyAttendance[21],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[22],\"U\")+COUNTIF(JulyAttendance[22],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[23],\"U\")+COUNTIF(JulyAttendance[23],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[24],\"U\")+COUNTIF(JulyAttendance[24],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[25],\"U\")+COUNTIF(JulyAttendance[25],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[26],\"U\")+COUNTIF(JulyAttendance[26],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[27],\"U\")+COUNTIF(JulyAttendance[27],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[28],\"U\")+COUNTIF(JulyAttendance[28],\"E\")","v":0},{"$f":"COUNTIF(JulyAttendance[29],\"U\")+COUNTIF(JulyAttendance[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,JulyAttendance[T])","v":0},{"$f":"SUBTOTAL(109,JulyAttendance[E])","v":0},{"$f":"SUBTOTAL(109,JulyAttendance[U])","v":0},{"$f":"SUBTOTAL(109,JulyAttendance[P])","v":0},{"$f":"SUBTOTAL(109,JulyAttendance[欠席日数])","v":0}]

{"sheet":"学生の出席記録","index":14,"n_rows":40,"n_cols":37,"rows_kept":40,"merged":[[2,3,2,14],[2,15,2,17],[2,18,2,21],[2,22,2,29],[2,30,2,31],[2,32,2,35],[3,1,3,2],[3,3,3,14],[3,15,3,17],[3,18,3,21],[3,22,3,29],[3,30,3,31],[3,32,3,35],[4,1,4,9],[4,10,4,21],[4,22,4,29],[4,30,4,36],[5,1,5,9],[5,10,5,21],[5,22,5,29],[5,30,5,36],[6,1,6,9],[6,10,6,21],[6,22,6,29],[6,30,6,36],[7,1,7,9],[7,10,7,21],[7,22,7,29],[7,30,7,36],[8,1,8,9],[8,10,8,21],[8,22,8,29],[8,30,8,36],[9,1,9,9],[9,10,9,21],[9,22,9,29],[9,30,9,36],[13,1,14,32],[13,33,13,36],[15,1,16,1],[15,33,16,33],[15,34,16,34],[15,35,16,35],[15,36,16,36],[17,1,18,1],[17,33,18,33],[17,34,18,34],[17,35,18,35],[17,36,18,36],[19,1,20,1],[19,33,20,33],[19,34,20,34],[19,35,20,35],[19,36,20,36],[21,1,22,1],[21,33,22,33],[21,34,22,34],[21,35,22,35],[21,36,22,36],[23,1,24,1],[23,33,24,33],[23,34,24,34],[23,35,24,35],[23,36,24,36],[25,1,26,1],[25,33,26,33],[25,34,26,34],[25,35,26,35],[25,36,26,36],[27,1,28,1],[27,33,28,33],[27,34,28,34],[27,35,28,35],[27,36,28,36],[29,1,30,1],[29,33,30,33],[29,34,30,34],[29,35,30,35],[29,36,30,36],[31,1,32,1],[31,33,32,33],[31,34,32,34],[31,35,32,35],[31,36,32,36],[33,1,34,1],[33,33,34,33],[33,34,34,34],[33,35,34,35],[33,36,34,36],[35,1,36,1],[35,33,36,33],[35,34,36,34],[35,35,36,35],[35,36,36,36],[37,1,38,1],[37,33,38,33],[37,34,38,34],[37,35,38,35],[37,36,38,36],[39,30,39,32]]}
[{"$f":"\"出席記録:  \"","v":"出席記録:  "},null,null,{"$f":"D4","v":"川田 弘穀"}]
[]
[null,"学生 ID",null,"学生名",{"$nulls":11},"性別",null,null,"誕生日",{"$nulls":3},"学校名",{"$nulls":7},"学年",null,"先生",{"$nulls":3},"教室"]
[null,"S001",null,{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],18,FALSE),\"\")","v":"川田 弘穀"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],4,FALSE),\"\")","v":"男"},null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],5,FALSE),\"\")","v":"1997-03-28"},{"$nulls":3},"美術学校",{"$nulls":7},7,null,"加山 宏",{"$nulls":3},123]
[null,"保護者 1",{"$nulls":8},"続柄",{"$nulls":11},"勤務先電話番号",{"$nulls":7},"自宅電話番号"]
[null,{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],6,FALSE),\"\")","v":"川田 一之"},{"$nulls":8},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],7,FALSE),\"\")","v":"兄"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],8,FALSE),\"\")","v":"(03)1111-1111"},{"$nulls":7},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],9,FALSE),\"\")","v":"(03)1111-2222"}]
[null,"保護者 2",{"$nulls":8},"続柄",{"$nulls":11},"勤務先電話番号",{"$nulls":7},"自宅電話番号"]
[null,{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],10,FALSE),\"\")","v":"川田 浩之"},{"$nulls":8},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],11,FALSE),\"\")","v":"父"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],12,FALSE),\"\")","v":"(03)1111-1111"},{"$nulls":7},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],13,FALSE),\"\")","v":"(03)1111-2222"}]
[null,"緊急連絡先",{"$nulls":8},"続柄",{"$nulls":11},"勤務先電話番号",{"$nulls":7},"自宅電話番号"]
[null,{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],14,FALSE),\"\")","v":"川井 伸好"},{"$nulls":8},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],15,FALSE),\"\")","v":"祖父"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],16,FALSE),\"\")","v":"(03)1111-3333"},{"$nulls":7},{"$f":"IFERROR(VLOOKUP(StudentLookup,StudentList[],17,FALSE),\"\")","v":"(03)1111-4444"}]
[]
[null,{"$f":"'4 月'!C3","v":"色分け"},{"$f":"'4 月'!D3","v":"T"},{"$f":"'4 月'!E3","v":"遅刻"},null,null,{"$f":"'4 月'!H3","v":"E"},{"$f":"'4 月'!I3","v":"届出欠席"},null,null,{"$f":"'4 月'!L3","v":"U"},{"$f":"'4 月'!M3","v":"無断欠席"},{"$nulls":3},{"$f":"'4 月'!P3","v":"P"},{"$f":"'4 月'!Q3","v":"出席"},null,null,{"$f":"'4 月'!T3","v":"N"},{"$f":"'4 月'!U3","v":"休校日"}]
[]
[null,"出席状況",{"$nulls":31},"出席状況の合計"]
[{"$nulls":33},"T","E","U","P"]
[null,"4 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,{"$f":"COUNTIF($D17:$AH17,Code1)","v":2},{"$f":"COUNTIF($D17:$AH17,Code2)","v":1},{"$f":"COUNTIF($D17:$AH17,Code3)","v":0},{"$f":"COUNTIF($D17:$AH17,Code4)","v":18}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],3,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],4,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],5,FALSE),\"\")","v":"T"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],6,FALSE),\"\")","v":"T"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],7,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],8,FALSE),\"\")","v":"N"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],9,FALSE),\"\")","v":"N"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],10,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],11,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],12,FALSE),\"\")","v":"E"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],13,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],14,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],15,FALSE),\"\")","v":"N"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],16,FALSE),\"\")","v":"N"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],17,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],18,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],19,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],20,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],21,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],22,FALSE),\"\")","v":"N"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],23,FALSE),\"\")","v":"N"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],24,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],25,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],26,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],27,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],28,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],29,FALSE),\"\")","v":"N"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],30,FALSE),\"\")","v":"N"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],31,FALSE),\"\")","v":"P"},{"$f":"IFERROR(VLOOKUP(StudentLookup,AugustAttendance[],32,FALSE),\"\")","v":"P"}]
[null,"5 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D19:$AH19,Code1)","v":0},{"$f":"COUNTIF($D19:$AH19,Code2)","v":0},{"$f":"COUNTIF($D19:$AH19,Code3)","v":0},{"$f":"COUNTIF($D19:$AH19,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,SeptemberAttendance[],33,FALSE),\"\")","v":""}]
[null,"6 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,{"$f":"COUNTIF($D21:$AH21,Code1)","v":0},{"$f":"COUNTIF($D21:$AH21,Code2)","v":0},{"$f":"COUNTIF($D21:$AH21,Code3)","v":0},{"$f":"COUNTIF($D21:$AH21,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,OctoberAttendance[],33,FALSE),\"\")","v":""}]
[null,"7 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D23:$AH23,Code1)","v":0},{"$f":"COUNTIF($D23:$AH23,Code2)","v":0},{"$f":"COUNTIF($D23:$AH23,Code3)","v":0},{"$f":"COUNTIF($D23:$AH23,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,NovemberAttendance[],33,FALSE),\"\")","v":""}]
[null,"8 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D25:$AH25,Code1)","v":0},{"$f":"COUNTIF($D25:$AH25,Code2)","v":0},{"$f":"COUNTIF($D25:$AH25,Code3)","v":0},{"$f":"COUNTIF($D25:$AH25,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,DecemberAttendance[],33,FALSE),\"\")","v":""}]
[null,"9 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,{"$f":"COUNTIF($D27:$AH27,Code1)","v":0},{"$f":"COUNTIF($D27:$AH27,Code2)","v":0},{"$f":"COUNTIF($D27:$AH27,Code3)","v":0},{"$f":"COUNTIF($D27:$AH27,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JanuaryAttendance[],32,FALSE),\"\")","v":""}]
[null,"10 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D29:$AH29,Code1)","v":0},{"$f":"COUNTIF($D29:$AH29,Code2)","v":0},{"$f":"COUNTIF($D29:$AH29,Code3)","v":0},{"$f":"COUNTIF($D29:$AH29,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,FebruaryAttendance[],33,FALSE),\"\")","v":""}]
[null,"11 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,{"$f":"COUNTIF($D31:$AH31,Code1)","v":0},{"$f":"COUNTIF($D31:$AH31,Code2)","v":0},{"$f":"COUNTIF($D31:$AH31,Code3)","v":0},{"$f":"COUNTIF($D31:$AH31,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MarchAttendance[],32,FALSE),\"\")","v":""}]
[null,"12 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D33:$AH33,Code1)","v":0},{"$f":"COUNTIF($D33:$AH33,Code2)","v":0},{"$f":"COUNTIF($D33:$AH33,Code3)","v":0},{"$f":"COUNTIF($D33:$AH33,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,AprilAttendance[],33,FALSE),\"\")","v":""}]
[null,"1 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D35:$AH35,Code1)","v":0},{"$f":"COUNTIF($D35:$AH35,Code2)","v":0},{"$f":"COUNTIF($D35:$AH35,Code3)","v":0},{"$f":"COUNTIF($D35:$AH35,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,MayAttendance[],33,FALSE),\"\")","v":""}]
[null,"2 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,{"$nulls":3},{"$f":"COUNTIF($D37:$AH37,Code1)","v":0},{"$f":"COUNTIF($D37:$AH37,Code2)","v":0},{"$f":"COUNTIF($D37:$AH37,Code3)","v":0},{"$f":"COUNTIF($D37:$AH37,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JuneAttendance[],30,FALSE),\"\")","v":""}]
[null,"3 月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D39:$AH39,Code1)","v":0},{"$f":"COUNTIF($D39:$AH39,Code2)","v":0},{"$f":"COUNTIF($D39:$AH39,Code3)","v":0},{"$f":"COUNTIF($D39:$AH39,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentLookup,JulyAttendance[],33,FALSE),\"\")","v":""}]
[{"$nulls":30},"合計",null,null,{"$f":"SUM(AH16:AH39)","v":2},{"$f":"SUM(AI16:AI39)","v":1},{"$f":"SUM(AJ16:AJ39)","v":0},{"$f":"SUM(AK16:AK39)","v":18}]