Posted By | Message |
avsbruins65
Posts: 2,149
Joined: Sep 2008
|
Monday, September 18, 2017 4:25 PM | |
Would be curious to your what your spreadsheet loks like
Mark
-------------------------------
Trying to acquire one card for every for every set, insert, parralle, minor, euro, team issue, oddball etc sets produced for Hockey. Been an interesting project.
|
|
|
|
Vvvergeer
Posts: 2,058
Joined: Jan 2014
|
Monday, September 18, 2017 4:59 PM | |
Too lazy to try to include a picture here. It's my Baseball Card Collection Have List, so it shows every card I own. Column A is Year/Set. Column B is card number, which is the list of cards I have. The long list gets replaced by "set" when the set is complete. Column C is Value, which I keep vague track of for kicks and giggles. Column D is Year Total Cards, so it shows how many cards I have for each year. For now, that column also doubles as the notes column, where I would write "replace" or mark the grade, if relevant. Column E is the total value of each year.
If that's any help. It works for me. But I actually use the Want List more when I'm out looking for cards.
v3
|
|
|
|
Lea DeFoote
Posts: 1,535
Joined: Jul 2012
|
Monday, September 18, 2017 5:23 PM | |
I have many collections, and items in some of them are more prone to having condition issues than others. If I get a filler piece I leave the item on my want list but mark it "GABO" so that I know not to go out of my way to get another filler piece.
It stands for "Get A Better One".
-Tom
-------------------------------
Ted Musgrave card collection 98.9% Complete: Cards Known: 1013, Cards Owned: 1002 I prefer the company of people who disagree with me for the right reasons over the company of those who agree with me for the wrong reasons.
|
|
|
|
|
Monday, September 18, 2017 5:46 PM | |
This message has been removed.
|
|
obxyankeefan
Posts: 757
Joined: Aug 2017
|
Monday, September 18, 2017 5:47 PM | |
Someone want to delete this. I was trying to put a small part of a spreed sheet up here and it didn't work
Edited on: Sep 18, 2017 - 5:51PM
|
|
|
|
Doc Floyd
Posts: 483
Joined: Sep 2014
|
Monday, September 18, 2017 7:54 PM | |
A couple sets I'm working on which are in pages, I have damaged cards I want to be replaced turned upside down from the good ones. Usually, I'll have a sheet of paper at the front of the set with missing cards, and a note with whats wrong with fillers.
Boxed sets I try to have a sheet on top inside the box. When it's down to a single card or 2 I have written on the box or taped a note on it before.
-------------------------------
"I believe there ought to be a constitutional amendment outlawing Astroturf and the designated hitter." - Crash Davis
|
|
|
|
obxyankeefan
Posts: 757
Joined: Aug 2017
|
Monday, September 18, 2017 8:13 PM | |
Let me try thios again without putting the spreed sheet in here. I have 7 different spreed sheets, 1 for each of the main types of cards I collect. Ex Topps Hockey. The first page is just the years and I will color the years taht are complete in blue. On this page I have Formulas that will show me all the amounts from each year. How many cards I have, don't have, book value for those I have, book value for those I don't have, total amounts of cards and book value, and percentages. Each other page is for each given year. On those I list the cards, then with IF formulas I can change all the totals on the first page.
|
|
|
|
Doc Floyd
Posts: 483
Joined: Sep 2014
|
Monday, September 18, 2017 8:42 PM | |
Something went screwy with the last couple replies, hope I didn't cause it.
-------------------------------
"I believe there ought to be a constitutional amendment outlawing Astroturf and the designated hitter." - Crash Davis
|
|
|
|
vrooomed
Posts: 14,985
Joined: Dec 2012
|
Monday, September 18, 2017 9:32 PM | |
it was obxyankeefan's post. He asked for it to be removed and I assisted.
-------------------------------
-- Dan -- Note: Please see my profile for more info regarding trading (section updated 3/4/2024). I have added a large portion of my inventory to the site, and currently have trading turned on (details are in my profile).
|
|
|
|
obxyankeefan
Posts: 757
Joined: Aug 2017
|
Monday, September 18, 2017 10:52 PM | |
Sorry about that. I tried to copy and paste an example of my spreed sheet and it screwed everything up.
|
|
|
|