Category: Uncategorized

  • Tracking the Position of a live Mouse

    Placecell research. That’s what it is called.   In our brains, there are cells that become active when you are somewhere familiar. This is how we can drive home and not even remember taking the exit ramp off the highway.   Anyway, I was recruited to help a memory and learning researcher correlate the physical…

  • Using Cognos Report Studio as a bulk email tool

    I’m not referring to spam here. My customer needed a way to communicate with subsets of their customers. All of the (internal) customers were in a database and they were classified by which type of customer they were. Luckily the email addresses were also available. There was no budget to build a custom piece of software…

  • Least Squares Linear Predictive Report with Cognos Report Studio

    In a large corporation, things move extremely slowly. At my most recent job, if we wanted more disk space, it would take about 2 months to actually see the space. First there were the requests and signoffs, then the provisioning and people who ask you to justify the need, then the ordering and finally the…

  • Term Life Insurance Billing Rewrite

    This project was for a life insurance company that had a legacy Life Insurance and Billing system built in dBase. The system allowed the entry of customers, calculated the rates based on their age and a few other statistics, then produced a bill for mailing to the customers and tracked the payment status of the…

  • Pepsi Challenge Running Race customer aquisition Software system vintage 1982

    “The Pepsi Challenge” The Pepsi Challenge was a running race series sponsired by Pepsico where participants times were tracked and tabulated and Pepsi sent everyone a coupon for a 2-Liter bottle after their race. Our role was to create a database system that enabled the entry of the race results by staff, generated the age/sex series…

  • The Energy Saving Economics of DIY vs. Contractors

    If you have even decent skills, there is no comparison of the economics. Energy Saving projects are generally a marginal effort and the returns are over long periods of time. For example, I estimate that sealing, improving soffit ventilation, sealing my Air Handler in the attic, and the basement sill plates will, at most, save $75-$100 per…