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.
- 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.
- Next, define column D as “Point (X , Y).”
- Input the following formula in cell D2:”=B2”,”&C2”
- 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.
- Now switch over to ZWCAD, and then start Spline command to begin drawing the curve.
- 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.
