Monday, January 21, 2019

Working with the Cardano-Viete Formulas in Excel


  Mathtype did a tweet on the Cardano-Viete relations a couple of days ago and I decided to see if Nio was capable of handling them now. He did ok as this video show.


The video also gives a peek at how he is able multiply polynomials.

  As you can tell, I'm working on a "token processor" and the functions in the video beginning with the letter "t" are some user functions that I wrote. It's still a work in progress and I  need to optimize the functions used and simplify the procedures as much as possible. Notice that I had to sort the terms of the polynomial product. Microsoft has a sort function beta that it is evaluating. One only needs to sort an index since that can be used with the Index function to sort more than one column. It would be more convenient if a range of sorted indices could be used to sort a corresponding column.

No comments:

Post a Comment