xref: /AOO41X/main/sc/source/ui/src/scfuncs.src (revision 54628ca40d27d15cc98fe861da7fff7e60c2f7d6)
1/**************************************************************
2 *
3 * Licensed to the Apache Software Foundation (ASF) under one
4 * or more contributor license agreements.  See the NOTICE file
5 * distributed with this work for additional information
6 * regarding copyright ownership.  The ASF licenses this file
7 * to you under the Apache License, Version 2.0 (the
8 * "License"); you may not use this file except in compliance
9 * with the License.  You may obtain a copy of the License at
10 *
11 *   http://www.apache.org/licenses/LICENSE-2.0
12 *
13 * Unless required by applicable law or agreed to in writing,
14 * software distributed under the License is distributed on an
15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16 * KIND, either express or implied.  See the License for the
17 * specific language governing permissions and limitations
18 * under the License.
19 *
20 *************************************************************/
21
22
23
24/* Resource file for the function wizard / autopilot.
25 *
26 * All descriptions of functions are collected within the resources
27 * RID_SC_FUNCTION_DESCRIPTIONS1 respectively RID_SC_FUNCTION_DESCRIPTIONS2,
28 * two blocks because otherwise we had a 64kb overflow.
29 *
30 *  For every function there is a sub resource with the number of the OpCode of
31 *  the function.
32 *
33 *      In this sub resource, with index 1 the description of the function is
34 *      given, after that follows an
35 *
36 *      ExtraData block with:
37 *
38 *          Boolean flag whether function is suppressed. Usually 0. This may be
39 *          used to add UI string resources before UI freeze if implementation
40 *          isn't ready yet without displaying them in the function wizard,
41 *          most recent used list and other UI elements. Also not available via
42 *          API then.
43 *
44 *          Function group (text, math, ...), one of ID_FUNCTION_GRP_...
45 *
46 *          Help ID, U2S(HID_FUNC_...)
47 *
48 *          Number of parameters. VAR_ARGS if variable number, or
49 *          VAR_ARGS+number if number of fixed parameters and variable
50 *          arguments following. Or PAIRED_VAR_ARGS if variable number of
51 *          paired parameters, or PAIRED_VAR_ARGS+number if number of fixed
52 *          parameters and variable paired arguments following.
53 *
54 *          For every parameter:
55 *
56 *              Boolean flag whether the parameter is optional.
57 *
58 *          Number of suppressed parameters. Usually 0. Same meaning and
59 *          mechanism as the flag for the entire function above.
60 *
61 *          For every suppressed parameter:
62 *
63 *              The parameter number, offset starting with 0. Variable
64 *              arguments can't be suppressed!
65 *
66 *
67 *      ExtraData block followed by two string resources for each parameter,
68 *      first the type or name of the parameter, second a description of the
69 *      parameter.
70 */
71
72// Hack:
73//#define   U2S(x)  ((x)-HID_START)
74#define U2S(x) x
75// Macro U2S: unsigned to signed
76// is needed because the resource compiler only knows signed short int in
77// ExtraData, but the HID_XXX are unsigned and exceed 32k. Code reading the
78// resource entries must consider this and undo the conversion.
79
80#include "scfuncs.hrc" // ID_FUNCTION_GRP_XXX, HID_FUNC_XXX
81#include "formula/compiler.hrc" // SC_OPCODE_XXX
82
83Resource RID_SC_FUNCTION_DESCRIPTIONS1
84{
85     // -=*# Resource for function DBANZAHL #*=-
86    Resource SC_OPCODE_DB_COUNT
87    {
88        String 1 // Description
89        {
90            Text [ en-US ] = "Counts the cells of a data range whose contents match the search criteria." ;
91        };
92        ExtraData =
93        {
94            0;
95            ID_FUNCTION_GRP_DATABASE;
96            U2S( HID_FUNC_DBANZAHL );
97            3;  0;  0;  0;
98            0;
99        };
100        String 2 // Name of Parameter 1
101        {
102            Text [ en-US ] = "Database" ;
103        };
104        String 3 // Description of Parameter 1
105        {
106            Text [ en-US ] = "The range of cells containing data." ;
107        };
108        String 4 // Name of Parameter 2
109        {
110            Text [ en-US ] = "Database field" ;
111        };
112        String 5 // Description of Parameter 2
113        {
114            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
115        };
116        String 6 // Name of Parameter 3
117        {
118            Text [ en-US ] = "Search criteria" ;
119        };
120        String 7 // Description of Parameter 3
121        {
122            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
123        };
124    };
125     // -=*# Resource for function DBANZAHL2 #*=-
126    Resource SC_OPCODE_DB_COUNT_2
127    {
128        String 1 // Description
129        {
130            Text [ en-US ] = "Counts all non-blank cells of a data range where the content corresponds to the search criteria." ;
131        };
132        ExtraData =
133        {
134            0;
135            ID_FUNCTION_GRP_DATABASE;
136            U2S( HID_FUNC_DBANZAHL2 );
137            3;  0;  0;  0;
138            0;
139        };
140        String 2 // Name of Parameter 1
141        {
142            Text [ en-US ] = "Database" ;
143        };
144        String 3 // Description of Parameter 1
145        {
146            Text [ en-US ] = "The range of cells containing data." ;
147        };
148        String 4 // Name of Parameter 2
149        {
150            Text [ en-US ] = "Database field" ;
151        };
152        String 5 // Description of Parameter 2
153        {
154            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
155        };
156        String 6 // Name of Parameter 3
157        {
158            Text [ en-US ] = "Search criteria" ;
159        };
160        String 7 // Description of Parameter 3
161        {
162            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
163        };
164    };
165     // -=*# Resource for function DBMITTELWERT #*=-
166    Resource SC_OPCODE_DB_AVERAGE
167    {
168        String 1 // Description
169        {
170            Text [ en-US ] = "Returns the average value of all the cells of a data range whose contents match the search criteria." ;
171        };
172        ExtraData =
173        {
174            0;
175            ID_FUNCTION_GRP_DATABASE;
176            U2S( HID_FUNC_DBMITTELWERT );
177            3;  0;  0;  0;
178            0;
179        };
180        String 2 // Name of Parameter 1
181        {
182            Text [ en-US ] = "Database" ;
183        };
184        String 3 // Description of Parameter 1
185        {
186            Text [ en-US ] = "The range of cells containing data." ;
187        };
188        String 4 // Name of Parameter 2
189        {
190            Text [ en-US ] = "Database field" ;
191        };
192        String 5 // Description of Parameter 2
193        {
194            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
195        };
196        String 6 // Name of Parameter 3
197        {
198            Text [ en-US ] = "Search criteria" ;
199        };
200        String 7 // Description of Parameter 3
201        {
202            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
203        };
204    };
205     // -=*# Resource for function DBAUSZUG #*=-
206    Resource SC_OPCODE_DB_GET
207    {
208        String 1 // Description
209        {
210            Text [ en-US ] = "Defines the contents of the cell of a data range which matches the search criteria." ;
211        };
212        ExtraData =
213        {
214            0;
215            ID_FUNCTION_GRP_DATABASE;
216            U2S( HID_FUNC_DBAUSZUG );
217            3;  0;  0;  0;
218            0;
219        };
220        String 2 // Name of Parameter 1
221        {
222            Text [ en-US ] = "Database" ;
223        };
224        String 3 // Description of Parameter 1
225        {
226            Text [ en-US ] = "The range of cells containing data." ;
227        };
228        String 4 // Name of Parameter 2
229        {
230            Text [ en-US ] = "Database field" ;
231        };
232        String 5 // Description of Parameter 2
233        {
234            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
235        };
236        String 6 // Name of Parameter 3
237        {
238            Text [ en-US ] = "Search criteria" ;
239        };
240        String 7 // Description of Parameter 3
241        {
242            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
243        };
244    };
245     // -=*# Resource for function DBMAX #*=-
246    Resource SC_OPCODE_DB_MAX
247    {
248        String 1 // Description
249        {
250            Text [ en-US ] = "Returns the maximum value from all of the cells of a data range which correspond to the search criteria." ;
251        };
252        ExtraData =
253        {
254            0;
255            ID_FUNCTION_GRP_DATABASE;
256            U2S( HID_FUNC_DBMAX );
257            3;  0;  0;  0;
258            0;
259        };
260        String 2 // Name of Parameter 1
261        {
262            Text [ en-US ] = "Database" ;
263        };
264        String 3 // Description of Parameter 1
265        {
266            Text [ en-US ] = "The range of cells containing data." ;
267        };
268        String 4 // Name of Parameter 2
269        {
270            Text [ en-US ] = "Database field" ;
271        };
272        String 5 // Description of Parameter 2
273        {
274            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
275        };
276        String 6 // Name of Parameter 3
277        {
278            Text [ en-US ] = "Search criteria" ;
279        };
280        String 7 // Description of Parameter 3
281        {
282            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
283        };
284    };
285     // -=*# Resource for function DBMIN #*=-
286    Resource SC_OPCODE_DB_MIN
287    {
288        String 1 // Description
289        {
290            Text [ en-US ] = "Returns the minimum of all cells of a data range where the contents correspond to the search criteria." ;
291        };
292        ExtraData =
293        {
294            0;
295            ID_FUNCTION_GRP_DATABASE;
296            U2S( HID_FUNC_DBMIN );
297            3;  0;  0;  0;
298            0;
299        };
300        String 2 // Name of Parameter 1
301        {
302            Text [ en-US ] = "Database" ;
303        };
304        String 3 // Description of Parameter 1
305        {
306            Text [ en-US ] = "The range of cells containing data." ;
307        };
308        String 4 // Name of Parameter 2
309        {
310            Text [ en-US ] = "Database field" ;
311        };
312        String 5 // Description of Parameter 2
313        {
314            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
315        };
316        String 6 // Name of Parameter 3
317        {
318            Text [ en-US ] = "Search criteria" ;
319        };
320        String 7 // Description of Parameter 3
321        {
322            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
323        };
324    };
325     // -=*# Resource for function DBPRODUKT #*=-
326    Resource SC_OPCODE_DB_PRODUCT
327    {
328        String 1 // Description
329        {
330            Text [ en-US ] = "Multiplies all cells of a data range where the contents match the search criteria." ;
331        };
332        ExtraData =
333        {
334            0;
335            ID_FUNCTION_GRP_DATABASE;
336            U2S( HID_FUNC_DBPRODUKT );
337            3;  0;  0;  0;
338            0;
339        };
340        String 2 // Name of Parameter 1
341        {
342            Text [ en-US ] = "Database" ;
343        };
344        String 3 // Description of Parameter 1
345        {
346            Text [ en-US ] = "The range of cells containing data." ;
347        };
348        String 4 // Name of Parameter 2
349        {
350            Text [ en-US ] = "Database field" ;
351        };
352        String 5 // Description of Parameter 2
353        {
354            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
355        };
356        String 6 // Name of Parameter 3
357        {
358            Text [ en-US ] = "Search criteria" ;
359        };
360        String 7 // Description of Parameter 3
361        {
362            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
363        };
364    };
365     // -=*# Resource for function DBSTDABW #*=-
366    Resource SC_OPCODE_DB_STD_DEV
367    {
368        String 1 // Description
369        {
370            Text [ en-US ] = "Calculates the standard deviation of all cells in a data range whose contents match the search criteria." ;
371        };
372        ExtraData =
373        {
374            0;
375            ID_FUNCTION_GRP_DATABASE;
376            U2S( HID_FUNC_DBSTDABW );
377            3;  0;  0;  0;
378            0;
379        };
380        String 2 // Name of Parameter 1
381        {
382            Text [ en-US ] = "Database" ;
383        };
384        String 3 // Description of Parameter 1
385        {
386            Text [ en-US ] = "The range of cells containing data." ;
387        };
388        String 4 // Name of Parameter 2
389        {
390            Text [ en-US ] = "Database field" ;
391        };
392        String 5 // Description of Parameter 2
393        {
394            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
395        };
396        String 6 // Name of Parameter 3
397        {
398            Text [ en-US ] = "Search criteria" ;
399        };
400        String 7 // Description of Parameter 3
401        {
402            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
403        };
404    };
405     // -=*# Resource for function DBSTDABWN #*=-
406    Resource SC_OPCODE_DB_STD_DEV_P
407    {
408        String 1 // Description
409        {
410            Text [ en-US ] = "Returns the standard deviation with regards to the population of all cells of a data range matching the search criteria." ;
411        };
412        ExtraData =
413        {
414            0;
415            ID_FUNCTION_GRP_DATABASE;
416            U2S( HID_FUNC_DBSTDABWN );
417            3;  0;  0;  0;
418            0;
419        };
420        String 2 // Name of Parameter 1
421        {
422            Text [ en-US ] = "Database" ;
423        };
424        String 3 // Description of Parameter 1
425        {
426            Text [ en-US ] = "The range of cells containing data." ;
427        };
428        String 4 // Name of Parameter 2
429        {
430            Text [ en-US ] = "Database field" ;
431        };
432        String 5 // Description of Parameter 2
433        {
434            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
435        };
436        String 6 // Name of Parameter 3
437        {
438            Text [ en-US ] = "Search criteria" ;
439        };
440        String 7 // Description of Parameter 3
441        {
442            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
443        };
444    };
445     // -=*# Resource for function DBSUMME #*=-
446    Resource SC_OPCODE_DB_SUM
447    {
448        String 1 // Description
449        {
450            Text [ en-US ] = "Adds all the cells of a data range where the contents match the search criteria." ;
451        };
452        ExtraData =
453        {
454            0;
455            ID_FUNCTION_GRP_DATABASE;
456            U2S( HID_FUNC_DBSUMME );
457            3;  0;  0;  0;
458            0;
459        };
460        String 2 // Name of Parameter 1
461        {
462            Text [ en-US ] = "Database" ;
463        };
464        String 3 // Description of Parameter 1
465        {
466            Text [ en-US ] = "The range of cells containing data." ;
467        };
468        String 4 // Name of Parameter 2
469        {
470            Text [ en-US ] = "Database field" ;
471        };
472        String 5 // Description of Parameter 2
473        {
474            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
475        };
476        String 6 // Name of Parameter 3
477        {
478            Text [ en-US ] = "Search criteria" ;
479        };
480        String 7 // Description of Parameter 3
481        {
482            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
483        };
484    };
485     // -=*# Resource for function DBVARIANZ #*=-
486    Resource SC_OPCODE_DB_VAR
487    {
488        String 1 // Description
489        {
490            Text [ en-US ] = "Determines the variance of all the cells in a data range where the contents match the search criteria." ;
491        };
492        ExtraData =
493        {
494            0;
495            ID_FUNCTION_GRP_DATABASE;
496            U2S( HID_FUNC_DBVARIANZ );
497            3;  0;  0;  0;
498            0;
499        };
500        String 2 // Name of Parameter 1
501        {
502            Text [ en-US ] = "Database" ;
503        };
504        String 3 // Description of Parameter 1
505        {
506            Text [ en-US ] = "The range of cells containing data." ;
507        };
508        String 4 // Name of Parameter 2
509        {
510            Text [ en-US ] = "Database field" ;
511        };
512        String 5 // Description of Parameter 2
513        {
514            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
515        };
516        String 6 // Name of Parameter 3
517        {
518            Text [ en-US ] = "Search criteria" ;
519        };
520        String 7 // Description of Parameter 3
521        {
522            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
523        };
524    };
525     // -=*# Resource for function DBVARIANZEN #*=-
526    Resource SC_OPCODE_DB_VAR_P
527    {
528        String 1 // Description
529        {
530            Text [ en-US ] = "Determines variance of a population based on all cells in a data range where contents match the search criteria." ;
531        };
532        ExtraData =
533        {
534            0;
535            ID_FUNCTION_GRP_DATABASE;
536            U2S( HID_FUNC_DBVARIANZEN );
537            3;  0;  0;  0;
538            0;
539        };
540        String 2 // Name of Parameter 1
541        {
542            Text [ en-US ] = "Database" ;
543        };
544        String 3 // Description of Parameter 1
545        {
546            Text [ en-US ] = "The range of cells containing data." ;
547        };
548        String 4 // Name of Parameter 2
549        {
550            Text [ en-US ] = "Database field" ;
551        };
552        String 5 // Description of Parameter 2
553        {
554            Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ;
555        };
556        String 6 // Name of Parameter 3
557        {
558            Text [ en-US ] = "Search criteria" ;
559        };
560        String 7 // Description of Parameter 3
561        {
562            Text [ en-US ] = "Defines the cell range containing the search criteria." ;
563        };
564    };
565     // -=*# Resource for function DATUM #*=-
566    Resource SC_OPCODE_GET_DATE
567    {
568        String 1 // Description
569        {
570            Text [ en-US ] = "Provides an internal number for the date given." ;
571        };
572        ExtraData =
573        {
574            0;
575            ID_FUNCTION_GRP_DATETIME;
576            U2S( HID_FUNC_DATUM );
577            3;  0;  0;  0;
578            0;
579        };
580        String 2 // Name of Parameter 1
581        {
582            Text [ en-US ] = "year" ;
583        };
584        String 3 // Description of Parameter 1
585        {
586            Text [ en-US ] = "An integer between 1583 and 9956 or 0 and 99 (19xx or 20xx depending on the defined option)." ;
587        };
588        String 4 // Name of Parameter 2
589        {
590            Text [ en-US ] = "month" ;
591        };
592        String 5 // Description of Parameter 2
593        {
594            Text [ en-US ] = "An integer between 1 and 12 representing the month." ;
595        };
596        String 6 // Name of Parameter 3
597        {
598            Text [ en-US ] = "day" ;
599        };
600        String 7 // Description of Parameter 3
601        {
602            Text [ en-US ] = "An integer between 1 and 31 representing the day of the month." ;
603        };
604    };
605     // -=*# Resource for function DATWERT #*=-
606    Resource SC_OPCODE_GET_DATE_VALUE
607    {
608        String 1 // Description
609        {
610            Text [ en-US ] = "Returns an internal number for a text having a possible date format." ;
611        };
612        ExtraData =
613        {
614            0;
615            ID_FUNCTION_GRP_DATETIME;
616            U2S( HID_FUNC_DATWERT );
617            1;  0;
618            0;
619        };
620        String 2 // Name of Parameter 1
621        {
622            Text [ en-US ] = "text" ;
623        };
624        String 3 // Description of Parameter 1
625        {
626            Text [ en-US ] = "A text enclosed in quotation marks which returns a date in a %PRODUCTNAME date format." ;
627        };
628    };
629     // -=*# Resource for function TAG #*=-
630    Resource SC_OPCODE_GET_DAY
631    {
632        String 1 // Description
633        {
634            Text [ en-US ] = "Returns the sequential date of the month as an integer (1-31) in relation to the date value." ;
635        };
636        ExtraData =
637        {
638            0;
639            ID_FUNCTION_GRP_DATETIME;
640            U2S( HID_FUNC_TAG );
641            1;  0;
642            0;
643        };
644        String 2 // Name of Parameter 1
645        {
646            Text [ en-US ] = "Number" ;
647        };
648        String 3 // Description of Parameter 1
649        {
650            Text [ en-US ] = "The internal number for the date." ;
651        };
652    };
653     // -=*# Resource for function TAGE360 #*=-
654    Resource SC_OPCODE_GET_DIFF_DATE_360
655    {
656        String 1 // Description
657        {
658            Text [ en-US ] = "Calculates the number of days between two dates based on a 360-day year." ;
659        };
660        ExtraData =
661        {
662            0;
663            ID_FUNCTION_GRP_DATETIME;
664            U2S( HID_FUNC_TAGE360 );
665            3;  0;  0;  1;
666            0;
667        };
668        String 2 // Name of Parameter 1
669        {
670            Text [ en-US ] = "Date_1" ;
671        };
672        String 3 // Description of Parameter 1
673        {
674            Text [ en-US ] = "The start date for calculating the difference in days." ;
675        };
676        String 4 // Name of Parameter 2
677        {
678            Text [ en-US ] = "Date_2" ;
679        };
680        String 5 // Description of Parameter 2
681        {
682            Text [ en-US ] = "The end date for calculating the difference in days." ;
683        };
684        String 6 // Name of Parameter 3
685        {
686            Text [ en-US ] = "Type" ;
687        };
688        String 7 // Description of Parameter 3
689        {
690            Text [ en-US ] = "Method used to form differences: Type = 0 denotes US method (NASD), Type = 1 denotes the European method." ;
691        };
692    };
693     // -=*# Resource for function STUNDE #*=-
694    Resource SC_OPCODE_GET_HOUR
695    {
696        String 1 // Description
697        {
698            Text [ en-US ] = "Determines the sequential number of the hour of the day (0-23) for the time value." ;
699        };
700        ExtraData =
701        {
702            0;
703            ID_FUNCTION_GRP_DATETIME;
704            U2S( HID_FUNC_STUNDE );
705            1;  0;
706            0;
707        };
708        String 2 // Name of Parameter 1
709        {
710            Text [ en-US ] = "Number" ;
711        };
712        String 3 // Description of Parameter 1
713        {
714            Text [ en-US ] = "Internal time value" ;
715        };
716    };
717     // -=*# Resource for function MINUTE #*=-
718    Resource SC_OPCODE_GET_MIN
719    {
720        String 1 // Description
721        {
722            Text [ en-US ] = "Determines the sequential number for the minute of the hour (0-59) for the time value." ;
723        };
724        ExtraData =
725        {
726            0;
727            ID_FUNCTION_GRP_DATETIME;
728            U2S( HID_FUNC_MINUTE );
729            1;  0;
730            0;
731        };
732        String 2 // Name of Parameter 1
733        {
734            Text [ en-US ] = "Number" ;
735        };
736        String 3 // Description of Parameter 1
737        {
738            Text [ en-US ] = "Internal time value." ;
739        };
740    };
741     // -=*# Resource for function MONAT #*=-
742    Resource SC_OPCODE_GET_MONTH
743    {
744        String 1 // Description
745        {
746            Text [ en-US ] = "Determines the sequential number of a month of the year (1-12) for the date value." ;
747        };
748        ExtraData =
749        {
750            0;
751            ID_FUNCTION_GRP_DATETIME;
752            U2S( HID_FUNC_MONAT );
753            1;  0;
754            0;
755        };
756        String 2 // Name of Parameter 1
757        {
758            Text [ en-US ] = "Number" ;
759        };
760        String 3 // Description of Parameter 1
761        {
762            Text [ en-US ] = "The internal number of the date." ;
763        };
764    };
765     // -=*# Resource for function JETZT #*=-
766    Resource SC_OPCODE_GET_ACT_TIME
767    {
768        String 1 // Description
769        {
770            Text [ en-US ] = "Determines the current time of the computer." ;
771        };
772        ExtraData =
773        {
774            0;
775            ID_FUNCTION_GRP_DATETIME;
776            U2S( HID_FUNC_JETZT );
777            0;
778            0;
779        };
780    };
781     // -=*# Resource for function SEKUNDE #*=-
782    Resource SC_OPCODE_GET_SEC
783    {
784        String 1 // Description
785        {
786            Text [ en-US ] = "Determines the sequential number of the second of a minute (0-59) for the time value." ;
787        };
788        ExtraData =
789        {
790            0;
791            ID_FUNCTION_GRP_DATETIME;
792            U2S( HID_FUNC_SEKUNDE );
793            1;  0;
794            0;
795        };
796        String 2 // Name of Parameter 1
797        {
798            Text [ en-US ] = "Number" ;
799        };
800        String 3 // Description of Parameter 1
801        {
802            Text [ en-US ] = "The internal time value." ;
803        };
804    };
805     // -=*# Resource for function ZEIT #*=-
806    Resource SC_OPCODE_GET_TIME
807    {
808        String 1 // Description
809        {
810            Text [ en-US ] = "Determines a time value from the details for hour, minute and second." ;
811        };
812        ExtraData =
813        {
814            0;
815            ID_FUNCTION_GRP_DATETIME;
816            U2S( HID_FUNC_ZEIT );
817            3;  0;  0;  0;
818            0;
819        };
820        String 2 // Name of Parameter 1
821        {
822            Text [ en-US ] = "hour" ;
823        };
824        String 3 // Description of Parameter 1
825        {
826            Text [ en-US ] = "The integer for the hour." ;
827        };
828        String 4 // Name of Parameter 2
829        {
830            Text [ en-US ] = "minute" ;
831        };
832        String 5 // Description of Parameter 2
833        {
834            Text [ en-US ] = "The integer for the minute." ;
835        };
836        String 6 // Name of Parameter 3
837        {
838            Text [ en-US ] = "second" ;
839        };
840        String 7 // Description of Parameter 3
841        {
842            Text [ en-US ] = "The integer for the second." ;
843        };
844    };
845     // -=*# Resource for function ZEITWERT #*=-
846    Resource SC_OPCODE_GET_TIME_VALUE
847    {
848        String 1 // Description
849        {
850            Text [ en-US ] = "Returns a sequential number for a text shown in a possible time entry format." ;
851        };
852        ExtraData =
853        {
854            0;
855            ID_FUNCTION_GRP_DATETIME;
856            U2S( HID_FUNC_ZEITWERT );
857            1;  0;
858            0;
859        };
860        String 2 // Name of Parameter 1
861        {
862            Text [ en-US ] = "text" ;
863        };
864        String 3 // Description of Parameter 1
865        {
866            Text [ en-US ] = "A text enclosed in quotation marks which returns a time in a %PRODUCTNAME time format." ;
867        };
868    };
869     // -=*# Resource for function HEUTE #*=-
870    Resource SC_OPCODE_GET_ACT_DATE
871    {
872        String 1 // Description
873        {
874            Text [ en-US ] = "Determines the current date of the computer." ;
875        };
876        ExtraData =
877        {
878            0;
879            ID_FUNCTION_GRP_DATETIME;
880            U2S( HID_FUNC_HEUTE );
881            0;
882            0;
883        };
884    };
885     // -=*# Resource for function WOCHENTAG #*=-
886    Resource SC_OPCODE_GET_DAY_OF_WEEK
887    {
888        String 1 // Description
889        {
890            Text [ en-US ] = "Returns the day of the week for the date value as an integer (1-7)." ;
891        };
892        ExtraData =
893        {
894            0;
895            ID_FUNCTION_GRP_DATETIME;
896            U2S( HID_FUNC_WOCHENTAG );
897            2;  0;  1;
898            0;
899        };
900        String 2 // Name of Parameter 1
901        {
902            Text [ en-US ] = "Number" ;
903        };
904        String 3 // Description of Parameter 1
905        {
906            Text [ en-US ] = "The internal number for the date." ;
907        };
908        String 4 // Name of Parameter 2
909        {
910            Text [ en-US ] = "Type" ;
911        };
912        String 5 // Description of Parameter 2
913        {
914            Text [ en-US ] = "Fixes the beginning of the week and the type of calculation to be used." ;
915        };
916    };
917     // -=*# Resource for function JAHR #*=-
918    Resource SC_OPCODE_GET_YEAR
919    {
920        String 1 // Description
921        {
922            Text [ en-US ] = "Returns the year of a date value as an integer." ;
923        };
924        ExtraData =
925        {
926            0;
927            ID_FUNCTION_GRP_DATETIME;
928            U2S( HID_FUNC_JAHR );
929            1;  0;
930            0;
931        };
932        String 2 // Name of Parameter 1
933        {
934            Text [ en-US ] = "Number" ;
935        };
936        String 3 // Description of Parameter 1
937        {
938            Text [ en-US ] = "Internal number of the date." ;
939        };
940    };
941     // -=*# Resource for function TAGE #*=-
942    Resource SC_OPCODE_GET_DIFF_DATE
943    {
944        String 1 // Description
945        {
946            Text [ en-US ] = "Calculates the number of days between two dates." ;
947        };
948        ExtraData =
949        {
950            0;
951            ID_FUNCTION_GRP_DATETIME;
952            U2S( HID_FUNC_TAGE );
953            2;  0;  0;
954            0;
955        };
956        String 2 // Name of Parameter 1
957        {
958            Text [ en-US ] = "Date_2" ;
959        };
960        String 3 // Description of Parameter 1
961        {
962            Text [ en-US ] = "The end date for calculating the difference in days." ;
963        };
964        String 4 // Name of Parameter 2
965        {
966            Text [ en-US ] = "Date_1" ;
967        };
968        String 5 // Description of Parameter 2
969        {
970            Text [ en-US ] = "The start date for calculating the difference in days." ;
971        };
972    };
973     // -=*# Resource for function KALENDERWOCHE #*=-
974    Resource SC_OPCODE_WEEK
975    {
976        String 1 // Description
977        {
978            Text [ en-US ] = "Calculates the calendar week corresponding to the given date." ;
979        };
980        ExtraData =
981        {
982            0;
983            ID_FUNCTION_GRP_DATETIME;
984            U2S( HID_FUNC_KALENDERWOCHE );
985            2;  0;  0;
986            0;
987        };
988        String 2 // Name of Parameter 1
989        {
990            Text [ en-US ] = "Number" ;
991        };
992        String 3 // Description of Parameter 1
993        {
994            Text [ en-US ] = "The internal number of the date." ;
995        };
996        String 4 // Name of Parameter 2
997        {
998            Text [ en-US ] = "mode" ;
999        };
1000        String 5 // Description of Parameter 2
1001        {
1002            Text [ en-US ] = "Indicates the first day of the week (1 = Sunday, other values = Monday)." ;
1003        };
1004    };
1005     // -=*# Resource for function OSTERSONNTAG #*=-
1006    Resource SC_OPCODE_EASTERSUNDAY
1007    {
1008        String 1 // Description
1009        {
1010            Text [ en-US ] = "Calculates the date of Easter Sunday in a given year.";
1011        };
1012        ExtraData =
1013        {
1014            0;
1015            ID_FUNCTION_GRP_DATETIME;
1016            U2S( HID_FUNC_OSTERSONNTAG );
1017            1;  0;
1018            0;
1019        };
1020        String 2 // Name of Parameter 1
1021        {
1022            Text [ en-US ] = "year";
1023        };
1024        String 3 // Description of Parameter 1
1025        {
1026            Text [ en-US ] = "An integer between 1583 and 9956, or 0 and 99 (19xx or 20xx depending on the option set).";
1027        };
1028    };
1029     // -=*# Resource for function BW #*=-
1030    Resource SC_OPCODE_BW
1031    {
1032        String 1 // Description
1033        {
1034            Text [ en-US ] = "Present value. Calculates the present value of an investment." ;
1035        };
1036        ExtraData =
1037        {
1038            0;
1039            ID_FUNCTION_GRP_FINANZ;
1040            U2S( HID_FUNC_BW );
1041            5;  0;  0;  0;  1;  1;
1042            0;
1043        };
1044        String 2 // Name of Parameter 1
1045        {
1046            Text [ en-US ] = "Rate" ;
1047        };
1048        String 3 // Description of Parameter 1
1049        {
1050            Text [ en-US ] = "The rate of interest for the period given." ;
1051        };
1052        String 4 // Name of Parameter 2
1053        {
1054            Text [ en-US ] = "NPER" ;
1055        };
1056        String 5 // Description of Parameter 2
1057        {
1058            Text [ en-US ] = "The payment period. The total number of periods in which the annuity is paid." ;
1059        };
1060        String 6 // Name of Parameter 3
1061        {
1062            Text [ en-US ] = "PMT" ;
1063        };
1064        String 7 // Description of Parameter 3
1065        {
1066            Text [ en-US ] = "Regular payments. The constant amount of annuity that is paid in each period." ;
1067        };
1068        String 8 // Name of Parameter 4
1069        {
1070            Text [ en-US ] = "FV" ;
1071        };
1072        String 9 // Description of Parameter 4
1073        {
1074            Text [ en-US ] = "Future value. The value (final value) to be attained after the last payment." ;
1075        };
1076        String 10 // Name of Parameter 5
1077        {
1078            Text [ en-US ] = "Type" ;
1079        };
1080        String 11 // Description of Parameter 5
1081        {
1082            Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
1083        };
1084    };
1085     // -=*# Resource for function ZW #*=-
1086    Resource SC_OPCODE_ZW
1087    {
1088        String 1 // Description
1089        {
1090            Text [ en-US ] = "Future value. Returns the future value of an investment based on regular payments and a constant interest rate." ;
1091        };
1092        ExtraData =
1093        {
1094            0;
1095            ID_FUNCTION_GRP_FINANZ;
1096            U2S( HID_FUNC_ZW );
1097            5;  0;  0;  0;  1;  1;
1098            0;
1099        };
1100        String 2 // Name of Parameter 1
1101        {
1102            Text [ en-US ] = "Rate" ;
1103        };
1104        String 3 // Description of Parameter 1
1105        {
1106            Text [ en-US ] = "The rate of interest per period." ;
1107        };
1108        String 4 // Name of Parameter 2
1109        {
1110            Text [ en-US ] = "NPER" ;
1111        };
1112        String 5 // Description of Parameter 2
1113        {
1114            Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ;
1115        };
1116        String 6 // Name of Parameter 3
1117        {
1118            Text [ en-US ] = "PMT" ;
1119        };
1120        String 7 // Description of Parameter 3
1121        {
1122            Text [ en-US ] = "Regular payments. The constant annuity to be paid in each period." ;
1123        };
1124        String 8 // Name of Parameter 4
1125        {
1126            Text [ en-US ] = "PV" ;
1127        };
1128        String 9 // Description of Parameter 4
1129        {
1130            Text [ en-US ] = "Present value. The current value of a series of payments" ;
1131        };
1132        String 10 // Name of Parameter 5
1133        {
1134            Text [ en-US ] = "Type" ;
1135        };
1136        String 11 // Description of Parameter 5
1137        {
1138            Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
1139        };
1140    };
1141     // -=*# Resource for function ZZR #*=-
1142    Resource SC_OPCODE_ZZR
1143    {
1144        String 1 // Description
1145        {
1146            Text [ en-US ] = "Payment period. Calculates the number of payment periods for an investment based on regular payments and a constant interest rate." ;
1147        };
1148        ExtraData =
1149        {
1150            0;
1151            ID_FUNCTION_GRP_FINANZ;
1152            U2S( HID_FUNC_ZZR );
1153            5;  0;  0;  0;  1;  1;
1154            0;
1155        };
1156        String 2 // Name of Parameter 1
1157        {
1158            Text [ en-US ] = "Rate" ;
1159        };
1160        String 3 // Description of Parameter 1
1161        {
1162            Text [ en-US ] = "The rate of interest per period." ;
1163        };
1164        String 4 // Name of Parameter 2
1165        {
1166            Text [ en-US ] = "PMT" ;
1167        };
1168        String 5 // Description of Parameter 2
1169        {
1170            Text [ en-US ] = "Regular payments. The constant annuity to be paid in each period." ;
1171        };
1172        String 6 // Name of Parameter 3
1173        {
1174            Text [ en-US ] = "PV" ;
1175        };
1176        String 7 // Description of Parameter 3
1177        {
1178            Text [ en-US ] = "Present value. The current value of a series of payments" ;
1179        };
1180        String 8 // Name of Parameter 4
1181        {
1182            Text [ en-US ] = "FV" ;
1183        };
1184        String 9 // Description of Parameter 4
1185        {
1186            Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ;
1187        };
1188        String 10 // Name of Parameter 5
1189        {
1190            Text [ en-US ] = "Type" ;
1191        };
1192        String 11 // Description of Parameter 5
1193        {
1194            Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
1195        };
1196    };
1197     // -=*# Resource for function RMZ #*=-
1198    Resource SC_OPCODE_RMZ
1199    {
1200        String 1 // Description
1201        {
1202            Text [ en-US ] = "Regular payments. Returns the periodic payment of an annuity, based on regular payments and a fixed periodic interest rate." ;
1203        };
1204        ExtraData =
1205        {
1206            0;
1207            ID_FUNCTION_GRP_FINANZ;
1208            U2S( HID_FUNC_RMZ );
1209            5;  0;  0;  0;  1;  1;
1210            0;
1211        };
1212        String 2 // Name of Parameter 1
1213        {
1214            Text [ en-US ] = "Rate" ;
1215        };
1216        String 3 // Description of Parameter 1
1217        {
1218            Text [ en-US ] = "The rate of interest per period." ;
1219        };
1220        String 4 // Name of Parameter 2
1221        {
1222            Text [ en-US ] = "NPER" ;
1223        };
1224        String 5 // Description of Parameter 2
1225        {
1226            Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ;
1227        };
1228        String 6 // Name of Parameter 3
1229        {
1230            Text [ en-US ] = "PV" ;
1231        };
1232        String 7 // Description of Parameter 3
1233        {
1234            Text [ en-US ] = "Present value. The current value of a series of payments" ;
1235        };
1236        String 8 // Name of Parameter 4
1237        {
1238            Text [ en-US ] = "FV" ;
1239        };
1240        String 9 // Description of Parameter 4
1241        {
1242            Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ;
1243        };
1244        String 10 // Name of Parameter 5
1245        {
1246            Text [ en-US ] = "Type" ;
1247        };
1248        String 11 // Description of Parameter 5
1249        {
1250            Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
1251        };
1252    };
1253     // -=*# Resource for function ZINS #*=-
1254    Resource SC_OPCODE_ZINS
1255    {
1256        String 1 // Description
1257        {
1258            Text [ en-US ] = "Calculates the constant interest rate of an investment with regular payments." ;
1259        };
1260        ExtraData =
1261        {
1262            0;
1263            ID_FUNCTION_GRP_FINANZ;
1264            U2S( HID_FUNC_ZINS );
1265            6;  0;  0;  0;  1;  1;  1;
1266            0;
1267        };
1268        String 2 // Name of Parameter 1
1269        {
1270            Text [ en-US ] = "NPER" ;
1271        };
1272        String 3 // Description of Parameter 1
1273        {
1274            Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ;
1275        };
1276        String 4 // Name of Parameter 2
1277        {
1278            Text [ en-US ] = "PMT" ;
1279        };
1280        String 5 // Description of Parameter 2
1281        {
1282            Text [ en-US ] = "Regular payments. The constant annuity to be paid in each period." ;
1283        };
1284        String 6 // Name of Parameter 3
1285        {
1286            Text [ en-US ] = "PV" ;
1287        };
1288        String 7 // Description of Parameter 3
1289        {
1290            Text [ en-US ] = "Present value. The current value of a series of payments" ;
1291        };
1292        String 8 // Name of Parameter 4
1293        {
1294            Text [ en-US ] = "FV" ;
1295        };
1296        String 9 // Description of Parameter 4
1297        {
1298            Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ;
1299        };
1300        String 10 // Name of Parameter 5
1301        {
1302            Text [ en-US ] = "Type" ;
1303        };
1304        String 11 // Description of Parameter 5
1305        {
1306            Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
1307        };
1308        String 12 // Name of Parameter 6
1309        {
1310            Text [ en-US ] = "Guess" ;
1311        };
1312        String 13 // Description of Parameter 6
1313        {
1314            Text [ en-US ] = "Guess. The estimate of the interest rate for the iterative calculating method." ;
1315        };
1316    };
1317     // -=*# Resource for function ZINSZ #*=-
1318    Resource SC_OPCODE_ZINS_Z
1319    {
1320        String 1 // Description
1321        {
1322            Text [ en-US ] = "Compounded interest. Calculates the interest payment on the principal for an investment with regular payments and a constant interest rate for a given period." ;
1323        };
1324        ExtraData =
1325        {
1326            0;
1327            ID_FUNCTION_GRP_FINANZ;
1328            U2S( HID_FUNC_ZINSZ );
1329            6;  0;  0;  0;  0;  1;  1;
1330            0;
1331        };
1332        String 2 // Name of Parameter 1
1333        {
1334            Text [ en-US ] = "Rate" ;
1335        };
1336        String 3 // Description of Parameter 1
1337        {
1338            Text [ en-US ] = "The rate of interest per period." ;
1339        };
1340        String 4 // Name of Parameter 2
1341        {
1342            Text [ en-US ] = "Period" ;
1343        };
1344        String 5 // Description of Parameter 2
1345        {
1346            Text [ en-US ] = "Periods. The periods for which the compounded interest is to be calculated. P = 1 denotes for the first period, P = NPER for the last one." ;
1347        };
1348        String 6 // Name of Parameter 3
1349        {
1350            Text [ en-US ] = "NPER" ;
1351        };
1352        String 7 // Description of Parameter 3
1353        {
1354            Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ;
1355        };
1356        String 8 // Name of Parameter 4
1357        {
1358            Text [ en-US ] = "pv" ;
1359        };
1360        String 9 // Description of Parameter 4
1361        {
1362            Text [ en-US ] = "Present value. The current value of a series of payments" ;
1363        };
1364        String 10 // Name of Parameter 5
1365        {
1366            Text [ en-US ] = "FV" ;
1367        };
1368        String 11 // Description of Parameter 5
1369        {
1370            Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ;
1371        };
1372        String 12 // Name of Parameter 6
1373        {
1374            Text [ en-US ] = "Type" ;
1375        };
1376        String 13 // Description of Parameter 6
1377        {
1378            Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
1379        };
1380    };
1381     // -=*# Resource for function KAPZ #*=-
1382    Resource SC_OPCODE_KAPZ
1383    {
1384        String 1 // Description
1385        {
1386            Text [ en-US ] = "Repayment. Calculates the repayment amount for a period for an investment whereby the payments are at regular intervals and the interest rate constant." ;
1387        };
1388        ExtraData =
1389        {
1390            0;
1391            ID_FUNCTION_GRP_FINANZ;
1392            U2S( HID_FUNC_KAPZ );
1393            6;  0;  0;  0;  0;  1;  1;
1394            0;
1395        };
1396        String 2 // Name of Parameter 1
1397        {
1398            Text [ en-US ] = "Rate" ;
1399        };
1400        String 3 // Description of Parameter 1
1401        {
1402            Text [ en-US ] = "The interest rate per period." ;
1403        };
1404        String 4 // Name of Parameter 2
1405        {
1406            Text [ en-US ] = "Period" ;
1407        };
1408        String 5 // Description of Parameter 2
1409        {
1410            Text [ en-US ] = "Period. The period for which the repayments are to be calculated. Per = 1 denotes for the first period, P = NPER for the last" ;
1411        };
1412        String 6 // Name of Parameter 3
1413        {
1414            Text [ en-US ] = "NPER" ;
1415        };
1416        String 7 // Description of Parameter 3
1417        {
1418            Text [ en-US ] = "The payment period. The total number of periods in which the annuity (pension) is paid." ;
1419        };
1420        String 8 // Name of Parameter 4
1421        {
1422            Text [ en-US ] = "PV" ;
1423        };
1424        String 9 // Description of Parameter 4
1425        {
1426            Text [ en-US ] = "The present value. The present value or the amount the annuity is currently worth." ;
1427        };
1428        String 10 // Name of Parameter 5
1429        {
1430            Text [ en-US ] = "FV" ;
1431        };
1432        String 11 // Description of Parameter 5
1433        {
1434            Text [ en-US ] = "Future value. The value (end value) attained after the last payment has been made." ;
1435        };
1436        String 12 // Name of Parameter 6
1437        {
1438            Text [ en-US ] = "Type" ;
1439        };
1440        String 13 // Description of Parameter 6
1441        {
1442            Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
1443        };
1444    };
1445     // -=*# Resource for function KUMKAPITAL #*=-
1446    Resource SC_OPCODE_KUM_KAP_Z
1447    {
1448        String 1 // Description
1449        {
1450            Text [ en-US ] = "Cumulative Capital. Calculates the total amount of the repayment share in a period for an investment with constant interest rate." ;
1451        };
1452        ExtraData =
1453        {
1454            0;
1455            ID_FUNCTION_GRP_FINANZ;
1456            U2S( HID_FUNC_KUMKAPITAL );
1457            6;  0;  0;  0;  0;  0;  0;
1458            0;
1459        };
1460        String 2 // Name of Parameter 1
1461        {
1462            Text [ en-US ] = "Rate" ;
1463        };
1464        String 3 // Description of Parameter 1
1465        {
1466            Text [ en-US ] = "The rate of interest per period." ;
1467        };
1468        String 4 // Name of Parameter 2
1469        {
1470            Text [ en-US ] = "NPER" ;
1471        };
1472        String 5 // Description of Parameter 2
1473        {
1474            Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ;
1475        };
1476        String 6 // Name of Parameter 3
1477        {
1478            Text [ en-US ] = "PV" ;
1479        };
1480        String 7 // Description of Parameter 3
1481        {
1482            Text [ en-US ] = "The present value. The present value or the amount the annuity is currently worth." ;
1483        };
1484        String 8 // Name of Parameter 4
1485        {
1486            Text [ en-US ] = "S" ;
1487        };
1488        String 9 // Description of Parameter 4
1489        {
1490            Text [ en-US ] = "The start period. The first period to be taken into account. A = 1 denotes the very first period." ;
1491        };
1492        String 10 // Name of Parameter 5
1493        {
1494            Text [ en-US ] = "E" ;
1495        };
1496        String 11 // Description of Parameter 5
1497        {
1498            Text [ en-US ] = "End period. The last period to be taken into account." ;
1499        };
1500        String 12 // Name of Parameter 6
1501        {
1502            Text [ en-US ] = "Type" ;
1503        };
1504        String 13 // Description of Parameter 6
1505        {
1506            Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
1507        };
1508    };
1509     // -=*# Resource for function KUMZINSZ #*=-
1510    Resource SC_OPCODE_KUM_ZINS_Z
1511    {
1512        String 1 // Description
1513        {
1514            Text [ en-US ] = "Cumulative compounded interest. Calculates the total amount of the interest share in a period for an investment with a constant interest rate." ;
1515        };
1516        ExtraData =
1517        {
1518            0;
1519            ID_FUNCTION_GRP_FINANZ;
1520            U2S( HID_FUNC_KUMZINSZ );
1521            6;  0;  0;  0;  0;  0;  0;
1522            0;
1523        };
1524        String 2 // Name of Parameter 1
1525        {
1526            Text [ en-US ] = "Rate" ;
1527        };
1528        String 3 // Description of Parameter 1
1529        {
1530            Text [ en-US ] = "The rate of interest per period." ;
1531        };
1532        String 4 // Name of Parameter 2
1533        {
1534            Text [ en-US ] = "NPER" ;
1535        };
1536        String 5 // Description of Parameter 2
1537        {
1538            Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ;
1539        };
1540        String 6 // Name of Parameter 3
1541        {
1542            Text [ en-US ] = "pv" ;
1543        };
1544        String 7 // Description of Parameter 3
1545        {
1546            Text [ en-US ] = "The present value. The present value or the amount the annuity is currently worth." ;
1547        };
1548        String 8 // Name of Parameter 4
1549        {
1550            Text [ en-US ] = "S" ;
1551        };
1552        String 9 // Description of Parameter 4
1553        {
1554            Text [ en-US ] = "The start period. The first period to be taken into account. A = 1 denotes the very first period." ;
1555        };
1556        String 10 // Name of Parameter 5
1557        {
1558            Text [ en-US ] = "E" ;
1559        };
1560        String 11 // Description of Parameter 5
1561        {
1562            Text [ en-US ] = "The end period. The last period to be taken into account." ;
1563        };
1564        String 12 // Name of Parameter 6
1565        {
1566            Text [ en-US ] = "Type" ;
1567        };
1568        String 13 // Description of Parameter 6
1569        {
1570            Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
1571        };
1572    };
1573     // -=*# Resource for function DIA #*=-
1574    Resource SC_OPCODE_DIA
1575    {
1576        String 1 // Description
1577        {
1578            Text [ en-US ] = "Calculates the arithmetically declining value of an asset (depreciation) for a specified period." ;
1579        };
1580        ExtraData =
1581        {
1582            0;
1583            ID_FUNCTION_GRP_FINANZ;
1584            U2S( HID_FUNC_DIA );
1585            4;  0;  0;  0;  0;
1586            0;
1587        };
1588        String 2 // Name of Parameter 1
1589        {
1590            Text [ en-US ] = "Cost" ;
1591        };
1592        String 3 // Description of Parameter 1
1593        {
1594            Text [ en-US ] = "Acquisition costs. The initial cost of the asset." ;
1595        };
1596        String 4 // Name of Parameter 2
1597        {
1598            Text [ en-US ] = "Salvage" ;
1599        };
1600        String 5 // Description of Parameter 2
1601        {
1602            Text [ en-US ] = "Salvage: The remaining value of the asset at the end of its life." ;
1603        };
1604        String 6 // Name of Parameter 3
1605        {
1606            Text [ en-US ] = "Life" ;
1607        };
1608        String 7 // Description of Parameter 3
1609        {
1610            Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ;
1611        };
1612        String 8 // Name of Parameter 4
1613        {
1614            Text [ en-US ] = "Period" ;
1615        };
1616        String 9 // Description of Parameter 4
1617        {
1618            Text [ en-US ] = "Period. The depreciation period which must have the same time unit as average useful life." ;
1619        };
1620    };
1621     // -=*# Resource for function LIA #*=-
1622    Resource SC_OPCODE_LIA
1623    {
1624        String 1 // Description
1625        {
1626            Text [ en-US ] = "Calculates the linear depreciation per period." ;
1627        };
1628        ExtraData =
1629        {
1630            0;
1631            ID_FUNCTION_GRP_FINANZ;
1632            U2S( HID_FUNC_LIA );
1633            3;  0;  0;  0;
1634            0;
1635        };
1636        String 2 // Name of Parameter 1
1637        {
1638            Text [ en-US ] = "Cost" ;
1639        };
1640        String 3 // Description of Parameter 1
1641        {
1642            Text [ en-US ] = "Acquisition cost. The initial cost of an asset." ;
1643        };
1644        String 4 // Name of Parameter 2
1645        {
1646            Text [ en-US ] = "Salvage" ;
1647        };
1648        String 5 // Description of Parameter 2
1649        {
1650            Text [ en-US ] = "Salvage: The remaining value of the asset at the end of its life." ;
1651        };
1652        String 6 // Name of Parameter 3
1653        {
1654            Text [ en-US ] = "Life" ;
1655        };
1656        String 7 // Description of Parameter 3
1657        {
1658            Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ;
1659        };
1660    };
1661     // -=*# Resource for function GDA #*=-
1662    Resource SC_OPCODE_GDA
1663    {
1664        String 1 // Description
1665        {
1666            Text [ en-US ] = "Calculates the depreciation of an asset for a specific period using the double-declining balance method or declining balance factor." ;
1667        };
1668        ExtraData =
1669        {
1670            0;
1671            ID_FUNCTION_GRP_FINANZ;
1672            U2S( HID_FUNC_GDA );
1673            5;  0;  0;  0;  0;  1;
1674            0;
1675        };
1676        String 2 // Name of Parameter 1
1677        {
1678            Text [ en-US ] = "Cost" ;
1679        };
1680        String 3 // Description of Parameter 1
1681        {
1682            Text [ en-US ] = "Acquisition costs. The initial cost of the asset." ;
1683        };
1684        String 4 // Name of Parameter 2
1685        {
1686            Text [ en-US ] = "Salvage" ;
1687        };
1688        String 5 // Description of Parameter 2
1689        {
1690            Text [ en-US ] = "Salvage: The remaining value of the asset at the end of its life." ;
1691        };
1692        String 6 // Name of Parameter 3
1693        {
1694            Text [ en-US ] = "Life" ;
1695        };
1696        String 7 // Description of Parameter 3
1697        {
1698            Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ;
1699        };
1700        String 8 // Name of Parameter 4
1701        {
1702            Text [ en-US ] = "Period" ;
1703        };
1704        String 9 // Description of Parameter 4
1705        {
1706            Text [ en-US ] = "Period. The depreciation period in the same time unit as the average useful life entry." ;
1707        };
1708        String 10 // Name of Parameter 5
1709        {
1710            Text [ en-US ] = "Factor" ;
1711        };
1712        String 11 // Description of Parameter 5
1713        {
1714            Text [ en-US ] = "Factor. The factor for balance decline. F = 2 means a double declining balance factor" ;
1715        };
1716    };
1717     // -=*# Resource for function GDA2 #*=-
1718    Resource SC_OPCODE_GDA_2
1719    {
1720        String 1 // Description
1721        {
1722            Text [ en-US ] = "Returns the real depreciation of an asset for a specified period using the fixed-declining balance method." ;
1723        };
1724        ExtraData =
1725        {
1726            0;
1727            ID_FUNCTION_GRP_FINANZ;
1728            U2S( HID_FUNC_GDA2 );
1729            5;  0;  0;  0;  0;  1;
1730            0;
1731        };
1732        String 2 // Name of Parameter 1
1733        {
1734            Text [ en-US ] = "Cost" ;
1735        };
1736        String 3 // Description of Parameter 1
1737        {
1738            Text [ en-US ] = "Acquisition costs: The initial cost of the asset." ;
1739        };
1740        String 4 // Name of Parameter 2
1741        {
1742            Text [ en-US ] = "Salvage" ;
1743        };
1744        String 5 // Description of Parameter 2
1745        {
1746            Text [ en-US ] = "Salvage: The remaining value of the asset at the end of its life." ;
1747        };
1748        String 6 // Name of Parameter 3
1749        {
1750            Text [ en-US ] = "Life" ;
1751        };
1752        String 7 // Description of Parameter 3
1753        {
1754            Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ;
1755        };
1756        String 8 // Name of Parameter 4
1757        {
1758            Text [ en-US ] = "Period" ;
1759        };
1760        String 9 // Description of Parameter 4
1761        {
1762            Text [ en-US ] = "Periods: The period for which the depreciation is calculated. The time unit used for period must be the same as that for the useful life." ;
1763        };
1764        String 10 // Name of Parameter 5
1765        {
1766            Text [ en-US ] = "month" ;
1767        };
1768        String 11 // Description of Parameter 5
1769        {
1770            Text [ en-US ] = "Months: The number of months in the first year of depreciation." ;
1771        };
1772    };
1773     // -=*# Resource for function VDB #*=-
1774    Resource SC_OPCODE_VBD
1775    {
1776        String 1 // Description
1777        {
1778            Text [ en-US ] = "Variable declining balance. Returns the declining balance depreciation for a particular period." ;
1779        };
1780        ExtraData =
1781        {
1782            0;
1783            ID_FUNCTION_GRP_FINANZ;
1784            U2S( HID_FUNC_VDB );
1785            7;  0;  0;  0;  0;  0;  1;  1;
1786            0;
1787        };
1788        String 2 // Name of Parameter 1
1789        {
1790            Text [ en-US ] = "Cost" ;
1791        };
1792        String 3 // Description of Parameter 1
1793        {
1794            Text [ en-US ] = "Cost. The initial cost of the asset." ;
1795        };
1796        String 4 // Name of Parameter 2
1797        {
1798            Text [ en-US ] = "Salvage" ;
1799        };
1800        String 5 // Description of Parameter 2
1801        {
1802            Text [ en-US ] = "Salvage. The salvage value of an asset at the end of its useful life." ;
1803        };
1804        String 6 // Name of Parameter 3
1805        {
1806            Text [ en-US ] = "Life" ;
1807        };
1808        String 7 // Description of Parameter 3
1809        {
1810            Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ;
1811        };
1812        String 8 // Name of Parameter 4
1813        {
1814            Text [ en-US ] = "S" ;
1815        };
1816        String 9 // Description of Parameter 4
1817        {
1818            Text [ en-US ] = "Start. The first period for depreciation in the same time unit as the useful life." ;
1819        };
1820        String 10 // Name of Parameter 5
1821        {
1822            Text [ en-US ] = "end" ;
1823        };
1824        String 11 // Description of Parameter 5
1825        {
1826            Text [ en-US ] = "End. The last period of the depreciation using the same time unit as for the useful life." ;
1827        };
1828        String 12 // Name of Parameter 6
1829        {
1830            Text [ en-US ] = "Factor" ;
1831        };
1832        String 13 // Description of Parameter 6
1833        {
1834            Text [ en-US ] = "Factor. The factor for the reduction of the depreciation. F = 2 denotes double rate depreciation." ;
1835        };
1836        String 14 // Name of Parameter 7
1837        {
1838            Text [ en-US ] = "Type" ;
1839        };
1840        String 15 // Description of Parameter 7
1841        {
1842            Text [ en-US ] = "Do not alter. Type = 1 denotes switch to linear depreciation, type = 0 do not switch." ;
1843        };
1844    };
1845     // -=*# Resource for function EFFEKTIV #*=-
1846    Resource SC_OPCODE_EFFEKTIV
1847    {
1848        String 1 // Description
1849        {
1850            Text [ en-US ] = "Calculates the annual net interest rate for a nominal interest rate." ;
1851        };
1852        ExtraData =
1853        {
1854            0;
1855            ID_FUNCTION_GRP_FINANZ;
1856            U2S( HID_FUNC_EFFEKTIV );
1857            2;  0;  0;
1858            0;
1859        };
1860        String 2 // Name of Parameter 1
1861        {
1862            Text [ en-US ] = "NOM" ;
1863        };
1864        String 3 // Description of Parameter 1
1865        {
1866            Text [ en-US ] = "Nominal Interest" ;
1867        };
1868        String 4 // Name of Parameter 2
1869        {
1870            Text [ en-US ] = "P" ;
1871        };
1872        String 5 // Description of Parameter 2
1873        {
1874            Text [ en-US ] = "Periods. The number of interest payments per year." ;
1875        };
1876    };
1877     // -=*# Resource for function NOMINAL #*=-
1878    Resource SC_OPCODE_NOMINAL
1879    {
1880        String 1 // Description
1881        {
1882            Text [ en-US ] = "Calculates the yearly nominal interest rate as an effective interest rate." ;
1883        };
1884        ExtraData =
1885        {
1886            0;
1887            ID_FUNCTION_GRP_FINANZ;
1888            U2S( HID_FUNC_NOMINAL );
1889            2;  0;  0;
1890            0;
1891        };
1892        String 2 // Name of Parameter 1
1893        {
1894            Text [ en-US ] = "effect_rate" ;
1895        };
1896        String 3 // Description of Parameter 1
1897        {
1898            Text [ en-US ] = "The effective interest rate" ;
1899        };
1900        String 4 // Name of Parameter 2
1901        {
1902            Text [ en-US ] = "npery" ;
1903        };
1904        String 5 // Description of Parameter 2
1905        {
1906            Text [ en-US ] = "Periods. The number of interest payment per year." ;
1907        };
1908    };
1909     // -=*# Resource for function NBW #*=-
1910    Resource SC_OPCODE_NBW
1911    {
1912        String 1 // Description
1913        {
1914            Text [ en-US ] = "Net present value. Calculates the net present value of an investment based on a series of periodic payments and a discount rate." ;
1915        };
1916        ExtraData =
1917        {
1918            0;
1919            ID_FUNCTION_GRP_FINANZ;
1920            U2S( HID_FUNC_NBW );
1921            VAR_ARGS+1; 0;  0;
1922            0;
1923        };
1924        String 2 // Name of Parameter 1
1925        {
1926            Text [ en-US ] = "RATE" ;
1927        };
1928        String 3 // Description of Parameter 1
1929        {
1930            Text [ en-US ] = "The rate of discount for one period." ;
1931        };
1932        String 4 // Name of Parameter 2
1933        {
1934            Text [ en-US ] = "value " ;
1935        };
1936        String 5 // Description of Parameter 2
1937        {
1938            Text [ en-US ] = "Value 1, value 2,... are 1 to 30 arguments representing payments and income." ;
1939        };
1940    };
1941     // -=*# Resource for function IKV #*=-
1942    Resource SC_OPCODE_IKV
1943    {
1944        String 1 // Description
1945        {
1946            Text [ en-US ] = "Returns the actuarial rate of interest of an investment excluding costs or profits." ;
1947        };
1948        ExtraData =
1949        {
1950            0;
1951            ID_FUNCTION_GRP_FINANZ;
1952            U2S( HID_FUNC_IKV );
1953            2;  0;  1;
1954            0;
1955        };
1956        String 2 // Name of Parameter 1
1957        {
1958            Text [ en-US ] = "Values" ;
1959        };
1960        String 3 // Description of Parameter 1
1961        {
1962            Text [ en-US ] = "An array or reference to cells whose contents correspond to the payments. " ;
1963        };
1964        String 4 // Name of Parameter 2
1965        {
1966            Text [ en-US ] = "Guess" ;
1967        };
1968        String 5 // Description of Parameter 2
1969        {
1970            Text [ en-US ] = "Guess. An estimated value of the rate of return to be used for the iteration calculation." ;
1971        };
1972    };
1973     // -=*# Resource for function QIKV/MIRR #*=-
1974    Resource SC_OPCODE_MIRR
1975    {
1976        String 1 // Description
1977        {
1978            Text [ en-US ] = "Returns the modified internal rate of return for a series of investments.";
1979        };
1980        ExtraData =
1981        {
1982            0;
1983            ID_FUNCTION_GRP_FINANZ;
1984            U2S( HID_FUNC_QIKV );
1985            3;  0;  0;  0;
1986            0;
1987        };
1988        String 2 // Name of Parameter 1
1989        {
1990            Text [ en-US ] = "Values";
1991        };
1992        String 3 // Description of Parameter 1
1993        {
1994            Text [ en-US ] = "An array or reference to cells whose contents correspond to the payments.";
1995        };
1996        String 4 // Name of Parameter 2
1997        {
1998            Text [ en-US ] = "investment";
1999        };
2000        String 5 // Description of Parameter 2
2001        {
2002            Text [ en-US ] = "Interest rate for investments (the negative values in the array).";
2003        };
2004        String 6 // Name of Parameter 3
2005        {
2006            Text [ en-US ] = "reinvest_rate";
2007        };
2008        String 7 // Description of Parameter 3
2009        {
2010            Text [ en-US ] = "interest rate for reinvestments (the positive values in the array).";
2011        };
2012    };
2013     // -=*# Resource for function ISPMT #*=-
2014    Resource SC_OPCODE_ISPMT
2015    {
2016        String 1 // Description
2017        {
2018            Text [ en-US ] = "Returns the amount of interest for constant amortization rates.";
2019        };
2020        ExtraData =
2021        {
2022            0;
2023            ID_FUNCTION_GRP_FINANZ;
2024            U2S( HID_FUNC_ISPMT );
2025            4;  0;  0;  0;  0;
2026            0;
2027        };
2028        String 2 // Name of Parameter 1
2029        {
2030            Text [ en-US ] = "rate";
2031        };
2032        String 3 // Description of Parameter 1
2033        {
2034            Text [ en-US ] = "Interest rate for a single amortization rate.";
2035        };
2036        String 4 // Name of Parameter 2
2037        {
2038            Text [ en-US ] = "Period";
2039        };
2040        String 5 // Description of Parameter 2
2041        {
2042            Text [ en-US ] = "Number of amortization periods for the calculation of the interest.";
2043        };
2044        String 6 // Name of Parameter 3
2045        {
2046            Text [ en-US ] = "total_periods";
2047        };
2048        String 7 // Description of Parameter 3
2049        {
2050            Text [ en-US ] = "Sum total of amortization periods.";
2051        };
2052        String 8 // Name of Parameter 4
2053        {
2054            Text [ en-US ] = "invest";
2055        };
2056        String 9 // Description of Parameter 4
2057        {
2058            Text [ en-US ] = "Amount of the investment.";
2059        };
2060    };
2061     // -=*# Resource for function LAUFZEIT #*=-
2062    Resource SC_OPCODE_LAUFZ
2063    {
2064        String 1 // Description
2065        {
2066            Text [ en-US ] = "Duration. Calculates the number of periods required by an investment to attain the desired value." ;
2067        };
2068        ExtraData =
2069        {
2070            0;
2071            ID_FUNCTION_GRP_FINANZ;
2072            U2S( HID_FUNC_LAUFZEIT );
2073            3;  0;  0;  0;
2074            0;
2075        };
2076        String 2 // Name of Parameter 1
2077        {
2078            Text [ en-US ] = "RATE" ;
2079        };
2080        String 3 // Description of Parameter 1
2081        {
2082            Text [ en-US ] = "The constant rate of interest." ;
2083        };
2084        String 4 // Name of Parameter 2
2085        {
2086            Text [ en-US ] = "pv" ;
2087        };
2088        String 5 // Description of Parameter 2
2089        {
2090            Text [ en-US ] = "The present value. The current value of the investment." ;
2091        };
2092        String 6 // Name of Parameter 3
2093        {
2094            Text [ en-US ] = "FV" ;
2095        };
2096        String 7 // Description of Parameter 3
2097        {
2098            Text [ en-US ] = "The future value of the investment." ;
2099        };
2100    };
2101     // -=*# Resource for function ZGZ #*=-
2102    Resource SC_OPCODE_ZGZ
2103    {
2104        String 1 // Description
2105        {
2106            Text [ en-US ] = "Interest. Calculates the interest rate which represents the rate of return from an investment." ;
2107        };
2108        ExtraData =
2109        {
2110            0;
2111            ID_FUNCTION_GRP_FINANZ;
2112            U2S( HID_FUNC_ZGZ );
2113            3;  0;  0;  0;
2114            0;
2115        };
2116        String 2 // Name of Parameter 1
2117        {
2118            Text [ en-US ] = "P" ;
2119        };
2120        String 3 // Description of Parameter 1
2121        {
2122            Text [ en-US ] = "The number of periods used in the calculation." ;
2123        };
2124        String 4 // Name of Parameter 2
2125        {
2126            Text [ en-US ] = "pv" ;
2127        };
2128        String 5 // Description of Parameter 2
2129        {
2130            Text [ en-US ] = "Present value. The current value of the investment." ;
2131        };
2132        String 6 // Name of Parameter 3
2133        {
2134            Text [ en-US ] = "FV" ;
2135        };
2136        String 7 // Description of Parameter 3
2137        {
2138            Text [ en-US ] = "The future value of the investment." ;
2139        };
2140    };
2141     // -=*# Resource for function ISTBEZUG #*=-
2142    Resource SC_OPCODE_IS_REF
2143    {
2144        String 1 // Description
2145        {
2146            Text [ en-US ] = "Returns TRUE if value is a reference." ;
2147        };
2148        ExtraData =
2149        {
2150            0;
2151            ID_FUNCTION_GRP_INFO;
2152            U2S( HID_FUNC_ISTBEZUG );
2153            1;  0;
2154            0;
2155        };
2156        String 2 // Name of Parameter 1
2157        {
2158            Text [ en-US ] = "value" ;
2159        };
2160        String 3 // Description of Parameter 1
2161        {
2162            Text [ en-US ] = "The value to be tested." ;
2163        };
2164    };
2165     // -=*# Resource for function ISTFEHL #*=-
2166    Resource SC_OPCODE_IS_ERR
2167    {
2168        String 1 // Description
2169        {
2170            Text [ en-US ] = "Returns TRUE if the value is an error value not equal to #N/A." ;
2171        };
2172        ExtraData =
2173        {
2174            0;
2175            ID_FUNCTION_GRP_INFO;
2176            U2S( HID_FUNC_ISTFEHL );
2177            1;  0;
2178            0;
2179        };
2180        String 2 // Name of Parameter 1
2181        {
2182            Text [ en-US ] = "value" ;
2183        };
2184        String 3 // Description of Parameter 1
2185        {
2186            Text [ en-US ] = "The value to be tested." ;
2187        };
2188    };
2189     // -=*# Resource for function ISTFEHLER #*=-
2190    Resource SC_OPCODE_IS_ERROR
2191    {
2192        String 1 // Description
2193        {
2194            Text [ en-US ] = "Returns TRUE if the value is an error value." ;
2195        };
2196        ExtraData =
2197        {
2198            0;
2199            ID_FUNCTION_GRP_INFO;
2200            U2S( HID_FUNC_ISTFEHLER );
2201            1;  0;
2202            0;
2203        };
2204        String 2 // Name of Parameter 1
2205        {
2206            Text [ en-US ] = "value" ;
2207        };
2208        String 3 // Description of Parameter 1
2209        {
2210            Text [ en-US ] = "The value to be tested." ;
2211        };
2212    };
2213     // -=*# Resource for function ISTLEER #*=-
2214    Resource SC_OPCODE_IS_EMPTY
2215    {
2216        String 1 // Description
2217        {
2218            Text [ en-US ] = "Returns TRUE if value refers to an empty cell." ;
2219        };
2220        ExtraData =
2221        {
2222            0;
2223            ID_FUNCTION_GRP_INFO;
2224            U2S( HID_FUNC_ISTLEER );
2225            1;  0;
2226            0;
2227        };
2228        String 2 // Name of Parameter 1
2229        {
2230            Text [ en-US ] = "value" ;
2231        };
2232        String 3 // Description of Parameter 1
2233        {
2234            Text [ en-US ] = "The value to be tested." ;
2235        };
2236    };
2237     // -=*# Resource for function ISTLOG #*=-
2238    Resource SC_OPCODE_IS_LOGICAL
2239    {
2240        String 1 // Description
2241        {
2242            Text [ en-US ] = "Returns TRUE if the value carries a logical number format." ;
2243        };
2244        ExtraData =
2245        {
2246            0;
2247            ID_FUNCTION_GRP_INFO;
2248            U2S( HID_FUNC_ISTLOG );
2249            1;  0;
2250            0;
2251        };
2252        String 2 // Name of Parameter 1
2253        {
2254            Text [ en-US ] = "value" ;
2255        };
2256        String 3 // Description of Parameter 1
2257        {
2258            Text [ en-US ] = "The value to be tested." ;
2259        };
2260    };
2261     // -=*# Resource for function ISTNV #*=-
2262    Resource SC_OPCODE_IS_NV
2263    {
2264        String 1 // Description
2265        {
2266            Text [ en-US ] = "Returns TRUE if value equals #N/A." ;
2267        };
2268        ExtraData =
2269        {
2270            0;
2271            ID_FUNCTION_GRP_INFO;
2272            U2S( HID_FUNC_ISTNV );
2273            1;  0;
2274            0;
2275        };
2276        String 2 // Name of Parameter 1
2277        {
2278            Text [ en-US ] = "value" ;
2279        };
2280        String 3 // Description of Parameter 1
2281        {
2282            Text [ en-US ] = "The value to be tested." ;
2283        };
2284    };
2285     // -=*# Resource for function ISTKTEXT #*=-
2286    Resource SC_OPCODE_IS_NON_STRING
2287    {
2288        String 1 // Description
2289        {
2290            Text [ en-US ] = "Returns TRUE if the value is not text." ;
2291        };
2292        ExtraData =
2293        {
2294            0;
2295            ID_FUNCTION_GRP_INFO;
2296            U2S( HID_FUNC_ISTKTEXT );
2297            1;  0;
2298            0;
2299        };
2300        String 2 // Name of Parameter 1
2301        {
2302            Text [ en-US ] = "value" ;
2303        };
2304        String 3 // Description of Parameter 1
2305        {
2306            Text [ en-US ] = "The value to be tested." ;
2307        };
2308    };
2309     // -=*# Resource for function ISTTEXT #*=-
2310    Resource SC_OPCODE_IS_STRING
2311    {
2312        String 1 // Description
2313        {
2314            Text [ en-US ] = "Returns TRUE if value is text." ;
2315        };
2316        ExtraData =
2317        {
2318            0;
2319            ID_FUNCTION_GRP_INFO;
2320            U2S( HID_FUNC_ISTTEXT );
2321            1;  0;
2322            0;
2323        };
2324        String 2 // Name of Parameter 1
2325        {
2326            Text [ en-US ] = "value" ;
2327        };
2328        String 3 // Description of Parameter 1
2329        {
2330            Text [ en-US ] = "The value to be tested." ;
2331        };
2332    };
2333     // -=*# Resource for function ISTZAHL #*=-
2334    Resource SC_OPCODE_IS_VALUE
2335    {
2336        String 1 // Description
2337        {
2338            Text [ en-US ] = "Returns TRUE if value is a number." ;
2339        };
2340        ExtraData =
2341        {
2342            0;
2343            ID_FUNCTION_GRP_INFO;
2344            U2S( HID_FUNC_ISTZAHL );
2345            1;  0;
2346            0;
2347        };
2348        String 2 // Name of Parameter 1
2349        {
2350            Text [ en-US ] = "value" ;
2351        };
2352        String 3 // Description of Parameter 1
2353        {
2354            Text [ en-US ] = "The value to be tested." ;
2355        };
2356    };
2357     // -=*# Resource for function ISTFORMEL #*=-
2358    Resource SC_OPCODE_IS_FORMULA
2359    {
2360        String 1 // Description
2361        {
2362            Text [ en-US ] = "Returns TRUE if the cell is a formula cell." ;
2363        };
2364        ExtraData =
2365        {
2366            0;
2367            ID_FUNCTION_GRP_INFO;
2368            U2S( HID_FUNC_ISTFORMEL );
2369            1;  0;
2370            0;
2371        };
2372        String 2 // Name of Parameter 1
2373        {
2374            Text [ en-US ] = "reference" ;
2375        };
2376        String 3 // Description of Parameter 1
2377        {
2378            Text [ en-US ] = "The cell to be checked." ;
2379        };
2380    };
2381     // -=*# Resource for function FORMEL #*=-
2382    Resource SC_OPCODE_FORMULA
2383    {
2384        String 1 // Description
2385        {
2386            Text [ en-US ] = "Returns the formula of a formula cell.";
2387        };
2388        ExtraData =
2389        {
2390            0;
2391            ID_FUNCTION_GRP_INFO;
2392            U2S( HID_FUNC_FORMEL );
2393            1;  0;
2394            0;
2395        };
2396        String 2 // Name of Parameter 1
2397        {
2398            Text [ en-US ] = "Reference";
2399        };
2400        String 3 // Description of Parameter 1
2401        {
2402            Text [ en-US ] = "The formula cell.";
2403        };
2404    };
2405     // -=*# Resource for function N #*=-
2406    Resource SC_OPCODE_N
2407    {
2408        String 1 // Description
2409        {
2410            Text [ en-US ] = "Converts a value to a number." ;
2411        };
2412        ExtraData =
2413        {
2414            0;
2415            ID_FUNCTION_GRP_INFO;
2416            U2S( HID_FUNC_N );
2417            1;  0;
2418            0;
2419        };
2420        String 2 // Name of Parameter 1
2421        {
2422            Text [ en-US ] = "value" ;
2423        };
2424        String 3 // Description of Parameter 1
2425        {
2426            Text [ en-US ] = "The value to be interpreted as a number." ;
2427        };
2428    };
2429     // -=*# Resource for function NV #*=-
2430    Resource SC_OPCODE_NO_VALUE
2431    {
2432        String 1 // Description
2433        {
2434            Text [ en-US ] = "Not available. Returns the error value #N/A." ;
2435        };
2436        ExtraData =
2437        {
2438            0;
2439            ID_FUNCTION_GRP_INFO;
2440            U2S( HID_FUNC_NV );
2441            0;
2442            0;
2443        };
2444    };
2445     // -=*# Resource for function TYP #*=-
2446    Resource SC_OPCODE_TYPE
2447    {
2448        String 1 // Description
2449        {
2450            Text [ en-US ] = "Defines the data type of a value." ;
2451        };
2452        ExtraData =
2453        {
2454            0;
2455            ID_FUNCTION_GRP_INFO;
2456            U2S( HID_FUNC_TYP );
2457            1;  0;
2458            0;
2459        };
2460        String 2 // Name of Parameter 1
2461        {
2462            Text [ en-US ] = "value" ;
2463        };
2464        String 3 // Description of Parameter 1
2465        {
2466            Text [ en-US ] = "The value for which the data type is to be determined." ;
2467        };
2468    };
2469     // -=*# Resource for function CELL/ZELLE #*=-
2470    Resource SC_OPCODE_CELL
2471    {
2472        String 1 // Description
2473        {
2474            Text [ en-US ] = "Determines information about address, formatting or contents of a cell.";
2475        };
2476        ExtraData =
2477        {
2478            0;
2479            ID_FUNCTION_GRP_INFO;
2480            U2S( HID_FUNC_ZELLE );
2481            2;  0;  1;
2482            0;
2483        };
2484        String 2 // Name of Parameter 1
2485        {
2486            Text [ en-US ] = "info_type";
2487        };
2488        String 3 // Description of Parameter 1
2489        {
2490            Text [ en-US ] = "String that specifies the type of information.";
2491        };
2492        String 4 // Name of Parameter 2
2493        {
2494            Text [ en-US ] = "Reference";
2495        };
2496        String 5 // Description of Parameter 2
2497        {
2498            Text [ en-US ] = "The position of the cell you want to examine.";
2499        };
2500    };
2501     // -=*# Resource for function AKTUELL #*=-
2502    Resource SC_OPCODE_CURRENT
2503    {
2504        String 1 // Description
2505        {
2506            Text [ en-US ] = "Calculates the current value of the formula at the present location. " ;
2507        };
2508        ExtraData =
2509        {
2510            0;
2511            ID_FUNCTION_GRP_INFO;
2512            U2S( HID_FUNC_AKTUELL );
2513            0;
2514            0;
2515        };
2516    };
2517     // -=*# Resource for function FALSCH #*=-
2518    Resource SC_OPCODE_FALSE
2519    {
2520        String 1 // Description
2521        {
2522            Text [ en-US ] = "Defines the logical value as FALSE." ;
2523        };
2524        ExtraData =
2525        {
2526            0;
2527            ID_FUNCTION_GRP_LOGIC;
2528            U2S( HID_FUNC_FALSCH );
2529            0;
2530            0;
2531        };
2532    };
2533     // -=*# Resource for function NICHT #*=-
2534    Resource SC_OPCODE_NOT
2535    {
2536        String 1 // Description
2537        {
2538            Text [ en-US ] = "Reverses the value of the argument." ;
2539        };
2540        ExtraData =
2541        {
2542            0;
2543            ID_FUNCTION_GRP_LOGIC;
2544            U2S( HID_FUNC_NICHT );
2545            1;  0;
2546            0;
2547        };
2548        String 2 // Name of Parameter 1
2549        {
2550            Text [ en-US ] = "Logical value" ;
2551        };
2552        String 3 // Description of Parameter 1
2553        {
2554            Text [ en-US ] = "An expression that can be either TRUE or FALSE." ;
2555        };
2556    };
2557     // -=*# Resource for function WAHR #*=-
2558    Resource SC_OPCODE_TRUE
2559    {
2560        String 1 // Description
2561        {
2562            Text [ en-US ] = "Returns the logical value TRUE." ;
2563        };
2564        ExtraData =
2565        {
2566            0;
2567            ID_FUNCTION_GRP_LOGIC;
2568            U2S( HID_FUNC_WAHR );
2569            0;
2570            0;
2571        };
2572    };
2573     // -=*# Resource for function WENN #*=-
2574    Resource SC_OPCODE_IF
2575    {
2576        String 1 // Description
2577        {
2578            Text [ en-US ] = "Specifies a logical test to be performed." ;
2579        };
2580        ExtraData =
2581        {
2582            0;
2583            ID_FUNCTION_GRP_LOGIC;
2584            U2S( HID_FUNC_WENN );
2585            3;  0;  1;  1;
2586            0;
2587        };
2588        String 2 // Name of Parameter 1
2589        {
2590            Text [ en-US ] = "Test" ;
2591        };
2592        String 3 // Description of Parameter 1
2593        {
2594            Text [ en-US ] = "Any value or expression which can be either TRUE or FALSE." ;
2595        };
2596        String 4 // Name of Parameter 2
2597        {
2598            Text [ en-US ] = "Then_value" ;
2599        };
2600        String 5 // Description of Parameter 2
2601        {
2602            Text [ en-US ] = "The result of the function if the logical test returns a TRUE." ;
2603        };
2604        String 6 // Name of Parameter 3
2605        {
2606            Text [ en-US ] = "Otherwise_value" ;
2607        };
2608        String 7 // Description of Parameter 3
2609        {
2610            Text [ en-US ] = "The result of the function if the logical test returns FALSE." ;
2611        };
2612    };
2613     // -=*# Resource for function ODER #*=-
2614    Resource SC_OPCODE_OR
2615    {
2616        String 1 // Description
2617        {
2618            Text [ en-US ] = "Returns TRUE if an argument is TRUE." ;
2619        };
2620        ExtraData =
2621        {
2622            0;
2623            ID_FUNCTION_GRP_LOGIC;
2624            U2S( HID_FUNC_ODER );
2625            VAR_ARGS;   0;
2626            0;
2627        };
2628        String 2 // Name of Parameter 1
2629        {
2630            Text [ en-US ] = "Logical value " ;
2631        };
2632        String 3 // Description of Parameter 1
2633        {
2634            Text [ en-US ] = "Logical value 1, logical value 2,... are 1 to 30 conditions to be tested and which return either TRUE or FALSE." ;
2635        };
2636    };
2637     // -=*# Resource for function UND #*=-
2638    Resource SC_OPCODE_AND
2639    {
2640        String 1 // Description
2641        {
2642            Text [ en-US ] = "Returns TRUE if all arguments are TRUE." ;
2643        };
2644        ExtraData =
2645        {
2646            0;
2647            ID_FUNCTION_GRP_LOGIC;
2648            U2S( HID_FUNC_UND );
2649            VAR_ARGS;   0;
2650            0;
2651        };
2652        String 2 // Name of Parameter 1
2653        {
2654            Text [ en-US ] = "Logical value " ;
2655        };
2656        String 3 // Description of Parameter 1
2657        {
2658            Text [ en-US ] = "Logical value 1, logical value 2;...are 1 to 30 conditions to be tested and each returns either TRUE or FALSE." ;
2659        };
2660    };
2661
2662    // -=*# Resource for function XOR #*=-
2663    Resource SC_OPCODE_XOR
2664    {
2665        String 1 // Description
2666        {
2667            Text [ en-US ] = "Returns TRUE if exactly one of the arguments is TRUE." ;
2668        };
2669        ExtraData =
2670        {
2671            0;
2672            ID_FUNCTION_GRP_LOGIC;
2673            U2S( HID_FUNC_XOR );
2674            VAR_ARGS;   0;
2675            0;
2676        };
2677        String 2 // Name of Parameter 1
2678        {
2679            Text [ en-US ] = "Logical value " ;
2680        };
2681        String 3 // Description of Parameter 1
2682        {
2683            Text [ en-US ] = "Logical value 1, logical value 2,... are 1 to 30 conditions to be tested and which return either TRUE or FALSE." ;
2684        };
2685    };
2686     // -=*# Resource for function ABS #*=-
2687    Resource SC_OPCODE_ABS
2688    {
2689        String 1 // Description
2690        {
2691            Text [ en-US ] = "Absolute value of a number." ;
2692        };
2693        ExtraData =
2694        {
2695            0;
2696            ID_FUNCTION_GRP_MATH;
2697            U2S( HID_FUNC_ABS );
2698            1;  0;
2699            0;
2700        };
2701        String 2 // Name of Parameter 1
2702        {
2703            Text [ en-US ] = "Number" ;
2704        };
2705        String 3 // Description of Parameter 1
2706        {
2707            Text [ en-US ] = "The number whose absolute value is to be returned." ;
2708        };
2709    };
2710     // -=*# Resource for function POTENZ #*=-
2711    Resource SC_OPCODE_POWER
2712    {
2713        String 1 // Description
2714        {
2715            Text [ en-US ] = "Returns a^b, base a raised to the power of exponent b." ;
2716        };
2717        ExtraData =
2718        {
2719            0;
2720            ID_FUNCTION_GRP_MATH;
2721            U2S( HID_FUNC_POTENZ );
2722            2;  0;  0;
2723            0;
2724        };
2725        String 2 // Name of Parameter 1
2726        {
2727            Text [ en-US ] = "Base" ;
2728        };
2729        String 3 // Description of Parameter 1
2730        {
2731            Text [ en-US ] = "The base a of the power a^b." ;
2732        };
2733        String 4 // Name of Parameter 2
2734        {
2735            Text [ en-US ] = "Exponent" ;
2736        };
2737        String 5 // Description of Parameter 2
2738        {
2739            Text [ en-US ] = "The exponent b of the power a^b." ;
2740        };
2741    };
2742     // -=*# Resource for function ANZAHLLEEREZELLEN #*=-
2743    Resource SC_OPCODE_COUNT_EMPTY_CELLS
2744    {
2745        String 1 // Description
2746        {
2747            Text [ en-US ] = "Counts the blank cells in a specified range." ;
2748        };
2749        ExtraData =
2750        {
2751            0;
2752            ID_FUNCTION_GRP_MATH;
2753            U2S( HID_FUNC_ANZAHLLEEREZELLEN );
2754            1;  0;
2755            0;
2756        };
2757        String 2 // Name of Parameter 1
2758        {
2759            Text [ en-US ] = "range" ;
2760        };
2761        String 3 // Description of Parameter 1
2762        {
2763            Text [ en-US ] = "The range in which empty cells are to be counted." ;
2764        };
2765    };
2766     // -=*# Resource for function PI #*=-
2767    Resource SC_OPCODE_PI
2768    {
2769        String 1 // Description
2770        {
2771            Text [ en-US ] = "Returns the value of the number Pi." ;
2772        };
2773        ExtraData =
2774        {
2775            0;
2776            ID_FUNCTION_GRP_MATH;
2777            U2S( HID_FUNC_PI );
2778            0;
2779            0;
2780        };
2781    };
2782     // -=*# Resource for function SUMME #*=-
2783    Resource SC_OPCODE_SUM
2784    {
2785        String 1 // Description
2786        {
2787            Text [ en-US ] = "Returns the sum of all arguments." ;
2788        };
2789        ExtraData =
2790        {
2791            0;
2792            ID_FUNCTION_GRP_MATH;
2793            U2S( HID_FUNC_SUMME );
2794            VAR_ARGS;   0;
2795            0;
2796        };
2797        String 2 // Name of Parameter 1
2798        {
2799            Text [ en-US ] = "number " ;
2800        };
2801        String 3 // Description of Parameter 1
2802        {
2803            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 arguments whose total is to be calculated." ;
2804        };
2805    };
2806     // -=*# Resource for function QUADRATESUMME #*=-
2807    Resource SC_OPCODE_SUM_SQ
2808    {
2809        String 1 // Description
2810        {
2811            Text [ en-US ] = "Returns the sum of the squares of the arguments." ;
2812        };
2813        ExtraData =
2814        {
2815            0;
2816            ID_FUNCTION_GRP_MATH;
2817            U2S( HID_FUNC_QUADRATESUMME );
2818            VAR_ARGS;   0;
2819            0;
2820        };
2821        String 2 // Name of Parameter 1
2822        {
2823            Text [ en-US ] = "number " ;
2824        };
2825        String 3 // Description of Parameter 1
2826        {
2827            Text [ en-US ] = "Number 1, number 2,... are 1 to 30 arguments for which the sum of the squares is to be calculated." ;
2828        };
2829    };
2830     // -=*# Resource for function PRODUKT #*=-
2831    Resource SC_OPCODE_PRODUCT
2832    {
2833        String 1 // Description
2834        {
2835            Text [ en-US ] = "Multiplies the arguments." ;
2836        };
2837        ExtraData =
2838        {
2839            0;
2840            ID_FUNCTION_GRP_MATH;
2841            U2S( HID_FUNC_PRODUKT );
2842            VAR_ARGS;   0;
2843            0;
2844        };
2845        String 2 // Name of Parameter 1
2846        {
2847            Text [ en-US ] = "Number " ;
2848        };
2849        String 3 // Description of Parameter 1
2850        {
2851            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 arguments to be multiplied and a result returned." ;
2852        };
2853    };
2854     // -=*# Resource for function SUMMEWENN #*=-
2855    Resource SC_OPCODE_SUM_IF
2856    {
2857        String 1 // Description
2858        {
2859            Text [ en-US ] = "Totals the arguments that meet the conditions." ;
2860        };
2861        ExtraData =
2862        {
2863            0;
2864            ID_FUNCTION_GRP_MATH;
2865            U2S( HID_FUNC_SUMMEWENN );
2866            3;  0;  0;  1;
2867            0;
2868        };
2869        String 2 // Name of Parameter 1
2870        {
2871            Text [ en-US ] = "range" ;
2872        };
2873        String 3 // Description of Parameter 1
2874        {
2875            Text [ en-US ] = "The range to be evaluated by the criteria given." ;
2876        };
2877        String 4 // Name of Parameter 2
2878        {
2879            Text [ en-US ] = "criteria" ;
2880        };
2881        String 5 // Description of Parameter 2
2882        {
2883            Text [ en-US ] = "The cell range in which the search criteria are given." ;
2884        };
2885        String 6 // Name of Parameter 3
2886        {
2887            Text [ en-US ] = "sum_range" ;
2888        };
2889        String 7 // Description of Parameter 3
2890        {
2891            Text [ en-US ] = "The range from which the values are to be totalled." ;
2892        };
2893    };
2894
2895    // -=*# Resource for function AVERAGEIF #*=-
2896    Resource SC_OPCODE_AVERAGE_IF
2897    {
2898        String 1 // Description
2899        {
2900            Text [ en-US ] = "Averages the arguments that meet the conditions." ;
2901        };
2902        ExtraData =
2903        {
2904            0;
2905            ID_FUNCTION_GRP_MATH;
2906            U2S( HID_FUNC_AVERAGEIF );
2907            3;  0;  0;  1;
2908            0;
2909        };
2910        String 2 // Name of Parameter 1
2911        {
2912            Text [ en-US ] = "range" ;
2913        };
2914        String 3 // Description of Parameter 1
2915        {
2916            Text [ en-US ] = "The range to be evaluated by the criteria given." ;
2917        };
2918        String 4 // Name of Parameter 2
2919        {
2920            Text [ en-US ] = "criteria" ;
2921        };
2922        String 5 // Description of Parameter 2
2923        {
2924            Text [ en-US ] = "The cell range in which the search criteria are given." ;
2925        };
2926        String 6 // Name of Parameter 3
2927        {
2928            Text [ en-US ] = "average_range" ;
2929        };
2930        String 7 // Description of Parameter 3
2931        {
2932            Text [ en-US ] = "The range from which the values are to be averaged." ;
2933        };
2934    };
2935
2936    Resource SC_OPCODE_SUM_IFS
2937    {
2938        String 1 // Description
2939        {
2940            Text [ en-US ] = "Totals the values of cells in a range that meet multiple criteria in multiple ranges." ;
2941        };
2942        ExtraData =
2943        {
2944            0;
2945            ID_FUNCTION_GRP_MATH;
2946            U2S( HID_FUNC_SUMIFS );
2947            PAIRED_VAR_ARGS+1;  0;  0;  0;
2948            0;
2949        };
2950        String 2 // Name of Parameter 1
2951        {
2952            Text [ en-US ] = "sum_range" ;
2953        };
2954        String 3 // Description of Parameter 1
2955        {
2956            Text [ en-US ] = "The range from which the values are to be totalled." ;
2957        };
2958        String 4 // Name of Parameter 2
2959        {
2960            Text [ en-US ] = "range " ;
2961        };
2962        String 5 // Description of Parameter 2
2963        {
2964            Text [ en-US ] = "Range 1, range 2,... are the ranges to be evaluated by the criteria given." ;
2965        };
2966        String 6 // Name of Parameter 3
2967        {
2968            Text [ en-US ] = "criteria " ;
2969        };
2970        String 7 // Description of Parameter 3
2971        {
2972            Text [ en-US ] = "Criteria 1, criteria 2,... are the cell ranges in which the search criteria are given." ;
2973        };
2974    };
2975
2976    // -=*# Resource for function AVERAGEIFS #*=-
2977    Resource SC_OPCODE_AVERAGE_IFS
2978    {
2979        String 1 // Description
2980        {
2981            Text [ en-US ] = "Averages the value of the cells that meet multiple criteria in multiple ranges." ;
2982        };
2983        ExtraData =
2984        {
2985            0;
2986            ID_FUNCTION_GRP_MATH;
2987            U2S( HID_FUNC_AVERAGEIFS );
2988            PAIRED_VAR_ARGS+1;  0;  0;  0;
2989            0;
2990        };
2991        String 2 // Name of Parameter 1
2992        {
2993            Text [ en-US ] = "average_range" ;
2994        };
2995        String 3 // Description of Parameter 1
2996        {
2997            Text [ en-US ] = "The range from which the values are to be averaged." ;
2998        };
2999        String 4 // Name of Parameter 2
3000        {
3001            Text [ en-US ] = "range " ;
3002        };
3003        String 5 // Description of Parameter 2
3004        {
3005            Text [ en-US ] = "Range 1, range 2,... are the ranges to be evaluated by the criteria given." ;
3006        };
3007        String 6 // Name of Parameter 3
3008        {
3009            Text [ en-US ] = "criteria " ;
3010        };
3011        String 7 // Description of Parameter 3
3012        {
3013            Text [ en-US ] = "Criteria 1, criteria 2,... are the cell ranges in which the search criteria are given." ;
3014        };
3015    };
3016
3017    // -=*# Resource for function COUNTIFS #*=-
3018    Resource SC_OPCODE_COUNT_IFS
3019    {
3020        String 1 // Description
3021        {
3022            Text [ en-US ] = "Counts the cells that meet multiple criteria in multiple ranges." ;
3023        };
3024        ExtraData =
3025        {
3026            0;
3027            ID_FUNCTION_GRP_MATH;
3028            U2S( HID_FUNC_COUNTIFS );
3029            PAIRED_VAR_ARGS;    0;  0;
3030            0;
3031        };
3032        String 2 // Name of Parameter 1
3033        {
3034            Text [ en-US ] = "range " ;
3035        };
3036        String 3 // Description of Parameter 1
3037        {
3038            Text [ en-US ] = "Range 1, range 2,... are the ranges to be evaluated by the criteria given." ;
3039        };
3040        String 4 // Name of Parameter 2
3041        {
3042            Text [ en-US ] = "criteria " ;
3043        };
3044        String 5 // Description of Parameter 2
3045        {
3046            Text [ en-US ] = "Criteria 1, criteria 2,... are the cell ranges in which the search criteria are given." ;
3047        };
3048    };
3049
3050     // -=*# Resource for function ZÄHLENWENN #*=-
3051    Resource SC_OPCODE_COUNT_IF
3052    {
3053        String 1 // Description
3054        {
3055            Text [ en-US ] = "Counts the arguments which meet the set conditions." ;
3056        };
3057        ExtraData =
3058        {
3059            0;
3060            ID_FUNCTION_GRP_MATH;
3061            U2S( HID_FUNC_ZAEHLENWENN );
3062            2;  0;  0;
3063            0;
3064        };
3065        String 2 // Name of Parameter 1
3066        {
3067            Text [ en-US ] = "range" ;
3068        };
3069        String 3 // Description of Parameter 1
3070        {
3071            Text [ en-US ] = "The range of cells on which the criteria are to be applied." ;
3072        };
3073        String 4 // Name of Parameter 2
3074        {
3075            Text [ en-US ] = "criteria" ;
3076        };
3077        String 5 // Description of Parameter 2
3078        {
3079            Text [ en-US ] = "The cell range in which the search criteria are given." ;
3080        };
3081    };
3082     // -=*# Resource for function WURZEL #*=-
3083    Resource SC_OPCODE_SQRT
3084    {
3085        String 1 // Description
3086        {
3087            Text [ en-US ] = "Returns the square root of a number." ;
3088        };
3089        ExtraData =
3090        {
3091            0;
3092            ID_FUNCTION_GRP_MATH;
3093            U2S( HID_FUNC_WURZEL );
3094            1;  0;
3095            0;
3096        };
3097        String 2 // Name of Parameter 1
3098        {
3099            Text [ en-US ] = "number" ;
3100        };
3101        String 3 // Description of Parameter 1
3102        {
3103            Text [ en-US ] = "A positive value for which the square root is to be calculated." ;
3104        };
3105    };
3106     // -=*# Resource for function ZUFALLSZAHL #*=-
3107    Resource SC_OPCODE_RANDOM
3108    {
3109        String 1 // Description
3110        {
3111            Text [ en-US ] = "Returns a random number between 0 and 1." ;
3112        };
3113        ExtraData =
3114        {
3115            0;
3116            ID_FUNCTION_GRP_MATH;
3117            U2S( HID_FUNC_ZUFALLSZAHL );
3118            0;
3119            0;
3120        };
3121    };
3122     // -=*# Resource for function ISTGERADE #*=-
3123    Resource SC_OPCODE_IS_EVEN
3124    {
3125        String 1 // Description
3126        {
3127            Text [ en-US ] = "Returns TRUE if value is an even integer." ;
3128        };
3129        ExtraData =
3130        {
3131            0;
3132            ID_FUNCTION_GRP_MATH;
3133            U2S( HID_FUNC_ISTGERADE );
3134            1;  0;
3135            0;
3136        };
3137        String 2 // Name of Parameter 1
3138        {
3139            Text [ en-US ] = "value" ;
3140        };
3141        String 3 // Description of Parameter 1
3142        {
3143            Text [ en-US ] = "The value to be tested." ;
3144        };
3145    };
3146     // -=*# Resource for function ISTUNGERADE #*=-
3147    Resource SC_OPCODE_IS_ODD
3148    {
3149        String 1 // Description
3150        {
3151            Text [ en-US ] = "Returns TRUE if value is an odd integer." ;
3152        };
3153        ExtraData =
3154        {
3155            0;
3156            ID_FUNCTION_GRP_MATH;
3157            U2S( HID_FUNC_ISTUNGERADE );
3158            1;  0;
3159            0;
3160        };
3161        String 2 // Name of Parameter 1
3162        {
3163            Text [ en-US ] = "value" ;
3164        };
3165        String 3 // Description of Parameter 1
3166        {
3167            Text [ en-US ] = "The value to be tested." ;
3168        };
3169    };
3170     // -=*# Resource for function KOMBINATIONEN #*=-
3171    Resource SC_OPCODE_KOMBIN
3172    {
3173        String 1 // Description
3174        {
3175            Text [ en-US ] = "Calculates the number of combinations for elements without repetition." ;
3176        };
3177        ExtraData =
3178        {
3179            0;
3180            ID_FUNCTION_GRP_MATH;
3181            U2S( HID_FUNC_KOMBINATIONEN );
3182            2;  0;  0;
3183            0;
3184        };
3185        String 2 // Name of Parameter 1
3186        {
3187            Text [ en-US ] = "number_1" ;
3188        };
3189        String 3 // Description of Parameter 1
3190        {
3191            Text [ en-US ] = "The total number of elements." ;
3192        };
3193        String 4 // Name of Parameter 2
3194        {
3195            Text [ en-US ] = "number_2" ;
3196        };
3197        String 5 // Description of Parameter 2
3198        {
3199            Text [ en-US ] = "The number of elements selected." ;
3200        };
3201    };
3202     // -=*# Resource for function KOMBINATIONEN2 #*=-
3203    Resource SC_OPCODE_KOMBIN_2
3204    {
3205        String 1 // Description
3206        {
3207            Text [ en-US ] = "Calculates the number of combinations of elements including repetition." ;
3208        };
3209        ExtraData =
3210        {
3211            0;
3212            ID_FUNCTION_GRP_MATH;
3213            U2S( HID_FUNC_KOMBINATIONEN2 );
3214            2;  0;  0;
3215            0;
3216        };
3217        String 2 // Name of Parameter 1
3218        {
3219            Text [ en-US ] = "number_1" ;
3220        };
3221        String 3 // Description of Parameter 1
3222        {
3223            Text [ en-US ] = "The total number of elements." ;
3224        };
3225        String 4 // Name of Parameter 2
3226        {
3227            Text [ en-US ] = "number_2" ;
3228        };
3229        String 5 // Description of Parameter 2
3230        {
3231            Text [ en-US ] = "The number of elements selected." ;
3232        };
3233    };
3234     // -=*# Resource for function ARCCOS #*=-
3235    Resource SC_OPCODE_ARC_COS
3236    {
3237        String 1 // Description
3238        {
3239            Text [ en-US ] = "Returns the arccosine of a number." ;
3240        };
3241        ExtraData =
3242        {
3243            0;
3244            ID_FUNCTION_GRP_MATH;
3245            U2S( HID_FUNC_ARCCOS );
3246            1;  0;
3247            0;
3248        };
3249        String 2 // Name of Parameter 1
3250        {
3251            Text [ en-US ] = "Number" ;
3252        };
3253        String 3 // Description of Parameter 1
3254        {
3255            Text [ en-US ] = "A value between -1 and 1 for which the arccosine is to be returned." ;
3256        };
3257    };
3258     // -=*# Resource for function ARCSIN #*=-
3259    Resource SC_OPCODE_ARC_SIN
3260    {
3261        String 1 // Description
3262        {
3263            Text [ en-US ] = "Returns the arcsine of a number." ;
3264        };
3265        ExtraData =
3266        {
3267            0;
3268            ID_FUNCTION_GRP_MATH;
3269            U2S( HID_FUNC_ARCSIN );
3270            1;  0;
3271            0;
3272        };
3273        String 2 // Name of Parameter 1
3274        {
3275            Text [ en-US ] = "Number" ;
3276        };
3277        String 3 // Description of Parameter 1
3278        {
3279            Text [ en-US ] = "A value between -1 and 1 for which the arcsine is to be returned." ;
3280        };
3281    };
3282     // -=*# Resource for function ARCCOSHYP #*=-
3283    Resource SC_OPCODE_ARC_COS_HYP
3284    {
3285        String 1 // Description
3286        {
3287            Text [ en-US ] = "Returns the inverse hyperbolic cosine of a number." ;
3288        };
3289        ExtraData =
3290        {
3291            0;
3292            ID_FUNCTION_GRP_MATH;
3293            U2S( HID_FUNC_ARCOSHYP );
3294            1;  0;
3295            0;
3296        };
3297        String 2 // Name of Parameter 1
3298        {
3299            Text [ en-US ] = "Number" ;
3300        };
3301        String 3 // Description of Parameter 1
3302        {
3303            Text [ en-US ] = "A value greater than or equal to 1 for which the hyperbolic cosine is to be returned." ;
3304        };
3305    };
3306     // -=*# Resource for function ARCSINHYP #*=-
3307    Resource SC_OPCODE_ARC_SIN_HYP
3308    {
3309        String 1 // Description
3310        {
3311            Text [ en-US ] = "Returns the inverse hyperbolic sine of a number." ;
3312        };
3313        ExtraData =
3314        {
3315            0;
3316            ID_FUNCTION_GRP_MATH;
3317            U2S( HID_FUNC_ARSINHYP );
3318            1;  0;
3319            0;
3320        };
3321        String 2 // Name of Parameter 1
3322        {
3323            Text [ en-US ] = "Number" ;
3324        };
3325        String 3 // Description of Parameter 1
3326        {
3327            Text [ en-US ] = "The value for which the inverse hyperbolic sine is to be returned." ;
3328        };
3329    };
3330     // -=*# Resource for function ARCCOT #*=-
3331    Resource SC_OPCODE_ARC_COT
3332    {
3333        String 1 // Description
3334        {
3335            Text [ en-US ] = "Returns the inverse cotangent of a number." ;
3336        };
3337        ExtraData =
3338        {
3339            0;
3340            ID_FUNCTION_GRP_MATH;
3341            U2S( HID_FUNC_ARCCOT );
3342            1;  0;
3343            0;
3344        };
3345        String 2 // Name of Parameter 1
3346        {
3347            Text [ en-US ] = "Number" ;
3348        };
3349        String 3 // Description of Parameter 1
3350        {
3351            Text [ en-US ] = "The value for which the inverse cotangent is to be returned." ;
3352        };
3353    };
3354     // -=*# Resource for function ARCTAN #*=-
3355    Resource SC_OPCODE_ARC_TAN
3356    {
3357        String 1 // Description
3358        {
3359            Text [ en-US ] = "Returns the arctangent of a number." ;
3360        };
3361        ExtraData =
3362        {
3363            0;
3364            ID_FUNCTION_GRP_MATH;
3365            U2S( HID_FUNC_ARCTAN );
3366            1;  0;
3367            0;
3368        };
3369        String 2 // Name of Parameter 1
3370        {
3371            Text [ en-US ] = "Number" ;
3372        };
3373        String 3 // Description of Parameter 1
3374        {
3375            Text [ en-US ] = "The value for which the arctangent is to be returned." ;
3376        };
3377    };
3378     // -=*# Resource for function ARCCOTHYP #*=-
3379    Resource SC_OPCODE_ARC_COT_HYP
3380    {
3381        String 1 // Description
3382        {
3383            Text [ en-US ] = "Returns the inverse hyperbolic cotangent of a number." ;
3384        };
3385        ExtraData =
3386        {
3387            0;
3388            ID_FUNCTION_GRP_MATH;
3389            U2S( HID_FUNC_ARCOTHYP );
3390            1;  0;
3391            0;
3392        };
3393        String 2 // Name of Parameter 1
3394        {
3395            Text [ en-US ] = "Number" ;
3396        };
3397        String 3 // Description of Parameter 1
3398        {
3399            Text [ en-US ] = "A value smaller than -1 or greater than 1 for which the inverse hyperbolic cotangent is to be returned." ;
3400        };
3401    };
3402     // -=*# Resource for function ARCTANHYP #*=-
3403    Resource SC_OPCODE_ARC_TAN_HYP
3404    {
3405        String 1 // Description
3406        {
3407            Text [ en-US ] = "Returns the inverse hyperbolic tangent of a number." ;
3408        };
3409        ExtraData =
3410        {
3411            0;
3412            ID_FUNCTION_GRP_MATH;
3413            U2S( HID_FUNC_ARTANHYP );
3414            1;  0;
3415            0;
3416        };
3417        String 2 // Name of Parameter 1
3418        {
3419            Text [ en-US ] = "Number" ;
3420        };
3421        String 3 // Description of Parameter 1
3422        {
3423            Text [ en-US ] = "A value between -1 and 1 for which the inverse hyperbolic tangent is to be returned." ;
3424        };
3425    };
3426     // -=*# Resource for function COS #*=-
3427    Resource SC_OPCODE_COS
3428    {
3429        String 1 // Description
3430        {
3431            Text [ en-US ] = "Returns the cosine of a number." ;
3432        };
3433        ExtraData =
3434        {
3435            0;
3436            ID_FUNCTION_GRP_MATH;
3437            U2S( HID_FUNC_COS );
3438            1;  0;
3439            0;
3440        };
3441        String 2 // Name of Parameter 1
3442        {
3443            Text [ en-US ] = "Number" ;
3444        };
3445        String 3 // Description of Parameter 1
3446        {
3447            Text [ en-US ] = "The angle in the radians for which the cosine is to be returned." ;
3448        };
3449    };
3450     // -=*# Resource for function SIN #*=-
3451    Resource SC_OPCODE_SIN
3452    {
3453        String 1 // Description
3454        {
3455            Text [ en-US ] = "Returns the sine of a number." ;
3456        };
3457        ExtraData =
3458        {
3459            0;
3460            ID_FUNCTION_GRP_MATH;
3461            U2S( HID_FUNC_SIN );
3462            1;  0;
3463            0;
3464        };
3465        String 2 // Name of Parameter 1
3466        {
3467            Text [ en-US ] = "number" ;
3468        };
3469        String 3 // Description of Parameter 1
3470        {
3471            Text [ en-US ] = "The angle in radians for which the sine is to be calculated." ;
3472        };
3473    };
3474     // -=*# Resource for function COT #*=-
3475    Resource SC_OPCODE_COT
3476    {
3477        String 1 // Description
3478        {
3479            Text [ en-US ] = "Returns the cotangent of a number." ;
3480        };
3481        ExtraData =
3482        {
3483            0;
3484            ID_FUNCTION_GRP_MATH;
3485            U2S( HID_FUNC_COT );
3486            1;  0;
3487            0;
3488        };
3489        String 2 // Name of Parameter 1
3490        {
3491            Text [ en-US ] = "Number" ;
3492        };
3493        String 3 // Description of Parameter 1
3494        {
3495            Text [ en-US ] = "The angle in radians whose cotangent value is to be returned." ;
3496        };
3497    };
3498     // -=*# Resource for function TAN #*=-
3499    Resource SC_OPCODE_TAN
3500    {
3501        String 1 // Description
3502        {
3503            Text [ en-US ] = "Returns the tangent of a number." ;
3504        };
3505        ExtraData =
3506        {
3507            0;
3508            ID_FUNCTION_GRP_MATH;
3509            U2S( HID_FUNC_TAN );
3510            1;  0;
3511            0;
3512        };
3513        String 2 // Name of Parameter 1
3514        {
3515            Text [ en-US ] = "number" ;
3516        };
3517        String 3 // Description of Parameter 1
3518        {
3519            Text [ en-US ] = "The angle in radians for which the tangent is to be calculated." ;
3520        };
3521    };
3522     // -=*# Resource for function COSHYP #*=-
3523    Resource SC_OPCODE_COS_HYP
3524    {
3525        String 1 // Description
3526        {
3527            Text [ en-US ] = "Returns the hyperbolic cosine of a number." ;
3528        };
3529        ExtraData =
3530        {
3531            0;
3532            ID_FUNCTION_GRP_MATH;
3533            U2S( HID_FUNC_COSHYP );
3534            1;  0;
3535            0;
3536        };
3537        String 2 // Name of Parameter 1
3538        {
3539            Text [ en-US ] = "Number" ;
3540        };
3541        String 3 // Description of Parameter 1
3542        {
3543            Text [ en-US ] = "The value for which the hyperbolic cosine is to be returned." ;
3544        };
3545    };
3546     // -=*# Resource for function SINHYP #*=-
3547    Resource SC_OPCODE_SIN_HYP
3548    {
3549        String 1 // Description
3550        {
3551            Text [ en-US ] = "Returns the hyperbolic sine of a number." ;
3552        };
3553        ExtraData =
3554        {
3555            0;
3556            ID_FUNCTION_GRP_MATH;
3557            U2S( HID_FUNC_SINHYP );
3558            1;  0;
3559            0;
3560        };
3561        String 2 // Name of Parameter 1
3562        {
3563            Text [ en-US ] = "number" ;
3564        };
3565        String 3 // Description of Parameter 1
3566        {
3567            Text [ en-US ] = "The value for which the hyperbolic sine is to be calculated." ;
3568        };
3569    };
3570     // -=*# Resource for function COTHYP #*=-
3571    Resource SC_OPCODE_COT_HYP
3572    {
3573        String 1 // Description
3574        {
3575            Text [ en-US ] = "Returns the hyperbolic cotangent of a number." ;
3576        };
3577        ExtraData =
3578        {
3579            0;
3580            ID_FUNCTION_GRP_MATH;
3581            U2S( HID_FUNC_COTHYP );
3582            1;  0;
3583            0;
3584        };
3585        String 2 // Name of Parameter 1
3586        {
3587            Text [ en-US ] = "Number" ;
3588        };
3589        String 3 // Description of Parameter 1
3590        {
3591            Text [ en-US ] = "A value not equal to 0 for which the hyperbolic cotangent is to be returned." ;
3592        };
3593    };
3594     // -=*# Resource for function TANHYP #*=-
3595    Resource SC_OPCODE_TAN_HYP
3596    {
3597        String 1 // Description
3598        {
3599            Text [ en-US ] = "Returns the hyperbolic tangent of a number." ;
3600        };
3601        ExtraData =
3602        {
3603            0;
3604            ID_FUNCTION_GRP_MATH;
3605            U2S( HID_FUNC_TANHYP );
3606            1;  0;
3607            0;
3608        };
3609        String 2 // Name of Parameter 1
3610        {
3611            Text [ en-US ] = "number" ;
3612        };
3613        String 3 // Description of Parameter 1
3614        {
3615            Text [ en-US ] = "The value for which the hyperbolic tangent is to be calculated." ;
3616        };
3617    };
3618     // -=*# Resource for function ARCTAN2 #*=-
3619    Resource SC_OPCODE_ARC_TAN_2
3620    {
3621        String 1 // Description
3622        {
3623            Text [ en-US ] = "Returns the arctangent for the specified coordinates." ;
3624        };
3625        ExtraData =
3626        {
3627            0;
3628            ID_FUNCTION_GRP_MATH;
3629            U2S( HID_FUNC_ARCTAN2 );
3630            2;  0;  0;
3631            0;
3632        };
3633        String 2 // Name of Parameter 1
3634        {
3635            Text [ en-US ] = "number_x" ;
3636        };
3637        String 3 // Description of Parameter 1
3638        {
3639            Text [ en-US ] = "The value for the x coordinate." ;
3640        };
3641        String 4 // Name of Parameter 2
3642        {
3643            Text [ en-US ] = "number_y" ;
3644        };
3645        String 5 // Description of Parameter 2
3646        {
3647            Text [ en-US ] = "The value for the y coordinate." ;
3648        };
3649    };
3650
3651     // -=*# Resource for function DEG #*=-
3652    Resource SC_OPCODE_DEG
3653    {
3654        String 1 // Description
3655        {
3656            Text [ en-US ] = "Converts a radian to degrees" ;
3657        };
3658        ExtraData =
3659        {
3660            0;
3661            ID_FUNCTION_GRP_MATH;
3662            U2S( HID_FUNC_DEG );
3663            1;  0;
3664            0;
3665        };
3666        String 2 // Name of Parameter 1
3667        {
3668            Text [ en-US ] = "Number" ;
3669        };
3670        String 3 // Description of Parameter 1
3671        {
3672            Text [ en-US ] = "The angle in a radian" ;
3673        };
3674    };
3675     // -=*# Resource for function RAD #*=-
3676    Resource SC_OPCODE_RAD
3677    {
3678        String 1 // Description
3679        {
3680            Text [ en-US ] = "Converts degrees to radians" ;
3681        };
3682        ExtraData =
3683        {
3684            0;
3685            ID_FUNCTION_GRP_MATH;
3686            U2S( HID_FUNC_RAD );
3687            1;  0;
3688            0;
3689        };
3690        String 2 // Name of Parameter 1
3691        {
3692            Text [ en-US ] = "Number" ;
3693        };
3694        String 3 // Description of Parameter 1
3695        {
3696            Text [ en-US ] = "The angle in degrees." ;
3697        };
3698    };
3699     // -=*# Resource for function EXP #*=-
3700    Resource SC_OPCODE_EXP
3701    {
3702        String 1 // Description
3703        {
3704            Text [ en-US ] = "Calculates the exponent for basis e." ;
3705        };
3706        ExtraData =
3707        {
3708            0;
3709            ID_FUNCTION_GRP_MATH;
3710            U2S( HID_FUNC_EXP );
3711            1;  0;
3712            0;
3713        };
3714        String 2 // Name of Parameter 1
3715        {
3716            Text [ en-US ] = "Number" ;
3717        };
3718        String 3 // Description of Parameter 1
3719        {
3720            Text [ en-US ] = "The exponent applied to base e." ;
3721        };
3722    };
3723     // -=*# Resource for function LOG #*=-
3724    Resource SC_OPCODE_LOG
3725    {
3726        String 1 // Description
3727        {
3728            Text [ en-US ] = "Calculates the logarithm to any specified base." ;
3729        };
3730        ExtraData =
3731        {
3732            0;
3733            ID_FUNCTION_GRP_MATH;
3734            U2S( HID_FUNC_LOG );
3735            2;  0;  1;
3736            0;
3737        };
3738        String 2 // Name of Parameter 1
3739        {
3740            Text [ en-US ] = "Number" ;
3741        };
3742        String 3 // Description of Parameter 1
3743        {
3744            Text [ en-US ] = "A value greater than 0 for which the logarithm is to be calculated." ;
3745        };
3746        String 4 // Name of Parameter 2
3747        {
3748            Text [ en-US ] = "Base" ;
3749        };
3750        String 5 // Description of Parameter 2
3751        {
3752            Text [ en-US ] = "The base of the logarithm. If omitted, the base is regarded as 10." ;
3753        };
3754    };
3755     // -=*# Resource for function LN #*=-
3756    Resource SC_OPCODE_LN
3757    {
3758        String 1 // Description
3759        {
3760            Text [ en-US ] = "Calculates the natural logarithm of a number." ;
3761        };
3762        ExtraData =
3763        {
3764            0;
3765            ID_FUNCTION_GRP_MATH;
3766            U2S( HID_FUNC_LN );
3767            1;  0;
3768            0;
3769        };
3770        String 2 // Name of Parameter 1
3771        {
3772            Text [ en-US ] = "Number" ;
3773        };
3774        String 3 // Description of Parameter 1
3775        {
3776            Text [ en-US ] = "A value greater than 0 for which the natural logarithm is to be calculated." ;
3777        };
3778    };
3779     // -=*# Resource for function LOG10 #*=-
3780    Resource SC_OPCODE_LOG10
3781    {
3782        String 1 // Description
3783        {
3784            Text [ en-US ] = "Calculates the base-10 logarithm of a number." ;
3785        };
3786        ExtraData =
3787        {
3788            0;
3789            ID_FUNCTION_GRP_MATH;
3790            U2S( HID_FUNC_LOG10 );
3791            1;  0;
3792            0;
3793        };
3794        String 2 // Name of Parameter 1
3795        {
3796            Text [ en-US ] = "Number" ;
3797        };
3798        String 3 // Description of Parameter 1
3799        {
3800            Text [ en-US ] = "A value greater than 0 for which the logarithm is to be calculated." ;
3801        };
3802    };
3803     // -=*# Resource for function FAKULTÄT #*=-
3804    Resource SC_OPCODE_FACT
3805    {
3806        String 1 // Description
3807        {
3808            Text [ en-US ] = "Calculates the factorial of a number." ;
3809        };
3810        ExtraData =
3811        {
3812            0;
3813            ID_FUNCTION_GRP_MATH;
3814            U2S( HID_FUNC_FAKULTAET );
3815            1;  0;
3816            0;
3817        };
3818        String 2 // Name of Parameter 1
3819        {
3820            Text [ en-US ] = "Number" ;
3821        };
3822        String 3 // Description of Parameter 1
3823        {
3824            Text [ en-US ] = "The number for which the factorial is to be calculated." ;
3825        };
3826    };
3827     // -=*# Resource for function REST #*=-
3828    Resource SC_OPCODE_MOD
3829    {
3830        String 1 // Description
3831        {
3832            Text [ en-US ] = "Calculates the remainder of a division." ;
3833        };
3834        ExtraData =
3835        {
3836            0;
3837            ID_FUNCTION_GRP_MATH;
3838            U2S( HID_FUNC_REST );
3839            2;  0;  0;
3840            0;
3841        };
3842        String 2 // Name of Parameter 1
3843        {
3844            Text [ en-US ] = "Dividend" ;
3845        };
3846        String 3 // Description of Parameter 1
3847        {
3848            Text [ en-US ] = "The number to be divided." ;
3849        };
3850        String 4 // Name of Parameter 2
3851        {
3852            Text [ en-US ] = "Divisor" ;
3853        };
3854        String 5 // Description of Parameter 2
3855        {
3856            Text [ en-US ] = "The number by which the dividend is divided." ;
3857        };
3858    };
3859     // -=*# Resource for function VORZEICHEN #*=-
3860    Resource SC_OPCODE_PLUS_MINUS
3861    {
3862        String 1 // Description
3863        {
3864            Text [ en-US ] = "Returns the algebraic sign of a number." ;
3865        };
3866        ExtraData =
3867        {
3868            0;
3869            ID_FUNCTION_GRP_MATH;
3870            U2S( HID_FUNC_VORZEICHEN );
3871            1;  0;
3872            0;
3873        };
3874        String 2 // Name of Parameter 1
3875        {
3876            Text [ en-US ] = "Number" ;
3877        };
3878        String 3 // Description of Parameter 1
3879        {
3880            Text [ en-US ] = "The number for which the algebraic sign is to be determined." ;
3881        };
3882    };
3883     // -=*# Resource for function TEILERGEBNIS #*=-
3884    Resource SC_OPCODE_SUB_TOTAL
3885    {
3886        String 1 // Description
3887        {
3888            Text [ en-US ] = "Calculates subtotals in a spreadsheet." ;
3889        };
3890        ExtraData =
3891        {
3892            0;
3893            ID_FUNCTION_GRP_MATH;
3894            U2S( HID_FUNC_TEILERGEBNIS );
3895            2;  0;  0;
3896            0;
3897        };
3898        String 2 // Name of Parameter 1
3899        {
3900            Text [ en-US ] = "Function" ;
3901        };
3902        String 3 // Description of Parameter 1
3903        {
3904            Text [ en-US ] = "Function index. Is an index of the possible functions Total, Max, ..." ;
3905        };
3906        String 4 // Name of Parameter 2
3907        {
3908            Text [ en-US ] = "range " ;
3909        };
3910        String 5 // Description of Parameter 2
3911        {
3912            Text [ en-US ] = "The cells of the range which are to be taken into account." ;
3913        };
3914    };
3915     // -=*# Resource for function GANZZAHL #*=-
3916    Resource SC_OPCODE_INT
3917    {
3918        String 1 // Description
3919        {
3920            Text [ en-US ] = "Rounds a number down to the nearest integer." ;
3921        };
3922        ExtraData =
3923        {
3924            0;
3925            ID_FUNCTION_GRP_MATH;
3926            U2S( HID_FUNC_GANZZAHL );
3927            1;  0;
3928            0;
3929        };
3930        String 2 // Name of Parameter 1
3931        {
3932            Text [ en-US ] = "Number" ;
3933        };
3934        String 3 // Description of Parameter 1
3935        {
3936            Text [ en-US ] = "The number to be rounded down." ;
3937        };
3938    };
3939     // -=*# Resource for function KÜRZEN #*=-
3940    Resource SC_OPCODE_TRUNC
3941    {
3942        String 1 // Description
3943        {
3944            Text [ en-US ] = "Truncates the decimal places of a number." ;
3945        };
3946        ExtraData =
3947        {
3948            0;
3949            ID_FUNCTION_GRP_MATH;
3950            U2S( HID_FUNC_KUERZEN );
3951            2;  0;  0;
3952            0;
3953        };
3954        String 2 // Name of Parameter 1
3955        {
3956            Text [ en-US ] = "number" ;
3957        };
3958        String 3 // Description of Parameter 1
3959        {
3960            Text [ en-US ] = "The number to be truncated." ;
3961        };
3962        String 4 // Name of Parameter 2
3963        {
3964            Text [ en-US ] = "count" ;
3965        };
3966        String 5 // Description of Parameter 2
3967        {
3968            Text [ en-US ] = "The number of places after the decimal point that are not to be truncated." ;
3969        };
3970    };
3971     // -=*# Resource for function RUNDEN #*=-
3972    Resource SC_OPCODE_ROUND
3973    {
3974        String 1 // Description
3975        {
3976            Text [ en-US ] = "Rounds a number to a predefined accuracy." ;
3977        };
3978        ExtraData =
3979        {
3980            0;
3981            ID_FUNCTION_GRP_MATH;
3982            U2S( HID_FUNC_RUNDEN );
3983            2;  0;  1;
3984            0;
3985        };
3986        String 2 // Name of Parameter 1
3987        {
3988            Text [ en-US ] = "number" ;
3989        };
3990        String 3 // Description of Parameter 1
3991        {
3992            Text [ en-US ] = "The number to be rounded." ;
3993        };
3994        String 4 // Name of Parameter 2
3995        {
3996            Text [ en-US ] = "count" ;
3997        };
3998        String 5 // Description of Parameter 2
3999        {
4000            Text [ en-US ] = "The number of places to which a number is to be rounded." ;
4001        };
4002    };
4003     // -=*# Resource for function AUFRUNDEN #*=-
4004    Resource SC_OPCODE_ROUND_UP
4005    {
4006        String 1 // Description
4007        {
4008            Text [ en-US ] = "Rounds a number up to the predefined accuracy." ;
4009        };
4010        ExtraData =
4011        {
4012            0;
4013            ID_FUNCTION_GRP_MATH;
4014            U2S( HID_FUNC_AUFRUNDEN );
4015            2;  0;  1;
4016            0;
4017        };
4018        String 2 // Name of Parameter 1
4019        {
4020            Text [ en-US ] = "number" ;
4021        };
4022        String 3 // Description of Parameter 1
4023        {
4024            Text [ en-US ] = "The number to be rounded up." ;
4025        };
4026        String 4 // Name of Parameter 2
4027        {
4028            Text [ en-US ] = "count" ;
4029        };
4030        String 5 // Description of Parameter 2
4031        {
4032            Text [ en-US ] = "The number of places to which a number is to be rounded." ;
4033        };
4034    };
4035     // -=*# Resource for function ABRUNDEN #*=-
4036    Resource SC_OPCODE_ROUND_DOWN
4037    {
4038        String 1 // Description
4039        {
4040            Text [ en-US ] = "Rounds a number down to a predefined accuracy." ;
4041        };
4042        ExtraData =
4043        {
4044            0;
4045            ID_FUNCTION_GRP_MATH;
4046            U2S( HID_FUNC_ABRUNDEN );
4047            2;  0;  1;
4048            0;
4049        };
4050        String 2 // Name of Parameter 1
4051        {
4052            Text [ en-US ] = "number" ;
4053        };
4054        String 3 // Description of Parameter 1
4055        {
4056            Text [ en-US ] = "The number to be rounded down." ;
4057        };
4058        String 4 // Name of Parameter 2
4059        {
4060            Text [ en-US ] = "count" ;
4061        };
4062        String 5 // Description of Parameter 2
4063        {
4064            Text [ en-US ] = "The number of places down to which a number is to be rounded." ;
4065        };
4066    };
4067     // -=*# Resource for function GERADE #*=-
4068    Resource SC_OPCODE_EVEN
4069    {
4070        String 1 // Description
4071        {
4072            Text [ en-US ] = "Rounds a positive number up and negative number down to the nearest even integer.";
4073        };
4074        ExtraData =
4075        {
4076            0;
4077            ID_FUNCTION_GRP_MATH;
4078            U2S( HID_FUNC_GERADE );
4079            1;  0;
4080            0;
4081        };
4082        String 2 // Name of Parameter 1
4083        {
4084            Text [ en-US ] = "Number" ;
4085        };
4086        String 3 // Description of Parameter 1
4087        {
4088            Text [ en-US ] = "The number to be rounded up." ;
4089        };
4090    };
4091     // -=*# Resource for function UNGERADE #*=-
4092    Resource SC_OPCODE_ODD
4093    {
4094        String 1 // Description
4095        {
4096            Text [ en-US ] = "Rounds a positive number up and negative number down to the nearest odd integer.";
4097        };
4098        ExtraData =
4099        {
4100            0;
4101            ID_FUNCTION_GRP_MATH;
4102            U2S( HID_FUNC_UNGERADE );
4103            1;  0;
4104            0;
4105        };
4106        String 2 // Name of Parameter 1
4107        {
4108            Text [ en-US ] = "Number" ;
4109        };
4110        String 3 // Description of Parameter 1
4111        {
4112            Text [ en-US ] = "The number to be rounded up." ;
4113        };
4114    };
4115     // -=*# Resource for function OBERGRENZE #*=-
4116    Resource SC_OPCODE_CEIL
4117    {
4118        String 1 // Description
4119        {
4120            Text [ en-US ] = "Rounds a number up to the nearest multiple of significance." ;
4121        };
4122        ExtraData =
4123        {
4124            0;
4125            ID_FUNCTION_GRP_MATH;
4126            U2S( HID_FUNC_OBERGRENZE );
4127            3;  0;  0;  1;
4128            0;
4129        };
4130        String 2 // Name of Parameter 1
4131        {
4132            Text [ en-US ] = "Number" ;
4133        };
4134        String 3 // Description of Parameter 1
4135        {
4136            Text [ en-US ] = "The number to be rounded up." ;
4137        };
4138        String 4 // Name of Parameter 2
4139        {
4140            Text [ en-US ] = "Significance" ;
4141        };
4142        String 5 // Description of Parameter 2
4143        {
4144            Text [ en-US ] = "The number to whose multiple the value is rounded." ;
4145        };
4146        String 6 // Name of Parameter 3
4147        {
4148            Text [ en-US ] = "Mode" ;
4149        };
4150        String 7 // Description of Parameter 3
4151        {
4152            Text [ en-US ] = "If given and not equal to zero then rounded up according to amount when a negative number and significance." ;
4153        };
4154    };
4155     // -=*# Resource for function UNTERGRENZE #*=-
4156    Resource SC_OPCODE_FLOOR
4157    {
4158        String 1 // Description
4159        {
4160            Text [ en-US ] = "Rounds number down to the nearest multiple of significance." ;
4161        };
4162        ExtraData =
4163        {
4164            0;
4165            ID_FUNCTION_GRP_MATH;
4166            U2S( HID_FUNC_UNTERGRENZE );
4167            3;  0;  0;  1;
4168            0;
4169        };
4170        String 2 // Name of Parameter 1
4171        {
4172            Text [ en-US ] = "Number" ;
4173        };
4174        String 3 // Description of Parameter 1
4175        {
4176            Text [ en-US ] = "The number to be rounded down." ;
4177        };
4178        String 4 // Name of Parameter 2
4179        {
4180            Text [ en-US ] = "Significance" ;
4181        };
4182        String 5 // Description of Parameter 2
4183        {
4184            Text [ en-US ] = "The number to whose multiple the value is to be rounded down." ;
4185        };
4186        String 6 // Name of Parameter 3
4187        {
4188            Text [ en-US ] = "Mode" ;
4189        };
4190        String 7 // Description of Parameter 3
4191        {
4192            Text [ en-US ] = "If given and not equal to zero then rounded down according to amount when a negative number and significance." ;
4193        };
4194    };
4195     // -=*# Resource for function GGT #*=-
4196    Resource SC_OPCODE_GGT
4197    {
4198        String 1 // Description
4199        {
4200            Text [ en-US ] = "Greatest Common Divisor" ;
4201        };
4202        ExtraData =
4203        {
4204            0;
4205            ID_FUNCTION_GRP_MATH;
4206            U2S( HID_FUNC_GGT );
4207            VAR_ARGS;   0;
4208            0;
4209        };
4210        String 2 // Name of Parameter 1
4211        {
4212            Text [ en-US ] = "Integer " ;
4213        };
4214        String 3 // Description of Parameter 1
4215        {
4216            Text [ en-US ] = "Integer 1; integer 2,... are integers for which the greatest common divisor is to be calculated." ;
4217        };
4218    };
4219     // -=*# Resource for function KGV #*=-
4220    Resource SC_OPCODE_KGV
4221    {
4222        String 1 // Description
4223        {
4224            Text [ en-US ] = "Lowest common multiple" ;
4225        };
4226        ExtraData =
4227        {
4228            0;
4229            ID_FUNCTION_GRP_MATH;
4230            U2S( HID_FUNC_KGV );
4231            VAR_ARGS;   0;
4232            0;
4233        };
4234        String 2 // Name of Parameter 1
4235        {
4236            Text [ en-US ] = "Integer " ;
4237        };
4238        String 3 // Description of Parameter 1
4239        {
4240            Text [ en-US ] = "Integer 1; integer 2,... are integers whose smallest common multiple is to be calculated." ;
4241        };
4242    };
4243     // -=*# Resource for function MTRANS #*=-
4244    Resource SC_OPCODE_MAT_TRANS
4245    {
4246        String 1 // Description
4247        {
4248            Text [ en-US ] = "Array transposition. Exchanges the rows and columns of an array." ;
4249        };
4250        ExtraData =
4251        {
4252            0;
4253            ID_FUNCTION_GRP_MATRIX;
4254            U2S( HID_FUNC_MTRANS );
4255            1;  0;
4256            0;
4257        };
4258        String 2 // Name of Parameter 1
4259        {
4260            Text [ en-US ] = "array" ;
4261        };
4262        String 3 // Description of Parameter 1
4263        {
4264            Text [ en-US ] = "The array in which the rows and columns have been transposed." ;
4265        };
4266    };
4267     // -=*# Resource for function MMULT #*=-
4268    Resource SC_OPCODE_MAT_MULT
4269    {
4270        String 1 // Description
4271        {
4272            Text [ en-US ] = "Array multiplication. Returns the product of two arrays." ;
4273        };
4274        ExtraData =
4275        {
4276            0;
4277            ID_FUNCTION_GRP_MATRIX;
4278            U2S( HID_FUNC_MMULT );
4279            2;  0;  0;
4280            0;
4281        };
4282        String 2 // Name of Parameter 1
4283        {
4284            Text [ en-US ] = "array" ;
4285        };
4286        String 3 // Description of Parameter 1
4287        {
4288            Text [ en-US ] = "The first array for the array product." ;
4289        };
4290        String 4 // Name of Parameter 2
4291        {
4292            Text [ en-US ] = "array" ;
4293        };
4294        String 5 // Description of Parameter 2
4295        {
4296            Text [ en-US ] = "The second array having the same number of rows as the first array has columns." ;
4297        };
4298    };
4299     // -=*# Resource for function MDET #*=-
4300    Resource SC_OPCODE_MAT_DET
4301    {
4302        String 1 // Description
4303        {
4304            Text [ en-US ] = "Returns the array determinant." ;
4305        };
4306        ExtraData =
4307        {
4308            0;
4309            ID_FUNCTION_GRP_MATRIX;
4310            U2S( HID_FUNC_MDET );
4311            1;  0;
4312            0;
4313        };
4314        String 2 // Name of Parameter 1
4315        {
4316            Text [ en-US ] = "array" ;
4317        };
4318        String 3 // Description of Parameter 1
4319        {
4320            Text [ en-US ] = "The array for which the determinant is to be determined." ;
4321        };
4322    };
4323     // -=*# Resource for function MINV #*=-
4324    Resource SC_OPCODE_MAT_INV
4325    {
4326        String 1 // Description
4327        {
4328            Text [ en-US ] = "Returns the inverse of an array." ;
4329        };
4330        ExtraData =
4331        {
4332            0;
4333            ID_FUNCTION_GRP_MATRIX;
4334            U2S( HID_FUNC_MINV );
4335            1;  0;
4336            0;
4337        };
4338        String 2 // Name of Parameter 1
4339        {
4340            Text [ en-US ] = "array" ;
4341        };
4342        String 3 // Description of Parameter 1
4343        {
4344            Text [ en-US ] = "The array to be inverted." ;
4345        };
4346    };
4347     // -=*# Resource for function EINHEITSMATRIX #*=-
4348    Resource SC_OPCODE_MATRIX_UNIT
4349    {
4350        String 1 // Description
4351        {
4352            Text [ en-US ] = "Returns the unitary square array of a certain size." ;
4353        };
4354        ExtraData =
4355        {
4356            0;
4357            ID_FUNCTION_GRP_MATRIX;
4358            U2S( HID_FUNC_EINHEITSMATRIX );
4359            1;  0;
4360            0;
4361        };
4362        String 2 // Name of Parameter 1
4363        {
4364            Text [ en-US ] = "Dimensions" ;
4365        };
4366        String 3 // Description of Parameter 1
4367        {
4368            Text [ en-US ] = "The size of the unitary array." ;
4369        };
4370    };
4371     // -=*# Resource for function SUMMENPRODUKT #*=-
4372    Resource SC_OPCODE_SUM_PRODUCT
4373    {
4374        String 1 // Description
4375        {
4376            Text [ en-US ] = "(Inner products) Returns the sum of the products of array arguments." ;
4377        };
4378        ExtraData =
4379        {
4380            0;
4381            ID_FUNCTION_GRP_MATRIX;
4382            U2S( HID_FUNC_SUMMENPRODUKT );
4383            VAR_ARGS;   0;
4384            0;
4385        };
4386        String 2 // Name of Parameter 1
4387        {
4388            Text [ en-US ] = "Array " ;
4389        };
4390        String 3 // Description of Parameter 1
4391        {
4392            Text [ en-US ] = "Array 1, array 2, ... are up to 30 arrays whose arguments are to be multiplied." ;
4393        };
4394    };
4395     // -=*# Resource for function SUMMEX2MY2 #*=-
4396    Resource SC_OPCODE_SUM_X2MY2
4397    {
4398        String 1 // Description
4399        {
4400            Text [ en-US ] = "Returns the sum of the difference of squares of two arrays." ;
4401        };
4402        ExtraData =
4403        {
4404            0;
4405            ID_FUNCTION_GRP_MATRIX;
4406            U2S( HID_FUNC_SUMMEX2MY2 );
4407            2;  0;  0;
4408            0;
4409        };
4410        String 2 // Name of Parameter 1
4411        {
4412            Text [ en-US ] = "array_x" ;
4413        };
4414        String 3 // Description of Parameter 1
4415        {
4416            Text [ en-US ] = "First array where the square of the arguments are totalled." ;
4417        };
4418        String 4 // Name of Parameter 2
4419        {
4420            Text [ en-US ] = "array_y" ;
4421        };
4422        String 5 // Description of Parameter 2
4423        {
4424            Text [ en-US ] = "Second array where the square of the arguments is to be subtracted." ;
4425        };
4426    };
4427     // -=*# Resource for function SUMMEX2PY2 #*=-
4428    Resource SC_OPCODE_SUM_X2DY2
4429    {
4430        String 1 // Description
4431        {
4432            Text [ en-US ] = "Returns the total of the square sum of two arrays." ;
4433        };
4434        ExtraData =
4435        {
4436            0;
4437            ID_FUNCTION_GRP_MATRIX;
4438            U2S( HID_FUNC_SUMMEX2PY2 );
4439            2;  0;  0;
4440            0;
4441        };
4442        String 2 // Name of Parameter 1
4443        {
4444            Text [ en-US ] = "array_x" ;
4445        };
4446        String 3 // Description of Parameter 1
4447        {
4448            Text [ en-US ] = "First array where the square of the arguments are totalled." ;
4449        };
4450        String 4 // Name of Parameter 2
4451        {
4452            Text [ en-US ] = "array_y" ;
4453        };
4454        String 5 // Description of Parameter 2
4455        {
4456            Text [ en-US ] = "Second array where the square of the arguments is to be totalled." ;
4457        };
4458    };
4459     // -=*# Resource for function SUMMEXMY2 #*=-
4460    Resource SC_OPCODE_SUM_XMY2
4461    {
4462        String 1 // Description
4463        {
4464            Text [ en-US ] = "Returns the sum of squares of differences of two arrays." ;
4465        };
4466        ExtraData =
4467        {
4468            0;
4469            ID_FUNCTION_GRP_MATRIX;
4470            U2S( HID_FUNC_SUMMEXMY2 );
4471            2;  0;  0;
4472            0;
4473        };
4474        String 2 // Name of Parameter 1
4475        {
4476            Text [ en-US ] = "array_x" ;
4477        };
4478        String 3 // Description of Parameter 1
4479        {
4480            Text [ en-US ] = "First array for forming argument differences." ;
4481        };
4482        String 4 // Name of Parameter 2
4483        {
4484            Text [ en-US ] = "array_y" ;
4485        };
4486        String 5 // Description of Parameter 2
4487        {
4488            Text [ en-US ] = "Second array for forming the argument differences." ;
4489        };
4490    };
4491};
4492
4493Resource RID_SC_FUNCTION_DESCRIPTIONS2
4494{
4495     // -=*# Resource for function HÄUFIGKEIT #*=-
4496    Resource SC_OPCODE_FREQUENCY
4497    {
4498        String 1 // Description
4499        {
4500            Text [ en-US ] = "Returns a frequency distribution as a vertical array." ;
4501        };
4502        ExtraData =
4503        {
4504            0;
4505            ID_FUNCTION_GRP_MATRIX;
4506            U2S( HID_FUNC_HAEUFIGKEIT );
4507            2;  0;  0;
4508            0;
4509        };
4510        String 2 // Name of Parameter 1
4511        {
4512            Text [ en-US ] = "data" ;
4513        };
4514        String 3 // Description of Parameter 1
4515        {
4516            Text [ en-US ] = "The array of the data." ;
4517        };
4518        String 4 // Name of Parameter 2
4519        {
4520            Text [ en-US ] = "classes" ;
4521        };
4522        String 5 // Description of Parameter 2
4523        {
4524            Text [ en-US ] = "The array for forming classes." ;
4525        };
4526    };
4527     // -=*# Resource for function RGP #*=-
4528    Resource SC_OPCODE_RGP
4529    {
4530        String 1 // Description
4531        {
4532            Text [ en-US ] = "Calculates parameters of the linear regression as an array." ;
4533        };
4534        ExtraData =
4535        {
4536            0;
4537            ID_FUNCTION_GRP_MATRIX;
4538            U2S( HID_FUNC_RGP );
4539            4;  0;  1;  1;  1;
4540            0;
4541        };
4542        String 2 // Name of Parameter 1
4543        {
4544            Text [ en-US ] = "data_Y" ;
4545        };
4546        String 3 // Description of Parameter 1
4547        {
4548            Text [ en-US ] = "The Y data array." ;
4549        };
4550        String 4 // Name of Parameter 2
4551        {
4552            Text [ en-US ] = "data_X" ;
4553        };
4554        String 5 // Description of Parameter 2
4555        {
4556            Text [ en-US ] = "The X data array." ;
4557        };
4558        String 6 // Name of Parameter 3
4559        {
4560            Text [ en-US ] = "Linear_type" ;
4561        };
4562        String 7 // Description of Parameter 3
4563        {
4564            Text [ en-US ] = "If type = 0 the linears will be calculated through the zero point, or else moved linears." ;
4565        };
4566        String 8 // Name of Parameter 4
4567        {
4568            Text [ en-US ] = "stats" ;
4569        };
4570        String 9 // Description of Parameter 4
4571        {
4572            Text [ en-US ] = "If parameter = 0 then only the regression coefficient will be calculated, otherwise other values as well." ;
4573        };
4574    };
4575     // -=*# Resource for function RKP #*=-
4576    Resource SC_OPCODE_RKP
4577    {
4578        String 1 // Description
4579        {
4580            Text [ en-US ] = "Calculates the parameters of the exponential regression curve as an array." ;
4581        };
4582        ExtraData =
4583        {
4584            0;
4585            ID_FUNCTION_GRP_MATRIX;
4586            U2S( HID_FUNC_RKP );
4587            4;  0;  1;  1;  1;
4588            0;
4589        };
4590        String 2 // Name of Parameter 1
4591        {
4592            Text [ en-US ] = "data_Y" ;
4593        };
4594        String 3 // Description of Parameter 1
4595        {
4596            Text [ en-US ] = "The Y data array." ;
4597        };
4598        String 4 // Name of Parameter 2
4599        {
4600            Text [ en-US ] = "data_X" ;
4601        };
4602        String 5 // Description of Parameter 2
4603        {
4604            Text [ en-US ] = "The X data array." ;
4605        };
4606        String 6 // Name of Parameter 3
4607        {
4608            Text [ en-US ] = "Function_type" ;
4609        };
4610        String 7 // Description of Parameter 3
4611        {
4612            Text [ en-US ] = "If type = 0 then the functions will be calculated in the form of y=m^x, or also functions y=b*m^x." ;
4613        };
4614        String 8 // Name of Parameter 4
4615        {
4616            Text [ en-US ] = "stats" ;
4617        };
4618        String 9 // Description of Parameter 4
4619        {
4620            Text [ en-US ] = "If parameter = 0 then only the regression coefficient will be calculated, otherwise other values as well." ;
4621        };
4622    };
4623     // -=*# Resource for function TREND #*=-
4624    Resource SC_OPCODE_TREND
4625    {
4626        String 1 // Description
4627        {
4628            Text [ en-US ] = "Calculates points along a regression line." ;
4629        };
4630        ExtraData =
4631        {
4632            0;
4633            ID_FUNCTION_GRP_MATRIX;
4634            U2S( HID_FUNC_TREND );
4635            4;  0;  1;  1;  1;
4636            0;
4637        };
4638        String 2 // Name of Parameter 1
4639        {
4640            Text [ en-US ] = "data_Y" ;
4641        };
4642        String 3 // Description of Parameter 1
4643        {
4644            Text [ en-US ] = "The Y data array." ;
4645        };
4646        String 4 // Name of Parameter 2
4647        {
4648            Text [ en-US ] = "data_X" ;
4649        };
4650        String 5 // Description of Parameter 2
4651        {
4652            Text [ en-US ] = "The X data array as the basis for the regression." ;
4653        };
4654        String 6 // Name of Parameter 3
4655        {
4656            Text [ en-US ] = "new data_X" ;
4657        };
4658        String 7 // Description of Parameter 3
4659        {
4660            Text [ en-US ] = "The array of X data for recalculating the values." ;
4661        };
4662        String 8 // Name of Parameter 4
4663        {
4664            Text [ en-US ] = "Linear_type" ;
4665        };
4666        String 9 // Description of Parameter 4
4667        {
4668            Text [ en-US ] = "If type = 0 the linears will be calculated through the zero point, or else moved linears." ;
4669        };
4670    };
4671     // -=*# Resource for function VARIATION #*=-
4672    Resource SC_OPCODE_GROWTH
4673    {
4674        String 1 // Description
4675        {
4676            Text [ en-US ] = "Calculates points on the exponential regression function." ;
4677        };
4678        ExtraData =
4679        {
4680            0;
4681            ID_FUNCTION_GRP_MATRIX;
4682            U2S( HID_FUNC_VARIATION );
4683            4;  0;  1;  1;  1;
4684            0;
4685        };
4686        String 2 // Name of Parameter 1
4687        {
4688            Text [ en-US ] = "data_Y" ;
4689        };
4690        String 3 // Description of Parameter 1
4691        {
4692            Text [ en-US ] = "The Y data array." ;
4693        };
4694        String 4 // Name of Parameter 2
4695        {
4696            Text [ en-US ] = "data_X" ;
4697        };
4698        String 5 // Description of Parameter 2
4699        {
4700            Text [ en-US ] = "The X data array as the basis for the regression." ;
4701        };
4702        String 6 // Name of Parameter 3
4703        {
4704            Text [ en-US ] = "new_data_X" ;
4705        };
4706        String 7 // Description of Parameter 3
4707        {
4708            Text [ en-US ] = "The array of X data for recalculating the values." ;
4709        };
4710        String 8 // Name of Parameter 4
4711        {
4712            Text [ en-US ] = "Function_type" ;
4713        };
4714        String 9 // Description of Parameter 4
4715        {
4716            Text [ en-US ] = "If type = 0 then the functions will be calculated in the form of y=m^x, or also functions y=b*m^x." ;
4717        };
4718    };
4719     // -=*# Resource for function ANZAHL #*=-
4720    Resource SC_OPCODE_COUNT
4721    {
4722        String 1 // Description
4723        {
4724            Text [ en-US ] = "Counts how many numbers are in the list of arguments." ;
4725        };
4726        ExtraData =
4727        {
4728            0;
4729            ID_FUNCTION_GRP_STATISTIC;
4730            U2S( HID_FUNC_ANZAHL );
4731            VAR_ARGS;   0;
4732            0;
4733        };
4734        String 2 // Name of Parameter 1
4735        {
4736            Text [ en-US ] = "value " ;
4737        };
4738        String 3 // Description of Parameter 1
4739        {
4740            Text [ en-US ] = "Value 1, value 2, ... are 1 to 30 arguments containing different data types but where only numbers are counted." ;
4741        };
4742    };
4743     // -=*# Resource for function ANZAHL2 #*=-
4744    Resource SC_OPCODE_COUNT_2
4745    {
4746        String 1 // Description
4747        {
4748            Text [ en-US ] = "Counts how many values are in the list of arguments." ;
4749        };
4750        ExtraData =
4751        {
4752            0;
4753            ID_FUNCTION_GRP_STATISTIC;
4754            U2S( HID_FUNC_ANZAHL2 );
4755            VAR_ARGS;   0;
4756            0;
4757        };
4758        String 2 // Name of Parameter 1
4759        {
4760            Text [ en-US ] = "value " ;
4761        };
4762        String 3 // Description of Parameter 1
4763        {
4764            Text [ en-US ] = "Value 1, value 2, ... are 1 to 30 arguments representing the values to be counted." ;
4765        };
4766    };
4767     // -=*# Resource for function MAX #*=-
4768    Resource SC_OPCODE_MAX
4769    {
4770        String 1 // Description
4771        {
4772            Text [ en-US ] = "Returns the maximum value in a list of arguments." ;
4773        };
4774        ExtraData =
4775        {
4776            0;
4777            ID_FUNCTION_GRP_STATISTIC;
4778            U2S( HID_FUNC_MAX );
4779            VAR_ARGS;   0;
4780            0;
4781        };
4782        String 2 // Name of Parameter 1
4783        {
4784            Text [ en-US ] = "number " ;
4785        };
4786        String 3 // Description of Parameter 1
4787        {
4788            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments for which the largest number is to be determined." ;
4789        };
4790    };
4791     // -=*# Resource for function MAXA #*=-
4792    Resource SC_OPCODE_MAX_A
4793    {
4794        String 1 // Description
4795        {
4796            Text [ en-US ] = "Returns the maximum value in a list of arguments. Text is evaluated as Zero.";
4797        };
4798        ExtraData =
4799        {
4800            0;
4801            ID_FUNCTION_GRP_STATISTIC;
4802            U2S( HID_FUNC_MAXA );
4803            VAR_ARGS;   0;
4804            0;
4805        };
4806        String 2 // Name of Parameter 1
4807        {
4808            Text [ en-US ] = "value ";
4809        };
4810        String 3 // Description of Parameter 1
4811        {
4812            Text [ en-US ] = "Value 1, value 2,    are 1 to 30 arguments whose largest value is to be determined.";
4813        };
4814    };
4815     // -=*# Resource for function MIN #*=-
4816    Resource SC_OPCODE_MIN
4817    {
4818        String 1 // Description
4819        {
4820            Text [ en-US ] = "Returns the minimum value in a list of arguments." ;
4821        };
4822        ExtraData =
4823        {
4824            0;
4825            ID_FUNCTION_GRP_STATISTIC;
4826            U2S( HID_FUNC_MIN );
4827            VAR_ARGS;   0;
4828            0;
4829        };
4830        String 2 // Name of Parameter 1
4831        {
4832            Text [ en-US ] = "number " ;
4833        };
4834        String 3 // Description of Parameter 1
4835        {
4836            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments for which the smallest number is to be determined." ;
4837        };
4838    };
4839     // -=*# Resource for function MINA #*=-
4840    Resource SC_OPCODE_MIN_A
4841    {
4842        String 1 // Description
4843        {
4844            Text [ en-US ] = "Returns the smallest value in a list of arguments. Text is evaluated as zero.";
4845        };
4846        ExtraData =
4847        {
4848            0;
4849            ID_FUNCTION_GRP_STATISTIC;
4850            U2S( HID_FUNC_MINA );
4851            VAR_ARGS;   0;
4852            0;
4853        };
4854        String 2 // Name of Parameter 1
4855        {
4856            Text [ en-US ] = "value ";
4857        };
4858        String 3 // Description of Parameter 1
4859        {
4860            Text [ en-US ] = "Value 1; value 2;... are 1 to 30 arguments whose smallest number is to be determined.";
4861        };
4862    };
4863     // -=*# Resource for function VARIANZ #*=-
4864    Resource SC_OPCODE_VAR
4865    {
4866        String 1 // Description
4867        {
4868            Text [ en-US ] = "Calculates the variance based on a sample." ;
4869        };
4870        ExtraData =
4871        {
4872            0;
4873            ID_FUNCTION_GRP_STATISTIC;
4874            U2S( HID_FUNC_VARIANZ );
4875            VAR_ARGS;   0;
4876            0;
4877        };
4878        String 2 // Name of Parameter 1
4879        {
4880            Text [ en-US ] = "number " ;
4881        };
4882        String 3 // Description of Parameter 1
4883        {
4884            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population." ;
4885        };
4886    };
4887     // -=*# Resource for function VARIANZ #*=-
4888    Resource SC_OPCODE_VAR_A
4889    {
4890        String 1 // Description
4891        {
4892            Text [ en-US ] = "Returns the variance based on a sample. Text is evaluated as zero.";
4893        };
4894        ExtraData =
4895        {
4896            0;
4897            ID_FUNCTION_GRP_STATISTIC;
4898            U2S( HID_FUNC_VARIANZA );
4899            VAR_ARGS;   0;
4900            0;
4901        };
4902        String 2 // Name of Parameter 1
4903        {
4904            Text [ en-US ] = "value ";
4905        };
4906        String 3 // Description of Parameter 1
4907        {
4908            Text [ en-US ] = "Value 1; value 2; ... are 1 to 30 arguments representing a sample taken from a basic total population.";
4909        };
4910    };
4911     // -=*# Resource for function VARIANZEN #*=-
4912    Resource SC_OPCODE_VAR_P
4913    {
4914        String 1 // Description
4915        {
4916            Text [ en-US ] = "Calculates variance based on the entire population." ;
4917        };
4918        ExtraData =
4919        {
4920            0;
4921            ID_FUNCTION_GRP_STATISTIC;
4922            U2S( HID_FUNC_VARIANZEN );
4923            VAR_ARGS;   0;
4924            0;
4925        };
4926        String 2 // Name of Parameter 1
4927        {
4928            Text [ en-US ] = "number " ;
4929        };
4930        String 3 // Description of Parameter 1
4931        {
4932            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which represent a population." ;
4933        };
4934    };
4935     // -=*# Resource for function VARIANZENA #*=-
4936    Resource SC_OPCODE_VAR_P_A
4937    {
4938        String 1 // Description
4939        {
4940            Text [ en-US ] = "Returns the variance based on the entire population. Text is evaluated as zero.";
4941        };
4942        ExtraData =
4943        {
4944            0;
4945            ID_FUNCTION_GRP_STATISTIC;
4946            U2S( HID_FUNC_VARIANZENA );
4947            VAR_ARGS;   0;
4948            0;
4949        };
4950        String 2 // Name of Parameter 1
4951        {
4952            Text [ en-US ] = "value ";
4953        };
4954        String 3 // Description of Parameter 1
4955        {
4956            Text [ en-US ] = "Value 1; value 2;... are 1 to 30 arguments representing a population.";
4957        };
4958    };
4959     // -=*# Resource for function STABW #*=-
4960    Resource SC_OPCODE_ST_DEV
4961    {
4962        String 1 // Description
4963        {
4964            Text [ en-US ] = "Calculates the standard deviation based on a sample." ;
4965        };
4966        ExtraData =
4967        {
4968            0;
4969            ID_FUNCTION_GRP_STATISTIC;
4970            U2S( HID_FUNC_STABW );
4971            VAR_ARGS;   0;
4972            0;
4973        };
4974        String 2 // Name of Parameter 1
4975        {
4976            Text [ en-US ] = "number " ;
4977        };
4978        String 3 // Description of Parameter 1
4979        {
4980            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population." ;
4981        };
4982    };
4983     // -=*# Resource for function STABWA #*=-
4984    Resource SC_OPCODE_ST_DEV_A
4985    {
4986        String 1 // Description
4987        {
4988            Text [ en-US ] = "Returns the standard deviation based on a sample. Text is evaluated as zero.";
4989        };
4990        ExtraData =
4991        {
4992            0;
4993            ID_FUNCTION_GRP_STATISTIC;
4994            U2S( HID_FUNC_STABWA );
4995            VAR_ARGS;   0;
4996            0;
4997        };
4998        String 2 // Name of Parameter 1
4999        {
5000            Text [ en-US ] = "value ";
5001        };
5002        String 3 // Description of Parameter 1
5003        {
5004            Text [ en-US ] = "Value 1; value 2; ... are 1 to 30 arguments representing a sample taken from a basic total population.";
5005        };
5006    };
5007     // -=*# Resource for function STABWN #*=-
5008    Resource SC_OPCODE_ST_DEV_P
5009    {
5010        String 1 // Description
5011        {
5012            Text [ en-US ] = "Calculates the standard deviation based on the entire population." ;
5013        };
5014        ExtraData =
5015        {
5016            0;
5017            ID_FUNCTION_GRP_STATISTIC;
5018            U2S( HID_FUNC_STABWN );
5019            VAR_ARGS;   0;
5020            0;
5021        };
5022        String 2 // Name of Parameter 1
5023        {
5024            Text [ en-US ] = "number " ;
5025        };
5026        String 3 // Description of Parameter 1
5027        {
5028            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population." ;
5029        };
5030    };
5031     // -=*# Resource for function STABWNA #*=-
5032    Resource SC_OPCODE_ST_DEV_P_A
5033    {
5034        String 1 // Description
5035        {
5036            Text [ en-US ] = "Returns the standard deviation based on the entire population. Text is evaluated as zero.";
5037        };
5038        ExtraData =
5039        {
5040            0;
5041            ID_FUNCTION_GRP_STATISTIC;
5042            U2S( HID_FUNC_STABWNA );
5043            VAR_ARGS;   0;
5044            0;
5045        };
5046        String 2 // Name of Parameter 1
5047        {
5048            Text [ en-US ] = "value ";
5049        };
5050        String 3 // Description of Parameter 1
5051        {
5052            Text [ en-US ] = "Value 1; value 2;... are 1 to 30 arguments corresponding to a population.";
5053        };
5054    };
5055     // -=*# Resource for function MITTELWERT #*=-
5056    Resource SC_OPCODE_AVERAGE
5057    {
5058        String 1 // Description
5059        {
5060            Text [ en-US ] = "Returns the average of a sample." ;
5061        };
5062        ExtraData =
5063        {
5064            0;
5065            ID_FUNCTION_GRP_STATISTIC;
5066            U2S( HID_FUNC_MITTELWERT );
5067            VAR_ARGS;   0;
5068            0;
5069        };
5070        String 2 // Name of Parameter 1
5071        {
5072            Text [ en-US ] = "number " ;
5073        };
5074        String 3 // Description of Parameter 1
5075        {
5076            Text [ en-US ] = "Number 1, number 2;...are 1 to 30 numeric arguments representing a population sample." ;
5077        };
5078    };
5079     // -=*# Resource for function MITTELWERTA #*=-
5080    Resource SC_OPCODE_AVERAGE_A
5081    {
5082        String 1 // Description
5083        {
5084            Text [ en-US ] = "Returns the average value for a sample. Text is evaluated as zero.";
5085        };
5086        ExtraData =
5087        {
5088            0;
5089            ID_FUNCTION_GRP_STATISTIC;
5090            U2S( HID_FUNC_MITTELWERTA );
5091            VAR_ARGS;   0;
5092            0;
5093        };
5094        String 2 // Name of Parameter 1
5095        {
5096            Text [ en-US ] = "value ";
5097        };
5098        String 3 // Description of Parameter 1
5099        {
5100            Text [ en-US ] = "Value 1; value 2; ... are 1 to 30 arguments representing a sample taken from a basic total population.";
5101        };
5102    };
5103     // -=*# Resource for function SUMQUADABW #*=-
5104    Resource SC_OPCODE_DEV_SQ
5105    {
5106        String 1 // Description
5107        {
5108            Text [ en-US ] = "Returns the sum of squares of deviations from the sample mean value" ;
5109        };
5110        ExtraData =
5111        {
5112            0;
5113            ID_FUNCTION_GRP_STATISTIC;
5114            U2S( HID_FUNC_SUMQUADABW );
5115            VAR_ARGS;   0;
5116            0;
5117        };
5118        String 2 // Name of Parameter 1
5119        {
5120            Text [ en-US ] = "number " ;
5121        };
5122        String 3 // Description of Parameter 1
5123        {
5124            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ;
5125        };
5126    };
5127     // -=*# Resource for function MITTELABW #*=-
5128    Resource SC_OPCODE_AVE_DEV
5129    {
5130        String 1 // Description
5131        {
5132            Text [ en-US ] = "Returns the average of the absolute deviations of a sample from the mean." ;
5133        };
5134        ExtraData =
5135        {
5136            0;
5137            ID_FUNCTION_GRP_STATISTIC;
5138            U2S( HID_FUNC_MITTELABW );
5139            VAR_ARGS;   0;
5140            0;
5141        };
5142        String 2 // Name of Parameter 1
5143        {
5144            Text [ en-US ] = "number " ;
5145        };
5146        String 3 // Description of Parameter 1
5147        {
5148            Text [ en-US ] = "Number 1, number 2;...are 1 to 30 numerical arguments representing a sample." ;
5149        };
5150    };
5151     // -=*# Resource for function SCHIEFE #*=-
5152    Resource SC_OPCODE_SCHIEFE
5153    {
5154        String 1 // Description
5155        {
5156            Text [ en-US ] = "Returns the skewness of a distribution." ;
5157        };
5158        ExtraData =
5159        {
5160            0;
5161            ID_FUNCTION_GRP_STATISTIC;
5162            U2S( HID_FUNC_SCHIEFE );
5163            VAR_ARGS;   0;
5164            0;
5165        };
5166        String 2 // Name of Parameter 1
5167        {
5168            Text [ en-US ] = "number " ;
5169        };
5170        String 3 // Description of Parameter 1
5171        {
5172            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments portraying a sample of the distribution." ;
5173        };
5174    };
5175     // -=*# Resource for function KURT #*=-
5176    Resource SC_OPCODE_KURT
5177    {
5178        String 1 // Description
5179        {
5180            Text [ en-US ] = "Returns the kurtosis of a distribution." ;
5181        };
5182        ExtraData =
5183        {
5184            0;
5185            ID_FUNCTION_GRP_STATISTIC;
5186            U2S( HID_FUNC_KURT );
5187            VAR_ARGS;   0;
5188            0;
5189        };
5190        String 2 // Name of Parameter 1
5191        {
5192            Text [ en-US ] = "number " ;
5193        };
5194        String 3 // Description of Parameter 1
5195        {
5196            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments, representing a sample of the distribution." ;
5197        };
5198    };
5199     // -=*# Resource for function GEOMITTEL #*=-
5200    Resource SC_OPCODE_GEO_MEAN
5201    {
5202        String 1 // Description
5203        {
5204            Text [ en-US ] = "Returns the geometric mean of a sample." ;
5205        };
5206        ExtraData =
5207        {
5208            0;
5209            ID_FUNCTION_GRP_STATISTIC;
5210            U2S( HID_FUNC_GEOMITTEL );
5211            VAR_ARGS;   0;
5212            0;
5213        };
5214        String 2 // Name of Parameter 1
5215        {
5216            Text [ en-US ] = "number " ;
5217        };
5218        String 3 // Description of Parameter 1
5219        {
5220            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ;
5221        };
5222    };
5223     // -=*# Resource for function HARMITTEL #*=-
5224    Resource SC_OPCODE_HAR_MEAN
5225    {
5226        String 1 // Description
5227        {
5228            Text [ en-US ] = "Returns the harmonic mean of a sample." ;
5229        };
5230        ExtraData =
5231        {
5232            0;
5233            ID_FUNCTION_GRP_STATISTIC;
5234            U2S( HID_FUNC_HARMITTEL );
5235            VAR_ARGS;   0;
5236            0;
5237        };
5238        String 2 // Name of Parameter 1
5239        {
5240            Text [ en-US ] = "number " ;
5241        };
5242        String 3 // Description of Parameter 1
5243        {
5244            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ;
5245        };
5246    };
5247     // -=*# Resource for function MODALWERT #*=-
5248    Resource SC_OPCODE_MODAL_VALUE
5249    {
5250        String 1 // Description
5251        {
5252            Text [ en-US ] = "Returns the most common value in a sample." ;
5253        };
5254        ExtraData =
5255        {
5256            0;
5257            ID_FUNCTION_GRP_STATISTIC;
5258            U2S( HID_FUNC_MODALWERT );
5259            VAR_ARGS;   0;
5260            0;
5261        };
5262        String 2 // Name of Parameter 1
5263        {
5264            Text [ en-US ] = "number " ;
5265        };
5266        String 3 // Description of Parameter 1
5267        {
5268            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ;
5269        };
5270    };
5271     // -=*# Resource for function MEDIAN #*=-
5272    Resource SC_OPCODE_MEDIAN
5273    {
5274        String 1 // Description
5275        {
5276            Text [ en-US ] = "Returns the median of a given sample." ;
5277        };
5278        ExtraData =
5279        {
5280            0;
5281            ID_FUNCTION_GRP_STATISTIC;
5282            U2S( HID_FUNC_MEDIAN );
5283            VAR_ARGS;   0;
5284            0;
5285        };
5286        String 2 // Name of Parameter 1
5287        {
5288            Text [ en-US ] = "number " ;
5289        };
5290        String 3 // Description of Parameter 1
5291        {
5292            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ;
5293        };
5294    };
5295     // -=*# Resource for function QUANTIL #*=-
5296    Resource SC_OPCODE_PERCENTILE
5297    {
5298        String 1 // Description
5299        {
5300            Text [ en-US ] = "Returns the alpha quantile of a sample." ;
5301        };
5302        ExtraData =
5303        {
5304            0;
5305            ID_FUNCTION_GRP_STATISTIC;
5306            U2S( HID_FUNC_QUANTIL );
5307            2;  0;  0;
5308            0;
5309        };
5310        String 2 // Name of Parameter 1
5311        {
5312            Text [ en-US ] = "data" ;
5313        };
5314        String 3 // Description of Parameter 1
5315        {
5316            Text [ en-US ] = "The array of the data in the sample." ;
5317        };
5318        String 4 // Name of Parameter 2
5319        {
5320            Text [ en-US ] = "Alpha" ;
5321        };
5322        String 5 // Description of Parameter 2
5323        {
5324            Text [ en-US ] = "The percentage rate of the quantile between 0 and 1." ;
5325        };
5326    };
5327     // -=*# Resource for function QUARTILE #*=-
5328    Resource SC_OPCODE_QUARTILE
5329    {
5330        String 1 // Description
5331        {
5332            Text [ en-US ] = "Returns the quartile of a sample." ;
5333        };
5334        ExtraData =
5335        {
5336            0;
5337            ID_FUNCTION_GRP_STATISTIC;
5338            U2S( HID_FUNC_QUARTILE );
5339            2;  0;  0;
5340            0;
5341        };
5342        String 2 // Name of Parameter 1
5343        {
5344            Text [ en-US ] = "data" ;
5345        };
5346        String 3 // Description of Parameter 1
5347        {
5348            Text [ en-US ] = "The array of the data in the sample." ;
5349        };
5350        String 4 // Name of Parameter 2
5351        {
5352            Text [ en-US ] = "Type" ;
5353        };
5354        String 5 // Description of Parameter 2
5355        {
5356            Text [ en-US ] = "The type of the quartile (0 = MIN, 1 = 25%, 2 = 50 %, 3 = 75 %, 4 =MAX)." ;
5357        };
5358    };
5359     // -=*# Resource for function KGRÖSSTE #*=-
5360    Resource SC_OPCODE_LARGE
5361    {
5362        String 1 // Description
5363        {
5364            Text [ en-US ] = "Returns the k-th largest value of a sample." ;
5365        };
5366        ExtraData =
5367        {
5368            0;
5369            ID_FUNCTION_GRP_STATISTIC;
5370            U2S( HID_FUNC_KGROESSTE );
5371            2;  0;  0;
5372            0;
5373        };
5374        String 2 // Name of Parameter 1
5375        {
5376            Text [ en-US ] = "data" ;
5377        };
5378        String 3 // Description of Parameter 1
5379        {
5380            Text [ en-US ] = "The array of the data in the sample." ;
5381        };
5382        String 4 // Name of Parameter 2
5383        {
5384            Text [ en-US ] = "Rank_c" ;
5385        };
5386        String 5 // Description of Parameter 2
5387        {
5388            Text [ en-US ] = "The ranking of the value." ;
5389        };
5390    };
5391     // -=*# Resource for function KKLEINSTE #*=-
5392    Resource SC_OPCODE_SMALL
5393    {
5394        String 1 // Description
5395        {
5396            Text [ en-US ] = "Returns the k-th smallest value of a sample." ;
5397        };
5398        ExtraData =
5399        {
5400            0;
5401            ID_FUNCTION_GRP_STATISTIC;
5402            U2S( HID_FUNC_KKLEINSTE );
5403            2;  0;  0;
5404            0;
5405        };
5406        String 2 // Name of Parameter 1
5407        {
5408            Text [ en-US ] = "data" ;
5409        };
5410        String 3 // Description of Parameter 1
5411        {
5412            Text [ en-US ] = "The array of the data in the sample." ;
5413        };
5414        String 4 // Name of Parameter 2
5415        {
5416            Text [ en-US ] = "Rank_c" ;
5417        };
5418        String 5 // Description of Parameter 2
5419        {
5420            Text [ en-US ] = "The ranking of the value." ;
5421        };
5422    };
5423     // -=*# Resource for function QUANTILSRANG #*=-
5424    Resource SC_OPCODE_PERCENT_RANK
5425    {
5426        String 1 // Description
5427        {
5428            Text [ en-US ] = "Returns the percentage rank of a value in a sample." ;
5429        };
5430        ExtraData =
5431        {
5432            0;
5433            ID_FUNCTION_GRP_STATISTIC;
5434            U2S( HID_FUNC_QUANTILSRANG );
5435            2;  0;  0;
5436            0;
5437        };
5438        String 2 // Name of Parameter 1
5439        {
5440            Text [ en-US ] = "data" ;
5441        };
5442        String 3 // Description of Parameter 1
5443        {
5444            Text [ en-US ] = "The array of the data in the sample." ;
5445        };
5446        String 4 // Name of Parameter 2
5447        {
5448            Text [ en-US ] = "value" ;
5449        };
5450        String 5 // Description of Parameter 2
5451        {
5452            Text [ en-US ] = "The value for which percentage ranking is to be determined." ;
5453        };
5454    };
5455     // -=*# Resource for function RANG #*=-
5456    Resource SC_OPCODE_RANK
5457    {
5458        String 1 // Description
5459        {
5460            Text [ en-US ] = "Returns the ranking of a value in a sample." ;
5461        };
5462        ExtraData =
5463        {
5464            0;
5465            ID_FUNCTION_GRP_STATISTIC;
5466            U2S( HID_FUNC_RANG );
5467            3;  0;  0;  1;
5468            0;
5469        };
5470        String 2 // Name of Parameter 1
5471        {
5472            Text [ en-US ] = "value" ;
5473        };
5474        String 3 // Description of Parameter 1
5475        {
5476            Text [ en-US ] = "The value for which the rank is to be determined." ;
5477        };
5478        String 4 // Name of Parameter 2
5479        {
5480            Text [ en-US ] = "Data" ;
5481        };
5482        String 5 // Description of Parameter 2
5483        {
5484            Text [ en-US ] = "The array of the data in the sample." ;
5485        };
5486        String 6 // Name of Parameter 3
5487        {
5488            Text [ en-US ] = "Type" ;
5489        };
5490        String 7 // Description of Parameter 3
5491        {
5492            Text [ en-US ] = "Sequence order: 0 or omitted means descending, any other value than 0 means ascending." ;
5493        };
5494    };
5495     // -=*# Resource for function GESTUTZTMITTEL #*=-
5496    Resource SC_OPCODE_TRIM_MEAN
5497    {
5498        String 1 // Description
5499        {
5500            Text [ en-US ] = "Returns the mean of a sample without including the marginal values." ;
5501        };
5502        ExtraData =
5503        {
5504            0;
5505            ID_FUNCTION_GRP_STATISTIC;
5506            U2S( HID_FUNC_GESTUTZTMITTEL );
5507            2;  0;  0;
5508            0;
5509        };
5510        String 2 // Name of Parameter 1
5511        {
5512            Text [ en-US ] = "data" ;
5513        };
5514        String 3 // Description of Parameter 1
5515        {
5516            Text [ en-US ] = "The array of the data in the sample." ;
5517        };
5518        String 4 // Name of Parameter 2
5519        {
5520            Text [ en-US ] = "Alpha" ;
5521        };
5522        String 5 // Description of Parameter 2
5523        {
5524            Text [ en-US ] = "The percentage of marginal data that is not to be taken into account." ;
5525        };
5526    };
5527     // -=*# Resource for function WAHRSCHBEREICH #*=-
5528    Resource SC_OPCODE_PROB
5529    {
5530        String 1 // Description
5531        {
5532            Text [ en-US ] = "Returns the discreet probability of an interval." ;
5533        };
5534        ExtraData =
5535        {
5536            0;
5537            ID_FUNCTION_GRP_STATISTIC;
5538            U2S( HID_FUNC_WAHRSCHBEREICH );
5539            4;  0;  0;  0;  1;
5540            0;
5541        };
5542        String 2 // Name of Parameter 1
5543        {
5544            Text [ en-US ] = "data" ;
5545        };
5546        String 3 // Description of Parameter 1
5547        {
5548            Text [ en-US ] = "The sample data array." ;
5549        };
5550        String 4 // Name of Parameter 2
5551        {
5552            Text [ en-US ] = "probability" ;
5553        };
5554        String 5 // Description of Parameter 2
5555        {
5556            Text [ en-US ] = "The array of the associated probabilities." ;
5557        };
5558        String 6 // Name of Parameter 3
5559        {
5560            Text [ en-US ] = "Start" ;
5561        };
5562        String 7 // Description of Parameter 3
5563        {
5564            Text [ en-US ] = "The start of the value interval whose probabilities is to be totalled." ;
5565        };
5566        String 8 // Name of Parameter 4
5567        {
5568            Text [ en-US ] = "End" ;
5569        };
5570        String 9 // Description of Parameter 4
5571        {
5572            Text [ en-US ] = "The end of the value interval where the probabilities are to be totalled." ;
5573        };
5574    };
5575     // -=*# Resource for function B #*=-
5576    Resource SC_OPCODE_B
5577    {
5578        String 1 // Description
5579        {
5580            Text [ en-US ] = "Returns the probability of a trial result using binomial distribution." ;
5581        };
5582        ExtraData =
5583        {
5584            0;
5585            ID_FUNCTION_GRP_STATISTIC;
5586            U2S( HID_FUNC_B );
5587            4;  0;  0;  0;  1;
5588            0;
5589        };
5590        String 2 // Name of Parameter 1
5591        {
5592            Text [ en-US ] = "trials" ;
5593        };
5594        String 3 // Description of Parameter 1
5595        {
5596            Text [ en-US ] = "The number of trials." ;
5597        };
5598        String 4 // Name of Parameter 2
5599        {
5600            Text [ en-US ] = "SP" ;
5601        };
5602        String 5 // Description of Parameter 2
5603        {
5604            Text [ en-US ] = "The individual probability of a trial result." ;
5605        };
5606        String 6 // Name of Parameter 3
5607        {
5608            Text [ en-US ] = "T_1" ;
5609        };
5610        String 7 // Description of Parameter 3
5611        {
5612            Text [ en-US ] = "Lower limit for the number of trials." ;
5613        };
5614        String 8 // Name of Parameter 4
5615        {
5616            Text [ en-US ] = "T_2" ;
5617        };
5618        String 9 // Description of Parameter 4
5619        {
5620            Text [ en-US ] = "Upper limit for the number of trials." ;
5621        };
5622    };
5623     // -=*# Resource for function PHI #*=-
5624    Resource SC_OPCODE_PHI
5625    {
5626        String 1 // Description
5627        {
5628            Text [ en-US ] = "Values of the distribution function for a standard normal distribution." ;
5629        };
5630        ExtraData =
5631        {
5632            0;
5633            ID_FUNCTION_GRP_STATISTIC;
5634            U2S( HID_FUNC_PHI );
5635            1;  0;
5636            0;
5637        };
5638        String 2 // Name of Parameter 1
5639        {
5640            Text [ en-US ] = "number" ;
5641        };
5642        String 3 // Description of Parameter 1
5643        {
5644            Text [ en-US ] = "The value for which the standard normal distribution is to be calculated." ;
5645        };
5646    };
5647     // -=*# Resource for function GAUSS #*=-
5648    Resource SC_OPCODE_GAUSS
5649    {
5650        String 1 // Description
5651        {
5652            Text [ en-US ] = "Returns the integral values of the standard normal cumulative distribution." ;
5653        };
5654        ExtraData =
5655        {
5656            0;
5657            ID_FUNCTION_GRP_STATISTIC;
5658            U2S( HID_FUNC_GAUSS );
5659            1;  0;
5660            0;
5661        };
5662        String 2 // Name of Parameter 1
5663        {
5664            Text [ en-US ] = "Number" ;
5665        };
5666        String 3 // Description of Parameter 1
5667        {
5668            Text [ en-US ] = "The value for which the integral value of the standard normal distribution is to be calculated." ;
5669        };
5670    };
5671     // -=*# Resource for function FISHER #*=-
5672    Resource SC_OPCODE_FISHER
5673    {
5674        String 1 // Description
5675        {
5676            Text [ en-US ] = "Returns the Fisher transformation." ;
5677        };
5678        ExtraData =
5679        {
5680            0;
5681            ID_FUNCTION_GRP_STATISTIC;
5682            U2S( HID_FUNC_FISHER );
5683            1;  0;
5684            0;
5685        };
5686        String 2 // Name of Parameter 1
5687        {
5688            Text [ en-US ] = "Number" ;
5689        };
5690        String 3 // Description of Parameter 1
5691        {
5692            Text [ en-US ] = "The value to be transformed (-1 < VALUE < 1)." ;
5693        };
5694    };
5695     // -=*# Resource for function FISHERINV #*=-
5696    Resource SC_OPCODE_FISHER_INV
5697    {
5698        String 1 // Description
5699        {
5700            Text [ en-US ] = "Returns the inverse of the Fisher transformation." ;
5701        };
5702        ExtraData =
5703        {
5704            0;
5705            ID_FUNCTION_GRP_STATISTIC;
5706            U2S( HID_FUNC_FISHERINV );
5707            1;  0;
5708            0;
5709        };
5710        String 2 // Name of Parameter 1
5711        {
5712            Text [ en-US ] = "Number" ;
5713        };
5714        String 3 // Description of Parameter 1
5715        {
5716            Text [ en-US ] = "The value that is to be transformed back." ;
5717        };
5718    };
5719     // -=*# Resource for function BINOMVERT #*=-
5720    Resource SC_OPCODE_BINOM_DIST
5721    {
5722        String 1 // Description
5723        {
5724            Text [ en-US ] = "Values of the binomial distribution." ;
5725        };
5726        ExtraData =
5727        {
5728            0;
5729            ID_FUNCTION_GRP_STATISTIC;
5730            U2S( HID_FUNC_BINOMVERT );
5731            4;  0;  0;  0;  0;
5732            0;
5733        };
5734        String 2 // Name of Parameter 1
5735        {
5736            Text [ en-US ] = "X" ;
5737        };
5738        String 3 // Description of Parameter 1
5739        {
5740            Text [ en-US ] = "The number of successes in a series of trials." ;
5741        };
5742        String 4 // Name of Parameter 2
5743        {
5744            Text [ en-US ] = "trials" ;
5745        };
5746        String 5 // Description of Parameter 2
5747        {
5748            Text [ en-US ] = "The total number of trials." ;
5749        };
5750        String 6 // Name of Parameter 3
5751        {
5752            Text [ en-US ] = "SP" ;
5753        };
5754        String 7 // Description of Parameter 3
5755        {
5756            Text [ en-US ] = "The success probability of a trial." ;
5757        };
5758        String 8 // Name of Parameter 4
5759        {
5760            Text [ en-US ] = "C" ;
5761        };
5762        String 9 // Description of Parameter 4
5763        {
5764            Text [ en-US ] = "Cumulated. C=0 calculates the individual probability, C=1 the cumulated probability." ;
5765        };
5766    };
5767     // -=*# Resource for function NEGBINOMVERT #*=-
5768    Resource SC_OPCODE_NEG_BINOM_VERT
5769    {
5770        String 1 // Description
5771        {
5772            Text [ en-US ] = "Values of the negative binomial distribution." ;
5773        };
5774        ExtraData =
5775        {
5776            0;
5777            ID_FUNCTION_GRP_STATISTIC;
5778            U2S( HID_FUNC_NEGBINOMVERT );
5779            3;  0;  0;  0;
5780            0;
5781        };
5782        String 2 // Name of Parameter 1
5783        {
5784            Text [ en-US ] = "X" ;
5785        };
5786        String 3 // Description of Parameter 1
5787        {
5788            Text [ en-US ] = "The number of failures in the trial range." ;
5789        };
5790        String 4 // Name of Parameter 2
5791        {
5792            Text [ en-US ] = "R" ;
5793        };
5794        String 5 // Description of Parameter 2
5795        {
5796            Text [ en-US ] = "The number of successes in the trial sequence." ;
5797        };
5798        String 6 // Name of Parameter 3
5799        {
5800            Text [ en-US ] = "SP" ;
5801        };
5802        String 7 // Description of Parameter 3
5803        {
5804            Text [ en-US ] = "The success probability of a trial." ;
5805        };
5806    };
5807     // -=*# Resource for function KRITBINOM #*=-
5808    Resource SC_OPCODE_KRIT_BINOM
5809    {
5810        String 1 // Description
5811        {
5812            Text [ en-US ] = "Border arguments of the binomial distribution." ;
5813        };
5814        ExtraData =
5815        {
5816            0;
5817            ID_FUNCTION_GRP_STATISTIC;
5818            U2S( HID_FUNC_KRITBINOM );
5819            3;  0;  0;  0;
5820            0;
5821        };
5822        String 2 // Name of Parameter 1
5823        {
5824            Text [ en-US ] = "trials" ;
5825        };
5826        String 3 // Description of Parameter 1
5827        {
5828            Text [ en-US ] = "The total number of trials." ;
5829        };
5830        String 4 // Name of Parameter 2
5831        {
5832            Text [ en-US ] = "SP" ;
5833        };
5834        String 5 // Description of Parameter 2
5835        {
5836            Text [ en-US ] = "The success probability of a trial." ;
5837        };
5838        String 6 // Name of Parameter 3
5839        {
5840            Text [ en-US ] = "alpha" ;
5841        };
5842        String 7 // Description of Parameter 3
5843        {
5844            Text [ en-US ] = "The border probability that is attained or exceeded." ;
5845        };
5846    };
5847     // -=*# Resource for function POISSON #*=-
5848    Resource SC_OPCODE_POISSON_DIST
5849    {
5850        String 1 // Description
5851        {
5852            Text [ en-US ] = "Returns the Poisson distribution." ;
5853        };
5854        ExtraData =
5855        {
5856            0;
5857            ID_FUNCTION_GRP_STATISTIC;
5858            U2S( HID_FUNC_POISSON );
5859            3;  0;  0;  1;
5860            0;
5861        };
5862        String 2 // Name of Parameter 1
5863        {
5864            Text [ en-US ] = "Number" ;
5865        };
5866        String 3 // Description of Parameter 1
5867        {
5868            Text [ en-US ] = "The value for which the Poisson distribution is to be calculated." ;
5869        };
5870        String 4 // Name of Parameter 2
5871        {
5872            Text [ en-US ] = "mean" ;
5873        };
5874        String 5 // Description of Parameter 2
5875        {
5876            Text [ en-US ] = "Mean. The mean value of the Poisson distribution." ;
5877        };
5878        String 6 // Name of Parameter 3
5879        {
5880            Text [ en-US ] = "Cumulative" ;
5881        };
5882        String 7 // Description of Parameter 3
5883        {
5884            Text [ en-US ] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ;
5885        };
5886    };
5887     // -=*# Resource for function NORMVERT #*=-
5888    Resource SC_OPCODE_NORM_DIST
5889    {
5890        String 1 // Description
5891        {
5892            Text [ en-US ] = "Values of the normal distribution." ;
5893        };
5894        ExtraData =
5895        {
5896            0;
5897            ID_FUNCTION_GRP_STATISTIC;
5898            U2S( HID_FUNC_NORMVERT );
5899            4;  0;  0;  0;  1;
5900            0;
5901        };
5902        String 2 // Name of Parameter 1
5903        {
5904            Text [ en-US ] = "Number" ;
5905        };
5906        String 3 // Description of Parameter 1
5907        {
5908            Text [ en-US ] = "The value for which the normal distribution is to be calculated." ;
5909        };
5910        String 4 // Name of Parameter 2
5911        {
5912            Text [ en-US ] = "Mean" ;
5913        };
5914        String 5 // Description of Parameter 2
5915        {
5916            Text [ en-US ] = "The mean value. The mean value of the normal distribution." ;
5917        };
5918        String 6 // Name of Parameter 3
5919        {
5920            Text [ en-US ] = "STDEV" ;
5921        };
5922        String 7 // Description of Parameter 3
5923        {
5924            Text [ en-US ] = "Standard deviation. The standard deviation of the normal distribution." ;
5925        };
5926        String 8 // Name of Parameter 4
5927        {
5928            Text [ en-US ] = "C" ;
5929        };
5930        String 9 // Description of Parameter 4
5931        {
5932            Text [ en-US ] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ;
5933        };
5934    };
5935     // -=*# Resource for function NORMINV #*=-
5936    Resource SC_OPCODE_NORM_INV
5937    {
5938        String 1 // Description
5939        {
5940            Text [ en-US ] = "Values of the inverse normal distribution." ;
5941        };
5942        ExtraData =
5943        {
5944            0;
5945            ID_FUNCTION_GRP_STATISTIC;
5946            U2S( HID_FUNC_NORMINV );
5947            3;  0;  0;  0;
5948            0;
5949        };
5950        String 2 // Name of Parameter 1
5951        {
5952            Text [ en-US ] = "number" ;
5953        };
5954        String 3 // Description of Parameter 1
5955        {
5956            Text [ en-US ] = "The probability value for which the inverse normal distribution is to be calculated." ;
5957        };
5958        String 4 // Name of Parameter 2
5959        {
5960            Text [ en-US ] = "mean" ;
5961        };
5962        String 5 // Description of Parameter 2
5963        {
5964            Text [ en-US ] = "The mean value. The mean value of the normal distribution." ;
5965        };
5966        String 6 // Name of Parameter 3
5967        {
5968            Text [ en-US ] = "STDEV" ;
5969        };
5970        String 7 // Description of Parameter 3
5971        {
5972            Text [ en-US ] = "Standard deviation. The standard deviation of the normal distribution." ;
5973        };
5974    };
5975     // -=*# Resource for function STANDNORMVERT #*=-
5976    Resource SC_OPCODE_STD_NORM_DIST
5977    {
5978        String 1 // Description
5979        {
5980            Text [ en-US ] = "The values of the standard normal cumulative distribution." ;
5981        };
5982        ExtraData =
5983        {
5984            0;
5985            ID_FUNCTION_GRP_STATISTIC;
5986            U2S( HID_FUNC_STANDNORMVERT );
5987            1;  0;
5988            0;
5989        };
5990        String 2 // Name of Parameter 1
5991        {
5992            Text [ en-US ] = "Number" ;
5993        };
5994        String 3 // Description of Parameter 1
5995        {
5996            Text [ en-US ] = "The value for which the standard normal distribution is to be calculated." ;
5997        };
5998    };
5999     // -=*# Resource for function STANDNORMINV #*=-
6000    Resource SC_OPCODE_S_NORM_INV
6001    {
6002        String 1 // Description
6003        {
6004            Text [ en-US ] = "Values of the inverse standard normal distribution." ;
6005        };
6006        ExtraData =
6007        {
6008            0;
6009            ID_FUNCTION_GRP_STATISTIC;
6010            U2S( HID_FUNC_STANDNORMINV );
6011            1;  0;
6012            0;
6013        };
6014        String 2 // Name of Parameter 1
6015        {
6016            Text [ en-US ] = "number" ;
6017        };
6018        String 3 // Description of Parameter 1
6019        {
6020            Text [ en-US ] = "The probability value for which the inverse standard normal distribution is to be calculated." ;
6021        };
6022    };
6023     // -=*# Resource for function LOGNORMVERT #*=-
6024    Resource SC_OPCODE_LOG_NORM_DIST
6025    {
6026        String 1 // Description
6027        {
6028            Text [ en-US ] = "Values of the log normal distribution." ;
6029        };
6030        ExtraData =
6031        {
6032            0;
6033            ID_FUNCTION_GRP_STATISTIC;
6034            U2S( HID_FUNC_LOGNORMVERT );
6035            4;  0;  1;  1;  1;
6036            0;
6037        };
6038        String 2 // Name of Parameter 1
6039        {
6040            Text [ en-US ] = "Number" ;
6041        };
6042        String 3 // Description of Parameter 1
6043        {
6044            Text [ en-US ] = "The value for which the log normal distribution is to be calculated." ;
6045        };
6046        String 4 // Name of Parameter 2
6047        {
6048            Text [ en-US ] = "mean" ;
6049        };
6050        String 5 // Description of Parameter 2
6051        {
6052            Text [ en-US ] = "The mean value of the log normal distribution. It is set to 0 if omitted." ;
6053        };
6054        String 6 // Name of Parameter 3
6055        {
6056            Text [ en-US ] = "STDEV" ;
6057        };
6058        String 7 // Description of Parameter 3
6059        {
6060            Text [ en-US ] = "The standard deviation of the log normal distribution. It is set to 1 if omitted." ;
6061        };
6062        String 8 // Name of Parameter 4
6063        {
6064            Text [ en-US] = "Cumulative";
6065        };
6066        String 9 // Description of Parameter 4
6067        {
6068            Text [ en-US] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ;
6069        };
6070    };
6071     // -=*# Resource for function LOGINV #*=-
6072    Resource SC_OPCODE_LOG_INV
6073    {
6074        String 1 // Description
6075        {
6076            Text [ en-US ] = "Values of the inverse of the lognormal distribution." ;
6077        };
6078        ExtraData =
6079        {
6080            0;
6081            ID_FUNCTION_GRP_STATISTIC;
6082            U2S( HID_FUNC_LOGINV );
6083            3;  0;  0;  0;
6084            0;
6085        };
6086        String 2 // Name of Parameter 1
6087        {
6088            Text [ en-US ] = "number" ;
6089        };
6090        String 3 // Description of Parameter 1
6091        {
6092            Text [ en-US ] = "The probability value for which the inverse log normal distribution is to be calculated." ;
6093        };
6094        String 4 // Name of Parameter 2
6095        {
6096            Text [ en-US ] = "mean" ;
6097        };
6098        String 5 // Description of Parameter 2
6099        {
6100            Text [ en-US ] = "Mean value. The mean value of the log normal distribution." ;
6101        };
6102        String 6 // Name of Parameter 3
6103        {
6104            Text [ en-US ] = "STDEV" ;
6105        };
6106        String 7 // Description of Parameter 3
6107        {
6108            Text [ en-US ] = "Standard deviation. The standard deviation of the log normal distribution." ;
6109        };
6110    };
6111     // -=*# Resource for function EXPONVERT #*=-
6112    Resource SC_OPCODE_EXP_DIST
6113    {
6114        String 1 // Description
6115        {
6116            Text [ en-US ] = "Values of the exponential distribution." ;
6117        };
6118        ExtraData =
6119        {
6120            0;
6121            ID_FUNCTION_GRP_STATISTIC;
6122            U2S( HID_FUNC_EXPONVERT );
6123            3;  0;  0;  0;
6124            0;
6125        };
6126        String 2 // Name of Parameter 1
6127        {
6128            Text [ en-US ] = "Number" ;
6129        };
6130        String 3 // Description of Parameter 1
6131        {
6132            Text [ en-US ] = "The value to which the exponential distribution is to be calculated." ;
6133        };
6134        String 4 // Name of Parameter 2
6135        {
6136            Text [ en-US ] = "lambda" ;
6137        };
6138        String 5 // Description of Parameter 2
6139        {
6140            Text [ en-US ] = "The parameters of the exponential distribution." ;
6141        };
6142        String 6 // Name of Parameter 3
6143        {
6144            Text [ en-US ] = "C" ;
6145        };
6146        String 7 // Description of Parameter 3
6147        {
6148            Text [ en-US ] = "Cumulated. C=0 calculates the density function, C=1 the distribution." ;
6149        };
6150    };
6151     // -=*# Resource for function GAMMAVERT #*=-
6152    Resource SC_OPCODE_GAMMA_DIST
6153    {
6154        String 1 // Description
6155        {
6156            Text [ en-US ] = "Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution." ;
6157        };
6158        ExtraData =
6159        {
6160            0;
6161            ID_FUNCTION_GRP_STATISTIC;
6162            U2S( HID_FUNC_GAMMAVERT );
6163            4;  0;  0;  0;  1;
6164            0;
6165        };
6166        String 2 // Name of Parameter 1
6167        {
6168            Text [ en-US ] = "Number" ;
6169        };
6170        String 3 // Description of Parameter 1
6171        {
6172            Text [ en-US ] = "The value for which the gamma distribution is to be calculated." ;
6173        };
6174        String 4 // Name of Parameter 2
6175        {
6176            Text [ en-US ] = "alpha" ;
6177        };
6178        String 5 // Description of Parameter 2
6179        {
6180            Text [ en-US ] = "The Alpha parameter of the Gamma distribution." ;
6181        };
6182        String 6 // Name of Parameter 3
6183        {
6184            Text [ en-US ] = "beta" ;
6185        };
6186        String 7 // Description of Parameter 3
6187        {
6188            Text [ en-US ] = "The Beta parameter of the Gamma distribution." ;
6189        };
6190        String 8 // Name of Parameter 4
6191        {
6192            Text [ en-US ] = "Cumulative" ;
6193        };
6194        String 9 // Description of Parameter 4
6195        {
6196            Text [ en-US ] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ;
6197        };
6198    };
6199     // -=*# Resource for function GAMMAINV #*=-
6200    Resource SC_OPCODE_GAMMA_INV
6201    {
6202        String 1 // Description
6203        {
6204            Text [ en-US ] = "Values of the inverse gamma distribution." ;
6205        };
6206        ExtraData =
6207        {
6208            0;
6209            ID_FUNCTION_GRP_STATISTIC;
6210            U2S( HID_FUNC_GAMMAINV );
6211            3;  0;  0;  0;
6212            0;
6213        };
6214        String 2 // Name of Parameter 1
6215        {
6216            Text [ en-US ] = "Number" ;
6217        };
6218        String 3 // Description of Parameter 1
6219        {
6220            Text [ en-US ] = "The probability value for which the inverse gamma distribution is to be calculated." ;
6221        };
6222        String 4 // Name of Parameter 2
6223        {
6224            Text [ en-US ] = "alpha" ;
6225        };
6226        String 5 // Description of Parameter 2
6227        {
6228            Text [ en-US ] = "The Alpha (shape) parameter of the Gamma distribution." ;
6229        };
6230        String 6 // Name of Parameter 3
6231        {
6232            Text [ en-US ] = "beta" ;
6233        };
6234        String 7 // Description of Parameter 3
6235        {
6236            Text [ en-US ] = "The Beta (scale) parameter of the Gamma distribution." ;
6237        };
6238    };
6239     // -=*# Resource for function GAMMALN #*=-
6240    Resource SC_OPCODE_GAMMA_LN
6241    {
6242        String 1 // Description
6243        {
6244            Text [ en-US ] = "Returns the natural logarithm of the gamma function." ;
6245        };
6246        ExtraData =
6247        {
6248            0;
6249            ID_FUNCTION_GRP_STATISTIC;
6250            U2S( HID_FUNC_GAMMALN );
6251            1;  0;
6252            0;
6253        };
6254        String 2 // Name of Parameter 1
6255        {
6256            Text [ en-US ] = "Number" ;
6257        };
6258        String 3 // Description of Parameter 1
6259        {
6260            Text [ en-US ] = "The value for which the natural logarithm of the gamma function is to be calculated." ;
6261        };
6262    };
6263
6264     // -=*# Resource for function GAMMA #*=-
6265    Resource SC_OPCODE_GAMMA
6266    {
6267        String 1 // Description
6268        {
6269            Text [ en-US ] = "Returns the value of the Gamma function." ;
6270        };
6271        ExtraData =
6272        {
6273            0;
6274            ID_FUNCTION_GRP_STATISTIC;
6275            U2S( HID_FUNC_GAMMA );
6276            1;  0;
6277            0;
6278        };
6279        String 2 // Name of Parameter 1
6280        {
6281            Text [ en-US ] = "Number" ;
6282        };
6283        String 3 // Description of Parameter 1
6284        {
6285            Text [ en-US ] = "The value for which the Gamma function is to be calculated." ;
6286        };
6287    };
6288
6289     // -=*# Resource for function BETAVERT #*=-
6290    Resource SC_OPCODE_BETA_DIST
6291    {
6292        String 1 // Description
6293        {
6294            Text [ en-US ] = "Values of the beta distribution." ;
6295        };
6296        ExtraData =
6297        {
6298            0;
6299            ID_FUNCTION_GRP_STATISTIC;
6300            U2S( HID_FUNC_BETAVERT );
6301            6;  0;  0;  0;  1;  1;  1;
6302            0;
6303        };
6304        String 2 // Name of Parameter 1
6305        {
6306            Text [ en-US ] = "number" ;
6307        };
6308        String 3 // Description of Parameter 1
6309        {
6310            Text [ en-US ] = "The value for which the beta distribution is to be calculated." ;
6311        };
6312        String 4 // Name of Parameter 2
6313        {
6314            Text [ en-US ] = "alpha" ;
6315        };
6316        String 5 // Description of Parameter 2
6317        {
6318            Text [ en-US ] = "The Alpha parameter of the Beta distribution." ;
6319        };
6320        String 6 // Name of Parameter 3
6321        {
6322            Text [ en-US ] = "beta" ;
6323        };
6324        String 7 // Description of Parameter 3
6325        {
6326            Text [ en-US ] = "The Beta parameter of the Beta distribution." ;
6327        };
6328        String 8 // Name of Parameter 4
6329        {
6330            Text [ en-US ] = "Start" ;
6331        };
6332        String 9 // Description of Parameter 4
6333        {
6334            Text [ en-US ] = "The starting value for the value interval of the distribution." ;
6335        };
6336        String 10 // Name of Parameter 5
6337        {
6338            Text [ en-US ] = "End" ;
6339        };
6340        String 11 // Description of Parameter 5
6341        {
6342            Text [ en-US ] = "The final value for the value interval of the distribution." ;
6343        };
6344        String 12 // Name of Parameter 6
6345        {
6346            Text [en-US ] = "Cumulative" ;
6347        };
6348        String 13 // Description of Parameter 6
6349        {
6350            Text [ en-US ] = "0 or FALSE for probability density function, any other value or TRUE or omitted for cumulative distribution function.";
6351        };
6352    };
6353     // -=*# Resource for function BETAINV #*=-
6354    Resource SC_OPCODE_BETA_INV
6355    {
6356        String 1 // Description
6357        {
6358            Text [ en-US ] = "Values of the inverse beta distribution." ;
6359        };
6360        ExtraData =
6361        {
6362            0;
6363            ID_FUNCTION_GRP_STATISTIC;
6364            U2S( HID_FUNC_BETAINV );
6365            5;  0;  0;  0;  1;  1;
6366            0;
6367        };
6368        String 2 // Name of Parameter 1
6369        {
6370            Text [ en-US ] = "number" ;
6371        };
6372        String 3 // Description of Parameter 1
6373        {
6374            Text [ en-US ] = "The probability value for which the inverse beta distribution is to be calculated." ;
6375        };
6376        String 4 // Name of Parameter 2
6377        {
6378            Text [ en-US ] = "alpha" ;
6379        };
6380        String 5 // Description of Parameter 2
6381        {
6382            Text [ en-US ] = "The Alpha parameter of the Beta distribution." ;
6383        };
6384        String 6 // Name of Parameter 3
6385        {
6386            Text [ en-US ] = "beta" ;
6387        };
6388        String 7 // Description of Parameter 3
6389        {
6390            Text [ en-US ] = "The Beta parameter of the Beta distribution." ;
6391        };
6392        String 8 // Name of Parameter 4
6393        {
6394            Text [ en-US ] = "Start" ;
6395        };
6396        String 9 // Description of Parameter 4
6397        {
6398            Text [ en-US ] = "The starting value for the value interval of the distribution." ;
6399        };
6400        String 10 // Name of Parameter 5
6401        {
6402            Text [ en-US ] = "End" ;
6403        };
6404        String 11 // Description of Parameter 5
6405        {
6406            Text [ en-US ] = "The final value for the value interval of the distribution." ;
6407        };
6408    };
6409     // -=*# Resource for function WEIBULL #*=-
6410    Resource SC_OPCODE_WEIBULL
6411    {
6412        String 1 // Description
6413        {
6414            Text [ en-US ] = "Returns the values of the Weibull distribution." ;
6415        };
6416        ExtraData =
6417        {
6418            0;
6419            ID_FUNCTION_GRP_STATISTIC;
6420            U2S( HID_FUNC_WEIBULL );
6421            4;  0;  0;  0;  0;
6422            0;
6423        };
6424        String 2 // Name of Parameter 1
6425        {
6426            Text [ en-US ] = "Number" ;
6427        };
6428        String 3 // Description of Parameter 1
6429        {
6430            Text [ en-US ] = "The value for which the Weibull distribution is to be calculated." ;
6431        };
6432        String 4 // Name of Parameter 2
6433        {
6434            Text [ en-US ] = "Alpha" ;
6435        };
6436        String 5 // Description of Parameter 2
6437        {
6438            Text [ en-US ] = "The Alpha parameter of the Weibull distribution." ;
6439        };
6440        String 6 // Name of Parameter 3
6441        {
6442            Text [ en-US ] = "beta" ;
6443        };
6444        String 7 // Description of Parameter 3
6445        {
6446            Text [ en-US ] = "The Beta parameter of the Weibull distribution." ;
6447        };
6448        String 8 // Name of Parameter 4
6449        {
6450            Text [ en-US ] = "C" ;
6451        };
6452        String 9 // Description of Parameter 4
6453        {
6454            Text [ en-US ] = "Cumulated. C=0 calculates the density function, C=1 the distribution." ;
6455        };
6456    };
6457     // -=*# Resource for function HYPGEOMVERT #*=-
6458    Resource SC_OPCODE_HYP_GEOM_DIST
6459    {
6460        String 1 // Description
6461        {
6462            Text [ en-US ] = "Values of the hypergeometric distribution." ;
6463        };
6464        ExtraData =
6465        {
6466            0;
6467            ID_FUNCTION_GRP_STATISTIC;
6468            U2S( HID_FUNC_HYPGEOMVERT );
6469            4;  0;  0;  0;  0;
6470            0;
6471        };
6472        String 2 // Name of Parameter 1
6473        {
6474            Text [ en-US ] = "X" ;
6475        };
6476        String 3 // Description of Parameter 1
6477        {
6478            Text [ en-US ] = "The number of successes in the sample." ;
6479        };
6480        String 4 // Name of Parameter 2
6481        {
6482            Text [ en-US ] = "n_sample" ;
6483        };
6484        String 5 // Description of Parameter 2
6485        {
6486            Text [ en-US ] = "The size of the sample." ;
6487        };
6488        String 6 // Name of Parameter 3
6489        {
6490            Text [ en-US ] = "successes" ;
6491        };
6492        String 7 // Description of Parameter 3
6493        {
6494            Text [ en-US ] = "The number of successes in the population." ;
6495        };
6496        String 8 // Name of Parameter 4
6497        {
6498            Text [ en-US ] = "n_population" ;
6499        };
6500        String 9 // Description of Parameter 4
6501        {
6502            Text [ en-US ] = "The population size." ;
6503        };
6504    };
6505     // -=*# Resource for function TVERT #*=-
6506    Resource SC_OPCODE_T_DIST
6507    {
6508        String 1 // Description
6509        {
6510            Text [ en-US ] = "Returns the t-distribution." ;
6511        };
6512        ExtraData =
6513        {
6514            0;
6515            ID_FUNCTION_GRP_STATISTIC;
6516            U2S( HID_FUNC_TVERT );
6517            3;  0;  0;  0;
6518            0;
6519        };
6520        String 2 // Name of Parameter 1
6521        {
6522            Text [ en-US ] = "Number" ;
6523        };
6524        String 3 // Description of Parameter 1
6525        {
6526            Text [ en-US ] = "The value for which the T distribution is to be calculated." ;
6527        };
6528        String 4 // Name of Parameter 2
6529        {
6530            Text [ en-US ] = "degrees_freedom" ;
6531        };
6532        String 5 // Description of Parameter 2
6533        {
6534            Text [ en-US ] = "The degrees of freedom of the T distribution." ;
6535        };
6536        String 6 // Name of Parameter 3
6537        {
6538            Text [ en-US ] = "mode" ;
6539        };
6540        String 7 // Description of Parameter 3
6541        {
6542            Text [ en-US ] = "Mode = 1 calculates the one-tailed test, 2 = two-tailed distribution." ;
6543        };
6544    };
6545     // -=*# Resource for function TINV #*=-
6546    Resource SC_OPCODE_T_INV
6547    {
6548        String 1 // Description
6549        {
6550            Text [ en-US ] = "Values of the inverse t-distribution." ;
6551        };
6552        ExtraData =
6553        {
6554            0;
6555            ID_FUNCTION_GRP_STATISTIC;
6556            U2S( HID_FUNC_TINV );
6557            2;  0;  0;
6558            0;
6559        };
6560        String 2 // Name of Parameter 1
6561        {
6562            Text [ en-US ] = "number" ;
6563        };
6564        String 3 // Description of Parameter 1
6565        {
6566            Text [ en-US ] = "The probability value for which the inverse T distribution is to be calculated." ;
6567        };
6568        String 4 // Name of Parameter 2
6569        {
6570            Text [ en-US ] = "degrees_freedom" ;
6571        };
6572        String 5 // Description of Parameter 2
6573        {
6574            Text [ en-US ] = "The degrees of freedom of the T distribution." ;
6575        };
6576    };
6577     // -=*# Resource for function FVERT #*=-
6578    Resource SC_OPCODE_F_DIST
6579    {
6580        String 1 // Description
6581        {
6582            Text [ en-US ] = "Values of the F probability distribution." ;
6583        };
6584        ExtraData =
6585        {
6586            0;
6587            ID_FUNCTION_GRP_STATISTIC;
6588            U2S( HID_FUNC_FVERT );
6589            3;  0;  0;  0;
6590            0;
6591        };
6592        String 2 // Name of Parameter 1
6593        {
6594            Text [ en-US ] = "Number" ;
6595        };
6596        String 3 // Description of Parameter 1
6597        {
6598            Text [ en-US ] = "The value for which the F distribution is to be calculated." ;
6599        };
6600        String 4 // Name of Parameter 2
6601        {
6602            Text [ en-US ] = "degrees_freedom_1" ;
6603        };
6604        String 5 // Description of Parameter 2
6605        {
6606            Text [ en-US ] = "The degrees of freedom in the numerator of the F distribution." ;
6607        };
6608        String 6 // Name of Parameter 3
6609        {
6610            Text [ en-US ] = "degrees_freedom_2" ;
6611        };
6612        String 7 // Description of Parameter 3
6613        {
6614            Text [ en-US ] = "The degrees of freedom in the denominator of the F distribution." ;
6615        };
6616    };
6617     // -=*# Resource for function FINV #*=-
6618    Resource SC_OPCODE_F_INV
6619    {
6620        String 1 // Description
6621        {
6622            Text [ en-US ] = "Values of the inverse F distribution." ;
6623        };
6624        ExtraData =
6625        {
6626            0;
6627            ID_FUNCTION_GRP_STATISTIC;
6628            U2S( HID_FUNC_FINV );
6629            3;  0;  0;  0;
6630            0;
6631        };
6632        String 2 // Name of Parameter 1
6633        {
6634            Text [ en-US ] = "number" ;
6635        };
6636        String 3 // Description of Parameter 1
6637        {
6638            Text [ en-US ] = "The probability value for which the inverse F distribution is to be calculated." ;
6639        };
6640        String 4 // Name of Parameter 2
6641        {
6642            Text [ en-US ] = "degrees_freedom_1" ;
6643        };
6644        String 5 // Description of Parameter 2
6645        {
6646            Text [ en-US ] = "The degrees of freedom in the numerator of the F distribution." ;
6647        };
6648        String 6 // Name of Parameter 3
6649        {
6650            Text [ en-US ] = "degrees_freedom_2" ;
6651        };
6652        String 7 // Description of Parameter 3
6653        {
6654            Text [ en-US ] = "The degrees of freedom in the denominator of the F distribution." ;
6655        };
6656    };
6657     // -=*# Resource for function CHIVERT #*=-
6658    Resource SC_OPCODE_CHI_DIST
6659    {
6660        String 1 // Description
6661        {
6662            Text [ en-US ] = "Returns the right-tail probability of the chi-square distribution." ;
6663        };
6664        ExtraData =
6665        {
6666            0;
6667            ID_FUNCTION_GRP_STATISTIC;
6668            U2S( HID_FUNC_CHIVERT );
6669            2;  0;  0;
6670            0;
6671        };
6672        String 2 // Name of Parameter 1
6673        {
6674            Text [ en-US ] = "Number" ;
6675        };
6676        String 3 // Description of Parameter 1
6677        {
6678            Text [ en-US ] = "The value for which the chi square distribution is to be calculated." ;
6679        };
6680        String 4 // Name of Parameter 2
6681        {
6682            Text [ en-US ] = "degrees_freedom" ;
6683        };
6684        String 5 // Description of Parameter 2
6685        {
6686            Text [ en-US ] = "The degrees of freedom of the chi square distribution." ;
6687        };
6688    };
6689
6690     // -=*# Resource for function CHISQDIST #*=-
6691    Resource SC_OPCODE_CHISQ_DIST
6692    {
6693        String 1 // Description
6694        {
6695            Text [ en-US ] = "Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution." ;
6696        };
6697        ExtraData =
6698        {
6699            0;
6700            ID_FUNCTION_GRP_STATISTIC;
6701            U2S( HID_FUNC_CHISQDIST );
6702            3;  0;  0;  1;
6703            0;
6704        };
6705        String 2 // Name of Parameter 1
6706        {
6707            Text [ en-US ] = "Number" ;
6708        };
6709        String 3 // Description of Parameter 1
6710        {
6711            Text [ en-US ] = "The value for which the probability density function or cumulative distribution function is to be calculated." ;
6712        };
6713        String 4 // Name of Parameter 2
6714        {
6715            Text [ en-US ] = "Degrees of Freedom" ;
6716        };
6717        String 5 // Description of Parameter 2
6718        {
6719            Text [ en-US ] = "The degrees of freedom of the chi-square distribution." ;
6720        };
6721        String 6 // Name of Parameter 3
6722        {
6723            Text [ en-US ] = "Cumulative" ;
6724        };
6725        String 7 // Description of Parameter 3
6726        {
6727            Text [ en-US ] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ;
6728        };
6729    };
6730
6731
6732     // -=*# Resource for function CHIINV #*=-
6733    Resource SC_OPCODE_CHI_INV
6734    {
6735        String 1 // Description
6736        {
6737            Text [ en-US ] = "Values of the inverse of CHIDIST(x; DegreesOfFreedom)." ;
6738        };
6739        ExtraData =
6740        {
6741            0;
6742            ID_FUNCTION_GRP_STATISTIC;
6743            U2S( HID_FUNC_CHIINV );
6744            2;  0;  0;
6745            0;
6746        };
6747        String 2 // Name of Parameter 1
6748        {
6749            Text [ en-US ] = "number" ;
6750        };
6751        String 3 // Description of Parameter 1
6752        {
6753            Text [ en-US ] = "The probability value for which the inverse chi square distribution is to be calculated." ;
6754        };
6755        String 4 // Name of Parameter 2
6756        {
6757            Text [ en-US ] = "degrees_freedom" ;
6758        };
6759        String 5 // Description of Parameter 2
6760        {
6761            Text [ en-US ] = "The degrees of freedom of the chi square distribution." ;
6762        };
6763    };
6764
6765     // -=*# Resource for function CHISQINV #*=-
6766    Resource SC_OPCODE_CHISQ_INV
6767    {
6768        String 1 // Description
6769        {
6770            Text [ en-US ] = "Values of the inverse of CHISQDIST(x;DegreesOfFreedom;TRUE())." ;
6771        };
6772        ExtraData =
6773        {
6774            0;
6775            ID_FUNCTION_GRP_STATISTIC;
6776            U2S( HID_FUNC_CHISQINV );
6777            2;  0;  0;
6778            0;
6779        };
6780        String 2 // Name of Parameter 1
6781        {
6782            Text [ en-US ] = "Probability" ;
6783        };
6784        String 3 // Description of Parameter 1
6785        {
6786            Text [ en-US ] = "The probability value for which the inverse of the chi square distribution is to be calculated." ;
6787        };
6788        String 4 // Name of Parameter 2
6789        {
6790            Text [ en-US ] = "Degrees of Freedom" ;
6791        };
6792        String 5 // Description of Parameter 2
6793        {
6794            Text [ en-US ] = "The degrees of freedom of the chi square distribution." ;
6795        };
6796    };
6797
6798     // -=*# Resource for function STANDARDISIERUNG #*=-
6799    Resource SC_OPCODE_STANDARD
6800    {
6801        String 1 // Description
6802        {
6803            Text [ en-US ] = "Converts a random variable to a normalized value." ;
6804        };
6805        ExtraData =
6806        {
6807            0;
6808            ID_FUNCTION_GRP_STATISTIC;
6809            U2S( HID_FUNC_STANDARDISIERUNG );
6810            3;  0;  0;  0;
6811            0;
6812        };
6813        String 2 // Name of Parameter 1
6814        {
6815            Text [ en-US ] = "Number" ;
6816        };
6817        String 3 // Description of Parameter 1
6818        {
6819            Text [ en-US ] = "The value to be standardized." ;
6820        };
6821        String 4 // Name of Parameter 2
6822        {
6823            Text [ en-US ] = "mean" ;
6824        };
6825        String 5 // Description of Parameter 2
6826        {
6827            Text [ en-US ] = "The mean value used for moving." ;
6828        };
6829        String 6 // Name of Parameter 3
6830        {
6831            Text [ en-US ] = "STDEV" ;
6832        };
6833        String 7 // Description of Parameter 3
6834        {
6835            Text [ en-US ] = "The standard deviation used for scaling." ;
6836        };
6837    };
6838     // -=*# Resource for function VARIATIONEN #*=-
6839    Resource SC_OPCODE_VARIATIONEN
6840    {
6841        String 1 // Description
6842        {
6843            Text [ en-US ] = "Returns the number of permutations for a given number of elements without repetition." ;
6844        };
6845        ExtraData =
6846        {
6847            0;
6848            ID_FUNCTION_GRP_STATISTIC;
6849            U2S( HID_FUNC_VARIATIONEN );
6850            2;  0;  0;
6851            0;
6852        };
6853        String 2 // Name of Parameter 1
6854        {
6855            Text [ en-US ] = "Count_1" ;
6856        };
6857        String 3 // Description of Parameter 1
6858        {
6859            Text [ en-US ] = "The total number of elements." ;
6860        };
6861        String 4 // Name of Parameter 2
6862        {
6863            Text [ en-US ] = "Count_2" ;
6864        };
6865        String 5 // Description of Parameter 2
6866        {
6867            Text [ en-US ] = "The selection number taken from the elements." ;
6868        };
6869    };
6870     // -=*# Resource for function VARIATIONEN2 #*=-
6871    Resource SC_OPCODE_VARIATIONEN_2
6872    {
6873        String 1 // Description
6874        {
6875            Text [ en-US ] = "Returns the number of permutations for a given number of objects (repetition allowed)." ;
6876        };
6877        ExtraData =
6878        {
6879            0;
6880            ID_FUNCTION_GRP_STATISTIC;
6881            U2S( HID_FUNC_VARIATIONEN2 );
6882            2;  0;  0;
6883            0;
6884        };
6885        String 2 // Name of Parameter 1
6886        {
6887            Text [ en-US ] = "Count_1" ;
6888        };
6889        String 3 // Description of Parameter 1
6890        {
6891            Text [ en-US ] = "The total number of elements." ;
6892        };
6893        String 4 // Name of Parameter 2
6894        {
6895            Text [ en-US ] = "Count_2" ;
6896        };
6897        String 5 // Description of Parameter 2
6898        {
6899            Text [ en-US ] = "The selection number taken from the elements." ;
6900        };
6901    };
6902     // -=*# Resource for function KONFIDENZ #*=-
6903    Resource SC_OPCODE_CONFIDENCE
6904    {
6905        String 1 // Description
6906        {
6907            Text [ en-US ] = "Returns a (1 alpha) confidence interval for a normal distribution." ;
6908        };
6909        ExtraData =
6910        {
6911            0;
6912            ID_FUNCTION_GRP_STATISTIC;
6913            U2S( HID_FUNC_KONFIDENZ );
6914            3;  0;  0;  0;
6915            0;
6916        };
6917        String 2 // Name of Parameter 1
6918        {
6919            Text [ en-US ] = "alpha" ;
6920        };
6921        String 3 // Description of Parameter 1
6922        {
6923            Text [ en-US ] = "The level of the confidence interval." ;
6924        };
6925        String 4 // Name of Parameter 2
6926        {
6927            Text [ en-US ] = "STDEV" ;
6928        };
6929        String 5 // Description of Parameter 2
6930        {
6931            Text [ en-US ] = "The standard deviation of the population." ;
6932        };
6933        String 6 // Name of Parameter 3
6934        {
6935            Text [ en-US ] = "size" ;
6936        };
6937        String 7 // Description of Parameter 3
6938        {
6939            Text [ en-US ] = "The size of the population." ;
6940        };
6941    };
6942     // -=*# Resource for function GTEST #*=-
6943    Resource SC_OPCODE_Z_TEST
6944    {
6945        String 1 // Description
6946        {
6947            Text [ en-US ] = "Calculates the probability of observing a z-statistic greater than the one computed based on a sample." ;
6948        };
6949        ExtraData =
6950        {
6951            0;
6952            ID_FUNCTION_GRP_STATISTIC;
6953            U2S( HID_FUNC_GTEST );
6954            3;  0;  0;  1;
6955            0;
6956        };
6957        String 2 // Name of Parameter 1
6958        {
6959            Text [ en-US ] = "data" ;
6960        };
6961        String 3 // Description of Parameter 1
6962        {
6963            Text [ en-US ] = "The given sample, drawn from a normally distributed population." ;
6964        };
6965        String 4 // Name of Parameter 2
6966        {
6967            Text [ en-US ] = "mu" ;
6968        };
6969        String 5 // Description of Parameter 2
6970        {
6971            Text [ en-US ] = "The known mean of the population." ;
6972        };
6973        String 6 // Name of Parameter 3
6974        {
6975            Text [ en-US ] = "sigma" ;
6976        };
6977        String 7 // Description of Parameter 3
6978        {
6979            Text [ en-US ] = "The known standard deviation of the population. If omitted, the standard deviation of the given sample is used." ;
6980        };
6981    };
6982     // -=*# Resource for function CHITEST #*=-
6983    Resource SC_OPCODE_CHI_TEST
6984    {
6985        String 1 // Description
6986        {
6987            Text [ en-US ] = "Returns the chi square independence test." ;
6988        };
6989        ExtraData =
6990        {
6991            0;
6992            ID_FUNCTION_GRP_STATISTIC;
6993            U2S( HID_FUNC_CHITEST );
6994            2;  0;  0;
6995            0;
6996        };
6997        String 2 // Name of Parameter 1
6998        {
6999            Text [ en-US ] = "Data_B" ;
7000        };
7001        String 3 // Description of Parameter 1
7002        {
7003            Text [ en-US ] = "The observed data array." ;
7004        };
7005        String 4 // Name of Parameter 2
7006        {
7007            Text [ en-US ] = "data_E" ;
7008        };
7009        String 5 // Description of Parameter 2
7010        {
7011            Text [ en-US ] = "The expected data array." ;
7012        };
7013    };
7014     // -=*# Resource for function FTEST #*=-
7015    Resource SC_OPCODE_F_TEST
7016    {
7017        String 1 // Description
7018        {
7019            Text [ en-US ] = "Calculates the F test." ;
7020        };
7021        ExtraData =
7022        {
7023            0;
7024            ID_FUNCTION_GRP_STATISTIC;
7025            U2S( HID_FUNC_FTEST );
7026            2;  0;  0;
7027            0;
7028        };
7029        String 2 // Name of Parameter 1
7030        {
7031            Text [ en-US ] = "data_1" ;
7032        };
7033        String 3 // Description of Parameter 1
7034        {
7035            Text [ en-US ] = "The first record array." ;
7036        };
7037        String 4 // Name of Parameter 2
7038        {
7039            Text [ en-US ] = "data_2" ;
7040        };
7041        String 5 // Description of Parameter 2
7042        {
7043            Text [ en-US ] = "The second record array." ;
7044        };
7045    };
7046     // -=*# Resource for function TTEST #*=-
7047    Resource SC_OPCODE_T_TEST
7048    {
7049        String 1 // Description
7050        {
7051            Text [ en-US ] = "Calculates the T test." ;
7052        };
7053        ExtraData =
7054        {
7055            0;
7056            ID_FUNCTION_GRP_STATISTIC;
7057            U2S( HID_FUNC_TTEST );
7058            4;  0;  0;  0;  0;
7059            0;
7060        };
7061        String 2 // Name of Parameter 1
7062        {
7063            Text [ en-US ] = "data_1" ;
7064        };
7065        String 3 // Description of Parameter 1
7066        {
7067            Text [ en-US ] = "The first record array." ;
7068        };
7069        String 4 // Name of Parameter 2
7070        {
7071            Text [ en-US ] = "data_2" ;
7072        };
7073        String 5 // Description of Parameter 2
7074        {
7075            Text [ en-US ] = "The second record array." ;
7076        };
7077        String 6 // Name of Parameter 3
7078        {
7079            Text [ en-US ] = "mode" ;
7080        };
7081        String 7 // Description of Parameter 3
7082        {
7083            Text [ en-US ] = "Mode specifies the number of distribution tails to return. 1= one-tailed, 2 = two-tailed distribution" ;
7084        };
7085        String 8 // Name of Parameter 4
7086        {
7087            Text [ en-US ] = "Type" ;
7088        };
7089        String 9 // Description of Parameter 4
7090        {
7091            Text [ en-US ] = "The type of the T test." ;
7092        };
7093    };
7094     // -=*# Resource for function BESTIMMTHEITSMASS #*=-
7095    Resource SC_OPCODE_RSQ
7096    {
7097        String 1 // Description
7098        {
7099            Text [ en-US ] = "Returns the square of the Pearson product moment correlation coefficient." ;
7100        };
7101        ExtraData =
7102        {
7103            0;
7104            ID_FUNCTION_GRP_STATISTIC;
7105            U2S( HID_FUNC_BESTIMMTHEITSMASS );
7106            2;  0;  0;
7107            0;
7108        };
7109        String 2 // Name of Parameter 1
7110        {
7111            Text [ en-US ] = "data_Y" ;
7112        };
7113        String 3 // Description of Parameter 1
7114        {
7115            Text [ en-US ] = "The Y data array." ;
7116        };
7117        String 4 // Name of Parameter 2
7118        {
7119            Text [ en-US ] = "data_X" ;
7120        };
7121        String 5 // Description of Parameter 2
7122        {
7123            Text [ en-US ] = "The X data array." ;
7124        };
7125    };
7126     // -=*# Resource for function ACHSENABSCHNITT #*=-
7127    Resource SC_OPCODE_INTERCEPT
7128    {
7129        String 1 // Description
7130        {
7131            Text [ en-US ] = "Returns the intercept of the linear regression line and the Y axis." ;
7132        };
7133        ExtraData =
7134        {
7135            0;
7136            ID_FUNCTION_GRP_STATISTIC;
7137            U2S( HID_FUNC_ACHSENABSCHNITT );
7138            2;  0;  0;
7139            0;
7140        };
7141        String 2 // Name of Parameter 1
7142        {
7143            Text [ en-US ] = "data_Y" ;
7144        };
7145        String 3 // Description of Parameter 1
7146        {
7147            Text [ en-US ] = "The Y data array." ;
7148        };
7149        String 4 // Name of Parameter 2
7150        {
7151            Text [ en-US ] = "data_X" ;
7152        };
7153        String 5 // Description of Parameter 2
7154        {
7155            Text [ en-US ] = "The X data array." ;
7156        };
7157    };
7158     // -=*# Resource for function STEIGUNG #*=-
7159    Resource SC_OPCODE_SLOPE
7160    {
7161        String 1 // Description
7162        {
7163            Text [ en-US ] = "Returns the slope of the linear regression line." ;
7164        };
7165        ExtraData =
7166        {
7167            0;
7168            ID_FUNCTION_GRP_STATISTIC;
7169            U2S( HID_FUNC_STEIGUNG );
7170            2;  0;  0;
7171            0;
7172        };
7173        String 2 // Name of Parameter 1
7174        {
7175            Text [ en-US ] = "data_Y" ;
7176        };
7177        String 3 // Description of Parameter 1
7178        {
7179            Text [ en-US ] = "The Y data array." ;
7180        };
7181        String 4 // Name of Parameter 2
7182        {
7183            Text [ en-US ] = "data_X" ;
7184        };
7185        String 5 // Description of Parameter 2
7186        {
7187            Text [ en-US ] = "The X data array." ;
7188        };
7189    };
7190     // -=*# Resource for function STFEHLERYX #*=-
7191    Resource SC_OPCODE_STEYX
7192    {
7193        String 1 // Description
7194        {
7195            Text [ en-US ] = "Returns the standard error of the linear regression." ;
7196        };
7197        ExtraData =
7198        {
7199            0;
7200            ID_FUNCTION_GRP_STATISTIC;
7201            U2S( HID_FUNC_STFEHLERYX );
7202            2;  0;  0;
7203            0;
7204        };
7205        String 2 // Name of Parameter 1
7206        {
7207            Text [ en-US ] = "data_Y" ;
7208        };
7209        String 3 // Description of Parameter 1
7210        {
7211            Text [ en-US ] = "The Y data array." ;
7212        };
7213        String 4 // Name of Parameter 2
7214        {
7215            Text [ en-US ] = "data_X" ;
7216        };
7217        String 5 // Description of Parameter 2
7218        {
7219            Text [ en-US ] = "The X data array." ;
7220        };
7221    };
7222     // -=*# Resource for function PEARSON #*=-
7223    Resource SC_OPCODE_PEARSON
7224    {
7225        String 1 // Description
7226        {
7227            Text [ en-US ] = "Returns the Pearson product moment correlation coefficient." ;
7228        };
7229        ExtraData =
7230        {
7231            0;
7232            ID_FUNCTION_GRP_STATISTIC;
7233            U2S( HID_FUNC_PEARSON );
7234            2;  0;  0;
7235            0;
7236        };
7237        String 2 // Name of Parameter 1
7238        {
7239            Text [ en-US ] = "Data_1" ;
7240        };
7241        String 3 // Description of Parameter 1
7242        {
7243            Text [ en-US ] = "The first record array." ;
7244        };
7245        String 4 // Name of Parameter 2
7246        {
7247            Text [ en-US ] = "Data_2" ;
7248        };
7249        String 5 // Description of Parameter 2
7250        {
7251            Text [ en-US ] = "The second record array." ;
7252        };
7253    };
7254     // -=*# Resource for function KORREL #*=-
7255    Resource SC_OPCODE_CORREL
7256    {
7257        String 1 // Description
7258        {
7259            Text [ en-US ] = "Returns the correlation coefficient." ;
7260        };
7261        ExtraData =
7262        {
7263            0;
7264            ID_FUNCTION_GRP_STATISTIC;
7265            U2S( HID_FUNC_KORREL );
7266            2;  0;  0;
7267            0;
7268        };
7269        String 2 // Name of Parameter 1
7270        {
7271            Text [ en-US ] = "Data_1" ;
7272        };
7273        String 3 // Description of Parameter 1
7274        {
7275            Text [ en-US ] = "The first record array." ;
7276        };
7277        String 4 // Name of Parameter 2
7278        {
7279            Text [ en-US ] = "Data_2" ;
7280        };
7281        String 5 // Description of Parameter 2
7282        {
7283            Text [ en-US ] = "The second record array." ;
7284        };
7285    };
7286     // -=*# Resource for function KOVAR #*=-
7287    Resource SC_OPCODE_COVAR
7288    {
7289        String 1 // Description
7290        {
7291            Text [ en-US ] = "Calculates the covariance." ;
7292        };
7293        ExtraData =
7294        {
7295            0;
7296            ID_FUNCTION_GRP_STATISTIC;
7297            U2S( HID_FUNC_KOVAR );
7298            2;  0;  0;
7299            0;
7300        };
7301        String 2 // Name of Parameter 1
7302        {
7303            Text [ en-US ] = "Data_1" ;
7304        };
7305        String 3 // Description of Parameter 1
7306        {
7307            Text [ en-US ] = "The first record array." ;
7308        };
7309        String 4 // Name of Parameter 2
7310        {
7311            Text [ en-US ] = "Data_2" ;
7312        };
7313        String 5 // Description of Parameter 2
7314        {
7315            Text [ en-US ] = "The second record array." ;
7316        };
7317    };
7318     // -=*# Resource for function SCHÄTZER #*=-
7319    Resource SC_OPCODE_FORECAST
7320    {
7321        String 1 // Description
7322        {
7323            Text [ en-US ] = "Returns a value along a linear regression" ;
7324        };
7325        ExtraData =
7326        {
7327            0;
7328            ID_FUNCTION_GRP_STATISTIC;
7329            U2S( HID_FUNC_SCHAETZER );
7330            3;  0;  0;  0;
7331            0;
7332        };
7333        String 2 // Name of Parameter 1
7334        {
7335            Text [ en-US ] = "value" ;
7336        };
7337        String 3 // Description of Parameter 1
7338        {
7339            Text [ en-US ] = "The X value for which the Y value on the regression linear is to be calculated." ;
7340        };
7341        String 4 // Name of Parameter 2
7342        {
7343            Text [ en-US ] = "data_Y" ;
7344        };
7345        String 5 // Description of Parameter 2
7346        {
7347            Text [ en-US ] = "The Y data array." ;
7348        };
7349        String 6 // Name of Parameter 3
7350        {
7351            Text [ en-US ] = "data_X" ;
7352        };
7353        String 7 // Description of Parameter 3
7354        {
7355            Text [ en-US ] = "The X data array." ;
7356        };
7357    };
7358     // -=*# Resource for function ADRESSE #*=-
7359    Resource SC_OPCODE_ADDRESS
7360    {
7361        String 1 // Description
7362        {
7363            Text [ en-US ] = "Returns the reference to a cell as text." ;
7364        };
7365        ExtraData =
7366        {
7367            0;
7368            ID_FUNCTION_GRP_TABLE;
7369            U2S( HID_FUNC_ADRESSE );
7370            5;  0;  0;  1;  1;  1;
7371            0;
7372        };
7373        String 2 // Name of Parameter 1
7374        {
7375            Text [ en-US ] = "row" ;
7376        };
7377        String 3 // Description of Parameter 1
7378        {
7379            Text [ en-US ] = "The row number of the cell." ;
7380        };
7381        String 4 // Name of Parameter 2
7382        {
7383            Text [ en-US ] = "column" ;
7384        };
7385        String 5 // Description of Parameter 2
7386        {
7387            Text [ en-US ] = "The column number of the cell." ;
7388        };
7389        String 6 // Name of Parameter 3
7390        {
7391            Text [ en-US ] = "ABS" ;
7392        };
7393        String 7 // Description of Parameter 3
7394        {
7395            Text [ en-US ] = "Specifies whether absolute or relative referencing is to be used." ;
7396        };
7397        String 8 // Name of Parameter 4
7398        {
7399            Text [ en-US ] = "A1" ;
7400        };
7401        String 9 // Description of Parameter 4
7402        {
7403            Text [ en-US ] = "The reference style: 0 or FALSE means R1C1 style, any other value or omitted means A1 style." ;
7404        };
7405        String 10 // Name of Parameter 5
7406        {
7407            Text [ en-US ] = "sheet" ;
7408            Text [ x-comment ] = "previously to OOo3.0 this was String resource RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_ADDRESS 8" ;
7409        };
7410        String 11 // Description of Parameter 5
7411        {
7412            Text [ en-US ] = "The spreadsheet name of the cell reference." ;
7413            Text [ x-comment ] = "previously to OOo3.0 this was String resource RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_ADDRESS 9" ;
7414        };
7415    };
7416     // -=*# Resource for function BEREICHE #*=-
7417    Resource SC_OPCODE_AREAS
7418    {
7419        String 1 // Description
7420        {
7421            Text [ en-US ] = "Returns the number of individual ranges that belong to a (multiple) range." ;
7422        };
7423        ExtraData =
7424        {
7425            0;
7426            ID_FUNCTION_GRP_TABLE;
7427            U2S( HID_FUNC_BEREICHE );
7428            1;  0;
7429            0;
7430        };
7431        String 2 // Name of Parameter 1
7432        {
7433            Text [ en-US ] = "reference" ;
7434        };
7435        String 3 // Description of Parameter 1
7436        {
7437            Text [ en-US ] = "The reference to a (multiple) range." ;
7438        };
7439    };
7440     // -=*# Resource for function WAHL #*=-
7441    Resource SC_OPCODE_CHOSE
7442    {
7443        String 1 // Description
7444        {
7445            Text [ en-US ] = "Selects a value from a list of up to 30 value arguments." ;
7446        };
7447        ExtraData =
7448        {
7449            0;
7450            ID_FUNCTION_GRP_TABLE;
7451            U2S( HID_FUNC_WAHL );
7452            VAR_ARGS+1; 0;  0;
7453            0;
7454        };
7455        String 2 // Name of Parameter 1
7456        {
7457            Text [ en-US ] = "Index" ;
7458        };
7459        String 3 // Description of Parameter 1
7460        {
7461            Text [ en-US ] = "The index of the value (1..30) selected." ;
7462        };
7463        String 4 // Name of Parameter 2
7464        {
7465            Text [ en-US ] = "value " ;
7466        };
7467        String 5 // Description of Parameter 2
7468        {
7469            Text [ en-US ] = "Value 1, value 2,... The list of arguments from which a value is chosen." ;
7470        };
7471    };
7472     // -=*# Resource for function SPALTE #*=-
7473    Resource SC_OPCODE_COLUMN
7474    {
7475        String 1 // Description
7476        {
7477            Text [ en-US ] = "Returns the internal column number of a reference." ;
7478        };
7479        ExtraData =
7480        {
7481            0;
7482            ID_FUNCTION_GRP_TABLE;
7483            U2S( HID_FUNC_SPALTE );
7484            1;  1;
7485            0;
7486        };
7487        String 2 // Name of Parameter 1
7488        {
7489            Text [ en-US ] = "reference" ;
7490        };
7491        String 3 // Description of Parameter 1
7492        {
7493            Text [ en-US ] = "The reference to a cell or a range." ;
7494        };
7495    };
7496     // -=*# Resource for function ZEILE #*=-
7497    Resource SC_OPCODE_ROW
7498    {
7499        String 1 // Description
7500        {
7501            Text [ en-US ] = "Defines the internal row number of a reference." ;
7502        };
7503        ExtraData =
7504        {
7505            0;
7506            ID_FUNCTION_GRP_TABLE;
7507            U2S( HID_FUNC_ZEILE );
7508            1;  1;
7509            0;
7510        };
7511        String 2 // Name of Parameter 1
7512        {
7513            Text [ en-US ] = "reference" ;
7514        };
7515        String 3 // Description of Parameter 1
7516        {
7517            Text [ en-US ] = "The reference to a cell or a range." ;
7518        };
7519    };
7520     // -=*# Resource for function TABELLE #*=-
7521    Resource SC_OPCODE_TABLE
7522    {
7523        String 1 // Description
7524        {
7525            Text [ en-US ] = "Returns the internal sheet number of a reference or a string." ;
7526        };
7527        ExtraData =
7528        {
7529            0;
7530            ID_FUNCTION_GRP_TABLE;
7531            U2S( HID_FUNC_TABELLE );
7532            1;  1;
7533            0;
7534        };
7535        String 2 // Name of Parameter 1
7536        {
7537            Text [ en-US ] = "reference" ;
7538        };
7539        String 3 // Description of Parameter 1
7540        {
7541            Text [ en-US ] = "The reference to a cell or a range or the character string of a sheet name." ;
7542        };
7543    };
7544     // -=*# Resource for function SPALTEN #*=-
7545    Resource SC_OPCODE_COLUMNS
7546    {
7547        String 1 // Description
7548        {
7549            Text [ en-US ] = "Returns the number of columns in an array or reference." ;
7550        };
7551        ExtraData =
7552        {
7553            0;
7554            ID_FUNCTION_GRP_TABLE;
7555            U2S( HID_FUNC_SPALTEN );
7556            1;  0;
7557            0;
7558        };
7559        String 2 // Name of Parameter 1
7560        {
7561            Text [ en-US ] = "array" ;
7562        };
7563        String 3 // Description of Parameter 1
7564        {
7565            Text [ en-US ] = "The array (reference) for which the number of columns is to be determined." ;
7566        };
7567    };
7568     // -=*# Resource for function ZEILEN #*=-
7569    Resource SC_OPCODE_ROWS
7570    {
7571        String 1 // Description
7572        {
7573            Text [ en-US ] = "Returns the number of rows in a reference or array." ;
7574        };
7575        ExtraData =
7576        {
7577            0;
7578            ID_FUNCTION_GRP_TABLE;
7579            U2S( HID_FUNC_ZEILEN );
7580            1;  0;
7581            0;
7582        };
7583        String 2 // Name of Parameter 1
7584        {
7585            Text [ en-US ] = "array" ;
7586        };
7587        String 3 // Description of Parameter 1
7588        {
7589            Text [ en-US ] = "The array (reference) for which the number of rows is to be determined." ;
7590        };
7591    };
7592     // -=*# Resource for function TABELLEN #*=-
7593    Resource SC_OPCODE_TABLES
7594    {
7595        String 1 // Description
7596        {
7597            Text [ en-US ] = "Returns the number of sheets of a given reference. If no parameter has been entered, the total number of sheets in the document is returned." ;
7598        };
7599        ExtraData =
7600        {
7601            0;
7602            ID_FUNCTION_GRP_TABLE;
7603            U2S( HID_FUNC_TABELLEN );
7604            1;  1;
7605            0;
7606        };
7607        String 2 // Name of Parameter 1
7608        {
7609            Text [ en-US ] = "reference" ;
7610        };
7611        String 3 // Description of Parameter 1
7612        {
7613            Text [ en-US ] = "The reference to a cell or a range." ;
7614        };
7615    };
7616     // -=*# Resource for function WVERWEIS #*=-
7617    Resource SC_OPCODE_H_LOOKUP
7618    {
7619        String 1 // Description
7620        {
7621            Text [ en-US ] = "Horizontal search and reference to the cells located below." ;
7622        };
7623        ExtraData =
7624        {
7625            0;
7626            ID_FUNCTION_GRP_TABLE;
7627            U2S( HID_FUNC_WVERWEIS );
7628            4;  0;  0;  0;  1;
7629            0;
7630        };
7631        String 2 // Name of Parameter 1
7632        {
7633            Text [ en-US ] = "search_criteria" ;
7634        };
7635        String 3 // Description of Parameter 1
7636        {
7637            Text [ en-US ] = "The value to be found in the first row." ;
7638        };
7639        String 4 // Name of Parameter 2
7640        {
7641            Text [ en-US ] = "array" ;
7642        };
7643        String 5 // Description of Parameter 2
7644        {
7645            Text [ en-US ] = "The array or the range for the reference." ;
7646        };
7647        String 6 // Name of Parameter 3
7648        {
7649            Text [ en-US ] = "Index" ;
7650        };
7651        String 7 // Description of Parameter 3
7652        {
7653            Text [ en-US ] = "The row index in the array." ;
7654        };
7655        String 8 // Name of Parameter 4
7656        {
7657            Text [ en-US ] = "sorted" ;
7658        };
7659        String 9 // Description of Parameter 4
7660        {
7661            Text [ en-US ] = "If the value is TRUE or not given, the search row of the array must be sorted in ascending order." ;
7662        };
7663    };
7664     // -=*# Resource for function SVERWEIS #*=-
7665    Resource SC_OPCODE_V_LOOKUP
7666    {
7667        String 1 // Description
7668        {
7669            Text [ en-US ] = "Vertical search and reference to indicated cells." ;
7670        };
7671        ExtraData =
7672        {
7673            0;
7674            ID_FUNCTION_GRP_TABLE;
7675            U2S( HID_FUNC_SVERWEIS );
7676            4;  0;  0;  0;  1;
7677            0;
7678        };
7679        String 2 // Name of Parameter 1
7680        {
7681            Text [ en-US ] = "Search criterion" ;
7682        };
7683        String 3 // Description of Parameter 1
7684        {
7685            Text [ en-US ] = "The value to be found in the first column." ;
7686        };
7687        String 4 // Name of Parameter 2
7688        {
7689            Text [ en-US ] = "array" ;
7690        };
7691        String 5 // Description of Parameter 2
7692        {
7693            Text [ en-US ] = "The array or range for referencing." ;
7694        };
7695        String 6 // Name of Parameter 3
7696        {
7697            Text [ en-US ] = "Index" ;
7698        };
7699        String 7 // Description of Parameter 3
7700        {
7701            Text [ en-US ] = "Column index number in the array." ;
7702        };
7703        String 8 // Name of Parameter 4
7704        {
7705            Text [ en-US ] = "sort order" ;
7706        };
7707        String 9 // Description of Parameter 4
7708        {
7709            Text [ en-US ] = "If the value is TRUE or not given, the search column of the array must be sorted in ascending order." ;
7710        };
7711    };
7712     // -=*# Resource for function INDEX #*=-
7713    Resource SC_OPCODE_INDEX
7714    {
7715        String 1 // Description
7716        {
7717            Text [ en-US ] = "Returns a reference to a cell from a defined range." ;
7718        };
7719        ExtraData =
7720        {
7721            0;
7722            ID_FUNCTION_GRP_TABLE;
7723            U2S( HID_FUNC_INDEX );
7724            4;  0;  1;  1;  1;
7725            0;
7726        };
7727        String 2 // Name of Parameter 1
7728        {
7729            Text [ en-US ] = "reference" ;
7730        };
7731        String 3 // Description of Parameter 1
7732        {
7733            Text [ en-US ] = "The reference to a (multiple) range." ;
7734        };
7735        String 4 // Name of Parameter 2
7736        {
7737            Text [ en-US ] = "row" ;
7738        };
7739        String 5 // Description of Parameter 2
7740        {
7741            Text [ en-US ] = "The row in the range." ;
7742        };
7743        String 6 // Name of Parameter 3
7744        {
7745            Text [ en-US ] = "column" ;
7746        };
7747        String 7 // Description of Parameter 3
7748        {
7749            Text [ en-US ] = "The column in the range." ;
7750        };
7751        String 8 // Name of Parameter 4
7752        {
7753            Text [ en-US ] = "range" ;
7754        };
7755        String 9 // Description of Parameter 4
7756        {
7757            Text [ en-US ] = "The index of the subrange if referring to a multiple range." ;
7758        };
7759    };
7760     // -=*# Resource for function INDIREKT #*=-
7761    Resource SC_OPCODE_INDIRECT
7762    {
7763        String 1 // Description
7764        {
7765            Text [ en-US ] = "Returns the contents of a cell that is referenced in text form." ;
7766        };
7767        ExtraData =
7768        {
7769            0;
7770            ID_FUNCTION_GRP_TABLE;
7771            U2S( HID_FUNC_INDIREKT );
7772            2;  0;  1;
7773            0;
7774        };
7775        String 2 // Name of Parameter 1
7776        {
7777            Text [ en-US ] = "ref " ;
7778        };
7779        String 3 // Description of Parameter 1
7780        {
7781            Text [ en-US ] = "The cell whose contents are to be evaluated is to be referenced in text form (e.g. \"A1\")." ;
7782        };
7783        String 4 // Name of Parameter 2
7784        {
7785            Text [ en-US ] = "A1" ;
7786        };
7787        String 5 // Description of Parameter 2
7788        {
7789            Text [ en-US ] = "The reference style: 0 or FALSE means R1C1 style, any other value or omitted means A1 style." ;
7790        };
7791    };
7792     // -=*# Resource for function VERWEIS #*=-
7793    Resource SC_OPCODE_LOOKUP
7794    {
7795        String 1 // Description
7796        {
7797            Text [ en-US ] = "Determines a value in a vector by comparison to values in another vector." ;
7798        };
7799        ExtraData =
7800        {
7801            0;
7802            ID_FUNCTION_GRP_TABLE;
7803            U2S( HID_FUNC_VERWEIS );
7804            3;  0;  0;  1;
7805            0;
7806        };
7807        String 2 // Name of Parameter 1
7808        {
7809            Text [ en-US ] = "Search criterion" ;
7810        };
7811        String 3 // Description of Parameter 1
7812        {
7813            Text [ en-US ] = "The value to be used for comparison." ;
7814        };
7815        String 4 // Name of Parameter 2
7816        {
7817            Text [ en-US ] = "Search vector" ;
7818        };
7819        String 5 // Description of Parameter 2
7820        {
7821            Text [ en-US ] = "The vector (row or column) in which to search." ;
7822        };
7823        String 6 // Name of Parameter 3
7824        {
7825            Text [ en-US ] = "result_vector" ;
7826        };
7827        String 7 // Description of Parameter 3
7828        {
7829            Text [ en-US ] = "The vector (row or range) from which the value is to be determined." ;
7830        };
7831    };
7832     // -=*# Resource for function VERGLEICH #*=-
7833    Resource SC_OPCODE_MATCH
7834    {
7835        String 1 // Description
7836        {
7837            Text [ en-US ] = "Defines a position in a array after comparing values." ;
7838        };
7839        ExtraData =
7840        {
7841            0;
7842            ID_FUNCTION_GRP_TABLE;
7843            U2S( HID_FUNC_VERGLEICH );
7844            3;  0;  0;  1;
7845            0;
7846        };
7847        String 2 // Name of Parameter 1
7848        {
7849            Text [ en-US ] = "Search criterion" ;
7850        };
7851        String 3 // Description of Parameter 1
7852        {
7853            Text [ en-US ] = "The value to be used for comparison." ;
7854        };
7855        String 4 // Name of Parameter 2
7856        {
7857            Text [ en-US ] = "lookup_array" ;
7858        };
7859        String 5 // Description of Parameter 2
7860        {
7861            Text [ en-US ] = "The array (range) in which the search is made." ;
7862        };
7863        String 6 // Name of Parameter 3
7864        {
7865            Text [ en-US ] = "Type" ;
7866        };
7867        String 7 // Description of Parameter 3
7868        {
7869            Text [ en-US ] = "Type can take the value 1, 0 or -1 and determines the criteria are to be used for comparison purposes." ;
7870        };
7871    };
7872     // -=*# Resource for function VERSCHIEBUNG #*=-
7873    Resource SC_OPCODE_OFFSET
7874    {
7875        String 1 // Description
7876        {
7877            Text [ en-US ] = "Returns a reference which has been moved in relation to the starting point." ;
7878        };
7879        ExtraData =
7880        {
7881            0;
7882            ID_FUNCTION_GRP_TABLE;
7883            U2S( HID_FUNC_VERSCHIEBUNG );
7884            5;  0;  0;  0;  1;  1;
7885            0;
7886        };
7887        String 2 // Name of Parameter 1
7888        {
7889            Text [ en-US ] = "reference" ;
7890        };
7891        String 3 // Description of Parameter 1
7892        {
7893            Text [ en-US ] = "The reference (cell) from which to base the movement." ;
7894        };
7895        String 4 // Name of Parameter 2
7896        {
7897            Text [ en-US ] = "rows" ;
7898        };
7899        String 5 // Description of Parameter 2
7900        {
7901            Text [ en-US ] = "The number of rows to be moved either up or down." ;
7902        };
7903        String 6 // Name of Parameter 3
7904        {
7905            Text [ en-US ] = "columns" ;
7906        };
7907        String 7 // Description of Parameter 3
7908        {
7909            Text [ en-US ] = "The number of columns that are to be moved to the left or to the right." ;
7910        };
7911        String 8 // Name of Parameter 4
7912        {
7913            Text [ en-US ] = "height" ;
7914        };
7915        String 9 // Description of Parameter 4
7916        {
7917            Text [ en-US ] = "The number of rows of the moved reference." ;
7918        };
7919        String 10 // Name of Parameter 5
7920        {
7921            Text [ en-US ] = "width" ;
7922        };
7923        String 11 // Description of Parameter 5
7924        {
7925            Text [ en-US ] = "The number of columns in the moved reference." ;
7926        };
7927    };
7928     // -=*# Resource for function FEHLERTYP #*=-
7929    Resource SC_OPCODE_ERROR_TYPE
7930    {
7931        String 1 // Description
7932        {
7933            Text [ en-US ] = "Returns a number corresponding to an error type" ;
7934        };
7935        ExtraData =
7936        {
7937            0;
7938            ID_FUNCTION_GRP_TABLE;
7939            U2S( HID_FUNC_FEHLERTYP );
7940            1;  0;
7941            0;
7942        };
7943        String 2 // Name of Parameter 1
7944        {
7945            Text [ en-US ] = "reference" ;
7946        };
7947        String 3 // Description of Parameter 1
7948        {
7949            Text [ en-US ] = "The reference (cell) in which the error occurred." ;
7950        };
7951    };
7952     // -=*# Resource for function VORLAGE #*=-
7953    Resource SC_OPCODE_STYLE
7954    {
7955        String 1 // Description
7956        {
7957            Text [ en-US ] = "Applies a Style to the formula cell." ;
7958        };
7959        ExtraData =
7960        {
7961            0;
7962            ID_FUNCTION_GRP_TABLE;
7963            U2S( HID_FUNC_VORLAGE );
7964            3;  0;  1;  1;
7965            0;
7966        };
7967        String 2 // Name of Parameter 1
7968        {
7969            Text [ en-US ] = "Style" ;
7970        };
7971        String 3 // Description of Parameter 1
7972        {
7973            Text [ en-US ] = "The name of the Style to be applied." ;
7974        };
7975        String 4 // Name of Parameter 2
7976        {
7977            Text [ en-US ] = "Time" ;
7978        };
7979        String 5 // Description of Parameter 2
7980        {
7981            Text [ en-US ] = "The time (in seconds) that the Style is to remain valid." ;
7982        };
7983        String 6 // Name of Parameter 3
7984        {
7985            Text [ en-US ] = "Style2" ;
7986        };
7987        String 7 // Description of Parameter 3
7988        {
7989            Text [ en-US ] = "The Style to be applied after time expires." ;
7990        };
7991    };
7992     // -=*# Resource for function DDE #*=-
7993    Resource SC_OPCODE_DDE
7994    {
7995        String 1 // Description
7996        {
7997            Text [ en-US ] = "Result of a DDE link." ;
7998        };
7999        ExtraData =
8000        {
8001            0;
8002            ID_FUNCTION_GRP_TABLE;
8003            U2S( HID_FUNC_DDE );
8004            4;  0;  0;  0;  1;
8005            0;
8006        };
8007        String 2 // Name of Parameter 1
8008        {
8009            Text [ en-US ] = "server" ;
8010        };
8011        String 3 // Description of Parameter 1
8012        {
8013            Text [ en-US ] = "The name of the server application." ;
8014        };
8015        String 4 // Name of Parameter 2
8016        {
8017            Text [ en-US ] = "File" ;
8018        };
8019        String 5 // Description of Parameter 2
8020        {
8021            Text [ en-US ] = "The name of the file." ;
8022        };
8023        String 6 // Name of Parameter 3
8024        {
8025            Text [ en-US ] = "range" ;
8026        };
8027        String 7 // Description of Parameter 3
8028        {
8029            Text [ en-US ] = "The range from which data is to be taken." ;
8030        };
8031        String 8 // Name of Parameter 4
8032        {
8033            Text [ en-US ] = "mode" ;
8034        };
8035        String 9 // Description of Parameter 4
8036        {
8037            Text [ en-US ] = "Defines how data is to be converted to numbers." ;
8038        };
8039    };
8040     // -=*# Resource for function HYPERLINK #*=-
8041    Resource SC_OPCODE_HYPERLINK
8042    {
8043        String 1 // Description
8044        {
8045            Text [ en-US ] = "Hyperlink." ;
8046        };
8047        ExtraData =
8048        {
8049            0;
8050            ID_FUNCTION_GRP_TABLE;
8051            U2S( HID_FUNC_HYPERLINK );
8052            2;  0;  1;
8053            0;
8054        };
8055        String 2 // Name of Parameter 1
8056        {
8057            Text [ en-US ] = "URL " ;
8058        };
8059        String 3 // Description of Parameter 1
8060        {
8061            Text [ en-US ] = "URL";
8062        };
8063        String 4 // Name of Parameter 2
8064        {
8065            Text [ en-US ] = "CellText " ;
8066        };
8067        String 5 // Description of Parameter 2
8068        {
8069            Text [ en-US ] = "Cell Text";
8070        };
8071    };
8072     // -=*# Resource for function GETPIVOTDATA #*=-
8073    Resource SC_OPCODE_GET_PIVOT_DATA
8074    {
8075        String 1 // Description
8076        {
8077            Text [ en-US ] = "Extracts value(s) from a pivot table.";
8078        };
8079        ExtraData =
8080        {
8081            0;
8082            ID_FUNCTION_GRP_TABLE;
8083            U2S( HID_FUNC_GETPIVOTDATA );
8084            VAR_ARGS+2;      0; 0;  1;
8085            0;
8086        };
8087        String 2 // Name of Parameter 1
8088        {
8089            Text [ en-US ] = "Data Field";
8090        };
8091        String 3 // Description of Parameter 1
8092        {
8093            Text [ en-US ] = "The name of the pivot table field to extract.";
8094        };
8095        String 4 // Name of Parameter 2
8096        {
8097            Text [ en-US ] = "Pivot Table";
8098        };
8099        String 5 // Description of Parameter 2
8100        {
8101            Text [ en-US ] = "A reference to a cell or range in the pivot table.";
8102        };
8103        String 6 // Name of Parameter 3
8104        {
8105            Text [ en-US ] = "Field Name / Item";
8106        };
8107        String 7 // Description of Parameter 3
8108        {
8109            Text [ en-US ] = "Field name/value pair to filter the target data.";
8110        };
8111    };
8112     // -=*# Resource for function BAHTTEXT #*=-
8113    Resource SC_OPCODE_BAHTTEXT
8114    {
8115        String 1 // Description
8116        {
8117            Text [ en-US ] = "Converts a number to text (Baht)." ;
8118        };
8119        ExtraData =
8120        {
8121            0;
8122            ID_FUNCTION_GRP_TEXT;
8123            U2S( HID_FUNC_BAHTTEXT );
8124            1;  0;
8125            0;
8126        };
8127        String 2 // Name of Parameter 1
8128        {
8129            Text [ en-US ] = "Number" ;
8130        };
8131        String 3 // Description of Parameter 1
8132        {
8133            Text [ en-US ] = "The number to convert.";
8134        };
8135    };
8136     // -=*# Resource for function JIS #*=-
8137    Resource SC_OPCODE_JIS
8138    {
8139        String 1 // Description
8140        {
8141            Text [ en-US ] = "Converts half-width ASCII and katakana characters to full-width." ;
8142        };
8143        ExtraData =
8144        {
8145            0;
8146            ID_FUNCTION_GRP_TEXT;
8147            U2S( HID_FUNC_JIS );
8148            1;  0;
8149            0;
8150        };
8151        String 2 // Name of Parameter 1
8152        {
8153            Text [ en-US ] = "text" ;
8154        };
8155        String 3 // Description of Parameter 1
8156        {
8157            Text [ en-US ] = "The text to convert.";
8158        };
8159    };
8160     // -=*# Resource for function ASC #*=-
8161    Resource SC_OPCODE_ASC
8162    {
8163        String 1 // Description
8164        {
8165            Text [ en-US ] = "Converts full-width ASCII and katakana characters to half-width." ;
8166        };
8167        ExtraData =
8168        {
8169            0;
8170            ID_FUNCTION_GRP_TEXT;
8171            U2S( HID_FUNC_ASC );
8172            1;  0;
8173            0;
8174        };
8175        String 2 // Name of Parameter 1
8176        {
8177            Text [ en-US ] = "text" ;
8178        };
8179        String 3 // Description of Parameter 1
8180        {
8181            Text [ en-US ] = "The text to convert.";
8182        };
8183    };
8184     // -=*# Resource for function CODE #*=-
8185    Resource SC_OPCODE_CODE
8186    {
8187        String 1 // Description
8188        {
8189            Text [ en-US ] = "Returns a numeric code for the first character in a text string." ;
8190        };
8191        ExtraData =
8192        {
8193            0;
8194            ID_FUNCTION_GRP_TEXT;
8195            U2S( HID_FUNC_CODE );
8196            1;  0;
8197            0;
8198        };
8199        String 2 // Name of Parameter 1
8200        {
8201            Text [ en-US ] = "text" ;
8202        };
8203        String 3 // Description of Parameter 1
8204        {
8205            Text [ en-US ] = "This is the text for which the code of the first character is to be found." ;
8206        };
8207    };
8208     // -=*# Resource for function DM #*=-
8209    Resource SC_OPCODE_CURRENCY
8210    {
8211        String 1 // Description
8212        {
8213            Text [ en-US ] = "Converts a number to text in currency format." ;
8214        };
8215        ExtraData =
8216        {
8217            0;
8218            ID_FUNCTION_GRP_TEXT;
8219            U2S( HID_FUNC_DM );
8220            2;  0;  1;
8221            0;
8222        };
8223        String 2 // Name of Parameter 1
8224        {
8225            Text [ en-US ] = "value" ;
8226        };
8227        String 3 // Description of Parameter 1
8228        {
8229            Text [ en-US ] = "Value is a number, a reference to a cell containing a number or a formula that results in a number." ;
8230        };
8231        String 4 // Name of Parameter 2
8232        {
8233            Text [ en-US ] = "decimals" ;
8234        };
8235        String 5 // Description of Parameter 2
8236        {
8237            Text [ en-US ] = "Decimal places. Denotes the number of digits to the right of the decimal point." ;
8238        };
8239    };
8240     // -=*# Resource for function ZEICHEN #*=-
8241    Resource SC_OPCODE_CHAR
8242    {
8243        String 1 // Description
8244        {
8245            Text [ en-US ] = "Converts a code number into a character or letter." ;
8246        };
8247        ExtraData =
8248        {
8249            0;
8250            ID_FUNCTION_GRP_TEXT;
8251            U2S( HID_FUNC_ZEICHEN );
8252            1;  0;
8253            0;
8254        };
8255        String 2 // Name of Parameter 1
8256        {
8257            Text [ en-US ] = "number" ;
8258        };
8259        String 3 // Description of Parameter 1
8260        {
8261            Text [ en-US ] = "The code value for the character." ;
8262        };
8263    };
8264     // -=*# Resource for function SÄUBERN #*=-
8265    Resource SC_OPCODE_CLEAN
8266    {
8267        String 1 // Description
8268        {
8269            Text [ en-US ] = "Removes all nonprintable characters from text." ;
8270        };
8271        ExtraData =
8272        {
8273            0;
8274            ID_FUNCTION_GRP_TEXT;
8275            U2S( HID_FUNC_SAEUBERN );
8276            1;  0;
8277            0;
8278        };
8279        String 2 // Name of Parameter 1
8280        {
8281            Text [ en-US ] = "text" ;
8282        };
8283        String 3 // Description of Parameter 1
8284        {
8285            Text [ en-US ] = "The text from which nonprintable characters are to be removed." ;
8286        };
8287    };
8288     // -=*# Resource for function VERKETTEN #*=-
8289    Resource SC_OPCODE_CONCAT
8290    {
8291        String 1 // Description
8292        {
8293            Text [ en-US ] = "Combines several text items into one." ;
8294        };
8295        ExtraData =
8296        {
8297            0;
8298            ID_FUNCTION_GRP_TEXT;
8299            U2S( HID_FUNC_VERKETTEN );
8300            VAR_ARGS;   0;
8301            0;
8302        };
8303        String 2 // Name of Parameter 1
8304        {
8305            Text [ en-US ] = "text " ;
8306        };
8307        String 3 // Description of Parameter 1
8308        {
8309            Text [ en-US ] = "Text for the concatentation." ;
8310        };
8311    };
8312     // -=*# Resource for function IDENTISCH #*=-
8313    Resource SC_OPCODE_EXACT
8314    {
8315        String 1 // Description
8316        {
8317            Text [ en-US ] = "Specifies whether two texts are identical." ;
8318        };
8319        ExtraData =
8320        {
8321            0;
8322            ID_FUNCTION_GRP_TEXT;
8323            U2S( HID_FUNC_IDENTISCH );
8324            2;  0;  0;
8325            0;
8326        };
8327        String 2 // Name of Parameter 1
8328        {
8329            Text [ en-US ] = "text_1" ;
8330        };
8331        String 3 // Description of Parameter 1
8332        {
8333            Text [ en-US ] = "The first text to be used for comparing texts." ;
8334        };
8335        String 4 // Name of Parameter 2
8336        {
8337            Text [ en-US ] = "text_2" ;
8338        };
8339        String 5 // Description of Parameter 2
8340        {
8341            Text [ en-US ] = "The second text for comparing texts." ;
8342        };
8343    };
8344     // -=*# Resource for function FINDEN #*=-
8345    Resource SC_OPCODE_FIND
8346    {
8347        String 1 // Description
8348        {
8349            Text [ en-US ] = "Looks for a string of text within another (case sensitive)" ;
8350        };
8351        ExtraData =
8352        {
8353            0;
8354            ID_FUNCTION_GRP_TEXT;
8355            U2S( HID_FUNC_FINDEN );
8356            3;  0;  0;  1;
8357            0;
8358        };
8359        String 2 // Name of Parameter 1
8360        {
8361            Text [ en-US ] = "find_text" ;
8362        };
8363        String 3 // Description of Parameter 1
8364        {
8365            Text [ en-US ] = "The text to be found." ;
8366        };
8367        String 4 // Name of Parameter 2
8368        {
8369            Text [ en-US ] = "text" ;
8370        };
8371        String 5 // Description of Parameter 2
8372        {
8373            Text [ en-US ] = "The text in which a search is to be made." ;
8374        };
8375        String 6 // Name of Parameter 3
8376        {
8377            Text [ en-US ] = "position" ;
8378        };
8379        String 7 // Description of Parameter 3
8380        {
8381            Text [ en-US ] = "The position in the text from which the search starts." ;
8382        };
8383    };
8384     // -=*# Resource for function SUCHEN #*=-
8385    Resource SC_OPCODE_SEARCH
8386    {
8387        String 1 // Description
8388        {
8389            Text [ en-US ] = "Looks for one text value within another (not case-sensitive)." ;
8390        };
8391        ExtraData =
8392        {
8393            0;
8394            ID_FUNCTION_GRP_TEXT;
8395            U2S( HID_FUNC_SUCHEN );
8396            3;  0;  0;  1;
8397            0;
8398        };
8399        String 2 // Name of Parameter 1
8400        {
8401            Text [ en-US ] = "find_text" ;
8402        };
8403        String 3 // Description of Parameter 1
8404        {
8405            Text [ en-US ] = "The text to be found." ;
8406        };
8407        String 4 // Name of Parameter 2
8408        {
8409            Text [ en-US ] = "text" ;
8410        };
8411        String 5 // Description of Parameter 2
8412        {
8413            Text [ en-US ] = "The text in which a search is to be made." ;
8414        };
8415        String 6 // Name of Parameter 3
8416        {
8417            Text [ en-US ] = "position" ;
8418        };
8419        String 7 // Description of Parameter 3
8420        {
8421            Text [ en-US ] = "The position in the text where the search is started." ;
8422        };
8423    };
8424     // -=*# Resource for function GLÄTTEN #*=-
8425    Resource SC_OPCODE_TRIM
8426    {
8427        String 1 // Description
8428        {
8429            Text [ en-US ] = "Removes extra spaces from text." ;
8430        };
8431        ExtraData =
8432        {
8433            0;
8434            ID_FUNCTION_GRP_TEXT;
8435            U2S( HID_FUNC_GLAETTEN );
8436            1;  0;
8437            0;
8438        };
8439        String 2 // Name of Parameter 1
8440        {
8441            Text [ en-US ] = "text" ;
8442        };
8443        String 3 // Description of Parameter 1
8444        {
8445            Text [ en-US ] = "The text in which extra spaces between words are to be deleted." ;
8446        };
8447    };
8448     // -=*# Resource for function GROSS2 #*=-
8449    Resource SC_OPCODE_PROPPER
8450    {
8451        String 1 // Description
8452        {
8453            Text [ en-US ] = "Capitalizes the first letter in all words." ;
8454        };
8455        ExtraData =
8456        {
8457            0;
8458            ID_FUNCTION_GRP_TEXT;
8459            U2S( HID_FUNC_GROSS2 );
8460            1;  0;
8461            0;
8462        };
8463        String 2 // Name of Parameter 1
8464        {
8465            Text [ en-US ] = "text" ;
8466        };
8467        String 3 // Description of Parameter 1
8468        {
8469            Text [ en-US ] = "The text in which the beginning of words are to be replaced by capital letters." ;
8470        };
8471    };
8472     // -=*# Resource for function GROSS #*=-
8473    Resource SC_OPCODE_UPPER
8474    {
8475        String 1 // Description
8476        {
8477            Text [ en-US ] = "Converts text to uppercase." ;
8478        };
8479        ExtraData =
8480        {
8481            0;
8482            ID_FUNCTION_GRP_TEXT;
8483            U2S( HID_FUNC_GROSS );
8484            1;  0;
8485            0;
8486        };
8487        String 2 // Name of Parameter 1
8488        {
8489            Text [ en-US ] = "text" ;
8490        };
8491        String 3 // Description of Parameter 1
8492        {
8493            Text [ en-US ] = "The text in which lower case letters are to be converted to capitals." ;
8494        };
8495    };
8496     // -=*# Resource for function KLEIN #*=-
8497    Resource SC_OPCODE_LOWER
8498    {
8499        String 1 // Description
8500        {
8501            Text [ en-US ] = "Converts text to lowercase." ;
8502        };
8503        ExtraData =
8504        {
8505            0;
8506            ID_FUNCTION_GRP_TEXT;
8507            U2S( HID_FUNC_KLEIN );
8508            1;  0;
8509            0;
8510        };
8511        String 2 // Name of Parameter 1
8512        {
8513            Text [ en-US ] = "text" ;
8514        };
8515        String 3 // Description of Parameter 1
8516        {
8517            Text [ en-US ] = "The text in which capitals are converted to lower case letters." ;
8518        };
8519    };
8520     // -=*# Resource for function WERT #*=-
8521    Resource SC_OPCODE_VALUE
8522    {
8523        String 1 // Description
8524        {
8525            Text [ en-US ] = "Converts text to a number." ;
8526        };
8527        ExtraData =
8528        {
8529            0;
8530            ID_FUNCTION_GRP_TEXT;
8531            U2S( HID_FUNC_WERT );
8532            1;  0;
8533            0;
8534        };
8535        String 2 // Name of Parameter 1
8536        {
8537            Text [ en-US ] = "text" ;
8538        };
8539        String 3 // Description of Parameter 1
8540        {
8541            Text [ en-US ] = "The text to be converted to a number." ;
8542        };
8543    };
8544     // -=*# Resource for function TEXT #*=-
8545    Resource SC_OPCODE_TEXT
8546    {
8547        String 1 // Description
8548        {
8549            Text [ en-US ] = "Converts a number to text according to a given format." ;
8550        };
8551        ExtraData =
8552        {
8553            0;
8554            ID_FUNCTION_GRP_TEXT;
8555            U2S( HID_FUNC_TEXT );
8556            2;  0;  0;
8557            0;
8558        };
8559        String 2 // Name of Parameter 1
8560        {
8561            Text [ en-US ] = "number" ;
8562        };
8563        String 3 // Description of Parameter 1
8564        {
8565            Text [ en-US ] = "The numeric value to be converted." ;
8566        };
8567        String 4 // Name of Parameter 2
8568        {
8569            Text [ en-US ] = "Format" ;
8570        };
8571        String 5 // Description of Parameter 2
8572        {
8573            Text [ en-US ] = "The text that describes the format." ;
8574        };
8575    };
8576     // -=*# Resource for function T #*=-
8577    Resource SC_OPCODE_T
8578    {
8579        String 1 // Description
8580        {
8581            Text [ en-US ] = "Returns a value if it is text, otherwise an empty string." ;
8582        };
8583        ExtraData =
8584        {
8585            0;
8586            ID_FUNCTION_GRP_TEXT;
8587            U2S( HID_FUNC_T );
8588            1;  0;
8589            0;
8590        };
8591        String 2 // Name of Parameter 1
8592        {
8593            Text [ en-US ] = "value" ;
8594        };
8595        String 3 // Description of Parameter 1
8596        {
8597            Text [ en-US ] = "The value to be checked and returned if it is text." ;
8598        };
8599    };
8600     // -=*# Resource for function ERSETZEN #*=-
8601    Resource SC_OPCODE_REPLACE
8602    {
8603        String 1 // Description
8604        {
8605            Text [ en-US ] = "Replaces characters within a text string with a different text string." ;
8606        };
8607        ExtraData =
8608        {
8609            0;
8610            ID_FUNCTION_GRP_TEXT;
8611            U2S( HID_FUNC_ERSETZEN );
8612            4;  0;  0;  0;  0;
8613            0;
8614        };
8615        String 2 // Name of Parameter 1
8616        {
8617            Text [ en-US ] = "Text" ;
8618        };
8619        String 3 // Description of Parameter 1
8620        {
8621            Text [ en-US ] = "The text in which some characters are to be replaced." ;
8622        };
8623        String 4 // Name of Parameter 2
8624        {
8625            Text [ en-US ] = "position" ;
8626        };
8627        String 5 // Description of Parameter 2
8628        {
8629            Text [ en-US ] = "The character position from which text is to be replaced." ;
8630        };
8631        String 6 // Name of Parameter 3
8632        {
8633            Text [ en-US ] = "length" ;
8634        };
8635        String 7 // Description of Parameter 3
8636        {
8637            Text [ en-US ] = "The number of characters to be replaced." ;
8638        };
8639        String 8 // Name of Parameter 4
8640        {
8641            Text [ en-US ] = "new text" ;
8642        };
8643        String 9 // Description of Parameter 4
8644        {
8645            Text [ en-US ] = "The text to be inserted." ;
8646        };
8647    };
8648     // -=*# Resource for function FEST #*=-
8649    Resource SC_OPCODE_FIXED
8650    {
8651        String 1 // Description
8652        {
8653            Text [ en-US ] = "Formats a number with a fixed number of places after the decimal point and thousands separator." ;
8654        };
8655        ExtraData =
8656        {
8657            0;
8658            ID_FUNCTION_GRP_TEXT;
8659            U2S( HID_FUNC_FEST );
8660            3;  0;  0;  1;
8661            0;
8662        };
8663        String 2 // Name of Parameter 1
8664        {
8665            Text [ en-US ] = "number" ;
8666        };
8667        String 3 // Description of Parameter 1
8668        {
8669            Text [ en-US ] = "The number to be formatted." ;
8670        };
8671        String 4 // Name of Parameter 2
8672        {
8673            Text [ en-US ] = "Decimals" ;
8674        };
8675        String 5 // Description of Parameter 2
8676        {
8677            Text [ en-US ] = "Decimal places. The number of fixed decimal places that are to be displayed." ;
8678        };
8679        String 6 // Name of Parameter 3
8680        {
8681            Text [ en-US ] = "No thousands separators" ;
8682        };
8683        String 7 // Description of Parameter 3
8684        {
8685            Text [ en-US ] = "No thousands separator. True value, if existing and TRUE (unequal to 0), no thousands separators are set." ;
8686        };
8687    };
8688     // -=*# Resource for function LÄNGE #*=-
8689    Resource SC_OPCODE_LEN
8690    {
8691        String 1 // Description
8692        {
8693            Text [ en-US ] = "Calculates length of a text string." ;
8694        };
8695        ExtraData =
8696        {
8697            0;
8698            ID_FUNCTION_GRP_TEXT;
8699            U2S( HID_FUNC_LAENGE );
8700            1;  0;
8701            0;
8702        };
8703        String 2 // Name of Parameter 1
8704        {
8705            Text [ en-US ] = "text" ;
8706        };
8707        String 3 // Description of Parameter 1
8708        {
8709            Text [ en-US ] = "The text in which the length is to be determined." ;
8710        };
8711    };
8712     // -=*# Resource for function LINKS #*=-
8713    Resource SC_OPCODE_LEFT
8714    {
8715        String 1 // Description
8716        {
8717            Text [ en-US ] = "Returns the first character or characters of a text." ;
8718        };
8719        ExtraData =
8720        {
8721            0;
8722            ID_FUNCTION_GRP_TEXT;
8723            U2S( HID_FUNC_LINKS );
8724            2;  0;  1;
8725            0;
8726        };
8727        String 2 // Name of Parameter 1
8728        {
8729            Text [ en-US ] = "text" ;
8730        };
8731        String 3 // Description of Parameter 1
8732        {
8733            Text [ en-US ] = "The text where the initial partial words are to be determined." ;
8734        };
8735        String 4 // Name of Parameter 2
8736        {
8737            Text [ en-US ] = "number" ;
8738        };
8739        String 5 // Description of Parameter 2
8740        {
8741            Text [ en-US ] = "The number of characters for the start text." ;
8742        };
8743    };
8744     // -=*# Resource for function RECHTS #*=-
8745    Resource SC_OPCODE_RIGHT
8746    {
8747        String 1 // Description
8748        {
8749            Text [ en-US ] = "Returns the last character or characters of a text." ;
8750        };
8751        ExtraData =
8752        {
8753            0;
8754            ID_FUNCTION_GRP_TEXT;
8755            U2S( HID_FUNC_RECHTS );
8756            2;  0;  1;
8757            0;
8758        };
8759        String 2 // Name of Parameter 1
8760        {
8761            Text [ en-US ] = "text" ;
8762        };
8763        String 3 // Description of Parameter 1
8764        {
8765            Text [ en-US ] = "The text in which the end partial words are to be determined." ;
8766        };
8767        String 4 // Name of Parameter 2
8768        {
8769            Text [ en-US ] = "number" ;
8770        };
8771        String 5 // Description of Parameter 2
8772        {
8773            Text [ en-US ] = "The number of characters for the end text." ;
8774        };
8775    };
8776     // -=*# Resource for function TEIL #*=-
8777    Resource SC_OPCODE_MID
8778    {
8779        String 1 // Description
8780        {
8781            Text [ en-US ] = "Returns a partial text string of a text." ;
8782        };
8783        ExtraData =
8784        {
8785            0;
8786            ID_FUNCTION_GRP_TEXT;
8787            U2S( HID_FUNC_TEIL );
8788            3;  0;  0;  0;
8789            0;
8790        };
8791        String 2 // Name of Parameter 1
8792        {
8793            Text [ en-US ] = "text" ;
8794        };
8795        String 3 // Description of Parameter 1
8796        {
8797            Text [ en-US ] = "The text in which partial words are to be determined." ;
8798        };
8799        String 4 // Name of Parameter 2
8800        {
8801            Text [ en-US ] = "start" ;
8802        };
8803        String 5 // Description of Parameter 2
8804        {
8805            Text [ en-US ] = "The position from which the part word is to be determined." ;
8806        };
8807        String 6 // Name of Parameter 3
8808        {
8809            Text [ en-US ] = "number" ;
8810        };
8811        String 7 // Description of Parameter 3
8812        {
8813            Text [ en-US ] = "The number of characters for the text." ;
8814        };
8815    };
8816     // -=*# Resource for function WIEDERHOLEN #*=-
8817    Resource SC_OPCODE_REPT
8818    {
8819        String 1 // Description
8820        {
8821            Text [ en-US ] = "Repeats text a given number of times." ;
8822        };
8823        ExtraData =
8824        {
8825            0;
8826            ID_FUNCTION_GRP_TEXT;
8827            U2S( HID_FUNC_WIEDERHOLEN );
8828            2;  0;  0;
8829            0;
8830        };
8831        String 2 // Name of Parameter 1
8832        {
8833            Text [ en-US ] = "text" ;
8834        };
8835        String 3 // Description of Parameter 1
8836        {
8837            Text [ en-US ] = "The text to be repeated." ;
8838        };
8839        String 4 // Name of Parameter 2
8840        {
8841            Text [ en-US ] = "number" ;
8842        };
8843        String 5 // Description of Parameter 2
8844        {
8845            Text [ en-US ] = "The number of times the text is to be repeated." ;
8846        };
8847    };
8848     // -=*# Resource for function WECHSELN #*=-
8849    Resource SC_OPCODE_SUBSTITUTE
8850    {
8851        String 1 // Description
8852        {
8853            Text [ en-US ] = "Substitutes new text for old text in a string." ;
8854        };
8855        ExtraData =
8856        {
8857            0;
8858            ID_FUNCTION_GRP_TEXT;
8859            U2S( HID_FUNC_WECHSELN );
8860            4;  0;  0;  0;  1;
8861            0;
8862        };
8863        String 2 // Name of Parameter 1
8864        {
8865            Text [ en-US ] = "text" ;
8866        };
8867        String 3 // Description of Parameter 1
8868        {
8869            Text [ en-US ] = "The text in which partial words are to be replaced." ;
8870        };
8871        String 4 // Name of Parameter 2
8872        {
8873            Text [ en-US ] = "search_text" ;
8874        };
8875        String 5 // Description of Parameter 2
8876        {
8877            Text [ en-US ] = "The partial string to be (repeatedly) replaced." ;
8878        };
8879        String 6 // Name of Parameter 3
8880        {
8881            Text [ en-US ] = "new text" ;
8882        };
8883        String 7 // Description of Parameter 3
8884        {
8885            Text [ en-US ] = "The text which is to replace the text string." ;
8886        };
8887        String 8 // Name of Parameter 4
8888        {
8889            Text [ en-US ] = "occurrence" ;
8890        };
8891        String 9 // Description of Parameter 4
8892        {
8893            Text [ en-US ] = "Which occurrence of the old text is to be replaced." ;
8894        };
8895    };
8896     // -=*# Resource for function BASIS #*=-
8897    Resource SC_OPCODE_BASE
8898    {
8899        String 1 // Description
8900        {
8901            Text [ en-US ] = "Converts a positive integer to text from a number system to the base defined." ;
8902        };
8903        ExtraData =
8904        {
8905            0;
8906            ID_FUNCTION_GRP_TEXT;
8907            U2S( HID_FUNC_BASIS );
8908            3;  0;  0;  1;
8909            0;
8910        };
8911        String 2 // Name of Parameter 1
8912        {
8913            Text [ en-US ] = "number" ;
8914        };
8915        String 3 // Description of Parameter 1
8916        {
8917            Text [ en-US ] = "The number to be converted." ;
8918        };
8919        String 4 // Name of Parameter 2
8920        {
8921            Text [ en-US ] = "radix" ;
8922        };
8923        String 5 // Description of Parameter 2
8924        {
8925            Text [ en-US ] = "The base number for conversion must be in the range 2 - 36." ;
8926        };
8927        String 6 // Name of Parameter 3
8928        {
8929            Text [ en-US ] = "Minimum length" ;
8930        };
8931        String 7 // Description of Parameter 3
8932        {
8933            Text [ en-US ] = "If the text is shorter than the specified length, zeros are added to the left of the string." ;
8934        };
8935    };
8936     // -=*# Resource for function DEZIMAL #*=-
8937    Resource SC_OPCODE_DECIMAL
8938    {
8939        String 1 // Description
8940        {
8941            Text [ en-US ] = "Converts a text of a specified number system to a positive integer in the base given." ;
8942        };
8943        ExtraData =
8944        {
8945            0;
8946            ID_FUNCTION_GRP_TEXT;
8947            U2S( HID_FUNC_DEZIMAL );
8948            2;  0;  0;
8949            0;
8950        };
8951        String 2 // Name of Parameter 1
8952        {
8953            Text [ en-US ] = "text" ;
8954        };
8955        String 3 // Description of Parameter 1
8956        {
8957            Text [ en-US ] = "The text to be converted." ;
8958        };
8959        String 4 // Name of Parameter 2
8960        {
8961            Text [ en-US ] = "radix" ;
8962        };
8963        String 5 // Description of Parameter 2
8964        {
8965            Text [ en-US ] = "The base number for conversion must be in the range 2 - 36." ;
8966        };
8967    };
8968     // -=*# Resource for function CONVERT #*=-
8969    Resource SC_OPCODE_CONVERT
8970    {
8971        String 1 // Description
8972        {
8973            Text [ en-US ] = "Converts a value according to a conversion table in the configuration (calc.xcu).";
8974        };
8975        ExtraData =
8976        {
8977            0;
8978            ID_FUNCTION_GRP_MATH;
8979            U2S( HID_FUNC_UMRECHNEN );
8980            3;  0;  0;  0;
8981            0;
8982        };
8983        String 2 // Name of Parameter 1
8984        {
8985            Text [ en-US ] = "value" ;
8986        };
8987        String 3 // Description of Parameter 1
8988        {
8989            Text [ en-US ] = "The value to be converted.";
8990        };
8991        String 4 // Name of Parameter 2
8992        {
8993            Text [ en-US ] = "text" ;
8994        };
8995        String 5 // Description of Parameter 2
8996        {
8997            Text [ en-US ] = "Unit from which something is converted, case-sensitive.";
8998        };
8999        String 6 // Name of Parameter 3
9000        {
9001            Text [ en-US ] = "text" ;
9002        };
9003        String 7 // Description of Parameter 3
9004        {
9005            Text [ en-US ] = "Unit into which something is converted, case-sensitive.";
9006        };
9007    };
9008     // -=*# Resource for function ROEMISCH #*=-
9009    Resource SC_OPCODE_ROMAN
9010    {
9011        String 1 // Description
9012        {
9013            Text [ en-US ] = "Converts a number to a Roman numeral.";
9014        };
9015        ExtraData =
9016        {
9017            0;
9018            ID_FUNCTION_GRP_TEXT;
9019            U2S( HID_FUNC_ROEMISCH );
9020            2;  0;  1;
9021            0;
9022        };
9023        String 2 // Name of Parameter 1
9024        {
9025            Text [ en-US ] = "Number";
9026        };
9027        String 3 // Description of Parameter 1
9028        {
9029            Text [ en-US ] = "The number to be converted to a Roman numeral must be in the 0 - 3999 range.";
9030        };
9031        String 4 // Name of Parameter 2
9032        {
9033            Text [ en-US ] = "Mode";
9034        };
9035        String 5 // Description of Parameter 2
9036        {
9037            Text [ en-US ] = "The more this value increases, the more the Roman numeral is simplified. The value must be in the 0 - 4 range.";
9038        };
9039    };
9040     // -=*# Resource for function ARABISCH #*=-
9041    Resource SC_OPCODE_ARABIC
9042    {
9043        String 1 // Description
9044        {
9045            Text [ en-US ] = "Calculates the value of a Roman numeral.";
9046        };
9047        ExtraData =
9048        {
9049            0;
9050            ID_FUNCTION_GRP_TEXT;
9051            U2S( HID_FUNC_ARABISCH );
9052            1;  0;
9053            0;
9054        };
9055        String 2 // Name of Parameter 1
9056        {
9057            Text [ en-US ] = "Text";
9058        };
9059        String 3 // Description of Parameter 1
9060        {
9061            Text [ en-US ] = "The text that represents a Roman numeral.";
9062        };
9063    };
9064    Resource SC_OPCODE_INFO
9065    {
9066        String 1
9067        {
9068            Text [ en-US ] = "Returns information about the environment.";
9069        };
9070        ExtraData =
9071        {
9072            0;
9073            ID_FUNCTION_GRP_INFO;
9074            U2S( HID_FUNC_INFO );
9075            1;  0;
9076            0;
9077        };
9078        String 2
9079        {
9080            Text [ en-US ] = "Text";
9081        };
9082        String 3
9083        {
9084            Text [ en-US ] = "Can be \"osversion\", \"system\", \"release\", \"numfile\", and \"recalc\".";
9085        };
9086    };
9087    Resource SC_OPCODE_UNICODE
9088    {
9089        String 1 // Description
9090        {
9091            Text [ en-US ] = "Returns the numeric code for the first Unicode character in a text string." ;
9092        };
9093        ExtraData =
9094        {
9095            0;
9096            ID_FUNCTION_GRP_TEXT;
9097            U2S( HID_FUNC_UNICODE );
9098            1;  0;
9099            0;
9100        };
9101        String 2 // Name of Parameter 1
9102        {
9103            Text [ en-US ] = "text" ;
9104        };
9105        String 3 // Description of Parameter 1
9106        {
9107            Text [ en-US ] = "This is the text for which the code of the first character is to be found." ;
9108        };
9109    };
9110    Resource SC_OPCODE_UNICHAR
9111    {
9112        String 1 // Description
9113        {
9114            Text [ en-US ] = "Converts a code number into a Unicode character or letter." ;
9115        };
9116        ExtraData =
9117        {
9118            0;
9119            ID_FUNCTION_GRP_TEXT;
9120            U2S( HID_FUNC_UNICHAR );
9121            1;  0;
9122            0;
9123        };
9124        String 2 // Name of Parameter 1
9125        {
9126            Text [ en-US ] = "number" ;
9127        };
9128        String 3 // Description of Parameter 1
9129        {
9130            Text [ en-US ] = "The code value for the character." ;
9131        };
9132    };
9133    Resource SC_OPCODE_EUROCONVERT
9134    {
9135        String 1 // Description
9136        {
9137            Text [ en-US ] = "Converts a value from one to another Euro currency.";
9138        };
9139        ExtraData =
9140        {
9141            0;  // DOING
9142            ID_FUNCTION_GRP_MATH;
9143            U2S( HID_FUNC_EUROCONVERT );
9144            5;  0;  0;  0;  1;  1;
9145            0;
9146        };
9147        String 2 // Name of Parameter 1
9148        {
9149            Text [ en-US ] = "value" ;
9150        };
9151        String 3 // Description of Parameter 1
9152        {
9153            Text [ en-US ] = "The value to be converted.";
9154        };
9155        String 4 // Name of Parameter 2
9156        {
9157            Text [ en-US ] = "from_currency" ;
9158        };
9159        String 5 // Description of Parameter 2
9160        {
9161            Text [ en-US ] = "ISO 4217 code of the currency from which is converted, case-sensitive.";
9162        };
9163        String 6 // Name of Parameter 3
9164        {
9165            Text [ en-US ] = "to_currency" ;
9166        };
9167        String 7 // Description of Parameter 3
9168        {
9169            Text [ en-US ] = "ISO 4217 code of the currency into which is converted, case-sensitive.";
9170        };
9171        String 8 // Name of Parameter 4
9172        {
9173            Text [ en-US ] = "full_precision" ;
9174        };
9175        String 9 // Description of Parameter 4
9176        {
9177            Text [ en-US ] = "If omitted or 0 or FALSE, the result is rounded to the decimals of to_currency. Else the result is not rounded.";
9178        };
9179        String 10 // Name of Parameter 5
9180        {
9181            Text [ en-US ] = "triangulation_precision" ;
9182        };
9183        String 11 // Description of Parameter 5
9184        {
9185            Text [ en-US ] = "If given and >=3, the intermediate result of a triangular conversion is rounded to that precision. If omitted, the result is not rounded.";
9186            Text [ x-comment ] = "This description uses almost all available space in the dialog, make sure translations fit in size." ;
9187        };
9188    };
9189    Resource SC_OPCODE_NUMBERVALUE
9190    {
9191        String 1 // Description
9192        {
9193            Text [ en-US ] = "Converts text to a number, in a locale-independent way." ;
9194        };
9195        ExtraData =
9196        {
9197            1;  // TODO: implementation and unsuppress
9198            ID_FUNCTION_GRP_TEXT;
9199            U2S( HID_FUNC_NUMBERVALUE );
9200            2;  0;  0;
9201            0;
9202        };
9203        String 2 // Name of Parameter 1
9204        {
9205            Text [ en-US ] = "text" ;
9206        };
9207        String 3 // Description of Parameter 1
9208        {
9209            Text [ en-US ] = "The text to be converted to a number." ;
9210        };
9211        String 4 // Name of Parameter 2
9212        {
9213            Text [ en-US ] = "decimal_point" ;
9214        };
9215        String 5 // Description of Parameter 2
9216        {
9217            Text [ en-US ] = "Defines the character used as the decimal point." ;
9218        };
9219    };
9220    Resource SC_OPCODE_LENB
9221    {
9222        String 1 // Description
9223        {
9224            Text [ en-US ] = "Calculates length of a text string, with DBCS" ;
9225        };
9226        ExtraData =
9227        {
9228            0;
9229            ID_FUNCTION_GRP_TEXT;
9230            U2S( HID_FUNC_LENB );
9231            1;  0;
9232            0;
9233        };
9234        String 2 // Name of Parameter 1
9235        {
9236            Text [ en-US ] = "text" ;
9237        };
9238        String 3 // Description of Parameter 1
9239        {
9240            Text [ en-US ] = "The text in which the length is to be determined." ;
9241        };
9242    };
9243    Resource SC_OPCODE_RIGHTB
9244    {
9245        String 1 // Description
9246        {
9247            Text [ en-US ] = "Returns the last character or characters of a text,with DBCS" ;
9248        };
9249        ExtraData =
9250        {
9251            0;
9252            ID_FUNCTION_GRP_TEXT;
9253            U2S( HID_FUNC_RIGHTB );
9254            2;  0;  1;
9255            0;
9256        };
9257        String 2 // Name of Parameter 1
9258        {
9259            Text [ en-US ] = "text" ;
9260        };
9261        String 3 // Description of Parameter 1
9262        {
9263            Text [ en-US ] = "The text in which the end partial words are to be determined." ;
9264        };
9265        String 4 // Name of Parameter 2
9266        {
9267            Text [ en-US ] = "number" ;
9268        };
9269        String 5 // Description of Parameter 2
9270        {
9271            Text [ en-US ] = "The number of characters for the end text." ;
9272        };
9273    };
9274    Resource SC_OPCODE_LEFTB
9275    {
9276        String 1 // Description
9277        {
9278            Text [ en-US ] = "Returns the first character or characters of a text,with DBCS" ;
9279        };
9280        ExtraData =
9281        {
9282            0;
9283            ID_FUNCTION_GRP_TEXT;
9284            U2S( HID_FUNC_LEFTB );
9285            2;  0;  1;
9286            0;
9287        };
9288        String 2 // Name of Parameter 1
9289        {
9290            Text [ en-US ] = "text" ;
9291        };
9292        String 3 // Description of Parameter 1
9293        {
9294            Text [ en-US ] = "The text where the initial partial words are to be determined." ;
9295        };
9296        String 4 // Name of Parameter 2
9297        {
9298            Text [ en-US ] = "number" ;
9299        };
9300        String 5 // Description of Parameter 2
9301        {
9302            Text [ en-US ] = "The number of characters for the start text." ;
9303        };
9304    };
9305    Resource SC_OPCODE_MIDB
9306    {
9307        String 1 // Description
9308        {
9309            Text [ en-US ] = "Returns a partial text string of a text, with DBCS" ;
9310        };
9311        ExtraData =
9312        {
9313            0;
9314            ID_FUNCTION_GRP_TEXT;
9315            U2S( HID_FUNC_MIDB );
9316            3;  0;  0;  0;
9317            0;
9318        };
9319        String 2 // Name of Parameter 1
9320        {
9321            Text [ en-US ] = "text" ;
9322        };
9323        String 3 // Description of Parameter 1
9324        {
9325            Text [ en-US ] = "The text in which partial words are to be determined." ;
9326        };
9327        String 4 // Name of Parameter 2
9328        {
9329            Text [ en-US ] = "start" ;
9330        };
9331        String 5 // Description of Parameter 2
9332        {
9333            Text [ en-US ] = "The position from which the part word is to be determined." ;
9334        };
9335        String 6 // Name of Parameter 3
9336        {
9337            Text [ en-US ] = "number" ;
9338        };
9339        String 7 // Description of Parameter 3
9340        {
9341            Text [ en-US ] = "The number of characters for the text." ;
9342        };
9343    };
9344};
9345
9346#if defined(U2S)
9347#undef U2S
9348#endif
9349