forecast

Hello, can someone please help with this... I'm trying to get excel to IF function to return to words to W and L without having to manually type it in. Here is an example below. The forecast means, +16 play the over to win and -11 means play the under to win. basically any plus symbol play over...

Hello Reader's, Our financial year runs from Jan-19 to Dec-19. Currently we are in May-19 period therefore we have finalized actual sales data for the period Jan-19 to Apr-19 period. I need help to construct a Quarter to date formula. For example in below data: I need a formula that will...

Hello, I am building forecast model and want to be able to forecast with formula inexcel, hard code or a formula in a macro. The spreadsheet it set up sothe user can update it with a hard coded number or enter a formula. However, I would also like to be able to adda macro that will overwrite...

Hello, I am building forecast model and want to be able to forecast with formula inexcel, hard code or a formula in a macro. The spreadsheet it set up sothe user can update it with a hard coded number or enter a formula. However, I would also like to be able to adda macro that will overwrite...

Hi all, I've got the following formula combining an index match with a sumif, but it's returning the wrong result. The goal is to sum all the values that equal what is in C8 that match column A on the Niagara Summary page, and then sum the values based on the index match criteria below. The...

Hello all, new to the forum. I have an issue with powerpivot/DAX that I have not been able to solve. I hope someone is up for the challenge... The problem is calculating a YTD monthly Inventory closing position while ignoring cumulative negatives if there is no stock to satisfy the forecast...

Hi Guys! I'm getting frustrated with my indolence in solving the following problem. Hope some smart good people can help me :) I have a spreadsheet in which I add project actual and forecast cost on monthly basis. There is around 500 different projects which, obviously, have different duration...

Hi All, Im building automatic order point but hit some wall :( Maybe anyone here is happy to help :confused: ? I have managed to calculate weeks of cover but I want to now add formula with allow me to : -if weeks of cover lower then 3 place an order -calculate quantity for "planned orders" to...

Hi All, Im trying to resolve below issue form a while. Currently im trying to build forecast vs stock calculations to show me weeks of cover. Im not looking for average but to calculate in Wk2 i have stock enough for ... weeks with the forecast value as .... Also include negative stock (to be...

Hi guys, I am new to excel and can use some help. I have a table that tracks frequency counts, by date, for client behavior occurrences. So, in column A, I have all the dates for 2018, in column B, C, D, etc...are the different behaviors where I have the counts for each behavior, each day...

Hi I am trying to track paint consumption. I have 50 gallon drums in which a machine consumes at different rates until empty. I log down the gallons used per day. I have 2 to 4 drums on hand at time. I need to chart this information and have the chart forecast on when the 4 drums will be done...

Good Afternoon All, I've got a set of resource usage graphs over time built in Excel. Every week, I go in and update actuals through the current period, and also update my forecast for all future periods. So for example: week 5 - weekly actuals are in columns A through E, and weekly forecast...

Hi There, I'm looking for some assistance with a formula I've been stewing over for a couple of days now and would appreciate some assistance. I am putting together a spreadsheet to help with forecasting where I have an input template that will feed a formulated forecasting vs. actual calc...

actuals sum 135 3254 KEUR customer a 110 KG 2092 KEUR custmer b 21 kg 974 KEUR customer c 4 KG 188 keUR forcast sum 147 3377 KEUR customer a 106 KG 1993 KEUR customer b 27 KG 736 KEUR customer c 14 KG...

Hi all, I have been given a piece of work to carry on which I am more than happy to do however, there is an element within that has me confused as it just doesn't look or feel right. So the data is laid out like this and is manually updated through templates sent in. <tbody> Value of Batch...

<colgroup><col><col><col><col><col></colgroup><tbody> Can you please suggest to transpose this data in excel Actual Published Forecast ZDP ZST ZMAT Expected Published Forecast ZDP Published Forecast ZST Published Forecast ZMAT </tbody> Thanks in...

Hello all, I hope someone can assist in this - and thanks in advance. I hope I can explain this without much confusion. I have a sample survey size of 1,120. 60 people out of 1,120 responses are reporting site errors (so 5% of the population is reporting site errors). It is assumed that these...

I'm attempting to forecast the sales for the last three periods of a restaurant. Given the way the sales vary overall, using a seasonal forecast sounds appropriate as I have last year's data. But, I'm open to other suggestions. I've come across the forecast.ets function. But, to say the...

Is there an easy way to change this. Currently my data is in the following format: PartNumber Description Jan Feb Mar ETC. The forecast is under each month currently. I will prefer to have the data like the format below PartNumber Month Description Forecast.

Good evening, I need some help as I cannot find anything relevant on Google or the forum. Here is my situation: January 1st 2019, I'll open a new business; I plan on signing 5,000 users the 1st month (A2=5,000) have accumulated 500,000 users by end of December 2019 (L2=500,000) reach...