{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Student List","Class Roster","Student Details"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Student List","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,2,3],[1,4,1,11],[2,4,2,11],[6,12,8,16]]}
[]
[null,null,"Student List",null,"GO TO CLASS ROSTER"]
[null,null,null,null,"GO TO STUDENT DETAILS"]
[null,null,"STUDENT NAME","EMAIL","HOME PHONE","CELL PHONE","DOB","EMERGENCY CONTACT","EMERGENCY PHONE","PHYSICIAN","PHYSICIAN PHONE","  "]
[null,null,"Name 1","Email address","Home phone","Cell phone","Date","Contact 1","Emergency phone","Physician 1","Physician phone"]
[null,null,"Name 2","Email address","Home phone","Cell phone","Date","Contact 2","Emergency phone","Physician 2","Physician phone"]
[null,null,"Name 3","Email address","Home phone","Cell phone","Date","Contact 3","Emergency phone","Physician 3","Physician phone",null,"Tip:To add more students, in the last cell of the table, press the tab key."]
[null,null,"Name 4","Email address","Home phone","Cell phone","Date","Contact 4","Emergency phone","Physician 4","Physician phone"]

{"sheet":"Class Roster","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,2,2,2],[2,4,2,6],[1,4,1,6],[1,3,2,3]]}
[]
[null,null,"Class Roster","Graphic Design Institute","GO TO STUDENT LIST"]
[null,null,null,null,"GO TO STUDENT DETAILS"]
[null,null,"COURSE","Course name","START DATE","Date"]
[null,null,"INSTRUCTOR","Instructor 1","END DATE","Date"]
[null,null,"STUDENTS ENROLLED",{"$f":"COUNTA(StudentRoster[STUDENT NAME])","v":5}]
[]
[null,null,"STUDENT NAME","EMAIL","HOME PHONE","CELL PHONE","  "]
[null,null,"Name 1",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],2),\"\")","v":"Email address"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],3),\"\")","v":"Home phone"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],4),\"\")","v":"Cell phone"}]
[null,null,"Name 2",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],2),\"\")","v":"Email address"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],3),\"\")","v":"Home phone"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],4),\"\")","v":"Cell phone"}]
[null,null,"Name 3",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],2),\"\")","v":"Email address"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],3),\"\")","v":"Home phone"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],4),\"\")","v":"Cell phone"}]
[null,null,"Name 4",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],2),\"\")","v":"Email address"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],3),\"\")","v":"Home phone"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],4),\"\")","v":"Cell phone"}]
[null,null,"Name 3",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],2),\"\")","v":"Email address"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],3),\"\")","v":"Home phone"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[STUDENT NAME]],Students[],4),\"\")","v":"Cell phone"}]

{"sheet":"Student Details","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,3,1,4],[2,3,2,4],[1,2,2,2],[3,2,3,3]]}
[]
[null,null,"Student Details","GO TO STUDENT LIST"]
[null,null,null,"GO TO CLASS ROSTER"]
[null,null,"TIP: SELECT A STUDENT FROM THE DROP DOWN LIST IN CELL D5 TO UPDATE THE STUDENT DETAILS"]
[null,null,"STUDENT NAME","Name 1"]
[null,null,"EMAIL",{"$f":"IFERROR(VLOOKUP(StudentName,Students[],2,FALSE),\"\")","v":"Email address"}]
[null,null,"HOME PHONE",{"$f":"IFERROR(VLOOKUP(StudentName,Students[],3,FALSE),\"\")","v":"Home phone"}]
[null,null,"CELL PHONE",{"$f":"IFERROR(VLOOKUP(StudentName,Students[],4,FALSE),\"\")","v":"Cell phone"}]
[null,null,"DOB",{"$f":"IFERROR(VLOOKUP(StudentName,Students[],5,FALSE),\"\")","v":"Date"}]
[null,null,"EMERGENCY CONTACT",{"$f":"IFERROR(VLOOKUP(StudentName,Students[],6,FALSE),\"\")","v":"Contact 1"}]
[null,null,"EMERGENCY PHONE",{"$f":"IFERROR(VLOOKUP(StudentName,Students[],7,FALSE),\"\")","v":"Emergency phone"}]
[null,null,"PHYSICIAN",{"$f":"IFERROR(VLOOKUP(StudentName,Students[],8,FALSE),\"\")","v":"Physician 1"}]
[null,null,"PHYSICIAN PHONE",{"$f":"IFERROR(VLOOKUP(StudentName,Students[],9,FALSE),\"\")","v":"Physician phone"}]