AI Creates Your Spreadsheets, Sometimes

August 9, 2022 by 9 Comments

We’ve been interested in looking at how AI can process things other than silly images. That’s why the “Free AI Bot that Generates the Excel Formula for Any Problem” caught our eye. Based on GPT-3, it supposedly transforms your problem description into a formula suitable for Excel or Google Sheets.

Our first prompt didn’t work out very well. But that was sort of our fault. When they say “Excel formula” they mean that quite literally. So trying to describe the actual result you want in terms of columns or rows seems to be beyond it. Not realizing that, we asked:

If the sum of column H is greater than 50, multiply column A by 0.33

And got:

=IF(SUM(H:H)>50,A*0.33,0)

A Better Try

Which is close, but not really how anyone even mildly proficient with Excel would interpret that request. But that’s not fair. It really needs to be a y=f(x) sort of problem, we suppose.

Continue reading “AI Creates Your Spreadsheets, Sometimes” →

Infant is wearing sensor vest as she is held by her mom. ECG, respiration, and accelerometry data is also showing.

Open Source Wearables For Infants

August 9, 2022 by 8 Comments

We’ve seen plenty of hacks that analyze biometric signals as measures of athletic performance, but maybe not as many hacks that are trying to study behavior. Well, that’s exactly what developmental psychologists at Indiana University and the University of East Anglia have done with their open-source, wireless vest for measuring autonomic function in infants.

infant biosensor vest for heart rate, motion, and respiratory rateTheir device includes a number of components we’ve seen already. There is an HC-05 Bluetooth module, AD8232 electrocardiography (ECG) analog front-end, LIS3DH 3-axis accelerometer, MCP73831 LiPo charger, a force-sensitive resistor for measuring respiration, and a Teensy microcontroller. Given how sensitive an infant’s skin can be, they opted for fabric electrodes for the ECG instead of those awful sticky ones that we’re accustomed to. They then interfaced the conductive fabric with copper plates using snap fasteners (or press studs or snap buttons, whichever terminology you’re more familiar with). The copper plates were connected to the circuit board using standard electrical wire. Then, they embedded the sensors into a vest they sewed together themselves. It’s basically a tiny weighted vest for infants but it seems well-padded enough to be somewhat comfortable.

They did a short test analyzing heart and breathing rates during a period of “sustained attention,” basically when you’re quietly fixated on a single object or activity for a period of a few minutes or longer. They were really pleased with the vest’s ability to collect consistent data and noted that heart and respiratory rate variability decreased during the sustained activity test, which was an expected outcome. Apparently, when you’re pretty fixated on a singular task, your body naturally calms down, so to speak, and the variability in some of your physiological responses decreases. Well, unless someone slowly walks up behind you and pinches you, of course.

They provided detailed instructions for recreating the vest, so be sure to check those out. They probably want their device to look a lot less than body armor though. Maybe the Sewbo can help them out with their next iteration.

Junkbox Build Keeps Tesla Coils Perfectly Varnished

August 9, 2022 by 21 Comments

Admittedly, not a lot of people have a regular need to varnish coils. It’s mainly something that Tesla coil builders and other high-voltage experimenters are concerned with. But since that group probably constitutes a not insignificant fraction of the Hackaday audience, and because there are probably more applications for this homebrew coil varnishing setup, we figured it would be a good idea to share it.

For [Mads Barnkob], coil maintenance isn’t something to take lightly. If you check out his Kaizer Power Electronics channel on YouTube, you’ll see that he has quite a collection of large, powerful Tesla coils, some of which are used for demos and shows, and others that seem to be reserved mainly for blowing stuff up. To prevent one of his coils from joining the latter group, keeping the coat of insulating varnish on the secondary coil windings in tip-top condition is essential.

The setup seen in the video below helps with that tedious chore. Built entirely from scraps and junk bin parts, the low-speed, low-precision lathe can be set up to accommodate coils of all sizes. In use, the lathe turns the coil very slowly, allowing [Mads] to apply an even coat of varnish over the coil surface, and to keep it from sagging while it dries.

[Mads]’ setup is probably not great for coil winding as it is, but for coil maintenance, it’s just the thing. If your needs are more along the lines of a coil winder, we’ve got a fully automated winder that might work for you.

Continue reading “Junkbox Build Keeps Tesla Coils Perfectly Varnished” →

Large Tip Driven Copter Turns Very Slowly

August 8, 2022 by 21 Comments

Picking propeller size for any aircraft, but especially VTOLs, it’s a tradeoff between size and RPM. You can either move a large volume of air slowly or a small volume of air quickly. Small and fast tend to be the most practical for many applications, but if you’re thinking outside the box like [amazingdiyprojects], you can build a massive propeller and make it fly at just one revolution per second. (Video, embedded below the break.)

One of the challenges of large propellers is their high torque requirements. To get around this, [amazingdiyprojects] drives the 5m diameter propeller from the tips using electric motors with propellers. The blades are simple welded aluminum frames covered with heat-shrunk packing tape, braced with wires for stiffness.

The flight controller, with its own battery, is prevented from spinning with the blades by counteracting the spin of a small DC motor. Each blade is equipped with a servo-driven control surface, which can give roll and pitch control by adjusting deflection based on the blade’s radial position.

[amazingdiyprojects] control setup is very creative but somewhat imprecise. Instead of trying to write a custom control scheme, he configured the old KK2.15HC flight controller for a hexacopter. Each control servo’s PWM signal routes through a commutator disc with six sectors, one for each motor of the virtual hexacopter. This means each of the servos switches between six different PWM channels throughout its rotation. To compensate for lag when switching between channels, [amazingdiyprojects] had to tune the offset of the commutator disc otherwise it would veer off in the wrong direction. After a second test flight session to tune the flight controller settings, control authority improved, although it is still very docile in terms of response.

Continue reading “Large Tip Driven Copter Turns Very Slowly” →

Replace An AA Battery With Paper

August 8, 2022 by 54 Comments

Paper is an ubiquitous part of society; so much so that the incredible engineering behind it often goes unnoticed. That isn’t the case for [Robert], though, who has a deep appreciation for the material and all its many uses far beyond recording information. In this particular video, he recreates a method found by researchers to turn a piece of paper into a battery with equivalent performance to a AA-sized alkaline battery. (Video, embedded below the break.)

The process involves the creation of a few different types of ink, each of which can be made with relatively common materials such as shellac, ethanol, polyethylene glycol, and graphite. Each of these materials are mixed in different proportions to create the inks. Once the cathode ink and anode ink are made, a third ink is needed called a current collector ink which functions essentially as a wire. The paper is dipped into a salt solution and then allowed to dry, given a partial waterproof coating, and when it is needed it can be activated by wetting it which allows the ion flow of the battery to happen.

The chemistry of this battery makes a lot of sense once you see it in action, and the battery production method also has a perk of having a long shelf life as long as the batteries stay dry. They also don’t damage the environment as much as non-rechargable alkaline cells do, at least unless you want to go to some extreme measures to reuse them.

Continue reading “Replace An AA Battery With Paper” →

The Car Of Theseus Boldly Goes Where Many Cars Have Gone Before

August 8, 2022 by 45 Comments

We could all use a good chuckle every once in a while. [William Osman] revisited the ship of Theseus in a simplified manner. How many parts can you remove from a car and still be a car? (Video, embedded below the break.)

Of course, there are legal definitions of what a car is and a minimum set of requirements to be met to drive on the road. So, with two older cars ready for hacking and a group of hackers gathered, they split into two teams and started ripping parts of the vehicle. It becomes pretty humorous as it reminds us of many refactoring projects we’ve undertaken. For example, you move one BGA chip, and suddenly, it might be faster to reroute the whole board. Or you remove one component, you have to rip it out of three other modules, which affect four or more other modules, and so on. Accidentally cutting part of the electrical harness meant that one team had to dig further and further into the car to get back to a working car state. It was a race to get back to street legal while taking off more parts.

By the end of the exercise, they have a technically street-legal car they drove around, enjoying passersby’s pointed looks and confusion. They even take it to a dealership to see how much they could get for it. [William] points out that their abysmally low offer proves that a car with less stuff costs less. While we doubt that car manufacturers will follow his lead, it’s a good 15 minutes of fun.

We’ve got you covered if you’re interested in more minimal motoring.

Continue reading “The Car Of Theseus Boldly Goes Where Many Cars Have Gone Before” →

The SDWire board plugged into some SoM's breakout board's MicroSD socket

Automated MicroSD Card Swapping Helps In Embedded Shenanigans

August 8, 2022 by 20 Comments

[Saulius Lukse] has been working on some single board computer, seemingly, running Linux. Naturally, that boots from a microSD card – and as development goes on, that card has to be reimaged all the time. Sick of constantly plugging and unplugging the microSD card between the SBC and an SD card reader, [Saulius] started looking for a more automated solution – and it wasn’t long before he found out about the SDWire project, a hardware tool that lets you swap a card between a DUT (Device Under Test) and your personal computer with no moving parts involved.

SDWire is an offshoot from the Tizen project, evidently, designed to be of help in device development, be it single-board computers or smartphones. The idea is simple – you plug your MicroSD card into the SDWire board, plug the SDWire into a MicroSD slot of your embedded device, and then connect a USB cable from the SDWire to your development computer. This way, if you need to reflash the firmware on the SBC you’re tinkering with, you only need to issue a command to the SDWire board over the USB cable, and the MicroSD card appears as a storage drive on your computer. SDWire is a fully open source project, both in hardware and in software, and you can also buy preassembled boards online.

Such shortening of development time helps in things like automated testing, but it also speeds your development up quite a bit, saving you time between iterations, freeing you from all the tiny SD card fiddling, and letting you have more fun as you hack. There’s a clear need for a project like SDWire, as we’ve already seen a hacker assemble such a device using breakouts.