Need help configuring Tournament rosters in PT? Here you go!

Rich Grisham · 09-26-2020, 12:50 AM

Ever wanted to tinker with various combinations of players and see what a Tournament roster could look like?

Community member Simple Enigma has, and he's graciously offered to share his 'alpha' version of a Tournament Roster builder. Currently configured to support Bronze and Iron tournaments, it's a fun way to mix and match players to see how far over/under the cap you can be and what different combinations of rosters may look!

There is a lot of manual work that's gone into it, with plenty more to come. Here it is in its current state:

https://1drv.ms/x/s!ApwCHLSsAn0y3F69...Yt2gi?e=TPuEae

Check out a recent livestream of ours where we reviewed it together and used it to build a Bronze 1375 Cap roster that ultimately was right on the nose!

https://www.twitch.tv/videos/752331845

Thank you Simple Enigma!

BatAround · 09-26-2020, 11:35 AM

When I open the file, it says it's "read only" and I can't add anything to the cells. When I download the file as excel, the Defense, Offense, and Pitching Values tabs aren't populated, so the spreadsheet only produces errors.

SimpleEnigma · 09-26-2020, 02:41 PM

Quote:

Originally Posted by BatAround

When I open the file, it says it's "read only" and I can't add anything to the cells. When I download the file as excel, the Defense, Offense, and Pitching Values tabs aren't populated, so the spreadsheet only produces errors.

Hi! The next major update I hope to make to the spreadsheet is to make it usable in browser with the full collection of cards (or as close as I can get to it) available. Right now it only works when downloaded, and only with Office 365. I'm more than willing to assist anyone with converting it to work with older versions of Excel and Google Sheets, but hopefully that won't be necessary once I have it working in browser.

Based on those value tabs being blank, I am assuming you have an older version of Excel? I use XLOOKUP extensively throughout the spreadsheet which sadly is exclusive to Office 365. It can be replaced with VLOOKUP but will be very tedious.

BatAround · 09-26-2020, 02:56 PM

Ah, ok. I'm using Microsoft Office Home and Student 2019, I'm not up on all of the different versions but I assume Office 365 is different.

adion · 11-03-2020, 08:30 AM

Is there an updated version of the this spreadsheet? If so, where is it?

09-26-2020, 12:50 AM	#1
Rich Grisham Biz Dev Join Date: Dec 2015 Posts: 442	Need help configuring Tournament rosters in PT? Here you go! Ever wanted to tinker with various combinations of players and see what a Tournament roster could look like? Community member Simple Enigma has, and he's graciously offered to share his 'alpha' version of a Tournament Roster builder. Currently configured to support Bronze and Iron tournaments, it's a fun way to mix and match players to see how far over/under the cap you can be and what different combinations of rosters may look! There is a lot of manual work that's gone into it, with plenty more to come. Here it is in its current state: https://1drv.ms/x/s!ApwCHLSsAn0y3F69...Yt2gi?e=TPuEae Check out a recent livestream of ours where we reviewed it together and used it to build a Bronze 1375 Cap roster that ultimately was right on the nose! https://www.twitch.tv/videos/752331845 Thank you Simple Enigma! __________________

11-03-2020, 08:30 AM	#5
adion All Star Starter Join Date: Apr 2006 Posts: 1,376	Updated version Is there an updated version of the this spreadsheet? If so, where is it?

09-26-2020, 11:35 AM	#2
BatAround Minors (Single A) Join Date: Apr 2020 Posts: 57	When I open the file, it says it's "read only" and I can't add anything to the cells. When I download the file as excel, the Defense, Offense, and Pitching Values tabs aren't populated, so the spreadsheet only produces errors.

09-26-2020, 02:56 PM	#4
BatAround Minors (Single A) Join Date: Apr 2020 Posts: 57	Ah, ok. I'm using Microsoft Office Home and Student 2019, I'm not up on all of the different versions but I assume Office 365 is different.