Challenge #94: Have we reached Peak Pumpkin?

[Watermark]

Spoiler

 

[Watermark]

Spoiler

oops  duplicate wrong challenge ignore

 

[duartepimentel]

Nice one. Solution Attached :)

[TonyAndriani]

Reposting under my new user ID.

[binuacs]

solution attached

[mmontgomery]

Challenge #94

[scoles0617]

My solution:

[mouna_belaid]

Please find below my solution.

[harrame]

Don't know if it's been mentioned yet but I found some issues with the 2018.2+ solution. The input macro brought in the Store01 file five times because the action tools in the input_macro need to be updated accordingly: 

Spoiler

Additionally, I wonder if it might be better to replace nulls with the average from the other stores in the same year and week instead of using the average from the other stores across all years? 

In solution:
Proposed (which I did):
Anyways, here's my solution, featuring a batch macro that performs the ETS forecasting for each product
And here's a snippet of the results I got:

[Reesetrain2]

All,

My submission:

Spoiler