At work, our negiotations for a pay increase have gone pear shaped. So the Company has proposed that it will implement a pay scale based on performance criteria. Now I can live with this, in fact i except the challange of reaching the top performance level.

My question therefore is this:

Given that there is approximately 30 criteria over several different areas, should I design a multi tabbed form in which each individual is evaluated, and this form then records to a flat file or is there a more effecient method of recording and reviewing the data on each employee?

I'm not looking for any specific code right now, but would appreciate any ideas that I could follow up as a project. Oh BTW.. I want to do this in Excel only, if you don't mind.

Ted