NEWH Kill Tracker

Phone-first Streamlit tracker for weekend kill leaderboard progress in a mobile game alliance.

This version is CSV-first. Screenshot extraction is intentionally not included yet.

Features

• Weekend setup with selectable timezone.
• Approved snapshot workflow for Alliance and Player CSV input.
• SQLite persistence at data/tracker.db.
• Validation warnings and save-blocking errors before data is stored.
• Progress calculations from the earliest weekend timestamp to the latest weekend timestamp.
• Alliance and player dashboards with NEWH rank, gains, new players, dropped players, and anomalies.
• Excel export with formatted sheets for raw kills, progress, dashboard, new/dropped players, and anomalies.
• Copy-ready text reports for alliance progress, player progress, and recruitment.

Required CSV columns

Alliance CSV:

Rank,Alliance Tag,Alliance Name,Kills,Timestamp
1,NEWH,New Home,1234567,2026-06-13 09:00:00

Player CSV:

Rank,Commander,Kills,Timestamp
1,CommanderName,123456,2026-06-13 09:00:00

Timestamps must use YYYY-MM-DD HH:MM:SS.

Install

python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt

Run

streamlit run app.py

Open the local Streamlit URL on your phone or desktop browser. The layout uses a simple vertical flow with full-width buttons.

Test

pytest

Project Structure

newh-kill-tracker/
  app.py
  requirements.txt
  README.md
  src/
    database.py
    validators.py
    calculations.py
    excel_export.py
    reports.py
  tests/
    test_validators.py
    test_calculations.py
  exports/
  data/