Month: March 2015

Posted on by admin

How to create a .csv from a Google Spreadsheet

by tyler
by tyler in google, googlespreadsheet, data, googledocs | 1 min

Downloading a Google Spreadsheet as a .csv file is easy.

Tools:

  • 1 ea Google Drive

1Open your google spreadsheet

2Click File > Download as > Comma Separated Values

This will initiate a download of the current spreadsheet as a csv file!

Now learn about:

Always Clear Downloads in Chrome

by juniper in bugmenot, google, chrome

How to get the sum of a column in a Google Drive spread sheet

by hammerhead in internet, google, interwebs

Discuss this guide

var disqus_shortname = ‘howchootest’; (function() { var dsq = document.createElement(‘script’); dsq.type = ‘text/javascript’; dsq.async = true; dsq.src = ‘//’ + disqus_shortname + ‘.disqus.com/embed.js’; (document.getElementsByTagName(‘head’)[0] || document.getElementsByTagName(‘body’)[0]).appendChild(dsq); })();

Tools:

  • 1 ea Google Drive

Always Clear Downloads in Chrome

by juniper in bugmenot, google, chrome

How to get the sum of a column in a Google Drive spread sheet

by hammerhead in internet, google, interwebs

Join Us

©2014 howchoo.com | About your privacy | Sitemap
Posted on by admin

pestcontrol

Pest control can be traced back to the earliest instances of agriculture. The first evidence of chemical pest control refers to the Sumerians’ use of sulfur compounds as a form of reducing the effects of pests on crops.

Keep raccoons out of your trash can with bleach

by brokenlamp245 in home, pestcontrol, raccoons

Join Us

©2014 howchoo.com | About your privacy | Sitemap
Posted on by admin

How to check PHP syntax using the command line

by tyler
by tyler in code, php, programming, webdev | 1 min

If you’re using PHP for web developoment, you may often want to check the syntax of your file without opening it in a browser. Checking syntax is quite easy from the command line.

Tools:

  • 1 ea shell
  • 1 ea PHP

1Open Terminal or any other unix shell

If you’re on a Mac you can open Terminal which is located in: Applications/Utilities

2Navigate to your project folder

You can navigate to your project folder by using the change directory or cd command followed by the directory. For me it is: cd /Users/josephtylerjones/Developer/scripts/

3Use the php command with the -l option

Now you can check the syntax of your script by running php -l followed by the file name. For me it is: php -l testfile.php This command will detect any syntax errors in your script!

Now learn about:

Custom Key Mappings Vim

by Ashley in vim, code

Python collections

by tyler in python, code

Debugging your Python code

by Ashley in python, Debugging, code

Discuss this guide

var disqus_shortname = ‘howchootest’; (function() { var dsq = document.createElement(‘script’); dsq.type = ‘text/javascript’; dsq.async = true; dsq.src = ‘//’ + disqus_shortname + ‘.disqus.com/embed.js’; (document.getElementsByTagName(‘head’)[0] || document.getElementsByTagName(‘body’)[0]).appendChild(dsq); })();

Tools:

  • 1 ea shell
  • 1 ea PHP

Custom Key Mappings Vim

by Ashley in vim, code

Python collections

by tyler in python, code

Debugging your Python code

by Ashley in python, Debugging, code

Join Us

©2014 howchoo.com | About your privacy | Sitemap
Posted on by admin

A new type of guide

by tyler
by tyler in howchoo


We’re experimenting with a new variation of a guide called “guide post”. Currently only privileged users are able to create guide posts, but they will soon be open for everyone.



Standard guides are designed for creating step-by-step tutorials, but we thought it would be useful to create a more traditional blog-style guide.



At first, guide posts will be written using HTML until we decide on an appropriate text editor or markdown.



Why not use TinyMCE?



TinyMCE seems to be the go-to editor for situations like these. WordPress and many other CMS platforms have painfully integrated TinyMCE as their editor, but from my experience it doesn’t provide enough flexibility and it can be difficult to work with due to a lack of useful documentation. We may start exploring other web based text editors, but for now I’m going to stick with our HTML editor provided by CodeMirror.



Why use guide posts?



There are many times when you’ll want to create a guide that isn’t restricted to the step-based guide format. Being that guide posts are more flexible, you can use them to create a simple resource like a picture or document to include on another guide, or you can use the guide post as a master guide with links to other related guides.

Now learn about:

How to add a guide in howchoo

by tyler in howchoo

Discuss this guide

var disqus_shortname = ‘howchootest’; (function() { var dsq = document.createElement(‘script’); dsq.type = ‘text/javascript’; dsq.async = true; dsq.src = ‘//’ + disqus_shortname + ‘.disqus.com/embed.js’; (document.getElementsByTagName(‘head’)[0] || document.getElementsByTagName(‘body’)[0]).appendChild(dsq); })();

How to add a guide in howchoo

by tyler in howchoo

Join Us

©2014 howchoo.com | About your privacy | Sitemap
Posted on by admin

Get a free vehicle history report

by tyler
by tyler in autos, vin | 1 min

Before you buy a car you will likely want to get a vehicle history report. Carfax seems to be the name that comes to mind when the search for a vehicle history report begins, but unfortunately they charge quite a bit of money for a single report. I’ve dis

Tools:

  • 1 ea internet browser

1Get the VIN number for the car

The VIN number can often be found on the side of the drivers side door.

2Search for ‘dealer autocheck inurl:vin’ in Google

Currently the first result is from dealersuite.com. Although this search will look for any site that does an autocheck and has ‘vin’ in the url. In this case, you will be able to replace your vin number with the vin number in the URL in hit ‘Enter’.

3Replace the vin number in the url with your vin number

The vin will likely be in the second part of the url after the ? and it may look something like this vin=xxxxxxxxxxx. After replacing the vin and hitting ‘Enter’ it should run the report for you vehicle!

Now learn about:

Power window motor/regulator replacement (Honda Element)

by FifthElement in honda, element, autos

Discuss this guide

var disqus_shortname = ‘howchootest’; (function() { var dsq = document.createElement(‘script’); dsq.type = ‘text/javascript’; dsq.async = true; dsq.src = ‘//’ + disqus_shortname + ‘.disqus.com/embed.js’; (document.getElementsByTagName(‘head’)[0] || document.getElementsByTagName(‘body’)[0]).appendChild(dsq); })();

Tools:

  • 1 ea internet browser

Power window motor/regulator replacement (Honda Element)

by FifthElement in honda, element, autos

Join Us

©2014 howchoo.com | About your privacy | Sitemap
Posted on by admin

home

Keep raccoons out of your trash can with bleach

by brokenlamp245 in home, pestcontrol, raccoons

How to get rid of weeds between pavers

by tyler in home, homeimprovement, organic

Join Us

©2014 howchoo.com | About your privacy | Sitemap
Posted on by admin

Securely empty trash in OS X

by vicarious
by vicarious in osx, mac, security, apple, tinfoilhats | 1 min

This guide explains how to securely empty your Mac’s trash can. This function overwrites the old data on your hard drive with a bunch of 0s, making it harder to recover.

Tools:

  • 1 ea Mac OS X

1To securely empty the trash

Hold down CMD-SHIFT and right-click the trash can icon. You will now see the Securely Empty Trash option appear.

To securely empty the trash

Note:

Securely emptying the trash might take a while if you have a lot of files.

Now learn about:

How to change the HipChat notification sound

by Zach in osx, windows, hipchat

How to disable Messages in OS X Yosemite (without disabling it on your phone)

by Zach in osx, apple, ios

How to enable emojis in iOS 7

by tyler in apple, ios, iphone

Discuss this guide

var disqus_shortname = ‘howchootest’; (function() { var dsq = document.createElement(‘script’); dsq.type = ‘text/javascript’; dsq.async = true; dsq.src = ‘//’ + disqus_shortname + ‘.disqus.com/embed.js’; (document.getElementsByTagName(‘head’)[0] || document.getElementsByTagName(‘body’)[0]).appendChild(dsq); })();

Tools:

  • 1 ea Mac OS X

How to change the HipChat notification sound

by Zach in osx, windows, hipchat

How to disable Messages in OS X Yosemite (without disabling it on your phone)

by Zach in osx, apple, ios

How to enable emojis in iOS 7

by tyler in apple, ios, iphone

Join Us

©2014 howchoo.com | About your privacy | Sitemap
Posted on by admin

transmit

How to show hidden (invisible) system files in Transmit for Mac

by Zach in osx, mac, apple, panic, ftp, sftp, transmit

Join Us

©2014 howchoo.com | About your privacy | Sitemap
Posted on by admin

How to open a phone app with an html link

by arthur
by arthur in webdesign, css, html | 1 min

If you’d like your visitors to be able to open a phone application straight from your website you can follow this quick guide.

1Create a basic HTML link

In the body of your website, create a basic HTML link like this:
222-333-4444

2Add ‘tel:12223334444’ in the href attribute

When you finish your link should look like this:
222-333-4444
replacing ‘12223334444’ with your phone number including the country code and area code.

Now learn about:

Use Chrome Developer Tools to check whether resources are loading over SSL

by Zach in webdesign, webdev, chrome

How to make YouTube videos responsive (without JS)

by Zach in webdesign, webdev, youtube, embed

Tell Chrome Developer Tools to use a dark theme

by Zach in webdesign, webdev, chrome, console

Discuss this guide

var disqus_shortname = ‘howchootest’; (function() { var dsq = document.createElement(‘script’); dsq.type = ‘text/javascript’; dsq.async = true; dsq.src = ‘//’ + disqus_shortname + ‘.disqus.com/embed.js’; (document.getElementsByTagName(‘head’)[0] || document.getElementsByTagName(‘body’)[0]).appendChild(dsq); })();

Use Chrome Developer Tools to check whether resources are loading over SSL

by Zach in webdesign, webdev, chrome

How to make YouTube videos responsive (without JS)

by Zach in webdesign, webdev, youtube, embed

Tell Chrome Developer Tools to use a dark theme

by Zach in webdesign, webdev, chrome, console

Join Us

©2014 howchoo.com | About your privacy | Sitemap
Posted on by admin

How to boil an egg

by tyler
by tyler in cooking | 20 min

Don’t be ashamed. This guide gets a lot of page views.

Tools:

  • 1 ea pot

Materials:

  • 1 tablespoon salt
  • 1 ea egg

1Place the eggs in a pot of water

Ensure there is 1 inch of water above the top of the eggs. The eggs will float, but you can estimate an inch of space.

Place the eggs in a pot of water

2Add a pinch of salt

This will help the shell separate from the egg.

Add a pinch of salt

3Place pot on stove, put on the lid and turn the heat on high

Place pot on stove, put on the lid and turn the heat on high

4Once the water comes to a boil, turn the burner off and leave the pot on the stove for 15 minutes

Once the water comes to a boil, turn the burner off and leave the pot on the stove for 15 minutes

5Chill the eggs by placing in cold water

This will cause the eggs to stop cooking, and help you separate the egg from the shell.

Chill the eggs by placing in cold water

Now learn about:

How to adjust your Hario Mini Mill coffee grinder

by daynejones in cooking, coffee

How to make pour over coffee with a Hario V60

by daynejones in cooking, coffee

How to bake salmon fillets

by tyler in cooking, recipes

Discuss this guide

var disqus_shortname = ‘howchootest’; (function() { var dsq = document.createElement(‘script’); dsq.type = ‘text/javascript’; dsq.async = true; dsq.src = ‘//’ + disqus_shortname + ‘.disqus.com/embed.js’; (document.getElementsByTagName(‘head’)[0] || document.getElementsByTagName(‘body’)[0]).appendChild(dsq); })();

Tools:

  • 1 ea pot

Materials:

  • 1 tablespoon salt
  • 1 ea egg

How to adjust your Hario Mini Mill coffee grinder

by daynejones in cooking, coffee

How to make pour over coffee with a Hario V60

by daynejones in cooking, coffee

How to bake salmon fillets

by tyler in cooking, recipes

Join Us

©2014 howchoo.com | About your privacy | Sitemap

Follow @howchoo and learn cool things!