Construction geometry usage in Solidworks - Real Business Scenario

Scenario Mode

👤 Your Role: You are a design analyst at a manufacturing company using SolidWorks.

📋 Request: Your manager wants a report showing how construction geometry is used in recent part designs to improve design efficiency.

📊 Data: You have access to design metadata including part names, number of construction geometry elements used (lines, points, planes), and time taken to complete each design.

🎯 Deliverable: Create a dashboard showing the count of construction geometry elements per part and analyze the correlation with design time.

Sample Data

Part Name	Construction Lines	Construction Points	Construction Planes	Design Time (hours)
Bracket A	5	3	2	8
Bracket B	7	2	3	10
Gear C	4	4	1	7
Gear D	6	3	2	9
Lever E	3	1	1	6
Lever F	8	5	4	12
Plate G	2	2	1	5
Plate H	5	3	2	8

1

Step 1: Create a new table column 'Total Construction Geometry' by summing Construction Lines, Points, and Planes for each part.

Total Construction Geometry = Construction Lines + Construction Points + Construction Planes

Expected Result

Bracket A: 10, Bracket B: 12, Gear C: 9, Gear D: 11, Lever E: 5, Lever F: 17, Plate G: 5, Plate H: 10

2

Step 2: Create a bar chart with Part Name on the X-axis and Total Construction Geometry on the Y-axis.

X-axis: Part Name; Y-axis: Total Construction Geometry

Expected Result

Bar chart showing each part's total construction geometry count.

3

Step 3: Create a scatter plot with Total Construction Geometry on the X-axis and Design Time (hours) on the Y-axis to analyze correlation.

X-axis: Total Construction Geometry; Y-axis: Design Time (hours)

Expected Result

Scatter plot showing points clustered with a trend indicating if more construction geometry relates to longer design time.

4

Step 4: Calculate the correlation coefficient between Total Construction Geometry and Design Time.

Correlation = CORREL(Total Construction Geometry, Design Time)

Expected Result

Correlation coefficient approximately 0.95 indicating strong positive correlation.

5

Step 5: Summarize findings in a report section explaining how construction geometry usage relates to design time.

Write summary text based on charts and correlation result.

Expected Result

Parts with higher construction geometry counts tend to have longer design times, suggesting complexity increases design effort.

Final Result

Part Name       | Total Construction Geometry
--------------------------------------------
Bracket A       | ########## (10)
Bracket B       | ############ (12)
Gear C          | ######### (9)
Gear D          | ########### (11)
Lever E         | ##### (5)
Lever F         | ################# (17)
Plate G         | ##### (5)
Plate H         | ########## (10)

Scatter Plot:
X: Total Construction Geometry (5 to 17)
Y: Design Time (5 to 12 hours)
Points show upward trend

Correlation Coefficient: 0.95

✓Higher use of construction geometry elements correlates strongly with longer design times.

✓Lever F has the highest construction geometry count and the longest design time.

✓Simpler parts like Plate G and Lever E use fewer construction elements and have shorter design times.

✓Using construction geometry helps manage complex designs but increases design effort.

Bonus Challenge

Create a calculated measure to find the average design time per construction geometry element for each part and visualize it.

Show Hint

Divide Design Time by Total Construction Geometry for each part and create a bar chart to compare efficiency.