Try it yourself
Rebuild the Example B ranking and briefing yourself with a free AI chat.
A CSV is a plain-text table. In exposure.csv, russia_usd and gulf_usd are imports in US dollars. gdp_usd is GDP in US dollars. exposure_pct_gdp is the at-risk share of GDP. mirror_years lists years taken from the seller’s report.
Download the data
✅ Free pending testDownload exposure.csv and save it in your Downloads folder.
I saved a file named exposure.csv. Tell me how to confirm it is in my Downloads folder and that the name is exactly exposure.csv. Do not change the file. You see a file named exposure.csv in your Downloads folder.
Ask for a ranking and chart
⚠️ Free, limit: free file-upload and message limits pending testIn a new chat with your AI, upload exposure.csv and send this prompt.
Use only the attached exposure.csv. Do not invent values.
exposure_pct_gdp is imports at risk as a percent of GDP.
Show the 10 countries with the highest exposure_pct_gdp, highest first.
Make a horizontal bar chart split into Russia and Gulf.
The Russia part is russia_usd divided by gdp_usd, times 100.
The Gulf part is gulf_usd divided by gdp_usd, times 100.
Label both parts as a percent of GDP.
If mirror_years is not blank, mark that country as mirror.
If you cannot draw a chart in this chat, give the same 10 countries in a table with those two percentages. You see ranks 1 to 10 from the table on the Example B page, each split into a Russia percent of GDP and a Gulf percent of GDP.
Make the AI explain its method
⚠️ Free, limit: free message cap pending testIn the same chat, send this prompt.
Explain this method in plain words.
Average the 2020 to 2024 imports of HS 2709 (crude oil), HS 2710 (refined fuel) and HS 2711 (natural gas, including LNG).
The suppliers are Russia, Saudi Arabia, the United Arab Emirates, Iraq, Kuwait, Qatar, Iran, Oman and Bahrain.
Divide that average by average GDP.
GDP is the size of an economy.
Name two weaknesses.
Explain why the result is not a prediction of lost GDP. You see a reply that names the imports being added, GDP as what they are divided by, two weaknesses, and a statement that this is not a prediction of lost GDP.
Separate the two supply shocks
⚠️ Free, limit: free message cap pending testIn the same chat, send this prompt.
Use only the attached exposure.csv. Do not invent values.
Rank countries by russia_usd divided by gdp_usd.
Then rank them by gulf_usd divided by gdp_usd.
Compare each rank with the rank by exposure_pct_gdp.
Name the countries whose rank changes most if only Russia stops supplying.
Name the countries whose rank changes most if only the Gulf stops supplying.
For those countries, show the old rank and the new rank. You see two lists of country names, one for a Russia-only stop and one for a Gulf-only stop, each with an old rank and a new rank.
Write a short ASEAN briefing
⚠️ Free, limit: free message cap pending testIn the same chat, send this prompt.
Use only the attached exposure.csv. Do not invent numbers or countries.
Use only the rows where the group column says ASEAN.
Write a briefing of about 300 words on the five with the highest exposure_pct_gdp.
For each of the five, give the country name as written in the file, the exposure as a share of GDP, and the Russia share versus the Gulf share.
Explain the method in two sentences.
Name two limitations.
Keep the numbers separate from any policy suggestion.
If mirror_years is not blank, name the country and the years.
Do not forecast GDP or prices. You see a briefing that names Brunei, Singapore, Thailand, Malaysia, and Vietnam, with a share of GDP and a Russia versus Gulf split for each, plus two limitations.
Spot-check two numbers
✅ Free pending testIn the same chat, send this prompt. Replace each bracket with a country name from the table on the Example B page.
Use only the attached exposure.csv. Do not change a number to force a match.
For [first country] and [second country], show russia_usd, gulf_usd and gdp_usd.
For each country, calculate (russia_usd + gulf_usd) / gdp_usd * 100.
Show the file's exposure_pct_gdp beside that result.
Say whether the two percentages match after rounding.
Then say whether those percentages match the briefing you wrote above. You see russia_usd, gulf_usd, gdp_usd, and a calculated percentage for each country that matches exposure_pct_gdp apart from rounding.
Open the explorer when you want to move a Russia cut and a Gulf cut yourself.