# xlTools Home

[SolverStat Home]    [EST Home]

NEW August 19, 2019 SolverStat 2019 R0 Released!

September 10, 2010 A second proof of The Manual Released!

September 10, 2010 SolverStat 2010 R3 Released!

August 12, 2010 The first proof of The Manual Released!

August 12, 2010 SolverStat 2010 R2 Released!

February 24, 2010: SolverStat 2010 Released!

September 20, 2009
: fixed some bugs in SolverStat.

August 28, 2009
: SolverStat and Est may be downloaded from ifile.it as zip files.

March 18, 2009fixed a installation problem in SolverStat. The old mail address solverstat@lycos.it is replaced with solverstat@gmail.com.

December 27, 2008SolverStat 2008 (2.0) was released as Open Source under the Educational Community License version 2.0.

In Microsoft Excel, the built-in optimization package Solver yields minimized least squares regression parameters: the use of this utility in association with the worksheet functions makes Excel a flexible tool to solve linear and non linear regression problems. Nevertheless, Solver provides no estimates of the precision of the fitted parameters and an incomplete and unprompted analysis of fittings: the statistical analysis of the result is, on the other hand, a crucial step to evalutate the reliability of the models. SolverStat overcomes that limits.
What is new:
-Open Source
-Monte Carlo search of global minimum of the sum of squares in nonlinear regressions
-LOO and MC cross validation
-Beale confidence region
-Significance and Power Analysis via MC Simulation
-Correlation tests
-Lin's Concordance Test
-Univariate outliers
-Resampling and histogram tools
-Principal Component Analysis
-Support for simple Logistic Regression

December 27, 2008:  EST 2.0 was released as Open Source under the Educational Community License version 2.0.

EST (Equilibrium Speciation Tool) is a Excel add-in for the simulation of chemical equilibria in solution. The program calculates the thermodynamic equilibrium concentrations of species in aqueous and non aqueous chemical systems. It handles homogeneous (complexation, acid-base, redox) and heterogeneous equilibria (solubility and distribution with other solvent or gas phase). Corrections for ionic strength can be made and activities calculated. It allows the users to simulate, or to obtain from experimental data, desired chemical-physical parameters as well as to interact with other available or freely created Excel tools. It is based onclassical  Newton-Raphson method applied to mass balance and improved by using a robust Genetic Algorithm.
What is new:
-Open Source
-Bugs fix

solverstat@gmail.com

[SolverStat Home]    [EST Home]
[University of Udine]

Last Updated: August 19, 2019 - Pierluigi Polese