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.
Also, just imagine the amount of paper you would be using all year round just to store all of those data and numbers. You can do Mother Nature a good turn by switching to using electronic spreadsheets instead of manual options. And if it is not the ease of use or the speed of the calculations that you are after, at least you would see the benefit of the automatic formatting features that come with any spreadsheet software. Now you can easily have very presentable spreadsheets done for you as you type your data inside the cells. You do not have to worry too much about the look of your spreadsheets, especially if you are presenting these to your clients. Businesses generally make extensive use of spreadsheets both in accounting and all other business fields. Being a numerically based system of analyzing information spreadsheets are used throughout every accounting function as the technique presents an ideal basis to maintain accuracy and automate the collection of financial information.