Here are some Excel functions that may be useful for engineers designing electric vehicles:
- IF: to perform conditional calculations based on certain conditions. For example, to calculate the energy consumption of a vehicle based on different driving modes.
- SUMIF: to sum values based on certain conditions. For example, to calculate the total energy consumed by a vehicle over a certain distance.
- INDEX/MATCH: to retrieve data from a table based on a specified condition. For example, to find the range of a battery based on different driving conditions.
- VLOOKUP: to perform vertical lookups, where data is retrieved from a table based on the value in a specified column. For example, to find the energy consumption of a vehicle based on the speed and acceleration.
- Pivot tables: to organize and analyze large data sets, for example to identify trends in energy consumption or battery life.
- SUMPRODUCT: to perform matrix multiplication and conditional summation. For example, to calculate the total energy consumed by a vehicle based on different driving modes and conditions.
- Solver: to optimize a set of decision variables to meet constraints and maximize or minimize an objective function. For example, to optimize the energy consumption of a vehicle based on different driving conditions.
But…
Why spend all this time learning various functions for a tool that just isn’t adequate for doing complex engineering?
Why not use a tool that’s made by engineers, for engineers?
