Optimizing the Spread: More Spreadsheet Circuit Design Tricks

Last time I showed you how to set up a reasonably complex design in a spreadsheet: a common emitter bipolar transistor amplifier. Having the design in a spreadsheet makes it easy to do “what if” scenarios and see the effects on the design almost immediately.

Another advantage that spreadsheets offer is a way to “solve” or optimize equations. That can be very useful once you have your model. For Excel, you need to install the Solver add-in (go to the Excel Options dialog, select Manage Add-Ins, and select the Solver Add-In). You might also enjoy OpenSolver. You can even get …read more

Continue reading Optimizing the Spread: More Spreadsheet Circuit Design Tricks

Droolworthy Animatronic Stargate Horus Helmet

It’s incredibly likely that, unless you own one of the original movie props, your Stargate Horus helmet is not as cool as [jeromekelty]’s. We say this with some confidence because [jerome] got access to the original molds and put in an incredible amount of time on the animatronics. (See his latest video embedded below.)

Surprisingly, a number of the parts for this amazing piece were bought off the shelf. The irises that open and close they eyes, for instance, were bought on eBay. This is not to downplay the amount of custom design, though. The mechanism that moves the feathers …read more

Continue reading Droolworthy Animatronic Stargate Horus Helmet

Soviet-Era Tank Gets The 3D Printed Treatment

3D printers are celebrated for their capacity to replace missing or broken parts. How about an entire T-62 tank?

Now hold on a second — this is only a model replica. It is, however another expression of the myriad uses for 3D printers. Designed in Maya and requiring almost three weeks to print all 62 parts from about 70 meters of PLA filament.  The assembly is not terribly involved, made easier by printing a few large sections such as the crew section and hull while the parts don’t get much smaller than the turret hatches. Nonetheless, he final product is …read more

Continue reading Soviet-Era Tank Gets The 3D Printed Treatment

R/C Hot Rod Built Completely From Scratch

[ossum]’s R/C hot rod shows what’s possible when a talented hacker takes full advantage of all the modern resources available to them. The results are stunning.

[ossum] had a stack of Amazon and Shapeways credits lying around after winning a few competitions. He had this dream of building an R/C car for a while, and decided now was the time. After ordering all the needed parts from Amazon, he made an extremely nice model of the car in Fusion 360. The CAD model is a great learning resource. If you want to learn how to use reference photos, parts, and …read more

Continue reading R/C Hot Rod Built Completely From Scratch