Answered

How do I make a variable that is equal to the position of a row in a table by using the name of that row?

fieldnames is specically documented for struct or Java or COM objects at least thru R2019b; I wasn't aware it would return the ...

How do I make a variable that is equal to the position of a row in a table by using the name of that row?

fieldnames is specically documented for struct or Java or COM objects at least thru R2019b; I wasn't aware it would return the ...

ein Tag ago | 0

| accepted

Question

Yet Another Excel COM Problem -- SAVEAS

Have a whole bunch of older Excel files that must process -- and for going forward would like to convert them to the current def...

3 Tage ago | 1 answer | 0

Answered

Error for reading function

You certainly do throw the parentheses around... :) sumenergy2= ((delta_H_T_ref)+ ((delta_Cp)*((T_isoth)-(T_ref))); ...

Error for reading function

You certainly do throw the parentheses around... :) sumenergy2= ((delta_H_T_ref)+ ((delta_Cp)*((T_isoth)-(T_ref))); ...

4 Tage ago | 0

Answered

graph axes and its scaling

If you haven't, turn your time vector into datetime (if it is actual calendar time) or a duration (if it is elapsed time from so...

graph axes and its scaling

If you haven't, turn your time vector into datetime (if it is actual calendar time) or a duration (if it is elapsed time from so...

7 Tage ago | 0

Answered

How do I detect a "tab" character in a line of text read by fgetl?

l=fgetl(fid); istab=(l==9); % the fast way... % istab=strfind(l,char(9)); % the char() string stri...

How do I detect a "tab" character in a line of text read by fgetl?

l=fgetl(fid); istab=(l==9); % the fast way... % istab=strfind(l,char(9)); % the char() string stri...

7 Tage ago | 1

| accepted

Answered

Modifying Figure Y-Axis Exponent Parameter After YTickLabels are Modified

Don't use manual labels on ticks, just don't put ticks at the unwanted places. When write labels, the EponentMode is set to 'Ma...

Modifying Figure Y-Axis Exponent Parameter After YTickLabels are Modified

Don't use manual labels on ticks, just don't put ticks at the unwanted places. When write labels, the EponentMode is set to 'Ma...

8 Tage ago | 0

| accepted

Answered

About the usage of for, while and return

With the clarification that operations are the same, then data=xlsread('data.xlsx','B1:B86640'); % preliminaries -- define sto...

About the usage of for, while and return

With the clarification that operations are the same, then data=xlsread('data.xlsx','B1:B86640'); % preliminaries -- define sto...

9 Tage ago | 0

| accepted

Answered

Array loop to find highest value

"Now I want the 5 best values, but I'm afraid if I sort them with the sort function the id's wont match anymore ..." If that's ...

Array loop to find highest value

"Now I want the 5 best values, but I'm afraid if I sort them with the sort function the id's wont match anymore ..." If that's ...

11 Tage ago | 1

| accepted

Question

Indexing to table subset from unique

Have a fairly complex table that contains, amongst other things, a Formula field (altho what the field is is immaterial to the q...

11 Tage ago | 0 answers | 0

Answered

I want to plot!!!

You left out some very key information MATLAB told you about... ... contour(x,y,psi); Warning: Matrix is singular to working ...

I want to plot!!!

You left out some very key information MATLAB told you about... ... contour(x,y,psi); Warning: Matrix is singular to working ...

12 Tage ago | 0

Answered

Knowing the value in the first and second column of an array, what is the corresponding value in the third column?

Use the MATrix LABoratory features of MATLAB instead of explicit loops where can... width = 0.5; height = 0.1; nIntervalsX = ...

Knowing the value in the first and second column of an array, what is the corresponding value in the third column?

Use the MATrix LABoratory features of MATLAB instead of explicit loops where can... width = 0.5; height = 0.1; nIntervalsX = ...

12 Tage ago | 0

| accepted

Answered

How to perform mathematical operation in columns on certain elements and make the other elements zero??

Don't try to get too fancy...sometimes just deadahead is the simplest and best (and probably fastest, besides)... a=10; ...

How to perform mathematical operation in columns on certain elements and make the other elements zero??

Don't try to get too fancy...sometimes just deadahead is the simplest and best (and probably fastest, besides)... a=10; ...

12 Tage ago | 0

| accepted

Answered

how to convert the cell to matrix

Presuming the input is a cell array, m... >> cellfun(@(s) sprintf('%d',fliplr(s)),m,'UniformOutput',false) ans = 6×1 cell a...

how to convert the cell to matrix

Presuming the input is a cell array, m... >> cellfun(@(s) sprintf('%d',fliplr(s)),m,'UniformOutput',false) ans = 6×1 cell a...

13 Tage ago | 0

Answered

How to run a Absolute value for formula when there's a variable?

Because >> y=abs('Temperature'); >> char(y) ans = 'Temperature' >> You passed the literal character string 'Temperatur...

How to run a Absolute value for formula when there's a variable?

Because >> y=abs('Temperature'); >> char(y) ans = 'Temperature' >> You passed the literal character string 'Temperatur...

13 Tage ago | 1

| accepted

Answered

Interpolation Between Two known data points

You're not looking across the variations in your two variables--another illustration why it's better to not create multiple vari...

Interpolation Between Two known data points

You're not looking across the variations in your two variables--another illustration why it's better to not create multiple vari...

15 Tage ago | 0

| accepted

Answered

if statement within for within while loop is not fullfilled but loop is exited

if randomizeOrder(randomizeOrder(:,7)==i,5) == randomizeOrder(randomizeOrder(:,7)==i+1,5) == randomizeOrder(randomizeOrder(:...

if statement within for within while loop is not fullfilled but loop is exited

if randomizeOrder(randomizeOrder(:,7)==i,5) == randomizeOrder(randomizeOrder(:,7)==i+1,5) == randomizeOrder(randomizeOrder(:...

17 Tage ago | 0

Answered

apply function to all fields in a structure array

Why the nested structure? That's where the problem arises---convert to a struct array, S as >> S=F1 S = 1×2 struct array ...

apply function to all fields in a structure array

Why the nested structure? That's where the problem arises---convert to a struct array, S as >> S=F1 S = 1×2 struct array ...

17 Tage ago | 0

Answered

How to read excel file?

Reading isn't too hard; interpreting what what you have is lacking some information... First, use the detectImportOptions funct...

How to read excel file?

Reading isn't too hard; interpreting what what you have is lacking some information... First, use the detectImportOptions funct...

18 Tage ago | 0

| accepted

Answered

Sort variables form lowest to largest but by keeping their name

Per usual, the way in MATLABB is to not used explicitly named variables -- use an array and if you need some auxiliary name/id t...

Sort variables form lowest to largest but by keeping their name

Per usual, the way in MATLABB is to not used explicitly named variables -- use an array and if you need some auxiliary name/id t...

19 Tage ago | 0

Answered

HELP: Why poly11 fit is not fitting my data?

>> zX=(X-mean(X))/std(X); >> zY=(Y-mean(Y))/std(Y); >> f=fit([zX,zY],Z,'poly11') Linear model Poly11: f(x,y) = p00...

HELP: Why poly11 fit is not fitting my data?

>> zX=(X-mean(X))/std(X); >> zY=(Y-mean(Y))/std(Y); >> f=fit([zX,zY],Z,'poly11') Linear model Poly11: f(x,y) = p00...

21 Tage ago | 0

Answered

Change axis colour to a user-define color

Use rgb color form: color[rgb]{specifier} Replace specifier with a three-element RGB triplet. \color[rgb]{0,0.5,0.5} ...

Change axis colour to a user-define color

Use rgb color form: color[rgb]{specifier} Replace specifier with a three-element RGB triplet. \color[rgb]{0,0.5,0.5} ...

23 Tage ago | 2

| accepted

Answered

Find a word in a file then pick the value next to it

buf=importdata('thibaut.dat'); % get the data in; how is your choice...importdata leaves .text, .data ix=contains(buf.tex...

Find a word in a file then pick the value next to it

buf=importdata('thibaut.dat'); % get the data in; how is your choice...importdata leaves .text, .data ix=contains(buf.tex...

24 Tage ago | 1

Answered

loglog plot command not working,gives linear plot. I need help to make it work

The plots are correct; you simply do not have enough dynamic range of the variables from minimum to maximum values that the loga...

loglog plot command not working,gives linear plot. I need help to make it work

The plots are correct; you simply do not have enough dynamic range of the variables from minimum to maximum values that the loga...

24 Tage ago | 0

| accepted

Answered

How to calculate the mean of a certain column of tables inside a cell

Close but not quite right syntax...many ways you can do, but test_means = cellfun(@(x) mean(x.Var1),test); should do the trick...

How to calculate the mean of a certain column of tables inside a cell

Close but not quite right syntax...many ways you can do, but test_means = cellfun(@(x) mean(x.Var1),test); should do the trick...

24 Tage ago | 1

| accepted

Answered

Error using readmatrix - Unable to determine range. Range must be a named range in the sheet or a single cell within 'XFD1048576'.

Given that it appears readmatrix is fatally flawed for you use case, try something like First = 1000e3; Last = 1200e3; L=Fir...

Error using readmatrix - Unable to determine range. Range must be a named range in the sheet or a single cell within 'XFD1048576'.

Given that it appears readmatrix is fatally flawed for you use case, try something like First = 1000e3; Last = 1200e3; L=Fir...

24 Tage ago | 0

Answered

num2str default format

'%.5g' is default format iirc what num2str does and the way %g counts precision.

num2str default format

'%.5g' is default format iirc what num2str does and the way %g counts precision.

24 Tage ago | 1

Answered

Multiple selection of data (dates,months,days,hours)

Attach text that folks can do something with instead of pictures...or just attach the .csv file itself. Use split to break the ...

Multiple selection of data (dates,months,days,hours)

Attach text that folks can do something with instead of pictures...or just attach the .csv file itself. Use split to break the ...

25 Tage ago | 0

Answered

Error using readmatrix - Unable to determine range. Range must be a named range in the sheet or a single cell within 'XFD1048576'.

"Worksheet and workbook specifications and limits Feature Maximum limit Open workbooks Limite...

Error using readmatrix - Unable to determine range. Range must be a named range in the sheet or a single cell within 'XFD1048576'.

"Worksheet and workbook specifications and limits Feature Maximum limit Open workbooks Limite...

25 Tage ago | 0

Answered

How to rotate the annotation text box?

Yes, as both Answers you referred to note specifically you can't rotate an annotation textbox and to use text object or textarro...

How to rotate the annotation text box?

Yes, as both Answers you referred to note specifically you can't rotate an annotation textbox and to use text object or textarro...

26 Tage ago | 1