Community Profile

photo

dpb


Last seen: Today Active since 2012

Statistics

All
  • Revival Level 2
  • First Review
  • Master
  • Thankful Level 2
  • 36 Month Streak
  • Knowledgeable Level 4
  • First Answer
  • Solver

View badges

Content Feed

View by

Question


Using Cells() in VBA with Excel via ActiveX
While off topic, there are enough using Excel and ActiveX that it is a pretty active subject area, so I'll add one more I couldn...

12 giorni ago | 0 answers | 0

0

answers

Answered
Plot 3 lines using plotyy with Different X-axis
plotyy creates two overlaying axes; you've created two sets of those and there's no way to not occlude one axis with the other, ...

14 giorni ago | 0

Answered
How do I overlap boxplots on top of each other for the same x-axis?
Use boxchart and the grouping by color option probably best builtin solution...

18 giorni ago | 0

Answered
What is this fft code doing?
See the documentation of FFT and read the example for a one-sided PSD from the FFT carefully... Basically, the reason for the a...

18 giorni ago | 0

Answered
Find and compare rows in table by column value
groupsummary(table,{'Year','Ed_level'},@(x)mean(x(randperm(numel(x),50)),'Income')

19 giorni ago | 0

Answered
How do I select several rows in Excel?
I'll throw the last example code out as an Answer as well as Comment just for visibility -- and it may turn out useful for other...

19 giorni ago | 1

Answered
How do I select several rows in Excel?
You can use any valid range expression to address any range you can code the logic to compute addresses of. You must then use e...

20 giorni ago | 1

| accepted

Answered
Save a matrix .mat in a specific folder with a variable name
save(filepath,'variablename') The functional form of save needs the file name to be the variable containing the (hopefully full...

20 giorni ago | 0

Answered
is there any way to pause the code if there exist an imaginary variable?
While I've not tried it, the following should work if you can arrange the conditions needed. The first one may be the kicker in...

21 giorni ago | 1

Answered
Adding text programmatically to a figure
text() is exclusively a child of an axes, not a figure. To write text outside the boundaries of an axis, use the annotation obj...

21 giorni ago | 0

Answered
How to scan directories and find a specific file in each folder and their respective subfolders
Of course. However, with base MATLAB syntax you have to traverse the folder tree manually/explicitly in code; there are a numbe...

21 giorni ago | 0

| accepted

Answered
Adding latex equation to a Matlab Live Script and Plot the equation
LaTeX is simply a display feature, at least so far it isn't tied to the actual code...

23 giorni ago | 0

Answered
enumeration Fails with get(), set() arguments
OK, I (finally!) figured out how to code the above to use a named constant with external interface -- don't use MATLAB enumerati...

24 giorni ago | 0

Answered
How to lookup and return a corresponding value from table?
I'd start by turning 'obs' into a categorical variable... cmnt0 = categorical({'obs1';'obs2';'obs3';'obs4'}); curve=[1;2;3;2];...

28 giorni ago | 0

Answered
I like to save a cell array into text file
>> c={'Al','Mg';'Na','K'} c = 2×2 cell array {'Al'} {'Mg'} {'Na'} {'K' } >> join(c,'') ans = 2×1 cell a...

28 giorni ago | 0

| accepted

Answered
How to Interpolate scalar on new grid
Error using griddedInterpolant Sample points must be unique. comes from x = Results(:,1); y = Results(:,2); ... [X,Y]=mesh...

28 giorni ago | 0

Answered
How to save this matrix?
If there's just one array/matrix M, then fid=fopen('test.txt','w'); fmt=[repmat('%.4f',1,size(M,2)) '\n']; % build ...

circa un mese ago | 1

| accepted

Answered
What is missing from MATLAB #2 - the next decade edition
Related to my previous re: insert() function for tables @ <What is Missing is insert() Function> would be enhancement to addvars...

circa un mese ago | 0

Answered
how can i get data sampling rate and FFT bin width?
"What is the default value of the parameters fft?" None...the fft doesn't care, the sample rate is set solely by the data colle...

circa un mese ago | 0

Answered
How to plot an array with an hourly time stamp without starting at 00:00:00?
You can build complete datetime variables from the input by something like-- dt1=datetime("yesterday")+duration(T(1)); % ...

circa un mese ago | 0

| accepted

Answered
How can I convert file txt into matrix?
Simply put, you can't. An array of anything (even a cell array) has to be regular (your cell array above is Nx1; it is only the...

circa un mese ago | 0

Answered
Box plot with categorical axis - without LaTex interpreter
Much easier now... :) optFV=detectImportOptions('fruitvegprices.csv') % lets you then set the input...

circa un mese ago | 0

| accepted

Answered
calculate kurtosis in matlab and minitab but not same answer
Looks like Minitab uses the bias-corrected estimator with the "-3" convention applied -- K>> kurtosis(x(:,2),0) ans = ...

circa un mese ago | 0

Answered
sorting data tables according to results from cluster analysis
Y=X(outperm,:); % presuming X is the variable guessing from the initial code...

circa un mese ago | 1

| accepted

Answered
sort the matrix X, then sort the another matrix in the same order as X
Matrix expansion of subscripts gets you here... Q=cell2mat(arrayfun(@(i) P(i,indx(i,:)),[1:size(P,1)].','UniformOutput',false))...

circa un mese ago | 0

| accepted

Answered
How can I plot a circle over an interval (range of values)
hL=plot([-1327,0],[0 0],'LineWidth',8,'Color',[1 1 1]*0.5); xlim([-1500 200]); ylim([-20 20]) xticks([]),yticks([]) hold on ...

circa un mese ago | 0

| accepted

Answered
How to choose values from vector (150 000x1). When i need first 512 values for x, next 512 values for y and next 512 values for z. And separate vector by this style to the end
XYZ=reshape(V,512,[]); then process by column. Most MATLAB functions operate by column natively; depending upon what you're do...

circa un mese ago | 0

Answered
R2017b Compatibility
https://www.mathworks.com/support/requirements/matlab-system-requirements.html?s_tid=srchtitle_MAC%20Monterey_6 indicates R2021b...

circa un mese ago | 0

Answered
How do I get my graphs to converge on one ?
... [yob,t,xob] = lsim(syst,r,t,[x0 x0ob]); figure(2); hold on plot(t,xob(:,1)/max(xob(:,1)),'r'); plot(t,xob(:,2)/abs(min(...

circa un mese ago | 0

Answered
select folder that also includes subfolders
There is no builtin gui tool that does more than multi-select on files within a single folder; you have to traverse the director...

circa un mese ago | 0

Load more