Export to Excel
Why Export?
The Excel file lets you:
- Present results to management
- Archive the study for future reference
- Further analyse with pivot tables
- Integrate with other reporting systems
How to Export
- Go to the "Report" tab of your study
- Click the "Export to Excel" button 📥
- The file downloads automatically
Contents of the Excel File
The file includes multiple sheets with all the information of the study:
📋 Dashboard
- • Study title and general information
- • Company, technician, and department
- • Key statistics (number of stations, average obs.)
- • General activity distribution
📊 Statistical Parameters
- • Statistical validation by work station
- • Initial vs actual sample size
- • Real proportion (p') and standard error
- • Completion status by work station
⏱️ Standard Time
- • Units produced in the range
- • Total, normal, and standard time
- • In the selected time unit (h, min, s, cmin, mmin, dmh)
- • Cycles / Hour
- • Pace rating and allowances
📝 Detailed Observations
- • Complete observation history
- • Planned and observed date/time
- • Work station, category, task
- • Pace rating and notes
📈 Breakdowns (multiple sheets)
- • By Work Station: Productive, Non-productive, and Delay for each work station
- • By Worker: Activity distribution per operator
- • By Category: Grouping by organisational categories
- • By Subcategory: Detailed breakdown by subcategories
💡 Note about Standard Time
The Standard Time sheet is only included if you calculated the standard time before exporting. Values are exported in the time unit you selected in the calculation form (hours, minutes, seconds, cmin, mmin, or dmh), and include Cycles / Hour.
File Name
The file is named automatically with the format:
Sampling_[Study-Name]_[Date].xlsx
Example: Sampling_Production-Line-A_2025-01-31.xlsx
Visual Format
The Excel file includes professional formatting:
- ✅ Cells with colours by category (green, yellow, red)
- ✅ Formatted borders and headers
- ✅ Columns with adjusted width
- ✅ Compatible with Excel, LibreOffice, and Google Sheets
Other Export Options
In addition to Excel, you can:
- Export JSON: For integration with other systems
- Export configuration: To reuse in another study
💡 Tip
Export regularly during the study to keep backups. You can generate the Excel as many times as you want - it will always reflect the current data.
🎯 Next Step
You have the data. In the final lesson we will learn how to draw conclusions and present recommendations.