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