Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Bartlesville, Oklahoma
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Averaging checkbox values (2000)

    How may I go about having Word average evaluation scores that are selected with check boxes?

    I am trying to improve an employee evaluation document to where it will calculate the employee's score based upon which check boxes are checked. For each area of evaluation there are five scoring selections, 1 thru 5. The score for any particular area of evaluation is determined by which check box the evaluator checks. At the end of the evaluation the evaluator has to manually average the scores to come up with the employee's evaluation score. What I want to do is have Word calculate the average based on whatever scoring check boxes are used by the evaluator.

    How do I have Word determine which scores are selected (check box checked), average the scores for the evaluator, and place the final score in a field for the evaluation score? I'm thinking this is going to involve IF statements and possibly a macro, both being subjects in which I am not very adept. If this process is possible (and I believe it is, I just do not have the expertise to do it w/o some help from WOPR), what would the average function do if any of the scoring fields were not used? Let's say some evaluation areas were not applicable to a certain employee? Would the average just be of the fields used? That is to say, would the averaging divisor be the total number of evaluation fields or just the number of fields having a value greater than zero? Is there a way to make sure that users check only one box?

    Also, I've attached a copy of a blank evaluation form for your information. This is not the finished product because I intend to combine it with a supplemental evaluation form that is also used in the process. I've attached the one form just for brevity and to save space.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Averaging checkbox values (2000)

    In my humble opinion, Word is not the best application for this. Excel or Access are much more suitable for performing calculations, and there is dedicated survey software with features for designing forms, collecting data and tallying the results.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Bartlesville, Oklahoma
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Averaging checkbox values (2000)

    Hans,

    Thanks for replying.

    Yes, I figured Excel would be a better app. However, since the form is already made in Word I was trying to make due with what I have. If I do not come up with a Word solution MAYBE I'll make the document into an Excel worksheet. This is something I'm doing on my own, mainly for personal training and experience.

    Thanks again,

    -Steve-

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Averaging checkbox values (2000)

    <P ID="edit" class=small>(Edited by jscher2000 on 29-Jun-05 09:57. )</P>Perhaps you need to write a macro that pops your survey data into one or more Access tables. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Actually, if it's a one-time project, popping the values into an Excel workbook probably makes more sense.

    Added: I didn't read your first post carefully enough and assumed you had already collected the data. Why do you want the evaluator to worry about the average? Will then then go back and adjust individual categories to get the average they want? If that is not envisioned or desirable, I suggest you do all the averaging after-the-fact. Alternatively, if field math doesn't solve it, you could hijack the File>Save command with a FileSave procedure to update the averages. People can be trained to save, usually. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Bartlesville, Oklahoma
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Averaging checkbox values (2000)

    I'm beginning to see that this may be more involved than I had anticipated. I may just try to put it all in Excel someday. I'll have to mull it over for a while to ascertain if I even want to do it and, if so, if it is something that will not take a degree from MIT to accomplish.

    Thanks for taking the time to respond.

    -Steve-

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Bartlesville, Oklahoma
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Averaging checkbox values (2000)

    Response to "Added"

    The reason I want to average the scores is because the average score is the ratee's eval score. I do want the averaging to take place when all the grades/scores have been entered. If the person scoring the ratee's eval goes back to adjust the score to fit their needs or desires I have no way of regulating or controlling that. They are doing a dis-service to their employee and employer, not to mention falling victim to their own indecision. I'm with the City police, not the ethics police, so I can only hope that any users of my document would conduct themselves accordingly.

    Thanks again for your suggestions. Perhaps I'll run into you again in the Excel forum IF I decide to try that avenue.

    -Steve-

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •