 |
Welcome... |  |
Login |  |
 |
News
Now works with Excel 2007.
To automatically converts Excel formulas into formatted mathematical equations.
Ideal if you like to document your worksheet or if you just need help debugging formulas.
Example usage:
The Excel formula:
=(SIN(x)^2)/(1+COS(x))
Examples.xlsis formatted to give:
Note: Cell on left contains our formula with numeric solution (i.e. 1.989992). The formatted equation is automatically place to the right of the source formula. All equations can moved and resized.
The main interface to this Excel Add-in is through the toolbar:
Each button performs the following tasks:
| Button | Action |
|---|---|
 |
Creates a graphical formatted equation for the formula within the current selected Cell. You can update a previously generated graphical equation, by selected either the source Excel Cell with the formula or the previous graphical equation. Either way, this tool will look for a new formula within the source Cell and update the equation as appropriate. If you have repositioned the graphical equation, then an updated to the equation will maintain this position. Note: If you move a formula Cell, then the link to the graphical equation will be broken. |
 |
As above, except that the graphical equation is encapsulated within a box. This box is added within Excel, so the properties of the box (thickness, color, margins etc) can be change afterwards. |
 |
This will erase the currently selected graphical equation, or graphical equation associated with a particular Excel Formula. |
 |
This will erase all graphical equations generated by this Add-in. |
 |
Help - which will bring you back to this page! |
If you select multiple cells or previously formatted equations, then these buttons will cycle through each object (Cell or formatted equation) and execute the action required. Note: that to update a previously generated equation you can select either the graphical equation or the original call and press one of two equation rendering buttons.
This tool converts both Excel formulas and LaTeX equations, as detailed below:
Excel equations all start with an '=', e.g.
=A1+B2gives:
=SUM(A1+B2)/SIN(x)gives:
The add-in understands that these are Excel formulas and applies appropriate formatting to create the graphical equations. This includes making function names bold and cell references blue.
If you prefer to write an equation in the LaTeX equation syntax then simply type the LaTeX equation directly into the cell and click either one of the equation formatting buttons, e.g.
\int_3^4 sin(x^2)gives:
All Modules
\sum_{n=1}^N \frac{a_n^2}{2}
gives: For help with formulating the LaTeX code see our LaTeX Equation Editor.
The equations inserted into Excel and generated in a gif file format at 300dpi. This gives good resolution on most laser printers. For display on the screen, the equation is reduced to only 100dpi. If you enlarge the graphical equation (by scaling) then be aware that although it may look good on the screen, the printed quality will reduced.
To installation this add-in, follow these steps:
excelEquations.xla
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. If you do not agree with these terms then do not download this code.
I wasn't asked?
Occasionally Excel fails to ask. This doesn't matter, the add-in will work perfectly well from any location, however for tidy integration with Excel it is usually best to install all Excel add-ins in the path: C:\Documents and Settings\<your name>\Application Data\Microsoft\AddIns. Copying the file to this directory using the Windows Explorer (make sure hidden files are visible) will have the same effect. Then follow the instructions above and you'll immediately see the 'excelEquations' add-in listed in the 'Add-ins' dialog box. Simply make sure its 'ticked' to activate.
To remove this addin follow these steps:
You must login to leave a messge
