{"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":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,"White","Nonwhite","Percentage Chance 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,"Submitting Applications",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,"Passing Initial Screening",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,"Participating in District Interviews",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,"Participating in School Interviews",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,"Selected",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,"Accepted Offer",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,"3-Year Retention",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,"5-Year Retention",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":""}]
[]
[]
[]
[]
[]
[]
["Rank","Category","Gap Increase",null,null,null,null,"White","Nonwhite","Gap","Percent White","Percent Non White","Gap",null,"Rank","Category","Gap Increase"]
[1,{"$f":"IF(ISTEXT(P18),P18,\"\")","v":""},{"$f":"IF(ISNUMBER(Q18),Q18,\"\")","v":""},null,null,null,"Student Population",{"$f":"IF(C2=\"\",NA(),C2)","v":{"$error":"#N/A"}},{"$f":"IF(D2=\"\",NA(),D2)","v":{"$error":"#N/A"}},{"$f":"IF(OR(H18=\"\",I18=\"\"),\"\",H18-I18)","v":{"$error":"#N/A"}},{"$f":"IF(OR(H18=\"\",I18=\"\"),\"\",H18/(H18+I18))","v":{"$error":"#N/A"}},{"$f":"IF(OR(H18=\"\",I18=\"\"),\"\",I18/(I18+H18))","v":{"$error":"#N/A"}},{"$f":"K18-L18","v":{"$error":"#N/A"}},null,1,{"$f":"INDEX($B$2:$B$11,MATCH(Q18,$J$2:$J$11,0))","v":{"$error":"#NUM!"}},{"$f":"LARGE($J$2:$J$11,O18)","v":{"$error":"#NUM!"}}]
[2,{"$f":"IF(ISTEXT(P19),P19,\"\")","v":""},{"$f":"IF(ISNUMBER(Q19),Q19,\"\")","v":""},null,null,null,"Certified",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(OR(H19=\"\",I19=\"\"),\"\",H19/(H19+I19))","v":{"$error":"#N/A"}},{"$f":"IF(OR(H19=\"\",I19=\"\"),\"\",I19/(I19+H19))","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,2,{"$f":"INDEX($B$2:$B$11,MATCH(Q19,$J$2:$J$11,0))","v":{"$error":"#NUM!"}},{"$f":"LARGE($J$2:$J$11,O19)","v":{"$error":"#NUM!"}}]
[3,"","",null,null,null,"Submitting Applications",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,3,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[4,"","",null,null,null,"Passing Initial Screening",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,4,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[5,"","",null,null,null,"Participating in District Interviews",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,5,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[6,"","",null,null,null,"Participating in School Interviews",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,6,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[7,"","",null,null,null,"Selected",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,7,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[8,"","",null,null,null,"Accepted Offer",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,8,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,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,9,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[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":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,"Nonwhite","Percentage Change for Nonwhite"]
[null,"Student Population",{"$f":"IF('Development of Gaps'!D2=\"\",\"\",'Development of Gaps'!D2)","v":""},null,null,null,null,null,null,null,null,null,"Rank","Category","Gap Increase"]
[null,"Submitting Applications",{"$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,null,1,{"$f":"INDEX($B$3:$B$10,MATCH(O3,$D$3:$D$10,0))","v":{"$error":"#NUM!"}},{"$f":"SMALL($D$3:$D$10,M3)","v":{"$error":"#NUM!"}}]
[null,"Passing Initial Screening",{"$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,null,2,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"Participating in District Interviews",{"$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,null,3,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"Participating in School Interviews",{"$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,null,4,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"Selected",{"$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,null,5,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"Accepted Offer",{"$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,null,6,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"3-Year Retention",{"$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,null,7,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"5-Year Retention",{"$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,null,8,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,9,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,10,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,11,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,12,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,13,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Rank","Category","Gap Increase",null,null,null,null,null,null,null,null,null,14,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[1,{"$f":"IF(ISTEXT(N3),N3,\"\")","v":""},{"$f":"IF(ISNUMBER(O3),O3,\"\")","v":""},null,null,null,null,null,null,null,null,null,15,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[2,{"$f":"IF(ISTEXT(N4),N4,\"\")","v":""},{"$f":"IF(ISNUMBER(O4),O4,\"\")","v":""}]
[3,"",""]
[4,"",""]
[5,"",""]
[6,"",""]
[7,"",""]

{"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!"}}]