Tag Archives: Func_Numeric
MaxNErr(TheRange)
MaxNErr is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This macro was originally created as I tend to use controlled errors in my formulas. As such, since I want to be able to ignore … Continue reading
SumNErr(TheRange)
SumNErr is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This macro was originally created as I tend to use controlled errors in my formulas. As such, since I want to be able to ignore … Continue reading
ddAverage(TheRange,Optional=Exclude)
ddAverage is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This function allows you to exclude specific numbers from your calculation. Assume you are given 100 accounts with a score assigned to it, but you … Continue reading
AvgNErr(TheRange)
AvgNErr is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This macro was originally created as I actually love to have controlled errors in my formulas (especially the #N/A error) as there is a hidden … Continue reading
ABSSum(TheRange)
ABSSum is a function within ddGlobal and forms part of the Func_Numeric suite of macros. ABSSum, or “absolute sum” will convert any negative number into a positive number and add that. I wrote this function over a decade ago and … Continue reading
ddGini(TheBadRange,TheGoodRange)
ddGini is a function within ddGlobal and is use to calculate the Gini-coefficient, also known as the Gini-index or the Gini-Ratio. The calculation is generally use by statisticians to measure the inequality of income levels. Scorecard developers however abuse this … Continue reading