Excel Questions

[macdanger2]

Probably more algerbra than excel question!
im trying to find out actual wages from one of my subcontractor and he has 3 different pay grades for trades. i have a total for the months and % allocation of the trades. Im sure there is an easy way to find out but my math brain has left me!
Month 1 total cost = 4972  which is made up of Tom x 33% , John x 12%, Mick x 30%
Month 2 Total cost = 6499 which is made up of Tom x 50% , John x 10%, Mick x 34%
How much is the monthly cost of each person?

If I understand you correctly, you're short one piece of information. You have two equations:

4972 = 0.33T + 0.12J + 0.3M
6499 = 0.5T + 0.1J +0.34M

You need some relationship to create a 3rd equation if you're looking for an exact answer. You could get a decent estimate from the info you currently have but I presume that's no good?

Yeah thats right Macdanger, if i knew one ofthe wages i could work out the rest but im struggling.

Is this a maths problem or a real world problem ludermor? If it's a maths problem, there must have been something else provided

[ludermor]

No its a real word problem!

Probably more algerbra than excel question!
im trying to find out actual wages from one of my subcontractor and he has 3 different pay grades for trades.?

[macdanger2]

A good estimate would be 8470 for Tom, 4600 for John and 5380 for Mick.

[macdanger2]

Sorry, I meant to explain where I got that estimate from (there are plenty of feasible solutions)

If you subtract one equation from the other, you end up with

1527 = 0.17T + 0.02J + 0.04M

So that 1527 is made up of 17% Tom plus 2% and 4% which I assume are negligible (say €100) - this estimate determines what your final result will be.

From that, you can calculate all three.

[gallsman]

The assumption in that however is that the total bill consists of the aggregate of the wages and nothing else.

[ludermor]

The assumption in that however is that the total bill consists of the aggregate of the wages and nothing else.

the assumption would be correct

[ludermor]

Sorry, I meant to explain where I got that estimate from (there are plenty of feasible solutions)

If you subtract one equation from the other, you end up with

1527 = 0.17T + 0.02J + 0.04M

So that 1527 is made up of 17% Tom plus 2% and 4% which I assume are negligible (say €100) - this estimate determines what your final result will be.

From that, you can calculate all three.

Cheers Mac, I'll play around and see how they work with a couple of other months

[muppet]

Sorry, I meant to explain where I got that estimate from (there are plenty of feasible solutions)

If you subtract one equation from the other, you end up with

1527 = 0.17T + 0.02J + 0.04M

So that 1527 is made up of 17% Tom plus 2% and 4% which I assume are negligible (say €100) - this estimate determines what your final result will be.

From that, you can calculate all three.

Should it not be €1,527 = 0.17T - 0.02J + 0.04M

The difference will be very small but it is interesting that John's went down even though the overall cost of the job went up. Thus (unless John is being shafted) the relationships are not linear and that makes it harder to work out.

Suggest you try to find out how much extra Mick made in the second month, or John lost, over a coffee or other casual chat. And us the above to work it out.

[macdanger2]

Sorry, yeah should be minus the 0.02 alright but same idea applies

[ludermor]

Sorry, I meant to explain where I got that estimate from (there are plenty of feasible solutions)

If you subtract one equation from the other, you end up with

1527 = 0.17T + 0.02J + 0.04M

So that 1527 is made up of 17% Tom plus 2% and 4% which I assume are negligible (say €100) - this estimate determines what your final result will be.

From that, you can calculate all three.

Should it not be €1,527 = 0.17T - 0.02J + 0.04M

The difference will be very small but it is interesting that John's went down even though the overall cost of the job went up. Thus (unless John is being shafted) the relationships are not linear and that makes it harder to work out.

Suggest you try to find out how much extra Mick made in the second month, or John lost, over a coffee or other casual chat. And us the above to work it out.

They would not be linear, Tom would earn a lot more than John who should be earning more than Mick. I shoudl know more in the next 2 weeks when i get the monthly application.

[gerrykeegan]

I have quick question for the excel experts. I have some information I want sort quickly.
       A        B         C       D
1     alg     55        alg     55
2     als     45        als      45
3     avd    33        aox     47
4     aox    47        rst       35

Products are in A and  C amounts in  B & D
I need it to kick out a gap where the product isn't in both A&C
      A        B         C       D
1     alg     55        alg     55
2     als     45        als      45
3     avd    33       
4     aox    47        aox     47
5                           rst       35

Anyone?

[laceer]

Highlight cells C3 and D3, click insert cells, select move cells down.
Think that should do what you're after

[gerrykeegan]

Highlight cells C3 and D3, click insert cells, select move cells down.
Think that should do what you're after

Thanks but that is  the manual version. I have a huge spreadsheet that this jobs needs to be done to time and time again.That process would take hours.

[macdanger2]

How frequently in the spreadsheet do you have to bump these couple of cells down? Is it recurring?

[Mario]

I have quick question for the excel experts. I have some information I want sort quickly.
       A        B         C       D
1     alg     55        alg     55
2     als     45        als      45
3     avd    33        aox     47
4     aox    47        rst       35

Products are in A and  C amounts in  B & D
I need it to kick out a gap where the product isn't in both A&C
      A        B         C       D
1     alg     55        alg     55
2     als     45        als      45
3     avd    33       
4     aox    47        aox     47
5                           rst       35

Anyone?

Where do you need the gap, in row 3 you have it in column C, in row 5 you have it in column A