ACCEPTED SOLUTION
Accepted Solutions
@ptc-5892428 wrote:
Hi guys,
I have to export data for 3d plotting in excel.
what I have is a function f(x,y) which gives me the results in vector form of course.
anybody know how I can convert the vector into a matrix or export it to an excel sheet.
Best
ALi
First of all, you don't really have a vector.
Because you define A and B as range variables, your formula computes; but if you try to define a vector (Vc), the program throws an error. You can turn A and B into vectors (an undocumented and dangerous practice) by putting an "evaluation" equals sign after the definition; but the results aren't what you'd expect:
Why? Because A and B are both vectors, so the multiplication signs in the equation are interpreted as "dot products," and you get a single value answer. You can "vectorize" the equation (means evaluate for each set of values in each vector) and get:
But that's still not what you want.
I'm not sure how you would get a 3D plot in EXCEL; but in Mathcad you'd use the function "CreateMesh" to create a (very large) three column array (AKA matrix) that you'd then drop into a 3D plot.
Hope this helps!
Excel does not support a decent surface plot as far as I know. The surface plot in Excel simply takes a n x m matrix of z-values and shows a surface over an equidistant xy-grid. So all that would have to be done is create that kind of matrix at equidistant positions and export to Excel.
But as the thread is rather old and the questioner never came back to push the question its likely he is not interested anymore. Its surprising that nobody had answered that question months ago when it was fresh - maybe it was moved from a different (wrong) section to this forum just later and the thread did not bubble up because of the older date?
BTW, what we see in the sheet is a severe bug in Primes 3D plot!
The function arguments are mixed - the first, phi2, is a free, unassigned variable but the second, A, is range from 0 to 5. So we would expect to see the x axis from -10 to 10 and the y-axis from 0 to 5. In first sight the opposite seems to be true but on second sight the catastrophe: Prime exchanged x- and y-axis!!!!
