Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - ludermor

Pages: [1] 2 3 ... 188
1
General discussion / Re: The OFFICIAL Liverpool FC thread
« on: March 18, 2015, 11:35:55 AM »
http://www.bbc.co.uk/news/uk-31928476
No comments here on the Hillsborough inquest, is there any new info coming out or has it all been in the public domain previously?

2
General discussion / Re: Things that make you go What the F**k?
« on: March 16, 2015, 03:15:10 PM »
Telford 'Jump' onlookers condemned by police
http://www.bbc.co.uk/news/uk-england-shropshire-31903327
Witness Chloe Jones said about 20 people, mainly teenagers, but "some grown men", were filming the incident unfold.

"As we walked past, there were some youths shouting 'Go on, do it - jump'," she said.

"It made me feel quite sick, actually,and then a lot of them were filming it, but to see some grown men filming it... I just said to them 'What on earth are you going to do with that footage? Are you going to home and watch it if that poor man jumps?'"

She said she was shocked at how people could not see "the obvious state" the man was in.

"It was almost like a form of entertainment for them... kids were screaming, running to the other side to see if they could get a better view," she said.

"It was just so sad."

3
General discussion / Re: Polygamy
« on: March 05, 2015, 10:53:32 AM »
Not sure if this is the best place to put this link but it might make a few heads explode.
http://skeleton-love.diply.com/auntyacid/kissing-skeletons-love-has-no-labels/101140

4
General discussion / Re: Excel Questions
« on: February 20, 2015, 11:16:51 AM »
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

I need the gap where ever the product is not in both A&C. My first table is how my data looks now. My second table is the result of a sort I need to do. Product avd is not in C&D thats why I need a gap to appear. Product aox was not lined up in the first table is is in the second.
Will the total in B always equal the total in D?

5
General discussion / Re: The OFFICIAL Liverpool FC thread
« on: February 19, 2015, 09:51:13 PM »
Sturridge having a strop when he didn't get the penalty and then not celebrating with Balotelli, sign of good team harmony!

6
General discussion / Re: Excel Questions
« on: February 19, 2015, 08:51:37 AM »
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.

7
General discussion / Re: Excel Questions
« on: February 18, 2015, 09:15:40 PM »
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

8
General discussion / Re: Excel Questions
« on: February 18, 2015, 09:14:02 PM »
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

9
General discussion / Re: Excel Questions
« on: February 18, 2015, 07:40:09 PM »
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.?

10
General discussion / Re: Excel Questions
« on: February 18, 2015, 07:02:46 PM »
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.

11
General discussion / Re: Excel Questions
« on: February 18, 2015, 05:19:55 PM »
I'm not sure Gallsman, that's why I'm asking here!

12
General discussion / Re: Excel Questions
« on: February 18, 2015, 04:51:40 PM »
Do you mean this?

visitors can't see pics , please register or login

image upload no limit
No the % of each worker is the % of their wages, not the % of the monthly cost. I'm trying to find out their individual monthly cost.

13
General discussion / Re: Excel Questions
« on: February 18, 2015, 02:50:52 PM »
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?

14
General discussion / Re: The Bible in quotations
« on: February 15, 2015, 10:14:07 PM »
I think omaghjoe has more reason than most to be religious as he may be the reincarnation of a previous poster ( who got crucified a few times!)

15
General discussion / Re: Moone Boy
« on: February 11, 2015, 09:11:35 PM »
No , never seen it first time round so watching from the start.

Pages: [1] 2 3 ... 188