[Products/Formula Render (fxRender)]

Index » Products » Formula Render (fxRender) »

$CodeCogs\′s Photo$

11 Oct 10, 7:14PM

Thanks guys, a really great discussion and some excellent ideas.

I particularly like the $S_{1,1}$ notation that Ahbanen has put forward. I am not a purist, but I can see the rational, though I can also see absolutely no reason why we shouldn't have it all.

so =SUM(B4:D56), could be rendered as:

$\sum \color{blue}B4: \color{blue}D56$

(1)

$\sum_{i=4,j=2}^{i=56,j=4} B_{i,j}$

(2)

$\sum \begin{pmatrix} S_{4,2} & \cdots & S_{56,2} \\ \vdots & \ddots & \vdots \\ S_{4,4} & \cdots & S_{56,4} \end{pmatrix}$

(3)

We'll add in an option that allows the user to select the method they want to use. In the scheme of things this is not hard to do.

However, I'm also not sure what's wrong with the Ugly format. Like Deedee, I personally trace errors using the graphical form. Having to convert $S_{3,4}$ to D3 would be painful, even if mathematically correct.

So is

$\sum_{i=4,j=B}^{i=56,j=D} S_{i,j}$

(4)

really that horrible, or perhaps a fourth option?

and what about this:

$\sum \begin{pmatrix} \color{blue}B4 & \cdots & \color{blue}D4 \\ \vdots & \ddots & \vdots \\ \color{blue}B56 & \cdots & \color{blue}D56 \end{pmatrix}$

(5)

or smaller

$\sum \left(\begin{smallmatrix} \color{blue}B4 & \cdots & \color{blue}D4 \\ \vdots & \ddots & \vdots \\ \color{blue}B56 & \cdots & \color{blue}D56 \end{smallmatrix}\right)$

(6)

Whats more difficult, is will people want the conversion style to be different in different parts of the sheet?

Incidentally, what addins are you both using? Have you tried our Excel 2007 plugin (on this page http://www.codecogs.com/pages/forums/pagegen.php?id=1850 ? Would you like to experiment with the new and improved 2003 plugin? We're looking for testers.