Proyectos de Subversion Moodle

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1441 ariadna 1
############################################################
2
##
3
## PhpSpreadsheet - function name translations
4
##
5
## Español (Spanish)
6
##
7
############################################################
8
 
9
 
10
##
11
## Funciones de cubo (Cube Functions)
12
##
13
CUBEKPIMEMBER = MIEMBROKPICUBO
14
CUBEMEMBER = MIEMBROCUBO
15
CUBEMEMBERPROPERTY = PROPIEDADMIEMBROCUBO
16
CUBERANKEDMEMBER = MIEMBRORANGOCUBO
17
CUBESET = CONJUNTOCUBO
18
CUBESETCOUNT = RECUENTOCONJUNTOCUBO
19
CUBEVALUE = VALORCUBO
20
 
21
##
22
## Funciones de base de datos (Database Functions)
23
##
24
DAVERAGE = BDPROMEDIO
25
DCOUNT = BDCONTAR
26
DCOUNTA = BDCONTARA
27
DGET = BDEXTRAER
28
DMAX = BDMAX
29
DMIN = BDMIN
30
DPRODUCT = BDPRODUCTO
31
DSTDEV = BDDESVEST
32
DSTDEVP = BDDESVESTP
33
DSUM = BDSUMA
34
DVAR = BDVAR
35
DVARP = BDVARP
36
 
37
##
38
## Funciones de fecha y hora (Date & Time Functions)
39
##
40
DATE = FECHA
41
DATEDIF = SIFECHA
42
DATESTRING = CADENA.FECHA
43
DATEVALUE = FECHANUMERO
44
DAY = DIA
45
DAYS = DIAS
46
DAYS360 = DIAS360
47
EDATE = FECHA.MES
48
EOMONTH = FIN.MES
49
HOUR = HORA
50
ISOWEEKNUM = ISO.NUM.DE.SEMANA
51
MINUTE = MINUTO
52
MONTH = MES
53
NETWORKDAYS = DIAS.LAB
54
NETWORKDAYS.INTL = DIAS.LAB.INTL
55
NOW = AHORA
56
SECOND = SEGUNDO
57
THAIDAYOFWEEK = DIASEMTAI
58
THAIMONTHOFYEAR = MESAÑOTAI
59
THAIYEAR = AÑOTAI
60
TIME = NSHORA
61
TIMEVALUE = HORANUMERO
62
TODAY = HOY
63
WEEKDAY = DIASEM
64
WEEKNUM = NUM.DE.SEMANA
65
WORKDAY = DIA.LAB
66
WORKDAY.INTL = DIA.LAB.INTL
67
YEAR = AÑO
68
YEARFRAC = FRAC.AÑO
69
 
70
##
71
## Funciones de ingeniería (Engineering Functions)
72
##
73
BESSELI = BESSELI
74
BESSELJ = BESSELJ
75
BESSELK = BESSELK
76
BESSELY = BESSELY
77
BIN2DEC = BIN.A.DEC
78
BIN2HEX = BIN.A.HEX
79
BIN2OCT = BIN.A.OCT
80
BITAND = BIT.Y
81
BITLSHIFT = BIT.DESPLIZQDA
82
BITOR = BIT.O
83
BITRSHIFT = BIT.DESPLDCHA
84
BITXOR = BIT.XO
85
COMPLEX = COMPLEJO
86
CONVERT = CONVERTIR
87
DEC2BIN = DEC.A.BIN
88
DEC2HEX = DEC.A.HEX
89
DEC2OCT = DEC.A.OCT
90
DELTA = DELTA
91
ERF = FUN.ERROR
92
ERF.PRECISE = FUN.ERROR.EXACTO
93
ERFC = FUN.ERROR.COMPL
94
ERFC.PRECISE = FUN.ERROR.COMPL.EXACTO
95
GESTEP = MAYOR.O.IGUAL
96
HEX2BIN = HEX.A.BIN
97
HEX2DEC = HEX.A.DEC
98
HEX2OCT = HEX.A.OCT
99
IMABS = IM.ABS
100
IMAGINARY = IMAGINARIO
101
IMARGUMENT = IM.ANGULO
102
IMCONJUGATE = IM.CONJUGADA
103
IMCOS = IM.COS
104
IMCOSH = IM.COSH
105
IMCOT = IM.COT
106
IMCSC = IM.CSC
107
IMCSCH = IM.CSCH
108
IMDIV = IM.DIV
109
IMEXP = IM.EXP
110
IMLN = IM.LN
111
IMLOG10 = IM.LOG10
112
IMLOG2 = IM.LOG2
113
IMPOWER = IM.POT
114
IMPRODUCT = IM.PRODUCT
115
IMREAL = IM.REAL
116
IMSEC = IM.SEC
117
IMSECH = IM.SECH
118
IMSIN = IM.SENO
119
IMSINH = IM.SENOH
120
IMSQRT = IM.RAIZ2
121
IMSUB = IM.SUSTR
122
IMSUM = IM.SUM
123
IMTAN = IM.TAN
124
OCT2BIN = OCT.A.BIN
125
OCT2DEC = OCT.A.DEC
126
OCT2HEX = OCT.A.HEX
127
 
128
##
129
## Funciones financieras (Financial Functions)
130
##
131
ACCRINT = INT.ACUM
132
ACCRINTM = INT.ACUM.V
133
AMORDEGRC = AMORTIZ.PROGRE
134
AMORLINC = AMORTIZ.LIN
135
COUPDAYBS = CUPON.DIAS.L1
136
COUPDAYS = CUPON.DIAS
137
COUPDAYSNC = CUPON.DIAS.L2
138
COUPNCD = CUPON.FECHA.L2
139
COUPNUM = CUPON.NUM
140
COUPPCD = CUPON.FECHA.L1
141
CUMIPMT = PAGO.INT.ENTRE
142
CUMPRINC = PAGO.PRINC.ENTRE
143
DB = DB
144
DDB = DDB
145
DISC = TASA.DESC
146
DOLLARDE = MONEDA.DEC
147
DOLLARFR = MONEDA.FRAC
148
DURATION = DURACION
149
EFFECT = INT.EFECTIVO
150
FV = VF
151
FVSCHEDULE = VF.PLAN
152
INTRATE = TASA.INT
153
IPMT = PAGOINT
154
IRR = TIR
155
ISPMT = INT.PAGO.DIR
156
MDURATION = DURACION.MODIF
157
MIRR = TIRM
158
NOMINAL = TASA.NOMINAL
159
NPER = NPER
160
NPV = VNA
161
ODDFPRICE = PRECIO.PER.IRREGULAR.1
162
ODDFYIELD = RENDTO.PER.IRREGULAR.1
163
ODDLPRICE = PRECIO.PER.IRREGULAR.2
164
ODDLYIELD = RENDTO.PER.IRREGULAR.2
165
PDURATION = P.DURACION
166
PMT = PAGO
167
PPMT = PAGOPRIN
168
PRICE = PRECIO
169
PRICEDISC = PRECIO.DESCUENTO
170
PRICEMAT = PRECIO.VENCIMIENTO
171
PV = VA
172
RATE = TASA
173
RECEIVED = CANTIDAD.RECIBIDA
174
RRI = RRI
175
SLN = SLN
176
SYD = SYD
177
TBILLEQ = LETRA.DE.TEST.EQV.A.BONO
178
TBILLPRICE = LETRA.DE.TES.PRECIO
179
TBILLYIELD = LETRA.DE.TES.RENDTO
180
VDB = DVS
181
XIRR = TIR.NO.PER
182
XNPV = VNA.NO.PER
183
YIELD = RENDTO
184
YIELDDISC = RENDTO.DESC
185
YIELDMAT = RENDTO.VENCTO
186
 
187
##
188
## Funciones de información (Information Functions)
189
##
190
CELL = CELDA
191
ERROR.TYPE = TIPO.DE.ERROR
192
INFO = INFO
193
ISBLANK = ESBLANCO
194
ISERR = ESERR
195
ISERROR = ESERROR
196
ISEVEN = ES.PAR
197
ISFORMULA = ESFORMULA
198
ISLOGICAL = ESLOGICO
199
ISNA = ESNOD
200
ISNONTEXT = ESNOTEXTO
201
ISNUMBER = ESNUMERO
202
ISODD = ES.IMPAR
203
ISREF = ESREF
204
ISTEXT = ESTEXTO
205
N = N
206
NA = NOD
207
SHEET = HOJA
208
SHEETS = HOJAS
209
TYPE = TIPO
210
 
211
##
212
## Funciones lógicas (Logical Functions)
213
##
214
AND = Y
215
FALSE = FALSO
216
IF = SI
217
IFERROR = SI.ERROR
218
IFNA = SI.ND
219
IFS = SI.CONJUNTO
220
NOT = NO
221
OR = O
222
SWITCH = CAMBIAR
223
TRUE = VERDADERO
224
XOR = XO
225
 
226
##
227
## Funciones de búsqueda y referencia (Lookup & Reference Functions)
228
##
229
ADDRESS = DIRECCION
230
AREAS = AREAS
231
CHOOSE = ELEGIR
232
COLUMN = COLUMNA
233
COLUMNS = COLUMNAS
234
FORMULATEXT = FORMULATEXTO
235
GETPIVOTDATA = IMPORTARDATOSDINAMICOS
236
HLOOKUP = BUSCARH
237
HYPERLINK = HIPERVINCULO
238
INDEX = INDICE
239
INDIRECT = INDIRECTO
240
LOOKUP = BUSCAR
241
MATCH = COINCIDIR
242
OFFSET = DESREF
243
ROW = FILA
244
ROWS = FILAS
245
RTD = RDTR
246
TRANSPOSE = TRANSPONER
247
VLOOKUP = BUSCARV
248
*RC = FC
249
 
250
##
251
## Funciones matemáticas y trigonométricas (Math & Trig Functions)
252
##
253
ABS = ABS
254
ACOS = ACOS
255
ACOSH = ACOSH
256
ACOT = ACOT
257
ACOTH = ACOTH
258
AGGREGATE = AGREGAR
259
ARABIC = NUMERO.ARABE
260
ASIN = ASENO
261
ASINH = ASENOH
262
ATAN = ATAN
263
ATAN2 = ATAN2
264
ATANH = ATANH
265
BASE = BASE
266
CEILING.MATH = MULTIPLO.SUPERIOR.MAT
267
CEILING.PRECISE = MULTIPLO.SUPERIOR.EXACTO
268
COMBIN = COMBINAT
269
COMBINA = COMBINA
270
COS = COS
271
COSH = COSH
272
COT = COT
273
COTH = COTH
274
CSC = CSC
275
CSCH = CSCH
276
DECIMAL = CONV.DECIMAL
277
DEGREES = GRADOS
278
ECMA.CEILING = MULTIPLO.SUPERIOR.ECMA
279
EVEN = REDONDEA.PAR
280
EXP = EXP
281
FACT = FACT
282
FACTDOUBLE = FACT.DOBLE
283
FLOOR.MATH = MULTIPLO.INFERIOR.MAT
284
FLOOR.PRECISE = MULTIPLO.INFERIOR.EXACTO
285
GCD = M.C.D
286
INT = ENTERO
287
ISO.CEILING = MULTIPLO.SUPERIOR.ISO
288
LCM = M.C.M
289
LN = LN
290
LOG = LOG
291
LOG10 = LOG10
292
MDETERM = MDETERM
293
MINVERSE = MINVERSA
294
MMULT = MMULT
295
MOD = RESIDUO
296
MROUND = REDOND.MULT
297
MULTINOMIAL = MULTINOMIAL
298
MUNIT = M.UNIDAD
299
ODD = REDONDEA.IMPAR
300
PI = PI
301
POWER = POTENCIA
302
PRODUCT = PRODUCTO
303
QUOTIENT = COCIENTE
304
RADIANS = RADIANES
305
RAND = ALEATORIO
306
RANDBETWEEN = ALEATORIO.ENTRE
307
ROMAN = NUMERO.ROMANO
308
ROUND = REDONDEAR
309
ROUNDBAHTDOWN = REDONDEAR.BAHT.MAS
310
ROUNDBAHTUP = REDONDEAR.BAHT.MENOS
311
ROUNDDOWN = REDONDEAR.MENOS
312
ROUNDUP = REDONDEAR.MAS
313
SEC = SEC
314
SECH = SECH
315
SERIESSUM = SUMA.SERIES
316
SIGN = SIGNO
317
SIN = SENO
318
SINH = SENOH
319
SQRT = RAIZ
320
SQRTPI = RAIZ2PI
321
SUBTOTAL = SUBTOTALES
322
SUM = SUMA
323
SUMIF = SUMAR.SI
324
SUMIFS = SUMAR.SI.CONJUNTO
325
SUMPRODUCT = SUMAPRODUCTO
326
SUMSQ = SUMA.CUADRADOS
327
SUMX2MY2 = SUMAX2MENOSY2
328
SUMX2PY2 = SUMAX2MASY2
329
SUMXMY2 = SUMAXMENOSY2
330
TAN = TAN
331
TANH = TANH
332
TRUNC = TRUNCAR
333
 
334
##
335
## Funciones estadísticas (Statistical Functions)
336
##
337
AVEDEV = DESVPROM
338
AVERAGE = PROMEDIO
339
AVERAGEA = PROMEDIOA
340
AVERAGEIF = PROMEDIO.SI
341
AVERAGEIFS = PROMEDIO.SI.CONJUNTO
342
BETA.DIST = DISTR.BETA.N
343
BETA.INV = INV.BETA.N
344
BINOM.DIST = DISTR.BINOM.N
345
BINOM.DIST.RANGE = DISTR.BINOM.SERIE
346
BINOM.INV = INV.BINOM
347
CHISQ.DIST = DISTR.CHICUAD
348
CHISQ.DIST.RT = DISTR.CHICUAD.CD
349
CHISQ.INV = INV.CHICUAD
350
CHISQ.INV.RT = INV.CHICUAD.CD
351
CHISQ.TEST = PRUEBA.CHICUAD
352
CONFIDENCE.NORM = INTERVALO.CONFIANZA.NORM
353
CONFIDENCE.T = INTERVALO.CONFIANZA.T
354
CORREL = COEF.DE.CORREL
355
COUNT = CONTAR
356
COUNTA = CONTARA
357
COUNTBLANK = CONTAR.BLANCO
358
COUNTIF = CONTAR.SI
359
COUNTIFS = CONTAR.SI.CONJUNTO
360
COVARIANCE.P = COVARIANCE.P
361
COVARIANCE.S = COVARIANZA.M
362
DEVSQ = DESVIA2
363
EXPON.DIST = DISTR.EXP.N
364
F.DIST = DISTR.F.N
365
F.DIST.RT = DISTR.F.CD
366
F.INV = INV.F
367
F.INV.RT = INV.F.CD
368
F.TEST = PRUEBA.F.N
369
FISHER = FISHER
370
FISHERINV = PRUEBA.FISHER.INV
371
FORECAST.ETS = PRONOSTICO.ETS
372
FORECAST.ETS.CONFINT = PRONOSTICO.ETS.CONFINT
373
FORECAST.ETS.SEASONALITY = PRONOSTICO.ETS.ESTACIONALIDAD
374
FORECAST.ETS.STAT = PRONOSTICO.ETS.STAT
375
FORECAST.LINEAR = PRONOSTICO.LINEAL
376
FREQUENCY = FRECUENCIA
377
GAMMA = GAMMA
378
GAMMA.DIST = DISTR.GAMMA.N
379
GAMMA.INV = INV.GAMMA
380
GAMMALN = GAMMA.LN
381
GAMMALN.PRECISE = GAMMA.LN.EXACTO
382
GAUSS = GAUSS
383
GEOMEAN = MEDIA.GEOM
384
GROWTH = CRECIMIENTO
385
HARMEAN = MEDIA.ARMO
386
HYPGEOM.DIST = DISTR.HIPERGEOM.N
387
INTERCEPT = INTERSECCION.EJE
388
KURT = CURTOSIS
389
LARGE = K.ESIMO.MAYOR
390
LINEST = ESTIMACION.LINEAL
391
LOGEST = ESTIMACION.LOGARITMICA
392
LOGNORM.DIST = DISTR.LOGNORM
393
LOGNORM.INV = INV.LOGNORM
394
MAX = MAX
395
MAXA = MAXA
396
MAXIFS = MAX.SI.CONJUNTO
397
MEDIAN = MEDIANA
398
MIN = MIN
399
MINA = MINA
400
MINIFS = MIN.SI.CONJUNTO
401
MODE.MULT = MODA.VARIOS
402
MODE.SNGL = MODA.UNO
403
NEGBINOM.DIST = NEGBINOM.DIST
404
NORM.DIST = DISTR.NORM.N
405
NORM.INV = INV.NORM
406
NORM.S.DIST = DISTR.NORM.ESTAND.N
407
NORM.S.INV = INV.NORM.ESTAND
408
PEARSON = PEARSON
409
PERCENTILE.EXC = PERCENTIL.EXC
410
PERCENTILE.INC = PERCENTIL.INC
411
PERCENTRANK.EXC = RANGO.PERCENTIL.EXC
412
PERCENTRANK.INC = RANGO.PERCENTIL.INC
413
PERMUT = PERMUTACIONES
414
PERMUTATIONA = PERMUTACIONES.A
415
PHI = FI
416
POISSON.DIST = POISSON.DIST
417
PROB = PROBABILIDAD
418
QUARTILE.EXC = CUARTIL.EXC
419
QUARTILE.INC = CUARTIL.INC
420
RANK.AVG = JERARQUIA.MEDIA
421
RANK.EQ = JERARQUIA.EQV
422
RSQ = COEFICIENTE.R2
423
SKEW = COEFICIENTE.ASIMETRIA
424
SKEW.P = COEFICIENTE.ASIMETRIA.P
425
SLOPE = PENDIENTE
426
SMALL = K.ESIMO.MENOR
427
STANDARDIZE = NORMALIZACION
428
STDEV.P = DESVEST.P
429
STDEV.S = DESVEST.M
430
STDEVA = DESVESTA
431
STDEVPA = DESVESTPA
432
STEYX = ERROR.TIPICO.XY
433
T.DIST = DISTR.T.N
434
T.DIST.2T = DISTR.T.2C
435
T.DIST.RT = DISTR.T.CD
436
T.INV = INV.T
437
T.INV.2T = INV.T.2C
438
T.TEST = PRUEBA.T.N
439
TREND = TENDENCIA
440
TRIMMEAN = MEDIA.ACOTADA
441
VAR.P = VAR.P
442
VAR.S = VAR.S
443
VARA = VARA
444
VARPA = VARPA
445
WEIBULL.DIST = DISTR.WEIBULL
446
Z.TEST = PRUEBA.Z.N
447
 
448
##
449
## Funciones de texto (Text Functions)
450
##
451
BAHTTEXT = TEXTOBAHT
452
CHAR = CARACTER
453
CLEAN = LIMPIAR
454
CODE = CODIGO
455
CONCAT = CONCAT
456
DOLLAR = MONEDA
457
EXACT = IGUAL
458
FIND = ENCONTRAR
459
FIXED = DECIMAL
460
ISTHAIDIGIT = ESDIGITOTAI
461
LEFT = IZQUIERDA
462
LEN = LARGO
463
LOWER = MINUSC
464
MID = EXTRAE
465
NUMBERSTRING = CADENA.NUMERO
466
NUMBERVALUE = VALOR.NUMERO
467
PHONETIC = FONETICO
468
PROPER = NOMPROPIO
469
REPLACE = REEMPLAZAR
470
REPT = REPETIR
471
RIGHT = DERECHA
472
SEARCH = HALLAR
473
SUBSTITUTE = SUSTITUIR
474
T = T
475
TEXT = TEXTO
476
TEXTJOIN = UNIRCADENAS
477
THAIDIGIT = DIGITOTAI
478
THAINUMSOUND = SONNUMTAI
479
THAINUMSTRING = CADENANUMTAI
480
THAISTRINGLENGTH = LONGCADENATAI
481
TRIM = ESPACIOS
482
UNICHAR = UNICAR
483
UNICODE = UNICODE
484
UPPER = MAYUSC
485
VALUE = VALOR
486
 
487
##
488
## Funciones web (Web Functions)
489
##
490
ENCODEURL = URLCODIF
491
FILTERXML = XMLFILTRO
492
WEBSERVICE = SERVICIOWEB
493
 
494
##
495
## Funciones de compatibilidad (Compatibility Functions)
496
##
497
BETADIST = DISTR.BETA
498
BETAINV = DISTR.BETA.INV
499
BINOMDIST = DISTR.BINOM
500
CEILING = MULTIPLO.SUPERIOR
501
CHIDIST = DISTR.CHI
502
CHIINV = PRUEBA.CHI.INV
503
CHITEST = PRUEBA.CHI
504
CONCATENATE = CONCATENAR
505
CONFIDENCE = INTERVALO.CONFIANZA
506
COVAR = COVAR
507
CRITBINOM = BINOM.CRIT
508
EXPONDIST = DISTR.EXP
509
FDIST = DISTR.F
510
FINV = DISTR.F.INV
511
FLOOR = MULTIPLO.INFERIOR
512
FORECAST = PRONOSTICO
513
FTEST = PRUEBA.F
514
GAMMADIST = DISTR.GAMMA
515
GAMMAINV = DISTR.GAMMA.INV
516
HYPGEOMDIST = DISTR.HIPERGEOM
517
LOGINV = DISTR.LOG.INV
518
LOGNORMDIST = DISTR.LOG.NORM
519
MODE = MODA
520
NEGBINOMDIST = NEGBINOMDIST
521
NORMDIST = DISTR.NORM
522
NORMINV = DISTR.NORM.INV
523
NORMSDIST = DISTR.NORM.ESTAND
524
NORMSINV = DISTR.NORM.ESTAND.INV
525
PERCENTILE = PERCENTIL
526
PERCENTRANK = RANGO.PERCENTIL
527
POISSON = POISSON
528
QUARTILE = CUARTIL
529
RANK = JERARQUIA
530
STDEV = DESVEST
531
STDEVP = DESVESTP
532
TDIST = DISTR.T
533
TINV = DISTR.T.INV
534
TTEST = PRUEBA.T
535
VAR = VAR
536
VARP = VARP
537
WEIBULL = DIST.WEIBULL
538
ZTEST = PRUEBA.Z