ProFSL: Pro Fantasy Sports Leagues

Fantasy Leagues => Dynasty NHL => NHL Leagues => Dynasty NHL: Archive => Topic started by: SlackJack on November 23, 2020, 01:21:48 PM

Title: Google Sheet Thing
Post by: SlackJack on November 23, 2020, 01:21:48 PM
Not a huge fan of the google sheets in-lieu of profsl rosters but I'll adapt. One change for the better would be to stop projecting prospect contracts (p/na) ahead for 4 years at $500k. It really muddies the at-a-glance view. Would be better if when I look at the 2024/25 column (for example) I only see actual contract commitments, not place-holder numbers.
Title: Re: Google Sheet Thing
Post by: GypsieDeathBringer on November 23, 2020, 02:58:12 PM
What would be the suggested alternative way?
Title: Re: Google Sheet Thing
Post by: SlackJack on November 23, 2020, 04:32:48 PM
Simply fill in the current year with the $0.5 placeholder! Roll that forward one year at a time until the prospect is released or signed to a 5 year discounted pro-contract.

C   n/a   Nick Suzuki         $0.5   $0.5   $0.5   $0.5   $0.5

The (n/a) designation is reminder enough of what type of contract it is, and so by dropping the unnecessary row of $0.5's it would really enhance our ability to see how our pro-contracts are impacting future cap space!
Title: Re: Google Sheet Thing
Post by: SlackJack on November 23, 2020, 04:43:26 PM
Currently my Salary Cap projection for 24/25 is at $30m but I only have commitments of $22.5m. This gets remedied with that suggestion as well. 
Title: Re: Google Sheet Thing
Post by: jmtrops on November 23, 2020, 05:56:37 PM
I have my own speed sheet for my team and project future contracts for what I think they would be. for prospects on google we should show it for 3 years since we know it will at least be for 3.
Title: Re: Google Sheet Thing
Post by: SlackJack on November 23, 2020, 06:33:24 PM
for prospects on google we should show it for 3 years since we know it will at least be for 3.
This isn't true though as p/na contracts are only good until the end of the season in which they hit 40 games. Only the current years salary is a true commitment...so there is no good reason to clutter up a column by projecting $0.5 forward. After 40 games the contract will either be terminated or extended for 5 years at a different number.

Anyway I only raised this because it's an easy fix.  :thumbsup:
Title: Re: Google Sheet Thing
Post by: shooter47 on November 23, 2020, 06:37:42 PM
This isn't true though as p/na contracts are only good until the end of the season in which they hit 40 games. Only the current years salary is a true commitment...so there is no good reason to clutter up a column by projecting $0.5 forward. After 40 games the contract will either be terminated or extended for 5 years at a different number.

Anyway I only raised this because it's an easy fix.  :thumbsup:

I dont follow this at all. When a player is on a p-n/a contract its essentially a contract for 0.5m for all years in the future. Once a player hits 40 games played it changes to a salary of 0.5m for 2 years and then after that you'd have to extend. If you only show one year for a prospect contract your going to think you have more cap space for the following year then you do because you still have to pay your p-n/a guys 0.5m next year...
Title: Re: Google Sheet Thing
Post by: Anthony on November 23, 2020, 07:43:52 PM
I get what you're saying and I can cut it down to the current year and 2 additional years. I don't want to have the salary only shown in the current year for the reason shooter brought up.
Title: Re: Google Sheet Thing
Post by: shooter47 on November 23, 2020, 07:59:23 PM
I get what you're saying and I can cut it down to the current year and 2 additional years. I don't want to have the salary only shown in the current year for the reason shooter brought up.

I think how it is shown in the google spreadsheet is accurate how its currently shown. Below is how a prospect contract is described in the rules. They are eternal 500k contracts. So showing them as 500k contracts for each year shown on the spreadsheet is correct. I think if slackjack wants to look at salaries in the 2024-2025 year he can make his own roster spreadsheet and track them however he wants to.

Prospect Contracts
To simplify things, all prospects (under 40 NHL games played) will inherit $500k/yr contracts.  Prospect contracts are eternal, they will always make $500k and no extension is required.  The contract lasts for two years after the point they accumulate 40 NHL games played.  They may accumulate this over multiple years, but the two year rule does not take effect until the year they actually hit the accumulation threshold.  A player becomes ineligible for a prospect contract when that player is released from a prospect contract that had its two year clock already start.

Example:  Prospect X plays his 40th game in January of 2011.  His prospect contract would now take him through 11/12 & 12/13 and he will need to be extended to a normal contract for the 13/14 season.

Prospects on the minor league roster do not count towards the salary cap.  They only count towards the cap if they're on the NHL roster.
Title: Re: Google Sheet Thing
Post by: SlackJack on November 24, 2020, 01:08:52 PM
Quote
I think if slackjack wants to look at salaries in the 2024-2025 year he can make his own roster spreadsheet and track them however he wants to.
I already had one Shooter, that was the profsl roster sheet. If my team icon could link back to that instead of google that would be great. I'd happily maintain that as I never wanted to use a spreadsheet in the first place. I think it's great that there are steps to maintain the league in the event profsl goes down but I'm here for site first and league second.

As far as prospect contracts go I see what you are saying and from one point of view it makes sense. But I look at prospect contracts as being a different class of contract (from pro-contract commitments). Prospect contacts are less obligatory and much more fluid in terms of roster movement. The 40 game threshold is a wait-and-see period that let's us evaluate the prospect and so there is a moment one commits to these players but until they are signed to a pro-contract I view them as having roster optionality.
Title: Re: Google Sheet Thing
Post by: shooter47 on November 24, 2020, 01:31:14 PM
http://www.profsl.com/smf/index.php?topic=24719.0

Your page here on PROFSL didn't disappear. The quick link just doesn't work anymore as that directs you to the spreadsheet. The link above will take you to your page or you can get there by going to official rosters and then picking arizona.

Personally I keep a separate spreadsheet on my own outside of the google doc. That way I can track changes to my roster, project future resign values and see what FA or other additions to my roster look like. That is an easy thing for anyone to do whether it is a spreadsheet or a page here on profsl.

I get that you view prospect contracts differently. But they are 500k eternal contracts. And they continue to be 500k contracts until 1 of 2 things happens. If they go over 40 games played then you get 2 more years at 500k. Or if you drop the player the contract dissappears.

You are correct that they aren't guaranteed contracts. If I sign a player for 900k for two years though that is also an unguaranted contract. We wouldn't show those as 900k for only one year just because I could drop him and the next year isn't technically guaranteed...

Title: Re: Google Sheet Thing
Post by: SlackJack on November 24, 2020, 01:52:56 PM
 :iatp: Makes sense Shooter so let's call it personal preference then. I would love to see the link restored so that I can easily click on my team icon and go to my team as housed on profsl. You know...the way it always was and one of the primary things I like about both site and league.
Title: Re: Google Sheet Thing
Post by: Rob on November 24, 2020, 02:00:14 PM
:iatp: Makes sense Shooter so let's call it personal preference then. I would love to see the link restored so that I can easily click on my team icon and go to my team as housed on profsl. You know...the way it always was and one of the primary things I like about both site and league.

This is a request for Anthony - I used to be able to edit it, but those functions disappeared a while back and now we have an HTML block up there for the banner and all those links.  I would think resetting your link to the ProFSL page would be easy enough. 
Title: Re: Google Sheet Thing
Post by: Anthony on November 24, 2020, 03:29:53 PM
My hesitation with restoring the links to the old roster pages through the logos is that most teams won't keep their roster page maintained. At least if we link to google sheets it ensures an updated roster.

I'm with you slack, I like the classic roster pages better, but as we've run into before the two alternatives to keep those updated have flaws:

1. Updating the roster pages by hand is a giant waste of time and easy to make mistakes and no one wants to do it.

2. Maintaining an offline spreadsheet that you copy and paste onto the roster page leaves us with only one person that can update the roster, and if they disappear (ex. Ian in BY), we have to redo everything.
Title: Re: Google Sheet Thing
Post by: Rob on November 24, 2020, 03:37:52 PM
My hesitation with restoring the links to the old roster pages through the logos is that most teams won't keep their roster page maintained. At least if we link to google sheets it ensures an updated roster.

I'm with you slack, I like the classic roster pages better, but as we've run into before the two alternatives to keep those updated have flaws:

1. Updating the roster pages by hand is a giant waste of time and easy to make mistakes and no one wants to do it.

2. Maintaining an offline spreadsheet that you copy and paste onto the roster page leaves us with only one person that can update the roster, and if they disappear (ex. Ian in BY), we have to redo everything.

Can you just change his link and leave the rest of the links going to Google?  He's going to update on his own.
Title: Re: Google Sheet Thing
Post by: jmtrops on November 24, 2020, 03:51:43 PM
why dont we just have both links. I have been playing with my roster page so I like to keep it but the google sheet is the way to go as far as updating. just post another link to the pro roster page for those of us who want to keep them. I have been adding other info on mine about new players, prospects and other info I find interesting. I was in a dynasty BB league on another site long time ago that everyone had to maintain there own page with prospect grades and evaluations so Im kind of doing that here.
Title: Re: Google Sheet Thing
Post by: SlackJack on November 24, 2020, 06:57:22 PM
Can you just change his link and leave the rest of the links going to Google?  He's going to update on his own.
:iatp: I've been consistent in updating my profsl roster on my own roster for a few years now.