JohnStevensInc
Board Regular
- Joined
- Dec 2, 2003
- Messages
- 109
I need help with a formula that will help with rising tide. Each worker in column A has a max daily inventory allotment as indicated in column B. Column C represents what they have been alloted that day. Column D represents the percentage that they have already been alloted that day.
20 additional units are received. What formula should I enter in column E that will distribute the units as evenly as possible across all workers (Rising tide = Jack gets so many units until he is even with Sarah's percentage, then Jack and Sarah get distributed evenly until they are equal to Frank's percentage and so on until the inventory is exhausted. THANKS FOR ANY HELP YOU CAN GIVE ME!
A B C D E
1 Jack 10 0 0%
2 Sally 150 50 33%
3 Frank 85 20 24%
4 John 150 100 67%
5 Sarah 110 10 9%
20 additional units are received. What formula should I enter in column E that will distribute the units as evenly as possible across all workers (Rising tide = Jack gets so many units until he is even with Sarah's percentage, then Jack and Sarah get distributed evenly until they are equal to Frank's percentage and so on until the inventory is exhausted. THANKS FOR ANY HELP YOU CAN GIVE ME!
A B C D E
1 Jack 10 0 0%
2 Sally 150 50 33%
3 Frank 85 20 24%
4 John 150 100 67%
5 Sarah 110 10 9%