Skip to main content
Toolathlon-Verified · Website task ID 150 · Canonical task machine-operating View the task source at d57361c0

​
Required Tools

MCP Servers
google-cloud
filesystem
excel
Local Tools
python_execute
handle_overlong_tool_outputs
manage_context
history
claim_done

​
Instruction

A production line in the factory streams real-time data through IoT sensors into the live_sensor table of the machine_operating dataset in BigQuery. The normal operating parameter ranges (minimum/maximum values) for each machine’s sensors are defined in a configuration file named machine_operating_parameters.xlsx. Please query the live_sensor table in the machine_operating dataset in BigQuery for sensor data between 11:30 and 12:30 on August 19, 2025, and, using the parameter ranges from the Excel file, identify all readings that fall outside their normal ranges (you may choose any efficient method for comparison). Compile the final anomaly report with the fields timestamp, machine_id, sensor_type, reading, (the format of these data should be exactly the same as in the BigQuery table) and normal_range (min - max) into a file named “anomaly_report.csv”. Save the file in the workspace, and upload this file to the existing cloud storage bucket whose name starts with the prefix “iot_anomaly_reports” in your cloud space.

​
Initial State

​
Local Workspace

workspace/ └── machine_operating_parameters.xlsx

​
Runtime Setup

This task initializes application or service state during preprocessing. Review the pinned setup source.

​
Legacy Trajectories

These replays were produced on the original Toolathlon release. They are retained for historical inspection and are not Toolathlon-Verified results.