PDA

View Full Version : Betting Tracker Advanced v2.21 (dollar version) - "Screen" cells?



WWWW
19th May 2017, 05:00 AM
Just downloaded Betting Tracker Advanced v2.21 (dollar version) (~3.8 MB) - 2 copies, and Standard version downloaded one time.

In each one, "Bets" page/ Rows 16-18 have something that looks like a window screen occupying almost all of the cells except Columns D/H/J/L/N.
I cannot delete it nor add info to those cells, and see nothing in the instructions about it.

What is that and why?

Thank you (It's a great spreadsheet, but never encountered this before in previous versions).

admin
19th May 2017, 11:22 PM
Hi WWWW,

Yes, it does look strange, but that isn't an error. If you enter M into the win column to denote a multi, the betting tracker covers up the irrelevant cells, only showing columns D, H, J, L and N. Once you remove the sample data this will go away.

The M for multi enables you to enter leg details for the multi which the spreadsheet will ignore. In the sample data row 15 is the actual multi bet. Rows 16-18 show the multi details for the punter's reference only.

Let me know if you have further questions.

WWWW
22nd May 2017, 04:14 AM
Thanks.

I had already deleted the sample data in "Settings" and "Deposits" and part of the "Bets" data, but not all of it and thought something was amiss.
That's a great solution for tracking a multi/parlay!

Two questions:

1) There is no designation specifically for betting both sides of a game for an arb/scalp/middle, is there?

2) Too late I noticed
"STEP 1: ... IMPORTANT: do not use the Ctrl+X keyboard combination to delete data because this can cause background calculations to go awry. To remove data highlight the cells and press the Delete button on your keyboard."

Instead of doing the above, I was highlighting and then right clicking "Clear contents".

I believe that should be ok as the one you warn against Cuts.
Is the way I did it an acceptable method to remove the sample data?

admin
22nd May 2017, 12:09 PM
Hi WWWW,

To answer your questions:

1) I'm afraid there isn't, just enter each bet separately. For my own sheet I have a Capper / Tipper type called 'Hedge' so I can track the overall performance of my hedge bets on existing wagers. You might want to enter arb/scalp/middle in a similar fashion. You could also use the custom field for this purpose if you aren't using it for anything else.

2) Selecting Clear Contents is perfect :)