Spreadsheet Updates

[Guardians GM (Matt)]

After realizing that my spreadsheet was created wrong and was double counting my releases and minor league system against me I went in and fixed some other rosters for 2013 only, so you will need to update future rosters to only have your total salary commitments run to row 42 in the spreadsheet formula. This is a huge problem and cost me $8 million that I could have used in free agency.

Teams affected in 2013:
Indians
Orioles
Cubs
White Sox (17million in savings)
Reds
Tigers
Dodgers
Yankees
Athletics
Phillies (12.5 million in savings)
Padres
Mariners
Giants
Cardinals
Rays (7 mil in savings, had different error double counting releases)
Blue Jays

[Pirates GM (Hollar)]

Indians, your spreadsheet is now set up wrong and is not counting your releases against your cap. You should have $4.25M less in cap room than you have listed.

[Pirates GM (Hollar)]

Also the White Sox now, from the one other one I audited. I think all you did is remove the released players from the cap hit, which is wrong.

[Pirates GM (Hollar)]

To be more specific, cells 2:42 are for your roster, and are summed in cell 71. Cells 43:52 are for your minor league roster, cannot be used for players making over $1M, and are not summed anywhere. They do not count against your cap. Cells 54:68 are for your released players, and are summed in cell 72. Your cap is listed in cell 70, and your available cap space in cell 73. For this to be calculated correctly, you need to subtract both cell 71 (Active roster contracts) AND cell 72 (Released player salary obligations) from cell 70 (With a basic formula of D70-D71-D72).

You have not created cap space. You have created an incorrect roster. If you find problems with the spreadsheet, please either post them on the board or PM an admin about them so that they can be looked at before changing the spreadsheet. This results in less backtracking if a mistake is made.

I don't mean for that to be a tongue-lashing or anything (PROTIP: Tongue-lashings: Not as sexy as they sound). Just wanted to explain it better.

Edit: As far as I can tell, what you did is modify the formula for cell 73 to simply be D70-D71. If I'm missing something, please let me know.

[Guardians GM (Matt)]

It was counting my minor league system, I have figured out the modification, why are all the rosters calculated differently? The ones I have altered are now set up like WAS so that their minor leagues don't count against their cap (it was still a 4 million difference for my team)

[Deleted]

All players min salary is 500k so of that was the case it's 5 mil for some

[Nationals GM (Preston - Old)]

Mar 25, 2013 7:00:47 GMT -8 Guardians GM (Matt) said:

It was counting my minor league system, I have figured out the modification, why are all the rosters calculated differently? The ones I have altered are now set up like WAS so that their minor leagues don't count against their cap (it was still a 4 million difference for my team)

I copied my spreadsheet for all of the other teams. It must have been an issue converting from Excel.

[Pirates GM (Hollar)]

Indians, your team is currently at your salary cap. Are you saying you were $4M over the cap before today?

[Guardians GM (Matt)]

Yeah, took on a ton of free agents including 2.25 million of Grokys Hernandez

[Rangers GM (Victor)]

This is why a LO member needs to be in charge of the spreadsheet. Too many cooks in the kitchen is bad. One or two people need to be in charge of spreadsheet, or we will continue to have issues with people being over the salary cap. We already had one team over $20M the cap at one point and NO ONE noticed. Just saying.

[Deleted]

I agree with Vic. The A's mentioned he thought it was wrong and dumb that someone modify the spreadsheet, but what is really dumb is that he even had the ability to modify it.

There are teams that are/were over the cap for that exact reason, shoot when I took over than Yanks they were 16M+ over the cap.

Pretty much in agreeing with Vic that only one or two LO members should have admin access to the spreadsheets.

[Reds GM (Pat H.)]

The original intention of the spreadsheets was to make it easier for each manager to track his current and future salaries, while at the same time give the LO a place to track salaries at the same time.

Everyone has access to be able to make changes to their own rosters as each transaction takes place. For only one or two people to do all of this work is unrealistic. The LO has a finite amount of manpower to run the day to day operations and to be able to enforce all of the rules. The spreadsheet was a welcome addition in as far as being able to help police salaries and spread the work involved to every team manager instead of just a few. No one is making cash hand over fist in this league, so it was hoped that most managers would try to follow the rules. The spreadsheet is there for you to be able to police yourselves.

The league is not that old and we are still making small adjustments to rules and learning how to enforce all of them. I will be working on a way to track each and every players' salaries individually and when that salary was last audited.

Having said that, the LO is aware of some teams being over the cap. It has been an on going problem that we will soon try to take care of. Eventually, every team roster will be audited.

If you see any problems please bring them to the LO first.

Everyone please follow the rules and be patient.

[Deleted]

I accidentally modified Pat's post initially. He post is unedited. My apologies. I'll be more careful in the future.

[Deleted]

Mar 26, 2013 8:47:38 GMT -8 @joshualarimer said:

I agree with Vic. The A's mentioned he thought it was wrong and dumb that someone modify the spreadsheet, but what is really dumb is that he even had the ability to modify it.

There are teams that are/were over the cap for that exact reason, shoot when I took over than Yanks they were 16M+ over the cap.

Pretty much in agreeing with Vic that only one or two LO members should have admin access to the spreadsheets.

I agree, Josh, and have approached the LO about creating a spreadsheet.

Respectfully, I disagree that it's too much work for the LO to maintain a spreadsheet. It's a massive task to build the sheet initially but once it's done, it's not terribly difficult to maintain. If the LO doesn't see that as a useful allocation of resources, fair enough, but I'm in 4 leagues like this and this is the only one without an official LO spreadsheet. It's certainly possible.

[Former Angels GM (Mike C.)]

it would actually make complete sense for nobody to go to a spreadsheet site and nobody messing with it except maybe 2 people tops.... take it over now, call it a rough draft, audit it all during the season, then next off season, make adjustments as they come up. Would never have to worry about fixing short term owners mistakes or adjustments, ever.

[Pirates GM (Hollar)]

PB has given me the approval to do some work on the spreadsheet, so I'm going to be modifying team pages in an attempt to have a standard formatting for every team, and to make some corrections (For example, unlisted salaries for MiLB players). If you have any questions, post them or PM me.