Microsoft

With New User-Defined Functions, Microsoft Excel is Now Turing Complete (visualstudiomagazine.com) 109

Visual Studio Magazine reports: Microsoft, which calls its Excel spreadsheet a programming language, reports that an effort called LAMBDA to make it even more of a programming language is paying off, recently being deemed Turing complete. Being Turing complete is the litmus test of a full-fledged programming language, marking the ability to imitate a Turing machine. According to one definition, that means, "A programming language is Turing complete if you can implement any possible algorithm with it."

And that's exactly what LAMBDA can now do. "You can now, in principle, write any computation in the Excel formula language," said Microsoft researchers in a Jan. 25 blog post.

To get there, researchers at the Calc Intelligence project addressed two shortcomings to the LAMBDA project, which is conducted in coordination with the Excel team and which was first announced early last month. They are:

- The Excel formula language supported only scalar values like numbers, strings and Booleans

- It didn't let users define new functions....

"Moreover, even if it takes greater skill and knowledge to author a lambda, it takes no extra skill to call it," researchers said. "LAMBDA allows skilled authors to extend Excel with application-domain-specific functions that appear seamlessly part of Excel to their colleagues, who simply call them.

"It will be interesting to see how users continue to experiment with and apply not only LAMBDA but also data types and dynamic arrays. We believe these new functional programming features will transform how people make decisions with Excel."

And there is certainly a large audience of both programmers and coders, as Microsoft claims "Excel formulas are written by an order of magnitude more users than all the C, C++, C#, Java, and Python programmers in the world combined."

Towards the end the article points out that right now to actually use the new feature, "you have to be a member of the Insiders: Beta program."
Social Networks

'Recovering' QAnon Members Seek Help from Therapists, Subreddits, and On Telegram (go.com) 400

"More than at any point since the QAnon conspiracy began, there is a tremendous opportunity to pull disaffected followers out of the conspiracy," writes FiveThirtyEight. And while it's just one of three possible scenarios, online posts suggest at least some members are abandoning the group, "but they will need support to really sever their connection."

ABC News reports that some QAnon adherents "are turning to therapy and online support groups to talk about the damage done when beliefs collide with reality," including Ceally Smith, a working single mom in Kansas City: "We as a society need to start teaching our kids to ask: Where is this information coming from? Can I trust it?" she said. "Anyone can cut and paste anything." After a year, Smith wanted out, suffocated by dark prophesies that were taking up more and more of her time, leaving her terrified....

Another ex-believer, Jitarth Jadeja, now moderates a Reddit forum called QAnon Casualties to help others like him, as well as the relatives of people still consumed by the theory. Membership has doubled in recent weeks to more than 119,000 members. Three new moderators had to be added just to keep up. "They are our friends and family," said Jadeja, of Sydney, Australia. "It's not about who is right or who is wrong. I'm here to preach empathy, for the normal people, the good people who got brainwashed by this death cult." His advice to those fleeing QAnon? Get off social media, take deep breaths, and pour that energy and internet time into local volunteering.

Michael Frink is a Mississippi computer engineer who helps administer a QAnon recovery channel on the social media platform Telegram. He said that while mocking the group has never been more popular online, it will only further alienate people. Frink said he never believed in the QAnon theory but sympathizes with those who did. "I think after the inauguration a lot of them realized they've been taken for a ride," he said.

The New York Times tells the story of one Bernie Sanders supporter who entered — and then exited — the QAnon movement: Those who do leave are often filled with shame. Sometimes their addiction was so severe that they have become estranged from family and friends... "We felt we were coming from a place of moral superiority. We were part of a special club." Meanwhile, her family was eating takeout all the time since she had stopped cooking and her stress levels had shot up, causing her blood pressure medication to stop working. Her doctor, worried, doubled her dose...

When she first left QAnon, she felt a lot of shame and guilt. It was also humbling: Ms. Perron, who has a master's degree, had looked down on Scientologists as people who believed crazy things. But there she was...

She agreed to speak for this article to help others who are still in the throes of QAnon.

And CNN reporter Anderson Cooper recently interviewed a recovering QAnon supporter, who tells him there were many theories about Cooper, including one that said he was actually a robot. The embarrassed former QAnon supporter admits that he had once believed that the people behind Q "were actually a group of 5th dimensional, intra-dimensional, extraterrestrial bi-pedal bird aliens called blue avians."

During that interview, he also tells Anderson Cooper, "I apologize for thinking that you ate babies."
The Military

The Problems of Touchscreens In the F-35 Joint Strike Fighter (boingboing.net) 138

Long-time Slashdot reader AmiMoJo quotes a recent blog post from BoingBoing: The F-35 Joint Strike Fighter is the most crammed-with-digital-tech fighter jet in history, the product of a multi-decade, trillion-dollar design process that has been famously messy. But the jet is out there, and pilots are flying it. One big design shift with the F-35 is that it removes many of the small physical switches that crowded older jet cockpits, and replaces them with a big touchscreen...

The folks at the Husk-Kit aviation magazine got an (anonymous) pilot of the F-35 to give their candid assessment of the plane, and it turns out the touchscreen causes some serious problems — for this pilot, anyway, an astounding error rate of 20% while trying to activate a feature.

Power

The US Government's Entire 645,000-Vehicle Fleet Will Go All-Electric (msn.com) 216

Jalopnik reports: The United States government operates a fleet of about 645,000 vehicles, from mail delivery trucks to military vehicles and passenger cars. On Monday, President Joe Biden announced that his administration intends to replace them all with American-made, electric alternatives...

In 2015, the government operated 357,610 gasoline vehicles and 3,896 electric ones; in 2019, those numbers grew to 368,807 and 4,475, respectively. That's excluding the tens of thousands of E-85 ["flex fuel"] and diesel-based vehicles on the road, which, together, comprise nearly a third of the 645,047 total. So, yeah, there's certainly a lot of work to do...

The Washington Post reports: The declaration is a boon to the fledgling electric vehicle industry, which has grown exponentially in the past decade but still represents less than 2 percent of automobiles sold in the United States... "It's important as a symbolic thing," said Timothy Lipman, co-director of the Transportation Sustainability Research Center at the University of California at Berkeley. "But I think it also will have a way of helping to jolt the industry forward at a time when it kind of needed that...."

One of the biggest issues: Just three automakers currently manufacture electric vehicles in the United States, and none of those cars meet Biden's criteria of being produced by union workers from at least 50 percent American-made materials. The closest is the Chevrolet Bolt, assembled at a General Motors plant in Lake Orion, Michigan. But most of that car's parts — including the battery, motor and drive unit — are produced overseas. But that could easily change, said Kristin Dziczek, vice president of industry, labor and economics at the nonprofit Center for Automotive Research.

If Biden succeeds in making every car in the federal fleet electric, he would increase the total number of electric vehicles in the United States by more than 50 percent. "One of the big questions for companies is, 'Is the consumer there?' Well, [the government] is a big consumer," Dziczek said. "Now they know there's some solid demand from the government to support their early launches of new vehicles...." With 640,000 nonelectric vehicles, the federal fleet represents the annual output of about three or four automotive plants, Dziczek said. That's not exactly the million jobs Biden promised in his announcement Monday. But it might be sufficient to convince car manufacturers to change their supply chains or shift their production to U.S. facilities.

Mars

Could This Powerful New Fusion Rocket Thruster Propel Us Beyond Mars? (sky.com) 88

Long-time Slashdot reader schwit1 shared this article from Sky.com: Dr. Fatima Ebrahimi "has invented a new fusion rocket thruster concept which could power humans to Mars and beyond," writes Sky.com

Long-time Slashdot reader schwit1 shared their report: The physicist who works for the U.S. Department of Energy's Princeton Plasma Physics Laboratory designed the rocket which will use magnetic fields to shoot plasma particles — electrically charged gas — into the vacuum of space. According to Newton's second and third laws of motion, the conservation of momentum would mean the rocket was propelled forwards — and at speeds 10 times faster than comparable devices.

While current space-proven plasma propulsion engines use electric fields to propel the particles, the new rocket design would accelerate them using magnetic reconnection... Dr. Ebrahimi's new concept performs much better than existing plasma thrusters in computer simulations — generating exhaust with velocities of hundreds of kilometres per second, 10 times faster than those of other thrusters.

That faster velocity at the beginning of a spacecraft's journey could bring the outer planets within reach of astronauts, the physicist said.... "The next step is building a prototype!"

Privacy

Phone Numbers For 533 Million Facebook Users Were Being Sold On Telegram (theverge.com) 35

Slashdot reader DevNull127 writes: This week a security researcher discovered a bot on Telegram that sold the phone numbers of Facebook users for $20 apiece. "The security researcher who found this vulnerability, Alon Gal, says that the person who runs the bot claims to have the information of 533 million users, which came from a Facebook vulnerability that was patched in 2019," reported the Verge. Motherboard reported the bot was also offering "bulk" pricing, selling 10,000 phone numbers for $5,000.

Telegram told the New York Post that they'd blocked the bot Tuesday morning, while Facebook downplayed the incident, reminding the Post "This is old data." But the Post notes that Facebook already had more than 1.6 billion daily active users in September 2019, and security researcher Alon Gal posted a count of the millions of affected users in each country, finding 32,315,282 in America, 11,522,328 in the United Kingdom, 7,320,478 in Australia, and 3,494,385 in Canada.

But the Verge points out the most ominous message of the breach: that ""the data is still out there on the web" — and that it's already resurfaced, more than once, in the days since it was initially scraped.

IT

Study Finds The Least-Affordable City for Tech Workers: Silicon Valley's San Jose (thestar.com.my) 63

The Bay Area Newsgroup reports: Despite high salaries and world-class amenities, San Jose is the least affordable place for tech workers to buy a home. [Alternate URL here] A new analysis by the American Enterprise Institute found the typical tech worker and his or her partner — with two incomes totaling $200,000 — can afford just 12 percent of the homes for sale in the San Jose metro area.

The picture in San Francisco and the East Bay is nearly as bad, with just 21 percent of homes for sale fitting in the budget of an average tech couple. The high-hurdles to home ownership are fueling a Bay Area exodus that has contributed to the state's sluggish population growth in recent years, researchers say. Study author Ed Pinto, director of the AEI Housing Center, said tech workers can afford their pick of homes in almost every other U.S. city. "But in those places like San Jose, San Francisco and Los Angeles," he said, "that is not the case."

The analysis gives another explanation for the Bay Area exodus. And it's not only workers who are leaving. Tech heavyweights HPE and Oracle have announced moves of their headquarters from Silicon Valley to Texas. Pinto believes the spread of remote work will only accelerate migration from the Bay Area. With new workplace flexibilities, tech workers have a choice between high-cost regions near their offices and low-cost regions with bigger houses and remote work. "Work from home is winning," he said.

United States

Are the US Military's GPS Tests Threatening Airline Safety? (ieee.org) 119

Long-time Slashdot reader cusco quotes a new report from IEEE Spectrum: In August 2018, a passenger aircraft in Idaho, flying in smoky conditions, reportedly suffered GPS interference from military tests and was saved from crashing into a mountain only by the last-minute intervention of an air traffic controller. "Loss of life can happen because air traffic control and a flight crew believe their equipment are working as intended, but are in fact leading them into the side of the mountain," wrote the controller. "Had [we] not noticed, that flight crew and the passengers would be dead...."

There are some 90 reports on NASA's Aviation Safety Reporting System forum detailing GPS interference in the United States over the past eight years, the majority of which were filed in 2019 and 2020. Now IEEE Spectrum has new evidence that GPS disruption to commercial aviation is much more common than even the ASRS database suggests. Previously undisclosed Federal Aviation Administration data for a few months in 2017 and 2018 detail hundreds of aircraft losing GPS reception in the vicinity of military tests. On a single day in March 2018, 21 aircraft reported GPS problems to air traffic controllers near Los Angeles. These included a medevac helicopter, several private planes, and a dozen commercial passenger jets. Some managed to keep flying normally; others required help from air traffic controllers. Five aircraft reported making unexpected turns or navigating off course. In all likelihood, there are many hundreds, possibly thousands, of such incidents each year nationwide, each one a potential accident. The vast majority of this disruption can be traced back to the U.S. military, which now routinely jams GPS signals over wide areas on an almost daily basis somewhere in the country.

The military is jamming GPS signals to develop its own defenses against GPS jamming. Ironically, though, the Pentagon's efforts to safeguard its own troops and systems are putting the lives of civilian pilots, passengers, and crew at risk... Todd E. Humphreys, director of the Radionavigation Laboratory at the University of Texas at Austin, says. "When something works well 99.99 percent of the time, humans don't do well in being vigilant for that 0.01 percent of the time that it doesn't."

Social Networks

'Terms of Service' Agreements Are Unbalanced, Need Reforming, Urges New York Times (nytimes.com) 53

"The same legalese that can ban Donald Trump from Twitter can bar users from joining class-action lawsuits," warns the official Editorial Board of the New York Times, urging "It's time to fix the fine print." [Alternate URL here] [M]ost people have no idea what is signed away when they click "agree" to binding terms of service contracts — again and again on phones, laptops, tablets, watches, e-readers and televisions. Agreeing often means allowing personal data to be resold or waiving the right to sue or join a class-action lawsuit... Because corporations and their lawyers know most consumers don't have the time or wherewithal to study their new terms, which can stretch to 20,000 words — about the length of Shakespeare's "Julius Caesar" — they stuff them with opaque provisions and lengthy legalistic explanations meant to confuse or obfuscate. Understanding a typical company's terms, according to one study, requires 14 years of education, which is beyond the level most Americans attain. A 2012 Carnegie Mellon study found that the average American would have to devote 76 work days just to read over tech companies' policies. That number would probably be much higher today.

At its core, the arrangement is unbalanced, putting the burden on consumers to read through voluminous, nonnegotiable documents, written to benefit corporations in exchange for access to their services. It's hard to imagine, by contrast, being asked to sign a 60-page printed contract before entering a bowling alley or a florist shop... Though courts have held terms of service contracts to be binding, there is generally no legal requirement that companies make them comprehensible. It is understandable, then, that companies may feel emboldened to insert terms that advantage them at their customers' expense.

That includes provisions that most consumers wouldn't knowingly agree to: an inability to delete one's own account, granting companies the right to claim credit for or alter their creative work, letting companies retain content even after a user deletes it, letting them gain access to a user's full browsing history and giving them blanket indemnity. More often than not, there is a clause (including for The New York Times's website) that the terms can be updated at any time without prior notice. Some terms approach the absurd. Food and ride-share companies, like DoorDash and Lyft, ask users to agree that the companies are not delivery or transportation businesses, a sleight of hand designed to give the companies license to treat their contract drivers as employees while also sheltering the companies from liability for whatever may happen on a ride or delivery. Handy, an on-demand housecleaning service, once sought in its terms of service to put customers on the hook for future tax liabilities should their contract workers' job classification be changed to employee...

"This is one of the tools used by corporations to assert themselves over their customers and whittle away their rights," said Nancy Kim, a California Western School of Law professor who studies online contracts. "With their constant updates to terms and conditions, it amounts to a massive bait-and-switch...."

"We have become so beaten down by this that we just accept it," said Woodrow Hartzog, a Northeastern University law professor. "The idea that anyone should be expected to read these terms of service is preposterous — they are written to discourage people from reading them...."

The Board urges the U.S. Congress to consider requiring greater transparency about terms and their changes — as well as simpler explanations. "If a company's online service is open to 13-year-olds, as many are, then the terms of use need to be written so an eighth grader can understand them."
United States

Can Oklahoma Return Its $2 Million Stockpile of Hydroxychloroquine? (readfrontier.org) 206

A nonprofit watchdog news site in Tulsa, Oklahoma reports: The Oklahoma Attorney General's Office has been tasked with attempting to return a $2 million stockpile of a malaria drug once touted by former President Donald Trump as a way to treat the coronavirus. In April, Gov. Kevin Stitt, who ordered the hydroxychloroquine purchase, defended it by saying that while it may not be a useful treatment for the coronavirus, the drug had multiple other uses and "that money will not have gone to waste in any respect."

But nearly a year later the state is trying to offload the drug back to its original supplier, California-based FFF Enterprises, Inc, a private pharmaceutical wholesaler...

It's unclear yet how much of the initial $2 million investment in the hydroxychloroquine the state could recoup.

"While governments in at least 20 other states obtained more than 30 million doses of the drug through donations from the federal reserve or private companies, Oklahoma and Utah bought them from private pharmaceutical companies," notes ABC News: Then-Utah Gov. Gary Herbert, a Republican, initially defended the state's $800,000 purchase of 20,000 packets of hydroxychloroquine compounded with zinc, but later canceled an additional plan to spend $8 million more to buy 200,000 more treatments. The state then managed to secure a refund on the $800,000 no-bid contract it signed with a local pharmacy company that had been promoting the drugs.

The CEO of the pharmacy company has since pleaded guilty to a federal misdemeanor for mislabeling the drug imported from China.

Businesses

How Reddit's Co-Founder, Jim Cramer, and Wall Street Reacted to GameStop's Surge (cnn.com) 180

Friday afternoon CNBC reported that "heightened speculative trading by retail investors" (later referred to as "GameStop mania") had "continued to unnerve the market." The Dow Jones Industrial average lost 620.74 points, or 2%, to 29,982.62, the first time the 30-stock gauge has closed below the 30,000 mark since Dec. 14....

The market also experienced the highest trading volume in years as the mania heated up. On Wednesday, total market volume hit more than 23.7 billion shares, surpassing the level during the height of the financial crisis in 2008. Thursday also saw extremely heavy trading with more than 19 billion shares changing hands.

But Forbes reports that experts "seem in broad agreement that the bull market can rage on." "The market is not broken, but recent events have revealed some cracks," says Commonwealth Financial Network Chief Investment Officer Brad McMillan, who thinks one likely result of the week's frenzy could be that the price of options — which helped fuel some of the outsized meme-stock demand — rise to help curb "price hacking" in the future. McMillan eschews concerns from other experts that the Reddit-fueled price mania could be a sign the market is in the middle of a bubble akin to the dot-com era in the late 1990s, but he says "crackdown" by regulators is likely.
CNN pointed out that the tagline of Reddit's forum is "like 4chan found a Bloomberg terminal illness" — and cited two more reactions:

- "We've seen how social media can be manipulated to expose fault lines in our democracy," said Arthur Levitt, Jr., the former chair of the Securities and Exchange Commission, in an op-ed [titled "Danger Lurks Beneath Reddit Day Traders' GameStop Triumph"]. "Are we certain the same isn't happening in our financial markets? Time to find out."

- "I think it's a real example of what we're already seeing with the way media has been upended," said Reddit co-founder Alexis Ohanian in an Instagram video this week. "All of these big institutions have been challenged, quietly and sometimes loudly, at moments, for the last 10 years with the rise of social media."

Meanwhile, CNBC's stock pundit Jim Cramer advised the traders who'd helped spark the runup to grab their profits now: "Take the home run. Don't go for the grand slam. Take the home run. You've already won. You've won the game. You're done," Cramer said on "Squawk on the Street."

"Please don't lose a lot of money on GameStop," added the "Mad Money" host.

Cramer, who's being treated in the hospital for a pinched nerve, said he called into CNBC in hopes of making sure people recognize the potential downside risk in GameStop and other soaring short squeezed stocks. "Don't let them get hurt. It's our job" to make sure people know they may get burned if the stock price collapses, he said....

Cramer said he was concerned about the stability of the rest of the U.S. equity market the longer the frenzied trading continued...

"I'm not saying that Reddit is good or bad, or that the shorts are good or bad," he said. "I'm just saying that the government has to step in and at least try to address the situation so the rest of the market isn't panicked by four stocks that are heavily shorted."

China

US Intelligence Officials Say Chinese Government Is Collecting Americans' DNA (cbsnews.com) 95

schwit1 shares a report from CBS News: The largest biotech firm in the world wasted no time in offering to build and run COVID testing labs in Washington, contacting its governor right after the first major COVID outbreak in the U.S. occurred there. The Chinese company, the BGI Group, made the same offer to at least five other states, including New York and California, 60 Minutes has learned. This, along with other COVID testing offers by BGI, so worried Bill Evanina, then the country's top counterintelligence officer, that he authorized a rare public warning. "Foreign powers can collect, store and exploit biometric information from COVID tests" declared the notice. Evanina believes the Chinese are trying to collect Americans' DNA to win a race to control the world's biodata. Jon Wertheim speaks to Evanina and others for an investigation into how personal data, particularly biodata, has become a precious commodity and in the wrong hands, poses threats to national security and the economy.
Government

Biden Orders Sweeping Review of Government Science Integrity Policies (sciencemag.org) 162

sciencehabit shares a report from Science Magazine: President Joe Biden today created a task force that will conduct a 120-day review of scientific integrity policies across the U.S. government, including documenting instances in which "improper political interference" interfered with research or led to the suppression or distortion of data. The review is part of a lengthy memorandum from Biden on his plans for "restoring trust" in government by emphasizing scientific integrity and the use of evidence in policymaking. The memo also calls on federal research agencies to name Chief Scientific Officers, and for all agencies to spend 90 days reviewing the role of dozens of panels that provide scientific advice to government. Agencies will also determine if they want to recreate technical advisory panels dismantled under former President Donald Trump.

"Scientific and technological information, data, and evidence are central to the development and iterative improvement of sound policies," states the memo. "Improper political interference in the work of Federal scientists or other scientists who support the work of the Federal Government and in the communication of scientific facts undermines the welfare of the Nation." Today's memo largely restates policies outlined in laws passed by Congress and in memos released by former President Barack Obama in 2009 and by his science adviser, John Holdren, in 2010. In general, those policies attempt to create uniform practices across the federal government for handling and sharing data, using technical evidence, and insulating researchers from political concerns.

Science

Surround Sound From Lightweight Roll-To-Roll Printed Loudspeaker Paper (phys.org) 21

"Researchers from the fields of print media technology, chemistry, physics, acoustics, electrical engineering, and economics from six nations developed a continuous, highly productive, and reliable roll production of loudspeaker webs," reports project manager Georg C. Schmidt. [For those unfamiliar with roll-to-roll processing, it is the process of creating electronic devices on a roll of flexible plastic or metal foil, which, among other things, reduces manufacturing cost.]

This is an improvement upon the 2015 T-Book -- a large-format illustrated book equipped with printed electronics that outputs sound through a speaker invisibly located inside the sheet of paper. "The T-Book was and is a milestone in the development of printed electronics, but development is continuing all the time," says Prof. Dr. Arved C. Hubler, under whose leadership this technology trend has been driven forward for more than 20 years. Phys.Org reports: Not only did they use the roll-to-roll (R2R) printing process for this, but they also developed inline technologies for other process steps, such as the lamination of functional layers. "This allows electronics to be embedded in the paper -- invisibly and protected," says Hubler. In addition, he says, inline polarization of piezoelectric polymer layers has been achieved for the first time and complete inline process monitoring of the printed functional layers is possible. The final project results were published in the renowned journal Advanced Materials.

The potential of loudspeaker paper was extended to other areas of application in the T-Paper project. For example, meter-long loudspeaker installations can now be manufactured in web form or as a circle (T-RING). "In our T-RING prototype, an almost four-meter-long track with 56 individual loudspeakers was connected to form seven segments and shaped into a circle, making a 360-degree surround sound installation possible," says Schmidt. The speaker track, including printed circuitry, weighs just 150 grams and consists of 90 percent conventional paper that can be printed in color on both sides. "This means that low-cost infotainment solutions are now possible in museums, at trade shows and in the advertising industry, for example. In public buildings, for example, very homogeneous sound reinforcement of long stretches such as corridors is possible. But the process technology itself could also become interesting for other areas, such as the production of inline measurement systems for Industry 4.0," says the project manager, looking to the future.

Slashdot Top Deals