Hi,
yes sure I can do that. But it is pretty simple and straight forward.
I have build the complete construction of the planning for a camper into freecad. So this is an assemby of "boxes", which are all the plates of the planned furniture. Then I looked for a solution to collect all these pieces with their length, width and heights to calculate the total amount of wood I need and so get the total weight of the interior construction.
So I found this reporting workbench and put the reporting statement:
Code: Select all
SELECT Label, Length, Width, Height
FROM document
WHERE Length IS NOT NULL
This gives a result table like:
Code: Select all
=Label Length Width Height
Boden =3600mm =2040mm =52mm
Seite links =3600mm =40mm =2192mm
Seite rechts =3600mm =40mm =2192mm
Seite hinten =40mm =2040mm =1960mm
Seite vorne =40mm =2040mm =1500mm
Seite Alkoven Top =40mm =2040mm =670mm
Sitz_Wand001 =16mm =650mm =634mm
Sitz_Wand002 =16mm =650mm =634mm
Bodenplatte Sitz =800mm =660mm =16mm
Sitz_Wand_L =800mm =16mm =634mm
Sitz_Wand_R =800mm =16mm =634mm
Sitz_Trennwand =16mm =1960mm =634mm
This I then took to Excel and made some calculations.
- removed the mm and make the fields number
- filtered Length,Width,Height for 16mm entries, because these are the furniture plates. (40mm are the sidewalls..) and gave them a 4. filter attribute
- for all these furniture entries I simply calculated the volume and devided by 16 to get the total plate area. done
Sure this could be some more automated, but since this is more a singel event caculation it is ok for me to get the result.