Fun Pyramid Set Math

Push Up PyramidsIf you’re doing work out sets with a pyramid, i.e. 1, 2, 3, 4, 3, 2, 1 , there is some really cool math to figure out your totals, or work backwards from a total to get your max count in the pyramid.

Pyramids are a great way to increase your max rep in a given set, for example in pushups, pullups, and situps. For example, with a maximum number of reps at 5, you can knock out a total count of 25.

Now, for the fun math. Continue reading “Fun Pyramid Set Math”

Building a Snow Cave

Building a Snow Cave
The view from inside our snow cave

So you wanna build a Snow Cave? Thankfully it’s a lot easier than I thought – easy as in not complicated, that is. Building a snow cave takes a lot of hard physical labor, but is well worth it in the end as you have a comfy, flat, dry, above freezing home for the night.

This weekend, George, Greg and I ventured off to into the great outdoors for two days of snowshoeing and winter backpacking with some big ideas of how we could spend the night.

On Friday afternoon, I had read about the IceBox which unfortunately is only available online from REI and occasionally at their flagship store in Seattle. The IceBox is a brilliant invention which allows for the creation of perfect igloos, even with less than ideal snow. As I would not be able to acquire this in time for our trip, we had to make do with building a snow cave, and hauling in a 3 person tent and tarps in case that didn’t work out.

So where do you learn how to build a snow cave? Continue reading “Building a Snow Cave”

Extending the Battery Life of Verizon Android Phones

Android Low BatteryIf you have an android phone such as the Droid or Incredible, you know how horrible the battery life is. If you don’t touch the phone all day, you MIGHT make it to lunch time before needing to recharge it.

Thanks to Terry, I now have two backup batteries and a dedicated wall charger for spare batteries with an extra spare battery in my pocket at all times for when I’ll be away from a wall outlet for more than 4-6 hours. Sad, I know.

The good news is that I discovered a fantastic way to extend the battery life of your android phone on the Verizon network. Continue reading “Extending the Battery Life of Verizon Android Phones”

Reducing PDF File Sizes on OSX

ColorSync UtilitySometimes when I print a file to a PDF, the resulting file is HUGE. There’s no reason for a print-ready 1 page, mostly text page made in Microsoft Word to be 7 – 40 MB.

Fortunately, there’s a little-known, but super-effective solution to reduce the size of your PDF files dramatically.

Open ColorSync Utility (search for it using spotlight) and then drag your PDF file to the ColorSync Utility icon in your dock to open it. From there, you’ll see a drop down on the bottom left.

Choose Reduce File Size and click Apply. Save the file and note the drastically reduced file size. I’ve gone from 7MB to 500kb with two clicks and even better in some cases.

Goodbye bloated PDFs!

Copying and Pasting Non-Hidden (Visible) Cells in Excel

Selecting Visible Cells Only in Excel
Selecting Visible Cells Only in Excel

Every have a huge spreadsheet with some hidden rows and columns, only to find that when you copy and paste the data, all the hidden data comes along for the ride?

Guess that would be helpful sometimes, but other times, you just want the visible data to be copied leaving the hidden rows and columns behind.

I searched the web and found solutions that involved filtering, re-hiding the data you didn’t want to see, and even using macros to get the job done.

The best answer, though, goes to April, who shows how to select just the visible cells and then copy and paste away. Continue reading “Copying and Pasting Non-Hidden (Visible) Cells in Excel”