The function arguments are mixed - the first, phi2, is a free, unassigned variable but the second, A, is range from 0 to 5. 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?īTW, what we see in the sheet is a severe bug in Primes 3D plot! So all that would have to be done is create that kind of matrix at equidistant positions and export to Excel.īut as the thread is rather old and the questioner never came back to push the question its likely he is not interested anymore. The surface plot in Excel simply takes a n x m matrix of z-values and shows a surface over an equidistant xy-grid. 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.Įxcel does not support a decent surface plot as far as I know. You can "vectorize" the equation (means evaluate for each set of values in each vector) and get: 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 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: What I have is a function f(x,y) which gives me the results in vector form of course.Īnybody know how I can convert the vector into a matrix or export it to an excel sheet.įirst of all, you don't really have a vector.īecause 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. I have to export data for 3d plotting in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |