Home
Free Trial Sign In
  • Sign In
  • Forecasts and models
    • Countries
      • Economic forecasts and reports
      • Economic model and scenarios
      • Event-driven analysis
      • Risk assessment
    • Industries
      • Industry forecasts and reports
    • Cities and Regions
      • City forecasts and reports
    • Country and City Tourism
      • Forecast data and reports
    • All subscription services
      • 200+ COUNTRIES
      • 100+ INDUSTRIES
      • 4,000+ CITIES & REGIONS
      • TOURISM FORECASTS
    • Contact us to find out more about our forecasting services, models, and scenarios.

      Request trial
  • Consulting

    We combine the analytical skills of our economists and thought leadership team to deliver unique and groundbreaking research.

    • In focus
      • Brexit
      • IFRS9
      • View all recent releases
    • Demonstrate economic impact and social value
    • Establish your firm as a thought leader
    • Develop forecasts and explore scenarios
    • Evaluate the impact of policy changes
  • About Us
  • My Oxford
  • Contact
  • My sector
    • How we help
      • Asset Management
      • B2C
      • Banking
      • Chemicals
      • Energy
      • Government
      • Infrastructure
      • Manufacturing
      • Mining
      • Real Estate
      • Technology
      • Travel and tourism

A leader in global forecasting and quantitative analysis, with the world’s only fully integrated economic model and 200 full-time economists and analysts, Oxford Economics is a trusted advisor to corporate and government decision-makers. We help our clients track, analyse, and model country, industry and urban trends around the world.

 

Subscription Services

A deep portfolio of research tools to assess the impact of macro events across more than 200 countries, including regularly-updated economic briefings, forecasts, and scenarios. Find out more.

 

A complete industry forecasting and analysis service with continuous updates for 74 countries and 26 commodities. Find out more.

 

The most complete set of forecasts available for cities and sub-regions around the world. Find out more.

 

NEW: MiFiD II 

A full list of our subscription services

Learn more

Macro Matters

How we support your sector

Airlines and airports
Asset management
B2C
Construction
Energy
Government
Manufacturing
Mining
Real estate
Technology
Trade Associations
Travel and tourism




  • Economic Impact
  • Research Techniques
  • Economic Impact Analysis
  • Cost-Benefit Analysis
  • Valuing Social Impact
  • Feasibility and Location Studies
  • Macro and Micro Forecasting
  • Data Analytics and Custom Models
  • Labour Market Analysis
  • Economic Development in EMs
  • State and Local Strategy
  • Scenario Analysis and Stress Testing
  •  
  • Economic Impact archive
  • By Topic
  • Browse Economic Impact by topic
  • By Industry
  • Browse Economic Impact by industry
  • Full archive
  • Publications in date order

Featured Project: Assessing the
Economic Implications of Brexit

Learn more

 

  • Thought Leadership
  • Research Inputs
  • Global surveys
  • Executive interviews and case studies
  • Advisory panels and peer interchange
  • Social media research
  • Quantitative and economic analysis
  •  
  • Research Outputs
  • White papers, briefings, and think pieces
  • Charts, infographics, and dashboards
  • Analytical tools and models
  • Social and digital media
  • Microsites and presentations
  • Forward Thinking Blog
  • Click here for latest content
  •  
  • Thought Leadership Examples
  • By topic
  • Publications categorised by Topic
  • By Industry
  • Publications categorised by Industry
  • By Client
  • Publications categorised by Client
  • Full archive
  • Publications in date order

Techlabs

Helpful tips and guidance on

all the good stuff  that comes out of

Oxford Economics Technology Labs

  • Techlabs
  • Global Data Workstation Excel Plugin–User Guide and Installation

Global Data Workstation Excel Plugin–User Guide and Installation

UPDATE – 2 DECEMBER 2014

A new version of the Excel Plugin is available

 

Instructions to install the Excel Plugin are provided at the end of the User Guide

Updated 23 April 2014

Excel Plugin User Guide

 

Overview

The Data Workstation Excel Plugin is a simple tool which can be used to retrieve data from the online Oxford Economics Global Data Workstation directly into Microsoft Excel.

The process begins by making one or more data selections in the online workstation and saving them as individually named “saved selections” (SSs).

image[14]

 

Once the plugin is installed, an Oxford Economics menu item will appear in Microsoft Excel, in which a number of functions are available as shown:

image

 

In Excel you can use the Oxford Economics menu login command to connect the plugin to the online data workstation. This allows the plugin to retrieve your saved selections.

When you choose a SS to download, its data is obtained from the online workstation and loaded into a spreadsheet.

A new spreadsheet will be created for each new downloaded SS. The Excel workbook can then be saved and opened again at a later date.

A previously downloaded spreadsheet can be selected and refreshed with the latest data from the online data workstation using the refresh ribbon command.

Reference links to any dependent spreadsheets and charts will be kept intact to reflect refreshed new data.

 

Details

General | Login

To login, click the Login button and enter your credentials which are the username and password you use to log into My Oxford (on the Oxford Economics Website) and the Databank (on the Oxford Economics Global Data Workstation):

image

 

An incorrect login will raise an error message:

 

image[15]

 

After logging in successfully additional functions are revealed:

image

 

You will only have to log in once. Your credentials will be remembered between Excel sessions. If you Log out you will, of course, have to log back in.

General | Logout

This logs you out of the Excel plugin application without affecting any Oxford Economics services you are already logged into.

General | About

The About window is activated by clicking the down arrow in the bottom right hand corner of the General section.

image

This will show you the version of the Excel plugin installed on your computer.

General | About | Configure Proxy

If your access to the Internet is mediated through a proxy, then you must complete the settings in this dialogue box. If the plugin is unable to get an internet connection to log in, then there’s a good chance your network is behind a proxy. Please ask your company’s IT department for assistance configuring these settings if you’re unsure.

image[105]

 

General | About | View Log

This command shows a window with technical information which is useful for Oxford Economics technical support. If you’re having issues using the tool, cut and paste the text into an email and send it to support@oxfordeconomics.com.

image

Website | My Oxford

Takes you to the My Oxford section of the Oxford Economics website.

Website | Databank

Takes you to the databank associated with the currently active selection

image5[1]

 

Selections | Reload

This button reloads the list of saved selections. This is useful if you add or remove SSs from the databank and want to see the updated list in the plugin.

Selections | Load

To use this command you must first have saved selections under your Databank account. If you don’t the button will not be shown disabled on the toolbar ribbon.

If the button is disabled, please go to the Databank and create a couple of saved selections right now before proceeding.

Once you’re done, click Selections | Reload.

Clicking Selections | Load brings up the list of saved selections on the Databank saved under your account

image8[1]

 

Selecting one of these saved selections will bring up a form to configure the download.

The plugin provides a couple of download table formatting options and a couple of data layout (shaping) options. The shaping options will be applied in addition to any shaping option already associated with the saved selection.

image[16]

 

The data folding option creates a skinny table with one column of Years and one column of Data values. This layout is ideal for importing data into third-party tools like Tableau Desktop and Microsoft PowerPivot.

 image[21]

 

A progress bar with estimated time for download will keep you occupied during big downloads.

image[31]

 

In addition, you may be warned when using the default template that it could take some time to format the data. Your experience will vary depending on the size of your selection and power of your computer.

image[26]

 

The saved selection loads into a spreadsheet. The name of the sheet will be the same as the saved selection name. A new section Current Sheet appears in the ribbon menu.

 image

 

Current Sheet | Refresh

The active sheet can be refreshed in situ.

The purpose of this feature is to allow you to take a dependency on the sheet in other sheets, external workbooks or applications.

When the plugin detects an active sheet is backed by a saved selection, the Current Sheet | Refresh button appears in the ribbon allowing you to refresh it.

This button won’t appear if the active sheet doesn’t contain data downloaded from a saved selection.

It is therefore possible for Databank-connected spreadsheets to co-exist with regular spreadsheets in the same Excel workbook.

 

Excel Plugin Installation

 

Prerequisites

The tool requires Microsoft Excel for Windows. It works in both 32-Bit and 64-Bit versions of Excel 2007, Excel 2010 and Excel 2013.

It requires .NET Version 4.5 and Visual Studio Tools for Office Runtime 2010. These prerequisites will be installed during the installation procedure if you don’t have them installed already.

You must have Administrator privileges on your computer to install .NET 4.5 and VSTO 2010. If you do not have these privileges, please contact your company’s IT helpdesk for assistance. Oxford Economics unfortunately cannot help you with this particular issue.

The plugin has been tested on Windows 7 and Windows 8. It will not work on Windows XP due to the dependency on .NET 4.5.

 

Installation

1. Download the latest EXE installer file by clicking the link below:

http://tools.oxfordeconomics.com/ExcelPlugin/Downloads.aspx

image[55]

 

2. Right click the file and select Properties. Click Unblock to authorise this downloaded file. Click OK.

image[60]

 

3.  Open the EXE file (or double click to start)

4.  If you hadn’t Unblocked the file you will get a security warning when you open it. It is safe to click Run.

image[65]

 

5.  The following dialogue screens will appear as the installation progresses

 imageimageimageimageimageimageimageimage

 

 

Support

If you run into issues installing this tool, which cannot be solved by your company’s IT helpdesk, please contact support@oxfordeconomics.com.

Excel Plugin

Search our archive

Search our portfolio of public information
Go to archive
  • Oxford Economics
    • About us
    • Contact us
    • Economists and analysts
    • Careers
  • Products and services
    • Subscription services
    • Economic Impact
    • Thought Leadership
    • Forecasts and scenarios
    • Impact of policy change
  • Help and software
    • Help using our services
    • Software and downloads
    • Latest technology developments
  • Follow Us
    • LinkedIn
    • Twitter
    • Facebook
© Oxford Economics 2019 all rights reserved