Check to see if formula is correct

[Bob]

Could someone please check if my formula is correct for calculating my
total square feet.
P6 = Lenght
Q6 = Width
R6 = Height
S6 = Qty.
T6 = Total Square Feet
=(2*(P6)*(Q6)+2*(P6)*(R6)+2*(Q6)*(R6))*S6/144
What is 1 x 1 x 1, my answer is .0416. Is that correct?

 

[GS]

After serious thinking Bob wrote :

Could someone please check if my formula is correct for calculating my
total square feet.
P6 = Lenght
Q6 = Width
R6 = Height
S6 = Qty.
T6 = Total Square Feet
=(2*(P6)*(Q6)+2*(P6)*(R6)+2*(Q6)*(R6))*S6/144

Not sure why you multiply by 2. Are you calcing surface area sq. ft.?
Assuming the objects are rectangular (6 sides)...

=SUM((P6*Q6)*2,(P6*R6)*2,(R6*Q6)*2)*Qty

In plain english:

=SUM((FeetLong*FeetWide)*2,(FeetLong*FeetHigh)*2,(FeetHigh*FeetWide)*2)*Qty

What is 1 x 1 x 1, my answer is .0416. Is that correct?

No! Assuming these dims are feet, a 1Ft square object has 6 sq. ft. of
surface area.

 

[GS]

Correction:No! Assuming these dims are feet, a 1x1x1 cube has 6 sq. ft. of
surface area.

 

[CWatters]

Could someone please check if my formula is correct for calculating my
total square feet.
P6 = Lenght
Q6 = Width
R6 = Height
S6 = Qty.
T6 = Total Square Feet
=(2*(P6)*(Q6)+2*(P6)*(R6)+2*(Q6)*(R6))*S6/144
What is 1 x 1 x 1, my answer is .0416. Is that correct?

It's correct.

A cube 1 inch on a side has a surface area of 6 square inches.

6/144 = 0.0416

so yes a 1" cube has a surface area of 0.0416 square feet.

 

[CWatters]

After serious thinking Bob wrote :
Not sure why you multiply by 2. Are you calcing surface area sq. ft.?
Assuming the objects are rectangular (6 sides)...

=SUM((P6*Q6)*2,(P6*R6)*2,(R6*Q6)*2)*Qty

In plain english:

=SUM((FeetLong*FeetWide)*2,(FeetLong*FeetHigh)*2,(FeetHigh*FeetWide)*2)*Qty


No! Assuming these dims are feet, a 1Ft square object has 6 sq. ft. of
surface area.

His dims must be in inches. Hence the 144.

6/144 = 0.0416

 

[GS]

After serious thinking CWatters wrote :

His dims must be in inches. Hence the 144.

6/144 = 0.0416

Thanks! -Makes sense. I could have derived that but didn't catch it
given the context of square feet. In this case...

=((SUM(P6*Q6,P6*R6,Q6*R6)*2)*S6)/144

Returns: 0.041667 sq. ft. for 1 piece measuring 1x1x1

Though, I'd prefer to name the columns with local scope as
ColumnAbsolute,RowRelative so the formula makes easier to understand
sense 'as viewed'!

=((SUM(Length*Width,Length*Height,Width*Height)*2)*Qty)/InchesPerSqFt

 

[Bob]

After serious thinking CWatters wrote :








Thanks! -Makes sense. I could have derived that but didn't catch it
given the context of square feet. In this case...

  =((SUM(P6*Q6,P6*R6,Q6*R6)*2)*S6)/144

  Returns: 0.041667 sq. ft. for 1 piece measuring 1x1x1

Though, I'd prefer to name the columns with local scope as
ColumnAbsolute,RowRelative so the formula makes easier to understand
sense 'as viewed'!

  =((SUM(Length*Width,Length*Height,Width*Height)*2)*Qty)/InchesPerSqFt

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -

- Show quoted text -

Thanks, for all the responce!