In Response to Re: Skill & Go Chirps Binks & Porkies : hi CM I think your formulas are not right. i downloaded your spreadsheet and it differs from mine. we need to reconcile. it's either me or you who is right, or both wrong. regards Posted by aussie09
I think we are just using different methods to work out the same thing
=IF(C4="",G3,((G3*B3) + (E4/C4))/B4)
B = number of games
C = buy in
E = profit
G = average ROI
so my formula in words...
IF (the buy in is blank, then use the previous average ROI, otherwise (multiply the previous Average ROI by the previous number of games played) + (the ROI from the current game) / the new total number of games))
I guess the important thing is that we get the same results?
The first leaderboard has been PUBLISHED folks. Remember it's only displaying players who have already reached the 30 game criteria so most of you won't be on there yet. AndyL1986 setting the early pace with a solid ROI of 45%. Posted by Sky_DanR
Erm. I should be on the leaderboard no?
I have completed 30 games and have entered the code...
In Response to Re: Skill & Go Chirps Binks & Porkies : Erm. I should be on the leaderboard no? I have completed 30 games and have entered the code... Posted by gazza127
Our report has you down as playing less than 30, looks like quite a few of your games finished after midnight last night which is probably why, you'll be on there tomorrow.
Depends what time they compiled it gazza. You and a few others look set to knock me out of 6th. How do the maths change once head over 30 games of regular 6max? what will a win or 2nd add to your avg roi?
In Response to Re: Skill & Go Chirps Binks & Porkies : Our report has you down as playing less than 30, looks like quite a few of your games finished after midnight last night which is probably why, you'll be on there tomorrow. Posted by Sky_DanR
Can we double check the figures posted please?
Hate to be that guy, but I had to check SS to double check. There are different av ROIs for many of the players. It even suggests one of the players currently in the top 6 has only completed 29 games since the promo started.
In Response to Re: Skill & Go Chirps Binks & Porkies : I think we are just using different methods to work out the same thing =IF(C4="",G3,((G3*B3) + (E4/C4))/B4) B = number of games C = buy in E = profit G = average ROI so my formula in words... IF (the buy in is blank, then use the previous average ROI, otherwise (multiply the previous Average ROI by the previous number of games played) + (the ROI from the current game) / the new total number of games)) I guess the important thing is that we get the same results? Posted by chicknMelt
hi CM.
Yes, we agree. I deleted my post as there was no difference. We were both corect.
In Response to Re: Skill & Go Chirps Binks & Porkies : Can we double check the figures posted please? Hate to be that guy, but I had to check SS to double check. There are different av ROIs for many of the players. It even suggests one of the players currently in the top 6 has only completed 29 games since the promo started. Posted by gazza127
In Response to Re: Skill & Go Chirps Binks & Porkies : Can we double check the figures posted please? Hate to be that guy, but I had to check SS to double check. There are different av ROIs for many of the players. It even suggests one of the players currently in the top 6 has only completed 29 games since the promo started. Posted by gazza127
Sharkscope has missed one of my games Gazza. Had to check my sky account after scoping myself earlier but it must have missed a game. It was a regular 6max so not sure what the problem was.
In Response to Re: Skill & Go Chirps Binks & Porkies : Which player does it say has played 29? Posted by Sky_DanR
Beno1980.
Maybe its wrong... but it seems there are different av ROIs on a number of other players too... some of which have actually posted their final ROIs on this thread.
In Response to Re: Skill & Go Chirps Binks & Porkies : Beno1980. Maybe its wrong... but it seems there are different av ROIs on a number of other players too... some of which have actually posted their final ROIs on this thread. Posted by gazza127
I'm coming for you guys!! 5 more under the belt and still going well. Totals now are.... 13 played Wins - 5 2nd - 3 Losses - 5 Anyone know what that ROI is? Posted by Lambert180
In Response to Re: Skill & Go Chirps Binks & Porkies : Beno1980. Maybe its wrong... but it seems there are different av ROIs on a number of other players too... some of which have actually posted their final ROIs on this thread. Posted by gazza127
Right, think we've found the source of the potential data issue, conversations being had with the necessary people and we'll keep you updated on here, will aim to get this sorted as soon as possible.
I've basically shot myself in the foot with this promo. Got to 30 games with an Ave ROI in the mid to high 40s. I ask some friends, do you think that'll be enough? No they say. I try to improve it. Swong. Sigh.
So two options. Either I give up or I end up grinding into the hundreds to try to get it back. I wonder which I will choose.....
So the first run of data included games where you've registered and then unregistered (not played), obviously these shouldn't be counted and will affect the number of games played and the actual ROI.
Thankfully nipped in the bud nice and early (thanks Gazza), report is being re-run now and will be published shortly.
I've basically shot myself in the foot with this promo. Got to 30 games with an Ave ROI in the mid to high 40s. I ask some friends, do you think that'll be enough? No they say. I try to improve it. Swong. Sigh. So two options. Either I give up or I end up grinding into the hundreds to try to get it back. I wonder which I will choose..... [ ] Actually wondering Posted by TommyD
I actually think mid to high 40s may have grabbed you 5th or 6th, Tommy.
So the first run of data included games where you've registered and then unregistered (not played), obviously these shouldn't be counted and will affect the number of games played and the actual ROI. Thankfully nipped in the bud nice and early (thanks Gazza), report is being re-run now and will be published shortly. Posted by Sky_DanR
I await my free entry to Sundays Roller with eagerness for pointing this out.
Comments
hi CM.
Yes, we agree. I deleted my post as there was no difference. We were both corect.
Cheers man
...and so the promotional discrepancies begin...
So two options. Either I give up or I end up grinding into the hundreds to try to get it back. I wonder which I will choose.....
[ ] Actually wondering
*This may be slightly swayed by the fact I want you to stop regging all the games I wanna play