#excel for data

[uplyrnteam]

Excel Pivot Tables: Crash Course introduction

Learn data analytics with helpful Pivot Tables in MS Excel. Use Pivot Tables to get answers of business problems.

Link to course

[mimi-0007]

Valerie L. Thomas (born February 8, 1943) is an American data scientist and inventor. She invented the illusion transmitter, for which she received a patent in 1980. She was responsible for developing the digital media formats that image processing systems used in the early years of NASA's Landsat program.

[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

[limefrogg]

:]

[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.

[gnot-art]

Checkin' My Spreadsheet :: half body (2025)

Who to send back to the professor…

He's comparing statistics :3

[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

[lapdogchase]

i have officially set up the substances spreadsheet for 2025. which is a normal thing to do

[bigcats-birds-and-books]

y'know it wasn't until i went to pull all my stats data off the nano website that i realized: it's not actually gr8 for grabbing things in one fell swoop, huh??

[dailydegurechaff]

Today's Daily Degurechaff is… boop boop boop

[khodorkovskaya]

ive been trying to figure out if my cycle is regular or not (bc how regular is considered regular) and i haven't been able to find any information about distribution of what having a regular cycle is. it's always about distribution of women as a whole and not for one woman.

any excel girlies do this?

[gnot-art]

=SUBSTITUTE(myFursona,"fox","lion") :: full body (midi) (2025)

He's broken into my spreadsheet

[idol--hands]

[greaseonmymouth]

please can the 50yo men at my work stop wanking over chatgpt