dave seah: better living through new media Filter Navigation Design Portfolio The Printable CEO Series The Printable CEO Series Compact Calendar Compact Calendar Back to Home Page Admin:Login

Viewing Category: ThinkingTools

Design Agency Process Diagram

POSTED 01/27/2010 UNDER DesignThinkingTools

Agenceum Process

In Monday's post I went through a process of recentering myself, and identified four areas to focus on and track. The trickiest one was DESIGN AGENCY, because there are a LOT of different tasks.

I just finished creating a "process diagram" that outlines a high-level roadmap of agency operations; just about any task I can think of fits somewhere the diagram. You can read about and download the PDF over on the Agenceum Blog, which is where I am running my "open design agency" experiment. Although this diagram is labeled for Agenceum, it really is for ALL of my design-related business activities.

Read more about the diagram on the Agenceum blog.

Compact Calendar Change for Reported Easter Calculation Bugs

POSTED 01/17/2010 UNDER ThinkingTools

This year's Compact Calendar added "automatic holiday calculation" when the year is changed in the Excel spreadsheet. Holiday calculations are terribly tricky, though, and a bug in the Easter Calculation was reported by Mike Kennedy with OpenOffice. The Easter calculation I'm using, he pointed out, assume date entry in a certain text format which is not universal. I went back and looked at it and saw he was right, though I couldn't duplicate the other reported bug. Anyway, I've uploaded a more robustly-coded version of original Easter calculation, which substitutes the locale-specific date string with the Excel DATE function.

UPDATE: After downloading OpenOffice and cross-checking the calculation with Google Spreadsheet, it appears that the cause of the bug is due to a difference between in how the DAY() function works for values under 61. So if you are using Excel you are fine, but OpenOffice users should probably use the EASTERSUNDAY() function.

UPDATE2: Here's an explanation of why Excel's DAY() function is buggy; it was originally to maintain compatibility with Lotus 1-2-3, which used to be the dominant spreadsheet.

In Excel 2007, Easter appears to be calculated correctly for the next five years. If you are outside the USA, you can re-download the ZIP file from the Compact Calendar Page for the more robust version of the calculation.

Concrete Goals Tracker 2010 Updates

POSTED 01/01/2010 UNDER ProductivityThinkingTools

Concrete Goals Tracker Updates

Pursue Tangible Results to Achieve Greater Goals

The Concrete Goals Tracker (CGT) is the original Printable CEO™ form, created one evening in 2005 to alleviate my desire to have a "trusted personal CEO" that would tell me what to do. I figured since I couldn't hire anyone to do the job, I might be able to go the cheap route and print one up on paper :-)

Designed for Minimal Tracking Effort

Task list

The idea is pretty simple: every time you complete something on the "worth doing" task list, you award yourself points. ONLY things you've done that produce tangible benefits are worth points, and the point scale is weighted so the most goal-directed criteria earn the most. Goal-supporting achievements, which tend to happen more frequently, are weighted less. It's up to you whether a task "counts" or not toward your goal. You can even award multiple points for a single task if it makes sense to you...try your best to optimize!

The list shown here is designed to create a successful freelance practice, based on the idea that "showing and talking about your work leads to more work". It lists categories of tasks that can be framed as being productive relative to your overall goal. For a freelancer, that's making stuff and showing it to people, and also talking to people constantly so you are on their mind. It all pays off when you get that check. There's a small business version too in the downloads section.

Tracker

As you accomplish various goal-related items throughout the day, fill in the appropriate bubble to log the points. At the end of the day, you will see how well you did (or didn't). Each CGT form tracks an entire week, so you will see how you did every day, and week-by-week...and most importantly, what you did to move yourself along your path. Since the items on the task list award points only for tangible results, you will have made actual progress.

The theory behind the form itself is described more in the original 2005 post on the Printable CEO and the followup Making of the Printable CEO; there is a good bit of video game design psychology embedded in this paper form.

Overall Application

The CGT has evolved into a bunch of other forms that help visualize different aspects of my workday, and I no longer use it daily because it actually did its job: it got me focused on some processes that actually deliver meaningful result; all I had to do was focus not on what they were, but how I could tell if I was on the right path or not, and whether my daily output was really helping me forward. The idea is pretty simple: by focusing on making things that people can see and counting what you've done in a simple daily manner, you plant the seeds for daily progress. This is a high level guidance tool, much like the way a good manager will tell you what she needs and you pick your own way of making that happen without a lot of micromanagement. With luck, this is a form you use to get started in a new direction, and then you will pretty much know what you need to be doing. I haven't heard much feedback about it lately, but the general impression I have is that people use it for 2 weeks to six months, then move on.

The concept is translatable to different fields too. For example, there was also some interest from a magazine, so I created a small business edition based on that.

Make New Year's Resolutions Printable Lists with the Editable Versions

There are "write-your-own" PDFs with suggested methodology for how I put together a good "worth doing" list, which is an art in itself. I've written instructions on how to create new year's resolutions using these forms. By using the make-your-own printable versions of the CGT, you can put together a pretty decent goal tracking kit using either 8.5x11 paper, index cards for you Hipster users, or mini-book formats (pocketmod compatible, even). There is also an editable Excel version.

Note: You'll need to use Acrobat Reader to modify the text fields in the editable PDF versions.


Download 2010 Concrete Goals Tracker Printable Forms

Standard Form



3x5" Index Card Printable Formats

Index Card Formats



PocketMod / MiniBook Format

The End Result


How to Fold


Editable Excel Goals Tracker

Excel Editable


  • Download Editable Excel version. It isn't pretty, but it gets the job done. Use to create your own variations in points. Note that this is not an interactive calculator or tracker spreadsheet as is.

For an overview of all the forms available, visit The Printable CEO™ Series Page. Enjoy!

Vote for 2010 Printable CEO™ Updates for 2010

POSTED 12/30/2009 UNDER ProductivityThinkingTools

SUMMARY: While the Concrete Goals Tracker, Emergent Task Planner, and Emergent Task Timer PDFs are being updated, the more obscure forms may not get an update unless I hear that someone needs them. The current roster of forms is listed in this blog post.

>> READ FULL ARTICLE

Compact Calendar 2010

POSTED 12/11/2009 UNDER ProductivityThinkingTools

Compact Calendar

The Compact Calendar is a printable calendar based on an Excel spreadsheet, designed to be easy to use in impromptu planning by yourself or with a group of people.

>> READ FULL ARTICLE

Thank you for printing this article! Please note that all material on this website is copyrighted by either David Seah or individual comment contributors. To request permission for republication and distribution, please contact David Seah (http://davidseah.com/contact).