Important: Please read the following before attempting to run the PVC sustainability tool V1.1. 0. This version of the tool, released in October 2010, represents an updated version of the original version V1.0 (released in February 2010). It is fully compatible with the original version and studies created in the original version can be imported easily into this version. The following updates have been incorporated in this version: -choice of different currencies for value added analysis (£, € and $) -updated data for S-PVC to correspond to the latest Plastics Europe data -updated formulation for PVC pipes with a lower content of recycled PVC (following an advice from the PVC industry) -different plasticisers (DINP, DIDP) have been added to the database -in the flooring formulation, the plasticiser DEHP has been replaced with DINP -the ratio of PVC-to-steel in the window frame formulation has been increased (following an advice from the PVC industry) -in the window formulation, the MMA has been replaced with PMMA -limestone has been renamed calcium carbonate (limestone) -the database has been updated to include the data from the ELCD database. 1. System requirements The PVC sustainability tool was designed and built using the English-version of Microsoft Excel 2003 for Windows XP. It may not run properly on non-English operating systems as well as on older versions of Excel or Windows. The tool is designed for use on PCs and is not suitable for use on Mac computers. 2. Security settings In order for the macros to work correctly, the Excel security settings should be set to either Medium or Low. In Excel 2003 this can be done through the Tools>Macros>Security menu. When the tool is loaded, click on Enable Macros in order to run the tool. Consult the Excel Help for enabling macros for other versions of Excel. 3. Using Excel version 2007 The PVC tool specific menus are displayed differently in Excel 2007. In order to view the PVC tool menus please click on the Add-ins tab on the main menu-bar. The menu items will then be displayed on the left hand side of the main menu-bar. 4. PVC tool manual The manual can be found as a pdf file under the PVC Help menu option. 5. Disclaimer By using the PVC sustainability tool the user accepts the following terms and conditions: • To use the tool solely for their own purposes • Not to use the tool for any income-generating consulting services • Not to copy or distribute the tool to a third party. 6. Credits PVC sustainability tool was developed by a research group based at the University of Manchester and led by Professor Adisa Azapagic. The project was funded by EPSRC (grant number EP/D505372/2). PVC sustainability tool ©2006-2010. All rights reserved.