VGCollect Forum
VGCollect Site Stuff => Video Game Database Discussion => Topic started by: mrcrimpbiscuit on January 12, 2015, 10:46:22 am
-
Does this already exist for my profile?
I want to know (when I finish submitting all of my games) about how much I have spent on it.
The fields for how much you spent already exist for each individual game, so I was just curious if we could pull it together for a total amount.
:)
-
probably not.
too many variables - people can get the same game in different locations & for vastly different prices; from yard sales to paying top dollar for "officially graded" copies.
really, your best & most accurate way would be the longest, least convenient, and the biggest pain in the ass way of keeping track of it yourself.
welcome to VGC, by the way...we've got an "Introduction" thread, if you feel like saying Hi!
-
Thanks for the reply and the welcome! :)
However now I must ask why there is an input for how much I spent on a game when I register it to my collection?
:)
-
The easiest way to do it is to export your collection to the CSV format and open that in excel. From there you can simply run a SUM function on the $ spent column and figure it out easily. Its how I figured out I spent $746 last year.
-
Thanks for the reply and the welcome! :)
However now I must ask why there is an input for how much I spent on a game when I register it to my collection?
:)
You can do it from your collection screen (once the item is already added to your collection):
(http://i.imgur.com/r6meuyo.png)
A similar screen will pop up when you add new items so that you can enter your cost in. That way, when you export your collection, you can use Excel to calculate your cost, like tafk said.
EDIT: my bad, I though you said "where" is the area to enter the cost, not why, haha. But yeah, you can enter your cost and export and get your sum :)
-
I like that idea. The comic collecting software I have has a "total cover price" it shows you in the summary section, as well as a "total price paid" if you want to enter that info into your collection.
We could do the same thing here, if it is implemented. Have a "total retail value", and then a "total price paid" optional if people want to enter that.
-
I like that idea. The comic collecting software I have has a "total cover price" it shows you in the summary section, as well as a "total price paid" if you want to enter that info into your collection.
We could do the same thing here, if it is implemented. Have a "total retail value", and then a "total price paid" optional if people want to enter that.
I'd love that, too, as getting gifts and such, I don't always like to put in the cost of the item but it'd be nice to be able to keep track of its cost for insurance reasons.
-
These are things I want to work on. Like a user stats page. A cumulative total of the cost fields and an estimated value based on the loose/complete/new values of VGPC, highest valued game, system you have the most titles for, % of library owned for individual systems, etc.
-
Seems like I've made a good first impression here. :)
Thanks for the advice on exporting to Excel!
I'll be doing that as soon as I get finished! :)
I appreciate the very warm welcome everyone!
Happy collecting everyone! :)
-
These are things I want to work on. Like a user stats page. A cumulative total of the cost fields and an estimated value based on the loose/complete/new values of VGPC, highest valued game, system you have the most titles for, % of library owned for individual systems, etc.
We have *something* like this - Go to your home page & click-on your avatar to see it - using my page as an example (in the link below); look in the top-left corner (directly under the "VGCOLLECT" you'll see a pic of (the same pic you'll see here in the forums) my avatar...clicking on that will access some stats (and a pie chart) of your collection :)
http://vgcollect.com/disgaeniac
"However now I must ask why there is an input for how much I spent on a game when I register it to my collection"?:)
just for your personal notes/record-keeping; as I've said: 10 different people could, very easily, have 10 different prices there...for the same game - making a "1 size fits all" approach to something like this almost impossible & meaningless - when everyone can (and usually does) get the same games @ very different prices.
TL;DR It's just there for you ;)
-
Is it possible to add to the .csv if not the site.... Pricecharting.com's current price for the game?
-
I should also mention that this thread should probably be under the Site Feedback subforum where we post up suggestions/bugs/etc about the site :)
http://vgcollect.com/forum/index.php/board,2.0.html
-
Is it possible to add to the .csv if not the site.... Pricecharting.com's current price for the game?
Thats been brought up multiple times I believe and IIRC the response was that it would be too complicated/hard for such a small return. If people wanted to do that they could go search the VGPC prices themselves. There was a thread about it a few months back.
-
just for your personal notes/record-keeping; as I've said: 10 different people could, very easily, have 10 different prices there...for the same game - making a "1 size fits all" approach to something like this almost impossible & meaningless - when everyone can (and usually does) get the same games @ very different prices.
TL;DR It's just there for you ;)
I mentioned a fix for this in an earlier post. My comic collecting software has a "Total Cover Price" section that automatically has the retail prices fixed. And then there's also a "Total Price Paid", which is optional and you can enter your own values. Both sections stay separated with separate values. The same system could be used for games.
-
just for your personal notes/record-keeping; as I've said: 10 different people could, very easily, have 10 different prices there...for the same game - making a "1 size fits all" approach to something like this almost impossible & meaningless - when everyone can (and usually does) get the same games @ very different prices.
TL;DR It's just there for you ;)
I mentioned a fix for this in an earlier post. My comic collecting software has a "Total Cover Price" section that automatically has the retail prices fixed. And then there's also a "Total Price Paid", which is optional and you can enter your own values. Both sections stay separated with separate values. The same system could be used for games.
That's exactly my point, though...
...games (except for new releases coming out @ the MSRP), don't *HAVE* "fixed" retail prices :o
Ten retail stores could be listing it for 10 different retail prices & that's not even factoring in Black label vs GH, variants, LE's of the same game, the same game on multiple platforms, game condition, existence & condition of case, manual, swag/extras, OST's, artbooks, etc and sealed vs un-sealed (which can be vastly different #'s) --and-- since *I* think that it's just silly & a waste of money...I'm not even counting the "graded" vs non-graded & the # of the grading :-\
There's just TOO many variables to make that work *especially* on a collector's site like this where 20 people can own the game _____ and, each have a different value & worth because of...variables 8)
-
just for your personal notes/record-keeping; as I've said: 10 different people could, very easily, have 10 different prices there...for the same game - making a "1 size fits all" approach to something like this almost impossible & meaningless - when everyone can (and usually does) get the same games @ very different prices.
TL;DR It's just there for you ;)
I mentioned a fix for this in an earlier post. My comic collecting software has a "Total Cover Price" section that automatically has the retail prices fixed. And then there's also a "Total Price Paid", which is optional and you can enter your own values. Both sections stay separated with separate values. The same system could be used for games.
That's exactly my point, though...
...games (except for new releases coming out @ the MSRP), don't *HAVE* "fixed" retail prices :o
Ten retail stores could be listing it for 10 different retail prices & that's not even factoring in Black label vs GH, variants, LE's of the same game, the same game on multiple platforms, game condition, existence & condition of case, manual, swag/extras, OST's, artbooks, etc and sealed vs un-sealed (which can be vastly different #'s) --and-- since *I* think that it's just silly & a waste of money...I'm not even counting the "graded" vs non-graded & the # of the grading :-\
There's just TOO many variables to make that work *especially* on a collector's site like this where 20 people can own the game _____ and, each have a different value & worth because of...variables 8)
Same as comics. Comics get sold at different prices, too. I'm talking the original suggested retail price from the manufacturer. Which is often $50-$60. Brand new games, in the plastic wrap, are generally sold for the same price across the board at department stores, game stores, and electronic shops. Same as brand-new comics. It's when they're used or have been out for a while that discrepancies come in, or in non-retail situations (same as comics).