MATLAB: How to export a bode plot magnitude and phase to excel

bodedatadegreesexcelexporthertzMATLABplotradians

I am very new to Matlab. The transfer function I am working with is much more difficult than the one below, but what I want to do will is not impacted by the function. I have a bode plot I am generating:
H = tf([1 0.1 7.5],[1 0.12 9 0 0]);
bode(H)
I get a plot of magnitude in dB and phase in degrees, both across rad/sec. I am looking for absolute magnitude (not dB), radians (not degrees) and the the x-axis should he Hertz. I am then wanting to export the data into Excel (magnitude in the first column and phase in the second) from, for example, 10Hz to 100Hz in 10Hz steps. Can someone please assist me in doing this. It would be greatly appreciated. Thanks!

Best Answer

I would create a table from the bode output, and then use the writetable (link) function:
H = tf([1 0.1 7.5],[1 0.12 9 0 0]);
w_v = [10:10:100]*2*pi;                                 % Vector Of Radian Frequencies
[mag,phs,RadianFrequency] = bode(H, w_v);
Magnitude = squeeze(mag);
Phase = squeeze(phs);
T = table(RadianFrequency,Magnitude,Phase)
Then use writetable to your Excel file. The headers and column information will all be there.
Related Question