After fiddling more and more with the Battletech Roster Builder spreadsheet, I up and redid whole sections. You can now independently select gunnery and piloting skills. It will "lock out" (not display any base BV of a unit if the BV is greater than the balance remaining . Things like that. Feel free to go here and download it so you can play with it to your hearts content!