Lesson 4 - Editing Linked Data in the Worksheet

The data held in a Data Source module can be edited in the worksheet window. Changes made in the worksheet window are immediately visible in the Viewer window. In this lesson we will make a few changes in the worksheet and see how it affects the downstream modules.

 

To view the xyz1.dat module data in the worksheet:

  1. Click on the xyc1.dat module in the Network Manager.

  2. Click the Edit Worksheet button in the Worksheet field of the Property Manager. The module data is opened in a new worksheet window. Notice the document tab displays “Linked to:”, the module name, and the module ID. This indicates the worksheet is displaying the module data and not the xyzc1.dat data file.

  3. Click on cell E2 containing the “MW-1” label. The bold cell border indicates that cell E2 is now the active cell.

  4. Type a new label name, for example type BH-10 and press ENTER.

  5. Click the Data | Transform command. The Transform dialog opens.

  6. Change the Transform with setting to Column variables (e.g. C = A + B).

  7. In the Transform equation field, type B = 40 - (10-ROW()) * 4.

  8. Type 2 in the First row field and type 9 in the Last row field.

  9. Click OK in the Transform dialog.

  10. Now click on the Voxler1 project tab located above the Active Cell Location box.

A large number of data manipulations can be performed with the

Transform command.

 

 

Notice that the point formerly labeled “MW-1” is now labeled “BH-10” (or whatever you chose to name it). You can also see how changing the Y value for the first 8 points changed the scatterplot. Note that we changed the data for the xyzc1.dat module. The xyzc1.dat sample file is unchanged. To save a copy of changes made to linked data, click the File | Save Copy As command while viewing the data in the worksheet.

 

 

Back to Rotating Graphics

Next to Lesson 5 - Using Computational Modules