first I would like to complement Eric Wilk from FC-CADlink on his
most helpful book "ARCHICAD - From CAD to quantity survey".
If any of you are still baffled by the "Calculate Menu (now hidden...)" -
This is a real Eye-Opener!!!
Now to the trick question (see attached image):
A. In a simple wall, I calculate the plaster finish area by using the
"Surface A" reference Quantity.
B. However, in a situation like a Tiled Bathroom Wall, the surface is
covered by TWO different Materials:
- The Tiles themselves, to the hight of 1.8m, which I calculate as
"Length" X 1.8
- The remaining Plaster above the Tiles
The Plaster surface is a "Left-Over" quantity (The tiles have a
"fixed height" of 180cm, The wall hight, however, can change from
situation to situation), and by reason, should be derived by calculating
a subtraction:
Total of "Surface A" - Area of Tiles = Plaster.
In my database, I set up a Tile component which has a ratio of 1.8
to the length of a wall, and a Plaster component with a ratio of 1 to
"Surface A".
The question is this:
How can one create a "Property Object" (that can link to such walls)
in which both components are "read" from the database and then
have a GDL script within the Property Object subtract "Tiles" from
"Plaster"?
My GDL is a bit rusty, but I am sure it can be done via the Properties
script and a database lookup (I Better get that new book by CADImage!)
Ideas?
PS: The issue is calculating the quantities per a SINGLE wall, so
using an extra "tile" object or wall is not the solution.
Thanks -
Gil Rosenthal
Hi Karl!
Thanks - I actually came across this post a couple of hours back🙂
What's up with Djordge these days? Still in Dubai?
In this case I need the "entirely-inside-ArchiCAD solution", as I am
linking AC to a national Quantity Survey Database, using the exact same
Chapters & Keys - so it is rather easy to import hundreds of list items
(via excell) into the AC database, including prices as they update quarterly,
and also in the end, outputting the same keyed quantities from AC back
into the national DB - to be incorporated in the more conventional format,
if required.
Err... the database has over 3000 line items!!!
SO -
Here is the obvious and dead simple solution (See attachments in this and following posts):
1. All Components are linked into a Property Object from my custom DB.
2. In case of the Plaster component (the one from which we need to subtract
the area covered by the Tiling), the trick is as follows:
- Link in the Plaster Component as usual
- Change the "Proportional With..." field from "Surface A" to "CUSTOM"
- In the CUSTOM field, type the following expression:
WALL_SURFACE_A-WALL_LENGTH_A*1.8
3. These Global parameters were found at the end of the GDL manual, and
I am certain that other formulas can be developed from here (see
attached)
4. Shown is the end result after importing in Excell. Notice the total
partition surface as calculated for the cement bricks (The test wall was 200/300cm)
Cheers,
Gil
Thanks - I actually came across this post a couple of hours back
What's up with Djordge these days? Still in Dubai?
In this case I need the "entirely-inside-ArchiCAD solution", as I am
linking AC to a national Quantity Survey Database, using the exact same
Chapters & Keys - so it is rather easy to import hundreds of list items
(via excell) into the AC database, including prices as they update quarterly,
and also in the end, outputting the same keyed quantities from AC back
into the national DB - to be incorporated in the more conventional format,
if required.
Err... the database has over 3000 line items!!!
SO -
Here is the obvious and dead simple solution (See attachments in this and following posts):
1. All Components are linked into a Property Object from my custom DB.
2. In case of the Plaster component (the one from which we need to subtract
the area covered by the Tiling), the trick is as follows:
- Link in the Plaster Component as usual
- Change the "Proportional With..." field from "Surface A" to "CUSTOM"
- In the CUSTOM field, type the following expression:
WALL_SURFACE_A-WALL_LENGTH_A*1.8
3. These Global parameters were found at the end of the GDL manual, and
I am certain that other formulas can be developed from here (see
attached)
4. Shown is the end result after importing in Excell. Notice the total
partition surface as calculated for the cement bricks (The test wall was 200/300cm)
Cheers,
Gil
...and the GDL Globals that make this work,
found at the end of the GDL manual.
I am sure more uses can be found for these🙂
found at the end of the GDL manual.
I am sure more uses can be found for these
Still looking?
