HELP - SCORE BOARD

nicolanicola · Apr 2nd, 2002, 05:55 AM

Hi can someone please help me, I'm a bit of a novice with excel and need to put a questionnaire with 12 questions into a spreadsheet.

The answers to the questions are scored (they range from 5 - very happy, to 1 very unhappy).

At the end of each sheet I need a mark out of 100 for what each person's feelings are, in order to highlight any unhappy customers.

Any help would be greatly appreciated.

Audiojoe · Apr 2nd, 2002, 06:00 AM

I know this sounds anally retentive, but 12 questions with a maximum of 5 points each, would make the maximum total 60? Do you mean that you want that split into a percentage, so that each customer has a % of how happy they are?

RoyinUK2000 · Apr 2nd, 2002, 06:48 AM

Come on Joe, don't be so cruel to the lady, they can't always see things as clearly as the male population.

But hey yes it was a bit anally retentive.

Roy

Audiojoe · Apr 2nd, 2002, 07:08 AM

I didn't mean to be cruel, I just needed some clarification. I'm sorry if it came across that way Nicola, unfortunately you couldn't see my face when I was typing it. I was smiling and petting a dog, and kissing a baby's forehead, and speaking in a very agreeable voice. if any of you had been here, you probably would have fallen in love with me, I was being that charming.

But anyway, all I needed to know was if you needed the answer expressed as a percentage? It's just that 12 questions with a maximum of five points each comes to 60, so I didn't quite understand what that 'out of 100' bit meant.

You should have seen me then, while I typed that bit I was feeding an orphan

nicolanicola · Apr 2nd, 2002, 07:33 AM

yes I did mean as a percentage - sorry for being so utterly stupid!!! (does this mean you may be abl;e to help?)
Hope you are enjoying the orphan!
x

Audiojoe · Apr 2nd, 2002, 07:39 AM

All righty, that's no problem then. If you want, you can Private Message me your email address or I'll send you mine and you can either send me an example of what your questionnaire looks like, and I'll do it for you and send it back with an explanation,OR I can send you a mock one but it wont look anything like what you're working on

Up to you. I'll send you my email address through Private Message and we can go from there.

Ramone the orphan says hello by the way. Ow! He bit me! Still, that's what you get from being brought up by a wolf I guess

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 05:55 AM	#1
nicolanicola New Member Join Date: Apr 2002 Location: Aylesbury, UK Posts: 2	Hi can someone please help me, I'm a bit of a novice with excel and need to put a questionnaire with 12 questions into a spreadsheet. The answers to the questions are scored (they range from 5 - very happy, to 1 very unhappy). At the end of each sheet I need a mark out of 100 for what each person's feelings are, in order to highlight any unhappy customers. Any help would be greatly appreciated.

Apr 2nd, 2002, 06:00 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	I know this sounds anally retentive, but 12 questions with a maximum of 5 points each, would make the maximum total 60? Do you mean that you want that split into a percentage, so that each customer has a % of how happy they are?

Apr 2nd, 2002, 06:48 AM	#3
RoyinUK2000 Board Regular Join Date: Mar 2002 Posts: 79	Come on Joe, don't be so cruel to the lady, they can't always see things as clearly as the male population. But hey yes it was a bit anally retentive. Roy

Apr 2nd, 2002, 07:08 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	I didn't mean to be cruel, I just needed some clarification. I'm sorry if it came across that way Nicola, unfortunately you couldn't see my face when I was typing it. I was smiling and petting a dog, and kissing a baby's forehead, and speaking in a very agreeable voice. if any of you had been here, you probably would have fallen in love with me, I was being that charming. But anyway, all I needed to know was if you needed the answer expressed as a percentage? It's just that 12 questions with a maximum of five points each comes to 60, so I didn't quite understand what that 'out of 100' bit meant. You should have seen me then, while I typed that bit I was feeding an orphan

Apr 2nd, 2002, 07:33 AM	#5
nicolanicola New Member Join Date: Apr 2002 Location: Aylesbury, UK Posts: 2	yes I did mean as a percentage - sorry for being so utterly stupid!!! (does this mean you may be abl;e to help?) Hope you are enjoying the orphan! x

Apr 2nd, 2002, 07:39 AM	#6
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	All righty, that's no problem then. If you want, you can Private Message me your email address or I'll send you mine and you can either send me an example of what your questionnaire looks like, and I'll do it for you and send it back with an explanation,OR I can send you a mock one but it wont look anything like what you're working on Up to you. I'll send you my email address through Private Message and we can go from there. Ramone the orphan says hello by the way. Ow! He bit me! Still, that's what you get from being brought up by a wolf I guess