I was building a list the other day, and found out (the hard way) that I had made some mistakes.
I didn't fill out all of the formulas in the Mech B and Mech C columns, and I had incorrectly calculate the C3 bonus. I was adding the 5% into each Mech that was using the C3, plus that 5% into the roster total on top of the Mechs. Thus, in the battle I fought, I inadvertently spotted my opponent about 400 points. I got it all straightened out, and everything should be working correctly now. I also made it a Macro-enabled spreadsheet. If you hit "Ctrl+q" it will remove all pilots and the "Y/N" for C3 in all three Mech columns. DO NOT do this manually, as you might accidentally delete a crucial formula in the BV column. Here is the file:
Battletech Mech Alpha Roster v2.1
Have Fun with it!
[8/21/15 UPDATE:] With my upgrade in blog software to Joomla, I also decided to upgrade this spreadsheet as well. See this page for more information.