Need formula for Point spread

Sylviav

New Member
Joined
Sep 18, 2019
Messages
1
Need a formula for the following:


Sales goal 77% 300 points to spread amongst 4 employees based on results


Emp #1 Actual - 83%
Emp #2 Actual - 80%
Emp #3 Actual - 78%
Emp #4 Actual - 69%
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Figuring out the split after the fact will only cause dissent among the 4 involved and any other employees. Since it was not decided prior to the results, I would give each 75 points.

Determining point division ahead of time could be rationalized to any of a number of ways to divide the 300 points:
Highest getting all of it
Even spit between all
Employees above 50% splitting 150 points equally and the balance distributed based on how far above half of goal (33/110,30/110,28/110,19/110)
Below goal getting none and splitting the points among the others 3 based on how far over the goal they were (6/10, 3/10, 1/10)

Each choice would put different pressures on the company/employee and the owner(s) would have to decide how they wanted their company to present to the world.
 
Upvote 0

Forum statistics

Threads
1,215,110
Messages
6,123,138
Members
449,098
Latest member
Doanvanhieu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top