#spreadsheets

[tubapun]

Because this came up in my life recently, a question:

To be clear I mean a spreadsheet in any program (Excel, Sheets, Notion) and for any reason EXCEPT for it being required of you. It could be cataloging stuff you own, categorizing characters in a show you like, etc. But it has to be something you chose to do without being paid or graded for it

[theresattrpgforthat]

Hey - You Should Check Out My Character Sheets

I've been making character sheets for various roleplaying games over the past few years, and I've gotten pretty fucking good at it. I've got everything from small, simple, sheets...

...to complex beasts with clocks that tick and self-populating sections that pull from numbers you put in specific boxes.

I've got big, trad-like games with lots of pieces...

...and more abstract story-games.

And I include more than just character sheets! I include mission clocks, world-building tools...

... and safety sheets with a list of common safety tools!

So check out my play-kits - you might find that game you want to play just a little bit easier to do!

[charl0ttan]

having wretched terrible hobbies will have you looking up things like "mtx to gexf converter" as if those are actual real file extensions

[theheartnexttophan]

Phreadsheets Masterpost

For some reason, I've never posted most of my spreadsheets on here so I decided it's finally time to actually put them all in one place!

Dan and Phil Videos: A list of every currently public video, separated by channels, including date posted, length, if there was a guest, and spon info

Time Between Videos: A list of every day since Phil's first video, with all currently public videos filled in on the day they were posted (good for looking at posting frequency, but it's super long)

DnP Video Stats: Includes number of videos each year on each channel, total and average length per year, with graphs

Deleted DnP Videos- Post Hiatus: A list of unlisted and deleted videos, with dates, lengths, and functional links to the vids (note: only includes post hiatus, most of them are ads)

DnP Tour Dates: Includes dates and locations of all 4 tours, and videos posted during the tours

Phandometrics: Tracks relevant tags' position on the Tumblr fandometrics, starting post hiatus

I'm going to keep updating these as needed, but I may not get to it immediately, so if I haven't updated something yet, just know that I will! Also, I've checked for mistakes, but it's always possible I missed something, so if anyone notices a mistake, please let me know!

[phoenixyfriend]

New OC clones idea

His name is XL. He's average clone size, so people are naturally curious about what the name means. They ask if it's a dirty joke about his dingaling.

It's not. He pulls up some files. He's the quartermaster. He uses Space Excel, and it's not CALLED Excel, but he Excels at it. Hence XL.

His friends in two other battalions are Spread and Sheets. All of them get asked the Is It A Dirty Joke question and ALL respond with The Same Fucking Move (files).

This clone's job is spreadsheets and he LOVES it.

[copperbadge]

One of the things I do for my job every January is update a spreadsheet that contains all of the research my org has funded, and what the researchers went on to do after -- basically "We gave them $50K to study this disease and since then they've earned $2M in grants from other sources to continue that study." Overall we've had a great ROI.

But I took over the sheet two years ago, I didn't build it from scratch, and I had to modify it -- stuff like "separating researcher name into first and last name columns", adding a column for source URLs, a column for brief biographies, etc.

It's always had some formatting issues -- cells wouldn't align properly, or wouldn't wrap, or the row height would be truncated, and I couldn't figure out why.

Until I just took a look at the cell styles and realized that the person who had it before me, who was in finance, had formatted every column regardless of content to be either Currency or Accounting.

I'm gonna have to rebuild this fucker from scratch. I'm gonna have to copy the entire thing to a new sheet, paste without formatting, and reformat everything.

*cracks knuckles* should be fun!

(This is an example of how I am just Like That.)

[bewareofthenewphannie]

sigh....please don't kill me for this

AO3 Phandom Stats - Top or Bottom?

As many of you may have noticed there has been a shift in the depiction of Dan and Phil in fanfiction over the past few months from previously predominantly Dan being written as the bottom to now largely Phil bottoming. This post aims to put that trend into numbers and visualise it in a few overly convoluted diagrams below the cut.

Does any of this matter? Absolutely not.

Is it interesting? Oh boy, it sure is!

Disclaimer: This is an analysis of the fanfiction writing and tagging trends within the Phandom. It's at most tangentially related to the Real People Dan and Phil and is not meant to spark any type of discourse. I am doing this as an avid fanfic reader and with the utmost respect and appreciation for the authors of these fics, so I don't want to see any negativity directed towards them. Above all this is meant to be fun and interesting.

And as always - don't like it, don't read it <3

Note on accessibility: linked here is a doc with all the numbers shown in the screenshots of this post. Inspired by emma's stats I will be putting the cell range in the ID - if there's a better way to do this, please lmk!!

Methodology

To get the numbers shown here I filtered the works in the Phandom/The Fantastic Foursome (YouTube RPF) AO3 tag by "date updated" from the Jan 1st to Dec 31st of each year and by the following tags:

Bottom Dan Howell

Bottom Phil Lester

Top Dan Howell

Top Phil Lester

Short excurse on AO3 tags for those unaware:

The tags I chose are canonical tags, which means other tags that mean the same thing but are for example spelled differently are linked to this tag by tag wranglers and appear when you search for the canonical tag (see example below).

Additionally, the "bottom x" tags are metatags for the power bottom tags, which means fics tagged with "power bottom x" also appear when you filter works for these tags.

It's important to note that not every fic where one of them tops or bottoms is tagged as such. That means these stats very specifically look at the author's choice to tag fics with these tags and not the overall amount of fics where one of them tops or bottoms. However, I would argue it's fair to assume that it's at least somewhat reflective of the general writing trends within the Phandom.

For simplicity's sake I will refer to these tags as e.g. "Bottom!Phil" (b!p) going forward.

Stats 2013 - 2024

Here you can see how many fics were tagged with each tag in the respective year and the amount of bottom!dan and bottom!phil fics relative to the total amount of fanfic written in the same time span.

As expected, up until 2023 the split was about 2 b!d to 1 b!p fic (precise numbers: 71% to 29%; see pie chart above).

In 2018 we can see a peak in both in the number of phanfics written and the relative amount of fics tagged as bottom!dan.

Starting in 2023 (more on that below!) this flips and in 2024 the ratio of b!d to b!p fics was 1 to 4 (precise numbers: 81% to 19%; see pie chart above).

Furthermore, making up 4,62% of the total amount of phanfics written in 2024, the bottom!phil tag is relatively speaking twice as popular now as the bottom!dan tag ever was.

Sidenote: You can see that generally the amount of fics tagged with b!d and t!p, as well as b!p and t!d correspond to each other for obvious reasons (they're usually fucking each other). This year however there's 16 fics more tagged with bottom!phil than top!dan, which shows that there's been a very specific interest in writing and tagging bottom!phil in the last year.

Here you can see the total amount of phanfics written by year because I already collected the data, so I might as well put it here:

Stats 11/2023 - 12/2024

Now I want to take a closer look at the past few months post hiatus.

You can see that there's been a steady increase in the total amount of fics written per month!

That's incredibly cool!! (Love to all the wonderful writers out there <33)

Before we get into the actual stats, it's important to note that we're working with very low numbers here, so don't be fooled by overinterpreting percentages in the first few months depicted and look at the actual numbers! In the diagram below I excluded September and October 2023 because there simply wasn't enough data to produce useable results.

Contrary to what I expected, the increase in fics tagged with bottom!phil does not coincide with gamingmas 2023 (pour bot hem and top bunk kind of guy), nor phil's birthday live stream (topped by kakuna) but only really starts in June 24 and spikes in August for reasons I'm not fully sure about.

If I had to pin it on one thing it'd be the precious baby angel picture, which was posted in mid August.

Much more likely is though that this was simply a dynamic that built over months and had a wide array of reasons mentioned above and could very well be a self-reinforcing dynamic of more and more people looking for that tag and also writing for it.

If anyone has more insight on this, please share your thoughts :]

On that note, I'm finally done yapping, I hope this was at least mildly interesting!

[thiswasachoice]

This is a spreadsheet from Old Kingdom Egypt, written about 4500 years ago. It was part of the diary and logbook of Merer, an inspector responsible for the transportation of materials to Giza for the construction of Khufu's pyramid. There's something beautiful about the organization here, how his rows and columns would fit in just as well in Excel as any modern spreadsheet of delivery records. Across the yawning gulf of ages, we're united by this mundane and incredibly human task. I love reading things like this. They remind me of the fundamental similarity of humans across time. They were no less intelligent or skilled than we, and oftentimes had to be moreso, to account for the many technological aids they lacked.

I often hear people talk about how showing a smartphone to a medieval peasant would shock him, but I want to show Merer Excel. I think pivot tables would make him cry tears of joy.

[hailsatanacab]

about to make another spreadsheet. truly one of life's great joys

[theresattrpgforthat]

Mothership Playkit

I've got another Google Sheets Playkit for folks, this time for Mothership!

Mothership is an OSR space-horror game by Tuesday Knight Games, and is inspired by movies like Alien. It has oodles and oodles of interesting modules for you to run for you crew, the most recent of which were submitted to the TripTech Game Jam back in May!

I tried to replicate the way the character sheet guides you through character creation, although I had to upload a second tab just to illustrate how the different skills are connected to each-other. I also included my typical Safety Tools Sheet, which has a link to the game and my bog-standard section of Lines, Veils & Lures!

You can check out the playbook here...

...and you can take a look at my entire playkit library at the link below!

Clicky.

[charl0ttan]

blue dot for each rating ive given an album on rateyourmusic from each year, red is the rolling average rating of my 908 albums over each year

[luxradium]

If you're getting into audio drama because you're tired of living in a world where every second is ruled by spreadsheets, I have some terrible, horrible, no good, very bad news for you...

[dare-to-dm]

There's this running joke HBomberGuy has in some of his videos where he makes a spreadsheet of all video games in order of which ones are the best. There's only like 4 games on his list, because it's more of an exercise in sarcasm than anything else. But to me there's nothing more relaxing than making lists and spreadsheets, so I decided to make a spreadsheet unironically ranking every video game I've ever played.

I tried to approach it with a certain level of structure by rating every game for the following categories: Gameplay, Story, Controls, Visual Aesthetics, Sound Design, Re-Playability, Quality Assurance, and User Interface.

Anyway, I've now rated 407 games, which is not necessarily an exhaustive list, but it does include everything in my xbox and PC libraries as well as other games I can remember playing earlier in life. And according to the aggregate scores, these are my top 10 games:

Mass Effect 3

Hades

Balatro

Baldur's Gate 3

Persona 5 Royal

XCOM Enemy Within

Assassin's Creed IV Black Flag

Saints Row 4

Halo 3 ODST

Spiritfarer

This is not to say those are my favorite games (though I do really like all of them). Heck, a couple of them surprise me. But they definitely rank highly in my mind in terms of overall quality.

[phanchester]

since there are so many data nerd phannies i decided to make a compilation of all the spreadsheets i could find - lmk if i missed any or if you want me to add any additional details <3

last updated: 30/06/24

actively updating spreadsheets

dan and phil uploads from 2021-2024

dan and phil’s upload schedule from all their channels with days and dates

amount of days in between videos in each channel

pie charts of days of the week they upload

made by @ahappydnp 

everything dan and phil related

all of dan and phil’s video links from all their channels from all their accounts (including super amazing project, snapchat, vine, tiktok and more)

all of dan and phil’s radio shows, including reuploads and playlists, as well as the dan vs phil, fan war and internet news if available for each show with misc clips and written recaps

all of dan and phil’s liveshows, including some written recaps and the app where it was originally posted

all of dan and phil’s vyous including the question they were answering

all of dan and phil’s collaborations and video features (even if they were in the background), including the channel they were originally uploaded on 

all of dan and phil’s interviews

all of dan and phil’s merch, including originally shop links and links to the phandom wiki which has further information

all of dan and phil’s professional photos as well as some fan photos, including the event, photographer and platform

the dates and statuses of each of these videos (lost, archived, unlisted or public)

made by @stillarchivingdnp

dan and phil 2024 upload stats

each of their 2024 videos with channel, upload date, upload time in uk, length, sponsor and editor/s (if applicable) with an accompanying colour-coded calendar

(for amazingphil videos) whether dan featured and (for dapg videos) whether it was gaming/talking and who tweeted it

interactive part where you can see the time period between two videos

averages, maximums and minimums for times between uploads, upload times and runtimes with accompanying graphs

percentage of videos with other editors, with pie charts for all channels and each channel

made by @dnpbeats

all or nothing: dan vs phil season 2

all of the games for season 2, with the year they played them and the results with and without all or nothing coming into play

how often all or nothing came into play and who suggested it

the general impact of all or nothing

made by @organized-chaotic-disaster

dan and phil saying “i love you”

when dan and/or phil said ily

the video and timestamp from when they said ily and whether it was prompted

pie chart of dan or phil saying ily

made by @ahappydnp

games where one of them decides the winner

date and link for each video

overall winner with the winner for each round

breakdown of the amount of times each of them have won each round and the percentage phil has won

made by @dnpbeats

dan and phil 2024 upload schedule

upload date for each video, with the day of the week and approximate time it was uploaded in cst, including the most common and second most common upload day for dapg

days between each upload, including the longest gap, shortest gap, average gap and first and second most common gap for dapg

a colour-coded calendar displaying the upload schedule for dapg and amazingphil

made by @kat-aa

completed spreadsheets

all or nothing: dan vs phil season 1 with a great accompanying document with further details and analysis of the data

all of the games they played, with the year they played them and the results with and without all or nothing coming into play

how often all or nothing came into play and who suggested it

the general impact of all or nothing

made by @organized-chaotic-disaster 

youtuber tours

(not necessarily dnp but it includes them!)

120 different tours, including the creators, names, dates, countries, links (if available) and producers (if applicable)

each tours’ venue capacity range, average and total attendance

individual tour show breakdown with city, state, country and additional notes

data on each venue’s capacity, number of tours, and which youtuber went to each venue

data on each country’s amount of shows, broken down into states and cities

made by @stillarchivingdnp 

gamingmas 2023 schedule

all gamingmas video titles from 2023

the time each video was uploaded in gmt

made by @cactuslester

spreadsheet screenshots in posts

listening trends in all or nothing

scatter graph for the correlation between track number and number of listens

analysis of the data

made by @serendipnpipity

analysis of dnp’s letterboxd ratings and movies with part 1 and part 2

(pt 1) rating distributions for all the movies they’ve rated, including details about which movies one rated higher than the other, and which movies they rated the same

(pt 1) a list of their five-star movies

(pt 1) a list of movies one logged but not the other

(pt 1) cute little misc notes about the specific movies and dates

(pt 2) ratings broken down into genre, studio and franchise with accompanying bar charts

made by @philsrosesweatshirt

views on post-hiatus dapg videos after specific time frames

i believe this is a work of progress!

video titles with the dates and months, along with details of whether they were sponsored or had external editors

view count after 24 hours, 48 hours, 1 week, 2 weeks, 3 months and 6 months

made by @goldenpinof

favourite dnp tour song statistics

years phannies started watching vs the year they joined the phandom represented in a bar graph

favourite dnp tour song in a donut pie graph and a bar graph

favourite song vs year joined represented in a bar graph

made by @serendipnpipity

terrible influence: the tour trailer video analysis

all the videos that appear in terrible influence with additional notes

the list sorted by date, view count and channel specifics

timestamps provided for each clip, both in the video and where they appear in the trailer

made by @emojackolantern