New Skill Analysis Metric (Trial Phase)

[noname219]

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)

[Silvuh]

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.)

[PhantomPuppy]

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.

[DSMLMD]

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.

[Trumpet63]

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.

Are you sure? On the table I see for you:
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 :/

[PhantomPuppy]

Re: New Skill Analysis Metric (Trial Phase)

Are you sure? On the table I see for you:
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 :/

oooooh ok lol. i just looked at the front page xD that scared me.

[Dynam0]

Re: New Skill Analysis Metric (Trial Phase)

Requesting a curve in the name of science!

[Trumpet63]

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

[sweet2kill210]

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.

[Trumpet63]

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.

Yo! Sorry this took so long, I was away for the weekend. I ran your stats and from what you told me in the PM, evidently it worked fine.

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.

[Tarrik]

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

[sweet2kill210]

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).

[Trumpet63]

Re: New Skill Analysis Metric (Trial Phase)


Z-Score = 75.15
Z-Score Scaled = 77.18

You've been added to the google doc.

[Tarrik]

Re: New Skill Analysis Metric (Trial Phase)

Thanks mate.

[EzExZeRo7497]

Re: New Skill Analysis Metric (Trial Phase)

Sure, I'm curious to see mine.