24M Technologies

VBA Projects

Testing is very important to any R&D company but communicating test requests and resulting data between the requester and the test engineer can be complicated. I was tasked with coding an easy-to-use program for our engineers and technicians to quickly pull vital information for testing. We needed one to pull test requests from requesters, but only prioritize the information necessary for the test department, like procedures and voltage of the cells. Initially, outside departments created Excel sheets, detailing test procedures and what the purposes were. A database held all these files, and our manager would go through each one and manually record the important information and kept them in organized OneNotes for the team. It was tedious and mistakes were sometimes made. I was assigned to code a program to perform this task, so anyone could check test requests. We also needed the program to grab the data of a cell after formation. Formation was an important step in a cell's life, where we know if it's worth testing and the rate we should charge/discharge. The cells would perform formation in battery testers, each controlled by a different computer, and the data was imported into our SQL database. My project also needed to allow users to search for the formation data of the batch of cells they want and perform calculations to output the data of many cells.