Challenge #94: Have we reached Peak Pumpkin?

[rachel_lynch]

Spoiler

 

[ed_hayter]

Really fun challenge from using a list of sheets and dynamic input to making an iterative macro to run the two time series on each category and comparing the parameter score. Then thanks to @JamesCharnley I was made aware of the TS Factory Tool downloadable that ran the time series across groups.

Spoiler

[gawa]

done

[mithily]

Spoiler

will need to redo

[daiphuongngo]

Spoiler

 

[Hammad_Rashid]

[RWvanLeeuwen]

This has been awesome to revisit!

I tried to build a very dynamic process, but ultimately decided it would be best to work with 1 family of forecast models instead of pooling all of them.

here's my take

Spoiler

ARIMA for the win (ETS fails miserably somehow)the first step was to ensure all files and all sheets are loaded in appropriately, so I built a few macros that allow schema changes, and they work as long as the files are in the same directory as the workflow

[Rob-Silk]

My solution below:

Spoiler

[IgnacioVilaplana]

Please find attached my solution. I used the TS Factory model and forecast tools to simplify the model creation process.

Spoiler

 

[olga_strubbe]

Thank you, @ChristineB!

I don't have R-tool functionality, so my TS Forecast macro errored out, but I was able to follow the logic from the solution provided. 

I leveraged the macros from the solution provided in lieu of my R-tool errors.