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 
## Français (French)
6 
##
7 
############################################################
8 
 
9 
 
10 
##
11 
## Fonctions Cube (Cube Functions)
12 
##
13 
CUBEKPIMEMBER = MEMBREKPICUBE
14 
CUBEMEMBER = MEMBRECUBE
15 
CUBEMEMBERPROPERTY = PROPRIETEMEMBRECUBE
16 
CUBERANKEDMEMBER = RANGMEMBRECUBE
17 
CUBESET = JEUCUBE
18 
CUBESETCOUNT = NBJEUCUBE
19 
CUBEVALUE = VALEURCUBE
20 
 
21 
##
22 
## Fonctions de base de données (Database Functions)
23 
##
24 
DAVERAGE = BDMOYENNE
25 
DCOUNT = BDNB
26 
DCOUNTA = BDNBVAL
27 
DGET = BDLIRE
28 
DMAX = BDMAX
29 
DMIN = BDMIN
30 
DPRODUCT = BDPRODUIT
31 
DSTDEV = BDECARTYPE
32 
DSTDEVP = BDECARTYPEP
33 
DSUM = BDSOMME
34 
DVAR = BDVAR
35 
DVARP = BDVARP
36 
 
37 
##
38 
## Fonctions de date et d’heure (Date & Time Functions)
39 
##
40 
DATE = DATE
41 
DATEVALUE = DATEVAL
42 
DAY = JOUR
43 
DAYS = JOURS
44 
DAYS360 = JOURS360
45 
EDATE = MOIS.DECALER
46 
EOMONTH = FIN.MOIS
47 
HOUR = HEURE
48 
ISOWEEKNUM = NO.SEMAINE.ISO
49 
MINUTE = MINUTE
50 
MONTH = MOIS
51 
NETWORKDAYS = NB.JOURS.OUVRES
52 
NETWORKDAYS.INTL = NB.JOURS.OUVRES.INTL
53 
NOW = MAINTENANT
54 
SECOND = SECONDE
55 
TIME = TEMPS
56 
TIMEVALUE = TEMPSVAL
57 
TODAY = AUJOURDHUI
58 
WEEKDAY = JOURSEM
59 
WEEKNUM = NO.SEMAINE
60 
WORKDAY = SERIE.JOUR.OUVRE
61 
WORKDAY.INTL = SERIE.JOUR.OUVRE.INTL
62 
YEAR = ANNEE
63 
YEARFRAC = FRACTION.ANNEE
64 
 
65 
##
66 
## Fonctions d’ingénierie (Engineering Functions)
67 
##
68 
BESSELI = BESSELI
69 
BESSELJ = BESSELJ
70 
BESSELK = BESSELK
71 
BESSELY = BESSELY
72 
BIN2DEC = BINDEC
73 
BIN2HEX = BINHEX
74 
BIN2OCT = BINOCT
75 
BITAND = BITET
76 
BITLSHIFT = BITDECALG
77 
BITOR = BITOU
78 
BITRSHIFT = BITDECALD
79 
BITXOR = BITOUEXCLUSIF
80 
COMPLEX = COMPLEXE
81 
CONVERT = CONVERT
82 
DEC2BIN = DECBIN
83 
DEC2HEX = DECHEX
84 
DEC2OCT = DECOCT
85 
DELTA = DELTA
86 
ERF = ERF
87 
ERF.PRECISE = ERF.PRECIS
88 
ERFC = ERFC
89 
ERFC.PRECISE = ERFC.PRECIS
90 
GESTEP = SUP.SEUIL
91 
HEX2BIN = HEXBIN
92 
HEX2DEC = HEXDEC
93 
HEX2OCT = HEXOCT
94 
IMABS = COMPLEXE.MODULE
95 
IMAGINARY = COMPLEXE.IMAGINAIRE
96 
IMARGUMENT = COMPLEXE.ARGUMENT
97 
IMCONJUGATE = COMPLEXE.CONJUGUE
98 
IMCOS = COMPLEXE.COS
99 
IMCOSH = COMPLEXE.COSH
100 
IMCOT = COMPLEXE.COT
101 
IMCSC = COMPLEXE.CSC
102 
IMCSCH = COMPLEXE.CSCH
103 
IMDIV = COMPLEXE.DIV
104 
IMEXP = COMPLEXE.EXP
105 
IMLN = COMPLEXE.LN
106 
IMLOG10 = COMPLEXE.LOG10
107 
IMLOG2 = COMPLEXE.LOG2
108 
IMPOWER = COMPLEXE.PUISSANCE
109 
IMPRODUCT = COMPLEXE.PRODUIT
110 
IMREAL = COMPLEXE.REEL
111 
IMSEC = COMPLEXE.SEC
112 
IMSECH = COMPLEXE.SECH
113 
IMSIN = COMPLEXE.SIN
114 
IMSINH = COMPLEXE.SINH
115 
IMSQRT = COMPLEXE.RACINE
116 
IMSUB = COMPLEXE.DIFFERENCE
117 
IMSUM = COMPLEXE.SOMME
118 
IMTAN = COMPLEXE.TAN
119 
OCT2BIN = OCTBIN
120 
OCT2DEC = OCTDEC
121 
OCT2HEX = OCTHEX
122 
 
123 
##
124 
## Fonctions financières (Financial Functions)
125 
##
126 
ACCRINT = INTERET.ACC
127 
ACCRINTM = INTERET.ACC.MAT
128 
AMORDEGRC = AMORDEGRC
129 
AMORLINC = AMORLINC
130 
COUPDAYBS = NB.JOURS.COUPON.PREC
131 
COUPDAYS = NB.JOURS.COUPONS
132 
COUPDAYSNC = NB.JOURS.COUPON.SUIV
133 
COUPNCD = DATE.COUPON.SUIV
134 
COUPNUM = NB.COUPONS
135 
COUPPCD = DATE.COUPON.PREC
136 
CUMIPMT = CUMUL.INTER
137 
CUMPRINC = CUMUL.PRINCPER
138 
DB = DB
139 
DDB = DDB
140 
DISC = TAUX.ESCOMPTE
141 
DOLLARDE = PRIX.DEC
142 
DOLLARFR = PRIX.FRAC
143 
DURATION = DUREE
144 
EFFECT = TAUX.EFFECTIF
145 
FV = VC
146 
FVSCHEDULE = VC.PAIEMENTS
147 
INTRATE = TAUX.INTERET
148 
IPMT = INTPER
149 
IRR = TRI
150 
ISPMT = ISPMT
151 
MDURATION = DUREE.MODIFIEE
152 
MIRR = TRIM
153 
NOMINAL = TAUX.NOMINAL
154 
NPER = NPM
155 
NPV = VAN
156 
ODDFPRICE = PRIX.PCOUPON.IRREG
157 
ODDFYIELD = REND.PCOUPON.IRREG
158 
ODDLPRICE = PRIX.DCOUPON.IRREG
159 
ODDLYIELD = REND.DCOUPON.IRREG
160 
PDURATION = PDUREE
161 
PMT = VPM
162 
PPMT = PRINCPER
163 
PRICE = PRIX.TITRE
164 
PRICEDISC = VALEUR.ENCAISSEMENT
165 
PRICEMAT = PRIX.TITRE.ECHEANCE
166 
PV = VA
167 
RATE = TAUX
168 
RECEIVED = VALEUR.NOMINALE
169 
RRI = TAUX.INT.EQUIV
170 
SLN = AMORLIN
171 
SYD = SYD
172 
TBILLEQ = TAUX.ESCOMPTE.R
173 
TBILLPRICE = PRIX.BON.TRESOR
174 
TBILLYIELD = RENDEMENT.BON.TRESOR
175 
VDB = VDB
176 
XIRR = TRI.PAIEMENTS
177 
XNPV = VAN.PAIEMENTS
178 
YIELD = RENDEMENT.TITRE
179 
YIELDDISC = RENDEMENT.SIMPLE
180 
YIELDMAT = RENDEMENT.TITRE.ECHEANCE
181 
 
182 
##
183 
## Fonctions d’information (Information Functions)
184 
##
185 
CELL = CELLULE
186 
ERROR.TYPE = TYPE.ERREUR
187 
INFO = INFORMATIONS
188 
ISBLANK = ESTVIDE
189 
ISERR = ESTERR
190 
ISERROR = ESTERREUR
191 
ISEVEN = EST.PAIR
192 
ISFORMULA = ESTFORMULE
193 
ISLOGICAL = ESTLOGIQUE
194 
ISNA = ESTNA
195 
ISNONTEXT = ESTNONTEXTE
196 
ISNUMBER = ESTNUM
197 
ISODD = EST.IMPAIR
198 
ISREF = ESTREF
199 
ISTEXT = ESTTEXTE
200 
N = N
201 
NA = NA
202 
SHEET = FEUILLE
203 
SHEETS = FEUILLES
204 
TYPE = TYPE
205 
 
206 
##
207 
## Fonctions logiques (Logical Functions)
208 
##
209 
AND = ET
210 
FALSE = FAUX
211 
IF = SI
212 
IFERROR = SIERREUR
213 
IFNA = SI.NON.DISP
214 
IFS = SI.CONDITIONS
215 
NOT = NON
216 
OR = OU
217 
SWITCH = SI.MULTIPLE
218 
TRUE = VRAI
219 
XOR = OUX
220 
 
221 
##
222 
## Fonctions de recherche et de référence (Lookup & Reference Functions)
223 
##
224 
ADDRESS = ADRESSE
225 
AREAS = ZONES
226 
CHOOSE = CHOISIR
227 
COLUMN = COLONNE
228 
COLUMNS = COLONNES
229 
FORMULATEXT = FORMULETEXTE
230 
GETPIVOTDATA = LIREDONNEESTABCROISDYNAMIQUE
231 
HLOOKUP = RECHERCHEH
232 
HYPERLINK = LIEN_HYPERTEXTE
233 
INDEX = INDEX
234 
INDIRECT = INDIRECT
235 
LOOKUP = RECHERCHE
236 
MATCH = EQUIV
237 
OFFSET = DECALER
238 
ROW = LIGNE
239 
ROWS = LIGNES
240 
RTD = RTD
241 
TRANSPOSE = TRANSPOSE
242 
VLOOKUP = RECHERCHEV
243 
*RC = LC
244 
 
245 
##
246 
## Fonctions mathématiques et trigonométriques (Math & Trig Functions)
247 
##
248 
ABS = ABS
249 
ACOS = ACOS
250 
ACOSH = ACOSH
251 
ACOT = ACOT
252 
ACOTH = ACOTH
253 
AGGREGATE = AGREGAT
254 
ARABIC = CHIFFRE.ARABE
255 
ASIN = ASIN
256 
ASINH = ASINH
257 
ATAN = ATAN
258 
ATAN2 = ATAN2
259 
ATANH = ATANH
260 
BASE = BASE
261 
CEILING.MATH = PLAFOND.MATH
262 
CEILING.PRECISE = PLAFOND.PRECIS
263 
COMBIN = COMBIN
264 
COMBINA = COMBINA
265 
COS = COS
266 
COSH = COSH
267 
COT = COT
268 
COTH = COTH
269 
CSC = CSC
270 
CSCH = CSCH
271 
DECIMAL = DECIMAL
272 
DEGREES = DEGRES
273 
ECMA.CEILING = ECMA.PLAFOND
274 
EVEN = PAIR
275 
EXP = EXP
276 
FACT = FACT
277 
FACTDOUBLE = FACTDOUBLE
278 
FLOOR.MATH = PLANCHER.MATH
279 
FLOOR.PRECISE = PLANCHER.PRECIS
280 
GCD = PGCD
281 
INT = ENT
282 
ISO.CEILING = ISO.PLAFOND
283 
LCM = PPCM
284 
LN = LN
285 
LOG = LOG
286 
LOG10 = LOG10
287 
MDETERM = DETERMAT
288 
MINVERSE = INVERSEMAT
289 
MMULT = PRODUITMAT
290 
MOD = MOD
291 
MROUND = ARRONDI.AU.MULTIPLE
292 
MULTINOMIAL = MULTINOMIALE
293 
MUNIT = MATRICE.UNITAIRE
294 
ODD = IMPAIR
295 
PI = PI
296 
POWER = PUISSANCE
297 
PRODUCT = PRODUIT
298 
QUOTIENT = QUOTIENT
299 
RADIANS = RADIANS
300 
RAND = ALEA
301 
RANDBETWEEN = ALEA.ENTRE.BORNES
302 
ROMAN = ROMAIN
303 
ROUND = ARRONDI
304 
ROUNDDOWN = ARRONDI.INF
305 
ROUNDUP = ARRONDI.SUP
306 
SEC = SEC
307 
SECH = SECH
308 
SERIESSUM = SOMME.SERIES
309 
SIGN = SIGNE
310 
SIN = SIN
311 
SINH = SINH
312 
SQRT = RACINE
313 
SQRTPI = RACINE.PI
314 
SUBTOTAL = SOUS.TOTAL
315 
SUM = SOMME
316 
SUMIF = SOMME.SI
317 
SUMIFS = SOMME.SI.ENS
318 
SUMPRODUCT = SOMMEPROD
319 
SUMSQ = SOMME.CARRES
320 
SUMX2MY2 = SOMME.X2MY2
321 
SUMX2PY2 = SOMME.X2PY2
322 
SUMXMY2 = SOMME.XMY2
323 
TAN = TAN
324 
TANH = TANH
325 
TRUNC = TRONQUE
326 
 
327 
##
328 
## Fonctions statistiques (Statistical Functions)
329 
##
330 
AVEDEV = ECART.MOYEN
331 
AVERAGE = MOYENNE
332 
AVERAGEA = AVERAGEA
333 
AVERAGEIF = MOYENNE.SI
334 
AVERAGEIFS = MOYENNE.SI.ENS
335 
BETA.DIST = LOI.BETA.N
336 
BETA.INV = BETA.INVERSE.N
337 
BINOM.DIST = LOI.BINOMIALE.N
338 
BINOM.DIST.RANGE = LOI.BINOMIALE.SERIE
339 
BINOM.INV = LOI.BINOMIALE.INVERSE
340 
CHISQ.DIST = LOI.KHIDEUX.N
341 
CHISQ.DIST.RT = LOI.KHIDEUX.DROITE
342 
CHISQ.INV = LOI.KHIDEUX.INVERSE
343 
CHISQ.INV.RT = LOI.KHIDEUX.INVERSE.DROITE
344 
CHISQ.TEST = CHISQ.TEST
345 
CONFIDENCE.NORM = INTERVALLE.CONFIANCE.NORMAL
346 
CONFIDENCE.T = INTERVALLE.CONFIANCE.STUDENT
347 
CORREL = COEFFICIENT.CORRELATION
348 
COUNT = NB
349 
COUNTA = NBVAL
350 
COUNTBLANK = NB.VIDE
351 
COUNTIF = NB.SI
352 
COUNTIFS = NB.SI.ENS
353 
COVARIANCE.P = COVARIANCE.PEARSON
354 
COVARIANCE.S = COVARIANCE.STANDARD
355 
DEVSQ = SOMME.CARRES.ECARTS
356 
EXPON.DIST = LOI.EXPONENTIELLE.N
357 
F.DIST = LOI.F.N
358 
F.DIST.RT = LOI.F.DROITE
359 
F.INV = INVERSE.LOI.F.N
360 
F.INV.RT = INVERSE.LOI.F.DROITE
361 
F.TEST = F.TEST
362 
FISHER = FISHER
363 
FISHERINV = FISHER.INVERSE
364 
FORECAST.ETS = PREVISION.ETS
365 
FORECAST.ETS.CONFINT = PREVISION.ETS.CONFINT
366 
FORECAST.ETS.SEASONALITY = PREVISION.ETS.CARACTERESAISONNIER
367 
FORECAST.ETS.STAT = PREVISION.ETS.STAT
368 
FORECAST.LINEAR = PREVISION.LINEAIRE
369 
FREQUENCY = FREQUENCE
370 
GAMMA = GAMMA
371 
GAMMA.DIST = LOI.GAMMA.N
372 
GAMMA.INV = LOI.GAMMA.INVERSE.N
373 
GAMMALN = LNGAMMA
374 
GAMMALN.PRECISE = LNGAMMA.PRECIS
375 
GAUSS = GAUSS
376 
GEOMEAN = MOYENNE.GEOMETRIQUE
377 
GROWTH = CROISSANCE
378 
HARMEAN = MOYENNE.HARMONIQUE
379 
HYPGEOM.DIST = LOI.HYPERGEOMETRIQUE.N
380 
INTERCEPT = ORDONNEE.ORIGINE
381 
KURT = KURTOSIS
382 
LARGE = GRANDE.VALEUR
383 
LINEST = DROITEREG
384 
LOGEST = LOGREG
385 
LOGNORM.DIST = LOI.LOGNORMALE.N
386 
LOGNORM.INV = LOI.LOGNORMALE.INVERSE.N
387 
MAX = MAX
388 
MAXA = MAXA
389 
MAXIFS = MAX.SI
390 
MEDIAN = MEDIANE
391 
MIN = MIN
392 
MINA = MINA
393 
MINIFS = MIN.SI
394 
MODE.MULT = MODE.MULTIPLE
395 
MODE.SNGL = MODE.SIMPLE
396 
NEGBINOM.DIST = LOI.BINOMIALE.NEG.N
397 
NORM.DIST = LOI.NORMALE.N
398 
NORM.INV = LOI.NORMALE.INVERSE.N
399 
NORM.S.DIST = LOI.NORMALE.STANDARD.N
400 
NORM.S.INV = LOI.NORMALE.STANDARD.INVERSE.N
401 
PEARSON = PEARSON
402 
PERCENTILE.EXC = CENTILE.EXCLURE
403 
PERCENTILE.INC = CENTILE.INCLURE
404 
PERCENTRANK.EXC = RANG.POURCENTAGE.EXCLURE
405 
PERCENTRANK.INC = RANG.POURCENTAGE.INCLURE
406 
PERMUT = PERMUTATION
407 
PERMUTATIONA = PERMUTATIONA
408 
PHI = PHI
409 
POISSON.DIST = LOI.POISSON.N
410 
PROB = PROBABILITE
411 
QUARTILE.EXC = QUARTILE.EXCLURE
412 
QUARTILE.INC = QUARTILE.INCLURE
413 
RANK.AVG = MOYENNE.RANG
414 
RANK.EQ = EQUATION.RANG
415 
RSQ = COEFFICIENT.DETERMINATION
416 
SKEW = COEFFICIENT.ASYMETRIE
417 
SKEW.P = COEFFICIENT.ASYMETRIE.P
418 
SLOPE = PENTE
419 
SMALL = PETITE.VALEUR
420 
STANDARDIZE = CENTREE.REDUITE
421 
STDEV.P = ECARTYPE.PEARSON
422 
STDEV.S = ECARTYPE.STANDARD
423 
STDEVA = STDEVA
424 
STDEVPA = STDEVPA
425 
STEYX = ERREUR.TYPE.XY
426 
T.DIST = LOI.STUDENT.N
427 
T.DIST.2T = LOI.STUDENT.BILATERALE
428 
T.DIST.RT = LOI.STUDENT.DROITE
429 
T.INV = LOI.STUDENT.INVERSE.N
430 
T.INV.2T = LOI.STUDENT.INVERSE.BILATERALE
431 
T.TEST = T.TEST
432 
TREND = TENDANCE
433 
TRIMMEAN = MOYENNE.REDUITE
434 
VAR.P = VAR.P.N
435 
VAR.S = VAR.S
436 
VARA = VARA
437 
VARPA = VARPA
438 
WEIBULL.DIST = LOI.WEIBULL.N
439 
Z.TEST = Z.TEST
440 
 
441 
##
442 
## Fonctions de texte (Text Functions)
443 
##
444 
BAHTTEXT = BAHTTEXT
445 
CHAR = CAR
446 
CLEAN = EPURAGE
447 
CODE = CODE
448 
CONCAT = CONCAT
449 
DOLLAR = DEVISE
450 
EXACT = EXACT
451 
FIND = TROUVE
452 
FIXED = CTXT
453 
LEFT = GAUCHE
454 
LEN = NBCAR
455 
LOWER = MINUSCULE
456 
MID = STXT
457 
NUMBERVALUE = VALEURNOMBRE
458 
PHONETIC = PHONETIQUE
459 
PROPER = NOMPROPRE
460 
REPLACE = REMPLACER
461 
REPT = REPT
462 
RIGHT = DROITE
463 
SEARCH = CHERCHE
464 
SUBSTITUTE = SUBSTITUE
465 
T = T
466 
TEXT = TEXTE
467 
TEXTJOIN = JOINDRE.TEXTE
468 
TRIM = SUPPRESPACE
469 
UNICHAR = UNICAR
470 
UNICODE = UNICODE
471 
UPPER = MAJUSCULE
472 
VALUE = CNUM
473 
 
474 
##
475 
## Fonctions web (Web Functions)
476 
##
477 
ENCODEURL = URLENCODAGE
478 
FILTERXML = FILTRE.XML
479 
WEBSERVICE = SERVICEWEB
480 
 
481 
##
482 
## Fonctions de compatibilité (Compatibility Functions)
483 
##
484 
BETADIST = LOI.BETA
485 
BETAINV = BETA.INVERSE
486 
BINOMDIST = LOI.BINOMIALE
487 
CEILING = PLAFOND
488 
CHIDIST = LOI.KHIDEUX
489 
CHIINV = KHIDEUX.INVERSE
490 
CHITEST = TEST.KHIDEUX
491 
CONCATENATE = CONCATENER
492 
CONFIDENCE = INTERVALLE.CONFIANCE
493 
COVAR = COVARIANCE
494 
CRITBINOM = CRITERE.LOI.BINOMIALE
495 
EXPONDIST = LOI.EXPONENTIELLE
496 
FDIST = LOI.F
497 
FINV = INVERSE.LOI.F
498 
FLOOR = PLANCHER
499 
FORECAST = PREVISION
500 
FTEST = TEST.F
501 
GAMMADIST = LOI.GAMMA
502 
GAMMAINV = LOI.GAMMA.INVERSE
503 
HYPGEOMDIST = LOI.HYPERGEOMETRIQUE
504 
LOGINV = LOI.LOGNORMALE.INVERSE
505 
LOGNORMDIST = LOI.LOGNORMALE
506 
MODE = MODE
507 
NEGBINOMDIST = LOI.BINOMIALE.NEG
508 
NORMDIST = LOI.NORMALE
509 
NORMINV = LOI.NORMALE.INVERSE
510 
NORMSDIST = LOI.NORMALE.STANDARD
511 
NORMSINV = LOI.NORMALE.STANDARD.INVERSE
512 
PERCENTILE = CENTILE
513 
PERCENTRANK = RANG.POURCENTAGE
514 
POISSON = LOI.POISSON
515 
QUARTILE = QUARTILE
516 
RANK = RANG
517 
STDEV = ECARTYPE
518 
STDEVP = ECARTYPEP
519 
TDIST = LOI.STUDENT
520 
TINV = LOI.STUDENT.INVERSE
521 
TTEST = TEST.STUDENT
522 
VAR = VAR
523 
VARP = VAR.P
524 
WEIBULL = LOI.WEIBULL
525 
ZTEST = TEST.Z