Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 20 Sep 2016 19:30:39 +0200How can I use a sheet name in formulas? SHEET doesn't work!https://ask.libreoffice.org/en/question/77680/how-can-i-use-a-sheet-name-in-formulas-sheet-doesnt-work/Hi,
I am dumping data into sheets and naming them with dates, I want to have a master sheet that pulls info from lots of various sheets but I only want to type the sheet name once, not 25 times inserting it into formulas, by typing the sheet name into one cell and a formula referencing it, but it doesn't seem to work.
here is an example.
this works
=AVERAGE('20-07-16'.C1383:C1442)
but I want to use some thing like
=AVERAGE(A32.C1383:C1442)
where A32 is a sheet name?
Any thoughts on why this won't work?
Many thanks
JimJimtechTue, 20 Sep 2016 19:30:39 +0200https://ask.libreoffice.org/en/question/77680/Complicated Calc spreadsheet, how to classify a list by the "best"?https://ask.libreoffice.org/en/question/33227/complicated-calc-spreadsheet-how-to-classify-a-list-by-the-best/I'd rather explain what I need to do with an example instead of using words. Talking about LibreOffice Calc here.
Let's say that I have the detailed characteristics of 3 racing cars and want to sort/classify them from the best to the worst.
(downloadable example Calc file here: http://en.libreofficeforum.org/sites/libreofficeforum.org/files/uploads/WAZAAAAA_files/StupidExample.ods)
Ferrari - MAX SPEED:200km/h - ACCELERATION SPEED:8sec - MASS:1100kg
McLaren - MAX SPEED:110km/h - ACCELERATION SPEED:10sec - MASS:1090kg
Honda - MAX SPEED:120km/h - ACCELERATION SPEED:10sec - MASS:1091kg
The calculation should take in consideration that higher=better for MAX SPEED, and lower=better for ACCEL SPEED and MASS. It should also consider that the MASS advantage for the Honda over the Ferrari is a very small "victory" (+0,82%) compared to the huge difference in MAX SPEED (-66%).
Naturally, the results from the best to the worst in the example would be Ferrari 1st, Honda 2nd, McLaren 3rd, but how do I process all of this with Calc? And HOW MUCH (maybe expressed in percentage) is each car better than the other?
Thanks in advance.WAZAAAAASun, 27 Apr 2014 20:07:19 +0200https://ask.libreoffice.org/en/question/33227/