nabla v2.0.0
One namespace.
This release renames every function and breaks every formula written against v1.2.x.
nabla.f.Amortiseλ is now nb.Amortiseλ. Models built on the old names keep
working only if they keep the old workbook, which stays available at the v1.2.6 tag.
Six module prefixes became one. The gain is five fewer characters on every call and
autocomplete that works: typing =nb. narrows to this library instead of requiring you to
remember which of six modules a function lived in first.
Of the 130 functions, 106 change prefix and nothing else. Seventeen bare names existed in
more than one module: the fuller implementation keeps the plain name and the other 19 take
a one-letter tag, B for debt, E for essentials, U for utilities. The five About
tables take words.
nabla.xlsx is attached below, which earlier releases did not offer.
Every rename
| Was | Is now |
|---|---|
nabla.d.Aboutλ |
nb.AboutDatesλ |
nabla.d.CountDOWλ |
nb.CountDOWλ |
nabla.d.FinancialYearλ |
nb.FinancialYearλ |
nabla.d.IsBetweenλ |
nb.IsBetweenλ |
nabla.d.IsOccurrenceDateλ |
nb.IsOccurrenceDateλ |
nabla.d.OverLapDaysλ |
nb.OverLapDaysλ |
nabla.d.PeriodLabelλ |
nb.PeriodLabelλ |
nabla.d.Periodsλ |
nb.Periodsλ |
nabla.d.ScheduleRatesByItemsλ |
nb.ScheduleRatesByItemsλ |
nabla.d.ScheduleRatesλ |
nb.ScheduleRatesλ |
nabla.d.ScheduleValuesByItemsλ |
nb.ScheduleValuesByItemsλ |
nabla.d.ScheduleValuesλ |
nb.ScheduleValuesλ |
nabla.d.Timelineλ |
nb.Timelineλ |
nabla.debt.Amortiseλ |
nb.AmortiseBλ |
nabla.debt.DebtSculptFixedλ |
nb.DebtSculptFixedλ |
nabla.debt.DebtSculptVariableLRVλ |
nb.DebtSculptVariableLRVλ |
nabla.debt.DebtSculptVariableλ |
nb.DebtSculptVariableλ |
nabla.debt.InterestLRVλ |
nb.InterestLRVλ |
nabla.e.Aboutλ |
nb.AboutEssentialsλ |
nabla.e.AvgColsλ |
nb.AvgColsλ |
nabla.e.AvgRowsλ |
nb.AvgRowsλ |
nabla.e.CountAColsλ |
nb.CountAColsλ |
nabla.e.CountARowsλ |
nb.CountARowsλ |
nabla.e.CountColsλ |
nb.CountColsλ |
nabla.e.CountCλ |
nb.CountCλ |
nabla.e.CountRowsλ |
nb.CountRowsλ |
nabla.e.IsBetweenλ |
nb.IsBetweenEλ |
nabla.e.IsInListλ |
nb.IsInListλ |
nabla.e.MaxColsλ |
nb.MaxColsλ |
nabla.e.MaxRowsλ |
nb.MaxRowsλ |
nabla.e.MinColsλ |
nb.MinColsλ |
nabla.e.MinRowsλ |
nb.MinRowsλ |
nabla.e.RangeToDAλ |
nb.RangeToDAEλ |
nabla.e.SumColsλ |
nb.SumColsλ |
nabla.e.SumRowsλ |
nb.SumRowsλ |
nabla.f.Aboutλ |
nb.AboutFinancialλ |
nabla.f.Allocateλ |
nb.Allocateλ |
nabla.f.Amortiseλ |
nb.Amortiseλ |
nabla.f.AmortiseλDV |
nb.AmortiseλDV |
nabla.f.CorkScrewReversalλ |
nb.CorkScrewReversalλ |
nabla.f.Corkscrewλ |
nb.Corkscrewλ |
nabla.f.CorkscrewλDV |
nb.CorkscrewλDV |
nabla.f.Cumulativeλ |
nb.Cumulativeλ |
nabla.f.DBλ |
nb.DBλ |
nabla.f.DDBλ |
nb.DDBλ |
nabla.f.Depreciateλ |
nb.Depreciateλ |
nabla.f.DepreciateλDV |
nb.DepreciateλDV |
nabla.f.DiminishingValueλ |
nb.DiminishingValueλ |
nabla.f.FilterContainsλ |
nb.FilterContainsλ |
nabla.f.GSTAddλ |
nb.GSTAddλ |
nabla.f.GSTExtractλ |
nb.GSTExtractλ |
nabla.f.IRRλ |
nb.IRRλ |
nabla.f.IntOnIntλ |
nb.IntOnIntλ |
nabla.f.LabelAmortiseλ |
nb.LabelAmortiseλ |
nabla.f.LabelDepreciateλ |
nb.LabelDepreciateλ |
nabla.f.Movementλ |
nb.Movementλ |
nabla.f.PeriodDiffλ |
nb.PeriodDiffλ |
nabla.f.PeriodStartλ |
nb.PeriodStartλ |
nabla.f.PrimeCostλ |
nb.PrimeCostλ |
nabla.f.RangeToDAλ |
nb.RangeToDAλ |
nabla.f.Reversalλ |
nb.Reversalλ |
nabla.f.RollingAvgλ |
nb.RollingAvgλ |
nabla.f.RollingMaxλ |
nb.RollingMaxλ |
nabla.f.RollingMinλ |
nb.RollingMinλ |
nabla.f.RollingSumλ |
nb.RollingSumλ |
nabla.f.SLNλ |
nb.SLNλ |
nabla.f.SYDλ |
nb.SYDλ |
nabla.f.SumAmortiseλ |
nb.SumAmortiseλ |
nabla.f.SumContainsλ |
nb.SumContainsλ |
nabla.f.SumDepreciateλ |
nb.SumDepreciateλ |
nabla.f.SumPeriodsλ |
nb.SumPeriodsλ |
nabla.f.TimelineOffsetλ |
nb.TimelineOffsetλ |
nabla.f.TimelinePositionλ |
nb.TimelinePositionλ |
nabla.f.VDBλ |
nb.VDBλ |
nabla.r.Aboutλ |
nb.AboutRatiosλ |
nabla.r.AssetTurnoverRatioλ |
nb.AssetTurnoverRatioλ |
nabla.r.BVPSλ |
nb.BVPSλ |
nabla.r.CAPERatioλ |
nb.CAPERatioλ |
nabla.r.CashFlowMarginλ |
nb.CashFlowMarginλ |
nabla.r.CashRatioλ |
nb.CashRatioλ |
nabla.r.CurrentRatioλ |
nb.CurrentRatioλ |
nabla.r.DPRλ |
nb.DPRλ |
nabla.r.DSCRλ |
nb.DSCRλ |
nabla.r.DSIλ |
nb.DSIλ |
nabla.r.DebtRatioλ |
nb.DebtRatioλ |
nabla.r.DebtToAssetRatioλ |
nb.DebtToAssetRatioλ |
nabla.r.DebtToCapitalRatioλ |
nb.DebtToCapitalRatioλ |
nabla.r.DebtToEquityRatioλ |
nb.DebtToEquityRatioλ |
nabla.r.DividendYieldRatioλ |
nb.DividendYieldRatioλ |
nabla.r.EBITDAMarginλ |
nb.EBITDAMarginλ |
nabla.r.EPSλ |
nb.EPSλ |
nabla.r.EquityMultiplierλ |
nb.EquityMultiplierλ |
nabla.r.EquityRatioλ |
nb.EquityRatioλ |
nabla.r.GrossMarginλ |
nb.GrossMarginλ |
nabla.r.InterestCoverageRatioλ |
nb.InterestCoverageRatioλ |
nabla.r.InventoryTurnoverRatioλ |
nb.InventoryTurnoverRatioλ |
nabla.r.NetProfitMarginλ |
nb.NetProfitMarginλ |
nabla.r.OperatingCashFlowRatioλ |
nb.OperatingCashFlowRatioλ |
nabla.r.OperatingMarginλ |
nb.OperatingMarginλ |
nabla.r.OperatingRatioλ |
nb.OperatingRatioλ |
nabla.r.PretaxMarginλ |
nb.PretaxMarginλ |
nabla.r.PriceEarningsRatioλ |
nb.PriceEarningsRatioλ |
nabla.r.PriceToBookRatioλ |
nb.PriceToBookRatioλ |
nabla.r.PriceToCashRatioλ |
nb.PriceToCashRatioλ |
nabla.r.PriceToSalesRatioλ |
nb.PriceToSalesRatioλ |
nabla.r.QuickRatioλ |
nb.QuickRatioλ |
nabla.r.ROAλ |
nb.ROAλ |
nabla.r.ROEλ |
nb.ROEλ |
nabla.r.ROICλ |
nb.ROICλ |
nabla.r.ROIλ |
nb.ROIλ |
nabla.r.ReceivablesTurnoverRatioλ |
nb.ReceivablesTurnoverRatioλ |
nabla.r.RetentionRatioλ |
nb.RetentionRatioλ |
nabla.r.WorkingCapitalTurnoverRatioλ |
nb.WorkingCapitalTurnoverRatioλ |
nabla.u.Aboutλ |
nb.AboutUtilitiesλ |
nabla.u.AvgColsλ |
nb.AvgColsUλ |
nabla.u.AvgRowsλ |
nb.AvgRowsUλ |
nabla.u.CountAColsλ |
nb.CountAColsUλ |
nabla.u.CountARowsλ |
nb.CountARowsUλ |
nabla.u.CountColsλ |
nb.CountColsUλ |
nabla.u.CountCλ |
nb.CountCUλ |
nabla.u.CountRowsλ |
nb.CountRowsUλ |
nabla.u.IsBetweenλ |
nb.IsBetweenUλ |
nabla.u.IsInListλ |
nb.IsInListUλ |
nabla.u.MaxColsλ |
nb.MaxColsUλ |
nabla.u.MaxRowsλ |
nb.MaxRowsUλ |
nabla.u.MinColsλ |
nb.MinColsUλ |
nabla.u.MinRowsλ |
nb.MinRowsUλ |
nabla.u.RangeToDAλ |
nb.RangeToDAUλ |
nabla.u.SumColsλ |
nb.SumColsUλ |
nabla.u.SumRowsλ |
nb.SumRowsUλ |