GLOBE users can download collections of case studies together with computed values of global variables in Excel (.xlsx) format. This tool works with any collection or published representativeness analysis. Instructions on global representativeness analysis are here.

Here is an example using the World Bank – Agriculture collection.  .

Instructions:

1. Navigate to collections under the Cases tab and load the desired collection. In this example, the World Bank – Agriculture collection was used.
2. After the collection loads, there is a zero with a plus sign icon on the top right corner. This icon lets you add global variables.
   

   The top-right icon allows users to add global variables

3. Users can select one or multiple variables by navigating through the categories, or by using the search box. Once the desired global variables are found, simply double click to select it or use the “select” icon on the top right corner of the pop-up window. To remove you can click “unselect”
4. After the desired global variables have been selected close the window. Now, the icon should display number of global variables selected by the user. In this example, the icon shows three because three variables were selected
   

   Three global variables added to the current collection

5. To download the excel workbook click on the excel icon present on the top right corner and save the excel workbook
6. The excel workbook contains four sheets:
   1. Instructions – Contains instructions on how to use the excel worksheet
   2. Data – actual data
   3. Variables – metadata for different variables and sources
   4. Weighting – GLOBE’s weights explained