Spreadsheets translations

It doesn t matter whether or not you use spaces around the arithmetic operators.) When you hit RETURN, the number 0.99997 appears in cell C5. The formula above is the spreadsheet translation of Equation 2-4. A 6 refers to the constant in cell A6. (We will explain the dollar signs shortly.) B5 refers to the temperature in cell B5. The times sign is and the exponentiation sign is A. For example, the term A 12 B5A3 means (contents of cell A12) X (contents of cell B5)3. ... 

In the case of the spreadsheet, a considerable GUI will be required to display the spreadsheet, to translate mouse operations into the specified incoming messages, and to direct them to the appropriate cells. 

The implementation s vocabulary should be translated to the specification s by using retrieve functions as in Section 6.4, Spreadsheet Model Refinement. 

This equation must be translated into the actual weighings required so that a spreadsheet can be drawn up. Errors can easily occur in the calculations unless the individual steps are understood. The sample weight is 0.5000 g and the calculation formula and any spreadsheet must be designed for this and allow for the fact that the original ash is carried out on 1.0000 g. The residue of undigested sample contains four components of the calculation ... 

Translate. You can transfer data from the spreadsheet program to other application programs, and vice versa. For instance, ASCH text files from BASIC programs can be transferred to and from the spreadsheet program through appropriate commands. 

Run hs.exe and copy the output data for the lithium 2s radial function onto columns A and B of a new spreadsheet. This means that the Thomas-Fermi mesh will be the radial mesh for the remainder of the exercise. For simplicity delete column A the dimensionless x-mesh. Label the remaining columns of translated data from the Herman-Skillman output file, r[TF], r/ (rXi-2s) and enter the headers RDF-Li 2s and RDF-Slater in cells C 5 and D 5. 

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. 

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. 

---