www.fantrax.com (GM's must have a fantrax ID to participate.)

* Dynasty NHL


Author Topic: Google Sheet Thing  (Read 1820 times)

0 Members and 1 Guest are viewing this topic.

Offline SlackJack

  • *ProFSL Hall Of Famer
  • GM (Elite)
  • ***
  • Join Date: Jan 2012
  • Posts: 5160
  • Bonus inPoints: 0
  • Director of Media Relations
    • :Blank:
    • :Blank:
    • :PHI-NHL:
    • :Blank:
    • :Blank:
Re: Google Sheet Thing
« Reply #17 on: November 24, 2020, 05: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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions
:SC-NHL: :SC-NHL: :SC-NHL: :SC-NHL:  2015-16, 2017-18, 2018-19, 2019-20 Backyard NHL Stanley Cup Champion :STL-NHL:

Offline jmtrops

  • *ProFSL Hall Of Famer
  • GM (Elite)
  • ***
  • Join Date: Jan 2011
  • Posts: 5214
  • Bonus inPoints: 0
    • :NE:
    • :Blank:
    • :TBL:
    • :Blank:
Re: Google Sheet Thing
« Reply #16 on: November 24, 2020, 02: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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Online Rob

  • *ProFSL Hall Of Famer
  • GM (Hall Of Fame)
  • ***
  • Join Date: Oct 2010
  • Posts: 19311
  • Bonus inPoints: 3
    • :NE:
    • :BOS-NBA:
    • :BOS-NHL:
    • :NewHampshire:
Re: Google Sheet Thing
« Reply #15 on: November 24, 2020, 02: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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline Anthony

  • *ProFSL Hall Of Famer
  • GM (Hall Of Fame)
  • ***
  • Join Date: Feb 2011
  • Posts: 10070
  • Bonus inPoints: 10000
    • :CHI:
    • :CHI-NBA:
    • :CHI-NHL:
    • :Minnesota:
    • :CHC:
Re: Google Sheet Thing
« Reply #14 on: November 24, 2020, 02: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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Online Rob

  • *ProFSL Hall Of Famer
  • GM (Hall Of Fame)
  • ***
  • Join Date: Oct 2010
  • Posts: 19311
  • Bonus inPoints: 3
    • :NE:
    • :BOS-NBA:
    • :BOS-NHL:
    • :NewHampshire:
Re: Google Sheet Thing
« Reply #13 on: November 24, 2020, 01: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. 
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline SlackJack

  • *ProFSL Hall Of Famer
  • GM (Elite)
  • ***
  • Join Date: Jan 2012
  • Posts: 5160
  • Bonus inPoints: 0
  • Director of Media Relations
    • :Blank:
    • :Blank:
    • :PHI-NHL:
    • :Blank:
    • :Blank:
Re: Google Sheet Thing
« Reply #12 on: November 24, 2020, 12: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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions
:SC-NHL: :SC-NHL: :SC-NHL: :SC-NHL:  2015-16, 2017-18, 2018-19, 2019-20 Backyard NHL Stanley Cup Champion :STL-NHL:

Offline shooter47

  • *ProFSL Hall Of Famer
  • GM (Elite)
  • ***
  • Join Date: Apr 2011
  • Posts: 4938
  • Bonus inPoints: 0
    • :MIN-NFL:
    • :MIN-NBA:
    • :MIN-NHL:
    • :NorthDakotaState:
    • :MIN:
Re: Google Sheet Thing
« Reply #11 on: November 24, 2020, 12: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...

funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline SlackJack

  • *ProFSL Hall Of Famer
  • GM (Elite)
  • ***
  • Join Date: Jan 2012
  • Posts: 5160
  • Bonus inPoints: 0
  • Director of Media Relations
    • :Blank:
    • :Blank:
    • :PHI-NHL:
    • :Blank:
    • :Blank:
Re: Google Sheet Thing
« Reply #10 on: November 24, 2020, 12: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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions
:SC-NHL: :SC-NHL: :SC-NHL: :SC-NHL:  2015-16, 2017-18, 2018-19, 2019-20 Backyard NHL Stanley Cup Champion :STL-NHL:

Offline shooter47

  • *ProFSL Hall Of Famer
  • GM (Elite)
  • ***
  • Join Date: Apr 2011
  • Posts: 4938
  • Bonus inPoints: 0
    • :MIN-NFL:
    • :MIN-NBA:
    • :MIN-NHL:
    • :NorthDakotaState:
    • :MIN:
Re: Google Sheet Thing
« Reply #9 on: November 23, 2020, 06: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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline Anthony

  • *ProFSL Hall Of Famer
  • GM (Hall Of Fame)
  • ***
  • Join Date: Feb 2011
  • Posts: 10070
  • Bonus inPoints: 10000
    • :CHI:
    • :CHI-NBA:
    • :CHI-NHL:
    • :Minnesota:
    • :CHC:
Re: Google Sheet Thing
« Reply #8 on: November 23, 2020, 06: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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

 

Quick Profile

 
 
Welcome, Guest. Please login or register.
Did you miss your activation email?

GM Level Up Available!

* Chat Room

Refresh History
  • POWERHOUSE: Lmao even
    September 12, 2024, 06:00:11 PM
  • LIVE DynastySports: 100,000 site visitors today 9/12/24 (first time). Thank you!
    September 12, 2024, 11:04:54 PM
  • Brian: If any one is interested in taking over mlb live Guardians please pm me or let one of the mods know in mlb live. I want to be the new exspansion team expos in mlb live but i got to find someone for cleveland guardians first. The team is set up to make it to playoffs in 2025.
    September 13, 2024, 12:51:57 AM
  • Brian: made it to 2nd rd of playoffs in 2024. Have a very good pitching staff and have a great hitting team. My minors our setup to be great.
    September 13, 2024, 12:54:44 AM
  • Brian: Built the pitching staff to be able to help guardians in next 2 to 3 yrs.
    September 13, 2024, 12:55:51 AM
  • Brian: Lost to a amazing team and a great gm in oakland was a close call could have gone either way.
    September 13, 2024, 12:57:10 AM
  • LIVE DynastySports: Montreal will be in the NL. You get an A for effort @Brian. :toth:
    September 13, 2024, 03:06:06 AM
  • Brian: Live dynasty sports  aka daddy pm
    September 13, 2024, 02:42:43 PM
  • jimw: The stats link Live DS posted is interesting. I was surprised to see I'm the #11 topic starter.
    September 13, 2024, 02:45:28 PM
  • jimw: Better than the #11 problem starter
    September 13, 2024, 02:47:41 PM
  • MauriceAJR: Eh same difference
    September 13, 2024, 04:25:46 PM
  • Brent: Damn, my time online is/was a lot.  IIRC, there was a time when I had the record for the most consecutive days.
    September 13, 2024, 05:43:36 PM
  • LIVE DynastySports: ProFSL expanded calendar [link]
    September 13, 2024, 06:35:57 PM
  • STLBlues91: Just sent you a message @Live
    September 13, 2024, 06:36:33 PM
  • LIVE DynastySports: Thank you.
    September 13, 2024, 06:44:32 PM
  • LIVE DynastySports: Site upgrades are on going. We never stop upgrading leagues or the site so that tomorrow's experience will always be better than yesterday's.
    September 13, 2024, 06:47:11 PM
  • LIVE DynastySports: @LNL this is "transfer portal" only recruiting. Meaning 5 per team. National Recruiting is closed. Thank you :toth:
    September 13, 2024, 09:37:31 PM
  • jimw: Brent you're only 600 days out of the #1spot :) will take awhile
    September 13, 2024, 10:02:23 PM
  • LIVE DynastySports: Happy Birthday @TheProfessor. May you have many more.
    September 14, 2024, 11:02:08 AM
  • Ben: Good Saturday morning all. Hoping to see some chaos today in the college ranks
    September 14, 2024, 11:15:12 AM
  • Brian: Good morning ben
    September 14, 2024, 11:36:51 AM
  • Brian: Happy birthday professor
    September 14, 2024, 11:37:42 AM
  • Brian: 4340 people on here today thats crazy.
    September 14, 2024, 11:38:21 AM
  • Brian: I have been on this site for a long time we have never had that many and i mean never.
    September 14, 2024, 11:39:06 AM
  • Brent: @jimw, I did take a near 3-year break from ProFSL from Dec 2015 until summer of 2018.
    September 14, 2024, 07:33:33 PM
  • ldsjayhawk: Well one of these 4000 people out here need to step up and take on an FGM team.  :NYY: is open and :OAK: & :SEA: have not checked in.  As far as I concerned, of olI can get an active GM to take them on, they're open too.
    September 14, 2024, 08:52:26 PM
  • ldsjayhawk: Show me that you're not just all bots!  [link]
    September 14, 2024, 08:53:06 PM
  • ldsjayhawk: No ghosts need apply, just real people please
    September 14, 2024, 08:54:22 PM
  • Mt_Crushmore: I'm waiting for this UFC dynasty to be generated. This UFC card is crazy tonight. And there is the dome in Vegas. New bucketlist adventure
    September 14, 2024, 09:47:09 PM
  • LIVE DynastySports: Working on it.
    September 14, 2024, 09:48:56 PM
  • Brian: If anybody is interested we have openings in fgm Yankees and seattle u can pm me if interested in a great baseball league
    September 14, 2024, 10:27:04 PM
  • LIVE DynastySports: There is not one league that should have an opening besides the new concept leagues that are start ups.
    September 15, 2024, 10:30:01 PM
  • LIVE DynastySports: ProFSL stats [link]
    September 16, 2024, 09:00:32 AM
  • Rhino7: Thanks for the stream
    September 16, 2024, 08:11:54 PM
  • LIVE DynastySports: You're welcome!
    September 16, 2024, 08:53:14 PM
  • LIVE DynastySports: NCAA LIVE POWER 25 NATIONAL RANKINGS [link]
    September 16, 2024, 10:17:06 PM
  • LIVE DynastySports: Week 3 NFL LIVE Matchup/Preview [link]
    September 17, 2024, 12:58:17 PM
  • LIVE DynastySports: :LVG:
    September 18, 2024, 12:29:42 AM
  • LIVE DynastySports: :LVG2:
    September 18, 2024, 12:55:33 AM
  • LIVE DynastySports: Welcome to MLB LIVE Las Vegas Gamblers. those are your new logos. :toth: (LVG & LVG2)
    September 18, 2024, 01:00:06 AM
  • ldsjayhawk: So, are they moving to Oakland when the A's move to Las Vegas?  Lol
    September 18, 2024, 10:44:51 AM
  • TheProfessor: Viva Las Vegas!!!
    September 18, 2024, 11:22:49 AM
  • jimw: A's moving to Las Vegas for 2028 season.  Playing in Sacramento until then
    September 18, 2024, 06:16:36 PM
  • LIVE DynastySports: 155 member accounts have logged on at some point in 2024. Some of them are no longer with us (RIP). We only have one league with over 32 GMs needed to be full.
    Yesterday at 10:24:07 AM
  • LIVE DynastySports: That league NCAA LIVE is full (or can be at any time) needing 64 Membered GMs. If anyone has a 30 team or less league that isn't full. It's not because of the site or GM pool.
    Yesterday at 10:31:19 AM
  • LIVE DynastySports: 100 members since 8/19/24 alone have logged on. :toth:
    Yesterday at 11:37:08 AM
  • Mt_Crushmore: Hello
    Yesterday at 06:14:39 PM
  • LIVE DynastySports: Hello @Eric, 2593 new member accounts have been rejected so far in 2024. Thankfully you were not one of them. :)
    Yesterday at 06:33:33 PM
  • LIVE DynastySports: Fight Night [link]
    Yesterday at 06:41:03 PM
  • STLBlues91: Ill be around the rest of the night. Been sick all week so been processing and sleeping so around to talk any trades
    Yesterday at 07:07:32 PM

Dynastic Calendar

September 2024
Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 [21]
22 23 24 25 26 27 28
29 30

No calendar events were found.

Database Search