Calculating totals of material with feet and inches

[Julleanna]

I'm setting up a spread sheet for bill of materials. Let's say I have
3x3x1/4 material at 1' 10 3/8" each and 3x3x1/4 at 5' 4 1/8" each. I want
Excel to calculate total in feet and inches. Bascially variable sizes.

I am not sure how to write this so that I can use it for other materials. I
need to find out the total of the material to order. Is there any easy way to
do this?

 

[Julleanna]

I'm not trying to find out how many sheets. I'm trying to figure out the
total feet and inches 8, 15 or 4 of these are and so on.
--
Julleanna

Assuming you are trying to get at (1) how many sheets of 3x3x1/4 are in a 1'
10 3/8" stack, (2) how many sheets of 3x3x1/4 are in a 5' 4 1/8" stack...
=[(1x12)+10+(3/8)]/.25 = 89.5 sheets
and
=[(5*12)+4+(1/4)]/.25 = 256.5 sheets
Not sure how you could get half a sheet like that but, mathematically, that
is the answer.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown

I'm setting up a spread sheet for bill of materials. Let's say I have
3x3x1/4 material at 1' 10 3/8" each and 3x3x1/4 at 5' 4 1/8" each. I want
Excel to calculate total in feet and inches. Bascially variable sizes.

I am not sure how to write this so that I can use it for other materials. I
need to find out the total of the material to order. Is there any easy way to
do this?

 

[Gary Brown]

Assuming you are trying to get at (1) how many sheets of 3x3x1/4 are in a 1'
10 3/8" stack, (2) how many sheets of 3x3x1/4 are in a 5' 4 1/8" stack...
=[(1x12)+10+(3/8)]/.25 = 89.5 sheets
and
=[(5*12)+4+(1/4)]/.25 = 256.5 sheets
Not sure how you could get half a sheet like that but, mathematically, that
is the answer.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown