New Skill Analysis Metric (Trial Phase)

[M0nkeyz]

and me

[xXOpkillerXx]

me pwease~ ^^

[xAlphaWolf]

mee

[___________]

Me~

[YoshL]

yo

[MinaciousGrace]

do me do me

[PhantomPuppy]

yes, i have to see this. plis do mine

[Ksl33zy24]

I can't wait for the hiking phase.

[Untimely Friction]

Im pretty sure I would definitely have the most bizzare zenith curve

[Callipygian]

zenith is not at his zenith yet, so I predict his zenith curve will change. I am not even zen yet, so I have low expectations for my zenith curve, but by all means, run the numbers if you have enough time!

[TheSaxRunner05]

Can you make the tool where we can just imput the link to our level ranks, hit enter, and then it churns out our own graph?

[Trumpet63]

Originally Posted by TheSaxRunner05

Can you make the tool where we can just imput the link to our level ranks, hit enter, and then it churns out our own graph?

I would so dearly love for this to be the case, but alas, I have not the programming prowess to put that together, as I said in the OP. I just got back from school, so maybe after I've solidified the work here, someone will be interested in helping me with something like that.

Note: I'll start just updating the OP with changes in formula, and any thoughts I have about the changes.

[_Zenith_]

After seeing Sorie's Zenith Score, if you happen to do anyone in D7 with 90+% of all songs AAA'd, the curve would be straight until the very end, even if so, such a tiny fluctuation between the 90 scores which is kind of neat

Realistically, having more AAA's will boost your Zenith Curve up to an extent, where the person's highest difficulty drops off depending on how high that is. Such a cool feature to have though. #SenseOfAchievement

[Silvuh]

zenith-score.xlsx

If you have Excel, you can use this. Go to your level ranks page and copy the whole table, including the column titles (in Firefox, it's some kind of Ctrl+Shift with clicking and dragging from just outside the table). Paste it into A1 of Sheet1, go into Sheet2, and all the results will be there.

There are more levels of difficulty 64 than any other (49 of them), so that's one problem with the non-scaled score. I can update my sheet with any changes made to the formula.

And for my Level Ranks, it's
Non-scaled: Z-Score: 68.34; Best Diff: 64
Scaled: Z-Score: 70.22; Best Diff: 62

[Kanzas]

ME

[Trumpet63]

Originally Posted by Silvuh

zenith-score.xlsx

If you have Excel, you can use this. Go to your level ranks page and copy the whole table, including the column titles (in Firefox, it's some kind of Ctrl+Shift with clicking and dragging from just outside the table). Paste it into A1 of Sheet1, go into Sheet2, and all the results will be there.

There are more levels of difficulty 64 than any other (49 of them), so that's one problem with the non-scaled score. I can update my sheet with any changes made to the formula.

And for my Level Ranks, it's
Non-scaled: Z-Score: 68.34; Best Diff: 64
Scaled: Z-Score: 70.22; Best Diff: 62

<3 <3 <3 <3
I Approve, thank you so much for optimizing the Excel work for me. I hope everyone knows: I didn't post a dl link for my Excel file because it really wouldn't have been usable by anyone else. I'm still posting the stuff for everyone that asked.

@Silvuh I hope my explanation in the OP was sufficient in helping you put this together. You've just signed yourself up as the Senior Excel Formula Updater. I'd better put your link in the OP.

[Trumpet63]

Second batch of scores and graphs, feel free to comment.


Z-Score = 68.72
Z-Score Scaled = 68.98


Z-Score = 56.00
Z-Score Scaled = 62.02


Z-Score = 68.80
Z-Score Scaled = 84.00


Z-Score = 74.50
Z-Score Scaled = 90.70


Z-Score = 61.13
Z-Score Scaled = 76.13


Z-Score = 64.53
Z-Score Scaled = 64.64


Z-Score = 39.96
Z-Score Scaled = 57.00

[yo man im awesome]

sure, throw me in there

[Silvuh]

Rawr, haappy to help~ And, yeah, it was kind of funny that with my scaled score, my best difficulty goes down but my score goes up. And it's due to the effect you mentioned: I only have one 80 and one 82 on the chart, 10 goods and a boo on Ketsarku Mozgalom and 12 goods on Blue Rose. My other scores in that range are definitely not comparable.

So rather than divide by the number of files for a difficulty in your sheet, I tried dividing by the total number of files in that difficulty. And this seems to work better; the curve is doesn't fan out so much. (It's equivalent to multiplying the scaled score by the ratio of files you have NGC<20 on, because the count of NGC<20 files cancels out.) My new Z-Score is 67.58 with a best difficulty of 61.

The change on my spreadsheet is pretty simple, and I can update my file if you like the idea.

Sheet2 Column C currently references Sheet1 Column L, which restates the difficulty for played files with a non-negative NGC (new good count). So instead, you can put =IF(B2=0,0,B2/COUNTIF(Sheet1!B:B,"="&A2)) in C2, referring to the complete difficulty list in Column B, and fill that down.


Oh, and the only step in your explanation I got stuck on was Step 2, because it doesn't explicitly say to multiply the Averages, Misses, and Boos by those factors and sum them all up with the number of goods to make a new good count. (And Step 4 still refers to what I'm calling the NGC as the "good count".)

[Poison-]

I'm interested in seeing what it says for me.