{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Development of Gaps","Teacher Hiring Funnel","Accountability Score Entry","Accountability Score Results","Subject"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Development of Gaps","index":0,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,"All Teachers","SPED","Percent Change For All Teachers",{"$f":"\"Percent Change for \" & CHAR(10) & D1 & \" Teachers\"","v":"Percent Change for \nSPED Teachers"},"# Gap","Percent Retained All Teachers",{"$f":"\"Percent Retained\" & CHAR(10) & D1 & \" Teachers\"","v":"Percent Retained\nSPED Teachers"},"% Retained Gap","Change"]
[null,"Teacher Preparation Program Applied",null,null,null,null,{"$f":"IF(OR(C2=\"\",D2=\"\"),\"\",C2-D2)","v":""},{"$f":"IF(AND(ISNUMBER(C2),ISNUMBER(D2)),1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(C2),ISNUMBER(D2)),1,\"\")","v":""},{"$f":"IF(OR(I2=\"\",H2=\"\"),\"\",(H2-I2))","v":""}]
[null,"Teacher Preparation Program Admitted",null,null,{"$f":"IF(C3=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C2),$C$2:C2)),(C3-LOOKUP(2,1/ISNUMBER($C$2:C2),$C$2:C2))/LOOKUP(2,1/ISNUMBER($C$2:C2),$C$2:C2),\"\"))","v":""},{"$f":"IF(D3=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D2),$D$2:D2)),(D3-LOOKUP(2,1/ISNUMBER($D$2:D2),$D$2:D2))/LOOKUP(2,1/ISNUMBER($D$2:D2),$D$2:D2),\"\"))","v":""},"",{"$f":"IF(AND(ISNUMBER(C3),$C$2<>0),C3/$C$2,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D3),$D$2<>0),D3/$D$2,\"\")","v":""},"",{"$f":"IF(J3=0,0,IF(J3=\"\",\"\",(J3-LOOKUP(2,1/ISNUMBER($J$2:J2),$J$2:J2))))","v":""}]
[null,"Teacher Preparation Program Enrollment",null,null,{"$f":"IF(C4=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C3),$C$2:C3)),(C4-LOOKUP(2,1/ISNUMBER($C$2:C3),$C$2:C3))/LOOKUP(2,1/ISNUMBER($C$2:C3),$C$2:C3),\"\"))","v":""},{"$f":"IF(D4=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D3),$D$2:D3)),(D4-LOOKUP(2,1/ISNUMBER($D$2:D3),$D$2:D3))/LOOKUP(2,1/ISNUMBER($D$2:D3),$D$2:D3),\"\"))","v":""},{"$f":"IF(OR(C4=\"\",D4=\"\"),\"\",C4-D4)","v":""},{"$f":"IF(AND(ISNUMBER(C4),$C$2<>0),C4/$C$2,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D4),$D$2<>0),D4/$D$2,\"\")","v":""},"",{"$f":"IF(J4=0,0,IF(J4=\"\",\"\",(J4-LOOKUP(2,1/ISNUMBER($J$2:J3),$J$2:J3))))","v":""}]
[null,"Education Degree Conferred",null,null,{"$f":"IF(C5=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C4),$C$2:C4)),(C5-LOOKUP(2,1/ISNUMBER($C$2:C4),$C$2:C4))/LOOKUP(2,1/ISNUMBER($C$2:C4),$C$2:C4),\"\"))","v":""},{"$f":"IF(D5=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D4),$D$2:D4)),(D5-LOOKUP(2,1/ISNUMBER($D$2:D4),$D$2:D4))/LOOKUP(2,1/ISNUMBER($D$2:D4),$D$2:D4),\"\"))","v":""},"","","","",{"$f":"IF(J5=0,0,IF(J5=\"\",\"\",(J5-LOOKUP(2,1/ISNUMBER($J$2:J4),$J$2:J4))))","v":""}]
[null,"Pass State Licensure Test",null,null,{"$f":"IF(C6=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C5),$C$2:C5)),(C6-LOOKUP(2,1/ISNUMBER($C$2:C5),$C$2:C5))/LOOKUP(2,1/ISNUMBER($C$2:C5),$C$2:C5),\"\"))","v":""},{"$f":"IF(D6=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D5),$D$2:D5)),(D6-LOOKUP(2,1/ISNUMBER($D$2:D5),$D$2:D5))/LOOKUP(2,1/ISNUMBER($D$2:D5),$D$2:D5),\"\"))","v":""},"","","","",{"$f":"IF(J6=0,0,IF(J6=\"\",\"\",(J6-LOOKUP(2,1/ISNUMBER($J$2:J5),$J$2:J5))))","v":""}]
[null,"Certified",null,null,{"$f":"IF(C7=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C6),$C$2:C6)),(C7-LOOKUP(2,1/ISNUMBER($C$2:C6),$C$2:C6))/LOOKUP(2,1/ISNUMBER($C$2:C6),$C$2:C6),\"\"))","v":""},{"$f":"IF(D7=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D6),$D$2:D6)),(D7-LOOKUP(2,1/ISNUMBER($D$2:D6),$D$2:D6))/LOOKUP(2,1/ISNUMBER($D$2:D6),$D$2:D6),\"\"))","v":""},"","","","",{"$f":"IF(J7=0,0,IF(J7=\"\",\"\",(J7-LOOKUP(2,1/ISNUMBER($J$2:J6),$J$2:J6))))","v":""}]
[null,"Submitting Applications",null,null,{"$f":"IF(C8=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C7),$C$2:C7)),(C8-LOOKUP(2,1/ISNUMBER($C$2:C7),$C$2:C7))/LOOKUP(2,1/ISNUMBER($C$2:C7),$C$2:C7),\"\"))","v":""},{"$f":"IF(D8=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D7),$D$2:D7)),(D8-LOOKUP(2,1/ISNUMBER($D$2:D7),$D$2:D7))/LOOKUP(2,1/ISNUMBER($D$2:D7),$D$2:D7),\"\"))","v":""},"","","","",{"$f":"IF(J8=0,0,IF(J8=\"\",\"\",(J8-LOOKUP(2,1/ISNUMBER($J$2:J7),$J$2:J7))))","v":""}]
[null,"Passing Initial Screening",null,null,{"$f":"IF(C9=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C8),$C$2:C8)),(C9-LOOKUP(2,1/ISNUMBER($C$2:C8),$C$2:C8))/LOOKUP(2,1/ISNUMBER($C$2:C8),$C$2:C8),\"\"))","v":""},{"$f":"IF(D9=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D8),$D$2:D8)),(D9-LOOKUP(2,1/ISNUMBER($D$2:D8),$D$2:D8))/LOOKUP(2,1/ISNUMBER($D$2:D8),$D$2:D8),\"\"))","v":""},"","","","",{"$f":"IF(J9=0,0,IF(J9=\"\",\"\",(J9-LOOKUP(2,1/ISNUMBER($J$2:J8),$J$2:J8))))","v":""}]
[null,"Participating in District Interviews",null,null,{"$f":"IF(C10=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C9),$C$2:C9)),(C10-LOOKUP(2,1/ISNUMBER($C$2:C9),$C$2:C9))/LOOKUP(2,1/ISNUMBER($C$2:C9),$C$2:C9),\"\"))","v":""},{"$f":"IF(D10=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D9),$D$2:D9)),(D10-LOOKUP(2,1/ISNUMBER($D$2:D9),$D$2:D9))/LOOKUP(2,1/ISNUMBER($D$2:D9),$D$2:D9),\"\"))","v":""},"","","","",{"$f":"IF(J10=0,0,IF(J10=\"\",\"\",(J10-LOOKUP(2,1/ISNUMBER($J$2:J9),$J$2:J9))))","v":""}]
[null,"Participating in School Interviews",null,null,{"$f":"IF(C11=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C10),$C$2:C10)),(C11-LOOKUP(2,1/ISNUMBER($C$2:C10),$C$2:C10))/LOOKUP(2,1/ISNUMBER($C$2:C10),$C$2:C10),\"\"))","v":""},{"$f":"IF(D11=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D10),$D$2:D10)),(D11-LOOKUP(2,1/ISNUMBER($D$2:D10),$D$2:D10))/LOOKUP(2,1/ISNUMBER($D$2:D10),$D$2:D10),\"\"))","v":""},"","","","",{"$f":"IF(J11=0,0,IF(J11=\"\",\"\",(J11-LOOKUP(2,1/ISNUMBER($J$2:J10),$J$2:J10))))","v":""}]
[null,"Selected",null,null,{"$f":"IF(C12=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C11),$C$2:C11)),(C12-LOOKUP(2,1/ISNUMBER($C$2:C11),$C$2:C11))/LOOKUP(2,1/ISNUMBER($C$2:C11),$C$2:C11),\"\"))","v":""},{"$f":"IF(D12=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D11),$D$2:D11)),(D12-LOOKUP(2,1/ISNUMBER($D$2:D11),$D$2:D11))/LOOKUP(2,1/ISNUMBER($D$2:D11),$D$2:D11),\"\"))","v":""},"","","","",{"$f":"IF(J12=0,0,IF(J12=\"\",\"\",(J12-LOOKUP(2,1/ISNUMBER($J$2:J11),$J$2:J11))))","v":""}]
[null,"Accepted Offer",null,null,{"$f":"IF(C13=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C12),$C$2:C12)),(C13-LOOKUP(2,1/ISNUMBER($C$2:C12),$C$2:C12))/LOOKUP(2,1/ISNUMBER($C$2:C12),$C$2:C12),\"\"))","v":""},{"$f":"IF(D13=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D12),$D$2:D12)),(D13-LOOKUP(2,1/ISNUMBER($D$2:D12),$D$2:D12))/LOOKUP(2,1/ISNUMBER($D$2:D12),$D$2:D12),\"\"))","v":""},"","","","",{"$f":"IF(J13=0,0,IF(J13=\"\",\"\",(J13-LOOKUP(2,1/ISNUMBER($J$2:J12),$J$2:J12))))","v":""}]
[null,"1-Year Retention",null,null,{"$f":"IF(C14=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C13),$C$2:C13)),(C14-LOOKUP(2,1/ISNUMBER($C$2:C13),$C$2:C13))/LOOKUP(2,1/ISNUMBER($C$2:C13),$C$2:C13),\"\"))","v":""},{"$f":"IF(D14=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D13),$D$2:D13)),(D14-LOOKUP(2,1/ISNUMBER($D$2:D13),$D$2:D13))/LOOKUP(2,1/ISNUMBER($D$2:D13),$D$2:D13),\"\"))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",C14-D14)","v":""},"","",{"$f":"IF(OR(I14=\"\",H14=\"\"),\"\",(H14-I14))","v":""},{"$f":"IF(J14=0,0,IF(J14=\"\",\"\",(J14-LOOKUP(2,1/ISNUMBER($J$2:J13),$J$2:J13))))","v":""}]
[null,"3-Year Retention",null,null,{"$f":"IF(C15=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C14),$C$2:C14)),(C15-LOOKUP(2,1/ISNUMBER($C$2:C14),$C$2:C14))/LOOKUP(2,1/ISNUMBER($C$2:C14),$C$2:C14),\"\"))","v":""},{"$f":"IF(D15=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D14),$D$2:D14)),(D15-LOOKUP(2,1/ISNUMBER($D$2:D14),$D$2:D14))/LOOKUP(2,1/ISNUMBER($D$2:D14),$D$2:D14),\"\"))","v":""},"","","","",{"$f":"IF(J15=0,0,IF(J15=\"\",\"\",(J15-LOOKUP(2,1/ISNUMBER($J$2:J14),$J$2:J14))))","v":""}]
[null,"5-Year Retention",null,null,{"$f":"IF(C16=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C15),$C$2:C15)),(C16-LOOKUP(2,1/ISNUMBER($C$2:C15),$C$2:C15))/LOOKUP(2,1/ISNUMBER($C$2:C15),$C$2:C15),\"\"))","v":""},{"$f":"IF(D16=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D15),$D$2:D15)),(D16-LOOKUP(2,1/ISNUMBER($D$2:D15),$D$2:D15))/LOOKUP(2,1/ISNUMBER($D$2:D15),$D$2:D15),\"\"))","v":""},"","","","",{"$f":"IF(J16=0,0,IF(J16=\"\",\"\",(J16-LOOKUP(2,1/ISNUMBER($J$2:J15),$J$2:J15))))","v":""}]
[]
[]
[]
["Rank","Category","Gap Increase",null,null,null,null,null,{"$f":"C1","v":"All Teachers"},{"$f":"D1 & \" Teachers\"","v":"SPED Teachers"},"Gap",{"$f":"H1","v":"Percent Retained All Teachers"},{"$f":"I1","v":"Percent Retained\nSPED Teachers"},"Gap","DiffMid",null,"Rank","Category","Gap Increase"]
[1,{"$f":"IF(ISERROR(VLOOKUP(A21,$Q$21:$S$35,2,FALSE))=FALSE,VLOOKUP(A21,$Q$21:$S$35,2,FALSE),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(A21,$Q$21:$S$35,3,FALSE))=FALSE,VLOOKUP(A21,$Q$21:$S$35,3,FALSE),\"\")","v":""},null,null,null,null,{"$f":"B2","v":"Teacher Preparation Program Applied"},{"$f":"IF(ISBLANK(C2),NA(),C2)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D2),NA(),D2)","v":{"$error":"#N/A"}},{"$f":"IF(AND(ISNUMBER(I21),ISNUMBER(J21)),I21-J21,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(H2),ISNUMBER(I2)),H2,NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND(ISNUMBER(H2),ISNUMBER(I2)),I2,NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND(ISNUMBER(L21),ISNUMBER(M21)),ABS(L21-M21),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L21),ISNUMBER(M21)),(L21+M21)/2,\"\")","v":""},null,{"$f":"_xlfn.RANK.EQ(S21,$S$21:$S$35,0)+COUNTIF($S$21:$S21,S21)-1","v":{"$error":"#VALUE!"}},{"$f":"B2","v":"Teacher Preparation Program Applied"},{"$f":"IF(ISNUMBER(K2),ROUND(K2,4),\"\")","v":""}]
[2,"","",null,null,null,null,"Teacher Preparation Program Admitted",{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(ISNUMBER(I22),ISNUMBER(J22)),I22-J22,\"\")","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(ISNUMBER(L22),ISNUMBER(M22)),ABS(L22-M22),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L22),ISNUMBER(M22)),(L22+M22)/2,\"\")","v":""},null,{"$f":"_xlfn.RANK.EQ(S22,$S$21:$S$35,0)+COUNTIF($S$21:$S22,S22)-1","v":{"$error":"#VALUE!"}},"Teacher Preparation Program Admitted",""]
[3,"","",null,null,null,null,"Teacher Preparation Program Enrollment",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S23,$S$21:$S$35,0)+COUNTIF($S$21:$S23,S23)-1","v":{"$error":"#VALUE!"}},"Teacher Preparation Program Enrollment",""]
[4,"","",null,null,null,null,"Education Degree Conferred",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S24,$S$21:$S$35,0)+COUNTIF($S$21:$S24,S24)-1","v":{"$error":"#VALUE!"}},"Education Degree Conferred",""]
[5,"","",null,null,null,null,"Pass State Licensure Test",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S25,$S$21:$S$35,0)+COUNTIF($S$21:$S25,S25)-1","v":{"$error":"#VALUE!"}},"Pass State Licensure Test",""]
[6,"","",null,null,null,null,"Certified",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S26,$S$21:$S$35,0)+COUNTIF($S$21:$S26,S26)-1","v":{"$error":"#VALUE!"}},"Certified",""]
[7,"","",null,null,null,null,"Submitting Applications",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S27,$S$21:$S$35,0)+COUNTIF($S$21:$S27,S27)-1","v":{"$error":"#VALUE!"}},"Submitting Applications",""]
[8,"","",null,null,null,null,"Passing Initial Screening",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S28,$S$21:$S$35,0)+COUNTIF($S$21:$S28,S28)-1","v":{"$error":"#VALUE!"}},"Passing Initial Screening",""]
[9,"","",null,null,null,null,"Participating in District Interviews",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S29,$S$21:$S$35,0)+COUNTIF($S$21:$S29,S29)-1","v":{"$error":"#VALUE!"}},"Participating in District Interviews",""]
[10,"","",null,null,null,null,"Participating in School Interviews",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S30,$S$21:$S$35,0)+COUNTIF($S$21:$S30,S30)-1","v":{"$error":"#VALUE!"}},"Participating in School Interviews",""]
[11,"","",null,null,null,null,"Selected",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S31,$S$21:$S$35,0)+COUNTIF($S$21:$S31,S31)-1","v":{"$error":"#VALUE!"}},"Selected",""]
[12,"","",null,null,null,null,"Accepted Offer",{"$error":"#N/A"},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S32,$S$21:$S$35,0)+COUNTIF($S$21:$S32,S32)-1","v":{"$error":"#VALUE!"}},"Accepted Offer",""]
[13,"","",null,null,null,null,{"$f":"B14","v":"1-Year Retention"},{"$f":"IF(ISBLANK(C14),NA(),C14)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AND(ISNUMBER(I33),ISNUMBER(J33)),I33-J33,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(H14),ISNUMBER(I14)),H14,NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND(ISNUMBER(H14),ISNUMBER(I14)),I14,NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND(ISNUMBER(L33),ISNUMBER(M33)),ABS(L33-M33),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(L33),ISNUMBER(M33)),(L33+M33)/2,\"\")","v":""},null,{"$f":"_xlfn.RANK.EQ(S33,$S$21:$S$35,0)+COUNTIF($S$21:$S33,S33)-1","v":{"$error":"#VALUE!"}},{"$f":"B14","v":"1-Year Retention"},{"$f":"IF(ISNUMBER(K14),ROUND(K14,4),\"\")","v":""}]
[14,"","",null,null,null,null,"3-Year Retention",{"$f":"IF(ISBLANK(C15),NA(),C15)","v":{"$error":"#N/A"}},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S34,$S$21:$S$35,0)+COUNTIF($S$21:$S34,S34)-1","v":{"$error":"#VALUE!"}},"3-Year Retention",""]
[null,null,null,null,null,null,null,"5-Year Retention",{"$f":"IF(ISBLANK(C16),NA(),C16)","v":{"$error":"#N/A"}},{"$error":"#N/A"},"",{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(S35,$S$21:$S$35,0)+COUNTIF($S$21:$S35,S35)-1","v":{"$error":"#VALUE!"}},"5-Year Retention",""]

{"sheet":"Teacher Hiring Funnel","index":1,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'Development of Gaps'!D1 & \" Teachers\"","v":"SPED Teachers"},{"$f":"\"Change for \" &C1","v":"Change for SPED Teachers"}]
[null,{"$f":"'Development of Gaps'!B2","v":"Teacher Preparation Program Applied"},{"$f":"IF(ISNUMBER('Development of Gaps'!D2),'Development of Gaps'!D2,\"\")","v":""},null,null,null,null,null,null,null,null,"Rank","Category","Gap Increase"]
[null,{"$f":"'Development of Gaps'!B3","v":"Teacher Preparation Program Admitted"},{"$f":"IF(ISNUMBER('Development of Gaps'!D3),'Development of Gaps'!D3,\"\")","v":""},{"$f":"IF(C3=\"\",\"\",C3-LOOKUP(2,1/ISNUMBER($C$2:C2),$C$2:C2))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N3,$N$3:$N$19,1)+COUNTIF($N$3:N3,N3)-1","v":{"$error":"#VALUE!"}},{"$f":"B3","v":"Teacher Preparation Program Admitted"},{"$f":"D3","v":""}]
[null,{"$f":"'Development of Gaps'!B4","v":"Teacher Preparation Program Enrollment"},{"$f":"IF(ISNUMBER('Development of Gaps'!D4),'Development of Gaps'!D4,\"\")","v":""},{"$f":"IF(C4=\"\",\"\",C4-LOOKUP(2,1/ISNUMBER($C$2:C3),$C$2:C3))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N4,$N$3:$N$19,1)+COUNTIF($N$3:N4,N4)-1","v":{"$error":"#VALUE!"}},{"$f":"B4","v":"Teacher Preparation Program Enrollment"},""]
[null,{"$f":"'Development of Gaps'!B5","v":"Education Degree Conferred"},{"$f":"IF(ISNUMBER('Development of Gaps'!D5),'Development of Gaps'!D5,\"\")","v":""},{"$f":"IF(C5=\"\",\"\",C5-LOOKUP(2,1/ISNUMBER($C$2:C4),$C$2:C4))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N5,$N$3:$N$19,1)+COUNTIF($N$3:N5,N5)-1","v":{"$error":"#VALUE!"}},"Education Degree Conferred",""]
[null,{"$f":"'Development of Gaps'!B6","v":"Pass State Licensure Test"},{"$f":"IF(ISNUMBER('Development of Gaps'!D6),'Development of Gaps'!D6,\"\")","v":""},{"$f":"IF(C6=\"\",\"\",C6-LOOKUP(2,1/ISNUMBER($C$2:C5),$C$2:C5))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N6,$N$3:$N$19,1)+COUNTIF($N$3:N6,N6)-1","v":{"$error":"#VALUE!"}},"Pass State Licensure Test",""]
[null,{"$f":"'Development of Gaps'!B7","v":"Certified"},{"$f":"IF(ISNUMBER('Development of Gaps'!D7),'Development of Gaps'!D7,\"\")","v":""},{"$f":"IF(C7=\"\",\"\",C7-LOOKUP(2,1/ISNUMBER($C$2:C6),$C$2:C6))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N7,$N$3:$N$19,1)+COUNTIF($N$3:N7,N7)-1","v":{"$error":"#VALUE!"}},"Certified",""]
[null,{"$f":"'Development of Gaps'!B8","v":"Submitting Applications"},{"$f":"IF(ISNUMBER('Development of Gaps'!D8),'Development of Gaps'!D8,\"\")","v":""},{"$f":"IF(C8=\"\",\"\",C8-LOOKUP(2,1/ISNUMBER($C$2:C7),$C$2:C7))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N8,$N$3:$N$19,1)+COUNTIF($N$3:N8,N8)-1","v":{"$error":"#VALUE!"}},"Submitting Applications",""]
[null,{"$f":"'Development of Gaps'!B9","v":"Passing Initial Screening"},{"$f":"IF(ISNUMBER('Development of Gaps'!D9),'Development of Gaps'!D9,\"\")","v":""},{"$f":"IF(C9=\"\",\"\",C9-LOOKUP(2,1/ISNUMBER($C$2:C8),$C$2:C8))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N9,$N$3:$N$19,1)+COUNTIF($N$3:N9,N9)-1","v":{"$error":"#VALUE!"}},"Passing Initial Screening",""]
[null,{"$f":"'Development of Gaps'!B10","v":"Participating in District Interviews"},{"$f":"IF(ISNUMBER('Development of Gaps'!D10),'Development of Gaps'!D10,\"\")","v":""},{"$f":"IF(C10=\"\",\"\",C10-LOOKUP(2,1/ISNUMBER($C$2:C9),$C$2:C9))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N10,$N$3:$N$19,1)+COUNTIF($N$3:N10,N10)-1","v":{"$error":"#VALUE!"}},"Participating in District Interviews",""]
[null,{"$f":"'Development of Gaps'!B11","v":"Participating in School Interviews"},{"$f":"IF(ISNUMBER('Development of Gaps'!D11),'Development of Gaps'!D11,\"\")","v":""},{"$f":"IF(C11=\"\",\"\",C11-LOOKUP(2,1/ISNUMBER($C$2:C10),$C$2:C10))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N11,$N$3:$N$19,1)+COUNTIF($N$3:N11,N11)-1","v":{"$error":"#VALUE!"}},"Participating in School Interviews",""]
[null,{"$f":"'Development of Gaps'!B12","v":"Selected"},{"$f":"IF(ISNUMBER('Development of Gaps'!D12),'Development of Gaps'!D12,\"\")","v":""},{"$f":"IF(C12=\"\",\"\",C12-LOOKUP(2,1/ISNUMBER($C$2:C11),$C$2:C11))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N12,$N$3:$N$19,1)+COUNTIF($N$3:N12,N12)-1","v":{"$error":"#VALUE!"}},"Selected",""]
[null,{"$f":"'Development of Gaps'!B13","v":"Accepted Offer"},{"$f":"IF(ISNUMBER('Development of Gaps'!D13),'Development of Gaps'!D13,\"\")","v":""},{"$f":"IF(C13=\"\",\"\",C13-LOOKUP(2,1/ISNUMBER($C$2:C12),$C$2:C12))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N13,$N$3:$N$19,1)+COUNTIF($N$3:N13,N13)-1","v":{"$error":"#VALUE!"}},"Accepted Offer",""]
[null,{"$f":"'Development of Gaps'!B14","v":"1-Year Retention"},{"$f":"IF(ISNUMBER('Development of Gaps'!D14),'Development of Gaps'!D14,\"\")","v":""},{"$f":"IF(C14=\"\",\"\",C14-LOOKUP(2,1/ISNUMBER($C$2:C13),$C$2:C13))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N14,$N$3:$N$19,1)+COUNTIF($N$3:N14,N14)-1","v":{"$error":"#VALUE!"}},{"$f":"B14","v":"1-Year Retention"},{"$f":"D14","v":""}]
[null,{"$f":"'Development of Gaps'!B15","v":"3-Year Retention"},{"$f":"IF(ISNUMBER('Development of Gaps'!D15),'Development of Gaps'!D15,\"\")","v":""},{"$f":"IF(C15=\"\",\"\",C15-LOOKUP(2,1/ISNUMBER($C$2:C14),$C$2:C14))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N15,$N$3:$N$19,1)+COUNTIF($N$3:N15,N15)-1","v":{"$error":"#VALUE!"}},"3-Year Retention",{"$f":"D15","v":""}]
[null,{"$f":"'Development of Gaps'!B16","v":"5-Year Retention"},{"$f":"IF(ISNUMBER('Development of Gaps'!D16),'Development of Gaps'!D16,\"\")","v":""},{"$f":"IF(C16=\"\",\"\",C16-LOOKUP(2,1/ISNUMBER($C$2:C15),$C$2:C15))","v":""},null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(N16,$N$3:$N$19,1)+COUNTIF($N$3:N16,N16)-1","v":{"$error":"#VALUE!"}},"5-Year Retention",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Rank","Category","Teacher Loss"]
[1,{"$f":"IF(ISERROR(VLOOKUP(A27,$L$3:$N$19,2,FALSE))=FALSE,VLOOKUP(A27,$L$3:$N$19,2,FALSE),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(A27,$L$3:$N$19,3,FALSE))=FALSE,VLOOKUP(A27,$L$3:$N$19,3,FALSE),\"\")","v":""}]
[2,"",""]
[3,"",""]
[4,"",""]
[5,"",""]
[6,"",""]
[7,"",""]
[8,"",""]
[9,"",""]
[10,"",""]
[11,"",""]
[12,"",""]
[13,"",""]

{"sheet":"Accountability Score Entry","index":2,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,10,4,13]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Accountability Score"]
["School or District Names","Submitting Applications - # SWD Teachers","Passed Initial Screening - # SWD Teachers","Participating In District Interviews - # SWD Teachers","Participating in School Interviews - # SWD Teachers","Selected - # SWD Teachers","Accepted Offer - # SWD Teachers","1-Year Retention - # SWD Teachers","3-Year Retention - # SWD Teachers","5-Year Retention - # SWD Teachers","All Students Score","Students With Disabilities (SWD) Subgroup Score","Gap Between Disability Subgroup Score and All Students Score","Score Gap Percentile","Remove Row"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(T_Scoring[[#This Row],[All Students Score]]),ISNUMBER(T_Scoring[[#This Row],[Students With Disabilities (SWD) Subgroup Score]])),T_Scoring[[#This Row],[Students With Disabilities (SWD) Subgroup Score]]-T_Scoring[[#This Row],[All Students Score]],\"\")","v":""},{"$f":"IF(ISNUMBER(T_Scoring[[#This Row],[Gap Between Disability Subgroup Score and All Students Score]]),IF(T_Scoring[[#This Row],[Gap Between Disability Subgroup Score and All Students Score]]>=_xlfn.QUARTILE.INC(T_Scoring[Gap Between Disability Subgroup Score and All Students Score],3),\"Above 75th Percentile\",IF(T_Scoring[[#This Row],[Gap Between Disability Subgroup Score and All Students Score]]<=_xlfn.QUARTILE.INC(T_Scoring[Gap Between Disability Subgroup Score and All Students Score],1),\"Below 25th Percentile\",\"Between 25th and 75th Percentile\")), \"\")","v":""},{"$f":"\"Double Click To Remove Row\"","v":"Double Click To Remove Row"}]

{"sheet":"Accountability Score Results","index":3,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"\"Above 75th Percentile - \" &  \"SWD Teachers\"","v":"Above 75th Percentile - SWD Teachers"},{"$f":"\"Between 25th and 75th Percentile - \" &  \"SWD Teachers\"","v":"Between 25th and 75th Percentile - SWD Teachers"},{"$f":"\"Below 25th Percentile - \" & \"SWD Teachers\"","v":"Below 25th Percentile - SWD Teachers"},"Percent Change - Above 75th Percentile","Percent Change - Between 25th and 75th Percentile","Percent Change - Below 25th Percentile","Percent Retained - Above 75th Percentile","Percent Retained - Between 25th and 75th Percentile","Percent Retained - Below 25th Percentile","% Retained Gap","Change"]
[null,"Submitting Applications",{"$f":"IF(COUNT(T_Scoring[Submitting Applications - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Above 75th Percentile\",T_Scoring[Submitting Applications - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Submitting Applications - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Between 25th and 75th Percentile\",T_Scoring[Submitting Applications - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Submitting Applications - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Below 25th Percentile\",T_Scoring[Submitting Applications - '# SWD Teachers]),\"\")","v":""},null,null,null,{"$f":"IF(ISNUMBER(C2),1,\"\")","v":""},{"$f":"IF(ISNUMBER(D2),1,\"\")","v":""},{"$f":"IF(ISNUMBER(E2),1,\"\")","v":""},{"$f":"IF(OR(I2=\"\",K2=\"\"),\"\",(I2-K2))","v":""}]
[null,"Passing Initial Screening",{"$f":"IF(COUNT(T_Scoring[Passed Initial Screening - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Above 75th Percentile\",T_Scoring[Passed Initial Screening - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Passed Initial Screening - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Between 25th and 75th Percentile\",T_Scoring[Passed Initial Screening - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Passed Initial Screening - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Below 25th Percentile\",T_Scoring[Passed Initial Screening - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(C3=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C2),$C$2:C2)),(C3-LOOKUP(2,1/ISNUMBER($C$2:C2),$C$2:C2))/LOOKUP(2,1/ISNUMBER($C$2:C2),$C$2:C2),\"\"))","v":""},{"$f":"IF(D3=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D2),$D$2:D2)),(D3-LOOKUP(2,1/ISNUMBER($D$2:D2),$D$2:D2))/LOOKUP(2,1/ISNUMBER($D$2:D2),$D$2:D2),\"\"))","v":""},{"$f":"IF(E3=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($E$2:E2),$E$2:E2)),(E3-LOOKUP(2,1/ISNUMBER($E$2:E2),$E$2:E2))/LOOKUP(2,1/ISNUMBER($E$2:E2),$E$2:E2),\"\"))","v":""},{"$f":"IF(AND(ISNUMBER(C3),$C$2<>0),C3/$C$2,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D3),$D$2<>0),D3/$D$2,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E3),$E$2<>0),E3/$E$2,\"\")","v":""},"",{"$f":"IF(L3=0,0,IF(L3=\"\",\"\",(L3-LOOKUP(2,1/ISNUMBER($L$2:L2),$L$2:L2))))","v":""}]
[null,"Participating in District Interviews",{"$f":"IF(COUNT(T_Scoring[Participating In District Interviews - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Above 75th Percentile\",T_Scoring[Participating In District Interviews - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Participating In District Interviews - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Between 25th and 75th Percentile\",T_Scoring[Participating In District Interviews - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Participating In District Interviews - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Below 25th Percentile\",T_Scoring[Participating In District Interviews - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(C4=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C3),$C$2:C3)),(C4-LOOKUP(2,1/ISNUMBER($C$2:C3),$C$2:C3))/LOOKUP(2,1/ISNUMBER($C$2:C3),$C$2:C3),\"\"))","v":""},{"$f":"IF(D4=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D3),$D$2:D3)),(D4-LOOKUP(2,1/ISNUMBER($D$2:D3),$D$2:D3))/LOOKUP(2,1/ISNUMBER($D$2:D3),$D$2:D3),\"\"))","v":""},{"$f":"IF(E4=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($E$2:E3),$E$2:E3)),(E4-LOOKUP(2,1/ISNUMBER($E$2:E3),$E$2:E3))/LOOKUP(2,1/ISNUMBER($E$2:E3),$E$2:E3),\"\"))","v":""},"",{"$f":"IF(AND(ISNUMBER(D4),$D$2<>0),D4/$D$2,\"\")","v":""},"","",{"$f":"IF(L4=0,0,IF(L4=\"\",\"\",(L4-LOOKUP(2,1/ISNUMBER($L$2:L3),$L$2:L3))))","v":""}]
[null,"Participating in School Interviews",{"$f":"IF(COUNT(T_Scoring[Participating in School Interviews - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Above 75th Percentile\",T_Scoring[Participating in School Interviews - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Participating in School Interviews - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Between 25th and 75th Percentile\",T_Scoring[Participating in School Interviews - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Participating in School Interviews - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Below 25th Percentile\",T_Scoring[Participating in School Interviews - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(C5=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C4),$C$2:C4)),(C5-LOOKUP(2,1/ISNUMBER($C$2:C4),$C$2:C4))/LOOKUP(2,1/ISNUMBER($C$2:C4),$C$2:C4),\"\"))","v":""},{"$f":"IF(D5=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D4),$D$2:D4)),(D5-LOOKUP(2,1/ISNUMBER($D$2:D4),$D$2:D4))/LOOKUP(2,1/ISNUMBER($D$2:D4),$D$2:D4),\"\"))","v":""},{"$f":"IF(E5=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($E$2:E4),$E$2:E4)),(E5-LOOKUP(2,1/ISNUMBER($E$2:E4),$E$2:E4))/LOOKUP(2,1/ISNUMBER($E$2:E4),$E$2:E4),\"\"))","v":""},"",{"$f":"IF(AND(ISNUMBER(D5),$D$2<>0),D5/$D$2,\"\")","v":""},"","",{"$f":"IF(L5=0,0,IF(L5=\"\",\"\",(L5-LOOKUP(2,1/ISNUMBER($L$2:L4),$L$2:L4))))","v":""}]
[null,"Selected",{"$f":"IF(COUNT(T_Scoring[Selected - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Above 75th Percentile\",T_Scoring[Selected - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Selected - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Between 25th and 75th Percentile\",T_Scoring[Selected - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Selected - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Below 25th Percentile\",T_Scoring[Selected - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(C6=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C5),$C$2:C5)),(C6-LOOKUP(2,1/ISNUMBER($C$2:C5),$C$2:C5))/LOOKUP(2,1/ISNUMBER($C$2:C5),$C$2:C5),\"\"))","v":""},{"$f":"IF(D6=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D5),$D$2:D5)),(D6-LOOKUP(2,1/ISNUMBER($D$2:D5),$D$2:D5))/LOOKUP(2,1/ISNUMBER($D$2:D5),$D$2:D5),\"\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($E$2:E5),$E$2:E5)),(E6-LOOKUP(2,1/ISNUMBER($E$2:E5),$E$2:E5))/LOOKUP(2,1/ISNUMBER($E$2:E5),$E$2:E5),\"\"))","v":""},"",{"$f":"IF(AND(ISNUMBER(D6),$D$2<>0),D6/$D$2,\"\")","v":""},"","",{"$f":"IF(L6=0,0,IF(L6=\"\",\"\",(L6-LOOKUP(2,1/ISNUMBER($L$2:L5),$L$2:L5))))","v":""}]
[null,"Accepted Offer",{"$f":"IF(COUNT(T_Scoring[Accepted Offer - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Above 75th Percentile\",T_Scoring[Accepted Offer - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Accepted Offer - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Between 25th and 75th Percentile\",T_Scoring[Accepted Offer - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[Accepted Offer - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Below 25th Percentile\",T_Scoring[Accepted Offer - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(C7=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C6),$C$2:C6)),(C7-LOOKUP(2,1/ISNUMBER($C$2:C6),$C$2:C6))/LOOKUP(2,1/ISNUMBER($C$2:C6),$C$2:C6),\"\"))","v":""},{"$f":"IF(D7=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D6),$D$2:D6)),(D7-LOOKUP(2,1/ISNUMBER($D$2:D6),$D$2:D6))/LOOKUP(2,1/ISNUMBER($D$2:D6),$D$2:D6),\"\"))","v":""},{"$f":"IF(E7=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($E$2:E6),$E$2:E6)),(E7-LOOKUP(2,1/ISNUMBER($E$2:E6),$E$2:E6))/LOOKUP(2,1/ISNUMBER($E$2:E6),$E$2:E6),\"\"))","v":""},"",{"$f":"IF(AND(ISNUMBER(D7),$D$2<>0),D7/$D$2,\"\")","v":""},"","",{"$f":"IF(L7=0,0,IF(L7=\"\",\"\",(L7-LOOKUP(2,1/ISNUMBER($L$2:L6),$L$2:L6))))","v":""}]
[null,"1-Year Retention",{"$f":"IF(COUNT(T_Scoring[1-Year Retention - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Above 75th Percentile\",T_Scoring[1-Year Retention - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[1-Year Retention - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Between 25th and 75th Percentile\",T_Scoring[1-Year Retention - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[1-Year Retention - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Below 25th Percentile\",T_Scoring[1-Year Retention - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(C8=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C7),$C$2:C7)),(C8-LOOKUP(2,1/ISNUMBER($C$2:C7),$C$2:C7))/LOOKUP(2,1/ISNUMBER($C$2:C7),$C$2:C7),\"\"))","v":""},{"$f":"IF(D8=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D7),$D$2:D7)),(D8-LOOKUP(2,1/ISNUMBER($D$2:D7),$D$2:D7))/LOOKUP(2,1/ISNUMBER($D$2:D7),$D$2:D7),\"\"))","v":""},{"$f":"IF(E8=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($E$2:E7),$E$2:E7)),(E8-LOOKUP(2,1/ISNUMBER($E$2:E7),$E$2:E7))/LOOKUP(2,1/ISNUMBER($E$2:E7),$E$2:E7),\"\"))","v":""},"","","","",{"$f":"IF(L8=0,0,IF(L8=\"\",\"\",(L8-LOOKUP(2,1/ISNUMBER($L$2:L7),$L$2:L7))))","v":""}]
[null,"3-Year Retention",{"$f":"IF(COUNT(T_Scoring[3-Year Retention - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Above 75th Percentile\",T_Scoring[3-Year Retention - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[3-Year Retention - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Between 25th and 75th Percentile\",T_Scoring[3-Year Retention - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[3-Year Retention - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Below 25th Percentile\",T_Scoring[3-Year Retention - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(C9=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C8),$C$2:C8)),(C9-LOOKUP(2,1/ISNUMBER($C$2:C8),$C$2:C8))/LOOKUP(2,1/ISNUMBER($C$2:C8),$C$2:C8),\"\"))","v":""},{"$f":"IF(D9=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D8),$D$2:D8)),(D9-LOOKUP(2,1/ISNUMBER($D$2:D8),$D$2:D8))/LOOKUP(2,1/ISNUMBER($D$2:D8),$D$2:D8),\"\"))","v":""},{"$f":"IF(E9=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($E$2:E8),$E$2:E8)),(E9-LOOKUP(2,1/ISNUMBER($E$2:E8),$E$2:E8))/LOOKUP(2,1/ISNUMBER($E$2:E8),$E$2:E8),\"\"))","v":""},"","","","",{"$f":"IF(L9=0,0,IF(L9=\"\",\"\",(L9-LOOKUP(2,1/ISNUMBER($L$2:L8),$L$2:L8))))","v":""}]
[null,"5-Year Retention",{"$f":"IF(COUNT(T_Scoring[5-Year Retention - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Above 75th Percentile\",T_Scoring[5-Year Retention - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[5-Year Retention - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Between 25th and 75th Percentile\",T_Scoring[5-Year Retention - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(COUNT(T_Scoring[5-Year Retention - '# SWD Teachers])>0,SUMIF(T_Scoring[Score Gap Percentile],\"Below 25th Percentile\",T_Scoring[5-Year Retention - '# SWD Teachers]),\"\")","v":""},{"$f":"IF(C10=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($C$2:C9),$C$2:C9)),(C10-LOOKUP(2,1/ISNUMBER($C$2:C9),$C$2:C9))/LOOKUP(2,1/ISNUMBER($C$2:C9),$C$2:C9),\"\"))","v":""},{"$f":"IF(D10=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($D$2:D9),$D$2:D9)),(D10-LOOKUP(2,1/ISNUMBER($D$2:D9),$D$2:D9))/LOOKUP(2,1/ISNUMBER($D$2:D9),$D$2:D9),\"\"))","v":""},{"$f":"IF(E10=\"\",\"\",IF(ISNUMBER(LOOKUP(2,1/ISNUMBER($E$2:E9),$E$2:E9)),(E10-LOOKUP(2,1/ISNUMBER($E$2:E9),$E$2:E9))/LOOKUP(2,1/ISNUMBER($E$2:E9),$E$2:E9),\"\"))","v":""},"","","","",{"$f":"IF(L10=0,0,IF(L10=\"\",\"\",(L10-LOOKUP(2,1/ISNUMBER($L$2:L9),$L$2:L9))))","v":""}]
[]
[]
[]
["Rank","Category","Gap Increase"]
[1,{"$f":"IF(ISERROR(VLOOKUP(A15,$P$21:$R$29,2,FALSE))=FALSE,VLOOKUP(A15,$P$21:$R$29,2,FALSE),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(A15,$P$21:$R$29,3,FALSE))=FALSE,VLOOKUP(A15,$P$21:$R$29,3,FALSE),\"\")","v":""}]
[2,"",""]
[3,"",""]
[4,"",""]
[5,"",""]
[6,"","",null,null,null,null,null,null,"Percent SPED Teachers Retained—Schools Above 75th Percentile ","Percent SPED Teachers Retained—Schools Between 25th and 75th Percentile ","Percent SPED Teachers Retained—Schools Below 25th Percentile","Gap","DiffMid",null,"Rank","Category","Gap Increase"]
[7,"","",null,null,null,null,null,{"$f":"B2","v":"Submitting Applications"},{"$f":"IF(ISNUMBER(I2),I2,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AND(ISNUMBER(J21),ISNUMBER(L21)),J21-L21,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J21),ISNUMBER(L21)),(J21+L21)/2,\"\")","v":""},null,{"$f":"_xlfn.RANK.EQ(R21,$R$21:$R$29,0)+COUNTIF($R$21:$R21,R21)-1","v":{"$error":"#VALUE!"}},{"$f":"B2","v":"Submitting Applications"},{"$f":"IF(ISNUMBER(L2),ROUND(L2,4),\"\")","v":""}]
[8,"","",null,null,null,null,null,"Passing Initial Screening",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(R22,$R$21:$R$29,0)+COUNTIF($R$21:$R22,R22)-1","v":{"$error":"#VALUE!"}},"Passing Initial Screening",""]
[9,"","",null,null,null,null,null,"Participating in District Interviews",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(R23,$R$21:$R$29,0)+COUNTIF($R$21:$R23,R23)-1","v":{"$error":"#VALUE!"}},"Participating in District Interviews",""]
[null,null,null,null,null,null,null,null,"Participating in School Interviews",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(R24,$R$21:$R$29,0)+COUNTIF($R$21:$R24,R24)-1","v":{"$error":"#VALUE!"}},"Participating in School Interviews",""]
[null,null,null,null,null,null,null,null,"Selected",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(R25,$R$21:$R$29,0)+COUNTIF($R$21:$R25,R25)-1","v":{"$error":"#VALUE!"}},"Selected",""]
[null,null,null,null,null,null,null,null,"Accepted Offer",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(R26,$R$21:$R$29,0)+COUNTIF($R$21:$R26,R26)-1","v":{"$error":"#VALUE!"}},"Accepted Offer",""]
[null,null,null,null,null,null,null,null,"1-Year Retention",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(R27,$R$21:$R$29,0)+COUNTIF($R$21:$R27,R27)-1","v":{"$error":"#VALUE!"}},"1-Year Retention",""]
[null,null,null,null,null,null,null,null,"3-Year Retention",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(R28,$R$21:$R$29,0)+COUNTIF($R$21:$R28,R28)-1","v":{"$error":"#VALUE!"}},"3-Year Retention",""]
[null,null,null,null,null,null,null,null,"5-Year Retention",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"","",null,{"$f":"_xlfn.RANK.EQ(R29,$R$21:$R$29,0)+COUNTIF($R$21:$R29,R29)-1","v":{"$error":"#VALUE!"}},"5-Year Retention",""]

{"sheet":"Subject","index":4,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Subject"]
["SPED"]
["ELL"]
["Math"]
["Science"]
["World Language"]