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