Quote:
Originally Posted by TrustySam
Hey, 1:1, thanks so much for spending all that time doing the downloads, and then sharing all the info with us. And thanks blopp for posting a link to this thread in the other thread that got started in NVG - have really enjoyed looking over the data.
I don't mind typing in the data and figuring out the winrates pre-rakeback, and rake in terms of bb/100, if op gives me the actual formulas used - am on break, and type pretty fast, so once one chart gets set up, it shouldn't take too long to do the rest.
Okay, well once things got going, it didn't wind up taking so long - the high school algebra actually wound up taking longer than typing in the data
Do these look right to everybody?
EG1.
Rakeback estimates the OP used:
Bronze to Gold - 19%
Bronze to Platinum - 24%
Bronze to Supernova - 27%
So for this person, where w is the winrate, and R is the rake:
1) w + 0.19R = 9.52 (Bronze to Gold)
2) w + 0.24R = 10.01 (Bronze to Platinum)
3) w + 0.27R = 10.36 (Bronze to Supernova)
Rewriting (1) gives: w = 9.52 - 0.19R
And substituting (1) into (2) gives: (9.52 - 0.19R) + 0.24R = 10.01
0.05R = 0.49
therefore R = 9.8bb/100
and w = 9.52 – 0.19(9.8) = 7.66bb/100
Check using (3):
w + 0.27R = 10.36
w = 10.36 – 0.27R
w = 10.36 – 0.27(9.8) = 7.7bb/100 <- guess this is roundoff error?
EG2.
Rakeback estimates the OP used:
Platinum to Supernova - 43%
Supernova to Supernova 500k - 45%
Supernova to Supernova Elite - 55%
Checked the spreadsheet calculations found using the 'PN-SN' and 'SN-500K' columns, using the data for this person from the 'SNE' column:
w + 0.55R = -0.37
w = -0.37 – 0.55(8.06)
w = -4.80 <- roundoff error?
Hopefully 1:1 will come back later today, and double-check everything to make sure it's okay. But for now, here's what the spreadsheet churned out - if anybody spots any typos, etc. please let me know:
So nice to have this data, not just for Zoom but for the other games too - thanks again to 1:1 and blopp for sharing! Hope the formula I used is okay!! eek!!
Last edited by TrustySam; 07-29-2014 at 08:02 AM.