andreacalcagniNF/csv-powerpoint-generator

🏭 CSV to PowerPoint Generator

Generate branded PowerPoint presentations from manufacturing CSV data with automated KPI calculations.

🚀 Features

• —CSV Upload: Support for large manufacturing datasets (up to 200MB)
• —Automated KPI Calculation: Calculate efficiency metrics for Stampaggio, Stampaggio Surlyn, and Decorazioni departments
• —PowerPoint Generation: Create professional reports using branded templates
• —User Authentication: Secure access with username/password authentication
• —Multi-language Support: Italian interface optimized for manufacturing workflows

🔐 Authentication

This Space uses username/password authentication to control access. Users need valid credentials to access the application.

📊 Supported Data

The application processes manufacturing data with the following requirements:

• —Format: CSV files with UTF-8 or ISO-8859-1 encoding
• —Departments: ST (Stampaggio), MS (Stampaggio Surlyn), DC (Decorazioni)
• —Data Structure: Compatible with "Dati_Grezzi" export format
• —KPIs Calculated: EFFREP, EFFPRO, EFFSC, EFFE, OEE

🛠️ How to Use

1. 1.Upload your CSV file containing manufacturing data
2. 2.Select the month and year for KPI calculation
3. 3.Click "Generate PowerPoint" to create the presentation
4. 4.Download the generated PowerPoint file

📈 KPI Targets

Stampaggio (ST)

• —EFF_REP: > 91%
• —EFF_PRO: > 94%
• —EFF_SC: > 98.5%
• —EFF_E: > 93%
• —OEE: > 80%

Stampaggio Surlyn (MS)

• —EFF_REP: > 93%
• —EFF_PRO: > 95%
• —EFF_SC: > 96%
• —EFF_E: > 92%
• —OEE: > 85%

Decorazioni (DC)

• —EFF_REP: > 84%
• —EFF_PRO: > 87%
• —EFF_SC: > 96.5%
• —EFF_E: > 91%
• —OEE: > 80%

🔧 Technical Details

• —Framework: Gradio 4.44.0
• —Python: 3.10
• —Libraries: pandas, python-pptx, gradio
• —Template: Uses template.pptx for branded presentations
• —Security: Environment-based authentication with HF Secrets