{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Notice","Roster"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Notice","index":0,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"In order to properly use this document, you must enable macros"]

{"sheet":"Roster","index":1,"n_rows":206,"n_cols":19,"rows_kept":206,"cut":false,"hidden":true,"merged":[[1,2,2,11],[3,0,4,0],[1,1,2,1],[3,1,4,1],[3,2,4,6],[3,10,4,11]]}
[null,"# Students",1,null,null,null,null,null,null,null,null,"Version  - 2.6"]
[null,"School:"," Please select a school from the drop down"]
[]
[null,"Instructor E-mail Address",null,null,null,null,null,null,null,null,{"$f":"validateEmail(C4)","v":"Invalid E-mail Address"}]
[]
[]
["#","StudentID","First Name","Middle Initial","Last Name","First Clinical Day","Last Clinical Day","School","Contact","Valid","Fingerprint Time","Validation"]
[1,null,null,null,null,null,null,{"$f":"$C$2","v":" Please select a school from the drop down"},{"$f":"$C$4","v":"00:00:00"},null,null,{"$f":"TRIM(IF(ROW()-7 <= $C$1, validateResults(A8:K8), \"Exempt\"))","v":"StudentID Invalid - Must be populated and unique \r\nFirst Name Invalid - Check for spaces and symbols\r\nLast Name Invalid - Check for spaces and symbols\r\nPlease select valid fingerprint time\r\nStartDate Invalid\r\nEndDate Invalid\r\nStart Date exceeds EndDate\r\n"},null,null,null,null,null,"8A-10A First Clinical Day"," Please select a school from the drop down"]
[2,null,null,null,null,null,null,{"$f":"$C$2","v":" Please select a school from the drop down"},{"$f":"$C$4","v":"00:00:00"},null,null,{"$f":"TRIM(IF(ROW()-7 <= $C$1, validateResults(A9:K9), \"Exempt\"))","v":"Exempt"},null,null,null,null,null,"3P-5P First Clinical Day","Ashland University"]
[3,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",null,null,"Exempt",null,null,null,null,null,"Self-Enrollment on Unit","Benedictine University"]
[4,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",null,null,"Exempt",null,null,null,null,null,"N/A - Not Administering Medications","Capital University"]
[5,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",null,null,"Exempt",null,null,null,null,null,null,"Case Western Reserve"]
[6,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Central Ohio Technical College"]
[7,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Chamberlain College of Nursing"]
[8,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Chatham University"]
[9,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Columbus State"]
[10,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Fitchburg State University"]
[11,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Franklin University"]
[12,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Frontier Nursing University"]
[13,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"George Mason University"]
[14,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"George Washington University"]
[15,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Georgetown University"]
[16,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Hocking College"]
[17,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Hondros College School of Nursing"]
[18,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Indiana State University"]
[19,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Indiana Wesleyan University"]
[20,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Kaplan University"]
[21,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Kent State University"]
[22,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Liberty University"]
[23,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Marion Technical College"]
[24,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Mt. Carmel College of Nursing"]
[25,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Mt. Vernon Nazarene University"]
[26,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Muskingum University"]
[27,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"North Central State College"]
[28,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Ohio Northern University"]
[29,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Ohio University - Athens"]
[30,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Ohio University - Chillicothe"]
[31,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Ohio University - Zanesville"]
[32,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Otterbein University"]
[33,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Purdue University"]
[34,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Regis University"]
[35,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"The Ohio State University"]
[36,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"University of Akron"]
[37,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"University of Cincinnati"]
[38,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"University of Toledo"]
[39,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Vanderbilt University"]
[40,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"West Virginia University"]
[41,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Wheeling Jesuit University"]
[42,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Wright State University"]
[43,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Xavier University"]
[44,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt",null,null,null,null,null,null,"Other"]
[45,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[46,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[47,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[48,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[49,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[50,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[51,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[52,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[53,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[54,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[55,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[56,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[57,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[58,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[59,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[60,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[61,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[62,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[63,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[64,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[65,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[66,null,null,null,null,null,null,{"$f":"$C$2","v":" Please select a school from the drop down"},{"$f":"$C$4","v":"00:00:00"},{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,{"$f":"TRIM(IF(ROW()-7 <= $C$1, validateResults(A73:K73), \"Exempt\"))","v":"Exempt"}]
[67,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[68,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[69,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[70,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[71,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[72,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[73,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[74,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[75,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[76,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[77,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[78,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[79,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[80,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[81,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[82,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[83,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[84,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[85,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[86,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[87,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[88,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[89,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[90,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[91,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[92,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[93,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[94,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[95,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[96,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[97,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[98,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[99,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[100,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[101,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[102,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[103,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[104,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[105,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[106,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[107,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[108,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[109,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[110,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[111,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[112,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[113,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[114,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[115,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[116,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[117,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[118,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[119,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[120,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[121,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[122,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[123,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[124,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[125,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[126,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[127,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[128,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[129,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[130,null,null,null,null,null,null,{"$f":"$C$2","v":" Please select a school from the drop down"},{"$f":"$C$4","v":"00:00:00"},{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,{"$f":"TRIM(IF(ROW()-7 <= $C$1, validateResults(A137:K137), \"Exempt\"))","v":"Exempt"}]
[131,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[132,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[133,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[134,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[135,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[136,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[137,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[138,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[139,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[140,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[141,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[142,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[143,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[144,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[145,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[146,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[147,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[148,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[149,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[150,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[151,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[152,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[153,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[154,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[155,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[156,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[157,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[158,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[159,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[160,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[161,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[162,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[163,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[164,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[165,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[166,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[167,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[168,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[169,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[170,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[171,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[172,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[173,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[174,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[176,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[177,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[178,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[179,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[180,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[181,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[182,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[183,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[184,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[185,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[186,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[187,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[188,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[189,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[190,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[191,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[192,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[193,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[194,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[195,null,null,null,null,null,null,{"$f":"$C$2","v":" Please select a school from the drop down"},{"$f":"$C$4","v":"00:00:00"},{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,{"$f":"TRIM(IF(ROW()-7 <= $C$1, validateResults(A201:K201), \"Exempt\"))","v":"Exempt"}]
[196,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[197,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[198,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[199,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]
[200,null,null,null,null,null,null," Please select a school from the drop down","00:00:00",{"$f":"IF(ROW()-7 <= $C$1, IsValid(MyNamedRange[[#This Row],[StudentID]:[Valid]]), \"Exempt\")","v":"Exempt"},null,"Exempt"]