Challenge #94: Have we reached Peak Pumpkin?

[rachel_lynch]

スポイラ

 

[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.

スポイラ

[gawa]

done

[mithily]

スポイラ

will need to redo

[daiphuongngo]

スポイラ

 

[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

スポイラ

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:

スポイラ

[IgnacioVilaplana]

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

スポイラ

 

[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.