Spreadsheet: 130798d1322585344-score-card-using-nested-if-and-then-statements-scoringmetric
Sheet: Sheet1

Part 1 | Pass?
Element A
Factor 1* | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Percentage Met | 1
SubScore | 0
Logic | 100%: met all 4 factors
 | 75%: met 3 factors, including factor 1
 | 50%: met 2 factors, including factor 1
 | 25%: met factor 1
 | 0%: met no factors or does not meet factor 1
Element B
Factor 1 | Y
Factor 2 | Y
Factor 3* | Y
Factor 4 | Y
Factor 5 | Y
Percentage Met
Subscore
Logic | 100%: met all 5 factors, including factor 3
 | 75%: met 4 factors, including factor 3
 | 50%: met 3 factors, including factor 3
 | 25%: met 1-2 factors or met 3-4 factors but not factor 3
 | 0%: meets no factor
 | *Factor 3 must be met to score higher than 25% on this element
Element C | 2
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Percentage Met
Subscore
Logic | 100%: met 5-6 factors
 | 75%: met 3-4 factors
 | 50%: met 2 factors
 | 25%: met 1 factor
 | 0%: met 0 factors
Element D | 2
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Percentage Met
Subscore
Logic | 100% met all 3 factors
 | 75% no scoring option
 | 50% met 2 factors
 | 25% met 1 factor
 | 0% met no factor
Element E
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Percentage Met
Subscore
Logic | 100% met all 4 factors
 | 75% met 3 factors
 | 50% met 2 factors
 | 25% met 1 factor
 | 0% met no factors
Element G
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Factor 7 | Y
Factor 8 | Y
Percentage Met
Subscore
Logic | Factor 2 must be met to score higher than 25% on this element
 | 100% met 7-8 factors, including factor 2
 | 75% met 5-6 factors, including factor 2
 | 50%, met 4 factors, including factor 2
 | 25% met 2-3 factors or meets 3-7 factors but not factor 2
 | 0% practice meets 0-1 factors
Part 2
Element A
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Factor 7 | Y
Factor 8 | Y
Factor 9 | Y
Factor 10 | Y
Factor 11 | Y
Factor 12 | Y
Percentage Met
Subscore
Logic | 100% meets 9-12 factors
 | 75% meets 7-8 factors
 | 50% meets 5-6 factors
 | 25% meets 3-4 factors
 | 0% meets 0-2 factors
Element B
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Factor 7 | Y
Factor 8 | Y
Factor 9 | Y
Percentage Met
Subscore
Logic | 100% met all 9 factors
 | 75% met 7-8 factors
 | 50% met 5-6 factors
 | 25% met 3-4 factors
 | 0% 0-2 factors
Element C
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Factor 7 | Y
Factor 8 | Y
Factor 9 | Y
Percentage Met
Subscore
Logic | 100% met all 8-9 factors
 | 75% met 6-7 factors
 | 50% met 4-5 factors
 | 25% met 2-3 factors
 | 0% 0-1 factors
Element D
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Percentage Met
Subscore
Logic | 100% Meets all 4 factors
 | 75% meets 3 factors
 | 50% meets 2 factors
 | 25% meets 1 factor
 | 0% meets no factors
Part 3
Element A
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Percentage Met
Subscore
Logic | 100% meets all 3 factors
 | 75% no scoring option
 | 50% meets 2 factors, including factor 3
 | 25% meets 1 factor
 | 0% meets no factor
Element B
Factor 1 | Y
Factor 2 | Y
Percentage Met
Subscore
Logic | 100% meets both factors
 | 75% no scoring option
 | 50% no scoring option
 | 25% meets 1 factor
 | 0% meets no factors
Element C
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Factor 7 | Y
Percentage Met
Subscore
Logic | 100% meets 6-7 factors
 | 75% meets 5 factors
 | 50% meets 3-4 factors
 | 25% meets 1-2 factors
 | 0% meets no factors
Element D
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Percentage Met
Subscore
Logic | 100% meets 5-6 factors, including factor 1
 | 75% meets 3-4 factors, including factor 1
 | 50% meets 2 factors, including factor 1
 | 25% meets factor 1
 | 0% meets no factors or does not meet factor 1
Element E
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Percentage Met
Subscore
Logic | 100% meets 5-6 factors, including factor 2
 | 75% meets 4 factors, including factor 2
 | 50% meets 2-3 factors, including factor 2
 | 25% meets 1 factor or meets 2-5 factors but not factor 2
 | 0% meets no factor
Part 4
Element A
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Percentage Met
Subscore
Logic | 100% meets 5-6 factors, including factor 3
 | 75% meets 4 factors, including factor 3
 | 50% meets 3 factors, including factor 3
 | 25% meets 1-2 factors or meets 3-5 factors but not factor 3
 | 0% meets no factors
Element B
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Percentage Met
Subscore
Logic | 100% meets all 4 factors
 | 75% meets 3 factors
 | 50% meets 2 factors
 | 25% meets 1 factor
 | 0% meets no factors
Part 5
Element A
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Factor 7 | Y
Factor 8 | Y
Factor 9 | Y
Factor 10 | Y
Percentage Met
Subscore
Logic | 100% meets 8-10, including factors 1 and 2
 | 75% meets 6-7 factors, inclduing factors 1 and 2
 | 50% practice meets 4-5 factors, including factors 1 and 2
 | 25% meets 3 factors, including factors 1 and 2
 | 0% meets fewer than 3 factors or does not meet factors 1 and 2
Element B
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Factor 7 | Y
Percentage Met
Subscore
Logic | 100% meets 5-7 factors
 | 75% meets 4 factors
 | 50% meets 3 factors
 | 25% meets 1-2 factors
 | 0% meets no factors
Element C
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Factor 5 | Y
Factor 6 | Y
Factor 7 | Y
Factor 8 | Y
Percentage Met
Subscore
Logic | 100% meets 5-8 factors
 | 75% meets 4 factors
 | 50% meets 2-3 factors
 | 25% meets 1 factor
 | 0% meets no factors
Part 6
Element A
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Percentage Met
Subscore
Logic | 100% meets 5-8 factors
 | 75% meets 4 factors
 | 50% meets 2-3 factors
 | 25% meets 1 factor
 | 0% meets no factors
Element B
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Percentage Met
Subscore
Logic | 100% meets all 4 factors
 | 75% meets 3 factors
 | 50% meets 2 factors
 | 25% meets 1 factor
 | 0% meets no factor
Element C
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Percentage Met
Subscore
Logic | 100% meets 3-4 factors
 | 75% no scoring option
 | 50% meets 2 factors
 | 25% meets 1 factor
 | 0% meets no factors
Element D
Factor 1 | Y
Factor 2 | Y
Factor 3 | Y
Factor 4 | Y
Percentage Met
Subscore
Logic | 100% meets all 4 factors
 | 75% meets 3 factors
 | 50% meets 2 factors
 | 25% meets 1 factor
 | 0% meets no factors