reallocation - Percentage Split in excel

[waratah2014]

I have this simple case, where 35 students formed a group and advised in % the effort work done in the project. Total percentage is 100% ( % splitted and equals 100%)

One student ( aka GOJI) decided to leave and requested to allocate his % (25%) among the group.

GOJI contributed 25% and now his % to be reallocated among 35 Students ( based on the students current %).

I have prepared the sheet and I have to reallocate 33.33 % instead of Goji's 25% so group total equals 100%.

Is that correct approach ?

Please have a look at the sheet

Column A & B is the actual numbers, showing Goji included.
Column J & K is the revised % split, including Goji's % ( 33.33 %) and excluding Goji from Group.

 

[Hui]

Waratah

That method is wrong

What is required is to allocate each persons results as a proportion of the total minus Goji's %

eg: John A has 8.34%, Goji is giving up 25%
So John A's total of the revised amount is 8.34%/(1-25%) = 11.12%

I've also put a Data validation Drop Down in J1 and added some Conditional Formatting

see attached file