Engine Comparison
| Engine Model | Cost ($) | Fuel Efficiency (km/l) | Max Power (HP) | Max Torque (Nm) | Displacement (cc) | Weight (kg) | Availability |
|---|---|---|---|---|---|---|---|
| Engine A | 800 | 40 | 15 | 100 | 1200 | 180 | In Stock |
| Engine B | 1000 | 35 | 20 | 120 | 1500 | 200 | Out of Stock |
| Engine C | 1500 | 30 | 25 | 150 | 1800 | 250 | In Stock |
| Engine D | 2000 | 28 | 30 | 180 | 2000 | 300 | Pre-Order |
Excel Functions
- Total Cost: 800 + 1000 + 1500 + 2000 = 5300
- Average Fuel Efficiency: (40 + 35 + 30 + 28) / 4 = 33.25 km/l
- Highest Power: 30 HP (Engine D)
- Lowest Power: 15 HP (Engine A)
- Engines with Cost > $1000: Engine C, Engine D
- Count Engines with Fuel Efficiency > 35 km/l: 2 engines (Engine A and Engine B)
- Rank Based on Max Torque: Engine D (1st), Engine C (2nd), Engine B (3rd), Engine A (4th)