Excel macros

The copper cyanide bath has excellent macro-throwing power and is chosen whenever irregular-shaped parts are to be plated. The sulphate bath is not inferior when parts with very narrow recesses, i.e. with width of opening less than 6 mm, are to be plated, although its macro-throwing power is... 

Solution The following is a complete program for performing the calculations. It is written in Basic as an Excel macro. The rather arcane statements needed to display the results on the Excel spreadsheet are shown at the end. They need to be replaced with PRINT statements given a Basic compiler that can write directly to the screen. The programming examples in this text will normally show only the computational algorithm and will leave input and output to the reader. 

An Excel macro is given in Appendix 7.2, and some results are shown in Figure 7.7. The macro is specific to the example reaction with v = - -l but can be generalized to other reactions. Components of the macro illustrate many of the previous examples. Specific heats and enthalpies are calculated analytically using the functional form of Equation (7.19) and the data in Tables 7.1 and 7.2. The main computational loop begins with the estimation of Kthermo using the methodology of Example (7.15). 

The following Excel macro illustrates the use of the trapezoidal rule for evaluating both the numerator and denominator in this equation. 

These results were calculated using the following Excel macro ... 

The overall solution is based on the method of lines discussed in Chapter 8. The resulting DDEs can then be solved by any convenient method. Appendix 13.2 gives an Excel macro that solves the DDEs using Euler s method. Figure 13.9 shows the behavior of the streamlines. 

The Excel macro findpeak.xls imports the data from the. CSV files into an Excel spreadsheet. This imports all of the. CSV files containing all the mass spectra of one Total Ion Chromatogram. The user may import as many data files as desired for comparisons. 

The EC 10 was calculated using a non linear regression procedure that is available as an Excel macro at the following link http //eric.vindimian.9online.fr... 

Figure 5.8 Examples of duplicate-replicate plots from soil analyses from the Geochemical Baseline Survey of the Environment (G-BASE) project generated by an MS Excel macro (for the relationship of control samples, see Fig. 5.4). Note that the cited detection limits for Cu, U and I are 1.3, 0.5 and 0.5 mg/kg, respectively.

Excel macros for MLR, PCA, PCR and PLS as described in Section A.4.6.2, written by Tom Thurston, based on original material by Les Erskine. These are freely available for private and academic educational uses, but if used for profit making activities such as consultancy or industrial research, or profit making courses, you must contact bris-chemom bris.ac.uk for terms of agreement. 

A password is required for the Excel macros and Madab procedures, as outlined in the website this is available to all readers of the book. This corresponds to a specific word on a given line of a given page of the book. The password may change but there will always be current details available on-line. If there are problems, contact chemometrics wiley.co.uk. 

An example of automated purity assessment of a compound analyzed by LC/UV/MS is shown in Figure 11-4. In this example, purity is assessed at two different wavelengths, X220 and L254. Excel macros are used for automated... 

Excel macro generating pipetting tables from a list of sequences is available online (www.5z.com/mlebl/macros.html). The area of grafted solid supports in peptide synthesis was recently reviewed (17). 

This is the variation of all samples that are j time units apart. Division by makes it a relative variance. An example is given in Figure D.l with code for the Excel macro given in Table D.l. 

You can use a scanner and a software program that performs optical character recognition to create a data file from hard copy. Once imported into Excel, the data may have to be manipulated to get it into a useable form. The following example shows how to record a simple Excel macro for converting scarmed data with blank lines and other undesired features into useful columnar data. 

In early spreadsheet programs, a macro was simply a string of keystrokes that could be recorded, saved and repeated to automate a simple keyboard operation. In Microsoft Excel, macros are written in a complete programming language that provides the capability to perform iterative calculations, or to take different actions based on the results of logic functions. 

Macro programming was introduced in Excel 4.0. A macro written in Excel 4.0 Macro Language (XLM) is a series of statements or commands cn an Excel macro sheet, which looks much like an Excel worksheet, with rows and columns. Macro statements in XLM can use any of Excel s worksheet functions, but in addition there are over 400 macro functions that can be used. Macros written in XLM can still be run in Excel 2000. 

As an alternative to the Add-In, users can also develop their own Excel Macros to call the programmable interfaces that have been published. 

It may be useful to dissect the macro Power 1, because it contains five common, distinctive parts of a well-written Excel macro ... 

Excel macros can be called most conveniently with a simple shortcut key, for which you have to remember the specific letter used for the particular... 

Write an Excel Macro that (presumably) reproduces the results in Example 3.4. Now rework the example considering reversibility of the reaction. Assume... 

Another nice example of creative crystallographic education is in an article by William Clegg [6]. He nicely explains the relationship between the amplitude of the diffracted wave and the electron density. Even better a Microsoft Excel macro downloadable from the journal website [7] is available which allows students to interactively play with the phase problem and Fourier transforms for a 1-dimensional crystal structure. 

Figure 15-12 is the same record applying the Duhamel Integral with the Microsoft Excel macro integraleduhamel.xls (prepared by the author and enclosed as the download file, DUHAMEL on the book s accompanying website). The Duhamel Integral has been calculated for 20 simple oscillator frequencies ranging from 0.1 Hz to 20 Hz. 

De Levie, R. 2001. How to Use Excef in Analytical Chemistry and in General Scientific Data Analysis, Cambridge University Press, Cambridge. (Extensive and advanced text covering much physical chemistry, kinetics, etc., as well as analytical topics. Large range of Excel macros in Visual Basic provided.)... 

---