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