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

  • Zach: Hi Doug and Les, I didn’t have a lot of time to mess with this, but I did find a work-around. I plotted...
  • hamed: k
  • Les: @Zach This isn’t exactly what you are looking for but at least it puts all three parameters on the same...
  • Zach: Thanks for your suggestions Doug. I’ll give that a shot and see what happens. I’ve seen many of...
  • Doug: @Zach, I would say to use plotYYY, because that is close to what you want, but using depth as Y makes sense....
  • Doug: @Teja, I think this will work: http://www.mathworks .com/access/helpdesk /help/techdoc/ref...
  • Gify: merry christmas :) nice christmas tree! Regards, Janet Gify
  • Teja: Dear Doug Is there anyway to plot a surface from nonuniform data without meshgrid and griddata? Basically i...
  • Zach: I’m working with geophysical data, so I’d like to produce a depth profile. The y-axis would be...
  • Doug: @Ashok First, please do not use variable names that are MATLAB commands (std and mean). Second, p(j) should be...

Blog Admin

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