Formula for S Shape Curve

[chris8877]

scurve ee.xls


Hello Experts,

I have a few dates and one Total value. I need to distribute this Total Value in such a way so I can get the same shape S curve (Date vs Value).
In my attached sheet please develop/assign a formula so I can get the Exact same S curve. Please someone help.
Thanks,

Chris

[shg]

Why not use the same approach you used in rows 4 and 5?

[chris8877]

Dear Shg,
I tried it but it does not work. If you or any respected member please could help and develop a formula in the attached sheet it would be a great help.
Thanks

[Kaper]

Suggested formula for N11 is:

Please Login or Register  to view this content.

If you got something in date format, change the cell format into General (Ctrl+1)
Copy down.

You can adjust how steep the curve is by changing 6 in third argument into for instance 12 (very steep) or 3 (rather flat) - follow your taste

P.S. For those with older Excel versions - formula shall read:

Please Login or Register  to view this content.

[chris8877]

Kaper,
Great Work ... Thank you very much ...