EXCEL - Recording survey details in excel - Easiest way

[reecec]

Hi,

I have got the job of creating a spreadsheet to record about 1,600 survey results. I am trying to think of the easiest way to record them. The survey has open and closed questions. So i was thinking if its possible to create a macro that would add one to the total each time it is clicked like a tally but have no clue for the open questions.

 

Any help appreciated

Thanks

[srochford]

I think I'd use Access rather than Excel (actually, I'd rather use a web based form and SQL server. It's a bit harder to set up but it's much easier to have multiple people entering data - you can even collect directly rather than doing paper forms and rekeying)

 

You don't need to worry about adding up the totals as you go - even if you use Excel you just have a set of COUNT or COUNTIF statements (eg if Q1 can have answers 1,2 or 3 then somehwhere you'd have a COUNTIF for each of the possible values and it will just increment each time you enter 1,2 or 3)

 

Access needs a little bit more work - you probably want to make a form to collect the data - but you've got much better reporting facilities. I assume what you're doing is asking questions like "what do you think of the canteen?" and you'll get back free-text answers. There's very little you can do with these apart from list responses (and this is where you really need to get your survey design right - if you have too many questions like this you get nothing out of the survey because it's just too much effort to correlate all the responses)

[reecec]

I think I'd use Access rather than Excel (actually, I'd rather use a web based form and SQL server. It's a bit harder to set up but it's much easier to have multiple people entering data - you can even collect directly rather than doing paper forms and rekeying)

 

You don't need to worry about adding up the totals as you go - even if you use Excel you just have a set of COUNT or COUNTIF statements (eg if Q1 can have answers 1,2 or 3 then somehwhere you'd have a COUNTIF for each of the possible values and it will just increment each time you enter 1,2 or 3)

 

Access needs a little bit more work - you probably want to make a form to collect the data - but you've got much better reporting facilities. I assume what you're doing is asking questions like "what do you think of the canteen?" and you'll get back free-text answers. There's very little you can do with these apart from list responses (and this is where you really need to get your survey design right - if you have too many questions like this you get nothing out of the survey because it's just too much effort to correlate all the responses)

 

Thanks! That is how I would have done it but the data has been collected manually on paper. So all the data has got to be entered into it. And I think I might give access a go.

 

Thanks Again