Export normalised, weighted and/or SingleScore results

Question

If I export the LCIA results as an excel, the resulting excel document shows the impact analysis results (at midpoint), but does not include the normalised/weighted or single score results. As they are shown in my OpenLCA results, I can copy them manually into a separate excel document. But I was wondering if there was a way to do this more efficiently and export ALL results alltogether at once? Thanks for the advice! Yanne

Comments

Hi, may I ask how did you copy them manually into a separate Excel? I am trying to copy my Midpoint results from the quick Impact Analysis tab (I don't do the Direct calculation to save time...), but I can't find the way.
thanks in advance

---

Hej, I must say I use a particular approach as OpenLCA is installed on an external server (with better performance as my notebook), and there is no Excel installed there. So there is no direct way of copying results into excel: I copy the results from OpenLCA manually (by selecting them, then right click “copy”) and paste this into a Notepad file.
After transferring this notepad file to my computer, I copy the text in the notepad file manually to an excel document. And this works fine; all data is sorted in columns as it should.
So if you can’t copy results in an Excel file, maybe you can copy them into Notepad and this works for you as well: first copy into Notepad, and then copy the Notepad text into Excel? Hope this does the trick for you!!! Good luck!!
Best of course would be if ALL results would be directly exported to an excel, but as mentioned above, this seems to work for the midpoint results, but not for the weighted or endpoint results.

---

Thanks for the reply. I was wondering though if I could copy the results from the Impact Analysis tab (which is waaaay faster than the Direct calculation step). On another post it is said that you can do this by right-clicking and choosing "copy", but this option does not appear to me. Perhaps it's only available for the Direct calculation results, donno. Thanks anyway! By the way you could use OpenOffice or LibreOffice Calc in your server, surely will work better than Notepad.. ;)