|Introduction to SQL|
|Form Query User Guide|
|SkyServer Traffic Page|
|Contact Help Desk|
Create a New Column from a Calculation
To learn how to use Excel to do calculations, let's say we wanted to create a new column that contains the value of the color (difference in magnitudes) u-g for each star.
First, click on the top cell in your new column and type a label. Next, click on the cell just below the label. Type the equals (=) sign. Next, click on the column for u in the same row. Type the minus (-) sign. Click on the column that contains the g value. The spreadsheet should look like it does below:
Hit Enter and the spreadsheet will calculate u-g for that cell.
Next, select all cells in the u-g column (except for the label). Click the Edit menu. Select Fill and then Down. The entire column will now have the u-g value for the star in its row.