Connect Wall and Rooms Schedule

Hi!
I’m trying to solve a problem about linking data from different schedules: rooms and walls.
What I want to achieve it is a schedule which will give me a data about the total value of rooms and walls in a certain apartment.

Rooms
are described in the following way:
Department: A
(like building A, B, C etc.)
Occupancy: A.1.1; A.2.1
(where A - building, A.1. apartments on the first floor)
Number: A.1.1.1; A.1.1.2.
(where the last digit is for the room number)
Name : Hall, Kitchen etc.

Walls
are described in the following way, because I am interested in only the area of the one of wall type:
Type: Generic_Calculate
Description: Demontaż
Comments: A.1.1
(to know in which apartment I have these walls)
Area Length Unconnected Height etc.
Also Calculated Parameter to get the area:
(Area/Unconnected Height)Width [m2]
(Length
Width) [m2]
Two different way to check the results. But both results are not the same as my own calculations have shown.

I need to export the data to Exel file and then import to Revit.
However, I have problems with:

  • exporting parameters form selected wall type
  • sum all areas from one of the apartments like A.1.1
  • connect the total value of rooms area with the total value of walls area

Unfortunately, I cannot enclose my Revit file Dynamo file and any images as a new user ;/

Post the dyn/rvt/etc to another service like dropbox/google drive/a360/etc. Images would also help as I (and certainly others) are somewhat lost in the desired output. For image hosting imgur might work, which I believe is free to use.

You’re right, thanks!
Here you’ll find the files:
https://drive.google.com/open?id=0B2FTj_5voQgCd0VVQWxWVTEyOGs