Sounds like a fun one to set up, ECS. The approach I'd probably take is twofold.
First, I'd set up the XP/Calculated Bonus column pair we already talked about. I'd make each entry in that Bonus column calculate itself based on columns to the right that define values, with each column being one of those Traits you mentioned.
So, basically, you'd have:
XP | Bonus | Fast Learner | Slow Learner | Natural Aptitude | ...
The Bonus column would simply sum up all the columns to its right, and you could use the VLOOKUP function as discussed to get the appropriate bonus.
Now, the second half of this would be that each of the cells in the extra columns is +x, 0, or -x depending on whether or not that Trait was selected. This can be done with a simple IF() call, and (for example) a quick MATCH() to see if that Trait is listed for the character (using the column header so you don't have to hand-code any constants into the formula directly), and you can set the formula up once and simply expand it to the others cells. Saves on typing. Or you can have it test a cell somewhere else and treat that as a switch to turn that Trait on or off. I'd prefer the 'look for the trait in a list' option myself, but that's because I tend to keep character sheets in electronic format anyway.
--sofaspud
--"Listening to your kid is the audio equivalent of a Salvador Dali painting, Spud." --OpMegs
First, I'd set up the XP/Calculated Bonus column pair we already talked about. I'd make each entry in that Bonus column calculate itself based on columns to the right that define values, with each column being one of those Traits you mentioned.
So, basically, you'd have:
XP | Bonus | Fast Learner | Slow Learner | Natural Aptitude | ...
The Bonus column would simply sum up all the columns to its right, and you could use the VLOOKUP function as discussed to get the appropriate bonus.
Now, the second half of this would be that each of the cells in the extra columns is +x, 0, or -x depending on whether or not that Trait was selected. This can be done with a simple IF() call, and (for example) a quick MATCH() to see if that Trait is listed for the character (using the column header so you don't have to hand-code any constants into the formula directly), and you can set the formula up once and simply expand it to the others cells. Saves on typing. Or you can have it test a cell somewhere else and treat that as a switch to turn that Trait on or off. I'd prefer the 'look for the trait in a list' option myself, but that's because I tend to keep character sheets in electronic format anyway.
--sofaspud
--"Listening to your kid is the audio equivalent of a Salvador Dali painting, Spud." --OpMegs