E/W Euro version summary problem

[thehoveround]

For some unknown reason in the "Outcome Frequencies" E/W Place bets only show up when selecting "All Dates" in the Filtered data. If you choose a "Specific Date" the bet does not show up.

Thanks in advance and just to be cheeky, is there any way of adding the E/W option and the Multi-bet option to the sheet with staking plans

[admin]

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,F ILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OF FSET(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,F ILT_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,F ILT_M_C=1),COUNTIFS(WIN,"EP",SPORT,OFFSET(AC$36,FI LT_M_S,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",CAPPER,OFFSET(AE$36,F ILT_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",BET_DATE,">="&DATE(OF FSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_DATE,"< ="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),B ET_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,F ILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OF FSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_DATE,"< ="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),S PORT,OFFSET(AC$36,FILT_M_S,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",BET_DATE,">="&DATE(OF FSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_DATE,"< ="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),C APPER,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",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,F ILT_M_C=1),COUNTIFS(WIN,"EP",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,F ILT_M_C=1),COUNTIFS(WIN,"EP",SPORT,OFFSET(AC$36,FI LT_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",BET_DATE,">="&DATE(OF FSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_DATE,"< ="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),B ET_TYPE,OFFSET(AD$36,FILT_M_B,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,F ILT_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,F ILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OF FSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_DATE,"< ="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),S PORT,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,F ILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OF FSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_DATE,"< ="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),B ET_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,F ILT_M_C=1),COUNTIFS(WIN,"EP",BET_DATE,">="&DATE(OF FSET(AG$37,FILT_YS,0),FILT_MS,FILT_DS),BET_DATE,"< ="&DATE(OFFSET(AG$37,FILT_YE,0),FILT_ME,FILT_DE),B ET_TYPE,OFFSET(AD$36,FILT_M_B,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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_M_C,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,F ILT_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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_M_C,0),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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_M_C,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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_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),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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_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),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,F ILT_M_C,0),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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_M_C,0),BET_TYPE,OFFSET(AD$36,FILT_M_B,0),CAPPE R,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,F ILT_M_C,0),SPORT,OFFSET(AC$36,FILT_M_S,0),CAPPER,O FFSET(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,F ILT_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,FILT_M_S,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,F ILT_M_C,0),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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_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),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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_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,F ILT_M_C>1),COUNTIFS(WIN,"EP",CUSTOM,OFFSET(AF$36,F ILT_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,FILT_M_S,0),CAPP ER,OFFSET(AE$36,FILT_M_T,0)),
""))))))))))))))))))))))))))))))))

[thehoveround]

That fixed it, said there was a typo in the formula however excel seems to of corrected that. Many thanks for all your hard work and looking forward to the next version of the staking plans sheet