+ Reply to Thread
Results 1 to 1 of 1

Monthly Forecast Automatic Spreads

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    371

    Monthly Forecast Automatic Spreads

    My goal is to re-spread over or under monthly variances as months progress and actuals are updated. I'm doing this manually for over 120 project budgets. I wish to automate the re-spreading of the variances (whether under or over). The original budget allocation should stay static as the re-spreads are updated. Any ideas or resolution is greatly appreciated. I've attached a sample of what I have...

    Edit:
    I forgot to add that some projects may start anytime during the initial year and some even can cross over to the following year. Therefore the budgets will be multi year. I've updated the attachment -
    Attached Files Attached Files
    Last edited by rz6657; 06-12-2014 at 02:22 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert 52 Week Rolling Forecast to Monthly Forecast
    By rainintl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2014, 07:24 PM
  2. automatic monthly entry
    By gsvrcek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2014, 08:47 AM
  3. Replies: 3
    Last Post: 03-12-2013, 12:14 PM
  4. automatic monthly payment until end
    By kghisla in forum Excel General
    Replies: 2
    Last Post: 11-07-2010, 03:50 PM
  5. How do I forecast monthly and annual totals from previous year's .
    By Jeff Hart in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-01-2005, 03:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1