You are in the DevOps group at the hospital where the organization is implementing a now Electronic Medical Records (EMR) system. You are asked to estimate the amount of and cost of the required storage capacity. The project manager has given you the following information: 

2. The hospital currently has 1,250,000 patients in a legacy system which has been running for the past 10 years. These will be transferred to the new system.
4. It is estimated that 250,000 new patients will be added each year and 100,000 existing patients will return for a visit every year. For those patients in the legacy system, the average number of visits over 10 years is 6.
6. The new system includes the following data.
   2. Patient identification (300 bytes)
   4. Visit information (450 bytes per visit)
   6. Diagnosis information (600 bytes per diagnosis), average number of diagnosis is 3
   8. Lab results (800 bytes per lab), average number of labs per visit is 3
   10. Image results (20,000 bytes per image), average number of images per visit is 2
   12. Physician notes (1,500 bytes per contact), average number of contacts per visit is 6
9. Allow 45% overhead for the database management system (including additional files for indexing, metadata, etc.)
11. A full backup will be taken daily and each backup will be kept for 10 days.
13. A daily transaction log will be maintained for 5 days; it is estimated that there are some 25,000 transactions per day (average size is 500 bytes)
15. Develop a detailed spreadsheet showing your calculations on disk capacity requirements:
    2. When system installed
    4. At 1 year
    6. At 10 years

Note: the project manager says these numbers may change so make a spreadsheet that allows you to easily change the numbers