Hi, I have the table with a total of 11 cells for 11 quizzes.
Example:
1. If all 11 tests were completed on the first attend then I mark as a "P" / overall % completion 100%
2. If 11 tests were failed on the first attend but completed on the second round, I mark as a P-F1 / overall % completion 90%
3. If 11 tests failed on 2nd time but completed on 3rd round then I mark P-F2 / overall % completion 80%
4. If all tests failed on the 3rd time but completed on the 4th round, then I mark as a P-F3 / overall completed 70%
How about if from the first round only 5 of 11 tests were completed on the 1st round, 3 of 11 on the 2nd round, 2 of 11 on 3r and 1 of 11 on the 4th round... what formula to use to calculate overall % (see table below)
<tbody> </tbody>
Example:
1. If all 11 tests were completed on the first attend then I mark as a "P" / overall % completion 100%
2. If 11 tests were failed on the first attend but completed on the second round, I mark as a P-F1 / overall % completion 90%
3. If 11 tests failed on 2nd time but completed on 3rd round then I mark P-F2 / overall % completion 80%
4. If all tests failed on the 3rd time but completed on the 4th round, then I mark as a P-F3 / overall completed 70%
How about if from the first round only 5 of 11 tests were completed on the 1st round, 3 of 11 on the 2nd round, 2 of 11 on 3r and 1 of 11 on the 4th round... what formula to use to calculate overall % (see table below)
[FONT="]IPR 1[/FONT] | [FONT="]IPR 2[/FONT] | [FONT="]IPR 3[/FONT] | [FONT="]IPR 4[/FONT] | [FONT="]IPR 5[/FONT] | [FONT="]IPR 6[/FONT] | [FONT="]IPR 7[/FONT] | [FONT="]IPR 8[/FONT] | [FONT="]IPR 9[/FONT] | [FONT="]IPR 10[/FONT] | [FONT="]IPR 11[/FONT] | [FONT="]OVERALL PROGRESS (% COMP)[/FONT] |
[FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]100.0%[/FONT] |
[FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]90.0%[/FONT] |
[FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]80.0%[/FONT] |
[FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]70%[/FONT] |
[FONT="]P[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P-F1[/FONT] | [FONT="]P-F2[/FONT] | [FONT="]P-F3[/FONT] | [FONT="]P[/FONT] | [FONT="]P[/FONT] | [FONT="]?[/FONT] |
<tbody> </tbody>