You'll need to use a weighted average, first of the days worked. then of the
days earnings


Amount Name Share Days Weighted Days Weighted
1500 Tracy 0.47 7 329.000 890.79
Buzz 0.33 5 165.000 446.75
Damon 0.20 3 60.000 162.45
Totals 1.00 15 554.000 1500.00


Weighted days = (Days worked by indiv/sum of days worked by all employees) *
(Individual Share * Amount)
Assuming table is in a=>F above, for Tracy: (D2/d5) * (B2*A2)

Weighted = (Weighted days/Sum of Weighted Days)* Amount

Again, for Tracy: (E2/E5) * A2

You can change values in A (Amount), Columns B, C & D (Individuals and their
rates, days). Naturally you will have to come up with appropriate reference
for the summation cells:

e.g. F2 = (E2/Sum(E:E))*A2
BAc


"pgc" wrote:

> 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
>
>