How do you keep track of run collecting? 1 1

[oakman29]

You guys are way too smart for me. I love completing runs, but I use the old fashion way. Pencil and paper.

Edited May 25, 2018 by oakman29

[kav]

50 minutes ago, oakman29 said:

You guys are way to smart for me. I love completing runs, but I use the old fashion way. Pencil and paper.

What's a pencil and paper?

[oakman29]

21 minutes ago, kav said:

What's a pencil and paper?

 I also document it on a message board journal to keep my old azz from having to thumb through them.

[kav]

1 minute ago, oakman29 said:

 I also document it on a message board journal to keep my old azz from having to thumb through them.

What's a 'thumb'?

 

[oakman29]

1 minute ago, kav said:

What's a 'thumb'?

 

 

[kav]

3 minutes ago, oakman29 said:

 

Oh that thing.

[jmg3637]

In the early days of my collecting i tried to actively maintain an inventory with these manual spreadsheets  from the BAG MAN.  He had pad of 50 sheets and you could get 400 on one page.  He even sold a set  of 401-800  for the really long running series.

This is the last update I did for my FOUR COLOR's  prior to switching to a real spreadsheet over a decade ago. I had to jury rig another sheet  to accommodate  801-1200  and never tracked the either the First series  or the  last 154 issues.

He also sold plastic title dividers.  Placed a nice order from him in the early 90's as this was copyrighted in 1990  with intentional errors in the numbering 

[Andahaion]

I use Google Drive (spreadsheet).  It's always available, laptop or phone.  

 

[MadripoorNights]

Excel list updated locally.  Uploaded to Google Drive and converted to Google Sheets file for easy mobile use.  I filter wanted issues and upgrades to a Buy List tab to make a shorter, more manageable search list.

[jcjames]

18 minutes ago, MadripoorNights said:

Excel list updated locally.  Uploaded to Google Drive and converted to Google Sheets file for easy mobile use.  I filter wanted issues and upgrades to a Buy List tab to make a shorter, more manageable search list.

Cool! Can you explain a little more what you mean about filtering to a Buy List tab?

 

[MadripoorNights]

23 minutes ago, jcjames said:

Cool! Can you explain a little more what you mean about filtering to a Buy List tab?

 

I have an index lookup on a secondary worksheet that pulls titles from the main checklist into it that meet the criteria for purchase or upgrade, like Owned = No or raw grade not equal to NM.  You could make this in a few ways depending on your needs, like with nested IF functions, index match, or a simple pivot table.  Even easier would be to just filter your main list to what you're looking to buy and copy/paste the remaining titles into a new tab.  Repeat to update when new titles are added.

[01TheDude]

I just write the ones I need on a post it note. There are about 7 titles but I pretty much know what I'm missing on most of them.

I try to focus on a few titles-- If I run out of easily affordable/obtainable ones, I sometimes add a new title to my post it. It is all SA/BA though.

Lately, I've been slowing down on the purchases. Mostly because I have plenty of books I still need to read in the first place, but also because the prices have been going up on the books I like, I did buy some X-Men recently due to watching the show Legion-- specifically the Muir Island Sage (X-men 278-280, X-Factor 69, 70) that should be coming in a week or so. I don't own a single X-Men book since I sold all mine back in 1986 for peanuts (some good books off the rack in low 100s and some decent SA).

Edited May 25, 2018 by 01TheDude
forgot a word

[jmg3637]

17 hours ago, jmg3637 said:

In the early days of my collecting i tried to actively maintain an inventory with these manual spreadsheets  from the BAG MAN.  He had pad of 50 sheets and you could get 400 on one page.  He even sold a set  of 401-800  for the really long running series.

This is the last update I did for my FOUR COLOR's  prior to switching to a real spreadsheet over a decade ago. I had to jury rig another sheet  to accommodate  801-1200  and never tracked the either the First series  or the  last 154 issues.

He also sold plastic title dividers.  Placed a nice order from him in the early 90's as this was copyrighted in 1990  with intentional errors in the numbering 

Here is my current FOUR COLOR HAVE list.  with 1130 issues in hand  and the ability to handle the entire series.  You can see the progress I have made  with  70 of the first 99  and 79  of the 1xx  issues.  Way back when I think I only had 19 of the first  and 26 of the second hundred issues.

 

AS always  the trading hut is open for business on any of the missing issues

[Scrooge]

32 minutes ago, jmg3637 said:

You can see the progress I have made  with  70 of the first 99  and 79  of the 1xx  issues

Awesome. You've made such great progress in the past few years 

 

Sadly, I haven't. Here are my current counts. Compares with your bottom row. For example, we're dead-even on the first 100 issues @ 70 each of us.

1 - 100	70
101 - 200	92
201 - 300	91
301 - 400	95
401 - 500	98
501 - 600	95
601 - 700	97
701 - 800	98
801 - 900	97
901 - 1000	97
1001 - 1100	96
1101 - 1200	96
1201 - 1300	83
1301 - 1354	18

[01TheDude]

Four Color run collectors are animals! Hard core!

[jmg3637]

39 minutes ago, Scrooge said:

Awesome. You've made such great progress in the past few years 

 

Sadly, I haven't. Here are my current counts. Compares with your bottom row. For example, we're dead-even on the first 100 issues @ 70 each of us.

1 - 100	70
101 - 200	92
201 - 300	91
301 - 400	95
401 - 500	98
501 - 600	95
601 - 700	97
701 - 800	98
801 - 900	97
901 - 1000	97
1001 - 1100	96
1101 - 1200	96
1201 - 1300	83
1301 - 1354	18

Yes but you have the heck beat out of me in each other Hundred  except for the 10xx's  where we are tied at 96  and the 13xx  where I have you beat 22  to 18. I am sure it gets much harder when you are down to the last hundred books.

 How many First Series do you have?  I have jumped up to 11  of those 25  which is probably the hardest section to dig up. I have all kinds of statistical analysis on the non printed pages but  that is for the super analytic types like a fellow Actuary.  For example I have now have all 13 of the xx00, xx56, xx58, xx71, xx80, xx82, xx86 and xx86  books  and all 14 of  the xx12  xx36 and xx48  rows.   

[Scrooge]

8 minutes ago, jmg3637 said:

How many First Series do you have?

I decided from the start that I wouldn't chase after those.

I do too have quite a few analyses going in the background, including the progress chart. Adjusted to percentage to account for the missing #s -

 

[Wipple]

Found these in my 1975 overstreet. 

[miraclemet]

i used to print my issue list and put it in an ID holder on a lanyard around my neck.

no fishing lists out. 

no losing the list 

no leaving it beind at a booth

[Dr Zen]

I use and Excel spreadsheet that I have on my phone. White means I don't have it. Yellow I do. Blue means I have it but need an upgrade.