{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Development of Gaps","Minority Hiring Funnel","Parity","scratch"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Development of Gaps","index":0,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,"White","Nonwhite","Percentage Change for Nonwhite","Gap","Percent White","Percent Nonwhite","Gap","Change"]
[null,"Student Population",null,null,null,{"$f":"IF(OR(C2=\"\",D2=\"\"),\"\",C2-D2)","v":""},{"$f":"IF(OR(C2=\"\",D2=\"\"),\"\",C2/(C2+D2))","v":""},{"$f":"IF(OR(C2=\"\",D2=\"\"),\"\",D2/(D2+C2))","v":""},{"$f":"IF(OR(H2=\"\",G2=\"\"),\"\",(G2-H2))","v":""}]
[null,"Public School Enrollment",null,null,{"$f":"IF(D3=\"\",\"\",(D3-LOOKUP(2,1/ISNUMBER($D$2:D2),$D$2:D2))/LOOKUP(2,1/ISNUMBER($D$2:D2),$D$2:D2))","v":""},"",{"$f":"IF(OR(C3=\"\",D3=\"\"),\"\",C3/(C3+D3))","v":""},{"$f":"IF(OR(C3=\"\",D3=\"\"),\"\",D3/(D3+C3))","v":""},{"$f":"IF(OR(H3=\"\",G3=\"\"),\"\",(G3-H3))","v":""},{"$f":"IF(I3=\"\",\"\",IF(I2<>\"\",I3-I2,\"\"))","v":""}]
[null,"High School Graduation",null,null,{"$f":"IF(D4=\"\",\"\",(D4-LOOKUP(2,1/ISNUMBER($D$2:D3),$D$2:D3))/LOOKUP(2,1/ISNUMBER($D$2:D3),$D$2:D3))","v":""},"","","","",{"$f":"IF(I4=\"\",\"\",IF(I3<>\"\",I4-I3,IF(I2<>\"\",I4-I2,\"\")))","v":""}]
[null,"Postsecondary Enrollment",null,null,{"$f":"IF(D5=\"\",\"\",(D5-LOOKUP(2,1/ISNUMBER($D$2:D4),$D$2:D4))/LOOKUP(2,1/ISNUMBER($D$2:D4),$D$2:D4))","v":""},"","","","",{"$f":"IF(I5=\"\",\"\",IF(I4<>\"\",I5-I4,IF(I3<>\"\",I5-I3,IF(I2<>\"\",I5-I2,\"\"))))","v":""}]
[null,"Teacher Preparation Program Applied",null,null,{"$f":"IF(D6=\"\",\"\",(D6-LOOKUP(2,1/ISNUMBER($D$2:D5),$D$2:D5))/LOOKUP(2,1/ISNUMBER($D$2:D5),$D$2:D5))","v":""},"","","","",{"$f":"IF(I6=\"\",\"\",IF(I5<>\"\",I6-I5,IF(I4<>\"\",I6-I4,IF(I3<>\"\",I6-I3,IF(I2<>\"\",I6-I2,\"\")))))","v":""}]
[null,"Teacher Preparation Program Admitted",null,null,{"$f":"IF(D7=\"\",\"\",(D7-LOOKUP(2,1/ISNUMBER($D$2:D6),$D$2:D6))/LOOKUP(2,1/ISNUMBER($D$2:D6),$D$2:D6))","v":""},"","","","",{"$f":"IF(I7=\"\",\"\",IF(I6<>\"\",I7-I6,IF(I5<>\"\",I7-I5,IF(I4<>\"\",I7-I4,IF(I3<>\"\",I7-I3,IF(I2<>\"\",I7-I2,\"\"))))))","v":""}]
[null,"Teacher Preparation Program Enrollment",null,null,{"$f":"IF(D8=\"\",\"\",(D8-LOOKUP(2,1/ISNUMBER($D$2:D7),$D$2:D7))/LOOKUP(2,1/ISNUMBER($D$2:D7),$D$2:D7))","v":""},"","","","",{"$f":"IF(I8=\"\",\"\",IF(I7<>\"\",I8-I7,IF(I6<>\"\",I8-I6,IF(I5<>\"\",I8-I5,IF(I4<>\"\",I8-I4,IF(I3<>\"\",I8-I3,IF(I2<>\"\",I8-I2,\"\")))))))","v":""}]
[null,"Education Bachelor's Degree Conferred",null,null,{"$f":"IF(D9=\"\",\"\",(D9-LOOKUP(2,1/ISNUMBER($D$2:D8),$D$2:D8))/LOOKUP(2,1/ISNUMBER($D$2:D8),$D$2:D8))","v":""},"","","","",{"$f":"IF(I9=\"\",\"\",IF(I8<>\"\",I9-I8,IF(I7<>\"\",I9-I7,IF(I6<>\"\",I9-I6,IF(I5<>\"\",I9-I5,IF(I4<>\"\",I9-I4,IF(I3<>\"\",I9-I3,IF(I2<>\"\",I9-I2,\"\"))))))))","v":""}]
[null,"Pass State Licensure Test",null,null,{"$f":"IF(D10=\"\",\"\",(D10-LOOKUP(2,1/ISNUMBER($D$2:D9),$D$2:D9))/LOOKUP(2,1/ISNUMBER($D$2:D9),$D$2:D9))","v":""},"","","","",{"$f":"IF(I10=\"\",\"\",IF(I9<>\"\",I10-I9,IF(I8<>\"\",I10-I8,IF(I7<>\"\",I10-I7,IF(I6<>\"\",I10-I6,IF(I5<>\"\",I10-I5,IF(I4<>\"\",I10-I4,IF(I3<>\"\",I10-I3,IF(I2<>\"\",I10-I2,\"\")))))))))","v":""}]
[null,"Certified",null,null,{"$f":"IF(D11=\"\",\"\",(D11-LOOKUP(2,1/ISNUMBER($D$2:D10),$D$2:D10))/LOOKUP(2,1/ISNUMBER($D$2:D10),$D$2:D10))","v":""},"","","","",{"$f":"IF(I11=\"\",\"\",IF(I10<>\"\",I11-I10,IF(I9<>\"\",I11-I9,IF(I8<>\"\",I11-I8,IF(I7<>\"\",I11-I7,IF(I6<>\"\",I11-I6,IF(I5<>\"\",I11-I5,IF(I4<>\"\",I11-I4,IF(I3<>\"\",I11-I3,IF(I2<>\"\",I11-I2,\"\"))))))))))","v":""}]
[null,"Accepted Offer",null,null,{"$f":"IF(D12=\"\",\"\",(D12-LOOKUP(2,1/ISNUMBER($D$2:D11),$D$2:D11))/LOOKUP(2,1/ISNUMBER($D$2:D11),$D$2:D11))","v":""},"","","","",{"$f":"IF(I12=\"\",\"\",IF(I11<>\"\",I12-I11,IF(I10<>\"\",I12-I10,IF(I9<>\"\",I12-I9,IF(I8<>\"\",I12-I8,IF(I7<>\"\",I12-I7,IF(I6<>\"\",I12-I6,IF(I5<>\"\",I12-I5,IF(I4<>\"\",I12-I4,IF(I3<>\"\",I12-I3,IF(I2<>\"\",I12-I2,\"\")))))))))))","v":""}]
[null,"3-Year Retention",null,null,{"$f":"IF(D13=\"\",\"\",(D13-LOOKUP(2,1/ISNUMBER($D$2:D12),$D$2:D12))/LOOKUP(2,1/ISNUMBER($D$2:D12),$D$2:D12))","v":""},"","","","",{"$f":"IF(I13=\"\",\"\",IF(I12<>\"\",I13-I12,IF(I11<>\"\",I13-I11,IF(I10<>\"\",I13-I10,IF(I9<>\"\",I13-I9,IF(I8<>\"\",I13-I8,IF(I7<>\"\",I13-I7,IF(I6<>\"\",I13-I6,IF(I5<>\"\",I13-I5,IF(I4<>\"\",I13-I4,IF(I3<>\"\",I13-I3,IF(I2<>\"\",I13-I2,\"\"))))))))))))","v":""}]
[null,"5-Year Retention",null,null,{"$f":"IF(D14=\"\",\"\",(D14-LOOKUP(2,1/ISNUMBER($D$2:D13),$D$2:D13))/LOOKUP(2,1/ISNUMBER($D$2:D13),$D$2:D13))","v":""},"","","","",{"$f":"IF(I14=\"\",\"\",IF(I13<>\"\",I14-I13,IF(I12<>\"\",I14-I12,IF(I11<>\"\",I14-I11,IF(I10<>\"\",I14-I10,IF(I9<>\"\",I14-I9,IF(I8<>\"\",I14-I8,IF(I7<>\"\",I14-I7,IF(I6<>\"\",I14-I6,IF(I5<>\"\",I14-I5,IF(I4<>\"\",I14-I4,IF(I3<>\"\",I14-I3,IF(I2<>\"\",I14-I2,\"\")))))))))))))","v":""}]
[]
[]
[]
[]
[]
[]
["Rank","Category","Gap Increase",null,null,null,null,"White","Nonwhite","Gap","Percent White","Percent Nonwhite","Gap",null,"Rank","Category","Gap Increase"]
[1,{"$f":"IF(ISERROR(VLOOKUP(A22,$O$22:$Q$33,2,FALSE))=FALSE,VLOOKUP(A22,$O$22:$Q$33,2,FALSE),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(A22,$O$22:$Q$33,3,FALSE))=FALSE,VLOOKUP(A22,$O$22:$Q$33,3,FALSE),\"\")","v":""},null,null,null,{"$f":"B2","v":"Student Population"},{"$f":"IF(C2=\"\",NA(),C2)","v":{"$error":"#N/A"}},{"$f":"IF(D2=\"\",NA(),D2)","v":{"$error":"#N/A"}},{"$f":"IF(OR(H22=\"\",I22=\"\"),\"\",H22-I22)","v":{"$error":"#N/A"}},{"$f":"IF(OR(H22=\"\",I22=\"\"),\"\",H22/(H22+I22))","v":{"$error":"#N/A"}},{"$f":"IF(OR(H22=\"\",I22=\"\"),\"\",I22/(I22+H22))","v":{"$error":"#N/A"}},{"$f":"K22-L22","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.RANK.EQ(Q22,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q22,Q22)-1","v":{"$error":"#VALUE!"}},{"$f":"B3","v":"Public School Enrollment"},{"$f":"J3","v":""}]
[2,{"$f":"IF(ISERROR(VLOOKUP(A23,$O$22:$Q$33,2,FALSE))=FALSE,VLOOKUP(A23,$O$22:$Q$33,2,FALSE),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(A23,$O$22:$Q$33,3,FALSE))=FALSE,VLOOKUP(A23,$O$22:$Q$33,3,FALSE),\"\")","v":""},null,null,null,{"$f":"B3","v":"Public School Enrollment"},{"$f":"IF(C3=\"\",NA(),C3)","v":{"$error":"#N/A"}},{"$f":"IF(D3=\"\",NA(),D3)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(OR(H23=\"\",I23=\"\"),\"\",H23/(H23+I23))","v":{"$error":"#N/A"}},{"$f":"IF(OR(H23=\"\",I23=\"\"),\"\",I23/(I23+H23))","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q23,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q23,Q23)-1","v":{"$error":"#VALUE!"}},{"$f":"B4","v":"High School Graduation"},{"$f":"J4","v":""}]
[3,"","",null,null,null,"High School Graduation",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q24,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q24,Q24)-1","v":{"$error":"#VALUE!"}},"Postsecondary Enrollment",""]
[4,"","",null,null,null,"Postsecondary Enrollment",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q25,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q25,Q25)-1","v":{"$error":"#VALUE!"}},"Teacher Preparation Program Applied",""]
[5,"","",null,null,null,"Teacher Preparation Program Applied",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q26,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q26,Q26)-1","v":{"$error":"#VALUE!"}},"Teacher Preparation Program Admitted",""]
[6,"","",null,null,null,"Teacher Preparation Program Admitted",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q27,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q27,Q27)-1","v":{"$error":"#VALUE!"}},"Teacher Preparation Program Enrollment",""]
[7,"","",null,null,null,"Teacher Preparation Program Enrollment",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q28,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q28,Q28)-1","v":{"$error":"#VALUE!"}},"Education Bachelor's Degree Conferred",""]
[8,"","",null,null,null,"Education Bachelor's Degree Conferred",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q29,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q29,Q29)-1","v":{"$error":"#VALUE!"}},"Pass State Licensure Test",""]
[9,"","",null,null,null,"Pass State Licensure Test",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q30,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q30,Q30)-1","v":{"$error":"#VALUE!"}},"Certified",""]
[10,"","",null,null,null,"Certified",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q31,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q31,Q31)-1","v":{"$error":"#VALUE!"}},"Accepted Offer",""]
[11,"","",null,null,null,"Accepted Offer",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q32,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q32,Q32)-1","v":{"$error":"#VALUE!"}},"3-Year Retention",""]
[12,"","",null,null,null,"3-Year Retention",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"_xlfn.RANK.EQ(Q33,$Q$22:$Q$33,0)+COUNTIF($Q$22:Q33,Q33)-1","v":{"$error":"#VALUE!"}},"5-Year Retention",""]
[null,null,null,null,null,null,"5-Year Retention",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Minority Hiring Funnel","index":1,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,"Nonwhite","Change for Non White"]
[null,"Student Population",{"$f":"IF('Development of Gaps'!D2=\"\",\"\",'Development of Gaps'!D2)","v":""},null,null,null,null,null,null,null,null,"Rank","Category","Gap Increase"]
[null,"Public School Enrollment",{"$f":"IF('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":"Public School Enrollment"},{"$f":"D3","v":""}]
[null,"High School Graduation",{"$f":"IF('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":"High School Graduation"},{"$f":"D4","v":""}]
[null,"Postsecondary Enrollment",{"$f":"IF('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!"}},"Postsecondary Enrollment",""]
[null,"Teacher Preparation Program Applied",{"$f":"IF('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!"}},"Teacher Preparation Program Applied",""]
[null,"Teacher Preparation Program Admitted",{"$f":"IF('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!"}},"Teacher Preparation Program Admitted",""]
[null,"Teacher Preparation Program Enrollment",{"$f":"IF('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!"}},"Teacher Preparation Program Enrollment",""]
[null,"Education Bachelor's Degree Conferred",{"$f":"IF('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!"}},"Education Bachelor's Degree Conferred",""]
[null,"Pass State Licensure Test",{"$f":"IF('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!"}},"Pass State Licensure Test",""]
[null,"Certified",{"$f":"IF('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!"}},"Certified",""]
[null,"Submitting Applications",{"$f":"IF('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!"}},"Submitting Applications",""]
[null,"3-Year Retention",{"$f":"IF('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!"}},{"$f":"B13","v":"3-Year Retention"},""]
[null,"5-Year Retention",{"$f":"IF('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!"}},"5-Year Retention",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Rank","Category","Gap Increase"]
[1,{"$f":"IF(ISERROR(VLOOKUP(A26,$L$3:$N$19,2,FALSE))=FALSE,VLOOKUP(A26,$L$3:$N$19,2,FALSE),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(A26,$L$3:$N$19,3,FALSE))=FALSE,VLOOKUP(A26,$L$3:$N$19,3,FALSE),\"\")","v":""}]
[2,{"$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":""}]
[3,"",""]
[4,"",""]
[5,"",""]
[6,"",""]
[7,"",""]
[8,"",""]
[9,"",""]
[10,"",""]
[11,"",{"$f":"IF(ISERROR(VLOOKUP(A36,$L$3:$N$19,3,FALSE))=FALSE,VLOOKUP(A36,$L$3:$N$19,3,FALSE),\"\")","v":""}]
[12,"",""]

{"sheet":"Parity","index":2,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,"White","African American","Latino/a","Asian American","Native American","Multiracial","Nonwhite Combined",null,null,null,"Rank","Category","Gap"]
[null,"Percent Students ",null,null,null,null,null,null,{"$f":"SUM(D2:H2)","v":0},null,null,null,{"$f":"_xlfn.RANK.EQ(O2,$O$2:$O$7,0)+COUNTIF($O$2:O2,O2)-1","v":{"$error":"#VALUE!"}},{"$f":"C1","v":"White"},{"$f":"O20","v":""}]
[null,"Percent Teachers ",null,null,null,null,null,null,{"$f":"SUM(D3:H3)","v":0},null,null,null,{"$f":"_xlfn.RANK.EQ(O3,$O$2:$O$7,0)+COUNTIF($O$2:O3,O3)-1","v":{"$error":"#VALUE!"}},{"$f":"D1","v":"African American"},{"$f":"P20","v":""}]
[null,"Parity Gap",{"$f":"C2-C3","v":0},0,0,0,0,0,0,null,null,null,{"$f":"_xlfn.RANK.EQ(O4,$O$2:$O$7,0)+COUNTIF($O$2:O4,O4)-1","v":{"$error":"#VALUE!"}},{"$f":"E1","v":"Latino/a"},{"$f":"Q20","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(O5,$O$2:$O$7,0)+COUNTIF($O$2:O5,O5)-1","v":{"$error":"#VALUE!"}},{"$f":"F1","v":"Asian American"},{"$f":"R20","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(O6,$O$2:$O$7,0)+COUNTIF($O$2:O6,O6)-1","v":{"$error":"#VALUE!"}},{"$f":"G1","v":"Native American"},{"$f":"S20","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.RANK.EQ(O7,$O$2:$O$7,0)+COUNTIF($O$2:O7,O7)-1","v":{"$error":"#VALUE!"}},{"$f":"H1","v":"Multiracial"},{"$f":"T20","v":""}]
[]
[]
["Rank","Race Ethnicity","Size of Parity Gap"]
[1,{"$f":"IF(ISERROR(VLOOKUP(A11,$M$2:$O$7,2,FALSE))=FALSE,VLOOKUP(A11,$M$2:$O$7,2,FALSE),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(A11,$M$2:$O$7,3,FALSE))=FALSE,VLOOKUP(A11,$M$2:$O$7,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"White","African American","Latino/a","Asian American","Native American","Multiracial","Nonwhite Combined"]
[2,{"$f":"IF(ISERROR(VLOOKUP(A12,$M$2:$O$7,2,FALSE))=FALSE,VLOOKUP(A12,$M$2:$O$7,2,FALSE),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(A12,$M$2:$O$7,3,FALSE))=FALSE,VLOOKUP(A12,$M$2:$O$7,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Percentage Students ",{"$f":"C2","v":0},0,0,0,0,0,0]
[3,"","",null,null,null,null,null,null,null,null,null,null,"Percentage Teachers ",{"$f":"C3","v":0},{"$f":"D3","v":0},{"$f":"E3","v":0},{"$f":"F3","v":0},{"$f":"G3","v":0},0,0]
[4,"","",null,null,null,null,null,null,null,null,null,null,"Parity Gap",{"$f":"IF(OR(C2=\"\",C3=\"\"),0,C4)","v":0},{"$f":"IF(OR(D2=\"\",D3=\"\"),0,D4)","v":0},{"$f":"IF(OR(E2=\"\",E3=\"\"),0,E4)","v":0},{"$f":"IF(OR(F2=\"\",F3=\"\"),0,F4)","v":0},{"$f":"IF(OR(G2=\"\",G3=\"\"),0,G4)","v":0},0,{"$f":"IF(OR(I2=\"\",I3=\"\"),0,I4)","v":0}]
[5,"",""]
[6,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White","African American","Latino","Asian American","Native American","Multiracial","Non White Combined"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage Students ",{"$f":"C8","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage Teachers ",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Parity Gap",{"$f":"IF(OR(C2=\"\",C3=\"\"),\"\",C4)","v":""},"","","","","",0]

{"sheet":"scratch","index":3,"n_rows":17,"n_cols":36,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["*** This sheet to remain hidden ***"]
[]
[]
[]
[]
[]
[null,"Average Y:",{"$f":"AVERAGE(AD13:AE13)","v":{"$error":"#REF!"}}]
[]
[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,null,null,null,null,{"$f":"AA12/2+8+50","v":{"$error":"#REF!"}}]
[null,null,null,null,"Percentages Series & Labels",null,null,null,null,"Stage Totals & Labels",null,null,null,null,"Lost Totals & Labels",null,null,null,null,"Unqualified Total & Label",null,null,null,null,"Edges"]
[null,"Stage","x",null,"Offsets",null,0.45,{"$f":"3.85%*C7","v":{"$error":"#REF!"}},null,"Offsets",null,0.45,{"$f":"-3.85%*C7","v":{"$error":"#REF!"}},null,"Offsets",null,0.45,{"$f":"-19.2%*C7","v":{"$error":"#REF!"}},null,"Offsets",null,0.45,{"$f":"-25.7%*C7","v":{"$error":"#REF!"}},null,1.8,null,null,null,null,{"$f":"AD12-8","v":{"$error":"#REF!"}},{"$f":"AE12+8","v":{"$error":"#REF!"}}]
[null,"Rim",null,null,"Label","Value","x","y",null,"Label","Value","x","y",null,"Label","Value","x","y",null,"Label","Value","x","y",null,2,null,{"$f":"K13","v":{"$error":"#REF!"}},"Identified",null,{"$f":"-AA12/2+$AD$9","v":{"$error":"#REF!"}},{"$f":"AA12/2+$AD$9","v":{"$error":"#REF!"}},null,{"$f":"AE12","v":{"$error":"#REF!"}},0,0,0]
[null,"Identified",2,null,{"$f":"F13","v":1},1,{"$f":"$C13+G$11","v":2.4500000000000002},{"$f":"$C$7+$H$11","v":{"$error":"#REF!"}},null,{"$f":"UPPER(B13)&\" \"&K13","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$C13+L$11","v":2.4500000000000002},{"$f":"$C$7+$M$11","v":{"$error":"#REF!"}},null,{"$f":"\"LOST \" & P13","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$C13+Q$11","v":2.4500000000000002},{"$f":"$C$7+$R$11","v":{"$error":"#REF!"}},null,{"$f":"\"UNQUALIFIED \"&U13","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$C13+V$11","v":2.4500000000000002},{"$f":"$C$7+$W$11","v":{"$error":"#REF!"}},null,{"$f":"Y12+1","v":3},null,null,"IDENTIFIED",null,{"$f":"-K13/2+$AD$9","v":{"$error":"#REF!"}},{"$f":"K13/2+$AD$9","v":{"$error":"#REF!"}},null,{"$f":"AE13","v":{"$error":"#REF!"}},{"$f":"AE13","v":{"$error":"#REF!"}},0,0]
[null,"Contacted",3,null,{"$f":"F14","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"$C14+G$11","v":3.45},{"$f":"$C$7+$H$11","v":{"$error":"#REF!"}},null,{"$f":"UPPER(B14)&\" \"&K14","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$C14+L$11","v":3.45},{"$f":"$C$7+$M$11","v":{"$error":"#REF!"}},null,{"$f":"\"LOST \" & P14","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$C14+Q$11","v":3.45},{"$f":"$C$7+$R$11","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"Y13+1","v":4},null,null,"CONTACTED",null,{"$f":"-K14/2+$AD$9","v":{"$error":"#REF!"}},{"$f":"K14/2+$AD$9","v":{"$error":"#REF!"}},null,null,{"$f":"AE14","v":{"$error":"#REF!"}},{"$f":"AE14","v":{"$error":"#REF!"}},0]
[null,"Discussion",4,null,{"$f":"F15","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"$C15+G$11","v":4.45},{"$f":"$C$7+$H$11","v":{"$error":"#REF!"}},null,{"$f":"UPPER(B15)&\" \"&K15","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$C15+L$11","v":4.45},{"$f":"$C$7+$M$11","v":{"$error":"#REF!"}},null,{"$f":"\"LOST \" & P15","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$C15+Q$11","v":4.45},{"$f":"$C$7+$R$11","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"Y14+1","v":5},null,null,"DISCUSSION",null,{"$f":"-K15/2+$AD$9","v":{"$error":"#REF!"}},{"$f":"K15/2+$AD$9","v":{"$error":"#REF!"}},null,null,null,{"$f":"AE15","v":{"$error":"#REF!"}},{"$f":"AE15","v":{"$error":"#REF!"}}]
[null,"Won",5,null,{"$f":"F16","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"$C16+G$11 - 0.1","v":5.3500000000000005},{"$f":"$C$7+$H$11","v":{"$error":"#REF!"}},null,{"$f":"UPPER(B16)","v":"WON"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$C16+L$11 -0.1","v":5.3500000000000005},{"$f":"$C$7+$M$11","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y15+1","v":6},null,null,"WON",null,{"$f":"-K16/2+$AD$9","v":{"$error":"#REF!"}},{"$f":"K16/2+$AD$9","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"AE16","v":{"$error":"#REF!"}}]
[null,"Won Dot",6,null,null,null,null,null,null,null,{"$f":"K16","v":{"$error":"#REF!"}},6.44,{"$f":"C7","v":{"$error":"#REF!"}}]