Check output is as expected
Link to Item Demands file
Find nearest warehouse for each store
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 #15
1
467764.31807845
2
520950.356459252
3
418529.43408498
4
471483.324599005
5
613089.857981943
6
338432.74381217
7
654162.976293154
8
465070.542812818
9
385441.880195139
10
385761.522224907
C:\Users\Mike\AppData\Local\Temp\Engine_18172_e7ea82fb37c74453ad398ddfd33f7923_\Engine_10688_f3bfac6e87d8465696d9955b7b0b95be_.yxdb
Single
Profile
A
26
Houston
TX
-95.562207
29.839187
B
4
Birmingham
AL
-86.625591
33.410321
C
25
Seattle
WA
-122.291399
47.603993
D
3
Detroit
MI
-83.255088
42.412144
E
5
Nashville
TN
-86.729174
36.135464
F
2
Chicago
IL
-87.597287
41.734
G
24
Lansing
IA
-91.228717
43.361018
H
1
Fayetteville
NC
-78.907738
35.024302
I
23
Miami
FL
-80.31047
25.792304
J
22
Tampa
FL
-82.539427
27.886595
K
21
Charleston
SC
-80.063175
32.931254
L
6
Los Angeles
CA
-118.386826
33.945722
M
20
Sacramento
CA
-121.40379
38.568865
N
7
Tucson
AZ
-110.845502
32.311728
O
8
Dallas
TX
-96.770293
32.84673
P
19
Austin
TX
-97.713678
30.19727
Q
9
Tulsa
OK
-95.861086
36.177745
R
16
New York
NY
-74.002527
40.734408
S
10
Baltimore
MD
-76.467296
39.3277
T
15
Portland
OR
-122.889658
45.563461
U
11
Philadelphia
PA
-75.171584
39.955317
V
12
Boston
MA
-71.066428
42.315352
W
13
Helena
MT
-112.00339
46.593143
X
14
Denver
CO
-104.943955
39.709101
Y
18
Milwaukee
WI
-87.925026
42.96156
Z
17
Las Vegas
NV
-115.242869
36.177034
Stores
C:\Users\Mike\AppData\Local\Temp\Engine_18172_e7ea82fb37c74453ad398ddfd33f7923_\Engine_10688_16bd35f8fbc845b3bccb1f2799069e89_.yxdb
Single
Profile
C:\Users\Mike\AppData\Local\Temp\Engine_18172_e7ea82fb37c74453ad398ddfd33f7923_\Engine_10688_ee6b75b016614adf8acc2c27f64e7a39_.yxdb
Single
Profile
A
1
47
47
A
2
29
29
A
3
50
50
A
4
12
12
A
5
19
19
A
6
72
0
A
7
71
13
A
8
2
0
A
10
40
40
B
2
46
46
B
3
36
36
B
4
7
7
B
5
48
48
B
6
71
71
B
7
19
19
B
10
4
4
C
1
34
34
C
2
52
52
C
3
66
66
C
4
17
17
C
6
3
2
C
7
57
57
C
8
77
64
C
10
13
13
D
2
1
1
D
3
76
76
D
4
46
46
D
6
21
21
D
7
40
40
D
10
41
41
E
1
44
44
E
2
14
14
E
5
75
75
E
6
32
32
E
7
14
14
E
8
76
76
E
10
42
42
F
1
71
71
F
2
28
28
F
3
46
46
F
4
54
54
F
5
9
9
F
6
52
52
F
7
43
43
F
8
33
33
F
9
59
59
F
10
16
16
G
1
60
60
G
2
2
2
G
3
51
51
G
4
66
66
G
5
47
47
G
6
28
28
G
7
66
66
G
9
30
0
G
10
55
55
H
1
11
11
H
2
69
69
H
3
5
5
H
4
41
41
H
5
54
54
H
7
28
28
H
8
57
57
H
9
17
17
H
10
36
36
I
2
6
6
I
4
73
73
I
5
43
43
I
6
3
3
I
7
70
70
I
8
70
70
I
9
16
0
I
10
17
17
J
1
71
71
J
2
35
35
J
4
5
5
J
5
79
79
J
6
9
9
J
7
38
38
J
9
55
21
J
10
72
72
K
1
44
44
K
2
13
13
K
3
63
63
K
4
73
73
K
6
62
62
K
7
61
61
K
8
20
20
K
10
25
25
L
1
26
26
L
3
10
10
L
4
35
35
L
5
62
62
L
6
16
16
L
7
73
73
L
8
35
35
L
9
78
78
L
10
33
33
M
2
12
12
M
3
23
23
M
4
55
55
M
5
46
46
M
6
9
9
M
7
4
4
M
8
8
8
M
9
76
76
M
10
60
60
N
2
9
9
N
4
29
29
N
5
12
12
N
6
4
4
N
7
36
36
N
8
3
3
N
10
8
8
O
1
15
15
O
2
35
35
O
5
30
30
O
6
43
43
O
8
78
78
O
9
48
48
O
10
64
64
P
2
60
60
P
3
33
33
P
4
5
5
P
5
9
9
P
6
27
27
P
7
62
62
P
8
71
71
P
9
30
30
P
10
50
50
Q
2
22
22
Q
3
32
32
Q
4
11
11
Q
5
4
4
Q
6
46
46
Q
7
69
69
Q
8
46
46
Q
9
12
12
Q
10
53
53
R
2
76
76
R
3
15
15
R
4
13
13
R
5
69
69
R
6
41
41
R
7
49
49
R
8
50
50
R
10
9
9
S
1
23
23
S
2
9
9
S
4
27
27
S
5
31
31
S
6
31
31
S
7
17
17
S
8
69
69
S
9
53
53
S
10
21
21
T
1
19
19
T
2
66
66
T
3
76
76
T
4
56
56
T
5
78
78
T
6
53
53
T
7
62
62
T
8
2
2
T
9
12
12
U
1
71
71
U
2
54
54
U
4
3
3
U
5
54
54
U
6
3
3
U
7
48
48
U
8
6
6
V
1
65
65
V
2
30
30
V
3
4
4
V
4
12
12
V
5
50
50
V
7
37
37
V
8
10
10
V
9
76
76
W
1
76
76
W
2
68
68
W
3
10
10
W
4
48
48
W
5
65
65
W
7
60
60
W
8
15
15
W
9
31
31
X
1
8
8
X
2
49
49
X
3
57
57
X
4
23
23
X
5
25
25
X
7
39
39
X
8
45
45
X
9
68
68
Y
1
6
6
Y
2
47
47
Y
4
1
1
Y
5
26
26
Y
6
64
64
Y
7
33
33
Y
8
41
41
Y
9
33
33
Y
10
7
7
Z
1
60
60
Z
2
25
25
Z
3
39
39
Z
4
45
45
Z
5
75
75
Z
6
18
18
Z
7
18
18
Z
8
25
25
Z
9
2
2
Z
10
10
10
Item Demands
Main
Huntsville
AL
34.737177
-86.603266
Second
El Paso
TX
31.767002
-106.492058
Third
Colorado Springs
CO
38.825775
-104.831478
Warehouses
C:\Users\Mike\AppData\Local\Temp\Engine_18172_e7ea82fb37c74453ad398ddfd33f7923_\Engine_10688_bebd0904eb854a2b96da8c38bf4b7a92_.yxdb
Single
Profile
Double
Double
Miles
Latest
Store
Store
City
FindWhole
Append
C:\Users\Mike\AppData\Local\Temp\Engine_18172_e7ea82fb37c74453ad398ddfd33f7923_\Engine_10688_0b96c538544f44099332d0c925e568cd_.yxdb
Single
Profile
Horizontal
challenge_15_soln_MikeLR