#excel data

[biggest-gaudiest-patronuses]

the fact that shakespeare was a playwright is sometimes so funny to me. just the concept of the "greatest writer of the English language" being a random 450-year-old entertainer, a 16th cent pop cultural sensation (thanks in large part to puns & dirty jokes & verbiage & a long-running appeal to commoners). and his work was made to be watched not read, but in the classroom teachers just hand us his scripts and say "that's literature"

just...imagine it's 2450 A.D. and English Lit students are regularly going into 100k debt writing postdoc theses on The Simpsons screenplays. the original animation hasn't even been preserved, it's literally just scripts and the occasional SDH subtitles.txt. they've been republished more times than the Bible

[selfindulgentcompetition]

TRYING AGAIN WITH CLEARER WORDING. PLS READ BEFORE VOTING

*Meaning: When did you stop wearing a mask to a majority of your public activities? Wearing a mask when you feel sick or very rarely for specific events/reasons counts as “stopping”

[More Questions Here]

[luthqrs]

doctor who big finish audio stories!

⚠️ this post is no longer being updated or monitored x ⚠️

you may have seen my nuwho books post and thought “well that’s all good and proper but i wanted the big finish audio dramas >:(“ fear not, because i have a collection of those too and i am still not allergic to sharing :)

also up for grabs: doctor who novelisations (x) and torchwood big finish audios (x)

a list of what’s there + how to play below the cut x

things you’ll find here:

new who + misc

the diary of river song (series 1-12)

the death and life of river song (series 1)

the tenth doctor and river song (series 1)

the tenth doctor adventures (series 1-3)

the ninth doctor adventures (series 1 + series 4 vol. 1)

unit incursions (episodes 8.04 + 8.05)

unit nemesis (series 4)

missy (series 1-4)

the eighth of march (3.01 + 3.02)

masterful + terror of the master

rose tyler: the dimension cannon (series 1-3)

the paternoster gang (series 1-5)

master! (series 1-3)

time lord victorious (008)

once and future (005)

tenth doctor adventures: dalek universe (3.02)

classic who

the eighth doctor adventures (series 1-4)

stranded series (series 1-3)

doom coalition (series 1-4) (exc. 3.02.... working on it)

dark eyes (series 1-4)

ravenous (series 1-4)

classic main range (134, 135 + 168)

companion chronicles: the second doctor (vol 1-3 / series 10, 12 + 14)

gallifrey (series 1-3)

!!! torchwood audios have moved. they can now be found here !!!

and how to access them

press play!!

if you like to listen at 1.5x speed like me, you can use an independent media player. on ios, press the 3 dots -> open with: [audio player of choice] (i use evermusic)

make and save copies of what you want even if you don’t have time to listen right now. don’t rely on this link always being here.

want something you can't have?

⚠️ this post is not currently being monitored or updated ⚠️

if there's a particular story/series you wanted to hear that i don't have listed yet, send me an ask or pop it in the comments x

happy listening! x

[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

[scificrows]

Okay, my brain refuses to think about anything other than Murderbot, so I looked at every use of the word "friend[s]" in TMBD and... created some pie charts. Normal human activities.

Some Thoughts™ I had while putting this together (under the cut):

In All Systems Red, Murderbot notes that the PresAux crew are all close friends (twice! and goes on to explain their internal relationships which I think is very cute). This is pretty much the only use of 'friends' in ASR, except for when Murderbot says that SecUnits can't be friends with each other.

It seems that this may be one of the first times Murderbot has ever really been around a group of friends before? Murderbot notes that this is not the norm for its contracts and admits that the fact that they are all friends and the way they interact with each other make it actually enjoy that contract (before!!!! the hostile attack, so it already enjoys this contract before they start seeing it as a person etc ghghhhh). [Inference: Friendship seems enjoyable.]

The first character that calls Murderbot its friend is ART in Artificial Condition. Murderbot immediately refutes this (and then goes on to call ART its friend to its clients for the rest of the book). [Inference: Maybe ART is Murderbot's friend. And maybe that is... agreeable]

Rogue Protocol has more than twice as many instances of the word 'friend' as any of the other novellas. Why? Miki. Friendship and its implications for non-humans are a central theme because Miki is friends with everyone. Murderbot initially scoffs at the notion that Miki and Miki's humans are friends. At the end of the book, after witnessing how desperately Don Abene tried to stop Miki from trying to save them, and her grief after its death, Murderbot has to admit that she had in fact been Miki's friend. [Inference: Humans can be friends with bots and can sincerely care about them]

In Exit Strategy, Murderbot tentatively uses the word "friends" for its humans for the first time (several times actually). It questions whether it can actually call them its friends or not and later realizes that it had been afraid what admitting that the humans are its friends would do to it. At the end of the book, Mensah tells Murderbot the PresAux crew are its friends, which is the first time a human has directly said that to it (at least on-page). [Inference: Humans can and want to be Murderbot's friends]

In Network Effect, Murderbot seems to be more habituated to the word 'friend', confidently calling ART and Ratthi its friends, like it is no longer just trying the concept on unsure if it fits. There are many instances in which other characters refer to MB as ART's friend or the other way around and Murderbot's humans refer to Murderbot as their friend several times. Generally, there seems to be less hesitancy, because yes, all of them are Murderbot's friends, why wouldn't they be. [Inference: SecUnits can have friends. This SecUnit has friends. They care about it a lot.]

Conclusion: The Murderbot Diaries tell the story of a construct that does not seem to consider the possibility of friendship for itself and is fine with that - until it accidentally starts caring a little too much and suddenly more and more people annex it as a friend (ew) to the point where it can no longer deny that this is happening and has to begrudgingly admit that yes, it has friends now and maybe that is actually not a bad thing.

[deer-watcher]

"For both bonobos and chimpanzees, the bodies of the dead evoke many emotions. Even if the process often begins with trauma and confusion, typically corpses shift to a liminal status; not alive, but equally not a lump of meat. They're more intensively manipulated than hunted animals, and carried for longer. In some – if not all – cases, the eaters must know what and who they're consuming. Cannibalism is very probably a powerful means by which individuals and groups process the impact not only of killings carried out on emotional impulses, but other deaths too. In other words, it's about grieving. [...] "Shift these scenarios to Neanderthals, and add into the mix their far greater cognitive sophistication, and lives that revolved around using lithics. Suddenly it's not difficult to envision how skills in carefully taking apart hunted carcasses might be transposed into a grieving process that involved butchery and cannibalism as acts of intimacy, not violation."

Rebecca Wragg Sykes, Kindred: Neanderthal Life, Love, Death and Art

[dnpbeats]

would it be too unhinged if I made an excel/google sheet tracking all the main channel uploads this year so that I can see the avg time between each upload across AP and DAPG.... also I kinda wanna keep track of other info too like vid spons, AP vids with dan, if they're actually playing a game or just Banting™ in DAPG vids,,, like is that unhealthy or would it be interesting 👀

[dailydegurechaff]

Today's Daily Degurechaff is… boop boop boop

[thedisablednaturalist]

idk whats wrong with me.

I'm trying to exercise, eat healthier, get enough sleep. Just like the doctors say.

But I'm still, STILL, so..so tired. So unbelievably exhausted. I'm starting to think I might have ME or something. Fibro is supposed to be able to be managed with diet and exercise, according to my doctors *rolls eyes*.

I want to work hard like I used to. I want to have bright ideas and feel passion. I do, sometimes, but it's so hard to break through the fog and pain and exhaustion, and it doesn't last. I feel like I'm constantly trying to hide how stupid I am, I'm afraid my coworkers will find out how hard I'm really struggling. All the stuff they praise me for seem like they were all achievements from Before the illness, I don't feel like that person anymore.

But what am I supposed to do? I have to work, I have to make enough to stay out of my parents house. I can't go back there. So I'll keep fighting, hiding, crying, and doing my best to improve my health, even if that's only out of desperation.

[herpersonafire]

Hey! and welcome back!

As Uni is about to begin in a few days....I upgraded to a third monitor! Also!! I job a Data entry job! Big things moving forward :)

Let me introduce myself;

I'm Mick, (she/her) and I currently study Data Analytics. I'll be 26 in July and I love to read and play video games in my free time. I also like to watch football (LIVERPOOL xx)

Im currently taking the time to learn Excel and Python. However, I know for school I'll be learning Python, SQL and maybe some other things.

FOLLOW me along on this journey and if you have any questions please ask!

[superm4ks]

Kit do you not rep Charles anymore 😭

Of course I do he’s prime I just need a break from his team and that fucking dog

[frnkiebby]

i could watch his fucking talking hands for HOURS~🎃

[bigcats-birds-and-books]

y'all i've been upset about nanowrimo's shenanigans since last year, when kids weren't safe, and now there's this AI shitshow, and i want to cry about it again, because nano has been SO IMPORTANT to me since 2008--it helped me hack my writing process and make a bunch of cool shit, and i've written so many stories i love using it as a jumping off point. but. we gotta protect kids, and we gotta get the fuck out of here with AI bullshit.

so. the decision i have come to is that i will still be participating in nano. but now it stands for "now a's [that's me] novel writing month." i'm still going to write a book in november, and i'm still going to shoot for the 1,667 words/day (even though my finished projects wind up way longer than that, invariably), because i've structured my creative life around this routine, but i won't be using their site any more.

i will also not be tagging my november project posts as nanowrimo, but i WILL still be tagging them as "nano[YEAR]" (because that's been my tagging system for untitled projects for uh. years.). and it's now a's novel writing month :)

[istharoth]

Now that we got Contrived Smile for Tohma's banner (Last Re-ran on June 13th), these are the ones left for a possible re-run in due time.

Zenji Kotodama - Unearthly Bohemian: First Banner on June 3rd, has not been rerun.

Taiga Hoshibami - Notorious Visionary: Last Reran on June 17th

Romeo Lucci - Cutthroat Opulence: Last Reran on June 24th

Alan Mido - Dark Horizon: Last Reran on July 8th

[petit-papillion]

Giving credit to original posters, creators, artists, photographers, and sources matters.

It matters to the person who put in the time and effort to create the content. Whether it's finding that photo and editing it to make it stand out. Or downloading that video, editing it, coloring it, turning it into a gif, adding subtitles, etc. Regardless of what you do (job/student), I'm sure you too would not like it if someone else takes credit for your work.

It matters to people who want to know context. Was it said by a fan, your favourite's bestie, a reputable journalist? Published by a tabloid or the New York Times? From last week or last year? Is it an original, or did someone get photoshopped in for a meme?

It matters to people who may want to explore more content of that particular publication, so they will continue to publish top-notch articles. Or give kudos to a budding artist for their outstanding art work, potentially encouraging them to create more. Or compliment that photographer on capturing their fave in just the right light.

It matters, because even though it may take you an extra minute or so to add on that name or link, it is the right thing to do.

[veronadragon]

Sims 2 Townie Data

After watching @anibats ' latest video on her setting up her Downtown by matching up townies by genes, it had me very curious about the genes of townies from other hoods. So I decided to spend a couple hours collecting data and made an Excel sheet with Pleasantview, Strangetown, Veronaville, and Bluewater Village townies. It's just the basic stuff really, first and last name, age, main aspiration, hair, eye and skin color. In the end I found the data I collected very interesting (to me at least)

So here the link to the Excel spreadsheet if you want it so you can see the data yourself in it's entirety or want an easier way of pairing certain townies up into families. I'll consider about possibly doing the EP hoods later.