Hello,
I think what I need should be fairly straight forward.
I have a spreadsheet that I use to build meeting agenda's and rate the participant's perception of the success of each meeting (spreadsheet attached). Currently I'm manually typing an 'X' each time someone rates the meeting 1-10 (creating a histogram of the participant ratings).
So if 5 people rate the meeting as an 8 I will have to type 'X' 5 times. I facilitate dozens of these meetings every week so what I'd prefer is to have a button for each rating (1-10) that I simply press when the participant tells me their rating.
I faciliate groups no more with no more than 10 people (typically) so the X's would cap off at 10 for any given rating.
The attached spreadsheet already have a histogram set-up with the button's 1-10.
Any thoughts or help would be much appreciated.
Thanks!
Last edited by davesexcel; 10-25-2010 at 08:54 AM. Reason: Original-"Simple Histogram"-if so simple then why ask?
Why don't you just enter the list of your participants' names (or number the participants 1 to 10) and next to them enter the rating they tell you? Then do a countif() for each number. No need for macros and buttons. Isn't it much quicker to hit the 5 key instead of writing a macro so when a button is pressed, an X is entered into a cell that needs to be determined first, then count the number of X entries?
Seems a bit like overkill to me.
Last edited by teylyn; 10-24-2010 at 08:00 PM.
Thanks teylyn, I appreciate the comments!
What you describe is what I already do. I already have the histogram template set-up on my form and I simply put an X for each participant as they provide their scores/feedback.
However, I’m multi tasking at a flipchart, facilitating the meeting and trying to extract meaningful comments from participants not simply getting their score. I could do all of this on a flipchart too but government regulations require that I have an electronic record of the meetings so that would just mean more time out of the meeting transcribing flipcharts.
If I were only doing 1 or 2 of these per week I wouldn’t bother with the macro. But given the volume of meetings that I facilitate a savings of only 30 seconds per meeting would translate to nearly 5-hours per year.
I believe having to only click my mouse in 1-plane on the spreadsheet will easily save me 30 seconds during each meeting. I believe a potential savings of 5-10 hours per year on key strokes is well worth it to me.
I’ll keep trying to build something and additional comments are of course welcome. Having the X’s appear when I hit the button is simple. The part I’ll need to work on, that would be simple to most of you, is how to efficiently get the macro to stop when I hit 10 X’s in the respective column. I have an idea that I think will work. I'll keep this up for now and remove it when I've got something that works.
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks