Tutorials
DR4 Help
 Archive Intro
 Table Descriptions
 Schema Browser
 Glossary
 Algorithms
 Introduction to SQL
 Sample SQL Queries
 Query Limits
 How To
     - Search
     - Graph
 FAQ
 API
 Download
 SkyServer Sites
 SkyServer Traffic Page
 Web Browsers
 Site News
 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.