WCD CAD in 20 Seconds: Spreadsheet Deriven Back Driven VexPro Ball Shifter CAD Tool

aka Drivetrain CAD in 20 Seconds

Some teams feel that West-Coast style drives are out of their reach and feel forced to use the kitbot year after year, so we on Team 449 - The Blair Robot Project put together a spreadsheet-driven CAD where anyone can quickly type in parameters into a spreadsheet and the CAD will be updated appropriately. This CAD matches the style which Team 449 has been using, with 6 MiniCIMs in two VexPro ball shifter gearboxes placed in the back of the robot. Wheels can either be 4 or 6 inches in diameter, and can either have all six wheels be Colson Performa wheels, or they can be set as 2+4 with Colson wheels in the center and VexPro omni wheels on the edges. The frame is made of four lengths of aluminum 1/8" thick 2x1 tube and can be heavily customized through the spreadsheet. While this tool is focused on belts (specifically 15mm wide HTD belts), and includes a c-c distance chart for 5mm HTD, this could also be used for chain drive with a bit of effort.

This tool requires Autodesk Inventor 2018 and Microsoft Excel (free alternatives don’t work).

Features:

  1. Customizable 2x1x1/8" aluminum tube drive.
  2. Supports standard 6-Colson WCD and 2+4, with both 6" and 4" wheel diameter.
  3. Easy to adjust dimensions, wheel types, etc.
  4. Fully constrained VexPro Ball Shifter Gearbox CAD.
  5. 5mm HTD belt C-C distance chart included.
  6. Hardware, belts, etc. are included in the CAD (with text on the belts!)

How to use:

  1. Download the files from https://grabcad.com/library/spreadsheet-deriven-back-driven-vexpro-ball-shifter-wcd-1
  2. Extract the contents of the .zip to the desired location.
  3. Double click “Spreadsheet Deriven VexPro Ball Shifter WCD.ipj” at root
  4. In Windows Explorer Go to Workspaces\Workspace\Base Frame
  5. Open “Base Frame Sheet.xlsx” and “Base Frame With Gearboxes.iam”
  6. Set your settings in the spreadsheet. Remember, bad inputs make bad results.
  7. Go to “Base Frame With Gearboxes.iam” in Inventor.
  8. Go to the Manage tab and click on the iTrigger button. This updates wheels.
  9. Then, click the update button (the lightning bolt) at the top. This updates dimensions and constraints.
  10. Preview the generated results, and repeat steps 4-7 as needed.

Helpful 449 WCD/2+4 Tips:

  1. Make a test piece to test c-c distance, belt tension, and wheel-ground contact before finalizing exact specs.
  2. We found that 6" Colsons are slightly smaller than 6" omnis. This reduces how good they are at providing traction to a 2+4 drive, since they aren’t touching the ground. This is one of the things to check for and adjust in tip 1. We found a .007" center drop works well enough for a 6" wheel 2+4.
  3. 3D print gearbox shields for the third stage of the gearboxes to keep them clean.
  4. After this past year we’ve come to like 2+4 (with no center drop, obviously) quite a lot. If you’ve never tried making and using a 2+4 drive, I would strongly recommend doing so.

If you come across any problems or have any questions about the design, feel free to ask!

I have been working on the same exact thing… its a little creepy

Seriously though this looks awesome and will help out our project.

We also had someone on our team working on a type of drivetrain generator!

I thought that this idea was really cool. I didn’t know that you could have parameters driven by Excel spreadsheets, so I found a video that explained how to do it. I made a similar WCD generator using the VersaChassis system. It’s not quite as flexible as yours but I will work on improving it in the future.

Using WCP Flipped DS and 2+4 Colson and Omni (4inch). It was a good learning experience to make sure that all of the dimensions behaved as expected when changing the size of the frame.

Here it is:
https://workbench.grabcad.com/workbench/projects/gcoE9qRYrMpQx2GSreKpyNp58VhU0MsksmVksPhdDHmixM#/space/gchgIx5WZTUjL8vzXGb60tC9yus8FvUZ24x0aq7GHRq2oz

You need Inventor 2017 or later to open

Edit: one question I had was how did you make the parameters change the part used? For example changing from a 4inch to a 6inch wheel, or from all-Colson to 2+4. If you could point me to some video/text resources I would appreciate it. Thanks!