Rachel,
Part way into reading your request I was going to suggest a relational
database program, such as Access since Excel is seemingly overloading you
with information. Generally I'm thinking it is probably the tool for this
type of situation.
If you were just trying to analyze the results of a single survey, or even
the same survey given at different points in time, Excel would probably
handle it pretty well. But with a mix of several types of surveys (those
tabs) and a variety of each of those (for each performer) taken over a long
period of time, Access or a similar RDBMS would seem to me the way to go.
I suspect that the problem in moving your data from Excel into Access may be
that once you got it all into Excel you may not have examined it to see how
you could optimize it's organization to obtain the information you want
easily. I don't know how familiar you are with Access, but this is a typical
problem with people trying to move from Excel into Access - they still think
'2-dimensionally' rather than '3-dimensionally'; i.e. they leave their data
in the tables created by the data import rather than analyzing it to see how
it can be restructured into multiple, related tables for efficient storage
and data retrieval.
There's a pretty good discussion of the basics of RDBMS published by Oracle
he
http://searchstorage.techtarget.com/...087688,00.html
it gets a bit deep at times (well, those Oracle folks tend to go overboard at
times), but it might be something to read up on. Another good place to look
would be
http://office.microsoft.com/en-us/he...563211033.aspx which is
an article Microsoft has put up that uses data in Excel as an example of how
to move it all into Access in a 'better' way. Beth Melton has a good article
on normalization also:
http://pubs.logicalexpressions.com/P...icle.asp?ID=88 One more
good read on normalization is at
http://dev.mysql.com/tech-resources/...alization.html by
the MySQL folks - an open source RDBMS that is often used to drive dynamic
page providing websites.
While I don't adhere to strict normalization (there are always exceptions to
the rules), until you have a grasp of this basic fundamental of RDBMS
architecture, any attempt to set up a smoothly functioning database is going
to be tough going and you'll probably end up with the attitude of 'there is
so much work to be done to get anything out of it' that so many end up with.
That's mostly because they are trying to make the database look and function
like Excel. Kind of like trying to use the heel of a shoe to hammer a nail:
it can be done, but not nearly as well as with a real hammer.
With the Excel setup you have, I can imagine it's difficult or at least
tedious, to find out what performer was well accepted by both the patrons and
your staff - with Access it would be an easy task. But you have to do some
more learning in the area of creating queries and reports - luckily, Access
has some great wizards to help you do exactly that.
"Rachel" wrote:
I send out forms to gather feedback on performers/programs that my company
has to entertain patrons.
I gather feedback from both staff and patrons. Staff feedback includes how
well the performer did (were they on time? prepared? etc.) and how well they
were received by the audience (1-5 rating). Patron feedback includes how they
found out about the program, how they'd rate the program and what other types
of programs they would like to see.
I currently keep the statistics in a Microsoft Excel spreadsheet and send
out quarterly reports using the stats.
However, the spreadsheet has so much information, I feel like Excel isn't a
good choice. I have a Staff tab, Patron tab and two other tabs for general
market research. The Staff and Patron ratings though fill up so much of the
spreadsheet it's hard to use it to really gather stats aside from the
complete results (# of patrons surveyed, # of surveys sent, etc.)
Is there a good template or even better program that I can use? I tried
transferring it all to Access, but that seemed just as messy.
Thanks.