Help with MS Excel S-Curve

Hi everyone,

I am new to this forum so I would really appreciate your help in the following matter:

I have a MS Project worksheet that helped me create a Cash Flow report with Excel. My problem is that our customer has requested an "Earnings Curve" and so far I haven't been successful with the previous curves I have submitted. My due date is tomorrow

Our customer is asking for an earnings curve which will show the actual accumulative cost, base on % completion.

So far I have managed to reflect a curve that shows the actual cost, based on % completion, but it needs to be accumulative (nine is not). In an accumulative curve, the curve will always go up when their is a payment and horizontal when there is no payment. However, the curve can never go down (mine does).

Anyone can help with this?

Thanks in advance for taking the time to read my post and comments.

Hi everyone,

I am new to this forum so I would really appreciate your help in the following matter:

I have a MS Project worksheet that helped me create a Cash Flow report with Excel. My problem is that our customer has requested an "Earnings Curve" and so far I haven't been successful with the previous curves I have submitted. My due date is tomorrow

Our customer is asking for an earnings curve which will show the actual accumulative cost, base on % completion.

So far I have managed to reflect a curve that shows the actual cost, based on % completion, but it needs to be accumulative (nine is not). In an accumulative curve, the curve will always go up when their is a payment and horizontal when there is no payment. However, the curve can never go down (mine does).

Anyone can help with this?

Thanks in advance for taking the time to read my post and comments.

Thank you Excel day savers!

Please see a screen shot of my worksheet data.

Also, what I meant with % completion is percentage completion as in:
An S-curve that will be used to check during construction when pay requests are submitted
to check the actual progress against the schedule.


This was my review for the earnings curve attached:
“I reviewed the earnings curve, but unfortunately it is still not correct.
The 2nd curve now seem to show the actual cost, based on % completion, but it needs to be accumulative, which it is not.
In an accumulative curve, the curve will always go up when there is a payment and horizontal when there is no payment.
However, the curve can never go down."


Thanks for your taking the time to reply!

This is a screen shot of my worksheet data. I got a review That said:

"Curve 1 is OK. Curve 2 needs to show the accumulative actual cost. The 2nd curve now seem to show the actual cost,
based on % completion, but it needs to be accumulative, which it is not.
In an accumulative curve, the curve will always go up when their is a payment and horizontal when there is no payment.
However, the curve can never go down."

Thanks for your reply!

How can I fix it? I am totally in blank with this situation.

Thanks for your reply!

I have attached a sample file.
What type of column should I add to my table?
I really appreciate you taking your time to help.
Thank you.