How to efficiently perform Royalty Calculations with Excel Agents

What are the Excel Agents?

DataSnipper Excel Agents move beyond automation to bring intelligence directly into Excel. Instead of working through manual steps, you simply describe what you want to achieve and the Agent takes care of the execution. From reading source documents and reconciling data to applying audit and finance logic, Excel Agents execute complete tests end to end. The result is transparent, explainable output that is fully traceable back to the underlying evidence and ready for review.

Pre-requisites:

• DataSnipper version 26.1 or later
• Accelerate or Elevate DataSnipper package
• Access to the internet

Video Tutorial

Step-by-step tutorial

1. Open your Royalty Calculations Excel workpaper and Document the procedure
   
   
2. To initiate Excel Agents, click on the icon within DataSnipper Ribbon
   
3. Enter your instruction in the prompt to tell the Excel Agent what to do
   
4. The Excel Agent will analyze your instruction and summarize the procedure it plans to perform. If the summary looks correct, confirm to proceed
   

5. Once the procedure finishes, the Excel Agent will provide a detailed summary of the actions completed.

   

6. The workpaper will now include all generated outputs, along with the excel formula wherever required for traceability.

   
7. Please use your professional judgement to review the output and make any required edits.