|
|
| DiffEngineX compares two Excel workbooks by highlighting the cells that differ between them with color. A cell-by-cell difference report is also generated in a new workbook. It can be used from its user interface or the command prompt. |
|
| Updated |
Oct 3, 2009 06:14:01 | | Size | 1444 kb | | Licence | Shareware | | Status | Minor Update | | Languages | English | | Tags | 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 | | OS | Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista | | Homepage | florencesoft.com | | Email | support@florencesoft.com | | Author | DiffEngineX LLC |
|
|
 click for full size
|
Description:
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. | Short tags:
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 | System Requirements:
Any version of Microsoft Excel or Office | Change Info:
Option to add hyperlinks to difference report. | |
| | Freeware alternatives DiffEngineX 1.42.1.0 |
|  Free Download DiffEngineX 1.42.1.0 from florencesoft.com |
| Similar smart reviews: | - Excel Workbook Splitter 1.05, Fastest And Easiest Way — Trends in today’s software industry have brought us many monster-like huge «suites». In fact, «multifeatured and universal software suites» take any niche where enough users can be found. It is not that bad, these suites are typically really useful and pleasant to use, but they don’t suit many situations, when you need to do one easy operation but many times…
- PPTMinimizer: A Weight Loss Solution for Office Documents — Despite that PowerPoint presentations are certainly an effective way of communicating a message, the humongous size of PowerPoint files sets noticeable limits on the opportunities for spreading them around. Nevertheless, taking into account the ease of creating presentations with PowerPoint, it’s hard to think of any replacement for it. But why seek for something other? — There…
- PowerShrink, Bring Office Documents to the Real Size — Have you ever wondered how a Word document with just couple of sentences of text could take up to a few hundreds of kilobytes on disk? Or how a PowerPoint presentation of a few slides could take quite a few megabytes of diskspace? Could you imagine exchanging such puffed up files with someone over e-mail or posting them on a website? — Doubtfully…
- Excel Merge Tool: Few Clicks that Save Hours — Merging a report out of a multitude of Excel spreadsheets is quite a challenge. Although data from a couple of spreadsheets could be merged by hand, with the copy/paste command and a bit of patience, merging data from a few dozens or hundreds of tables requires totally different approaches. Excel Merge Tool provides the functionality you need to merge…
- Merge for Windows – quick and easy file comparison, merging and folder synchronization — If you are one of those «lucky ones» who work with hundreds of different files coming from various sources, you must be well aware of the difficulties associated with comparing different versions of the same files on a daily basis. A minor edit in a legal document may have serious implications on your or your client’s business and a single character added…
- Access Folders. Useful File Dialog Utility For Windows. — It is really important to keep all of your folders and sub-folders within an easy reach if you want to get your job done fast and easily, waste no time and efforts on the furious mouse clicking trying to find what you need and not get nervous every time when your search is vain. Access Folders can easily handle all of these problems. Access Folders is a unique tool that can…
- Recover My Files - Data Recovery – a handy utility that will make sure nothing gets lost forever! — If you have ever lost a file that was really important at a time when it was least necessary, you know this frantic feeling very well. Files can be lost accidentally after a power failure, a hardware crash or a human mistake, and there isn’t much we can do about it. However, if you think that a deleted file is something you can’t get back, you are…
- Blitz Document - lightning-fast creation of legal and business documents — If you examine your company’s documents, you will notice that most of them contain a lot of identical information — headers, footers, common fields, text blocks and other elements. Retyping them each time you need a new document takes a lot of time and effort, which means financial losses in a commercial enterprise. If you are willing to optimize your document flow and…
- Blitz Document 3.2.13: just three clicks – the document is ready — The creation of standard documents, such as contracts, license agreements, form letters, patent assignments and even more, is a real nightmare. You must always remember about the formal correctness as well as the conformity with everyday needs; you must also keep in mind thousands of boring details. A little mistake can cost you thousands of dollars, lost of contracts and partners…
| | Find all smart reviews similar on DiffEngineX 1.42.1.0 |
|
