I'm writing a program to analyze the pop report. Suggestions?
jrinck
Posts: 1,321 ✭✭
Partly because I'm a geek and partly because I think the pop report is hard to read onscreen, I'm developing a little software program (written in PERL, for you fellow geeks) that will help me analyze it a little better.
The main focus of what I want to do is to compare pop reports of a specific set between different dates to see what's changed and what hasn't. This data could be used to graph what cards seem to be increasing in population (and at what grades) versus stagnant cards. You draw your own conclusions as to why you're seeing what you're seeing. Basically what I'll do is save the pop report from time to time (hit SAVE-AS from the browser) so I'll have an archival "snap-shots" of the state of the report at different dates.
Anyway, I'm looking for suggestions as to what other features I might be able to add to help analyze the report. Specifically, what can I do with just a single pop-report file to draw any useful conclusions?
Thanks,
John
The main focus of what I want to do is to compare pop reports of a specific set between different dates to see what's changed and what hasn't. This data could be used to graph what cards seem to be increasing in population (and at what grades) versus stagnant cards. You draw your own conclusions as to why you're seeing what you're seeing. Basically what I'll do is save the pop report from time to time (hit SAVE-AS from the browser) so I'll have an archival "snap-shots" of the state of the report at different dates.
Anyway, I'm looking for suggestions as to what other features I might be able to add to help analyze the report. Specifically, what can I do with just a single pop-report file to draw any useful conclusions?
Thanks,
John
0
Comments
During the month of June 200X, 1,000 cards from X set were graded -- and of those, the following grades were assigned:
3 PSA 9, 298 PSA 8, 504 PSA 7, 165 PSA 6, 30 qualified cards....
I've kept similar data for selected subjects from the Pop report over the last 3 years or so. Very interesting to see the changes, when they happen, and which dealers get the 10s. (when they end up on Ebay...)
And to think that this data was once only available in that huge book!
This is something I can easily add. One of the first lines in the pop report shows the current totals for each grade. This can also be done for individual cards, which is especially helpful when only one or two cards in a set are the most active, such as the '86 Fleer Jordan.
Here is a summary analysis of the 1971 Topps population report between yesterday (7/25) and today (7/26) as of mid-day. The analysis for the entire set took roughly 20 seconds. Further style refinements are pending, but it seems to work!
Summary for Total Set...
Total graded: 24807 vs 24854
10: 7 vs 7
9 (NQ): 446 vs 446
9 (Q): 20 vs 20
8 (NQ): 12753 vs 12763
8 (Q): 489 vs 490
7 (NQ): 8833 vs 8847
7 (Q): 227 vs 227
6: 1424 vs 1439
5: 411 vs 416
3/4: 178 vs 180
1/2: 19 vs 19
Sample of cards with changes...
Summary for card #14 (Dave Concepcion RC)...
Total graded: 140 vs 141
10: 0 vs 0
9 (NQ): 2 vs 2
9 (Q): 0 vs 0
8 (NQ): 57 vs 57
8 (Q): 6 vs 6
7 (NQ): 54 vs 54
7 (Q): 2 vs 2
6: 11 vs 12
5: 4 vs 4
3/4: 2 vs 2
1/2: 0 vs 0
Summary for card #20 (Reggie Jackson)...
Total graded: 266 vs 267
10: 0 vs 0
9 (NQ): 1 vs 1
9 (Q): 0 vs 0
8 (NQ): 59 vs 59
8 (Q): 15 vs 15
7 (NQ): 100 vs 101
7 (Q): 18 vs 18
6: 43 vs 43
5: 13 vs 13
3/4: 7 vs 7
1/2: 2 vs 2
Summary for card #36 (Dean Chance)...
Total graded: 16 vs 17
10: 0 vs 0
9 (NQ): 0 vs 0
9 (Q): 0 vs 0
8 (NQ): 8 vs 8
8 (Q): 0 vs 0
7 (NQ): 7 vs 8
7 (Q): 0 vs 0
6: 0 vs 0
5: 1 vs 1
3/4: 0 vs 0
1/2: 0 vs 0
Summary for card #50 (Willie McCovey)...
Total graded: 152 vs 153
10: 0 vs 0
9 (NQ): 0 vs 0
9 (Q): 0 vs 0
8 (NQ): 69 vs 70
8 (Q): 2 vs 2
7 (NQ): 68 vs 68
7 (Q): 2 vs 2
6: 6 vs 6
5: 3 vs 3
3/4: 2 vs 2
1/2: 0 vs 0
Summary for card #55 (Steve Carlton)...
Total graded: 202 vs 205
10: 0 vs 0
9 (NQ): 1 vs 1
9 (Q): 0 vs 0
8 (NQ): 76 vs 76
8 (Q): 1 vs 1
7 (NQ): 100 vs 100
7 (Q): 2 vs 2
6: 16 vs 17
5: 3 vs 5
3/4: 3 vs 3
1/2: 0 vs 0
Summary for card #100 (Pete Rose)...
Total graded: 298 vs 300
10: 0 vs 0
9 (NQ): 1 vs 1
9 (Q): 0 vs 0
8 (NQ): 59 vs 59
8 (Q): 16 vs 16
7 (NQ): 134 vs 134
7 (Q): 8 vs 8
6: 46 vs 47
5: 17 vs 17
3/4: 11 vs 12
1/2: 0 vs 0
Summary for card #400 (Hank Aaron)...
Total graded: 546 vs 548
10: 2 vs 2
9 (NQ): 24 vs 24
9 (Q): 1 vs 1
8 (NQ): 219 vs 219
8 (Q): 14 vs 15
7 (NQ): 190 vs 190
7 (Q): 4 vs 4
6: 61 vs 62
5: 17 vs 17
3/4: 11 vs 11
1/2: 1 vs 1
Summary for card #513 (Nolan Ryan)...
Total graded: 1130 vs 1138
10: 0 vs 0
9 (NQ): 15 vs 15
9 (Q): 4 vs 4
8 (NQ): 264 vs 264
8 (Q): 64 vs 64
7 (NQ): 412 vs 412
7 (Q): 52 vs 52
6: 191 vs 198
5: 72 vs 73
3/4: 39 vs 39
1/2: 3 vs 3
Summary for card #600 (Willie Mays)...
Total graded: 427 vs 429
10: 0 vs 0
9 (NQ): 8 vs 8
9 (Q): 1 vs 1
8 (NQ): 128 vs 128
8 (Q): 14 vs 14
7 (NQ): 154 vs 154
7 (Q): 9 vs 9
6: 74 vs 75
5: 26 vs 27
3/4: 7 vs 7
1/2: 2 vs 2
Summary for card #709 (Baylor/Baker RC SP)...
Total graded: 210 vs 211
10: 0 vs 0
9 (NQ): 2 vs 2
9 (Q): 1 vs 1
8 (NQ): 70 vs 70
8 (Q): 3 vs 3
7 (NQ): 79 vs 80
7 (Q): 7 vs 7
6: 34 vs 34
5: 7 vs 7
3/4: 5 vs 5
1/2: 1 vs 1