Spreadsheets are very useful tools for scientists. They allow us to enter data from experiments very easily into neat and tidy tables, (the standard way of presenting your results), allow complex manipulation of the results, and will even create graphs. As an example, we may have measured voltage (V) and current (I) in an experiment. The data can be put into a spreadsheet, and the software can be told to combine the two to find RESISTANCE (R), or POWER (P). The relationships:
Spreadsheet tables are separated into cells. In the example above, we have cells with Text, Numbers and Formulæ. We refer to a cell by the Column LETTER followed by the Row NUMBER. Thus, cell 'a1' contains the text: "Current, I (amps)", and cell b4 contains the number '1·5'. When we create forumlæ, we refer to cells containing numbers and perform mathematics on them. For example, the cell d2 needs the formula (a2*d2). Thus, only Current and Voltage were entered into the sheet, Resistance was found by entering (b2/a2) in cell c2, and copying this formula into the rest of the table. Power was found in a similar fashion, i.e. (a2*b2). A * is used to mean multiply, and / to mean divide.
When you include spreadsheet tables in a write-up, you should, however, explain what you are getting the spreadsheet to do. Most spreadsheet packages use a similar method of formula entry to that above - refer to your own manuals if in doubt.
A few hints:
The table 2 below shows an example that you should follow:
Spreadsheet tables often print terribly. Yes, you will have saved time on calculations by entering the data for analysis, but the final result can be disappointing. Exporting the spreadsheet as a comma separated variable (CSV) file, into a specialised table creator (e.g. the TableMate series for RISC OS) will solve this problem.
If you would like to make comments or suggestions about these pages,
Last updated Monday 19th February 2001 | Top ^^