The Complete DC Bronze Age

[Warlord]

Stronguy recently posted his list of The Complete Marvel Bronze Age when he completed his amazing collection of those comics.

 

I'm interested in a comparable list of DC comics - anyone have a complete DC list? Or something that would get a collective effort at compiling such a list off to a good start?

[Scrooge]

Easy. Go to DC Indexes and download the Master List. Voilà!

[Hawkman]

can someone post this. i don't have excel, so i can't get this to open. i'm very interested in a complete dc bronze age list.

[Scrooge]

can someone post this. i don't have excel, so i can't get this to open. i'm very interested in a complete dc bronze age list.

 

Give me the specific cut-offs time-wise and I'll post them.

[Warlord]

can someone post this. i don't have excel, so i can't get this to open. i'm very interested in a complete dc bronze age list.

 

Give me the specific cut-offs time-wise and I'll post them.

 

Jan 1970 to Dec 1979

 

I've downloaded the Excel and turned on an autofilter and you'd think it would be an easy matter to just display all the rows where the year contains "197"... but Excel isn't cooperating.... Then there'd still be the matter of summarizing the list, not having one row per issue!

[Hawkman]

jan 1970-dec 1979

[Scrooge]

Here's everything with a 197X date in the database -

 

See later accurate lists

[Hawkman]

*saves*

 

thank you very much

[Warlord]

Small progress ... there are 3,615 issues in the DC Bronze Age per the main listing of the 1970s issues...

[Warlord]

Cool!

I'm one macro away from consolidating the list into that brief form. I wasted time trying to manually edit the list. Stoopid!

 

<Begin Excel Geekfest>After giving up the editing approach, I did subtotal for min and max, then was struggling to figure out a quick way to summarize the min and max values for each title into a single line. How'd you do that? Just a macro referencing the current line and then the next line issue number value?</End Excel Geekfest>

[Warlord]

Going to need some edits to your auto list...

 

Famous First Edition C-26, C-28, C-30, F-4 to F-8, C-61

[Warlord]

Another edit....

 

All-New Collectors' Edition C-53 to C-56, C58, C-60, C-62

[Scrooge]

Cool!

I'm one macro away from consolidating the list into that brief form. I wasted time trying to manually edit the list. Stoopid!

 

<Begin Excel Geekfest>After giving up the editing approach, I did subtotal for min and max, then was struggling to figure out a quick way to summarize the min and max values for each title into a single line. How'd you do that? Just a macro referencing the current line and then the next line issue number value?</End Excel Geekfest>

 

I didn't use the summary function (sub-total) because I knew it would be a pain later on, same as you ran into. Instead I grabbed only the 197X years first and worked on those. Sorted them by title and issue #. Then I created a column with an if statement to find where the titles changed. I had my starting points. I added another column for the ending points. That is I created a column with a dummy variable taking on 1 if it was either the start or end of a title list. I then discarded anything in the middle through another sort. Final step was a concatenate statement to put in the brief format above.

[Scrooge]

Another edit....

 

All-New Collectors' Edition C-53 to C-56, C58, C-60, C-62

 

Crappy non-continuous numbering

[Warlord]

Limited Collectors' Edition (C-20) to C-25, C-27, C-29, C-31 to C-52, C-57, C-59

[Warlord]

Super DC Giant S-13 to S-26, 27

[Warlord]

Tarzan Digest 1

 

not Tarzan Digest 1-60!

 

Tarzan Digest was in the middle of the Tarzan issues for some reason. Error in the orig Excel file ordering I suppose...

 

I think that's all of them. Any see any other problems?

[Hawkman]

changes made. once i get my current list (sig) out of the way, this will be my next goal (i'll put this in my five year pile. ).

[Hawkman]

deleted

[Warlord]

*deleted*