Address |
Clive |
Value |
AG3 |
=findred(B3:AE3)*3 |
0 |
AH3 |
=IF(A3=0,"",AL3/(AK3-AG3)) |
|
AI3 |
=SUM(IF(ISERROR(501-AL3),0,501-AL3)) |
0 |
AJ3 |
=SUM(IF(ISERROR(AM3*3),0,AM3*3)) |
0 |
AG4 |
=findred(B4:AE4)*3 |
0 |
AH4 |
=IF(A4=0,"",AL4/(AK4-AG4)) |
|
AI4 |
=SUM(IF(ISERROR(501-AL4),0,501-AL4)) |
0 |
AJ4 |
=SUM(IF(ISERROR(AM4*3),0,AM4*3)) |
0 |
AG5 |
=findred(B5:AE5)*3 |
0 |
AH5 |
=IF(A5=0,"",AL5/(AK5-AG5)) |
|
AI5 |
=SUM(IF(ISERROR(501-AL5),0,501-AL5)) |
0 |
AJ5 |
=SUM(IF(ISERROR(AM5*3),0,AM5*3)) |
0 |
AG6 |
=findred(B6:AE6)*3 |
0 |
AH6 |
=IF(A6=0,"",AL6/(AK6-AG6)) |
|
AI6 |
=SUM(IF(ISERROR(501-AL6),0,501-AL6)) |
0 |
AJ6 |
=SUM(IF(ISERROR(AM6*3),0,AM6*3)) |
0 |
AG7 |
=findred(B7:AE7)*3 |
0 |
AH7 |
=IF(A7=0,"",AL7/(AK7-AG7)) |
|
AI7 |
=SUM(IF(ISERROR(501-AL7),0,501-AL7)) |
0 |
AJ7 |
=SUM(IF(ISERROR(AM7*3),0,AM7*3)) |
0 |
AG8 |
=findred(B8:AE8)*3 |
0 |
AH8 |
=IF(A8=0,"",AL8/(AK8-AG8)) |
|
AI8 |
=SUM(IF(ISERROR(501-AL8),0,501-AL8)) |
0 |
AJ8 |
=SUM(IF(ISERROR(AM8*3),0,AM8*3)) |
0 |
AG9 |
=findred(B9:AE9)*3 |
0 |
AH9 |
=IF(A9=0,"",AL9/(AK9-AG9)) |
|
AI9 |
=SUM(IF(ISERROR(501-AL9),0,501-AL9)) |
0 |
AJ9 |
=SUM(IF(ISERROR(AM9*3),0,AM9*3)) |
0 |
AG10 |
=findred(B10:AE10)*3 |
0 |
AH10 |
=IF(A10=0,"",AL10/(AK10-AG10)) |
|
AI10 |
=SUM(IF(ISERROR(501-AL10),0,501-AL10)) |
0 |
AJ10 |
=SUM(IF(ISERROR(AM10*3),0,AM10*3)) |
0 |
AG11 |
=findred(B11:AE11)*3 |
0 |
AH11 |
=IF(A11=0,"",AL11/(AK11-AG11)) |
|
AI11 |
=SUM(IF(ISERROR(501-AL11),0,501-AL11)) |
0 |
AJ11 |
=SUM(IF(ISERROR(AM11*3),0,AM11*3)) |
0 |
AG12 |
=findred(B12:AE12)*3 |
0 |
AH12 |
=IF(A12=0,"",AL12/(AK12-AG12)) |
|
AI12 |
=SUM(IF(ISERROR(501-AL12),0,501-AL12)) |
0 |
AJ12 |
=SUM(IF(ISERROR(AM12*3),0,AM12*3)) |
0 |
AG13 |
=findred(B13:AE13)*3 |
0 |
AH13 |
=IF(A13=0,"",AL13/(AK13-AG13)) |
|
AI13 |
=SUM(IF(ISERROR(501-AL13),0,501-AL13)) |
0 |
AJ13 |
=SUM(IF(ISERROR(AM13*3),0,AM13*3)) |
0 |
AG14 |
=findred(B14:AE14)*3 |
0 |
AH14 |
=IF(A14=0,"",AL14/(AK14-AG14)) |
|
AI14 |
=SUM(IF(ISERROR(501-AL14),0,501-AL14)) |
0 |
AJ14 |
=SUM(IF(ISERROR(AM14*3),0,AM14*3)) |
0 |
AG15 |
=findred(B15:AE15)*3 |
0 |
AH15 |
=IF(A15=0,"",AL15/(AK15-AG15)) |
|
AI15 |
=SUM(IF(ISERROR(501-AL15),0,501-AL15)) |
0 |
AJ15 |
=SUM(IF(ISERROR(AM15*3),0,AM15*3)) |
0 |
AG16 |
=findred(B16:AE16)*3 |
0 |
AH16 |
=IF(A16=0,"",AL16/(AK16-AG16)) |
|
AI16 |
=SUM(IF(ISERROR(501-AL16),0,501-AL16)) |
0 |
AJ16 |
=SUM(IF(ISERROR(AM16*3),0,AM16*3)) |
0 |
AG17 |
=findred(B17:AE17)*3 |
0 |
AH17 |
=IF(A17=0,"",AL17/(AK17-AG17)) |
|
AI17 |
=SUM(IF(ISERROR(501-AL17),0,501-AL17)) |
0 |
AJ17 |
=SUM(IF(ISERROR(AM17*3),0,AM17*3)) |
0 |
AG18 |
=findred(B18:AE18)*3 |
0 |
AH18 |
=IF(A18=0,"",AL18/(AK18-AG18)) |
|
AI18 |
=SUM(IF(ISERROR(501-AL18),0,501-AL18)) |
0 |
AJ18 |
=SUM(IF(ISERROR(AM18*3),0,AM18*3)) |
0 |
AG19 |
=findred(B19:AE19)*3 |
0 |
AH19 |
=IF(A19=0,"",AL19/(AK19-AG19)) |
|
AI19 |
=SUM(IF(ISERROR(501-AL19),0,501-AL19)) |
0 |
AJ19 |
=SUM(IF(ISERROR(AM19*3),0,AM19*3)) |
0 |
AG20 |
=findred(B20:AE20)*3 |
0 |
AH20 |
=IF(A20=0,"",AL20/(AK20-AG20)) |
|
AI20 |
=SUM(IF(ISERROR(501-AL20),0,501-AL20)) |
0 |
AJ20 |
=SUM(IF(ISERROR(AM20*3),0,AM20*3)) |
0 |
AG21 |
=findred(B21:AE21)*3 |
0 |
AH21 |
=IF(A21=0,"",AL21/(AK21-AG21)) |
|
AI21 |
=SUM(IF(ISERROR(501-AL21),0,501-AL21)) |
0 |
AJ21 |
=SUM(IF(ISERROR(AM21*3),0,AM21*3)) |
0 |
AG22 |
=findred(B22:AE22)*3 |
0 |
AH22 |
=IF(A22=0,"",AL22/(AK22-AG22)) |
|
AI22 |
=SUM(IF(ISERROR(501-AL22),0,501-AL22)) |
0 |
AJ22 |
=SUM(IF(ISERROR(AM22*3),0,AM22*3)) |
0 |
AG23 |
=findred(B23:AE23)*3 |
0 |
AH23 |
=IF(A23=0,"",AL23/(AK23-AG23)) |
|
AI23 |
=SUM(IF(ISERROR(501-AL23),0,501-AL23)) |
0 |
AJ23 |
=SUM(IF(ISERROR(AM23*3),0,AM23*3)) |
0 |
AG24 |
=findred(B24:AE24)*3 |
0 |
AH24 |
=IF(A24=0,"",AL24/(AK24-AG24)) |
|
AI24 |
=SUM(IF(ISERROR(501-AL24),0,501-AL24)) |
0 |
AJ24 |
=SUM(IF(ISERROR(AM24*3),0,AM24*3)) |
0 |
AG25 |
=findred(B25:AE25)*3 |
0 |
AH25 |
=IF(A25=0,"",AL25/(AK25-AG25)) |
|
AI25 |
=SUM(IF(ISERROR(501-AL25),0,501-AL25)) |
0 |
AJ25 |
=SUM(IF(ISERROR(AM25*3),0,AM25*3)) |
0 |
AG26 |
=findred(B26:AE26)*3 |
0 |
AH26 |
=IF(A26=0,"",AL26/(AK26-AG26)) |
|
AI26 |
=SUM(IF(ISERROR(501-AL26),0,501-AL26)) |
0 |
AJ26 |
=SUM(IF(ISERROR(AM26*3),0,AM26*3)) |
0 |
AG27 |
=findred(B27:AE27)*3 |
0 |
AH27 |
=IF(A27=0,"",AL27/(AK27-AG27)) |
|
AI27 |
=SUM(IF(ISERROR(501-AL27),0,501-AL27)) |
0 |
AJ27 |
=SUM(IF(ISERROR(AM27*3),0,AM27*3)) |
0 |
AG28 |
=findred(B28:AE28)*3 |
0 |
AH28 |
=IF(A28=0,"",AL28/(AK28-AG28)) |
|
AI28 |
=SUM(IF(ISERROR(501-AL28),0,501-AL28)) |
0 |
AJ28 |
=SUM(IF(ISERROR(AM28*3),0,AM28*3)) |
0 |
AG29 |
=findred(B29:AE29)*3 |
0 |
AH29 |
=IF(A29=0,"",AL29/(AK29-AG29)) |
|
AI29 |
=SUM(IF(ISERROR(501-AL29),0,501-AL29)) |
0 |
AJ29 |
=SUM(IF(ISERROR(AM29*3),0,AM29*3)) |
0 |
AK3 |
=IF(A3=0,"",SUM(COUNT(B3:AD3)*3)+AF3) |
|
AL3 |
=IF(A3=0,"",SUM(B3:AE3)) |
|
AM3 |
=IF(A3=0,"",AL3/AK3) |
|
AN3 |
=IF(A3=0,"",COUNTIF(B3:AE3,">99")-AO3-AP3-AQ3) |
|
AO3 |
=IF(A3=0,"",COUNTIF(B3:AE3,">139")-AP3-AQ3) |
|
AP3 |
=IF(A3=0,"",COUNTIF(B3:AE3,">169")-AQ3) |
|
AQ3 |
=IF(A3=0,"",COUNTIF(B3:AE3,">179")) |
|
AR3 |
=IF(A3=0,"",AN3+AO3+AP3+AQ3) |
|
AK4 |
=IF(A4=0,"",SUM(COUNT(B4:AD4)*3)+AF4) |
|
AL4 |
=IF(A4=0,"",SUM(B4:AE4)) |
|
AM4 |
=IF(A4=0,"",AL4/AK4) |
|
AN4 |
=IF(A4=0,"",COUNTIF(B4:AE4,">99")-AO4-AP4-AQ4) |
|
AO4 |
=IF(A4=0,"",COUNTIF(B4:AE4,">139")-AP4-AQ4) |
|
AP4 |
=IF(A4=0,"",COUNTIF(B4:AE4,">169")-AQ4) |
|
AQ4 |
=IF(A4=0,"",COUNTIF(B4:AE4,">179")) |
|
AR4 |
=IF(A4=0,"",AN4+AO4+AP4+AQ4) |
|
AK5 |
=IF(A5=0,"",SUM(COUNT(B5:AD5)*3)+AF5) |
|
AL5 |
=IF(A5=0,"",SUM(B5:AE5)) |
|
AM5 |
=IF(A5=0,"",AL5/AK5) |
|
AN5 |
=IF(A5=0,"",COUNTIF(B5:AE5,">99")-AO5-AP5-AQ5) |
|
AO5 |
=IF(A5=0,"",COUNTIF(B5:AE5,">139")-AP5-AQ5) |
|
AP5 |
=IF(A5=0,"",COUNTIF(B5:AE5,">169")-AQ5) |
|
AQ5 |
=IF(A5=0,"",COUNTIF(B5:AE5,">179")) |
|
AR5 |
=IF(A5=0,"",AN5+AO5+AP5+AQ5) |
|
AK6 |
=IF(A6=0,"",SUM(COUNT(B6:AD6)*3)+AF6) |
|
AL6 |
=IF(A6=0,"",SUM(B6:AE6)) |
|
AM6 |
=IF(A6=0,"",AL6/AK6) |
|
AN6 |
=IF(A6=0,"",COUNTIF(B6:AE6,">99")-AO6-AP6-AQ6) |
|
AO6 |
=IF(A6=0,"",COUNTIF(B6:AE6,">139")-AP6-AQ6) |
|
AP6 |
=IF(A6=0,"",COUNTIF(B6:AE6,">169")-AQ6) |
|
AQ6 |
=IF(A6=0,"",COUNTIF(B6:AE6,">179")) |
|
AR6 |
=IF(A6=0,"",AN6+AO6+AP6+AQ6) |
|
AK7 |
=IF(A7=0,"",SUM(COUNT(B7:AD7)*3)+AF7) |
|
AL7 |
=IF(A7=0,"",SUM(B7:AE7)) |
|
AM7 |
=IF(A7=0,"",AL7/AK7) |
|
AN7 |
=IF(A7=0,"",COUNTIF(B7:AE7,">99")-AO7-AP7-AQ7) |
|
AO7 |
=IF(A7=0,"",COUNTIF(B7:AE7,">139")-AP7-AQ7) |
|
AP7 |
=IF(A7=0,"",COUNTIF(B7:AE7,">169")-AQ7) |
|
AQ7 |
=IF(A7=0,"",COUNTIF(B7:AE7,">179")) |
|
AR7 |
=IF(A7=0,"",AN7+AO7+AP7+AQ7) |
|
AK8 |
=IF(A8=0,"",SUM(COUNT(B8:AD8)*3)+AF8) |
|
AL8 |
=IF(A8=0,"",SUM(B8:AE8)) |
|
AM8 |
=IF(A8=0,"",AL8/AK8) |
|
AN8 |
=IF(A8=0,"",COUNTIF(B8:AE8,">99")-AO8-AP8-AQ8) |
|
AO8 |
=IF(A8=0,"",COUNTIF(B8:AE8,">139")-AP8-AQ8) |
|
AP8 |
=IF(A8=0,"",COUNTIF(B8:AE8,">169")-AQ8) |
|
AQ8 |
=IF(A8=0,"",COUNTIF(B8:AE8,">179")) |
|
AR8 |
=IF(A8=0,"",AN8+AO8+AP8+AQ8) |
|
AK9 |
=IF(A9=0,"",SUM(COUNT(B9:AD9)*3)+AF9) |
|
AL9 |
=IF(A9=0,"",SUM(B9:AE9)) |
|
AM9 |
=IF(A9=0,"",AL9/AK9) |
|
AN9 |
=IF(A9=0,"",COUNTIF(B9:AE9,">99")-AO9-AP9-AQ9) |
|
AO9 |
=IF(A9=0,"",COUNTIF(B9:AE9,">139")-AP9-AQ9) |
|
AP9 |
=IF(A9=0,"",COUNTIF(B9:AE9,">169")-AQ9) |
|
AQ9 |
=IF(A9=0,"",COUNTIF(B9:AE9,">179")) |
|
AR9 |
=IF(A9=0,"",AN9+AO9+AP9+AQ9) |
|
AK10 |
=IF(A10=0,"",SUM(COUNT(B10:AD10)*3)+AF10) |
|
AL10 |
=IF(A10=0,"",SUM(B10:AE10)) |
|
AM10 |
=IF(A10=0,"",AL10/AK10) |
|
AN10 |
=IF(A10=0,"",COUNTIF(B10:AE10,">99")-AO10-AP10-AQ10) |
|
AO10 |
=IF(A10=0,"",COUNTIF(B10:AE10,">139")-AP10-AQ10) |
|
AP10 |
=IF(A10=0,"",COUNTIF(B10:AE10,">169")-AQ10) |
|
AQ10 |
=IF(A10=0,"",COUNTIF(B10:AE10,">179")) |
|
AR10 |
=IF(A10=0,"",AN10+AO10+AP10+AQ10) |
|
AK11 |
=IF(A11=0,"",SUM(COUNT(B11:AD11)*3)+AF11) |
|
AL11 |
=IF(A11=0,"",SUM(B11:AE11)) |
|
AM11 |
=IF(A11=0,"",AL11/AK11) |
|
AN11 |
=IF(A11=0,"",COUNTIF(B11:AE11,">99")-AO11-AP11-AQ11) |
|
AO11 |
=IF(A11=0,"",COUNTIF(B11:AE11,">139")-AP11-AQ11) |
|
AP11 |
=IF(A11=0,"",COUNTIF(B11:AE11,">169")-AQ11) |
|
AQ11 |
=IF(A11=0,"",COUNTIF(B11:AE11,">179")) |
|
AR11 |
=IF(A11=0,"",AN11+AO11+AP11+AQ11) |
|
AK12 |
=IF(A12=0,"",SUM(COUNT(B12:AD12)*3)+AF12) |
|
AL12 |
=IF(A12=0,"",SUM(B12:AE12)) |
|
AM12 |
=IF(A12=0,"",AL12/AK12) |
|
AN12 |
=IF(A12=0,"",COUNTIF(B12:AE12,">99")-AO12-AP12-AQ12) |
|
AO12 |
=IF(A12=0,"",COUNTIF(B12:AE12,">139")-AP12-AQ12) |
|
AP12 |
=IF(A12=0,"",COUNTIF(B12:AE12,">169")-AQ12) |
|
AQ12 |
=IF(A12=0,"",COUNTIF(B12:AE12,">179")) |
|
AR12 |
=IF(A12=0,"",AN12+AO12+AP12+AQ12) |
|
AK13 |
=IF(A13=0,"",SUM(COUNT(B13:AD13)*3)+AF13) |
|
AL13 |
=IF(A13=0,"",SUM(B13:AE13)) |
|
AM13 |
=IF(A13=0,"",AL13/AK13) |
|
AN13 |
=IF(A13=0,"",COUNTIF(B13:AE13,">99")-AO13-AP13-AQ13) |
|
AO13 |
=IF(A13=0,"",COUNTIF(B13:AE13,">139")-AP13-AQ13) |
|
AP13 |
=IF(A13=0,"",COUNTIF(B13:AE13,">169")-AQ13) |
|
AQ13 |
=IF(A13=0,"",COUNTIF(B13:AE13,">179")) |
|
AR13 |
=IF(A13=0,"",AN13+AO13+AP13+AQ13) |
|
AK14 |
=IF(A14=0,"",SUM(COUNT(B14:AD14)*3)+AF14) |
|
AL14 |
=IF(A14=0,"",SUM(B14:AE14)) |
|
AM14 |
=IF(A14=0,"",AL14/AK14) |
|
AN14 |
=IF(A14=0,"",COUNTIF(B14:AE14,">99")-AO14-AP14-AQ14) |
|
AO14 |
=IF(A14=0,"",COUNTIF(B14:AE14,">139")-AP14-AQ14) |
|
AP14 |
=IF(A14=0,"",COUNTIF(B14:AE14,">169")-AQ14) |
|
AQ14 |
=IF(A14=0,"",COUNTIF(B14:AE14,">179")) |
|
AR14 |
=IF(A14=0,"",AN14+AO14+AP14+AQ14) |
|
AK15 |
=IF(A15=0,"",SUM(COUNT(B15:AD15)*3)+AF15) |
|
AL15 |
=IF(A15=0,"",SUM(B15:AE15)) |
|
AM15 |
=IF(A15=0,"",AL15/AK15) |
|
AN15 |
=IF(A15=0,"",COUNTIF(B15:AE15,">99")-AO15-AP15-AQ15) |
|
AO15 |
=IF(A15=0,"",COUNTIF(B15:AE15,">139")-AP15-AQ15) |
|
AP15 |
=IF(A15=0,"",COUNTIF(B15:AE15,">169")-AQ15) |
|
AQ15 |
=IF(A15=0,"",COUNTIF(B15:AE15,">179")) |
|
AR15 |
=IF(A15=0,"",AN15+AO15+AP15+AQ15) |
|
AK16 |
=IF(A16=0,"",SUM(COUNT(B16:AD16)*3)+AF16) |
|
AL16 |
=IF(A16=0,"",SUM(B16:AE16)) |
|
AM16 |
=IF(A16=0,"",AL16/AK16) |
|
AN16 |
=IF(A16=0,"",COUNTIF(B16:AE16,">99")-AO16-AP16-AQ16) |
|
AO16 |
=IF(A16=0,"",COUNTIF(B16:AE16,">139")-AP16-AQ16) |
|
AP16 |
=IF(A16=0,"",COUNTIF(B16:AE16,">169")-AQ16) |
|
AQ16 |
=IF(A16=0,"",COUNTIF(B16:AE16,">179")) |
|
AR16 |
=IF(A16=0,"",AN16+AO16+AP16+AQ16) |
|
AK17 |
=IF(A17=0,"",SUM(COUNT(B17:AD17)*3)+AF17) |
|
AL17 |
=IF(A17=0,"",SUM(B17:AE17)) |
|
AM17 |
=IF(A17=0,"",AL17/AK17) |
|
AN17 |
=IF(A17=0,"",COUNTIF(B17:AE17,">99")-AO17-AP17-AQ17) |
|
AO17 |
=IF(A17=0,"",COUNTIF(B17:AE17,">139")-AP17-AQ17) |
|
AP17 |
=IF(A17=0,"",COUNTIF(B17:AE17,">169")-AQ17) |
|
AQ17 |
=IF(A17=0,"",COUNTIF(B17:AE17,">179")) |
|
AR17 |
=IF(A17=0,"",AN17+AO17+AP17+AQ17) |
|
AK18 |
=IF(A18=0,"",SUM(COUNT(B18:AD18)*3)+AF18) |
|
AL18 |
=IF(A18=0,"",SUM(B18:AE18)) |
|
AM18 |
=IF(A18=0,"",AL18/AK18) |
|
AN18 |
=IF(A18=0,"",COUNTIF(B18:AE18,">99")-AO18-AP18-AQ18) |
|
AO18 |
=IF(A18=0,"",COUNTIF(B18:AE18,">139")-AP18-AQ18) |
|
AP18 |
=IF(A18=0,"",COUNTIF(B18:AE18,">169")-AQ18) |
|
AQ18 |
=IF(A18=0,"",COUNTIF(B18:AE18,">179")) |
|
AR18 |
=IF(A18=0,"",AN18+AO18+AP18+AQ18) |
|
AK19 |
=IF(A19=0,"",SUM(COUNT(B19:AD19)*3)+AF19) |
|
AL19 |
=IF(A19=0,"",SUM(B19:AE19)) |
|
AM19 |
=IF(A19=0,"",AL19/AK19) |
|
AN19 |
=IF(A19=0,"",COUNTIF(B19:AE19,">99")-AO19-AP19-AQ19) |
|
AO19 |
=IF(A19=0,"",COUNTIF(B19:AE19,">139")-AP19-AQ19) |
|
AP19 |
=IF(A19=0,"",COUNTIF(B19:AE19,">169")-AQ19) |
|
AQ19 |
=IF(A19=0,"",COUNTIF(B19:AE19,">179")) |
|
AR19 |
=IF(A19=0,"",AN19+AO19+AP19+AQ19) |
|
AK20 |
=IF(A20=0,"",SUM(COUNT(B20:AD20)*3)+AF20) |
|
AL20 |
=IF(A20=0,"",SUM(B20:AE20)) |
|
AM20 |
=IF(A20=0,"",AL20/AK20) |
|
AN20 |
=IF(A20=0,"",COUNTIF(B20:AE20,">99")-AO20-AP20-AQ20) |
|
AO20 |
=IF(A20=0,"",COUNTIF(B20:AE20,">139")-AP20-AQ20) |
|
AP20 |
=IF(A20=0,"",COUNTIF(B20:AE20,">169")-AQ20) |
|
AQ20 |
=IF(A20=0,"",COUNTIF(B20:AE20,">179")) |
|
AR20 |
=IF(A20=0,"",AN20+AO20+AP20+AQ20) |
|
AK21 |
=IF(A21=0,"",SUM(COUNT(B21:AD21)*3)+AF21) |
|
AL21 |
=IF(A21=0,"",SUM(B21:AE21)) |
|
AM21 |
=IF(A21=0,"",AL21/AK21) |
|
AN21 |
=IF(A21=0,"",COUNTIF(B21:AE21,">99")-AO21-AP21-AQ21) |
|
AO21 |
=IF(A21=0,"",COUNTIF(B21:AE21,">139")-AP21-AQ21) |
|
AP21 |
=IF(A21=0,"",COUNTIF(B21:AE21,">169")-AQ21) |
|
AQ21 |
=IF(A21=0,"",COUNTIF(B21:AE21,">179")) |
|
AR21 |
=IF(A21=0,"",AN21+AO21+AP21+AQ21) |
|
AK22 |
=IF(A22=0,"",SUM(COUNT(B22:AD22)*3)+AF22) |
|
AL22 |
=IF(A22=0,"",SUM(B22:AE22)) |
|
AM22 |
=IF(A22=0,"",AL22/AK22) |
|
AN22 |
=IF(A22=0,"",COUNTIF(B22:AE22,">99")-AO22-AP22-AQ22) |
|
AO22 |
=IF(A22=0,"",COUNTIF(B22:AE22,">139")-AP22-AQ22) |
|
AP22 |
=IF(A22=0,"",COUNTIF(B22:AE22,">169")-AQ22) |
|
AQ22 |
=IF(A22=0,"",COUNTIF(B22:AE22,">179")) |
|
AR22 |
=IF(A22=0,"",AN22+AO22+AP22+AQ22) |
|
AK23 |
=IF(A23=0,"",SUM(COUNT(B23:AD23)*3)+AF23) |
|
AL23 |
=IF(A23=0,"",SUM(B23:AE23)) |
|
AM23 |
=IF(A23=0,"",AL23/AK23) |
|
AN23 |
=IF(A23=0,"",COUNTIF(B23:AE23,">99")-AO23-AP23-AQ23) |
|
AO23 |
=IF(A23=0,"",COUNTIF(B23:AE23,">139")-AP23-AQ23) |
|
AP23 |
=IF(A23=0,"",COUNTIF(B23:AE23,">169")-AQ23) |
|
AQ23 |
=IF(A23=0,"",COUNTIF(B23:AE23,">179")) |
|
AR23 |
=IF(A23=0,"",AN23+AO23+AP23+AQ23) |
|
AK24 |
=IF(A24=0,"",SUM(COUNT(B24:AD24)*3)+AF24) |
|
AL24 |
=IF(A24=0,"",SUM(B24:AE24)) |
|
AM24 |
=IF(A24=0,"",AL24/AK24) |
|
AN24 |
=IF(A24=0,"",COUNTIF(B24:AE24,">99")-AO24-AP24-AQ24) |
|
AO24 |
=IF(A24=0,"",COUNTIF(B24:AE24,">139")-AP24-AQ24) |
|
AP24 |
=IF(A24=0,"",COUNTIF(B24:AE24,">169")-AQ24) |
|
AQ24 |
=IF(A24=0,"",COUNTIF(B24:AE24,">179")) |
|
AR24 |
=IF(A24=0,"",AN24+AO24+AP24+AQ24) |
|
AK25 |
=IF(A25=0,"",SUM(COUNT(B25:AD25)*3)+AF25) |
|
AL25 |
=IF(A25=0,"",SUM(B25:AE25)) |
|
AM25 |
=IF(A25=0,"",AL25/AK25) |
|
AN25 |
=IF(A25=0,"",COUNTIF(B25:AE25,">99")-AO25-AP25-AQ25) |
|
AO25 |
=IF(A25=0,"",COUNTIF(B25:AE25,">139")-AP25-AQ25) |
|
AP25 |
=IF(A25=0,"",COUNTIF(B25:AE25,">169")-AQ25) |
|
AQ25 |
=IF(A25=0,"",COUNTIF(B25:AE25,">179")) |
|
AR25 |
=IF(A25=0,"",AN25+AO25+AP25+AQ25) |
|
AK26 |
=IF(A26=0,"",SUM(COUNT(B26:AD26)*3)+AF26) |
|
AL26 |
=IF(A26=0,"",SUM(B26:AE26)) |
|
AM26 |
=IF(A26=0,"",AL26/AK26) |
|
AN26 |
=IF(A26=0,"",COUNTIF(B26:AE26,">99")-AO26-AP26-AQ26) |
|
AO26 |
=IF(A26=0,"",COUNTIF(B26:AE26,">139")-AP26-AQ26) |
|
AP26 |
=IF(A26=0,"",COUNTIF(B26:AE26,">169")-AQ26) |
|
AQ26 |
=IF(A26=0,"",COUNTIF(B26:AE26,">179")) |
|
AR26 |
=IF(A26=0,"",AN26+AO26+AP26+AQ26) |
|
AK27 |
=IF(A27=0,"",SUM(COUNT(B27:AD27)*3)+AF27) |
|
AL27 |
=IF(A27=0,"",SUM(B27:AE27)) |
|
AM27 |
=IF(A27=0,"",AL27/AK27) |
|
AN27 |
=IF(A27=0,"",COUNTIF(B27:AE27,">99")-AO27-AP27-AQ27) |
|
AO27 |
=IF(A27=0,"",COUNTIF(B27:AE27,">139")-AP27-AQ27) |
|
AP27 |
=IF(A27=0,"",COUNTIF(B27:AE27,">169")-AQ27) |
|
AQ27 |
=IF(A27=0,"",COUNTIF(B27:AE27,">179")) |
|
AR27 |
=IF(A27=0,"",AN27+AO27+AP27+AQ27) |
|
AK28 |
=IF(A28=0,"",SUM(COUNT(B28:AD28)*3)+AF28) |
|
AL28 |
=IF(A28=0,"",SUM(B28:AE28)) |
|
AM28 |
=IF(A28=0,"",AL28/AK28) |
|
AN28 |
=IF(A28=0,"",COUNTIF(B28:AE28,">99")-AO28-AP28-AQ28) |
|
AO28 |
=IF(A28=0,"",COUNTIF(B28:AE28,">139")-AP28-AQ28) |
|
AP28 |
=IF(A28=0,"",COUNTIF(B28:AE28,">169")-AQ28) |
|
AQ28 |
=IF(A28=0,"",COUNTIF(B28:AE28,">179")) |
|
AR28 |
=IF(A28=0,"",AN28+AO28+AP28+AQ28) |
|
AK29 |
=IF(A29=0,"",SUM(COUNT(B29:AD29)*3)+AF29) |
|
AL29 |
=IF(A29=0,"",SUM(B29:AE29)) |
|
AM29 |
=IF(A29=0,"",AL29/AK29) |
|
AN29 |
=IF(A29=0,"",COUNTIF(B29:AE29,">99")-AO29-AP29-AQ29) |
|
AO29 |
=IF(A29=0,"",COUNTIF(B29:AE29,">139")-AP29-AQ29) |
|
AP29 |
=IF(A29=0,"",COUNTIF(B29:AE29,">169")-AQ29) |
|
AQ29 |
=IF(A29=0,"",COUNTIF(B29:AE29,">179")) |
|
AR29 |
=IF(A29=0,"",AN29+AO29+AP29+AQ29) |
|
AK30 |
=IF(A30=0,"",SUM(COUNT(B30:AD30)*3)+AF30) |
|
AL30 |
=IF(A30=0,"",SUM(B30:AE30)) |
|
AM30 |
=IF(A30=0,"",AL30/AK30) |
|
AN30 |
=IF(A30=0,"",COUNTIF(B30:AE30,">99")-AO30-AP30-AQ30) |
|
AO30 |
=IF(A30=0,"",COUNTIF(B30:AE30,">139")-AP30-AQ30) |
|
AP30 |
=IF(A30=0,"",COUNTIF(B30:AE30,">169")-AQ30) |
|
AQ30 |
=IF(A30=0,"",COUNTIF(B30:AE30,">179")) |
|
AR30 |
=IF(A30=0,"",AN30+AO30+AP30+AQ30) |
|
AK31 |
=IF(A31=0,"",SUM(COUNT(B31:AD31)*3)+AF31) |
|
AL31 |
=IF(A31=0,"",SUM(B31:AE31)) |
|
AM31 |
=IF(A31=0,"",AL31/AK31) |
|
AN31 |
=IF(A31=0,"",COUNTIF(B31:AE31,">99")-AO31-AP31-AQ31) |
|
AO31 |
=IF(A31=0,"",COUNTIF(B31:AE31,">139")-AP31-AQ31) |
|
AP31 |
=IF(A31=0,"",COUNTIF(B31:AE31,">169")-AQ31) |
|
AQ31 |
=IF(A31=0,"",COUNTIF(B31:AE31,">179")) |
|
AR31 |
=IF(A31=0,"",AN31+AO31+AP31+AQ31) |
|
AK32 |
=IF(A32=0,"",SUM(COUNT(B32:AD32)*3)+AF32) |
|
AL32 |
=IF(A32=0,"",SUM(B32:AE32)) |
|
AM32 |
=IF(A32=0,"",AL32/AK32) |
|
AN32 |
=IF(A32=0,"",COUNTIF(B32:AE32,">99")-AO32-AP32-AQ32) |
|
AO32 |
=IF(A32=0,"",COUNTIF(B32:AE32,">139")-AP32-AQ32) |
|
AP32 |
=IF(A32=0,"",COUNTIF(B32:AE32,">169")-AQ32) |
|
AQ32 |
=IF(A32=0,"",COUNTIF(B32:AE32,">179")) |
|
AR32 |
=IF(A32=0,"",AN32+AO32+AP32+AQ32) |
|
AK33 |
=IF(A33=0,"",SUM(COUNT(B33:AD33)*3)+AF33) |
|
AL33 |
=IF(A33=0,"",SUM(B33:AE33)) |
|
AM33 |
=IF(A33=0,"",AL33/AK33) |
|
AN33 |
=IF(A33=0,"",COUNTIF(B33:AE33,">99")-AO33-AP33-AQ33) |
|
AO33 |
=IF(A33=0,"",COUNTIF(B33:AE33,">139")-AP33-AQ33) |
|
AP33 |
=IF(A33=0,"",COUNTIF(B33:AE33,">169")-AQ33) |
|
AQ33 |
=IF(A33=0,"",COUNTIF(B33:AE33,">179")) |
|
AR33 |
=IF(A33=0,"",AN33+AO33+AP33+AQ33) |
|
AK34 |
=IF(A34=0,"",SUM(COUNT(B34:AD34)*3)+AF34) |
|
AL34 |
=IF(A34=0,"",SUM(B34:AE34)) |
|
AM34 |
=IF(A34=0,"",AL34/AK34) |
|
AN34 |
=IF(A34=0,"",COUNTIF(B34:AE34,">99")-AO34-AP34-AQ34) |
|
AO34 |
=IF(A34=0,"",COUNTIF(B34:AE34,">139")-AP34-AQ34) |
|
AP34 |
=IF(A34=0,"",COUNTIF(B34:AE34,">169")-AQ34) |
|
AQ34 |
=IF(A34=0,"",COUNTIF(B34:AE34,">179")) |
|
AR34 |
=IF(A34=0,"",AN34+AO34+AP34+AQ34) |
|
AK35 |
=IF(A35=0,"",SUM(COUNT(B35:AD35)*3)+AF35) |
|
AL35 |
=IF(A35=0,"",SUM(B35:AE35)) |
|
AM35 |
=IF(A35=0,"",AL35/AK35) |
|
AN35 |
=IF(A35=0,"",COUNTIF(B35:AE35,">99")-AO35-AP35-AQ35) |
|
AO35 |
=IF(A35=0,"",COUNTIF(B35:AE35,">139")-AP35-AQ35) |
|
AP35 |
=IF(A35=0,"",COUNTIF(B35:AE35,">169")-AQ35) |
|
AQ35 |
=IF(A35=0,"",COUNTIF(B35:AE35,">179")) |
|
AR35 |
=IF(A35=0,"",AN35+AO35+AP35+AQ35) |
|
AK36 |
=IF(A36=0,"",SUM(COUNT(B36:AD36)*3)+AF36) |
|
AL36 |
=IF(A36=0,"",SUM(B36:AE36)) |
|
AM36 |
=IF(A36=0,"",AL36/AK36) |
|
AN36 |
=IF(A36=0,"",COUNTIF(B36:AE36,">99")-AO36-AP36-AQ36) |
|
AO36 |
=IF(A36=0,"",COUNTIF(B36:AE36,">139")-AP36-AQ36) |
|
AP36 |
=IF(A36=0,"",COUNTIF(B36:AE36,">169")-AQ36) |
|
AQ36 |
=IF(A36=0,"",COUNTIF(B36:AE36,">179")) |
|
AR36 |
=IF(A36=0,"",AN36+AO36+AP36+AQ36) |
|
AK37 |
=IF(A37=0,"",SUM(COUNT(B37:AD37)*3)+AF37) |
|
AL37 |
=IF(A37=0,"",SUM(B37:AE37)) |
|
AM37 |
=IF(A37=0,"",AL37/AK37) |
|
AN37 |
=IF(A37=0,"",COUNTIF(B37:AE37,">99")-AO37-AP37-AQ37) |
|
AO37 |
=IF(A37=0,"",COUNTIF(B37:AE37,">139")-AP37-AQ37) |
|
AP37 |
=IF(A37=0,"",COUNTIF(B37:AE37,">169")-AQ37) |
|
AQ37 |
=IF(A37=0,"",COUNTIF(B37:AE37,">179")) |
|
AR37 |
=IF(A37=0,"",AN37+AO37+AP37+AQ37) |
|
AK38 |
=IF(A38=0,"",SUM(COUNT(B38:AD38)*3)+AF38) |
|
AL38 |
=IF(A38=0,"",SUM(B38:AE38)) |
|
AM38 |
=IF(A38=0,"",AL38/AK38) |
|
AN38 |
=IF(A38=0,"",COUNTIF(B38:AE38,">99")-AO38-AP38-AQ38) |
|
AO38 |
=IF(A38=0,"",COUNTIF(B38:AE38,">139")-AP38-AQ38) |
|
AP38 |
=IF(A38=0,"",COUNTIF(B38:AE38,">169")-AQ38) |
|
AQ38 |
=IF(A38=0,"",COUNTIF(B38:AE38,">179")) |
|
AR38 |
=IF(A38=0,"",AN38+AO38+AP38+AQ38) |
|
AK39 |
=IF(A39=0,"",SUM(COUNT(B39:AD39)*3)+AF39) |
|
AL39 |
=IF(A39=0,"",SUM(B39:AE39)) |
|
AM39 |
=IF(A39=0,"",AL39/AK39) |
|
AN39 |
=IF(A39=0,"",COUNTIF(B39:AE39,">99")-AO39-AP39-AQ39) |
|
AO39 |
=IF(A39=0,"",COUNTIF(B39:AE39,">139")-AP39-AQ39) |
|
AP39 |
=IF(A39=0,"",COUNTIF(B39:AE39,">169")-AQ39) |
|
AQ39 |
=IF(A39=0,"",COUNTIF(B39:AE39,">179")) |
|
AR39 |
=IF(A39=0,"",AN39+AO39+AP39+AQ39) |
|
AK40 |
=IF(A40=0,"",SUM(COUNT(B40:AD40)*3)+AF40) |
|
AL40 |
=IF(A40=0,"",SUM(B40:AE40)) |
|
AM40 |
=IF(A40=0,"",AL40/AK40) |
|
AN40 |
=IF(A40=0,"",COUNTIF(B40:AE40,">99")-AO40-AP40-AQ40) |
|
AO40 |
=IF(A40=0,"",COUNTIF(B40:AE40,">139")-AP40-AQ40) |
|
AP40 |
=IF(A40=0,"",COUNTIF(B40:AE40,">169")-AQ40) |
|
AQ40 |
=IF(A40=0,"",COUNTIF(B40:AE40,">179")) |
|
AR40 |
=IF(A40=0,"",AN40+AO40+AP40+AQ40) |
|
AK41 |
=IF(A41=0,"",SUM(COUNT(B41:AD41)*3)+AF41) |
|
AL41 |
=IF(A41=0,"",SUM(B41:AE41)) |
|
AM41 |
=IF(A41=0,"",AL41/AK41) |
|
AN41 |
=IF(A41=0,"",COUNTIF(B41:AE41,">99")-AO41-AP41-AQ41) |
|
AO41 |
=IF(A41=0,"",COUNTIF(B41:AE41,">139")-AP41-AQ41) |
|
AP41 |
=IF(A41=0,"",COUNTIF(B41:AE41,">169")-AQ41) |
|
AQ41 |
=IF(A41=0,"",COUNTIF(B41:AE41,">179")) |
|
AR41 |
=IF(A41=0,"",AN41+AO41+AP41+AQ41) |
|
AK42 |
=IF(A42=0,"",SUM(COUNT(B42:AD42)*3)+AF42) |
|
AL42 |
=IF(A42=0,"",SUM(B42:AE42)) |
|
AM42 |
=IF(A42=0,"",AL42/AK42) |
|
AN42 |
=IF(A42=0,"",COUNTIF(B42:AE42,">99")-AO42-AP42-AQ42) |
|
AO42 |
=IF(A42=0,"",COUNTIF(B42:AE42,">139")-AP42-AQ42) |
|
AP42 |
=IF(A42=0,"",COUNTIF(B42:AE42,">169")-AQ42) |
|
AQ42 |
=IF(A42=0,"",COUNTIF(B42:AE42,">179")) |
|
AR42 |
=IF(A42=0,"",AN42+AO42+AP42+AQ42) |
|
AK43 |
=IF(A43=0,"",SUM(COUNT(B43:AD43)*3)+AF43) |
|
AL43 |
=IF(A43=0,"",SUM(B43:AE43)) |
|
AM43 |
=IF(A43=0,"",AL43/AK43) |
|
AN43 |
=IF(A43=0,"",COUNTIF(B43:AE43,">99")-AO43-AP43-AQ43) |
|
AO43 |
=IF(A43=0,"",COUNTIF(B43:AE43,">139")-AP43-AQ43) |
|
AP43 |
=IF(A43=0,"",COUNTIF(B43:AE43,">169")-AQ43) |
|
AQ43 |
=IF(A43=0,"",COUNTIF(B43:AE43,">179")) |
|
AR43 |
=IF(A43=0,"",AN43+AO43+AP43+AQ43) |
|
AK44 |
=IF(A44=0,"",SUM(COUNT(B44:AD44)*3)+AF44) |
|
AL44 |
=IF(A44=0,"",SUM(B44:AE44)) |
|
AM44 |
=IF(A44=0,"",AL44/AK44) |
|
AN44 |
=IF(A44=0,"",COUNTIF(B44:AE44,">99")-AO44-AP44-AQ44) |
|
AO44 |
=IF(A44=0,"",COUNTIF(B44:AE44,">139")-AP44-AQ44) |
|
AP44 |
=IF(A44=0,"",COUNTIF(B44:AE44,">169")-AQ44) |
|
AQ44 |
=IF(A44=0,"",COUNTIF(B44:AE44,">179")) |
|
AR44 |
=IF(A44=0,"",AN44+AO44+AP44+AQ44) |
|
AK45 |
=IF(A45=0,"",SUM(COUNT(B45:AD45)*3)+AF45) |
|
AL45 |
=IF(A45=0,"",SUM(B45:AE45)) |
|
AM45 |
=IF(A45=0,"",AL45/AK45) |
|
AN45 |
=IF(A45=0,"",COUNTIF(B45:AE45,">99")-AO45-AP45-AQ45) |
|
AO45 |
=IF(A45=0,"",COUNTIF(B45:AE45,">139")-AP45-AQ45) |
|
AP45 |
=IF(A45=0,"",COUNTIF(B45:AE45,">169")-AQ45) |
|
AQ45 |
=IF(A45=0,"",COUNTIF(B45:AE45,">179")) |
|
AR45 |
=IF(A45=0,"",AN45+AO45+AP45+AQ45) |
|
AK46 |
=IF(A46=0,"",SUM(COUNT(B46:AD46)*3)+AF46) |
|
AL46 |
=IF(A46=0,"",SUM(B46:AE46)) |
|
AM46 |
=IF(A46=0,"",AL46/AK46) |
|
AN46 |
=IF(A46=0,"",COUNTIF(B46:AE46,">99")-AO46-AP46-AQ46) |
|
AO46 |
=IF(A46=0,"",COUNTIF(B46:AE46,">139")-AP46-AQ46) |
|
AP46 |
=IF(A46=0,"",COUNTIF(B46:AE46,">169")-AQ46) |
|
AQ46 |
=IF(A46=0,"",COUNTIF(B46:AE46,">179")) |
|
AR46 |
=IF(A46=0,"",AN46+AO46+AP46+AQ46) |
|
AK47 |
=IF(A47=0,"",SUM(COUNT(B47:AD47)*3)+AF47) |
|
AL47 |
=IF(A47=0,"",SUM(B47:AE47)) |
|
AM47 |
=IF(A47=0,"",AL47/AK47) |
|
AN47 |
=IF(A47=0,"",COUNTIF(B47:AE47,">99")-AO47-AP47-AQ47) |
|
AO47 |
=IF(A47=0,"",COUNTIF(B47:AE47,">139")-AP47-AQ47) |
|
AP47 |
=IF(A47=0,"",COUNTIF(B47:AE47,">169")-AQ47) |
|
AQ47 |
=IF(A47=0,"",COUNTIF(B47:AE47,">179")) |
|
AR47 |
=IF(A47=0,"",AN47+AO47+AP47+AQ47) |
|
AK48 |
=IF(A48=0,"",SUM(COUNT(B48:AD48)*3)+AF48) |
|
AL48 |
=IF(A48=0,"",SUM(B48:AE48)) |
|
AM48 |
=IF(A48=0,"",AL48/AK48) |
|
AN48 |
=IF(A48=0,"",COUNTIF(B48:AE48,">99")-AO48-AP48-AQ48) |
|
AO48 |
=IF(A48=0,"",COUNTIF(B48:AE48,">139")-AP48-AQ48) |
|
AP48 |
=IF(A48=0,"",COUNTIF(B48:AE48,">169")-AQ48) |
|
AQ48 |
=IF(A48=0,"",COUNTIF(B48:AE48,">179")) |
|
AR48 |
=IF(A48=0,"",AN48+AO48+AP48+AQ48) |
|
AK49 |
=IF(A49=0,"",SUM(COUNT(B49:AD49)*3)+AF49) |
|
AL49 |
=IF(A49=0,"",SUM(B49:AE49)) |
|
AM49 |
=IF(A49=0,"",AL49/AK49) |
|
AN49 |
=IF(A49=0,"",COUNTIF(B49:AE49,">99")-AO49-AP49-AQ49) |
|
AO49 |
=IF(A49=0,"",COUNTIF(B49:AE49,">139")-AP49-AQ49) |
|
AP49 |
=IF(A49=0,"",COUNTIF(B49:AE49,">169")-AQ49) |
|
AQ49 |
=IF(A49=0,"",COUNTIF(B49:AE49,">179")) |
|
AR49 |
=IF(A49=0,"",AN49+AO49+AP49+AQ49) |
|
AK50 |
=IF(A50=0,"",SUM(COUNT(B50:AD50)*3)+AF50) |
|
AL50 |
=IF(A50=0,"",SUM(B50:AE50)) |
|
AM50 |
=IF(A50=0,"",AL50/AK50) |
|
AN50 |
=IF(A50=0,"",COUNTIF(B50:AE50,">99")-AO50-AP50-AQ50) |
|
AO50 |
=IF(A50=0,"",COUNTIF(B50:AE50,">139")-AP50-AQ50) |
|
AP50 |
=IF(A50=0,"",COUNTIF(B50:AE50,">169")-AQ50) |
|
AQ50 |
=IF(A50=0,"",COUNTIF(B50:AE50,">179")) |
|
AR50 |
=IF(A50=0,"",AN50+AO50+AP50+AQ50) |
|
AK51 |
=IF(A51=0,"",SUM(COUNT(B51:AD51)*3)+AF51) |
|
AL51 |
=IF(A51=0,"",SUM(B51:AE51)) |
|
AM51 |
=IF(A51=0,"",AL51/AK51) |
|
AN51 |
=IF(A51=0,"",COUNTIF(B51:AE51,">99")-AO51-AP51-AQ51) |
|
AO51 |
=IF(A51=0,"",COUNTIF(B51:AE51,">139")-AP51-AQ51) |
|
AP51 |
=IF(A51=0,"",COUNTIF(B51:AE51,">169")-AQ51) |
|
AQ51 |
=IF(A51=0,"",COUNTIF(B51:AE51,">179")) |
|
AR51 |
=IF(A51=0,"",AN51+AO51+AP51+AQ51) |
|
AK52 |
=IF(A52=0,"",SUM(COUNT(B52:AD52)*3)+AF52) |
|
AL52 |
=IF(A52=0,"",SUM(B52:AE52)) |
|
AM52 |
=IF(A52=0,"",AL52/AK52) |
|
AN52 |
=IF(A52=0,"",COUNTIF(B52:AE52,">99")-AO52-AP52-AQ52) |
|
AO52 |
=IF(A52=0,"",COUNTIF(B52:AE52,">139")-AP52-AQ52) |
|
AP52 |
=IF(A52=0,"",COUNTIF(B52:AE52,">169")-AQ52) |
|
AQ52 |
=IF(A52=0,"",COUNTIF(B52:AE52,">179")) |
|
AR52 |
=IF(A52=0,"",AN52+AO52+AP52+AQ52) |
|
AK53 |
=IF(A53=0,"",SUM(COUNT(B53:AD53)*3)+AF53) |
|
AL53 |
=IF(A53=0,"",SUM(B53:AE53)) |
|
AM53 |
=IF(A53=0,"",AL53/AK53) |
|
AN53 |
=IF(A53=0,"",COUNTIF(B53:AE53,">99")-AO53-AP53-AQ53) |
|
AO53 |
=IF(A53=0,"",COUNTIF(B53:AE53,">139")-AP53-AQ53) |
|
AP53 |
=IF(A53=0,"",COUNTIF(B53:AE53,">169")-AQ53) |
|
AQ53 |
=IF(A53=0,"",COUNTIF(B53:AE53,">179")) |
|
AR53 |
=IF(A53=0,"",AN53+AO53+AP53+AQ53) |
|
AK54 |
=IF(A54=0,"",SUM(COUNT(B54:AD54)*3)+AF54) |
|
AL54 |
=IF(A54=0,"",SUM(B54:AE54)) |
|
AM54 |
=IF(A54=0,"",AL54/AK54) |
|
AN54 |
=IF(A54=0,"",COUNTIF(B54:AE54,">99")-AO54-AP54-AQ54) |
|
AO54 |
=IF(A54=0,"",COUNTIF(B54:AE54,">139")-AP54-AQ54) |
|
AP54 |
=IF(A54=0,"",COUNTIF(B54:AE54,">169")-AQ54) |
|
AQ54 |
=IF(A54=0,"",COUNTIF(B54:AE54,">179")) |
|
AR54 |
=IF(A54=0,"",AN54+AO54+AP54+AQ54) |
|
AK55 |
=IF(A55=0,"",SUM(COUNT(B55:AD55)*3)+AF55) |
|
AL55 |
=IF(A55=0,"",SUM(B55:AE55)) |
|
AM55 |
=IF(A55=0,"",AL55/AK55) |
|
AN55 |
=IF(A55=0,"",COUNTIF(B55:AE55,">99")-AO55-AP55-AQ55) |
|
AO55 |
=IF(A55=0,"",COUNTIF(B55:AE55,">139")-AP55-AQ55) |
|
AP55 |
=IF(A55=0,"",COUNTIF(B55:AE55,">169")-AQ55) |
|
AQ55 |
=IF(A55=0,"",COUNTIF(B55:AE55,">179")) |
|
AR55 |
=IF(A55=0,"",AN55+AO55+AP55+AQ55) |
|
AK56 |
=IF(A56=0,"",SUM(COUNT(B56:AD56)*3)+AF56) |
|
AL56 |
=IF(A56=0,"",SUM(B56:AE56)) |
|
AM56 |
=IF(A56=0,"",AL56/AK56) |
|
AN56 |
=IF(A56=0,"",COUNTIF(B56:AE56,">99")-AO56-AP56-AQ56) |
|
AO56 |
=IF(A56=0,"",COUNTIF(B56:AE56,">139")-AP56-AQ56) |
|
AP56 |
=IF(A56=0,"",COUNTIF(B56:AE56,">169")-AQ56) |
|
AQ56 |
=IF(A56=0,"",COUNTIF(B56:AE56,">179")) |
|
AR56 |
=IF(A56=0,"",AN56+AO56+AP56+AQ56) |
|
AK57 |
=IF(A57=0,"",SUM(COUNT(B57:AD57)*3)+AF57) |
|
AL57 |
=IF(A57=0,"",SUM(B57:AE57)) |
|
AM57 |
=IF(A57=0,"",AL57/AK57) |
|
AN57 |
=IF(A57=0,"",COUNTIF(B57:AE57,">99")-AO57-AP57-AQ57) |
|
AO57 |
=IF(A57=0,"",COUNTIF(B57:AE57,">139")-AP57-AQ57) |
|
AP57 |
=IF(A57=0,"",COUNTIF(B57:AE57,">169")-AQ57) |
|
AQ57 |
=IF(A57=0,"",COUNTIF(B57:AE57,">179")) |
|
AR57 |
=IF(A57=0,"",AN57+AO57+AP57+AQ57) |
|
AK58 |
=IF(A58=0,"",SUM(COUNT(B58:AD58)*3)+AF58) |
|
AL58 |
=IF(A58=0,"",SUM(B58:AE58)) |
|
AM58 |
=IF(A58=0,"",AL58/AK58) |
|
AN58 |
=IF(A58=0,"",COUNTIF(B58:AE58,">99")-AO58-AP58-AQ58) |
|
AO58 |
=IF(A58=0,"",COUNTIF(B58:AE58,">139")-AP58-AQ58) |
|
AP58 |
=IF(A58=0,"",COUNTIF(B58:AE58,">169")-AQ58) |
|
AQ58 |
=IF(A58=0,"",COUNTIF(B58:AE58,">179")) |
|
AR58 |
=IF(A58=0,"",AN58+AO58+AP58+AQ58) |
|
AK61 |
=IF(A61=0,"",SUM(COUNT(B61:AD61)*3)+AF61) |
|
AL61 |
=IF(A61=0,"",SUM(B61:AE61)) |
|
AM61 |
=IF(A61=0,"",AL61/AK61) |
|
AN61 |
=IF(A61=0,"",COUNTIF(B61:AE61,">99")-AO61-AP61-AQ61) |
|
AO61 |
=IF(A61=0,"",COUNTIF(B61:AE61,">139")-AP61-AQ61) |
|
AP61 |
=IF(A61=0,"",COUNTIF(B61:AE61,">169")-AQ61) |
|
AQ61 |
=IF(A61=0,"",COUNTIF(B61:AE61,">179")) |
|
AR61 |
=IF(A61=0,"",AN61+AO61+AP61+AQ61) |
|
AK62 |
=IF(A62=0,"",SUM(COUNT(B62:AD62)*3)+AF62) |
|
AL62 |
=IF(A62=0,"",SUM(B62:AE62)) |
|
AM62 |
=IF(A62=0,"",AL62/AK62) |
|
AN62 |
=IF(A62=0,"",COUNTIF(B62:AE62,">99")-AO62-AP62-AQ62) |
|
AO62 |
=IF(A62=0,"",COUNTIF(B62:AE62,">139")-AP62-AQ62) |
|
AP62 |
=IF(A62=0,"",COUNTIF(B62:AE62,">169")-AQ62) |
|
AQ62 |
=IF(A62=0,"",COUNTIF(B62:AE62,">179")) |
|
AR62 |
=IF(A62=0,"",AN62+AO62+AP62+AQ62) |
|
|
|
|