DiffEngineX is a utility that reports on the differences between the formulae and constants contained in either two whole Excel workbooks or selected worksheets.
Advertisements
Platform
Windows 98, Windows, Windows Me, Windows 2000, Windows XP
DiffEngineX is a utility that reports on the differences between the formulae and constants contained in either two whole Excel workbooks or selected worksheets. As Excel workbooks get modified over time new rows and columns can be inserted in between existing rows and columns. This can confuse a straightforward difference analysis where identical cells are only recognized as such if they have the same row and column numbers in both of the sheets being compared. DiffEngineX can align both similar rows and columns between the worksheets being compared by the insertion of blank rows and columns. As such this problem is avoided. Conventional reports listing each cell difference are difficult to understand given the lack of context. This is why there is an option to automatically create copies of the workbooks being compared and then modify them such that the differences are highlighted in color. Different colors are used to flag deletions, modifications and additions. The options available allow users a choice between comparing formulae directly or by their calculated values. For example if two cells containing =2*6 and =3*4 are compared directly they will reported as different. If they are compared by their calculated values they will be reported as identical. It is common in workbooks modeling certain financial scenarios to have blocks of tens to hundreds of equivalent formulae that only differ from their neighbors in terms of their inputs. The absolute coordinates of these inputs change from one cell to the next, but the relative coordinates do not. If a later version of such a workbook is compared to an earlier one, hundreds of changes can potentially be reported. This makes a difference report tedious to inspect. DiffEngineX has a powerful feature to group equivalent changes made to contiguous cells into just one reported change made to a range of cells. It can be used from its user interface or the command prompt.
Synkronizer for Excel 8.0
Synkronizer compares, updates and synchronizes Excel spreadsheets. Synkronizer compares any two Excel worksheets. Simply enter the file names in the clear interface, then check off which sheets to compare. You can compare two sheets in the same workbook or two sheets in entirely different files. You'll get a quick, cell-by-cell ...
ConsoXL 1.2
Multiple financial Excel workbooks and sheets consolidation with a few clicks. Consolidate most Excel financial forms without selecting a cell! Have more time for data analysis. Look at the total and immediately see the breakdown of each cell without moving between sheets and save your time again.
ConsoXL consolidates multiple ...
Workbook TOC 1.1
Excel Workbook table of contents generator. Workbook TOC is a table of contents generator for a Microsoft Excel workbook. This Excel Add-on will create a new worksheet listing the names of the worksheets in the workbook. The worksheet names are also hyperlinked to the worksheet to allow quick navigation ...
Merge Workbooks 3.12
Quickly and easily combine Excel workbooks. Merge Workbooks is an Excel tool for combining multiple Excel workbooks into one workbook. Simply select the workbooks you want to merge and Merge Workbooks will combine those workbooks into one workbook. ...
Excel Import Multiple Excel Files Software 7.0
Import one or many Excel files into a blank MS Excel file. Specify local Excel files and either insert them all into one sheet or individual sheets per file. Excel 2000 or higher required. ...
Excel Extract Comments Software 7.0
Get the comments from multiple Excel files. Save the results to a text file or put them in a blank Excel workbook. ...
Excel Remove (Delete) Blank Rows, Columns or Cells Software 7.0
Eliminate all blank rows and columns from your Excel worksheets. One option removes blank rows from the entire worksheet, the other option removes blank columns from the entire worksheet. ...
Excel Copy Sheets Multiple Times Software 7.0
Quickly make many duplicate copies of one Excel worksheet. Browse to your Excel file, select the sheet you want to copy, and specify the number of copies you would like to make. ...
