Interesting Links

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

May 18, 2015

http://stackoverflow.com/questions/138162/wildcards-in-a-windows-hosts-file

Personal note: update domain set name = ‘menioshost.com’

March 16, 2015

http://colinharrington.net/blog/2008/10/groovy-elvis-operator/

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.

Example:

AVERAGE(
INDEX([DataColumn];1):
[@DataColumn]
)

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.

Example:

=[@DataColumn]-OFFSET([@DataColumn];-1;0)

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

 

July 9, 2014 – Port Forwarding

https://help.ubuntu.com/community/SSH/OpenSSH/PortForwarding
http://www.cyberciti.biz/faq/linux-unix-tcp-port-forwarding/
http://www.cyberciti.biz/faq/disable-the-mail-alert-by-crontab-command/

June 26, 2014

http://www.brandonchecketts.com/archives/creating-a-permanent-ssh-tunnel-between-linux-servers

September 21, 2013

http://www.sevenforums.com/tutorials/87555-user-profile-change-default-location.html

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

AXIS RTSP VAPIX API Documentation

January 26, 2013

Varnish: Reloading VCL configuration files with varnishadm

January 23, 2013 

W3C XML Schema Design Patterns: Dealing With Change

Leave a Reply

*

+ 39 = 45