
…and was happening during Ensemble Deployment to Excel using the new math functions: Excel would crash, …
the models of the ensemble before deploying to Excel! What the heck was going on? It couldn't be the …
Excel VBA code, right? Otherwise the individual models …
up the deployment of ensembles and models to Excel by optimizing the way Excel calculations were …
we finally found the culprit: Minus zero in Excel calculations! A bug not even acknowledged by …

…Speedups in Model & Ensemble Deployment to Excel Extra feature for copying the model code as HTML …

…Visual Basic code is almost an exact clone of the Excel VBA code. The only difference is related to the …
problem of minus zero in Excel median calculations described in the post …
"Debugging: Minus Zero in Excel Median Calculations". We realized then that by …
of "0.0", the number of "0" occurrences in Excel decreased. So, although this fix did not solve …
the problem of negative zero in Excel, we decided to adopt this format for all discrete …

…for model selection during Ensemble Deployment to Excel: And by the way, these Hits and Outliers …

…The Excel VBA code for all the new 39 math functions to be …
important for two main reasons. First of all, the Excel VBA code is being used to double check the …
through the deployment of models and ensembles to Excel. Second of all, because of the double checking, …
VB.Net and others. As we will see below, the Excel VBA code for the new 39 math functions differs …
and initialization of variables, which in Excel VBA require decoupling the variable declaration …

…is very similar to both the Visual Basic code and Excel VBA code, except that in VB.Net there is a …

…supported by GeneXproTools (Ada, C, C++, C#, Excel VBA, Fortran, Go, Java, JavaScript, Matlab, …

…17 math programming languages (Ada, C, C++, C#, Excel VBA, Fortran, Java, JavaScript, Matlab, Octave, …