I want to do a small survey to parents of a basketball league. I thought I would send it out as and email using excel. The way I formatted it was as follows:

Rate the following from needs improvement to excellent; on a scale from 1 to 4.
Please use drop down box in each category below with 1 being needs improvement and 4 being
Excellent. ( If it does not apply leave blank)
With questions lYour child's grade level?
Ease at Sign Ups
Cost
Uniforms
League age structure
Basketball Instruction
Coaches knowledge
Duration of game
Duration of practice
Playing time
Child's improvement
Schedule
Communication
Supervision
Game officials
Scorekeepers
Web-site

I have nio idea if I can consolidate the info when they email it back to me. Is there an easy way to do this?

Do you have Microsoft Access?

Yes, but I'm really not firmiliar, with it.

Well this would be best done in Access. A survey is a specific type of database. Are the questions set up in a column with the question in column A and the answers in column B?

Well this would be best done in Access. A survey is a specific type of database. Are the questions set up in a column with the question in column A and the answers in column B?

Yes, about 15 basic questions in column A and a drop down 1-4 in column B. I was checking in excel for consolidation & pivot tables. Maybe I'll pick up a Access for dummies. It looks like that is the way to go, I just didn't feel like tackling it.

Thanks Tom

I can help there. If all the work sheets are the same, this won't be too difficult. How many surveys did you send out. Is there anything in the sheet that identifies the parent the survey was sent to?

I can help there. If all the work sheets are the same, this won't be too difficult. How many surveys did you send out. Is there anything in the sheet that identifies the parent the survey was sent to?

Scott,

I haven't sent any out. I wanted to get everything in place 1st. I will attach what I have maybe this will help.

Scott,

Sorry I do have Access, but hardly use it.

Scott,

I haven't sent any out. I wanted to get everything in place 1st. I will attach what I have maybe this will help.


OK, One more question, will the survey be anonymous or will the parents identify their response.

If you can give me over the weekend I can work something up for you.

Scott,

I was thinking of putting Players Name (Optional): & Parents Name (Optional):

Wow, that would be great, thank you for your help.

Tom

You could look into online services such as SurveyMonkey: Free online survey software & questionnaire tool (http://www.surveymonkey.com/)

Scott,

I was thinking of putting Players Name (Optional): & Parents Name (Optional):

Wow, that would be great, thank you for your help.

Tom

Ok, so the surveys could be anonymous. I can deal with that.

Ok, so the surveys could be anonymous. I can deal with that.

Scott,

Just wanted to check if you had time to look at my issue with the survey? Do you think the survey mokey might be the way to go?

Scott,

Just wanted to check if you had time to look at my issue with the survey? Do you think the survey mokey might be the way to go?

I'm sorry, I got distracted. I'll do something before the end of the week.

Scott,

Just wanted to check if you had time to look at my issue with the survey? Do you think the survey mokey might be the way to go?

Yes, in terms of collecting the data, Survey Monkey is certainly a good idea. If you want to go that route, you would have to see how survey Monky provide the data to you to see where you go from there.

I have a potential alternative answer.

Attached are two files. The text.xls contains a macro that opens a new workbook and imports any *.xls file from c:\CSV as separate sheets. It also contains a template for consolidating via average the cells from other sheets if you were to copy it into the new workbook.

The trick is the average will not work unless the survey matches the template, so included is a template survey based off the file you had originally provided. The other important thing to remember is the macro only merges xls files within the c:\CSV\ directory, none others.

The steps to use these would be as following...
Distribute "Survey1.xls" and gather results.
Give each a new name (If you have a lot try something like the bulk rename utility)
Put them all in the c:\csv directory
open test.xls and run the Loop macro.
In the new workbook that appears, go to sheet 1
Copy into it the data from test.xls
Change the =Average(SheetA:SheetB!C14) to the corresponding:
Average is the function, SheetA is the Left most sheet, SheetB is the right most sheet you want included. C14 is the cell in all the selected sheets that will be averaged.

This would avoid using access and realistically probably could more easily be accomplished in Access as ScottGem has suggested. But this is how I would do it.