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.

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.

Google Wallet Widely Rolling Out ‘Everything Else’ Pass Creator In the US

Google is rolling out a new feature for Google Wallet that uses AI to generate a digital version of IDs, tickets, and other passes. “Replacing the old ‘Photo’ option, Everything else lets you ‘Scan a photo of any pass like an event ticket, gym membership, insurance card, and more’ to create a digital version that appears in Google Wallet,” writes 9to5Google’s Abner Li. “The app explains how AI is leveraged to ‘determine what kind of pass you’re adding and to suggest the content of the pass.'” From the report: If you’re adding something sensitive with health or government ID information, it will be classified as private and not get synced to other devices, while authentication is required before opening. However, you can change the private pass classification later. After taking a picture of the pass, Google will extract the information and let you edit common fields, as well as add your own. At this stage, you can change the pass type […]. When finalized, it will appear below your carousel of credit/debit cards. Google will let you access the original “Pass photos” when viewing the digital copy.

Read more of this story at Slashdot.