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.