The Straight Dope

Go Back   Straight Dope Message Board > Main > In My Humble Opinion (IMHO)

Thread Tools Display Modes
Old 08-01-2003, 03:00 PM
Janx Janx is offline
Join Date: Jan 2001
How to tabulate customer survey results using MS Excel?

We are doing an ongoing patient satisfaction survey where I work.
Each patient is asked to fill out a form with 15 quick questions regarding how their visit went. I would like to do this in excel because everything is in portuguese and I cant seem to find any off the shelf software that will allow me to configure our survey.

The question is simple: How do you make a simple data entry form in excel.
When the clerk types the number 1 into box a, box b, c, etc then hits enter,
All those numbers are passed to another spreadsheet where they are added to the existing totals, (if you follow me). I know I should be thinking Access for this but I havenít messed with it for some time and I think it may be a bit more complex then we need. Also I donít want to learn Access all over again, if I can help it.

Any thoughts or ideas would be greatly appreciated.
Reply With Quote
Old 08-01-2003, 07:47 PM
Bill H. Bill H. is offline
Join Date: Jun 2000
Check out Forms (under the Data menu). Also, if you move this to GQ, you'll get a lot more answers
Reply With Quote
Old 08-01-2003, 08:57 PM
Siege Siege is offline
Join Date: Dec 2000
Actually, unless you enjoy writing Visual Basic for Application code, this would be easier in Access because Access is built to do just this little or no programming. I might be able to rough out a spreadsheet (in English, I'm afraid) and e-mail it to you, if you're interested. Actually, the idea of doing that sounds kind of like fun, but then again, I'm the kind of deviant who does enjoy writing VBA code. What I'd do is set the form up so that when it's submitted, 1 is added to the total number of responses for each question clicked.

Here's how it might look:
Responses     A     B     C     D
Q1            0     0     0     0
Q2            0     0     0     0
Q3            0     0     0     0
Q4            0     0     0     0

Hope this helps,
Reply With Quote
Old 08-04-2003, 07:29 AM
Janx Janx is offline
Join Date: Jan 2001
Siege wrote:

I might be able to rough out a spreadsheet (in English, I'm afraid) and e-mail it to you, if you're interested.
Siege That would be super cool, I could change the language later. My e-mail is listed in my profile. Just let me know (either in this forum, or by E-mail) what you need to know about the questionnaire, If you would like I could scan it and send it off to you so you can get an idea of how many fields would be needed for each question.

P.S. I didnít post this to GQ because I know there will be more then one correct answer.

Thanks again!
You mess with me, you mess with the whole trailer park!
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

All times are GMT -5. The time now is 09:18 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.

Send questions for Cecil Adams to:

Send comments about this website to:

Terms of Use / Privacy Policy

Advertise on the Straight Dope!
(Your direct line to thousands of the smartest, hippest people on the planet, plus a few total dipsticks.)

Publishers - interested in subscribing to the Straight Dope?
Write to:

Copyright © 2017 Sun-Times Media, LLC.