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.
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!
Other videos have been gathered here:
Practical example videos have been gathered here: