FlexCel.AddinFunctions Namespace

This is a namespace with commonly used Excel Addin functions that will be used by FlexCel when recalculating. While the functions defined here are not part of the Excel 2003 internal functions, they are often used as they are included in the default "addin packs" in Excel. They also might be built-in in newer Excel releases.

Classes

Name	Description
BaseBinHexImpl	Base conversion class for implementing Bin2Hex, Dec2Bin, etc.
BaseBondsImpl	Implements the basics for Bond functions, like CoupDays, CoupDaysNC, CoupDayBS, CoupNCD, CoupNum, CoupPCD.
BaseGCDLCM	A base implementation for both GCD and LCM
BaseWorkDaysImpl	Implements the basis for WorkDays and NetWorkDays Excel functions. Look at Excel documentation for more information.
Bin2DecImpl	Implements the Bin2Dec Excel function. Look at Excel documentation for more information.
Bin2HexImpl	Implements the Bin2Hex Excel function. Look at Excel documentation for more information.
Bin2OctImpl	Implements the Bin2Oct Excel function. Look at Excel documentation for more information.
ConvertImpl	Implements the Convert Excel function. Look at Excel documentation for more information.
CoupDaysBSImpl	Implements the CoupDaysBS Excel function. Look at Excel documentation for more information.
CoupDaysImpl	Implements the CoupDays Excel function. Look at Excel documentation for more information.
CoupDaysNCImpl	Implements the CoupDaysNC Excel function. Look at Excel documentation for more information.
CoupNCDImpl	Implements the CoupNCD Excel function. Look at Excel documentation for more information.
CoupNumImpl	Implements the CoupNum Excel function. Look at Excel documentation for more information.
CoupPCDImpl	Implements the CoupPCD Excel function. Look at Excel documentation for more information.
Dec2BinImpl	Implements the Dec2Bin Excel function. Look at Excel documentation for more information.
Dec2HexImpl	Implements the Dec2Hex Excel function. Look at Excel documentation for more information.
Dec2OctImpl	Implements the Dec2Oct Excel function. Look at Excel documentation for more information.
DeltaImpl	Implements the Delta Excel function. Look at Excel documentation for more information.
DollarDeImpl	Implements the DollarDe Excel function. Look at Excel documentation for more information.
DollarFrImpl	Implements the DollarDe Excel function. Look at Excel documentation for more information.
DurationImpl	Implements the Duration and MDuration addin functions. Returns the [modified] Macauley duration for a security with an assumed par value of $100.
EDateImpl	Implements the EDate addin function. Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
EffectImpl	Implements the Effect Excel function. Look at Excel documentation for more information.
EOMonthImpl	Implements the EOMonth Excel function. Look at Excel documentation for more information.
FactDoubleImpl	Implements the FactDouble Excel function. Look at Excel documentation for more information.
GcdImpl	Implements the GCD Excel function. Look at Excel documentation for more information.
GeStepImpl	Implements the GeStep Excel function. Look at Excel documentation for more information.
Hex2BinImpl	Implements the Hex2Bin Excel function. Look at Excel documentation for more information.
Hex2DecImpl	Implements the Hex2Dec Excel function. Look at Excel documentation for more information.
Hex2OctImpl	Implements the Hex2Oct Excel function. Look at Excel documentation for more information.
IsEvenImpl	Implements the IsEven Excel function. Look at Excel documentation for more information.
IsOddImpl	Implements the IsOdd Excel function. Look at Excel documentation for more information.
LcmImpl	Implements the LCM Excel function. Look at Excel documentation for more information.
MRoundImpl	Implements the MRound Excel function. Look at Excel documentation for more information.
MultinomialImpl	Implements the Multinomial Excel function. Look at Excel documentation for more information.
NetWorkDaysImpl	Implements the NetWorkDays Excel function. Look at Excel documentation for more information.
NominalImpl	Implements the Nominal Excel function. Look at Excel documentation for more information.
Oct2BinImpl	Implements the Oct2Bin Excel function. Look at Excel documentation for more information.
Oct2DecImpl	Implements the Oct2Dec Excel function. Look at Excel documentation for more information.
Oct2HexImpl	Implements the Oct2Hex Excel function. Look at Excel documentation for more information.
QuotientImpl	Implements the Quotient Excel function. Look at Excel documentation for more information.
RandBetweenImpl	Implements the Quotient Excel function. Look at Excel documentation for more information.
SeriesSumImpl	Implements the SeriesSum Excel function. Look at Excel documentation for more information.
SqrtPiImpl	Implements the Quotient Excel function. Look at Excel documentation for more information.
WeekNumImpl	Implements the Weeknum Excel function. Look at Excel documentation for more information.
WorkDayImpl	Implements the WorkDay Excel function. Look at Excel documentation for more information.
XIRRImpl	Implements the XIRR Excel function. Look at Excel documentation for more information.
XNPVImpl	Implements the XNPV Excel function. Look at Excel documentation for more information.
YearFracImpl	Implements the YearFrac Excel function. Look at Excel documentation for more information.

Enumerations

Name	Description
TDayCountBasis	Enumerates different Basis parameters for financial functions like Duration.