My Musings

  • |

    Pivot to the Rescue

    Sometimes simple is all you need. Last month I was asked to help out in automating an activity that was needlessly taking up time. Usually when people come to me, they think “program” but sometimes formulas or pivot tables will do the job just as well. In this instance, they needed to restructure some reporting…

  • Third Time’s a Charm

    Or so the saying goes. For a couple of years, I’ve been asked to help create a program to automate the gathering of data from a different system and roll it into our current system and each time the effort got bogged down in the corporate blackhole. I always got stuck at the point where…

  • |

    Playing with Data Query

    I thought since I’m on Thanksgiving holiday that I would go back to my climate files where I had gathered data from the web and see if I can update the data using the embedded data query. The one I was really interested in was the file pulling in temperature data history for each state…

  • What Robots Can Do

    Well, it looks like while we were sleeping, the robot revolution progressed on. Now, robots can: read, write, see, hear and understand, speak, smell, touch, move understand emotions, play games, debate, create, and read your mind. With the exception of the last item which is beyond humans’ ken, they cover pretty much most of the…