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 // -=*# Resource for function ABS #*=- 2660 Resource SC_OPCODE_ABS 2661 { 2662 String 1 // Description 2663 { 2664 Text [ en-US ] = "Absolute value of a number." ; 2665 }; 2666 ExtraData = 2667 { 2668 0; 2669 ID_FUNCTION_GRP_MATH; 2670 U2S( HID_FUNC_ABS ); 2671 1; 0; 2672 0; 2673 }; 2674 String 2 // Name of Parameter 1 2675 { 2676 Text [ en-US ] = "Number" ; 2677 }; 2678 String 3 // Description of Parameter 1 2679 { 2680 Text [ en-US ] = "The number whose absolute value is to be returned." ; 2681 }; 2682 }; 2683 // -=*# Resource for function POTENZ #*=- 2684 Resource SC_OPCODE_POWER 2685 { 2686 String 1 // Description 2687 { 2688 Text [ en-US ] = "Returns a^b, base a raised to the power of exponent b." ; 2689 }; 2690 ExtraData = 2691 { 2692 0; 2693 ID_FUNCTION_GRP_MATH; 2694 U2S( HID_FUNC_POTENZ ); 2695 2; 0; 0; 2696 0; 2697 }; 2698 String 2 // Name of Parameter 1 2699 { 2700 Text [ en-US ] = "Base" ; 2701 }; 2702 String 3 // Description of Parameter 1 2703 { 2704 Text [ en-US ] = "The base a of the power a^b." ; 2705 }; 2706 String 4 // Name of Parameter 2 2707 { 2708 Text [ en-US ] = "Exponent" ; 2709 }; 2710 String 5 // Description of Parameter 2 2711 { 2712 Text [ en-US ] = "The exponent b of the power a^b." ; 2713 }; 2714 }; 2715 // -=*# Resource for function ANZAHLLEEREZELLEN #*=- 2716 Resource SC_OPCODE_COUNT_EMPTY_CELLS 2717 { 2718 String 1 // Description 2719 { 2720 Text [ en-US ] = "Counts the blank cells in a specified range." ; 2721 }; 2722 ExtraData = 2723 { 2724 0; 2725 ID_FUNCTION_GRP_MATH; 2726 U2S( HID_FUNC_ANZAHLLEEREZELLEN ); 2727 1; 0; 2728 0; 2729 }; 2730 String 2 // Name of Parameter 1 2731 { 2732 Text [ en-US ] = "range" ; 2733 }; 2734 String 3 // Description of Parameter 1 2735 { 2736 Text [ en-US ] = "The range in which empty cells are to be counted." ; 2737 }; 2738 }; 2739 // -=*# Resource for function PI #*=- 2740 Resource SC_OPCODE_PI 2741 { 2742 String 1 // Description 2743 { 2744 Text [ en-US ] = "Returns the value of the number Pi." ; 2745 }; 2746 ExtraData = 2747 { 2748 0; 2749 ID_FUNCTION_GRP_MATH; 2750 U2S( HID_FUNC_PI ); 2751 0; 2752 0; 2753 }; 2754 }; 2755 // -=*# Resource for function SUMME #*=- 2756 Resource SC_OPCODE_SUM 2757 { 2758 String 1 // Description 2759 { 2760 Text [ en-US ] = "Returns the sum of all arguments." ; 2761 }; 2762 ExtraData = 2763 { 2764 0; 2765 ID_FUNCTION_GRP_MATH; 2766 U2S( HID_FUNC_SUMME ); 2767 VAR_ARGS; 0; 2768 0; 2769 }; 2770 String 2 // Name of Parameter 1 2771 { 2772 Text [ en-US ] = "number " ; 2773 }; 2774 String 3 // Description of Parameter 1 2775 { 2776 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 arguments whose total is to be calculated." ; 2777 }; 2778 }; 2779 // -=*# Resource for function QUADRATESUMME #*=- 2780 Resource SC_OPCODE_SUM_SQ 2781 { 2782 String 1 // Description 2783 { 2784 Text [ en-US ] = "Returns the sum of the squares of the arguments." ; 2785 }; 2786 ExtraData = 2787 { 2788 0; 2789 ID_FUNCTION_GRP_MATH; 2790 U2S( HID_FUNC_QUADRATESUMME ); 2791 VAR_ARGS; 0; 2792 0; 2793 }; 2794 String 2 // Name of Parameter 1 2795 { 2796 Text [ en-US ] = "number " ; 2797 }; 2798 String 3 // Description of Parameter 1 2799 { 2800 Text [ en-US ] = "Number 1, number 2,... are 1 to 30 arguments for which the sum of the squares is to be calculated." ; 2801 }; 2802 }; 2803 // -=*# Resource for function PRODUKT #*=- 2804 Resource SC_OPCODE_PRODUCT 2805 { 2806 String 1 // Description 2807 { 2808 Text [ en-US ] = "Multiplies the arguments." ; 2809 }; 2810 ExtraData = 2811 { 2812 0; 2813 ID_FUNCTION_GRP_MATH; 2814 U2S( HID_FUNC_PRODUKT ); 2815 VAR_ARGS; 0; 2816 0; 2817 }; 2818 String 2 // Name of Parameter 1 2819 { 2820 Text [ en-US ] = "Number " ; 2821 }; 2822 String 3 // Description of Parameter 1 2823 { 2824 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 arguments to be multiplied and a result returned." ; 2825 }; 2826 }; 2827 // -=*# Resource for function SUMMEWENN #*=- 2828 Resource SC_OPCODE_SUM_IF 2829 { 2830 String 1 // Description 2831 { 2832 Text [ en-US ] = "Totals the arguments that meet the conditions." ; 2833 }; 2834 ExtraData = 2835 { 2836 0; 2837 ID_FUNCTION_GRP_MATH; 2838 U2S( HID_FUNC_SUMMEWENN ); 2839 3; 0; 0; 1; 2840 0; 2841 }; 2842 String 2 // Name of Parameter 1 2843 { 2844 Text [ en-US ] = "range" ; 2845 }; 2846 String 3 // Description of Parameter 1 2847 { 2848 Text [ en-US ] = "The range to be evaluated by the criteria given." ; 2849 }; 2850 String 4 // Name of Parameter 2 2851 { 2852 Text [ en-US ] = "criteria" ; 2853 }; 2854 String 5 // Description of Parameter 2 2855 { 2856 Text [ en-US ] = "The cell range in which the search criteria are given." ; 2857 }; 2858 String 6 // Name of Parameter 3 2859 { 2860 Text [ en-US ] = "sum_range" ; 2861 }; 2862 String 7 // Description of Parameter 3 2863 { 2864 Text [ en-US ] = "The range from which the values are to be totalled." ; 2865 }; 2866 }; 2867 2868 // -=*# Resource for function AVERAGEIF #*=- 2869 Resource SC_OPCODE_AVERAGE_IF 2870 { 2871 String 1 // Description 2872 { 2873 Text [ en-US ] = "Averages the arguments that meet the conditions." ; 2874 }; 2875 ExtraData = 2876 { 2877 0; 2878 ID_FUNCTION_GRP_MATH; 2879 U2S( HID_FUNC_AVERAGEIF ); 2880 3; 0; 0; 1; 2881 0; 2882 }; 2883 String 2 // Name of Parameter 1 2884 { 2885 Text [ en-US ] = "range" ; 2886 }; 2887 String 3 // Description of Parameter 1 2888 { 2889 Text [ en-US ] = "The range to be evaluated by the criteria given." ; 2890 }; 2891 String 4 // Name of Parameter 2 2892 { 2893 Text [ en-US ] = "criteria" ; 2894 }; 2895 String 5 // Description of Parameter 2 2896 { 2897 Text [ en-US ] = "The cell range in which the search criteria are given." ; 2898 }; 2899 String 6 // Name of Parameter 3 2900 { 2901 Text [ en-US ] = "average_range" ; 2902 }; 2903 String 7 // Description of Parameter 3 2904 { 2905 Text [ en-US ] = "The range from which the values are to be averaged." ; 2906 }; 2907 }; 2908 // -=*# Resource for function ZÄHLENWENN #*=- 2909 Resource SC_OPCODE_COUNT_IF 2910 { 2911 String 1 // Description 2912 { 2913 Text [ en-US ] = "Counts the arguments which meet the set conditions." ; 2914 }; 2915 ExtraData = 2916 { 2917 0; 2918 ID_FUNCTION_GRP_MATH; 2919 U2S( HID_FUNC_ZAEHLENWENN ); 2920 2; 0; 0; 2921 0; 2922 }; 2923 String 2 // Name of Parameter 1 2924 { 2925 Text [ en-US ] = "range" ; 2926 }; 2927 String 3 // Description of Parameter 1 2928 { 2929 Text [ en-US ] = "The range of cells on which the criteria are to be applied." ; 2930 }; 2931 String 4 // Name of Parameter 2 2932 { 2933 Text [ en-US ] = "criteria" ; 2934 }; 2935 String 5 // Description of Parameter 2 2936 { 2937 Text [ en-US ] = "The cell range in which the search criteria are given." ; 2938 }; 2939 }; 2940 // -=*# Resource for function WURZEL #*=- 2941 Resource SC_OPCODE_SQRT 2942 { 2943 String 1 // Description 2944 { 2945 Text [ en-US ] = "Returns the square root of a number." ; 2946 }; 2947 ExtraData = 2948 { 2949 0; 2950 ID_FUNCTION_GRP_MATH; 2951 U2S( HID_FUNC_WURZEL ); 2952 1; 0; 2953 0; 2954 }; 2955 String 2 // Name of Parameter 1 2956 { 2957 Text [ en-US ] = "number" ; 2958 }; 2959 String 3 // Description of Parameter 1 2960 { 2961 Text [ en-US ] = "A positive value for which the square root is to be calculated." ; 2962 }; 2963 }; 2964 // -=*# Resource for function ZUFALLSZAHL #*=- 2965 Resource SC_OPCODE_RANDOM 2966 { 2967 String 1 // Description 2968 { 2969 Text [ en-US ] = "Returns a random number between 0 and 1." ; 2970 }; 2971 ExtraData = 2972 { 2973 0; 2974 ID_FUNCTION_GRP_MATH; 2975 U2S( HID_FUNC_ZUFALLSZAHL ); 2976 0; 2977 0; 2978 }; 2979 }; 2980 // -=*# Resource for function ISTGERADE #*=- 2981 Resource SC_OPCODE_IS_EVEN 2982 { 2983 String 1 // Description 2984 { 2985 Text [ en-US ] = "Returns TRUE if value is an even integer." ; 2986 }; 2987 ExtraData = 2988 { 2989 0; 2990 ID_FUNCTION_GRP_MATH; 2991 U2S( HID_FUNC_ISTGERADE ); 2992 1; 0; 2993 0; 2994 }; 2995 String 2 // Name of Parameter 1 2996 { 2997 Text [ en-US ] = "value" ; 2998 }; 2999 String 3 // Description of Parameter 1 3000 { 3001 Text [ en-US ] = "The value to be tested." ; 3002 }; 3003 }; 3004 // -=*# Resource for function ISTUNGERADE #*=- 3005 Resource SC_OPCODE_IS_ODD 3006 { 3007 String 1 // Description 3008 { 3009 Text [ en-US ] = "Returns TRUE if value is an odd integer." ; 3010 }; 3011 ExtraData = 3012 { 3013 0; 3014 ID_FUNCTION_GRP_MATH; 3015 U2S( HID_FUNC_ISTUNGERADE ); 3016 1; 0; 3017 0; 3018 }; 3019 String 2 // Name of Parameter 1 3020 { 3021 Text [ en-US ] = "value" ; 3022 }; 3023 String 3 // Description of Parameter 1 3024 { 3025 Text [ en-US ] = "The value to be tested." ; 3026 }; 3027 }; 3028 // -=*# Resource for function KOMBINATIONEN #*=- 3029 Resource SC_OPCODE_KOMBIN 3030 { 3031 String 1 // Description 3032 { 3033 Text [ en-US ] = "Calculates the number of combinations for elements without repetition." ; 3034 }; 3035 ExtraData = 3036 { 3037 0; 3038 ID_FUNCTION_GRP_MATH; 3039 U2S( HID_FUNC_KOMBINATIONEN ); 3040 2; 0; 0; 3041 0; 3042 }; 3043 String 2 // Name of Parameter 1 3044 { 3045 Text [ en-US ] = "number_1" ; 3046 }; 3047 String 3 // Description of Parameter 1 3048 { 3049 Text [ en-US ] = "The total number of elements." ; 3050 }; 3051 String 4 // Name of Parameter 2 3052 { 3053 Text [ en-US ] = "number_2" ; 3054 }; 3055 String 5 // Description of Parameter 2 3056 { 3057 Text [ en-US ] = "The number of elements selected." ; 3058 }; 3059 }; 3060 // -=*# Resource for function KOMBINATIONEN2 #*=- 3061 Resource SC_OPCODE_KOMBIN_2 3062 { 3063 String 1 // Description 3064 { 3065 Text [ en-US ] = "Calculates the number of combinations of elements including repetition." ; 3066 }; 3067 ExtraData = 3068 { 3069 0; 3070 ID_FUNCTION_GRP_MATH; 3071 U2S( HID_FUNC_KOMBINATIONEN2 ); 3072 2; 0; 0; 3073 0; 3074 }; 3075 String 2 // Name of Parameter 1 3076 { 3077 Text [ en-US ] = "number_1" ; 3078 }; 3079 String 3 // Description of Parameter 1 3080 { 3081 Text [ en-US ] = "The total number of elements." ; 3082 }; 3083 String 4 // Name of Parameter 2 3084 { 3085 Text [ en-US ] = "number_2" ; 3086 }; 3087 String 5 // Description of Parameter 2 3088 { 3089 Text [ en-US ] = "The number of elements selected." ; 3090 }; 3091 }; 3092 // -=*# Resource for function ARCCOS #*=- 3093 Resource SC_OPCODE_ARC_COS 3094 { 3095 String 1 // Description 3096 { 3097 Text [ en-US ] = "Returns the arccosine of a number." ; 3098 }; 3099 ExtraData = 3100 { 3101 0; 3102 ID_FUNCTION_GRP_MATH; 3103 U2S( HID_FUNC_ARCCOS ); 3104 1; 0; 3105 0; 3106 }; 3107 String 2 // Name of Parameter 1 3108 { 3109 Text [ en-US ] = "Number" ; 3110 }; 3111 String 3 // Description of Parameter 1 3112 { 3113 Text [ en-US ] = "A value between -1 and 1 for which the arccosine is to be returned." ; 3114 }; 3115 }; 3116 // -=*# Resource for function ARCSIN #*=- 3117 Resource SC_OPCODE_ARC_SIN 3118 { 3119 String 1 // Description 3120 { 3121 Text [ en-US ] = "Returns the arcsine of a number." ; 3122 }; 3123 ExtraData = 3124 { 3125 0; 3126 ID_FUNCTION_GRP_MATH; 3127 U2S( HID_FUNC_ARCSIN ); 3128 1; 0; 3129 0; 3130 }; 3131 String 2 // Name of Parameter 1 3132 { 3133 Text [ en-US ] = "Number" ; 3134 }; 3135 String 3 // Description of Parameter 1 3136 { 3137 Text [ en-US ] = "A value between -1 and 1 for which the arcsine is to be returned." ; 3138 }; 3139 }; 3140 // -=*# Resource for function ARCCOSHYP #*=- 3141 Resource SC_OPCODE_ARC_COS_HYP 3142 { 3143 String 1 // Description 3144 { 3145 Text [ en-US ] = "Returns the inverse hyperbolic cosine of a number." ; 3146 }; 3147 ExtraData = 3148 { 3149 0; 3150 ID_FUNCTION_GRP_MATH; 3151 U2S( HID_FUNC_ARCOSHYP ); 3152 1; 0; 3153 0; 3154 }; 3155 String 2 // Name of Parameter 1 3156 { 3157 Text [ en-US ] = "Number" ; 3158 }; 3159 String 3 // Description of Parameter 1 3160 { 3161 Text [ en-US ] = "A value greater than or equal to 1 for which the hyperbolic cosine is to be returned." ; 3162 }; 3163 }; 3164 // -=*# Resource for function ARCSINHYP #*=- 3165 Resource SC_OPCODE_ARC_SIN_HYP 3166 { 3167 String 1 // Description 3168 { 3169 Text [ en-US ] = "Returns the inverse hyperbolic sine of a number." ; 3170 }; 3171 ExtraData = 3172 { 3173 0; 3174 ID_FUNCTION_GRP_MATH; 3175 U2S( HID_FUNC_ARSINHYP ); 3176 1; 0; 3177 0; 3178 }; 3179 String 2 // Name of Parameter 1 3180 { 3181 Text [ en-US ] = "Number" ; 3182 }; 3183 String 3 // Description of Parameter 1 3184 { 3185 Text [ en-US ] = "The value for which the inverse hyperbolic sine is to be returned." ; 3186 }; 3187 }; 3188 // -=*# Resource for function ARCCOT #*=- 3189 Resource SC_OPCODE_ARC_COT 3190 { 3191 String 1 // Description 3192 { 3193 Text [ en-US ] = "Returns the inverse cotangent of a number." ; 3194 }; 3195 ExtraData = 3196 { 3197 0; 3198 ID_FUNCTION_GRP_MATH; 3199 U2S( HID_FUNC_ARCCOT ); 3200 1; 0; 3201 0; 3202 }; 3203 String 2 // Name of Parameter 1 3204 { 3205 Text [ en-US ] = "Number" ; 3206 }; 3207 String 3 // Description of Parameter 1 3208 { 3209 Text [ en-US ] = "The value for which the inverse cotangent is to be returned." ; 3210 }; 3211 }; 3212 // -=*# Resource for function ARCTAN #*=- 3213 Resource SC_OPCODE_ARC_TAN 3214 { 3215 String 1 // Description 3216 { 3217 Text [ en-US ] = "Returns the arctangent of a number." ; 3218 }; 3219 ExtraData = 3220 { 3221 0; 3222 ID_FUNCTION_GRP_MATH; 3223 U2S( HID_FUNC_ARCTAN ); 3224 1; 0; 3225 0; 3226 }; 3227 String 2 // Name of Parameter 1 3228 { 3229 Text [ en-US ] = "Number" ; 3230 }; 3231 String 3 // Description of Parameter 1 3232 { 3233 Text [ en-US ] = "The value for which the arctangent is to be returned." ; 3234 }; 3235 }; 3236 // -=*# Resource for function ARCCOTHYP #*=- 3237 Resource SC_OPCODE_ARC_COT_HYP 3238 { 3239 String 1 // Description 3240 { 3241 Text [ en-US ] = "Returns the inverse hyperbolic cotangent of a number." ; 3242 }; 3243 ExtraData = 3244 { 3245 0; 3246 ID_FUNCTION_GRP_MATH; 3247 U2S( HID_FUNC_ARCOTHYP ); 3248 1; 0; 3249 0; 3250 }; 3251 String 2 // Name of Parameter 1 3252 { 3253 Text [ en-US ] = "Number" ; 3254 }; 3255 String 3 // Description of Parameter 1 3256 { 3257 Text [ en-US ] = "A value smaller than -1 or greater than 1 for which the inverse hyperbolic cotangent is to be returned." ; 3258 }; 3259 }; 3260 // -=*# Resource for function ARCTANHYP #*=- 3261 Resource SC_OPCODE_ARC_TAN_HYP 3262 { 3263 String 1 // Description 3264 { 3265 Text [ en-US ] = "Returns the inverse hyperbolic tangent of a number." ; 3266 }; 3267 ExtraData = 3268 { 3269 0; 3270 ID_FUNCTION_GRP_MATH; 3271 U2S( HID_FUNC_ARTANHYP ); 3272 1; 0; 3273 0; 3274 }; 3275 String 2 // Name of Parameter 1 3276 { 3277 Text [ en-US ] = "Number" ; 3278 }; 3279 String 3 // Description of Parameter 1 3280 { 3281 Text [ en-US ] = "A value between -1 and 1 for which the inverse hyperbolic tangent is to be returned." ; 3282 }; 3283 }; 3284 // -=*# Resource for function COS #*=- 3285 Resource SC_OPCODE_COS 3286 { 3287 String 1 // Description 3288 { 3289 Text [ en-US ] = "Returns the cosine of a number." ; 3290 }; 3291 ExtraData = 3292 { 3293 0; 3294 ID_FUNCTION_GRP_MATH; 3295 U2S( HID_FUNC_COS ); 3296 1; 0; 3297 0; 3298 }; 3299 String 2 // Name of Parameter 1 3300 { 3301 Text [ en-US ] = "Number" ; 3302 }; 3303 String 3 // Description of Parameter 1 3304 { 3305 Text [ en-US ] = "The angle in the radians for which the cosine is to be returned." ; 3306 }; 3307 }; 3308 // -=*# Resource for function SIN #*=- 3309 Resource SC_OPCODE_SIN 3310 { 3311 String 1 // Description 3312 { 3313 Text [ en-US ] = "Returns the sine of a number." ; 3314 }; 3315 ExtraData = 3316 { 3317 0; 3318 ID_FUNCTION_GRP_MATH; 3319 U2S( HID_FUNC_SIN ); 3320 1; 0; 3321 0; 3322 }; 3323 String 2 // Name of Parameter 1 3324 { 3325 Text [ en-US ] = "number" ; 3326 }; 3327 String 3 // Description of Parameter 1 3328 { 3329 Text [ en-US ] = "The angle in radians for which the sine is to be calculated." ; 3330 }; 3331 }; 3332 // -=*# Resource for function COT #*=- 3333 Resource SC_OPCODE_COT 3334 { 3335 String 1 // Description 3336 { 3337 Text [ en-US ] = "Returns the cotangent of a number." ; 3338 }; 3339 ExtraData = 3340 { 3341 0; 3342 ID_FUNCTION_GRP_MATH; 3343 U2S( HID_FUNC_COT ); 3344 1; 0; 3345 0; 3346 }; 3347 String 2 // Name of Parameter 1 3348 { 3349 Text [ en-US ] = "Number" ; 3350 }; 3351 String 3 // Description of Parameter 1 3352 { 3353 Text [ en-US ] = "The angle in radians whose cotangent value is to be returned." ; 3354 }; 3355 }; 3356 // -=*# Resource for function TAN #*=- 3357 Resource SC_OPCODE_TAN 3358 { 3359 String 1 // Description 3360 { 3361 Text [ en-US ] = "Returns the tangent of a number." ; 3362 }; 3363 ExtraData = 3364 { 3365 0; 3366 ID_FUNCTION_GRP_MATH; 3367 U2S( HID_FUNC_TAN ); 3368 1; 0; 3369 0; 3370 }; 3371 String 2 // Name of Parameter 1 3372 { 3373 Text [ en-US ] = "number" ; 3374 }; 3375 String 3 // Description of Parameter 1 3376 { 3377 Text [ en-US ] = "The angle in radians for which the tangent is to be calculated." ; 3378 }; 3379 }; 3380 // -=*# Resource for function COSHYP #*=- 3381 Resource SC_OPCODE_COS_HYP 3382 { 3383 String 1 // Description 3384 { 3385 Text [ en-US ] = "Returns the hyperbolic cosine of a number." ; 3386 }; 3387 ExtraData = 3388 { 3389 0; 3390 ID_FUNCTION_GRP_MATH; 3391 U2S( HID_FUNC_COSHYP ); 3392 1; 0; 3393 0; 3394 }; 3395 String 2 // Name of Parameter 1 3396 { 3397 Text [ en-US ] = "Number" ; 3398 }; 3399 String 3 // Description of Parameter 1 3400 { 3401 Text [ en-US ] = "The value for which the hyperbolic cosine is to be returned." ; 3402 }; 3403 }; 3404 // -=*# Resource for function SINHYP #*=- 3405 Resource SC_OPCODE_SIN_HYP 3406 { 3407 String 1 // Description 3408 { 3409 Text [ en-US ] = "Returns the hyperbolic sine of a number." ; 3410 }; 3411 ExtraData = 3412 { 3413 0; 3414 ID_FUNCTION_GRP_MATH; 3415 U2S( HID_FUNC_SINHYP ); 3416 1; 0; 3417 0; 3418 }; 3419 String 2 // Name of Parameter 1 3420 { 3421 Text [ en-US ] = "number" ; 3422 }; 3423 String 3 // Description of Parameter 1 3424 { 3425 Text [ en-US ] = "The value for which the hyperbolic sine is to be calculated." ; 3426 }; 3427 }; 3428 // -=*# Resource for function COTHYP #*=- 3429 Resource SC_OPCODE_COT_HYP 3430 { 3431 String 1 // Description 3432 { 3433 Text [ en-US ] = "Returns the hyperbolic cotangent of a number." ; 3434 }; 3435 ExtraData = 3436 { 3437 0; 3438 ID_FUNCTION_GRP_MATH; 3439 U2S( HID_FUNC_COTHYP ); 3440 1; 0; 3441 0; 3442 }; 3443 String 2 // Name of Parameter 1 3444 { 3445 Text [ en-US ] = "Number" ; 3446 }; 3447 String 3 // Description of Parameter 1 3448 { 3449 Text [ en-US ] = "A value not equal to 0 for which the hyperbolic cotangent is to be returned." ; 3450 }; 3451 }; 3452 // -=*# Resource for function TANHYP #*=- 3453 Resource SC_OPCODE_TAN_HYP 3454 { 3455 String 1 // Description 3456 { 3457 Text [ en-US ] = "Returns the hyperbolic tangent of a number." ; 3458 }; 3459 ExtraData = 3460 { 3461 0; 3462 ID_FUNCTION_GRP_MATH; 3463 U2S( HID_FUNC_TANHYP ); 3464 1; 0; 3465 0; 3466 }; 3467 String 2 // Name of Parameter 1 3468 { 3469 Text [ en-US ] = "number" ; 3470 }; 3471 String 3 // Description of Parameter 1 3472 { 3473 Text [ en-US ] = "The value for which the hyperbolic tangent is to be calculated." ; 3474 }; 3475 }; 3476 // -=*# Resource for function ARCTAN2 #*=- 3477 Resource SC_OPCODE_ARC_TAN_2 3478 { 3479 String 1 // Description 3480 { 3481 Text [ en-US ] = "Returns the arctangent for the specified coordinates." ; 3482 }; 3483 ExtraData = 3484 { 3485 0; 3486 ID_FUNCTION_GRP_MATH; 3487 U2S( HID_FUNC_ARCTAN2 ); 3488 2; 0; 0; 3489 0; 3490 }; 3491 String 2 // Name of Parameter 1 3492 { 3493 Text [ en-US ] = "number_x" ; 3494 }; 3495 String 3 // Description of Parameter 1 3496 { 3497 Text [ en-US ] = "The value for the x coordinate." ; 3498 }; 3499 String 4 // Name of Parameter 2 3500 { 3501 Text [ en-US ] = "number_y" ; 3502 }; 3503 String 5 // Description of Parameter 2 3504 { 3505 Text [ en-US ] = "The value for the y coordinate." ; 3506 }; 3507 }; 3508 3509 // -=*# Resource for function DEG #*=- 3510 Resource SC_OPCODE_DEG 3511 { 3512 String 1 // Description 3513 { 3514 Text [ en-US ] = "Converts a radian to degrees" ; 3515 }; 3516 ExtraData = 3517 { 3518 0; 3519 ID_FUNCTION_GRP_MATH; 3520 U2S( HID_FUNC_DEG ); 3521 1; 0; 3522 0; 3523 }; 3524 String 2 // Name of Parameter 1 3525 { 3526 Text [ en-US ] = "Number" ; 3527 }; 3528 String 3 // Description of Parameter 1 3529 { 3530 Text [ en-US ] = "The angle in a radian" ; 3531 }; 3532 }; 3533 // -=*# Resource for function RAD #*=- 3534 Resource SC_OPCODE_RAD 3535 { 3536 String 1 // Description 3537 { 3538 Text [ en-US ] = "Converts degrees to radians" ; 3539 }; 3540 ExtraData = 3541 { 3542 0; 3543 ID_FUNCTION_GRP_MATH; 3544 U2S( HID_FUNC_RAD ); 3545 1; 0; 3546 0; 3547 }; 3548 String 2 // Name of Parameter 1 3549 { 3550 Text [ en-US ] = "Number" ; 3551 }; 3552 String 3 // Description of Parameter 1 3553 { 3554 Text [ en-US ] = "The angle in degrees." ; 3555 }; 3556 }; 3557 // -=*# Resource for function EXP #*=- 3558 Resource SC_OPCODE_EXP 3559 { 3560 String 1 // Description 3561 { 3562 Text [ en-US ] = "Calculates the exponent for basis e." ; 3563 }; 3564 ExtraData = 3565 { 3566 0; 3567 ID_FUNCTION_GRP_MATH; 3568 U2S( HID_FUNC_EXP ); 3569 1; 0; 3570 0; 3571 }; 3572 String 2 // Name of Parameter 1 3573 { 3574 Text [ en-US ] = "Number" ; 3575 }; 3576 String 3 // Description of Parameter 1 3577 { 3578 Text [ en-US ] = "The exponent applied to base e." ; 3579 }; 3580 }; 3581 // -=*# Resource for function LOG #*=- 3582 Resource SC_OPCODE_LOG 3583 { 3584 String 1 // Description 3585 { 3586 Text [ en-US ] = "Calculates the logarithm to any specified base." ; 3587 }; 3588 ExtraData = 3589 { 3590 0; 3591 ID_FUNCTION_GRP_MATH; 3592 U2S( HID_FUNC_LOG ); 3593 2; 0; 1; 3594 0; 3595 }; 3596 String 2 // Name of Parameter 1 3597 { 3598 Text [ en-US ] = "Number" ; 3599 }; 3600 String 3 // Description of Parameter 1 3601 { 3602 Text [ en-US ] = "A value greater than 0 for which the logarithm is to be calculated." ; 3603 }; 3604 String 4 // Name of Parameter 2 3605 { 3606 Text [ en-US ] = "Base" ; 3607 }; 3608 String 5 // Description of Parameter 2 3609 { 3610 Text [ en-US ] = "The base of the logarithm. If omitted, the base is regarded as 10." ; 3611 }; 3612 }; 3613 // -=*# Resource for function LN #*=- 3614 Resource SC_OPCODE_LN 3615 { 3616 String 1 // Description 3617 { 3618 Text [ en-US ] = "Calculates the natural logarithm of a number." ; 3619 }; 3620 ExtraData = 3621 { 3622 0; 3623 ID_FUNCTION_GRP_MATH; 3624 U2S( HID_FUNC_LN ); 3625 1; 0; 3626 0; 3627 }; 3628 String 2 // Name of Parameter 1 3629 { 3630 Text [ en-US ] = "Number" ; 3631 }; 3632 String 3 // Description of Parameter 1 3633 { 3634 Text [ en-US ] = "A value greater than 0 for which the natural logarithm is to be calculated." ; 3635 }; 3636 }; 3637 // -=*# Resource for function LOG10 #*=- 3638 Resource SC_OPCODE_LOG10 3639 { 3640 String 1 // Description 3641 { 3642 Text [ en-US ] = "Calculates the base-10 logarithm of a number." ; 3643 }; 3644 ExtraData = 3645 { 3646 0; 3647 ID_FUNCTION_GRP_MATH; 3648 U2S( HID_FUNC_LOG10 ); 3649 1; 0; 3650 0; 3651 }; 3652 String 2 // Name of Parameter 1 3653 { 3654 Text [ en-US ] = "Number" ; 3655 }; 3656 String 3 // Description of Parameter 1 3657 { 3658 Text [ en-US ] = "A value greater than 0 for which the logarithm is to be calculated." ; 3659 }; 3660 }; 3661 // -=*# Resource for function FAKULTÄT #*=- 3662 Resource SC_OPCODE_FACT 3663 { 3664 String 1 // Description 3665 { 3666 Text [ en-US ] = "Calculates the factorial of a number." ; 3667 }; 3668 ExtraData = 3669 { 3670 0; 3671 ID_FUNCTION_GRP_MATH; 3672 U2S( HID_FUNC_FAKULTAET ); 3673 1; 0; 3674 0; 3675 }; 3676 String 2 // Name of Parameter 1 3677 { 3678 Text [ en-US ] = "Number" ; 3679 }; 3680 String 3 // Description of Parameter 1 3681 { 3682 Text [ en-US ] = "The number for which the factorial is to be calculated." ; 3683 }; 3684 }; 3685 // -=*# Resource for function REST #*=- 3686 Resource SC_OPCODE_MOD 3687 { 3688 String 1 // Description 3689 { 3690 Text [ en-US ] = "Calculates the remainder of a division." ; 3691 }; 3692 ExtraData = 3693 { 3694 0; 3695 ID_FUNCTION_GRP_MATH; 3696 U2S( HID_FUNC_REST ); 3697 2; 0; 0; 3698 0; 3699 }; 3700 String 2 // Name of Parameter 1 3701 { 3702 Text [ en-US ] = "Dividend" ; 3703 }; 3704 String 3 // Description of Parameter 1 3705 { 3706 Text [ en-US ] = "The number to be divided." ; 3707 }; 3708 String 4 // Name of Parameter 2 3709 { 3710 Text [ en-US ] = "Divisor" ; 3711 }; 3712 String 5 // Description of Parameter 2 3713 { 3714 Text [ en-US ] = "The number by which the dividend is divided." ; 3715 }; 3716 }; 3717 // -=*# Resource for function VORZEICHEN #*=- 3718 Resource SC_OPCODE_PLUS_MINUS 3719 { 3720 String 1 // Description 3721 { 3722 Text [ en-US ] = "Returns the algebraic sign of a number." ; 3723 }; 3724 ExtraData = 3725 { 3726 0; 3727 ID_FUNCTION_GRP_MATH; 3728 U2S( HID_FUNC_VORZEICHEN ); 3729 1; 0; 3730 0; 3731 }; 3732 String 2 // Name of Parameter 1 3733 { 3734 Text [ en-US ] = "Number" ; 3735 }; 3736 String 3 // Description of Parameter 1 3737 { 3738 Text [ en-US ] = "The number for which the algebraic sign is to be determined." ; 3739 }; 3740 }; 3741 // -=*# Resource for function TEILERGEBNIS #*=- 3742 Resource SC_OPCODE_SUB_TOTAL 3743 { 3744 String 1 // Description 3745 { 3746 Text [ en-US ] = "Calculates subtotals in a spreadsheet." ; 3747 }; 3748 ExtraData = 3749 { 3750 0; 3751 ID_FUNCTION_GRP_MATH; 3752 U2S( HID_FUNC_TEILERGEBNIS ); 3753 2; 0; 0; 3754 0; 3755 }; 3756 String 2 // Name of Parameter 1 3757 { 3758 Text [ en-US ] = "Function" ; 3759 }; 3760 String 3 // Description of Parameter 1 3761 { 3762 Text [ en-US ] = "Function index. Is an index of the possible functions Total, Max, ..." ; 3763 }; 3764 String 4 // Name of Parameter 2 3765 { 3766 Text [ en-US ] = "range " ; 3767 }; 3768 String 5 // Description of Parameter 2 3769 { 3770 Text [ en-US ] = "The cells of the range which are to be taken into account." ; 3771 }; 3772 }; 3773 // -=*# Resource for function GANZZAHL #*=- 3774 Resource SC_OPCODE_INT 3775 { 3776 String 1 // Description 3777 { 3778 Text [ en-US ] = "Rounds a number down to the nearest integer." ; 3779 }; 3780 ExtraData = 3781 { 3782 0; 3783 ID_FUNCTION_GRP_MATH; 3784 U2S( HID_FUNC_GANZZAHL ); 3785 1; 0; 3786 0; 3787 }; 3788 String 2 // Name of Parameter 1 3789 { 3790 Text [ en-US ] = "Number" ; 3791 }; 3792 String 3 // Description of Parameter 1 3793 { 3794 Text [ en-US ] = "The number to be rounded down." ; 3795 }; 3796 }; 3797 // -=*# Resource for function KÜRZEN #*=- 3798 Resource SC_OPCODE_TRUNC 3799 { 3800 String 1 // Description 3801 { 3802 Text [ en-US ] = "Truncates the decimal places of a number." ; 3803 }; 3804 ExtraData = 3805 { 3806 0; 3807 ID_FUNCTION_GRP_MATH; 3808 U2S( HID_FUNC_KUERZEN ); 3809 2; 0; 0; 3810 0; 3811 }; 3812 String 2 // Name of Parameter 1 3813 { 3814 Text [ en-US ] = "number" ; 3815 }; 3816 String 3 // Description of Parameter 1 3817 { 3818 Text [ en-US ] = "The number to be truncated." ; 3819 }; 3820 String 4 // Name of Parameter 2 3821 { 3822 Text [ en-US ] = "count" ; 3823 }; 3824 String 5 // Description of Parameter 2 3825 { 3826 Text [ en-US ] = "The number of places after the decimal point that are not to be truncated." ; 3827 }; 3828 }; 3829 // -=*# Resource for function RUNDEN #*=- 3830 Resource SC_OPCODE_ROUND 3831 { 3832 String 1 // Description 3833 { 3834 Text [ en-US ] = "Rounds a number to a predefined accuracy." ; 3835 }; 3836 ExtraData = 3837 { 3838 0; 3839 ID_FUNCTION_GRP_MATH; 3840 U2S( HID_FUNC_RUNDEN ); 3841 2; 0; 1; 3842 0; 3843 }; 3844 String 2 // Name of Parameter 1 3845 { 3846 Text [ en-US ] = "number" ; 3847 }; 3848 String 3 // Description of Parameter 1 3849 { 3850 Text [ en-US ] = "The number to be rounded." ; 3851 }; 3852 String 4 // Name of Parameter 2 3853 { 3854 Text [ en-US ] = "count" ; 3855 }; 3856 String 5 // Description of Parameter 2 3857 { 3858 Text [ en-US ] = "The number of places to which a number is to be rounded." ; 3859 }; 3860 }; 3861 // -=*# Resource for function AUFRUNDEN #*=- 3862 Resource SC_OPCODE_ROUND_UP 3863 { 3864 String 1 // Description 3865 { 3866 Text [ en-US ] = "Rounds a number up to the predefined accuracy." ; 3867 }; 3868 ExtraData = 3869 { 3870 0; 3871 ID_FUNCTION_GRP_MATH; 3872 U2S( HID_FUNC_AUFRUNDEN ); 3873 2; 0; 1; 3874 0; 3875 }; 3876 String 2 // Name of Parameter 1 3877 { 3878 Text [ en-US ] = "number" ; 3879 }; 3880 String 3 // Description of Parameter 1 3881 { 3882 Text [ en-US ] = "The number to be rounded up." ; 3883 }; 3884 String 4 // Name of Parameter 2 3885 { 3886 Text [ en-US ] = "count" ; 3887 }; 3888 String 5 // Description of Parameter 2 3889 { 3890 Text [ en-US ] = "The number of places to which a number is to be rounded." ; 3891 }; 3892 }; 3893 // -=*# Resource for function ABRUNDEN #*=- 3894 Resource SC_OPCODE_ROUND_DOWN 3895 { 3896 String 1 // Description 3897 { 3898 Text [ en-US ] = "Rounds a number down to a predefined accuracy." ; 3899 }; 3900 ExtraData = 3901 { 3902 0; 3903 ID_FUNCTION_GRP_MATH; 3904 U2S( HID_FUNC_ABRUNDEN ); 3905 2; 0; 1; 3906 0; 3907 }; 3908 String 2 // Name of Parameter 1 3909 { 3910 Text [ en-US ] = "number" ; 3911 }; 3912 String 3 // Description of Parameter 1 3913 { 3914 Text [ en-US ] = "The number to be rounded down." ; 3915 }; 3916 String 4 // Name of Parameter 2 3917 { 3918 Text [ en-US ] = "count" ; 3919 }; 3920 String 5 // Description of Parameter 2 3921 { 3922 Text [ en-US ] = "The number of places down to which a number is to be rounded." ; 3923 }; 3924 }; 3925 // -=*# Resource for function GERADE #*=- 3926 Resource SC_OPCODE_EVEN 3927 { 3928 String 1 // Description 3929 { 3930 Text [ en-US ] = "Rounds a positive number up and negative number down to the nearest even integer."; 3931 }; 3932 ExtraData = 3933 { 3934 0; 3935 ID_FUNCTION_GRP_MATH; 3936 U2S( HID_FUNC_GERADE ); 3937 1; 0; 3938 0; 3939 }; 3940 String 2 // Name of Parameter 1 3941 { 3942 Text [ en-US ] = "Number" ; 3943 }; 3944 String 3 // Description of Parameter 1 3945 { 3946 Text [ en-US ] = "The number to be rounded up." ; 3947 }; 3948 }; 3949 // -=*# Resource for function UNGERADE #*=- 3950 Resource SC_OPCODE_ODD 3951 { 3952 String 1 // Description 3953 { 3954 Text [ en-US ] = "Rounds a positive number up and negative number down to the nearest odd integer."; 3955 }; 3956 ExtraData = 3957 { 3958 0; 3959 ID_FUNCTION_GRP_MATH; 3960 U2S( HID_FUNC_UNGERADE ); 3961 1; 0; 3962 0; 3963 }; 3964 String 2 // Name of Parameter 1 3965 { 3966 Text [ en-US ] = "Number" ; 3967 }; 3968 String 3 // Description of Parameter 1 3969 { 3970 Text [ en-US ] = "The number to be rounded up." ; 3971 }; 3972 }; 3973 // -=*# Resource for function OBERGRENZE #*=- 3974 Resource SC_OPCODE_CEIL 3975 { 3976 String 1 // Description 3977 { 3978 Text [ en-US ] = "Rounds a number up to the nearest multiple of significance." ; 3979 }; 3980 ExtraData = 3981 { 3982 0; 3983 ID_FUNCTION_GRP_MATH; 3984 U2S( HID_FUNC_OBERGRENZE ); 3985 3; 0; 0; 1; 3986 0; 3987 }; 3988 String 2 // Name of Parameter 1 3989 { 3990 Text [ en-US ] = "Number" ; 3991 }; 3992 String 3 // Description of Parameter 1 3993 { 3994 Text [ en-US ] = "The number to be rounded up." ; 3995 }; 3996 String 4 // Name of Parameter 2 3997 { 3998 Text [ en-US ] = "Significance" ; 3999 }; 4000 String 5 // Description of Parameter 2 4001 { 4002 Text [ en-US ] = "The number to whose multiple the value is rounded." ; 4003 }; 4004 String 6 // Name of Parameter 3 4005 { 4006 Text [ en-US ] = "Mode" ; 4007 }; 4008 String 7 // Description of Parameter 3 4009 { 4010 Text [ en-US ] = "If given and not equal to zero then rounded up according to amount when a negative number and significance." ; 4011 }; 4012 }; 4013 // -=*# Resource for function UNTERGRENZE #*=- 4014 Resource SC_OPCODE_FLOOR 4015 { 4016 String 1 // Description 4017 { 4018 Text [ en-US ] = "Rounds number down to the nearest multiple of significance." ; 4019 }; 4020 ExtraData = 4021 { 4022 0; 4023 ID_FUNCTION_GRP_MATH; 4024 U2S( HID_FUNC_UNTERGRENZE ); 4025 3; 0; 0; 1; 4026 0; 4027 }; 4028 String 2 // Name of Parameter 1 4029 { 4030 Text [ en-US ] = "Number" ; 4031 }; 4032 String 3 // Description of Parameter 1 4033 { 4034 Text [ en-US ] = "The number to be rounded down." ; 4035 }; 4036 String 4 // Name of Parameter 2 4037 { 4038 Text [ en-US ] = "Significance" ; 4039 }; 4040 String 5 // Description of Parameter 2 4041 { 4042 Text [ en-US ] = "The number to whose multiple the value is to be rounded down." ; 4043 }; 4044 String 6 // Name of Parameter 3 4045 { 4046 Text [ en-US ] = "Mode" ; 4047 }; 4048 String 7 // Description of Parameter 3 4049 { 4050 Text [ en-US ] = "If given and not equal to zero then rounded down according to amount when a negative number and significance." ; 4051 }; 4052 }; 4053 // -=*# Resource for function GGT #*=- 4054 Resource SC_OPCODE_GGT 4055 { 4056 String 1 // Description 4057 { 4058 Text [ en-US ] = "Greatest Common Divisor" ; 4059 }; 4060 ExtraData = 4061 { 4062 0; 4063 ID_FUNCTION_GRP_MATH; 4064 U2S( HID_FUNC_GGT ); 4065 VAR_ARGS; 0; 4066 0; 4067 }; 4068 String 2 // Name of Parameter 1 4069 { 4070 Text [ en-US ] = "Integer " ; 4071 }; 4072 String 3 // Description of Parameter 1 4073 { 4074 Text [ en-US ] = "Integer 1; integer 2,... are integers for which the greatest common divisor is to be calculated." ; 4075 }; 4076 }; 4077 // -=*# Resource for function KGV #*=- 4078 Resource SC_OPCODE_KGV 4079 { 4080 String 1 // Description 4081 { 4082 Text [ en-US ] = "Lowest common multiple" ; 4083 }; 4084 ExtraData = 4085 { 4086 0; 4087 ID_FUNCTION_GRP_MATH; 4088 U2S( HID_FUNC_KGV ); 4089 VAR_ARGS; 0; 4090 0; 4091 }; 4092 String 2 // Name of Parameter 1 4093 { 4094 Text [ en-US ] = "Integer " ; 4095 }; 4096 String 3 // Description of Parameter 1 4097 { 4098 Text [ en-US ] = "Integer 1; integer 2,... are integers whose smallest common multiple is to be calculated." ; 4099 }; 4100 }; 4101 // -=*# Resource for function MTRANS #*=- 4102 Resource SC_OPCODE_MAT_TRANS 4103 { 4104 String 1 // Description 4105 { 4106 Text [ en-US ] = "Array transposition. Exchanges the rows and columns of an array." ; 4107 }; 4108 ExtraData = 4109 { 4110 0; 4111 ID_FUNCTION_GRP_MATRIX; 4112 U2S( HID_FUNC_MTRANS ); 4113 1; 0; 4114 0; 4115 }; 4116 String 2 // Name of Parameter 1 4117 { 4118 Text [ en-US ] = "array" ; 4119 }; 4120 String 3 // Description of Parameter 1 4121 { 4122 Text [ en-US ] = "The array in which the rows and columns have been transposed." ; 4123 }; 4124 }; 4125 // -=*# Resource for function MMULT #*=- 4126 Resource SC_OPCODE_MAT_MULT 4127 { 4128 String 1 // Description 4129 { 4130 Text [ en-US ] = "Array multiplication. Returns the product of two arrays." ; 4131 }; 4132 ExtraData = 4133 { 4134 0; 4135 ID_FUNCTION_GRP_MATRIX; 4136 U2S( HID_FUNC_MMULT ); 4137 2; 0; 0; 4138 0; 4139 }; 4140 String 2 // Name of Parameter 1 4141 { 4142 Text [ en-US ] = "array" ; 4143 }; 4144 String 3 // Description of Parameter 1 4145 { 4146 Text [ en-US ] = "The first array for the array product." ; 4147 }; 4148 String 4 // Name of Parameter 2 4149 { 4150 Text [ en-US ] = "array" ; 4151 }; 4152 String 5 // Description of Parameter 2 4153 { 4154 Text [ en-US ] = "The second array having the same number of rows as the first array has columns." ; 4155 }; 4156 }; 4157 // -=*# Resource for function MDET #*=- 4158 Resource SC_OPCODE_MAT_DET 4159 { 4160 String 1 // Description 4161 { 4162 Text [ en-US ] = "Returns the array determinant." ; 4163 }; 4164 ExtraData = 4165 { 4166 0; 4167 ID_FUNCTION_GRP_MATRIX; 4168 U2S( HID_FUNC_MDET ); 4169 1; 0; 4170 0; 4171 }; 4172 String 2 // Name of Parameter 1 4173 { 4174 Text [ en-US ] = "array" ; 4175 }; 4176 String 3 // Description of Parameter 1 4177 { 4178 Text [ en-US ] = "The array for which the determinant is to be determined." ; 4179 }; 4180 }; 4181 // -=*# Resource for function MINV #*=- 4182 Resource SC_OPCODE_MAT_INV 4183 { 4184 String 1 // Description 4185 { 4186 Text [ en-US ] = "Returns the inverse of an array." ; 4187 }; 4188 ExtraData = 4189 { 4190 0; 4191 ID_FUNCTION_GRP_MATRIX; 4192 U2S( HID_FUNC_MINV ); 4193 1; 0; 4194 0; 4195 }; 4196 String 2 // Name of Parameter 1 4197 { 4198 Text [ en-US ] = "array" ; 4199 }; 4200 String 3 // Description of Parameter 1 4201 { 4202 Text [ en-US ] = "The array to be inverted." ; 4203 }; 4204 }; 4205 // -=*# Resource for function EINHEITSMATRIX #*=- 4206 Resource SC_OPCODE_MATRIX_UNIT 4207 { 4208 String 1 // Description 4209 { 4210 Text [ en-US ] = "Returns the unitary square array of a certain size." ; 4211 }; 4212 ExtraData = 4213 { 4214 0; 4215 ID_FUNCTION_GRP_MATRIX; 4216 U2S( HID_FUNC_EINHEITSMATRIX ); 4217 1; 0; 4218 0; 4219 }; 4220 String 2 // Name of Parameter 1 4221 { 4222 Text [ en-US ] = "Dimensions" ; 4223 }; 4224 String 3 // Description of Parameter 1 4225 { 4226 Text [ en-US ] = "The size of the unitary array." ; 4227 }; 4228 }; 4229 // -=*# Resource for function SUMMENPRODUKT #*=- 4230 Resource SC_OPCODE_SUM_PRODUCT 4231 { 4232 String 1 // Description 4233 { 4234 Text [ en-US ] = "(Inner products) Returns the sum of the products of array arguments." ; 4235 }; 4236 ExtraData = 4237 { 4238 0; 4239 ID_FUNCTION_GRP_MATRIX; 4240 U2S( HID_FUNC_SUMMENPRODUKT ); 4241 VAR_ARGS; 0; 4242 0; 4243 }; 4244 String 2 // Name of Parameter 1 4245 { 4246 Text [ en-US ] = "Array " ; 4247 }; 4248 String 3 // Description of Parameter 1 4249 { 4250 Text [ en-US ] = "Array 1, array 2, ... are up to 30 arrays whose arguments are to be multiplied." ; 4251 }; 4252 }; 4253 // -=*# Resource for function SUMMEX2MY2 #*=- 4254 Resource SC_OPCODE_SUM_X2MY2 4255 { 4256 String 1 // Description 4257 { 4258 Text [ en-US ] = "Returns the sum of the difference of squares of two arrays." ; 4259 }; 4260 ExtraData = 4261 { 4262 0; 4263 ID_FUNCTION_GRP_MATRIX; 4264 U2S( HID_FUNC_SUMMEX2MY2 ); 4265 2; 0; 0; 4266 0; 4267 }; 4268 String 2 // Name of Parameter 1 4269 { 4270 Text [ en-US ] = "array_x" ; 4271 }; 4272 String 3 // Description of Parameter 1 4273 { 4274 Text [ en-US ] = "First array where the square of the arguments are totalled." ; 4275 }; 4276 String 4 // Name of Parameter 2 4277 { 4278 Text [ en-US ] = "array_y" ; 4279 }; 4280 String 5 // Description of Parameter 2 4281 { 4282 Text [ en-US ] = "Second array where the square of the arguments is to be subtracted." ; 4283 }; 4284 }; 4285 // -=*# Resource for function SUMMEX2PY2 #*=- 4286 Resource SC_OPCODE_SUM_X2DY2 4287 { 4288 String 1 // Description 4289 { 4290 Text [ en-US ] = "Returns the total of the square sum of two arrays." ; 4291 }; 4292 ExtraData = 4293 { 4294 0; 4295 ID_FUNCTION_GRP_MATRIX; 4296 U2S( HID_FUNC_SUMMEX2PY2 ); 4297 2; 0; 0; 4298 0; 4299 }; 4300 String 2 // Name of Parameter 1 4301 { 4302 Text [ en-US ] = "array_x" ; 4303 }; 4304 String 3 // Description of Parameter 1 4305 { 4306 Text [ en-US ] = "First array where the square of the arguments are totalled." ; 4307 }; 4308 String 4 // Name of Parameter 2 4309 { 4310 Text [ en-US ] = "array_y" ; 4311 }; 4312 String 5 // Description of Parameter 2 4313 { 4314 Text [ en-US ] = "Second array where the square of the arguments is to be totalled." ; 4315 }; 4316 }; 4317 // -=*# Resource for function SUMMEXMY2 #*=- 4318 Resource SC_OPCODE_SUM_XMY2 4319 { 4320 String 1 // Description 4321 { 4322 Text [ en-US ] = "Returns the sum of squares of differences of two arrays." ; 4323 }; 4324 ExtraData = 4325 { 4326 0; 4327 ID_FUNCTION_GRP_MATRIX; 4328 U2S( HID_FUNC_SUMMEXMY2 ); 4329 2; 0; 0; 4330 0; 4331 }; 4332 String 2 // Name of Parameter 1 4333 { 4334 Text [ en-US ] = "array_x" ; 4335 }; 4336 String 3 // Description of Parameter 1 4337 { 4338 Text [ en-US ] = "First array for forming argument differences." ; 4339 }; 4340 String 4 // Name of Parameter 2 4341 { 4342 Text [ en-US ] = "array_y" ; 4343 }; 4344 String 5 // Description of Parameter 2 4345 { 4346 Text [ en-US ] = "Second array for forming the argument differences." ; 4347 }; 4348 }; 4349}; 4350 4351Resource RID_SC_FUNCTION_DESCRIPTIONS2 4352{ 4353 // -=*# Resource for function HÄUFIGKEIT #*=- 4354 Resource SC_OPCODE_FREQUENCY 4355 { 4356 String 1 // Description 4357 { 4358 Text [ en-US ] = "Returns a frequency distribution as a vertical array." ; 4359 }; 4360 ExtraData = 4361 { 4362 0; 4363 ID_FUNCTION_GRP_MATRIX; 4364 U2S( HID_FUNC_HAEUFIGKEIT ); 4365 2; 0; 0; 4366 0; 4367 }; 4368 String 2 // Name of Parameter 1 4369 { 4370 Text [ en-US ] = "data" ; 4371 }; 4372 String 3 // Description of Parameter 1 4373 { 4374 Text [ en-US ] = "The array of the data." ; 4375 }; 4376 String 4 // Name of Parameter 2 4377 { 4378 Text [ en-US ] = "classes" ; 4379 }; 4380 String 5 // Description of Parameter 2 4381 { 4382 Text [ en-US ] = "The array for forming classes." ; 4383 }; 4384 }; 4385 // -=*# Resource for function RGP #*=- 4386 Resource SC_OPCODE_RGP 4387 { 4388 String 1 // Description 4389 { 4390 Text [ en-US ] = "Calculates parameters of the linear regression as an array." ; 4391 }; 4392 ExtraData = 4393 { 4394 0; 4395 ID_FUNCTION_GRP_MATRIX; 4396 U2S( HID_FUNC_RGP ); 4397 4; 0; 1; 1; 1; 4398 0; 4399 }; 4400 String 2 // Name of Parameter 1 4401 { 4402 Text [ en-US ] = "data_Y" ; 4403 }; 4404 String 3 // Description of Parameter 1 4405 { 4406 Text [ en-US ] = "The Y data array." ; 4407 }; 4408 String 4 // Name of Parameter 2 4409 { 4410 Text [ en-US ] = "data_X" ; 4411 }; 4412 String 5 // Description of Parameter 2 4413 { 4414 Text [ en-US ] = "The X data array." ; 4415 }; 4416 String 6 // Name of Parameter 3 4417 { 4418 Text [ en-US ] = "Linear_type" ; 4419 }; 4420 String 7 // Description of Parameter 3 4421 { 4422 Text [ en-US ] = "If type = 0 the linears will be calculated through the zero point, or else moved linears." ; 4423 }; 4424 String 8 // Name of Parameter 4 4425 { 4426 Text [ en-US ] = "stats" ; 4427 }; 4428 String 9 // Description of Parameter 4 4429 { 4430 Text [ en-US ] = "If parameter = 0 then only the regression coefficient will be calculated, otherwise other values as well." ; 4431 }; 4432 }; 4433 // -=*# Resource for function RKP #*=- 4434 Resource SC_OPCODE_RKP 4435 { 4436 String 1 // Description 4437 { 4438 Text [ en-US ] = "Calculates the parameters of the exponential regression curve as an array." ; 4439 }; 4440 ExtraData = 4441 { 4442 0; 4443 ID_FUNCTION_GRP_MATRIX; 4444 U2S( HID_FUNC_RKP ); 4445 4; 0; 1; 1; 1; 4446 0; 4447 }; 4448 String 2 // Name of Parameter 1 4449 { 4450 Text [ en-US ] = "data_Y" ; 4451 }; 4452 String 3 // Description of Parameter 1 4453 { 4454 Text [ en-US ] = "The Y data array." ; 4455 }; 4456 String 4 // Name of Parameter 2 4457 { 4458 Text [ en-US ] = "data_X" ; 4459 }; 4460 String 5 // Description of Parameter 2 4461 { 4462 Text [ en-US ] = "The X data array." ; 4463 }; 4464 String 6 // Name of Parameter 3 4465 { 4466 Text [ en-US ] = "Function_type" ; 4467 }; 4468 String 7 // Description of Parameter 3 4469 { 4470 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." ; 4471 }; 4472 String 8 // Name of Parameter 4 4473 { 4474 Text [ en-US ] = "stats" ; 4475 }; 4476 String 9 // Description of Parameter 4 4477 { 4478 Text [ en-US ] = "If parameter = 0 then only the regression coefficient will be calculated, otherwise other values as well." ; 4479 }; 4480 }; 4481 // -=*# Resource for function TREND #*=- 4482 Resource SC_OPCODE_TREND 4483 { 4484 String 1 // Description 4485 { 4486 Text [ en-US ] = "Calculates points along a regression line." ; 4487 }; 4488 ExtraData = 4489 { 4490 0; 4491 ID_FUNCTION_GRP_MATRIX; 4492 U2S( HID_FUNC_TREND ); 4493 4; 0; 1; 1; 1; 4494 0; 4495 }; 4496 String 2 // Name of Parameter 1 4497 { 4498 Text [ en-US ] = "data_Y" ; 4499 }; 4500 String 3 // Description of Parameter 1 4501 { 4502 Text [ en-US ] = "The Y data array." ; 4503 }; 4504 String 4 // Name of Parameter 2 4505 { 4506 Text [ en-US ] = "data_X" ; 4507 }; 4508 String 5 // Description of Parameter 2 4509 { 4510 Text [ en-US ] = "The X data array as the basis for the regression." ; 4511 }; 4512 String 6 // Name of Parameter 3 4513 { 4514 Text [ en-US ] = "new data_X" ; 4515 }; 4516 String 7 // Description of Parameter 3 4517 { 4518 Text [ en-US ] = "The array of X data for recalculating the values." ; 4519 }; 4520 String 8 // Name of Parameter 4 4521 { 4522 Text [ en-US ] = "Linear_type" ; 4523 }; 4524 String 9 // Description of Parameter 4 4525 { 4526 Text [ en-US ] = "If type = 0 the linears will be calculated through the zero point, or else moved linears." ; 4527 }; 4528 }; 4529 // -=*# Resource for function VARIATION #*=- 4530 Resource SC_OPCODE_GROWTH 4531 { 4532 String 1 // Description 4533 { 4534 Text [ en-US ] = "Calculates points on the exponential regression function." ; 4535 }; 4536 ExtraData = 4537 { 4538 0; 4539 ID_FUNCTION_GRP_MATRIX; 4540 U2S( HID_FUNC_VARIATION ); 4541 4; 0; 1; 1; 1; 4542 0; 4543 }; 4544 String 2 // Name of Parameter 1 4545 { 4546 Text [ en-US ] = "data_Y" ; 4547 }; 4548 String 3 // Description of Parameter 1 4549 { 4550 Text [ en-US ] = "The Y data array." ; 4551 }; 4552 String 4 // Name of Parameter 2 4553 { 4554 Text [ en-US ] = "data_X" ; 4555 }; 4556 String 5 // Description of Parameter 2 4557 { 4558 Text [ en-US ] = "The X data array as the basis for the regression." ; 4559 }; 4560 String 6 // Name of Parameter 3 4561 { 4562 Text [ en-US ] = "new_data_X" ; 4563 }; 4564 String 7 // Description of Parameter 3 4565 { 4566 Text [ en-US ] = "The array of X data for recalculating the values." ; 4567 }; 4568 String 8 // Name of Parameter 4 4569 { 4570 Text [ en-US ] = "Function_type" ; 4571 }; 4572 String 9 // Description of Parameter 4 4573 { 4574 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." ; 4575 }; 4576 }; 4577 // -=*# Resource for function ANZAHL #*=- 4578 Resource SC_OPCODE_COUNT 4579 { 4580 String 1 // Description 4581 { 4582 Text [ en-US ] = "Counts how many numbers are in the list of arguments." ; 4583 }; 4584 ExtraData = 4585 { 4586 0; 4587 ID_FUNCTION_GRP_STATISTIC; 4588 U2S( HID_FUNC_ANZAHL ); 4589 VAR_ARGS; 0; 4590 0; 4591 }; 4592 String 2 // Name of Parameter 1 4593 { 4594 Text [ en-US ] = "value " ; 4595 }; 4596 String 3 // Description of Parameter 1 4597 { 4598 Text [ en-US ] = "Value 1, value 2, ... are 1 to 30 arguments containing different data types but where only numbers are counted." ; 4599 }; 4600 }; 4601 // -=*# Resource for function ANZAHL2 #*=- 4602 Resource SC_OPCODE_COUNT_2 4603 { 4604 String 1 // Description 4605 { 4606 Text [ en-US ] = "Counts how many values are in the list of arguments." ; 4607 }; 4608 ExtraData = 4609 { 4610 0; 4611 ID_FUNCTION_GRP_STATISTIC; 4612 U2S( HID_FUNC_ANZAHL2 ); 4613 VAR_ARGS; 0; 4614 0; 4615 }; 4616 String 2 // Name of Parameter 1 4617 { 4618 Text [ en-US ] = "value " ; 4619 }; 4620 String 3 // Description of Parameter 1 4621 { 4622 Text [ en-US ] = "Value 1, value 2, ... are 1 to 30 arguments representing the values to be counted." ; 4623 }; 4624 }; 4625 // -=*# Resource for function MAX #*=- 4626 Resource SC_OPCODE_MAX 4627 { 4628 String 1 // Description 4629 { 4630 Text [ en-US ] = "Returns the maximum value in a list of arguments." ; 4631 }; 4632 ExtraData = 4633 { 4634 0; 4635 ID_FUNCTION_GRP_STATISTIC; 4636 U2S( HID_FUNC_MAX ); 4637 VAR_ARGS; 0; 4638 0; 4639 }; 4640 String 2 // Name of Parameter 1 4641 { 4642 Text [ en-US ] = "number " ; 4643 }; 4644 String 3 // Description of Parameter 1 4645 { 4646 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments for which the largest number is to be determined." ; 4647 }; 4648 }; 4649 // -=*# Resource for function MAXA #*=- 4650 Resource SC_OPCODE_MAX_A 4651 { 4652 String 1 // Description 4653 { 4654 Text [ en-US ] = "Returns the maximum value in a list of arguments. Text is evaluated as Zero."; 4655 }; 4656 ExtraData = 4657 { 4658 0; 4659 ID_FUNCTION_GRP_STATISTIC; 4660 U2S( HID_FUNC_MAXA ); 4661 VAR_ARGS; 0; 4662 0; 4663 }; 4664 String 2 // Name of Parameter 1 4665 { 4666 Text [ en-US ] = "value "; 4667 }; 4668 String 3 // Description of Parameter 1 4669 { 4670 Text [ en-US ] = "Value 1, value 2, are 1 to 30 arguments whose largest value is to be determined."; 4671 }; 4672 }; 4673 // -=*# Resource for function MIN #*=- 4674 Resource SC_OPCODE_MIN 4675 { 4676 String 1 // Description 4677 { 4678 Text [ en-US ] = "Returns the minimum value in a list of arguments." ; 4679 }; 4680 ExtraData = 4681 { 4682 0; 4683 ID_FUNCTION_GRP_STATISTIC; 4684 U2S( HID_FUNC_MIN ); 4685 VAR_ARGS; 0; 4686 0; 4687 }; 4688 String 2 // Name of Parameter 1 4689 { 4690 Text [ en-US ] = "number " ; 4691 }; 4692 String 3 // Description of Parameter 1 4693 { 4694 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments for which the smallest number is to be determined." ; 4695 }; 4696 }; 4697 // -=*# Resource for function MINA #*=- 4698 Resource SC_OPCODE_MIN_A 4699 { 4700 String 1 // Description 4701 { 4702 Text [ en-US ] = "Returns the smallest value in a list of arguments. Text is evaluated as zero."; 4703 }; 4704 ExtraData = 4705 { 4706 0; 4707 ID_FUNCTION_GRP_STATISTIC; 4708 U2S( HID_FUNC_MINA ); 4709 VAR_ARGS; 0; 4710 0; 4711 }; 4712 String 2 // Name of Parameter 1 4713 { 4714 Text [ en-US ] = "value "; 4715 }; 4716 String 3 // Description of Parameter 1 4717 { 4718 Text [ en-US ] = "Value 1; value 2;... are 1 to 30 arguments whose smallest number is to be determined."; 4719 }; 4720 }; 4721 // -=*# Resource for function VARIANZ #*=- 4722 Resource SC_OPCODE_VAR 4723 { 4724 String 1 // Description 4725 { 4726 Text [ en-US ] = "Calculates the variance based on a sample." ; 4727 }; 4728 ExtraData = 4729 { 4730 0; 4731 ID_FUNCTION_GRP_STATISTIC; 4732 U2S( HID_FUNC_VARIANZ ); 4733 VAR_ARGS; 0; 4734 0; 4735 }; 4736 String 2 // Name of Parameter 1 4737 { 4738 Text [ en-US ] = "number " ; 4739 }; 4740 String 3 // Description of Parameter 1 4741 { 4742 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population." ; 4743 }; 4744 }; 4745 // -=*# Resource for function VARIANZ #*=- 4746 Resource SC_OPCODE_VAR_A 4747 { 4748 String 1 // Description 4749 { 4750 Text [ en-US ] = "Returns the variance based on a sample. Text is evaluated as zero."; 4751 }; 4752 ExtraData = 4753 { 4754 0; 4755 ID_FUNCTION_GRP_STATISTIC; 4756 U2S( HID_FUNC_VARIANZA ); 4757 VAR_ARGS; 0; 4758 0; 4759 }; 4760 String 2 // Name of Parameter 1 4761 { 4762 Text [ en-US ] = "value "; 4763 }; 4764 String 3 // Description of Parameter 1 4765 { 4766 Text [ en-US ] = "Value 1; value 2; ... are 1 to 30 arguments representing a sample taken from a basic total population."; 4767 }; 4768 }; 4769 // -=*# Resource for function VARIANZEN #*=- 4770 Resource SC_OPCODE_VAR_P 4771 { 4772 String 1 // Description 4773 { 4774 Text [ en-US ] = "Calculates variance based on the entire population." ; 4775 }; 4776 ExtraData = 4777 { 4778 0; 4779 ID_FUNCTION_GRP_STATISTIC; 4780 U2S( HID_FUNC_VARIANZEN ); 4781 VAR_ARGS; 0; 4782 0; 4783 }; 4784 String 2 // Name of Parameter 1 4785 { 4786 Text [ en-US ] = "number " ; 4787 }; 4788 String 3 // Description of Parameter 1 4789 { 4790 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which represent a population." ; 4791 }; 4792 }; 4793 // -=*# Resource for function VARIANZENA #*=- 4794 Resource SC_OPCODE_VAR_P_A 4795 { 4796 String 1 // Description 4797 { 4798 Text [ en-US ] = "Returns the variance based on the entire population. Text is evaluated as zero."; 4799 }; 4800 ExtraData = 4801 { 4802 0; 4803 ID_FUNCTION_GRP_STATISTIC; 4804 U2S( HID_FUNC_VARIANZENA ); 4805 VAR_ARGS; 0; 4806 0; 4807 }; 4808 String 2 // Name of Parameter 1 4809 { 4810 Text [ en-US ] = "value "; 4811 }; 4812 String 3 // Description of Parameter 1 4813 { 4814 Text [ en-US ] = "Value 1; value 2;... are 1 to 30 arguments representing a population."; 4815 }; 4816 }; 4817 // -=*# Resource for function STABW #*=- 4818 Resource SC_OPCODE_ST_DEV 4819 { 4820 String 1 // Description 4821 { 4822 Text [ en-US ] = "Calculates the standard deviation based on a sample." ; 4823 }; 4824 ExtraData = 4825 { 4826 0; 4827 ID_FUNCTION_GRP_STATISTIC; 4828 U2S( HID_FUNC_STABW ); 4829 VAR_ARGS; 0; 4830 0; 4831 }; 4832 String 2 // Name of Parameter 1 4833 { 4834 Text [ en-US ] = "number " ; 4835 }; 4836 String 3 // Description of Parameter 1 4837 { 4838 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population." ; 4839 }; 4840 }; 4841 // -=*# Resource for function STABWA #*=- 4842 Resource SC_OPCODE_ST_DEV_A 4843 { 4844 String 1 // Description 4845 { 4846 Text [ en-US ] = "Returns the standard deviation based on a sample. Text is evaluated as zero."; 4847 }; 4848 ExtraData = 4849 { 4850 0; 4851 ID_FUNCTION_GRP_STATISTIC; 4852 U2S( HID_FUNC_STABWA ); 4853 VAR_ARGS; 0; 4854 0; 4855 }; 4856 String 2 // Name of Parameter 1 4857 { 4858 Text [ en-US ] = "value "; 4859 }; 4860 String 3 // Description of Parameter 1 4861 { 4862 Text [ en-US ] = "Value 1; value 2; ... are 1 to 30 arguments representing a sample taken from a basic total population."; 4863 }; 4864 }; 4865 // -=*# Resource for function STABWN #*=- 4866 Resource SC_OPCODE_ST_DEV_P 4867 { 4868 String 1 // Description 4869 { 4870 Text [ en-US ] = "Calculates the standard deviation based on the entire population." ; 4871 }; 4872 ExtraData = 4873 { 4874 0; 4875 ID_FUNCTION_GRP_STATISTIC; 4876 U2S( HID_FUNC_STABWN ); 4877 VAR_ARGS; 0; 4878 0; 4879 }; 4880 String 2 // Name of Parameter 1 4881 { 4882 Text [ en-US ] = "number " ; 4883 }; 4884 String 3 // Description of Parameter 1 4885 { 4886 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample of a population." ; 4887 }; 4888 }; 4889 // -=*# Resource for function STABWNA #*=- 4890 Resource SC_OPCODE_ST_DEV_P_A 4891 { 4892 String 1 // Description 4893 { 4894 Text [ en-US ] = "Returns the standard deviation based on the entire population. Text is evaluated as zero."; 4895 }; 4896 ExtraData = 4897 { 4898 0; 4899 ID_FUNCTION_GRP_STATISTIC; 4900 U2S( HID_FUNC_STABWNA ); 4901 VAR_ARGS; 0; 4902 0; 4903 }; 4904 String 2 // Name of Parameter 1 4905 { 4906 Text [ en-US ] = "value "; 4907 }; 4908 String 3 // Description of Parameter 1 4909 { 4910 Text [ en-US ] = "Value 1; value 2;... are 1 to 30 arguments corresponding to a population."; 4911 }; 4912 }; 4913 // -=*# Resource for function MITTELWERT #*=- 4914 Resource SC_OPCODE_AVERAGE 4915 { 4916 String 1 // Description 4917 { 4918 Text [ en-US ] = "Returns the average of a sample." ; 4919 }; 4920 ExtraData = 4921 { 4922 0; 4923 ID_FUNCTION_GRP_STATISTIC; 4924 U2S( HID_FUNC_MITTELWERT ); 4925 VAR_ARGS; 0; 4926 0; 4927 }; 4928 String 2 // Name of Parameter 1 4929 { 4930 Text [ en-US ] = "number " ; 4931 }; 4932 String 3 // Description of Parameter 1 4933 { 4934 Text [ en-US ] = "Number 1, number 2;...are 1 to 30 numeric arguments representing a population sample." ; 4935 }; 4936 }; 4937 // -=*# Resource for function MITTELWERTA #*=- 4938 Resource SC_OPCODE_AVERAGE_A 4939 { 4940 String 1 // Description 4941 { 4942 Text [ en-US ] = "Returns the average value for a sample. Text is evaluated as zero."; 4943 }; 4944 ExtraData = 4945 { 4946 0; 4947 ID_FUNCTION_GRP_STATISTIC; 4948 U2S( HID_FUNC_MITTELWERTA ); 4949 VAR_ARGS; 0; 4950 0; 4951 }; 4952 String 2 // Name of Parameter 1 4953 { 4954 Text [ en-US ] = "value "; 4955 }; 4956 String 3 // Description of Parameter 1 4957 { 4958 Text [ en-US ] = "Value 1; value 2; ... are 1 to 30 arguments representing a sample taken from a basic total population."; 4959 }; 4960 }; 4961 // -=*# Resource for function SUMQUADABW #*=- 4962 Resource SC_OPCODE_DEV_SQ 4963 { 4964 String 1 // Description 4965 { 4966 Text [ en-US ] = "Returns the sum of squares of deviations from the sample mean value" ; 4967 }; 4968 ExtraData = 4969 { 4970 0; 4971 ID_FUNCTION_GRP_STATISTIC; 4972 U2S( HID_FUNC_SUMQUADABW ); 4973 VAR_ARGS; 0; 4974 0; 4975 }; 4976 String 2 // Name of Parameter 1 4977 { 4978 Text [ en-US ] = "number " ; 4979 }; 4980 String 3 // Description of Parameter 1 4981 { 4982 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ; 4983 }; 4984 }; 4985 // -=*# Resource for function MITTELABW #*=- 4986 Resource SC_OPCODE_AVE_DEV 4987 { 4988 String 1 // Description 4989 { 4990 Text [ en-US ] = "Returns the average of the absolute deviations of a sample from the mean." ; 4991 }; 4992 ExtraData = 4993 { 4994 0; 4995 ID_FUNCTION_GRP_STATISTIC; 4996 U2S( HID_FUNC_MITTELABW ); 4997 VAR_ARGS; 0; 4998 0; 4999 }; 5000 String 2 // Name of Parameter 1 5001 { 5002 Text [ en-US ] = "number " ; 5003 }; 5004 String 3 // Description of Parameter 1 5005 { 5006 Text [ en-US ] = "Number 1, number 2;...are 1 to 30 numerical arguments representing a sample." ; 5007 }; 5008 }; 5009 // -=*# Resource for function SCHIEFE #*=- 5010 Resource SC_OPCODE_SCHIEFE 5011 { 5012 String 1 // Description 5013 { 5014 Text [ en-US ] = "Returns the skewness of a distribution." ; 5015 }; 5016 ExtraData = 5017 { 5018 0; 5019 ID_FUNCTION_GRP_STATISTIC; 5020 U2S( HID_FUNC_SCHIEFE ); 5021 VAR_ARGS; 0; 5022 0; 5023 }; 5024 String 2 // Name of Parameter 1 5025 { 5026 Text [ en-US ] = "number " ; 5027 }; 5028 String 3 // Description of Parameter 1 5029 { 5030 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments portraying a sample of the distribution." ; 5031 }; 5032 }; 5033 // -=*# Resource for function KURT #*=- 5034 Resource SC_OPCODE_KURT 5035 { 5036 String 1 // Description 5037 { 5038 Text [ en-US ] = "Returns the kurtosis of a distribution." ; 5039 }; 5040 ExtraData = 5041 { 5042 0; 5043 ID_FUNCTION_GRP_STATISTIC; 5044 U2S( HID_FUNC_KURT ); 5045 VAR_ARGS; 0; 5046 0; 5047 }; 5048 String 2 // Name of Parameter 1 5049 { 5050 Text [ en-US ] = "number " ; 5051 }; 5052 String 3 // Description of Parameter 1 5053 { 5054 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments, representing a sample of the distribution." ; 5055 }; 5056 }; 5057 // -=*# Resource for function GEOMITTEL #*=- 5058 Resource SC_OPCODE_GEO_MEAN 5059 { 5060 String 1 // Description 5061 { 5062 Text [ en-US ] = "Returns the geometric mean of a sample." ; 5063 }; 5064 ExtraData = 5065 { 5066 0; 5067 ID_FUNCTION_GRP_STATISTIC; 5068 U2S( HID_FUNC_GEOMITTEL ); 5069 VAR_ARGS; 0; 5070 0; 5071 }; 5072 String 2 // Name of Parameter 1 5073 { 5074 Text [ en-US ] = "number " ; 5075 }; 5076 String 3 // Description of Parameter 1 5077 { 5078 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ; 5079 }; 5080 }; 5081 // -=*# Resource for function HARMITTEL #*=- 5082 Resource SC_OPCODE_HAR_MEAN 5083 { 5084 String 1 // Description 5085 { 5086 Text [ en-US ] = "Returns the harmonic mean of a sample." ; 5087 }; 5088 ExtraData = 5089 { 5090 0; 5091 ID_FUNCTION_GRP_STATISTIC; 5092 U2S( HID_FUNC_HARMITTEL ); 5093 VAR_ARGS; 0; 5094 0; 5095 }; 5096 String 2 // Name of Parameter 1 5097 { 5098 Text [ en-US ] = "number " ; 5099 }; 5100 String 3 // Description of Parameter 1 5101 { 5102 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ; 5103 }; 5104 }; 5105 // -=*# Resource for function MODALWERT #*=- 5106 Resource SC_OPCODE_MODAL_VALUE 5107 { 5108 String 1 // Description 5109 { 5110 Text [ en-US ] = "Returns the most common value in a sample." ; 5111 }; 5112 ExtraData = 5113 { 5114 0; 5115 ID_FUNCTION_GRP_STATISTIC; 5116 U2S( HID_FUNC_MODALWERT ); 5117 VAR_ARGS; 0; 5118 0; 5119 }; 5120 String 2 // Name of Parameter 1 5121 { 5122 Text [ en-US ] = "number " ; 5123 }; 5124 String 3 // Description of Parameter 1 5125 { 5126 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ; 5127 }; 5128 }; 5129 // -=*# Resource for function MEDIAN #*=- 5130 Resource SC_OPCODE_MEDIAN 5131 { 5132 String 1 // Description 5133 { 5134 Text [ en-US ] = "Returns the median of a given sample." ; 5135 }; 5136 ExtraData = 5137 { 5138 0; 5139 ID_FUNCTION_GRP_STATISTIC; 5140 U2S( HID_FUNC_MEDIAN ); 5141 VAR_ARGS; 0; 5142 0; 5143 }; 5144 String 2 // Name of Parameter 1 5145 { 5146 Text [ en-US ] = "number " ; 5147 }; 5148 String 3 // Description of Parameter 1 5149 { 5150 Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ; 5151 }; 5152 }; 5153 // -=*# Resource for function QUANTIL #*=- 5154 Resource SC_OPCODE_PERCENTILE 5155 { 5156 String 1 // Description 5157 { 5158 Text [ en-US ] = "Returns the alpha quantile of a sample." ; 5159 }; 5160 ExtraData = 5161 { 5162 0; 5163 ID_FUNCTION_GRP_STATISTIC; 5164 U2S( HID_FUNC_QUANTIL ); 5165 2; 0; 0; 5166 0; 5167 }; 5168 String 2 // Name of Parameter 1 5169 { 5170 Text [ en-US ] = "data" ; 5171 }; 5172 String 3 // Description of Parameter 1 5173 { 5174 Text [ en-US ] = "The array of the data in the sample." ; 5175 }; 5176 String 4 // Name of Parameter 2 5177 { 5178 Text [ en-US ] = "Alpha" ; 5179 }; 5180 String 5 // Description of Parameter 2 5181 { 5182 Text [ en-US ] = "The percentage rate of the quantile between 0 and 1." ; 5183 }; 5184 }; 5185 // -=*# Resource for function QUARTILE #*=- 5186 Resource SC_OPCODE_QUARTILE 5187 { 5188 String 1 // Description 5189 { 5190 Text [ en-US ] = "Returns the quartile of a sample." ; 5191 }; 5192 ExtraData = 5193 { 5194 0; 5195 ID_FUNCTION_GRP_STATISTIC; 5196 U2S( HID_FUNC_QUARTILE ); 5197 2; 0; 0; 5198 0; 5199 }; 5200 String 2 // Name of Parameter 1 5201 { 5202 Text [ en-US ] = "data" ; 5203 }; 5204 String 3 // Description of Parameter 1 5205 { 5206 Text [ en-US ] = "The array of the data in the sample." ; 5207 }; 5208 String 4 // Name of Parameter 2 5209 { 5210 Text [ en-US ] = "Type" ; 5211 }; 5212 String 5 // Description of Parameter 2 5213 { 5214 Text [ en-US ] = "The type of the quartile (0 = MIN, 1 = 25%, 2 = 50 %, 3 = 75 %, 4 =MAX)." ; 5215 }; 5216 }; 5217 // -=*# Resource for function KGRÖSSTE #*=- 5218 Resource SC_OPCODE_LARGE 5219 { 5220 String 1 // Description 5221 { 5222 Text [ en-US ] = "Returns the k-th largest value of a sample." ; 5223 }; 5224 ExtraData = 5225 { 5226 0; 5227 ID_FUNCTION_GRP_STATISTIC; 5228 U2S( HID_FUNC_KGROESSTE ); 5229 2; 0; 0; 5230 0; 5231 }; 5232 String 2 // Name of Parameter 1 5233 { 5234 Text [ en-US ] = "data" ; 5235 }; 5236 String 3 // Description of Parameter 1 5237 { 5238 Text [ en-US ] = "The array of the data in the sample." ; 5239 }; 5240 String 4 // Name of Parameter 2 5241 { 5242 Text [ en-US ] = "Rank_c" ; 5243 }; 5244 String 5 // Description of Parameter 2 5245 { 5246 Text [ en-US ] = "The ranking of the value." ; 5247 }; 5248 }; 5249 // -=*# Resource for function KKLEINSTE #*=- 5250 Resource SC_OPCODE_SMALL 5251 { 5252 String 1 // Description 5253 { 5254 Text [ en-US ] = "Returns the k-th smallest value of a sample." ; 5255 }; 5256 ExtraData = 5257 { 5258 0; 5259 ID_FUNCTION_GRP_STATISTIC; 5260 U2S( HID_FUNC_KKLEINSTE ); 5261 2; 0; 0; 5262 0; 5263 }; 5264 String 2 // Name of Parameter 1 5265 { 5266 Text [ en-US ] = "data" ; 5267 }; 5268 String 3 // Description of Parameter 1 5269 { 5270 Text [ en-US ] = "The array of the data in the sample." ; 5271 }; 5272 String 4 // Name of Parameter 2 5273 { 5274 Text [ en-US ] = "Rank_c" ; 5275 }; 5276 String 5 // Description of Parameter 2 5277 { 5278 Text [ en-US ] = "The ranking of the value." ; 5279 }; 5280 }; 5281 // -=*# Resource for function QUANTILSRANG #*=- 5282 Resource SC_OPCODE_PERCENT_RANK 5283 { 5284 String 1 // Description 5285 { 5286 Text [ en-US ] = "Returns the percentage rank of a value in a sample." ; 5287 }; 5288 ExtraData = 5289 { 5290 0; 5291 ID_FUNCTION_GRP_STATISTIC; 5292 U2S( HID_FUNC_QUANTILSRANG ); 5293 2; 0; 0; 5294 0; 5295 }; 5296 String 2 // Name of Parameter 1 5297 { 5298 Text [ en-US ] = "data" ; 5299 }; 5300 String 3 // Description of Parameter 1 5301 { 5302 Text [ en-US ] = "The array of the data in the sample." ; 5303 }; 5304 String 4 // Name of Parameter 2 5305 { 5306 Text [ en-US ] = "value" ; 5307 }; 5308 String 5 // Description of Parameter 2 5309 { 5310 Text [ en-US ] = "The value for which percentage ranking is to be determined." ; 5311 }; 5312 }; 5313 // -=*# Resource for function RANG #*=- 5314 Resource SC_OPCODE_RANK 5315 { 5316 String 1 // Description 5317 { 5318 Text [ en-US ] = "Returns the ranking of a value in a sample." ; 5319 }; 5320 ExtraData = 5321 { 5322 0; 5323 ID_FUNCTION_GRP_STATISTIC; 5324 U2S( HID_FUNC_RANG ); 5325 3; 0; 0; 1; 5326 0; 5327 }; 5328 String 2 // Name of Parameter 1 5329 { 5330 Text [ en-US ] = "value" ; 5331 }; 5332 String 3 // Description of Parameter 1 5333 { 5334 Text [ en-US ] = "The value for which the rank is to be determined." ; 5335 }; 5336 String 4 // Name of Parameter 2 5337 { 5338 Text [ en-US ] = "Data" ; 5339 }; 5340 String 5 // Description of Parameter 2 5341 { 5342 Text [ en-US ] = "The array of the data in the sample." ; 5343 }; 5344 String 6 // Name of Parameter 3 5345 { 5346 Text [ en-US ] = "Type" ; 5347 }; 5348 String 7 // Description of Parameter 3 5349 { 5350 Text [ en-US ] = "Sequence order: 0 or omitted means descending, any other value than 0 means ascending." ; 5351 }; 5352 }; 5353 // -=*# Resource for function GESTUTZTMITTEL #*=- 5354 Resource SC_OPCODE_TRIM_MEAN 5355 { 5356 String 1 // Description 5357 { 5358 Text [ en-US ] = "Returns the mean of a sample without including the marginal values." ; 5359 }; 5360 ExtraData = 5361 { 5362 0; 5363 ID_FUNCTION_GRP_STATISTIC; 5364 U2S( HID_FUNC_GESTUTZTMITTEL ); 5365 2; 0; 0; 5366 0; 5367 }; 5368 String 2 // Name of Parameter 1 5369 { 5370 Text [ en-US ] = "data" ; 5371 }; 5372 String 3 // Description of Parameter 1 5373 { 5374 Text [ en-US ] = "The array of the data in the sample." ; 5375 }; 5376 String 4 // Name of Parameter 2 5377 { 5378 Text [ en-US ] = "Alpha" ; 5379 }; 5380 String 5 // Description of Parameter 2 5381 { 5382 Text [ en-US ] = "The percentage of marginal data that is not to be taken into account." ; 5383 }; 5384 }; 5385 // -=*# Resource for function WAHRSCHBEREICH #*=- 5386 Resource SC_OPCODE_PROB 5387 { 5388 String 1 // Description 5389 { 5390 Text [ en-US ] = "Returns the discreet probability of an interval." ; 5391 }; 5392 ExtraData = 5393 { 5394 0; 5395 ID_FUNCTION_GRP_STATISTIC; 5396 U2S( HID_FUNC_WAHRSCHBEREICH ); 5397 4; 0; 0; 0; 1; 5398 0; 5399 }; 5400 String 2 // Name of Parameter 1 5401 { 5402 Text [ en-US ] = "data" ; 5403 }; 5404 String 3 // Description of Parameter 1 5405 { 5406 Text [ en-US ] = "The sample data array." ; 5407 }; 5408 String 4 // Name of Parameter 2 5409 { 5410 Text [ en-US ] = "probability" ; 5411 }; 5412 String 5 // Description of Parameter 2 5413 { 5414 Text [ en-US ] = "The array of the associated probabilities." ; 5415 }; 5416 String 6 // Name of Parameter 3 5417 { 5418 Text [ en-US ] = "Start" ; 5419 }; 5420 String 7 // Description of Parameter 3 5421 { 5422 Text [ en-US ] = "The start of the value interval whose probabilities is to be totalled." ; 5423 }; 5424 String 8 // Name of Parameter 4 5425 { 5426 Text [ en-US ] = "End" ; 5427 }; 5428 String 9 // Description of Parameter 4 5429 { 5430 Text [ en-US ] = "The end of the value interval where the probabilities are to be totalled." ; 5431 }; 5432 }; 5433 // -=*# Resource for function B #*=- 5434 Resource SC_OPCODE_B 5435 { 5436 String 1 // Description 5437 { 5438 Text [ en-US ] = "Returns the probability of a trial result using binomial distribution." ; 5439 }; 5440 ExtraData = 5441 { 5442 0; 5443 ID_FUNCTION_GRP_STATISTIC; 5444 U2S( HID_FUNC_B ); 5445 4; 0; 0; 0; 1; 5446 0; 5447 }; 5448 String 2 // Name of Parameter 1 5449 { 5450 Text [ en-US ] = "trials" ; 5451 }; 5452 String 3 // Description of Parameter 1 5453 { 5454 Text [ en-US ] = "The number of trials." ; 5455 }; 5456 String 4 // Name of Parameter 2 5457 { 5458 Text [ en-US ] = "SP" ; 5459 }; 5460 String 5 // Description of Parameter 2 5461 { 5462 Text [ en-US ] = "The individual probability of a trial result." ; 5463 }; 5464 String 6 // Name of Parameter 3 5465 { 5466 Text [ en-US ] = "T_1" ; 5467 }; 5468 String 7 // Description of Parameter 3 5469 { 5470 Text [ en-US ] = "Lower limit for the number of trials." ; 5471 }; 5472 String 8 // Name of Parameter 4 5473 { 5474 Text [ en-US ] = "T_2" ; 5475 }; 5476 String 9 // Description of Parameter 4 5477 { 5478 Text [ en-US ] = "Upper limit for the number of trials." ; 5479 }; 5480 }; 5481 // -=*# Resource for function PHI #*=- 5482 Resource SC_OPCODE_PHI 5483 { 5484 String 1 // Description 5485 { 5486 Text [ en-US ] = "Values of the distribution function for a standard normal distribution." ; 5487 }; 5488 ExtraData = 5489 { 5490 0; 5491 ID_FUNCTION_GRP_STATISTIC; 5492 U2S( HID_FUNC_PHI ); 5493 1; 0; 5494 0; 5495 }; 5496 String 2 // Name of Parameter 1 5497 { 5498 Text [ en-US ] = "number" ; 5499 }; 5500 String 3 // Description of Parameter 1 5501 { 5502 Text [ en-US ] = "The value for which the standard normal distribution is to be calculated." ; 5503 }; 5504 }; 5505 // -=*# Resource for function GAUSS #*=- 5506 Resource SC_OPCODE_GAUSS 5507 { 5508 String 1 // Description 5509 { 5510 Text [ en-US ] = "Returns the integral values of the standard normal cumulative distribution." ; 5511 }; 5512 ExtraData = 5513 { 5514 0; 5515 ID_FUNCTION_GRP_STATISTIC; 5516 U2S( HID_FUNC_GAUSS ); 5517 1; 0; 5518 0; 5519 }; 5520 String 2 // Name of Parameter 1 5521 { 5522 Text [ en-US ] = "Number" ; 5523 }; 5524 String 3 // Description of Parameter 1 5525 { 5526 Text [ en-US ] = "The value for which the integral value of the standard normal distribution is to be calculated." ; 5527 }; 5528 }; 5529 // -=*# Resource for function FISHER #*=- 5530 Resource SC_OPCODE_FISHER 5531 { 5532 String 1 // Description 5533 { 5534 Text [ en-US ] = "Returns the Fisher transformation." ; 5535 }; 5536 ExtraData = 5537 { 5538 0; 5539 ID_FUNCTION_GRP_STATISTIC; 5540 U2S( HID_FUNC_FISHER ); 5541 1; 0; 5542 0; 5543 }; 5544 String 2 // Name of Parameter 1 5545 { 5546 Text [ en-US ] = "Number" ; 5547 }; 5548 String 3 // Description of Parameter 1 5549 { 5550 Text [ en-US ] = "The value to be transformed (-1 < VALUE < 1)." ; 5551 }; 5552 }; 5553 // -=*# Resource for function FISHERINV #*=- 5554 Resource SC_OPCODE_FISHER_INV 5555 { 5556 String 1 // Description 5557 { 5558 Text [ en-US ] = "Returns the inverse of the Fisher transformation." ; 5559 }; 5560 ExtraData = 5561 { 5562 0; 5563 ID_FUNCTION_GRP_STATISTIC; 5564 U2S( HID_FUNC_FISHERINV ); 5565 1; 0; 5566 0; 5567 }; 5568 String 2 // Name of Parameter 1 5569 { 5570 Text [ en-US ] = "Number" ; 5571 }; 5572 String 3 // Description of Parameter 1 5573 { 5574 Text [ en-US ] = "The value that is to be transformed back." ; 5575 }; 5576 }; 5577 // -=*# Resource for function BINOMVERT #*=- 5578 Resource SC_OPCODE_BINOM_DIST 5579 { 5580 String 1 // Description 5581 { 5582 Text [ en-US ] = "Values of the binomial distribution." ; 5583 }; 5584 ExtraData = 5585 { 5586 0; 5587 ID_FUNCTION_GRP_STATISTIC; 5588 U2S( HID_FUNC_BINOMVERT ); 5589 4; 0; 0; 0; 0; 5590 0; 5591 }; 5592 String 2 // Name of Parameter 1 5593 { 5594 Text [ en-US ] = "X" ; 5595 }; 5596 String 3 // Description of Parameter 1 5597 { 5598 Text [ en-US ] = "The number of successes in a series of trials." ; 5599 }; 5600 String 4 // Name of Parameter 2 5601 { 5602 Text [ en-US ] = "trials" ; 5603 }; 5604 String 5 // Description of Parameter 2 5605 { 5606 Text [ en-US ] = "The total number of trials." ; 5607 }; 5608 String 6 // Name of Parameter 3 5609 { 5610 Text [ en-US ] = "SP" ; 5611 }; 5612 String 7 // Description of Parameter 3 5613 { 5614 Text [ en-US ] = "The success probability of a trial." ; 5615 }; 5616 String 8 // Name of Parameter 4 5617 { 5618 Text [ en-US ] = "C" ; 5619 }; 5620 String 9 // Description of Parameter 4 5621 { 5622 Text [ en-US ] = "Cumulated. C=0 calculates the individual probability, C=1 the cumulated probability." ; 5623 }; 5624 }; 5625 // -=*# Resource for function NEGBINOMVERT #*=- 5626 Resource SC_OPCODE_NEG_BINOM_VERT 5627 { 5628 String 1 // Description 5629 { 5630 Text [ en-US ] = "Values of the negative binomial distribution." ; 5631 }; 5632 ExtraData = 5633 { 5634 0; 5635 ID_FUNCTION_GRP_STATISTIC; 5636 U2S( HID_FUNC_NEGBINOMVERT ); 5637 3; 0; 0; 0; 5638 0; 5639 }; 5640 String 2 // Name of Parameter 1 5641 { 5642 Text [ en-US ] = "X" ; 5643 }; 5644 String 3 // Description of Parameter 1 5645 { 5646 Text [ en-US ] = "The number of failures in the trial range." ; 5647 }; 5648 String 4 // Name of Parameter 2 5649 { 5650 Text [ en-US ] = "R" ; 5651 }; 5652 String 5 // Description of Parameter 2 5653 { 5654 Text [ en-US ] = "The number of successes in the trial sequence." ; 5655 }; 5656 String 6 // Name of Parameter 3 5657 { 5658 Text [ en-US ] = "SP" ; 5659 }; 5660 String 7 // Description of Parameter 3 5661 { 5662 Text [ en-US ] = "The success probability of a trial." ; 5663 }; 5664 }; 5665 // -=*# Resource for function KRITBINOM #*=- 5666 Resource SC_OPCODE_KRIT_BINOM 5667 { 5668 String 1 // Description 5669 { 5670 Text [ en-US ] = "Border arguments of the binomial distribution." ; 5671 }; 5672 ExtraData = 5673 { 5674 0; 5675 ID_FUNCTION_GRP_STATISTIC; 5676 U2S( HID_FUNC_KRITBINOM ); 5677 3; 0; 0; 0; 5678 0; 5679 }; 5680 String 2 // Name of Parameter 1 5681 { 5682 Text [ en-US ] = "trials" ; 5683 }; 5684 String 3 // Description of Parameter 1 5685 { 5686 Text [ en-US ] = "The total number of trials." ; 5687 }; 5688 String 4 // Name of Parameter 2 5689 { 5690 Text [ en-US ] = "SP" ; 5691 }; 5692 String 5 // Description of Parameter 2 5693 { 5694 Text [ en-US ] = "The success probability of a trial." ; 5695 }; 5696 String 6 // Name of Parameter 3 5697 { 5698 Text [ en-US ] = "alpha" ; 5699 }; 5700 String 7 // Description of Parameter 3 5701 { 5702 Text [ en-US ] = "The border probability that is attained or exceeded." ; 5703 }; 5704 }; 5705 // -=*# Resource for function POISSON #*=- 5706 Resource SC_OPCODE_POISSON_DIST 5707 { 5708 String 1 // Description 5709 { 5710 Text [ en-US ] = "Returns the Poisson distribution." ; 5711 }; 5712 ExtraData = 5713 { 5714 0; 5715 ID_FUNCTION_GRP_STATISTIC; 5716 U2S( HID_FUNC_POISSON ); 5717 3; 0; 0; 1; 5718 0; 5719 }; 5720 String 2 // Name of Parameter 1 5721 { 5722 Text [ en-US ] = "Number" ; 5723 }; 5724 String 3 // Description of Parameter 1 5725 { 5726 Text [ en-US ] = "The value for which the Poisson distribution is to be calculated." ; 5727 }; 5728 String 4 // Name of Parameter 2 5729 { 5730 Text [ en-US ] = "mean" ; 5731 }; 5732 String 5 // Description of Parameter 2 5733 { 5734 Text [ en-US ] = "Mean. The mean value of the Poisson distribution." ; 5735 }; 5736 String 6 // Name of Parameter 3 5737 { 5738 Text [ en-US ] = "Cumulative" ; 5739 }; 5740 String 7 // Description of Parameter 3 5741 { 5742 Text [ en-US ] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ; 5743 }; 5744 }; 5745 // -=*# Resource for function NORMVERT #*=- 5746 Resource SC_OPCODE_NORM_DIST 5747 { 5748 String 1 // Description 5749 { 5750 Text [ en-US ] = "Values of the normal distribution." ; 5751 }; 5752 ExtraData = 5753 { 5754 0; 5755 ID_FUNCTION_GRP_STATISTIC; 5756 U2S( HID_FUNC_NORMVERT ); 5757 4; 0; 0; 0; 1; 5758 0; 5759 }; 5760 String 2 // Name of Parameter 1 5761 { 5762 Text [ en-US ] = "Number" ; 5763 }; 5764 String 3 // Description of Parameter 1 5765 { 5766 Text [ en-US ] = "The value for which the normal distribution is to be calculated." ; 5767 }; 5768 String 4 // Name of Parameter 2 5769 { 5770 Text [ en-US ] = "Mean" ; 5771 }; 5772 String 5 // Description of Parameter 2 5773 { 5774 Text [ en-US ] = "The mean value. The mean value of the normal distribution." ; 5775 }; 5776 String 6 // Name of Parameter 3 5777 { 5778 Text [ en-US ] = "STDEV" ; 5779 }; 5780 String 7 // Description of Parameter 3 5781 { 5782 Text [ en-US ] = "Standard deviation. The standard deviation of the normal distribution." ; 5783 }; 5784 String 8 // Name of Parameter 4 5785 { 5786 Text [ en-US ] = "C" ; 5787 }; 5788 String 9 // Description of Parameter 4 5789 { 5790 Text [ en-US ] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ; 5791 }; 5792 }; 5793 // -=*# Resource for function NORMINV #*=- 5794 Resource SC_OPCODE_NORM_INV 5795 { 5796 String 1 // Description 5797 { 5798 Text [ en-US ] = "Values of the inverse normal distribution." ; 5799 }; 5800 ExtraData = 5801 { 5802 0; 5803 ID_FUNCTION_GRP_STATISTIC; 5804 U2S( HID_FUNC_NORMINV ); 5805 3; 0; 0; 0; 5806 0; 5807 }; 5808 String 2 // Name of Parameter 1 5809 { 5810 Text [ en-US ] = "number" ; 5811 }; 5812 String 3 // Description of Parameter 1 5813 { 5814 Text [ en-US ] = "The probability value for which the inverse normal distribution is to be calculated." ; 5815 }; 5816 String 4 // Name of Parameter 2 5817 { 5818 Text [ en-US ] = "mean" ; 5819 }; 5820 String 5 // Description of Parameter 2 5821 { 5822 Text [ en-US ] = "The mean value. The mean value of the normal distribution." ; 5823 }; 5824 String 6 // Name of Parameter 3 5825 { 5826 Text [ en-US ] = "STDEV" ; 5827 }; 5828 String 7 // Description of Parameter 3 5829 { 5830 Text [ en-US ] = "Standard deviation. The standard deviation of the normal distribution." ; 5831 }; 5832 }; 5833 // -=*# Resource for function STANDNORMVERT #*=- 5834 Resource SC_OPCODE_STD_NORM_DIST 5835 { 5836 String 1 // Description 5837 { 5838 Text [ en-US ] = "The values of the standard normal cumulative distribution." ; 5839 }; 5840 ExtraData = 5841 { 5842 0; 5843 ID_FUNCTION_GRP_STATISTIC; 5844 U2S( HID_FUNC_STANDNORMVERT ); 5845 1; 0; 5846 0; 5847 }; 5848 String 2 // Name of Parameter 1 5849 { 5850 Text [ en-US ] = "Number" ; 5851 }; 5852 String 3 // Description of Parameter 1 5853 { 5854 Text [ en-US ] = "The value for which the standard normal distribution is to be calculated." ; 5855 }; 5856 }; 5857 // -=*# Resource for function STANDNORMINV #*=- 5858 Resource SC_OPCODE_S_NORM_INV 5859 { 5860 String 1 // Description 5861 { 5862 Text [ en-US ] = "Values of the inverse standard normal distribution." ; 5863 }; 5864 ExtraData = 5865 { 5866 0; 5867 ID_FUNCTION_GRP_STATISTIC; 5868 U2S( HID_FUNC_STANDNORMINV ); 5869 1; 0; 5870 0; 5871 }; 5872 String 2 // Name of Parameter 1 5873 { 5874 Text [ en-US ] = "number" ; 5875 }; 5876 String 3 // Description of Parameter 1 5877 { 5878 Text [ en-US ] = "The probability value for which the inverse standard normal distribution is to be calculated." ; 5879 }; 5880 }; 5881 // -=*# Resource for function LOGNORMVERT #*=- 5882 Resource SC_OPCODE_LOG_NORM_DIST 5883 { 5884 String 1 // Description 5885 { 5886 Text [ en-US ] = "Values of the log normal distribution." ; 5887 }; 5888 ExtraData = 5889 { 5890 0; 5891 ID_FUNCTION_GRP_STATISTIC; 5892 U2S( HID_FUNC_LOGNORMVERT ); 5893 4; 0; 1; 1; 1; 5894 0; 5895 }; 5896 String 2 // Name of Parameter 1 5897 { 5898 Text [ en-US ] = "Number" ; 5899 }; 5900 String 3 // Description of Parameter 1 5901 { 5902 Text [ en-US ] = "The value for which the log normal distribution is to be calculated." ; 5903 }; 5904 String 4 // Name of Parameter 2 5905 { 5906 Text [ en-US ] = "mean" ; 5907 }; 5908 String 5 // Description of Parameter 2 5909 { 5910 Text [ en-US ] = "The mean value of the log normal distribution. It is set to 0 if omitted." ; 5911 }; 5912 String 6 // Name of Parameter 3 5913 { 5914 Text [ en-US ] = "STDEV" ; 5915 }; 5916 String 7 // Description of Parameter 3 5917 { 5918 Text [ en-US ] = "The standard deviation of the log normal distribution. It is set to 1 if omitted." ; 5919 }; 5920 String 8 // Name of Parameter 4 5921 { 5922 Text [ en-US] = "Cumulative"; 5923 }; 5924 String 9 // Description of Parameter 4 5925 { 5926 Text [ en-US] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ; 5927 }; 5928 }; 5929 // -=*# Resource for function LOGINV #*=- 5930 Resource SC_OPCODE_LOG_INV 5931 { 5932 String 1 // Description 5933 { 5934 Text [ en-US ] = "Values of the inverse of the lognormal distribution." ; 5935 }; 5936 ExtraData = 5937 { 5938 0; 5939 ID_FUNCTION_GRP_STATISTIC; 5940 U2S( HID_FUNC_LOGINV ); 5941 3; 0; 0; 0; 5942 0; 5943 }; 5944 String 2 // Name of Parameter 1 5945 { 5946 Text [ en-US ] = "number" ; 5947 }; 5948 String 3 // Description of Parameter 1 5949 { 5950 Text [ en-US ] = "The probability value for which the inverse log normal distribution is to be calculated." ; 5951 }; 5952 String 4 // Name of Parameter 2 5953 { 5954 Text [ en-US ] = "mean" ; 5955 }; 5956 String 5 // Description of Parameter 2 5957 { 5958 Text [ en-US ] = "Mean value. The mean value of the log normal distribution." ; 5959 }; 5960 String 6 // Name of Parameter 3 5961 { 5962 Text [ en-US ] = "STDEV" ; 5963 }; 5964 String 7 // Description of Parameter 3 5965 { 5966 Text [ en-US ] = "Standard deviation. The standard deviation of the log normal distribution." ; 5967 }; 5968 }; 5969 // -=*# Resource for function EXPONVERT #*=- 5970 Resource SC_OPCODE_EXP_DIST 5971 { 5972 String 1 // Description 5973 { 5974 Text [ en-US ] = "Values of the exponential distribution." ; 5975 }; 5976 ExtraData = 5977 { 5978 0; 5979 ID_FUNCTION_GRP_STATISTIC; 5980 U2S( HID_FUNC_EXPONVERT ); 5981 3; 0; 0; 0; 5982 0; 5983 }; 5984 String 2 // Name of Parameter 1 5985 { 5986 Text [ en-US ] = "Number" ; 5987 }; 5988 String 3 // Description of Parameter 1 5989 { 5990 Text [ en-US ] = "The value to which the exponential distribution is to be calculated." ; 5991 }; 5992 String 4 // Name of Parameter 2 5993 { 5994 Text [ en-US ] = "lambda" ; 5995 }; 5996 String 5 // Description of Parameter 2 5997 { 5998 Text [ en-US ] = "The parameters of the exponential distribution." ; 5999 }; 6000 String 6 // Name of Parameter 3 6001 { 6002 Text [ en-US ] = "C" ; 6003 }; 6004 String 7 // Description of Parameter 3 6005 { 6006 Text [ en-US ] = "Cumulated. C=0 calculates the density function, C=1 the distribution." ; 6007 }; 6008 }; 6009 // -=*# Resource for function GAMMAVERT #*=- 6010 Resource SC_OPCODE_GAMMA_DIST 6011 { 6012 String 1 // Description 6013 { 6014 Text [ en-US ] = "Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution." ; 6015 }; 6016 ExtraData = 6017 { 6018 0; 6019 ID_FUNCTION_GRP_STATISTIC; 6020 U2S( HID_FUNC_GAMMAVERT ); 6021 4; 0; 0; 0; 1; 6022 0; 6023 }; 6024 String 2 // Name of Parameter 1 6025 { 6026 Text [ en-US ] = "Number" ; 6027 }; 6028 String 3 // Description of Parameter 1 6029 { 6030 Text [ en-US ] = "The value for which the gamma distribution is to be calculated." ; 6031 }; 6032 String 4 // Name of Parameter 2 6033 { 6034 Text [ en-US ] = "alpha" ; 6035 }; 6036 String 5 // Description of Parameter 2 6037 { 6038 Text [ en-US ] = "The Alpha parameter of the Gamma distribution." ; 6039 }; 6040 String 6 // Name of Parameter 3 6041 { 6042 Text [ en-US ] = "beta" ; 6043 }; 6044 String 7 // Description of Parameter 3 6045 { 6046 Text [ en-US ] = "The Beta parameter of the Gamma distribution." ; 6047 }; 6048 String 8 // Name of Parameter 4 6049 { 6050 Text [ en-US ] = "Cumulative" ; 6051 }; 6052 String 9 // Description of Parameter 4 6053 { 6054 Text [ en-US ] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ; 6055 }; 6056 }; 6057 // -=*# Resource for function GAMMAINV #*=- 6058 Resource SC_OPCODE_GAMMA_INV 6059 { 6060 String 1 // Description 6061 { 6062 Text [ en-US ] = "Values of the inverse gamma distribution." ; 6063 }; 6064 ExtraData = 6065 { 6066 0; 6067 ID_FUNCTION_GRP_STATISTIC; 6068 U2S( HID_FUNC_GAMMAINV ); 6069 3; 0; 0; 0; 6070 0; 6071 }; 6072 String 2 // Name of Parameter 1 6073 { 6074 Text [ en-US ] = "Number" ; 6075 }; 6076 String 3 // Description of Parameter 1 6077 { 6078 Text [ en-US ] = "The probability value for which the inverse gamma distribution is to be calculated." ; 6079 }; 6080 String 4 // Name of Parameter 2 6081 { 6082 Text [ en-US ] = "alpha" ; 6083 }; 6084 String 5 // Description of Parameter 2 6085 { 6086 Text [ en-US ] = "The Alpha (shape) parameter of the Gamma distribution." ; 6087 }; 6088 String 6 // Name of Parameter 3 6089 { 6090 Text [ en-US ] = "beta" ; 6091 }; 6092 String 7 // Description of Parameter 3 6093 { 6094 Text [ en-US ] = "The Beta (scale) parameter of the Gamma distribution." ; 6095 }; 6096 }; 6097 // -=*# Resource for function GAMMALN #*=- 6098 Resource SC_OPCODE_GAMMA_LN 6099 { 6100 String 1 // Description 6101 { 6102 Text [ en-US ] = "Returns the natural logarithm of the gamma function." ; 6103 }; 6104 ExtraData = 6105 { 6106 0; 6107 ID_FUNCTION_GRP_STATISTIC; 6108 U2S( HID_FUNC_GAMMALN ); 6109 1; 0; 6110 0; 6111 }; 6112 String 2 // Name of Parameter 1 6113 { 6114 Text [ en-US ] = "Number" ; 6115 }; 6116 String 3 // Description of Parameter 1 6117 { 6118 Text [ en-US ] = "The value for which the natural logarithm of the gamma function is to be calculated." ; 6119 }; 6120 }; 6121 6122 // -=*# Resource for function GAMMA #*=- 6123 Resource SC_OPCODE_GAMMA 6124 { 6125 String 1 // Description 6126 { 6127 Text [ en-US ] = "Returns the value of the Gamma function." ; 6128 }; 6129 ExtraData = 6130 { 6131 0; 6132 ID_FUNCTION_GRP_STATISTIC; 6133 U2S( HID_FUNC_GAMMA ); 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 Gamma function is to be calculated." ; 6144 }; 6145 }; 6146 6147 // -=*# Resource for function BETAVERT #*=- 6148 Resource SC_OPCODE_BETA_DIST 6149 { 6150 String 1 // Description 6151 { 6152 Text [ en-US ] = "Values of the beta distribution." ; 6153 }; 6154 ExtraData = 6155 { 6156 0; 6157 ID_FUNCTION_GRP_STATISTIC; 6158 U2S( HID_FUNC_BETAVERT ); 6159 6; 0; 0; 0; 1; 1; 1; 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 beta distribution is to be calculated." ; 6169 }; 6170 String 4 // Name of Parameter 2 6171 { 6172 Text [ en-US ] = "alpha" ; 6173 }; 6174 String 5 // Description of Parameter 2 6175 { 6176 Text [ en-US ] = "The Alpha parameter of the Beta distribution." ; 6177 }; 6178 String 6 // Name of Parameter 3 6179 { 6180 Text [ en-US ] = "beta" ; 6181 }; 6182 String 7 // Description of Parameter 3 6183 { 6184 Text [ en-US ] = "The Beta parameter of the Beta distribution." ; 6185 }; 6186 String 8 // Name of Parameter 4 6187 { 6188 Text [ en-US ] = "Start" ; 6189 }; 6190 String 9 // Description of Parameter 4 6191 { 6192 Text [ en-US ] = "The starting value for the value interval of the distribution." ; 6193 }; 6194 String 10 // Name of Parameter 5 6195 { 6196 Text [ en-US ] = "End" ; 6197 }; 6198 String 11 // Description of Parameter 5 6199 { 6200 Text [ en-US ] = "The final value for the value interval of the distribution." ; 6201 }; 6202 String 12 // Name of Parameter 6 6203 { 6204 Text [en-US ] = "Cumulative" ; 6205 }; 6206 String 13 // Description of Parameter 6 6207 { 6208 Text [ en-US ] = "0 or FALSE for probability density function, any other value or TRUE or omitted for cumulative distribution function."; 6209 }; 6210 }; 6211 // -=*# Resource for function BETAINV #*=- 6212 Resource SC_OPCODE_BETA_INV 6213 { 6214 String 1 // Description 6215 { 6216 Text [ en-US ] = "Values of the inverse beta distribution." ; 6217 }; 6218 ExtraData = 6219 { 6220 0; 6221 ID_FUNCTION_GRP_STATISTIC; 6222 U2S( HID_FUNC_BETAINV ); 6223 5; 0; 0; 0; 1; 1; 6224 0; 6225 }; 6226 String 2 // Name of Parameter 1 6227 { 6228 Text [ en-US ] = "number" ; 6229 }; 6230 String 3 // Description of Parameter 1 6231 { 6232 Text [ en-US ] = "The probability value for which the inverse beta distribution is to be calculated." ; 6233 }; 6234 String 4 // Name of Parameter 2 6235 { 6236 Text [ en-US ] = "alpha" ; 6237 }; 6238 String 5 // Description of Parameter 2 6239 { 6240 Text [ en-US ] = "The Alpha parameter of the Beta distribution." ; 6241 }; 6242 String 6 // Name of Parameter 3 6243 { 6244 Text [ en-US ] = "beta" ; 6245 }; 6246 String 7 // Description of Parameter 3 6247 { 6248 Text [ en-US ] = "The Beta parameter of the Beta distribution." ; 6249 }; 6250 String 8 // Name of Parameter 4 6251 { 6252 Text [ en-US ] = "Start" ; 6253 }; 6254 String 9 // Description of Parameter 4 6255 { 6256 Text [ en-US ] = "The starting value for the value interval of the distribution." ; 6257 }; 6258 String 10 // Name of Parameter 5 6259 { 6260 Text [ en-US ] = "End" ; 6261 }; 6262 String 11 // Description of Parameter 5 6263 { 6264 Text [ en-US ] = "The final value for the value interval of the distribution." ; 6265 }; 6266 }; 6267 // -=*# Resource for function WEIBULL #*=- 6268 Resource SC_OPCODE_WEIBULL 6269 { 6270 String 1 // Description 6271 { 6272 Text [ en-US ] = "Returns the values of the Weibull distribution." ; 6273 }; 6274 ExtraData = 6275 { 6276 0; 6277 ID_FUNCTION_GRP_STATISTIC; 6278 U2S( HID_FUNC_WEIBULL ); 6279 4; 0; 0; 0; 0; 6280 0; 6281 }; 6282 String 2 // Name of Parameter 1 6283 { 6284 Text [ en-US ] = "Number" ; 6285 }; 6286 String 3 // Description of Parameter 1 6287 { 6288 Text [ en-US ] = "The value for which the Weibull distribution is to be calculated." ; 6289 }; 6290 String 4 // Name of Parameter 2 6291 { 6292 Text [ en-US ] = "Alpha" ; 6293 }; 6294 String 5 // Description of Parameter 2 6295 { 6296 Text [ en-US ] = "The Alpha parameter of the Weibull distribution." ; 6297 }; 6298 String 6 // Name of Parameter 3 6299 { 6300 Text [ en-US ] = "beta" ; 6301 }; 6302 String 7 // Description of Parameter 3 6303 { 6304 Text [ en-US ] = "The Beta parameter of the Weibull distribution." ; 6305 }; 6306 String 8 // Name of Parameter 4 6307 { 6308 Text [ en-US ] = "C" ; 6309 }; 6310 String 9 // Description of Parameter 4 6311 { 6312 Text [ en-US ] = "Cumulated. C=0 calculates the density function, C=1 the distribution." ; 6313 }; 6314 }; 6315 // -=*# Resource for function HYPGEOMVERT #*=- 6316 Resource SC_OPCODE_HYP_GEOM_DIST 6317 { 6318 String 1 // Description 6319 { 6320 Text [ en-US ] = "Values of the hypergeometric distribution." ; 6321 }; 6322 ExtraData = 6323 { 6324 0; 6325 ID_FUNCTION_GRP_STATISTIC; 6326 U2S( HID_FUNC_HYPGEOMVERT ); 6327 4; 0; 0; 0; 0; 6328 0; 6329 }; 6330 String 2 // Name of Parameter 1 6331 { 6332 Text [ en-US ] = "X" ; 6333 }; 6334 String 3 // Description of Parameter 1 6335 { 6336 Text [ en-US ] = "The number of successes in the sample." ; 6337 }; 6338 String 4 // Name of Parameter 2 6339 { 6340 Text [ en-US ] = "n_sample" ; 6341 }; 6342 String 5 // Description of Parameter 2 6343 { 6344 Text [ en-US ] = "The size of the sample." ; 6345 }; 6346 String 6 // Name of Parameter 3 6347 { 6348 Text [ en-US ] = "successes" ; 6349 }; 6350 String 7 // Description of Parameter 3 6351 { 6352 Text [ en-US ] = "The number of successes in the population." ; 6353 }; 6354 String 8 // Name of Parameter 4 6355 { 6356 Text [ en-US ] = "n_population" ; 6357 }; 6358 String 9 // Description of Parameter 4 6359 { 6360 Text [ en-US ] = "The population size." ; 6361 }; 6362 }; 6363 // -=*# Resource for function TVERT #*=- 6364 Resource SC_OPCODE_T_DIST 6365 { 6366 String 1 // Description 6367 { 6368 Text [ en-US ] = "Returns the t-distribution." ; 6369 }; 6370 ExtraData = 6371 { 6372 0; 6373 ID_FUNCTION_GRP_STATISTIC; 6374 U2S( HID_FUNC_TVERT ); 6375 3; 0; 0; 0; 6376 0; 6377 }; 6378 String 2 // Name of Parameter 1 6379 { 6380 Text [ en-US ] = "Number" ; 6381 }; 6382 String 3 // Description of Parameter 1 6383 { 6384 Text [ en-US ] = "The value for which the T distribution is to be calculated." ; 6385 }; 6386 String 4 // Name of Parameter 2 6387 { 6388 Text [ en-US ] = "degrees_freedom" ; 6389 }; 6390 String 5 // Description of Parameter 2 6391 { 6392 Text [ en-US ] = "The degrees of freedom of the T distribution." ; 6393 }; 6394 String 6 // Name of Parameter 3 6395 { 6396 Text [ en-US ] = "mode" ; 6397 }; 6398 String 7 // Description of Parameter 3 6399 { 6400 Text [ en-US ] = "Mode = 1 calculates the one-tailed test, 2 = two-tailed distribution." ; 6401 }; 6402 }; 6403 // -=*# Resource for function TINV #*=- 6404 Resource SC_OPCODE_T_INV 6405 { 6406 String 1 // Description 6407 { 6408 Text [ en-US ] = "Values of the inverse t-distribution." ; 6409 }; 6410 ExtraData = 6411 { 6412 0; 6413 ID_FUNCTION_GRP_STATISTIC; 6414 U2S( HID_FUNC_TINV ); 6415 2; 0; 0; 6416 0; 6417 }; 6418 String 2 // Name of Parameter 1 6419 { 6420 Text [ en-US ] = "number" ; 6421 }; 6422 String 3 // Description of Parameter 1 6423 { 6424 Text [ en-US ] = "The probability value for which the inverse T distribution is to be calculated." ; 6425 }; 6426 String 4 // Name of Parameter 2 6427 { 6428 Text [ en-US ] = "degrees_freedom" ; 6429 }; 6430 String 5 // Description of Parameter 2 6431 { 6432 Text [ en-US ] = "The degrees of freedom of the T distribution." ; 6433 }; 6434 }; 6435 // -=*# Resource for function FVERT #*=- 6436 Resource SC_OPCODE_F_DIST 6437 { 6438 String 1 // Description 6439 { 6440 Text [ en-US ] = "Values of the F probability distribution." ; 6441 }; 6442 ExtraData = 6443 { 6444 0; 6445 ID_FUNCTION_GRP_STATISTIC; 6446 U2S( HID_FUNC_FVERT ); 6447 3; 0; 0; 0; 6448 0; 6449 }; 6450 String 2 // Name of Parameter 1 6451 { 6452 Text [ en-US ] = "Number" ; 6453 }; 6454 String 3 // Description of Parameter 1 6455 { 6456 Text [ en-US ] = "The value for which the F distribution is to be calculated." ; 6457 }; 6458 String 4 // Name of Parameter 2 6459 { 6460 Text [ en-US ] = "degrees_freedom_1" ; 6461 }; 6462 String 5 // Description of Parameter 2 6463 { 6464 Text [ en-US ] = "The degrees of freedom in the numerator of the F distribution." ; 6465 }; 6466 String 6 // Name of Parameter 3 6467 { 6468 Text [ en-US ] = "degrees_freedom_2" ; 6469 }; 6470 String 7 // Description of Parameter 3 6471 { 6472 Text [ en-US ] = "The degrees of freedom in the denominator of the F distribution." ; 6473 }; 6474 }; 6475 // -=*# Resource for function FINV #*=- 6476 Resource SC_OPCODE_F_INV 6477 { 6478 String 1 // Description 6479 { 6480 Text [ en-US ] = "Values of the inverse F distribution." ; 6481 }; 6482 ExtraData = 6483 { 6484 0; 6485 ID_FUNCTION_GRP_STATISTIC; 6486 U2S( HID_FUNC_FINV ); 6487 3; 0; 0; 0; 6488 0; 6489 }; 6490 String 2 // Name of Parameter 1 6491 { 6492 Text [ en-US ] = "number" ; 6493 }; 6494 String 3 // Description of Parameter 1 6495 { 6496 Text [ en-US ] = "The probability value for which the inverse F distribution is to be calculated." ; 6497 }; 6498 String 4 // Name of Parameter 2 6499 { 6500 Text [ en-US ] = "degrees_freedom_1" ; 6501 }; 6502 String 5 // Description of Parameter 2 6503 { 6504 Text [ en-US ] = "The degrees of freedom in the numerator of the F distribution." ; 6505 }; 6506 String 6 // Name of Parameter 3 6507 { 6508 Text [ en-US ] = "degrees_freedom_2" ; 6509 }; 6510 String 7 // Description of Parameter 3 6511 { 6512 Text [ en-US ] = "The degrees of freedom in the denominator of the F distribution." ; 6513 }; 6514 }; 6515 // -=*# Resource for function CHIVERT #*=- 6516 Resource SC_OPCODE_CHI_DIST 6517 { 6518 String 1 // Description 6519 { 6520 Text [ en-US ] = "Returns the right-tail probability of the chi-square distribution." ; 6521 }; 6522 ExtraData = 6523 { 6524 0; 6525 ID_FUNCTION_GRP_STATISTIC; 6526 U2S( HID_FUNC_CHIVERT ); 6527 2; 0; 0; 6528 0; 6529 }; 6530 String 2 // Name of Parameter 1 6531 { 6532 Text [ en-US ] = "Number" ; 6533 }; 6534 String 3 // Description of Parameter 1 6535 { 6536 Text [ en-US ] = "The value for which the chi square distribution is to be calculated." ; 6537 }; 6538 String 4 // Name of Parameter 2 6539 { 6540 Text [ en-US ] = "degrees_freedom" ; 6541 }; 6542 String 5 // Description of Parameter 2 6543 { 6544 Text [ en-US ] = "The degrees of freedom of the chi square distribution." ; 6545 }; 6546 }; 6547 6548 // -=*# Resource for function CHISQDIST #*=- 6549 Resource SC_OPCODE_CHISQ_DIST 6550 { 6551 String 1 // Description 6552 { 6553 Text [ en-US ] = "Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution." ; 6554 }; 6555 ExtraData = 6556 { 6557 0; 6558 ID_FUNCTION_GRP_STATISTIC; 6559 U2S( HID_FUNC_CHISQDIST ); 6560 3; 0; 0; 1; 6561 0; 6562 }; 6563 String 2 // Name of Parameter 1 6564 { 6565 Text [ en-US ] = "Number" ; 6566 }; 6567 String 3 // Description of Parameter 1 6568 { 6569 Text [ en-US ] = "The value for which the probability density function or cumulative distribution function is to be calculated." ; 6570 }; 6571 String 4 // Name of Parameter 2 6572 { 6573 Text [ en-US ] = "Degrees of Freedom" ; 6574 }; 6575 String 5 // Description of Parameter 2 6576 { 6577 Text [ en-US ] = "The degrees of freedom of the chi-square distribution." ; 6578 }; 6579 String 6 // Name of Parameter 3 6580 { 6581 Text [ en-US ] = "Cumulative" ; 6582 }; 6583 String 7 // Description of Parameter 3 6584 { 6585 Text [ en-US ] = "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function." ; 6586 }; 6587 }; 6588 6589 6590 // -=*# Resource for function CHIINV #*=- 6591 Resource SC_OPCODE_CHI_INV 6592 { 6593 String 1 // Description 6594 { 6595 Text [ en-US ] = "Values of the inverse of CHIDIST(x; DegreesOfFreedom)." ; 6596 }; 6597 ExtraData = 6598 { 6599 0; 6600 ID_FUNCTION_GRP_STATISTIC; 6601 U2S( HID_FUNC_CHIINV ); 6602 2; 0; 0; 6603 0; 6604 }; 6605 String 2 // Name of Parameter 1 6606 { 6607 Text [ en-US ] = "number" ; 6608 }; 6609 String 3 // Description of Parameter 1 6610 { 6611 Text [ en-US ] = "The probability value for which the inverse chi square distribution is to be calculated." ; 6612 }; 6613 String 4 // Name of Parameter 2 6614 { 6615 Text [ en-US ] = "degrees_freedom" ; 6616 }; 6617 String 5 // Description of Parameter 2 6618 { 6619 Text [ en-US ] = "The degrees of freedom of the chi square distribution." ; 6620 }; 6621 }; 6622 6623 // -=*# Resource for function CHISQINV #*=- 6624 Resource SC_OPCODE_CHISQ_INV 6625 { 6626 String 1 // Description 6627 { 6628 Text [ en-US ] = "Values of the inverse of CHISQDIST(x;DegreesOfFreedom;TRUE())." ; 6629 }; 6630 ExtraData = 6631 { 6632 0; 6633 ID_FUNCTION_GRP_STATISTIC; 6634 U2S( HID_FUNC_CHISQINV ); 6635 2; 0; 0; 6636 0; 6637 }; 6638 String 2 // Name of Parameter 1 6639 { 6640 Text [ en-US ] = "Probability" ; 6641 }; 6642 String 3 // Description of Parameter 1 6643 { 6644 Text [ en-US ] = "The probability value for which the inverse of the chi square distribution is to be calculated." ; 6645 }; 6646 String 4 // Name of Parameter 2 6647 { 6648 Text [ en-US ] = "Degrees of Freedom" ; 6649 }; 6650 String 5 // Description of Parameter 2 6651 { 6652 Text [ en-US ] = "The degrees of freedom of the chi square distribution." ; 6653 }; 6654 }; 6655 6656 // -=*# Resource for function STANDARDISIERUNG #*=- 6657 Resource SC_OPCODE_STANDARD 6658 { 6659 String 1 // Description 6660 { 6661 Text [ en-US ] = "Converts a random variable to a normalized value." ; 6662 }; 6663 ExtraData = 6664 { 6665 0; 6666 ID_FUNCTION_GRP_STATISTIC; 6667 U2S( HID_FUNC_STANDARDISIERUNG ); 6668 3; 0; 0; 0; 6669 0; 6670 }; 6671 String 2 // Name of Parameter 1 6672 { 6673 Text [ en-US ] = "Number" ; 6674 }; 6675 String 3 // Description of Parameter 1 6676 { 6677 Text [ en-US ] = "The value to be standardized." ; 6678 }; 6679 String 4 // Name of Parameter 2 6680 { 6681 Text [ en-US ] = "mean" ; 6682 }; 6683 String 5 // Description of Parameter 2 6684 { 6685 Text [ en-US ] = "The mean value used for moving." ; 6686 }; 6687 String 6 // Name of Parameter 3 6688 { 6689 Text [ en-US ] = "STDEV" ; 6690 }; 6691 String 7 // Description of Parameter 3 6692 { 6693 Text [ en-US ] = "The standard deviation used for scaling." ; 6694 }; 6695 }; 6696 // -=*# Resource for function VARIATIONEN #*=- 6697 Resource SC_OPCODE_VARIATIONEN 6698 { 6699 String 1 // Description 6700 { 6701 Text [ en-US ] = "Returns the number of permutations for a given number of elements without repetition." ; 6702 }; 6703 ExtraData = 6704 { 6705 0; 6706 ID_FUNCTION_GRP_STATISTIC; 6707 U2S( HID_FUNC_VARIATIONEN ); 6708 2; 0; 0; 6709 0; 6710 }; 6711 String 2 // Name of Parameter 1 6712 { 6713 Text [ en-US ] = "Count_1" ; 6714 }; 6715 String 3 // Description of Parameter 1 6716 { 6717 Text [ en-US ] = "The total number of elements." ; 6718 }; 6719 String 4 // Name of Parameter 2 6720 { 6721 Text [ en-US ] = "Count_2" ; 6722 }; 6723 String 5 // Description of Parameter 2 6724 { 6725 Text [ en-US ] = "The selection number taken from the elements." ; 6726 }; 6727 }; 6728 // -=*# Resource for function VARIATIONEN2 #*=- 6729 Resource SC_OPCODE_VARIATIONEN_2 6730 { 6731 String 1 // Description 6732 { 6733 Text [ en-US ] = "Returns the number of permutations for a given number of objects (repetition allowed)." ; 6734 }; 6735 ExtraData = 6736 { 6737 0; 6738 ID_FUNCTION_GRP_STATISTIC; 6739 U2S( HID_FUNC_VARIATIONEN2 ); 6740 2; 0; 0; 6741 0; 6742 }; 6743 String 2 // Name of Parameter 1 6744 { 6745 Text [ en-US ] = "Count_1" ; 6746 }; 6747 String 3 // Description of Parameter 1 6748 { 6749 Text [ en-US ] = "The total number of elements." ; 6750 }; 6751 String 4 // Name of Parameter 2 6752 { 6753 Text [ en-US ] = "Count_2" ; 6754 }; 6755 String 5 // Description of Parameter 2 6756 { 6757 Text [ en-US ] = "The selection number taken from the elements." ; 6758 }; 6759 }; 6760 // -=*# Resource for function KONFIDENZ #*=- 6761 Resource SC_OPCODE_CONFIDENCE 6762 { 6763 String 1 // Description 6764 { 6765 Text [ en-US ] = "Returns a (1 alpha) confidence interval for a normal distribution." ; 6766 }; 6767 ExtraData = 6768 { 6769 0; 6770 ID_FUNCTION_GRP_STATISTIC; 6771 U2S( HID_FUNC_KONFIDENZ ); 6772 3; 0; 0; 0; 6773 0; 6774 }; 6775 String 2 // Name of Parameter 1 6776 { 6777 Text [ en-US ] = "alpha" ; 6778 }; 6779 String 3 // Description of Parameter 1 6780 { 6781 Text [ en-US ] = "The level of the confidence interval." ; 6782 }; 6783 String 4 // Name of Parameter 2 6784 { 6785 Text [ en-US ] = "STDEV" ; 6786 }; 6787 String 5 // Description of Parameter 2 6788 { 6789 Text [ en-US ] = "The standard deviation of the population." ; 6790 }; 6791 String 6 // Name of Parameter 3 6792 { 6793 Text [ en-US ] = "size" ; 6794 }; 6795 String 7 // Description of Parameter 3 6796 { 6797 Text [ en-US ] = "The size of the population." ; 6798 }; 6799 }; 6800 // -=*# Resource for function GTEST #*=- 6801 Resource SC_OPCODE_Z_TEST 6802 { 6803 String 1 // Description 6804 { 6805 Text [ en-US ] = "Calculates the probability of observing a z-statistic greater than the one computed based on a sample." ; 6806 }; 6807 ExtraData = 6808 { 6809 0; 6810 ID_FUNCTION_GRP_STATISTIC; 6811 U2S( HID_FUNC_GTEST ); 6812 3; 0; 0; 1; 6813 0; 6814 }; 6815 String 2 // Name of Parameter 1 6816 { 6817 Text [ en-US ] = "data" ; 6818 }; 6819 String 3 // Description of Parameter 1 6820 { 6821 Text [ en-US ] = "The given sample, drawn from a normally distributed population." ; 6822 }; 6823 String 4 // Name of Parameter 2 6824 { 6825 Text [ en-US ] = "mu" ; 6826 }; 6827 String 5 // Description of Parameter 2 6828 { 6829 Text [ en-US ] = "The known mean of the population." ; 6830 }; 6831 String 6 // Name of Parameter 3 6832 { 6833 Text [ en-US ] = "sigma" ; 6834 }; 6835 String 7 // Description of Parameter 3 6836 { 6837 Text [ en-US ] = "The known standard deviation of the population. If omitted, the standard deviation of the given sample is used." ; 6838 }; 6839 }; 6840 // -=*# Resource for function CHITEST #*=- 6841 Resource SC_OPCODE_CHI_TEST 6842 { 6843 String 1 // Description 6844 { 6845 Text [ en-US ] = "Returns the chi square independence test." ; 6846 }; 6847 ExtraData = 6848 { 6849 0; 6850 ID_FUNCTION_GRP_STATISTIC; 6851 U2S( HID_FUNC_CHITEST ); 6852 2; 0; 0; 6853 0; 6854 }; 6855 String 2 // Name of Parameter 1 6856 { 6857 Text [ en-US ] = "Data_B" ; 6858 }; 6859 String 3 // Description of Parameter 1 6860 { 6861 Text [ en-US ] = "The observed data array." ; 6862 }; 6863 String 4 // Name of Parameter 2 6864 { 6865 Text [ en-US ] = "data_E" ; 6866 }; 6867 String 5 // Description of Parameter 2 6868 { 6869 Text [ en-US ] = "The expected data array." ; 6870 }; 6871 }; 6872 // -=*# Resource for function FTEST #*=- 6873 Resource SC_OPCODE_F_TEST 6874 { 6875 String 1 // Description 6876 { 6877 Text [ en-US ] = "Calculates the F test." ; 6878 }; 6879 ExtraData = 6880 { 6881 0; 6882 ID_FUNCTION_GRP_STATISTIC; 6883 U2S( HID_FUNC_FTEST ); 6884 2; 0; 0; 6885 0; 6886 }; 6887 String 2 // Name of Parameter 1 6888 { 6889 Text [ en-US ] = "data_1" ; 6890 }; 6891 String 3 // Description of Parameter 1 6892 { 6893 Text [ en-US ] = "The first record array." ; 6894 }; 6895 String 4 // Name of Parameter 2 6896 { 6897 Text [ en-US ] = "data_2" ; 6898 }; 6899 String 5 // Description of Parameter 2 6900 { 6901 Text [ en-US ] = "The second record array." ; 6902 }; 6903 }; 6904 // -=*# Resource for function TTEST #*=- 6905 Resource SC_OPCODE_T_TEST 6906 { 6907 String 1 // Description 6908 { 6909 Text [ en-US ] = "Calculates the T test." ; 6910 }; 6911 ExtraData = 6912 { 6913 0; 6914 ID_FUNCTION_GRP_STATISTIC; 6915 U2S( HID_FUNC_TTEST ); 6916 4; 0; 0; 0; 0; 6917 0; 6918 }; 6919 String 2 // Name of Parameter 1 6920 { 6921 Text [ en-US ] = "data_1" ; 6922 }; 6923 String 3 // Description of Parameter 1 6924 { 6925 Text [ en-US ] = "The first record array." ; 6926 }; 6927 String 4 // Name of Parameter 2 6928 { 6929 Text [ en-US ] = "data_2" ; 6930 }; 6931 String 5 // Description of Parameter 2 6932 { 6933 Text [ en-US ] = "The second record array." ; 6934 }; 6935 String 6 // Name of Parameter 3 6936 { 6937 Text [ en-US ] = "mode" ; 6938 }; 6939 String 7 // Description of Parameter 3 6940 { 6941 Text [ en-US ] = "Mode specifies the number of distribution tails to return. 1= one-tailed, 2 = two-tailed distribution" ; 6942 }; 6943 String 8 // Name of Parameter 4 6944 { 6945 Text [ en-US ] = "Type" ; 6946 }; 6947 String 9 // Description of Parameter 4 6948 { 6949 Text [ en-US ] = "The type of the T test." ; 6950 }; 6951 }; 6952 // -=*# Resource for function BESTIMMTHEITSMASS #*=- 6953 Resource SC_OPCODE_RSQ 6954 { 6955 String 1 // Description 6956 { 6957 Text [ en-US ] = "Returns the square of the Pearson product moment correlation coefficient." ; 6958 }; 6959 ExtraData = 6960 { 6961 0; 6962 ID_FUNCTION_GRP_STATISTIC; 6963 U2S( HID_FUNC_BESTIMMTHEITSMASS ); 6964 2; 0; 0; 6965 0; 6966 }; 6967 String 2 // Name of Parameter 1 6968 { 6969 Text [ en-US ] = "data_Y" ; 6970 }; 6971 String 3 // Description of Parameter 1 6972 { 6973 Text [ en-US ] = "The Y data array." ; 6974 }; 6975 String 4 // Name of Parameter 2 6976 { 6977 Text [ en-US ] = "data_X" ; 6978 }; 6979 String 5 // Description of Parameter 2 6980 { 6981 Text [ en-US ] = "The X data array." ; 6982 }; 6983 }; 6984 // -=*# Resource for function ACHSENABSCHNITT #*=- 6985 Resource SC_OPCODE_INTERCEPT 6986 { 6987 String 1 // Description 6988 { 6989 Text [ en-US ] = "Returns the intercept of the linear regression line and the Y axis." ; 6990 }; 6991 ExtraData = 6992 { 6993 0; 6994 ID_FUNCTION_GRP_STATISTIC; 6995 U2S( HID_FUNC_ACHSENABSCHNITT ); 6996 2; 0; 0; 6997 0; 6998 }; 6999 String 2 // Name of Parameter 1 7000 { 7001 Text [ en-US ] = "data_Y" ; 7002 }; 7003 String 3 // Description of Parameter 1 7004 { 7005 Text [ en-US ] = "The Y data array." ; 7006 }; 7007 String 4 // Name of Parameter 2 7008 { 7009 Text [ en-US ] = "data_X" ; 7010 }; 7011 String 5 // Description of Parameter 2 7012 { 7013 Text [ en-US ] = "The X data array." ; 7014 }; 7015 }; 7016 // -=*# Resource for function STEIGUNG #*=- 7017 Resource SC_OPCODE_SLOPE 7018 { 7019 String 1 // Description 7020 { 7021 Text [ en-US ] = "Returns the slope of the linear regression line." ; 7022 }; 7023 ExtraData = 7024 { 7025 0; 7026 ID_FUNCTION_GRP_STATISTIC; 7027 U2S( HID_FUNC_STEIGUNG ); 7028 2; 0; 0; 7029 0; 7030 }; 7031 String 2 // Name of Parameter 1 7032 { 7033 Text [ en-US ] = "data_Y" ; 7034 }; 7035 String 3 // Description of Parameter 1 7036 { 7037 Text [ en-US ] = "The Y data array." ; 7038 }; 7039 String 4 // Name of Parameter 2 7040 { 7041 Text [ en-US ] = "data_X" ; 7042 }; 7043 String 5 // Description of Parameter 2 7044 { 7045 Text [ en-US ] = "The X data array." ; 7046 }; 7047 }; 7048 // -=*# Resource for function STFEHLERYX #*=- 7049 Resource SC_OPCODE_STEYX 7050 { 7051 String 1 // Description 7052 { 7053 Text [ en-US ] = "Returns the standard error of the linear regression." ; 7054 }; 7055 ExtraData = 7056 { 7057 0; 7058 ID_FUNCTION_GRP_STATISTIC; 7059 U2S( HID_FUNC_STFEHLERYX ); 7060 2; 0; 0; 7061 0; 7062 }; 7063 String 2 // Name of Parameter 1 7064 { 7065 Text [ en-US ] = "data_Y" ; 7066 }; 7067 String 3 // Description of Parameter 1 7068 { 7069 Text [ en-US ] = "The Y data array." ; 7070 }; 7071 String 4 // Name of Parameter 2 7072 { 7073 Text [ en-US ] = "data_X" ; 7074 }; 7075 String 5 // Description of Parameter 2 7076 { 7077 Text [ en-US ] = "The X data array." ; 7078 }; 7079 }; 7080 // -=*# Resource for function PEARSON #*=- 7081 Resource SC_OPCODE_PEARSON 7082 { 7083 String 1 // Description 7084 { 7085 Text [ en-US ] = "Returns the Pearson product moment correlation coefficient." ; 7086 }; 7087 ExtraData = 7088 { 7089 0; 7090 ID_FUNCTION_GRP_STATISTIC; 7091 U2S( HID_FUNC_PEARSON ); 7092 2; 0; 0; 7093 0; 7094 }; 7095 String 2 // Name of Parameter 1 7096 { 7097 Text [ en-US ] = "Data_1" ; 7098 }; 7099 String 3 // Description of Parameter 1 7100 { 7101 Text [ en-US ] = "The first record array." ; 7102 }; 7103 String 4 // Name of Parameter 2 7104 { 7105 Text [ en-US ] = "Data_2" ; 7106 }; 7107 String 5 // Description of Parameter 2 7108 { 7109 Text [ en-US ] = "The second record array." ; 7110 }; 7111 }; 7112 // -=*# Resource for function KORREL #*=- 7113 Resource SC_OPCODE_CORREL 7114 { 7115 String 1 // Description 7116 { 7117 Text [ en-US ] = "Returns the correlation coefficient." ; 7118 }; 7119 ExtraData = 7120 { 7121 0; 7122 ID_FUNCTION_GRP_STATISTIC; 7123 U2S( HID_FUNC_KORREL ); 7124 2; 0; 0; 7125 0; 7126 }; 7127 String 2 // Name of Parameter 1 7128 { 7129 Text [ en-US ] = "Data_1" ; 7130 }; 7131 String 3 // Description of Parameter 1 7132 { 7133 Text [ en-US ] = "The first record array." ; 7134 }; 7135 String 4 // Name of Parameter 2 7136 { 7137 Text [ en-US ] = "Data_2" ; 7138 }; 7139 String 5 // Description of Parameter 2 7140 { 7141 Text [ en-US ] = "The second record array." ; 7142 }; 7143 }; 7144 // -=*# Resource for function KOVAR #*=- 7145 Resource SC_OPCODE_COVAR 7146 { 7147 String 1 // Description 7148 { 7149 Text [ en-US ] = "Calculates the covariance." ; 7150 }; 7151 ExtraData = 7152 { 7153 0; 7154 ID_FUNCTION_GRP_STATISTIC; 7155 U2S( HID_FUNC_KOVAR ); 7156 2; 0; 0; 7157 0; 7158 }; 7159 String 2 // Name of Parameter 1 7160 { 7161 Text [ en-US ] = "Data_1" ; 7162 }; 7163 String 3 // Description of Parameter 1 7164 { 7165 Text [ en-US ] = "The first record array." ; 7166 }; 7167 String 4 // Name of Parameter 2 7168 { 7169 Text [ en-US ] = "Data_2" ; 7170 }; 7171 String 5 // Description of Parameter 2 7172 { 7173 Text [ en-US ] = "The second record array." ; 7174 }; 7175 }; 7176 // -=*# Resource for function SCHÄTZER #*=- 7177 Resource SC_OPCODE_FORECAST 7178 { 7179 String 1 // Description 7180 { 7181 Text [ en-US ] = "Returns a value along a linear regression" ; 7182 }; 7183 ExtraData = 7184 { 7185 0; 7186 ID_FUNCTION_GRP_STATISTIC; 7187 U2S( HID_FUNC_SCHAETZER ); 7188 3; 0; 0; 0; 7189 0; 7190 }; 7191 String 2 // Name of Parameter 1 7192 { 7193 Text [ en-US ] = "value" ; 7194 }; 7195 String 3 // Description of Parameter 1 7196 { 7197 Text [ en-US ] = "The X value for which the Y value on the regression linear is to be calculated." ; 7198 }; 7199 String 4 // Name of Parameter 2 7200 { 7201 Text [ en-US ] = "data_Y" ; 7202 }; 7203 String 5 // Description of Parameter 2 7204 { 7205 Text [ en-US ] = "The Y data array." ; 7206 }; 7207 String 6 // Name of Parameter 3 7208 { 7209 Text [ en-US ] = "data_X" ; 7210 }; 7211 String 7 // Description of Parameter 3 7212 { 7213 Text [ en-US ] = "The X data array." ; 7214 }; 7215 }; 7216 // -=*# Resource for function ADRESSE #*=- 7217 Resource SC_OPCODE_ADDRESS 7218 { 7219 String 1 // Description 7220 { 7221 Text [ en-US ] = "Returns the reference to a cell as text." ; 7222 }; 7223 ExtraData = 7224 { 7225 0; 7226 ID_FUNCTION_GRP_TABLE; 7227 U2S( HID_FUNC_ADRESSE ); 7228 5; 0; 0; 1; 1; 1; 7229 0; 7230 }; 7231 String 2 // Name of Parameter 1 7232 { 7233 Text [ en-US ] = "row" ; 7234 }; 7235 String 3 // Description of Parameter 1 7236 { 7237 Text [ en-US ] = "The row number of the cell." ; 7238 }; 7239 String 4 // Name of Parameter 2 7240 { 7241 Text [ en-US ] = "column" ; 7242 }; 7243 String 5 // Description of Parameter 2 7244 { 7245 Text [ en-US ] = "The column number of the cell." ; 7246 }; 7247 String 6 // Name of Parameter 3 7248 { 7249 Text [ en-US ] = "ABS" ; 7250 }; 7251 String 7 // Description of Parameter 3 7252 { 7253 Text [ en-US ] = "Specifies whether absolute or relative referencing is to be used." ; 7254 }; 7255 String 8 // Name of Parameter 4 7256 { 7257 Text [ en-US ] = "A1" ; 7258 }; 7259 String 9 // Description of Parameter 4 7260 { 7261 Text [ en-US ] = "The reference style: 0 or FALSE means R1C1 style, any other value or omitted means A1 style." ; 7262 }; 7263 String 10 // Name of Parameter 5 7264 { 7265 Text [ en-US ] = "sheet" ; 7266 Text [ x-comment ] = "previously to OOo3.0 this was String resource RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_ADDRESS 8" ; 7267 }; 7268 String 11 // Description of Parameter 5 7269 { 7270 Text [ en-US ] = "The spreadsheet name of the cell reference." ; 7271 Text [ x-comment ] = "previously to OOo3.0 this was String resource RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_ADDRESS 9" ; 7272 }; 7273 }; 7274 // -=*# Resource for function BEREICHE #*=- 7275 Resource SC_OPCODE_AREAS 7276 { 7277 String 1 // Description 7278 { 7279 Text [ en-US ] = "Returns the number of individual ranges that belong to a (multiple) range." ; 7280 }; 7281 ExtraData = 7282 { 7283 0; 7284 ID_FUNCTION_GRP_TABLE; 7285 U2S( HID_FUNC_BEREICHE ); 7286 1; 0; 7287 0; 7288 }; 7289 String 2 // Name of Parameter 1 7290 { 7291 Text [ en-US ] = "reference" ; 7292 }; 7293 String 3 // Description of Parameter 1 7294 { 7295 Text [ en-US ] = "The reference to a (multiple) range." ; 7296 }; 7297 }; 7298 // -=*# Resource for function WAHL #*=- 7299 Resource SC_OPCODE_CHOSE 7300 { 7301 String 1 // Description 7302 { 7303 Text [ en-US ] = "Selects a value from a list of up to 30 value arguments." ; 7304 }; 7305 ExtraData = 7306 { 7307 0; 7308 ID_FUNCTION_GRP_TABLE; 7309 U2S( HID_FUNC_WAHL ); 7310 VAR_ARGS+1; 0; 0; 7311 0; 7312 }; 7313 String 2 // Name of Parameter 1 7314 { 7315 Text [ en-US ] = "Index" ; 7316 }; 7317 String 3 // Description of Parameter 1 7318 { 7319 Text [ en-US ] = "The index of the value (1..30) selected." ; 7320 }; 7321 String 4 // Name of Parameter 2 7322 { 7323 Text [ en-US ] = "value " ; 7324 }; 7325 String 5 // Description of Parameter 2 7326 { 7327 Text [ en-US ] = "Value 1, value 2,... The list of arguments from which a value is chosen." ; 7328 }; 7329 }; 7330 // -=*# Resource for function SPALTE #*=- 7331 Resource SC_OPCODE_COLUMN 7332 { 7333 String 1 // Description 7334 { 7335 Text [ en-US ] = "Returns the internal column number of a reference." ; 7336 }; 7337 ExtraData = 7338 { 7339 0; 7340 ID_FUNCTION_GRP_TABLE; 7341 U2S( HID_FUNC_SPALTE ); 7342 1; 1; 7343 0; 7344 }; 7345 String 2 // Name of Parameter 1 7346 { 7347 Text [ en-US ] = "reference" ; 7348 }; 7349 String 3 // Description of Parameter 1 7350 { 7351 Text [ en-US ] = "The reference to a cell or a range." ; 7352 }; 7353 }; 7354 // -=*# Resource for function ZEILE #*=- 7355 Resource SC_OPCODE_ROW 7356 { 7357 String 1 // Description 7358 { 7359 Text [ en-US ] = "Defines the internal row number of a reference." ; 7360 }; 7361 ExtraData = 7362 { 7363 0; 7364 ID_FUNCTION_GRP_TABLE; 7365 U2S( HID_FUNC_ZEILE ); 7366 1; 1; 7367 0; 7368 }; 7369 String 2 // Name of Parameter 1 7370 { 7371 Text [ en-US ] = "reference" ; 7372 }; 7373 String 3 // Description of Parameter 1 7374 { 7375 Text [ en-US ] = "The reference to a cell or a range." ; 7376 }; 7377 }; 7378 // -=*# Resource for function TABELLE #*=- 7379 Resource SC_OPCODE_TABLE 7380 { 7381 String 1 // Description 7382 { 7383 Text [ en-US ] = "Returns the internal sheet number of a reference or a string." ; 7384 }; 7385 ExtraData = 7386 { 7387 0; 7388 ID_FUNCTION_GRP_TABLE; 7389 U2S( HID_FUNC_TABELLE ); 7390 1; 1; 7391 0; 7392 }; 7393 String 2 // Name of Parameter 1 7394 { 7395 Text [ en-US ] = "reference" ; 7396 }; 7397 String 3 // Description of Parameter 1 7398 { 7399 Text [ en-US ] = "The reference to a cell or a range or the character string of a sheet name." ; 7400 }; 7401 }; 7402 // -=*# Resource for function SPALTEN #*=- 7403 Resource SC_OPCODE_COLUMNS 7404 { 7405 String 1 // Description 7406 { 7407 Text [ en-US ] = "Returns the number of columns in an array or reference." ; 7408 }; 7409 ExtraData = 7410 { 7411 0; 7412 ID_FUNCTION_GRP_TABLE; 7413 U2S( HID_FUNC_SPALTEN ); 7414 1; 0; 7415 0; 7416 }; 7417 String 2 // Name of Parameter 1 7418 { 7419 Text [ en-US ] = "array" ; 7420 }; 7421 String 3 // Description of Parameter 1 7422 { 7423 Text [ en-US ] = "The array (reference) for which the number of columns is to be determined." ; 7424 }; 7425 }; 7426 // -=*# Resource for function ZEILEN #*=- 7427 Resource SC_OPCODE_ROWS 7428 { 7429 String 1 // Description 7430 { 7431 Text [ en-US ] = "Returns the number of rows in a reference or array." ; 7432 }; 7433 ExtraData = 7434 { 7435 0; 7436 ID_FUNCTION_GRP_TABLE; 7437 U2S( HID_FUNC_ZEILEN ); 7438 1; 0; 7439 0; 7440 }; 7441 String 2 // Name of Parameter 1 7442 { 7443 Text [ en-US ] = "array" ; 7444 }; 7445 String 3 // Description of Parameter 1 7446 { 7447 Text [ en-US ] = "The array (reference) for which the number of rows is to be determined." ; 7448 }; 7449 }; 7450 // -=*# Resource for function TABELLEN #*=- 7451 Resource SC_OPCODE_TABLES 7452 { 7453 String 1 // Description 7454 { 7455 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." ; 7456 }; 7457 ExtraData = 7458 { 7459 0; 7460 ID_FUNCTION_GRP_TABLE; 7461 U2S( HID_FUNC_TABELLEN ); 7462 1; 1; 7463 0; 7464 }; 7465 String 2 // Name of Parameter 1 7466 { 7467 Text [ en-US ] = "reference" ; 7468 }; 7469 String 3 // Description of Parameter 1 7470 { 7471 Text [ en-US ] = "The reference to a cell or a range." ; 7472 }; 7473 }; 7474 // -=*# Resource for function WVERWEIS #*=- 7475 Resource SC_OPCODE_H_LOOKUP 7476 { 7477 String 1 // Description 7478 { 7479 Text [ en-US ] = "Horizontal search and reference to the cells located below." ; 7480 }; 7481 ExtraData = 7482 { 7483 0; 7484 ID_FUNCTION_GRP_TABLE; 7485 U2S( HID_FUNC_WVERWEIS ); 7486 4; 0; 0; 0; 1; 7487 0; 7488 }; 7489 String 2 // Name of Parameter 1 7490 { 7491 Text [ en-US ] = "search_criteria" ; 7492 }; 7493 String 3 // Description of Parameter 1 7494 { 7495 Text [ en-US ] = "The value to be found in the first row." ; 7496 }; 7497 String 4 // Name of Parameter 2 7498 { 7499 Text [ en-US ] = "array" ; 7500 }; 7501 String 5 // Description of Parameter 2 7502 { 7503 Text [ en-US ] = "The array or the range for the reference." ; 7504 }; 7505 String 6 // Name of Parameter 3 7506 { 7507 Text [ en-US ] = "Index" ; 7508 }; 7509 String 7 // Description of Parameter 3 7510 { 7511 Text [ en-US ] = "The row index in the array." ; 7512 }; 7513 String 8 // Name of Parameter 4 7514 { 7515 Text [ en-US ] = "sorted" ; 7516 }; 7517 String 9 // Description of Parameter 4 7518 { 7519 Text [ en-US ] = "If the value is TRUE or not given, the search row of the array must be sorted in ascending order." ; 7520 }; 7521 }; 7522 // -=*# Resource for function SVERWEIS #*=- 7523 Resource SC_OPCODE_V_LOOKUP 7524 { 7525 String 1 // Description 7526 { 7527 Text [ en-US ] = "Vertical search and reference to indicated cells." ; 7528 }; 7529 ExtraData = 7530 { 7531 0; 7532 ID_FUNCTION_GRP_TABLE; 7533 U2S( HID_FUNC_SVERWEIS ); 7534 4; 0; 0; 0; 1; 7535 0; 7536 }; 7537 String 2 // Name of Parameter 1 7538 { 7539 Text [ en-US ] = "Search criterion" ; 7540 }; 7541 String 3 // Description of Parameter 1 7542 { 7543 Text [ en-US ] = "The value to be found in the first column." ; 7544 }; 7545 String 4 // Name of Parameter 2 7546 { 7547 Text [ en-US ] = "array" ; 7548 }; 7549 String 5 // Description of Parameter 2 7550 { 7551 Text [ en-US ] = "The array or range for referencing." ; 7552 }; 7553 String 6 // Name of Parameter 3 7554 { 7555 Text [ en-US ] = "Index" ; 7556 }; 7557 String 7 // Description of Parameter 3 7558 { 7559 Text [ en-US ] = "Column index number in the array." ; 7560 }; 7561 String 8 // Name of Parameter 4 7562 { 7563 Text [ en-US ] = "sort order" ; 7564 }; 7565 String 9 // Description of Parameter 4 7566 { 7567 Text [ en-US ] = "If the value is TRUE or not given, the search column of the array must be sorted in ascending order." ; 7568 }; 7569 }; 7570 // -=*# Resource for function INDEX #*=- 7571 Resource SC_OPCODE_INDEX 7572 { 7573 String 1 // Description 7574 { 7575 Text [ en-US ] = "Returns a reference to a cell from a defined range." ; 7576 }; 7577 ExtraData = 7578 { 7579 0; 7580 ID_FUNCTION_GRP_TABLE; 7581 U2S( HID_FUNC_INDEX ); 7582 4; 0; 1; 1; 1; 7583 0; 7584 }; 7585 String 2 // Name of Parameter 1 7586 { 7587 Text [ en-US ] = "reference" ; 7588 }; 7589 String 3 // Description of Parameter 1 7590 { 7591 Text [ en-US ] = "The reference to a (multiple) range." ; 7592 }; 7593 String 4 // Name of Parameter 2 7594 { 7595 Text [ en-US ] = "row" ; 7596 }; 7597 String 5 // Description of Parameter 2 7598 { 7599 Text [ en-US ] = "The row in the range." ; 7600 }; 7601 String 6 // Name of Parameter 3 7602 { 7603 Text [ en-US ] = "column" ; 7604 }; 7605 String 7 // Description of Parameter 3 7606 { 7607 Text [ en-US ] = "The column in the range." ; 7608 }; 7609 String 8 // Name of Parameter 4 7610 { 7611 Text [ en-US ] = "range" ; 7612 }; 7613 String 9 // Description of Parameter 4 7614 { 7615 Text [ en-US ] = "The index of the subrange if referring to a multiple range." ; 7616 }; 7617 }; 7618 // -=*# Resource for function INDIREKT #*=- 7619 Resource SC_OPCODE_INDIRECT 7620 { 7621 String 1 // Description 7622 { 7623 Text [ en-US ] = "Returns the contents of a cell that is referenced in text form." ; 7624 }; 7625 ExtraData = 7626 { 7627 0; 7628 ID_FUNCTION_GRP_TABLE; 7629 U2S( HID_FUNC_INDIREKT ); 7630 2; 0; 1; 7631 0; 7632 }; 7633 String 2 // Name of Parameter 1 7634 { 7635 Text [ en-US ] = "ref " ; 7636 }; 7637 String 3 // Description of Parameter 1 7638 { 7639 Text [ en-US ] = "The cell whose contents are to be evaluated is to be referenced in text form (e.g. \"A1\")." ; 7640 }; 7641 String 4 // Name of Parameter 2 7642 { 7643 Text [ en-US ] = "A1" ; 7644 }; 7645 String 5 // Description of Parameter 2 7646 { 7647 Text [ en-US ] = "The reference style: 0 or FALSE means R1C1 style, any other value or omitted means A1 style." ; 7648 }; 7649 }; 7650 // -=*# Resource for function VERWEIS #*=- 7651 Resource SC_OPCODE_LOOKUP 7652 { 7653 String 1 // Description 7654 { 7655 Text [ en-US ] = "Determines a value in a vector by comparison to values in another vector." ; 7656 }; 7657 ExtraData = 7658 { 7659 0; 7660 ID_FUNCTION_GRP_TABLE; 7661 U2S( HID_FUNC_VERWEIS ); 7662 3; 0; 0; 1; 7663 0; 7664 }; 7665 String 2 // Name of Parameter 1 7666 { 7667 Text [ en-US ] = "Search criterion" ; 7668 }; 7669 String 3 // Description of Parameter 1 7670 { 7671 Text [ en-US ] = "The value to be used for comparison." ; 7672 }; 7673 String 4 // Name of Parameter 2 7674 { 7675 Text [ en-US ] = "Search vector" ; 7676 }; 7677 String 5 // Description of Parameter 2 7678 { 7679 Text [ en-US ] = "The vector (row or column) in which to search." ; 7680 }; 7681 String 6 // Name of Parameter 3 7682 { 7683 Text [ en-US ] = "result_vector" ; 7684 }; 7685 String 7 // Description of Parameter 3 7686 { 7687 Text [ en-US ] = "The vector (row or range) from which the value is to be determined." ; 7688 }; 7689 }; 7690 // -=*# Resource for function VERGLEICH #*=- 7691 Resource SC_OPCODE_MATCH 7692 { 7693 String 1 // Description 7694 { 7695 Text [ en-US ] = "Defines a position in a array after comparing values." ; 7696 }; 7697 ExtraData = 7698 { 7699 0; 7700 ID_FUNCTION_GRP_TABLE; 7701 U2S( HID_FUNC_VERGLEICH ); 7702 3; 0; 0; 1; 7703 0; 7704 }; 7705 String 2 // Name of Parameter 1 7706 { 7707 Text [ en-US ] = "Search criterion" ; 7708 }; 7709 String 3 // Description of Parameter 1 7710 { 7711 Text [ en-US ] = "The value to be used for comparison." ; 7712 }; 7713 String 4 // Name of Parameter 2 7714 { 7715 Text [ en-US ] = "lookup_array" ; 7716 }; 7717 String 5 // Description of Parameter 2 7718 { 7719 Text [ en-US ] = "The array (range) in which the search is made." ; 7720 }; 7721 String 6 // Name of Parameter 3 7722 { 7723 Text [ en-US ] = "Type" ; 7724 }; 7725 String 7 // Description of Parameter 3 7726 { 7727 Text [ en-US ] = "Type can take the value 1, 0 or -1 and determines the criteria are to be used for comparison purposes." ; 7728 }; 7729 }; 7730 // -=*# Resource for function VERSCHIEBUNG #*=- 7731 Resource SC_OPCODE_OFFSET 7732 { 7733 String 1 // Description 7734 { 7735 Text [ en-US ] = "Returns a reference which has been moved in relation to the starting point." ; 7736 }; 7737 ExtraData = 7738 { 7739 0; 7740 ID_FUNCTION_GRP_TABLE; 7741 U2S( HID_FUNC_VERSCHIEBUNG ); 7742 5; 0; 0; 0; 1; 1; 7743 0; 7744 }; 7745 String 2 // Name of Parameter 1 7746 { 7747 Text [ en-US ] = "reference" ; 7748 }; 7749 String 3 // Description of Parameter 1 7750 { 7751 Text [ en-US ] = "The reference (cell) from which to base the movement." ; 7752 }; 7753 String 4 // Name of Parameter 2 7754 { 7755 Text [ en-US ] = "rows" ; 7756 }; 7757 String 5 // Description of Parameter 2 7758 { 7759 Text [ en-US ] = "The number of rows to be moved either up or down." ; 7760 }; 7761 String 6 // Name of Parameter 3 7762 { 7763 Text [ en-US ] = "columns" ; 7764 }; 7765 String 7 // Description of Parameter 3 7766 { 7767 Text [ en-US ] = "The number of columns that are to be moved to the left or to the right." ; 7768 }; 7769 String 8 // Name of Parameter 4 7770 { 7771 Text [ en-US ] = "height" ; 7772 }; 7773 String 9 // Description of Parameter 4 7774 { 7775 Text [ en-US ] = "The number of rows of the moved reference." ; 7776 }; 7777 String 10 // Name of Parameter 5 7778 { 7779 Text [ en-US ] = "width" ; 7780 }; 7781 String 11 // Description of Parameter 5 7782 { 7783 Text [ en-US ] = "The number of columns in the moved reference." ; 7784 }; 7785 }; 7786 // -=*# Resource for function FEHLERTYP #*=- 7787 Resource SC_OPCODE_ERROR_TYPE 7788 { 7789 String 1 // Description 7790 { 7791 Text [ en-US ] = "Returns a number corresponding to an error type" ; 7792 }; 7793 ExtraData = 7794 { 7795 0; 7796 ID_FUNCTION_GRP_TABLE; 7797 U2S( HID_FUNC_FEHLERTYP ); 7798 1; 0; 7799 0; 7800 }; 7801 String 2 // Name of Parameter 1 7802 { 7803 Text [ en-US ] = "reference" ; 7804 }; 7805 String 3 // Description of Parameter 1 7806 { 7807 Text [ en-US ] = "The reference (cell) in which the error occurred." ; 7808 }; 7809 }; 7810 // -=*# Resource for function VORLAGE #*=- 7811 Resource SC_OPCODE_STYLE 7812 { 7813 String 1 // Description 7814 { 7815 Text [ en-US ] = "Applies a Style to the formula cell." ; 7816 }; 7817 ExtraData = 7818 { 7819 0; 7820 ID_FUNCTION_GRP_TABLE; 7821 U2S( HID_FUNC_VORLAGE ); 7822 3; 0; 1; 1; 7823 0; 7824 }; 7825 String 2 // Name of Parameter 1 7826 { 7827 Text [ en-US ] = "Style" ; 7828 }; 7829 String 3 // Description of Parameter 1 7830 { 7831 Text [ en-US ] = "The name of the Style to be applied." ; 7832 }; 7833 String 4 // Name of Parameter 2 7834 { 7835 Text [ en-US ] = "Time" ; 7836 }; 7837 String 5 // Description of Parameter 2 7838 { 7839 Text [ en-US ] = "The time (in seconds) that the Style is to remain valid." ; 7840 }; 7841 String 6 // Name of Parameter 3 7842 { 7843 Text [ en-US ] = "Style2" ; 7844 }; 7845 String 7 // Description of Parameter 3 7846 { 7847 Text [ en-US ] = "The Style to be applied after time expires." ; 7848 }; 7849 }; 7850 // -=*# Resource for function DDE #*=- 7851 Resource SC_OPCODE_DDE 7852 { 7853 String 1 // Description 7854 { 7855 Text [ en-US ] = "Result of a DDE link." ; 7856 }; 7857 ExtraData = 7858 { 7859 0; 7860 ID_FUNCTION_GRP_TABLE; 7861 U2S( HID_FUNC_DDE ); 7862 4; 0; 0; 0; 1; 7863 0; 7864 }; 7865 String 2 // Name of Parameter 1 7866 { 7867 Text [ en-US ] = "server" ; 7868 }; 7869 String 3 // Description of Parameter 1 7870 { 7871 Text [ en-US ] = "The name of the server application." ; 7872 }; 7873 String 4 // Name of Parameter 2 7874 { 7875 Text [ en-US ] = "File" ; 7876 }; 7877 String 5 // Description of Parameter 2 7878 { 7879 Text [ en-US ] = "The name of the file." ; 7880 }; 7881 String 6 // Name of Parameter 3 7882 { 7883 Text [ en-US ] = "range" ; 7884 }; 7885 String 7 // Description of Parameter 3 7886 { 7887 Text [ en-US ] = "The range from which data is to be taken." ; 7888 }; 7889 String 8 // Name of Parameter 4 7890 { 7891 Text [ en-US ] = "mode" ; 7892 }; 7893 String 9 // Description of Parameter 4 7894 { 7895 Text [ en-US ] = "Defines how data is to be converted to numbers." ; 7896 }; 7897 }; 7898 // -=*# Resource for function HYPERLINK #*=- 7899 Resource SC_OPCODE_HYPERLINK 7900 { 7901 String 1 // Description 7902 { 7903 Text [ en-US ] = "Hyperlink." ; 7904 }; 7905 ExtraData = 7906 { 7907 0; 7908 ID_FUNCTION_GRP_TABLE; 7909 U2S( HID_FUNC_HYPERLINK ); 7910 2; 0; 1; 7911 0; 7912 }; 7913 String 2 // Name of Parameter 1 7914 { 7915 Text [ en-US ] = "URL " ; 7916 }; 7917 String 3 // Description of Parameter 1 7918 { 7919 Text [ en-US ] = "URL"; 7920 }; 7921 String 4 // Name of Parameter 2 7922 { 7923 Text [ en-US ] = "CellText " ; 7924 }; 7925 String 5 // Description of Parameter 2 7926 { 7927 Text [ en-US ] = "Cell Text"; 7928 }; 7929 }; 7930 // -=*# Resource for function GETPIVOTDATA #*=- 7931 Resource SC_OPCODE_GET_PIVOT_DATA 7932 { 7933 String 1 // Description 7934 { 7935 Text [ en-US ] = "Extracts value(s) from a pivot table."; 7936 }; 7937 ExtraData = 7938 { 7939 0; 7940 ID_FUNCTION_GRP_TABLE; 7941 U2S( HID_FUNC_GETPIVOTDATA ); 7942 VAR_ARGS+2; 0; 0; 1; 7943 0; 7944 }; 7945 String 2 // Name of Parameter 1 7946 { 7947 Text [ en-US ] = "Data Field"; 7948 }; 7949 String 3 // Description of Parameter 1 7950 { 7951 Text [ en-US ] = "The name of the pivot table field to extract."; 7952 }; 7953 String 4 // Name of Parameter 2 7954 { 7955 Text [ en-US ] = "Pivot Table"; 7956 }; 7957 String 5 // Description of Parameter 2 7958 { 7959 Text [ en-US ] = "A reference to a cell or range in the pivot table."; 7960 }; 7961 String 6 // Name of Parameter 3 7962 { 7963 Text [ en-US ] = "Field Name / Item"; 7964 }; 7965 String 7 // Description of Parameter 3 7966 { 7967 Text [ en-US ] = "Field name/value pair to filter the target data."; 7968 }; 7969 }; 7970 // -=*# Resource for function BAHTTEXT #*=- 7971 Resource SC_OPCODE_BAHTTEXT 7972 { 7973 String 1 // Description 7974 { 7975 Text [ en-US ] = "Converts a number to text (Baht)." ; 7976 }; 7977 ExtraData = 7978 { 7979 0; 7980 ID_FUNCTION_GRP_TEXT; 7981 U2S( HID_FUNC_BAHTTEXT ); 7982 1; 0; 7983 0; 7984 }; 7985 String 2 // Name of Parameter 1 7986 { 7987 Text [ en-US ] = "Number" ; 7988 }; 7989 String 3 // Description of Parameter 1 7990 { 7991 Text [ en-US ] = "The number to convert."; 7992 }; 7993 }; 7994 // -=*# Resource for function JIS #*=- 7995 Resource SC_OPCODE_JIS 7996 { 7997 String 1 // Description 7998 { 7999 Text [ en-US ] = "Converts half-width ASCII and katakana characters to full-width." ; 8000 }; 8001 ExtraData = 8002 { 8003 0; 8004 ID_FUNCTION_GRP_TEXT; 8005 U2S( HID_FUNC_JIS ); 8006 1; 0; 8007 0; 8008 }; 8009 String 2 // Name of Parameter 1 8010 { 8011 Text [ en-US ] = "text" ; 8012 }; 8013 String 3 // Description of Parameter 1 8014 { 8015 Text [ en-US ] = "The text to convert."; 8016 }; 8017 }; 8018 // -=*# Resource for function ASC #*=- 8019 Resource SC_OPCODE_ASC 8020 { 8021 String 1 // Description 8022 { 8023 Text [ en-US ] = "Converts full-width ASCII and katakana characters to half-width." ; 8024 }; 8025 ExtraData = 8026 { 8027 0; 8028 ID_FUNCTION_GRP_TEXT; 8029 U2S( HID_FUNC_ASC ); 8030 1; 0; 8031 0; 8032 }; 8033 String 2 // Name of Parameter 1 8034 { 8035 Text [ en-US ] = "text" ; 8036 }; 8037 String 3 // Description of Parameter 1 8038 { 8039 Text [ en-US ] = "The text to convert."; 8040 }; 8041 }; 8042 // -=*# Resource for function CODE #*=- 8043 Resource SC_OPCODE_CODE 8044 { 8045 String 1 // Description 8046 { 8047 Text [ en-US ] = "Returns a numeric code for the first character in a text string." ; 8048 }; 8049 ExtraData = 8050 { 8051 0; 8052 ID_FUNCTION_GRP_TEXT; 8053 U2S( HID_FUNC_CODE ); 8054 1; 0; 8055 0; 8056 }; 8057 String 2 // Name of Parameter 1 8058 { 8059 Text [ en-US ] = "text" ; 8060 }; 8061 String 3 // Description of Parameter 1 8062 { 8063 Text [ en-US ] = "This is the text for which the code of the first character is to be found." ; 8064 }; 8065 }; 8066 // -=*# Resource for function DM #*=- 8067 Resource SC_OPCODE_CURRENCY 8068 { 8069 String 1 // Description 8070 { 8071 Text [ en-US ] = "Converts a number to text in currency format." ; 8072 }; 8073 ExtraData = 8074 { 8075 0; 8076 ID_FUNCTION_GRP_TEXT; 8077 U2S( HID_FUNC_DM ); 8078 2; 0; 1; 8079 0; 8080 }; 8081 String 2 // Name of Parameter 1 8082 { 8083 Text [ en-US ] = "value" ; 8084 }; 8085 String 3 // Description of Parameter 1 8086 { 8087 Text [ en-US ] = "Value is a number, a reference to a cell containing a number or a formula that results in a number." ; 8088 }; 8089 String 4 // Name of Parameter 2 8090 { 8091 Text [ en-US ] = "decimals" ; 8092 }; 8093 String 5 // Description of Parameter 2 8094 { 8095 Text [ en-US ] = "Decimal places. Denotes the number of digits to the right of the decimal point." ; 8096 }; 8097 }; 8098 // -=*# Resource for function ZEICHEN #*=- 8099 Resource SC_OPCODE_CHAR 8100 { 8101 String 1 // Description 8102 { 8103 Text [ en-US ] = "Converts a code number into a character or letter." ; 8104 }; 8105 ExtraData = 8106 { 8107 0; 8108 ID_FUNCTION_GRP_TEXT; 8109 U2S( HID_FUNC_ZEICHEN ); 8110 1; 0; 8111 0; 8112 }; 8113 String 2 // Name of Parameter 1 8114 { 8115 Text [ en-US ] = "number" ; 8116 }; 8117 String 3 // Description of Parameter 1 8118 { 8119 Text [ en-US ] = "The code value for the character." ; 8120 }; 8121 }; 8122 // -=*# Resource for function SÄUBERN #*=- 8123 Resource SC_OPCODE_CLEAN 8124 { 8125 String 1 // Description 8126 { 8127 Text [ en-US ] = "Removes all nonprintable characters from text." ; 8128 }; 8129 ExtraData = 8130 { 8131 0; 8132 ID_FUNCTION_GRP_TEXT; 8133 U2S( HID_FUNC_SAEUBERN ); 8134 1; 0; 8135 0; 8136 }; 8137 String 2 // Name of Parameter 1 8138 { 8139 Text [ en-US ] = "text" ; 8140 }; 8141 String 3 // Description of Parameter 1 8142 { 8143 Text [ en-US ] = "The text from which nonprintable characters are to be removed." ; 8144 }; 8145 }; 8146 // -=*# Resource for function VERKETTEN #*=- 8147 Resource SC_OPCODE_CONCAT 8148 { 8149 String 1 // Description 8150 { 8151 Text [ en-US ] = "Combines several text items into one." ; 8152 }; 8153 ExtraData = 8154 { 8155 0; 8156 ID_FUNCTION_GRP_TEXT; 8157 U2S( HID_FUNC_VERKETTEN ); 8158 VAR_ARGS; 0; 8159 0; 8160 }; 8161 String 2 // Name of Parameter 1 8162 { 8163 Text [ en-US ] = "text " ; 8164 }; 8165 String 3 // Description of Parameter 1 8166 { 8167 Text [ en-US ] = "Text for the concatentation." ; 8168 }; 8169 }; 8170 // -=*# Resource for function IDENTISCH #*=- 8171 Resource SC_OPCODE_EXACT 8172 { 8173 String 1 // Description 8174 { 8175 Text [ en-US ] = "Specifies whether two texts are identical." ; 8176 }; 8177 ExtraData = 8178 { 8179 0; 8180 ID_FUNCTION_GRP_TEXT; 8181 U2S( HID_FUNC_IDENTISCH ); 8182 2; 0; 0; 8183 0; 8184 }; 8185 String 2 // Name of Parameter 1 8186 { 8187 Text [ en-US ] = "text_1" ; 8188 }; 8189 String 3 // Description of Parameter 1 8190 { 8191 Text [ en-US ] = "The first text to be used for comparing texts." ; 8192 }; 8193 String 4 // Name of Parameter 2 8194 { 8195 Text [ en-US ] = "text_2" ; 8196 }; 8197 String 5 // Description of Parameter 2 8198 { 8199 Text [ en-US ] = "The second text for comparing texts." ; 8200 }; 8201 }; 8202 // -=*# Resource for function FINDEN #*=- 8203 Resource SC_OPCODE_FIND 8204 { 8205 String 1 // Description 8206 { 8207 Text [ en-US ] = "Looks for a string of text within another (case sensitive)" ; 8208 }; 8209 ExtraData = 8210 { 8211 0; 8212 ID_FUNCTION_GRP_TEXT; 8213 U2S( HID_FUNC_FINDEN ); 8214 3; 0; 0; 1; 8215 0; 8216 }; 8217 String 2 // Name of Parameter 1 8218 { 8219 Text [ en-US ] = "find_text" ; 8220 }; 8221 String 3 // Description of Parameter 1 8222 { 8223 Text [ en-US ] = "The text to be found." ; 8224 }; 8225 String 4 // Name of Parameter 2 8226 { 8227 Text [ en-US ] = "text" ; 8228 }; 8229 String 5 // Description of Parameter 2 8230 { 8231 Text [ en-US ] = "The text in which a search is to be made." ; 8232 }; 8233 String 6 // Name of Parameter 3 8234 { 8235 Text [ en-US ] = "position" ; 8236 }; 8237 String 7 // Description of Parameter 3 8238 { 8239 Text [ en-US ] = "The position in the text from which the search starts." ; 8240 }; 8241 }; 8242 // -=*# Resource for function SUCHEN #*=- 8243 Resource SC_OPCODE_SEARCH 8244 { 8245 String 1 // Description 8246 { 8247 Text [ en-US ] = "Looks for one text value within another (not case-sensitive)." ; 8248 }; 8249 ExtraData = 8250 { 8251 0; 8252 ID_FUNCTION_GRP_TEXT; 8253 U2S( HID_FUNC_SUCHEN ); 8254 3; 0; 0; 1; 8255 0; 8256 }; 8257 String 2 // Name of Parameter 1 8258 { 8259 Text [ en-US ] = "find_text" ; 8260 }; 8261 String 3 // Description of Parameter 1 8262 { 8263 Text [ en-US ] = "The text to be found." ; 8264 }; 8265 String 4 // Name of Parameter 2 8266 { 8267 Text [ en-US ] = "text" ; 8268 }; 8269 String 5 // Description of Parameter 2 8270 { 8271 Text [ en-US ] = "The text in which a search is to be made." ; 8272 }; 8273 String 6 // Name of Parameter 3 8274 { 8275 Text [ en-US ] = "position" ; 8276 }; 8277 String 7 // Description of Parameter 3 8278 { 8279 Text [ en-US ] = "The position in the text where the search is started." ; 8280 }; 8281 }; 8282 // -=*# Resource for function GLÄTTEN #*=- 8283 Resource SC_OPCODE_TRIM 8284 { 8285 String 1 // Description 8286 { 8287 Text [ en-US ] = "Removes extra spaces from text." ; 8288 }; 8289 ExtraData = 8290 { 8291 0; 8292 ID_FUNCTION_GRP_TEXT; 8293 U2S( HID_FUNC_GLAETTEN ); 8294 1; 0; 8295 0; 8296 }; 8297 String 2 // Name of Parameter 1 8298 { 8299 Text [ en-US ] = "text" ; 8300 }; 8301 String 3 // Description of Parameter 1 8302 { 8303 Text [ en-US ] = "The text in which extra spaces between words are to be deleted." ; 8304 }; 8305 }; 8306 // -=*# Resource for function GROSS2 #*=- 8307 Resource SC_OPCODE_PROPPER 8308 { 8309 String 1 // Description 8310 { 8311 Text [ en-US ] = "Capitalizes the first letter in all words." ; 8312 }; 8313 ExtraData = 8314 { 8315 0; 8316 ID_FUNCTION_GRP_TEXT; 8317 U2S( HID_FUNC_GROSS2 ); 8318 1; 0; 8319 0; 8320 }; 8321 String 2 // Name of Parameter 1 8322 { 8323 Text [ en-US ] = "text" ; 8324 }; 8325 String 3 // Description of Parameter 1 8326 { 8327 Text [ en-US ] = "The text in which the beginning of words are to be replaced by capital letters." ; 8328 }; 8329 }; 8330 // -=*# Resource for function GROSS #*=- 8331 Resource SC_OPCODE_UPPER 8332 { 8333 String 1 // Description 8334 { 8335 Text [ en-US ] = "Converts text to uppercase." ; 8336 }; 8337 ExtraData = 8338 { 8339 0; 8340 ID_FUNCTION_GRP_TEXT; 8341 U2S( HID_FUNC_GROSS ); 8342 1; 0; 8343 0; 8344 }; 8345 String 2 // Name of Parameter 1 8346 { 8347 Text [ en-US ] = "text" ; 8348 }; 8349 String 3 // Description of Parameter 1 8350 { 8351 Text [ en-US ] = "The text in which lower case letters are to be converted to capitals." ; 8352 }; 8353 }; 8354 // -=*# Resource for function KLEIN #*=- 8355 Resource SC_OPCODE_LOWER 8356 { 8357 String 1 // Description 8358 { 8359 Text [ en-US ] = "Converts text to lowercase." ; 8360 }; 8361 ExtraData = 8362 { 8363 0; 8364 ID_FUNCTION_GRP_TEXT; 8365 U2S( HID_FUNC_KLEIN ); 8366 1; 0; 8367 0; 8368 }; 8369 String 2 // Name of Parameter 1 8370 { 8371 Text [ en-US ] = "text" ; 8372 }; 8373 String 3 // Description of Parameter 1 8374 { 8375 Text [ en-US ] = "The text in which capitals are converted to lower case letters." ; 8376 }; 8377 }; 8378 // -=*# Resource for function WERT #*=- 8379 Resource SC_OPCODE_VALUE 8380 { 8381 String 1 // Description 8382 { 8383 Text [ en-US ] = "Converts text to a number." ; 8384 }; 8385 ExtraData = 8386 { 8387 0; 8388 ID_FUNCTION_GRP_TEXT; 8389 U2S( HID_FUNC_WERT ); 8390 1; 0; 8391 0; 8392 }; 8393 String 2 // Name of Parameter 1 8394 { 8395 Text [ en-US ] = "text" ; 8396 }; 8397 String 3 // Description of Parameter 1 8398 { 8399 Text [ en-US ] = "The text to be converted to a number." ; 8400 }; 8401 }; 8402 // -=*# Resource for function TEXT #*=- 8403 Resource SC_OPCODE_TEXT 8404 { 8405 String 1 // Description 8406 { 8407 Text [ en-US ] = "Converts a number to text according to a given format." ; 8408 }; 8409 ExtraData = 8410 { 8411 0; 8412 ID_FUNCTION_GRP_TEXT; 8413 U2S( HID_FUNC_TEXT ); 8414 2; 0; 0; 8415 0; 8416 }; 8417 String 2 // Name of Parameter 1 8418 { 8419 Text [ en-US ] = "number" ; 8420 }; 8421 String 3 // Description of Parameter 1 8422 { 8423 Text [ en-US ] = "The numeric value to be converted." ; 8424 }; 8425 String 4 // Name of Parameter 2 8426 { 8427 Text [ en-US ] = "Format" ; 8428 }; 8429 String 5 // Description of Parameter 2 8430 { 8431 Text [ en-US ] = "The text that describes the format." ; 8432 }; 8433 }; 8434 // -=*# Resource for function T #*=- 8435 Resource SC_OPCODE_T 8436 { 8437 String 1 // Description 8438 { 8439 Text [ en-US ] = "Returns a value if it is text, otherwise an empty string." ; 8440 }; 8441 ExtraData = 8442 { 8443 0; 8444 ID_FUNCTION_GRP_TEXT; 8445 U2S( HID_FUNC_T ); 8446 1; 0; 8447 0; 8448 }; 8449 String 2 // Name of Parameter 1 8450 { 8451 Text [ en-US ] = "value" ; 8452 }; 8453 String 3 // Description of Parameter 1 8454 { 8455 Text [ en-US ] = "The value to be checked and returned if it is text." ; 8456 }; 8457 }; 8458 // -=*# Resource for function ERSETZEN #*=- 8459 Resource SC_OPCODE_REPLACE 8460 { 8461 String 1 // Description 8462 { 8463 Text [ en-US ] = "Replaces characters within a text string with a different text string." ; 8464 }; 8465 ExtraData = 8466 { 8467 0; 8468 ID_FUNCTION_GRP_TEXT; 8469 U2S( HID_FUNC_ERSETZEN ); 8470 4; 0; 0; 0; 0; 8471 0; 8472 }; 8473 String 2 // Name of Parameter 1 8474 { 8475 Text [ en-US ] = "Text" ; 8476 }; 8477 String 3 // Description of Parameter 1 8478 { 8479 Text [ en-US ] = "The text in which some characters are to be replaced." ; 8480 }; 8481 String 4 // Name of Parameter 2 8482 { 8483 Text [ en-US ] = "position" ; 8484 }; 8485 String 5 // Description of Parameter 2 8486 { 8487 Text [ en-US ] = "The character position from which text is to be replaced." ; 8488 }; 8489 String 6 // Name of Parameter 3 8490 { 8491 Text [ en-US ] = "length" ; 8492 }; 8493 String 7 // Description of Parameter 3 8494 { 8495 Text [ en-US ] = "The number of characters to be replaced." ; 8496 }; 8497 String 8 // Name of Parameter 4 8498 { 8499 Text [ en-US ] = "new text" ; 8500 }; 8501 String 9 // Description of Parameter 4 8502 { 8503 Text [ en-US ] = "The text to be inserted." ; 8504 }; 8505 }; 8506 // -=*# Resource for function FEST #*=- 8507 Resource SC_OPCODE_FIXED 8508 { 8509 String 1 // Description 8510 { 8511 Text [ en-US ] = "Formats a number with a fixed number of places after the decimal point and thousands separator." ; 8512 }; 8513 ExtraData = 8514 { 8515 0; 8516 ID_FUNCTION_GRP_TEXT; 8517 U2S( HID_FUNC_FEST ); 8518 3; 0; 0; 1; 8519 0; 8520 }; 8521 String 2 // Name of Parameter 1 8522 { 8523 Text [ en-US ] = "number" ; 8524 }; 8525 String 3 // Description of Parameter 1 8526 { 8527 Text [ en-US ] = "The number to be formatted." ; 8528 }; 8529 String 4 // Name of Parameter 2 8530 { 8531 Text [ en-US ] = "Decimals" ; 8532 }; 8533 String 5 // Description of Parameter 2 8534 { 8535 Text [ en-US ] = "Decimal places. The number of fixed decimal places that are to be displayed." ; 8536 }; 8537 String 6 // Name of Parameter 3 8538 { 8539 Text [ en-US ] = "No thousands separators" ; 8540 }; 8541 String 7 // Description of Parameter 3 8542 { 8543 Text [ en-US ] = "No thousands separator. True value, if existing and TRUE (unequal to 0), no thousands separators are set." ; 8544 }; 8545 }; 8546 // -=*# Resource for function LÄNGE #*=- 8547 Resource SC_OPCODE_LEN 8548 { 8549 String 1 // Description 8550 { 8551 Text [ en-US ] = "Calculates length of a text string." ; 8552 }; 8553 ExtraData = 8554 { 8555 0; 8556 ID_FUNCTION_GRP_TEXT; 8557 U2S( HID_FUNC_LAENGE ); 8558 1; 0; 8559 0; 8560 }; 8561 String 2 // Name of Parameter 1 8562 { 8563 Text [ en-US ] = "text" ; 8564 }; 8565 String 3 // Description of Parameter 1 8566 { 8567 Text [ en-US ] = "The text in which the length is to be determined." ; 8568 }; 8569 }; 8570 // -=*# Resource for function LINKS #*=- 8571 Resource SC_OPCODE_LEFT 8572 { 8573 String 1 // Description 8574 { 8575 Text [ en-US ] = "Returns the first character or characters of a text." ; 8576 }; 8577 ExtraData = 8578 { 8579 0; 8580 ID_FUNCTION_GRP_TEXT; 8581 U2S( HID_FUNC_LINKS ); 8582 2; 0; 1; 8583 0; 8584 }; 8585 String 2 // Name of Parameter 1 8586 { 8587 Text [ en-US ] = "text" ; 8588 }; 8589 String 3 // Description of Parameter 1 8590 { 8591 Text [ en-US ] = "The text where the initial partial words are to be determined." ; 8592 }; 8593 String 4 // Name of Parameter 2 8594 { 8595 Text [ en-US ] = "number" ; 8596 }; 8597 String 5 // Description of Parameter 2 8598 { 8599 Text [ en-US ] = "The number of characters for the start text." ; 8600 }; 8601 }; 8602 // -=*# Resource for function RECHTS #*=- 8603 Resource SC_OPCODE_RIGHT 8604 { 8605 String 1 // Description 8606 { 8607 Text [ en-US ] = "Returns the last character or characters of a text." ; 8608 }; 8609 ExtraData = 8610 { 8611 0; 8612 ID_FUNCTION_GRP_TEXT; 8613 U2S( HID_FUNC_RECHTS ); 8614 2; 0; 1; 8615 0; 8616 }; 8617 String 2 // Name of Parameter 1 8618 { 8619 Text [ en-US ] = "text" ; 8620 }; 8621 String 3 // Description of Parameter 1 8622 { 8623 Text [ en-US ] = "The text in which the end partial words are to be determined." ; 8624 }; 8625 String 4 // Name of Parameter 2 8626 { 8627 Text [ en-US ] = "number" ; 8628 }; 8629 String 5 // Description of Parameter 2 8630 { 8631 Text [ en-US ] = "The number of characters for the end text." ; 8632 }; 8633 }; 8634 // -=*# Resource for function TEIL #*=- 8635 Resource SC_OPCODE_MID 8636 { 8637 String 1 // Description 8638 { 8639 Text [ en-US ] = "Returns a partial text string of a text." ; 8640 }; 8641 ExtraData = 8642 { 8643 0; 8644 ID_FUNCTION_GRP_TEXT; 8645 U2S( HID_FUNC_TEIL ); 8646 3; 0; 0; 0; 8647 0; 8648 }; 8649 String 2 // Name of Parameter 1 8650 { 8651 Text [ en-US ] = "text" ; 8652 }; 8653 String 3 // Description of Parameter 1 8654 { 8655 Text [ en-US ] = "The text in which partial words are to be determined." ; 8656 }; 8657 String 4 // Name of Parameter 2 8658 { 8659 Text [ en-US ] = "start" ; 8660 }; 8661 String 5 // Description of Parameter 2 8662 { 8663 Text [ en-US ] = "The position from which the part word is to be determined." ; 8664 }; 8665 String 6 // Name of Parameter 3 8666 { 8667 Text [ en-US ] = "number" ; 8668 }; 8669 String 7 // Description of Parameter 3 8670 { 8671 Text [ en-US ] = "The number of characters for the text." ; 8672 }; 8673 }; 8674 // -=*# Resource for function WIEDERHOLEN #*=- 8675 Resource SC_OPCODE_REPT 8676 { 8677 String 1 // Description 8678 { 8679 Text [ en-US ] = "Repeats text a given number of times." ; 8680 }; 8681 ExtraData = 8682 { 8683 0; 8684 ID_FUNCTION_GRP_TEXT; 8685 U2S( HID_FUNC_WIEDERHOLEN ); 8686 2; 0; 0; 8687 0; 8688 }; 8689 String 2 // Name of Parameter 1 8690 { 8691 Text [ en-US ] = "text" ; 8692 }; 8693 String 3 // Description of Parameter 1 8694 { 8695 Text [ en-US ] = "The text to be repeated." ; 8696 }; 8697 String 4 // Name of Parameter 2 8698 { 8699 Text [ en-US ] = "number" ; 8700 }; 8701 String 5 // Description of Parameter 2 8702 { 8703 Text [ en-US ] = "The number of times the text is to be repeated." ; 8704 }; 8705 }; 8706 // -=*# Resource for function WECHSELN #*=- 8707 Resource SC_OPCODE_SUBSTITUTE 8708 { 8709 String 1 // Description 8710 { 8711 Text [ en-US ] = "Substitutes new text for old text in a string." ; 8712 }; 8713 ExtraData = 8714 { 8715 0; 8716 ID_FUNCTION_GRP_TEXT; 8717 U2S( HID_FUNC_WECHSELN ); 8718 4; 0; 0; 0; 1; 8719 0; 8720 }; 8721 String 2 // Name of Parameter 1 8722 { 8723 Text [ en-US ] = "text" ; 8724 }; 8725 String 3 // Description of Parameter 1 8726 { 8727 Text [ en-US ] = "The text in which partial words are to be replaced." ; 8728 }; 8729 String 4 // Name of Parameter 2 8730 { 8731 Text [ en-US ] = "search_text" ; 8732 }; 8733 String 5 // Description of Parameter 2 8734 { 8735 Text [ en-US ] = "The partial string to be (repeatedly) replaced." ; 8736 }; 8737 String 6 // Name of Parameter 3 8738 { 8739 Text [ en-US ] = "new text" ; 8740 }; 8741 String 7 // Description of Parameter 3 8742 { 8743 Text [ en-US ] = "The text which is to replace the text string." ; 8744 }; 8745 String 8 // Name of Parameter 4 8746 { 8747 Text [ en-US ] = "occurrence" ; 8748 }; 8749 String 9 // Description of Parameter 4 8750 { 8751 Text [ en-US ] = "Which occurrence of the old text is to be replaced." ; 8752 }; 8753 }; 8754 // -=*# Resource for function BASIS #*=- 8755 Resource SC_OPCODE_BASE 8756 { 8757 String 1 // Description 8758 { 8759 Text [ en-US ] = "Converts a positive integer to text from a number system to the base defined." ; 8760 }; 8761 ExtraData = 8762 { 8763 0; 8764 ID_FUNCTION_GRP_TEXT; 8765 U2S( HID_FUNC_BASIS ); 8766 3; 0; 0; 1; 8767 0; 8768 }; 8769 String 2 // Name of Parameter 1 8770 { 8771 Text [ en-US ] = "number" ; 8772 }; 8773 String 3 // Description of Parameter 1 8774 { 8775 Text [ en-US ] = "The number to be converted." ; 8776 }; 8777 String 4 // Name of Parameter 2 8778 { 8779 Text [ en-US ] = "radix" ; 8780 }; 8781 String 5 // Description of Parameter 2 8782 { 8783 Text [ en-US ] = "The base number for conversion must be in the range 2 - 36." ; 8784 }; 8785 String 6 // Name of Parameter 3 8786 { 8787 Text [ en-US ] = "Minimum length" ; 8788 }; 8789 String 7 // Description of Parameter 3 8790 { 8791 Text [ en-US ] = "If the text is shorter than the specified length, zeros are added to the left of the string." ; 8792 }; 8793 }; 8794 // -=*# Resource for function DEZIMAL #*=- 8795 Resource SC_OPCODE_DECIMAL 8796 { 8797 String 1 // Description 8798 { 8799 Text [ en-US ] = "Converts a text of a specified number system to a positive integer in the base given." ; 8800 }; 8801 ExtraData = 8802 { 8803 0; 8804 ID_FUNCTION_GRP_TEXT; 8805 U2S( HID_FUNC_DEZIMAL ); 8806 2; 0; 0; 8807 0; 8808 }; 8809 String 2 // Name of Parameter 1 8810 { 8811 Text [ en-US ] = "text" ; 8812 }; 8813 String 3 // Description of Parameter 1 8814 { 8815 Text [ en-US ] = "The text to be converted." ; 8816 }; 8817 String 4 // Name of Parameter 2 8818 { 8819 Text [ en-US ] = "radix" ; 8820 }; 8821 String 5 // Description of Parameter 2 8822 { 8823 Text [ en-US ] = "The base number for conversion must be in the range 2 - 36." ; 8824 }; 8825 }; 8826 // -=*# Resource for function CONVERT #*=- 8827 Resource SC_OPCODE_CONVERT 8828 { 8829 String 1 // Description 8830 { 8831 Text [ en-US ] = "Converts a value according to a conversion table in the configuration (calc.xcu)."; 8832 }; 8833 ExtraData = 8834 { 8835 0; 8836 ID_FUNCTION_GRP_MATH; 8837 U2S( HID_FUNC_UMRECHNEN ); 8838 3; 0; 0; 0; 8839 0; 8840 }; 8841 String 2 // Name of Parameter 1 8842 { 8843 Text [ en-US ] = "value" ; 8844 }; 8845 String 3 // Description of Parameter 1 8846 { 8847 Text [ en-US ] = "The value to be converted."; 8848 }; 8849 String 4 // Name of Parameter 2 8850 { 8851 Text [ en-US ] = "text" ; 8852 }; 8853 String 5 // Description of Parameter 2 8854 { 8855 Text [ en-US ] = "Unit from which something is converted, case-sensitive."; 8856 }; 8857 String 6 // Name of Parameter 3 8858 { 8859 Text [ en-US ] = "text" ; 8860 }; 8861 String 7 // Description of Parameter 3 8862 { 8863 Text [ en-US ] = "Unit into which something is converted, case-sensitive."; 8864 }; 8865 }; 8866 // -=*# Resource for function ROEMISCH #*=- 8867 Resource SC_OPCODE_ROMAN 8868 { 8869 String 1 // Description 8870 { 8871 Text [ en-US ] = "Converts a number to a Roman numeral."; 8872 }; 8873 ExtraData = 8874 { 8875 0; 8876 ID_FUNCTION_GRP_TEXT; 8877 U2S( HID_FUNC_ROEMISCH ); 8878 2; 0; 1; 8879 0; 8880 }; 8881 String 2 // Name of Parameter 1 8882 { 8883 Text [ en-US ] = "Number"; 8884 }; 8885 String 3 // Description of Parameter 1 8886 { 8887 Text [ en-US ] = "The number to be converted to a Roman numeral must be in the 0 - 3999 range."; 8888 }; 8889 String 4 // Name of Parameter 2 8890 { 8891 Text [ en-US ] = "Mode"; 8892 }; 8893 String 5 // Description of Parameter 2 8894 { 8895 Text [ en-US ] = "The more this value increases, the more the Roman numeral is simplified. The value must be in the 0 - 4 range."; 8896 }; 8897 }; 8898 // -=*# Resource for function ARABISCH #*=- 8899 Resource SC_OPCODE_ARABIC 8900 { 8901 String 1 // Description 8902 { 8903 Text [ en-US ] = "Calculates the value of a Roman numeral."; 8904 }; 8905 ExtraData = 8906 { 8907 0; 8908 ID_FUNCTION_GRP_TEXT; 8909 U2S( HID_FUNC_ARABISCH ); 8910 1; 0; 8911 0; 8912 }; 8913 String 2 // Name of Parameter 1 8914 { 8915 Text [ en-US ] = "Text"; 8916 }; 8917 String 3 // Description of Parameter 1 8918 { 8919 Text [ en-US ] = "The text that represents a Roman numeral."; 8920 }; 8921 }; 8922 Resource SC_OPCODE_INFO 8923 { 8924 String 1 8925 { 8926 Text [ en-US ] = "Returns information about the environment."; 8927 }; 8928 ExtraData = 8929 { 8930 0; 8931 ID_FUNCTION_GRP_INFO; 8932 U2S( HID_FUNC_INFO ); 8933 1; 0; 8934 0; 8935 }; 8936 String 2 8937 { 8938 Text [ en-US ] = "Text"; 8939 }; 8940 String 3 8941 { 8942 Text [ en-US ] = "Can be \"osversion\", \"system\", \"release\", \"numfile\", and \"recalc\"."; 8943 }; 8944 }; 8945 Resource SC_OPCODE_UNICODE 8946 { 8947 String 1 // Description 8948 { 8949 Text [ en-US ] = "Returns the numeric code for the first Unicode character in a text string." ; 8950 }; 8951 ExtraData = 8952 { 8953 0; 8954 ID_FUNCTION_GRP_TEXT; 8955 U2S( HID_FUNC_UNICODE ); 8956 1; 0; 8957 0; 8958 }; 8959 String 2 // Name of Parameter 1 8960 { 8961 Text [ en-US ] = "text" ; 8962 }; 8963 String 3 // Description of Parameter 1 8964 { 8965 Text [ en-US ] = "This is the text for which the code of the first character is to be found." ; 8966 }; 8967 }; 8968 Resource SC_OPCODE_UNICHAR 8969 { 8970 String 1 // Description 8971 { 8972 Text [ en-US ] = "Converts a code number into a Unicode character or letter." ; 8973 }; 8974 ExtraData = 8975 { 8976 0; 8977 ID_FUNCTION_GRP_TEXT; 8978 U2S( HID_FUNC_UNICHAR ); 8979 1; 0; 8980 0; 8981 }; 8982 String 2 // Name of Parameter 1 8983 { 8984 Text [ en-US ] = "number" ; 8985 }; 8986 String 3 // Description of Parameter 1 8987 { 8988 Text [ en-US ] = "The code value for the character." ; 8989 }; 8990 }; 8991 Resource SC_OPCODE_EUROCONVERT 8992 { 8993 String 1 // Description 8994 { 8995 Text [ en-US ] = "Converts a value from one to another Euro currency."; 8996 }; 8997 ExtraData = 8998 { 8999 0; // DOING 9000 ID_FUNCTION_GRP_MATH; 9001 U2S( HID_FUNC_EUROCONVERT ); 9002 5; 0; 0; 0; 1; 1; 9003 0; 9004 }; 9005 String 2 // Name of Parameter 1 9006 { 9007 Text [ en-US ] = "value" ; 9008 }; 9009 String 3 // Description of Parameter 1 9010 { 9011 Text [ en-US ] = "The value to be converted."; 9012 }; 9013 String 4 // Name of Parameter 2 9014 { 9015 Text [ en-US ] = "from_currency" ; 9016 }; 9017 String 5 // Description of Parameter 2 9018 { 9019 Text [ en-US ] = "ISO 4217 code of the currency from which is converted, case-sensitive."; 9020 }; 9021 String 6 // Name of Parameter 3 9022 { 9023 Text [ en-US ] = "to_currency" ; 9024 }; 9025 String 7 // Description of Parameter 3 9026 { 9027 Text [ en-US ] = "ISO 4217 code of the currency into which is converted, case-sensitive."; 9028 }; 9029 String 8 // Name of Parameter 4 9030 { 9031 Text [ en-US ] = "full_precision" ; 9032 }; 9033 String 9 // Description of Parameter 4 9034 { 9035 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."; 9036 }; 9037 String 10 // Name of Parameter 5 9038 { 9039 Text [ en-US ] = "triangulation_precision" ; 9040 }; 9041 String 11 // Description of Parameter 5 9042 { 9043 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."; 9044 Text [ x-comment ] = "This description uses almost all available space in the dialog, make sure translations fit in size." ; 9045 }; 9046 }; 9047 Resource SC_OPCODE_NUMBERVALUE 9048 { 9049 String 1 // Description 9050 { 9051 Text [ en-US ] = "Converts text to a number, in a locale-independent way." ; 9052 }; 9053 ExtraData = 9054 { 9055 1; // TODO: implementation and unsuppress 9056 ID_FUNCTION_GRP_TEXT; 9057 U2S( HID_FUNC_NUMBERVALUE ); 9058 2; 0; 0; 9059 0; 9060 }; 9061 String 2 // Name of Parameter 1 9062 { 9063 Text [ en-US ] = "text" ; 9064 }; 9065 String 3 // Description of Parameter 1 9066 { 9067 Text [ en-US ] = "The text to be converted to a number." ; 9068 }; 9069 String 4 // Name of Parameter 2 9070 { 9071 Text [ en-US ] = "decimal_point" ; 9072 }; 9073 String 5 // Description of Parameter 2 9074 { 9075 Text [ en-US ] = "Defines the character used as the decimal point." ; 9076 }; 9077 }; 9078}; 9079 9080#if defined(U2S) 9081#undef U2S 9082#endif 9083