Reverse engineer to create unknown numbers based on known percentage allocations

[raynerfredrick]

I'm trying to reverse engineer hours based on a team with various %s totaling 100%. In the end, hours X each individuals known Rate will all sum to be $175,000. I have a program that does this but I'm trying to replicate in excel. First table below is completed in the program and every time I modify the %, it reallocates hours to total 100%. Second table is emptyAny help appreciated.

[TABLE="width: 229"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]TYPE[/TD]
[TD]%[/TD]
[TD]HRS[/TD]
[TD]RATE[/TD]
[TD]AMOUNT[/TD]
[/TR]
[TR]
[TD]A

[/TD]
[TD]

5[/TD]
[TD]23.52[/TD]
[TD]$750[/TD]
[TD]$17,641[/TD]
[/TR]
[TR]
[TD]B

[/TD]
[TD]

5[/TD]
[TD]23.52[/TD]
[TD]$430[/TD]
[TD]$10,114[/TD]
[/TR]
[TR]
[TD]C

[/TD]
[TD]

15[/TD]
[TD]70.56[/TD]
[TD]$365[/TD]
[TD]$25,756[/TD]
[/TR]
[TR]
[TD]D

[/TD]
[TD]

15[/TD]
[TD]70.56[/TD]
[TD]$295[/TD]
[TD]$20,817[/TD]
[/TR]
[TR]
[TD]E

[/TD]
[TD]

10[/TD]
[TD]47.04[/TD]
[TD]$300[/TD]
[TD]$14,113[/TD]
[/TR]
[TR]
[TD]F

[/TD]
[TD]

20[/TD]
[TD]94.09[/TD]
[TD]$500[/TD]
[TD]$47,043[/TD]
[/TR]
[TR]
[TD]G

[/TD]
[TD]

15[/TD]
[TD]70.56[/TD]
[TD]$280[/TD]
[TD]$19,758[/TD]
[/TR]
[TR]
[TD]H

[/TD]
[TD]

15[/TD]
[TD]70.56[/TD]
[TD]$280[/TD]
[TD]$19,758[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100%[/TD]
[TD]470.41[/TD]
[TD]$372[/TD]
[TD]$175,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TYPE[/TD]
[TD]%[/TD]
[TD]HRS[/TD]
[TD]RATE[/TD]
[TD]AMOUNT[/TD]
[/TR]
[TR]
[TD]A

[/TD]
[TD] [/TD]
[TD][/TD]
[TD]$750[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B

[/TD]
[TD] [/TD]
[TD][/TD]
[TD]$430[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C

[/TD]
[TD] [/TD]
[TD][/TD]
[TD]$365[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D

[/TD]
[TD] [/TD]
[TD][/TD]
[TD]$295[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E

[/TD]
[TD] [/TD]
[TD][/TD]
[TD]$300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F

[/TD]
[TD] [/TD]
[TD][/TD]
[TD]$500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G

[/TD]
[TD] [/TD]
[TD][/TD]
[TD]$280[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]H

[/TD]
[TD] [/TD]
[TD][/TD]
[TD]$280[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0%[/TD]
[TD][/TD]
[TD]$372[/TD]
[TD]$175,000[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

Solver will do this, hang on I'll post an example

 

[sheetspread]

goal seek works too here, and is easier

 

[raynerfredrick]

Worked perfectly. Thanks so much for your help.