Creating Curves In Zwcad Quickly With Excel

By Author: Karl Lundberg
Total Articles: 2
Comment this article

In surveying and mapping, we get coordinates by taking measurements in the field, and then we make curves from these coordinates. To draw the curves in ZWCAD, we have to input the coordinates one by one at the command line, unfortunately. When there are many coordinates, then it becomes inefficient to draw curves in this way; in any case, this form of manual input is prone to making mistakes.

Now there is an easier way to draw these kinds of curves by using ZWCAD and Excel together. This makes the task efficient and more precise. Here are the steps to carrying this out.

1. First, enter the coordinates into a spreadsheet, such as Excel or LibreOffice. In the figure below, column B contains the x coordinates and column C contains the y coordinates.

2. Next, define column D as "Point (X , Y)."

3. Input the following formula in cell D2:
"=B2","&C2"

4. Copy the formula to all rows by dragging the cell down the column, as shown by the following picture. ...
... When you are done, the x,y coordinates are generated automatically in column D.

5. Now switch over to ZWCAD, and then start Spline command to begin drawing the curve.

6. When the Spline command prompts you, "First point for spline," copy the x,y coordinate from cell D2 to the last one in the Excel document, and then paste them in the command line in ZWCAD. As you do, the spline will be created automatically, as shown by the figure below.

This method using ZWCAD with Excel makes it easy to quickly create the measured curves with x,y coordinates, but without making mistakes -- no matter how many points you have to input.

About ZWCAD
ZWCAD(TM) is a cost-effective, DWG file format compatible CAD solution which provides innovative, collaborative and customizable features for both the AEC and MCAD industries. The unrivalled compatibility and friendly user interface lets users begin working with ZWCAD immediately with little to no training. ZWCAD is popular in over 80 countries with more than 180,000 users.