Movie Store Tracker

[SimonSays]

I've posted about this before, but thought I'd share with the community.

Many of us find it hard to track which movies we have, which ones we've watched, trying to pick a movie, seeing if we have all movies in a set, and so on.

So from day 1, I've used an Excel sheet to track movies on my wishlist and in my collection, and many attributes connected with them. Over the last 2 years, I've updated the sheet with more graphics, calculations, filters, and so on.

So, downloaded or not, I can easily track which movies I have, and if I've watched the movie.

Here are some of the features, with screenshots from my own sheet.

1) Header
Number of owned movies, wishlist, $$ value you've spent, $$ value you would have spent if you paid in full for each movie, $$ savings using D2D offers, and many more.



2. Tabs
Tabs for Movies, Series and Documentaries, Music, and Demos, plus 2 sheets with collection data and order history



3. Movie entries.
Various fields I copy from the movie page in the Kaleidescape Store, for which I include the URL.
I mark which movies I purchased using D2D offers. If the D2D offer is bad, and I buy the movie during a sale at a better price, I remove the X.

I also track movies that are in my wish list. Basically, I put an entry whenever I see a movie I'd like, in my sheet, and add it to my wish list on K as well. That way, I know I have the entry ready to go in my sheet when I purchase the movie.

I marked a movie in red, because I want to wait watching it until I get the 2nd movie in that set (Another 48 Hrs.) Because the sheet has filters I use all the time, you can't always tell if you've got all the movies in a set when using the "Owned / Not Seen" filter.




4. Filters
I have a few filters I can quickly switch between:

- No filters allows me to add movies in line, and play around with any manual filters I like.
- Owned / Unwatched is my main view, allowing me to track which movies I haven't seen yet
- AMI Top 100 shows me the American Movie Institute Top 100 Movies. Some of these movies are not available in the store yet though.

 

[SimonSays]

I have noticed that the quick button doesn't automatically show up on a new computer, so you may need to add it manually just once:
(mine is on a Mac, Windows PC may differ)

5. AMI List + Watched

To the right of the sheet, you can find the AMI Top 100, and I use the column to mark which movies I've watched. I also use the NOTES column for comments like upgrading a previously purchased movie to 4K, as I update the Price Paid column accordingly.
Some statistics at the top to show how much you've watched.


6. Colors

I use colored cells for time, price etc. The time one is useful to quickly find a movie in the time range you're interested in. Have about 90mins, pick green (under 90min), have a full evening to fill, pick a purple one (over 180min) and so on.

Also, for each entry, you can enter if you own it, it's on your wishlist, or it's not (yet) available on the store)

 

[SimonSays]

7. Statistics / Graphs

I'm a data nerd, so you can find some Statistics and Graphs on the Validation sheet




8. The Good / The Bad

So the good thing about this sheet, is that it's free. I made it for myself, and decided to create a somewhat cleaned up copy for you all to use, no charge. It's served me well.

The bad is that you need to enter everything manually. If you're just starting out, it's no big deal, but if you have 1000 movies, it's a bit of a pain.
But as I've updated the sheet a few times, going through 1000 movies to update something doesn't take that long.
Once you've put everything in, daily maintenance is easy peasy.

I can group movies the way I like it, such as entering a prefix like "James Bond |" in front of the movies, so I can have them all together and they're easy to find. I also used information I found online to group movies in the DC Universe and Marvel Universe and order them according to the time line they are supposed to occur in. Great in case you want to watch them in the correct order:

 

[SimonSays]

So the template comes pre-filled with the AMI top 100, plus a few other movies, to give you an idea of how I use the sheet.
Feel free to remove the movies you're not interested in, and update the movies you want or have, accordingly.

Here is the link to download it:

Simon's Movie Store Tracker

Of course, feedback welcome. I'm happy to tinker around to add more features, or if someone is a bit handy and can automate some things, I'd love to hear about it.

Enjoy!

Simon

 

[LoveCinema]

As a fellow data nerd with a many-tabbed spreadsheet, my hat is off to you. Thank you for sharing this resource.

 

[josh]

Wow! That's not your basic level excel tracking sheet...
super impressive.

 

[SimonSays]

As a fellow data nerd with a many-tabbed spreadsheet, my hat is off to you. Thank you for sharing this resource.

Wow! That's not your basic level excel tracking sheet...
super impressive.

Glad you all like it. I hope it proves useful to someone!

 

[Aburguy]

Thanks I love data as well but don’t have this ability in excel. I’m going to use this, I was using a paid app, but once I saw Kscape lets me see my movies (newbie never knew) I cancelled the subscription.

 

[SimonSays]

Thanks I love data as well but don’t have this ability in excel. I’m going to use this, I was using a paid app, but once I saw Kscape lets me see my movies (newbie never knew) I cancelled the subscription.

Let me know how you get on, and any feedback you may have!

 

[Aburguy]

Let me know how you get on, and any feedback you may have!

Thanks will do

 

[Aburguy]

Let me know how you get on, and any feedback you may have!

Sorry first snag, Im on a Mac, have excel for mack but it does not seem google sheets is available for Mac or is it? Doesn't seem to like it when I try excel.

 

[SimonSays]

Sorry first snag, Im on a Mac, have excel for mack but it does not seem google sheets is available for Mac or is it? Doesn't seem to like it when I try excel.

I have a Mac and use Excel for Mac. Should work fine. I shared it through Google Drive, so it probably tries to open it in Google Sheets. See if you can download it directly as an XLSX file?

 

[Aburguy]

I have a Mac and use Excel for Mac. Should work fine. I shared it through Google Drive, so it probably tries to open it in Google Sheets. See if you can download it directly as an XLSX file?

Perfect that worked, thanks.

 

[SimonSays]

Perfect that worked, thanks.

The only thing I had to do when I first opened it on a new Mac, was put the button for the different views / filters back in the "Quick Access Toolbar". Seems that is only saved to your local Excel instance, it's not tied to a sheet.

Just click the ellipses (...), then "More Commands". The command you're looking for is "Save Custom View". Just drag the icon over to the right, and it should be there.

 

[Aburguy]

The only thing I had to do when I first opened it on a new Mac, was put the button for the different views / filters back in the "Quick Access Toolbar". Seems that is only saved to your local Excel instance, it's not tied to a sheet.

Just click the ellipses (...), then "More Commands". The command you're looking for is "Save Custom View". Just drag the icon over to the right, and it should be there.

Awesome going to do a deep dive into thugs weekend