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