how to create cutting & filling measurement sheet AutoCAD to excel

Understanding parts lists is essential for organizing and managing the components required for a project. In the context of engineering, construction, and manufacturing, a parts list (also known as a Bill of Materials or BOM) is a comprehensive list of raw materials, components, and assemblies needed to construct, manufacture, or repair a product or project.

### Components of a Parts List

1. **Item Number**:
- Unique identifier for each part.
- Helps in tracking and referencing parts easily.

2. **Part Name/Description**:
- Detailed description of the part.
- Includes specifications such as dimensions, material, and any other relevant characteristics.

3. **Quantity**:
- Number of each part required.
- Essential for ordering and inventory management.

4. **Part Number/Code**:
- Manufacturer's or supplier's unique code for the part.
- Useful for ordering and ensuring the correct part is used.

5. **Supplier Information**:
- Details of the supplier or manufacturer.
- Includes contact information and possibly pricing.

6. **Unit of Measure**:
- How the part is measured (e.g., pieces, meters, kilograms).
- Important for ordering the correct amount.

7. **Cost**:
- Unit cost of each part.
- Used for budgeting and cost management.

8. **Notes/Comments**:
- Any additional information relevant to the part.
- Could include assembly instructions, special handling requirements, or substitution options.

### Creating a Parts List in AutoCAD

AutoCAD offers features to create and manage parts lists, particularly useful in CAD drawings for engineering projects.

#### Step-by-Step Guide to Creating a Parts List in AutoCAD

1. **Draft the Drawing**:
- Complete the drawing with all the necessary components and parts.
- Use commands like `LINE`, `CIRCLE`, `POLYLINE` to draw the components.

2. **Insert Blocks for Components**:
- Use the `BLOCK` command to create reusable components.
- Each block should represent a different part.

3. **Annotate the Drawing**:
- Use the `TEXT` or `MTEXT` commands to label parts.
- Include details such as part names, numbers, and descriptions.

4. **Create an Attribute Block**:
- Use the `ATTDEF` command to define attributes for blocks.
- Attributes can include part number, description, quantity, and any other relevant information.

Example:
```
ATTDEF
Enter the Tag: PART_NO
Enter the Prompt: Enter Part Number:
Enter the Default: 1234
Specify insertion point: (click or type coordinates)
```

5. **Insert Attribute Blocks**:
- Insert the blocks with attributes into the drawing.
- Use the `INSERT` command and fill in the attribute values as prompted.

6. **Extract Attributes to Create the Parts List**:
- Use the `DATAEXTRACTION` command to extract block attributes to a table.
- Follow the Data Extraction wizard to select the blocks and attributes you want to include in your parts list.

Example:
```
DATAEXTRACTION
S