topic Re: Formulas in Schedules in Collaboration with other software

Formulas in Schedules

Anonymous — Tue, 11 Mar 2008 13:59:57 GMT

Is there a way to put a formula in a a cell of a schedule? I need to use in a zone schedule a field calculating one fifth of the area of the windows surface and showing it. Any help?

Re: Formulas in Schedules

TomWaltz — Tue, 11 Mar 2008 20:06:35 GMT

it would be nice, but no

Re: Formulas in Schedules

Rob — Tue, 11 Mar 2008 21:58:37 GMT

...and let's make it a wish
http://archicad-talk.graphisoft.com/viewtopic.php?t=21689

Re: Formulas in Schedules

James Murray — Wed, 12 Mar 2008 17:28:33 GMT

It is an essential wish, but in the meantime such calculations can be done in a customized zone stamp.

! parameter: winAreaFifth (real number type)

! In master script
winAreaFifth=ROOM_WINDS_SURF*0.2
PARAMETERS winAreaFifth= winAreaFifth

Then add that parameter to the schedule using Scheme Settings -> Fields -> Additional Parameters.

Re: Formulas in Schedules

Anonymous — Thu, 13 Mar 2008 19:33:42 GMT

That's a great tip! but the value I want would be the fifth of Room_area instead of room_winds_surf. By the way, the room_winds_surf ignores windows smaller than 1 square meter. Where do I set this value?

Re: Formulas in Schedules

Anonymous — Tue, 15 Apr 2008 14:40:43 GMT

Ok , I tried a lot but it didn't work. I created a zone stamp introducing two parameters: One sets the factor of the calculation and one that calculates it. Everything works fine, but when I insert this parameter on a schedule it remains blank (appearing dashed lines instead) whenever I reopen the file. Here is the parameter calculation:

! options for the factor calculation
values "Vent_ilum_factor_name" "1/8","1/5"
if Vent_ilum_factor_name="1/8" then Ilum_vent_factor=0.125
if Vent_ilum_factor_name="1/5" then Ilum_vent_factor=0.2

! calculating the needed illumination and ventilation area
Ilum_vent_ar= ROOM_CALC_AREA*Ilum_vent_factor
PARAMETERS Ilum_vent_area=Ilum_vent_ar

! Showing the existent illumination and ventilation area
Ilum_vent_exist= ROOM_WINDS_SURF
PARAMETERS Ilum_vent_exist= Ilum_vent_exist

What am I doing wrong?

Re: Formulas in Schedules

Ignacio Azpiazu — Tue, 15 Apr 2008 18:21:18 GMT

I think there is no way of showing a value calculated by a script in the schedule, because the scripts are not run by the schedule. The zone stamp script calculates the thing for display in the 2D window but will do nothing about the schedule.

Re: Formulas in Schedules

James Murray — Tue, 15 Apr 2008 22:20:26 GMT

1. Did you create the parameters "Ilum_vent_area" and "Ilum_vent_exist"? Dashed lines in a schedule usually means the parameter is not available in the object (stamp).

2. Is the code in the Master Script?

To be clear, you certainly can schedule parameters calculated in this way. My zone stamp has a custom parameter for the area in whole square feet, and it updates when the zone shape changes. (Just checked it, whew!) The math and PARAMETERS statement are in the master script.

PARAMETERS can be used in the master or parameter scripts. Master is more robust in many cases. I believe the parameter script only runs in the settings dialog or when the object is otherwise edited, while the master will run when any script is run, which apparently includes building the schedule, thank goodness.

Re: Formulas in Schedules

vfrontiers — Wed, 16 Apr 2008 20:05:05 GMT

As James eluded to; you must create a PARAMETER in the Parameter List that corresponds to the ones you are defining in the script. (add PARAMETER and name it the same and make it the appropriate type)

Also, why are your PARAMETER definition using two steps?

! calculating the needed illumination and ventilation area
Ilum_vent_ar= ROOM_CALC_AREA*Ilum_vent_factor
PARAMETERS Ilum_vent_area=Ilum_vent_ar

! Showing the existent illumination and ventilation area
Ilum_vent_exist= ROOM_WINDS_SURF
PARAMETERS Ilum_vent_exist= Ilum_vent_exist

Why couldn't you just type....

PARAMETERS Ilum_vent_area = ROOM_CALC_AREA*Ilum_vent_factor

Re: Formulas in Schedules

James Murray — Thu, 17 Apr 2008 14:52:34 GMT

vfrontiers wrote:
Why couldn't you just type....

PARAMETERS Ilum_vent_area = ROOM_CALC_AREA*Ilum_vent_factor

There are cases where it's more reliable to do the calculation separately, such as if the value will be used in other calculations besides the PARAMETERS statement. For some reason, changing the value of the parameter does not always change the value of the variable.

However, in this case of a simple PARAMETERS assignment, you can condense it to one line.

Re: Formulas in Schedules

Rob — Sat, 19 Apr 2008 05:57:42 GMT

There are cases where it's more reliable to do the calculation separately, such as if the value will be used in other calculations besides the PARAMETERS statement. For some reason, changing the value of the parameter does not always change the value of the variable.

you right, the best is to place the equation in the master script as well (especially with zones).

Re: Formulas in Schedules

Anonymous — Mon, 21 Apr 2008 19:55:57 GMT

Hello,

This can be found in the old GDL programming standards and seems still to be true after 8 years.

When resetting the value of a parameter in a certain condition in the
Parameter Script using the “parameters” command, a similar statement must be put into the Master Script, especially if the modification of the second
parameter changes the value of a third (or more) parameter. E.g.:
if xx then parameters yy=1 (Parameter script)
if xx then yy=1 (Master script)

--
Regards, Juha

Re: Formulas in Schedules

Anonymous — Thu, 24 Apr 2008 19:10:33 GMT

Juha wrote:
This can be found in the old GDL programming standards and seems still to be true after 8 years.

Still true in the latest GDL Technical Standards. 🙂
http://www.graphisoft.com/ftp/techsupport/documentation/developer_docs/BasicLibraryDoc/11/LibDevGuide/TechnicalStandards.html#title44

In practice, if calculations are made in Master Script, and particulary when they are numerous,
no need to re-type (Parameters Script): if bCondition then parameters yy = 1.
You get the same result just typing: parameters yy = yy, etc ...

May be not "academicl" scripting, but efficient. Parameters always update for any situation.

Cheers,
Olivier

Re: !Restored: Formulas in Schedules

Ignacio Azpiazu — Mon, 03 Nov 2008 16:05:09 GMT

Anybody has a sense of what is going on here? I can't get the schedule to display two zone additional parameters, one of which you just fill in and the other one calculated in the master script --I just get those dashes. The libraries are loaded OK as far as I can tell from Library Loading Report, zone settings preview and floor plans, those values display OK in the zone stamp everywhere.

There is a 'Bldg Name' text parameter, 'II' in the screenshot. The stamp makes a string of Bldg Name + story number + zone number to create and display a unique 'apartment long number', 'II.5.06' in the screenshot. [These have been custom-scripted into a Tom Waltz's Superzone; AC11 1210 USA.]

Re: !Restored: Formulas in Schedules

Ignacio Azpiazu — Mon, 03 Nov 2008 16:28:02 GMT

I just read the thread below, http://archicad-talk.graphisoft.com/viewtopic.php?t=25495 . Saved back to AC 10 and the parameters are displaying OK in the same schedules there. So the problem is a 10-to-11 thing.

Wonder what the problem can be though --one of the problem parameters is a simple stupid fill-in text parameter.

Re: Formulas in Schedules

TomWaltz — Mon, 03 Nov 2008 18:17:32 GMT

There was a minor change in the Master Script necessary for AC11. It was something that GS changed between AC10 and AC11 that only seemed to affect my object!

For more info:
http://archicad-talk.graphisoft.com/viewtopic.php?p=113423

Re: Formulas in Schedules

Ignacio Azpiazu — Mon, 03 Nov 2008 19:18:05 GMT

Wow thanks. I love AC talk, I love you all guys, and I think I am not drunk.