If you can download
THIS zip file and have a little knowledge of MS Access 2000 then you can accomplish the task by following these steps. This will generate Caesar neutral file which can be imported in Caesar by Caesar II Neutral File Interface
1- Extract the file in a temporary folder.
2- Open your excel file and arrange your data in the following format
Element No: A sequential No
From Node
To Node
DX, DY, DZ
Pipe Ends: This is the end type of To Node. Allowed entries are Pipe, Elbow or Tee
Pipe Support: Type of Support at To Node. Allowed entries are "+Y", "Guide", "Line Stop" or keep it blank if no support at To Node
3- Select the excel data and Copy it by Edit-->Copy
4- Open the extracted file
Dwg 2 CII.mde in Access 2000. A form will appear
5- Click the button "Open Table" in the form
6- Select the first row of the opened table by clicking the Row Selecting Arrow and paste the copied data by Edit-->Paste. Your Excel data should now be in the table
7- Click the form "Import Route". The same form will appear again.
8- Click button "Make Neutral File"
9- Give a temporary name for the neutral file to be generated. Include the suffix .Cii in the file name
10- Import the generated neutral file in Caesar by Caesar II Neutral File Interface
11- Caesar File will contain following
Dx, Dy, Dz as specified
Type 1 Bends at specified node
Type 3 Tees at specified nodes
+Y, Guide or Line Stop with COF 0.3 at specified nodes
Remaining data will have to be input manually