Archive

Posts Tagged ‘compare xls’

Used a automated test tool together with Compare Suite

Hi – just to let you know how we used Compare Suite to save many man days of effort. We have recently upgraded a very big system, which produces many hundreds of .csv, .xls, .txt files. We used a automated test tool (from Mercury Interactive) together with Compare Suite, and was able to run massive file checks over night, checking any differences manually the following day. This clearly saved us weeks of effort and not once did we get a “spurious” comparison. Very good product which I can highly recommend.

Rob Park, Testing
Consultant, Leading UK Utility

  • Share/Bookmark

admin Testimonials

Online store content managers can use Compare Suite to update pricelists

Modern business can hardly function without the Internet and IT support. Moreover, some businesses are entirely run in the World Wide Web. Managers of web sites and content managers of online stores have to process huge volumes of information. At that, this information is important as any mistakes may result in loss of money or customers.

If you have to process numerous files, financial reports, pricelists and other important documents you do not have the right to make mistakes. We should always take into account human factor. We are people are we cannot be perfect.

Content managers of online stores have to regularly update prices and pricelists. Sometimes new or amended pricelists are sent from head offices of the company. Thus, in order to update current pricelists it is necessary to compare two documents and find differences between them.

In order to save own time and make sure that all necessary amendments are introduced you need to use Compare Suite from AKS-LABS. The newest version of this program has advanced features to compare Excel documents. As known, Excel is the most widely used program to store financial data. Most pricelists are made out in xls format, as it is easy to perform calculations there and edit files.

Update pricelists through comparison of Excel files

Update pricelists through comparison of Excel files

Use Compare Suite to contrast Excel spreadsheets

Use Compare Suite to contrast Excel spreadsheets

So, let’s imagine that you are a content manager of an online store. You have just received updated pricelists but you are not sure if the existing positions are represented there. Consequently, you have to compare two Excel spreadsheets.

With Compare Suite this procedure is extremely convenient and effective. The updated Compare Suite version has additional features which specialize in comparison of xls files. With Compare Suite you will be able to see difference sin prices and product positions. Moreover, this difference will be calculated in percents and figures.

Having contrasted the two files you will see similarities and differences and thus, will be able to make further decisions. Compare Suite has 3 comparison modes: char by char, word by word and comparison by keyword. If price lists look pretty much alike you should definitely use the first two methods.

A content manager will contrast pricelists within several minutes. Moreover, it is possible to merge files, i.e. apply changes. As a result you will have updated pricelist that contains both old and new positions.

By uploading updated pricelist to the site you inform your customers on new offers and prices for your products and/or services.

  • Share/Bookmark

compare_file Articles

New Compare Suite version is perfect for comparison of Excel files

It looks like everyone has faced the problem of file comparison. Those who think that this process is quite easy are mistaken or simple never deal with huge volumes of information facing deadlines at the same time.  As known, every word matters in the modern world of business which is run at a very high speed these days. Development of the Internet changed our lives, including business.

It is impossible to compare huge files without proper file compare solutions. The market is full of such programs. Some of them are too expensive while others require special knowledge from users. Compare Suite from AKS-LABS has successfully combined simplicity, convenience and efficiency.

Recently, developers from AKS-LABS have released the latest version of this program which has a number of advanced features used for comparison of Excel files. Everybody knows how popular xls files are. They are used to make accounting reports, pricelists, advertising offers etc.

Use new Compare Suite version to contrast Excel files

Use new Compare Suite version to contrast Excel files

Compare Excel files with an effective file compare solution

Compare Excel files with an effective file compare solution

Thus, Compare Suite is now even more efficient in comparing Excel files. What are these features? They are not numerous but all of them are certainly helpful. So, read on!

  1. New version of Compare Suite can show difference in numbers. What does it mean? Well, let’s take an example. For instance, you have two xls files. Cell A1 in both file stands for expenses. In file A this value is 10 while in file B it is 20. Compare Suite will not only mark figures with color but also show actual difference which makes 10 in our example, or 100%. Compare Suite will also state if the value has decreased or increased.
  2. Compare Suite can show difference in dates. Thus, if you have got a date Jan 6, 2010 in your Excel file, Compare Suite will convert it to 6/01/2010 and compare it to the relevant date in the other file. If they are different Compare Suite will express this difference either in seconds, minutes, hours, days, weeks, months or years.
  3. Compare Suite has become even a more effective tool to compare excel workbook. Special features make it possible to adjust column width right in the program, as well as cut long columns.
  4. It is possible to compare certain columns. However in such a case you have to compare one excel sheet from each file.
  5. It is possible to compare csv file which are widely used to structure information.
  6. Changes and differences will be displayed in the final comparison report.
  • Share/Bookmark

compare_file Articles

Need to compare csv file? Use Compare Suite!

Comparing files is an easy and at the same time difficult task. It can be easy if you have to compare two small files with almost identical contents. In such a case you can perform comparison by yourself. But what if you have to compare huge files containing very important information, including figures/prices? What if every mistake or even minor inattentiveness may cost you a career? What if you have 5 minutes to contrast two versions of a pricelist?

In such a case you certainly need a powerful file compare solution. We would like to draw your attention to Compare Suite. This program is developed by AKS-LABS company which has recently released new program version.

Compare Suite is not just a file compare solution. The program offers a number of additional features which make it universal software capable of solving multiple tasks.

It is well known that office employees and other professional often use Excel in their work. MS Excel is a very useful program that helps millions of people store and process figures. Thus, xls files are used to make pricelists, accounting reports, sales reports etc. the program is very easy to use which explains its popularity.

Compare csv file to integrate changes

Compare csv file to integrate changes

Compare Suite is an ultimate tool to compare csv file

Compare Suite is an ultimate tool to compare csv file

New version of Compare Suite has additional feature to compare Excel docs, including csv files. Comma separated values are used to store and structure information. This file type can be formalized in Excel. CSV files are often converter into xml format as both file types have similar functions – structure information.

In order to compare csv file you need to open it Compare Suite and contrast against its draft or newer version. First of all, it needs mentioning that Compare Suite can show differences between figures. If earlier this difference was market by color, now Compare Suite show it in numerical form or percentagewise. This is very convenient if your ultimate goal is, for example, to establish price difference of certain products. Besides, these differences may be shown in the final comparison report.

Traditionally, Compare Suite contrasts files char by char, word by word and by key word. You can use Compare Suite as a text editor and integrate change in the Excel spreadsheet. All you have to do is to use Apply change function available in the right mouse click menu.

Thus, as you can see upgraded Compare Suite is a perfect tool for comparison of Excel files.

  • Share/Bookmark

compare_file Articles

Compare Suite will effectively compare excel cells

Have you ever tried to manually compare files? It is pretty difficult, isn’t it? We are not perfect creatures and can miss certain words and make mistakes. When we are dealing with huge amounts of information then use of file search systems is highly recommended.

But have you ever tried to compare figures? This is even more difficult task. If words can be remembered and associated with something, figures are boring. After one hour of such comparison you won’t be able to differentiate 0 from 9.

You may ask: “Who needs to compare figures?” The answer is – millions of people! These are people who work with figures – accountants, economists, financers, sales managers and even secretaries. Figures (i.e. prices and dates) are always changing. It happens every second and the market conditions change as well as global economy.

As a rule pricelists and accounting reports are made in MS Excel. This is a very popular program that makes it possible to save data and process it. However, comparison of Excel files can be very difficult, especially if the file consists of several sheets. What if you have to compare figures expressed in millions of dollars? You do not have the right to make any mistakes!

Compare excel cells to find differences between the docs

Compare excel cells to find differences between the docs

Use FSA to compare excel cells

Use FSA compare excel cells

With Compare Suite you can feel 100% sure that you will track all differences between important financial documents. Compare Suite does not only contrast and compare excel cells but also provide you with the information on the differences between figures. For instance if cell A1 has value of 5 in one doc and value of 9 in the other, Compare Suite will calculate the difference (which will be 4 in our case) and also express it percentagewise. All you have to do is to point at the figure with mouse cursor.

The same applies to date and time. If you have date or time indication, Compare Suite show differences between them expressed in seconds, minutes, hours, days, weeks, months and years. This is very convenient if you compare two draft projects with start up dates.

You can compare particular columns if you select one sheet from each file. It is also possible to compare several sheets of the one and the same file.

If you wish, differences between figures and dates will be displayed in the comparison report. In such a case this will be a very informative document which you can use in your further work.

  • Share/Bookmark

compare_file Articles

Choose updated Compare Suite to contrast and compare excel workbook

File comparison is becoming increasingly difficult. There are several reasons explaining it. One of them is global growth of information and rapid development of business which in its turn was caused by the Internet and IT revolution. There is much information that needs to be processed. Why do people need to compare files? It is very simple. Information never stays the same. Business information changes very fast together with the market situation and economy in general. Thus, new contract and agreements appear. Managers change pricelists and advertising offers.

As a rule, new documents are based on the old versions. Thus, in order to find possible mistakes one needs to compare files. Of course, you can do it by yourself if you have to compare 4 sentences. But what if these are 10 huge documents containing very important and sensitive information? In such a case you will not survive without a reliable file compare solution, for instance, like Compare Suite from AKS-LABS.

It is worth saying that developers from AKS-LABS never stop working on their products, offering new software versions. Thus, new version of Compare Suite has advanced features in comparing Excel files.

We all know how popular Excel spreadsheets are. XLS files are used by all people working with number. Excel files can both store information and process it through mathematical operations. Most pricelists and catalogues of products are made in Excel.

Imagine, that you have received updated pricelist version with new products and amended prices. In order to track differences you have to compare two files.

Compare excel workbook with Compare Suite

Compare excel workbook with Compare Suite

Use Compare Suite to contrast and compare excel workbook

Use Compare Suite to contrast and compare excel workbook

Updated version of Compare Suite has a number of new features that will make comparison of Excel files effective and very convenient. You will not only find all differences and amendments but also receive additional information on the files.

Compare Suite can show differences in figures and dates. If you point on the figure, the program will show difference between original figure and amended one in numerical way and percentagewise.

Differences in dates and time are shown in seconds, minutes, hours, days, months and years. This is very convenient to analyze changes (for instance you will get to know price hikes or changes in product delivery terms). Moreover, these changes can be displayed in the comparison report which thus becomes extremely informative.

Use of Compare Suite to contrast Excel files is easy, fast and at the same time effective.

  • Share/Bookmark

compare_file Articles

Compare Suite can contrast Excel files and show difference in dates

IT revolution has truly changed our lives. But it is business that has undergone most changes. Computers and the Internet made business work faster and in a more efficient way. Besides, the Internet has contributed to internationalization and globalization of business.

But IT revolution as any phenomenon has its advantages and drawbacks. Sure, there are more pros than cons in using computers but modern technologies bring modern challenges. Volumes of information transmitted through the internet and downloaded to personal computers keep growing. What does it mean in practice? It means that your computers contain more files now than 5 years ago. This trend seems unstoppable.

One of the major problems is file compare. Documents and files are changing all the time. Contrasts and agreements sometimes have a dozen of versions. Pricelists are changed every day as the economy and the market situation changes. Thus, use of automated file compare systems is strongly recommended for those professionals working with huge amounts of info.

If you pay your attention to updated version of Compare Suite you will soon understand that you made the right choice. In addition to traditional Compare Suite features, updated program has advanced function in comparing Excel files.

show difference in dates

CS will show difference in dates

Compare Suite is the best tool show difference in dates

Compare Suite is the best tool show difference in dates

We all know that Excel docs are very popular among office employees, accountants, financers, economists and even webmasters who need to update online pricelists. Excel does not only save information but also processes it using mathematical functions and operations.

What are benefits in using Compare Suite to contrast Excel spreadsheets? Read on.

  1. It is possible to compare certain sheets of Excel files, as well as to compare sheets within one file.
  2. Compare Suite correctly opens Excel files preserving width of columns which although can be adjusted (for instance you can cut long columns).
  3. One of the key advantages of Compare Suite is ability to show difference in dates. What does it mean? Imagine you have got dates stated in a certain column. The other document contains amended dates (let is be start of the project). If you point on the amended date with a mouse cursor you will see difference in date or time expressed in seconds, minutes, hours, days, months and years.
  4. It is possible to compare certain columns in Compare Suite (however you have to select only one column from each document).
  5. Compare Suite also shows differences in numbers (in figures and percents). These differences may be included to the final comparison report.
  • Share/Bookmark

compare_file Articles