Setup

1. Add credentials to the Intelligent Expression tool

2. Set up base path in the ExcelWriter tool

Spreadsheet Doctor Agent

Example interactions with the spreadsheet doctor agent

1. Rename the columns to these ones: order id, Customer Name, ORDER_DATE, Amount, currency, country, status, Comments. Then, remove the 1st 3 rows.

2. In this resulting table:

   • remove the rows from the order id column where the id is not like XXXX (where X is a number from 0 to 9);

   • fix the Amount column to keep only values that can be converted to numbers (you can use an LLM for that). If the amount is negative, remove the negative sign. Replace the existing Amount column with the new one that you create. Convert the final amount column to number.

   • fix the currency column to convert currencies to standard codes like XXX, e.g., EUR. Replace the currency column.

3. Using this resulting table, show me the total amount spent by each customer who paid in EUR in a bar chart.