surveys

  1. J

    Creating a pivot chart to show survey results

    Good morning all, I have a problem I've been trying to solve for a while and I can't seem to find a good way to do it. I have survey data which needs to be visually represented in charts. Participants are asked a number of questions and can answer 1-6 (1 being the lowest, 6 the highest)...
  2. G

    Surveys Needed Calculator

    Good Day! I wanted to make a calculator to determine the number of perfect surveys needed to reach the target. Please see details below: Current score: 96.77% # of Surveys: 31 (30 satisfied / 1 dissatisfied) Goal: 98% Appreciate any help ?
  3. M

    Lift/Drag

    Hello! I’m working on reporting to show the overall impact an agent has on our site. Our site KPI goal is 90%; Agent 1 has 20 surveys averaging 80% Agent 2 has 100 surveys at 80%. Both are obviously not meeting but Agent 2 has a bigger “drag” to our site. Can someone help me with the formula...
  4. A

    Really need some formula help please .....

    Hi folks. I’m having a major meltdown and need to get this sorted for work. Have asked around the office and our IT dept but they say they don’t have time to work this out ( read it’s too difficult!! ) I am conducting a survey at work and the answer to the questions is either a “yes” or “no”...
  5. R

    Calculating Number Needed to Hit Percentage

    Hi There, I am wondering if I could get some help. At work we calculate customer satisfaction with NPS surveys, which is percentage of promoters (rating of 9 or 10) minus percentage of detractors (rating of 6 or below). Our NPS score is calculated as ((Promoters/Total Surveys)-(Detractors/Total...
  6. A

    VBA Code for Entering Data With Double Clicks

    Hello All: I am trying to build a Survey Form in Excel where I want to simplify the data entry by allowing the user to enter data by double-clicking on cells (or buttons), with some areas for text input. Some questions will have multiple answer options by I want to force only one selection...
  7. K

    CSAT Score Predictor

    hello there! it's been a while since i last dropped by. once again, i am here seeking help in coming up with a Customer Satisfaction survey score predictor where possible scores in 1 survey are only: 100, 80, 60, 40, 20 & 0. say in order to pass, 1 must aim to have a 93% as an average score for...
  8. 2

    Compiling Data from excel survey....Is it even possible to accomplish what i want?

    So, I created an Excel Survey to ask new customers to our powder-coating business to provide the vital information regarding their work orders that is badly missed on their hand-written P.O.s, and in the never-ending struggle to make life easier, I thought, "Self, you should really try to get...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top