Author Topic: Google Sheet Thing  (Read 912 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: 5138
  • 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: 19177
  • 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: 10059
  • 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: 19177
  • 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: 5180
  • 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: 5138
  • 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: Back @janes
    April 14, 2024, 05:00:16 PM
  • Rhino7: If you’re in CCD and plan to return next season, make sure to check-in asap before it’s too late! Notices have been made and soon some of you could get replaced. Only takes a moment to get it done. [link]
    April 14, 2024, 06:08:14 PM
  • STLBlues91: Just got home so replying to all messages now
    April 14, 2024, 08:37:13 PM
  • jimw: CCD championship ended one week ago and we are pressured to decide right away if we are coming back or we lose our team?
    April 14, 2024, 08:39:48 PM
  • Rhino7: It’s a dynasty league so we assume everyone plans to return. This is the time for those who definitely don’t plan to return to say so that way we know ahead of time we have to find replacements. Nobody is pressuring you, it’s more of a courtesy to the LM who do this for nothing so they can make a game plan for next season.
    April 14, 2024, 11:13:17 PM
  • PsychoticPondGoons: FNHL FINALS scoring update after 1 week with 4 days to go.  :ANA: Ducks 112.05 v 149.85 :NYR: Rangers [link] :taco:
    April 14, 2024, 11:51:20 PM
  • indiansnation: Indians mlb live looking to trade looking for a bat or 2 and starting pitching.
    April 15, 2024, 03:38:50 PM
  • indiansnation: Jim w pm
    April 15, 2024, 05:43:06 PM
  • Daddy: Brian you are in 11 leagues? You are a true legend dude.
    April 15, 2024, 06:04:36 PM
  • Daddy: Sports Fan dynasty legend.
    April 15, 2024, 06:05:16 PM
  • BayAreaBallers: I'm in 10
    April 15, 2024, 07:06:08 PM
  • BayAreaBallers: And active in all
    April 15, 2024, 07:06:41 PM
  • indiansnation: Jim w pm
    April 15, 2024, 07:22:14 PM
  • indiansnation: Daddy pm
    April 15, 2024, 07:22:40 PM
  • STLBlues91: ill be around the rest of the day
    April 15, 2024, 07:27:08 PM
  • Daddy: Youre getting the full experience in that many leagues. There is always something to do.
    April 15, 2024, 07:33:19 PM
  • Daddy: Each league is different so makes you approach things differently.
    April 15, 2024, 07:33:43 PM
  • Jon: i have openings in SEC football 1st year league
    April 15, 2024, 07:54:15 PM
  • Jon: I am pretty sure that I am going to do away with the 64 team league as I can't justify paying the fee that Fantrax wants
    April 15, 2024, 07:54:44 PM
  • Jon: [link]
    April 15, 2024, 07:56:47 PM
  • Daddy: I pay about $500 in fantrax fees. I feel ya Jon.
    April 15, 2024, 08:09:00 PM
  • Daddy: Probably more if i added it all up. All that work + all that money = why very few do it. #Respect
    April 15, 2024, 08:11:47 PM
  • indiansnation: Bigfry pm
    April 15, 2024, 09:52:34 PM
  • indiansnation: Jim w one last pm
    April 16, 2024, 01:01:12 AM
  • indiansnation: Trade posted jim w
    April 16, 2024, 01:02:15 AM
  • BayAreaBallers: Two late night deals
    April 16, 2024, 01:18:11 AM
  • Brent: Good morning guys.  Just a heads up, I am cutting back on leagues by a lot.  I'll message the commissioners which ones, but between work, school, fishing and family the thing that is going to get cut is fantasy sports.
    April 16, 2024, 07:30:32 AM
  • PsychoticPondGoons: :taco::taco::taco: FNHL WELCOMES OUR NEWEST OWNER BRUISER :judge: BRUISER HAS COMPLETED PURCHASE OF THE ARIZONA/UTHA COYOTES FRANCHISE :PHO2: [link] :PHO2:
    April 16, 2024, 11:37:48 AM
  • STLBlues91: ill be around the rest of the night for deals
    April 16, 2024, 08:13:31 PM
  • indiansnation: Updated trade block in fgm
    April 17, 2024, 12:37:39 AM
  • indiansnation: Indians in mlb live looking to trade
    April 17, 2024, 01:48:22 AM
  • jschwab: Leagues?? I'm in 14 MLB, 2 NHL, 1 NFL and 2 NBA.
    April 17, 2024, 12:33:58 PM
  • jschwab: It's nice being retired with a wife that likes me to stay out of her hair.
    April 17, 2024, 12:34:21 PM
  • jschwab: Oh yeah, and now 1 big honkin' NCAA
    April 17, 2024, 12:34:50 PM
  • Jwalkerjr88: Haha nice jschwab
    April 17, 2024, 12:45:03 PM
  • BayAreaBallers: Indians pm
    April 17, 2024, 01:42:37 PM
  • Daddy: @John :rofl: respect
    April 17, 2024, 02:58:00 PM
  • Daddy: Fantasy sports IS MY getaway. Im a Dad, i work, i deal in real world Crap all day. I travel a lot across the country. My Son and others on site know the life. :rofl:
    April 17, 2024, 02:59:59 PM
  • Daddy: I imagine running a league is equivalent to running 10-32 teams by itself. I can do that from the Crapter.
    April 17, 2024, 03:01:15 PM
  • Daddy: And still be a dad, go on trips, get much booty :) . And im an old fart.
    April 17, 2024, 03:02:42 PM
  • Daddy: oh s?, el pap? hace tiempo para mi bot?n.
    April 17, 2024, 03:05:58 PM
  • dbreer23: Mucho respecto!
    April 17, 2024, 03:31:00 PM
  • STLBlues91: ill be around the rest of the night for any deals
    April 17, 2024, 06:58:06 PM
  • Daddy: Michael Porter Jr.'s brother Jontay.... Banned for life by NBA for gambling.
    April 17, 2024, 07:58:24 PM
  • Daddy: He bet on his own performance (under) and his team to lose games.
    April 17, 2024, 07:58:57 PM
  • dbreer23: good riddance
    April 17, 2024, 10:17:11 PM
  • dbreer23: and I'm not even a NBA fan
    April 17, 2024, 10:17:20 PM
  • Daddy: Gambling is as bad an addiction as there is.  This guy comes from money, has a brother thats uber rich, and he himself was in the NBA.
    April 17, 2024, 11:00:36 PM
  • PsychoticPondGoons: FNHL FINALS looking very tough for one team :ANA: 155.05 v 236.25 :NYR: with only today's games left to plan. :judge: [link]
    Yesterday at 10:44:33 AM
  • STLBlues91: ill be around the rest of the day for any deals
    Yesterday at 06:30:53 PM