Monthly Archives: April 2009

Tiling the Laundry

Over the past few weeks, Tara and I (mostly Tara) have been working on tiling the laundry room. It started months ago when we installed the hardwood, and pulled up the ugly linoleum on the downstairs landing. It remained that way for months, and just recently we started the laundry room.

We went with a porcelain, cream/tan colored tile. 13″x13″. About $1.19/sq ft at the local hardware store.

After pulling out the washer and dryer, and pulling the base boards, we pulled up the linoleum. Tara scraped off most of the old glue, and we started working on caulking under the drywall to prevent the self leveler from oozing out under it. During that, we discovered that the drywall right under the washer drain spout was rotted out (well, dissolved out), probably due to the drain backing up and water pouring out and getting under the drywall. So, we cut out that bad drywall and found mold (big surprise). We cut out probably a 3′x4′ chunk, and replaced it, taped, mudded, textured. Painted (later). Looks good.

So, after that, we poured self leveler since the room wasn’t very flat. There’s kind of a “hump” in the middle of the room. After one bag worth, we saw the hump was still there, so we mixed and poured another bag worth. The hump was still there, but much better. And we didn’t want to spend another $30 on a bag that will just raise the floor even more. So, we called it good.
Tara basically did all the tiling herself. She mixed the thinset, cut the tile (with a wonderfully handy tile saw we borrowed from her uncle). She basically did it all while I was at work. Tilesaw works great… except when you don’t have the blade shield all the way down and water sprays all over the front of your pants… but I digress.

Next came grouting, which is a tedious process, but might be easier if the grout was a bit thinner. I mixed it a bit thick, so it really took some elbow grease to work in. Then you wipe it down, and seal it a few days later. All of this went pretty well. The only thing I didn’t look forward to was trimming the doors to make room for the extra 1/2 of tile, thinset, and self leveler. But, all and all, that went quite well as well.

And we’re done! we put the washer and dryer back, all the various holes in the walls have been sealed (you know, where the valves for the washer water come through, or the dryer exhaust, etc. Hopefully the laundry room will stay a bit warmer now. Heck, we even bought nice new hoses for the washer (did you know you’re supposed to replace the hoses every 5 years???). Really, the only thing left is to finish the new baseboard, and sometime down the road, get a laundry sink/basin installed (which we’ll have a plumber do, and probably run us a few hundred).

With Tara’s family coming down this weekend, we’re now in rapid cleaning mode. I also need to install a new lav faucet in the guest bathroom, which I’ll probably do tonight. That’s easy plumbing…

Tweet this
Posted in Home Ownership | Comments closed

Bringing it all together…

So, I’ve been asked by a friend on facebook about jpgraph and my home energy use. Here’s kind of a “here’s how I did it” and an example.

Back a few weeks ago, I purchased a TED for my home. The Energy Detective has a piece that installs in my electrical panel around my main power feed (both phases), and then reads total load on my panel. It then sends that information over household wiring to the receiver in my office. It gets new info every second. It’s accurate to about 10W.

Okay, so every minute, my home server polls the TED, gets current KW use, and total KHW for the day, and writes that to a file along with date and time. Also, it grabs the current outdoor temp from my weather station and writes that to the same file. I don’t grab indoor temp because the weather station console is mounted somewhat close to the output of my server rack, so it pretty much constantly reads 68F (though, that is what I keep my house at).

Then the question is, what to do with this data? I have been messing with it in Numbers.app, but it’s slow dealing with 1400 rows of data (60 * 24 data points). And I hate excel. Plus, I’d like to make it automated. So looking around online, I found a few php suites that’ll do graphing. One uses google’s graphing API, but it’s kinda broken in that if you try to pass it 1400 data points, it breaks. =P This seems to be a problem with the google API because they’re all pushed as a HTTP GET. =/ Out of all of them, the best seemed to be jpgraph. It uses GD (which meant I had to install a copy of PHP on my server that was actually complied with GD support (thanks Apple for giving us semi-crippled software, again) (see my links for a link to the PHP install). Once that was going, I read up on jpgraph, and looked at the examples. They seem pretty cut and dry, so I pasted in a bunch of data, and lo-and-behold, it works! So, now I need to make it dynamic (you pass it a date, and it parses the energy use for that date). I got that done yesterday.

So now, you can go: http://www.staze.org/powergraph.php?date=20090407, and see a nifty graph of my power usage on the 7th of April, 2009, as well as the temperature for that time. I still need to make a page that acts as a kind of interface for this. Something that lists available dates, links to the graph, etc. I also hope to allow easy graphing of whole months, years, etc. But, that’ll take some time.

All this really came about because I’ve been graphing and tracking my energy use on a monthly basis by inputting the data off my Utility bills. Now I just have more granularity!

So, things left to do with this project are: Make an interface, get monthly graphing working (it would be a daily granularity) with average temp for that day graphed, and work out a long term file structure for the data. Right now it’s all just sitting in a directory that every night, a cronjob takes the previous day, grabs the total KWH use, and logs that and the date to a monthly file, then compresses the daily log (speaking of which, who knew there was a gzfile operator in PHP!?!)). Um, maybe change the image format from PNG to jpg, and probably make it so the image wasn’t necessarily recreated every time (check to see if it exists, and if it does, serve that up, if not, create it, and save it for next time). While I don’t see my energy logs getting a lot of traffic, it’s just good coding.

All of this REALLY makes me want to get a 3PH equivalent for work, so we can watch energy usage in the building. But, that’ll have to wait. =P

Oh, and let me know if you want raw data… I can post some. I’m also more than happy to post my PHP that’s parsing and graphing, as well as post my scripts that log the data, or the ajax I use to update the sidebar (though, those last ones you can get by viewing my page source).

Links:
jpgraph: http://www.aditus.nu/jpgraph/
Real PHP install file: http://www.entropy.ch/software/macosx/php/
TED: http://www.theenergydetective.com/index.html
Python script that I based by query off of: http://www.bananabend.net/energy_detective/ted5.py

Tweet this
Posted in Energy, Sys Admin | Comments closed
  • Weather

  • Current Power Usage

  • Prius Mileage

    Lifetime Average (Calc) : 44.6MPG
    Lifetime Average (MFD) : 45.43MPG
    Total Miles Driven : 70691.9
    Graphs: Price/Gal. || Mileage || Summary
  • Distance Walked

    Distance walked in last 7 days
    9.4 miles (20395 steps)
    Graphs: History || Summary