Our human resource department is designing a word document for reviews. They want it to work like this:
Code:
Section 1                               weight         value        score
Employee is worthwhile...                  10%             5             .5
Employee does blah blah...                 20%             4             .8
...
Total                                     100%                          3.2
where the weight is a percentage entered in by the reviewer, the value is a value between 1 and 5, and the line score is the percentage times the value...

There are 6 sections; each section the weight must equal 100%.

THey gave me the word document they started with, and they have text boxes for the weight, value and score.

Can anyone offer up some tips / pointers on the best way to implement this? Should I redesign it to use embedded Excel functionality, or can it all be done with word and VBA?

THis would be in Office XP.

Thanks
Steve