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\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_1ff155c7b67144d99ddcb485ba049291_.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\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_3bae74c746914002b50241ab74a6bd75_.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
Calc month average
Calc year average
Error
Error
Replace units if null
units_adj = if isnull([Units]) then
if isnull([month_avg_units]) then
[...
unit_fcst
units_adj
False
"Product", "Fiscal Year", "Fiscal Month", "Fiscal Week Number", "Units", "month_avg_units", "year_avg_units", "units_adj"
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
100
True
False
False
True
5.00
5.50
False
13.00
14.95
1x
10
Model
C:\Users\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_7547c7fd109f4ef5b9cccb54851014ae_.yxdb
Single
Report
C:\Users\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_84051a39dc6741bcbfa59f3e44ab00e9_.yxdb
Single
Report
forecast
95
80
6
True
5.50
5.50
False
13.00
14.95
1x
10
Forecast
C:\Users\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_681356bb4a69484994aac181fc27b41b_.yxdb
C:\Users\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_cf0ca0ea1e38413597fa9617636b7ba9_.yxdb
C:\Users\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_42e551efa5e44820910b31be614505b5_.yxdb
Check Results
Warn
Transpose solution
Warn
Transpose my results
C:\Users\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_afb66e4fab9b427099764d4199990372_.yxdb
Single
Profile
In solution, not in my results (should be nothing)
C:\Users\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_2515a38d45594c298bb9fb81d6cbb19f_.yxdb
Single
Profile
In my results, not in solution (should be nothing)
round([Value],6) = round([Right_Value],6)
Custom
Values match?
round([Value],6) = round([Right_Value],6)
C:\Users\KELLY~1.GIL\AppData\Local\Temp\Engine_20060_3b9e2c3472254c22a97f5bc176aa4a5f_\Engine_16460_67361c957a554102a9b0b8df222a1812_.yxdb
Single
Profile
(should be nothing)
My results don't match these results, but they do match the results in the challenge_24_solution.yxmd file
Horizontal
challenge_24_solution_klg