Thanks for your contribution, especially for the showing how can be determined decision values with solver.

Dear Mr, I'd like to send the greatest thank to your dedication on these useful explanations about this forecasting method. I wonder where you were for these previous years, why didnt you continue, Mr?

Very nice demonstration. Thank you!

Very well explained. Thank you

Thanks for the explanation! How could I add the confidence interval's upper and lower bounds?

Good explanation. I do something similar for milking production here in COLOMBIA ! ! ! Thanks in advance!!!!

Was going to answer Alpay Dincer's question from 3 years ago, but maybe it's useful for others. Not offering a declarative answer here, just sharing my experience. Paraphrased: "What does it mean if solver gives values of 0 for the smoothing constants?" Solver can certainly give you a values of the smoothing constants at or near zero. You can check this by increasing the number of decimal places excel displays for those cells. However, if you allow unconstrained variables to be negative (by unchecking "Make Unconstrained Variables Non-Negative)", you may get a clearer picture. In my experience this can happen in one of four scenarios: (a) The overall trend is negative or almost non-existent, and needs to be smoothed that way; (b) There aren't enough data points to meaningfully plot, which is confusing solver (do a regression on the forecast and check the f test and R^2); (c) there is little or no seasonality in your data (Same check as in point (b)); or (d) some combination of the previous three. Point (c) can happen if a business isn't properly marketing or promoting their product to create a steadily increasing level of demand; they will be (in effect) subject to exogenous factors (whims of consumers, weather, retail partner sales, etc.). Anyone else have any insights or experience they can share?

Thanks for the explanation sir!

Eyvallah hocam yarın tahmin vizesi vardı. Bu arada aksan da ateş ediyor.

Thanks for this thorough walk through! If I wanted to forecast for week 21+, do I just drag and pull from formula I22 and adjust the changed value in the formula accordingly or is it a different process? Thanks!

Great video. Did you know you can use F4 instead of adding the $ individually? saves a lot of frustrations and time.

When F17 was calculated why did you use S13 and not S17 (after you calculate S17) ? For future forecasts values the formula says F(t+1) = )Lt + l*Tt) * (St+l). and what does S(in subscript (t+l)) even stand for?

Do we have to calculate Min for MAD and MAPE as we do with MSE? or min for MSE is enough? Thank you for your contribution

nice explanation..I need multiplicative seasonality so pls send any one

I missed some part of the video. Can anyone please explain if this method is useful for forecasting or should I just rely on times series forecasting.

Thnx for the presentation. But is the use of S formula correct? As I understand the formula(s) use the S from the previous period (St-p)

Hei. Thank you for the video. Please correct me if I'm wrong, the highlighted section in column 3 starts two cells after and ends two cells before the cells in column two because "p" is equal to 4. What if "p" is 7? How many cells after and before should be the highlighted area? Thank!

very clear .... can i have excel file plz..thanks

In the solver, you have mentioned only one criteria,i.e. less than equal to 1(=0). If it is less than one, it could also pick up values less than 1 i.e a negative number. Although, the criteria for Alpha, Beta and Gamma is that the values should be between 0 and 1

@ergin.ozturk

5 жыл бұрын

The checkbox just above the solving method makes them non-negative

@AnkitGupta12

4 жыл бұрын

there's an option in solver to make the unconstrainedvariables non - negativr. That is ticked.

What does that mean after solver processing alfa and gamma are equal to "0"

@scatheroy

3 жыл бұрын

Answered this - not sure if the channel operator ever got back to you, but maybe this is worth looking at after all this time? Cheers.

Please can you provide sources of formulas

what if the data is quarterly. is the procedure still the same?

Pls make more videos

The link to your website and the read up problem statement is not working. Gives 404 error.

Can you please share the excel file...not able to see the formula

Why not just use F4 for absolute values

Can we consider this model as a Decomposition method?

@founder1

4 жыл бұрын

That is correct. Decomposition is just another name for Holt-Winters Model (Trend + Seasonality). Hope that helps!

Great explanation but your formulas notations seem incorrect. It seems like you are forecasting the future based on future data. Is it that your t+1 refers to cell positioning as opposed to the actual period coding?

why s13 for F17

@joyantamitra8186

5 жыл бұрын

understood bro