forecast

Hello all. I am getting a bit frustrated with this one. This is a sheet used to calculated the number of laptops/desktops to procure for the next quarter. I need a formula for I4 and then I can just copy it to I5. Basically, we need to order the right number of devices and have a buffer of...

Hi I'm trying to figure out a way I can actualise some data so this is the only place to come. 1) I have forecast Sales, Forecast volume and Net Invoice value (NIV) in one table. The data is granular in that it shows the sales ID an product code. 2) In another table, I am pulling through the...

Hi guys, Not sure that title is correct, by the way I am stuck in one formula. Hopefully you can help. This is the result I am looking for: <tbody> week Month Month +1 Month -1 Forecast a 0 0 0 500 500 b 0 200 201 300 200 c 100 0 0 101 100 </tbody> Basically in "Forecast...

Hi, I am trying to use a forecast function. For it to work I need to provide a list of known x and y values. (Easy so far). The problem, I am having is that my list of x,y values contains many things I don't want to include. I want to be able to have a forecast function I can drag down that...

hi everyone, I have a sheet (which updates the forecast sheet with actuals and therefore equals TRUE if its an actual column). I am wanting to sum multiple columns based on the top of the column (row 11) being TRUE but summing all adjacent columns up to one column to the left of the last TRUE...

There are 3 columns. One is type, 2nd temp and 3rd W/m. I have to select the "w/m" at a particular "temp" of a particular "type" I may not have the Temp and W/m inputs at various values, so i have to use the forecast function in excel. I have to instruct excel to forecast the W/m of type 3BTV...

Hi guys, I am running into circles with trying to figure out this issue. I am wanting to automate our current capacity planning tool for my team and want to generate some sort of forecasting ability with the forecast formula. I have heard that the newer versions of Excel contain the forecasting...

Hi, I am trying to use the =forecast.ets function to forecast a call volume assumption for a 30 minute interval. However the forecast function is including the zeroes in the process which lessen the forecast value, what is the best way to counter that but still using the forecast function...

Hi, I have a complex dashboard that uses box plots, and other statistical formulas to come up with a forecast for how many Call Volumes are coming into the suppport center. The problem I am having is the fields below point to a 9 month calendar and when we are in the current month, the volume...

Hello, I am trying to forecast into the future using excel's automatic forecast function. It's producing negative values, when the minimum possible is 0 (as it's number of items sold). Is there anyway to fix this, or another way to forecast that might be better? Please help!

Does anyone know if this is possible? The Forecast Sheet function is very picky when it comes to only using valid data- in this case timeline MUST be in date format. This is bad news bears for pivots because if you group dates it converts them to text (strike out with Forecast) and if you...

I am working in Excel 2016 and trying to use the Forecast Sheet functionality. I need to move the forecast sheet higher to be able to access all the options that I want to change. I cannot get the forecast sheet to move.

I have values in column A for my future forecast. In columnB I have budget for that forecast. Ihave delta btw the two in Column C. Iwant to create a formula that will use conditional format preferably with iconsets instead of fill that will do the following: If deviation exceeds in...

Have 3 data series: 10-Year Actuals; Trendline, and 5-Year Forecast Trendline and Actuals are displaying correctly. I've mapped the forecast range to begin on the last actual price and then an additional five rows of prices. The forecast should then begin in 2018 and go out five years...

Hi, I have many rows of data in one sheet showing productsales by month. I would like to be able to run a macro that cycles through eachrow and creates a Forecast Sheet (Excel 2016) with specific settings (such asthe end date and showing the stats table etc). That’s the first part, just...

I have expense forecast for the whole fiscal year which I need to summarize via Pivot Table. Data is available in two different tables, "Forecast" and "Actual". How to do the following: At the start of the year, Pivot should take all data from Forecast table. However, after each month closing...

Hi, For the coming world cup, me and some friends have filled in our forecast in an excel file. Al morning i am trying to find a good way for handing out points so we can have a ranking based on the score of our forecasts. Although we are trying to keep it simple, it seems not so easy to...

Hi all, I have to consolidate sales targets from multiple countries and they have all submitted/sent me their files. The excel files they send me all look exactly the same in terms of where the numbers i need to fetch is located. For example, worksheet named "Summary" cell A1 and cell B8...

I would like to forecast the values for each X variable for each Group. There is 5 years worth of data for Groups A-D, Group E has 2 years worth of data. Regardless, I would like to forecast values for August 31, 2018. Can you do this in Powerquery or Powerpivot? I have been using the...

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