Spreadsheet: 110016d1306826573-how-to-autofill-planner-sheet
Sheet: Sheet1

 |  |  | [NAME] available |  |  |  |  |  |  | 1700
Customer Code | Customer Name | Total order Volume | DIRECTION |  |  |  |  |  |  |  | Key | Un dispatched volume | Aggregated Volume - Clubbed orders |  | Un Dispatched Volume | Next | Key
1137 | a | 591.7248794811128 | L-S |  |  |  |  |  |  |  | L-S |  | 591.7248794811128 |  |  | 7 |  | Mark
1139 | b | 585.573531906082 | L-S |  |  |  |  |  |  |  | L-S |  | 1177.298411387195 |  |  | 8 |  | Mark
1141 | c | 186.4737999709938 | L-S |  |  |  |  |  |  |  | L-S |  | 1363.772211358189 |  |  | 21 |  | Mark
1150 | d | 230.5003663073879 | L-NW |  |  |  |  |  |  |  | L-NW |  | 230.5003663073879 |  |  | 0 |  | 0
1164 | e | 588.1174863532763 | U-W |  |  |  |  |  |  |  | U-W |  | 588.1174863532763 |  |  | 0 |  | 0
1169 | f | 860.3538510190904 | U-W |  |  |  |  |  |  |  | U-W |  | 1448.471337372367 |  |  | 0 |  | 0
1174 | g | 291.0769536309245 | L-W |  |  |  |  |  |  |  | L-W |  | 291.0769536309245 |  |  | 0 |  | 0
1176 | h | 742.2931176996285 | L-NW |  |  |  |  |  |  |  | L-NW |  | 972.7934840070164 |  |  | 0 |  | 0
1178 | i | 452.5273068787218 | U-W |  |  |  |  |  |  |  | U-W |  | 1900.998644251089 |  |  | 0 |  | 0
1217 | j | 373.1153902855456 | U-W |  |  |  |  |  |  |  | U-W |  | 2274.114034536634 |  |  | 0 |  | 0
1229 | k | 205.8860366897564 | U-S |  |  |  |  |  |  |  | U-S |  | 205.8860366897564 |  |  | 0 |  | 0
3309 | l | 497.6590937292736 | L-E |  |  |  |  |  |  |  | L-E |  | 497.6590937292736 |  |  | 0 |  | 0
5427 | m | 635.2841463611848 | L-E |  |  |  |  |  |  |  | L-E |  | 1132.943240090458 |  |  | 0 |  | 0
8967 | n | 192.7074102016737 | L-E |  |  |  |  |  |  |  | L-E |  | 1325.650650292132 |  |  | 0 |  | 0
9478 | o | 79.85063076696817 | L-N |  |  |  |  |  |  |  | L-N |  | 79.85063076696817 |  |  | 0 |  | 0
9612 | p | 332.4014387836769 | L-S |  |  |  |  |  |  |  | L-S |  | 1696.173650141865 |  |  | 22 | L-S | Mark
10228 | q | 310.4042245781633 | L-S |  |  |  |  |  |  |  | L-S |  | 2006.577874720029 |  |  | 23 | L-S
10390 | r | 319.1315679284679 | L-S |  |  |  |  |  |  |  | L-S |  | 2325.709442648497 |  |  | 32 | L-S
10424 | s | 217.3566657549354 | U-SW |  |  |  |  |  |  |  | U-SW |  | 217.3566657549354 |  |  | 0 |  | 0
10524 | t | 228.8016741594107 | L-W |  |  |  |  |  |  |  | L-W |  | 519.8786277903353 |  |  | 0 |  | 0
11062 | u | 293.0051484593381 | U-N |  |  |  |  |  |  |  | U-N |  | 293.0051484593381 |  |  | 0 |  | 0
11187 | v | 569.786914229303 | L-NW |  |  |  |  |  |  |  | L-NW |  | 1542.58039823632 |  |  | 0 |  | 0
14503 | x | 260.8883216194189 | L-SW |  |  |  |  |  |  |  | L-SW |  | 260.8883216194189 |  |  | 0 |  | 0
15077 | y | 922.9128728832359 | L-E |  |  |  |  |  |  |  | L-E |  | 2248.563523175368 |  |  | 0 |  | 0
15323 | z | 186.075275119195 | U-W |  |  |  |  |  |  |  | U-W |  | 2460.189309655829 |  |  | 0 |  | 0
15931 | aa | 38.93814668981484 | U-SW |  |  |  |  |  |  |  | U-SW |  | 256.2948124447503 |  |  | 0 |  | 0
16062 | bb | 1265.10069351888 | L-S |  |  |  |  |  |  |  | L-S |  | 3590.810136167377 |  |  | 34 | L-S
16172 | cc | 681.7721027447192 | L-SE |  |  |  |  |  |  |  | L-SE |  | 681.7721027447192 |  |  | 0 |  | 0
16612 | dd | 247.7993246979836 | L-S |  |  |  |  |  |  |  | L-S |  | 3838.609460865361 |  |  | 35 | L-S
16660 | ee | 479.0118609061184 | L-S |  |  |  |  |  |  |  | L-S |  | 4317.621321771479 |  |  | 37 | L-S
17040 | ff | 339.4784874936946 | U-W |  |  |  |  |  |  |  | U-W |  | 2799.667797149523 |  |  | 0 |  | 0
17087 | gg | 262.3730951983065 | L-S |  |  |  |  |  |  |  | L-S |  | 4579.994416969786 |  |  | 0 | L-S
17120 | hh | 475.5569370932478 | L-W |  |  |  |  |  |  |  | L-W |  | 995.4355648835831 |  |  | 0 |  | 0
17978 | ii | 577.8937400963155 | L-W |  |  |  |  |  |  |  | L-W |  | 1573.329304979899 |  |  | 0 |  | 0
18132 | jj | 859.4378872736888 | U-SW |  |  |  |  |  |  |  | U-SW |  | 1115.732699718439 |  |  | 0 |  | 0
18568 | kk | 170.7875151876196 | U-N |  |  |  |  |  |  |  | U-N |  | 463.7926636469577 |  |  | 0 |  | 0
(blank) | (blank) | (blank) | (blank) |  |  |  |  |  |  |  | (blank) |  | 0 |  |  | 0 |  | 0
Grand Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | Z407
 |  |  | Z709
 |  |  | Z009
 |  |  | Z005
 |  |  | Z026
 |  |  | Z001
 |  |  | Z002
 |  |  | Z003
 |  |  | Z004
 |  |  | Z019
 |  |  | Z219
 |  |  | Z020
 |  |  | Z220
 |  |  | Z021
 |  |  | Z221
 |  |  | Z022