forecasting

  1. R

    Calculating values based on variables

    Using Excel 2007, I am trying to create a revenue forecast for the year based on several sets of criteria. Would like to have the spreadsheet calculate monthly payment values based on: 1. Payment options (1 payment, 2 payments, etc. through 6 payments) with established table of probability...
  2. P

    Inventory - Days On Hand Help

    Having trouble with aligning a production schedule to produce the same number of days on hand [DOH] across three packaging types. A total of 480.3 units can be produced for the three packaging types. All three packaging types have different inventory levels and daily rate of sales [DROS]. how...
  3. M

    Forecasting Accuracy in Excel

    Hi All, Need to know how to calculate forecasting accuracy in excel and which is the best way to measure forecast accuracy. Quick response will be highly appreciated. Sample Data : <colgroup><col><col><col><col></colgroup><tbody> Actual P1 Calls Forecasted P1 Calls...
  4. C

    Consolidate forecasts and actual dates into one column with a helper column

    I am looking to see how to convert raw data as shown in the 1st table and manipulating the data to display as shown in the 2nd table. Specifically, I want the dates to be in a single column with a second column marking if the date is an actual or forecast. Any help would be greatly...
  5. D

    Combine Budget and Actual Months to create "Forecast"

    Hello, I have financial data that is arranged as follows: Account Code, Actual, Jan, Feb, Mar, ....Nov, Dec, YTD, Full Year Account Code, Budget, Jan, Feb, Mar, ....Nov, Dec, YTD, Full Year There are several hundred rows for each account code. I realize this is not the best table...
  6. A

    macro to choose between different formula's

    I have two formula's available for a cell. Its actual value, and a previously forecasted value. The actual value is found using an index formula and the forecasted value is a forecast function. i want to create a macro and link it to a button such that i can change which formula used in the cell...
  7. jamwil

    I have rows of records, each w/ a start and end date. How can I compile and summarize these in a separate table, month by month

    Above I have a list of projects, each on a new row, each with a start and end date. I need to take this information and organize it into a month by month forecast, the outline of which should look something like this: Is this possible or reasonable to do? I've looked into vlookup(), match()...
  8. G

    Pharmaceutical Forecasting trending seasonality model

    Hi Everyone, I am working on a pharmaceutical inline forecasting project and need some readily available trending tool which can trend on monthly level considering different trends (best fit should be selected automatically) and historical seasonality. I have created one and want to share with...
  9. K

    Changing Calendar -- Too complicated for me!

    Hi there, I have a complicated excel problem, which I want to solve with formulas if possible. Basically, it's a forecasting tool that changes based on different launch dates. For example: Launch Date is April 2013, and the quantity in that month is a percentage of the total market (say 50)...
  10. H

    Forecasting Average Monthly Growth Rates

    Hi there, I have a simple forecasting query that I'm struggling to solve. Hoping you can help! I wish to forecast a target monthly growth rate, based on 12 months worth of data, for example: Date|Visits Dec-11|1000 Jan-12|1200 Feb-12|900 Mar-12|800 Apr-12|900 May-12|1000 Jun-12|720 Jul-12|450...
  11. 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...
  12. J

    Help on calculating payroll taxes

    Hi I need help on writing this formula, never posted here but I am hoping someone can help. I have a model with changing payroll data and have made a tab of forecasted cumulative payroll. I want to forecast the different payroll taxes a business will incur in 2013. For example FUTA tax is only...
  13. andrewb90

    General Data Forecasting

    Hello All, I have started trying to do 10 -12 year forecasting model for my business. I tried using some various equations but none of them have given me what I am looking for. Starting in 2013 through 2018 I will be opening 30 new stores. 5 one year and six the next. so 2013 - 5, 2014 -6, 2015...
  14. A

    Seasonailty and Target Average Discounts

    Hi all Im not sure if this is a basic math question but I'm scratching my head over it. Basically, I have been given some data relating to the seasonality of sales discounts to mess around with. I have managed to calculate the average discount for the year based on those trends without any...
  15. R

    Find out which month purchases are 1st forecast

    Hi, I’m trying to work out which month a forecast is first made. Probably need to explain a bit more. I have a list of purchases along the left, 12 months along the top and then the various cost in the middle followed with a total at the end. I’m trying to work out which is first month the...
  16. F

    Conditional formatting based on the specific TYPE of formula in a cell (e.g. flat-lining versus summing)

    It seems to be commonly known that the Get.Cell function can be used to format (shade) cells conditionally based on whether they contain a formula or just a value (explained here: http://j-walk.com/ss/excel/usertips/tip045.htm). Can anybody figure out how to take this one step further and...
  17. T

    Calculate a trendline forecast

    Hello, This is my first post. I found an article on Microsoft Office Online from MrExcel about calculating a forecast for Sales based on historical data. I tried this LINEST formula by selecting two cells side by side and entering the =linest(c2:c35) etc. This formula does not seem to work for...
  18. A

    Intermittent Forecasting

    This is a unique problem I have never encountered and I wanted to see if I could get some thoughts. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am working on 5-year monthly projections in a clinical trial environment. Each trial will have different...

Some videos you may like

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