HOME | DD

Published: 2012-06-03 10:34:57 +0000 UTC; Views: 21864; Favourites: 181; Downloads: 16699
Redirect to original
Description
EqD Article: www.equestriadaily.com/2012/06…Excel sheet download: (see link to seasons 1-3)
Depending on the number of characters present and frequency of shots' changes, analyzing each episode took from less than an hour up to three.
Estimated total time spent: 110 - 150 hours.
Margin of error:
Since the timers of the video players I used show only full seconds, I had to guess how the fractions of seconds were long when added up together.
On average, in each episode there may be a 10 second difference between the real screentime of a character and the screentime I calculated - but since it can be either more or less than reality, given the number of episodes and the fact that all of the characters are prone to this miscalculation, the overall screentime difference will probably be negligable.
Seasons 1-3 analysis: fav.me/d5kzo28
Ponyville's population analysis: fav.me/d4uyijp
Birth, pregnancy, coitus & death statistics: fav.me/d5fd4rz
Related content
Comments: 157
dziadek1990 In reply to ??? [2013-10-01 14:52:25 +0000 UTC]
Sethisto accidentally linked to the seasons 1&2 analysis. The link to the all-three-seasons analysis is in the description.
And AJ was called a background pony because she didn't have many episodes dedicated solely to her. Even when she was on the screen, she didn't do important stuff often. Her spotlight time was comparatively shorter to the rest's.
👍: 0 ⏩: 0
AbyssalEmissary [2013-10-01 11:39:20 +0000 UTC]
The first thing here I saw with more downloads than views. You had one job, dziadek1990. And you did it. Amazing.
👍: 0 ⏩: 1
dziadek1990 In reply to AbyssalEmissary [2013-10-01 14:58:14 +0000 UTC]
Thanks. Please do note the link in the description to the all-three-seasons analysis which features the rest of the episodes. Sethisto accidentally linked everyone to THIS one.
👍: 0 ⏩: 1
AbyssalEmissary In reply to dziadek1990 [2013-10-01 19:31:28 +0000 UTC]
Hehe, thanks for the info, I already read the description and found the link. Maybe you should have included a Trixie graph in the all-three-seasons version.
👍: 0 ⏩: 0
ludechris31 [2013-10-01 04:12:11 +0000 UTC]
Why does pinkie hold the record screen time in an episode? She peaks higher than twilight does.
👍: 0 ⏩: 1
AbyssalEmissary In reply to ludechris31 [2013-10-01 11:37:00 +0000 UTC]
It seems that she had more screen time in "A Friend in Deed" than Twili had in any other episode. Understandable, as she is the only Mane 6 character involved in this story whereas Twilight always had to share the time with others in the other episodes.
👍: 0 ⏩: 1
SketchcreativeLe [2013-10-01 03:47:26 +0000 UTC]
So YES! Twilight Sparkle won for being seen in a longest duration of time.
👍: 0 ⏩: 1
dziadek1990 In reply to SketchcreativeLe [2013-10-01 10:00:18 +0000 UTC]
Somepony should tell Seth that he linked the wrong analysis. This one's includes only seasons 1 and 2. The 1-3 analysis is linked in the description.
👍: 0 ⏩: 0
addy1235 [2013-06-26 07:00:15 +0000 UTC]
Rainbow Dash got third.Not bad for my favorite pony.
👍: 0 ⏩: 0
lood1234 [2013-03-20 23:06:07 +0000 UTC]
I think you got 2x12 and 2x13 or something like that mixed up.
👍: 0 ⏩: 0
garciarael [2012-10-13 08:00:38 +0000 UTC]
: My best pony has the lowest screen time among the rest aside from Spike!
👍: 0 ⏩: 1
dziadek1990 In reply to garciarael [2012-10-13 09:55:12 +0000 UTC]
But look: Fluttershy has merely 30 seconds less of screentime than AJ - that's a little more than half a second per episode. The margin of error of my measurements is bigger. She still COULD have a second-last place amongst Mane 6.
👍: 0 ⏩: 2
MillennialDan In reply to dziadek1990 [2013-02-06 08:47:30 +0000 UTC]
But if you take season three into account, she's way, way behind.
👍: 0 ⏩: 0
garciarael In reply to dziadek1990 [2012-10-13 14:40:23 +0000 UTC]
: Please don't worry him like that.
👍: 0 ⏩: 0
dziadek1990 In reply to BronyBeforePony [2012-10-03 12:48:14 +0000 UTC]
... but in a good way, right?
👍: 0 ⏩: 1
Mynameisnotdavid [2012-09-12 20:15:15 +0000 UTC]
My Little Pony Nerdyness level: ERROR! ERROR! SYSTEM WILL SELF DESTRUCT IN 30 SECONDS. 29... 28... 27...
Seriously though... NICE FREAKING JOB!
You should total be some kinda mathematician... or... something along those lines...
👍: 0 ⏩: 1
dziadek1990 In reply to Mynameisnotdavid [2012-09-12 20:58:41 +0000 UTC]
Thanks, and I am already a math student at an institute... and let's be honest: this graph required mostly patience to make it, because how hard counting seconds is when you compare it to calculus which I am studying?
Making graphs like this for me is easy... though I will have to deal with my laziness towards OTHER things, like writing fan-fics and analyses like the one I made on Ponyville's population - I am a REALLY lazy bum when it comes to stuf like that.
👍: 0 ⏩: 1
Mynameisnotdavid In reply to dziadek1990 [2012-09-12 21:02:33 +0000 UTC]
Your welcome!
Keep doing what you do, " s'gonna gecha far, kiddo".
And remember that you shouldn't be lazy! That wont help you at all!
"Heh heh, look who's talking..."
SHUDDUP CYAN, I DIDN'T TELL YOU TO ADD ANYTHING TO MY MORAL LESSONS!
👍: 0 ⏩: 1
dziadek1990 In reply to Mynameisnotdavid [2012-09-12 21:06:38 +0000 UTC]
Well, sprinkle with me with pasta and call me "gravy".
... whatever that means...
Anyways, I am constantly trying, but my friggin ADHD keeps being my enemy and-- OOH, SHINY! 8-D
👍: 0 ⏩: 1
Mynameisnotdavid In reply to dziadek1990 [2012-09-12 21:14:21 +0000 UTC]
"8-D"
You DO realize what that looks like, right?
👍: 0 ⏩: 3
dziadek1990 In reply to Mynameisnotdavid [2012-09-12 21:19:49 +0000 UTC]
... do you guys think ONLY about dirty things?
👍: 0 ⏩: 1
Mynameisnotdavid In reply to dziadek1990 [2012-09-13 07:21:14 +0000 UTC]
... 'cause "8-D" looks like a happy alien when you turn it on its side!
👍: 0 ⏩: 0
dziadek1990 In reply to Mynameisnotdavid [2012-09-12 21:17:22 +0000 UTC]
Awesome emoticon conversion strikes again...
👍: 0 ⏩: 0
dziadek1990 In reply to Mynameisnotdavid [2012-09-12 21:16:32 +0000 UTC]
Yes, just like 8. Problem?
👍: 0 ⏩: 0
hexamane [2012-07-31 17:50:23 +0000 UTC]
Thank you for this detailed analysis! I put the numbers to use with this little test I made (credits on the results page): [link]
👍: 0 ⏩: 2
dziadek1990 In reply to hexamane [2012-07-31 20:02:45 +0000 UTC]
You silly! You wrote "dziadek990" instead of "dziadek1990" in the credits!
But that's, um... that's not a problem...
👍: 0 ⏩: 1
hexamane In reply to dziadek1990 [2012-07-31 22:38:20 +0000 UTC]
Did I drop the hammer again?
Yes, you dodo! Lucky for you I was there to fix that mess!
Did somepony say mess? Do you want me to make some for you?! Please say yes!!!
👍: 0 ⏩: 1
dziadek1990 In reply to hexamane [2012-08-01 13:34:47 +0000 UTC]
WOOOHOOO! This is going to be the messiest mess of all messiest messes EVER!
... Wait a minute. How can I be here AND there under the blanket at the same time? Am I you or you are me or neither of us are us or both of us are you and me or... or...
...
ARE YOU MY LONG-LOST TWIN SISTER???
👍: 0 ⏩: 0
dziadek1990 In reply to hexamane [2012-07-31 19:34:01 +0000 UTC]
No prob. Doing the analysis was a pleasurable act itself.
Hopefuly I will do more of those soon, because lately I am being FRIGGIN lazy. You have no idea how it is annoying. :\
👍: 0 ⏩: 0
Silentmatten [2012-06-13 23:18:55 +0000 UTC]
Sir... i think you might have a little too much free time but hey, nice job!
👍: 0 ⏩: 0
cgutteridge [2012-06-06 14:13:35 +0000 UTC]
Apologies, my last two links were the wrong way around.
👍: 0 ⏩: 0
cgutteridge [2012-06-06 14:12:01 +0000 UTC]
Hi, I work for the University of Southampton Open Data Service [link] . It's good to see people filling up important gaps in the world's data, but you've not placed any license on your data so it's difficult to reuse with confidence. See [link] -- I would suggest on of the data licenses listed at [link]
That said, we've done a bit of processing on your data to look for trends. We tried a line graph showing a 12 episode rolling average;
[link] but that's still hard to read, so plotting it as a stacked area graph works much better; you can see the change in relative screentime over time much better: [link]
👍: 0 ⏩: 1
dziadek1990 In reply to cgutteridge [2012-09-09 17:25:34 +0000 UTC]
Kinda late, but finally changed the licence.
👍: 0 ⏩: 0
ColtintheMoon [2012-06-05 18:42:45 +0000 UTC]
how much time does Derpy have? what about background ponies?
👍: 0 ⏩: 1
dziadek1990 In reply to ColtintheMoon [2012-06-05 18:53:53 +0000 UTC]
I timed only Trixie: 291 seconds. Timing other characters would require returning to the previous episodes... and I don't want to only do screentime; I am planning to do other, more interesting analyses.
👍: 0 ⏩: 0
dziadek1990 In reply to SweetTooth115 [2012-06-05 06:31:00 +0000 UTC]
Nope. Look here: [link]
👍: 0 ⏩: 1
SweetTooth115 In reply to dziadek1990 [2012-06-06 03:20:23 +0000 UTC]
well 5% is still somethin
👍: 0 ⏩: 0
OneRadicalDude [2012-06-05 01:47:41 +0000 UTC]
Again, thank you for doing these. I wonder what Season Three is going to look like!
👍: 0 ⏩: 1
dziadek1990 In reply to OneRadicalDude [2012-06-05 04:10:47 +0000 UTC]
Seriously, what do you nerds see in this math of yours anyway?
:\ Pinkster, just because you dislike math, doesn't mean everyone else does...
But still... could anypony explain to me what's so fun about math? It's all just numbers for Celestia's sake!
👍: 0 ⏩: 0
dziadek1990 In reply to Pirill-Poveniy [2012-06-04 15:38:35 +0000 UTC]
Oh, cheer up, Fluttershy! We still love you!
👍: 0 ⏩: 1
| Next =>