Blog

  • Update to Weekly Gantt Excel Spreadsheet

    February 23, 2012

    I was putting together a development plan and bid for a new project, and found myself using my Gantt Chart Spreadsheet, weekly version to visualize how the project might take. That’s when I discovered that I hadn’t set it up for an arbitrary starting date.

    So I fixed it.

    Gantt Weekly Update The new weekly version is available to download as version 5, over on the Gantt Excel page. This is merely useful for generating a kind of “gantt graph paper”; it’s not a full-blown project management tool with auto-allocation and calculation of time. It’s good for outlining and quick estimating, though.

    As a bonus, the new weekly version can be cut and paste into other spreadsheets (which I needed to do) and it still works. Select the range A1:F17 in your cell copy, and paste into your own worksheet. To extend the range of days, select the last two columns and stretch ’em to use ordinary Excel range extrapolation. If this doesn’t make sense, watch the video on the Excel Gantt page and this may help.

    Read more
    DSri Seah
  • Harvard Business Review: The Value of Happiness

    February 21, 2012

    The Jan-Feb double-issue of Harvard Business Review has an excellent series of articles about happiness in business. I was pleasantly surprised when I grabbed it at the airport; getting an issue of HBR is one of my self-awarded travel perks, and I didn’t even look at the cover! From some countries move from GDP to Happiness as their prime measurement of economic accomplishment, to the very history of Happiness, this is a great collection of articles for those of you looking seeking a rational basis for fulfillment. Highly recommended.

    Read more
    DSri Seah
  • San Diego Bound

    February 7, 2012

    I’m going to be in San Diego for business, and will hopefully have some free time over weekend from 2/11 to 2/13. The last time I was in this part of the country, I think, was in the late 1990s for my cousin’s wedding…wow! I may have some time to hang out on Sunday if there are any readers in the area who want to talk shop or have a very low-key meet-up at a coffee shop somewhere. Leave a comment below if you’re interested.

    I’ll be somewhere in the “Mission Hills” neighborhood, which I’m not familiar with at all…I gather it is near the airport. I’m looking forward to getting a little sun.

    Read more
    DSri Seah
  • Wearable Focus Aids for the Easily Distractable

    February 6, 2012

    I have been very distracted lately. There’s a lot going on with personal and client projects, and I’ve had to be very flexible with my scheduling. Because of this, I find myself task-switching more often than I like, which means reloading my brain with another context and skill set. Jumping between writing code, doing design strategy, and visual design is (for me) enormously taxing. For example, I forget how to have a normal conversation after I’ve been coding for a while and talk like a malfunctioning robot. Likewise, moving from the more visual/social activities into programming demands that I retreat into a little box, which I don’t like doing. Household chores are another drag.

    Index Card Nagger I’m at the point now that my brain is in full rebellion, and is eagerly jumping at anything that looks like a fun distraction. It got so bad on Saturday that I actually wrote down that I was going to do LAUNDRY on an index card, complete with a step-by-step list, and then used an old badge lanyard to wear around my neck. Everytime distraction threatened me, I would look at the card yoked below my neck. It looks ridiculous, but I can pretend I’m at a Laundry Conference, and it actually did help me muddle through my laundry task list. Yay!

    Index Card ScabbardBecause I like ridiculous ideas, I do like the concept of wearing your tasks. I once made an Index Card Scabbard out of an archery arm protector and a pen protector sheath. It’s one of those love/hate things; a hardy few proclaimed their support, while others posted funny remarks on Lifehacker, along the lines of, “I’m not as dysfunctional as THAT idiot”. That said, perhaps it is time to bring it back. I certain could use it. In fact, there are a number of options available out there.

    Recently, reader Jesse’ forwarded me some links to a “tactical arm board” and similar products used by pilots, as he had been using them himself and wanted to let me know what he’d found:

    • Tactical Arm Boards are used by military personnel in the field, holding maps and other such things. They’re similar to the football wrist coaches, except built for heavy-duty use. There’s one that folds out into a map, but this Mayflower Arm Board seems to fit the bill with both external and internal compartments. The football wrist coaches are cheaper, but they also look flimsy.
    • Pilots use knee boards and armboards too. Jesse’ forwarded this link to a pilot writing armboard which is essentially a notepad on your wrist. It looks gigantic, but if you’re writing down stuff while flying, I guess this is what you want.

    • While surfing for good web links, I stumbled upon this WristWriter, the so-called “toolbelt for the wrist”. It’s a scrolling paper wristpad, using waterproof Rite in the Rain paper. I’m going to have to order one just to have in my collection.

    <

    p>The lanyard approach, if it’s not uncouth to toot my own idea, is less extreme-looking than any of these products (though I still want them all!). I may go find a nice piece of wood laminate and cut a slot in it to serve as a surface for sticky notes so I can wear them around my neck. For extra stealth, I could make it look like an actual security badge on the outside that flips open somehow at the press of a finger to show you your to-do list. Or, I can just use thick index card stock and a slot punch. The important part to me, though, is the step-by-step list that accompanies the to-do task list. Might not be a bad thing to do; reader ChewLH mentioned another aviation-themed product idea to me a few months ago that might work well with it, but it’s not my idea to share.

    As a concluding observation, there’s something very satisfying about wearable information aids. Wearing a watch, for example, has been very reassuring when I’m flying. I usually just use my cell phone to tell the time these days, but having a watch(especially one you like) gives you INSTANT TIME OF DAY. That little bit of assurance helps keep me from freaking out when I wonder what time it is, for the 100th time, as I’m waiting to board. To-Do lists have something of the same power, but when they’re not easily accessible they lose their immediacy and directness; this is one issue that smartphones and PDAs have, as the to-do list takes a few taps to pull up usually, and in the process you may get distracted by something else you see.

    There may be something more intimate–and therefore stirring more commitment–about wearing your task list. Unfortunately this conflicts with looking organized; wearing your list around your neck makes you a target for ridicule if you’re not a pilot, football coach, astronaut, or squad leader. Those watch-shaped Post-It pads are a step in the right direction, but this will be a tough one to crack.

    Read more
    DSri Seah
  • You Loved the Manual. Now Buy the Product!

    February 4, 2012

    Over on Kevin Kelley’s Cool Tools, I came across a post about how he downloads the manual before purchasing the product as a kind of preemptive RTFM. It makes tons of sense. How many times have you purchased what you thought was a good (if expensive) fit for your needs to discover major limitations that are not pointed out on the packaging? By reading the manual first, you can discover the true specifications before you buy. I LIKE IT!

    Read more
    DSri Seah