Topic: Some Year End Totals...

[Tom]

Here my statistics (boxsets always count as one).

Money spent:

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

Least expensive:

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

Most expensive:

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

Purchased by month:

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

First bought: Fantastic Four: Rise of the Silver Surfer (Blu-ray)
Last bought: Terminator Salvation (Blu-ray)

[Tom]

SQL statements used:

Money spent:

Code: [Select]

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);
where I only count titles which have collection type "Owned" and have a collection number entered (I give a number to each purchase item, i.e. boxsets have one, child profiles have none)

Min Price:

Code: [Select]

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"
Max Price:

Code: [Select]

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"
Purchased by month:

Code: [Select]

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
where I distinguish TV boxsets by setting a tag called "TV Series" and where I do not count gifts.

Hint:
In CCViewer, if you right-click on the result table of the SQL query, you can copy the result to the clipboard. You are asked to enter how the columns should be divided. If you enter "bbcode", a table which can be used in the forum is generated.

[Achim]

But how much of an influence has the forum had on your collections this year?

That's a cool question... Well, let's see:

I think the Dr. Horrible's Sing-Along Blog came from this forum, although the web series was released last year. Who brought it up originally? Karsten?

Let the Right One In was "recommended" by Tom. It is so good, I bought it twice (of course not, I bought it twice because the Magnolia release has terrible subtitles and they refused to suck it up).

Mario Bava Collection I + II by Jimmy with some support from Jon, I think.

The Bourne Trilogy by Jon, I think? Anyway, I don't recall anyone here disliking them...

Dead Set was originally mentioned here by Jon.

Black Christmas by Jimmy.

Fear Itself by Pete (although technically not on this forum and I think he already pointed it out to me last year).

The Gate by Jimmy.

The New York Ripper was supported by Jimmy's comments.

Castle: The Complete First Season by lovemunkey, although technically through Facebook.

I apologize if I should have any of my references wrong.


So, coming to this forum is no cheap matter

[Kathy]

But how much of an influence has the forum had on your collections this year?

I wish I had kept track...no maybe not because of this forum I bought way too many DVDs. I don't remember who recommended most, sorry, but then you can't be blamed! I'm sure I've forgotten many but, off the top of my head:

Brick: Matthias (thanks Jon)

Due South: Tom

Opening of Misty Beethoven: Jimmy

50 First Dates: Tom (I think)

Alfred Hitchcock: The Masterpiece Collection: Karsten (I think) posted this when it was on sale

Mist: Jon

The Complete Monty Python Flying Circus: ?

3:10 to Yuma (1957): Roger

History of Violence: Karsten

Cloverfield: ?

Dead Like Me: The Complete Collection: ?

Awakenings: Pete (I think)

Charmed: ? I bought all 8 seasons from someone here who was upgrading

Angel: Collectors Limited Edition: ?

The Station Agent: Jon or Rich

Sweeney Todd: The Demon Barber of Fleet Street: ? But definitely not Pete

Ringu: ?

Driving Miss Daisy: Tom (I think)

The Sea Inside: Eric

Angels in America: ?

Hairspray (2007): ?

Wonderfalls: ?

Tremors: Pete or Jon

House: ?

Veronica Mars: ?

The Treasure of the Sierra Madre: Antares

The Shawshank Redemption

I know there are more but I can't think without my morning coffee. I might have to give up these forums because I have even more on my wish list!







 

[Tom]

I didn't keep track what was bought because of an recommendation or review here, but I am trying anyway:

You Can't Take It With You (Jon?)
Fingersmith (?)
Tipping the Velvet (?)
Life on Mars: Series 1 (Jon)
Time Tunnel (Pete)
This Ugly Yet Beautiful World (Sébastien's WhatYaGot)
A Time to Kill (Karsten?)
Freedom Writers (Eric?)
Oranges Are Not the Only Fruit (?)
Grave of the Fireflies (Sébastien)
Kleinruppin forever (Karsten)
Veronica Mars (Pete/Karsten)
Kiss Kiss Bang Bang (Jon?)

[movielovers0]

I have never actually kept track in a year period how much i have added or price comparison to what i paid and what i saved. I am planning on doing this now that i see this post and find it may be an interesting endevour! Seeing as how my main goal at this point (as i am sure is the same with a lot of collectors) is replacing my well watched VHS collection..currently standing at a measly 450 now... i am able to find alot of titles at flea markets and yard sales. I may spend 1-2 dollars a piece for my little treasures! I must have added approx. 700 or so titles last year and may have spent 1000 bucks! My collection all told is around 4000 movies..of course this includes VHS DVD Blu-Ray HD and my newest addition of Laserdiscs..which I just started collecting about a year ago and has grown to almost 400 titles.
I will try to keep a good track of this stuff and see where i end up!!!

[DJ Doena]

2010 End Statistics:

New Purchase Items: 131 (141 in 2009)
New Movies: 93 (thereof Blu-ray: 36)
New TV Seasons: 54 (thereof Blu-ray: 7)
New TV Specials: 17
New Special Interest: 1 (thereof Blu-ray: 1)

Money Spent: 1,586.10€ (1,869.30€ in 2009)
Money Spent on Movies: 684.18€
Money Spent on TV Seasons: 813.53€
Money Spent on TV Specials: 78.41€
Money Spent on Special Interest: 9.98€

Avg Spent: 12.11€ (13.26€ in 2009)
Avg Spent on Movies: 7.36€
Avg Spent on TV Seasons: 15.07€
Avg Spent on TV Specials: 4.61€
Avg Spent on Special Interest: 9.98€

Runtime: 45,592m (31d 15h 52m)
Runtime Movies: 10,647m (7d 9h 27m)
Runtime TV Seasons: 33,491m (23d 5h 11m)
Runtime TV Specials: 1,349m (22h 29m)
Runtime Special Interest: 105m (1h 45m)

Cheapest Item: Superman: Vol. 1 (1.00€)


Most Expensive Item: Torchwood: The Complete Series (42.99€)


First Item: How I Met Your Mother: Season 3 (0.00€)


Last Item: V for Vendetta (9.99€)


Purchase by Locality:
United States: 17
Canada: 6
United Kingdom: 80
Germany: 28

[Najemikon]

I never post the actual figures, I know, but this year has been my cheapest since 2001 and my number of titles (89) is consistent with recent years. It helped winning those vouchers of course! I didn't just spend them on DVD/Blu-Ray, but still, it was a healthy chunk.

[Critter]

I actually don't have any DVD year end totals, but I do have cinemas ones. I try to keep track of what I see at the cinema.

During 2010:

I went to the cinema 31 times.

I saw 22 different movies.

The movies I saw the most were Kick-Ass which I saw 4 times and Toy Story 3 which I saw 3 times.

The first movie seen was Avatar in January, and last was TRON: Legacy in December.

The movie that I enjoyed the least was Get Him to the Greek. I would give it 1/5

The movies I enjoyed the most were Toy Story 3, Kick-Ass, Animal Kingdom and Soctt Pilgrim vs the World. I would give them 5/5

[Dr. Hasslein]

Here are some of my totals...

DVD Purchases: 63

Blu-ray Purchased: 25

I think I only went to the cinema 5 times this year.

I saw The Wolfman, Kick-Ass, Shutter Island, Inception and Piranha 3D.

The movie I enjoyed the least was The Wolfman. 3/5

The movie I enjoyed the most was Shutter Island. 4/5

[Jimmy]

2010 End Statistics

Purchase Items: 106

Money Spent: 399.43 $US / 518.92 $CAN / 66.84 € /  50.04 £

Cheapest Item (gift and reward not included) : The Wicker Man (1.98£)


Most Expensive Item: Blonde Ambition (29.99 US$)


First Item: Carter Steven's Collegiates Features Film Collection


Last Item: Vampire Circus

[addicted2dvd]

2010 was huge for me... as I was literally given hundreds of DVDs... including many boxsets and many TV Series.

Items Purchased/Gifts: 553
SRP: $14,391.97
Paid: $855.07
Saving: $13,536.90

[Najemikon]

That's mad, Pete! That's well over half my collection. 

[Blair]

For 2010:

Purchased: 11
Gifts: 49  (my average per year is usually 22, but half were given to me by one friend)
SPR: $2,011.74
Paid: $82.63 (3 were new TV series sets)

Favorite movie of the year: Toy Story 3
Least Favorite: The Last Airbender 

[Achim]

2010:

I bought 152 items. That is more than 2009 (109) but still less than 2008 (192). I am making an effort to be more conscious about purchases; doesn't always work out though.

The first item added to my collection was:
Outnumbered: Series One & Two


The last was: