I’ve been working on a script to have Dynamo read an excel file with as-buit piles and have them show up in green and red in Revit when they are within or over a set distance from the designed pile.
I thought it worked. Well…it did in my test project with 6 piles and about a meter (X and Y) away from the Project Base Point and the Survey Point. These two, in my test project, are in the same place.
But the true test comes when one is using the script on a real life project.
So before I wanted to do that I thought…let’s get the coördinates from the designed piles and export them to Excel. So I can check if the benchmark is correct. To my surprise the coordinates aren’t even close to the ones in the list the contractor provided.
It turns out that the coordinates I send to excel have the Project Base Point as 0,0,0.
But when I use “Annotate -> Spot Coordinate” in Revit I get the correct coordinates because that uses the Survey Point as 0,0,0.
So my current script is related to the Project base Point…How can I change it so it is related to the Survey Point?
Here’s part of my script that needs to be changed somehow…I guess.