- Most Recent | Since 2004
- List View
- Archive
- January 17, 2010
Compact Calendar Change for Reported Easter Calculation Bugs
January 17, 2010Read moreThis 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 theEASTERSUNDAY()
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.
- January 14, 2010
Quickie Logo Conversion
January 14, 2010Read moreOne 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?
Here’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.
One 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.
Despite 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.
- January 14, 2010
Virtual Terrain Maps IV: Inspired Guessing
January 14, 2010Read moreSUMMARY: 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…)
- January 13, 2010
Virtual Terrain Maps III: Reframing Tasks
January 13, 2010Read moreSUMMARY: Exploring the difference between a “values-based” task list and a “goals-based” task list. (more…)
- January 12, 2010
Tuesday Staff Meeting
January 12, 2010Read moreThis 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.”