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

8:35 am | 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 9:33 am :
   

   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 am :
   

   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 2:14 pm :
   

   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 am :
   

   Please talk to the support team at:

   http://www.mathworks.com/support

   Thanks,
   Doug

Leave a Reply

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