Bridging the Gap: Automated Tools for EV Charging Infrastructure Planning

This article presents an analysis of the automated calculation of stops and energy consumption for electric vehicles (EVs) using a custom Visual Basic for Applications (VBA) program integrated with Microsoft Excel. The study evaluates two EV models, the JAC E10X and Tesla Model Y, across three different routes under identical operating conditions, including passenger loads and average speeds. The analysis incorporates two scenarios: Case 1, representing an average family with a total passenger mass of 253.5 kg, and Case 2, with five adults totaling 355 kg. The program calculates whether the available battery energy is sufficient to complete each route segment and determines where additional stops for recharging are needed. Results reveal that the Tesla Model Y, with its larger battery capacity, requires significantly fewer stops than the JAC E10X. This finding highlights the impact of battery size on long-distance travel and has implications for optimizing electric vehicle infrastructure. The study also proposes the development of an advanced platform that integrates real-time data through Application Programming Interfaces (APIs) to improve route and charging optimization based on vehicle specifications and passenger details.