Message for Vaigret. I don't know how busy you are right now, but what would be really handy is to know what the overall MONTHLY and YEARLY Profit/Loss is for everyone up to an including today (30/10/17). This way I can implement the changes to test it all when I add tomorrow's results. Is this something you can do tonight, or are you busy?
If you can do it, post the two tables on this thread and I will sort the rest out with the Google Sheets.
This way hopefully I can have it all figured out before we formally start the new month.
If you could do the monthly table V that'd be great. What I really want to know is what the overall leader board totals are after tomorrow's (31/10/17) NAP results. I need to put this carry over figure into the November/Overall combined sheet.
Cheers,
G
P.S. Have you heard from Wynne? Hope he is OK. He managed to update the test sheets etc, but haven't had any NAP's from him the last couple of days.
Hi G Wynne posted on my facebook today about DTD so obviously ok.
With regard naps, have we changed the end of October end date then. I thought we were running October until Sunday 5th november or am I missing the point. when it comes down to it I can do an overall table to whatever date you want. Confirm which date and I will do. Will try and do weekly to 29th now.
Message for Vaigret. I don't know how busy you are right now, but what would be really handy is to know what the overall MONTHLY and YEARLY Profit/Loss is for everyone up to an including today (30/10/17). This way I can implement the changes to test it all when I add tomorrow's results. Is this something you can do tonight, or are you busy?
If you can do it, post the two tables on this thread and I will sort the rest out with the Google Sheets.
This way hopefully I can have it all figured out before we formally start the new month.
That's great, really appreciate it, we will then have a formal GOOGLE SHEET for calendar month OCTOBER after tomorrow's results, and I can also feed it in to NOVEMBER.
Going forward, all league tables "should" be "dynamically" updated on a daily basis, but I would still appreciate it if you verified them as before.
hope this all you need and they are right. Havent bothered with weekly from 22/10/17 bearing in mind the change of date and what we are doing going forward Terry
Hi all, I have done some playing around with the NAPS GOOGLE SHEET. Take a look, let me know your thoughts. I have spent quite a bit of time on it, so I hope you like it. Just continue to update your selection as before:
MONTHLY TABLE ON TOP, YEARLY ONE UNDERNEATH:
THE TOP THREE OF THE MONTHLY LEADER BOARD HAVE THE PRIVILEGE TO TYPE THEIR SELECTIONS INTO GOLD, SILVER AN BRONZE BACKGROUNDS:
When the P/L on the day is entered, it will update semi-dynamically both the MONTHLY and YEARLY tables. VAIGRET could you please check that my carry over totals are correct?
In the interest of fairness, 70% participation will now be required for the YEARLY table, as it's so hard to show a profit over such a long period, so favours those who do less selections, MONTHLY will remain at 50% as usually that is won with a profit. (VAIGRET can you notify me when someone slips below or indeed reaches the threshold, doesn't need to be exact?
VAIGRET, if at a later date you get more comfortable with the spreadsheet and are happy to maintain a "NUMBER OF SELECTIONS" and/or "WINS" and/or "NUMBER OF PLACES" column then we can work on that, but for now I am trying to keep manual processes that I have to do to a minimum.
To a degree we can all dabble with little bits of it as long as we know who's doing what. Let me know at a future date if you want me to set up columns for selections/wins/placed and losses etc.
MK, MISTY, JORDZ and MICKY are all close to that threshold, but just over it atm.
Just type it in the correct column, no need to save or do anything else. Just come out of it afterwards and then click on the link above again to check it's there.
Please note the two leaders, MISTY and MK, are below the NEW 70% threshold, but I have allowed them to remain as it's a new rule, provided they reach 70% participation by the end of the year they will retain their positions.
FYI, MIST, MK. You both currently have approx 60% participation, so a concerted effort over the last couple of months, on GO-LIVE days, should get you over the 70% threshold by the end of 2017 and a chance, potentially, to win some money for your chosen charity.
Hi all, I have done some playing around with the NAPS GOOGLE SHEET. Take a look, let me know your thoughts. I have spent quite a bit of time on it, so I hope you like it. Just continue to update your selection as before:
MONTHLY TABLE ON TOP, YEARLY ONE UNDERNEATH:
THE TOP THREE OF THE MONTHLY LEADER BOARD HAVE THE PRIVILEGE TO TYPE THEIR SELECTIONS INTO GOLD, SILVER AN BRONZE BACKGROUNDS:
When the P/L on the day is entered, it will update semi-dynamically both the MONTHLY and YEARLY tables. VAIGRET could you please check that my carry over totals are correct?
In the interest of fairness, 70% participation will now be required for the YEARLY table, as it's so hard to show a profit over such a long period, so favours those who do less selections, MONTHLY will remain at 50% as usually that is won with a profit. (VAIGRET can you notify me when someone slips below or indeed reaches the threshold, doesn't need to be exact?
VAIGRET, if at a later date you get more comfortable with the spreadsheet and are happy to maintain a "NUMBER OF SELECTIONS" and/or "WINS" and/or "NUMBER OF PLACES" column then we can work on that, but for now I am trying to keep manual processes that I have to do to a minimum.
To a degree we can all dabble with little bits of it as long as we know who's doing what. Let me know at a future date if you want me to set up columns for selections/wins/placed and losses etc.
MK, MISTY, JORDZ and MICKY are all close to that threshold, but just over it atm.
Comments
If you can do it, post the two tables on this thread and I will sort the rest out with the Google Sheets.
This way hopefully I can have it all figured out before we formally start the new month.
Cheers,
G
With regard naps, have we changed the end of October end date then. I thought we were running October until Sunday 5th november or am I missing the point. when it comes down to it I can do an overall table to whatever date you want. Confirm which date and I will do. Will try and do weekly to 29th now.
V
Going forward, all league tables "should" be "dynamically" updated on a daily basis, but I would still appreciate it if you verified them as before.
Thanks again,
G
- MKGUNNER- 159 SEL 44 WINNERS 42 PLACED 73 LOSERS - £ 3.03 UP
- RABDENIRO - 217 SEL 56 WINNERS 56 PLACED 105 LOSERS - £ (4.42)
- MISTY4ME - 164 SEL 34 WINNERS 36 PLACED 94 LOSERS - £ (25.83)
- WYNNE1938- 216 SEL 63 WINNERS 51 PLACED 102 LOSERS - £ (27.35)
- PHANTOM66 - 203 SEL 29 WINNERS 44 PLACED 130 LOSERS- £(30.39)
- VAIGRET - 221 SEL 34 WINNERS 60 PLACED 127 LOSERS -£ (32.10)
- STAYORGO - 215 SEL 55 WINNERS 61 PLACED 99 LOSERS - £ (33.93)
- JORDZ16 - 178 SEL 26 WINNERS 40 PLACED 112 LOSERS - £ (35.20)
- SNUFFER - 194 SEL 42 WINNERS 45 PLACED 107 LOSERS - £ (42.74)
- MICKYBLUE - 152 SEL 20 WINNERS 37 PLACED 95 LOSERS - £(69.98)
- ZADOC - 222 SEL 34 WINNERS 71 PLACED 117 LOSERS - £ (77.14)
- MAXALLY - 217 SEL 19 WINNERS 44 PLACED 154 LOSERS - £(98.86)
- HANSON - 33 SEL 3 WINNERS 9 PLACED 21 LOSERS - £ (6.00)
Well done RABDENIRO ON CLOSING THE GAP AT THE TOP.hOPE ALL ABOVE CORRECT
MISTY4ME 57 SELECTIONS 16 WINNERS 10 PLACED 31 LOSERS £ 7.21 UP
MKGUNNER 55 SELECTIONS 18 WINNERS 14 PLACED 23 LOSERS £ 3.33 UP
VAIGRET 94 SELECTIONS 17 WINNERS 25 PLACED 52 LOSERS £ 0.15 UP
SNUFFER 70 SELECTIONS 18 WINNERS 16 PLACED 36 LOSERS £ (2.51)
RABDENIRO 93 SELECTIONS 22 WINNERS 23 PLACED 48 LOSERS £ (6.77)
STAYORGO 92 SELECTIONS 25 WINNERS 27 PLACED 40 LOSERS £ (6.83)
PHANTOM66 92 SELECTIONS 17 WINNERS 21 PLACED 54 LOSERS £(7.89)
JORDZ16 84 SELECTIONS 15 WINNERS 17 PLACED 52 LOSERS £ (15.20)
WYNNE1938 88 SELECTIONS 21 WINNERS 22 PLACED 45 LOSERS £ (22.19)
MICKYBLUE 68 SELECTIONS 12 WINNERS 16 PLACED 40 LOSERS £(26.48)
ZADOC 91 SELECTIONS 17 WINNERS 26 PLACED 48 LOSERS £ (31.65)
MAXALLY 84 SELECTIONS 10 WINNERS 14 PLACED 60 LOSERS £(35.36)
HANSON 12 SELECTIONS 2 WINNERS 2 PLACED 8 LOSERS £ (2.00)
hope this all you need and they are right. Havent bothered with weekly from 22/10/17 bearing in mind the change of date and what we are doing going forward
Terry
MONTHLY TABLE ON TOP, YEARLY ONE UNDERNEATH:
THE TOP THREE OF THE MONTHLY LEADER BOARD HAVE THE PRIVILEGE TO TYPE THEIR SELECTIONS INTO GOLD, SILVER AN BRONZE BACKGROUNDS:
https://docs.google.com/spreadsheets/d/1c4fW3INzu1z_Sb9zlPKZBG0B1uuui935_8hQYp-3NWc/edit#gid=0
When the P/L on the day is entered, it will update semi-dynamically both the MONTHLY and YEARLY tables. VAIGRET could you please check that my carry over totals are correct?
In the interest of fairness, 70% participation will now be required for the YEARLY table, as it's so hard to show a profit over such a long period, so favours those who do less selections, MONTHLY will remain at 50% as usually that is won with a profit. (VAIGRET can you notify me when someone slips below or indeed reaches the threshold, doesn't need to be exact?
VAIGRET, if at a later date you get more comfortable with the spreadsheet and are happy to maintain a "NUMBER OF SELECTIONS" and/or "WINS" and/or "NUMBER OF PLACES" column then we can work on that, but for now I am trying to keep manual processes that I have to do to a minimum.
To a degree we can all dabble with little bits of it as long as we know who's doing what. Let me know at a future date if you want me to set up columns for selections/wins/placed and losses etc.
MK, MISTY, JORDZ and MICKY are all close to that threshold, but just over it atm.
Any feedback/comments, let me know.
Cheers,
G
https://docs.google.com/spreadsheets/d/1c4fW3INzu1z_Sb9zlPKZBG0B1uuui935_8hQYp-3NWc/edit#gid=0
Just type it in the correct column, no need to save or do anything else. Just come out of it afterwards and then click on the link above again to check it's there.
Cheers,
G
https://docs.google.com/spreadsheets/d/e/2PACX-1vTZKXk0SFPt1IfktkIbtPuIDCorMRITaMaUDvLRaYzMtWP5Kiv9rF3MaRLOFjJ7fPl3auRWN2Yid-mx/pubhtml
Please note the two leaders, MISTY and MK, are below the NEW 70% threshold, but I have allowed them to remain as it's a new rule, provided they reach 70% participation by the end of the year they will retain their positions.
FYI, MIST, MK. You both currently have approx 60% participation, so a concerted effort over the last couple of months, on GO-LIVE days, should get you over the 70% threshold by the end of 2017 and a chance, potentially, to win some money for your chosen charity.
Cheers,
G