Skip to content

Instantly share code, notes, and snippets.

View iphoting's full-sized avatar

Ronald Ip iphoting

26 followers · 20 following
View GitHub Profile
@iphoting
iphoting / gist:c5095851b9bb432f9af1
Created March 31, 2015 09:23
Excel: Sequential Serial Numbers Formula
=IFERROR(IF(NOT(AND(ISBLANK(INDIRECT(ADDRESS(ROW(), COLUMN()+1))), ISBLANK(INDIRECT(ADDRESS(ROW(), COLUMN()+2))))),INDIRECT(ADDRESS(ROW()-1, COLUMN()))+1,""),1)
@iphoting
iphoting / keybase.md
Created October 29, 2014 12:39
keybase.md

Keybase proof

I hereby claim:

  • I am iphoting on github.
  • I am iphoting (https://keybase.io/iphoting) on keybase.
  • I have a public key whose fingerprint is 6A7E AB1E A822 E621 4DEC 11C4 F355 0635 71D7 1151

To claim this, I am signing this object:

@iphoting
iphoting / boxstarter.txt
Last active January 2, 2016 11:19
Boxstarter Script
Set-ExplorerOptions -showHidenFilesFoldersDrives -showProtectedOSFiles -showFileExtensions
Enable-RemoteDesktop
Set-TaskbarSmall
cinst Microsoft-Hyper-V-All -source windowsFeatures
#rem cinst PowerShell
cinst powertab
cinst pscx
cinst teamviewer
#cinst avastfreeantivirus
@iphoting
iphoting / newrelic.yml
Created December 31, 2013 04:47
Cleaned Up Ruby New Relic Agent Configuration File
#
# This file configures the New Relic Agent. New Relic monitors
# Ruby, Java, .NET, PHP, and Python applications with deep visibility and low overhead.
# For more information, visit www.newrelic.com.
#
# Generated June 03, 2013
#
# This configuration file is custom generated for Barsoom
@iphoting
iphoting / global.gems.linux
Last active December 16, 2015 12:08
global.gems for RVM in /usr/local/rvm/gemsets/global.gems
rubygems-bundler
bundler
rake
rvm
heroku
powder
foreman
guard
guard-bundler
@iphoting
iphoting / play
Created March 28, 2013 08:12
play shell script. Put in ~/bin
#!/usr/bin/env bash
export JAVA_HOME="`/usr/libexec/java_home`"
PLAY_HOME="~/Development/Java/play-latest"
exec ${PLAY_HOME}/play $@
@iphoting
iphoting / expenses-by-month.sh
Created February 27, 2013 04:19
Ledger output for Expenses by Month specified.
#!/usr/bin/env bash
if [ "$1" ]; then
MTH="$1"
else
MTH="`date +%b`"
fi
echo "Month: ${MTH}."
@iphoting
iphoting / ledger.sh
Last active March 29, 2019 06:00
Ledger Bash Completion
# Assumption : bash-completion package is installed and enabled
# Try it : just "source ledger"
# Here are three possible ways to install this file
# 1. As ~/.bash_completion file
# 2. As ~/.bash_completion.d/ledger file, with additional file
# ~/.bash_completion which contents ". ~/.bash_completion.d/ledger"
# 3. As /etc/bash_completion.d/ledger
_ledger()
{
@iphoting
iphoting / .powrc
Last active December 12, 2015 09:08
.powrc to be committed.
# detect `$rvm_path`
if [ -z "${rvm_path:-}" ] && [ -x "${HOME:-}/.rvm/bin/rvm" ]
then rvm_path="${HOME:-}/.rvm"
fi
if [ -z "${rvm_path:-}" ] && [ -x "/usr/local/rvm/bin/rvm" ]
then rvm_path="/usr/local/rvm"
fi
# load environment of current project ruby
if
@iphoting
iphoting / Gemfile
Created January 22, 2013 15:32
Bundler < 1.2.0 compatible Gemfile
source :rubygems
ruby "1.9.3" if Gem::Version.new(Bundler::VERSION) > Gem::Version.new('1.2.0')
gem 'sinatra'