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.
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
** 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.