PT21 Card Ratings Spreadsheet - Page 3

Jeff1787 · 05-28-2020, 12:47 PM

Quote:

Originally Posted by Torgonius

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.

kq76 was explaining something else, I think.

kq76 · 05-28-2020, 04:22 PM

No, I think we're describing the same thing. I just would have described it differently. LeMandria may have said it best here though.

The only difference is I was saying you could do it even before a single game is played, but I think Torg's way of doing it after the tourney has completed is probably better as, I'm not sure, but teams may have to set their rosters before those players can be picked up from the search. Or maybe not. I was just being impatient with my way.

jeffstified · 05-29-2020, 09:44 AM

After the tourney you can get actual stats. Which is how I built my iron team.

Lemandria · 06-08-2020, 05:23 PM

Spreadsheet – PT21 Card Ratings
FINAL RELEASE

v2.5 6-8-2020
Links: Hitting Ratings MASTER v2.5 Pitching Ratings MASTER v2.5

All right, for those of you who’ve never used Player Search extensively, there is a known feature where leagues exceeding a certain size (4096 players) force the report to paginate. Instead of getting one report, you get 102 pages of individual reports…one…page…at…a…time.

The average league is 30 teams. 30 teams x 200 active roster is? Yep, 6000. An average league will break Player Search’s functionality as a report. I’m currently playing in six leagues, and FOUR of them are ‘broken,’ for example.

It used to be, perhaps, that a 200 man roster was more rare than it is today. Collections force nearly everyone to cap out their teams with a large list of locked players, particularly when Live collections are de facto required to compete.

Whatever the reason, that pagination is enormously unfriendly to a big data approach.

I saw this coming, the eventual end of this project. When the Live players go Live (MLB starts playing games again), updating this sheet on a weekly basis will become impossible. So, I’m calling it quits unless or until that pagination limit gets raised far enough for Player Search to be usable at a typical league level.

If that’s even possible, maybe it isn’t. Maybe OOTPD is so choked for throughput with their current ISP that they don’t want big data approaches to their game. More than possible.

kq76 · 06-08-2020, 07:30 PM

Yeah, I had the same problem last night with one of my leagues. At first I thought my game was glitching out then I came across that it's a known issue. I asked if they could make the setting configurable in the app.cfg file in the future.

What maybe we can do in the future is post records of data that we've entered by hand and then when we add it to your data we can just add a column that it was from another source.

Thanks again for all your work!

Sharkn20 · 06-08-2020, 08:37 PM

Do we have this for OOTPXX??

Sent from my SM-G960F using Tapatalk

Catchthedamnball · 06-08-2020, 09:13 PM

Quote:

Originally Posted by Sharkn20

Do we have this for OOTPXX??

Sent from my SM-G960F using Tapatalk

A spreadsheet with all ratings was provided at the beginning of OOTP 20.

BatAround · 06-17-2020, 08:50 PM

Quote:

Originally Posted by Lemandria

Spreadsheet – PT21 Card Ratings
FINAL RELEASE

v2.5 6-8-2020
Links: Hitting Ratings MASTER v2.5 Pitching Ratings MASTER v2.5

Seems like the link to Pitching Ratings is broken.

Edit: Although it's easy to get to from the previous link:

https://facethecurtain.wordpress.com/spreadsheet/

Thanks for all of the work!

benderguy1 · 06-18-2020, 04:55 PM

Thanks for doing this, Lemandria! It's much appreciated!

Lemandria · 07-28-2020, 11:35 AM

Final pre-Live Live Cards update? Probably.

https://facethecurtain.wordpress.com/spreadsheet/

Largely taken over by @YourKidnies Sheet

Lemandria · 08-03-2020, 05:19 PM

v3.1

There really will be some 'live' cards, just any day now (we hope).

Lemandria · 08-10-2020, 05:18 PM

v 3.2

Version 3.2, first "live" cards updated!

kq76 · 08-10-2020, 09:06 PM

LOL, whenever I finally get around to updating my sheet with adding your data you seem to update the very next day!

Thanks!

This last time I noticed a number of your title column data were wrong, like everything would point to another player except the title column. Not all of them of course, just the odd one.

05-28-2020, 04:22 PM	#42
kq76 Global Moderator Join Date: Nov 2002 Posts: 11,770	No, I think we're describing the same thing. I just would have described it differently. LeMandria may have said it best here though. The only difference is I was saying you could do it even before a single game is played, but I think Torg's way of doing it after the tourney has completed is probably better as, I'm not sure, but teams may have to set their rosters before those players can be picked up from the search. Or maybe not. I was just being impatient with my way. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project)

06-08-2020, 05:23 PM	#44
Lemandria All Star Reserve Join Date: Sep 2019 Location: Chicagoland Posts: 702	Spreadsheet – PT21 Card Ratings FINAL RELEASE v2.5 6-8-2020 Links: Hitting Ratings MASTER v2.5 Pitching Ratings MASTER v2.5 All right, for those of you who’ve never used Player Search extensively, there is a known feature where leagues exceeding a certain size (4096 players) force the report to paginate. Instead of getting one report, you get 102 pages of individual reports…one…page…at…a…time. The average league is 30 teams. 30 teams x 200 active roster is? Yep, 6000. An average league will break Player Search’s functionality as a report. I’m currently playing in six leagues, and FOUR of them are ‘broken,’ for example. It used to be, perhaps, that a 200 man roster was more rare than it is today. Collections force nearly everyone to cap out their teams with a large list of locked players, particularly when Live collections are de facto required to compete. Whatever the reason, that pagination is enormously unfriendly to a big data approach. I saw this coming, the eventual end of this project. When the Live players go Live (MLB starts playing games again), updating this sheet on a weekly basis will become impossible. So, I’m calling it quits unless or until that pagination limit gets raised far enough for Player Search to be usable at a typical league level. If that’s even possible, maybe it isn’t. Maybe OOTPD is so choked for throughput with their current ISP that they don’t want big data approaches to their game. More than possible. __________________ FOTF victim Farewell

06-08-2020, 07:30 PM	#45
kq76 Global Moderator Join Date: Nov 2002 Posts: 11,770	Yeah, I had the same problem last night with one of my leagues. At first I thought my game was glitching out then I came across that it's a known issue. I asked if they could make the setting configurable in the app.cfg file in the future. What maybe we can do in the future is post records of data that we've entered by hand and then when we add it to your data we can just add a column that it was from another source. Thanks again for all your work! __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project)

06-18-2020, 04:55 PM	#49
benderguy1 Minors (Single A) Join Date: Aug 2019 Posts: 69	Thanks for doing this, Lemandria! It's much appreciated! __________________ OOTP 21: FTP Team: FTP Theme Team:

07-28-2020, 11:35 AM	#50
Lemandria All Star Reserve Join Date: Sep 2019 Location: Chicagoland Posts: 702	Final pre-Live Live Cards update? Probably. https://facethecurtain.wordpress.com/spreadsheet/ Largely taken over by @YourKidnies Sheet __________________ FOTF victim Farewell Last edited by Lemandria; 07-31-2020 at 01:13 PM.

05-29-2020, 09:44 AM	#43
jeffstified Minors (Double A) Join Date: Feb 2019 Posts: 141	After the tourney you can get actual stats. Which is how I built my iron team.

06-08-2020, 08:37 PM	#46
Sharkn20 Minors (Triple A) Join Date: May 2015 Posts: 289	Do we have this for OOTPXX?? Sent from my SM-G960F using Tapatalk

08-03-2020, 05:19 PM	#51
Lemandria All Star Reserve Join Date: Sep 2019 Location: Chicagoland Posts: 702	v3.1 There really will be some 'live' cards, just any day now (we hope). __________________ FOTF victim Farewell

08-10-2020, 05:18 PM	#52
Lemandria All Star Reserve Join Date: Sep 2019 Location: Chicagoland Posts: 702	v 3.2 Version 3.2, first "live" cards updated! __________________ FOTF victim Farewell

08-10-2020, 09:06 PM	#53
kq76 Global Moderator Join Date: Nov 2002 Posts: 11,770	LOL, whenever I finally get around to updating my sheet with adding your data you seem to update the very next day! Thanks! This last time I noticed a number of your title column data were wrong, like everything would point to another player except the title column. Not all of them of course, just the odd one. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project)