tables, actions, automation ?'s

[jms248]

First of all, I am new to this forum.

I am looking for a way to stream-line productivity of measuring points.

Currently working on monitoring surveys and have to show the movement of beams for the shoring walls.

The crew sets the benchmarks and every week goes back ties them in. I am currently measuring the horizontal, lateral, and vertical movement manually and then taking the numbers and typing them in excel.

is there a way to select the 2 points and it automatticaly insert the difference in a table?

Thanks for the help.

[tcorey]

Are the points just AutoCAD Points or are they Civil 3D points?

[jms248]

They are Civil 3D points

[tcorey]

If you convert the Civil 3D Points to regular blocks using CONVERTPOINTSTOSDSKPOINTS command (does not wipe out the c3d points) then I could write you a quick lisp routine that would allow you to pick two points and could place the data in a table. It might be a few days as we're busy this week.

Tim

[jms248]

What do you need from me, so you can write the LISP Routine? Ill have to research LISP Routines, I am not familiar with them.

[tcorey]

Just tell me what information you need in the table, provide a drawing with the table style included.

[tcorey]

There are several line objects near the benchmark, each on a layer called monitoring#####, where ##### is a date. These must represent the shots you've taken. Yes?

How do I know which end of each line represents the point coordinates, or is there some other way to tell? Whichever end is closest to the benchmark? The start point? The end point?

My thought was to give you a text file with the information comma delimited and then you import it as a csv into Excel. Will that work for you?

You only mention a difference in northing. The differences you show in your xls file...Are those only differences in Northing or are those distances? 

Tim

[Joe-Bouza]

Is the ATTIN ATTOUT functions of any use to this task?

[tcorey]

No, because his objects are either a circle or a line and I will have to collect the date from the end of the layer name. It's not a well-designed procedure they are using. No COGO points or even blocks at the locations. Just circles and lines. 

[jms248]

I exploded the points for this drawing. I do actually have points in the drawing.

I normally draw a line for horizontal (- or +) movement, and a line for Lateral (- or +) movement. I take a distance using (dist) and write down the movement. For most occassions the movement is plus or minus .01.

Some of our projects are getting to be time consuming due to the amount of points that need to be monitored.

Just looking for a way to streamline the data input to a table, whether it be a table inside of autocad, or a excel spread sheet.

I was thinking about creating a table style, label each line, then create a table.

[KirkNoonan]

Sounds like it would be quicker and easier to do the calculations in Excel and have the spreadsheet dynamically linked into the drawing.

[tcorey]

@jms248 wrote:

I exploded the points for this drawing. I do actually have points in the drawing.

---

Hello jms248,

It is difficult for me to create a solution unless you send me a drawing representatvie of what you are actually going to to use the program on. Please attach a representative drawing, not one that has been exploded.

Best regards,

Tim