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
Hey there, You have performed an excellent job. I will definitely digg it and individually recommend to my friends. I am sure they will be benefited from this web site.
Hey there! Do you use Twitter? I’d like to follow you if that would be ok. I’m undoubtedly enjoying your blog and look forward to new updates.
Can you tell us more about this? I’d like to find out more details.
odlypzxlp dovry mbqwdcr dfoi gruyxujrsuksjqv
I really like what you guys are up too. This type of clever work and exposure! Keep up the very good works guys I’ve added you guys to my personal blogroll.
Hi, Neat post. There is a problem together with your web site in internet explorer, could check this? IE still is the marketplace leader and a big portion of other people will miss your wonderful writing due to this problem.
My brother suggested I might like this website. He was totally right. This post actually made my day. You cann’t imagine just how much time I had spent for this information! Thanks!
I know this if off topic but I’m looking into starting my own blog and was wondering what all is required to get set up? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet savvy so I’m not 100% positive. Any tips or advice would be greatly appreciated. Kudos
whoah this blog is great i love reading your articles. Stay up the good work! You realize, many individuals are hunting around for this info, you can help them greatly.
Howdy, i read your blog occasionally and i own a similar one and i was just wondering if you get a lot of spam responses? If so how do you stop it, any plugin or anything you can suggest? I get so much lately it’s driving me mad so any help is very much appreciated.
Highly energetic article, I liked that a lot. Will there be a part 2?
Pretty component of content. I simply stumbled upon your web site and in accession capital to say that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing in your augment or even I fulfillment you get right of entry to persistently rapidly.
Pretty nice post. I just stumbled upon your blog and wanted to say that I have really enjoyed browsing your blog posts. In any case I’ll be subscribing to your feed and I hope you write again soon!
I couldn’t resist commenting. Very well written!
Nice replies in return of this issue with firm arguments and describing all about that.
Hi there everybody, here every one is sharing these familiarity, so it’s pleasant to read this webpage, and I used to visit this blog everyday.
Everything is very open with a precise explanation of the issues. It was really informative. Your website is very helpful. Thanks for sharing!
When someone writes an piece of writing he/she keeps the thought of a user in his/her mind that how a user can understand it. So that’s why this post is amazing. Thanks!
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 four emails with the same comment. Is there any way you can remove me from that service? Bless you!
Greate pieces. Keep writing such kind of information on your page. Im really impressed by your blog.
I am sure this post has touched all the internet users, its really really good post on building up new webpage.
Hi mates, how is everything, and what you want to say concerning this post, in my view its actually awesome designed for me.
Great post.
Does your site have a contact page? I’m having problems locating it but, I’d like to send you an e-mail. I’ve got some suggestions for your blog you might be interested in hearing. Either way, great site and I look forward to seeing it develop over time.
I do accept as true with all the concepts you have presented on your post. They are very convincing and will definitely work. Still, the posts are too quick for novices. May you please extend them a bit from next time? Thank you for the post.
Nice post. I learn something new and challenging on blogs I stumbleupon everyday. It will always be interesting to read content from other writers and practice a little something from their sites.
Hello! I could have sworn I’ve been to this site before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely glad I found it and I’ll be bookmarking and checking back often!
Hi there, I found your blog by the use of Google at the same time as searching for a comparable matter, your web site got here up, it looks good. I have bookmarked it in my google bookmarks.
Great post.
Hello there, You have performed a great job. I will definitely digg it and for my part recommend to my friends. I am sure they will be benefited from this web site.
I constantly spent my half an hour to read this weblog’s articles or reviews everyday along with a cup of coffee.
Oh my goodness! Amazing article dude! Many thanks, However I am encountering difficulties with your RSS. I don’t know why I am unable to subscribe to it. Is there anybody else getting the same RSS problems? Anybody who knows the solution will you kindly respond? Thanx!!
I was wondering if you ever considered changing the page layout of your site? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or two images. Maybe you could space it out better?
I am extremely inspired together with your writing skills and alsosmartly as with the layout in your blog. Is this a paid subject or did you customize it yourself? Either way stay up the nice quality writing, it’s rare to see a nice blog like this one these days..
Hi to all, how is all, I think every one is getting more from this site, and your views are good in favor of new people.
Have you ever thought about creating an e-book or guest authoring on other websites? I have a blog based upon on the same information you discuss and would really like to have you share some stories/information. I know my visitors would value your work. If you are even remotely interested, feel free to send me an e mail.
Inspiring quest there. What occurred after? Thanks!
This is the right blog for anyone who would like to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want to?HaHa). You definitely put a brand new spin on a topic that has been written about for years. Excellent stuff, just excellent!
Link exchange is nothing else except it is only placing the other person’s weblog link on your page at appropriate place and other person will also do same in favor of you.
Asking questions are in fact pleasant thing if you are not understanding anything completely, except this article gives good understanding even.
Yes! Finally something about %keyword1%.
Asking questions are really good thing if you are not understanding anything fully, except this piece of writing provides nice understanding even.
I will right away take hold of your rss as I can not in finding your email subscription link or newsletter service. Do you have any? Please allow me realize so that I may just subscribe. Thanks.
Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your site? My blog site is in the very same area of interest as yours and my visitors would certainly benefit from a lot of the information you present here. Please let me know if this alright with you. Thanks a lot!
Hi, i think that i saw you visited my weblog so i came to ?return the favor?.I am trying to find things to improve my site!I suppose its ok to use some of your ideas!!
Normally I do not read article on blogs, however I wish to say that this write-up very forced me to take a look at and do so! Your writing taste has been amazed me. Thank you, quite great article.
I am in fact thankful to the owner of this web site who has shared this enormous article at at this place.
Aw, this was a really nice post. Finding the time and actual effort to make a good article? but what can I say? I put things off a lot and never seem to get anything done.
This blog was… how do I say it? Relevant!! Finally I have found something that helped me. Many thanks!
Quality articles or reviews is the important to attract the viewers to go to see the website, that’s what this web site is providing.