Productivity is about tools that make spreadsheet developers more efficient.
Efficiency is about doing the right thing, doing it quickly, preventing errors, and detecting errors quickly.
OAK by Operis
“Insert rows and columns even when they intersect merged cells, arrays and data tables; get suggestions for optimizing formulas, change your mind about the choice of names, even after they've been extensively referred to in your spreadsheet; remove names from your formulas, and turn them back to conventional coordinate notation. Reconstruct a formula, to receive automated re-performance of specified calculations; prune a formula; identify the discrepancies that are preventing your attempt at a parallel reconstruction of a spreadsheet calculation; provides systematic version control; gives financial model auditors the means to accommodate late changes to financial models in the minutes before a transaction closes; relevant to spreadsheet inventories...”
Editor’s Note: This is unique professional-quality software, complete with a 295-page user’s manual.
bpmModules and bpmToolbox by BPM Financial Modeling
“bpmToolbox is an add-in to Microsoft Excel that allows users to rapidly and accurately develop any spreadsheet model in accordance with the Best Practice Spreadsheet Modelling Standards. bpmToolbox is the most comprehensive spreadsheet model development software that has ever been developed for Excel.”
“bpmModules is the first ever tool for Microsoft Excel that facilitates the development of "whole-of-company" or "part-of-company" spreadsheet models in minutes, not months.”
Editor’s Note: These are powerful tools with potential to provide a step-change in productivity. We understand they will be re-launched in mid 2010.
Navigator Utilities by Navigator Utilities
“Navigator Utilities will save you heaps of time and frustration in finding your way around and auditing large (and small) Excel workbooks.”
FastExcel by Decision Models
“Do you know why your spreadsheet is slow and big?Are your workbooks suffering from file bloat? Are your worksheets calculating in the wrong sequence? Are your lookups or array formulae running slow? Have you got a formulae blockage? Have you got a memory usage problem? Or a used-range problem? Or a workbook overhead problem? Or a worksheet cross-reference loop problem? How much time are each of these problems taking? Fix it with FastExcel.”
Power Utility Pak by Spreadsheet Page
“Power Utility Pak: PUP is an Excel add-in that adds dozens of new features and functions to Excel.”
ASAP Utilities by A Must in Every Office
“ASAP Utilities is a powerful Excel software add-in that fills the gaps in Excel, and automates frequently used tasks. Since 1999 it has grown to become probably one of the world's most popular add-ins for MS Excel.”
Excel Add-In Collection by Ablebits
“Features include: Removing duplicates; Matching and merging tables; Merging cells; Random numbers; dates, strings; Find and replace; Pivot table formatting; Managing worksheets; Colors and styles.”
“Our Excel add-ins have friendly user interfaces. All addins are easy to install, menu driven and very fast. All Excel plugins come with detailed instructions in help files easily accessible from the opening dialogs.”
Model Builder for Excel by Jabsoft
“With Model Builder for Excel you can perform fast and accurately repetitive and time consuming tasks, such as transposing linked formulas, if formulas, consolidating sheets, swapping data, etc.”
JEM Plus by Kenneth Jarvis, LLC
“JEM Plus is an unbelievable product that will boost productivity and take data integrity to new heights. This is a must-have software for individuals that work with Microsoft Excel. JEM Plus provides professionals and everyday users the power to get the most out of their Microsoft Excel Spreadsheets.”