Q1: ESPN Cricinfo Duck Counter
Count the number of ducks in the specified page of ESPN Cricinfo ODI batting stats
Task Description
Your task is to count the number of ducks (scores of 0) across all players on page 22 of ESPN Cricinfo's ODI batting statistics.
This tool will automatically fetch and analyze the data using a server-side proxy to avoid CORS issues. If automatic fetching fails, you can use the manual method provided below.
Automatic Duck Counter
Manual Method (Using Google Sheets)
If the automatic method doesn't work, follow these steps:
- Open a new Google Sheets document
- Copy the following formula and paste it into cell A1:
=IMPORTHTML("https://stats.espncricinfo.com/stats/engine/stats/index.html?class=2;page=$22;template=results;type=batting", "table", 3)
- Wait for the data to load in Google Sheets
- Find the column with header "0" (this represents ducks)
- Use a formula like
=SUM(M2:M51)
to sum the values (column letter may vary)