Computers Lotus

Voice mail can be extremely helpful in facilitating information transfer, especially for informal exchanges among dispersed teams. On a larger scale, interactive computer programs such as Lotus Notes enable teammates in multiple locations to work simultaneously on a single assignment. 

A simple linear regression is very easily computed with an ordinary computer spreadsheet program such as Lotus 1-2-3 or Microsoft Excel. The method involves calculating first the average values of x and y, then the values of Co and Ci, and then the estimated value of y ... 

The next type of standard output is the spreadsheet. These file formats use comma-separated ASCII code, but also add calculation information and addressing information for the columns and rows they occupy. The simplest of these are. DIF files, which originated to allow information transfer between VisiCalc worksheets in the Apple II computer and have been retained as a standard format.. WK files are Lotus-1,2,3 formats and. XLS are Microsoft Excel formats that have become spreadsheet standards, allowing transfer of data, calculations, addresses, and macro programs. 

Another of the most important features of LOTUS is now used. In 117 one puts in the equation for DaoW, in M17 the one for DDr, etc. The result will be that as soon as the experimental values needed to compute the equations have been filled in column W, the result of the computations will appear in row 17. Let us now see how this is done in practice. There are in fact two ways to do it, namely by using the pointer or by typing. The latter has our preference. One moves first the pointer to cell 117. Then one types the pertinent equation using the cell addresses, where the information needed is stored. For instance, the first element in the equation for DA is Yi. This is found in W8 and therefore in the worksheet equation W8 replaces Yi. The equation in 117 should be ... 

Whenever possible, line and bar graphs should be constructed with the use of computer graphing programs (CricketGraph, Excel, Lotus, etc.). Aside from the fact that they produce graphs that are uniform and visually attractive, they have the added capability of fitting non-ideal data to a best-fit line or polynomial equation. This operation of fitting a set of data to a best-fit line becomes extremely im-... 

In the case of the original expanded memory, the actual memory was installed on a special hardware board installed in the computer, and the driver that was loaded was actually a hardware driver for the board. Incidentally, the reason that all three companies got involved is rather unique. Intel developed one of the first expanded memory boards, called the AboveBoard, which was used by people who wanted to make larger spreadsheets with Lotus 1-2-3, which ran primarily under MS-DOS (made by Microsoft). Expanded memory can be utilized on any computer from the 8088-based PC to the Pentium and higher. Depending on the motherboard you were using, you could install as much as 32MB of memory to be used as expanded memory. 

Computer Microsoft Office, Powerpoint, Lotus Freelance and Notes,... 

Barnes S-J, 1988, Automated plotting of geochemical data using the Lotus symphony package. Comput, Geosei., 14, 409-411. 

Before closing this section it should be mentioned that most of the methods discussed above can be solved using commercially available programs such as symbolic computation (Mathematica, Maple, or Mathcad 3.0), equation solvers (TK Solver Plus or Mathcad 3.0), spreadsheets (e.g., Lotus 123, Quattro Pro, Microsoft Excel, or Wingz), simulators (Extend or Stella), or Microsoft FORTRAN 5.0. For example, one can introduce the idea of molecular mechanics on model systems using a spreadsheet. Actual applications of molecular mechanics are much better carried out on a software package designed for that purpose, however. 

A major objective of this book is help you become familiar with and confident about the important ideas used by analytical chemists. These ideas are also essential to others who make physical and chemical measurements the basis for their decision-making. This includes chemists in general, engineers, physicists, physicians, etc. In it we will examine the ideas themselves and their relation to each other. By this means, we will by develop appropriate, rigorous equations which will be made "user friendly" by the techniques used here to solve them. Together we will conquer all tedious and repetitive arithmetic operations with the help of a computer spreadsheet program. The one we use is called Quattro Pro (QPro). We will give references in the text to the QPro menu and commands as well as those for Lotus 123, and the older Quattro version can be called up. 

Modern XRF analytical software is open for easy integration into customized software packages, e.g. user-specific programs for process and quality control, and computer networks without influencing the reliability of the standard software product. All analytical results can be stored as standard LOTUS 1-2-3 or EXCEL worksheets and ASCII data files to be accessed by most commercially available programs. 

The earliest computer network communications application, e-mail, is sfiU the largest and most successful network application. One accesses e-mail services through an e-mail client. The client can be a stand-alone program, such as Outlook Express or Eudora, or it can be browser based, using Internet Explorer or Foxfire. The e-mail server can be a proprietary system such as Lotus Notes or one of the... 

A special feature in this book is the inclusion of the Hansen solubility parameter theory that can be used to classify solvents in terms of their nonpolar, polar and hydrogen bonding characteristics. Use of the Hansen solubility parameter theory will allow the worker to systematically search for a solvent substitute or determine the solubility of a resin/polymer in a certain solvent or solvent blend. The files necessary to construct computer spreadsheets that can utilize the Hansen solubility parameter theory are included with this book. The useful spreadsheet files on a computer disk are included in a plastic pocket on the back inside cover of the book. These files can be used on an IBM-compatible computer with Lotus 123 (or Excel) software. These computer spreadsheets were developed in the Lotus 123. WKl file format. The data files can be used with the Lotus 123 Version 5.0 for Windows, the Microsoft Excel Version 5.0 for Windows or any earlier version of the spreadsheet software. The files can also be translated into the Macintosh Excel format if the correct version of Excel is available. The coating industry will find the information on solvent substitution using the Hansen solubility parameter theory of particular interest. The use of computer spreadsheets to compare the solubility envelope of the polymer with likely solvent candidates has been very helpful to the author in past work and others in the coating in selecting substitute solvents or solvent blends. The Hansen solubility parameter values for 166 resins and polymers and 289 solvents are listed. 

Table 17.3 compares the solvency of a 60 vol% nitroethane and 40 vol% toluene blend for a nitrile-butyl rubber as compared to the solvents cyclohexanone and N-methyl 2-pyrrolidone. A Lotus 123 spreadsheet, DECITREE.WKl, was used to generate Table 17.3. This spreadsheet is included on the computer disk accompanying this book. The spreadsheet allows one to compare the solubility parameters of solvents with a selected resin. The values for the selected resin are supplied by the user while the solvent data is available from the lookup tables. The typical R values are calculated and the location of...

The total solubility parameter of a resin or polymer is the point in three-dimensional space where the three partial solubility parameter vectors meet as the center point of the idealized spherical envelope. The distance in space between the two sets of parameters (solvent and polymer) can be represented by the radius of interaction term, R. The radius of interaction term is used to express the degree of mutual solubility. All of these solubility comparisons can be made by using computer spreadsheets that are described in this chapter. These computer spreadsheets were developed in the Lotus 123. WKl file format. The data files are listed on the IBM compatible computer disk in the Lotus. WKl and can be translated to Excel for Windows format. 

A backup copy of the data files on the computer disk should be made onto a formatted 3.5 in. disk before using the files in any solvent-resin calculations. It is suggested that the Lotus. WKl files be copied to the appropriate spreadsheet directory on the computer hard drive for faster operation of the spreadsheets. The directions needed for proper operation of the spreadsheet are listed at the top of each spreadsheet. Any spreadsheet data and calculations that need be saved should be saved under a different file name. Any solvent or resin/polymer numbers that are typed into the appropriate spreadsheet cells must be listed in numerical order for the lookup function to work correctly. The data files can be used with Lotus 123 Version 5.0 for Windows, Microsoft Excel Version 5.0 for Windows, or any earlier version of the spreadsheet software. Anyone familiar with the use of macros in spreadsheets can undoubtedly automate the operation of some of the spreadsheets contained on the computer disk. 

The new nonpolar, polar, and hydrogen-bonding values for the solvent blend are calculated in three separate equations utilizing the three solubility parameter values of each blend solvent. The computer spreadsheet data files TERTBLEN.WKl and 7BLEND.WK1 (Figures 19.1 and 19.2) can be used to automatically calculate the solvent blend parameters. Blends of two or three solvents with different solubility values can often yield a solvent blend with intermediate values that may better match a specific resin. As shown in Chapter 4 two nonresin solvents can be blended to give a solvent mixture that dissolves the resin. These data files can be loaded into the Lotus or Excel software directory and used to calculate the solubility parameters of the solvent blend. The solvents of choice are selected from a list of 289 solvents by listing the solvent number in the proper spreadsheet cell. The solvent name and solubility par-... 

FigurO 19.1 Computer data spreadsheet in Lotus 123 format can be used to calculate the partial Hansen solubility...

---