Matthew Moore crowdmatt

crowdmatt / unique-excel-columns.xls

Created April 23, 2013 00:16

=SUMPRODUCT((E2:E4106<>"")/COUNTIF(E2:E4106,E2:E4106&""))

crowdmatt / opsworks-chef-output-error

Created April 24, 2013 23:13

	---- Begin output of echo 'sinatra restart' && sleep 0 && ../shared/scripts/unicorn clean-restart ----
	STDOUT: STDERR: /opt/aws/opsworks/releases/20130418090734_113/vendor/bundle/ruby/1.8/gems/chef-0.9.15.5/bin/../lib/chef/node/attribute.rb:374:in `auto_vivifiy': You tried to set a nested key, where the parent is not a hash-like object: deploy/[MYAPP]/environment/RAILS_ENV/RAILS_ENV (ArgumentError)
	from /opt/aws/opsworks/releases/20130418090734_113/vendor/bundle/ruby/1.8/gems/chef-0.9.15.5/bin/../lib/chef/node/attribute.rb:280:in `get_value'
	from /opt/aws/opsworks/releases/20130418090734_113/vendor/bundle/ruby/1.8/gems/chef-0.9.15.5/bin/../lib/chef/node/attribute.rb:269:in `upto'
	from /opt/aws/opsworks/releases/20130418090734_113/vendor/bundle/ruby/1.8/gems/chef-0.9.15.5/bin/../lib/chef/node/attribute.rb:269:in `get_value'
	from /opt/aws/opsworks/releases/20130418090734_113/vendor/bundle/ruby/1.8/gems/chef-0.9.15.5/bin/../lib/chef/node/attribute.rb:134:in `each'
	from /opt/aws/opsworks/releases/20130418090734_

crowdmatt / s3-redshift-load.rb

Created April 26, 2013 00:25

Example of loading data into Amazon Redshift using redshift database adapter.

	ActiveRecord::Base.connection.execute(
	"copy campaign_events from 's3://BUCKET/FILEPATHPREFIX/' credentials 'aws_access_key_id=XXX;aws_secret_access_key=XXX' emptyasnull blanksasnull fillrecord delimiter '\|'"
	)

crowdmatt / sync-google-cloud-storage-with-s3

Last active December 17, 2015 13:19

gsutil -m cp -r s3://my-s3-bucket gs://my-gs-bucket

crowdmatt / unix-nanoseconds-to-date-in-excel.txt

Created May 24, 2013 19:34

=CELL/(1000000000.00*60*60*24)+"1/1/1970"

crowdmatt / .bash_profile

Created October 23, 2013 20:27