{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Phonics Screening Check","Reference"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":52,"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":"Phonics Screening Check","index":0,"n_rows":270,"n_cols":13,"rows_kept":270,"cut":false,"hidden":false,"merged":[[18,5,19,5],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4]]}
["If prompted, please 'Enable Content' before entering details."]
[]
["2025 SCREENING CHECK SCHOOLS TO LA SPREADSHEET"]
["1.  Enter school/setting identification details in the boxes below:",null,null,"Return status:"]
[]
["Name of school *",null,null,"Total no. of pupils",null,{"$f":"COUNTIF(J21:J270,TRUE)","v":0}]
["Local Authority No. ",null,null,"Maladministration (Q)",null,{"$f":"COUNTIF(H21:H270,\"Q\")","v":0}]
["School Estab No. ",null,null,"Disapplied (D)",null,{"$f":"COUNTIF(H21:H270,\"D\")","v":0}]
["                                                      * Do not enter commas in the school name",null,null,"Absent (A)",null,{"$f":"COUNTIF(H21:H270,\"A\")","v":0}]
["2.  Starting at row 21 and using a new row for each child, enter his/her",null,null,"Left (L)",null,{"$f":"COUNTIF(H21:H270,\"L\")","v":0}]
["      identifying details and Phonics result levels in appropriate cells"]
["3.  Use drop-down menu for valid outcome codes",null,null,"Missing UPN errors",null,{"$f":"COUNTIF(J21:J270, TRUE) - COUNTA(C21:C270)","v":0}]
["4.  Using keyboard tab key will move the cursor to next box/row ",null,null,"Duplicate UPN errors",null,{"$f":"M28","v":0}]
["5.  When all entries are complete, save / back up the worksheet then click on the ",null,null,"Invalid UPNs",null,{"$f":"M27","v":0}]
["     'Export' button below to create a CSV export file and send to your Local  ",null,null,"Missing non-UPN data",null,{"$f":"M29","v":0}]
["     Authority as directed.",null,null,"Result qualifiers missing/duplicated",null,{"$f":"M30+M31","v":0}]
[]
[]
["Child Surname","Child Forename","UPN","Sex\n(M or F)  ","Date of Birth (DD/MM/YYYY) ","Year Group","Phonics Check Mark","Phonics Check Outcome"]
[null,null,null,null,null,null,"(NM)","(NY)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C21=\"\",\"\",IF(J21<>\"\",IF(TestUPN(C21)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C21)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A21:F21)","v":false},{"$f":"IF(J21 = TRUE,(G21<>\"\") + (H21<>\"\"), \"\")","v":""},"Surnames",{"$f":"COUNTA($A$21:$A$270)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C22=\"\",\"\",IF(J22<>\"\",IF(TestUPN(C22)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C22)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A22:F22)","v":false},{"$f":"IF(J22 = TRUE,(G22<>\"\") + (H22<>\"\"), \"\")","v":""},"Forenames",{"$f":"COUNTA($B$21:$B$270)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C23=\"\",\"\",IF(J23<>\"\",IF(TestUPN(C23)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C23)>1,\"Duplicate UPN\",\"\"))))","v":""},false,"","UPNs",{"$f":"COUNTA($C$21:$C$270)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C24=\"\",\"\",IF(J24<>\"\",IF(TestUPN(C24)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C24)>1,\"Duplicate UPN\",\"\"))))","v":""},false,"","Genders",{"$f":"COUNTA($D$21:$D$270)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",IF(J25<>\"\",IF(TestUPN(C25)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C25)>1,\"Duplicate UPN\",\"\"))))","v":""},false,"","DoB",{"$f":"COUNTA($E$21:$E$270)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C26=\"\",\"\",IF(J26<>\"\",IF(TestUPN(C26)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C26)>1,\"Duplicate UPN\",\"\"))))","v":""},false,"","YearGroup",{"$f":"COUNTA($F$21:$F$270)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C27=\"\",\"\",IF(J27<>\"\",IF(TestUPN(C27)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C27)>1,\"Duplicate UPN\",\"\"))))","v":""},false,"","Invalid UPN",{"$f":"COUNTIF($I$21:$I$270, L27)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C28=\"\",\"\",IF(J28<>\"\",IF(TestUPN(C28)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C28)>1,\"Duplicate UPN\",\"\"))))","v":""},false,"","Duplicate UPN",{"$f":"COUNTIF($I$21:$I$270, L28)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C29=\"\",\"\",IF(J29<>\"\",IF(TestUPN(C29)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C29)>1,\"Duplicate UPN\",\"\"))))","v":""},false,"","Missing values",{"$f":"F6*5-SUM(M21+M22+M24+M25+M26)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C30=\"\",\"\",IF(J30<>\"\",IF(TestUPN(C30)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C30)>1,\"Duplicate UPN\",\"\"))))","v":""},false,"","Missing check values",{"$f":"COUNTIF(K21:K270,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",IF(J31<>\"\",IF(TestUPN(C31)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C31)>1,\"Duplicate UPN\",\"\"))))","v":""},false,"","Both check values submitted",{"$f":"COUNTIF(K21:K270, 2)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C32=\"\",\"\",IF(J32<>\"\",IF(TestUPN(C32)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C32)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C33=\"\",\"\",IF(J33<>\"\",IF(TestUPN(C33)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C33)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C34=\"\",\"\",IF(J34<>\"\",IF(TestUPN(C34)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C34)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C35=\"\",\"\",IF(J35<>\"\",IF(TestUPN(C35)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C35)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C36=\"\",\"\",IF(J36<>\"\",IF(TestUPN(C36)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C36)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C37=\"\",\"\",IF(J37<>\"\",IF(TestUPN(C37)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C37)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C38=\"\",\"\",IF(J38<>\"\",IF(TestUPN(C38)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C38)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C39=\"\",\"\",IF(J39<>\"\",IF(TestUPN(C39)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C39)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C40=\"\",\"\",IF(J40<>\"\",IF(TestUPN(C40)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C40)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C41=\"\",\"\",IF(J41<>\"\",IF(TestUPN(C41)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C41)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C42=\"\",\"\",IF(J42<>\"\",IF(TestUPN(C42)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C42)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C43=\"\",\"\",IF(J43<>\"\",IF(TestUPN(C43)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C43)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C44=\"\",\"\",IF(J44<>\"\",IF(TestUPN(C44)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C44)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C45=\"\",\"\",IF(J45<>\"\",IF(TestUPN(C45)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C45)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C46=\"\",\"\",IF(J46<>\"\",IF(TestUPN(C46)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C46)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C47=\"\",\"\",IF(J47<>\"\",IF(TestUPN(C47)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C47)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C48=\"\",\"\",IF(J48<>\"\",IF(TestUPN(C48)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C48)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C49=\"\",\"\",IF(J49<>\"\",IF(TestUPN(C49)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C49)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C50=\"\",\"\",IF(J50<>\"\",IF(TestUPN(C50)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C50)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C51=\"\",\"\",IF(J51<>\"\",IF(TestUPN(C51)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C51)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C52=\"\",\"\",IF(J52<>\"\",IF(TestUPN(C52)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C52)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C53=\"\",\"\",IF(J53<>\"\",IF(TestUPN(C53)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C53)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C54=\"\",\"\",IF(J54<>\"\",IF(TestUPN(C54)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C54)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C55=\"\",\"\",IF(J55<>\"\",IF(TestUPN(C55)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C55)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C56=\"\",\"\",IF(J56<>\"\",IF(TestUPN(C56)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C56)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C57=\"\",\"\",IF(J57<>\"\",IF(TestUPN(C57)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C57)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C58=\"\",\"\",IF(J58<>\"\",IF(TestUPN(C58)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C58)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C59=\"\",\"\",IF(J59<>\"\",IF(TestUPN(C59)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C59)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C60=\"\",\"\",IF(J60<>\"\",IF(TestUPN(C60)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C60)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C61=\"\",\"\",IF(J61<>\"\",IF(TestUPN(C61)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C61)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C62=\"\",\"\",IF(J62<>\"\",IF(TestUPN(C62)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C62)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C63=\"\",\"\",IF(J63<>\"\",IF(TestUPN(C63)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C63)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C64=\"\",\"\",IF(J64<>\"\",IF(TestUPN(C64)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C64)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C65=\"\",\"\",IF(J65<>\"\",IF(TestUPN(C65)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C65)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C66=\"\",\"\",IF(J66<>\"\",IF(TestUPN(C66)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C66)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C67=\"\",\"\",IF(J67<>\"\",IF(TestUPN(C67)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C67)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C68=\"\",\"\",IF(J68<>\"\",IF(TestUPN(C68)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C68)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C69=\"\",\"\",IF(J69<>\"\",IF(TestUPN(C69)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C69)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C70=\"\",\"\",IF(J70<>\"\",IF(TestUPN(C70)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C70)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C71=\"\",\"\",IF(J71<>\"\",IF(TestUPN(C71)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C71)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C72=\"\",\"\",IF(J72<>\"\",IF(TestUPN(C72)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C72)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C73=\"\",\"\",IF(J73<>\"\",IF(TestUPN(C73)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C73)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C74=\"\",\"\",IF(J74<>\"\",IF(TestUPN(C74)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C74)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C75=\"\",\"\",IF(J75<>\"\",IF(TestUPN(C75)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C75)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C76=\"\",\"\",IF(J76<>\"\",IF(TestUPN(C76)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C76)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C77=\"\",\"\",IF(J77<>\"\",IF(TestUPN(C77)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C77)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C78=\"\",\"\",IF(J78<>\"\",IF(TestUPN(C78)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C78)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C79=\"\",\"\",IF(J79<>\"\",IF(TestUPN(C79)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C79)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C80=\"\",\"\",IF(J80<>\"\",IF(TestUPN(C80)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C80)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C81=\"\",\"\",IF(J81<>\"\",IF(TestUPN(C81)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C81)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C82=\"\",\"\",IF(J82<>\"\",IF(TestUPN(C82)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C82)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C83=\"\",\"\",IF(J83<>\"\",IF(TestUPN(C83)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C83)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C84=\"\",\"\",IF(J84<>\"\",IF(TestUPN(C84)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C84)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C85=\"\",\"\",IF(J85<>\"\",IF(TestUPN(C85)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C85)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C86=\"\",\"\",IF(J86<>\"\",IF(TestUPN(C86)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C86)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A86:F86)","v":false},{"$f":"IF(J86 = TRUE,(G86<>\"\") + (H86<>\"\"), \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C87=\"\",\"\",IF(J87<>\"\",IF(TestUPN(C87)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C87)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C88=\"\",\"\",IF(J88<>\"\",IF(TestUPN(C88)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C88)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C89=\"\",\"\",IF(J89<>\"\",IF(TestUPN(C89)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C89)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C90=\"\",\"\",IF(J90<>\"\",IF(TestUPN(C90)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C90)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C91=\"\",\"\",IF(J91<>\"\",IF(TestUPN(C91)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C91)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C92=\"\",\"\",IF(J92<>\"\",IF(TestUPN(C92)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C92)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C93=\"\",\"\",IF(J93<>\"\",IF(TestUPN(C93)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C93)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C94=\"\",\"\",IF(J94<>\"\",IF(TestUPN(C94)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C94)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C95=\"\",\"\",IF(J95<>\"\",IF(TestUPN(C95)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C95)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C96=\"\",\"\",IF(J96<>\"\",IF(TestUPN(C96)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C96)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C97=\"\",\"\",IF(J97<>\"\",IF(TestUPN(C97)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C97)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C98=\"\",\"\",IF(J98<>\"\",IF(TestUPN(C98)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C98)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C99=\"\",\"\",IF(J99<>\"\",IF(TestUPN(C99)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C99)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C100=\"\",\"\",IF(J100<>\"\",IF(TestUPN(C100)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C100)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C101=\"\",\"\",IF(J101<>\"\",IF(TestUPN(C101)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C101)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C102=\"\",\"\",IF(J102<>\"\",IF(TestUPN(C102)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C102)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C103=\"\",\"\",IF(J103<>\"\",IF(TestUPN(C103)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C103)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C104=\"\",\"\",IF(J104<>\"\",IF(TestUPN(C104)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C104)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C105=\"\",\"\",IF(J105<>\"\",IF(TestUPN(C105)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C105)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C106=\"\",\"\",IF(J106<>\"\",IF(TestUPN(C106)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C106)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C107=\"\",\"\",IF(J107<>\"\",IF(TestUPN(C107)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C107)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C108=\"\",\"\",IF(J108<>\"\",IF(TestUPN(C108)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C108)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C109=\"\",\"\",IF(J109<>\"\",IF(TestUPN(C109)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C109)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C110=\"\",\"\",IF(J110<>\"\",IF(TestUPN(C110)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C110)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C111=\"\",\"\",IF(J111<>\"\",IF(TestUPN(C111)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C111)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C112=\"\",\"\",IF(J112<>\"\",IF(TestUPN(C112)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C112)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C113=\"\",\"\",IF(J113<>\"\",IF(TestUPN(C113)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C113)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C114=\"\",\"\",IF(J114<>\"\",IF(TestUPN(C114)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C114)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C115=\"\",\"\",IF(J115<>\"\",IF(TestUPN(C115)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C115)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C116=\"\",\"\",IF(J116<>\"\",IF(TestUPN(C116)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C116)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C117=\"\",\"\",IF(J117<>\"\",IF(TestUPN(C117)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C117)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C118=\"\",\"\",IF(J118<>\"\",IF(TestUPN(C118)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C118)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C119=\"\",\"\",IF(J119<>\"\",IF(TestUPN(C119)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C119)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C120=\"\",\"\",IF(J120<>\"\",IF(TestUPN(C120)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C120)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C121=\"\",\"\",IF(J121<>\"\",IF(TestUPN(C121)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C121)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C122=\"\",\"\",IF(J122<>\"\",IF(TestUPN(C122)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C122)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C123=\"\",\"\",IF(J123<>\"\",IF(TestUPN(C123)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C123)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C124=\"\",\"\",IF(J124<>\"\",IF(TestUPN(C124)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C124)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C125=\"\",\"\",IF(J125<>\"\",IF(TestUPN(C125)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C125)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C126=\"\",\"\",IF(J126<>\"\",IF(TestUPN(C126)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C126)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C127=\"\",\"\",IF(J127<>\"\",IF(TestUPN(C127)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C127)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C128=\"\",\"\",IF(J128<>\"\",IF(TestUPN(C128)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C128)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C129=\"\",\"\",IF(J129<>\"\",IF(TestUPN(C129)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C129)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C130=\"\",\"\",IF(J130<>\"\",IF(TestUPN(C130)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C130)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C131=\"\",\"\",IF(J131<>\"\",IF(TestUPN(C131)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C131)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C132=\"\",\"\",IF(J132<>\"\",IF(TestUPN(C132)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C132)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C133=\"\",\"\",IF(J133<>\"\",IF(TestUPN(C133)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C133)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C134=\"\",\"\",IF(J134<>\"\",IF(TestUPN(C134)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C134)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C135=\"\",\"\",IF(J135<>\"\",IF(TestUPN(C135)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C135)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C136=\"\",\"\",IF(J136<>\"\",IF(TestUPN(C136)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C136)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C137=\"\",\"\",IF(J137<>\"\",IF(TestUPN(C137)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C137)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C138=\"\",\"\",IF(J138<>\"\",IF(TestUPN(C138)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C138)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C139=\"\",\"\",IF(J139<>\"\",IF(TestUPN(C139)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C139)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C140=\"\",\"\",IF(J140<>\"\",IF(TestUPN(C140)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C140)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C141=\"\",\"\",IF(J141<>\"\",IF(TestUPN(C141)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C141)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C142=\"\",\"\",IF(J142<>\"\",IF(TestUPN(C142)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C142)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C143=\"\",\"\",IF(J143<>\"\",IF(TestUPN(C143)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C143)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C144=\"\",\"\",IF(J144<>\"\",IF(TestUPN(C144)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C144)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C145=\"\",\"\",IF(J145<>\"\",IF(TestUPN(C145)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C145)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C146=\"\",\"\",IF(J146<>\"\",IF(TestUPN(C146)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C146)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C147=\"\",\"\",IF(J147<>\"\",IF(TestUPN(C147)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C147)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C148=\"\",\"\",IF(J148<>\"\",IF(TestUPN(C148)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C148)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C149=\"\",\"\",IF(J149<>\"\",IF(TestUPN(C149)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C149)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C150=\"\",\"\",IF(J150<>\"\",IF(TestUPN(C150)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C150)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A150:F150)","v":false},{"$f":"IF(J150 = TRUE,(G150<>\"\") + (H150<>\"\"), \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C151=\"\",\"\",IF(J151<>\"\",IF(TestUPN(C151)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C151)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C152=\"\",\"\",IF(J152<>\"\",IF(TestUPN(C152)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C152)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C153=\"\",\"\",IF(J153<>\"\",IF(TestUPN(C153)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C153)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C154=\"\",\"\",IF(J154<>\"\",IF(TestUPN(C154)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C154)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C155=\"\",\"\",IF(J155<>\"\",IF(TestUPN(C155)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C155)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C156=\"\",\"\",IF(J156<>\"\",IF(TestUPN(C156)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C156)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C157=\"\",\"\",IF(J157<>\"\",IF(TestUPN(C157)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C157)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C158=\"\",\"\",IF(J158<>\"\",IF(TestUPN(C158)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C158)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C159=\"\",\"\",IF(J159<>\"\",IF(TestUPN(C159)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C159)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C160=\"\",\"\",IF(J160<>\"\",IF(TestUPN(C160)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C160)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C161=\"\",\"\",IF(J161<>\"\",IF(TestUPN(C161)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C161)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C162=\"\",\"\",IF(J162<>\"\",IF(TestUPN(C162)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C162)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C163=\"\",\"\",IF(J163<>\"\",IF(TestUPN(C163)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C163)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C164=\"\",\"\",IF(J164<>\"\",IF(TestUPN(C164)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C164)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C165=\"\",\"\",IF(J165<>\"\",IF(TestUPN(C165)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C165)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C166=\"\",\"\",IF(J166<>\"\",IF(TestUPN(C166)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C166)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C167=\"\",\"\",IF(J167<>\"\",IF(TestUPN(C167)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C167)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C168=\"\",\"\",IF(J168<>\"\",IF(TestUPN(C168)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C168)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C169=\"\",\"\",IF(J169<>\"\",IF(TestUPN(C169)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C169)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C170=\"\",\"\",IF(J170<>\"\",IF(TestUPN(C170)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C170)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C171=\"\",\"\",IF(J171<>\"\",IF(TestUPN(C171)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C171)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C172=\"\",\"\",IF(J172<>\"\",IF(TestUPN(C172)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C172)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C173=\"\",\"\",IF(J173<>\"\",IF(TestUPN(C173)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C173)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C174=\"\",\"\",IF(J174<>\"\",IF(TestUPN(C174)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C174)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C175=\"\",\"\",IF(J175<>\"\",IF(TestUPN(C175)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C175)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C176=\"\",\"\",IF(J176<>\"\",IF(TestUPN(C176)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C176)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C177=\"\",\"\",IF(J177<>\"\",IF(TestUPN(C177)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C177)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C178=\"\",\"\",IF(J178<>\"\",IF(TestUPN(C178)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C178)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C179=\"\",\"\",IF(J179<>\"\",IF(TestUPN(C179)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C179)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C180=\"\",\"\",IF(J180<>\"\",IF(TestUPN(C180)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C180)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C181=\"\",\"\",IF(J181<>\"\",IF(TestUPN(C181)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C181)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C182=\"\",\"\",IF(J182<>\"\",IF(TestUPN(C182)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C182)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C183=\"\",\"\",IF(J183<>\"\",IF(TestUPN(C183)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C183)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C184=\"\",\"\",IF(J184<>\"\",IF(TestUPN(C184)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C184)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C185=\"\",\"\",IF(J185<>\"\",IF(TestUPN(C185)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C185)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C186=\"\",\"\",IF(J186<>\"\",IF(TestUPN(C186)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C186)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C187=\"\",\"\",IF(J187<>\"\",IF(TestUPN(C187)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C187)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C188=\"\",\"\",IF(J188<>\"\",IF(TestUPN(C188)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C188)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C189=\"\",\"\",IF(J189<>\"\",IF(TestUPN(C189)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C189)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C190=\"\",\"\",IF(J190<>\"\",IF(TestUPN(C190)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C190)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C191=\"\",\"\",IF(J191<>\"\",IF(TestUPN(C191)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C191)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C192=\"\",\"\",IF(J192<>\"\",IF(TestUPN(C192)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C192)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C193=\"\",\"\",IF(J193<>\"\",IF(TestUPN(C193)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C193)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C194=\"\",\"\",IF(J194<>\"\",IF(TestUPN(C194)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C194)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C195=\"\",\"\",IF(J195<>\"\",IF(TestUPN(C195)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C195)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C196=\"\",\"\",IF(J196<>\"\",IF(TestUPN(C196)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C196)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C197=\"\",\"\",IF(J197<>\"\",IF(TestUPN(C197)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C197)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C198=\"\",\"\",IF(J198<>\"\",IF(TestUPN(C198)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C198)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C199=\"\",\"\",IF(J199<>\"\",IF(TestUPN(C199)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C199)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C200=\"\",\"\",IF(J200<>\"\",IF(TestUPN(C200)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C200)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C201=\"\",\"\",IF(J201<>\"\",IF(TestUPN(C201)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C201)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C202=\"\",\"\",IF(J202<>\"\",IF(TestUPN(C202)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C202)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C203=\"\",\"\",IF(J203<>\"\",IF(TestUPN(C203)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C203)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C204=\"\",\"\",IF(J204<>\"\",IF(TestUPN(C204)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C204)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C205=\"\",\"\",IF(J205<>\"\",IF(TestUPN(C205)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C205)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C206=\"\",\"\",IF(J206<>\"\",IF(TestUPN(C206)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C206)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C207=\"\",\"\",IF(J207<>\"\",IF(TestUPN(C207)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C207)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C208=\"\",\"\",IF(J208<>\"\",IF(TestUPN(C208)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C208)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C209=\"\",\"\",IF(J209<>\"\",IF(TestUPN(C209)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C209)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C210=\"\",\"\",IF(J210<>\"\",IF(TestUPN(C210)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C210)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C211=\"\",\"\",IF(J211<>\"\",IF(TestUPN(C211)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C211)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C212=\"\",\"\",IF(J212<>\"\",IF(TestUPN(C212)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C212)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C213=\"\",\"\",IF(J213<>\"\",IF(TestUPN(C213)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C213)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C214=\"\",\"\",IF(J214<>\"\",IF(TestUPN(C214)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C214)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A214:F214)","v":false},{"$f":"IF(J214 = TRUE,(G214<>\"\") + (H214<>\"\"), \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C215=\"\",\"\",IF(J215<>\"\",IF(TestUPN(C215)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C215)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C216=\"\",\"\",IF(J216<>\"\",IF(TestUPN(C216)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C216)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C217=\"\",\"\",IF(J217<>\"\",IF(TestUPN(C217)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C217)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C218=\"\",\"\",IF(J218<>\"\",IF(TestUPN(C218)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C218)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C219=\"\",\"\",IF(J219<>\"\",IF(TestUPN(C219)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C219)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C220=\"\",\"\",IF(J220<>\"\",IF(TestUPN(C220)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C220)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C221=\"\",\"\",IF(J221<>\"\",IF(TestUPN(C221)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C221)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C222=\"\",\"\",IF(J222<>\"\",IF(TestUPN(C222)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C222)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C223=\"\",\"\",IF(J223<>\"\",IF(TestUPN(C223)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C223)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C224=\"\",\"\",IF(J224<>\"\",IF(TestUPN(C224)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C224)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C225=\"\",\"\",IF(J225<>\"\",IF(TestUPN(C225)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C225)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C226=\"\",\"\",IF(J226<>\"\",IF(TestUPN(C226)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C226)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C227=\"\",\"\",IF(J227<>\"\",IF(TestUPN(C227)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C227)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C228=\"\",\"\",IF(J228<>\"\",IF(TestUPN(C228)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C228)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C229=\"\",\"\",IF(J229<>\"\",IF(TestUPN(C229)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C229)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C230=\"\",\"\",IF(J230<>\"\",IF(TestUPN(C230)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C230)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C231=\"\",\"\",IF(J231<>\"\",IF(TestUPN(C231)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C231)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C232=\"\",\"\",IF(J232<>\"\",IF(TestUPN(C232)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C232)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C233=\"\",\"\",IF(J233<>\"\",IF(TestUPN(C233)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C233)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C234=\"\",\"\",IF(J234<>\"\",IF(TestUPN(C234)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C234)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C235=\"\",\"\",IF(J235<>\"\",IF(TestUPN(C235)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C235)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C236=\"\",\"\",IF(J236<>\"\",IF(TestUPN(C236)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C236)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C237=\"\",\"\",IF(J237<>\"\",IF(TestUPN(C237)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C237)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C238=\"\",\"\",IF(J238<>\"\",IF(TestUPN(C238)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C238)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C239=\"\",\"\",IF(J239<>\"\",IF(TestUPN(C239)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C239)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C240=\"\",\"\",IF(J240<>\"\",IF(TestUPN(C240)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C240)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C241=\"\",\"\",IF(J241<>\"\",IF(TestUPN(C241)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C241)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C242=\"\",\"\",IF(J242<>\"\",IF(TestUPN(C242)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C242)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C243=\"\",\"\",IF(J243<>\"\",IF(TestUPN(C243)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C243)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C244=\"\",\"\",IF(J244<>\"\",IF(TestUPN(C244)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C244)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C245=\"\",\"\",IF(J245<>\"\",IF(TestUPN(C245)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C245)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C246=\"\",\"\",IF(J246<>\"\",IF(TestUPN(C246)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C246)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C247=\"\",\"\",IF(J247<>\"\",IF(TestUPN(C247)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C247)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C248=\"\",\"\",IF(J248<>\"\",IF(TestUPN(C248)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C248)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C249=\"\",\"\",IF(J249<>\"\",IF(TestUPN(C249)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C249)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C250=\"\",\"\",IF(J250<>\"\",IF(TestUPN(C250)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C250)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C251=\"\",\"\",IF(J251<>\"\",IF(TestUPN(C251)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C251)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C252=\"\",\"\",IF(J252<>\"\",IF(TestUPN(C252)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C252)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C253=\"\",\"\",IF(J253<>\"\",IF(TestUPN(C253)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C253)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C254=\"\",\"\",IF(J254<>\"\",IF(TestUPN(C254)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C254)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C255=\"\",\"\",IF(J255<>\"\",IF(TestUPN(C255)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C255)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C256=\"\",\"\",IF(J256<>\"\",IF(TestUPN(C256)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C256)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C257=\"\",\"\",IF(J257<>\"\",IF(TestUPN(C257)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C257)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C258=\"\",\"\",IF(J258<>\"\",IF(TestUPN(C258)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C258)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C259=\"\",\"\",IF(J259<>\"\",IF(TestUPN(C259)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C259)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C260=\"\",\"\",IF(J260<>\"\",IF(TestUPN(C260)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C260)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C261=\"\",\"\",IF(J261<>\"\",IF(TestUPN(C261)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C261)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C262=\"\",\"\",IF(J262<>\"\",IF(TestUPN(C262)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C262)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C263=\"\",\"\",IF(J263<>\"\",IF(TestUPN(C263)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C263)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C264=\"\",\"\",IF(J264<>\"\",IF(TestUPN(C264)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C264)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C265=\"\",\"\",IF(J265<>\"\",IF(TestUPN(C265)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C265)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C266=\"\",\"\",IF(J266<>\"\",IF(TestUPN(C266)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C266)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C267=\"\",\"\",IF(J267<>\"\",IF(TestUPN(C267)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C267)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C268=\"\",\"\",IF(J268<>\"\",IF(TestUPN(C268)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C268)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C269=\"\",\"\",IF(J269<>\"\",IF(TestUPN(C269)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C269)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]
[null,null,null,null,null,null,null,null,{"$f":"IF(C270=\"\",\"\",IF(J270<>\"\",IF(TestUPN(C270)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$270, C270)>1,\"Duplicate UPN\",\"\"))))","v":""},false,""]

{"sheet":"Reference","index":1,"n_rows":154,"n_cols":7,"rows_kept":154,"cut":false,"hidden":true,"merged":[[1,5,1,6],[0,2,0,3],[0,5,0,6]]}
[201,null,"Lookup Tables",null,null,"Lookup Table2"]
[202,null,"looknums","lookletters",null,"looklet2"]
[203,null,0,"A",null,"A",0]
[204,null,1,"B",null,"B",1]
[205,null,2,"C",null,"C",2]
[206,null,3,"D",null,"D",3]
[207,null,4,"E",null,"E",4]
[208,null,5,"F",null,"F",5]
[209,null,6,"G",null,"G",6]
[210,null,7,"H",null,"H",7]
[211,null,8,"J",null,"J",8]
[212,null,9,"K",null,"K",9]
[213,null,10,"L",null,"L",10]
[301,null,11,"M",null,"M",11]
[302,null,12,"N",null,"N",12]
[303,null,13,"P",null,"P",13]
[304,null,14,"Q",null,"Q",14]
[305,null,15,"R",null,"R",15]
[306,null,16,"T",null,"T",16]
[307,null,17,"U",null,"U",17]
[308,null,18,"V",null,"V",18]
[309,null,19,"W",null,"W",19]
[310,null,20,"X",null,"X",20]
[311,null,21,"Y",null,"Y",21]
[312,null,22,"Z",null,"Z",22]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[340]
[341]
[342]
[343]
[344]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[370]
[371]
[372]
[373]
[380]
[381]
[382]
[383]
[384]
[390]
[391]
[392]
[393]
[394]
[420]
[702]
[800]
[801]
[802]
[803]
[805]
[806]
[807]
[808]
[810]
[811]
[812]
[813]
[815]
[816]
[821]
[822]
[823]
[825]
[826]
[830]
[831]
[838]
[839]
[840]
[841]
[845]
[846]
[850]
[851]
[852]
[855]
[856]
[857]
[860]
[861]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[908]
[916]
[919]
[921]
[925]
[926]
[929]
[931]
[933]
[935]
[936]
[937]
[938]
[940]
[941]
[942]
[943]