forecast

  1. A

    VBA to Transpose Data and Loop

    Hello Excel Gurus, I'm trying to write a code that will transform my data from singular columns to multiple rows. My data is currently organized like this; <tbody> Index Budget View 1/1/2018 2/1/2018 3/1/2018 4/1/2018 123 Budget $10.00 $10.00 $10.00 $10.00 123 Forecast $10.00 $0.00 $5.00...
  2. M

    Power Pivot - Calculate the variance between columns when using column headers

    Hi, New to using Power Pivots, however I don't think this is necessarily a beginner problem. I am trying to calculate the variances in my power pivot between two columns which contains forecast values, under the header of Month (when the forecast is applicable) and the subset of Forecast...
  3. S

    Simple Function

    I call this function to calculate current months of coverage. It compares 1 column (Inventory ) to a range of cells ( future forecast ) and give me a current month's of coverage: Function coverage(inventory, forecast) Application.Volatile For Each c In forecast inventory = inventory -...
  4. S

    Forecasting Accuracy Model

    Hi all, First time posting so apologies if I'm not overly clear. I've been set a task that is bending my brain a little bit - The document has 3 tabs - Historical Calls, Forecast Calls, Accuracy -Historical Calls - actual data -Forecast Calls - historical data which is either like for like...
  5. T

    Linear Regression

    I have two data points in my data, a and b and I am trying to forecast point c. Assuming a linear relationship, surely point c would be: (b-a) + a However if I use Excel's linear forecast function in the graph, I get an equation that does not give me the same figure. In my data, a =...
  6. D

    Linear Forecasting with criteria

    Hi everyone, First time posting here, so sorry if the explanation/format of my question is unclear. I'm trying to use the FORECAST.LINEAR function to come up with a very basic forecast for a product based off its Week 1 Sales. The sheet is set up as follows: <tbody> Product Name Sales...
  7. V

    Sum different multiple columns based on Month Selected

    Good Morning, I have a spreadsheet with the months of the year starting from column C with forecast values in the hundreds of rows below. I am looking for a formula that, if I select the current month in a drop down box, it will sum the next 3, 6 and 9 months totals automatically without...
  8. P

    Extracting data from a P&L depending on date in the drop down list

    Hi all, I want to extract data from my P&L budget and forecast (on different tabs in excel) based on a date I select from my drop down list. I basically want to do a variance analysis between the budget and forecast P&L. Both my budget and forecast income statement look like the below in terms...
  9. A

    Power pivot display calculated columns for each month

    Hello, I have a power pivot model with budget table, forecast table and keys table. Forecast table columns: Data Type, Manager Name, Client Name, Period, Amount, Month, Year, Key (Manager A_Client A_Month_Year) Example of table row: "Forecast", "Manager A", "Client A", Jan-17, 100, 1,2017...
  10. M

    Multiple filter help

    I need to apply two different filters to a measure. I can do them individually but cannot figure out how to combine them. I want to get total pounds of linen per month. For a table "Forecast" <tbody> Start Date Member Linen Type Activity Weight Linen Group Feb 22, 2019 Member A...
  11. B

    Please help on a forecast excel formula

    Dear I am trying to apply forecast formula on income statement and cash flow. I have known amounts for 2 years 2016 and 2017 and for 2018 and 2019 i entered zero values. I need to forecast the amount of sales for the 5th year 2020 up to 2023. In 2016 and 2017 there are positive sales...
  12. B

    Help over Forecast formula

    Dear I am trying to apply forecast formula on income statement and cash flow. I have known amounts for 2 years 2016 and 2017 and for 2018 and 2019 i entered zero values. I need to forecast the amount of sales for the 5th year 2020 up to 2023. In 2016 and 2017 there are positive sales value...
  13. M

    Pivot Charts resetting when i change filters through slicers, how to workaround?

    Hello MrExcel. I have a dataset of 70k rows and 40 columns describing 40 different entities, which i am analyzing through a pivot table. I am trying to make a dashboard where i can describe and compare whichever entities i want through a slicer controlling multiple pivots. However, for...
  14. A

    searching when extra spaces exists in value

    I am using vba to search for searching for certain key words/phrases in excel spreadsheets. Sometimes a phrase may have extra spaces in between words i.e. "Forecast O&A $ per Unit" When I search i use "Forecast O&A $ per Unit" (only one space between each word). In my spreadsheet...
  15. O

    Forecasting with several conditions

    Hello, I'm trying to forecast values along down a table. I have already used Forecast (Linear) formula without a problem, but now I need several conditions to be met. This is what I have so far: {FORECAST.LINEAR([@Date];AND(IF([Date]>=([@[Date]]-5); [Score];"");IF([Date]<[@[Date]]...
  16. J

    Pivot Table Help Please: Calculating ‘% Achieved Cumulative’ in a pivot table

    Please could someone help me with how to approach calculating ‘% Achieved Cumulative’ in a pivot table? Have search online without success. I am trying to create a Actuals vs. Forecast pivot table to show the following metrics: Actual value for month Cumulative Actual YTD Forecast value for...
  17. J

    VBA Pulling data into sheet from closed workbooks

    Hello, in the second macro - forecast_day_2, it does not pull the values. the forecast_day_1 it returns them all - is there any obvious errors with this pulling of values into my spreadsheet? Many thanks Dim myvalue3 As Variant Dim destcell As Range, r As Long Dim fileSpec As String...
  18. J

    VBA Import from Closed Workbooks: Condensing Needed

    Please help, I need to condense the below and also to ignore if the file cannot be found: Many thanks! Sub Forecast_AllDays() Dim destcell As Range, r As Long Dim fileSpec As String, folderPath As String, fileName As String FD =...
  19. A

    Cumulative sales Forecast Formula

    I have a year end sale figure of £80,000 and want to divide this between 12 months in way that starts from Jan to Dec, and the Jan Sale not to be less than £4,000 and each month the sale increase slightly with a few fluctuations in Sep, Feb and March when there is seasonality and the sales are...
  20. J

    VBA Pull Data from Closed Workbooks

    Hello, I have the following code which successfully pulls data from closed workbooks. Is it possible to edit it so if it does not find a file stored in the folder then it ignores it? Many thanks. Sub Forecast_Weekends() Dim destcell As Range, r As Long Dim fileSpec As String...

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