# Difficulties in placing elements based on coordinates **URL:** \ **Category:** Revit\ **Tags:** revit, excel\ **Created:** [July 30, 2018, 11:35am UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276 "2018-07-30T11:35:48Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [July 30, 2018, 11:35am UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/1 "2018-07-30T11:35:48Z")
Hi, I tried to fetch clash points from Navisworks to use it to indicate them in Revit using Dynamo, Excel clash points: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/c/bc436f686d14f321733df036945bfaac80198e4d.png) Dynamo Script: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/8/c8e22bef497efdced0735ccdaf530c28e78f1d1f.jpg) Can you guys help me out to identify what went wrong in the script, coz I see the allthe family types are located far away Snip: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/1/21b887aeea8d27c608ec25556df8eaf1f81a7c78.jpg) ---
**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\ **Post date:** [July 30, 2018, 11:48am UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/2 "2018-07-30T11:48:06Z")
Are you working with linked files ? If so, you may need to use a coordinate system with transform. ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 23, 2019, 2:48pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/3 "2019-03-23T14:48:02Z")
@Alban_de_Chasteigner Excatly what node should I use to transform my coordinate system Currently my survey point is set to zero and base point is set to some value. ---
**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\ **Post date:** [March 23, 2019, 5:20pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/4 "2019-03-23T17:20:17Z")
Hi, You can try the _Convert Point in Coordinate Systems_ node to convert the coordinates. ![Convert%20Point%20in%20Coordinate%20Systems](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/0/304417272369050fc7e9813b685893d545d71851.png) ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 23, 2019, 5:27pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/5 "2019-03-23T17:27:47Z")
@Alban_de_Chasteigner ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/8/2891b204cf0b841d5b083fda18f33962fb061910.png) Still get error? I tried to get values from excel in meters, unit systems in revit is set to meters as well. ---
**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\ **Post date:** [March 23, 2019, 5:29pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/6 "2019-03-23T17:29:17Z")
Can you show the previews under the nodes. You have null under the _Point.ByCoordinates_ node. ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 23, 2019, 5:33pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/7 "2019-03-23T17:33:17Z")
[try.dyn](https://forum.dynamobim.com/uploads/short-url/nfBRgBhCzG1OBHRI0uklrfc9N6q.dyn) (37.7 KB) [New Microsoft Excel Worksheet.xlsx](https://forum.dynamobim.com/uploads/short-url/kd1h8oMxhzMWWs9le8Q9W0pZiYD.xlsx) (9.7 KB) ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 23, 2019, 5:35pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/8 "2019-03-23T17:35:09Z")
![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/1/51f75fe1163f03974a20162f6ebdd29d9ccb7de0.png) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/5/951fac86e66f07be558cb4d0c1c7e4151093da17.png) ---
**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\ **Post date:** [March 23, 2019, 5:39pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/9 "2019-03-23T17:39:01Z")
It is working for me. Note that the name of your worksheet is Ark1 and not Sheet1. ![WorkSheetName](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/8/d8b8d3acd172dfd4325a64093e882ff9d7958ae3.jpeg) ![Convert%20Point%20in%20Coordinate%20Systems](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/e/6e3b54581f569cc7ab897ec47981c4ae22b70c11.png) ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 23, 2019, 5:45pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/10 "2019-03-23T17:45:12Z")
![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/8/d8ecc6da15a5121e1d53d20e055ceb2176f7501d.png) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/5/65fecd518065adf1b1579966070573bda1957edb.png) When trying with base point ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/c/4c27d14cdc56364931c9863a6367604916335d3a.png) ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 23, 2019, 5:46pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/11 "2019-03-23T17:46:37Z")
Thanks Now i could get values, but I need all my elements close to project as all my model elements refer project base point. ---
**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\ **Post date:** [March 23, 2019, 5:48pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/12 "2019-03-23T17:48:39Z")
Can you send a sample file with your project base point, the building footprint and your clash point family ? ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 23, 2019, 5:58pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/13 "2019-03-23T17:58:36Z")
Mailed you a sample file. ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 23, 2019, 8:01pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/14 "2019-03-23T20:01:13Z")
clash point family is basically a sphere. ---
**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\ **Post date:** [March 23, 2019, 9:08pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/15 "2019-03-23T21:08:10Z")
Not sure if the points should be rotated. ![Coordinates](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/0/208695668365403f46cb140a5a8c53dd0a5d356b.png) ![Coordinates%202](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/c/3c3b2278defbc13e17714af873d75c2d57b9d796.jpeg) [try2.dyn](https://forum.dynamobim.com/uploads/short-url/ezB4cC0He4AyBipYP8ag95qoE9h.dyn) (144.8 KB) ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 24, 2019, 9:41am UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/16 "2019-03-24T09:41:11Z")
Dear @Alban_de_Chasteigner it works perfect, can you explain me why we need to subtract the base point from the excel values ? ---
**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\ **Post date:** [March 24, 2019, 10:06am UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/17 "2019-03-24T10:06:42Z")
The instances are placed relative to the origin of the base point of the project and not with respect to coordinates whose origin is the survey point. Subtraction calculates points whose coordinate system is the project base point. ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 24, 2019, 11:29am UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/18 "2019-03-24T11:29:52Z")
@Alban_de_Chasteigner thanks for your time in helping me understand the the problem. Looking forward to learn from you more 🙂 ---
**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\ **Post date:** [March 25, 2019, 5:55pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/19 "2019-03-25T17:55:22Z")
@Alban_de_Chasteigner I think I need to rotate it by 6.2 degrees clockwise, it seems I doesnt with with other models, You are right, what should be the node that i use to rotate ? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/0/109498806af7ab0d19917185ff9e29cfb009c002.png) ---
**Author:** ![Alban\_de\_Chasteigner](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alban_de_chasteigner/32/39650_2.png) [@Alban\_de\_Chasteigner](https://forum.dynamobim.com/u/Alban_de_Chasteigner)\ **Post date:** [March 25, 2019, 5:58pm UTC](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276/20 "2019-03-25T17:58:42Z")
The _Geometry.Rotate_ node can rotate yours points. [Next page](https://forum.dynamobim.com/t/difficulties-in-placing-elements-based-on-coordinates/24276.md?page=2)