7. Spreadsheet

The spreadsheet window is used to view, compute, and analyze data associated with molecules and can be seen in Figure 7.1. The spreadsheet window contains three initial spreadsheets by default: Molecules, Proteins and Atoms. The Atoms spreadsheet is slightly different in behavior from the other two and is described later.

The Molecules spreadsheet is populated with all currently loaded small molecules (fewer than 255 atoms). Conversely, the Proteins spreadsheet is populated all currenty loaded molecules that have more than 255 atoms.

The columns and their associated values are populated from SD data. SD data can be found in both SDF and OEB files. Additional spreadsheet columns can also be added by computing expressions (see Section 7.5) or by importing external data from a comma-seperated value (.csv) or tab-seperated value file (.txt) (see Section 7.9).

Figure 7.1: Spreadsheet window
 
spreadsheet1.png


Subsections