Welcome to OnlineConversion.com Forums 

Convert and Calculate Post any conversion related questions and discussions here. If you're having trouble converting something, this is where you should post. * Guest Posting is allowed. 

Thread Tools  Display Modes 
#1




Formula to determine cubic area of money stacks?
I am trying to generate an infographic that compares the size of a stack of money to a 6ft. tall human.
There will be various sums of money ($1.2 billion, $47.6 million, etc.) so I'm hoping to create the formula in Excel and just plugin the different dollar amounts to determine the area. A $100 bill is .0043 inches thick (.10922 mm), 6 inches wide (152.4 mm) and 2.5 inches tall (63.5 mm) So a stack of one thousand $100 bills ($100,000) is 4.3 inches thick. If I'm displaying a single stack, it's not a problem. But I may want to have multiple stacks (say a 5stack by 5stack array) so the money amount will look more like a cube than a giant, single column. This is what's giving me trouble. How can I create a formula to see how big a cube of x number of dollars would be? Thanks for your help. Sorry if this is confusing 
#2




Re: Formula to determine cubic area of money stacks?
a cube is a volume that is equal on all three sides (it has the same depth, height, and width) based on that, I've created an excel calculation that takes the dollar amount of bills, and uses the goalseek command to find the cubic size of the bills. since the bills themselves aren't cubic, I've added a calculation that returns the real size taken by the bills. (bold underline text is only for reference, and not a part of the equation)
Code:
A1 height width depth volume $1 =E3*1 size requested (in inches) B2 =B2 =B2 =D2*C2*B2 $2 =E3*2 number of bills =QUOTIENT(B2,0.0043) =QUOTIENT(C2,6) =QUOTIENT(D2,2.5) =D3*C3*B3 $5 =E3*5 actual size =B3*0.0043 =C3*6 =D3*2.5 =D4*C4*B4 $10 =E3*10 $20 =E3*20 $50 =E3*50 $100 =E3*100
__________________
duct tape duct tape it's better than glue fixes stuff just like new be prepared throughout your life keep a roll beneath your pillow at night Last edited by gubment_cheez; 02022008 at 02:56 PM. 
#3




Re: Formula to determine cubic area of money stacks?
Quote:
Could you help me understand the above quote? For example, if I'm trying to find the size for $1,500 Again, I appreciate your help 
#4




Re: Formula to determine cubic area of money stacks?
What Is the cubic area of 1000 bills

#5




Re: Formula to determine cubic area of money stacks?
The basic formula for cubic area (i.e. volume) is Length * Width * Height. Substitute the thickness for the height, and work from there.

Thread Tools  
Display Modes  

