Jump to content


Member Since 19 Aug 2010
Offline Last Active Jun 01 2019 02:40 PM

Posts I've Made

In Topic: Edit a trade as commissioner?

05 May 2019 - 09:35 AM

ok thanks!

In Topic: Add players to rosters as commissioner

29 July 2018 - 08:52 AM

Take a peak at this google sheet I have put together, https://docs.google....dit?usp=sharing


Essentially, as players are acquired, they are entered into column A on the Bid Sheet tab.  As they are added there, they are struck through using conditional formatting on the Free Agents tab (I used Russel Wilson as an example).  After rookie draft (which we do online) I will need to pull all remaining rookies into free agent tab so they can be bid on in free agency auction.  


Overall seems to work very well and should not necessitate me loading them realtime and the cap is tracked as well in the bid sheet.  If you find this useful, feel free to use it.  


Future enhancement, I would like to pull in all current rosters and salaries to make cap tracking automatic.  I think I can do this via API.

In Topic: Add players to rosters as commissioner

29 July 2018 - 08:24 AM

Thanks Bonscott.  Yes they need to track themselves and that should be that  :).  I think they are all used to a more online type experience from other simpler leagues, and expect the website to aid them in players available, 2017 stats, etc.  I've always pushed back against them citing they should be taking care of this themselves...

In Topic: Add players to rosters as commissioner

28 July 2018 - 01:56 PM

I was just evaluating options. I commission a pretty complicated league and we do our free agent auction each year offline (all in one night). The owners in the league want the results loaded onto their roster in real-time. I was thinking about a button in google sheet or similar for each winning bid that would load them in.  The challenge for the owners is that free agents list doesnt update who is available unless I load them manually after each winning bid which is a pain and puts me at a disadvantage for bidding on free agents. Weve tried the live auction but it has never worked well for us. And maybe I am missing a method that is easier than. adding them via waivers in the website. Thanks.