OpenOffice Calc Auditing Toolbar

The immensely useful 'Auditing Toolbar' facility of Excel has for no apparent reason been renamed the Data Detective in OpenOffice, and can be found on one of the menus rather than as a toolbar.

It allows you to trace which cells your values depend on, and which they influence. Sort of like a debugger for a functional language without recursion.

Ubuntu 10.04 NVIDIA restricted driver

Use restricted driver thingy to install nvidia driver. Everything is dead. No idea why.

at command line sudo nvidia-xconfig creates an xorg.conf file, after that it seems to work.

Ubuntu Wireless Connection from Command Line (WPA-PSK)

It can be useful to make a connection from the command line, without having to use the network manager. This is the magic incantation:

$ sudo ifconfig wlan0 down && sudo dhclient -r wlan0 && sudo wpa_supplicant -Dwext -iwlan0 -c/etc/wpa_supplicant.conf -dd & sudo dhclient wlan0

And the file /etc/wpa_supplicant.conf should contain:

ap_scan=1
ctrl_interface=/var/run/wpa_supplicant

network={
        ssid="YOUR_NETWORK_NAME_HERE"
        scan_ssid=0
        proto=WPA
        key_mgmt=WPA-PSK
        psk="PASSWORD"
        pairwise=TKIP
        group=TKIP
}