Home About Us Contact Blog
 
 
What's New Products Buy Now Downloads Forum  


Discover the excitement & power of modeling with GeneXproTools!
Create powerful predictive models for Regression & Time Series Prediction,
Classification & Logistic Regression and explore Logic Synthesis.

Learn More

   
 
 
GeneXproTools  

GeneXproServer  

Gene Expression Programming

 

Excel Configuration for Ensemble and Model Deployments

When you try to deploy a model or an ensemble to Excel for the first time, you may come across this message:


Security dialog


In this page you will find an explanation of how to configure Excel so that GeneXproTools can deploy models and model ensembles to Excel 2003, 2007, 2010 and 2013.

The deployment features in GeneXproTools add the model code to Excel but, by default, Excel does not have this feature enabled. It's very easy to enable this feature in Excel. All you need to do is follow the step by step instructions in this page.



If you have Excel 2003

Select the menu Tools -> Options to access the Options window.

Excel 2003

Then in the Options window select the Security tab and then click the button Macro Security.

Security


And finally in the Security window check the Trust Access to Visual Basic Project checkbox.

Security



If you have Excel 2007

In the menu press the Excel Options at the bottom:

Excel 2007

Then in the Excel Options window select the Trust Center option and then press the Trust Center Settings button on the right:

Excel Trust 2007 Center

Then in the Trust Center window select Macro Settings and, under the Developer Macro Settings, check the box "Trust access to the VBA project object model":

Excel Macro Settings 2007


If you have Excel 2010 or 2013

In the menu press the Options at the bottom:

Excel 2010

Then in the Excel Options window select the Trust Center option and then press the Trust Center Settings button on the right:

Excel Trust 2010 Center

Then in the Trust Center window select Macro Settings and, under the Developer Macro Settings, check the box "Trust access to the VBA project object model":

Excel Macro Settings 2010


Security Warning and Antivirus Software

Enabling this feature allows any application to add VBA code to Excel files. There is a certain risk in doing so and you should ensure that your computer is running antivirus software. Reversing the process will restore the default Excel settings. It is also possible that some antivirus software may flag GeneXproTools since it uses this non-default feature. If that is the case, you will need to add GeneXproTools to the safe list of that software. If you have any questions regarding this process, please email us at support@gepsoft.com.

 

 Time Limited Trial

 Try GeneXproTools for free for 30 days!

 Released February 19, 2014

 Last update: 5.0.3883

 Read more...

   Academic Editions

Academic licenses of all GeneXproTools editions are available at a discount for education institutions & students.

   Software Bundles

Bundles of GeneXproTools & GeneXproServer are available at a discount price for all editions of GeneXproTools, including academic editions.

   Subscribe to the GEP-List

3 8 4
   

"Finally, a world class user interface in the field of genetic programming and evolutionary computation !! GeneXproTools is simply unrivaled in its marvelous user interface, the breadth of its Fitness Functions, the choice and flexibility in Math and Logic functions, the clarity of its final Model Presentation, and a built in panel for Scoring new data, right inside the interface. This kind of functionality and ease of use has never been seen before in the field of Genetic Programming. Additionally, Dr Ferreira's specific methodology of Gene Expression Programming makes important contributions to the field of evolutionary computation, and the various algorithms she has developed and deployed inside of GeneXproTools are brilliantly conceived, and her methodologies evolve highly predictive models that solve real business problems. GeneXproTools is an extraordinary structural tour de force."

Brian C. Watt, CRM
Chief Risk Officer / Chief Financial Officer
GECC Inc, USA

 

"I have been using GeneXproTools against a variety of drug research related problems and have found the GUI to be readily-usable and well-attuned to the stages of predictive modeling..."

Steven J Barrett, Ph.D
Principal Scientist
New Applications Team
Data Exploration Sciences GlaxoSmithKline

 

"Gene Expression Programming, combined with GeneXproTools, allow us here at Mercator GeoSystems to explore new and exciting methods for spatially modelling the relationship between a company's outlets and their customers. The GeneXproTools software is simple to use, well-designed and very flexible. In particular the ability to load training data from a database, and the option to create models in the programming language of our choice, really make this product stand out. Product support is excellent and very responsive - heartily recommended!"

Steve Hall
Mercator GeoSystems Ltd
United Kingdom

"As a professional software developer, I could have attempted to read up on all the latest developments in the field of evolutionary programming and start writing my own modeling tools. One look at the GeneXproTools demo, however, was enough to convince me of the absurdity of that thought. Not only does GeneXproTools have all the power that I would ever need, but it also allows me to customize all parts of the modeling process. I don't have to know the first thing about evolutionary algorithms and yet I can write my own grammars or fitness functions if I wanted to. It is obvious that a huge amount of work went into the making of GeneXproTools, and I am now a very happy customer. Keep up the great work, Gepsoft!"

Glenn Lewis
Software developer, USA

"I've been working as a coastal engineer and mathematical modeler for more than 10 years and now I'm using GeneXproTools to discover complex nonlinear relations that exist in hydraulic and wave processes. For example, GeneXproTools recently helped me establish several explicit approximations to the Wave Dispersion Equation and now with the new version, which allows more independent variables, fitness functions and unlimited records, I plan to develop my own formulae to evaluate the wave overtopping of breakwaters and seawalls. Thanks Gepsoft for providing such an exciting, creative and useful software tool to the scientific community."

Ricardo Carvalho
PROMAN - Centro de Estudos & Projectos, SA
Lisbon, Portugal

"GeneXproTools is being used to look at problems involving parasite populations, where the data is highly skewed. The results using GeneXproTools are considerably better than those obtained using conventional statistics."

Prof John Barrett
Head of the Parasitology Group
University of Wales, UK

"We are using GeneXproTools for modeling the rainfall-runoff process and time series forecasting. GeneXproTools has a nice graphical user interface system and a lot of flexibility in choosing the type of input file. Configuring the problem setup, running and visualizing the graphical outputs with GeneXproTools is indeed user friendly. Being able to get the final model in the languages of our choice makes GeneXproTools stand out from other packages."

Professor S. Mohan
Professor & Head of the Department
Department of Civil Engineering
Indian Institute of Technology, Madras
More


 


 
Home | What's New | Products | Buy Now | Downloads | Quick Tour | Support | Contact Us | About Gepsoft | Sign Up
Forum | Blog | Videos | Tutorials | Knowledge Base | Server KB | Logistic Regression Guide | Terms of Use | Privacy & Cookies
 
 

Copyright (c) 2000-2014 Gepsoft Ltd. All rights reserved.