Author Archives: Lee Devlin

About Lee Devlin

I'm Lee Devlin from Greeley, Colorado.

How to make mailing labels with Excel and Word

Posted on by
Reply
Share

I’ve done mailing labels over the years when I was the local chapter EAA newsletter editor and then a few times for Christmas cards, but each time I do them now, it seems that I can’t remember the steps it takes to repeat the process and as a result, it feels like I have to learn it all over again. So today I carefully went through the procedure because I’m helping out with my high school reunion and we will need to print out mailing labels several times in the next few months. I figured other people might want to know how to do it, so I will give the step-by-step method here in the blog.

First of all, you will need to put your mailing database in an Excel spreadsheet. Even though you’ll use the MailMerge function of Word, a spreadsheet is much easier for manipulating lists of data compared with trying to work with tables in Word. You should title the columns with intuitive names such as, LastName, FirstName, Address1, City, State, Zip code because if you do, MailMerge will usually correctly guess the order to arrange the data when it comes time to put them into a mailing label format.

I like using type 5160 Avery adhesive labels which are arranged in 8.5″ x 11″ sheets with individual labels 1″ x 2.625″ spaced 3 across and 11 down for a total of 33 labels per page.

[Note: When I first wrote these instructions, I was using Office 2003. Now that I have Office 2007, I can see that some of the menus have been changed. I’ll add some extra instructions below for those with Office 2007.]

Here are the steps for producing labels using the Mail Merge program in Microsoft Word:

Launch Word and use File->New to create a Blank Document

Tools->Letters and Mailings->Mail Merge Wizard

[Office 2007: Mailings -> Start Mail Merge -> Step-by-step Mail Merge Wizard ]

You’ll see Step 1 of 6:

Choose the option ‘Labels’ then select ‘Next’ at the bottom of the menu.

Step 2: Make sure ‘Change document layout’ radio button is selected and then and select ‘Label options…’ below it.

This will take you to a Label Options menu that allows you to select a label type. I use ‘Avery Standard’ and type ‘5160 Address’. Then select OK. Office 2007 asks you if it’s OK to overwrite your document at this point. Select OK.

In Word 2003, a grid should appear in your document that shows labels borders spaced in 3 columns, 11 rows per sheet. This grid doesn’t appear in Word 2007.

Step 3: Now select ‘Next: Select recipients’

Make sure the option to ‘Select/Use an Existing list’ is selected and the select ‘Browse’ and find the .xls file on your computer with your database and then open it. Select the spreadsheet page you wish to use. If it has just one page, you will see $Sheet1 and you should select it. In Word 2003 you may select ‘entire spreadsheet’ if you have only one sheet. You will then see a list of names from the spreadsheet. Select OK. You may have to select OK again. A list of <> entries will appear in the document.

Step 4: Now select ‘Next: Arrange your labels’

Select ‘Address Block’. Look at the preview field to see if the example label has all the information you want. Because of the layout of the heading row spreadsheet, it should be correct. If it’s not, you can fix it by selecting the ‘Match fields’ option and editing them. Now select OK. You should see <> in the first label and <> in all the other labels. Select ‘Update all labels’. This will cause the text <> to be added to all the labels that previously had just <> in them. So the first field will have <> and all the others will have <><>.

Note: If you wish to have more control over your labels, instead of selecting ‘address block’, you can select ‘More options’ and this will allow you to apply the exact amount of spacing, carriage returns, etc., around each field. I’ve found this helpful if you have international addresses mixed in.

Step 5: Now select ‘Next: Preview your labels’

Now you will see a sample page of the labels.

At this point, you can select ‘Print…’ which will walk you through the steps of printing out the labels on a local printer, or you can select ‘Edit individual labels…’ If you select that, it will create a Word document file that you can edit or store away for future use or print from another computer. I usually use that option.

I should mention that there was an issue with the zip codes that started with ‘0’ (zero). You should format that field in the spreadsheet as a ‘special’ zip code field, which is an option in the format command of Excel. Then during the import to MailMerge, I had to use these steps.

Preparing DDE settings in Microsoft Word:
If you perform a mail merge in Office 2003 and use Excel as the data source, some of the numeric data may not retain its formatting when merged. To resolve this:
1. Open Word
2. On the Tools menu, click Options, and then click the General tab.
3. Click to select Confirm conversion at open check box, and click OK.
4. Continue creating the mail merge as explained above
5. Open Data Source.
6. In the Confirm Data Source dialog box, click MS Excel Worksheets via DDE (*.xls), then click OK.

You may have to answer a few questions when you import the .xls file but it will fix any issues with the zip code field, especially with those starting with ‘0’ (zero).

Another trick to making labels is printing a single sheet of labels out on plain paper first to make sure the alignment is OK. You can hold the sheet of labels up to the light with the printed paper labels behind it and insure that the text will all end up inside the sticky label borders. You don’t want to be making mistakes on the label stock because it’s much more expensive than plain paper.

Hybrids require more energy than Hummers?

Posted on by
Reply
Share

I’ve read several references to a report that alleges that the total energy costs per mile of a hybrid vehicle exceed that of an H3 Hummer, and by a significant margin too, more than 50%. I decided to look up the source of this information and found a 450+ page report filled with spreadsheets on various costs it takes to run a vehicle over its life expectancy and beyond. There was a lot of interesting information in the report, like how many miles a typical vehicle is driven before being recycled, how much money is spent on repair, how much it costs to recycle, as well as a lot of feedback and industry reports attached to th end of it.

Manufacturers estimate that the energy used to produce a vehicle is about 20% of the amount of energy it burns in fuel over its lifetime. The fuel cost over the life of a vehicle is easy to compute. For example, if a car gets 25 miles to the gallon, and is driven 180,000 miles before it’s recycled, it would use about 7200 gallons of gasoline, and at a cost of $3.00 per gallon, this would come out to $21,600 or $.12 per mile, which seems quite believable. Add to that another 20% for the energy required to produce the car ($4320) or $.02/mile and you have a total energy cost of roughly $.14 per mile. This value seems plausible, although it doesn’t include the recycling energy cost which one might assume is on the same order of magnitude as the energy cost to produce the vehicle.

However, the report, available for free from CNW Research, estimates that most of the energy used by a vehicle comes not from the energy to produce it and to power it over its lifetime, but rather from the recycling cost and that accounts for most of their $3.238 per mile estimate for a Honda Civic Hybrid and $1.949 per mile estimate for an H3. A Honda Civic Hybrid is one of the most fuel efficient vehicles on the road whereas an an H3 is a very large SUV and gets about a quarter of the fuel economy of the Hybrid. So it’s hard to imagine an inverse relationship in energy cost per mile, and why would the real energy costs exceed the ‘apparent’ energy costs by not just a factor of 2 or 3, but more than 20 times? The report suggests that the amount of energy used in recycling is related to the ‘complexity’ of the vehicle and that the complexity of hybrids makes them much more expensive to recycle than a simpler vehicle that has been in production for a longer period of time.

After combing through the entire report and seeing numbers calculated out to such a high degree of precision, yet showing no calculations for the actual recycle costs, I can only conclude that they must be a guess.

A manufacturer has to have a pretty good idea of how much energy goes into a vehicle’s manufacture. After all, they have to sell the car for well more than just the energy that goes into it or they’d go broke in a hurry. The same is true for their part suppliers. Similarly, a recycler wouldn’t take a car for recycling if the value of the material derived from it would be completely be overshadowed by the energy cost it would take to recycle it. Much of the material gets recycled from a vehicle simply *because* it’s cheaper to used recycled materials than it is to process the material from scratch. If this were not the case, these materials would end up buried in a landfill, end of story. So saying that the recycle cost exceeds the original vehicle’s cost and all of its apparent energy usage by an order of magnitude or more simply makes no sense.

The research seems to indicate that the recycle costs are somehow hidden in the operating costs and profits of other businesses but that similarly makes little sense. Surely the report wouldn’t intend to count the energy cost to produce a single car as somehow having to include the costs of other cars that may be produced by that same material after it’s recycled. That would would be not just double or triple counting energy, but counting the energy for each recycling operation against the original vehicle for all eternity. Again, that would make absolutely no sense.

Indeed, the intricacies of recycling costs and their impact on operating expenses can be quite perplexing. It’s important to distinguish between the energy and resources used in the initial production of a vehicle and those required for subsequent recycling processes. Double or even triple counting of energy costs, as you mentioned, would not accurately reflect the true environmental impact. A more transparent approach would be to account for the energy consumed during the lifecycle of each vehicle independently, without perpetuating costs across multiple cycles of recycling.

In the realm of car maintenance, understanding these nuances can be critical for both consumers and repair shops. At Blue Wrench Auto, we emphasize the importance of clear and accurate cost assessments, whether it’s for repairs or understanding the broader impact of vehicle maintenance and recycling. By focusing on each vehicle’s specific needs and history, we ensure that every repair is handled efficiently and with full transparency, avoiding any confusion over hidden costs or energy impacts.

So my conclusion is that the research is flawed and the only reason it gets any attention is because it alleges something that anti-environmentalists find so outrageously compelling, i.e., that H3’s are more environmentally friendly than hybrid vehicles. And I write this not as a hybrid car owner, but as an owner of a 15 mpg SUV. I just don’t like research that gets so many references without being critically examined.

Removing a hot tub from a deck

Posted on by
3
Share

Last weekend Terri asked me to work on finding a new home for our hot tub. The hot tub came with the house that we purchased in 1994. We enjoyed it for a while, but then got out of the habit and thought it would be best to sell it or give it away to someone who would use it. Paying to heat and maintain a hot tub can be expensive, particularly when it needs repairs. Our last repair bill was nearly $800 because it required replacing the heater box, recirculating pump, and some of the tubing. It was also leaking and that was repaired at the same time too.

I put an ad on Craigslist and attached the picture above letting anyone know that if they wanted the tub, they could have it for free if they moved it themselves. Prior to placing the ad, I had called the hot tub store and asked what it cost to have it professionally moved and they told me it would be around $300-$500 depending on the complexity and about $100/hour for every hour extra they need to spend. They also told me the model of hot tub I had weighed about 900 lbs. In about 4 hours after placing the ad for a free hot tub, I had 9 responses from interested parties. That evening a guy stopped by to look at it and while he was here another guy showed up also wanting to take the tub. I suggested a coin toss to which they both agreed and that resulted in a winner. The coin toss winner said he’d come back with some friends and equipment to retrieve the tub a few days later. I told him I’d work on removing some of the decking to make it accessible.

The main problem was that the hot tub was built into our redwood deck. Actually, the deck was built around it like a jig saw puzzle because the hot tub was installed on a concrete pad before the deck was built. The floor boards on the deck are attached with long wood screws, so I didn’t anticipate a problem removing them…. until I actually tried to do it. Most of the screws were screwed well below the wood surface, up to a half inch deep in some places, which caused the screw head to disappear below the surface of the deck. This also caused the holes to fill with dirt and wood, so before I could remove most of the screws, I had to first excavate them. I used a drill with a Forstner bit to remove the wood above them, then an exacto knife to clean out the dirt in the screw heads and then a right angle screw driver to provide enough leverage and get them started so that I didn’t strip out the heads. It took me a good 5 hours working in the heat to get enough boards out of the deck to find out that a much bigger challenge lay ahead. The hot tub had a massive frame built around it and I would have to remove that frame before the tub could be lifted because we couldn’t get anything under the tub to lift it out with the frame in place. I removed a few more floor boards and then used a Sawzall to cut the joists, which worked for the stringers, but there were a few parts of the frame that required cutting through stringers that had been doubled or tripled, so I pulled out my chainsaw. A chainsaw is an interesting tool to use for working on a beautiful redwood deck. But in a surprisingly short time, I had severed enough joists and members in the frame so that Terri and I could lift the frame away from the hot tub.

After we got this taken care of, our buyer showed up with 3 friends along with a flat bed trailer and a pair of flat dollies. He was well prepared with various tools, and yet we were still unsure of how we would lift the 900 lb tub up out of the hole it was set down in. One guy suggested we just try to lift it as he had done with his hot tub. I thought that couldn’t hurt as long as we took it easy so between the 5 of us we found that it was in fact possible to lift the tub. We got one end of it up on the deck only to find we forgot to remove the wiring. Oops. We put some wood under the dangling end of the tub while one guy took care of unwiring it. Then we tilted it up on end, on to the dolly, so it would fit out through the gate which was about 4 feet wide. One guy had built a small ramp with bricks and plywood to roll it safely down the one step between the patio and the sidewalk and then we wheeled it out to the flat bed trailer. The whole ordeal took less than 20 minutes and would have take half that had we remembered to unwire it first. It was quite a relief.

Now the tub is on its way to a new home where it will no doubt see much more use that it had here. And I have a large hole in my deck that I had to fill in and you can read about it here.

Canceling an XBOX Live Gold membership

Posted on by
60
Share

I got an Xbox 360 about a year ago with the hope of using it as a media player for my HP Media Vault because it is supposed to be a DLNA-compliant media server. It’s not. You can get it to work by installing Twonkyvision’s server on the Media Vault (which costs another $40), but it won’t stream Divx/xvid-encoded videos, which pretty much renders it useless as a media player in my opinion.

I’m not much of a gamer myself, and so the Xbox 360 hasn’t gotten much use. For some reason that I cannot recall, I decided to upgrade my Xbox 360 silver membership (which is free) to an Xbox Live Gold membership which costs about $7.99/month. I figured I could always just switch back to the free membership if I didn’t use the Gold membership features. After a while of seeing that monthly charge appear on the credit card, I decided to cancel it. I first tried canceling it on-line via the webpage for Live, then through the Xbox console, and wasted at least a half hour before searching on the Internet only to find out that that only way to cancel it is to call up 1-800-4MY-XBOX (1-800-469-9269) to wait to talk to an operator. And that took an additional 18 minutes, most of which time I was on hold.

I really hate it when a company makes such an obvious attempt to hang on to subscription fees that it causes that level of inconvenience when attempting to cancel a service. Signing up took a few minutes and I didn’t need to call anyone, but canceling took 48 minutes from my life. So I’ll post this here for three reasons:

  • To help someone in the future to not waste time looking for an on-line solution to canceling their xbox live membership.

  • To let Microsoft know that this is a really stupid policy.

  • To let any other company that is contemplating a similar strategy not to do it because customers don’t like it.

    • I hope someone Diggs this and maybe it will get the attention of the person Microsoft who can correct the situation. If they do, I’ll gladly remove this from my blog.