Chapter 5 - GeneHunter Examples in Excel

<< Click to Display Table of Contents >>

Navigation:  Chapter 5 - GeneHunter Examples in Excel >

Chapter 5 - GeneHunter Examples in Excel

Previous pageReturn to chapter overviewNext page

This chapter will give an overview of the example problems that come with GeneHunter.  The examples are included in the spreadsheet file called GHSAMPLE.XLS, which is located in the directory where you installed GeneHunter.  The examples are meant to demonstrate the different types of problems that GeneHunter may help you solve.  You will undoubtedly discover many more uses for GeneHunter.  You are encouraged to change the parameters in the example programs in order to experiment with how GeneHunter works.

 

Creating a model of a problem in GeneHunter requires entering the relevant data into an Excel spreadsheet and entering a description of the problem into a GeneHunter dialog box.  The dialog box may be opened from the Excel Tools Menu.  Select GeneHunter and then select the Start option to display the dialog box.

 

Example Files:

Portfolio

Neural Net – Bob’s Deli

NYSE Prediction

Traveling Salesman Problem

Scheduler

NYSE 2 Prediction

Polynomial Approximation

Portfolio Optimization

Clusters

Selecting Indicators

 

Excel Macro Security Level May Prohibit GeneHunter Add-In Operation

When opening GeneHunter example workbooks in Excel, you may get a security warning saying that macros in this workbook have been disabled. This happens because some example workbooks contains a VBA code to provide various functionality for the examples. You will need to enable the macro content in the workbook to be able to run the examples.  When the macros are not allowed to run, the GeneHunter Add-In main dialog box will display on the screen, but then becomes non-responsive to any action. The remedy is to lower the macro security level.

How to Lower the Macro Security Level

Excel 2003: Go to the Tools -> Macro -> Security dialog.

 

Excel 2007 and 2010:  You first need to unhide the Developer tab by going to the Office button -> Excel Options -> Popular tab and checking the "Show Developer tab in the Ribbon" box. After the Developer tab shows up, click on it and select Macro Security. Try to lower the security setting a notch and see if this restores GeneHunter's normal operation. If not, try to lower the security even more.  As an alternative to allowing all macros, look at the top of the worksheet for the Security Warning:  Macros have been disabled. Click on the "Enable this content" button which will allow only the GeneHunter Add-In macro.  When you close the worksheet you will have to repeat the process to allow macros.

 

Excel 2013: If the Developer tab is not visible, go to the File Menu, Excel Options, and select Customize Ribbon in the left pane of the displayed window.  Check the Developer box to display the tab on the ribbon.  Click on the Developer tab and then choose Macro Security to lower the security level until the GeneHunter Add-In macro is displayed on the Add-Ins ribbon.