PDA

View Full Version : E/W Euro version summary problem



thehoveround
24th September 2018, 11:44 PM
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
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)),
""))))))))))))))))))))))))))))))))

thehoveround
26th September 2018, 02:50 AM
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