1#!/usr/local/bin/perl -w 2 3############################################################################### 4# 5# Generate function names for different locales. 6# 7# This program can be used to generate the hash of known functions for use in 8# the Formula.pm module. By default the function names are in English but you 9# can also choose to support the following languages: German, French, Spanish, 10# Portuguese, Dutch, Finnish, Italian and Swedish. 11# 12# This would allow you to do something like the following: 13# 14# $worksheet->write(0, 0, '=SUM(C1:C3)' ); 15# $worksheet->write(1, 0, '=SUMME(C1:C3)'); 16# $worksheet->write(2, 0, '=SOMME(C1:C3)'); 17# $worksheet->write(3, 0, '=SUMA(C1:C3)' ); 18# $worksheet->write(4, 0, '=SOMA(C1:C3)' ); 19# $worksheet->write(5, 0, '=SOM(C1:C3)' ); 20# $worksheet->write(6, 0, '=SUMMA(C1:C3)'); 21# $worksheet->write(7, 0, '=SOMMA(C1:C3)'); 22# 23# Unfortunately, if you wish to support more than one language there are some 24# conflicts between function names: 25# 26# Function Language 1 Language 2 27# ======== ========== ========== 28# NB French Dutch 29# NA English/French Finnish 30# TRIM French English 31# DIA Spanish/Portuguese German 32# 33# Therefore, if you try to generate a hash of function names to support both 34# French and English then the function TRIM will be assigned the meaning of the 35# first language that defines it, which in this case is French. You can get 36# around this by renaming the function for one of the languages and documenting 37# the change, for example: TRIM.EN or TRIM.FR. 38# 39# Please note that this only partially solves the problem of localisation. 40# There are also number formats to consider (1.5 == 1,5) and the fact that the 41# list separator "," and the array separator ";" are interchanged in different 42# locales. 43# 44# The longest function name is LOI.NORMALE.STANDARD.INVERSE (29 chars) followed 45# by NORM.JAKAUMA.NORMIT.K��NT (25 chars). 46# The shortest function name in all languages is T. 47# 48# 49# reverse('�'); John McNamara, March 2001, jmcnamara@cpan.org 50# 51 52 53 54use strict; 55 56 57# 58# Modify the following variables to add the language to the function name hash 59# 60my $english = 1; 61my $german = 0; 62my $french = 0; 63my $spanish = 0; 64my $portuguese = 0; 65my $dutch = 0; 66my $finnish = 0; 67my $italian = 0; 68my $swedish = 0; 69 70my %funcs; 71 72# Ignore the headings 73<DATA>; 74 75# Print the beginning of the hash definition 76print " %functions = (\n"; 77print " #" . " " x 37 ; 78print "ptg args class vol\n"; 79 80while (<DATA>){ 81 my @F = split " "; 82 my $value = $F[0]; 83 my $args = $F[1]; 84 my $ref = $F[2]; 85 my $vol = $F[3]; 86 87 print_function($F[4], $value, $args, $ref, $vol) if $english; 88 print_function($F[5], $value, $args, $ref, $vol) if $german; 89 print_function($F[6], $value, $args, $ref, $vol) if $french; 90 print_function($F[7], $value, $args, $ref, $vol) if $spanish; 91 print_function($F[8], $value, $args, $ref, $vol) if $portuguese; 92 print_function($F[9], $value, $args, $ref, $vol) if $dutch; 93 print_function($F[10], $value, $args, $ref, $vol) if $finnish; 94 print_function($F[11], $value, $args, $ref, $vol) if $italian; 95 print_function($F[12], $value, $args, $ref, $vol) if $swedish; 96} 97# Print the end of the hash definition 98print " );\n"; 99 100 101############################################################################### 102# 103# Function to print the function names. It prints a warning if there is a 104# clash. 105# 106sub print_function { 107 108 my $func = shift; 109 my $value = shift; 110 my $args = shift; 111 my $ref = shift; 112 my $vol = shift; 113 114 $func = "'$func'"; 115 116 if (not exists $funcs{$func}) { 117 printf(" %-31s => [%4d, %4d, %4d, %4d ],\n", 118 $func, $value, $args, $ref, $vol); 119 $funcs{$func} = $value; 120 } 121 else { 122 if ($funcs{$func} != $value) { 123 print " # Warning "; 124 print $func, " is already defined in another language\n"; 125 printf(" #%-31s => [%4d, %4d, %4d, %4d ],\n", 126 $func, $value, $args, $ref, $vol); 127 } 128 } 129} 130 131 132# Note: The following data contains the function names in the various 133# languages. These lines are LONG. 134 135__DATA__ 136Value Args Refclass Volatile English German French Spanish Portuguese Dutch Finnish Italian Swedish 1370 -1 0 0 COUNT ANZAHL NB CONTAR CONT.N�M AANTAL LASKE CONTA.NUMERI ANTAL 1381 -1 1 0 IF WENN SI SI SE ALS JOS SE OM 1392 1 1 0 ISNA ISTNV ESTNA ESNOD �.N�O.DISP ISNB ONPUUTTUU VAL.NON.DISP �RSAKNAD 1403 1 1 0 ISERROR ISTFEHLER ESTERREUR ESERROR �ERROS ISFOUT ONVIRHE VAL.ERRORE �RFEL 1414 -1 0 0 SUM SUMME SOMME SUMA SOMA SOM SUMMA SOMMA SUMMA 1425 -1 0 0 AVERAGE MITTELWERT MOYENNE PROMEDIO M�DIA GEMIDDELDE KESKIARVO MEDIA MEDEL 1436 -1 0 0 MIN MIN MIN MIN M�NIMO MIN MIN MIN MIN 1447 -1 0 0 MAX MAX MAX MAX M�XIMO MAX MAKS MAX MAX 1458 -1 0 0 ROW ZEILE LIGNE FILA LIN RIJ RIVI RIF.RIGA RAD 1469 -1 0 0 COLUMN SPALTE COLONNE COLUMNA COL KOLOM SARAKE RIF.COLONNA KOLUMN 14710 0 0 0 NA NV NA NOD N�O.DISP NB PUUTTUU NON.DISP SAKNAS 14811 -1 1 0 NPV NBW VAN VNA VPL NHW NNA VAN NETNUV�RDE 14912 -1 0 0 STDEV STABW ECARTYPE DESVEST DESVPAD STDEV KESKIHAJONTA DEV.ST STDAV 15013 -1 1 0 DOLLAR DM FRANC MONEDA MOEDA GULDEN VALUUTTA VALUTA VALUTA 15114 -1 1 0 FIXED FEST CTXT DECIMAL DEF.N�M.DEC VAST KIINTE� FISSO FASTTAL 15215 1 1 0 SIN SIN SIN SENO SEN SIN SIN SEN SIN 15316 1 1 0 COS COS COS COS COS COS COS COS COS 15417 1 1 0 TAN TAN TAN TAN TAN TAN TAN TAN TAN 15518 1 1 0 ATAN ARCTAN ATAN ATAN ATAN BOOGTAN ATAN ARCTAN ARCTAN 15619 0 1 0 PI PI PI PI PI PI PII PI.GRECO PI 15720 1 1 0 SQRT WURZEL RACINE RAIZ RAIZ WORTEL NELI�JUURI RADQ ROT 15821 1 1 0 EXP EXP EXP EXP EXP EXP EKSPONENTTI EXP EXP 15922 1 1 0 LN LN LN LN LN LN LUONNLOG LN LN 16023 1 1 0 LOG10 LOG10 LOG10 LOG10 LOG10 LOG10 LOG10 LOG10 LOG10 16124 1 1 0 ABS ABS ABS ABS ABS ABS ITSEISARVO ASS ABS 16225 1 1 0 INT GANZZAHL ENT ENTERO INT INTEGER KOKONAISLUKU INT HELTAL 16326 1 1 0 SIGN VORZEICHEN SIGNE SIGNO SINAL POS.NEG ETUMERKKI SEGNO TECKEN 16427 2 1 0 ROUND RUNDEN ARRONDI REDONDEAR ARRED AFRONDEN PY�RIST� ARROTONDA AVRUNDA 16528 -1 0 0 LOOKUP VERWEIS RECHERCHE BUSCAR PROC ZOEKEN HAKU CERCA LETAUPP 16629 -1 0 1 INDEX INDEX INDEX INDICE �NDICE INDEX INDEKSI INDICE INDEX 16730 2 1 0 REPT WIEDERHOLEN REPT REPETIR REPETIR HERHALING TOISTA RIPETI REP 16831 3 1 0 MID TEIL STXT EXTRAE EXT.TEXTO DEEL POIMI.TEKSTI STRINGA.ESTRAI EXTEXT 16932 1 1 0 LEN L�NGE NBCAR LARGO N�M.CARACT LENGTE PITUUS LUNGHEZZA L�NGD 17033 1 1 0 VALUE WERT CNUM VALOR VALOR WAARDE ARVO VALORE TEXTNUM 17134 0 1 0 TRUE WAHR VRAI VERDADERO VERDADEIRO WAAR TOSI VERO SANT 17235 0 1 0 FALSE FALSCH FAUX FALSO FALSO ONWAAR EP�TOSI FALSO FALSKT 17336 -1 0 0 AND UND ET Y E EN JA E OCH 17437 -1 0 0 OR ODER OU O OU OF TAI O ELLER 17538 1 1 0 NOT NICHT NON NO N�O NIET EI NON ICKE 17639 2 1 0 MOD REST MOD RESIDUO MOD REST JAKOJ RESTO REST 17740 3 0 0 DCOUNT DBANZAHL BDNB BDCONTAR BDCONTAR DBAANTAL TLASKE DB.CONTA.NUMERI DANTAL 17841 3 0 0 DSUM DBSUMME BDSOMME BDSUMA BDSOMA DBSOM TSUMMA DB.SOMMA DSUMMA 17942 3 0 0 DAVERAGE DBMITTELWERT BDMOYENNE BDPROMEDIO BDM�DIA DBGEMIDDELDE TKESKIARVO DB.MEDIA DMEDEL 18043 3 0 0 DMIN DBMIN BDMIN BDMIN BDM�N DBMIN TMIN DB.MIN DMIN 18144 3 0 0 DMAX DBMAX BDMAX BDMAX BDM�X DBMAX TMAKS DB.MAX DMAX 18245 3 0 0 DSTDEV DBSTDABW BDECARTYPE BDDESVEST BDEST DBSTDEV TKESKIHAJONTA DB.DEV.ST DSTDAV 18346 -1 0 0 VAR VARIANZ VAR VAR VAR VAR VAR VAR VARIANS 18447 3 0 0 DVAR DBVARIANZ BDVAR BDVAR BDVAREST DBVAR TVARIANSSI DB.VAR DVARIANS 18548 2 1 0 TEXT TEXT TEXTE TEXTO TEXTO TEKST TEKSTI TESTO TEXT 18649 -1 0 0 LINEST RGP DROITEREG ESTIMACION.LINEAL PROJ.LIN LIJNSCH LINREGR REGR.LIN REGR 18750 -1 0 0 TREND TREND TENDANCE TENDENCIA TEND�NCIA TREND SUUNTAUS TENDENZA TREND 18851 -1 0 0 LOGEST RKP LOGREG ESTIMACION.LOGARITMICA PROJ.LOG LOGSCH LOGREGR REGR.LOG EXPREGR 18952 -1 0 0 GROWTH VARIATION CROISSANCE CRECIMIENTO CRESCIMENTO GROEI KASVU CRESCITA EXPTREND 19056 -1 1 0 PV BW VA VA VP HW NA VA NUV�RDE 19157 -1 1 0 FV ZW VC VF VF TW TULEVA.ARVO VAL.FUT SLUTV�RDE 19258 -1 1 0 NPER ZZR NPM NPER NPER NPER NJAKSO NUM.RATE PERIODER 19359 -1 1 0 PMT RMZ VPM PAGO PGTO BET MAKSU RATA BETALNING 19460 -1 1 0 RATE ZINS TAUX TASA TAXA RENTE KORKO TASSO R�NTA 19561 3 0 0 MIRR QIKV TRIM TIRM MTIR GIR MSIS�INEN TIR.VAR MODIR 19662 -1 0 0 IRR IKV TRI TIR TIR IR SIS�INEN.KORKO TIR.COST IR 19763 0 1 1 RAND ZUFALLSZAHL ALEA ALEATORIO ALEAT�RIO ASELECT SATUNNAISLUKU CASUALE SLUMP 19864 -1 0 0 MATCH VERGLEICH EQUIV COINCIDIR CORRESP VERGELIJKEN VASTINE CONFRONTA PASSA 19965 3 1 0 DATE DATUM DATE FECHA DATA DATUM P�IV�YS DATA DATUM 20066 3 1 0 TIME ZEIT TEMPS NSHORA TEMPO TIJD AIKA ORARIO KLOCKSLAG 20167 1 1 0 DAY TAG JOUR DIA DIA DAG P�IV� GIORNO DAG 20268 1 1 0 MONTH MONAT MOIS MES M�S MAAND KUUKAUSI MESE M�NAD 20369 1 1 0 YEAR JAHR ANNEE A�O ANO JAAR VUOSI ANNO �R 20470 -1 1 0 WEEKDAY WOCHENTAG JOURSEM DIASEM DIA.DA.SEMANA WEEKDAG VIIKONP�IV� GIORNO.SETTIMANA VECKODAG 20571 1 1 0 HOUR STUNDE HEURE HORA HORA UUR TUNNIT ORA TIMME 20672 1 1 0 MINUTE MINUTE MINUTE MINUTO MINUTO MINUUT MINUUTIT MINUTO MINUT 20773 1 1 0 SECOND SEKUNDE SECONDE SEGUNDO SEGUNDO SECONDE SEKUNNIT SECONDO SEKUND 20874 0 1 1 NOW JETZT MAINTENANT AHORA AGORA NU NYT ADESSO NU 20975 1 0 1 AREAS BEREICHE ZONES AREAS �REAS BEREIKEN ALUEET AREE OMR�DEN 21076 1 0 1 ROWS ZEILEN LIGNES FILAS LINS RIJEN RIVIT RIGHE RADER 21177 1 0 1 COLUMNS SPALTEN COLONNES COLUMNAS COLS KOLOMMEN SARAKKEET COLONNE KOLUMNER 21278 -1 0 1 OFFSET BEREICH.VERSCHIEBEN DECALER DESREF DESLOC VERSCHUIVING SIIRTYM� SCARTO F�RSKJUTNING 21382 -1 1 0 SEARCH SUCHEN CHERCHE HALLAR LOCALIZAR VIND.SPEC K�Y.L�PI RICERCA S�K 21483 1 1 0 TRANSPOSE MTRANS TRANSPOSE TRANSPONER TRANSPOR TRANSPONEREN TRANSPONOI MATR.TRASPOSTA TRANSPONERA 21586 1 1 0 TYPE TYP TYPE TIPO TIPO TYPE TYYPPI TIPO V�RDETYP 21697 2 1 0 ATAN2 ARCTAN2 ATAN2 ATAN2 ATAN2 BOOGTAN2 ATAN2 ARCTAN.2 ARCTAN2 21798 1 1 0 ASIN ARCSIN ASIN ASENO ASEN BOOGSIN ASIN ARCSEN ARCSIN 21899 1 1 0 ACOS ARCCOS ACOS ACOS ACOS BOOGCOS ACOS ARCCOS ARCCOS 219100 -1 1 0 CHOOSE WAHL CHOISIR ELEGIR ESCOLHER KIEZEN VALITSE.INDEKSI SCEGLI V�LJ 220101 -1 0 0 HLOOKUP WVERWEIS RECHERCHEH BUSCARH PROCH HORIZ.ZOEKEN VHAKU CERCA.ORIZZ LETAKOLUMN 221102 -1 0 0 VLOOKUP SVERWEIS RECHERCHEV BUSCARV PROCV VERT.ZOEKEN PHAKU CERCA.VERT LETARAD 222105 1 0 0 ISREF ISTBEZUG ESTREF ESREF �REF ISVERWIJZING ONVIITT VAL.RIF �RREF 223109 -1 1 0 LOG LOG LOG LOG LOG LOG LOG LOG LOG 224111 1 1 0 CHAR ZEICHEN CAR CARACTER CARACT TEKEN MERKKI CODICE.CARATT TECKENKOD 225112 1 1 0 LOWER KLEIN MINUSCULE MINUSC MIN�SCULA KLEINE.LETTERS PIENET MINUSC GEMENER 226113 1 1 0 UPPER GROSS MAJUSCULE MAYUSC MAI�SCULA HOOFDLETTERS ISOT MAIUSC VERSALER 227114 1 1 0 PROPER GROSS2 NOMPROPRE NOMPROPIO PRI.MAI�SCULA BEGINLETTERS ERISNIMI MAIUSC.INIZ INITIAL 228115 -1 1 0 LEFT LINKS GAUCHE IZQUIERDA ESQUERDA LINKS VASEN SINISTRA V�NSTER 229116 -1 1 0 RIGHT RECHTS DROITE DERECHA DIREITA RECHTS OIKEA DESTRA H�GER 230117 2 1 0 EXACT IDENTISCH EXACT IGUAL EXATO GELIJK VERTAA IDENTICO EXAKT 231118 1 1 0 TRIM GL�TTEN SUPPRESPACE ESPACIOS ARRUMAR SPATIES.WISSEN POISTA.V�LIT ANNULLA.SPAZI RENSA 232119 4 1 0 REPLACE ERSETZEN REMPLACER REEMPLAZAR MUDAR VERVANGEN KORVAA RIMPIAZZA ERS�TT 233120 -1 1 0 SUBSTITUTE WECHSELN SUBSTITUE SUSTITUIR SUBSTITUIR SUBSTITUEREN VAIHDA SOSTITUISCI BYT.UT 234121 1 1 0 CODE CODE CODE CODIGO C�DIGO CODE KOODI CODICE KOD 235124 -1 1 0 FIND FINDEN TROUVE ENCONTRAR PROCURAR VIND.ALLES ETSI TROVA HITTA 236125 -1 0 1 CELL ZELLE CELLULE CELDA C�L CEL SOLU CELLA CELL 237126 1 1 0 ISERR ISTFEHL ESTERR ESERR �ERRO ISFOUT2 ONVIRH VAL.ERR �RF 238127 1 1 0 ISTEXT ISTTEXT ESTTEXTE ESTEXTO �TEXTO ISTEKST ONTEKSTI VAL.TESTO �RTEXT 239128 1 1 0 ISNUMBER ISTZAHL ESTNUM ESNUMERO �N�M ISGETAL ONLUKU VAL.NUMERO �RTAL 240129 1 1 0 ISBLANK ISTLEER ESTVIDE ESBLANCO �C�L.VAZIA ISLEEG ONTYHJ� VAL.VUOTO �RTOM 241130 1 0 0 T T T T T T T T T 242131 1 0 0 N N N N N N N NUM N 243140 1 1 0 DATEVALUE DATWERT DATEVAL FECHANUMERO DATA.VALOR DATUMWAARDE P�IV�YSARVO DATA.VALORE DATUMV�RDE 244141 1 1 0 TIMEVALUE ZEITWERT TEMPSVAL HORANUMERO VALOR.TEMPO TIJDWAARDE AIKA_ARVO ORARIO.VALORE TIDV�RDE 245142 3 1 0 SLN LIA AMORLIN SLN DPD LIN.AFSCHR STP AMMORT.COST LINAVSKR 246143 4 1 0 SYD DIA SYD SYD SDA SYD VUOSIPOISTO AMMORT.ANNUO �RSAVSKR 247144 -1 1 0 DDB GDA DDB DDB BDD DDB DDB AMMORT DEGAVSKR 248148 -1 1 1 INDIRECT INDIREKT INDIRECT INDIRECTO INDIRETO INDIRECT EP�SUORA INDIRETTO INDIREKT 249150 -1 1 0 CALL AUFRUFEN FONCTION.APPELANTE LLAMAR CHAMAR ROEPEN KUTSU RICHIAMA ANROPA 250162 1 1 0 CLEAN S�UBERN EPURAGE LIMPIAR TIRAR WISSEN.CONTROL SIIVOA LIBERA ST�DA 251163 1 2 0 MDETERM MDET DETERMAT MDETERM MATRIZ.DETERM DETERMINANTMAT MDETERM MATR.DETERM MDETERM 252164 1 2 0 MINVERSE MINV INVERSEMAT MINVERSA MATRIZ.INVERSO INVERSEMAT MK��NTEINEN MATR.INVERSA MINVERT 253165 2 2 0 MMULT MMULT PRODUITMAT MMULT MATRIZ.MULT PRODUKTMAT MKERRO MATR.PRODOTTO MMULT 254167 -1 1 0 IPMT ZINSZ INTPER PAGOINT IPGTO IBET IPMT INTERESSI RBETALNING 255168 -1 1 0 PPMT KAPZ PRINCPER PAGOPRIN PPGTO PBET PPMT P.RATA AMORT 256169 -1 0 0 COUNTA ANZAHL2 NBVAL CONTARA CONT.VALORES AANTALARG LASKE.A CONTA.VALORI ANTALV 257183 -1 0 0 PRODUCT PRODUKT PRODUIT PRODUCTO MULT PRODUKT TULO PRODOTTO PRODUKT 258184 1 1 0 FACT FAKULT�T FACT FACT FATORIAL FACULTEIT KERTOMA FATTORIALE FAKULTET 259189 3 0 0 DPRODUCT DBPRODUKT BDPRODUIT BDPRODUCTO BDMULTIPL DBPRODUKT TTULO DB.PRODOTTO DPRODUKT 260190 1 1 0 ISNONTEXT ISTKTEXT ESTNONTEXTE ESNOTEXTO �.N�O.TEXTO ISGEENTEKST ONEI_TEKSTI VAL.NON.TESTO �REJTEXT 261193 -1 0 0 STDEVP STABWN ECARTYPEP DESVESTP DESVPADP STDEVP KESKIHAJONTAP DEV.ST.POP STDAVP 262194 -1 0 0 VARP VARIANZEN VAR.P VARP VARP VARP VARP VAR.POP VARIANSP 263195 3 0 0 DSTDEVP DBSTDABWN BDECARTYPEP BDDESVESTP BDDESVPA DBSTDEVP TKESKIHAJONTAP DB.DEV.ST.POP DSTDAVP 264196 3 0 0 DVARP DBVARIANZEN BDVARP BDVARP BDVARP DBVARP TVARIANSSIP DB.VAR.POP DVARIANSP 265197 -1 1 0 TRUNC K�RZEN TRONQUE TRUNCAR TRUNCAR GEHEEL KATKAISE TRONCA AVKORTA 266198 1 1 0 ISLOGICAL ISTLOG ESTLOGIQUE ESLOGICO �L�GICO ISLOGISCH ONTOTUUS VAL.LOGICO �RLOGISK 267199 3 0 0 DCOUNTA DBANZAHL2 BDNBVAL BDCONTARA BDCONTARA DBAANTALC TLASKEA DB.CONTA.VALORI DANTALV 268212 2 1 0 ROUNDUP AUFRUNDEN ARRONDI.SUP REDONDEAR.MAS ARREDONDAR.PARA.CIMA AFRONDEN.NAAR.BOVEN PY�RIST�.DES.YL�S ARROTONDA.PER.ECC AVRUNDA.UPP�T 269213 2 1 0 ROUNDDOWN ABRUNDEN ARRONDI.INF REDONDEAR.MENOS ARREDONDAR.PARA.BAIXO AFRONDEN.NAAR.BENEDEN PY�RIST�.DES.ALAS ARROTONDA.PER.DIF AVRUNDA.NED�T 270216 -1 0 0 RANK RANG RANG JERARQUIA ORDEM RANG ARVON.MUKAAN RANGO RANG 271219 -1 1 0 ADDRESS ADRESSE ADRESSE DIRECCION ENDERE�O ADRES OSOITE INDIRIZZO ADRESS 272220 -1 1 0 DAYS360 TAGE360 JOURS360 DIAS360 DIAS360 DAGEN360 P�IV�T360 GIORNO360 DAGAR360 273221 0 1 1 TODAY HEUTE AUJOURDHUI HOY HOJE VANDAAG T�M�.P�IV� OGGI IDAG 274222 -1 1 0 VDB VDB VDB DVS BDV VDB VDB AMMORT.VAR VDEGRAVSKR 275227 -1 0 0 MEDIAN MEDIAN MEDIANE MEDIANA MED MEDIAAN MEDIAANI MEDIANA MEDIAN 276228 -1 2 0 SUMPRODUCT SUMMENPRODUKT SOMMEPROD SUMAPRODUCTO SOMARPRODUTO SOMPRODUKT TULOJEN.SUMMA MATR.SOMMA.PRODOTTO PRODUKTSUMMA 277229 1 1 0 SINH SINHYP SINH SENOH SENH SINH SINH SENH SINH 278230 1 1 0 COSH COSHYP COSH COSH COSH COSH COSH COSH COSH 279231 1 1 0 TANH TANHYP TANH TANH TANH TANH TANH TANH TANH 280232 1 1 0 ASINH ARCSINHYP ASINH ASENOH ASENH BOOGSINH ASINH ARCSENH ARCSINH 281233 1 1 0 ACOSH ARCCOSHYP ACOSH ACOSH ACOSH BOOGCOSH ACOSH ARCCOSH ARCCOSH 282234 1 1 0 ATANH ARCTANHYP ATANH ATANH ATANH BOOGTANH ATANH ARCTANH ARCTANH 283235 3 0 0 DGET DBAUSZUG BDLIRE BDEXTRAER BDEXTRAIR DBLEZEN TNOUDA DB.VALORI DH�MTA 284244 1 1 1 INFO INFO INFO INFO INFORMA��O INFO KUVAUS AMBIENTE.INFO INFO 285247 -1 1 0 DB GDA2 DB DB BD DB DB AMMORT.FISSO DB 286252 2 0 0 FREQUENCY H�UFIGKEIT FREQUENCE FRECUENCIA FREQ��NCIA INTERVAL TAAJUUS FREQUENZA FREKVENS 287261 1 1 0 ERROR.TYPE FEHLER.TYP TYPE.ERREUR TIPO.DE.ERROR TIPO.ERRO TYPE.FOUT VIRHEEN.LAJI ERRORE.TIPO FEL.TYP 288267 -1 1 0 REGISTER.ID REGISTER.KENNUMMER REGISTRE.NUMERO ID.REGISTRO IDENT.REGISTRO REGISTRATIE.ID REKISTERI.TUNNUS IDENTIFICATORE.REGISTRO REGISTRERA.ID 289269 -1 0 0 AVEDEV MITTELABW ECART.MOYEN DESVPROM DESV.M�DIO GEM.DEVIATIE KESKIPOIKKEAMA MEDIA.DEV MEDELAVV 290270 -1 1 0 BETADIST BETAVERT LOI.BETA DISTR.BETA DISTBETA BETA.VERD BEETAJAKAUMA DISTRIB.BETA BETAF�RD 291271 1 1 0 GAMMALN GAMMALN LNGAMMA GAMMA.LN LNGAMA GAMMA.LN GAMMALN LN.GAMMA GAMMALN 292272 -1 1 0 BETAINV BETAINV BETA.INVERSE DISTR.BETA.INV BETA.ACUM.INV BETA.INV BEETAJAKAUMA.K��NT INV.BETA BETAINV 293273 4 1 0 BINOMDIST BINOMVERT LOI.BINOMIALE DISTR.BINOM DISTRBINOM BINOMIALE.VERD BINOMIJAKAUMA DISTRIB.BINOM BINOMF�RD 294274 2 1 0 CHIDIST CHIVERT LOI.KHIDEUX DISTR.CHI DIST.QUI CHI.KWADRAAT CHIJAKAUMA DISTRIB.CHI CHI2F�RD 295275 2 1 0 CHIINV CHIINV KHIDEUX.INVERSE PRUEBA.CHI.INV INV.QUI CHI.KWADRAAT.INV CHIJAKAUMA.K��NT INV.CHI CHI2INV 296276 2 1 0 COMBIN KOMBINATIONEN COMBIN COMBINAT COMBIN COMBINATIES KOMBINAATIO COMBINAZIONE KOMBIN 297277 3 1 0 CONFIDENCE KONFIDENZ INTERVALLE.CONFIANCE INTERVALO.CONFIANZA INT.CONFIAN�A BETROUWBAARHEID LUOTTAMUSV�LI CONFIDENZA KONFIDENS 298278 3 1 0 CRITBINOM KRITBINOM CRITERE.LOI.BINOMIALE BINOM.CRIT CRIT.BINOM CRIT.BINOM BINOMIJAKAUMA.KRIT CRIT.BINOM KRITBINOM 299279 1 1 0 EVEN GERADE PAIR REDONDEA.PAR PAR EVEN PARILLINEN PARI J�MN 300280 3 1 0 EXPONDIST EXPONVERT LOI.EXPONENTIELLE DISTR.EXP DISTEXPON EXPON.VERD EKSPONENTIAALIJAKAUMA DISTRIB.EXP EXPONF�RD 301281 3 1 0 FDIST FVERT LOI.F DISTR.F DISTF F.VERDELING FJAKAUMA DISTRIB.F FF�RD 302282 3 1 0 FINV FINV INVERSE.LOI.F DISTR.F.INV INVF F.INVERSE FJAKAUMA.K��NT INV.F FINV 303283 1 1 0 FISHER FISHER FISHER FISHER FISHER FISHER FISHER FISHER FISHER 304284 1 1 0 FISHERINV FISHERINV FISHER.INVERSE PRUEBA.FISHER.INV FISHERINV FISHER.INV FISHER.K��NT INV.FISHER FISHERINV 305285 2 1 0 FLOOR UNTERGRENZE PLANCHER MULTIPLO.INFERIOR ARREDMULTB AFRONDEN.BENEDEN PY�RIST�.KERR.ALAS ARROTONDA.DIFETTO RUNDA.NER 306286 4 1 0 GAMMADIST GAMMAVERT LOI.GAMMA DISTR.GAMMA DISTGAMA GAMMA.VERD GAMMAJAKAUMA DISTRIB.GAMMA GAMMAF�RD 307287 3 1 0 GAMMAINV GAMMAINV LOI.GAMMA.INVERSE DISTR.GAMMA.INV INVGAMA GAMMA.INV GAMMAJAKAUMA.K��NT INV.GAMMA GAMMAINV 308288 2 1 0 CEILING OBERGRENZE PLAFOND MULTIPLO.SUPERIOR TETO AFRONDEN.BOVEN PY�RIST�.KERR.YL�S ARROTONDA.ECCESSO RUNDA.UPP 309289 4 1 0 HYPGEOMDIST HYPGEOMVERT LOI.HYPERGEOMETRIQUE DISTR.HIPERGEOM DIST.HIPERGEOM HYPERGEO.VERD HYPERGEOM.JAKAUMA DISTRIB.IPERGEOM HYPGEOMF�RD 310290 3 1 0 LOGNORMDIST LOGNORMVERT LOI.LOGNORMALE DISTR.LOG.NORM DIST.LOGNORMAL LOG.NORM.VERD LOGNORM.JAKAUMA DISTRIB.LOGNORM LOGNORMF�RD 311291 3 1 0 LOGINV LOGINV LOI.LOGNORMALE.INVERSE DISTR.LOG.INV INVLOG LOG.NORM.INV LOGNORM.JAKAUMA.K��NT INV.LOGNORM LOGINV 312292 3 1 0 NEGBINOMDIST NEGBINOMVERT LOI.BINOMIALE.NEG NEGBINOMDIST DIST.BIN.NEG NEG.BINOM.VERD BINOMIJAKAUMA.NEG DISTRIB.BINOM.NEG NEGBINOMF�RD 313293 4 1 0 NORMDIST NORMVERT LOI.NORMALE DISTR.NORM DIST.NORM NORM.VERD NORM.JAKAUMA DISTRIB.NORM NORMF�RD 314294 1 1 0 NORMSDIST STANDNORMVERT LOI.NORMALE.STANDARD DISTR.NORM.ESTAND DIST.NORMP STAND.NORM.VERD NORM.JAKAUMA.NORMIT DISTRIB.NORM.ST NORMSF�RD 315295 3 1 0 NORMINV NORMINV LOI.NORMALE.INVERSE DISTR.NORM.INV INV.NORM NORM.INV NORM.JAKAUMA.K��NT INV.NORM NORMINV 316296 1 1 0 NORMSINV STANDNORMINV LOI.NORMALE.STANDARD.INVERSE DISTR.NORM.ESTAND.INV INV.NORMP STAND.NORM.INV NORM.JAKAUMA.NORMIT.K��NT INV.NORM.ST NORMSINV 317297 3 1 0 STANDARDIZE STANDARDISIERUNG CENTREE.REDUITE NORMALIZACION PADRONIZAR NORMALISEREN NORMITA NORMALIZZA STANDARDISERA 318298 1 1 0 ODD UNGERADE IMPAIR REDONDEA.IMPAR �MPAR ONEVEN PARITON DISPARI UDDA 319299 2 1 0 PERMUT VARIATIONEN PERMUTATION PERMUTACIONES PERMUT PERMUTATIES PERMUTAATIO PERMUTAZIONE PERMUT 320300 3 1 0 POISSON POISSON LOI.POISSON POISSON POISSON POISSON POISSON POISSON POISSON 321301 3 1 0 TDIST TVERT LOI.STUDENT DISTR.T DISTT T.VERD TJAKAUMA DISTRIB.T TF�RD 322302 4 1 0 WEIBULL WEIBULL LOI.WEIBULL DIST.WEIBULL WEIBULL WEIBULL WEIBULL WEIBULL WEIBULL 323303 2 2 0 SUMXMY2 SUMMEXMY2 SOMME.XMY2 SUMAXMENOSY2 SOMAXMY2 SOM.XMINY.2 EROTUSTEN.NELI�SUMMA SOMMA.Q.DIFF SUMMAXMY2 324304 2 2 0 SUMX2MY2 SUMMEX2MY2 SOMME.X2MY2 SUMAX2MENOSY2 SOMAX2DY2 SOM.X2MINY2 NELI�SUMMIEN.EROTUS SOMMA.DIFF.Q SUMMAX2MY2 325305 2 2 0 SUMX2PY2 SUMMEX2PY2 SOMME.X2PY2 SUMAX2MASY2 SOMAX2SY2 SOM.X2PLUSY2 NELI�SUMMIEN.SUMMA SOMMA.SOMMA.Q SUMMAX2PY2 326306 2 2 0 CHITEST CHITEST TEST.KHIDEUX PRUEBA.CHI TESTE.QUI CHI.TOETS CHITESTI TEST.CHI CHI2TEST 327307 2 2 0 CORREL KORREL COEFFICIENT.CORRELATION COEF.DE.CORREL CORREL CORRELATIE KORRELAATIO CORRELAZIONE KORREL 328308 2 2 0 COVAR KOVAR COVARIANCE COVAR COVAR COVARIANTIE KOVARIANSSI COVARIANZA KOVAR 329309 3 2 0 FORECAST SCH�TZER PREVISION PRONOSTICO PREVIS�O VOORSPELLEN ENNUSTE PREVISIONE PREDIKTION 330310 2 2 0 FTEST FTEST TEST.F PRUEBA.F TESTEF F.TOETS FTESTI TEST.F FTEST 331311 2 2 0 INTERCEPT ACHSENABSCHNITT ORDONNEE.ORIGINE INTERSECCION INTERCEP��O SNIJPUNT LEIKKAUSPISTE INTERCETTA SK�RNINGSPUNKT 332312 2 2 0 PEARSON PEARSON PEARSON PEARSON PEARSON PEARSON PEARSON PEARSON PEARSON 333313 2 2 0 RSQ BESTIMMTHEITSMASS COEFFICIENT.DETERMINATION COEFICIENTE.R2 RQUAD R.KWADRAAT PEARSON.NELI� RQ RKV 334314 2 2 0 STEYX STFEHLERYX ERREUR.TYPE.XY ERROR.TIPICO.XY EPADYX STAND.FOUT.YX KESKIVIRHE ERR.STD.YX STDFELYX 335315 2 2 0 SLOPE STEIGUNG PENTE PENDIENTE INCLINA��O RICHTING KULMAKERROIN PENDENZA LUTNING 336316 4 2 0 TTEST TTEST TEST.STUDENT PRUEBA.T TESTET T.TOETS TTESTI TEST.T TTEST 337317 -1 2 0 PROB WAHRSCHBEREICH PROBABILITE PROBABILIDAD PROB KANS TODENN�K�ISYYS PROBABILIT� SANNOLIKHET 338318 -1 0 0 DEVSQ SUMQUADABW SOMME.CARRES.ECARTS DESVIA2 DESVQ DEV.KWAD OIKAISTU.NELI�SUMMA DEV.Q KVADAVV 339319 -1 0 0 GEOMEAN GEOMITTEL MOYENNE.GEOMETRIQUE MEDIA.GEOM M�DIA.GEOM�TRICA MEETK.GEM KESKIARVO.GEOM MEDIA.GEOMETRICA GEOMEDEL 340320 -1 0 0 HARMEAN HARMITTEL MOYENNE.HARMONIQUE MEDIA.ARMO M�DIA.HARM�NICA HARM.GEM KESKIARVO.HARM MEDIA.ARMONICA HARMMEDEL 341321 -1 0 0 SUMSQ QUADRATESUMME SOMME.CARRES SUMA.CUADRADOS SOMAQUAD KWADRATENSOM NELI�SUMMA SOMMA.Q KVADRATSUMMA 342322 -1 0 0 KURT KURT KURTOSIS CURTOSIS CURT KURTOSIS KURT CURTOSI TOPPIGHET 343323 -1 0 0 SKEW SCHIEFE COEFFICIENT.ASYMETRIE COEFICIENTE.ASIMETRIA DISTOR��O SCHEEFHEID JAKAUMAN.VINOUS ASIMMETRIA SNEDHET 344324 -1 0 0 ZTEST GTEST TEST.Z PRUEBA.Z TESTEZ Z.TOETS ZTESTI TEST.Z ZTEST 345325 2 0 0 LARGE KGR�SSTE GRANDE.VALEUR K.ESIMO.MAYOR MAIOR GROOTSTE SUURI GRANDE ST�RSTA 346326 2 0 0 SMALL KKLEINSTE PETITE.VALEUR K.ESIMO.MENOR MENOR KLEINSTE PIENI PICCOLO MINSTA 347327 2 0 0 QUARTILE QUARTILE QUARTILE CUARTIL QUARTIL KWARTIEL NELJ�NNES QUARTILE KVARTIL 348328 2 0 0 PERCENTILE QUANTIL CENTILE PERCENTIL PERCENTIL PERCENTIEL PROSENTTIPISTE PERCENTILE PERCENTIL 349329 -1 0 0 PERCENTRANK QUANTILSRANG RANG.POURCENTAGE RANGO.PERCENTIL ORDEM.PORCENTUAL PERCENT.RANG PROSENTTIJ�RJESTYS PERCENT.RANGO PROCENTRANG 350330 -1 2 0 MODE MODALWERT MODE MODA MODO MODUS MOODI MODA TYPV�RDE 351331 2 0 0 TRIMMEAN GESTUTZTMITTEL MOYENNE.REDUITE MEDIA.ACOTADA M�DIA.INTERNA GETRIMD.GEM KESKIARVO.TASATTU MEDIA.TRONCATA TRIMMEDEL 352332 2 1 0 TINV TINV LOI.STUDENT.INVERSE DISTR.T.INV INVT T.INV TJAKAUMA.K��NT INV.T TINV 353336 -1 1 0 CONCATENATE VERKETTEN CONCATENER CONCATENAR CONCATENAR TEKST.SAMENVOEGEN KETJUTA CONCATENA SAMMANFOGA 354337 2 1 0 POWER POTENZ PUISSANCE POTENCIA POT�NCIA MACHT POTENSSI POTENZA UPPH�JT.TILL 355342 1 1 0 RADIANS RADIANT RADIANS RADIANES RADIANOS RADIALEN RADIAANIT RADIANTI RADIANER 356343 1 1 0 DEGREES GRAD DEGRES GRADOS GRAUS GRADEN ASTEET GRADI GRADER 357344 -1 0 0 SUBTOTAL TEILERGEBNIS SOUS.TOTAL SUBTOTALES SUBTOTAL SUBTOTAAL V�LISUMMA SUBTOTALE DELSUMMA 358345 -1 0 0 SUMIF SUMMEWENN SOMME.SI SUMAR.SI SOMASE SOM.ALS SUMMA.JOS SOMMA.SE SUMMA.OM 359346 2 0 0 COUNTIF Z�HLENWENN NB.SI CONTAR.SI CONT.SE AANTAL.ALS LASKE.JOS CONTA.SE ANTAL.OM 360347 1 0 0 COUNTBLANK ANZAHLLEEREZELLEN NB.VIDE CONTAR.BLANCO CONTAR.VAZIO AANTAL.LEGE.CELLEN LASKE.TYHJ�T CONTA.VUOTE ANTAL.TOMMA 361354 -1 1 0 ROMAN R�MISCH ROMAIN NUMERO.ROMANO ROMANO ROMEINS ROMAN ROMANO ROMERSK 362