Creating and Editing Columns

You can create a new column that is manually entered or based on calculations. The new column can calculate important results from other data in Logger Pro. For example, if you have current and voltage data, you can create a new calculated column to calculate current times voltage, or power.

Creating a New Calculated Column

Create a new calculated column by choosing New Calculated Column from the Data menu, or click the New Calculated Column button in the Data Browser. The arithmetic operators ("^", "*", "/", "+", "-"), parentheses, and the mathematical functions that you type in are used to create a new column based on one or more existing columns.

1. Name the new column by editing the text in Name and Short Name text boxes.
2. Enter units in the Unit box. You can choose a symbol, from the drop-down menu.
3. Enter a formula in the Equation text box. The definition can contain numbers, calculator functions (sin, sqrt, etc.), other columns, or functions such as smoothAve or derivative. You can either type the formula or select item(s) from the list of functions. Access the names of the other columns by choosing from the Variables (columns) menu. Access the additional constants by choosing from the Constants menu.
4. You can customize the column colors, assign point symbols, etc. in the Options tab.
5. Click Done when the information is complete.

Creating a New Manual Column

Create a new manual column by choosing New Manual Column from the Data menu or click the New Manual Column button in the Data Browser. Manual columns can contain values that you enter manually in the data table or Logger Pro can populate the column with generated values such as names of the month.

1. Name the new column by editing the text in Name and Short Name text boxes.
2. Enter units in the Unit box. You can choose a symbol, from the drop-down menu.
3. If you want the column to contain non-numeric values such as dates, change the Data Type. For more information, click here.
4. You can generate numbers for the manual column by checking Generate Column. For more information about these options, click here.
5. You can customize the column colors, assign point symbols, etc. in the Options tab.
6. Click Done.

Editing the Properties of an Existing Column

Changing options for a single column

You can change options for a single column a few different ways. Any of the options below will bring up the Column Options dialog box.

• Right click in a table (Windows) or Ctrl-click (Macintosh), choose Column Options then choose the column you want to change. Here, the column's data set name will appear before the column's name.
• Double click a column's name in the data table.
• Choose Column Options from the Data menu.
• Double-click a column in the Data Browser.

Changing options for multiple columns

You can change options for multiple columns as long as they share the same name.

1. Choose Column Options from the Data menu.
2. Next, pick the column name you wish to make changes to. Note: Any changes you make will be made to ALL columns with the same name.

See Also:

• Adding and managing multiple data sets