Check to see if formula is correct

  • Thread starter Thread starter Bob
  • Start date Start date
B

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?
 
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
Click to expand...
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?
Click to expand...

No! Assuming these dims are feet, a 1Ft square object has 6 sq. ft. of
surface area.
 
After serious thinking CWatters wrote :
His dims must be in inches. Hence the 144.

6/144 = 0.0416
Click to expand...

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
 
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 -
Click to expand...

Thanks, for all the responce!
 
Back
Top