NSM Forums

Please login or register.

Login with username, password and session length
Advanced search  

News:

Spotted an error on the main site? Let us know!

Author Topic: NSM Submissions Statistics  (Read 421 times)

Onionleaf

  • Birdo's Ballet
  • ************
  • Gender: Female
  • Posts: 360
  • Flutter~ish
    • View Profile
NSM Submissions Statistics
« on: January 14, 2017, 07:47:28 AM »

Hiya! I wanted to share the result of something that came to mind recently. I thought it would be interesting to see what the trends for NSM updates have been throughout the years. Apologies if this has been done before or if there's already a neater way of doing this, but I basically set up an Excel data table for preparing some statistics for NSM uploaded submissions.

I hope viewing these will be a motivational experience for you. ;)

Here's the original Excel file with all the data and Pivot Charts all set up if you'd like to get more out of the info: [Link]
(Let me know if I made the whole thing too difficult to decipher, I'll do my best to improve it!)

=============

The charts below show the total submissions uploaded to the site per month, categorised into new sheets (blue) and replacements (red). I've also included two key dates, labelled by green vertical lines, which help understand the data a bit better.

Chart for All Data
[close]

This second chart removes all special projects or featured arranger updates, showing only the normal, regular updates.

Chart for Regular Updates Only
[close]

Finally, this third chart shows the total arrangements for each month. There's an obvious seasonal trend to be seen!

Totals by Month
[close]

All-in-all, I'd say the figures show that we can expect a positive trend in years to come. And if we include the factor that the quality of uploaded sheets is only improving, then we surely have nothing to worry about.

============

If you have any other ideas for NSM Stats, feel free to share them. I like working with statistics and Excel worksheets, and am happy to work on any other crazy ideas. ^^
Logged
It's your friendly, neighbourhood Onionleaf! (Almost as friendly as Zeta!)

Click me for sheets!

E. Gadd Industries

  • Nintendo Nocturne
  • ********************************
  • Gender: Male
  • Posts: 2571
  • Two words: PACHINKO PAIN
    • View Profile
Re: NSM Submissions Statistics
« Reply #1 on: January 14, 2017, 01:38:08 PM »

Well this is an interesting project!
Logged
The entrance to my lab is hidden... somewhere...
Spoiler

[close]

Tobbeh99

  • Nintendo Nocturne
  • ********************************
  • Gender: Male
  • Posts: 2078
  • The Triforce of Courage!
    • View Profile
    • Youtube
Re: NSM Submissions Statistics
« Reply #2 on: January 14, 2017, 01:39:11 PM »

Well this is an interesting project!

Agrees! :D
Logged
tfw you get schooled in English grammar by a guy whose first language is not English

10/10 tobbeh

Dudeman

  • NSM's Least Active Mod
  • Global Moderator
  • Nintendo Nocturne
  • *
  • Gender: Male
  • Posts: 4130
  • Resident Rip Fanatic
    • View Profile
    • Email
Re: NSM Submissions Statistics
« Reply #3 on: January 14, 2017, 08:36:11 PM »

This is way cool. It takes some determination to dig back in the submission archives, so nice job!
Logged
All Hail Zeila
[close]

Latios212

  • Pokémon Music Curator
  • Updater
  • Nintendo Nocturne
  • *
  • Gender: Male
  • Posts: 3269
  • Wheeeee™
    • View Profile
    • YouTube channel
Re: NSM Submissions Statistics
« Reply #4 on: January 16, 2017, 02:40:55 AM »

I like this a lot. Numbers are cool

Oh, do you have the excel file with the actual numbers in it? I'd like to look haha
« Last Edit: January 16, 2017, 05:27:06 AM by Latios212 »
Logged
My arrangements and YouTube channel!

who needs education when you can have WAIFUS!!!!!

Spoiler
[close]

Onionleaf

  • Birdo's Ballet
  • ************
  • Gender: Female
  • Posts: 360
  • Flutter~ish
    • View Profile
Re: NSM Submissions Statistics
« Reply #5 on: January 18, 2017, 09:09:46 AM »

I like this a lot. Numbers are cool

Super cool. Can't beat the power of statistical analysis. 8)

Quote
Oh, do you have the excel file with the actual numbers in it? I'd like to look haha

Sure do! The link is up in the OP, here you go *reaches up and picks it off the shelf* https://dl.dropboxusercontent.com/u/108749630/Arrangements/NSM%20Stats.xlsx
Enjoy
Logged
It's your friendly, neighbourhood Onionleaf! (Almost as friendly as Zeta!)

Click me for sheets!

Latios212

  • Pokémon Music Curator
  • Updater
  • Nintendo Nocturne
  • *
  • Gender: Male
  • Posts: 3269
  • Wheeeee™
    • View Profile
    • YouTube channel
Re: NSM Submissions Statistics
« Reply #6 on: January 18, 2017, 08:01:11 PM »

oh I can't read xD thanks!
Logged
My arrangements and YouTube channel!

who needs education when you can have WAIFUS!!!!!

Spoiler
[close]

Latios212

  • Pokémon Music Curator
  • Updater
  • Nintendo Nocturne
  • *
  • Gender: Male
  • Posts: 3269
  • Wheeeee™
    • View Profile
    • YouTube channel
Re: NSM Submissions Statistics
« Reply #7 on: January 19, 2017, 07:35:51 AM »

This is been something I've been wondering for a while, but never bothered to count up (so thanks for this ::))

A little over two years ago Deku implemented the new submissions system. About two years ago we had the domain change, so any sheet uploaded since then will both have the new URL on it and be checked for quality through the strict updating process; we'll call it up to date. Your chart gives me 1343 replacements or new sheets uploaded in the past year, which is over 40% of the site! That may not seem like a lot, but consider just two years ago a flat 0% of the sheets were up to date, and that comprises everything from 2004 to 2014. Only 3/5 of the sheets we have today are fro mbefore 2015.

So if >40% of our site is up to date, good with formatting and accuracy, where does the other <60% stand? That's a little hard to tell because the good pre-2015 sheets are mixed in with all the horrendous ones. Well, some pre-2015 sheets have been updated with the new URL (some Animal Crossing, Metroid, Zelda games...) and wouldn't still be up there in that condition if they weren't good as well. So probably close to half our sheets have the new URL, that's cool. URL aside, though, I'm confident that a sizeable portion of them are good. The updating process was far from awful pre-2015, and besides a select few good arrangers comprise a large chunk of the site. So I'd conclude that the majority of the sheets we host are presentable! (That's saying a lot, considering what some sections used to look like when I joined).

It is my goal to one day get that number up to 100%. There's no end to clearing the abominations on site in near sight (there are sooo many...) but I believe one day we can do it!

<end pep talk>
Logged
My arrangements and YouTube channel!

who needs education when you can have WAIFUS!!!!!

Spoiler
[close]

NocturneOfShadow

  • Nintendo Nocturne
  • ********************************
  • Gender: Male
  • Posts: 9818
  • im mary poppins yall
    • View Profile
    • Email
Re: NSM Submissions Statistics
« Reply #8 on: January 19, 2017, 08:11:23 AM »

My goal is to have every track of every game ever
Logged
what is sithroast

shadowkirby

  • Corneria Concert
  • *****************************
  • Posts: 1878
  • E G G
    • View Profile
Re: NSM Submissions Statistics
« Reply #9 on: January 19, 2017, 09:47:28 AM »

my goal is to get laid, but hey, whatever works
Logged
A L L   H A I L   E G G

AwesomeYears

  • Flashman Funk
  • ************************
  • Gender: Male
  • Posts: 955
  • Call me Kale
    • View Profile
    • Email
Re: NSM Submissions Statistics
« Reply #10 on: January 19, 2017, 12:17:15 PM »

my goal is to get laid

sees profile pic

is egg

Spoiler
[close]
Logged
The second part of Rachimanoff's Prelude in C# Minir is too damn hard and fast.
 

Page created in 0.081 seconds with 22 queries.