Announcement

Collapse
No announcement yet.

Forecasting, running totals

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • flem
    started a topic Forecasting, running totals

    Forecasting, running totals

    Hi All!

    I am a very inexperienced excel user and have been working on a spreadsheet for my boss and am in desperate need of some assistance.

    The attached file is what I have come up with so far. Excuse the long winded formulas but like i mentioned above my excelpertise are limited

    The input contractors sheet allows you to input the amount of 3/6 month contractors for a month and then shows the breakdown of contractors on our books for the next 3/6 months with 50% of the contractors falling off every 3/6 months.

    What I need to do now is allow the 3/6 months to become a variable and the percentage (50%) of fall offs to also become a variable.

    In addition I have to allow me to replace the forecasted figure with the actual figures after the month has been completed.

    Would anyone be able to point me in the right direction? or any direction for that matter!!!

    Any help would be much appreciated.


    flem
    Attached Files

  • Dave Hawley
    replied
    Re: Forecasting, running totals

    PM me when you have read the rules in my signature

    http://www.excelforum.com/excel-gene...ng-totals.html

    Leave a comment:

Working...
X