Compute Promoter Surveys Needed to Meet a Target

[Venus Uson]

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.

Date	Promoters	Neutral	Detractors	# of Survey	NPS	Target	Cumulative	% to Goal
1-Jan	178	15	38	231	60.61	80	60.61	75.76%
2-Jan	219	24	42	285	62.11	80	61.43	76.79%
3-Jan	216	21	48	285	58.95	80	60.55	75.69%
4-Jan	0	0	0	0		80	60.55	75.69%
5-Jan	344	24	69	437	62.93	80	61.39	76.74%
6-Jan	228	19	48	295	61.02	80	61.32	76.65%
7-Jan	220	22	38	280	65.00	80	61.89	77.36%
8-Jan	134	11	23	168	66.07	80	62.24	77.80%
9-Jan	191	22	41	254	59.06	80	61.88	77.35%
10-Jan	198	19	33	250	66.00	80	62.29	77.87%
11-Jan	313	24	52	389	67.10	80	62.94	78.68%
12-Jan	250	17	47	314	64.65	80	63.11	78.89%
13-Jan	210	22	33	265	66.79	80	63.39	79.24%
14-Jan	202	21	23	246	72.76	80	64.02	80.02%
15-Jan	0	0	0	0		80	64.02	80.02%
16-Jan				0		80	64.02	80.02%
17-Jan				0		80	64.02	80.02%
18-Jan				0		80	64.02	80.02%
19-Jan				0		80	64.02	80.02%
20-Jan				0		80	64.02	80.02%
21-Jan				0		80	64.02	80.02%
22-Jan				0		80	64.02	80.02%
23-Jan				0		80	64.02	80.02%
24-Jan				0		80	64.02	80.02%
25-Jan				0		80	64.02	80.02%
26-Jan				0		80	64.02	80.02%
27-Jan				0		80	64.02	80.02%
28-Jan				0		80	64.02	80.02%
29-Jan				0		80	64.02	80.02%
30-Jan				0		80	64.02	80.02%
31-Jan				0		80	64.02	80.02%
Grand Total	2903	261	535	3699	64.02

 

[maabadi]

It Depends on Neutral and Detractors and Exact Value for that is
Promoters = 4 * Neutral + 9 * Dtractors

 

[Venus Uson]

It Depends on Neutral and Detractors and Exact Value for that is
Promoters = 4 * Neutral + 9 * Dtractors

The formula is not working.

 

[maabadi]

This is Not formula I tell to you procedure. Check Columns K & L

TestFormatting.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	Promoters	Neutral	Detractors	# of Survey	NPS	Target	Cumulative	% to Goal		Promoters Goal	NPS
2	1-Jan	178	15	38	231	60.61	80	60.61	75.76%		402	80
3	2-Jan	219	24	42	285	62.11	80	61.43	76.79%		474	80
4	3-Jan	216	21	48	285	58.95	80	60.55	75.69%		516	80
5	4-Jan	0	0	0	0		80	60.55	75.69%		0
6	5-Jan	344	24	69	437	62.93	80	61.39	76.74%		717	80
7	6-Jan	228	19	48	295	61.02	80	61.32	76.65%		508	80
8	7-Jan	220	22	38	280	65	80	61.89	77.36%		430	80
9	8-Jan	134	11	23	168	66.07	80	62.24	77.80%		251	80
10	9-Jan	191	22	41	254	59.06	80	61.88	77.35%		457	80
11	10-Jan	198	19	33	250	66	80	62.29	77.87%		373	80
12	11-Jan	313	24	52	389	67.1	80	62.94	78.68%		564	80
13	12-Jan	250	17	47	314	64.65	80	63.11	78.89%		491	80
14	13-Jan	210	22	33	265	66.79	80	63.39	79.24%		385	80
15	14-Jan	202	21	23	246	72.76	80	64.02	80.02%		291	80
16	15-Jan	0	0	0	0		80	64.02	80.02%		0
17	16-Jan				0		80	64.02	80.02%		0
18	17-Jan				0		80	64.02	80.02%		0
19	18-Jan				0		80	64.02	80.02%		0
20	19-Jan				0		80	64.02	80.02%		0
21	20-Jan				0		80	64.02	80.02%		0
22	21-Jan				0		80	64.02	80.02%		0
23	22-Jan				0		80	64.02	80.02%		0
24	23-Jan				0		80	64.02	80.02%		0
25	24-Jan				0		80	64.02	80.02%		0
26	25-Jan				0		80	64.02	80.02%		0
27	26-Jan				0		80	64.02	80.02%		0
28	27-Jan				0		80	64.02	80.02%		0
29	28-Jan				0		80	64.02	80.02%		0
30	29-Jan				0		80	64.02	80.02%		0
31	30-Jan				0		80	64.02	80.02%		0
32	31-Jan				0		80	64.02	80.02%		0
33	Grand Total	2903	261	535	3699	64.02					5859	80
Sheet4

Cell Formulas
Range	Formula
L33,L6:L15,L2:L4	L2	=(K2-D2)*100/(K2+C2+D2)
K2:K33	K2	=4*C2+9*D2

 

[Venus Uson]

This is Not formula I tell to you procedure. Check Columns K & L

TestFormatting.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	Promoters	Neutral	Detractors	# of Survey	NPS	Target	Cumulative	% to Goal		Promoters Goal	NPS
2	1-Jan	178	15	38	231	60.61	80	60.61	75.76%		402	80
3	2-Jan	219	24	42	285	62.11	80	61.43	76.79%		474	80
4	3-Jan	216	21	48	285	58.95	80	60.55	75.69%		516	80
5	4-Jan	0	0	0	0		80	60.55	75.69%		0
6	5-Jan	344	24	69	437	62.93	80	61.39	76.74%		717	80
7	6-Jan	228	19	48	295	61.02	80	61.32	76.65%		508	80
8	7-Jan	220	22	38	280	65	80	61.89	77.36%		430	80
9	8-Jan	134	11	23	168	66.07	80	62.24	77.80%		251	80
10	9-Jan	191	22	41	254	59.06	80	61.88	77.35%		457	80
11	10-Jan	198	19	33	250	66	80	62.29	77.87%		373	80
12	11-Jan	313	24	52	389	67.1	80	62.94	78.68%		564	80
13	12-Jan	250	17	47	314	64.65	80	63.11	78.89%		491	80
14	13-Jan	210	22	33	265	66.79	80	63.39	79.24%		385	80
15	14-Jan	202	21	23	246	72.76	80	64.02	80.02%		291	80
16	15-Jan	0	0	0	0		80	64.02	80.02%		0
17	16-Jan				0		80	64.02	80.02%		0
18	17-Jan				0		80	64.02	80.02%		0
19	18-Jan				0		80	64.02	80.02%		0
20	19-Jan				0		80	64.02	80.02%		0
21	20-Jan				0		80	64.02	80.02%		0
22	21-Jan				0		80	64.02	80.02%		0
23	22-Jan				0		80	64.02	80.02%		0
24	23-Jan				0		80	64.02	80.02%		0
25	24-Jan				0		80	64.02	80.02%		0
26	25-Jan				0		80	64.02	80.02%		0
27	26-Jan				0		80	64.02	80.02%		0
28	27-Jan				0		80	64.02	80.02%		0
29	28-Jan				0		80	64.02	80.02%		0
30	29-Jan				0		80	64.02	80.02%		0
31	30-Jan				0		80	64.02	80.02%		0
32	31-Jan				0		80	64.02	80.02%		0
33	Grand Total	2903	261	535	3699	64.02					5859	80
Sheet4

Cell Formulas
Range	Formula
L33,L6:L15,L2:L4	L2	=(K2-D2)*100/(K2+C2+D2)
K2:K33	K2	=4*C2+9*D2

Promoter are 9 to 10, Neutrals are 7 to 8 then detractors are 6 to 0

 

[maabadi]

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?

 

[maabadi]

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
	A	B	C	D
1	Promoters	Neutral	Detractors	NPS
2	10	8	-2.44	80
3	9.95	7.95	-2.43	80
4	9.9	7.9	-2.41	80
5	9.85	7.85	-2.39	80
6	9.8	7.8	-2.38	80
7	9.75	7.75	-2.36	80
8	9.7	7.7	-2.34	80
9	9.65	7.65	-2.33	80
10	9.6	7.6	-2.31	80
11	9.55	7.55	-2.29	80
12	9.5	7.5	-2.28	80
13	9.45	7.45	-2.26	80
14	9.4	7.4	-2.24	80
15	9.35	7.35	-2.23	80
16	9.3	7.3	-2.21	80
17	9.25	7.25	-2.19	80
18	9.2	7.2	-2.18	80
19	9.15	7.15	-2.16	80
20	9.1	7.1	-2.14	80
21	9.05	7.05	-2.13	80
22	9	7	-2.11	80
Sheet5

Cell Formulas
Range	Formula
C2:C22	C2	=(A2-4*B2)/9
D2:D22	D2	=(A2-C2)*100/(A2+B2+C2)