Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for dividing work
He is the situation. I have 15 trucks a day to load each a different volume.
I have 3 or 4 loaders per day. I need a formula that would allow me to have the trucks assigned to each loader so that they each end up with about the same volume for the day. Truck Volume Loader 101 237 160 700 1198 102 236 151 654 1143 103 221 75 980 1379 Loaders 104 186 131 867 1288 Bob 105 301 186 955 1547 John 106 294 67 675 1142 Rick 107 156 167 755 1185 108 221 320 846 1495 109 234 454 946 1743 110 265 234 984 1593 111 274 222 344 951 112 301 443 944 1800 113 268 341 867 1589 114 186 564 754 1618 115 257 355 688 1415 116 255 186 901 1458 Avg. Vol 1328 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for counting and dividing | Excel Worksheet Functions | |||
SUMPRODUCT: dividing the formula of one cell by another. | Excel Worksheet Functions | |||
What is the formula for dividing-I have the total | Excel Worksheet Functions | |||
Formula needed for dividing hours by numbers | Excel Discussion (Misc queries) | |||
What is the formula for dividing a number by 4 in excel | Excel Worksheet Functions |