Author Topic: Google Sheet Thing  (Read 1377 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: 5156
  • 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: 19212
  • 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

Online 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: 19212
  • 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: 5156
  • 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: NHL LIVE will drop first. Hockey guys trade like crazy. Good luck. :)
    Yesterday at 08:12:04 PM
  • STLBlues91: Yeah working on that spreadsheet and a few fixes on it. May do some slight visual adds and then to NCAA football sheet which I got going as well
    Yesterday at 08:48:21 PM
  • Daddy: :toth: the best moderator team on the planet. Thanks! :toth:
    Yesterday at 09:14:11 PM
  • Daddy: Can you imagine a league(s).  Where EVERY player that becomes a professional has value.. and 30-32 teams have 30-32 different people are actively determining that value?
    Today at 01:46:50 AM
  • Daddy: Where you dont wait for trades to happen on scoring sites or SS updates and the only thing asked of you is to run your own franchise and see how good you are. On an EVEN playing field.
    Today at 01:48:59 AM
  • Daddy: Its already near impossible to get into NFL LIVE. We had to start up a 64 team league just to accommodate the waiting list. True Story.
    Today at 01:55:29 AM
  • Daddy: Once full. NBA, NHL, & NCAAs will be very difficult to get into. People dont just walk away from LIVE often and when they do... They usually want back in. Legit dont miss your team in your sports. Get them while you can.
    Today at 02:00:44 AM
  • IndianaBuc: RyanJames5 PM
    Today at 09:13:54 AM
  • indiansnation: Hey guys take a look at these baseball mugs
    Today at 01:53:49 PM
  • indiansnation: [link]
    Today at 01:53:56 PM
  • STLBlues91: Feel free to message I will be around for talks as I work on some spreadsheets
    Today at 04:43:35 PM
  • Daddy: @Brian the city of Pittsburgh would never forgive you for trading Crosby. Let him retire in Pittsburgh.
    Today at 05:58:55 PM
  • Daddy: I was looking forward to bashing you and him upside the head with these Flyers. Do not deny me that sir.
    Today at 06:00:04 PM
  • Mt_Crushmore: Man, I was thinking the same for Stamkos. Nevermind, were not allowed.
    Today at 06:10:06 PM
  • STLBlues91: I mean STL is a welcoming place
    Today at 06:14:03 PM
  • indiansnation: Nice job with NHL live  guys
    Today at 07:38:43 PM
  • Daddy: Thanks Brian. You've seen them all.
    Today at 07:51:41 PM
  • Daddy: We're nearly completed.
    Today at 07:55:40 PM
  • Braves155: Daddy you me & Brian gonna be at one each other a ton in hockey as I'm the Rangers in y'alls division
    Today at 09:04:25 PM
  • Daddy: I must break you.
    Today at 09:26:23 PM
  • STLBlues91: The guy that says that loses in the long run though...
    Today at 09:39:42 PM
  • Braves155: To hell with all Philly sports teams. :rofl:   ☠️ #TRUTH
    Today at 09:43:28 PM
  • Braves155: More importantly Mets suck
    Today at 09:44:57 PM
  • Daddy: @Blues... Not this guy.
    Today at 09:49:10 PM
  • STLBlues91: We shall see. May go fix some flyers cap hits real quick while i am at it.. They need a pay bump
    Today at 09:51:07 PM
  • BayAreaBallers: quick question on nhl live
    Today at 09:57:27 PM
  • BayAreaBallers: will there be a roster cleanup
    Today at 09:57:44 PM
  • Daddy: What you talkin bout Willis?
    Today at 09:58:35 PM
  • Daddy: Roster cleanup?
    Today at 09:58:51 PM
  • Daddy: @STLBlues91 look at the NHL LIVE chat window please.
    Today at 09:59:36 PM
  • STLBlues91: Going there now
    Today at 10:00:09 PM
  • BayAreaBallers: didnt you mention that some players on our roster have moved
    Today at 10:00:14 PM
  • BayAreaBallers: will that need to eb accounted for
    Today at 10:00:22 PM
  • Daddy: @BAB as per LIVE rules... All new ownership gets free drops year one.
    Today at 10:00:25 PM
  • BayAreaBallers: or are they still ours
    Today at 10:00:28 PM
  • BayAreaBallers: that part i get
    Today at 10:00:51 PM
  • Daddy: The rosters are set by a prior date not todays or tomorrows
    Today at 10:00:53 PM
  • Daddy: If someone appears on your roster its because they are your player
    Today at 10:01:21 PM
  • Daddy: Regardless of who they start the new season with.
    Today at 10:01:40 PM
  • BayAreaBallers: are we allowed to post drops now or is that at a different time
    Today at 10:02:42 PM
  • BayAreaBallers: last question
    Today at 10:02:46 PM
  • Daddy: Only the newest NBA LIVE rosters are unknown as we will go with the newest version for the upcoming 2024/25 season.
    Today at 10:02:54 PM
  • Daddy: NHL LIVE you must wait.
    Today at 10:03:15 PM
  • Daddy: It doesnt start till 6/1
    Today at 10:03:28 PM
  • Daddy: We just work fast ;)
    Today at 10:03:45 PM
  • Daddy: Looks like its ready but the SS isnt finished and we cant do transactions till we finish.
    Today at 10:04:25 PM
  • Daddy: Its not like the others. Its got NHL/AHL and formulas need perfected.
    Today at 10:04:56 PM
  • Daddy: A lot of LIVE GMs came after i had won in football and built a monster in baseball. Many of you weren't there for the start. Like STLBlues. Like Braves. So you talk smack to the old Man (me).
    Today at 10:09:00 PM
  • Daddy: I cannot wait to start these virgin leagues. So that (you too BAB) can get your deserved foots from day one. :)
    Today at 10:10:30 PM
  • Daddy: Size 13 (lubricant included sponsored by *Acme Bigfoot Jelly Inc)
    Today at 10:12:47 PM