2006 Pool Season: Short but Sweet

That about sums it up. Tomorrow we’re putting the winter cover on the pool and officially sticking a fork in the 2006 swimming season. For all intents and purposes, it was really over before the Labor Day holiday, although we did sneak one post-Labor Day swim in, during a warm spell where I was able to briefly nurse the water temperature back up to 80. But it was all downhill from there. Although 2006 certainly ranks as our shortest swim season to date, it was also one of the best. In the peak months of July and August, the pool saw almost daily use, and there were no serious maintenance hassles — in particular, no yellow algae this year. I did have my annual 6-week cloud-up (where the water starts clouding up approximately 6 weeks into swim season), but I believe I narrowed that problem down to inadequate filtration. Increasing the pump run time seemed to clear the water up. Next year will be the real test.

Regarding the yellow algae, or lack thereof, I credit that to more frequent superchlorination combined with additional pump run time (probably more the former than the latter). The past couple seasons, I just don’t think I was superchlorinating enough. Once a week during really hot periods (water pushing 90), and once every 2-3 weeks otherwise, seemed to do the trick this year. Since everyone seems to have a different definition of what constitutes “superchlorination”, here’s mine: start with a residual of 2-3ppm free chlorine. If the pH is 7.6 or above, first throw in a couple pounds of bisulfate. Then add 2-1/2 gallons of 12.5% sodium hypochlorite.

Next spring, I get the joy of draining the pool for repairs. Really, I can’t wait.

Sump Pump fun

So, the float switch on the old FloTec sump pump in our basement office died a while back, and I’m just getting around to doing something about it. This particular sump gets very little water in it, even with a dehumidifier draining into it, so my solution for the summer was to just manually pump it out every couple weeks or so. But now, with vacation looming, I want to get an automatic pump back in there. Rather than getting a new float switch for the old pump (that would cost money, you see), I’m just going to replace the pump with a Zoeller that I’d been keeping around as a hot spare for our other sump pump (the one that sees tons of action from driveway runoff). I figure I can still use it as a hot spare, and as an added bonus it’ll see some occasional action in the office sump, so I’ll know it’s working.

I went to do the work today, and true to form, it’s proving to be a bit more difficult than expected (nothing in this house is ever easy or straightforward, you see). First, the bottom of the sump is so impossibly uneven that I couldn’t find a level spot for the new pump. And, the original pump’s plumbing is some sort of half-assed Rube Goldberg conglomeration of flex ABS, threaded couplings, band clamps, and what appears to be automobile radiator hose (rule two of this house: all previous-owner retrofit work must be done half-assed). So, I have the fun of sorting all this out. I started by dumping some gravel in the bottom of the pit to level it out. Next I have to pick up some PVC and a Fernco coupling or two (to replace the radiator hose) and redo the plumbing. I’ll start by just doing the piping near the pump, and tying it into the existing stuff where it exits the foundation. But long term, I might reroute the run out the foundation.. we’ll see.

Retro coding

’tis been a while.. but I’m currently writing some code (the Student Parking Registration rewrite) that communicates directly with our system of record for SIS, the HP3000 mainframe. I haven’t done this for 6 or 7 years (although I’ve made tweaks here and there, this is the most I’ve done with it since 2000 or so). And I had forgotten how comically antiquated the whole process is. Now, I don’t write code on the HP (God forbid.. it’s all Cobol), but I do interact with a TCP/IP socket-based server that runs on the HP. And, I have to send data buffers over the socket in a format that the HP will understand. It’s reminiscent of FORTRAN, or Assembly Language, or something like it. The HP is very fussy about field width, positions of parameters within buffers, etc. If I’m off by a character, for example, subsequent fields all end up shifted over too far. Suffice it to say, it’s not much like the stuff I’m doing nowadays – Java, PHP, XML, etc. It’s quite nostalgic. It makes me want to go log into the VAX 4000 and run my old 4-bit assembly simulator.

Oh well.. back to work. I’d hate not to finish this, and have 13,000 students unable to be billed by Parking Services next fall. That might affect my next raise…

FPE panel replacement project underway

Today I officially began my project to replace two Federal Pacific circuit breaker panels in my house. I’m starting with a subpanel in the boiler room, and after that’s done I’ll move on to the house’s main panel.

Ironically, the first step to doing this was to replace a perfectly good Square-D QO subpanel in the boiler room. This panel was upstream of the FPE panel (which is totally full — a previous owner added the QO panel to add capacity). The plan is to consolidate both panels into a single QO panel, but the existing one was too small. So step one was to replace it with a 24-slot QO. Next, I’ll move all the circuits over from the FPE panel.

Wiring the new panel was pretty easy as far as these things go — no big surprises. The QO panels are very nicely laid out, with neutral busses on either side, for example, so there’s no need to cut conductors to different lengths. The only thing I didn’t care for was the placement of the separate ground bus (required by code for subpanels) which was at the very bottom of the panel. A couple of my existing ground wires were not long enough to reach the bus (keep in mind the new panel is several inches taller than the old one). But this wasn’t too hard to work around.

Phase two, as mentioned, will be to move the circuits off the FPE panel. I’ll need to set aside a day for this, as there’s some conduit that’ll need to be rerouted, plus some wires that will need to be spliced to reach over to the new panel. I’ll probably try to do this the week after we get back from the beach — no sense rushing it with the beach trip looming and lots of other stuff to take care of.

Browse NFPA codes online

I just found out that The National Fire Protection Association has a method you can use to browse all of its publications online. This includes the National Electrical Code and its associated offshoots. This is really nice, because printed versions of the NEC (NFPA 70) sell for upwards of $60, and then you still need to get NFPA 7A, which specifically covers single- and double-family dwellings. And on top of that, the codes are updated every three years, at which point you need to buy all-new copies if you want to stay up-to-date. This is a little pricey for a weekend shade-tree electrician like me. However, a copy of the NEC is essential if you want to do safe, code-compliant work that will be approved by an inspector. It’s always been frustrating to me that these documents cost so much — no one, be it contractor or homeowner, professional or amateur, should be required to pay for what is ostensibly a book of requirements. IMO, the high price point of the printed NEC promotes shoddy, non-permitted, non-compliant work, which is not good for anyone.

Now, all is not perfect. NFPA still wants to make money selling hardcopy and PDF versions of the code, so the free access you get is a bit crippled. It works via a Java applet that doesn’t allow printing, cut-and-paste, or search. However, it’s better than nothing, and I have to give props to NFPA for recognizing the importance of providing easy access to these codes. There are certain things that are more important than making money..

Oh yeah.. here’s the link.

Early end to swim season?

Several days of persistent cloudy, cool and rainy weather have conspired to drop the pool temperature to a nice, chilly 76 degrees. And, the forecast for the next week or so doesn’t look too promising. So it looks like we may be in for our earliest end to the swim season since we moved into the house. Combined with the late start, it was a pretty short season. However, in terms of usage, I think it was our best year since 2002. It seemed like someone (usually Michael) was in the pool more days than not. So I’m satisfied that we’re getting something out of the pool, though it’s still not quite worth all the work and expense.

Anyhow, if the weather doesn’t turn around soon and extend the swim season, I’ll probably look at covering the pool just before we leave on our beach trip.

9/10 – Well, we got a couple days of warm, sunny weather and I was able to nurse the pool back to 80 degrees.. So Michael and I spend a token 45 minutes or so swimming around this evening. The 5-day forecast doesn’t bode well for keeping it up, though.

I definitely have mixed feelings about swimming in September. It’s a lot of work for diminishing returns (not as much swimming). I have to use the solar cover if I want to keep the water from getting too cold. I’m constantly having to scoop falling leaves out. And in the 5 years we’ve had the pool, Michael and I are the only ones who have ever been in the pool after Labor Day. But truth be told, I don’t really mind the work — it’s kind of like I’m prolonging the summer just a little bit more. Strange as it may seem, there’s still a tiny part of me that misses summer when it’s gone.

Tweaked cash-flow spreadsheet format

For over 2 years now, I’ve been using spreadsheets to track our month-to-month household cash flow. In general, it’s been a huge success. It helps immensely with short- and intermediate-term financial planning. It lets us know when we’re running short on cash and need to be budget-conscious, and it allows us to earmark money ahead of time for future expenses. Through a combination of living beneath our means and planning expenses with these spreadsheets, we’ve managed to come out ahead every single month since I began doing this.

Tracking expenses like this does involve some extra accounting overhead. I have to spend a couple hours each month maintaining the spreadsheets, and there’s a fair bit of double-entry between the spreadsheets and our financial software. It’s well worth the effort, but I still like to refine the spreadsheets periodically to try to make the process easier.

Each spreadsheet tracks the cash flow in our “main” checking account over the course of a month. There’s a column for income and expenses, and a separate section to track money that is “reserved” for future expenses. I project expenses for the current month and a couple months in the future, so in June, for example, I might have active spreadsheets for June, July, and August. At the end of each month, the balance is carried forward to the following month’s spreadsheet as either income or an expense. I also use a separate sheet to track a second (money market) account, which is used for longer-term expense planning as it earns a higher interest rate. Rounding the whole thing out are sheets to track our two active credit cards. To keep things simple, most credit card expenses are glopped into a single “household expense” budget. I don’t account for individual charges against this budget, just the grand total. However, I do account for individual charges that are outside the household budget.


Up till now, I also tracked an account we hold with the local credit union. The credit union pays really crappy interest, so I don’t keep much money there. However, they have an ATM that’s convenient to me, so I use the account for cash withdrawals and check deposits. I transfer any balance over a certain amount into our “main” checking account, where it earns much better interest. This month, I decided that it wasn’t really worth the effort to track the credit union account, so I took it out of my spreadsheets. If I really miss it, I’ll put it back… but I don’t think I will.

I follow a similar strategy with the money market and the “main” checking account. Between the two, I like to keep as much money as possible in the money market. However, the money market doesn’t have the convenience of checkwriting or immediate liquidity of funds. If I need funds from it, I need to sell shares, which has a 1-business-day turnaround. So, I use the spreadsheet to plan when I’ll need to sell money market shares, and how much I’ll need to sell. Today, I hacked the spreadsheet template to “recommend” an appropriate amount of money market shares to sell, based on this strategy.

I’m hoping that these two tweaks will simplify the spreadsheets a bit, as they had been getting a little unwieldy. That aside, I highly recommend this method of cash flow management, as it’s worked really well for our family.