﻿ Creating Curves in ZWCAD Quickly with Excel - ZWCAD Technical Support | CAD Free Support - ZWSOFT.com

## Forum Recent Posts

### Intro to ZWCAD+ Design Center Color issues on PDF plotting Printing from ZWCAD to PDF problems How to print a multi-page PDF from ZWCAD? How to batch Plot to plot files or PDF's? Why the dots only appear on the vertices of polylines? How to Create Custom Linetype How to Draw a Cone with Round Top and Square Bottom Use Polar Tracking in ZWCAD How to Hatch Efficiently in ZWCAD Improvements To Paper Space Creating Boundary Polylines

Creating Curves in ZWCAD Quickly with Excel

July 11, 2012

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 curves by using ZWCAD with Excel . 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.

Print PDF