142
140
#: ../plugins/fn-eng/functions.c:453 ../plugins/fn-eng/functions.c:476
143
141
#: ../plugins/fn-eng/functions.c:499 ../plugins/fn-eng/functions.c:519
144
142
#: ../plugins/fn-eng/functions.c:608 ../plugins/fn-eng/functions.c:637
145
#: ../plugins/fn-eng/functions.c:745 ../plugins/fn-eng/functions.c:1121
146
#: ../plugins/fn-eng/functions.c:1144 ../plugins/fn-info/functions.c:97
147
#: ../plugins/fn-info/functions.c:1285 ../plugins/fn-info/functions.c:1351
148
#: ../plugins/fn-info/functions.c:1440 ../plugins/fn-info/functions.c:1458
149
#: ../plugins/fn-info/functions.c:1480 ../plugins/fn-info/functions.c:1507
150
#: ../plugins/fn-info/functions.c:1534 ../plugins/fn-info/functions.c:1571
151
#: ../plugins/fn-info/functions.c:1587 ../plugins/fn-info/functions.c:1609
152
#: ../plugins/fn-info/functions.c:1626 ../plugins/fn-info/functions.c:1644
153
#: ../plugins/fn-info/functions.c:1661 ../plugins/fn-info/functions.c:1683
154
#: ../plugins/fn-info/functions.c:1703 ../plugins/fn-info/functions.c:1722
155
#: ../plugins/fn-info/functions.c:1759 ../plugins/fn-logical/functions.c:52
156
#: ../plugins/fn-logical/functions.c:103 ../plugins/fn-logical/functions.c:131
157
#: ../plugins/fn-logical/functions.c:269 ../plugins/fn-logical/functions.c:287
158
#: ../plugins/fn-math/functions.c:61 ../plugins/fn-math/functions.c:124
159
#: ../plugins/fn-math/functions.c:225 ../plugins/fn-math/functions.c:243
160
#: ../plugins/fn-math/functions.c:266 ../plugins/fn-math/functions.c:326
161
#: ../plugins/fn-math/functions.c:351 ../plugins/fn-math/functions.c:370
162
#: ../plugins/fn-math/functions.c:389 ../plugins/fn-math/functions.c:415
163
#: ../plugins/fn-math/functions.c:460 ../plugins/fn-math/functions.c:534
164
#: ../plugins/fn-math/functions.c:646 ../plugins/fn-math/functions.c:714
165
#: ../plugins/fn-math/functions.c:743 ../plugins/fn-math/functions.c:763
166
#: ../plugins/fn-math/functions.c:817 ../plugins/fn-math/functions.c:836
167
#: ../plugins/fn-math/functions.c:870 ../plugins/fn-math/functions.c:931
168
#: ../plugins/fn-math/functions.c:1010 ../plugins/fn-math/functions.c:1067
169
#: ../plugins/fn-math/functions.c:1100 ../plugins/fn-math/functions.c:1122
170
#: ../plugins/fn-math/functions.c:1150 ../plugins/fn-math/functions.c:1174
171
#: ../plugins/fn-math/functions.c:1200 ../plugins/fn-math/functions.c:1274
172
#: ../plugins/fn-math/functions.c:1317 ../plugins/fn-math/functions.c:1335
173
#: ../plugins/fn-math/functions.c:1432 ../plugins/fn-math/functions.c:1450
174
#: ../plugins/fn-math/functions.c:1497 ../plugins/fn-math/functions.c:1521
175
#: ../plugins/fn-math/functions.c:1567 ../plugins/fn-math/functions.c:1584
176
#: ../plugins/fn-math/functions.c:1619 ../plugins/fn-math/functions.c:1654
177
#: ../plugins/fn-math/functions.c:1689 ../plugins/fn-math/functions.c:1726
178
#: ../plugins/fn-math/functions.c:1805 ../plugins/fn-math/functions.c:1830
179
#: ../plugins/fn-math/functions.c:1856 ../plugins/fn-math/functions.c:1882
180
#: ../plugins/fn-math/functions.c:1906 ../plugins/fn-math/functions.c:1947
181
#: ../plugins/fn-math/functions.c:1992 ../plugins/fn-math/functions.c:2119
182
#: ../plugins/fn-math/functions.c:2367 ../plugins/fn-math/functions.c:2411
183
#: ../plugins/fn-math/functions.c:2454 ../plugins/fn-math/functions.c:2497
184
#: ../plugins/fn-math/functions.c:2553 ../plugins/fn-math/functions.c:2803
185
#: ../plugins/fn-math/functions.c:2870 ../plugins/fn-random/functions.c:47
186
#: ../plugins/fn-random/functions.c:248 ../plugins/fn-stat/functions.c:86
187
#: ../plugins/fn-stat/functions.c:114 ../plugins/fn-stat/functions.c:141
188
#: ../plugins/fn-stat/functions.c:169 ../plugins/fn-stat/functions.c:277
189
#: ../plugins/fn-stat/functions.c:325 ../plugins/fn-stat/functions.c:355
190
#: ../plugins/fn-stat/functions.c:388 ../plugins/fn-stat/functions.c:412
191
#: ../plugins/fn-stat/functions.c:437 ../plugins/fn-stat/functions.c:468
192
#: ../plugins/fn-stat/functions.c:497 ../plugins/fn-stat/functions.c:526
193
#: ../plugins/fn-stat/functions.c:546 ../plugins/fn-stat/functions.c:573
194
#: ../plugins/fn-stat/functions.c:600 ../plugins/fn-stat/functions.c:626
195
#: ../plugins/fn-stat/functions.c:662 ../plugins/fn-stat/functions.c:696
196
#: ../plugins/fn-stat/functions.c:722 ../plugins/fn-stat/functions.c:757
197
#: ../plugins/fn-stat/functions.c:797 ../plugins/fn-stat/functions.c:851
198
#: ../plugins/fn-stat/functions.c:919 ../plugins/fn-stat/functions.c:951
199
#: ../plugins/fn-stat/functions.c:981 ../plugins/fn-stat/functions.c:1008
200
#: ../plugins/fn-stat/functions.c:1038 ../plugins/fn-stat/functions.c:1126
201
#: ../plugins/fn-stat/functions.c:1163 ../plugins/fn-stat/functions.c:1246
202
#: ../plugins/fn-stat/functions.c:1283 ../plugins/fn-stat/functions.c:1449
203
#: ../plugins/fn-stat/functions.c:1481 ../plugins/fn-stat/functions.c:1591
204
#: ../plugins/fn-stat/functions.c:1618 ../plugins/fn-stat/functions.c:1648
205
#: ../plugins/fn-stat/functions.c:1683 ../plugins/fn-stat/functions.c:1710
206
#: ../plugins/fn-stat/functions.c:1742 ../plugins/fn-stat/functions.c:1774
207
#: ../plugins/fn-stat/functions.c:1806 ../plugins/fn-stat/functions.c:1839
208
#: ../plugins/fn-stat/functions.c:1889 ../plugins/fn-stat/functions.c:1914
209
#: ../plugins/fn-stat/functions.c:1939 ../plugins/fn-stat/functions.c:1971
210
#: ../plugins/fn-stat/functions.c:2000 ../plugins/fn-stat/functions.c:2019
211
#: ../plugins/fn-stat/functions.c:2045 ../plugins/fn-stat/functions.c:2167
212
#: ../plugins/fn-stat/functions.c:2210 ../plugins/fn-stat/functions.c:2284
213
#: ../plugins/fn-stat/functions.c:2364 ../plugins/fn-stat/functions.c:2518
214
#: ../plugins/fn-stat/functions.c:2577 ../plugins/fn-stat/functions.c:2602
215
#: ../plugins/fn-stat/functions.c:2629 ../plugins/fn-stat/functions.c:2661
216
#: ../plugins/fn-stat/functions.c:2688 ../plugins/fn-stat/functions.c:2718
217
#: ../plugins/fn-stat/functions.c:2745 ../plugins/fn-stat/functions.c:2869
218
#: ../plugins/fn-stat/functions.c:2913 ../plugins/fn-stat/functions.c:2954
219
#: ../plugins/fn-stat/functions.c:3020 ../plugins/fn-stat/functions.c:3186
220
#: ../plugins/fn-stat/functions.c:4354 ../plugins/fn-stat/functions.c:4424
221
#: ../plugins/fn-stat/functions.c:4475 ../plugins/fn-stat/functions.c:4543
222
#: ../plugins/fn-string/functions.c:66 ../plugins/fn-string/functions.c:137
223
#: ../plugins/fn-string/functions.c:199 ../plugins/fn-string/functions.c:218
224
#: ../plugins/fn-string/functions.c:235 ../plugins/fn-string/functions.c:255
225
#: ../plugins/fn-string/functions.c:319 ../plugins/fn-string/functions.c:339
226
#: ../plugins/fn-string/functions.c:466 ../plugins/fn-string/functions.c:535
227
#: ../plugins/fn-string/functions.c:555 ../plugins/fn-string/functions.c:577
228
#: ../plugins/fn-string/functions.c:621 ../plugins/fn-string/functions.c:652
229
#: ../plugins/fn-string/functions.c:690 ../plugins/fn-string/functions.c:745
230
#: ../plugins/fn-string/functions.c:791 ../plugins/fn-string/functions.c:892
231
#: ../plugins/fn-string/functions.c:916 ../plugins/fn-string/functions.c:969
232
#: ../plugins/fn-string/functions.c:1016 ../plugins/fn-string/functions.c:1112
233
#: ../plugins/fn-string/functions.c:1183 ../plugins/fn-string/functions.c:1266
143
#: ../plugins/fn-eng/functions.c:1127 ../plugins/fn-eng/functions.c:1150
144
#: ../plugins/fn-info/functions.c:97 ../plugins/fn-info/functions.c:1285
145
#: ../plugins/fn-info/functions.c:1351 ../plugins/fn-info/functions.c:1440
146
#: ../plugins/fn-info/functions.c:1458 ../plugins/fn-info/functions.c:1480
147
#: ../plugins/fn-info/functions.c:1507 ../plugins/fn-info/functions.c:1534
148
#: ../plugins/fn-info/functions.c:1571 ../plugins/fn-info/functions.c:1587
149
#: ../plugins/fn-info/functions.c:1609 ../plugins/fn-info/functions.c:1626
150
#: ../plugins/fn-info/functions.c:1644 ../plugins/fn-info/functions.c:1661
151
#: ../plugins/fn-info/functions.c:1683 ../plugins/fn-info/functions.c:1703
152
#: ../plugins/fn-info/functions.c:1722 ../plugins/fn-info/functions.c:1759
153
#: ../plugins/fn-logical/functions.c:52 ../plugins/fn-logical/functions.c:103
154
#: ../plugins/fn-logical/functions.c:131 ../plugins/fn-logical/functions.c:269
155
#: ../plugins/fn-logical/functions.c:287 ../plugins/fn-math/functions.c:61
156
#: ../plugins/fn-math/functions.c:124 ../plugins/fn-math/functions.c:225
157
#: ../plugins/fn-math/functions.c:243 ../plugins/fn-math/functions.c:266
158
#: ../plugins/fn-math/functions.c:326 ../plugins/fn-math/functions.c:351
159
#: ../plugins/fn-math/functions.c:370 ../plugins/fn-math/functions.c:389
160
#: ../plugins/fn-math/functions.c:423 ../plugins/fn-math/functions.c:469
161
#: ../plugins/fn-math/functions.c:543 ../plugins/fn-math/functions.c:655
162
#: ../plugins/fn-math/functions.c:723 ../plugins/fn-math/functions.c:752
163
#: ../plugins/fn-math/functions.c:772 ../plugins/fn-math/functions.c:826
164
#: ../plugins/fn-math/functions.c:845 ../plugins/fn-math/functions.c:879
165
#: ../plugins/fn-math/functions.c:940 ../plugins/fn-math/functions.c:1018
166
#: ../plugins/fn-math/functions.c:1075 ../plugins/fn-math/functions.c:1108
167
#: ../plugins/fn-math/functions.c:1130 ../plugins/fn-math/functions.c:1158
168
#: ../plugins/fn-math/functions.c:1182 ../plugins/fn-math/functions.c:1208
169
#: ../plugins/fn-math/functions.c:1282 ../plugins/fn-math/functions.c:1325
170
#: ../plugins/fn-math/functions.c:1343 ../plugins/fn-math/functions.c:1440
171
#: ../plugins/fn-math/functions.c:1458 ../plugins/fn-math/functions.c:1505
172
#: ../plugins/fn-math/functions.c:1529 ../plugins/fn-math/functions.c:1575
173
#: ../plugins/fn-math/functions.c:1592 ../plugins/fn-math/functions.c:1627
174
#: ../plugins/fn-math/functions.c:1662 ../plugins/fn-math/functions.c:1697
175
#: ../plugins/fn-math/functions.c:1734 ../plugins/fn-math/functions.c:1813
176
#: ../plugins/fn-math/functions.c:1838 ../plugins/fn-math/functions.c:1864
177
#: ../plugins/fn-math/functions.c:1890 ../plugins/fn-math/functions.c:1914
178
#: ../plugins/fn-math/functions.c:1955 ../plugins/fn-math/functions.c:2000
179
#: ../plugins/fn-math/functions.c:2127 ../plugins/fn-math/functions.c:2375
180
#: ../plugins/fn-math/functions.c:2419 ../plugins/fn-math/functions.c:2462
181
#: ../plugins/fn-math/functions.c:2505 ../plugins/fn-math/functions.c:2562
182
#: ../plugins/fn-math/functions.c:2819 ../plugins/fn-math/functions.c:2886
183
#: ../plugins/fn-random/functions.c:48 ../plugins/fn-random/functions.c:249
184
#: ../plugins/fn-stat/functions.c:83 ../plugins/fn-stat/functions.c:111
185
#: ../plugins/fn-stat/functions.c:138 ../plugins/fn-stat/functions.c:166
186
#: ../plugins/fn-stat/functions.c:276 ../plugins/fn-stat/functions.c:324
187
#: ../plugins/fn-stat/functions.c:354 ../plugins/fn-stat/functions.c:387
188
#: ../plugins/fn-stat/functions.c:411 ../plugins/fn-stat/functions.c:436
189
#: ../plugins/fn-stat/functions.c:467 ../plugins/fn-stat/functions.c:496
190
#: ../plugins/fn-stat/functions.c:525 ../plugins/fn-stat/functions.c:545
191
#: ../plugins/fn-stat/functions.c:572 ../plugins/fn-stat/functions.c:599
192
#: ../plugins/fn-stat/functions.c:625 ../plugins/fn-stat/functions.c:661
193
#: ../plugins/fn-stat/functions.c:695 ../plugins/fn-stat/functions.c:721
194
#: ../plugins/fn-stat/functions.c:756 ../plugins/fn-stat/functions.c:796
195
#: ../plugins/fn-stat/functions.c:850 ../plugins/fn-stat/functions.c:918
196
#: ../plugins/fn-stat/functions.c:950 ../plugins/fn-stat/functions.c:980
197
#: ../plugins/fn-stat/functions.c:1007 ../plugins/fn-stat/functions.c:1037
198
#: ../plugins/fn-stat/functions.c:1125 ../plugins/fn-stat/functions.c:1162
199
#: ../plugins/fn-stat/functions.c:1245 ../plugins/fn-stat/functions.c:1282
200
#: ../plugins/fn-stat/functions.c:1448 ../plugins/fn-stat/functions.c:1480
201
#: ../plugins/fn-stat/functions.c:1576 ../plugins/fn-stat/functions.c:1603
202
#: ../plugins/fn-stat/functions.c:1633 ../plugins/fn-stat/functions.c:1668
203
#: ../plugins/fn-stat/functions.c:1695 ../plugins/fn-stat/functions.c:1727
204
#: ../plugins/fn-stat/functions.c:1759 ../plugins/fn-stat/functions.c:1791
205
#: ../plugins/fn-stat/functions.c:1824 ../plugins/fn-stat/functions.c:1874
206
#: ../plugins/fn-stat/functions.c:1899 ../plugins/fn-stat/functions.c:1924
207
#: ../plugins/fn-stat/functions.c:1956 ../plugins/fn-stat/functions.c:1985
208
#: ../plugins/fn-stat/functions.c:2004 ../plugins/fn-stat/functions.c:2030
209
#: ../plugins/fn-stat/functions.c:2152 ../plugins/fn-stat/functions.c:2195
210
#: ../plugins/fn-stat/functions.c:2244 ../plugins/fn-stat/functions.c:2324
211
#: ../plugins/fn-stat/functions.c:2382 ../plugins/fn-stat/functions.c:2441
212
#: ../plugins/fn-stat/functions.c:2466 ../plugins/fn-stat/functions.c:2493
213
#: ../plugins/fn-stat/functions.c:2525 ../plugins/fn-stat/functions.c:2552
214
#: ../plugins/fn-stat/functions.c:2582 ../plugins/fn-stat/functions.c:2609
215
#: ../plugins/fn-stat/functions.c:2733 ../plugins/fn-stat/functions.c:2776
216
#: ../plugins/fn-stat/functions.c:2817 ../plugins/fn-stat/functions.c:2883
217
#: ../plugins/fn-stat/functions.c:3052 ../plugins/fn-stat/functions.c:3916
218
#: ../plugins/fn-stat/functions.c:3973 ../plugins/fn-stat/functions.c:4021
219
#: ../plugins/fn-stat/functions.c:4086 ../plugins/fn-string/functions.c:68
220
#: ../plugins/fn-string/functions.c:140 ../plugins/fn-string/functions.c:202
221
#: ../plugins/fn-string/functions.c:221 ../plugins/fn-string/functions.c:238
222
#: ../plugins/fn-string/functions.c:258 ../plugins/fn-string/functions.c:322
223
#: ../plugins/fn-string/functions.c:342 ../plugins/fn-string/functions.c:469
224
#: ../plugins/fn-string/functions.c:538 ../plugins/fn-string/functions.c:558
225
#: ../plugins/fn-string/functions.c:580 ../plugins/fn-string/functions.c:624
226
#: ../plugins/fn-string/functions.c:655 ../plugins/fn-string/functions.c:693
227
#: ../plugins/fn-string/functions.c:750 ../plugins/fn-string/functions.c:796
228
#: ../plugins/fn-string/functions.c:897 ../plugins/fn-string/functions.c:921
229
#: ../plugins/fn-string/functions.c:974 ../plugins/fn-string/functions.c:1021
230
#: ../plugins/fn-string/functions.c:1117 ../plugins/fn-string/functions.c:1188
231
#: ../plugins/fn-string/functions.c:1271
234
232
msgid "This function is Excel compatible."
237
#: ../plugins/fn-complex/functions.c:109
235
#: ../plugins/fn-complex/functions.c:111
238
236
msgid "IMAGINARY:the imaginary part of the complex number @{z}"
241
#: ../plugins/fn-complex/functions.c:110 ../plugins/fn-complex/functions.c:137
242
#: ../plugins/fn-complex/functions.c:161 ../plugins/fn-complex/functions.c:188
243
#: ../plugins/fn-complex/functions.c:213 ../plugins/fn-complex/functions.c:236
244
#: ../plugins/fn-complex/functions.c:259 ../plugins/fn-complex/functions.c:285
245
#: ../plugins/fn-complex/functions.c:311 ../plugins/fn-complex/functions.c:338
246
#: ../plugins/fn-complex/functions.c:364 ../plugins/fn-complex/functions.c:390
247
#: ../plugins/fn-complex/functions.c:416 ../plugins/fn-complex/functions.c:440
248
#: ../plugins/fn-complex/functions.c:468 ../plugins/fn-complex/functions.c:495
249
#: ../plugins/fn-complex/functions.c:586 ../plugins/fn-complex/functions.c:611
250
#: ../plugins/fn-complex/functions.c:635 ../plugins/fn-complex/functions.c:660
251
#: ../plugins/fn-complex/functions.c:685 ../plugins/fn-complex/functions.c:709
252
#: ../plugins/fn-complex/functions.c:734 ../plugins/fn-complex/functions.c:758
253
#: ../plugins/fn-complex/functions.c:785 ../plugins/fn-complex/functions.c:812
254
#: ../plugins/fn-complex/functions.c:839 ../plugins/fn-complex/functions.c:863
255
#: ../plugins/fn-complex/functions.c:888 ../plugins/fn-complex/functions.c:912
256
#: ../plugins/fn-complex/functions.c:939 ../plugins/fn-complex/functions.c:967
257
#: ../plugins/fn-complex/functions.c:995
258
#: ../plugins/fn-complex/functions.c:1019
259
#: ../plugins/fn-complex/functions.c:1044
260
#: ../plugins/fn-complex/functions.c:1069
239
#: ../plugins/fn-complex/functions.c:112 ../plugins/fn-complex/functions.c:139
240
#: ../plugins/fn-complex/functions.c:163 ../plugins/fn-complex/functions.c:190
241
#: ../plugins/fn-complex/functions.c:215 ../plugins/fn-complex/functions.c:238
242
#: ../plugins/fn-complex/functions.c:261 ../plugins/fn-complex/functions.c:287
243
#: ../plugins/fn-complex/functions.c:313 ../plugins/fn-complex/functions.c:340
244
#: ../plugins/fn-complex/functions.c:366 ../plugins/fn-complex/functions.c:392
245
#: ../plugins/fn-complex/functions.c:418 ../plugins/fn-complex/functions.c:442
246
#: ../plugins/fn-complex/functions.c:470 ../plugins/fn-complex/functions.c:497
247
#: ../plugins/fn-complex/functions.c:591 ../plugins/fn-complex/functions.c:616
248
#: ../plugins/fn-complex/functions.c:640 ../plugins/fn-complex/functions.c:665
249
#: ../plugins/fn-complex/functions.c:690 ../plugins/fn-complex/functions.c:714
250
#: ../plugins/fn-complex/functions.c:739 ../plugins/fn-complex/functions.c:763
251
#: ../plugins/fn-complex/functions.c:790 ../plugins/fn-complex/functions.c:817
252
#: ../plugins/fn-complex/functions.c:844 ../plugins/fn-complex/functions.c:868
253
#: ../plugins/fn-complex/functions.c:893 ../plugins/fn-complex/functions.c:917
254
#: ../plugins/fn-complex/functions.c:944 ../plugins/fn-complex/functions.c:972
255
#: ../plugins/fn-complex/functions.c:1000
256
#: ../plugins/fn-complex/functions.c:1024
257
#: ../plugins/fn-complex/functions.c:1049
258
#: ../plugins/fn-complex/functions.c:1074
261
259
msgid "z:a complex number"
264
#: ../plugins/fn-complex/functions.c:111 ../plugins/fn-complex/functions.c:138
265
#: ../plugins/fn-complex/functions.c:162 ../plugins/fn-complex/functions.c:189
266
#: ../plugins/fn-complex/functions.c:214 ../plugins/fn-complex/functions.c:237
267
#: ../plugins/fn-complex/functions.c:260 ../plugins/fn-complex/functions.c:286
268
#: ../plugins/fn-complex/functions.c:313 ../plugins/fn-complex/functions.c:340
269
#: ../plugins/fn-complex/functions.c:366 ../plugins/fn-complex/functions.c:391
270
#: ../plugins/fn-complex/functions.c:418 ../plugins/fn-complex/functions.c:444
271
#: ../plugins/fn-complex/functions.c:469 ../plugins/fn-complex/functions.c:496
272
#: ../plugins/fn-complex/functions.c:587 ../plugins/fn-complex/functions.c:612
273
#: ../plugins/fn-complex/functions.c:636 ../plugins/fn-complex/functions.c:661
274
#: ../plugins/fn-complex/functions.c:686 ../plugins/fn-complex/functions.c:710
275
#: ../plugins/fn-complex/functions.c:735 ../plugins/fn-complex/functions.c:761
276
#: ../plugins/fn-complex/functions.c:788 ../plugins/fn-complex/functions.c:815
277
#: ../plugins/fn-complex/functions.c:840 ../plugins/fn-complex/functions.c:864
278
#: ../plugins/fn-complex/functions.c:889 ../plugins/fn-complex/functions.c:915
279
#: ../plugins/fn-complex/functions.c:943 ../plugins/fn-complex/functions.c:971
280
#: ../plugins/fn-complex/functions.c:996
281
#: ../plugins/fn-complex/functions.c:1020
282
#: ../plugins/fn-complex/functions.c:1045
283
#: ../plugins/fn-complex/functions.c:1070
262
#: ../plugins/fn-complex/functions.c:113 ../plugins/fn-complex/functions.c:140
263
#: ../plugins/fn-complex/functions.c:164 ../plugins/fn-complex/functions.c:191
264
#: ../plugins/fn-complex/functions.c:216 ../plugins/fn-complex/functions.c:239
265
#: ../plugins/fn-complex/functions.c:262 ../plugins/fn-complex/functions.c:288
266
#: ../plugins/fn-complex/functions.c:315 ../plugins/fn-complex/functions.c:342
267
#: ../plugins/fn-complex/functions.c:368 ../plugins/fn-complex/functions.c:393
268
#: ../plugins/fn-complex/functions.c:420 ../plugins/fn-complex/functions.c:446
269
#: ../plugins/fn-complex/functions.c:471 ../plugins/fn-complex/functions.c:498
270
#: ../plugins/fn-complex/functions.c:592 ../plugins/fn-complex/functions.c:617
271
#: ../plugins/fn-complex/functions.c:641 ../plugins/fn-complex/functions.c:666
272
#: ../plugins/fn-complex/functions.c:691 ../plugins/fn-complex/functions.c:715
273
#: ../plugins/fn-complex/functions.c:740 ../plugins/fn-complex/functions.c:766
274
#: ../plugins/fn-complex/functions.c:793 ../plugins/fn-complex/functions.c:820
275
#: ../plugins/fn-complex/functions.c:845 ../plugins/fn-complex/functions.c:869
276
#: ../plugins/fn-complex/functions.c:894 ../plugins/fn-complex/functions.c:920
277
#: ../plugins/fn-complex/functions.c:948 ../plugins/fn-complex/functions.c:976
278
#: ../plugins/fn-complex/functions.c:1001
279
#: ../plugins/fn-complex/functions.c:1025
280
#: ../plugins/fn-complex/functions.c:1050
281
#: ../plugins/fn-complex/functions.c:1075
284
282
msgid "If @{z} is not a valid complex number, #VALUE! is returned."
287
#: ../plugins/fn-complex/functions.c:136
285
#: ../plugins/fn-complex/functions.c:138
288
286
msgid "IMABS:the absolute value of the complex number @{z}"
291
#: ../plugins/fn-complex/functions.c:160
289
#: ../plugins/fn-complex/functions.c:162
292
290
msgid "IMREAL:the real part of the complex number @{z}"
295
#: ../plugins/fn-complex/functions.c:187
293
#: ../plugins/fn-complex/functions.c:189
296
294
msgid "IMCONJUGATE:the complex conjugate of the complex number @{z}"
299
#: ../plugins/fn-complex/functions.c:212
297
#: ../plugins/fn-complex/functions.c:214
300
298
msgid "IMINV:the reciprocal, or inverse, of the complex number @{z}"
303
#: ../plugins/fn-complex/functions.c:235
301
#: ../plugins/fn-complex/functions.c:237
304
302
msgid "IMNEG:the negative of the complex number @{z}"
307
#: ../plugins/fn-complex/functions.c:258
305
#: ../plugins/fn-complex/functions.c:260
308
306
msgid "IMCOS:the cosine of the complex number @{z}"
311
#: ../plugins/fn-complex/functions.c:284
309
#: ../plugins/fn-complex/functions.c:286
312
310
msgid "IMTAN:the tangent of the complex number @{z}"
315
#: ../plugins/fn-complex/functions.c:310
313
#: ../plugins/fn-complex/functions.c:312
316
314
msgid "IMSEC:the secant of the complex number @{z}"
319
#: ../plugins/fn-complex/functions.c:312
317
#: ../plugins/fn-complex/functions.c:314
320
318
msgid "secz = 1/cosz."
323
#: ../plugins/fn-complex/functions.c:337
321
#: ../plugins/fn-complex/functions.c:339
324
322
msgid "IMCSC:the cosecant of the complex number @{z}"
327
#: ../plugins/fn-complex/functions.c:339
325
#: ../plugins/fn-complex/functions.c:341
328
326
msgid "cscz = 1/sinz."
331
#: ../plugins/fn-complex/functions.c:363
329
#: ../plugins/fn-complex/functions.c:365
332
330
msgid "IMCOT:the cotangent of the complex number @{z}"
335
#: ../plugins/fn-complex/functions.c:365
333
#: ../plugins/fn-complex/functions.c:367
336
334
msgid "cotz = cosz/sinz."
339
#: ../plugins/fn-complex/functions.c:389
337
#: ../plugins/fn-complex/functions.c:391
340
338
msgid "IMEXP:the exponential of the complex number @{z}"
343
#: ../plugins/fn-complex/functions.c:415
341
#: ../plugins/fn-complex/functions.c:417
344
342
msgid "IMARGUMENT:the argument theta of the complex number @{z} "
347
#: ../plugins/fn-complex/functions.c:417
345
#: ../plugins/fn-complex/functions.c:419
349
347
"The argument theta of a complex number is its angle in radians from the real "
353
#: ../plugins/fn-complex/functions.c:439
351
#: ../plugins/fn-complex/functions.c:441
354
352
msgid "IMLN:the natural logarithm of the complex number @{z}"
357
#: ../plugins/fn-complex/functions.c:441
355
#: ../plugins/fn-complex/functions.c:443
359
357
"The result will have an imaginary part between -π and +π.\n"
360
358
"The natural logarithm is not uniquely defined on complex numbers. You may "
361
359
"need to add or subtract an even multiple of π to the imaginary part."
364
#: ../plugins/fn-complex/functions.c:467
362
#: ../plugins/fn-complex/functions.c:469
365
363
msgid "IMLOG2:the base-2 logarithm of the complex number @{z}"
368
#: ../plugins/fn-complex/functions.c:494
366
#: ../plugins/fn-complex/functions.c:496
369
367
msgid "IMLOG10:the base-10 logarithm of the complex number @{z}"
372
#: ../plugins/fn-complex/functions.c:520
373
msgid "IMPOWER: the complex number @{z1} raised to the @{z2}th power"
370
#: ../plugins/fn-complex/functions.c:522
371
msgid "IMPOWER:the complex number @{z1} raised to the @{z2}th power"
376
#: ../plugins/fn-complex/functions.c:521 ../plugins/fn-complex/functions.c:553
377
#: ../plugins/fn-complex/functions.c:1095
378
#: ../plugins/fn-complex/functions.c:1125
379
#: ../plugins/fn-complex/functions.c:1194
374
#: ../plugins/fn-complex/functions.c:523 ../plugins/fn-complex/functions.c:558
375
#: ../plugins/fn-complex/functions.c:1100
376
#: ../plugins/fn-complex/functions.c:1130
377
#: ../plugins/fn-complex/functions.c:1199
380
378
msgid "z1:a complex number"
383
#: ../plugins/fn-complex/functions.c:522 ../plugins/fn-complex/functions.c:554
384
#: ../plugins/fn-complex/functions.c:1096
385
#: ../plugins/fn-complex/functions.c:1126
386
#: ../plugins/fn-complex/functions.c:1195
381
#: ../plugins/fn-complex/functions.c:524 ../plugins/fn-complex/functions.c:559
382
#: ../plugins/fn-complex/functions.c:1101
383
#: ../plugins/fn-complex/functions.c:1131
384
#: ../plugins/fn-complex/functions.c:1200
387
385
msgid "z2:a complex number"
390
#: ../plugins/fn-complex/functions.c:523 ../plugins/fn-complex/functions.c:555
391
#: ../plugins/fn-complex/functions.c:1097
388
#: ../plugins/fn-complex/functions.c:525 ../plugins/fn-complex/functions.c:560
389
#: ../plugins/fn-complex/functions.c:1102
392
390
msgid "If @{z1} or @{z2} is not a valid complex number, #VALUE! is returned."
395
#: ../plugins/fn-complex/functions.c:552
393
#: ../plugins/fn-complex/functions.c:557
396
394
msgid "IMDIV:the quotient of two complex numbers @{z1}/@{z2}"
399
#: ../plugins/fn-complex/functions.c:585
397
#: ../plugins/fn-complex/functions.c:590
400
398
msgid "IMSIN:the sine of the complex number @{z}"
403
#: ../plugins/fn-complex/functions.c:610
401
#: ../plugins/fn-complex/functions.c:615
404
402
msgid "IMSINH:the hyperbolic sine of the complex number @{z}"
407
#: ../plugins/fn-complex/functions.c:634
405
#: ../plugins/fn-complex/functions.c:639
408
406
msgid "IMCOSH:the hyperbolic cosine of the complex number @{z}"
411
#: ../plugins/fn-complex/functions.c:659
409
#: ../plugins/fn-complex/functions.c:664
412
410
msgid "IMTANH:the hyperbolic tangent of the complex number @{z}"
415
#: ../plugins/fn-complex/functions.c:684
413
#: ../plugins/fn-complex/functions.c:689
416
414
msgid "IMSECH:the hyperbolic secant of the complex number @{z}"
419
#: ../plugins/fn-complex/functions.c:708
417
#: ../plugins/fn-complex/functions.c:713
420
418
msgid "IMCSCH:the hyperbolic cosecant of the complex number @{z}"
423
#: ../plugins/fn-complex/functions.c:733
421
#: ../plugins/fn-complex/functions.c:738
424
422
msgid "IMCOTH:the hyperbolic cotangent of the complex number @{z}"
427
#: ../plugins/fn-complex/functions.c:757
425
#: ../plugins/fn-complex/functions.c:762
428
426
msgid "IMARCSIN:the complex arcsine of the complex number @{z}"
431
#: ../plugins/fn-complex/functions.c:759
429
#: ../plugins/fn-complex/functions.c:764
433
431
"IMARCSIN returns the complex arcsine of the complex number @{z}. The branch "
434
432
"cuts are on the real axis, less than -1 and greater than 1."
437
#: ../plugins/fn-complex/functions.c:784
435
#: ../plugins/fn-complex/functions.c:789
438
436
msgid "IMARCCOS:the complex arccosine of the complex number "
441
#: ../plugins/fn-complex/functions.c:786
439
#: ../plugins/fn-complex/functions.c:791
443
441
"IMARCCOS returns the complex arccosine of the complex number @{z}. The "
444
442
"branch cuts are on the real axis, less than -1 and greater than 1."
447
#: ../plugins/fn-complex/functions.c:811
445
#: ../plugins/fn-complex/functions.c:816
448
446
msgid "IMARCTAN:the complex arctangent of the complex number "
451
#: ../plugins/fn-complex/functions.c:813
449
#: ../plugins/fn-complex/functions.c:818
453
451
"IMARCTAN returns the complex arctangent of the complex number @{z}. The "
454
452
"branch cuts are on the imaginary axis, below -i and above i."
457
#: ../plugins/fn-complex/functions.c:838
455
#: ../plugins/fn-complex/functions.c:843
458
456
msgid "IMARCSEC:the complex arcsecant of the complex number @{z}"
461
#: ../plugins/fn-complex/functions.c:862
459
#: ../plugins/fn-complex/functions.c:867
462
460
msgid "IMARCCSC:the complex arccosecant of the complex number @{z}"
465
#: ../plugins/fn-complex/functions.c:887
463
#: ../plugins/fn-complex/functions.c:892
466
464
msgid "IMARCCOT:the complex arccotangent of the complex number @{z}"
469
#: ../plugins/fn-complex/functions.c:911
467
#: ../plugins/fn-complex/functions.c:916
470
468
msgid "IMARCSINH:the complex hyperbolic arcsine of the complex number @{z}"
473
#: ../plugins/fn-complex/functions.c:913
471
#: ../plugins/fn-complex/functions.c:918
475
473
"IMARCSINH returns the complex hyperbolic arcsine of the complex number @"
476
474
"{z}. The branch cuts are on the imaginary axis, below -i and above i."
479
#: ../plugins/fn-complex/functions.c:938
477
#: ../plugins/fn-complex/functions.c:943
480
478
msgid "IMARCCOSH:the complex hyperbolic arccosine of the complex number @{z}"
483
#: ../plugins/fn-complex/functions.c:940
481
#: ../plugins/fn-complex/functions.c:945
485
483
"IMARCCOSH returns the complex hyperbolic arccosine of the complex number @"
486
484
"{z}. The branch cut is on the real axis, less than 1."
489
#: ../plugins/fn-complex/functions.c:966
487
#: ../plugins/fn-complex/functions.c:971
490
488
msgid "IMARCTANH:the complex hyperbolic arctangent of the complex number @{z}"
493
#: ../plugins/fn-complex/functions.c:968
491
#: ../plugins/fn-complex/functions.c:973
495
493
"IMARCTANH returns the complex hyperbolic arctangent of the complex number @"
496
494
"{z}. The branch cuts are on the real axis, less than -1 and greater than 1."
499
#: ../plugins/fn-complex/functions.c:994
497
#: ../plugins/fn-complex/functions.c:999
500
498
msgid "IMARCSECH:the complex hyperbolic arcsecant of the complex number @{z}"
503
#: ../plugins/fn-complex/functions.c:1018
501
#: ../plugins/fn-complex/functions.c:1023
504
502
msgid "IMARCCSCH:the complex hyperbolic arccosecant of the complex number @{z}"
507
#: ../plugins/fn-complex/functions.c:1043
505
#: ../plugins/fn-complex/functions.c:1048
509
507
"IMARCCOTH:the complex hyperbolic arccotangent of the complex number @{z}"
512
#: ../plugins/fn-complex/functions.c:1068
510
#: ../plugins/fn-complex/functions.c:1073
513
511
msgid "IMSQRT:the square root of the complex number @{z}"
516
#: ../plugins/fn-complex/functions.c:1094
517
msgid "IMSUB:the difference of two complex numbers."
520
#: ../plugins/fn-complex/functions.c:1124
521
msgid "IMPRODUCT:the product of the given complex numbers."
524
#: ../plugins/fn-complex/functions.c:1127
525
#: ../plugins/fn-complex/functions.c:1196
514
#: ../plugins/fn-complex/functions.c:1099
515
msgid "IMSUB:the difference of two complex numbers"
518
#: ../plugins/fn-complex/functions.c:1129
519
msgid "IMPRODUCT:the product of the given complex numbers"
522
#: ../plugins/fn-complex/functions.c:1132
523
#: ../plugins/fn-complex/functions.c:1201
527
525
"If any of @{z1}, @{z2},... is not a valid complex number, #VALUE! is "
531
#: ../plugins/fn-complex/functions.c:1193
529
#: ../plugins/fn-complex/functions.c:1198
532
530
msgid "IMSUM:the sum of the given complex numbers"
2642
2684
#: ../plugins/fn-financial/functions.c:365
2643
#: ../plugins/fn-financial/functions.c:462
2644
#: ../plugins/fn-financial/functions.c:500
2645
#: ../plugins/fn-financial/functions.c:541
2646
#: ../plugins/fn-financial/functions.c:577
2647
#: ../plugins/fn-financial/functions.c:622
2648
#: ../plugins/fn-financial/functions.c:1060
2649
#: ../plugins/fn-financial/functions.c:1098
2650
#: ../plugins/fn-financial/functions.c:1132
2651
#: ../plugins/fn-financial/functions.c:1864
2652
#: ../plugins/fn-financial/functions.c:2220
2653
#: ../plugins/fn-financial/functions.c:2270
2654
#: ../plugins/fn-financial/functions.c:2379
2655
#: ../plugins/fn-financial/functions.c:2424
2656
#: ../plugins/fn-financial/functions.c:2463
2657
#: ../plugins/fn-financial/functions.c:2613
2658
#: ../plugins/fn-financial/functions.c:2709
2659
#: ../plugins/fn-financial/functions.c:2787
2660
#: ../plugins/fn-financial/functions.c:2959
2661
#: ../plugins/fn-financial/functions.c:2983
2662
#: ../plugins/fn-financial/functions.c:3007
2663
#: ../plugins/fn-financial/functions.c:3031
2664
#: ../plugins/fn-financial/functions.c:3057
2665
#: ../plugins/fn-financial/functions.c:3083
2666
#: ../plugins/fn-financial/functions.c:3195
2685
#: ../plugins/fn-financial/functions.c:488
2686
#: ../plugins/fn-financial/functions.c:526
2687
#: ../plugins/fn-financial/functions.c:567
2688
#: ../plugins/fn-financial/functions.c:603
2689
#: ../plugins/fn-financial/functions.c:648
2690
#: ../plugins/fn-financial/functions.c:1086
2691
#: ../plugins/fn-financial/functions.c:1124
2692
#: ../plugins/fn-financial/functions.c:1158
2693
#: ../plugins/fn-financial/functions.c:1890
2694
#: ../plugins/fn-financial/functions.c:2252
2695
#: ../plugins/fn-financial/functions.c:2302
2696
#: ../plugins/fn-financial/functions.c:2411
2697
#: ../plugins/fn-financial/functions.c:2456
2698
#: ../plugins/fn-financial/functions.c:2495
2699
#: ../plugins/fn-financial/functions.c:2645
2700
#: ../plugins/fn-financial/functions.c:2741
2701
#: ../plugins/fn-financial/functions.c:2819
2702
#: ../plugins/fn-financial/functions.c:2999
2703
#: ../plugins/fn-financial/functions.c:3023
2704
#: ../plugins/fn-financial/functions.c:3047
2705
#: ../plugins/fn-financial/functions.c:3071
2706
#: ../plugins/fn-financial/functions.c:3097
2707
#: ../plugins/fn-financial/functions.c:3123
2708
#: ../plugins/fn-financial/functions.c:3235
2667
2709
msgid "settlement:settlement date"
2670
2712
#: ../plugins/fn-financial/functions.c:366
2671
#: ../plugins/fn-financial/functions.c:426
2672
#: ../plugins/fn-financial/functions.c:503
2673
#: ../plugins/fn-financial/functions.c:660
2674
#: ../plugins/fn-financial/functions.c:2222
2675
#: ../plugins/fn-financial/functions.c:2272
2676
#: ../plugins/fn-financial/functions.c:2427
2677
#: ../plugins/fn-financial/functions.c:2467
2678
#: ../plugins/fn-financial/functions.c:2617
2679
#: ../plugins/fn-financial/functions.c:2712
2680
#: ../plugins/fn-financial/functions.c:2790
2713
#: ../plugins/fn-financial/functions.c:452
2714
#: ../plugins/fn-financial/functions.c:529
2715
#: ../plugins/fn-financial/functions.c:686
2716
#: ../plugins/fn-financial/functions.c:2254
2717
#: ../plugins/fn-financial/functions.c:2304
2718
#: ../plugins/fn-financial/functions.c:2459
2719
#: ../plugins/fn-financial/functions.c:2499
2720
#: ../plugins/fn-financial/functions.c:2649
2721
#: ../plugins/fn-financial/functions.c:2744
2722
#: ../plugins/fn-financial/functions.c:2822
2681
2723
msgid "rate:nominal annual interest rate"
2684
2726
#: ../plugins/fn-financial/functions.c:367
2685
#: ../plugins/fn-financial/functions.c:427
2686
msgid "par:par value"
2727
msgid "par:par value, defaults to $1000"
2689
2730
#: ../plugins/fn-financial/functions.c:368
2690
#: ../plugins/fn-financial/functions.c:1868
2691
#: ../plugins/fn-financial/functions.c:2225
2692
#: ../plugins/fn-financial/functions.c:2275
2693
#: ../plugins/fn-financial/functions.c:2470
2694
#: ../plugins/fn-financial/functions.c:2620
2695
#: ../plugins/fn-financial/functions.c:2715
2696
#: ../plugins/fn-financial/functions.c:2793
2697
#: ../plugins/fn-financial/functions.c:2961
2698
#: ../plugins/fn-financial/functions.c:2985
2699
#: ../plugins/fn-financial/functions.c:3009
2700
#: ../plugins/fn-financial/functions.c:3033
2701
#: ../plugins/fn-financial/functions.c:3059
2702
#: ../plugins/fn-financial/functions.c:3085
2703
#: ../plugins/fn-financial/functions.c:3199
2731
#: ../plugins/fn-financial/functions.c:1894
2732
#: ../plugins/fn-financial/functions.c:2257
2733
#: ../plugins/fn-financial/functions.c:2307
2734
#: ../plugins/fn-financial/functions.c:2502
2735
#: ../plugins/fn-financial/functions.c:2652
2736
#: ../plugins/fn-financial/functions.c:2747
2737
#: ../plugins/fn-financial/functions.c:2825
2738
#: ../plugins/fn-financial/functions.c:3001
2739
#: ../plugins/fn-financial/functions.c:3025
2740
#: ../plugins/fn-financial/functions.c:3049
2741
#: ../plugins/fn-financial/functions.c:3073
2742
#: ../plugins/fn-financial/functions.c:3099
2743
#: ../plugins/fn-financial/functions.c:3125
2744
#: ../plugins/fn-financial/functions.c:3239
2704
2745
msgid "frequency:number of interest payments per year"
2748
#: ../plugins/fn-financial/functions.c:369
2749
msgid "basis:calendar basis, defaults to 0"
2707
2752
#: ../plugins/fn-financial/functions.c:370
2709
"ACCRINT calculates the accrued interest for a security that pays periodic "
2713
#: ../plugins/fn-financial/functions.c:423
2753
msgid "calc_method:calculation method, defaults to TRUE"
2756
#: ../plugins/fn-financial/functions.c:372
2758
"If @{first_interest} < @{settlement} and @{calc_method} is TRUE, then "
2759
"ACCRINT returns the sum of the interest accrued in all coupon periods from @"
2760
"{issue} date until @{settlement} date."
2763
#: ../plugins/fn-financial/functions.c:377
2765
"If @{first_interest} < @{settlement} and @{calc_method} is FALSE, then "
2766
"ACCRINT returns the sum of the interest accrued in all coupon periods from @"
2767
"{first_interest} date until @{settlement} date."
2770
#: ../plugins/fn-financial/functions.c:382
2772
"Otherwise ACCRINT returns the sum of the interest accrued in all coupon "
2773
"periods from @{issue} date until @{settlement} date."
2776
#: ../plugins/fn-financial/functions.c:385
2778
"@{frequency} must be one of 1, 2 or 4, but the exact value does not affect "
2782
#: ../plugins/fn-financial/functions.c:387
2783
msgid "@{issue} must precede both @{first_interest} and @{settlement}."
2786
#: ../plugins/fn-financial/functions.c:449
2714
2787
msgid "ACCRINTM:accrued interest"
2717
#: ../plugins/fn-financial/functions.c:425
2718
#: ../plugins/fn-financial/functions.c:463
2719
#: ../plugins/fn-financial/functions.c:501
2720
#: ../plugins/fn-financial/functions.c:542
2721
#: ../plugins/fn-financial/functions.c:578
2722
#: ../plugins/fn-financial/functions.c:623
2723
#: ../plugins/fn-financial/functions.c:1061
2724
#: ../plugins/fn-financial/functions.c:1099
2725
#: ../plugins/fn-financial/functions.c:1133
2726
#: ../plugins/fn-financial/functions.c:1865
2727
#: ../plugins/fn-financial/functions.c:2221
2728
#: ../plugins/fn-financial/functions.c:2271
2729
#: ../plugins/fn-financial/functions.c:2380
2730
#: ../plugins/fn-financial/functions.c:2425
2731
#: ../plugins/fn-financial/functions.c:2464
2732
#: ../plugins/fn-financial/functions.c:2614
2733
#: ../plugins/fn-financial/functions.c:2710
2734
#: ../plugins/fn-financial/functions.c:2788
2735
#: ../plugins/fn-financial/functions.c:2960
2736
#: ../plugins/fn-financial/functions.c:2984
2737
#: ../plugins/fn-financial/functions.c:3008
2738
#: ../plugins/fn-financial/functions.c:3032
2739
#: ../plugins/fn-financial/functions.c:3058
2740
#: ../plugins/fn-financial/functions.c:3084
2741
#: ../plugins/fn-financial/functions.c:3196
2790
#: ../plugins/fn-financial/functions.c:451
2791
#: ../plugins/fn-financial/functions.c:489
2792
#: ../plugins/fn-financial/functions.c:527
2793
#: ../plugins/fn-financial/functions.c:568
2794
#: ../plugins/fn-financial/functions.c:604
2795
#: ../plugins/fn-financial/functions.c:649
2796
#: ../plugins/fn-financial/functions.c:1087
2797
#: ../plugins/fn-financial/functions.c:1125
2798
#: ../plugins/fn-financial/functions.c:1159
2799
#: ../plugins/fn-financial/functions.c:1891
2800
#: ../plugins/fn-financial/functions.c:2253
2801
#: ../plugins/fn-financial/functions.c:2303
2802
#: ../plugins/fn-financial/functions.c:2412
2803
#: ../plugins/fn-financial/functions.c:2457
2804
#: ../plugins/fn-financial/functions.c:2496
2805
#: ../plugins/fn-financial/functions.c:2646
2806
#: ../plugins/fn-financial/functions.c:2742
2807
#: ../plugins/fn-financial/functions.c:2820
2808
#: ../plugins/fn-financial/functions.c:3000
2809
#: ../plugins/fn-financial/functions.c:3024
2810
#: ../plugins/fn-financial/functions.c:3048
2811
#: ../plugins/fn-financial/functions.c:3072
2812
#: ../plugins/fn-financial/functions.c:3098
2813
#: ../plugins/fn-financial/functions.c:3124
2814
#: ../plugins/fn-financial/functions.c:3236
2742
2815
msgid "maturity:maturity date"
2745
#: ../plugins/fn-financial/functions.c:429
2746
msgid "ACCRINT calculates the accrued interest from @{issue} to @{maturity}."
2749
#: ../plugins/fn-financial/functions.c:430
2818
#: ../plugins/fn-financial/functions.c:453
2819
msgid "par:par value"
2822
#: ../plugins/fn-financial/functions.c:455
2823
msgid "ACCRINTM calculates the accrued interest from @{issue} to @{maturity}."
2826
#: ../plugins/fn-financial/functions.c:456
2750
2827
msgid "@{par} defaults to $1000."
2753
#: ../plugins/fn-financial/functions.c:461
2830
#: ../plugins/fn-financial/functions.c:487
2754
2831
msgid "INTRATE:interest rate"
2757
#: ../plugins/fn-financial/functions.c:464
2758
#: ../plugins/fn-financial/functions.c:502
2834
#: ../plugins/fn-financial/functions.c:490
2835
#: ../plugins/fn-financial/functions.c:528
2759
2836
msgid "investment:amount paid on settlement"
2762
#: ../plugins/fn-financial/functions.c:465
2763
#: ../plugins/fn-financial/functions.c:544
2764
#: ../plugins/fn-financial/functions.c:625
2765
#: ../plugins/fn-financial/functions.c:2224
2766
#: ../plugins/fn-financial/functions.c:2274
2767
#: ../plugins/fn-financial/functions.c:2382
2768
#: ../plugins/fn-financial/functions.c:2469
2769
#: ../plugins/fn-financial/functions.c:2619
2770
#: ../plugins/fn-financial/functions.c:2714
2771
#: ../plugins/fn-financial/functions.c:2792
2839
#: ../plugins/fn-financial/functions.c:491
2840
#: ../plugins/fn-financial/functions.c:570
2841
#: ../plugins/fn-financial/functions.c:651
2842
#: ../plugins/fn-financial/functions.c:2256
2843
#: ../plugins/fn-financial/functions.c:2306
2844
#: ../plugins/fn-financial/functions.c:2414
2845
#: ../plugins/fn-financial/functions.c:2501
2846
#: ../plugins/fn-financial/functions.c:2651
2847
#: ../plugins/fn-financial/functions.c:2746
2848
#: ../plugins/fn-financial/functions.c:2824
2772
2849
msgid "redemption:amount received at maturity"
2775
#: ../plugins/fn-financial/functions.c:467
2852
#: ../plugins/fn-financial/functions.c:493
2776
2853
msgid "INTRATE calculates the interest of a fully vested security."
2779
#: ../plugins/fn-financial/functions.c:499
2856
#: ../plugins/fn-financial/functions.c:525
2780
2857
msgid "RECEIVED:amount to be received at maturity"
2783
#: ../plugins/fn-financial/functions.c:505
2860
#: ../plugins/fn-financial/functions.c:531
2784
2861
msgid "RECEIVED calculates the amount to be received when a security matures."
2787
#: ../plugins/fn-financial/functions.c:540
2864
#: ../plugins/fn-financial/functions.c:566
2788
2865
msgid "PRICEDISC:discounted price"
2791
#: ../plugins/fn-financial/functions.c:543
2792
#: ../plugins/fn-financial/functions.c:580
2793
#: ../plugins/fn-financial/functions.c:1062
2794
#: ../plugins/fn-financial/functions.c:1100
2868
#: ../plugins/fn-financial/functions.c:569
2869
#: ../plugins/fn-financial/functions.c:606
2870
#: ../plugins/fn-financial/functions.c:1088
2871
#: ../plugins/fn-financial/functions.c:1126
2795
2872
msgid "discount:annual rate at which to discount"
2798
#: ../plugins/fn-financial/functions.c:546
2875
#: ../plugins/fn-financial/functions.c:572
2800
2877
"PRICEDISC calculates the price per $100 face value of a bond that does not "
2801
2878
"pay interest at maturity."
2804
#: ../plugins/fn-financial/functions.c:576
2881
#: ../plugins/fn-financial/functions.c:602
2805
2882
msgid "PRICEMAT:price at maturity"
2808
#: ../plugins/fn-financial/functions.c:581
2809
#: ../plugins/fn-financial/functions.c:1867
2810
#: ../plugins/fn-financial/functions.c:2223
2811
#: ../plugins/fn-financial/functions.c:2468
2812
#: ../plugins/fn-financial/functions.c:2713
2813
#: ../plugins/fn-financial/functions.c:3198
2885
#: ../plugins/fn-financial/functions.c:607
2886
#: ../plugins/fn-financial/functions.c:1893
2887
#: ../plugins/fn-financial/functions.c:2255
2888
#: ../plugins/fn-financial/functions.c:2500
2889
#: ../plugins/fn-financial/functions.c:2745
2890
#: ../plugins/fn-financial/functions.c:3238
2814
2891
msgid "yield:annual yield of security"
2817
#: ../plugins/fn-financial/functions.c:583
2894
#: ../plugins/fn-financial/functions.c:609
2819
2896
"PRICEMAT calculates the price per $100 face value of a bond that pays "
2820
2897
"interest at maturity."
2823
#: ../plugins/fn-financial/functions.c:621
2900
#: ../plugins/fn-financial/functions.c:647
2824
2901
msgid "DISC:discount rate"
2827
#: ../plugins/fn-financial/functions.c:624
2904
#: ../plugins/fn-financial/functions.c:650
2828
2905
msgid "par:price per $100 face value"
2831
#: ../plugins/fn-financial/functions.c:627
2908
#: ../plugins/fn-financial/functions.c:653
2832
2909
msgid "DISC calculates the discount rate for a security."
2835
#: ../plugins/fn-financial/functions.c:628
2912
#: ../plugins/fn-financial/functions.c:654
2836
2913
msgid "@{redemption} is the redemption value per $100 face value."
2839
#: ../plugins/fn-financial/functions.c:659
2916
#: ../plugins/fn-financial/functions.c:685
2840
2917
msgid "EFFECT:effective interest rate"
2843
#: ../plugins/fn-financial/functions.c:661
2844
#: ../plugins/fn-financial/functions.c:686
2920
#: ../plugins/fn-financial/functions.c:687
2921
#: ../plugins/fn-financial/functions.c:712
2845
2922
msgid "nper:number of periods used for compounding"
2848
#: ../plugins/fn-financial/functions.c:662
2925
#: ../plugins/fn-financial/functions.c:688
2850
2927
"EFFECT calculates the effective interest rate using the formula (1+@{rate}/@"
2851
2928
"{nper})^@{nper}-1."
2854
#: ../plugins/fn-financial/functions.c:684
2931
#: ../plugins/fn-financial/functions.c:710
2855
2932
msgid "NOMINAL:nominal interest rate"
2858
#: ../plugins/fn-financial/functions.c:685
2859
#: ../plugins/fn-financial/functions.c:710
2860
#: ../plugins/fn-financial/functions.c:1516
2861
#: ../plugins/fn-financial/functions.c:1702
2862
#: ../plugins/fn-financial/functions.c:1732
2863
#: ../plugins/fn-financial/functions.c:1772
2864
#: ../plugins/fn-financial/functions.c:1816
2865
#: ../plugins/fn-financial/functions.c:1908
2866
#: ../plugins/fn-financial/functions.c:3107
2867
#: ../plugins/fn-financial/functions.c:3151
2935
#: ../plugins/fn-financial/functions.c:711
2936
#: ../plugins/fn-financial/functions.c:736
2937
#: ../plugins/fn-financial/functions.c:1542
2938
#: ../plugins/fn-financial/functions.c:1728
2939
#: ../plugins/fn-financial/functions.c:1758
2940
#: ../plugins/fn-financial/functions.c:1798
2941
#: ../plugins/fn-financial/functions.c:1842
2942
#: ../plugins/fn-financial/functions.c:1934
2868
2943
msgid "rate:effective annual interest rate"
2871
#: ../plugins/fn-financial/functions.c:687
2946
#: ../plugins/fn-financial/functions.c:713
2872
2947
msgid "NOMINAL calculates the nominal interest rate from the effective rate."
2875
#: ../plugins/fn-financial/functions.c:709
2950
#: ../plugins/fn-financial/functions.c:735
2876
2951
msgid "ISPMT:interest payment for period"
2879
#: ../plugins/fn-financial/functions.c:711
2880
#: ../plugins/fn-financial/functions.c:1733
2881
#: ../plugins/fn-financial/functions.c:1773
2954
#: ../plugins/fn-financial/functions.c:737
2955
#: ../plugins/fn-financial/functions.c:1759
2956
#: ../plugins/fn-financial/functions.c:1799
2882
2957
msgid "per:period number"
2885
#: ../plugins/fn-financial/functions.c:712
2886
#: ../plugins/fn-financial/functions.c:1166
2887
#: ../plugins/fn-financial/functions.c:1433
2888
#: ../plugins/fn-financial/functions.c:1667
2889
#: ../plugins/fn-financial/functions.c:1703
2890
#: ../plugins/fn-financial/functions.c:1734
2891
#: ../plugins/fn-financial/functions.c:1774
2892
#: ../plugins/fn-financial/functions.c:3108
2893
#: ../plugins/fn-financial/functions.c:3152
2960
#: ../plugins/fn-financial/functions.c:738
2961
#: ../plugins/fn-financial/functions.c:1192
2962
#: ../plugins/fn-financial/functions.c:1459
2963
#: ../plugins/fn-financial/functions.c:1693
2964
#: ../plugins/fn-financial/functions.c:1729
2965
#: ../plugins/fn-financial/functions.c:1760
2966
#: ../plugins/fn-financial/functions.c:1800
2967
#: ../plugins/fn-financial/functions.c:3148
2968
#: ../plugins/fn-financial/functions.c:3192
2894
2969
msgid "nper:number of periods"
2897
#: ../plugins/fn-financial/functions.c:713
2898
#: ../plugins/fn-financial/functions.c:1168
2899
#: ../plugins/fn-financial/functions.c:1281
2900
#: ../plugins/fn-financial/functions.c:1669
2901
#: ../plugins/fn-financial/functions.c:1704
2902
#: ../plugins/fn-financial/functions.c:1735
2903
#: ../plugins/fn-financial/functions.c:1775
2904
#: ../plugins/fn-financial/functions.c:1818
2905
#: ../plugins/fn-financial/functions.c:1909
2906
#: ../plugins/fn-financial/functions.c:3109
2907
#: ../plugins/fn-financial/functions.c:3153
2972
#: ../plugins/fn-financial/functions.c:739
2973
#: ../plugins/fn-financial/functions.c:1194
2974
#: ../plugins/fn-financial/functions.c:1307
2975
#: ../plugins/fn-financial/functions.c:1695
2976
#: ../plugins/fn-financial/functions.c:1730
2977
#: ../plugins/fn-financial/functions.c:1761
2978
#: ../plugins/fn-financial/functions.c:1801
2979
#: ../plugins/fn-financial/functions.c:1844
2980
#: ../plugins/fn-financial/functions.c:1935
2981
#: ../plugins/fn-financial/functions.c:3149
2982
#: ../plugins/fn-financial/functions.c:3193
2908
2983
msgid "pv:present value"
2911
#: ../plugins/fn-financial/functions.c:714
2986
#: ../plugins/fn-financial/functions.c:740
2912
2987
msgid "ISPMT calculates the interest payment for period number @{per}."
2915
#: ../plugins/fn-financial/functions.c:745
2990
#: ../plugins/fn-financial/functions.c:771
2916
2991
msgid "DB:depreciation of an asset"
2919
#: ../plugins/fn-financial/functions.c:746
2920
#: ../plugins/fn-financial/functions.c:796
2921
#: ../plugins/fn-financial/functions.c:845
2922
#: ../plugins/fn-financial/functions.c:875
2923
#: ../plugins/fn-financial/functions.c:2865
2924
#: ../plugins/fn-financial/functions.c:2913
2925
#: ../plugins/fn-financial/functions.c:3240
2994
#: ../plugins/fn-financial/functions.c:772
2995
#: ../plugins/fn-financial/functions.c:822
2996
#: ../plugins/fn-financial/functions.c:871
2997
#: ../plugins/fn-financial/functions.c:901
2998
#: ../plugins/fn-financial/functions.c:2897
2999
#: ../plugins/fn-financial/functions.c:2953
3000
#: ../plugins/fn-financial/functions.c:3280
2926
3001
msgid "cost:initial cost of asset"
2929
#: ../plugins/fn-financial/functions.c:747
2930
#: ../plugins/fn-financial/functions.c:797
2931
#: ../plugins/fn-financial/functions.c:846
2932
#: ../plugins/fn-financial/functions.c:876
2933
#: ../plugins/fn-financial/functions.c:2868
2934
#: ../plugins/fn-financial/functions.c:2916
2935
#: ../plugins/fn-financial/functions.c:3241
3004
#: ../plugins/fn-financial/functions.c:773
3005
#: ../plugins/fn-financial/functions.c:823
3006
#: ../plugins/fn-financial/functions.c:872
3007
#: ../plugins/fn-financial/functions.c:902
3008
#: ../plugins/fn-financial/functions.c:2900
3009
#: ../plugins/fn-financial/functions.c:2956
3010
#: ../plugins/fn-financial/functions.c:3281
2936
3011
msgid "salvage:value after depreciation"
2939
#: ../plugins/fn-financial/functions.c:748
2940
#: ../plugins/fn-financial/functions.c:798
2941
#: ../plugins/fn-financial/functions.c:847
2942
#: ../plugins/fn-financial/functions.c:877
2943
#: ../plugins/fn-financial/functions.c:3242
3014
#: ../plugins/fn-financial/functions.c:774
3015
#: ../plugins/fn-financial/functions.c:824
3016
#: ../plugins/fn-financial/functions.c:873
3017
#: ../plugins/fn-financial/functions.c:903
3018
#: ../plugins/fn-financial/functions.c:3282
2944
3019
msgid "life:number of periods"
2947
#: ../plugins/fn-financial/functions.c:749
2948
#: ../plugins/fn-financial/functions.c:799
2949
#: ../plugins/fn-financial/functions.c:878
2950
#: ../plugins/fn-financial/functions.c:2869
2951
#: ../plugins/fn-financial/functions.c:2917
3022
#: ../plugins/fn-financial/functions.c:775
3023
#: ../plugins/fn-financial/functions.c:825
3024
#: ../plugins/fn-financial/functions.c:904
3025
#: ../plugins/fn-financial/functions.c:2901
3026
#: ../plugins/fn-financial/functions.c:2957
2952
3027
msgid "period:subject period"
2955
#: ../plugins/fn-financial/functions.c:750
3030
#: ../plugins/fn-financial/functions.c:776
2956
3031
msgid "month:number of months in first year of depreciation"
2959
#: ../plugins/fn-financial/functions.c:751
3034
#: ../plugins/fn-financial/functions.c:777
2961
3036
"DB calculates the depreciation of an asset for a given period using the "
2962
3037
"fixed-declining balance method."
2965
#: ../plugins/fn-financial/functions.c:795
3040
#: ../plugins/fn-financial/functions.c:821
2966
3041
msgid "DDB:depreciation of an asset"
2969
#: ../plugins/fn-financial/functions.c:800
2970
#: ../plugins/fn-financial/functions.c:3245
3044
#: ../plugins/fn-financial/functions.c:826
3045
#: ../plugins/fn-financial/functions.c:3285
2971
3046
msgid "factor:factor at which the balance declines"
2974
#: ../plugins/fn-financial/functions.c:801
3049
#: ../plugins/fn-financial/functions.c:827
2976
3051
"DDB calculates the depreciation of an asset for a given period using the "
2977
3052
"double-declining balance method."
2980
#: ../plugins/fn-financial/functions.c:844
3055
#: ../plugins/fn-financial/functions.c:870
2981
3056
msgid "SLN:depreciation of an asset"
2984
#: ../plugins/fn-financial/functions.c:848
3059
#: ../plugins/fn-financial/functions.c:874
2986
3061
"SLN calculates the depreciation of an asset using the straight-line method."
2989
#: ../plugins/fn-financial/functions.c:874
3064
#: ../plugins/fn-financial/functions.c:900
2990
3065
msgid "SYD:sum-of-years depreciation"
2993
#: ../plugins/fn-financial/functions.c:879
3068
#: ../plugins/fn-financial/functions.c:905
2995
3070
"SYD calculates the depreciation of an asset using the sum-of-years method."
2998
#: ../plugins/fn-financial/functions.c:907
3073
#: ../plugins/fn-financial/functions.c:933
2999
3074
msgid "DOLLARDE:convert to decimal dollar amount"
3002
#: ../plugins/fn-financial/functions.c:908
3077
#: ../plugins/fn-financial/functions.c:934
3003
3078
msgid "fractional_dollar:amount to convert"
3006
#: ../plugins/fn-financial/functions.c:909
3007
#: ../plugins/fn-financial/functions.c:957
3081
#: ../plugins/fn-financial/functions.c:935
3082
#: ../plugins/fn-financial/functions.c:983
3008
3083
msgid "fraction:denominator"
3011
#: ../plugins/fn-financial/functions.c:910
3086
#: ../plugins/fn-financial/functions.c:936
3013
3088
"DOLLARDE converts a fractional dollar amount into a decimal amount. This is "
3014
3089
"the inverse of the DOLLARFR function."
3017
#: ../plugins/fn-financial/functions.c:955
3092
#: ../plugins/fn-financial/functions.c:981
3018
3093
msgid "DOLLARFR:convert to dollar fraction"
3021
#: ../plugins/fn-financial/functions.c:956
3096
#: ../plugins/fn-financial/functions.c:982
3022
3097
msgid "decimal_dollar:amount to convert"
3025
#: ../plugins/fn-financial/functions.c:958
3100
#: ../plugins/fn-financial/functions.c:984
3027
"DOLLARFR converts a fractional dollar amount into a fraction which is "
3102
"DOLLARFR converts a decimal dollar amount into a fractional amount which is "
3028
3103
"represented as the digits after the decimal point. For example, 2/8 would "
3029
"be represented as .2 while 3/16 would be represented as .03."
3104
"be represented as .2 while 3/16 would be represented as .03. This is the "
3105
"inverse of the DOLLARDE function."
3032
#: ../plugins/fn-financial/functions.c:1001
3108
#: ../plugins/fn-financial/functions.c:1027
3033
3109
msgid "MIRR:modified internal rate of return"
3036
#: ../plugins/fn-financial/functions.c:1002
3037
#: ../plugins/fn-financial/functions.c:1315
3038
#: ../plugins/fn-financial/functions.c:1517
3039
#: ../plugins/fn-financial/functions.c:1572
3112
#: ../plugins/fn-financial/functions.c:1028
3113
#: ../plugins/fn-financial/functions.c:1341
3114
#: ../plugins/fn-financial/functions.c:1543
3115
#: ../plugins/fn-financial/functions.c:1598
3040
3116
msgid "values:cash flow"
3043
#: ../plugins/fn-financial/functions.c:1003
3119
#: ../plugins/fn-financial/functions.c:1029
3044
3120
msgid "finance_rate:interest rate for financing cost"
3047
#: ../plugins/fn-financial/functions.c:1004
3123
#: ../plugins/fn-financial/functions.c:1030
3048
3124
msgid "reinvest_rate:interest rate for reinvestments"
3051
#: ../plugins/fn-financial/functions.c:1005
3127
#: ../plugins/fn-financial/functions.c:1031
3053
3129
"MIRR calculates the modified internal rate of return of a periodic cash flow."
3056
#: ../plugins/fn-financial/functions.c:1059
3132
#: ../plugins/fn-financial/functions.c:1085
3057
3133
msgid "TBILLEQ:bond-equivalent yield for a treasury bill"
3060
#: ../plugins/fn-financial/functions.c:1063
3136
#: ../plugins/fn-financial/functions.c:1089
3061
3137
msgid "TBILLEQ calculates the bond-equivalent yield for a treasury bill."
3064
#: ../plugins/fn-financial/functions.c:1097
3140
#: ../plugins/fn-financial/functions.c:1123
3065
3141
msgid "TBILLPRICE:price of a treasury bill"
3068
#: ../plugins/fn-financial/functions.c:1101
3144
#: ../plugins/fn-financial/functions.c:1127
3070
3146
"TBILLPRICE calculates the price per $100 face value for a treasury bill."
3073
#: ../plugins/fn-financial/functions.c:1131
3149
#: ../plugins/fn-financial/functions.c:1157
3074
3150
msgid "TBILLYIELD:yield of a treasury bill"
3077
#: ../plugins/fn-financial/functions.c:1134
3153
#: ../plugins/fn-financial/functions.c:1160
3078
3154
msgid "price:price"
3081
#: ../plugins/fn-financial/functions.c:1135
3157
#: ../plugins/fn-financial/functions.c:1161
3082
3158
msgid "TBILLYIELD calculates the yield of a treasury bill."
3085
#: ../plugins/fn-financial/functions.c:1165
3161
#: ../plugins/fn-financial/functions.c:1191
3086
3162
msgid "RATE:rate of investment"
3089
#: ../plugins/fn-financial/functions.c:1167
3090
#: ../plugins/fn-financial/functions.c:1434
3091
#: ../plugins/fn-financial/functions.c:1668
3092
#: ../plugins/fn-financial/functions.c:1817
3165
#: ../plugins/fn-financial/functions.c:1193
3166
#: ../plugins/fn-financial/functions.c:1460
3167
#: ../plugins/fn-financial/functions.c:1694
3168
#: ../plugins/fn-financial/functions.c:1843
3093
3169
msgid "pmt:payment at each period"
3096
#: ../plugins/fn-financial/functions.c:1169
3097
#: ../plugins/fn-financial/functions.c:1282
3098
#: ../plugins/fn-financial/functions.c:1435
3099
#: ../plugins/fn-financial/functions.c:1705
3100
#: ../plugins/fn-financial/functions.c:1736
3101
#: ../plugins/fn-financial/functions.c:1776
3102
#: ../plugins/fn-financial/functions.c:1819
3103
#: ../plugins/fn-financial/functions.c:1910
3172
#: ../plugins/fn-financial/functions.c:1195
3173
#: ../plugins/fn-financial/functions.c:1308
3174
#: ../plugins/fn-financial/functions.c:1461
3175
#: ../plugins/fn-financial/functions.c:1731
3176
#: ../plugins/fn-financial/functions.c:1762
3177
#: ../plugins/fn-financial/functions.c:1802
3178
#: ../plugins/fn-financial/functions.c:1845
3179
#: ../plugins/fn-financial/functions.c:1936
3104
3180
msgid "fv:future value"
3107
#: ../plugins/fn-financial/functions.c:1170
3108
#: ../plugins/fn-financial/functions.c:1436
3109
#: ../plugins/fn-financial/functions.c:1670
3110
#: ../plugins/fn-financial/functions.c:1706
3111
#: ../plugins/fn-financial/functions.c:1737
3112
#: ../plugins/fn-financial/functions.c:1777
3113
#: ../plugins/fn-financial/functions.c:1820
3114
#: ../plugins/fn-financial/functions.c:3112
3115
#: ../plugins/fn-financial/functions.c:3156
3183
#: ../plugins/fn-financial/functions.c:1196
3184
#: ../plugins/fn-financial/functions.c:1462
3185
#: ../plugins/fn-financial/functions.c:1696
3186
#: ../plugins/fn-financial/functions.c:1732
3187
#: ../plugins/fn-financial/functions.c:1763
3188
#: ../plugins/fn-financial/functions.c:1803
3189
#: ../plugins/fn-financial/functions.c:1846
3190
#: ../plugins/fn-financial/functions.c:3152
3191
#: ../plugins/fn-financial/functions.c:3196
3116
3192
msgid "type:payment type"
3119
#: ../plugins/fn-financial/functions.c:1171
3120
#: ../plugins/fn-financial/functions.c:1316
3121
#: ../plugins/fn-financial/functions.c:1574
3195
#: ../plugins/fn-financial/functions.c:1197
3196
#: ../plugins/fn-financial/functions.c:1342
3197
#: ../plugins/fn-financial/functions.c:1600
3122
3198
msgid "guess:an estimate of what the result should be"
3125
#: ../plugins/fn-financial/functions.c:1172
3201
#: ../plugins/fn-financial/functions.c:1198
3126
3202
msgid "RATE calculates the rate of return."
3129
#: ../plugins/fn-financial/functions.c:1174
3130
#: ../plugins/fn-financial/functions.c:1319
3131
#: ../plugins/fn-financial/functions.c:1576
3205
#: ../plugins/fn-financial/functions.c:1200
3206
#: ../plugins/fn-financial/functions.c:1345
3207
#: ../plugins/fn-financial/functions.c:1602
3133
3209
"The optional @{guess} is needed because there can be more than one valid "
3134
3210
"result. It defaults to 10%."
3137
#: ../plugins/fn-financial/functions.c:1279
3213
#: ../plugins/fn-financial/functions.c:1305
3138
3214
msgid "RRI:equivalent interest rate for an investment increasing in value"
3141
#: ../plugins/fn-financial/functions.c:1280
3217
#: ../plugins/fn-financial/functions.c:1306
3142
3218
msgid "p:number of periods"
3145
#: ../plugins/fn-financial/functions.c:1283
3221
#: ../plugins/fn-financial/functions.c:1309
3147
3223
"RRI determines an equivalent interest rate for an investment that increases "
3148
3224
"in value. The interest is compounded after each complete period."
3151
#: ../plugins/fn-financial/functions.c:1285
3227
#: ../plugins/fn-financial/functions.c:1311
3153
3229
"Note that @{p} need not be an integer but for fractional value the "
3154
3230
"calculated rate is only approximate."
3157
#: ../plugins/fn-financial/functions.c:1314
3233
#: ../plugins/fn-financial/functions.c:1340
3158
3234
msgid "IRR:internal rate of return"
3161
#: ../plugins/fn-financial/functions.c:1317
3237
#: ../plugins/fn-financial/functions.c:1343
3163
3239
"IRR calculates the internal rate of return of a cash flow with periodic "
3164
3240
"payments. @{values} lists the payments (negative values) and receipts "
3165
3241
"(positive values) for each period."
3168
#: ../plugins/fn-financial/functions.c:1431
3244
#: ../plugins/fn-financial/functions.c:1457
3169
3245
msgid "PV:present value"
3172
#: ../plugins/fn-financial/functions.c:1432
3173
#: ../plugins/fn-financial/functions.c:1472
3174
#: ../plugins/fn-financial/functions.c:1666
3248
#: ../plugins/fn-financial/functions.c:1458
3249
#: ../plugins/fn-financial/functions.c:1498
3250
#: ../plugins/fn-financial/functions.c:1692
3175
3251
msgid "rate:effective interest rate per period"
3178
#: ../plugins/fn-financial/functions.c:1437
3254
#: ../plugins/fn-financial/functions.c:1463
3180
3256
"PV calculates the present value of @{fv} which is @{nper} periods into the "
3181
3257
"future, assuming a periodic payment of @{pmt} and an interest rate of @"
3182
3258
"{rate} per period."
3185
#: ../plugins/fn-financial/functions.c:1471
3261
#: ../plugins/fn-financial/functions.c:1497
3186
3262
msgid "NPV:net present value"
3189
#: ../plugins/fn-financial/functions.c:1473
3265
#: ../plugins/fn-financial/functions.c:1499
3190
3266
msgid "value1:cash flow for period 1"
3193
#: ../plugins/fn-financial/functions.c:1474
3269
#: ../plugins/fn-financial/functions.c:1500
3194
3270
msgid "value2:cash flow for period 2"
3197
#: ../plugins/fn-financial/functions.c:1475
3273
#: ../plugins/fn-financial/functions.c:1501
3198
3274
msgid "NPV calculates the net present value of a cash flow."
3201
#: ../plugins/fn-financial/functions.c:1515
3277
#: ../plugins/fn-financial/functions.c:1541
3202
3278
msgid "XNPV:net present value"
3205
#: ../plugins/fn-financial/functions.c:1518
3206
#: ../plugins/fn-financial/functions.c:1573
3281
#: ../plugins/fn-financial/functions.c:1544
3282
#: ../plugins/fn-financial/functions.c:1599
3207
3283
msgid "dates:dates of cash flow"
3210
#: ../plugins/fn-financial/functions.c:1519
3286
#: ../plugins/fn-financial/functions.c:1545
3211
3287
msgid "XNPV calculates the net present value of a cash flow at irregular times"
3214
#: ../plugins/fn-financial/functions.c:1571
3290
#: ../plugins/fn-financial/functions.c:1597
3215
3291
msgid "XIRR:internal rate of return"
3218
#: ../plugins/fn-financial/functions.c:1575
3294
#: ../plugins/fn-financial/functions.c:1601
3220
3296
"XIRR calculates the annualized internal rate of return of a cash flow at "
3221
3297
"arbitrary points in time. @{values} lists the payments (negative values) "
3222
3298
"and receipts (positive values) with one value for each entry in @{dates}."
3225
#: ../plugins/fn-financial/functions.c:1665
3301
#: ../plugins/fn-financial/functions.c:1691
3226
3302
msgid "FV:future value"
3229
#: ../plugins/fn-financial/functions.c:1671
3305
#: ../plugins/fn-financial/functions.c:1697
3231
3307
"FV calculates the future value of @{pv} moved @{nper} periods into the "
3232
3308
"future, assuming a periodic payment of @{pmt} and an interest rate of @"
3233
3309
"{rate} per period."
3236
#: ../plugins/fn-financial/functions.c:1701
3312
#: ../plugins/fn-financial/functions.c:1727
3237
3313
msgid "PMT:payment for annuity"
3240
#: ../plugins/fn-financial/functions.c:1707
3316
#: ../plugins/fn-financial/functions.c:1733
3241
3317
msgid "PMT calculates the payment amount for an annuity."
3244
#: ../plugins/fn-financial/functions.c:1731
3320
#: ../plugins/fn-financial/functions.c:1757
3245
3321
msgid "IPMT:interest payment for period"
3248
#: ../plugins/fn-financial/functions.c:1738
3324
#: ../plugins/fn-financial/functions.c:1764
3250
3326
"IPMT calculates the interest part of an annuity's payment for period number @"
3254
#: ../plugins/fn-financial/functions.c:1771
3330
#: ../plugins/fn-financial/functions.c:1797
3255
3331
msgid "PPMT:interest payment for period"
3258
#: ../plugins/fn-financial/functions.c:1778
3334
#: ../plugins/fn-financial/functions.c:1804
3260
3336
"PPMT calculates the principal part of an annuity's payment for period number "
3264
#: ../plugins/fn-financial/functions.c:1815
3340
#: ../plugins/fn-financial/functions.c:1841
3265
3341
msgid "NPER:number of periods"
3268
#: ../plugins/fn-financial/functions.c:1821
3344
#: ../plugins/fn-financial/functions.c:1847
3270
3346
"NPER calculates the number of periods of an investment based on periodic "
3271
3347
"constant payments and a constant interest rate."
3274
#: ../plugins/fn-financial/functions.c:1863
3350
#: ../plugins/fn-financial/functions.c:1889
3275
3351
msgid "DURATION:the duration of a security"
3278
#: ../plugins/fn-financial/functions.c:1866
3279
#: ../plugins/fn-financial/functions.c:3197
3354
#: ../plugins/fn-financial/functions.c:1892
3355
#: ../plugins/fn-financial/functions.c:3237
3280
3356
msgid "coupon:annual coupon rate"
3283
#: ../plugins/fn-financial/functions.c:1870
3359
#: ../plugins/fn-financial/functions.c:1896
3284
3360
msgid "DURATION calculates the duration of a security."
3287
#: ../plugins/fn-financial/functions.c:1907
3363
#: ../plugins/fn-financial/functions.c:1933
3288
3364
msgid "G_DURATION:the duration of a investment"
3291
#: ../plugins/fn-financial/functions.c:1911
3367
#: ../plugins/fn-financial/functions.c:1937
3293
3369
"G_DURATION calculates the number of periods needed for an investment to "
3294
3370
"attain a desired value."
3297
#: ../plugins/fn-financial/functions.c:1912
3373
#: ../plugins/fn-financial/functions.c:1938
3298
3374
msgid "G_DURATION is the OpenFormula function PDURATION."
3301
#: ../plugins/fn-financial/functions.c:1940
3377
#: ../plugins/fn-financial/functions.c:1966
3302
3378
msgid "FVSCHEDULE:future value"
3305
#: ../plugins/fn-financial/functions.c:1941
3381
#: ../plugins/fn-financial/functions.c:1967
3306
3382
msgid "principal:initial value"
3309
#: ../plugins/fn-financial/functions.c:1942
3385
#: ../plugins/fn-financial/functions.c:1968
3310
3386
msgid "schedule:range of interest rates"
3313
#: ../plugins/fn-financial/functions.c:1943
3389
#: ../plugins/fn-financial/functions.c:1969
3315
3391
"FVSCHEDULE calculates the future value of @{principal} after applying a "
3316
3392
"range of interest rates with compounding."
3319
#: ../plugins/fn-financial/functions.c:1976
3395
#: ../plugins/fn-financial/functions.c:2002
3320
3396
msgid "EURO:equivalent of 1 EUR"
3323
#: ../plugins/fn-financial/functions.c:1977
3399
#: ../plugins/fn-financial/functions.c:2003
3324
3400
msgid "currency:three-letter currency code"
3327
#: ../plugins/fn-financial/functions.c:1978
3403
#: ../plugins/fn-financial/functions.c:2004
3329
3405
"EURO calculates the national currency amount corresponding to 1 EUR for any "
3330
3406
"of the national currencies that were replaced by the Euro on its "
3331
3407
"introduction."
3334
#: ../plugins/fn-financial/functions.c:1979
3410
#: ../plugins/fn-financial/functions.c:2005
3336
3412
"@{currency} must be one of ATS (Austria), BEF (Belgium), CYP (Cyprus), DEM "
3337
"(Germany), ESP (Spain), EUR (Euro), FIM (Finland), FRF (France), GRD "
3338
"(Greece), IEP (Ireland), ITL (Italy), LUF (Luxembourg), MTL (Malta), NLG "
3339
"(The Netherlands), PTE (Portugal), SIT (Slovenia), or SKK (Slovakia)."
3413
"(Germany), EEK (Estonia), ESP (Spain), EUR (Euro), FIM (Finland), FRF "
3414
"(France), GRD (Greece), IEP (Ireland), ITL (Italy), LUF (Luxembourg), MTL "
3415
"(Malta), NLG (The Netherlands), PTE (Portugal), SIT (Slovenia), or SKK "
3342
#: ../plugins/fn-financial/functions.c:1997
3343
#: ../plugins/fn-financial/functions.c:2176
3419
#: ../plugins/fn-financial/functions.c:2024
3420
#: ../plugins/fn-financial/functions.c:2208
3344
3421
msgid "This function is not likely to be useful anymore."
3347
#: ../plugins/fn-financial/functions.c:2168
3424
#: ../plugins/fn-financial/functions.c:2199
3348
3425
msgid "EUROCONVERT:pre-Euro amount from one currency to another"
3351
#: ../plugins/fn-financial/functions.c:2169
3428
#: ../plugins/fn-financial/functions.c:2200
3352
3429
msgid "n:amount"
3355
#: ../plugins/fn-financial/functions.c:2170
3432
#: ../plugins/fn-financial/functions.c:2201
3356
3433
msgid "source:three-letter source currency code"
3359
#: ../plugins/fn-financial/functions.c:2171
3436
#: ../plugins/fn-financial/functions.c:2202
3360
3437
msgid "target:three-letter target currency code"
3363
#: ../plugins/fn-financial/functions.c:2172
3365
"full_precision:if true, the result is not rounded; if false the result is "
3366
"rounded to 0 or 2 decimals depending on the target currency; defaults to "
3440
#: ../plugins/fn-financial/functions.c:2203
3441
msgid "full_precision:whether to provide the full precision; defaults to false"
3370
#: ../plugins/fn-financial/functions.c:2173
3444
#: ../plugins/fn-financial/functions.c:2204
3372
3446
"triangulation_precision:number of digits (at least 3) to be rounded to after "
3373
"the source currency has been converted to euro; omitting this argument "
3374
"results in no rounding."
3447
"conversion of the source currency to euro; defaults to no rounding"
3377
#: ../plugins/fn-financial/functions.c:2174
3450
#: ../plugins/fn-financial/functions.c:2205
3379
3452
"EUROCONVERT converts @{n} units of currency @{source} to currency @"
3380
3453
"{target}. The rates used are the official ones used on the introduction of "
3384
#: ../plugins/fn-financial/functions.c:2175
3457
#: ../plugins/fn-financial/functions.c:2206
3459
"If @{full_precision} is true, the result is not rounded; if it false the "
3460
"result is rounded to 0 or 2 decimals depending on the target currency; "
3461
"defaults to false."
3464
#: ../plugins/fn-financial/functions.c:2207
3386
3466
"@{source} and @{target} must be one of the currencies listed for the EURO "
3390
#: ../plugins/fn-financial/functions.c:2219
3470
#: ../plugins/fn-financial/functions.c:2251
3391
3471
msgid "PRICE:price of a security"
3394
#: ../plugins/fn-financial/functions.c:2227
3474
#: ../plugins/fn-financial/functions.c:2259
3396
3476
"PRICE calculates the price per $100 face value of a security that pays "
3397
3477
"periodic interest."
3400
#: ../plugins/fn-financial/functions.c:2269
3480
#: ../plugins/fn-financial/functions.c:2301
3401
3481
msgid "YIELD:yield of a security"
3404
#: ../plugins/fn-financial/functions.c:2273
3405
#: ../plugins/fn-financial/functions.c:2381
3406
#: ../plugins/fn-financial/functions.c:2428
3407
#: ../plugins/fn-financial/functions.c:2618
3408
#: ../plugins/fn-financial/functions.c:2791
3484
#: ../plugins/fn-financial/functions.c:2305
3485
#: ../plugins/fn-financial/functions.c:2413
3486
#: ../plugins/fn-financial/functions.c:2460
3487
#: ../plugins/fn-financial/functions.c:2650
3488
#: ../plugins/fn-financial/functions.c:2823
3409
3489
msgid "price:price of security"
3412
#: ../plugins/fn-financial/functions.c:2277
3492
#: ../plugins/fn-financial/functions.c:2309
3413
3493
msgid "YIELD calculates the yield of a security that pays periodic interest."
3416
#: ../plugins/fn-financial/functions.c:2378
3496
#: ../plugins/fn-financial/functions.c:2410
3417
3497
msgid "YIELDDISC:yield of a discounted security"
3420
#: ../plugins/fn-financial/functions.c:2384
3500
#: ../plugins/fn-financial/functions.c:2416
3421
3501
msgid "YIELDDISC calculates the yield of a discounted security."
3424
#: ../plugins/fn-financial/functions.c:2423
3504
#: ../plugins/fn-financial/functions.c:2455
3425
3505
msgid "YIELDMAT:yield of a security"
3428
#: ../plugins/fn-financial/functions.c:2430
3508
#: ../plugins/fn-financial/functions.c:2462
3430
3510
"YIELDMAT calculates the yield of a security for which the interest is paid "
3431
3511
"at maturity date."
3434
#: ../plugins/fn-financial/functions.c:2462
3514
#: ../plugins/fn-financial/functions.c:2494
3435
3515
msgid "ODDFPRICE:price of a security that has an odd first period"
3438
#: ../plugins/fn-financial/functions.c:2466
3439
#: ../plugins/fn-financial/functions.c:2616
3518
#: ../plugins/fn-financial/functions.c:2498
3519
#: ../plugins/fn-financial/functions.c:2648
3440
3520
msgid "first_interest:first interest date"
3443
#: ../plugins/fn-financial/functions.c:2472
3523
#: ../plugins/fn-financial/functions.c:2504
3445
3525
"ODDFPRICE calculates the price per $100 face value of a security that pays "
3446
3526
"periodic interest, but has an odd first period."
3449
#: ../plugins/fn-financial/functions.c:2612
3529
#: ../plugins/fn-financial/functions.c:2644
3450
3530
msgid "ODDFYIELD:yield of a security that has an odd first period"
3453
#: ../plugins/fn-financial/functions.c:2622
3533
#: ../plugins/fn-financial/functions.c:2654
3455
3535
"ODDFYIELD calculates the yield of a security that pays periodic interest, "
3456
3536
"but has an odd first period."
3459
#: ../plugins/fn-financial/functions.c:2708
3539
#: ../plugins/fn-financial/functions.c:2740
3460
3540
msgid "ODDLPRICE:price of a security that has an odd last period"
3463
#: ../plugins/fn-financial/functions.c:2711
3464
#: ../plugins/fn-financial/functions.c:2789
3543
#: ../plugins/fn-financial/functions.c:2743
3544
#: ../plugins/fn-financial/functions.c:2821
3465
3545
msgid "last_interest:last interest date"
3468
#: ../plugins/fn-financial/functions.c:2717
3548
#: ../plugins/fn-financial/functions.c:2749
3470
3550
"ODDLPRICE calculates the price per $100 face value of a security that pays "
3471
3551
"periodic interest, but has an odd last period."
3474
#: ../plugins/fn-financial/functions.c:2786
3554
#: ../plugins/fn-financial/functions.c:2818
3475
3555
msgid "ODDLYIELD:yield of a security that has an odd last period"
3478
#: ../plugins/fn-financial/functions.c:2795
3558
#: ../plugins/fn-financial/functions.c:2827
3480
3560
"ODDLYIELD calculates the yield of a security that pays periodic interest, "
3481
3561
"but has an odd last period."
3484
#: ../plugins/fn-financial/functions.c:2864
3564
#: ../plugins/fn-financial/functions.c:2896
3485
3565
msgid "AMORDEGRC:depreciation of an asset using French accounting conventions"
3488
#: ../plugins/fn-financial/functions.c:2866
3489
#: ../plugins/fn-financial/functions.c:2914
3568
#: ../plugins/fn-financial/functions.c:2898
3569
#: ../plugins/fn-financial/functions.c:2954
3490
3570
msgid "purchase_date:date of purchase"
3493
#: ../plugins/fn-financial/functions.c:2867
3494
#: ../plugins/fn-financial/functions.c:2915
3573
#: ../plugins/fn-financial/functions.c:2899
3574
#: ../plugins/fn-financial/functions.c:2955
3495
3575
msgid "first_period:end of first period"
3498
#: ../plugins/fn-financial/functions.c:2870
3499
#: ../plugins/fn-financial/functions.c:2918
3578
#: ../plugins/fn-financial/functions.c:2902
3579
#: ../plugins/fn-financial/functions.c:2958
3500
3580
msgid "rate:depreciation rate"
3503
#: ../plugins/fn-financial/functions.c:2873
3583
#: ../plugins/fn-financial/functions.c:2905
3505
3585
"AMORDEGRC calculates the depreciation of an asset using French accounting "
3506
3586
"conventions. Assets purchased in the middle of a period take prorated "
3509
3589
"of the assets."
3512
#: ../plugins/fn-financial/functions.c:2876
3592
#: ../plugins/fn-financial/functions.c:2909
3594
"The depreciation coefficient used is:\n"
3595
"1.0 for an expected lifetime less than 3 years,\n"
3596
"1.5 for an expected lifetime of at least 3 years but less than 5 years,\n"
3597
"2.0 for an expected lifetime of at least 5 years but at most 6 years,\n"
3598
"2.5 for an expected lifetime of more than 6 years."
3601
#: ../plugins/fn-financial/functions.c:2914
3603
"Special depreciation rules are applied for the last two periods resulting in "
3604
"a possible total depreciation exceeding the difference of @{cost} - @"
3608
#: ../plugins/fn-financial/functions.c:2916
3513
3609
msgid "Named for AMORtissement DEGRessif Comptabilite."
3516
#: ../plugins/fn-financial/functions.c:2912
3612
#: ../plugins/fn-financial/functions.c:2952
3517
3613
msgid "AMORLINC:depreciation of an asset using French accounting conventions"
3520
#: ../plugins/fn-financial/functions.c:2921
3616
#: ../plugins/fn-financial/functions.c:2961
3522
3618
"AMORLINC calculates the depreciation of an asset using French accounting "
3523
3619
"conventions. Assets purchased in the middle of a period take prorated "
3524
3620
"depreciation into account. "
3527
#: ../plugins/fn-financial/functions.c:2923
3623
#: ../plugins/fn-financial/functions.c:2963
3528
3624
msgid "Named for AMORtissement LINeaire Comptabilite."
3531
#: ../plugins/fn-financial/functions.c:2958
3627
#: ../plugins/fn-financial/functions.c:2998
3532
3628
msgid "COUPDAYBS:number of days from coupon period to settlement"
3535
#: ../plugins/fn-financial/functions.c:2963
3536
#: ../plugins/fn-financial/functions.c:2987
3537
#: ../plugins/fn-financial/functions.c:3011
3538
#: ../plugins/fn-financial/functions.c:3035
3539
#: ../plugins/fn-financial/functions.c:3061
3540
#: ../plugins/fn-financial/functions.c:3087
3631
#: ../plugins/fn-financial/functions.c:3003
3632
#: ../plugins/fn-financial/functions.c:3027
3633
#: ../plugins/fn-financial/functions.c:3051
3634
#: ../plugins/fn-financial/functions.c:3075
3635
#: ../plugins/fn-financial/functions.c:3101
3636
#: ../plugins/fn-financial/functions.c:3127
3541
3637
msgid "eom:end-of-month flag"
3544
#: ../plugins/fn-financial/functions.c:2964
3640
#: ../plugins/fn-financial/functions.c:3004
3546
3642
"COUPDAYBS calculates the number of days from the beginning of the coupon "
3547
3643
"period to the settlement date."
3550
#: ../plugins/fn-financial/functions.c:2982
3646
#: ../plugins/fn-financial/functions.c:3022
3551
3647
msgid "COUPDAYS:number of days in the coupon period of the settlement date"
3554
#: ../plugins/fn-financial/functions.c:2988
3650
#: ../plugins/fn-financial/functions.c:3028
3556
3652
"COUPDAYS calculates the number of days in the coupon period of the "
3557
3653
"settlement date."
3560
#: ../plugins/fn-financial/functions.c:3006
3656
#: ../plugins/fn-financial/functions.c:3046
3562
3658
"COUPDAYSNC:number of days from the settlement date to the next coupon period"
3565
#: ../plugins/fn-financial/functions.c:3012
3661
#: ../plugins/fn-financial/functions.c:3052
3567
3663
"COUPDAYSNC calculates number of days from the settlement date to the next "
3568
3664
"coupon period."
3571
#: ../plugins/fn-financial/functions.c:3030
3667
#: ../plugins/fn-financial/functions.c:3070
3572
3668
msgid "COUPNCD:the next coupon date after settlement"
3575
#: ../plugins/fn-financial/functions.c:3036
3671
#: ../plugins/fn-financial/functions.c:3076
3576
3672
msgid "COUPNCD calculates the coupon date following settlement."
3579
#: ../plugins/fn-financial/functions.c:3056
3675
#: ../plugins/fn-financial/functions.c:3096
3580
3676
msgid "COUPPCD:the last coupon date before settlement"
3583
#: ../plugins/fn-financial/functions.c:3062
3679
#: ../plugins/fn-financial/functions.c:3102
3584
3680
msgid "COUPPCD calculates the coupon date preceding settlement."
3587
#: ../plugins/fn-financial/functions.c:3082
3683
#: ../plugins/fn-financial/functions.c:3122
3588
3684
msgid "COUPNUM:number of coupons"
3591
#: ../plugins/fn-financial/functions.c:3088
3687
#: ../plugins/fn-financial/functions.c:3128
3593
3689
"COUPNUM calculates the number of coupons to be paid between the settlement "
3594
3690
"and maturity dates, rounded up."
3597
#: ../plugins/fn-financial/functions.c:3106
3693
#: ../plugins/fn-financial/functions.c:3146
3598
3694
msgid "CUMIPMT:cumulative interest payment"
3601
#: ../plugins/fn-financial/functions.c:3110
3602
#: ../plugins/fn-financial/functions.c:3154
3603
#: ../plugins/fn-financial/functions.c:3243
3697
#: ../plugins/fn-financial/functions.c:3147
3698
#: ../plugins/fn-financial/functions.c:3191
3699
msgid "rate:interest rate per period"
3702
#: ../plugins/fn-financial/functions.c:3150
3703
#: ../plugins/fn-financial/functions.c:3194
3704
#: ../plugins/fn-financial/functions.c:3283
3604
3705
msgid "start_period:first period to accumulate for"
3607
#: ../plugins/fn-financial/functions.c:3111
3608
#: ../plugins/fn-financial/functions.c:3155
3609
#: ../plugins/fn-financial/functions.c:3244
3708
#: ../plugins/fn-financial/functions.c:3151
3709
#: ../plugins/fn-financial/functions.c:3195
3710
#: ../plugins/fn-financial/functions.c:3284
3610
3711
msgid "end_period:last period to accumulate for"
3613
#: ../plugins/fn-financial/functions.c:3113
3714
#: ../plugins/fn-financial/functions.c:3153
3615
3716
"CUMIPMT calculates the cumulative interest paid on a loan from @"
3616
3717
"{start_period} to @{end_period}."
3619
#: ../plugins/fn-financial/functions.c:3150
3720
#: ../plugins/fn-financial/functions.c:3190
3620
3721
msgid "CUMPRINC:cumulative principal"
3623
#: ../plugins/fn-financial/functions.c:3157
3724
#: ../plugins/fn-financial/functions.c:3197
3625
3726
"CUMPRINC calculates the cumulative principal paid on a loan from @"
3626
3727
"{start_period} to @{end_period}."
3629
#: ../plugins/fn-financial/functions.c:3194
3630
msgid "MDURATION:the Macauley duration of a security"
3633
#: ../plugins/fn-financial/functions.c:3201
3634
msgid "MDURATION calculates the Macauley duration of a security."
3637
#: ../plugins/fn-financial/functions.c:3239
3730
#: ../plugins/fn-financial/functions.c:3234
3731
msgid "MDURATION:the Macaulay duration of a security"
3734
#: ../plugins/fn-financial/functions.c:3241
3735
msgid "MDURATION calculates the Macaulay duration of a security."
3738
#: ../plugins/fn-financial/functions.c:3279
3638
3739
msgid "VDB:depreciation of an asset"
3641
#: ../plugins/fn-financial/functions.c:3246
3742
#: ../plugins/fn-financial/functions.c:3286
3642
3743
msgid "no_switch:do not switch to straight-line depreciation"
3645
#: ../plugins/fn-financial/functions.c:3247
3746
#: ../plugins/fn-financial/functions.c:3287
3647
3748
"VDB calculates the depreciation of an asset for a given period range using "
3648
"the double-declining balance method."
3749
"the variable-rate declining balance method."
3651
#: ../plugins/fn-financial/functions.c:3248
3752
#: ../plugins/fn-financial/functions.c:3288
3653
3754
"If @{no_switch} is FALSE, the calculation switches to straight-line "
3654
3755
"depreciation when depreciation is greater than the declining balance "
3658
#: ../plugins/fn-hebrew-date/functions.c:52
3759
#: ../plugins/fn-hebrew-date/functions.c:92
3659
3760
msgid "HDATE:Hebrew date"
3662
#: ../plugins/fn-hebrew-date/functions.c:85
3763
#: ../plugins/fn-hebrew-date/functions.c:93
3764
#: ../plugins/fn-hebrew-date/functions.c:162
3765
#: ../plugins/fn-hebrew-date/functions.c:235
3766
#: ../plugins/fn-hebrew-date/functions.c:262
3767
#: ../plugins/fn-hebrew-date/functions.c:289
3768
#: ../plugins/fn-hebrew-date/functions.c:316
3769
msgid "year:Gregorian year of date, defaults to the current year"
3772
#: ../plugins/fn-hebrew-date/functions.c:94
3773
#: ../plugins/fn-hebrew-date/functions.c:163
3774
#: ../plugins/fn-hebrew-date/functions.c:236
3775
#: ../plugins/fn-hebrew-date/functions.c:263
3776
#: ../plugins/fn-hebrew-date/functions.c:290
3777
#: ../plugins/fn-hebrew-date/functions.c:317
3778
msgid "month:Gregorian month of year, defaults to the current month"
3781
#: ../plugins/fn-hebrew-date/functions.c:95
3782
#: ../plugins/fn-hebrew-date/functions.c:164
3783
#: ../plugins/fn-hebrew-date/functions.c:237
3784
#: ../plugins/fn-hebrew-date/functions.c:264
3785
#: ../plugins/fn-hebrew-date/functions.c:291
3786
#: ../plugins/fn-hebrew-date/functions.c:318
3787
msgid "day:Gregorian day of month, defaults to the current day"
3790
#: ../plugins/fn-hebrew-date/functions.c:127
3791
msgid "DATE2HDATE:Hebrew date"
3794
#: ../plugins/fn-hebrew-date/functions.c:128
3795
#: ../plugins/fn-hebrew-date/functions.c:203
3796
#: ../plugins/fn-hebrew-date/functions.c:342
3797
msgid "date:Gregorian date, defaults to today"
3800
#: ../plugins/fn-hebrew-date/functions.c:161
3663
3801
msgid "HDATE_HEB:Hebrew date in Hebrew"
3666
#: ../plugins/fn-hebrew-date/functions.c:120
3804
#: ../plugins/fn-hebrew-date/functions.c:202
3805
msgid "DATE2HDATE_HEB:Hebrew date in Hebrew"
3808
#: ../plugins/fn-hebrew-date/functions.c:234
3667
3809
msgid "HDATE_MONTH:Hebrew month of Gregorian date"
3670
#: ../plugins/fn-hebrew-date/functions.c:121
3671
#: ../plugins/fn-hebrew-date/functions.c:148
3672
#: ../plugins/fn-hebrew-date/functions.c:175
3673
#: ../plugins/fn-hebrew-date/functions.c:202
3674
msgid "year:Gregorian year of date"
3677
#: ../plugins/fn-hebrew-date/functions.c:122
3678
#: ../plugins/fn-hebrew-date/functions.c:149
3679
#: ../plugins/fn-hebrew-date/functions.c:176
3680
#: ../plugins/fn-hebrew-date/functions.c:203
3681
msgid "month:Gregorian month of year"
3684
#: ../plugins/fn-hebrew-date/functions.c:123
3685
#: ../plugins/fn-hebrew-date/functions.c:150
3686
#: ../plugins/fn-hebrew-date/functions.c:177
3687
#: ../plugins/fn-hebrew-date/functions.c:204
3688
msgid "day:Gregorian day of month"
3691
#: ../plugins/fn-hebrew-date/functions.c:147
3812
#: ../plugins/fn-hebrew-date/functions.c:261
3692
3813
msgid "HDATE_DAY:Hebrew day of Gregorian date"
3695
#: ../plugins/fn-hebrew-date/functions.c:174
3816
#: ../plugins/fn-hebrew-date/functions.c:288
3696
3817
msgid "HDATE_YEAR:Hebrew year of Gregorian date"
3699
#: ../plugins/fn-hebrew-date/functions.c:201
3820
#: ../plugins/fn-hebrew-date/functions.c:315
3700
3821
msgid "HDATE_JULIAN:Julian day number for given Gregorian date"
3824
#: ../plugins/fn-hebrew-date/functions.c:341
3825
msgid "DATE2JULIAN:Julian day number for given Gregorian date"
3703
3828
#: ../plugins/fn-info/functions.c:68
3704
3829
msgid "CELL:information of @{type} about @{cell}"
4280
4405
"offset is returned."
4283
#: ../plugins/fn-lookup/functions.c:928 ../plugins/fn-lookup/functions.c:989
4408
#: ../plugins/fn-lookup/functions.c:929 ../plugins/fn-lookup/functions.c:990
4285
4410
"If @{approximate} is true, then the values must be sorted in order of "
4286
4411
"ascending value."
4289
#: ../plugins/fn-lookup/functions.c:930
4290
msgid "VLOOKUP returns #REF! if @{row} falls outside @{range}."
4414
#: ../plugins/fn-lookup/functions.c:931
4415
msgid "VLOOKUP returns #REF! if @{column} falls outside @{range}."
4293
#: ../plugins/fn-lookup/functions.c:974
4418
#: ../plugins/fn-lookup/functions.c:975
4294
4419
msgid "HLOOKUP:search the first row of @{range} for @{value}"
4297
#: ../plugins/fn-lookup/functions.c:977
4298
msgid "row:1-based column offset indicating the return values "
4301
#: ../plugins/fn-lookup/functions.c:982
4422
#: ../plugins/fn-lookup/functions.c:978
4423
msgid "row:1-based row offset indicating the return values "
4426
#: ../plugins/fn-lookup/functions.c:981
4428
"as_index:if true, the 0-based column offset is returned; defaults to FALSE"
4431
#: ../plugins/fn-lookup/functions.c:983
4303
4433
"HLOOKUP function finds the row in @{range} that has a first cell similar to @"
4304
"{value}. If @{approximate} is not true it finds the row with an exact "
4305
"equality. If @{approximate} is true, it finds the last row with first value "
4306
"less than or equal to @{value}. If @{as_index} is true the 0-based row "
4307
"offset is returned."
4434
"{value}. If @{approximate} is not true it finds the column with an exact "
4435
"equality. If @{approximate} is true, it finds the last column with first "
4436
"value less than or equal to @{value}. If @{as_index} is true the 0-based "
4437
"column offset is returned."
4310
#: ../plugins/fn-lookup/functions.c:991
4440
#: ../plugins/fn-lookup/functions.c:992
4311
4441
msgid "HLOOKUP returns #REF! if @{row} falls outside @{range}."
4314
#: ../plugins/fn-lookup/functions.c:1035
4444
#: ../plugins/fn-lookup/functions.c:1036
4316
4446
"LOOKUP:contents of @{vector2} at the corresponding location to @{value} in @"
4320
#: ../plugins/fn-lookup/functions.c:1037
4450
#: ../plugins/fn-lookup/functions.c:1038
4321
4451
msgid "value:value to look up"
4324
#: ../plugins/fn-lookup/functions.c:1038
4454
#: ../plugins/fn-lookup/functions.c:1039
4325
4455
msgid "vector1:range to search:"
4328
#: ../plugins/fn-lookup/functions.c:1039
4458
#: ../plugins/fn-lookup/functions.c:1040
4329
4459
msgid "vector2:range of return values"
4332
#: ../plugins/fn-lookup/functions.c:1040
4462
#: ../plugins/fn-lookup/functions.c:1041
4334
4464
"If @{vector1} has more rows than columns, LOOKUP searches the first row of @"
4335
4465
"{vector1}, otherwise the first column. If @{vector2} is omitted the return "
4336
4466
"value is taken from the last row or column of @{vector1}."
4339
#: ../plugins/fn-lookup/functions.c:1044
4469
#: ../plugins/fn-lookup/functions.c:1045
4341
4471
"If LOOKUP can't find @{value} it uses the largest value less than @{value}."
4344
#: ../plugins/fn-lookup/functions.c:1046
4474
#: ../plugins/fn-lookup/functions.c:1047
4345
4475
msgid "The data must be sorted."
4348
#: ../plugins/fn-lookup/functions.c:1047
4478
#: ../plugins/fn-lookup/functions.c:1048
4349
4479
msgid "If @{value} is smaller than the first value it returns #N/A."
4352
#: ../plugins/fn-lookup/functions.c:1048
4482
#: ../plugins/fn-lookup/functions.c:1049
4354
4484
"If the corresponding location does not exist in @{vector2}, it returns #N/A."
4357
#: ../plugins/fn-lookup/functions.c:1135
4487
#: ../plugins/fn-lookup/functions.c:1136
4358
4488
msgid "MATCH:the index of @{seek} in @{vector}"
4361
#: ../plugins/fn-lookup/functions.c:1136
4491
#: ../plugins/fn-lookup/functions.c:1137
4362
4492
msgid "seek:value to find"
4365
#: ../plugins/fn-lookup/functions.c:1137
4495
#: ../plugins/fn-lookup/functions.c:1138
4366
4496
msgid "vector:n by 1 or 1 by n range to be searched"
4369
#: ../plugins/fn-lookup/functions.c:1138
4499
#: ../plugins/fn-lookup/functions.c:1139
4371
4501
"type:+1 (the default) to find the largest value ≤ @{seek}, 0 to find the "
4372
4502
"first value = @{seek}, or-1 to find the smallest value ≥ @{seek}"
4375
#: ../plugins/fn-lookup/functions.c:1141
4505
#: ../plugins/fn-lookup/functions.c:1142
4376
4506
msgid "MATCH searches @{vector} for @{seek} and returns the 1-based index."
4379
#: ../plugins/fn-lookup/functions.c:1142
4509
#: ../plugins/fn-lookup/functions.c:1143
4381
4511
" For @{type} = -1 the data must be sorted in descending order; for @{type} = "
4382
4512
"+1 the data must be sorted in ascending order."
4385
#: ../plugins/fn-lookup/functions.c:1144
4515
#: ../plugins/fn-lookup/functions.c:1145
4386
4516
msgid "If @{seek} could not be found, #N/A is returned."
4389
#: ../plugins/fn-lookup/functions.c:1145
4519
#: ../plugins/fn-lookup/functions.c:1146
4390
4520
msgid "If @{vector} is neither n by 1 nor 1 by n, #N/A is returned."
4393
#: ../plugins/fn-lookup/functions.c:1196
4523
#: ../plugins/fn-lookup/functions.c:1197
4394
4524
msgid "INDIRECT:contents of the cell pointed to by the @{ref_text} string"
4397
#: ../plugins/fn-lookup/functions.c:1197
4401
4527
#: ../plugins/fn-lookup/functions.c:1198
4528
msgid "ref_text:textual reference"
4531
#: ../plugins/fn-lookup/functions.c:1199
4403
4533
"format:if true, @{ref_text} is given in A1-style, otherwise it is given in "
4404
4534
"R1C1 style; defaults to true"
4407
#: ../plugins/fn-lookup/functions.c:1200
4537
#: ../plugins/fn-lookup/functions.c:1201
4409
4539
"If @{ref_text} is not a valid reference in the style determined by @"
4410
4540
"{format}, INDIRECT returns #REF!"
4413
#: ../plugins/fn-lookup/functions.c:1234
4543
#: ../plugins/fn-lookup/functions.c:1235
4414
4544
msgid "INDEX:reference to a cell in the given @{array}"
4417
#: ../plugins/fn-lookup/functions.c:1235
4421
4547
#: ../plugins/fn-lookup/functions.c:1236
4548
msgid "array:cell or inline array"
4551
#: ../plugins/fn-lookup/functions.c:1237
4422
4552
msgid "row:desired row, defaults to 1"
4425
#: ../plugins/fn-lookup/functions.c:1237
4555
#: ../plugins/fn-lookup/functions.c:1238
4426
4556
msgid "col:desired column, defaults to 1"
4429
#: ../plugins/fn-lookup/functions.c:1238
4559
#: ../plugins/fn-lookup/functions.c:1239
4430
4560
msgid "area:from which area to select a cell, defaults to 1"
4433
#: ../plugins/fn-lookup/functions.c:1239
4563
#: ../plugins/fn-lookup/functions.c:1240
4435
4565
"INDEX gives a reference to a cell in the given @{array}. The cell is "
4436
4566
"selected by @{row} and @{col}, which count the rows and columns in the array."
4439
#: ../plugins/fn-lookup/functions.c:1244
4569
#: ../plugins/fn-lookup/functions.c:1245
4441
4571
"If the reference falls outside the range of @{array}, INDEX returns #REF!"
4444
#: ../plugins/fn-lookup/functions.c:1246
4574
#: ../plugins/fn-lookup/functions.c:1247
4446
4576
"Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, "
4447
4577
"21.3, 25.9, and 40.1. Then INDEX(A1:A5,4,1,1) equals 25.9"
4450
#: ../plugins/fn-lookup/functions.c:1335
4580
#: ../plugins/fn-lookup/functions.c:1336
4451
4581
msgid "COLUMN:vector of column numbers"
4454
#: ../plugins/fn-lookup/functions.c:1336 ../plugins/fn-lookup/functions.c:1488
4584
#: ../plugins/fn-lookup/functions.c:1337 ../plugins/fn-lookup/functions.c:1489
4455
4585
msgid "x:reference, defaults to the position of the current expression"
4458
#: ../plugins/fn-lookup/functions.c:1337
4588
#: ../plugins/fn-lookup/functions.c:1338
4460
4590
"COLUMN function returns a Nx1 array containing the sequence of integers from "
4461
"the first column to the last column of @{reference}."
4591
"the first column to the last column of @{x}."
4464
#: ../plugins/fn-lookup/functions.c:1340 ../plugins/fn-lookup/functions.c:1492
4594
#: ../plugins/fn-lookup/functions.c:1341 ../plugins/fn-lookup/functions.c:1493
4466
"If @{reference} is neither an array nor a reference nor a range, returns "
4596
"If @{x} is neither an array nor a reference nor a range, returns #VALUE!"
4470
#: ../plugins/fn-lookup/functions.c:1344
4599
#: ../plugins/fn-lookup/functions.c:1345
4471
4600
msgid "column() in G13 equals 7."
4474
#: ../plugins/fn-lookup/functions.c:1384
4603
#: ../plugins/fn-lookup/functions.c:1385
4475
4604
msgid "COLUMNNUMBER:column number for the given column called @{name}"
4478
#: ../plugins/fn-lookup/functions.c:1385
4607
#: ../plugins/fn-lookup/functions.c:1386
4479
4608
msgid "name:column name such as \"IV\""
4482
#: ../plugins/fn-lookup/functions.c:1386
4611
#: ../plugins/fn-lookup/functions.c:1387
4483
4612
msgid "If @{name} is invalid, COLUMNNUMBER returns #VALUE!"
4486
#: ../plugins/fn-lookup/functions.c:1411
4615
#: ../plugins/fn-lookup/functions.c:1412
4487
4616
msgid "COLUMNS:number of columns in @{reference}"
4490
#: ../plugins/fn-lookup/functions.c:1412
4619
#: ../plugins/fn-lookup/functions.c:1413
4491
4620
msgid "reference:array or area"
4494
#: ../plugins/fn-lookup/functions.c:1413
4623
#: ../plugins/fn-lookup/functions.c:1414
4496
4625
"If @{reference} is neither an array nor a reference nor a range, COLUMNS "
4497
4626
"returns #VALUE!"
4500
#: ../plugins/fn-lookup/functions.c:1429
4629
#: ../plugins/fn-lookup/functions.c:1430
4501
4630
msgid "OFFSET:an offset cell range"
4504
#: ../plugins/fn-lookup/functions.c:1430
4633
#: ../plugins/fn-lookup/functions.c:1431
4505
4634
msgid "range:reference or range"
4508
#: ../plugins/fn-lookup/functions.c:1431
4637
#: ../plugins/fn-lookup/functions.c:1432
4509
4638
msgid "row:number of rows to offset @{range}"
4512
#: ../plugins/fn-lookup/functions.c:1432
4641
#: ../plugins/fn-lookup/functions.c:1433
4513
4642
msgid "col:number of columns to offset @{range}"
4516
#: ../plugins/fn-lookup/functions.c:1433
4645
#: ../plugins/fn-lookup/functions.c:1434
4517
4646
msgid "height:height of the offset range, defaults to height of @{range}"
4520
#: ../plugins/fn-lookup/functions.c:1434
4649
#: ../plugins/fn-lookup/functions.c:1435
4521
4650
msgid "width:width of the offset range, defaults to width of @{range}"
4524
#: ../plugins/fn-lookup/functions.c:1435
4653
#: ../plugins/fn-lookup/functions.c:1436
4526
4655
"OFFSET returns the cell range starting at offset (@{row},@{col}) from @"
4527
4656
"{range} of height @{height} and width @{width}."
4530
#: ../plugins/fn-lookup/functions.c:1438
4659
#: ../plugins/fn-lookup/functions.c:1439
4531
4660
msgid "If @{range} is neither a reference nor a range, OFFSET returns #VALUE!"
4534
#: ../plugins/fn-lookup/functions.c:1487
4663
#: ../plugins/fn-lookup/functions.c:1488
4535
4664
msgid "ROW:vector of row numbers"
4538
#: ../plugins/fn-lookup/functions.c:1489
4667
#: ../plugins/fn-lookup/functions.c:1490
4540
4669
"ROW function returns a 1xN array containing the sequence of integers from "
4541
"the first row to the last row of @{reference}."
4670
"the first row to the last row of @{x}."
4544
#: ../plugins/fn-lookup/functions.c:1535
4673
#: ../plugins/fn-lookup/functions.c:1536
4545
4674
msgid "ROWS:number of rows in @{reference}"
4548
#: ../plugins/fn-lookup/functions.c:1536
4677
#: ../plugins/fn-lookup/functions.c:1537
4549
4678
msgid "reference:array, reference, or range"
4552
#: ../plugins/fn-lookup/functions.c:1537
4681
#: ../plugins/fn-lookup/functions.c:1538
4554
4683
"If @{reference} is neither an array nor a reference nor a range, ROWS "
4555
4684
"returns #VALUE!"
4558
#: ../plugins/fn-lookup/functions.c:1553
4687
#: ../plugins/fn-lookup/functions.c:1554
4559
4688
msgid "SHEETS:number of sheets in @{reference}"
4562
#: ../plugins/fn-lookup/functions.c:1554
4691
#: ../plugins/fn-lookup/functions.c:1555
4563
4692
msgid "reference:array, reference, or range, defaults to the maximum range"
4566
#: ../plugins/fn-lookup/functions.c:1555
4695
#: ../plugins/fn-lookup/functions.c:1556
4568
4697
"If @{reference} is neither an array nor a reference nor a range, SHEETS "
4569
4698
"returns #VALUE!"
4782
4930
#: ../plugins/fn-math/functions.c:411
4783
msgid "ATAN2:arc tangent of the ratio of @{b1} and @{b2}"
4786
#: ../plugins/fn-math/functions.c:412
4787
msgid "b1:angle in radians"
4931
msgid "ATAN2:the arc tangent of the ratio @{y}/@{x}"
4790
4934
#: ../plugins/fn-math/functions.c:413
4791
msgid "b2:angle in radians"
4935
msgid "x:x-coordinate"
4794
4938
#: ../plugins/fn-math/functions.c:414
4939
msgid "y:y-coordinate"
4942
#: ../plugins/fn-math/functions.c:415
4796
"ATAN2 calculates the arc tangent of the ratio @{b1}/@{b2} with the sign "
4797
"according to the quadrant containing (@{b1},@{b2})."
4800
#: ../plugins/fn-math/functions.c:437
4944
"ATAN2 calculates the direction from the origin to the point (@{x},@{y}) as "
4945
"an angle from the x-axis in radians."
4948
#: ../plugins/fn-math/functions.c:419
4949
msgid "The result will be between π and +π."
4952
#: ../plugins/fn-math/functions.c:421
4953
msgid "The order of the arguments may be unexpected."
4956
#: ../plugins/fn-math/functions.c:446
4801
4957
msgid "CEIL:smallest integer larger than or equal to @{x}"
4804
#: ../plugins/fn-math/functions.c:439
4960
#: ../plugins/fn-math/functions.c:448
4805
4961
msgid "CEIL(@{x}) is the smallest integer that is at least as large as @{x}."
4808
#: ../plugins/fn-math/functions.c:440
4964
#: ../plugins/fn-math/functions.c:449
4809
4965
msgid "This function is the OpenFormula function CEILING(@{x})."
4812
#: ../plugins/fn-math/functions.c:457
4968
#: ../plugins/fn-math/functions.c:466
4813
4969
msgid "COUNTIF:count of the cells meeting the given @{criteria}"
4816
#: ../plugins/fn-math/functions.c:458 ../plugins/fn-math/functions.c:531
4817
#: ../plugins/fn-math/functions.c:643
4972
#: ../plugins/fn-math/functions.c:467 ../plugins/fn-math/functions.c:540
4973
#: ../plugins/fn-math/functions.c:652
4818
4974
msgid "range:cell area"
4821
#: ../plugins/fn-math/functions.c:459
4822
msgid "criteria: condition for a cell to be counted"
4977
#: ../plugins/fn-math/functions.c:468
4978
msgid "criteria:condition for a cell to be counted"
4825
#: ../plugins/fn-math/functions.c:530
4981
#: ../plugins/fn-math/functions.c:539
4827
4983
"SUMIF:sum of the cells in @{actual_range} for which the corresponding cells "
4828
4984
"in the range meet the given @{criteria}"
4831
#: ../plugins/fn-math/functions.c:532
4832
msgid "criteria: condition for a cell to be summed"
4835
#: ../plugins/fn-math/functions.c:533 ../plugins/fn-math/functions.c:645
4836
msgid "actual_range: cell area, defaults to @{range}"
4839
#: ../plugins/fn-math/functions.c:642
4987
#: ../plugins/fn-math/functions.c:541
4988
msgid "criteria:condition for a cell to be summed"
4991
#: ../plugins/fn-math/functions.c:542 ../plugins/fn-math/functions.c:654
4992
msgid "actual_range:cell area, defaults to @{range}"
4995
#: ../plugins/fn-math/functions.c:651
4841
4997
"AVERAGEIF:average of the cells in @{actual range} for which the "
4842
4998
"corresponding cells in the range meet the given @{criteria}"
4845
#: ../plugins/fn-math/functions.c:644
4846
msgid "criteria: condition for a cell to be included"
5001
#: ../plugins/fn-math/functions.c:653
5002
msgid "criteria:condition for a cell to be included"
4849
#: ../plugins/fn-math/functions.c:708
5005
#: ../plugins/fn-math/functions.c:717
4851
5007
"CEILING:nearest multiple of @{significance} whose absolute value is at least "
4855
#: ../plugins/fn-math/functions.c:710 ../plugins/fn-math/functions.c:1064
5011
#: ../plugins/fn-math/functions.c:719 ../plugins/fn-math/functions.c:1072
4857
5013
"significance:base multiple (defaults to 1 for @{x} > 0 and -1 for @{x} <0)"
4860
#: ../plugins/fn-math/functions.c:711
5016
#: ../plugins/fn-math/functions.c:720
4862
5018
"CEILING(@{x},@{significance}) is the nearest multiple of @{significance} "
4863
5019
"whose absolute value is at least ABS(@{x})."
4866
#: ../plugins/fn-math/functions.c:712
5022
#: ../plugins/fn-math/functions.c:721
4868
5024
"If @{x} or @{significance} is non-numeric, CEILING returns a #VALUE! error."
4871
#: ../plugins/fn-math/functions.c:713
5027
#: ../plugins/fn-math/functions.c:722
4873
5029
"If @{x} and @{significance} have different signs, CEILING returns a #NUM! "
4877
#: ../plugins/fn-math/functions.c:715
5033
#: ../plugins/fn-math/functions.c:724
4879
5035
"CEILING(@{x}) is exported to ODF as CEILING(@{x},SIGN(@{x}),1). CEILING(@{x},"
4880
5036
"@{significance}) is the OpenFormula function CEILING(@{x},@{significance},1)."
4883
#: ../plugins/fn-math/functions.c:741
4884
msgid "COS:Cosine function"
4887
#: ../plugins/fn-math/functions.c:744
5039
#: ../plugins/fn-math/functions.c:750
5040
msgid "COS:the cosine of @{x}"
5043
#: ../plugins/fn-math/functions.c:751 ../plugins/fn-math/functions.c:825
5044
#: ../plugins/fn-math/functions.c:1342 ../plugins/fn-math/functions.c:1361
5045
#: ../plugins/fn-math/functions.c:1401 ../plugins/fn-math/functions.c:1574
5046
msgid "x:angle in radians"
5049
#: ../plugins/fn-math/functions.c:753
4888
5050
msgid "wolfram:Cosine.html"
4891
#: ../plugins/fn-math/functions.c:761
4892
msgid "COSH:Hyperbolic cosine function"
4895
#: ../plugins/fn-math/functions.c:779
4896
msgid "COT:cotangent of a value"
4899
#: ../plugins/fn-math/functions.c:783
5053
#: ../plugins/fn-math/functions.c:770
5054
msgid "COSH:the hyperbolic cosine of @{x}"
5057
#: ../plugins/fn-math/functions.c:788
5058
msgid "COT:the cotangent of @{x}"
5061
#: ../plugins/fn-math/functions.c:792
4900
5062
msgid "wolfram:Cotangent.html"
4903
#: ../plugins/fn-math/functions.c:797
4904
msgid "COTH:hyperbolic cotangent of a value"
5065
#: ../plugins/fn-math/functions.c:806
5066
msgid "COTH:the hyperbolic cotangent of @{x}"
4907
#: ../plugins/fn-math/functions.c:801
5069
#: ../plugins/fn-math/functions.c:810
4908
5070
msgid "wolfram:HyperbolicCotangent.html"
4911
#: ../plugins/fn-math/functions.c:802 ../plugins/fn-math/functions.c:1379
4912
#: ../plugins/fn-math/functions.c:1419
5073
#: ../plugins/fn-math/functions.c:811 ../plugins/fn-math/functions.c:1387
5074
#: ../plugins/fn-math/functions.c:1427
4913
5075
msgid "wiki:en:Hyperbolic_function"
4916
#: ../plugins/fn-math/functions.c:815
4917
msgid "DEGREES:Equivalent degrees to @{x} radians."
5078
#: ../plugins/fn-math/functions.c:824
5079
msgid "DEGREES:equivalent degrees to @{x} radians"
4920
#: ../plugins/fn-math/functions.c:833
5082
#: ../plugins/fn-math/functions.c:842
4921
5083
msgid "EXP:e raised to the power of @{x}"
4924
#: ../plugins/fn-math/functions.c:835
5086
#: ../plugins/fn-math/functions.c:844
4925
5087
msgid "e is the base of the natural logarithm."
4928
#: ../plugins/fn-math/functions.c:851
5090
#: ../plugins/fn-math/functions.c:860
4929
5091
msgid "EXPM1:EXP(@{x})-1"
4932
#: ../plugins/fn-math/functions.c:853
5094
#: ../plugins/fn-math/functions.c:862
4934
5096
"This function has a higher resulting precision than evaluating EXP(@{x})-1."
4937
#: ../plugins/fn-math/functions.c:868
5099
#: ../plugins/fn-math/functions.c:877
4938
5100
msgid "FACT:the factorial of @{x}, i.e. @{x}!"
4941
#: ../plugins/fn-math/functions.c:871
5103
#: ../plugins/fn-math/functions.c:880
4942
5104
msgid "The domain of this function has been extended using the GAMMA function."
4945
#: ../plugins/fn-math/functions.c:899
5107
#: ../plugins/fn-math/functions.c:908
4946
5108
msgid "GAMMA:the Gamma function"
4949
#: ../plugins/fn-math/functions.c:929
4950
msgid "GAMMALN:natural logarithm of the Gamma function."
5111
#: ../plugins/fn-math/functions.c:938
5112
msgid "GAMMALN:natural logarithm of the Gamma function"
4953
#: ../plugins/fn-math/functions.c:953
5115
#: ../plugins/fn-math/functions.c:962
4954
5116
msgid "BETA:Euler beta function"
4957
#: ../plugins/fn-math/functions.c:955 ../plugins/fn-math/functions.c:980
4958
#: ../plugins/fn-math/functions.c:1196
5119
#: ../plugins/fn-math/functions.c:964 ../plugins/fn-math/functions.c:988
5120
#: ../plugins/fn-math/functions.c:1204
4959
5121
msgid "y:number"
4962
#: ../plugins/fn-math/functions.c:956
5124
#: ../plugins/fn-math/functions.c:965
4964
5126
"BETA function returns the value of the Euler beta function extended to all "
4965
5127
"real numbers except 0 and negative integers."
4968
#: ../plugins/fn-math/functions.c:957
5130
#: ../plugins/fn-math/functions.c:966
4970
5132
"If @{x}, @{y}, or (@{x} + @{y}) are non-positive integers, BETA returns #NUM!"
4973
#: ../plugins/fn-math/functions.c:961 ../plugins/fn-math/functions.c:986
5135
#: ../plugins/fn-math/functions.c:970 ../plugins/fn-math/functions.c:994
4974
5136
msgid "wiki:en:Beta_function"
4977
#: ../plugins/fn-math/functions.c:978
5139
#: ../plugins/fn-math/functions.c:986
4979
"BETALN:Natural logarithm of the absolute value of the Euler beta function"
5141
"BETALN:natural logarithm of the absolute value of the Euler beta function"
4982
#: ../plugins/fn-math/functions.c:981
5144
#: ../plugins/fn-math/functions.c:989
4984
5146
"BETALN function returns the natural logarithm of the absolute value of the "
4985
5147
"Euler beta function extended to all real numbers except 0 and negative "
4989
#: ../plugins/fn-math/functions.c:982
5151
#: ../plugins/fn-math/functions.c:990
4991
5153
"If @{x}, @{y}, or (@{x} + @{y}) are non-positive integers, BETALN returns "
4995
#: ../plugins/fn-math/functions.c:1003
4996
msgid "COMBIN:Binomial coefficient"
5157
#: ../plugins/fn-math/functions.c:1011
5158
msgid "COMBIN:binomial coefficient"
4999
#: ../plugins/fn-math/functions.c:1004 ../plugins/fn-math/functions.c:1036
5000
#: ../plugins/fn-math/functions.c:2113
5161
#: ../plugins/fn-math/functions.c:1012 ../plugins/fn-math/functions.c:1044
5162
#: ../plugins/fn-math/functions.c:2121
5001
5163
msgid "n:non-negative integer"
5004
#: ../plugins/fn-math/functions.c:1005 ../plugins/fn-math/functions.c:1037
5166
#: ../plugins/fn-math/functions.c:1013 ../plugins/fn-math/functions.c:1045
5005
5167
msgid "k:non-negative integer"
5008
#: ../plugins/fn-math/functions.c:1006
5170
#: ../plugins/fn-math/functions.c:1014
5010
5172
"COMBIN returns the binomial coefficient \"@{n} choose @{k}\", the number of @"
5011
5173
"{k}-combinations of an @{n}-element set without repetition."
5014
#: ../plugins/fn-math/functions.c:1009
5176
#: ../plugins/fn-math/functions.c:1017
5015
5177
msgid "If @{n} is less than @{k} COMBIN returns #NUM!"
5018
#: ../plugins/fn-math/functions.c:1014
5180
#: ../plugins/fn-math/functions.c:1022
5019
5181
msgid "wiki:en:Binomial_coefficient"
5022
#: ../plugins/fn-math/functions.c:1034
5184
#: ../plugins/fn-math/functions.c:1042
5024
5186
"COMBINA:the number of @{k}-combinations of an @{n}-element set with "
5028
#: ../plugins/fn-math/functions.c:1042
5190
#: ../plugins/fn-math/functions.c:1050
5029
5191
msgid "wiki:en:Multiset"
5032
#: ../plugins/fn-math/functions.c:1062
5194
#: ../plugins/fn-math/functions.c:1070
5034
5196
"FLOOR:nearest multiple of @{significance} whose absolute value is at most ABS"
5038
#: ../plugins/fn-math/functions.c:1063
5042
#: ../plugins/fn-math/functions.c:1066
5200
#: ../plugins/fn-math/functions.c:1074
5044
5202
"FLOOR(@{x},@{significance}) is the nearest multiple of @{significance} whose "
5045
5203
"absolute value is at most ABS(@{x})"
5048
#: ../plugins/fn-math/functions.c:1068
5206
#: ../plugins/fn-math/functions.c:1076
5050
5208
"FLOOR(@{x}) is exported to ODF as FLOOR(@{x},SIGN(@{x}),1). FLOOR(@{x},@"
5051
5209
"{significance}) is the OpenFormula function FLOOR(@{x},@{significance},1)."
5054
#: ../plugins/fn-math/functions.c:1098
5055
msgid "INT: largest integer not larger than @{x}"
5058
#: ../plugins/fn-math/functions.c:1117
5059
msgid "LOG:Logarithm"
5062
#: ../plugins/fn-math/functions.c:1118 ../plugins/fn-math/functions.c:1148
5063
#: ../plugins/fn-math/functions.c:1171 ../plugins/fn-math/functions.c:1226
5064
#: ../plugins/fn-math/functions.c:1248
5212
#: ../plugins/fn-math/functions.c:1106
5213
msgid "INT:largest integer not larger than @{x}"
5216
#: ../plugins/fn-math/functions.c:1125
5217
msgid "LOG:logarithm of @{x} with base @{base}"
5220
#: ../plugins/fn-math/functions.c:1126 ../plugins/fn-math/functions.c:1156
5221
#: ../plugins/fn-math/functions.c:1179 ../plugins/fn-math/functions.c:1234
5222
#: ../plugins/fn-math/functions.c:1256
5065
5223
msgid "x:positive number"
5068
#: ../plugins/fn-math/functions.c:1119
5226
#: ../plugins/fn-math/functions.c:1127
5069
5227
msgid "base:base of the logarithm, defaults to 10"
5072
#: ../plugins/fn-math/functions.c:1120
5230
#: ../plugins/fn-math/functions.c:1128
5073
5231
msgid "@{base} must be positive and not equal to 1."
5076
#: ../plugins/fn-math/functions.c:1121
5234
#: ../plugins/fn-math/functions.c:1129
5077
5235
msgid "If @{x} ≤ 0, LOG returns #NUM! error."
5080
#: ../plugins/fn-math/functions.c:1147
5081
msgid "LN:the natural logarithm of @{x}."
5238
#: ../plugins/fn-math/functions.c:1155
5239
msgid "LN:the natural logarithm of @{x}"
5084
#: ../plugins/fn-math/functions.c:1149
5242
#: ../plugins/fn-math/functions.c:1157
5085
5243
msgid "If @{x} ≤ 0, LN returns #NUM! error."
5088
#: ../plugins/fn-math/functions.c:1170
5246
#: ../plugins/fn-math/functions.c:1178
5089
5247
msgid "LN1P:LN(1+@{x})"
5092
#: ../plugins/fn-math/functions.c:1172
5250
#: ../plugins/fn-math/functions.c:1180
5094
5252
"LN1P calculates LN(1+@{x}) but yielding a higher precision than evaluating LN"
5098
#: ../plugins/fn-math/functions.c:1173
5256
#: ../plugins/fn-math/functions.c:1181
5099
5257
msgid "If @{x} ≤ -1, LN returns #NUM! error."
5102
#: ../plugins/fn-math/functions.c:1194
5103
msgid "POWER:the value of @{x} raised to the power @{y}."
5260
#: ../plugins/fn-math/functions.c:1202
5261
msgid "POWER:the value of @{x} raised to the power @{y}"
5106
#: ../plugins/fn-math/functions.c:1197
5264
#: ../plugins/fn-math/functions.c:1205
5107
5265
msgid "If both @{x} and @{y} equal 0, POWER returns #NUM!"
5110
#: ../plugins/fn-math/functions.c:1198
5268
#: ../plugins/fn-math/functions.c:1206
5111
5269
msgid "If @{x} = 0 and @{y} < 0, POWER returns #DIV/0!"
5114
#: ../plugins/fn-math/functions.c:1199
5272
#: ../plugins/fn-math/functions.c:1207
5115
5273
msgid "If @{x} < 0 and @{y} is not an integer, POWER returns #NUM!"
5118
#: ../plugins/fn-math/functions.c:1225
5119
msgid "LOG2:the base-2 logarithm of @{x}."
5276
#: ../plugins/fn-math/functions.c:1233
5277
msgid "LOG2:the base-2 logarithm of @{x}"
5122
#: ../plugins/fn-math/functions.c:1227
5280
#: ../plugins/fn-math/functions.c:1235
5123
5281
msgid "If @{x} ≤ 0, LOG2 returns #NUM!"
5126
#: ../plugins/fn-math/functions.c:1247
5127
msgid "LOG10:the base-10 logarithm of @{x}."
5284
#: ../plugins/fn-math/functions.c:1255
5285
msgid "LOG10:the base-10 logarithm of @{x}"
5130
#: ../plugins/fn-math/functions.c:1249
5288
#: ../plugins/fn-math/functions.c:1257
5131
5289
msgid "If @{x} ≤ 0, LOG10 returns #NUM!"
5134
#: ../plugins/fn-math/functions.c:1269
5135
msgid "MOD: the remainder of @{x} under division by @{n}"
5292
#: ../plugins/fn-math/functions.c:1277
5293
msgid "MOD:the remainder of @{x} under division by @{n}"
5138
#: ../plugins/fn-math/functions.c:1272
5296
#: ../plugins/fn-math/functions.c:1280
5139
5297
msgid "MOD function returns the remainder when @{x} is divided by @{n}."
5142
#: ../plugins/fn-math/functions.c:1273
5300
#: ../plugins/fn-math/functions.c:1281
5143
5301
msgid "If @{n} is 0, MOD returns #DIV/0!"
5146
#: ../plugins/fn-math/functions.c:1315
5147
msgid "RADIANS:the number of radians equivalent to @{x} degrees."
5304
#: ../plugins/fn-math/functions.c:1323
5305
msgid "RADIANS:the number of radians equivalent to @{x} degrees"
5150
#: ../plugins/fn-math/functions.c:1316
5308
#: ../plugins/fn-math/functions.c:1324
5151
5309
msgid "x:angle in degrees"
5154
#: ../plugins/fn-math/functions.c:1333
5155
msgid "SIN:Sine function"
5312
#: ../plugins/fn-math/functions.c:1341
5313
msgid "SIN:the sine of @{x}"
5158
#: ../plugins/fn-math/functions.c:1338
5316
#: ../plugins/fn-math/functions.c:1346
5159
5317
msgid "wolfram:Sine.html"
5162
#: ../plugins/fn-math/functions.c:1352
5163
msgid "CSC:Cosecant"
5320
#: ../plugins/fn-math/functions.c:1360
5321
msgid "CSC:the cosecant of @{x}"
5166
#: ../plugins/fn-math/functions.c:1354 ../plugins/fn-math/functions.c:1374
5167
#: ../plugins/fn-math/functions.c:1394 ../plugins/fn-math/functions.c:1414
5324
#: ../plugins/fn-math/functions.c:1362 ../plugins/fn-math/functions.c:1382
5325
#: ../plugins/fn-math/functions.c:1402 ../plugins/fn-math/functions.c:1422
5168
5326
msgid "This function is not Excel compatible."
5171
#: ../plugins/fn-math/functions.c:1358
5329
#: ../plugins/fn-math/functions.c:1366
5172
5330
msgid "wolfram:Cosecant.html"
5175
#: ../plugins/fn-math/functions.c:1372
5176
msgid "CSCH:Hyperbolic cosecant"
5333
#: ../plugins/fn-math/functions.c:1380
5334
msgid "CSCH:the hyperbolic cosecant of @{x}"
5179
#: ../plugins/fn-math/functions.c:1378
5337
#: ../plugins/fn-math/functions.c:1386
5180
5338
msgid "wolfram:HyperbolicCosecant.html"
5183
#: ../plugins/fn-math/functions.c:1392
5341
#: ../plugins/fn-math/functions.c:1400
5184
5342
msgid "SEC:Secant"
5187
#: ../plugins/fn-math/functions.c:1395
5345
#: ../plugins/fn-math/functions.c:1403
5188
5346
msgid "SEC(@{x}) is exported to OpenFormula as 1/COS(@{x})."
5191
#: ../plugins/fn-math/functions.c:1398
5349
#: ../plugins/fn-math/functions.c:1406
5192
5350
msgid "wolfram:Secant.html"
5195
#: ../plugins/fn-math/functions.c:1412
5196
msgid "SECH:Hyperbolic secant"
5353
#: ../plugins/fn-math/functions.c:1420
5354
msgid "SECH:the hyperbolic secant of @{x}"
5199
#: ../plugins/fn-math/functions.c:1415
5357
#: ../plugins/fn-math/functions.c:1423
5200
5358
msgid "SECH(@{x}) is exported to OpenFormula as 1/COSH(@{x})."
5203
#: ../plugins/fn-math/functions.c:1418
5361
#: ../plugins/fn-math/functions.c:1426
5204
5362
msgid "wolfram:HyperbolicSecant.html"
5207
#: ../plugins/fn-math/functions.c:1430
5365
#: ../plugins/fn-math/functions.c:1438
5208
5366
msgid "SINH:the hyperbolic sine of @{x}"
5211
#: ../plugins/fn-math/functions.c:1448
5369
#: ../plugins/fn-math/functions.c:1456
5212
5370
msgid "SQRT:square root of @{x}"
5215
#: ../plugins/fn-math/functions.c:1449 ../plugins/fn-math/functions.c:1855
5373
#: ../plugins/fn-math/functions.c:1457 ../plugins/fn-math/functions.c:1863
5216
5374
msgid "x:non-negative number"
5219
#: ../plugins/fn-math/functions.c:1451
5377
#: ../plugins/fn-math/functions.c:1459
5220
5378
msgid "If @{x} is negative, SQRT returns #NUM!"
5223
#: ../plugins/fn-math/functions.c:1470
5381
#: ../plugins/fn-math/functions.c:1478
5224
5382
msgid "SUMA:sum of all values and cells referenced"
5227
#: ../plugins/fn-math/functions.c:1471 ../plugins/fn-math/functions.c:1495
5385
#: ../plugins/fn-math/functions.c:1479 ../plugins/fn-math/functions.c:1503
5228
5386
msgid "area0:first cell area"
5231
#: ../plugins/fn-math/functions.c:1472 ../plugins/fn-math/functions.c:1496
5389
#: ../plugins/fn-math/functions.c:1480 ../plugins/fn-math/functions.c:1504
5232
5390
msgid "area1:second cell area"
5235
#: ../plugins/fn-math/functions.c:1494
5236
msgid "SUMSQ:sum of th squares of all values and cells referenced"
5393
#: ../plugins/fn-math/functions.c:1502
5394
msgid "SUMSQ:sum of the squares of all values and cells referenced"
5239
#: ../plugins/fn-math/functions.c:1517
5397
#: ../plugins/fn-math/functions.c:1525
5241
"MULTINOMIAL:Multinomial coefficient (@{x1}+⋯+@{xn}) choose (@{x1},...,@{xn})"
5399
"MULTINOMIAL:multinomial coefficient (@{x1}+⋯+@{xn}) choose (@{x1},…,@{xn})"
5244
#: ../plugins/fn-math/functions.c:1518
5402
#: ../plugins/fn-math/functions.c:1526
5245
5403
msgid "x1:first number"
5248
#: ../plugins/fn-math/functions.c:1519
5406
#: ../plugins/fn-math/functions.c:1527
5249
5407
msgid "x2:second number"
5252
#: ../plugins/fn-math/functions.c:1520
5410
#: ../plugins/fn-math/functions.c:1528
5253
5411
msgid "xn:nth number"
5256
#: ../plugins/fn-math/functions.c:1524
5414
#: ../plugins/fn-math/functions.c:1532
5257
5415
msgid "wiki:en:Multinomial_theorem"
5260
#: ../plugins/fn-math/functions.c:1542
5418
#: ../plugins/fn-math/functions.c:1550
5261
5419
msgid "G_PRODUCT:product of all the values and cells referenced"
5264
#: ../plugins/fn-math/functions.c:1543
5422
#: ../plugins/fn-math/functions.c:1551
5265
5423
msgid "x1:number"
5268
#: ../plugins/fn-math/functions.c:1544
5426
#: ../plugins/fn-math/functions.c:1552
5269
5427
msgid "x2:number"
5272
#: ../plugins/fn-math/functions.c:1545
5430
#: ../plugins/fn-math/functions.c:1553
5273
5431
msgid "Empty cells are ignored and the empty product is 1."
5276
#: ../plugins/fn-math/functions.c:1565
5280
#: ../plugins/fn-math/functions.c:1582
5281
msgid "TANH:hyperbolic tangent"
5284
#: ../plugins/fn-math/functions.c:1599
5434
#: ../plugins/fn-math/functions.c:1573
5435
msgid "TAN:the tangent of @{x}"
5438
#: ../plugins/fn-math/functions.c:1590
5439
msgid "TANH:the hyperbolic tangent of @{x}"
5442
#: ../plugins/fn-math/functions.c:1607
5285
5443
msgid "PI:the constant π"
5288
#: ../plugins/fn-math/functions.c:1600
5446
#: ../plugins/fn-math/functions.c:1608
5290
5448
"This function is Excel compatible, but it returns π with a better precision."
5293
#: ../plugins/fn-math/functions.c:1615
5451
#: ../plugins/fn-math/functions.c:1623
5294
5452
msgid "TRUNC:@{x} truncated to @{d} digits"
5297
#: ../plugins/fn-math/functions.c:1617
5298
msgid "x:non-negative integer, defaults to 0"
5455
#: ../plugins/fn-math/functions.c:1625
5456
msgid "d:non-negative integer, defaults to 0"
5301
#: ../plugins/fn-math/functions.c:1618
5459
#: ../plugins/fn-math/functions.c:1626
5303
5461
"If @{d} is omitted or negative then it defaults to zero. If it is not an "
5304
5462
"integer then it is truncated to an integer."
5307
#: ../plugins/fn-math/functions.c:1652
5308
msgid "EVEN: @{x} rounded away from 0 to the next even integer"
5311
#: ../plugins/fn-math/functions.c:1687
5312
msgid "ODD: @{x} rounded away from 0 to the next odd integer"
5315
#: ../plugins/fn-math/functions.c:1722
5465
#: ../plugins/fn-math/functions.c:1660
5466
msgid "EVEN:@{x} rounded away from 0 to the next even integer"
5469
#: ../plugins/fn-math/functions.c:1695
5470
msgid "ODD:@{x} rounded away from 0 to the next odd integer"
5473
#: ../plugins/fn-math/functions.c:1730
5316
5474
msgid "FACTDOUBLE:double factorial"
5319
#: ../plugins/fn-math/functions.c:1723
5477
#: ../plugins/fn-math/functions.c:1731
5320
5478
msgid "x:non-negative integer"
5323
#: ../plugins/fn-math/functions.c:1724
5481
#: ../plugins/fn-math/functions.c:1732
5324
5482
msgid "FACTDOUBLE function returns the double factorial @{x}!!"
5327
#: ../plugins/fn-math/functions.c:1725
5485
#: ../plugins/fn-math/functions.c:1733
5329
5487
"If @{x} is not an integer, it is truncated. If @{x} is negative, FACTDOUBLE "
5330
5488
"returns #NUM!"
5333
#: ../plugins/fn-math/functions.c:1759
5491
#: ../plugins/fn-math/functions.c:1767
5334
5492
msgid "FIB:Fibonacci numbers"
5337
#: ../plugins/fn-math/functions.c:1760 ../plugins/fn-numtheory/numtheory.c:219
5495
#: ../plugins/fn-math/functions.c:1768 ../plugins/fn-numtheory/numtheory.c:219
5338
5496
#: ../plugins/fn-numtheory/numtheory.c:253
5339
5497
#: ../plugins/fn-numtheory/numtheory.c:294
5340
5498
#: ../plugins/fn-numtheory/numtheory.c:326
6549
6707
"distribution."
6552
#: ../plugins/fn-random/functions.c:46
6553
msgid "RAND:a random number between zero and one."
6710
#: ../plugins/fn-random/functions.c:47
6711
msgid "RAND:a random number between zero and one"
6556
#: ../plugins/fn-random/functions.c:63
6714
#: ../plugins/fn-random/functions.c:64
6558
6716
"RANDUNIFORM:random variate from the uniform distribution from @{a} to @{b}"
6561
#: ../plugins/fn-random/functions.c:64
6719
#: ../plugins/fn-random/functions.c:65
6562
6720
msgid "a:lower limit of the uniform distribution"
6565
#: ../plugins/fn-random/functions.c:65
6723
#: ../plugins/fn-random/functions.c:66
6566
6724
msgid "b:upper limit of the uniform distribution"
6569
#: ../plugins/fn-random/functions.c:66
6727
#: ../plugins/fn-random/functions.c:67
6570
6728
msgid "If @{a} > @{b} RANDUNIFORM returns #NUM!"
6573
#: ../plugins/fn-random/functions.c:88
6731
#: ../plugins/fn-random/functions.c:89
6574
6732
msgid "RANDDISCRETE:random variate from a finite discrete distribution"
6577
#: ../plugins/fn-random/functions.c:89
6735
#: ../plugins/fn-random/functions.c:90
6578
6736
msgid "val_range:possible values of the random variable"
6581
#: ../plugins/fn-random/functions.c:90
6739
#: ../plugins/fn-random/functions.c:91
6583
6741
"prob_range:probabilities of the corresponding values in @{val_range}, "
6584
6742
"defaults to equal probabilities"
6587
#: ../plugins/fn-random/functions.c:92
6745
#: ../plugins/fn-random/functions.c:93
6589
6747
"RANDDISCRETE returns one of the values in the @{val_range}. The "
6590
6748
"probabilities for each value are given in the @{prob_range}."
6593
#: ../plugins/fn-random/functions.c:94
6751
#: ../plugins/fn-random/functions.c:95
6595
6753
"If the sum of all values in @{prob_range} is not one, RANDDISCRETE returns "
6599
#: ../plugins/fn-random/functions.c:95
6757
#: ../plugins/fn-random/functions.c:96
6601
6759
"If @{val_range} and @{prob_range} are not the same size, RANDDISCRETE "
6602
6760
"returns #NUM!"
6605
#: ../plugins/fn-random/functions.c:96
6763
#: ../plugins/fn-random/functions.c:97
6607
6765
"If @{val_range} or @{prob_range} is not a range, RANDDISCRETE returns #VALUE!"
6610
#: ../plugins/fn-random/functions.c:174
6768
#: ../plugins/fn-random/functions.c:175
6611
6769
msgid "RANDEXP:random variate from an exponential distribution"
6614
#: ../plugins/fn-random/functions.c:175
6772
#: ../plugins/fn-random/functions.c:176
6615
6773
msgid "b:parameter of the exponential distribution"
6618
#: ../plugins/fn-random/functions.c:193
6776
#: ../plugins/fn-random/functions.c:194
6619
6777
msgid "RANDPOISSON:random variate from a Poisson distribution"
6622
#: ../plugins/fn-random/functions.c:194
6780
#: ../plugins/fn-random/functions.c:195
6623
6781
msgid "λ:parameter of the Poisson distribution"
6626
#: ../plugins/fn-random/functions.c:195
6784
#: ../plugins/fn-random/functions.c:196
6627
6785
msgid "If @{λ} < 0 RANDPOISSON returns #NUM!"
6630
#: ../plugins/fn-random/functions.c:217
6788
#: ../plugins/fn-random/functions.c:218
6631
6789
msgid "RANDBINOM:random variate from a binomial distribution"
6634
#: ../plugins/fn-random/functions.c:218 ../plugins/fn-random/functions.c:275
6635
#: ../plugins/fn-random/functions.c:581
6792
#: ../plugins/fn-random/functions.c:219 ../plugins/fn-random/functions.c:276
6793
#: ../plugins/fn-random/functions.c:582
6636
6794
msgid "p:probability of success in a single trial"
6639
#: ../plugins/fn-random/functions.c:219
6797
#: ../plugins/fn-random/functions.c:220
6640
6798
msgid "n:number of trials"
6643
#: ../plugins/fn-random/functions.c:220
6801
#: ../plugins/fn-random/functions.c:221
6644
6802
msgid "If @{p} < 0 or @{p} > 1 RANDBINOM returns #NUM!"
6647
#: ../plugins/fn-random/functions.c:221
6805
#: ../plugins/fn-random/functions.c:222
6648
6806
msgid "If @{n} < 0 RANDBINOM returns #NUM!"
6651
#: ../plugins/fn-random/functions.c:243
6809
#: ../plugins/fn-random/functions.c:244
6653
6811
"RANDBETWEEN:a random integer number between and including @{bottom} and @"
6657
#: ../plugins/fn-random/functions.c:245
6815
#: ../plugins/fn-random/functions.c:246
6658
6816
msgid "bottom:lower limit"
6661
#: ../plugins/fn-random/functions.c:246
6819
#: ../plugins/fn-random/functions.c:247
6662
6820
msgid "top:upper limit"
6665
#: ../plugins/fn-random/functions.c:247
6823
#: ../plugins/fn-random/functions.c:248
6666
6824
msgid "If @{bottom} > @{top}, RANDBETWEEN returns #NUM!"
6669
#: ../plugins/fn-random/functions.c:274
6827
#: ../plugins/fn-random/functions.c:275
6670
6828
msgid "RANDNEGBINOM:random variate from a negative binomial distribution"
6673
#: ../plugins/fn-random/functions.c:276
6831
#: ../plugins/fn-random/functions.c:277
6674
6832
msgid "n:number of failures"
6677
#: ../plugins/fn-random/functions.c:277
6835
#: ../plugins/fn-random/functions.c:278
6678
6836
msgid "If @{p} < 0 or @{p} > 1 RANDNEGBINOM returns #NUM!"
6681
#: ../plugins/fn-random/functions.c:278
6839
#: ../plugins/fn-random/functions.c:279
6682
6840
msgid "If @{n} < 1 RANDNEGBINOM returns #NUM!"
6685
#: ../plugins/fn-random/functions.c:299
6843
#: ../plugins/fn-random/functions.c:300
6686
6844
msgid "RANDBERNOULLI:random variate from a Bernoulli distribution"
6689
#: ../plugins/fn-random/functions.c:300 ../plugins/fn-stat/functions.c:878
6847
#: ../plugins/fn-random/functions.c:301 ../plugins/fn-stat/functions.c:877
6690
6848
msgid "p:probability of success"
6693
#: ../plugins/fn-random/functions.c:301
6851
#: ../plugins/fn-random/functions.c:302
6694
6852
msgid "If @{p} < 0 or @{p} > 1 RANDBERNOULLI returns #NUM!"
6697
#: ../plugins/fn-random/functions.c:323
6855
#: ../plugins/fn-random/functions.c:324
6698
6856
msgid "RANDNORM:random variate from a normal distribution"
6701
#: ../plugins/fn-random/functions.c:324
6859
#: ../plugins/fn-random/functions.c:325
6702
6860
msgid "μ:mean of the distribution"
6705
#: ../plugins/fn-random/functions.c:325 ../plugins/fn-random/functions.c:373
6863
#: ../plugins/fn-random/functions.c:326 ../plugins/fn-random/functions.c:374
6706
6864
msgid "σ:standard deviation of the distribution"
6709
#: ../plugins/fn-random/functions.c:326
6867
#: ../plugins/fn-random/functions.c:327
6710
6868
msgid "If @{σ} < 0, RANDNORM returns #NUM!"
6713
#: ../plugins/fn-random/functions.c:348
6871
#: ../plugins/fn-random/functions.c:349
6714
6872
msgid "RANDCAUCHY:random variate from a Cauchy or Lorentz distribution"
6717
#: ../plugins/fn-random/functions.c:349
6875
#: ../plugins/fn-random/functions.c:350
6718
6876
msgid "a:scale parameter of the distribution"
6721
#: ../plugins/fn-random/functions.c:350
6879
#: ../plugins/fn-random/functions.c:351
6722
6880
msgid "If @{a} < 0 RANDCAUCHY returns #NUM!"
6725
#: ../plugins/fn-random/functions.c:371
6883
#: ../plugins/fn-random/functions.c:372
6726
6884
msgid "RANDLOGNORM:random variate from a lognormal distribution"
6729
#: ../plugins/fn-random/functions.c:372
6887
#: ../plugins/fn-random/functions.c:373
6730
6888
msgid "ζ:parameter of the lognormal distribution"
6733
#: ../plugins/fn-random/functions.c:374
6891
#: ../plugins/fn-random/functions.c:375
6734
6892
msgid "If @{σ} < 0, RANDLOGNORM returns #NUM!"
6737
#: ../plugins/fn-random/functions.c:393
6895
#: ../plugins/fn-random/functions.c:394
6738
6896
msgid "RANDWEIBULL:random variate from a Weibull distribution"
6741
#: ../plugins/fn-random/functions.c:394
6899
#: ../plugins/fn-random/functions.c:395
6742
6900
msgid "a:parameter of the Weibull distribution"
6745
#: ../plugins/fn-random/functions.c:395
6903
#: ../plugins/fn-random/functions.c:396
6746
6904
msgid "b:parameter of the Weibull distribution"
6749
#: ../plugins/fn-random/functions.c:414
6907
#: ../plugins/fn-random/functions.c:415
6750
6908
msgid "RANDLAPLACE:random variate from a Laplace distribution"
6753
#: ../plugins/fn-random/functions.c:415
6911
#: ../plugins/fn-random/functions.c:416
6754
6912
msgid "a:parameter of the Laplace distribution"
6757
#: ../plugins/fn-random/functions.c:433
6915
#: ../plugins/fn-random/functions.c:434
6758
6916
msgid "RANDRAYLEIGH:random variate from a Rayleigh distribution"
6761
#: ../plugins/fn-random/functions.c:434 ../plugins/fn-random/functions.c:454
6919
#: ../plugins/fn-random/functions.c:435 ../plugins/fn-random/functions.c:455
6762
6920
msgid "σ:scale parameter of the Rayleigh distribution"
6765
#: ../plugins/fn-random/functions.c:452
6923
#: ../plugins/fn-random/functions.c:453
6767
6925
"RANDRAYLEIGHTAIL:random variate from the tail of a Rayleigh distribution"
6770
#: ../plugins/fn-random/functions.c:453 ../plugins/fn-random/functions.c:792
6928
#: ../plugins/fn-random/functions.c:454 ../plugins/fn-random/functions.c:793
6771
6929
msgid "a:lower limit of the tail"
6774
#: ../plugins/fn-random/functions.c:473
6932
#: ../plugins/fn-random/functions.c:474
6775
6933
msgid "RANDGAMMA:random variate from a Gamma distribution"
6778
#: ../plugins/fn-random/functions.c:474
6936
#: ../plugins/fn-random/functions.c:475
6779
6937
msgid "a:parameter of the Gamma distribution"
6782
#: ../plugins/fn-random/functions.c:475
6940
#: ../plugins/fn-random/functions.c:476
6783
6941
msgid "b:parameter of the Gamma distribution"
6786
#: ../plugins/fn-random/functions.c:476
6944
#: ../plugins/fn-random/functions.c:477
6787
6945
msgid "If @{a} ≤ 0, RANDGAMMA returns #NUM!"
6790
#: ../plugins/fn-random/functions.c:498
6948
#: ../plugins/fn-random/functions.c:499
6791
6949
msgid "RANDPARETO:random variate from a Pareto distribution"
6794
#: ../plugins/fn-random/functions.c:499
6952
#: ../plugins/fn-random/functions.c:500
6795
6953
msgid "a:parameter of the Pareto distribution"
6798
#: ../plugins/fn-random/functions.c:500
6956
#: ../plugins/fn-random/functions.c:501
6799
6957
msgid "b:parameter of the Pareto distribution"
6802
#: ../plugins/fn-random/functions.c:519
6960
#: ../plugins/fn-random/functions.c:520
6803
6961
msgid "RANDFDIST:random variate from an F distribution"
6806
#: ../plugins/fn-random/functions.c:520
6964
#: ../plugins/fn-random/functions.c:521
6807
6965
msgid "df1:numerator degrees of freedom"
6810
#: ../plugins/fn-random/functions.c:521
6968
#: ../plugins/fn-random/functions.c:522
6811
6969
msgid "df2:denominator degrees of freedom"
6814
#: ../plugins/fn-random/functions.c:540
6972
#: ../plugins/fn-random/functions.c:541
6815
6973
msgid "RANDBETA:random variate from a Beta distribution"
6818
#: ../plugins/fn-random/functions.c:541
6976
#: ../plugins/fn-random/functions.c:542
6819
6977
msgid "a:parameter of the Beta distribution"
6822
#: ../plugins/fn-random/functions.c:542
6980
#: ../plugins/fn-random/functions.c:543
6823
6981
msgid "b:parameter of the Beta distribution"
6826
#: ../plugins/fn-random/functions.c:561
6984
#: ../plugins/fn-random/functions.c:562
6827
6985
msgid "RANDLOGISTIC:random variate from a logistic distribution"
6830
#: ../plugins/fn-random/functions.c:562
6988
#: ../plugins/fn-random/functions.c:563
6831
6989
msgid "a:parameter of the logistic distribution"
6834
#: ../plugins/fn-random/functions.c:580
6992
#: ../plugins/fn-random/functions.c:581
6835
6993
msgid "RANDGEOM:random variate from a geometric distribution"
6838
#: ../plugins/fn-random/functions.c:582
6996
#: ../plugins/fn-random/functions.c:583
6839
6997
msgid "If @{p} < 0 or @{p} > 1 RANDGEOM returns #NUM!"
6842
#: ../plugins/fn-random/functions.c:603
7000
#: ../plugins/fn-random/functions.c:604
6843
7001
msgid "RANDHYPERG:random variate from a hypergeometric distribution"
6846
#: ../plugins/fn-random/functions.c:604
7004
#: ../plugins/fn-random/functions.c:605
6847
7005
msgid "n1:number of objects of type 1"
6850
#: ../plugins/fn-random/functions.c:605
7008
#: ../plugins/fn-random/functions.c:606
6851
7009
msgid "n2:number of objects of type 2"
6854
#: ../plugins/fn-random/functions.c:606
7012
#: ../plugins/fn-random/functions.c:607
6855
7013
msgid "t:total number of objects selected"
6858
#: ../plugins/fn-random/functions.c:628
7016
#: ../plugins/fn-random/functions.c:629
6859
7017
msgid "RANDLOG:random variate from a logarithmic distribution"
6862
#: ../plugins/fn-random/functions.c:630
7020
#: ../plugins/fn-random/functions.c:631
6863
7021
msgid "If @{p} < 0 or @{p} > 1 RANDLOG returns #NUM!"
6866
#: ../plugins/fn-random/functions.c:651
7024
#: ../plugins/fn-random/functions.c:652
6867
7025
msgid "RANDCHISQ:random variate from a Chi-square distribution"
6870
#: ../plugins/fn-random/functions.c:652 ../plugins/fn-random/functions.c:671
6871
#: ../plugins/fn-random/functions.c:922
7028
#: ../plugins/fn-random/functions.c:653 ../plugins/fn-random/functions.c:672
7029
#: ../plugins/fn-random/functions.c:923
6872
7030
msgid "df:degrees of freedom"
6875
#: ../plugins/fn-random/functions.c:670
7033
#: ../plugins/fn-random/functions.c:671
6876
7034
msgid "RANDTDIST:random variate from a Student t distribution"
6879
#: ../plugins/fn-random/functions.c:689
7037
#: ../plugins/fn-random/functions.c:690
6880
7038
msgid "RANDGUMBEL:random variate from a Gumbel distribution"
6883
#: ../plugins/fn-random/functions.c:690
7041
#: ../plugins/fn-random/functions.c:691
6884
7042
msgid "a:parameter of the Gumbel distribution"
6887
#: ../plugins/fn-random/functions.c:691
7045
#: ../plugins/fn-random/functions.c:692
6888
7046
msgid "b:parameter of the Gumbel distribution"
6891
#: ../plugins/fn-random/functions.c:692
7049
#: ../plugins/fn-random/functions.c:693
6892
7050
msgid "type:type of the Gumbel distribution, defaults to 1"
6895
#: ../plugins/fn-random/functions.c:693
7053
#: ../plugins/fn-random/functions.c:694
6896
7054
msgid "If @{type} is neither 1 nor 2, RANDGUMBEL returns #NUM!"
6899
#: ../plugins/fn-random/functions.c:718
7057
#: ../plugins/fn-random/functions.c:719
6900
7058
msgid "RANDLEVY:random variate from a Lévy distribution"
6903
#: ../plugins/fn-random/functions.c:719
7061
#: ../plugins/fn-random/functions.c:720
6904
7062
msgid "c:parameter of the Lévy distribution"
6907
#: ../plugins/fn-random/functions.c:720
7065
#: ../plugins/fn-random/functions.c:721
6908
7066
msgid "α:parameter of the Lévy distribution"
6911
#: ../plugins/fn-random/functions.c:721
7069
#: ../plugins/fn-random/functions.c:722
6912
7070
msgid "β:parameter of the Lévy distribution, defaults to 0"
6915
#: ../plugins/fn-random/functions.c:722
7073
#: ../plugins/fn-random/functions.c:723
6917
7075
"For @{α} = 1, @{β}=0, the Lévy distribution reduces to the Cauchy (or "
6918
7076
"Lorentzian) distribution."
6921
#: ../plugins/fn-random/functions.c:724
7079
#: ../plugins/fn-random/functions.c:725
6923
7081
"For @{α} = 2, @{β}=0, the Lévy distribution reduces to the normal "
6924
7082
"distribution."
6927
#: ../plugins/fn-random/functions.c:726
7085
#: ../plugins/fn-random/functions.c:727
6928
7086
msgid "If @{α} ≤ 0 or @{α} > 2, RANDLEVY returns #NUM!"
6931
#: ../plugins/fn-random/functions.c:727
7089
#: ../plugins/fn-random/functions.c:728
6932
7090
msgid "If @{β} < -1 or @{β} > 1, RANDLEVY returns #NUM!"
6935
#: ../plugins/fn-random/functions.c:750
7093
#: ../plugins/fn-random/functions.c:751
6936
7094
msgid "RANDEXPPOW:random variate from an exponential power distribution"
6939
#: ../plugins/fn-random/functions.c:751
7097
#: ../plugins/fn-random/functions.c:752
6940
7098
msgid "a:scale parameter of the exponential power distribution"
6943
#: ../plugins/fn-random/functions.c:752
7101
#: ../plugins/fn-random/functions.c:753
6944
7102
msgid "b:exponent of the exponential power distribution"
6947
#: ../plugins/fn-random/functions.c:753
7105
#: ../plugins/fn-random/functions.c:754
6949
7107
"For @{b} = 1 the exponential power distribution reduces to the Laplace "
6950
7108
"distribution."
6953
#: ../plugins/fn-random/functions.c:755
7111
#: ../plugins/fn-random/functions.c:756
6955
7113
"For @{b} = 2 the exponential power distribution reduces to the normal "
6956
7114
"distribution with σ = a/sqrt(2)"
6959
#: ../plugins/fn-random/functions.c:775
7117
#: ../plugins/fn-random/functions.c:776
6960
7118
msgid "RANDLANDAU:random variate from the Landau distribution"
6963
#: ../plugins/fn-random/functions.c:791
7121
#: ../plugins/fn-random/functions.c:792
6965
"RANDNORMTAIL:a random variates from the upper tail of a normal distribution "
7123
"RANDNORMTAIL:random variate from the upper tail of a normal distribution "
6969
#: ../plugins/fn-random/functions.c:793
7127
#: ../plugins/fn-random/functions.c:794
6970
7128
msgid "σ:standard deviation of the normal distribution"
6973
#: ../plugins/fn-random/functions.c:794
7131
#: ../plugins/fn-random/functions.c:795
6975
7133
"The method is based on Marsaglia's famous rectangle-wedge-tail algorithm "
6976
7134
"(Ann Math Stat 32, 894-899 (1961)), with this aspect explained in Knuth, v2, "
6977
7135
"3rd ed, p139, 586 (exercise 11)."
6980
#: ../plugins/fn-random/functions.c:815
7138
#: ../plugins/fn-random/functions.c:816
6982
7140
"SIMTABLE:one of the values in the given argument list depending on the round "
6983
"number of the simulation tool."
7141
"number of the simulation tool"
6986
#: ../plugins/fn-random/functions.c:817
7144
#: ../plugins/fn-random/functions.c:818
6987
7145
msgid "d1:first value"
6990
#: ../plugins/fn-random/functions.c:818
7148
#: ../plugins/fn-random/functions.c:819
6991
7149
msgid "d2:second value"
6994
#: ../plugins/fn-random/functions.c:819
7152
#: ../plugins/fn-random/functions.c:820
6996
7154
"SIMTABLE returns one of the values in the given argument list depending on "
6997
7155
"the round number of the simulation tool. When the simulation tool is not "
7252
7410
"the nearest even number."
7255
#: ../plugins/fn-stat/functions.c:279
7413
#: ../plugins/fn-stat/functions.c:278
7257
7415
"Then TRIMMEAN(A1:A5,0.2) equals 23.2 and TRIMMEAN(A1:A5,0.4) equals 21.5."
7260
#: ../plugins/fn-stat/functions.c:321
7418
#: ../plugins/fn-stat/functions.c:320
7261
7419
msgid "COVAR:covariance of two data sets"
7264
#: ../plugins/fn-stat/functions.c:322 ../plugins/fn-stat/functions.c:352
7422
#: ../plugins/fn-stat/functions.c:321 ../plugins/fn-stat/functions.c:351
7265
7423
msgid "array1:first data set"
7268
#: ../plugins/fn-stat/functions.c:323
7426
#: ../plugins/fn-stat/functions.c:322
7269
7427
msgid "array2:set data set"
7272
#: ../plugins/fn-stat/functions.c:324 ../plugins/fn-stat/functions.c:354
7273
#: ../plugins/fn-stat/functions.c:544 ../plugins/fn-stat/functions.c:792
7274
#: ../plugins/fn-stat/functions.c:821 ../plugins/fn-stat/functions.c:1832
7275
#: ../plugins/fn-stat/functions.c:1863 ../plugins/fn-stat/functions.c:1913
7276
#: ../plugins/fn-stat/functions.c:1999 ../plugins/fn-stat/functions.c:2018
7277
#: ../plugins/fn-stat/functions.c:2042
7430
#: ../plugins/fn-stat/functions.c:323 ../plugins/fn-stat/functions.c:353
7431
#: ../plugins/fn-stat/functions.c:543 ../plugins/fn-stat/functions.c:791
7432
#: ../plugins/fn-stat/functions.c:820 ../plugins/fn-stat/functions.c:1817
7433
#: ../plugins/fn-stat/functions.c:1848 ../plugins/fn-stat/functions.c:1898
7434
#: ../plugins/fn-stat/functions.c:1984 ../plugins/fn-stat/functions.c:2003
7435
#: ../plugins/fn-stat/functions.c:2027
7278
7436
msgid "Strings and empty cells are simply ignored."
7281
#: ../plugins/fn-stat/functions.c:326 ../plugins/fn-stat/functions.c:356
7282
#: ../plugins/fn-stat/functions.c:2365 ../plugins/fn-stat/functions.c:2955
7283
#: ../plugins/fn-stat/functions.c:3021 ../plugins/fn-stat/functions.c:3881
7284
#: ../plugins/fn-stat/functions.c:4355 ../plugins/fn-stat/functions.c:4425
7285
#: ../plugins/fn-stat/functions.c:4480
7439
#: ../plugins/fn-stat/functions.c:325 ../plugins/fn-stat/functions.c:355
7440
#: ../plugins/fn-stat/functions.c:2325 ../plugins/fn-stat/functions.c:2818
7441
#: ../plugins/fn-stat/functions.c:2884 ../plugins/fn-stat/functions.c:3917
7442
#: ../plugins/fn-stat/functions.c:3974 ../plugins/fn-stat/functions.c:4026
7287
7444
"Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, "
7288
7445
"21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, "
7292
#: ../plugins/fn-stat/functions.c:329
7449
#: ../plugins/fn-stat/functions.c:328
7293
7450
msgid "Then COVAR(A1:A5,B1:B5) equals 65.858."
7296
#: ../plugins/fn-stat/functions.c:331
7453
#: ../plugins/fn-stat/functions.c:330
7297
7454
msgid "wiki:en:Covariance"
7300
#: ../plugins/fn-stat/functions.c:332 ../plugins/fn-stat/functions.c:362
7457
#: ../plugins/fn-stat/functions.c:331 ../plugins/fn-stat/functions.c:361
7301
7458
msgid "wolfram:Covariance.html"
7304
#: ../plugins/fn-stat/functions.c:351
7461
#: ../plugins/fn-stat/functions.c:350
7305
7462
msgid "CORREL:Pearson correlation coefficient of two data sets"
7308
#: ../plugins/fn-stat/functions.c:353
7465
#: ../plugins/fn-stat/functions.c:352
7309
7466
msgid "array2:second data set"
7312
#: ../plugins/fn-stat/functions.c:359
7469
#: ../plugins/fn-stat/functions.c:358
7313
7470
msgid "Then CORREL(A1:A5,B1:B5) equals 0.996124788."
7316
#: ../plugins/fn-stat/functions.c:361
7473
#: ../plugins/fn-stat/functions.c:360
7317
7474
msgid "wiki:en:CorrelationCoefficient.html"
7477
#: ../plugins/fn-stat/functions.c:380
7479
"NEGBINOMDIST:probability mass function of the negative binomial distribution"
7320
7482
#: ../plugins/fn-stat/functions.c:381
7322
"NEGBINOMDIST:probability mass function of the negative binomial distribution"
7483
msgid "f:number of failures"
7325
7486
#: ../plugins/fn-stat/functions.c:382
7326
msgid "f:number of failures"
7487
msgid "t:threshold number of successes"
7329
7490
#: ../plugins/fn-stat/functions.c:383
7330
msgid "t:threshold number of successes"
7491
msgid "p:probability of a success"
7333
7494
#: ../plugins/fn-stat/functions.c:384
7334
msgid "p:probability of a success"
7495
msgid "If @{f} or @{t} is a non-integer it is truncated."
7337
7498
#: ../plugins/fn-stat/functions.c:385
7338
msgid "If @{f} or @{t} is a non-integer it is truncated."
7499
msgid "If (@{f} + @{t} -1) <= 0 this function returns a #NUM! error."
7341
7502
#: ../plugins/fn-stat/functions.c:386
7342
msgid "If (@{f} + @{t} -1) <= 0 this function returns a #NUM! error."
7345
#: ../plugins/fn-stat/functions.c:387
7346
7503
msgid "If @{p} < 0 or @{p} > 1 this functions returns a #NUM! error."
7349
#: ../plugins/fn-stat/functions.c:410
7506
#: ../plugins/fn-stat/functions.c:409
7351
7508
"NORMSDIST:cumulative density function of the standard normal distribution"
7354
#: ../plugins/fn-stat/functions.c:411 ../plugins/fn-stat/functions.c:463
7355
#: ../plugins/fn-stat/functions.c:524 ../plugins/fn-stat/functions.c:844
7356
#: ../plugins/fn-stat/functions.c:913 ../plugins/fn-stat/functions.c:976
7357
#: ../plugins/fn-stat/functions.c:1118 ../plugins/fn-stat/functions.c:1190
7358
#: ../plugins/fn-stat/functions.c:1277 ../plugins/fn-stat/functions.c:1307
7359
#: ../plugins/fn-stat/functions.c:1554 ../plugins/fn-stat/functions.c:1733
7360
#: ../plugins/fn-stat/functions.c:1769 ../plugins/fn-stat/functions.c:1936
7361
#: ../plugins/fn-stat/functions.c:4769 ../plugins/fn-stat/functions.c:4800
7362
#: ../plugins/fn-stat/functions.c:4834 ../plugins/fn-stat/functions.c:4869
7363
#: ../plugins/fn-stat/functions.c:4908 ../plugins/fn-stat/functions.c:4941
7367
#: ../plugins/fn-stat/functions.c:413
7511
#: ../plugins/fn-stat/functions.c:412
7368
7512
msgid "NORMSDIST is the OpenFormula function LEGACY.NORMSDIST."
7515
#: ../plugins/fn-stat/functions.c:415 ../plugins/fn-stat/functions.c:440
7516
msgid "wiki:en:Normal_distribution"
7371
7519
#: ../plugins/fn-stat/functions.c:416 ../plugins/fn-stat/functions.c:441
7372
msgid "wiki:en:Normal_distribution"
7375
#: ../plugins/fn-stat/functions.c:417 ../plugins/fn-stat/functions.c:442
7376
7520
msgid "wolfram:NormalDistribution.html"
7523
#: ../plugins/fn-stat/functions.c:433
7525
"NORMSINV:inverse of the cumulative density function of the standard normal "
7379
7529
#: ../plugins/fn-stat/functions.c:434
7381
"NORMSINV:inverse of the cumulative density function of the standard normal "
7530
msgid "p:given probability"
7385
7533
#: ../plugins/fn-stat/functions.c:435
7386
msgid "p:given probability"
7389
#: ../plugins/fn-stat/functions.c:436
7390
7534
msgid "If @{p} < 0 or @{p} > 1 this function returns #NUM! error."
7393
#: ../plugins/fn-stat/functions.c:438
7537
#: ../plugins/fn-stat/functions.c:437
7394
7538
msgid "NORMSINV is the OpenFormula function LEGACY.NORMSINV."
7397
#: ../plugins/fn-stat/functions.c:462
7541
#: ../plugins/fn-stat/functions.c:461
7399
7543
"LOGNORMDIST:cumulative distribution function of the lognormal distribution"
7546
#: ../plugins/fn-stat/functions.c:463 ../plugins/fn-stat/functions.c:493
7402
7550
#: ../plugins/fn-stat/functions.c:464 ../plugins/fn-stat/functions.c:494
7406
#: ../plugins/fn-stat/functions.c:465 ../plugins/fn-stat/functions.c:495
7407
7551
msgid "stddev:standard deviation"
7554
#: ../plugins/fn-stat/functions.c:465
7555
msgid "If @{stddev} = 0 LOGNORMDIST returns a #DIV/0! error."
7410
7558
#: ../plugins/fn-stat/functions.c:466
7411
msgid "If @{stddev} = 0 LOGNORMDIST returns a #DIV/0! error."
7414
#: ../plugins/fn-stat/functions.c:467
7416
7560
"If @{x} <= 0, @{mean} < 0 or @{stddev} <= 0 this function returns a #NUM! "
7564
#: ../plugins/fn-stat/functions.c:470 ../plugins/fn-stat/functions.c:499
7565
msgid "wiki:en:Log-normal_distribution"
7420
7568
#: ../plugins/fn-stat/functions.c:471 ../plugins/fn-stat/functions.c:500
7421
msgid "wiki:en:Log-normal_distribution"
7424
#: ../plugins/fn-stat/functions.c:472 ../plugins/fn-stat/functions.c:501
7425
7569
msgid "wolfram:LogNormalDistribution.html"
7428
#: ../plugins/fn-stat/functions.c:492
7572
#: ../plugins/fn-stat/functions.c:491
7430
7574
"LOGINV:inverse of the cumulative distribution function of the lognormal "
7434
#: ../plugins/fn-stat/functions.c:496
7578
#: ../plugins/fn-stat/functions.c:495
7436
7580
"If @{p} < 0 or @{p} > 1 or @{stddev} <= 0 this function returns #NUM! error."
7439
#: ../plugins/fn-stat/functions.c:523
7583
#: ../plugins/fn-stat/functions.c:522
7440
7584
msgid "FISHERINV:inverse of the Fisher transformation"
7443
#: ../plugins/fn-stat/functions.c:525
7587
#: ../plugins/fn-stat/functions.c:524
7444
7588
msgid "If @{x} is a non-number this function returns a #VALUE! error."
7447
#: ../plugins/fn-stat/functions.c:541
7591
#: ../plugins/fn-stat/functions.c:540
7448
7592
msgid "MODE:first most common number in the dataset"
7595
#: ../plugins/fn-stat/functions.c:541 ../plugins/fn-stat/functions.c:569
7596
#: ../plugins/fn-stat/functions.c:596 ../plugins/fn-stat/functions.c:623
7597
#: ../plugins/fn-stat/functions.c:659 ../plugins/fn-stat/functions.c:693
7598
#: ../plugins/fn-stat/functions.c:719 ../plugins/fn-stat/functions.c:754
7599
#: ../plugins/fn-stat/functions.c:789 ../plugins/fn-stat/functions.c:818
7600
#: ../plugins/fn-stat/functions.c:1815 ../plugins/fn-stat/functions.c:1846
7601
#: ../plugins/fn-stat/functions.c:1872 ../plugins/fn-stat/functions.c:1896
7602
#: ../plugins/fn-stat/functions.c:2025 ../plugins/fn-stat/functions.c:2438
7603
#: ../plugins/fn-stat/functions.c:2463 ../plugins/fn-stat/functions.c:2490
7604
msgid "number1:first value"
7451
7607
#: ../plugins/fn-stat/functions.c:542 ../plugins/fn-stat/functions.c:570
7452
7608
#: ../plugins/fn-stat/functions.c:597 ../plugins/fn-stat/functions.c:624
7453
7609
#: ../plugins/fn-stat/functions.c:660 ../plugins/fn-stat/functions.c:694
7454
7610
#: ../plugins/fn-stat/functions.c:720 ../plugins/fn-stat/functions.c:755
7455
7611
#: ../plugins/fn-stat/functions.c:790 ../plugins/fn-stat/functions.c:819
7456
#: ../plugins/fn-stat/functions.c:1830 ../plugins/fn-stat/functions.c:1861
7457
#: ../plugins/fn-stat/functions.c:1887 ../plugins/fn-stat/functions.c:1911
7458
#: ../plugins/fn-stat/functions.c:2040 ../plugins/fn-stat/functions.c:2574
7459
#: ../plugins/fn-stat/functions.c:2599 ../plugins/fn-stat/functions.c:2626
7460
msgid "number1:first value"
7463
#: ../plugins/fn-stat/functions.c:543 ../plugins/fn-stat/functions.c:571
7464
#: ../plugins/fn-stat/functions.c:598 ../plugins/fn-stat/functions.c:625
7465
#: ../plugins/fn-stat/functions.c:661 ../plugins/fn-stat/functions.c:695
7466
#: ../plugins/fn-stat/functions.c:721 ../plugins/fn-stat/functions.c:756
7467
#: ../plugins/fn-stat/functions.c:791 ../plugins/fn-stat/functions.c:820
7468
#: ../plugins/fn-stat/functions.c:1831 ../plugins/fn-stat/functions.c:1862
7469
#: ../plugins/fn-stat/functions.c:1888 ../plugins/fn-stat/functions.c:1912
7470
#: ../plugins/fn-stat/functions.c:2041 ../plugins/fn-stat/functions.c:2575
7471
#: ../plugins/fn-stat/functions.c:2600 ../plugins/fn-stat/functions.c:2627
7612
#: ../plugins/fn-stat/functions.c:1816 ../plugins/fn-stat/functions.c:1847
7613
#: ../plugins/fn-stat/functions.c:1873 ../plugins/fn-stat/functions.c:1897
7614
#: ../plugins/fn-stat/functions.c:2026 ../plugins/fn-stat/functions.c:2439
7615
#: ../plugins/fn-stat/functions.c:2464 ../plugins/fn-stat/functions.c:2491
7472
7616
msgid "number2:second value"
7475
#: ../plugins/fn-stat/functions.c:545
7619
#: ../plugins/fn-stat/functions.c:544
7477
7621
"If the data set does not contain any duplicates this function returns a #N/A "
7625
#: ../plugins/fn-stat/functions.c:546
7627
"Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, "
7628
"11.4, 25.9, and 40.1."
7481
7631
#: ../plugins/fn-stat/functions.c:547
7483
"Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, "
7484
"11.4, 25.9, and 40.1."
7487
#: ../plugins/fn-stat/functions.c:548
7488
7632
msgid "Then MODE(A1:A5) equals 11.4."
7635
#: ../plugins/fn-stat/functions.c:549
7636
msgid "wiki:en:Mode_(statistics)"
7491
7639
#: ../plugins/fn-stat/functions.c:550
7492
msgid "wiki:en:Mode_(statistics)"
7495
#: ../plugins/fn-stat/functions.c:551
7496
7640
msgid "wolfram:Mode.html"
7499
#: ../plugins/fn-stat/functions.c:569
7643
#: ../plugins/fn-stat/functions.c:568
7500
7644
msgid "HARMEAN:harmonic mean"
7503
#: ../plugins/fn-stat/functions.c:572
7647
#: ../plugins/fn-stat/functions.c:571
7505
7649
"The harmonic mean of N data points is N divided by the sum of the "
7506
7650
"reciprocals of the data points)."
7509
#: ../plugins/fn-stat/functions.c:575
7653
#: ../plugins/fn-stat/functions.c:574
7510
7654
msgid "Then HARMEAN(A1:A5) equals 19.529814427."
7657
#: ../plugins/fn-stat/functions.c:576
7658
msgid "wiki:en:Harmonic_mean"
7513
7661
#: ../plugins/fn-stat/functions.c:577
7514
msgid "wiki:en:Harmonic_mean"
7517
#: ../plugins/fn-stat/functions.c:578
7518
7662
msgid "wolfram:HarmonicMean.html"
7521
#: ../plugins/fn-stat/functions.c:596
7665
#: ../plugins/fn-stat/functions.c:595
7522
7666
msgid "GEOMEAN:geometric mean"
7525
#: ../plugins/fn-stat/functions.c:599
7669
#: ../plugins/fn-stat/functions.c:598
7527
7671
"The geometric mean is equal to the Nth root of the product of the N values."
7530
#: ../plugins/fn-stat/functions.c:602
7674
#: ../plugins/fn-stat/functions.c:601
7531
7675
msgid "Then GEOMEAN(A1:A5) equals 21.279182482."
7678
#: ../plugins/fn-stat/functions.c:603
7679
msgid "wiki:en:Geometric_mean"
7534
7682
#: ../plugins/fn-stat/functions.c:604
7535
msgid "wiki:en:Geometric_mean"
7538
#: ../plugins/fn-stat/functions.c:605
7539
7683
msgid "wolfram:GeometricMean.html"
7542
#: ../plugins/fn-stat/functions.c:623
7686
#: ../plugins/fn-stat/functions.c:622
7543
7687
msgid "COUNT:total number of integer or floating point arguments passed"
7546
#: ../plugins/fn-stat/functions.c:628
7690
#: ../plugins/fn-stat/functions.c:627
7547
7691
msgid "Then COUNT(A1:A5) equals 5."
7550
#: ../plugins/fn-stat/functions.c:659
7694
#: ../plugins/fn-stat/functions.c:658
7551
7695
msgid "COUNTA:number of arguments passed not including empty cells"
7698
#: ../plugins/fn-stat/functions.c:662
7700
"Let us assume that the cells A1, A2, ..., A5 contain numbers and strings "
7701
"11.4, \"missing\", \"missing\", 25.9, and 40.1."
7554
7704
#: ../plugins/fn-stat/functions.c:663
7556
"Let us assume that the cells A1, A2, ..., A5 contain numbers and strings "
7557
"11.4, \"missing\", \"missing\", 25.9, and 40.1."
7560
#: ../plugins/fn-stat/functions.c:664
7561
7705
msgid "Then COUNTA(A1:A5) equals 5."
7564
#: ../plugins/fn-stat/functions.c:693
7708
#: ../plugins/fn-stat/functions.c:692
7565
7709
msgid "AVERAGE:average of all the numeric values and cells"
7568
#: ../plugins/fn-stat/functions.c:698
7712
#: ../plugins/fn-stat/functions.c:697
7569
7713
msgid "Then AVERAGE(A1:A5) equals 23.2."
7716
#: ../plugins/fn-stat/functions.c:699
7717
msgid "wiki:en:Arithmetic_mean"
7572
7720
#: ../plugins/fn-stat/functions.c:700
7573
msgid "wiki:en:Arithmetic_mean"
7576
#: ../plugins/fn-stat/functions.c:701
7577
7721
msgid "wolfram:ArithmeticMean.html"
7580
#: ../plugins/fn-stat/functions.c:719
7724
#: ../plugins/fn-stat/functions.c:718
7582
7726
"MIN:smallest value, with negative numbers considered smaller than positive "
7586
#: ../plugins/fn-stat/functions.c:724
7730
#: ../plugins/fn-stat/functions.c:723
7587
7731
msgid "Then MIN(A1:A5) equals 11.4."
7590
#: ../plugins/fn-stat/functions.c:754
7734
#: ../plugins/fn-stat/functions.c:753
7592
7736
"MAX:largest value, with negative numbers considered smaller than positive "
7596
#: ../plugins/fn-stat/functions.c:759
7740
#: ../plugins/fn-stat/functions.c:758
7597
7741
msgid "Then MAX(A1:A5) equals 40.1."
7600
#: ../plugins/fn-stat/functions.c:789
7744
#: ../plugins/fn-stat/functions.c:788
7601
7745
msgid "SKEW:unbiased estimate for skewness of a distribution"
7604
#: ../plugins/fn-stat/functions.c:793
7748
#: ../plugins/fn-stat/functions.c:792
7606
7750
"This is only meaningful if the underlying distribution really has a third "
7607
7751
"moment. The skewness of a symmetric (e.g., normal) distribution is zero."
7610
#: ../plugins/fn-stat/functions.c:796
7754
#: ../plugins/fn-stat/functions.c:795
7612
7756
"If less than three numbers are given, this function returns a #DIV/0! error."
7615
#: ../plugins/fn-stat/functions.c:799
7759
#: ../plugins/fn-stat/functions.c:798
7616
7760
msgid "Then SKEW(A1:A5) equals 0.976798268."
7619
#: ../plugins/fn-stat/functions.c:818
7763
#: ../plugins/fn-stat/functions.c:817
7620
7764
msgid "SKEWP:population skewness of a data set"
7623
#: ../plugins/fn-stat/functions.c:822
7767
#: ../plugins/fn-stat/functions.c:821
7624
7768
msgid "If less than two numbers are given, SKEWP returns a #DIV/0! error."
7627
#: ../plugins/fn-stat/functions.c:824
7771
#: ../plugins/fn-stat/functions.c:823
7628
7772
msgid "Then SKEWP(A1:A5) equals 0.655256198."
7631
#: ../plugins/fn-stat/functions.c:843
7632
msgid "EXPONDIST:(cumulative)density function of the exponential distribution"
7775
#: ../plugins/fn-stat/functions.c:842
7777
"EXPONDIST:probability density or cumulative distribution function of the "
7778
"exponential distribution"
7635
#: ../plugins/fn-stat/functions.c:845
7781
#: ../plugins/fn-stat/functions.c:844
7636
7782
msgid "y:scale parameter"
7639
#: ../plugins/fn-stat/functions.c:846 ../plugins/fn-stat/functions.c:916
7640
#: ../plugins/fn-stat/functions.c:1556 ../plugins/fn-stat/functions.c:1736
7641
#: ../plugins/fn-stat/functions.c:1772
7785
#: ../plugins/fn-stat/functions.c:845 ../plugins/fn-stat/functions.c:915
7786
#: ../plugins/fn-stat/functions.c:1541 ../plugins/fn-stat/functions.c:1721
7787
#: ../plugins/fn-stat/functions.c:1757
7643
7789
"cumulative:whether to evaluate the density function or the cumulative "
7644
7790
"distribution function"
7647
#: ../plugins/fn-stat/functions.c:847
7793
#: ../plugins/fn-stat/functions.c:846
7649
7795
"If @{cumulative} is false it will return:\t@{y} * exp (-@{y}*@{x}),otherwise "
7650
7796
"it will return\t1 - exp (-@{y}*@{x})."
7653
#: ../plugins/fn-stat/functions.c:850
7799
#: ../plugins/fn-stat/functions.c:849
7654
7800
msgid "If @{x} < 0 or @{y} <= 0 this will return an error."
7803
#: ../plugins/fn-stat/functions.c:875
7804
msgid "BERNOULLI:probability mass function of a Bernoulli distribution"
7657
7807
#: ../plugins/fn-stat/functions.c:876
7658
msgid "BERNOULLI:probability mass function of a Bernoulli distribution"
7661
#: ../plugins/fn-stat/functions.c:877
7665
#: ../plugins/fn-stat/functions.c:879
7811
#: ../plugins/fn-stat/functions.c:878
7666
7812
msgid "If @{k} != 0 and @{k} != 1 this function returns a #NUM! error."
7669
#: ../plugins/fn-stat/functions.c:880 ../plugins/fn-stat/functions.c:949
7670
#: ../plugins/fn-stat/functions.c:1160 ../plugins/fn-stat/functions.c:1447
7671
#: ../plugins/fn-stat/functions.c:1480 ../plugins/fn-stat/functions.c:1514
7672
#: ../plugins/fn-stat/functions.c:1589 ../plugins/fn-stat/functions.c:4742
7815
#: ../plugins/fn-stat/functions.c:879 ../plugins/fn-stat/functions.c:948
7816
#: ../plugins/fn-stat/functions.c:1159 ../plugins/fn-stat/functions.c:1446
7817
#: ../plugins/fn-stat/functions.c:1479 ../plugins/fn-stat/functions.c:1513
7818
#: ../plugins/fn-stat/functions.c:1574 ../plugins/fn-stat/functions.c:4285
7673
7819
msgid "If @{p} < 0 or @{p} > 1 this function returns a #NUM! error."
7676
#: ../plugins/fn-stat/functions.c:912
7677
msgid "GAMMADIST:(cumulative) density function of the gamma distribution"
7822
#: ../plugins/fn-stat/functions.c:911
7824
"GAMMADIST:probability density or cumulative distribution function of the "
7825
"gamma distribution"
7828
#: ../plugins/fn-stat/functions.c:913 ../plugins/fn-stat/functions.c:946
7829
#: ../plugins/fn-stat/functions.c:1118 ../plugins/fn-stat/functions.c:1155
7830
#: ../plugins/fn-stat/functions.c:1719
7831
msgid "alpha:scale parameter"
7680
7834
#: ../plugins/fn-stat/functions.c:914 ../plugins/fn-stat/functions.c:947
7681
7835
#: ../plugins/fn-stat/functions.c:1119 ../plugins/fn-stat/functions.c:1156
7682
#: ../plugins/fn-stat/functions.c:1734
7683
msgid "alpha:scale parameter"
7686
#: ../plugins/fn-stat/functions.c:915 ../plugins/fn-stat/functions.c:948
7687
#: ../plugins/fn-stat/functions.c:1120 ../plugins/fn-stat/functions.c:1157
7688
#: ../plugins/fn-stat/functions.c:1735
7836
#: ../plugins/fn-stat/functions.c:1720
7689
7837
msgid "beta:scale parameter"
7692
#: ../plugins/fn-stat/functions.c:917 ../plugins/fn-stat/functions.c:1281
7693
#: ../plugins/fn-stat/functions.c:1740 ../plugins/fn-stat/functions.c:1969
7840
#: ../plugins/fn-stat/functions.c:916 ../plugins/fn-stat/functions.c:1280
7841
#: ../plugins/fn-stat/functions.c:1725 ../plugins/fn-stat/functions.c:1954
7694
7842
msgid "If @{x} < 0 this function returns a #NUM! error."
7697
#: ../plugins/fn-stat/functions.c:918 ../plugins/fn-stat/functions.c:1124
7698
#: ../plugins/fn-stat/functions.c:1161
7845
#: ../plugins/fn-stat/functions.c:917 ../plugins/fn-stat/functions.c:1123
7846
#: ../plugins/fn-stat/functions.c:1160
7699
7847
msgid "If @{alpha} <= 0 or @{beta} <= 0, this function returns a #NUM! error."
7702
#: ../plugins/fn-stat/functions.c:945
7850
#: ../plugins/fn-stat/functions.c:944
7703
7851
msgid "GAMMAINV:inverse of the cumulative gamma distribution"
7706
#: ../plugins/fn-stat/functions.c:950 ../plugins/fn-stat/functions.c:1741
7854
#: ../plugins/fn-stat/functions.c:949 ../plugins/fn-stat/functions.c:1726
7707
7855
msgid "If @{alpha} <= 0 or @{beta} <= 0 this function returns a #NUM! error."
7710
#: ../plugins/fn-stat/functions.c:975
7858
#: ../plugins/fn-stat/functions.c:974
7711
7859
msgid "CHIDIST:survival function of the chi-squared distribution"
7862
#: ../plugins/fn-stat/functions.c:976 ../plugins/fn-stat/functions.c:1004
7863
#: ../plugins/fn-stat/functions.c:1190 ../plugins/fn-stat/functions.c:1242
7864
msgid "dof:number of degrees of freedom"
7714
7867
#: ../plugins/fn-stat/functions.c:977 ../plugins/fn-stat/functions.c:1005
7715
#: ../plugins/fn-stat/functions.c:1191 ../plugins/fn-stat/functions.c:1243
7716
msgid "dof:number of degrees of freedom"
7719
#: ../plugins/fn-stat/functions.c:978 ../plugins/fn-stat/functions.c:1006
7720
#: ../plugins/fn-stat/functions.c:1193 ../plugins/fn-stat/functions.c:1244
7721
#: ../plugins/fn-stat/functions.c:1280 ../plugins/fn-stat/functions.c:1446
7868
#: ../plugins/fn-stat/functions.c:1192 ../plugins/fn-stat/functions.c:1243
7869
#: ../plugins/fn-stat/functions.c:1279 ../plugins/fn-stat/functions.c:1445
7722
7870
msgid "The survival function is 1 minus the cumulative distribution function."
7725
#: ../plugins/fn-stat/functions.c:979
7873
#: ../plugins/fn-stat/functions.c:978
7726
7874
msgid "If @{dof} is non-integer it is truncated."
7729
#: ../plugins/fn-stat/functions.c:980 ../plugins/fn-stat/functions.c:1194
7877
#: ../plugins/fn-stat/functions.c:979 ../plugins/fn-stat/functions.c:1193
7730
7878
msgid "If @{dof} < 1 this function returns a #NUM! error."
7733
#: ../plugins/fn-stat/functions.c:982
7881
#: ../plugins/fn-stat/functions.c:981
7735
7883
"CHIDIST(@{x},@{dof}) is the OpenFormula function LEGACY.CHIDIST(@{x},@{dof})."
7738
#: ../plugins/fn-stat/functions.c:1003
7886
#: ../plugins/fn-stat/functions.c:1002
7739
7887
msgid "CHIINV:inverse of the survival function of the chi-squared distribution"
7742
#: ../plugins/fn-stat/functions.c:1007 ../plugins/fn-stat/functions.c:1245
7890
#: ../plugins/fn-stat/functions.c:1006 ../plugins/fn-stat/functions.c:1244
7744
7892
"If @{p} < 0 or @{p} > 1 or @{dof} < 1 this function returns a #NUM! error."
7747
#: ../plugins/fn-stat/functions.c:1009
7895
#: ../plugins/fn-stat/functions.c:1008
7749
7897
"CHIINV(@{p},@{dof}) is the OpenFormula function LEGACY.CHIDIST(@{p},@{dof})."
7900
#: ../plugins/fn-stat/functions.c:1029
7901
msgid "CHITEST:p value of the Goodness of Fit Test"
7752
7904
#: ../plugins/fn-stat/functions.c:1030
7753
msgid "CHITEST:p value of the Goodness of Fit Test"
7905
msgid "actual_range:observed data"
7756
7908
#: ../plugins/fn-stat/functions.c:1031
7757
msgid "actual_range:observed data"
7909
msgid "theoretical_range:expected values"
7760
7912
#: ../plugins/fn-stat/functions.c:1032
7761
msgid "theoretical_range:expected values"
7764
#: ../plugins/fn-stat/functions.c:1033
7766
7914
"If the actual range is not an n by 1 or 1 by n range, but an n by m range, "
7767
7915
"then CHITEST uses (n-1) times (m-1) as degrees of freedom. This is useful if "
7769
7917
"independence or test of homogeneity."
7772
#: ../plugins/fn-stat/functions.c:1039
7920
#: ../plugins/fn-stat/functions.c:1038
7773
7921
msgid "CHITEST is the OpenFormula function LEGACY.CHITEST."
7776
#: ../plugins/fn-stat/functions.c:1117
7924
#: ../plugins/fn-stat/functions.c:1116
7777
7925
msgid "BETADIST:cumulative distribution function of the beta distribution"
7928
#: ../plugins/fn-stat/functions.c:1120 ../plugins/fn-stat/functions.c:1157
7929
msgid "a:optional lower bound, defaults to 0"
7780
7932
#: ../plugins/fn-stat/functions.c:1121 ../plugins/fn-stat/functions.c:1158
7781
msgid "a:optional lower bound, defaults to 0"
7784
#: ../plugins/fn-stat/functions.c:1122 ../plugins/fn-stat/functions.c:1159
7785
7933
msgid "b:optional upper bound, defaults to 1"
7788
#: ../plugins/fn-stat/functions.c:1123
7936
#: ../plugins/fn-stat/functions.c:1122
7789
7937
msgid "If @{x} < @{a} or @{x} > @{b} this function returns a #NUM! error."
7792
#: ../plugins/fn-stat/functions.c:1125 ../plugins/fn-stat/functions.c:1162
7940
#: ../plugins/fn-stat/functions.c:1124 ../plugins/fn-stat/functions.c:1161
7793
7941
msgid "If @{a} >= @{b} this function returns a #NUM! error."
7796
#: ../plugins/fn-stat/functions.c:1154
7944
#: ../plugins/fn-stat/functions.c:1153
7798
7946
"BETAINV:inverse of the cumulative distribution function of the beta "
7802
#: ../plugins/fn-stat/functions.c:1189
7950
#: ../plugins/fn-stat/functions.c:1188
7803
7951
msgid "TDIST:survival function of the Student t-distribution"
7806
#: ../plugins/fn-stat/functions.c:1192
7807
msgid "tails:1 or 2."
7954
#: ../plugins/fn-stat/functions.c:1191
7955
msgid "tails:1 or 2"
7958
#: ../plugins/fn-stat/functions.c:1194
7959
msgid "If @{tails} is neither 1 or 2 this function returns a #NUM! error."
7810
7962
#: ../plugins/fn-stat/functions.c:1195
7811
msgid "If @{tails} is neither 1 or 2 this function returns a #NUM! error."
7814
#: ../plugins/fn-stat/functions.c:1196
7816
7964
"The parameterization of this function is different from what is used for, e."
7817
7965
"g., NORMSDIST. This is a common source of mistakes, but necessary for "
7818
7966
"compatibility."
7821
#: ../plugins/fn-stat/functions.c:1199
7969
#: ../plugins/fn-stat/functions.c:1198
7822
7970
msgid "This function is Excel compatible for non-negative @{x}."
7825
#: ../plugins/fn-stat/functions.c:1241
7973
#: ../plugins/fn-stat/functions.c:1240
7826
7974
msgid "TINV:inverse of the survival function of the Student t-distribution"
7829
#: ../plugins/fn-stat/functions.c:1247
7977
#: ../plugins/fn-stat/functions.c:1246
7831
7979
"The parameterization of this function is different from what is used for, e."
7832
7980
"g., NORMSINV. This is a common source of mistakes, but necessary for "
7833
7981
"compatibility."
7836
#: ../plugins/fn-stat/functions.c:1276
7984
#: ../plugins/fn-stat/functions.c:1275
7837
7985
msgid "FDIST:survival function of the F distribution"
7988
#: ../plugins/fn-stat/functions.c:1277 ../plugins/fn-stat/functions.c:1443
7989
msgid "dof_of_num:numerator degrees of freedom"
7840
7992
#: ../plugins/fn-stat/functions.c:1278 ../plugins/fn-stat/functions.c:1444
7841
msgid "dof_of_num:numerator degrees of freedom"
7844
#: ../plugins/fn-stat/functions.c:1279 ../plugins/fn-stat/functions.c:1445
7845
7993
msgid "dof_of_denom:denominator degrees of freedom"
7848
#: ../plugins/fn-stat/functions.c:1282
7996
#: ../plugins/fn-stat/functions.c:1281
7850
7998
"If @{dof_of_num} < 1 or @{dof_of_denom} < 1, this function returns a #NUM! "
7854
#: ../plugins/fn-stat/functions.c:1284
8002
#: ../plugins/fn-stat/functions.c:1283
7855
8003
msgid "FDIST is the OpenFormula function LEGACY.FDIST."
7858
#: ../plugins/fn-stat/functions.c:1306
8006
#: ../plugins/fn-stat/functions.c:1305
7860
8008
"LANDAU:approximate probability density function of the Landau distribution"
7863
#: ../plugins/fn-stat/functions.c:1442
8011
#: ../plugins/fn-stat/functions.c:1441
7864
8012
msgid "FINV:inverse of the survival function of the F distribution"
7867
#: ../plugins/fn-stat/functions.c:1448
8015
#: ../plugins/fn-stat/functions.c:1447
7869
8017
"If @{dof_of_num} < 1 or @{dof_of_denom} < 1 this function returns a #NUM! "
7873
#: ../plugins/fn-stat/functions.c:1450
8021
#: ../plugins/fn-stat/functions.c:1449
7874
8022
msgid "FINV is the OpenFormula function LEGACY.FINV."
8025
#: ../plugins/fn-stat/functions.c:1471
8027
"BINOMDIST:probability mass or cumulative distribution function of the "
8028
"binomial distribution"
7877
8031
#: ../plugins/fn-stat/functions.c:1472
7879
"BINOMDIST:(cumulative) probability mass function of the binomial distribution"
7882
#: ../plugins/fn-stat/functions.c:1473
7883
8032
msgid "n:number of successes"
8035
#: ../plugins/fn-stat/functions.c:1473 ../plugins/fn-stat/functions.c:1507
8036
#: ../plugins/fn-stat/functions.c:1569
8037
msgid "trials:number of trials"
7886
8040
#: ../plugins/fn-stat/functions.c:1474 ../plugins/fn-stat/functions.c:1508
7887
#: ../plugins/fn-stat/functions.c:1584
7888
msgid "trials:number of trials"
7891
#: ../plugins/fn-stat/functions.c:1475 ../plugins/fn-stat/functions.c:1509
7892
#: ../plugins/fn-stat/functions.c:1585
8041
#: ../plugins/fn-stat/functions.c:1570
7893
8042
msgid "p:probability of success in each trial"
7896
#: ../plugins/fn-stat/functions.c:1476 ../plugins/fn-stat/functions.c:1644
7897
#: ../plugins/fn-stat/functions.c:1967 ../plugins/fn-stat/functions.c:4740
8045
#: ../plugins/fn-stat/functions.c:1475 ../plugins/fn-stat/functions.c:1629
8046
#: ../plugins/fn-stat/functions.c:1952 ../plugins/fn-stat/functions.c:4283
7899
8048
"cumulative:whether to evaluate the mass function or the cumulative "
7900
8049
"distribution function"
8052
#: ../plugins/fn-stat/functions.c:1476
8053
msgid "If @{n} or @{trials} are non-integer they are truncated."
7903
8056
#: ../plugins/fn-stat/functions.c:1477
7904
msgid "If @{n} or @{trials} are non-integer they are truncated."
8057
msgid "If @{n} < 0 or @{trials} < 0 this function returns a #NUM! error."
7907
8060
#: ../plugins/fn-stat/functions.c:1478
7908
msgid "If @{n} < 0 or @{trials} < 0 this function returns a #NUM! error."
7911
#: ../plugins/fn-stat/functions.c:1479
7912
8061
msgid "If @{n} > @{trials} this function returns a #NUM! error."
7915
#: ../plugins/fn-stat/functions.c:1507
8064
#: ../plugins/fn-stat/functions.c:1506
7917
8066
"BINOM.DIST.RANGE:probability of the binomial distribution over an interval"
8069
#: ../plugins/fn-stat/functions.c:1509
8070
msgid "start:start of the interval"
7920
8073
#: ../plugins/fn-stat/functions.c:1510
7921
msgid "start:start of the interval"
8074
msgid "end:end of the interval, defaults to @{start}"
7924
8077
#: ../plugins/fn-stat/functions.c:1511
7925
msgid "end:start of the interval, defaults to @{start}"
7928
#: ../plugins/fn-stat/functions.c:1512
7929
8078
msgid "If @{start}, @{end} or @{trials} are non-integer they are truncated."
7932
#: ../plugins/fn-stat/functions.c:1513 ../plugins/fn-stat/functions.c:1588
8081
#: ../plugins/fn-stat/functions.c:1512 ../plugins/fn-stat/functions.c:1573
7933
8082
msgid "If @{trials} < 0 this function returns a #NUM! error."
7936
#: ../plugins/fn-stat/functions.c:1515
8085
#: ../plugins/fn-stat/functions.c:1514
7937
8086
msgid "If @{start} > @{end} this function returns 0."
7940
#: ../plugins/fn-stat/functions.c:1516
7941
msgid "This function is the OpenFormula function B"
7944
#: ../plugins/fn-stat/functions.c:1552
8089
#: ../plugins/fn-stat/functions.c:1537
7946
"CAUCHY:(cumulative) probability density function of the Cauchy, Lorentz or "
7947
"Breit-Wigner distribution"
8091
"CAUCHY:probability density or cumulative distribution function of the "
8092
"Cauchy, Lorentz or Breit-Wigner distribution"
7950
#: ../plugins/fn-stat/functions.c:1555 ../plugins/fn-stat/functions.c:4770
7951
#: ../plugins/fn-stat/functions.c:4909
8095
#: ../plugins/fn-stat/functions.c:1540 ../plugins/fn-stat/functions.c:4313
8096
#: ../plugins/fn-stat/functions.c:4452
7952
8097
msgid "a:scale parameter"
7955
#: ../plugins/fn-stat/functions.c:1557
8100
#: ../plugins/fn-stat/functions.c:1542
7956
8101
msgid "If @{a} < 0 this function returns a #NUM! error."
7959
#: ../plugins/fn-stat/functions.c:1558 ../plugins/fn-stat/functions.c:4743
8104
#: ../plugins/fn-stat/functions.c:1543 ../plugins/fn-stat/functions.c:4286
7961
8106
"If @{cumulative} is neither TRUE nor FALSE this function returns a #VALUE! "
7965
#: ../plugins/fn-stat/functions.c:1583
8110
#: ../plugins/fn-stat/functions.c:1568
7966
8111
msgid "CRITBINOM:right-tailed critical value of the binomial distribution"
7969
#: ../plugins/fn-stat/functions.c:1586
8114
#: ../plugins/fn-stat/functions.c:1571
7970
8115
msgid "alpha:significance level (area of the tail)"
7973
#: ../plugins/fn-stat/functions.c:1587
8118
#: ../plugins/fn-stat/functions.c:1572
7974
8119
msgid "If @{trials} is a non-integer it is truncated."
7977
#: ../plugins/fn-stat/functions.c:1590
8122
#: ../plugins/fn-stat/functions.c:1575
7978
8123
msgid "If @{alpha} < 0 or @{alpha} > 1 this function returns a #NUM! error."
7981
#: ../plugins/fn-stat/functions.c:1613
8126
#: ../plugins/fn-stat/functions.c:1598
7982
8127
msgid "PERMUT:number of @{k}-permutations of a @{n}-set"
7985
#: ../plugins/fn-stat/functions.c:1614
8130
#: ../plugins/fn-stat/functions.c:1599
7986
8131
msgid "n:size of the base set"
7989
#: ../plugins/fn-stat/functions.c:1615
8134
#: ../plugins/fn-stat/functions.c:1600
7990
8135
msgid "k:number of elements in each permutation"
7993
#: ../plugins/fn-stat/functions.c:1616
8138
#: ../plugins/fn-stat/functions.c:1601
7994
8139
msgid "If @{n} = 0 this function returns a #NUM! error."
7997
#: ../plugins/fn-stat/functions.c:1617
8142
#: ../plugins/fn-stat/functions.c:1602
7998
8143
msgid "If @{n} < @{k} this function returns a #NUM! error."
8001
#: ../plugins/fn-stat/functions.c:1639
8146
#: ../plugins/fn-stat/functions.c:1624
8003
"HYPGEOMDIST:(cumulative) probability mass function of the hypergeometric "
8148
"HYPGEOMDIST:probability mass or cumulative distribution function of the "
8149
"hypergeometric distribution"
8007
#: ../plugins/fn-stat/functions.c:1640
8152
#: ../plugins/fn-stat/functions.c:1625
8008
8153
msgid "x:number of successes"
8011
#: ../plugins/fn-stat/functions.c:1641
8156
#: ../plugins/fn-stat/functions.c:1626
8012
8157
msgid "n:sample size"
8015
#: ../plugins/fn-stat/functions.c:1642
8160
#: ../plugins/fn-stat/functions.c:1627
8016
8161
msgid "M:number of possible successes in the population"
8019
#: ../plugins/fn-stat/functions.c:1643
8164
#: ../plugins/fn-stat/functions.c:1628
8020
8165
msgid "N:population size"
8023
#: ../plugins/fn-stat/functions.c:1645
8168
#: ../plugins/fn-stat/functions.c:1630
8024
8169
msgid "If @{x},@{n},@{M} or @{N} is a non-integer it is truncated."
8027
#: ../plugins/fn-stat/functions.c:1646
8172
#: ../plugins/fn-stat/functions.c:1631
8028
8173
msgid "If @{x},@{n},@{M} or @{N} < 0 this function returns a #NUM! error."
8031
#: ../plugins/fn-stat/functions.c:1647
8176
#: ../plugins/fn-stat/functions.c:1632
8032
8177
msgid "If @{x} > @{M} or @{n} > @{N} this function returns a #NUM! error."
8035
#: ../plugins/fn-stat/functions.c:1675
8180
#: ../plugins/fn-stat/functions.c:1660
8037
8182
"CONFIDENCE:margin of error of a confidence interval for the population mean"
8040
#: ../plugins/fn-stat/functions.c:1676
8185
#: ../plugins/fn-stat/functions.c:1661
8041
8186
msgid "alpha:significance level"
8044
#: ../plugins/fn-stat/functions.c:1677
8189
#: ../plugins/fn-stat/functions.c:1662
8045
8190
msgid "stddev:population standard deviation"
8048
#: ../plugins/fn-stat/functions.c:1678
8193
#: ../plugins/fn-stat/functions.c:1663
8049
8194
msgid "size:sample size"
8052
#: ../plugins/fn-stat/functions.c:1679
8197
#: ../plugins/fn-stat/functions.c:1664
8054
8199
"This function requires the usually unknown population standard deviation."
8057
#: ../plugins/fn-stat/functions.c:1680
8202
#: ../plugins/fn-stat/functions.c:1665
8058
8203
msgid "If @{size} is non-integer it is truncated."
8061
#: ../plugins/fn-stat/functions.c:1681
8206
#: ../plugins/fn-stat/functions.c:1666
8062
8207
msgid "If @{size} < 0 this function returns a #NUM! error."
8065
#: ../plugins/fn-stat/functions.c:1682
8210
#: ../plugins/fn-stat/functions.c:1667
8066
8211
msgid "If @{size} is 0 this function returns a #DIV/0! error."
8069
#: ../plugins/fn-stat/functions.c:1705
8214
#: ../plugins/fn-stat/functions.c:1690
8070
8215
msgid "STANDARDIZE:z-score of a value"
8073
#: ../plugins/fn-stat/functions.c:1707
8218
#: ../plugins/fn-stat/functions.c:1692
8074
8219
msgid "mean:mean of the original distribution"
8077
#: ../plugins/fn-stat/functions.c:1708
8222
#: ../plugins/fn-stat/functions.c:1693
8078
8223
msgid "stddev:standard deviation of the original distribution"
8081
#: ../plugins/fn-stat/functions.c:1709 ../plugins/fn-stat/functions.c:1773
8226
#: ../plugins/fn-stat/functions.c:1694 ../plugins/fn-stat/functions.c:1758
8082
8227
msgid "If @{stddev} is 0 this function returns a #DIV/0! error."
8085
#: ../plugins/fn-stat/functions.c:1732
8230
#: ../plugins/fn-stat/functions.c:1717
8087
"WEIBULL:(cumulative) probability density function of the Weibull distribution"
8232
"WEIBULL:probability density or cumulative distribution function of the "
8233
"Weibull distribution"
8090
#: ../plugins/fn-stat/functions.c:1737
8236
#: ../plugins/fn-stat/functions.c:1722
8092
8238
"If the @{cumulative} boolean is true it will return: 1 - exp (-(@{x}/@{beta})"
8093
8239
"^@{alpha}),otherwise it will return (@{alpha}/@{beta}^@{alpha}) * @{x}^(@"
8094
8240
"{alpha}-1) * exp(-(@{x}/@{beta}^@{alpha}))."
8097
#: ../plugins/fn-stat/functions.c:1768
8243
#: ../plugins/fn-stat/functions.c:1753
8099
"NORMDIST:(cumulative) probability density function of a normal distribution"
8245
"NORMDIST:probability density or cumulative distribution function of a normal "
8102
#: ../plugins/fn-stat/functions.c:1770 ../plugins/fn-stat/functions.c:1803
8103
#: ../plugins/fn-stat/functions.c:1966
8249
#: ../plugins/fn-stat/functions.c:1755 ../plugins/fn-stat/functions.c:1788
8250
#: ../plugins/fn-stat/functions.c:1951
8104
8251
msgid "mean:mean of the distribution"
8107
#: ../plugins/fn-stat/functions.c:1771 ../plugins/fn-stat/functions.c:1804
8254
#: ../plugins/fn-stat/functions.c:1756 ../plugins/fn-stat/functions.c:1789
8108
8255
msgid "stddev:standard deviation of the distribution"
8111
#: ../plugins/fn-stat/functions.c:1801
8258
#: ../plugins/fn-stat/functions.c:1786
8113
8260
"NORMINV:inverse of the cumulative distribution function of a normal "
8117
#: ../plugins/fn-stat/functions.c:1805
8264
#: ../plugins/fn-stat/functions.c:1790
8119
8266
"If @{p} < 0 or @{p} > 1 or @{stddev} <= 0 this function returns a #NUM! "
8123
#: ../plugins/fn-stat/functions.c:1829
8124
msgid "KURT:unbiased estimate of the kurtosis of a data set."
8270
#: ../plugins/fn-stat/functions.c:1814
8271
msgid "KURT:unbiased estimate of the kurtosis of a data set"
8127
#: ../plugins/fn-stat/functions.c:1833
8274
#: ../plugins/fn-stat/functions.c:1818
8129
8276
"This is only meaningful if the underlying distribution really has a fourth "
8130
8277
"moment. The kurtosis is offset by three such that a normal distribution "
8131
8278
"will have zero kurtosis."
8134
#: ../plugins/fn-stat/functions.c:1837
8281
#: ../plugins/fn-stat/functions.c:1822
8136
8283
"If fewer than four numbers are given or all of them are equal this function "
8137
8284
"returns a #DIV/0! error."
8140
#: ../plugins/fn-stat/functions.c:1841
8287
#: ../plugins/fn-stat/functions.c:1826
8141
8288
msgid "Then KURT(A1:A5) equals 1.234546305."
8144
#: ../plugins/fn-stat/functions.c:1860
8291
#: ../plugins/fn-stat/functions.c:1845
8145
8292
msgid "KURTP:population kurtosis of a data set"
8148
#: ../plugins/fn-stat/functions.c:1864
8295
#: ../plugins/fn-stat/functions.c:1849
8150
8297
"If fewer than two numbers are given or all of them are equal this function "
8151
8298
"returns a #DIV/0! error."
8154
#: ../plugins/fn-stat/functions.c:1867
8301
#: ../plugins/fn-stat/functions.c:1852
8155
8302
msgid "Then KURTP(A1:A5) equals -0.691363424."
8158
#: ../plugins/fn-stat/functions.c:1886
8305
#: ../plugins/fn-stat/functions.c:1871
8159
8306
msgid "AVEDEV:average of the absolute deviations of a data set"
8162
#: ../plugins/fn-stat/functions.c:1891
8309
#: ../plugins/fn-stat/functions.c:1876
8163
8310
msgid "Then AVEDEV(A1:A5) equals 7.84."
8166
#: ../plugins/fn-stat/functions.c:1910
8313
#: ../plugins/fn-stat/functions.c:1895
8167
8314
msgid "DEVSQ:sum of squares of deviations of a data set"
8170
#: ../plugins/fn-stat/functions.c:1916
8317
#: ../plugins/fn-stat/functions.c:1901
8171
8318
msgid "Then DEVSQ(A1:A5) equals 470.56."
8174
#: ../plugins/fn-stat/functions.c:1935
8321
#: ../plugins/fn-stat/functions.c:1920
8175
8322
msgid "FISHER:Fisher transformation"
8178
#: ../plugins/fn-stat/functions.c:1937
8325
#: ../plugins/fn-stat/functions.c:1922
8179
8326
msgid "If @{x} is not a number, this function returns a #VALUE! error."
8182
#: ../plugins/fn-stat/functions.c:1938
8329
#: ../plugins/fn-stat/functions.c:1923
8183
8330
msgid "If @{x} <= -1 or @{x} >= 1, this function returns a #NUM! error."
8186
#: ../plugins/fn-stat/functions.c:1964
8333
#: ../plugins/fn-stat/functions.c:1949
8188
"POISSON:(cumulative) probability mass function of the Poisson distribution"
8335
"POISSON:probability mass or cumulative distribution function of the Poisson "
8191
#: ../plugins/fn-stat/functions.c:1965
8339
#: ../plugins/fn-stat/functions.c:1950
8192
8340
msgid "x:number of events"
8195
#: ../plugins/fn-stat/functions.c:1968
8343
#: ../plugins/fn-stat/functions.c:1953
8196
8344
msgid "If @{x} is a non-integer it is truncated."
8199
#: ../plugins/fn-stat/functions.c:1970
8347
#: ../plugins/fn-stat/functions.c:1955
8200
8348
msgid "If @{mean} <= 0 POISSON returns the #NUM! error."
8203
#: ../plugins/fn-stat/functions.c:1996
8351
#: ../plugins/fn-stat/functions.c:1981
8204
8352
msgid "PEARSON:Pearson correlation coefficient of the paired set of data"
8207
#: ../plugins/fn-stat/functions.c:1997 ../plugins/fn-stat/functions.c:2016
8355
#: ../plugins/fn-stat/functions.c:1982 ../plugins/fn-stat/functions.c:2001
8208
8356
msgid "array1:first component values"
8211
#: ../plugins/fn-stat/functions.c:1998 ../plugins/fn-stat/functions.c:2017
8359
#: ../plugins/fn-stat/functions.c:1983 ../plugins/fn-stat/functions.c:2002
8212
8360
msgid "array2:second component values"
8215
#: ../plugins/fn-stat/functions.c:2015
8363
#: ../plugins/fn-stat/functions.c:2000
8217
8365
"RSQ:square of the Pearson correlation coefficient of the paired set of data"
8220
#: ../plugins/fn-stat/functions.c:2039
8368
#: ../plugins/fn-stat/functions.c:2024
8221
8369
msgid "MEDIAN:median of a data set"
8224
#: ../plugins/fn-stat/functions.c:2043
8372
#: ../plugins/fn-stat/functions.c:2028
8226
8374
"If even numbers are given MEDIAN returns the average of the two numbers in "
8230
#: ../plugins/fn-stat/functions.c:2047
8378
#: ../plugins/fn-stat/functions.c:2032
8231
8379
msgid "Then MEDIAN(A1:A5) equals 21.3."
8234
#: ../plugins/fn-stat/functions.c:2049
8382
#: ../plugins/fn-stat/functions.c:2034
8235
8383
msgid "wiki:en:Median"
8238
#: ../plugins/fn-stat/functions.c:2050
8386
#: ../plugins/fn-stat/functions.c:2035
8239
8387
msgid "wolfram:StatisticalMedian.html"
8242
#: ../plugins/fn-stat/functions.c:2069
8390
#: ../plugins/fn-stat/functions.c:2054
8244
8392
"SSMEDIAN:median for grouped data as commonly determined in the social "
8248
#: ../plugins/fn-stat/functions.c:2070
8396
#: ../plugins/fn-stat/functions.c:2055
8249
8397
msgid "array:data set"
8252
#: ../plugins/fn-stat/functions.c:2071
8400
#: ../plugins/fn-stat/functions.c:2056
8253
8401
msgid "interval:length of each grouping interval, defaults to 1"
8256
#: ../plugins/fn-stat/functions.c:2072
8404
#: ../plugins/fn-stat/functions.c:2057
8258
8406
"The data points given in @{array} are assumed to be the result of grouping "
8259
8407
"data into intervals of length @{interval}"
8262
#: ../plugins/fn-stat/functions.c:2074 ../plugins/fn-stat/functions.c:2867
8263
#: ../plugins/fn-stat/functions.c:2910
8410
#: ../plugins/fn-stat/functions.c:2059 ../plugins/fn-stat/functions.c:2731
8411
#: ../plugins/fn-stat/functions.c:2773
8264
8412
msgid "If @{array} is empty, this function returns a #NUM! error."
8267
#: ../plugins/fn-stat/functions.c:2075
8415
#: ../plugins/fn-stat/functions.c:2060
8269
8417
"If @{interval} <= 0, this function returns a #NUM! error.SSMEDIAN does not "
8270
8418
"check whether the data points are at least @{interval} apart."
8273
#: ../plugins/fn-stat/functions.c:2078
8421
#: ../plugins/fn-stat/functions.c:2063
8274
8422
msgid "Let us assume that the cells A1, A2, A3 contain numbers 7, 8, 8."
8277
#: ../plugins/fn-stat/functions.c:2079
8425
#: ../plugins/fn-stat/functions.c:2064
8278
8426
msgid "Then SSMEDIAN(A1:A3, 1) equals 7.75."
8281
#: ../plugins/fn-stat/functions.c:2161
8429
#: ../plugins/fn-stat/functions.c:2146
8282
8430
msgid "LARGE:@{k}-th largest value in a data set"
8285
#: ../plugins/fn-stat/functions.c:2162 ../plugins/fn-stat/functions.c:2205
8433
#: ../plugins/fn-stat/functions.c:2147 ../plugins/fn-stat/functions.c:2190
8286
8434
msgid "data:data set"
8289
#: ../plugins/fn-stat/functions.c:2163 ../plugins/fn-stat/functions.c:2206
8437
#: ../plugins/fn-stat/functions.c:2148 ../plugins/fn-stat/functions.c:2191
8290
8438
msgid "k:which value to find"
8293
#: ../plugins/fn-stat/functions.c:2164 ../plugins/fn-stat/functions.c:2207
8441
#: ../plugins/fn-stat/functions.c:2149 ../plugins/fn-stat/functions.c:2192
8294
8442
msgid "If data set is empty this function returns a #NUM! error."
8297
#: ../plugins/fn-stat/functions.c:2165 ../plugins/fn-stat/functions.c:2208
8445
#: ../plugins/fn-stat/functions.c:2150 ../plugins/fn-stat/functions.c:2193
8299
8447
"If @{k} <= 0 or @{k} is greater than the number of data items given this "
8300
8448
"function returns a #NUM! error."
8303
#: ../plugins/fn-stat/functions.c:2170
8451
#: ../plugins/fn-stat/functions.c:2155
8304
8452
msgid "Then LARGE(A1:A5,2) equals 25.9.LARGE(A1:A5,4) equals 17.3."
8307
#: ../plugins/fn-stat/functions.c:2204
8308
msgid "SMALL: @{k}-th smallest value in a data set."
8455
#: ../plugins/fn-stat/functions.c:2189
8456
msgid "SMALL:@{k}-th smallest value in a data set"
8311
#: ../plugins/fn-stat/functions.c:2213
8459
#: ../plugins/fn-stat/functions.c:2198
8312
8460
msgid "Then SMALL(A1:A5,2) equals 17.3.SMALL(A1:A5,4) equals 25.9."
8315
#: ../plugins/fn-stat/functions.c:2273
8463
#: ../plugins/fn-stat/functions.c:2233
8317
8465
"PROB:probability of an interval for a discrete (and finite) probability "
8321
#: ../plugins/fn-stat/functions.c:2274
8469
#: ../plugins/fn-stat/functions.c:2234
8322
8470
msgid "x_range:possible values"
8325
#: ../plugins/fn-stat/functions.c:2275
8473
#: ../plugins/fn-stat/functions.c:2235
8326
8474
msgid "prob_range:probabilities of the corresponding values"
8329
#: ../plugins/fn-stat/functions.c:2276
8477
#: ../plugins/fn-stat/functions.c:2236
8330
8478
msgid "lower_limit:lower interval limit"
8333
#: ../plugins/fn-stat/functions.c:2277
8481
#: ../plugins/fn-stat/functions.c:2237
8334
8482
msgid "upper_limit:upper interval limit, defaults to @{lower_limit}"
8337
#: ../plugins/fn-stat/functions.c:2278
8485
#: ../plugins/fn-stat/functions.c:2238
8339
8487
"If the sum of the probabilities in @{prob_range} is not equal to 1 this "
8340
8488
"function returns a #NUM! error."
8343
#: ../plugins/fn-stat/functions.c:2280
8491
#: ../plugins/fn-stat/functions.c:2240
8345
8493
"If any value in @{prob_range} is <=0 or > 1, this function returns a #NUM! "
8349
#: ../plugins/fn-stat/functions.c:2282
8497
#: ../plugins/fn-stat/functions.c:2242
8351
8499
"If @{x_range} and @{prob_range} contain a different number of data entries, "
8352
8500
"this function returns a #N/A error."
8355
#: ../plugins/fn-stat/functions.c:2359
8503
#: ../plugins/fn-stat/functions.c:2319
8356
8504
msgid "STEYX:standard error of the predicted y-value in the regression"
8359
#: ../plugins/fn-stat/functions.c:2360 ../plugins/fn-stat/functions.c:3515
8360
#: ../plugins/fn-stat/functions.c:3780 ../plugins/fn-stat/functions.c:3875
8361
#: ../plugins/fn-stat/functions.c:3987 ../plugins/fn-stat/functions.c:4227
8362
#: ../plugins/fn-stat/functions.c:4346 ../plugins/fn-stat/functions.c:4418
8363
#: ../plugins/fn-stat/functions.c:4473
8364
msgid "known_y's:known y-values"
8367
#: ../plugins/fn-stat/functions.c:2361 ../plugins/fn-stat/functions.c:3781
8368
#: ../plugins/fn-stat/functions.c:4347 ../plugins/fn-stat/functions.c:4419
8369
#: ../plugins/fn-stat/functions.c:4474
8370
msgid "known_x's:known x-values"
8373
#: ../plugins/fn-stat/functions.c:2362
8507
#: ../plugins/fn-stat/functions.c:2320 ../plugins/fn-stat/functions.c:3365
8508
#: ../plugins/fn-stat/functions.c:3481 ../plugins/fn-stat/functions.c:3723
8509
#: ../plugins/fn-stat/functions.c:3821 ../plugins/fn-stat/functions.c:3908
8510
#: ../plugins/fn-stat/functions.c:3967 ../plugins/fn-stat/functions.c:4019
8511
msgid "known_ys:known y-values"
8514
#: ../plugins/fn-stat/functions.c:2321 ../plugins/fn-stat/functions.c:3482
8515
#: ../plugins/fn-stat/functions.c:3909 ../plugins/fn-stat/functions.c:3968
8516
#: ../plugins/fn-stat/functions.c:4020
8517
msgid "known_xs:known x-values"
8520
#: ../plugins/fn-stat/functions.c:2322
8375
"If @{known_y}'s and @{known_x}'s are empty or have a different number of "
8522
"If @{known_ys} and @{known_xs} are empty or have a different number of "
8376
8523
"arguments then this function returns a #N/A error."
8379
#: ../plugins/fn-stat/functions.c:2368
8526
#: ../plugins/fn-stat/functions.c:2328
8380
8527
msgid "Then STEYX(A1:A5,B1:B5) equals 1.101509979."
8383
#: ../plugins/fn-stat/functions.c:2508
8530
#: ../plugins/fn-stat/functions.c:2372
8385
8532
"ZTEST:the probability of observing a sample mean as large as or larger than "
8386
8533
"the mean of the given sample"
8389
#: ../plugins/fn-stat/functions.c:2510
8536
#: ../plugins/fn-stat/functions.c:2374
8390
8537
msgid "ref:data set (sample)"
8393
#: ../plugins/fn-stat/functions.c:2511
8540
#: ../plugins/fn-stat/functions.c:2375
8394
8541
msgid "x:population mean"
8397
#: ../plugins/fn-stat/functions.c:2512
8544
#: ../plugins/fn-stat/functions.c:2376
8399
8546
"stddev:population standard deviation, defaults to the sample standard "
8403
#: ../plugins/fn-stat/functions.c:2513
8550
#: ../plugins/fn-stat/functions.c:2377
8405
8552
"ZTEST calulates the probability of observing a sample mean as large as or "
8406
8553
"larger than the mean of the given sample for samples drawn from a normal "
8407
8554
"distribution with mean @{x} and standard deviation @{stddev}."
8410
#: ../plugins/fn-stat/functions.c:2516
8557
#: ../plugins/fn-stat/functions.c:2380
8412
8559
"If @{ref} contains less than two data items ZTEST returns #DIV/0! error."
8415
#: ../plugins/fn-stat/functions.c:2522
8562
#: ../plugins/fn-stat/functions.c:2386
8416
8563
msgid "Then ZTEST(A1:A5,20) equals 0.254717826."
8419
#: ../plugins/fn-stat/functions.c:2573
8566
#: ../plugins/fn-stat/functions.c:2437
8420
8567
msgid "AVERAGEA:average of all the values and cells"
8423
#: ../plugins/fn-stat/functions.c:2578 ../plugins/fn-stat/functions.c:2603
8424
#: ../plugins/fn-stat/functions.c:2630 ../plugins/fn-stat/functions.c:2662
8425
#: ../plugins/fn-stat/functions.c:2689 ../plugins/fn-stat/functions.c:2719
8426
#: ../plugins/fn-stat/functions.c:2746
8570
#: ../plugins/fn-stat/functions.c:2442 ../plugins/fn-stat/functions.c:2467
8571
#: ../plugins/fn-stat/functions.c:2494 ../plugins/fn-stat/functions.c:2526
8572
#: ../plugins/fn-stat/functions.c:2553 ../plugins/fn-stat/functions.c:2583
8573
#: ../plugins/fn-stat/functions.c:2610
8428
8575
"Let us assume that the cells A1, A2, ..., A5 contain numbers and strings "
8429
8576
"11.4, 17.3, \"missing\", 25.9, and 40.1."
8432
#: ../plugins/fn-stat/functions.c:2579
8579
#: ../plugins/fn-stat/functions.c:2443
8433
8580
msgid "Then AVERAGEA(A1:A5) equals 18.94."
8436
#: ../plugins/fn-stat/functions.c:2598
8583
#: ../plugins/fn-stat/functions.c:2462
8438
8585
"MAXA:largest value, with negative numbers considered smaller than positive "
8442
#: ../plugins/fn-stat/functions.c:2605
8589
#: ../plugins/fn-stat/functions.c:2469
8443
8590
msgid "Then MAXA(A1:A5) equals 40.1."
8446
#: ../plugins/fn-stat/functions.c:2625
8593
#: ../plugins/fn-stat/functions.c:2489
8448
8595
"MINA:smallest value, with negative numbers considered smaller than positive "
8452
#: ../plugins/fn-stat/functions.c:2632
8599
#: ../plugins/fn-stat/functions.c:2496
8453
8600
msgid "Then MINA(A1:A5) equals 0."
8456
#: ../plugins/fn-stat/functions.c:2652
8603
#: ../plugins/fn-stat/functions.c:2516
8457
8604
msgid "VARA:sample variance of the given sample"
8460
#: ../plugins/fn-stat/functions.c:2655
8607
#: ../plugins/fn-stat/functions.c:2519
8461
8608
msgid "VARA is also known as the N-1-variance."
8464
#: ../plugins/fn-stat/functions.c:2656
8611
#: ../plugins/fn-stat/functions.c:2520
8465
8612
msgid "To get the true variance of a complete population use VARPA."
8468
#: ../plugins/fn-stat/functions.c:2664
8615
#: ../plugins/fn-stat/functions.c:2528
8469
8616
msgid "Then VARA(A1:A5) equals 228.613."
8472
#: ../plugins/fn-stat/functions.c:2683
8619
#: ../plugins/fn-stat/functions.c:2547
8473
8620
msgid "VARPA:variance of an entire population"
8476
#: ../plugins/fn-stat/functions.c:2686
8623
#: ../plugins/fn-stat/functions.c:2550
8477
8624
msgid "VARPA is also known as the N-variance."
8480
#: ../plugins/fn-stat/functions.c:2691
8627
#: ../plugins/fn-stat/functions.c:2555
8481
8628
msgid "Then VARPA(A1:A5) equals 182.8904."
8484
#: ../plugins/fn-stat/functions.c:2710
8485
msgid "STDEVA:sample standard deviation of the given sample."
8631
#: ../plugins/fn-stat/functions.c:2574
8632
msgid "STDEVA:sample standard deviation of the given sample"
8488
#: ../plugins/fn-stat/functions.c:2714
8635
#: ../plugins/fn-stat/functions.c:2578
8489
8636
msgid "STDEVA is also known as the N-1-standard deviation."
8492
#: ../plugins/fn-stat/functions.c:2715
8639
#: ../plugins/fn-stat/functions.c:2579
8494
8641
"To obtain the population standard deviation of a whole population use "
8498
#: ../plugins/fn-stat/functions.c:2721
8645
#: ../plugins/fn-stat/functions.c:2585
8499
8646
msgid "Then STDEVA(A1:A5) equals 15.119953704."
8502
#: ../plugins/fn-stat/functions.c:2740
8503
msgid "STDEVPA:population standard deviation of an entire population."
8649
#: ../plugins/fn-stat/functions.c:2604
8650
msgid "STDEVPA:population standard deviation of an entire population"
8506
#: ../plugins/fn-stat/functions.c:2748
8653
#: ../plugins/fn-stat/functions.c:2612
8507
8654
msgid "Then STDEVPA(A1:A5) equals 13.523697719."
8510
#: ../plugins/fn-stat/functions.c:2767
8511
msgid "PERCENTRANK:rank of a data point in a data set."
8657
#: ../plugins/fn-stat/functions.c:2631
8658
msgid "PERCENTRANK:rank of a data point in a data set"
8514
#: ../plugins/fn-stat/functions.c:2768
8661
#: ../plugins/fn-stat/functions.c:2632
8515
8662
msgid "array:range of numeric values"
8518
#: ../plugins/fn-stat/functions.c:2769
8665
#: ../plugins/fn-stat/functions.c:2633
8519
8666
msgid "x:data point to be ranked"
8522
#: ../plugins/fn-stat/functions.c:2770
8669
#: ../plugins/fn-stat/functions.c:2634
8523
8670
msgid "significance:number of significant digits, defaults to 3"
8526
#: ../plugins/fn-stat/functions.c:2771
8673
#: ../plugins/fn-stat/functions.c:2635
8528
8675
"If @{array} contains no data points, this function returns a #NUM! error."
8531
#: ../plugins/fn-stat/functions.c:2773
8678
#: ../plugins/fn-stat/functions.c:2637
8533
8680
"If @{significance} is less than one, this function returns a #NUM! error."
8536
#: ../plugins/fn-stat/functions.c:2775
8683
#: ../plugins/fn-stat/functions.c:2639
8538
8685
"If @{x} exceeds the largest value or is less than the smallest value in @"
8539
8686
"{array}, this function returns a #NUM! error."
8542
#: ../plugins/fn-stat/functions.c:2777
8689
#: ../plugins/fn-stat/functions.c:2641
8544
8691
"If @{x} does not match any of the values in @{array} or @{x} matches more "
8545
8692
"than once, this function interpolates the returned value."
8548
#: ../plugins/fn-stat/functions.c:2864
8695
#: ../plugins/fn-stat/functions.c:2728
8550
8697
"PERCENTILE:determines the 100*@{k}-th percentile of the given data points"
8553
#: ../plugins/fn-stat/functions.c:2865 ../plugins/fn-stat/functions.c:2907
8700
#: ../plugins/fn-stat/functions.c:2729 ../plugins/fn-stat/functions.c:2771
8554
8701
msgid "array:data points"
8557
#: ../plugins/fn-stat/functions.c:2866
8704
#: ../plugins/fn-stat/functions.c:2730
8558
8705
msgid "k:which percentile to calculate"
8561
#: ../plugins/fn-stat/functions.c:2868
8708
#: ../plugins/fn-stat/functions.c:2732
8562
8709
msgid "If @{k} < 0 or @{k} > 1, this function returns a #NUM! error."
8565
#: ../plugins/fn-stat/functions.c:2871
8712
#: ../plugins/fn-stat/functions.c:2735
8566
8713
msgid "Then PERCENTILE(A1:A5,0.42) equals 20.02."
8569
#: ../plugins/fn-stat/functions.c:2906
8716
#: ../plugins/fn-stat/functions.c:2770
8570
8717
msgid "QUARTILE:the @{k}-th quartile of the data points"
8573
#: ../plugins/fn-stat/functions.c:2908
8720
#: ../plugins/fn-stat/functions.c:2772
8721
msgid "quart:a number from 0 to 4, indicating which quartile to calculate"
8724
#: ../plugins/fn-stat/functions.c:2774
8575
"quart:A number from 0 to 4, indicating which quartile to calculate. A value "
8576
"of 0 causes the smallest value of @{array} to be returned."
8579
#: ../plugins/fn-stat/functions.c:2911
8580
msgid "If @{quart} < 0 or @{quart} > 4, this function returns a #NUM! error."
8583
#: ../plugins/fn-stat/functions.c:2912
8726
"If @{quart} < 0 or @{quart} > 4, this function returns a #NUM! error. If @"
8727
"{quart} = 0, the smallest value of @{array} to be returned."
8730
#: ../plugins/fn-stat/functions.c:2775
8584
8731
msgid "If @{quart} is not an integer, it is truncated."
8587
#: ../plugins/fn-stat/functions.c:2915
8734
#: ../plugins/fn-stat/functions.c:2778
8588
8735
msgid "Then QUARTILE(A1:A5,1) equals 17.3."
8591
#: ../plugins/fn-stat/functions.c:2950
8738
#: ../plugins/fn-stat/functions.c:2813
8593
8740
"FTEST:p-value for the two-tailed hypothesis test comparing the variances of "
8594
8741
"two populations"
8597
#: ../plugins/fn-stat/functions.c:2952 ../plugins/fn-stat/functions.c:3009
8744
#: ../plugins/fn-stat/functions.c:2815 ../plugins/fn-stat/functions.c:2872
8598
8745
msgid "array1:sample from the first population"
8601
#: ../plugins/fn-stat/functions.c:2953 ../plugins/fn-stat/functions.c:3010
8748
#: ../plugins/fn-stat/functions.c:2816 ../plugins/fn-stat/functions.c:2873
8602
8749
msgid "array2:sample from the second population"
8605
#: ../plugins/fn-stat/functions.c:2958
8752
#: ../plugins/fn-stat/functions.c:2821
8606
8753
msgid "Then FTEST(A1:A5,B1:B5) equals 0.510815017."
8609
#: ../plugins/fn-stat/functions.c:3007
8756
#: ../plugins/fn-stat/functions.c:2870
8611
8758
"TTEST:p-value for a hypothesis test comparing the means of two populations "
8612
8759
"using the Student t-distribution"
8615
#: ../plugins/fn-stat/functions.c:3011
8762
#: ../plugins/fn-stat/functions.c:2874
8616
8763
msgid "tails:number of tails to consider"
8619
#: ../plugins/fn-stat/functions.c:3012
8766
#: ../plugins/fn-stat/functions.c:2875
8621
8768
"type:Type of test to perform. 1 indicates a test for paired variables, 2 a "
8622
8769
"test of unpaired variables with equal variances, and 3 a test of unpaired "
8623
8770
"variables with unequal variances"
8626
#: ../plugins/fn-stat/functions.c:3015
8773
#: ../plugins/fn-stat/functions.c:2878
8628
8775
"If the data sets contain a different number of data points and the test is "
8629
8776
"paired (@{type} one), TTEST returns the #N/A error."
8632
#: ../plugins/fn-stat/functions.c:3017
8779
#: ../plugins/fn-stat/functions.c:2880
8633
8780
msgid "@{tails} and @{type} are truncated to integers."
8636
#: ../plugins/fn-stat/functions.c:3018
8783
#: ../plugins/fn-stat/functions.c:2881
8637
8784
msgid "If @{tails} is not one or two, this function returns a #NUM! error."
8640
#: ../plugins/fn-stat/functions.c:3019
8787
#: ../plugins/fn-stat/functions.c:2882
8642
8789
"If @{type} is any other than one, two, or three, this function returns a "
8646
#: ../plugins/fn-stat/functions.c:3024
8793
#: ../plugins/fn-stat/functions.c:2887
8648
8795
"Then TTEST(A1:A5,B1:B5,1,1) equals 0.003127619.TTEST(A1:A5,B1:B5,2,1) equals "
8649
8796
"0.006255239.TTEST(A1:A5,B1:B5,1,2) equals 0.111804322.TTEST(A1:A5,B1:B5,1,3) "
8650
8797
"equals 0.113821797."
8653
#: ../plugins/fn-stat/functions.c:3179
8654
msgid "FREQUENCY:the frequency table"
8800
#: ../plugins/fn-stat/functions.c:3045
8801
msgid "FREQUENCY:frequency table"
8657
#: ../plugins/fn-stat/functions.c:3180
8804
#: ../plugins/fn-stat/functions.c:3046
8658
8805
msgid "data_array:data values"
8661
#: ../plugins/fn-stat/functions.c:3181
8808
#: ../plugins/fn-stat/functions.c:3047
8662
8809
msgid "bins_array:array of cutoff values"
8665
#: ../plugins/fn-stat/functions.c:3182
8812
#: ../plugins/fn-stat/functions.c:3048
8666
8813
msgid "The results are given as an array."
8669
#: ../plugins/fn-stat/functions.c:3183
8816
#: ../plugins/fn-stat/functions.c:3049
8671
"If the @{bin_array} is empty, this function returns the number of data "
8818
"If the @{bins_array} is empty, this function returns the number of data "
8672
8819
"points in @{data_array}."
8675
#: ../plugins/fn-stat/functions.c:3247
8677
"LINEST:determines multiple linear regression coefficients and statistics."
8680
#: ../plugins/fn-stat/functions.c:3248
8681
msgid "known_y's:vector of values of dependent variable."
8684
#: ../plugins/fn-stat/functions.c:3249
8686
"known_x's:array of values of independent variables, defaults to a single "
8690
#: ../plugins/fn-stat/functions.c:3250
8691
msgid "affine:if true, the model contains a constant term, defaults to true."
8694
#: ../plugins/fn-stat/functions.c:3251
8822
#: ../plugins/fn-stat/functions.c:3267
8823
msgid "LINEST:multiple linear regression coefficients and statistics"
8826
#: ../plugins/fn-stat/functions.c:3268 ../plugins/fn-stat/functions.c:3576
8827
msgid "known_ys:vector of values of dependent variable"
8830
#: ../plugins/fn-stat/functions.c:3269 ../plugins/fn-stat/functions.c:3577
8832
"known_xs:array of values of independent variables, defaults to a single "
8836
#: ../plugins/fn-stat/functions.c:3270 ../plugins/fn-stat/functions.c:3367
8837
#: ../plugins/fn-stat/functions.c:3579 ../plugins/fn-stat/functions.c:3725
8838
#: ../plugins/fn-stat/functions.c:3824
8839
msgid "affine:if true, the model contains a constant term, defaults to true"
8842
#: ../plugins/fn-stat/functions.c:3271
8696
8844
"stats:if true, some additional statistics are provided, defaults to false"
8699
#: ../plugins/fn-stat/functions.c:3252
8847
#: ../plugins/fn-stat/functions.c:3272
8701
8849
"This function returns an array with the first row giving the regression "
8702
"coefficients for the independent variables x_m, x_(m-1),...,x_2, x_1 "
8703
"followed by the y-intercept if @{affine} is true."
8850
"coefficients for the independent variables x_m, x_(m-1),…,x_2, x_1 followed "
8851
"by the y-intercept if @{affine} is true."
8706
#: ../plugins/fn-stat/functions.c:3255
8854
#: ../plugins/fn-stat/functions.c:3275
8708
8856
"If @{stats} is true, the second row contains the corresponding standard "
8709
8857
"errors of the regression coefficients.In this case, the third row contains "
9212
9343
msgid "@{x} must be in the range 1 to 255."
9215
#: ../plugins/fn-string/functions.c:60 ../plugins/fn-string/functions.c:133
9346
#: ../plugins/fn-string/functions.c:60 ../plugins/fn-string/functions.c:136
9217
9348
"CP1252 (Windows-1252) is also known as the \"ANSI code page\", but it is not "
9218
9349
"an ANSI standard."
9221
#: ../plugins/fn-string/functions.c:62 ../plugins/fn-string/functions.c:134
9352
#: ../plugins/fn-string/functions.c:62
9223
9354
"CP1252 (Windows-1252) is based on an early draft of ISO-8859-1, and contains "
9224
"all of its printable characters (but partially at different positions.)"
9355
"all of its printable characters. It also contains all of ISO-8859-15's "
9356
"printable characters (but partially at different positions.)"
9227
#: ../plugins/fn-string/functions.c:64 ../plugins/fn-string/functions.c:135
9359
#: ../plugins/fn-string/functions.c:66 ../plugins/fn-string/functions.c:138
9229
9361
"In CP1252 (Windows-1252), 129, 141, 143, 144, and 157 do not have matching "
9233
#: ../plugins/fn-string/functions.c:65 ../plugins/fn-string/functions.c:136
9365
#: ../plugins/fn-string/functions.c:67 ../plugins/fn-string/functions.c:139
9235
9367
"For @{x} from 1 to 255 except 129, 141, 143, 144, and 157 we have CODE(CHAR(@"
9239
#: ../plugins/fn-string/functions.c:103
9371
#: ../plugins/fn-string/functions.c:105
9241
"UNICHAR:the Unicode character represented by the Unicode code point @{x}."
9373
"UNICHAR:the Unicode character represented by the Unicode code point @{x}"
9244
#: ../plugins/fn-string/functions.c:104
9376
#: ../plugins/fn-string/functions.c:106
9245
9377
msgid "x:Unicode code point"
9248
#: ../plugins/fn-string/functions.c:130
9380
#: ../plugins/fn-string/functions.c:133
9249
9381
msgid "CODE:the CP1252 (Windows-1252) code point for the character @{c}"
9252
#: ../plugins/fn-string/functions.c:131 ../plugins/fn-string/functions.c:176
9384
#: ../plugins/fn-string/functions.c:134 ../plugins/fn-string/functions.c:179
9253
9385
msgid "c:character"
9256
#: ../plugins/fn-string/functions.c:132
9388
#: ../plugins/fn-string/functions.c:135
9257
9389
msgid "@{c} must be a valid CP1252 (Windows-1252) character."
9260
#: ../plugins/fn-string/functions.c:175
9392
#: ../plugins/fn-string/functions.c:137
9394
"CP1252 (Windows-1252) is based on an early draft of ISO-8859-1, and contains "
9395
"all of its printable characters (but partially at different positions.)"
9398
#: ../plugins/fn-string/functions.c:178
9261
9399
msgid "UNICODE:the Unicode code point for the character @{c}"
9264
#: ../plugins/fn-string/functions.c:196
9402
#: ../plugins/fn-string/functions.c:199
9265
9403
msgid "EXACT:TRUE if @{string1} is exactly equal to @{string2}"
9268
#: ../plugins/fn-string/functions.c:197
9406
#: ../plugins/fn-string/functions.c:200
9269
9407
msgid "string1:first string"
9272
#: ../plugins/fn-string/functions.c:198
9410
#: ../plugins/fn-string/functions.c:201
9273
9411
msgid "string2:second string"
9276
#: ../plugins/fn-string/functions.c:216
9414
#: ../plugins/fn-string/functions.c:219
9277
9415
msgid "LEN:the number of characters of the string @{s}"
9280
#: ../plugins/fn-string/functions.c:217 ../plugins/fn-string/functions.c:234
9281
#: ../plugins/fn-string/functions.c:252 ../plugins/fn-string/functions.c:284
9282
#: ../plugins/fn-string/functions.c:336 ../plugins/fn-string/functions.c:376
9283
#: ../plugins/fn-string/functions.c:463 ../plugins/fn-string/functions.c:499
9418
#: ../plugins/fn-string/functions.c:220 ../plugins/fn-string/functions.c:237
9419
#: ../plugins/fn-string/functions.c:255 ../plugins/fn-string/functions.c:287
9420
#: ../plugins/fn-string/functions.c:339 ../plugins/fn-string/functions.c:379
9421
#: ../plugins/fn-string/functions.c:466 ../plugins/fn-string/functions.c:502
9284
9422
msgid "s:the string"
9287
#: ../plugins/fn-string/functions.c:233
9425
#: ../plugins/fn-string/functions.c:236
9288
9426
msgid "LENB:the number of bytes in the string @{s}"
9291
#: ../plugins/fn-string/functions.c:251
9429
#: ../plugins/fn-string/functions.c:254
9292
9430
msgid "LEFT:the first @{num_chars} characters of the string @{s}"
9295
#: ../plugins/fn-string/functions.c:253 ../plugins/fn-string/functions.c:464
9433
#: ../plugins/fn-string/functions.c:256 ../plugins/fn-string/functions.c:467
9296
9434
msgid "num_chars:the number of characters to return (defaults to 1)"
9299
#: ../plugins/fn-string/functions.c:254
9437
#: ../plugins/fn-string/functions.c:257
9301
9439
"If the string @{s} is in a right-to-left script, the returned first "
9302
9440
"characters are from the right of the string."
9305
#: ../plugins/fn-string/functions.c:283
9443
#: ../plugins/fn-string/functions.c:286
9307
9445
"LEFTB:the first characters of the string @{s} comprising at most @"
9308
9446
"{num_bytes} bytes"
9311
#: ../plugins/fn-string/functions.c:285 ../plugins/fn-string/functions.c:378
9312
#: ../plugins/fn-string/functions.c:500
9449
#: ../plugins/fn-string/functions.c:288 ../plugins/fn-string/functions.c:381
9450
#: ../plugins/fn-string/functions.c:503
9313
9451
msgid "num_bytes:the maximum number of bytes to return (defaults to 1)"
9316
#: ../plugins/fn-string/functions.c:286 ../plugins/fn-string/functions.c:379
9317
#: ../plugins/fn-string/functions.c:501 ../plugins/fn-string/functions.c:844
9318
#: ../plugins/fn-string/functions.c:1335
9454
#: ../plugins/fn-string/functions.c:289 ../plugins/fn-string/functions.c:382
9455
#: ../plugins/fn-string/functions.c:504 ../plugins/fn-string/functions.c:849
9456
#: ../plugins/fn-string/functions.c:1340
9320
9458
"The semantics of this function is subject to change as various applications "
9321
9459
"implement it."
9324
#: ../plugins/fn-string/functions.c:287
9462
#: ../plugins/fn-string/functions.c:290
9326
9464
"If the string is in a right-to-left script, the returned first characters "
9327
9465
"are from the right of the string."
9330
#: ../plugins/fn-string/functions.c:288 ../plugins/fn-string/functions.c:380
9331
#: ../plugins/fn-string/functions.c:424 ../plugins/fn-string/functions.c:503
9332
#: ../plugins/fn-string/functions.c:845 ../plugins/fn-string/functions.c:1336
9468
#: ../plugins/fn-string/functions.c:291 ../plugins/fn-string/functions.c:383
9469
#: ../plugins/fn-string/functions.c:427 ../plugins/fn-string/functions.c:506
9470
#: ../plugins/fn-string/functions.c:850 ../plugins/fn-string/functions.c:1341
9334
9472
"While this function is syntactically Excel compatible, the differences in "
9335
9473
"the underlying text encoding will usually yield different results."
9338
#: ../plugins/fn-string/functions.c:289 ../plugins/fn-string/functions.c:382
9339
#: ../plugins/fn-string/functions.c:426 ../plugins/fn-string/functions.c:504
9340
#: ../plugins/fn-string/functions.c:847 ../plugins/fn-string/functions.c:1338
9476
#: ../plugins/fn-string/functions.c:292 ../plugins/fn-string/functions.c:385
9477
#: ../plugins/fn-string/functions.c:429 ../plugins/fn-string/functions.c:507
9478
#: ../plugins/fn-string/functions.c:852 ../plugins/fn-string/functions.c:1343
9342
9480
"While this function is OpenFormula compatible, most of its behavior is, at "
9343
9481
"this time, implementation specific."
9346
#: ../plugins/fn-string/functions.c:317
9347
msgid "LOWER:a lower-case version of the string @{text}."
9484
#: ../plugins/fn-string/functions.c:320
9485
msgid "LOWER:a lower-case version of the string @{text}"
9350
#: ../plugins/fn-string/functions.c:335
9488
#: ../plugins/fn-string/functions.c:338
9352
9490
"MID:the substring of the string @{s} starting at position @{position} "
9353
9491
"consisting of @{length} characters"
9356
#: ../plugins/fn-string/functions.c:337
9494
#: ../plugins/fn-string/functions.c:340
9357
9495
msgid "position:the starting position"
9360
#: ../plugins/fn-string/functions.c:338
9498
#: ../plugins/fn-string/functions.c:341
9361
9499
msgid "length:the number of characters to return"
9364
#: ../plugins/fn-string/functions.c:375
9502
#: ../plugins/fn-string/functions.c:378
9366
9504
"MIDB:the characters following the first @{start_pos} bytes comprising at "
9367
9505
"most @{num_bytes} bytes"
9370
#: ../plugins/fn-string/functions.c:377
9508
#: ../plugins/fn-string/functions.c:380
9371
9509
msgid "start_pos:the number of the byte with which to start (defaults to 1)"
9374
#: ../plugins/fn-string/functions.c:419
9512
#: ../plugins/fn-string/functions.c:422
9376
9514
"FINDB:first byte position of @{string1} in @{string2} following byte "
9377
9515
"position @{start}"
9380
#: ../plugins/fn-string/functions.c:420 ../plugins/fn-string/functions.c:648
9518
#: ../plugins/fn-string/functions.c:423 ../plugins/fn-string/functions.c:651
9381
9519
msgid "string1:search string"
9384
#: ../plugins/fn-string/functions.c:421 ../plugins/fn-string/functions.c:649
9522
#: ../plugins/fn-string/functions.c:424 ../plugins/fn-string/functions.c:652
9385
9523
msgid "string2:search field"
9388
#: ../plugins/fn-string/functions.c:422 ../plugins/fn-string/functions.c:1325
9526
#: ../plugins/fn-string/functions.c:425 ../plugins/fn-string/functions.c:1330
9389
9527
msgid "start:starting byte position, defaults to 1"
9392
#: ../plugins/fn-string/functions.c:423 ../plugins/fn-string/functions.c:651
9530
#: ../plugins/fn-string/functions.c:426 ../plugins/fn-string/functions.c:654
9393
9531
msgid "This search is case-sensitive."
9396
#: ../plugins/fn-string/functions.c:462
9534
#: ../plugins/fn-string/functions.c:465
9397
9535
msgid "RIGHT:the last @{num_chars} characters of the string @{s}"
9400
#: ../plugins/fn-string/functions.c:465 ../plugins/fn-string/functions.c:502
9538
#: ../plugins/fn-string/functions.c:468 ../plugins/fn-string/functions.c:505
9402
9540
"If the string @{s} is in a right-to-left script, the returned last "
9403
9541
"characters are from the left of the string."
9406
#: ../plugins/fn-string/functions.c:498
9544
#: ../plugins/fn-string/functions.c:501
9408
9546
"RIGHTB:the last characters of the string @{s} comprising at most @"
9409
9547
"{num_bytes} bytes"
9412
#: ../plugins/fn-string/functions.c:533
9413
msgid "UPPER:an upper-case version of the string @text."
9416
#: ../plugins/fn-string/functions.c:552
9417
msgid "CONCATENATE:the concatenation of the strings @{s1}, @{s2},..."
9420
#: ../plugins/fn-string/functions.c:553
9550
#: ../plugins/fn-string/functions.c:536
9551
msgid "UPPER:an upper-case version of the string @{text}"
9554
#: ../plugins/fn-string/functions.c:555
9555
msgid "CONCATENATE:the concatenation of the strings @{s1}, @{s2},…"
9558
#: ../plugins/fn-string/functions.c:556
9421
9559
msgid "s1:first string"
9424
#: ../plugins/fn-string/functions.c:554
9562
#: ../plugins/fn-string/functions.c:557
9425
9563
msgid "s2:second string"
9428
#: ../plugins/fn-string/functions.c:574
9566
#: ../plugins/fn-string/functions.c:577
9429
9567
msgid "REPT:@{num} repetitions of string @{text}"
9432
#: ../plugins/fn-string/functions.c:576
9570
#: ../plugins/fn-string/functions.c:579
9433
9571
msgid "num:non-negative integer"
9436
#: ../plugins/fn-string/functions.c:618
9574
#: ../plugins/fn-string/functions.c:621
9437
9575
msgid "CLEAN:@{text} with any non-printable characters removed"
9440
#: ../plugins/fn-string/functions.c:620
9578
#: ../plugins/fn-string/functions.c:623
9442
9580
"CLEAN removes non-printable characters from its argument leaving only "
9443
9581
"regular characters and white-space."
9446
#: ../plugins/fn-string/functions.c:647
9584
#: ../plugins/fn-string/functions.c:650
9448
9586
"FIND:first position of @{string1} in @{string2} following position @{start}"
9451
#: ../plugins/fn-string/functions.c:650 ../plugins/fn-string/functions.c:1256
9589
#: ../plugins/fn-string/functions.c:653 ../plugins/fn-string/functions.c:1261
9452
9590
msgid "start:starting position, defaults to 1"
9455
#: ../plugins/fn-string/functions.c:685
9593
#: ../plugins/fn-string/functions.c:688
9456
9594
msgid "FIXED:formatted string representation of @{num}"
9459
#: ../plugins/fn-string/functions.c:686 ../plugins/fn-string/functions.c:1181
9597
#: ../plugins/fn-string/functions.c:689 ../plugins/fn-string/functions.c:1186
9460
9598
msgid "num:number"
9463
#: ../plugins/fn-string/functions.c:687
9601
#: ../plugins/fn-string/functions.c:690
9464
9602
msgid "decimals:number of decimals"
9467
#: ../plugins/fn-string/functions.c:688
9605
#: ../plugins/fn-string/functions.c:691
9469
9607
"no_commas:TRUE if no thousand separators should be used, defaults to FALSE"
9472
#: ../plugins/fn-string/functions.c:743
9473
msgid "PROPER:@{text} with initial of each word capitalised."
9610
#: ../plugins/fn-string/functions.c:748
9611
msgid "PROPER:@{text} with initial of each word capitalised"
9476
#: ../plugins/fn-string/functions.c:785
9614
#: ../plugins/fn-string/functions.c:790
9478
"REPLACE:String @{old} with @{num} characters starting at @{start} replaced "
9616
"REPLACE:string @{old} with @{num} characters starting at @{start} replaced "
9482
#: ../plugins/fn-string/functions.c:787 ../plugins/fn-string/functions.c:838
9620
#: ../plugins/fn-string/functions.c:792 ../plugins/fn-string/functions.c:843
9483
9621
msgid "old:original text"
9486
#: ../plugins/fn-string/functions.c:788
9624
#: ../plugins/fn-string/functions.c:793
9487
9625
msgid "start:starting position"
9490
#: ../plugins/fn-string/functions.c:789
9628
#: ../plugins/fn-string/functions.c:794
9491
9629
msgid "num:number of characters to be replaced"
9494
#: ../plugins/fn-string/functions.c:790 ../plugins/fn-string/functions.c:841
9495
#: ../plugins/fn-string/functions.c:1109
9632
#: ../plugins/fn-string/functions.c:795 ../plugins/fn-string/functions.c:846
9633
#: ../plugins/fn-string/functions.c:1114
9496
9634
msgid "new:replacement string"
9499
#: ../plugins/fn-string/functions.c:836
9637
#: ../plugins/fn-string/functions.c:841
9501
9639
"REPLACEB:string @{old} with up to @{num} bytes starting at @{start} replaced "
9505
#: ../plugins/fn-string/functions.c:839
9643
#: ../plugins/fn-string/functions.c:844
9506
9644
msgid "start:starting byte position"
9509
#: ../plugins/fn-string/functions.c:840
9647
#: ../plugins/fn-string/functions.c:845
9510
9648
msgid "num:number of bytes to be replaced"
9513
#: ../plugins/fn-string/functions.c:842
9651
#: ../plugins/fn-string/functions.c:847
9515
9653
"REPLACEB replaces the string of valid unicode characters starting at the "
9516
9654
"byte @{start} and ending at @{start}+@{num}-1 with the string @{new}."
9519
#: ../plugins/fn-string/functions.c:890
9657
#: ../plugins/fn-string/functions.c:895
9520
9658
msgid "T:@{value} if and only if @{value} is text, otherwise empty"
9523
#: ../plugins/fn-string/functions.c:891
9661
#: ../plugins/fn-string/functions.c:896
9524
9662
msgid "value:original value"
9527
#: ../plugins/fn-string/functions.c:913
9665
#: ../plugins/fn-string/functions.c:918
9528
9666
msgid "TEXT:@{value} as a string formatted as @{format}"
9531
#: ../plugins/fn-string/functions.c:914
9669
#: ../plugins/fn-string/functions.c:919
9532
9670
msgid "value:value to be formatted"
9535
#: ../plugins/fn-string/functions.c:915
9673
#: ../plugins/fn-string/functions.c:920
9536
9674
msgid "format:desired format"
9539
#: ../plugins/fn-string/functions.c:967
9540
msgid "TRIM:@{text} with only single spaces between words."
9677
#: ../plugins/fn-string/functions.c:972
9678
msgid "TRIM:@{text} with only single spaces between words"
9543
#: ../plugins/fn-string/functions.c:1014
9681
#: ../plugins/fn-string/functions.c:1019
9544
9682
msgid "VALUE:numeric value of @{text}"
9547
#: ../plugins/fn-string/functions.c:1047
9685
#: ../plugins/fn-string/functions.c:1052
9548
9686
msgid "NUMBERVALUE:numeric value of @{text}"
9551
#: ../plugins/fn-string/functions.c:1049
9689
#: ../plugins/fn-string/functions.c:1054
9552
9690
msgid "separator:decimal separator"
9555
#: ../plugins/fn-string/functions.c:1050
9693
#: ../plugins/fn-string/functions.c:1055
9557
9695
"If @{text} does not look like a decimal number, NUMBERVALUE returns the "
9558
9696
"value VALUE would return (ignoring the given @{separator})."
9561
#: ../plugins/fn-string/functions.c:1106
9699
#: ../plugins/fn-string/functions.c:1111
9562
9700
msgid "SUBSTITUTE:@{text} with all occurrences of @{old} replaced by @{new}"
9565
#: ../plugins/fn-string/functions.c:1107 ../plugins/fn-string/functions.c:1517
9703
#: ../plugins/fn-string/functions.c:1112 ../plugins/fn-string/functions.c:1522
9566
9704
msgid "text:original text"
9569
#: ../plugins/fn-string/functions.c:1108
9707
#: ../plugins/fn-string/functions.c:1113
9570
9708
msgid "old:string to be replaced"
9573
#: ../plugins/fn-string/functions.c:1110
9711
#: ../plugins/fn-string/functions.c:1115
9575
9713
"num:if @{num} is specified and a number only the @{num}th occurrence of @"
9576
9714
"{old} is replaced"
9579
#: ../plugins/fn-string/functions.c:1180
9580
msgid "DOLLAR:@{num} formatted as currency."
9717
#: ../plugins/fn-string/functions.c:1185
9718
msgid "DOLLAR:@{num} formatted as currency"
9583
#: ../plugins/fn-string/functions.c:1182
9721
#: ../plugins/fn-string/functions.c:1187
9584
9722
msgid "decimals:decimals"
9587
#: ../plugins/fn-string/functions.c:1252
9725
#: ../plugins/fn-string/functions.c:1257
9589
9727
"SEARCH:the location of the @{search} string within @{text} after position @"
9593
#: ../plugins/fn-string/functions.c:1254 ../plugins/fn-string/functions.c:1323
9731
#: ../plugins/fn-string/functions.c:1259 ../plugins/fn-string/functions.c:1328
9594
9732
msgid "search:search string"
9597
#: ../plugins/fn-string/functions.c:1255 ../plugins/fn-string/functions.c:1324
9735
#: ../plugins/fn-string/functions.c:1260 ../plugins/fn-string/functions.c:1329
9598
9736
msgid "text:search field"
9601
#: ../plugins/fn-string/functions.c:1257 ../plugins/fn-string/functions.c:1326
9739
#: ../plugins/fn-string/functions.c:1262 ../plugins/fn-string/functions.c:1331
9603
9741
"@{search} may contain wildcard characters (*) and question marks (?). A "
9604
9742
"question mark matches any single character, and a wildcard matches any "