Dynasty NHL

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



::
::

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

0 Members and 6 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
  • Daddy: @jwalkerjr88 aint never done more but use my account. Im paying for 32 teams and only watching the Rams.
    Yesterday at 05:20:53 PM
  • Daddy: I want my money back. I just looked it up. I want 31/32 refund. Well my Dad & Son benefited so 29/32 refund.
    Yesterday at 05:21:56 PM
  • indiansnation: How much it cost?
    Yesterday at 05:22:50 PM
  • Daddy: A lot. I think about $300 per season.
    Yesterday at 05:24:18 PM
  • Daddy: Added to the cable bill of like $200. That nobody ever used.
    Yesterday at 05:25:01 PM
  • Daddy: So i had DirecTV for 12 months to use Sunday ticket for 3 months and paid like 3 installments of roughly $100 added to my $200m bill.
    Yesterday at 05:26:18 PM
  • Daddy: For that i got two TVs that could watch any game any time any where. Problem is they getting played at the same times. You cant watch every game. Why you charging me for every game?
    Yesterday at 05:27:40 PM
  • Daddy: If thats the case i should have access to 32 different monitors. Right?
    Yesterday at 05:30:19 PM
  • Daddy: Or maybe 16. I would take 16. But two. Give me my bread back Mafia!
    Yesterday at 05:31:38 PM
  • Daddy: Making me watch  Bo Nix + Zach Wilson + Jared Stidham = you should be paying me
    Yesterday at 05:33:56 PM
  • Daddy: Me and coach Payton [link]
    Yesterday at 05:34:53 PM
  • Jwalkerjr88: Thats cap by the way. I pay for my own way to watch my team
    Yesterday at 05:41:55 PM
  • Jwalkerjr88: I dont have your account or login
    Yesterday at 05:42:07 PM
  • Jwalkerjr88: I used yours for 1-2 seasons.
    Yesterday at 05:43:32 PM
  • Jwalkerjr88: I used my mothers for a decade before that
    Yesterday at 05:43:46 PM
  • Jwalkerjr88: But ive used my way for the past few years. Ill be paying attention like i said
    Yesterday at 05:44:27 PM
  • Daddy: She deserves a refund too
    Yesterday at 05:46:27 PM
  • Daddy: The point was DirecTV never got in your pockets and it was a rip-off but they had a monopoly on the product. Im not loving all the streaming games but DTV will be paying $$$.
    Yesterday at 05:48:22 PM
  • Jwalkerjr88: The new iteration with Youtube TV isnt the greatest either but an improvement on Directtv version
    Yesterday at 05:48:37 PM
  • Daddy: And your grandfather used it every year besides those two :rofl:
    Yesterday at 05:49:26 PM
  • Daddy: I kept DirecTV and always willing to share. But thats my point.
    Yesterday at 05:49:47 PM
  • Daddy: If i had 3 monitors rather than two or four rather than two, either me or moms save money. Lots of it.
    Yesterday at 05:50:26 PM
  • 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