Worksheet Formulas
Cell | Formula |
---|
E3 | =P30 |
---|
H3 | =IF([COLOR=rgb(255]E3>=0.9,"A",IF(E3>=0.8,"B",IF([COLOR=0)]E3>=0.7,"C",IF([COLOR=rgb(0]E3>=0.6,"D","F"[/COLOR])[/COLOR]))[/COLOR]) |
---|
P11 | =IF([COLOR=rgb(255]K11="A",1,IF(K11="B",0.8,IF([COLOR=0)]K11="C",0.7,IF([COLOR=rgb(0]K11="D",0.6,IF(K11="F",0,IF([COLOR=255)]K11="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q11 | =IF([COLOR=rgb(255]K11="N/A",0,D11[/COLOR]) |
---|
R11 | =IFERROR([COLOR=rgb(255]Q11/$Q$30,0[/COLOR]) |
---|
P12 | =IF([COLOR=rgb(255]K12="A",1,IF(K12="B",0.8,IF([COLOR=0)]K12="C",0.7,IF([COLOR=rgb(0]K12="D",0.6,IF(K12="F",0,IF([COLOR=255)]K12="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q12 | =IF([COLOR=rgb(255]K12="N/A",0,D12[/COLOR]) |
---|
R12 | =IFERROR([COLOR=rgb(255]Q12/$Q$30,0[/COLOR]) |
---|
P13 | =IF([COLOR=rgb(255]K13="A",1,IF(K13="B",0.8,IF([COLOR=0)]K13="C",0.7,IF([COLOR=rgb(0]K13="D",0.6,IF(K13="F",0,IF([COLOR=255)]K13="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q13 | =IF([COLOR=rgb(255]K13="N/A",0,D13[/COLOR]) |
---|
R13 | =IFERROR([COLOR=rgb(255]Q13/$Q$30,0[/COLOR]) |
---|
K14 | =IF([COLOR=rgb(255]SUM(P11:P13)=0,"N/A",SUM(P11:P13)/COUNTIF(K11:K13,"<>*N/A*")[/COLOR]) |
---|
P16 | =IF([COLOR=rgb(255]K16="A",1,IF(K16="B",0.8,IF([COLOR=0)]K16="C",0.7,IF([COLOR=rgb(0]K16="D",0.6,IF(K16="F",0,IF([COLOR=255)]K16="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q16 | =IF([COLOR=rgb(255]K16="N/A",0,D16[/COLOR]) |
---|
R16 | =IFERROR([COLOR=rgb(255]Q16/$Q$30,0[/COLOR]) |
---|
P17 | =IF([COLOR=rgb(255]K17="A",1,IF(K17="B",0.8,IF([COLOR=0)]K17="C",0.7,IF([COLOR=rgb(0]K17="D",0.6,IF(K17="F",0,IF([COLOR=255)]K17="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q17 | =IF([COLOR=rgb(255]K17="N/A",0,D17[/COLOR]) |
---|
R17 | =IFERROR([COLOR=rgb(255]Q17/$Q$30,0[/COLOR]) |
---|
K18 | =IF([COLOR=rgb(255]SUM(P16:P17)=0,"N/A",SUM(P16:P17)/COUNTIF(K16:K17,"<>*N/A*")[/COLOR]) |
---|
K24 | =IF([COLOR=rgb(255]SUM(P20:P23)=0,"N/A",SUM(P20:P23)/COUNTIF(K20:K23,"<>*N/A*")[/COLOR]) |
---|
P20 | =IF([COLOR=rgb(255]K20="A",1,IF(K20="B",0.8,IF([COLOR=0)]K20="C",0.7,IF([COLOR=rgb(0]K20="D",0.6,IF(K20="F",0,IF([COLOR=255)]K20="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q20 | =IF([COLOR=rgb(255]K20="N/A",0,D20[/COLOR]) |
---|
R20 | =IFERROR([COLOR=rgb(255]Q20/$Q$30,0[/COLOR]) |
---|
P21 | =IF([COLOR=rgb(255]K21="A",1,IF(K21="B",0.8,IF([COLOR=0)]K21="C",0.7,IF([COLOR=rgb(0]K21="D",0.6,IF(K21="F",0,IF([COLOR=255)]K21="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q21 | =IF([COLOR=rgb(255]K21="N/A",0,D21[/COLOR]) |
---|
R21 | =IFERROR([COLOR=rgb(255]Q21/$Q$30,0[/COLOR]) |
---|
P22 | =IF([COLOR=rgb(255]K22="A",1,IF(K22="B",0.8,IF([COLOR=0)]K22="C",0.7,IF([COLOR=rgb(0]K22="D",0.6,IF(K22="F",0,IF([COLOR=255)]K22="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q22 | =IF([COLOR=rgb(255]K22="N/A",0,D22[/COLOR]) |
---|
R22 | =IFERROR([COLOR=rgb(255]Q22/$Q$30,0[/COLOR]) |
---|
P23 | =IF([COLOR=rgb(255]K23="A",1,IF(K23="B",0.8,IF([COLOR=0)]K23="C",0.7,IF([COLOR=rgb(0]K23="D",0.6,IF(K23="F",0,IF([COLOR=255)]K23="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q23 | =IF([COLOR=rgb(255]K23="N/A",0,D23[/COLOR]) |
---|
R23 | =IFERROR([COLOR=rgb(255]Q23/$Q$30,0[/COLOR]) |
---|
R24 | =SUM([COLOR=rgb(255]R21:R23[/COLOR]) |
---|
P26 | =IF([COLOR=rgb(255]K26="A",1,IF(K26="B",0.8,IF([COLOR=0)]K26="C",0.7,IF([COLOR=rgb(0]K26="D",0.6,IF(K26="F",0,IF([COLOR=255)]K26="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q26 | =IF([COLOR=rgb(255]K26="N/A",0,D26[/COLOR]) |
---|
R26 | =IFERROR([COLOR=rgb(255]Q26/$Q$30,0[/COLOR]) |
---|
P27 | =IF([COLOR=rgb(255]K27="A",1,IF(K27="B",0.8,IF([COLOR=0)]K27="C",0.7,IF([COLOR=rgb(0]K27="D",0.6,IF(K27="F",0,IF([COLOR=255)]K27="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q27 | =IF([COLOR=rgb(255]K27="N/A",0,D27[/COLOR]) |
---|
R27 | =IFERROR([COLOR=rgb(255]Q27/$Q$30,0[/COLOR]) |
---|
P28 | =IF([COLOR=rgb(255]K28="A",1,IF(K28="B",0.8,IF([COLOR=0)]K28="C",0.7,IF([COLOR=rgb(0]K28="D",0.6,IF(K28="F",0,IF([COLOR=255)]K28="N/A",0[/COLOR]))[/COLOR])[/COLOR]))[/COLOR]) |
---|
Q28 | =IF([COLOR=rgb(255]K28="N/A",0,D28[/COLOR]) |
---|
R28 | =IFERROR([COLOR=rgb(255]Q28/$Q$30,0[/COLOR]) |
---|
K29 | =IF([COLOR=rgb(255]SUM(P26:P28)=0,"N/A",SUM(P26:P28)/COUNTIF(K26:K28,"<>*N/A*")[/COLOR]) |
---|
P30 | =SUMPRODUCT([COLOR=rgb(255]P11:P28,R11:R28[/COLOR])/SUM([COLOR=rgb(255]R11:R28[/COLOR]) |
---|
Q30 | =SUM([COLOR=rgb(255]Q11:Q29[/COLOR]) |
---|
R30 | =SUM([COLOR=rgb(255]R11:R29[/COLOR]) |
---|
<thead>
</thead><tbody>
</tbody> |