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.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.