Python Apps Streamline Battery Energy Storage Ops

The first of the five applications created by Six Feet Up’s expert developers is used to calculate the size of the energy storage solution required for individual clients. Prior to Six Feet Up’s involvement, company engineers entered information relevant to a battery system’s power performance guarantees and other characteristics into an Excel-based system that used a series of proprietary formulas to determine:

• the number of batteries needed for a given power output,
• the number and timing of new battery installs to make up for battery degradation; and
• power loss due to the addition of components such as cooling systems and converters.

Before building the application, Six Feet Up’s engineers needed to gain a solid understanding of the underlying formulas and how they interacted with each other to produce the desired output.

Understanding the Formulas

Six Feet Up first examined the proprietary formulas in Excel so that they could be converted to Python code. The sizing formulas were complex and interrelated, but Six Feet Up’s team took the time and worked with the client to obtain the needed level of understanding.

Creating the Application

The team determined that using Django (the go-to Python web application framework for rich applications) with a PostgreSQL database managed by AWS RDS (which provides scalability and reliability) would be the best solution for the application’s back end.

Docker and AWS App Runner were used to deploy the Django application, including the front end, which was implemented using the Next.js React framework. The resulting user interface is designed to be recognizable to engineers who have been using the spreadsheet tool for years, while removing visual clutter and streamlining its usability. The result is a modern application interface with a cleaner, easy-to-use design.

Six Feet Up deployed the application using Terraform, a widely-adopted tool for defining infrastructure as code, and recommended unit tests for 100% coverage of the application.

Company engineers and staff have given favorable reviews of the new application. The Django back end and React front end allow for a clean and easy-to-use application.

Because the new application was created using modern software development practices — and its ongoing maintenance and feature development will be accomplished through managed software development life cycle processes — company staff can be confident that the application works correctly. Additionally, the superior numerical precision of Python means that calculations from the application are more accurate than they were when processed using Excel.

The optimized suite of applications will help the company install energy storage systems with a greater degree of quality, precision and cost control. In turn, these applications will benefit the renewable energy sector and help mitigate the economic and environmental impacts of climate change.