Large Ad

Collapse

New Rows added but not being calculated in Performance Summary

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • skyalpha
    New Member
    • Jun 2014
    • 7

    New Rows added but not being calculated in Performance Summary

    Hi,

    I've added new rows because we hit the 10,000 entries, but the new rows aren't being calculated in the Performance Summary. How do I fix this?

    Thanks
  • admin
    Moderator
    • Aug 2011
    • 1072

    #2
    Hi skyalpha, have you used the instructions in the Intro sheet?

    Scroll to the right until you can see the working cells. Make sure their formulas are populated by dragging down and copying over them using cells from a row that is working properly. Do the same for the cells with purple headers (At Risk, Potential Payout, etc.).

    Comment

    • skyalpha
      New Member
      • Jun 2014
      • 7

      #3
      Originally posted by admin View Post
      Hi skyalpha, have you used the instructions in the Intro sheet?

      Scroll to the right until you can see the working cells. Make sure their formulas are populated by dragging down and copying over them using cells from a row that is working properly. Do the same for the cells with purple headers (At Risk, Potential Payout, etc.).
      Hi,

      Yes I followed the instructions in the Intro Sheet.

      Which ones are the 'working cells'?

      Everything seems to be working and calculating correctly in the Bets Tab. All the Purple cells are calculating correctly. The cells to the far right (columns BH to BP) that are used for the Performance Graph are calculating correctly. The cells next to that 'grey' Working odds, potential payout, etc are all calculating correctly.

      BUT the Performance Summary Tab is not calculating anything from the newly inserted Sheet Rows.

      Comment

      • dizzyone
        Administrator
        • Jul 2012
        • 2

        #4
        Hi skyalpha,

        By working cells I'm referring to BH-BP.

        When you created the new cells did you insert them in-between existing rows? If you've added them below the lowest row the case may be that they are being ignored by the Performance Summary because they fall outside the region used for the Performance Summary calculations.

        In the top left hand side of the screen there is a dropdown menu in the Excel menu that shows the current cell that has been selected. Click on the dropdown menu and select "AGENCY" from the list. Excel will then highlight the range used to define AGENCY, which is the bookmakers column in the Bets worksheet. Scroll down to the very bottom. Does the range include your new rows?

        If it doesn't then then this would explain why your new cells are being ignored.

        If it does include them, feel free to send me a PM and I'll give you an email address to send your spreadsheet to.

        Let me know if you have further questions.

        Comment

        • skyalpha
          New Member
          • Jun 2014
          • 7

          #5
          That's brilliant... I got it working. I screwed up by not inserting the new rows between current ones properly. All fixed and another 10,000 rows added. Thank you SO MUCH )

          Comment

          • NickTaylor98
            New Member
            • Nov 2023
            • 1

            #6
            Hi,
            I have updated the ranges as outlined above, however now all I get on my Performance summary page is VALUE#### in all the boxes. Do I need to update something else for the performance summary page to acknowledge the new ranges? Or have I just done this wrong? I am using the google sheets version, if this makes a difference.
            Thanks in advance
            P.S. Love the spreadsheet, long time user!

            Comment

            • admin
              Moderator
              • Aug 2011
              • 1072

              #7
              Hi NickTaylor98,

              There shouldn't be anything else required to get the performance summary page to acknowledge the expanded range. I recommend you look at the cell ranges (Data -> Named Ranges) to make sure the cell ranges include the new cells. I also recommend you scroll to the right in the Bets worksheet until you find the columns BF-BK. Make sure the background calculations are working there.

              If you can't fix the issue, try creating a new copy of the sheet, expand the number of rows, and then paste your betting data from the first copy over.

              Comment

              Working...
              X