PDA

View Full Version : Forget a bet - how to enter it in correct date area



WWWW
20th October 2011, 03:05 PM
Suppose I enter a number of bets daily. Now I discover that I left out a bet made 2 weeks ago.


Is there any way to enter that bet, e.g., into Row 45, although that Row and the next 50 Rows have already had bets entered?

A friend tried to Cut and Paste and another method, but either way it messed up the stats calc and graphing tracking (Column AO and higher).

Is there a way that this can be done without messing up other tracking areas of the Betting Tracker?

admin
21st October 2011, 10:57 AM
Hi there,

If you entered the two week old bet later on in the sheet I think it will wreck the performance graph.

My suggestion is to:

Input your old bet into the first available row below the rest of your betting data
Unlock the Bets sheet by selecting Tools -> Protection -> Unprotect sheet. The password is sport
Highlight the betting sheet data (columns B-N if you're using the latest version), but do not include the header cells (rows 9 & 10)
Select Sort -> Sort by Column B
Press OK
Your bets should now be reordered, with your two weeks old bet placed in order of date

There are other ways around it, but I think the above option is the easiest.

Let me know if you have further questions.