I’ve created a video describing how to make this in Excel and you can get it HERE.
Also, I’ve created a template that you can download and use HERE.
Finally, HERE is the YouTube video instructions.
As many of you know, I’m a huge proponent of the communication style of Why, then How, then What. Because of this, I’ve come across a lot of opinionated information – asking people why they may want or do something, how they do it, and then what it is they actually do.
Not long ago I sent a survey out to my co-workers asking them why we do a few things as an organization to start a mission statement for the group I was tasked with forming. This brought back a bunch of results with no, absolutely none, data to work with. For a couple years now, as well, I’ve been collecting surveys from our training clients (with a few questions to be hand-written) to see how we might better serve them and improve in our quality. It’s great having that information, but can we really interpret these opinions into actionable paths for improvement? Maybe. If there are a few.
So, I started researching and finally built a tool (in Excel) to turn opinions into measurable results; in more technical terms – qualitative results into quantifiable data.
This is a valuable tool for anyone that wants to rightly know what clients, employees, friends, groups, or even one’s self, are thinking, want, need….
Simply, send out a survey:
- In a class
- On Facebook
- As an email
- Using MailChimp
- A pros and cons list
- Whatever
Use the results with this method, and you’ll have the DATA you want to make the decisions you see best.
This tool was built in Excel, however, the concept can be used in any logic program I believe.
Below I describe the process:
- Get your survey responses
- Enter them into a data bank (some electronic tool or list that can sort and assign)
- Create overarching categories that describe all the variables in the responses
- ex.
- ex.
- Assign the categories a code
- Go through all of the responses and assign them a category code
- Sum the results of each category
I’ve created a video describing how to make this in Excel and you can get it HERE.
Also, I’ve created a template that you can download and use HERE.
Hopefully, this brings some enrichment to your life. I know it is to me. If you have any feedback, comments, questions, etc I’d be really happy to hear from you.
Thanks for reading,
Jase
Wonderful blog! Do you have any helpful hints for aspiring writers? I’m planning to start my own site soon but I’m a little lost on everything. Would you advise starting with a free platform like WordPress or go for a paid option? There are so many choices out there that I’m totally confused .. Any suggestions? Thank you!
Magnificent beat ! I wish to apprentice whilst you amend your site, how can i subscribe for a blog site? The account aided me a applicable deal. I were tiny bit familiar of this your broadcast provided shiny transparent concept
Hi, i think that i saw you visited my website so i came to ?return the favor?.I am trying to find things to improve my website!I suppose its ok to use some of your ideas!!
Appreciate the recommendation. Will try it out.
Every weekend i used to visit this website, as i want enjoyment, since this this web site conations really pleasant funny data too.
If you are going for most excellent contents like I do, only pay a visit this web site everyday because it gives quality contents, thanks
Hey There. I found your blog using msn. This is an extremely well written article. I will be sure to bookmark it and come back to read more of your useful information. Thanks for the post. I will definitely comeback.
When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get three emails with the same comment. Is there any way you can remove me from that service? Thanks!
I think this is one of the most significant information for me. And i’m glad reading your article. But want to remark on few general things, The website style is great, the articles is really nice : D. Good job, cheers
Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.
I loved as much as you will receive carried out right here. The sketch is tasteful, your authored subject matter stylish. nonetheless, you command get bought an nervousness over that you wish be delivering the following. unwell unquestionably come further formerly again since exactly the same nearly a lot often inside case you shield this increase.
Having read this I thought it was really informative. I appreciate you finding the time and effort to put this informative article together. I once again find myself spending way too much time both reading and commenting. But so what, it was still worth it!
I really like it when people come together and share thoughts. Great blog, keep it up!
My spouse and I stumbled over here from a different web page and thought I might as well check things out. I like what I see so now i’m following you. Look forward to exploring your web page again.
Hey I am so happy I found your webpage, I really found you by error, while I was searching on Digg for something else, Nonetheless I am here now and would just like to say kudos for a remarkable post and a all round exciting blog (I also love the theme/design), I don’t have time to look over it all at the minute but I have book-marked it and also included your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the superb job.
Do you have a spam issue on this website; I also am a blogger, and I was wanting to know your situation; many of us have created some nice methods and we are looking to trade strategies with other folks, why not shoot me an e-mail if interested.
Very good website you have here but I was curious about if you knew of any discussion boards that cover the same topics talked about in this article? I’d really love to be a part of group where I can get feed-back from other knowledgeable individuals that share the same interest. If you have any recommendations, please let me know. Kudos!
Everything is very open with a precise description of the issues. It was really informative. Your website is very helpful. Thank you for sharing!
I do agree with all the ideas you have presented on your post. They are very convincing and will definitely work. Still, the posts are too brief for beginners. May you please extend them a bit from next time? Thank you for the post.
Hello there, You have done a fantastic job. I will definitely digg it and personally recommend to my friends. I am sure they will be benefited from this site.
Howdy! I realize this is kind of off-topic but I had to ask. Does running a well-established blog like yours take a massive amount work? I’m completely new to blogging but I do write in my diary daily. I’d like to start a blog so I will be able to share my own experience and views online. Please let me know if you have any suggestions or tips for new aspiring bloggers. Appreciate it!
This post is actually a nice one it helps new internet people, who are wishing for blogging.
Wow, superb blog format! How long have you been blogging for? you make blogging glance easy. The whole glance of your site is wonderful, let alonewell as the content!
This post will help the internet people for creating new weblog or even a blog from start to end.
Hi there, just wanted to say, I liked this article. It was inspiring. Keep on posting!
My spouse and I stumbled over here different page and thought I might as well check things out. I like what I see so now i’m following you. Look forward to finding out about your web page for a second time.
Ahaa, its pleasant discussion regarding this post here at this website, I have read all that, so now me also commenting here.
Aw, this was a really nice post. Spending some time and actual effort to make a good article? but what can I say? I procrastinate a lot and never seem to get anything done.
Spot on with this write-up, I truly think this web site needs much more attention. I’ll probably be back again to read more, thanks for the information!
Can I just say what a relief to find somebody who really knows what they’re talking about on the internet. You definitely know how to bring an issue to light and make it important. More and more people have to read this and understand this side of the story. I was surprised that you aren’t more popular because you definitely have the gift.
This piece of writing gives clear idea for the new viewers of blogging, that actually how to do blogging and site-building.
We stumbled over here different page and thought I might check things out. I like what I see so now i’m following you. Look forward to exploring your web page yet again.
I’m not sure why but this web site is loading extremely slow for me. Is anyone else having this issue or is it a problem on my end? I’ll check back later and see if the problem still exists.
I am sure this post has touched all the internet people, its really really pleasant article on building up new blog.
Wow, that’s what I was searching for, what a information! present here at this blog, thanks admin of this website.
Right now it sounds like Drupal is the best blogging platform out there right now. (from what I’ve read) Is that what you’re using on your blog?
Howdy! I could have sworn I’ve been to this site before but after browsing through a few of the posts I realized it’s new to me. Anyhow, I’m definitely happy I found it and I’ll be bookmarking it and checking back regularly!
I am in fact pleased to read this website posts which contains plenty of useful data, thanks for providing such information.
Thank you, I have recently been searching for information approximately this topic for ages and yours is the best I have found out so far. However, what concerning the conclusion? Are you sure concerning the source?
Sweet blog! I found it while browsing on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Appreciate it
I was more than happy to discover this site. I wanted to thank you for your time for this wonderful read!! I definitely enjoyed every little bit of it and I have you bookmarked to check out new stuff on your blog.
I am actually thankful to the owner of this web site who has shared this wonderful article at at this place.
It’s awesome to visit this site and reading the views of all mates concerning this post, while I am also keen of getting knowledge.
Hey there! Quick question that’s completely off topic. Do you know how to make your site mobile friendly? My blog looks weird when viewing from my iphone4. I’m trying to find a theme or plugin that might be able to fix this problem. If you have any suggestions, please share. Thanks!
Yes! Finally something about %keyword1%.
Wow, amazing blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is great, let alone the content!
Way cool! Some very valid points! I appreciate you writing this article and also the rest of the site is very good.
Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.
Unquestionably consider that that you stated. Your favourite justification appeared to be at the internet the simplest thing to remember of. I say to you, I definitely get irked whilst other folks consider concerns that they plainly do not recognise about. You controlled to hit the nail upon the top as well as defined out the whole thing with no need side effect , other people can take a signal. Will likely be back to get more. Thank you
I like the valuable information you provide in your articles. I will bookmark your weblog and check again here frequently. I am quite certain I will learn plenty of new stuff right here! Good luck for the next!