Below is a typical layout of a spreadsheet. Across the top are the columns indicated by letters. On the left are the rows indicated with numbers. The boxes where you type are called cells. The location of a cell in defined by its column letter and row number. For example, the cell where the number "19.3" is located is D1. To do dimensional analysis in a spreadsheet just type the number in one cell and the dimension next to it. The spreadsheet lets you layout the problem so you can see all the units. You can even color the units that cancel and the ones that will remain. That helps you see you have it set up correctly.
 A B C D E F G H 1 355 mL x 19.3 g = ? grams 2 1 mL
 By the way, it's possible to turn off the grid lines to make the setup look more like a standard equation
 A B C D E F G H 1 355 mL x 19.3 g = ? grams 2 1 mL

 To get the spreadsheet to calculate your answer, you would go to G1 and type an equal sign "=". That tells the spreadsheet that you are putting in a formula. Then click on A1 where the 355 is sitting. The spreadsheet will insert "A1" into the formula. Then type an asterisk "*" which means to multiply. Then you click on "19.3" and "D1" will appear in the formula, which will now read "=A1*D1". Then press the Return (Enter) key, and the answer will then appear because it's been told to multiply A1 by D1. You can then type different values for the volume (A1) or density (D1) and after typing a new value press Return key or click out of that cell and the new gram amount will automatically be recalculated. So the beauty of a spreadsheet is that after you set up one problem. It can be used to calculate different values of volume or density without going through the calculations again. It also keeps it all organized so you don't make mistakes.
 The below table is like the top one but I've set it up so you can type in values for the volume and density and it will calculate the grams automatically. Initial values are for 10mL of water, which has a density of 1.0 grams per mL. Try changing the density to 19.3 (density of gold) and the volume to 355 (volume of soda can). Click the "D Calculation" button to have it do the calculations. On a Web page we need a button to cause it to calculate. Then try some other volumes and densities.
 A B C D E F G H 1 mL x g = grams 2 1 mL
 Using spreadsheets is especially helpful when you have a long series of calculations because you are more prone to make mistakes doing it with a calculator. Let's do the conversion of miles per hour into centimeters per second. The first 3 conversion fractions is to convert miles to centimeters. The next 2 is to change hours into seconds. I put all units (dimensions) that cancel in red and those that don't in green. Again, units cancel if one is in numerator and one is in denominator. To calculate the answer, we multiply all numerator and divide by each denominator. So go to cell S1 and type an equal sign "=". Now click on the "2" next to miles. Now type "*" to indicate multiplying. Now click the "440" followed by typing "*". Now click "36" followed by typing "*". Then click "2.54". No need to click on the ones. Now type "/" to indicate you want division. Now click the "0.25" followed by typing "/". Now click "60" followed by typing "/". End by clicking the other "60". At this point the formula will read "=A1*D1*G1*J1/D2/M2/P2". Press Return key and the answer will appear. The beauty of this again is that now all you have to do is change the number of miles and you automatically get the new centimeters per second.
 A B C D E F G H I J K L M N O P Q R S T 1 2 miles x 440 yards x 36 inches x 2.54 cm x 1 hr x 1 min = ? cm 2 hr 0.25 mile 1 yard 1 inch 60 min 60 sec sec
 In the below spreadsheet, I put in an input text field for the miles per hour. When you click the Do Calculation button, it will do all the calculations to get centimeters per second. So it shows how easy it is to find answers to a long series of calculations. It also keeps you organized and reduces dumb mistakes. Searching the web for the conversion of miles per hour to centimeters per second can be found as one conversion factor (it's 1 mph =44.704 cm/sec); however, there will be other calculations where you can't look up a shortcut and will have a long series of conversions.
 A B C D E F G H I J K L M N O P Q R S T 1 Start velocity miles to yards yards to inches inches to cm per hr to per min per min to per sec desired units 2 miles x 440 yards x 36 inches x 2.54 cm x 1 hr x 1 min = cm 3 hr 0.25 mile 1 yard 1 inch 60 min 60 sec sec

Number of visitors (not hits) since Aug, 2009