Spreadsheet: 110008d1306819794-how-to-autofill-planner-sheet1
Sheet: Sheet1

 |  |  | [NAME] available |  |  |  |  |  |  | 1700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MY COMMENTS
Customer Code | Customer Name | Total order Volume | DIRECTION |  |  |  |  |  |  |  |  | Key | Aggregated Volume - Clubbed orders | Utilization
1137 | a | 591.7248794811128 | L-S |  |  |  |  |  |  |  |  | L-S | 591.7248794811128 | 0.3480734585183016 | Should be marked as this is above row marked in yellow
1139 | b | 585.573531906082 | L-S |  |  |  |  |  |  |  |  | L-S | 1177.298411387195 | 0.6925284772865852 | Should be marked as this is above row marked in yellow
1141 | c | 186.4737999709938 | L-S |  |  |  |  |  |  |  |  | L-S | 1363.772211358189 | 0.8022189478577579 | Should be marked as this is above row marked in yellow
1150 | d | 230.5003663073879 | L-NW |  |  |  |  |  |  |  |  | L-NW | 230.5003663073879 | 0.1355884507690517
1164 | e | 588.1174863532763 | U-W |  |  |  |  |  |  |  |  | U-W | 588.1174863532763 | 0.3459514625607508
1169 | f | 860.3538510190904 | U-W |  |  |  |  |  |  |  |  | U-W | 1448.471337372367 | 0.8520419631602156
1174 | g | 291.0769536309245 | L-W |  |  |  |  |  |  |  |  | L-W | 291.0769536309245 | 0.1712217374299556 | OTHER DIRECTIONS CAN BE IGNORED
1176 | h | 742.2931176996285 | L-NW |  |  |  |  |  |  |  |  | L-NW | 972.7934840070164 | 0.5722314611805979
1178 | i | 452.5273068787218 | U-W |  |  |  |  |  |  |  |  | U-W | 1900.998644251089 | 1.118234496618287
1217 | j | 373.1153902855456 | U-W |  |  |  |  |  |  |  |  | U-W | 2274.114034536634 | 1.337714137962726
1229 | k | 205.8860366897564 | U-S |  |  |  |  |  |  |  |  | U-S | 205.8860366897564 | 0.1211094333469155
3309 | l | 497.6590937292736 | L-E |  |  |  |  |  |  |  |  | L-E | 497.6590937292736 | 0.292740643370161
5427 | m | 635.2841463611848 | L-E |  |  |  |  |  |  |  |  | L-E | 1132.943240090458 | 0.6664372000532108
8967 | n | 192.7074102016737 | L-E |  |  |  |  |  |  |  |  | L-E | 1325.650650292132 | 0.7797945001718424
9478 | o | 79.85063076696817 | L-N |  |  |  |  |  |  |  |  | L-N | 79.85063076696817 | 0.04697095927468715
9612 | p | 332.4014387836769 | L-S |  |  |  |  |  |  |  |  | L-S | 1696.173650141865 | 0.9977492059658032 | < -- Gives max utilization so L-S direction will be served with the available truck
10228 | q | 310.4042245781633 | L-S |  |  |  |  |  |  |  |  | L-S | 2006.577874720029 | 1.180339926305899 | Should NOT be marked as this is below  row marked in yellow
10390 | r | 319.1315679284679 | L-S |  |  |  |  |  |  |  |  | L-S | 2325.709442648497 | 1.368064378028528 | Should NOT be marked as this is below  row marked in yellow
10424 | s | 217.3566657549354 | U-SW |  |  |  |  |  |  |  |  | U-SW | 217.3566657549354 | 0.1278568622087856
10524 | t | 228.8016741594107 | L-W |  |  |  |  |  |  |  |  | L-W | 519.8786277903353 | 0.3058109575237266
11062 | u | 293.0051484593381 | U-N |  |  |  |  |  |  |  |  | U-N | 293.0051484593381 | 0.1723559696819636
11187 | v | 569.786914229303 | L-NW |  |  |  |  |  |  |  |  | L-NW | 1542.58039823632 | 0.9074002342566585
14503 | x | 260.8883216194189 | L-SW |  |  |  |  |  |  |  |  | L-SW | 260.8883216194189 | 0.1534637185996582
15077 | y | 922.9128728832359 | L-E |  |  |  |  |  |  |  |  | L-E | 2248.563523175368 | 1.322684425397275
15323 | z | 186.075275119195 | U-W |  |  |  |  |  |  |  |  | U-W | 2460.189309655829 | 1.447170182150487
15931 | aa | 38.93814668981484 | U-SW |  |  |  |  |  |  |  |  | U-SW | 256.2948124447503 | 0.1507616543792649
16062 | bb | 1265.10069351888 | L-S |  |  |  |  |  |  |  |  | L-S | 3590.810136167377 | 2.112241256569045 | Should NOT be marked as this is below  row marked in yellow
16172 | cc | 681.7721027447192 | L-SE |  |  |  |  |  |  |  |  | L-SE | 681.7721027447192 | 0.4010424133792466
16612 | dd | 247.7993246979836 | L-S |  |  |  |  |  |  |  |  | L-S | 3838.609460865361 | 2.258005565214918 | Should NOT be marked as this is below  row marked in yellow
16660 | ee | 479.0118609061184 | L-S |  |  |  |  |  |  |  |  | L-S | 4317.621321771479 | 2.53977724810087 | Should NOT be marked as this is below  row marked in yellow
17040 | ff | 339.4784874936946 | U-W |  |  |  |  |  |  |  |  | U-W | 2799.667797149523 | 1.646863410087955
17087 | gg | 262.3730951983065 | L-S |  |  |  |  |  |  |  |  | L-S | 4579.994416969786 | 2.694114362923403 | Should NOT be marked as this is below  row marked in yellow
17120 | hh | 475.5569370932478 | L-W |  |  |  |  |  |  |  |  | L-W | 995.4355648835831 | 0.5855503322844606
17978 | ii | 577.8937400963155 | L-W |  |  |  |  |  |  |  |  | L-W | 1573.329304979899 | 0.9254878264587638
18132 | jj | 859.4378872736888 | U-SW |  |  |  |  |  |  |  |  | U-SW | 1115.732699718439 | 0.6563133527755524
18568 | kk | 170.7875151876196 | U-N |  |  |  |  |  |  |  |  | U-N | 463.7926636469577 | 0.2728192139099752
(blank) | (blank) | (blank) | (blank) |  |  |  |  |  |  |  |  | (blank) | 0 | 0
Grand Total
 |  |  | Z407
 |  |  | Z709
 |  |  | Z009
 |  |  | Z005
 |  |  | Z026
 |  |  | Z001
 |  |  | Z002
 |  |  | Z003
 |  |  | Z004
 |  |  | Z019
 |  |  | Z219
 |  |  | Z020
 |  |  | Z220
 |  |  | Z021
 |  |  | Z221
 |  |  | Z022