Back to Hub

Capacity Compiler

Compile multiple capacity reliability files into one document - 100% Client-side Processing

Upload Files
Drag and drop Excel files or click to select multiple files. All processing happens in your browser - no data leaves your device.

All Processing Happens in Your Browser

Your data never leaves your device. All Excel files are processed client-side for maximum privacy and security.

About Capacity Planning Tool

Optimize your fleet operations with our Capacity Planning Tool. By analyzing historical performance and target metrics, this tool helps you determine the ideal number of routes and associates needed to maintain peak efficiency.

How to Use
  1. Upload your capacity report Excel files.
  2. Review the extracted metrics such as reliability scores and completed routes.
  3. Analyze the trends in the data preview.
  4. Download the compiled dataset for further analysis.
Key Features
  • Multi-file Excel processing
  • Automatic metric extraction (Reliability, Routes, etc.)
  • Real-time data preview
  • Client-side processing for security
  • Export to formatted Excel

What is the Capacity Planning Tool?

The Capacity Planning Tool is designed to help Amazon Delivery Service Partners (DSPs) master their operational efficiency. It simplifies the complex task of compiling and analyzing multiple capacity reliability Excel files. By aggregating key metrics like completed routes, paid cancellations, and reliability scores, this tool provides a clear view of your fleet's daily performance, enabling better resource planning.

How to Use the Capacity Planning Tool

Streamline your capacity reporting with ease:

  1. Upload: Drop your capacity report Excel files into the tool. It supports batch processing for multiple files.
  2. Automatic Compilation: The tool automatically extracts key metrics, calculates weekly trends, and compiles everything into a unified dataset.
  3. Analyze: Review the aggregated metrics directly in the data preview.
  4. Export: Download the compiled dataset in a clean, formatted Excel file for further analysis or reporting.

Key Benefits

  • Fleet Optimization: Make data-driven decisions on route allocation and associate scheduling based on real-time capacity metrics.
  • Simplified Reporting: Spend less time manually compiling Excel reports and more time managing your team for delivery excellence.
  • Data Integrity & Security: As with all our tools, processing is 100% client-side, ensuring your capacity data never leaves your device.
  • Free to Use: This essential tool is provided free of charge, reflecting our commitment to empowering DSPs.

Frequently Asked Questions (FAQ)

Can I process multiple capacity files together?

Yes. The tool supports batch processing, allowing you to compile data from multiple Excel files into a single, comprehensive view in one go.

Does this tool support all Excel file formats?

The tool is designed to work with standard .xlsx and .xls capacity reliability reports typically generated by Amazon DSP platforms.