How to organize a worksheet

[rebu1985]

Good morning,

I dont know if someone can help me with this topic.
I have create a worksheet organized by spaces to calculate areas, such us, buildable areas, useful areas, exterior areas. My question is if it is possible to organize them by columns because I have calculated them by rows but i would to simplify the worksheet. 

Sample of exterior areas:
 

Sample of buildable areas:


The idea is to have something like below because then I export as txt format and i can link to an excel file automatically:

[rebu1985]

The idea is to know if it is possible to combine in a cell of the database areas, classes and spaces in the same column but i couldnt do it. If i could fix them i think it is possible to do it.

[Pat Stanford]

What are the criteria of the two database sections?  If they are basically different subsets of the same type of object then we can get close to what your want.

 

The main difference will be that you will not be able to get sub-sections of sub-sections. So you will not be able to have one instance of Planta 01 and then one instance each of Escalera 1 and 2 inside of that. But you would be able to have Planta 01 and the 1 or 2 on each line individually (repeated for each subrow).

[rebu1985]

Hi guys,

I would like to organize in columns like below but i just can indicate the total area of each space. I would like that the 3rd column would be usabe area and the 4th the buildable area, for example. 



The criteria is this:


I was trying to make different formulas but they dont work:



 

[rebu1985]

hace 19 horas, Pat Stanford dijo:

What are the criteria of the two database sections?  If they are basically different subsets of the same type of object then we can get close to what your want.

 

The main difference will be that you will not be able to get sub-sections of sub-sections. So you will not be able to have one instance of Planta 01 and then one instance each of Escalera 1 and 2 inside of that. But you would be able to have Planta 01 and the 1 or 2 on each line individually (repeated for each subrow).

I dont know really need Escalera 1 and 2, it is another filter but it is not necessary, i just need the level and the letter. It was a sample about how i need to show the columns of the areas for each apartment.

[Pat Stanford]

So which field of the Space object contains the Usable Area and which contains the Buildable Area?  Or if these values are not in a field, how do you calculate those values based on the overall Area of the space which you do have?

[rebu1985]

Hi Pat, 

I am going to update here the file here. As you can see, the worksheet have differents rows and the 1-3 columns are repeating all time, and the only different is the area. On the excel file we show the areas in columns, so if i could do the same in the worksheet it would be easier to link the worksheet in txt file to an excel file.
Sample.vwx





 

Sample.vwx

[rebu1985]

As you can see, sometimes we dont have opened or covered terrace on the apartments. That is the point if it is going to be easier this worksheet without some of the areas. 
That was the reason of asking on the other topic to create other row showing as a zero the empty cell with the tool space and custom parameters.