Dynasty NHL

Home :: Fantrax :: Rules :: Transactions :: History



::
::

Author Topic: Official Q&A Thread  (Read 85358 times)

0 Members and 2 Guests are viewing this topic.

Offline Rob

  • League Moderator
  • Legend
  • *****
  • Join Date: Oct 2010
  • Posts: 19243
  • Bonus inPoints: 3
    • :NE:
    • :BOS-NBA:
    • :BOS-NHL:
    • :NewHampshire:
    • :NER:
    • :BOS:
    • View Profile
Re: Official Q&A Thread
« Reply #320 on: March 02, 2017, 09:37:45 AM »
When I started the league I was provided with a handy dandy spreadsheet by the ProFSL staff, back when the staff was active and engaged and eager to grow the website.  This spreadsheet is wonderfully formatted with equations that make my life super easy.  I'm fluent at using the spreadsheet, but the actual programming behind it is beyond my expertise.  Adding some data about future cap would be a nice feature, but I have no idea how to do it. 

About that 5.999999m crap - some kind of spreadsheet equation anomaly.  I think Anthony and I used the same sheet.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline snugerud

  • League Moderator
  • MVP
  • *****
  • Join Date: Jul 2011
  • Posts: 4392
  • Bonus inPoints: 0
  • I am the ghost of fantasy hockey past
    • :NE:
    • :TOR-NBA:
    • :PIT-NHL:
    • :Blank:
    • View Profile
Re: Official Q&A Thread
« Reply #321 on: March 02, 2017, 10:29:09 AM »
When I started the league I was provided with a handy dandy spreadsheet by the ProFSL staff, back when the staff was active and engaged and eager to grow the website.  This spreadsheet is wonderfully formatted with equations that make my life super easy.  I'm fluent at using the spreadsheet, but the actual programming behind it is beyond my expertise.  Adding some data about future cap would be a nice feature, but I have no idea how to do it. 

About that 5.999999m crap - some kind of spreadsheet equation anomaly.  I think Anthony and I used the same sheet.

Give it to Gypsie to figure out that guy gets wood doing things with numbers and percentages.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions
Bro-Lo El Cunado

Offline Rob

  • League Moderator
  • Legend
  • *****
  • Join Date: Oct 2010
  • Posts: 19243
  • Bonus inPoints: 3
    • :NE:
    • :BOS-NBA:
    • :BOS-NHL:
    • :NewHampshire:
    • :NER:
    • :BOS:
    • View Profile
Re: Official Q&A Thread
« Reply #322 on: March 02, 2017, 10:36:04 AM »
If someone knows what they're doing, please be my guest.  I am attaching my spreadsheet here.  Though, if you're not going to do it immediately, then just let me know when you're ready and I'll send the most up to date sheet.  I don't want someone to update this and send it to me a month from now, forcing me to update a months worth of transactions twice.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline shooter47

  • MVP
  • ****
  • Join Date: Apr 2011
  • Posts: 4936
  • Bonus inPoints: 0
    • :MIN-NFL:
    • :MIN-NBA:
    • :MIN-NHL:
    • :NorthDakotaState:
    • View Profile
Re: Official Q&A Thread
« Reply #323 on: March 02, 2017, 12:03:34 PM »
If someone knows what they're doing, please be my guest.  I am attaching my spreadsheet here.  Though, if you're not going to do it immediately, then just let me know when you're ready and I'll send the most up to date sheet.  I don't want someone to update this and send it to me a month from now, forcing me to update a months worth of transactions twice.

I added a rounding formula to the nearest tenth in Column M on the Roster Tab. That fixed the issue of the cap space showing up to so many decimal points.

I added in a projection for next years cap space that will show up just below the current information shown for 2016-2017 on the team rosters. A couple of things on this number is that I couldn't get Cash Exchanges to be included for future years. This was due to how these are entered into the spreadsheet. Also if you have a player on LTIR this year his cap hit wouldn't be included in future years since his salary for this year is set to 0.

Take a look at it Rob and let me know what you think. I can always modify it if you don't like the looks of it. We could fix it to include the future cash in the projection but that would require us to add a column to the contracts tab and you would have to put the future value of the cash exchange in that column.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline Rob

  • League Moderator
  • Legend
  • *****
  • Join Date: Oct 2010
  • Posts: 19243
  • Bonus inPoints: 3
    • :NE:
    • :BOS-NBA:
    • :BOS-NHL:
    • :NewHampshire:
    • :NER:
    • :BOS:
    • View Profile
Re: Official Q&A Thread
« Reply #324 on: March 02, 2017, 12:08:23 PM »
Wow, you really are the greatest human being.... Here's what it looks like for everyone else.

Boston Bruins :BOS-NHL:
Last Updated: 3/2/17
General Manager: Rob Bertini
ProFSL ID: Rob

Team Budget for the 2016-2017 Season
Salary: $79m
Under cap by $0.3m

Team Budget for the 2017-2018 Season
Salary: $68.4m
Under cap by $12.7m

I wouldn't mind adding a column for cash exchanges if it's not too much work.  I'm not a big fan of how I'm recording those now.  Let me know if you want to do it, and how I need to enter them going forward.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline shooter47

  • MVP
  • ****
  • Join Date: Apr 2011
  • Posts: 4936
  • Bonus inPoints: 0
    • :MIN-NFL:
    • :MIN-NBA:
    • :MIN-NHL:
    • :NorthDakotaState:
    • View Profile
Re: Official Q&A Thread
« Reply #325 on: March 02, 2017, 12:43:25 PM »
Wow, you really are the greatest human being.... Here's what it looks like for everyone else.

Boston Bruins :BOS-NHL:
Last Updated: 3/2/17
General Manager: Rob Bertini
ProFSL ID: Rob

Team Budget for the 2016-2017 Season
Salary: $79m
Under cap by $0.3m

Team Budget for the 2017-2018 Season
Salary: $68.4m
Under cap by $12.7m

I wouldn't mind adding a column for cash exchanges if it's not too much work.  I'm not a big fan of how I'm recording those now.  Let me know if you want to do it, and how I need to enter them going forward.

I added a column J to the Contracts tab. If a cash exchange is for a future year you just need to put the value of the cash exchange for the future year in that column. A pretty minor change to the spreadsheet. If you want we could probably make some more updates to the sheet in the offseason.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline Capn Cally

  • MVP
  • ****
  • Join Date: Apr 2012
  • Posts: 3391
  • Bonus inPoints: 10
    • :Blank:
    • :TOR-NBA:
    • :VAN:
    • :Blank:
    • :VAN-MLS:
    • View Profile
Re: Official Q&A Thread
« Reply #326 on: March 02, 2017, 01:16:22 PM »
Wow... You guys are so much smarter than me, haha.

I'm definitely not an office/spreadsheet guy! I dabble with Excel here and there but that's about where it ends. I still don't know formulas that well...
=SUM and then.....? I don't even know if that's right, haha
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline Rob

  • League Moderator
  • Legend
  • *****
  • Join Date: Oct 2010
  • Posts: 19243
  • Bonus inPoints: 3
    • :NE:
    • :BOS-NBA:
    • :BOS-NHL:
    • :NewHampshire:
    • :NER:
    • :BOS:
    • View Profile
Re: Official Q&A Thread
« Reply #327 on: March 02, 2017, 01:19:32 PM »
I added a column J to the Contracts tab. If a cash exchange is for a future year you just need to put the value of the cash exchange for the future year in that column. A pretty minor change to the spreadsheet. If you want we could probably make some more updates to the sheet in the offseason.

Thank you thank you thank you!

I went and updated all rosters.  So happy to get rid of that 0.99999 crap! 

And yes, other updates would be most welcome.  Let's talk in the offseason.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline Capn Cally

  • MVP
  • ****
  • Join Date: Apr 2012
  • Posts: 3391
  • Bonus inPoints: 10
    • :Blank:
    • :TOR-NBA:
    • :VAN:
    • :Blank:
    • :VAN-MLS:
    • View Profile
Re: Official Q&A Thread
« Reply #328 on: March 02, 2017, 01:23:08 PM »
Thank you thank you thank you!

I went and updated all rosters.  So happy to get rid of that 0.99999 crap! 

And yes, other updates would be most welcome.  Let's talk in the offseason.

Nice, that's awesome.

Thanks everyone!

Sometimes I'm OCD and that 5.9999999999 was reeeeally irritating me haha.
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

Offline Rob

  • League Moderator
  • Legend
  • *****
  • Join Date: Oct 2010
  • Posts: 19243
  • Bonus inPoints: 3
    • :NE:
    • :BOS-NBA:
    • :BOS-NHL:
    • :NewHampshire:
    • :NER:
    • :BOS:
    • View Profile
Re: Official Q&A Thread
« Reply #329 on: March 02, 2017, 01:25:49 PM »
Sometimes I'm OCD and that 5.9999999999 was reeeeally irritating me haha.

Same here man I've been bothered by that since day 1!

 
« Last Edit: March 02, 2017, 04:05:23 PM by snugerud »
funny
0
like
0
dislike
0
No reactions
No reactions
No reactions

 

Forum Search


Quick Profile

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

* Chat Room

Refresh History
  • Jwalkerjr88: Yea your point is just wrong is all. Theyve gotten into my pockets directly and indirectly
    Yesterday at 05:51:03 PM
  • Daddy: Oh, i was unaware. DTV must have got us all.
    Yesterday at 05:51:55 PM
  • Daddy: I know you dont endorse them. Never did. I paid for lots of crap i never used. Just for NFL Sunday Ticket.
    Yesterday at 05:52:45 PM
  • Jwalkerjr88: I dont and didnt endorse cable period. The irony is streaming is becoming cable now.
    Yesterday at 05:55:39 PM
  • Jwalkerjr88: I paid for directtv version 1-2 years when i had my apartment. Not as much as the 35+ crowd but they did
    Yesterday at 05:56:34 PM
  • Daddy: Still never watched a game on YouTube. I miss the days of CBS = AFC >> FOX/NBC = NFC >> ABC = MNF
    Yesterday at 05:56:42 PM
  • Jwalkerjr88: There was no reason to have directtv outside of sunday ticket. My apartment couldnt get it so i paid ONLY for sunday ticket
    Yesterday at 05:57:04 PM
  • Daddy: I was ok with TNF & SNF.
    Yesterday at 05:57:43 PM
  • Daddy: Its all over the place now. So ive stuck with what i know. The Ticket. I can't miss a Rams game. Not gonna do it.
    Yesterday at 05:58:45 PM
  • Jwalkerjr88: Now they stream some games only on amazon and peacock. I need a streaming lawsuit
    Yesterday at 06:01:20 PM
  • indiansnation: Dont forget disney + soon u will stream games pn their
    Yesterday at 09:43:09 PM
  • indiansnation: Disney trying yo buy nfl network and using espn as part of the trade off nfl will own a certain % of espn. First deal eas 70m for nfl network but nfl turned that down real quick
    Yesterday at 09:46:43 PM
  • indiansnation: Anyone want to talk trade nfl live,mlb live,fgm,armchair
    Yesterday at 10:00:02 PM
  • indiansnation: And any other league that im in that i didnt post yet
    Yesterday at 10:00:35 PM
  • Daddy: They keep throwing insane money at the NFL to televise games and owners share those shiny pennies just enough with the players.
    Yesterday at 10:39:25 PM
  • ldsjayhawk: I'm available.  Not sure if we match up anywhere other than NHL Live, but let me know if there's something you're interested in @Brian
    Yesterday at 10:45:39 PM
  • ldsjayhawk: The other leagues for me are FGM, MLB Live and DNHL in case any-one else is looking to do a deal
    Yesterday at 10:49:01 PM
  • Daddy: Healthy mix. Couple baseball, couple hockey, different scoring options.
    Yesterday at 11:08:15 PM
  • Daddy: You probably kick ass in all of them although NHL LIVE hasnt officially started.
    Yesterday at 11:08:42 PM
  • Daddy: I respect your gaming options
    Yesterday at 11:09:54 PM
  • Daddy: I would for sure be an FGM or Armchair owner if i were here for baseball. Powerhouse too. Why not? Great leagues with better LMs.
    Yesterday at 11:16:38 PM
  • Daddy: DNHL must be 15 years old. Gotta be doing something right. Most leagues dont make it past 5. Very few make it 10.
    Yesterday at 11:20:45 PM
  • Daddy: I think Rob been running that league longer than ive been on profsl. Legendary LM.
    Yesterday at 11:22:42 PM
  • indiansnation: Jmntl82 pm important messave about armchair
    Yesterday at 11:45:05 PM
  • jmntl82: indiansnation-replied
    Yesterday at 11:48:26 PM
  • ldsjayhawk: thanks @daddy.  I hold my own
    Today at 12:05:43 AM
  • Braves155: Will be around today for deal talks - ANY sport
    Today at 10:12:32 AM
  • Daddy: You tellem @Braves!
    Today at 11:47:14 AM
  • IndianaBuc: Braves PM
    Today at 03:04:47 PM
  • Braves155: Back
    Today at 03:10:34 PM
  • IndianaBuc: Back
    Today at 03:19:17 PM
  • Daddy: Better be glad Buc dont know hockey. He'd be IndianaPuc on yall asses.
    Today at 03:54:00 PM
  • Braves155: Speaking of NHL. Anyone up for an NHL LIVE deal?
    Today at 04:05:16 PM
  • Braves155: PM Blues
    Today at 04:07:53 PM
  • Brent: I am.  I read up on stuff today, I think I have a direction for my Predators.
    Today at 04:23:17 PM
  • Jwalkerjr88: Im here for NFL Live. I get the trade itch every day but ive been suppressing it. Waiting for someone to make me submit to the madness again
    Today at 04:48:32 PM
  • Braves155: Pm there buddy
    Today at 04:53:17 PM
  • Braves155: PM as well dbreer
    Today at 04:58:57 PM
  • dbreer23: replied Braves
    Today at 05:10:11 PM
  • BayAreaBallers: PM Braves
    Today at 05:31:50 PM
  • indiansnation: Hey guys whats up
    Today at 05:31:53 PM
  • BayAreaBallers: NHL LIVE FOLKS sharks have zadina otb any interest message me ask is prospects and picks
    Today at 05:32:27 PM
  • indiansnation: Lets talk trade
    Today at 05:32:30 PM
  • indiansnation: Indians mlb live looking to trade
    Today at 05:37:05 PM
  • indiansnation: Nfl live colts looking for starting rb
    Today at 05:37:24 PM
  • indiansnation: Braves155 pm
    Today at 05:38:39 PM
  • indiansnation: ldsjayhawks pm
    Today at 05:38:48 PM
  • Daddy: Oh Crap. Trade winds blowing like P Diddy sponsored them.
    Today at 05:45:23 PM
  • Daddy: Flyers, Rams, Blue Jays, 76ers have responded to all inquiries. Not that my inbox gets flooded with offers. My teams all stink.
    Today at 05:47:35 PM
  • Daddy: T Wolves loaded but its too early yet. Cant wait for NBA.
    Today at 05:49:02 PM