The problem: You receive daily, weekly, or monthly forecasts or reports in spreadsheet format, and need to spot the trends in the data.  For example, you might want to trend a weekly sales forecast for the quarter, so you can see if the forecast is improving or worsening as you near the end of the quarter.  Trying to do this across multiple spreadsheets is time-consuming (if you can even find the older spreadsheets).

The solution: Changes N Trends merges the numeric values of each time period side-by-side in a new worksheet, and even graphs it so you immediately see the trends.  Since the new worksheet is in Microsoft® Excel format, you are free to further analyze the data using all of Excel's features.  In addition, because Changes N Trends copies the data of each sheet into its repository, you don't even have to look for the old spreadsheets!

The problem: Each location or group in your organization prepares a budget or report spreadsheet, and you need to combine the data from all those spreadsheets into one sheet.  For example, you might want to combine the inventory spreadsheets of multiple warehouses into a single spreadsheet.  Consolidating data across multiple sheets is difficult and error-prone, because you can't be sure that each item record is in the same row in all spreadsheets.

The solution: Changes N Trends creates spreadsheets with each location’s data side-by-side, so you can easily sum or compare them.  Changes N Trends matches item records based on the values of the "key columns" (these are columns you identify).  Therefore, even if "item ABC" is in row 20 on one spreadsheet, and in row 25 in another, Changes N Trends will place their values side-by-side.

The problem: You receive 2 or more versions of a spreadsheet (for example, a "price list" or a budget), and you find it difficult to locate the differences among the versions.  So, if you're about to discuss those changes with a customer or an associate, you find yourself printing the spreadsheets and taking out a highlighter to mark the changes.

The solution: Changes N Trends shows the data from both versions with columns side- by-side, and highlights the differences.  It even creates a "Changed?" column in which it places a "Y" in each row where the value of the data changed.  Then, you can use Microsoft® Excel's "autofilter" feature to quickly produce a list of only those rows that changed.  This allows you to quickly narrow the discussion to just those changed items.

The problem: You create regular daily, weekly, or monthly spreadsheets containing data like a list of employees and their hours worked for the period, or a list of your sales pipeline and their status.  Each new version should contain mostly the same rows as the previous one, but some rows will be added, some deleted, and others will be updated.  You usually start by copying the old spreadsheet, then making changes to the copy.  However, you find it difficult to spot mistakes such as accidentally deleting a row, failing to add one of the new rows, or mistyping a name or value in the new version you are creating.  You find yourself wasting time comparing the old and new versions to be sure you have made all the right changes.

The solution: Changes and Trends automatically compares your new spreadsheet with the old ones, and flags all the changes, deletions, and additions.  This will make typos and other mistakes stand out so you can correct them before sending out the new spreadsheet.