You need to be logged in to your Sky Poker account above to post discussions and comments.

You might need to refresh your page afterwards.

Jackpot Syndicate - NAPs tables for October

12930313335

Comments

  • StayOrGoStayOrGo Member Posts: 12,169
    zadoc said:

    JACKPOT meeting tomorrow ( Tuesday ) is at CATTERICK.

    Great, many thanks for finding out R, it will be a NO-GO
  • StayOrGoStayOrGo Member Posts: 12,169
    edited October 2017
    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.

    Cheers,

    G
  • vaigretvaigret Member Posts: 16,372
    StayOrGo said:

    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.

    V
  • vaigretvaigret Member Posts: 16,372
    StayOrGo said:

    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.

    Cheers,

    G

    sorry only just seen this post will do G
  • StayOrGoStayOrGo Member Posts: 12,169
    edited October 2017
    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.

    Thanks again,

    G
  • vaigretvaigret Member Posts: 16,372
    overall table upto and including 30/10/17
    1. MKGUNNER- 159 SEL 44 WINNERS 42 PLACED 73 LOSERS - £ 3.03 UP
    2. RABDENIRO - 217 SEL 56 WINNERS 56 PLACED 105 LOSERS - £ (4.42)
    3. MISTY4ME - 164 SEL 34 WINNERS 36 PLACED 94 LOSERS - £ (25.83)
    4. WYNNE1938- 216 SEL 63 WINNERS 51 PLACED 102 LOSERS - £ (27.35)
    5. PHANTOM66 - 203 SEL 29 WINNERS 44 PLACED 130 LOSERS- £(30.39)
    6. VAIGRET - 221 SEL 34 WINNERS 60 PLACED 127 LOSERS -£ (32.10)
    7. STAYORGO - 215 SEL 55 WINNERS 61 PLACED 99 LOSERS - £ (33.93)
    8. JORDZ16 - 178 SEL 26 WINNERS 40 PLACED 112 LOSERS - £ (35.20)
    9. SNUFFER - 194 SEL 42 WINNERS 45 PLACED 107 LOSERS - £ (42.74)
    10. MICKYBLUE - 152 SEL 20 WINNERS 37 PLACED 95 LOSERS - £(69.98)
    11. ZADOC - 222 SEL 34 WINNERS 71 PLACED 117 LOSERS - £ (77.14)
    12. MAXALLY - 217 SEL 19 WINNERS 44 PLACED 154 LOSERS - £(98.86)
    13. 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
  • vaigretvaigret Member Posts: 16,372
    MONTHLY TABLE UP TO AND INCLUDING 30/10/17
    1. RABDENIRO 33 SELECTIONS 12 WINNERS 3 PLACED 18 LOSERS £ 11.07 UP
    2. MKGUNNER 13 SELECTIONS 6 WINNERS 1 PLACED 6 LOSERS £ 0.85 UP
    3. STAYORGO 34 SELECTIONS 12 WINNERS 9 PLACED 13 LOSERS £ 0.55 UP
    4. HANSON 27 SELECTIONS 3 WINNERS 6 PLACED 18 LOSERS £ 0.00 -
    5. JORDZ16 16 SELECTIONS 2 WINNERS 4 PLACED 10 LOSERS £ 0.00 -
    6. MICKYBLUE 10 SELECTIONS 3 WINNERS 3 PLACED 4 LOSERS £(1.12)
    7. WYNNE1938 19 SELECTIONS 6 WINNERS 4 PLACED 9 LOSERS £ (3.39)
    8. MISTY4ME 29 SELECTIONS 5 WINNERS 9 PLACED 15 LOSERS £( 5.00)
    9. SNUFFER 27 SELECTIONS 7 WINNERS 4 PLACED 16 LOSERS £ (6.69)
    10. VAIGRET 33 SELECTIONS 5 WINNERS 6 PLACED 22 LOSERS £ (7.25)
    11. PHANTOM66 19 SELECTIONS 2 WINNERS 5 PLACED 12 LOSERS £(9.50)
    12. ZADOC 36 SELECTIONS 6 WINNERS 13 PLACED 17 LOSERS £ (14.75)
    13. MAXALLY 36 SELECTIONS 2 WINNERS 11 PLACED 23 LOSERS £(25.00)
  • vaigretvaigret Member Posts: 16,372
    LIVE TABLE AS AT 30/10/17

    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)
  • vaigretvaigret Member Posts: 16,372
    Graham

    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
  • StayOrGoStayOrGo Member Posts: 12,169
    That's perfect, thx Terry!
  • vaigretvaigret Member Posts: 16,372
    edited October 2017
    wrong duplicate post
  • vaigretvaigret Member Posts: 16,372
    1.05 SARABI HOPEFULLY ALSO POSTED ON GOOGLE SHEET
  • MISTY4MEMISTY4ME Member Posts: 6,282
    edited October 2017
    2.40: INGLEBY HOLLOW (posted on sheet)
  • vaigretvaigret Member Posts: 16,372
    ZADOC SAID CATTERICK GOOGLE SHEET SAYS CHEPSTOW, CONFUSED DOT COM
  • StayOrGoStayOrGo Member Posts: 12,169
    vaigret said:

    ZADOC SAID CATTERICK GOOGLE SHEET SAYS CHEPSTOW, CONFUSED DOT COM

    Well spotted! My bad, corrected now.
  • StayOrGoStayOrGo Member Posts: 12,169
    edited October 2017
    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:

    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
  • StayOrGoStayOrGo Member Posts: 12,169
    edited October 2017
    vaigret said:

    1.05 SARABI HOPEFULLY ALSO POSTED ON GOOGLE SHEET

    Hi V, it isn't there for some reason, maybe I was messing around with it when you were trying to update it. Try doing it via this link:

    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
  • StayOrGoStayOrGo Member Posts: 12,169
    edited October 2017
    Here is a look at the "NEW STYLE" GO-LIVE ONLY YEARLY LEADER BOARD: (READ ONLY WEB VERSION)

    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
  • SnufferSnuffer Member Posts: 3,057
    StayOrGo said:

    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:

    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

    Great job Graham, looks really slick!
  • SnufferSnuffer Member Posts: 3,057
    2.10: FINGAL'S CAVE (posted on GOOGLE)
Sign In or Register to comment.