Hi G I will check now, I dont know why but I always make mistakes with Roger's , if you havent already done it can you change the sheet for Sunday to 9 races. @StayOrGo
Serendipity in action, I'd just sent you an email re the 9 races on Sunday.
It will be the day 3 sheet, I removed your previous selections.
Thanks G thought you would have had it in hand. you will see I have posted the correct table now . Pity I stupidly deleted my round up first
No problem, it's easy to make a mistake or miss one when you are cross referencing back and forth.
I appreciate all the effort you put into it, as, I am sure, all the others do too.
I have updated the DAY 3 sheet, so that it records meeting totals, and overall totals, not just daily totals.
We'll see if it works OK, and if so I will update the other sheets.
Might make things a bit easier Terry?
It's only a few clicks to set up each day, so no problem for me to do.
I would recommend still posting them on the thread and in the hall of fame, as you have always done, as the sheets will be refreshed each meeting, as we do now.
The number of winners and losers will still need to be done manually I am afraid.
Hopefully these additions to the sheet will make things easier for you Terry, and also people will see "in running" how they stand for the meeting and overall as a whole.
There may be a few teething troubles with the formulas to start with, so I'd still double check manually for the first few.
Hope this helps.
Cheers,
G
P.S. @MAXALLY I have put 9 no shows against each of us, just so the totals tally with @vaigret's, as none of Sunday's have run yet. I will change to zero on the day and then you just do what you did before when there is a NR.
P.P.S. Give it a try Terry, and if you don't like it, we can go back to how it was before.
I see what you mean now the sheet will update the totals but winners and losers will just be on my tables . Am I right Thanks a lot mate
Yes mate.
Also, when I do the "permanent copy" I will sort the order from top to bottom, for the three tables (daily, meeting and overall), so it should be fairly straight forward for you.
I wouldn't "trust" the sheet straight away.
To start with I would do it exactly as you do now and then cross reference the sheet to see if everything matches.
When we are all "confident" that it works OK, then you should be able to rely on the sheet a bit more.
12.30: SILVER KNOTT 13.00: ABEL KANE 13.35: MALRESCIA 14.10: DAKOTA GOLD 14.45: TRUESHAN 15.20: DOUBLE OR BUBBLE 15.55: NEW LONDON 16.30: SYMBOLIZE 17.05: INCHICORE
12.30: Silver Knott 13.00: Juan Les Pins 13.35: Trillium 14.10: Count D'Orsay 14.45: Trueshan 15.20: Kinross 15.55: New London 16.30: Flor De La Luna 17.05: Wise Eagle
I see what you mean now the sheet will update the totals but winners and losers will just be on my tables . Am I right Thanks a lot mate
Yes mate.
Also, when I do the "permanent copy" I will sort the order from top to bottom, for the three tables (daily, meeting and overall), so it should be fairly straight forward for you.
I wouldn't "trust" the sheet straight away.
To start with I would do it exactly as you do now and then cross reference the sheet to see if everything matches.
When we are all "confident" that it works OK, then you should be able to rely on the sheet a bit more.
Any questions, give me a shout
thanks mate will continue as before until we see how it all works
Comments
STAYORGO== 338 runners 90 winners 248 losers- £(45.15)
RABDENIRO== 333 runners 84 winners 249 losers- £(54.48)
ZADOC ==== 338 runners 56 winners 282 losers-£(75.40)
MAXALLY === 338 runners 60 winners 278 losers- £(106.11)
SIDV79 ==== 326 runners 64 winners 262 losers- £(108.95)
VAIGRET==== 339 runners 48 winners 291 losers- £(168.34)
THEFALL ==== 194 Runners 32 Winners 162 Losers - £(47.43)
https://docs.google.com/spreadsheets/d/1acsNPOBqY2fgctWVJwDsNv98sVOCRtoBqq2Lf-eDJ98/edit#gid=0
@rabdeniro @MAXALLY @thefall @SidV79 @zadoc
I appreciate all the effort you put into it, as, I am sure, all the others do too.
I have updated the DAY 3 sheet, so that it records meeting totals, and overall totals, not just daily totals.
We'll see if it works OK, and if so I will update the other sheets.
Might make things a bit easier Terry?
It's only a few clicks to set up each day, so no problem for me to do.
I would recommend still posting them on the thread and in the hall of fame, as you have always done, as the sheets will be refreshed each meeting, as we do now.
The number of winners and losers will still need to be done manually I am afraid.
Hopefully these additions to the sheet will make things easier for you Terry, and also people will see "in running" how they stand for the meeting and overall as a whole.
There may be a few teething troubles with the formulas to start with, so I'd still double check manually for the first few.
Hope this helps.
Cheers,
G
P.S. @MAXALLY I have put 9 no shows against each of us, just so the totals tally with @vaigret's, as none of Sunday's have run yet. I will change to zero on the day and then you just do what you did before when there is a NR.
P.P.S. Give it a try Terry, and if you don't like it, we can go back to how it was before.
1.00: MITROSONFIRE (14)
1.35: THE PLATINUM QUEEN (7)
2.10: LORD RIDDIFORD (18)
2.45: STRATUM (5)
3.20: DOUBLE OR BUBBLE (6)
3.55: HOO YA MAL (5)
4.30: EMPIRESTATEOFMIND(7)
5.05: SONGO (13)
Great work again with the sheets Graham.
Also BIG THANKS to Terry & Alan for continued hard work in making this comp work.
Also, when I do the "permanent copy" I will sort the order from top to bottom, for the three tables (daily, meeting and overall), so it should be fairly straight forward for you.
I wouldn't "trust" the sheet straight away.
To start with I would do it exactly as you do now and then cross reference the sheet to see if everything matches.
When we are all "confident" that it works OK, then you should be able to rely on the sheet a bit more.
Any questions, give me a shout
1.00: JUAN LES PINS
1.35: THE PLATINUM QUEEN
2.10: WHENTHEDEALISDONE
2.45: TRUESHAN
3.20: KINROSS
3.55: ELDAR ELDAROV
4.30: ATRIUM
5.05: INCHICORE
13.00: FOOLS RUSH IN
13.35: MALRESCIA
14.10: NOMADIC EMPIRE
14.45: STRATUM
15.20: GARRUS
15.55: HOO YA MAL
16.30: EMPIRESTATEOFMIND
17.05: DARK JEDI
Not on sheet, could someone do me a favour and put them on the sheet please?
13.00: ABEL KANE
13.35: MALRESCIA
14.10: DAKOTA GOLD
14.45: TRUESHAN
15.20: DOUBLE OR BUBBLE
15.55: NEW LONDON
16.30: SYMBOLIZE
17.05: INCHICORE
ON SHEET
13.00: Juan Les Pins
13.35: Trillium
14.10: Count D'Orsay
14.45: Trueshan
15.20: Kinross
15.55: New London
16.30: Flor De La Luna
17.05: Wise Eagle
on sheet
12.30: SILVER KNOTT
1.00: MUMS TIPPLE
1.35: TRILLIUM
2.10: LORD RIDDIFORD
2.45: TRUESHAN
3.20: KINROSS
3.55: NEW LONDON
4.30: TYRRHENIAN SEA
5..05: INCHICORE
On Sheet
13. 00 FOOLS RUSH IN
14. 10 THE PLATINUM QUEEN
14.45 TRUESHAN
15.20 GARRUS
15.55 NEW LONDON
16.30 SYMBOLIZE
17.05 THEMAXWECAN
Sorry I'm latte