Skip to main content

MCP Servers
fetch
google_sheet
playwright_with_chunk
Local Tools
history
claim_done
web_search
python_execute
manage_context
handle_overlong_tool_outputs

Instruction

Please read the table titled “GDP2022” in Google Sheets and calculate the CR5 index for each of the seven major regions listed by the World Bank. Create a new spreadsheet in Google Sheets, name it “GDP CR5 Analysis”, and within it, create a new table titled “gdp_cr5_analysis”. Save the following data with headers being Region, Top5_Countries, Top5_GDP_Sum, Region_GDP_Total, and CR5_Ratio, where they represent the region name, the top five countries (use exactly the full names in existing sheet and separated by ”/”, from highest to lowest), the sum of the top five countries’ GDP, the total regional GDP, and the CR5 index (percentage, rounded to two decimal places). Sort the data in descending order by CR5 index. Note: You should strictly following the country classification provided by the World Bank. If one region has less than 5 countries, you just consider the real number of countries in filling the table.

Initial State

Google Sheets

The Google Sheet is reinitialized on each test; you can view the original data here.