Challenge #94: Have we reached Peak Pumpkin?

[danilang]

My solution.  Matches all categories except Bakery!

Spoiler

Dan

[kat]

@danilang finished today! :)

[danilang]

@kat Excellent!  Congratulations.  

I've still got 6 left.  See you at the top.

Dan

[kat]

@danilang thanks! and well done to you too, almost there!

[StevenBetts]

Here's my solution :)

A bit heavy handed, I feel. But got there in the end.

Spoiler

[Wouter]

my solution:

Spoiler

[JoBen]

Cheers!

[kelly_gilbert]

Whew, this one took me a few evenings and lunch breaks to work through! I'm starting to get the hang of incorporating forecast output with historical data (and also creating batch macros), though!

I couldn't figure out why I wasn't matching the solution, until I finally realized that there is a little issue in the input_macro in the provided solution (#2). The Input and Dynamic Input tools in the solution input_macro are initialized with a relative file path (..\..\externals...)
However, the Replace text in the Action tool is an absolute path (C:\Users...) Since the Replace text isn't present in the tool, nothing is being replaced, and the file path isn't being updated each time the macro runs. Therefore, the solution forecast is based on store #1's data five times.

Spoiler

I also had to look at the solution to realize that I misread the instructions - we have to replace nulls with the week's average across all stores and years (I was averaging across stores, but separate avg for each year/week).

Spoiler

OK, now my output now matches the (updated) solution workflow, but the forecast still looks weird - I'm getting negative forecasts for most products after a few months. I'm not super knowledgeable about the ETS tool, so I'll need to read up on this a little more to figure out what's going on.




My workflow:

My macro:

[pasccout]

Here is my solution... I have all the columns, the ETS methodology but the numbers go way faster down then in the solution results... can you let me know if I missed anything?

[jssandom]

Nice to learn about new tools