Steam account value versus dollars spent and unplayed Steam games

I'm sure everyone has seen the various Steam calculator sites that let you type in your Steam ID to find out just how much your Steam account is actually worth by tallying up the current price of every game in your library. It's a fun way to see how much money you've actually wasted on games. Well, sort of, anyway. Since it uses the current price of the games to come up with a total value they don't factor in what you've actually spent, just what they are worth right now.

Some games tend to hold their value while others drop to bargain bin prices within months of their release. Games like Alpha Protocol, Witcher 2, New Vegas, etc I paid full price for on day one, but they are worth less than half (or in some cases as low as 15-20%) of their original prices even when not on sale. Realizing this, I copy/pasted my Steam Store Transaction History and dumped it into a spreadsheet and filtered it to get an actual dollar sum to compare to the dollar sum provided by the Steam calculators.

I was pleased (and surprised) to see that the two numbers actually ended up being about the same. I guess the games that I bought at full price but that depreciated quickly are balanced out by the games that I bought on sale that later returned to their original higher price. It's not perfect, because it doesn't factor in Steam key obtained from other sources such as online retailers or hardware bundles, but the two numbers were within 5% of each other.

So my question is, has anyone else every checked this? Is there a Steam calc website that does the calculation off of recorded store transactions rather than your library (probably not since that info isn't likely exposed through the public API)? How big is the difference between your account value and the dollars you spent?

This is the site I used: http://steamdb.info/calculator/

Bonus question: The particular calc I'm using had one additional data point I hadn't seen before, a column labeled "Games Not Played". Apparently, 42% of my Steam library consists of games that I own but have not fired up even once. How many unplayed games do -you- have in your account?

-Byshop

* *Worth:* $2185.78

* *Games owned:* 155

* *Games not played:* 36

* *Percentage:* 23%

* *Hours spent:* 4,799.7h

* *Worth:* $2185.78

* *Games owned:* 155

* *Games not played:* 36

* *Percentage:* 23%

* *Hours spent:* 4,799.7h

wis3boi

I don't feel quite as bad. :) My total number of games is higher but my hours spent is way lower.

-Byshop

* *Worth:* $3294.51 * *Games owned:* 279 * *Games not played:* 118 * *Percentage:* 42% * *Hours spent:* 2,456.2hTokeism

Woohoo! We tied for percentage of unplayed games. :)

-Byshop

Worth: $6723.92
Games Owned: 496
Games Not Played: 208 (42%)
Hours Spent: 3,191.3h

When I did the total of the store transactions, it came out to about $6,400 or so. Again, that's not perfect because it doesn't account for keys I bought outside of Steam. Also the transaction log only appears to go back to 2007 so items like my original purchase of Half Life 2 don't show up. Still, I was shocked to see how close these numbers were considering how many $50-$60 games I bought that are now $5-$10.

-Byshop

Worth: $6723.92
Games Owned: 496
Games Not Played: 208 (42%)
Hours Spent: 3,191.3h

When I did the total of the store transactions, it came out to about $6,400 or so. Again, that's not perfect because it doesn't account for keys I bought outside of Steam. Also the transaction log only appears to go back to 2007 so items like my original purchase of Half Life 2 don't show up. Still, I was shocked to see how close these numbers were considering how many $50-$60 games I bought that are now $5-$10.

-Byshop

Byshop

Okay, I don't feel so bad then. It seems that a lot of people have between 20-40% unplayed games in their libraries. I'm guessing that it's all those indy bundles where you pay $10 for one or two games you actually want and then you get 8 other games you don't give a crap about.

-Byshop

geez, apparently i need to be doing some more gaming

* *Worth:* $776.43

* *Games owned:* 59

* *Games not played:* 29

* *Percentage:* 49%

* *Hours spent:* 428.6h

Worth : 3167.02
Owned : 250
Not played : 62 (25%)
Hours spent : 3837.1 

Amazing.

* *Worth:* $1696.99

* *Games owned:* 140

* *Games not played:* 45

* *Percentage:* 32%

* *Hours spent:* 758.8h

Mine's a little misleading as I usually open up any game I've installed and I'll configure the settings. So I truly have much more than only 45 not played. :(

* *Worth:* $2859.79

* *Games owned:* 267

* *Games not played:* 123

* *Percentage:* 46%

* *Hours spent:* 1,031.3h

Worth:* $1587.06

Games owned:* 118

Games not played:* 56

Percentage:* 47%

Hours spent:* 2,546.6h

Great gods, I haven't played 47% of my games. I actually don't know how to feel about that, other than shocked.

Worth:* $1587.06

Games owned:* 118

Games not played:* 56

Percentage:* 47%

Hours spent:* 2,546.6h

 

Great gods, I haven't played 47% of my games. I actually don't know how to feel about that, other than shocked.

Shryke888

Yeah, when I realized I had over 200 games that I apparenlty had never played I was surprised to say the least. To be fair, at least some of them are games that I -have- played (and maybe even beaten), but have just never played on Steam. For example, when I bought DMC it came bundled with Devil May Cry 3 and 4 which are two games that I already played on consoles so I had no reason to install them.

On the other hand, some are legit games that I deliberately purchased (and not as a part of a pack) that I simply haven't gotten around to. Dead Rising 2: Off the Record I bought on sale but I haven't played it yet because I haven't beaten DR2 yet.

-Byshop

* *Worth:* $1795.55

* *Games owned:* 179

* *Games not played:* 34

* *Percentage:* 19%

* *Hours spent:* 2,870.2h

i have a second question for you guys, how long have you been with steam this is my 8th year.

i have a second question for you guys, how long have you been with steam this is my 8th year.

4StringSamurai

I forget where to look but I think I remember the year showing as 2004.

-Byshop

Oh what the hell.  I'll be a groupie and join in....hah

* *Worth:* $1547.25

* *Games owned:* 99

* *Games not played:* 30

* *Percentage:* 30%

* *Hours spent:* 423.8h

Oh crap... that's sad on my part.. At the rate I spend money and played hours on Steam games.. I'm paying $0.06 per minute. I'm a cheapass bastard.