OnlineConversion Forums Welcome to OnlineConversion.com Forums

Go Back   OnlineConversion Forums > Main Forums > Convert and Calculate

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.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-01-2008, 01:39 PM
tekkendork
Guest
 
Posts: n/a
Question 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 6-ft. 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 plug-in 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 5-stack by 5-stack 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
Reply With Quote
  #2  
Old 02-02-2008, 02:40 PM
gubment_cheez's Avatar
gubment_cheez gubment_cheez is offline
Ultimate Supreme Bacon Cheese Member
Long Time Member The Golden Calculator Award The Tree House Award Over 100 Posts
 
Join Date: Jan 2007
Location: Sac-o-Tomato, Cowafornia
Posts: 354
Rep Power: 8
gubment_cheez is on a distinguished road
Default 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
to use this, you can provide an inch measurement in B2, and it will spit out how much will fill that cubic volume, or you can goalseek in whatever dollar amount you want (by selecting the appropriate set cell in column G) and selecting B2 as the changing cell. alternatively, you can erase the HWD values in B2:D2 and use your own dimensions (e.g., 10 high, 20 wide, 15 deep)
__________________
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; 02-02-2008 at 02:56 PM.
Reply With Quote
  #3  
Old 02-04-2008, 04:05 PM
tekkendork
Guest
 
Posts: n/a
Default Re: Formula to determine cubic area of money stacks?

Quote:
Originally Posted by gubment_cheez
or you can goalseek in whatever dollar amount you want (by selecting the appropriate set cell in column G) and selecting B2 as the changing cell.
Thank you very much for your help (I never would have figured this out)

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
Reply With Quote
  #4  
Old 08-12-2013, 06:37 AM
Unregistered
Guest
 
Posts: n/a
Default Re: Formula to determine cubic area of money stacks?

What Is the cubic area of 1000 bills
Reply With Quote
  #5  
Old 09-27-2013, 02:18 PM
Unregistered
Guest
 
Posts: n/a
Default 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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 11:26 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 1997-2005, 2007, OnlineConversion.com