Spreadsheet Number format

There are three types of data that can be entered in the cells of the spreadsheet number, date/time, and text. For multiple entries of serial number with constant increment, enter the initial value into the first cell, highlight the cells, and select Edit -> Fill -> Series. To fill multiple entries of the same value into a range, enter the value into the first cell, move the pointer to the right-hand corner of the active cell to activate fill handle (a bold crosshair), and drag it through the range. Data are edited with the usual cut, copy, and paste operations in the Edit menu and the decimal places of scientific numbers is controlled via dialog box in Format -> Cells. 

A historical control database can take on many formats, from a simple spreadsheet (e.g., Microsoft Excel) to a fully searchable database that is interfaced or a part of the laboratory s computer data collection system. Most laboratories that conduct large numbers of studies according to GLP standards have a validated computer data collection system, and some of these systems automatically compile control data ftom studies so the user does not have to reenter the data into a separate historical control database. However, because of the inflexibility of the data acquisition systems, many laboratories still compile their historical control data by manually entering into a stand-alone database, such as customized spreadsheet format (e.g., Microsoft Excel). 

With the exception of the EPISUITE package, which is freely downloadable, all the products listed in Table 3.7 are commercial and charges are associated with their use. Most enable large numbers of compounds to be input at one time, using most common file formats such as SMILES,. mol, and. pdb. Descriptors may be extracted easily from most of these packages and transferred into spreadsheets for statistical analysis. Some of the products include some form of statistical analysis, although the use of dedicated external statistical packages is recommended in most cases. 

A very important facility is to be able to pass information to and from die spreadsheet. For many purposes die Cells statement is adequate. Each cell is addressed with its row first and column second, so diat die cell number (3,2) corresponds to B3 in alphanumeric format. It is dien easy to pass data back and forth. The statement x = Cells (5,1) places die value of A5 into x. Equivalently, Cells (i%, k%) = scores (i%, k%) places die relevant value of scores into the cell in die /th row and ktli column. Note diat any type of information including character and logical information can be passed to and from die spreadsheet, so Cells (7,3) = "Result" places die word Result in C7, whereas Cells (7,3) = Result places the numerical value of a variable called Result (if it exists) in this cell. 

Figure 8-5 Generating 10 random numbers from 1 to 1000 by use of a spreadsheet. The random number function in Excel [=RAND ) ] generates random numbers between 0 and 1. The multiplier shown in the documentation ensures that the numbers generated in column B will be between 1 and 1000. To obtain integer numbers, we use the Format/Cells. .. command on the menu bar, choose Number and then 0 decimal places. So that the numbers do not change with every recalculation, the random numbers in column B are copied and then pasted as values into column C using the Edit/Paste Special.

Under the Format menu bar are several options that make your spreadsheet more readable. With the Format/Cells... you can change the way numbers are displayed, the alignment of them within the cell, and the font properties. You can also set a border around some cells, and change the pattern or color (the Color option is inside the Pattern option). You can even protect the spreadsheet or parts of it so others cannot change it. 

If there is any line in the map file that does not have six columns in the correct format, GenomeViz will show an error, point out the incorrect fine number and the column, and stop the plotting. In such as case, one must identify the error, correct it, and redo the plot again. The map file format is easy to maintain and modify in simple text editors or spreadsheets, and the extensive format checking performed by GenomeViz before plotting helps identify and correct mistakes before they are incorporated in the plot. The map file alone is sufficient for plotting numerical data, but both the map and tag files are needed to plot classification-type data. The type of data, qualitative or quantitative, is automatically detected from the map file. 

Many aspects of the spreadsheet proper can be changed with Format => Style => Modify, including the way numbers are represented, the font used, cell borders, colors, and patterns. 

The values calculated by Excel are shown in cells B12 and B13. Of course they must be rounded off to the correct number of significant figures, but are the same as the results obtained manually. Learning to use spreadsheets can save time and permit the data to be stored, processed, and presented in a variety of formats. The spreadsheets can be made part of the electronic lab notebooks that are common in industry and government laboratories as well as in many college laboratories. 

The main CodeGen algorithm is called for each synthesis step. All of the tag codes start with the number of tags used, 1,2, or 3. Then the tag codes are listed in alphabetical order separated by commas. The tag assignments are reviewed with the show list button. Once the user is satisfied with the tag lists an Excel spreadsheet formatted as Table 9.2 can be obtained and the tag information is saved to a temporary file. 

Using the pK values listed in Appendix B for various ligands which are also Bronsted bases, develop spreadsheets and EquiligrapHs for a number of common ligands. Preserve these for use in conjunction with questions concerning the role of pH in metal complex formation that will be introduced in Chapter 5. 

We adopt a standard format in this book in which constants are collected in column A. Select cell A1 and type Constant as a column heading. Select cell A2 and type CO = to indicate that the constant Cq will be written in the next cell down. Now select cell A3 and type the number 273.15. Your spreadsheet should now look like Figure 3-3b. 

To home in on an exact volume (such as /e), set the spreadsheet to show extra digits in the cell of interest. Tables in this book have been formatted to reduce the number of digits. 

---