Compute Promoter Surveys Needed to Meet a Target

Venus Uson

New Member
Joined
Jan 11, 2021
Messages
6
Office Version
  1. 365
Platform
  1. Windows
Hello,

I need help in deriving the formula to get the total number of promoters needed in order for us to meet our NPS.

Actual Survey Count: 3699
Promoters: 2903
Neutrals: 261
Detractors: 535
Net Promoter Score (NPS): 64.02
Formula = ((Promoters - Detractors)/(Promoters + Neutrals + Detractors)*100)

I need to know the formula on how to get the total number of promoters needed in order for our 64.02 NPS to be at 80.00.



DatePromotersNeutralDetractors# of SurveyNPSTargetCumulative% to Goal
1-Jan178153823160.618060.6175.76%
2-Jan219244228562.118061.4376.79%
3-Jan216214828558.958060.5575.69%
4-Jan00008060.5575.69%
5-Jan344246943762.938061.3976.74%
6-Jan228194829561.028061.3276.65%
7-Jan220223828065.008061.8977.36%
8-Jan134112316866.078062.2477.80%
9-Jan191224125459.068061.8877.35%
10-Jan198193325066.008062.2977.87%
11-Jan313245238967.108062.9478.68%
12-Jan250174731464.658063.1178.89%
13-Jan210223326566.798063.3979.24%
14-Jan202212324672.768064.0280.02%
15-Jan00008064.0280.02%
16-Jan08064.0280.02%
17-Jan08064.0280.02%
18-Jan08064.0280.02%
19-Jan08064.0280.02%
20-Jan08064.0280.02%
21-Jan08064.0280.02%
22-Jan08064.0280.02%
23-Jan08064.0280.02%
24-Jan08064.0280.02%
25-Jan08064.0280.02%
26-Jan08064.0280.02%
27-Jan08064.0280.02%
28-Jan08064.0280.02%
29-Jan08064.0280.02%
30-Jan08064.0280.02%
31-Jan08064.0280.02%
Grand Total2903261535369964.02
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
It Depends on Neutral and Detractors and Exact Value for that is
Promoters = 4 * Neutral + 9 * Dtractors
 
Upvote 0
This is Not formula I tell to you procedure. Check Columns K & L

TestFormatting.xlsm
ABCDEFGHIJKL
1DatePromotersNeutralDetractors# of SurveyNPSTargetCumulative% to GoalPromoters GoalNPS
21-Jan178153823160.618060.6175.76%40280
32-Jan219244228562.118061.4376.79%47480
43-Jan216214828558.958060.5575.69%51680
54-Jan00008060.5575.69%0
65-Jan344246943762.938061.3976.74%71780
76-Jan228194829561.028061.3276.65%50880
87-Jan2202238280658061.8977.36%43080
98-Jan134112316866.078062.2477.80%25180
109-Jan191224125459.068061.8877.35%45780
1110-Jan1981933250668062.2977.87%37380
1211-Jan313245238967.18062.9478.68%56480
1312-Jan250174731464.658063.1178.89%49180
1413-Jan210223326566.798063.3979.24%38580
1514-Jan202212324672.768064.0280.02%29180
1615-Jan00008064.0280.02%0
1716-Jan08064.0280.02%0
1817-Jan08064.0280.02%0
1918-Jan08064.0280.02%0
2019-Jan08064.0280.02%0
2120-Jan08064.0280.02%0
2221-Jan08064.0280.02%0
2322-Jan08064.0280.02%0
2423-Jan08064.0280.02%0
2524-Jan08064.0280.02%0
2625-Jan08064.0280.02%0
2726-Jan08064.0280.02%0
2827-Jan08064.0280.02%0
2928-Jan08064.0280.02%0
3029-Jan08064.0280.02%0
3130-Jan08064.0280.02%0
3231-Jan08064.0280.02%0
33Grand Total2903261535369964.02585980
Sheet4
Cell Formulas
RangeFormula
L33,L6:L15,L2:L4L2=(K2-D2)*100/(K2+C2+D2)
K2:K33K2=4*C2+9*D2
 
Upvote 0
This is Not formula I tell to you procedure. Check Columns K & L

TestFormatting.xlsm
ABCDEFGHIJKL
1DatePromotersNeutralDetractors# of SurveyNPSTargetCumulative% to GoalPromoters GoalNPS
21-Jan178153823160.618060.6175.76%40280
32-Jan219244228562.118061.4376.79%47480
43-Jan216214828558.958060.5575.69%51680
54-Jan00008060.5575.69%0
65-Jan344246943762.938061.3976.74%71780
76-Jan228194829561.028061.3276.65%50880
87-Jan2202238280658061.8977.36%43080
98-Jan134112316866.078062.2477.80%25180
109-Jan191224125459.068061.8877.35%45780
1110-Jan1981933250668062.2977.87%37380
1211-Jan313245238967.18062.9478.68%56480
1312-Jan250174731464.658063.1178.89%49180
1413-Jan210223326566.798063.3979.24%38580
1514-Jan202212324672.768064.0280.02%29180
1615-Jan00008064.0280.02%0
1716-Jan08064.0280.02%0
1817-Jan08064.0280.02%0
1918-Jan08064.0280.02%0
2019-Jan08064.0280.02%0
2120-Jan08064.0280.02%0
2221-Jan08064.0280.02%0
2322-Jan08064.0280.02%0
2423-Jan08064.0280.02%0
2524-Jan08064.0280.02%0
2625-Jan08064.0280.02%0
2726-Jan08064.0280.02%0
2827-Jan08064.0280.02%0
2928-Jan08064.0280.02%0
3029-Jan08064.0280.02%0
3130-Jan08064.0280.02%0
3231-Jan08064.0280.02%0
33Grand Total2903261535369964.02585980
Sheet4
Cell Formulas
RangeFormula
L33,L6:L15,L2:L4L2=(K2-D2)*100/(K2+C2+D2)
K2:K33K2=4*C2+9*D2
Promoter are 9 to 10, Neutrals are 7 to 8 then detractors are 6 to 0
 
Upvote 0
Promoter are 9 to 10, Neutrals are 7 to 8 then detractors are 6 to 0
I don't know what this means. these is Values range? why your data range is different than these criteria?
 
Upvote 0
With this situation Detractors is Minus and can't be at Range 0 to 6 to get Target NPS at 80
Minimum of your promoters should be 4 times of neutral to get distractors should be 0
TestFormatting.xlsm
ABCD
1PromotersNeutralDetractorsNPS
2108-2.4480
39.957.95-2.4380
49.97.9-2.4180
59.857.85-2.3980
69.87.8-2.3880
79.757.75-2.3680
89.77.7-2.3480
99.657.65-2.3380
109.67.6-2.3180
119.557.55-2.2980
129.57.5-2.2880
139.457.45-2.2680
149.47.4-2.2480
159.357.35-2.2380
169.37.3-2.2180
179.257.25-2.1980
189.27.2-2.1880
199.157.15-2.1680
209.17.1-2.1480
219.057.05-2.1380
2297-2.1180
Sheet5
Cell Formulas
RangeFormula
C2:C22C2=(A2-4*B2)/9
D2:D22D2=(A2-C2)*100/(A2+B2+C2)
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,198
Members
448,554
Latest member
Gleisner2

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