フィルターのクリア

Create power map of motor using xlxread ie Speed Torque and Power

28 ビュー (過去 30 日間)
rockstar49
rockstar49 2023 年 8 月 9 日
回答済み: Divyanshu 2023 年 8 月 21 日
Hi,
where it is a speed torque graph with power instead of effeciencies. Im trying to pull data from an excel file with a colum for speed, torque and input power.
Im using this but im not sure how to generate the map using contourf(XYZ)
[Data]=xlsread('Table.xlsx');
X=[Data(:,11)]; (Speed)
Y=[Data(:,2)]; (Torque)
Z=[Data(:,50)]; (Power)
Contourf(X,Y,Z);
etc.
Can someone show me the best way to do this? I think i need to create (x,y) before i use the contour function.
Thanks
  1 件のコメント
dpb
dpb 2023 年 8 月 9 日
"...show me the best way to do this?"
readtable, in all likelihood; xlsread has been deprecated for quite a while, now...
Once you have the table, use the references to the desired columns by name from it; don't make more copies of the same data.
Specific help would doubtless ensue if you would attach the input file so folks can see what actually have and do something with it.

サインインしてコメントする。

回答 (1 件)

Divyanshu
Divyanshu 2023 年 8 月 21 日
Hi rockstar49,
Here are few assumptions I have made based on the description provided:
  • The data contains three values probably as columns in the excel sheet i.e., speed, torque & power.
  • And you want to plot power on a X-Y grid where X is speed and Y is torque.
Few steps you can follow to achieve the desired plot are:
  • Firstly, read the data from the excel-file using readtable” function.
  • Then, create a 2-D grid of speed & torque using “meshgrid” function of Matlab.
  • Finally, you can plot the data using “contourf” function.
Here is a sample Matlab script you can refer to:
data = readtable("Book1.xlsx");
[speed,torque] = meshgrid(data.S,data.T);
power = data.S * data.T'
contourf(speed,torque,power)
In the above script, "power" is a 9 * 9 matrix which we got by multiplying each element of "speed" with all the elements of "torque".
Please refer the following documentation for further understanding of the functions used:

カテゴリ

Help Center および File Exchange2-D and 3-D Plots についてさらに検索

製品


リリース

R2022a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by