Home
Free Trial Sign In



  • 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
  • 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
  • Excel Data Workstation V2 0 Excel Plugin

Excel Data Workstation (v2.0 Excel Plugin)

There is a new version of the Excel Plugin. – Please go here for VERSION 3.0.

 

Quick Links

Installation | Download | User Guide

Overview

Excel Data Workstation is one of three complementary platforms which make up the Oxford Economics Global Data Services. The other two platforms are Global Data Workstation and Global Model Workstation. Together they provide economic data and analysis functions covering 200 countries, 100 industries and over 3,000 cities and sub-regions.

image

1. Global Data Workstation (GDW): Is an online web-based system currently serving 19 pre-packaged databanks covering several macro, industry, cities and labour economics domains. GDW provides a variety of data selection, heat map and chart visualisations, data downloads, data sharing and personalisation features. All databanks are updated periodically and the intention is to add more databanks over time.

2. Global Model Workstation (GMW): This personal desktop application provides a variety of user driven economic forecasting, scenario modelling, and visualisation capabilities supported by periodic updates of the underlying macro and industry model bases.

3. Excel Data Workstation (EDW): Is a simple but powerful Excel add-in which allows the user to connect to GDW and GMW, and bring data selectively into Excel worksheets. Data from these different systems can be intermingled in the same worksheets, saved and then refreshed easily at a later time when the origin source data is periodically updated.

The pictures below show the big picture of how EDW fits into a data flow originating with data in GDW and GMW, and Excel worksheets themselves, finally ending with Excel tables and charts of your own custom analyses. Essentially, EDW bridges the gap between economic data sources and insightful results… right where you usually need it, in Excel.

 

image

Excel Data Workstation as a bridge between data and results

 

image

Excel Data Workstation is a powerful combination of dynamic data sources, rapid data exploration tools, data manipulation functions, quick charting, and VBA macro automation alongside Excel’s own powerful features

Key Features

  • Easily plot data series charts
  • Perform simple data table reshaping operations
  • Perform data series splitting operations
  • Save workbooks, re-open, refresh worksheet data and continue work where you left off
  • Retrieve online and desktop saved selections
  • Aggregate, intermingle, and combine data series using ad-hoc indicator mnemonic based selections and queries
  • Record data retrieval operations as scripts which can be modified and reapplied in different contexts
  • Automate all commands from external Excel VBA Macros

Installation

Follow the instructions below to download and install the latest version of Excel Data Workstation. Once installed, an Oxford Economics menu item will appear in Microsoft Excel. Click on this menu to show a ribbon holding a number of functions as shown in the figure following.

We recommend you mouse over the controls to read the fairly detailed tooltips provided. This is a good way to quickly get an idea of the features available.

image

Ribbon mouse-over tooltips (Excel 2013)

The ribbon is divided into logically related groups of functionality, e.g. General, Connection, Refresh, and Data Series. Each group has one or more controls used to perform actions, enter information, make selections, or indicate status information.

The user guide describes the function of each control in detail and shows examples of applying some of the more advanced features.

Prerequisites

  • Microsoft Windows versions greater than Windows XP (i.e. will not work in Windows XP)
  • Microsoft Excel 2007 | 2010 | 2013
  • An active internet connection to use the online Global Data Workstation
  • Microsoft .NET 4.5 (will be installed if not present)

 

Download

Download the latest EXE installer file by clicking the link below: http://tools.oxfordeconomics.com/ExcelPlugin/Downloads.aspx

 

Instructions

  1. Right click the file and select properties. Click Unblock to authorise this downloaded file. Click OK.
  2. Open the EXE file (or double click to start)
  3. If you hadn’t unblocked the file you will get a security warning when you open it. It is safe to click Run.
  4. You’ll be warned that this program came from an unknown publisher. Click Yes.
  5. The following dialogue screens will appear as the installation progresses
  6. In the dialog, Select Components, please ensure you make the correct choice to suit your local
    desktop IT environment. Contact your IT support if unsure which selection is appropriate.

 

Install 1Install 2Install 3Install 4Install 5Install 6Install 7Install 8Install 9

User Guide

The user guide is available in Excel Data Workstation by clicking on General | Arrow to open the About box and then choosing User Guide to open the user guide PDF document in your default PDF reader application.

The version number of the user guide distributed with EDW is consistent with the installed version of the add-in.

image

Click here to download the latest user guide without installing Excel Data Workstation.

Excel Plugin, Excel Data Workstation, Global Data Workstation, Global Model Workstation

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 2021 all rights reserved