Address |
Formula |
Value |
AG3 |
=FindColorSum2(A3:AE3,$A$36,TRUE) |
0 |
AH3 |
=FindColorSum(B3:AE3,$A$35,TRUE) |
0 |
AI3 |
=findzero(B3:AE3)*3 |
0 |
AJ3 |
=IF(A3=0,"",AN3/(AM3-AI3)) |
|
AK3 |
=SUM(IF(ISERROR(601-AN3),0,601-AN3)) |
0 |
AL3 |
=SUM(IF(ISERROR(AO3*3),0,AO3*3)) |
0 |
AG4 |
=FindColorSum2(A4:AE4,$A$36,TRUE) |
0 |
AH4 |
=FindColorSum(B4:AE4,$A$35,TRUE) |
0 |
AI4 |
=findzero(B4:AE4)*3 |
0 |
AJ4 |
=IF(A4=0,"",AN4/(AM4-AI4)) |
|
AK4 |
=SUM(IF(ISERROR(601-AN4),0,601-AN4)) |
0 |
AL4 |
=SUM(IF(ISERROR(AO4*3),0,AO4*3)) |
0 |
AG5 |
=FindColorSum2(A5:AE5,$A$36,TRUE) |
0 |
AH5 |
=FindColorSum(B5:AE5,$A$35,TRUE) |
0 |
AI5 |
=findzero(B5:AE5)*3 |
0 |
AJ5 |
=IF(A5=0,"",AN5/(AM5-AI5)) |
|
AK5 |
=SUM(IF(ISERROR(601-AN5),0,601-AN5)) |
0 |
AL5 |
=SUM(IF(ISERROR(AO5*3),0,AO5*3)) |
0 |
AG6 |
=FindColorSum2(A6:AE6,$A$36,TRUE) |
0 |
AH6 |
=FindColorSum(B6:AE6,$A$35,TRUE) |
0 |
AI6 |
=findzero(B6:AE6)*3 |
0 |
AJ6 |
=IF(A6=0,"",AN6/(AM6-AI6)) |
|
AK6 |
=SUM(IF(ISERROR(601-AN6),0,601-AN6)) |
0 |
AL6 |
=SUM(IF(ISERROR(AO6*3),0,AO6*3)) |
0 |
AG7 |
=FindColorSum2(A7:AE7,$A$36,TRUE) |
0 |
AH7 |
=FindColorSum(B7:AE7,$A$35,TRUE) |
0 |
AI7 |
=findzero(B7:AE7)*3 |
0 |
AJ7 |
=IF(A7=0,"",AN7/(AM7-AI7)) |
|
AK7 |
=SUM(IF(ISERROR(601-AN7),0,601-AN7)) |
0 |
AL7 |
=SUM(IF(ISERROR(AO7*3),0,AO7*3)) |
0 |
AG8 |
=FindColorSum2(A8:AE8,$A$36,TRUE) |
0 |
AH8 |
=FindColorSum(B8:AE8,$A$35,TRUE) |
0 |
AI8 |
=findzero(B8:AE8)*3 |
0 |
AJ8 |
=IF(A8=0,"",AN8/(AM8-AI8)) |
|
AK8 |
=SUM(IF(ISERROR(601-AN8),0,601-AN8)) |
0 |
AL8 |
=SUM(IF(ISERROR(AO8*3),0,AO8*3)) |
0 |
AG9 |
=FindColorSum2(A9:AE9,$A$36,TRUE) |
0 |
AH9 |
=FindColorSum(B9:AE9,$A$35,TRUE) |
0 |
AI9 |
=findzero(B9:AE9)*3 |
0 |
AJ9 |
=IF(A9=0,"",AN9/(AM9-AI9)) |
|
AK9 |
=SUM(IF(ISERROR(601-AN9),0,601-AN9)) |
0 |
AL9 |
=SUM(IF(ISERROR(AO9*3),0,AO9*3)) |
0 |
AG10 |
=FindColorSum2(A10:AE10,$A$36,TRUE) |
0 |
AH10 |
=FindColorSum(B10:AE10,$A$35,TRUE) |
0 |
AI10 |
=findzero(B10:AE10)*3 |
0 |
AJ10 |
=IF(A10=0,"",AN10/(AM10-AI10)) |
|
AK10 |
=SUM(IF(ISERROR(601-AN10),0,601-AN10)) |
0 |
AL10 |
=SUM(IF(ISERROR(AO10*3),0,AO10*3)) |
0 |
AM3 |
=IF(A3=0,"",SUM(COUNT(B3:AD3)*3)+AF3) |
|
AN3 |
=IF(A3=0,"",SUM(B3:AE3)) |
|
AO3 |
=IF(A3=0,"",AN3/AM3) |
|
AP3 |
=IF(A3=0,"",COUNTIF(B3:AE3,">99")-AQ3-AR3-AS3) |
|
AQ3 |
=IF(A3=0,"",COUNTIF(B3:AE3,">139")-AR3-AS3) |
|
AR3 |
=IF(A3=0,"",COUNTIF(B3:AE3,">169")-AS3) |
|
AS3 |
=IF(A3=0,"",COUNTIF(B3:AE3,">179")) |
|
AT3 |
=IF(A3=0,"",AP3+AQ3+AR3+AS3) |
|
AM4 |
=IF(A4=0,"",SUM(COUNT(B4:AD4)*3)+AF4) |
|
AN4 |
=IF(A4=0,"",SUM(B4:AE4)) |
|
AO4 |
=IF(A4=0,"",AN4/AM4) |
|
AP4 |
=IF(A4=0,"",COUNTIF(B4:AE4,">99")-AQ4-AR4-AS4) |
|
AQ4 |
=IF(A4=0,"",COUNTIF(B4:AE4,">139")-AR4-AS4) |
|
AR4 |
=IF(A4=0,"",COUNTIF(B4:AE4,">169")-AS4) |
|
AS4 |
=IF(A4=0,"",COUNTIF(B4:AE4,">179")) |
|
AT4 |
=IF(A4=0,"",AP4+AQ4+AR4+AS4) |
|
AM5 |
=IF(A5=0,"",SUM(COUNT(B5:AD5)*3)+AF5) |
|
AN5 |
=IF(A5=0,"",SUM(B5:AE5)) |
|
AO5 |
=IF(A5=0,"",AN5/AM5) |
|
AP5 |
=IF(A5=0,"",COUNTIF(B5:AE5,">99")-AQ5-AR5-AS5) |
|
AQ5 |
=IF(A5=0,"",COUNTIF(B5:AE5,">139")-AR5-AS5) |
|
AR5 |
=IF(A5=0,"",COUNTIF(B5:AE5,">169")-AS5) |
|
AS5 |
=IF(A5=0,"",COUNTIF(B5:AE5,">179")) |
|
AT5 |
=IF(A5=0,"",AP5+AQ5+AR5+AS5) |
|
AM6 |
=IF(A6=0,"",SUM(COUNT(B6:AD6)*3)+AF6) |
|
AN6 |
=IF(A6=0,"",SUM(B6:AE6)) |
|
AO6 |
=IF(A6=0,"",AN6/AM6) |
|
AP6 |
=IF(A6=0,"",COUNTIF(B6:AE6,">99")-AQ6-AR6-AS6) |
|
AQ6 |
=IF(A6=0,"",COUNTIF(B6:AE6,">139")-AR6-AS6) |
|
AR6 |
=IF(A6=0,"",COUNTIF(B6:AE6,">169")-AS6) |
|
AS6 |
=IF(A6=0,"",COUNTIF(B6:AE6,">179")) |
|
AT6 |
=IF(A6=0,"",AP6+AQ6+AR6+AS6) |
|
AM7 |
=IF(A7=0,"",SUM(COUNT(B7:AD7)*3)+AF7) |
|
AN7 |
=IF(A7=0,"",SUM(B7:AE7)) |
|
AO7 |
=IF(A7=0,"",AN7/AM7) |
|
AP7 |
=IF(A7=0,"",COUNTIF(B7:AE7,">99")-AQ7-AR7-AS7) |
|
AQ7 |
=IF(A7=0,"",COUNTIF(B7:AE7,">139")-AR7-AS7) |
|
AR7 |
=IF(A7=0,"",COUNTIF(B7:AE7,">169")-AS7) |
|
AS7 |
=IF(A7=0,"",COUNTIF(B7:AE7,">179")) |
|
AT7 |
=IF(A7=0,"",AP7+AQ7+AR7+AS7) |
|
AM8 |
=IF(A8=0,"",SUM(COUNT(B8:AD8)*3)+AF8) |
|
AN8 |
=IF(A8=0,"",SUM(B8:AE8)) |
|
AO8 |
=IF(A8=0,"",AN8/AM8) |
|
AP8 |
=IF(A8=0,"",COUNTIF(B8:AE8,">99")-AQ8-AR8-AS8) |
|
AQ8 |
=IF(A8=0,"",COUNTIF(B8:AE8,">139")-AR8-AS8) |
|
AR8 |
=IF(A8=0,"",COUNTIF(B8:AE8,">169")-AS8) |
|
AS8 |
=IF(A8=0,"",COUNTIF(B8:AE8,">179")) |
|
AT8 |
=IF(A8=0,"",AP8+AQ8+AR8+AS8) |
|
AM9 |
=IF(A9=0,"",SUM(COUNT(B9:AD9)*3)+AF9) |
|
AN9 |
=IF(A9=0,"",SUM(B9:AE9)) |
|
AO9 |
=IF(A9=0,"",AN9/AM9) |
|
AP9 |
=IF(A9=0,"",COUNTIF(B9:AE9,">99")-AQ9-AR9-AS9) |
|
AQ9 |
=IF(A9=0,"",COUNTIF(B9:AE9,">139")-AR9-AS9) |
|
AR9 |
=IF(A9=0,"",COUNTIF(B9:AE9,">169")-AS9) |
|
AS9 |
=IF(A9=0,"",COUNTIF(B9:AE9,">179")) |
|
AT9 |
=IF(A9=0,"",AP9+AQ9+AR9+AS9) |
|
AM10 |
=IF(A10=0,"",SUM(COUNT(B10:AD10)*3)+AF10) |
|
AN10 |
=IF(A10=0,"",SUM(B10:AE10)) |
|
AO10 |
=IF(A10=0,"",AN10/AM10) |
|
AP10 |
=IF(A10=0,"",COUNTIF(B10:AE10,">99")-AQ10-AR10-AS10) |
|
AQ10 |
=IF(A10=0,"",COUNTIF(B10:AE10,">139")-AR10-AS10) |
|
AR10 |
=IF(A10=0,"",COUNTIF(B10:AE10,">169")-AS10) |
|
AS10 |
=IF(A10=0,"",COUNTIF(B10:AE10,">179")) |
|
AT10 |
=IF(A10=0,"",AP10+AQ10+AR10+AS10) |
|
AM11 |
=IF(A11=0,"",SUM(COUNT(B11:AD11)*3)+AF11) |
|
AN11 |
=IF(A11=0,"",SUM(B11:AE11)) |
|
AO11 |
=IF(A11=0,"",AN11/AM11) |
|
AP11 |
=IF(A11=0,"",COUNTIF(B11:AE11,">99")-AQ11-AR11-AS11) |
|
AQ11 |
=IF(A11=0,"",COUNTIF(B11:AE11,">139")-AR11-AS11) |
|
AR11 |
=IF(A11=0,"",COUNTIF(B11:AE11,">169")-AS11) |
|
AS11 |
=IF(A11=0,"",COUNTIF(B11:AE11,">179")) |
|
AT11 |
=IF(A11=0,"",AP11+AQ11+AR11+AS11) |
|
AM12 |
=IF(A12=0,"",SUM(COUNT(B12:AD12)*3)+AF12) |
|
AN12 |
=IF(A12=0,"",SUM(B12:AE12)) |
|
AO12 |
=IF(A12=0,"",AN12/AM12) |
|
AP12 |
=IF(A12=0,"",COUNTIF(B12:AE12,">99")-AQ12-AR12-AS12) |
|
AQ12 |
=IF(A12=0,"",COUNTIF(B12:AE12,">139")-AR12-AS12) |
|
AR12 |
=IF(A12=0,"",COUNTIF(B12:AE12,">169")-AS12) |
|
AS12 |
=IF(A12=0,"",COUNTIF(B12:AE12,">179")) |
|
AT12 |
=IF(A12=0,"",AP12+AQ12+AR12+AS12) |
|
AM13 |
=IF(A13=0,"",SUM(COUNT(B13:AD13)*3)+AF13) |
|
AN13 |
=IF(A13=0,"",SUM(B13:AE13)) |
|
AO13 |
=IF(A13=0,"",AN13/AM13) |
|
AP13 |
=IF(A13=0,"",COUNTIF(B13:AE13,">99")-AQ13-AR13-AS13) |
|
AQ13 |
=IF(A13=0,"",COUNTIF(B13:AE13,">139")-AR13-AS13) |
|
AR13 |
=IF(A13=0,"",COUNTIF(B13:AE13,">169")-AS13) |
|
AS13 |
=IF(A13=0,"",COUNTIF(B13:AE13,">179")) |
|
AT13 |
=IF(A13=0,"",AP13+AQ13+AR13+AS13) |
|
AM14 |
=IF(A14=0,"",SUM(COUNT(B14:AD14)*3)+AF14) |
|
AN14 |
=IF(A14=0,"",SUM(B14:AE14)) |
|
AO14 |
=IF(A14=0,"",AN14/AM14) |
|
AP14 |
=IF(A14=0,"",COUNTIF(B14:AE14,">99")-AQ14-AR14-AS14) |
|
AQ14 |
=IF(A14=0,"",COUNTIF(B14:AE14,">139")-AR14-AS14) |
|
AR14 |
=IF(A14=0,"",COUNTIF(B14:AE14,">169")-AS14) |
|
AS14 |
=IF(A14=0,"",COUNTIF(B14:AE14,">179")) |
|
AT14 |
=IF(A14=0,"",AP14+AQ14+AR14+AS14) |
|
AM15 |
=IF(A15=0,"",SUM(COUNT(B15:AD15)*3)+AF15) |
|
AN15 |
=IF(A15=0,"",SUM(B15:AE15)) |
|
AO15 |
=IF(A15=0,"",AN15/AM15) |
|
AP15 |
=IF(A15=0,"",COUNTIF(B15:AE15,">99")-AQ15-AR15-AS15) |
|
AQ15 |
=IF(A15=0,"",COUNTIF(B15:AE15,">139")-AR15-AS15) |
|
AR15 |
=IF(A15=0,"",COUNTIF(B15:AE15,">169")-AS15) |
|
AS15 |
=IF(A15=0,"",COUNTIF(B15:AE15,">179")) |
|
AT15 |
=IF(A15=0,"",AP15+AQ15+AR15+AS15) |
|
AM16 |
=IF(A16=0,"",SUM(COUNT(B16:AD16)*3)+AF16) |
|
AN16 |
=IF(A16=0,"",SUM(B16:AE16)) |
|
AO16 |
=IF(A16=0,"",AN16/AM16) |
|
AP16 |
=IF(A16=0,"",COUNTIF(B16:AE16,">99")-AQ16-AR16-AS16) |
|
AQ16 |
=IF(A16=0,"",COUNTIF(B16:AE16,">139")-AR16-AS16) |
|
AR16 |
=IF(A16=0,"",COUNTIF(B16:AE16,">169")-AS16) |
|
AS16 |
=IF(A16=0,"",COUNTIF(B16:AE16,">179")) |
|
AT16 |
=IF(A16=0,"",AP16+AQ16+AR16+AS16) |
|
AM17 |
=IF(A17=0,"",SUM(COUNT(B17:AD17)*3)+AF17) |
|
AN17 |
=IF(A17=0,"",SUM(B17:AE17)) |
|
AO17 |
=IF(A17=0,"",AN17/AM17) |
|
AP17 |
=IF(A17=0,"",COUNTIF(B17:AE17,">99")-AQ17-AR17-AS17) |
|
AQ17 |
=IF(A17=0,"",COUNTIF(B17:AE17,">139")-AR17-AS17) |
|
AR17 |
=IF(A17=0,"",COUNTIF(B17:AE17,">169")-AS17) |
|
AS17 |
=IF(A17=0,"",COUNTIF(B17:AE17,">179")) |
|
AT17 |
=IF(A17=0,"",AP17+AQ17+AR17+AS17) |
|
AM18 |
=IF(A18=0,"",SUM(COUNT(B18:AD18)*3)+AF18) |
|
AN18 |
=IF(A18=0,"",SUM(B18:AE18)) |
|
AO18 |
=IF(A18=0,"",AN18/AM18) |
|
AP18 |
=IF(A18=0,"",COUNTIF(B18:AE18,">99")-AQ18-AR18-AS18) |
|
AQ18 |
=IF(A18=0,"",COUNTIF(B18:AE18,">139")-AR18-AS18) |
|
AR18 |
=IF(A18=0,"",COUNTIF(B18:AE18,">169")-AS18) |
|
AS18 |
=IF(A18=0,"",COUNTIF(B18:AE18,">179")) |
|
AT18 |
=IF(A18=0,"",AP18+AQ18+AR18+AS18) |
|
AM19 |
=IF(A19=0,"",SUM(COUNT(B19:AD19)*3)+AF19) |
|
AN19 |
=IF(A19=0,"",SUM(B19:AE19)) |
|
AO19 |
=IF(A19=0,"",AN19/AM19) |
|
AP19 |
=IF(A19=0,"",COUNTIF(B19:AE19,">99")-AQ19-AR19-AS19) |
|
AQ19 |
=IF(A19=0,"",COUNTIF(B19:AE19,">139")-AR19-AS19) |
|
AR19 |
=IF(A19=0,"",COUNTIF(B19:AE19,">169")-AS19) |
|
AS19 |
=IF(A19=0,"",COUNTIF(B19:AE19,">179")) |
|
AT19 |
=IF(A19=0,"",AP19+AQ19+AR19+AS19) |
|
AM20 |
=IF(A20=0,"",SUM(COUNT(B20:AD20)*3)+AF20) |
|
AN20 |
=IF(A20=0,"",SUM(B20:AE20)) |
|
AO20 |
=IF(A20=0,"",AN20/AM20) |
|
AP20 |
=IF(A20=0,"",COUNTIF(B20:AE20,">99")-AQ20-AR20-AS20) |
|
AQ20 |
=IF(A20=0,"",COUNTIF(B20:AE20,">139")-AR20-AS20) |
|
AR20 |
=IF(A20=0,"",COUNTIF(B20:AE20,">169")-AS20) |
|
AS20 |
=IF(A20=0,"",COUNTIF(B20:AE20,">179")) |
|
AT20 |
=IF(A20=0,"",AP20+AQ20+AR20+AS20) |
|
AM21 |
=IF(A21=0,"",SUM(COUNT(B21:AD21)*3)+AF21) |
|
AN21 |
=IF(A21=0,"",SUM(B21:AE21)) |
|
AO21 |
=IF(A21=0,"",AN21/AM21) |
|
AP21 |
=IF(A21=0,"",COUNTIF(B21:AE21,">99")-AQ21-AR21-AS21) |
|
AQ21 |
=IF(A21=0,"",COUNTIF(B21:AE21,">139")-AR21-AS21) |
|
AR21 |
=IF(A21=0,"",COUNTIF(B21:AE21,">169")-AS21) |
|
AS21 |
=IF(A21=0,"",COUNTIF(B21:AE21,">179")) |
|
AT21 |
=IF(A21=0,"",AP21+AQ21+AR21+AS21) |
|
AM22 |
=IF(A22=0,"",SUM(COUNT(B22:AD22)*3)+AF22) |
|
AN22 |
=IF(A22=0,"",SUM(B22:AE22)) |
|
AO22 |
=IF(A22=0,"",AN22/AM22) |
|
AP22 |
=IF(A22=0,"",COUNTIF(B22:AE22,">99")-AQ22-AR22-AS22) |
|
AQ22 |
=IF(A22=0,"",COUNTIF(B22:AE22,">139")-AR22-AS22) |
|
AR22 |
=IF(A22=0,"",COUNTIF(B22:AE22,">169")-AS22) |
|
AS22 |
=IF(A22=0,"",COUNTIF(B22:AE22,">179")) |
|
AT22 |
=IF(A22=0,"",AP22+AQ22+AR22+AS22) |
|
AM23 |
=IF(A23=0,"",SUM(COUNT(B23:AD23)*3)+AF23) |
|
AN23 |
=IF(A23=0,"",SUM(B23:AE23)) |
|
AO23 |
=IF(A23=0,"",AN23/AM23) |
|
AP23 |
=IF(A23=0,"",COUNTIF(B23:AE23,">99")-AQ23-AR23-AS23) |
|
AQ23 |
=IF(A23=0,"",COUNTIF(B23:AE23,">139")-AR23-AS23) |
|
AR23 |
=IF(A23=0,"",COUNTIF(B23:AE23,">169")-AS23) |
|
AS23 |
=IF(A23=0,"",COUNTIF(B23:AE23,">179")) |
|
AT23 |
=IF(A23=0,"",AP23+AQ23+AR23+AS23) |
|
AM24 |
=IF(A24=0,"",SUM(COUNT(B24:AD24)*3)+AF24) |
|
AN24 |
=IF(A24=0,"",SUM(B24:AE24)) |
|
AO24 |
=IF(A24=0,"",AN24/AM24) |
|
AP24 |
=IF(A24=0,"",COUNTIF(B24:AE24,">99")-AQ24-AR24-AS24) |
|
AQ24 |
=IF(A24=0,"",COUNTIF(B24:AE24,">139")-AR24-AS24) |
|
AR24 |
=IF(A24=0,"",COUNTIF(B24:AE24,">169")-AS24) |
|
AS24 |
=IF(A24=0,"",COUNTIF(B24:AE24,">179")) |
|
AT24 |
=IF(A24=0,"",AP24+AQ24+AR24+AS24) |
|
AM25 |
=IF(A25=0,"",SUM(COUNT(B25:AD25)*3)+AF25) |
|
AN25 |
=IF(A25=0,"",SUM(B25:AE25)) |
|
AO25 |
=IF(A25=0,"",AN25/AM25) |
|
AP25 |
=IF(A25=0,"",COUNTIF(B25:AE25,">99")-AQ25-AR25-AS25) |
|
AQ25 |
=IF(A25=0,"",COUNTIF(B25:AE25,">139")-AR25-AS25) |
|
AR25 |
=IF(A25=0,"",COUNTIF(B25:AE25,">169")-AS25) |
|
AS25 |
=IF(A25=0,"",COUNTIF(B25:AE25,">179")) |
|
AT25 |
=IF(A25=0,"",AP25+AQ25+AR25+AS25) |
|
AM26 |
=IF(A26=0,"",SUM(COUNT(B26:AD26)*3)+AF26) |
|
AN26 |
=IF(A26=0,"",SUM(B26:AE26)) |
|
AO26 |
=IF(A26=0,"",AN26/AM26) |
|
AP26 |
=IF(A26=0,"",COUNTIF(B26:AE26,">99")-AQ26-AR26-AS26) |
|
AQ26 |
=IF(A26=0,"",COUNTIF(B26:AE26,">139")-AR26-AS26) |
|
AR26 |
=IF(A26=0,"",COUNTIF(B26:AE26,">169")-AS26) |
|
AS26 |
=IF(A26=0,"",COUNTIF(B26:AE26,">179")) |
|
AT26 |
=IF(A26=0,"",AP26+AQ26+AR26+AS26) |
|
AM27 |
=IF(A27=0,"",SUM(COUNT(B27:AD27)*3)+AF27) |
|
AN27 |
=IF(A27=0,"",SUM(B27:AE27)) |
|
AO27 |
=IF(A27=0,"",AN27/AM27) |
|
AP27 |
=IF(A27=0,"",COUNTIF(B27:AE27,">99")-AQ27-AR27-AS27) |
|
AQ27 |
=IF(A27=0,"",COUNTIF(B27:AE27,">139")-AR27-AS27) |
|
AR27 |
=IF(A27=0,"",COUNTIF(B27:AE27,">169")-AS27) |
|
AS27 |
=IF(A27=0,"",COUNTIF(B27:AE27,">179")) |
|
AT27 |
=IF(A27=0,"",AP27+AQ27+AR27+AS27) |
|
AM28 |
=IF(A28=0,"",SUM(COUNT(B28:AD28)*3)+AF28) |
|
AN28 |
=IF(A28=0,"",SUM(B28:AE28)) |
|
AO28 |
=IF(A28=0,"",AN28/AM28) |
|
AP28 |
=IF(A28=0,"",COUNTIF(B28:AE28,">99")-AQ28-AR28-AS28) |
|
AQ28 |
=IF(A28=0,"",COUNTIF(B28:AE28,">139")-AR28-AS28) |
|
AR28 |
=IF(A28=0,"",COUNTIF(B28:AE28,">169")-AS28) |
|
AS28 |
=IF(A28=0,"",COUNTIF(B28:AE28,">179")) |
|
AT28 |
=IF(A28=0,"",AP28+AQ28+AR28+AS28) |
|
AM29 |
=IF(A29=0,"",SUM(COUNT(B29:AD29)*3)+AF29) |
|
AN29 |
=IF(A29=0,"",SUM(B29:AE29)) |
|
AO29 |
=IF(A29=0,"",AN29/AM29) |
|
AP29 |
=IF(A29=0,"",COUNTIF(B29:AE29,">99")-AQ29-AR29-AS29) |
|
AQ29 |
=IF(A29=0,"",COUNTIF(B29:AE29,">139")-AR29-AS29) |
|
AR29 |
=IF(A29=0,"",COUNTIF(B29:AE29,">169")-AS29) |
|
AS29 |
=IF(A29=0,"",COUNTIF(B29:AE29,">179")) |
|
AT29 |
=IF(A29=0,"",AP29+AQ29+AR29+AS29) |
|
AM30 |
=IF(A30=0,"",SUM(COUNT(B30:AD30)*3)+AF30) |
|
AN30 |
=IF(A30=0,"",SUM(B30:AE30)) |
|
AO30 |
=IF(A30=0,"",AN30/AM30) |
|
AP30 |
=IF(A30=0,"",COUNTIF(B30:AE30,">99")-AQ30-AR30-AS30) |
|
AQ30 |
=IF(A30=0,"",COUNTIF(B30:AE30,">139")-AR30-AS30) |
|
AR30 |
=IF(A30=0,"",COUNTIF(B30:AE30,">169")-AS30) |
|
AS30 |
=IF(A30=0,"",COUNTIF(B30:AE30,">179")) |
|
AT30 |
=IF(A30=0,"",AP30+AQ30+AR30+AS30) |
|
AM31 |
=IF(A31=0,"",SUM(COUNT(B31:AD31)*3)+AF31) |
|
AN31 |
=IF(A31=0,"",SUM(B31:AE31)) |
|
AO31 |
=IF(A31=0,"",AN31/AM31) |
|
AP31 |
=IF(A31=0,"",COUNTIF(B31:AE31,">99")-AQ31-AR31-AS31) |
|
AQ31 |
=IF(A31=0,"",COUNTIF(B31:AE31,">139")-AR31-AS31) |
|
AR31 |
=IF(A31=0,"",COUNTIF(B31:AE31,">169")-AS31) |
|
AS31 |
=IF(A31=0,"",COUNTIF(B31:AE31,">179")) |
|
AT31 |
=IF(A31=0,"",AP31+AQ31+AR31+AS31) |
|
AM32 |
=IF(A32=0,"",SUM(COUNT(B32:AD32)*3)+AF32) |
|
AN32 |
=IF(A32=0,"",SUM(B32:AE32)) |
|
AO32 |
=IF(A32=0,"",AN32/AM32) |
|
AP32 |
=IF(A32=0,"",COUNTIF(B32:AE32,">99")-AQ32-AR32-AS32) |
|
AQ32 |
=IF(A32=0,"",COUNTIF(B32:AE32,">139")-AR32-AS32) |
|
AR32 |
=IF(A32=0,"",COUNTIF(B32:AE32,">169")-AS32) |
|
AS32 |
=IF(A32=0,"",COUNTIF(B32:AE32,">179")) |
|
AT32 |
=IF(A32=0,"",AP32+AQ32+AR32+AS32) |
|
AM33 |
=IF(A33=0,"",SUM(COUNT(B33:AD33)*3)+AF33) |
|
AN33 |
=IF(A33=0,"",SUM(B33:AE33)) |
|
AO33 |
=IF(A33=0,"",AN33/AM33) |
|
AP33 |
=IF(A33=0,"",COUNTIF(B33:AE33,">99")-AQ33-AR33-AS33) |
|
AQ33 |
=IF(A33=0,"",COUNTIF(B33:AE33,">139")-AR33-AS33) |
|
AR33 |
=IF(A33=0,"",COUNTIF(B33:AE33,">169")-AS33) |
|
AS33 |
=IF(A33=0,"",COUNTIF(B33:AE33,">179")) |
|
AT33 |
=IF(A33=0,"",AP33+AQ33+AR33+AS33) |
|
AM34 |
=IF(A34=0,"",SUM(COUNT(B34:AD34)*3)+AF34) |
|
AN34 |
=IF(A34=0,"",SUM(B34:AE34)) |
|
AO34 |
=IF(A34=0,"",AN34/AM34) |
|
AP34 |
=IF(A34=0,"",COUNTIF(B34:AE34,">99")-AQ34-AR34-AS34) |
|
AQ34 |
=IF(A34=0,"",COUNTIF(B34:AE34,">139")-AR34-AS34) |
|
AR34 |
=IF(A34=0,"",COUNTIF(B34:AE34,">169")-AS34) |
|
AS34 |
=IF(A34=0,"",COUNTIF(B34:AE34,">179")) |
|
AT34 |
=IF(A34=0,"",AP34+AQ34+AR34+AS34) |
|
AM35 |
=IF(A35=0,"",SUM(COUNT(B35:AD35)*3)+AF35) |
0 |
AN35 |
=IF(A35=0,"",SUM(B35:AE35)) |
0 |
AO35 |
=IF(A35=0,"",AN35/AM35) |
#### |
AP35 |
=IF(A35=0,"",COUNTIF(B35:AE35,">99")-AQ35-AR35-AS35) |
0 |
AQ35 |
=IF(A35=0,"",COUNTIF(B35:AE35,">139")-AR35-AS35) |
0 |
AR35 |
=IF(A35=0,"",COUNTIF(B35:AE35,">169")-AS35) |
0 |
AS35 |
=IF(A35=0,"",COUNTIF(B35:AE35,">179")) |
0 |
AT35 |
=IF(A35=0,"",AP35+AQ35+AR35+AS35) |
0 |
AM36 |
=IF(A36=0,"",SUM(COUNT(B36:AD36)*3)+AF36) |
0 |
AN36 |
=IF(A36=0,"",SUM(B36:AE36)) |
0 |
AO36 |
=IF(A36=0,"",AN36/AM36) |
#### |
AP36 |
=IF(A36=0,"",COUNTIF(B36:AE36,">99")-AQ36-AR36-AS36) |
0 |
AQ36 |
=IF(A36=0,"",COUNTIF(B36:AE36,">139")-AR36-AS36) |
0 |
AR36 |
=IF(A36=0,"",COUNTIF(B36:AE36,">169")-AS36) |
0 |
AS36 |
=IF(A36=0,"",COUNTIF(B36:AE36,">179")) |
0 |
AT36 |
=IF(A36=0,"",AP36+AQ36+AR36+AS36) |
0 |
AM37 |
=IF(A37=0,"",SUM(COUNT(B37:AD37)*3)+AF37) |
0 |
AN37 |
=IF(A37=0,"",SUM(B37:AE37)) |
0 |
AO37 |
=IF(A37=0,"",AN37/AM37) |
#### |
AP37 |
=IF(A37=0,"",COUNTIF(B37:AE37,">99")-AQ37-AR37-AS37) |
0 |
AQ37 |
=IF(A37=0,"",COUNTIF(B37:AE37,">139")-AR37-AS37) |
0 |
AR37 |
=IF(A37=0,"",COUNTIF(B37:AE37,">169")-AS37) |
0 |
AS37 |
=IF(A37=0,"",COUNTIF(B37:AE37,">179")) |
0 |
AT37 |
=IF(A37=0,"",AP37+AQ37+AR37+AS37) |
0 |
AM38 |
=IF(A38=0,"",SUM(COUNT(B38:AD38)*3)+AF38) |
|
AN38 |
=IF(A38=0,"",SUM(B38:AE38)) |
|
AO38 |
=IF(A38=0,"",AN38/AM38) |
|
AP38 |
=IF(A38=0,"",COUNTIF(B38:AE38,">99")-AQ38-AR38-AS38) |
|
AQ38 |
=IF(A38=0,"",COUNTIF(B38:AE38,">139")-AR38-AS38) |
|
AR38 |
=IF(A38=0,"",COUNTIF(B38:AE38,">169")-AS38) |
|
AS38 |
=IF(A38=0,"",COUNTIF(B38:AE38,">179")) |
|
AT38 |
=IF(A38=0,"",AP38+AQ38+AR38+AS38) |
|
AM39 |
=IF(A39=0,"",SUM(COUNT(B39:AD39)*3)+AF39) |
|
AN39 |
=IF(A39=0,"",SUM(B39:AE39)) |
|
AO39 |
=IF(A39=0,"",AN39/AM39) |
|
AP39 |
=IF(A39=0,"",COUNTIF(B39:AE39,">99")-AQ39-AR39-AS39) |
|
AQ39 |
=IF(A39=0,"",COUNTIF(B39:AE39,">139")-AR39-AS39) |
|
AR39 |
=IF(A39=0,"",COUNTIF(B39:AE39,">169")-AS39) |
|
AS39 |
=IF(A39=0,"",COUNTIF(B39:AE39,">179")) |
|
AT39 |
=IF(A39=0,"",AP39+AQ39+AR39+AS39) |
|
AM40 |
=IF(A40=0,"",SUM(COUNT(B40:AD40)*3)+AF40) |
|
AN40 |
=IF(A40=0,"",SUM(B40:AE40)) |
|
AO40 |
=IF(A40=0,"",AN40/AM40) |
|
AP40 |
=IF(A40=0,"",COUNTIF(B40:AE40,">99")-AQ40-AR40-AS40) |
|
AQ40 |
=IF(A40=0,"",COUNTIF(B40:AE40,">139")-AR40-AS40) |
|
AR40 |
=IF(A40=0,"",COUNTIF(B40:AE40,">169")-AS40) |
|
AS40 |
=IF(A40=0,"",COUNTIF(B40:AE40,">179")) |
|
AT40 |
=IF(A40=0,"",AP40+AQ40+AR40+AS40) |
|
AM41 |
=IF(A41=0,"",SUM(COUNT(B41:AD41)*3)+AF41) |
|
AN41 |
=IF(A41=0,"",SUM(B41:AE41)) |
|
AO41 |
=IF(A41=0,"",AN41/AM41) |
|
AP41 |
=IF(A41=0,"",COUNTIF(B41:AE41,">99")-AQ41-AR41-AS41) |
|
AQ41 |
=IF(A41=0,"",COUNTIF(B41:AE41,">139")-AR41-AS41) |
|
AR41 |
=IF(A41=0,"",COUNTIF(B41:AE41,">169")-AS41) |
|
AS41 |
=IF(A41=0,"",COUNTIF(B41:AE41,">179")) |
|
AT41 |
=IF(A41=0,"",AP41+AQ41+AR41+AS41) |
|
AM42 |
=IF(A42=0,"",SUM(COUNT(B42:AD42)*3)+AF42) |
|
AN42 |
=IF(A42=0,"",SUM(B42:AE42)) |
|
AO42 |
=IF(A42=0,"",AN42/AM42) |
|
AP42 |
=IF(A42=0,"",COUNTIF(B42:AE42,">99")-AQ42-AR42-AS42) |
|
AQ42 |
=IF(A42=0,"",COUNTIF(B42:AE42,">139")-AR42-AS42) |
|
AR42 |
=IF(A42=0,"",COUNTIF(B42:AE42,">169")-AS42) |
|
AS42 |
=IF(A42=0,"",COUNTIF(B42:AE42,">179")) |
|
AT42 |
=IF(A42=0,"",AP42+AQ42+AR42+AS42) |
|
AM43 |
=IF(A43=0,"",SUM(COUNT(B43:AD43)*3)+AF43) |
|
AN43 |
=IF(A43=0,"",SUM(B43:AE43)) |
|
AO43 |
=IF(A43=0,"",AN43/AM43) |
|
AP43 |
=IF(A43=0,"",COUNTIF(B43:AE43,">99")-AQ43-AR43-AS43) |
|
AQ43 |
=IF(A43=0,"",COUNTIF(B43:AE43,">139")-AR43-AS43) |
|
AR43 |
=IF(A43=0,"",COUNTIF(B43:AE43,">169")-AS43) |
|
AS43 |
=IF(A43=0,"",COUNTIF(B43:AE43,">179")) |
|
AT43 |
=IF(A43=0,"",AP43+AQ43+AR43+AS43) |
|
AM44 |
=IF(A44=0,"",SUM(COUNT(B44:AD44)*3)+AF44) |
|
AN44 |
=IF(A44=0,"",SUM(B44:AE44)) |
|
AO44 |
=IF(A44=0,"",AN44/AM44) |
|
AP44 |
=IF(A44=0,"",COUNTIF(B44:AE44,">99")-AQ44-AR44-AS44) |
|
AQ44 |
=IF(A44=0,"",COUNTIF(B44:AE44,">139")-AR44-AS44) |
|
AR44 |
=IF(A44=0,"",COUNTIF(B44:AE44,">169")-AS44) |
|
AS44 |
=IF(A44=0,"",COUNTIF(B44:AE44,">179")) |
|
AT44 |
=IF(A44=0,"",AP44+AQ44+AR44+AS44) |
|
AM45 |
=IF(A45=0,"",SUM(COUNT(B45:AD45)*3)+AF45) |
|
AN45 |
=IF(A45=0,"",SUM(B45:AE45)) |
|
AO45 |
=IF(A45=0,"",AN45/AM45) |
|
AP45 |
=IF(A45=0,"",COUNTIF(B45:AE45,">99")-AQ45-AR45-AS45) |
|
AQ45 |
=IF(A45=0,"",COUNTIF(B45:AE45,">139")-AR45-AS45) |
|
AR45 |
=IF(A45=0,"",COUNTIF(B45:AE45,">169")-AS45) |
|
AS45 |
=IF(A45=0,"",COUNTIF(B45:AE45,">179")) |
|
AT45 |
=IF(A45=0,"",AP45+AQ45+AR45+AS45) |
|
AM46 |
=IF(A46=0,"",SUM(COUNT(B46:AD46)*3)+AF46) |
|
AN46 |
=IF(A46=0,"",SUM(B46:AE46)) |
|
AO46 |
=IF(A46=0,"",AN46/AM46) |
|
AP46 |
=IF(A46=0,"",COUNTIF(B46:AE46,">99")-AQ46-AR46-AS46) |
|
AQ46 |
=IF(A46=0,"",COUNTIF(B46:AE46,">139")-AR46-AS46) |
|
AR46 |
=IF(A46=0,"",COUNTIF(B46:AE46,">169")-AS46) |
|
AS46 |
=IF(A46=0,"",COUNTIF(B46:AE46,">179")) |
|
AT46 |
=IF(A46=0,"",AP46+AQ46+AR46+AS46) |
|
AM47 |
=IF(A47=0,"",SUM(COUNT(B47:AD47)*3)+AF47) |
|
AN47 |
=IF(A47=0,"",SUM(B47:AE47)) |
|
AO47 |
=IF(A47=0,"",AN47/AM47) |
|
AP47 |
=IF(A47=0,"",COUNTIF(B47:AE47,">99")-AQ47-AR47-AS47) |
|
AQ47 |
=IF(A47=0,"",COUNTIF(B47:AE47,">139")-AR47-AS47) |
|
AR47 |
=IF(A47=0,"",COUNTIF(B47:AE47,">169")-AS47) |
|
AS47 |
=IF(A47=0,"",COUNTIF(B47:AE47,">179")) |
|
AT47 |
=IF(A47=0,"",AP47+AQ47+AR47+AS47) |
|
AM48 |
=IF(A48=0,"",SUM(COUNT(B48:AD48)*3)+AF48) |
|
AN48 |
=IF(A48=0,"",SUM(B48:AE48)) |
|
AO48 |
=IF(A48=0,"",AN48/AM48) |
|
AP48 |
=IF(A48=0,"",COUNTIF(B48:AE48,">99")-AQ48-AR48-AS48) |
|
AQ48 |
=IF(A48=0,"",COUNTIF(B48:AE48,">139")-AR48-AS48) |
|
AR48 |
=IF(A48=0,"",COUNTIF(B48:AE48,">169")-AS48) |
|
AS48 |
=IF(A48=0,"",COUNTIF(B48:AE48,">179")) |
|
AT48 |
=IF(A48=0,"",AP48+AQ48+AR48+AS48) |
|
AM49 |
=IF(A49=0,"",SUM(COUNT(B49:AD49)*3)+AF49) |
|
AN49 |
=IF(A49=0,"",SUM(B49:AE49)) |
|
AO49 |
=IF(A49=0,"",AN49/AM49) |
|
AP49 |
=IF(A49=0,"",COUNTIF(B49:AE49,">99")-AQ49-AR49-AS49) |
|
AQ49 |
=IF(A49=0,"",COUNTIF(B49:AE49,">139")-AR49-AS49) |
|
AR49 |
=IF(A49=0,"",COUNTIF(B49:AE49,">169")-AS49) |
|
AS49 |
=IF(A49=0,"",COUNTIF(B49:AE49,">179")) |
|
AT49 |
=IF(A49=0,"",AP49+AQ49+AR49+AS49) |
|
AM50 |
=IF(A50=0,"",SUM(COUNT(B50:AD50)*3)+AF50) |
|
AN50 |
=IF(A50=0,"",SUM(B50:AE50)) |
|
AO50 |
=IF(A50=0,"",AN50/AM50) |
|
AP50 |
=IF(A50=0,"",COUNTIF(B50:AE50,">99")-AQ50-AR50-AS50) |
|
AQ50 |
=IF(A50=0,"",COUNTIF(B50:AE50,">139")-AR50-AS50) |
|
AR50 |
=IF(A50=0,"",COUNTIF(B50:AE50,">169")-AS50) |
|
AS50 |
=IF(A50=0,"",COUNTIF(B50:AE50,">179")) |
|
AT50 |
=IF(A50=0,"",AP50+AQ50+AR50+AS50) |
|
AM51 |
=IF(A51=0,"",SUM(COUNT(B51:AD51)*3)+AF51) |
|
AN51 |
=IF(A51=0,"",SUM(B51:AE51)) |
|
AO51 |
=IF(A51=0,"",AN51/AM51) |
|
AP51 |
=IF(A51=0,"",COUNTIF(B51:AE51,">99")-AQ51-AR51-AS51) |
|
AQ51 |
=IF(A51=0,"",COUNTIF(B51:AE51,">139")-AR51-AS51) |
|
AR51 |
=IF(A51=0,"",COUNTIF(B51:AE51,">169")-AS51) |
|
AS51 |
=IF(A51=0,"",COUNTIF(B51:AE51,">179")) |
|
AT51 |
=IF(A51=0,"",AP51+AQ51+AR51+AS51) |
|
AM52 |
=IF(A52=0,"",SUM(COUNT(B52:AD52)*3)+AF52) |
|
AN52 |
=IF(A52=0,"",SUM(B52:AE52)) |
|
AO52 |
=IF(A52=0,"",AN52/AM52) |
|
AP52 |
=IF(A52=0,"",COUNTIF(B52:AE52,">99")-AQ52-AR52-AS52) |
|
AQ52 |
=IF(A52=0,"",COUNTIF(B52:AE52,">139")-AR52-AS52) |
|
AR52 |
=IF(A52=0,"",COUNTIF(B52:AE52,">169")-AS52) |
|
AS52 |
=IF(A52=0,"",COUNTIF(B52:AE52,">179")) |
|
AT52 |
=IF(A52=0,"",AP52+AQ52+AR52+AS52) |
|
AM53 |
=IF(A53=0,"",SUM(COUNT(B53:AD53)*3)+AF53) |
|
AN53 |
=IF(A53=0,"",SUM(B53:AE53)) |
|
AO53 |
=IF(A53=0,"",AN53/AM53) |
|
AP53 |
=IF(A53=0,"",COUNTIF(B53:AE53,">99")-AQ53-AR53-AS53) |
|
AQ53 |
=IF(A53=0,"",COUNTIF(B53:AE53,">139")-AR53-AS53) |
|
AR53 |
=IF(A53=0,"",COUNTIF(B53:AE53,">169")-AS53) |
|
AS53 |
=IF(A53=0,"",COUNTIF(B53:AE53,">179")) |
|
AT53 |
=IF(A53=0,"",AP53+AQ53+AR53+AS53) |
|
AM54 |
=IF(A54=0,"",SUM(COUNT(B54:AD54)*3)+AF54) |
|
AN54 |
=IF(A54=0,"",SUM(B54:AE54)) |
|
AO54 |
=IF(A54=0,"",AN54/AM54) |
|
AP54 |
=IF(A54=0,"",COUNTIF(B54:AE54,">99")-AQ54-AR54-AS54) |
|
AQ54 |
=IF(A54=0,"",COUNTIF(B54:AE54,">139")-AR54-AS54) |
|
AR54 |
=IF(A54=0,"",COUNTIF(B54:AE54,">169")-AS54) |
|
AS54 |
=IF(A54=0,"",COUNTIF(B54:AE54,">179")) |
|
AT54 |
=IF(A54=0,"",AP54+AQ54+AR54+AS54) |
|
AM55 |
=IF(A55=0,"",SUM(COUNT(B55:AD55)*3)+AF55) |
|
AN55 |
=IF(A55=0,"",SUM(B55:AE55)) |
|
AO55 |
=IF(A55=0,"",AN55/AM55) |
|
AP55 |
=IF(A55=0,"",COUNTIF(B55:AE55,">99")-AQ55-AR55-AS55) |
|
AQ55 |
=IF(A55=0,"",COUNTIF(B55:AE55,">139")-AR55-AS55) |
|
AR55 |
=IF(A55=0,"",COUNTIF(B55:AE55,">169")-AS55) |
|
AS55 |
=IF(A55=0,"",COUNTIF(B55:AE55,">179")) |
|
AT55 |
=IF(A55=0,"",AP55+AQ55+AR55+AS55) |
|
AM56 |
=IF(A56=0,"",SUM(COUNT(B56:AD56)*3)+AF56) |
|
AN56 |
=IF(A56=0,"",SUM(B56:AE56)) |
|
AO56 |
=IF(A56=0,"",AN56/AM56) |
|
AP56 |
=IF(A56=0,"",COUNTIF(B56:AE56,">99")-AQ56-AR56-AS56) |
|
AQ56 |
=IF(A56=0,"",COUNTIF(B56:AE56,">139")-AR56-AS56) |
|
AR56 |
=IF(A56=0,"",COUNTIF(B56:AE56,">169")-AS56) |
|
AS56 |
=IF(A56=0,"",COUNTIF(B56:AE56,">179")) |
|
AT56 |
=IF(A56=0,"",AP56+AQ56+AR56+AS56) |
|
AM57 |
=IF(A57=0,"",SUM(COUNT(B57:AD57)*3)+AF57) |
|
AN57 |
=IF(A57=0,"",SUM(B57:AE57)) |
|
AO57 |
=IF(A57=0,"",AN57/AM57) |
|
AP57 |
=IF(A57=0,"",COUNTIF(B57:AE57,">99")-AQ57-AR57-AS57) |
|
AQ57 |
=IF(A57=0,"",COUNTIF(B57:AE57,">139")-AR57-AS57) |
|
AR57 |
=IF(A57=0,"",COUNTIF(B57:AE57,">169")-AS57) |
|
AS57 |
=IF(A57=0,"",COUNTIF(B57:AE57,">179")) |
|
AT57 |
=IF(A57=0,"",AP57+AQ57+AR57+AS57) |
|
AM58 |
=IF(A58=0,"",SUM(COUNT(B58:AD58)*3)+AF58) |
|
AN58 |
=IF(A58=0,"",SUM(B58:AE58)) |
|
AO58 |
=IF(A58=0,"",AN58/AM58) |
|
AP58 |
=IF(A58=0,"",COUNTIF(B58:AE58,">99")-AQ58-AR58-AS58) |
|
AQ58 |
=IF(A58=0,"",COUNTIF(B58:AE58,">139")-AR58-AS58) |
|
AR58 |
=IF(A58=0,"",COUNTIF(B58:AE58,">169")-AS58) |
|
AS58 |
=IF(A58=0,"",COUNTIF(B58:AE58,">179")) |
|
AT58 |
=IF(A58=0,"",AP58+AQ58+AR58+AS58) |
|
AM61 |
=IF(A61=0,"",SUM(COUNT(B61:AD61)*3)+AF61) |
|
AN61 |
=IF(A61=0,"",SUM(B61:AE61)) |
|
AO61 |
=IF(A61=0,"",AN61/AM61) |
|
AP61 |
=IF(A61=0,"",COUNTIF(B61:AE61,">99")-AQ61-AR61-AS61) |
|
AQ61 |
=IF(A61=0,"",COUNTIF(B61:AE61,">139")-AR61-AS61) |
|
AR61 |
=IF(A61=0,"",COUNTIF(B61:AE61,">169")-AS61) |
|
AS61 |
=IF(A61=0,"",COUNTIF(B61:AE61,">179")) |
|
AT61 |
=IF(A61=0,"",AP61+AQ61+AR61+AS61) |
|
AM62 |
=IF(A62=0,"",SUM(COUNT(B62:AD62)*3)+AF62) |
|
AN62 |
=IF(A62=0,"",SUM(B62:AE62)) |
|
AO62 |
=IF(A62=0,"",AN62/AM62) |
|
AP62 |
=IF(A62=0,"",COUNTIF(B62:AE62,">99")-AQ62-AR62-AS62) |
|
AQ62 |
=IF(A62=0,"",COUNTIF(B62:AE62,">139")-AR62-AS62) |
|
AR62 |
=IF(A62=0,"",COUNTIF(B62:AE62,">169")-AS62) |
|
AS62 |
=IF(A62=0,"",COUNTIF(B62:AE62,">179")) |
|
AT62 |
=IF(A62=0,"",AP62+AQ62+AR62+AS62) |
|
|
|
|