{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Start","Weekly attendance report"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this template to create a Weekly attendance report."]
[null,"Fill in Room name or number, Time and period, Teacher, Course names and Week start date."]
[null,"Enter Student names and Y for yes in Attendance table to mark student as Present, Tardy, Unexcused or Excused for corresponding day."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in WEEKLY ATTENDANCE REPORT worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font colour."]
[null,"To learn more about table, press SHIFT and then F10 within the table, select the TABLE option and then select ALTERNATIVE TEXT."]

{"sheet":"Weekly attendance report","index":1,"n_rows":14,"n_cols":25,"rows_kept":14,"merged":[[0,4,0,24],[1,2,2,2],[1,5,1,8],[1,9,1,12],[1,13,1,16],[1,17,1,20],[1,21,1,24],[3,2,4,2],[5,2,6,2],[7,2,8,2],[9,2,10,2],[11,2,12,2],[13,2,14,2]]}
["Create a Weekly attendance report in this worksheet. Title of the worksheet is in cell to the right. Helpful instructions on how to use this worksheet are in cells in this column. Arrow-down to get started.",{"$nulls":3},"Weekly attendance report"]
["Enter Room name or number in cell C2. Weekdays are in cells F2 to V2.",null,"Room",null,null,"Monday",{"$nulls":3},"Tuesday",{"$nulls":3},"Wednesday",{"$nulls":3},"Thursday",{"$nulls":3},"Friday"]
["Enter details in Attendance table starting in cell E3.",{"$nulls":3},"Student name","P1","T1","U1","E1","P2","T2","U2","E2","P3","T3","U3","E3","P4","T4","U4","E4","P5","T5","U5","E5"]
["Enter Period and time in cell C4. Next instruction is in cell A6.",null,"Period/Time"]
[]
["Enter Teacher name in cell C6. Next instruction is in cell A8.",null,"Teacher"]
[]
["Enter Course name in cell C8. Next instruction is in cell A10.",null,"Course"]
[]
["Enter Week of date in cell C10. Next instruction is in cell A12.",null,"Week of"]
[]
["Legends are defined in cells C12 to C15.",null,"P = Present; T = Tardy;"]
[]
[null,null,"U = Unexcused; E = Excused; # = Day of the week"]