I use LibreOffice to analyse test data generated in csv files, with a new csv file for each test run.
My process in the past has been to load the csv files into calc, import the calc sheet into base, create a query for the appropriate records, import the query into calc via F4 (now “CTL-SHIFT-F4”) so that I can perform more calculations on it and graph it, then copy the graphs into writer for presentation. The process works, but feels very clunky.
What I desire in the final result is
- the ability to review data and weed
out bad stuff before committing to
- the ability to select data sets with a query
- the ability to do calculations on the data from the query
- ability to graph the data after analyzed
- ability to put the graphs in writer documents
- ability to update the graphs as the calculations are refined
I am currently stuck at item 6, because the graphs copied to writer lose any link back to the original calc document. This means the error prone and tedious process of upgrading each and every graph in a document every time it is tweaked, or possibly going back and tweaking the calc document to match the writer document. My rule of the thumb is that if there are two different versions of anything you will invariably get the wrong one, so there should only be one version.
I now realize that I set this up based on experience with Microsoft Office, and suspect there might be a better way to set things up in LibreOffice. I think this workflow and basic requirements are very similar for anyone doing scientific work. Is there a better way to set up LibreOffice to handle this work?