Author Topic: Google Sheet Thing  (Read 1480 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: 19225
  • 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: 19225
  • 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: 5188
  • 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
  • OUDAN: Imagine lying to all of us like that lollll\
    Yesterday at 03:48:54 PM
  • Daddy: Up yours Danno :rofl:
    Yesterday at 04:16:28 PM
  • OUDAN: Hahaha
    Yesterday at 04:22:07 PM
  • Daddy: Takes a certain kind of guy to even do dynasty and unfortunately many of them are.. umm "sensitive" is a good word. I am a lot of personality, but im very good at what i do. I might suck at everything else but in dynasty fantasy i am ELITE.
    Yesterday at 04:29:57 PM
  • Daddy: As both an owner & moderator. It im ok letting you know about it.
    Yesterday at 04:30:41 PM
  • Daddy: Its ok to be diverse. Dont chat
    Yesterday at 04:31:36 PM
  • Daddy: Close the chat and just run your team.
    Yesterday at 04:31:59 PM
  • Daddy: In dynasty fantasy i have the Mamba mentality and there are others like me.
    Yesterday at 04:33:49 PM
  • Daddy: You own a baseball team for ten years and get mad you have to throw 35 innings pitched. In a week. Of baseball. Da fuq? No. Get out. Dont want you.
    Yesterday at 04:36:25 PM
  • Daddy: Fuq u been doing? Try art or some Crap. Take up painting. Ten years you cant field a starting rotation? Da fuq is you illiterate?
    Yesterday at 04:38:27 PM
  • Daddy: PLAYSTATION/XBOX = EA Sports (its in the game! :) )
    Yesterday at 04:40:06 PM
  • Daddy: The rest of you join my big mouth ass and lets play ball.
    Yesterday at 04:41:03 PM
  • Daddy: Hockey fan much [link] NHL LIVE is fantasy hockey on illegal substances. Just like NFL/MLB LIVE it offers a unique perspective on "modern day" fantasy sport experience.
    Yesterday at 05:27:47 PM
  • Daddy: NHL LIVE owners here are your spreadsheets [link] you can see your Franchises, your availability cap, your RFAs, all of it. Make your plans. Talk yo talk. Be ready.
    Yesterday at 05:50:15 PM
  • STLBlues91: I will be around the rest of the night. I will finish correcting 5 spreadsheets and then they all should match. I am officially on summer vacation
    Yesterday at 06:35:36 PM
  • Daddy: Shot out to YURmom. The first female of LIVE as its only female LIVE GM. Thats a keeper @Mt_Crushmore! :toast:
    Yesterday at 09:23:01 PM
  • Daddy: #Chicks dig da dynasty
    Yesterday at 09:24:43 PM
  • Daddy: Shot out to all actively bidding in the Nico Hoerner sweepstakes! [link] MLB LIVE never sleeps.
    Yesterday at 09:29:27 PM
  • Daddy: Shot out to @jmntl82 [link] congratulations on your first of many LIVE trades.
    Yesterday at 09:31:14 PM
  • Daddy: Well damn.. congratulations on your second trade in the last fifteen minutes. :rofl: Bartender i will have what he's having.
    Yesterday at 09:37:13 PM
  • IndianaBuc: I’ll have a double.
    Yesterday at 09:38:53 PM
  • jmntl82: Stay tuned, we're building something over here in Detroit
    Yesterday at 09:43:10 PM
  • Brent: PM sent Detroit
    Yesterday at 09:51:02 PM
  • Rhino7: Bartender pour me another :toast:
    Yesterday at 09:56:30 PM
  • Daddy: We are building something. In every sport. Non stop. Its what we do.
    Yesterday at 10:11:31 PM
  • Jwalkerjr88: Yup, sometimes people dont see the vision. Sometimes the vision Fricks up. You dont know till the chips are cashed in
    Yesterday at 10:12:50 PM
  • Jwalkerjr88: I once traded a full draft class 1-7, an additional 1st, 3 offensive flyer players for what player you might ask?
    Yesterday at 10:13:27 PM
  • Jwalkerjr88: WR Jalen Reagor lmaaooo  :rofl:
    Yesterday at 10:14:04 PM
  • Jwalkerjr88: And won my first chip that same season. Reagor starting in the flex scoring 9 points
    Yesterday at 10:14:39 PM
  • jmntl82: How did the other team finish?
    Yesterday at 10:16:01 PM
  • Jwalkerjr88: It was dallas. I think he missed the playoffs that year. Then used the draft picks on the 2021 class. Every pick was the 32nd pick (dont remembee what the other 1st became)
    Yesterday at 10:18:22 PM
  • Jwalkerjr88: Idk if anyone remembers the 2021 class but it was weak on offense outside or the top 10-15. I dont regret the deal just learned and move on. As long as you have assets, you can mold your build how you want. Picks are usually the most valuable asset because most gms want in on a draft.
    Yesterday at 10:19:34 PM
  • Jwalkerjr88: The results of that draft class is here [link]
    Yesterday at 10:20:27 PM
  • Jwalkerjr88: Every 32 overall pick dallas makes in each round came from that trade
    Yesterday at 10:20:54 PM
  • Jwalkerjr88: The 2024 and 2025 classes look much more promising than that one lol
    Yesterday at 10:22:06 PM
  • BayAreaBallers: 2021 draft class was my worst class as a NFL Live gm. my 2022 and 2023 were better
    Yesterday at 10:32:52 PM
  • Jwalkerjr88: I think it was the worst for most of us. It was a bad class overall. The top was amazing tho
    Yesterday at 10:42:05 PM
  • jimw: Etienne is amazing. He was near the top of that draft lol
    Yesterday at 11:18:42 PM
  • Brent: I got Nico Collins at 26.
    Yesterday at 11:20:10 PM
  • Daddy: You can use his bat n glove.
    Yesterday at 11:41:35 PM
  • dbreer23: I'm having issues trying to access league SS using Google Sheets. Anyone else having problems?
    Today at 12:32:38 AM
  • Jwalkerjr88: :beer:
    Today at 12:42:14 AM
  • Daddy: Which league SS
    Today at 12:56:47 AM
  • Daddy: NHL LIVE Buzz... "Tomas Hertl has just purchased land in the Delaware Valley. His agent suggests he loves Cheesesteaks
    Today at 01:30:45 AM
  • dbreer23: All league SS
    Today at 01:55:17 AM
  • dbreer23: which sucks bc I am headed out of town again tomorrow.
    Today at 01:55:29 AM
  • dbreer23: I'll be back on Monday to get things back in order in all leagues.
    Today at 02:00:12 AM
  • Daddy: Its local on your end @Dan
    Today at 02:06:12 AM
  • Daddy: I can see them all.
    Today at 02:06:47 AM
  • DaveW: safe travels Dan - I can also see the spreadsheets in both MLB Live and FGM
    Today at 07:05:08 AM