I have managed to position and color sphere target elements into the revit model space based on an excel survey stakeout report. The spheres are modelled and colored based on whether the stakeout positions are within tolerance. In the excel sheet the columns list the point ID, easting, northing, elevation, yes or no whether it is in tolerance or not in position and height. It also specifies the exact dimensions / residuals relating to these points.
I am trying to write back in these residuals into the modelled element parameters. I have been successful in doing so, however, they do not match up (i.e. The wrong residuals are being written into the wrong elements).
Have you guys got any idea what would be the best way to match up the residuals to the newly created list of sphere element GUID’s within the model space?
Plate Check iCON Demo.xlsx (19.1 KB)
Hopefully the images attached will make what I am trying to achieve that little bit clearer.
Added note: The points positions in the excel sheet are in a national grid but the spheres modelled locations have been translated and rotated relative to the project base point.