Dashboard Mode - Gerber file generation
Business Question
How can we track and analyze the generation of Gerber files for PCB manufacturing to ensure quality and timeliness?
0
0
Gerber file generation in PCB Design - Dashboard Guide
Sample Data
| Date | Project | Layer | Files Generated | Errors | Generation Time (min) |
|---|---|---|---|---|---|
| 2024-06-01 | Alpha | Top Copper | 1 | 0 | 5 |
| 2024-06-01 | Alpha | Bottom Copper | 1 | 1 | 6 |
| 2024-06-02 | Beta | Top Copper | 1 | 0 | 4 |
| 2024-06-02 | Beta | Silkscreen | 1 | 0 | 3 |
| 2024-06-03 | Gamma | Top Copper | 1 | 2 | 7 |
| 2024-06-03 | Gamma | Bottom Copper | 1 | 0 | 5 |
| 2024-06-04 | Alpha | Silkscreen | 1 | 0 | 3 |
Dashboard Components
- KPI Card: Total Files Generated
Formula: SUM(Files Generated) = 7
Shows total Gerber files created in the period. - KPI Card: Total Errors
Formula: SUM(Errors) = 3
Shows total errors found during generation. - KPI Card: Average Generation Time (min)
Formula: AVERAGE(Generation Time) = (5+6+4+3+7+5+3)/7 = 4.71
Shows average time to generate a file. - Bar Chart: Files Generated by Project
X-axis: Project (Alpha, Beta, Gamma)
Y-axis: SUM(Files Generated)
Alpha=3, Beta=2, Gamma=2 - Stacked Bar Chart: Errors by Layer and Project
X-axis: Project
Y-axis: SUM(Errors)
Stack by Layer (Top Copper, Bottom Copper, Silkscreen)
Shows error distribution per layer per project. - Table: Detailed File Generation Records
Shows all columns from sample data for detailed review.
Dashboard Layout
+----------------------+----------------------+----------------------+ | Total Files Generated | Total Errors | Avg Generation Time | | [7] | [3] | [4.71] | +----------------------+----------------------+----------------------+ | Bar Chart: Files Generated by Project | | (Alpha, Beta, Gamma) | +---------------------------------------------------------------------+ | Stacked Bar Chart: Errors by Layer and Project | | (Project on X-axis) | +---------------------------------------------------------------------+ | Detailed File Generation Table | +---------------------------------------------------------------------+
Interactivity
Filter by Project: Selecting a project updates all KPIs, charts, and the table to show data only for that project.
Filter by Date Range: Limits data to selected dates across all components.
Layer Filter: Filters charts and table by selected PCB layers.
Self Check
If you add a filter for Project = 'Alpha', which components update?
- All KPI cards update to show totals and averages for Alpha only.
- Bar chart updates to show files generated only for Alpha.
- Stacked bar chart updates to show errors by layer for Alpha.
- Table shows only records where Project is Alpha.
Key Result
Dashboard shows Gerber file generation totals, errors, average time, and breakdown by project and layer.