Some Useful Functions

The functions available in VBA are similar to the functions available in Excel itself. There are 108 VBA functions listed in VBA Help. Table 14-3 lists some of the more useful ones for numerical calculations. 

---

Ejectors are rather versatile when applied to a wide variety of processing movement, compression, mixing, etc., operations. A brief listing of some useful functions are (By permission [30]) ... 

In the following chapters we will see how explosives, when detonated, work on their surroundings to perform some useful function. We will use databases that have been established by experimental data utilizing the techniques of geometric similitude scaling as well as dimensional analysis. Most of these databases will require that we know how much energy the explosive has available for use. Let us review how an explosive behaves. 

In the reduction of aqueous copper(II) ions by zinc metal, electrons flow from the zinc rod directly to copper(II) ions in the solution. If electron transfer from the zinc rod to the copper ions in solution could be directed through an external electrical circuit, this spontaneous oxidation-reduction reaction could be used to produce an electrical current that could perform some useful function. 

The above ideas are really far reaching. As an example of their application in a more subtle context, let s consider the possibility of a protein having not one but several distinct low energy folded states. Such phenomenon is known to biologists and medical doctors some proteins have two or sometimes even three different folded states, and depending on the conditions (or even on chance) they can fold into either one of them. Sometimes this has bad medical consequences in one of the folds protein performs some useful function, while in the other it causes some deadly disease, such as. 

Electronic textiles, or simply e-textiles, are textiles with embedded electronics and some fibre materials possessing electrical characteristics and providing some useful functions. Current research on military textiles includes the improvement in the ballistic protection level (which is the primary requirement), and the developments of new designs with integrated sensors and embedded sensing technologies in clothing, backpacks or tents for other functionalities. 

Although serving some useful functions, the division of chemistry into five major subdisciplines is not as simplifying as it might appear. Principally, this is... 

In the last column of the character table, it is customary to list some useful functions that have the transformation properties shown. From Table I. I it can be seen that the angular part of a orbital, for example, is simply equal to z/r. As a result, from the character table, a orbital located at a point, which contains all of the symmetry elements of the group, will transform as a, symmetry. 

If a catalyst is to work well in solution, it (and tire reactants) must be sufficiently soluble and stable. Most polar catalysts (e.g., acids and bases) are used in water and most organometallic catalysts (compounds of metals witli organic ligands bonded to tliem) are used in organic solvents. Some enzymes function in aqueous biological solutions, witli tlieir solubilities detennined by the polar functional groups (R groups) on tlieir outer surfaces. 

An alternative way to eliminate discontinuities in the energy and force equations is to use a switching function. A switching function is a polynomial ftmction of the distance by which the potential energy function is multiplied. Thus the switched potential o (r) is related to the true potential t> r) by v r) = v(r)S(r). Some switching functions are applied to the entire range of the potential up to the cutoff point. One such function is ... 

The second approximation in HF calculations is due to the fact that the wave function must be described by some mathematical function, which is known exactly for only a few one-electron systems. The functions used most often are linear combinations of Gaussian-type orbitals exp(—nr ), abbreviated GTO. The wave function is formed from linear combinations of atomic orbitals or, stated more correctly, from linear combinations of basis functions. Because of this approximation, most HF calculations give a computed energy greater than the Hartree-Fock limit. The exact set of basis functions used is often specified by an abbreviation, such as STO—3G or 6—311++g. Basis sets are discussed further in Chapters 10 and 28. 

Choosing a standard GTO basis set means that the wave function is being described by a finite number of functions. This introduces an approximation into the calculation since an infinite number of GTO functions would be needed to describe the wave function exactly. Dilferences in results due to the quality of one basis set versus another are referred to as basis set effects. In order to avoid the problem of basis set effects, some high-accuracy work is done with numeric basis sets. These basis sets describe the electron distribution without using functions with a predefined shape. A typical example of such a basis set might... 

The documentation is clearly written and generally adequate, although some of the less frequently used functions and utilities were not documented. The user should have a basic understanding of band structure theory before attempting to read the documentation. 

Table 2.1 Some Useful Relationships Involving the Hyperbolic Sine and Inverse Hyperbolic Sine Function...

The principal monomer is acrylamide [79-06-17, where R = H and R = NH2, made by the hydrolysis of acrylonitrile. The homopolymer [9003-05-8] of acrylamide, which in theory has no electrical charge, has some use as a flocculant however, the majority of acrylamide-based flocculants are copolymers with acryHc monomers containing charged functional groups, such as those shown in Figure 1, or polymers containing functional groups formed by modification of acrylamide homopolymers or copolymers (Fig. 2). The chemistry of polyacrylamides has been reviewed by several authors (18—20) (see... 

Melting points, boiling points, densities, and refractive indexes for carboxyUc acids vary widely depending on molecular weight, stmcture, and the presence of unsaturation or other functional groups (Tables 1,2,3, and 5). In addition, some useful constants for alkanoic acids are Hsted in Table 1. Some constants for selected unsaturated and substituted acids are given in Table 7. 

Hemodialysis with microencapsulated urease and an ammonia ion adsorbent, zirconium phosphate [13772-29-7], has been used (247) to delay the onset of dialysis therapy in patients retaining some renal function, and to reduce the time between dialysis treatment. 

Programmable Logic Controllers The programmable logic controller (PLC) originated as a solid-state replacement for the hardwired relay control panel and was first used in the automotive indus-tiy for discrete manufacturing control. Today, PLCs are used to implement Boolean logic functions, timers, counters, and some math functions and PID control. PLCs are often used with on/off process control valves. 

Glass-reinforced grades have widely replaced metals in pumps and other functional parts in washing equipment and central heating systems. In the manufacture of business machine and computer housings structural foam materials have found some use. Mouldings weighing as much as 50 kg have been reported. 

Since we shall also be interested in analyzing the confined fluid s microscopic structure it is worthwhile to introduce some useful structural correlation functions at this point. The simplest of these is related to the instantaneous number density operator... 

The formation of vinylogous amides from primary amines and -dicarbonyl compounds gives rise to hydrolyzable amine derivatives with greatly decreased nucleophilicity of the nitrogen function. Thus these derivatives have found some use as protecting groups in peptide syntheses 617-619). 

In the discussion of benzylamines, we have met medicinal agents that owe their activity to some particular functionality almost without reference to the structure of the rest of the molecule. The hydrazine group is one such function in that it frequently confers monamine oxidase-inhibiting activity to molecules containing that group. Such agents frequently find use as antidepressants. Thus, reduction of the hydrazone of phenyl-acetaldehyde (84) affords the antidepressant phenelzine (85). Similar treatment of the derivative of phenylacetone (86) gives pheniprazine (87). ... 

As one would expect, in those cases in which the ionic liquid acts as a co-catalyst, the nature of the ionic liquid becomes very important for the reactivity of the transition metal complex. The opportunity to optimize the ionic medium used, by variation of the halide salt, the Lewis acid, and the ratio of the two components forming the ionic liquid, opens up enormous potential for optimization. However, the choice of these parameters may be restricted by some possible incompatibilities with the feedstock used. Undesired side reactions caused by the Lewis acidity of the ionic liquid or by strong interaction between the Lewis acidic ionic liquid and, for example, some oxygen functionalities in the substrate have to be considered. 

---