A fullstack energy audit dashboard that helps teams measure store electricity usage, compare it with equipment-based estimates, and identify operational waste.

SPARTA Energy is an internal platform for running energy audits across multiple store locations. The goal was to make energy usage easier to measure, compare, and review through a structured digital workflow instead of relying only on monthly electricity bills.

I worked on the project as a fullstack developer. My role included building the audit flow, calculation logic, data model, dashboard views, admin reporting, and the result screen that turns technical input into a clear efficiency status and operational recommendation.

The project combined several areas at once: store data, equipment usage, area measurements, electricity history, audit calculation, recommendation logic, and admin monitoring. The challenge was to keep the flow understandable for field users while still collecting enough detail to make the result useful.

Energy usage is not always obvious from a bill alone. A store can have higher consumption because of equipment schedules, operating habits, older devices, or a gap between expected and actual usage. The system needed to help surface those signals without making the user feel like they were filling a complex spreadsheet.

It was important to create something that worked not only as an input form, but as a repeatable audit method. The platform had to support consistent data entry, reliable calculation, readable results, and reporting that could be reviewed later by operational teams.

I started by structuring the audit into a step-by-step flow, from selecting a store and filling area data to entering equipment usage and electricity history. This made the process easier to follow and helped separate the operational input from the calculation and result view.

The core logic compares estimated monthly consumption from equipment power and operating hours against real electricity usage history. I also worked on the supporting data model for stores, equipment types, equipment brands, audit items, usage history, and recommendations so the audit result could be stored and reviewed consistently.

The admin side was built to make the data more useful after the audit is submitted. It includes dashboard views, audit history, reports, export flows, store and equipment master data, and filtering by operational context. The focus was to make the tool useful both for field execution and for management review.

The result is a decision-support tool that makes energy audits more consistent, measurable, and easier to review. Teams can compare estimated usage with actual electricity data and quickly understand whether a store is operating efficiently or needs attention.

The platform also gives operational teams a clearer way to look at audit history, consumption trends, high-impact equipment, efficiency status, and recommended actions. Instead of keeping the audit as scattered input, the system turns it into structured data that can support follow-up decisions.

The project created a foundation for a broader energy monitoring workflow. It can be extended with richer analytics, better benchmarking between stores, and more detailed recommendation logic as more audit data is collected.