Add-In Function Macros

Saving a custom function as an Add-In is by far the most convenient way to use it. Here are some of the advantages  

---

Unfortunately, if you re entering the custom function in a different workbook than the one that contains the custom function, the function name must be entered as an external reference, e.g. PERSONAL.XLS FtoC. This can make typing the function rather cumbersome, and means that you ll probably enter the function by using Excel s Paste Fimction. But, see "Creating Add-In Function Macros" in Chapter 17 for a solution to the problem. 

How to call both built-in functions and Add-In functions from VBA Macros... 

There is an additional major advantage in using the Solver Add-in and the SolvStat.xls macro, even for functions that are linear or can be rearranged to a linear form. For example, if the function is... 

Excel is a rather complex program, that can be used at various levels of sophistication. In this book we will mostly stay with the basic operations common to most spreadsheets, although we will occasionally exploit some of ExceFs specific capabilities, as when we use functions from the add-in menu or special macros. Because printing manuals is expensive, and many users do not consult them anyway, Excel has an extensive, built-inhe p library that can be called while you are working on a spreadsheet. Call it by clicking Help, then find your way to the topic you want. For example, let us assume that you want to use the Analysis Tool Pak, but cannot find it under Tools. Apparently it was not installed. How would you find out how to install it ... 

To obtain a standard deviation to express an experimental error with a confidence area, procedures to obtain standard deviations of parameters of general functions are indispensable. These are, however, quite complex. With the aid of spreadsheet software, the standard deviations can be obtained relatively easily. In this case, a convenient way to obtain the standard deviation is to apply the Solvstat macro to the spreadsheet. Doing so is easy and provides reliable results. First, a spreadsheet to obtain regression coefficients by using Solver must be prepared. Then the Solvstat add-in can be used to elucidate standard deviations of regression coefficients. ... 

Add some noise to the signal in B13 B524, and see how it tends to swamp the derivative. Figure 7.3-2 illustrates this. Of course you will see this only afteryou have again used the forward and inverse transforms, as in (9). The Fourier transform is performed by a macro. Macros do wotupdate automatically, as the standard spreadsheet functions do. 

This type of chemistry towards well-defined star-shaped (polymer)j,Qo is closely linked to progress made during this last decade in radical polymerization [3]. Indeed, the various controlled radical polymerizations such as nitroxide-mediated polymerization (NMP) or atom transfer radical polymerization (ATRP) allow us to produce polymer chains with tailored chain length and low polydisper-sities. Furthermore, the as-prepared chains bear at their end a function (stable radical or C—halogen bond) that can be converted under the right conditions into a macro-radical. If this latter is produced in the presence of Cgo, several chains should add to the fullerene. 

---