JACKPOT meeting for tomorrow ( FRIDAY ) is UTTOXETER
Thanks R, the UTTOXETER card sets up quite well, I think we should go for it.
Are you OK to do the card Roger on the GOOGLE SHEET template I sent you?
Please name the file 171103_UTTOXETER_REMOVERS and only share it with me for now (update access)
So your process should be to make a copy of the template file I sent you. Call it 171103_UTTOXETER_REMOVERS, update the sheet as normal, and notify me when done.
Don't directly update the template file otherwise you will lose the template.
Checking each of the tables on a daily basis is a bit of a problem to me as I am working on manual basis and is a **** of a lot of work. Happy to check weekly and would suggest if people have a discrepancy with a total on any one given day they should advise themselves. Unfortunately because we go away sunday for couple of days that weekly check wont be until next sunday night. Hope that is ok.
As to the average profit and loss how do you work the figure. I think I have worked out rabdeniro's but struggling with others. Can you do a maths example on mine to help me understand it better.
As to the table and how it based I would still have it in order of simple profit and loss with only people who have done the requisite % being on the leaderboard. Average profit and loss per selection whilst it might be useful to have on the sheet leaves me confused.
Checking each of the tables on a daily basis is a bit of a problem to me as I am working on manual basis and is a **** of a lot of work. Happy to check weekly and would suggest if people have a discrepancy with a total on any one given day they should advise themselves. Unfortunately because we go away sunday for couple of days that weekly check wont be until next sunday night. Hope that is ok.
As to the average profit and loss how do you work the figure. I think I have worked out rabdeniro's but struggling with others. Can you do a maths example on mine to help me understand it better.
As to the table and how it based I would still have it in order of simple profit and loss with only people who have done the requisite % being on the leaderboard. Average profit and loss per selection whilst it might be useful to have on the sheet leaves me confused.
V
Yep no problem mate, weekly/as a when is fine, obviously the longer it is the more chance of compounding errors, but I appreciate you can't do it 24/7.
Regarding average P/L. It is simply total profit divided by number of selections.
So take your overall figures. You have a £38.10 loss as of 3/11/17 from 227 selections. So -£38.10/227 = an average of 17p loss per selection (Actually slightly less due to rounding). I can go to 5dp's if required. See below:
Checking each of the tables on a daily basis is a bit of a problem to me as I am working on manual basis and is a **** of a lot of work. Happy to check weekly and would suggest if people have a discrepancy with a total on any one given day they should advise themselves. Unfortunately because we go away sunday for couple of days that weekly check wont be until next sunday night. Hope that is ok.
As to the average profit and loss how do you work the figure. I think I have worked out rabdeniro's but struggling with others. Can you do a maths example on mine to help me understand it better.
As to the table and how it based I would still have it in order of simple profit and loss with only people who have done the requisite % being on the leaderboard. Average profit and loss per selection whilst it might be useful to have on the sheet leaves me confused.
V
Yep no problem mate, weekly/as a when is fine, obviously the longer it is the more chance of compounding errors, but I appreciate you can't do it 24/7.
Regarding average P/L. It is simply total profit divided by number of selections.
So take your overall figures. You have a £38.10 loss as of 3/11/17 from 227 selections. So -£38.10/227 = an average of 17p loss per selection. I can go to 4dp's if required.
Make sense?
Cheers,
G
Hi G,
Yes makes sense, that was what I thought i was doing and as I said I agreed Rabdeniro's, obviously hit a wrong key when I checked mine or wishful thinking one of the two. totally understand now. Up to you and feedback from others on how the table is sorted.
As to weekly or when I can do check and compound errors. They wont compound as when I do my check I double check back on all the results if i have any discrepancy with yours. As long as the results of the naps are posted daily I will pick up everything. Hope that ok.
Comments
https://docs.google.com/spreadsheets/d/e/2PACX-1vQ8Dg_qPtM4Qc3Q4iXAW_-WpShThNKYQtNa9uwrfzYoOckHzOGZpRJignMUkx0Zt8qOG0NSaxl8gIS-/pubhtml
Are you OK to do the card Roger on the GOOGLE SHEET template I sent you?
Please name the file 171103_UTTOXETER_REMOVERS and only share it with me for now (update access)
So your process should be to make a copy of the template file I sent you. Call it 171103_UTTOXETER_REMOVERS, update the sheet as normal, and notify me when done.
Don't directly update the template file otherwise you will lose the template.
Any questions, let me know.
Many thanks,
G
Link below:
https://docs.google.com/spreadsheets/d/1sMTbNkXdfnrx8vIPFaeg8-5BJZ-OegJeZh-D81Hc-ao/edit#gid=0
VWP R!
https://docs.google.com/spreadsheets/d/e/2PACX-1vTU6fssvXUsFR5OzXbZozsSkL8IRcU9eN8uLV_8M-KN_fOyTQzcmUJI7Vj3bliCsnsXvwYT2081OO6_/pubhtml
https://docs.google.com/spreadsheets/d/e/2PACX-1vTRcG-lXmFNs600EJDDJsBJESOo5j2e05vvG_DbJcle8dJf4Q923VX1YdRFhEfNbF4Rqlsxv8U7EaWX/pubhtml
https://docs.google.com/spreadsheets/d/e/2PACX-1vTaTiytztQsusrdIrZPdGIVByxcHkSYZmP34iJKS2Xqj3wRSsf1buyDFH1wv5XynIWGK7E_a3ASkdQh/pubhtml
https://docs.google.com/spreadsheets/d/1c4fW3INzu1z_Sb9zlPKZBG0B1uuui935_8hQYp-3NWc/edit#gid=0
Cheers,
G
Checking each of the tables on a daily basis is a bit of a problem to me as I am working on manual basis and is a **** of a lot of work. Happy to check weekly and would suggest if people have a discrepancy with a total on any one given day they should advise themselves. Unfortunately because we go away sunday for couple of days that weekly check wont be until next sunday night. Hope that is ok.
As to the average profit and loss how do you work the figure. I think I have worked out rabdeniro's but struggling with others. Can you do a maths example on mine to help me understand it better.
As to the table and how it based I would still have it in order of simple profit and loss with only people who have done the requisite % being on the leaderboard. Average profit and loss per selection whilst it might be useful to have on the sheet leaves me confused.
V
Regarding average P/L. It is simply total profit divided by number of selections.
So take your overall figures. You have a £38.10 loss as of 3/11/17 from 227 selections. So -£38.10/227 = an average of 17p loss per selection (Actually slightly less due to rounding). I can go to 5dp's if required. See below:
https://docs.google.com/spreadsheets/d/1c4fW3INzu1z_Sb9zlPKZBG0B1uuui935_8hQYp-3NWc/edit#gid=0
Make sense?
Cheers,
G
Yes makes sense, that was what I thought i was doing and as I said I agreed Rabdeniro's, obviously hit a wrong key when I checked mine or wishful thinking one of the two. totally understand now. Up to you and feedback from others on how the table is sorted.
As to weekly or when I can do check and compound errors. They wont compound as when I do my check I double check back on all the results if i have any discrepancy with yours. As long as the results of the naps are posted daily I will pick up everything. Hope that ok.
V
Cheers,
G
WILL CHECK THE YEARLY AND MONTHLY TABLE BY POSTING MY TABLES AS PREVIOUSLY AGREED AS SOON AS I CAN
This is the link to the GO-LIVE NAP's
https://docs.google.com/spreadsheets/d/1sMTbNkXdfnrx8vIPFaeg8-5BJZ-OegJeZh-D81Hc-ao/edit#gid=0
SHOULDNT BE A PROBLEM ANYWAY AS I WILL CHECK THE LIVE TABLE AFTER EVERYTIME WE HAVE AN ATTEMPT AS THAT IS SPORADIC RATHER THAN DAILY.
Just confused myself earlier.
V
https://docs.google.com/spreadsheets/d/e/2PACX-1vTOred86hyEix9aWvVi3V1E37M-75lUMsxuYYCiPXXLZfbzB1Sn24qFkpq6-tSmVfuT5b_4828Vtw_J/pubhtml
Vaigret to check weekly/as and when available, so errors possible until validated.
RABDENIRO HAS 57 WINNERS NOT 58 IN YEARLY FIGURES.
MY CHECKING TABLE FOR YEARLY BELOW