Good Morning,

Can anyone help on an Excel linking problem (and in general DB, non-SQL data sets)  for data lookup.   

I have several static data sets stored in flat files like Excel (xls) format. 

I understand Maples connectivity via the import function to an array.  I also understand the export and use of Maple from within Excel vi the add-in..

When doing data lookups it is not convienet to import the entire database and is memory intensive for large data sets.  As such it is much more convienenit to open/attach like the old ODBC connectivity schemes.   The goal is to open/attach to the data file (xls), search a column and return other column's data as a subset for further analysis in maple.  An example would be a steel properties xls file.

My Maple worksheet is calculating the dynamic loads and stresses of an object.  With that answer of say stress, I want to link to my excel data file and search the Yield strength and return the material name and props for those grades of steel that have yield strength greater than 1.5 times my caclulated answer.

This can then be returned into a smaller array for further analysis using Maple with different properties of my retrieved subset.  The link would be closed after getting the subset.

I have read all the Maple document Excel help info and the excel add-in info which is the wrong direction.   I can easily code this search into a vlookup within excel - but completely defeats the purpose for using Maple in the first place.   Again, importing is not a method as these data sets are static and come from various sources like "AMS" which need to live outside maple.

I have looked into FileTools pakcage and old C type fopen, scanf, etc. without much luck on Maple implementation.   The fopen seems to be for text or csv data sets?   according to the documentation.  But, I'll keep looking while waiting any replies.

Any assistance very appreciated.

Bill

I am trying to get this to work

{seq(isolve({a = k, irem(a*b, 10000) = 2391}), k = 1 .. 9999)}

but am not getting any answer. One solution is irem(297*9503, 10000).

Dear friends~

Recently I wanted to create some funny gif with Maple based on other interesting pictures but I met some problems:(1)I read many commands in ImageTools but few can aid me.(2)If I use “plot(,background=file_address)”,then the whole background will be filled with pictures but I just want it to be a part of my gif.I finally noticed that “plot3d(,image=file_address)”can realize my idea to some extents if I adjust orientation’s value  suitably.

However,I still think my operations can be improved(for example,my code consumes a fair amount of  memory) and there maybe one better approach to be good too. Hence I upload my code and sincerely look forward your suggestions and help~

#Janesefor do it in 2019/4/15 13:20 with Maple2018~
with(plots):
# smile.jpg's address
image_file:="C:/Users/ysl-pc/Desktop/":
str:="有","朋","自","远","方","来","不","亦","乐","乎","?":
location_func,dy,dz:=3*sin(2*3.14/10*y),.75,.75:

display(seq(display(textplot3d([0,1,4.5,cat(str[1..ha])],align='right'),textplot3d([0,3.5,-4.5,"By Janesefor ~"],align='right'),plot3d([0,s,t],subs(y=ha-1,[s=y-dy..y+dy,t=location_func-dz..location_func+dz])[],image=cat(image_file,"smile.jpg"),axes=none,scaling=constrained,orientation=[180,90,-180],view=[default,0..10,-5..5],glossiness=0,lightmodel=light4)),ha=[`$`(1..nops([str]))]),insequence=true);
Export(cat(image_file,"smile.gif"),%)

smile.mw

Hello,

Please, is there a free trial version of Maple for students? If, so, please, where can I find it?

Thanks in advance.

Hi, I am struggling a bit animating a result that I have.

Let me explain.

I solved numerically some equations for me movement of a rolling disc and a bar bolted to the center of the disc.

So I have a long list of values for:

x[h] for the horizontal position of the disc
beta[h] for the rotation of the disc
theta[h] for the rotation of the bar

and so on...

Then I created a procedure that, for a given instant "h", maple plots the disc and the bar correctly.

Now I want to anumate this procedure that should depend only on the instant h and I cannot perform it.
Maybe the error comes from the fact that there are not functions involved but numerical data, or maybe it is the fact that disc radius and bar lenght are assigned outside the procedure.

Any help would be appreciated.

This is the file:

Mechanics.mw
 

i want to calculate the eigenvalues and  the spectral radius of this matrix can anyone help me 

B:=Matrix([[a, -b, e], [c, l, d], [-e, -k, m]]

When I tried to solve the following integral, Maple returns it unevaluated. What am I doing wrong?

int(ln(a^2+x^2)/(a^2+x^2)^n, x = 0 .. infinity)

I have a system of equations to solve. After that I get a lot of solutions (in attached example it is not such a big number, but I have larger system with hundreds of solutions). After that I have to put all the solutions into function, one by one and calculate it (for each solution). What is the best way to that? For small number of solutions I did it manually.    

Here is this example:

example.mw

I have this file in Excel.

poljska_mreza.xlsx

It has two columns of numbers: "from vertex" and "to vertex". Is there any way to use this file to create a graph in Maple?

I am installing maple 2019 on Linux 64 bit. I used the option

--mode text

The installer has not proceeded after answering Y to the following. 

Activate Maple 2019 now (requires an Internet connection). [Y/n]:

Any suggestions? 

Not sure if i'm missing something, but this does not seem to work how i would expect.

Trying to understand why the [1,1] element is simplifed to -3, as well as the [3,3] element to -2. 

Any ideas?

thanks!
 

Download translate_from_mma.mw

Markiyan has contributed valueable mapleprimes posts and comments.  His account is unaccessible to view listed posts.  Is his information deleted?

I am using Maple 18 to plot iterates of a discrete map.  A vector R1 is parametrized by the label b that runs from 0 - 2*Pi.  The following initial iterate gives me a blue circle:  

>a := 1.0
>q := a*cos(b)
>p := a*sin(b)
>R1 := PositionVector([q, p], cartesian[x, y])
>PlotPositionVector(R1, b = 0 .. 2*Pi);

Is there a way for me to assign a gradient colorscheme to each point of the circle, using b as parameter from 0 - 2*Pi? I have tried using the following, which does not give an error message, but it also just gives me a blue circle:

>PlotPositionVector(R1, b = 0 .. 2*Pi, curveoptions = [colorscheme = ["valuesplit"]]);

I am not sure how to use the vector and mapping options in the command >plotcommand(plotargs, colorscheme=["valuesplit", V, mapping]) to obtain the color gradient along the circle.

Hello, I'm trying to build a function of two variables which has also and index that will be useful later when I will substitue indexed varaibles

f[i] := (x,y) -> a[i]*x + b[i]*y;
f[3](x,y)  -------> expecting: a[3]*x + b[3]*y , but it gives f3(x,y)

Any suggestion?

Hi,

I have to model a DC motor in MapleSim. Reading the help of the component EMF I can't undestand if it takes into account also the Back EMF or if I have to use a voltage generator and a rotational speed feedback loop.

Do you know something about that?

Thanks.