Revit dynamo - Create topography from excel coordintes - example 1

0.Start

In this task, we have manually taken coordinates of the bottom of the lake by driving over the area we want to map, with a boat. Got a couple of hundreds of coordinates which was typed into excel (see picture 1)

In the right corner in the excel sheet, the global coordinates in our local origin are placed. Further, in sheet Ark2, we subtract the “boat” coordinates with the global coordinates in our local origin, to get more manageable numbers.

**1.Input**

We are now in dynamo, deciding the input variables.

**File path**, find the excel document where the coordinates are saved.

**String*** *represents the sheet name to use in the excel document, in this case, we want to use a sheet with the name Ark2.

x,y,z coordinate, and the number below represents the number of the column in excel, so 0 is column A, 1 is B, and 2 is C.

**2.Import XYZ coordinates from excel**

In this section, we import the coordinates and reorganize the coordinates in lists that are understandable for the next node. For example, the list that the node **Data.importExcel** is given us can’t be read by the node x-coordinate(**List.GetItemAtIndex**), its necessary to re-organize the list structure, so we use the node *List transpose* to do so. As picture 3 shows, the list is organized in a different manner.

**3.Create topography and import to Revit**

We have no reorganized the coordinates lists, it can now be used by the node **Topography.ByPoints** and create topography in Revit*, *but first, the coordinate list needs to run through the node **Point.PruneDuplicates **to remove duplicated coordinates.

**4. Conclusion**

Check out how to create a void topography here.