Spreadsheet: 109972d1306779059-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 | #N/A | 591.7248794811128 |  | #N/A | 7 |  | Mark
1139 | b | 585.573531906082 | L-S |  |  |  |  |  |  |  | L-S | #N/A | 1177.298411387195 |  | #N/A | 8 |  | Mark
1141 | c | 186.4737999709938 | L-S |  |  |  |  |  |  |  | L-S | #N/A | 1363.772211358189 |  | #N/A | 21 |  | Mark
1150 | d | 230.5003663073879 | L-NW |  |  |  |  |  |  |  | L-NW | #N/A | 230.5003663073879 |  | #N/A | 13 |  | Mark
1164 | e | 588.1174863532763 | U-W |  |  |  |  |  |  |  | U-W | #N/A | 588.1174863532763 |  | #N/A | 11 |  | Mark
1169 | f | 860.3538510190904 | U-W |  |  |  |  |  |  |  | U-W | #N/A | 1448.471337372367 |  | #N/A | 14 | U-W | Mark
1174 | g | 291.0769536309245 | L-W |  |  |  |  |  |  |  | L-W | #N/A | 291.0769536309245 |  | #N/A | 25 |  | Mark
1176 | h | 742.2931176996285 | L-NW |  |  |  |  |  |  |  | L-NW | #N/A | 972.7934840070164 |  | #N/A | 27 |  | Mark
1178 | i | 452.5273068787218 | U-W |  |  |  |  |  |  |  | U-W | #N/A | 1900.998644251089 |  | #N/A | 15 | U-W
1217 | j | 373.1153902855456 | U-W |  |  |  |  |  |  |  | U-W | #N/A | 2274.114034536634 |  | #N/A | 30 | U-W
1229 | k | 205.8860366897564 | U-S |  |  |  |  |  |  |  | U-S | #N/A | 205.8860366897564 |  | #N/A | 0 |  | Mark
3309 | l | 497.6590937292736 | L-E |  |  |  |  |  |  |  | L-E | #N/A | 497.6590937292736 |  | #N/A | 18 |  | Mark
5427 | m | 635.2841463611848 | L-E |  |  |  |  |  |  |  | L-E | #N/A | 1132.943240090458 |  | #N/A | 19 |  | Mark
8967 | n | 192.7074102016737 | L-E |  |  |  |  |  |  |  | L-E | #N/A | 1325.650650292132 |  | #N/A | 29 | L-E | Mark
9478 | o | 79.85063076696817 | L-N |  |  |  |  |  |  |  | L-N | #N/A | 79.85063076696817 |  | #N/A | 0 |  | Mark
9612 | p | 332.4014387836769 | L-S |  |  |  |  |  |  |  | L-S | #N/A | 1696.173650141865 |  | #N/A | 22 | L-S | Mark
10228 | q | 310.4042245781633 | L-S |  |  |  |  |  |  |  | L-S | #N/A | 2006.577874720029 |  | #N/A | 23 | L-S
10390 | r | 319.1315679284679 | L-S |  |  |  |  |  |  |  | L-S | #N/A | 2325.709442648497 |  | #N/A | 32 | L-S
10424 | s | 217.3566657549354 | U-SW |  |  |  |  |  |  |  | U-SW | #N/A | 217.3566657549354 |  | #N/A | 31 |  | Mark
10524 | t | 228.8016741594107 | L-W |  |  |  |  |  |  |  | L-W | #N/A | 519.8786277903353 |  | #N/A | 38 |  | Mark
11062 | u | 293.0051484593381 | U-N |  |  |  |  |  |  |  | U-N | #N/A | 293.0051484593381 |  | #N/A | 41 |  | Mark
11187 | v | 569.786914229303 | L-NW |  |  |  |  |  |  |  | L-NW | #N/A | 1542.58039823632 |  | #N/A | 0 |  | Mark
14503 | x | 260.8883216194189 | L-SW |  |  |  |  |  |  |  | L-SW | #N/A | 260.8883216194189 |  | #N/A | 0 |  | Mark
15077 | y | 922.9128728832359 | L-E |  |  |  |  |  |  |  | L-E | #N/A | 2248.563523175368 |  | #N/A | 0 | L-E
15323 | z | 186.075275119195 | U-W |  |  |  |  |  |  |  | U-W | #N/A | 2460.189309655829 |  | #N/A | 36 | U-W
15931 | aa | 38.93814668981484 | U-SW |  |  |  |  |  |  |  | U-SW | #N/A | 256.2948124447503 |  | #N/A | 40 |  | Mark
16062 | bb | 1265.10069351888 | L-S |  |  |  |  |  |  |  | L-S | #N/A | 3590.810136167377 |  | #N/A | 34 | L-S
16172 | cc | 681.7721027447192 | L-SE |  |  |  |  |  |  |  | L-SE | #N/A | 681.7721027447192 |  | #N/A | 0 |  | Mark
16612 | dd | 247.7993246979836 | L-S |  |  |  |  |  |  |  | L-S | #N/A | 3838.609460865361 |  | #N/A | 35 | L-S
16660 | ee | 479.0118609061184 | L-S |  |  |  |  |  |  |  | L-S | #N/A | 4317.621321771479 |  | #N/A | 37 | L-S
17040 | ff | 339.4784874936946 | U-W |  |  |  |  |  |  |  | U-W | #N/A | 2799.667797149523 |  | #N/A | 0 | U-W
17087 | gg | 262.3730951983065 | L-S |  |  |  |  |  |  |  | L-S | #N/A | 4579.994416969786 |  | #N/A | 0 | L-S
17120 | hh | 475.5569370932478 | L-W |  |  |  |  |  |  |  | L-W | #N/A | 995.4355648835831 |  | #N/A | 39 |  | Mark
17978 | ii | 577.8937400963155 | L-W |  |  |  |  |  |  |  | L-W | #N/A | 1573.329304979899 |  | #N/A | 0 |  | Mark
18132 | jj | 859.4378872736888 | U-SW |  |  |  |  |  |  |  | U-SW | #N/A | 1115.732699718439 |  | #N/A | 0 |  | Mark
18568 | kk | 170.7875151876196 | U-N |  |  |  |  |  |  |  | U-N | #N/A | 463.7926636469577 |  | #N/A | 0 |  | Mark
(blank) | (blank) | (blank) | (blank) |  |  |  |  |  |  |  | (blank) | #N/A | 0 |  | #N/A | 43 | #N/A | #N/A
Grand Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mark
 |  |  | Z407
 |  |  | Z709
 |  |  | Z009
 |  |  | Z005
 |  |  | Z026
 |  |  | Z001
 |  |  | Z002
 |  |  | Z003
 |  |  | Z004
 |  |  | Z019
 |  |  | Z219
 |  |  | Z020
 |  |  | Z220
 |  |  | Z021
 |  |  | Z221
 |  |  | Z022