Gerber file generation in PCB Design - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Gerber File Layers

Which of the following Gerber file layers typically contains the copper traces on the top side of a PCB?

A Drill Drawing Layer (e.g., .drl file)

B Solder Mask Bottom Layer (e.g., .sbm file)

C Top Copper Layer (e.g., .gtl file)

D Silkscreen Bottom Layer (e.g., .smb file)

💡 Hint

Think about which layer shows the actual electrical paths on the top side.

The Top Copper Layer (.gtl) contains the copper traces on the top side of the PCB. Other layers like solder mask or silkscreen serve different purposes.

❓ dax_lod_result

intermediate

Calculating Total Gerber Files Generated

You have a table named GerberFiles with columns ProjectID and FileType. You want to calculate the total number of unique Gerber files generated per project. Which DAX measure correctly counts unique files per project?

A TotalFiles = CALCULATE(DISTINCTCOUNT(GerberFiles[FileType]), ALLEXCEPT(GerberFiles, GerberFiles[ProjectID]))

B TotalFiles = SUM(GerberFiles[FileType])

C TotalFiles = COUNT(GerberFiles[FileType])

D TotalFiles = DISTINCTCOUNT(GerberFiles[FileType])

💡 Hint

Remember to count unique files per project, ignoring filters except ProjectID.

Option A uses CALCULATE with ALLEXCEPT to count distinct FileType per ProjectID, which correctly counts unique files per project.

❓ visualization

advanced

Best Visualization for Gerber File Generation Status

You want to create a dashboard showing the status of Gerber file generation across multiple PCB projects. The statuses are: Pending, In Progress, and Completed. Which visualization type best shows the proportion of each status per project?

A Line Chart showing status changes over time

B Stacked Bar Chart showing counts of each status per project

C Scatter Plot showing file size vs. generation time

D Pie Chart showing total counts of statuses across all projects

💡 Hint

Think about comparing multiple categories per project side by side.

A stacked bar chart clearly shows the count of each status per project, allowing easy comparison of proportions.

🔧 Formula Fix

advanced

Debugging Gerber File Export Script

Given this pseudocode snippet for exporting Gerber files, which option explains why the export fails?

for layer in layers:
    if layer.name == 'TopCopper'
        export_gerber(layer)
    else
        continue

PCB Design

for layer in layers:
    if layer.name == 'TopCopper':
        export_gerber(layer)
    else:
        continue

A Missing colon after the if statement causes a syntax error

B The else statement is unnecessary and causes a runtime error

C The export_gerber function is called incorrectly without parameters

D The loop should iterate over files, not layers

💡 Hint

Check Python syntax carefully for control statements.

Python requires a colon after if statements. Missing it causes a syntax error preventing export.

🎯 Scenario

expert

Optimizing Gerber File Generation Workflow

Your PCB design team generates Gerber files for multiple projects weekly. The current process is manual and error-prone, causing delays. Which BI approach best helps identify bottlenecks and improve the workflow?

A Build a static report listing all Gerber files generated without timestamps or status details

B Send weekly email summaries without data visualization or interactive elements

C Use a pie chart to show the percentage of projects completed without tracking process steps

D Create a dashboard tracking file generation times, errors, and responsible team members with filters by project and date

💡 Hint

Think about what data helps find delays and errors clearly.

A dashboard with detailed tracking and filters allows the team to spot bottlenecks and assign responsibility, enabling process improvements.