admin
25th September 2018, 06:41 PM
Hi thehoveround,
I've found the bug and have updated the download file. To fix it on your copy, unlock the performance summary sheet (password is sport) and replace the formula for cell F26 with the code below. Let me know if this doesn't fix the issue for you.
Thanks for your feedback. I will most likely include E/W and multi betting in the next version of the staking plans spreadsheet.
=IF(AND(FILT_D=1,FILT_M_B=1,FILT_M_S=1,FILT_M_T=1, FILT_M_C=1),COUNTIFS(WIN,"EP"),
IF(AND(FILT_D>1,FILT_M_B=1,FILT_M_S=1,FILT_M_T=1,FILT_M_C=1),COU NTIFS(WIN,"EP",BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE)),
IF(AND(FILT_D=1,FILT_M_B>1,FILT_M_S=1,FILT_M_T=1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_TYPE,OFFSET(AD$36,FILT_M_B,0)),
IF(AND(FILT_D=1,FILT_M_B=1,FILT_M_S>1,FILT_M_T=1,FILT_M_C=1),COUNTIFS(WIN,"EP",SPORT,OFFSET(AC$36,FILT_M_S,0)),
IF(AND(FILT_D=1,FILT_M_B=1,FILT_M_S=1,FILT_M_T>1,FILT_M_C=1),COUNTIFS(WIN,"EP",CAPPER,OFFSET(AE$36,FILT_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B>1,FILT_M_S=1,FILT_M_T=1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AD$36,FILT_M_B,0)),
IF(AND(FILT_D>1,FILT_M_B=1,FILT_M_S>1,FILT_M_T=1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),SPOR T,OFFSET(AC$36,FILT_M_S,0)),
IF(AND(FILT_D>1,FILT_M_B=1,FILT_M_S=1,FILT_M_T>1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),CAPP ER,OFFSET(AE$36,FILT_M_T,0)),
IF(AND(FILT_D=1,FILT_M_B>1,FILT_M_S>1,FILT_M_T=1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_TYPE,OFFSET(AD$36,FILT_M_B,0),SPORT,OFFSET(AC $36,FILT_M_S,0)),
IF(AND(FILT_D=1,FILT_M_B>1,FILT_M_S=1,FILT_M_T>1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_TYPE,OFFSET(AD$36,FILT_M_B,0),CAPPER,OFFSET(A E$36,FILT_M_T,0)),
IF(AND(FILT_D=1,FILT_M_B=1,FILT_M_S>1,FILT_M_T>1,FILT_M_C=1),COUNTIFS(WIN,"EP",SPORT,OFFSET(AC$36,FILT_M_S,0),CAPPER,OFFSET(AE$3 6,FILT_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B>1,FILT_M_S>1,FILT_M_T=1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AD$36,FILT_M_B,0),SPORT,OFFSET(AC$36,F ILT_M_S,0)),
IF(AND(FILT_D=1,FILT_M_B>1,FILT_M_S>1,FILT_M_T>1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_TYPE,OFFSET(AD$36,FILT_M_B,0),SPORT,OFFSET(AC $36,FILT_M_S,0),CAPPER,OFFSET(AE$36,FILT_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B=1,FILT_M_S>1,FILT_M_T>1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),SPOR T,OFFSET(AC$36,FILT_M_S,0),CAPPER,OFFSET(AE$36,FIL T_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B>1,FILT_M_S=1,FILT_M_T>1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AD$36,FILT_M_B,0),CAPPER,OFFSET(AE$36, FILT_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B>1,FILT_M_S>1,FILT_M_T>1,FILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AD$36,FILT_M_B,0),SPORT,OFFSET(AC$36,F ILT_M_S,0),CAPPER,OFFSET(AE$36,FILT_M_T,0)),
IF(AND(FILT_D=1,FILT_M_B=1,FILT_M_S=1,FILT_M_T=1,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0)),
IF(AND(FILT_D>1,FILT_M_B=1,FILT_M_S=1,FILT_M_T=1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE)),
IF(AND(FILT_D=1,FILT_M_B>1,FILT_M_S=1,FILT_M_T=1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_TYPE,OFFSET(A D$36,FILT_M_B,0)),
IF(AND(FILT_D=1,FILT_M_B=1,FILT_M_S>1,FILT_M_T=1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),SPORT,OFFSET(AC$3 6,FILT_M_S,0)),
IF(AND(FILT_D=1,FILT_M_B=1,FILT_M_S=1,FILT_M_T>1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),CAPPER,OFFSET(AE$ 36,FILT_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B>1,FILT_M_S=1,FILT_M_T=1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AD$36,FILT_M_B,0)),
IF(AND(FILT_D>1,FILT_M_B=1,FILT_M_S>1,FILT_M_T=1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),SPOR T,OFFSET(AC$36,FILT_M_S,0)),
IF(AND(FILT_D>1,FILT_M_B=1,FILT_M_S=1,FILT_M_T>1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),CAPP ER,OFFSET(AE$36,FILT_M_T,0)),
IF(AND(FILT_D=1,FILT_M_B>1,FILT_M_S>1,FILT_M_T=1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_TYPE,OFFSET(A D$36,FILT_M_B,0),SPORT,OFFSET(AC$36,FILT_M_S,0)),
IF(AND(FILT_D=1,FILT_M_B>1,FILT_M_S=1,FILT_M_T>1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_TYPE,OFFSET(A D$36,FILT_M_B,0),CAPPER,OFFSET(AE$36,FILT_M_T,0)),
IF(AND(FILT_D=1,FILT_M_B=1,FILT_M_S>1,FILT_M_T>1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),SPORT,OFFSET(AC$3 6,FILT_M_S,0),CAPPER,OFFSET(AE$36,FILT_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B>1,FILT_M_S>1,FILT_M_T=1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AD$36,FILT_M_B,0),SPORT,OFFSET(AC$36,F ILT_M_S,0)),
IF(AND(FILT_D=1,FILT_M_B>1,FILT_M_S>1,FILT_M_T>1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_TYPE,OFFSET(A D$36,FILT_M_B,0),SPORT,OFFSET(AC$36,FILT_M_S,0),CA PPER,OFFSET(AE$36,FILT_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B=1,FILT_M_S>1,FILT_M_T>1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),SPOR T,OFFSET(AC$36,FILT_M_S,0),CAPPER,OFFSET(AE$36,FIL T_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B>1,FILT_M_S=1,FILT_M_T>1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AD$36,FILT_M_B,0),CAPPER,OFFSET(AE$36, FILT_M_T,0)),
IF(AND(FILT_D>1,FILT_M_B>1,FILT_M_S>1,FILT_M_T>1,FILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,FILT_M_C,0),BET_DATE,">="&DATE(OFFSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_ DATE,"<="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),BET_ TYPE,OFFSET(AD$36,FILT_M_B,0),SPORT,OFFSET(AC$36,F ILT_M_S,0),CAPPER,OFFSET(AE$36,FILT_M_T,0)),
""))))))))))))))))))))))))))))))))
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.