Allocate bonus amount proportionally according to individual scores

Hi.

I am looking to make a spreadsheet to divides up a bonus amount among people.

The amount should be distributed so that 100% of the funds are distributed to all people but not equally.

The amount of funds each person gets is determined by their score. The higher the score, the more the bonus they each person gets. The bonus amount is also a percentage of 100%. After the bonus is calculated, 100
% of the bonus amount should be allocated.





After the calculation is done, the total of each persons bonus must equal the bonus amount.

I intend to add more people who will further dilute the bonus amount each other person gets (but the bonus
amount will increase.





Thanks

Bonus	100.00
Name	Score	Bonus Amount
Lisa	28.2200	?
Dan	20.3800	?
Bob	215.8651	?
Mary	352.5401	?
Kathy	62.6800	?
Michael	36.2247	?
Chris	84.5400	?
David	1.3500	?
Alice	33.2042	?

Is the bonus allocated linearly according to the score? That is, does Mary get 17.30 times as much as Dan? If so, pretty straightforward. First, your format is working against you. Change your format to put the total bonus amount somewhere else, such as D1.

Scores in column B

First name on row 2

Lisa's bonus is

Formula:

Please Login or Register  to view this content.

and copy down.

If not, then you need to explain your algorithm for allocating the bonus.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.