Skip to content

VBA-Expressions v3.0.0

Choose a tag to compare

View all tags
@ws-garcia ws-garcia released this 16 Mar 00:14
· 194 commits to main since this release
v3.0.0
5034cb3

The most robust expressions evaluation tool for VBA is here now!

Improvements

  • Added ROUND function
  • Added MROUND function for matrices elements round
  • Added REM function to compute division operation remainder
  • Added MSum function for matrices adittion and substraction
  • Added MTranspose function for computing matrix transposition
  • Added MNEG function for computing matrix negation
  • Added GAMMALN function
  • Added iBETA function for computing the integral of BETA function
  • Added BETAINV function
  • Added TINV_1T function for compute the one-tailed t-value (Student t-value) with up to 6 significant digits accuracy.
  • Added TINV function to compute the one-tailed or two-tailed t-value (Student t-value) with up to 6 significant digits accuracy. Use the tOption parameter to select from two and right one-tailed computation.
  • Added TINV_2T function compute the two-tailed t-value (Student t-value) with full significant digits accuracy.
  • Added NORM function
  • Added CHISQ function
  • Added GAUSS function
  • Added ERF function
  • Added STUDT function
  • Added ANORM function
  • Added AGAUSS function
  • Added AERF function
  • Added ACHISQ function
  • Added FISHF function
  • Added ASTUDT function
  • Added AFISHF function
  • Added ArrayFromString2 method for create jagged arrays from Strings
  • Added QR function for computing QR decomposition using Householder transformations.
  • Added LSQRsolve function for solve overdetermined system of equations using the least square method and the QR decomposition.
  • Added FIT function to perform least squares regression curve fitting with goodness of fit computation. The function supports straight-line, polynomial, exponentiation, power and logarithmic fits.
  • New GAMMA function implementation
  • More flexible variable scope: now allows vectors and arrays assignment from eval method directly. It is allowed to assign the value of a variable not present in the main expression but which is a second order variable present in the ImplicitVarValue arguments.
  • More unit test added
  • Aded support for matrices by scalar multiplication
  • Improved string Array constructors and array parser
  • Factorial function now accepts non integers parameters thanks to the new GAMMA function implementation
  • Improved error messages for functions eval errors

Bug fixes

  • Fixed bug preventing expressions from being parsed correctly at tokenisation stage.
  • Fixed indexes base different from 0 for arrays.

Note

This software use ideas/creations from:
© John C. Pezzullo
© David M. Lane
© Dr. Hossein Arsham
© iCalculator™
© mozilla.org
© William H. Press [Numerical recipes in C: the art of scientific computing / William H. Press]

Assets 2
Loading