|
Excel Experts out there?
Can someone possibly sort this PSA POP Report to total up the amount of Blank Back graded vs the total amount of Sporting News Backs graded?
Much appreciated. https://www.psacard.com/pop/baseball...ing-news/41365 |
It's pretty even-steven, Ray. I came up with 1,396 of the 2,888 with NQ are blank backs.
|
You may be able to do it technically, but it would provide false and wholly unreliable conclusions because until recently, PSA lumped them both together, along with some others that had different advertising backs. The fact that you might see some entries for a player with "blank Back" notation does not mean the 12 other examples listed for him without such notation are all with Sporting News backs. IOW, a player with a certain number graded "blank backs" has at least that many with blanks but does not mean the others graded for that player without the notation do not also include a large number of blanks.
|
Card Ad blank Grand Total
1 6 11 17 2 6 4 10 3 8 9 17 4 12 11 23 5 7 12 19 6 6 7 13 7 6 6 12 8 8 7 15 9 14 8 22 10 10 13 23 11 7 8 15 12 8 8 16 13 12 16 28 14 7 5 12 15 5 7 12 16 7 5 12 17 10 13 23 18 7 9 16 19 6 8 14 20 8 7 15 21 8 8 16 22 7 8 15 23 8 6 14 24 7 7 14 25 6 10 16 26 7 8 15 27 6 9 15 28 8 10 18 29 6 8 14 30 7 9 16 31 6 11 17 32 8 10 18 33 7 10 17 34 9 14 23 35 7 7 14 36 12 11 23 37 7 8 15 38 17 18 35 39 9 8 17 40 7 9 16 41 12 11 23 42 5 9 14 43 7 7 14 44 6 9 15 45 7 6 13 46 7 8 15 47 8 12 20 48 6 10 16 49 7 9 16 50 7 5 12 51 6 7 13 52 6 9 15 53 6 9 15 54 13 12 25 55 9 11 20 56 6 13 19 57 7 8 15 58 7 11 18 59 7 9 16 60 7 5 12 61 9 9 18 62 8 8 16 63 7 7 14 64 11 8 19 65 9 9 18 66 8 13 21 67 7 10 17 68 7 8 15 69 7 13 20 70 8 9 17 71 7 11 18 72 13 13 26 73 11 6 17 74 9 9 18 75 6 6 12 76 10 5 15 77 10 9 19 78 9 6 15 79 8 7 15 80 9 7 16 81 8 6 14 82 9 12 21 83 9 8 17 84 10 10 20 85 7 6 13 86 9 10 19 87 22 21 43 88 8 10 18 89 8 9 17 90 9 12 21 91 15 15 30 92 8 7 15 93 10 8 18 94 9 6 15 95 7 7 14 96 8 9 17 97 15 15 30 98 10 8 18 99 7 8 15 100 8 7 15 101 8 6 14 102 8 6 14 103 10 10 20 104 10 6 16 105 10 5 15 106 9 7 16 107 12 8 20 108 10 7 17 109 9 8 17 110 8 6 14 111 8 9 17 112 10 10 20 113 10 12 22 114 8 9 17 115 8 7 15 116 12 11 23 117 9 3 12 118 9 7 16 119 8 8 16 120 9 7 16 121 12 5 17 122 9 5 14 123 10 4 14 124 11 5 16 125 9 8 17 126 11 4 15 127 9 6 15 128 10 7 17 129 9 7 16 130 9 5 14 131 8 5 13 132 10 5 15 133 8 6 14 134 8 9 17 135 8 6 14 136 9 6 15 137 8 7 15 138 10 6 16 139 9 5 14 140 12 7 19 141 8 8 16 142 10 11 21 143 9 9 18 144 11 11 22 145 10 7 17 146 8 8 16 147 10 4 14 148 8 7 15 149 8 8 16 150 10 6 16 151 18 6 24 152 9 10 19 153 11 9 20 154 10 8 18 155 10 6 16 156 8 6 14 157 9 7 16 158 9 6 15 159 8 6 14 160 9 6 15 161 10 4 14 162 8 8 16 163 9 6 15 164 10 11 21 165 10 6 16 166 9 5 14 167 9 8 17 168 8 6 14 169 17 15 32 170 8 8 16 171 10 9 19 172 8 7 15 173 9 8 17 174 15 10 25 175 10 6 16 176 9 4 13 177 10 6 16 178 10 6 16 179 8 5 13 180 10 4 14 181 7 5 12 182 18 10 28 183 9 5 14 184 10 7 17 185 8 5 13 186 11 11 22 187 7 9 16 188 9 8 17 189 6 5 11 190 8 4 12 191 7 7 14 192 9 4 13 193 7 6 13 194 8 7 15 195 9 13 22 196 7 8 15 197 9 6 15 198 8 9 17 199 7 6 13 200 6 7 13 Grand Total 1768 1613 3381 |
Quote:
The only interesting info I can infer from the reports is the comparison of this total number to the totals of other graded Ad Backs (the rarer ones). I'm down a rat hole at the moment. RayB |
Sorry Ray, the pop reports are not very helpful for your purposes. I trust (mostly) that the numbers for cards identified as blank backs are accurate, but if you see a player that has 15 blank backs and 15 others non-designated, you can rest assured that some and maybe most of the latter are also blank-backs. The grading companies were just too late in making the distinction for us to know how many are just good old Sporting News backs.
|
| All times are GMT -6. The time now is 01:23 PM. |