############################################################
|
##
|
## PhpSpreadsheet - function name translations
|
##
|
## Deutsch (German)
|
##
|
############################################################
|
|
|
##
|
## Cubefunktionen (Cube Functions)
|
##
|
CUBEKPIMEMBER = CUBEKPIELEMENT
|
CUBEMEMBER = CUBEELEMENT
|
CUBEMEMBERPROPERTY = CUBEELEMENTEIGENSCHAFT
|
CUBERANKEDMEMBER = CUBERANGELEMENT
|
CUBESET = CUBEMENGE
|
CUBESETCOUNT = CUBEMENGENANZAHL
|
CUBEVALUE = CUBEWERT
|
|
##
|
## Datenbankfunktionen (Database Functions)
|
##
|
DAVERAGE = DBMITTELWERT
|
DCOUNT = DBANZAHL
|
DCOUNTA = DBANZAHL2
|
DGET = DBAUSZUG
|
DMAX = DBMAX
|
DMIN = DBMIN
|
DPRODUCT = DBPRODUKT
|
DSTDEV = DBSTDABW
|
DSTDEVP = DBSTDABWN
|
DSUM = DBSUMME
|
DVAR = DBVARIANZ
|
DVARP = DBVARIANZEN
|
|
##
|
## Datums- und Uhrzeitfunktionen (Date & Time Functions)
|
##
|
DATE = DATUM
|
DATEVALUE = DATWERT
|
DAY = TAG
|
DAYS = TAGE
|
DAYS360 = TAGE360
|
EDATE = EDATUM
|
EOMONTH = MONATSENDE
|
HOUR = STUNDE
|
ISOWEEKNUM = ISOKALENDERWOCHE
|
MINUTE = MINUTE
|
MONTH = MONAT
|
NETWORKDAYS = NETTOARBEITSTAGE
|
NETWORKDAYS.INTL = NETTOARBEITSTAGE.INTL
|
NOW = JETZT
|
SECOND = SEKUNDE
|
THAIDAYOFWEEK = THAIWOCHENTAG
|
THAIMONTHOFYEAR = THAIMONATDESJAHRES
|
THAIYEAR = THAIJAHR
|
TIME = ZEIT
|
TIMEVALUE = ZEITWERT
|
TODAY = HEUTE
|
WEEKDAY = WOCHENTAG
|
WEEKNUM = KALENDERWOCHE
|
WORKDAY = ARBEITSTAG
|
WORKDAY.INTL = ARBEITSTAG.INTL
|
YEAR = JAHR
|
YEARFRAC = BRTEILJAHRE
|
|
##
|
## Technische Funktionen (Engineering Functions)
|
##
|
BESSELI = BESSELI
|
BESSELJ = BESSELJ
|
BESSELK = BESSELK
|
BESSELY = BESSELY
|
BIN2DEC = BININDEZ
|
BIN2HEX = BININHEX
|
BIN2OCT = BININOKT
|
BITAND = BITUND
|
BITLSHIFT = BITLVERSCHIEB
|
BITOR = BITODER
|
BITRSHIFT = BITRVERSCHIEB
|
BITXOR = BITXODER
|
COMPLEX = KOMPLEXE
|
CONVERT = UMWANDELN
|
DEC2BIN = DEZINBIN
|
DEC2HEX = DEZINHEX
|
DEC2OCT = DEZINOKT
|
DELTA = DELTA
|
ERF = GAUSSFEHLER
|
ERF.PRECISE = GAUSSF.GENAU
|
ERFC = GAUSSFKOMPL
|
ERFC.PRECISE = GAUSSFKOMPL.GENAU
|
GESTEP = GGANZZAHL
|
HEX2BIN = HEXINBIN
|
HEX2DEC = HEXINDEZ
|
HEX2OCT = HEXINOKT
|
IMABS = IMABS
|
IMAGINARY = IMAGINÄRTEIL
|
IMARGUMENT = IMARGUMENT
|
IMCONJUGATE = IMKONJUGIERTE
|
IMCOS = IMCOS
|
IMCOSH = IMCOSHYP
|
IMCOT = IMCOT
|
IMCSC = IMCOSEC
|
IMCSCH = IMCOSECHYP
|
IMDIV = IMDIV
|
IMEXP = IMEXP
|
IMLN = IMLN
|
IMLOG10 = IMLOG10
|
IMLOG2 = IMLOG2
|
IMPOWER = IMAPOTENZ
|
IMPRODUCT = IMPRODUKT
|
IMREAL = IMREALTEIL
|
IMSEC = IMSEC
|
IMSECH = IMSECHYP
|
IMSIN = IMSIN
|
IMSINH = IMSINHYP
|
IMSQRT = IMWURZEL
|
IMSUB = IMSUB
|
IMSUM = IMSUMME
|
IMTAN = IMTAN
|
OCT2BIN = OKTINBIN
|
OCT2DEC = OKTINDEZ
|
OCT2HEX = OKTINHEX
|
|
##
|
## Finanzmathematische Funktionen (Financial Functions)
|
##
|
ACCRINT = AUFGELZINS
|
ACCRINTM = AUFGELZINSF
|
AMORDEGRC = AMORDEGRK
|
AMORLINC = AMORLINEARK
|
COUPDAYBS = ZINSTERMTAGVA
|
COUPDAYS = ZINSTERMTAGE
|
COUPDAYSNC = ZINSTERMTAGNZ
|
COUPNCD = ZINSTERMNZ
|
COUPNUM = ZINSTERMZAHL
|
COUPPCD = ZINSTERMVZ
|
CUMIPMT = KUMZINSZ
|
CUMPRINC = KUMKAPITAL
|
DB = GDA2
|
DDB = GDA
|
DISC = DISAGIO
|
DOLLARDE = NOTIERUNGDEZ
|
DOLLARFR = NOTIERUNGBRU
|
DURATION = DURATION
|
EFFECT = EFFEKTIV
|
FV = ZW
|
FVSCHEDULE = ZW2
|
INTRATE = ZINSSATZ
|
IPMT = ZINSZ
|
IRR = IKV
|
ISPMT = ISPMT
|
MDURATION = MDURATION
|
MIRR = QIKV
|
NOMINAL = NOMINAL
|
NPER = ZZR
|
NPV = NBW
|
ODDFPRICE = UNREGER.KURS
|
ODDFYIELD = UNREGER.REND
|
ODDLPRICE = UNREGLE.KURS
|
ODDLYIELD = UNREGLE.REND
|
PDURATION = PDURATION
|
PMT = RMZ
|
PPMT = KAPZ
|
PRICE = KURS
|
PRICEDISC = KURSDISAGIO
|
PRICEMAT = KURSFÄLLIG
|
PV = BW
|
RATE = ZINS
|
RECEIVED = AUSZAHLUNG
|
RRI = ZSATZINVEST
|
SLN = LIA
|
SYD = DIA
|
TBILLEQ = TBILLÄQUIV
|
TBILLPRICE = TBILLKURS
|
TBILLYIELD = TBILLRENDITE
|
VDB = VDB
|
XIRR = XINTZINSFUSS
|
XNPV = XKAPITALWERT
|
YIELD = RENDITE
|
YIELDDISC = RENDITEDIS
|
YIELDMAT = RENDITEFÄLL
|
|
##
|
## Informationsfunktionen (Information Functions)
|
##
|
CELL = ZELLE
|
ERROR.TYPE = FEHLER.TYP
|
INFO = INFO
|
ISBLANK = ISTLEER
|
ISERR = ISTFEHL
|
ISERROR = ISTFEHLER
|
ISEVEN = ISTGERADE
|
ISFORMULA = ISTFORMEL
|
ISLOGICAL = ISTLOG
|
ISNA = ISTNV
|
ISNONTEXT = ISTKTEXT
|
ISNUMBER = ISTZAHL
|
ISODD = ISTUNGERADE
|
ISREF = ISTBEZUG
|
ISTEXT = ISTTEXT
|
N = N
|
NA = NV
|
SHEET = BLATT
|
SHEETS = BLÄTTER
|
TYPE = TYP
|
|
##
|
## Logische Funktionen (Logical Functions)
|
##
|
AND = UND
|
FALSE = FALSCH
|
IF = WENN
|
IFERROR = WENNFEHLER
|
IFNA = WENNNV
|
IFS = WENNS
|
NOT = NICHT
|
OR = ODER
|
SWITCH = ERSTERWERT
|
TRUE = WAHR
|
XOR = XODER
|
|
##
|
## Nachschlage- und Verweisfunktionen (Lookup & Reference Functions)
|
##
|
ADDRESS = ADRESSE
|
AREAS = BEREICHE
|
CHOOSE = WAHL
|
COLUMN = SPALTE
|
COLUMNS = SPALTEN
|
FORMULATEXT = FORMELTEXT
|
GETPIVOTDATA = PIVOTDATENZUORDNEN
|
HLOOKUP = WVERWEIS
|
HYPERLINK = HYPERLINK
|
INDEX = INDEX
|
INDIRECT = INDIREKT
|
LOOKUP = VERWEIS
|
MATCH = VERGLEICH
|
OFFSET = BEREICH.VERSCHIEBEN
|
ROW = ZEILE
|
ROWS = ZEILEN
|
RTD = RTD
|
TRANSPOSE = MTRANS
|
VLOOKUP = SVERWEIS
|
*RC = ZS
|
|
##
|
## Mathematische und trigonometrische Funktionen (Math & Trig Functions)
|
##
|
ABS = ABS
|
ACOS = ARCCOS
|
ACOSH = ARCCOSHYP
|
ACOT = ARCCOT
|
ACOTH = ARCCOTHYP
|
AGGREGATE = AGGREGAT
|
ARABIC = ARABISCH
|
ASIN = ARCSIN
|
ASINH = ARCSINHYP
|
ATAN = ARCTAN
|
ATAN2 = ARCTAN2
|
ATANH = ARCTANHYP
|
BASE = BASIS
|
CEILING.MATH = OBERGRENZE.MATHEMATIK
|
CEILING.PRECISE = OBERGRENZE.GENAU
|
COMBIN = KOMBINATIONEN
|
COMBINA = KOMBINATIONEN2
|
COS = COS
|
COSH = COSHYP
|
COT = COT
|
COTH = COTHYP
|
CSC = COSEC
|
CSCH = COSECHYP
|
DECIMAL = DEZIMAL
|
DEGREES = GRAD
|
ECMA.CEILING = ECMA.OBERGRENZE
|
EVEN = GERADE
|
EXP = EXP
|
FACT = FAKULTÄT
|
FACTDOUBLE = ZWEIFAKULTÄT
|
FLOOR.MATH = UNTERGRENZE.MATHEMATIK
|
FLOOR.PRECISE = UNTERGRENZE.GENAU
|
GCD = GGT
|
INT = GANZZAHL
|
ISO.CEILING = ISO.OBERGRENZE
|
LCM = KGV
|
LN = LN
|
LOG = LOG
|
LOG10 = LOG10
|
MDETERM = MDET
|
MINVERSE = MINV
|
MMULT = MMULT
|
MOD = REST
|
MROUND = VRUNDEN
|
MULTINOMIAL = POLYNOMIAL
|
MUNIT = MEINHEIT
|
ODD = UNGERADE
|
PI = PI
|
POWER = POTENZ
|
PRODUCT = PRODUKT
|
QUOTIENT = QUOTIENT
|
RADIANS = BOGENMASS
|
RAND = ZUFALLSZAHL
|
RANDBETWEEN = ZUFALLSBEREICH
|
ROMAN = RÖMISCH
|
ROUND = RUNDEN
|
ROUNDBAHTDOWN = RUNDBAHTNED
|
ROUNDBAHTUP = BAHTAUFRUNDEN
|
ROUNDDOWN = ABRUNDEN
|
ROUNDUP = AUFRUNDEN
|
SEC = SEC
|
SECH = SECHYP
|
SERIESSUM = POTENZREIHE
|
SIGN = VORZEICHEN
|
SIN = SIN
|
SINH = SINHYP
|
SQRT = WURZEL
|
SQRTPI = WURZELPI
|
SUBTOTAL = TEILERGEBNIS
|
SUM = SUMME
|
SUMIF = SUMMEWENN
|
SUMIFS = SUMMEWENNS
|
SUMPRODUCT = SUMMENPRODUKT
|
SUMSQ = QUADRATESUMME
|
SUMX2MY2 = SUMMEX2MY2
|
SUMX2PY2 = SUMMEX2PY2
|
SUMXMY2 = SUMMEXMY2
|
TAN = TAN
|
TANH = TANHYP
|
TRUNC = KÜRZEN
|
|
##
|
## Statistische Funktionen (Statistical Functions)
|
##
|
AVEDEV = MITTELABW
|
AVERAGE = MITTELWERT
|
AVERAGEA = MITTELWERTA
|
AVERAGEIF = MITTELWERTWENN
|
AVERAGEIFS = MITTELWERTWENNS
|
BETA.DIST = BETA.VERT
|
BETA.INV = BETA.INV
|
BINOM.DIST = BINOM.VERT
|
BINOM.DIST.RANGE = BINOM.VERT.BEREICH
|
BINOM.INV = BINOM.INV
|
CHISQ.DIST = CHIQU.VERT
|
CHISQ.DIST.RT = CHIQU.VERT.RE
|
CHISQ.INV = CHIQU.INV
|
CHISQ.INV.RT = CHIQU.INV.RE
|
CHISQ.TEST = CHIQU.TEST
|
CONFIDENCE.NORM = KONFIDENZ.NORM
|
CONFIDENCE.T = KONFIDENZ.T
|
CORREL = KORREL
|
COUNT = ANZAHL
|
COUNTA = ANZAHL2
|
COUNTBLANK = ANZAHLLEEREZELLEN
|
COUNTIF = ZÄHLENWENN
|
COUNTIFS = ZÄHLENWENNS
|
COVARIANCE.P = KOVARIANZ.P
|
COVARIANCE.S = KOVARIANZ.S
|
DEVSQ = SUMQUADABW
|
EXPON.DIST = EXPON.VERT
|
F.DIST = F.VERT
|
F.DIST.RT = F.VERT.RE
|
F.INV = F.INV
|
F.INV.RT = F.INV.RE
|
F.TEST = F.TEST
|
FISHER = FISHER
|
FISHERINV = FISHERINV
|
FORECAST.ETS = PROGNOSE.ETS
|
FORECAST.ETS.CONFINT = PROGNOSE.ETS.KONFINT
|
FORECAST.ETS.SEASONALITY = PROGNOSE.ETS.SAISONALITÄT
|
FORECAST.ETS.STAT = PROGNOSE.ETS.STAT
|
FORECAST.LINEAR = PROGNOSE.LINEAR
|
FREQUENCY = HÄUFIGKEIT
|
GAMMA = GAMMA
|
GAMMA.DIST = GAMMA.VERT
|
GAMMA.INV = GAMMA.INV
|
GAMMALN = GAMMALN
|
GAMMALN.PRECISE = GAMMALN.GENAU
|
GAUSS = GAUSS
|
GEOMEAN = GEOMITTEL
|
GROWTH = VARIATION
|
HARMEAN = HARMITTEL
|
HYPGEOM.DIST = HYPGEOM.VERT
|
INTERCEPT = ACHSENABSCHNITT
|
KURT = KURT
|
LARGE = KGRÖSSTE
|
LINEST = RGP
|
LOGEST = RKP
|
LOGNORM.DIST = LOGNORM.VERT
|
LOGNORM.INV = LOGNORM.INV
|
MAX = MAX
|
MAXA = MAXA
|
MAXIFS = MAXWENNS
|
MEDIAN = MEDIAN
|
MIN = MIN
|
MINA = MINA
|
MINIFS = MINWENNS
|
MODE.MULT = MODUS.VIELF
|
MODE.SNGL = MODUS.EINF
|
NEGBINOM.DIST = NEGBINOM.VERT
|
NORM.DIST = NORM.VERT
|
NORM.INV = NORM.INV
|
NORM.S.DIST = NORM.S.VERT
|
NORM.S.INV = NORM.S.INV
|
PEARSON = PEARSON
|
PERCENTILE.EXC = QUANTIL.EXKL
|
PERCENTILE.INC = QUANTIL.INKL
|
PERCENTRANK.EXC = QUANTILSRANG.EXKL
|
PERCENTRANK.INC = QUANTILSRANG.INKL
|
PERMUT = VARIATIONEN
|
PERMUTATIONA = VARIATIONEN2
|
PHI = PHI
|
POISSON.DIST = POISSON.VERT
|
PROB = WAHRSCHBEREICH
|
QUARTILE.EXC = QUARTILE.EXKL
|
QUARTILE.INC = QUARTILE.INKL
|
RANK.AVG = RANG.MITTELW
|
RANK.EQ = RANG.GLEICH
|
RSQ = BESTIMMTHEITSMASS
|
SKEW = SCHIEFE
|
SKEW.P = SCHIEFE.P
|
SLOPE = STEIGUNG
|
SMALL = KKLEINSTE
|
STANDARDIZE = STANDARDISIERUNG
|
STDEV.P = STABW.N
|
STDEV.S = STABW.S
|
STDEVA = STABWA
|
STDEVPA = STABWNA
|
STEYX = STFEHLERYX
|
T.DIST = T.VERT
|
T.DIST.2T = T.VERT.2S
|
T.DIST.RT = T.VERT.RE
|
T.INV = T.INV
|
T.INV.2T = T.INV.2S
|
T.TEST = T.TEST
|
TREND = TREND
|
TRIMMEAN = GESTUTZTMITTEL
|
VAR.P = VAR.P
|
VAR.S = VAR.S
|
VARA = VARIANZA
|
VARPA = VARIANZENA
|
WEIBULL.DIST = WEIBULL.VERT
|
Z.TEST = G.TEST
|
|
##
|
## Textfunktionen (Text Functions)
|
##
|
BAHTTEXT = BAHTTEXT
|
CHAR = ZEICHEN
|
CLEAN = SÄUBERN
|
CODE = CODE
|
CONCAT = TEXTKETTE
|
DOLLAR = DM
|
EXACT = IDENTISCH
|
FIND = FINDEN
|
FIXED = FEST
|
ISTHAIDIGIT = ISTTHAIZAHLENWORT
|
LEFT = LINKS
|
LEN = LÄNGE
|
LOWER = KLEIN
|
MID = TEIL
|
NUMBERVALUE = ZAHLENWERT
|
PROPER = GROSS2
|
REPLACE = ERSETZEN
|
REPT = WIEDERHOLEN
|
RIGHT = RECHTS
|
SEARCH = SUCHEN
|
SUBSTITUTE = WECHSELN
|
T = T
|
TEXT = TEXT
|
TEXTJOIN = TEXTVERKETTEN
|
THAIDIGIT = THAIZAHLENWORT
|
THAINUMSOUND = THAIZAHLSOUND
|
THAINUMSTRING = THAILANDSKNUMSTRENG
|
THAISTRINGLENGTH = THAIZEICHENFOLGENLÄNGE
|
TRIM = GLÄTTEN
|
UNICHAR = UNIZEICHEN
|
UNICODE = UNICODE
|
UPPER = GROSS
|
VALUE = WERT
|
|
##
|
## Webfunktionen (Web Functions)
|
##
|
ENCODEURL = URLCODIEREN
|
FILTERXML = XMLFILTERN
|
WEBSERVICE = WEBDIENST
|
|
##
|
## Kompatibilitätsfunktionen (Compatibility Functions)
|
##
|
BETADIST = BETAVERT
|
BETAINV = BETAINV
|
BINOMDIST = BINOMVERT
|
CEILING = OBERGRENZE
|
CHIDIST = CHIVERT
|
CHIINV = CHIINV
|
CHITEST = CHITEST
|
CONCATENATE = VERKETTEN
|
CONFIDENCE = KONFIDENZ
|
COVAR = KOVAR
|
CRITBINOM = KRITBINOM
|
EXPONDIST = EXPONVERT
|
FDIST = FVERT
|
FINV = FINV
|
FLOOR = UNTERGRENZE
|
FORECAST = SCHÄTZER
|
FTEST = FTEST
|
GAMMADIST = GAMMAVERT
|
GAMMAINV = GAMMAINV
|
HYPGEOMDIST = HYPGEOMVERT
|
LOGINV = LOGINV
|
LOGNORMDIST = LOGNORMVERT
|
MODE = MODALWERT
|
NEGBINOMDIST = NEGBINOMVERT
|
NORMDIST = NORMVERT
|
NORMINV = NORMINV
|
NORMSDIST = STANDNORMVERT
|
NORMSINV = STANDNORMINV
|
PERCENTILE = QUANTIL
|
PERCENTRANK = QUANTILSRANG
|
POISSON = POISSON
|
QUARTILE = QUARTILE
|
RANK = RANG
|
STDEV = STABW
|
STDEVP = STABWN
|
TDIST = TVERT
|
TINV = TINV
|
TTEST = TTEST
|
VAR = VARIANZ
|
VARP = VARIANZEN
|
WEIBULL = WEIBULL
|
ZTEST = GTEST
|
