All 4K Releases Spreadsheet

Please post here for issues related to UHD discs
Cannikin
Posts: 173
Joined: Tue Aug 18, 2020 11:54 pm

Re: All 4K Releases Spreadsheet

Post by Cannikin »

Update

Added the 2022-02-19 sheet with 1357 titles (133 more than the previous sheet).

https://docs.google.com/spreadsheets/d/ ... 2026863674
J8GDN
Posts: 1
Joined: Tue Feb 22, 2022 3:32 pm

Re: All 4K Releases Spreadsheet

Post by J8GDN »

Great spreadsheet !!
seanfrisbey
Posts: 2
Joined: Fri Jan 03, 2020 4:41 pm

Re: All 4K Releases Spreadsheet

Post by seanfrisbey »

Could I request that the header row be frozen? It's very difficult to keep track of which column is which when looking at this spreadsheet. Please and thank you for considering!
Cannikin
Posts: 173
Joined: Tue Aug 18, 2020 11:54 pm

Re: All 4K Releases Spreadsheet

Post by Cannikin »

Updated with latest releases, looks like 105 new releases since last time!

https://docs.google.com/spreadsheets/d/ ... PAH7i3dStM
roymi6
Posts: 4
Joined: Thu Jul 07, 2022 7:39 am

Re: All 4K Releases Spreadsheet

Post by roymi6 »

Hi @Cannikin, loving your spreadsheet! As my cinema room nears completion I hope to make good use of it! :D

I'm a much more visual person so thought I'd throw together a interactive dashboard to help me understand your data better: https://datastudio.google.com/reporting ... 74307c5d44

I find data visualisation quite fun because you can make quick observations about outliers - like noticing that there are very few "IMAX Enhanced" films, and that only ONE of those has ATMOS... and that film is Angry Birds! :shock:

Just a couple of questions/requests from a data engineering standpoint...

Why have you chosen to have multiple entries for the same thing without having different names? For example, Terminator 2: Judgement Day has a 2017 and 2018 release, but you don't differentiate them in the title (e.g. by adding the year to the end). Would be nice if this was the case as it kinda messes with my ability to count distinct records, so there's a difference between what the numbers will sometimes say and what the list at the bottom might contain. (EDIT: Actually, I can fix this by making a combined column of #TITLE# - #RELEASE_DATE#... but it shouldn't really be necessary)

It would be great if there was a "latest" tab rather than a new tab every time you add data. The problem is going to be that when you update the list I'll need to update the data source for my dashboard to point to a different sheet. What might make a little more sense is to have a "date added" column rather than separate sheets, but I appreciate that might not be of interest to how you want to do things. Feel free to copy the dashboard if it interests you. I'm unlikely to keep it up to date if you're adding a new sheet every time.

Keep up the good work!
Cannikin
Posts: 173
Joined: Tue Aug 18, 2020 11:54 pm

Re: All 4K Releases Spreadsheet

Post by Cannikin »

roymi6 wrote:
Thu Jul 07, 2022 8:13 am
Hi @Cannikin, loving your spreadsheet! As my cinema room nears completion I hope to make good use of it! :D
That dashboard is awesome! Can I link to it from the first post in this thread? I bet other people would love to get that breakdown.

I don't actually maintain this list at all, it's just a digest of the data from https://thedigitalbits.com/columns/the- ... lease-list I parse each line and convert it to CSV, then import into the sheet. If that page doesn't have the data (like the difference between 2017 and 2018 releases) then I can't show it in that sheet with the current logic I have. I could add custom code to handle those cases, but it sounds like there's a lot and I don't have a complete picture of what would need to happen...

I could open source the parsing engine if someone wants to give it a try though! It's written in Ruby. Right now I just have it dump CSV to a file, then I import that into a new sheet in that spreadsheet. I didn't bother going through the work of connecting via API and creating them automatically, but that could totally be added (although Google's API used to charge based on usage though).

What I could do is just keep updating the same sheet, rather than creating a new one, that way your dashboard is always pointed to the same place, will that work? I'll make a copy before I update it, then rename the original to new date.
roymi6
Posts: 4
Joined: Thu Jul 07, 2022 7:39 am

Re: All 4K Releases Spreadsheet

Post by roymi6 »

Yeah, feel free to link it.

Ok, I hadn't looked at the source so I'd assumed you'd done it manually :)

A sure fire way to just get this working with as little effort as possible would be to just get the most up to date sheet with a constant name. Data Studio doesn't appear to allow me to import by ID. I'm only using Data Studio because it was a free solution to tinker with but i might look for a more complete solution that supports web scraping as well.

Another option is to get in touch the digital bits author to see if they've got a direct datasource we can pull from :D
Cannikin
Posts: 173
Joined: Tue Aug 18, 2020 11:54 pm

Re: All 4K Releases Spreadsheet

Post by Cannikin »

Updated list, looks like 68 new releases since last time!
https://docs.google.com/spreadsheets/d/ ... PAH7i3dStM


Cannikin wrote:
Thu Jul 07, 2022 5:36 pm
What I could do is just keep updating the same sheet, rather than creating a new one, that way your dashboard is always pointed to the same place, will that work? I'll make a copy before I update it, then rename the original to new date.
I just tried this, let me know if it works @roymi6 !
roymi6
Posts: 4
Joined: Thu Jul 07, 2022 7:39 am

Re: All 4K Releases Spreadsheet

Post by roymi6 »

Hum, I'm not seeing a "Most Recent" sheet... only ones with dates...
Cannikin
Posts: 173
Joined: Tue Aug 18, 2020 11:54 pm

Re: All 4K Releases Spreadsheet

Post by Cannikin »

roymi6 wrote:
Thu Jul 07, 2022 7:18 pm
Hum, I'm not seeing a "Most Recent" sheet... only ones with dates...
I thought your dashboard was pointing at the latest sheet, so I just updated that existing sheet with the newest releases then renamed it to match today's date...
roymi6
Posts: 4
Joined: Thu Jul 07, 2022 7:39 am

Re: All 4K Releases Spreadsheet

Post by roymi6 »

Sorry Cannikin, thought I'd replied to this but obviously didn't hit submit!

The way Google Data Studio appears to work is that it can only select a data source from a Google Sheet based on the name of the sheet rather than an index or id.

This means unless you call the most recent one something consistent (like "Latest") I'll need to change the data source every time. Annoyingly, not only do I need to change the source worksheet, I actually need to update every graph to then point at the new column in the new sheet :?

Soooo yeah... if you could name the latest one the same thing and just rename the old versions that would be appreciated :)
Cannikin
Posts: 173
Joined: Tue Aug 18, 2020 11:54 pm

Re: All 4K Releases Spreadsheet

Post by Cannikin »

roymi6 wrote:
Wed Jul 13, 2022 10:44 am
Soooo yeah... if you could name the latest one the same thing and just rename the old versions that would be appreciated :)
Ahh! Okay, renamed the latest sheet to just "Latest" and I'll keep updating that one with the new releases each month. Thanks!
Cannikin
Posts: 173
Joined: Tue Aug 18, 2020 11:54 pm

Re: All 4K Releases Spreadsheet

Post by Cannikin »

Updated Looks like 80 new titles since last time!

https://docs.google.com/spreadsheets/d/ ... PAH7i3dStM
Cannikin
Posts: 173
Joined: Tue Aug 18, 2020 11:54 pm

Re: All 4K Releases Spreadsheet

Post by Cannikin »

Updated Looks like 155 new titles since last time!

https://docs.google.com/spreadsheets/d/ ... PAH7i3dStM
Cannikin
Posts: 173
Joined: Tue Aug 18, 2020 11:54 pm

Re: All 4K Releases Spreadsheet

Post by Cannikin »

Updated

310 new titles since last time!

https://docs.google.com/spreadsheets/d/ ... PAH7i3dStM
Post Reply