I have a long pipeline which I am modeling. Our client sent us a table of northing coordinates which locates each node on the pipeline (each point represents the end of a spool/section of pipe). If I convert these coordinates into delta X,Y, and Z measurements is there a way for Caesar to import these numbers so I don't have to do it manually?

Hi bpeer

Go to "Edit"-"Global" then enter global co ordinate there for the first node.


Regards

Habib

hi Bpeer

I think Habib has mis-understood the question.

We have similar issues when we design cross country pipelines (perhaps 2km) and we have the co-ordinates of all the changes in direction and loops etc, but have not found a way to import the dx dy dz values into CAESAR II. In the end we just have an excel spreadsheet setup to work out all the dx dy dz values and then hard type it all in. Clunky, but doesn't actually take too long.

It would be really nice to be able to cut and past these valves from excel into the elements page.

If one else knows a much better way I would love to hear about it as well.

I believe that if you use CADWorx you can extract the excel data into CADWorx and then import into Caesar. Unfortunately we are don't have that capability.

Sadly we don't that capability either, (and I imagine I would be hitting my head against a brick wall to try and get it).

you could use excel to create text formatted for a neutral file.

Create a neutral file for the first few nodes, then use that to figure out what text strings you need to make with coordinates for each node.

Then copy paste in the .cii which is just a text file.

If you do a lot of these you could even write a vb macro in excel to auto generate pipeline models.