Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
We can Display an equation...... How about mapping an equation to cells, rows or Columns (Or named tables) (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: We can Display an equation...... How about mapping an equation to cells, rows or Columns (Or named tables)
#2764
birse1976 (User)
Tadpole (Junior Boarder)
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
We can Display an equation...... How about mapping an equation to cells, rows or Columns (Or named tables) 5 Years, 1 Month ago Karma: 0  
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.

So

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.

Cheers,

Scott
 
Logged Logged  
  The administrator has disabled public write access.
#2765
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1729
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:We can Display an equation...... How about mapping an equation to cells, rows or Columns (Or named tables) 5 Years, 1 Month ago Karma: 492  
Hi Scott. When starting writing XLC two ideas drove its development:
1) It should use Excel because everybody has it and its very good.
2) Excel needed additional functionality to be more useful to engineers.

Once the descision to use Excel is made then Microsoft then there is a whole set of pre-existing rules you have to observe and respect and the Excel API gives you access to only certain parts of their code. One think that is dificult to access is the formula bar you can't do much with its contents whilst you are editing until you have entered it into a cell. Its a door that Microsoft keep closed but it was an idea I investigated at one time. I spent a lot of time looking at MathML and Latex but this evolved for completly different reasons to Excel and as such I saw it as a square peg in a round hole. The other difficulty is supporting different versions of Excel each of which have subtle but annoyingly different ways of doing things and it does not always have backward compatibility.

As it turned out I am very pleased with what XLC does for me as an engineer both in terms of presentation and validation of cell formulas.
 
Logged Logged  
 
  The administrator has disabled public write access.
#2766
birse1976 (User)
Tadpole (Junior Boarder)
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:We can Display an equation...... How about mapping an equation to cells, rows or Columns (Or named tables) 5 Years, 1 Month ago Karma: 0  
Thanks for the reply. I have my head buried in software development as a product owner which is a far cry from standing on a rig in the north sea. Just seen a few things around while I have been in my current position.

The main idea for my request came from playing with Microsoft Mathematics 4.0, this is essentially a free graphic calculator which lets you insert a function and map it. However this only lets you do one equation and a limited number of columns of data.

www.microsoft.com/download/en/details.aspx?id=15702

Some other interesting though seldom seen MS software comes from their dev labs

D* is a .net language for FEA I think, IronPython is managed python for .net

www.ironpython.net/

Math.NET Numerics, Numerical Library for .net

mathnetnumerics.codeplex.com/


Also for those who like reference material for all sorts of things - www.cheat-sheets.org/

Finally, Microsoft research labs Cambridge have a really nice plotting tool for dynamic data display.
research.microsoft.com/en-us/um/cambridge/projects/ddd/d3isdk/

The above link takes you to their show and tell page.

The link to MS Research - lots of interesting tidbits.....
research.microsoft.com/en-us/default.aspx

research.microsoft.com/en-us/downloads/e...3-a219-c0f3fca9881e/

research.microsoft.com/en-us/downloads/0...1-8246-07e25900c7e7/
 
Logged Logged  
  The administrator has disabled public write access.
#2767
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1729
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:We can Display an equation...... How about mapping an equation to cells, rows or Columns (Or named tables) 5 Years, 1 Month ago Karma: 492  
Hi Scott - thanks for telling me about these tools I particularly like Microsoft Math. There is a good description of it here


It installed with no problems and by the looks of it it an do many of the things that Sage has done for me in the past:
/repository/links/sagemath-note-book/
I like Sage because it is easy to copy and paste information into the Excel Formula bar.

I have quite a few other links to check out too. Thanks for the recommendations.
 
Logged Logged  
 
  The administrator has disabled public write access.
#2768
birse1976 (User)
Tadpole (Junior Boarder)
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:We can Display an equation...... How about mapping an equation to cells, rows or Columns (Or named tables) 5 Years, 1 Month ago Karma: 0  
This is pretty cool too

muparser.sourceforge.net/ and opensource/MIT license
muparser.sourceforge.net/mup_links.html
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
We have 17 guests and 36 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.