10-29-2011, 12:32 PM | #21 |
Batch Manager
Game Manager, Song Release Coordinator
Join Date: Mar 2008
Location: USA
Age: 29
Posts: 14,867
|
Re: iironiic's little experiment
Enginuity, this is all I see when I tried changing the levelranks to mine in excel:
Code:
Difficulty # Songs # Played # AAA (well, rank = 1) % AAA'd 1 5 #NAME? #NAME? #NAME? 2 27 #NAME? #NAME? #NAME? 3 31 #NAME? #NAME? #NAME? 4 44 #NAME? #NAME? #NAME? 5 53 #NAME? #NAME? #NAME? 6 70 #NAME? #NAME? #NAME? 7 100 #NAME? #NAME? #NAME? 8 143 #NAME? #NAME? #NAME? 9 167 #NAME? #NAME? #NAME? 10 173 #NAME? #NAME? #NAME? 11 88 #NAME? #NAME? #NAME? 12 50 #NAME? #NAME? #NAME? 13 2 #NAME? #NAME? #NAME? Difficulty Scores: AAA -1 -2 -3 -4 -5 -6 -7 -8 -9 -10 1 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 1 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 1 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 1 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 2 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 2 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 2 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 2 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 3 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 3 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 3 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 3 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 4 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 4 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 4 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 4 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 5 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 5 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 5 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 5 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 6 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 6 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 6 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 6 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 7 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 7 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 7 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 7 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 8 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 8 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 8 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 8 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 9 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 9 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 9 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 9 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 10 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 10 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 10 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 10 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 11 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 11 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 11 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 11 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 12 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 12 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 12 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 12 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 13 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 13 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 13 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 13 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Totals 1 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 2 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 3 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 4 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 5 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 6 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 7 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 8 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 9 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 10 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 11 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 12 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 13 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Weights: 1 0.91 0.82 0.73 0.64 0.55 0.45 0.36 0.27 0.18 0.09 Weights2: 1 0.83 0.67 0.5 0.33 0.17 1.25 0.92 0.83 0.75 0.67 0.58 i Weights * counts 1 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 2 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 3 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 4 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 5 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 6 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 7 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 8 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 9 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 10 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 11 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 12 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 13 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? |
10-29-2011, 12:38 PM | #22 |
FFR Player
Join Date: Dec 2006
Posts: 107
|
Re: iironiic's little experiment
Um, are you opening it on google docs? Google docs doesn't have the function I need . (I was going to upload it in googledocs, but it doesn't recognize the function COUNTIFS)
I'll try your level ranks and see what happens, iironiic. Edit: I know what I messed up on. It works fine for 12, but since you're 11, I messed up a couple entries... I'll repost. I didn't notice because I didn't have any 10, or 11 AAA's. Edit 2: Is a value of 11.523 right for you? (iironiic) Edit 3: Dossar, I think you need to use at least Excel 2007. Excel 2003 doesn't support the function... (nor does google docs). Last edited by Enginuity; 10-29-2011 at 03:20 PM.. |
10-29-2011, 12:46 PM | #23 |
Batch Manager
Game Manager, Song Release Coordinator
Join Date: Mar 2008
Location: USA
Age: 29
Posts: 14,867
|
Re: iironiic's little experiment
I opened it up with OpenOffice (even though I said Excel because I can't tell the difference)
I'm assuming OpenOffice is missing the function then? If that is missing it and Google Docs, do you think there is another function that could work or is just that the only one you could think of |
10-29-2011, 12:49 PM | #24 | |
D6 FFR Legacy Player
Join Date: Jan 2009
Age: 33
Posts: 4,342
|
Re: iironiic's little experiment
Quote:
I'll try your program though just to see if I'm doing it right. |
|
10-29-2011, 12:50 PM | #25 |
FFR Player
Join Date: Dec 2006
Posts: 107
|
Re: iironiic's little experiment
There are various sources (from googling, mainly using SUMPRODUCT instead) that have workarounds for Excel 2003 (which I assume is more compatible with openoffice/googledocs. I'll see if I can get something up on google docs in a few hours...
I should probably get some schoolwork done instead of working on this :P. @iironiic: Sorry, I was dumb and did not fix all of the cells. Hm, somethings weird with the way I'm counting AAA's... hold on. Edit 2: I know why. For some reason, your Distorted God score says 1410 averages instead of 1410 perfects... Last edited by Enginuity; 10-29-2011 at 12:58 PM.. |
10-29-2011, 01:00 PM | #26 | |
D6 FFR Legacy Player
Join Date: Jan 2009
Age: 33
Posts: 4,342
|
Re: iironiic's little experiment
Quote:
|
|
10-29-2011, 01:04 PM | #27 |
FFR Player
Join Date: Dec 2006
Posts: 107
|
Re: iironiic's little experiment
Alright, I'll check rank 1 for AAA as well as no g and no boo's.
I do agree with your score now though. Silly mistakes . Last edited by Enginuity; 10-29-2011 at 01:11 PM.. |
10-29-2011, 01:09 PM | #28 |
D6 FFR Legacy Player
Join Date: Jan 2009
Age: 33
Posts: 4,342
|
Re: iironiic's little experiment
|
10-29-2011, 01:12 PM | #29 |
lol happy
Join Date: Oct 2005
Location: DESTINY
Age: 33
Posts: 12,193
|
Re: iironiic's little experiment
Damn I called that shit like a pr0.
As much as FFR and TS pretend to hate each other, you should talk to Patashu to see how he implemented his algorithm. As far as I can tell they work similarly.
__________________
|
10-29-2011, 01:12 PM | #30 |
FFR Player
Join Date: Dec 2006
Posts: 107
|
Re: iironiic's little experiment
It's not going to work if they have unrecorded scores anywhere except for an unrecorded AAA. I guess you can manually edit the cells (but you'd need to figure out what I'm doing; didn't document it very much).
The attachment is in my previous post (I edited). Hopefully it works properly, let me know if anything isn't working. |
10-29-2011, 01:20 PM | #31 | ||
D6 FFR Legacy Player
Join Date: Jan 2009
Age: 33
Posts: 4,342
|
Re: iironiic's little experiment
Quote:
Quote:
EDIT: Something to think about. What about new songs? How are you going to implement this in your program? Last edited by iironiic; 10-29-2011 at 01:22 PM.. |
||
10-29-2011, 01:23 PM | #32 |
FFR Player
Join Date: Dec 2006
Posts: 107
|
Re: iironiic's little experiment
um, the thing will work fine for another few months. I made it check cells 2:1000, so the moment ffr has more than 999 songs it'll not work; would be an easy fix though.
dammit, I don't know why I find this interesting/entertaining. (I mean, i know why; i'm a statistics phd student; which means though that I probably should be doing other stuff). I could pretty easily (not using excel) calculate scores for arbitrarily many people; assuming ffr site admins let me gather data from the site from level rank pages... Oh, I didn't realize you meant you could fix it easily by just fixing the stuff in the level ranks. That's better than what I had in mind (editing the cells in to the right, where computation is done, is a bad idea). Last edited by Enginuity; 10-29-2011 at 01:29 PM.. |
10-29-2011, 01:24 PM | #33 |
FFR Player
|
Re: iironiic's little experiment
So when are you going to scale down to VCs? :3
|
10-29-2011, 01:28 PM | #34 | |
D6 FFR Legacy Player
Join Date: Jan 2009
Age: 33
Posts: 4,342
|
Re: iironiic's little experiment
Quote:
I already did haha. I made a general formula for everything lower than a FGO. Plug p = VC and p+1 = FMO. |
|
10-29-2011, 01:39 PM | #35 |
FFR Player
Join Date: Dec 2006
Posts: 107
|
Re: iironiic's little experiment
Just let me know if there's anything you may want to change (ie, any editing of the formula or whatever), and I could edit the excel file (or feel free to do it yourself)... Also I edited my previous post after you had posted, don't know if you've read it.
|
10-29-2011, 01:41 PM | #36 |
Rhythm game specialist.
|
Re: iironiic's little experiment
it's beautiful.
:') I'm so happy that iironiic did this. I couldn't have even come close to deriving a formula like this. |
10-29-2011, 01:44 PM | #37 | |
D6 FFR Legacy Player
Join Date: Jan 2009
Age: 33
Posts: 4,342
|
Re: iironiic's little experiment
Quote:
And yeah, I read that edit . Hopefully that'll save you some time haha! |
|
10-29-2011, 01:52 PM | #38 |
good hot
Join Date: Sep 2007
Location: North Carolina
Age: 29
Posts: 5,309
|
Re: iironiic's little experiment
"azn pocket calculator to da rescue"
awesome job wilson, i support this idea completely
__________________
|
10-29-2011, 02:02 PM | #39 |
This Is How We Do It~
|
Re: iironiic's little experiment
guess its time to work out my power level
I mean skill level *cough* EDIT: After I posted my ranks, I got confused, where would my rating be on the spreadsheet
__________________
Best AAA's: NAINAI69, Eradication, Since 1983 Best Non AAA's: Gunkienen Tarusuigin, (1-0-1-1), Pandora (6-0-1-0) Rotary Slicers MISSFLAG Waiting for 2 Million members... 5th Place: 7th Official Tournament D5 Last edited by bob bob; 10-29-2011 at 02:10 PM.. |
10-29-2011, 02:14 PM | #40 |
FFR Player
Join Date: Dec 2006
Posts: 107
|
Re: iironiic's little experiment
If you scroll to the right (cells AC101 to AC115 or so), there should be some cells highlighted in green. The rating itself would be the lowest value that doesn't say NOT ENOUGH AAA's, but the score (between 1 and 14) would be the number directly to the left of it.
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|