by Jeff Webb : Programming Excel with VBA and .NET: Solve Real-World Problems with Excel ISBN : #0596007663 | Date : 2006-05-05 Description : PDF-716bf | Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining exist...

Some of previously indicated errors in Microsoft Excel 97 and Excel XP have been eliminated in Excel 2003. But some others have not been corrected in Excel 2003 and new ones have been found as is shown by numerical examples.

This book is meant to be read and used by professors and economists. It assumes familiarity with economic theory and data analysis, so it will not make sense to a student or beginner. It is a manual for utilizing teaching materials that are available on the Web at http://www.depauw.edu/learn/ macroexcel. It is assumed that the professor has a favorite textbook or readings that neither this book...

Paternity analysis using microsatellite information is a well-studied subject. These markers are ideal for parentage studies and fingerprinting, due to their high-discrimination power. This type of data is used to assign paternity, to compute the average selfing and outcrossing rates and to estimate the biparental inbreeding. There are several public domain programs that compute all this inform...

Soil classifiers have taken their lead from biologists but have not produced an internationally accepted system even though the WRB is supported by the IUSS. More recently Mazaheri et al. (1995a, 1995b) have tried to introduce Fuzzy logic into soil classification. They achieved a small amount of success when their technique was applied to selected soils in Australia but failed when applied to o...

Excel 2013 (version 15) includes an add-in 'Inquire' 1 for auditing spreadsheets. We describe the evolution of such tools in the third-party marketplace and assess the usefulness of Microsoft's own add-in in this context. We compare in detail the features of Inquire with similar products and make suggestions for how it could be enhanced. We offer a free helper add-in that in our opinion correct...

We analyze the performance of a genetic algorithm (GA) we call Culling, and a variety of other algorithms, on a problem we refer to as the Additive Search Problem (ASP). We show that the problem of learning the Ising perceptron is reducible to a noisy version of ASP. Noisy ASP is the first problem we are aware of where a genetic-type algorithm bests all known competitors. We generalize ASP to k...