G
Guest
I need to adjust a machine setting according to a 5% average balance between
4 cranes storing pallets.
If the average of 76.12% is 2.5% above the total average of all cranes, then
adjust down to 1.
If the average of 76.12% is -2.5% less then the average of all cranes, then
adjust up to 1.
Aisle1 Aisle2 Aisle 3 Aisle4 Totals
4,092 4,128 4,128 4,128 16,476 Total #Plts
3,115 3,218 3,473 3,420 13,226 Actual # Plts
76.12% 77.96% 84.13% 82.85% 80.27% Avg % Full
82.28% is 2.50% of 80.27%
78.27% is -2.50% of 80.27%
I have worked on this for 3 days and cant get
the formula set. I'm using Excel VS.2003.
4 cranes storing pallets.
If the average of 76.12% is 2.5% above the total average of all cranes, then
adjust down to 1.
If the average of 76.12% is -2.5% less then the average of all cranes, then
adjust up to 1.
Aisle1 Aisle2 Aisle 3 Aisle4 Totals
4,092 4,128 4,128 4,128 16,476 Total #Plts
3,115 3,218 3,473 3,420 13,226 Actual # Plts
76.12% 77.96% 84.13% 82.85% 80.27% Avg % Full
82.28% is 2.50% of 80.27%
78.27% is -2.50% of 80.27%
I have worked on this for 3 days and cant get
the formula set. I'm using Excel VS.2003.