Gear Stats Analysis Engine & Web Tool
A comprehensive full-stack application designed to aggregate, analyze, and compare in-game equipment and stats. This repository houses both the automated data pipeline used to extract and score gear modifiers, and the user-facing web interface that visualizes rankings and stat comparisons.
🚀 Overview
The Gear Stats Calculator provides deep analytical insight into character equipment optimization ("theorycrafting") by calculating comparative scores based on weighted troop cycle logic and raw statistical multipliers. It features an interactive gear comparison interface, localization, and a robust data processing backend.
Key Features
- Advanced Scoring Algorithm: Implements a multi-layered equation that ranks gear and trinkets based on raw, unweighted averages and sophisticated troop-cycle weighting.
- Dynamic Gear Comparison: Offers an interactive UI to compare loadouts side-by-side, enforcing accurate stat combinations.
- Data Engineering & Analysis: Utilizes Pandas to clean, process, and analyze raw game statistics directly from ingestion APIs and template sheets.
- OCR Pipeline: Integrates OpenCV and Tesseract to extract and digitize stats automatically from game imagery.
- Translation Engine: Connects with DeepL API to process strings across multiple supported languages.
- Scalable Architecture: Centralized logging, structured database models via SQLAlchemy, and global exception handling tuned for production environments.
🛠Tech Stack
Backend & Data Processing
- Flask: High-performance Python web framework handling backend routing and API endpoints.
- Flask-SQLAlchemy & SQLite: Relational database layer for persisting gear item schemas and properties.
- Pandas & OpenPyXL: Used for ingesting, transforming, and analyzing game data templates (CSV/XLSX).
- OpenCV & PyTesseract: Applied for image recognition and text scraping directly from game assets.
- DeepL: Extracted for dynamic localization tasks.
Frontend
- JavaScript & HTML: Kept as vanilla and lightweight as possible for maximal rendering performance.
- esbuild: Extremely fast bundler used to transpile, minify, and map JS assets.