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
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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Correction:
>> What is 1 x 1 x 1, my answer is .0416. Is that correct?
>
No! Assuming these dims are feet, a 1x1x1 cube has 6 sq. ft. of
surface area.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

After serious thinking CWatters wrote :
> On 30/06/2011 02:44, GS wrote:
>> 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.
>>
>
> 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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Jun 30, 10:25*am, GS <g...@somewhere.net> wrote:
> After serious thinking CWatters wrote :
>
>
>
>
>
> > On 30/06/2011 02:44, GS wrote:
> >> 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.
>
> > 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
>
> --
> 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!