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.
Now go over to the next column and label it ‘affiliate link‘. Finally you will want two more columns labeled ‘username‘ and ‘password‘. You may not need these with all of your affiliate programs, but it sure is a hassle to need them and not have them. Now just fill in the rows with the information that you already have. And when you join a new affiliate, be sure to paste the information in your spreadsheet.