Bringing agentic AI into spreadsheets for planning tactical electrical power

This article describes how AWS and Sentient Industries integrated agentic AI into Excel spreadsheets to streamline military tactical electrical power planning for the METEOR modular energy system.

• Logistics officers can type device descriptions in Excel to retrieve power specifications from Amazon Bedrock knowledge base
• AI agents directly populate spreadsheet cells with power data, eliminating manual document searches
• System handles diverse device specs, manufacturer documentation, and field-measured power values
• Architecture uses four layers: knowledge base, agentic, runtime, and UI layers
• Excel integrates with agents via Power Query and VBA macros for seamless user workflow
• Agents estimate power consumption when data unavailable, clearly marking estimates
• Solution reduces logistics planning time and improves tactical power deployment accuracy

The solution demonstrates how agentic AI can enhance enterprise spreadsheet workflows by meeting users where they work, combining AI capabilities with familiar tools for military logistics planning.