Analyzers in Spreadsheets

This discussion is devoted to explaining how one would build an insight generation system in a spreadsheet, along with other associated end-user application development tools. However, it is important for the reader to understand why one would want to do this in the first place. Since an insight generation system applies expertise and knowledge, why not build it in an expert system shell? This why question is addressed first, followed by the how question.