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

  • Beats: Not useful for everyday but very interesting. Thanks.
  • nickey: Hi Brett, I’ve tested Tao’s program and yours too. They ran successfully. I’ve tried to...
  • Kika: THANK YOU!! I’ve been trying to change the colormap but I didn’t know what to do. It was driving me crazy!...
  • Richard: Hello Doug, yet another question. I followed this tutorial: http://blinkdagger.c om/matlab/matlab-...
  • Doug: Richard, Use the compiler options file, it is found at the bottom of the dialog that you get when clicking on...
  • Richard: To whom it may concern, a solution to the dos screen annoyance is found by user ‘vihang’ in this...
  • Richard: Thank you for your reply. I understand that I can specify flags using the mcc command, but is this also...
  • Doug: Richard: Find it here: http://www.mathworks .com/access/helpdesk /help/toolbox/compil er/mcc.html Doug
  • Richard: Hello Doug, Can you explain point 56. (about the -e flag) because I can’t seem to find it. Regards,...
  • Doug: Tony, When you say the .MAT file has 984 files, you mean it has the *names* of the files. So the real problem...

Blog Admin

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