Hello,
Recently I finished collecting data about M.2 SSDs. I'm planning to buy one and needed a different metric then is typically used by reviewing sites. I broke out libreoffice and soon had a spreadsheet with lots of data in it.
The problem is that the name for the rows and columns are pretty far away from the vast majority of the actual data making identifying the fields something of an art, even for me.
I know that I could use gnuplot to give me what I want but the manual is 800 pages of bliss (which would take too long to read). I might be able to use a tool inside libreoffice to do data analytics but my entire being is telling me that there's a tool out there for me and I'm going about this the hard way or the "Learn the IDE" way, both of which have large downsides. I know I already tried using the builtin math functions and broke one of the metrics results.
All the numbers are integers or can be promoted to integers.
Ideas?
Thanks!

Anything will have a learning curve - better probably to use what you have already. Calc has graphing (charts) and math functions as you mention. Also has a pretty average reputation for intensive work.
Might be worth doing some data reduction if the data are all over the place as you describe. Delete (or hide) rows/columns if you can easily identify them. I might be inclined to export as csv and use something like awk - say " if column2 and column3 and column28 are all zero delete the entire record". Then re-import the reduced file.
The less work you give calc, apparently the better - me purely surmising from what I read of users complaining.

1 members found this post helpful.

I'm not a .

Good idea, but it would be nice to visualize it in some way. I wonder if awk could generate an xpm image. Hmm...... You have me thinking of something penguiny.

It took me about five minutes to figure out gnuplot. There are plenty of examples online.