How to calculate the volume of plastic bags

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
2,687
Office Version
  1. 365
Platform
  1. Windows
This is really more of a math (geometry) question, but a lot of people here are pretty good at math, so I'm hoping...

I am trying to calculate the volume of various plastic bags used to line trash bins. I know how to calculate the volume of regular solids like cylinders, cubes, rectangular solids, and cones. I don't think these bags are not any of those shapes. They typically come in rolls so they lay out flat before being opened. When opened, the top assumes the shape of the bin, usually a circle or a rectangle. The bottom remains sealed. My first thought was that the cross-sectional area would go from the maximum at the top down to zero at the bottom, so I'd just need to average that over the entire height.

In one roll of bags that I have now that claim to hold 2.6 gallons, each bag is 16" wide and 17" deep. Here's the table of calculations:

Kitchen Scrap Bins.xlsx
CDEF
5ValueUnitsQuantityFormula
616.00inWidth of bagC6: 16
717.00inHeight of bagC7: 17
832.00inCircumferenceC8: =C6*2
910.19inDiameter at topC9: =C8/PI()
105.09inRadius at topC10: =C9/2
1181.49in sqArea at topC11: =PI()*(C10^2)
120.00in sqArea at bottomC12: 0
1340.74in sqAverage areaC13: =(C11+C12)/2
14692.64in cuVolume in in^3C14: =C13*C7
153.00galVolume in gallonsC15: =CONVERT(C14,"in^3","gal")
Sheet6
Cell Formulas
RangeFormula
C8C8=C6*2
C9C9=C8/PI()
C10C10=C9/2
C11C11=PI()*(C10^2)
C13C13=(C11+C12)/2
C14C14=C13*C7
C15C15=CONVERT(C14,"in^3","gal")


My calculations came up with 3.0 gallons, which is not far off from 2.6.

But then I got to thinking. These are very flimsy plastic bags. They are not hard plastic that goes from a circle at the top to a line at the bottom. When filled with water or pretty much anything else, they will bulge out to the maximum cross-sectional area almost all of the way to the bottom, unless stopped by the side of the bin. So the maximum volume would be close to double the above calculation, or almost 6.0 gallons, which is more that twice what is stated on the box.

Can anyone shed any light on this?

Tomorrow, I'm going to see if I can find a bin that is close to the maximum area at the top and then fill a bag with water to see just what it can hold.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Hi,
Take a look at this calculation we're using. Be aware this is a theoretical volume calculation which doesn't include parameters for the strength of the bag or does take into account how stretch the material of the bag has. The calculation does take into account a certain amount of wasted space of the bag at the top as there would need to be a way to seal or close the bag.

Book1
ABC
1Conversion table
2Liter to US Gallon10,264172
3CM to Inch10,393701
4
5Volume Calculation
6Inch--> CM
7Width1640,64
8Length1743,18
9Closure space25,08
10
11
12LitersUS Gallon
13Volume9,3473672,469313
Sheet1
Cell Formulas
RangeFormula
C7C7=B7/C3
C8C8=B8/C3
C9C9=B9/C3
B13B13=((C7^2/PI())*(C8-(C7/2)-C9))/1000
C13C13=B13*C2


The calculation comes close to the 2.6 gallons as stated on the box.
 
Upvote 1
Hi,
Take a look at this calculation we're using. Be aware this is a theoretical volume calculation which doesn't include parameters for the strength of the bag or does take into account how stretch the material of the bag has. The calculation does take into account a certain amount of wasted space of the bag at the top as there would need to be a way to seal or close the bag.

The calculation comes close to the 2.6 gallons as stated on the box.
Wow! That is close.

I can't follow the formula, which is,

1661269554216.png


Can you explain the derivation?

Here's my implementation. If I reduce the closure to 1.62", I get 2.6 exactly.

Kitchen Scrap Bins.xlsx
BCDEF
4R/CCDEF
55ValueUnitsQuantityFormula
6616.00inWidth of bagC6: 16
7717.00inLength of bagC7: 17
881.62inClosure spaceC8: 2
9932.00inCircumferenceC9: =Wid*2
101010.19inDiameter at topC10: =Cir/PI()
11115.09inRadius at topC11: =Dia/2
121281.49in sqArea at topC12: =PI()*(Rad^2)
13130.00in sqArea at bottomC13: 0
141440.74in sqAverage areaC14: =(AreaTop+AreaBot)/2
1515601.38in cuVolume in in^3C15: = ((Wid^2)/PI()) * (Len - (Wid/2) - Close)
16162.60galVolume in gallonsC16: =CONVERT(VolCubIn,"in^3","gal")
Bag Vol 2
Cell Formulas
RangeFormula
C4:F4C4=col()
C9C9=Wid*2
C10C10=Cir/PI()
C11C11=Dia/2
C12C12=PI()*(Rad^2)
B5:B16B5=ROW()
C14C14=(AreaTop+AreaBot)/2
C15C15= ((Wid^2)/PI()) * (Len - (Wid/2) - Close)
C16C16=CONVERT(VolCubIn,"in^3","gal")
Named Ranges
NameRefers ToCells
'Bag Vol 2'!AreaBot='Bag Vol 2'!$C$13C14
'Bag Vol 2'!AreaTop='Bag Vol 2'!$C$12C14
'Bag Vol 2'!Cir='Bag Vol 2'!$C$9C10
'Bag Vol 2'!Close='Bag Vol 2'!$C$8C15
'Bag Vol 2'!Dia='Bag Vol 2'!$C$10C11
'Bag Vol 2'!Len='Bag Vol 2'!$C$7C15
'Bag Vol 2'!Rad='Bag Vol 2'!$C$11C12
'Bag Vol 2'!VolCubIn='Bag Vol 2'!$C$15C16
'Bag Vol 2'!Wid='Bag Vol 2'!$C$6C15, C9
 
Upvote 0
I did my best to fill one of the 16x17 bags with water. I used a 4-cup measuring cup. I was able to pour 9 4-cup loads into the bag before I couldn't keep it from spilling. That's 36 cups (9x4), which is 2.25 gallons (9x4/16). That pretty much in line with 2.6 gallon cvapacity on the box.

The shape of the bag when filled with water was definitely not a cylinder. It was more like a squashed sphere, which, I just learned, is called an oblate sphere.

1661300771594.png

The formula for the volume of an oblate sphere is,
1661300859119.png

As best as I could measure, the dimensions of my bag filled with water were about 11 x 6.

1661300953083.png


That would make the volume about 1.65 gal. But I could not fill it all the way up. I had 2-3 inches of bag in my fingers. Herfe are a few possible measurements.

1661301223313.png


And the bag was not really a perfect poblate sphere. It was wider at the bottom than at the top, maybe something like this:

1661301397289.png


All in all, the 2.6 volume claim is probably correct.
 

Attachments

  • 1661300859188.png
    1661300859188.png
    4.4 KB · Views: 22
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,313
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top