Applying a spread curve

Ian M · Apr 2nd, 2002, 08:31 PM

Hi,

I'm working on an estimating model where the user selects an amount (ie hours) and a curve profile (ie Linear= 20% 20% 20% 20% 20%, Bell= 10% 20% 40% 20% 10%, etc.)

The curve defines how to spread the hours over a duration that could be 1 month, 3 months, 7 months etc. I can get close using a PERCENTILE function, but any ideas for a better solution would be welcome.

Thanks

Duane · Apr 2nd, 2002, 10:31 PM

Do you have a sample spreadsheet you can email? If so, send it to me.

If not, I might benefit from more information on what you're trying to do.

Apr 2nd, 2002, 10:31 PM	#2
Duane Join Date: Mar 2002 Location: Toronto Posts: 171	Do you have a sample spreadsheet you can email? If so, send it to me. If not, I might benefit from more information on what you're trying to do. __________________ Regards, Duane (Office2003 in XP)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 08:31 PM	#1
Ian M Join Date: Apr 2002 Posts: 1	Hi, I'm working on an estimating model where the user selects an amount (ie hours) and a curve profile (ie Linear= 20% 20% 20% 20% 20%, Bell= 10% 20% 40% 20% 10%, etc.) The curve defines how to spread the hours over a duration that could be 1 month, 3 months, 7 months etc. I can get close using a PERCENTILE function, but any ideas for a better solution would be welcome. Thanks