MatLab to Excel

Sometimes I have trouble visualizing some matrix structures that I create in MatLab. And when I get to see them in the MatLab command line or the matlab workspace it does not help much. A way to deal with that and seek and understand patterns easier is to export them in excel. MatLab supports this with the instructions:

xlsread (to read from an excel file) and

xlswrite (to write to one)

the parameters that follow are:

(filename, matrix(to be written max 2 dimensions), sheet, range)

by using the following one can create matrixes that contain both data and titles:

matrix1 = {‘Title1', Title2'; 1 423 ; 2 742; 3 192}

And to actually write in an excel file:

xlswrite('matrix1.xls', matrix1, 'Example Sheet', 'E1')

It is needless to point out the usefulness of this. One can either import data to MatLab from an excel (which amy be automated to produce desired data and easily editable) and once the simulation is done and the results are calculated they can be exported for further analysis in an excel too.

Both tools are very powerful mathematical tools each one with different properties. The combination of these both can really give solutions to many problems!

Benchmarking and statistics

Well I’m pretty sure that most of you out there like to compare hardware. The hardware you have, the hardware you will get, the hardware you had, the one your friends have, the neighbor’s and so on. The problem is that it is not easy to compare them if we don’t benchmark them. So, Passmark is a site that one can compare his CPU and GPU to any other CPU and GPU simply by searching for it! Or if you want to see how the new hardware racks up you can just visit the equivalent list.

I think that they offer a free 30days trial of their benchmarking tool as well if you want to check how you rig is doing. They also have a list of user benchmark (the 20 best and the 20 worst).

Apart from hardware other interesting statistics is operating system usage, browsers and so on. The classic flame wars that pop up in forums. Net Market Share offers real time data of the internet usage. ISPs , resolutions, operating systems, browsers, anything a curious guy wants to know. I found out this site when I was checking out that this August Windows Vista market share went lower than that of Windows 7. However Windows XP is still high.

So that’s enough to lose a couple of hours measuring stuff. I know you like it!