Add Data to a Spreadsheet

Add data from Genstat

You can append new columns to an existing spreadsheet by loading additional Genstat data structures. To add new columns select Spread | Add | Data in Genstat. Note that to add a column (data structure) it must contain the same number of rows as the structures within the current spreadsheet, otherwise it will be opened within a new spreadsheet.

Add data from a file

You can append new columns to an existing spreadsheet by loading additional data from a saved file. To add new columns select Spread | Add | Data file. Note that to add columns (data structure) from the file they must contain the same number of rows as the structures within the current spreadsheet in Genstat.

Calculate new columns

You can create new columns within an existing spreadsheet by calculating values from existing columns or other Genstat data structures. The new columns must have the same number of rows as the current spreadsheet. New columns can be calculated using the Calculate menu.

Create new rows and columns

You can extend the spreadsheet by inserting new rows or columns and typing in the data values. You can also use the Clipboard or the Column Fill menu to automatically generate data that contains patterns of values.

Getting columns from another spreadsheet

You can transfer columns between open spreadsheets using Spread | Column | Get/Move. To move columns between spreadsheets both must contain the same number of rows.

Add results from an analysis

You can append new columns to an existing spreadsheet by saving the results from an analysis. Data can be saved using the Save buttons on the Data or Stats menus and then displayed in a spreadsheet by selecting the Display as spreadsheet option. If the number of rows matches the spreadsheet containing the original, then you can use the Get/Move dialog to add the results to this spreadsheet.