10-3-2014, 03:24 AM | #61 |
FFR Wiki Admin
Wiki Administrator
|
Re: New Skill Analysis Metric (Trial Phase)
Why don't you use VLOOKUP in the pass column ? And use the name of the file as a reference ?
Something like : =O12=(VLOOKUP(P12;C:H;3;FALSE))+(VLOOKUP(P12;C:H;4;FALSE))+(VLOOKUP(P12;C:H;5;FALSE))+(VLOOKUP(P12;C:H;6;FALSE)) (P being an additional column for file names)
__________________
Last edited by noname219; 10-3-2014 at 03:27 AM.. |
10-3-2014, 05:10 AM | #62 |
quit
Join Date: Apr 2005
Location: anywhere but here
Posts: 938
|
Re: New Skill Analysis Metric (Trial Phase)
Oh, yeah, haha, whoops. Thanks for the help! I was trying to do something with VLOOKUP earlier but it wasn't doing what I thought it would, but now I see how it's supposed to work. So I tried that in my sheet, and ... it almost completely works, but it doesn't seem to like song names with tildes. But I can change references to the song title to SUBSTITUTE(Q2,"~","~~") where necessary, because it turns out doing that makes song titles that are numbers break. (Didn't think until I came to a snag later that I could have just done an IF to check for tildes, which I have now in column O.)
I have the notecounts ordered by ID now so I can just add new songs onto the end and have everything be in order. Made a second Pass? column with VLOOKUP that's even with the pasted level ranks, so I won't have to figure out how to use COUNTIFS and SUMIFS when the criteria aren't all in the same row. Finally finished with all the VLOOKUP stuff, and I've updated it. Now it can be used without having to worry about sorting the pasted ranks in Excel (which would have only taken like five seconds, anyway, haha.) Last edited by Silvuh; 10-3-2014 at 05:15 AM.. |
10-3-2014, 10:09 AM | #63 |
Washed and Irrelevant D7
Join Date: May 2012
Age: 27
Posts: 1,804
|
Re: New Skill Analysis Metric (Trial Phase)
oh crap what, my graph says i should be in D4 D: damn, i dont think im ready for that.
|
10-3-2014, 10:32 AM | #64 |
FFR Player
Join Date: May 2009
Location: Cibinong, Indonesia
Posts: 17
|
Re: New Skill Analysis Metric (Trial Phase)
Interesting! I want to see for mine. Can you make it for me? I'm curious about graphic and zenith score. I just want to know why I was in D3.
__________________
Sorry if my spelling and grammar is bad. Because I'm Indonesia. 10/(09-10)/2010 +7 GMT - FFR is Back |
10-3-2014, 11:06 AM | #65 | |
Mostly Ignored
Skill Rating Designer
Join Date: Mar 2011
Posts: 471
|
Re: New Skill Analysis Metric (Trial Phase)
Quote:
Z-Score = 52.72 Z-Score Scaled = 60.39 The current scale for D4 says a minimum of 55.99 and 62.01 respectively. I haven't updated the OP with that yet though :/ Last edited by Trumpet63; 10-7-2014 at 12:50 AM.. |
|
10-3-2014, 11:17 AM | #66 |
Washed and Irrelevant D7
Join Date: May 2012
Age: 27
Posts: 1,804
|
Re: New Skill Analysis Metric (Trial Phase)
oooooh ok lol. i just looked at the front page xD that scared me.
|
10-3-2014, 11:29 AM | #67 |
The Dominator
Join Date: Sep 2005
Location: North Bay, ON
Age: 35
Posts: 8,987
|
Re: New Skill Analysis Metric (Trial Phase)
Requesting a curve in the name of science!
|
10-3-2014, 09:46 PM | #68 |
Mostly Ignored
Skill Rating Designer
Join Date: Mar 2011
Posts: 471
|
Re: New Skill Analysis Metric (Trial Phase)
Z-Score = 68.43 Z-Score Scaled = 73.40 Z-Score = 74.27 Z-Score Scaled = 94.30 |
10-4-2014, 12:38 AM | #69 |
I'm okay I guess
|
Re: New Skill Analysis Metric (Trial Phase)
You might want to do mine for me because I did it using LibreOffice Calc which is like a really shitty version of Microsoft Excel.
EDIT: Did it in Google Docs and got the same score. Are the song levels supposed to not match up with each other though? Like on the levels sheet I have: Excite Bike listed as the first level on the left but then on the right I have Terror From Beyond. Last edited by sweet2kill210; 10-4-2014 at 12:49 AM.. |
10-6-2014, 08:20 PM | #70 | |
Mostly Ignored
Skill Rating Designer
Join Date: Mar 2011
Posts: 471
|
Re: New Skill Analysis Metric (Trial Phase)
Quote:
Yes, it IS perfectly normal that the first song you saw in column P was "Terror from Beyond". The way the spreadsheet works requires that there be a list of all the public songs, with which it will correctly match the song names up with the note counts for each song. UPDATE for you and anyone revisiting the thread, you can check the OP under the "News and Progress" spoiler to see what we've been doing. Last edited by Trumpet63; 10-6-2014 at 08:23 PM.. |
|
10-6-2014, 08:27 PM | #71 |
D7 Elite Keymasher
|
Re: New Skill Analysis Metric (Trial Phase)
I'm curious as to what mine would be since i only play higher difficulty things..
Would be great if you could do this for me |
10-6-2014, 09:17 PM | #72 |
I'm okay I guess
|
Re: New Skill Analysis Metric (Trial Phase)
hmmm, what if you're someone that actively goes for AAAs? I mean my Zenith score seems accurate and I doubt it makes much of a difference, but I wonder if it would be lower if I hadn't purposefully AAAed any song 59 or under (I have almost all of them because I actively tried for them).
|
10-6-2014, 09:20 PM | #73 |
Mostly Ignored
Skill Rating Designer
Join Date: Mar 2011
Posts: 471
|
Re: New Skill Analysis Metric (Trial Phase)
Z-Score = 75.15 Z-Score Scaled = 77.18 You've been added to the google doc. Last edited by Trumpet63; 10-6-2014 at 09:21 PM.. |
10-6-2014, 09:44 PM | #74 |
D7 Elite Keymasher
|
Re: New Skill Analysis Metric (Trial Phase)
Thanks mate.
|
10-6-2014, 09:45 PM | #75 |
⠀
Join Date: Dec 2010
Location: Singapore, SG
Age: 26
Posts: 6,858
|
Re: New Skill Analysis Metric (Trial Phase)
Sure, I'm curious to see mine.
|
10-6-2014, 09:45 PM | #76 | |
Mostly Ignored
Skill Rating Designer
Join Date: Mar 2011
Posts: 471
|
Re: New Skill Analysis Metric (Trial Phase)
Quote:
Thank you for bringing that up |
|
10-6-2014, 09:59 PM | #77 |
Mostly Ignored
Skill Rating Designer
Join Date: Mar 2011
Posts: 471
|
Re: New Skill Analysis Metric (Trial Phase)
Z-Score = 78.49 Z-Score Scaled = 91.14 |
10-7-2014, 12:45 AM | #78 |
Banned
Join Date: Nov 2013
Posts: 8,563
|
Re: New Skill Analysis Metric (Trial Phase)
that graph is what I get for getting bf's on 12s and AAAing 80s
|
10-7-2014, 07:30 AM | #79 |
<3 Jumpstream <3
|
Re: New Skill Analysis Metric (Trial Phase)
I'm curious about mine as well if you don't mind
|
10-7-2014, 08:45 AM | #80 |
Mostly Ignored
Skill Rating Designer
Join Date: Mar 2011
Posts: 471
|
Re: New Skill Analysis Metric (Trial Phase)
I'm not sure how serious you are, but as much as I'd like to say you're right, I don't know what everyone's scores in D6 are. Soon though, soon maybe everyone could use their Zenith Score to lawyer for a division placement.
__________________
2014 October 7th 1:03 AM Zageron: Trumpet Trumpet63: yes, im here Zageron: You have a problem. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|