0 Members and 2 Guests are viewing this topic.
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.
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.
Wow, you really are the greatest human being.... Here's what it looks like for everyone else.Boston Bruins Last Updated: 3/2/17General Manager: Rob BertiniProFSL ID: RobTeam Budget for the 2016-2017 SeasonSalary: $79mUnder cap by $0.3mTeam Budget for the 2017-2018 SeasonSalary: $68.4mUnder cap by $12.7mI 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.
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.
Sometimes I'm OCD and that 5.9999999999 was reeeeally irritating me haha.