Did you add the truck number into the load on each truck? I put the data
into a spdsheet and reorganized it just to see if I understoond the
problem--16 trucks, 3 different sized loads listed per truck, actual average
on the lower right...is this the right way to look at the data? Not sure if
there is a set way to do this, or if sorting the loads and then running some
kinds of aveages would work. Does each truck have a different max load?

Regards,
Peter
# Ld1 Ld2 Ld3 xxx actual load minus truck #???
101 237 160 700 1198 1097
102 236 151 654 1143 1041
103 221 75 980 1379 1276
104 186 131 867 1288 1184
105 301 186 955 1547 1442
106 294 67 675 1142 1036
107 156 167 755 1185 1078
108 221 320 846 1495 1387
109 234 454 946 1743 1634
110 265 234 984 1593 1483
111 274 222 344 951 840
112 301 443 944 1800 1688
113 268 341 867 1589 1476
114 186 564 754 1618 1504
115 257 355 688 1415 1300
116 255 186 901 1458 1342
Avg. Vol 1328 Average 1300.5

"Dok" wrote:

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