DiffEngineX  Total Downloads: | Hits:  | Rating:

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.

Company: Florencesoft Title: DiffEngineX License: Shareware Price: 40 Version: 1 Program Size: 23136 KB Operating System: Win98,WinME,Windows2000,WinXP,Windows2003 Date Released:   22-08-2005 Program Homepage  Download DiffEngineX

DiffEngineX Similar Software:

excel, compare, comparison, diff, difference, differences, workbook, workbooks, worksheet, worksheets, sheet, sheets, spreadsheet, spreadsheets, file, files, document, documents, two, 2, florencesoft, diffenginex, row, column, alignment, office, microsoft, utility, tool, report

Bar Code 2 of 5 Interleaved - Print barcode 2/5 interleaved from Windows with TrueType or PostScript fonts. Standard and human readable versions, bearer bars, 5 different aspect ratios. VBA functions for Excel / Access, Word label templates... Excel Split Cells, Columns & Data Software - Divide the contents of a single cell into multiple cells. Splits can be done by spaces, commas, or any other distinguishing character. Splits can be done quickly on a group of cells that you select. This works ... BootIt Next Generation - An excellent partition and multi boot manager with a powerful and simple to use set of tools to quickly partition, image, or multi boot your computer. It combines the features of several standalone products co... 4TOPS Excel Import for MS Access 2000 - The easy way to import excel to access.. PokerAce - Addictive, video poker game for your PC. Excellent graphics and unique features.. Import Wizard - Import any text file into Access, Excel or ODBC databases. ESQuotes - Powerful Excel add-on for quoting stocks & mutual funds direct from Internet.. Euromat - Office and currency calculator. Papertape, tax, discount, excel conv. macros.... AAA Easy Grid Control ActiveX - editable grid control activex with print preview, spreadsheet, chart, excel. Topee CD Ripper - CD to MP3, WAV, WMA, OGG with excellent output quality and high ripping speed.