View Single Post
 
Old 07-19-2011, 03:08 PM
Jennifer_Falcon Jennifer_Falcon is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2011
Posts: 4
Jennifer_Falcon is on a distinguished road
Default Perform Calculations using List boxes

Good Day,

I am new to programming / designing forms in Microsoft Word. I am using Word 2003.

I have been asked to make a template for our change management system.

What I would like to do is this:

Column 1 --> Question to ask User
Column 2 --> Choice of Answers for User

Column 1 Column 2
Is the implementation date within the change window? List Box with options: Yes, No
How many services are affected by this change? List box with options: 1 to 3, 4 to 6, 7 to 9
How technically complex is the change? List box with options: Extremely, Very, Minimal, Low


I want to be able to calculate the risk of this change. The risk is determined by the weight of each answer in the list box.

So, if you chose these options:

Column 1 Column 2
Is the implementation date within the change window? Yes (worth 5 points)
How many services are affected by this change? 1 to 3 (worth 8 points)
How technically complex is the change? Extremely (worth 10 points)

The risk would be 23 ( 5 + 8 + 10)

I would then like the Risk amount to be displayed in a field. If the user changes their answers, the total should should update.

Is this something that is easy to do in Word?

Thanks,

Jennifer
Reply With Quote