am currently working on a time-phased budgeting app in excel for a
client. I'm supposed to deliver the app to him by the close of
business TODAY. I thought it was completed until I was told yesterday
that my output calculations weren't right. Here's what the
requirements of
the project a

"I need to time-phase budgets. generally, there are two scenarios I
work
in.

The first is - there are no actuals or costs to date. I provide the
number of periods to spread the budget over, I provide the amount to be
spread, and I provide the "shape of the curve"....that is - if I said
"50%" - then, at the 50% mark of 'time' (i.e., periods); 50% of the
"amount" will have been spent; if I said "30%", then at the 50% mark of
time, 30% of amount will have been spent.

The second scenario is a situation whereby I've already incurred
actuals or costs-to-date within my budget - and now I need to
time-phase the remaining budget over the remaining number of periods."

I was just informed that the slope of the curve he refers to is
supposed to be an actual curve. I thought it was just used to spread
budgeted amounts evenly among certain ranges of periods. I asked the
client for a little more insight into how this curve things is to be
calculated and he told me that he had an app that did this before and
it used the solver in Excel and the curve-fit function. I did not find
a curve fit function.

I have been furiously searching the net since trying to find out more
about this curve-fit function or concept. If you can provide me with
any more insight into this problem, i would greatly appreciate it.