I am pretty sure the problem came about when pasting formats to get the gold silver and bronze in the right order. It won't look as good, but also to make it easier for myself and MAX when I am away, I think I will keep them all the same format for now, as it adds more manual steps.
I have almost completed a new design that "should" make things easier/less prone to error, but it will be best to implement it on 1st Dec when monthly totals are zero.
Really appreciate your dedication and attention to detail mate.
OK, this was my mistake not MAX's, as I checked it and said it was OK, but there was an error with MKGUNNER's score on the yearly. The link above shows the TODAY P/L as £0.00 in the yearly and it should have been -£1.00
It has been amended on the "active sheet" and MK's yearly profit is now £2.03 not £3.03.
I believe the total selections and number of winners are correct, but when you do your next check Vaigret, can you just make sure.
OK, this was my mistake not MAX's, as I checked it and said it was OK, but there was an error with MKGUNNER's score on the yearly. The link above shows the TODAY P/L as £0.00 in the yearly and it should have been -£1.00
It has been amended on the "active sheet" and MK's yearly profit is now £2.03 not £3.03.
I believe the total selections and number of winners are correct, but when you do your next check Vaigret, can you just make sure.
Cheers,
G
WILL DO AND I CONFIRM THAT AFTER 8/11 MKGUNNERS SELECTIONS 160 WINNERS 44
In fact it was probably me that changed it to zero when I was testing out the conditional formatting of the blue/grey/red cells. Probably forgot to change it back. Sorry chaps!
May have been me G, sorry. Glad with have got V for back up. He will defo be needed to check my work while you are away. It is defo getting there though. Hopefully, the process for all the syndicate work will work smoothly once we are all on board and this ship will sail without any hitches.
Example SNUFFER yesterday on Monthly -£1.65, no selections today, you have him as -£1.34
Row muddle up somewhere as others also out. Unless I have made an error previously.
The error is with the sheets Im afraid and as I have said I cannot check everyday. Lets start with the monthly although the error I am going to highlight will affect the yearly as well and I would ask you to correct that beforte I check that one again.
Here we go
All correct Monthly except STAYORGO YOU KEEP DIDDLING YOURSELF OUT OF A PENNY HANSON on 7th his selection WICKER (loser) put against SNUFFER whose selection MAGIC MIRROR (winner) put against Hanson.
Comments
Cheers,
G
https://docs.google.com/spreadsheets/d/e/2PACX-1vT5aSgSjBYAH8KJvLtWV07QuAz5h9uKHTlA2xZqxbyiky2XTL23Nfb6gtboDa_M8ff9Hqu0zRoW9rhn/pubhtml
It has been amended on the "active sheet" and MK's yearly profit is now £2.03 not £3.03.
I believe the total selections and number of winners are correct, but when you do your next check Vaigret, can you just make sure.
Cheers,
G
https://docs.google.com/spreadsheets/d/e/2PACX-1vTgyTbZcYzYzLgzE7FXtlJJTioAoIwPFrLJa5mt6UvGVkviacytfP1nCaUlu_MXWQ2pElecVdVFGM_h/pubhtml
- RABDENIRO - 239 SEL 63 WINNERS 176 LOSERS - £ (0.29)
- PHANTOM66 - 203 SEL 29 WINNERS 174 LOSERS- £(30.39)
- WYNNE1938- 233 SEL 68 WINNERS 165 LOSERS - £ (32.68)
- STAYORGO - 237 SEL 62 WINNERS 175 LOSERS - £ (32.85)
- MISTY4ME - 177 SEL 36 WINNERS 141 LOSERS - £ (35.01)
- JORDZ16 - 178 SEL 26 WINNERS 152 LOSERS - £ (35.20)
- VAIGRET - 241 SEL 36 WINNERS 205 LOSERS -£ (42.10)
- SNUFFER - 213 SEL 48 WINNERS 165 LOSERS - £ (45.42)
- ZADOC - 244 SEL 40 WINNERS 204 LOSERS - £ (71.41)
- MAXALLY - 239 SEL 19 WINNERS 210 LOSERS - £(120.86)
MKGUNNER- 159 SEL 44 WINNERS 125 LOSERS - £ 2.03 UPHANSON - 49 SEL 6 WINNERS 43 LOSERS - £ (16.74)
MICKYBLUE - 158 SEL 21 WINNERS 137 LOSERS - £(74.54)
TO BE USED FOR CHECKING
- ZADOC 16 SELECTIONS 4 WINNERS £2.82 UP
- RABDENIRO 16 SELECTIONS 5 WINNERS £2,38 UP
- STAYORGO 16 SELECTIONS 4 WINNERS £(0.96)
- SNUFFER 13 SELECTIONS 4 WINNERS £(1.34)
- WYNNE1938 13 SELECTIONS 4 WINNERS £(3,24)
- VAIGRET 15 SELECTIONS 2 WINNERS £(5,00)
- HANSON 11 SELECTIONS 2 WINNERS £(7.65)
- MAXALLY 16 SELECTONS 0 WINNERS £(16,00)
PHANTOM66 0 SELECTIONS 0 WINNERS 0.00JORDZ16 0 SELECTIONS 0 WINNERS 0.00
MKGUNNER 1 SELECTION 0 WINNERS £(1.00)
MICKYBLUE 6 SELECTIONS 1 WINNER £(4.56)
MISTY4ME 7 SELECTIONS 1 WINNER £(5.09)
FOR CHECKING PURPOSES
- RABDENIRO - 239 SEL 63 WINNERS 176 LOSERS - £ (0.29)
- PHANTOM66 - 203 SEL 29 WINNERS 174 LOSERS- £(30.39)
- WYNNE1938- 233 SEL 68 WINNERS 165 LOSERS - £ (32.68)
- STAYORGO - 237 SEL 62 WINNERS 175 LOSERS - £ (32.85)
- MISTY4ME - 177 SEL 36 WINNERS 141 LOSERS - £ (35.01)
- JORDZ16 - 178 SEL 26 WINNERS 152 LOSERS - £ (35.20)
- VAIGRET - 241 SEL 36 WINNERS 205 LOSERS -£ (42.10)
- SNUFFER - 213 SEL 48 WINNERS 165 LOSERS - £ (45.42)
- ZADOC - 244 SEL 40 WINNERS 204 LOSERS - £ (71.41)
- MAXALLY - 239 SEL 19 WINNERS 210 LOSERS - £(120.86)
MKGUNNER- 160 SEL 44 WINNERS 126 LOSERS - £ 2.03 UPHANSON - 49 SEL 6 WINNERS 43 LOSERS - £ (16.74)
MICKYBLUE - 158 SEL 21 WINNERS 137 LOSERS - £(74.54)
correct chart
https://docs.google.com/spreadsheets/d/1c4fW3INzu1z_Sb9zlPKZBG0B1uuui935_8hQYp-3NWc/edit#gid=0
I will not post results or reset spreadsheet until verified who's right.
Cheers,
G
Row muddle up somewhere as others also out. Unless I have made an error previously.
Here we go
All correct Monthly except STAYORGO YOU KEEP DIDDLING YOURSELF OUT OF A PENNY
HANSON on 7th his selection WICKER (loser) put against SNUFFER whose selection MAGIC MIRROR (winner) put against Hanson.
Hopefully that change will sort the monthly out.
V
your sheets all correct except VAIGRET 237 SELECTIONS NOT 238
Sorry, I am trying to sort this while playing. It's not a great time of day for me to try and do this.
Could you please tell me which rows are wrong.