Hi all,

I'm new and have just started using XLC. One suggestion I have is to have one button to show the equation with variables and a second button built in to the tool bar to show the equation with numbers. You could then easily show the equation with variables and then show the equation again below the first with the numbers inserted from the variables. It would make it very similar to doing a calc by hand and also easier to check.

Just a thought.

Dave

Thanks for your suggestion JoeMiner - it would be an easy thing to implement. You are aware of the "about XLC and settings" button on the XLC toolbar which allows you to set a default value for the 'ShowWorking' equation control parameter – 0 to show algebraic names; 1 to show numerical values.
I had thought people would use either show algebraic names or show numerical values but I guess you are suggesting some users want to show both. If a few other users agree it is a good idea I'll implement the change. My reluctance to change is simply because we could have a button for every permutation of the EQS equation control string and then XLC's toolbar would become very large and unwieldy.
A good work around in the mean time would be to use two EQS() functions to produce two equation graphics. Both EQS() functions can call the same cell reference but edit the equation control strings so that one has 'ShowWorking = 0' and the other has 'ShowWorking = 1'. If you do this regularly simply copy and past the EQS() functions when you hit the equation redraw button an equation is drawn over every EQS() function.
I'll be grateful for any further comments. Thanks again JoeMiner.

I see your point about the tool bar getting very large.

I have been doing what you suggested, I just thought it would be more convenient if there was a button for this purpose. This is still the most impressive add in for excel I have encountered; keep up the good work.

I agree with Joe that if the XLC can show the equation both in algebra and number.

I think XLC may have the option that "show equation in algebra only
show equation in number only
show both"

As for the relative position of these two equations, there can be two default positions: numerical eqn is on the right side Or under the algebraic eqn.

The default relative positions of these two eqn can be adjusted by user, so I suggest the pic of two equations should be seperate.

I have played around with this a little but partly because of the existing program structure and partly because I am not clear about how it is best implemented I have not found a solution that I am happy with.

The workaround I suggested works pretty well for me (copy the EQS() function and change the equation control string to "showWorking = 1" but I am still trying out ideas for improvement to achieve this in one keystroke.

Finally nailed it and I have just updated the latest version of XLC which now includes an 'Equation Clone' button. Just download XLC and reinstall. There is a help file too to show how it works.