README.md

metadata

title: PUE Report Generator
emoji: 📄
colorFrom: green
colorTo: blue
sdk: streamlit
sdk_version: 1.40.0
app_file: app.py
pinned: false

PUE Report Generator

Upload a community PUE master-sheet workbook and download a template-faithful Word report. Every figure in the report is recomputed deterministically from the sheet — the (optional) AI step only ever rewrites prose, never numbers.

Use it

1. Upload the master sheet (.xlsx).
2. Set the developer name, report date, and any developer-supplied mini-grid capacities (only if they aren't already in the sheet).
3. Click Generate report and download the .docx.

Pipeline

master.xlsx --extract--> PUEReportData --recompute--> --validate--> (+warnings)
                                |
                                +-- generate_narratives (LLM, prose only)
                                +-- render (deterministic .docx)

AI narratives (optional)

The three prose sections can be written by Gemini. To enable them, add a GOOGLE_API_KEY secret to the Space (Settings -> Variables and secrets) and switch on the toggle in the sidebar. Without a key, those sections use a plain deterministic fallback and everything else works unchanged.

Run locally

pip install -r requirements.txt
streamlit run app.py

(Developer/internals notes are in DEVELOPER_NOTES.md.)