Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Spoiler
I've tried both TS Factory (another tool learnt!) and a batch macro solution but am still getting slightly different numbers in both solutions
My Effort. Arima gave lower AICC's, so went with that. Used a macro to apply the model top each product. Everything looks OK except produce, which varies wildly from the answer
Spoiler
There weren't any NULL's. Didn't need to put in averages for those. Wildcard .xlsx input is the best input method here.
There weren't any NULL's. Didn't need to put in averages for those. Wildcard .xlsx input is the best input method here. 
Spoiler
I went with an iterative macro approach, creating a 52-week forecast for each variable one at a time.
