Help with time-phased budgeting app in Excel and curve-fitting

I 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 tommorow. I thought it was completed until I was told today
that my calculations weren't right. Here's what the requirements of
the project are:

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 all day
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.

.

Relevant Pages

  • Help with budget curve application
    ... I am currently working on a time-phased budgeting app in excel for a ... number of periods to spread the budget over, I provide the amount to be ... I'm figuring i need a curve thats max y-value should be at ...
    (sci.math.num-analysis)
  • Using Curve-fit for time-phased budget app in Excel
    ... I'm supposed to deliver the app to him by the close of ... number of periods to spread the budget over, I provide the amount to be ... I was just informed that the slope of the curve he refers to is ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help with budget curve application
    ... I was supposed to deliver the app to him by the close of ... > slope of the curve. ... > it used the solver in Excel and the curve-fit function. ...
    (sci.math.num-analysis)
  • Re: Help with budget curve application
    ... I was supposed to deliver the app to him by the close of ... >slope of the curve. ... >I have asked the client for a little more insight into how this curve ...
    (sci.math.num-analysis)
  • Re: Using Curve-fit for time-phased budget app in Excel
    ... Regarding "the solver in Excel and the curve-fit function," once you have ... specified a functional form for the curve, you ... parameters in cells, uses references to those ... > number of periods to spread the budget over, I provide the amount to be ...
    (microsoft.public.excel.worksheet.functions)