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
    Jan 2015

    Performance Summary - Filter by specific dates


    When I try to filter by specific dates the only values I can see in the year drop-down boxes under 'Date start' and 'Date end' are numbers ranging from 114 to 132. I was expecting to see dates of the years i have inputted in the bet section, ie. 2013, 2014, 2015, 2016 etc... Instead, selecting these values gives me a #VALUE output.

    Below is a screenshot of what I mean. Here I was trying to get it to filter by dates from 21 Sep 2014 - 1 Jan 2015:

    Is this a bug or is there another way to get this working?
    Last edited by jolly; 1st January 2015 at 01:10 PM.

  2. #2
    Join Date
    Aug 2011
    Hi Jolly,

    That is strange. Have you deleted any rows from the Bets worksheet? Doing so would throw other aspects of the spreadsheet off. Also, make sure your betting data uses the correct format for the date column. Is the Performance Graph working properly?

    To the right of the farthest right Performance Summary table are some hidden cells, if you unhide these cells you may be able to debug what's wrong. Unlock the Performance Summary sheet by selecting Tools -> Protect Document and de-select Sheet. The password is sport. The hidden cells are between AM and AW. Highlight these two columns then right click and select Show. The All Years column is where the years data is sourced from in the drop down menu.

    Another option is to paste your betting data into a fresh copy of the spreadsheet to see if that fixes things.

    If you're still stuck let me know and I'll send you a PM with an email address that you can send the spreadsheet to.




Posting Permissions

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