Saints 2020 and 2021 (edit) Possible Player Crisis (edit) (What Front Offices Don't Often Tell their Fans). This is an End User Modeler (I hope)
We are facing a massive talent loss in 2020 and 2021 including many young stars. I wanted us to be able to see the actual players, their numbers and be able for each viewer to do scenarios as they see best fit. I have been playing with these numbers in a live Google Sheets spreadsheet and it's real scary. We haven't had the numbers nor tools to see what the Saints FO is actually looking at and using for the basis for planning the actual 2020 and 2021 rosters. The purpose of this is so that we can see and model scenarios close to what the FO and SP are doing. Btw: this is real long with tons of actual data. If you want my early crisis observations, just view the Summary.
Here's Some Scary Facts that Jumped Off the Page for Me (SUMMARY)
2020 and 2021 Summary
- We have 17 Starters who will be FAs in 2020 and 2021 plus 9 Key Rotational Players
Players
2020 -A.J. Klein (2017-2019) Andrus Peat (2015-2019) Austin Carr (2017-2019) Cameron Tom (2019-2019) Colton Jumper (2019-2019) D.J. Swearinger (2019-2019) David Onyemata (2016-2019) Drew Brees (2018-2019) Dwayne Washington (2018-2019) Eli Apple (2016-2019) J.T. Gray (2019-2019) Johnson Bademosi (2019-2019) Josh Martin (2019-2019) Justin Hardee (2019-2019) Keith Kirkwood (2018-2019) Manti Te'o (2019-2019) Noah Spence (2019-2019) P.J. Williams (2019-2019) Patrick Omameh (2019-2019) Stephone Anthony (2019-2019) Taysom Hill (2017-2019) Ted Ginn Jr. (2017-2019) Teddy Bridgewater (2019-2019) Vonn Bell (2016-2019) Zach Line (2018-2019) Zach Wood (2019-2019), 2021 Alex Anzalone (2017-2020) Avlvin Kamara (2017-2020) Cole Wick (2020-2020) Craig Robertson (2019-2020) Demario Davis (2018-2020) Garrett Griffin (2019-2020) Janoris Jenkins (2016-2020) Jared Cook (2019-2020) Jason Vander Laan (2019-2020) Kiko Alonso (2017-2020) Krishawn Hogan (2019-2020) Larry Warford (2017-2020) Lil’jordan Humphrey (2019-2020) Marcus Williams (2017-2020) Mario Edwards (2019-2020) Maurice Harris (2020-2020) Ricky Ortiz (2020-2020) Sheldon Rankins (2016-2020) Taylor Stallworth (2019-2020) Trey Hendrickson (2017-2020)
- We need to reduce the current 2020 estimated cap by $68 million this year and nearly $50 million more next year
- As far as potential talent loss, this year is bad. Next year looks tragic for talent loss of key and star players
- And there's no Money left for any FAs
2020 FAs
- 8 more starters become FAs and 5 more key Rotational players are FAs including: Klein, Peat, Onyemata, Brees, Apple, T Hill, Ginn, V Bell and Line
- If we reduce the $68,000,000 required this year
- There's no money for new Free Agents
2021 FAs
- 9 more starters become FAs and 4 more key rotational players including: Anzalone, Kamara, Robertson, Demario Davis, Janoris Jenkins, Jared Cook, Alonso, Warford, Marcus Williams, Mario Edwards, Rankins, Stallworth and Hendrickson.
- If we reduce the $68,000,000 required this year, we need to reduce another $50 plus million in 2021
- There's no money for new Free Agents
_____________________________________________________________________________________________________________________________________________________________________
Assumptions and Notes
1) I made some estimates on cap hit costs if we keep players. idk this stuff so would like those who do to really step on for all of you to have this tool to see what you think it will look like and the moves they will have to make
2) The real Google Sheet is Color-coded and mathematically interactive. So if you delete a player, it reduces that from the project cap for that year. 2020 FAs and 2021 FAs are color coded in yellow, Starter in Yellow also. Top rotational players in light green and meh players with no color coding
3) In the real Google Sheet, it's like a game. When you delete a player, his cap hit gets deleted from the total cap hit. The Projected actual Cap for 2020 and 2021 are conditionally formatted so that anything above the Projected actual Caps are in Red cell until you delete enough players, or you can even restructure the numbers for Loomis type moves. When the user modified cap goes below the Projected actual Cap, the cell turns white
HELP PLEASE - Is there a way to embed an actual live Google Sheet into a SSF entry? If so, I can either follow instructions or PM you the live sheet.
Here's some frightening numbers and players at risk discovered in a few minutes of playing with the live Sheet. The one I pasted in below from Google Sheet is not mathematically active or color coded, but you can all see the basic numbers and players
Again, please keep in mind for future contracts I just guessed my best and my best at legit numbers for future player contracts is not awe inspiring for accuracy - lol
Here's Some Scary Facts that Jumped Off the Page for Me
2020 and 2021 Summary
- We have 17 Starters who will be FAs in 2020 and 2021 plus 9 Key Rotational Players
Players (Starters in Red font, key Rotational players in Blue font)
2020 -A.J. Klein (2017-2019) Andrus Peat (2015-2019) Austin Carr (2017-2019) Cameron Tom (2019-2019) Colton Jumper (2019-2019) D.J. Swearinger (2019-2019) David Onyemata (2016-2019) Drew Brees (2018-2019) Dwayne Washington (2018-2019) Eli Apple (2016-2019) J.T. Gray (2019-2019) Johnson Bademosi (2019-2019) Josh Martin (2019-2019) Justin Hardee (2019-2019) Keith Kirkwood (2018-2019) Manti Te'o (2019-2019) Noah Spence (2019-2019) P.J. Williams (2019-2019) Patrick Omameh (2019-2019) Stephone Anthony (2019-2019) Taysom Hill (2017-2019) Ted Ginn Jr. (2017-2019) Teddy Bridgewater (2019-2019) Vonn Bell (2016-2019) Zach Line (2018-2019) Zach Wood (2019-2019), 2021 Alex Anzalone (2017-2020) Avlvin Kamara (2017-2020) Cole Wick (2020-2020) Craig Robertson (2019-2020) Demario Davis (2018-2020) Garrett Griffin (2019-2020) Janoris Jenkins (2016-2020) Jared Cook (2019-2020) Jason Vander Laan (2019-2020) Kiko Alonso (2017-2020) Krishawn Hogan (2019-2020) Larry Warford (2017-2020) Lil’jordan Humphrey (2019-2020) Marcus Williams (2017-2020) Mario Edwards (2019-2020) Maurice Harris (2020-2020) Ricky Ortiz (2020-2020) Sheldon Rankins (2016-2020) Taylor Stallworth (2019-2020) Trey Hendrickson (2017-2020)
- We need to reduce the current 2020 estimated cap by $68 million this year and nearly $50 million more next year
- As far as potential talent loss, this year is bad. Next year looks tragic for talent loss of key and star players
- And there's no Money left for any FAs
2020 FAs
- 8 more starters become FAs and 5 more key Rotational players are FAs including: Klein, Peat, Onyemata, Brees, Apple, T Hill, Ginn, V Bell and Line
- If we reduce the $68,000,000 required this year
- There's no money for new Free Agents
2021 FAs
- 9 more starters become FAs and 4 more key rotational players are FAs
- If we reduce the $68,000,000 required this year, we need to reduce another $50 plus million in 2021
- There's no money for new Free Agents
- We have 8 2020 FA starters and 5 Rotational Starters and many are stars, then top players and solid players including: Anzalone, Kamara, Robertson, Demario Davis, Janoris Jenkins, Jared Cook, Alonso, Warford, Marcus Williams, Mario Edwards, Rankins, Stallworth and Hendrickson.
Note: Had to delete the full spreadsheet. It was too big for the post
We are facing a massive talent loss in 2020 and 2021 including many young stars. I wanted us to be able to see the actual players, their numbers and be able for each viewer to do scenarios as they see best fit. I have been playing with these numbers in a live Google Sheets spreadsheet and it's real scary. We haven't had the numbers nor tools to see what the Saints FO is actually looking at and using for the basis for planning the actual 2020 and 2021 rosters. The purpose of this is so that we can see and model scenarios close to what the FO and SP are doing. Btw: this is real long with tons of actual data. If you want my early crisis observations, just view the Summary.
Here's Some Scary Facts that Jumped Off the Page for Me (SUMMARY)
2020 and 2021 Summary
- We have 17 Starters who will be FAs in 2020 and 2021 plus 9 Key Rotational Players
Players
2020 -A.J. Klein (2017-2019) Andrus Peat (2015-2019) Austin Carr (2017-2019) Cameron Tom (2019-2019) Colton Jumper (2019-2019) D.J. Swearinger (2019-2019) David Onyemata (2016-2019) Drew Brees (2018-2019) Dwayne Washington (2018-2019) Eli Apple (2016-2019) J.T. Gray (2019-2019) Johnson Bademosi (2019-2019) Josh Martin (2019-2019) Justin Hardee (2019-2019) Keith Kirkwood (2018-2019) Manti Te'o (2019-2019) Noah Spence (2019-2019) P.J. Williams (2019-2019) Patrick Omameh (2019-2019) Stephone Anthony (2019-2019) Taysom Hill (2017-2019) Ted Ginn Jr. (2017-2019) Teddy Bridgewater (2019-2019) Vonn Bell (2016-2019) Zach Line (2018-2019) Zach Wood (2019-2019), 2021 Alex Anzalone (2017-2020) Avlvin Kamara (2017-2020) Cole Wick (2020-2020) Craig Robertson (2019-2020) Demario Davis (2018-2020) Garrett Griffin (2019-2020) Janoris Jenkins (2016-2020) Jared Cook (2019-2020) Jason Vander Laan (2019-2020) Kiko Alonso (2017-2020) Krishawn Hogan (2019-2020) Larry Warford (2017-2020) Lil’jordan Humphrey (2019-2020) Marcus Williams (2017-2020) Mario Edwards (2019-2020) Maurice Harris (2020-2020) Ricky Ortiz (2020-2020) Sheldon Rankins (2016-2020) Taylor Stallworth (2019-2020) Trey Hendrickson (2017-2020)
- We need to reduce the current 2020 estimated cap by $68 million this year and nearly $50 million more next year
- As far as potential talent loss, this year is bad. Next year looks tragic for talent loss of key and star players
- And there's no Money left for any FAs
2020 FAs
- 8 more starters become FAs and 5 more key Rotational players are FAs including: Klein, Peat, Onyemata, Brees, Apple, T Hill, Ginn, V Bell and Line
- If we reduce the $68,000,000 required this year
- There's no money for new Free Agents
2021 FAs
- 9 more starters become FAs and 4 more key rotational players including: Anzalone, Kamara, Robertson, Demario Davis, Janoris Jenkins, Jared Cook, Alonso, Warford, Marcus Williams, Mario Edwards, Rankins, Stallworth and Hendrickson.
- If we reduce the $68,000,000 required this year, we need to reduce another $50 plus million in 2021
- There's no money for new Free Agents
_____________________________________________________________________________________________________________________________________________________________________
Assumptions and Notes
1) I made some estimates on cap hit costs if we keep players. idk this stuff so would like those who do to really step on for all of you to have this tool to see what you think it will look like and the moves they will have to make
2) The real Google Sheet is Color-coded and mathematically interactive. So if you delete a player, it reduces that from the project cap for that year. 2020 FAs and 2021 FAs are color coded in yellow, Starter in Yellow also. Top rotational players in light green and meh players with no color coding
3) In the real Google Sheet, it's like a game. When you delete a player, his cap hit gets deleted from the total cap hit. The Projected actual Cap for 2020 and 2021 are conditionally formatted so that anything above the Projected actual Caps are in Red cell until you delete enough players, or you can even restructure the numbers for Loomis type moves. When the user modified cap goes below the Projected actual Cap, the cell turns white
HELP PLEASE - Is there a way to embed an actual live Google Sheet into a SSF entry? If so, I can either follow instructions or PM you the live sheet.
Here's some frightening numbers and players at risk discovered in a few minutes of playing with the live Sheet. The one I pasted in below from Google Sheet is not mathematically active or color coded, but you can all see the basic numbers and players
Again, please keep in mind for future contracts I just guessed my best and my best at legit numbers for future player contracts is not awe inspiring for accuracy - lol
Here's Some Scary Facts that Jumped Off the Page for Me
2020 and 2021 Summary
- We have 17 Starters who will be FAs in 2020 and 2021 plus 9 Key Rotational Players
Players (Starters in Red font, key Rotational players in Blue font)
2020 -A.J. Klein (2017-2019) Andrus Peat (2015-2019) Austin Carr (2017-2019) Cameron Tom (2019-2019) Colton Jumper (2019-2019) D.J. Swearinger (2019-2019) David Onyemata (2016-2019) Drew Brees (2018-2019) Dwayne Washington (2018-2019) Eli Apple (2016-2019) J.T. Gray (2019-2019) Johnson Bademosi (2019-2019) Josh Martin (2019-2019) Justin Hardee (2019-2019) Keith Kirkwood (2018-2019) Manti Te'o (2019-2019) Noah Spence (2019-2019) P.J. Williams (2019-2019) Patrick Omameh (2019-2019) Stephone Anthony (2019-2019) Taysom Hill (2017-2019) Ted Ginn Jr. (2017-2019) Teddy Bridgewater (2019-2019) Vonn Bell (2016-2019) Zach Line (2018-2019) Zach Wood (2019-2019), 2021 Alex Anzalone (2017-2020) Avlvin Kamara (2017-2020) Cole Wick (2020-2020) Craig Robertson (2019-2020) Demario Davis (2018-2020) Garrett Griffin (2019-2020) Janoris Jenkins (2016-2020) Jared Cook (2019-2020) Jason Vander Laan (2019-2020) Kiko Alonso (2017-2020) Krishawn Hogan (2019-2020) Larry Warford (2017-2020) Lil’jordan Humphrey (2019-2020) Marcus Williams (2017-2020) Mario Edwards (2019-2020) Maurice Harris (2020-2020) Ricky Ortiz (2020-2020) Sheldon Rankins (2016-2020) Taylor Stallworth (2019-2020) Trey Hendrickson (2017-2020)
- We need to reduce the current 2020 estimated cap by $68 million this year and nearly $50 million more next year
- As far as potential talent loss, this year is bad. Next year looks tragic for talent loss of key and star players
- And there's no Money left for any FAs
2020 FAs
- 8 more starters become FAs and 5 more key Rotational players are FAs including: Klein, Peat, Onyemata, Brees, Apple, T Hill, Ginn, V Bell and Line
- If we reduce the $68,000,000 required this year
- There's no money for new Free Agents
2021 FAs
- 9 more starters become FAs and 4 more key rotational players are FAs
- If we reduce the $68,000,000 required this year, we need to reduce another $50 plus million in 2021
- There's no money for new Free Agents
- We have 8 2020 FA starters and 5 Rotational Starters and many are stars, then top players and solid players including: Anzalone, Kamara, Robertson, Demario Davis, Janoris Jenkins, Jared Cook, Alonso, Warford, Marcus Williams, Mario Edwards, Rankins, Stallworth and Hendrickson.
Note: Had to delete the full spreadsheet. It was too big for the post