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.
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.
I only had to make use of the part at the end about disabling ssl verification.
Sunday, November 14, 2010
Tuesday, November 2, 2010
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)
My way of building nginx 0.8.53 on ubuntu 10.04:
(assembled from various sources on the net)
- wget http://nginx.org/download/nginx-0.8.53.tar.gz
- sudo aptitude install libpcre3 libpcre3-dev libpcrecpp0 libssl-dev zlib1g-dev libgcrypt11
- ./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.
Subscribe to:
Posts (Atom)