Spreadsheet: 89674d1289433137-data-validation-list-blake-7-sumproduct-for-forum
Sheet: Scenario

Course Title | Starts (total) | Completing | Achievements | [NAME] | Achievement % | Success %
Business & Finance L1 (Literacy qual) 16-18 (Nov Start) |  |  |  |  |  |  | Hi there, I would like this table to be a scenario table. |  |  |  |  | Course Title | Starts (total) | Completing | Achievements | [NAME] | Achievement % | Success %
 |  |  |  |  |  |  | The data source is sheet "AFS data sheet" matrix c74:I125 |  |  |  |  | Business & Finance L1 (Literacy qual) 16-18 (Nov Start) | 16 | 14 | 12 | 0.875 | 0.8571428571428571 | 0.75
 |  |  |  |  |  |  | I would like to be able to deduct course title in order |  |  |  |  | Zeroed Business & Finance L1 (Literacy qual) 16-18 (Nov Start) | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | to see the effect in rows 53,54,55 |  |  |  |  | Cert in Personal Finance | 17 | 15 | 15 | 0.8823529411764706 | 1 | 0.8823529411764706
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] in Personal Finance | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | I was thinking of a drop down list from A2:A52 whereby |  |  |  |  | [NAME] in WorkSkills (E3) | 6 | 6 | 6 | 1 | 1 | 1
 |  |  |  |  |  |  | I could choos between "empty" which would deduct
 |  |  |  |  |  |  | the figures in cols b to g, or the course title which would include |  |  |  |  | YEHE - Humanities Yr1 | 23 | 21 | 21 | 0.9130434782608695 | 1 | 0.9130434782608695
 |  |  |  |  |  |  | the fighures in cols b to g
 |  |  |  |  |  |  |  |  |  |  |  | YEHE - Humanities Yr2 | 14 | 14 | 13 | 1 | 0.9285714285714286 | 0.9285714285714286
 |  |  |  |  |  |  | see table here ------------------------------------------------------------->
 |  |  |  |  |  |  |  |  |  |  |  | GCSE English (Eve) | 30 | 25 | 25 | 0.8333333333333334 | 1 | 0.8333333333333334
 |  |  |  |  |  |  |  |  |  |  |  | GCSE Maths (Day) | 41 | 28 | 25 | 0.6829268292682927 | 0.8928571428571429 | 0.6097560975609756
 |  |  |  |  |  |  |  |  |  |  |  | GCSE Maths (Eve) | 59 | 44 | 42 | 0.7457627118644068 | 0.9545454545454546 | 0.711864406779661
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Comms - Day L1 - Non Cert | 42 | 31 | 31 | 0.7380952380952381 | 1 | 0.7380952380952381
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Comms - Day L1 (Prog From Above) | 28 | 28 | 23 | 1 | 0.8214285714285714 | 0.8214285714285714
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Comms - Day E3 (Infill) | 0 | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Comms - Evn L1 - Non Cert | 40 | 29 | 29 | 0.725 | 1 | 0.725
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Comms - Evn L1 (Prog From Above) | 30 | 28 | 17 | 0.9333333333333333 | 0.6071428571428571 | 0.5666666666666667
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Comms - Eve E3 (Infill) | 0 | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Comms - Evn L2 - Non Cert | 17 | 16 | 16 | 0.9411764705882353 | 1 | 0.9411764705882353
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Comms - Evn L2 (Prog From Above) | 13 | 12 | 8 | 0.9230769230769231 | 0.6666666666666666 | 0.6153846153846154
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Comms - Eve L1 (Infill) | 0 | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  | Literacy E1 (Non Cert)- Day | 16 | 15 | 15 | 0.9375 | 1 | 0.9375
 |  |  |  |  |  |  |  |  |  |  |  | Literacy E1- Day (Prog From Above) | 18 | 18 | 0 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Literacy E2 (Non Cert) - Day | 16 | 12 | 12 | 0.75 | 1 | 0.75
 |  |  |  |  |  |  |  |  |  |  |  | Literacy E2 - Day (Prog From Above) | 12 | 11 | 11 | 0.9166666666666666 | 1 | 0.9166666666666666
 |  |  |  |  |  |  |  |  |  |  |  | Literacy E3 (Non Cert) - Day | 19 | 17 | 17 | 0.8947368421052632 | 1 | 0.8947368421052632
 |  |  |  |  |  |  |  |  |  |  |  | Literacy E3 - Day (Prog From Above) | 22 | 19 | 17 | 0.8636363636363636 | 0.8947368421052632 | 0.7727272727272727
 |  |  |  |  |  |  |  |  |  |  |  | Literacy E3 (Non Cert) - Day (Feb start) | 5 | 3 | 3 | 0.6 | 1 | 0.6
 |  |  |  |  |  |  |  |  |  |  |  | Literacy E3 (Non Cert) - Eve | 16 | 15 | 15 | 0.9375 | 1 | 0.9375
REVISED TOTAL |  |  |  |  |  |  |  |  |  |  |  | Literacy E3 - Eve (Prog From Above) | 12 | 12 | 8 | 1 | 0.6666666666666666 | 0.6666666666666666
ORIGINAL TOTAL
DIFFERENCE |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Nums - Evn E3 - Non Cert | 18 | 16 | 16 | 0.8888888888888888 | 1 | 0.8888888888888888
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Nums - Evn E3 (Prog From Above) | 9 | 9 | 7 | 1 | 0.7777777777777778 | 0.7777777777777778
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Nums - Evn L1 |(Infill) | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Nums - Evn L1 - Non Cert | 20 | 17 | 17 | 0.85 | 1 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Nums - Evn L1 (Prog From Above) | 17 | 15 | 13 | 0.8823529411764706 | 0.8666666666666667 | 0.7647058823529411
 |  |  |  |  |  |  |  |  |  |  |  | Essential Skills Nums - Evn E3 |(Infill) | 2 | 1 | 1 | 0.5 | 1 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Non Cert) - Eve | 18 | 11 | 11 | 0.6111111111111112 | 1 | 0.6111111111111112
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Prog From Above) | 11 | 10 | 8 | 0.9090909090909091 | 0.8 | 0.7272727272727273
 |  |  |  |  |  |  |  |  |  |  |  | Numeracy E3 (Non Cert) - Day | 16 | 12 | 12 | 0.75 | 1 | 0.75
 |  |  |  |  |  |  |  |  |  |  |  | Numeracy E3  -Day (Prog From Above) | 14 | 13 | 11 | 0.9285714285714286 | 0.8461538461538461 | 0.7857142857142857
 |  |  |  |  |  |  |  |  |  |  |  | Numeracy E3 (Non Cert) - Day (Feb start) | 5 | 5 | 5 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Adult Learners (Foundation) Literacy CG E1/2 | 13 | 8 | 8 | 0.6153846153846154 | 1 | 0.6153846153846154
 |  |  |  |  |  |  |  |  |  |  |  | Adult Learners (Foundation) Literacy CG E1/E2 | 15 | 14 | 11 | 0.9333333333333333 | 0.7857142857142857 | 0.7333333333333333
 |  |  |  |  |  |  |  |  |  |  |  | Adult Learners (Foundation) Literacy CG E3/L1 | 28 | 20 | 14 | 0.7142857142857143 | 0.7 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | Adult Learners (Intermediate) Literacy CG E3/L1 | 20 | 19 | 6 | 0.95 | 0.3157894736842105 | 0.3
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Advanced) Literacy CG L2 | 24 | 18 | 9 | 0.75 | 0.5 | 0.375
 |  |  |  |  |  |  |  |  |  |  |  | Cert In British Sign Language CACDP | 29 | 24 | 15 | 0.8275862068965517 | 0.625 | 0.5172413793103449
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Skills Upgrade) | 11 | 9 | 9 | 0.8181818181818182 | 1 | 0.8181818181818182
 |  |  |  |  |  |  |  |  |  |  |  | BASIC IT ENTRY (FDN SKILLS) w=ABE | 2 | 2 | 2 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  | BASIC LIT CG ENTRY (FDN SKILLS) w=S4L | 6 | 6 | 6 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  | BASIC NUM CG ENTRY (FDN SKILLS) w=S4L | 33 | 32 | 27 | 0.9696969696969697 | 0.84375 | 0.8181818181818182
 |  |  |  |  |  |  |  |  |  |  |  | BASIC NUM EDEXCEL L1 (FDN SKILLS) w=S4L | 61 | 59 | 44 | 0.9672131147540983 | 0.7457627118644068 | 0.7213114754098361
 |  |  |  |  |  |  |  |  |  |  |  | BASIC NUM EDEXCEL L2 (FDN SKILLS) w=S4L | 23 | 23 | 13 | 1 | 0.5652173913043478 | 0.5652173913043478
 |  |  |  |  |  |  |  |  |  |  |  | BASIC LIT EDEXCEL L1 (FDN SKILLS) w=S4L | 33 | 32 | 22 | 0.9696969696969697 | 0.6875 | 0.6666666666666666
 |  |  |  |  |  |  |  |  |  |  |  | BASIC LIT EDEXCEL L2 (FDN SKILLS) w=S4L | 17 | 16 | 8 | 0.9411764705882353 | 0.5 | 0.4705882352941176
 |  |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL | 958 | 825 | 677 | 0.8611691022964509 | 0.8206060606060606 | 0.7066805845511482