File Exchange Pick of the Week

September 28th, 2007

Video series: Expanding the GUI to do calculations on the data from Excel

Last month we covered a lot of ground in making a GUI that would read and display Excel data (click here to see the original post). Since those videos were originally posted, I have gotten quite a few requests to expand the GUI to do some analysis. This video shows how I was able to add analysis capabilities to the GUI. We do a simple normalization of the data, but you could expand this to do more exotic calculations.

For a more extensive GUI, I would add the ability to choose from many different types of calculations and to do custom analysis. If I get enough requests, that can be done in yet another video. Let me know!

Video Content

Find the files here.

Other videos have been gathered here:
http://blogs.mathworks.com/pick/category/video/

Practical example videos have been gathered here:
http://blogs.mathworks.com/pick/category/practical-example

By Doug Hull

08:35 UTC | Posted in Excel, GUI or GUIDE, Practical example, Video | Permalink |

You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

4 Responses to “Video series: Expanding the GUI to do calculations on the data from Excel”

  1. Dennis (Mike) Briggs replied on September 28th, 2007 at 09:33 UTC :

    I am a frequent Matlab user, but by no means a Matlab geek. These little videos are so cool for me because you show, in addition to the main tip of the week, little shortcuts that inspire me to become more sophisticated. Case in point: the functions list button. I’ll use that regularly from now on.

    Thanks for the great little videos.

    Mike Briggs

  2. Doug replied on September 28th, 2007 at 10:07 UTC :

    Mike,

    Thank you for the kind words.

    You are right, there are a lot of little things along the way to learn. It is good to know these little things that our developers put in are appreciated.

    Thanks,
    Doug

  3. A. Baltimore replied on January 22nd, 2008 at 14:14 UTC :

    Hi, I have a problem when running deployment tool. I got this message:

    ________________________________________________________________________
    Your project cannot be built because you have not specified a compiler.
    To do so run the following command in MATLAB:

    mbuild -setup

    If the problem persists, click the project settings icon in the toolbar,
    select General on the left hand panel and then remove the options file
    specified in the last text box on the right hand side panel.
    ________________________________________________________________________

    then I typed mbuild -setup I installed

    Lcc C version 2.4.1 in C:\Program files\MATLAB\R2006b\sys\lcc

    the error was there, then I changed the settings in the icon toolbar
    as the help says, but the error was still there.

    Can you help me?

    P.D.: I use MATLAB 7.3(R2006b)

  4. Doug replied on January 23rd, 2008 at 10:58 UTC :

    Please talk to the support team at:

    http://www.mathworks.com/support

    Thanks,
    Doug

Leave a Reply

Wrap code fragments inside <pre> tags, like this:

<pre class="code">
a = magic(3);
sum(a)
</pre>

If you have a "<" character in your code, either follow it with a space or replace it with "&lt;" (including the semicolon).

About

Bob, Brett & Jiro share their favorite user-contributed submissions from the File Exchange.

Subscribe


Recent Comments

  • oleg: The author has implemented skewness, kurtosis and checks answering appropriately to the critic.
  • Ashok: how to store 10 or more random number in a loop a loop for i = 1:n mean(i) = input(’enter the mean value...
  • Ben: Doug, Thanks for the very helpful videos! Uitables seem like a convenient way to make a customized property...
  • oleg: Allstats has no checks, no comments and could also be improved (talking about prctile implementatio). Not to...
  • Todd: Additional information and a link to download free MATLAB and Simulink LEGO MINDSTORMS NXT code can be found at...
  • Doug: @Leo, Here is the “English version” of that code. “vec = []” makes an empty variable...
  • leo: Dear Doug I have a question in your code ‘October 9th, 2009 at 13:53′ vec = []; vec = [vec val]; I...
  • Shanker Keshavdas: You sir, are a gentleman and a scholar… No really, helped me out a lot. As to what is...
  • Quan Zheng: how can I get a copy of stepspecs.m?
  • Doug: @Lucy I think this is what you seek to move a line with the mouse in MATLAB. http://blogs.math...

Blog Admin

These postings are the author's and don't necessarily represent the opinions of The MathWorks.