# Mech Equipment Schedule

**URL:** <https://forum.dynamobim.com/t/mech-equipment-schedule/45095>\
**Category:** Revit\
**Tags:** revit, excel\
**Created:** [January 5, 2020, 3:16am UTC](https://forum.dynamobim.com/t/mech-equipment-schedule/45095 "2020-01-05T03:16:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bravia](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@Bravia](https://forum.dynamobim.com/u/Bravia)\
**Post date:** [January 5, 2020, 3:16am UTC](https://forum.dynamobim.com/t/mech-equipment-schedule/45095/1 "2020-01-05T03:16:36Z")

</div>

Hi All,

New to dynamo. Working on preparing dynamo code to export/import mech equipment schedules into spreadsheet and implement this into daily workflow. There were numerous posts that I have seen. Got couple of questions:

- Can we use Element ID to import excel info back into Revit or do we require GUI ID?
- Need some pointers to prepare code to import i.e. the code should be able to update any information irrespective of where the info is updated.

FYI the code to export the schedule into spreadsheet along with element ID.

 ![Export](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/3/6390ca2fd10478d29c0784435ea6e7bc5a962903.jpeg)

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [January 5, 2020, 3:34am UTC](https://forum.dynamobim.com/t/mech-equipment-schedule/45095/2 "2020-01-05T03:34:06Z")

</div>

> [@Bravia](#):
>
> Can we use Element ID to import excel info back into Revit or do we require GUI ID?

GUID will not change over time. Element ID can.

> [@Bravia](#):
>
> Need some pointers to prepare code to import i.e. the code should be able to update any information irrespective of where the info is updated.

Import is much like export - once you have the data from excel in Dynamo, use the GUID or Element ID to get the items, and use the parameter names (headings unles you renamed them) to set parameter values.

---

<div class="post-metadata">

**Author:** ![Bravia](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@Bravia](https://forum.dynamobim.com/u/Bravia)\
**Post date:** [January 5, 2020, 4:09am UTC](https://forum.dynamobim.com/t/mech-equipment-schedule/45095/3 "2020-01-05T04:09:50Z")

</div>

> [@jacob.small](#):
>
> GUID will not change over time. Element ID can.

So you would recommend GUID ? if so I will amend the code

---

<div class="post-metadata">

**Author:** ![Bravia](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@Bravia](https://forum.dynamobim.com/u/Bravia)\
**Post date:** [January 6, 2020, 5:49am UTC](https://forum.dynamobim.com/t/mech-equipment-schedule/45095/4 "2020-01-06T05:49:51Z")

</div>

Hi All,

Attached the updated code and excel images. The challenge is the exported excel is not properly arranged. Any pointers greatly appreciated.

 ![B](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/3/f3cd53fb882fe96c5671ab203c8dede89e9d6e7d.jpeg)

 ![Excel](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/4/14c740b5504c351bf266bd45557c0a6683d0e0d5.jpeg)