Create drainage pipe network from excel data


#1

Hi, was wondering if Dynamo can create a pipe network from excel data (attached). The data looks like this:
<table width=“754”>
<tbody>
<tr>
<td width=“64”>XCoord</td>
<td width=“64”>YCoord</td>
<td width=“64”>ZCoord</td>
<td width=“64”>StrNumber</td>
<td width=“76”>Type</td>
<td width=“64”>Owner</td>
<td width=“71”>Description</td>
<td width=“98”>Diameter_Width</td>
<td width=“42”>Height</td>
<td width=“83”>z Justification</td>
<td width=“64”>Thickness</td>
</tr>
<tr>
<td>4087.198</td>
<td>2459.792</td>
<td>5.393</td>
<td>1</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Box Culvert</td>
<td>2.2</td>
<td>1.3</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>4099.064</td>
<td>2499.548</td>
<td>5.79</td>
<td>1</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Box Culvert</td>
<td>2.2</td>
<td>1.3</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>4099.064</td>
<td>2499.548</td>
<td>5.79</td>
<td>1</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Box Culvert</td>
<td>2.2</td>
<td>1.3</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>3999.22</td>
<td>2757.101</td>
<td>8.435</td>
<td>1</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Box Culvert</td>
<td>2.2</td>
<td>1.3</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>321035.3</td>
<td>5812591</td>
<td>5.2</td>
<td>2</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Pipe</td>
<td>1.2</td>
<td> -</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>320996.9</td>
<td>5812691</td>
<td>5.3</td>
<td>2</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Pipe</td>
<td>1.2</td>
<td> -</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
</tbody>
</table>
I would very much appreciate your help.

DRAINAGE_OP1_Revit

Regards,

Chris


#2

And I cant edit my post (delete the table) for some reason.


#3

Hi Chris,

could you elaborate? Are the points in the file connected to each other? Or is it more element based, like a Box culvert component with centerpoint at X,Y,Z?


#4

Thanks Jostein,

The xyz represent the centreline of a box culvert. z represents the bottom of it. The StrNumber represents the culvert. ie in this case there are 2 culverts, 1 is defined by 4 centreline points, 2 is represented by 2 centreline points.