Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the Australia Sports Betting Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Results 1 to 3 of 3
  1. #1

    E/W Euro version summary problem

    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

  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    898
    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)),
    ""))))))))))))))))))))))))))))))))

  3. #3
    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

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •