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
Lol.
A. B.
Super Mario 64
Super Mario 64!
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
Quote from: Zeila on March 13, 2016, 03:28:32 PMIs 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.
Quote from: Zeila on March 13, 2016, 03:28:32 PMIf 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.
A. Sanic XDXD
B. Dang! How long did this take? I commend you for this!
Quote from: E. Gadd Industries on March 13, 2016, 04:08:54 PMDang! 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.
Quote from: E. Gadd Industries on March 13, 2016, 04:08:54 PMSanic XDXD
Gotta go fast.
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.
Data table has been updated to include every series represented on the sidebar. Please take a look to see if I've missed anything!
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!
well I don't know what I was expecting but it wasn't a surprise
I'm on my phone so it finished loading while I was scrolling around the stats. Actually scared me gg
I just realized the title of this topic means NinSheetMusic Sheet Music Data Table
not redundant enough
Quote from: Latios212 on April 01, 2016, 12:48:04 PMI 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
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
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.
And, I've updated the table for today's update! And miraculously, I'm not off by anything!
Table updated. Not much else to say.
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?
LOL this is just me being nerdy and nit-picky, but under "# of games represented" for Star Fox, it should 5 :P
Quote from: DS on June 09, 2016, 07:01:45 AMLOL 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.
Quote from: Onionleaf on June 09, 2016, 04:55:05 AMIf 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."
Quote from: Onionleaf on June 09, 2016, 04:55:05 AMI'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.
Quote from: Yug_Guy on June 09, 2016, 04:21:52 PMYeah, 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?
Quote from: Altissimo on June 09, 2016, 04:24:09 PM"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.
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.
Why the heck are the highest red & lowest green?
oh gosh like they did in pokemon with natures
RED MEANS BAD OK GUYS
Quote from: E. Gadd Industries on June 26, 2016, 04:51:26 PMWhy the heck are the highest red & lowest green?
Because why not?
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
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!
Well, it's been a while. In addition to keeping up with regular updates, I've also done a few new things:
- Games are now listed in alphabetical order instead of by release date. (Which saves me a huge headache)
- Each game now includes a "%age of total section": as you might guess, it's the percent each game takes up in it's particular section.
- All text is now centered
- The layout of the "All Series" table was tweaked slightly
And, that's about it.
Resident sorter guy. Imo the data table should be somewhere on the main site (if it already isn't anyway)
Quote from: NocturneOfShadow on November 01, 2016, 07:25:20 PMImo 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.
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.
Quote from: Yug_Guy on December 14, 2016, 03:31:20 PMThe total is off by 3 somehow, and that annoys me more than it probably should.
Clearly, you missed three french hens.
oh no
quick, we need to start a new project with more than 110 tracks
NO
egg
Quote from: blueflower999 on December 14, 2016, 04:07:34 PMegg
I SWEAR TO GOD THAT IF I SEE THIS ONE MORE TIME I WILL BAN WHOEVER SAYS IT
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
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...
So uh... it's been a while, hasn't it?
I guess, I'm posting to remind folks that this is still a thing.
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~
Quote from: Yug_Guy on October 21, 2018, 05:53:29 PMWell, I've been keeping it up-to-date, whether people want me to or not.
The hero we all need.
This is cool! Thanks for taking the time to keep these sorts of things going. <3
Donkey Kong 64 is 64% of the DK section
10/10
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.
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...
420*10 blaze it! How fitting for an update based around food...
Just letting you guys know that the new Monster Hunter section has been added to the Data Table. Otherwise, everything should be up to date.
Quote from: mastersuperfan on March 01, 2020, 03:16:24 PMI don't think that's how math works
What're ya talkin' about?