PDA

View Full Version : VOID as KO? Not quiet right.



duffysz
28th October 2013, 08:49 PM
Hi, I absolute love the spreadsheet but I noticed few mistakes. Counting VOID among loosing bets is wrong. When you have a look to a personal stats according to a tipster. It counts void picks as loosing, is there any way how to change it pls? By creating PUSH tab fe?

admin
29th October 2013, 09:01 AM
Hi duffysz.

That amendment has been slated for the next update, however the Return column (K) is the one you should be paying attention to, not the Win % (column M), which is just a simple ratio of wins/bets.

In the meantime, you can make a quick change yourself. In the Performance Summary change cell M9 to something along the lines of:

=IF(H9<>"",
IF(AND(FILT_D=1,FILT_B=1,FILT_C=1),COUNTIFS(SPORT, H9,WIN,"<>P",WIN,"<>R",WIN,"<>PU"),
IF(AND(FILT_D>1,FILT_B=1,FILT_C=1),COUNTIFS(SPORT,H9,WIN,"<>P",WIN,"<>R",WIN,"<>PU",BET_DATE,">="&DATE(OFFSET(AQ$11,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AQ$11,FILT_YE,0),FILT_ME,FILT_DE)),
IF(AND(FILT_D=1,FILT_B>1,FILT_C=1),COUNTIFS(SPORT,H9,WIN,"<>P",WIN,"<>R",WIN,"<>PU",BET_TYPE,OFFSET(AO$10,FILT_B,0)),
IF(AND(FILT_D=1,FILT_B=1,FILT_C>1),COUNTIFS(SPORT,H9,WIN,"<>P",WIN,"<>R",WIN,"<>PU",CAPPER,OFFSET(AP$10,FILT_C,0)),
IF(AND(FILT_D>1,FILT_B>1,FILT_C=1),COUNTIFS(SPORT,H9,WIN,"<>P",WIN,"<>R",WIN,"<>PU",BET_DATE,">="&DATE(OFFSET(AQ$11,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AQ$11,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AO$10,FILT_B,0)),
IF(AND(FILT_D>1,FILT_B=1,FILT_C>1),COUNTIFS(SPORT,H9,WIN,"<>P",WIN,"<>R",WIN,"<>PU",BET_DATE,">="&DATE(OFFSET(AQ$11,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AQ$11,FILT_YE,0),FILT_ME,FILT_DE),CAPP ER,OFFSET(AP$10,FILT_C,0)),
IF(AND(FILT_D=1,FILT_B>1,FILT_C>1),COUNTIFS(SPORT,H9,WIN,"<>P",WIN,"<>R",WIN,"<>PU",BET_TYPE,OFFSET(AO$10,FILT_B,0),CAPPER,OFFSET(AP$ 10,FILT_C,0)),
IF(AND(FILT_D>1,FILT_B>1,FILT_C>1),COUNTIFS(SPORT,H9,WIN,"<>P",WIN,"<>R",WIN,"<>PU",BET_DATE,">="&DATE(OFFSET(AQ$11,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AQ$11,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AO$10,FILT_B,0),CAPPER,OFFSET(AP$10,FI LT_C,0)),
"")))))))
),"")

Note that this still won't account for Asian Handicap results for half win and half lose. It is only intended to be a simple tally.