NinSheetMusic Forums

Other => Off-Topic => Topic started by: Yug_Guy on March 13, 2016, 09:56:27 PM

Title: NSM Sheet Music Data Table
Post by: Yug_Guy on March 13, 2016, 09:56:27 PM
I figure I may as well make a separate topic for this:

I have made a table detailing how many songs there are for all the series represented via sidebar on NSM. The initial thought behind it was to figure out which game series were justified in having their own categories, and which ones weren't. Though, now it's really a matter of being able to see at a glance how many sheets any given game or series has on NSM. Here's a link to the table:

NSM Sheet Music Data Table (https://docs.google.com/spreadsheets/d/18drTM_WAsaG-PrPDekxojkirCex4026tMDe5TW-Amtk/edit?usp=sharing)

I have a table for all the series represented, and tables for each individual series & their games.

For the All Series table, column A details the game series, column B details how many games are represented in that series, and column C details the total number of sheets represented in that series. Column D is simply column C divided by column B, giving the average number of sheets per game, and Column E is the median. For columns G and H, they contain the highest and lowest number of sheets for any given game in a series. For example, Ace Attorney's highest number is 13, because Phoenix Wright: Ace Attorney has 13 total sheets, the highest number for a game in the Ace Attorney category.

For the other tables, the data that's included is the name of the game (alphabetical order), how many sheets that game has on site, and what percentage each game represents within it's given section. The total number of sheets for a given series is located at the bottom of each table, as well as the game(s) with the highest, lowest & median number of sheets for that section.

If you guys have any suggestions for different things to add to this list, please feel free to let me know. Ideally, I'd like for this table to be useful for as many people as possible, so we can have raw data for decision making, or anything else.

Yeah, that's it. I hope I didn't confuse anybody with these long explanations. I really tried to make them as simple and easy to understand as possible. idk, I really just like putting things in tables
Title: Re: NSM Sheet Music Data Table
Post by: cashwarrior1 on March 13, 2016, 10:43:08 PM
Lol.
        A.               B.
Super Mario        64

Super Mario 64!
Title: Re: NSM Sheet Music Data Table
Post by: Zeila on March 13, 2016, 11:28:32 PM
Is there a reason why you didn't fill out columns E and F for the "Other" section? Aside from that, it's pretty solid. Maybe you should put the date last updated in Column A right next to "Total Sheets" (row 29). This way, if you miss an update, then people will at least know how accurate (or inaccurate) it is (or they could deduce that by the total number of sheets listed, but it wouldn't take much to put an edit date). If you make a spreadsheet for a specific series (like pokemon), would A just be where each individual game goes, and Columns B/D-F are replaced with stuff like "Number of total songs in OST," or "Percentage of OST completed?"

As far as what constitutes a series, I think Dragon Quest, Harvest Moon, and Metal Gear should be removed from the sidebar. The only series I've noticed that are close to the 15 sheet limit are Hamtaro and Kingdom Hearts, each with 13 total sheets
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on March 13, 2016, 11:43:17 PM
Is there a reason why you didn't fill out columns E and F for the "Other" section?
Mostly because I hadn't yet done the "Other" section yet, and then just kinda forgot once I finished it. Really, most of the songs in the "Other" section have only 1 sheet, so the most/least # of sheets/game isn't really all that helpful at a glance.
If you make a spreadsheet for a specific series (like pokemon), would A just be where each individual game goes, and Columns B/D-F are replaced with stuff like "Number of total songs in OST," or "Percentage of OST completed?"
As of right now, it'll pretty much be exactly like the "Other" table: the name of the game, and how many sheets that game has. As nice as a "percent of OST completed" would be, it can be pretty frustrating trying to find complete OST's for every single game. For now, I'm going to focus on just what NSM has, and not what it could have in the future.
Title: Re: NSM Sheet Music Data Table
Post by: E. Gadd Industries on March 14, 2016, 12:08:54 AM
A. Sanic XDXD
B. Dang! How long did this take? I commend you for this!
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on March 14, 2016, 02:33:22 AM
Dang! How long did this take? I commend you for this!
~2-3 hours or so. It's not too hard once you've got a rhythm going.
Sanic XDXD
Gotta go fast.
Title: Re: NSM Sheet Music Data Table
Post by: KefkaticFanatic on March 14, 2016, 04:03:22 AM
Having series pages isn't just to put a bunch of sheets on one page, it showcases well-known titles to visitors and reduces the possible clutter of 5 different games in a series lining up one after another each having one or two sheets on the giant "other" page.
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on March 21, 2016, 02:59:46 AM
Data table has been updated to include every series represented on the sidebar. Please take a look to see if I've missed anything!
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on April 01, 2016, 07:14:25 PM
So, in light of the new update today, I've updated the data table! I've tried something new with the way I have the data arranged, so let me know what you guys think of it!
Title: Re: NSM Sheet Music Data Table
Post by: mikey on April 01, 2016, 07:18:42 PM
well I don't know what I was expecting but it wasn't a surprise
Title: Re: NSM Sheet Music Data Table
Post by: Th3Gavst3r on April 01, 2016, 07:42:19 PM
I'm on my phone so it finished loading while I was scrolling around the stats. Actually scared me gg
Title: Re: NSM Sheet Music Data Table
Post by: Latios212 on April 01, 2016, 08:48:04 PM
I just realized the title of this topic means NinSheetMusic Sheet Music Data Table

not redundant enough
Title: Re: NSM Sheet Music Data Table
Post by: Altissimo on April 01, 2016, 11:32:59 PM
I just realized the title of this topic means NinSheetMusic Sheet Music Data Table

not redundant enough

Nintendo Games NSM Sheet Music Data Table Project Post on Nintendo NSM Music Forums
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on April 01, 2016, 11:46:08 PM
Can You Really Call This a NSM Sheet Music Data Table, I Didn't Even Get Anything Out Of It, I Mean It's Just Numbers & Stuff
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on April 02, 2016, 09:36:59 PM
Okay, I went ahead and actually made an update for the table. Most of the changes are simply formatting stuff so I don't have to do as much work next time I update this. :P However, I've also changed the highest & lowest sheets sheets/game so that the number of sheets is at the bottom of the column, rather than in parenthesis next to each individual game.

Also, I tried going back and re-counting all of the sheets on site, since I was off by about 4 or so in the last update, aaaaaaaaaaand I'm still off by one sheet. I have no idea how this keeps happening.
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on April 27, 2016, 10:24:24 PM
And, I've updated the table for today's update! And miraculously, I'm not off by anything!
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on June 09, 2016, 03:57:37 AM
Table updated. Not much else to say.
Title: Re: NSM Sheet Music Data Table
Post by: Onionleaf on June 09, 2016, 12:55:05 PM
I haven't seen this until now. Woo, this was fun to browse through. (I like seeing stuff organised into Excel sheets!)

My initial thought was how cool it would be if the % of completion would also be included for every listed game soundtrack, but that will be incredibly difficult to compile. But even in this format it could be helpful with deciding on a official/unofficial arrangement project. :)

If you'd like, you can always add a data Filter to your sheets. You can add one in Google Docs by selecting the topmost row (the one with the titles) and go to Data > Filter. That way people won't have to create a temporary filter when they open up the sheet.

I've been wondering about possibly a way for the Other section to look less "bulky", but it's much easier to navigate via the "Sheet Music" page link, so it's not a huge issue. Perhaps some of the games listed in the Other section could one day be included in the sidebar, if enough sheets will be uploaded for them?
Title: Re: NSM Sheet Music Data Table
Post by: DS on June 09, 2016, 03:01:45 PM
LOL this is just me being nerdy and nit-picky, but under "# of games represented" for Star Fox, it should 5 :P
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on June 10, 2016, 12:21:52 AM
LOL this is just me being nerdy and nit-picky, but under "# of games represented" for Star Fox, it should 5 :P
Completely slipped my mind. It should be fixed now.

If you'd like, you can always add a data Filter to your sheets. You can add one in Google Docs by selecting the topmost row (the one with the titles) and go to Data > Filter. That way people won't have to create a temporary filter when they open up the sheet.
I think the table is fairly nice the way it is now, it's fairly easy to navigate through for the most part. And honestly, I don't know where I'd start with the Data Filter. For right now I'll leave it as "filter at your own pleasure."

I've been wondering about possibly a way for the Other section to look less "bulky", but it's much easier to navigate via the "Sheet Music" page link, so it's not a huge issue.
Yeah, the "Other" section bothers me this way too. Unfortunately, there's no real way to get around the issue, since you can only fit so many games on a page at once.
Title: Re: NSM Sheet Music Data Table
Post by: Altissimo on June 10, 2016, 12:24:09 AM
Yeah, the "Other" section bothers me this way too. Unfortunately, there's no real way to get around the issue, since you can only fit so many games on a page at once.

"Other Games: A-M" and "Other Games: N-Z" or something mayhaps?
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on June 10, 2016, 12:53:24 AM
"Other Games: A-M" and "Other Games: N-Z" or something mayhaps?
If I did something like this, it'd probably be something like "Other Games: Pre-2000" and "Other Games: Post-2000", since I have them ordered by date & not alphabetically.
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on June 26, 2016, 11:56:23 PM
I've updated the table for today's update. I've also fixed a few things I forgot about for the "All Series" table; it should now be up to date.
Title: Re: NSM Sheet Music Data Table
Post by: E. Gadd Industries on June 27, 2016, 12:51:26 AM
Why the heck are the highest red & lowest green?
Title: Re: NSM Sheet Music Data Table
Post by: mikey on June 27, 2016, 12:53:18 AM
oh gosh like they did in pokemon with natures
RED MEANS BAD OK GUYS
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on June 27, 2016, 01:31:52 AM
Why the heck are the highest red & lowest green?
Because why not?
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on August 03, 2016, 03:19:37 AM
So, I've decided that I'm only gonna bump this thread after a couple of updates instead of after every single update, since I'm sure it would probably get old after some time. In the time since I last bumped this thread, I've been keeping the table up to date with all of NSM's updates, including today's G/S/C update. Otherwise, not much else has changed, other than one or two minor tweaks.
Also, for whatever reason my total is off by one and I seriously cannot figure out where the inconsistency is and it is driving me up the wall
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on August 13, 2016, 10:09:05 PM
Okay, I know I said I wouldn't bump this thread after every update, but I forgot to mention last time that Pokemon Gold & Silver beat out Animal Crossing: New Leaf for the largest number of sheets for any single game on site: 86.

...at least, until today's update. Today's update gave that title to another game: Donkey Kong 64, with a whopping 109 sheets. This is also noteworthy for being the first time (at least to my knowledge) that a single game on site has reached over 100 individual sheets. So congrats to WaluigiTime64 and the rest of the DK Crew, you've officially set a new record!
Also, I'm not off by one for the total # of sheets on site, yay!
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on November 02, 2016, 03:03:11 AM
Well, it's been a while. In addition to keeping up with regular updates, I've also done a few new things:
And, that's about it.
Title: Re: NSM Sheet Music Data Table
Post by: mikey on November 02, 2016, 03:25:20 AM
Resident sorter guy.  Imo the data table should be somewhere on the main site (if it already isn't anyway)
Title: Re: NSM Sheet Music Data Table
Post by: Sebastian on November 02, 2016, 03:26:12 AM
Imo the data table should be somewhere on the main site (if it already isn't anyway)
YES, PLEASE^

Please, Deku? : )

In all seriousness, I know you're busy. I'm sure this would be lower on the to-do list.
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on December 15, 2016, 12:31:20 AM
I'm here to announce that the title of "Most sheets for a single game" has now gone to a new game, Undertale! This newest update brings Undertale's total to 110 sheets, around 25 more then the previous title-holder, Pokemon Gold & Silver with 86.

Otherwise, all I've been doing is regular maintenance & updating. The total is off by 3 somehow, and that annoys me more than it probably should.
Title: Re: NSM Sheet Music Data Table
Post by: Dudeman on December 15, 2016, 12:33:36 AM
The total is off by 3 somehow, and that annoys me more than it probably should.
Clearly, you missed three french hens.
Title: Re: NSM Sheet Music Data Table
Post by: mikey on December 15, 2016, 12:44:44 AM
oh no
quick, we need to start a new project with more than 110 tracks
Title: Re: NSM Sheet Music Data Table
Post by: Maelstrom on December 15, 2016, 01:06:58 AM
NO
Title: Re: NSM Sheet Music Data Table
Post by: blueflower999 on December 15, 2016, 01:07:34 AM
egg
Title: Re: NSM Sheet Music Data Table
Post by: Dudeman on December 15, 2016, 01:13:25 AM
egg
I SWEAR TO GOD THAT IF I SEE THIS ONE MORE TIME I WILL BAN WHOEVER SAYS IT
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on July 30, 2017, 05:17:25 AM
So, this is still a thing, right?

Sorry for the necrobump, but it's for a major announcement: DK64 now has the most sheets for any game on site, with a whopping 112 sheets! DK64 has beaten out the previous record-holder Undertale, which had 110 sheets.

There's probably some other notable things that have happened with the table since I lasted posted in this topic, but I don't feel like compiling them here. So go search for them yourself :P
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on September 02, 2017, 07:19:08 PM
Posting to comment that the "Other" section now has over 700 sheets!

...oh and I guess the Pokemon section is over 500 sheets now, but I think that happened during the last update, so...
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on February 11, 2018, 11:23:03 PM
So uh... it's been a while, hasn't it?

I guess, I'm posting to remind folks that this is still a thing.
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on October 22, 2018, 01:53:29 AM
Remember this? Yeah, I don't think many people do.

Well, I've been keeping it up-to-date, whether people want me to or not. I just wanted to pop in & say that I've added a Median stat to all of the series. It should hopefully shed some new light onto the data I've been collecting.

Anyway, that's all. Peace~
Title: Re: NSM Sheet Music Data Table
Post by: BlackDragonSlayer on October 22, 2018, 05:27:31 AM
Well, I've been keeping it up-to-date, whether people want me to or not.
The hero we all need.
Title: Re: NSM Sheet Music Data Table
Post by: Libera on October 22, 2018, 01:03:43 PM
This is cool!  Thanks for taking the time to keep these sorts of things going. <3
Title: Re: NSM Sheet Music Data Table
Post by: Maelstrom on October 22, 2018, 02:33:09 PM
Donkey Kong 64 is 64% of the DK section

10/10
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on April 11, 2019, 07:24:24 AM
As expected, I've updated the table with the new series on the sidebar (thanks, Deku!). I suppose this means the table has fulfilled its original purpose?     

...whatever, I'll probably keep updating it no matter what.

Nothing much to say about the data itself, other than Undertale massively skewing a bunch of the data. At least I know who to blame for that.

I'll probably update the Audit when it's not 1 in the morning like it currently is for me rn. Until then, stay funky.   
Title: Re: NSM Sheet Music Data Table
Post by: Yug_Guy on August 06, 2019, 04:37:18 AM
Well, you did it guys. You fanboyed/girled/non-binaryed so hard on Octopath that it now has the most sheets out of any game in the "Other" section. And, I get the sneaking suspicion that that's not gonna slow down anytime soon...