another excel question

dori2o

Hi,

I want to make an electronic version of the McGill pain questionairre.



So first of all I want drop down boxes for the description words, is this possible?

Second, these words have a value to them in order to get the final score. If I use a drop down can I assign a value to the selected answer and if so get this totalled along with the other values?

If this is possible can anyone suggest relevent formulae?

Am i on a hiding to nothing and should I make it simpler by showing all the words and tick boxes (if possible) and using IF statements to provide a value for each ticked box?

Would it be easier to do this via database rather than spreadsheets?

Thanks

Idiophreak

Have a read of this:
http://stackoverflow.com/questions/8295816/how-to-create-an-excel-dropdown-list-that-displays-text-with-a-numeric-hidden-va

Should get you most of the way there.

Tigsteroonie

There I am working out how to do it in Excel (setting up data tables, validation, then vlookup) ... and you find a link to a page that explains it all so simply

WhiteChristmas

That is a very good link.

Tigster - remember that the McGill questionnaire is still under copyright and you'll need permission to use it like this for anything other than personal use.

dori2o

WhiteChristmas wrote: »

That is a very good link.

Tigster - remember that the McGill questionnaire is still under copyright and you'll need permission to use it like this for anything other than personal use.

Don't worry, it is only for private use.

Currently I complete a form every couple of weeks to keep a record of pain throughout the year alongside a diary (This changes to once a week for a month or so when I change meds). This means my Diary has lots of additional pages stapled in and it's a bit of a mess.

I want to change everything to a digital record of my pain so that I have easy access to it whenever it is needed.