Eye Glazer

Seriously, when is Microsoft going to make a setting that says, "Do NOT auto-detect data types!" so I can check that box? I deal with raw data a lot, and we end up using CSV simply because most everyone has a program that allows for easy viewing of the data inside (I still wish people had settled on a simple delimited format, but that's another rant). Excel (2007/2010) ends up being the most common data-viewing-tool that people use.  It's unfortunate. Most people have no idea that Excel attempts to auto-detect the type of data in a field, and even less know that some of it's guesses are irreversible. So if you send them a csv and they wish to change one little thing before sending it along, they have no idea that they just screwed up the file! Date information is the most annoying. If you send "yyyy-MM-dd HH:mm:ss", it gets transformed into "M/d/yyyy HH:mm"---not only for viewing, but it gets saved back into the CSV in that format! So st

About a year ago, I made my first application for Android (1.6; Donut). This post is mainly to give me an easy way to install it again now that I've upgraded my G1 to CyanogenMod 6.1.0 (Android 2.2; Froyo). The purpose of the app is to restore the volume/ringer after turning it on Vibrate/Silent. Whenever you turn the volume down to Vibrate/Silent, the app pops up a menu that has 4 configurable options plus a "restore to this volume" slider. If you long-press an option, you can change it to be something else. You can either make the volume restore after a set amount of time (e.g 4 hours), or at a particular time (e.g. 8:00 AM). I use it each night before going to bed, or when I'm going to a meeting.