how to count a part of the wall area.

[Amarin]

Hello

I need to count the wall areas inside a house that will be painted. I don't understand how to get the right numbers. If I make a filter for the table for the walls it count all the height of the wall including the part that is over ceiling and under the floor. I tried to use wall layers with materials, and make a filter for the material. That worked well on one hand, and show the right area, but it also shows all the other materials in scene, and I can't filter them by classes, or floors or by any other data. Can smw give an advice how it is better to do this? 

[Tom W.]

3 minutes ago, Amarin said:

Hello

I need to count the wall areas inside a house that will be painted. I don't understand how to get the right numbers. If I make a filter for the table for the walls it count all the height of the wall including the part that is over ceiling and under the floor. I tried to use wall layers with materials, and make a filter for the material. That worked well on one hand, and show the right area, but it also shows all the other materials in scene, and I can't filter them by classes, or floors or by any other data. Can smw give an advice how it is better to do this? 

 

I would do it using Materials + it's not difficult but be easier to help if you posted a small sample file.

[Amarin]

19 minutes ago, Tom W. said:

 

I would do it using Materials + it's not difficult but be easier to help if you posted a small sample file.

Thank you for the help. So I made a small scene, with walls that have 2 finish materials on 2 sides wich I need to count. One side outside is full painted and the inside it is partly painted. Also I put few random objects to scene with materials. And I made a table for materials. As I said before it shows all the materials in scene, but I need only the 2 finishes of the wall. 

Test scene.vwx

[Tom W.]

See Test scene_TW.vwx

 

I've created a new spreadsheet worksheet which is looking for named Materials only rather than all the Materials in the file which is what your database report is doing. I've also made it so it's only looking for those Materials when they are used on Walls: I created two new objects which are using the 'Rot M' + 'Beige M' Materials but as you can see the worksheet is ignoring those objects.

 

This is how I report on Materials. I have a 'master' worksheet containing all my Materials which is saved in Favorites. I just import it into my files + delete the redundant rows.

 

This also gives you more flexibility when it comes to performing additional calculations in that you can do different things with different Materials depending on what they represent i.e. in your case you might want to convert m2 to litres of paint based on the manufacturer's coverage info, add a % for wastage then convert that into tins of paint. You can include completely different materials/products in the subsequent rows + apply a completely different set of calculations e.g. you might want to work out quantity of sheets of plywood or whatever. Or the next Material you might want to return volume rather than area. Etc etc

[Amarin]

On 11/22/2024 at 4:26 PM, Tom W. said:

See Test scene_TW.vwx

 

I've created a new spreadsheet worksheet which is looking for named Materials only rather than all the Materials in the file which is what your database report is doing. I've also made it so it's only looking for those Materials when they are used on Walls: I created two new objects which are using the 'Rot M' + 'Beige M' Materials but as you can see the worksheet is ignoring those objects.

 

This is how I report on Materials. I have a 'master' worksheet containing all my Materials which is saved in Favorites. I just import it into my files + delete the redundant rows.

 

This also gives you more flexibility when it comes to performing additional calculations in that you can do different things with different Materials depending on what they represent i.e. in your case you might want to convert m2 to litres of paint based on the manufacturer's coverage info, add a % for wastage then convert that into tins of paint. You can include completely different materials/products in the subsequent rows + apply a completely different set of calculations e.g. you might want to work out quantity of sheets of plywood or whatever. Or the next Material you might want to return volume rather than area. Etc etc

hello. Your worksheet looks fine, but I don't understand how you deleted the extra rows and columns and how you excluded the extra object from it. When I try to do this, it clears all. Mb there is a Video in Vectorworks University explained this? From your explanation, It shouldn't be difficult, but it is not intuitive at all and VW lack "how to" videos on Youtube.  

Edited November 25, 2024 by Amarin

[Tom W.]

Your Worksheet is a Database Report as indicated by the sub rows on the left hand side:

 

 

Mine is a Spreadsheet Report where each cell is independent. To create a new Spreadsheet Report, either right-click in the Resource Manager + select New Resource > Worksheet... or double-click to open the 'Create Resource' dialog + select 'Worksheet'.

[Amarin]

10 minutes ago, Tom W. said:

Your Worksheet is a Database Report as indicated by the sub rows on the left hand side:

 

 

Mine is a Spreadsheet Report where each cell is independent. To create a new Spreadsheet Report, either right-click in the Resource Manager + select New Resource > Worksheet... or double-click to open the 'Create Resource' dialog + select 'Worksheet'.

it is clear how to make an empty worksheet:)) you added the formulas just by hand to each sell, without using the automatic filtering etc? 

[Tom W.]

2 minutes ago, Amarin said:

it is clear how to make an empty worksheet:)) you added the formulas just by hand to each sell, without using the automatic filtering etc? 

 

You can select a cell then go to Insert menu > Function... or Criteria...

 

Or you can open up the Material Take-off by Category - Spreadsheet preformatted report + adapt that or copy/paste formulae from it into a new worksheet.

 

Re Worksheet tutorials there is one on the University by @michaelk:

 

plus you could seek out @Jonathan Pickup's videos which I think are very good on the subject.

[Amarin]

1 minute ago, Tom W. said:

 

You can select a cell then go to Insert menu > Function... or Criteria...

 

Or you can open up the Material Take-off by Category - Spreadsheet preformatted report + adapt that or copy/paste formulae from it into a new worksheet.

 

Re Worksheet tutorials there is one on the University by @michaelk:

 

plus you could seek out @Jonathan Pickup's videos which I think are very good on the subject.

Ok, got it. Thank you very much for the help. 

[Amarin]

30 minutes ago, Tom W. said:

 

You can select a cell then go to Insert menu > Function... or Criteria...

 

Or you can open up the Material Take-off by Category - Spreadsheet preformatted report + adapt that or copy/paste formulae from it into a new worksheet.

 

Re Worksheet tutorials there is one on the University by @michaelk:

 

plus you could seek out @Jonathan Pickup's videos which I think are very good on the subject.

sorry, one more question - is it possible to add the the floor (story) filter to this formula you made? I'm trying to do it, but it doesn't work.

[Tom W.]

8 minutes ago, Amarin said:

sorry, one more question - is it possible to add the the floor (story) filter to this formula you made? I'm trying to do it, but it doesn't work.

 

Doesn't something like this work?:

 

=MATERIALSURFACEAREA((STO='Story-1') & (T=WALL), A8)

[Amarin]

On 11/25/2024 at 11:51 AM, Tom W. said:

 

Doesn't something like this work?:

 

=MATERIALSURFACEAREA((STO='Story-1') & (T=WALL), A8)

unfortunately no. 

[Tom W.]

7 minutes ago, Amarin said:

unfortunately no. 

 

Not sure why because it works at this end... 🤷‍♂️

[Amarin]

40 minutes ago, Tom W. said:

 

Not sure why because it works at this end... 🤷‍♂️

I found the problem, my story had '.' in the name. I tried to make formula for other one, that doesn't have it, and it worked. So I need to rename the floors to make it work. Thnx one more time, you helped a lot.