Sooner or later, many of us need to process some numeric data in plain text format into spreadsheets with charts and formulas, which are both editable and compatible with people who only know how to deal with spreadsheets in office suites. Doing this manually is tolerable if it’s a one-time task, much less if you have to produce a new version of that spreadsheet, with fresh data, every day!
Luckily, if your raw data and the layout of the required spreadsheet have a constant structure, it only takes a bit of shell and Perl scripting to generate automatically a new OpenDocument spreadsheet with the same layout whenever the raw data change. Here is the full explanation and scripts.
