# Comparing Room Number and Area parameter values with excel spreadsheet

**URL:** <https://forum.dynamobim.com/t/comparing-room-number-and-area-parameter-values-with-excel-spreadsheet/25144>\
**Category:** Uncategorized\
**Created:** [August 23, 2018, 12:38pm UTC](https://forum.dynamobim.com/t/comparing-room-number-and-area-parameter-values-with-excel-spreadsheet/25144 "2018-08-23T12:38:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anders\_Haugaard](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/anders_haugaard/32/39300_2.png) [@Anders\_Haugaard](https://forum.dynamobim.com/u/Anders_Haugaard)\
**Post date:** [August 23, 2018, 12:38pm UTC](https://forum.dynamobim.com/t/comparing-room-number-and-area-parameter-values-with-excel-spreadsheet/25144/1 "2018-08-23T12:38:11Z")

</div>

Hi guys!  
I need to compare room numbers and areas from an external excel spreadsheet. I was hoping to get a True/False list as result - does the room number appear in the model, and does it have the same area value? I have to use Room Number as ID, because the index lists do not match - see attached

Is it also possible to create a True/False data marked with a color for each comparison? Or is it just easier in excel. This would help me with a good overview.

I have now imported, filtered and sorted the data that I want to work with, but now I am stocked. Is my work until now ok? And how do I get started with the comparison, and export.

Thank you guys!

[RoomCHECK.dyn](https://forum.dynamobim.com/uploads/short-url/fVxQKn1sJf6Q3Jh8u0rAESMm554.dyn) (38.2 KB)

 ![CaptureRoomCheck](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/a/bacfdadd6da5016ca1c2a35276dc2bbb9de8234f.png)

 ![Comparison](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/5/75a4d8a776e8a5ccb0c39df014eef010f82b179b.png)

---

<div class="post-metadata">

**Author:** ![m.rijsmus](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@m.rijsmus](https://forum.dynamobim.com/u/m.rijsmus)\
**Post date:** [August 23, 2018, 2:21pm UTC](https://forum.dynamobim.com/t/comparing-room-number-and-area-parameter-values-with-excel-spreadsheet/25144/2 "2018-08-23T14:21:07Z")

</div>

> [@Compare Revit element parameter values with Excel list values](https://forum.dynamobim.com/t/compare-revit-element-parameter-values-with-excel-list-values/6545):
>
> Hi. I’m new to Dynamo and I need a bit of help. I have multiple family elements in Revit with filled certain parameter (‘magi\_ov1’ for my case) values. I also have a list of these same values in Excel file (in column A). Column B contains different information about each item. I want to transfer this Column B information to corresponding Revit element (by comparing ‘magi\_ov1’ values with excel Column A values). The information should be written to different parameter (‘magi\_ov2’ in my case). …