Author name: Tim Belzer

the-perfect-new-year’s-eve-comedy-turns-30

The perfect New Year’s Eve comedy turns 30

There aren’t that many movies specifically set on New Year’s Eve, but one of the best is The Hudsucker Proxy (1994), Joel and Ethan Coen’s visually striking, affectionate homage to classic Hollywood screwball comedies. The film turned 30 this year, so it’s the perfect opportunity for a rewatch.

(WARNING: Spoilers below.)

The Coen brothers started writing the script for The Hudsucker Proxy when Joel was working as an assistant editor on Sam Raimi’s The Evil Dead (1981). Raimi ended up co-writing the script, as well as making a cameo appearance as a brainstorming marketing executive.  The Coen brothers took their inspiration from the films of Preston Sturgess and Frank Capra, among others, but the intent was never to satirize or parody those films. “It’s the case where, having seen those movies, we say ‘They’re really fun—let’s do one!’; as opposed to “They’re really fun—let’s comment upon them,'” Ethan Coen has said.

They finished the script in 1985, but at the time they were small indie film directors. It wasn’t until the critical and commercial success of 1991’s Barton Fink that the Coen brothers had the juice in Hollywood to finally make The Hudsucker Proxy. Warner Bros. greenlit the project and producer Joel Silver gave the brothers complete creative control, particularly over the final cut.

Norville Barnes (Tim Robbins) is an ambitious, idealistic recent graduate of a business college in Muncie, Indiana, who takes a job as a mailroom clerk at Hudsucker Industries in New York, intent on working his way to the top. That ascent happens much sooner than expected. On the same December day in 1958, the company’s founder and president, Waring Hudsucker (Charles Durning), leaps to his death from the boardroom on the 44th floor (not counting the mezzanine).

A meteoric rise

Norville Barnes (Tim Robbins) gets a job at Hudsucker Industries Warner Bros.

To keep the company’s stock from going public as the bylaws dictate, board member Sidney Mussburger (Paul Newman) proposes they elect a patsy as the next president—someone so incompetent it will spook investors and temporarily depress the stock so the board can buy up controlling shares on the cheap. Enter Norville, who takes the opportunity of delivering a Blue Letter to Mussburger to pitch a new product, represented by a simple circle drawn on a piece of paper: “You know… for kids!” Thinking he’s found his imbecilic patsy, Mussburger names Norville the new president.

The perfect New Year’s Eve comedy turns 30 Read More »

power-company-hid-illegal-crypto-mine-that-may-have-caused-outages

Power company hid illegal crypto mine that may have caused outages

But Russia presumably gets no taxes on illegal crypto mining, and power outages can be costly for everyone in a region. So next year, Russia will ban crypto mining in 10 regions for six years and place seasonal restrictions that would disrupt some crypto mining operations during the coldest winter months in regions like Irkutsk, CoinTelegraph reported.

Illegal mining is still reportedly thriving in Irkutsk, though, despite the government’s attempts to shut down secret farms. To deter any illegal crypto mining disrupting power grids last year, authorities seized hundreds of crypto mining rigs in Irkutsk, Crypto News reported.

In July, Russian president Vladimir Putin linked blackouts to illegal crypto mines, warning that crypto mining currently consumes “almost 1.5 percent of Russia’s total electricity consumption,” but “the figure continues to go up,” the Moscow Times reported. And in September, Reuters reported that illegal mines were literally going underground to avoid detection as Russia’s crackdown continues.

Even though illegal mines are seemingly common in parts of Siberia and increasingly operating out of the public eye, finding an illegal mine hidden on state land controlled by an electrical utility was probably surprising to officials.

The power provider was not named in the announcement, and there are several in the region, so it’s not currently clear which one made the controversial decision to lease state land to an illegal mining operation.

Power company hid illegal crypto mine that may have caused outages Read More »

evolution-journal-editors-resign-en-masse

Evolution journal editors resign en masse


an emerging form of protest?

Board members expressed concerns over high fees, editorial independence, and use of AI in editorial processes.

Over the holiday weekend, all but one member of the editorial board of Elsevier’s Journal of Human Evolution (JHE) resigned “with heartfelt sadness and great regret,” according to Retraction Watch, which helpfully provided an online PDF of the editors’ full statement. It’s the 20th mass resignation from a science journal since 2023 over various points of contention, per Retraction Watch, many in response to controversial changes in the business models used by the scientific publishing industry.

“This has been an exceptionally painful decision for each of us,” the board members wrote in their statement. “The editors who have stewarded the journal over the past 38 years have invested immense time and energy in making JHE the leading journal in paleoanthropological research and have remained loyal and committed to the journal and our authors long after their terms ended. The [associate editors] have been equally loyal and committed. We all care deeply about the journal, our discipline, and our academic community; however, we find we can no longer work with Elsevier in good conscience.”

The editorial board cited several changes made over the last ten years that it believes are counter to the journal’s longstanding editorial principles. These included eliminating support for a copy editor and a special issues editor, leaving it to the editorial board to handle those duties. When the board expressed the need for a copy editor, Elsevier’s response, they said, was “to maintain that the editors should not be paying attention to language, grammar, readability, consistency, or accuracy of proper nomenclature or formatting.”

There is also a major restructuring of the editorial board underway that aims to reduce the number of associate editors by more than half, which “will result in fewer AEs handling far more papers, and on topics well outside their areas of expertise.”

Furthermore, there are plans to create a third-tier editorial board that functions largely in a figurehead capacity, after Elsevier “unilaterally took full control” of the board’s structure in 2023 by requiring all associate editors to renew their contracts annually—which the board believes undermines its editorial independence and integrity.

Worst practices

In-house production has been reduced or outsourced, and in 2023 Elsevier began using AI during production without informing the board, resulting in many style and formatting errors, as well as reversing versions of papers that had already been accepted and formatted by the editors. “This was highly embarrassing for the journal and resolution took six months and was achieved only through the persistent efforts of the editors,” the editors wrote. “AI processing continues to be used and regularly reformats submitted manuscripts to change meaning and formatting and require extensive author and editor oversight during proof stage.”

In addition, the author page charges for JHE are significantly higher than even Elsevier’s other for-profit journals, as well as broad-based open access journals like Scientific Reports. Not many of the journal’s authors can afford those fees, “which runs counter to the journal’s (and Elsevier’s) pledge of equality and inclusivity,” the editors wrote.

The breaking point seems to have come in November, when Elsevier informed co-editors Mark Grabowski (Liverpool John Moores University) and Andrea Taylor (Touro University California College of Osteopathic Medicine) that it was ending the dual-editor model that has been in place since 1986. When Grabowki and Taylor protested, they were told the model could only remain if they took a 50 percent cut in their compensation.

Elsevier has long had its share of vocal critics (including our own Chris Lee) and this latest development has added fuel to the fire. “Elsevier has, as usual, mismanaged the journal and done everything they could to maximize profit at the expense of quality,” biologist PZ Myers of the University of Minnesota Morris wrote on his blog Pharyngula. “In particular, they decided that human editors were too expensive, so they’re trying to do the job with AI. They also proposed cutting the pay for the editor-in-chief in half. Keep in mind that Elsevier charges authors a $3990 processing fee for each submission. I guess they needed to improve the economics of their piratical mode of operation a little more.”

Elsevier has not yet responded to Ars’ request for comment; we will update accordingly should a statement be issued.

Not all AI uses are created equal

John Hawks, an anthropologist at the University of Wisconsin, Madison, who has published 17 papers in JHE over his career, expressed his full support for the board members’ decision on his blog, along with shock at the (footnoted) revelation that Elsevier had introduced AI to its editorial process in 2023. “I’ve published four articles in the journal during the last two years, including one in press now, and if there was any notice to my co-authors or me about an AI production process, I don’t remember it,” he wrote, noting that the move violates the journal’s own AI policies. “Authors should be informed at the time of submission how AI will be used in their work. I would have submitted elsewhere if I was aware that AI would potentially be altering the meaning of the articles.”

There is certainly cause for concern when it comes to using AI in the pursuit of science. For instance, earlier this year, we witnessed the viral sensation of several egregiously bad AI-generated figures published in a peer-reviewed article in Frontiers, a reputable scientific journal. Scientists on social media expressed equal parts shock and ridicule at the images, one of which featured a rat with grotesquely large and bizarre genitals. The paper has since been retracted, but the incident reinforces a growing concern that AI will make published scientific research less trustworthy, even as it increases productivity.

That said, there are also some useful applications of AI in the scientific endeavor. For instance, back in January, the research publisher Science announced that all of its journals would begin using commercial software that automates the process of detecting improperly manipulated images. Perhaps that would have caught the egregious rat genitalia figure, although as Ars Science Editor John Timmer pointed out at the time, the software has limitations. “While it will catch some of the most egregious cases of image manipulation, enterprising fraudsters can easily avoid being caught if they know how the software operates,” he wrote.

Hawks acknowledged on his blog that the use of AI by scientists and scientific journals is likely inevitable and even recognizes the potential benefits. “I don’t think this is a dystopian future. But not all uses of machine learning are equal,” he wrote. To wit:

[I]t’s bad for anyone to use AI to reduce or replace the scientific input and oversight of people in research—whether that input comes from researchers, editors, reviewers, or readers. It’s stupid for a company to use AI to divert experts’ effort into redundant rounds of proofreading, or to make disseminating scientific work more difficult.

In this case, Elsevier may have been aiming for good but instead hit the exacta of bad and stupid. It’s especially galling that they demand transparency from authors but do not provide transparency about their own processes… [I]t would be a very good idea for authors of recent articles to make sure that they have posted a preprint somewhere, so that their original pre-AI version will be available for readers. As the editors lose access, corrections to published articles may become difficult or impossible.

Nature published an article back in March raising questions about the efficacy of mass resignations as an emerging form of protest after all the editors of the Wiley-published linguistics journal Syntax resigned in February. (Several of their concerns mirror those of the JHE editorial board.) Such moves certainly garner attention, but even former Syntax editor Klaus Abels of University College London told Nature that the objective of such mass resignations should be on moving beyond mere protest, focusing instead on establishing new independent nonprofit journals for the academic community that are open access and have high academic standards.

Abels and his former Syntax colleagues are in the process of doing just that, following the example of the former editors of Critical Public Health and another Elsevier journal, NeuroImage, last year.

Photo of Jennifer Ouellette

Jennifer is a senior reporter at Ars Technica with a particular focus on where science meets culture, covering everything from physics and related interdisciplinary topics to her favorite films and TV series. Jennifer lives in Baltimore with her spouse, physicist Sean M. Carroll, and their two cats, Ariel and Caliban.

Evolution journal editors resign en masse Read More »

frogfish-reveals-how-it-evolved-the-“fishing-rod”-on-its-head

Frogfish reveals how it evolved the “fishing rod” on its head

In most bony fish, or teleosts, motor neurons for fins are found on the sides (ventrolateral zone) of the underside (ventral horn) of the spinal cord. The motor neurons controlling the illicium of frogfish are in their own cluster and located in the dorsolateral zone. In fish, this is unusual.

“The peculiar location of fishing motor neurons, with little doubt, is linked with the specialization of the illicium serving fishing behavior,” the team said in a study recently published in the Journal of Comparative Neurology.

Fishing for answers

So what does this have to do with evolution? The white-spotted pygmy filefish might look nothing like a frogfish and has no built-in fishing lure, but it is still a related species and can possibly tell us something.

While the first dorsal fin of the filefish doesn’t really move—it is thought that its main purpose is to scare off predators by looking menacing—there are still motor neurons that control it. Motor neurons for the first dorsal fin of filefish were found in the same location as motor neurons for the second, third and fourth dorsal fins in frogfish. In frogfish, these fins also do not move much while swimming, but can appear threatening to a predator.

If the same types of motor neurons control non-moving fins in both species, the frogfish has something extra when it comes to the function and location of motor neurons controlling the illicium.

Yamamoto thinks the unique group of fishing motor neurons found in frogfish suggests that, as a result of evolution, “the motor neurons for the illicium [became] segregated from other motor neurons” to end up in their own distinct cluster away from motor neurons controlling other fins, as he said in the study.

What exactly caused the functional and locational shift of motor neurons that give the frogfish’s illicium its function is still a mystery. How the brain influences their fishing behavior is another area that needs to be investigated.

While Yamamoto and his team speculate that specific regions of the brain send messages to the fishing motor neurons, they do not yet know which regions are involved, and say that more studies need to be carried out on other species of fish and the groups of motor neurons that power each of their dorsal fins.

In the meantime, the frogfish will continue being its freaky self.

Journal of Comparative Neurology, 2024. DOI: 10.1002/cne.25674

Frogfish reveals how it evolved the “fishing rod” on its head Read More »

you-can-love-or-hate-ai,-but-it’s-killed-crappy-8gb-versions-of-pricey-pcs-and-macs

You can love or hate AI, but it’s killed crappy 8GB versions of pricey PCs and Macs

I’d describe myself as a skeptic of the generative AI revolution—I think the technology as it currently exists is situationally impressive and useful for specific kinds of tasks, but broadly oversold. I’m not sure it will vanish from relevance to quite the extent that other tech fads like the metaverse or NFTs did, but my suspicion is that companies like Nvidia and OpenAI are riding a bubble that will pop or deflate over time as more companies and individuals run up against the technology’s limitations, and as it fails to advance as quickly or as impressively as its most ardent boosters are predicting.

Maybe you agree with me and maybe you don’t! I’m not necessarily trying to convince you one way or the other. But I am here to say that even if you agree with me, we can all celebrate the one unambiguously positive thing that the generative AI hype cycle has done for computers this year: the RAM floor for many PCs and all Macs is now finally 16GB instead of 8GB.

Companies like Apple and Microsoft have, for years, created attractive, high-powered hardware with 8GB of memory in it, most egregiously in $1,000-and-up putative “pro” computers like last year’s $1,599 M3 MacBook Pro or the Surface Pro 9.

This meant that, for the kinds of power users and professionals drawn to these machines, that their starting prices were effectively mirages; “pay for 16GB if you can” has been my blanket advice to MacBook buyers for years now, since there’s basically no workload (including Just Browsing The Web) that won’t benefit at least a little. It also leaves more headroom for future software bloat and future hobby discovery. Did you buy an 8GB Mac, and then decide you wanted to try software development, photo or video editing, CAD design, or Logic Pro? Good luck!

You can love or hate AI, but it’s killed crappy 8GB versions of pricey PCs and Macs Read More »

after-a-24-second-test-of-its-engines,-the-new-glenn-rocket-is-ready-to-fly

After a 24-second test of its engines, the New Glenn rocket is ready to fly

After a long day of stops and starts that stretched well into the evening, and on what appeared to be the company’s fifth attempt Friday, Blue Origin successfully ignited the seven main engines on its massive New Glenn rocket.

The test firing as fog built over the Florida coast marks the final major step in the rocket company’s campaign to bring the New Glenn rocket—a privately developed, super-heavy lift vehicle—to launch readiness. Blue Origin said it fired the vehicle’s engines for a duration of 24 seconds. They fired at full thrust for 13 of those seconds.

“This is a monumental milestone and a glimpse of what’s just around the corner for New Glenn’s first launch,” said Jarrett Jones,  senior vice president of the New Glenn program, in a news release. “Today’s success proves that our rigorous approach to testing–combined with our incredible tooling and design engineering–is working as intended.”

Completion of the dynamic hot-fire test sets up a historic moment for the company founded by Jeff Bezos nearly a quarter of a century ago, the firm’s first ever orbital launch attempt. It will occur from Launch Complex-36, at Cape Canaveral Space Force Station.

Blue Origin’s post-test update did not include a launch date, but based on flight advisory information, a no-earlier than launch date is likely to be January 6.

A license to fly

Friday was important for New Glenn’s debut mission in another way. Several hours before the test firing, the Federal Aviation Administration said it had issued a launch license for the rocket. The license allows Blue Origin to conduct orbital missions from Cape Canaveral with New Glenn, as well as to attempt first stage landings on a barge in the Atlantic Ocean. The license is valid for five years.

After years of waiting, the much-anticipated mission is finally coming together. The hot-fire test, taking place just two days after the Christmas holiday in the United States, reflects the urgency that Bezos has injected into his rocket company over the last 18 months. In the fall of 2023, Bezos ousted Bob Smith as chief executive of Blue Origin, and tapped a long-time Amazon executive, Dave Limp, to lead the company.

After a 24-second test of its engines, the New Glenn rocket is ready to fly Read More »

could-microwaved-grapes-be-used-for-quantum-sensing?

Could microwaved grapes be used for quantum sensing?

The microwaved grape trick also shows their promise as alternative microwave resonators for quantum sensing applications, according to the authors of this latest paper. Those applications include satellite technology, masers, microwave photon detection, hunting for axions (a dark matter candidate), and various quantum systems, and driving spin in superconducting qubits for quantum computing, among others.

Prior research had specifically investigated the electrical fields behind the plasma effect. “We showed that grape pairs can also enhance magnetic fields which are crucial for quantum sensing applications,” said co-author Ali Fawaz, a graduate student at Macquarie University.

Fawaz and co-authors used specially fabricated nanodiamonds for their experiments. Unlike pure diamonds, which are colorless, some of the carbon atoms in the nanodiamonds were replaced, creating tiny defect centers that act like tiny magnets, making them ideal for quantum sensing. Sapphires are typically used for this purpose, but Fawaz et al. realized that water conducts microwave energy better than sapphires—and grapes are mostly water.

So the team placed a nanodiamond atop a thin glass fiber and placed it between two grapes. Then they shone green laser light through the fiber, making the defect centers glow red. Measuring the brightness told them the strength of the magnetic field around the grapes, which turned out to be twice as strong with grapes than without.

The size and shape of the grapes used in the experiments proved crucial; they must be about 27 millimeters long to get concentrated microwave energy at just the right frequency for the quantum sensor. The biggest catch is that using the grapes proved to be less stable with more energy loss. Future research may identify more reliable potential materials to achieve a similar effect.

DOI: Physical Review Applied, 2024. 10.1103/PhysRevApplied.22.064078 (About DOIs).

Could microwaved grapes be used for quantum sensing? Read More »

ftc-launches-probe-of-microsoft-over-bundling

FTC launches probe of Microsoft over bundling

John Lopatka, a former consultant to the FTC who now teaches antitrust law at Penn State, told ProPublica that the Microsoft actions detailed in the news organization’s recent reporting followed “a very familiar pattern” of behavior.

“It does echo the Microsoft case” from decades ago, said Lopatka, who co-authored a book on that case.

In the new investigation, the FTC has sent Microsoft a civil investigative demand, the agency’s version of a subpoena, compelling the company to turn over information, people familiar with the probe said. Microsoft confirmed that it received the document.

Company spokesperson David Cuddy did not comment on the specifics of the investigation but said the FTC’s demand is “broad, wide ranging, and requests things that are out of the realm of possibility to even be logical.” He declined to provide on-the-record examples. The FTC declined to comment.

The agency’s investigation follows a public comment period in 2023 during which it sought information on the business practices of cloud computing providers. When that concluded, the FTC said it had ongoing interest in whether “certain business practices are inhibiting competition.”

The recent demand to Microsoft represents one of FTC Commissioner Lina Khan’s final moves as chair, and the probe appears to be picking up steam as the Biden administration winds down. The commission’s new leadership, however, will decide the future of the investigation.

President-elect Donald Trump said this month that he will elevate Commissioner Andrew Ferguson, a Republican attorney, to lead the agency. Following the announcement, Ferguson said in a post on X, “At the FTC, we will end Big Tech’s vendetta against competition and free speech. We will make sure that America is the world’s technological leader and the best place for innovators to bring new ideas to life.”

Trump also said he would nominate Republican lawyer Mark Meador as a commissioner, describing him as an “antitrust enforcer” who previously worked at the FTC and the Justice Department. Meador is also a former aide to Sen. Mike Lee, a Utah Republican who introduced legislation to break up Google.

Doris Burke contributed research.

This story originally appeared on ProPublica.

FTC launches probe of Microsoft over bundling Read More »

magnetic-shape-shifting-surface-can-move-stuff-without-grasping-it 

Magnetic shape-shifting surface can move stuff without grasping it 

A kirigami design where the cuts’ length-to-width ratio was six was way more responsive to magnets, and that, in turn, enhanced an effect known as magnetically induced stiffening. With no magnets around, the kirigami disk was way more compliant than one without cuts. But when a magnetic field was applied, it became more than 1.8 times stiffer.

Overall, the kirigami dome could lift an object weighing 43.1 grams (28 times its own weight) to a height of 2.5 millimeters and hold it there. To test what this technology could do, Yin’s team built a 5×5 array of domes actuated by movable permanent magnetic pillars placed underneath that could move left or right, or spin. The array could precisely move droplets, potato chips, a leaf, and even a small wooden plank. It could also rotate a petri dish.

Next-gen haptics

The team thinks one possible application for this technology is precise transport and mixing of very tiny amounts of fluids in research laboratories. But there is another, arguably more exciting option. Chi’s shape-shifting surface is very fast; it reacts to changes in the magnetic field in under 2 milliseconds, which is a response time rivaling gaming monitors.

This, according to the team, makes it possible to use in haptic feedback controllers. Super-fast, magnetically actuated shape-shifting surfaces could emulate the sense of touch, texture, and feel of the objects you interact with wearing your VR goggles. “I’m new to haptics, but considering you can change the stiffness of our surfaces by modulating the magnetic field, this should enable us to recreate different haptic perceptions,” Yin says.

Before that becomes a reality, there is one more limitation the team must overcome.

If you compared Yin’s shape-shifting surface to a display where each dome stands for a single pixel, the resolution of this display would be very low. “So, there is the question how small can you make those domes,” Yin says. He suggested that, with advanced manufacturing techniques, it is possible to miniaturize the domes down to around 10 microns in diameter. “The challenge is how we do the actuation at such scales—that is something we focus on today. We try to pave the way but there is much more to do,” Chi adds.

Science Advances, 2024. DOI: https://doi.org/10.1126/sciadv.adr8421

Magnetic shape-shifting surface can move stuff without grasping it  Read More »

craving-carbs?-blame-an-ancient-gene.

Craving carbs? Blame an ancient gene.

“This observation is concordant with the recent evidence of Neanderthal starch consumption, and perhaps the availability of cooked starch in archaic hominins made possible through the domestication of fire,” the researchers said in a study recently published in Science.

Out of eight genomes examined, multiple copies of AMY1 were found in two Eastern Neanderthal genomes, one from a Western Neanderthal, and one from a Denisovan. So why did these extra copies evolve? While the exact reason is still unknown, the team thinks that the gene itself was copy number variable, meaning the number of copies within a population can vary between individuals. This variation likely developed before humans diverged from Neanderthals and Denisovans.

With the grain

To the research team, it was inevitable that copies of AMY1 in individual genomes would increase as former hunter-gatherers established agricultural societies. Farming meant grains and other starch-rich foods, and the ability to adjust those meant carbs.

And the data here is consistent with that. The team “found a general trend where the AMY1 gene copy number is significantly higher among samples excavated from archaeologically agricultural contexts compared to those from hunter-gatherer contexts,” as they said in the same study.

In genomes from pre-agricultural individuals, there were already anywhere from four to eight copies of the gene. The variation is thought to have come from groups experimenting with food-processing techniques such as grinding wild grains into flour. AMY1 copy numbers grew pretty consistently from the pre-agricultural to post-agricultural period. Individuals from populations that were in the process of transitioning to agriculture (around 16,100 to 8,500 years ago) were found to have about similar numbers of AMY1 copies as hunter-gatherers at the time.

Individuals from after 8,500 years ago who lived in more established agricultural societies showed the most copies and therefore the most evidence of adaptation to eating diets high in carbs. Agriculture continued to advance, and the last 4,000 years have seen the most significant surge of AMY1 copy increases. Modern humans have anywhere from two to 15 copies.

Further research could help with understanding how genetic variation of AMY1 copy numbers influences starch metabolism, including conditions such as gluten allergy and celiac disease, and overall metabolic health.

Can we really blame AMY1 and amylase on our carb cravings? Partly. The number of AMY1 copies in a human genome determine not only the ability to metabolize starches, but will also influence how they taste to us, and may have given us a preference for them. Maybe we can finally ease up on demonizing bread.

Science, 2024.  DOI: 10.1126/science.adn060

Craving carbs? Blame an ancient gene. Read More »

i-keep-turning-my-google-sheets-into-phone-friendly-webapps,-and-i-can’t-stop

I keep turning my Google Sheets into phone-friendly webapps, and I can’t stop


Software is eating the world and I have snacks for it

How I tackled takeout, spices, and meal ideas with spreadsheets and Glide.

It started, like so many overwrought home optimization projects, during the pandemic.

My wife and I, like many people stuck inside, were ordering takeout more frequently. We wanted to support local restaurants, reduce the dish load, and live a little. It became clear early on that app-based delivery services like DoorDash and Uber Eats were not the best way to support local businesses. If a restaurant had its own ordering site or a preferred service, we wanted to use that—or even, heaven forfend, call the place.

The secondary issue was that we kept ordering from the same places, and we wanted to mix it up. Sometimes we’d want to pick something up nearby. Sometimes we wanted to avoid an entire category (“Too many carbs this week, no pasta”) or try the newest places we knew about, or maybe a forgotten classic. Or just give me three places randomly, creative constraints, please—it’s Friday.

At its core, this is a shared list, i.e. spreadsheet. But my spreadsheet maintenance enthusiasm greatly outweighs that of my spouse. More than that, have you ever pulled up a Google Sheet or online Excel file on your normal-sized phone to make changes? I do so only in moments of true desperation.

For things that are bigger than a note or dry-erase board but smaller than paying for some single-use, subscription-based app, I build little private webapps with Glide. You might use something else, but Glide is a really nice entry into the spreadsheet-to-app milieu. The apps it creates are the kind that can easily be shared and installed (i.e., “Add to Home Screen”) on phones, tablets, or desktops, from a browser. Here’s how it worked for me.

Why you might want to make a little personal webapp

Glide is technically a no-code tool aimed at businesses, but you get one user-based published app for free, and you can have more “private” apps if you’re truly keeping it to your household or friend group. Each full-fledged app can have 10 users and up to 25,000 rows, which should probably be enough for most uses.

I do wish there was a “prosumer” kind of account that billed for less than $828 per year. If you want more than one (relatively) small-scale apps, there are alternatives, like Google’s AppSheet (included in most paid Google Workspace accounts). But most are just as business-oriented, and none have struck me as elegant a tool as Glide.

As mentioned, my primary use for a sheet-based app is to make searching, filtering, reading, and editing that sheet far easier. In the case of my takeout app, that meant being able to search anything—a specific restaurant, “tacos,” a quadrant of the District of Columbia. And a sorting option for when I added a restaurant, so I can find the place I added while a friend was recommending it.

Let’s whip up a webapp

Google Sheet showing the columns Restaurant, Category, Address, Order Link, Phone, Quadrant, Notes/Hours, and Added

The spreadsheet behind my “DC Takeout” app.

Credit: Kevin Purdy

The spreadsheet behind my “DC Takeout” app. Credit: Kevin Purdy

Throwing that sheet fresh into Glide, it’s not off to a bad start. The main view of Glide is a usable version of your app, and I can see that I can already type whatever I want into the search bar, and it will search across fields.

First version of takeout app, with a

I could honestly stop here if I wasn’t picky about some of the quirks I’m seeing. The app is showing screens, “Public” and “Users,” and I want to hide them. In the upper-left corner, in Navigation, I’ll click an eye icon to hide the “Users” section. With “Public” selected, I’ll change the Label in the upper-right to “DC Takeout,” and, if I was going to have more than one screen, give it an icon.

The app already provided a “+” button for adding restaurants, just a simple vertical stack of entry boxes, along with a date picker for Date Added. If you prefer something static, toggle off the options in the “Actions” field in the bottom-right.

Searching is pretty robust, but what if you want to browse a broad category or just see stuff that’s nearby? In the “Options” section to the right, you can add in In-App Filter, which creates a familiar arrow-shaped three-bar button to the right of the search bar. I’ve added Quadrant and Category filters. If I want to go further here, it’s on me and my spreadsheet. Open on Mondays? Offers pick-up? Has a bar? The possibilities are endless, even if my weekend spreadsheet time is not.

Phone app showing a filter for quadrant and restaurant catgegory.

Simple filter for my takeout app. I need to get the category to be comma-separate values, not a single pile of descriptors.

Credit: Kevin Purdy

Simple filter for my takeout app. I need to get the category to be comma-separate values, not a single pile of descriptors. Credit: Kevin Purdy

What happens when you click on a restaurant? Right now, you see, essentially, a vertical readout of everything in that spreadsheet row. What could you see? Well, you’ve got an address there, so how about a map?

Click on a restaurant in the fake phone, and on the left you can see “Components,” one of which is our map. Set the address to equal the address column in your sheet, and, in “Options,” set Visibility so that it only shows up when the address field is not empty. In “Actions,” you can set it so that clicking the map opens the phone’s default mapping app, set to the proper address. (If you’re struggling to get the right place to show up, you might want to check out a sample address in Mapbox’s API; it can be a little finicky about how it parses them.)

Map showing on a phone layout, with La Casina, a Romano pizza place, selected with details showing.

Take me to the slightly different pizza!

Credit: Kevin Purdy

Take me to the slightly different pizza! Credit: Kevin Purdy

Glide offers dozens more ways to customize every little thing about your app.

That’s about all I need from a “mix up your takeout and use the right apps” app, one made mostly for me, my spouse, and nearby friends and visitors. Pretty much anything you’d find useful while sitting down at a spreadsheet, you can also make useful through a little phone webapp.

Joyful overkill

I went a good deal further with my “DIYRoot” app. After using a couple meal delivery services, I sussed out the kinds of recipe formulas they were mixing up each week, plus the items or equivalents I had found at nearby stores. Knowing that I could figure out the basic cooking, I made an app that listed as many recipes as I could find, broke them into components, let me add them to an erasable menu plan and shopping list, and even had some pictures.

Image of a phone app, showing

The best version of an entry has an image, ingredients, and recipe. There’s a button to add it to the menu and all the items to a list.

Credit: Kevin Purdy

The best version of an entry has an image, ingredients, and recipe. There’s a button to add it to the menu and all the items to a list. Credit: Kevin Purdy

I didn’t quite master this app (the shopping list is plagued by blank items/rows), and it’s now technically an outdated “Classic” Glide app; maybe I’ll give it another shot. More successful is my most recent effort, “Pantry Items,” which is just a searchable list of spices and sauces, a note about how much I have left of each, and, through a webhook, add anything I see missing to a shopping list on Bring.

I can feel some people reading this article demanding that I just learn Swift or some mobile-friendly JavaScript package and make some real apps, but I steadfastly refuse. I enjoy the messy middle of programming, where I have just enough app, API, and logic knowledge to make something small for my friends and family that’s always accessible on this little computer I carry everywhere, but I have no ambitions to make it “real.” Anyone can add to it through the relatively simple spreadsheet. Heck, I’ll even take feature requests if I’m feeling gracious.

I use Glide, but you might have something else even simpler (and should recommend it as such in the comments). Just be warned that once you start thinking (or overthinking) along these lines, it can be hard to stop, even without the worldwide pandemic.

Photo of Kevin Purdy

Kevin is a senior technology reporter at Ars Technica, covering open-source software, PC gaming, home automation, repairability, e-bikes, and tech history. He has previously worked at Lifehacker, Wirecutter, iFixit, and Carbon Switch.

I keep turning my Google Sheets into phone-friendly webapps, and I can’t stop Read More »