forecast

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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