projections

  1. J

    Importing dynamic worksheets from another workbook

    Good morning everyone. Have a question.. Hope someone can help. I have a history with programming in QBASIC, but VB is... a different ballgame. Here's what I'm trying to do at present. I am trying to marry several different workbooks for my work into one very powerful and highly automated...
  2. S

    Cash Flow Projection Probabilty

    I have a years worth of Cash Flow projections for Capital projects that are based on the start and end dates of construction. Each month i have been tracking the actual's compared to what the projections were and creating a chart based on the projections and actual's. now i am being tasked...
  3. 2

    Calculating Projection Accuracy

    I'm trying to figure out 2 different sets of projections and whose projections where the most accurate. The data looks like this: Proj 1 Proj 2 Actual23 25 27 24 29 16 33 37 26 8 16 33 The...
  4. D

    Declaring variables for use in formulae

    Hello! I had posted this question on Stack Overflow, but was told that it isn't the right place for such a question. I have two sheets in Excel, one with formulae calculating business costs, and another where I'm trying to calculate revenue projections based on those costs. Images: Costs...
  5. J

    How to Fetch values from different based on the titles in the cell

    Hi Folks, I am preparing a Projections and Invoiced sheet for Invoicing. I have 2 sheets 1) Project Actuals ($) & 2) Project Projections ($). 1) What I would like to know is that - If my cell text is named as Projected under Project Actuals ($) (F3) it should be able to fetch values from...
  6. M

    Age of Queue each day based on 1 assumption

    I am trying to figure out how to automate or simplify a manual report. I was to track the age of queue of items from one day to the next based on an assumption of how many items we can get through. So for example I have 100 items currently at 58, and then 350 at day 57 and so forth. The...
  7. M

    Daily projection based on historical percentages

    I'm looking to get a formula for end of day projection for order lines based on historical percentages for each of our hourly order pulls. Below is an example: 6am pull - 100 lines (historically 50% of daily volume) 7am pull - 50 lines (historically 25% of daily volume) 8am pull - ...
  8. W

    I need help with projections

    Hello, I am totaling a value for each month of the year as and I need something to give me a projected year end value based on the numbers I enter for each month. Why doesn't hitting enter take me to a new line? Seems dumb. Anyway, for example, for January I have 42, February is 31 and March (so...
  9. R

    Projections/forecasting

    Hi all, New to mr excel and still relatively new to excel but loving it ... I'm looking to be able to get a projection or forecast value from a previous weeks data so that each week going forward always has a projection value based on previous weeks results ... Hope this makes sense? I've...
  10. M

    Contract projections help

    Hi, I'm trying to build into a spread sheet a function but am really stuck. I have a 3 year monthly projection. In each month a number of contracts occur, eg 1 new contract or 2 new contracts etc. I need to be able to select a start month and then the flow of new contracts (which has no...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top