projections

1. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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...

This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...