EQUS launches to prevent spreadsheet mistakes and misinterpretations
According to a recent report from Salesforce, the customer relationship management (CRM) specialists, some 88% of spreadsheets contain errors. These are costing organisations billions of dollars due to miscalculations and misinterpretations of data.
So, to help combat these mistakes and ensure that spreadsheets provide the value they’re intended to provide, Sheffield Hallam University has developed visualization plug-in software called ‘Ensuring the Quality and Usability of Spreadsheets’ (EQUS).
EQUS, which aims to enhance the accessibility and understanding of almost all spreadsheet formulae and the data with which they work, is being distributed by VeryViz - a partnership between Sheffield Hallam University and the online learning and training consultancy, Learning Light.
“EQUS enables improved user understanding as well as greater formula integrity of calculations made in spreadsheets,” said Dr Chris Roast, of Sheffield Hallam University and EQUS’s technical lead. “We call it a ‘Formulae Visualizer’ because EQUS dynamically illustrates what’s happening with spreadsheet formulae.”
Robustly tested by hundreds of users, EQUS works with equations of any size and complexity, along with referenced cells between different worksheets. Moreover, there’s no specified limit on the size of the equations that EQUS can visualise.
Contained in a downloadable file of less than 1Mb, EQUS explains visually, via an on-screen diagram, how a formula in a spreadsheet is calculated. It presents a calculation’s result, along with all intermediate results, allowing anyone to check the logic behind each formula on a spreadsheet and to see if the correct operations are being used.
According to Learning Light director, David Patterson, “EQUS is a useful spreadsheet add-in, currently available for Microsoft Excel, which helps to ensure correct use of formulae by flagging potential issues and errors. Moreover, it shows this visually – making it easier to solve any errors that might occur.”
Marc Zao-Sanders, CEO of adult education specialists, Filtered, commented, “Spreadsheeting errors are a problem and can cost companies huge sums - as well as present smaller issues that frustrate the world's 1billion or more spreadsheet users every single day.
“For beginners, EQUS explains how formulae are put together and work. For advanced users, it can help visualise and debug complex formulae.
“In particular, EQUS could benefit teachers and trainers to demonstrate what spreadsheets can do,” he added.
“As someone who’s worked extensively with Excel, EQUS is the sort of tool you wish had been developed a long time ago,” said Andy Cottier, of Day One Technologies. “Faults and anomalies in Excel can sap productivity and confidence in business data - so EQUS should save users and consumers of Excel masses of time and money.
“And, in schools, Excel is a low-cost solution for modelling and learning subjects such as Maths and Physics. EQUS can help with that experience – particularly in helping students understand the concepts in a visual, accessible way.”
Initially, EQUS is expected to prove popular in three main areas among the estimated 750m spreadsheet users throughout the world:
• Educators using spreadsheets in Science, Technology, Engineering and Mathematics (STEM) and other numeracy-related subjects
• Trainers helping develop workforce numeracy skills
• Professional users of spreadsheets in businesses of any size
David Patterson commented, “VeryViz intends to create further useful tools for managing data and ensuring its integrity. We’ll also be signposting more tools and useful tips for using data, analytics and spreadsheets.
“We welcome opportunities to collaborate on projects as well as suggestions for additions and improvements to our website. So please contact us to start a discussion,” he added.
Learning Light, VeryViz and Sheffield Hallam University have collaborated on a further new product, called SQLView. This project uses a similar approach to that of the EQUS project but in respect of the common database language, SQL.
For a visual explanation of EQUS, visit: https://www.veryvizsolutions.com/equs/ or https://www.youtube.com/watch?v=SKoUWIHDcAw
About VeryViz Ltd
VeryViz is a partnership between Sheffield Hallam University in the UK and online learning and training consultancy, Learning Light Ltd. It aims to create and signpost leading tools and advice to help improve the quality and integrity of data used for education, business and personal productivity. In particular, its goal is to improve the integrity of the data used by companies and organisations of all sizes to make key decisions about their investments, hiring, business processes and much more.
C/O Learning Light Ltd, Sheffield Technology Parks, Suite 21, Cooper Buildings, Arundel Street, Sheffield, South Yorkshire S1 2NS, UK
Tel: +44 (0)114 307 2358; Website: https://www.veryvizsolutions.com/
Contact: David Patterson, Very Viz Ltd, +44 (0)114 307 2358; firstname.lastname@example.org
PR contact: Bob Little, Bob Little Press & PR, +44 (0)1727 860405, email@example.com
This release was published on openPR.
Permanent link to this press release:
Please set a link in the press area of your homepage to this press release on openPR. openPR disclaims liability for any content contained in this release.
You can edit or delete your press release EQUS launches to prevent spreadsheet mistakes and misinterpretations here
News-ID: 1525072 • Views: 352
More Releases for EQUS
Global Pre-vacuum Autoclave market: New Prospects to Emerge by 2028 | Tex Year(E …
" The Pre-vacuum Autoclave global market is thoroughly researched in this report, noting important aspects like market competition, global and regional growth, market segmentation and market structure. The report author analysts have estimated the size of the global market in terms of value and volume using the latest research tools and techniques. The report also includes estimates for market share, revenue, production, consumption, gross profit margin, CAGR, and other key factors.
Global Class B Table Autoclave market: Reliable Market Size and Share Forecasts …
" The Class B Table Autoclave global market is thoroughly researched in this report, noting important aspects like market competition, global and regional growth, market segmentation and market structure. The report author analysts have estimated the size of the global market in terms of value and volume using the latest research tools and techniques. The report also includes estimates for market share, revenue, production, consumption, gross profit margin, CAGR, and other
Global Artificial Quartz Kitchen Countertops Market Report Top-Companies Offerin …
LOS ANGELES, United States: The latest report up for sale by QY Research demonstrates that the Global Artificial Quartz Kitchen Countertops Market is likely to garner a great pace in the coming years. Analysts have scrutinized the market drivers, confinements, risks, and openings present in the overall market. The Artificial Quartz Kitchen Countertops report shows course the market is expected to take in the coming years along with its estimations.
Quartz Market 2021 Is Thriving Across the Globe by Key Segments, Growth Size and …
Infinity Business Insights has recently printed an informed analysis of the Quartz market in order to come up with more information about the industry. The experts provide a detailed analysis of the qualitative and quantitative methodologies. The Quartz industry report deals with the industry trends and development. The report also points out the market dynamics, applications, types, and important components of the market. The latest figures from the worldwide Quartz
Global Vacuum Autoclaves Industry Professional Market Overview Report by 2020-20 …
Market Overview The Vacuum Autoclaves market report provides a detailed analysis of global market size, regional and country-level market size, segmentation market growth, market share, competitive Landscape, sales analysis, impact of domestic and global market players, value chain optimization, trade regulations, recent developments, opportunities analysis, strategic market growth analysis, product launches, area marketplace expanding, and technological innovations. The global Vacuum Autoclaves market size is expected to gain market growth in the forecast period
Global Semi-Automatic Autoclave Market Status and Outlook (2015-2025)
Market Overview The Semi-Automatic Autoclave market report provides a detailed analysis of global market size, regional and country-level market size, segmentation market growth, market share, competitive Landscape, sales analysis, impact of domestic and global market players, value chain optimization, trade regulations, recent developments, opportunities analysis, strategic market growth analysis, product launches, area marketplace expanding, and technological innovations. The global Semi-Automatic Autoclave market size is expected to gain market growth in the forecast period of 2020 to