** JACKPOT SYNDICATE ** AUTOMATIC REMOVAL LEADER BOARD GENERATION ** PLAY AREA **

StayOrGo

Hi guys, this is a test REMOVALS SCORING sheet for you to play with. (Only enter "test scores" (yellow tabs) not actual horses)

https://docs.google.com/spreadsheets/d/1tP1A9_BDHYodkIU5Tg7f6ri5CjATOVAJGdUeGoBKSsg/edit#gid=0

It dynamically updates the REMOVERS LEADER BOARD as soon as you score your card.

Try it out, only update the "YELLOW" cells. Carry over scores are current as of 03/11/17.

I have a backup so don't worry just give it a go.

HANSEN and MAXALLY, I have columns for you in case you decide to do the removers next year.

Please note, the position doesn't update automatically, I have to do that manually. I will try and do something similar with NAPS at a later date.

Cheers,

G

P.S. Only rule for "playing" is update yellow cells only.

P.P.S. Note for Roger, I have made major changes to your master template to incorporate this. FYI, I took the word "TEST" out as it is now the formal template and is called, "ROGERS_GOOGLE_REMOVALS_TEMPLATE"

StayOrGo

Any feedback re the above appreciated.

Cheers,

G

Snuffer

Read only for me.

StayOrGo

Snuffer said:

Read only for me.

Hmm, that's strange, you have update access.

Are you logged into google with your normal email address. Also maybe check "junk folder" again.

Cheers,

G

wynne1938

Not sure what to do? There is no selections from me ,so no scores.

StayOrGo

wynne1938 said:

Not sure what to do? There is no selections from me ,so no scores.

It is just a test of the scoring system only.

So put in any scores you like in your column (imagine you done say 20 selections got 45 points and 2 winners and see it auto update your overall score at the bottom, just update yellow cells.

Cheers,

G

BTW, any NAP today?

MISTY4ME

StayOrGo said:

Any feedback re the above appreciated.

Cheers,

G

Works fine for me G. I can write scores and make comments too. I deleted what i had entered coz I didnt know for sure if you wanted us to put anything in for you to look at, and I didnt want to mess anything up

StayOrGo

MISTY4ME said:

StayOrGo said:

Any feedback re the above appreciated.

Cheers,

G

Works fine for me G. I can write scores and make comments too. I deleted what i had entered coz I didnt know for sure if you wanted us to put anything in for you to look at, and I didnt want to mess anything up

Nice one Mist. It's only a practice sheet, so you can leave your fictitious scores there if you want. Might give others an idea of what to do.

On that note I will put in my own fictitious scores too.

Cheers,

G

Snuffer

Working for me now

MISTY4ME

looks like it works fine G.....well done.

GOOD LUCK tonight

StayOrGo

MISTY4ME said:

looks like it works fine G.....well done.

GOOD LUCK tonight

Hi Jez, in the points scoring column you (or someone elses) put "pts" this will stop it working as it has to be numeric. (Cell S10 is the cell in question)

You will see that your score hasn't transferred through properly to main leader board. Remove the "pts" and it should be OK.

Take a look and you'll see what I mean. Remove the pts and it will calculate OK.

Cheers,

G

MISTY4ME

StayOrGo said:

MISTY4ME said:

looks like it works fine G.....well done.

GOOD LUCK tonight

Hi Jez, in the points scoring column you (or someone elses) put "pts" this will stop it working as it has to be numeric. (Cell S10 is the cell in question)

You will see that your score hasn't transferred through properly to main leader board. Remove the "pts" and it should be OK.

Take a look and you'll see what I mean. Remove the pts and it will calculate OK.

Cheers,

G

OK will do G......... yes sorted it. An error message did come up but I thought it was for a different cell.

wynne1938

Tested,seems ok