NHS Premises Assurance Model Metrics Update

Tender description

The NHS Premises Assurance Model (PAM) was first released to the NHS Acute Sector on the 1st April 2010 in Microsoft Excel format. The NHS PAM has gone through a number of iterations and improvements with the current version released in May 2014. This is available on the gov.uk website at; https://www.gov.uk/government/publications/nhs-premises-assurance-model-launch. The requirement in this ITT is to update the NHS PAM metrics with 2013/14 data. More specifically this includes the following : Incorporate new data and updated metrics for 2013/14 based on the following datasets : Estates Return Information Collection (ERIC ) Patient Lead Assessment of the Care Environment In Patient survey Health Episode Statistics (HES) Removal of 2010-11 data (the model is only required to contain the last three years data ) Any modifications to the NHS PAM metrics workbook resulting from work within this ITT e.g. macros, labelling, drop down menus etc .