1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
3 * This file is part of the LibreOffice project.
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/.
9 * This file incorporates work covered by the following license notice:
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 .
21 #define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String))
23 /* Resource file for the function wizard / autopilot.
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
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.
33 // -=*# Resource for function DCOUNT #*=-
34 const TranslateId SC_OPCODE_DB_COUNT_ARY[] =
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.")
45 // -=*# Resource for function DCOUNTA #*=-
46 const TranslateId SC_OPCODE_DB_COUNT_2_ARY[] =
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.")
57 // -=*# Resource for function DAVERAGE #*=-
58 const TranslateId SC_OPCODE_DB_AVERAGE_ARY[] =
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.")
69 // -=*# Resource for function DGET #*=-
70 const TranslateId SC_OPCODE_DB_GET_ARY[] =
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.")
81 // -=*# Resource for function DMAX #*=-
82 const TranslateId SC_OPCODE_DB_MAX_ARY[] =
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.")
93 // -=*# Resource for function DMIN #*=-
94 const TranslateId SC_OPCODE_DB_MIN_ARY[] =
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.")
105 // -=*# Resource for function DPRODUCT #*=-
106 const TranslateId SC_OPCODE_DB_PRODUCT_ARY[] =
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.")
117 // -=*# Resource for function DSTDEV #*=-
118 const TranslateId SC_OPCODE_DB_STD_DEV_ARY[] =
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.")
129 // -=*# Resource for function DSTDEVP #*=-
130 const TranslateId SC_OPCODE_DB_STD_DEV_P_ARY[] =
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.")
141 // -=*# Resource for function DSUM #*=-
142 const TranslateId SC_OPCODE_DB_SUM_ARY[] =
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.")
153 // -=*# Resource for function DVAR #*=-
154 const TranslateId SC_OPCODE_DB_VAR_ARY[] =
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.")
165 // -=*# Resource for function DVARP #*=-
166 const TranslateId SC_OPCODE_DB_VAR_P_ARY[] =
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.")
177 // -=*# Resource for function DATE #*=-
178 const TranslateId SC_OPCODE_GET_DATE_ARY[] =
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.")
189 // -=*# Resource for function DATE_VALUE #*=-
190 const TranslateId SC_OPCODE_GET_DATE_VALUE_ARY[] =
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.")
197 // -=*# Resource for function DAY #*=-
198 const TranslateId SC_OPCODE_GET_DAY_ARY[] =
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.")
205 // -=*# Resource for function DAYS360 #*=-
206 const TranslateId SC_OPCODE_GET_DIFF_DATE_360_ARY[] =
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.")
217 // -=*# Resource for function NETWORKDAYS #*=-
218 const TranslateId SC_OPCODE_NETWORKDAYS_ARY[] =
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.")
231 // -=*# Resource for function NETWORKDAYS.INTL #*=-
232 const TranslateId SC_OPCODE_NETWORKDAYS_MS_ARY[] =
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.")
245 // -=*# Resource for function WORKDAY.INTL #*=-
246 const TranslateId SC_OPCODE_WORKDAY_MS_ARY[] =
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.")
259 // -=*# Resource for function HOUR #*=-
260 const TranslateId SC_OPCODE_GET_HOUR_ARY[] =
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")
267 // -=*# Resource for function MINUTE #*=-
268 const TranslateId SC_OPCODE_GET_MIN_ARY[] =
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.")
275 // -=*# Resource for function MONTH #*=-
276 const TranslateId SC_OPCODE_GET_MONTH_ARY[] =
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.")
283 // -=*# Resource for function NOW #*=-
284 const TranslateId SC_OPCODE_GET_ACT_TIME_ARY[] =
286 NC_("SC_OPCODE_GET_ACT_TIME", "Determines the current time of the computer.")
289 // -=*# Resource for function SECOND #*=-
290 const TranslateId SC_OPCODE_GET_SEC_ARY[] =
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.")
297 // -=*# Resource for function TIME #*=-
298 const TranslateId SC_OPCODE_GET_TIME_ARY[] =
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.")
309 // -=*# Resource for function TIMEVALUE #*=-
310 const TranslateId SC_OPCODE_GET_TIME_VALUE_ARY[] =
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.")
317 // -=*# Resource for function TODAY #*=-
318 const TranslateId SC_OPCODE_GET_ACT_DATE_ARY[] =
320 NC_("SC_OPCODE_GET_ACT_DATE", "Determines the current date of the computer.")
323 // -=*# Resource for function WEEKDAY #*=-
324 const TranslateId SC_OPCODE_GET_DAY_OF_WEEK_ARY[] =
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.")
333 // -=*# Resource for function YEAR #*=-
334 const TranslateId SC_OPCODE_GET_YEAR_ARY[] =
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.")
341 // -=*# Resource for function DAYS #*=-
342 const TranslateId SC_OPCODE_GET_DIFF_DATE_ARY[] =
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.")
351 // -=*# Resource for function DATEDIF #*=-
352 const TranslateId SC_OPCODE_GET_DATEDIF_ARY[] =
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\".")
363 // -=*# Resource for function WEEKNUM #*=-
364 const TranslateId SC_OPCODE_WEEK_ARY[] =
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.")
373 // -=*# Resource for function ISOWEEKNUM #*=-
374 const TranslateId SC_OPCODE_ISOWEEKNUM_ARY[] =
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.")
381 const TranslateId SC_OPCODE_WEEKNUM_OOO_ARY[] =
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).")
390 // -=*# Resource for function EASTERSUNDAY #*=-
391 const TranslateId SC_OPCODE_EASTERSUNDAY_ARY[] =
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).")
398 // -=*# Resource for function PV #*=-
399 const TranslateId SC_OPCODE_PV_ARY[] =
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.")
414 // -=*# Resource for function FV #*=-
415 const TranslateId SC_OPCODE_FV_ARY[] =
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.")
430 // -=*# Resource for function NPER #*=-
431 const TranslateId SC_OPCODE_NPER_ARY[] =
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.")
446 // -=*# Resource for function PMT #*=-
447 const TranslateId SC_OPCODE_PMT_ARY[] =
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.")
462 // -=*# Resource for function RATE #*=-
463 const TranslateId SC_OPCODE_RATE_ARY[] =
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.")
480 // -=*# Resource for function IPMT #*=-
481 const TranslateId SC_OPCODE_IPMT_ARY[] =
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.")
498 // -=*# Resource for function PPMT #*=-
499 const TranslateId SC_OPCODE_PPMT_ARY[] =
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.")
516 // -=*# Resource for function CUMPRINC #*=-
517 const TranslateId SC_OPCODE_CUM_PRINC_ARY[] =
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.")
534 // -=*# Resource for function CUMIPMT #*=-
535 const TranslateId SC_OPCODE_CUM_IPMT_ARY[] =
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.")
552 // -=*# Resource for function SYD #*=-
553 const TranslateId SC_OPCODE_SYD_ARY[] =
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.")
566 // -=*# Resource for function SLN #*=-
567 const TranslateId SC_OPCODE_SLN_ARY[] =
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.")
578 // -=*# Resource for function DDB #*=-
579 const TranslateId SC_OPCODE_DDB_ARY[] =
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")
594 // -=*# Resource for function DB #*=-
595 const TranslateId SC_OPCODE_DB_ARY[] =
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.")
610 // -=*# Resource for function VDB #*=-
611 const TranslateId SC_OPCODE_VBD_ARY[] =
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.")
630 // -=*# Resource for function EFFECT #*=-
631 const TranslateId SC_OPCODE_EFFECT_ARY[] =
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.")
640 // -=*# Resource for function NOMINAL #*=-
641 const TranslateId SC_OPCODE_NOMINAL_ARY[] =
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.")
650 // -=*# Resource for function NPV #*=-
651 const TranslateId SC_OPCODE_NPV_ARY[] =
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.")
660 // -=*# Resource for function IRR #*=-
661 const TranslateId SC_OPCODE_IRR_ARY[] =
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.")
670 // -=*# Resource for function MIRR #*=-
671 const TranslateId SC_OPCODE_MIRR_ARY[] =
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).")
682 // -=*# Resource for function ISPMT #*=-
683 const TranslateId SC_OPCODE_ISPMT_ARY[] =
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.")
696 // -=*# Resource for function PDURATION #*=-
697 const TranslateId SC_OPCODE_PDURATION_ARY[] =
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.")
708 // -=*# Resource for function RRI #*=-
709 const TranslateId SC_OPCODE_RRI_ARY[] =
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.")
720 // -=*# Resource for function ISREF #*=-
721 const TranslateId SC_OPCODE_IS_REF_ARY[] =
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.")
728 // -=*# Resource for function ISERR #*=-
729 const TranslateId SC_OPCODE_IS_ERR_ARY[] =
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.")
736 // -=*# Resource for function ISERROR #*=-
737 const TranslateId SC_OPCODE_IS_ERROR_ARY[] =
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.")
744 // -=*# Resource for function ISBLANK #*=-
745 const TranslateId SC_OPCODE_IS_EMPTY_ARY[] =
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.")
752 // -=*# Resource for function ISLOGICAL #*=-
753 const TranslateId SC_OPCODE_IS_LOGICAL_ARY[] =
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.")
760 // -=*# Resource for function ISNA #*=-
761 const TranslateId SC_OPCODE_IS_NV_ARY[] =
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.")
768 // -=*# Resource for function ISNONTEXT #*=-
769 const TranslateId SC_OPCODE_IS_NON_STRING_ARY[] =
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.")
776 // -=*# Resource for function ISTEXT #*=-
777 const TranslateId SC_OPCODE_IS_STRING_ARY[] =
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.")
784 // -=*# Resource for function ISNUMBER #*=-
785 const TranslateId SC_OPCODE_IS_VALUE_ARY[] =
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.")
792 // -=*# Resource for function ISFORMULA #*=-
793 const TranslateId SC_OPCODE_IS_FORMULA_ARY[] =
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.")
800 // -=*# Resource for function FORMULA #*=-
801 const TranslateId SC_OPCODE_FORMULA_ARY[] =
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.")
808 // -=*# Resource for function N #*=-
809 const TranslateId SC_OPCODE_N_ARY[] =
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.")
816 // -=*# Resource for function NA #*=-
817 const TranslateId SC_OPCODE_NO_VALUE_ARY[] =
819 NC_("SC_OPCODE_NO_VALUE", "Not available. Returns the error value #N/A.")
822 // -=*# Resource for function TYPE #*=-
823 const TranslateId SC_OPCODE_TYPE_ARY[] =
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.")
830 // -=*# Resource for function CELL #*=-
831 const TranslateId SC_OPCODE_CELL_ARY[] =
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.")
840 // -=*# Resource for function CURRENT #*=-
841 const TranslateId SC_OPCODE_CURRENT_ARY[] =
843 NC_("SC_OPCODE_CURRENT", "Calculates the current value of the formula at the present location.")
846 // -=*# Resource for function FALSE #*=-
847 const TranslateId SC_OPCODE_FALSE_ARY[] =
849 NC_("SC_OPCODE_FALSE", "Defines the logical value as FALSE.")
852 // -=*# Resource for function NOT #*=-
853 const TranslateId SC_OPCODE_NOT_ARY[] =
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.")
860 // -=*# Resource for function TRUE #*=-
861 const TranslateId SC_OPCODE_TRUE_ARY[] =
863 NC_("SC_OPCODE_TRUE", "Returns the logical value TRUE.")
866 // -=*# Resource for function IF #*=-
867 const TranslateId SC_OPCODE_IF_ARY[] =
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.")
878 // -=*# Resource for function IFERROR #*=-
879 const TranslateId SC_OPCODE_IF_ERROR_ARY[] =
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.")
888 // -=*# Resource for function IFNA #*=-
889 const TranslateId SC_OPCODE_IF_NA_ARY[] =
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.")
898 // -=*# Resource for function OR #*=-
899 const TranslateId SC_OPCODE_OR_ARY[] =
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.")
906 // -=*# Resource for function XOR #*=-
907 const TranslateId SC_OPCODE_XOR_ARY[] =
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.")
914 // -=*# Resource for function AND #*=-
915 const TranslateId SC_OPCODE_AND_ARY[] =
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.")
922 // -=*# Resource for function ABS #*=-
923 const TranslateId SC_OPCODE_ABS_ARY[] =
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.")
930 // -=*# Resource for function POWER #*=-
931 const TranslateId SC_OPCODE_POWER_ARY[] =
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.")
940 // -=*# Resource for function COUNTBLANK #*=-
941 const TranslateId SC_OPCODE_COUNT_EMPTY_CELLS_ARY[] =
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.")
948 // -=*# Resource for function PI #*=-
949 const TranslateId SC_OPCODE_PI_ARY[] =
951 NC_("SC_OPCODE_PI", "Returns the value of the number Pi.")
954 // -=*# Resource for function SUM #*=-
955 const TranslateId SC_OPCODE_SUM_ARY[] =
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.")
962 // -=*# Resource for function SUMSQ #*=-
963 const TranslateId SC_OPCODE_SUM_SQ_ARY[] =
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.")
970 // -=*# Resource for function PRODUCT #*=-
971 const TranslateId SC_OPCODE_PRODUCT_ARY[] =
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.")
978 // -=*# Resource for function SUMIF #*=-
979 const TranslateId SC_OPCODE_SUM_IF_ARY[] =
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.")
990 // -=*# Resource for function AVERAGEIF #*=-
991 const TranslateId SC_OPCODE_AVERAGE_IF_ARY[] =
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.")
1002 const TranslateId SC_OPCODE_SUM_IFS_ARY[] =
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.")
1013 // -=*# Resource for function AVERAGEIFS #*=-
1014 const TranslateId SC_OPCODE_AVERAGE_IFS_ARY[] =
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.")
1025 // -=*# Resource for function COUNTIFS #*=-
1026 const TranslateId SC_OPCODE_COUNT_IFS_ARY[] =
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.")
1035 // -=*# Resource for function COUNTIF #*=-
1036 const TranslateId SC_OPCODE_COUNT_IF_ARY[] =
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.")
1045 // -=*# Resource for function SQRT #*=-
1046 const TranslateId SC_OPCODE_SQRT_ARY[] =
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.")
1053 // -=*# Resource for function RAND #*=-
1054 const TranslateId SC_OPCODE_RANDOM_ARY[] =
1056 NC_("SC_OPCODE_RANDOM", "Returns a random number between 0 and 1.")
1059 // -=*# Resource for function ISEVEN #*=-
1060 const TranslateId SC_OPCODE_IS_EVEN_ARY[] =
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.")
1067 // -=*# Resource for function ISODD #*=-
1068 const TranslateId SC_OPCODE_IS_ODD_ARY[] =
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.")
1075 // -=*# Resource for function COMBIN #*=-
1076 const TranslateId SC_OPCODE_COMBIN_ARY[] =
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.")
1085 // -=*# Resource for function COMBINA #*=-
1086 const TranslateId SC_OPCODE_COMBIN_A_ARY[] =
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.")
1095 // -=*# Resource for function ARCCOS #*=-
1096 const TranslateId SC_OPCODE_ARC_COS_ARY[] =
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.")
1103 // -=*# Resource for function ARCSIN #*=-
1104 const TranslateId SC_OPCODE_ARC_SIN_ARY[] =
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.")
1111 // -=*# Resource for function ARCCOSHYP #*=-
1112 const TranslateId SC_OPCODE_ARC_COS_HYP_ARY[] =
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.")
1119 // -=*# Resource for function ARCSINHYP #*=-
1120 const TranslateId SC_OPCODE_ARC_SIN_HYP_ARY[] =
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.")
1127 // -=*# Resource for function ARCCOT #*=-
1128 const TranslateId SC_OPCODE_ARC_COT_ARY[] =
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.")
1135 // -=*# Resource for function ARCTAN #*=-
1136 const TranslateId SC_OPCODE_ARC_TAN_ARY[] =
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.")
1143 // -=*# Resource for function ARCCOTHYP #*=-
1144 const TranslateId SC_OPCODE_ARC_COT_HYP_ARY[] =
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.")
1151 // -=*# Resource for function ARCTANHYP #*=-
1152 const TranslateId SC_OPCODE_ARC_TAN_HYP_ARY[] =
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.")
1159 // -=*# Resource for function COS #*=-
1160 const TranslateId SC_OPCODE_COS_ARY[] =
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.")
1167 // -=*# Resource for function SIN #*=-
1168 const TranslateId SC_OPCODE_SIN_ARY[] =
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.")
1175 // -=*# Resource for function COT #*=-
1176 const TranslateId SC_OPCODE_COT_ARY[] =
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.")
1183 // -=*# Resource for function TAN #*=-
1184 const TranslateId SC_OPCODE_TAN_ARY[] =
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.")
1191 // -=*# Resource for function COSHYP #*=-
1192 const TranslateId SC_OPCODE_COS_HYP_ARY[] =
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.")
1199 // -=*# Resource for function SINHYP #*=-
1200 const TranslateId SC_OPCODE_SIN_HYP_ARY[] =
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.")
1207 // -=*# Resource for function COTHYP #*=-
1208 const TranslateId SC_OPCODE_COT_HYP_ARY[] =
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.")
1215 // -=*# Resource for function TANHYP #*=-
1216 const TranslateId SC_OPCODE_TAN_HYP_ARY[] =
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.")
1223 // -=*# Resource for function ARCTAN2 #*=-
1224 const TranslateId SC_OPCODE_ARC_TAN_2_ARY[] =
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.")
1233 // -=*# Resource for function CSC #*=-
1234 const TranslateId SC_OPCODE_COSECANT_ARY[] =
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.")
1241 // -=*# Resource for function SEC #*=-
1242 const TranslateId SC_OPCODE_SECANT_ARY[] =
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.")
1249 // -=*# Resource for function CSCH #*=-
1250 const TranslateId SC_OPCODE_COSECANT_HYP_ARY[] =
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.")
1257 // -=*# Resource for function SECH #*=-
1258 const TranslateId SC_OPCODE_SECANT_HYP_ARY[] =
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.")
1265 // -=*# Resource for function DEG #*=-
1266 const TranslateId SC_OPCODE_DEG_ARY[] =
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")
1273 // -=*# Resource for function RAD #*=-
1274 const TranslateId SC_OPCODE_RAD_ARY[] =
1276 NC_("SC_OPCODE_RAD", "Converts degrees to radians"),
1277 NC_("SC_OPCODE_RAD", "Number"),
1278 NC_("SC_OPCODE_RAD", "The angle in degrees.")
1281 // -=*# Resource for function EXP #*=-
1282 const TranslateId SC_OPCODE_EXP_ARY[] =
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.")
1289 // -=*# Resource for function LOG #*=-
1290 const TranslateId SC_OPCODE_LOG_ARY[] =
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.")
1299 // -=*# Resource for function LN #*=-
1300 const TranslateId SC_OPCODE_LN_ARY[] =
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.")
1307 // -=*# Resource for function LOG10 #*=-
1308 const TranslateId SC_OPCODE_LOG10_ARY[] =
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.")
1315 // -=*# Resource for function FACT #*=-
1316 const TranslateId SC_OPCODE_FACT_ARY[] =
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.")
1323 // -=*# Resource for function MOD #*=-
1324 const TranslateId SC_OPCODE_MOD_ARY[] =
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.")
1333 // -=*# Resource for function SIGN #*=-
1334 const TranslateId SC_OPCODE_PLUS_MINUS_ARY[] =
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.")
1341 // -=*# Resource for function SUBTOTAL #*=-
1342 const TranslateId SC_OPCODE_SUB_TOTAL_ARY[] =
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.")
1351 // -=*# Resource for function AGGREGATE #*=-
1352 const TranslateId SC_OPCODE_AGGREGATE_ARY[] =
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.")
1365 // -=*# Resource for function INT #*=-
1366 const TranslateId SC_OPCODE_INT_ARY[] =
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.")
1373 // -=*# Resource for function TRUNC #*=-
1374 const TranslateId SC_OPCODE_TRUNC_ARY[] =
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.")
1383 // -=*# Resource for function ROUND #*=-
1384 const TranslateId SC_OPCODE_ROUND_ARY[] =
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.")
1393 // -=*# Resource for function ROUNDUP #*=-
1394 const TranslateId SC_OPCODE_ROUND_UP_ARY[] =
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.")
1403 // -=*# Resource for function ROUNDDOWN #*=-
1404 const TranslateId SC_OPCODE_ROUND_DOWN_ARY[] =
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.")
1413 // -=*# Resource for function EVEN #*=-
1414 const TranslateId SC_OPCODE_EVEN_ARY[] =
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.")
1421 // -=*# Resource for function ODD #*=-
1422 const TranslateId SC_OPCODE_ODD_ARY[] =
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.")
1429 // -=*# Resource for function CEILING.XCL #*=-
1430 const TranslateId SC_OPCODE_CEIL_MS_ARY[] =
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.")
1439 // -=*# Resource for function CEILING.PRECISE #*=-
1440 const TranslateId SC_OPCODE_CEIL_PRECISE_ARY[] =
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.")
1449 // -=*# Resource for function ISO.CEILING #*=-
1450 const TranslateId SC_OPCODE_CEIL_ISO_ARY[] =
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.")
1459 // -=*# Resource for function CEILING #*=-
1460 const TranslateId SC_OPCODE_CEIL_ARY[] =
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.")
1471 // -=*# Resource for function CEILING.MATH #*=-
1472 const TranslateId SC_OPCODE_CEIL_MATH_ARY[] =
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.")
1483 // -=*# Resource for function FLOOR #*=-
1484 const TranslateId SC_OPCODE_FLOOR_ARY[] =
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.")
1495 // -=*# Resource for function FLOOR.XCL #*=-
1496 const TranslateId SC_OPCODE_FLOOR_MS_ARY[] =
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.")
1505 // -=*# Resource for function FLOOR.MATH #*=-
1506 const TranslateId SC_OPCODE_FLOOR_MATH_ARY[] =
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.")
1517 // -=*# Resource for function FLOOR.PRECISE #*=-
1518 const TranslateId SC_OPCODE_FLOOR_PRECISE_ARY[] =
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.")
1527 // -=*# Resource for function GCD #*=-
1528 const TranslateId SC_OPCODE_GCD_ARY[] =
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.")
1535 // -=*# Resource for function LCM #*=-
1536 const TranslateId SC_OPCODE_LCM_ARY[] =
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.")
1543 // -=*# Resource for function TRANSPOSE #*=-
1544 const TranslateId SC_OPCODE_MAT_TRANS_ARY[] =
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.")
1551 // -=*# Resource for function MMULT #*=-
1552 const TranslateId SC_OPCODE_MAT_MULT_ARY[] =
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.")
1561 // -=*# Resource for function MDETERM #*=-
1562 const TranslateId SC_OPCODE_MAT_DET_ARY[] =
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.")
1569 // -=*# Resource for function MINVERSE #*=-
1570 const TranslateId SC_OPCODE_MAT_INV_ARY[] =
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.")
1577 // -=*# Resource for function MUNIT #*=-
1578 const TranslateId SC_OPCODE_MATRIX_UNIT_ARY[] =
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.")
1585 // -=*# Resource for function SUMPRODUCT #*=-
1586 const TranslateId SC_OPCODE_SUM_PRODUCT_ARY[] =
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.")
1593 // -=*# Resource for function SUMX2MY2 #*=-
1594 const TranslateId SC_OPCODE_SUM_X2MY2_ARY[] =
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.")
1603 // -=*# Resource for function SUMX2PY2 #*=-
1604 const TranslateId SC_OPCODE_SUM_X2DY2_ARY[] =
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.")
1613 // -=*# Resource for function SUMXMY2 #*=-
1614 const TranslateId SC_OPCODE_SUM_XMY2_ARY[] =
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.")
1623 // -=*# Resource for function FREQUENCY #*=-
1624 const TranslateId SC_OPCODE_FREQUENCY_ARY[] =
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.")
1633 // -=*# Resource for function LINEST #*=-
1634 const TranslateId SC_OPCODE_LINEST_ARY[] =
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.")
1647 // -=*# Resource for function LOGEST #*=-
1648 const TranslateId SC_OPCODE_LOGEST_ARY[] =
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.")
1661 // -=*# Resource for function TREND #*=-
1662 const TranslateId SC_OPCODE_TREND_ARY[] =
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.")
1675 // -=*# Resource for function GROWTH #*=-
1676 const TranslateId SC_OPCODE_GROWTH_ARY[] =
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.")
1689 // -=*# Resource for function COUNT #*=-
1690 const TranslateId SC_OPCODE_COUNT_ARY[] =
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.")
1697 // -=*# Resource for function COUNTA #*=-
1698 const TranslateId SC_OPCODE_COUNT_2_ARY[] =
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.")
1705 // -=*# Resource for function MAX #*=-
1706 const TranslateId SC_OPCODE_MAX_ARY[] =
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.")
1713 // -=*# Resource for function MAXA #*=-
1714 const TranslateId SC_OPCODE_MAX_A_ARY[] =
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.")
1721 // -=*# Resource for function MIN #*=-
1722 const TranslateId SC_OPCODE_MIN_ARY[] =
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.")
1729 // -=*# Resource for function MINA #*=-
1730 const TranslateId SC_OPCODE_MIN_A_ARY[] =
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.")
1737 // -=*# Resource for function VAR #*=-
1738 const TranslateId SC_OPCODE_VAR_ARY[] =
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.")
1745 // -=*# Resource for function VAR.S #*=-
1746 const TranslateId SC_OPCODE_VAR_S_ARY[] =
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.")
1753 // -=*# Resource for function VARA #*=-
1754 const TranslateId SC_OPCODE_VAR_A_ARY[] =
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.")
1761 // -=*# Resource for function VARP #*=-
1762 const TranslateId SC_OPCODE_VAR_P_ARY[] =
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.")
1769 // -=*# Resource for function VAR.P #*=-
1770 const TranslateId SC_OPCODE_VAR_P_MS_ARY[] =
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.")
1777 // -=*# Resource for function VARPA #*=-
1778 const TranslateId SC_OPCODE_VAR_P_A_ARY[] =
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.")
1785 // -=*# Resource for function STDEV #*=-
1786 const TranslateId SC_OPCODE_ST_DEV_ARY[] =
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.")
1793 // -=*# Resource for function STDEV.S #*=-
1794 const TranslateId SC_OPCODE_ST_DEV_S_ARY[] =
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.")
1801 // -=*# Resource for function STDEVA #*=-
1802 const TranslateId SC_OPCODE_ST_DEV_A_ARY[] =
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.")
1809 // -=*# Resource for function STDEVP #*=-
1810 const TranslateId SC_OPCODE_ST_DEV_P_ARY[] =
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.")
1817 // -=*# Resource for function STDEV.P #*=-
1818 const TranslateId SC_OPCODE_ST_DEV_P_MS_ARY[] =
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.")
1825 // -=*# Resource for function STDEVPA #*=-
1826 const TranslateId SC_OPCODE_ST_DEV_P_A_ARY[] =
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.")
1833 // -=*# Resource for function AVERAGE #*=-
1834 const TranslateId SC_OPCODE_AVERAGE_ARY[] =
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.")
1841 // -=*# Resource for function AVERAGEA #*=-
1842 const TranslateId SC_OPCODE_AVERAGE_A_ARY[] =
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.")
1849 // -=*# Resource for function DEVSQ #*=-
1850 const TranslateId SC_OPCODE_DEV_SQ_ARY[] =
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.")
1857 // -=*# Resource for function AVEDEV #*=-
1858 const TranslateId SC_OPCODE_AVE_DEV_ARY[] =
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.")
1865 // -=*# Resource for function SKEW #*=-
1866 const TranslateId SC_OPCODE_SKEW_ARY[] =
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.")
1873 // -=*# Resource for function SKEWP #*=-
1874 const TranslateId SC_OPCODE_SKEWP_ARY[] =
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.")
1881 // -=*# Resource for function KURT #*=-
1882 const TranslateId SC_OPCODE_KURT_ARY[] =
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.")
1889 // -=*# Resource for function GEOMEAN #*=-
1890 const TranslateId SC_OPCODE_GEO_MEAN_ARY[] =
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.")
1897 // -=*# Resource for function HARMEAN #*=-
1898 const TranslateId SC_OPCODE_HAR_MEAN_ARY[] =
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.")
1905 // -=*# Resource for function MODE #*=-
1906 const TranslateId SC_OPCODE_MODAL_VALUE_ARY[] =
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.")
1913 // -=*# Resource for function MODE.SNGL #*=-
1914 const TranslateId SC_OPCODE_MODAL_VALUE_MS_ARY[] =
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.")
1921 // -=*# Resource for function MODE.MULT #*=-
1922 const TranslateId SC_OPCODE_MODAL_VALUE_MULTI_ARY[] =
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.")
1929 // -=*# Resource for function MEDIAN #*=-
1930 const TranslateId SC_OPCODE_MEDIAN_ARY[] =
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.")
1937 // -=*# Resource for function PERCENTILE #*=-
1938 const TranslateId SC_OPCODE_PERCENTILE_ARY[] =
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.")
1947 // -=*# Resource for function PERCENTILE.EXC #*=-
1948 const TranslateId SC_OPCODE_PERCENTILE_EXC_ARY[] =
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.")
1957 // -=*# Resource for function PERCENTILE.INC #*=-
1958 const TranslateId SC_OPCODE_PERCENTILE_INC_ARY[] =
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.")
1967 // -=*# Resource for function QUARTILE #*=-
1968 const TranslateId SC_OPCODE_QUARTILE_ARY[] =
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).")
1977 // -=*# Resource for function QUARTILE.EXC #*=-
1978 const TranslateId SC_OPCODE_QUARTILE_EXC_ARY[] =
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%).")
1987 // -=*# Resource for function QUARTILE.INC #*=-
1988 const TranslateId SC_OPCODE_QUARTILE_INC_ARY[] =
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).")
1997 // -=*# Resource for function LARGE #*=-
1998 const TranslateId SC_OPCODE_LARGE_ARY[] =
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.")
2007 // -=*# Resource for function SMALL #*=-
2008 const TranslateId SC_OPCODE_SMALL_ARY[] =
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.")
2017 // -=*# Resource for function PERCENTRANK #*=-
2018 const TranslateId SC_OPCODE_PERCENT_RANK_ARY[] =
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.")
2029 // -=*# Resource for function PERCENTRANK.EXC #*=-
2030 const TranslateId SC_OPCODE_PERCENT_RANK_EXC_ARY[] =
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.")
2041 // -=*# Resource for function PERCENTRANK.INC #*=-
2042 const TranslateId SC_OPCODE_PERCENT_RANK_INC_ARY[] =
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.")
2053 // -=*# Resource for function RANK #*=-
2054 const TranslateId SC_OPCODE_RANK_ARY[] =
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.")
2065 // -=*# Resource for function RANK.EQ #*=-
2066 const TranslateId SC_OPCODE_RANK_EQ_ARY[] =
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.")
2077 // -=*# Resource for function RANK.AVG #*=-
2078 const TranslateId SC_OPCODE_RANK_AVG_ARY[] =
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.")
2089 // -=*# Resource for function TRIMMEAN #*=-
2090 const TranslateId SC_OPCODE_TRIM_MEAN_ARY[] =
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.")
2099 // -=*# Resource for function PROB #*=-
2100 const TranslateId SC_OPCODE_PROB_ARY[] =
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.")
2113 // -=*# Resource for function B #*=-
2114 const TranslateId SC_OPCODE_B_ARY[] =
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.")
2127 // -=*# Resource for function PHI #*=-
2128 const TranslateId SC_OPCODE_PHI_ARY[] =
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.")
2135 // -=*# Resource for function GAUSS #*=-
2136 const TranslateId SC_OPCODE_GAUSS_ARY[] =
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.")
2143 // -=*# Resource for function FISHER #*=-
2144 const TranslateId SC_OPCODE_FISHER_ARY[] =
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).")
2151 // -=*# Resource for function FISHERINV #*=-
2152 const TranslateId SC_OPCODE_FISHER_INV_ARY[] =
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.")
2159 // -=*# Resource for function BINOMDIST #*=-
2160 const TranslateId SC_OPCODE_BINOM_DIST_ARY[] =
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.")
2173 // -=*# Resource for function BINOM.DIST #*=-
2174 const TranslateId SC_OPCODE_BINOM_DIST_MS_ARY[] =
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.")
2187 // -=*# Resource for function NEGBINOMDIST #*=-
2188 const TranslateId SC_OPCODE_NEG_BINOM_VERT_ARY[] =
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.")
2199 // -=*# Resource for function NEGBINOM.DIST #*=-
2200 const TranslateId SC_OPCODE_NEG_BINOM_DIST_MS_ARY[] =
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.")
2213 // -=*# Resource for function CRITBINOM #*=-
2214 const TranslateId SC_OPCODE_CRIT_BINOM_ARY[] =
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.")
2225 // -=*# Resource for function BINOM.INV #*=-
2226 const TranslateId SC_OPCODE_BINOM_INV_ARY[] =
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.")
2237 // -=*# Resource for function POISSON #*=-
2238 const TranslateId SC_OPCODE_POISSON_DIST_ARY[] =
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.")
2249 // -=*# Resource for function POISSON.DIST #*=-
2250 const TranslateId SC_OPCODE_POISSON_DIST_MS_ARY[] =
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.")
2261 // -=*# Resource for function NORMDIST #*=-
2262 const TranslateId SC_OPCODE_NORM_DIST_ARY[] =
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.")
2275 // -=*# Resource for function NORM.DIST #*=-
2276 const TranslateId SC_OPCODE_NORM_DIST_MS_ARY[] =
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.")
2289 // -=*# Resource for function NORMINV #*=-
2290 const TranslateId SC_OPCODE_NORM_INV_ARY[] =
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.")
2301 // -=*# Resource for function NORM.INV #*=-
2302 const TranslateId SC_OPCODE_NORM_INV_MS_ARY[] =
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.")
2313 // -=*# Resource for function NORMSDIST #*=-
2314 const TranslateId SC_OPCODE_STD_NORM_DIST_ARY[] =
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.")
2321 // -=*# Resource for function NORM.S.DIST #*=-
2322 const TranslateId SC_OPCODE_STD_NORM_DIST_MS_ARY[] =
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.")
2331 // -=*# Resource for function NORMSINV #*=-
2332 const TranslateId SC_OPCODE_S_NORM_INV_ARY[] =
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.")
2339 // -=*# Resource for function NORM.S.INV #*=-
2340 const TranslateId SC_OPCODE_S_NORM_INV_MS_ARY[] =
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.")
2347 // -=*# Resource for function LOGNORMDIST #*=-
2348 const TranslateId SC_OPCODE_LOG_NORM_DIST_ARY[] =
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.")
2361 // -=*# Resource for function LOGNORM.DIST #*=-
2362 const TranslateId SC_OPCODE_LOG_NORM_DIST_MS_ARY[] =
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.")
2375 // -=*# Resource for function LOGINV #*=-
2376 const TranslateId SC_OPCODE_LOG_INV_ARY[] =
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.")
2387 // -=*# Resource for function LOGNORM.INV #*=-
2388 const TranslateId SC_OPCODE_LOG_INV_MS_ARY[] =
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.")
2399 // -=*# Resource for function EXPONDIST #*=-
2400 const TranslateId SC_OPCODE_EXP_DIST_ARY[] =
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.")
2411 // -=*# Resource for function EXPON.DIST #*=-
2412 const TranslateId SC_OPCODE_EXP_DIST_MS_ARY[] =
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.")
2423 // -=*# Resource for function GAMMADIST #*=-
2424 const TranslateId SC_OPCODE_GAMMA_DIST_ARY[] =
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.")
2437 // -=*# Resource for function GAMMA.DIST #*=-
2438 const TranslateId SC_OPCODE_GAMMA_DIST_MS_ARY[] =
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.")
2451 // -=*# Resource for function GAMMAINV #*=-
2452 const TranslateId SC_OPCODE_GAMMA_INV_ARY[] =
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.")
2463 // -=*# Resource for function GAMMA.INV #*=-
2464 const TranslateId SC_OPCODE_GAMMA_INV_MS_ARY[] =
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.")
2475 // -=*# Resource for function GAMMALN #*=-
2476 const TranslateId SC_OPCODE_GAMMA_LN_ARY[] =
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.")
2483 // -=*# Resource for function GAMMALN.PRECISE #*=-
2484 const TranslateId SC_OPCODE_GAMMA_LN_MS_ARY[] =
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.")
2492 // -=*# Resource for function GAMMA #*=-
2493 const TranslateId SC_OPCODE_GAMMA_ARY[] =
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.")
2501 // -=*# Resource for function BETADIST #*=-
2502 const TranslateId SC_OPCODE_BETA_DIST_ARY[] =
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.")
2519 // -=*# Resource for function BETAINV #*=-
2520 const TranslateId SC_OPCODE_BETA_INV_ARY[] =
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.")
2535 // -=*# Resource for function BETA.DIST #*=-
2536 const TranslateId SC_OPCODE_BETA_DIST_MS_ARY[] =
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.")
2553 // -=*# Resource for function BETA.INV #*=-
2554 const TranslateId SC_OPCODE_BETA_INV_MS_ARY[] =
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.")
2569 // -=*# Resource for function WEIBULL #*=-
2570 const TranslateId SC_OPCODE_WEIBULL_ARY[] =
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.")
2583 // -=*# Resource for function WEIBULL.DIST #*=-
2584 const TranslateId SC_OPCODE_WEIBULL_MS_ARY[] =
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.")
2597 // -=*# Resource for function HYPGEOMDIST #*=-
2598 const TranslateId SC_OPCODE_HYP_GEOM_DIST_ARY[] =
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.")
2613 // -=*# Resource for function HYPGEOM.DIST #*=-
2614 const TranslateId SC_OPCODE_HYP_GEOM_DIST_MS_ARY[] =
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.")
2629 // -=*# Resource for function TDIST #*=-
2630 const TranslateId SC_OPCODE_T_DIST_ARY[] =
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.")
2641 // -=*# Resource for function T.DIST.2T #*=-
2642 const TranslateId SC_OPCODE_T_DIST_2T_ARY[] =
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.")
2651 // -=*# Resource for function T.DIST #*=-
2652 const TranslateId SC_OPCODE_T_DIST_MS_ARY[] =
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.")
2663 // -=*# Resource for function T.DIST.RT #*=-
2664 const TranslateId SC_OPCODE_T_DIST_RT_ARY[] =
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.")
2673 // -=*# Resource for function TINV #*=-
2674 const TranslateId SC_OPCODE_T_INV_ARY[] =
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.")
2683 // -=*# Resource for function T.INV #*=-
2684 const TranslateId SC_OPCODE_T_INV_MS_ARY[] =
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.")
2693 // -=*# Resource for function T.INV.2T #*=-
2694 const TranslateId SC_OPCODE_T_INV_2T_ARY[] =
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.")
2703 // -=*# Resource for function FDIST #*=-
2704 const TranslateId SC_OPCODE_F_DIST_ARY[] =
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.")
2715 // -=*# Resource for function F.DIST #*=-
2716 const TranslateId SC_OPCODE_F_DIST_LT_ARY[] =
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).")
2729 // -=*# Resource for function F.DIST.RT #*=-
2730 const TranslateId SC_OPCODE_F_DIST_RT_ARY[] =
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.")
2741 // -=*# Resource for function FINV #*=-
2742 const TranslateId SC_OPCODE_F_INV_ARY[] =
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.")
2753 // -=*# Resource for function F.INV #*=-
2754 const TranslateId SC_OPCODE_F_INV_LT_ARY[] =
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.")
2765 // -=*# Resource for function F.INV.RT #*=-
2766 const TranslateId SC_OPCODE_F_INV_RT_ARY[] =
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.")
2777 // -=*# Resource for function CHIDIST #*=-
2778 const TranslateId SC_OPCODE_CHI_DIST_ARY[] =
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.")
2787 // -=*# Resource for function CHISQ.DIST.RT #*=-
2788 const TranslateId SC_OPCODE_CHI_DIST_MS_ARY[] =
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.")
2798 // -=*# Resource for function CHISQDIST #*=-
2799 const TranslateId SC_OPCODE_CHISQ_DIST_ARY[] =
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.")
2811 // -=*# Resource for function CHISQ.DIST #*=-
2812 const TranslateId SC_OPCODE_CHISQ_DIST_MS_ARY[] =
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.")
2824 // -=*# Resource for function CHIINV #*=-
2825 const TranslateId SC_OPCODE_CHI_INV_ARY[] =
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.")
2835 // -=*# Resource for function CHISQ.INV.RT #*=-
2836 const TranslateId SC_OPCODE_CHI_INV_MS_ARY[] =
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.")
2846 // -=*# Resource for function CHISQINV #*=-
2847 const TranslateId SC_OPCODE_CHISQ_INV_ARY[] =
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.")
2857 // -=*# Resource for function CHISQ.INV #*=-
2858 const TranslateId SC_OPCODE_CHISQ_INV_MS_ARY[] =
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.")
2868 // -=*# Resource for function STANDARDIZE #*=-
2869 const TranslateId SC_OPCODE_STANDARD_ARY[] =
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.")
2880 // -=*# Resource for function PERMUT #*=-
2881 const TranslateId SC_OPCODE_PERMUT_ARY[] =
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.")
2890 // -=*# Resource for function PERMUTATIONA #*=-
2891 const TranslateId SC_OPCODE_PERMUTATION_A_ARY[] =
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.")
2900 // -=*# Resource for function CONFIDENCE #*=-
2901 const TranslateId SC_OPCODE_CONFIDENCE_ARY[] =
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.")
2912 // -=*# Resource for function CONFIDENCE.NORM #*=-
2913 const TranslateId SC_OPCODE_CONFIDENCE_N_ARY[] =
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.")
2924 // -=*# Resource for function CONFIDENCE.T #*=-
2925 const TranslateId SC_OPCODE_CONFIDENCE_T_ARY[] =
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.")
2936 // -=*# Resource for function ZTEST #*=-
2937 const TranslateId SC_OPCODE_Z_TEST_ARY[] =
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.")
2948 // -=*# Resource for function Z.TEST #*=-
2949 const TranslateId SC_OPCODE_Z_TEST_MS_ARY[] =
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.")
2960 // -=*# Resource for function CHITEST #*=-
2961 const TranslateId SC_OPCODE_CHI_TEST_ARY[] =
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.")
2970 // -=*# Resource for function CHISQ.TEST #*=-
2971 const TranslateId SC_OPCODE_CHI_TEST_MS_ARY[] =
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.")
2980 // -=*# Resource for function FTEST #*=-
2981 const TranslateId SC_OPCODE_F_TEST_ARY[] =
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.")
2990 // -=*# Resource for function F.TEST #*=-
2991 const TranslateId SC_OPCODE_F_TEST_MS_ARY[] =
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.")
3000 // -=*# Resource for function TTEST #*=-
3001 const TranslateId SC_OPCODE_T_TEST_ARY[] =
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.")
3014 // -=*# Resource for function T.TEST #*=-
3015 const TranslateId SC_OPCODE_T_TEST_MS_ARY[] =
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.")
3028 // -=*# Resource for function RSQ #*=-
3029 const TranslateId SC_OPCODE_RSQ_ARY[] =
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.")
3038 // -=*# Resource for function INTERCEPT #*=-
3039 const TranslateId SC_OPCODE_INTERCEPT_ARY[] =
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.")
3048 // -=*# Resource for function SLOPE #*=-
3049 const TranslateId SC_OPCODE_SLOPE_ARY[] =
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.")
3058 // -=*# Resource for function STEYX #*=-
3059 const TranslateId SC_OPCODE_STEYX_ARY[] =
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.")
3068 // -=*# Resource for function PEARSON #*=-
3069 const TranslateId SC_OPCODE_PEARSON_ARY[] =
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.")
3078 // -=*# Resource for function CORREL #*=-
3079 const TranslateId SC_OPCODE_CORREL_ARY[] =
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.")
3088 // -=*# Resource for function COVAR #*=-
3089 const TranslateId SC_OPCODE_COVAR_ARY[] =
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.")
3098 // -=*# Resource for function COVARIANCE.P #*=-
3099 const TranslateId SC_OPCODE_COVARIANCE_P_ARY[] =
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.")
3108 // -=*# Resource for function COVARIANCE.S #*=-
3109 const TranslateId SC_OPCODE_COVARIANCE_S_ARY[] =
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.")
3118 // -=*# Resource for function FORECAST #*=-
3119 const TranslateId SC_OPCODE_FORECAST_ARY[] =
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.")
3130 // -=*# Resource for function FORECAST.ETS #*=-
3131 const TranslateId SC_OPCODE_FORECAST_ETS_ADD_ARY[] =
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.")
3148 // -=*# Resource for function FORECAST.ETS.MULT #*=-
3149 const TranslateId SC_OPCODE_FORECAST_ETS_MUL_ARY[] =
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.")
3166 // -=*# Resource for function FORECAST.ETS.CONFINT #*=-
3167 const TranslateId SC_OPCODE_FORECAST_ETS_PIA_ARY[] =
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.")
3186 // -=*# Resource for function FORECAST.ETS.PI.MULT #*=-
3187 const TranslateId SC_OPCODE_FORECAST_ETS_PIM_ARY[] =
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.")
3206 // -=*# Resource for function FORECAST.ETS.SEASONALITY #*=-
3207 const TranslateId SC_OPCODE_FORECAST_ETS_SEA_ARY[] =
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.")
3220 // -=*# Resource for function FORECAST.ETS.STAT #*=-
3221 const TranslateId SC_OPCODE_FORECAST_ETS_STA_ARY[] =
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.")
3238 // -=*# Resource for function FORECAST.ETS.STAT.MULT #*=-
3239 const TranslateId SC_OPCODE_FORECAST_ETS_STM_ARY[] =
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.")
3256 // -=*# Resource for function FORECAST.LINEAR #*=-
3257 const TranslateId SC_OPCODE_FORECAST_LIN_ARY[] =
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.")
3268 // -=*# Resource for function ADDRESS #*=-
3269 const TranslateId SC_OPCODE_ADDRESS_ARY[] =
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.")
3284 // -=*# Resource for function AREAS #*=-
3285 const TranslateId SC_OPCODE_AREAS_ARY[] =
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.")
3292 // -=*# Resource for function CHOOSE #*=-
3293 const TranslateId SC_OPCODE_CHOOSE_ARY[] =
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.")
3302 // -=*# Resource for function COLUMNS #*=-
3303 const TranslateId SC_OPCODE_COLUMN_ARY[] =
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.")
3310 // -=*# Resource for function ROW #*=-
3311 const TranslateId SC_OPCODE_ROW_ARY[] =
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.")
3318 // -=*# Resource for function SHEET #*=-
3319 const TranslateId SC_OPCODE_SHEET_ARY[] =
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.")
3326 // -=*# Resource for function COLUMNS #*=-
3327 const TranslateId SC_OPCODE_COLUMNS_ARY[] =
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.")
3334 // -=*# Resource for function ROWS #*=-
3335 const TranslateId SC_OPCODE_ROWS_ARY[] =
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.")
3342 // -=*# Resource for function SHEETS #*=-
3343 const TranslateId SC_OPCODE_SHEETS_ARY[] =
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.")
3350 // -=*# Resource for function HLOOKUP #*=-
3351 const TranslateId SC_OPCODE_H_LOOKUP_ARY[] =
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.")
3364 // -=*# Resource for function VLOOKUP #*=-
3365 const TranslateId SC_OPCODE_V_LOOKUP_ARY[] =
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.")
3378 // -=*# Resource for function INDEX #*=-
3379 const TranslateId SC_OPCODE_INDEX_ARY[] =
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.")
3392 // -=*# Resource for function INDIRECT #*=-
3393 const TranslateId SC_OPCODE_INDIRECT_ARY[] =
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.")
3402 // -=*# Resource for function LOOKUP #*=-
3403 const TranslateId SC_OPCODE_LOOKUP_ARY[] =
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.")
3414 // -=*# Resource for function MATCH #*=-
3415 const TranslateId SC_OPCODE_MATCH_ARY[] =
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.")
3426 // -=*# Resource for function OFFSET #*=-
3427 const TranslateId SC_OPCODE_OFFSET_ARY[] =
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.")
3442 // -=*# Resource for function ERRORTYPE #*=-
3443 const TranslateId SC_OPCODE_ERROR_TYPE_ARY[] =
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.")
3450 // -=*# Resource for function ERROR.TYPE #*=-
3451 const TranslateId SC_OPCODE_ERROR_TYPE_ODF_ARY[] =
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.")
3458 // -=*# Resource for function STYLE #*=-
3459 const TranslateId SC_OPCODE_STYLE_ARY[] =
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.")
3470 // -=*# Resource for function DDE #*=-
3471 const TranslateId SC_OPCODE_DDE_ARY[] =
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.")
3484 // -=*# Resource for function HYPERLINK #*=-
3485 const TranslateId SC_OPCODE_HYPERLINK_ARY[] =
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.")
3494 // -=*# Resource for function GETPIVOTDATA #*=-
3495 const TranslateId SC_OPCODE_GET_PIVOT_DATA_ARY[] =
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.")
3506 // -=*# Resource for function BAHTTEXT #*=-
3507 const TranslateId SC_OPCODE_BAHTTEXT_ARY[] =
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.")
3514 // -=*# Resource for function JIS #*=-
3515 const TranslateId SC_OPCODE_JIS_ARY[] =
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.")
3522 // -=*# Resource for function ASC #*=-
3523 const TranslateId SC_OPCODE_ASC_ARY[] =
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.")
3530 // -=*# Resource for function CODE #*=-
3531 const TranslateId SC_OPCODE_CODE_ARY[] =
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.")
3538 // -=*# Resource for function DOLLAR #*=-
3539 const TranslateId SC_OPCODE_CURRENCY_ARY[] =
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.")
3548 // -=*# Resource for function CHAR #*=-
3549 const TranslateId SC_OPCODE_CHAR_ARY[] =
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.")
3556 // -=*# Resource for function CLEAN #*=-
3557 const TranslateId SC_OPCODE_CLEAN_ARY[] =
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.")
3564 // -=*# Resource for function CONCATENATE #*=-
3565 const TranslateId SC_OPCODE_CONCAT_ARY[] =
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.")
3572 // -=*# Resource for function CONCAT #*=-
3573 const TranslateId SC_OPCODE_CONCAT_MS_ARY[] =
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.")
3580 // -=*# Resource for function TEXTJOIN #*=-
3581 const TranslateId SC_OPCODE_TEXTJOIN_MS_ARY[] =
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.")
3592 // -=*# Resource for function IFS #*=-
3593 const TranslateId SC_OPCODE_IFS_MS_ARY[] =
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.")
3602 // -=*# Resource for function SWITCH #*=-
3603 const TranslateId SC_OPCODE_SWITCH_MS_ARY[] =
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.")
3614 const TranslateId SC_OPCODE_MINIFS_MS_ARY[] =
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.")
3625 const TranslateId SC_OPCODE_MAXIFS_MS_ARY[] =
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.")
3636 // -=*# Resource for function EXACT #*=-
3637 const TranslateId SC_OPCODE_EXACT_ARY[] =
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.")
3646 // -=*# Resource for function FIND #*=-
3647 const TranslateId SC_OPCODE_FIND_ARY[] =
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.")
3658 // -=*# Resource for function SEARCH #*=-
3659 const TranslateId SC_OPCODE_SEARCH_ARY[] =
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.")
3670 // -=*# Resource for function TRIM #*=-
3671 const TranslateId SC_OPCODE_TRIM_ARY[] =
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.")
3678 // -=*# Resource for function PROPER #*=-
3679 const TranslateId SC_OPCODE_PROPER_ARY[] =
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.")
3686 // -=*# Resource for function UPPER #*=-
3687 const TranslateId SC_OPCODE_UPPER_ARY[] =
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.")
3694 // -=*# Resource for function LOWER #*=-
3695 const TranslateId SC_OPCODE_LOWER_ARY[] =
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.")
3702 // -=*# Resource for function VALUE #*=-
3703 const TranslateId SC_OPCODE_VALUE_ARY[] =
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.")
3710 // -=*# Resource for function TEXT #*=-
3711 const TranslateId SC_OPCODE_TEXT_ARY[] =
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.")
3720 // -=*# Resource for function T #*=-
3721 const TranslateId SC_OPCODE_T_ARY[] =
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.")
3728 // -=*# Resource for function REPLACE #*=-
3729 const TranslateId SC_OPCODE_REPLACE_ARY[] =
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.")
3742 // -=*# Resource for function FIXED #*=-
3743 const TranslateId SC_OPCODE_FIXED_ARY[] =
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.")
3754 // -=*# Resource for function LEN #*=-
3755 const TranslateId SC_OPCODE_LEN_ARY[] =
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.")
3762 // -=*# Resource for function LEFT #*=-
3763 const TranslateId SC_OPCODE_LEFT_ARY[] =
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.")
3772 // -=*# Resource for function RIGHT #*=-
3773 const TranslateId SC_OPCODE_RIGHT_ARY[] =
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.")
3782 // -=*# Resource for function MID #*=-
3783 const TranslateId SC_OPCODE_MID_ARY[] =
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.")
3794 // -=*# Resource for function REPT #*=-
3795 const TranslateId SC_OPCODE_REPT_ARY[] =
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.")
3804 // -=*# Resource for function SUBSTITUTE #*=-
3805 const TranslateId SC_OPCODE_SUBSTITUTE_ARY[] =
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.")
3818 // -=*# Resource for function REGEX #*=-
3819 const TranslateId SC_OPCODE_REGEX_ARY[] =
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.")
3832 // -=*# Resource for function BASE #*=-
3833 const TranslateId SC_OPCODE_BASE_ARY[] =
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.")
3844 // -=*# Resource for function DECIMAL #*=-
3845 const TranslateId SC_OPCODE_DECIMAL_ARY[] =
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.")
3854 // -=*# Resource for function CONVERT_OOO #*=-
3855 const TranslateId SC_OPCODE_CONVERT_OOO_ARY[] =
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.")
3866 // -=*# Resource for function ROMAN #*=-
3867 const TranslateId SC_OPCODE_ROMAN_ARY[] =
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.")
3876 // -=*# Resource for function ARABIC #*=-
3877 const TranslateId SC_OPCODE_ARABIC_ARY[] =
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.")
3884 const TranslateId SC_OPCODE_INFO_ARY[] =
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\".")
3891 const TranslateId SC_OPCODE_UNICODE_ARY[] =
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.")
3898 const TranslateId SC_OPCODE_UNICHAR_ARY[] =
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.")
3905 const TranslateId SC_OPCODE_EUROCONVERT_ARY[] =
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.")
3921 const TranslateId SC_OPCODE_NUMBERVALUE_ARY[] =
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.")
3933 const TranslateId SC_OPCODE_BITAND_ARY[] =
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.")
3942 const TranslateId SC_OPCODE_BITOR_ARY[] =
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.")
3951 const TranslateId SC_OPCODE_BITXOR_ARY[] =
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.")
3960 const TranslateId SC_OPCODE_BITRSHIFT_ARY[] =
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.")
3969 const TranslateId SC_OPCODE_BITLSHIFT_ARY[] =
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.")
3978 const TranslateId SC_OPCODE_LENB_ARY[] =
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.")
3985 const TranslateId SC_OPCODE_RIGHTB_ARY[] =
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.")
3994 const TranslateId SC_OPCODE_LEFTB_ARY[] =
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.")
4003 const TranslateId SC_OPCODE_MIDB_ARY[] =
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.")
4014 const TranslateId SC_OPCODE_FILTERXML_ARY[] =
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")
4023 const TranslateId SC_OPCODE_COLOR_ARY[] =
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")
4036 const TranslateId SC_OPCODE_WEBSERVICE_ARY[] =
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")
4043 const TranslateId SC_OPCODE_ENCODEURL_ARY[] =
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")
4050 const TranslateId SC_OPCODE_ERF_MS_ARY[] =
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")
4057 const TranslateId SC_OPCODE_ERFC_MS_ARY[] =
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")
4064 const TranslateId SC_OPCODE_RAWSUBTRACT_ARY[] =
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.")
4073 // -=*# Resource for function ROUNDSIG #*=-
4074 const TranslateId SC_OPCODE_ROUNDSIG_ARY[] =
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.")
4083 const TranslateId SC_OPCODE_REPLACEB_ARY[] =
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.")
4096 // -=*# Resource for function FINDB #*=-
4097 const TranslateId SC_OPCODE_FINDB_ARY[] =
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.")
4108 // -=*# Resource for function SEARCHB #*=-
4109 const TranslateId SC_OPCODE_SEARCHB_ARY[] =
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.")
4120 // -=*# Resource for function FOURIER #*=-
4121 const TranslateId SC_OPCODE_FOURIER_ARY[] =
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).")
4136 // -=*# Resource for function RAND.NV #*=-
4137 const TranslateId SC_OPCODE_RANDOM_NV_ARY[] =
4139 NC_("SC_OPCODE_RANDOM_NV", "Returns a random number between 0 and 1, non-volatile.")
4142 // -=*# Resource for function RANDBETWEEN.NV #*=-
4143 const TranslateId SC_OPCODE_RANDBETWEEN_NV_ARY[] =
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.")
4152 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */