Interesting Links

This page is a collection of interesting links we have come across and are worth mentioning.

May 18, 2015

Personal note: update domain set name = ‘’

March 16, 2015

Instead of writing:

If (something != null) {
    val = something 
} else { 
    val = defaultValue 

You may write:

val = something ? something : defaultValue


February 2, 2015

Keep local modifications in Git-tracked files:

git update-index --skip-worktree FILENAME
git update-index -–no-skip-worktree FILENAME

November 30, 2014 – Excel Tables / Structured Data

The specific links above deal with using Excel structured references. Excel tables are almost like mini worksheets embedded into your worksheet. If you wanted to have e.g. a moving average you could use something like below.



The above calculates the average of items in a range starting from 1st cell of “DataColumn” table column, to current row (@DataColumn).

Another interesting function is the offset function that allows the calculation of stuff such as this row minus previous row.



Note: Please replace “;” with “,” if your in North America.


July 9, 2014 – Port Forwarding

June 26, 2014

September 21, 2013

March 21, 2013

Excel formula to convert ISO 8601 formatted timestamp into Excel datetime

March 15, 2013

Best Tools to Monitor Tomcat

March 14, 2013

How to crop a mp3(or video) from x to xn using ffmpeg 

February 1, 2013

How to use Boost in Visual Studio 2010

Migrating an existing Windows 7 installation to an SSD

January 31, 2013


January 26, 2013

Varnish: Reloading VCL configuration files with varnishadm

January 23, 2013 

W3C XML Schema Design Patterns: Dealing With Change

Leave a Reply


8 + 1 =

This site uses Akismet to reduce spam. Learn how your comment data is processed.