Tuesday, February 24, 2015

SUM filtered rows in LibreOffice using SUBTOTAL

In Libre Office Calc you sometimes need to filter data using the Autofilter. And of course you would like to know the sum of the values filtered. This is where you'll want to use the SUBTOTAL() function. To get the subtotal of the filtered values you'll need to tell the subtotal function which function you would like to use on the filtered rows.

Monday, January 26, 2015

LibreOffice - using INDIRECT() for cell referencing

At times I need to summarize values from another sheet in Libre Office, and get an output that will group some values together. In my example I have a small table that could contain from 10 to 1000 rows. The table I want is to be grouped by date, and I want to know how much I have spent on a specific day.

Friday, March 7, 2014

Cleaning out linux-image-x.x.xx-xx-* files

I was suddenly denied access to my in-house web-server with a message telling me the disk is full. After a quick check with df -h I could confirm the root partition used 100%.
First I started to look for "user -files" I could remove, but found out there wasn't all that many of them. Most of the usage was in the folders /lib, /usr and /var. A quick question to my friend google took me in the direction that there could be some linux-image files no longer used that were spending my disk.
Some more searching gave me the following solution to removing these unused kernel files:

Wednesday, January 29, 2014

Personal emails - Mail Merge add-on

 About a year ago I added some info about this little add-on for thunderbird calle Merge Email. I then described how-to use the address-book to make merged emails. Since I am a bit of a fan of this add-on I'll describe using it with a csv-file.

Thursday, January 23, 2014

Making or burning ISO images

I was given a burned CD from a friend and decided to make an ISO image of that particular CD. Currently I'm using Ubuntu 12.10 and decided to use the Linux-command: dd

But to my surprise; IT WOULDN'T WORK!!! I have always used that command to make an ISO image, so now I had to figure out why this is not working, and how I could make it work.

Monday, January 20, 2014

LibreOffice 4.1 Solver example

While going through my accounting I found some discrepancies. So I needed to go through a long list of numbers and check whether they have been included in the totals I was checking.
Of course I would like not having to spend hours doing this, so I decided to find out how I could do this using LibreOffice Calc an save myself a lot of time. The time spent making the calculation is now about 1 second. (The time spent figuring this out... Let's just say hours....)