Go Back  DVD Talk Forum > Archives > Archives > DVD Talk Archive
Reload this Page >

Do you use Excel spreadsheets to organize your DVD collection?

Community
Search

Do you use Excel spreadsheets to organize your DVD collection?

 
Thread Tools
 
Search this Thread
 
Old 06-01-04, 09:16 PM
  #1  
Member
Thread Starter
 
Join Date: Dec 2003
Location: Indiana
Posts: 182
Likes: 0
Received 0 Likes on 0 Posts
Do you use Excel spreadsheets to organize your DVD collection?

If so what are the advantages over DVDAficionado, DVD Profiler or Guzzlefish? Do you use them to keep track of how much you've spent on DVDs or what else do you use them for?
OREOSpeedwagon is offline  
Old 06-01-04, 10:20 PM
  #2  
DVD Talk Limited Edition
 
Join Date: Jan 2000
Location: east texas
Posts: 5,473
Likes: 0
Received 0 Likes on 0 Posts
i used to use excel to catalogue all of my collections. i had a very complex database with just about every concievable piece of information. then my computer crashed. now i use a program called dvdattache that was free and very easy to use. all i do i enter the ISBN number and it searches the net to find all of the details.
kevin75 is offline  
Old 06-01-04, 10:39 PM
  #3  
DVD Talk Legend
 
milo bloom's Avatar
 
Join Date: May 2001
Location: Chicago suburbs
Posts: 18,299
Received 1,410 Likes on 1,033 Posts
I used to Excel, but I was just typing in all the data, I'm not good at programming. Now I've got Aficionado and I'm perfectly satisfied.
milo bloom is offline  
Old 06-01-04, 10:44 PM
  #4  
DVD Talk Hero
 
TomOpus's Avatar
 
Join Date: Jul 2002
Location: Kansas City, MO
Posts: 40,144
Received 1,301 Likes on 945 Posts
Re: Do you use Excel spreadsheets to organize your DVD collection?

Originally posted by OREOSpeedwagon
If so what are the advantages over DVDAficionado, DVD Profiler or Guzzlefish? Do you use them to keep track of how much you've spent on DVDs or what else do you use them for?
It's tough for friends and family to check out my collection with an Excel spreadsheet locally on my PC.

I used to keep track of all the DVD info on a spreadsheet but the online collection sites make it so much easier. Plus, for Profiler, you can download reports to print out hardcopies, if needed.
TomOpus is online now  
Old 06-01-04, 10:55 PM
  #5  
DVD Talk Legend
 
Drexl's Avatar
 
Join Date: Feb 2001
Location: St. Louis, MO
Posts: 16,077
Likes: 0
Received 15 Likes on 13 Posts
I'm considering using Access to do it, but it will take a while.
Drexl is offline  
Old 06-01-04, 10:56 PM
  #6  
DVD Talk Gold Edition
 
Join Date: Oct 2000
Location: Seattle
Posts: 2,349
Likes: 0
Received 0 Likes on 0 Posts
I use an Excel spreadsheet for my collection of ~500. The only reason I really even use it is to keep track of how much I've spent on my collection, but I also have other information in it, such as where the DVD was purchased, how many discs it has, and other goofy information.

For 2004, I've also been tracking the purchase dates of my DVDs so at the end of the year, I'll be able to wonder how I was able to afford rent in certain months.

Really, the only advantage of doing a spreadsheet is that you can use it to hone your skills with Excel, or whatever program you may use. I know it's been pretty beneficial for me. I've actually been looking into using DVDProfiler recently, but I'm dreading having to go through and enter my entire collection one by one.
FatTony is offline  
Old 06-01-04, 10:57 PM
  #7  
Premium Member
 
The Cow's Avatar
 
Join Date: Jan 2000
Location: Grazing in a field somewhere...
Posts: 23,630
Received 695 Likes on 465 Posts
I use Excel to track my orders (order info and such), but after they arrive, I use an online catalog.
The Cow is offline  
Old 06-01-04, 11:08 PM
  #8  
Moderator
 
nemein's Avatar
 
Join Date: Sep 1999
Location: 1bit away from total disaster
Posts: 34,196
Received 3 Likes on 3 Posts
I do a little bit of everything

Excel to track what I own, what I have on order, what I've donated and Netflix rentals (started awhile ago when trying to figure out just what exactly my rentals/month were and I've just kept it updated). As far as what I own I just track MSRP and disk count for insurance purposes.

I also have a simple list of DVDs for the PDA/personal web site so I make sure I don't accidentally repurchase anything and it gives friends/co-workers a place to go for the complete list if they want to borrow anything (something else tracked in excel).

I use both DVDaf and Guzzlefish mainly out of habit. If it weren't for the "stats" I'd probably dump Guzzlefish as it seems the slower of the two. I like DVDaf for the fact I can create my own folders/categories. Neither of them has all the titles I own that's why I don't use either exclusively.

Edit: I also use DVDpricesearch to track my "want list"

Last edited by nemein; 06-01-04 at 11:26 PM.
nemein is offline  
Old 06-01-04, 11:14 PM
  #9  
DVD Talk Hall of Fame
 
Join Date: Jun 2001
Posts: 7,784
Likes: 0
Received 0 Likes on 0 Posts
i use excel to keep track of my want list...organize by want level (ie. 1 to 5), their columbia house status (enrollment, fullfillment, not available, etc) and their status (ordered, shipped, etc).
atari2600 is offline  
Old 06-01-04, 11:14 PM
  #10  
Senior Member
 
Join Date: Oct 2001
Posts: 674
Likes: 0
Received 0 Likes on 0 Posts
I use excel as well.
insanecollector is offline  
Old 06-02-04, 04:43 AM
  #11  
DVD Talk Platinum Edition
 
Join Date: Aug 2001
Posts: 3,193
Likes: 0
Received 0 Likes on 0 Posts
After setting up collection in DVDprofiler I exported it into an excel spreadsheet. It has the advantage of being highly customizeable- I use it mainly to keep a total number of physical DVDs in addition to the standard DVD method of counting boxsets and 2-disc sets as one DVD.

Also, I keep a running tally of:
which DVDs I've yet to watch, (14 discs currently unwatched, mostly made of the most recent Buffy/Angel/Gilmore Girls season sets)
which DVDs were "blind buys" (484 of 825 bought without seeing the feature before hand)
my personal rankings from 1 to 10 for each title I own (current overall average - 7.3).

I also have simple anime and Criterion pages with rankings just because it's sometimes nice to keep track of those subsets. And last I've got a badly out of date "Not on DVD" wishlist that I need to update. (The Accidental Tourist and The Thing (1951) ) are both still listed on that page to name a couple).
Tscott is offline  
Old 06-02-04, 05:24 AM
  #12  
New Member
 
Join Date: May 2004
Posts: 2
Likes: 0
Received 0 Likes on 0 Posts
I am using Access to organize my DVD at my PC and at the internet with Aficionado.
x1kh is offline  
Old 06-02-04, 06:37 AM
  #13  
DVD Talk Reviewer/ Admin
 
Adam Tyner's Avatar
 
Join Date: Sep 1999
Location: Greenville, South Cackalack
Posts: 28,823
Received 1,882 Likes on 1,238 Posts
I use MySQL.
Adam Tyner is online now  
Old 06-02-04, 06:53 AM
  #14  
DVD Talk Legend
 
Join Date: Apr 2002
Location: Michigan
Posts: 10,989
Likes: 0
Received 1 Like on 1 Post
I use it.
Snowmaker is offline  
Old 06-02-04, 07:03 AM
  #15  
DVD Talk Legend
 
Join Date: Jan 2001
Location: Times Square
Posts: 12,135
Likes: 0
Received 4 Likes on 2 Posts
I toss my new purchases onto DVDAF (yakes maybe 5 minutes a week total).

Then I actually watch my DVDs.
marty888 is offline  
Old 06-02-04, 07:26 AM
  #16  
New Member
 
Join Date: Apr 2003
Location: Kansas
Posts: 14
Likes: 0
Received 0 Likes on 0 Posts
There is a great program from http://www.collectorz.com called Movie Collector also. I highly recommend it.
whatever is offline  
Old 06-02-04, 08:24 AM
  #17  
DVD Talk Ultimate Edition
 
Join Date: Mar 2003
Posts: 4,389
Likes: 0
Received 0 Likes on 0 Posts
Originally posted by FatTony
Really, the only advantage of doing a spreadsheet is that you can use it to hone your skills with Excel, or whatever program you may use.
Not entirely true. I use DVDProfiler for my collection, but I also keep an Excel SS of the titles. I sort them by type of case since that is how I have my collection sorted on my shelves. It comes in handy when things get moved around and also if we have a number of guests over to make sure nothing has disappeared.
Qui Gon Jim is offline  
Old 06-02-04, 08:33 AM
  #18  
DVD Talk Special Edition
 
Join Date: Aug 2002
Location: GA
Posts: 1,397
Likes: 0
Received 0 Likes on 0 Posts
I used to use this program and then export to excel and then tweak it and create a website from it. You can check out an old version of my spreadsheet / website hybrid here. As you can see, I stopped updating that and now I use the "big 3" DVD collection sites as I like them much better.
ScottyWH is offline  
Old 06-02-04, 08:36 AM
  #19  
DVD Talk Special Edition
 
Join Date: Aug 2002
Location: GA
Posts: 1,397
Likes: 0
Received 0 Likes on 0 Posts
Originally posted by Qui Gon Jim
Not entirely true. I use DVDProfiler for my collection, but I also keep an Excel SS of the titles. I sort them by type of case since that is how I have my collection sorted on my shelves. It comes in handy when things get moved around and also if we have a number of guests over to make sure nothing has disappeared.
I think it would be pretty easy to accomplish this with DVD Profiler by specifying a location.
ScottyWH is offline  
Old 06-02-04, 10:14 AM
  #20  
DVD Talk Limited Edition
 
Ginwen's Avatar
 
Join Date: May 2002
Location: Kent, WA
Posts: 7,387
Received 21 Likes on 17 Posts
I export from DVD Profiler to a spreadsheet; I added a few extra columns to the spreadsheet where I keep track of how many times I've watched something, last time I watched, and what I thought of it. The spreadsheet is also handy for sorting by different things (for example if I have 90 minutes to watch a movie, I can sort by movie length)
Ginwen is offline  
Old 06-02-04, 10:32 AM
  #21  
DVD Talk Ultimate Edition
 
Join Date: Dec 1999
Location: NYC * See da name? Go get me some coffee...
Posts: 4,665
Likes: 0
Received 1 Like on 1 Post
I use excel. If you guys want to take a look here it is DVD Tracker
Get Me Coffee is offline  
Old 06-02-04, 10:58 AM
  #22  
DVD Talk Limited Edition
 
JuryDuty's Avatar
 
Join Date: Oct 1999
Location: Lost in Texas
Posts: 6,629
Received 33 Likes on 26 Posts
I use DVDAF for my friends to see and for PDA use.

I use Excel for me because I can be more detailed. Here is a link to look at my Excel sheet.

Man, Get Me Coffee, I LOVE your charts and graphs! Is there an easy way to set those up? I have columns very similar to yours, but can't figure out how to break them down so it counts (for instance) how many PG movies I have.

Last edited by JuryDuty; 06-02-04 at 11:19 AM.
JuryDuty is offline  
Old 06-02-04, 11:27 AM
  #23  
DVD Talk Godfather
 
Michael Corvin's Avatar
 
Join Date: May 1999
Location: Louisville, KY
Posts: 62,519
Received 913 Likes on 648 Posts
excel. that way I have it set up for what I have spent and what my cost per disc is. $6.45.

Upload it to my web page server on occasion in case the house burns down.
Michael Corvin is offline  
Old 06-02-04, 11:35 AM
  #24  
Senior Member
 
Join Date: Apr 1999
Location: Texas
Posts: 948
Likes: 0
Received 0 Likes on 0 Posts
I use excel as well, I port html to my website every once in awhile (although not to much recently) for others to look at and to my PDA for portability. I pretty much keep mine to that downloadable list (forgot the link) so when i add a title, I just copy the infor from there into my collection. Makes it simple. I've got some customization in there, but not much really....no charts and graphs yet...lol, but i do organize it by what I have up for trade, my wants, etc.
DVDave is offline  
Old 06-02-04, 12:02 PM
  #25  
DVD Talk Gold Edition
 
Join Date: Jul 2002
Location: Hawkeye Country
Posts: 2,489
Received 3 Likes on 3 Posts
Originally posted by FatTony
I use an Excel spreadsheet for my collection of ~500. The only reason I really even use it is to keep track of how much I've spent on my collection, but I also have other information in it, such as where the DVD was purchased, how many discs it has, and other goofy information.
DVD Profiler does everything you described above. You can enter the price you paid, the date you bought it, and where you bought it. Those are some of the more important things to me that you can't do with Guzzlefish, and is annoying to do with DVDaf.

Plus, with DVD Profiler you can export your collection to Excel with minimal modification to the spreadsheet.
Numes is offline  


Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.