{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["InputSheet","PVIs 2023","Reference"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":1,"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":"InputSheet","index":0,"n_rows":170,"n_cols":28,"rows_kept":170,"cut":false,"hidden":false,"merged":[[18,1,19,1],[18,0,19,0],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,2,19,2],[18,6,18,7],[18,8,18,10],[18,11,18,12],[18,13,18,15],[18,21,18,22],[18,16,18,17],[18,18,18,20]]}
["2023 EARLY YEARS FOUNDATION STAGE PROFILE SPREADSHEET"]
["1.  Enter school/setting identification details in the boxes below:"]
[]
["    Name of school or setting *","Select Seting Name…...."]
["    Local Authority No.",320]
["    Estab No (LA schools / academies / independent schools)"]
["    URN (independent  schools/ PVI settings only)",{"$f":"IFERROR(VLOOKUP(B4,'PVIs 2023'!A:D,4,FALSE),\"TYPE URN HERE\")","v":""}]
["                * Do not enter commas in the school name"]
["2.  Starting at row 21 and using a new row for each child, enter his/her",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Missing scores",{"$f":"(17*150)-COUNT($G$21:$W$21)","v":2550}]
["      identifying details and Foundation Stage Profile assessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pupils",{"$f":"COUNTIF($Z$21:$Z$170,TRUE)","v":0}]
["      judgement rating in the appropriate boxes.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surnames",{"$f":"COUNTA($A$21:$A$170)","v":0}]
["3.  You can use drop-down menus for Gender and score entries. 1 = Emerging, 2= Expected, A= An exemption applies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forenames",{"$f":"COUNTA($B$21:$B$170)","v":0}]
["4.  Using keyboard tab key will move the cursor to next box or next row. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gender",{"$f":"COUNTA($D$21:$D$170)","v":0}]
["5. When all entries are complete, save / back up the worksheet then click                 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dates of Birth",{"$f":"COUNTA($E$21:$E$170)","v":0}]
["       to create a CSV export file and send to your Local Authority as directed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Postcodes",{"$f":"COUNTA($F$21:$F$170)","v":0}]
[]
["6.   See guidance notes for further instructions as directed."]
[null,null,null,null,null,null,"ASSESSMENT JUDGEMENT RATINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Missing"]
["Child's Surname ","Child's Forename","UPN","Gender\nF / M","Date of Birth\n(DD/MM/YYYY)","Home Postcode","Communication and language ",null,"Personal, social and emotional development ",null,null,"Physical Development ",null,"Literacy",null,null,"Mathematics",null,"Understanding the world ",null,null,"Expressive arts and design",null,"Judgement",null,"Data-entry"]
[null,null,null,null,null,null,"LAU","S","SR","MS","BR","GMS","FMS","C","WR","W","N","NP","P and P","PCC","NW","CWW","BIE","Ratings","UPN check","string"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z21,COUNTIF(G21:W21,\"\"), 0)","v":0},{"$f":"IF(NOT(Z21),\"\",IF(C21=\"\", \"Missing\", IF(TestUPN(C21)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C21)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A21:W21)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z22),\"\",IF(C22=\"\", \"Missing\", IF(TestUPN(C22)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C22)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z23),\"\",IF(C23=\"\", \"Missing\", IF(TestUPN(C23)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C23)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z24),\"\",IF(C24=\"\", \"Missing\", IF(TestUPN(C24)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C24)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z25),\"\",IF(C25=\"\", \"Missing\", IF(TestUPN(C25)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C25)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z26),\"\",IF(C26=\"\", \"Missing\", IF(TestUPN(C26)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C26)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z27),\"\",IF(C27=\"\", \"Missing\", IF(TestUPN(C27)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C27)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z28),\"\",IF(C28=\"\", \"Missing\", IF(TestUPN(C28)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C28)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z29),\"\",IF(C29=\"\", \"Missing\", IF(TestUPN(C29)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C29)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z30),\"\",IF(C30=\"\", \"Missing\", IF(TestUPN(C30)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C30)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z31),\"\",IF(C31=\"\", \"Missing\", IF(TestUPN(C31)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C31)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z32),\"\",IF(C32=\"\", \"Missing\", IF(TestUPN(C32)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C32)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z33),\"\",IF(C33=\"\", \"Missing\", IF(TestUPN(C33)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C33)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z34),\"\",IF(C34=\"\", \"Missing\", IF(TestUPN(C34)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C34)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z35),\"\",IF(C35=\"\", \"Missing\", IF(TestUPN(C35)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C35)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z36),\"\",IF(C36=\"\", \"Missing\", IF(TestUPN(C36)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C36)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z37),\"\",IF(C37=\"\", \"Missing\", IF(TestUPN(C37)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C37)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z38),\"\",IF(C38=\"\", \"Missing\", IF(TestUPN(C38)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C38)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z39),\"\",IF(C39=\"\", \"Missing\", IF(TestUPN(C39)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C39)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z40),\"\",IF(C40=\"\", \"Missing\", IF(TestUPN(C40)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C40)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z41),\"\",IF(C41=\"\", \"Missing\", IF(TestUPN(C41)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C41)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z42),\"\",IF(C42=\"\", \"Missing\", IF(TestUPN(C42)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C42)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z43),\"\",IF(C43=\"\", \"Missing\", IF(TestUPN(C43)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C43)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z44),\"\",IF(C44=\"\", \"Missing\", IF(TestUPN(C44)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C44)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z45),\"\",IF(C45=\"\", \"Missing\", IF(TestUPN(C45)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C45)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z46),\"\",IF(C46=\"\", \"Missing\", IF(TestUPN(C46)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C46)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z47),\"\",IF(C47=\"\", \"Missing\", IF(TestUPN(C47)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C47)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z48),\"\",IF(C48=\"\", \"Missing\", IF(TestUPN(C48)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C48)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z49),\"\",IF(C49=\"\", \"Missing\", IF(TestUPN(C49)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C49)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z50),\"\",IF(C50=\"\", \"Missing\", IF(TestUPN(C50)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C50)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z51),\"\",IF(C51=\"\", \"Missing\", IF(TestUPN(C51)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C51)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z52),\"\",IF(C52=\"\", \"Missing\", IF(TestUPN(C52)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C52)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z53,COUNTIF(G53:W53,\"\"), 0)","v":0},{"$f":"IF(NOT(Z53),\"\",IF(C53=\"\", \"Missing\", IF(TestUPN(C53)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C53)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A53:W53)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z54),\"\",IF(C54=\"\", \"Missing\", IF(TestUPN(C54)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C54)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z55),\"\",IF(C55=\"\", \"Missing\", IF(TestUPN(C55)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C55)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z56),\"\",IF(C56=\"\", \"Missing\", IF(TestUPN(C56)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C56)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z57),\"\",IF(C57=\"\", \"Missing\", IF(TestUPN(C57)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C57)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z58),\"\",IF(C58=\"\", \"Missing\", IF(TestUPN(C58)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C58)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z59),\"\",IF(C59=\"\", \"Missing\", IF(TestUPN(C59)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C59)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z60),\"\",IF(C60=\"\", \"Missing\", IF(TestUPN(C60)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C60)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z61),\"\",IF(C61=\"\", \"Missing\", IF(TestUPN(C61)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C61)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z62),\"\",IF(C62=\"\", \"Missing\", IF(TestUPN(C62)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C62)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z63),\"\",IF(C63=\"\", \"Missing\", IF(TestUPN(C63)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C63)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z64),\"\",IF(C64=\"\", \"Missing\", IF(TestUPN(C64)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C64)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z65),\"\",IF(C65=\"\", \"Missing\", IF(TestUPN(C65)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C65)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z66),\"\",IF(C66=\"\", \"Missing\", IF(TestUPN(C66)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C66)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z67),\"\",IF(C67=\"\", \"Missing\", IF(TestUPN(C67)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C67)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z68),\"\",IF(C68=\"\", \"Missing\", IF(TestUPN(C68)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C68)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z69),\"\",IF(C69=\"\", \"Missing\", IF(TestUPN(C69)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C69)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z70),\"\",IF(C70=\"\", \"Missing\", IF(TestUPN(C70)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C70)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z71),\"\",IF(C71=\"\", \"Missing\", IF(TestUPN(C71)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C71)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z72),\"\",IF(C72=\"\", \"Missing\", IF(TestUPN(C72)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C72)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z73),\"\",IF(C73=\"\", \"Missing\", IF(TestUPN(C73)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C73)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z74),\"\",IF(C74=\"\", \"Missing\", IF(TestUPN(C74)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C74)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z75),\"\",IF(C75=\"\", \"Missing\", IF(TestUPN(C75)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C75)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z76),\"\",IF(C76=\"\", \"Missing\", IF(TestUPN(C76)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C76)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z77),\"\",IF(C77=\"\", \"Missing\", IF(TestUPN(C77)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C77)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z78),\"\",IF(C78=\"\", \"Missing\", IF(TestUPN(C78)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C78)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z79),\"\",IF(C79=\"\", \"Missing\", IF(TestUPN(C79)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C79)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z80),\"\",IF(C80=\"\", \"Missing\", IF(TestUPN(C80)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C80)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z81),\"\",IF(C81=\"\", \"Missing\", IF(TestUPN(C81)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C81)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z82),\"\",IF(C82=\"\", \"Missing\", IF(TestUPN(C82)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C82)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z83),\"\",IF(C83=\"\", \"Missing\", IF(TestUPN(C83)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C83)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z84),\"\",IF(C84=\"\", \"Missing\", IF(TestUPN(C84)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C84)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z85,COUNTIF(G85:W85,\"\"), 0)","v":0},{"$f":"IF(NOT(Z85),\"\",IF(C85=\"\", \"Missing\", IF(TestUPN(C85)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C85)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A85:W85)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z86),\"\",IF(C86=\"\", \"Missing\", IF(TestUPN(C86)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C86)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z87),\"\",IF(C87=\"\", \"Missing\", IF(TestUPN(C87)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C87)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z88),\"\",IF(C88=\"\", \"Missing\", IF(TestUPN(C88)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C88)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z89),\"\",IF(C89=\"\", \"Missing\", IF(TestUPN(C89)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C89)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z90),\"\",IF(C90=\"\", \"Missing\", IF(TestUPN(C90)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C90)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z91),\"\",IF(C91=\"\", \"Missing\", IF(TestUPN(C91)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C91)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z92),\"\",IF(C92=\"\", \"Missing\", IF(TestUPN(C92)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C92)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z93),\"\",IF(C93=\"\", \"Missing\", IF(TestUPN(C93)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C93)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z94),\"\",IF(C94=\"\", \"Missing\", IF(TestUPN(C94)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C94)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z95),\"\",IF(C95=\"\", \"Missing\", IF(TestUPN(C95)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C95)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z96),\"\",IF(C96=\"\", \"Missing\", IF(TestUPN(C96)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C96)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z97),\"\",IF(C97=\"\", \"Missing\", IF(TestUPN(C97)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C97)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z98),\"\",IF(C98=\"\", \"Missing\", IF(TestUPN(C98)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C98)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z99),\"\",IF(C99=\"\", \"Missing\", IF(TestUPN(C99)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C99)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z100),\"\",IF(C100=\"\", \"Missing\", IF(TestUPN(C100)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C100)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z101),\"\",IF(C101=\"\", \"Missing\", IF(TestUPN(C101)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C101)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z102),\"\",IF(C102=\"\", \"Missing\", IF(TestUPN(C102)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C102)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z103),\"\",IF(C103=\"\", \"Missing\", IF(TestUPN(C103)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C103)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z104),\"\",IF(C104=\"\", \"Missing\", IF(TestUPN(C104)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C104)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z105),\"\",IF(C105=\"\", \"Missing\", IF(TestUPN(C105)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C105)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z106),\"\",IF(C106=\"\", \"Missing\", IF(TestUPN(C106)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C106)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z107),\"\",IF(C107=\"\", \"Missing\", IF(TestUPN(C107)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C107)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z108),\"\",IF(C108=\"\", \"Missing\", IF(TestUPN(C108)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C108)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z109),\"\",IF(C109=\"\", \"Missing\", IF(TestUPN(C109)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C109)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z110),\"\",IF(C110=\"\", \"Missing\", IF(TestUPN(C110)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C110)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z111),\"\",IF(C111=\"\", \"Missing\", IF(TestUPN(C111)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C111)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z112),\"\",IF(C112=\"\", \"Missing\", IF(TestUPN(C112)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C112)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z113),\"\",IF(C113=\"\", \"Missing\", IF(TestUPN(C113)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C113)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z114),\"\",IF(C114=\"\", \"Missing\", IF(TestUPN(C114)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C114)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z115),\"\",IF(C115=\"\", \"Missing\", IF(TestUPN(C115)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C115)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z116),\"\",IF(C116=\"\", \"Missing\", IF(TestUPN(C116)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C116)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z117,COUNTIF(G117:W117,\"\"), 0)","v":0},{"$f":"IF(NOT(Z117),\"\",IF(C117=\"\", \"Missing\", IF(TestUPN(C117)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C117)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A117:W117)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z118),\"\",IF(C118=\"\", \"Missing\", IF(TestUPN(C118)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C118)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z119),\"\",IF(C119=\"\", \"Missing\", IF(TestUPN(C119)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C119)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z120),\"\",IF(C120=\"\", \"Missing\", IF(TestUPN(C120)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C120)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z121),\"\",IF(C121=\"\", \"Missing\", IF(TestUPN(C121)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C121)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z122),\"\",IF(C122=\"\", \"Missing\", IF(TestUPN(C122)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C122)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z123),\"\",IF(C123=\"\", \"Missing\", IF(TestUPN(C123)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C123)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z124),\"\",IF(C124=\"\", \"Missing\", IF(TestUPN(C124)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C124)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z125),\"\",IF(C125=\"\", \"Missing\", IF(TestUPN(C125)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C125)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z126),\"\",IF(C126=\"\", \"Missing\", IF(TestUPN(C126)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C126)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z127),\"\",IF(C127=\"\", \"Missing\", IF(TestUPN(C127)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C127)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z128),\"\",IF(C128=\"\", \"Missing\", IF(TestUPN(C128)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C128)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z129),\"\",IF(C129=\"\", \"Missing\", IF(TestUPN(C129)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C129)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z130),\"\",IF(C130=\"\", \"Missing\", IF(TestUPN(C130)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C130)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z131),\"\",IF(C131=\"\", \"Missing\", IF(TestUPN(C131)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C131)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z132),\"\",IF(C132=\"\", \"Missing\", IF(TestUPN(C132)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C132)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z133),\"\",IF(C133=\"\", \"Missing\", IF(TestUPN(C133)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C133)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z134),\"\",IF(C134=\"\", \"Missing\", IF(TestUPN(C134)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C134)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z135),\"\",IF(C135=\"\", \"Missing\", IF(TestUPN(C135)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C135)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z136),\"\",IF(C136=\"\", \"Missing\", IF(TestUPN(C136)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C136)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z137),\"\",IF(C137=\"\", \"Missing\", IF(TestUPN(C137)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C137)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z138),\"\",IF(C138=\"\", \"Missing\", IF(TestUPN(C138)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C138)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z139),\"\",IF(C139=\"\", \"Missing\", IF(TestUPN(C139)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C139)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z140),\"\",IF(C140=\"\", \"Missing\", IF(TestUPN(C140)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C140)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z141),\"\",IF(C141=\"\", \"Missing\", IF(TestUPN(C141)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C141)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z142),\"\",IF(C142=\"\", \"Missing\", IF(TestUPN(C142)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C142)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z143),\"\",IF(C143=\"\", \"Missing\", IF(TestUPN(C143)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C143)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z144),\"\",IF(C144=\"\", \"Missing\", IF(TestUPN(C144)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C144)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z145),\"\",IF(C145=\"\", \"Missing\", IF(TestUPN(C145)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C145)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z146),\"\",IF(C146=\"\", \"Missing\", IF(TestUPN(C146)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C146)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z147),\"\",IF(C147=\"\", \"Missing\", IF(TestUPN(C147)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C147)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z148),\"\",IF(C148=\"\", \"Missing\", IF(TestUPN(C148)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C148)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z149,COUNTIF(G149:W149,\"\"), 0)","v":0},{"$f":"IF(NOT(Z149),\"\",IF(C149=\"\", \"Missing\", IF(TestUPN(C149)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C149)>1,\"Duplicate UPN\",\"\"))))","v":""},{"$f":"RangeHasText(A149:W149)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z150),\"\",IF(C150=\"\", \"Missing\", IF(TestUPN(C150)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C150)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z151),\"\",IF(C151=\"\", \"Missing\", IF(TestUPN(C151)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C151)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z152),\"\",IF(C152=\"\", \"Missing\", IF(TestUPN(C152)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C152)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z153),\"\",IF(C153=\"\", \"Missing\", IF(TestUPN(C153)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C153)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z154),\"\",IF(C154=\"\", \"Missing\", IF(TestUPN(C154)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C154)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z155),\"\",IF(C155=\"\", \"Missing\", IF(TestUPN(C155)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C155)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z156),\"\",IF(C156=\"\", \"Missing\", IF(TestUPN(C156)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C156)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z157),\"\",IF(C157=\"\", \"Missing\", IF(TestUPN(C157)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C157)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z158),\"\",IF(C158=\"\", \"Missing\", IF(TestUPN(C158)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C158)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z159),\"\",IF(C159=\"\", \"Missing\", IF(TestUPN(C159)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C159)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z160),\"\",IF(C160=\"\", \"Missing\", IF(TestUPN(C160)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C160)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z161),\"\",IF(C161=\"\", \"Missing\", IF(TestUPN(C161)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C161)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z162),\"\",IF(C162=\"\", \"Missing\", IF(TestUPN(C162)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C162)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z163),\"\",IF(C163=\"\", \"Missing\", IF(TestUPN(C163)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C163)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z164),\"\",IF(C164=\"\", \"Missing\", IF(TestUPN(C164)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C164)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z165),\"\",IF(C165=\"\", \"Missing\", IF(TestUPN(C165)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C165)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z166),\"\",IF(C166=\"\", \"Missing\", IF(TestUPN(C166)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C166)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z167),\"\",IF(C167=\"\", \"Missing\", IF(TestUPN(C167)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C167)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z168),\"\",IF(C168=\"\", \"Missing\", IF(TestUPN(C168)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C168)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z169),\"\",IF(C169=\"\", \"Missing\", IF(TestUPN(C169)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C169)>1,\"Duplicate UPN\",\"\"))))","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(Z170),\"\",IF(C170=\"\", \"Missing\", IF(TestUPN(C170)=FALSE,\"Invalid UPN\",IF(COUNTIF($C$21:$C$21, C170)>1,\"Duplicate UPN\",\"\"))))","v":""},false]

{"sheet":"PVIs 2023","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Setting Name","LA","Estab","URN"]
["Select Seting Name…....",null,null,""]
["AZHAR ACADEMY PRIMARY SCHOOL",320,null,613324]
["CALVARY PRE-SCHOOL",320,null,613067]
["EXCEL KIDS DAY NURSERY",320,null,583247]
["LITTLE LEARNERS NURSERY: ST SAVIOUR'S",320,null,613266]
["NOAH'S ARK COMMUNITY PRESCHOOL",320,null,613341]
["NOOR UL ISLAM PRE-SCHOOL",320,null,533328]
["NOOR UL ISLAM PRIMARY",320,null,613321]
["NORMANHURST SCHOOL",320,null,510284]
["ST ANDREWS PRE-SCHOOL HIGHAM HILL",320,null,530062]
["TENDER CUBS PRE-SCHOOL AND DAY NURSERY",320,null,713102]
["THE CORNERSTONE PRE-SCHOOL",320,null,530352]
["THE LLOYD PARK CENTRE",320,null,520766]
["THE VILLAGE PRE-SCHOOL E17",320,null,530354]
["TINY TOTS DAY NURSERY",320,null,533319]
["UNIQUE CHILD MONTESSORI NURSERY",320,null,713098]
["WALTHAMSTOW MONTESSORI SCHOOL",320,null,533340]

{"sheet":"Reference","index":2,"n_rows":159,"n_cols":7,"rows_kept":159,"cut":false,"hidden":true,"merged":[[0,2,0,3],[1,5,1,6],[0,5,0,6]]}
["LA Numbers",null,"Lookup Tables",null,null,"Lookup Table2"]
[201,null,"looknums","lookletters",null,"looklet2"]
[202,null,0,"A",null,"A",0]
[203,null,1,"B",null,"B",1]
[204,null,2,"C",null,"C",2]
[205,null,3,"D",null,"D",3]
[206,null,4,"E",null,"E",4]
[207,null,5,"F",null,"F",5]
[208,null,6,"G",null,"G",6]
[209,null,7,"H",null,"H",7]
[210,null,8,"J",null,"J",8]
[211,null,9,"K",null,"K",9]
[212,null,10,"L",null,"L",10]
[213,null,11,"M",null,"M",11]
[301,null,12,"N",null,"N",12]
[302,null,13,"P",null,"P",13]
[303,null,14,"Q",null,"Q",14]
[304,null,15,"R",null,"R",15]
[305,null,16,"T",null,"T",16]
[306,null,17,"U",null,"U",17]
[307,null,18,"V",null,"V",18]
[308,null,19,"W",null,"W",19]
[309,null,20,"X",null,"X",20]
[310,null,21,"Y",null,"Y",21]
[311,null,22,"Z",null,"Z",22]
[312]
[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]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[845]
[846]
[850]
[851]
[852]
[855]
[856]
[857]
[860]
[861]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[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]