blonde poker forum

Community Forums => The Lounge => Topic started by: outragous76 on April 07, 2011, 08:23:48 PM



Title: Maths/Excel help pls
Post by: outragous76 on April 07, 2011, 08:23:48 PM
I am needing to show % savings in excel

as an example

claim 100

settled at 70

if I use (= 70/100*100) - it gives me the reduction of the total as an answer ie 70%

I want it to show the saving ie30% - can anyone come up with a formula please

tyty


Title: Re: Maths/Excel help pls
Post by: rossfourfive on April 07, 2011, 08:26:17 PM
=1-(70/100)


Title: Re: Maths/Excel help pls
Post by: kinboshi on April 07, 2011, 08:27:07 PM
100-

or 1-


Title: Re: Maths/Excel help pls
Post by: outragous76 on April 07, 2011, 08:35:46 PM
ty both  - knew there would be a quick solution


Title: Re: Maths/Excel help pls
Post by: skolsuper on April 07, 2011, 09:13:32 PM
Wow.


Title: Re: Maths/Excel help pls
Post by: outragous76 on April 07, 2011, 09:31:57 PM
Wow.

If there is horizontal cracking running through brickwork, what do you believe the problem to be?

Does it make a difference between cavity brickwork and traditional brickwork?

What remedies would you propose?


Title: Re: Maths/Excel help pls
Post by: rossfourfive on April 07, 2011, 09:37:52 PM
Wow.

If there is horizontal cracking running through brickwork, what do you believe the problem to be?

Does it make a difference between cavity brickwork and traditional brickwork?

What remedies would you propose?

Good answer


Title: Re: Maths/Excel help pls
Post by: thetank on April 07, 2011, 10:26:41 PM
Wow.

If there is horizontal cracking running through brickwork, what do you believe the problem to be?

Does it make a difference between cavity brickwork and traditional brickwork?

What remedies would you propose?

Good answer

totally

Though I now need closure on wtf we're going to do about these bricks.


Title: Re: Maths/Excel help pls
Post by: outragous76 on April 07, 2011, 10:58:10 PM
haha tank - just for you

horizontal cracking is a sign of wall tie failure in cavity brickwork (usually down to the use of ferrous ties and not the more modern stainless steel). The ties corrode and fail meaning that the two "skins" of brickwork move independently and do not provide adequate lateral support causing horizontal cracking (rather than vertical cracking as would be seen in subsidence for example).

Traditional remedies include cutting out sections of brickwork at say 600mm centres and inserting new ties. This is expensive and time consuming. A more modern approach includes the insertion of long steel rods through the mortar joints which are in turn tied back to the inner leaf but at less frequent centres (i dont do resi so cant tell you too much of this system).

Hope that helps you sleep!


Title: Re: Maths/Excel help pls
Post by: thetank on April 07, 2011, 10:59:24 PM
 :)up