• First ensure that indices have been calculated and customised satisfactorily by changing exchange rates or by adding or removing items and categories. Please make a note of any customisations that have been made.
• Click on the 'Export into Excel' button at the bottom right of the index table on the WCOL website. When prompted, click on 'Save' and choose where you would like to save the file. Once the index data file has been downloaded to your computer, open it in Excel.
• Save the index template (WCOLIndexTemplate.xls) by clicking on it and saving onto your local drive. Once saved please open the template, enabling macros if prompted, and click on the 'Import data' button.
• Please note that you may need to change your security settings to use the download templates. In Excel 97 you can do this by going to the 'Tools' menu, selecting 'Options', clicking on the 'General' tab and un-ticking the 'Macro virus protection' option. In Excel 2000 and above you can do this by going to the 'Tools' menu, selecting 'Macro', clicking on 'Security...' and selecting Medium or Low on the 'Security level' tab.
• When the data have been imported, copy the exchange rates from the WCOL website using the 'Copy to clipboard' button and paste them into the template starting at cell B28.
• You will now have a printable index sheet for each country in your selection.

• Click on the 'Export into Excel' button at the bottom right of the price data table. When prompted, click on 'Save' and choose where you would like to save the file. Once the price data file has been downloaded to your computer, open it in Excel.
• Save the price template (WCOLPricesTemplate.xls) by clicking on it and saving onto your local drive. Once saved please open the template, enabling macros if prompted, and click on the 'Import data' button.
• Please note that you may need to change your security settings to use the download templates. In Excel 97 you can do this by going to the 'Tools' menu, selecting 'Options', clicking on the 'General' tab and un-ticking the 'Macro virus protection' option. In Excel 2000 and above you can do this by going to the 'Tools' menu, selecting 'Macro', clicking on 'Security...' and selecting Medium or Low on the 'Security level' tab.
• When the data have been imported, copy the exchange rates from the WCOL website using the 'Copy to clipboard' button and paste them into the template starting at cell B6 on the 'EXCHANGE RATES' sheet. Please note that prices will be presented in the local currency and US dollars even if an alternative currency has been selected.
• You will now have a printable price data sheet for each country in your selection.

to top