VBA-Expressions
VBA-float
VBA-Expressions | VBA-float | |
---|---|---|
5 | 3 | |
19 | 3 | |
- | - | |
8.7 | 1.7 | |
13 days ago | about 1 year ago | |
VBA | VBA | |
GNU General Public License v3.0 only | GNU General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
VBA-Expressions
-
Evaluate piecewise functions in VBA
So, if a Dominican needs to calculate the taxes that will be charged to them monthly, they should take pencil and paper, compute the annual amount of income and apply the corresponding formula, or they can use the following code in conjunction with VBA Expressions and get their result in a simple way.
-
Solving systems of linear equations with VBA
Systems of linear equations have been taught since high school, they are of utmost importance in mathematics. Although Excel is possible to solve, manually, equations using matrix inverse and matrix multiplication. Today we will show you a practical way to solve such problems using VBA Expressions.
-
Expression evaluator for VBA
Here is a direct GitHub link to VBA Expressions Best regards!
-
Advanced CSV filtering through VBA
After this publication, which details the reason why VBA Expressions turned out to be the most feasible option to solve the problem of integrating an expression evaluator with CSV Interface, it is time to address the process of integrating the evaluation capabilities and the ease with which this goal was achieved.
-
Evaluating expressions from strings in VBA
After a long search for something similar to the above, I decided to experiment and test the veracity of a warning that read: "... rather, it evaluates the infix expression directly. This approach is slightly more complicated than the traditional one". Then, I chose to develop an evaluator with its own grammar and a different approach to handle mathematical expressions. The solution I came up with is so called VBA Expressions. With VBA Expressions we can evaluate a variety of mathematical expressions, being able to work with arrays defined by text strings as in Java. A notorious feature is the ability to work with variables (Pi.e * 5.2Pie.1 + 3.1Pie), constants (3pi+ln(2e)), floating point numbers ((1.434E3+1000)*2/3.235E-5) and Boolean values (x>0 & Sqr(x-Ln(2))>=3 | tan(x)<0).
VBA-float
-
Porting big integers division code to VBA
In that post I mentioned a library that I had coded in VBA to operate on numbers with hundreds, even thousands of digits. At that time I raised a difficulty that I had encountered when implementing large integer division and u/sancarn recommended me to port code from other libraries to VBA. In this issue I collect the details on the subject.
-
Division of real/rational numbers using integers computations
Now, with the Float class module, it is possible to compute addition, multiplication and division of real/rational numbers with a precision not existing in any native VBA data type. These features make the class much more attractive for numerical experiments and future enhancements. Much more, I have not found a VBA library with similar features in the whole Internet, which could make it the first of its kind.
-
Arithmetic over huge integers with VBA
The [VBA-float](https://github.com/ws-garcia/VBA-float) class module handles representation of numerical values as scientific notation using strings, allowing to obtain several cohorts for the same number.
What are some alternatives?
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
VBA-float - This is a class module in beta state to implement computations with large integers and reals/rationals numbers, while proposing representation of numerical values as scientific notation, allowing to obtain several cohorts for the same number (a lot of fun!).
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
Code-Finds-Determinant-of-a-Array-in-C
Tiger - C++ Matrix -- High performance and accurate (e.g. edge cases) matrix math library with expression template arithmetic operators