, ѻ (). ARCHICAD .
, Excel. , . , , , Excel . , , , IFC-. , . ARCHICAD.
BIM- , 3D-. , ; , . , -, , . -, , , . ARCHICAD . , , .
, . , , , (. 1).
. 1
, , (. 2).
. 2
, .
- .
- , , . , , , {Property:/}, , . , , : . ARCHICAD, .
- , , .
- {} , .
- .
- .
- , , .
- , .
, (. 3).
. 3
, , , . , , , , , . , , ( ), , :
100 * TAN ()
, , ( ).
, . , ( ) , , .
:
CONCAT ("i="; STR (100 * TAN (); "%"),
i=1,50% ( ), , / , , .
, . . , I, II, III, IV, V. , , , . , , .
, . , , , .
, , < >, ---. !! ( - ). , , , , , . , , , (. 4).
. 4
IF ( <> ; !!; {}),
, .
, , , . , .
:
IF ( =-; !!; {}) (. 5).
. 5
. , , (/):
IF ( % <= 5; ; )
5%, , .
ARCHICAD. , , . . , - , , :
3D- * 1 m
, , , , ( 2 ).
ARCHICAD : , , . , , ( Sublime Text) .
, ARCHICAD , RUS- , INT- Wall. , , . TRUE/FALSE (/) . , , : , . , (, . .). ARCHICAD .
, . (. 6), , , , . : A ( ) -, ; B :
IF (A<>-; A; {})
A - , B=A, {}.
. 6
1: -123
- , , , . . (. 7) ( 21 -123).. 7
, , . , , . , , , ( , , ).
. , , V , , , I . , . 8.
. 8
. 9
, , , , ( ). , , , .
, :
IF ("" = ""; "!!";
IF ( <> " "; ;
IF ( <> ; "!!";
IF ( = "V"; " ";
IF ( = " ";
IF ( = "I"; "120";
IF ( = "II"; "90";
IF ( = "III";
IF (AND (_ = TRUE; = ""); "60"; "45");
IF ( = "IV";
IF (AND (_ = TRUE; = ""); "45"; "15"); "! !"))));
IF ( = "";
IF ( = "I"; "30"; "15"); " "))))))
, . . , .
, , , Grasshopper. , , , .
, . , , . ID , , , 90; TXT-, GUID , . :
CONTAINS ( ID;! 90!; FALSE),
! 90! , , GUID . GUID .
Labpp GUID . C++ (GUID .cpp *) Goodwin GDL Labpp ( ) GUID . , . 10.
. 10
2: 23166-99
, . ., . (, . .). , , , , -, , , , . -, . ( , . .), , (. 11).
. 11
.
, , : . , :
IF (OR ( _ <> " "; _ = ""); "";
IF (_ = ""; " 30674-99";
IF (_ = ""; " 21519-2003";
IF (_ = " + "; " 24700-99";
IF (_ = " + "; " 11214-2003";
IF (_ = " "; " 30734-2000";
IF (_ = ""; " 31462-2011"; "! !")))))))
, : _, _ "" "". , _ . _ , .
, , .
(_1_):
IF ( OR ( _ <> " "; _ = "" ); " ";
CONCAT (IF ( - 22 = " "; "";
IF ( - 22 = " "; ""; ! !);
IF (_ = ""; " ";
IF (_ = ""; " ";
IF (_ = " + "; "";
IF (_ = " + "; "";
IF (_ = " "; " ";
IF (_ = ""; " "; "! !"))))))))
, "". , ( ). CONCAT , _.
(_02_ ):
IF (OR ( _ <> " ";
_ = ""); "";
IF (_06_ = ""; "";
IF (_ = " "; "-1"; "")))
. , , . ( 30734-2000) .
, , , .
, , (_03_), , - , .
:
IF ("" = ""; "!!";
SUBSTITUTE (CONCAT (STRCALCUNIT (); "-"; STRCALCUNIT ();
IF ( - 22 = " "; ; "")); " "; ""))
. CONCAT , ; , , . STRCALCUNIT, .
ARCHICAD ( ) Windows → → → . ARCHICAD 22 , , TRIM ( , ) SUBSTITUTE.
:
IF (" " = ""; "!!";
SUBSTITUTE (CONCAT (STRCALCUNIT ( (A)); "-"; STRCALCUNIT ()); " "; ""))
, , , (A).
(_04__):
IF (OR ( _ <> " "; _ = ""); "";
TEXTJOIN (" "; TRUE; IF ( _ = TRUE; ""; "");
IF (_ = TRUE; ""; "");
IF (_ = TRUE; ""; "");
IF (_ = TRUE; ""; "");
IF (_ = TRUE; ""; "");
IF (_ = TRUE; ""; "");
IF (_ = "-"; "";
IF (_ = "-"; ""; ""))))
. , , . (, . .) , TRUE. , . TEXTJOIN, - .
(_05_ _06_) _R:
IF (OR ( _ <> " "; _ = ""); "";
IF (_R = 0; "";
IF (_R >= 0,8; "1";
IF (_R >= 0,75; "2";
IF (_R >= 0,7; "1";
IF (_R >= 0,65; "2";
IF (_R >= 0,6; "1";
IF (_R >= 0,55; "2";
IF (_R >= 0,5; "1";
IF (_R >= 0,45; "2";
IF (_R >= 0,4; "1";
IF (_R >= 0,35; "2"; ""))))))))))))
R ( ) . 4.7.1 23166-99. , , , R.
, , _ :
TRIM (TEXTJOIN (" "; TRUE; _01_; _02_ ; /_01__; _03_; _04__; _05_; _06_; /_02__; CONCAT ( _; _)))
TEXTJOIN, TRIM , . /_01__ /_02__ , - .
, . 12.
. 12
, _ (. 13).
. 13
3:
, Labpp_ ARCHICAD: .( - ). , , (. 14).
. 14
, , ; . , , . ( ) , , , . , . 15.
. 15
. , . . (S OP-UP.cpp *) S (. 16).
. 16
. 17
, , , . , S , S /-L, S /-S.
I (S I):
IF ( > - ; "!!! !!!";
IF (- <= 7; "0,067";
IF (- <= 13;
IF (- = "1"; "0,133";
IF (OR (- = "2"; - = "3/4");
IF ( <= 7; "0,067"; "0,133"); "! !"));
IF (- <= 21;
IF (- = "1"; "0,222";
IF (- = "2"; IF ( <= 13; "0,133"; "0,222");
IF (- <> "3/4"; "! !";
IF ( <= 7; "0,067";
IF ( <= 13; "0,133"; "0,222")))));
IF (- > 25; "! 25!";
IF (- = "1"; "0,267";
IF (- = "2"; IF ( <= 13; "0,133"; "0,267");
IF (- <> "3/4"; "! !";
IF ( <= 7; "0,067";
IF ( <= 13; "0,133";
IF ( <= 19; "0,222" ; "0,267" )))))))))))
, , , ( ):
( 1)
: , . , , , , .
. , . 8 13, , , , ( 7 ). 14 21 (, ). 22-25 , , . - 3/4.
25, , , . - (1, 2 3/4), , . , . II III.
(S ):
IF (S = 0; "!!! !!!";
IF ( = " "; " ";
IF (OR ( = "1"; = "3");
IF (S <= 50; S I; S III);
IF ( = "2";
IF (S <= 63; S I; S III ); "! !"))))
. . , , .
, ( ) . . ( → → ) .
: , , , S . , . , . (S _) (. 18).
. 18
SPLIT (STRCALCUNIT ( / * * 1000)); ","; 1)
( , ) SPLIT. , , ARCHICAD 22 ( ):
IF (CONTAINS ( " "; S _ ); SUBSTITUTE ( S _; " "; "," );
CONCAT ( "0,"; S _ ) )
. , S _ , , 0,. , ( , ), , , .
, , , . : , , . , , , .
ARCHICAD . , IFC- ( ), . , Excel ( ), ARCHICAD . , ( ), ., , .
: - , , , , . , . , , , , .
... , , , ( , ).