Study Finds 94% of Business Spreadsheets Have Critical Errors

A recent study reveals that 94% of spreadsheets used in business decision-making contain errors, highlighting significant risks of financial and operational mistakes. Phys.org reports: Errors in spreadsheets can lead to poor decisions, resulting in financial losses, pricing mistakes, and operational problems in fields like health care and nuclear operations. “These mistakes can cause major issues in various sectors,” adds Prof. Pak-Lok Poon, the lead author of the study. Spreadsheets are crucial tools in many fields, such as linear programming and neuroscience. However, with more people creating their own spreadsheets without formal training, the number of faulty spreadsheets has increased. “Many end-users lack proper software development training, leading to more errors,” explains Prof. Poon.

The research team reviewed studies from the past 35.5 years for journal articles and 10.5 years for conference papers, focusing on spreadsheet quality and related techniques across different fields. The study found that most research focuses on testing and fixing spreadsheets after they are created, rather than on early development stages like planning and design. This approach can be more costly and risky. Prof. Poon emphasizes the need for more focus on the early stages of spreadsheet development to prevent errors. The study suggests that adopting a life cycle approach to spreadsheet quality can help reduce errors. Addressing quality from the beginning can help businesses lower risks and improve the reliability of their decision-making tools. The study has been published in the journal Frontiers of Computer Science.

Read more of this story at Slashdot.

Texas Sues General Motors, Alleging Illegal Selling of Driver Data

In a press release today, Texas Attorney General Ken Paxton said he has filed a lawsuit against General Motors, alleging the carmaker illegally collected and sold drivers’ data to insurance companies without their consent or knowledge. CNN reports: In car models from 2015 and later, the Detroit-based car manufacturer allegedly used technology to “collect, record, analyze, and transmit highly detailed driving data about each time a driver used their vehicle,” according to the AG’s statement. General Motors sold this information to several other companies, including to at least two companies for the purpose of generating “Driving Scores” about GM’s customers, the AG alleged. The suit said those two companies then sold these scores to insurance companies.

Insurance companies can use data to see how many times people exceeded a speed limit or obeyed other traffic laws. Some insurance firms ask customers if they want to voluntarily opt-in to such programs, promising lower rates for safer drivers. But the attorney general’s office claimed GM “deceived” its Texan customers by encouraging them to enroll in programs such as OnStar Smart Driver. But by agreeing to join these programs, customers also unknowingly agreed to the collection and sale of their data, the attorney general’s office said. “Despite lengthy and convoluted disclosures, General Motors never informed its customers of its actual conduct — the systematic collection and sale of their highly detailed driving data,” the AG’s office said in a statement. The filing can be read here (PDF).

Read more of this story at Slashdot.

Google’s Pixel 9 Phones Are the First To Get Satellite SOS For Android

Reservoir of Liquid Water Found Deep In Martian Rocks

Slashdot contributors Tablizer, radaos, fjo3, and dbialac highlighted a major discovery by scientists: a reservoir of liquid water hidden deep beneath Mars’ rocky outer crust. The BBC reports: The findings come from a new analysis of data from Nasa’s Mars Insight Lander, which touched down on the planet back in 2018. The lander carried a seismometer, which recorded four years’ of vibrations — Mars quakes — from deep inside the Red Planet. Analyzing those quakes — and exactly how the planet moves — revealed “seismic signals” of liquid water… The Insight probe was only able to record directly from the crust beneath its feet, but the researchers expect that there will be similar reservoirs across the planet. If that is the case, they estimate that there is enough liquid water on Mars to form a layer across the surface that would be more than half a mile deep.

However, they point out, the location of this Martian groundwater is not good news for billionaires with Mars colonization plans who might want to tap into it. “It’s sequestered 10-20km deep in the crust,” explained Prof Manga. “Drilling a hole 10km deep on Mars — even for [Elon] Musk — would be difficult,” he told BBC News.

Read more of this story at Slashdot.

Locking Up Items To Deter Shoplifting Is Pushing Shoppers Online

Longtime Slashdot reader schwit1 shares a report from Axios: Locking up merchandise at drugstores and discount retailers hasn’t curbed retail theft but is driving frustrated consumers to shop online more, retail experts tell Axios. Retail crime is eating into retailers’ profits and high theft rates are also leading to a rise in store closures. Secured cases can cause sales to drop 15% to 25%, Joe Budano, CEO of anti-theft technology company Indyme, previously told Axios. Barricading everything from razors to laundry detergent has largely backfired and broken shopping in America, Bloomberg reports.

Aisles full of locked plexiglass cases are common at many CVS and Walgreens stores where consumers have to wait for an employee to unlock them. Target, Walmart, Dollar General and other retailers have also pulled back on self-checkout to deter shoplifting. “Locking up products worsens the shopping experience, and it makes things inconvenient and difficult,” GlobalData retail analyst Neil Saunders said, adding it pushes shoppers to other retailers or to move purchases online.

Driving the news: Manmohan Mahajan, Walgreens global chief financial officer, said in a June earnings call that the retailer was experiencing “higher levels of shrink.” Amazon CEO Andy Jassy spoke of the “speed and ease” of ordering online versus walking into pharmacies on a call with investors last week. “It’s a pretty tough experience with how much is locked behind cabinets, where you have to press a button to get somebody to come out and open the cabinets for you,” Jassy said. schwit1 adds: “The American-style retail shopping experience was invented in a high-trust environment. As trust erodes, so does the experience.”

Read more of this story at Slashdot.