Scale CPU frequency

Required tools:
And all that it needs.

Then the scaling policy can be changed by e.g.:
sudo cpupower frequency-set -g powersave
CPU speed governors are:

See the links below for more information.

What I installed to do that is:
sudo apt-get install linux-tools-generic linux-cloud-tools-generic
sudo apt-get install cpufrequtils
sudo apt-get install linux-tools-common
sudo apt-get install linux-tools-generic linux-cloud-tools-generic
sudo apt-get install linux-tools-4.2.0-35-generic linux-cloud-tools-4.2.0-35-generic



Restart wireless on kubuntu

Sometimes on my laptop I cant get any wifi to work... then I have to:

sudo service network-manager restart

Easy jpeg compression from command line

An tool to easily compress jpegs to a target filesize is:

jpegoptim --size=250k tecmint.jpeg
If not installed, do this:

sudo apt-get install jpegoptim



Resize VirtualBox images/discs

Is simple as

VBoxManage modifyhd "/Users/xxx/VBox VMs/Windows/Windows 7.vdi" --resize 32000

After that one has to use a partitioning tool in the VirtualBox Guest to adjust the main partition to fill the drive.


Reloading the soundsystem

Reloading the soundsystem in unbuntu:

pulseaudio -k && sudo alsa force-reload


Dealing with spaces in filenames

As I always forgot how to properly deal with it when scripting things -.-, here is one solution on how to deal with spaces in file names and processing it properly in a loop.

find . -print0 | while read -d $'\0' i; do mv "$i" ./; done

Source: http://www.cyberciti.biz/tips/handling-filenames-with-spaces-in-bash.html


Fix/rescue broken video

To fix or at least do a partial rescue, one could try playing with this line:

mencoder -forceidx -oac copy -ovc copy /tmp/src.mp4 -o /tmp/dst.avi


Free music for commercial use

Moving data from an old google sheet to a new google sheet

My original intend to use a new functionality in google sheets on a sheet I already created with the old version. As I already had a lot of content I didnt want to rewrite everything. And I only wanted to add a few formulas using "COUNTIFS". And copy pasting from the old to the new didnt work.

Here is what did work for me to convert from old google sheet to a new google sheet:
In a spreadsheet created in the old version, click the down arrow next to a sheet tab and click Copy to…, and copy the sheet (and its contents) to a spreadsheet created in the new version.

You may find other solutions here:

Also google needs some versioning because "old" and "new" are not the best keywords to search for.

Kubuntu 13.10: Network not working after sleep

Here is the fix that worked for me: