AutoCAD

How to Plot Lot Bearing in AutoCAD Using Excel?

Understanding Lot Bearings in AutoCAD

Plotting lot bearings in AutoCAD requires a systematic approach to accurately represent land boundaries. This process can be simplified using Excel to organize data effectively. This guide will explain how to plot these bearings step by step.

Preparing Your Data in Excel

1. **Create a New Spreadsheet**: Open Excel and start a new workbook.
2. **Input Coordinates**: Label the first column as “Point” and subsequent columns as “Bearing” and “Distance”. Enter the lot points, their bearings, and corresponding distances in their respective columns.
3. **Calculate Endpoints**: For each bearing and distance, compute the endpoint coordinates. You may need to apply trigonometric functions (SIN, COS) to derive these points based on the angle and distance.

Setting Up AutoCAD for Plotting

1. **Open AutoCAD**: Launch AutoCAD 2025.
2. **Set Up Units**: Ensure that you are working in the correct unit of measurement (Imperial, Metric). Command input: `UNITS`.
3. **Create a New Drawing**: Click on ‘New’ to start a fresh project.

Importing Data from Excel into AutoCAD

1. **Copy Your Coordinates**: Highlight the endpoint coordinates in Excel, right-click, and select “Copy”.
2. **Utilizing the Command Line**: In AutoCAD, access the command line and type `POINT`, then hit Enter.
3. **Paste Coordinates**: Right-click in the command line area or use CTRL+V to paste your coordinates directly into AutoCAD.

Plotting the Lot Bearings

1. **Start with the First Point**: Identify your starting point. For example, if your first point is at coordinates (X1, Y1), plot this as your starting location.
2. **Use the Line Command**: Type `LINE` in the command line and hit Enter to initiate the plotting process.
3. **Input Subsequent Points**: Enter the coordinates of the next point by typing them directly after `LINE`, following the pattern: “@DistanceFinalizing the Plot

1. **Review Your Work**: Zoom in and out to verify that all points are accurately placed according to your lot boundaries.
2. **Save Your Drawing**: Don’t forget to save your work by pressing `CTRL+S` or by navigating to the File menu and selecting Save.

Using COGO in AutoCAD

1. **Access COGO Input**: Navigate to the “Home” tab, open the Draw panel, and select “COGO”.
2. **Select Bearing/Distance Routine**: Input the first point’s coordinates and define the angle and distance.
3. **Calculate and Create Points**: AutoCAD will compute and generate points based on the entered angles and distances. Click “Create Point” to finalize.

FAQs

How do I convert bearings to coordinates in AutoCAD?

To convert bearings into coordinate points, you will need the angle in degrees. Use trigonometric equations to find the X and Y coordinates based on the distance traveled in each direction.

Can I modify plotted bearings after they are created?

Yes, you can modify the bearings using commands or grips to move lines or points. Simply select the line or point and adjust its angle or coordinates as necessary.

Is it possible to automate this process further?

Yes, using tools such as AutoLISP or scripting in AutoCAD can automate the plotting process, making it more efficient, especially for large datasets.

About the author

Wei Zhang

Wei Zhang

Wei Zhang is a renowned figure in the CAD (Computer-Aided Design) industry in Canada, with over 30 years of experience spanning his native China and Canada. As the founder of a CAD training center, Wei has been instrumental in shaping the skills of hundreds of technicians and engineers in technical drawing and CAD software applications. He is a certified developer with Autodesk, demonstrating his deep expertise and commitment to staying at the forefront of CAD technology. Wei’s passion for education and technology has not only made him a respected educator but also a key player in advancing CAD methodologies in various engineering sectors. His contributions have significantly impacted the way CAD is taught and applied in the professional world, bridging the gap between traditional drafting techniques and modern digital solutions.