I hadn't considered (since I either have or convert all of my SRP's to US dollars) that DBQ wouldn't show the SRP for movies if you were using multiple currencies.

Oh well.


bigdaddyhorse, did you load Cast & Crew data (the checkmark on the page that loads the information?) No answer needed, just a double-check. I've never seen that.

Quoting bigdaddyhorse:

Quote:
DB Queery won't show me the value of my collection, just that I've saved 76.5% from retail.

SRP of the collection can be done just by Charts and Graphs and adding up a few totals

Finally figured out my total SRP:   

Quoting Voltaire53:

Quote:
Quoting bigdaddyhorse:

Quote:
DB Queery won't show me the value of my collection, just that I've saved 76.5% from retail.

SRP of the collection can be done just by Charts and Graphs and adding up a few totals

A few totals? I have 1200+ owned and don't feel like doing that much math. I need a program or add-on to do it for me.
Unless I can do 2 charts of 600 or 3 of 400, and it adds those up so I just have to do the 2-3 totals. I get the "---" for value as well.

Quoting bigdaddyhorse:

Quote:
Quoting Voltaire53:

Quote:
Quoting bigdaddyhorse:

Quote:
DB Queery won't show me the value of my collection, just that I've saved 76.5% from retail.

SRP of the collection can be done just by Charts and Graphs and adding up a few totals

A few totals? I have 1200+ owned and don't feel like doing that much math. I need a program or add-on to do it for me.
Unless I can do 2 charts of 600 or 3 of 400, and it adds those up so I just have to do the 2-3 totals. I get the "---" for value as well.

I have 3000+ and was able to do it...

Go to the graphs chart, on the left menu select SRP -> Total and on that graph, to the right is the key listing the SRPs by year and you just add those up...

1) Do you place your DVDs into cases with the label rotated straight? Nope, unless the artwork matches the box, then I will (Simpsons)

2) Do you keep the "toys" from special-release DVDs? Yup, why throw/give them away?

3) Do you lend out your DVDs to family? Not really.

4) ... What about to friends? I have one friend I trust enough to do this with, that's it.

5) ... What about to friends of friends? Um, that would be a negative.

6) Do you rent out your DVDs? Nope.

7) Do you more often give, sell, or keep unwanted DVDs? Hmm, don't have many of these, but I've given a couple away...great gifts!

8) Do you always store your DVDs in their original cases? Yes.

9) Do you have a theater room in your home? No, but eventually I will!

10) Do you own a popcorn machine and/or soda dispenser? Nope.  Not a popcorn fan.

11) Do you or a friend invite others over for "Movie Night?" I have, but not regularly.

12) Do you ever set DVDs as background noise not for focusing on them? Yup, do this all the time with ones I've watched before. Rather than the tv on, I put on a movie.

13) Have you ever printed out custom artwork for your case cover(s)? No.

14) Have you ever put off buying a needed item so you could buy a DVD? No.

15) Have you ever returned the wrong DVD to a rental or store? Nope. I'm paranoid about this (though I only rent through the library) and always double check before returning.

16) Have you ever returned an empty case? Nope.

17) Have you ever forgotten to return a DVD for an extended length? No.

18) Have you ever had a DVD stolen from you? No

19) Have you ever accused someone of stealing a DVD from you? No

20) Have you ever bought a DVD forgetting you already owned it? I don't think so, I've a pretty good memory even before I used profiler.

21) Have you ever traded DVDs with a friend for something other than money or DVDs? No.

22) Have you ever given a bundle of DVDs away as a gift? Yes.

23) Have you ever received a bundle of DVDs as a gift? Yes.

24) Have you ever found a DVD in your collection unsure how it got there? No.

25) Have you ever been cheated on a DVD purchase (eg: badly scratched, bootleg)? Once...it was a gift for xmas for a family member and the "new" dvd turned out to scratched, opened and otherwise marked up. Returned it quite quickly and easily.

26) Have you ever received a DVD as a gift and returned it ASAP? I've had to do a replacement as the disc came scratched, but not a straight return.

27) Have you ever double-dipped solely for new special features? Yes.

28) Have you ever watched two DVDs/movies at the same time? No.

29) Have you ever given away a movie ending just to make someone mad? No.

30) Have you ever turned subtitles on because you could not understand the words? Yes. I don't buy dvds for subtitles, but they have come in handy when someone mumbles and I prefer them on foreign language films rather than dubs.

31) Have you ever used subtitles to try and learn another language? No.

32) Have you ever used a DVD for something other than playing it? Nope.

33) Have you ever forgotten about something important because of watching a movie? No.

34) Have you ever gotten rid of a DVD only for not liking the special features/artwork? No.

35) What are your favorite movies in your collection? Dirty Dancing, Princess Bride, Hairspray (original), The Wizard of Oz...I could go on for quite a while, so I'll quit right here.

36) What are your least favorites? Fever Lake. One reason and one reason only that I have this: My college is featured in the first 10 minutes and it's fun to watch because of that. I've never gotten past the first 30 minutes because of how awful this movie is.

37) What is the most you ever paid for a DVD? $84.39

38) What is the year in which you spent the most on DVDs? 2009 (as a side bit, this year is looking to be the least I've ever spent...)

39) What is the longest amount of time you have watched movies without a break? Couldn't tell you, but I've done tv marathans watching a season...

40) What is the largest number of DVDs you have bought at one time? Not sure, but probably about 10 or so, during Turkey Day.

41) What is the oldest DVD-movie in your collection by production year? 1891 (Edison: Invention of the Movies set)

42) What is/are your favorite movie line(s)/speech(es)? "This is not a tragedy. Tragedy is three men trapped in a mine, police dogs used in Birmingham. Monks burning themselves in protest."

43) How many DVDs are in your collection? 834, but I count box sets as one, not one per movie.

44) How many unwatched DVDs are in your collection? According to profiler, 543, but this is inflated because of child profiles and I didn't start using the watched as part right away.

45) How many double-dips do you have in your collection (2 copies is one double dip; 3 copies is 2)? 11, but 3 are from box sets, where I bought the movie as a stand alone, then I ended up with another copy b/c it was in with another movie I wanted and it was cheaper to buy both than getting it singly.

46) How many TV seasons (broken down, not complete series) do you own? 136ish

47) Using Database Query, who is the most common actor/actress in your collection? David Boreanaz (I have Angel, Buffy and Bones in my database).

48) ... Most common crew member? Joss Whedon. (See above, plus add Firefly).

49) ... Most common year of production? 1990's.

50) Using Database Query, what is the SRP of your collection? 26,477.96

Funny thing I discovered involving question 20 (Have you ever bought a DVD forgetting you already owned it?)

A few months ago I had bought Idle Hands on DVD only to discover it was the full screen version and being a purist, I wanted the widescreen version so I went on the Amazon Marketplace and picked one up on the cheap. Artwork was in poor condition but the disc had some light scratches and played fine so I just switched the FS artwork. Anyway, this morning I was going through some DVDs and tucked away in a little box was... Idle Hands, WS/FS flipper disc like the one I had bought used except this one was in pristine condition (both the disc and artwork) so I must have bought it years ago new before Sony switched it out for FS only versions.

I can laugh at this since I only paid a few bucks for the other but I can only shake my head.

1) Do you place your DVDs into cases with the label rotated straight?
No.
2) Do you keep the "toys" from special-release DVDs?
I've never bought a release that comes with a special "toy." Closest thing to it is editions with special cases, and for those, yes I do keep them.

3) Do you lend out your DVDs to family?
No. I don't have any relatives that lives in the same time zone as me.

4) ... What about to friends?
Yes.

5) ... What about to friends of friends?
No.

6) Do you rent out your DVDs?
No.

7) Do you more often give, sell, or keep unwanted DVDs?
Sell.

8) Do you always store your DVDs in their original cases?
Yes.

9) Do you have a theater room in your home?
Yes.

10) Do you own a popcorn machine and/or soda dispenser?
No.

11) Do you or a friend invite others over for "Movie Night?"
No.

12) Do you ever set DVDs as background noise not for focusing on them?
No.

13) Have you ever printed out custom artwork for your case cover(s)?
No.

14) Have you ever put off buying a needed item so you could buy a DVD?
No.

15) Have you ever returned the wrong DVD to a rental or store?
No.

16) Have you ever returned an empty case?
No.

17) Have you ever forgotten to return a DVD for an extended length?
No.

18) Have you ever had a DVD stolen from you?
No.

19) Have you ever accused someone of stealing a DVD from you?
No.

20) Have you ever bought a DVD forgetting you already owned it?
Yes.

21) Have you ever traded DVDs with a friend for something other than money or DVDs?
No.

22) Have you ever given a bundle of DVDs away as a gift?
Yes.

23) Have you ever received a bundle of DVDs as a gift?
Yes.

24) Have you ever found a DVD in your collection unsure how it got there?
No.

25) Have you ever been cheated on a DVD purchase (eg: badly scratched, bootleg)?
No.

26) Have you ever received a DVD as a gift and returned it ASAP?
Yes.

27) Have you ever double-dipped solely for new special features?
No.

28) Have you ever watched two DVDs/movies at the same time?
No.

29) Have you ever given away a movie ending just to make someone mad?
No. As far as I'm concerned, willfully doing this is punch-in-the-nose worthy.

30) Have you ever turned subtitles on because you could not understand the words?
On movies where I don't speak the language: Of course.
On movies where I do speak the language: No.

31) Have you ever used subtitles to try and learn another language?
No.

32) Have you ever used a DVD for something other than playing it?
No.

33) Have you ever forgotten about something important because of watching a movie?
Hmm... not that I recall. Which I guess means "No." If it was important, you'd think I'd remember
having forgotten it.

34) Have you ever gotten rid of a DVD only for not liking the special features/artwork?
No.

35) What are your favorite movies in your collection?
Favourite movies or favourite DVDs? Favourite movies, I'd guess maybe Seven and The Dirty Dozen. Favourite DVDs... that one's harder. Probably the extended cuts of Lord of the Rings, or maybe the most recent Blade Runner edition.

36) What are your least favorites?
Smokey & The Bandit 3 - both for least favourite "movie" and least favourite DVD. It's non-anamorphic, has really poor picture quality, and the movie itself utterly sucks too. I only own it cause it's part of a box set, and doesn't have individual packaging.

37) What is the most you ever paid for a DVD?
No idea. Probably around $30 or so.

38) What is the year in which you spent the most on DVDs?
2005

39) What is the longest amount of time you have watched movies without a break?
Don't know. I'd guess 7-14 days or thereabouts.

40) What is the largest number of DVDs you have bought at one time?
Also don't know. Maybe 10 or so.

41) What is the oldest DVD-movie in your collection by production year?
Nosferatu from 1922, after that Murder from 1930.

42) What is/are your favorite movie line(s)/speech(es)?
"Deep down in places you don't wanna talk about at parties, you want me on that wall, you need me on that wall..." Don't remember the whole speech, but it's a good one.

43) How many DVDs are in your collection?
1513 profiles. Not sure how many DVDs.

44) How many unwatched DVDs are in your collection?
179

45) How many double-dips do you have in your collection (2 copies is one double dip; 3 copies is 2)?
Two or three maybe.

46) How many TV seasons (broken down, not complete series) do you own?
27

47) Using Database Query, who is the most common actor/actress in your collection?
Bruce Willis, 34 titles.

48) ... Most common crew member?
Anna Behlmer, 37 titles. Apparently she's a sound mixer.

49) ... Most common year of production?
1999. I didn't know this, but I'm not surprised. I've long considered 1999 to be one of the greatest movie years in recent memory.

50) Using Database Query, what is the SRP of your collection?
$56,000