1/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ 2/* 3 * This file is part of the LibreOffice project. 4 * 5 * This Source Code Form is subject to the terms of the Mozilla Public 6 * License, v. 2.0. If a copy of the MPL was not distributed with this 7 * file, You can obtain one at http://mozilla.org/MPL/2.0/. 8 * 9 * This file incorporates work covered by the following license notice: 10 * 11 * Licensed to the Apache Software Foundation (ASF) under one or more 12 * contributor license agreements. See the NOTICE file distributed 13 * with this work for additional information regarding copyright 14 * ownership. The ASF licenses this file to you under the Apache 15 * License, Version 2.0 (the "License"); you may not use this file 16 * except in compliance with the License. You may obtain a copy of 17 * the License at http://www.apache.org/licenses/LICENSE-2.0 . 18 */ 19#pragma once 20 21#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) 22 23/* Resource file for the function wizard / autopilot. 24 * 25 * For every function there is a StringArray with a resource id (offset by 26 * RID_SC_FUNC_DESCRIPTIONS_START) with the OpCode of the function 27 * 28 * In this stringarray, the description of the function is given as the first 29 * entry, followed by two entries for each parameter, first the type or name 30 * of the parameter, second a description of the parameter. 31 */ 32 33// -=*# Resource for function DCOUNT #*=- 34const char* SC_OPCODE_DB_COUNT_ARY[] = 35{ 36 NC_("SC_OPCODE_DB_COUNT", "Counts the cells of a data range whose contents match the search criteria."), 37 NC_("SC_OPCODE_DB_COUNT", "Database"), 38 NC_("SC_OPCODE_DB_COUNT", "The range of cells containing data."), 39 NC_("SC_OPCODE_DB_COUNT", "Database field"), 40 NC_("SC_OPCODE_DB_COUNT", "Indicates which database field (column) is to be used for the search criteria."), 41 NC_("SC_OPCODE_DB_COUNT", "Search criteria"), 42 NC_("SC_OPCODE_DB_COUNT", "Defines the cell range containing the search criteria.") 43}; 44 45// -=*# Resource for function DCOUNTA #*=- 46const char* SC_OPCODE_DB_COUNT_2_ARY[] = 47{ 48 NC_("SC_OPCODE_DB_COUNT_2", "Counts all non-blank cells of a data range where the content corresponds to the search criteria."), 49 NC_("SC_OPCODE_DB_COUNT_2", "Database"), 50 NC_("SC_OPCODE_DB_COUNT_2", "The range of cells containing data."), 51 NC_("SC_OPCODE_DB_COUNT_2", "Database field"), 52 NC_("SC_OPCODE_DB_COUNT_2", "Indicates which database field (column) is to be used for the search criteria."), 53 NC_("SC_OPCODE_DB_COUNT_2", "Search criteria"), 54 NC_("SC_OPCODE_DB_COUNT_2", "Defines the cell range containing the search criteria.") 55}; 56 57// -=*# Resource for function DAVERAGE #*=- 58const char* SC_OPCODE_DB_AVERAGE_ARY[] = 59{ 60 NC_("SC_OPCODE_DB_AVERAGE", "Returns the average value of all the cells of a data range whose contents match the search criteria."), 61 NC_("SC_OPCODE_DB_AVERAGE", "Database"), 62 NC_("SC_OPCODE_DB_AVERAGE", "The range of cells containing data."), 63 NC_("SC_OPCODE_DB_AVERAGE", "Database field"), 64 NC_("SC_OPCODE_DB_AVERAGE", "Indicates which database field (column) is to be used for the search criteria."), 65 NC_("SC_OPCODE_DB_AVERAGE", "Search criteria"), 66 NC_("SC_OPCODE_DB_AVERAGE", "Defines the cell range containing the search criteria.") 67}; 68 69// -=*# Resource for function DGET #*=- 70const char* SC_OPCODE_DB_GET_ARY[] = 71{ 72 NC_("SC_OPCODE_DB_GET", "Defines the contents of the cell of a data range which matches the search criteria."), 73 NC_("SC_OPCODE_DB_GET", "Database"), 74 NC_("SC_OPCODE_DB_GET", "The range of cells containing data."), 75 NC_("SC_OPCODE_DB_GET", "Database field"), 76 NC_("SC_OPCODE_DB_GET", "Indicates which database field (column) is to be used for the search criteria."), 77 NC_("SC_OPCODE_DB_GET", "Search criteria"), 78 NC_("SC_OPCODE_DB_GET", "Defines the cell range containing the search criteria.") 79}; 80 81// -=*# Resource for function DMAX #*=- 82const char* SC_OPCODE_DB_MAX_ARY[] = 83{ 84 NC_("SC_OPCODE_DB_MAX", "Returns the maximum value from all of the cells of a data range which correspond to the search criteria."), 85 NC_("SC_OPCODE_DB_MAX", "Database"), 86 NC_("SC_OPCODE_DB_MAX", "The range of cells containing data."), 87 NC_("SC_OPCODE_DB_MAX", "Database field"), 88 NC_("SC_OPCODE_DB_MAX", "Indicates which database field (column) is to be used for the search criteria."), 89 NC_("SC_OPCODE_DB_MAX", "Search criteria"), 90 NC_("SC_OPCODE_DB_MAX", "Defines the cell range containing the search criteria.") 91}; 92 93// -=*# Resource for function DMIN #*=- 94const char* SC_OPCODE_DB_MIN_ARY[] = 95{ 96 NC_("SC_OPCODE_DB_MIN", "Returns the minimum of all cells of a data range where the contents correspond to the search criteria."), 97 NC_("SC_OPCODE_DB_MIN", "Database"), 98 NC_("SC_OPCODE_DB_MIN", "The range of cells containing data."), 99 NC_("SC_OPCODE_DB_MIN", "Database field"), 100 NC_("SC_OPCODE_DB_MIN", "Indicates which database field (column) is to be used for the search criteria."), 101 NC_("SC_OPCODE_DB_MIN", "Search criteria"), 102 NC_("SC_OPCODE_DB_MIN", "Defines the cell range containing the search criteria.") 103}; 104 105// -=*# Resource for function DPRODUCT #*=- 106const char* SC_OPCODE_DB_PRODUCT_ARY[] = 107{ 108 NC_("SC_OPCODE_DB_PRODUCT", "Multiplies all cells of a data range where the contents match the search criteria."), 109 NC_("SC_OPCODE_DB_PRODUCT", "Database"), 110 NC_("SC_OPCODE_DB_PRODUCT", "The range of cells containing data."), 111 NC_("SC_OPCODE_DB_PRODUCT", "Database field"), 112 NC_("SC_OPCODE_DB_PRODUCT", "Indicates which database field (column) is to be used for the search criteria."), 113 NC_("SC_OPCODE_DB_PRODUCT", "Search criteria"), 114 NC_("SC_OPCODE_DB_PRODUCT", "Defines the cell range containing the search criteria.") 115}; 116 117// -=*# Resource for function DSTDEV #*=- 118const char* SC_OPCODE_DB_STD_DEV_ARY[] = 119{ 120 NC_("SC_OPCODE_DB_STD_DEV", "Calculates the standard deviation of all cells in a data range whose contents match the search criteria."), 121 NC_("SC_OPCODE_DB_STD_DEV", "Database"), 122 NC_("SC_OPCODE_DB_STD_DEV", "The range of cells containing data."), 123 NC_("SC_OPCODE_DB_STD_DEV", "Database field"), 124 NC_("SC_OPCODE_DB_STD_DEV", "Indicates which database field (column) is to be used for the search criteria."), 125 NC_("SC_OPCODE_DB_STD_DEV", "Search criteria"), 126 NC_("SC_OPCODE_DB_STD_DEV", "Defines the cell range containing the search criteria.") 127}; 128 129// -=*# Resource for function DSTDEVP #*=- 130const char* SC_OPCODE_DB_STD_DEV_P_ARY[] = 131{ 132 NC_("SC_OPCODE_DB_STD_DEV_P", "Returns the standard deviation with regards to the population of all cells of a data range matching the search criteria."), 133 NC_("SC_OPCODE_DB_STD_DEV_P", "Database"), 134 NC_("SC_OPCODE_DB_STD_DEV_P", "The range of cells containing data."), 135 NC_("SC_OPCODE_DB_STD_DEV_P", "Database field"), 136 NC_("SC_OPCODE_DB_STD_DEV_P", "Indicates which database field (column) is to be used for the search criteria."), 137 NC_("SC_OPCODE_DB_STD_DEV_P", "Search criteria"), 138 NC_("SC_OPCODE_DB_STD_DEV_P", "Defines the cell range containing the search criteria.") 139}; 140 141// -=*# Resource for function DSUM #*=- 142const char* SC_OPCODE_DB_SUM_ARY[] = 143{ 144 NC_("SC_OPCODE_DB_SUM", "Adds all the cells of a data range where the contents match the search criteria."), 145 NC_("SC_OPCODE_DB_SUM", "Database"), 146 NC_("SC_OPCODE_DB_SUM", "The range of cells containing data."), 147 NC_("SC_OPCODE_DB_SUM", "Database field"), 148 NC_("SC_OPCODE_DB_SUM", "Indicates which database field (column) is to be used for the search criteria."), 149 NC_("SC_OPCODE_DB_SUM", "Search criteria"), 150 NC_("SC_OPCODE_DB_SUM", "Defines the cell range containing the search criteria.") 151}; 152 153// -=*# Resource for function DVAR #*=- 154const char* SC_OPCODE_DB_VAR_ARY[] = 155{ 156 NC_("SC_OPCODE_DB_VAR", "Determines the variance of all the cells in a data range where the contents match the search criteria."), 157 NC_("SC_OPCODE_DB_VAR", "Database"), 158 NC_("SC_OPCODE_DB_VAR", "The range of cells containing data."), 159 NC_("SC_OPCODE_DB_VAR", "Database field"), 160 NC_("SC_OPCODE_DB_VAR", "Indicates which database field (column) is to be used for the search criteria."), 161 NC_("SC_OPCODE_DB_VAR", "Search criteria"), 162 NC_("SC_OPCODE_DB_VAR", "Defines the cell range containing the search criteria.") 163}; 164 165// -=*# Resource for function DVARP #*=- 166const char* SC_OPCODE_DB_VAR_P_ARY[] = 167{ 168 NC_("SC_OPCODE_DB_VAR_P", "Determines variance of a population based on all cells in a data range where contents match the search criteria."), 169 NC_("SC_OPCODE_DB_VAR_P", "Database"), 170 NC_("SC_OPCODE_DB_VAR_P", "The range of cells containing data."), 171 NC_("SC_OPCODE_DB_VAR_P", "Database field"), 172 NC_("SC_OPCODE_DB_VAR_P", "Indicates which database field (column) is to be used for the search criteria."), 173 NC_("SC_OPCODE_DB_VAR_P", "Search criteria"), 174 NC_("SC_OPCODE_DB_VAR_P", "Defines the cell range containing the search criteria.") 175}; 176 177// -=*# Resource for function DATE #*=- 178const char* SC_OPCODE_GET_DATE_ARY[] = 179{ 180 NC_("SC_OPCODE_GET_DATE", "Provides an internal number for the date given."), 181 NC_("SC_OPCODE_GET_DATE", "Year"), 182 NC_("SC_OPCODE_GET_DATE", "An integer between 1583 and 9956 or 0 and 99 (19xx or 20xx depending on the defined option)."), 183 NC_("SC_OPCODE_GET_DATE", "Month"), 184 NC_("SC_OPCODE_GET_DATE", "An integer between 1 and 12 representing the month."), 185 NC_("SC_OPCODE_GET_DATE", "Day"), 186 NC_("SC_OPCODE_GET_DATE", "An integer between 1 and 31 representing the day of the month.") 187}; 188 189// -=*# Resource for function DATE_VALUE #*=- 190const char* SC_OPCODE_GET_DATE_VALUE_ARY[] = 191{ 192 NC_("SC_OPCODE_GET_DATE_VALUE", "Returns an internal number for a text having a possible date format."), 193 NC_("SC_OPCODE_GET_DATE_VALUE", "Text"), 194 NC_("SC_OPCODE_GET_DATE_VALUE", "A text enclosed in quotation marks which returns a date in a %PRODUCTNAME date format.") 195}; 196 197// -=*# Resource for function DAY #*=- 198const char* SC_OPCODE_GET_DAY_ARY[] = 199{ 200 NC_("SC_OPCODE_GET_DAY", "Returns the sequential date of the month as an integer (1-31) in relation to the date value."), 201 NC_("SC_OPCODE_GET_DAY", "Number"), 202 NC_("SC_OPCODE_GET_DAY", "The internal number for the date.") 203}; 204 205// -=*# Resource for function DAYS360 #*=- 206const char* SC_OPCODE_GET_DIFF_DATE_360_ARY[] = 207{ 208 NC_("SC_OPCODE_GET_DIFF_DATE_360", "Calculates the number of days between two dates based on a 360-day year."), 209 NC_("SC_OPCODE_GET_DIFF_DATE_360", "Date 1"), 210 NC_("SC_OPCODE_GET_DIFF_DATE_360", "The start date for calculating the difference in days."), 211 NC_("SC_OPCODE_GET_DIFF_DATE_360", "Date 2"), 212 NC_("SC_OPCODE_GET_DIFF_DATE_360", "The end date for calculating the difference in days."), 213 NC_("SC_OPCODE_GET_DIFF_DATE_360", "Type"), 214 NC_("SC_OPCODE_GET_DIFF_DATE_360", "Method used to form differences: Type = 0 denotes US method (NASD), Type = 1 denotes the European method.") 215}; 216 217// -=*# Resource for function NETWORKDAYS #*=- 218const char* SC_OPCODE_NETWORKDAYS_ARY[] = 219{ 220 NC_("SC_OPCODE_NETWORKDAYS", "Returns the number of workdays between two dates using arguments to indicate weekenddays and holidays."), 221 NC_("SC_OPCODE_NETWORKDAYS", "Start date"), 222 NC_("SC_OPCODE_NETWORKDAYS", "Start date for calculation."), 223 NC_("SC_OPCODE_NETWORKDAYS", "End date"), 224 NC_("SC_OPCODE_NETWORKDAYS", "End date for calculation."), 225 NC_("SC_OPCODE_NETWORKDAYS", "List of dates"), 226 NC_("SC_OPCODE_NETWORKDAYS", "Optional set of one or more dates to be considered as holiday."), 227 NC_("SC_OPCODE_NETWORKDAYS", "Array"), 228 NC_("SC_OPCODE_NETWORKDAYS", "Optional list of numbers to indicate working (0) and weekend (non-zero) days. When omitted, weekend is Saturday and Sunday.") 229}; 230 231// -=*# Resource for function NETWORKDAYS.INTL #*=- 232const char* SC_OPCODE_NETWORKDAYS_MS_ARY[] = 233{ 234 NC_("SC_OPCODE_NETWORKDAYS_MS", "Returns the number of workdays between two dates using arguments to indicate weekend days and holidays."), 235 NC_("SC_OPCODE_NETWORKDAYS_MS", "Start date"), 236 NC_("SC_OPCODE_NETWORKDAYS_MS", "Start date for calculation."), 237 NC_("SC_OPCODE_NETWORKDAYS_MS", "End date"), 238 NC_("SC_OPCODE_NETWORKDAYS_MS", "End date for calculation."), 239 NC_("SC_OPCODE_NETWORKDAYS_MS", "Number or string"), 240 NC_("SC_OPCODE_NETWORKDAYS_MS", "Optional number or string to indicate when weekends occur. When omitted, weekend is Saturday and Sunday."), 241 NC_("SC_OPCODE_NETWORKDAYS_MS", "Array"), 242 NC_("SC_OPCODE_NETWORKDAYS_MS", "Optional set of one or more dates to be considered as holiday.") 243}; 244 245// -=*# Resource for function WORKDAY.INTL #*=- 246const char* SC_OPCODE_WORKDAY_MS_ARY[] = 247{ 248 NC_("SC_OPCODE_WORKDAY_MS", "Returns the serial number of the date before or after a number of workdays using arguments to indicate weekend days and holidays."), 249 NC_("SC_OPCODE_WORKDAY_MS", "Start date"), 250 NC_("SC_OPCODE_WORKDAY_MS", "Start date for calculation."), 251 NC_("SC_OPCODE_WORKDAY_MS", "Days"), 252 NC_("SC_OPCODE_WORKDAY_MS", "The number of workdays before or after start date."), 253 NC_("SC_OPCODE_WORKDAY_MS", "Number or string"), 254 NC_("SC_OPCODE_WORKDAY_MS", "Optional number or string to indicate when weekends occur. When omitted, weekend is Saturday and Sunday."), 255 NC_("SC_OPCODE_WORKDAY_MS", "Array"), 256 NC_("SC_OPCODE_WORKDAY_MS", "Optional set of one or more dates to be considered as holiday.") 257}; 258 259// -=*# Resource for function HOUR #*=- 260const char* SC_OPCODE_GET_HOUR_ARY[] = 261{ 262 NC_("SC_OPCODE_GET_HOUR", "Determines the sequential number of the hour of the day (0-23) for the time value."), 263 NC_("SC_OPCODE_GET_HOUR", "Number"), 264 NC_("SC_OPCODE_GET_HOUR", "Internal time value") 265}; 266 267// -=*# Resource for function MINUTE #*=- 268const char* SC_OPCODE_GET_MIN_ARY[] = 269{ 270 NC_("SC_OPCODE_GET_MIN", "Determines the sequential number for the minute of the hour (0-59) for the time value."), 271 NC_("SC_OPCODE_GET_MIN", "Number"), 272 NC_("SC_OPCODE_GET_MIN", "Internal time value.") 273}; 274 275// -=*# Resource for function MONTH #*=- 276const char* SC_OPCODE_GET_MONTH_ARY[] = 277{ 278 NC_("SC_OPCODE_GET_MONTH", "Determines the sequential number of a month of the year (1-12) for the date value."), 279 NC_("SC_OPCODE_GET_MONTH", "Number"), 280 NC_("SC_OPCODE_GET_MONTH", "The internal number of the date.") 281}; 282 283// -=*# Resource for function NOW #*=- 284const char* SC_OPCODE_GET_ACT_TIME_ARY[] = 285{ 286 NC_("SC_OPCODE_GET_ACT_TIME", "Determines the current time of the computer.") 287}; 288 289// -=*# Resource for function SECOND #*=- 290const char*SC_OPCODE_GET_SEC_ARY[] = 291{ 292 NC_("SC_OPCODE_GET_SEC", "Determines the sequential number of the second of a minute (0-59) for the time value."), 293 NC_("SC_OPCODE_GET_SEC", "Number"), 294 NC_("SC_OPCODE_GET_SEC", "The internal time value.") 295}; 296 297// -=*# Resource for function TIME #*=- 298const char* SC_OPCODE_GET_TIME_ARY[] = 299{ 300 NC_("SC_OPCODE_GET_TIME", "Determines a time value from the details for hour, minute and second."), 301 NC_("SC_OPCODE_GET_TIME", "Hour"), 302 NC_("SC_OPCODE_GET_TIME", "The integer for the hour."), 303 NC_("SC_OPCODE_GET_TIME", "Minute"), 304 NC_("SC_OPCODE_GET_TIME", "The integer for the minute."), 305 NC_("SC_OPCODE_GET_TIME", "Second"), 306 NC_("SC_OPCODE_GET_TIME", "The integer for the second.") 307}; 308 309// -=*# Resource for function TIMEVALUE #*=- 310const char* SC_OPCODE_GET_TIME_VALUE_ARY[] = 311{ 312 NC_("SC_OPCODE_GET_TIME_VALUE", "Returns a sequential number for a text shown in a possible time entry format."), 313 NC_("SC_OPCODE_GET_TIME_VALUE", "Text"), 314 NC_("SC_OPCODE_GET_TIME_VALUE", "A text enclosed in quotation marks which returns a time in a %PRODUCTNAME time format.") 315}; 316 317// -=*# Resource for function TODAY #*=- 318const char* SC_OPCODE_GET_ACT_DATE_ARY[] = 319{ 320 NC_("SC_OPCODE_GET_ACT_DATE", "Determines the current date of the computer.") 321}; 322 323// -=*# Resource for function WEEKDAY #*=- 324const char* SC_OPCODE_GET_DAY_OF_WEEK_ARY[] = 325{ 326 NC_("SC_OPCODE_GET_DAY_OF_WEEK", "Returns the day of the week for the date value as an integer."), 327 NC_("SC_OPCODE_GET_DAY_OF_WEEK", "Number"), 328 NC_("SC_OPCODE_GET_DAY_OF_WEEK", "The internal number for the date."), 329 NC_("SC_OPCODE_GET_DAY_OF_WEEK", "Type"), 330 NC_("SC_OPCODE_GET_DAY_OF_WEEK", "Fixes the beginning of the week and the type of calculation to be used.") 331}; 332 333// -=*# Resource for function YEAR #*=- 334const char* SC_OPCODE_GET_YEAR_ARY[] = 335{ 336 NC_("SC_OPCODE_GET_YEAR", "Returns the year of a date value as an integer."), 337 NC_("SC_OPCODE_GET_YEAR", "Number"), 338 NC_("SC_OPCODE_GET_YEAR", "Internal number of the date.") 339}; 340 341// -=*# Resource for function DAYS #*=- 342const char* SC_OPCODE_GET_DIFF_DATE_ARY[] = 343{ 344 NC_("SC_OPCODE_GET_DIFF_DATE", "Calculates the number of days between two dates."), 345 NC_("SC_OPCODE_GET_DIFF_DATE", "Date 2"), 346 NC_("SC_OPCODE_GET_DIFF_DATE", "The end date for calculating the difference in days."), 347 NC_("SC_OPCODE_GET_DIFF_DATE", "Date 1"), 348 NC_("SC_OPCODE_GET_DIFF_DATE", "The start date for calculating the difference in days.") 349}; 350 351// -=*# Resource for function DATEDIF #*=- 352const char* SC_OPCODE_GET_DATEDIF_ARY[] = 353{ 354 NC_("SC_OPCODE_GET_DATEDIF", "Returns the number of whole days, months or years between 'start date' and 'end date'."), 355 NC_("SC_OPCODE_GET_DATEDIF", "Start date"), 356 NC_("SC_OPCODE_GET_DATEDIF", "The start date."), 357 NC_("SC_OPCODE_GET_DATEDIF", "End date"), 358 NC_("SC_OPCODE_GET_DATEDIF", "The end date."), 359 NC_("SC_OPCODE_GET_DATEDIF", "Interval"), 360 NC_("SC_OPCODE_GET_DATEDIF", "Interval to be calculated. Can be \"d\", \"m\", \"y\", \"ym\", \"md\" or \"yd\".") 361}; 362 363// -=*# Resource for function WEEKNUM #*=- 364const char* SC_OPCODE_WEEK_ARY[] = 365{ 366 NC_("SC_OPCODE_WEEK", "Calculates the calendar week corresponding to the given date."), 367 NC_("SC_OPCODE_WEEK", "Number"), 368 NC_("SC_OPCODE_WEEK", "The internal number of the date."), 369 NC_("SC_OPCODE_WEEK", "Mode"), 370 NC_("SC_OPCODE_WEEK", "Indicates the first day of the week and when week 1 starts.") 371}; 372 373// -=*# Resource for function ISOWEEKNUM #*=- 374const char* SC_OPCODE_ISOWEEKNUM_ARY[] = 375{ 376 NC_("SC_OPCODE_ISOWEEKNUM", "Calculates the ISO 8601 calendar week for the given date."), 377 NC_("SC_OPCODE_ISOWEEKNUM", "Number"), 378 NC_("SC_OPCODE_ISOWEEKNUM", "The internal number of the date.") 379}; 380 381const char* SC_OPCODE_WEEKNUM_OOO_ARY[] = 382{ 383 NC_("SC_OPCODE_WEEKNUM_OOO", "Calculates the calendar week corresponding to the given date.\nThis function only provides interoperability with %PRODUCTNAME 5.0 and earlier and OpenOffice.org."), 384 NC_("SC_OPCODE_WEEKNUM_OOO", "Number"), 385 NC_("SC_OPCODE_WEEKNUM_OOO", "The internal number of the date."), 386 NC_("SC_OPCODE_WEEKNUM_OOO", "Mode"), 387 NC_("SC_OPCODE_WEEKNUM_OOO", "Indicates the first day of the week (1 = Sunday, other values = Monday).") 388}; 389 390// -=*# Resource for function EASTERSUNDAY #*=- 391const char* SC_OPCODE_EASTERSUNDAY_ARY[] = 392{ 393 NC_("SC_OPCODE_EASTERSUNDAY", "Calculates the date of Easter Sunday in a given year."), 394 NC_("SC_OPCODE_EASTERSUNDAY", "Year"), 395 NC_("SC_OPCODE_EASTERSUNDAY", "An integer between 1583 and 9956, or 0 and 99 (19xx or 20xx depending on the option set).") 396}; 397 398// -=*# Resource for function PV #*=- 399const char* SC_OPCODE_PV_ARY[] = 400{ 401 NC_("SC_OPCODE_PV", "Present value. Calculates the present value of an investment."), 402 NC_("SC_OPCODE_PV", "Rate"), 403 NC_("SC_OPCODE_PV", "The rate of interest for the period given."), 404 NC_("SC_OPCODE_PV", "NPER"), 405 NC_("SC_OPCODE_PV", "The payment period. The total number of periods in which the annuity is paid."), 406 NC_("SC_OPCODE_PV", "PMT"), 407 NC_("SC_OPCODE_PV", "Regular payments. The constant amount of annuity that is paid in each period."), 408 NC_("SC_OPCODE_PV", "FV"), 409 NC_("SC_OPCODE_PV", "Future value. The value (final value) to be attained after the last payment."), 410 NC_("SC_OPCODE_PV", "Type"), 411 NC_("SC_OPCODE_PV", "Type = 1 denotes due at the beginning of the period, = 0 at the end.") 412}; 413 414// -=*# Resource for function FV #*=- 415const char* SC_OPCODE_FV_ARY[] = 416{ 417 NC_("SC_OPCODE_FV", "Future value. Returns the future value of an investment based on regular payments and a constant interest rate."), 418 NC_("SC_OPCODE_FV", "Rate"), 419 NC_("SC_OPCODE_FV", "The rate of interest per period."), 420 NC_("SC_OPCODE_FV", "NPER"), 421 NC_("SC_OPCODE_FV", "Payment period. The total number of periods in which the annuity (pension) is paid."), 422 NC_("SC_OPCODE_FV", "PMT"), 423 NC_("SC_OPCODE_FV", "Regular payments. The constant annuity to be paid in each period."), 424 NC_("SC_OPCODE_FV", "PV"), 425 NC_("SC_OPCODE_FV", "Present value. The current value of a series of payments"), 426 NC_("SC_OPCODE_FV", "Type"), 427 NC_("SC_OPCODE_FV", "Type = 1 denotes due at the beginning of the period, = 0 at the end.") 428}; 429 430// -=*# Resource for function NPER #*=- 431const char* SC_OPCODE_NPER_ARY[] = 432{ 433 NC_("SC_OPCODE_NPER", "Payment period. Calculates the number of payment periods for an investment based on regular payments and a constant interest rate."), 434 NC_("SC_OPCODE_NPER", "Rate"), 435 NC_("SC_OPCODE_NPER", "The rate of interest per period."), 436 NC_("SC_OPCODE_NPER", "PMT"), 437 NC_("SC_OPCODE_NPER", "Regular payments. The constant annuity to be paid in each period."), 438 NC_("SC_OPCODE_NPER", "PV"), 439 NC_("SC_OPCODE_NPER", "Present value. The current value of a series of payments"), 440 NC_("SC_OPCODE_NPER", "FV"), 441 NC_("SC_OPCODE_NPER", "Future value. The value (end value) to be attained after the final payment."), 442 NC_("SC_OPCODE_NPER", "Type"), 443 NC_("SC_OPCODE_NPER", "Type = 1 denotes due at the beginning of the period, = 0 at the end.") 444}; 445 446// -=*# Resource for function PMT #*=- 447const char* SC_OPCODE_PMT_ARY[] = 448{ 449 NC_("SC_OPCODE_PMT", "Regular payments. Returns the periodic payment of an annuity, based on regular payments and a fixed periodic interest rate."), 450 NC_("SC_OPCODE_PMT", "Rate"), 451 NC_("SC_OPCODE_PMT", "The rate of interest per period."), 452 NC_("SC_OPCODE_PMT", "NPER"), 453 NC_("SC_OPCODE_PMT", "Payment period. The total number of periods in which the annuity (pension) is paid."), 454 NC_("SC_OPCODE_PMT", "PV"), 455 NC_("SC_OPCODE_PMT", "Present value. The current value of a series of payments"), 456 NC_("SC_OPCODE_PMT", "FV"), 457 NC_("SC_OPCODE_PMT", "Future value. The value (end value) to be attained after the final payment."), 458 NC_("SC_OPCODE_PMT", "Type"), 459 NC_("SC_OPCODE_PMT", "Type = 1 denotes due at the beginning of the period, = 0 at the end.") 460}; 461 462// -=*# Resource for function RATE #*=- 463const char* SC_OPCODE_RATE_ARY[] = 464{ 465 NC_("SC_OPCODE_RATE", "Calculates the constant interest rate of an investment with regular payments."), 466 NC_("SC_OPCODE_RATE", "NPER"), 467 NC_("SC_OPCODE_RATE", "Payment period. The total number of periods in which the annuity (pension) is paid."), 468 NC_("SC_OPCODE_RATE", "PMT"), 469 NC_("SC_OPCODE_RATE", "Regular payments. The constant annuity to be paid in each period."), 470 NC_("SC_OPCODE_RATE", "PV"), 471 NC_("SC_OPCODE_RATE", "Present value. The current value of a series of payments"), 472 NC_("SC_OPCODE_RATE", "FV"), 473 NC_("SC_OPCODE_RATE", "Future value. The value (end value) to be attained after the final payment."), 474 NC_("SC_OPCODE_RATE", "Type"), 475 NC_("SC_OPCODE_RATE", "Type = 1 denotes due at the beginning of the period, = 0 at the end."), 476 NC_("SC_OPCODE_RATE", "Guess"), 477 NC_("SC_OPCODE_RATE", "Guess. The estimate of the interest rate for the iterative calculating method.") 478}; 479 480// -=*# Resource for function IPMT #*=- 481const char* SC_OPCODE_IPMT_ARY[] = 482{ 483 NC_("SC_OPCODE_IPMT", "Compounded interest. Calculates the interest payment on the principal for an investment with regular payments and a constant interest rate for a given period."), 484 NC_("SC_OPCODE_IPMT", "Rate"), 485 NC_("SC_OPCODE_IPMT", "The rate of interest per period."), 486 NC_("SC_OPCODE_IPMT", "Period"), 487 NC_("SC_OPCODE_IPMT", "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."), 488 NC_("SC_OPCODE_IPMT", "NPER"), 489 NC_("SC_OPCODE_IPMT", "Payment period. The total number of periods in which the annuity (pension) is paid."), 490 NC_("SC_OPCODE_IPMT", "PV"), 491 NC_("SC_OPCODE_IPMT", "Present value. The current value of a series of payments"), 492 NC_("SC_OPCODE_IPMT", "FV"), 493 NC_("SC_OPCODE_IPMT", "Future value. The value (end value) to be attained after the final payment."), 494 NC_("SC_OPCODE_IPMT", "Type"), 495 NC_("SC_OPCODE_IPMT", "Type = 1 denotes due at the beginning of the period, = 0 at the end.") 496}; 497 498// -=*# Resource for function PPMT #*=- 499const char* SC_OPCODE_PPMT_ARY[] = 500{ 501 NC_("SC_OPCODE_PPMT", "Repayment. Calculates the repayment amount for a period for an investment whereby the payments are at regular intervals and the interest rate constant."), 502 NC_("SC_OPCODE_PPMT", "Rate"), 503 NC_("SC_OPCODE_PPMT", "The interest rate per period."), 504 NC_("SC_OPCODE_PPMT", "Period"), 505 NC_("SC_OPCODE_PPMT", "Period. The period for which the repayments are to be calculated. Per = 1 denotes for the first period, P = NPER for the last"), 506 NC_("SC_OPCODE_PPMT", "NPER"), 507 NC_("SC_OPCODE_PPMT", "The payment period. The total number of periods in which the annuity (pension) is paid."), 508 NC_("SC_OPCODE_PPMT", "PV"), 509 NC_("SC_OPCODE_PPMT", "The present value. The present value or the amount the annuity is currently worth."), 510 NC_("SC_OPCODE_PPMT", "FV"), 511 NC_("SC_OPCODE_PPMT", "Future value. The value (end value) attained after the last payment has been made."), 512 NC_("SC_OPCODE_PPMT", "Type"), 513 NC_("SC_OPCODE_PPMT", "Type = 1 denotes due at the beginning of the period, = 0 at the end.") 514}; 515 516// -=*# Resource for function CUMPRINC #*=- 517const char* SC_OPCODE_CUM_PRINC_ARY[] = 518{ 519 NC_("SC_OPCODE_CUM_PRINC", "Cumulative capital. Calculates the total amount of the repayment share in a period for an investment with constant interest rate."), 520 NC_("SC_OPCODE_CUM_PRINC", "Rate"), 521 NC_("SC_OPCODE_CUM_PRINC", "The rate of interest per period."), 522 NC_("SC_OPCODE_CUM_PRINC", "NPER"), 523 NC_("SC_OPCODE_CUM_PRINC", "Payment period. The total number of periods in which the annuity (pension) is paid."), 524 NC_("SC_OPCODE_CUM_PRINC", "PV"), 525 NC_("SC_OPCODE_CUM_PRINC", "The present value. The present value or the amount the annuity is currently worth."), 526 NC_("SC_OPCODE_CUM_PRINC", "S"), 527 NC_("SC_OPCODE_CUM_PRINC", "The start period. The first period to be taken into account. S = 1 denotes the very first period."), 528 NC_("SC_OPCODE_CUM_PRINC", "E"), 529 NC_("SC_OPCODE_CUM_PRINC", "End period. The last period to be taken into account."), 530 NC_("SC_OPCODE_CUM_PRINC", "Type"), 531 NC_("SC_OPCODE_CUM_PRINC", "Type = 1 denotes due at the beginning of the period, = 0 at the end.") 532}; 533 534// -=*# Resource for function CUMIPMT #*=- 535const char* SC_OPCODE_CUM_IPMT_ARY[] = 536{ 537 NC_("SC_OPCODE_CUM_IPMT", "Cumulative compounded interest. Calculates the total amount of the interest share in a period for an investment with a constant interest rate."), 538 NC_("SC_OPCODE_CUM_IPMT", "Rate"), 539 NC_("SC_OPCODE_CUM_IPMT", "The rate of interest per period."), 540 NC_("SC_OPCODE_CUM_IPMT", "NPER"), 541 NC_("SC_OPCODE_CUM_IPMT", "Payment period. The total number of periods in which the annuity (pension) is paid."), 542 NC_("SC_OPCODE_CUM_IPMT", "PV"), 543 NC_("SC_OPCODE_CUM_IPMT", "The present value. The present value or the amount the annuity is currently worth."), 544 NC_("SC_OPCODE_CUM_IPMT", "S"), 545 NC_("SC_OPCODE_CUM_IPMT", "The start period. The first period to be taken into account. S = 1 denotes the very first period."), 546 NC_("SC_OPCODE_CUM_IPMT", "E"), 547 NC_("SC_OPCODE_CUM_IPMT", "The end period. The last period to be taken into account."), 548 NC_("SC_OPCODE_CUM_IPMT", "Type"), 549 NC_("SC_OPCODE_CUM_IPMT", "Type = 1 denotes due at the beginning of the period, = 0 at the end.") 550}; 551 552// -=*# Resource for function SYD #*=- 553const char* SC_OPCODE_SYD_ARY[] = 554{ 555 NC_("SC_OPCODE_SYD", "Calculates the arithmetically declining value of an asset (depreciation) for a specified period."), 556 NC_("SC_OPCODE_SYD", "Cost"), 557 NC_("SC_OPCODE_SYD", "Acquisition costs. The initial cost of the asset."), 558 NC_("SC_OPCODE_SYD", "Salvage"), 559 NC_("SC_OPCODE_SYD", "Salvage: The remaining value of the asset at the end of its life."), 560 NC_("SC_OPCODE_SYD", "Life"), 561 NC_("SC_OPCODE_SYD", "Useful life. The number of periods in the useful life of the asset."), 562 NC_("SC_OPCODE_SYD", "Period"), 563 NC_("SC_OPCODE_SYD", "Period. The depreciation period which must have the same time unit as average useful life.") 564}; 565 566// -=*# Resource for function SLN #*=- 567const char* SC_OPCODE_SLN_ARY[] = 568{ 569 NC_("SC_OPCODE_SLN", "Calculates the linear depreciation per period."), 570 NC_("SC_OPCODE_SLN", "Cost"), 571 NC_("SC_OPCODE_SLN", "Acquisition cost. The initial cost of an asset."), 572 NC_("SC_OPCODE_SLN", "Salvage"), 573 NC_("SC_OPCODE_SLN", "Salvage: The remaining value of the asset at the end of its life."), 574 NC_("SC_OPCODE_SLN", "Life"), 575 NC_("SC_OPCODE_SLN", "Useful life. The number of periods in the useful life of the asset.") 576}; 577 578// -=*# Resource for function DDB #*=- 579const char* SC_OPCODE_DDB_ARY[] = 580{ 581 NC_("SC_OPCODE_DDB", "Calculates the depreciation of an asset for a specific period using the double-declining balance method or declining balance factor."), 582 NC_("SC_OPCODE_DDB", "Cost"), 583 NC_("SC_OPCODE_DDB", "Acquisition costs. The initial cost of the asset."), 584 NC_("SC_OPCODE_DDB", "Salvage"), 585 NC_("SC_OPCODE_DDB", "Salvage: The remaining value of the asset at the end of its life."), 586 NC_("SC_OPCODE_DDB", "Life"), 587 NC_("SC_OPCODE_DDB", "Useful life. The number of periods in the useful life of the asset."), 588 NC_("SC_OPCODE_DDB", "Period"), 589 NC_("SC_OPCODE_DDB", "Period. The depreciation period in the same time unit as the average useful life entry."), 590 NC_("SC_OPCODE_DDB", "Factor"), 591 NC_("SC_OPCODE_DDB", "Factor. The factor for balance decline. F = 2 means a double declining balance factor") 592}; 593 594// -=*# Resource for function DB #*=- 595const char* SC_OPCODE_DB_ARY[] = 596{ 597 NC_("SC_OPCODE_DB", "Returns the real depreciation of an asset for a specified period using the fixed-declining balance method."), 598 NC_("SC_OPCODE_DB", "Cost"), 599 NC_("SC_OPCODE_DB", "Acquisition costs: The initial cost of the asset."), 600 NC_("SC_OPCODE_DB", "Salvage"), 601 NC_("SC_OPCODE_DB", "Salvage: The remaining value of the asset at the end of its life."), 602 NC_("SC_OPCODE_DB", "Life"), 603 NC_("SC_OPCODE_DB", "Useful life. The number of periods in the useful life of the asset."), 604 NC_("SC_OPCODE_DB", "Period"), 605 NC_("SC_OPCODE_DB", "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."), 606 NC_("SC_OPCODE_DB", "Month"), 607 NC_("SC_OPCODE_DB", "Months: The number of months in the first year of depreciation.") 608}; 609 610// -=*# Resource for function VDB #*=- 611const char* SC_OPCODE_VBD_ARY[] = 612{ 613 NC_("SC_OPCODE_VBD", "Variable declining balance. Returns the declining balance depreciation for a particular period."), 614 NC_("SC_OPCODE_VBD", "Cost"), 615 NC_("SC_OPCODE_VBD", "Cost. The initial cost of the asset."), 616 NC_("SC_OPCODE_VBD", "Salvage"), 617 NC_("SC_OPCODE_VBD", "Salvage. The salvage value of an asset at the end of its useful life."), 618 NC_("SC_OPCODE_VBD", "Life"), 619 NC_("SC_OPCODE_VBD", "Useful life. The number of periods in the useful life of the asset."), 620 NC_("SC_OPCODE_VBD", "Start"), 621 NC_("SC_OPCODE_VBD", "Start. The first period for depreciation in the same time unit as the useful life."), 622 NC_("SC_OPCODE_VBD", "End"), 623 NC_("SC_OPCODE_VBD", "End. The last period of the depreciation using the same time unit as for the useful life."), 624 NC_("SC_OPCODE_VBD", "Factor"), 625 NC_("SC_OPCODE_VBD", "Factor. The factor for the reduction of the depreciation. Factor = 2 denotes double rate depreciation."), 626 NC_("SC_OPCODE_VBD", "NoSwitch"), 627 NC_("SC_OPCODE_VBD", "NoSwitch = 0 denotes switch to linear depreciation, NoSwitch = 1 do not switch.") 628}; 629 630// -=*# Resource for function EFFECT #*=- 631const char* SC_OPCODE_EFFECT_ARY[] = 632{ 633 NC_("SC_OPCODE_EFFECT", "Calculates the annual net interest rate for a nominal interest rate."), 634 NC_("SC_OPCODE_EFFECT", "NOM"), 635 NC_("SC_OPCODE_EFFECT", "Nominal interest"), 636 NC_("SC_OPCODE_EFFECT", "P"), 637 NC_("SC_OPCODE_EFFECT", "Periods. The number of interest payments per year.") 638}; 639 640// -=*# Resource for function NOMINAL #*=- 641const char* SC_OPCODE_NOMINAL_ARY[] = 642{ 643 NC_("SC_OPCODE_NOMINAL", "Calculates the yearly nominal interest rate as an effective interest rate."), 644 NC_("SC_OPCODE_NOMINAL", "Effective rate"), 645 NC_("SC_OPCODE_NOMINAL", "The effective interest rate"), 646 NC_("SC_OPCODE_NOMINAL", "NPER"), 647 NC_("SC_OPCODE_NOMINAL", "Periods. The number of interest payment per year.") 648}; 649 650// -=*# Resource for function NPV #*=- 651const char* SC_OPCODE_NPV_ARY[] = 652{ 653 NC_("SC_OPCODE_NPV", "Net present value. Calculates the net present value of an investment based on a series of periodic payments and a discount rate."), 654 NC_("SC_OPCODE_NPV", "Rate"), 655 NC_("SC_OPCODE_NPV", "The rate of discount for one period."), 656 NC_("SC_OPCODE_NPV", "Value "), 657 NC_("SC_OPCODE_NPV", "Value 1, value 2,... are arguments representing payments and income.") 658}; 659 660// -=*# Resource for function IRR #*=- 661const char* SC_OPCODE_IRR_ARY[] = 662{ 663 NC_("SC_OPCODE_IRR", "Returns the actuarial rate of interest of an investment excluding costs or profits."), 664 NC_("SC_OPCODE_IRR", "Values"), 665 NC_("SC_OPCODE_IRR", "An array or reference to cells whose contents correspond to the payments."), 666 NC_("SC_OPCODE_IRR", "Guess"), 667 NC_("SC_OPCODE_IRR", "Guess. An estimated value of the rate of return to be used for the iteration calculation.") 668}; 669 670// -=*# Resource for function MIRR #*=- 671const char* SC_OPCODE_MIRR_ARY[] = 672{ 673 NC_("SC_OPCODE_MIRR", "Returns the modified internal rate of return for a series of investments."), 674 NC_("SC_OPCODE_MIRR", "Values"), 675 NC_("SC_OPCODE_MIRR", "An array or reference to cells whose contents correspond to the payments."), 676 NC_("SC_OPCODE_MIRR", "Investment"), 677 NC_("SC_OPCODE_MIRR", "Interest rate for investments (the negative values in the array)."), 678 NC_("SC_OPCODE_MIRR", "Reinvest rate"), 679 NC_("SC_OPCODE_MIRR", "Interest rate for reinvestments (the positive values in the array).") 680}; 681 682// -=*# Resource for function ISPMT #*=- 683const char* SC_OPCODE_ISPMT_ARY[] = 684{ 685 NC_("SC_OPCODE_ISPMT", "Returns the amount of interest for constant amortization rates."), 686 NC_("SC_OPCODE_ISPMT", "Rate"), 687 NC_("SC_OPCODE_ISPMT", "Interest rate for a single amortization rate."), 688 NC_("SC_OPCODE_ISPMT", "Period"), 689 NC_("SC_OPCODE_ISPMT", "Number of amortization periods for the calculation of the interest."), 690 NC_("SC_OPCODE_ISPMT", "Total periods"), 691 NC_("SC_OPCODE_ISPMT", "Sum total of amortization periods."), 692 NC_("SC_OPCODE_ISPMT", "Investment"), 693 NC_("SC_OPCODE_ISPMT", "Amount of the investment.") 694}; 695 696// -=*# Resource for function PDURATION #*=- 697const char* SC_OPCODE_PDURATION_ARY[] = 698{ 699 NC_("SC_OPCODE_PDURATION", "Duration. Calculates the number of periods required by an investment to attain the desired value."), 700 NC_("SC_OPCODE_PDURATION", "Rate"), 701 NC_("SC_OPCODE_PDURATION", "The constant rate of interest."), 702 NC_("SC_OPCODE_PDURATION", "PV"), 703 NC_("SC_OPCODE_PDURATION", "The present value. The current value of the investment."), 704 NC_("SC_OPCODE_PDURATION", "FV"), 705 NC_("SC_OPCODE_PDURATION", "The future value of the investment.") 706}; 707 708// -=*# Resource for function RRI #*=- 709const char* SC_OPCODE_RRI_ARY[] = 710{ 711 NC_("SC_OPCODE_RRI", "Interest. Calculates the interest rate which represents the rate of return from an investment."), 712 NC_("SC_OPCODE_RRI", "Periods"), 713 NC_("SC_OPCODE_RRI", "The number of periods used in the calculation."), 714 NC_("SC_OPCODE_RRI", "PV"), 715 NC_("SC_OPCODE_RRI", "Present value. The current value of the investment."), 716 NC_("SC_OPCODE_RRI", "FV"), 717 NC_("SC_OPCODE_RRI", "The future value of the investment.") 718}; 719 720// -=*# Resource for function ISREF #*=- 721const char* SC_OPCODE_IS_REF_ARY[] = 722{ 723 NC_("SC_OPCODE_IS_REF", "Returns TRUE if value is a reference."), 724 NC_("SC_OPCODE_IS_REF", "Value"), 725 NC_("SC_OPCODE_IS_REF", "The value to be tested.") 726}; 727 728// -=*# Resource for function ISERR #*=- 729const char* SC_OPCODE_IS_ERR_ARY[] = 730{ 731 NC_("SC_OPCODE_IS_ERR", "Returns TRUE if the value is an error value not equal to #N/A."), 732 NC_("SC_OPCODE_IS_ERR", "Value"), 733 NC_("SC_OPCODE_IS_ERR", "The value to be tested.") 734}; 735 736// -=*# Resource for function ISERROR #*=- 737const char* SC_OPCODE_IS_ERROR_ARY[] = 738{ 739 NC_("SC_OPCODE_IS_ERROR", "Returns TRUE if the value is an error value."), 740 NC_("SC_OPCODE_IS_ERROR", "Value"), 741 NC_("SC_OPCODE_IS_ERROR", "The value to be tested.") 742}; 743 744// -=*# Resource for function ISBLANK #*=- 745const char* SC_OPCODE_IS_EMPTY_ARY[] = 746{ 747 NC_("SC_OPCODE_IS_EMPTY", "Returns TRUE if value refers to an empty cell."), 748 NC_("SC_OPCODE_IS_EMPTY", "Value"), 749 NC_("SC_OPCODE_IS_EMPTY", "The value to be tested.") 750}; 751 752// -=*# Resource for function ISLOGICAL #*=- 753const char* SC_OPCODE_IS_LOGICAL_ARY[] = 754{ 755 NC_("SC_OPCODE_IS_LOGICAL", "Returns TRUE if the value carries a logical number format."), 756 NC_("SC_OPCODE_IS_LOGICAL", "Value"), 757 NC_("SC_OPCODE_IS_LOGICAL", "The value to be tested.") 758}; 759 760// -=*# Resource for function ISNA #*=- 761const char* SC_OPCODE_IS_NV_ARY[] = 762{ 763 NC_("SC_OPCODE_IS_NV", "Returns TRUE if value equals #N/A."), 764 NC_("SC_OPCODE_IS_NV", "Value"), 765 NC_("SC_OPCODE_IS_NV", "The value to be tested.") 766}; 767 768// -=*# Resource for function ISNONTEXT #*=- 769const char* SC_OPCODE_IS_NON_STRING_ARY[] = 770{ 771 NC_("SC_OPCODE_IS_NON_STRING", "Returns TRUE if the value is not text."), 772 NC_("SC_OPCODE_IS_NON_STRING", "Value"), 773 NC_("SC_OPCODE_IS_NON_STRING", "The value to be tested.") 774}; 775 776// -=*# Resource for function ISTEXT #*=- 777const char* SC_OPCODE_IS_STRING_ARY[] = 778{ 779 NC_("SC_OPCODE_IS_STRING", "Returns TRUE if value is text."), 780 NC_("SC_OPCODE_IS_STRING", "Value"), 781 NC_("SC_OPCODE_IS_STRING", "The value to be tested.") 782}; 783 784// -=*# Resource for function ISNUMBER #*=- 785const char* SC_OPCODE_IS_VALUE_ARY[] = 786{ 787 NC_("SC_OPCODE_IS_VALUE", "Returns TRUE if value is a number."), 788 NC_("SC_OPCODE_IS_VALUE", "Value"), 789 NC_("SC_OPCODE_IS_VALUE", "The value to be tested.") 790}; 791 792// -=*# Resource for function ISFORMULA #*=- 793const char* SC_OPCODE_IS_FORMULA_ARY[] = 794{ 795 NC_("SC_OPCODE_IS_FORMULA", "Returns TRUE if the cell is a formula cell."), 796 NC_("SC_OPCODE_IS_FORMULA", "Reference"), 797 NC_("SC_OPCODE_IS_FORMULA", "The cell to be tested.") 798}; 799 800// -=*# Resource for function FORMULA #*=- 801const char* SC_OPCODE_FORMULA_ARY[] = 802{ 803 NC_("SC_OPCODE_FORMULA", "Returns the formula of a formula cell."), 804 NC_("SC_OPCODE_FORMULA", "Reference"), 805 NC_("SC_OPCODE_FORMULA", "The formula cell.") 806}; 807 808// -=*# Resource for function N #*=- 809const char* SC_OPCODE_N_ARY[] = 810{ 811 NC_("SC_OPCODE_N", "Converts a value to a number."), 812 NC_("SC_OPCODE_N", "Value"), 813 NC_("SC_OPCODE_N", "The value to be interpreted as a number.") 814}; 815 816// -=*# Resource for function NA #*=- 817const char* SC_OPCODE_NO_VALUE_ARY[] = 818{ 819 NC_("SC_OPCODE_NO_VALUE", "Not available. Returns the error value #N/A.") 820}; 821 822// -=*# Resource for function TYPE #*=- 823const char* SC_OPCODE_TYPE_ARY[] = 824{ 825 NC_("SC_OPCODE_TYPE", "Returns the data type of a value (1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array)."), 826 NC_("SC_OPCODE_TYPE", "Value"), 827 NC_("SC_OPCODE_TYPE", "The value for which the data type is to be determined.") 828}; 829 830// -=*# Resource for function CELL #*=- 831const char* SC_OPCODE_CELL_ARY[] = 832{ 833 NC_("SC_OPCODE_CELL", "Determines information about address, formatting or contents of a cell."), 834 NC_("SC_OPCODE_CELL", "Info type"), 835 NC_("SC_OPCODE_CELL", "String that specifies the type of information."), 836 NC_("SC_OPCODE_CELL", "Reference"), 837 NC_("SC_OPCODE_CELL", "The position of the cell you want to examine.") 838}; 839 840// -=*# Resource for function CURRENT #*=- 841const char* SC_OPCODE_CURRENT_ARY[] = 842{ 843 NC_("SC_OPCODE_CURRENT", "Calculates the current value of the formula at the present location.") 844}; 845 846// -=*# Resource for function FALSE #*=- 847const char* SC_OPCODE_FALSE_ARY[] = 848{ 849 NC_("SC_OPCODE_FALSE", "Defines the logical value as FALSE.") 850}; 851 852// -=*# Resource for function NOT #*=- 853const char* SC_OPCODE_NOT_ARY[] = 854{ 855 NC_("SC_OPCODE_NOT", "Reverses the value of the argument."), 856 NC_("SC_OPCODE_NOT", "Logical value"), 857 NC_("SC_OPCODE_NOT", "An expression that can be either TRUE or FALSE.") 858}; 859 860// -=*# Resource for function TRUE #*=- 861const char* SC_OPCODE_TRUE_ARY[] = 862{ 863 NC_("SC_OPCODE_TRUE", "Returns the logical value TRUE.") 864}; 865 866// -=*# Resource for function IF #*=- 867const char* SC_OPCODE_IF_ARY[] = 868{ 869 NC_("SC_OPCODE_IF", "Specifies a logical test to be performed."), 870 NC_("SC_OPCODE_IF", "Test"), 871 NC_("SC_OPCODE_IF", "Any value or expression which can be either TRUE or FALSE."), 872 NC_("SC_OPCODE_IF", "Then value"), 873 NC_("SC_OPCODE_IF", "The result of the function if the logical test returns a TRUE."), 874 NC_("SC_OPCODE_IF", "Otherwise value"), 875 NC_("SC_OPCODE_IF", "The result of the function if the logical test returns FALSE.") 876}; 877 878// -=*# Resource for function IFERROR #*=- 879const char* SC_OPCODE_IF_ERROR_ARY[] = 880{ 881 NC_("SC_OPCODE_IF_ERROR", "Returns value if not an error value, else alternative."), 882 NC_("SC_OPCODE_IF_ERROR", "Value"), 883 NC_("SC_OPCODE_IF_ERROR", "The value to be calculated."), 884 NC_("SC_OPCODE_IF_ERROR", "Alternative value"), 885 NC_("SC_OPCODE_IF_ERROR", "The alternative to be returned, should value be an error value.") 886}; 887 888// -=*# Resource for function IFNA #*=- 889const char* SC_OPCODE_IF_NA_ARY[] = 890{ 891 NC_("SC_OPCODE_IF_NA", "Returns value if not a #N/A error, else alternative."), 892 NC_("SC_OPCODE_IF_NA", "Value"), 893 NC_("SC_OPCODE_IF_NA", "The value to be calculated."), 894 NC_("SC_OPCODE_IF_NA", "Alternative value"), 895 NC_("SC_OPCODE_IF_NA", "The alternative to be returned, should value be a #N/A error.") 896}; 897 898// -=*# Resource for function OR #*=- 899const char* SC_OPCODE_OR_ARY[] = 900{ 901 NC_("SC_OPCODE_OR", "Returns TRUE if an argument is TRUE."), 902 NC_("SC_OPCODE_OR", "Logical value "), 903 NC_("SC_OPCODE_OR", "Logical value 1, logical value 2,... are conditions to be tested and which return either TRUE or FALSE.") 904}; 905 906// -=*# Resource for function XOR #*=- 907const char* SC_OPCODE_XOR_ARY[] = 908{ 909 NC_("SC_OPCODE_XOR", "Returns TRUE if an odd number of arguments evaluates to TRUE."), 910 NC_("SC_OPCODE_XOR", "Logical value "), 911 NC_("SC_OPCODE_XOR", "Logical value 1, logical value 2, ... are conditions to be tested and which return either TRUE or FALSE.") 912}; 913 914// -=*# Resource for function AND #*=- 915const char* SC_OPCODE_AND_ARY[] = 916{ 917 NC_("SC_OPCODE_AND", "Returns TRUE if all arguments are TRUE."), 918 NC_("SC_OPCODE_AND", "Logical value "), 919 NC_("SC_OPCODE_AND", "Logical value 1, logical value 2;...are conditions to be tested and each returns either TRUE or FALSE.") 920}; 921 922// -=*# Resource for function ABS #*=- 923const char* SC_OPCODE_ABS_ARY[] = 924{ 925 NC_("SC_OPCODE_ABS", "Absolute value of a number."), 926 NC_("SC_OPCODE_ABS", "Number"), 927 NC_("SC_OPCODE_ABS", "The number whose absolute value is to be returned.") 928}; 929 930// -=*# Resource for function POWER #*=- 931const char* SC_OPCODE_POWER_ARY[] = 932{ 933 NC_("SC_OPCODE_POWER", "Returns a^b, base a raised to the power of exponent b."), 934 NC_("SC_OPCODE_POWER", "Base"), 935 NC_("SC_OPCODE_POWER", "The base a of the power a^b."), 936 NC_("SC_OPCODE_POWER", "Exponent"), 937 NC_("SC_OPCODE_POWER", "The exponent b of the power a^b.") 938}; 939 940// -=*# Resource for function COUNTBLANK #*=- 941const char* SC_OPCODE_COUNT_EMPTY_CELLS_ARY[] = 942{ 943 NC_("SC_OPCODE_COUNT_EMPTY_CELLS", "Counts the blank cells in a specified range."), 944 NC_("SC_OPCODE_COUNT_EMPTY_CELLS", "Range"), 945 NC_("SC_OPCODE_COUNT_EMPTY_CELLS", "The range in which empty cells are to be counted.") 946}; 947 948// -=*# Resource for function PI #*=- 949const char* SC_OPCODE_PI_ARY[] = 950{ 951 NC_("SC_OPCODE_PI", "Returns the value of the number Pi.") 952}; 953 954// -=*# Resource for function SUM #*=- 955const char* SC_OPCODE_SUM_ARY[] = 956{ 957 NC_("SC_OPCODE_SUM", "Returns the sum of all arguments."), 958 NC_("SC_OPCODE_SUM", "Number "), 959 NC_("SC_OPCODE_SUM", "Number 1, number 2, ... are arguments whose total is to be calculated.") 960}; 961 962// -=*# Resource for function SUMSQ #*=- 963const char* SC_OPCODE_SUM_SQ_ARY[] = 964{ 965 NC_("SC_OPCODE_SUM_SQ", "Returns the sum of the squares of the arguments."), 966 NC_("SC_OPCODE_SUM_SQ", "Number "), 967 NC_("SC_OPCODE_SUM_SQ", "Number 1, number 2,... are arguments for which the sum of the squares is to be calculated.") 968}; 969 970// -=*# Resource for function PRODUCT #*=- 971const char* SC_OPCODE_PRODUCT_ARY[] = 972{ 973 NC_("SC_OPCODE_PRODUCT", "Multiplies the arguments."), 974 NC_("SC_OPCODE_PRODUCT", "Number "), 975 NC_("SC_OPCODE_PRODUCT", "Number 1, number 2, ... are arguments to be multiplied and a result returned.") 976}; 977 978// -=*# Resource for function SUMIF #*=- 979const char* SC_OPCODE_SUM_IF_ARY[] = 980{ 981 NC_("SC_OPCODE_SUM_IF", "Totals the arguments that meet the condition."), 982 NC_("SC_OPCODE_SUM_IF", "Range"), 983 NC_("SC_OPCODE_SUM_IF", "The range to be evaluated by the criteria given."), 984 NC_("SC_OPCODE_SUM_IF", "Criteria"), 985 NC_("SC_OPCODE_SUM_IF", "The criteria to be applied to the range."), 986 NC_("SC_OPCODE_SUM_IF", "Sum range"), 987 NC_("SC_OPCODE_SUM_IF", "The range from which the values are to be totalled.") 988}; 989 990// -=*# Resource for function AVERAGEIF #*=- 991const char* SC_OPCODE_AVERAGE_IF_ARY[] = 992{ 993 NC_("SC_OPCODE_AVERAGE_IF", "Averages the arguments that meet the conditions."), 994 NC_("SC_OPCODE_AVERAGE_IF", "Range"), 995 NC_("SC_OPCODE_AVERAGE_IF", "The range to be evaluated by the criteria given."), 996 NC_("SC_OPCODE_AVERAGE_IF", "Criteria"), 997 NC_("SC_OPCODE_AVERAGE_IF", "The criteria to be applied to the range."), 998 NC_("SC_OPCODE_AVERAGE_IF", "Average range"), 999 NC_("SC_OPCODE_AVERAGE_IF", "The range from which the values are to be averaged.") 1000}; 1001 1002const char* SC_OPCODE_SUM_IFS_ARY[] = 1003{ 1004 NC_("SC_OPCODE_SUM_IFS", "Totals the values of cells in a range that meet multiple criteria in multiple ranges."), 1005 NC_("SC_OPCODE_SUM_IFS", "Sum range"), 1006 NC_("SC_OPCODE_SUM_IFS", "The range from which the values are to be totalled."), 1007 NC_("SC_OPCODE_SUM_IFS", "Range "), 1008 NC_("SC_OPCODE_SUM_IFS", "Range 1, range 2,... are the ranges to be evaluated by the criteria given."), 1009 NC_("SC_OPCODE_SUM_IFS", "Criteria "), 1010 NC_("SC_OPCODE_SUM_IFS", "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given.") 1011}; 1012 1013// -=*# Resource for function AVERAGEIFS #*=- 1014const char* SC_OPCODE_AVERAGE_IFS_ARY[] = 1015{ 1016 NC_("SC_OPCODE_AVERAGE_IFS", "Averages the value of the cells that meet multiple criteria in multiple ranges."), 1017 NC_("SC_OPCODE_AVERAGE_IFS", "Average range"), 1018 NC_("SC_OPCODE_AVERAGE_IFS", "The range from which the values are to be averaged."), 1019 NC_("SC_OPCODE_AVERAGE_IFS", "Range "), 1020 NC_("SC_OPCODE_AVERAGE_IFS", "Range 1, range 2,... are the ranges to be evaluated by the criteria given."), 1021 NC_("SC_OPCODE_AVERAGE_IFS", "Criteria "), 1022 NC_("SC_OPCODE_AVERAGE_IFS", "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given.") 1023}; 1024 1025// -=*# Resource for function COUNTIFS #*=- 1026const char* SC_OPCODE_COUNT_IFS_ARY[] = 1027{ 1028 NC_("SC_OPCODE_COUNT_IFS", "Counts the cells that meet multiple criteria in multiple ranges."), 1029 NC_("SC_OPCODE_COUNT_IFS", "Range "), 1030 NC_("SC_OPCODE_COUNT_IFS", "Range 1, range 2,... are the ranges to be evaluated by the criteria given."), 1031 NC_("SC_OPCODE_COUNT_IFS", "Criteria "), 1032 NC_("SC_OPCODE_COUNT_IFS", "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given.") 1033}; 1034 1035// -=*# Resource for function COUNTIF #*=- 1036const char* SC_OPCODE_COUNT_IF_ARY[] = 1037{ 1038 NC_("SC_OPCODE_COUNT_IF", "Counts the arguments which meet the set conditions."), 1039 NC_("SC_OPCODE_COUNT_IF", "Range"), 1040 NC_("SC_OPCODE_COUNT_IF", "The range of cells to be evaluated by the criteria given."), 1041 NC_("SC_OPCODE_COUNT_IF", "Criteria"), 1042 NC_("SC_OPCODE_COUNT_IF", "The criteria to be applied to the range.") 1043}; 1044 1045// -=*# Resource for function SQRT #*=- 1046const char* SC_OPCODE_SQRT_ARY[] = 1047{ 1048 NC_("SC_OPCODE_SQRT", "Returns the square root of a number."), 1049 NC_("SC_OPCODE_SQRT", "Number"), 1050 NC_("SC_OPCODE_SQRT", "A positive value for which the square root is to be calculated.") 1051}; 1052 1053// -=*# Resource for function RAND #*=- 1054const char* SC_OPCODE_RANDOM_ARY[] = 1055{ 1056 NC_("SC_OPCODE_RANDOM", "Returns a random number between 0 and 1.") 1057}; 1058 1059// -=*# Resource for function ISEVEN #*=- 1060const char* SC_OPCODE_IS_EVEN_ARY[] = 1061{ 1062 NC_("SC_OPCODE_IS_EVEN", "Returns TRUE if value is an even integer."), 1063 NC_("SC_OPCODE_IS_EVEN", "Value"), 1064 NC_("SC_OPCODE_IS_EVEN", "The value to be tested.") 1065}; 1066 1067// -=*# Resource for function ISODD #*=- 1068const char* SC_OPCODE_IS_ODD_ARY[] = 1069{ 1070 NC_("SC_OPCODE_IS_ODD", "Returns TRUE if value is an odd integer."), 1071 NC_("SC_OPCODE_IS_ODD", "Value"), 1072 NC_("SC_OPCODE_IS_ODD", "The value to be tested.") 1073}; 1074 1075// -=*# Resource for function COMBIN #*=- 1076const char* SC_OPCODE_COMBIN_ARY[] = 1077{ 1078 NC_("SC_OPCODE_COMBIN", "Calculates the number of combinations for elements without repetition."), 1079 NC_("SC_OPCODE_COMBIN", "Number 1"), 1080 NC_("SC_OPCODE_COMBIN", "The total number of elements."), 1081 NC_("SC_OPCODE_COMBIN", "Number 2"), 1082 NC_("SC_OPCODE_COMBIN", "The number of elements selected.") 1083}; 1084 1085// -=*# Resource for function COMBINA #*=- 1086const char* SC_OPCODE_COMBIN_A_ARY[] = 1087{ 1088 NC_("SC_OPCODE_COMBIN_A", "Calculates the number of combinations of elements including repetition."), 1089 NC_("SC_OPCODE_COMBIN_A", "Number 1"), 1090 NC_("SC_OPCODE_COMBIN_A", "The total number of elements."), 1091 NC_("SC_OPCODE_COMBIN_A", "Number 2"), 1092 NC_("SC_OPCODE_COMBIN_A", "The number of elements selected.") 1093}; 1094 1095// -=*# Resource for function ARCCOS #*=- 1096const char* SC_OPCODE_ARC_COS_ARY[] = 1097{ 1098 NC_("SC_OPCODE_ARC_COS", "Returns the arccosine of a number."), 1099 NC_("SC_OPCODE_ARC_COS", "Number"), 1100 NC_("SC_OPCODE_ARC_COS", "A value between -1 and 1 for which the arccosine is to be returned.") 1101}; 1102 1103// -=*# Resource for function ARCSIN #*=- 1104const char* SC_OPCODE_ARC_SIN_ARY[] = 1105{ 1106 NC_("SC_OPCODE_ARC_SIN", "Returns the arcsine of a number."), 1107 NC_("SC_OPCODE_ARC_SIN", "Number"), 1108 NC_("SC_OPCODE_ARC_SIN", "A value between -1 and 1 for which the arcsine is to be returned.") 1109}; 1110 1111// -=*# Resource for function ARCCOSHYP #*=- 1112const char* SC_OPCODE_ARC_COS_HYP_ARY[] = 1113{ 1114 NC_("SC_OPCODE_ARC_COS_HYP", "Returns the inverse hyperbolic cosine of a number."), 1115 NC_("SC_OPCODE_ARC_COS_HYP", "Number"), 1116 NC_("SC_OPCODE_ARC_COS_HYP", "A value greater than or equal to 1 for which the inverse hyperbolic cosine is to be returned.") 1117}; 1118 1119// -=*# Resource for function ARCSINHYP #*=- 1120const char* SC_OPCODE_ARC_SIN_HYP_ARY[] = 1121{ 1122 NC_("SC_OPCODE_ARC_SIN_HYP", "Returns the inverse hyperbolic sine of a number."), 1123 NC_("SC_OPCODE_ARC_SIN_HYP", "Number"), 1124 NC_("SC_OPCODE_ARC_SIN_HYP", "The value for which the inverse hyperbolic sine is to be returned.") 1125}; 1126 1127// -=*# Resource for function ARCCOT #*=- 1128const char* SC_OPCODE_ARC_COT_ARY[] = 1129{ 1130 NC_("SC_OPCODE_ARC_COT", "Returns the inverse cotangent of a number."), 1131 NC_("SC_OPCODE_ARC_COT", "Number"), 1132 NC_("SC_OPCODE_ARC_COT", "The value for which the inverse cotangent is to be returned.") 1133}; 1134 1135// -=*# Resource for function ARCTAN #*=- 1136const char* SC_OPCODE_ARC_TAN_ARY[] = 1137{ 1138 NC_("SC_OPCODE_ARC_TAN", "Returns the arctangent of a number."), 1139 NC_("SC_OPCODE_ARC_TAN", "Number"), 1140 NC_("SC_OPCODE_ARC_TAN", "The value for which the arctangent is to be returned.") 1141}; 1142 1143// -=*# Resource for function ARCCOTHYP #*=- 1144const char* SC_OPCODE_ARC_COT_HYP_ARY[] = 1145{ 1146 NC_("SC_OPCODE_ARC_COT_HYP", "Returns the inverse hyperbolic cotangent of a number."), 1147 NC_("SC_OPCODE_ARC_COT_HYP", "Number"), 1148 NC_("SC_OPCODE_ARC_COT_HYP", "A value smaller than -1 or greater than 1 for which the inverse hyperbolic cotangent is to be returned.") 1149}; 1150 1151// -=*# Resource for function ARCTANHYP #*=- 1152const char* SC_OPCODE_ARC_TAN_HYP_ARY[] = 1153{ 1154 NC_("SC_OPCODE_ARC_TAN_HYP", "Returns the inverse hyperbolic tangent of a number."), 1155 NC_("SC_OPCODE_ARC_TAN_HYP", "Number"), 1156 NC_("SC_OPCODE_ARC_TAN_HYP", "A value between -1 and 1 for which the inverse hyperbolic tangent is to be returned.") 1157}; 1158 1159// -=*# Resource for function COS #*=- 1160const char* SC_OPCODE_COS_ARY[] = 1161{ 1162 NC_("SC_OPCODE_COS", "Returns the cosine of a number."), 1163 NC_("SC_OPCODE_COS", "Number"), 1164 NC_("SC_OPCODE_COS", "The angle in the radians for which the cosine is to be returned.") 1165}; 1166 1167// -=*# Resource for function SIN #*=- 1168const char* SC_OPCODE_SIN_ARY[] = 1169{ 1170 NC_("SC_OPCODE_SIN", "Returns the sine of a number."), 1171 NC_("SC_OPCODE_SIN", "Number"), 1172 NC_("SC_OPCODE_SIN", "The angle in radians for which the sine is to be calculated.") 1173}; 1174 1175// -=*# Resource for function COT #*=- 1176const char* SC_OPCODE_COT_ARY[] = 1177{ 1178 NC_("SC_OPCODE_COT", "Returns the cotangent of a number."), 1179 NC_("SC_OPCODE_COT", "Number"), 1180 NC_("SC_OPCODE_COT", "The angle in radians whose cotangent value is to be returned.") 1181}; 1182 1183// -=*# Resource for function TAN #*=- 1184const char* SC_OPCODE_TAN_ARY[] = 1185{ 1186 NC_("SC_OPCODE_TAN", "Returns the tangent of a number."), 1187 NC_("SC_OPCODE_TAN", "Number"), 1188 NC_("SC_OPCODE_TAN", "The angle in radians for which the tangent is to be calculated.") 1189}; 1190 1191// -=*# Resource for function COSHYP #*=- 1192const char* SC_OPCODE_COS_HYP_ARY[] = 1193{ 1194 NC_("SC_OPCODE_COS_HYP", "Returns the hyperbolic cosine of a number."), 1195 NC_("SC_OPCODE_COS_HYP", "Number"), 1196 NC_("SC_OPCODE_COS_HYP", "The value for which the hyperbolic cosine is to be returned.") 1197}; 1198 1199// -=*# Resource for function SINHYP #*=- 1200const char* SC_OPCODE_SIN_HYP_ARY[] = 1201{ 1202 NC_("SC_OPCODE_SIN_HYP", "Returns the hyperbolic sine of a number."), 1203 NC_("SC_OPCODE_SIN_HYP", "Number"), 1204 NC_("SC_OPCODE_SIN_HYP", "The value for which the hyperbolic sine is to be calculated.") 1205}; 1206 1207// -=*# Resource for function COTHYP #*=- 1208const char* SC_OPCODE_COT_HYP_ARY[] = 1209{ 1210 NC_("SC_OPCODE_COT_HYP", "Returns the hyperbolic cotangent of a number."), 1211 NC_("SC_OPCODE_COT_HYP", "Number"), 1212 NC_("SC_OPCODE_COT_HYP", "A value not equal to 0 for which the hyperbolic cotangent is to be returned.") 1213}; 1214 1215// -=*# Resource for function TANHYP #*=- 1216const char* SC_OPCODE_TAN_HYP_ARY[] = 1217{ 1218 NC_("SC_OPCODE_TAN_HYP", "Returns the hyperbolic tangent of a number."), 1219 NC_("SC_OPCODE_TAN_HYP", "Number"), 1220 NC_("SC_OPCODE_TAN_HYP", "The value for which the hyperbolic tangent is to be calculated.") 1221}; 1222 1223// -=*# Resource for function ARCTAN2 #*=- 1224const char* SC_OPCODE_ARC_TAN_2_ARY[] = 1225{ 1226 NC_("SC_OPCODE_ARC_TAN_2", "Returns the arctangent for the specified coordinates."), 1227 NC_("SC_OPCODE_ARC_TAN_2", "Number X"), 1228 NC_("SC_OPCODE_ARC_TAN_2", "The value for the X coordinate."), 1229 NC_("SC_OPCODE_ARC_TAN_2", "Number Y"), 1230 NC_("SC_OPCODE_ARC_TAN_2", "The value for the Y coordinate.") 1231}; 1232 1233// -=*# Resource for function CSC #*=- 1234const char* SC_OPCODE_COSECANT_ARY[] = 1235{ 1236 NC_("SC_OPCODE_COSECANT", "Return the cosecant of an angle. CSC(x)=1/SIN(x)"), 1237 NC_("SC_OPCODE_COSECANT", "Angle"), 1238 NC_("SC_OPCODE_COSECANT", "The angle in radians for which the cosecant is to be calculated.") 1239}; 1240 1241// -=*# Resource for function SEC #*=- 1242const char* SC_OPCODE_SECANT_ARY[] = 1243{ 1244 NC_("SC_OPCODE_SECANT", "Return the secant of an angle. SEC(x)=1/COS(x)"), 1245 NC_("SC_OPCODE_SECANT", "Angle"), 1246 NC_("SC_OPCODE_SECANT", "The angle in radians for which the secant is to be calculated.") 1247}; 1248 1249// -=*# Resource for function CSCH #*=- 1250const char* SC_OPCODE_COSECANT_HYP_ARY[] = 1251{ 1252 NC_("SC_OPCODE_COSECANT_HYP", "Return the hyperbolic cosecant of a hyperbolic angle. CSCH(x)=1/SINH(x)"), 1253 NC_("SC_OPCODE_COSECANT_HYP", "Angle"), 1254 NC_("SC_OPCODE_COSECANT_HYP", "The hyperbolic angle in radians for which the hyperbolic cosecant is to be calculated.") 1255}; 1256 1257// -=*# Resource for function SECH #*=- 1258const char* SC_OPCODE_SECANT_HYP_ARY[] = 1259{ 1260 NC_("SC_OPCODE_SECANT_HYP", "Return the hyperbolic secant of a hyperbolic angle. SECH(x)=1/COSH(x)"), 1261 NC_("SC_OPCODE_SECANT_HYP", "Angle"), 1262 NC_("SC_OPCODE_SECANT_HYP", "The hyperbolic angle in radians for which the hyperbolic secant is to be calculated.") 1263}; 1264 1265// -=*# Resource for function DEG #*=- 1266const char* SC_OPCODE_DEG_ARY[] = 1267{ 1268 NC_("SC_OPCODE_DEG", "Converts a radian to degrees"), 1269 NC_("SC_OPCODE_DEG", "Number"), 1270 NC_("SC_OPCODE_DEG", "The angle in a radian") 1271}; 1272 1273// -=*# Resource for function RAD #*=- 1274const char* SC_OPCODE_RAD_ARY[] = 1275{ 1276 NC_("SC_OPCODE_RAD", "Converts degrees to radians"), 1277 NC_("SC_OPCODE_RAD", "Number"), 1278 NC_("SC_OPCODE_RAD", "The angle in degrees.") 1279}; 1280 1281// -=*# Resource for function EXP #*=- 1282const char* SC_OPCODE_EXP_ARY[] = 1283{ 1284 NC_("SC_OPCODE_EXP", "Calculates the exponent for basis e."), 1285 NC_("SC_OPCODE_EXP", "Number"), 1286 NC_("SC_OPCODE_EXP", "The exponent applied to base e.") 1287}; 1288 1289// -=*# Resource for function LOG #*=- 1290const char* SC_OPCODE_LOG_ARY[] = 1291{ 1292 NC_("SC_OPCODE_LOG", "Calculates the logarithm to any specified base."), 1293 NC_("SC_OPCODE_LOG", "Number"), 1294 NC_("SC_OPCODE_LOG", "A value greater than 0 for which the logarithm is to be calculated."), 1295 NC_("SC_OPCODE_LOG", "Base"), 1296 NC_("SC_OPCODE_LOG", "The base of the logarithm. If omitted, the base is regarded as 10.") 1297}; 1298 1299// -=*# Resource for function LN #*=- 1300const char* SC_OPCODE_LN_ARY[] = 1301{ 1302 NC_("SC_OPCODE_LN", "Calculates the natural logarithm of a number."), 1303 NC_("SC_OPCODE_LN", "Number"), 1304 NC_("SC_OPCODE_LN", "A value greater than 0 for which the natural logarithm is to be calculated.") 1305}; 1306 1307// -=*# Resource for function LOG10 #*=- 1308const char* SC_OPCODE_LOG10_ARY[] = 1309{ 1310 NC_("SC_OPCODE_LOG10", "Calculates the base-10 logarithm of a number."), 1311 NC_("SC_OPCODE_LOG10", "Number"), 1312 NC_("SC_OPCODE_LOG10", "A value greater than 0 for which the logarithm is to be calculated.") 1313}; 1314 1315// -=*# Resource for function FACT #*=- 1316const char* SC_OPCODE_FACT_ARY[] = 1317{ 1318 NC_("SC_OPCODE_FACT", "Calculates the factorial of a number."), 1319 NC_("SC_OPCODE_FACT", "Number"), 1320 NC_("SC_OPCODE_FACT", "The number for which the factorial is to be calculated.") 1321}; 1322 1323// -=*# Resource for function MOD #*=- 1324const char* SC_OPCODE_MOD_ARY[] = 1325{ 1326 NC_("SC_OPCODE_MOD", "Calculates the remainder of a division."), 1327 NC_("SC_OPCODE_MOD", "Dividend"), 1328 NC_("SC_OPCODE_MOD", "The number to be divided."), 1329 NC_("SC_OPCODE_MOD", "Divisor"), 1330 NC_("SC_OPCODE_MOD", "The number by which the dividend is divided.") 1331}; 1332 1333// -=*# Resource for function SIGN #*=- 1334const char* SC_OPCODE_PLUS_MINUS_ARY[] = 1335{ 1336 NC_("SC_OPCODE_PLUS_MINUS", "Returns the algebraic sign of a number."), 1337 NC_("SC_OPCODE_PLUS_MINUS", "Number"), 1338 NC_("SC_OPCODE_PLUS_MINUS", "The number for which the algebraic sign is to be determined.") 1339}; 1340 1341// -=*# Resource for function SUBTOTAL #*=- 1342const char* SC_OPCODE_SUB_TOTAL_ARY[] = 1343{ 1344 NC_("SC_OPCODE_SUB_TOTAL", "Calculates subtotals in a spreadsheet."), 1345 NC_("SC_OPCODE_SUB_TOTAL", "Function"), 1346 NC_("SC_OPCODE_SUB_TOTAL", "Function index. Is an index of the possible functions Total, Max, ..."), 1347 NC_("SC_OPCODE_SUB_TOTAL", "Range"), 1348 NC_("SC_OPCODE_SUB_TOTAL", "The cells of the range which are to be taken into account.") 1349}; 1350 1351// -=*# Resource for function AGGREGATE #*=- 1352const char* SC_OPCODE_AGGREGATE_ARY[] = 1353{ 1354 NC_("SC_OPCODE_AGGREGATE", "Calculates an aggregate in a spreadsheet."), 1355 NC_("SC_OPCODE_AGGREGATE", "Function"), 1356 NC_("SC_OPCODE_AGGREGATE", "Function index. Is an index of the possible functions Total, Max, ..."), 1357 NC_("SC_OPCODE_AGGREGATE", "Options"), 1358 NC_("SC_OPCODE_AGGREGATE", "Option index. Is an index of the possible ignore options."), 1359 NC_("SC_OPCODE_AGGREGATE", "Reference 1 or array"), 1360 NC_("SC_OPCODE_AGGREGATE", "The cell(s) of the range which are to be taken into account."), 1361 NC_("SC_OPCODE_AGGREGATE", "Reference 2..n or k "), 1362 NC_("SC_OPCODE_AGGREGATE", "The cells of the range which are to be taken into account or mandatory 2nd argument for certain functions.") 1363}; 1364 1365// -=*# Resource for function INT #*=- 1366const char* SC_OPCODE_INT_ARY[] = 1367{ 1368 NC_("SC_OPCODE_INT", "Rounds a number down to the nearest integer."), 1369 NC_("SC_OPCODE_INT", "Number"), 1370 NC_("SC_OPCODE_INT", "The number to be rounded down.") 1371}; 1372 1373// -=*# Resource for function TRUNC #*=- 1374const char* SC_OPCODE_TRUNC_ARY[] = 1375{ 1376 NC_("SC_OPCODE_TRUNC", "Truncates the decimal places of a number."), 1377 NC_("SC_OPCODE_TRUNC", "Number"), 1378 NC_("SC_OPCODE_TRUNC", "The number to be truncated."), 1379 NC_("SC_OPCODE_TRUNC", "Count"), 1380 NC_("SC_OPCODE_TRUNC", "The number of places after the decimal point that are not to be truncated.") 1381}; 1382 1383// -=*# Resource for function ROUND #*=- 1384const char* SC_OPCODE_ROUND_ARY[] = 1385{ 1386 NC_("SC_OPCODE_ROUND", "Rounds a number to a predefined accuracy."), 1387 NC_("SC_OPCODE_ROUND", "Number"), 1388 NC_("SC_OPCODE_ROUND", "The number to be rounded."), 1389 NC_("SC_OPCODE_ROUND", "Count"), 1390 NC_("SC_OPCODE_ROUND", "The number of places to which a number is to be rounded.") 1391}; 1392 1393// -=*# Resource for function ROUNDUP #*=- 1394const char* SC_OPCODE_ROUND_UP_ARY[] = 1395{ 1396 NC_("SC_OPCODE_ROUND_UP", "Rounds a number up to the predefined accuracy."), 1397 NC_("SC_OPCODE_ROUND_UP", "Number"), 1398 NC_("SC_OPCODE_ROUND_UP", "The number to be rounded up."), 1399 NC_("SC_OPCODE_ROUND_UP", "Count"), 1400 NC_("SC_OPCODE_ROUND_UP", "The number of places to which a number is to be rounded.") 1401}; 1402 1403// -=*# Resource for function ROUNDDOWN #*=- 1404const char* SC_OPCODE_ROUND_DOWN_ARY[] = 1405{ 1406 NC_("SC_OPCODE_ROUND_DOWN", "Rounds a number down to a predefined accuracy."), 1407 NC_("SC_OPCODE_ROUND_DOWN", "Number"), 1408 NC_("SC_OPCODE_ROUND_DOWN", "The number to be rounded down."), 1409 NC_("SC_OPCODE_ROUND_DOWN", "Count"), 1410 NC_("SC_OPCODE_ROUND_DOWN", "The number of places down to which a number is to be rounded.") 1411}; 1412 1413// -=*# Resource for function EVEN #*=- 1414const char* SC_OPCODE_EVEN_ARY[] = 1415{ 1416 NC_("SC_OPCODE_EVEN", "Rounds a positive number up and negative number down to the nearest even integer."), 1417 NC_("SC_OPCODE_EVEN", "Number"), 1418 NC_("SC_OPCODE_EVEN", "The number to be rounded up.") 1419}; 1420 1421// -=*# Resource for function ODD #*=- 1422const char* SC_OPCODE_ODD_ARY[] = 1423{ 1424 NC_("SC_OPCODE_ODD", "Rounds a positive number up and negative number down to the nearest odd integer."), 1425 NC_("SC_OPCODE_ODD", "Number"), 1426 NC_("SC_OPCODE_ODD", "The number to be rounded up.") 1427}; 1428 1429// -=*# Resource for function CEILING.XCL #*=- 1430const char* SC_OPCODE_CEIL_MS_ARY[] = 1431{ 1432 NC_("SC_OPCODE_CEIL_MS", "Rounds a number away from zero to the nearest multiple of significance.\nThis function exists for interoperability with Microsoft Excel 2007 or older versions."), 1433 NC_("SC_OPCODE_CEIL_MS", "Number"), 1434 NC_("SC_OPCODE_CEIL_MS", "The number to be rounded up."), 1435 NC_("SC_OPCODE_CEIL_MS", "Significance"), 1436 NC_("SC_OPCODE_CEIL_MS", "The number to whose multiple the value is rounded.") 1437}; 1438 1439// -=*# Resource for function CEILING.PRECISE #*=- 1440const char* SC_OPCODE_CEIL_PRECISE_ARY[] = 1441{ 1442 NC_("SC_OPCODE_CEIL_PRECISE", "Rounds a number up to the nearest multiple of significance, regardless of sign of significance."), 1443 NC_("SC_OPCODE_CEIL_PRECISE", "Number"), 1444 NC_("SC_OPCODE_CEIL_PRECISE", "The number to be rounded up."), 1445 NC_("SC_OPCODE_CEIL_PRECISE", "Significance"), 1446 NC_("SC_OPCODE_CEIL_PRECISE", "The number to whose multiple the value is rounded.") 1447}; 1448 1449// -=*# Resource for function ISO.CEILING #*=- 1450const char* SC_OPCODE_CEIL_ISO_ARY[] = 1451{ 1452 NC_("SC_OPCODE_CEIL_ISO", "Rounds a number up to the nearest multiple of significance, regardless of sign of significance."), 1453 NC_("SC_OPCODE_CEIL_ISO", "Number"), 1454 NC_("SC_OPCODE_CEIL_ISO", "The number to be rounded up."), 1455 NC_("SC_OPCODE_CEIL_ISO", "Significance"), 1456 NC_("SC_OPCODE_CEIL_ISO", "The number to whose multiple the value is rounded.") 1457}; 1458 1459// -=*# Resource for function CEILING #*=- 1460const char* SC_OPCODE_CEIL_ARY[] = 1461{ 1462 NC_("SC_OPCODE_CEIL", "Rounds a number up to the nearest multiple of significance."), 1463 NC_("SC_OPCODE_CEIL", "Number"), 1464 NC_("SC_OPCODE_CEIL", "The number to be rounded up."), 1465 NC_("SC_OPCODE_CEIL", "Significance"), 1466 NC_("SC_OPCODE_CEIL", "If given the number to whose multiple the value is rounded, else -1 or 1 depending on sign of Number."), 1467 NC_("SC_OPCODE_CEIL", "Mode"), 1468 NC_("SC_OPCODE_CEIL", "If given and not equal to zero then rounded up according to amount when a negative number and significance.") 1469}; 1470 1471// -=*# Resource for function CEILING.MATH #*=- 1472const char* SC_OPCODE_CEIL_MATH_ARY[] = 1473{ 1474 NC_("SC_OPCODE_CEIL_MATH", "Rounds a number up to the nearest multiple of significance."), 1475 NC_("SC_OPCODE_CEIL_MATH", "Number"), 1476 NC_("SC_OPCODE_CEIL_MATH", "The number to be rounded up."), 1477 NC_("SC_OPCODE_CEIL_MATH", "Significance"), 1478 NC_("SC_OPCODE_CEIL_MATH", "If given the number to whose multiple the value is rounded, else 1."), 1479 NC_("SC_OPCODE_CEIL_MATH", "Mode"), 1480 NC_("SC_OPCODE_CEIL_MATH", "For negative numbers; if given and not equal to zero then rounds away from zero, else rounds towards zero.") 1481}; 1482 1483// -=*# Resource for function FLOOR #*=- 1484const char* SC_OPCODE_FLOOR_ARY[] = 1485{ 1486 NC_("SC_OPCODE_FLOOR", "Rounds number down to the nearest multiple of significance."), 1487 NC_("SC_OPCODE_FLOOR", "Number"), 1488 NC_("SC_OPCODE_FLOOR", "The number to be rounded down."), 1489 NC_("SC_OPCODE_FLOOR", "Significance"), 1490 NC_("SC_OPCODE_FLOOR", "The number to whose multiple the value is to be rounded down."), 1491 NC_("SC_OPCODE_FLOOR", "Mode"), 1492 NC_("SC_OPCODE_FLOOR", "If given and not equal to zero then rounded towards zero with negative number and significance.") 1493}; 1494 1495// -=*# Resource for function FLOOR.XCL #*=- 1496const char* SC_OPCODE_FLOOR_MS_ARY[] = 1497{ 1498 NC_("SC_OPCODE_FLOOR_MS", "Rounds number towards zero to the nearest multiple of absolute value of significance.\nThis function exists for interoperability with Microsoft Excel 2007 or older versions."), 1499 NC_("SC_OPCODE_FLOOR_MS", "Number"), 1500 NC_("SC_OPCODE_FLOOR_MS", "The number to be rounded down."), 1501 NC_("SC_OPCODE_FLOOR_MS", "Significance"), 1502 NC_("SC_OPCODE_FLOOR_MS", "The number to whose multiple the value is to be rounded down.") 1503}; 1504 1505// -=*# Resource for function FLOOR.MATH #*=- 1506const char* SC_OPCODE_FLOOR_MATH_ARY[] = 1507{ 1508 NC_("SC_OPCODE_FLOOR_MATH", "Rounds number down to the nearest multiple of significance, regardless of sign of significance."), 1509 NC_("SC_OPCODE_FLOOR_MATH", "Number"), 1510 NC_("SC_OPCODE_FLOOR_MATH", "The number to be rounded down."), 1511 NC_("SC_OPCODE_FLOOR_MATH", "Significance"), 1512 NC_("SC_OPCODE_FLOOR_MATH", "The number to whose multiple the value is to be rounded down."), 1513 NC_("SC_OPCODE_FLOOR_MATH", "Mode"), 1514 NC_("SC_OPCODE_FLOOR_MATH", "For negative numbers; if given and not equal to or less than zero rounds towards zero.") 1515}; 1516 1517// -=*# Resource for function FLOOR.PRECISE #*=- 1518const char* SC_OPCODE_FLOOR_PRECISE_ARY[] = 1519{ 1520 NC_("SC_OPCODE_FLOOR_PRECISE", "Rounds number down (towards -∞) to the nearest multiple of significance."), 1521 NC_("SC_OPCODE_FLOOR_PRECISE", "Number"), 1522 NC_("SC_OPCODE_FLOOR_PRECISE", "The number to be rounded down."), 1523 NC_("SC_OPCODE_FLOOR_PRECISE", "Significance"), 1524 NC_("SC_OPCODE_FLOOR_PRECISE", "The number to whose multiple the value is to be rounded down. Sign has no meaning.") 1525}; 1526 1527// -=*# Resource for function GCD #*=- 1528const char* SC_OPCODE_GCD_ARY[] = 1529{ 1530 NC_("SC_OPCODE_GCD", "Greatest Common Divisor"), 1531 NC_("SC_OPCODE_GCD", "Integer "), 1532 NC_("SC_OPCODE_GCD", "Integer 1; integer 2,... are integers for which the greatest common divisor is to be calculated.") 1533}; 1534 1535// -=*# Resource for function LCM #*=- 1536const char* SC_OPCODE_LCM_ARY[] = 1537{ 1538 NC_("SC_OPCODE_LCM", "Lowest common multiple"), 1539 NC_("SC_OPCODE_LCM", "Integer "), 1540 NC_("SC_OPCODE_LCM", "Integer 1; integer 2,... are integers whose smallest common multiple is to be calculated.") 1541}; 1542 1543// -=*# Resource for function TRANSPOSE #*=- 1544const char* SC_OPCODE_MAT_TRANS_ARY[] = 1545{ 1546 NC_("SC_OPCODE_MAT_TRANS", "Array transposition. Exchanges the rows and columns of an array."), 1547 NC_("SC_OPCODE_MAT_TRANS", "Array"), 1548 NC_("SC_OPCODE_MAT_TRANS", "The array in which the rows and columns have been transposed.") 1549}; 1550 1551// -=*# Resource for function MMULT #*=- 1552const char* SC_OPCODE_MAT_MULT_ARY[] = 1553{ 1554 NC_("SC_OPCODE_MAT_MULT", "Array multiplication. Returns the product of two arrays."), 1555 NC_("SC_OPCODE_MAT_MULT", "Array 1"), 1556 NC_("SC_OPCODE_MAT_MULT", "The first array for the array product."), 1557 NC_("SC_OPCODE_MAT_MULT", "Array 2"), 1558 NC_("SC_OPCODE_MAT_MULT", "The second array having the same number of rows as the first array has columns.") 1559}; 1560 1561// -=*# Resource for function MDETERM #*=- 1562const char* SC_OPCODE_MAT_DET_ARY[] = 1563{ 1564 NC_("SC_OPCODE_MAT_DET", "Returns the array determinant."), 1565 NC_("SC_OPCODE_MAT_DET", "Array"), 1566 NC_("SC_OPCODE_MAT_DET", "The array for which the determinant is to be determined.") 1567}; 1568 1569// -=*# Resource for function MINVERSE #*=- 1570const char* SC_OPCODE_MAT_INV_ARY[] = 1571{ 1572 NC_("SC_OPCODE_MAT_INV", "Returns the inverse of an array."), 1573 NC_("SC_OPCODE_MAT_INV", "Array"), 1574 NC_("SC_OPCODE_MAT_INV", "The array to be inverted.") 1575}; 1576 1577// -=*# Resource for function MUNIT #*=- 1578const char* SC_OPCODE_MATRIX_UNIT_ARY[] = 1579{ 1580 NC_("SC_OPCODE_MATRIX_UNIT", "Returns the unitary square array of a certain size."), 1581 NC_("SC_OPCODE_MATRIX_UNIT", "Dimensions"), 1582 NC_("SC_OPCODE_MATRIX_UNIT", "The size of the unitary array.") 1583}; 1584 1585// -=*# Resource for function SUMPRODUCT #*=- 1586const char* SC_OPCODE_SUM_PRODUCT_ARY[] = 1587{ 1588 NC_("SC_OPCODE_SUM_PRODUCT", "(Inner products) Returns the sum of the products of array arguments."), 1589 NC_("SC_OPCODE_SUM_PRODUCT", "Array "), 1590 NC_("SC_OPCODE_SUM_PRODUCT", "Array 1, array 2, ... are arrays whose arguments are to be multiplied.") 1591}; 1592 1593// -=*# Resource for function SUMX2MY2 #*=- 1594const char* SC_OPCODE_SUM_X2MY2_ARY[] = 1595{ 1596 NC_("SC_OPCODE_SUM_X2MY2", "Returns the sum of the difference of squares of two arrays."), 1597 NC_("SC_OPCODE_SUM_X2MY2", "Array X"), 1598 NC_("SC_OPCODE_SUM_X2MY2", "First array where the square of the arguments are totalled."), 1599 NC_("SC_OPCODE_SUM_X2MY2", "Array Y"), 1600 NC_("SC_OPCODE_SUM_X2MY2", "Second array where the square of the arguments is to be subtracted.") 1601}; 1602 1603// -=*# Resource for function SUMX2PY2 #*=- 1604const char* SC_OPCODE_SUM_X2DY2_ARY[] = 1605{ 1606 NC_("SC_OPCODE_SUM_X2DY2", "Returns the total of the square sum of two arrays."), 1607 NC_("SC_OPCODE_SUM_X2DY2", "Array X"), 1608 NC_("SC_OPCODE_SUM_X2DY2", "First array where the square of the arguments are totalled."), 1609 NC_("SC_OPCODE_SUM_X2DY2", "Array Y"), 1610 NC_("SC_OPCODE_SUM_X2DY2", "Second array where the square of the arguments is to be totalled.") 1611}; 1612 1613// -=*# Resource for function SUMXMY2 #*=- 1614const char* SC_OPCODE_SUM_XMY2_ARY[] = 1615{ 1616 NC_("SC_OPCODE_SUM_XMY2", "Returns the sum of squares of differences of two arrays."), 1617 NC_("SC_OPCODE_SUM_XMY2", "Array X"), 1618 NC_("SC_OPCODE_SUM_XMY2", "First array for forming argument differences."), 1619 NC_("SC_OPCODE_SUM_XMY2", "Array Y"), 1620 NC_("SC_OPCODE_SUM_XMY2", "Second array for forming the argument differences.") 1621}; 1622 1623// -=*# Resource for function FREQUENCY #*=- 1624const char* SC_OPCODE_FREQUENCY_ARY[] = 1625{ 1626 NC_("SC_OPCODE_FREQUENCY", "Returns a frequency distribution as a vertical array."), 1627 NC_("SC_OPCODE_FREQUENCY", "Data"), 1628 NC_("SC_OPCODE_FREQUENCY", "The array of the data."), 1629 NC_("SC_OPCODE_FREQUENCY", "Classes"), 1630 NC_("SC_OPCODE_FREQUENCY", "The array for forming classes.") 1631}; 1632 1633// -=*# Resource for function LINEST #*=- 1634const char* SC_OPCODE_LINEST_ARY[] = 1635{ 1636 NC_("SC_OPCODE_LINEST", "Calculates parameters of the linear regression as an array."), 1637 NC_("SC_OPCODE_LINEST", "Data Y"), 1638 NC_("SC_OPCODE_LINEST", "The Y data array."), 1639 NC_("SC_OPCODE_LINEST", "Data X"), 1640 NC_("SC_OPCODE_LINEST", "The X data array."), 1641 NC_("SC_OPCODE_LINEST", "Linear type"), 1642 NC_("SC_OPCODE_LINEST", "If type = 0 the linears will be calculated through the zero point, or else moved linears."), 1643 NC_("SC_OPCODE_LINEST", "Stats"), 1644 NC_("SC_OPCODE_LINEST", "If parameter = 0 then only the regression coefficient will be calculated, otherwise other values as well.") 1645}; 1646 1647// -=*# Resource for function LOGEST #*=- 1648const char* SC_OPCODE_LOGEST_ARY[] = 1649{ 1650 NC_("SC_OPCODE_LOGEST", "Calculates the parameters of the exponential regression curve as an array."), 1651 NC_("SC_OPCODE_LOGEST", "Data Y"), 1652 NC_("SC_OPCODE_LOGEST", "The Y data array."), 1653 NC_("SC_OPCODE_LOGEST", "Data X"), 1654 NC_("SC_OPCODE_LOGEST", "The X data array."), 1655 NC_("SC_OPCODE_LOGEST", "Function type"), 1656 NC_("SC_OPCODE_LOGEST", "If type = 0 then the functions will be calculated in the form of y=m^x, or also functions y=b*m^x."), 1657 NC_("SC_OPCODE_LOGEST", "Stats"), 1658 NC_("SC_OPCODE_LOGEST", "If parameter = 0 then only the regression coefficient will be calculated, otherwise other values as well.") 1659}; 1660 1661// -=*# Resource for function TREND #*=- 1662const char* SC_OPCODE_TREND_ARY[] = 1663{ 1664 NC_("SC_OPCODE_TREND", "Calculates points along a regression line."), 1665 NC_("SC_OPCODE_TREND", "Data Y"), 1666 NC_("SC_OPCODE_TREND", "The Y data array."), 1667 NC_("SC_OPCODE_TREND", "Data X"), 1668 NC_("SC_OPCODE_TREND", "The X data array as the basis for the regression."), 1669 NC_("SC_OPCODE_TREND", "New data X"), 1670 NC_("SC_OPCODE_TREND", "The array of X data for recalculating the values."), 1671 NC_("SC_OPCODE_TREND", "Linear type"), 1672 NC_("SC_OPCODE_TREND", "If type = 0 the linears will be calculated through the zero point, or else moved linears.") 1673}; 1674 1675// -=*# Resource for function GROWTH #*=- 1676const char* SC_OPCODE_GROWTH_ARY[] = 1677{ 1678 NC_("SC_OPCODE_GROWTH", "Calculates points on the exponential regression function."), 1679 NC_("SC_OPCODE_GROWTH", "Data Y"), 1680 NC_("SC_OPCODE_GROWTH", "The Y data array."), 1681 NC_("SC_OPCODE_GROWTH", "Data X"), 1682 NC_("SC_OPCODE_GROWTH", "The X data array as the basis for the regression."), 1683 NC_("SC_OPCODE_GROWTH", "New data X"), 1684 NC_("SC_OPCODE_GROWTH", "The array of X data for recalculating the values."), 1685 NC_("SC_OPCODE_GROWTH", "Function type"), 1686 NC_("SC_OPCODE_GROWTH", "If type = 0 then the functions will be calculated in the form of y=m^x, or also functions y=b*m^x.") 1687}; 1688 1689// -=*# Resource for function COUNT #*=- 1690const char* SC_OPCODE_COUNT_ARY[] = 1691{ 1692 NC_("SC_OPCODE_COUNT", "Counts how many numbers are in the list of arguments."), 1693 NC_("SC_OPCODE_COUNT", "Value "), 1694 NC_("SC_OPCODE_COUNT", "Value 1, value 2, ... are arguments containing different data types but where only numbers are counted.") 1695}; 1696 1697// -=*# Resource for function COUNTA #*=- 1698const char* SC_OPCODE_COUNT_2_ARY[] = 1699{ 1700 NC_("SC_OPCODE_COUNT_2", "Counts how many values are in the list of arguments."), 1701 NC_("SC_OPCODE_COUNT_2", "Value "), 1702 NC_("SC_OPCODE_COUNT_2", "Value 1, value 2, ... are arguments representing the values to be counted.") 1703}; 1704 1705// -=*# Resource for function MAX #*=- 1706const char* SC_OPCODE_MAX_ARY[] = 1707{ 1708 NC_("SC_OPCODE_MAX", "Returns the maximum value in a list of arguments."), 1709 NC_("SC_OPCODE_MAX", "Number "), 1710 NC_("SC_OPCODE_MAX", "Number 1, number 2, ... are numerical arguments for which the largest number is to be determined.") 1711}; 1712 1713// -=*# Resource for function MAXA #*=- 1714const char* SC_OPCODE_MAX_A_ARY[] = 1715{ 1716 NC_("SC_OPCODE_MAX_A", "Returns the maximum value in a list of arguments. Text is evaluated as Zero."), 1717 NC_("SC_OPCODE_MAX_A", "Value "), 1718 NC_("SC_OPCODE_MAX_A", "Value 1, value 2, are arguments whose largest value is to be determined.") 1719}; 1720 1721// -=*# Resource for function MIN #*=- 1722const char* SC_OPCODE_MIN_ARY[] = 1723{ 1724 NC_("SC_OPCODE_MIN", "Returns the minimum value in a list of arguments."), 1725 NC_("SC_OPCODE_MIN", "Number "), 1726 NC_("SC_OPCODE_MIN", "Number 1, number 2, ... are numerical arguments for which the smallest number is to be determined.") 1727}; 1728 1729// -=*# Resource for function MINA #*=- 1730const char* SC_OPCODE_MIN_A_ARY[] = 1731{ 1732 NC_("SC_OPCODE_MIN_A", "Returns the smallest value in a list of arguments. Text is evaluated as zero."), 1733 NC_("SC_OPCODE_MIN_A", "Value "), 1734 NC_("SC_OPCODE_MIN_A", "Value 1; value 2;... are arguments whose smallest number is to be determined.") 1735}; 1736 1737// -=*# Resource for function VAR #*=- 1738const char* SC_OPCODE_VAR_ARY[] = 1739{ 1740 NC_("SC_OPCODE_VAR", "Calculates the variance based on a sample."), 1741 NC_("SC_OPCODE_VAR", "Number "), 1742 NC_("SC_OPCODE_VAR", "Number 1, number 2, ... are numerical arguments which portray a sample of a population.") 1743}; 1744 1745// -=*# Resource for function VAR.S #*=- 1746const char* SC_OPCODE_VAR_S_ARY[] = 1747{ 1748 NC_("SC_OPCODE_VAR_S", "Calculates the variance based on a sample."), 1749 NC_("SC_OPCODE_VAR_S", "Number "), 1750 NC_("SC_OPCODE_VAR_S", "Number 1, number 2, ... are numerical arguments which portray a sample of a population.") 1751}; 1752 1753// -=*# Resource for function VARA #*=- 1754const char* SC_OPCODE_VAR_A_ARY[] = 1755{ 1756 NC_("SC_OPCODE_VAR_A", "Returns the variance based on a sample. Text is evaluated as zero."), 1757 NC_("SC_OPCODE_VAR_A", "Value "), 1758 NC_("SC_OPCODE_VAR_A", "Value 1; value 2; ... are arguments representing a sample taken from a basic total population.") 1759}; 1760 1761// -=*# Resource for function VARP #*=- 1762const char* SC_OPCODE_VAR_P_ARY[] = 1763{ 1764 NC_("SC_OPCODE_VAR_P", "Calculates variance based on the entire population."), 1765 NC_("SC_OPCODE_VAR_P", "Number "), 1766 NC_("SC_OPCODE_VAR_P", "Number 1, number 2, ... are numerical arguments which represent a population.") 1767}; 1768 1769// -=*# Resource for function VAR.P #*=- 1770const char* SC_OPCODE_VAR_P_MS_ARY[] = 1771{ 1772 NC_("SC_OPCODE_VAR_P_MS", "Calculates variance based on the entire population."), 1773 NC_("SC_OPCODE_VAR_P_MS", "Number "), 1774 NC_("SC_OPCODE_VAR_P_MS", "Number 1, number 2, ... are numerical arguments which represent a population.") 1775}; 1776 1777// -=*# Resource for function VARPA #*=- 1778const char* SC_OPCODE_VAR_P_A_ARY[] = 1779{ 1780 NC_("SC_OPCODE_VAR_P_A", "Returns the variance based on the entire population. Text is evaluated as zero."), 1781 NC_("SC_OPCODE_VAR_P_A", "Value "), 1782 NC_("SC_OPCODE_VAR_P_A", "Value 1; value 2;... are arguments representing a population.") 1783}; 1784 1785// -=*# Resource for function STDEV #*=- 1786const char* SC_OPCODE_ST_DEV_ARY[] = 1787{ 1788 NC_("SC_OPCODE_ST_DEV", "Calculates the standard deviation based on a sample."), 1789 NC_("SC_OPCODE_ST_DEV", "Number "), 1790 NC_("SC_OPCODE_ST_DEV", "Number 1, number 2, ... are numerical arguments which portray a sample of a population.") 1791}; 1792 1793// -=*# Resource for function STDEV.S #*=- 1794const char* SC_OPCODE_ST_DEV_S_ARY[] = 1795{ 1796 NC_("SC_OPCODE_ST_DEV_S", "Calculates the standard deviation based on a sample."), 1797 NC_("SC_OPCODE_ST_DEV_S", "Number "), 1798 NC_("SC_OPCODE_ST_DEV_S", "Number 1, number 2, ... are numerical arguments which portray a sample of a population.") 1799}; 1800 1801// -=*# Resource for function STDEVA #*=- 1802const char* SC_OPCODE_ST_DEV_A_ARY[] = 1803{ 1804 NC_("SC_OPCODE_ST_DEV_A", "Returns the standard deviation based on a sample. Text is evaluated as zero."), 1805 NC_("SC_OPCODE_ST_DEV_A", "Value "), 1806 NC_("SC_OPCODE_ST_DEV_A", "Value 1; value 2; ... are arguments representing a sample taken from a basic total population.") 1807}; 1808 1809// -=*# Resource for function STDEVP #*=- 1810const char* SC_OPCODE_ST_DEV_P_ARY[] = 1811{ 1812 NC_("SC_OPCODE_ST_DEV_P", "Calculates the standard deviation based on the entire population."), 1813 NC_("SC_OPCODE_ST_DEV_P", "Number "), 1814 NC_("SC_OPCODE_ST_DEV_P", "Number 1, number 2, ... are numerical arguments which portray a population.") 1815}; 1816 1817// -=*# Resource for function STDEV.P #*=- 1818const char* SC_OPCODE_ST_DEV_P_MS_ARY[] = 1819{ 1820 NC_("SC_OPCODE_ST_DEV_P_MS", "Calculates the standard deviation based on the entire population."), 1821 NC_("SC_OPCODE_ST_DEV_P_MS", "Number "), 1822 NC_("SC_OPCODE_ST_DEV_P_MS", "Number 1, number 2, ... are numerical arguments which portray a population.") 1823}; 1824 1825// -=*# Resource for function STDEVPA #*=- 1826const char* SC_OPCODE_ST_DEV_P_A_ARY[] = 1827{ 1828 NC_("SC_OPCODE_ST_DEV_P_A", "Returns the standard deviation based on the entire population. Text is evaluated as zero."), 1829 NC_("SC_OPCODE_ST_DEV_P_A", "Value "), 1830 NC_("SC_OPCODE_ST_DEV_P_A", "Value 1; value 2;... are arguments corresponding to a population.") 1831}; 1832 1833// -=*# Resource for function AVERAGE #*=- 1834const char* SC_OPCODE_AVERAGE_ARY[] = 1835{ 1836 NC_("SC_OPCODE_AVERAGE", "Returns the average of a sample."), 1837 NC_("SC_OPCODE_AVERAGE", "Number "), 1838 NC_("SC_OPCODE_AVERAGE", "Number 1, number 2;...are numeric arguments representing a population sample.") 1839}; 1840 1841// -=*# Resource for function AVERAGEA #*=- 1842const char* SC_OPCODE_AVERAGE_A_ARY[] = 1843{ 1844 NC_("SC_OPCODE_AVERAGE_A", "Returns the average value for a sample. Text is evaluated as zero."), 1845 NC_("SC_OPCODE_AVERAGE_A", "Value "), 1846 NC_("SC_OPCODE_AVERAGE_A", "Value 1; value 2; ... are arguments representing a sample taken from a basic total population.") 1847}; 1848 1849// -=*# Resource for function DEVSQ #*=- 1850const char* SC_OPCODE_DEV_SQ_ARY[] = 1851{ 1852 NC_("SC_OPCODE_DEV_SQ", "Returns the sum of squares of deviations from the sample mean value"), 1853 NC_("SC_OPCODE_DEV_SQ", "Number "), 1854 NC_("SC_OPCODE_DEV_SQ", "Number 1, number 2, ... are numerical arguments which portray a sample.") 1855}; 1856 1857// -=*# Resource for function AVEDEV #*=- 1858const char* SC_OPCODE_AVE_DEV_ARY[] = 1859{ 1860 NC_("SC_OPCODE_AVE_DEV", "Returns the average of the absolute deviations of a sample from the mean."), 1861 NC_("SC_OPCODE_AVE_DEV", "Number "), 1862 NC_("SC_OPCODE_AVE_DEV", "Number 1, number 2;...are numerical arguments representing a sample.") 1863}; 1864 1865// -=*# Resource for function SKEW #*=- 1866const char* SC_OPCODE_SKEW_ARY[] = 1867{ 1868 NC_("SC_OPCODE_SKEW", "Returns the skewness of a distribution."), 1869 NC_("SC_OPCODE_SKEW", "Number "), 1870 NC_("SC_OPCODE_SKEW", "Number 1, number 2, ... are numerical arguments portraying a sample of the distribution.") 1871}; 1872 1873// -=*# Resource for function SKEWP #*=- 1874const char* SC_OPCODE_SKEWP_ARY[] = 1875{ 1876 NC_("SC_OPCODE_SKEWP", "Returns the skewness of a distribution using the population of a random variable."), 1877 NC_("SC_OPCODE_SKEWP", "Number "), 1878 NC_("SC_OPCODE_SKEWP", "Number 1, number 2, ... are numerical arguments portraying the population.") 1879}; 1880 1881// -=*# Resource for function KURT #*=- 1882const char* SC_OPCODE_KURT_ARY[] = 1883{ 1884 NC_("SC_OPCODE_KURT", "Returns the kurtosis of a distribution."), 1885 NC_("SC_OPCODE_KURT", "Number "), 1886 NC_("SC_OPCODE_KURT", "Number 1, number 2, ... are numerical arguments, representing a sample of the distribution.") 1887}; 1888 1889// -=*# Resource for function GEOMEAN #*=- 1890const char* SC_OPCODE_GEO_MEAN_ARY[] = 1891{ 1892 NC_("SC_OPCODE_GEO_MEAN", "Returns the geometric mean of a sample."), 1893 NC_("SC_OPCODE_GEO_MEAN", "Number "), 1894 NC_("SC_OPCODE_GEO_MEAN", "Number 1, number 2, ... are numerical arguments which portray a sample.") 1895}; 1896 1897// -=*# Resource for function HARMEAN #*=- 1898const char* SC_OPCODE_HAR_MEAN_ARY[] = 1899{ 1900 NC_("SC_OPCODE_HAR_MEAN", "Returns the harmonic mean of a sample."), 1901 NC_("SC_OPCODE_HAR_MEAN", "Number "), 1902 NC_("SC_OPCODE_HAR_MEAN", "Number 1, number 2, ... are numerical arguments which portray a sample.") 1903}; 1904 1905// -=*# Resource for function MODE #*=- 1906const char* SC_OPCODE_MODAL_VALUE_ARY[] = 1907{ 1908 NC_("SC_OPCODE_MODAL_VALUE", "Returns the most common value in a sample."), 1909 NC_("SC_OPCODE_MODAL_VALUE", "Number "), 1910 NC_("SC_OPCODE_MODAL_VALUE", "Number 1, number 2, ... are numerical arguments which portray a sample.") 1911}; 1912 1913// -=*# Resource for function MODE.SNGL #*=- 1914const char* SC_OPCODE_MODAL_VALUE_MS_ARY[] = 1915{ 1916 NC_("SC_OPCODE_MODAL_VALUE_MS", "Returns the most common value in a sample."), 1917 NC_("SC_OPCODE_MODAL_VALUE_MS", "Number "), 1918 NC_("SC_OPCODE_MODAL_VALUE_MS", "Number 1, number 2, ... are numerical arguments which portray a sample.") 1919}; 1920 1921// -=*# Resource for function MODE.MULT #*=- 1922const char* SC_OPCODE_MODAL_VALUE_MULTI_ARY[] = 1923{ 1924 NC_("SC_OPCODE_MODAL_VALUE_MULTI", "Returns the most common value in a sample."), 1925 NC_("SC_OPCODE_MODAL_VALUE_MULTI", "Number "), 1926 NC_("SC_OPCODE_MODAL_VALUE_MULTI", "Number 1, number 2, ... are 1 to 254 numerical arguments which portray a sample.") 1927}; 1928 1929// -=*# Resource for function MEDIAN #*=- 1930const char* SC_OPCODE_MEDIAN_ARY[] = 1931{ 1932 NC_("SC_OPCODE_MEDIAN", "Returns the median of a given sample."), 1933 NC_("SC_OPCODE_MEDIAN", "Number "), 1934 NC_("SC_OPCODE_MEDIAN", "Number 1, number 2, ... are numerical arguments which portray a sample.") 1935}; 1936 1937// -=*# Resource for function PERCENTILE #*=- 1938const char* SC_OPCODE_PERCENTILE_ARY[] = 1939{ 1940 NC_("SC_OPCODE_PERCENTILE", "Returns the alpha percentile of a sample."), 1941 NC_("SC_OPCODE_PERCENTILE", "Data"), 1942 NC_("SC_OPCODE_PERCENTILE", "The array of the data in the sample."), 1943 NC_("SC_OPCODE_PERCENTILE", "Alpha"), 1944 NC_("SC_OPCODE_PERCENTILE", "The percentile value between 0 and 1, inclusive.") 1945}; 1946 1947// -=*# Resource for function PERCENTILE.EXC #*=- 1948const char* SC_OPCODE_PERCENTILE_EXC_ARY[] = 1949{ 1950 NC_("SC_OPCODE_PERCENTILE_EXC", "Returns the alpha percentile of a sample."), 1951 NC_("SC_OPCODE_PERCENTILE_EXC", "Data"), 1952 NC_("SC_OPCODE_PERCENTILE_EXC", "The array of the data in the sample."), 1953 NC_("SC_OPCODE_PERCENTILE_EXC", "Alpha"), 1954 NC_("SC_OPCODE_PERCENTILE_EXC", "The percentile value, range 0...1, exclusive.") 1955}; 1956 1957// -=*# Resource for function PERCENTILE.INC #*=- 1958const char* SC_OPCODE_PERCENTILE_INC_ARY[] = 1959{ 1960 NC_("SC_OPCODE_PERCENTILE_INC", "Returns the alpha percentile of a sample."), 1961 NC_("SC_OPCODE_PERCENTILE_INC", "Data"), 1962 NC_("SC_OPCODE_PERCENTILE_INC", "The array of the data in the sample."), 1963 NC_("SC_OPCODE_PERCENTILE_INC", "Alpha"), 1964 NC_("SC_OPCODE_PERCENTILE_INC", "The percentile value, range 0...1, inclusive.") 1965}; 1966 1967// -=*# Resource for function QUARTILE #*=- 1968const char* SC_OPCODE_QUARTILE_ARY[] = 1969{ 1970 NC_("SC_OPCODE_QUARTILE", "Returns the quartile of a sample."), 1971 NC_("SC_OPCODE_QUARTILE", "Data"), 1972 NC_("SC_OPCODE_QUARTILE", "The array of the data in the sample."), 1973 NC_("SC_OPCODE_QUARTILE", "Type"), 1974 NC_("SC_OPCODE_QUARTILE", "The type of the quartile (0 = MIN, 1 = 25%, 2 = 50%, 3 = 75%, 4 = MAX).") 1975}; 1976 1977// -=*# Resource for function QUARTILE.EXC #*=- 1978const char* SC_OPCODE_QUARTILE_EXC_ARY[] = 1979{ 1980 NC_("SC_OPCODE_QUARTILE_EXC", "Returns the quartile of a sample."), 1981 NC_("SC_OPCODE_QUARTILE_EXC", "Data"), 1982 NC_("SC_OPCODE_QUARTILE_EXC", "The array of the data in the sample."), 1983 NC_("SC_OPCODE_QUARTILE_EXC", "Type"), 1984 NC_("SC_OPCODE_QUARTILE_EXC", "The type of the quartile (1 = 25%, 2 = 50%, 3 = 75%).") 1985}; 1986 1987// -=*# Resource for function QUARTILE.INC #*=- 1988const char* SC_OPCODE_QUARTILE_INC_ARY[] = 1989{ 1990 NC_("SC_OPCODE_QUARTILE_INC", "Returns the quartile of a sample."), 1991 NC_("SC_OPCODE_QUARTILE_INC", "Data"), 1992 NC_("SC_OPCODE_QUARTILE_INC", "The array of the data in the sample."), 1993 NC_("SC_OPCODE_QUARTILE_INC", "Type"), 1994 NC_("SC_OPCODE_QUARTILE_INC", "The type of the quartile (0 = MIN, 1 = 25%, 2 = 50%, 3 = 75%, 4 = MAX).") 1995}; 1996 1997// -=*# Resource for function LARGE #*=- 1998const char* SC_OPCODE_LARGE_ARY[] = 1999{ 2000 NC_("SC_OPCODE_LARGE", "Returns the k-th largest value of a sample."), 2001 NC_("SC_OPCODE_LARGE", "Data"), 2002 NC_("SC_OPCODE_LARGE", "The array of the data in the sample."), 2003 NC_("SC_OPCODE_LARGE", "Rank c"), 2004 NC_("SC_OPCODE_LARGE", "The ranking of the value.") 2005}; 2006 2007// -=*# Resource for function SMALL #*=- 2008const char* SC_OPCODE_SMALL_ARY[] = 2009{ 2010 NC_("SC_OPCODE_SMALL", "Returns the k-th smallest value of a sample."), 2011 NC_("SC_OPCODE_SMALL", "Data"), 2012 NC_("SC_OPCODE_SMALL", "The array of the data in the sample."), 2013 NC_("SC_OPCODE_SMALL", "Rank c"), 2014 NC_("SC_OPCODE_SMALL", "The ranking of the value.") 2015}; 2016 2017// -=*# Resource for function PERCENTRANK #*=- 2018const char* SC_OPCODE_PERCENT_RANK_ARY[] = 2019{ 2020 NC_("SC_OPCODE_PERCENT_RANK", "Returns the percentage rank of a value in a sample."), 2021 NC_("SC_OPCODE_PERCENT_RANK", "Data"), 2022 NC_("SC_OPCODE_PERCENT_RANK", "The array of the data in the sample."), 2023 NC_("SC_OPCODE_PERCENT_RANK", "Value"), 2024 NC_("SC_OPCODE_PERCENT_RANK", "The value for which percentage ranking is to be determined."), 2025 NC_("SC_OPCODE_PERCENT_RANK", "Significance"), 2026 NC_("SC_OPCODE_PERCENT_RANK", "The number of significant digits for the returned percentage: if omitted, a value of 3 is used.") 2027}; 2028 2029// -=*# Resource for function PERCENTRANK.EXC #*=- 2030const char* SC_OPCODE_PERCENT_RANK_EXC_ARY[] = 2031{ 2032 NC_("SC_OPCODE_PERCENT_RANK_EXC", "Returns the percentage rank (0..1, exclusive) of a value in a sample."), 2033 NC_("SC_OPCODE_PERCENT_RANK_EXC", "Data"), 2034 NC_("SC_OPCODE_PERCENT_RANK_EXC", "The array of the data in the sample."), 2035 NC_("SC_OPCODE_PERCENT_RANK_EXC", "Value"), 2036 NC_("SC_OPCODE_PERCENT_RANK_EXC", "The value for which percentage ranking is to be determined."), 2037 NC_("SC_OPCODE_PERCENT_RANK_EXC", "Significance"), 2038 NC_("SC_OPCODE_PERCENT_RANK_EXC", "The number of significant digits for the returned percentage: if omitted, a value of 3 is used.") 2039}; 2040 2041// -=*# Resource for function PERCENTRANK.INC #*=- 2042const char* SC_OPCODE_PERCENT_RANK_INC_ARY[] = 2043{ 2044 NC_("SC_OPCODE_PERCENT_RANK_INC", "Returns the percentage rank (0..1, inclusive) of a value in a sample."), 2045 NC_("SC_OPCODE_PERCENT_RANK_INC", "Data"), 2046 NC_("SC_OPCODE_PERCENT_RANK_INC", "The array of the data in the sample."), 2047 NC_("SC_OPCODE_PERCENT_RANK_INC", "Value"), 2048 NC_("SC_OPCODE_PERCENT_RANK_INC", "The value for which percentage ranking is to be determined."), 2049 NC_("SC_OPCODE_PERCENT_RANK_INC", "Significance"), 2050 NC_("SC_OPCODE_PERCENT_RANK_INC", "The number of significant digits for the returned percentage: if omitted, a value of 3 is used.") 2051}; 2052 2053// -=*# Resource for function RANK #*=- 2054const char* SC_OPCODE_RANK_ARY[] = 2055{ 2056 NC_("SC_OPCODE_RANK", "Returns the ranking of a value in a sample."), 2057 NC_("SC_OPCODE_RANK", "Value"), 2058 NC_("SC_OPCODE_RANK", "The value for which the rank is to be determined."), 2059 NC_("SC_OPCODE_RANK", "Data"), 2060 NC_("SC_OPCODE_RANK", "The array of the data in the sample."), 2061 NC_("SC_OPCODE_RANK", "Type"), 2062 NC_("SC_OPCODE_RANK", "Sequence order: 0 or omitted means descending, any other value than 0 means ascending.") 2063}; 2064 2065// -=*# Resource for function RANK.EQ #*=- 2066const char* SC_OPCODE_RANK_EQ_ARY[] = 2067{ 2068 NC_("SC_OPCODE_RANK_EQ", "Returns the ranking of a value in a sample; if more than one value has the same rank, the top rank of that set of values is returned."), 2069 NC_("SC_OPCODE_RANK_EQ", "Value"), 2070 NC_("SC_OPCODE_RANK_EQ", "The value for which the rank is to be determined."), 2071 NC_("SC_OPCODE_RANK_EQ", "Data"), 2072 NC_("SC_OPCODE_RANK_EQ", "The array of the data in the sample."), 2073 NC_("SC_OPCODE_RANK_EQ", "Type"), 2074 NC_("SC_OPCODE_RANK_EQ", "Sequence order: 0 or omitted means descending, any other value than 0 means ascending.") 2075}; 2076 2077// -=*# Resource for function RANK.AVG #*=- 2078const char* SC_OPCODE_RANK_AVG_ARY[] = 2079{ 2080 NC_("SC_OPCODE_RANK_AVG", "Returns the ranking of a value in a sample; if more than one value has the same rank, the average rank is returned."), 2081 NC_("SC_OPCODE_RANK_AVG", "Value"), 2082 NC_("SC_OPCODE_RANK_AVG", "The value for which the rank is to be determined."), 2083 NC_("SC_OPCODE_RANK_AVG", "Data"), 2084 NC_("SC_OPCODE_RANK_AVG", "The array of the data in the sample."), 2085 NC_("SC_OPCODE_RANK_AVG", "Type"), 2086 NC_("SC_OPCODE_RANK_AVG", "Sequence order: 0 or omitted means descending, any other value than 0 means ascending.") 2087}; 2088 2089// -=*# Resource for function TRIMMEAN #*=- 2090const char* SC_OPCODE_TRIM_MEAN_ARY[] = 2091{ 2092 NC_("SC_OPCODE_TRIM_MEAN", "Returns the mean of a sample without including the marginal values."), 2093 NC_("SC_OPCODE_TRIM_MEAN", "Data"), 2094 NC_("SC_OPCODE_TRIM_MEAN", "The array of the data in the sample."), 2095 NC_("SC_OPCODE_TRIM_MEAN", "Alpha"), 2096 NC_("SC_OPCODE_TRIM_MEAN", "The percentage of marginal data that is not to be taken into account.") 2097}; 2098 2099// -=*# Resource for function PROB #*=- 2100const char* SC_OPCODE_PROB_ARY[] = 2101{ 2102 NC_("SC_OPCODE_PROB", "Returns the discrete probability of an interval."), 2103 NC_("SC_OPCODE_PROB", "Data"), 2104 NC_("SC_OPCODE_PROB", "The sample data array."), 2105 NC_("SC_OPCODE_PROB", "Probability"), 2106 NC_("SC_OPCODE_PROB", "The array of the associated probabilities."), 2107 NC_("SC_OPCODE_PROB", "Start"), 2108 NC_("SC_OPCODE_PROB", "The start of the value interval whose probabilities is to be totalled."), 2109 NC_("SC_OPCODE_PROB", "End"), 2110 NC_("SC_OPCODE_PROB", "The end of the value interval where the probabilities are to be totalled.") 2111}; 2112 2113// -=*# Resource for function B #*=- 2114const char* SC_OPCODE_B_ARY[] = 2115{ 2116 NC_("SC_OPCODE_B", "Returns the probability of a trial result using binomial distribution."), 2117 NC_("SC_OPCODE_B", "Trials"), 2118 NC_("SC_OPCODE_B", "The number of trials."), 2119 NC_("SC_OPCODE_B", "SP"), 2120 NC_("SC_OPCODE_B", "The individual probability of a trial result."), 2121 NC_("SC_OPCODE_B", "T 1"), 2122 NC_("SC_OPCODE_B", "Lower limit for the number of trials."), 2123 NC_("SC_OPCODE_B", "T 2"), 2124 NC_("SC_OPCODE_B", "Upper limit for the number of trials.") 2125}; 2126 2127// -=*# Resource for function PHI #*=- 2128const char* SC_OPCODE_PHI_ARY[] = 2129{ 2130 NC_("SC_OPCODE_PHI", "Values of the distribution function for a standard normal distribution."), 2131 NC_("SC_OPCODE_PHI", "Number"), 2132 NC_("SC_OPCODE_PHI", "The value for which the standard normal distribution is to be calculated.") 2133}; 2134 2135// -=*# Resource for function GAUSS #*=- 2136const char* SC_OPCODE_GAUSS_ARY[] = 2137{ 2138 NC_("SC_OPCODE_GAUSS", "Returns the integral values of the standard normal cumulative distribution."), 2139 NC_("SC_OPCODE_GAUSS", "Number"), 2140 NC_("SC_OPCODE_GAUSS", "The value for which the integral value of the standard normal distribution is to be calculated.") 2141}; 2142 2143// -=*# Resource for function FISHER #*=- 2144const char* SC_OPCODE_FISHER_ARY[] = 2145{ 2146 NC_("SC_OPCODE_FISHER", "Returns the Fisher transformation."), 2147 NC_("SC_OPCODE_FISHER", "Number"), 2148 NC_("SC_OPCODE_FISHER", "The value to be transformed (-1 < VALUE < 1).") 2149}; 2150 2151// -=*# Resource for function FISHERINV #*=- 2152const char* SC_OPCODE_FISHER_INV_ARY[] = 2153{ 2154 NC_("SC_OPCODE_FISHER_INV", "Returns the inverse of the Fisher transformation."), 2155 NC_("SC_OPCODE_FISHER_INV", "Number"), 2156 NC_("SC_OPCODE_FISHER_INV", "The value that is to be transformed back.") 2157}; 2158 2159// -=*# Resource for function BINOMDIST #*=- 2160const char* SC_OPCODE_BINOM_DIST_ARY[] = 2161{ 2162 NC_("SC_OPCODE_BINOM_DIST", "Values of the binomial distribution."), 2163 NC_("SC_OPCODE_BINOM_DIST", "X"), 2164 NC_("SC_OPCODE_BINOM_DIST", "The number of successes in a series of trials."), 2165 NC_("SC_OPCODE_BINOM_DIST", "Trials"), 2166 NC_("SC_OPCODE_BINOM_DIST", "The total number of trials."), 2167 NC_("SC_OPCODE_BINOM_DIST", "SP"), 2168 NC_("SC_OPCODE_BINOM_DIST", "The success probability of a trial."), 2169 NC_("SC_OPCODE_BINOM_DIST", "C"), 2170 NC_("SC_OPCODE_BINOM_DIST", "Cumulated. C=0 calculates the individual probability, C=1 the cumulated probability.") 2171}; 2172 2173// -=*# Resource for function BINOM.DIST #*=- 2174const char* SC_OPCODE_BINOM_DIST_MS_ARY[] = 2175{ 2176 NC_("SC_OPCODE_BINOM_DIST_MS", "Values of the binomial distribution."), 2177 NC_("SC_OPCODE_BINOM_DIST_MS", "X"), 2178 NC_("SC_OPCODE_BINOM_DIST_MS", "The number of successes in a series of trials."), 2179 NC_("SC_OPCODE_BINOM_DIST_MS", "Trials"), 2180 NC_("SC_OPCODE_BINOM_DIST_MS", "The total number of trials."), 2181 NC_("SC_OPCODE_BINOM_DIST_MS", "SP"), 2182 NC_("SC_OPCODE_BINOM_DIST_MS", "The success probability of a trial."), 2183 NC_("SC_OPCODE_BINOM_DIST_MS", "C"), 2184 NC_("SC_OPCODE_BINOM_DIST_MS", "Cumulated. C=0 calculates the individual probability, C=1 the cumulated probability.") 2185}; 2186 2187// -=*# Resource for function NEGBINOMDIST #*=- 2188const char* SC_OPCODE_NEG_BINOM_VERT_ARY[] = 2189{ 2190 NC_("SC_OPCODE_NEG_BINOM_VERT", "Values of the negative binomial distribution."), 2191 NC_("SC_OPCODE_NEG_BINOM_VERT", "X"), 2192 NC_("SC_OPCODE_NEG_BINOM_VERT", "The number of failures in the trial range."), 2193 NC_("SC_OPCODE_NEG_BINOM_VERT", "R"), 2194 NC_("SC_OPCODE_NEG_BINOM_VERT", "The number of successes in the trial sequence."), 2195 NC_("SC_OPCODE_NEG_BINOM_VERT", "SP"), 2196 NC_("SC_OPCODE_NEG_BINOM_VERT", "The success probability of a trial.") 2197}; 2198 2199// -=*# Resource for function NEGBINOM.DIST #*=- 2200const char* SC_OPCODE_NEG_BINOM_DIST_MS_ARY[] = 2201{ 2202 NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "Values of the negative binomial distribution."), 2203 NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "X"), 2204 NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "The number of failures in the trial range."), 2205 NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "R"), 2206 NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "The number of successes in the trial sequence."), 2207 NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "SP"), 2208 NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "The success probability of a trial."), 2209 NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "Cumulative"), 2210 NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function.") 2211}; 2212 2213// -=*# Resource for function CRITBINOM #*=- 2214const char* SC_OPCODE_CRIT_BINOM_ARY[] = 2215{ 2216 NC_("SC_OPCODE_CRIT_BINOM", "Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value."), 2217 NC_("SC_OPCODE_CRIT_BINOM", "Trials"), 2218 NC_("SC_OPCODE_CRIT_BINOM", "The total number of trials."), 2219 NC_("SC_OPCODE_CRIT_BINOM", "SP"), 2220 NC_("SC_OPCODE_CRIT_BINOM", "The success probability of a trial."), 2221 NC_("SC_OPCODE_CRIT_BINOM", "Alpha"), 2222 NC_("SC_OPCODE_CRIT_BINOM", "The border probability that is attained or exceeded.") 2223}; 2224 2225// -=*# Resource for function BINOM.INV #*=- 2226const char* SC_OPCODE_BINOM_INV_ARY[] = 2227{ 2228 NC_("SC_OPCODE_BINOM_INV", "Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value."), 2229 NC_("SC_OPCODE_BINOM_INV", "Trials"), 2230 NC_("SC_OPCODE_BINOM_INV", "The total number of trials."), 2231 NC_("SC_OPCODE_BINOM_INV", "SP"), 2232 NC_("SC_OPCODE_BINOM_INV", "The success probability of a trial."), 2233 NC_("SC_OPCODE_BINOM_INV", "Alpha"), 2234 NC_("SC_OPCODE_BINOM_INV", "The border probability that is attained or exceeded.") 2235}; 2236 2237// -=*# Resource for function POISSON #*=- 2238const char* SC_OPCODE_POISSON_DIST_ARY[] = 2239{ 2240 NC_("SC_OPCODE_POISSON_DIST", "Returns the Poisson distribution."), 2241 NC_("SC_OPCODE_POISSON_DIST", "Number"), 2242 NC_("SC_OPCODE_POISSON_DIST", "The value for which the Poisson distribution is to be calculated."), 2243 NC_("SC_OPCODE_POISSON_DIST", "Mean"), 2244 NC_("SC_OPCODE_POISSON_DIST", "Mean. The mean value of the Poisson distribution."), 2245 NC_("SC_OPCODE_POISSON_DIST", "Cumulative"), 2246 NC_("SC_OPCODE_POISSON_DIST", "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function.") 2247}; 2248 2249// -=*# Resource for function POISSON.DIST #*=- 2250const char* SC_OPCODE_POISSON_DIST_MS_ARY[] = 2251{ 2252 NC_("SC_OPCODE_POISSON_DIST_MS", "Returns the Poisson distribution."), 2253 NC_("SC_OPCODE_POISSON_DIST_MS", "Number"), 2254 NC_("SC_OPCODE_POISSON_DIST_MS", "The value for which the Poisson distribution is to be calculated."), 2255 NC_("SC_OPCODE_POISSON_DIST_MS", "Mean"), 2256 NC_("SC_OPCODE_POISSON_DIST_MS", "Mean. The mean value of the Poisson distribution."), 2257 NC_("SC_OPCODE_POISSON_DIST_MS", "Cumulative"), 2258 NC_("SC_OPCODE_POISSON_DIST_MS", "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function.") 2259}; 2260 2261// -=*# Resource for function NORMDIST #*=- 2262const char* SC_OPCODE_NORM_DIST_ARY[] = 2263{ 2264 NC_("SC_OPCODE_NORM_DIST", "Values of the normal distribution."), 2265 NC_("SC_OPCODE_NORM_DIST", "Number"), 2266 NC_("SC_OPCODE_NORM_DIST", "The value for which the normal distribution is to be calculated."), 2267 NC_("SC_OPCODE_NORM_DIST", "Mean"), 2268 NC_("SC_OPCODE_NORM_DIST", "The mean value. The mean value of the normal distribution."), 2269 NC_("SC_OPCODE_NORM_DIST", "STDEV"), 2270 NC_("SC_OPCODE_NORM_DIST", "Standard deviation. The standard deviation of the normal distribution."), 2271 NC_("SC_OPCODE_NORM_DIST", "C"), 2272 NC_("SC_OPCODE_NORM_DIST", "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function.") 2273}; 2274 2275// -=*# Resource for function NORM.DIST #*=- 2276const char* SC_OPCODE_NORM_DIST_MS_ARY[] = 2277{ 2278 NC_("SC_OPCODE_NORM_DIST_MS", "Values of the normal distribution."), 2279 NC_("SC_OPCODE_NORM_DIST_MS", "Number"), 2280 NC_("SC_OPCODE_NORM_DIST_MS", "The value for which the normal distribution is to be calculated."), 2281 NC_("SC_OPCODE_NORM_DIST_MS", "Mean"), 2282 NC_("SC_OPCODE_NORM_DIST_MS", "The mean value. The mean value of the normal distribution."), 2283 NC_("SC_OPCODE_NORM_DIST_MS", "STDEV"), 2284 NC_("SC_OPCODE_NORM_DIST_MS", "Standard deviation. The standard deviation of the normal distribution."), 2285 NC_("SC_OPCODE_NORM_DIST_MS", "C"), 2286 NC_("SC_OPCODE_NORM_DIST_MS", "0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function.") 2287}; 2288 2289// -=*# Resource for function NORMINV #*=- 2290const char* SC_OPCODE_NORM_INV_ARY[] = 2291{ 2292 NC_("SC_OPCODE_NORM_INV", "Values of the inverse normal distribution."), 2293 NC_("SC_OPCODE_NORM_INV", "Number"), 2294 NC_("SC_OPCODE_NORM_INV", "The probability value for which the inverse normal distribution is to be calculated."), 2295 NC_("SC_OPCODE_NORM_INV", "Mean"), 2296 NC_("SC_OPCODE_NORM_INV", "The mean value. The mean value of the normal distribution."), 2297 NC_("SC_OPCODE_NORM_INV", "STDEV"), 2298 NC_("SC_OPCODE_NORM_INV", "Standard deviation. The standard deviation of the normal distribution.") 2299}; 2300 2301// -=*# Resource for function NORM.INV #*=- 2302const char* SC_OPCODE_NORM_INV_MS_ARY[] = 2303{ 2304 NC_("SC_OPCODE_NORM_INV_MS", "Values of the inverse normal distribution."), 2305 NC_("SC_OPCODE_NORM_INV_MS", "Number"), 2306 NC_("SC_OPCODE_NORM_INV_MS", "The probability value for which the inverse normal distribution is to be calculated."), 2307 NC_("SC_OPCODE_NORM_INV_MS", "Mean"), 2308 NC_("SC_OPCODE_NORM_INV_MS", "The mean value. The mean value of the normal distribution."), 2309 NC_("SC_OPCODE_NORM_INV_MS", "STDEV"), 2310 NC_("SC_OPCODE_NORM_INV_MS", "Standard deviation. The standard deviation of the normal distribution.") 2311}; 2312 2313// -=*# Resource for function NORMSDIST #*=- 2314const char* SC_OPCODE_STD_NORM_DIST_ARY[] = 2315{ 2316 NC_("SC_OPCODE_STD_NORM_DIST", "The values of the standard normal cumulative distribution."), 2317 NC_("SC_OPCODE_STD_NORM_DIST", "Number"), 2318 NC_("SC_OPCODE_STD_NORM_DIST", "The value for which the standard normal distribution is to be calculated.") 2319}; 2320 2321// -=*# Resource for function NORM.S.DIST #*=- 2322const char* SC_OPCODE_STD_NORM_DIST_MS_ARY[] = 2323{ 2324 NC_("SC_OPCODE_STD_NORM_DIST_MS", "The values of the standard normal distribution."), 2325 NC_("SC_OPCODE_STD_NORM_DIST_MS", "Number"), 2326 NC_("SC_OPCODE_STD_NORM_DIST_MS", "The value for which the standard normal distribution is to be calculated."), 2327 NC_("SC_OPCODE_STD_NORM_DIST_MS", "Cumulative"), 2328 NC_("SC_OPCODE_STD_NORM_DIST_MS", "0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function.") 2329}; 2330 2331// -=*# Resource for function NORMSINV #*=- 2332const char* SC_OPCODE_S_NORM_INV_ARY[] = 2333{ 2334 NC_("SC_OPCODE_S_NORM_INV", "Values of the inverse standard normal distribution."), 2335 NC_("SC_OPCODE_S_NORM_INV", "Number"), 2336 NC_("SC_OPCODE_S_NORM_INV", "The probability value for which the inverse standard normal distribution is to be calculated.") 2337}; 2338 2339// -=*# Resource for function NORM.S.INV #*=- 2340const char* SC_OPCODE_S_NORM_INV_MS_ARY[] = 2341{ 2342 NC_("SC_OPCODE_S_NORM_INV_MS", "Values of the inverse standard normal distribution."), 2343 NC_("SC_OPCODE_S_NORM_INV_MS", "Number"), 2344 NC_("SC_OPCODE_S_NORM_INV_MS", "The probability value for which the inverse standard normal distribution is to be calculated.") 2345}; 2346 2347// -=*# Resource for function LOGNORMDIST #*=- 2348const char* SC_OPCODE_LOG_NORM_DIST_ARY[] = 2349{ 2350 NC_("SC_OPCODE_LOG_NORM_DIST", "Values of the log normal distribution."), 2351 NC_("SC_OPCODE_LOG_NORM_DIST", "Number"), 2352 NC_("SC_OPCODE_LOG_NORM_DIST", "The value for which the log normal distribution is to be calculated."), 2353 NC_("SC_OPCODE_LOG_NORM_DIST", "Mean"), 2354 NC_("SC_OPCODE_LOG_NORM_DIST", "The mean value of the log normal distribution. It is set to 0 if omitted."), 2355 NC_("SC_OPCODE_LOG_NORM_DIST", "STDEV"), 2356 NC_("SC_OPCODE_LOG_NORM_DIST", "The standard deviation of the log normal distribution. It is set to 1 if omitted."), 2357 NC_("SC_OPCODE_LOG_NORM_DIST", "Cumulative"), 2358 NC_("SC_OPCODE_LOG_NORM_DIST", "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function.") 2359}; 2360 2361// -=*# Resource for function LOGNORM.DIST #*=- 2362const char* SC_OPCODE_LOG_NORM_DIST_MS_ARY[] = 2363{ 2364 NC_("SC_OPCODE_LOG_NORM_DIST_MS", "Values of the log normal distribution."), 2365 NC_("SC_OPCODE_LOG_NORM_DIST_MS", "Number"), 2366 NC_("SC_OPCODE_LOG_NORM_DIST_MS", "The value for which the log normal distribution is to be calculated."), 2367 NC_("SC_OPCODE_LOG_NORM_DIST_MS", "Mean"), 2368 NC_("SC_OPCODE_LOG_NORM_DIST_MS", "The mean value of the log normal distribution."), 2369 NC_("SC_OPCODE_LOG_NORM_DIST_MS", "STDEV"), 2370 NC_("SC_OPCODE_LOG_NORM_DIST_MS", "The standard deviation of the log normal distribution."), 2371 NC_("SC_OPCODE_LOG_NORM_DIST_MS", "Cumulative"), 2372 NC_("SC_OPCODE_LOG_NORM_DIST_MS", "0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function.") 2373}; 2374 2375// -=*# Resource for function LOGINV #*=- 2376const char* SC_OPCODE_LOG_INV_ARY[] = 2377{ 2378 NC_("SC_OPCODE_LOG_INV", "Values of the inverse of the lognormal distribution."), 2379 NC_("SC_OPCODE_LOG_INV", "Number"), 2380 NC_("SC_OPCODE_LOG_INV", "The probability value for which the inverse log normal distribution is to be calculated."), 2381 NC_("SC_OPCODE_LOG_INV", "Mean"), 2382 NC_("SC_OPCODE_LOG_INV", "Mean value. The mean value of the log normal distribution."), 2383 NC_("SC_OPCODE_LOG_INV", "STDEV"), 2384 NC_("SC_OPCODE_LOG_INV", "Standard deviation. The standard deviation of the log normal distribution.") 2385}; 2386 2387// -=*# Resource for function LOGNORM.INV #*=- 2388const char* SC_OPCODE_LOG_INV_MS_ARY[] = 2389{ 2390 NC_("SC_OPCODE_LOG_INV_MS", "Values of the inverse of the lognormal distribution."), 2391 NC_("SC_OPCODE_LOG_INV_MS", "Number"), 2392 NC_("SC_OPCODE_LOG_INV_MS", "The probability value for which the inverse log normal distribution is to be calculated."), 2393 NC_("SC_OPCODE_LOG_INV_MS", "Mean"), 2394 NC_("SC_OPCODE_LOG_INV_MS", "Mean value. The mean value of the log normal distribution."), 2395 NC_("SC_OPCODE_LOG_INV_MS", "STDEV"), 2396 NC_("SC_OPCODE_LOG_INV_MS", "Standard deviation. The standard deviation of the log normal distribution.") 2397}; 2398 2399// -=*# Resource for function EXPONDIST #*=- 2400const char* SC_OPCODE_EXP_DIST_ARY[] = 2401{ 2402 NC_("SC_OPCODE_EXP_DIST", "Values of the exponential distribution."), 2403 NC_("SC_OPCODE_EXP_DIST", "Number"), 2404 NC_("SC_OPCODE_EXP_DIST", "The value to which the exponential distribution is to be calculated."), 2405 NC_("SC_OPCODE_EXP_DIST", "Lambda"), 2406 NC_("SC_OPCODE_EXP_DIST", "The parameters of the exponential distribution."), 2407 NC_("SC_OPCODE_EXP_DIST", "C"), 2408 NC_("SC_OPCODE_EXP_DIST", "Cumulated. C=0 calculates the density function, C=1 the distribution.") 2409}; 2410 2411// -=*# Resource for function EXPON.DIST #*=- 2412const char* SC_OPCODE_EXP_DIST_MS_ARY[] = 2413{ 2414 NC_("SC_OPCODE_EXP_DIST_MS", "Values of the exponential distribution."), 2415 NC_("SC_OPCODE_EXP_DIST_MS", "Number"), 2416 NC_("SC_OPCODE_EXP_DIST_MS", "The value to which the exponential distribution is to be calculated."), 2417 NC_("SC_OPCODE_EXP_DIST_MS", "Lambda"), 2418 NC_("SC_OPCODE_EXP_DIST_MS", "The parameters of the exponential distribution."), 2419 NC_("SC_OPCODE_EXP_DIST_MS", "C"), 2420 NC_("SC_OPCODE_EXP_DIST_MS", "Cumulated. C=0 calculates the density function, C=1 the distribution.") 2421}; 2422 2423// -=*# Resource for function GAMMADIST #*=- 2424const char* SC_OPCODE_GAMMA_DIST_ARY[] = 2425{ 2426 NC_("SC_OPCODE_GAMMA_DIST", "Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution."), 2427 NC_("SC_OPCODE_GAMMA_DIST", "Number"), 2428 NC_("SC_OPCODE_GAMMA_DIST", "The value for which the gamma distribution is to be calculated."), 2429 NC_("SC_OPCODE_GAMMA_DIST", "Alpha"), 2430 NC_("SC_OPCODE_GAMMA_DIST", "The Alpha parameter of the Gamma distribution."), 2431 NC_("SC_OPCODE_GAMMA_DIST", "Beta"), 2432 NC_("SC_OPCODE_GAMMA_DIST", "The Beta parameter of the Gamma distribution."), 2433 NC_("SC_OPCODE_GAMMA_DIST", "Cumulative"), 2434 NC_("SC_OPCODE_GAMMA_DIST", "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function.") 2435}; 2436 2437// -=*# Resource for function GAMMA.DIST #*=- 2438const char* SC_OPCODE_GAMMA_DIST_MS_ARY[] = 2439{ 2440 NC_("SC_OPCODE_GAMMA_DIST_MS", "Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution."), 2441 NC_("SC_OPCODE_GAMMA_DIST_MS", "Number"), 2442 NC_("SC_OPCODE_GAMMA_DIST_MS", "The value for which the gamma distribution is to be calculated."), 2443 NC_("SC_OPCODE_GAMMA_DIST_MS", "Alpha"), 2444 NC_("SC_OPCODE_GAMMA_DIST_MS", "The Alpha parameter of the Gamma distribution."), 2445 NC_("SC_OPCODE_GAMMA_DIST_MS", "Beta"), 2446 NC_("SC_OPCODE_GAMMA_DIST_MS", "The Beta parameter of the Gamma distribution."), 2447 NC_("SC_OPCODE_GAMMA_DIST_MS", "Cumulative"), 2448 NC_("SC_OPCODE_GAMMA_DIST_MS", "0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function.") 2449}; 2450 2451// -=*# Resource for function GAMMAINV #*=- 2452const char* SC_OPCODE_GAMMA_INV_ARY[] = 2453{ 2454 NC_("SC_OPCODE_GAMMA_INV", "Values of the inverse gamma distribution."), 2455 NC_("SC_OPCODE_GAMMA_INV", "Number"), 2456 NC_("SC_OPCODE_GAMMA_INV", "The probability value for which the inverse gamma distribution is to be calculated."), 2457 NC_("SC_OPCODE_GAMMA_INV", "Alpha"), 2458 NC_("SC_OPCODE_GAMMA_INV", "The Alpha (shape) parameter of the Gamma distribution."), 2459 NC_("SC_OPCODE_GAMMA_INV", "Beta"), 2460 NC_("SC_OPCODE_GAMMA_INV", "The Beta (scale) parameter of the Gamma distribution.") 2461}; 2462 2463// -=*# Resource for function GAMMA.INV #*=- 2464const char* SC_OPCODE_GAMMA_INV_MS_ARY[] = 2465{ 2466 NC_("SC_OPCODE_GAMMA_INV_MS", "Values of the inverse gamma distribution."), 2467 NC_("SC_OPCODE_GAMMA_INV_MS", "Number"), 2468 NC_("SC_OPCODE_GAMMA_INV_MS", "The probability value for which the inverse gamma distribution is to be calculated."), 2469 NC_("SC_OPCODE_GAMMA_INV_MS", "Alpha"), 2470 NC_("SC_OPCODE_GAMMA_INV_MS", "The Alpha (shape) parameter of the Gamma distribution."), 2471 NC_("SC_OPCODE_GAMMA_INV_MS", "Beta"), 2472 NC_("SC_OPCODE_GAMMA_INV_MS", "The Beta (scale) parameter of the Gamma distribution.") 2473}; 2474 2475// -=*# Resource for function GAMMALN #*=- 2476const char* SC_OPCODE_GAMMA_LN_ARY[] = 2477{ 2478 NC_("SC_OPCODE_GAMMA_LN", "Returns the natural logarithm of the gamma function."), 2479 NC_("SC_OPCODE_GAMMA_LN", "Number"), 2480 NC_("SC_OPCODE_GAMMA_LN", "The value for which the natural logarithm of the gamma function is to be calculated.") 2481}; 2482 2483// -=*# Resource for function GAMMALN.PRECISE #*=- 2484const char* SC_OPCODE_GAMMA_LN_MS_ARY[] = 2485{ 2486 NC_("SC_OPCODE_GAMMA_LN_MS", "Returns the natural logarithm of the gamma function."), 2487 NC_("SC_OPCODE_GAMMA_LN_MS", "Number"), 2488 NC_("SC_OPCODE_GAMMA_LN_MS", "The value for which the natural logarithm of the gamma function is to be calculated.") 2489}; 2490 2491 2492// -=*# Resource for function GAMMA #*=- 2493const char* SC_OPCODE_GAMMA_ARY[] = 2494{ 2495 NC_("SC_OPCODE_GAMMA", "Returns the value of the Gamma function."), 2496 NC_("SC_OPCODE_GAMMA", "Number"), 2497 NC_("SC_OPCODE_GAMMA", "The value for which the Gamma function is to be calculated.") 2498}; 2499 2500 2501// -=*# Resource for function BETADIST #*=- 2502const char* SC_OPCODE_BETA_DIST_ARY[] = 2503{ 2504 NC_("SC_OPCODE_BETA_DIST", "Values of the beta distribution."), 2505 NC_("SC_OPCODE_BETA_DIST", "Number"), 2506 NC_("SC_OPCODE_BETA_DIST", "The value for which the beta distribution is to be calculated."), 2507 NC_("SC_OPCODE_BETA_DIST", "Alpha"), 2508 NC_("SC_OPCODE_BETA_DIST", "The Alpha parameter of the Beta distribution."), 2509 NC_("SC_OPCODE_BETA_DIST", "Beta"), 2510 NC_("SC_OPCODE_BETA_DIST", "The Beta parameter of the Beta distribution."), 2511 NC_("SC_OPCODE_BETA_DIST", "Start"), 2512 NC_("SC_OPCODE_BETA_DIST", "The starting value for the value interval of the distribution."), 2513 NC_("SC_OPCODE_BETA_DIST", "End"), 2514 NC_("SC_OPCODE_BETA_DIST", "The final value for the value interval of the distribution."), 2515 NC_("SC_OPCODE_BETA_DIST", "Cumulative"), 2516 NC_("SC_OPCODE_BETA_DIST", "0 or FALSE for probability density function, any other value or TRUE or omitted for cumulative distribution function.") 2517}; 2518 2519// -=*# Resource for function BETAINV #*=- 2520const char* SC_OPCODE_BETA_INV_ARY[] = 2521{ 2522 NC_("SC_OPCODE_BETA_INV", "Values of the inverse beta distribution."), 2523 NC_("SC_OPCODE_BETA_INV", "Number"), 2524 NC_("SC_OPCODE_BETA_INV", "The probability value for which the inverse beta distribution is to be calculated."), 2525 NC_("SC_OPCODE_BETA_INV", "Alpha"), 2526 NC_("SC_OPCODE_BETA_INV", "The Alpha parameter of the Beta distribution."), 2527 NC_("SC_OPCODE_BETA_INV", "Beta"), 2528 NC_("SC_OPCODE_BETA_INV", "The Beta parameter of the Beta distribution."), 2529 NC_("SC_OPCODE_BETA_INV", "Start"), 2530 NC_("SC_OPCODE_BETA_INV", "The starting value for the value interval of the distribution."), 2531 NC_("SC_OPCODE_BETA_INV", "End"), 2532 NC_("SC_OPCODE_BETA_INV", "The final value for the value interval of the distribution.") 2533}; 2534 2535// -=*# Resource for function BETA.DIST #*=- 2536const char* SC_OPCODE_BETA_DIST_MS_ARY[] = 2537{ 2538 NC_("SC_OPCODE_BETA_DIST_MS", "Values of the beta distribution."), 2539 NC_("SC_OPCODE_BETA_DIST_MS", "Number"), 2540 NC_("SC_OPCODE_BETA_DIST_MS", "The value for which the beta distribution is to be calculated."), 2541 NC_("SC_OPCODE_BETA_DIST_MS", "Alpha"), 2542 NC_("SC_OPCODE_BETA_DIST_MS", "The Alpha parameter of the Beta distribution."), 2543 NC_("SC_OPCODE_BETA_DIST_MS", "Beta"), 2544 NC_("SC_OPCODE_BETA_DIST_MS", "The Beta parameter of the Beta distribution."), 2545 NC_("SC_OPCODE_BETA_DIST_MS", "Cumulative"), 2546 NC_("SC_OPCODE_BETA_DIST_MS", "0 or FALSE for probability density function, any other value or TRUE or omitted for cumulative distribution function."), 2547 NC_("SC_OPCODE_BETA_DIST_MS", "Start"), 2548 NC_("SC_OPCODE_BETA_DIST_MS", "The starting value for the value interval of the distribution."), 2549 NC_("SC_OPCODE_BETA_DIST_MS", "End"), 2550 NC_("SC_OPCODE_BETA_DIST_MS", "The final value for the value interval of the distribution.") 2551}; 2552 2553// -=*# Resource for function BETA.INV #*=- 2554const char* SC_OPCODE_BETA_INV_MS_ARY[] = 2555{ 2556 NC_("SC_OPCODE_BETA_INV_MS", "Values of the inverse beta distribution."), 2557 NC_("SC_OPCODE_BETA_INV_MS", "Number"), 2558 NC_("SC_OPCODE_BETA_INV_MS", "The probability value for which the inverse beta distribution is to be calculated."), 2559 NC_("SC_OPCODE_BETA_INV_MS", "Alpha"), 2560 NC_("SC_OPCODE_BETA_INV_MS", "The Alpha parameter of the Beta distribution."), 2561 NC_("SC_OPCODE_BETA_INV_MS", "Beta"), 2562 NC_("SC_OPCODE_BETA_INV_MS", "The Beta parameter of the Beta distribution."), 2563 NC_("SC_OPCODE_BETA_INV_MS", "Start"), 2564 NC_("SC_OPCODE_BETA_INV_MS", "The starting value for the value interval of the distribution."), 2565 NC_("SC_OPCODE_BETA_INV_MS", "End"), 2566 NC_("SC_OPCODE_BETA_INV_MS", "The final value for the value interval of the distribution.") 2567}; 2568 2569// -=*# Resource for function WEIBULL #*=- 2570const char* SC_OPCODE_WEIBULL_ARY[] = 2571{ 2572 NC_("SC_OPCODE_WEIBULL", "Returns the values of the Weibull distribution."), 2573 NC_("SC_OPCODE_WEIBULL", "Number"), 2574 NC_("SC_OPCODE_WEIBULL", "The value for which the Weibull distribution is to be calculated."), 2575 NC_("SC_OPCODE_WEIBULL", "Alpha"), 2576 NC_("SC_OPCODE_WEIBULL", "The Alpha parameter of the Weibull distribution."), 2577 NC_("SC_OPCODE_WEIBULL", "Beta"), 2578 NC_("SC_OPCODE_WEIBULL", "The Beta parameter of the Weibull distribution."), 2579 NC_("SC_OPCODE_WEIBULL", "C"), 2580 NC_("SC_OPCODE_WEIBULL", "Cumulated. C=0 calculates the density function, C=1 the distribution.") 2581}; 2582 2583// -=*# Resource for function WEIBULL.DIST #*=- 2584const char* SC_OPCODE_WEIBULL_MS_ARY[] = 2585{ 2586 NC_("SC_OPCODE_WEIBULL_MS", "Returns the values of the Weibull distribution."), 2587 NC_("SC_OPCODE_WEIBULL_MS", "Number"), 2588 NC_("SC_OPCODE_WEIBULL_MS", "The value for which the Weibull distribution is to be calculated."), 2589 NC_("SC_OPCODE_WEIBULL_MS", "Alpha"), 2590 NC_("SC_OPCODE_WEIBULL_MS", "The Alpha parameter of the Weibull distribution."), 2591 NC_("SC_OPCODE_WEIBULL_MS", "Beta"), 2592 NC_("SC_OPCODE_WEIBULL_MS", "The Beta parameter of the Weibull distribution."), 2593 NC_("SC_OPCODE_WEIBULL_MS", "C"), 2594 NC_("SC_OPCODE_WEIBULL_MS", "Cumulated. C=0 calculates the density function, C=1 the distribution.") 2595}; 2596 2597// -=*# Resource for function HYPGEOMDIST #*=- 2598const char* SC_OPCODE_HYP_GEOM_DIST_ARY[] = 2599{ 2600 NC_("SC_OPCODE_HYP_GEOM_DIST", "Values of the hypergeometric distribution."), 2601 NC_("SC_OPCODE_HYP_GEOM_DIST", "X"), 2602 NC_("SC_OPCODE_HYP_GEOM_DIST", "The number of successes in the sample."), 2603 NC_("SC_OPCODE_HYP_GEOM_DIST", "N sample"), 2604 NC_("SC_OPCODE_HYP_GEOM_DIST", "The size of the sample."), 2605 NC_("SC_OPCODE_HYP_GEOM_DIST", "Successes"), 2606 NC_("SC_OPCODE_HYP_GEOM_DIST", "The number of successes in the population."), 2607 NC_("SC_OPCODE_HYP_GEOM_DIST", "N population"), 2608 NC_("SC_OPCODE_HYP_GEOM_DIST", "The population size."), 2609 NC_("SC_OPCODE_HYP_GEOM_DIST", "Cumulative"), 2610 NC_("SC_OPCODE_HYP_GEOM_DIST", "Cumulated. TRUE calculates the cumulative distribution function, FALSE the probability mass function.") 2611}; 2612 2613// -=*# Resource for function HYPGEOM.DIST #*=- 2614const char* SC_OPCODE_HYP_GEOM_DIST_MS_ARY[] = 2615{ 2616 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "Values of the hypergeometric distribution."), 2617 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "X"), 2618 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "The number of successes in the sample."), 2619 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "N sample"), 2620 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "The size of the sample."), 2621 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "Successes"), 2622 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "The number of successes in the population."), 2623 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "N population"), 2624 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "The population size."), 2625 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "Cumulative"), 2626 NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "Cumulated. TRUE calculates the cumulative distribution function, FALSE the probability mass function.") 2627}; 2628 2629// -=*# Resource for function TDIST #*=- 2630const char* SC_OPCODE_T_DIST_ARY[] = 2631{ 2632 NC_("SC_OPCODE_T_DIST", "Returns the t-distribution."), 2633 NC_("SC_OPCODE_T_DIST", "Number"), 2634 NC_("SC_OPCODE_T_DIST", "The value for which the T distribution is to be calculated."), 2635 NC_("SC_OPCODE_T_DIST", "Degrees freedom"), 2636 NC_("SC_OPCODE_T_DIST", "The degrees of freedom of the T distribution."), 2637 NC_("SC_OPCODE_T_DIST", "Mode"), 2638 NC_("SC_OPCODE_T_DIST", "Mode = 1 calculates the one-tailed test, 2 = two-tailed distribution.") 2639}; 2640 2641// -=*# Resource for function T.DIST.2T #*=- 2642const char* SC_OPCODE_T_DIST_2T_ARY[] = 2643{ 2644 NC_("SC_OPCODE_T_DIST_2T", "Returns the two-tailed t-distribution."), 2645 NC_("SC_OPCODE_T_DIST_2T", "Number"), 2646 NC_("SC_OPCODE_T_DIST_2T", "The value for which the T distribution is to be calculated."), 2647 NC_("SC_OPCODE_T_DIST_2T", "Degrees freedom"), 2648 NC_("SC_OPCODE_T_DIST_2T", "The degrees of freedom of the T distribution.") 2649}; 2650 2651// -=*# Resource for function T.DIST #*=- 2652const char* SC_OPCODE_T_DIST_MS_ARY[] = 2653{ 2654 NC_("SC_OPCODE_T_DIST_MS", "Returns the t-distribution."), 2655 NC_("SC_OPCODE_T_DIST_MS", "Number"), 2656 NC_("SC_OPCODE_T_DIST_MS", "The value for which the T distribution is to be calculated."), 2657 NC_("SC_OPCODE_T_DIST_MS", "Degrees freedom"), 2658 NC_("SC_OPCODE_T_DIST_MS", "The degrees of freedom of the T distribution."), 2659 NC_("SC_OPCODE_T_DIST_MS", "Cumulative"), 2660 NC_("SC_OPCODE_T_DIST_MS", "True calculates the cumulative distribution function, false the probability density function.") 2661}; 2662 2663// -=*# Resource for function T.DIST.RT #*=- 2664const char* SC_OPCODE_T_DIST_RT_ARY[] = 2665{ 2666 NC_("SC_OPCODE_T_DIST_RT", "Returns the right-tailed t-distribution."), 2667 NC_("SC_OPCODE_T_DIST_RT", "Number"), 2668 NC_("SC_OPCODE_T_DIST_RT", "The value for which the T distribution is to be calculated."), 2669 NC_("SC_OPCODE_T_DIST_RT", "Degrees freedom"), 2670 NC_("SC_OPCODE_T_DIST_RT", "The degrees of freedom of the T distribution.") 2671}; 2672 2673// -=*# Resource for function TINV #*=- 2674const char* SC_OPCODE_T_INV_ARY[] = 2675{ 2676 NC_("SC_OPCODE_T_INV", "Values of the inverse t-distribution."), 2677 NC_("SC_OPCODE_T_INV", "Number"), 2678 NC_("SC_OPCODE_T_INV", "The probability value for which the inverse T distribution is to be calculated."), 2679 NC_("SC_OPCODE_T_INV", "Degrees freedom"), 2680 NC_("SC_OPCODE_T_INV", "The degrees of freedom of the T distribution.") 2681}; 2682 2683// -=*# Resource for function T.INV #*=- 2684const char* SC_OPCODE_T_INV_MS_ARY[] = 2685{ 2686 NC_("SC_OPCODE_T_INV_MS", "Values of the left-tailed inverse t-distribution."), 2687 NC_("SC_OPCODE_T_INV_MS", "Number"), 2688 NC_("SC_OPCODE_T_INV_MS", "The probability value for which the inverse T distribution is to be calculated."), 2689 NC_("SC_OPCODE_T_INV_MS", "Degrees freedom"), 2690 NC_("SC_OPCODE_T_INV_MS", "The degrees of freedom of the T distribution.") 2691}; 2692 2693// -=*# Resource for function T.INV.2T #*=- 2694const char* SC_OPCODE_T_INV_2T_ARY[] = 2695{ 2696 NC_("SC_OPCODE_T_INV_2T", "Values of the two-tailed inverse t-distribution."), 2697 NC_("SC_OPCODE_T_INV_2T", "Number"), 2698 NC_("SC_OPCODE_T_INV_2T", "The probability value for which the inverse T distribution is to be calculated."), 2699 NC_("SC_OPCODE_T_INV_2T", "Degrees freedom"), 2700 NC_("SC_OPCODE_T_INV_2T", "The degrees of freedom of the T distribution.") 2701}; 2702 2703// -=*# Resource for function FDIST #*=- 2704const char* SC_OPCODE_F_DIST_ARY[] = 2705{ 2706 NC_("SC_OPCODE_F_DIST", "Values of the F probability distribution."), 2707 NC_("SC_OPCODE_F_DIST", "Number"), 2708 NC_("SC_OPCODE_F_DIST", "The value for which the F distribution is to be calculated."), 2709 NC_("SC_OPCODE_F_DIST", "Degrees freedom 1"), 2710 NC_("SC_OPCODE_F_DIST", "The degrees of freedom in the numerator of the F distribution."), 2711 NC_("SC_OPCODE_F_DIST", "Degrees freedom 2"), 2712 NC_("SC_OPCODE_F_DIST", "The degrees of freedom in the denominator of the F distribution.") 2713}; 2714 2715// -=*# Resource for function F.DIST #*=- 2716const char* SC_OPCODE_F_DIST_LT_ARY[] = 2717{ 2718 NC_("SC_OPCODE_F_DIST_LT", "Values of the left tail F probability distribution."), 2719 NC_("SC_OPCODE_F_DIST_LT", "Number"), 2720 NC_("SC_OPCODE_F_DIST_LT", "The value for which the F distribution is to be calculated."), 2721 NC_("SC_OPCODE_F_DIST_LT", "Degrees freedom 1"), 2722 NC_("SC_OPCODE_F_DIST_LT", "The degrees of freedom in the numerator of the F distribution."), 2723 NC_("SC_OPCODE_F_DIST_LT", "Degrees freedom 2"), 2724 NC_("SC_OPCODE_F_DIST_LT", "The degrees of freedom in the denominator of the F distribution."), 2725 NC_("SC_OPCODE_F_DIST_LT", "Cumulative"), 2726 NC_("SC_OPCODE_F_DIST_LT", "Cumulative distribution function (TRUE) or probability density function (FALSE).") 2727}; 2728 2729// -=*# Resource for function F.DIST.RT #*=- 2730const char* SC_OPCODE_F_DIST_RT_ARY[] = 2731{ 2732 NC_("SC_OPCODE_F_DIST_RT", "Values of the right tail F probability distribution."), 2733 NC_("SC_OPCODE_F_DIST_RT", "Number"), 2734 NC_("SC_OPCODE_F_DIST_RT", "The value for which the F distribution is to be calculated."), 2735 NC_("SC_OPCODE_F_DIST_RT", "Degrees freedom 1"), 2736 NC_("SC_OPCODE_F_DIST_RT", "The degrees of freedom in the numerator of the F distribution."), 2737 NC_("SC_OPCODE_F_DIST_RT", "Degrees freedom 2"), 2738 NC_("SC_OPCODE_F_DIST_RT", "The degrees of freedom in the denominator of the F distribution.") 2739}; 2740 2741// -=*# Resource for function FINV #*=- 2742const char* SC_OPCODE_F_INV_ARY[] = 2743{ 2744 NC_("SC_OPCODE_F_INV", "Values of the inverse F distribution."), 2745 NC_("SC_OPCODE_F_INV", "Number"), 2746 NC_("SC_OPCODE_F_INV", "The probability value for which the inverse F distribution is to be calculated."), 2747 NC_("SC_OPCODE_F_INV", "Degrees freedom 1"), 2748 NC_("SC_OPCODE_F_INV", "The degrees of freedom in the numerator of the F distribution."), 2749 NC_("SC_OPCODE_F_INV", "Degrees freedom 2"), 2750 NC_("SC_OPCODE_F_INV", "The degrees of freedom in the denominator of the F distribution.") 2751}; 2752 2753// -=*# Resource for function F.INV #*=- 2754const char* SC_OPCODE_F_INV_LT_ARY[] = 2755{ 2756 NC_("SC_OPCODE_F_INV_LT", "Values of the inverse left tail F distribution."), 2757 NC_("SC_OPCODE_F_INV_LT", "Number"), 2758 NC_("SC_OPCODE_F_INV_LT", "The probability value for which the inverse F distribution is to be calculated."), 2759 NC_("SC_OPCODE_F_INV_LT", "Degrees freedom 1"), 2760 NC_("SC_OPCODE_F_INV_LT", "The degrees of freedom in the numerator of the F distribution."), 2761 NC_("SC_OPCODE_F_INV_LT", "Degrees freedom 2"), 2762 NC_("SC_OPCODE_F_INV_LT", "The degrees of freedom in the denominator of the F distribution.") 2763}; 2764 2765// -=*# Resource for function F.INV.RT #*=- 2766const char* SC_OPCODE_F_INV_RT_ARY[] = 2767{ 2768 NC_("SC_OPCODE_F_INV_RT", "Values of the inverse right tail F distribution."), 2769 NC_("SC_OPCODE_F_INV_RT", "Number"), 2770 NC_("SC_OPCODE_F_INV_RT", "The probability value for which the inverse F distribution is to be calculated."), 2771 NC_("SC_OPCODE_F_INV_RT", "Degrees freedom 1"), 2772 NC_("SC_OPCODE_F_INV_RT", "The degrees of freedom in the numerator of the F distribution."), 2773 NC_("SC_OPCODE_F_INV_RT", "Degrees freedom 2"), 2774 NC_("SC_OPCODE_F_INV_RT", "The degrees of freedom in the denominator of the F distribution.") 2775}; 2776 2777// -=*# Resource for function CHIDIST #*=- 2778const char* SC_OPCODE_CHI_DIST_ARY[] = 2779{ 2780 NC_("SC_OPCODE_CHI_DIST", "Returns the right-tail probability of the chi-square distribution."), 2781 NC_("SC_OPCODE_CHI_DIST", "Number"), 2782 NC_("SC_OPCODE_CHI_DIST", "The value for which the chi square distribution is to be calculated."), 2783 NC_("SC_OPCODE_CHI_DIST", "Degrees freedom"), 2784 NC_("SC_OPCODE_CHI_DIST", "The degrees of freedom of the chi square distribution.") 2785}; 2786 2787// -=*# Resource for function CHISQ.DIST.RT #*=- 2788const char* SC_OPCODE_CHI_DIST_MS_ARY[] = 2789{ 2790 NC_("SC_OPCODE_CHI_DIST_MS", "Returns the right-tail probability of the chi-square distribution."), 2791 NC_("SC_OPCODE_CHI_DIST_MS", "Number"), 2792 NC_("SC_OPCODE_CHI_DIST_MS", "The value for which the chi square distribution is to be calculated."), 2793 NC_("SC_OPCODE_CHI_DIST_MS", "Degrees freedom"), 2794 NC_("SC_OPCODE_CHI_DIST_MS", "The degrees of freedom of the chi square distribution.") 2795}; 2796 2797 2798// -=*# Resource for function CHISQDIST #*=- 2799const char* SC_OPCODE_CHISQ_DIST_ARY[] = 2800{ 2801 NC_("SC_OPCODE_CHISQ_DIST", "Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution."), 2802 NC_("SC_OPCODE_CHISQ_DIST", "Number"), 2803 NC_("SC_OPCODE_CHISQ_DIST", "The value for which the probability density function or cumulative distribution function is to be calculated."), 2804 NC_("SC_OPCODE_CHISQ_DIST", "Degrees of Freedom"), 2805 NC_("SC_OPCODE_CHISQ_DIST", "The degrees of freedom of the chi-square distribution."), 2806 NC_("SC_OPCODE_CHISQ_DIST", "Cumulative"), 2807 NC_("SC_OPCODE_CHISQ_DIST", "0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function.") 2808}; 2809 2810 2811// -=*# Resource for function CHISQ.DIST #*=- 2812const char* SC_OPCODE_CHISQ_DIST_MS_ARY[] = 2813{ 2814 NC_("SC_OPCODE_CHISQ_DIST_MS", "Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution."), 2815 NC_("SC_OPCODE_CHISQ_DIST_MS", "Number"), 2816 NC_("SC_OPCODE_CHISQ_DIST_MS", "The value for which the probability density function or cumulative distribution function is to be calculated."), 2817 NC_("SC_OPCODE_CHISQ_DIST_MS", "Degrees of Freedom"), 2818 NC_("SC_OPCODE_CHISQ_DIST_MS", "The degrees of freedom of the chi-square distribution."), 2819 NC_("SC_OPCODE_CHISQ_DIST_MS", "Cumulative"), 2820 NC_("SC_OPCODE_CHISQ_DIST_MS", "0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function.") 2821}; 2822 2823 2824// -=*# Resource for function CHIINV #*=- 2825const char* SC_OPCODE_CHI_INV_ARY[] = 2826{ 2827 NC_("SC_OPCODE_CHI_INV", "Values of the inverse of CHIDIST(x; DegreesOfFreedom)."), 2828 NC_("SC_OPCODE_CHI_INV", "Number"), 2829 NC_("SC_OPCODE_CHI_INV", "The probability value for which the inverse chi square distribution is to be calculated."), 2830 NC_("SC_OPCODE_CHI_INV", "Degrees freedom"), 2831 NC_("SC_OPCODE_CHI_INV", "The degrees of freedom of the chi square distribution.") 2832}; 2833 2834 2835// -=*# Resource for function CHISQ.INV.RT #*=- 2836const char* SC_OPCODE_CHI_INV_MS_ARY[] = 2837{ 2838 NC_("SC_OPCODE_CHI_INV_MS", "Values of the inverse of CHIDIST(x; DegreesOfFreedom)."), 2839 NC_("SC_OPCODE_CHI_INV_MS", "Number"), 2840 NC_("SC_OPCODE_CHI_INV_MS", "The probability value for which the inverse chi square distribution is to be calculated."), 2841 NC_("SC_OPCODE_CHI_INV_MS", "Degrees freedom"), 2842 NC_("SC_OPCODE_CHI_INV_MS", "The degrees of freedom of the chi square distribution.") 2843}; 2844 2845 2846// -=*# Resource for function CHISQINV #*=- 2847const char* SC_OPCODE_CHISQ_INV_ARY[] = 2848{ 2849 NC_("SC_OPCODE_CHISQ_INV", "Values of the inverse of CHISQDIST(x;DegreesOfFreedom;TRUE())."), 2850 NC_("SC_OPCODE_CHISQ_INV", "Probability"), 2851 NC_("SC_OPCODE_CHISQ_INV", "The probability value for which the inverse of the chi square distribution is to be calculated."), 2852 NC_("SC_OPCODE_CHISQ_INV", "Degrees of Freedom"), 2853 NC_("SC_OPCODE_CHISQ_INV", "The degrees of freedom of the chi square distribution.") 2854}; 2855 2856 2857// -=*# Resource for function CHISQ.INV #*=- 2858const char* SC_OPCODE_CHISQ_INV_MS_ARY[] = 2859{ 2860 NC_("SC_OPCODE_CHISQ_INV_MS", "Values of the inverse of CHISQ.DIST(x;DegreesOfFreedom;TRUE())."), 2861 NC_("SC_OPCODE_CHISQ_INV_MS", "Probability"), 2862 NC_("SC_OPCODE_CHISQ_INV_MS", "The probability value for which the inverse of the chi square distribution is to be calculated."), 2863 NC_("SC_OPCODE_CHISQ_INV_MS", "Degrees of Freedom"), 2864 NC_("SC_OPCODE_CHISQ_INV_MS", "The degrees of freedom of the chi square distribution.") 2865}; 2866 2867 2868// -=*# Resource for function STANDARDIZE #*=- 2869const char* SC_OPCODE_STANDARD_ARY[] = 2870{ 2871 NC_("SC_OPCODE_STANDARD", "Converts a random variable to a normalized value."), 2872 NC_("SC_OPCODE_STANDARD", "Number"), 2873 NC_("SC_OPCODE_STANDARD", "The value to be standardized."), 2874 NC_("SC_OPCODE_STANDARD", "Mean"), 2875 NC_("SC_OPCODE_STANDARD", "The mean value used for moving."), 2876 NC_("SC_OPCODE_STANDARD", "STDEV"), 2877 NC_("SC_OPCODE_STANDARD", "The standard deviation used for scaling.") 2878}; 2879 2880// -=*# Resource for function PERMUT #*=- 2881const char* SC_OPCODE_PERMUT_ARY[] = 2882{ 2883 NC_("SC_OPCODE_PERMUT", "Returns the number of permutations for a given number of elements without repetition."), 2884 NC_("SC_OPCODE_PERMUT", "Count 1"), 2885 NC_("SC_OPCODE_PERMUT", "The total number of elements."), 2886 NC_("SC_OPCODE_PERMUT", "Count 2"), 2887 NC_("SC_OPCODE_PERMUT", "The selection number taken from the elements.") 2888}; 2889 2890// -=*# Resource for function PERMUTATIONA #*=- 2891const char* SC_OPCODE_PERMUTATION_A_ARY[] = 2892{ 2893 NC_("SC_OPCODE_PERMUTATION_A", "Returns the number of permutations for a given number of objects (repetition allowed)."), 2894 NC_("SC_OPCODE_PERMUTATION_A", "Count 1"), 2895 NC_("SC_OPCODE_PERMUTATION_A", "The total number of elements."), 2896 NC_("SC_OPCODE_PERMUTATION_A", "Count 2"), 2897 NC_("SC_OPCODE_PERMUTATION_A", "The selection number taken from the elements.") 2898}; 2899 2900// -=*# Resource for function CONFIDENCE #*=- 2901const char* SC_OPCODE_CONFIDENCE_ARY[] = 2902{ 2903 NC_("SC_OPCODE_CONFIDENCE", "Returns a (1-alpha) confidence interval for a normal distribution."), 2904 NC_("SC_OPCODE_CONFIDENCE", "Alpha"), 2905 NC_("SC_OPCODE_CONFIDENCE", "The level of the confidence interval."), 2906 NC_("SC_OPCODE_CONFIDENCE", "STDEV"), 2907 NC_("SC_OPCODE_CONFIDENCE", "The standard deviation of the population."), 2908 NC_("SC_OPCODE_CONFIDENCE", "Size"), 2909 NC_("SC_OPCODE_CONFIDENCE", "The size of the population.") 2910}; 2911 2912// -=*# Resource for function CONFIDENCE.NORM #*=- 2913const char* SC_OPCODE_CONFIDENCE_N_ARY[] = 2914{ 2915 NC_("SC_OPCODE_CONFIDENCE_N", "Returns a (1-alpha) confidence interval for a normal distribution."), 2916 NC_("SC_OPCODE_CONFIDENCE_N", "Alpha"), 2917 NC_("SC_OPCODE_CONFIDENCE_N", "The level of the confidence interval."), 2918 NC_("SC_OPCODE_CONFIDENCE_N", "STDEV"), 2919 NC_("SC_OPCODE_CONFIDENCE_N", "The standard deviation of the population."), 2920 NC_("SC_OPCODE_CONFIDENCE_N", "Size"), 2921 NC_("SC_OPCODE_CONFIDENCE_N", "The size of the population.") 2922}; 2923 2924// -=*# Resource for function CONFIDENCE.T #*=- 2925const char* SC_OPCODE_CONFIDENCE_T_ARY[] = 2926{ 2927 NC_("SC_OPCODE_CONFIDENCE_T", "Returns a (1-alpha) confidence interval for a Student's t distribution."), 2928 NC_("SC_OPCODE_CONFIDENCE_T", "Alpha"), 2929 NC_("SC_OPCODE_CONFIDENCE_T", "The level of the confidence interval."), 2930 NC_("SC_OPCODE_CONFIDENCE_T", "STDEV"), 2931 NC_("SC_OPCODE_CONFIDENCE_T", "The standard deviation of the population."), 2932 NC_("SC_OPCODE_CONFIDENCE_T", "Size"), 2933 NC_("SC_OPCODE_CONFIDENCE_T", "The size of the population.") 2934}; 2935 2936// -=*# Resource for function ZTEST #*=- 2937const char* SC_OPCODE_Z_TEST_ARY[] = 2938{ 2939 NC_("SC_OPCODE_Z_TEST", "Calculates the probability of observing a z-statistic greater than the one computed based on a sample."), 2940 NC_("SC_OPCODE_Z_TEST", "Data"), 2941 NC_("SC_OPCODE_Z_TEST", "The given sample, drawn from a normally distributed population."), 2942 NC_("SC_OPCODE_Z_TEST", "mu"), 2943 NC_("SC_OPCODE_Z_TEST", "The known mean of the population."), 2944 NC_("SC_OPCODE_Z_TEST", "sigma"), 2945 NC_("SC_OPCODE_Z_TEST", "The known standard deviation of the population. If omitted, the standard deviation of the given sample is used.") 2946}; 2947 2948// -=*# Resource for function Z.TEST #*=- 2949const char* SC_OPCODE_Z_TEST_MS_ARY[] = 2950{ 2951 NC_("SC_OPCODE_Z_TEST_MS", "Calculates the probability of observing a z-statistic greater than the one computed based on a sample."), 2952 NC_("SC_OPCODE_Z_TEST_MS", "Data"), 2953 NC_("SC_OPCODE_Z_TEST_MS", "The given sample, drawn from a normally distributed population."), 2954 NC_("SC_OPCODE_Z_TEST_MS", "mu"), 2955 NC_("SC_OPCODE_Z_TEST_MS", "The known mean of the population."), 2956 NC_("SC_OPCODE_Z_TEST_MS", "sigma"), 2957 NC_("SC_OPCODE_Z_TEST_MS", "The known standard deviation of the population. If omitted, the standard deviation of the given sample is used.") 2958}; 2959 2960// -=*# Resource for function CHITEST #*=- 2961const char* SC_OPCODE_CHI_TEST_ARY[] = 2962{ 2963 NC_("SC_OPCODE_CHI_TEST", "Returns the chi square independence test."), 2964 NC_("SC_OPCODE_CHI_TEST", "Data B"), 2965 NC_("SC_OPCODE_CHI_TEST", "The observed data array."), 2966 NC_("SC_OPCODE_CHI_TEST", "Data E"), 2967 NC_("SC_OPCODE_CHI_TEST", "The expected data array.") 2968}; 2969 2970// -=*# Resource for function CHISQ.TEST #*=- 2971const char* SC_OPCODE_CHI_TEST_MS_ARY[] = 2972{ 2973 NC_("SC_OPCODE_CHI_TEST_MS", "Returns the chi square independence test."), 2974 NC_("SC_OPCODE_CHI_TEST_MS", "Data B"), 2975 NC_("SC_OPCODE_CHI_TEST_MS", "The observed data array."), 2976 NC_("SC_OPCODE_CHI_TEST_MS", "Data E"), 2977 NC_("SC_OPCODE_CHI_TEST_MS", "The expected data array.") 2978}; 2979 2980// -=*# Resource for function FTEST #*=- 2981const char* SC_OPCODE_F_TEST_ARY[] = 2982{ 2983 NC_("SC_OPCODE_F_TEST", "Calculates the F test."), 2984 NC_("SC_OPCODE_F_TEST", "Data 1"), 2985 NC_("SC_OPCODE_F_TEST", "The first record array."), 2986 NC_("SC_OPCODE_F_TEST", "Data 2"), 2987 NC_("SC_OPCODE_F_TEST", "The second record array.") 2988}; 2989 2990// -=*# Resource for function F.TEST #*=- 2991const char* SC_OPCODE_F_TEST_MS_ARY[] = 2992{ 2993 NC_("SC_OPCODE_F_TEST_MS", "Calculates the F test."), 2994 NC_("SC_OPCODE_F_TEST_MS", "Data 1"), 2995 NC_("SC_OPCODE_F_TEST_MS", "The first record array."), 2996 NC_("SC_OPCODE_F_TEST_MS", "Data 2"), 2997 NC_("SC_OPCODE_F_TEST_MS", "The second record array.") 2998}; 2999 3000// -=*# Resource for function TTEST #*=- 3001const char* SC_OPCODE_T_TEST_ARY[] = 3002{ 3003 NC_("SC_OPCODE_T_TEST", "Calculates the T test."), 3004 NC_("SC_OPCODE_T_TEST", "Data 1"), 3005 NC_("SC_OPCODE_T_TEST", "The first record array."), 3006 NC_("SC_OPCODE_T_TEST", "Data 2"), 3007 NC_("SC_OPCODE_T_TEST", "The second record array."), 3008 NC_("SC_OPCODE_T_TEST", "Mode"), 3009 NC_("SC_OPCODE_T_TEST", "Mode specifies the number of distribution tails to return. 1 = one-tailed, 2 = two-tailed distribution"), 3010 NC_("SC_OPCODE_T_TEST", "Type"), 3011 NC_("SC_OPCODE_T_TEST", "The type of the T test.") 3012}; 3013 3014// -=*# Resource for function T.TEST #*=- 3015const char* SC_OPCODE_T_TEST_MS_ARY[] = 3016{ 3017 NC_("SC_OPCODE_T_TEST_MS", "Calculates the T test."), 3018 NC_("SC_OPCODE_T_TEST_MS", "Data 1"), 3019 NC_("SC_OPCODE_T_TEST_MS", "The first record array."), 3020 NC_("SC_OPCODE_T_TEST_MS", "Data 2"), 3021 NC_("SC_OPCODE_T_TEST_MS", "The second record array."), 3022 NC_("SC_OPCODE_T_TEST_MS", "Mode"), 3023 NC_("SC_OPCODE_T_TEST_MS", "Mode specifies the number of distribution tails to return. 1 = one-tailed, 2 = two-tailed distribution"), 3024 NC_("SC_OPCODE_T_TEST_MS", "Type"), 3025 NC_("SC_OPCODE_T_TEST_MS", "The type of the T test.") 3026}; 3027 3028// -=*# Resource for function RSQ #*=- 3029const char* SC_OPCODE_RSQ_ARY[] = 3030{ 3031 NC_("SC_OPCODE_RSQ", "Returns the square of the Pearson product moment correlation coefficient."), 3032 NC_("SC_OPCODE_RSQ", "Data Y"), 3033 NC_("SC_OPCODE_RSQ", "The Y data array."), 3034 NC_("SC_OPCODE_RSQ", "Data X"), 3035 NC_("SC_OPCODE_RSQ", "The X data array.") 3036}; 3037 3038// -=*# Resource for function INTERCEPT #*=- 3039const char* SC_OPCODE_INTERCEPT_ARY[] = 3040{ 3041 NC_("SC_OPCODE_INTERCEPT", "Returns the intercept of the linear regression line and the Y axis."), 3042 NC_("SC_OPCODE_INTERCEPT", "Data Y"), 3043 NC_("SC_OPCODE_INTERCEPT", "The Y data array."), 3044 NC_("SC_OPCODE_INTERCEPT", "Data X"), 3045 NC_("SC_OPCODE_INTERCEPT", "The X data array.") 3046}; 3047 3048// -=*# Resource for function SLOPE #*=- 3049const char* SC_OPCODE_SLOPE_ARY[] = 3050{ 3051 NC_("SC_OPCODE_SLOPE", "Returns the slope of the linear regression line."), 3052 NC_("SC_OPCODE_SLOPE", "Data Y"), 3053 NC_("SC_OPCODE_SLOPE", "The Y data array."), 3054 NC_("SC_OPCODE_SLOPE", "Data X"), 3055 NC_("SC_OPCODE_SLOPE", "The X data array.") 3056}; 3057 3058// -=*# Resource for function STEYX #*=- 3059const char* SC_OPCODE_STEYX_ARY[] = 3060{ 3061 NC_("SC_OPCODE_STEYX", "Returns the standard error of the linear regression."), 3062 NC_("SC_OPCODE_STEYX", "Data Y"), 3063 NC_("SC_OPCODE_STEYX", "The Y data array."), 3064 NC_("SC_OPCODE_STEYX", "Data X"), 3065 NC_("SC_OPCODE_STEYX", "The X data array.") 3066}; 3067 3068// -=*# Resource for function PEARSON #*=- 3069const char* SC_OPCODE_PEARSON_ARY[] = 3070{ 3071 NC_("SC_OPCODE_PEARSON", "Returns the Pearson product moment correlation coefficient."), 3072 NC_("SC_OPCODE_PEARSON", "Data 1"), 3073 NC_("SC_OPCODE_PEARSON", "The first record array."), 3074 NC_("SC_OPCODE_PEARSON", "Data 2"), 3075 NC_("SC_OPCODE_PEARSON", "The second record array.") 3076}; 3077 3078// -=*# Resource for function CORREL #*=- 3079const char* SC_OPCODE_CORREL_ARY[] = 3080{ 3081 NC_("SC_OPCODE_CORREL", "Returns the correlation coefficient."), 3082 NC_("SC_OPCODE_CORREL", "Data 1"), 3083 NC_("SC_OPCODE_CORREL", "The first record array."), 3084 NC_("SC_OPCODE_CORREL", "Data 2"), 3085 NC_("SC_OPCODE_CORREL", "The second record array.") 3086}; 3087 3088// -=*# Resource for function COVAR #*=- 3089const char* SC_OPCODE_COVAR_ARY[] = 3090{ 3091 NC_("SC_OPCODE_COVAR", "Calculates the population covariance."), 3092 NC_("SC_OPCODE_COVAR", "Data 1"), 3093 NC_("SC_OPCODE_COVAR", "The first record array."), 3094 NC_("SC_OPCODE_COVAR", "Data 2"), 3095 NC_("SC_OPCODE_COVAR", "The second record array.") 3096}; 3097 3098// -=*# Resource for function COVARIANCE.P #*=- 3099const char* SC_OPCODE_COVARIANCE_P_ARY[] = 3100{ 3101 NC_("SC_OPCODE_COVARIANCE_P", "Calculates the population covariance."), 3102 NC_("SC_OPCODE_COVARIANCE_P", "Data 1"), 3103 NC_("SC_OPCODE_COVARIANCE_P", "The first record array."), 3104 NC_("SC_OPCODE_COVARIANCE_P", "Data 2"), 3105 NC_("SC_OPCODE_COVARIANCE_P", "The second record array.") 3106}; 3107 3108// -=*# Resource for function COVARIANCE.S #*=- 3109const char* SC_OPCODE_COVARIANCE_S_ARY[] = 3110{ 3111 NC_("SC_OPCODE_COVARIANCE_S", "Calculates the sample covariance."), 3112 NC_("SC_OPCODE_COVARIANCE_S", "Data 1"), 3113 NC_("SC_OPCODE_COVARIANCE_S", "The first record array."), 3114 NC_("SC_OPCODE_COVARIANCE_S", "Data 2"), 3115 NC_("SC_OPCODE_COVARIANCE_S", "The second record array.") 3116}; 3117 3118// -=*# Resource for function FORECAST #*=- 3119const char* SC_OPCODE_FORECAST_ARY[] = 3120{ 3121 NC_("SC_OPCODE_FORECAST", "Returns a value along a linear regression"), 3122 NC_("SC_OPCODE_FORECAST", "Value"), 3123 NC_("SC_OPCODE_FORECAST", "The X value for which the Y value on the regression linear is to be calculated."), 3124 NC_("SC_OPCODE_FORECAST", "Data Y"), 3125 NC_("SC_OPCODE_FORECAST", "The Y data array."), 3126 NC_("SC_OPCODE_FORECAST", "Data X"), 3127 NC_("SC_OPCODE_FORECAST", "The X data array.") 3128}; 3129 3130// -=*# Resource for function FORECAST.ETS #*=- 3131const char* SC_OPCODE_FORECAST_ETS_ADD_ARY[] = 3132{ 3133 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Calculates future value(s) using additive Exponential Smoothing algorithm."), 3134 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Target"), 3135 NC_("SC_OPCODE_FORECAST_ETS_ADD", "The date (array) for which you want to predict a value."), 3136 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Values"), 3137 NC_("SC_OPCODE_FORECAST_ETS_ADD", "The data array from which you want to forecast."), 3138 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Timeline"), 3139 NC_("SC_OPCODE_FORECAST_ETS_ADD", "The date or numeric array; a consistent step between values is needed."), 3140 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Period length"), 3141 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Number of Samples in Period (default 1); length of the seasonal pattern."), 3142 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Data completion"), 3143 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Data completion (default 1); 0 treats missing points as zero, 1 interpolates."), 3144 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Aggregation"), 3145 NC_("SC_OPCODE_FORECAST_ETS_ADD", "Aggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values.") 3146}; 3147 3148// -=*# Resource for function FORECAST.ETS.MULT #*=- 3149const char* SC_OPCODE_FORECAST_ETS_MUL_ARY[] = 3150{ 3151 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Calculates future value(s) using multiplicative Exponential Smoothing algorithm."), 3152 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Target"), 3153 NC_("SC_OPCODE_FORECAST_ETS_MUL", "The date (array) for which you want to predict a value."), 3154 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Values"), 3155 NC_("SC_OPCODE_FORECAST_ETS_MUL", "The data array from which you want to forecast."), 3156 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Timeline"), 3157 NC_("SC_OPCODE_FORECAST_ETS_MUL", "The date or numeric array; a consistent step between values is needed."), 3158 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Period length"), 3159 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Number of Samples in Period (default 1); length of the seasonal pattern."), 3160 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Data completion"), 3161 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Data completion (default 1); 0 treats missing points as zero, 1 interpolates."), 3162 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Aggregation"), 3163 NC_("SC_OPCODE_FORECAST_ETS_MUL", "Aggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values.") 3164}; 3165 3166// -=*# Resource for function FORECAST.ETS.CONFINT #*=- 3167const char* SC_OPCODE_FORECAST_ETS_PIA_ARY[] = 3168{ 3169 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Returns a prediction interval at the specified target value(s) for additive Exponential Smoothing method"), 3170 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Target"), 3171 NC_("SC_OPCODE_FORECAST_ETS_PIA", "The date (array) for which you want to predict a value."), 3172 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Values"), 3173 NC_("SC_OPCODE_FORECAST_ETS_PIA", "The data array from which you want to forecast."), 3174 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Timeline"), 3175 NC_("SC_OPCODE_FORECAST_ETS_PIA", "The date or numeric array; a consistent step between values is needed."), 3176 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Confidence level"), 3177 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Confidence level (default 0.95); value 0 to 1 (exclusive) for 0 to 100% calculated prediction interval."), 3178 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Period length"), 3179 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Number of Samples in Period (default 1); length of the seasonal pattern."), 3180 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Data completion"), 3181 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Data completion (default 1); 0 treats missing points as zero, 1 interpolates."), 3182 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Aggregation"), 3183 NC_("SC_OPCODE_FORECAST_ETS_PIA", "Aggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values.") 3184}; 3185 3186// -=*# Resource for function FORECAST.ETS.PI.MULT #*=- 3187const char* SC_OPCODE_FORECAST_ETS_PIM_ARY[] = 3188{ 3189 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Returns a prediction interval at the specified target value(s) for multiplicative Exponential Smoothing method"), 3190 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Target"), 3191 NC_("SC_OPCODE_FORECAST_ETS_PIM", "The date (array) for which you want to predict a value."), 3192 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Values"), 3193 NC_("SC_OPCODE_FORECAST_ETS_PIM", "The data array from which you want to forecast."), 3194 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Timeline"), 3195 NC_("SC_OPCODE_FORECAST_ETS_PIM", "The date or numeric array; a consistent step between values is needed."), 3196 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Confidence level"), 3197 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Confidence level (default 0.95); value 0 to 1 (exclusive) for 0 to 100% calculated prediction interval."), 3198 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Period length"), 3199 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Number of Samples in Period (default 1); length of the seasonal pattern."), 3200 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Data completion"), 3201 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Data completion (default 1); 0 treats missing points as zero, 1 interpolates."), 3202 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Aggregation"), 3203 NC_("SC_OPCODE_FORECAST_ETS_PIM", "Aggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values.") 3204}; 3205 3206// -=*# Resource for function FORECAST.ETS.SEASONALITY #*=- 3207const char* SC_OPCODE_FORECAST_ETS_SEA_ARY[] = 3208{ 3209 NC_("SC_OPCODE_FORECAST_ETS_SEA", "Calculates the number of samples in period (season) using additive Exponential Triple Smoothing algorithm."), 3210 NC_("SC_OPCODE_FORECAST_ETS_SEA", "Values"), 3211 NC_("SC_OPCODE_FORECAST_ETS_SEA", "The data array from which you want to forecast."), 3212 NC_("SC_OPCODE_FORECAST_ETS_SEA", "Timeline"), 3213 NC_("SC_OPCODE_FORECAST_ETS_SEA", "The date or numeric array; a consistent step between values is needed."), 3214 NC_("SC_OPCODE_FORECAST_ETS_SEA", "Data completion"), 3215 NC_("SC_OPCODE_FORECAST_ETS_SEA", "Data completion (default 1); 0 treats missing points as zero, 1 interpolates."), 3216 NC_("SC_OPCODE_FORECAST_ETS_SEA", "Aggregation"), 3217 NC_("SC_OPCODE_FORECAST_ETS_SEA", "Aggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values.") 3218}; 3219 3220// -=*# Resource for function FORECAST.ETS.STAT #*=- 3221const char* SC_OPCODE_FORECAST_ETS_STA_ARY[] = 3222{ 3223 NC_("SC_OPCODE_FORECAST_ETS_STA", "Returns statistical value(s) using additive Exponential Smoothing algorithm."), 3224 NC_("SC_OPCODE_FORECAST_ETS_STA", "Values"), 3225 NC_("SC_OPCODE_FORECAST_ETS_STA", "The data array from which you want to forecast."), 3226 NC_("SC_OPCODE_FORECAST_ETS_STA", "Timeline"), 3227 NC_("SC_OPCODE_FORECAST_ETS_STA", "The date or numeric array; a consistent step between values is needed."), 3228 NC_("SC_OPCODE_FORECAST_ETS_STA", "Statistic type"), 3229 NC_("SC_OPCODE_FORECAST_ETS_STA", "Value (1-9) or array of values, indicating which statistic will be returned for the calculated forecast"), 3230 NC_("SC_OPCODE_FORECAST_ETS_STA", "Period length"), 3231 NC_("SC_OPCODE_FORECAST_ETS_STA", "Number of Samples in Period (default 1); length of the seasonal pattern."), 3232 NC_("SC_OPCODE_FORECAST_ETS_STA", "Data completion"), 3233 NC_("SC_OPCODE_FORECAST_ETS_STA", "Data completion (default 1); 0 treats missing points as zero, 1 interpolates."), 3234 NC_("SC_OPCODE_FORECAST_ETS_STA", "Aggregation"), 3235 NC_("SC_OPCODE_FORECAST_ETS_STA", "Aggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values.") 3236}; 3237 3238// -=*# Resource for function FORECAST.ETS.STAT.MULT #*=- 3239const char* SC_OPCODE_FORECAST_ETS_STM_ARY[] = 3240{ 3241 NC_("SC_OPCODE_FORECAST_ETS_STM", "Returns statistical value(s) using multiplicative Exponential Smoothing algorithm."), 3242 NC_("SC_OPCODE_FORECAST_ETS_STM", "Values"), 3243 NC_("SC_OPCODE_FORECAST_ETS_STM", "The data array from which you want to forecast."), 3244 NC_("SC_OPCODE_FORECAST_ETS_STM", "Timeline"), 3245 NC_("SC_OPCODE_FORECAST_ETS_STM", "The date or numeric array; a consistent step between values is needed."), 3246 NC_("SC_OPCODE_FORECAST_ETS_STM", "Statistic type"), 3247 NC_("SC_OPCODE_FORECAST_ETS_STM", "Value (1-9) or array of values, indicating which statistic will be returned for the calculated forecast"), 3248 NC_("SC_OPCODE_FORECAST_ETS_STM", "Period length"), 3249 NC_("SC_OPCODE_FORECAST_ETS_STM", "Number of samples in period (default 1); length of the seasonal pattern."), 3250 NC_("SC_OPCODE_FORECAST_ETS_STM", "Data completion"), 3251 NC_("SC_OPCODE_FORECAST_ETS_STM", "Data completion (default 1); 0 treats missing points as zero, 1 interpolates."), 3252 NC_("SC_OPCODE_FORECAST_ETS_STM", "Aggregation"), 3253 NC_("SC_OPCODE_FORECAST_ETS_STM", "Aggregation (default 1 = AVERAGE); method to be used to aggregate identical (time) values.") 3254}; 3255 3256// -=*# Resource for function FORECAST.LINEAR #*=- 3257const char* SC_OPCODE_FORECAST_LIN_ARY[] = 3258{ 3259 NC_("SC_OPCODE_FORECAST_LIN", "Returns a value along a linear regression"), 3260 NC_("SC_OPCODE_FORECAST_LIN", "Value"), 3261 NC_("SC_OPCODE_FORECAST_LIN", "The X value for which the Y value on the regression linear is to be calculated."), 3262 NC_("SC_OPCODE_FORECAST_LIN", "Data Y"), 3263 NC_("SC_OPCODE_FORECAST_LIN", "The Y data array."), 3264 NC_("SC_OPCODE_FORECAST_LIN", "Data X"), 3265 NC_("SC_OPCODE_FORECAST_LIN", "The X data array.") 3266}; 3267 3268// -=*# Resource for function ADDRESS #*=- 3269const char* SC_OPCODE_ADDRESS_ARY[] = 3270{ 3271 NC_("SC_OPCODE_ADDRESS", "Returns the reference to a cell as text."), 3272 NC_("SC_OPCODE_ADDRESS", "Row"), 3273 NC_("SC_OPCODE_ADDRESS", "The row number of the cell."), 3274 NC_("SC_OPCODE_ADDRESS", "Column"), 3275 NC_("SC_OPCODE_ADDRESS", "The column number of the cell."), 3276 NC_("SC_OPCODE_ADDRESS", "ABS"), 3277 NC_("SC_OPCODE_ADDRESS", "Specifies whether absolute or relative referencing is to be used."), 3278 NC_("SC_OPCODE_ADDRESS", "A1"), 3279 NC_("SC_OPCODE_ADDRESS", "The reference style: 0 or FALSE means R1C1 style, any other value or omitted means A1 style."), 3280 NC_("SC_OPCODE_ADDRESS", "Sheet"), 3281 NC_("SC_OPCODE_ADDRESS", "The spreadsheet name of the cell reference.") 3282}; 3283 3284// -=*# Resource for function AREAS #*=- 3285const char* SC_OPCODE_AREAS_ARY[] = 3286{ 3287 NC_("SC_OPCODE_AREAS", "Returns the number of individual ranges that belong to a (multiple) range."), 3288 NC_("SC_OPCODE_AREAS", "Reference"), 3289 NC_("SC_OPCODE_AREAS", "The reference to a (multiple) range.") 3290}; 3291 3292// -=*# Resource for function CHOOSE #*=- 3293const char* SC_OPCODE_CHOOSE_ARY[] = 3294{ 3295 NC_("SC_OPCODE_CHOOSE", "Selects a value from a list of up to 30 value arguments."), 3296 NC_("SC_OPCODE_CHOOSE", "Index"), 3297 NC_("SC_OPCODE_CHOOSE", "The index of the value (1..30) selected."), 3298 NC_("SC_OPCODE_CHOOSE", "Value "), 3299 NC_("SC_OPCODE_CHOOSE", "Value 1, value 2,... The list of arguments from which a value is chosen.") 3300}; 3301 3302// -=*# Resource for function COLUMNS #*=- 3303const char* SC_OPCODE_COLUMN_ARY[] = 3304{ 3305 NC_("SC_OPCODE_COLUMN", "Returns the internal column number of a reference."), 3306 NC_("SC_OPCODE_COLUMN", "Reference"), 3307 NC_("SC_OPCODE_COLUMN", "The reference to a cell or a range.") 3308}; 3309 3310// -=*# Resource for function ROW #*=- 3311const char* SC_OPCODE_ROW_ARY[] = 3312{ 3313 NC_("SC_OPCODE_ROW", "Defines the internal row number of a reference."), 3314 NC_("SC_OPCODE_ROW", "Reference"), 3315 NC_("SC_OPCODE_ROW", "The reference to a cell or a range.") 3316}; 3317 3318// -=*# Resource for function SHEET #*=- 3319const char* SC_OPCODE_SHEET_ARY[] = 3320{ 3321 NC_("SC_OPCODE_SHEET", "Returns the internal sheet number of a reference or a string."), 3322 NC_("SC_OPCODE_SHEET", "Reference"), 3323 NC_("SC_OPCODE_SHEET", "The reference to a cell or a range or the character string of a sheet name.") 3324}; 3325 3326// -=*# Resource for function COLUMNS #*=- 3327const char* SC_OPCODE_COLUMNS_ARY[] = 3328{ 3329 NC_("SC_OPCODE_COLUMNS", "Returns the number of columns in an array or reference."), 3330 NC_("SC_OPCODE_COLUMNS", "Array"), 3331 NC_("SC_OPCODE_COLUMNS", "The array (reference) for which the number of columns is to be determined.") 3332}; 3333 3334// -=*# Resource for function ROWS #*=- 3335const char* SC_OPCODE_ROWS_ARY[] = 3336{ 3337 NC_("SC_OPCODE_ROWS", "Returns the number of rows in a reference or array."), 3338 NC_("SC_OPCODE_ROWS", "Array"), 3339 NC_("SC_OPCODE_ROWS", "The array (reference) for which the number of rows is to be determined.") 3340}; 3341 3342// -=*# Resource for function SHEETS #*=- 3343const char* SC_OPCODE_SHEETS_ARY[] = 3344{ 3345 NC_("SC_OPCODE_SHEETS", "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."), 3346 NC_("SC_OPCODE_SHEETS", "Reference"), 3347 NC_("SC_OPCODE_SHEETS", "The reference to a cell or a range.") 3348}; 3349 3350// -=*# Resource for function HLOOKUP #*=- 3351const char* SC_OPCODE_H_LOOKUP_ARY[] = 3352{ 3353 NC_("SC_OPCODE_H_LOOKUP", "Horizontal search and reference to the cells located below."), 3354 NC_("SC_OPCODE_H_LOOKUP", "Search criterion"), 3355 NC_("SC_OPCODE_H_LOOKUP", "The value to be found in the first row."), 3356 NC_("SC_OPCODE_H_LOOKUP", "Array"), 3357 NC_("SC_OPCODE_H_LOOKUP", "The array or the range for the reference."), 3358 NC_("SC_OPCODE_H_LOOKUP", "Index"), 3359 NC_("SC_OPCODE_H_LOOKUP", "The row index in the array."), 3360 NC_("SC_OPCODE_H_LOOKUP", "Sorted range lookup"), 3361 NC_("SC_OPCODE_H_LOOKUP", "If the value is TRUE or not given, the search row of the array represents a series of ranges, and must be sorted in ascending order.") 3362}; 3363 3364// -=*# Resource for function VLOOKUP #*=- 3365const char* SC_OPCODE_V_LOOKUP_ARY[] = 3366{ 3367 NC_("SC_OPCODE_V_LOOKUP", "Vertical search and reference to indicated cells."), 3368 NC_("SC_OPCODE_V_LOOKUP", "Search criterion"), 3369 NC_("SC_OPCODE_V_LOOKUP", "The value to be found in the first column."), 3370 NC_("SC_OPCODE_V_LOOKUP", "Array"), 3371 NC_("SC_OPCODE_V_LOOKUP", "The array or range for referencing."), 3372 NC_("SC_OPCODE_V_LOOKUP", "Index"), 3373 NC_("SC_OPCODE_V_LOOKUP", "Column index number in the array."), 3374 NC_("SC_OPCODE_V_LOOKUP", "Sorted range lookup"), 3375 NC_("SC_OPCODE_V_LOOKUP", "If the value is TRUE or not given, the search column of the array represents a series of ranges, and must be sorted in ascending order.") 3376}; 3377 3378// -=*# Resource for function INDEX #*=- 3379const char* SC_OPCODE_INDEX_ARY[] = 3380{ 3381 NC_("SC_OPCODE_INDEX", "Returns a reference to a cell from a defined range."), 3382 NC_("SC_OPCODE_INDEX", "Reference"), 3383 NC_("SC_OPCODE_INDEX", "The reference to a (multiple) range."), 3384 NC_("SC_OPCODE_INDEX", "Row"), 3385 NC_("SC_OPCODE_INDEX", "The row in the range."), 3386 NC_("SC_OPCODE_INDEX", "Column"), 3387 NC_("SC_OPCODE_INDEX", "The column in the range."), 3388 NC_("SC_OPCODE_INDEX", "Range"), 3389 NC_("SC_OPCODE_INDEX", "The index of the subrange if referring to a multiple range.") 3390}; 3391 3392// -=*# Resource for function INDIRECT #*=- 3393const char* SC_OPCODE_INDIRECT_ARY[] = 3394{ 3395 NC_("SC_OPCODE_INDIRECT", "Returns the contents of a cell that is referenced in text form."), 3396 NC_("SC_OPCODE_INDIRECT", "Reference"), 3397 NC_("SC_OPCODE_INDIRECT", "The cell whose contents are to be evaluated is to be referenced in text form (e.g. \"A1\")."), 3398 NC_("SC_OPCODE_INDIRECT", "A1"), 3399 NC_("SC_OPCODE_INDIRECT", "The reference style: 0 or FALSE means R1C1 style, any other value or omitted means A1 style.") 3400}; 3401 3402// -=*# Resource for function LOOKUP #*=- 3403const char* SC_OPCODE_LOOKUP_ARY[] = 3404{ 3405 NC_("SC_OPCODE_LOOKUP", "Determines a value in a vector by comparison to values in another vector."), 3406 NC_("SC_OPCODE_LOOKUP", "Search criterion"), 3407 NC_("SC_OPCODE_LOOKUP", "The value to be used for comparison."), 3408 NC_("SC_OPCODE_LOOKUP", "Search vector"), 3409 NC_("SC_OPCODE_LOOKUP", "The vector (row or column) in which to search."), 3410 NC_("SC_OPCODE_LOOKUP", "Result vector"), 3411 NC_("SC_OPCODE_LOOKUP", "The vector (row or range) from which the value is to be determined.") 3412}; 3413 3414// -=*# Resource for function MATCH #*=- 3415const char* SC_OPCODE_MATCH_ARY[] = 3416{ 3417 NC_("SC_OPCODE_MATCH", "Defines a position in an array after comparing values."), 3418 NC_("SC_OPCODE_MATCH", "Search criterion"), 3419 NC_("SC_OPCODE_MATCH", "The value to be used for comparison."), 3420 NC_("SC_OPCODE_MATCH", "Lookup array"), 3421 NC_("SC_OPCODE_MATCH", "The array (range) in which the search is made."), 3422 NC_("SC_OPCODE_MATCH", "Type"), 3423 NC_("SC_OPCODE_MATCH", "Type can take the value 1 (first column array ascending), 0 (exact match or wildcard or regular expression match) or -1 (first column array descending) and determines the criteria to be used for comparison purposes.") 3424}; 3425 3426// -=*# Resource for function OFFSET #*=- 3427const char* SC_OPCODE_OFFSET_ARY[] = 3428{ 3429 NC_("SC_OPCODE_OFFSET", "Returns a reference which has been moved in relation to the starting point."), 3430 NC_("SC_OPCODE_OFFSET", "Reference"), 3431 NC_("SC_OPCODE_OFFSET", "The reference (cell) from which to base the movement."), 3432 NC_("SC_OPCODE_OFFSET", "Rows"), 3433 NC_("SC_OPCODE_OFFSET", "The number of rows to be moved either up or down."), 3434 NC_("SC_OPCODE_OFFSET", "Columns"), 3435 NC_("SC_OPCODE_OFFSET", "The number of columns that are to be moved to the left or to the right."), 3436 NC_("SC_OPCODE_OFFSET", "Height"), 3437 NC_("SC_OPCODE_OFFSET", "The number of rows of the moved reference."), 3438 NC_("SC_OPCODE_OFFSET", "Width"), 3439 NC_("SC_OPCODE_OFFSET", "The number of columns in the moved reference.") 3440}; 3441 3442// -=*# Resource for function ERRORTYPE #*=- 3443const char* SC_OPCODE_ERROR_TYPE_ARY[] = 3444{ 3445 NC_("SC_OPCODE_ERROR_TYPE", "Returns a number corresponding to an error type"), 3446 NC_("SC_OPCODE_ERROR_TYPE", "Reference"), 3447 NC_("SC_OPCODE_ERROR_TYPE", "The reference (cell) in which the error occurred.") 3448}; 3449 3450// -=*# Resource for function ERROR.TYPE #*=- 3451const char* SC_OPCODE_ERROR_TYPE_ODF_ARY[] = 3452{ 3453 NC_("SC_OPCODE_ERROR_TYPE_ODF", "Returns a number corresponding to one of the error values or #N/A if no error exists"), 3454 NC_("SC_OPCODE_ERROR_TYPE_ODF", "Expression"), 3455 NC_("SC_OPCODE_ERROR_TYPE_ODF", "The error value whose identifying number you want to find. Can be the actual error value or a reference to a cell that you want to test.") 3456}; 3457 3458// -=*# Resource for function STYLE #*=- 3459const char* SC_OPCODE_STYLE_ARY[] = 3460{ 3461 NC_("SC_OPCODE_STYLE", "Applies a Style to the formula cell."), 3462 NC_("SC_OPCODE_STYLE", "Style"), 3463 NC_("SC_OPCODE_STYLE", "The name of the Style to be applied."), 3464 NC_("SC_OPCODE_STYLE", "Time"), 3465 NC_("SC_OPCODE_STYLE", "The time (in seconds) that the Style is to remain valid."), 3466 NC_("SC_OPCODE_STYLE", "Style 2"), 3467 NC_("SC_OPCODE_STYLE", "The style to be applied after time expires.") 3468}; 3469 3470// -=*# Resource for function DDE #*=- 3471const char* SC_OPCODE_DDE_ARY[] = 3472{ 3473 NC_("SC_OPCODE_DDE", "Result of a DDE link."), 3474 NC_("SC_OPCODE_DDE", "Server"), 3475 NC_("SC_OPCODE_DDE", "The name of the server application."), 3476 NC_("SC_OPCODE_DDE", "Topic/file"), 3477 NC_("SC_OPCODE_DDE", "The topic or name of the file."), 3478 NC_("SC_OPCODE_DDE", "Item/range"), 3479 NC_("SC_OPCODE_DDE", "The item or range from which data is to be taken."), 3480 NC_("SC_OPCODE_DDE", "Mode"), 3481 NC_("SC_OPCODE_DDE", "Defines how data is to be converted to numbers.") 3482}; 3483 3484// -=*# Resource for function HYPERLINK #*=- 3485const char* SC_OPCODE_HYPERLINK_ARY[] = 3486{ 3487 NC_("SC_OPCODE_HYPERLINK", "Construct a Hyperlink."), 3488 NC_("SC_OPCODE_HYPERLINK", "URL"), 3489 NC_("SC_OPCODE_HYPERLINK", "The clickable URL."), 3490 NC_("SC_OPCODE_HYPERLINK", "Cell text"), 3491 NC_("SC_OPCODE_HYPERLINK", "The cell text to be displayed.") 3492}; 3493 3494// -=*# Resource for function GETPIVOTDATA #*=- 3495const char* SC_OPCODE_GET_PIVOT_DATA_ARY[] = 3496{ 3497 NC_("SC_OPCODE_GET_PIVOT_DATA", "Extracts value(s) from a pivot table."), 3498 NC_("SC_OPCODE_GET_PIVOT_DATA", "Data field"), 3499 NC_("SC_OPCODE_GET_PIVOT_DATA", "The name of the pivot table field to extract."), 3500 NC_("SC_OPCODE_GET_PIVOT_DATA", "Pivot table"), 3501 NC_("SC_OPCODE_GET_PIVOT_DATA", "A reference to a cell or range in the pivot table."), 3502 NC_("SC_OPCODE_GET_PIVOT_DATA", "Field name / item"), 3503 NC_("SC_OPCODE_GET_PIVOT_DATA", "Field name/value pair to filter the target data.") 3504}; 3505 3506// -=*# Resource for function BAHTTEXT #*=- 3507const char* SC_OPCODE_BAHTTEXT_ARY[] = 3508{ 3509 NC_("SC_OPCODE_BAHTTEXT", "Converts a number to text (Baht)."), 3510 NC_("SC_OPCODE_BAHTTEXT", "Number"), 3511 NC_("SC_OPCODE_BAHTTEXT", "The number to convert.") 3512}; 3513 3514// -=*# Resource for function JIS #*=- 3515const char* SC_OPCODE_JIS_ARY[] = 3516{ 3517 NC_("SC_OPCODE_JIS", "Converts half-width ASCII and katakana characters to full-width."), 3518 NC_("SC_OPCODE_JIS", "Text"), 3519 NC_("SC_OPCODE_JIS", "The text to convert.") 3520}; 3521 3522// -=*# Resource for function ASC #*=- 3523const char* SC_OPCODE_ASC_ARY[] = 3524{ 3525 NC_("SC_OPCODE_ASC", "Converts full-width ASCII and katakana characters to half-width."), 3526 NC_("SC_OPCODE_ASC", "Text"), 3527 NC_("SC_OPCODE_ASC", "The text to convert.") 3528}; 3529 3530// -=*# Resource for function CODE #*=- 3531const char* SC_OPCODE_CODE_ARY[] = 3532{ 3533 NC_("SC_OPCODE_CODE", "Returns a numeric code for the first character in a text string."), 3534 NC_("SC_OPCODE_CODE", "Text"), 3535 NC_("SC_OPCODE_CODE", "This is the text for which the code of the first character is to be found.") 3536}; 3537 3538// -=*# Resource for function DOLLAR #*=- 3539const char* SC_OPCODE_CURRENCY_ARY[] = 3540{ 3541 NC_("SC_OPCODE_CURRENCY", "Converts a number to text in currency format."), 3542 NC_("SC_OPCODE_CURRENCY", "Value"), 3543 NC_("SC_OPCODE_CURRENCY", "Value is a number, a reference to a cell containing a number or a formula that results in a number."), 3544 NC_("SC_OPCODE_CURRENCY", "Decimals"), 3545 NC_("SC_OPCODE_CURRENCY", "Decimal places. Denotes the number of digits to the right of the decimal point.") 3546}; 3547 3548// -=*# Resource for function CHAR #*=- 3549const char* SC_OPCODE_CHAR_ARY[] = 3550{ 3551 NC_("SC_OPCODE_CHAR", "Converts a code number into a character or letter."), 3552 NC_("SC_OPCODE_CHAR", "Number"), 3553 NC_("SC_OPCODE_CHAR", "The code value for the character.") 3554}; 3555 3556// -=*# Resource for function CLEAN #*=- 3557const char* SC_OPCODE_CLEAN_ARY[] = 3558{ 3559 NC_("SC_OPCODE_CLEAN", "Removes all nonprintable characters from text."), 3560 NC_("SC_OPCODE_CLEAN", "Text"), 3561 NC_("SC_OPCODE_CLEAN", "The text from which nonprintable characters are to be removed.") 3562}; 3563 3564// -=*# Resource for function CONCATENATE #*=- 3565const char* SC_OPCODE_CONCAT_ARY[] = 3566{ 3567 NC_("SC_OPCODE_CONCAT", "Combines several text items into one."), 3568 NC_("SC_OPCODE_CONCAT", "Text"), 3569 NC_("SC_OPCODE_CONCAT", "Text for the concatenation.") 3570}; 3571 3572// -=*# Resource for function CONCAT #*=- 3573const char* SC_OPCODE_CONCAT_MS_ARY[] = 3574{ 3575 NC_("SC_OPCODE_CONCAT_MS", "Combines several text items into one, accepts cell ranges as arguments."), 3576 NC_("SC_OPCODE_CONCAT_MS", "Text"), 3577 NC_("SC_OPCODE_CONCAT_MS", "Text and/or cell ranges for the concatenation.") 3578}; 3579 3580// -=*# Resource for function TEXTJOIN #*=- 3581const char* SC_OPCODE_TEXTJOIN_MS_ARY[] = 3582{ 3583 NC_("SC_OPCODE_TEXTJOIN_MS", "Combines several text items into one, accepts cell ranges as arguments. Uses delimiter between items."), 3584 NC_("SC_OPCODE_TEXTJOIN_MS", "Delimiter"), 3585 NC_("SC_OPCODE_TEXTJOIN_MS", "Text string to be used as delimiter."), 3586 NC_("SC_OPCODE_TEXTJOIN_MS", "Skip empty cells"), 3587 NC_("SC_OPCODE_TEXTJOIN_MS", "If TRUE, empty cells will be ignored."), 3588 NC_("SC_OPCODE_TEXTJOIN_MS", "Text"), 3589 NC_("SC_OPCODE_TEXTJOIN_MS", "Text and/or cell ranges for the concatenation.") 3590}; 3591 3592// -=*# Resource for function IFS #*=- 3593const char* SC_OPCODE_IFS_MS_ARY[] = 3594{ 3595 NC_("SC_OPCODE_IFS_MS", "Checks 1 or more conditions and returns a value corresponding to the first true condition."), 3596 NC_("SC_OPCODE_IFS_MS", "Test"), 3597 NC_("SC_OPCODE_IFS_MS", "Any value or expression which can be either TRUE or FALSE."), 3598 NC_("SC_OPCODE_IFS_MS", "Result"), 3599 NC_("SC_OPCODE_IFS_MS", "The result of the function if test is TRUE.") 3600}; 3601 3602// -=*# Resource for function SWITCH #*=- 3603const char* SC_OPCODE_SWITCH_MS_ARY[] = 3604{ 3605 NC_("SC_OPCODE_SWITCH_MS", "Compares expression against list of value/result pairs, and returns result for first value that matches the expression. If expression does not match any value, a default result is returned, if it is placed as final item in parameter list without a value."), 3606 NC_("SC_OPCODE_SWITCH_MS", "Expression"), 3607 NC_("SC_OPCODE_SWITCH_MS", "Value to be compared against value1…valueN (N ≤ 127)"), 3608 NC_("SC_OPCODE_SWITCH_MS", "Value"), 3609 NC_("SC_OPCODE_SWITCH_MS", "Value to compare against expression. If no result is given, then value is returned as default result."), 3610 NC_("SC_OPCODE_SWITCH_MS", "Result"), 3611 NC_("SC_OPCODE_SWITCH_MS", "Value to return when corresponding value argument matches expression.") 3612}; 3613 3614const char* SC_OPCODE_MINIFS_MS_ARY[] = 3615{ 3616 NC_("SC_OPCODE_MINIFS_MS", "Returns the minimum value in a range that meet multiple criteria in multiple ranges."), 3617 NC_("SC_OPCODE_MINIFS_MS", "Min range"), 3618 NC_("SC_OPCODE_MINIFS_MS", "The range from which the minimum will be determined."), 3619 NC_("SC_OPCODE_MINIFS_MS", "Range "), 3620 NC_("SC_OPCODE_MINIFS_MS", "Range 1, range 2,... are the ranges to be evaluated by the criteria given."), 3621 NC_("SC_OPCODE_MINIFS_MS", "Criteria "), 3622 NC_("SC_OPCODE_MINIFS_MS", "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given.") 3623}; 3624 3625const char* SC_OPCODE_MAXIFS_MS_ARY[] = 3626{ 3627 NC_("SC_OPCODE_MAXIFS_MS", "Returns the maximum value in a range that meet multiple criteria in multiple ranges."), 3628 NC_("SC_OPCODE_MAXIFS_MS", "Max range"), 3629 NC_("SC_OPCODE_MAXIFS_MS", "The range from which the maximum will be determined."), 3630 NC_("SC_OPCODE_MAXIFS_MS", "Range "), 3631 NC_("SC_OPCODE_MAXIFS_MS", "Range 1, range 2,... are the ranges to be evaluated by the criteria given."), 3632 NC_("SC_OPCODE_MAXIFS_MS", "Criteria "), 3633 NC_("SC_OPCODE_MAXIFS_MS", "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given.") 3634}; 3635 3636// -=*# Resource for function EXACT #*=- 3637const char* SC_OPCODE_EXACT_ARY[] = 3638{ 3639 NC_("SC_OPCODE_EXACT", "Specifies whether two texts are identical."), 3640 NC_("SC_OPCODE_EXACT", "Text 1"), 3641 NC_("SC_OPCODE_EXACT", "The first text to be used for comparing texts."), 3642 NC_("SC_OPCODE_EXACT", "Text 2"), 3643 NC_("SC_OPCODE_EXACT", "The second text for comparing texts.") 3644}; 3645 3646// -=*# Resource for function FIND #*=- 3647const char* SC_OPCODE_FIND_ARY[] = 3648{ 3649 NC_("SC_OPCODE_FIND", "Looks for a string of text within another (case sensitive)"), 3650 NC_("SC_OPCODE_FIND", "Find text"), 3651 NC_("SC_OPCODE_FIND", "The text to be found."), 3652 NC_("SC_OPCODE_FIND", "Text"), 3653 NC_("SC_OPCODE_FIND", "The text in which a search is to be made."), 3654 NC_("SC_OPCODE_FIND", "Position"), 3655 NC_("SC_OPCODE_FIND", "The position in the text from which the search starts.") 3656}; 3657 3658// -=*# Resource for function SEARCH #*=- 3659const char* SC_OPCODE_SEARCH_ARY[] = 3660{ 3661 NC_("SC_OPCODE_SEARCH", "Looks for one text value within another (not case-sensitive)."), 3662 NC_("SC_OPCODE_SEARCH", "Find text"), 3663 NC_("SC_OPCODE_SEARCH", "The text to be found."), 3664 NC_("SC_OPCODE_SEARCH", "Text"), 3665 NC_("SC_OPCODE_SEARCH", "The text in which a search is to be made."), 3666 NC_("SC_OPCODE_SEARCH", "Position"), 3667 NC_("SC_OPCODE_SEARCH", "The position in the text where the search is started.") 3668}; 3669 3670// -=*# Resource for function TRIM #*=- 3671const char* SC_OPCODE_TRIM_ARY[] = 3672{ 3673 NC_("SC_OPCODE_TRIM", "Removes extra spaces from text."), 3674 NC_("SC_OPCODE_TRIM", "Text"), 3675 NC_("SC_OPCODE_TRIM", "The text in which extra spaces between words are to be deleted.") 3676}; 3677 3678// -=*# Resource for function PROPER #*=- 3679const char* SC_OPCODE_PROPER_ARY[] = 3680{ 3681 NC_("SC_OPCODE_PROPER", "Capitalizes the first letter in all words."), 3682 NC_("SC_OPCODE_PROPER", "Text"), 3683 NC_("SC_OPCODE_PROPER", "The text in which the beginning of words are to be replaced by capital letters.") 3684}; 3685 3686// -=*# Resource for function UPPER #*=- 3687const char* SC_OPCODE_UPPER_ARY[] = 3688{ 3689 NC_("SC_OPCODE_UPPER", "Converts text to uppercase."), 3690 NC_("SC_OPCODE_UPPER", "Text"), 3691 NC_("SC_OPCODE_UPPER", "The text in which lower case letters are to be converted to capitals.") 3692}; 3693 3694// -=*# Resource for function LOWER #*=- 3695const char* SC_OPCODE_LOWER_ARY[] = 3696{ 3697 NC_("SC_OPCODE_LOWER", "Converts text to lowercase."), 3698 NC_("SC_OPCODE_LOWER", "Text"), 3699 NC_("SC_OPCODE_LOWER", "The text in which capitals are converted to lower case letters.") 3700}; 3701 3702// -=*# Resource for function VALUE #*=- 3703const char* SC_OPCODE_VALUE_ARY[] = 3704{ 3705 NC_("SC_OPCODE_VALUE", "Converts text to a number."), 3706 NC_("SC_OPCODE_VALUE", "Text"), 3707 NC_("SC_OPCODE_VALUE", "The text to be converted to a number.") 3708}; 3709 3710// -=*# Resource for function TEXT #*=- 3711const char* SC_OPCODE_TEXT_ARY[] = 3712{ 3713 NC_("SC_OPCODE_TEXT", "Converts a number to text according to a given format."), 3714 NC_("SC_OPCODE_TEXT", "Number"), 3715 NC_("SC_OPCODE_TEXT", "The numeric value to be converted."), 3716 NC_("SC_OPCODE_TEXT", "Format"), 3717 NC_("SC_OPCODE_TEXT", "The text that describes the format.") 3718}; 3719 3720// -=*# Resource for function T #*=- 3721const char* SC_OPCODE_T_ARY[] = 3722{ 3723 NC_("SC_OPCODE_T", "Returns a value if it is text, otherwise an empty string."), 3724 NC_("SC_OPCODE_T", "Value"), 3725 NC_("SC_OPCODE_T", "The value to be checked and returned if it is text.") 3726}; 3727 3728// -=*# Resource for function REPLACE #*=- 3729const char* SC_OPCODE_REPLACE_ARY[] = 3730{ 3731 NC_("SC_OPCODE_REPLACE", "Replaces characters within a text string with a different text string."), 3732 NC_("SC_OPCODE_REPLACE", "Text"), 3733 NC_("SC_OPCODE_REPLACE", "The text in which some characters are to be replaced."), 3734 NC_("SC_OPCODE_REPLACE", "Position"), 3735 NC_("SC_OPCODE_REPLACE", "The character position from which text is to be replaced."), 3736 NC_("SC_OPCODE_REPLACE", "Length"), 3737 NC_("SC_OPCODE_REPLACE", "The number of characters to be replaced."), 3738 NC_("SC_OPCODE_REPLACE", "New text"), 3739 NC_("SC_OPCODE_REPLACE", "The text to be inserted.") 3740}; 3741 3742// -=*# Resource for function FIXED #*=- 3743const char* SC_OPCODE_FIXED_ARY[] = 3744{ 3745 NC_("SC_OPCODE_FIXED", "Formats a number with a fixed number of places after the decimal point and thousands separator."), 3746 NC_("SC_OPCODE_FIXED", "Number"), 3747 NC_("SC_OPCODE_FIXED", "The number to be formatted."), 3748 NC_("SC_OPCODE_FIXED", "Decimals"), 3749 NC_("SC_OPCODE_FIXED", "Decimal places. The number of fixed decimal places that are to be displayed."), 3750 NC_("SC_OPCODE_FIXED", "No thousands separators"), 3751 NC_("SC_OPCODE_FIXED", "Thousands separator. If 0 or omitted the locale group separator is used else the separator is suppressed.") 3752}; 3753 3754// -=*# Resource for function LEN #*=- 3755const char* SC_OPCODE_LEN_ARY[] = 3756{ 3757 NC_("SC_OPCODE_LEN", "Calculates length of a text string."), 3758 NC_("SC_OPCODE_LEN", "Text"), 3759 NC_("SC_OPCODE_LEN", "The text in which the length is to be determined.") 3760}; 3761 3762// -=*# Resource for function LEFT #*=- 3763const char* SC_OPCODE_LEFT_ARY[] = 3764{ 3765 NC_("SC_OPCODE_LEFT", "Returns the first character or characters of a text."), 3766 NC_("SC_OPCODE_LEFT", "Text"), 3767 NC_("SC_OPCODE_LEFT", "The text where the initial partial words are to be determined."), 3768 NC_("SC_OPCODE_LEFT", "Number"), 3769 NC_("SC_OPCODE_LEFT", "The number of characters for the start text.") 3770}; 3771 3772// -=*# Resource for function RIGHT #*=- 3773const char* SC_OPCODE_RIGHT_ARY[] = 3774{ 3775 NC_("SC_OPCODE_RIGHT", "Returns the last character or characters of a text."), 3776 NC_("SC_OPCODE_RIGHT", "Text"), 3777 NC_("SC_OPCODE_RIGHT", "The text in which the end partial words are to be determined."), 3778 NC_("SC_OPCODE_RIGHT", "Number"), 3779 NC_("SC_OPCODE_RIGHT", "The number of characters for the end text.") 3780}; 3781 3782// -=*# Resource for function MID #*=- 3783const char* SC_OPCODE_MID_ARY[] = 3784{ 3785 NC_("SC_OPCODE_MID", "Returns a partial text string of a text."), 3786 NC_("SC_OPCODE_MID", "Text"), 3787 NC_("SC_OPCODE_MID", "The text in which partial words are to be determined."), 3788 NC_("SC_OPCODE_MID", "Start"), 3789 NC_("SC_OPCODE_MID", "The position from which the part word is to be determined."), 3790 NC_("SC_OPCODE_MID", "Number"), 3791 NC_("SC_OPCODE_MID", "The number of characters for the text.") 3792}; 3793 3794// -=*# Resource for function REPT #*=- 3795const char* SC_OPCODE_REPT_ARY[] = 3796{ 3797 NC_("SC_OPCODE_REPT", "Repeats text a given number of times."), 3798 NC_("SC_OPCODE_REPT", "Text"), 3799 NC_("SC_OPCODE_REPT", "The text to be repeated."), 3800 NC_("SC_OPCODE_REPT", "Number"), 3801 NC_("SC_OPCODE_REPT", "The number of times the text is to be repeated.") 3802}; 3803 3804// -=*# Resource for function SUBSTITUTE #*=- 3805const char* SC_OPCODE_SUBSTITUTE_ARY[] = 3806{ 3807 NC_("SC_OPCODE_SUBSTITUTE", "Substitutes new text for old text in a string."), 3808 NC_("SC_OPCODE_SUBSTITUTE", "Text"), 3809 NC_("SC_OPCODE_SUBSTITUTE", "The text in which partial words are to be replaced."), 3810 NC_("SC_OPCODE_SUBSTITUTE", "Search text"), 3811 NC_("SC_OPCODE_SUBSTITUTE", "The partial string to be (repeatedly) replaced."), 3812 NC_("SC_OPCODE_SUBSTITUTE", "New text"), 3813 NC_("SC_OPCODE_SUBSTITUTE", "The text which is to replace the text string."), 3814 NC_("SC_OPCODE_SUBSTITUTE", "Occurrence"), 3815 NC_("SC_OPCODE_SUBSTITUTE", "Which occurrence of the old text is to be replaced.") 3816}; 3817 3818// -=*# Resource for function REGEX #*=- 3819const char* SC_OPCODE_REGEX_ARY[] = 3820{ 3821 NC_("SC_OPCODE_REGEX", "Matches and extracts or optionally replaces text using regular expressions."), 3822 NC_("SC_OPCODE_REGEX", "Text"), 3823 NC_("SC_OPCODE_REGEX", "The text to be operated on."), 3824 NC_("SC_OPCODE_REGEX", "Expression"), 3825 NC_("SC_OPCODE_REGEX", "The regular expression pattern to be matched."), 3826 NC_("SC_OPCODE_REGEX", "Replacement"), 3827 NC_("SC_OPCODE_REGEX", "The replacement text and references to capture groups."), 3828 NC_("SC_OPCODE_REGEX", "Flags or Occurrence"), 3829 NC_("SC_OPCODE_REGEX", "Text specifying option flags, \"g\" for global replacement. Or number of occurrence to match or replace.") 3830}; 3831 3832// -=*# Resource for function BASE #*=- 3833const char* SC_OPCODE_BASE_ARY[] = 3834{ 3835 NC_("SC_OPCODE_BASE", "Converts a positive integer to text from a number system to the base defined."), 3836 NC_("SC_OPCODE_BASE", "Number"), 3837 NC_("SC_OPCODE_BASE", "The number to be converted."), 3838 NC_("SC_OPCODE_BASE", "Radix"), 3839 NC_("SC_OPCODE_BASE", "The base number for conversion must be in the range 2 - 36."), 3840 NC_("SC_OPCODE_BASE", "Minimum length"), 3841 NC_("SC_OPCODE_BASE", "If the text is shorter than the specified length, zeros are added to the left of the string.") 3842}; 3843 3844// -=*# Resource for function DECIMAL #*=- 3845const char* SC_OPCODE_DECIMAL_ARY[] = 3846{ 3847 NC_("SC_OPCODE_DECIMAL", "Converts a text of a specified number system to a positive integer in the base given."), 3848 NC_("SC_OPCODE_DECIMAL", "Text"), 3849 NC_("SC_OPCODE_DECIMAL", "The text to be converted."), 3850 NC_("SC_OPCODE_DECIMAL", "Radix"), 3851 NC_("SC_OPCODE_DECIMAL", "The base number for conversion must be in the range 2 - 36.") 3852}; 3853 3854// -=*# Resource for function CONVERT_OOO #*=- 3855const char* SC_OPCODE_CONVERT_OOO_ARY[] = 3856{ 3857 NC_("SC_OPCODE_CONVERT_OOO", "Converts a value according to a conversion table in the configuration (main.xcd)."), 3858 NC_("SC_OPCODE_CONVERT_OOO", "Value"), 3859 NC_("SC_OPCODE_CONVERT_OOO", "The value to be converted."), 3860 NC_("SC_OPCODE_CONVERT_OOO", "Text"), 3861 NC_("SC_OPCODE_CONVERT_OOO", "Unit from which something is converted, case-sensitive."), 3862 NC_("SC_OPCODE_CONVERT_OOO", "Text"), 3863 NC_("SC_OPCODE_CONVERT_OOO", "Unit into which something is converted, case-sensitive.") 3864}; 3865 3866// -=*# Resource for function ROMAN #*=- 3867const char* SC_OPCODE_ROMAN_ARY[] = 3868{ 3869 NC_("SC_OPCODE_ROMAN", "Converts a number to a Roman numeral."), 3870 NC_("SC_OPCODE_ROMAN", "Number"), 3871 NC_("SC_OPCODE_ROMAN", "The number to be converted to a Roman numeral must be in the 0 - 3999 range."), 3872 NC_("SC_OPCODE_ROMAN", "Mode"), 3873 NC_("SC_OPCODE_ROMAN", "The more this value increases, the more the Roman numeral is simplified. The value must be in the 0 - 4 range.") 3874}; 3875 3876// -=*# Resource for function ARABIC #*=- 3877const char* SC_OPCODE_ARABIC_ARY[] = 3878{ 3879 NC_("SC_OPCODE_ARABIC", "Calculates the value of a Roman numeral."), 3880 NC_("SC_OPCODE_ARABIC", "Text"), 3881 NC_("SC_OPCODE_ARABIC", "The text that represents a Roman numeral.") 3882}; 3883 3884const char* SC_OPCODE_INFO_ARY[] = 3885{ 3886 NC_("SC_OPCODE_INFO", "Returns information about the environment."), 3887 NC_("SC_OPCODE_INFO", "Text"), 3888 NC_("SC_OPCODE_INFO", "Can be \"osversion\", \"system\", \"release\", \"numfile\", and \"recalc\".") 3889}; 3890 3891const char* SC_OPCODE_UNICODE_ARY[] = 3892{ 3893 NC_("SC_OPCODE_UNICODE", "Returns the numeric code for the first Unicode character in a text string."), 3894 NC_("SC_OPCODE_UNICODE", "Text"), 3895 NC_("SC_OPCODE_UNICODE", "This is the text for which the code of the first character is to be found.") 3896}; 3897 3898const char* SC_OPCODE_UNICHAR_ARY[] = 3899{ 3900 NC_("SC_OPCODE_UNICHAR", "Converts a code number into a Unicode character or letter."), 3901 NC_("SC_OPCODE_UNICHAR", "Number"), 3902 NC_("SC_OPCODE_UNICHAR", "The code value for the character.") 3903}; 3904 3905const char* SC_OPCODE_EUROCONVERT_ARY[] = 3906{ 3907 NC_("SC_OPCODE_EUROCONVERT", "Converts a value from one to another Euro currency."), 3908 NC_("SC_OPCODE_EUROCONVERT", "Value"), 3909 NC_("SC_OPCODE_EUROCONVERT", "The value to be converted."), 3910 NC_("SC_OPCODE_EUROCONVERT", "From currency"), 3911 NC_("SC_OPCODE_EUROCONVERT", "ISO 4217 code of the currency from which is converted."), 3912 NC_("SC_OPCODE_EUROCONVERT", "To currency"), 3913 NC_("SC_OPCODE_EUROCONVERT", "ISO 4217 code of the currency into which is converted."), 3914 NC_("SC_OPCODE_EUROCONVERT", "Full precision"), 3915 NC_("SC_OPCODE_EUROCONVERT", "If omitted or 0 or FALSE, the result is rounded to the decimals of To_currency. Else the result is not rounded."), 3916 NC_("SC_OPCODE_EUROCONVERT", "Triangulation precision"), 3917 /* This description uses almost all available space in the dialog, make sure translations fit in size */ 3918 NC_("SC_OPCODE_EUROCONVERT", "If given and >=3, the intermediate result of a triangular conversion is rounded to that precision. If omitted, the result is not rounded.") 3919}; 3920 3921const char* SC_OPCODE_NUMBERVALUE_ARY[] = 3922{ 3923 NC_("SC_OPCODE_NUMBERVALUE", "Converts text to a number, in a locale-independent way."), 3924 NC_("SC_OPCODE_NUMBERVALUE", "Text"), 3925 NC_("SC_OPCODE_NUMBERVALUE", "The text to be converted to a number."), 3926 NC_("SC_OPCODE_NUMBERVALUE", "Decimal separator"), 3927 NC_("SC_OPCODE_NUMBERVALUE", "Defines the character used as the decimal separator."), 3928 NC_("SC_OPCODE_NUMBERVALUE", "Group separator"), 3929 NC_("SC_OPCODE_NUMBERVALUE", "Defines the character(s) used as the group separator.") 3930}; 3931 3932 3933const char* SC_OPCODE_BITAND_ARY[] = 3934{ 3935 NC_("SC_OPCODE_BITAND", "Bitwise \"AND\" of two integers."), 3936 NC_("SC_OPCODE_BITAND", "Number1"), 3937 NC_("SC_OPCODE_BITAND", "Positive integer less than 2^48."), 3938 NC_("SC_OPCODE_BITAND", "Number2"), 3939 NC_("SC_OPCODE_BITAND", "Positive integer less than 2^48.") 3940}; 3941 3942const char* SC_OPCODE_BITOR_ARY[] = 3943{ 3944 NC_("SC_OPCODE_BITOR", "Bitwise \"OR\" of two integers."), 3945 NC_("SC_OPCODE_BITOR", "Number1"), 3946 NC_("SC_OPCODE_BITOR", "Positive integer less than 2^48."), 3947 NC_("SC_OPCODE_BITOR", "Number2"), 3948 NC_("SC_OPCODE_BITOR", "Positive integer less than 2^48.") 3949}; 3950 3951const char* SC_OPCODE_BITXOR_ARY[] = 3952{ 3953 NC_("SC_OPCODE_BITXOR", "Bitwise \"exclusive OR\" of two integers."), 3954 NC_("SC_OPCODE_BITXOR", "Number1"), 3955 NC_("SC_OPCODE_BITXOR", "Positive integer less than 2^48."), 3956 NC_("SC_OPCODE_BITXOR", "Number2"), 3957 NC_("SC_OPCODE_BITXOR", "Positive integer less than 2^48.") 3958}; 3959 3960const char* SC_OPCODE_BITRSHIFT_ARY[] = 3961{ 3962 NC_("SC_OPCODE_BITRSHIFT", "Bitwise right shift of an integer value."), 3963 NC_("SC_OPCODE_BITRSHIFT", "Number"), 3964 NC_("SC_OPCODE_BITRSHIFT", "The value to be shifted. Positive integer less than 2^48."), 3965 NC_("SC_OPCODE_BITRSHIFT", "Shift"), 3966 NC_("SC_OPCODE_BITRSHIFT", "The integer number of bits the value is to be shifted.") 3967}; 3968 3969const char* SC_OPCODE_BITLSHIFT_ARY[] = 3970{ 3971 NC_("SC_OPCODE_BITLSHIFT", "Bitwise left shift of an integer value."), 3972 NC_("SC_OPCODE_BITLSHIFT", "Number"), 3973 NC_("SC_OPCODE_BITLSHIFT", "The value to be shifted. Positive integer less than 2^48."), 3974 NC_("SC_OPCODE_BITLSHIFT", "Shift"), 3975 NC_("SC_OPCODE_BITLSHIFT", "The integer number of bits the value is to be shifted.") 3976}; 3977 3978const char* SC_OPCODE_LENB_ARY[] = 3979{ 3980 NC_("SC_OPCODE_LENB", "Calculates length of a text string, with DBCS"), 3981 NC_("SC_OPCODE_LENB", "Text"), 3982 NC_("SC_OPCODE_LENB", "The text in which the length is to be determined.") 3983}; 3984 3985const char* SC_OPCODE_RIGHTB_ARY[] = 3986{ 3987 NC_("SC_OPCODE_RIGHTB", "Returns the last character or characters of a text,with DBCS"), 3988 NC_("SC_OPCODE_RIGHTB", "Text"), 3989 NC_("SC_OPCODE_RIGHTB", "The text in which the end partial words are to be determined."), 3990 NC_("SC_OPCODE_RIGHTB", "Number"), 3991 NC_("SC_OPCODE_RIGHTB", "The number of characters for the end text.") 3992}; 3993 3994const char* SC_OPCODE_LEFTB_ARY[] = 3995{ 3996 NC_("SC_OPCODE_LEFTB", "Returns the first character or characters of a text,with DBCS"), 3997 NC_("SC_OPCODE_LEFTB", "Text"), 3998 NC_("SC_OPCODE_LEFTB", "The text where the initial partial words are to be determined."), 3999 NC_("SC_OPCODE_LEFTB", "Number"), 4000 NC_("SC_OPCODE_LEFTB", "The number of characters for the start text.") 4001}; 4002 4003const char* SC_OPCODE_MIDB_ARY[] = 4004{ 4005 NC_("SC_OPCODE_MIDB", "Returns a partial text string of a text, with DBCS"), 4006 NC_("SC_OPCODE_MIDB", "Text"), 4007 NC_("SC_OPCODE_MIDB", "The text in which partial words are to be determined."), 4008 NC_("SC_OPCODE_MIDB", "Start"), 4009 NC_("SC_OPCODE_MIDB", "The position from which the part word is to be determined."), 4010 NC_("SC_OPCODE_MIDB", "Number"), 4011 NC_("SC_OPCODE_MIDB", "The number of characters for the text.") 4012}; 4013 4014const char* SC_OPCODE_FILTERXML_ARY[] = 4015{ 4016 NC_("SC_OPCODE_FILTERXML", "Apply an XPath expression to an XML document"), 4017 NC_("SC_OPCODE_FILTERXML", "XML Document"), 4018 NC_("SC_OPCODE_FILTERXML", "String containing a valid XML stream"), 4019 NC_("SC_OPCODE_FILTERXML", "XPath expression"), 4020 NC_("SC_OPCODE_FILTERXML", "String containing a valid XPath expression") 4021}; 4022 4023const char* SC_OPCODE_COLOR_ARY[] = 4024{ 4025 NC_("SC_OPCODE_COLOR", "Returns an implementation defined value representing a RGBA color"), 4026 NC_("SC_OPCODE_COLOR", "Red"), 4027 NC_("SC_OPCODE_COLOR", "Value of red"), 4028 NC_("SC_OPCODE_COLOR", "Green"), 4029 NC_("SC_OPCODE_COLOR", "Value of green"), 4030 NC_("SC_OPCODE_COLOR", "Blue"), 4031 NC_("SC_OPCODE_COLOR", "Value of blue"), 4032 NC_("SC_OPCODE_COLOR", "Alpha"), 4033 NC_("SC_OPCODE_COLOR", "Value of alpha") 4034}; 4035 4036const char* SC_OPCODE_WEBSERVICE_ARY[] = 4037{ 4038 NC_("SC_OPCODE_WEBSERVICE", "Get some web-content from a URI."), 4039 NC_("SC_OPCODE_WEBSERVICE", "URI"), 4040 NC_("SC_OPCODE_WEBSERVICE", "URI of the webservice") 4041}; 4042 4043const char* SC_OPCODE_ENCODEURL_ARY[] = 4044{ 4045 NC_("SC_OPCODE_ENCODEURL", "Return a URL-encoded string."), 4046 NC_("SC_OPCODE_ENCODEURL", "Text"), 4047 NC_("SC_OPCODE_ENCODEURL", "A string to be URL-encoded") 4048}; 4049 4050const char* SC_OPCODE_ERF_MS_ARY[] = 4051{ 4052 NC_("SC_OPCODE_ERF_MS", "Returns the error function."), 4053 NC_("SC_OPCODE_ERF_MS", "Lower limit"), 4054 NC_("SC_OPCODE_ERF_MS", "The lower limit for integration") 4055}; 4056 4057const char* SC_OPCODE_ERFC_MS_ARY[] = 4058{ 4059 NC_("SC_OPCODE_ERFC_MS", "Returns the complementary error function."), 4060 NC_("SC_OPCODE_ERFC_MS", "Lower limit"), 4061 NC_("SC_OPCODE_ERFC_MS", "The lower limit for integration") 4062}; 4063 4064const char* SC_OPCODE_RAWSUBTRACT_ARY[] = 4065{ 4066 NC_("SC_OPCODE_RAWSUBTRACT", "Returns the subtraction of numbers. Like a-b-c but without eliminating small roundoff errors."), 4067 NC_("SC_OPCODE_RAWSUBTRACT", "Minuend"), 4068 NC_("SC_OPCODE_RAWSUBTRACT", "Number from which following arguments are subtracted."), 4069 NC_("SC_OPCODE_RAWSUBTRACT", "Subtrahend "), 4070 NC_("SC_OPCODE_RAWSUBTRACT", "Subtrahend 1, subtrahend 2, ... are numerical arguments subtracted from the minuend.") 4071}; 4072 4073// -=*# Resource for function ROUNDSIG #*=- 4074const char* SC_OPCODE_ROUNDSIG_ARY[] = 4075{ 4076 NC_("SC_OPCODE_ROUNDSIG", "Rounds a number to predefined significant digits."), 4077 NC_("SC_OPCODE_ROUNDSIG", "Value"), 4078 NC_("SC_OPCODE_ROUNDSIG", "The number to be rounded."), 4079 NC_("SC_OPCODE_ROUNDSIG", "Digits"), 4080 NC_("SC_OPCODE_ROUNDSIG", "The number of significant digits to which value is to be rounded.") 4081}; 4082 4083const char* SC_OPCODE_REPLACEB_ARY[] = 4084{ 4085 NC_("SC_OPCODE_REPLACEB", "Replaces characters within a text string with a different text string, with DBCS."), 4086 NC_("SC_OPCODE_REPLACEB", "Text"), 4087 NC_("SC_OPCODE_REPLACEB", "The text in which some characters are to be replaced."), 4088 NC_("SC_OPCODE_REPLACEB", "Position"), 4089 NC_("SC_OPCODE_REPLACEB", "The character position from which text is to be replaced."), 4090 NC_("SC_OPCODE_REPLACEB", "Length"), 4091 NC_("SC_OPCODE_REPLACEB", "The number of characters to be replaced."), 4092 NC_("SC_OPCODE_REPLACEB", "New text"), 4093 NC_("SC_OPCODE_REPLACEB", "The text to be inserted.") 4094}; 4095 4096 // -=*# Resource for function FINDB #*=- 4097const char* SC_OPCODE_FINDB_ARY[] = 4098{ 4099 NC_("SC_OPCODE_FINDB", "Looks for a string of text within another (case sensitive), using byte positions."), 4100 NC_("SC_OPCODE_FINDB", "Find text"), 4101 NC_("SC_OPCODE_FINDB", "The text to be found."), 4102 NC_("SC_OPCODE_FINDB", "Text"), 4103 NC_("SC_OPCODE_FINDB", "The text in which a search is to be made."), 4104 NC_("SC_OPCODE_FINDB", "Position"), 4105 NC_("SC_OPCODE_FINDB", "The position in the text from which the search starts.") 4106}; 4107 4108 // -=*# Resource for function SEARCHB #*=- 4109const char* SC_OPCODE_SEARCHB_ARY[] = 4110{ 4111 NC_("SC_OPCODE_SEARCHB", "Looks for a string of text within another (not case sensitive), using byte positions."), 4112 NC_("SC_OPCODE_SEARCHB", "Find text"), 4113 NC_("SC_OPCODE_SEARCHB", "The text to be found."), 4114 NC_("SC_OPCODE_SEARCHB", "Text"), 4115 NC_("SC_OPCODE_SEARCHB", "The text in which a search is to be made."), 4116 NC_("SC_OPCODE_SEARCHB", "Position"), 4117 NC_("SC_OPCODE_SEARCHB", "The position in the text from which the search starts.") 4118}; 4119 4120// -=*# Resource for function FOURIER #*=- 4121const char* SC_OPCODE_FOURIER_ARY[] = 4122{ 4123 NC_("SC_OPCODE_FOURIER", "Computes the Discrete Fourier Transform (DFT) of an array"), 4124 NC_("SC_OPCODE_FOURIER", "Array"), 4125 NC_("SC_OPCODE_FOURIER", "The array whose DFT needs to be computed. The dimensions of this array can be Nx1 or Nx2 or 1xN or 2xN."), 4126 NC_("SC_OPCODE_FOURIER", "GroupedByColumns"), 4127 NC_("SC_OPCODE_FOURIER", "Flag to indicate whether the array is grouped by columns or not (default TRUE)."), 4128 NC_("SC_OPCODE_FOURIER", "Inverse"), 4129 NC_("SC_OPCODE_FOURIER", "Flag to indicate whether an inverse DFT is to be computed (default FALSE)."), 4130 NC_("SC_OPCODE_FOURIER", "Polar"), 4131 NC_("SC_OPCODE_FOURIER", "Flag to indicate whether to return the results in polar form (default FALSE)."), 4132 NC_("SC_OPCODE_FOURIER", "MinimumMagnitude"), 4133 NC_("SC_OPCODE_FOURIER", "In case of Polar=TRUE, the frequency components below this magnitude are clipped out (default 0.0).") 4134}; 4135 4136// -=*# Resource for function RAND.NV #*=- 4137const char* SC_OPCODE_RANDOM_NV_ARY[] = 4138{ 4139 NC_("SC_OPCODE_RANDOM_NV", "Returns a random number between 0 and 1, non-volatile.") 4140}; 4141 4142// -=*# Resource for function RANDBETWEEN.NV #*=- 4143const char* SC_OPCODE_RANDBETWEEN_NV_ARY[] = 4144{ 4145 NC_("SC_OPCODE_RANDBETWEEN_NV", "Returns a random integer between the numbers you specify, non-volatile."), 4146 NC_("SC_OPCODE_RANDBETWEEN_NV", "Bottom"), 4147 NC_("SC_OPCODE_RANDBETWEEN_NV", "The smallest integer returned."), 4148 NC_("SC_OPCODE_RANDBETWEEN_NV", "Top"), 4149 NC_("SC_OPCODE_RANDBETWEEN_NV", "The largest integer returned.") 4150}; 4151 4152/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ 4153
