I have 3 employees, Tracy, Buzz and Damon they work as a team,

If they all work the same amount of days there wages are as follows
Tracy gets 47% of the total

Buzz gets 33% of the total

And Damon gets 20% of the total

But what happens in the scenario below



Name Days total price total day rate total earnings
worked work for team for team for team

Tracy 7 £1500.00 £350.00 £1850.00
Buzz 5
Damon 3

How much would each member earn and i need a formula so i can change
details in each column


Your help would be most appreciated