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