S-Curve Generation Template in Excel

  • Posted:
  • Proposals: 1
  • Remote
  • #666226
  • Awarded
Ali H.
has already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Hello Ali,
I'm looking for someone who can create a template in excel that would do the following:
1. Create an initial graph and table representing a monthly progression schedule (progress in % on Y axis, months on X. Template would allow to specify number of months, start and end months to generate it.
2. A script would then draw a S-Curve based on the following parameters: start of curve at 0%, it should then reach 25% progress at 1/3 of schedule length, 75% at 2/3 and 100% at end.
3. Percentages for each month based on that curve should be shown in the table so we can calculate progress in dollars based on overall project value. The values should then be turned into a graph that can be layered on top of the initial graph showing project value progress %.

This is the basic idea. If possible we would like to have the ability to integrate vacation weeks in some months so that the progression can take these time outs into account (this would create flat lines in the curve). Let me know if you need more info. The S-Curve is basically a bezier curve I think (you can google s-curve project management). When we calculate progress of first month it should be more than 0% (obviously).
Thanks,
JP

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.