Autoría | Ultima modificación | Ver Log |
################################################################ PhpSpreadsheet - function name translations#### Español (Spanish)################################################################## Funciones de cubo (Cube Functions)##CUBEKPIMEMBER = MIEMBROKPICUBOCUBEMEMBER = MIEMBROCUBOCUBEMEMBERPROPERTY = PROPIEDADMIEMBROCUBOCUBERANKEDMEMBER = MIEMBRORANGOCUBOCUBESET = CONJUNTOCUBOCUBESETCOUNT = RECUENTOCONJUNTOCUBOCUBEVALUE = VALORCUBO#### Funciones de base de datos (Database Functions)##DAVERAGE = BDPROMEDIODCOUNT = BDCONTARDCOUNTA = BDCONTARADGET = BDEXTRAERDMAX = BDMAXDMIN = BDMINDPRODUCT = BDPRODUCTODSTDEV = BDDESVESTDSTDEVP = BDDESVESTPDSUM = BDSUMADVAR = BDVARDVARP = BDVARP#### Funciones de fecha y hora (Date & Time Functions)##DATE = FECHADATEDIF = SIFECHADATESTRING = CADENA.FECHADATEVALUE = FECHANUMERODAY = DIADAYS = DIASDAYS360 = DIAS360EDATE = FECHA.MESEOMONTH = FIN.MESHOUR = HORAISOWEEKNUM = ISO.NUM.DE.SEMANAMINUTE = MINUTOMONTH = MESNETWORKDAYS = DIAS.LABNETWORKDAYS.INTL = DIAS.LAB.INTLNOW = AHORASECOND = SEGUNDOTHAIDAYOFWEEK = DIASEMTAITHAIMONTHOFYEAR = MESAÑOTAITHAIYEAR = AÑOTAITIME = NSHORATIMEVALUE = HORANUMEROTODAY = HOYWEEKDAY = DIASEMWEEKNUM = NUM.DE.SEMANAWORKDAY = DIA.LABWORKDAY.INTL = DIA.LAB.INTLYEAR = AÑOYEARFRAC = FRAC.AÑO#### Funciones de ingeniería (Engineering Functions)##BESSELI = BESSELIBESSELJ = BESSELJBESSELK = BESSELKBESSELY = BESSELYBIN2DEC = BIN.A.DECBIN2HEX = BIN.A.HEXBIN2OCT = BIN.A.OCTBITAND = BIT.YBITLSHIFT = BIT.DESPLIZQDABITOR = BIT.OBITRSHIFT = BIT.DESPLDCHABITXOR = BIT.XOCOMPLEX = COMPLEJOCONVERT = CONVERTIRDEC2BIN = DEC.A.BINDEC2HEX = DEC.A.HEXDEC2OCT = DEC.A.OCTDELTA = DELTAERF = FUN.ERRORERF.PRECISE = FUN.ERROR.EXACTOERFC = FUN.ERROR.COMPLERFC.PRECISE = FUN.ERROR.COMPL.EXACTOGESTEP = MAYOR.O.IGUALHEX2BIN = HEX.A.BINHEX2DEC = HEX.A.DECHEX2OCT = HEX.A.OCTIMABS = IM.ABSIMAGINARY = IMAGINARIOIMARGUMENT = IM.ANGULOIMCONJUGATE = IM.CONJUGADAIMCOS = IM.COSIMCOSH = IM.COSHIMCOT = IM.COTIMCSC = IM.CSCIMCSCH = IM.CSCHIMDIV = IM.DIVIMEXP = IM.EXPIMLN = IM.LNIMLOG10 = IM.LOG10IMLOG2 = IM.LOG2IMPOWER = IM.POTIMPRODUCT = IM.PRODUCTIMREAL = IM.REALIMSEC = IM.SECIMSECH = IM.SECHIMSIN = IM.SENOIMSINH = IM.SENOHIMSQRT = IM.RAIZ2IMSUB = IM.SUSTRIMSUM = IM.SUMIMTAN = IM.TANOCT2BIN = OCT.A.BINOCT2DEC = OCT.A.DECOCT2HEX = OCT.A.HEX#### Funciones financieras (Financial Functions)##ACCRINT = INT.ACUMACCRINTM = INT.ACUM.VAMORDEGRC = AMORTIZ.PROGREAMORLINC = AMORTIZ.LINCOUPDAYBS = CUPON.DIAS.L1COUPDAYS = CUPON.DIASCOUPDAYSNC = CUPON.DIAS.L2COUPNCD = CUPON.FECHA.L2COUPNUM = CUPON.NUMCOUPPCD = CUPON.FECHA.L1CUMIPMT = PAGO.INT.ENTRECUMPRINC = PAGO.PRINC.ENTREDB = DBDDB = DDBDISC = TASA.DESCDOLLARDE = MONEDA.DECDOLLARFR = MONEDA.FRACDURATION = DURACIONEFFECT = INT.EFECTIVOFV = VFFVSCHEDULE = VF.PLANINTRATE = TASA.INTIPMT = PAGOINTIRR = TIRISPMT = INT.PAGO.DIRMDURATION = DURACION.MODIFMIRR = TIRMNOMINAL = TASA.NOMINALNPER = NPERNPV = VNAODDFPRICE = PRECIO.PER.IRREGULAR.1ODDFYIELD = RENDTO.PER.IRREGULAR.1ODDLPRICE = PRECIO.PER.IRREGULAR.2ODDLYIELD = RENDTO.PER.IRREGULAR.2PDURATION = P.DURACIONPMT = PAGOPPMT = PAGOPRINPRICE = PRECIOPRICEDISC = PRECIO.DESCUENTOPRICEMAT = PRECIO.VENCIMIENTOPV = VARATE = TASARECEIVED = CANTIDAD.RECIBIDARRI = RRISLN = SLNSYD = SYDTBILLEQ = LETRA.DE.TEST.EQV.A.BONOTBILLPRICE = LETRA.DE.TES.PRECIOTBILLYIELD = LETRA.DE.TES.RENDTOVDB = DVSXIRR = TIR.NO.PERXNPV = VNA.NO.PERYIELD = RENDTOYIELDDISC = RENDTO.DESCYIELDMAT = RENDTO.VENCTO#### Funciones de información (Information Functions)##CELL = CELDAERROR.TYPE = TIPO.DE.ERRORINFO = INFOISBLANK = ESBLANCOISERR = ESERRISERROR = ESERRORISEVEN = ES.PARISFORMULA = ESFORMULAISLOGICAL = ESLOGICOISNA = ESNODISNONTEXT = ESNOTEXTOISNUMBER = ESNUMEROISODD = ES.IMPARISREF = ESREFISTEXT = ESTEXTON = NNA = NODSHEET = HOJASHEETS = HOJASTYPE = TIPO#### Funciones lógicas (Logical Functions)##AND = YFALSE = FALSOIF = SIIFERROR = SI.ERRORIFNA = SI.NDIFS = SI.CONJUNTONOT = NOOR = OSWITCH = CAMBIARTRUE = VERDADEROXOR = XO#### Funciones de búsqueda y referencia (Lookup & Reference Functions)##ADDRESS = DIRECCIONAREAS = AREASCHOOSE = ELEGIRCOLUMN = COLUMNACOLUMNS = COLUMNASFORMULATEXT = FORMULATEXTOGETPIVOTDATA = IMPORTARDATOSDINAMICOSHLOOKUP = BUSCARHHYPERLINK = HIPERVINCULOINDEX = INDICEINDIRECT = INDIRECTOLOOKUP = BUSCARMATCH = COINCIDIROFFSET = DESREFROW = FILAROWS = FILASRTD = RDTRTRANSPOSE = TRANSPONERVLOOKUP = BUSCARV*RC = FC#### Funciones matemáticas y trigonométricas (Math & Trig Functions)##ABS = ABSACOS = ACOSACOSH = ACOSHACOT = ACOTACOTH = ACOTHAGGREGATE = AGREGARARABIC = NUMERO.ARABEASIN = ASENOASINH = ASENOHATAN = ATANATAN2 = ATAN2ATANH = ATANHBASE = BASECEILING.MATH = MULTIPLO.SUPERIOR.MATCEILING.PRECISE = MULTIPLO.SUPERIOR.EXACTOCOMBIN = COMBINATCOMBINA = COMBINACOS = COSCOSH = COSHCOT = COTCOTH = COTHCSC = CSCCSCH = CSCHDECIMAL = CONV.DECIMALDEGREES = GRADOSECMA.CEILING = MULTIPLO.SUPERIOR.ECMAEVEN = REDONDEA.PAREXP = EXPFACT = FACTFACTDOUBLE = FACT.DOBLEFLOOR.MATH = MULTIPLO.INFERIOR.MATFLOOR.PRECISE = MULTIPLO.INFERIOR.EXACTOGCD = M.C.DINT = ENTEROISO.CEILING = MULTIPLO.SUPERIOR.ISOLCM = M.C.MLN = LNLOG = LOGLOG10 = LOG10MDETERM = MDETERMMINVERSE = MINVERSAMMULT = MMULTMOD = RESIDUOMROUND = REDOND.MULTMULTINOMIAL = MULTINOMIALMUNIT = M.UNIDADODD = REDONDEA.IMPARPI = PIPOWER = POTENCIAPRODUCT = PRODUCTOQUOTIENT = COCIENTERADIANS = RADIANESRAND = ALEATORIORANDBETWEEN = ALEATORIO.ENTREROMAN = NUMERO.ROMANOROUND = REDONDEARROUNDBAHTDOWN = REDONDEAR.BAHT.MASROUNDBAHTUP = REDONDEAR.BAHT.MENOSROUNDDOWN = REDONDEAR.MENOSROUNDUP = REDONDEAR.MASSEC = SECSECH = SECHSERIESSUM = SUMA.SERIESSIGN = SIGNOSIN = SENOSINH = SENOHSQRT = RAIZSQRTPI = RAIZ2PISUBTOTAL = SUBTOTALESSUM = SUMASUMIF = SUMAR.SISUMIFS = SUMAR.SI.CONJUNTOSUMPRODUCT = SUMAPRODUCTOSUMSQ = SUMA.CUADRADOSSUMX2MY2 = SUMAX2MENOSY2SUMX2PY2 = SUMAX2MASY2SUMXMY2 = SUMAXMENOSY2TAN = TANTANH = TANHTRUNC = TRUNCAR#### Funciones estadísticas (Statistical Functions)##AVEDEV = DESVPROMAVERAGE = PROMEDIOAVERAGEA = PROMEDIOAAVERAGEIF = PROMEDIO.SIAVERAGEIFS = PROMEDIO.SI.CONJUNTOBETA.DIST = DISTR.BETA.NBETA.INV = INV.BETA.NBINOM.DIST = DISTR.BINOM.NBINOM.DIST.RANGE = DISTR.BINOM.SERIEBINOM.INV = INV.BINOMCHISQ.DIST = DISTR.CHICUADCHISQ.DIST.RT = DISTR.CHICUAD.CDCHISQ.INV = INV.CHICUADCHISQ.INV.RT = INV.CHICUAD.CDCHISQ.TEST = PRUEBA.CHICUADCONFIDENCE.NORM = INTERVALO.CONFIANZA.NORMCONFIDENCE.T = INTERVALO.CONFIANZA.TCORREL = COEF.DE.CORRELCOUNT = CONTARCOUNTA = CONTARACOUNTBLANK = CONTAR.BLANCOCOUNTIF = CONTAR.SICOUNTIFS = CONTAR.SI.CONJUNTOCOVARIANCE.P = COVARIANCE.PCOVARIANCE.S = COVARIANZA.MDEVSQ = DESVIA2EXPON.DIST = DISTR.EXP.NF.DIST = DISTR.F.NF.DIST.RT = DISTR.F.CDF.INV = INV.FF.INV.RT = INV.F.CDF.TEST = PRUEBA.F.NFISHER = FISHERFISHERINV = PRUEBA.FISHER.INVFORECAST.ETS = PRONOSTICO.ETSFORECAST.ETS.CONFINT = PRONOSTICO.ETS.CONFINTFORECAST.ETS.SEASONALITY = PRONOSTICO.ETS.ESTACIONALIDADFORECAST.ETS.STAT = PRONOSTICO.ETS.STATFORECAST.LINEAR = PRONOSTICO.LINEALFREQUENCY = FRECUENCIAGAMMA = GAMMAGAMMA.DIST = DISTR.GAMMA.NGAMMA.INV = INV.GAMMAGAMMALN = GAMMA.LNGAMMALN.PRECISE = GAMMA.LN.EXACTOGAUSS = GAUSSGEOMEAN = MEDIA.GEOMGROWTH = CRECIMIENTOHARMEAN = MEDIA.ARMOHYPGEOM.DIST = DISTR.HIPERGEOM.NINTERCEPT = INTERSECCION.EJEKURT = CURTOSISLARGE = K.ESIMO.MAYORLINEST = ESTIMACION.LINEALLOGEST = ESTIMACION.LOGARITMICALOGNORM.DIST = DISTR.LOGNORMLOGNORM.INV = INV.LOGNORMMAX = MAXMAXA = MAXAMAXIFS = MAX.SI.CONJUNTOMEDIAN = MEDIANAMIN = MINMINA = MINAMINIFS = MIN.SI.CONJUNTOMODE.MULT = MODA.VARIOSMODE.SNGL = MODA.UNONEGBINOM.DIST = NEGBINOM.DISTNORM.DIST = DISTR.NORM.NNORM.INV = INV.NORMNORM.S.DIST = DISTR.NORM.ESTAND.NNORM.S.INV = INV.NORM.ESTANDPEARSON = PEARSONPERCENTILE.EXC = PERCENTIL.EXCPERCENTILE.INC = PERCENTIL.INCPERCENTRANK.EXC = RANGO.PERCENTIL.EXCPERCENTRANK.INC = RANGO.PERCENTIL.INCPERMUT = PERMUTACIONESPERMUTATIONA = PERMUTACIONES.APHI = FIPOISSON.DIST = POISSON.DISTPROB = PROBABILIDADQUARTILE.EXC = CUARTIL.EXCQUARTILE.INC = CUARTIL.INCRANK.AVG = JERARQUIA.MEDIARANK.EQ = JERARQUIA.EQVRSQ = COEFICIENTE.R2SKEW = COEFICIENTE.ASIMETRIASKEW.P = COEFICIENTE.ASIMETRIA.PSLOPE = PENDIENTESMALL = K.ESIMO.MENORSTANDARDIZE = NORMALIZACIONSTDEV.P = DESVEST.PSTDEV.S = DESVEST.MSTDEVA = DESVESTASTDEVPA = DESVESTPASTEYX = ERROR.TIPICO.XYT.DIST = DISTR.T.NT.DIST.2T = DISTR.T.2CT.DIST.RT = DISTR.T.CDT.INV = INV.TT.INV.2T = INV.T.2CT.TEST = PRUEBA.T.NTREND = TENDENCIATRIMMEAN = MEDIA.ACOTADAVAR.P = VAR.PVAR.S = VAR.SVARA = VARAVARPA = VARPAWEIBULL.DIST = DISTR.WEIBULLZ.TEST = PRUEBA.Z.N#### Funciones de texto (Text Functions)##BAHTTEXT = TEXTOBAHTCHAR = CARACTERCLEAN = LIMPIARCODE = CODIGOCONCAT = CONCATDOLLAR = MONEDAEXACT = IGUALFIND = ENCONTRARFIXED = DECIMALISTHAIDIGIT = ESDIGITOTAILEFT = IZQUIERDALEN = LARGOLOWER = MINUSCMID = EXTRAENUMBERSTRING = CADENA.NUMERONUMBERVALUE = VALOR.NUMEROPHONETIC = FONETICOPROPER = NOMPROPIOREPLACE = REEMPLAZARREPT = REPETIRRIGHT = DERECHASEARCH = HALLARSUBSTITUTE = SUSTITUIRT = TTEXT = TEXTOTEXTJOIN = UNIRCADENASTHAIDIGIT = DIGITOTAITHAINUMSOUND = SONNUMTAITHAINUMSTRING = CADENANUMTAITHAISTRINGLENGTH = LONGCADENATAITRIM = ESPACIOSUNICHAR = UNICARUNICODE = UNICODEUPPER = MAYUSCVALUE = VALOR#### Funciones web (Web Functions)##ENCODEURL = URLCODIFFILTERXML = XMLFILTROWEBSERVICE = SERVICIOWEB#### Funciones de compatibilidad (Compatibility Functions)##BETADIST = DISTR.BETABETAINV = DISTR.BETA.INVBINOMDIST = DISTR.BINOMCEILING = MULTIPLO.SUPERIORCHIDIST = DISTR.CHICHIINV = PRUEBA.CHI.INVCHITEST = PRUEBA.CHICONCATENATE = CONCATENARCONFIDENCE = INTERVALO.CONFIANZACOVAR = COVARCRITBINOM = BINOM.CRITEXPONDIST = DISTR.EXPFDIST = DISTR.FFINV = DISTR.F.INVFLOOR = MULTIPLO.INFERIORFORECAST = PRONOSTICOFTEST = PRUEBA.FGAMMADIST = DISTR.GAMMAGAMMAINV = DISTR.GAMMA.INVHYPGEOMDIST = DISTR.HIPERGEOMLOGINV = DISTR.LOG.INVLOGNORMDIST = DISTR.LOG.NORMMODE = MODANEGBINOMDIST = NEGBINOMDISTNORMDIST = DISTR.NORMNORMINV = DISTR.NORM.INVNORMSDIST = DISTR.NORM.ESTANDNORMSINV = DISTR.NORM.ESTAND.INVPERCENTILE = PERCENTILPERCENTRANK = RANGO.PERCENTILPOISSON = POISSONQUARTILE = CUARTILRANK = JERARQUIASTDEV = DESVESTSTDEVP = DESVESTPTDIST = DISTR.TTINV = DISTR.T.INVTTEST = PRUEBA.TVAR = VARVARP = VARPWEIBULL = DIST.WEIBULLZTEST = PRUEBA.Z