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
235 notes
·
View notes