Release List Reviews Shop Join News DVD Giveaways Video Games Advertise
DVD Reviews | Theatrical Reviews | Adult DVD Reviews | Video Game Reviews | Price Search Buy Stuff Here
DVD Talk
DVD Reviews DVD Talk Headlines HD Reviews


Add to My Yahoo! - RSS 2.0 - RSS 2.0 - DVD Talk Podcast RSS -


Go Back   DVD Talk Forum > DVD Discussions > DVD Talk

DVD Talk Talk about DVDs and Movies on DVD including Covers and Cases

Reply
 
Thread Tools
Old 12-08-10, 04:22 PM   #1
putnum
Cool New Member
 
Join Date: Nov 2006
Location: Roanoke TX
Posts: 31
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
  Reply With Quote
Old 12-09-10, 09:09 AM   #2
putnum
Cool New Member
 
Join Date: Nov 2006
Location: Roanoke TX
Posts: 31
Re: Excel Spreadsheet Template For a Movie Database

There have been 83 views on this...Just wondering what everybody thinks about it?
  Reply With Quote
Old 12-09-10, 09:20 AM   #3
TomOpus
DVD Talk Hero
 
TomOpus's Avatar
 
Join Date: Jul 2002
Location: Kansas City, MO
Posts: 25,978
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.
__________________
"Pear Pimples for Hairy Fishnuts!"

My So-Called DVD Life (Profiler),A Fistful of Discs (DVDAf)
  Reply With Quote
Old 12-09-10, 11:13 AM   #4
mike07
Banned
 
Join Date: Mar 2009
Posts: 1,683
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.
  Reply With Quote
Old 12-09-10, 06:58 PM   #5
danwiz
DVD Talk Special Edition
 
danwiz's Avatar
 
Join Date: Dec 2000
Location: Mitaka, Tokyo, Japan
Posts: 1,700
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.
__________________
My DVD Collection (DVD Profiler)
[removed link to site]
  Reply With Quote
Old 12-10-10, 01:42 AM   #6
calhoun07
DVD Talk Legend
 
calhoun07's Avatar
 
Join Date: Oct 2001
Posts: 14,370
Re: Excel Spreadsheet Template For a Movie Database

Quote:
Originally Posted by putnum View Post
There have been 83 views on this...Just wondering what everybody thinks about it?
If it works for you. I created my own spread sheet that suits me just fine. I don't need to categorize the movies in my collection. Or the ratings of the movies, either.
__________________
You can only please a woman with a dick made out of chocolate that ejaculates money.-Rhemus
Windowless vans do NOT have candy, only rape.
  Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


All times are GMT -5. The time now is 08:55 PM.

Rules - DVD Talk - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Copyright 2011 DVDTalk.com All Rights Reserved. Privacy Policy and Terms of Use.