Me too!
I inflated the tires on my wife's bike, so she's happy for now

.
On my bike, here's an update:
I removed the rack and kickstand, removed all of the reflectors, and added the reflective tape. Also, I got a Mity 8 computer and picked up a pair of puncture resistant Specialized 1.5" tires and installed all of that.
When I was at the LBS I asked if they had on old set of Alivio 7 speed shifters lying around. They said no, but suggested prior to replacing them that I disconnect the cables, disassemble the exterior case, zap the guts with WD40, clean out all the crud (it looks like there were caterpillars living in there at one point), lube and reassemble. Voila - my front derailleur works!
Now all I have to do is ride!!!