Year | Count Titles | Cost | Currency |
2007 | 1 | 34.97 | CAD |
2007 | 5 | 44.24 | GBP |
2007 | 51 | 813.48 | EUR |
2007 | 119 | 2384 | USD |
OK... I don't expect to get any more DVDs in the next few days... so here is some totals I been keeping track of... So...
For the Year 2007...
New Titles Added: 223
Retail Price: $6,370.24
Price Paid: $2,336.48
Amount Saved: $4,033.76
Not too bad. :)
How do you find these details out?I guess besides Pete most others may have used the Charts in DVD Profiler. There is charts for Price paid as well as SRP which can be displayed by year.
:bag: I only use it to keep track of what I've got, tend not to bother with the other functions.
I guess besides Pete most others may have used the Charts in DVD Profiler.I have done it in my CCViewer, of course ;D
OK, my New Year's resolution for 2008: I will stay under $2000!
Let's see how long that will last :laugh:
It lasted until August :bag:That's only 2/3! If you extrapolate that you may end up spending as much as $3000 this year :dance:
[...]cannot help myself buying :laugh:You are preaching to the choir, Tom... ;)
But what was your best value title? :-XDefine "best value"? Emotionally? Price/Minute?
My most expensive item this year was "Smallville: Season 7" for $40,62, directly followed by the "Death Note" movie boxset for $39,99.
My first item this year was "Rodgers & Hammerstein's Cinderella".
My probably last items were today's Blu-ray titles (including "The Dark Knight", "WALL-E", "Ratatouille", "Enchanted", "Iron Man", "Spider-Man 3").
My least expensive item this year (not counting gifts) was Idaho Transfer for $0.87.
But what was your best value title? :-XDefine "best value"? Emotionally? Price/Minute?
Movies | 66 | 733.03 EUR | (11.11 per item) |
TV Series | 9 | 217.04 EUR | (24.12 per item) |
First | Stardust (R1-US, Paramount) | |
Last | The Last Days of Disco (R2-DE, Warner) | |
Most Expensive | John From Cincinatti (R1-US, HBO) | 41.25 EUR |
Least Expensive | Northfork (R2-UK, Metrodome) | 3.83 EUR |
Which makes me realise what my resolution for 2009 will be: buy less DVD!
And buy more Blu-ray :laugh:
And buy more Blu-ray :laugh:
Not for me. I'm still not sold on the whole Blu-ray bandwagon, and I still have no intention of taking the plunge anytime soon.
That was me as well. But I'm now happily on the bandwagon, snoozing at the back. In fact, I wonder if they'll let me drive it? :whistle:And buy more Blu-ray :laugh:Not for me. I'm still not sold on the whole Blu-ray bandwagon, and I still have no intention of taking the plunge anytime soon.
Not sure how to filter cost for individual years using Marks Database Query, or my phpprofiler?I've done it the old fashion way : with a pen and a paper
Just check the demo and like I've said this is the tv that is better not the media format. By the way the one with the music sheets is really exaggerated, the first one seems too blurry like the tv picture was not ajusted at all. I know that those new tv are better, I'm not again all the new technology (I don't watch my film on a 500 pound B/W TV cabinet :laugh:) I'm just not convinced that the blue ray format is that much better than the current media format.
Not sure how to filter cost for individual years using Marks Database Query, or my phpprofiler?Database Query should work.
WHERE ([Date] >= #1/1/2008#) AND ([Date] < #1/1/2009#) AND (PriceValue <> 0)
# | EUR | Ave EUR | ||||
Movies | 83 | 905.81 | 10.91 | |||
TV Seasons | 20 | 389.01 | 19.45 | |||
Total | 103 | 1294.82 | 12.57 |
EUR | Item | |||
Least Expensive | 2.50 | Waitress (http://www.imdb.com/title/tt0473308/) (R2-DE, Fox 2008) | ||
Most Expensive (Movie) | 27.56 | Fun (http://www.imdb.com/title/tt0109855/) (R1-US, Spectrum 2002) | ||
Most Expensive | 41.78 | True Blood: Season 1 (http://www.imdb.com/title/tt0844441/) (R1-US, HBO 2009) | ||
First | Slings & Arrows: The Complete Collection (http://www.imdb.com/title/tt0387779/) (R1-US, Acorn 2008) | |||
Last | Badlands (http://www.imdb.com/title/tt0069762/) (R2-UK, Warner 2003) |
Released | # | Region | # | |||
2009/10 | 32 | R1-US | 41 | |||
2008 | 26 | R2-DE | 27 | |||
<=2007 | 45 | R2-UK | 27 | |||
Other | 8 |
Movies by CoO | # | Movies by Decade | # | |||
USA | 48 | '00s | 49 | |||
UK | 13 | '90s | 16 | |||
France | 12 | '80s | 9 | |||
Other | 10 | <='70s | 9 |
Month: | Bought: | Retail: | Paid: | Saved: |
January | 16 | $549.67 | $280.18 | $269.49 |
February | 15 | $515.59 | $230.16 | $285.43 |
March | 22 | $638.51 | $186.12 | $452.39 |
April | 20 | $674.56 | $201.38 | $473.18 |
May | 13 | $566.68 | $198.71 | $367.97 |
June | 13 | $387.75 | $117.27 | $270.48 |
July | 38 | $918.11 | $108.10 | $810.01 |
August | 15 | $546.67 | $151.42 | $395.25 |
September | 25 | $773.45 | $196.08 | $577.37 |
October | 22 | $496.41 | $217.35 | $279.06 |
November | 10 | $246.74 | $86.40 | $160.34 |
December | 9 | $289.87 | $63.69 | $226.18 |
Totals: | 218 | $6,604.01 | $2,036.86 | $4,567.15 |
Emma, in some ways it is scary, but one thing I did was set a monthly budget. By tracking it properly I can see how much I've spent against or over that amount and try to pull it back the following month. To put it in perspective, I think this might turn out to be the cheapest year since 2000...
Possibly the best title of the year for that sort of thing though was Jimmy helping me get Bava's Kidnapped as I hadn't got the second Bava set with it in and it turned out to possibly be his best film. :bow:Thanks, but I owe you a lot for the Confession of ... box set sugestion and I'm sure you don't even own this British treasure :whistle:
# | Tot $ | Ave $ | ||||
Movies | 27 | 432.94 | 16.03 | |||
TV Seasons | 12 | 422.97 | 35.24 | |||
Anime | 13 | 567.19 | 43.63 | |||
Total | 52 | 1423.10 | 27.36 |
$ / Date | Item | |||
Least Expensive | 7.17 | Charlie Wilson's War (http://www.imdb.com/title/tt0472062/) | ||
Most Expensive (Movie) (tie) | 28.99 | Transformers: Revenge of the Fallen (http://www.imdb.com/title/tt1055369/) G.I.Joe: The Rise of Cobra (http://www.imdb.com/title/tt1046173/) Coraline (http://www.imdb.com/title/tt0327597/) | ||
Most Expensive | 81.99 | That 70s Show: Complete Series Stash Box (http://www.imdb.com/title/tt0165598/) | ||
First (tie) | 2009/01/03 | Wanted (http://www.imdb.com/title/tt0493464/) Horton Hears a Who! (http://www.imdb.com/title/tt0451079/) The Dark Knight (http://www.imdb.com/title/tt0468569/) | ||
Last (non-gifts) | 2009/12/24 | Supernatural Seasons 1-4 (http://www.imdb.com/title/tt0460681/) |
Wow! My SQL classes are far away (I wanted to use Tom's CCViewer)!
Possibly the best title of the year for that sort of thing though was Jimmy helping me get Bava's Kidnapped as I hadn't got the second Bava set with it in and it turned out to possibly be his best film. :bow:Thanks, but I owe you a lot for the Confession of ... box set sugestion and I'm sure you don't even own this British treasure :whistle:
Personally I haven't bought a lot of movie following the DVDC members recommandation, but I don't think it's a surprise for anyone :laugh:
I've bought all those awfull Jason Friedberg/Aaron Seltzer movies because of the bad review from Pete,
I've bought Dead Set because of Jon and it was great,
I've bought two hit and miss 50 movies boxset for the october marathon,
I've bought Art of the Devil 3 because Achim had found it for me.
Some titles are on my wishlist (one day I will buy The Girlfriend Experience), but there always something released more in my chord to pass it and my budget is very limited.
I've almost get the two Batman movie today since they were 2 for 25$ at Walmart, but they only had the Blu-rays in stock :laugh:
But how much of an influence has the forum had on your collections this year?
...
As did Goodguy with Madmen and Brick (Brick was an excellent choice, thank you, Matthias. :thumbup:).
Wow! My SQL classes are far away (I wanted to use Tom's CCViewer)!If interested, I could post some of my SQL queries I plan to use to give some ideas.
But how much of an influence has the forum had on your collections this year?
...
As did Goodguy with Madmen and Brick (Brick was an excellent choice, thank you, Matthias. :thumbup:).
Hm, difficult to say. I definitely blame Eagle Eye and Wicker Man on you (The latter wasn't that bad though). On the positive side: Fargo. Some things worked in an indirect way, instead of Malick's latest, I bought his first two. And North by Northwest prompted me to get Kusturica's opera. How's that?
Year | Currency | # Titles | Cost | Average/Title |
2009 | AUD | 1 | 82.2 | 82.2 |
2009 | DKK | 1 | 99.95 | 99.95 |
2009 | CAD | 2 | 72.92 | 36.46 |
2009 | USD | 46 | 1051.68 | 22.86 |
2009 | EUR | 75 | 879.28 | 11.72 |
2009 | GBP | 116 | 1078.23 | 9.3 |
Currency | Disc Title | Price |
AUD | M.A.S.K.: Ultimate Collection | 82.2 |
CAD | Corner Gas: Season Five | 35.86 |
DKK | Supervoksen | 99.95 |
EUR | Tum... ho na! | 2.97 |
EUR | ALAG | 2.97 |
EUR | Fight Club: Members Only | 2.97 |
EUR | Anjaam | 2.97 |
GBP | Cloverfield | 2.59 |
USD | La Femme de Chambre du Titanic | 9.3 |
Currency | Disc Title | Price |
AUD | M.A.S.K.: Ultimate Collection | 82.2 |
CAD | Corner Gas: Season Six | 37.06 |
DKK | Supervoksen | 99.95 |
EUR | Switch: Komplett. In Farbe und Bunt. | 59.45 |
GBP | The Twilight Zone: Season One | 26.88 |
USD | Death Note: Volume 2 Box Set | 42.91 |
Year | Month | # total | # TV Sets | # DVD | # Blu-ray |
2009 | 1 | 16 | 4 | 9 | 7 |
2009 | 2 | 28 | 11 | 26 | 2 |
2009 | 3 | 20 | 13 | 18 | 2 |
2009 | 4 | 13 | 7 | 10 | 3 |
2009 | 5 | 22 | 9 | 15 | 7 |
2009 | 6 | 22 | 7 | 16 | 6 |
2009 | 7 | 34 | 4 | 31 | 3 |
2009 | 8 | 14 | 3 | 13 | 1 |
2009 | 9 | 9 | 2 | 4 | 5 |
2009 | 10 | 25 | 7 | 16 | 9 |
2009 | 11 | 17 | 8 | 10 | 7 |
2009 | 12 | 18 | 8 | 10 |
SELECT YEAR(PurchaseInfo.PurchaseDate) AS [Year], PurchaseInfo.CurrencyID AS [Currency], Count(profiles.Title) AS [# Titles], ROUND(Sum(PurchaseInfo.Price), 2) AS Cost, ROUND(Avg(PurchaseInfo.Price), 2) AS [Average/Title]
FROM (Profiles INNER JOIN PurchaseInfo ON Profiles.ProfileID = PurchaseInfo.ProfileID)
WHERE ColNo<>'' AND ColType="Owned" GROUP BY YEAR(PurchaseDate), PurchaseInfo.CurrencyID
ORDER BY YEAR(PurchaseDate), Count(Profiles.Title);
SELECT PurchaseInfo.CurrencyID AS [Currency], Iif(OriginalTitle<>'', OriginalTitle, Title) AS [Disc Title], PurchaseInfo.Price AS [Price]
FROM (Profiles INNER JOIN PurchaseInfo ON Profiles.ProfileID = PurchaseInfo.ProfileID)
WHERE ColNo<>'' AND ColType="Owned" AND price in (SELECT min(price) from purchaseinfo where price > 0 and year(purchaseDate)=$Year$ and currencyID="$Currency$")
and year(purchasedate)=$Year$;
$Currency$)="SELECT CurrencyID FROM Currencies"
SELECT PurchaseInfo.CurrencyID AS [Currency], Iif(OriginalTitle<>'', OriginalTitle, Title) AS [Disc Title], PurchaseInfo.Price AS [Price]
FROM (Profiles INNER JOIN PurchaseInfo ON Profiles.ProfileID = PurchaseInfo.ProfileID)
WHERE ColNo<>'' AND ColType="Owned" AND price in (SELECT max(price) from purchaseinfo where price > 0 and year(purchaseDate)=$Year$ and currencyID="$Currency$")
and year(purchasedate)=$Year$;
$Currency$)="SELECT CurrencyID FROM Currencies"
SELECT Year, Month,sum(tit) as [# total], Sum(IIf(TagName="TV Series",Tit)) AS [# TV Sets], Sum(Iif(Medium="DVD",tit)) AS [# DVD], Sum(Iif(Medium="Blu-ray Disc", tit)) AS [# Blu-ray] FROM
(SELECT Year(PurchaseDate) as [Year], Month(PurchaseDate) as [Month], Count(title) As [tit], Medium, TagName FROM (Profiles p INNER JOIN purchaseinfo i ON i.profileid=p.profileId) left outer join (SELECT * FROM tags where tagname ="TV Series") as [t] on t.profileid=p.profileid where ColType="Owned" and price > 0 Group by Year(PurchaseDate), Month(PurchaseDate), Medium, TagName) GROUP BY Year, Month
But how much of an influence has the forum had on your collections this year?That's a cool question... Well, let's see:
But how much of an influence has the forum had on your collections this year?
Year | Currency | # Titles | Cost | Average/Title |
2010 | CAD | 1 | 26,97 | 26,97 |
2010 | EUR | 119 | 1174,99 | 9,87 |
2010 | GBP | 106 | 790,8 | 7,46 |
2010 | USD | 70 | 1077,66 | 15,4 |
Currency | Disc Title | Price |
CAD | Joey: Season Two | 26.97 |
EUR | Guddu | 2.97 |
GBP | Baabul | 1.80 |
USD | Over the Rainbow | 5.99 |
Currency | Disc Title | Price |
CAD | Joey: Season Two | 26.97 |
EUR | The Fresh Prince of Bel-Air: Season Five | 24.99 |
GBP | Get Smart: The Complete Series | 30.37 |
USD | The Office: Season Six | 38.53 |
Year | Month | # total | # TV Sets | # DVD | # Blu-ray |
2010 | 1 | 30 | 16 | 23 | 7 |
2010 | 2 | 26 | 9 | 21 | 5 |
2010 | 3 | 20 | 2 | 18 | 2 |
2010 | 4 | 28 | 8 | 22 | 6 |
2010 | 5 | 15 | 11 | 4 | |
2010 | 6 | 27 | 5 | 22 | 5 |
2010 | 7 | 28 | 2 | 23 | 5 |
2010 | 8 | 24 | 1 | 22 | 2 |
2010 | 9 | 23 | 3 | 14 | 9 |
2010 | 10 | 14 | 5 | 12 | 2 |
2010 | 11 | 25 | 6 | 24 | 1 |
2010 | 12 | 32 | 1 | 27 | 5 |
That looks cool
Count | Price | Currency | Avg |
6 | 145.76 | CAD | 24.29 |
321 | 5202.20 | EUR | 16.21 |
247 | 2996.68 | GBP | 12.13 |
1 | 3344.00 | JPY | 3344.00 |
72 | 1806.07 | USD | 25.08 |
Oh boy, I shouldn't have done that.Had you asked, we could have told you that beforehand...
(http://www.invelos.com/mpimages/50/5051892011662.4f.jpg) | (http://www.invelos.com/images/BlurayLogo.png)Mars Attacks! |
(http://www.invelos.com/mpimages/50/5051429702339.4f.jpg) | (http://www.invelos.com/images/BlurayLogo.png)The Devil's Double |
Although, looking at that phpDVDProfiler chart makes we wonder if there is a problem somehow, since 2009 is shown with less than half of that (109), which seems a bit low :hmmmm:)Possible since a lot of movie moved to 2011 from me too when I create a custom identifier. Maybe there is a bug that reset the purchase date when we move them :shrug:
I was thinking more like an incomplete update or something like that... I hope it's not actually changed in the profiles. :fingerchew: I'll have to check it out again within DVD Profiler itself.
You can also check if you have any conditionals in the localsiteconfig.php. For examply I only count profiles that have a purchase price > 0.00 to filter out all child profiles of TV sets.I do indeed have a bunch of conditions in effect, thanks or the pointer!
Total Price Paid: $17,149.22:o
Year | Price | Currency |
2000 | 246,6 | CAD |
2000 | 805,41 | EUR |
2000 | 81,96 | GBP |
2001 | 762,04 | CAD |
2001 | 1539,39 | EUR |
2001 | 674,02 | GBP |
2002 | 1255,1 | CAD |
2002 | 2303,06 | EUR |
2002 | 523,61 | GBP |
2002 | 0 | USD |
2003 | 2629,2 | CAD |
2003 | 2443 | EUR |
2003 | 381,71 | GBP |
2003 | 113,92 | USD |
2004 | 30 | AUD |
2004 | 4950,35 | CAD |
2004 | 2000,34 | EUR |
2004 | 298,8 | GBP |
2005 | 2751,14 | CAD |
2005 | 1770,35 | EUR |
2005 | 238,33 | GBP |
2005 | 477,55 | USD |
2006 | 206,84 | CAD |
2006 | 2771,03 | EUR |
2006 | 22,98 | GBP |
2006 | 233,14 | USD |
2007 | 34,97 | CAD |
2007 | 813,48 | EUR |
2007 | 44,24 | GBP |
2007 | 2384 | USD |
2008 | 371,02 | EUR |
2008 | 100,67 | GBP |
2008 | 2621,29 | USD |
2009 | 82,2 | AUD |
2009 | 72,92 | CAD |
2009 | 99,95 | DKK |
2009 | 879,28 | EUR |
2009 | 1078,23 | GBP |
2009 | 1051,68 | USD |
2010 | 26,97 | CAD |
2010 | 1174,99 | EUR |
2010 | 808,22 | GBP |
2010 | 1077,66 | USD |
2011 | 513,38 | EUR |
2011 | 1191,49 | GBP |
2011 | 851,26 | USD |
2012 | 24,95 | CAD |
2012 | 541,33 | EUR |
2012 | 396,32 | GBP |
2012 | 313,05 | USD |
Some additional stats:
SRP (converted to USD): $3900.85
Price total (converted to USD): $2277.77
Saved: $1623.08
Average: $16.04 for 142 titles
Profiles without SRP: 35
SRP/Price could not be converted: 2
2015 End Statistics:I am still not comfortable to go into too much detail about the year-end-totals, but I am happy to see, that I am down to approx. 100 purchased items in 2015 from 142 in 2014 (and 168 in 2013). Some sort of saturation point seems to have been achieved.
New Purchase Items: 110 (131 in 2014)
2015 End Statistics:I am still not comfortable to go into too much detail about the year-end-totals, but I am happy to see, that I am down to approx. 100 purchased items in 2015 from 142 in 2014 (and 168 in 2013). Some sort of saturation point seems to have been achieved.
New Purchase Items: 110 (131 in 2014)
[...] I have decided to sell off the vast majority of my collection.:stars:
[...] I have decided to sell off the vast majority of my collection.:stars:
Although....., I consider to do some heavy pruning myself at some not too distant point. There is just too much stuff I will never watch again and I might just as well get rid of them.
2015 End Statistics:I am still not comfortable to go into too much detail about the year-end-totals, but I am happy to see, that I am down to approx. 100 purchased items in 2015 from 142 in 2014 (and 168 in 2013). Some sort of saturation point seems to have been achieved.
New Purchase Items: 110 (131 in 2014)
I'm back to my 2008 value (which was the first year of recorded history for this statistic ;))
2008: 109
2009: 141
2010: 131
2011: 144
2012: 193
2013: 127
2014: 131
2015: 110
2015 End Statistics:2008: 109
New Purchase Items: 110 (131 in 2014)
2009: 141
2010: 131
2011: 144
2012: 193
2013: 127
2014: 131
2015: 110
2016: 144
2017: 108
Final tally (what I actually paid) in €: 1060.07
2015 End Statistics:2008: 109
New Purchase Items: 110 (131 in 2014)
2009: 141
2010: 131
2011: 144
2012: 193
2013: 127
2014: 131
2015: 110
2016: 144
2017: 108
Final tally (what I actually paid) in €: 1060.07
2018: 97
Tally in EUR: 633.63
Tally in GBP: 168.23
Tally in USD: 390.25
Tally in CAD: 0.00
Final tally (what I actually paid) in €: 1376.28
2015 End Statistics:2008: 109
New Purchase Items: 110 (131 in 2014)
2009: 141
2010: 131
2011: 144
2012: 193
2013: 127
2014: 131
2015: 110
2016: 144
2017: 108
Final tally (what I actually paid) in €: 1060.07
2018: 97
Tally in EUR: 633.63
Tally in GBP: 168.23
Tally in USD: 390.25
Tally in CAD: 0.00
Final tally (what I actually paid) in €: 1376.28
2019: 52
Tally in GBP: 288.26
Tally in EUR: 323.68
Tally in USD: 84.91
Tally in CAD: 5.00
Final tally (what I actually paid) in €: 802.19
2015 End Statistics:2008: 109
New Purchase Items: 110 (131 in 2014)
2009: 141
2010: 131
2011: 144
2012: 193
2013: 127
2014: 131
2015: 110
2016: 144
2017: 108
Final tally (what I actually paid) in €: 1060.07
2018: 97
Tally in EUR: 633.63
Tally in GBP: 168.23
Tally in USD: 390.25
Tally in CAD: 0.00
Final tally (what I actually paid) in €: 1376.28
2019: 52
Tally in GBP: 288.26
Tally in EUR: 323.68
Tally in USD: 84.91
Tally in CAD: 5.00
Final tally (what I actually paid) in €: 802.19
2020: 97
Tally in GBP: 670.13
Tally in USD: 95.73
Tally in EUR: 931.57
Final tally (what I actually paid) in €: 1799.55
2021: 63
Tally in USD: 193.68
Tally in EUR: 755.48
Tally in GBP: 142.60
Final tally (what I actually paid) in €: 1193.73
2015 End Statistics:2008: 109
New Purchase Items: 110 (131 in 2014)
2009: 141
2010: 131
2011: 144
2012: 193
2013: 127
2014: 131
2015: 110
2016: 144
2017: 108
Final tally (what I actually paid) in €: 1060.07
2018: 97
Tally in EUR: 633.63
Tally in GBP: 168.23
Tally in USD: 390.25
Tally in CAD: 0.00
Final tally (what I actually paid) in €: 1376.28
2019: 52
Tally in GBP: 288.26
Tally in EUR: 323.68
Tally in USD: 84.91
Tally in CAD: 5.00
Final tally (what I actually paid) in €: 802.19
2020: 97
Tally in GBP: 670.13
Tally in USD: 95.73
Tally in EUR: 931.57
Final tally (what I actually paid) in €: 1799.55
2021: 63
Tally in USD: 193.68
Tally in EUR: 755.48
Tally in GBP: 142.60
Final tally (what I actually paid) in €: 1193.73
2022: 55
Tally in EUR: 588.55
Tally in GBP: 19.83
Tally in USD: 154.92
Final tally (what I actually paid) in €: 769.91