Results 1 to 4 of 4

Actual Vs. Forecast Cashflow with multiple Criteria

Threaded View

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    853

    Actual Vs. Forecast Cashflow with multiple Criteria

    Dear Experts,

    Please find here attached workbook, I do have very complicated situation for me and for the same i am looking your precious support. In Raw Forecast & Raw Actual tabs i do have data on daily basis with the column heading Budget Period. Now basis on the daily numbers in the Report tab i do require output in Cell D14 & F14 for Total Week, Cell L14 & N14 for Total Month, Cell T14 & V14 for Total Quarter and Cell Ab14 & AD14 for Total Year based on following criteria:

    1) Criteria at Cell B11
    2) Criteria at Cell B13
    3) Criteria at Cell B14
    4) Criteria at Cell Q3
    5) Criteria at Bank Selection Control Form Box

    And the with above i do need formula for Opening Balance for Forecast & Actuals for Total Week, Month, Quarter & Year. Dear Experts i have kept also the Form Control Button for Frequency, Please check whether is it beneficial to keep or not.

    Request to you please do help me out.

    Thank you for your precious phase and valuable support.

    Regards,

    Neilesh

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Get variance between Forecast and Actual using Pivot Table
    By juan.doe in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-04-2016, 03:13 AM
  2. forecast vs. actual
    By ammartino44 in forum Excel General
    Replies: 0
    Last Post: 03-09-2015, 01:11 PM
  3. Replies: 0
    Last Post: 08-16-2012, 01:43 PM
  4. Forecast against Actual
    By leviathan86 in forum Excel General
    Replies: 1
    Last Post: 05-23-2012, 03:02 PM
  5. Dashboard - Actual Vs Budget and Re-forecast
    By Blake 7 in forum Excel General
    Replies: 3
    Last Post: 10-05-2011, 05:36 AM
  6. How To Calculate Variance B/W Actual and Forecast Data
    By Cherish2007 in forum Excel General
    Replies: 1
    Last Post: 03-28-2007, 05:01 PM
  7. Changing Forecast Data to Actual
    By Brian Hearty via OfficeKB.com in forum Excel General
    Replies: 3
    Last Post: 01-12-2006, 04:21 AM

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