Blog

  • Compact Calendar Change for Reported Easter Calculation Bugs

    January 17, 2010

    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.

    Read more
    DSri Seah
  • Quickie Logo Conversion

    January 14, 2010

    One of the Agenceum clients had a cool swirly glass sculpture that she likes a lot, so we tried turning it into a logo! She uploaded some photos of it, and I traced it with the last released version of Macromedia Freehand (circa 2004) instead of Adobe Illustrator CS4 (circa 2009).  Why? Because I saw a couple of videos, Illustrator vs Freehand and Illustrator vs Freehand Round 2, that reminded me how much I used to like Freehand for its power and ease in creating artwork. I switched to Illustrator back in 2005, and have been using it for my vector art needs since then. I’ve never really felt comfortable using its pen tool, though. How would going back to Freehand feel?

    SpiralHere’s the original photo. Since the image wasn’t taken “straight-on”, there’s some perspective to deal with. No matter, though…I just wanted to capture the “feel” of the shape.

    SpiralOne immediate feeling I noticed: it was much more relaxing to trace the shape in Freehand because there was no fear of screwing up. You can move points as you draw and the bezier curves are auto-drawn in preview without having to commit to placing a point. Because of this, I was able to trace the entire shape in one go. In Illustrator, the experience is more frustrating because points can be moved only after you’ve stopped adding points to a curve, so if you placed one badly, tough look…live with it for now. Nudging all those points to smooth them out is a royal pain in the ass, particularly because Illustrator doesn’t have the “auto handle” feature that adjusts the bezier handles as you move a point around. Anyway, after I got my basic shape down and smoothed it, I applied the simplify filter and got a very nice minimum-point shape that smoothed out all the curves nicely.

    SpiralDespite Freehand’s superior vector tools, compositing and setup is easier done in Illustrator now because I’m more used to it. I saved the Freehand document and loaded it directly into Illustrator. Since it’s just basic shapes, there wasn’t any import problems. I converted the document to CMYK and used some of the Freehand blend modes to create a simple effect. I need to make sure this actually prints correctly from PDF; the use of blending and transparency modes sometimes cause problems with commercial printing places.

    Total time from start to finish was about an hour of goofing around. I think I saved quite a bit of vector trace time by using Freehand instead of Illustrator to start; refining the same shape in Illustrator CS4 would have taken a lot of tedious nudging and adjustment. However, I should look into an alternative trace methodology that is just placing points and creating straight line segments, and then simplifying the shape with the Path->Simplify command. This results in a curved approximation of the segments, which would look pretty nice. I’ll try that on the next shape I need to make.

    Read more
    DSri Seah
  • Virtual Terrain Maps IV: Inspired Guessing

    January 14, 2010

    SUMMARY: I write about the experience of unintentional, high-quality collaboration leading to insights of how I know more than I knew, and that I should apply GUESSING more frequently because it actually works well as a starting point. (more…)

    Read more
    DSri Seah
  • Virtual Terrain Maps III: Reframing Tasks

    January 13, 2010

    SUMMARY: Exploring the difference between a “values-based” task list and a “goals-based” task list. (more…)

    Read more
    DSri Seah
  • Tuesday Staff Meeting

    January 12, 2010

    This week is largely a catch-up production week, so there hasn’t been much in advancing in terms of template building and documentation. The content and images are largely in from the first round of clients; now it’s a matter of making it as easy as possible to populate the existing templates and posting them somewhere. Ideally, my benchmark is to be able to do this in no more than an hour per template, but for right now I have to discover where the efficiencies are.

    I’ll be documenting each client as I begin the process.

    On a side note, I’m starting to handcode HTML/CSS documents on-the-fly, as a means of getting more familiar with what’s possible with the basic layouts. I think this is a necessary part of the engineering “discovery phase.”

    Read more
    DSri Seah