Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word Tables

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-21-2016, 08:51 PM
allikat305 allikat305 is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Nov 2016
Posts: 3
allikat305 is on a distinguished road
Cool Content control checkbox calculations

I have been searching all day to get some guidance on how to calculate average ratings on a performance evaluation form. This thread:


http://www.msofficeforums.com/word-t...g-results.html
is the closest post that I have found that talks about what I need. Your help would be so greatly appreciated. My question is pretty much the same as in the linked thread.

Each box in each section represents a score 1 -5 (1 being worst, 5 being best)
I would like to take the value for the checked box in each element and add them together then divide them by the number of factors to come up with an average score to be displayed at the bottom of each factor with a grand total at the bottom.

the first factor has 5 elements which score needs to averaged on its own and than added to the remaining factors. I hope that makes sense :-)

I would also like to prevent the user from checking more than one box per section?

I have never done this before so detailed instructions would be great if possible, please. I do not know how to work with Macros or how to write code so I am hoping this will be fairly easy :-)

Any help would be greatly appreciated :-)
Attached Files
File Type: docx Annual Performance Evaluation2016[264].docx (58.7 KB, 6 views)
Reply With Quote
  #2  
Old 11-22-2016, 02:38 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,666
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi allikat,

You refer to scores for each 'factor', but some of them (e.g. Communication, Decision-Making/Judgment, Appearance & Grooming) don't have anywhere for the score to be output. Please clarify.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 11-22-2016, 04:22 PM
allikat305 allikat305 is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Nov 2016
Posts: 3
allikat305 is on a distinguished road
Default

Hi - thank you so much for your help

There are 8 performance factors in total. Professionalism is the only performance factor that has 5 elements. We would like the form to calculate an average score based on the five elements and give an rating just for Professionalism.

Communication
Decision-Making/Judgment
Appearance and Grooming
Attendance
Dependability

Then take the score for Professionalism and as managers rate each performance factor, the form will give an average based on the ratings selected at the bottom of each factor and then give a grand total for all 8 factors at the bottom of the form.

Professionalism
Attention to Detail
Attitude
Ownership
Responsiveness
Teamwork & Cooperation
Ethics
Basic Job Knowledge

I hope that makes sense - please let me know if you have any more questions.

Thank you!
Reply With Quote
  #4  
Old 11-22-2016, 06:34 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,666
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

It's not the number of elements I'm concerned about, but with where the output for each factor is to go. The factors I mentioned don't have an output row in their tables.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 11-22-2016, 08:06 PM
allikat305 allikat305 is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Nov 2016
Posts: 3
allikat305 is on a distinguished road
Default

Oops! see attached

Thanks!
Alli
Attached Files
File Type: docx Annual Performance Evaluation2016[264].docx (58.7 KB, 7 views)
Reply With Quote
  #6  
Old 11-22-2016, 11:20 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,666
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Try the attached. If you save it as a macro-enabled template, any new document you create from it will have access to the code without having to be saved in the docm format - provided the template remains accessible to the document.
Attached Files
File Type: docm Annual Performance Evaluation.docm (80.4 KB, 22 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show Userform when Content Control CheckBox ticked derajlance Word VBA 1 05-13-2016 01:55 PM
Clicking the selected Content Control checkbox returns wrong control in vba event DougsGraphics Word VBA 2 06-24-2015 07:31 AM
Replace checkbox symbol with check box content control canadansk Word VBA 5 04-01-2015 08:21 AM
Deleting a table from a content control -- preserving the content control BrainSlugs83 Word Tables 8 11-14-2013 03:06 AM
Excel ->VB code for Checkbox (control toolbox) kirkstyle Excel 0 08-16-2006 04:17 PM


All times are GMT -7. The time now is 08:03 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft