Wednesday, September 13, 2017

Chevrolet Tahoe Suburban 3rd/Third-Row Seat Stuck Open, Won't Fold 2007-2014

Background: While trying to close/stow the 3rd row seats in my Chevrolet Tahoe recently, the 1st release lever, that folds the upper half of the seat down on itself, was stuck. I tried both pushing and pulling the upper half of the seat at the same time while trying to lift the lever (which normally works). It wouldn't budge, so I became frustrated and forced the lever. I heard and felt a pop and the lever moved and went through its complete travel, but the seat didn't fold. After close inspection, I realized that the part of the seat near the lever would move very slightly forward when I lifted up the lever but the other side of the seat didn't move at all. I figured, correctly as it turns out, that the hinge directly connected to the lever was releasing but the other one connected by a cable was not. I assumed the cable had slipped or broken in some way.

Problem: The main issue was that the seat was stuck open, basically eliminating 50% my cargo space. Without being able to close the seat, both the seat lift and release levers didn't work at all, which meant the seat couldn't even be removed in its current condition to troubleshoot/repair.

Solution:
Phase 1: Removing the 3rd row seat
Thankfully, I found the exact video I needed on YouTube for how to remove the 3rd row seat when it wasn't releasing. It involves opening up the leather/cloth seat cover, the plastic cover and exposing the hinge mechanism and manually releasing it.

Phase 2: Fixing the seat
Now that the seat is out of the vehicle, you can troubleshoot what's wrong with the release. In my case (yours may be different) the problem and fix were surprisingly simple. Unfortunately, getting to the point where the cables are exposed is difficult because of how the plastic pieces on the base of the seat are joined together. I found putting pressure on the joint while pulling the pieces apart was the most effective method, and resulted in only one set of plastic clips breaking. Once the plastic is off the cables are exposed.


Along the cable that connects the lever to the hinge release pin, there is a plastic cylinder. From what I can tell, this plastic cylinder acts as an expansion joint to allow the cable jacket to be shortened for installation/removal of the cable. The clip in the middle of the cylinder acts as a lock to keep the cable in the long condition. In my case, the clip had released and the cable jacket was in the short condition, which meant it wasn't taught enough to release the hinge when I pulled on the lever.


I simply pulled outward on the free floating end cable jacket next to the plastic cylinder (lengthening the jacket) and inserted the plastic clip to lock it and voila a working seat folding lever! The video below shows a before and after of this step and how it affects the function of the seat lever.


Seems like a silly fix for how much time I spent removing/troubleshooting/installing the seat, but it works again at no cost so I can't complain too much. I'm guessing that the expansion joint also doubles as a weak point in the system to prevent the cable from being broken in the event too much force is put on the lever.

I couldn't find any forum/blog posts with my exact problem/solution, so hopefully this helps someone with this issue in the future!

Friday, August 18, 2017

Nesting Cornhole 3D Model and Drawing with Dimensions

A friend asked me to help him build a nesting cornhole set. Being the engineer that he is, he wanted to make the boards the exact same angle (fair play and all), and because one board has the sides inset in order to nest, the legs for the two boards need to be different lengths. He asked me to help calculate the lengths/angles and I got a bit carried away and modeled the entire set in SolidWorks and created a drawing. In looking around online, there are similar nesting sets, but there doesn't seem to be all of the dimensions I show. So I figured I would publish this in case anyone else finds it useful... and so my time spent was a little more productive. In reality, the ground will probably vary more than the difference in leg height... but oh well.

Here is a link to the 3D model and below are images and PDFs of the drawings. Disclaimer: I know there are tons of overlapping dimensions and the views are poorly laid out. I wanted to get everything on one sheet with as few views as possible. Enjoy!



Inner Board (PDF)
Outer Board (PDF)

Friday, August 26, 2016

How to Smoke Brisket in a Hasty-Bake

This isn't a food blog in any sense, but when smoking a brisket recently on our Hasty-Bake there didn't seem to be a good set detailed instructions online on the operation of the Hasty-Bake itself. Hopefully someone will find this useful. Most of the instruction is based on Hasty-Bakes official channel YouTube video on the subject (Part 1 and Part 2). This brisket was cooked on a Legacy Hasty-Bake:


0. Start charcoal in Hasty-Bake using a tower or starter match (no lighter fluid!)

1. Trim the hard and excess (very thick) fat from the brisket (soft fat is good for flavor and moisture)

2. Rub 1-2 tbsp of Italian dressing on each side

3. Coat with seasoning/rub generously

4. About 20 minutes after starting the charcoal, pour out tower onto right half of tray and cover with smoking shield. Make sure charcoal tray is at the "Smoke" level and leave it.

5. Close lid, open all vents, and wait 5-10 minutes for temperature to stabilize and verify that the lid thermometer is ~225-250F. If it's below 200, add small amounts of charcoal and if it's above 250F close vents some (not completely).6. Place seasoned brisket on grate in the center over the shield

7. Starting every 30 minutes check the temperature of the lid thermometer and try and maintain 225-250F (hard to reach higher than 225F in the Hasty-Bake due to air leaks). Again, open vents to increase temperature (add oxygen) or if necessary (or all vents are open) add charcoal. Incrementally close vents to decrease temperature.

8. After a couple hours begin to check the internal temperature of the meat. (153-158F @ 2hrs for a 4lb brisket)

9. At 160F meat internal temperature remove from grill, wrap in foil, place back on grill flipped from how it was previously on.

10. Check meat internal temperature every hour until 190F (for slicing) or 205-210F (for pulling) is reached, and pull off. (186-195F @ 4hrs for a 4lb brisket)

11. Slice or pull and serve!

Thursday, August 25, 2016

DIY Boat Canopy Bird Wire - Effective and Elegant Seagull Deterrent

This post details the entire process: research, design and construction of our DIY boat lift canopy seagull or bird deterrent system. Feel free to skip to the end for pictures! Please leave comments with any questions you have and I'll try to answer them. More importantly please let me know if you used this design or found the post helpful and definitely link to pictures if you made one!!!

BACKGROUND

Let me paint a picture for you. It's a regular day at the lake and our Gullsweep which was installed at the lake-end of the boat lift canopy was spinning and flapping quite nicely in the morning breeze. Blanketing the remainder of the canopy, just inches beyond the reach of the Gullsweep, were tens of seagulls squaking and defecating all over the place. That was the exact moment that I realized there had to be a better canopy bird deterrent system, and if not, we needed to create one!

The problem with the Gullsweep is simple geometry. The Gullsweep covers a circular area (6' diameter for the GS-1), but relatively small compared to the overall rectangular canopy which is 12'x27'. Originally, the Gullsweep was very effective, keeping the seagulls off of the entire canopy with the movement and noise of the plastic owl silhouetted vanes flapping over each arm rotation. It appears  that the seagulls have become accustomed to the Gullsweep over time and now it's only effective over an area slightly larger than the swept area. Even if we we used the 8' versions AND had three of them equally spaced over the length of the canopy, there's still plenty of area for the birds to sit on the sides.



So, we started looking for other commercially available products that we could purchase to solve this problem. Surely there were other people with the same problem and an adequate product to solve it!

  • We came across the Bird Spider, which is also circular and ultimately would have the same problem as the Gullsweep. 
  • We also found a few different variations using electrified strips of metal, but they were a) expensive and b) were intended more for edges or rails or peaks, all of which have a small area and are more linear compared to a large rectangular canopy c) would have required power out at the dock and d) would have affected the canopy and it's installation and removal.
  • The Seagull Stopper was the first that we found of the "wire" concept and I really liked it for a number of reasons a) it was rectangular and could be modified to fit any canopy size b) doesn't rely on wind power (works without wind) and therefore doesn't have any moving parts c) not obnoxious looking d) effective based on two principles 1) that the wire acts as physical barrier or inhibitor to landing or taking off over a large area and 2) that if the bird chooses to land on the wire itself it unstable and therefore unsuitable. The latter is accomplished by various means  but is primarily due to the flexible supports and line itself (and the addition of a spring in other products). Apart from the cost (which isn't that bad), the only downside for this product for us is the fact that the installation is not permanent and needs to be done every time the canopy is removed. We are on a northern lake so the canopy needs to be removed for winter. Installing the Seagull Stopper, which needs ladders, every season just isn't practical. If your canopy stays on year round, this may be the best solution for you. Most importantly for us, we had found a concept we liked, we just need to find a better support system.
  • As soon as we knew what we were looking for we were able to find a bunch of variations on the "wire" or "line" concepts. Gulls Away, FLOE Bird Deterrent, The Dock Doctors and Seagull Eliminator are all very similar in function with minor differences in the mounting methods and the number of rows of wire/line. It's also possible that some of the canopy/lift companies use or rebrand one of the other OEM bird deterrent systems.
Gulls Away:




FLOE Bird Deterrent:


Seagull Eliminator:

The Dock Doctors:

We also found plenty of  DIY examples including ribbons, streamers and CD's which seem to have a larger area of effect other than their footprint due to the obnoxious glinting and gleaming in the light and wind. Ultimately, we felt that these are equally obnoxious to humans.


One DIY solution that was up our alley was sent in by a reader and published on a Boat U.S. page soliciting mariner ideas and methods for dealing with birds for their boats. This DIY bird wire system was used for a boat bimini and not a boat lift canopy, which in our case, is much more complicated.


DESIGN

The Seagull Eliminator people were kind enough to put an installation manual online which includes a nice exploded view:




Additionally, Gulls Away put a nice snapshot of their mounting method on the purchase page. Depending on how your canopy attaches to the frame, and if the cost isn't an issue, either of these two products may be right for you.



Our main problem with both of these two designs was that our canopy wraps up on the inside of the rectangular tube that both of these designs connect with (see below). You can also see the shadow of the Gullsweep post, and all of the seagull stains.



The other issue was that we didn't feel like paying HUNDREDS of dollars for a set of four or six bent poles welded to a pieces of angle and mounting hardware. At this point we had decided to design and fabricate our own bird wire posts and so started off with a list of design criteria.

  1. Should not significantly impact, in time or method, the canopy installation or removal.
  2. Should not contact the canopy in a way to increase stress or wear and degrade the life
  3. Installation or modifications to canopy frame should be simple and not compromise structural strength
  4. Should not be an eyesore (as much as possible)
  5. Minimize cost
With those criteria we started brainstorming. At first the simplest to fabricate seemed plate and tube welded or bolted together. Here are some of our back of the envelope sketches



We decided to go with the bent round tube designs after seeing so many variations thereof and with understanding round tube would have a very high strength to weight ratio. The problem now was seeing if we could bend the tube without kinking it. We bought a couple test sample pieces of varying diameter tube and solid rod. We found that we could bend the aluminum tube/rod around the horizontal cylinder of our vice and end up with a fairly neat, uniform 5 1/2" diameter bend. I was concerned about repeatability so we looked into tube benders but that was cost prohibitive (~$100) for the 1/2" OD tube.

My grandfather often used u-bolts in his contraptions so naturally it was agreed that u-bolts would be the best method to connect the tube to the frame, even though it involved drilling holes into the non-structural part of the frame. We decided to use flat spacers to suspend the tube off of the lift frame and allow the canopy securing flap to wrap under it. In retrospect, it probably would have been fine to have the tube interfere with the canopy securing flap similar to what happens at the much larger vertical rectangular support columns (below) as long as they landed in between the grommets and bungees.



We calculated that we needed 6' lengths of tube, but we could only find 3' and 4' lengths of tube in stock locally. We had to make a quick decision use 3/8" solid rod as an extension of the 1/2" tube, which worked well because the former fit perfectly (only slight clearance) inside the latter. We used a small bolt and lock nut to effectively pin/dowel them together. Assuming you can order 6' lengths of 1/2" tube, you can ignore that detail.

Here is a drawing of the post. This particular post goes on two of the four corners, catty-cornered from each other. The post for the other two corners just has the angles in the top view reversed.

Here are some renderings of the finalized design.

DIY Boat Canopy Bird Seagull Wire Deterrent



DIY Boat Canopy Bird Seagull Wire Deterrent


BILL OF MATERIALS (BOM)

Per Post:
  • Preferred Option: 1/2" x 6' Aluminim Hollow Tube (length depends on height from frame mount, to bottom of skirt to top of canopy) - $Unknown
  • Alternate Option 1: 1/2" x 6' Aluminum Solid Rod (heavier, more expensive) - $Unknown
  • Alternate Option 2: 3/8" x 3' Aluminum Solid Rod - $5.36 ea. and 1/2" x 3' Aluminum Hollow Tube - $8.61 (if you can't get 6' lenghts)
  • (Qty 2) 1/4" x 3/4" x 2" Stainless U-bolt with Plate - $1.89 ea. ($0.78 ea. for non-stainless) 
  • (Qty 4) 1/4" Stainless Locknut - $6.49 for 40
  • 3/16" Stainless Eyebolt - $0.99 ea.
  • 3/16" Stainless Locknut  - $0.47 ea
  • (Qty 2) 1/4" thick x 3/4" wide x 1 3/4" long Aluminum Spacer (made from 1/4" x 3/4" x 36" flat bar) - $20 for one bar which is enough for all spacers
  • #10 x 1" Stainless Machine Screw (if using Alternate Option 2)
  • #10 Stainless Locknut (if using Alternate Option 2) - $1.59 for 6
  • #10 Stainless Flat Washer - $0.98 for 20
  • 1/2" Plastic Cap (Qty 2 if using Preferred Option) - $0.99 for 4
Cost Per Post: $25.87

Wire System:
  • 1/4" x 3" Steel Spring - $1.89 ea
  • 50# Fishing Line (~100 yards per canopy) - $12.84
Wire System Cost: $14.73

Total Cost Per Lift: $118.21 (4-post) $159.95 (6-post)

TOOLS
  • Drill or Drill Press (preferred)
  • 9/32" Drill Bit (for u-bolt)
  • 7/32" Drill Bit (for eyebolt and connecting bolt)
  • 7/16 Open Ended Wrench or Ratcheting Wrench (preferred)
  • Hacksaw or Reciprocating Saw (preferred)
  • Punch or Automatic Punch (preferred)
  • Flat metal file
  • Safety Glasses, Gloves
 CONSTRUCTION

This section will go step-by-step through the fabrication, assembly and installation of the bird wire system.

1. Post Fabrication
1a. Mark the 1/2" aluminum tube with a sharpy where you calculate the center of the bend to be.
1b. Using an appropriately sized and fixed cylindrical object as a makeshift bender, SLOWLY bend the 1/2" aluminum tube to make sure it doesn't kink. The bending process for one tube took probably around 2-3 minutes. Make sure to bend in small increments and continue to check how you are doing with your center mark. If you used 6' tube you should end up with a "U" shape with one side about twice as long as the other. If you had to use a 3' or 4' tube one side will only be slightly longer than the other. We bent the tube about 170 degrees, leaving a slight "V" to allow the tension of the line to eventually straighten the posts.
1c. If you use 1/2" hollow tube make sure to put a piece of 2 1/2" long 3/8 alumnum rod in the end that will mount to the canopy and stake it in place. We used a fine point punch to do this at the end of the tube at four spots around the diameter.
1d. This is where things get complicated. If you want the posts to be angled out towards the front or back of the canopy when installed (instead of at right angles) then you need to drill the mounting holes at about 30 degrees off angle from tube-to-tube. We ended up using a jig on the makeshift drill press to get some repeatability. Mark the tube 3/4" and 1 3/4" (note that the difference between these two numbers is 1" which is the distance between the centers of the U-bolt) from the end of the tube that mounts to the canopy. Make sure to drill the hole as close as possible to the center of the pipe and that the distance between the holes is as close to 1" as possible. Make sure to secure the pipe when drilling and that you don't let the bit wander. Use an punch to help center and start your bit on the curved surface. Drill these two holes using the 9/32 drill bit. If you have trouble fitting the U-bolts then you may need to go to 5/16, but that doesn't leave much material on the sides of the tube after drilling the holes.



1e. If you had to go with two-piece construction (Alternate Option 2) for the posts (3/8" rod and 1/2" tube) then at this point you need to combine the two. Insert the 3/8" into the 1/2" tube just enough to get the desired overall height, and then drill them (location isn't important) together using the 7/32" drill bit and attach them together using the #10 screw and locknut.
1f. Mark, punch and drill a hole 3/4" from the end of the rod or tube (depending on one or two-piece construction) that is to have the line attached. Make sure to drill the hole such that the eyebolt will generally face towards the canopy center. This angle isn't super critical because the eyebolt will work +/- 45 degrees, more aesthetic than anything. Again we used a jig to drill the holes at the correct angle and ensure repeatability. Insert the eyebolt with the eye oriented vertically, facing towards where the canopy would be and tighten using a locknut on the opposite side.
1g. Using a file, slightly round the edge of the end of the tube that mounts to the canopy, in order to attach easily the cap. If you used Option 1, also do so at the other end that supports the string.

2. Spacer Fabrication
2a. Using 1/4" x 1 3/4" (min) flat aluminum bar, cut off pieces 3/4" long, corresponding to twice the number of posts you are using. Ideally a bansaw can be used, but a sawsall and hacksaw will suffice as well. File edges for safety and appearance.
2b. Drill 9/32" holes 1" apart in the center of the plate

3. Post Installation

The cross member of our Harbor Master lift has a non-structural lip that we were able to drill through. I take no responsability for any damage you may do to your lift as a result of trying to replicate this on Harbor Master and especially any other type of lift.

3a. Mark, punch and drill two 9/32" holes 1" apart, starting ~4.5" from the end of the canopy frame. This was in far enough from the end of the canopy to still have the rod to attach to and not so far in that the angle of the post wouldn't allow the wire to be near the end of the canopy. If you have a canopy larger than 25' it is recommended that you have 6 posts, 2 in the middle of each long side. The positioning and drilling of these poles isn't critical, just make sure they are relatively even.




We value our lake being clean of debris, especially harmful objects such as glass and metal. This includes the aluminum shavings from drilling the frame. So, we used either pillow cases or over-sized ziplocks bags clothes-pinned to the frame to catch the aluminum shavings.


3b. Install the post using the U-bolts with plates and fabricated spacers where necessary to achieve separation from the cross member and making the inside post as vertical as possible.




4. Line Installation

4a. Have a plan for running the line from post to post. You should be able to do it with retracing only one of the lengths for the four post version and two lengths for the six post version. 
4b. Start first by tying the spring to the fishing line using a good non-slip knot. We use a bowline knot. This will serve as a weight to keep the line from blowing in the wind too much and also allow you to fling it across the canopy to save time.
4c. Using ladders, start threading the spring through the eyebolts in the order you have planned. Leave the spool on the dock or boat in a position so that it continues to unravel freely as you progress.
4d. Tie a short jumper line from the other end of the spring to the last eyebolt as shown below. Then at the starting eyebolt near the spool, pull the line taught to the point where the posts start bending in and there is still PLENTY of flex in the line. Remember it should not be taught enough for a seagull or large bird to stand on. I found the the spring actually didn't flex, just the line. The below image shows the line ~4" above canopy as planned. You can also see how much of a seagull problem we USED to have.

DIY Boat Canopy Bird Seagull Wire Deterrent



FINISHED PRODUCT

Posts installed without line. You can see how the posts all angle outward somewhat.

DIY Boat Canopy Bird Seagull Wire Deterrent

Final installation with line. The posts are now mostly vertical, some angling in slightly. Note the seagull flying by... scared of the BIRD WIRE!

DIY Boat Canopy Bird Seagull Wire Deterrent

UPDATE: After two months we haven't seen any seagulls land on the canopies. Over the same time we have seen tons of seagulls land on our neighbor's canopy, which has no seagull deterrent. It WORKS! You can see in some of the pictures that the rods are a little bent. I think I tightened the fishing line a little too much. I might splice in a foot of line next year.

Boat Lift Canopy Seagull Wire Deterrent - Double

Boat Lift Canopy Seagull Wire Deterrent - Mastercraft

Boat Lift Canopy Seagull Wire Deterrent - Pontoon

Boat Lift Canopy Seagull Wire Deterrent - Double 2












Friday, June 12, 2015

Interpolate Between Radar Chart Points in Excel

Problem: Using a radar chart in Microsoft Excel, when missing the first (top) data point interpret between the two adjacent ones.

When the missing value is not the first value you can tell excel to ignore it (hidden and empty cells settings) or use the =NA() function and in either case it will automatically draw a straight line between the two values.



However, when it's the first data point in the series (top in the chart) for some reason Excel doesn't interpret between the two adjacent data points.


If this were a regular, linear, X-Y scatter graph this problem would be easy and we would just average the two data points. But because the radar chart is a polar coordinate system an average between two data points still puts a kink in the line between the two adjacent data points.


One solution was to just manually draw a line between the two open points, but this was time consuming, tedious and more importantly, not the exact/correct solution to the problem. So instead of paying attention in class I whipped out some law of sines and law of cosines to find an equation which would calculate the value required to put a point on a line between two adjacent points on the spokes of the radar chart if the angle (based on the number of spokes) and the two adjacent point values are known.


Here's the equation and the resulting complete graph.

=Value_A*SIN(ASIN(Value_A*SIN(PI()*4/N_Spokes)/SQRT(Value_A^2+Value_B^2-2*Value_B*Value_A*COS(PI()*4/N_Spokes))))/SIN(PI()-ASIN(Value_A*SIN(PI()*4/N_Spokes)/SQRT(Value_A^2+Value_B^2-2*Value_B*Value_A*COS(PI()*4/N_Spokes)))-PI()/6)


In case you're curious, I used this for the Competing Values Framework (CVF) radar charts.









Thursday, August 29, 2013

How to Export Solid Models from NX and Import into Blender

Summary:
This blog post details how to import solid bodies into Blender from NX. As always there are many different ways to skin a cat, but I was only able to find particular combination of files types and tools to maintain solid body definition after the import into Blender. The assembly model I wanted to import from NX had over 50 different bodies and over 500 surfaces. Even trying to select all of the surfaces associated with a body and creating a group or linking them would be impossibly tedious and wasteful. Hopefully this information will save you time and effort as well!

Steps:
I'm going to use this part with two bodies, a cube with a square cutout and a cylinder, as an example and walk through the process.


1. Export the model from NX. I'm using NX7.5. File -> Export -> Parasolid


2. A new Export Parasolid dialog will pop up. Select the desired bodies to export or Ctrl+A for all bodies. The desired bodies should be highlighted and the OK button should become green/selectable. Click OK.


3. Browse to the desired output directory and name the output file. 


4. Download and install CAD Exchanger. Unfortunately this is not freeware or open source, but there is a free trial period (no idea the duration) and it was the only file converting utility I could find that could go from parasolid to x3d.

5. Open CAD Exchanger. Before we get started we need to enable "Merge Face Sets" in the X3D exporter options. Go to Tools -> Options. Click on "X3D exporter" in the left hand list. Check "Merge Face Sets". Click OK.



6. Start a new file, File -> New.

7. Import the recently exported parasolid file, File -> Import.


8. You can see a preview of the model and solid bodies in the tree to the left.


9. Export the model, File -> Export. Select X3D files (*.x3d) in the dropdown menu). Name and save the file.


10. Open a new file in Blender and delete the auto-generated cube. Your screen should look something like this. I'm using Blender 2.68.


11. Import the newly exported X3D file using File -> Import -> X3D Extensible 3D (.x3d/.wrl).


12. Browse to the X3D file, select it, and click "Import X3D/VRML2".


13. After rotating and scaling this is our cube and cylinder! Done!


Hope someone finds this helpful, I know it would have saved me quite a few hours of trial and error. Please post successful results or questions in the comments as well as if you find a free/open source file converter.