#my spreadsheets

[vivitur-moritur]

say what you will about my tma episode spreadsheets and wasted effort but they've actually been enourmously helpful for writing fic! it's wonderful to have such a conveniently sorted timeline on hand. actually, it's technically four conveniently sorted timelines on hand! i love my spreadsheets.

[a-bad-case-of-the-stephs]

Keep having the urge to make spreadsheets. I could find the average amount of panels Steph is drawn with the half mask pulled down out of the amt of panels she is drawn wearing her half mask. I could sort these instances by setting and amt of characters present. I could compare this to the corresponding amt of panels where diff characters have their masks off + costumes on. I could write a short essay investigating the results.

[purplebunnygirl]

I made a spreadsheet to figure out the stats of my main music playlist and out of 164 songs, 43 (26.22%) were Bears in Trees; the next highest artist had 15 songs

[drunkkenobi]

Here it is, the final Watcher viewcounts post I plan to make.

While Watcher is staying on YouTube, with a portion of their audience watching their videos only on WatcherTV (like me), tracking viewcounts no longer feels like it’s something that is worth keeping up with week to week like I’ve been doing for the past five (!) years. Also, at this point, there are less things to be learned from this kind of weekly stat-keeping and I am a bit worn-out about it. I don’t take every video’s numbers every week or anything, but it’s still a bit of a chore, especially now that I’m at a job where it’s a bit harder to do every Monday.

Here is a hodgepodge of information I’ve gleaned from doing this:

I would say that views are a bit down since the WatcherTV announcement, but first of all, lots of people (myself included) do not watch them on YouTube at all anymore but still watch them on the streamer, so that has to account for some of that loss. Of course, people deciding they hated Watcher would also account for some of it, but it’s really not a dire fall-off or anything especially for Ghost Files.

The only thing that really did quite badly on YT after the streamer announcement was Weird and/or Wonderful World, which is distressing to me on every single level. That show is so good and you can tell it meant so much to them to make something so joyful after the mess that was April 2024. I hope that the streamer means it can continue to return, even if it’s not every year.

Steven’s food videos behaved completely differently than everything else on the Watcher channel. If that’s because they starred Steven or because they were food videos, I can’t say, but they were often the only videos that could really gain steam weeks after release. The Shane&Ryan videos pretty much always peaked the first week, maybe the first two weeks, but that has never been a guarantee with the food videos. Even just this year, the spicy food episode of Travel Season jumped around 400k views in its 4th week.

Knowing this, the revelation that Watcher is going to create a separate YouTube channel for their food videos (starring Steven and Andrew) does not surprise me in the slightest. There’s obviously something different about the Almighty Algorithm when it comes to food and cooking (which is probably why Buzzfeed had like 3 different food channels) so I’m all for them taking advantage of that. (and hopefully keeping Steven safe from nasty assholes)

I will probably keep an eye on that channel tbh, but not in the same way I did for Watcher proper. We’ll see.

The highest viewed video on Watcher’s YouTube is Ghost Files: Waverly Hills with 8.9 million views

Ironically, the video that got the best opening weekend ever was their Goodbye Youtube video with 1.728 million views by Monday morning.

Watcher lost around 100k subscribers during The Discourse this past spring but they are back up and beyond that now. As of today, January 6, 2025, they have 2.89 million subs and 450 videos.

The total views is 469,381,807. The average view per video is 1,043,070. (I assume this includes all the “shorts” as well, for whatever that’s worth)

I don’t have to do the math to tell you that Ghost Files has the highest average viewcount. It’s by far been the most consistent show for them. The least consistent is probably still Top 5 Beatdown, which does still have the distinction of being the first Watcher video to hit 1 million views. (Top 5 Fast Food Chains)

Alright, I think that’s it! If anyone has any questions, please let me know! It’s been fun keeping track of this for the past five years and I really only kept up with it for so long because of the support from y’all here on tumblr, so thank you all for reading!

[taylor-on-your-dash]

so i'm working on the live performances timeline and i don't know if should make a separate tab for the headlining tours or just cramp everything on one page. actually!! it's not gonna be one page bc i'm dividing the sheets into decades - so there are 3 tabs (1. 2002-2009; 2. 2010-2019; 3. 2020-present) BUT idk if the tours should get one tab of their own OR if its better to add them in their specific decade tab. AND!!! should the eras tour get its own tab since it was massive? DOES THAT MAKE SENSE IDK

[bookworm-2692]

Life Tracker updated for Episode 7! This one is much quicker than Episode 6 on account of not being on holiday at the time, even though there were two thirds more deaths this time. Previous posts: Session 6, Session 5, Session 4. Also Session 8 (finale) post!

As usual, close ups and commentary below the cut. I’ve also added another graph for the average time of each team, which will also be below the cut.

There was so much carnage! 45 whole deaths in a single session! Not all deaths were awarded time during the session, but Scott’s video advised that it would be added by next session, so I have taken the liberty to add all the time as I see fit, hence why Scott is back to 7.5 hours. I haven’t seen every episode yet (in fact, other than Scott, I’ve only seen those that have perma-died), so I’m not sure if anyone else’s time is a mismatch, but if so I’m happy to explain where I’m getting my time additions and subtractions from!

Now for some close ups.

First, there was enough chaos that I decided to take a close up of Session 6 and 7 together so we can properly appreciate it:

And a close up of Session 7 by itself:

So many people lost major time, so it’s interesting to see Scott’s uptick of time at the end - he ended on only 30 minutes less than he would have been if he hadn’t died at all this session. Pearl didn’t die at all, and got the kill credit for Martyn blowing himself up in a trap, so she actually ended the session 30 minutes better than she started it. Grian also did very well for himself - he killed and died so many times, but somehow ended on the exact time he would have been on if he had experienced a peaceful deathless session.

BigB, Cleo, and Martyn all ended the session 1 hour poorer than they started, and Bdubs and Scar ended 1.5 hours below where they would have been. Nosy Neighbours are thus doing super well, with Mean Gills and Clockers not too far behind, in terms of maintaining position from the start of the session.

TIES had an awful time this session, with Impulse and Tango both losing a net 2 hours, and Etho and Skizz losing a net 2.5 hours - and obviously Skizz entirely died.

Joel possibly had the worst time, losing a net 3.5 hours this session - though it didn’t help that 5 of his 7 deaths were all caused by the one person. Technically Jimmy didn’t do too badly, given he only lost a net 1.5 hours... but given that he was out of the series only an hour into the session, and also the first out entirely... it really didn’t go well for him either

I also find it interesting the sheer number of vertical lines this graph, the ones representing a death immediately followed by a kill or vice versa. I would love to figure out a way to show only one line at a time on the graph, so we can more easily see someone’s journey, but I haven’t had time to look into it yet.

Now onto the graph of the average times per team.

This one is super interesting to me, especially TIES’s line - they had the lowest average life right from the start, but somehow by Session 4, through Session 5, and for most of Session 6, they were the team with the highest average time, and then it quite literally went downhill from there. The only thing saving them from being last now is the fact that the Bad Boys are down to only a single living player, and even then Grian is doing far better than most of TIES.

It’s also interesting to me how Mean Gills had a significant time uptick at the end of both Session 6 and Session 7 (the first due to Martyn and the second due to Scott). Scott’s time was so high that it kept Mean Gills’ average time as yellow for all of Session 6 despite Martyn being red for most of it... and Martyn then got enough kills to keep it there. Mean Gills is also the only team in the entire graph to anywhere gain such consistent significant time.

These averages also coincide with the comments I made above about the time offset difference for each player from the start to end of the session. Mean Gills are doing well, but they’ve been doing well for so long that I’m sure most players are aware that they need to be a target. Nosy Neighbours are also doing well but I feel like they’ve flown under the radar, and are not a significant target right now.

Here is a close up of this graph with Sessions 1-4:

And the close up for Session 5-7:

And the Session 7 only close up:

I kept the dead players in the teams’ averages, since I think it is a better reflection of the teams’ strength as a whole, but I also created a version that excluded dead players. In those screenshots you can really see Bad Boys’ and TIES’ time jumping up at a death, instead of falling as it did here.

Here are the alternate averages graph:

And close ups:

This makes Bad Boys look a lot better, because Grian does have a lot of time... but he is also alone. And there is definitely strength in numbers. Two players at an hour and a half each can fend off an attacker more easily than a single player at three hours can... unless nerves and panic get to them, as we definitely saw this session.

Wow and I almost forgot to include the raw data for this session!

The first hour of the session:

The second hour of the session:

There is just so much death! Look at all the box outlines!! I could barely fit this data on two screens on the zoom I was on, and I did not want to zoom out further.

I also obviously have data for the averages, but it was too far away from the column with the times on it that I wasn’t sure if it would still be useful on its own? Let me know if you want to see it!

This has once again been fascinating to see, and I cannot wait to see how Session 8 will go. Will it be the last session? Will they go until everyone is dead? Will they somehow have enough people with enough time to get to Session 9? Will Mean Gills be the final two and get to play fun relaxing games like Scott was suggesting? 

Only time will tell.

[avicinda]

My Evolution and Eureka trackers 😊

Just really happy with the formatting!

[caller-id-cant-stop-me]

Cog Joke Response Graphs

Do you like parsing data? Do you enjoy making spreadsheets? Are you a Cog? Boy, do I have some Excel charts for you! I’ve decided to record every joke response in every Field Office I go into. I’ll stick them into my beautiful Excel spreadsheet and I’ll see if some joke responses are more common than others. Why? Because I can! Also I may be a Cog... in disguise... haha just kidding.

I don’t think I have enough data yet to make a conclusion. And even if I do make a conclusion, it will solely be what Nyamco, the Toon I’ve been running on, experiences. It may be different for different players!

As of December 29th, 2022, out of 251 joke responses:

Do you have some screenshots of joke responses? Please send them to me so I can throw the data into the chart! If you decide to make your own chart, also send it my way so I can see if the ratio changes depending on the Toon. I only run Field Offices on one Toon, so it’s possible that things will change based on the Toon. After all, responses are different for every Toon, unlike the jokes themselves. All players will see the same jokes, but all players will see different responses.

ALSO IF YOU HAVE IDEAS FOR OTHER SPREADSHEETS, PLEASE SEND! I LOVE SPREADSHEETS AND DATA AND EXCEL SO MUCH. AUTISM HUNGRY FEED IT DATA!