PT21 Card Ratings Spreadsheet

[Charlatan]

That’s a good question. The data I had from last year has the card type as part of it.

If you order the cards by ID does any sort of organization appear, or is it just one honkin alphabetical list?

[Torgonius]

I grabbed the list Kris posted here, which has the ID and the set. It matches up about 95% or so. I have to play with it more later.

My goal is to take what you built, add a column to indicate I own a card, then be able to filter down to cards that belong to a set (Bronze+Historical, Silver+Live, etc.) to figure out what I can build now, what I should look to acquire, and what I can sell off.

[Lemandria]

Should be easy enough to add, but if I recall correctly CardType is a numeric value (1-8?) in the player search. You might have to run a macro to covert it to "snapshot" (or whatever).

Or hell maybe there is a nice easy alpha value somewhere in those fields.

Take a look when I get home from work.

[ya, there is a type field in ootps release list, but no idea if any types changed along the way. Current data always better.]

No update before Monday, at any rate. See what I can do

----

UPDATE: The fields you're looking for are CType (UH, SS, etc) and CTier (Silver, bronze, etc). Alternatively Title incorporates everything in one line like "Snapshot, SP Jim Abbott, CWS, 1995" that would be searchable and sortable and easily parsed.

[Lemandria]

v1.7 4-27-2020

PT Card Ratings v1.7

(Includes the CardTitle field for sortable card type, last field on the row.)

[Lemandria]

v1.8 5-4-2020

PT Card Ratings v1.8

Includes the CardTitle field for sortable card type, the last field on the row.
SP/RP/CL ratings split out individually.

[kq76]

I appreciate the "card title" field. I know you don't take requests, but the 3 fields I collect myself (with the help of your instructions on your blog - thank you!) are year, team, and card type.

[Lemandria]

v1.9 5-11-2020

PT Card Ratings v1.9

[Torgonius]

sure, 20 minutes after I download 1.8

[PocketsAintFull]

Originally Posted by Lemandria

v1.9 5-11-2020

PT Card Ratings v1.9

This link ^ is broken, FYI

(this works https://facethecurtain.wordpress.com/spreadsheet/)

[Lemandria]

Originally Posted by Lemandria

v1.9 5-11-2020

PT Card Ratings v1.9

Links suck that way sometimes. :headdesk:

[KikiVincent]

Lotus was the BOMB back when.

[KikiVincent]

Seriously, thank you guys for being so into the game and for sharing that knowledge. Awesome community here.

[RoteLaterne]

Originally Posted by Lemandria

v1.9 5-11-2020

PT Card Ratings v1.9

Your data really helps a lot sorting out players.
Any chance we might fill those missing data for diamond cards 90+?

[Lemandria]

Originally Posted by RoteLaterne

Your data really helps a lot sorting out players.
Any chance we might fill those missing data for diamond cards 90+?

Sure. But many simply haven't been released yet.

[Lemandria]

v2.0 5-18-2020

PT Card Ratings v2.0

[Lemandria]

v2.1 5-25-2020

PT Card Ratings v2.1

[kq76]

Originally Posted by Lemandria

Sure. But many simply haven't been released yet.

You know what I've found helps is, join a tournament (gold, diamond, whatever you want), wait for it to "process", then do a player search of it! It won't get everyone, but it's going to pick up more players than just those in your own league.

[Lemandria]

Heh, grandpa knows that trick, believe me.

But we do suffer from sick-of-grinding-tournies, a bit.

Don't devote 10% as much time on tournies as XX.

[Jeff1787]

Originally Posted by kq76

You know what I've found helps is, join a tournament (gold, diamond, whatever you want), wait for it to "process", then do a player search of it! It won't get everyone, but it's going to pick up more players than just those in your own league.

Please explain in more detail if you don't mind. Thanks...

[Torgonius]

Originally Posted by Jeff1787

Please explain in more detail if you don't mind. Thanks...

After a tournament you entered has completed (winner crowned), you have 48 hours to go back into it. Once in, you can get the information about all the cards that were on entered rosters, and export that to a file, and then copy it into the spreadsheet software of your choice.