percentage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve - 14 Sep 2007 18:44 GMT

I have a total kw (kilowatt) of 1400110
I have a group of building that have each a portion of this.
Each building is different one is 55973kw another is 32034 and so on
How do I figure what percentage of the total kw each of the buildings
come out to be. or would I use the same formula you gave for the square
footage.

Signature

Thank You
Steve

Reply to this Message

Mike H - 14 Sep 2007 19:18 GMT

Steve,

It's exactly the same as for the footage:-

individual building usage/total usage * 100 = precentage

Mike

> I have a total kw (kilowatt) of 1400110
> I have a group of building that have each a portion of this.
> Each building is different one is 55973kw another is 32034 and so on
> How do I figure what percentage of the total kw each of the buildings
> come out to be. or would I use the same formula you gave for the square
> footage.

Reply to this Message

steve - 15 Sep 2007 11:38 GMT

Thanks again, this is an awsome site and you people are great for helping
others out.

Signature

Thank You
Steve

> Steve,
>
[quoted text clipped - 10 lines]
> > come out to be. or would I use the same formula you gave for the square
> > footage.

Reply to this Message

Gord Dibben - 14 Sep 2007 22:06 GMT

Bldg 1 =55973/1400110

Bldg 2 =32034/1400110

If the values are in cells just use the cell refs instead of numbers.

=A1/$B$1 with bldg 1 kw in A1 and total kw in B1

Remember if copying, use Absolute reference for the cell with 1400110

Gord Dibben MS Excel MVP

>I have a total kw (kilowatt) of 1400110
>I have a group of building that have each a portion of this.
>Each building is different one is 55973kw another is 32034 and so on
>How do I figure what percentage of the total kw each of the buildings
>come out to be. or would I use the same formula you gave for the square
>footage.

Reply to this Message