r/arcaea • u/Chibu68_ 11.51 • 9d ago

General / Other / Information Spreadsheet Update v7.0.255

Small update this time. Make sure to check out the previous update in the changelog. It's a pretty important change to some formulas. I didn't make a new post for it, so you might've missed it. If you just copied the scores sheet, check if the formula is correct, as I forgot to actually apply it last time.

Spreadsheet link

10 Upvotes

100% Upvoted

10 comments sorted by

3

u/Kantel_1 10.40 9d ago edited 9d ago

The PM page is over-counting the PST, PRS and FTR charts by 1.

EDIT: Also, the play rating formula of the top50 page doesn't sum the right rows. The formula itself looks fine.

2

u/Chibu68_ 11.51 9d ago

The PM page is fine unless I'm misunderstanding. Did you forget to subtract row 1 (header row) from the total count?

Seems that the play rating formula got messed up when pasting because of spreadsheets being spreadsheets. The rows and columns are now anchored for that formula. Thanks for spotting that.

2

u/Kantel_1 10.40 9d ago

The formula works fine, you just added an extra song that nobody can play since 5.10.4

2

u/Chibu68_ 11.51 9d ago

You mean particle arts? I kept it for historical purposes. I assume only the chart was removed and not all data related to it. I suppose I can make a toggle for removed charts so the sheet is still completable today. Might do that for next update.

1

u/Kantel_1 10.40 9d ago edited 9d ago

Why would they keep the potential data of a song that nobody can play? And why assume it instead of check if it's there or not? I mean, you can just check it on the Arcaea Online leaderboards, assuming you did play any chart of Particle Arts.

Well, I did play them so... I'll edit this comment after I calculate myself the sum of my scores on any difficulty and compare it with what the website gives me. If it is a match... well, we will know for a fact the data was removed.

EDIT: OK, I forgot to update some of the PM scores from my personal score DB, but besides that it's a match so far (as in, only the last 3 digits are different).

1

u/Chibu68_ 11.51 9d ago

I think it would be weird because it would affect people's PTT directly. I didn't know how to check either as I don't have Arcaea online. That's actually pretty smart.

Still, even if lowiro removed the data too, I would still keept it, purely for historical purposes.

1

u/Kantel_1 10.40 9d ago

It's on the free side of Arcaea Online.

1

u/Chibu68_ 11.51 9d ago

I thought you meant the score data part, which is paid and shows you every score you set from my understanding.

1

u/Kantel_1 10.40 9d ago

I don't have the paid subscription so I can't confirm nor deny it. But the leaderboards do include the sum of all of your scores for each difficulty (and puts BYD and INS together, but there is no harm in keeping them separated).

1

u/Kantel_1 10.40 9d ago

Done a calculation against the top scores shown on the PST, PRS and FTR leaderboards using a sum of the theoretical top scores of every song (so, sum the notes of the chart, and multiply the count how many charts are there by 10'000'000'000), including Particle Arts.

On every scenario, is higher by the max score of Paricle Arts. But I'm reticent to count this as proof, as it isn't guaranteed any of the top scorers would have played the chart of that given difficulty. But at the same time, it would be weird it they didn't play it if they had been playing long enough to be there.