{"id":207,"date":"2007-09-28T08:35:34","date_gmt":"2007-09-28T13:35:34","guid":{"rendered":"https:\/\/blogs.mathworks.com\/videos\/2007\/09\/28\/expanding-the-gui-to-do-calculations-on-the-data-from-excel\/"},"modified":"2016-11-09T21:39:17","modified_gmt":"2016-11-10T02:39:17","slug":"expanding-the-gui-to-do-calculations-on-the-data-from-excel","status":"publish","type":"post","link":"https:\/\/blogs.mathworks.com\/videos\/2007\/09\/28\/expanding-the-gui-to-do-calculations-on-the-data-from-excel\/","title":{"rendered":"Video series: Expanding the GUI to do calculations on the data from Excel"},"content":{"rendered":"Last month we covered a lot of ground in making a GUI that would read and display Excel data. 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.\r\n\r\nFor 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. <a href=\"mailto:%20hull@mathworks.com\">Let me know!\r\n<\/a>\r\n<div><div class=\"row\"><div class=\"col-xs-12 containing-block\"><div class=\"bc-outer-container add_margin_20\"><videoplayer><div class=\"video-js-container\"><video data-video-id=\"3877438785001\" data-video-category=\"blog\" data-autostart=\"false\" data-account=\"62009828001\" data-omniture-account=\"mathwgbl\" data-player=\"rJ9XCz2Sx\" data-embed=\"default\" id=\"mathworks-brightcove-player\" class=\"video-js\" controls><\/video><script src=\"\/\/players.brightcove.net\/62009828001\/rJ9XCz2Sx_default\/index.min.js\"><\/script><script>if (typeof(playerLoaded) === 'undefined') {var playerLoaded = false;}(function isVideojsDefined() {if (typeof(videojs) !== 'undefined') {videojs(\"mathworks-brightcove-player\").on('loadedmetadata', function() {playerLoaded = true;});} else {setTimeout(isVideojsDefined, 10);}})();<\/script><\/div><\/videoplayer><\/div><\/div><\/div><\/div>\r\nOther videos have been gathered here:\r\n<a href=\"https:\/\/blogs.mathworks.com\/pick\/category\/video\/\">https:\/\/blogs.mathworks.com\/pick\/category\/video\/<\/a>\r\n\r\nPractical example videos have been gathered here:\r\n<a href=\"https:\/\/blogs.mathworks.com\/pick\/category\/practical-example\">https:\/\/blogs.mathworks.com\/pick\/category\/practical-example<\/a>","protected":false},"excerpt":{"rendered":"<div class=\"thumbnail thumbnail_asset asset_overlay video\"><a href=\"https:\/\/blogs.mathworks.com\/videos\/2007\/09\/28\/expanding-the-gui-to-do-calculations-on-the-data-from-excel\/?dir=autoplay\"><img decoding=\"async\" src=\"https:\/\/cf-images.us-east-1.prod.boltdns.net\/v1\/static\/62009828001\/f0071ea5-2e12-4d5a-8dd7-e0a0d7970207\/de4f45e6-fe5b-4b17-823c-9d4bcab0a510\/1280x720\/match\/image.jpg\" onError=\"this.style.display ='none';\"\/>\n      <div class=\"overlay_container\">\n      <span class=\"icon-video icon_color_null\"><time class=\"video_length\">5:10<\/time><\/span>\n      <\/div>\n      <\/a><\/div><p>Last month we covered a lot of ground in making a GUI that would read and display Excel data. Since those videos were originally posted, I have gotten quite a few requests to expand the GUI to do&#8230; <a class=\"read-more\" href=\"https:\/\/blogs.mathworks.com\/videos\/2007\/09\/28\/expanding-the-gui-to-do-calculations-on-the-data-from-excel\/\">read more >><\/a><\/p>","protected":false},"author":68,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,7,14,20],"tags":[],"_links":{"self":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/207"}],"collection":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/users\/68"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/comments?post=207"}],"version-history":[{"count":2,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/207\/revisions"}],"predecessor-version":[{"id":2744,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/207\/revisions\/2744"}],"wp:attachment":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/media?parent=207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/categories?post=207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/tags?post=207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}