Applying a spread curve
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Applying a spread curve

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Fort McMurray, AB
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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
    Office2010 in Win7

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com