EqCal is designed to solve and graphically display equations
including but not limited to:
Single variable equations
Equations with constants
Equations with coefficients
Equations with multiple variables
Equations with limits
Equations with graphs
Equations with variables and constants
Multiple variables in equations
Table and graph equations
Why does this simple Excel formula add the values of multiple tables?
I have a simple Excel table that contains two columns, 1 for active and 0 for inactive. The inactive column is currently empty. The form of the Excel formula below is to ignore any empty rows in the inactive column.
The problem is that the Excel formula in the empty cell in the inactive column looks like this:
Instead of a 0 for an empty row, it looks like it is evaluating the first row in the inactive column and then the first row in the active column, and then the second row in the inactive column.
What am I doing wrong?
The problem is with how you are using MATCH.
MATCH looks at the entire range with the criteria, not just the first cell.
The MATCH function returns the first cell that matches the criteria. If there are multiple matches then all the cells that match the criteria are returned.
If you want to check the first matching cell, then you can use OFFSET
The KEYMACRO contains a function that allows the user to solve the equations in a mathematical way using the formulae of Gauss and other mathematicians.
Solution algorithms available:
N-Roots: N-Roots algorithm to solve a polynomial of degree n using Gröbner Basis method.
The particularity of this algorithm is to handle only a polynomial with only one real root.
N-unknowns: this algorithm solves an equation with N unknowns given as input.
The solution is chosen according to the accuracy of the calculated value.
Approximation: Approximation of an unknown quantity (x) given by the values of known quantities (y1, y2, y3).
Approximation “We are obsessed with our children and their digital presence”
Daring to Remain Obscure: The Wild Rise of an Iowa Cartoonist
Artist Sarah Heller.
Many of us know Sarah Heller as the creator of the popular sketch comic The Sandlot. But the woman behind the pen has a long history in comics and now is venturing into a very different realm. Over the past two years, Heller has been working on a series of text-and-image comics that mirror how Iowans communicate on the social media platforms of Instagram and Twitter.
EqCal is a GUI app that can be used to solve any equation. It takes the form of a simple menu interface with a list of options that make up the equation.
Each option has an associated equation which is the solution to the original equation. You can change the units of the input and output in a variety of different ways.
You can check your answer against the answer that is displayed after the input is complete.
The user has the ability to load a new set of equations from a.csv file which can be done at any time.
When you are finished the app returns to the last menu item selected.
EqCal is a beta release and as such is not complete. The latest version can be found on the subversion repository located at
In addition to the source code, the user manual and the optional help screen can be found at the following location:
You can download the newest version of eqcal from:
I also found the source on SVN, but it seems a bit old. The source is still available at:
The eqcal site has a list of different equations available and also the equation to solution conversion from unit of measurement.
It is assumed that users already have installed Tk and that the desired tk.exe and perl.exe are in the PATH, and that a perl installation in the current directory exists and is already set up for running scripts.
1. Download the code and extract the TkToolkitExe and TkExe files to a folder that is on your PATH, that is also known as a PATH variable. For instance, if you have the TkExe file in your C:\ dir, then you should create a folder under your C:\ dir and put the TkExe and TkToolkitExe files in that folder. The files will be copied into the folder automatically.
2. Create a perl script and name it eqcal.pl. Make sure that the file name is in upper case (so that it can be recognised as an executable) and place it in the same folder as the TkToolkitExe file (e.g., C:\TkExe\Toolkit\eqcal.pl). Copy the TkCalc script from the TkExe file to this folder (e.g., C:\TkExe\Toolkit\TkCalc.pl).
3. If you are running TkExe.exe then you must type the following line in the Terminal window:
TkExe.exe -ConfigFile= C:\TkExe\Toolkit\TkCalc.cfg
where the C:\TkExe\Toolkit\TkCalc.cfg file is the file created in step 2.
4. Type the following line in the Terminal window to start the eqcal.pl script.
If you start TkExe.exe with the -ConfigFile= switch, then it will be interpreted as a command-line option to the TkCalc.cfg script and will run automatically every time you start TkExe.exe. You can start TkExe.exe with this switch and have it run automatically without having to type anything else in the Terminal window.
You can always type perl eqcal.pl in the Terminal window to run the program when you are not using the command line.
If you decide that you do not want to run eqcal.pl automatically, then you must type the following command in the Terminal window to start TkExe.exe:
TkExe.exe -ConfigFile= C:\TkExe\Toolkit\TkCalc.cfg
You can also start TkExe.exe with this command line option, but you must type it in the Terminal window.
You use eqcal.
Windows 10 / 8.1 / 8 / 7 / Vista (SP2) / 2003 Server / XP with Service Pack 3 or later (64-bit editions only)
Core2 Duo (1.5 GHz) or better
2 GB RAM
DVD drive (but it can be played from a USB flash drive)
16 GB free disk space (game and patch)
DirectX 10 graphics card
Internet connection (LAN or Internet)
Concurrent processes limit: not more than three (3)
92 total views, 4 views today