Automating Different Survey Results

[Sara_Chase]

Does anyone have any idea on how to facilitate the preparation of surve
results?

Our survey results are downloaded from our survey online facility (som
facility when it can't even produce the report :sigh. These survey
are about the services of the different support groups of our company
So each survey has its own set of questions. The backend process o
translating these results is quite tedious and I've been thinking o
how to automate it ... I know that there is a better way. I am usin
Excel but only the standard features such as countif, sumproduct
pivot, charts. But still it consumes a lot of time just preparing on
report.

Any ideas? :confused

 

[Ryan.Chowdhury]

Sara, my recommendation would be to set up a template page with
established column headers, below which you could dump the raw data
from the survey. Then use Excels, Insert > Name > Create menu item to
name each column all at once. Finally, create formulas and analyses
based on the named ranges in other worksheets. All your tables and
charts should automatically update. The key here is that the analysis
doesn't change from survey to survey.

I'm not sure what to tell you if that's not the case. You could, I
suppose, create some VBA that leverages the named ranges and drown down
boxes that would select "operations" like average, median, high, low,
frequency tables, etc. and then have the code generate tables and
graphs, but that seems like overkill.

ryan

 

[Sara_Chase]

Hi, Ryan.

That's exactly what I did with our current survey results. However, it
still seems to be too much ... well, anyway probably just this survey
period. I will see if it's going to save us time on our next survey
period since all the templates for the 6 departments are all set-up.

Thanks.