Excel Spreadsheet Template For a Movie Database
#1
Cool New Member
Thread Starter
Join Date: Nov 2006
Location: Roanoke TX
Posts: 31
Likes: 0
Received 0 Likes
on
0 Posts
Excel Spreadsheet Template For a Movie Database
Hi all. After about a week of learning how to use excel 2007 for cataloging my movie collection I came up with this template. I wanted to give it out to the community as I know many people might like it.
To use it enter your movies on the Movie List Tab. There are alot of options, all which are requirments for me, so you might have to play around with it.
You can see the code for this spreadsheet by right clicking on Select Movies and view code.
I took this example
http://blog.contextures.com/archives...base-in-excel/
and made it work for me.
If there are any excel Gods out there that can make this better please let me know. One option I want to add in is a "binder location" column. I want to store all my dvds in a binder and then label them with a number and than in this spreadsheet I can enter what number its at. This makes trying to find the disc easy.
Anyways hope people can find use of this!
http://dl.dropbox.com/u/5552088/MovieDB.xlsm
To use it enter your movies on the Movie List Tab. There are alot of options, all which are requirments for me, so you might have to play around with it.
You can see the code for this spreadsheet by right clicking on Select Movies and view code.
I took this example
http://blog.contextures.com/archives...base-in-excel/
and made it work for me.
If there are any excel Gods out there that can make this better please let me know. One option I want to add in is a "binder location" column. I want to store all my dvds in a binder and then label them with a number and than in this spreadsheet I can enter what number its at. This makes trying to find the disc easy.
Anyways hope people can find use of this!
http://dl.dropbox.com/u/5552088/MovieDB.xlsm
#3
DVD Talk Hero
Re: Excel Spreadsheet Template For a Movie Database
I think one problem with keeping a spreadsheet is that a lot of us have large collections. I have over 1200 DVDs/Blu-rays. No way am I going to enter that many. It's easier to maintain and share online databases. If I buy 10 movies, they will be all entered in around 5 mins for both databases...and all the new entries are instantly available for others to view.
Spreadsheets are good if you are just starting out or have a small collection...or really love to manually enter data into spreadsheets if you have a large collection. I know there are some on here that already maintain a spreadsheet database and prefer this method.
But, it's nice that you've shared a template for those that might think it's a good option for them. Since it's not for me, I have not looked at the template. Hopefully some others can share their experiences.
Spreadsheets are good if you are just starting out or have a small collection...or really love to manually enter data into spreadsheets if you have a large collection. I know there are some on here that already maintain a spreadsheet database and prefer this method.
But, it's nice that you've shared a template for those that might think it's a good option for them. Since it's not for me, I have not looked at the template. Hopefully some others can share their experiences.
#4
Banned
Re: Excel Spreadsheet Template For a Movie Database
I keep a spreadsheet but not to keep track of all the details about a movie (year, cast, ratings, etc.) just the titles and DVD editions. So far it's helped me keep duplicates out of my collection.
#5
DVD Talk Gold Edition
Re: Excel Spreadsheet Template For a Movie Database
I also keep an Excel database, which I developed to make myself happy back when I first started collecting (in 1999) - but my primary list is in DVD Profiler - it's available online (in my signature) and can be seen by anybody who I want to see it. So - sorry - but I too have not bothered to look at your template and therefore I cannot comment on it.
#6
Re: Excel Spreadsheet Template For a Movie Database