{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Basic Skills Calculator","Qualification Rules"],"not_rendered":{"macros":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Basic Skills Calculator","index":0,"n_rows":111,"n_cols":96,"rows_kept":111,"merged":[[3,2,3,14],[4,2,5,2],[4,3,5,3],[4,4,4,13],[4,14,5,14],[29,31,29,34],[29,36,29,39],[29,41,29,44],[29,46,29,49],[29,51,29,53],[29,55,29,58],[29,60,29,63],[29,65,29,95],[30,65,31,65],[30,66,30,74],[30,76,30,85],[30,86,30,95]]}
[]
[]
[]
[null,null,"PDE Basics Skills Certification Calculator  ver 11.0"]
[null,null,"My Tests","\nSelect PAPA\nTimeframe\nBelow","My Scores",{"$nulls":9}," Do I Qualify?"]
[{"$nulls":4},"  Reading"," Qualifies For Mixed\n Score Option",null,"  Mathematics"," Qualifies For Mixed\n Score Option",null,"  Writing"," Qualifies For Mixed\n Score Option",null,"  Total"]
[]
[null,null,"ACT - (09/01/2015 - 08/31/2016 Only)",null,null,{"$f":"IF(E8=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",BR34=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",BV34=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(H8=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CB34=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CF34=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(K8=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CL34=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CP34=\"Yes\"),\"Yes\",\"\")))","v":""},null,{"$f":"E8+H8+K8","v":0},{"$f":"IF(OR(AG40=\"Qualify\",AG42=\"Qualify\"),\"Yes\",\"No\")","v":"No"}]
[]
[null,null,"ACT - New  (09/01/2016 and Later)",null,null,{"$f":"IF(E10=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",BR46=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",BV46=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(H10=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CB46=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CF46=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(K10=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CL46=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CP46=\"Yes\"),\"Yes\",\"\")))","v":""},null,{"$f":"E10+H10+K10","v":0},{"$f":"IF(OR(AL40=\"Qualify\",AL42=\"Qualify\"),\"Yes\",\"No\")","v":"No"}]
[]
[null,null,"CORE Academic (Instructional)",null,null,{"$f":"IF(E12=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",BR36=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",BV36=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(H12=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CB36=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CF36=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(K12=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CL36=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CP36=\"Yes\"),\"Yes\",\"\")))","v":""},null,{"$f":"E12+H12+K12","v":0},{"$f":"IF(OR(AQ40=\"Qualify\",AQ42=\"Qualify\"),\"Yes\",\"No\")","v":"No"}]
[]
[null,null,"PAPA (Provide Date Info)","(Select Timeframe)",null,{"$f":"IF(E14=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",BR38=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",BV38=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(H14=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CB38=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CF38=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(K14=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CL38=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CP38=\"Yes\"),\"Yes\",\"\")))","v":""},null,{"$f":"E14+H14+K14","v":0},{"$f":"IF(AV40=\"Qualify\",\"Yes\",IF(AV42=\"Qualify\",\"Yes\",IF(AV44=\"Qualify\",\"Yes\",IF(AV48=\"Missing Date\",\"Missing Date\",IF(AV52=\"Date Error\",\"Missing Date\",\"No\")))))","v":"No"}]
[]
[null,null,"SAT - Old    (Prior to 03/01/2016)",null,null,{"$f":"IF(E16=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",BR40=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",BV40=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(H16=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CB40=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CF40=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(K16=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CL40=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CP40=\"Yes\"),\"Yes\",\"\")))","v":""},null,{"$f":"E16+H16+K16","v":0},{"$f":"IF(BA40=\"Qualify\",\"Yes\",\"No\")","v":"No"}]
[]
[null,null,"SAT - New  (03/01/2016 and Later)",null,null,{"$f":"IF(E18=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",BR42=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",BV42=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(H18=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CB42=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CF42=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CL42=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CP42=\"Yes\"),\"Yes\",\"\")))","v":""},null,{"$f":"E18+H18+K18","v":0},{"$f":"IF(OR(BE40=\"Qualify\",BE42=\"Qualify\"),\"Yes\",\"No\")","v":"No"}]
[]
[null,null,"  PPST (Praxis) (Instructional)",null,null,{"$f":"IF(E20=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",BR44=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",BV44=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(H20=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CB44=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CF44=\"Yes\"),\"Yes\",\"\")))","v":""},null,null,{"$f":"IF(K20=\"\",\"\",IF(AND($BP$51=\"Yes\",$BP$56=\"Yes\",CL44=\"Yes\"),\"Yes\",IF(AND($BP$51=\"Yes\",$BP$62=\"Yes\",CP44=\"Yes\"),\"Yes\",\"\")))","v":""},null,{"$f":"E20+H20+K20","v":0},{"$f":"IF(OR(BJ40=\"Qualify\",BJ42=\"Qualify\"),\"Yes\",\"No\")","v":"No"}]
[]
[null,null,"  Mixed Score Qualification Option:",{"$nulls":11},{"$f":"IF(BP51=\"No\",\"N/A\",IF(AND(BP51=\"Yes\",(OR(BP56=\"Yes\",BP62=\"Yes\"))),\"Yes\",\"No\"))","v":"N/A"},{"$nulls":57},{"$f":"LARGE(BU34:BU46,1)","v":{"$error":"#NUM!"}},{"$nulls":9},{"$f":"LARGE(CE34:CE46,1)","v":{"$error":"#NUM!"}},{"$nulls":9},{"$f":"LARGE(CO34:CO46,1)","v":{"$error":"#NUM!"}}]
[]
[{"$nulls":4},{"$f":"COUNT(E8:E20)","v":0},null,null,{"$f":"COUNT(H8:H20)","v":0},null,null,{"$f":"COUNT(K8:K20)","v":0}]
[]
[]
[]
[]
[]
[{"$nulls":31},"ACT (Old) Rules",{"$nulls":4},"ACT (New) Rules",{"$nulls":4},"CORE Academic  Rules (Effective 06/01/2014)",{"$nulls":4},"PAPA Rules",{"$nulls":4},"SAT (Old) Rules",{"$nulls":3},"SAT (New) Rules",{"$nulls":4},"PPST (Praxis)",{"$nulls":4},"Mixed Rules"]
[{"$nulls":31},"Passing","Min","Input","Composite",null,"Passing","Min","Input","Composite",null,"Passing","Min","Input","Composite",null,"Passing","Min","Input","Composite",null,"Passing","Input",null,null,"Passing","Input","Min","Composite",null,"Passing","Min","Input","Composite",null,"Test","Reading",{"$nulls":9},"Mathematics",{"$nulls":9},"Writing"]
[{"$nulls":31},"09/01/2015 - 08/31/2016",{"$nulls":4},"09/01/2016 and Later",{"$nulls":14},"Prior to 03/01/2016",{"$nulls":3},"03/01/2016 Forward",{"$nulls":10},"Actual","Required To Pass","Passing\n???","Passing\nQualifier Used","Minimum For\nComposite","Met The\nMinimum","Actual/Pass\nDifference","Composite\nQualifier Used","Composite\nActual","Composite\nRequired","Actual","Required To Pass","Passing\n???","Passing\nQualifier Used","Minimum For\nComposite","Met The\nMinimum","Actual/Pass\nDifference","Composite\nQualifier Used","Composite\nActual","Composite\nRequired","Actual","Required To Pass","Passing\n???","Passing\nQualifier Used","Minimum For\nComposite","Met The\nMinimum","Actual/Pass\nDifference","Composite\nQualifier Used","Composite\nActual","Composite\nMinimum"]
[{"$nulls":29},"Reading",null,22,20,{"$f":"E8","v":0},{"$f":"SUM(AF33+AF35+AF37)","v":64},null,22,20,{"$f":"E10","v":0},{"$f":"SUM(AK33+AK35+AK37)","v":51},null,156,148,{"$f":"E12","v":0},{"$f":"SUM(AP33+AP35+AP37)","v":460},null,220,193,{"$f":"E14","v":0},{"$f":"SUM(AU33+AU35+AU37)","v":633},null,500,{"$f":"E16","v":0},null,null,27,{"$f":"ROUNDDOWN(E18,0)","v":0},25,{"$f":"SUM(BD33+BD35+BD37)","v":81},null,172,169,{"$f":"E20","v":0},{"$f":"SUM(BI33+BI35+BI37)","v":518}]
[{"$nulls":65},"ACT (Old)",{"$f":"E8","v":0},{"$f":"AF33","v":22},{"$f":"IF(BO34>=BP34,\"Yes\",\"No\")","v":"No"},{"$f":"IF(BQ34=\"No\",\"\",IF(BQ34=\"Yes\",\"Yes\",\"No\"))","v":""},{"$f":"AG33","v":20},{"$f":"IF(BO34>=BS34,\"Yes\",\"No\")","v":"No"},{"$f":"IF(BT34=\"Yes\",BO34-BP34,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(BT34=\"No\",\"\",IF(BU34=BU22,\"Yes\",\"No\")))","v":""},{"$f":"IF(BV34=\"Yes\",BO34,\"\")","v":""},{"$f":"IF(BV34=\"Yes\",BP34,\"\")","v":""},{"$f":"H8","v":0},{"$f":"AF35","v":21},{"$f":"IF(BY34>=BZ34,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CA34=\"No\",\"\",IF(CA34=\"Yes\",\"Yes\",\"No\"))","v":""},{"$f":"AG35","v":19},{"$f":"IF(BY34>=CC34,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CD34=\"Yes\",BY34-BZ34,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CD34=\"No\",\"\",IF(CE34=CE22,\"Yes\",\"No\")))","v":""},{"$f":"IF(CF34=\"Yes\",BY34,\"\")","v":""},{"$f":"IF(CF34=\"Yes\",BZ34,\"\")","v":""},{"$f":"K8","v":0},{"$f":"AF37","v":21},{"$f":"IF(CI34>=CJ34,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CK34=\"No\",\"\",IF(CK34=\"Yes\",\"Yes\",\"No\"))","v":""},{"$f":"AG37","v":17},{"$f":"IF(CI34>=CM34,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CN34=\"Yes\",CI34-CJ34,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CN34=\"No\",\"\",IF(CO34=CO22,\"Yes\",\"No\")))","v":""},{"$f":"IF(CP34=\"Yes\",CI34,\"\")","v":""},{"$f":"IF(CP34=\"Yes\",CJ34,\"\")","v":""}]
[{"$nulls":29},"Mathematics",null,21,19,{"$f":"H8","v":0},null,null,21,19,{"$f":"H10","v":0},null,null,142,132,{"$f":"H12","v":0},null,null,193,{"$f":"IF(AV50=\"1\",174,176)","v":176},{"$f":"H14","v":0},null,null,500,{"$f":"H16","v":0},null,null,26,{"$f":"ROUNDDOWN(H18,0)","v":0},24,null,null,173,170,{"$f":"H20","v":0}]
[{"$nulls":65},"CORE Academic ",{"$f":"E12","v":0},{"$f":"AP33","v":156},{"$f":"IF(BO36>=BP36,\"Yes\",\"No\")","v":"No"},{"$f":"IF(BQ36=\"No\",\"\",IF(AND(BQ36=\"Yes\",BQ34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AQ33","v":148},{"$f":"IF(BO36>=BS36,\"Yes\",\"No\")","v":"No"},{"$f":"IF(BT36=\"Yes\",BO36-BP36,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(BT36=\"No\",\"\",IF(AND(BU36=BU22,BV34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(BV36=\"Yes\",BO36,\"\")","v":""},{"$f":"IF(BV36=\"Yes\",BP36,\"\")","v":""},{"$f":"H12","v":0},{"$f":"AP35","v":142},{"$f":"IF(BY36>=BZ36,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CA36=\"No\",\"\",IF(AND(CA36=\"Yes\",CA34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AQ35","v":132},{"$f":"IF(BY36>=CC36,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CD36=\"Yes\",BY36-BZ36,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CD36=\"No\",\"\",IF(AND(CE36=CE22,CF34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CF36=\"Yes\",BY36,\"\")","v":""},{"$f":"IF(CF36=\"Yes\",BZ36,\"\")","v":""},{"$f":"K12","v":0},{"$f":"AP37","v":162},{"$f":"IF(CI36>=CJ36,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CK36=\"No\",\"\",IF(AND(CK36=\"Yes\",CK34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AQ37","v":158},{"$f":"IF(CI36>=CM36,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CN36=\"Yes\",CI36-CJ36,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CN36=\"No\",\"\",IF(AND(CO36=CO22,CP34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CP36=\"Yes\",CI36,\"\")","v":""},{"$f":"IF(CP36=\"Yes\",CJ36,\"\")","v":""}]
[{"$nulls":29},"Writing",null,21,17,{"$f":"K8","v":0},null,null,8,7,{"$f":"K10","v":0},null,null,162,158,{"$f":"K12","v":0},null,null,220,192,{"$f":"K14","v":0},null,null,500,{"$f":"K16","v":0},null,null,28,{"$f":"ROUNDDOWN(K18,0)","v":0},26,null,null,173,170,{"$f":"K20","v":0}]
[{"$nulls":65},"PAPA ",{"$f":"E14","v":0},{"$f":"AU33","v":220},"No",{"$f":"IF(BQ38=\"No\",\"\",IF(AND(BQ38=\"Yes\",BQ36=\"No\",BQ34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AV33","v":193},{"$f":"IF(BO38>=BS38,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(BT38=\"No\",\"\",IF(AND(BU38=BU22,BV36<>\"Yes\",BV34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(BV38=\"Yes\",BO38,\"\")","v":""},{"$f":"IF(BV38=\"Yes\",BP38,\"\")","v":""},{"$f":"IF(H14>=176,H14,IF(AND(AV50=\"1\",H14>=174),H14,0))","v":0},{"$f":"AU35","v":193},{"$f":"IF(BY38>=BZ38,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CA38=\"No\",\"\",IF(AND(CA38=\"Yes\",CA36=\"No\",CA34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AV35","v":176},{"$f":"IF(BY38>=CC38,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CD38=\"Yes\",BY38-BZ38,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CD38=\"No\",\"\",IF(AND(CE38=CE22,CF36<>\"Yes\",CF34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CF38=\"Yes\",BY38,\"\")","v":""},{"$f":"IF(CF38=\"Yes\",BZ38,\"\")","v":""},{"$f":"K14","v":0},{"$f":"AU37","v":220},{"$f":"IF(CI38>=CJ38,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CK38=\"No\",\"\",IF(AND(CK38=\"Yes\",CK36=\"No\",CK34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AV37","v":192},{"$f":"IF(CI38>=CM38,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CN38=\"No\",\"\",IF(AND(CO38=CO22,CP36<>\"Yes\",CP34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CP38=\"Yes\",CI38,\"\")","v":""},{"$f":"IF(CP38=\"Yes\",CJ38,\"\")","v":""}]
[]
[{"$nulls":31},"Rule 1:  All Minimum Score Qualifier",{"$f":"IF(AND(E8>=AF33,H8>=AF35,K8>=AF37),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"Rule 1:  All Passing Score Qualifier",{"$f":"IF(AND(E10>=AK33,H10>=AK35,K10>=AK37),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"Rule 1:  All Passing Score Qualifier",{"$f":"IF(AND(E12>=AP33,H12>=AP35,K12>=AP37),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"Rule 1:  All Passing Score Qualifier",{"$f":"IF(AND(E14>=AU33,H14>=AU35,K14>=AU37),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"Rule 1:  All Passing Score Qualifier",{"$f":"IF(AND(E16>=AZ33,H16>=AZ35,K16>=AZ37),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},null,null,"Rule 1:  All Passing Score Qualifier",{"$f":"IF(AND(BE33>=BD33,BE35>=BD35,BE37>=BD37),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"Rule 1:  All Passing Score Qualifier",{"$f":"IF(AND(E20>=BI33,H20>=BI35,K20>=BI37),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"SAT - Old",{"$f":"E16","v":0},{"$f":"AZ33","v":500},"No",{"$f":"IF(BQ40=\"No\",\"\",IF(AND(BQ40=\"Yes\",BQ38=\"No\",BQ36=\"No\",BQ34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AZ33","v":500},{"$f":"IF(BO40>=BS40,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(BT40=\"No\",\"\",IF(AND(BU40=BU22,BV38<>\"Yes\",BV36<>\"Yes\",BV34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(BV40=\"Yes\",BO40,\"\")","v":""},{"$f":"IF(BV40=\"Yes\",BP40,\"\")","v":""},{"$f":"H16","v":0},{"$f":"AZ35","v":500},{"$f":"IF(BY40>=BZ40,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CA40=\"No\",\"\",IF(AND(CA40=\"Yes\",CA38=\"No\",CA36=\"No\",CA34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AZ35","v":500},{"$f":"IF(BY40>=CC40,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CD40=\"Yes\",BY40-BZ40,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CD40=\"No\",\"\",IF(AND(CE40=CE22,CF38<>\"Yes\",CF36<>\"Yes\",CF34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CF40=\"Yes\",BY40,\"\")","v":""},{"$f":"IF(CF40=\"Yes\",BZ40,\"\")","v":""},{"$f":"K16","v":0},{"$f":"AZ37","v":500},{"$f":"IF(CI40>=CJ40,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CK40=\"No\",\"\",IF(AND(CK40=\"Yes\",CK38=\"No\",CK36=\"No\",CK34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AZ37","v":500},{"$f":"IF(CI40>=CM40,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CN40=\"No\",\"\",IF(AND(CO40=CO22,CP38<>\"Yes\",CP36<>\"Yes\",CP34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CP40=\"Yes\",CI40,\"\")","v":""},{"$f":"IF(CP40=\"Yes\",CJ40,\"\")","v":""}]
[]
[{"$nulls":31},"Rule 2: Composite Score Qualifier",{"$f":"IF(AND(E8>=AG33,H8>=AG35,K8>=AG37,N8>=AI33),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"Rule 2: Composite Score Qualifier",{"$f":"IF(AND(E10>=AL33,H10>=AL35,K10>=AL37,N10>=AN33),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"Rule 2: Composite Score Qualifier",{"$f":"IF(AND(E12>=AQ33,H12>=AQ35,K12>=AQ37,N12>=AS33),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"Rule 2: Composite Score Qualifier (Math >=176)",{"$f":"IF(AND(E14>=AV33,H14>=176,K14>=AV37,N14>=AX33),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":7},"Rule 2: Composite Score Qualifier",{"$f":"IF(AND(BE33>=BF33,BE35>=BF35,BE37>=BF37,N18>=BG33),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"Rule 2: Composite Score Qualifier",{"$f":"IF(AND(E20>=BJ33,H20>=BJ35,K20>=BJ37,N20>=BL33),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":3},"SAT - New",{"$f":"ROUNDDOWN(E18,0)","v":0},{"$f":"BD33","v":27},"No",{"$f":"IF(BQ42=\"No\",\"\",IF(AND(BQ42=\"Yes\",BQ40=\"No\",BQ38=\"No\",BQ36=\"No\",BQ34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"BF33","v":25},{"$f":"IF(BO42>=BS42,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(BT42=\"No\",\"\",IF(AND(BU42=BU22,BV40<>\"Yes\",BV38<>\"Yes\",BV36<>\"Yes\",BV34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(BV42=\"Yes\",BO42,\"\")","v":""},{"$f":"IF(BV42=\"Yes\",BP42,\"\")","v":""},{"$f":"ROUNDDOWN(H18,0)","v":0},{"$f":"BD35","v":26},{"$f":"IF(BY42>=BZ42,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CA42=\"No\",\"\",IF(AND(CA42=\"Yes\",CA40=\"No\",CA38=\"No\",CA36=\"No\",CA34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"BF35","v":24},{"$f":"IF(BY42>=CC42,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CD42=\"Yes\",BY42-BZ42,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CD42=\"No\",\"\",IF(AND(CE42=CE22,CF40<>\"Yes\",CF38<>\"Yes\",CF36<>\"Yes\",CF34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CF42=\"Yes\",BY42,\"\")","v":""},{"$f":"IF(CF42=\"Yes\",BZ42,\"\")","v":""},{"$f":"ROUNDDOWN(K18,0)","v":0},{"$f":"BD37","v":28},{"$f":"IF(CI42>=CJ42,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CK42=\"No\",\"\",IF(AND(CK42=\"Yes\",CK40=\"No\",CK38=\"No\",CK36=\"No\",CK34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"BF37","v":26},{"$f":"IF(CI42>=CM42,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CN42=\"No\",\"\",IF(AND(CO42=CO22,CP40<>\"Yes\",CP38<>\"Yes\",CP36<>\"Yes\",CP34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CP42=\"Yes\",CI42,\"\")","v":""},{"$f":"IF(CP42=\"Yes\",CJ42,\"\")","v":""}]
[]
[{"$nulls":46},"Rule 3: Composite Score Qualifier (Math >174 w/date)",{"$f":"IF(AND(AV50=\"1\",E14>=AV33,H14>=174,K14>=AV37,N14>=AX33),\"Qualify\",\"Does Not Qualify\")","v":"Does Not Qualify"},{"$nulls":4},{"$f":"LEFT(D16,1)","v":""},{"$nulls":12},"PPST (Praxis)",{"$f":"E20","v":0},{"$f":"BI33","v":172},{"$f":"IF(BO44>=BP44,\"Yes\",\"No\")","v":"No"},{"$f":"IF(BQ44=\"No\",\"\",IF(AND(BQ44=\"Yes\",BQ42=\"No\",BQ40=\"No\",BQ38=\"No\",BQ36=\"No\",BQ34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"BJ33","v":169},{"$f":"IF(BO44>=BS44,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(BT44=\"No\",\"\",IF(AND(BU44=BU22,BV42<>\"Yes\",BV40<>\"Yes\",BV38<>\"Yes\",BV36<>\"Yes\",BV34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(BV44=\"Yes\",BO44,\"\")","v":""},{"$f":"IF(BV44=\"Yes\",BP44,\"\")","v":""},{"$f":"H20","v":0},{"$f":"BI35","v":173},{"$f":"IF(BY44>=BZ44,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CA44=\"No\",\"\",IF(AND(CA44=\"Yes\",CA42=\"No\",CA40=\"No\",CA38=\"No\",CA36=\"No\",CA34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"BJ35","v":170},{"$f":"IF(BY44>=CC44,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CD44=\"Yes\",BY44-BZ44,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CD44=\"No\",\"\",IF(AND(CE44=CE22,CF42<>\"Yes\",CF40<>\"Yes\",CF38<>\"Yes\",CF36<>\"Yes\",CF34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CF44=\"Yes\",BY44,\"\")","v":""},{"$f":"IF(CF44=\"Yes\",BZ44,\"\")","v":""},{"$f":"K20","v":0},{"$f":"BI37","v":173},{"$f":"IF(CI44>=CJ44,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CK44=\"No\",\"\",IF(AND(CK44=\"Yes\",CK42=\"No\",CK40=\"No\",CK38=\"No\",CK36=\"No\",CK34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"BJ37","v":170},{"$f":"IF(CI44>=CM44,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CN44=\"No\",\"\",IF(AND(CO44=CO22,CP42<>\"Yes\",CP40<>\"Yes\",CP38<>\"Yes\",CP36<>\"Yes\",CP34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CP44=\"Yes\",CI44,\"\")","v":""},{"$f":"IF(CP44=\"Yes\",CJ44,\"\")","v":""}]
[]
[{"$nulls":65},"ACT - (New)",{"$f":"E10","v":0},{"$f":"AK33","v":22},"No",{"$f":"IF(BQ46=\"No\",\"\",IF(AND(BQ46=\"Yes\",BQ44=\"No\",BQ42=\"No\",BQ40=\"No\",BQ38=\"No\",BQ36=\"No\",BQ34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AL33","v":20},{"$f":"IF(BO46>=BS46,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(BT46=\"No\",\"\",IF(AND(BU46=BU22,BV44<>\"Yes\",BV42<>\"Yes\",BV40<>\"Yes\",BV38<>\"Yes\",BV36<>\"Yes\",BV34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(BV46=\"Yes\",BO46,\"\")","v":""},{"$f":"IF(BV46=\"Yes\",BP46,\"\")","v":""},{"$f":"H10","v":0},{"$f":"AK35","v":21},"No",{"$f":"IF(CA46=\"No\",\"\",IF(AND(CA46=\"Yes\",CA44=\"No\",CA42=\"No\",CA40=\"No\",CA38=\"No\",CA36=\"No\",CA34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AL35","v":19},{"$f":"IF(BY46>=CC46,\"Yes\",\"No\")","v":"No"},{"$f":"IF(CD46=\"Yes\",BY46-BZ46,\"Skip\")","v":"Skip"},{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CD46=\"No\",\"\",IF(AND(CE46=CE22,CF44<>\"Yes\",CF42<>\"Yes\",CF40<>\"Yes\",CF38<>\"Yes\",CF36<>\"Yes\",CF34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CF46=\"Yes\",BY46,\"\")","v":""},{"$f":"IF(CF46=\"Yes\",BZ46,\"\")","v":""},{"$f":"K10","v":0},{"$f":"AK37","v":8},"No",{"$f":"IF(CK46=\"No\",\"\",IF(AND(CK46=\"Yes\",CK44=\"No\",CK42=\"No\",CK40=\"No\",CK38=\"No\",CK36=\"No\",CK34=\"No\"),\"Yes\",\"No\"))","v":""},{"$f":"AL37","v":7},{"$f":"IF(CI46>=CM46,\"Yes\",\"No\")","v":"No"},"Skip",{"$f":"IF(BP56=\"Yes\",\"NA\",IF(CN46=\"No\",\"\",IF(AND(CO46=CO22,CP44<>\"Yes\",CP42<>\"Yes\",CP40<>\"Yes\",CP38<>\"Yes\",CP36<>\"Yes\",CP34<>\"Yes\"),\"Yes\",\"No\")))","v":""},{"$f":"IF(CP46=\"Yes\",CI46,\"\")","v":""},{"$f":"IF(CP46=\"Yes\",CJ46,\"\")","v":""}]
[]
[{"$nulls":46},"Rule 4: Composite Score Qualifier (Math >174 w/no date)",{"$f":"IF(OR(AV50=\"1\",AV50=\"2\"),\"Skip\",IF(AND(E14>=AV33,H14>=174,K14>=AV37,N14>=AX33),\"Missing Date\",\"Skip\"))","v":"Skip"}]
[{"$nulls":65},"1. Is There a Single Test Qualification?",null,{"$f":"IF(OR(O8=\"Yes\",O10=\"Yes\",O12=\"Yes\",O14=\"Yes\",O16=\"Yes\",O18=\"Yes\",O20=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":46},"Exception Date for Formula:",{"$f":"LEFT(D14,1)","v":"("},{"$f":"IF(AND(OR(AV50=\"\",AV50=\"(\"),N14>=AX33),\"Date Error\",\"\")","v":""},{"$nulls":16},"2.  At Least One Score for Each Subject?",null,{"$f":"IF(AND(E24>0,H24>0,K24>0),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":65},"3.  Is Mix Score Usable?",null,{"$f":"IF(BP49=\"Yes\",\"No\",IF(BP50=\"Yes\",\"Yes\",\"No\"))","v":"No"}]
[{"$nulls":46},"Rule 5:  Mixed Composite Score Qualifier (Math >174 w/no date)",{"$f":"IF(AND(BP58=\"Yes\",BP59=\"No\",BP60=\"Yes\",BP61=\"Yes\",H14>=174,AV50<>\"1\",AV50<>\"2\"),\"Date Error\",\"Skip\")","v":"Skip"}]
[{"$nulls":65},"4.  Is There a Passing Reading Qualifier?",null,{"$f":"IF(OR(BR34=\"Yes\",BR36=\"Yes\",BR38=\"Yes\",BR40=\"Yes\",BR42=\"Yes\",BR44=\"Yes\",BR46=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":65},"5.  Is There a Passing Math Qualifier?",null,{"$f":"IF(OR(CB34=\"Yes\",CB36=\"Yes\",CB38=\"Yes\",CB40=\"Yes\",CB42=\"Yes\",CB44=\"Yes\",CB46=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":65},"6.  Is There a Passing Writing Qualifier?",null,{"$f":"IF(OR(CL34=\"Yes\",CL36=\"Yes\",CL38=\"Yes\",CL40=\"Yes\",CL42=\"Yes\",CL44=\"Yes\",CL46=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":65},"7.  Is There an Overall Mixed Passing Qualifier?",null,{"$f":"IF(AND(BP53=\"Yes\",BP54=\"Yes\",BP55=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[]
[{"$nulls":65},"8.  Is There a Composite Reading Qualifier?",null,{"$f":"IF(OR(BV34=\"Yes\",BV36=\"Yes\",BV38=\"Yes\",BV40=\"Yes\",BV42=\"Yes\",BV44=\"Yes\",BV46=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":65},"9.  Is There a Composite Math Qualifier?",null,{"$f":"IF(OR(CF34=\"Yes\",CF36=\"Yes\",CF38=\"Yes\",CF40=\"Yes\",CF42=\"Yes\",CF44=\"Yes\",CF46=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":65},"10.  Is There a Composite Writing Qualifier?",null,{"$f":"IF(OR(CP34=\"Yes\",CP36=\"Yes\",CP38=\"Yes\",CP40=\"Yes\",CP42=\"Yes\",CP44=\"Yes\",CP46=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[{"$nulls":65},"11.  Does Actual Total Meet Required Composite Total?",null,{"$f":"IF(BQ69>=BR69,\"Yes\",\"No\")","v":"Yes"}]
[{"$nulls":65},"12.  Is There an Overall Mixed Composite Qualifier?",null,{"$f":"IF(AND(BP58=\"Yes\",BP59=\"Yes\",BP60=\"Yes\",BP61=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[]
[]
[{"$nulls":65},"Composite Calculation:",null,null,"Actual","Required Passing/Minimum"]
[{"$nulls":65},"  Reading",null,null,{"$f":"SUM(BW34:BW46)","v":0},{"$f":"SUM(BX34:BX46)","v":0}]
[{"$nulls":65},"  Mathematics",null,null,{"$f":"SUM(CG34:CG46)","v":0},{"$f":"SUM(CH34:CH46)","v":0}]
[{"$nulls":65},"  Writing",null,null,{"$f":"SUM(CQ34:CQ46)","v":0},{"$f":"SUM(CR34:CR46)","v":0}]
[{"$nulls":65},"  Total",null,null,{"$f":"SUM(BQ66:BQ68)","v":0},{"$f":"SUM(BR66:BR68)","v":0}]
{"$rows_empty":38}
[null,null,"PAPA Dates"]
[null,null,"(Select Timeframe)"]
[null,null,"1.  Prior to 08/31/2016."]
[null,null,"2.  08/31/2016 or Later."]

{"sheet":"Qualification Rules","index":1,"n_rows":97,"n_cols":6,"rows_kept":97,"merged":[[2,2,2,5],[4,2,4,5],[7,2,7,5],[91,3,91,5]]}
[]
[]
[null,null,"PDE Basic Skills Assessment Options"]
[]
[null,null,"   Basic Skills Assessments – Mixed Score Option"]
[]
[null,null,"1.  If scores for all three Subjects meet the applicable Passing requirement for the respective test(s)."]
[null,null,"2.  If scores meet the Passing/Minimum score for the respective Test/Subject and the total of those is greater than or equal to the sum of Passing requirements for the individual Test/Subject."]
[]
[null,null,"I.  ACT "]
[null,null,"Test Name",null,"Passing Score","Minimum Composite Score"]
[null,null,"Between September 1, 2015 And August 31, 2016:  (Score Range:  1 - 36)"]
[null,null,"Reading",null,22,20]
[null,null,"Mathematics",null,21,19]
[null,null,"Writing",null,21,17]
[null,null,"Total For Composite Calculation",null,{"$f":"SUM(E13:E15)","v":64}]
[]
[null,null,"Composite Score Method for ACT Tests: (September 1, 2015 - 8/31/2016)"]
[null,null,"If the sum of your reading, mathematics and writing modules total 64 or higher AND each "]
[null,null,"module’s score meets the minimum composite score above you meet the basic skills"]
[null,null,"requirement."]
[]
[null,null,"September 1, 2016 And Later:"]
[null,null,"Reading  (Score Range:  1 - 36)",null,22,20]
[null,null,"Mathematics  (Score Range:  1 - 36)",null,21,19]
[null,null,"Writing (Score Range:  2 - 12)",null,8,7]
[null,null,"Total For Composite Calculation",null,{"$f":"SUM(E24:E26)","v":51}]
[]
[null,null,"Composite Score Method for ACT Tests: (September 1, 2016 And Later Only)"]
[null,null,"If the sum of your reading, mathematics and writing modules total 51 or higher AND each "]
[null,null,"module’s score meets the minimum composite score above you meet the basic skills"]
[null,null,"requirement."]
[]
[null,null,"II. CORE Academic (For Instructional Certifications)"]
[null,null,"Test Name","Test Number","Passing Score","Minimum Composite Score"]
[null,null,"  (Score Range:  100 - 200)"]
[null,null,"Reading",5712,156,148]
[null,null,"Mathematics",5732,142,132]
[null,null,"Writing",5722,162,158]
[null,null,"Total For Composite Calculation",null,{"$f":"SUM(E37:E39)","v":460}]
[]
[null,null,"Composite Score Method for CORE Tests:"]
[null,null,"If the sum of your reading, mathematics and writing modules total 460 or higher AND each "]
[null,null,"module’s score meets the minimum composite score above you meet the basic skills"]
[null,null,"requirement."]
[]
[]
[]
[]
[null,null,"III. PAPA"]
[null,null,"Test Name","Test Number","Passing Score","Minimum Composite Score"]
[null,null,"  (Score Range:  100 - 300)"]
[null,null,"Reading",8001,220,193]
[null,null,"Mathematics",8002,193,"176*"]
[null,null,"Writing",8003,220,192]
[null,null,"Total For Composite Calculation",null,{"$f":"SUM(E53:E55)","v":633}]
[]
[null,null,"Composite Score Method for PAPA Tests:"]
[null,null,"If the sum of your reading, mathematics and writing modules total 633 or higher AND each "]
[null,null,"module’s score meets the minimum composite score above you meet the basic skills"]
[null,null,"requirement."]
[null,null,"  *We will accept 174 from candidates accepted into an educator certification program "]
[null,null,"  prior to 8/31/2016"]
[]
[null,null,"IV.  SAT"]
[null,null,"Test Name",null,"Passing Score","Minimum Composite Score"]
[null,null,"Prior to March 1, 2016:  (Score Range:  200 - 800)"]
[null,null,"Critical Reading",null,500,"N/A"]
[null,null,"Mathematics",null,500,"N/A"]
[null,null,"Writing",null,500,"N/A"]
[]
[null,null,"March 1, 2016 And Later:  (Score Range:  10 - 40)"]
[null,null,"Critical Reading",null,27,25]
[null,null,"Mathematics",null,26,24]
[null,null,"Writing and Language",null,28,26]
[null,null,"Total For Composite Calculation",null,{"$f":"SUM(E73:E75)","v":81}]
[]
[null,null,"Composite Score Method for SAT Tests: (March 1, 2016 And Later Only)"]
[null,null,"If the sum of your reading, mathematics and writing modules total 81 or higher AND each "]
[null,null,"module’s score meets the minimum composite score above you meet the basic skills"]
[null,null,"requirement."]
[]
[]
[]
[null,null,"V.  PPST (Praxis)"]
[null,null,"Test Name","Test Number","Passing Score","Minimum Composite Score"]
[null,null,"  (Score Range:  150 - 190)"]
[null,null,"PPST Computerized Reading",5713,172,169]
[null,null,"PPST Computerized Writing",5723,173,170]
[null,null,"PPST Computerized Mathematics",5733,173,170]
[null,null,"Total For Composite Calculation",null,{"$f":"SUM(E88:E90)","v":518}]
[]
[]
[null,null,"Composite Score Method for PPST Tests:"]
[null,null,"If the sum of your reading, mathematics and writing modules total 518 or higher AND each "]
[null,null,"module’s score meets the minimum composite score above you meet the basic skills"]
[null,null,"requirement."]