There are three types of medical document management solutions namely, Paper Charts, Spreadsheet files and OpenMRS EMR applications. The paper and spreadsheet files have certain limitations when it comes to their performance and availability of storage space. Spreadsheets, created in Excel with a VBA backbone, for instance may lose data, and can only keep not more than 100 patient records efficiently. There are citations from various users implying that Microsoft Office Excel 2003 can perform a better job when it comes to analysis using the Pivot Tables than a spreadsheet which merges several spreadsheets. Thus, complex data takes a lot of time to analyze. Although, a paper chart does not limit the number of patient records it can hold and have organized data, it does not have the flexibility to manage complex disease treatment like human immunodeficiency virus (HIV) and Tuberculosis (TB) properly.
If you are working with spreadsheets, you might encounter the time when you need to compare spreadsheet with another one. This is pretty helpful especially for those who need to get the differences and the similarities between two or more spreadsheets. This is a method for analyzing if the data entered are correct. Plus, this is also useful for those who are having problems in detecting the changes that have been made onto their spreadsheet files. In order for you to compare two spreadsheets, you will need to take advantage of the built in tools for comparing spreadsheets in the application that you are using. Spreadsheets are computer applications that provide you with a virtual way of creating accounting worksheets. They are often used for calculating numbers and organizing data. You can also use them for charting and displaying the graphical interpretation of data. There are many electronic spreadsheets today so you can use them to start the comparison process.