Calculating totals of material with feet and inches

  • Thread starter Thread starter Julleanna
  • Start date Start date
J

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


Gary Brown said:
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


Julleanna said:
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?
Click to expand...
Click to expand...
 
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
 
Back
Top