How quocquang/ph-n_t-ch_sales works
This is a Streamlit tool for turning monthly raw revenue-dashboard files and a payroll file into a KTV-TVV sheet, with branch/month revenue and payroll summaries, KPI checks, and downloadable detail. The excerpt shows revenue mapping and aggregation, payroll totals, warning calculations, and CSV table output. The upload and workbook-generation wiring is only partly sampled, so those links reflect the app’s stated purpose; unsampled implementation details are omitted.
Main entry points: app.py Streamlit app
Components 12
Input processing
- Streamlit app
app.py - Revenue mapping
app.py - Payroll summary
app.py
Business analysis
- Revenue aggregation
app.py - KPI checks
app.py - Performance warnings
app.py
Reporting
- KTV-TVV sheet
app.py - Branch detail table
app.py - CSV download
app.py
Other components
- Operator
- Monthly revenue files
- Payroll file
Connections 12
- Operator → Streamlit app: uses
- Monthly revenue files → Streamlit app: provides
- Payroll file → Streamlit app: provides
- Streamlit app → Revenue mapping: processes
- Streamlit app → Payroll summary: processes
- Revenue mapping → Revenue aggregation: maps data
- Streamlit app → Revenue aggregation: aggregates
- Streamlit app → KPI checks: checks KPIs
- Streamlit app → Performance warnings: computes warnings
- Streamlit app → KTV-TVV sheet: generates
- Streamlit app → Branch detail table: displays
- Branch detail table → CSV download: exports