← Back to listings

Spreadsheet Detective

Published by Southern Cross Software Queensland Pty Ltd

Excel formula-audit add-in from Southern Cross Software Queensland Pty Ltd (ABN 41 079 368 200; Queensland; author Anthony Berglas; info@spreadsheetdetective.com) that highlights formula errors and assists model risk management inside Microsoft Excel. The homepage titles The Spreadsheet Detective Excel Audit tool and meta-describes The Spreadsheet Detective formula audit add-in highlights formula errors and so assists model risk management. It can also efficiently compare spreadsheets, trace dependentcy relationships, manage scenarios, VBA and much more. Keywords include Excel Add-In. Homepage: SPREADSHEETS are notoriously difficult to validate. Undetected errors have caused large financial losses and expensive litigation. The Spreadsheet Detective provides many features that can reduce errors and aid in model risk management. Microsoft Excel Spreadsheet Audit Features used by thousands of spreadsheet professionals: comprehensive workbook reports, data flow analysis and error detection; show which cells have formulas and how they have been copied throughout a model; English AutoNames for cryptic A1 references; a non-modal window describing the current cell and formula; evaluate intermediate values and cell references of complex formulas; follow complex precedent and dependent relationships; compare different spreadsheets with both a succinct report and graphical annotations; manage Scenarios and perform Monte Carlo simulations; encrypt sensitive workbooks without the risk of losing the password (Master Key Encryption); analyze sensitivity relationships; assist with named ranges. Formula Dialog pretty-prints the active formula with hyperlinked cell references, evaluated hover values, unused IF branches grayed out, and green English AutoNames. Distinct and copied formulas are shaded on the actual model; a condensed map report uses symbols and comments. Audit Process Control can mark formulas verified, questionable, or erroneous. Workbook Discovery finds spreadsheet models and what other models link to them. The Spreadsheet Detective has been revealing modeling errors since 1997. Excel versions are supported from Office 365 down to Excel 2010. Site-license logos on the homepage include BAE Systems, British Business Bank, BDO, Chevron, Deloitte, EY, Grant Thornton, KPMG, Michael Kors, Pitcher, QTC, and S&P Global. Price List page (no title tag) Ordering Information Price List: The Spreadsheet Detective is normally purchased on an annual basis, with a substantial discount for periods of three years or longer paid in advance; continually enhanced with no additional charge to receive upgrades; price includes full support during the license period; currencies AUD EUR GBP NZD USD; prices per user and do not include GST if ordered in Australia; substantial discounts for sites of more than 10 users. License Type 1 Year / 3 Years (Paid In advance): Spreadsheet Auditor AU$225 / AU$450 (AU$150 per year) for people whose main use of the tool is to audit other people's models whose authors do not have a Spreadsheet Detective license — only this version includes the Ticks and Crosses / Question report; Quantitative Analyst AU$125 / AU$250 (AU$83 per year) for use by analysts to verify models that are substantially built by the licensed user; Small Business License AU$70 / AU$140 (AU$47 per year) for private companies with less than 10 employees in total that do not provide financial advice or primarily engage in financial activities; Charities Free. Order Form title OrderForm: fill in this form to order the Spreadsheet Detective; Southern Cross Software Queensland; confirmation and license within a few days. Terms and Conditions: licensed on an annual basis; when the license period expires the user is no longer permitted to use the software; a license may only be used by the number of individual users that are named; users may install the software on multiple machines for their own use, the license is per user, not per device; Audit Licenses review models produced by other people and include the Ticks and Crosses report; Analyst Licenses may only be used by people reviewing models they substantially built themselves; within 30 days of delivery the customer may cancel and request a full refund if technical limitations prevent effective use; if a permanent license is purchased, support is expected at 15% of the original license per year and the first year's support is compulsory. Free Download page title Free SDetective Download: free, full featured download of the Spreadsheet Detective which you may evaluate for 60 days (or use for 12 months with an appropriate coupon). Video Tutorials title Video Tutorials: Overview — The Case of the Invisible Spreadsheet Errors at https://www.spreadsheetdetective.com/video/Overview-2020-head-30A.mp4 (HTTP 200, video/mp4, 82,256,172 bytes) and Detailed Tutorial https://www.spreadsheetdetective.com/video/spreadsheet-detective-v18-30.mp4 (HTTP 200, video/mp4, 18,722,950 bytes); Help workbook included in the download; Advance options for installation are provided in the Technical Supplement which is also provided with the download. Ribbon screenshot https://www.spreadsheetdetective.com/Tumbnails/Ribbon.png HTTP 200 image/png 24,047 bytes. Bloor Research extract (Philip Howard, June 2007) titles Spreadsheet Detective and says Southern Cross Software's Spreadsheet Detective is a suite of tools that addresses the auditor's market, with the most extensive range of auditing tools that we have seen from any vendor in this class. Homepage warning: The Spreadsheet Detective should not be confused with the Detective feature in Libre/Open Office Calc which just provides similar features to Excel's in built audit arrows. This listing is Spreadsheet Detective — not the Compliance Detective EUCA/MRM scanner as a separate catalog row, and not Operis Analysis Kit (OAK).