Tweet
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?
-
-
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,">="&DA TE(OFFSET(AQ$11,FILT_YS,0),FILT_MS,FILT_DS),BET_DA TE,"<="&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,">="&DA TE(OFFSET(AQ$11,FILT_YS,0),FILT_MS,FILT_DS),BET_DA TE,"<="&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,">="&DA TE(OFFSET(AQ$11,FILT_YS,0),FILT_MS,FILT_DS),BET_DA TE,"<="&DATE(OFFSET(AQ$11,FILT_YE,0),FILT_ME,FILT_ DE),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_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,">="&DA TE(OFFSET(AQ$11,FILT_YS,0),FILT_MS,FILT_DS),BET_DA TE,"<="&DATE(OFFSET(AQ$11,FILT_YE,0),FILT_ME,FILT_ DE),BET_TYPE,OFFSET(AO$10,FILT_B,0),CAPPER,OFFSET( AP$10,FILT_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.
Comment