Official Q&A Thread

[Rob]

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.

[Anthony]

PS - Why in the world is the number $5.99999999m and not $6.0m flat? As far as I've been in the league, we have never had something like $2.01m or $2.59m contracts, they've all been to the nearest $0.1m.

It's something messed up with the spreadsheet formula. I had the same problem when I was using spreadsheets for my leagues.

[Capn Cally]

Something to think about for the summer/next year (or even this year if it's a simple fix):

Mostly for Rob,

Is there an easy way to show on our rosters what our next year's cap situation looks like?

I'm not sure how the spreadsheet you use is laid out, but another line under the Team Budget header that says next year's cap position would be helpful.

Example:
Team Budget for the 2016-2017 Season
Salary: $73.7m
Under cap by $5.59999999999999m
Next Year: Under cap by $X.XXXXXXXm

or:

Team Budget for the 2016-2017 Season
Salary: $73.7m
Under cap by $5.59999999999999m
Next year salary: $63.7m
Under cap by $15.599999999999m


If it is a ton of extra work, don't worry about it.

It would just be good to know where we stand for extensions and that kind of thing on quick glance.

Thanks


PS - Why in the world is the number $5.99999999m and not $6.0m flat? As far as I've been in the league, we have never had something like $2.01m or $2.59m contracts, they've all been to the nearest $0.1m.

[shooter47]

where can I find the past years draft results?

In the DNHL history folder just above this thread.

http://www.profsl.com/smf/index.php?board=1743.0

[jmtrops]

where can I find the past years draft results?

[jmtrops]

yes Rob that was my best one but I did search them all just to some self evaluation. my victor rask for a 2nd and 3rd round pix is looking real good right now

[Rob]

Jim, does this one make you feel all warm and fuzzy?  http://www.profsl.com/smf/index.php?topic=25986.0

I never thought Marchand was going to be much more than a pest who scored no more than 15-20 a year....

[Rob]

how do you search topics? I want to look at the trades I did last year.

Here's what I found:
http://www.profsl.com/smf/index.php?topic=228633.0
http://www.profsl.com/smf/index.php?topic=224906.0
http://www.profsl.com/smf/index.php?topic=224524.0

[snugerud]

how do you search topics? I want to look at the trades I did last year.

go to HOME > Search > put in your search terms and then uncheck the "check all"  and click the + sign to specify boards.  Limit it to dynasty NHL processed transactions

That should give you want you want.

[jmtrops]

how do you search topics? I want to look at the trades I did last year.