Excel data Analysis

The Compressed Air Accessories Selection Tool is an intelligent Excel-based application designed to simplify the process of selecting the right compressed air equipment for industrial needs.

By entering just two parameters — required airflow (CFM) and operating pressure (bar) — the tool automatically recommends:

Compressor Model (capacity matched to demand)

Air Dryer Model (adjusted with correction factors for pressure & temperature)

Air Filter Model (based on ISO air quality class requirements)

Estimated Price (for each accessory and total package)

Key Features:

User-Friendly Input

Enter airflow (CFM) and operating pressure directly in dedicated cells.

Optional input for ISO class / dew point requirement.

Automated Selection Logic

Uses correction factor tables to adjust dryer sizing for different operating conditions.

Applies lookup formulas (INDEX/MATCH/XLOOKUP) to suggest the best-fit model.

Ensures selected models meet or exceed requirements.

Comprehensive Database

Built-in tables for compressors (EOS series), dryers (AR series), and filters (AF series).

Expandable to include other models and updated pricing.

Instant Output

Displays recommended Compressor, Dryer, and Filter models.

Shows individual prices and total package cost.

Highlights efficiency and compliance with ISO standards.


***Note - I attached a file in that if you change airflow and pressure and temperature as per this your accessories change, you have to make same but now the data is big***