Player Search parsing for spreadsheets

Lemandria · 03-06-2020, 04:22 AM

From a discussion about the card dbase, there doesn't seem to be any "guides" section, so I guess it just goes here.

Player Search parsing for spreadsheets

^ If you'd like a nice sortable spreadsheet of PT card ratings, but aren't quite sure how to collect the information. Not just ratings, statistics colletion, too. Link is to my PT blog.

The power and beauty of the Player Search/Compare tool.

The screenshots and instructions are from PT20, but I wouldn't expect a great deal of "how to" change for PT21.

rburgh · 03-06-2020, 07:08 AM

This is most helpful. I think that it will enable me to generate my own databases pretty quickly simply by tracking the reports for all of my leagues' ending rosters on Sundays while the rest of you are fretting over your playoff results.

Lemandria · 03-06-2020, 09:28 AM

Quote:

Originally Posted by rburgh

Sundays while the rest of you are fretting over your playoff results.

Just be aware, if you re collecting statistics, that you only have about a two-hour window, after midnight, before the player stats get wiped.

They churn right into the team moving and league reassignments in prep for Monday morning.

Boomcoach · 03-06-2020, 09:56 AM

Quote:

Originally Posted by Lemandria

Just be aware, if you re collecting statistics, that you only have about a two-hour window, after midnight, before the player stats get wiped.

They churn right into the team moving and league reassignments in prep for Monday morning.

But if you are just looking for rating, those would still be available, right?

Lemandria · 03-06-2020, 03:01 PM

Quote:

Originally Posted by Boomcoach

But if you are just looking for rating, those would still be available, right?

Well, once your old league is dissolved...nope. I wouldn't wait too long.

The good news is that ratings are easy, you can go fishing for those any time you have an active league.

PocketsAintFull · 03-06-2020, 03:44 PM

You could get the regular season stats from the end of play on Saturday, too.

Orcin · 03-22-2020, 10:15 AM

This was really helpful, thank you for providing the tutorial.

One thing that tripped me up as a newbie... I use the dark skin so my report had white text. When I pasted into Excel, I thought I had nothing. In fact, I just had to select the text that I pasted and change the text color to black.

Lemandria · 03-22-2020, 11:22 AM

No problem.

Folks hungry for hot spreadsheet action can visit facethecurtain.wordpress.com, v1.O ratings went up yesterday.

Couple of posts back, now.

03-06-2020, 04:22 AM	#1
Lemandria All Star Reserve Join Date: Sep 2019 Location: Chicagoland Posts: 702	Player Search parsing for spreadsheets From a discussion about the card dbase, there doesn't seem to be any "guides" section, so I guess it just goes here. Player Search parsing for spreadsheets ^ If you'd like a nice sortable spreadsheet of PT card ratings, but aren't quite sure how to collect the information. Not just ratings, statistics colletion, too. Link is to my PT blog. The power and beauty of the Player Search/Compare tool. The screenshots and instructions are from PT20, but I wouldn't expect a great deal of "how to" change for PT21. __________________ FOTF victim Farewell Last edited by Lemandria; 03-06-2020 at 04:25 AM.

03-06-2020, 07:08 AM	#2
rburgh All Star Reserve Join Date: Nov 2012 Location: Pittsburgh Posts: 733	Thank you This is most helpful. I think that it will enable me to generate my own databases pretty quickly simply by tracking the reports for all of my leagues' ending rosters on Sundays while the rest of you are fretting over your playoff results.

03-06-2020, 03:44 PM	#6
PocketsAintFull All Star Starter Join Date: Nov 2018 Location: Birmingham, UK Posts: 1,771	You could get the regular season stats from the end of play on Saturday, too. __________________

03-22-2020, 11:22 AM	#8
Lemandria All Star Reserve Join Date: Sep 2019 Location: Chicagoland Posts: 702	No problem. Folks hungry for hot spreadsheet action can visit facethecurtain.wordpress.com, v1.O ratings went up yesterday. Couple of posts back, now. __________________ FOTF victim Farewell

03-22-2020, 10:15 AM	#7
Orcin Hall Of Famer Join Date: Aug 2010 Location: Indiana Posts: 9,798	This was really helpful, thank you for providing the tutorial. One thing that tripped me up as a newbie... I use the dark skin so my report had white text. When I pasted into Excel, I thought I had nothing. In fact, I just had to select the text that I pasted and change the text color to black.