prepare S-curve

[kvmahesh72]

I am trying to make S curves between given start and finish dates for following patterns. pls help with formulas. (spread to be between 0 to 100%)

Back load
Bell shape
Frontload
Linear
Offset Triangle
Three step
Trapezoidal
Triangular
Triangular Decrease

 

[number kruncher]

Have you tried any of the patterns above?
What formulas have you tried?
You have provided no Parameters.

We are here to help (operative word).

Hope this helps.

 

[kvmahesh72]

Have you tried any of the patterns above?
What formulas have you tried?
You have provided no Parameters.

We are here to help (operative word).

Hope this helps.

Thank you.. I have tried front load.. I think its working .. =$A$2*($B$2+2-ROW())/$B$2/SUMPRODUCT(ROW(INDIRECT("1:"&$B$2))/$B$2)
A is 100
B is Number of months
Others pls help with formulas

Percentage	# Months	frontload	Backload	Bell shape	Frontload	Linear	Offset Triangle	Three step	Trapezoidal	Triangular	Triangular Decrease
100%	10	18.182%
		16.364%
		14.545%
		12.727%
		10.909%
		9.091%
		7.273%
		5.455%
		3.636%
		1.818%
		0.000%
		-1.818%
		-3.636%
		-5.455%
		-7.273%
		-9.091%
		-10.909%
		-12.727%

 

[kvmahesh72]

Also, Parameters are 0 to 100% and duration in months entered manual..

 

[number kruncher]

have you checked out previous posts on this subject ?

Help with Auto-populating Percentages Based on User Input

Some more questions related to the draw schedule, which I'd like to create without using macros if possible. 1. how can I autopopulate the number of periods in (A17:A28) and (G4:15) based on result in cell C7? 2. can the percentages in column H autofill based on value in B13 and corresponding %...

www.mrexcel.com

 

[kvmahesh72]

Checked aren`t clear..