Function procedure creating simple

As a simple first example of a Function procedure, we ll create a custom function to convert temperatures in degrees Fahrenheit to degrees Celsius. 

This apparently simple reaction is of multiple relevance in catalytic carbon chemistry. The reaction is used to activate carbon by the increase of surface area due to hole burning. It is further used to create surface functional groups (Section 2.1.9.5). Finally it is used to remove undesired carbon deposits in regeneration procedures. 

As we have seen before (Fig. 3, Chap. I, and Fig. 80, Chap. II), the versatile chemistry of Mannich bases offers many opportunities for creating tailor-made molecular structures suited to different needs by virtue of simple and relatively inexpensive procedures that can be readily carried out in industry. In the present chapter, therefore, we shall examine both the chemical structures that provide the properties required and the synthetic strategies that lead to the products best suited to the desired functions. A survey of the main uses of individual Mannich bases according to the type of application is also included. 

Spreadsheets are created to facilitate computation. Commonly used mathematical operations (such as SIN, LOG, SQRT, and MINVERSE) are built-in as functions, and some more complicated procedures (e.g., Solver, Random Number Generation, Regression) are provided as macros. However, no spreadsheet maker can anticipate the needs of all possible users, and Excel therefore allows the introduction of so-called user-defined functions and macros. In section 9.2d we will describe some user-defined functions, while chapter 10 deals extensively with user-defined macros. However, beyond the simple exercises of section 10.1, it makes no sense to enter long macros by hand, and they are therefore provided in a web site from which they can be downloaded and stored onto your own computer disk or diskette. The web site also contains a sample file that is, likewise, larger than you might want to enter manually. 

The function of CISOC-SES (see Section 4.3) parallels that of SESAMI, i.e., to directly reduce the molecular formula of an unknown to a small list of plausible alternatives using ID and 2D NMR spectral data. The process consists of the three successive stages. In the first, a bond adjacency matrix is created, the free-bond connection matrix (FBMX) in this case. Atom correlations derived from 2D NMR experiments are then extensively used to reduce the FBMX. In the final stage, reduction to a one-to-one mapping of bonds is achieved by means a simple, recursive, depth-first search procedure that yields all compatible structures. C NMR chemical shift data and simple heuristics are used to guide this process and increase its efficiency. 

---