Wednesday, December 15, 2010

Deleting a branch on Github

If you need to delete a branch you have created on github or any ohter remote git repository, heres how to do it.

Sunday, December 12, 2010

Excel tricks

First guest tip, from my colleague Jonathan Luker:

If you nest a MATCH() function inside a ISNA() function, it can make a column of TRUE or FALSE on the new data.

e.g. if I look for matches in ItemID between data in separate tabs:
=ISNA(MATCH(A2, 'Test-jul data'!$A$2:$A$15633, FALSE))
This will scan the list for matching ItemsIDs and put TRUE or FALSE in the cell beside each one.
Copy & paste for full list (takes a while to process of course!).

If you sort on that TRUE or FALSE column, you'll have all the new ones listed together.

There are a bunch of IS functions in Excel:
# Excel ISBLANK Function
# Excel ISERR Function
# Excel ISERROR Function
# Excel ISLOGICAL Function
# Excel ISNA Function
# Excel ISNONTEXT Function
# Excel ISNUMBER Function
# Excel ISREF Function
# Excel ISTEXT Function
Quite handy, especially when used with IF(), MATCH(), VLOOKUP(), etc.


Friday, December 10, 2010

Ubuntu

So, after buying a new HDD, comes the re-install of Ubuntu 10.04.
So far:

How to get back the kill X server key combo (in case of emergencys with complete X lockup)

Disable 3D desktop effects to get rid of annoying background flashing when playing flash videos in browser in full-screen.

To move the Gnome panels around, you first have to untick "Expand" in their properties and then you can drag&drop them where ever you like using std mouse left-click&drag.

Thursday, November 18, 2010

Git

If you are forced to use Git on windows behind a proxy this is soem useful information.
I only had to make use of the part at the end about disabling ssl verification.

Saturday, October 30, 2010

Scite, Nginx, ...

The Scite FAQ has helpful, especially how to set monspaced font for all file types.

My way of building nginx 0.8.53 on ubuntu 10.04:
(assembled from various sources on the net)
  1. wget http://nginx.org/download/nginx-0.8.53.tar.gz
  2. sudo aptitude install libpcre3 libpcre3-dev libpcrecpp0 libssl-dev zlib1g-dev libgcrypt11
  3. ./configure --prefix=/opt/nginx-0.8.53 --with-http_ssl_module  --with-sha1-asm --with-sha1=/usr/include


Friday, October 29, 2010

Why?

The point of this blog is to record all the useful bits and pieces of information I learn each day, for both my future reference and anyone else who needs it.