Doug’s MATLAB Video Tutorials

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!
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 Format: Video, Topic: Excel, Topic: GUI or GUIDE, Topic: Practical example | 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.

7 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

  5. Waggy replied on March 2nd, 2009 at 11:43 UTC :

    Hi Doug,

    I am very new to MATLAB and have found your tutorials a massive help. The question i have for you is;

    My imported .xls data contain numerical and text columns, is it possible to filter the data by the text.

    eg column “status” contains NEW, UPDATE, INACTIVE and DELETE. Can i filter the spreadsheet to display all rows with the UPDATE value in the staus column?

    Many thanks,

    Waggy

  6. dhull replied on March 2nd, 2009 at 18:38 UTC :

    Waggy,

    http://blogs.mathworks.com/videos/2007/09/06/matlab-basics-video-absolute-and-logical-indexing/

    Watch the whole thing, but at about 2:30 there is a section where you find the rows of interest and then use that list to index into a matrix. It could be the same matrix, or in your case a totally different one.

    if you watch the rest of the videos in the basics section (especially from September 2007) you should be fine.

    http://blogs.mathworks.com/videos/category/matlab-basics/

    Let me know if you need help after that.

    Thanks,
    Doug

  7. Waggy replied on March 3rd, 2009 at 21:46 UTC :

    Doug,

    Incredible help,

    Thank you,

    Waggy

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

Doug Hull is a proud MathWorker who is on a mission to help you with MATLAB.

Doug's picture

Subscribe


Blog Admin

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