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.

[snugerud]

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.

[Rob]

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.

[shooter47]

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.

[Rob]

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.

[shooter47]

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.

[Capn Cally]

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

[Rob]

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.

[Capn Cally]

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.

[Rob]

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!