File size: 1,820 Bytes
4d0d437 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 | import streamlit as st
st.markdown(
"""
# LCG Capacity Documentation
## 1. Objective
Analyze LCG utilization behavior and detect imbalance/capacity pressure.
## 2. When to use this tool
Use this page for LCG-level dimensioning checks and region-level optimization decisions.
## 3. Input files and accepted formats
- Required: LCG report in `.csv`
- Data recommendation: at least 3 days, daily aggregated, LCG-level export
## 4. Required columns/fields
Input CSV must include columns expected by `load_and_process_lcg_data`.
Outputs include `final_comments` and geographic fields for map plotting.
## 5. Step-by-step usage
1. Open `Capacity Analysis > LCG Capacity Analysis`.
2. Upload LCG CSV report.
3. Set analysis days, threshold days, utilization threshold, and LCG difference threshold.
4. Click `Analyze Data`.
5. Review tables, charts, and map.
6. Download report.
## 6. Outputs generated
- LCG analysis dataframe
- KPI dataframe
- final comment distributions (global and per region)
- map of final comments
- downloadable file: `LCG_Capacity_Report.xlsx`
## 7. Frequent errors and fixes
- Validation warning on days settings.
- Fix: ensure threshold days <= analysis days and analysis days >= 3.
- Processing error.
- Fix: verify CSV schema and numeric fields.
- Empty map.
- Fix: confirm presence of `Longitude`/`Latitude` and non-empty comments.
## 8. Minimal reproducible example
- Input: valid LCG CSV with at least 7 days.
- Action: run default settings.
- Expected result: analysis table, distributions, map, and Excel download.
## 9. Known limitations
- Quality depends on source KPI completeness.
- Thresholds may require tuning by market behavior.
- Map view requires valid coordinates.
## 10. Version and update date
- Documentation version: 1.0
- Last update: 2026-02-23
"""
)
|