Software Excel

While serious research of the behavior of CA systems demands the use of dedicated hardware, the often high cost of such hardware sometimes prevents its acquisition, particularly by young researchers and graduate students just entering this field of study. It is therefore important to realize that there are many excellent software-only solutions that can often be used very effectively for research. While the list provided below is by no means exhaustive, it gives some idea of the kind of packages that are currently available either commercially or via anonymous ftp over the Internet. 

The excellent software BERKELEY-MADONNA enables a more modern, Windows-based (also Macintosh compatible) and menu driven solution. 

Microsoft Excel software (Microsoft Corp., Redmond, WA). 

To examine the quality of the data set, each data set is plotted against the data set of nonimmunized mice (N) using Excel software. 

Lines indicating twofold gene expression changes are drawn using the Excel software. The majority of the data points should lie within these lines. For low-quality data, many data points would be spread outside the line for the twofold gene expression changes at lower intensity values (9,10). 

Prices of the software, which range from essentially free to more than 100,000 (U.S.), are not included because they are subject to change and specific conditions. In some cases, particularly with respect to QCPE (Indiana University, Bloomington, Indiana), significant software, which has been verified with respect to expected output, can be obtained at practically no cost. Users of software should be optimistic about prices. With so much excellent software and so many suppliers now vying in the marketplace, prices will be under increasing competitive pressure. 

The principle of mass conservation, on a macroscopic basis, using equations representing the conservation of total mass, the conservation of each chemical element and the mass balance for each of the molecular species was applied. Chemical reactions were taken into account in these equations. The stoichiometric coefficients of individual reactants were evaluated using Microsoft Excel software by expressing the equations in matrix notation. 

The Group Theory Calculator [the GT Calculator] is the set of interactive EXCEL spreadsheet files, one for each of the main molecular point groups, on the CDROM supplied with this manual. The group theoretical calculations, which can be performed with the calculator, are rendered possible because of the enhancement of the basic spreadsheet operations and displays using Visual Basic for Applications code and the complex-arithmetic routines available in the Analysis Tool Pack EXCEL Add-ins . Since the Analysis Tool Pack is not one of the standard components loaded in a typical installation of the EXCEL software package, it is necessary, before attempting to use the GT Calculator, to ensure that your version of the EXCEL programme includes this extra component. With any spreadsheet open, check the Add-ins list in the TOOLS menu on the main EXCEL toolbar and, if necessary, install this component in the usual way. 

For each example, a solution was obtained by applying Eq.(2-23) and the EXCEL software. The solution is presented graphically, which demonstrates the dynamical behavior of the system in occupying the various states under consideration. Such an information was missing in the above refs.[2-8, 15-18, 84]. The latter contained only the one-step transition matrix, termed also as policymaking matrix. 

At the NEA Data Bank, Pierre Nagel and Eric Lacroix have provided excellent software and advice, which have eased the editorial and database work. Cynthia Picot, Solange Quarmeau and Amanda Costa from NEA Publications have provided considerable help in editing the present series. Their contributions and the support of many NEA staff members are highly appreciated. 

Select all the text in the file and COPY/PASTE into cell A 3 of a new worksheet, figl-9.xls. With luck, the EXCEL software will parse the pasted information into columns A and B of the worksheet. If not, open the TOOLS dropdown on the EXCEL toolbar and select the TEXT to COLUMNS option. Follow the wizard s instructions and the radial mesh data will separate in column A from the numerical wave function data, which will appear in column B. 

This exercise introduces two new features of the EXCEL software the matrix multiplication and transpose macros MMULT() and the TRANSPOSE(). These are best activated using the =/ icon on the TOOLBAR and the option to drag out the array data to be multiplied, visible in the function window. You select an equal area of blank cells on the spreadsheet and then activate the MMULT() or TRANSPOSEO macros. Note too that after selecting the particular area for each array, the sequence to enter these cell references requires CTL/SHIFT/ENTER. Otherwise, only one entry will appear in the top-left hand cell of the chosen active cells for the operation. 

Calculations using Gaussian lobe functions (47, 48, 85) are not used in modem program packages. However, since it is not possible to carry out a spreadsheet calculation with higher order Gaussian functions, because the function library of the EXCEL software does not include the derivatives of the Error Function, a simple Gaussian lobe calculation illustrates well the effect of polarization functions. 

In addition, the catalytic cycles and the corresponding chemical parameters have been entered into a database of palladium-catalyzed reactions. As well as the various examples quoted in the publications, it is possible to view either the general catalytic cycle (RXN) related to each reference or all the chemical parameters related to a reaction number. For each reference, one or more examples have been selected with respect to the reaction. ISIS software (version 1.2) from MDL, EXCEL software (version 5.0c) and WORD software (version 6.0c) from MICROSOFT have been used. At the present time, this database is made available to many research centres by the Rhdne-Poulenc company. An example of the database form is shown over the page. 

The reader needs to become familiar with the following topics regarding Excel software, using the related literature ... 

A set of values of Qlk are obtained with changing the parameter of H which ranges from 0 m to 120 m water column. The results with regression analysis by EXCEL software are shown in Figure 5. It could be find that the relationship between the water inflow and the hydraulic conductivity is linear for this specific case, which means that the assumption of Eq. (4) is at least suitable for this project, and values of S and C are 118.86 and 3.21, respectively. 

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 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-... 

The required data for this research was collected from operation and maintenance reports and direct field observations over a period of two years. Many of the desired information, such as failure occurrence times, reasons of failure, types of repair actions and time to repair were available in mine database, therefore only TBFs values were calculated. All needed calculations related to data analysis and reliability modeling were carried out using Easy/it and Microsoft Excel software. 

Note that using eqs. (10-3) and (10-4) require an iterative calculation since the value of the Reynolds number determines the flow regime and thus which equation to use. On the other hand, to evaluate the Reynolds number, one needs the value of Vt. Such problems are easily solved with an equation solver such as TK Solver software from Universal Technical Systems, Inc. or Microsoft Excel software. 

In both India and China (but most particularly in India) in the past two decades, the IT industry has relied on providing quality software services in a cost-effective manner. It has effectively leveraged the huge difference between the labour costs of equivalent skills in India and the developed part of the world. IT companies have developed excellent software engineering processes to manage such projects effectively. For example, the largest number of CMM level 5 companies is in India [8]. 

Correlation coefficients (r = correlation coefficient of Pearson) between the data of solid-phase microextraction (SPME) analysis and the data of time-intensity sensory analysis, were calculated with Excel software. 

Microsoft Office Excel Software (Microsoft, Redmond, WA) Personal computer... 

---