Page 5 of 7
Re: All 4K Releases Spreadsheet
Posted: Sat Feb 19, 2022 11:51 pm
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
Re: All 4K Releases Spreadsheet
Posted: Tue Feb 22, 2022 3:39 pm
by J8GDN
Great spreadsheet !!
Re: All 4K Releases Spreadsheet
Posted: Mon Mar 28, 2022 7:21 am
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!
Re: All 4K Releases Spreadsheet
Posted: Wed May 25, 2022 10:57 pm
by Cannikin
Updated with latest releases, looks like 105 new releases since last time!
https://docs.google.com/spreadsheets/d/ ... PAH7i3dStM
Re: All 4K Releases Spreadsheet
Posted: Thu Jul 07, 2022 8:13 am
by roymi6
Hi @Cannikin, loving your spreadsheet! As my cinema room nears completion I hope to make good use of it!
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!
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!
Re: All 4K Releases Spreadsheet
Posted: Thu Jul 07, 2022 5:36 pm
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!
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.
Re: All 4K Releases Spreadsheet
Posted: Thu Jul 07, 2022 6:18 pm
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
![Very Happy :D](./images/smilies/icon_biggrin.gif)
Re: All 4K Releases Spreadsheet
Posted: Thu Jul 07, 2022 7:07 pm
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 !
Re: All 4K Releases Spreadsheet
Posted: Thu Jul 07, 2022 7:18 pm
by roymi6
Hum, I'm not seeing a "Most Recent" sheet... only ones with dates...
Re: All 4K Releases Spreadsheet
Posted: Thu Jul 07, 2022 9:15 pm
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...
Re: All 4K Releases Spreadsheet
Posted: Wed Jul 13, 2022 10:44 am
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
![Smile :)](./images/smilies/icon_smile.gif)
Re: All 4K Releases Spreadsheet
Posted: Wed Jul 20, 2022 4:37 pm
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!
Re: All 4K Releases Spreadsheet
Posted: Mon Aug 29, 2022 5:26 pm
by Cannikin
Re: All 4K Releases Spreadsheet
Posted: Thu Dec 15, 2022 6:02 pm
by Cannikin
Re: All 4K Releases Spreadsheet
Posted: Mon Jun 12, 2023 9:26 pm
by Cannikin