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. 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. Thank you for the post. I will definitely comeback.
Thank you for the auspicious writeup. It in reality used to be a amusement account it. Glance complicated to far brought agreeable from you! By the way, how can we keep in touch?
This text is invaluable. How can I find out more?
Greetings from Ohio! I’m bored to death at work so I decided to check out your site on my iphone during lunch break. I really like the info you present here and can’t wait to take a look when I get home. I’m amazed at how quick your blog loaded on my cell phone .. I’m not even using WIFI, just 3G .. Anyhow, excellent site!
Spot on with this write-up, I really believe this website needs far more attention. I’ll probably be back again to read through more, thanks for the information!
You can definitely see your expertise in the article you write. The world hopes for more passionate writers like you who aren’t afraid to mention how they believe. Always go after your heart.
I have been surfing online more than three hours nowadays, yet I never found any fascinating article like yours. It’s lovely worth enough for me. In my opinion, if all website owners and bloggers made just right content as you did, the net shall be much more useful than ever before.
Everything is very open with a clear explanation of the issues. It was truly informative. Your website is very useful. Thank you for sharing!
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.
You ought to take part in a contest for one of the greatest blogs on the internet. I will recommend this site!
hi!,I love your writing so so much! percentage we communicate more approximately your post on AOL? I need an expert in this space to solve my problem. May be that is you! Taking a look forward to peer you.
I’m now not positive where you are getting your info, however good topic. I needs to spend a while studying more or working out more. Thank you for magnificent information I used to be in search of this information for my mission.
I don’t know if it’s just me or if everyone else experiencing problems with your website. It looks like some of the text on your posts are running off the screen. Can someone else please comment and let me know if this is happening to them too? This could be a problem with my browser because I’ve had this happen before. Thank you
Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You clearly know what youre talking about, why waste your intelligence on just posting videos to your blog when you could be giving us something enlightening to read?
Beginner Testosterone Cypionate Cycle finasteride 1 mg buy uk
Currently it seems like Movable Type is the best blogging platform out there right now. (from what I’ve read) Is that what you’re using on your blog?
Hi there, this weekend is nice in favor of me, as this time i am reading this enormous informative article here at my house.
Aw, this was an incredibly nice post. Finding the time and actual effort to make a top notch article? but what can I say? I procrastinate a lot and never seem to get anything done.
Great site. A lot of useful information here. I’m sending it to a few pals ans also sharing in delicious. And obviously, thank you for your effort!
Hey! I know this is somewhat off-topic but I had to ask. Does running a well-established blog like yours take a lot of work? I’m completely new to writing a blog but I do write in my diary on a daily basis. I’d like to start a blog so I will be able to share my experience and thoughts online. Please let me know if you have any suggestions or tips for new aspiring bloggers. Appreciate it!
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% sure. Any recommendations or advice would be greatly appreciated. Appreciate it
Usually I do not read article on blogs, however I wish to say that this write-up very forced me to try and do so! Your writing taste has been amazed me. Thank you, quite great article.
prednisone 2.5 tablet: http://prednisone1st.store/# prednisone drug costs
Greetings! Very helpful advice within this article! It is the little changes which will make the largest changes. Thanks a lot for sharing!
I always emailed this webpage post page to all my associates, because if like to read it next my links will too.
With havin so much content and articles do you ever run into any problems of plagorism or copyright violation? My website has a lot of exclusive content I’ve either authored myself or outsourced but it appears a lot of it is popping it up all over the web without my authorization. Do you know any techniques to help protect against content from being ripped off? I’d truly appreciate it.
Hello there, just became aware of your blog through Google, and found that it is really informative. I’m gonna watch out for brussels. I will appreciate if you continue this in future. Many people will be benefited from your writing. Cheers!
free dating and chatting: connecting singles games – free dating sites chat
Howdy! I’m at work browsing your blog from my new iphone! Just wanted to say I love reading your blog and look forward to all your posts! Keep up the great work!
Appreciating the hard work you put into your site and in depth information you provide. It’s great to come across a blog every once in a while that isn’t the same outdated rehashed material. Fantastic read! I’ve saved your site and I’m including your RSS feeds to my Google account.
My programmer is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the expenses. But he’s tryiong none the less. I’ve been using Movable-type on a variety of websites for about a year and am worried about switching to another platform. I have heard very good things about blogengine.net. Is there a way I can transfer all my wordpress content into it? Any kind of help would be really appreciated!
Hi there, i read your blog occasionally and i own a similar one and i was just wondering if you get a lot of spam comments? If so how do you reduce it, any plugin or anything you can advise? I get so much lately it’s driving me mad so any assistance is very much appreciated.
What i do not realize is actually how you’re now not really a lot more well-liked than you may be right now. You are so intelligent. You recognize therefore significantly on the subject of this topic, produced me in my opinion consider it from so many numerous angles. Its like men and women aren’t interested until it’s something to accomplish with Woman gaga! Your personal stuffs nice. All the time care for it up!
This is very interesting, You are a very skilled blogger. I have joined your feed and look forward to seeking more of your wonderful post. Also, I have shared your web site in my social networks!
you are actually a just right webmaster. The site loading velocity is incredible. It sort of feels that you are doing any unique trick. Moreover, The contents are masterpiece. you have performed a magnificent task in this topic!
Thank you for any other magnificent article. Where else may anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am at the look for such information.
Your style is really unique compared to other people I have read stuff from. Thank you for posting when you have the opportunity, Guess I will just bookmark this page.
Thanks for ones marvelous posting! I actually enjoyed reading it, you could be a great author.I will always bookmark your blog and will often come back very soon. I want to encourage continue your great posts, have a nice holiday weekend!
For most recent news you have to visit internet and on internet I found this web site as a best website for most recent updates.
Greetings! I know this is kinda off topic however I’d figured I’d ask. Would you be interested in exchanging links or maybe guest writing a blog article or vice-versa? My site discusses a lot of the same subjects as yours and I believe we could greatly benefit from each other. If you happen to be interested feel free to send me an e-mail. I look forward to hearing from you! Superb blog by the way!
Thanks for a marvelous posting! I seriously enjoyed reading it, you might be a great author. I will make certain to bookmark your blog and will eventually come back from now on. I want to encourage you to continue your great posts, have a nice holiday weekend!
Wow, this post is pleasant, my sister is analyzing such things, so I am going to inform her.
canadadrugpharmacy com canadian pharmacy 24h com safe
Good way of explaining, and good piece of writing to get information about my presentation subject, which i am going to deliver in institution of higher education.
continuously i used to read smaller posts which also clear their motive, and that is also happening with this piece of writing which I am reading here.
I am really thankful to the owner of this web site who has shared this enormous article at here.
Hello there! This article couldn’t be written any better! Looking at this post reminds me of my previous roommate! He constantly kept talking about this. I am going to forward this article to him. Pretty sure he’ll have a very good read. Thanks for sharing!
It’s a shame you don’t have a donate button! I’d most certainly donate to this fantastic blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to brand new updates and will talk about this site with my Facebook group. Chat soon!
non prescription erection pills: ed pills that really work – ed treatment review
Hi I am so glad I found your weblog, I really found you by mistake, while I was searching on Bing for something else, Regardless I am here now and would just like to say thank you for a fantastic post and a all round thrilling blog (I also love the theme/design), I don’t have time to read through it all at the minute but I have saved it and also added in your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the superb job.