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 2 of 2
  1. #1
    New Member
    Join Date
    Sep 2019
    Posts
    1

    Average bet size in All bets is wrong

    The average bet size under the all bets, in the Performance summary sheet is incorrect. I believe it is wrong due to multis. I have listed each leg of a multi as 'M', and bars go across the bet line, so shouldnt be taken into account. Then i do a bet line where i said its a legged multi and list its bet size. I believe the spreedsheet is taking these 'M' leg lines as a bet of 0 and dividing by them when it shouldnt be? Any help?

  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi Jacoooooo, you are correct. This bug has been removed in the next version of the spreadsheet that is currently in development. This has been achieved by adding an additional WIN,"<>M" condition. The average bet size formula will resemble something like:
    =IF(COUNTIFS(LAY,"<>Y",WIN,"<>"&"",WIN,"<>P",WIN," <>M")>0,SUMIFS(AMOUNT,LAY,"<>Y",WIN,"<>"&"",WIN,"< >P",WIN,"<>M")/COUNTIFS(LAY,"<>Y",WIN,"<>"&"",WIN,"<>P",WIN,"<>M" ),"")

 

 

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
  •