Author Topic: Google Sheet Thing  (Read 1131 times)

0 Members and 1 Guest are viewing this topic.

Offline shooter47

  • MVP
  • ****
  • Join Date: Apr 2011
  • Posts: 4936
  • Bonus inPoints: 0
    • :MIN-NFL:
    • :MIN-NBA:
    • :MIN-NHL:
    • :NorthDakotaState:
    • View Profile
Re: Google Sheet Thing
« Reply #10 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...

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

Offline SlackJack

  • Legend
  • *****
  • Join Date: Jan 2012
  • Posts: 5155
  • Bonus inPoints: 0
  • Director of Media Relations
    • :Blank:
    • :Blank:
    • :PHI-NHL:
    • :Blank:
    • View Profile
Re: Google Sheet Thing
« Reply #11 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.
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 Rob

  • Legend
  • *****
  • Join Date: Oct 2010
  • Posts: 19209
  • Bonus inPoints: 3
    • :NE:
    • :BOS-NBA:
    • :BOS-NHL:
    • :NewHampshire:
    • :NER:
    • :BOS:
    • View Profile
Re: Google Sheet Thing
« Reply #12 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. 
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline Anthony

  • Legend
  • *****
  • Join Date: Feb 2011
  • Posts: 10065
  • Bonus inPoints: 10000
    • :CHI:
    • :CHI-NBA:
    • :CHI-NHL:
    • :Minnesota:
    • :CHC:
    • View Profile
Re: Google Sheet Thing
« Reply #13 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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline Rob

  • Legend
  • *****
  • Join Date: Oct 2010
  • Posts: 19209
  • Bonus inPoints: 3
    • :NE:
    • :BOS-NBA:
    • :BOS-NHL:
    • :NewHampshire:
    • :NER:
    • :BOS:
    • View Profile
Re: Google Sheet Thing
« Reply #14 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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline jmtrops

  • Legend
  • *****
  • Join Date: Jan 2011
  • Posts: 5187
  • Bonus inPoints: 0
    • :NE:
    • :Blank:
    • :TBL:
    • :Blank:
    • View Profile
Re: Google Sheet Thing
« Reply #15 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.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline SlackJack

  • Legend
  • *****
  • Join Date: Jan 2012
  • Posts: 5155
  • Bonus inPoints: 0
  • Director of Media Relations
    • :Blank:
    • :Blank:
    • :PHI-NHL:
    • :Blank:
    • View Profile
Re: Google Sheet Thing
« Reply #16 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.
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:

 

Forum Search


Quick Profile

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

* Chat Room

Refresh History
  • Daddy: There is nothing like virgin teams that nobody else has been into. You get to inherit todays rosters. Then take them into the future.
    Today at 12:18:36 AM
  • Daddy: Usually taking over a team is inheriting someones mess which is why it was open. In startup leagues that isnt an issue.
    Today at 12:19:25 AM
  • Daddy: I forgot to text Brian. :doh:
    Today at 12:21:02 AM
  • Daddy: NBA LIVE Pre-Reserve sign up sheet [link] updated!
    Today at 02:31:32 AM
  • Daddy: I grew up watching The Rainman & The Glove. Welcome back to the NBA Seattle Supersonics. Ive missed ya.
    Today at 12:37:30 PM
  • OUDAN: Frick em, They are much better off in OKC
    Today at 12:54:01 PM
  • Daddy: Thats cold :rofl:
    Today at 01:03:25 PM
  • Daddy: I should have known you jumped off the Lakers and on to the home state squad. We havent talked basketball much here like the old days.
    Today at 01:08:21 PM
  • Daddy: When Philly drafted Embiid that year we had LOR (Lord of the Rings) and we talked much hoops.
    Today at 01:10:18 PM
  • OUDAN: I refused before because of KD but this squad you cant help but love the way they play
    Today at 01:17:16 PM
  • OUDAN: Also I swear I enjoy fantasy basketball more than any other.
    Today at 01:20:09 PM
  • Daddy: Well you are Oklahoma Dan. Makes sense for you to love OKC & OU. Fricking Boomer Sooner!!!
    Today at 01:35:12 PM
  • OUDAN: Truth
    Today at 02:00:20 PM
  • Daddy: You are also top 5 in my All Time Greatest Fantasy GM ranking. We go back 14 years. If there is a Mount Rushmore for dynasty GMs. You Qualify.
    Today at 02:05:44 PM
  • Daddy: Thats also Truth. Ive seen them all.
    Today at 02:06:08 PM
  • OUDAN: Appreciate that man, Crazy how long some of us have been around here.
    Today at 02:15:49 PM
  • OUDAN: Crazy how long some of us have been on here
    Today at 02:15:58 PM
  • Daddy: I was hooked right away. Day 1 Scouting Department Baseball Milwaukee Brewers. Its like i was bit by a Vampire.
    Today at 02:26:34 PM
  • OUDAN: I miss when I cared enough about baseball to put the time in lol
    Today at 02:29:23 PM
  • Daddy: Fourteen years of learning. Ive seen leagues and sites fail and shutdown. Ive watched all the sites. All the leagues. People love to play for a buck.
    Today at 02:33:42 PM
  • OUDAN: I for sure prefer money leagues but yeah a lot have failed
    Today at 02:36:12 PM
  • Daddy: Nobody offered what i wanted. Just parts of it. Nobody did it completely right. They copied flawed concepts and theyve failed. 95% of all dynasty leagues fail.
    Today at 02:36:15 PM
  • Rhino7: OUDAN if you want OKC let me know, I’ll take a diff team. I’d like to compete against you more
    Today at 03:12:12 PM
  • OUDAN: Im in if thats an option
    Today at 04:00:45 PM
  • Rhino7: I’ll take Orlando if it’s not an issue
    Today at 04:08:55 PM
  • OUDAN: That would have been my 2nd choice
    Today at 04:15:52 PM
  • OUDAN: Thanks man for that swap
    Today at 04:16:52 PM
  • Daddy: I will make it so
    Today at 05:00:42 PM
  • OUDAN: Daddy why is OU listed in the big 12?
    Today at 05:18:25 PM
  • OUDAN: Move them where they belong in the SEC
    Today at 05:18:35 PM
  • BayAreaBallers: So is OUDAN strictly basketball now?
    Today at 05:18:43 PM
  • BayAreaBallers: OU is still technically in big 12
    Today at 05:19:25 PM
  • OUDAN: I still have a few football leagues
    Today at 05:19:26 PM
  • BayAreaBallers: Sec move won't happen till 2025
    Today at 05:19:42 PM
  • OUDAN: When the league starts they will be SEC
    Today at 05:19:44 PM
  • OUDAN: Your league so of course its ok either way
    Today at 05:20:38 PM
  • BayAreaBallers: Ik this because I currently live in y'all's rival team
    Today at 05:20:40 PM
  • BayAreaBallers: I'll be going to some UT Austin games again
    Today at 05:21:22 PM
  • BayAreaBallers: I've gone to some for baseball and one football
    Today at 05:21:39 PM
  • OUDAN: Im sorry you are going to have to watch that Crap school do anything
    Today at 05:22:11 PM
  • Daddy: Im still setting it up Dan
    Today at 05:22:37 PM
  • OUDAN: Gotcha, I trust you either way
    Today at 05:22:56 PM
  • BayAreaBallers: Honestly it's not the school I even support but it's greats sports environment
    Today at 05:24:09 PM
  • BayAreaBallers: Baseball is a great vibe. Football was fun. Basketball is next on my list
    Today at 05:24:58 PM
  • BayAreaBallers: UT ain't Crap I'll tell you that. From what I've seen and follow
    Today at 05:25:26 PM
  • OUDAN: They sure think they are the best at everything lol
    Today at 05:26:21 PM
  • BayAreaBallers: I enjoyed the games I've gone to so far
    Today at 05:26:59 PM
  • BayAreaBallers: That's mainly why I went was cuz I enjoy going to sports games
    Today at 05:28:05 PM
  • OUDAN: You gonna have to pay PJ washington in CCD the way he is playing
    Today at 05:28:13 PM
  • OUDAN: College games always have great atmospheres
    Today at 05:28:31 PM