| Author |
Message |
| Registered: October 11, 2010 |  Posts: 180 |
| | Posted: | | | | Is there any way to see the total of the suggested retail prices for my collection in DVD Profiler? thanks | | | | Blu-ray collection order; Music>Musicals>Documentaries>TV shows>Criterions>Movies |
|
| Registered: March 14, 2007 | Reputation:  |  Posts: 6,741 |
| | Posted: | | | | Tools -> Charts & Graphs -> DVD -> SRP -> Total
If you group by year you have only a few numbers left which you can add with a calculator.
(Maybe there's a better way though) | | | Karsten
DVD Collectors Online
 |
|
| Registered: May 9, 2007 |  Posts: 1,536 |
| | Posted: | | | | Another way is to use the Database Query plugin. More flexible, especially in case of mulitple currencies, although still requiring some additions. | | | | Hans |
|
| Registered: October 11, 2010 | | Posts: 180 |
| | Posted: | | | | Quoting Staid S Barr: Quote:
Another way is to use the Database Query plugin. More flexible, especially in case of mulitple currencies, although still requiring some additions. How is this done? | | | | Blu-ray collection order; Music>Musicals>Documentaries>TV shows>Criterions>Movies |
|
| Registered: October 11, 2010 | | Posts: 180 |
| | Posted: | | | | Quoting DJ Doena: Quote:
Tools -> Charts & Graphs -> DVD -> SRP -> Total
If you group by year you have only a few numbers left which you can add with a calculator.
$59.99 2010 $20,475.66 2011 Where did that 2010 come from? I uploaded my all of my collection in the last month. Oh and Thank You!  | | | | Blu-ray collection order; Music>Musicals>Documentaries>TV shows>Criterions>Movies | | | | Last edited: by jamestech |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,741 |
| | Posted: | | | | Right-click on the list header in the program, select View Columns -> Purchase Date.
Now you can sort by that column by clicking on the column header. Twice for sorting descending. Then you'll find the entry that was purchased in 2010.
When press CTRL+P you can change the purchase date. | | | Karsten
DVD Collectors Online
|
|
| Registered: October 11, 2010 | | Posts: 180 |
| | Posted: | | | | Quoting DJ Doena: Quote:
Right-click on the list header in the program, select View Columns -> Purchase Date.
Now you can sort by that column by clicking on the column header. Twice for sorting descending. Then you'll find the entry that was purchased in 2010.
When press CTRL+P you can change the purchase date. Where can I find the list header? Also, what is the difference between Total and Average SRPs? | | | | Blu-ray collection order; Music>Musicals>Documentaries>TV shows>Criterions>Movies | | | | Last edited: by jamestech |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,741 |
| | Posted: | | | |  The total is the sum of all SRPs. The average is, well, the average. If you have one DVD with an SRP of $20 and one with $10 then the average is $15 ( (20+10) / 2 ). | | | Karsten
DVD Collectors Online
|
|
| Registered: October 11, 2010 | | Posts: 180 |
| | Posted: | | | | Perfect, thank you very much DJ Doena. | | | | Blu-ray collection order; Music>Musicals>Documentaries>TV shows>Criterions>Movies |
|
| Registered: October 11, 2010 | | Posts: 180 |
| | Posted: | | | | Oh and I don't want to be nosey but your huge collection SRP must be like $300,000.00 or better, no?  | | | | Blu-ray collection order; Music>Musicals>Documentaries>TV shows>Criterions>Movies | | | | Last edited: by jamestech |
|
| Registered: October 6, 2008 | | Posts: 1,932 |
| | Posted: | | | | Quoting jamestech: Quote:
Oh and I don't want to be nosey but your huge collection SRP must be like $300,000.00 or better, no? (Rumor has it the ogre made his money on oil leases in the swamp.) |
|
| Registered: October 11, 2010 | | Posts: 180 |
| | Posted: | | | | Quoting CalebAndCo: Quote:
Quoting jamestech:
Quote:
Oh and I don't want to be nosey but your huge collection SRP must be like $300,000.00 or better, no?
(Rumor has it the ogre made his money on oil leases in the swamp.) lol! | | | | Blu-ray collection order; Music>Musicals>Documentaries>TV shows>Criterions>Movies |
|
| Registered: October 11, 2010 | | Posts: 180 |
| | Posted: | | | | Oh and I wonder if my DVD Profiler collection would be good enough for insurance purposes? I don't save receipts so the SRP is all I have.  So State Farm, you owe me like 20Gs for my blu-ray collection that went up in flames. Anyone know? | | | | Blu-ray collection order; Music>Musicals>Documentaries>TV shows>Criterions>Movies | | | | Last edited: by jamestech |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,741 |
| | Posted: | | | | Quoting jamestech: Quote:
Oh and I don't want to be nosey but your huge collection SRP must be like $300,000.00 or better, no? My collection isn't that huge (851 movies, 378 TV seasons). I just have a lot of profiles to keep track of my watched status. Also, in Germany we have a similar system like the SRP, the UVP, but that's mostly for electronic devices, not really for small items like DVDs and CDs. And lastly: What do I care if the SRP is $39.99 when Amazon.com is selling it for $24.99 in the first week of release?  Personally, I use the SRP field to keep track of my purchases in the original currency (mostly US Dollar, Canadian Dollar and British Pound) while the purchase price field is reserved for the price I paid in my own currency (€uro). | | | Karsten
DVD Collectors Online
| | | | Last edited: by DJ Doena |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 2,293 |
| | Posted: | | | | Quoting jamestech: Quote:
Oh and I wonder if my DVD Profiler collection would be good enough for insurance purposes? I dare say by itself it wouldn't be but I combine it with semi-regularly updated photos of my collection on the shelves and I believe that should be. Quote:
What do I care if the SRP is $39.99 when Amazon.com is selling it for $24.99 in the first week of release?[/blockquote[/i]
It's a better starting point for negotiations with the insurance company if the worst does ever happen. | | | | It is dangerous to be right in matters where established men are wrong |
|