sameer fares wrote: Hello, in the attached sheet i have two question. please scroll down until you see the first red arrow for the first question, and scroll more until you see the second arrow for the second question. Q1. is it possible to combine different matrixes and display the values in a table with the heading of each column being the variable? Q2. Iteration until convergence. i have done 10 individual iterations to get the result to converge. Is it possible to do some loop to automate the iterations in one step. please look in my sheet that describe my iteration process. |
Attached find an answer to your first question, yes you can but you can't create a vector of vectors and have it be a matrix, that's what augment and stack are for.
The answer to Question 2 is yes, create a solve block function. There's too much typing invilved for me to insert an example.
I did notice a peculiar (and dangerous) thing. At the first question the value of ORIGIN, the staring index of vectors is 1. That's not the default, but that's okay if that's what you're used to. At the start of your iterations, however, ORIGIN is 0. Since this is a built-in variable if you're going to change it usaually you do it as a global variable. And I've NEVER seen a sheet where it changedin mid-calculation before, nor can I understand why you would. Very dangerous in my book.
