Versions:
Sheet Stats 1.1 by Japplis is a lightweight diagnostic utility designed to quantify the internal complexity of any Microsoft Excel workbook. After pointing the program at an .xlsx or .xls file, it instantly parses all worksheets, formulas, pivot tables, data connections, charts, conditional-formatting rules, named ranges, VBA modules, and embedded objects. The resulting report presents a detailed breakdown—number of unique formulas, cell references, nested functions, external links, array formulas, volatile functions, and more—together with a single composite “complexity score” that allows teams to benchmark files against one another. Typical use cases include auditors who need to flag overly intricate spreadsheets that pose operational risk, consultants who clean up inherited client files, and finance departments that run internal competitions to encourage simpler, more maintainable models. Because the tool is read-only, it can be run safely on production workbooks without altering content or triggering macro warnings. Version 1.1, the first public release, ships as a stand-alone JAR that works on any Windows, macOS, or Linux system equipped with Java 8 or later; no Excel installation is required, making it suitable for server-side batch auditing as well. The interface is a single-window wizard that exports reports to CSV or HTML for sharing with stakeholders who do not have the utility installed. Categorized under Office Tools → Spreadsheet Add-ons & Analytics, Sheet Stats complements traditional formula auditors by providing a quantified, gamified view of spreadsheet health. The software is available for free on get.nero.com, with downloads provided via trusted Windows package sources (e.g. winget), always delivering the latest version, and supporting batch installation of multiple applications.
Tags: