How to Modify the Width of a Column in Google Spreadsheet

Google Spreadsheets is probably the go to spreadsheet application for most non-windows users. Windows users probably have their trusty Microsoft Excel spreadsheet application with them. Here are a few things on managing the width of columns on Google spreadsheets.

Lengthen the width of the column

  • Hover over the line between the columns
  • Click and drag the column to meet your desired width

Auto fit the width depending on the width of the content

  • Hover of the line between the columns
  • Double-click

 How to Add a Dropdown to a Google Spreadsheet

Google Docs are awesome and there are a lot of things to learn about them. Here is a tutorial on how to add a dropdown to Google Spreadsheet

Step by Step:

  • Select the cell or cells where you want to create a drop-down list.
  • Click Data and then Data Validation.
  • In Criteria, choose the option, List of items
  • Enter items, separated by commas and no spaces.
  • Click Save. The cells you have chosen will show a dropdown list of the items you created

Video Tutorial

 Heroku: Cannot run more than 1 Free size dynos

 Cannot run more than 1 Free size dynos.

This is a common error when you forget or cancel a connection to heroku when using commands like:

heroku run rake db:migrate
bc(language-bash). heroku run  rails c --app you_app_name

Check your sessions

You will need to check if you have any sessions running with:

$ heroku ps --app your_app_name
=== web (Free): bundle exec puma -C config/puma.rb (1)
web.1: up 2017/06/13 10:23:38 +0800 (~ 33m ago)

=== worker (Free): bundle exec sidekiq -c 5 -q mailers -q default (1)
worker.1: up 2017/06/13 10:23:19 +0800 (~ 33m ago)

=== run: one-off processes (1)
run.2943 (Free): up 2017/06/13 10:39:57 +0800 (~ 17m ago): rails c

Stop the session

We will need to stop the session so that we can create a new session which we can use.

heroku ps:stop run.2943 --app your_app_name
Stopping run.2943 dyno on your_app_name... done

Try to run your session

$ heroku run rails c --app your_app_name
Running rails c on your_app_name... up, run.9284 (Free)
Loading staging environment (Rails 4.2.8)
[1] pry(main)>


 Swift: How to Join an Array of Strings into a single String

It is a common task to join an array of strings into a single string in programming. Here’s how you do it in Swift.

Swift 2

let array = ["Matthew", "John", "Paul", "Peter"]

let stringOfNames = array.joinedWithSeparator(", ")

Swift 3

let array = ["Matthew", "John", "Paul", "Peter"]

let stringOfNames = array.joined(separator: ", ")

Screen shot 2016 11 28 at 10.13.45 am