Under-defined vs fully-defined vs over-defined in Solidworks - Business Scenario Comparison

Scenario Mode

👤 Your Role: You are a mechanical design analyst working with SolidWorks models.

📋 Request: Your manager wants a report explaining the difference between under-defined, fully-defined, and over-defined sketches in SolidWorks, using data from recent design projects.

📊 Data: You have data on 10 sketches from recent projects, showing the number of constraints applied and the sketch status (under-defined, fully-defined, over-defined).

🎯 Deliverable: Create a dashboard that shows the count of sketches by definition status and explains the meaning of each status with examples.

Sample Data

Sketch ID	Project	Constraints Applied	Sketch Status
SK001	Project A	3	Under-defined
SK002	Project A	5	Fully-defined
SK003	Project B	7	Over-defined
SK004	Project B	4	Under-defined
SK005	Project C	6	Fully-defined
SK006	Project C	8	Over-defined
SK007	Project D	5	Fully-defined
SK008	Project D	3	Under-defined
SK009	Project E	7	Over-defined
SK010	Project E	5	Fully-defined

1

Step 1: Create a pivot table with Rows = Sketch Status, Values = Count of Sketch ID

Use Sketch Status as row labels and count Sketch ID for values

Expected Result

Under-defined: 3, Fully-defined: 4, Over-defined: 3

2

Step 2: Create a bar chart visualizing the count of sketches by Sketch Status

X-axis: Sketch Status, Y-axis: Count of Sketch ID

Expected Result

Bar chart showing Under-defined=3, Fully-defined=4, Over-defined=3

3

Step 3: Add text boxes explaining each Sketch Status with simple definitions and examples

Under-defined: Sketch has too few constraints, parts can move freely. Fully-defined: Sketch has just enough constraints, parts are fixed. Over-defined: Sketch has conflicting or too many constraints, causing errors.

Expected Result

Clear explanations visible on the dashboard

4

Step 4: Combine the pivot table, bar chart, and explanations into a single dashboard report

Arrange visuals and text for easy reading and understanding

Expected Result

Dashboard showing counts and clear definitions side by side

Final Result

Under-defined

↓

Fully-defined

↓

Over-defined

✓Most sketches are fully-defined, which is ideal for stable designs.

✓Under-defined sketches lack enough constraints and can cause parts to move unexpectedly.

✓Over-defined sketches have conflicting constraints and need correction to avoid errors.

Bonus Challenge

Create a calculated measure that shows the percentage of sketches in each status category.

Show Hint

Use the formula: (Count of sketches in status / Total sketches) * 100