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
- http://www.jkp-ads.com/articles/excel2007tables.asp?AllComments=True
See: Referencing cells in a table (structured referencing) - How to create running total using Excel table structured references?
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
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