Skip to main content
17-Peridot
October 1, 2015
Solved

Explicit problem

  • October 1, 2015
  • 1 reply
  • 4277 views

Hi there,

I have this little routine (see attached file MC15, Win 7) where I read in parameters from an excel file. For a better oversight of used values I display the assigned values by the explicit command. The catch is, even when restricting it by not using the keyword ALL, it displays all steps back to the very beginning; i.e. when read in from excel.

Is there a way to limit the steps back of the explicit function?

Raiko

Best answer by StuartBruff

Raiko Milanovic wrote:

Stuart,

this is what I'm seeing. Are you suggesting that it is a bug and not a feature?

Raiko

Kind of, Raiko ...

I think the bug is in explicit not allowing indexed matrix elements.

I think the explicit chain result is what you should expect.  The symbolic processor knows very little about string functions and it doesn't know about READEXCEL, consequently, the symbolic processor has no idea what the values of Mat and Coeff are.  Consequently, it will simply expand what it can, and throw in a few domain guesses whilst it's at it.  One way round the symbolic processor not getting the data is to use in-line evaluation.  From a symbolic processor point of view, this then assigns the values to Mat and Coeff so that you can access them.  I've put a few notes in the attached worksheet.

Stuart

1 reply

23-Emerald V
October 1, 2015

Raiko Milanovic wrote:

Hi there,

I have this little routine (see attached file MC15, Win 7) where I read in parameters from an excel file. For a better oversight of used values I display the assigned values by the explicit command. The catch is, even when restricting it by not using the keyword ALL, it displays all steps back to the very beginning; i.e. when read in from excel.

Is there a way to limit the steps back of the explicit function?

Raiko

I don't know what you're seeing in your version of M15, Raiko, but I suspect it's not what my Win 10 M15 M040 is showing ...

Stuart

Raiko17-PeridotAuthor
17-Peridot
October 1, 2015

Stuart,

this is what I'm seeing. Are you suggesting that it is a bug and not a feature?

Raiko

19-Tanzanite
October 1, 2015

Try using "simplify":

explicit.PNG

(Note: you have to use M and C in explicit not M1 and C0)

Hmm!  No. It doesn't work on your worksheet!

Alan