Input
Output
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
Weekly Challenge #24
Use Case: A retailer would like to forecast how many units of a particular product will be purchased from their locations based on a historical trend.
The source data contains weekly data for 2012 and 2013 details how many units have been moved. Some of the data, however, is populated with NULL values. For the NULL values, please assign the monthly average. If the monthly average is also NULL, assigned the annual average.
Objective: Forecast the number of units that will be sole in the six weeks following the available data.
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_896073c0fb4f4400aa7cca4d64744f50_.yxdb
Single
Profile
3
1
334.738227235981
466.538870124894
420.9180354194
248.558419052561
202.937584347067
3
2
293.126437836262
458.114318864577
401.006214656417
185.246661016106
128.138556807947
3
3
261.793005511522
442.916500671652
380.223293317982
143.362717705063
80.6695103513928
3
4
238.199115524766
427.862652462762
362.213436505595
114.184794543937
48.5355785867698
3
5
220.433055332642
414.772150701645
347.504559646592
93.361551018693
26.0939599636397
3
6
207.055316649986
403.996148338425
335.828004903848
78.2826283961243
10.1144849615482
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_39f7cf3c4c8f48c990abd34fcee234d2_.yxdb
Single
Profile
Widget
2012
2012-01
81
Widget
2012
2012-02
51
Widget
2012
2012-03
52
Widget
2012
2012-04
72
Widget
2012
2012-05
85
Widget
2012
2012-06
74
Widget
2012
2012-07
104
Widget
2012
2012-08
126
Widget
2012
2012-09
139
Widget
2012
2012-10
149
Widget
2012
2012-11
192
Widget
2012
2012-12
224
Widget
2012
2012-13
255
Widget
2012
2012-14
Widget
2012
2012-15
209
Widget
2012
2012-16
262
Widget
2012
2012-17
217
Widget
2012
2012-18
247
Widget
2012
2012-19
231
Widget
2012
2012-20
247
Widget
2012
2012-21
226
Widget
2012
2012-22
236
Widget
2012
2012-23
250
Widget
2012
2012-24
482
Widget
2012
2012-25
303
Widget
2012
2012-26
222
Widget
2012
2012-27
208
Widget
2012
2012-28
Widget
2012
2012-29
209
Widget
2012
2012-30
174
Widget
2012
2012-31
Widget
2012
2012-32
154
Widget
2012
2012-33
185
Widget
2012
2012-34
159
Widget
2012
2012-35
127
Widget
2012
2012-36
124
Widget
2012
2012-37
100
Widget
2012
2012-38
116
Widget
2012
2012-39
104
Widget
2012
2012-40
Widget
2012
2012-41
101
Widget
2012
2012-42
71
Widget
2012
2012-43
53
Widget
2012
2012-44
61
Widget
2012
2012-45
55
Widget
2012
2012-46
48
Widget
2012
2012-47
91
Widget
2012
2012-48
75
Widget
2012
2012-49
167
Widget
2012
2012-50
261
Widget
2012
2012-51
512
Widget
2012
2012-52
258
Widget
2013
2013-01
95
Widget
2013
2013-02
50
Widget
2013
2013-03
60
Widget
2013
2013-04
65
Widget
2013
2013-05
93
Widget
2013
2013-06
126
Widget
2013
2013-07
129
Widget
2013
2013-08
90
Widget
2013
2013-09
103
Widget
2013
2013-10
101
Widget
2013
2013-11
124
Widget
2013
2013-12
120
Widget
2013
2013-13
166
Widget
2013
2013-14
152
Widget
2013
2013-15
Widget
2013
2013-16
238
Widget
2013
2013-17
Widget
2013
2013-18
Widget
2013
2013-19
Widget
2013
2013-20
Widget
2013
2013-21
Widget
2013
2013-22
Widget
2013
2013-23
254
Widget
2013
2013-24
425
Widget
2013
2013-25
299
Widget
2013
2013-26
Widget
2013
2013-27
Widget
2013
2013-28
160
Widget
2013
2013-29
163
Widget
2013
2013-30
Widget
2013
2013-31
152
Widget
2013
2013-32
168
Widget
2013
2013-33
Widget
2013
2013-34
140
Widget
2013
2013-35
119
Widget
2013
2013-36
135
Widget
2013
2013-37
111
Widget
2013
2013-38
79
Widget
2013
2013-39
72
Widget
2013
2013-40
Widget
2013
2013-41
67
Widget
2013
2013-42
61
Widget
2013
2013-43
50
Widget
2013
2013-44
41
Widget
2013
2013-45
44
Widget
2013
2013-46
Widget
2013
2013-47
62
Widget
2013
2013-48
122
Widget
2013
2013-49
158
Widget
2013
2013-50
295
Widget
2013
2013-51
541
Widget
2013
2013-52
390
Simple
IsNotNull
Units
True
fixed
2023-04-09 11:37:29
0
2023-04-09 11:37:29
2023-04-09 11:37:29
!IsNull([Units])
Warning
All
ByName
Fiscal Week Number - Ascending
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_487f51bc4dfb455db669d9ba1688b437_.yxdb
Single
Profile
Forecast2
Units
False
"Product", "Fiscal Year", "Fiscal Month", "Fiscal Week Number", "Units"
True
False
False
False
False
True
False
False
False
False
False
False
0
2
2
False
0
1
1
False
True
False
False
5
False
True
False
0.00
False
0
0
0
0
0
0
False
False
0.00
False
1980
1
6
True
False
False
True
5.00
5.50
False
13.00
14.95
1x
10
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_309671992c3d468da18dfc5b50466e1b_.yxdb
Single
Report
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_bd726119478341ab963d3348f1960140_.yxdb
Single
Report
forecast
95
80
6
True
5.50
5.50
False
13.00
14.95
1x
10
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_762993aab3fe486c8277492669d6c463_.yxdb
Single
Report
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_29bb3e3d7b9144e5be94151ddae8bd04_.yxdb
Single
Report
Container 120
Forecast
Units
False
False
False
True
False
False
False
False
True
False
False
True
False
False
False
True
False
False
True
False
False
False
True
False
False
False
False
0.00
False
2012
1
6
True
False
False
True
5.50
5.50
False
13.00
14.95
1x
10
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_1e651da1ee5c45059e5ef3439ce9bf24_.yxdb
Single
Profile
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_e5c2fed154674862bd8133195c097ac5_.yxdb
Single
Report
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_9333aa2a8f8e4dd1b367124aa358cdb8_.yxdb
Single
Report
forecast
95
80
6
True
5.50
5.50
False
13.00
14.95
1x
10
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_f847b3ef2c8b4fda80000f4295d6598e_.yxdb
Single
Profile
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_5342d26ae7ff4375b2ae2bd9b9f7f444_.yxdb
Single
Report
C:\Users\DTSUCH~1\AppData\Local\Temp\Engine_21900_c6a28aa903004f0fbdcd8db05cdc952d_\Engine_10060_fe943ab9b4964f81a0761d4ccfbac8ab_.yxdb
Single
Report
Horizontal
challenge_24_start_file_DT