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

Posted in Articles, ddGlobal, Puzzles | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment