How do you export PSA pop reports into Excel?

This one's been bugging me for a while. When you go to the population reports on PSA's website, you can select all of the numbers you want and copy-->paste them over to Excel for further analysis. However, not matter what method I try, I cannot get those numbers converted to values so I can do calculations on them. I've tried the copy-->paste-->special-->values method, as well as converting text to numbers via the "value" function, but nothing seems to work. I consider myself fairly well versed in Excel but this one is killing me! The best I've been able to do is use the auto-filter to bring of cards with certain pops, but that is not helping me with everything I want to do because it's just a display solution and still won't allow me to sort or do calculations.
Anyone have a quick and easy solution for this that I am missing?
Anyone have a quick and easy solution for this that I am missing?
Jim G
All-time favorite athletes:
Steve Sax, Steve Garvey, Larry Bird, Jerry Rice, Joe Montana, Andre Agassi, Karch Kiraly, Wayne Gretzky, Ichiro Suzuki, Andres Galarraga, Greg Maddux.
"Make the world a better place... punch both A-Rods in the face (Alex Rodriguez and Andy Roddick)!"
All-time favorite athletes:
Steve Sax, Steve Garvey, Larry Bird, Jerry Rice, Joe Montana, Andre Agassi, Karch Kiraly, Wayne Gretzky, Ichiro Suzuki, Andres Galarraga, Greg Maddux.
"Make the world a better place... punch both A-Rods in the face (Alex Rodriguez and Andy Roddick)!"
0
Comments
<< <i>This one's been bugging me for a while. When you go to the population reports on PSA's website, you can select all of the numbers you want and copy-->paste them over to Excel for further analysis. However, not matter what method I try, I cannot get those numbers converted to values so I can do calculations on them. I've tried the copy-->paste-->special-->values method, as well as converting text to numbers via the "value" function, but nothing seems to work. I consider myself fairly well versed in Excel but this one is killing me! The best I've been able to do is use the auto-filter to bring of cards with certain pops, but that is not helping me with everything I want to do because it's just a display solution and still won't allow me to sort or do calculations.
Anyone have a quick and easy solution for this that I am missing? >>
Did you try converting the text to numbers using the Format Cells function?
WTB: 2001 Leaf Rookies & Stars Longevity: Ryan Jensen #/25
I was able to keep track of activity on the '71 Topps pop-report while I was building my set. I even spotted a suspicious switch of a 9 to a 10. Same number of cards graded, but one less 9 and one more 10 than in my previous analysis.
If they made the pop-report free, I'd go in and do all sorts of wonderful analyses, but since I'm not a member anymore, that's impossible.
Anyway... thanks again for the tip!
All-time favorite athletes:
Steve Sax, Steve Garvey, Larry Bird, Jerry Rice, Joe Montana, Andre Agassi, Karch Kiraly, Wayne Gretzky, Ichiro Suzuki, Andres Galarraga, Greg Maddux.
"Make the world a better place... punch both A-Rods in the face (Alex Rodriguez and Andy Roddick)!"
<< <i>When I was a member and had access to the pop reports, I would just ... run a Perl script on it. >>
heh... for some reason, this answer reminded me of a Star Trek quote...
Q: "Change the gravitational constant of the universe, thereby altering the mass of the asteroid."
Geordi: "Redefine gravity. And how the hell am I supposed to do that?"
Q: "You just DO it."
WTB: 2001 Leaf Rookies & Stars Longevity: Ryan Jensen #/25
i tried that but it will not allow me to paste anything in the find what box. i guess i am screwing up something.
All-time favorite athletes:
Steve Sax, Steve Garvey, Larry Bird, Jerry Rice, Joe Montana, Andre Agassi, Karch Kiraly, Wayne Gretzky, Ichiro Suzuki, Andres Galarraga, Greg Maddux.
"Make the world a better place... punch both A-Rods in the face (Alex Rodriguez and Andy Roddick)!"
Good Luck.
Justin
<< <i>So does anyone do analysis on these exports to help find cards to invest in? I am wondering what type of analysis you can do on these numbers to help make some money flipping cards.....
Justin >>
Scott Suser comes to mind...........he plays the seek out raw of low pop game...........
1955 Bowman Raw complete with 90% Ex-NR or better
Now seeking 1949 Eureka Sportstamps...NM condition
Working on '78 Autographed set now 99.9% complete -
Working on '89 Topps autoed set now complete
Who is Scott Suser? I board poster?
Any idea what he does?