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
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
301 notes
·
View notes
Palia Garden Progression
Here's several garden patterns that I've made starting from the 2 soil you have at the beginning, all the way to end game!
All of these are balanced around:
Growing every crop (rather than just gold farming)
Low maintenance (every crop has Weed Prevention and Water Retain without fertilizer)
Minimal crop changes between patterns
Two Soil Starter Garden
4 Carrots, Onions, Potatoes, and Tomatoes
2 Cotton
Four Soil Basic Garden
6 Carrots, Onions, Potatoes, and Tomatoes
4 Cotton, Rice, and Wheat
Six Soil Intermediate Garden
9 Carrots, Onions, Potatoes, and Tomatoes
6 Cotton, Rice, and Wheat
Nine Soil Advanced Garden
13 Carrots, Potatoes, and Tomatoes
12 Onions
11 Rice and Wheat
8 Cotton
First Blueberry Garden
13 Carrots, Onions, Potatoes, and Tomatoes
9 Rice and Wheat
7 Cotton
1 Blueberry
First Apple Garden
12 Carrots, Onions, Potatoes, and Tomatoes
8 Cotton, Rice, and Wheat
1 Apple
Blueberry Pie Garden
14 Carrots and Onions
13 Tomatoes
12 Potatoes
4 Cotton, Rice, Wheat, and Blueberries
In this one the very middle Tomato does not have Water Retain, so you will either need to water it yourself or maintain it with HydratePro fertilizer.
Apple/Blueberry Pie Garden
12 Carrots, Onions, Potatoes, and Tomatoes
4 Rice, Wheat, and Blueberries
1 Apple
Every Crop Garden
12 Carrots, Onions, Potatoes, and Tomatoes
6 Rice and Wheat
4 Cotton
2 Blueberries
1 Apple
(Bonus) Cake Baker Garden
8 Wheat
6 Rice and Any Crop (the purple spaces with the coin/Z)
5 Apples
4 Blueberries
This garden doesn't follow any of the rules of the previous gardens. It is designed to maximize apple and blueberry farming, with harvest boost and growth speed boost applied on every crop without fertilizer. You will also need to water and weed this farm every day, but in return you'll be able to bake sooooo many cakes, which is a great way to help your friends earn gold in group cooking because every participant gets 3 cakes which sell for a decent amount, and quickly raises cooking level. All the wheat also helps for baking pies!
132 notes
·
View notes
That’s the seductive power of the spreadsheet: it’s a tool for asking what if? With just a little training, anyone can use a spreadsheet to build a model of some real-world phenomenon, from an ecosystem to a convenience store, from a lemonade stand to a retirement savings plan.
Then, by tapping new numbers into those neat little boxes, you can change the model: what if I pay a little less here? What if I save a little more there? What if this number goes up? What if it goes down?
Change a box and all the numbers dance in their gridwork of faint gray lines, and the future is revealed, with a terrible and false precision. Terrible and false because the model is a model, it’s not the world, and each of those sharp figures and formulae obscures a fuzzy, squishy set of assumptions, guesses and elisions. The model can suggest, it can guide – but it cannot predict.
This is what made spreadsheets so science fictional. As we lose ourselves in a futuristic parable, it’s easy to forget the “parable” part and start to think we’re experiencing the future. To forget that sf writers have no more insight into what the future holds than any of us, and thank goodness, because if the future could be predicted, there’d be no reason to do anything or try anything.
The future is up for grabs. That’s the point of science fiction: not to predict the future, but to inspire it, or ward it off. To work out our present-day anxieties and aspirations on the page, to provide a virtual fly-through of the emotional experience of this technological arrangement or that.
The seductive, science fictional power of the spreadsheet
199 notes
·
View notes
Due to the recent end of secret life I present to you...
A SPREADSHEET!! :D
No but actually I made a spreadsheet to try and figure out how people are placing in the life series so I can make a guesstimate of how they'd place in a regular game, say if the other games were inconsequential, and they had the skills that they have after all the life games.
Ok to start I found out how they placed over every game and put that into a very confusing table (the limited life placing was so annoying :)).
And then I made it easier to tell how they placed with colouring so I could scope roughly how each person plays in every game. Putting it in order of each game would have been too much work, and I think it would be harder to tell anyway.
And then I averaged their places overall, and without third life. Reason for without third life is that it was the first game so their skills weren't at all what they are now, and it was kind of what I'd like to call a warm up. If that makes sense.
Then I averaged those together (a lot of averaging I know :D) and with that created a generalised list of how I think they might place in a game where: they had all their skills from playing the previous games, but also had no memory of previous alliances in the games, or if they had won previous games.
Also I kinda looked at the placing and asked myself who would win in a 1v1. AND I think that gem could easily beat everyone in a 1v1 but she's only been in one game so I put her lower lol.
(oh also, I made last place equal to 20 points because of how the different games have different amounts of players, and figured that would make it more of a fair test)
Sorry for iffy wording throughout this
explaining my thoughts was a tad bit strange :D
51 notes
·
View notes