What is the difference between Current User Selections Textbox where I enter countries and “TPIS Country Selection Results” at the bottom of the web page:

The “Current User Selections” textbox is used to enter countries or country groups you are interested in.  The “TPIS Country Selection Results” table takes whatever country selections and constraints you’ve made and returns the matching countries, as well as data if you ask for it; the “TPIS Country Selection Results” is updated when you hit the “Analyze” button or the “Refresh” button.  If you do NOT select any “Show Analytical Tools” options, the “TPIS Country Selection Results” contains countries and various country codes matching the groups or individual countries in your “Current User Selections” box; if there are not Countries in the “Current User Selections” then all  countries in the world are returned in the Results.  So if you enter “.NAFTA”, Russia and China in the “Current User Selections”, the results box would contain US, Canada, Mexico, all the European Union Countries, Russia and China.  If you used the “Advanced Options” Panel and asked it to show U.S. exports of vehicles (naics 3361), Clicking the “Analyze” button would show the data for those countries for U.S. vehicles exports in 2009-2012:


How do I select all countries in a group, say Europe:

Several  ways to do it.

1.      Easiest:  Select the .EUROPE country  group from the dropdown list.  Highlight the “.EUROPE” group name.  Hit it the “select>” button. 




2. Fastest:  Type ‘.EUROPE” into the “Current User Selections” box, then hit the “analyze”or “refresh” buttons. 

3.  Other:  select all individual countries from the “.EUROPE” dropdown list (e.g., use the select all button after selecting .EUROPE in the dropdown).  

4.   Enter countries by hand or paste a list of country names into the Current User Selectsions then hit refresh or analyze (note country name must be spelled identically to what is in the TPIS database.).  5. 



How do I Select Countries NOT in a Group, .Say not in .EU28: 

a.      Check box that says “Restrict Countries” (next to refresh button).

b.       Check Box “Not In”.  Either Type the group name (including the period in as a first character) in the box next to “Not In” checkbox,

c.       or highlight the group name in the dropdown list below “Source:  TPIS Groups” and then hit the button (to List->(Copy Above) to copy the group name to the box next to “Not In checkbox.

d.      Then hit refresh or analyze.

NOTE:  If countries are already selected in the Current User Selections then the restrictions will return only the current user selections that are not in the .EU28, whereas if no countries are selected in the Current User Selection box, all countries EXCEPT the .EU28 Countries will be selected.  So if .Europe is in the Current User Selections Box, all the European countries EXCEPT .EU28 will be selected.


What is a “session list”, since one of the items in the “Source” dropdown is “My Session Lists”

A session is created when you first enter the TPIS web site.  You can navigate to any of the TPIS web sites “US Top Country Page”, “Country Selection Page”, “TPIS Country Report” in the same brower “session” and anything TPIS remembers can be shared among the TPIS web pages.  On the TPIS Country Selection Page, you  create lists of countries matching your selections.  Entering a name in the “Selections Name” box, then hitting the “Analyze Button” or the “Refresh” button, the name is used as part of the “results” title .   You can save a list for use later in the same session by hitting the “New List” button after entering a name for the country list.  The List is comprised of the countries matching your selections and contraints (no data is save, just the list of countries in the “Results” table, NOT the text of the Current User Selections”).  The country session lists show up after you hit the “New List” button when you change the “Source” to “MY Session Lists”.


How do I save a country list for use later in my session:

1.      Select a group of countries, either through the dropdown group name and the “Select From List  or type in directly into the “Current User Selections” box.

2.      Hit Analyze button (or refresh button)

3.      Type in a name in the “Name”  Box:

4.      Click the “New List” Buttion (Warning the Current User Selection Box is cleared after the list is saved).

NOTE:  The individual matching countries wi ll be saved as the “Name for User Selections List” or the “Describe Country Selection Constraints:




How do I retrieve one of my Session Lists

A.     In the “Source” Dropdown list, change from TPIS Country Lists to “My Session Lists”

B.     Select the list you created earlier this session you want to recover or select from.

C.     Hit the “select all>>” button or select individual countries from the “Select from List”

D.     Alternative: if you know the list number (number 1 shown below) then type into the Current Users Selections box as: .LIST#1 for list number 1, or .LIST#15 for list number 15 in the current session (the number is shown below).  If only lists showing in the Dropdown below the “MY Session Lists” can be selected, i.e., only current session lists.


How do I restrict selections to countries in multiple groups, say .APEC and .MIDEAST

A.     Enter Multiple Group names in the Current User Selections Box, either typing by hand or using the dropdowns. 

B.     Hit Refresh button or Analyze Button and the countries in the groups show in Results table.



How do I restrict selections to countries NOT IN in multiple groups, say .APEC and .MIDEAST

A.     Create a session List of the Countries you want to exclude:  enter .APEC and .MIDEAST in the current user selections box.  Then Type in a name for the list, hit refresh, then hit the “NEW LIST” Button.



B.     In the dropdown list for the MY Session Lists, find the list number for the list named “List of APEC and MIDEAST”  (List number 2 above)

C.     Type .LIST#2 in the box next to the “NOT IN “ checkbox, and check both “Restrict Countries” and “Not In”, as shown below


D.     Hit the Refresh Button, or hit the Analyze Button

NOTE:  If NO countries are selected in the “Current User Selections” box, the all countries in the world EXCEPT those in .LIST#2 will show up (i.e., every country not in apec or the middle east).  If Countries ARE selected in the “Current User Selections Box” then any matching countries in .LIST#2 will NOT show up in the matching country list below after hitting REFRESH or ANALYZE.



How do I see if countries in one of my lists is also in a World Region, say South America

A.     Enter the group name “ .SOUTH AMERICA” or enter the list of countries in countries in South America in the “Current User Selections” box

B.     Enter the List group name (.LIST#2 which is APEC and Middle East) in the box next to the  Not In” Checkbox and check “Restrict Countries” and make sure to UNCHECK “Not In”.

C.     Hit Refresh or Analyze Button.  The country list below will be the matching countries in BOTH the group named “.SOUTH AMERICA” and in .LIST#2 (apec & middle east), the group found consists of Chile and Peru (both in south America and APEC, no middle east countries are in South America).




How do can I select countries based on economic data, such as commodity exports or imports, GDP, or population, and can I select just the top or fastest growing countries

A.     Check “Show Analytical Tools” then hit the refresh button to show the panel of options to select countries based on economic data, rather than just by name or group name.

B.     Select the year to use as the period for analysis of the data in the dropdown next to “Analyze For”.  For percentage changes and change in value, you should also choose a “Base Year”.




How do can I select top countries based on the relative value of economic data, such as commodity exports or imports, GDP, or population:


Ran k-Order listings are used to select top countries by the VALUE of an economic variable (value is usually $ value except for indexes, population, etc).  Check the “Rank”, “Rank BaseYr’ or “Difference” boxes to show countries ranked by value of an economic variable (i.e., the top country has a rank of 1).  RANKS=TOP Countries:  Use the Rank Checkbox to select “TOP” countries.  To see a difference in rank between the base and “Analyze For” years, check “RANK”, Check “Rank Base Yr”, and Check “Difference”.  If you don’t want the ranks to be restrictive, enter “ALL” in the box next to “CheckBox”.  If you want to limit the “Analyze For” to the top x number (default is 10), type a number, which mean the top X.  If you want to skip the top x (say 10) but see all the other, enter “>10”.  If you want to see a range, enter the 1st:last, e.g., 20:50 for the countries ranked between 20 and 50—i.e., a colon between the numbers means it is an inclusive range.  For the “Difference” or a change in rank between the Rank BaseYr and the Rank (“analyze for”) year, you and use a range, or a > or < sign.  So for countries increasing in rank, in the box next to difference, put “>0”, for countries falling in relative importance, choose “<0”, or to see countries with any change in rank use and exclamation point to mean “NOT”, so “!0” means NOT zero.


How do can I select top countries based on the percentage change in economic data, such as commodity exports or imports, GDP, or population:

Percent Change:  Calculates the percentage change between the “BaseYr” and the “Analyze For” year.  If you check “percentage Change” and specify “all”, it does NOT constrain the country list, it just shows the percentage change.   Suppose you enter 2012 as the “Analyze For” year and “2009” as the “BaseYr”.   If you enter a number in the textbox, it serves as a constraint on the countries found.  So if you enter 20, all countries matching your selection that also show a >= 20 percent change from 2009-2012.  Since percentage changes can be negative if trade declines, you can enter <20 in the box to show countries that declined by 20 percent or greater from 2009-2012; entering <0 would show any declines in trade.  You can also enter ranges by entering two percentages separated by a colon:  -20:20 would find all matching countries showing a percentage change in the economic variable showing a percentage between a decline of less than or equal to 20 percent up to an increase less than or equal to 20 percent.  You can use the not symbol (!, and exclamation point) to make a range show numbers outside the range: !-10:50 would show countries showing a decline greater than 10 percent AND countries showing an increase greater than 50 percent from 2009-2012.  The table below shows countries in Latin America and the Caribbean where US manufactures exports declined more than 20 percent or increased more than 90 percent from 2009-2012 (Note we also constraint the value>0 so we don’t show items with 0 trade in 2012):