[SOLVED] How to calculate each group percentage cut in google spreadsheet

[MadaChange]

I want to calculate each group percentage cut base on how much money they put in and I want Group 1 to have a +5% more over the others.

So I have this Spreadsheet screenshot, but Im still having problem how I will calculate the +5% more of Group 1.

 

[kanewolf]

I want to calculate each group percentage cut base on how much money they put in and I want Group 1 to have a +5% more over the others.

So I have this Spreadsheet screenshot, but Im still having problem how I will calculate the +5% more of Group 1.

When you say 5% more than the others. Do you mean 5% more than all the others or 5% more than an individual ?
If it is all the others then the group1 has to have 52.5% of the total. That leaves 47.5% for the other three groups so that there is a 5% of the total difference.

 

[MadaChange]

When you say 5% more than the others. Do you mean 5% more than all the others or 5% more than an individual ?
If it is all the others then the group1 has to have 52.5% of the total. That leaves 47.5% for the other three groups so that there is a 5% of the total difference.

I mean 5% more than all the others and 52.5% and 47.5% If they have all equal share.
But how about if they have unequal shares and group 1 still 5% more than all of the other groups how do you calculate that?

 

[USAFRet]

Give Group 1 52.5% of the total.
Split the rest proportionally.

 

[kanewolf]

I mean 5% more than all the others and 52.5% and 47.5% If they have all equal share.
But how about if they have unequal shares and group 1 still 5% more than all of the other groups how do you calculate that?

Sum of groups 2 - N == 47.5% of X, so X = sum / 47.5% Then multiply X by 52.5% to get group 1

 

[MadaChange]

Give Group 1 52.5% of the total.
Split the rest proportionally.

How can I do this with google spreadsheet, can you please explain it more.
I also want to make it look like this so it will be easier to see each group percentage.

 

[kanewolf]

How can I do this with google spreadsheet, can you please explain it more.
I also want to make it look like this so it will be easier to see each group percentage.

Read my post. It gives you the formulas..

 

[MadaChange]

Read my post. It gives you the formulas..

Im maybe dumb but how do you apply that formula to work in google spreadsheet.

 

[kanewolf]

Im maybe dumb but how do you apply that formula to work in google spreadsheet.

Assuming A2 - A5 are the "rest" of the values with values of 100, 200, 150, 75
A1 = (sum(a2:a5)/47.5%)*52.5%
A1 = 580.2632 == 52.5% of the total of a1 - a5.

Value	Percent
580.26​	52.5%​
100.00​	9.0%​
200.00​	18.1%​
150.00​	13.6%​
75.00​	6.8%​
	100.0%​