import streamlit as st

st.markdown(
    """
# CIQ 4G Generator Documentation

## 1. Objective
Generate 4G CIQ outputs from raw CIQ Excel input with configurable naming and MCC/MNC values.

## 2. When to use this tool
Use this page when preparing LTE CIQ outputs for deployment planning or verification.

## 3. Input files and accepted formats
- Required: CIQ brut 4G file (`.xlsx` or `.xls`)

## 4. Required columns/fields
Input must follow expected 4G CIQ raw schema.
User-configurable inputs:
- `Year suffix` (default: `26`)
- `Bands string` (default: `G9G18U9U21L8L18L26`)
- `MCC` (default: 610)
- `MNC` (default: 2)

## 5. Step-by-step usage
1. Open `Apps > CIQ 4G Generator`.
2. Upload CIQ brut 4G file.
3. Set suffix/bands/MCC/MNC values.
4. Click `Generate`.
5. Review generated sheet tabs.
6. Download `CIQ_4G.xlsx`.

## 6. Outputs generated
- generated sheets preview in tabs
- downloadable workbook `CIQ_4G.xlsx`

## 7. Frequent errors and fixes
- Missing CIQ file.
  - Fix: upload `.xlsx`/`.xls` input.
- Processing error.
  - Fix: validate source template and required columns.
- Wrong MCC/MNC values in output.
  - Fix: verify numeric MCC/MNC before generation.

## 8. Minimal reproducible example
- Input: `samples/CIQ_LTE.xlsx`
- Action: use defaults and click `Generate`.
- Expected result: generated sheet tabs and downloadable `CIQ_4G.xlsx`.

## 9. Known limitations
- Strict dependency on CIQ raw schema.
- Incorrect parameter values can propagate to outputs.
- No dump cross-check is performed in this page.

## 10. Version and update date
- Documentation version: 1.0
- Last update: 2026-02-23
"""
)