So, I love the ability to create equations from names fields. However I think the power is in the ability to use the Equation input panel to build a general formulated equation and then Map it to either named cells, Rows or Columns.
I have searched high and low for such an excel addin but right now have come up short. The closest I have come to is a MathMl to C parser. www.codeproject.com/Articles/30615/Conve...-math-equations-to-C
This uses the XML format for Maths, MathML. Interestingly enough, Mathmatical can use this encoding.
My Challenge is this. Reverse the ExcelCalc XLC process to enable a user to enter WYSIWYG correct equation in Mathematical notation and then Parse said equation/Map the fields to cells rows or Column (Maybe even named tables.
Provide it as an addin which modifies the ribbon bar to include its own tab with larger Icons. Additionally adding the functionality of using a .net math library such as .net Numerics with a nice Java plotting engine or say MS Dynamic Data display you'd be pretty far along in making a decent generalized engineering and math engine.
For an already implemented and free look at the idea please search for Microsoft Mathematics 4.0 - Its MS open source but does not have an API to connect the input panel to excel. Daft if you ask me!
Anyhoo, was also wondering if XLC is all VBA or is it C# using VSTO (Visual Studio Tools for Office)?
Now I have my wishlist out there I'll get back in my hole.