Re: Using Curve-fit for time-phased budget app in Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

James -

If it's not linear, i.e., "spread budgeted amounts evenly among certain
ranges of periods," then you need more information about how it should be
"spread," i.e, the functional form.

- Mike
www.mikemiddleton.com

"James Nasty" <j.grossiv@xxxxxxxxx> wrote in message
news:1123250572.311958.252190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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 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 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.
>


.

Relevant Pages

  • 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)
  • Re: Suggested power tools to buy for beginner
    ... You are not going to get good quality for everything on your list in your ... budget, but if you spread it out, you may be about to get some really good ... slightly abused is okay. ...
    (alt.home.repair)
  • 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)
  • 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 ... 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 ...
    (comp.apps.spreadsheets)